pre_preprocess_analysis.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Data wrangling"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:05.309828Z",
     "start_time": "2020-06-08T00:40:04.243467Z"
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import glob\n",
    "import preprocessing as pre\n",
    "import seaborn as sn\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "First we need to extract data from the excel file. In order to construct the eventual for loop, we'll first need to try extracting data from one file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:05.318959Z",
     "start_time": "2020-06-08T00:40:05.311392Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'/home/bea/bhs2020/Projet_BHS2020/SNF_ADHDsubtypes_project'"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pwd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:42.899307Z",
     "start_time": "2020-06-08T00:40:05.321017Z"
    }
   },
   "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>electrode</th>\n",
       "      <th>brain_oscillation</th>\n",
       "      <th>fft_abs_power</th>\n",
       "      <th>freq_band</th>\n",
       "      <th>id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>FP1</td>\n",
       "      <td>Delta</td>\n",
       "      <td>15.565495</td>\n",
       "      <td>1.0-4.0Hz</td>\n",
       "      <td>134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>FP2</td>\n",
       "      <td>Delta</td>\n",
       "      <td>13.945462</td>\n",
       "      <td>1.0-4.0Hz</td>\n",
       "      <td>134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>F7</td>\n",
       "      <td>Delta</td>\n",
       "      <td>10.874886</td>\n",
       "      <td>1.0-4.0Hz</td>\n",
       "      <td>134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>F3</td>\n",
       "      <td>Delta</td>\n",
       "      <td>13.581803</td>\n",
       "      <td>1.0-4.0Hz</td>\n",
       "      <td>134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Fz</td>\n",
       "      <td>Delta</td>\n",
       "      <td>15.644595</td>\n",
       "      <td>1.0-4.0Hz</td>\n",
       "      <td>134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21104</th>\n",
       "      <td>Pz</td>\n",
       "      <td>Beta2</td>\n",
       "      <td>1.224356</td>\n",
       "      <td>15.0-18.0Hz</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21105</th>\n",
       "      <td>P4</td>\n",
       "      <td>Beta2</td>\n",
       "      <td>1.139701</td>\n",
       "      <td>15.0-18.0Hz</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21106</th>\n",
       "      <td>T6</td>\n",
       "      <td>Beta2</td>\n",
       "      <td>1.157928</td>\n",
       "      <td>15.0-18.0Hz</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21107</th>\n",
       "      <td>O1</td>\n",
       "      <td>Beta2</td>\n",
       "      <td>2.315535</td>\n",
       "      <td>15.0-18.0Hz</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21108</th>\n",
       "      <td>O2</td>\n",
       "      <td>Beta2</td>\n",
       "      <td>1.199553</td>\n",
       "      <td>15.0-18.0Hz</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>21109 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      electrode brain_oscillation fft_abs_power    freq_band   id\n",
       "0           FP1             Delta     15.565495    1.0-4.0Hz  134\n",
       "1           FP2             Delta     13.945462    1.0-4.0Hz  134\n",
       "2            F7             Delta     10.874886    1.0-4.0Hz  134\n",
       "3            F3             Delta     13.581803    1.0-4.0Hz  134\n",
       "4            Fz             Delta     15.644595    1.0-4.0Hz  134\n",
       "...         ...               ...           ...          ...  ...\n",
       "21104        Pz             Beta2      1.224356  15.0-18.0Hz   87\n",
       "21105        P4             Beta2      1.139701  15.0-18.0Hz   87\n",
       "21106        T6             Beta2      1.157928  15.0-18.0Hz   87\n",
       "21107        O1             Beta2      2.315535  15.0-18.0Hz   87\n",
       "21108        O2             Beta2      1.199553  15.0-18.0Hz   87\n",
       "\n",
       "[21109 rows x 5 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_eeg = pre.process_all_excel_files()\n",
    "df_eeg"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Reorder columns of df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:42.906307Z",
     "start_time": "2020-06-08T00:40:42.900940Z"
    }
   },
   "outputs": [],
   "source": [
    "df_eeg = df_eeg[['id', 'brain_oscillation','freq_band','electrode','fft_abs_power']]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Remove participants (10,18, 52, 215 and 617) because of missing Neuropsy data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:42.925355Z",
     "start_time": "2020-06-08T00:40:42.907956Z"
    }
   },
   "outputs": [],
   "source": [
    "df_eeg = df_eeg[(df_eeg.id != '10') & (df_eeg.id != '18') & (df_eeg.id != '52') & (df_eeg.id != '215') & (df_eeg.id != '617')]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Verify data wrangling"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:42.939056Z",
     "start_time": "2020-06-08T00:40:42.927370Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(20064, 5)\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>id</th>\n",
       "      <th>brain_oscillation</th>\n",
       "      <th>freq_band</th>\n",
       "      <th>electrode</th>\n",
       "      <th>fft_abs_power</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>134</td>\n",
       "      <td>Delta</td>\n",
       "      <td>1.0-4.0Hz</td>\n",
       "      <td>FP1</td>\n",
       "      <td>15.565495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>134</td>\n",
       "      <td>Delta</td>\n",
       "      <td>1.0-4.0Hz</td>\n",
       "      <td>FP2</td>\n",
       "      <td>13.945462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>134</td>\n",
       "      <td>Delta</td>\n",
       "      <td>1.0-4.0Hz</td>\n",
       "      <td>F7</td>\n",
       "      <td>10.874886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>134</td>\n",
       "      <td>Delta</td>\n",
       "      <td>1.0-4.0Hz</td>\n",
       "      <td>F3</td>\n",
       "      <td>13.581803</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>134</td>\n",
       "      <td>Delta</td>\n",
       "      <td>1.0-4.0Hz</td>\n",
       "      <td>Fz</td>\n",
       "      <td>15.644595</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    id brain_oscillation  freq_band electrode fft_abs_power\n",
       "0  134             Delta  1.0-4.0Hz       FP1     15.565495\n",
       "1  134             Delta  1.0-4.0Hz       FP2     13.945462\n",
       "2  134             Delta  1.0-4.0Hz        F7     10.874886\n",
       "3  134             Delta  1.0-4.0Hz        F3     13.581803\n",
       "4  134             Delta  1.0-4.0Hz        Fz     15.644595"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print(df_eeg.shape)\n",
    "df_eeg.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:42.956310Z",
     "start_time": "2020-06-08T00:40:42.941115Z"
    }
   },
   "outputs": [],
   "source": [
    "#sort by ids\n",
    "df_eeg = df_eeg.sort_values(by=['id'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:42.967296Z",
     "start_time": "2020-06-08T00:40:42.959722Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "id                   object\n",
       "brain_oscillation    object\n",
       "freq_band            object\n",
       "electrode            object\n",
       "fft_abs_power        object\n",
       "dtype: object"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_eeg.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:42.978009Z",
     "start_time": "2020-06-08T00:40:42.969545Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "# unique ids: 96\n",
      "103    209\n",
      "701    209\n",
      "13     209\n",
      "17     209\n",
      "23     209\n",
      "      ... \n",
      "31     209\n",
      "12     209\n",
      "212    209\n",
      "42     209\n",
      "73     209\n",
      "Name: id, Length: 96, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "print('# unique ids: {}'.format(len(df_eeg.id.unique())))\n",
    "print(df_eeg.id.value_counts())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:42.999813Z",
     "start_time": "2020-06-08T00:40:42.979590Z"
    },
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "O2     1056\n",
      "O1     1056\n",
      "F8     1056\n",
      "Pz     1056\n",
      "P4     1056\n",
      "F3     1056\n",
      "FP1    1056\n",
      "C3     1056\n",
      "T3     1056\n",
      "P3     1056\n",
      "C4     1056\n",
      "F7     1056\n",
      "FP2    1056\n",
      "Cz     1056\n",
      "F4     1056\n",
      "T4     1056\n",
      "Fz     1056\n",
      "T6     1056\n",
      "T5     1056\n",
      "Name: electrode, dtype: int64\n",
      "Alpha2       1824\n",
      "Alpha        1824\n",
      "Gamma        1824\n",
      "Theta        1824\n",
      "HighGamma    1824\n",
      "Beta1        1824\n",
      "Beta2        1824\n",
      "HighBeta     1824\n",
      "Delta        1824\n",
      "Alpha1       1824\n",
      "Beta         1824\n",
      "Name: brain_oscillation, dtype: int64\n",
      "25.0-30.0Hz    1824\n",
      "1.0-4.0Hz      1824\n",
      "4.0-8.0Hz      1824\n",
      "40.0-50.0Hz    1824\n",
      "12.0-25.0Hz    1824\n",
      "8.0-12.0Hz     1824\n",
      "10.0-12.0Hz    1824\n",
      "8.0-10.0Hz     1824\n",
      "12.0-15.0Hz    1824\n",
      "15.0-18.0Hz    1824\n",
      "30.0-40.0Hz    1824\n",
      "Name: freq_band, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "print(df_eeg.electrode.value_counts())\n",
    "print(df_eeg.brain_oscillation.value_counts())\n",
    "print(df_eeg.freq_band.value_counts())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Merge dataframes (Neuropsy data with df (eeg))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### We now need to import the Neuropsydata"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:43.048941Z",
     "start_time": "2020-06-08T00:40:43.001416Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(100, 15)\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>ID</th>\n",
       "      <th>Age</th>\n",
       "      <th>Gender</th>\n",
       "      <th>cIM</th>\n",
       "      <th>cHR</th>\n",
       "      <th>cIE</th>\n",
       "      <th>cSC</th>\n",
       "      <th>inat</th>\n",
       "      <th>hyper</th>\n",
       "      <th>Aqtot</th>\n",
       "      <th>Aqaudi</th>\n",
       "      <th>Aqvis</th>\n",
       "      <th>RCQtot</th>\n",
       "      <th>RCQaudi</th>\n",
       "      <th>RCQvis</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>17.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>110.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>26.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>24.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>112.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>10</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>98.0</td>\n",
       "      <td>103.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>85.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ID  Age  Gender   cIM   cHR   cIE   cSC  inat  hyper  Aqtot  Aqaudi  Aqvis  \\\n",
       "0   1   21       1  17.0  31.0  29.0   9.0  18.0   20.0   90.0    91.0   92.0   \n",
       "1   3   20       1  10.0   5.0  13.0   1.0   8.0    5.0   27.0    34.0   41.0   \n",
       "2   4   18       1  26.0  17.0   7.0  15.0  23.0   11.0   93.0    89.0   96.0   \n",
       "3   7   23       1  24.0   8.0   6.0  14.0  19.0    3.0   86.0    66.0  112.0   \n",
       "4  10   18       1   NaN   NaN   NaN   NaN   NaN    NaN   98.0   103.0   93.0   \n",
       "\n",
       "   RCQtot  RCQaudi  RCQvis  \n",
       "0    94.0     80.0   110.0  \n",
       "1    25.0     31.0    38.0  \n",
       "2    90.0     92.0    90.0  \n",
       "3    94.0     90.0   100.0  \n",
       "4    92.0    100.0    85.0  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_neuropsy = pd.read_excel(\"Neuropsy.xlsx\", na_values=\".\")\n",
    "print(df_neuropsy.shape)\n",
    "df_neuropsy.head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Then remove participants (10,18, 52 and 215) because of missing Neuropsy data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:43.055968Z",
     "start_time": "2020-06-08T00:40:43.050370Z"
    }
   },
   "outputs": [],
   "source": [
    "df_neuropsy= df_neuropsy.dropna(axis=0, how='any')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Verify it worked"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:43.064027Z",
     "start_time": "2020-06-08T00:40:43.057460Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(96, 15)\n"
     ]
    }
   ],
   "source": [
    "print(df_neuropsy.shape)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Rename ID variable"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:43.085179Z",
     "start_time": "2020-06-08T00:40:43.065612Z"
    },
    "scrolled": true
   },
   "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>id</th>\n",
       "      <th>Age</th>\n",
       "      <th>Gender</th>\n",
       "      <th>cIM</th>\n",
       "      <th>cHR</th>\n",
       "      <th>cIE</th>\n",
       "      <th>cSC</th>\n",
       "      <th>inat</th>\n",
       "      <th>hyper</th>\n",
       "      <th>Aqtot</th>\n",
       "      <th>Aqaudi</th>\n",
       "      <th>Aqvis</th>\n",
       "      <th>RCQtot</th>\n",
       "      <th>RCQaudi</th>\n",
       "      <th>RCQvis</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>17.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>110.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>26.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>24.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>112.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>11</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>16.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id  Age  Gender   cIM   cHR   cIE   cSC  inat  hyper  Aqtot  Aqaudi  Aqvis  \\\n",
       "0   1   21       1  17.0  31.0  29.0   9.0  18.0   20.0   90.0    91.0   92.0   \n",
       "1   3   20       1  10.0   5.0  13.0   1.0   8.0    5.0   27.0    34.0   41.0   \n",
       "2   4   18       1  26.0  17.0   7.0  15.0  23.0   11.0   93.0    89.0   96.0   \n",
       "3   7   23       1  24.0   8.0   6.0  14.0  19.0    3.0   86.0    66.0  112.0   \n",
       "5  11   21       1  16.0  26.0  13.0  10.0  17.0   13.0   45.0    33.0   78.0   \n",
       "\n",
       "   RCQtot  RCQaudi  RCQvis  \n",
       "0    94.0     80.0   110.0  \n",
       "1    25.0     31.0    38.0  \n",
       "2    90.0     92.0    90.0  \n",
       "3    94.0     90.0   100.0  \n",
       "5    69.0     51.0    94.0  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#rename id\n",
    "df_neuropsy.rename(columns = {'ID':'id'}, inplace = True) #rename id so it can be merged\n",
    "df_neuropsy.head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Now let's merge the two dataframes together"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:43.094747Z",
     "start_time": "2020-06-08T00:40:43.086830Z"
    }
   },
   "outputs": [],
   "source": [
    "#change dtype of id column from df\n",
    "df_eeg['id']=df_eeg['id'].astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:43.108294Z",
     "start_time": "2020-06-08T00:40:43.096204Z"
    },
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "df_full = pd.merge(left=df_eeg, right=df_neuropsy, left_on='id', right_on='id')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:43.132705Z",
     "start_time": "2020-06-08T00:40:43.110146Z"
    }
   },
   "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>id</th>\n",
       "      <th>brain_oscillation</th>\n",
       "      <th>freq_band</th>\n",
       "      <th>electrode</th>\n",
       "      <th>fft_abs_power</th>\n",
       "      <th>Age</th>\n",
       "      <th>Gender</th>\n",
       "      <th>cIM</th>\n",
       "      <th>cHR</th>\n",
       "      <th>cIE</th>\n",
       "      <th>cSC</th>\n",
       "      <th>inat</th>\n",
       "      <th>hyper</th>\n",
       "      <th>Aqtot</th>\n",
       "      <th>Aqaudi</th>\n",
       "      <th>Aqvis</th>\n",
       "      <th>RCQtot</th>\n",
       "      <th>RCQaudi</th>\n",
       "      <th>RCQvis</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Delta</td>\n",
       "      <td>1.0-4.0Hz</td>\n",
       "      <td>FP1</td>\n",
       "      <td>15.376173</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>17.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>110.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>HighBeta</td>\n",
       "      <td>25.0-30.0Hz</td>\n",
       "      <td>FP1</td>\n",
       "      <td>7.356346</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>17.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>110.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>Beta</td>\n",
       "      <td>12.0-25.0Hz</td>\n",
       "      <td>O2</td>\n",
       "      <td>5.587346</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>17.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>110.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>Beta</td>\n",
       "      <td>12.0-25.0Hz</td>\n",
       "      <td>O1</td>\n",
       "      <td>5.659504</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>17.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>110.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>Beta</td>\n",
       "      <td>12.0-25.0Hz</td>\n",
       "      <td>T6</td>\n",
       "      <td>4.664137</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>17.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>110.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id brain_oscillation    freq_band electrode fft_abs_power  Age  Gender  \\\n",
       "0   1             Delta    1.0-4.0Hz       FP1     15.376173   21       1   \n",
       "1   1          HighBeta  25.0-30.0Hz       FP1      7.356346   21       1   \n",
       "2   1              Beta  12.0-25.0Hz        O2      5.587346   21       1   \n",
       "3   1              Beta  12.0-25.0Hz        O1      5.659504   21       1   \n",
       "4   1              Beta  12.0-25.0Hz        T6      4.664137   21       1   \n",
       "\n",
       "    cIM   cHR   cIE  cSC  inat  hyper  Aqtot  Aqaudi  Aqvis  RCQtot  RCQaudi  \\\n",
       "0  17.0  31.0  29.0  9.0  18.0   20.0   90.0    91.0   92.0    94.0     80.0   \n",
       "1  17.0  31.0  29.0  9.0  18.0   20.0   90.0    91.0   92.0    94.0     80.0   \n",
       "2  17.0  31.0  29.0  9.0  18.0   20.0   90.0    91.0   92.0    94.0     80.0   \n",
       "3  17.0  31.0  29.0  9.0  18.0   20.0   90.0    91.0   92.0    94.0     80.0   \n",
       "4  17.0  31.0  29.0  9.0  18.0   20.0   90.0    91.0   92.0    94.0     80.0   \n",
       "\n",
       "   RCQvis  \n",
       "0   110.0  \n",
       "1   110.0  \n",
       "2   110.0  \n",
       "3   110.0  \n",
       "4   110.0  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_full.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:43.144223Z",
     "start_time": "2020-06-08T00:40:43.134571Z"
    }
   },
   "outputs": [],
   "source": [
    "#sort by ids\n",
    "df_full = df_full.sort_values(by=['id'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Subtype labelling according to clinical standard"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Create a column for categorization of ADHD subtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:43.694498Z",
     "start_time": "2020-06-08T00:40:43.145883Z"
    }
   },
   "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>id</th>\n",
       "      <th>brain_oscillation</th>\n",
       "      <th>freq_band</th>\n",
       "      <th>electrode</th>\n",
       "      <th>fft_abs_power</th>\n",
       "      <th>Age</th>\n",
       "      <th>Gender</th>\n",
       "      <th>cIM</th>\n",
       "      <th>cHR</th>\n",
       "      <th>cIE</th>\n",
       "      <th>cSC</th>\n",
       "      <th>inat</th>\n",
       "      <th>hyper</th>\n",
       "      <th>Aqtot</th>\n",
       "      <th>Aqaudi</th>\n",
       "      <th>Aqvis</th>\n",
       "      <th>RCQtot</th>\n",
       "      <th>RCQaudi</th>\n",
       "      <th>RCQvis</th>\n",
       "      <th>subtype</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Delta</td>\n",
       "      <td>1.0-4.0Hz</td>\n",
       "      <td>FP1</td>\n",
       "      <td>15.376173</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>17.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>1</td>\n",
       "      <td>Beta2</td>\n",
       "      <td>15.0-18.0Hz</td>\n",
       "      <td>Pz</td>\n",
       "      <td>1.870920</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>17.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>1</td>\n",
       "      <td>Beta2</td>\n",
       "      <td>15.0-18.0Hz</td>\n",
       "      <td>P3</td>\n",
       "      <td>1.690150</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>17.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>1</td>\n",
       "      <td>Beta2</td>\n",
       "      <td>15.0-18.0Hz</td>\n",
       "      <td>T5</td>\n",
       "      <td>1.138450</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>17.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>1</td>\n",
       "      <td>Beta2</td>\n",
       "      <td>15.0-18.0Hz</td>\n",
       "      <td>T4</td>\n",
       "      <td>2.171898</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>17.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>mixed</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     id brain_oscillation    freq_band electrode fft_abs_power  Age  Gender  \\\n",
       "0     1             Delta    1.0-4.0Hz       FP1     15.376173   21       1   \n",
       "133   1             Beta2  15.0-18.0Hz        Pz      1.870920   21       1   \n",
       "134   1             Beta2  15.0-18.0Hz        P3      1.690150   21       1   \n",
       "135   1             Beta2  15.0-18.0Hz        T5      1.138450   21       1   \n",
       "136   1             Beta2  15.0-18.0Hz        T4      2.171898   21       1   \n",
       "\n",
       "      cIM   cHR   cIE  cSC  inat  hyper  Aqtot  Aqaudi  Aqvis  RCQtot  \\\n",
       "0    17.0  31.0  29.0  9.0  18.0   20.0   90.0    91.0   92.0    94.0   \n",
       "133  17.0  31.0  29.0  9.0  18.0   20.0   90.0    91.0   92.0    94.0   \n",
       "134  17.0  31.0  29.0  9.0  18.0   20.0   90.0    91.0   92.0    94.0   \n",
       "135  17.0  31.0  29.0  9.0  18.0   20.0   90.0    91.0   92.0    94.0   \n",
       "136  17.0  31.0  29.0  9.0  18.0   20.0   90.0    91.0   92.0    94.0   \n",
       "\n",
       "     RCQaudi  RCQvis subtype  \n",
       "0       80.0   110.0   mixed  \n",
       "133     80.0   110.0   mixed  \n",
       "134     80.0   110.0   mixed  \n",
       "135     80.0   110.0   mixed  \n",
       "136     80.0   110.0   mixed  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_full['subtype'] = df_full.apply(lambda x: pre.categorize_subtypes(x['inat'], x['hyper']), axis=1)\n",
    "\n",
    "df_full.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:43.714785Z",
     "start_time": "2020-06-08T00:40:43.695857Z"
    }
   },
   "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>subtype</th>\n",
       "      <th>adhdtype</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>mixed</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>mixed</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>mixed</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>mixed</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>mixed</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>mixed</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>mixed</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>mixed</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>mixed</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>mixed</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>mixed</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    subtype  adhdtype\n",
       "0     mixed         2\n",
       "133   mixed         2\n",
       "134   mixed         2\n",
       "135   mixed         2\n",
       "136   mixed         2\n",
       "137   mixed         2\n",
       "138   mixed         2\n",
       "139   mixed         2\n",
       "140   mixed         2\n",
       "141   mixed         2\n",
       "142   mixed         2"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#encoding the subtypes into numerocal labels for future SNF analysis/machine learning\n",
    "# hyperactive = 0\n",
    "# inattentive subtype = 1\n",
    "# mixed subtype = 2\n",
    "from sklearn.preprocessing import LabelEncoder\n",
    "\n",
    "lb_make = LabelEncoder()\n",
    "df_full[\"adhdtype\"] = lb_make.fit_transform(df_full[\"subtype\"])\n",
    "df_full[[\"subtype\", \"adhdtype\"]].head(11)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:43.745308Z",
     "start_time": "2020-06-08T00:40:43.716727Z"
    },
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1    10032\n",
       "2     9614\n",
       "0      418\n",
       "Name: adhdtype, dtype: int64"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Reorder columns \n",
    "df_full = df_full[['id','Age', 'Gender','inat','hyper',\"subtype\",'adhdtype', 'brain_oscillation','electrode','fft_abs_power', 'cIM', 'cHR', 'cIE', 'cSC', 'Aqtot', 'Aqaudi', 'Aqvis', 'RCQtot', 'RCQaudi', 'RCQvis']]\n",
    "df_full.head()\n",
    "df_full['adhdtype'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Adjust data types in dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:43.767150Z",
     "start_time": "2020-06-08T00:40:43.747384Z"
    },
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 20064 entries, 0 to 16092\n",
      "Data columns (total 20 columns):\n",
      " #   Column             Non-Null Count  Dtype  \n",
      "---  ------             --------------  -----  \n",
      " 0   id                 20064 non-null  int64  \n",
      " 1   Age                20064 non-null  int64  \n",
      " 2   Gender             20064 non-null  int64  \n",
      " 3   inat               20064 non-null  float64\n",
      " 4   hyper              20064 non-null  float64\n",
      " 5   subtype            20064 non-null  object \n",
      " 6   adhdtype           20064 non-null  int64  \n",
      " 7   brain_oscillation  20064 non-null  object \n",
      " 8   electrode          20064 non-null  object \n",
      " 9   fft_abs_power      20064 non-null  object \n",
      " 10  cIM                20064 non-null  float64\n",
      " 11  cHR                20064 non-null  float64\n",
      " 12  cIE                20064 non-null  float64\n",
      " 13  cSC                20064 non-null  float64\n",
      " 14  Aqtot              20064 non-null  float64\n",
      " 15  Aqaudi             20064 non-null  float64\n",
      " 16  Aqvis              20064 non-null  float64\n",
      " 17  RCQtot             20064 non-null  float64\n",
      " 18  RCQaudi            20064 non-null  float64\n",
      " 19  RCQvis             20064 non-null  float64\n",
      "dtypes: float64(12), int64(4), object(4)\n",
      "memory usage: 3.2+ MB\n"
     ]
    }
   ],
   "source": [
    "df_full.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:43.780571Z",
     "start_time": "2020-06-08T00:40:43.770823Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "id                     int64\n",
      "Age                    int64\n",
      "Gender                 int64\n",
      "inat                 float64\n",
      "hyper                float64\n",
      "subtype               object\n",
      "adhdtype               int64\n",
      "brain_oscillation     object\n",
      "electrode             object\n",
      "fft_abs_power        float64\n",
      "cIM                  float64\n",
      "cHR                  float64\n",
      "cIE                  float64\n",
      "cSC                  float64\n",
      "Aqtot                float64\n",
      "Aqaudi               float64\n",
      "Aqvis                float64\n",
      "RCQtot               float64\n",
      "RCQaudi              float64\n",
      "RCQvis               float64\n",
      "dtype: object\n"
     ]
    }
   ],
   "source": [
    "df_full['fft_abs_power'] = df_full['fft_abs_power'].astype(float)\n",
    "print(df_full.dtypes)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:43.800824Z",
     "start_time": "2020-06-08T00:40:43.782248Z"
    }
   },
   "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>id</th>\n",
       "      <th>Gender</th>\n",
       "      <th>adhdtype</th>\n",
       "      <th>brain_oscillation</th>\n",
       "      <th>electrode</th>\n",
       "      <th>fft_abs_power</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Delta</td>\n",
       "      <td>FP1</td>\n",
       "      <td>15.376173</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Beta2</td>\n",
       "      <td>Pz</td>\n",
       "      <td>1.870920</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Beta2</td>\n",
       "      <td>P3</td>\n",
       "      <td>1.690150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Beta2</td>\n",
       "      <td>T5</td>\n",
       "      <td>1.138450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Beta2</td>\n",
       "      <td>T4</td>\n",
       "      <td>2.171898</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15958</th>\n",
       "      <td>702</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Theta</td>\n",
       "      <td>Fz</td>\n",
       "      <td>15.355240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15959</th>\n",
       "      <td>702</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Alpha</td>\n",
       "      <td>P3</td>\n",
       "      <td>26.927847</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15960</th>\n",
       "      <td>702</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Theta</td>\n",
       "      <td>F4</td>\n",
       "      <td>12.414647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15935</th>\n",
       "      <td>702</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Theta</td>\n",
       "      <td>F3</td>\n",
       "      <td>12.058871</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16092</th>\n",
       "      <td>702</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Alpha2</td>\n",
       "      <td>F3</td>\n",
       "      <td>7.689915</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20064 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        id  Gender  adhdtype brain_oscillation electrode  fft_abs_power\n",
       "0        1       1         2             Delta       FP1      15.376173\n",
       "133      1       1         2             Beta2        Pz       1.870920\n",
       "134      1       1         2             Beta2        P3       1.690150\n",
       "135      1       1         2             Beta2        T5       1.138450\n",
       "136      1       1         2             Beta2        T4       2.171898\n",
       "...    ...     ...       ...               ...       ...            ...\n",
       "15958  702       1         1             Theta        Fz      15.355240\n",
       "15959  702       1         1             Alpha        P3      26.927847\n",
       "15960  702       1         1             Theta        F4      12.414647\n",
       "15935  702       1         1             Theta        F3      12.058871\n",
       "16092  702       1         1            Alpha2        F3       7.689915\n",
       "\n",
       "[20064 rows x 6 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_full_eeg = df_full[['id', 'Gender', 'adhdtype','brain_oscillation','electrode', 'fft_abs_power']]\n",
    "df_full_eeg"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Descriptive statistics according to gender (male and female)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Clean dataset and keep variables of interest only"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:43.818554Z",
     "start_time": "2020-06-08T00:40:43.802452Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "     id  Gender subtype  adhdtype brain_oscillation electrode  fft_abs_power  \\\n",
      "0     1       1   mixed         2             Delta       FP1      15.376173   \n",
      "133   1       1   mixed         2             Beta2        Pz       1.870920   \n",
      "134   1       1   mixed         2             Beta2        P3       1.690150   \n",
      "135   1       1   mixed         2             Beta2        T5       1.138450   \n",
      "136   1       1   mixed         2             Beta2        T4       2.171898   \n",
      "\n",
      "      cIM   cHR   cIE  cSC  Aqtot  Aqaudi  Aqvis  RCQtot  RCQaudi  RCQvis  \n",
      "0    17.0  31.0  29.0  9.0   90.0    91.0   92.0    94.0     80.0   110.0  \n",
      "133  17.0  31.0  29.0  9.0   90.0    91.0   92.0    94.0     80.0   110.0  \n",
      "134  17.0  31.0  29.0  9.0   90.0    91.0   92.0    94.0     80.0   110.0  \n",
      "135  17.0  31.0  29.0  9.0   90.0    91.0   92.0    94.0     80.0   110.0  \n",
      "136  17.0  31.0  29.0  9.0   90.0    91.0   92.0    94.0     80.0   110.0  \n"
     ]
    }
   ],
   "source": [
    "df_analysis = df_full[['id','Gender','subtype','adhdtype','brain_oscillation', 'electrode', 'fft_abs_power', 'cIM', 'cHR', 'cIE', 'cSC', 'Aqtot', 'Aqaudi', 'Aqvis', 'RCQtot', 'RCQaudi', 'RCQvis']]\n",
    "print(df_analysis.head())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Description statistics by gender, subtype and brain oscillations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:45.591501Z",
     "start_time": "2020-06-08T00:40:43.820690Z"
    }
   },
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th colspan=\"8\" halign=\"left\">id</th>\n",
       "      <th colspan=\"2\" halign=\"left\">adhdtype</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"2\" halign=\"left\">RCQaudi</th>\n",
       "      <th colspan=\"8\" halign=\"left\">RCQvis</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "      <th>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>...</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "      <th>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gender</th>\n",
       "      <th>subtype</th>\n",
       "      <th>brain_oscillation</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"22\" valign=\"top\">1</th>\n",
       "      <th rowspan=\"11\" valign=\"top\">inat</th>\n",
       "      <th>Alpha</th>\n",
       "      <td>646.0</td>\n",
       "      <td>179.764706</td>\n",
       "      <td>185.621020</td>\n",
       "      <td>4.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>702.0</td>\n",
       "      <td>646.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>94.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>646.0</td>\n",
       "      <td>76.558824</td>\n",
       "      <td>24.811515</td>\n",
       "      <td>37.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>76.5</td>\n",
       "      <td>97.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alpha1</th>\n",
       "      <td>646.0</td>\n",
       "      <td>179.764706</td>\n",
       "      <td>185.621020</td>\n",
       "      <td>4.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>702.0</td>\n",
       "      <td>646.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>94.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>646.0</td>\n",
       "      <td>76.558824</td>\n",
       "      <td>24.811515</td>\n",
       "      <td>37.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>76.5</td>\n",
       "      <td>97.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alpha2</th>\n",
       "      <td>646.0</td>\n",
       "      <td>179.764706</td>\n",
       "      <td>185.621020</td>\n",
       "      <td>4.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>702.0</td>\n",
       "      <td>646.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>94.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>646.0</td>\n",
       "      <td>76.558824</td>\n",
       "      <td>24.811515</td>\n",
       "      <td>37.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>76.5</td>\n",
       "      <td>97.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Beta</th>\n",
       "      <td>646.0</td>\n",
       "      <td>179.764706</td>\n",
       "      <td>185.621020</td>\n",
       "      <td>4.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>702.0</td>\n",
       "      <td>646.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>94.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>646.0</td>\n",
       "      <td>76.558824</td>\n",
       "      <td>24.811515</td>\n",
       "      <td>37.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>76.5</td>\n",
       "      <td>97.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Beta1</th>\n",
       "      <td>646.0</td>\n",
       "      <td>179.764706</td>\n",
       "      <td>185.621020</td>\n",
       "      <td>4.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>702.0</td>\n",
       "      <td>646.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>94.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>646.0</td>\n",
       "      <td>76.558824</td>\n",
       "      <td>24.811515</td>\n",
       "      <td>37.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>76.5</td>\n",
       "      <td>97.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Beta2</th>\n",
       "      <td>646.0</td>\n",
       "      <td>179.764706</td>\n",
       "      <td>185.621020</td>\n",
       "      <td>4.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>702.0</td>\n",
       "      <td>646.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>94.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>646.0</td>\n",
       "      <td>76.558824</td>\n",
       "      <td>24.811515</td>\n",
       "      <td>37.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>76.5</td>\n",
       "      <td>97.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Delta</th>\n",
       "      <td>646.0</td>\n",
       "      <td>179.764706</td>\n",
       "      <td>185.621020</td>\n",
       "      <td>4.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>702.0</td>\n",
       "      <td>646.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>94.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>646.0</td>\n",
       "      <td>76.558824</td>\n",
       "      <td>24.811515</td>\n",
       "      <td>37.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>76.5</td>\n",
       "      <td>97.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gamma</th>\n",
       "      <td>646.0</td>\n",
       "      <td>179.764706</td>\n",
       "      <td>185.621020</td>\n",
       "      <td>4.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>702.0</td>\n",
       "      <td>646.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>94.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>646.0</td>\n",
       "      <td>76.558824</td>\n",
       "      <td>24.811515</td>\n",
       "      <td>37.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>76.5</td>\n",
       "      <td>97.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HighBeta</th>\n",
       "      <td>646.0</td>\n",
       "      <td>179.764706</td>\n",
       "      <td>185.621020</td>\n",
       "      <td>4.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>702.0</td>\n",
       "      <td>646.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>94.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>646.0</td>\n",
       "      <td>76.558824</td>\n",
       "      <td>24.811515</td>\n",
       "      <td>37.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>76.5</td>\n",
       "      <td>97.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HighGamma</th>\n",
       "      <td>646.0</td>\n",
       "      <td>179.764706</td>\n",
       "      <td>185.621020</td>\n",
       "      <td>4.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>702.0</td>\n",
       "      <td>646.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>94.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>646.0</td>\n",
       "      <td>76.558824</td>\n",
       "      <td>24.811515</td>\n",
       "      <td>37.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>76.5</td>\n",
       "      <td>97.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Theta</th>\n",
       "      <td>646.0</td>\n",
       "      <td>179.764706</td>\n",
       "      <td>185.621020</td>\n",
       "      <td>4.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>702.0</td>\n",
       "      <td>646.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>94.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>646.0</td>\n",
       "      <td>76.558824</td>\n",
       "      <td>24.811515</td>\n",
       "      <td>37.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>76.5</td>\n",
       "      <td>97.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"11\" valign=\"top\">mixed</th>\n",
       "      <th>Alpha</th>\n",
       "      <td>437.0</td>\n",
       "      <td>154.869565</td>\n",
       "      <td>189.447661</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>213.0</td>\n",
       "      <td>701.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>85.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>71.739130</td>\n",
       "      <td>23.135335</td>\n",
       "      <td>33.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alpha1</th>\n",
       "      <td>437.0</td>\n",
       "      <td>154.869565</td>\n",
       "      <td>189.447661</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>213.0</td>\n",
       "      <td>701.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>85.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>71.739130</td>\n",
       "      <td>23.135335</td>\n",
       "      <td>33.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alpha2</th>\n",
       "      <td>437.0</td>\n",
       "      <td>154.869565</td>\n",
       "      <td>189.447661</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>213.0</td>\n",
       "      <td>701.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>85.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>71.739130</td>\n",
       "      <td>23.135335</td>\n",
       "      <td>33.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Beta</th>\n",
       "      <td>437.0</td>\n",
       "      <td>154.869565</td>\n",
       "      <td>189.447661</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>213.0</td>\n",
       "      <td>701.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>85.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>71.739130</td>\n",
       "      <td>23.135335</td>\n",
       "      <td>33.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Beta1</th>\n",
       "      <td>437.0</td>\n",
       "      <td>154.869565</td>\n",
       "      <td>189.447661</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>213.0</td>\n",
       "      <td>701.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>85.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>71.739130</td>\n",
       "      <td>23.135335</td>\n",
       "      <td>33.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Beta2</th>\n",
       "      <td>437.0</td>\n",
       "      <td>154.869565</td>\n",
       "      <td>189.447661</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>213.0</td>\n",
       "      <td>701.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>85.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>71.739130</td>\n",
       "      <td>23.135335</td>\n",
       "      <td>33.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Delta</th>\n",
       "      <td>437.0</td>\n",
       "      <td>154.869565</td>\n",
       "      <td>189.447661</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>213.0</td>\n",
       "      <td>701.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>85.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>71.739130</td>\n",
       "      <td>23.135335</td>\n",
       "      <td>33.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gamma</th>\n",
       "      <td>437.0</td>\n",
       "      <td>154.869565</td>\n",
       "      <td>189.447661</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>213.0</td>\n",
       "      <td>701.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>85.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>71.739130</td>\n",
       "      <td>23.135335</td>\n",
       "      <td>33.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HighBeta</th>\n",
       "      <td>437.0</td>\n",
       "      <td>154.869565</td>\n",
       "      <td>189.447661</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>213.0</td>\n",
       "      <td>701.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>85.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>71.739130</td>\n",
       "      <td>23.135335</td>\n",
       "      <td>33.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HighGamma</th>\n",
       "      <td>437.0</td>\n",
       "      <td>154.869565</td>\n",
       "      <td>189.447661</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>213.0</td>\n",
       "      <td>701.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>85.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>71.739130</td>\n",
       "      <td>23.135335</td>\n",
       "      <td>33.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Theta</th>\n",
       "      <td>437.0</td>\n",
       "      <td>154.869565</td>\n",
       "      <td>189.447661</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>213.0</td>\n",
       "      <td>701.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>85.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>71.739130</td>\n",
       "      <td>23.135335</td>\n",
       "      <td>33.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"33\" valign=\"top\">2</th>\n",
       "      <th rowspan=\"11\" valign=\"top\">hyper</th>\n",
       "      <th>Alpha</th>\n",
       "      <td>38.0</td>\n",
       "      <td>77.500000</td>\n",
       "      <td>18.748333</td>\n",
       "      <td>59.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>77.5</td>\n",
       "      <td>96.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>106.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>85.000000</td>\n",
       "      <td>12.161081</td>\n",
       "      <td>73.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alpha1</th>\n",
       "      <td>38.0</td>\n",
       "      <td>77.500000</td>\n",
       "      <td>18.748333</td>\n",
       "      <td>59.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>77.5</td>\n",
       "      <td>96.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>106.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>85.000000</td>\n",
       "      <td>12.161081</td>\n",
       "      <td>73.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alpha2</th>\n",
       "      <td>38.0</td>\n",
       "      <td>77.500000</td>\n",
       "      <td>18.748333</td>\n",
       "      <td>59.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>77.5</td>\n",
       "      <td>96.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>106.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>85.000000</td>\n",
       "      <td>12.161081</td>\n",
       "      <td>73.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Beta</th>\n",
       "      <td>38.0</td>\n",
       "      <td>77.500000</td>\n",
       "      <td>18.748333</td>\n",
       "      <td>59.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>77.5</td>\n",
       "      <td>96.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>106.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>85.000000</td>\n",
       "      <td>12.161081</td>\n",
       "      <td>73.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Beta1</th>\n",
       "      <td>38.0</td>\n",
       "      <td>77.500000</td>\n",
       "      <td>18.748333</td>\n",
       "      <td>59.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>77.5</td>\n",
       "      <td>96.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>106.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>85.000000</td>\n",
       "      <td>12.161081</td>\n",
       "      <td>73.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Beta2</th>\n",
       "      <td>38.0</td>\n",
       "      <td>77.500000</td>\n",
       "      <td>18.748333</td>\n",
       "      <td>59.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>77.5</td>\n",
       "      <td>96.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>106.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>85.000000</td>\n",
       "      <td>12.161081</td>\n",
       "      <td>73.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Delta</th>\n",
       "      <td>38.0</td>\n",
       "      <td>77.500000</td>\n",
       "      <td>18.748333</td>\n",
       "      <td>59.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>77.5</td>\n",
       "      <td>96.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>106.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>85.000000</td>\n",
       "      <td>12.161081</td>\n",
       "      <td>73.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gamma</th>\n",
       "      <td>38.0</td>\n",
       "      <td>77.500000</td>\n",
       "      <td>18.748333</td>\n",
       "      <td>59.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>77.5</td>\n",
       "      <td>96.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>106.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>85.000000</td>\n",
       "      <td>12.161081</td>\n",
       "      <td>73.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HighBeta</th>\n",
       "      <td>38.0</td>\n",
       "      <td>77.500000</td>\n",
       "      <td>18.748333</td>\n",
       "      <td>59.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>77.5</td>\n",
       "      <td>96.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>106.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>85.000000</td>\n",
       "      <td>12.161081</td>\n",
       "      <td>73.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HighGamma</th>\n",
       "      <td>38.0</td>\n",
       "      <td>77.500000</td>\n",
       "      <td>18.748333</td>\n",
       "      <td>59.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>77.5</td>\n",
       "      <td>96.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>106.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>85.000000</td>\n",
       "      <td>12.161081</td>\n",
       "      <td>73.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Theta</th>\n",
       "      <td>38.0</td>\n",
       "      <td>77.500000</td>\n",
       "      <td>18.748333</td>\n",
       "      <td>59.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>77.5</td>\n",
       "      <td>96.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>106.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>85.000000</td>\n",
       "      <td>12.161081</td>\n",
       "      <td>73.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"11\" valign=\"top\">inat</th>\n",
       "      <th>Alpha</th>\n",
       "      <td>266.0</td>\n",
       "      <td>108.000000</td>\n",
       "      <td>126.600486</td>\n",
       "      <td>19.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>61.5</td>\n",
       "      <td>121.0</td>\n",
       "      <td>409.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>84.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>65.642857</td>\n",
       "      <td>27.949353</td>\n",
       "      <td>8.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>107.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alpha1</th>\n",
       "      <td>266.0</td>\n",
       "      <td>108.000000</td>\n",
       "      <td>126.600486</td>\n",
       "      <td>19.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>61.5</td>\n",
       "      <td>121.0</td>\n",
       "      <td>409.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>84.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>65.642857</td>\n",
       "      <td>27.949353</td>\n",
       "      <td>8.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>107.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alpha2</th>\n",
       "      <td>266.0</td>\n",
       "      <td>108.000000</td>\n",
       "      <td>126.600486</td>\n",
       "      <td>19.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>61.5</td>\n",
       "      <td>121.0</td>\n",
       "      <td>409.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>84.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>65.642857</td>\n",
       "      <td>27.949353</td>\n",
       "      <td>8.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>107.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Beta</th>\n",
       "      <td>266.0</td>\n",
       "      <td>108.000000</td>\n",
       "      <td>126.600486</td>\n",
       "      <td>19.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>61.5</td>\n",
       "      <td>121.0</td>\n",
       "      <td>409.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>84.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>65.642857</td>\n",
       "      <td>27.949353</td>\n",
       "      <td>8.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>107.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Beta1</th>\n",
       "      <td>266.0</td>\n",
       "      <td>108.000000</td>\n",
       "      <td>126.600486</td>\n",
       "      <td>19.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>61.5</td>\n",
       "      <td>121.0</td>\n",
       "      <td>409.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>84.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>65.642857</td>\n",
       "      <td>27.949353</td>\n",
       "      <td>8.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>107.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Beta2</th>\n",
       "      <td>266.0</td>\n",
       "      <td>108.000000</td>\n",
       "      <td>126.600486</td>\n",
       "      <td>19.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>61.5</td>\n",
       "      <td>121.0</td>\n",
       "      <td>409.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>84.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>65.642857</td>\n",
       "      <td>27.949353</td>\n",
       "      <td>8.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>107.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Delta</th>\n",
       "      <td>266.0</td>\n",
       "      <td>108.000000</td>\n",
       "      <td>126.600486</td>\n",
       "      <td>19.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>61.5</td>\n",
       "      <td>121.0</td>\n",
       "      <td>409.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>84.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>65.642857</td>\n",
       "      <td>27.949353</td>\n",
       "      <td>8.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>107.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gamma</th>\n",
       "      <td>266.0</td>\n",
       "      <td>108.000000</td>\n",
       "      <td>126.600486</td>\n",
       "      <td>19.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>61.5</td>\n",
       "      <td>121.0</td>\n",
       "      <td>409.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>84.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>65.642857</td>\n",
       "      <td>27.949353</td>\n",
       "      <td>8.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>107.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HighBeta</th>\n",
       "      <td>266.0</td>\n",
       "      <td>108.000000</td>\n",
       "      <td>126.600486</td>\n",
       "      <td>19.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>61.5</td>\n",
       "      <td>121.0</td>\n",
       "      <td>409.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>84.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>65.642857</td>\n",
       "      <td>27.949353</td>\n",
       "      <td>8.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>107.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HighGamma</th>\n",
       "      <td>266.0</td>\n",
       "      <td>108.000000</td>\n",
       "      <td>126.600486</td>\n",
       "      <td>19.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>61.5</td>\n",
       "      <td>121.0</td>\n",
       "      <td>409.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>84.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>65.642857</td>\n",
       "      <td>27.949353</td>\n",
       "      <td>8.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>107.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Theta</th>\n",
       "      <td>266.0</td>\n",
       "      <td>108.000000</td>\n",
       "      <td>126.600486</td>\n",
       "      <td>19.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>61.5</td>\n",
       "      <td>121.0</td>\n",
       "      <td>409.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>84.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>65.642857</td>\n",
       "      <td>27.949353</td>\n",
       "      <td>8.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>107.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"11\" valign=\"top\">mixed</th>\n",
       "      <th>Alpha</th>\n",
       "      <td>437.0</td>\n",
       "      <td>179.695652</td>\n",
       "      <td>174.422287</td>\n",
       "      <td>17.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>126.0</td>\n",
       "      <td>216.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>100.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>22.396039</td>\n",
       "      <td>26.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>111.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alpha1</th>\n",
       "      <td>437.0</td>\n",
       "      <td>179.695652</td>\n",
       "      <td>174.422287</td>\n",
       "      <td>17.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>126.0</td>\n",
       "      <td>216.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>100.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>22.396039</td>\n",
       "      <td>26.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>111.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alpha2</th>\n",
       "      <td>437.0</td>\n",
       "      <td>179.695652</td>\n",
       "      <td>174.422287</td>\n",
       "      <td>17.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>126.0</td>\n",
       "      <td>216.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>100.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>22.396039</td>\n",
       "      <td>26.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>111.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Beta</th>\n",
       "      <td>437.0</td>\n",
       "      <td>179.695652</td>\n",
       "      <td>174.422287</td>\n",
       "      <td>17.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>126.0</td>\n",
       "      <td>216.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>100.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>22.396039</td>\n",
       "      <td>26.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>111.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Beta1</th>\n",
       "      <td>437.0</td>\n",
       "      <td>179.695652</td>\n",
       "      <td>174.422287</td>\n",
       "      <td>17.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>126.0</td>\n",
       "      <td>216.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>100.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>22.396039</td>\n",
       "      <td>26.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>111.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Beta2</th>\n",
       "      <td>437.0</td>\n",
       "      <td>179.695652</td>\n",
       "      <td>174.422287</td>\n",
       "      <td>17.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>126.0</td>\n",
       "      <td>216.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>100.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>22.396039</td>\n",
       "      <td>26.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>111.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Delta</th>\n",
       "      <td>437.0</td>\n",
       "      <td>179.695652</td>\n",
       "      <td>174.422287</td>\n",
       "      <td>17.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>126.0</td>\n",
       "      <td>216.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>100.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>22.396039</td>\n",
       "      <td>26.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>111.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gamma</th>\n",
       "      <td>437.0</td>\n",
       "      <td>179.695652</td>\n",
       "      <td>174.422287</td>\n",
       "      <td>17.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>126.0</td>\n",
       "      <td>216.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>100.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>22.396039</td>\n",
       "      <td>26.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>111.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HighBeta</th>\n",
       "      <td>437.0</td>\n",
       "      <td>179.695652</td>\n",
       "      <td>174.422287</td>\n",
       "      <td>17.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>126.0</td>\n",
       "      <td>216.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>100.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>22.396039</td>\n",
       "      <td>26.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>111.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HighGamma</th>\n",
       "      <td>437.0</td>\n",
       "      <td>179.695652</td>\n",
       "      <td>174.422287</td>\n",
       "      <td>17.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>126.0</td>\n",
       "      <td>216.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>100.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>22.396039</td>\n",
       "      <td>26.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>111.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Theta</th>\n",
       "      <td>437.0</td>\n",
       "      <td>179.695652</td>\n",
       "      <td>174.422287</td>\n",
       "      <td>17.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>126.0</td>\n",
       "      <td>216.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>100.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>22.396039</td>\n",
       "      <td>26.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>111.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>55 rows × 104 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     id                                      \\\n",
       "                                  count        mean         std   min   25%   \n",
       "Gender subtype brain_oscillation                                              \n",
       "1      inat    Alpha              646.0  179.764706  185.621020   4.0  64.0   \n",
       "               Alpha1             646.0  179.764706  185.621020   4.0  64.0   \n",
       "               Alpha2             646.0  179.764706  185.621020   4.0  64.0   \n",
       "               Beta               646.0  179.764706  185.621020   4.0  64.0   \n",
       "               Beta1              646.0  179.764706  185.621020   4.0  64.0   \n",
       "               Beta2              646.0  179.764706  185.621020   4.0  64.0   \n",
       "               Delta              646.0  179.764706  185.621020   4.0  64.0   \n",
       "               Gamma              646.0  179.764706  185.621020   4.0  64.0   \n",
       "               HighBeta           646.0  179.764706  185.621020   4.0  64.0   \n",
       "               HighGamma          646.0  179.764706  185.621020   4.0  64.0   \n",
       "               Theta              646.0  179.764706  185.621020   4.0  64.0   \n",
       "       mixed   Alpha              437.0  154.869565  189.447661   1.0  14.0   \n",
       "               Alpha1             437.0  154.869565  189.447661   1.0  14.0   \n",
       "               Alpha2             437.0  154.869565  189.447661   1.0  14.0   \n",
       "               Beta               437.0  154.869565  189.447661   1.0  14.0   \n",
       "               Beta1              437.0  154.869565  189.447661   1.0  14.0   \n",
       "               Beta2              437.0  154.869565  189.447661   1.0  14.0   \n",
       "               Delta              437.0  154.869565  189.447661   1.0  14.0   \n",
       "               Gamma              437.0  154.869565  189.447661   1.0  14.0   \n",
       "               HighBeta           437.0  154.869565  189.447661   1.0  14.0   \n",
       "               HighGamma          437.0  154.869565  189.447661   1.0  14.0   \n",
       "               Theta              437.0  154.869565  189.447661   1.0  14.0   \n",
       "2      hyper   Alpha               38.0   77.500000   18.748333  59.0  59.0   \n",
       "               Alpha1              38.0   77.500000   18.748333  59.0  59.0   \n",
       "               Alpha2              38.0   77.500000   18.748333  59.0  59.0   \n",
       "               Beta                38.0   77.500000   18.748333  59.0  59.0   \n",
       "               Beta1               38.0   77.500000   18.748333  59.0  59.0   \n",
       "               Beta2               38.0   77.500000   18.748333  59.0  59.0   \n",
       "               Delta               38.0   77.500000   18.748333  59.0  59.0   \n",
       "               Gamma               38.0   77.500000   18.748333  59.0  59.0   \n",
       "               HighBeta            38.0   77.500000   18.748333  59.0  59.0   \n",
       "               HighGamma           38.0   77.500000   18.748333  59.0  59.0   \n",
       "               Theta               38.0   77.500000   18.748333  59.0  59.0   \n",
       "       inat    Alpha              266.0  108.000000  126.600486  19.0  24.0   \n",
       "               Alpha1             266.0  108.000000  126.600486  19.0  24.0   \n",
       "               Alpha2             266.0  108.000000  126.600486  19.0  24.0   \n",
       "               Beta               266.0  108.000000  126.600486  19.0  24.0   \n",
       "               Beta1              266.0  108.000000  126.600486  19.0  24.0   \n",
       "               Beta2              266.0  108.000000  126.600486  19.0  24.0   \n",
       "               Delta              266.0  108.000000  126.600486  19.0  24.0   \n",
       "               Gamma              266.0  108.000000  126.600486  19.0  24.0   \n",
       "               HighBeta           266.0  108.000000  126.600486  19.0  24.0   \n",
       "               HighGamma          266.0  108.000000  126.600486  19.0  24.0   \n",
       "               Theta              266.0  108.000000  126.600486  19.0  24.0   \n",
       "       mixed   Alpha              437.0  179.695652  174.422287  17.0  45.0   \n",
       "               Alpha1             437.0  179.695652  174.422287  17.0  45.0   \n",
       "               Alpha2             437.0  179.695652  174.422287  17.0  45.0   \n",
       "               Beta               437.0  179.695652  174.422287  17.0  45.0   \n",
       "               Beta1              437.0  179.695652  174.422287  17.0  45.0   \n",
       "               Beta2              437.0  179.695652  174.422287  17.0  45.0   \n",
       "               Delta              437.0  179.695652  174.422287  17.0  45.0   \n",
       "               Gamma              437.0  179.695652  174.422287  17.0  45.0   \n",
       "               HighBeta           437.0  179.695652  174.422287  17.0  45.0   \n",
       "               HighGamma          437.0  179.695652  174.422287  17.0  45.0   \n",
       "               Theta              437.0  179.695652  174.422287  17.0  45.0   \n",
       "\n",
       "                                                      adhdtype       ...  \\\n",
       "                                    50%    75%    max    count mean  ...   \n",
       "Gender subtype brain_oscillation                                     ...   \n",
       "1      inat    Alpha               84.0  220.0  702.0    646.0  1.0  ...   \n",
       "               Alpha1              84.0  220.0  702.0    646.0  1.0  ...   \n",
       "               Alpha2              84.0  220.0  702.0    646.0  1.0  ...   \n",
       "               Beta                84.0  220.0  702.0    646.0  1.0  ...   \n",
       "               Beta1               84.0  220.0  702.0    646.0  1.0  ...   \n",
       "               Beta2               84.0  220.0  702.0    646.0  1.0  ...   \n",
       "               Delta               84.0  220.0  702.0    646.0  1.0  ...   \n",
       "               Gamma               84.0  220.0  702.0    646.0  1.0  ...   \n",
       "               HighBeta            84.0  220.0  702.0    646.0  1.0  ...   \n",
       "               HighGamma           84.0  220.0  702.0    646.0  1.0  ...   \n",
       "               Theta               84.0  220.0  702.0    646.0  1.0  ...   \n",
       "       mixed   Alpha               80.0  213.0  701.0    437.0  2.0  ...   \n",
       "               Alpha1              80.0  213.0  701.0    437.0  2.0  ...   \n",
       "               Alpha2              80.0  213.0  701.0    437.0  2.0  ...   \n",
       "               Beta                80.0  213.0  701.0    437.0  2.0  ...   \n",
       "               Beta1               80.0  213.0  701.0    437.0  2.0  ...   \n",
       "               Beta2               80.0  213.0  701.0    437.0  2.0  ...   \n",
       "               Delta               80.0  213.0  701.0    437.0  2.0  ...   \n",
       "               Gamma               80.0  213.0  701.0    437.0  2.0  ...   \n",
       "               HighBeta            80.0  213.0  701.0    437.0  2.0  ...   \n",
       "               HighGamma           80.0  213.0  701.0    437.0  2.0  ...   \n",
       "               Theta               80.0  213.0  701.0    437.0  2.0  ...   \n",
       "2      hyper   Alpha               77.5   96.0   96.0     38.0  0.0  ...   \n",
       "               Alpha1              77.5   96.0   96.0     38.0  0.0  ...   \n",
       "               Alpha2              77.5   96.0   96.0     38.0  0.0  ...   \n",
       "               Beta                77.5   96.0   96.0     38.0  0.0  ...   \n",
       "               Beta1               77.5   96.0   96.0     38.0  0.0  ...   \n",
       "               Beta2               77.5   96.0   96.0     38.0  0.0  ...   \n",
       "               Delta               77.5   96.0   96.0     38.0  0.0  ...   \n",
       "               Gamma               77.5   96.0   96.0     38.0  0.0  ...   \n",
       "               HighBeta            77.5   96.0   96.0     38.0  0.0  ...   \n",
       "               HighGamma           77.5   96.0   96.0     38.0  0.0  ...   \n",
       "               Theta               77.5   96.0   96.0     38.0  0.0  ...   \n",
       "       inat    Alpha               61.5  121.0  409.0    266.0  1.0  ...   \n",
       "               Alpha1              61.5  121.0  409.0    266.0  1.0  ...   \n",
       "               Alpha2              61.5  121.0  409.0    266.0  1.0  ...   \n",
       "               Beta                61.5  121.0  409.0    266.0  1.0  ...   \n",
       "               Beta1               61.5  121.0  409.0    266.0  1.0  ...   \n",
       "               Beta2               61.5  121.0  409.0    266.0  1.0  ...   \n",
       "               Delta               61.5  121.0  409.0    266.0  1.0  ...   \n",
       "               Gamma               61.5  121.0  409.0    266.0  1.0  ...   \n",
       "               HighBeta            61.5  121.0  409.0    266.0  1.0  ...   \n",
       "               HighGamma           61.5  121.0  409.0    266.0  1.0  ...   \n",
       "               Theta               61.5  121.0  409.0    266.0  1.0  ...   \n",
       "       mixed   Alpha              126.0  216.0  700.0    437.0  2.0  ...   \n",
       "               Alpha1             126.0  216.0  700.0    437.0  2.0  ...   \n",
       "               Alpha2             126.0  216.0  700.0    437.0  2.0  ...   \n",
       "               Beta               126.0  216.0  700.0    437.0  2.0  ...   \n",
       "               Beta1              126.0  216.0  700.0    437.0  2.0  ...   \n",
       "               Beta2              126.0  216.0  700.0    437.0  2.0  ...   \n",
       "               Delta              126.0  216.0  700.0    437.0  2.0  ...   \n",
       "               Gamma              126.0  216.0  700.0    437.0  2.0  ...   \n",
       "               HighBeta           126.0  216.0  700.0    437.0  2.0  ...   \n",
       "               HighGamma          126.0  216.0  700.0    437.0  2.0  ...   \n",
       "               Theta              126.0  216.0  700.0    437.0  2.0  ...   \n",
       "\n",
       "                                 RCQaudi        RCQvis                        \\\n",
       "                                     75%    max  count       mean        std   \n",
       "Gender subtype brain_oscillation                                               \n",
       "1      inat    Alpha                94.0  113.0  646.0  76.558824  24.811515   \n",
       "               Alpha1               94.0  113.0  646.0  76.558824  24.811515   \n",
       "               Alpha2               94.0  113.0  646.0  76.558824  24.811515   \n",
       "               Beta                 94.0  113.0  646.0  76.558824  24.811515   \n",
       "               Beta1                94.0  113.0  646.0  76.558824  24.811515   \n",
       "               Beta2                94.0  113.0  646.0  76.558824  24.811515   \n",
       "               Delta                94.0  113.0  646.0  76.558824  24.811515   \n",
       "               Gamma                94.0  113.0  646.0  76.558824  24.811515   \n",
       "               HighBeta             94.0  113.0  646.0  76.558824  24.811515   \n",
       "               HighGamma            94.0  113.0  646.0  76.558824  24.811515   \n",
       "               Theta                94.0  113.0  646.0  76.558824  24.811515   \n",
       "       mixed   Alpha                85.0  122.0  437.0  71.739130  23.135335   \n",
       "               Alpha1               85.0  122.0  437.0  71.739130  23.135335   \n",
       "               Alpha2               85.0  122.0  437.0  71.739130  23.135335   \n",
       "               Beta                 85.0  122.0  437.0  71.739130  23.135335   \n",
       "               Beta1                85.0  122.0  437.0  71.739130  23.135335   \n",
       "               Beta2                85.0  122.0  437.0  71.739130  23.135335   \n",
       "               Delta                85.0  122.0  437.0  71.739130  23.135335   \n",
       "               Gamma                85.0  122.0  437.0  71.739130  23.135335   \n",
       "               HighBeta             85.0  122.0  437.0  71.739130  23.135335   \n",
       "               HighGamma            85.0  122.0  437.0  71.739130  23.135335   \n",
       "               Theta                85.0  122.0  437.0  71.739130  23.135335   \n",
       "2      hyper   Alpha               106.0  106.0   38.0  85.000000  12.161081   \n",
       "               Alpha1              106.0  106.0   38.0  85.000000  12.161081   \n",
       "               Alpha2              106.0  106.0   38.0  85.000000  12.161081   \n",
       "               Beta                106.0  106.0   38.0  85.000000  12.161081   \n",
       "               Beta1               106.0  106.0   38.0  85.000000  12.161081   \n",
       "               Beta2               106.0  106.0   38.0  85.000000  12.161081   \n",
       "               Delta               106.0  106.0   38.0  85.000000  12.161081   \n",
       "               Gamma               106.0  106.0   38.0  85.000000  12.161081   \n",
       "               HighBeta            106.0  106.0   38.0  85.000000  12.161081   \n",
       "               HighGamma           106.0  106.0   38.0  85.000000  12.161081   \n",
       "               Theta               106.0  106.0   38.0  85.000000  12.161081   \n",
       "       inat    Alpha                84.0  106.0  266.0  65.642857  27.949353   \n",
       "               Alpha1               84.0  106.0  266.0  65.642857  27.949353   \n",
       "               Alpha2               84.0  106.0  266.0  65.642857  27.949353   \n",
       "               Beta                 84.0  106.0  266.0  65.642857  27.949353   \n",
       "               Beta1                84.0  106.0  266.0  65.642857  27.949353   \n",
       "               Beta2                84.0  106.0  266.0  65.642857  27.949353   \n",
       "               Delta                84.0  106.0  266.0  65.642857  27.949353   \n",
       "               Gamma                84.0  106.0  266.0  65.642857  27.949353   \n",
       "               HighBeta             84.0  106.0  266.0  65.642857  27.949353   \n",
       "               HighGamma            84.0  106.0  266.0  65.642857  27.949353   \n",
       "               Theta                84.0  106.0  266.0  65.642857  27.949353   \n",
       "       mixed   Alpha               100.0  132.0  437.0  75.000000  22.396039   \n",
       "               Alpha1              100.0  132.0  437.0  75.000000  22.396039   \n",
       "               Alpha2              100.0  132.0  437.0  75.000000  22.396039   \n",
       "               Beta                100.0  132.0  437.0  75.000000  22.396039   \n",
       "               Beta1               100.0  132.0  437.0  75.000000  22.396039   \n",
       "               Beta2               100.0  132.0  437.0  75.000000  22.396039   \n",
       "               Delta               100.0  132.0  437.0  75.000000  22.396039   \n",
       "               Gamma               100.0  132.0  437.0  75.000000  22.396039   \n",
       "               HighBeta            100.0  132.0  437.0  75.000000  22.396039   \n",
       "               HighGamma           100.0  132.0  437.0  75.000000  22.396039   \n",
       "               Theta               100.0  132.0  437.0  75.000000  22.396039   \n",
       "\n",
       "                                                                 \n",
       "                                   min   25%   50%   75%    max  \n",
       "Gender subtype brain_oscillation                                 \n",
       "1      inat    Alpha              37.0  55.0  76.5  97.0  122.0  \n",
       "               Alpha1             37.0  55.0  76.5  97.0  122.0  \n",
       "               Alpha2             37.0  55.0  76.5  97.0  122.0  \n",
       "               Beta               37.0  55.0  76.5  97.0  122.0  \n",
       "               Beta1              37.0  55.0  76.5  97.0  122.0  \n",
       "               Beta2              37.0  55.0  76.5  97.0  122.0  \n",
       "               Delta              37.0  55.0  76.5  97.0  122.0  \n",
       "               Gamma              37.0  55.0  76.5  97.0  122.0  \n",
       "               HighBeta           37.0  55.0  76.5  97.0  122.0  \n",
       "               HighGamma          37.0  55.0  76.5  97.0  122.0  \n",
       "               Theta              37.0  55.0  76.5  97.0  122.0  \n",
       "       mixed   Alpha              33.0  57.0  65.0  94.0  122.0  \n",
       "               Alpha1             33.0  57.0  65.0  94.0  122.0  \n",
       "               Alpha2             33.0  57.0  65.0  94.0  122.0  \n",
       "               Beta               33.0  57.0  65.0  94.0  122.0  \n",
       "               Beta1              33.0  57.0  65.0  94.0  122.0  \n",
       "               Beta2              33.0  57.0  65.0  94.0  122.0  \n",
       "               Delta              33.0  57.0  65.0  94.0  122.0  \n",
       "               Gamma              33.0  57.0  65.0  94.0  122.0  \n",
       "               HighBeta           33.0  57.0  65.0  94.0  122.0  \n",
       "               HighGamma          33.0  57.0  65.0  94.0  122.0  \n",
       "               Theta              33.0  57.0  65.0  94.0  122.0  \n",
       "2      hyper   Alpha              73.0  73.0  85.0  97.0   97.0  \n",
       "               Alpha1             73.0  73.0  85.0  97.0   97.0  \n",
       "               Alpha2             73.0  73.0  85.0  97.0   97.0  \n",
       "               Beta               73.0  73.0  85.0  97.0   97.0  \n",
       "               Beta1              73.0  73.0  85.0  97.0   97.0  \n",
       "               Beta2              73.0  73.0  85.0  97.0   97.0  \n",
       "               Delta              73.0  73.0  85.0  97.0   97.0  \n",
       "               Gamma              73.0  73.0  85.0  97.0   97.0  \n",
       "               HighBeta           73.0  73.0  85.0  97.0   97.0  \n",
       "               HighGamma          73.0  73.0  85.0  97.0   97.0  \n",
       "               Theta              73.0  73.0  85.0  97.0   97.0  \n",
       "       inat    Alpha               8.0  55.0  67.0  83.0  107.0  \n",
       "               Alpha1              8.0  55.0  67.0  83.0  107.0  \n",
       "               Alpha2              8.0  55.0  67.0  83.0  107.0  \n",
       "               Beta                8.0  55.0  67.0  83.0  107.0  \n",
       "               Beta1               8.0  55.0  67.0  83.0  107.0  \n",
       "               Beta2               8.0  55.0  67.0  83.0  107.0  \n",
       "               Delta               8.0  55.0  67.0  83.0  107.0  \n",
       "               Gamma               8.0  55.0  67.0  83.0  107.0  \n",
       "               HighBeta            8.0  55.0  67.0  83.0  107.0  \n",
       "               HighGamma           8.0  55.0  67.0  83.0  107.0  \n",
       "               Theta               8.0  55.0  67.0  83.0  107.0  \n",
       "       mixed   Alpha              26.0  55.0  75.0  94.0  111.0  \n",
       "               Alpha1             26.0  55.0  75.0  94.0  111.0  \n",
       "               Alpha2             26.0  55.0  75.0  94.0  111.0  \n",
       "               Beta               26.0  55.0  75.0  94.0  111.0  \n",
       "               Beta1              26.0  55.0  75.0  94.0  111.0  \n",
       "               Beta2              26.0  55.0  75.0  94.0  111.0  \n",
       "               Delta              26.0  55.0  75.0  94.0  111.0  \n",
       "               Gamma              26.0  55.0  75.0  94.0  111.0  \n",
       "               HighBeta           26.0  55.0  75.0  94.0  111.0  \n",
       "               HighGamma          26.0  55.0  75.0  94.0  111.0  \n",
       "               Theta              26.0  55.0  75.0  94.0  111.0  \n",
       "\n",
       "[55 rows x 104 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_analysis.groupby(['Gender','subtype', 'brain_oscillation']).describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Create two different df for behavioral data and connors"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:45.605511Z",
     "start_time": "2020-06-08T00:40:45.592935Z"
    }
   },
   "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>id</th>\n",
       "      <th>adhdtype</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15958</th>\n",
       "      <td>702</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15959</th>\n",
       "      <td>702</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15960</th>\n",
       "      <td>702</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15935</th>\n",
       "      <td>702</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16092</th>\n",
       "      <td>702</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20064 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        id  adhdtype\n",
       "0        1         2\n",
       "133      1         2\n",
       "134      1         2\n",
       "135      1         2\n",
       "136      1         2\n",
       "...    ...       ...\n",
       "15958  702         1\n",
       "15959  702         1\n",
       "15960  702         1\n",
       "15935  702         1\n",
       "16092  702         1\n",
       "\n",
       "[20064 rows x 2 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_connors = df_analysis[['id','Gender','cIM', 'cHR', 'cIE', 'cSC']]\n",
    "df_behavioral = df_analysis[['id','Gender', 'Aqtot', 'Aqaudi', 'Aqvis', 'RCQtot', 'RCQaudi', 'RCQvis']]\n",
    "df_labels = df_analysis[['id','adhdtype']]\n",
    "\n",
    "df_labels"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Export as csv "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:45.847164Z",
     "start_time": "2020-06-08T00:40:45.607255Z"
    }
   },
   "outputs": [],
   "source": [
    "df_connors.to_csv('Data/df_connors')\n",
    "df_behavioral.to_csv('Data/df_behavioral')\n",
    "df_labels.to_csv('Data/labels')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Export df_eeg into csv format for SNF analysis"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:45.913331Z",
     "start_time": "2020-06-08T00:40:45.848506Z"
    }
   },
   "outputs": [],
   "source": [
    "df_full_eeg.to_csv('Data/df_eeg')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Export df_analysis into csv format for visualization"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-08T00:40:46.141281Z",
     "start_time": "2020-06-08T00:40:45.914878Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "     id  Gender subtype  adhdtype brain_oscillation electrode  fft_abs_power  \\\n",
      "0     1       1   mixed         2             Delta       FP1      15.376173   \n",
      "133   1       1   mixed         2             Beta2        Pz       1.870920   \n",
      "134   1       1   mixed         2             Beta2        P3       1.690150   \n",
      "135   1       1   mixed         2             Beta2        T5       1.138450   \n",
      "136   1       1   mixed         2             Beta2        T4       2.171898   \n",
      "\n",
      "      cIM   cHR   cIE  cSC  Aqtot  Aqaudi  Aqvis  RCQtot  RCQaudi  RCQvis  \n",
      "0    17.0  31.0  29.0  9.0   90.0    91.0   92.0    94.0     80.0   110.0  \n",
      "133  17.0  31.0  29.0  9.0   90.0    91.0   92.0    94.0     80.0   110.0  \n",
      "134  17.0  31.0  29.0  9.0   90.0    91.0   92.0    94.0     80.0   110.0  \n",
      "135  17.0  31.0  29.0  9.0   90.0    91.0   92.0    94.0     80.0   110.0  \n",
      "136  17.0  31.0  29.0  9.0   90.0    91.0   92.0    94.0     80.0   110.0  \n"
     ]
    }
   ],
   "source": [
    "df_analysis = df_full[['id','Gender','subtype','adhdtype','brain_oscillation', 'electrode', 'fft_abs_power', 'cIM', 'cHR', 'cIE', 'cSC', 'Aqtot', 'Aqaudi', 'Aqvis', 'RCQtot', 'RCQaudi', 'RCQvis']]\n",
    "print(df_analysis.head())\n",
    "df_analysis.to_csv('Data/df_analysis')"
   ]
  }
 ],
 "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.7"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}