intensitites_template_generation.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# importing all libraries needed\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Reading \"gubra_allen_map.csv\" file\n",
    "brain_gubra_map = pd.read_csv(\"brain_gubra_map.csv\", \n",
    "                               dtype={\"IDPath\": \"string\",\n",
    "                                      \"LabelAbrv\": \"string\",\n",
    "                                      \"raw\": \"string\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Creating the 'LabelID'\n",
    "brain_gubra_map['LabelID'] = brain_gubra_map['IDPath'].str.split('/').str[-2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\intri\\anaconda3\\lib\\site-packages\\pandas\\core\\frame.py:2963: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  self[k1] = value[k2]\n",
      "C:\\Users\\intri\\anaconda3\\lib\\site-packages\\ipykernel_launcher.py:4: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  after removing the cwd from sys.path.\n",
      "C:\\Users\\intri\\anaconda3\\lib\\site-packages\\ipykernel_launcher.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  \"\"\"\n",
      "C:\\Users\\intri\\anaconda3\\lib\\site-packages\\ipykernel_launcher.py:6: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  \n",
      "C:\\Users\\intri\\anaconda3\\lib\\site-packages\\ipykernel_launcher.py:7: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  import sys\n"
     ]
    },
    {
     "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>IDPath</th>\n",
       "      <th>LabelID</th>\n",
       "      <th>raw</th>\n",
       "      <th>LabelAbrv</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>/997/8/567/623/477/278/23/</td>\n",
       "      <td>23</td>\n",
       "      <td>right_Anterior_amygdalar_area</td>\n",
       "      <td>RAAA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>/997/8/567/688/695/315/31/39/935/</td>\n",
       "      <td>935</td>\n",
       "      <td>right_Anterior_cingulate_area_dorsal_part_layer_1</td>\n",
       "      <td>RACAd1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>/997/8/567/688/695/315/31/39/211/</td>\n",
       "      <td>211</td>\n",
       "      <td>right_Anterior_cingulate_area_dorsal_part_laye...</td>\n",
       "      <td>RACAd2/3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>/997/8/567/688/695/315/31/39/1015/</td>\n",
       "      <td>1015</td>\n",
       "      <td>right_Anterior_cingulate_area_dorsal_part_layer_5</td>\n",
       "      <td>RACAd5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>/997/8/567/688/695/315/31/39/919/</td>\n",
       "      <td>919</td>\n",
       "      <td>right_Anterior_cingulate_area_dorsal_part_laye...</td>\n",
       "      <td>RACAd6a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>588</th>\n",
       "      <td>/997/1009/967/933/413/</td>\n",
       "      <td>413</td>\n",
       "      <td>right_vestibular_nerve</td>\n",
       "      <td>RvVIIIn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>589</th>\n",
       "      <td>/997/8/343/1065/354/370/765/</td>\n",
       "      <td>765</td>\n",
       "      <td>right_Nucleus_x</td>\n",
       "      <td>Rx</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>590</th>\n",
       "      <td>/997/8/343/1065/354/370/773/</td>\n",
       "      <td>773</td>\n",
       "      <td>right_Hypoglossal_nucleus</td>\n",
       "      <td>RXII</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>591</th>\n",
       "      <td>/997/8/343/1065/354/370/781/</td>\n",
       "      <td>781</td>\n",
       "      <td>right_Nucleus_y</td>\n",
       "      <td>Ry</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>592</th>\n",
       "      <td>/997/8/343/1129/1097/290/797/</td>\n",
       "      <td>797</td>\n",
       "      <td>right_Zona_incerta</td>\n",
       "      <td>RZI</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>593 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 IDPath  LabelID  \\\n",
       "0            /997/8/567/623/477/278/23/       23   \n",
       "1     /997/8/567/688/695/315/31/39/935/      935   \n",
       "2     /997/8/567/688/695/315/31/39/211/      211   \n",
       "3    /997/8/567/688/695/315/31/39/1015/     1015   \n",
       "4     /997/8/567/688/695/315/31/39/919/      919   \n",
       "..                                  ...      ...   \n",
       "588              /997/1009/967/933/413/      413   \n",
       "589        /997/8/343/1065/354/370/765/      765   \n",
       "590        /997/8/343/1065/354/370/773/      773   \n",
       "591        /997/8/343/1065/354/370/781/      781   \n",
       "592       /997/8/343/1129/1097/290/797/      797   \n",
       "\n",
       "                                                   raw LabelAbrv  \n",
       "0                        right_Anterior_amygdalar_area      RAAA  \n",
       "1    right_Anterior_cingulate_area_dorsal_part_layer_1    RACAd1  \n",
       "2    right_Anterior_cingulate_area_dorsal_part_laye...  RACAd2/3  \n",
       "3    right_Anterior_cingulate_area_dorsal_part_layer_5    RACAd5  \n",
       "4    right_Anterior_cingulate_area_dorsal_part_laye...   RACAd6a  \n",
       "..                                                 ...       ...  \n",
       "588                             right_vestibular_nerve   RvVIIIn  \n",
       "589                                    right_Nucleus_x        Rx  \n",
       "590                          right_Hypoglossal_nucleus      RXII  \n",
       "591                                    right_Nucleus_y        Ry  \n",
       "592                                 right_Zona_incerta       RZI  \n",
       "\n",
       "[593 rows x 4 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Creating the right gruba intensities template\n",
    "right_gubra = brain_gubra_map[['IDPath','LabelID','raw','LabelAbrv']]\n",
    "right_gubra[['LabelID']] = right_gubra[['LabelID']].astype(int)\n",
    "right_gubra['raw'] = right_gubra['raw'].str.replace(',','',regex=True)\n",
    "right_gubra['raw'] = right_gubra['raw'].str.replace(' ','_',regex=True)\n",
    "right_gubra['raw'] = 'right_' + right_gubra['raw']\n",
    "right_gubra['LabelAbrv'] = 'R' + right_gubra['LabelAbrv']\n",
    "right_gubra"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\intri\\anaconda3\\lib\\site-packages\\pandas\\core\\frame.py:2963: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  self[k1] = value[k2]\n",
      "C:\\Users\\intri\\anaconda3\\lib\\site-packages\\ipykernel_launcher.py:4: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  after removing the cwd from sys.path.\n",
      "C:\\Users\\intri\\anaconda3\\lib\\site-packages\\ipykernel_launcher.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  \"\"\"\n",
      "C:\\Users\\intri\\anaconda3\\lib\\site-packages\\ipykernel_launcher.py:6: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  \n"
     ]
    },
    {
     "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>IDPath</th>\n",
       "      <th>LabelID</th>\n",
       "      <th>raw</th>\n",
       "      <th>LabelAbrv</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>/997/8/567/623/477/278/23/</td>\n",
       "      <td>20023</td>\n",
       "      <td>left_Anterior_amygdalar_area</td>\n",
       "      <td>LAAA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>/997/8/567/688/695/315/31/39/935/</td>\n",
       "      <td>20935</td>\n",
       "      <td>left_Anterior_cingulate_area_dorsal_part_layer_1</td>\n",
       "      <td>LACAd1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>/997/8/567/688/695/315/31/39/211/</td>\n",
       "      <td>20211</td>\n",
       "      <td>left_Anterior_cingulate_area_dorsal_part_layer...</td>\n",
       "      <td>LACAd2/3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>/997/8/567/688/695/315/31/39/1015/</td>\n",
       "      <td>21015</td>\n",
       "      <td>left_Anterior_cingulate_area_dorsal_part_layer_5</td>\n",
       "      <td>LACAd5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>/997/8/567/688/695/315/31/39/919/</td>\n",
       "      <td>20919</td>\n",
       "      <td>left_Anterior_cingulate_area_dorsal_part_layer_6a</td>\n",
       "      <td>LACAd6a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>588</th>\n",
       "      <td>/997/1009/967/933/413/</td>\n",
       "      <td>20413</td>\n",
       "      <td>left_vestibular_nerve</td>\n",
       "      <td>LvVIIIn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>589</th>\n",
       "      <td>/997/8/343/1065/354/370/765/</td>\n",
       "      <td>20765</td>\n",
       "      <td>left_Nucleus_x</td>\n",
       "      <td>Lx</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>590</th>\n",
       "      <td>/997/8/343/1065/354/370/773/</td>\n",
       "      <td>20773</td>\n",
       "      <td>left_Hypoglossal_nucleus</td>\n",
       "      <td>LXII</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>591</th>\n",
       "      <td>/997/8/343/1065/354/370/781/</td>\n",
       "      <td>20781</td>\n",
       "      <td>left_Nucleus_y</td>\n",
       "      <td>Ly</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>592</th>\n",
       "      <td>/997/8/343/1129/1097/290/797/</td>\n",
       "      <td>20797</td>\n",
       "      <td>left_Zona_incerta</td>\n",
       "      <td>LZI</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>592 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 IDPath  LabelID  \\\n",
       "0            /997/8/567/623/477/278/23/    20023   \n",
       "1     /997/8/567/688/695/315/31/39/935/    20935   \n",
       "2     /997/8/567/688/695/315/31/39/211/    20211   \n",
       "3    /997/8/567/688/695/315/31/39/1015/    21015   \n",
       "4     /997/8/567/688/695/315/31/39/919/    20919   \n",
       "..                                  ...      ...   \n",
       "588              /997/1009/967/933/413/    20413   \n",
       "589        /997/8/343/1065/354/370/765/    20765   \n",
       "590        /997/8/343/1065/354/370/773/    20773   \n",
       "591        /997/8/343/1065/354/370/781/    20781   \n",
       "592       /997/8/343/1129/1097/290/797/    20797   \n",
       "\n",
       "                                                   raw LabelAbrv  \n",
       "0                         left_Anterior_amygdalar_area      LAAA  \n",
       "1     left_Anterior_cingulate_area_dorsal_part_layer_1    LACAd1  \n",
       "2    left_Anterior_cingulate_area_dorsal_part_layer...  LACAd2/3  \n",
       "3     left_Anterior_cingulate_area_dorsal_part_layer_5    LACAd5  \n",
       "4    left_Anterior_cingulate_area_dorsal_part_layer_6a   LACAd6a  \n",
       "..                                                 ...       ...  \n",
       "588                              left_vestibular_nerve   LvVIIIn  \n",
       "589                                     left_Nucleus_x        Lx  \n",
       "590                           left_Hypoglossal_nucleus      LXII  \n",
       "591                                     left_Nucleus_y        Ly  \n",
       "592                                  left_Zona_incerta       LZI  \n",
       "\n",
       "[592 rows x 4 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Creating the left gruba intensities template\n",
    "left_gubra = brain_gubra_map[['IDPath','LabelID','raw','LabelAbrv']]\n",
    "left_gubra[['LabelID']] = left_gubra[['LabelID']].astype(int)\n",
    "left_gubra['raw'] = left_gubra['raw'].str.replace(',','',regex=True)\n",
    "left_gubra['raw'] = left_gubra['raw'].str.replace(' ','_',regex=True)\n",
    "left_gubra['raw'] = 'left_' + left_gubra['raw']\n",
    "left_gubra = left_gubra[left_gubra.LabelID != 1]\n",
    "left_gubra['LabelID'] = left_gubra['LabelID'] + 20000\n",
    "left_gubra['LabelAbrv'] = 'L' + left_gubra['LabelAbrv']\n",
    "left_gubra"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>IDPath</th>\n",
       "      <th>LabelID</th>\n",
       "      <th>raw</th>\n",
       "      <th>LabelAbrv</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>/997/8/567/623/477/278/23/</td>\n",
       "      <td>23</td>\n",
       "      <td>right_Anterior_amygdalar_area</td>\n",
       "      <td>RAAA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>/997/8/567/688/695/315/31/39/935/</td>\n",
       "      <td>935</td>\n",
       "      <td>right_Anterior_cingulate_area_dorsal_part_layer_1</td>\n",
       "      <td>RACAd1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>/997/8/567/688/695/315/31/39/211/</td>\n",
       "      <td>211</td>\n",
       "      <td>right_Anterior_cingulate_area_dorsal_part_laye...</td>\n",
       "      <td>RACAd2/3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>/997/8/567/688/695/315/31/39/1015/</td>\n",
       "      <td>1015</td>\n",
       "      <td>right_Anterior_cingulate_area_dorsal_part_layer_5</td>\n",
       "      <td>RACAd5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>/997/8/567/688/695/315/31/39/919/</td>\n",
       "      <td>919</td>\n",
       "      <td>right_Anterior_cingulate_area_dorsal_part_laye...</td>\n",
       "      <td>RACAd6a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>588</th>\n",
       "      <td>/997/1009/967/933/413/</td>\n",
       "      <td>20413</td>\n",
       "      <td>left_vestibular_nerve</td>\n",
       "      <td>LvVIIIn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>589</th>\n",
       "      <td>/997/8/343/1065/354/370/765/</td>\n",
       "      <td>20765</td>\n",
       "      <td>left_Nucleus_x</td>\n",
       "      <td>Lx</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>590</th>\n",
       "      <td>/997/8/343/1065/354/370/773/</td>\n",
       "      <td>20773</td>\n",
       "      <td>left_Hypoglossal_nucleus</td>\n",
       "      <td>LXII</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>591</th>\n",
       "      <td>/997/8/343/1065/354/370/781/</td>\n",
       "      <td>20781</td>\n",
       "      <td>left_Nucleus_y</td>\n",
       "      <td>Ly</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>592</th>\n",
       "      <td>/997/8/343/1129/1097/290/797/</td>\n",
       "      <td>20797</td>\n",
       "      <td>left_Zona_incerta</td>\n",
       "      <td>LZI</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1185 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 IDPath  LabelID  \\\n",
       "0            /997/8/567/623/477/278/23/       23   \n",
       "1     /997/8/567/688/695/315/31/39/935/      935   \n",
       "2     /997/8/567/688/695/315/31/39/211/      211   \n",
       "3    /997/8/567/688/695/315/31/39/1015/     1015   \n",
       "4     /997/8/567/688/695/315/31/39/919/      919   \n",
       "..                                  ...      ...   \n",
       "588              /997/1009/967/933/413/    20413   \n",
       "589        /997/8/343/1065/354/370/765/    20765   \n",
       "590        /997/8/343/1065/354/370/773/    20773   \n",
       "591        /997/8/343/1065/354/370/781/    20781   \n",
       "592       /997/8/343/1129/1097/290/797/    20797   \n",
       "\n",
       "                                                   raw LabelAbrv  \n",
       "0                        right_Anterior_amygdalar_area      RAAA  \n",
       "1    right_Anterior_cingulate_area_dorsal_part_layer_1    RACAd1  \n",
       "2    right_Anterior_cingulate_area_dorsal_part_laye...  RACAd2/3  \n",
       "3    right_Anterior_cingulate_area_dorsal_part_layer_5    RACAd5  \n",
       "4    right_Anterior_cingulate_area_dorsal_part_laye...   RACAd6a  \n",
       "..                                                 ...       ...  \n",
       "588                              left_vestibular_nerve   LvVIIIn  \n",
       "589                                     left_Nucleus_x        Lx  \n",
       "590                           left_Hypoglossal_nucleus      LXII  \n",
       "591                                     left_Nucleus_y        Ly  \n",
       "592                                  left_Zona_incerta       LZI  \n",
       "\n",
       "[1185 rows x 4 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gubra_intensities_template = right_gubra.append(left_gubra)\n",
    "\n",
    "gubra_intensities_template"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "gubra_intensities_template.to_csv('gubra_intensities_template.csv', index=False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}