Analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 111,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import glob\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "metadata": {},
   "outputs": [],
   "source": [
    "csv_files = glob.glob('C:/Users/ledsouza/Downloads/Dados/*.csv')\n",
    "file_dict = {}\n",
    "\n",
    "for file_path in csv_files:\n",
    "    file_name = os.path.basename(file_path)\n",
    "    key = os.path.splitext(file_name)[0]  # remove the file extension\n",
    "    file_dict[key] = file_path"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Data ID</th>\n",
       "      <th>Value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Left_Hippocampus</td>\n",
       "      <td>0.787578</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Right_Hippocampus</td>\n",
       "      <td>0.846686</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Left_Amygdala</td>\n",
       "      <td>0.910429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Right_Amygdala</td>\n",
       "      <td>0.904355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Left_Anterior_temporal_lobe_medial_part</td>\n",
       "      <td>0.705265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>Left_Superior_parietal_gyrus</td>\n",
       "      <td>0.456771</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>Right_Lingual_gyrus</td>\n",
       "      <td>0.432674</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>Left_Lingual_gyrus</td>\n",
       "      <td>0.495757</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>Right_Cuneus</td>\n",
       "      <td>0.531448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>Left_Cuneus</td>\n",
       "      <td>0.527571</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>135 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     Data ID     Value\n",
       "0                           Left_Hippocampus  0.787578\n",
       "1                          Right_Hippocampus  0.846686\n",
       "2                              Left_Amygdala  0.910429\n",
       "3                             Right_Amygdala  0.904355\n",
       "4    Left_Anterior_temporal_lobe_medial_part  0.705265\n",
       "..                                       ...       ...\n",
       "130             Left_Superior_parietal_gyrus  0.456771\n",
       "131                      Right_Lingual_gyrus  0.432674\n",
       "132                       Left_Lingual_gyrus  0.495757\n",
       "133                             Right_Cuneus  0.531448\n",
       "134                              Left_Cuneus  0.527571\n",
       "\n",
       "[135 rows x 2 columns]"
      ]
     },
     "execution_count": 113,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "key_name = 'moving.nii_0000_PET_NEURO_AC_5mm'\n",
    "df = pd.read_csv(file_dict[key_name], sep=',', skiprows=range(1, 11))\n",
    "df.rename(columns={'0000': 'Value'}, inplace=True)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Separate the left and right regions into separate columns\n",
    "df['Side'] = df['Data ID'].str.split('_').str[0]\n",
    "df['Region'] = df['Data ID'].str.split('_').str[1:].str.join('_')\n",
    "df.drop('Data ID', axis=1, inplace=True)\n",
    "df = df[~(df['Side'] == 'Brainstem')]\n",
    "df = df[~(df['Side'] == 'Corpus')]\n",
    "df = df[~(df['Side'] == 'Regional WM recovery coefficients using full mask')]\n",
    "df = df[~(df['Side'] == 'Third')]\n",
    "df_1 = df[0:64]\n",
    "df_2 = df[64:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "metadata": {},
   "outputs": [],
   "source": [
    "grouped = df_1.groupby(['Region', 'Side']).sum().reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>Side</th>\n",
       "      <th>Left</th>\n",
       "      <th>Right</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Region</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Amygdala</th>\n",
       "      <td>0.910429</td>\n",
       "      <td>0.904355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Anterior_temporal_lobe_lateral_part</th>\n",
       "      <td>0.787233</td>\n",
       "      <td>0.815216</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Anterior_temporal_lobe_medial_part</th>\n",
       "      <td>0.705265</td>\n",
       "      <td>0.769747</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Caudate_nucleus</th>\n",
       "      <td>0.686767</td>\n",
       "      <td>0.701338</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cerebellum</th>\n",
       "      <td>0.819620</td>\n",
       "      <td>0.872090</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cuneus</th>\n",
       "      <td>0.749983</td>\n",
       "      <td>0.755391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fusiform_gyrus</th>\n",
       "      <td>0.716282</td>\n",
       "      <td>0.753466</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gyrus_cinguli_anterior_part</th>\n",
       "      <td>0.974377</td>\n",
       "      <td>0.965316</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gyrus_cinguli_posterior_part</th>\n",
       "      <td>0.979231</td>\n",
       "      <td>0.885492</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gyrus_rectus</th>\n",
       "      <td>0.820925</td>\n",
       "      <td>0.747709</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hippocampus</th>\n",
       "      <td>0.787578</td>\n",
       "      <td>0.846686</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Inferior_frontal_gyrus</th>\n",
       "      <td>0.844883</td>\n",
       "      <td>0.847159</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Inferolateral_remainder_of_parietal_lobe</th>\n",
       "      <td>0.722871</td>\n",
       "      <td>0.698836</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Insula</th>\n",
       "      <td>0.914790</td>\n",
       "      <td>0.925948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lateral_remainder_of_occipital_lobe</th>\n",
       "      <td>0.749302</td>\n",
       "      <td>0.768427</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lateral_ventricle_excluding_temporal_horn</th>\n",
       "      <td>0.492711</td>\n",
       "      <td>0.466216</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lateral_ventricle_temporal_horn</th>\n",
       "      <td>0.843382</td>\n",
       "      <td>0.561993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lingual_gyrus</th>\n",
       "      <td>0.861933</td>\n",
       "      <td>0.804420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Middle_and_inferior_temporal_gyri</th>\n",
       "      <td>0.764921</td>\n",
       "      <td>0.796092</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Middle_frontal_gyrus</th>\n",
       "      <td>0.794485</td>\n",
       "      <td>0.785866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nucleus_accumbens</th>\n",
       "      <td>0.826236</td>\n",
       "      <td>0.816248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Orbitofrontal_gyri</th>\n",
       "      <td>0.758134</td>\n",
       "      <td>0.776339</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pallidum</th>\n",
       "      <td>0.899165</td>\n",
       "      <td>0.867488</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Parahippocampal_and_ambient_gyri</th>\n",
       "      <td>0.676009</td>\n",
       "      <td>0.715564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Postcentral_gyrus</th>\n",
       "      <td>0.696411</td>\n",
       "      <td>0.690426</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Posterior_temporal_lobe</th>\n",
       "      <td>0.807394</td>\n",
       "      <td>0.834631</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Precentral_gyrus</th>\n",
       "      <td>0.756689</td>\n",
       "      <td>0.749475</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Putamen</th>\n",
       "      <td>0.885384</td>\n",
       "      <td>0.878109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Superior_frontal_gyrus</th>\n",
       "      <td>0.807516</td>\n",
       "      <td>0.831606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Superior_parietal_gyrus</th>\n",
       "      <td>0.698732</td>\n",
       "      <td>0.691552</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Superior_temporal_gyrus</th>\n",
       "      <td>0.800232</td>\n",
       "      <td>0.839304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thalamus</th>\n",
       "      <td>0.857182</td>\n",
       "      <td>0.860478</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Side                                           Left     Right\n",
       "Region                                                       \n",
       "Amygdala                                   0.910429  0.904355\n",
       "Anterior_temporal_lobe_lateral_part        0.787233  0.815216\n",
       "Anterior_temporal_lobe_medial_part         0.705265  0.769747\n",
       "Caudate_nucleus                            0.686767  0.701338\n",
       "Cerebellum                                 0.819620  0.872090\n",
       "Cuneus                                     0.749983  0.755391\n",
       "Fusiform_gyrus                             0.716282  0.753466\n",
       "Gyrus_cinguli_anterior_part                0.974377  0.965316\n",
       "Gyrus_cinguli_posterior_part               0.979231  0.885492\n",
       "Gyrus_rectus                               0.820925  0.747709\n",
       "Hippocampus                                0.787578  0.846686\n",
       "Inferior_frontal_gyrus                     0.844883  0.847159\n",
       "Inferolateral_remainder_of_parietal_lobe   0.722871  0.698836\n",
       "Insula                                     0.914790  0.925948\n",
       "Lateral_remainder_of_occipital_lobe        0.749302  0.768427\n",
       "Lateral_ventricle_excluding_temporal_horn  0.492711  0.466216\n",
       "Lateral_ventricle_temporal_horn            0.843382  0.561993\n",
       "Lingual_gyrus                              0.861933  0.804420\n",
       "Middle_and_inferior_temporal_gyri          0.764921  0.796092\n",
       "Middle_frontal_gyrus                       0.794485  0.785866\n",
       "Nucleus_accumbens                          0.826236  0.816248\n",
       "Orbitofrontal_gyri                         0.758134  0.776339\n",
       "Pallidum                                   0.899165  0.867488\n",
       "Parahippocampal_and_ambient_gyri           0.676009  0.715564\n",
       "Postcentral_gyrus                          0.696411  0.690426\n",
       "Posterior_temporal_lobe                    0.807394  0.834631\n",
       "Precentral_gyrus                           0.756689  0.749475\n",
       "Putamen                                    0.885384  0.878109\n",
       "Superior_frontal_gyrus                     0.807516  0.831606\n",
       "Superior_parietal_gyrus                    0.698732  0.691552\n",
       "Superior_temporal_gyrus                    0.800232  0.839304\n",
       "Thalamus                                   0.857182  0.860478"
      ]
     },
     "execution_count": 116,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pivoted_1 = grouped.pivot(index='Region', columns='Side', values='Value')\n",
    "pivoted_1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>Side</th>\n",
       "      <th>Left</th>\n",
       "      <th>Right</th>\n",
       "      <th>Ratio</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Region</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Amygdala</th>\n",
       "      <td>0.910429</td>\n",
       "      <td>0.904355</td>\n",
       "      <td>1.006716</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Anterior_temporal_lobe_lateral_part</th>\n",
       "      <td>0.787233</td>\n",
       "      <td>0.815216</td>\n",
       "      <td>0.965674</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Anterior_temporal_lobe_medial_part</th>\n",
       "      <td>0.705265</td>\n",
       "      <td>0.769747</td>\n",
       "      <td>0.916230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Caudate_nucleus</th>\n",
       "      <td>0.686767</td>\n",
       "      <td>0.701338</td>\n",
       "      <td>0.979224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cerebellum</th>\n",
       "      <td>0.819620</td>\n",
       "      <td>0.872090</td>\n",
       "      <td>0.939834</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cuneus</th>\n",
       "      <td>0.749983</td>\n",
       "      <td>0.755391</td>\n",
       "      <td>0.992841</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fusiform_gyrus</th>\n",
       "      <td>0.716282</td>\n",
       "      <td>0.753466</td>\n",
       "      <td>0.950649</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gyrus_cinguli_anterior_part</th>\n",
       "      <td>0.974377</td>\n",
       "      <td>0.965316</td>\n",
       "      <td>1.009387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gyrus_cinguli_posterior_part</th>\n",
       "      <td>0.979231</td>\n",
       "      <td>0.885492</td>\n",
       "      <td>1.105861</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gyrus_rectus</th>\n",
       "      <td>0.820925</td>\n",
       "      <td>0.747709</td>\n",
       "      <td>1.097920</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hippocampus</th>\n",
       "      <td>0.787578</td>\n",
       "      <td>0.846686</td>\n",
       "      <td>0.930189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Inferior_frontal_gyrus</th>\n",
       "      <td>0.844883</td>\n",
       "      <td>0.847159</td>\n",
       "      <td>0.997313</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Inferolateral_remainder_of_parietal_lobe</th>\n",
       "      <td>0.722871</td>\n",
       "      <td>0.698836</td>\n",
       "      <td>1.034393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Insula</th>\n",
       "      <td>0.914790</td>\n",
       "      <td>0.925948</td>\n",
       "      <td>0.987950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lateral_remainder_of_occipital_lobe</th>\n",
       "      <td>0.749302</td>\n",
       "      <td>0.768427</td>\n",
       "      <td>0.975111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lateral_ventricle_excluding_temporal_horn</th>\n",
       "      <td>0.492711</td>\n",
       "      <td>0.466216</td>\n",
       "      <td>1.056830</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lateral_ventricle_temporal_horn</th>\n",
       "      <td>0.843382</td>\n",
       "      <td>0.561993</td>\n",
       "      <td>1.500698</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lingual_gyrus</th>\n",
       "      <td>0.861933</td>\n",
       "      <td>0.804420</td>\n",
       "      <td>1.071496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Middle_and_inferior_temporal_gyri</th>\n",
       "      <td>0.764921</td>\n",
       "      <td>0.796092</td>\n",
       "      <td>0.960845</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Middle_frontal_gyrus</th>\n",
       "      <td>0.794485</td>\n",
       "      <td>0.785866</td>\n",
       "      <td>1.010968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nucleus_accumbens</th>\n",
       "      <td>0.826236</td>\n",
       "      <td>0.816248</td>\n",
       "      <td>1.012236</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Orbitofrontal_gyri</th>\n",
       "      <td>0.758134</td>\n",
       "      <td>0.776339</td>\n",
       "      <td>0.976550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pallidum</th>\n",
       "      <td>0.899165</td>\n",
       "      <td>0.867488</td>\n",
       "      <td>1.036516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Parahippocampal_and_ambient_gyri</th>\n",
       "      <td>0.676009</td>\n",
       "      <td>0.715564</td>\n",
       "      <td>0.944722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Postcentral_gyrus</th>\n",
       "      <td>0.696411</td>\n",
       "      <td>0.690426</td>\n",
       "      <td>1.008669</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Posterior_temporal_lobe</th>\n",
       "      <td>0.807394</td>\n",
       "      <td>0.834631</td>\n",
       "      <td>0.967366</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Precentral_gyrus</th>\n",
       "      <td>0.756689</td>\n",
       "      <td>0.749475</td>\n",
       "      <td>1.009625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Putamen</th>\n",
       "      <td>0.885384</td>\n",
       "      <td>0.878109</td>\n",
       "      <td>1.008285</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Superior_frontal_gyrus</th>\n",
       "      <td>0.807516</td>\n",
       "      <td>0.831606</td>\n",
       "      <td>0.971032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Superior_parietal_gyrus</th>\n",
       "      <td>0.698732</td>\n",
       "      <td>0.691552</td>\n",
       "      <td>1.010382</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Superior_temporal_gyrus</th>\n",
       "      <td>0.800232</td>\n",
       "      <td>0.839304</td>\n",
       "      <td>0.953447</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thalamus</th>\n",
       "      <td>0.857182</td>\n",
       "      <td>0.860478</td>\n",
       "      <td>0.996170</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Side                                           Left     Right     Ratio\n",
       "Region                                                                 \n",
       "Amygdala                                   0.910429  0.904355  1.006716\n",
       "Anterior_temporal_lobe_lateral_part        0.787233  0.815216  0.965674\n",
       "Anterior_temporal_lobe_medial_part         0.705265  0.769747  0.916230\n",
       "Caudate_nucleus                            0.686767  0.701338  0.979224\n",
       "Cerebellum                                 0.819620  0.872090  0.939834\n",
       "Cuneus                                     0.749983  0.755391  0.992841\n",
       "Fusiform_gyrus                             0.716282  0.753466  0.950649\n",
       "Gyrus_cinguli_anterior_part                0.974377  0.965316  1.009387\n",
       "Gyrus_cinguli_posterior_part               0.979231  0.885492  1.105861\n",
       "Gyrus_rectus                               0.820925  0.747709  1.097920\n",
       "Hippocampus                                0.787578  0.846686  0.930189\n",
       "Inferior_frontal_gyrus                     0.844883  0.847159  0.997313\n",
       "Inferolateral_remainder_of_parietal_lobe   0.722871  0.698836  1.034393\n",
       "Insula                                     0.914790  0.925948  0.987950\n",
       "Lateral_remainder_of_occipital_lobe        0.749302  0.768427  0.975111\n",
       "Lateral_ventricle_excluding_temporal_horn  0.492711  0.466216  1.056830\n",
       "Lateral_ventricle_temporal_horn            0.843382  0.561993  1.500698\n",
       "Lingual_gyrus                              0.861933  0.804420  1.071496\n",
       "Middle_and_inferior_temporal_gyri          0.764921  0.796092  0.960845\n",
       "Middle_frontal_gyrus                       0.794485  0.785866  1.010968\n",
       "Nucleus_accumbens                          0.826236  0.816248  1.012236\n",
       "Orbitofrontal_gyri                         0.758134  0.776339  0.976550\n",
       "Pallidum                                   0.899165  0.867488  1.036516\n",
       "Parahippocampal_and_ambient_gyri           0.676009  0.715564  0.944722\n",
       "Postcentral_gyrus                          0.696411  0.690426  1.008669\n",
       "Posterior_temporal_lobe                    0.807394  0.834631  0.967366\n",
       "Precentral_gyrus                           0.756689  0.749475  1.009625\n",
       "Putamen                                    0.885384  0.878109  1.008285\n",
       "Superior_frontal_gyrus                     0.807516  0.831606  0.971032\n",
       "Superior_parietal_gyrus                    0.698732  0.691552  1.010382\n",
       "Superior_temporal_gyrus                    0.800232  0.839304  0.953447\n",
       "Thalamus                                   0.857182  0.860478  0.996170"
      ]
     },
     "execution_count": 117,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pivoted_1['Ratio'] = pivoted_1['Left'] / pivoted_1['Right']\n",
    "pivoted_1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "metadata": {},
   "outputs": [],
   "source": [
    "grouped = df_2.groupby(['Region', 'Side']).sum().reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>Side</th>\n",
       "      <th>Left</th>\n",
       "      <th>Right</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Region</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Amygdala</th>\n",
       "      <td>0.473302</td>\n",
       "      <td>0.452279</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Anterior_temporal_lobe_lateral_part</th>\n",
       "      <td>0.653387</td>\n",
       "      <td>0.610343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Anterior_temporal_lobe_medial_part</th>\n",
       "      <td>0.547660</td>\n",
       "      <td>0.494751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Caudate_nucleus</th>\n",
       "      <td>0.374158</td>\n",
       "      <td>0.404520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cerebellum</th>\n",
       "      <td>0.512411</td>\n",
       "      <td>0.503316</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cuneus</th>\n",
       "      <td>0.527571</td>\n",
       "      <td>0.531448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fusiform_gyrus</th>\n",
       "      <td>0.437621</td>\n",
       "      <td>0.524782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gyrus_cinguli_anterior_part</th>\n",
       "      <td>0.675657</td>\n",
       "      <td>0.626611</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gyrus_cinguli_posterior_part</th>\n",
       "      <td>0.716067</td>\n",
       "      <td>0.598464</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gyrus_rectus</th>\n",
       "      <td>0.440097</td>\n",
       "      <td>0.393910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hippocampus</th>\n",
       "      <td>0.460567</td>\n",
       "      <td>0.493377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Inferior_frontal_gyrus</th>\n",
       "      <td>0.539434</td>\n",
       "      <td>0.592499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Inferolateral_remainder_of_parietal_lobe</th>\n",
       "      <td>0.466382</td>\n",
       "      <td>0.467464</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Insula</th>\n",
       "      <td>0.496952</td>\n",
       "      <td>0.498887</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lateral_remainder_of_occipital_lobe</th>\n",
       "      <td>0.457023</td>\n",
       "      <td>0.499430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lateral_ventricle_excluding_temporal_horn</th>\n",
       "      <td>0.198018</td>\n",
       "      <td>0.236990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lateral_ventricle_temporal_horn</th>\n",
       "      <td>0.517264</td>\n",
       "      <td>0.420620</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lingual_gyrus</th>\n",
       "      <td>0.495757</td>\n",
       "      <td>0.432674</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Middle_and_inferior_temporal_gyri</th>\n",
       "      <td>0.487681</td>\n",
       "      <td>0.536241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Middle_frontal_gyrus</th>\n",
       "      <td>0.425777</td>\n",
       "      <td>0.432275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nucleus_accumbens</th>\n",
       "      <td>0.416288</td>\n",
       "      <td>0.494104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Orbitofrontal_gyri</th>\n",
       "      <td>0.450743</td>\n",
       "      <td>0.473839</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pallidum</th>\n",
       "      <td>0.457287</td>\n",
       "      <td>0.445499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Parahippocampal_and_ambient_gyri</th>\n",
       "      <td>0.352639</td>\n",
       "      <td>0.423409</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Postcentral_gyrus</th>\n",
       "      <td>0.450907</td>\n",
       "      <td>0.445548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Posterior_temporal_lobe</th>\n",
       "      <td>0.409225</td>\n",
       "      <td>0.419707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Precentral_gyrus</th>\n",
       "      <td>0.490877</td>\n",
       "      <td>0.465634</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Putamen</th>\n",
       "      <td>0.667685</td>\n",
       "      <td>0.635343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Superior_frontal_gyrus</th>\n",
       "      <td>0.485956</td>\n",
       "      <td>0.474545</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Superior_parietal_gyrus</th>\n",
       "      <td>0.456771</td>\n",
       "      <td>0.462511</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Superior_temporal_gyrus</th>\n",
       "      <td>0.524790</td>\n",
       "      <td>0.535253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thalamus</th>\n",
       "      <td>0.356110</td>\n",
       "      <td>0.380705</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Side                                           Left     Right\n",
       "Region                                                       \n",
       "Amygdala                                   0.473302  0.452279\n",
       "Anterior_temporal_lobe_lateral_part        0.653387  0.610343\n",
       "Anterior_temporal_lobe_medial_part         0.547660  0.494751\n",
       "Caudate_nucleus                            0.374158  0.404520\n",
       "Cerebellum                                 0.512411  0.503316\n",
       "Cuneus                                     0.527571  0.531448\n",
       "Fusiform_gyrus                             0.437621  0.524782\n",
       "Gyrus_cinguli_anterior_part                0.675657  0.626611\n",
       "Gyrus_cinguli_posterior_part               0.716067  0.598464\n",
       "Gyrus_rectus                               0.440097  0.393910\n",
       "Hippocampus                                0.460567  0.493377\n",
       "Inferior_frontal_gyrus                     0.539434  0.592499\n",
       "Inferolateral_remainder_of_parietal_lobe   0.466382  0.467464\n",
       "Insula                                     0.496952  0.498887\n",
       "Lateral_remainder_of_occipital_lobe        0.457023  0.499430\n",
       "Lateral_ventricle_excluding_temporal_horn  0.198018  0.236990\n",
       "Lateral_ventricle_temporal_horn            0.517264  0.420620\n",
       "Lingual_gyrus                              0.495757  0.432674\n",
       "Middle_and_inferior_temporal_gyri          0.487681  0.536241\n",
       "Middle_frontal_gyrus                       0.425777  0.432275\n",
       "Nucleus_accumbens                          0.416288  0.494104\n",
       "Orbitofrontal_gyri                         0.450743  0.473839\n",
       "Pallidum                                   0.457287  0.445499\n",
       "Parahippocampal_and_ambient_gyri           0.352639  0.423409\n",
       "Postcentral_gyrus                          0.450907  0.445548\n",
       "Posterior_temporal_lobe                    0.409225  0.419707\n",
       "Precentral_gyrus                           0.490877  0.465634\n",
       "Putamen                                    0.667685  0.635343\n",
       "Superior_frontal_gyrus                     0.485956  0.474545\n",
       "Superior_parietal_gyrus                    0.456771  0.462511\n",
       "Superior_temporal_gyrus                    0.524790  0.535253\n",
       "Thalamus                                   0.356110  0.380705"
      ]
     },
     "execution_count": 119,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pivoted_2 = grouped.pivot(index='Region', columns='Side', values='Value')\n",
    "pivoted_2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>Side</th>\n",
       "      <th>Left</th>\n",
       "      <th>Right</th>\n",
       "      <th>Ratio</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Region</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Amygdala</th>\n",
       "      <td>0.473302</td>\n",
       "      <td>0.452279</td>\n",
       "      <td>1.046482</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Anterior_temporal_lobe_lateral_part</th>\n",
       "      <td>0.653387</td>\n",
       "      <td>0.610343</td>\n",
       "      <td>1.070524</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Anterior_temporal_lobe_medial_part</th>\n",
       "      <td>0.547660</td>\n",
       "      <td>0.494751</td>\n",
       "      <td>1.106941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Caudate_nucleus</th>\n",
       "      <td>0.374158</td>\n",
       "      <td>0.404520</td>\n",
       "      <td>0.924943</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cerebellum</th>\n",
       "      <td>0.512411</td>\n",
       "      <td>0.503316</td>\n",
       "      <td>1.018070</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cuneus</th>\n",
       "      <td>0.527571</td>\n",
       "      <td>0.531448</td>\n",
       "      <td>0.992705</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fusiform_gyrus</th>\n",
       "      <td>0.437621</td>\n",
       "      <td>0.524782</td>\n",
       "      <td>0.833910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gyrus_cinguli_anterior_part</th>\n",
       "      <td>0.675657</td>\n",
       "      <td>0.626611</td>\n",
       "      <td>1.078272</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gyrus_cinguli_posterior_part</th>\n",
       "      <td>0.716067</td>\n",
       "      <td>0.598464</td>\n",
       "      <td>1.196508</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gyrus_rectus</th>\n",
       "      <td>0.440097</td>\n",
       "      <td>0.393910</td>\n",
       "      <td>1.117253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hippocampus</th>\n",
       "      <td>0.460567</td>\n",
       "      <td>0.493377</td>\n",
       "      <td>0.933499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Inferior_frontal_gyrus</th>\n",
       "      <td>0.539434</td>\n",
       "      <td>0.592499</td>\n",
       "      <td>0.910439</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Inferolateral_remainder_of_parietal_lobe</th>\n",
       "      <td>0.466382</td>\n",
       "      <td>0.467464</td>\n",
       "      <td>0.997685</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Insula</th>\n",
       "      <td>0.496952</td>\n",
       "      <td>0.498887</td>\n",
       "      <td>0.996121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lateral_remainder_of_occipital_lobe</th>\n",
       "      <td>0.457023</td>\n",
       "      <td>0.499430</td>\n",
       "      <td>0.915089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lateral_ventricle_excluding_temporal_horn</th>\n",
       "      <td>0.198018</td>\n",
       "      <td>0.236990</td>\n",
       "      <td>0.835554</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lateral_ventricle_temporal_horn</th>\n",
       "      <td>0.517264</td>\n",
       "      <td>0.420620</td>\n",
       "      <td>1.229766</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lingual_gyrus</th>\n",
       "      <td>0.495757</td>\n",
       "      <td>0.432674</td>\n",
       "      <td>1.145798</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Middle_and_inferior_temporal_gyri</th>\n",
       "      <td>0.487681</td>\n",
       "      <td>0.536241</td>\n",
       "      <td>0.909444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Middle_frontal_gyrus</th>\n",
       "      <td>0.425777</td>\n",
       "      <td>0.432275</td>\n",
       "      <td>0.984968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nucleus_accumbens</th>\n",
       "      <td>0.416288</td>\n",
       "      <td>0.494104</td>\n",
       "      <td>0.842511</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Orbitofrontal_gyri</th>\n",
       "      <td>0.450743</td>\n",
       "      <td>0.473839</td>\n",
       "      <td>0.951258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pallidum</th>\n",
       "      <td>0.457287</td>\n",
       "      <td>0.445499</td>\n",
       "      <td>1.026460</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Parahippocampal_and_ambient_gyri</th>\n",
       "      <td>0.352639</td>\n",
       "      <td>0.423409</td>\n",
       "      <td>0.832857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Postcentral_gyrus</th>\n",
       "      <td>0.450907</td>\n",
       "      <td>0.445548</td>\n",
       "      <td>1.012028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Posterior_temporal_lobe</th>\n",
       "      <td>0.409225</td>\n",
       "      <td>0.419707</td>\n",
       "      <td>0.975025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Precentral_gyrus</th>\n",
       "      <td>0.490877</td>\n",
       "      <td>0.465634</td>\n",
       "      <td>1.054212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Putamen</th>\n",
       "      <td>0.667685</td>\n",
       "      <td>0.635343</td>\n",
       "      <td>1.050905</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Superior_frontal_gyrus</th>\n",
       "      <td>0.485956</td>\n",
       "      <td>0.474545</td>\n",
       "      <td>1.024046</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Superior_parietal_gyrus</th>\n",
       "      <td>0.456771</td>\n",
       "      <td>0.462511</td>\n",
       "      <td>0.987589</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Superior_temporal_gyrus</th>\n",
       "      <td>0.524790</td>\n",
       "      <td>0.535253</td>\n",
       "      <td>0.980452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thalamus</th>\n",
       "      <td>0.356110</td>\n",
       "      <td>0.380705</td>\n",
       "      <td>0.935396</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Side                                           Left     Right     Ratio\n",
       "Region                                                                 \n",
       "Amygdala                                   0.473302  0.452279  1.046482\n",
       "Anterior_temporal_lobe_lateral_part        0.653387  0.610343  1.070524\n",
       "Anterior_temporal_lobe_medial_part         0.547660  0.494751  1.106941\n",
       "Caudate_nucleus                            0.374158  0.404520  0.924943\n",
       "Cerebellum                                 0.512411  0.503316  1.018070\n",
       "Cuneus                                     0.527571  0.531448  0.992705\n",
       "Fusiform_gyrus                             0.437621  0.524782  0.833910\n",
       "Gyrus_cinguli_anterior_part                0.675657  0.626611  1.078272\n",
       "Gyrus_cinguli_posterior_part               0.716067  0.598464  1.196508\n",
       "Gyrus_rectus                               0.440097  0.393910  1.117253\n",
       "Hippocampus                                0.460567  0.493377  0.933499\n",
       "Inferior_frontal_gyrus                     0.539434  0.592499  0.910439\n",
       "Inferolateral_remainder_of_parietal_lobe   0.466382  0.467464  0.997685\n",
       "Insula                                     0.496952  0.498887  0.996121\n",
       "Lateral_remainder_of_occipital_lobe        0.457023  0.499430  0.915089\n",
       "Lateral_ventricle_excluding_temporal_horn  0.198018  0.236990  0.835554\n",
       "Lateral_ventricle_temporal_horn            0.517264  0.420620  1.229766\n",
       "Lingual_gyrus                              0.495757  0.432674  1.145798\n",
       "Middle_and_inferior_temporal_gyri          0.487681  0.536241  0.909444\n",
       "Middle_frontal_gyrus                       0.425777  0.432275  0.984968\n",
       "Nucleus_accumbens                          0.416288  0.494104  0.842511\n",
       "Orbitofrontal_gyri                         0.450743  0.473839  0.951258\n",
       "Pallidum                                   0.457287  0.445499  1.026460\n",
       "Parahippocampal_and_ambient_gyri           0.352639  0.423409  0.832857\n",
       "Postcentral_gyrus                          0.450907  0.445548  1.012028\n",
       "Posterior_temporal_lobe                    0.409225  0.419707  0.975025\n",
       "Precentral_gyrus                           0.490877  0.465634  1.054212\n",
       "Putamen                                    0.667685  0.635343  1.050905\n",
       "Superior_frontal_gyrus                     0.485956  0.474545  1.024046\n",
       "Superior_parietal_gyrus                    0.456771  0.462511  0.987589\n",
       "Superior_temporal_gyrus                    0.524790  0.535253  0.980452\n",
       "Thalamus                                   0.356110  0.380705  0.935396"
      ]
     },
     "execution_count": 120,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pivoted_2['Ratio'] = pivoted_2['Left'] / pivoted_2['Right']\n",
    "pivoted_2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 121,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>Side</th>\n",
       "      <th>Left</th>\n",
       "      <th>Right</th>\n",
       "      <th>Ratio</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Region</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Amygdala</th>\n",
       "      <td>0.910429</td>\n",
       "      <td>0.904355</td>\n",
       "      <td>1.006716</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Anterior_temporal_lobe_lateral_part</th>\n",
       "      <td>0.787233</td>\n",
       "      <td>0.815216</td>\n",
       "      <td>0.965674</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Anterior_temporal_lobe_medial_part</th>\n",
       "      <td>0.705265</td>\n",
       "      <td>0.769747</td>\n",
       "      <td>0.916230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Caudate_nucleus</th>\n",
       "      <td>0.686767</td>\n",
       "      <td>0.701338</td>\n",
       "      <td>0.979224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cerebellum</th>\n",
       "      <td>0.819620</td>\n",
       "      <td>0.872090</td>\n",
       "      <td>0.939834</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Putamen</th>\n",
       "      <td>0.667685</td>\n",
       "      <td>0.635343</td>\n",
       "      <td>1.050905</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Superior_frontal_gyrus</th>\n",
       "      <td>0.485956</td>\n",
       "      <td>0.474545</td>\n",
       "      <td>1.024046</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Superior_parietal_gyrus</th>\n",
       "      <td>0.456771</td>\n",
       "      <td>0.462511</td>\n",
       "      <td>0.987589</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Superior_temporal_gyrus</th>\n",
       "      <td>0.524790</td>\n",
       "      <td>0.535253</td>\n",
       "      <td>0.980452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thalamus</th>\n",
       "      <td>0.356110</td>\n",
       "      <td>0.380705</td>\n",
       "      <td>0.935396</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>64 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Side                                     Left     Right     Ratio\n",
       "Region                                                           \n",
       "Amygdala                             0.910429  0.904355  1.006716\n",
       "Anterior_temporal_lobe_lateral_part  0.787233  0.815216  0.965674\n",
       "Anterior_temporal_lobe_medial_part   0.705265  0.769747  0.916230\n",
       "Caudate_nucleus                      0.686767  0.701338  0.979224\n",
       "Cerebellum                           0.819620  0.872090  0.939834\n",
       "...                                       ...       ...       ...\n",
       "Putamen                              0.667685  0.635343  1.050905\n",
       "Superior_frontal_gyrus               0.485956  0.474545  1.024046\n",
       "Superior_parietal_gyrus              0.456771  0.462511  0.987589\n",
       "Superior_temporal_gyrus              0.524790  0.535253  0.980452\n",
       "Thalamus                             0.356110  0.380705  0.935396\n",
       "\n",
       "[64 rows x 3 columns]"
      ]
     },
     "execution_count": 121,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "concatenated_df = pd.concat([pivoted_1, pivoted_2])\n",
    "concatenated_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 122,
   "metadata": {},
   "outputs": [],
   "source": [
    "concatenated_df.to_csv('C:/Users/ledsouza/Documents/Python Scripts/Hoffman_EANM/EANM_Analysis/Results/' + key_name + '.csv', index=True)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.9"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}