hypnogram_EDA.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "84f9b2b0",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\ProgramData\\Anaconda3\\lib\\site-packages\\scipy\\__init__.py:146: UserWarning: A NumPy version >=1.16.5 and <1.23.0 is required for this version of SciPy (detected version 1.26.0\n",
      "  warnings.warn(f\"A NumPy version >={np_minversion} and <{np_maxversion}\"\n"
     ]
    }
   ],
   "source": [
    "# import\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "cfdcad16",
   "metadata": {},
   "outputs": [],
   "source": [
    "train=pd.read_csv(\"C:/Users/82102/Desktop/의료/128.치매 고위험군 라이프로그/128.치매 고위험군 라이프로그/01.데이터/train_data.csv\")\n",
    "val=pd.read_csv(\"C:/Users/82102/Desktop/의료/128.치매 고위험군 라이프로그/128.치매 고위험군 라이프로그/01.데이터/val_data.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "537a9ac5",
   "metadata": {},
   "outputs": [],
   "source": [
    "train.drop(columns=['Unnamed: 0'], inplace=True)\n",
    "val.drop(columns=['Unnamed: 0'], inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "ecf97b82",
   "metadata": {},
   "outputs": [],
   "source": [
    "CN_data=train[train['DIAG_NM']=='CN']\n",
    "MCI_data=train[train['DIAG_NM']=='MCI']\n",
    "Dem_data=train[train['DIAG_NM']=='Dem']\n",
    "CN_data=CN_data.reset_index(drop=True)\n",
    "MCI_data=MCI_data.reset_index(drop=True)\n",
    "Dem_data=Dem_data.reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1a8226fb",
   "metadata": {},
   "source": [
    "# 치매 환자 확인"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "5d82c13e",
   "metadata": {
    "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>EMAIL</th>\n",
       "      <th>activity_average_met</th>\n",
       "      <th>activity_cal_active</th>\n",
       "      <th>activity_cal_total</th>\n",
       "      <th>activity_daily_movement</th>\n",
       "      <th>activity_day_end</th>\n",
       "      <th>activity_day_start</th>\n",
       "      <th>activity_high</th>\n",
       "      <th>activity_inactive</th>\n",
       "      <th>activity_inactivity_alerts</th>\n",
       "      <th>...</th>\n",
       "      <th>Q14_1</th>\n",
       "      <th>Q14_2</th>\n",
       "      <th>Q15</th>\n",
       "      <th>Q16_1</th>\n",
       "      <th>Q16_2</th>\n",
       "      <th>Q16_3</th>\n",
       "      <th>Q17</th>\n",
       "      <th>Q18</th>\n",
       "      <th>Q19</th>\n",
       "      <th>TOTAL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>nia+067@rowan.kr</td>\n",
       "      <td>1.43750</td>\n",
       "      <td>397</td>\n",
       "      <td>2472</td>\n",
       "      <td>7103</td>\n",
       "      <td>2020-10-19T03:59:59+09:00</td>\n",
       "      <td>2020-10-18T04:00:00+09:00</td>\n",
       "      <td>0</td>\n",
       "      <td>636</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>nia+067@rowan.kr</td>\n",
       "      <td>1.37500</td>\n",
       "      <td>366</td>\n",
       "      <td>2398</td>\n",
       "      <td>6881</td>\n",
       "      <td>2020-10-20T03:59:59+09:00</td>\n",
       "      <td>2020-10-19T04:00:00+09:00</td>\n",
       "      <td>0</td>\n",
       "      <td>586</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>nia+067@rowan.kr</td>\n",
       "      <td>1.34375</td>\n",
       "      <td>330</td>\n",
       "      <td>2354</td>\n",
       "      <td>6389</td>\n",
       "      <td>2020-10-21T03:59:59+09:00</td>\n",
       "      <td>2020-10-20T04:00:00+09:00</td>\n",
       "      <td>0</td>\n",
       "      <td>539</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>nia+067@rowan.kr</td>\n",
       "      <td>1.21875</td>\n",
       "      <td>92</td>\n",
       "      <td>2122</td>\n",
       "      <td>1159</td>\n",
       "      <td>2020-10-22T03:59:59+09:00</td>\n",
       "      <td>2020-10-21T04:00:00+09:00</td>\n",
       "      <td>0</td>\n",
       "      <td>647</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>nia+067@rowan.kr</td>\n",
       "      <td>1.25000</td>\n",
       "      <td>206</td>\n",
       "      <td>2188</td>\n",
       "      <td>3755</td>\n",
       "      <td>2020-10-23T03:59:59+09:00</td>\n",
       "      <td>2020-10-22T04:00:00+09:00</td>\n",
       "      <td>0</td>\n",
       "      <td>506</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>16</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>566</th>\n",
       "      <td>nia+196@rowan.kr</td>\n",
       "      <td>1.00000</td>\n",
       "      <td>14</td>\n",
       "      <td>1845</td>\n",
       "      <td>194</td>\n",
       "      <td>2021-01-02T03:59:59+09:00</td>\n",
       "      <td>2021-01-01T04:00:00+09:00</td>\n",
       "      <td>0</td>\n",
       "      <td>104</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>567</th>\n",
       "      <td>nia+196@rowan.kr</td>\n",
       "      <td>1.15625</td>\n",
       "      <td>71</td>\n",
       "      <td>2032</td>\n",
       "      <td>1090</td>\n",
       "      <td>2021-01-03T03:59:59+09:00</td>\n",
       "      <td>2021-01-02T04:00:00+09:00</td>\n",
       "      <td>0</td>\n",
       "      <td>581</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>568</th>\n",
       "      <td>nia+196@rowan.kr</td>\n",
       "      <td>1.21875</td>\n",
       "      <td>207</td>\n",
       "      <td>2162</td>\n",
       "      <td>3726</td>\n",
       "      <td>2021-01-04T03:59:59+09:00</td>\n",
       "      <td>2021-01-03T04:00:00+09:00</td>\n",
       "      <td>2</td>\n",
       "      <td>457</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>569</th>\n",
       "      <td>nia+196@rowan.kr</td>\n",
       "      <td>1.15625</td>\n",
       "      <td>122</td>\n",
       "      <td>2071</td>\n",
       "      <td>1974</td>\n",
       "      <td>2021-01-05T03:59:59+09:00</td>\n",
       "      <td>2021-01-04T04:00:00+09:00</td>\n",
       "      <td>0</td>\n",
       "      <td>507</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>570</th>\n",
       "      <td>nia+196@rowan.kr</td>\n",
       "      <td>1.03125</td>\n",
       "      <td>3</td>\n",
       "      <td>1767</td>\n",
       "      <td>12</td>\n",
       "      <td>2021-01-06T03:59:59+09:00</td>\n",
       "      <td>2021-01-05T04:00:00+09:00</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>571 rows × 98 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                EMAIL  activity_average_met  activity_cal_active  \\\n",
       "0    nia+067@rowan.kr               1.43750                  397   \n",
       "1    nia+067@rowan.kr               1.37500                  366   \n",
       "2    nia+067@rowan.kr               1.34375                  330   \n",
       "3    nia+067@rowan.kr               1.21875                   92   \n",
       "4    nia+067@rowan.kr               1.25000                  206   \n",
       "..                ...                   ...                  ...   \n",
       "566  nia+196@rowan.kr               1.00000                   14   \n",
       "567  nia+196@rowan.kr               1.15625                   71   \n",
       "568  nia+196@rowan.kr               1.21875                  207   \n",
       "569  nia+196@rowan.kr               1.15625                  122   \n",
       "570  nia+196@rowan.kr               1.03125                    3   \n",
       "\n",
       "     activity_cal_total  activity_daily_movement           activity_day_end  \\\n",
       "0                  2472                     7103  2020-10-19T03:59:59+09:00   \n",
       "1                  2398                     6881  2020-10-20T03:59:59+09:00   \n",
       "2                  2354                     6389  2020-10-21T03:59:59+09:00   \n",
       "3                  2122                     1159  2020-10-22T03:59:59+09:00   \n",
       "4                  2188                     3755  2020-10-23T03:59:59+09:00   \n",
       "..                  ...                      ...                        ...   \n",
       "566                1845                      194  2021-01-02T03:59:59+09:00   \n",
       "567                2032                     1090  2021-01-03T03:59:59+09:00   \n",
       "568                2162                     3726  2021-01-04T03:59:59+09:00   \n",
       "569                2071                     1974  2021-01-05T03:59:59+09:00   \n",
       "570                1767                       12  2021-01-06T03:59:59+09:00   \n",
       "\n",
       "            activity_day_start  activity_high  activity_inactive  \\\n",
       "0    2020-10-18T04:00:00+09:00              0                636   \n",
       "1    2020-10-19T04:00:00+09:00              0                586   \n",
       "2    2020-10-20T04:00:00+09:00              0                539   \n",
       "3    2020-10-21T04:00:00+09:00              0                647   \n",
       "4    2020-10-22T04:00:00+09:00              0                506   \n",
       "..                         ...            ...                ...   \n",
       "566  2021-01-01T04:00:00+09:00              0                104   \n",
       "567  2021-01-02T04:00:00+09:00              0                581   \n",
       "568  2021-01-03T04:00:00+09:00              2                457   \n",
       "569  2021-01-04T04:00:00+09:00              0                507   \n",
       "570  2021-01-05T04:00:00+09:00              0                 28   \n",
       "\n",
       "     activity_inactivity_alerts  ...  Q14_1  Q14_2  Q15  Q16_1  Q16_2  Q16_3  \\\n",
       "0                             2  ...      2      2    2      1      1      2   \n",
       "1                             2  ...      2      2    2      1      1      2   \n",
       "2                             1  ...      2      2    2      1      1      2   \n",
       "3                             0  ...      2      2    2      1      1      2   \n",
       "4                             1  ...      2      2    2      1      1      2   \n",
       "..                          ...  ...    ...    ...  ...    ...    ...    ...   \n",
       "566                           0  ...      2      2    2      1      2      1   \n",
       "567                           1  ...      2      2    2      1      2      1   \n",
       "568                           0  ...      2      2    2      1      2      1   \n",
       "569                           0  ...      2      2    2      1      2      1   \n",
       "570                           0  ...      2      2    2      1      2      1   \n",
       "\n",
       "     Q17  Q18  Q19  TOTAL  \n",
       "0      1    2    2     16  \n",
       "1      1    2    2     16  \n",
       "2      1    2    2     16  \n",
       "3      1    2    2     16  \n",
       "4      1    2    2     16  \n",
       "..   ...  ...  ...    ...  \n",
       "566    2    1    2     16  \n",
       "567    2    1    2     16  \n",
       "568    2    1    2     16  \n",
       "569    2    1    2     16  \n",
       "570    2    1    2     16  \n",
       "\n",
       "[571 rows x 98 columns]"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Dem_data"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "945790cb",
   "metadata": {},
   "source": [
    "# hypnogram 열 빼고 다 제거"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "b4174485",
   "metadata": {},
   "outputs": [],
   "source": [
    "Dem_data=Dem_data[['EMAIL','CONVERT(sleep_hypnogram_5min USING utf8)']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "db334a64",
   "metadata": {},
   "outputs": [],
   "source": [
    "Dem_hypnogram = {}\n",
    "for email in Dem_data['EMAIL'].unique():\n",
    "    Dem_hypnogram[email] = Dem_data[Dem_data['EMAIL'] == email]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "d2dac64c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'nia+067@rowan.kr':                EMAIL           CONVERT(sleep_hypnogram_5min USING utf8)\n",
       " 0   nia+067@rowan.kr  4/2/4/4/2/2/2/2/2/2/2/2/2/2/2/2/4/2/2/1/2/3/3/...\n",
       " 1   nia+067@rowan.kr  4/2/2/3/2/2/2/2/2/1/2/2/2/2/2/2/2/2/2/2/2/2/2/...\n",
       " 2   nia+067@rowan.kr  4/4/4/2/2/4/4/2/2/1/1/1/2/2/4/4/2/2/4/4/4/4/4/...\n",
       " 3   nia+067@rowan.kr  4/4/4/2/4/4/2/4/4/2/2/2/2/1/1/2/2/3/4/4/4/2/2/...\n",
       " 4   nia+067@rowan.kr  4/2/1/2/4/4/2/2/2/1/1/1/1/1/4/4/4/2/2/2/4/4/2/...\n",
       " ..               ...                                                ...\n",
       " 70  nia+067@rowan.kr  4/2/2/2/2/1/1/1/1/2/2/2/2/2/1/2/4/4/2/1/1/1/2/...\n",
       " 71  nia+067@rowan.kr  4/4/2/2/2/2/2/2/1/1/4/2/2/1/1/2/2/3/3/2/4/4/4/...\n",
       " 72  nia+067@rowan.kr  4/2/2/2/2/2/2/2/2/2/2/2/1/1/2/2/2/2/2/2/2/2/2/...\n",
       " 73  nia+067@rowan.kr  4/2/2/2/2/2/2/4/2/2/2/2/2/2/1/1/4/4/4/2/2/2/3/...\n",
       " 74  nia+067@rowan.kr  2/4/4/4/2/2/2/1/1/1/2/2/2/2/2/2/2/2/2/2/2/2/2/...\n",
       " \n",
       " [75 rows x 2 columns],\n",
       " 'nia+341@rowan.kr':                 EMAIL           CONVERT(sleep_hypnogram_5min USING utf8)\n",
       " 75   nia+341@rowan.kr  4/4/4/1/1/1/1/2/4/2/2/2/4/2/4/4/4/2/2/1/4/2/1/...\n",
       " 76   nia+341@rowan.kr  4/4/2/1/1/1/1/4/4/2/4/2/2/2/2/4/4/4/4/2/1/1/1/...\n",
       " 77   nia+341@rowan.kr  4/2/2/2/2/2/3/2/2/2/2/4/1/1/1/1/1/1/1/1/1/1/1/...\n",
       " 78   nia+341@rowan.kr  4/4/4/2/2/2/1/1/1/2/2/1/1/1/1/1/1/2/4/4/4/4/1/...\n",
       " 79   nia+341@rowan.kr  4/2/2/4/2/1/1/4/4/4/4/2/2/2/1/2/2/2/2/3/3/3/3/...\n",
       " 80   nia+341@rowan.kr  4/4/4/4/2/1/4/4/2/2/2/3/1/1/2/2/2/2/1/1/2/1/1/...\n",
       " 81   nia+341@rowan.kr  4/2/4/4/4/4/4/4/3/3/3/1/1/1/3/3/3/4/3/2/3/3/1/...\n",
       " 82   nia+341@rowan.kr  4/4/4/4/4/4/4/4/4/4/4/2/4/2/4/4/2/2/4/4/1/1/1/...\n",
       " 83   nia+341@rowan.kr  4/4/4/4/4/4/2/4/3/4/4/4/2/4/4/3/2/2/4/4/2/2/2/...\n",
       " 84   nia+341@rowan.kr  4/4/4/4/1/1/1/1/1/1/1/1/1/1/1/1/3/3/3/3/4/3/4/...\n",
       " 85   nia+341@rowan.kr  4/4/4/2/1/2/2/2/4/2/2/2/2/2/4/4/2/2/1/1/2/1/2/...\n",
       " 86   nia+341@rowan.kr  4/4/2/4/4/4/4/2/2/1/1/1/1/1/1/1/3/3/3/2/4/4/1/...\n",
       " 87   nia+341@rowan.kr  4/2/2/2/2/2/2/2/3/4/4/2/2/2/2/2/2/3/3/3/3/4/4/...\n",
       " 88   nia+341@rowan.kr  4/4/4/2/3/3/3/2/4/4/1/2/4/4/2/2/2/2/4/2/2/2/2/...\n",
       " 89   nia+341@rowan.kr  4/4/4/2/2/1/2/2/1/1/2/1/1/1/1/3/3/3/3/3/3/2/2/...\n",
       " 90   nia+341@rowan.kr  4/4/1/1/4/4/4/4/2/4/4/2/1/2/4/4/2/2/4/4/2/2/3/...\n",
       " 91   nia+341@rowan.kr  2/2/2/2/4/4/2/3/2/2/2/2/2/2/2/2/2/2/2/3/3/3/3/...\n",
       " 92   nia+341@rowan.kr  4/2/4/4/4/4/4/4/4/2/4/1/2/2/1/1/3/1/4/2/2/2/3/...\n",
       " 93   nia+341@rowan.kr  4/4/2/4/2/2/2/1/1/2/2/1/1/1/1/1/1/1/3/3/3/3/2/...\n",
       " 94   nia+341@rowan.kr  4/2/4/2/2/2/4/4/2/2/2/2/2/2/2/4/4/1/1/1/2/4/1/...\n",
       " 95   nia+341@rowan.kr  2/4/2/2/2/1/1/2/1/4/4/2/2/2/2/1/1/1/1/4/2/2/2/...\n",
       " 96   nia+341@rowan.kr  4/4/4/4/2/2/4/2/1/2/2/2/2/4/4/2/2/2/2/2/3/2/2/...\n",
       " 97   nia+341@rowan.kr  4/2/2/2/2/4/1/4/4/1/1/1/1/1/3/1/1/1/2/2/4/4/4/...\n",
       " 98   nia+341@rowan.kr  4/4/4/1/1/1/4/4/4/1/1/1/1/1/1/3/3/4/4/4/4/4/4/...\n",
       " 99   nia+341@rowan.kr  4/4/4/4/1/2/2/1/3/1/1/2/2/4/2/2/2/2/1/1/2/2/2/...\n",
       " 100  nia+341@rowan.kr  4/2/4/2/2/3/2/2/1/1/1/1/1/1/4/4/2/2/1/2/1/2/1/...\n",
       " 101  nia+341@rowan.kr  2/2/2/1/1/4/2/1/2/2/2/1/2/2/3/4/2/2/2/2/2/3/2/...\n",
       " 102  nia+341@rowan.kr  4/4/4/4/4/4/4/4/2/4/4/3/2/2/4/2/2/2/2/2/2/4/2/...\n",
       " 103  nia+341@rowan.kr  4/1/1/4/4/4/2/1/1/1/1/1/3/1/2/3/3/3/3/3/3/3/2/...\n",
       " 104  nia+341@rowan.kr  4/2/2/2/2/1/1/1/2/2/2/1/3/1/4/2/2/2/1/1/1/2/1/...\n",
       " 105  nia+341@rowan.kr  4/2/4/4/2/2/2/1/1/1/1/4/4/2/2/2/2/2/2/4/2/2/2/...\n",
       " 106  nia+341@rowan.kr  4/4/2/1/2/2/2/4/4/4/4/4/2/3/3/2/3/3/1/1/3/1/4/...\n",
       " 107  nia+341@rowan.kr  4/2/1/1/2/1/1/1/1/4/2/2/3/3/3/3/2/2/2/4/2/2/1/...\n",
       " 108  nia+341@rowan.kr  4/4/1/1/1/1/1/1/1/1/1/1/1/1/2/3/3/3/3/3/3/4/4/...\n",
       " 109  nia+341@rowan.kr  2/2/1/1/2/2/2/2/2/3/3/2/2/2/3/1/2/2/2/2/2/4/4/...\n",
       " 110  nia+341@rowan.kr  4/2/3/1/4/2/3/2/4/2/2/2/2/2/2/1/1/2/2/2/2/1/2/...\n",
       " 111  nia+341@rowan.kr  4/2/2/2/2/4/4/2/4/1/4/4/4/4/4/2/2/2/4/4/4/4/4/...\n",
       " 112  nia+341@rowan.kr  4/4/2/1/1/1/2/1/1/1/1/1/1/1/1/1/3/3/3/3/3/4/4/...\n",
       " 113  nia+341@rowan.kr  4/2/2/2/2/2/2/2/4/2/2/2/2/4/2/1/1/1/1/4/4/2/1/...\n",
       " 114  nia+341@rowan.kr  4/2/2/2/2/1/1/2/1/1/1/1/1/1/1/1/1/1/1/2/1/1/2/...\n",
       " 115  nia+341@rowan.kr  4/4/2/2/2/2/1/1/2/1/1/1/1/1/1/2/1/1/2/2/2/2/2/...\n",
       " 116  nia+341@rowan.kr  4/4/4/4/2/2/4/2/3/2/4/4/2/4/2/2/2/2/1/1/4/2/2/...\n",
       " 117  nia+341@rowan.kr  4/2/2/1/2/4/4/4/4/1/1/2/2/4/4/4/4/4/4/4/4/2/2/...\n",
       " 118  nia+341@rowan.kr  4/4/4/4/2/4/2/2/4/2/2/2/2/2/2/1/1/1/1/1/1/1/1/...\n",
       " 119  nia+341@rowan.kr  4/2/2/4/4/4/4/4/2/4/4/4/4/2/2/2/2/3/3/2/2/3/3/...\n",
       " 120  nia+341@rowan.kr  4/2/2/1/1/1/1/1/1/1/4/1/1/1/2/2/1/1/1/3/3/3/2/...\n",
       " 121  nia+341@rowan.kr  4/4/4/2/4/2/2/4/4/4/4/4/1/3/3/1/2/2/4/4/4/4/4/...\n",
       " 122  nia+341@rowan.kr  4/4/4/1/2/4/4/3/3/3/2/2/4/4/2/2/2/2/2/2/2/2/4/...\n",
       " 123  nia+341@rowan.kr  4/2/1/1/1/1/2/2/1/1/1/1/1/1/1/2/2/3/2/2/3/3/2/...\n",
       " 124  nia+341@rowan.kr  4/4/4/2/2/4/2/2/1/1/1/1/1/1/1/4/2/2/1/1/2/3/2/...\n",
       " 125  nia+341@rowan.kr  4/4/4/1/2/2/4/4/4/2/2/4/4/4/1/1/4/4/2/2/1/1/1/...,\n",
       " 'nia+338@rowan.kr':                 EMAIL           CONVERT(sleep_hypnogram_5min USING utf8)\n",
       " 126  nia+338@rowan.kr  4/2/1/1/1/2/1/1/1/1/1/1/1/1/1/2/2/2/1/1/2/2/2/...\n",
       " 127  nia+338@rowan.kr  4/4/4/2/2/4/2/1/1/1/1/2/2/2/2/2/2/1/2/2/2/2/2/...\n",
       " 128  nia+338@rowan.kr  2/2/1/1/2/1/1/1/1/2/2/2/2/2/2/2/1/1/1/1/2/2/2/...\n",
       " 129  nia+338@rowan.kr  4/4/1/1/2/2/1/1/2/2/1/2/2/2/2/2/2/2/2/2/2/2/2/...\n",
       " 130  nia+338@rowan.kr  4/2/2/2/4/2/2/2/2/2/2/2/2/2/1/1/2/2/2/2/2/2/2/...\n",
       " ..                ...                                                ...\n",
       " 182  nia+338@rowan.kr  4/4/4/4/4/1/1/1/1/1/1/1/1/2/2/2/2/2/2/2/2/2/2/...\n",
       " 183  nia+338@rowan.kr  4/2/1/1/2/2/1/1/2/2/2/1/1/1/2/2/2/1/2/2/2/2/2/...\n",
       " 184  nia+338@rowan.kr  4/4/4/2/2/2/1/4/4/2/1/1/1/1/1/1/1/1/2/2/2/2/2/...\n",
       " 185  nia+338@rowan.kr  4/4/4/2/2/2/2/2/1/1/1/1/1/1/2/2/2/2/2/2/2/2/2/...\n",
       " 186  nia+338@rowan.kr  4/2/2/2/1/1/1/1/2/1/1/1/1/2/2/2/2/1/1/1/2/2/1/...\n",
       " \n",
       " [61 rows x 2 columns],\n",
       " 'nia+017@rowan.kr':                 EMAIL           CONVERT(sleep_hypnogram_5min USING utf8)\n",
       " 187  nia+017@rowan.kr  2/3/2/3/3/2/2/2/1/1/2/1/1/1/1/1/1/3/3/3/3/3/3/...\n",
       " 188  nia+017@rowan.kr  4/4/4/4/2/2/2/2/2/2/2/2/2/1/1/2/2/4/4/4/4/4/3/...\n",
       " 189  nia+017@rowan.kr  4/2/4/2/2/1/1/1/3/2/2/3/3/2/2/2/1/2/2/2/2/2/2/...\n",
       " 190  nia+017@rowan.kr  4/4/4/4/4/4/1/3/2/2/4/4/4/4/4/4/4/4/2/2/2/2/2/...\n",
       " 191  nia+017@rowan.kr  4/2/2/2/2/2/4/2/4/3/2/2/2/2/2/2/1/1/1/1/2/2/2/...\n",
       " 192  nia+017@rowan.kr  4/4/2/1/2/2/2/2/2/2/2/2/4/4/4/4/4/4/4/4/2/2/2/...\n",
       " 193  nia+017@rowan.kr  4/4/4/4/4/4/2/2/2/2/2/1/2/2/2/3/3/3/2/2/2/1/1/...\n",
       " 194  nia+017@rowan.kr  4/4/4/2/2/2/3/3/4/2/2/1/1/1/1/1/1/2/4/3/2/3/4/...\n",
       " 195  nia+017@rowan.kr  2/2/4/2/2/2/2/2/1/1/1/1/2/2/2/3/2/4/2/3/2/2/2/...\n",
       " 196  nia+017@rowan.kr  4/4/1/1/2/2/1/1/2/2/1/3/3/2/2/2/1/1/1/1/1/1/1/...\n",
       " 197  nia+017@rowan.kr  2/2/2/2/2/2/2/4/4/2/2/1/1/1/1/2/3/3/3/3/2/2/2/...\n",
       " 198  nia+017@rowan.kr  2/2/2/2/2/2/1/1/1/2/2/2/2/2/2/2/2/2/2/2/3/2/2/...\n",
       " 199  nia+017@rowan.kr  4/2/2/2/2/1/1/1/1/1/1/1/4/4/3/3/3/2/2/2/2/2/1/...\n",
       " 200  nia+017@rowan.kr  4/2/2/2/2/2/2/2/2/2/1/2/2/2/2/2/2/2/1/4/4/4/2/...\n",
       " 201  nia+017@rowan.kr  4/2/2/2/2/2/2/2/1/1/1/1/1/2/2/2/2/2/2/2/4/4/4/...\n",
       " 202  nia+017@rowan.kr  4/2/2/2/2/2/2/2/2/4/4/4/3/3/3/3/4/4/4/1/1/2/2/...\n",
       " 203  nia+017@rowan.kr  4/2/1/1/1/1/1/2/2/2/2/2/2/2/4/4/1/2/2/1/1/1/1/...\n",
       " 204  nia+017@rowan.kr  4/2/2/2/2/4/2/2/2/2/2/2/2/4/4/4/4/4/4/4/4/1/1/...\n",
       " 205  nia+017@rowan.kr  4/4/4/4/2/2/2/2/2/2/2/2/1/4/4/4/4/2/2/2/2/2/2/...\n",
       " 206  nia+017@rowan.kr  4/4/4/2/4/2/2/2/2/2/2/2/1/1/1/4/4/4/2/1/2/2/2/...\n",
       " 207  nia+017@rowan.kr  4/4/4/1/2/2/1/1/1/1/3/3/3/2/2/2/2/2/1/1/1/2/2/...\n",
       " 208  nia+017@rowan.kr  4/2/2/1/4/4/1/2/2/1/1/1/1/1/1/3/3/2/2/3/3/2/2/...\n",
       " 209  nia+017@rowan.kr  4/2/2/2/1/1/1/4/4/2/2/2/2/4/4/4/4/4/4/4/4/2/2/...\n",
       " 210  nia+017@rowan.kr  4/4/2/2/1/1/1/1/1/1/1/1/3/4/4/2/2/2/2/2/4/4/2/...\n",
       " 211  nia+017@rowan.kr  4/4/4/4/2/2/4/4/2/2/2/2/2/1/1/4/4/4/4/4/4/3/3/...\n",
       " 212  nia+017@rowan.kr  4/2/2/2/2/2/1/1/1/1/1/3/2/2/2/2/2/2/2/2/2/4/4/...\n",
       " 213  nia+017@rowan.kr  4/4/4/4/2/4/2/2/1/1/1/4/2/4/4/2/4/2/2/2/2/2/1/...\n",
       " 214  nia+017@rowan.kr  4/2/2/2/2/2/4/4/2/2/2/2/2/2/4/4/4/4/4/1/4/4/4/...\n",
       " 215  nia+017@rowan.kr  4/4/4/4/4/4/2/2/2/1/1/1/1/1/3/2/2/2/3/3/4/2/2/...\n",
       " 216  nia+017@rowan.kr  4/4/4/4/1/1/1/1/1/1/1/2/2/3/3/3/3/4/4/4/2/2/1/...\n",
       " 217  nia+017@rowan.kr  4/4/4/4/2/2/1/1/1/1/1/1/3/2/2/3/3/3/2/2/2/2/2/...\n",
       " 218  nia+017@rowan.kr  4/4/4/4/1/2/1/1/1/1/1/1/1/1/2/2/3/3/2/4/3/2/1/...\n",
       " 219  nia+017@rowan.kr  4/4/2/2/2/1/1/1/1/1/2/3/3/3/3/3/3/3/2/2/2/2/1/...\n",
       " 220  nia+017@rowan.kr  4/4/2/2/2/2/2/2/2/1/1/1/1/4/4/2/2/2/2/2/2/2/2/...\n",
       " 221  nia+017@rowan.kr  4/4/2/2/2/1/1/1/1/1/1/1/3/3/4/2/2/2/2/1/1/1/1/...\n",
       " 222  nia+017@rowan.kr  4/4/4/2/2/2/1/1/1/1/1/2/3/3/4/4/4/4/4/4/4/4/2/...\n",
       " 223  nia+017@rowan.kr  4/4/2/2/2/1/1/1/1/1/1/1/3/2/2/2/2/2/2/2/2/2/2/...\n",
       " 224  nia+017@rowan.kr  4/4/2/2/2/1/2/2/1/1/1/3/4/4/2/2/2/2/2/2/2/2/2/...\n",
       " 225  nia+017@rowan.kr  4/2/1/1/1/1/1/2/2/2/1/1/4/4/2/2/1/1/3/2/2/2/2/...\n",
       " 226  nia+017@rowan.kr  4/2/2/2/2/1/1/2/2/2/2/2/2/3/3/3/2/2/2/1/3/3/3/...\n",
       " 227  nia+017@rowan.kr  4/2/3/3/1/1/2/2/1/1/1/4/4/4/4/2/4/2/2/1/1/4/4/...\n",
       " 228  nia+017@rowan.kr  4/4/2/2/2/2/2/2/2/4/4/4/2/3/2/2/2/1/1/1/1/1/1/...\n",
       " 229  nia+017@rowan.kr  4/2/4/4/4/4/2/4/2/2/2/1/1/1/1/1/1/1/1/2/2/2/2/...\n",
       " 230  nia+017@rowan.kr  4/2/2/2/2/2/2/2/2/2/2/2/4/2/2/2/2/2/4/4/3/4/4/...\n",
       " 231  nia+017@rowan.kr  4/4/4/4/4/4/2/2/2/2/2/2/2/2/2/4/4/4/4/2/2/1/4/...\n",
       " 232  nia+017@rowan.kr  4/4/4/2/2/2/2/2/2/2/2/2/2/2/4/2/2/2/2/2/2/2/1/...\n",
       " 233  nia+017@rowan.kr  4/4/4/2/2/2/4/4/2/2/1/2/2/4/2/2/2/1/2/2/2/2/2/...\n",
       " 234  nia+017@rowan.kr  4/2/2/2/2/2/2/2/2/2/2/2/4/2/2/1/1/1/2/3/2/2/2/...\n",
       " 235  nia+017@rowan.kr  4/4/2/2/2/1/1/1/1/1/1/1/1/2/2/2/2/2/2/2/2/2/2/...\n",
       " 236  nia+017@rowan.kr  4/4/4/4/1/1/1/2/2/2/2/2/2/2/3/2/2/2/2/2/2/2/3/...\n",
       " 237  nia+017@rowan.kr  2/2/2/2/2/2/2/2/2/4/4/4/4/2/1/1/1/1/1/1/1/1/2/...\n",
       " 238  nia+017@rowan.kr  4/2/4/4/2/2/2/2/2/2/4/4/4/2/2/2/2/2/2/1/2/2/2/...\n",
       " 239  nia+017@rowan.kr  4/2/4/4/2/2/2/2/2/2/2/2/2/2/2/1/2/2/2/2/3/2/2/...\n",
       " 240  nia+017@rowan.kr  4/4/4/2/1/1/1/1/1/1/1/1/1/1/1/4/2/2/2/4/2/4/4/...\n",
       " 241  nia+017@rowan.kr  4/2/4/2/4/4/4/2/2/4/4/2/2/2/2/2/2/2/2/2/2/3/3/...,\n",
       " 'nia+219@rowan.kr':                 EMAIL           CONVERT(sleep_hypnogram_5min USING utf8)\n",
       " 242  nia+219@rowan.kr  4/4/2/2/2/2/1/2/2/2/3/3/1/3/4/4/3/4/4/2/4/4/4/...\n",
       " 243  nia+219@rowan.kr  4/2/2/2/2/2/2/1/2/2/2/2/3/2/2/2/2/2/2/2/2/2/3/...\n",
       " 244  nia+219@rowan.kr  4/4/4/1/1/1/1/1/1/1/2/4/4/4/4/2/2/4/4/2/2/2/2/...\n",
       " 245  nia+219@rowan.kr  4/4/4/1/1/1/1/3/3/3/1/4/4/2/2/2/2/2/2/2/2/2/2/...\n",
       " 246  nia+219@rowan.kr  4/4/4/4/4/4/4/2/2/2/2/2/2/2/2/2/4/4/2/2/2/2/1/...\n",
       " 247  nia+219@rowan.kr  4/2/2/2/4/4/4/4/2/2/2/2/2/4/4/2/2/2/4/3/4/4/4/...\n",
       " 248  nia+219@rowan.kr  4/4/1/1/1/1/1/2/2/4/4/4/4/4/4/4/4/4/4/2/2/2/1/...\n",
       " 249  nia+219@rowan.kr  4/4/4/1/1/1/1/2/2/4/4/4/4/4/4/4/4/4/4/4/4/4/4/...\n",
       " 250  nia+219@rowan.kr  4/4/4/2/1/2/1/1/1/4/4/4/2/4/3/2/4/4/2/2/2/2/2/...\n",
       " 251  nia+219@rowan.kr  4/4/4/1/2/1/1/1/1/1/3/3/4/4/4/2/2/2/2/4/4/4/4/...\n",
       " 252  nia+219@rowan.kr  4/4/4/4/1/1/1/1/1/2/2/2/2/4/4/4/4/2/2/2/2/2/2/...\n",
       " 253  nia+219@rowan.kr  4/4/4/4/4/4/4/2/2/2/4/4/4/4/4/3/3/3/4/4/4/4/4/...\n",
       " 254  nia+219@rowan.kr  4/4/2/2/2/2/2/2/4/4/4/4/2/2/2/2/2/4/4/2/2/2/2/...\n",
       " 255  nia+219@rowan.kr  4/4/4/4/2/2/1/1/1/1/2/2/2/2/2/2/2/2/2/2/2/2/2/...\n",
       " 256  nia+219@rowan.kr  4/4/4/4/3/3/3/3/3/3/4/4/3/3/1/1/3/4/4/4/4/2/2/...\n",
       " 257  nia+219@rowan.kr  4/4/4/2/2/1/1/4/4/2/2/2/4/2/2/2/4/4/2/2/2/2/2/...\n",
       " 258  nia+219@rowan.kr  4/2/2/4/4/2/2/2/2/1/2/1/3/3/3/3/4/4/4/2/2/2/2/...\n",
       " 259  nia+219@rowan.kr  4/4/4/1/1/1/1/1/2/2/2/4/2/4/4/2/2/4/4/4/4/4/4/...\n",
       " 260  nia+219@rowan.kr  4/2/2/2/2/2/2/2/2/2/1/2/2/2/4/4/2/4/4/4/2/2/2/...\n",
       " 261  nia+219@rowan.kr  4/4/4/4/4/4/1/1/1/2/2/4/4/4/4/4/4/4/4/2/2/2/2/...\n",
       " 262  nia+219@rowan.kr  4/4/4/1/1/1/1/1/1/1/1/2/4/2/2/2/4/4/2/2/2/3/3/...\n",
       " 263  nia+219@rowan.kr  4/2/4/4/2/2/2/4/4/4/4/2/4/4/4/4/4/4/4/4/4/4/4/...\n",
       " 264  nia+219@rowan.kr  4/2/1/1/1/1/2/2/2/2/4/4/4/4/4/4/2/2/2/2/2/2/2/...\n",
       " 265  nia+219@rowan.kr  4/2/2/2/2/4/3/3/2/4/4/4/4/4/4/4/3/2/4/2/2/2/1/...\n",
       " 266  nia+219@rowan.kr  4/2/2/2/2/2/2/2/2/2/4/3/4/4/4/4/4/2/2/2/2/2/4/...\n",
       " 267  nia+219@rowan.kr  4/4/1/2/2/2/4/2/2/4/4/4/2/2/2/2/2/2/4/4/2/2/2/...\n",
       " 268  nia+219@rowan.kr  4/4/4/4/2/2/1/1/1/1/2/4/2/2/2/1/1/1/1/2/2/1/1/...\n",
       " 269  nia+219@rowan.kr  4/4/4/4/4/2/2/2/2/2/2/3/2/2/2/2/1/3/1/2/2/2/2/...\n",
       " 270  nia+219@rowan.kr  4/4/2/2/1/1/1/3/1/1/2/2/1/1/2/2/2/2/2/1/2/2/2/...\n",
       " 271  nia+219@rowan.kr  4/2/2/2/1/1/1/1/2/2/2/2/4/2/2/4/2/2/2/4/4/2/2/...\n",
       " 272  nia+219@rowan.kr  4/4/4/2/2/2/1/1/1/2/2/2/1/1/2/2/2/1/1/2/2/1/1/...\n",
       " 273  nia+219@rowan.kr  4/4/4/2/1/1/2/1/1/1/2/2/2/2/3/2/1/1/1/1/2/2/2/...\n",
       " 274  nia+219@rowan.kr  4/4/2/1/1/1/1/4/4/4/2/1/1/1/1/1/3/3/1/4/4/4/2/...\n",
       " 275  nia+219@rowan.kr  4/2/4/2/4/2/2/2/2/1/1/1/2/2/2/2/2/1/1/1/1/1/2/...\n",
       " 276  nia+219@rowan.kr  4/2/2/1/1/1/2/1/1/1/1/2/2/2/2/1/1/1/1/2/1/1/2/...\n",
       " 277  nia+219@rowan.kr  4/4/4/4/1/1/1/1/1/1/1/1/2/2/2/1/1/1/1/1/3/3/2/...\n",
       " 278  nia+219@rowan.kr  4/4/4/2/2/2/2/2/1/1/1/1/2/2/2/2/4/2/2/1/1/2/2/...\n",
       " 279  nia+219@rowan.kr  4/4/2/2/2/1/1/1/1/1/2/2/2/1/1/1/1/1/1/1/1/1/1/...\n",
       " 280  nia+219@rowan.kr  4/4/2/2/2/1/1/1/1/1/1/2/2/1/1/1/2/2/2/2/2/2/2/...\n",
       " 281  nia+219@rowan.kr  4/4/4/4/1/1/1/1/1/1/1/1/1/1/2/2/1/1/2/2/2/2/2/...\n",
       " 282  nia+219@rowan.kr  4/4/4/4/4/4/4/1/2/2/1/4/4/4/4/4/4/4/4/4/4/4/4/...\n",
       " 283  nia+219@rowan.kr  4/4/4/4/4/4/1/1/1/4/4/4/4/2/2/4/4/2/4/4/4/4/4/...\n",
       " 284  nia+219@rowan.kr  4/4/4/1/2/2/1/1/3/2/2/2/2/2/2/2/2/3/2/2/2/2/4/...\n",
       " 285  nia+219@rowan.kr  4/2/2/2/2/2/1/1/1/2/2/1/1/1/1/2/2/4/3/3/4/4/4/...,\n",
       " 'nia+230@rowan.kr':                 EMAIL           CONVERT(sleep_hypnogram_5min USING utf8)\n",
       " 286  nia+230@rowan.kr  4/2/1/2/2/2/2/2/1/1/2/2/1/2/2/2/2/1/1/1/3/3/3/...\n",
       " 287  nia+230@rowan.kr  4/4/4/1/1/1/1/1/2/2/2/2/2/2/2/1/1/1/1/1/1/1/2/...\n",
       " 288  nia+230@rowan.kr  4/4/4/1/1/1/4/4/4/4/4/4/4/4/4/4/4/4/4/4/4/2/2/...\n",
       " 289  nia+230@rowan.kr  4/4/4/1/4/4/4/4/4/2/2/1/1/1/1/2/2/2/2/1/1/1/2/...\n",
       " 290  nia+230@rowan.kr  4/4/4/4/4/4/4/2/1/1/1/1/1/1/1/1/1/1/1/3/3/4/2/...\n",
       " ..                ...                                                ...\n",
       " 368  nia+230@rowan.kr  4/4/4/4/4/4/4/4/4/4/4/4/2/2/2/2/2/1/1/1/1/2/2/...\n",
       " 369  nia+230@rowan.kr  4/4/4/2/1/1/2/1/1/1/2/2/2/2/2/2/1/1/1/1/1/1/1/...\n",
       " 370  nia+230@rowan.kr  4/2/4/4/1/2/4/4/2/2/2/1/1/1/1/1/1/2/2/1/2/1/1/...\n",
       " 371  nia+230@rowan.kr  4/4/1/4/4/4/2/2/2/2/2/1/1/1/1/1/1/1/2/2/1/4/1/...\n",
       " 372  nia+230@rowan.kr  4/2/4/4/4/1/4/4/2/2/1/1/1/1/2/2/1/1/1/1/1/1/1/...\n",
       " \n",
       " [87 rows x 2 columns],\n",
       " 'nia+139@rowan.kr':                 EMAIL           CONVERT(sleep_hypnogram_5min USING utf8)\n",
       " 373  nia+139@rowan.kr  4/4/1/1/1/1/1/1/1/1/1/1/1/1/1/1/1/2/4/2/1/1/2/...\n",
       " 374  nia+139@rowan.kr  4/4/4/2/1/1/2/2/2/2/1/1/1/4/2/2/1/1/2/4/4/4/4/...\n",
       " 375  nia+139@rowan.kr  4/4/1/1/4/4/4/2/2/2/1/4/4/4/1/2/4/2/2/1/2/2/2/...\n",
       " 376  nia+139@rowan.kr  4/4/4/4/4/2/2/2/2/2/2/1/4/4/2/2/2/2/2/2/2/2/2/...\n",
       " 377  nia+139@rowan.kr  4/2/4/1/1/1/1/1/1/1/2/2/2/2/2/2/2/2/4/4/4/2/4/...\n",
       " 378  nia+139@rowan.kr  4/4/4/1/1/2/2/1/1/2/2/2/1/2/2/2/2/2/4/2/2/2/2/...\n",
       " 379  nia+139@rowan.kr  4/2/2/2/1/1/1/1/2/2/2/2/2/2/2/2/2/2/2/2/2/2/2/...\n",
       " 380  nia+139@rowan.kr  4/2/1/1/2/2/2/2/2/2/2/2/1/4/2/2/2/2/2/2/4/2/2/...\n",
       " 381  nia+139@rowan.kr  2/2/2/4/4/1/1/1/2/2/2/2/2/2/2/2/2/2/2/2/4/2/2/...\n",
       " 382  nia+139@rowan.kr  4/2/2/2/2/2/1/4/2/2/2/2/2/1/1/2/1/1/2/2/2/2/4/...\n",
       " 383  nia+139@rowan.kr  4/2/1/4/4/4/2/2/2/2/2/1/1/1/1/2/2/2/2/2/1/1/2/...\n",
       " 384  nia+139@rowan.kr  4/2/2/2/2/2/2/4/4/2/4/4/2/2/1/2/2/2/2/2/2/2/2/...\n",
       " 385  nia+139@rowan.kr  4/2/1/1/1/1/3/3/2/2/3/2/4/2/2/2/4/4/4/4/4/4/2/...\n",
       " 386  nia+139@rowan.kr  4/2/2/2/1/1/1/1/1/1/1/1/1/2/2/2/2/1/1/1/2/4/4/...\n",
       " 387  nia+139@rowan.kr  4/2/4/4/4/4/2/2/4/4/1/1/1/2/2/2/2/2/1/1/2/2/2/...\n",
       " 388  nia+139@rowan.kr  4/2/2/1/4/1/1/1/4/2/2/2/4/4/4/4/2/4/4/4/2/1/1/...\n",
       " 389  nia+139@rowan.kr  4/4/4/2/2/2/2/2/1/1/2/2/2/2/4/2/2/4/2/2/2/2/2/...\n",
       " 390  nia+139@rowan.kr  4/2/2/2/2/2/2/2/1/1/2/2/1/1/1/1/1/1/2/2/2/2/2/...\n",
       " 391  nia+139@rowan.kr  4/2/2/2/2/2/2/4/2/2/2/2/2/2/2/2/2/1/1/1/1/1/1/...\n",
       " 392  nia+139@rowan.kr  4/2/1/1/2/2/1/1/2/2/1/2/2/1/2/2/2/2/2/2/2/2/2/...\n",
       " 393  nia+139@rowan.kr  4/4/4/2/2/2/2/1/2/2/1/1/4/4/4/4/4/4/2/2/2/2/2/...\n",
       " 394  nia+139@rowan.kr  4/2/2/2/1/2/1/4/2/2/2/2/2/4/2/2/1/1/1/4/4/2/2/...\n",
       " 395  nia+139@rowan.kr  4/4/2/2/2/2/2/2/2/1/2/2/1/1/1/1/1/1/1/2/2/4/4/...\n",
       " 396  nia+139@rowan.kr  4/4/4/4/4/4/2/1/2/2/2/2/1/1/2/2/1/2/4/4/4/4/4/...\n",
       " 397  nia+139@rowan.kr  4/2/1/2/1/1/1/2/2/1/1/1/1/1/2/2/2/1/1/1/2/4/4/...\n",
       " 398  nia+139@rowan.kr  4/4/4/2/2/2/2/2/2/1/4/1/2/2/2/2/2/2/2/4/2/2/4/...\n",
       " 399  nia+139@rowan.kr  4/4/2/2/2/2/2/2/2/2/2/2/2/2/4/2/2/2/2/2/2/2/2/...\n",
       " 400  nia+139@rowan.kr  4/2/2/2/2/2/1/1/1/4/2/4/4/2/2/2/2/2/2/2/2/2/2/...\n",
       " 401  nia+139@rowan.kr  4/4/4/1/1/1/1/2/2/2/2/2/2/2/1/4/4/2/2/2/2/2/2/...\n",
       " 402  nia+139@rowan.kr  4/2/1/1/4/4/2/2/2/2/2/1/1/1/2/2/2/2/1/1/4/4/4/...\n",
       " 403  nia+139@rowan.kr  2/2/1/4/2/2/2/2/2/2/2/2/2/2/2/2/2/2/4/2/4/4/4/...\n",
       " 404  nia+139@rowan.kr  4/4/4/4/2/2/2/2/2/2/2/4/2/4/4/4/4/4/4/4/2/2/4/...\n",
       " 405  nia+139@rowan.kr  4/2/2/2/2/2/2/2/2/2/2/2/2/2/2/2/2/2/4/4/4/4/4/...\n",
       " 406  nia+139@rowan.kr  4/2/2/2/2/4/2/2/2/2/2/2/2/2/2/2/4/4/4/4/4/4/4/...\n",
       " 407  nia+139@rowan.kr  4/4/4/4/4/4/4/1/1/1/2/2/2/2/2/4/4/2/2/2/2/2/2/...\n",
       " 408  nia+139@rowan.kr  4/2/2/2/2/2/2/2/2/2/2/2/2/2/2/2/2/2/2/2/3/3/2/...\n",
       " 409  nia+139@rowan.kr  4/2/2/2/2/2/2/1/1/2/2/1/1/2/2/1/1/2/2/2/2/2/2/...\n",
       " 410  nia+139@rowan.kr  4/4/4/2/2/1/1/2/2/4/4/2/2/4/4/2/2/2/4/2/2/2/2/...\n",
       " 411  nia+139@rowan.kr  4/4/2/2/2/4/4/2/4/4/2/2/2/2/2/2/2/2/2/2/4/4/2/...\n",
       " 412  nia+139@rowan.kr  4/4/2/2/2/2/1/2/4/4/4/2/2/4/4/4/4/4/4/4/4/4/4/...\n",
       " 413  nia+139@rowan.kr  4/2/2/2/4/4/2/2/1/1/1/2/2/2/4/4/2/1/1/2/2/2/1/...\n",
       " 414  nia+139@rowan.kr  4/4/4/1/2/2/2/4/2/2/2/2/2/4/4/4/2/2/1/4/4/2/2/...\n",
       " 415  nia+139@rowan.kr  4/2/2/2/2/2/2/1/1/1/1/1/2/2/2/2/4/4/2/2/2/3/2/...\n",
       " 416  nia+139@rowan.kr  4/4/4/4/1/1/1/2/2/2/2/2/4/4/4/4/4/2/4/2/2/4/4/...\n",
       " 417  nia+139@rowan.kr  4/2/2/2/4/2/2/2/2/2/1/2/2/2/4/4/4/4/1/4/4/2/2/...\n",
       " 418  nia+139@rowan.kr  4/2/2/2/2/1/4/2/2/2/2/2/2/2/2/2/2/2/1/1/2/1/1/...\n",
       " 419  nia+139@rowan.kr  4/4/4/2/2/2/2/2/2/2/2/2/2/2/2/1/1/4/4/4/4/4/4/...\n",
       " 420  nia+139@rowan.kr  4/4/4/1/1/1/2/2/2/2/2/2/2/2/2/2/2/2/2/2/4/4/2/...\n",
       " 421  nia+139@rowan.kr  4/4/2/2/2/2/2/4/4/4/2/2/4/4/2/4/4/2/2/4/4/4/4/...\n",
       " 422  nia+139@rowan.kr  4/4/1/1/1/2/2/2/2/2/2/1/1/2/1/1/2/2/2/2/2/2/2/...,\n",
       " 'nia+306@rowan.kr':                 EMAIL           CONVERT(sleep_hypnogram_5min USING utf8)\n",
       " 423  nia+306@rowan.kr  4/2/2/2/2/2/2/2/2/2/2/2/2/2/2/2/2/3/3/3/3/3/3/...\n",
       " 424  nia+306@rowan.kr  4/2/2/2/1/1/1/1/1/3/3/3/1/3/2/2/2/2/2/2/2/2/2/...\n",
       " 425  nia+306@rowan.kr  4/4/2/2/1/4/4/1/2/2/2/2/2/2/2/2/4/4/4/4/4/4/4/...\n",
       " 426  nia+306@rowan.kr  4/2/2/2/2/4/4/4/1/2/2/2/2/2/2/2/2/2/2/2/2/2/2/...\n",
       " 427  nia+306@rowan.kr  4/2/2/2/4/2/3/3/2/2/2/2/2/1/2/2/2/2/2/2/2/2/2/...\n",
       " ..                ...                                                ...\n",
       " 492  nia+306@rowan.kr  4/2/1/1/1/1/2/2/2/1/2/2/3/3/3/3/3/1/2/2/2/2/2/...\n",
       " 493  nia+306@rowan.kr  2/4/2/2/1/1/1/1/2/2/2/2/2/2/1/3/2/2/2/2/2/2/2/...\n",
       " 494  nia+306@rowan.kr  4/1/1/1/1/1/2/2/2/1/1/1/1/1/3/1/1/1/1/3/2/2/2/...\n",
       " 495  nia+306@rowan.kr  2/2/2/2/2/2/2/2/2/1/2/2/1/1/1/1/1/1/1/1/1/1/2/...\n",
       " 496  nia+306@rowan.kr  4/2/2/2/1/1/1/1/2/2/2/1/1/1/1/1/2/3/1/1/3/2/2/...\n",
       " \n",
       " [74 rows x 2 columns],\n",
       " 'nia+196@rowan.kr':                 EMAIL           CONVERT(sleep_hypnogram_5min USING utf8)\n",
       " 497  nia+196@rowan.kr  4/2/2/2/1/1/2/2/1/2/2/2/2/2/1/1/4/2/2/2/1/1/1/...\n",
       " 498  nia+196@rowan.kr  4/4/1/1/1/1/2/2/2/2/4/2/2/2/4/4/1/1/1/2/2/1/4/...\n",
       " 499  nia+196@rowan.kr  2/2/1/2/1/1/1/1/1/2/2/1/2/1/1/1/2/1/1/1/1/1/4/...\n",
       " 500  nia+196@rowan.kr  2/2/2/4/4/4/2/2/2/2/2/2/2/2/4/4/2/4/4/4/2/2/1/...\n",
       " 501  nia+196@rowan.kr  4/1/4/1/1/1/2/2/2/2/2/2/2/2/2/2/2/2/1/4/1/2/2/...\n",
       " ..                ...                                                ...\n",
       " 566  nia+196@rowan.kr  4/1/1/1/1/1/4/2/1/1/1/1/1/1/2/1/2/1/1/2/4/4/4/...\n",
       " 567  nia+196@rowan.kr  4/2/2/2/2/2/1/1/2/2/3/2/2/2/4/4/1/1/2/3/3/2/2/...\n",
       " 568  nia+196@rowan.kr  4/2/2/2/2/2/2/2/2/2/2/2/2/2/2/3/2/2/2/2/2/2/2/...\n",
       " 569  nia+196@rowan.kr  4/2/2/1/1/2/2/4/4/4/4/1/2/4/4/4/4/4/2/2/2/2/2/...\n",
       " 570  nia+196@rowan.kr  4/4/2/2/2/2/2/2/2/2/1/1/2/2/2/4/4/4/4/2/4/1/4/...\n",
       " \n",
       " [74 rows x 2 columns]}"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Dem_hypnogram"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "8a64d077",
   "metadata": {},
   "outputs": [],
   "source": [
    "Dem_concatenated_hypnogram = {}\n",
    "\n",
    "# 각 이메일 주소별로 데이터를 이어붙임\n",
    "for email, group in Dem_data.groupby('EMAIL'):\n",
    "    Dem_concatenated_hypnogram[email] = ''.join(group['CONVERT(sleep_hypnogram_5min USING utf8)'].str.replace('/', ''))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "59bf08fb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'nia+017@rowan.kr': '2323322211211111133333322222212211111111224332222222222222222222222422332222211111333233333222444423323444442222222221122444443324442222334422221111222222222333322221122222111111233242233244233244424221113223322212222222111111222233332222211112221122222224424222222223333333244444441322444444442222222222221113333222222222222222223322222221111133244444444222224243222222111122244324422222111111444222222222242244244443222222233444421222222224444444422224422222222333221333221111323322224422222112222232323322242222222222113334444444222221222333222111111114222322324413332333322444244422222222222233222222222223332322224444222334221111112432344222222111112223332222213222222221144444222112111233333332222111122233324442242222211112223242322222111111112222224444222223223333333222332244422222222223322233444411221122133222111111113333422222222233332222232222223322222111221122244422222224422111123333222222322222233322211111132222222422244422222211122222222222322222211222222222334221112422221111122342344222222222233333333244322222222112233334442344422221111111443332222211222222222222232422223222233444222222222122222221444221122221111111111112444333222222222222222222233332222442443442444444244322223333333444422222221111122222224444422221111124422333343444422222221111222233242222222344333233444222222224443333444112211111233322222222222222222223334444444444342222144222222211222223334442111112222222441221111112333344222221122222222232222222222323333334332322223344333242222222332442443444222242222222444444441111222112332333221111111113333322322222222223322222244442223332222222222333344444422222222144442222222222223322222222233322211111111122444444444444444242222222111444212221112111111114411442222111134433222222222223322222222233332333332232333322222222222344444122111133322222111221222222222223333334424442422222222222333322222222222233332443332232222222244422144122111111332233222221111123221114424444233222222223334422222222222344322222222233334444222111442222444444442222222222111113342322221111122224444444222222222233344432444244444444422333344444233344422111111113442222244222222222223333224444222211221223332223222222222333444444224422222114444443344222222222444444444444444444444444444232444444224444442322222222222222223333333222222222333334422222111113222222222442211111122222111112333332222224433333432222224444442422111424424222221113333322422222222122222342232223244422222111123433443444444244444442222244222222444441444442442221111123333344221111111122233333322222444222222222232223334444444442221111132223342222222333111322222222222332232444422211111112112222222223242333423322222333222344444111111122333344422111111123324243334222222222234222222222322222344444422111111322333222222111111332232222222213333333322222222223223332222222122222222444422444444121111111122332432111121222234423333332222222222233332324422424232222444422211111233333332222111111111112332222442221111112224432444322211111133433444444444444222222211114422222222111444111111112333332221111244422222222233444422211111113342222111112221113332233222222222222223332232222224443333433223344332223333444442221111123344444444222222221122333422211222211233332422322222222333333244422211111113222222222222221112333322222222222112223333222333332442222211333233333333222234444222122111344222222222222122221222211223333324222222232222334442111112221144221132222221221112223332221111123322232232233333333333322444422221122222233322213333332232221112221111123222333322222222222234423311221114444242211442222111112332222222222221232332333322112111114222212233333344443332222222344333222333222444222222244423222111111223333232222111111133222222222322232222443444244442422211111111222233333332212221123222233333333322222222222233222222224444444444442222222222242222244344422222222224222222222244444444444442222222224444422222344444444444444444444444424422222324422232233323333323444444444222222222444422144444442222242222222332222222222223332224444233222233244444444444444444442324442222432223223222444442222222222242222222112222222224324222221111224422233333232222333322222442332222334444224424444244444222442212242221222222222222222444222222222221124422222222222233442222332222222324423333322224422333324444444444444444444444444422233322233333333334442442334442222222222242211123222244322222222223144222223322333322222442322222332222224433344442221111111122222222222232222244222222222322221112322212132233333332233332222222244444411122222223222222232432222222222222222222211122442422222222224422223223222233343422222222244442111111112222222444133222222222322322222222222222233333332444222222222222223322322333444424444444444444444444444442324432223323433333322233343344244222222444222222122222244221111232423332333222443324442322222233222322244224242444424422222222222122223222211222222224222232222222222222242332444222222222222433333333333444442424223334444421111111111142224244422222222222222232222222234422222222224424444224444222222332333344444244443444242444224422222222223322223222222432213244221422422222221113222222333224444433422442222222224',\n",
       " 'nia+067@rowan.kr': '424422222222222242212332222344222224424222222222222222444444224322233322222223222222222222233222222222322333224232223332224422322222122222222222222222422222222222233332322223342232222222222222222222233322332222423444442244221112244224444411111121121221221122222222222222222222222222122222222222244222222233333322222222233334444424424422221122344422444211112111122422442112111222222222221232222222223222222222242223333334223444434442124422211111444222442222244422211121112222224443322224422222222222222222243222233322223442333333333344422222222244422212222114422234444424422222222122222322224442222222211222442232224423322244223332223333443422222444243332244444444422222222332222222222222422224433133233332222242224442222222443222332222222222222332222222222222223333333324444244441221424444242221222222224422222222224332222222222222211442233333242222332232222222222242244444444243424222223334442444244444444444444444424444444244442222222222223444424244222222111111122222222222444422222222222222222222222224422232222233333333223332333222422222333444422333344222212222224422222222211224442222222222242222222222222233333222222222222333322222223244222222244422223333442224433344444223132244223222222222222244222221222222222234444242222222222221112222222222222222233324344444444443333344424444444444314442222222221112222322222242222224422222222222222222322222222222222422222333333333322343332222222222233324444222422222211111244222442222111222111333333444222322211331222333322333332222442222322222222334422222222224222233334444444444442444442442444222444444444222311114222242231222222122322332223222222222222244224422222222222222222222222323223333332322442442222332234444333442411444444444444114444444444422221221222222222244422222222222232222222222222222222222322233122222222222222222224222322332244233333333333322444411311444444422221112224422222222244222222222242222222222222222224233222222222222223333244423333233222422233333344424244444442422222222222222442221111122222223332442222222222222222232232223322232222323222333332442222222232222222222224333244444444444444444444444444444444444424244444444444444444424442441134422242222221111121442222222222222212223223444322212222222222222244222222222334443333333333333332222232233232234444414444444444244144442222111444422224442222244222242222222333222222222222224222222222332222244233433233332223222222222222234423323222222233333344444444444314422112212222222222222122223222222222444422222222222222222322222222222222333323332222222242333332222233333333222232423222444444444422222222231312222223222122211122222234444222222222222333344444222222222223222222222222222222222422222223333333344442231221122233222222344444444422222222222222111222223221322222222222322222113332442222442223332222222333332223322222244233322444444444444444444442333442444443222224432444211344224422233113344443342224444233322224222111222222222222242223222222222442333342222222222222222222322222222224222222222222333222222444424421233332211122222224233222222222222222244212222222222222432222222232222243322322224222222222222222332222222222234444444444444444444444444422222344222222222344442222212232232233333322222232222222333333233322224222222222322423222222233222322222222222222222233222222443444244444444333322222222244244444424422222222222222234423344431122222342332442223322222222222244222222222222222232222222222244233233333322244444444424444222444444222222222222222222222242444242222222222333222224222222222233333322233333442322222222244222232222223323333222423233444444444111111222222222222222222424422222424422222212222242222222231112222222222222224222222222222222322223222222232334333322223332423332222233333333433333334442444442221222221133312244442422222222222222233242222224222224222332233322222322442222222223222244222333333344442414444422222222222222222211122222222222222222222131424444442244422222234233224222222222222222223322332423333223324424444432233244222222112222222222222222222443422222222222222444442223222222223222233222232444444444444442444421244422244444444444424444444444442434224444424211444442431142244324222222222222222222222222222222222222222233322222222212222222244442423222233332223332224222332244444444444444444442444444424444444444444444444244444424442224444444444244442334223422222222223222222233324431131312224422422222222222224222222322222222222223222222222222222324444222223442244422222332442244444444422222222224333442242222232332222222224222222222442322222222222122232222222344222442333444444224442222224444244444444222224422222224444442222222232222222222222442333322222333233442322442223423444442224422212214422211124421112211233312222222222222222244222222221222222223322222222222222232322233444333334433324423344233444441222222422333222242221112222222222222222222222222222233322242222222223333322222222222222222223223333332423444433333344222222222224422222224422222222222222224422222222442222212222134423322222222233222442233211222222222442332223423333222223332224444444444444444444444424344434442423333333333333444244444444442222221232222224222224442444422222222222242333322222222223332224443222222222222224442222232222222332442222222223334422333332223344444422122222422421111113332244222222432222222222234244222222122222222234222222222222223244222222223332344222332242423222233333333333344444221222222222222444422422222222114422222223344333323332222222222222223222333442222222222222222344222222223333333333324433344444422222444422222222222222442424222222222222444424222222222222222223322232322222223333333332222223222224433344444444412111443322222344322222222222222242223224444424442222222222222222422211122222233333333333222222223333333344442222222111111333222222222222224442223224444422222222442322233322222233222332244222222222222333222222233334442332222222211114244423222222222222123222424424422222222222244223333244222332222222233333442332222222222442222222222344244422223344442443334444111244444222222443442222223441222222222222224242222221122222232222222222222222222222222244222222222223333344333334422332344444444444444444444444424444444222222242222222222222222222222244222333332222222223442222222222222322224423322222222222223333333332222222233333332222222242332233344444112422112122224222222111133332233222111111442222222222224223222222222333333324233333444423442334444444444444444442422442244442222222222222344442333223334423311222332222224422222222222444222222222222223322222422222222222222234433223322222443322244233442223344333334442444422212421122422222222222243142222222222224422222222222223322222223322222324222222333322244334444422222222222444412222222222222244422222324442224422442222322224422233323113333324444444444244434443444421111234422211112224422222222221222222222222222422222222222442222222222223332222233322243222222322222333333222423222234342222444444444444444444222422223442222222223333244222222244442244222222222222222222224222222222222122223334342443242222222334222222224444244444244442144443111144222242222222222222222222222222322222222222221223222222222222244332342222222333233324434443344444444422222222222222211111134222242222222222233332442222222211223332222332222222223332222222222222333333324222244444444444444222223322223422244444444444422221111422211222212222224224222444444442222221222222222222222222442222222222332222222222222333233322223334442442244222221222222222222222222442222442211123222322223333222222222222222222232222222222224232222224433333322223344422222222222111112222222222422222112222444211222222422222222224322333221223344232222222222242224242444432232233333333334424244444444444442222244222244433442242222122242222333332224443222222222223434322222222222222233222222222222222222223344222222222222223333444222112442222222222241111242223333333332322322222222222242222244444322222222223222222222222223244223223233422344442221111212222221122112423221423222222222243222222222222222222222422244222222222222444422222113222422221122144222132222222222222222222224444422222222222223222222233324422222233222334333332224444442222222222222112224442222222222222222222211212222222242222222222224422222222422222223333422222423334222333444244444444444444414244442442222122222444444422222222222222222224422222222222222222222222322332222233324423444422221121222223222222224422222224222222222224422222222222222223332224222222222222222222222442222222222233222222222223332224444444233111111442222332222111122221244422422222222422222244222222212222322344222222423233323233242222333242324422224434433224444444444222222443141114444222222223444444424442333444422222222222333332222222222222222224422222332223222222222222222333332222222224444222224423333344441424444442222222222222122222222222444442224444222222334222111122442222244222222222232442332223222223333333333344442444333314333324422442222222244222222222222222222222224242222222332222223322233444422221111111121122224222222244242224422222233222222222222222322222242333322222222233322333323332234423344222211112222212442111222422111111142222223244222221224422233444444444322224222222232222134444222222114221122332444111122222443332222442333222222223222222222222222222222244422222222222112222222222242222222222222222222222122144422222222222222222222322222232223333333324424433233344222222422222211444222333332442222222222223344442222222222222244222222233442224433444222333334424442221112222222222222222222122242224422311222444332332222221422223322222442222222223323333332222242333344',\n",
       " 'nia+139@rowan.kr': '4411111111111111124211213244444444422444242222223333322243444244444442424444444444444444224422221122212322222222222222442222244444222444421122221114221124444442444442221222222242244422212222222222111111144411444222144412422122222222224422211444422222222222222222222222222222222222242222222223222222222222222222332322322333322322222222333222222222222222244444442222221442222222222222222222222222222222222222222222222222444222222221222222222444244444444444444444444442243333344423333222444224442411111112222222244424444221224444422222221222242222222222222242222122222222222222222222222333222244444112211222122222422222222222222222422222222222222211333444442222111142233444444444444444424424423244422211112222222222222222212444422222222424444442111122211122222223344222222222222243322222222233333344333244442444211222222221422222242244442442444422222222222222211122212444242224444222442224411122222222222242222222222222222222222111122442222222111222222222222111124424442222222224222222224444444444444444444444334444444333322333322222223322444222221422222112112222422444442222222222222222224222222442224222222222222222244421444222221111222221124444442224442222221122242242222222222222224222222244422422222222222242222222222222222222222222222222222222223223333223322222222222332233222224442222224424422122222222222242224442222222222111222211222222222444211113322324222444444244442242244222441112211143442223222221111122222222222222222224331144222233222222211422232222222222233244422211111111122221112444222222222222222222442424222222122222442222242222222222221222222222222222222444444444422222222222224424444224411122222112222222222232222422211244242222221133331111332222222224442344222221244444442444444444222242222224442444423332222333344224444442222233223332222343322233322222444422141114222444424442112212222444424222222222242122422424422222242222222222233222422222222222222222333222114322222222233333322224444422222112222422422222222244424444442222222241112244222244222222211221111112222244244444444422222244444444224442424222222222222224442222244222222444422222222222211222223223224223223342442222242223333422222222234424422222224442222224222222222111111111111222444444444444444444444444412222224244422222222222422223222322222442442112211221221222222222222222444444444444424424444444424412222224222222222422444422222222222242222222212222222222422222243242222442444442232222222211444422221221144444422222211221122222222222222222221222222222224222233233323334424422244442222244444444444444444444444442222233322222333322232222223344422212142222242211144222222222244444422242244444422444444444422224222222222224422222222222224444222222212211111112244422244422244442444222222222422222222422222222222222222222222222222222242222322223322222222322222222242222223332222322332222222333222332222222222444444442122221122124444442224444444444442222232222222111132333342222344422222422422222242322223323224442222222222222222223222222222222223444222222333224421211122111112221112444422222222442222222244222224422424444444444444444444444422222242322222214222222323333333344424224444422222214122222224224444224224222244441211122122212112222122222124422322224222422222224244222444422222222222242222222222222222222212222222222222222322222222234442222211142442222222222222222222244444411112222221112222222221224322222222222442222222212444222222222222244244442244444444444444444444222222222222232233221132222444444411112222222144222222222422222222112222222222222222222122244424444444444444422244242222242222233324244211442222211122221144444444444442222444444424444444444444122214244222444222112444222222244222224244222222422222222222222222222222232222222233222344221422222222222222424444224444444444412221422222222222222244422221111222244444444444444444444444422444221223122222233233333222333333222222222222333334444442222222424444444224422222222244222444442211222122222222222222222222222222222222122444422222222222222222444244444444444444444444444423322233233333222244422222222222222222444444444444224222222224444412244444444442212222112222222322222222222222224422222222322222222222222222222222222222222224442222422222222224444444422221114444444411222222222222222244444444411122222442222224444241121221222222221111222222222222222222233222222222244422222222222222222223322222222411222222222224422222222222222222222222222222222244444444444444444444444423222223333333322222242222223334424444444444444444444444233222244424444443444422222211221122112222222222222442211111221114212224442421122211222222222244444221122442244222422222222224442224224224444444242442122222222222222222422234444444444444444444444444444423344222222222222222244422244244222222222244221442222222222222222222222222221132222332222222222443333222222222222222222222222244422222222222444422221244422444444444444442222442222224444444444444444412244222222244422422222222244222222244442222222222222222222222224222222222222222222222222222232442222222222444222442211122244211222111242444442444442222222222222222222222222244422222222212222222222222222222224224444444412224222224442214422222222222444222212112222222222222222222222244221112222222222222222224444444444444442222332233333333333433333222222222244222222111112222442223222222222224441112111112222222221222221111222222122333244122222222242244444332424244444244444442244433344333322332222244444441112222244444242244424422321133222222222222222222422442222222222221222222222222233332232444444444444444444444424422234444444443322332442224222221222444414422232222222224224433444222222121222221112332221222223232222222223322422233344422221422222222222112111442222142224444444222222222222222221212221122122222444444222222222222114444442222222122222233122114222222224222222222222444444222442222233444444444444444424444422222222222223333333322222322222222333334444411122222222222222442242244442124424422224442242442222444444244444442444422222222322222332324444442222244422442442244442111222242422222422221442244422244122221111442222222222222222222222222222222222444224333222444411122222211211222222222222224442223222222222222244122222211332232222244',\n",
       " 'nia+196@rowan.kr': '422211221222221142221111444212214441124421423242442211222222222224422442442442222222222444222222222222233222332233222224422222222223332322223322222222233244224441111222242224411122142221222222122442222222442422244222222111122244222222222222222222221244424422442212111112212111211111442211112221224111111111421221222224244441442312211222222222222332233113333213221223331334422244422222222442444221122222422222222221442212222222222222224422222422442222222222221211222222222222222222222332222222222222244422222222222222224441411122222222222214122224442224222222244444424422222222222222224222233222323333343333333322224444212222212222222212322222222233333332233332444333444414442222222222444241442222222144222222222222244422244222222244422222222222224444442222222222222333424442422233222223333333333333344222333244424444422222111121122211422222241112224414111122422111112112221111112222444442222442444422222233322242222333322224422223333444224214214411444411111112211222222244441144244411444444444444444444444222222223342422222333322222222222223322222322233322224422223222224222222222232222222333333334442224441111244112142111144421142221444442224422222222422222222222422234222222242222222232222222222222333323333333244422222222222211222222222223332444421242114421124224424424422224444224422222222242442222222223222222224444422222222222222222222222232232233322333423322222224444441334222233222231322444242224411224422244421222242242422112222121211111222112211122244212322222333242222222332222222244422444233222222444422332232222444222223333333224421122222141244441111444144124422242144114411122222224222222242222224422222342444442222224442222223323333321222223333222224442222222444422442222244222233232222222233333444211111111121221121221222222112222222222242222222333333334444444422221121122241221221441222222222224444444444444411241112222223222224222211222322232442232222322222222222334332333323332222244424423222223223333333322332422233233222233324222222222441114412222222224444112111122112212222222222224222222442422222222222222221122222224244422332222222222222223222222223333324231444444442242324442224142212222244444421122122422224444244244221122444444222122112222442211222242112222222221144422222223333244222222224222242222244233444424442444441113244322223333334442122222222421124244411122222222122224212111222222222222222222222221222222222222222222123142442222221133332222244444444444212222444424444422412242222222222224444444444442224224222223244444422222233222232244244422322422244224224422422224222333332231332434422222222222222222222222222222222222242211111112444444412224442111122222222222222223422224444242222244234444222444222442222222222222111442222242222222233222222223333324424222222422244224444422222224144442222442222222242444422244444444442444244222222224442222222442222222222242222444422222222222322222222242224444222424422222222222222344422223222223222233222222444422222441111222144244441112222224441122224224224444212221441112244112212211111222311212222222221112242122242442224444444423333333322334224221114224424422112224441242211112242222444442221112211421231314422221223333222214222232444421423222244444444441222411122224221444444422244444444444224244441111112212222242232334244442322222322222223332232233343224422222443222222331333222222333222222222244421222222222222444444444442121144422222444224211442424222222222322222222222222223222112222222222222222222222222222222221112111444444222222222232222222242244441422142222222244411224444244444442124444444424422422222242222222442212222222224442222222222222223222213333333333222244442222342333442421221212211112222224214444444222241222222222442222444422224444422122444222233222224444222324442322332223324224444444422244222244444444422222222424444424422222222244422442222224244244422224422212222241112222222222222222222222222222222422222222222222222222222224422111442212424444423423333324444424222441111444442121122211144244441141122222222222221242424442222444442222222222222244444222222442222442224222222222333222222222444232222222432244222222222333442433244222222244444444444444124221422111442444424444111111144222214441142222424242222242242222222244442222442222222222334422222222322242344222223332233223113233442222324224222444222112222212222222244424112244422442444122222222222244222122222222222144422222222422224222222222222442222222244224222222222233233333322324444444444444422212442244112244422242442441244122222442214212222222442222222222244444212122221422224424222224332222224444444444222333222233222434442244442442222322222222222222221222442112111211212222224411111122222444222211222222224442222224222222122212222242214422442444412433222244222222222444444222222222321133333333344442222442244223344222244122422222222244444444244444442442224222424444222212222212211122211242222112222222222222222222222222222222222222222222222222442222222444211222222224444111111124211114444242422222222222442222444444222222424322433424442222222222222212222344422232233344422222442222233222223322133444214211112112221122122244111122111122211222221122221222222222222222211222442112212211112211222222442222224222224222222323333333323313333334444244444444444244144112244444444212224442114441121222224412442222442244422322222222244424222222222222444422221232233242232222222222222233324412223334222232232222333322333333332233442114111144144414444444411224411422424442222411411222444112221222222223322444444442223444444222222222322222444444334444442333324224442222223332222222333344442242222233333324444121111121211212111111244122222222221222111224442122111144442112444444224441112424222222214442222244444442222223332222222332244224442224422222222222224422223244222222332222332242222333222333233443333444444422222444112222222224441144224444422242244124242332222214444222222222422224422422444442244432444242244222332422222224222222222444442244422222222223222222222222222224422433333222242444444444442112224444211242244444411421442224442121122441111122222222222224422222222222222233322232444231111324444444442223333224444422222222222233222222222222222222222424442222242222224112111111111444122112441124444444441122222212112221444444222122244214224422224222223333333311332444424444244444442222224422222324242324422242444222333223322422222222222333342221111422112244444222444444444444444444122222244442422222242222222332222442222344233222222222222223232231233333223222222222344424224444444441114422221214442144444444121112442444224222222244444444444444444443223223322222222222222233333344424444332223222222222221222222232222222222443224422222233222333133222422222442222224444444444411214233441124441441122444422224222222222332334344224444444444443444222444444324222224223333333333333322333222222222222222222222222222222222222222444222233441122242111124411144444444142222211141122442211222222442224422222222112222222224444422222222222223333422222222222444222222222222224222222422222222222222323342333332233333444422112114441222444242111112112222211122422124422232222212244421111222224424444422242122441222211221222221422223222224444422333223113444221112124441114442444441111142444444222222222224222222242132422224444112222332424222222222223322244224444424422422222223332233344224422244422441112111112112122444444441112211111111122212222224244224444442222222222422232242222224442224442222424444444442222444224222222221111133311332332442222222222444444444442444444222224422224224444444422324444442222422444221222332333444344442224422222222333322222232222222332232222222221333322222222222222442222223333342444444444442221122244124444444112222211122412222112124442242222444442222222222423222242222222222222222222222422442222222222422222223322222222244442422223222222222222222224442222222334224422222222224444422111114222224244444422222222422222222224412222222222222222222222122222444422222242422222222224442111111112422222212111421111111122222242222222211111223322222224222144222222222332233222444444422233332242211112212222444224444444422224444224444222222222222211132222222222222222122222222222333322222332222444222222223222332223444232444442424444222333222234442222212211111244112444424442224244444222244422111124444444444444223322322222222422233221223322232332222442244324423222244444224444433333444211111111144441421112134421422211442122221122221122222222222224442422222222224424444444222222222222244443444222222242444442222332222422223322444442411121111111444444142111111211114224421112222222224233422222222244422223444233222222444444442244444444222223234422332222232222222222444444444233333333232224442111124221222222244444244441111224414212224422222224424422444222222222224444444444444444442322244444444442222222222222222222222222422222233222222324233322233233233233223224443222422244112212411124222224444411122122222122444441242122222424422222222222222222244222244444444444444244422222424442442222222222222222222222244222223444444423333244422222222222223222441111112442224422222222222222222222422222222244244112211222122221111442222222222222444224444424222224444221234223344222444422244444244222142214211221144244221111122211122221444412222222224444444214444111112144444112222222222233224444224422222233333333442211224421111124222224444442224444444444444424442222223311322222211222122222222222442332444111122242222222433224222222333322222222222222244411221222224112222222211442224221444424242224444244222224444444444444444444444411111112113322232212222222222222222222222223222222222222222233332444444444444244444444443444444444244222444444444444414421122244222221111422422444444424424222212222222224422224444233444442444444442442222422224422333222222222222222222224444442444444422222233322222223333222222234444111122222222112222224444411222222242244444422122221122222222221122122222222242222444224442242222222222244222444444442222444233323434222444211112112241111111244411421112222122242222222232442222244422422244444444424442442222222422222244444422444422222344422222221144442222233333332222332234411241122222244444444122221112444411111122112444442222222211222221444422221112222231122223322324442222222222222222222222222223332442442222233333222222233333322424232421121144231242222222222222222122221122244444442222422424434444442222222144422222442211222444444422242442442222222222222222223333244442233322223324423222223444224444222222222224411111421111112121124444224444444444222244444444444442442222222444224444443344444222144444222222224444443222422222242222224324442244222222333322222221131133333233323442222211223222441123322222223222122222112244411422222222222222222222222222222244444442222222222222444222442211122444242332442222224422222222222222322222224233244222222422222223244444444444424422244444444221122444412444442222223222221312112211444444444442222422222444422224222444233124422223222444444422222222233324444222222221122244442414222222222221113332222222222222222222244232222111113311332422222222222333323334',\n",
       " 'nia+219@rowan.kr': '4422221222331344344244442224444223334222223322222244224422222222242222213222323333242223322111112222222222224444222222122223222222222331422222222222222222222244444111111124444224422222222222222222222222222222222222211222222222224444444424444444444444444422211122233333334422432223444441111333144222222222222112222222242222422222322224444444444444222222111222222223444344444422222222444444444422222222244222212222222222222222222332222222444222444422222442224344444444444424433334444244422333233322222222222222222222221131222222222222222222224442222243322322222224444111112244444444442221122222234222222444211222223333322223222222222132222444222224444444442222222232222333322234444424442223313133222244444111122444444444444442444444422444444222233222222222222232222222222222222224444421211144424324422222444444422444444444444444444422222222222442222222233322333332222222222223222222322223222244444444412111113344422224444444242333122444244444444444444444422222212222222222223433322222222222222224222222223222333333322222442322244444444411111222244442222222222223333222222221222213232222422222222222221133223344444444444222444443334444442222222242222221222222222224444444422221112222222222222222221244442222224444222224422224424424222222222222222223222211222222222233222222222222222222222344444221111222222222222222222222222224244222222222222222224444433333344331134444222222222222222221111122224444444422221111222222244444422222222322222244224222222222223331144444221144222422244222222222222224442222222222222222222222222221422222233332222222222222224422442222121333344422224222242333224224442222222223332222223223444224444224444444444222221222223322222222111222222222444444444111112224244224444442323333444222242332222222334222244244422222322222222222222322222222221122222223334442222222221222442444222312112233342222442222222222222222222222222322222222212233322222222222334444444111224444444422222222223222242444422222442224444444222222211221111344222224444411111111242224422233222224444221124422222442221111222222222211134442442224444244444444444422222222122423334224222243324442222222422222222233334444444444444444444222222222333334444421111222244444422222222222222244444444222444222222222112222222444222243324444444324222111133222244222111122222222442322322244222111222222233321122112222221322244222222222434444422222444442222223334211111422222222222444422222222112222222222212212223332222222333322222222223332234441222422444222222442222221112442222122211333222222222222422444444422111124222111122112211222222221112322242222224444444444444444444444222222222244443342342344222222222244444442222223222213122222111222333222222322222222223222223221224222222444444422111311221122222122211111122111122211123322232222222211122222222422444222111122224224222442211111222111111112221111122122221111122222222212222333322222222222222224444422211122211222112211222222211221122211112222322222222222332233222222222224444211211122223211112224444444444444444444444444422221111112222233222221122223223322222232222344334444211114442111113314442221112222111112222111212221144444222222223122311422222222222222233322222444424242222111222221111122222111222222244444444422242222222244221112111122221111211222233344322211223344222444444444411111111222111113322221111231134222222222233222211244444444444444444444444422222222232223222222222433332222442444442222211112222422112222311112222444422222222222222222222444444444444422211111222111111111114242211111112332242222422221222234444442221111112211122222221111123334422222234444424422242222332224422444444111111111122112222224422222244111142222221222223222222222112243222222322222222444444444122144444444444444422222322222221114442442222224444442422222223333442221244444444111444422442444444444444422232444444444444444444244222212442222224444224222222222333334442333343344444444412211322222222322224442422221112124334242222222322222221144444422222222231223344222211212244444422222111221111224334444422444422244222222233322222222222234444',\n",
       " 'nia+230@rowan.kr': '42122222112212222111333333333211221111111111122111114233222223233322222222222222232222233322233222222222222222233222344441111122222221111111211112222222222222222211132222333322222222222221222222222222222222222222212212233333233333334432233444411144444444444444422211111111122222222222222222222222222223222112222222221111111223222222222211122224433333334344444444414444422111122221112222224222222111111112222222222222221222211122332222222332222222222211112223333333332222222433223333344244444444444211111111111334222221122111111111111111111122222232222211111111112222222222222323333222233332333333223334433422441221111112212244244444444144444414422222222222222222222122111111122322222222222222222222322422222222222223333344444144444422211111111113322222111111111114433333322221111122222222222122222223333333333323332233442222222222222333332333344444111412142441112222211112222143133332221111121112211113222222222222232222222332222223322222222222332223333233222222222223444211221122111122222222442221111111111422222222222221112222222222333333222222222222222333333222222222224423332332233344444442221122111144221444442211111111211111111222222222222222222222222222121122211122233333233223333322222233333333233232444444421111111111111122222222222222222222222312222112222223322222222332332333333222222223322332222222222222222322222222424444444444411441222221114422111114222222222222322222112222211211112233222222222222111112222222322232222222333333333222333344424444444444444444144444244422222211122222211111222231111112322222222222222222222232222222223333322232223322332232334444434441114411211111111111133333323111111111111111211121323333332233222212223222123333222222333333333332222222222222333344441422221111111111111122211111222221111122111111222222222222222222222222222233222222333332222333233222223322333333444444424222211111112122112111111122221111111221232233222122111111322222222332333222322322323333332333222222222222244444444411222222111112211111111111342222222222222222223332333331113113311313332332222222222211112223222322333224244444441221111221111112222222222222222211111111111331222222222122222222232222333322333333222223233333333322223344444411221122112231321142213113312211113221112111112222211111133322133333333333222222222222222222442244222222222222223322222423444421211111111111111113322221122111121122221112222222222332322222222222211122223332222233222222222322222232223332324444112221111112222211424221111111222242112222211122222222111222222222222222222222222111211113233333332233232444444444442211111111222112222111122212222111111222222222222222332222222222222222222222222222331222332333333333333324433333334444442222222211122111422222222221121133223311333111133332222222222222222112122221111112333322333322223222222133111222244221111111111111114444221111131111113313333222333333232222222211222212221113333333222222222222222222233322223332222244222111111111111112211122111311111111111322222222211222223333322222222222222222222222222222333322332222334222222223333333333444211122111121111112311133332222111111121122122311221133312222122122111222222222223333223323333333222322324422444222222244444444444444441421111111111422212222211222211111111112222222222222222222222222233323332333233333332222233222222334433333322222222444242222111222111111111123111333333221111112222222111111122222222222222222221112233223333222222222222222233434442411221111111111223333311143111131333311322212222232222222222211111221112112222232222222221222222333223333333332222222222244421211221111121442344433442222222111111122133122222222212222222222222222223112222333233333333333323333333333322222222222442141111111112212222111112222111111333223221111112211111111221133333222222333222222233333333222222112222222222444444441111111114444442222442222111222111111322222222221111111122222221122222244422333333333322323223333322222244442444441222122222111222111111144423333323334222234433332332111222122111112222332222222222221112222232222311122222222222444444422221111111421111331111222242112221111222212222333222222112222222122233332222222222213311311333332222332222324444444444442111111122222111111111111111122223122222222222222233322211113232222222222222222322232222233333332444244444441444444444444444441441421111221222222222221111111221112222222221111111222222222332332222221123333233332224444244433444444111111111111111112222222221233222122222122222111122221222222222222222222222222222322222222222222333333332222223333222333244444444222111111111122122211114411111111122242222231122213222113333333332233222221222222222222333333322222244444122111111111222111122111112221122222222333311322121221133222222222222222222222222112333332322222222222223333332333322222322232222222444244422212111111111111211111133322222211111111111112222222233322222222222211222223333222222222222222332223332222222221344424444444444142222244222111224222111221111111111111112222222222222222222222222222222222222333333333323133332244444144244144222222111122112211144333311222234212221111111123322222222222222332222222222222222222222223211333334444444444214221111111122211112233221111111111111221111112222222222222221223333311333322223332233332222422222333333442224444122111111111122334222222112222222222221111112222222222211222211111123322222233342422222332222334433333333444444422222221112222111222111114422222222222111122222122221112222222222222222222222222223323222223324444444444444444444444444442442244442444444414422211111121133333334222222333332222222222222112212221222223222222222222222222223322222222222223322224422222221111114444442222222222111112222222222222221222222222222222222222222222222233222222221333333333344421122221111111122222223331221112112222222222222322313332222222222222112222222222223322223333333333333322222222333444424114443311442222111122222222211121122211222222221122222222222222232222223333333333333322222222422332222222223332222222222222333222444144111444222211111122221222111111222221111111111333333222222233111112333322222222223322223222222322222222222233344213344411121111111111111121111112211111222221112232111111123332222332333222222222222222311233333322222223333333333223233222222222244444442442122211114244421111321142222222222222222222211222222222222222222222222222222222221121223222233333222333332334433444441111211111122114411232221111322222222222222122222222222222111333323333322222222222332222344422222233222224444422444444444444444422144211111111214444114442211112222211112111112222112222222222322222333222222322222222222222223223222222222222222223224423444444442441111244444424144444424442222212222222222222222222442442222222222222322222222222222221222211111132333442223331333332223322233222322222334444242122122111111111111111242222222222212222112222221111111332322222222222223233333332223333332222222333223333222223322222224442412211111124424422222112232212222222222332221222221333233332222222222222222222333322222233233232233322222222233323332422244444444122211111111411231321112211111111222242222222222222223333332223322222331122222222222222233332222222222232233222222223232233333444442222111121444444442122222222111111122211221233222211111122222222222222222222222222222222222222233222223332222333333333333334424424122111111111122211114434441111442222222223222112222222222222322122222222222222222122332222222222222333222223333344444444444444211122111111111221111422111222222222211424442122442242321122222222222222222222233332422222222222223233333333332222222222222222244444411121144444441411114442222222211111111111111111122222222221222222222222222333333333222222222232222222222333112222222222444424441144222244111114422121112211111112222222222223333222314222222222222223333333322222222222222212223332322122233333222233222222444211114222111122222221114211132334221222333222334222222222223232223333222332222244442222222422222222222222222222223222222222222444214222122111122442211422222222222111111111111112222222222311221333333333222222222233222222222332222223333443333433344444444442214444444421112444422222211122112211111123222222222221111233333333333222222222222222222333322222222222222222222333222223222233332222222222222444414422111112222222222233331122221111123112221222221124422321422222222222222222222333322223322222222222222222322233223442422221111111111221111443333111224442222221111111121111333222222222342222232222222222233222332222222223333222222222322222244421444222222222442421111144222222222244312222444222222222233332322333312321122333112222333223322222222222222222222222233344244421221111111122211222111332211111111222222222211121112222222222222333333333322222111112222222222221332233333332222222224424444444444444422211111121111111114422122221222222112211111112222223222331222322222212233333333322222333322222233223333332443333344424142111111221142222212322221222222222112223221111221121222211122222222222233322333333322222222233222222222222222322233444444444444222222211222222222222222222244332233223344222222222111111112232222222222212222224222233222333333322233323222334444442111122111111111231311111121112221111112244222211112222222222222222222222222223332222222222222333333322222233222243334344444444144444422211111121144422222111131134422244421122222221111122222222233333222222222222222222233332232222222333322222222223322243332222323222444442342222111111111211112211111112444233314222222222222222222222222222222222222222222222233222222223322333222222333322332423223334443444344441111221122222111111222223333222221111111111222332222222222222222222233222222222222223332222222333332222222222222222322244444444444221111111112223222122222111122244444224422222222222221111222222222221232222222222222233333333222222222222222234433334444444422211111122441112211122222122222112222223122222222222222223212222422222222313333222233222233222222222222222222233322332222222144444424442211111111111111122222222222222222224222121111113332222222222222223333333422222222222332222223322222222222233333333332224444144444114444244441444221111111111111222111111132222222222222222322233322222222223322333333333221323333322222222222122222223333333222344442111144441144442224444422111111111111113322211112223322222222222222222222333233333333322222222222222222222222222233444444444444442222211112221422211144442344444422113322222222222222222111111111222333222222222222222222222222222222223332222223334244444421121112222221111111121133333222211111222111211133333323122222222222222222222222222222222222232322222222222244234434444442441244222111111221211112223332222221111222222222222222222222222222233222222333342222333332233332322222222233222344444242444444144422222111111122141122112244444222222222222111111112332222222222222222233211233332222222223333222222233333333322233322222244234424441442211112211111114221211111121114111124222222232222211312323222223222333333222222222222222333333333131222222222222223333322222211222322222244',\n",
       " 'nia+306@rowan.kr': '42222222222222222333333333333322222222222222222332222222222222222222222244422211111333132222222222222222232222222222222222233244222222222233342222233323333334442214412222222244444444444412221222222222222232223333332222222222222222222223222322222223322224422333223322224442222444122222222222222333222244432222222222222224442224233222221222222222222332222242224222222222222222222322232222222244333332233344422221111122333322222222222332232222222222222222222222222222222322222223333233322222242222222233333333333333444422222222233233322333322222222122222222222222233344223222222222222333333222222222233322222222442222222222222213222222222222222233222222222222222222222222233333344433222222222223322333333222222233333333334444222222244442222222222222222332233322222222222223221333333333342222222332232242222223332222244222121122222211122222222322233332322222221222222222232332222222222223222233332322223343333344444444242244424224424442222222233332442222222222222222222332222222222232333333442424422222222222222222223333333222222223333334442222212222222223211444222222222212211221133232222222222222333322222223333223223222222233334442222244222422342222222223442222222222113311342222222222222211122222222222222222224442222222222222222224422313322222222222222223333333322222244422422221441444421122233334422222222322222222222333332222222223222222233333422222222222333322332222222222244422222222211222222222222222222222211112222222233333333342222222333333333333222222222233322222224442111122111121122222222222222222222223332222222222222222222222222332422222222222332233323333224422222121133213222212222222122223334444222222222222222222222333322222222222222222333333222222233444422211221122221111322222122222222311222222233332332223422222222222222244222222222222223333333222222233322333442122221111222222221111122222224324222222323322322222223222244424332422233334444444444221222221111111322222222222221112222222222222222122232222242222222222222233333222222233232233333344442222211111111222222222222222222222222222222221143444222211112221222221112222211122222222222222222222232222222222222223322222222444444422222244442122221111111133322222222211222222222222233333222222222222222223332222222222222332223333334442442222212442213344422222222222322222221133244222222222223222222233322222222222222222233332322232222222222223224444444423222222244422212222222222222244223344444444424444444442222222222222333333332222222222222322222222242222211111111112222222222233422222222222222222222222222222222222222222222222222232222222222222332444444233333333333333334444444444444441112222224222221111122334442222222222222444424442224444444222222222322333222223233333333244222222233333223222222222222222233324444444444444444242322222221322222443334444222212222211111122444422222222222222211111112444244422222424344444442222222222444222211114222221111111112222221122113113322112111222222222222222222222344222222222333333334223222323334442111221112111111122221221222222222222222244444444444444444444422324444444443333323333442222222222222222224422222222212222222223333222222222222222222222233333322222421221222222233333222222222222222222333333222222222222333244222222222222221112222222244444444422222222222222222333222113222222222222222222332222222222344422222222122111122222323122222222222211233222222222222222212222222333222222322222222222222244421211111244444442222221333334222222333232222222333222342222222222222242222222222112211222222222222234442112222212222221111322222222222222222222222222222222222222222333344422333332222222222222222233224421112222122222223322222222222211222223322222222222222222222222212222222222222223333324444444442224442222222222232332222222332422111414442224422122222244444412444122221111222222224221112243133333322222222222223333332223444444444444422223222222222222222223222433333333222344422222222222222212222222222222222222222222322213334222222333333322222222222222222233333333334444222222211221122221111112231222222222222221222222222233322222222222222222332222222222222222222222222233333222323223223222444222244221141124444442211111122444222211122112222233222222222222222233223332233322324422222222222222222333333222224442122222122222223334442222222221122122222222222222222223332222222222222222222111122244422222222222222222222222222333333332333244233334333344421211112221211111111221122221222112222222222222221322222222222222322222222233222222222223333222332222223333333244444122111441222222222222112222222221122222222222223312222222222222222222222224422244422222222222224444442222333223322233444444412211111111122222222222222222122211121222222222222222222122222222222223444222221111111211111211122222222222222111142222222222222222222222332212222222222222222331123222233333433333442222222222221221111221222211122222222222222223112221132222122232222222222233332222222222222233333222222222222233332244444222222222442444444442212221111111212144222222112222221222222222222222222222332233333222222222322223333232222233333444222222211222111143112112211122111444442222222221222222222222233222222233222244232244442222222222223322223334433233333333444222122111111121222222111222222222211222222222222332222222222222222222233222222232422222323333333332334442221121111112222222211222222222222231222222222111122222222222222222222244222222222222334422323444422444442333333333222234424444422333222221222224222223333332222222222223222222223333222222222222333333332223222222223333322222222222233333444442442222232222222222223334443334444442222222222222222112211333222333222222222332442222222222222233333332222222222222222223333333222234444441222242224444424422222222222222224422223332221111111222222333323333222222311333322222222233333334422221111111321122222222222222222222223333422222222222222222333333322222222224423223322442221111111333333222222222222223333333333333322222223331222222233222244444444444444442222222223222222222222222222222444222244442222222222222223343222222222222222222222222233332222222222222442222222222222223333333334222222222223333333222223333442222222222222222222222222223244424444444444422222222233333333322222222222222222223322222222222222222333323332222222244444112222222222212333322222222222222222242223322324442222222222222222222222223244442244444444442333243333333333333333344422221111222212223333222222222222222222222223333322222222222222333333324444424424422222222222222222222222223344421131111211221113222222222222222222222233222224444444422333322222222222222223311322222322224444424444422221111222222221222222222222244122222221112222222222223333333222222222222222233322244421111112222222222242222222222221122222222222222233222222222222222222322223333244444444433343344444424444444442442222444244444222222234424444334444342444422222222212222222322222222222222233322222222222222222333222222222222233324422213133322222221111222222222122222222222222223222222222244222222222222222222222233233333333344433223432444442222222222224442122111111112222222133332222221222222222222222222332222333322222222222234442322222244442222222222222222224422223343333322222222222222233333332222222222222222333323324442224422222322323333323333334442222222221122222222221113344422311222221122233333334222222222222222222333332222222222222223333334442222333322131112222222222222222222222222422244211112221223333312222222211222111211124222222222222211222222222222222333244444422233333322222233332322222232233333324424221111222222132222222223333222222222222233333442222222222222332223322222222233222242222332222222224444444233333322222233333333223324441111122211111311113222222222222222234442222222222222233222222222223333324444422222222222233322222333333332222442222222221221111111111222222222222222222244222224333244222233332222222333333433222222233322222223332332222222222222222223333333222222233234422211112221111123113222212222222222222244444342222222222222324444333322222232222223333333322222222222222233333444',\n",
       " 'nia+338@rowan.kr': '4211121111111112221122222222111122112222212211112221121144222244444422421111222222122222222212222111122224442444444444421224444444221121111222222211112222211221111111211211222222221112444411221122122222222222211112222222112222222122221111211112222222211222222224422242222222221122222222112211221112222222222211222222222211114444114444444444414444444222242444412222221112222322222222111112222222222222222233333324322222222222211444222222111111222422222222222222112222222222233222231111121124444422222222212111112221111211111112222222211111111222222244222441222122222112221111122221122222222222114244111444424222222212222123312222222222221444221111111113333222121111221111332122222222222222222222222211112222222222224444441122212111114444422444244442244444242444444222222111111122222222222221222222222213333322333444211111111122222221222222222222222221122222222222222222222144422221221112142444444444424422444422222224442244222222444211122212222222222222222222222233222222222222322313212222222222444242222222222222222222222212221114442224222224442442222443224442221222222111111111121122222222233122222444411111122222222231133222112222222222222232232222211122224444422221111111122232222222122222111211222222222222211111222222222222222211111111144444221111111111222112111222222222222222221111112222222221122222222223444221111223322222222222212221112212211222222223122112222222222211111442233223224444222222111111122222222222221111112221211222444222444442442224244422222222111111111111122222222111232222222221111111122222222212222222222222222233333344422211111111222221211222221211211222222222111112222222224442221111111111222222221122221222222222222221122222444421111111222222212222222222211122222222122211121122222212222442224444222442211111111112222222112111111222221222122222233111133132222222222222222222442211111111122222211211122122122111442222222224424424444422211221111111211222111224444444444444444444112244422442444442442244442222222211222222222222222221322222222332222223222222222444441424111144444242444444444444422221111112222322222222211222211111122211111111112221111111444411222111124444144222222122224424442422244442332444422222111111222222222222122211113222222222222222222224444211111111211122222222111212222222122222112212222222222222222222222111112222222224444444112422222211111121222222222222111111111111111111222313342444422244224222244444444444444444211111111111112222111111222211113222222222221111111332223222222221114444422422111111111222221222222221222222222211112222222122222222223222111111122222344211242211111222222222222222222122112111222222212222222222444444224444444442222244444222222111144211111122222222222222222211112222222111222222222222222222222221112222214442121111442144444422112224441422444444422222211111222222222244134244442222222222222122222222222221111222222221144421111111111112112211222222122222222221211111112222222222112222222222222122222144222211112221122222222111112221121222222211111111112222222232222121112222222444444222242224444422444444221221111122211222222111112222222111111121222224222222444442412222122211222222222222222222222244444222144422222221111111222211111311333322211122222222122114444444221111111111222222222211222112221111122222221122111112222222222222244421111121211112222212222222222212211111223222222211122111112333222222222211231444422114412222112442444424424222222244444442444444444422222444222222222112222222222232222222222111222222232222223322242222222222222122224441112221211221222222222112211111111122311121222222211121112122222211122121442221111121111122222122122222222222222222221221122222222222222222244442221111111111222222222222211111222221111122222222221222211222222212424422211111111112222221222211111333222222221122211111444222211122222222222222222222111111122313324444111144222222442444411244242211142212112222222222211222222111111222111111122222222222222232222222444112111222222114442222222222111111112222222222111112212222222222222222111111224444422211111222212222222211111222112222222222211122222442222222222222111112222224222222222222224444422221122211122222222111111222222222222222212222224444222111111111111122122222211211111111112222221222222222212221222224444412111221112222222222212211121222222211123112222222222211222332222222222222222222222244424224112212111122244222211112211111112213222122214222222222222222222221122222244444114224441111211111122111112222222211122221222222222222222222122222222222322444411112222222222221221111121112222222222222211222222223221222222211122221121222222222222244211112111122212222222211111111111222222222222221122334244222222221122222222222222222222211222222244444441111111122222222222222232214444224444444242222222211113322222222211112242444211221122211122212222222122221111112222211222122222222222111144444222144211111111222222222222111122222222222222222222122122221222222111111221222244442222211111122222222221111111222222244222442244422242422122212221122222233333222124442221111211112222111221111111122223222112211211221211111222222222222122422233322332222233114',\n",
       " 'nia+341@rowan.kr': '4441111242224244422142111111124421111422211222221222224442222211111113244444244222222224442223333322244422222222222233222444421111442422224444211122334422222222212212212222233334222222222222222222233333323222333222222222224444424222222444232233223223332442222232222411111111111113322221322222211111444222222122221222112221443222222222221133132222322223444444423322223222233332444422211122111111244441111222222442222333322222222222221112322223332222221222222222222244233322222223332222322333344444224211444422212222333342221112233222222222112222344222444444442312221442211111221223332222322222232444442222222231132333323244222224444442144222311222211211111133322113333244422221122111122221313221433334222222222222222232333443333244444224232444422222224232224223344424444443331113334323314444444442211133222222222223244442444444444222222222222222112222222222442323333333222222233344444444444442424422441111233334323124333222222233333332222333333322222422223223444222222222222332212211111144444444422442224444422222222222222223322333334444444243444244322442222222442221111442111221113333244211123233222222223243333342444442422222442211221111332442222222242333222222324232244424332244224444444411111111111133334344343422221112222222112222332222222222122222222244412222222333333322222222212322333444421222422222442211212111111133242222212233332221222222222111112333222222323324444222222122111113223444422242223333332223344332244424444221111111333244111121124321112314444223224242221111114222221222221111111344422222223442222223333444114444232422444422222444221132211111111333333224422222211122133333334444442222222222342222422222222224444442223222334444233324412442222422222113224422222222442222222222222422344333322222442222222222222422223422324333333242223344422442332333322444442212211211113333332232211222112421421233322221222211142223222222224444444222222224441144442442124422442231222244432322224222222244444222222111111111231333333332222222222133333222222334444222244232222222222233333333322442222442222222422224222222222344443224442222222433222222222232422433223344424444444241221131422233222114222222223334422222223333222223333322222222332222224442233333223333224442324242224242324224442224233222244442422211221111111333322133332222222231222211222322111222224444422222222444224444222222233333333333322422222222224223322322333442422244222222244111241132222232234422242211111332222322222212211333334432222444444444421132244422244222222444444444422222222233242333244244242221121442222111142224422132211443224222333322224233222333222222222222233332244422222222222222232242333222224224442333222222222222222444444224212222442222232222222222222222242122322242222211124444222224224423442322321222223244422242222322244244433332333334442222414411111311122444422222222224422222222222323333333324424242222322422222222443333322222333244442322332442444441114441111113344444444442441144211111133332222222111111122223332222222442222223333333222222221324423223332222224223322333333333322444441221311224222211222211111332222212213333223333433322422222222242221122222311133332222322442222222222244444444333244222314442422322111111442212121212211211422111121122111144221111222332444421144222222222244422211421222122342222232232222444422242222222221112223233333244222222211222244222224422222442244333334432444444444444424432242222224222222223331332222222222222223342444444422222221122222444444222222222333232222222222442222222222242233323223332332223443332222322344411444211111312333333322111421122422342322222112222222222222233222222212222222223333333333333442222111222131422211121111133233322422322211222222212222233322223223333322222222111133344424422211114422222242221123442111222333222233222244444124444222444422422222222222222233332244222222122112211332222333332222223322334444444212224444423323311314221122222444422222222233222444444222222222222222113444442224222222222222222442223322333333344244233244442344421121111422333322242211122222233333142222222221222223333332322111122222222233344441111111111112333333443211122222411111111121111113334422222223224222232224444423324424221122222332223122222444442222224222222333322222222222232333332223222244444224222222242424233224442442244124444423142324222222112222122242222221111222212422443222223332222422211222222222222422233333244444444222332222233222222242333333333244223442222442414444422244444224224424444444444422244413333213111333222442222112221444222213333332222222222222242222444444211121111111113333344222422222222111123332222222222222222444222222242222421111442111122221113311333222112122222112333332223222222233223114442333222242322332222224222222132244422221121111111111121124441122113332422222222232223332214422334222222222432222222224442242222444222223333224433224233333444422221121111112112222222221222123324444412222222211222233322222222222444423333333333324233333344222242333322444444224232442422221142221244211133323222422224233222211221113333333323332244424422222223222222222111344242222242223223242222244244442222242224442212444411224444444422112224411111111111333332222222222334223333242323333332222222211223222333224443222222222244222224444442422422222211111111133333342221111112122211221222222222112222333333322222122221222223231111343333324433232222223244112233333224422444442444422223322333344224442112212222122222222223333223222222222222232444444444232222144223333233222442244442322423324242224442211111114111221113332111122211111112211122111122222122442222222222222222323332244442444222244433334444224442442444444424224444413312244444222222111121113333222222244222333332222222222222223222222444222422222112222222333224422223333333333333332332444244423333333333333344441244333224422222222442111244444444233333342221122122112244422222222223222222222222222223333332222233333333322223323244232224442111122111111122322332112122112422221223334333322333222222322224223332222222222223332333444422422111111142211232222222222222223322242222222234442232233222222222244444444231133113333333333324422224444442322444222223333333342244444122444224441144221111111442222222111222222233322222222211222222233322221433333344333322244444222222332332444222343444344'}"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Dem_concatenated_hypnogram"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "c26e9136",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>EMAIL</th>\n",
       "      <th>Length</th>\n",
       "      <th>Count_13</th>\n",
       "      <th>Count_31</th>\n",
       "      <th>Total_Count</th>\n",
       "      <th>Rating</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>nia+017@rowan.kr</td>\n",
       "      <td>5032</td>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>43</td>\n",
       "      <td>0.008545</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>nia+067@rowan.kr</td>\n",
       "      <td>9330</td>\n",
       "      <td>24</td>\n",
       "      <td>30</td>\n",
       "      <td>54</td>\n",
       "      <td>0.005788</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>nia+139@rowan.kr</td>\n",
       "      <td>6037</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "      <td>14</td>\n",
       "      <td>0.002319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>nia+196@rowan.kr</td>\n",
       "      <td>10776</td>\n",
       "      <td>33</td>\n",
       "      <td>26</td>\n",
       "      <td>59</td>\n",
       "      <td>0.005475</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>nia+219@rowan.kr</td>\n",
       "      <td>3964</td>\n",
       "      <td>23</td>\n",
       "      <td>18</td>\n",
       "      <td>41</td>\n",
       "      <td>0.010343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>nia+230@rowan.kr</td>\n",
       "      <td>10745</td>\n",
       "      <td>88</td>\n",
       "      <td>67</td>\n",
       "      <td>155</td>\n",
       "      <td>0.014425</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>nia+306@rowan.kr</td>\n",
       "      <td>7814</td>\n",
       "      <td>41</td>\n",
       "      <td>23</td>\n",
       "      <td>64</td>\n",
       "      <td>0.008190</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>nia+338@rowan.kr</td>\n",
       "      <td>4990</td>\n",
       "      <td>19</td>\n",
       "      <td>15</td>\n",
       "      <td>34</td>\n",
       "      <td>0.006814</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>nia+341@rowan.kr</td>\n",
       "      <td>6106</td>\n",
       "      <td>71</td>\n",
       "      <td>32</td>\n",
       "      <td>103</td>\n",
       "      <td>0.016869</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              EMAIL  Length  Count_13  Count_31  Total_Count    Rating\n",
       "0  nia+017@rowan.kr    5032        40         3           43  0.008545\n",
       "1  nia+067@rowan.kr    9330        24        30           54  0.005788\n",
       "2  nia+139@rowan.kr    6037        10         4           14  0.002319\n",
       "3  nia+196@rowan.kr   10776        33        26           59  0.005475\n",
       "4  nia+219@rowan.kr    3964        23        18           41  0.010343\n",
       "5  nia+230@rowan.kr   10745        88        67          155  0.014425\n",
       "6  nia+306@rowan.kr    7814        41        23           64  0.008190\n",
       "7  nia+338@rowan.kr    4990        19        15           34  0.006814\n",
       "8  nia+341@rowan.kr    6106        71        32          103  0.016869"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 이메일, 길이, 1과 3이 연속해서 나오는 횟수, 3과 1이 연속해서 나오는 횟수를 저장할 리스트 초기화\n",
    "emails = []\n",
    "lengths = []\n",
    "count_13 = []\n",
    "count_31 = []\n",
    "\n",
    "# 각 이메일 주소별로 데이터를 처리하여 리스트에 저장\n",
    "for email, hypnogram in Dem_concatenated_hypnogram.items():\n",
    "    emails.append(email)\n",
    "    lengths.append(len(hypnogram))\n",
    "\n",
    "    # 연속된 1과 3, 3과 1의 횟수 초기화\n",
    "    count_13.append(0)\n",
    "    count_31.append(0)\n",
    "\n",
    "    # hypnogram 문자열을 순회하면서 연속된 숫자 쌍을 찾음\n",
    "    for i in range(len(hypnogram) - 1):\n",
    "        if hypnogram[i:i+2] == '13':\n",
    "            count_13[-1] += 1\n",
    "        elif hypnogram[i:i+2] == '31':\n",
    "            count_31[-1] += 1\n",
    "\n",
    "# 데이터프레임 생성\n",
    "Dem_hypnogram_count = pd.DataFrame({\n",
    "    'EMAIL': emails,\n",
    "    'Length': lengths,\n",
    "    'Count_13': count_13,\n",
    "    'Count_31': count_31\n",
    "})\n",
    "\n",
    "# 1과 3이 연속해서 나오는 횟수와 3과 1이 연속해서 나오는 횟수를 더한 값을 새로운 열로 추가\n",
    "Dem_hypnogram_count['Total_Count'] = Dem_hypnogram_count['Count_13'] + Dem_hypnogram_count['Count_31']\n",
    "\n",
    "# 길이에 따른 1-3, 3-1 연속적으로 나타나는 횟수 비율\n",
    "Dem_hypnogram_count['Rating'] = (Dem_hypnogram_count['Count_13'] + Dem_hypnogram_count['Count_31'])/Dem_hypnogram_count['Length']\n",
    "\n",
    "# 결과 확인\n",
    "Dem_hypnogram_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "2cbb373d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "치매 환자들의 평균 Rating : 0.008752040475790765\n"
     ]
    }
   ],
   "source": [
    "print(\"치매 환자들의 평균 Rating : \"+ str(Dem_hypnogram_count['Rating'].mean()))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6aaa6fca",
   "metadata": {},
   "source": [
    "# 정상인"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "6da9e836",
   "metadata": {},
   "outputs": [],
   "source": [
    "CN_data=CN_data[['EMAIL','CONVERT(sleep_hypnogram_5min USING utf8)']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "2d816a4e",
   "metadata": {},
   "outputs": [],
   "source": [
    "CN_hypnogram = {}\n",
    "for email in CN_data['EMAIL'].unique():\n",
    "    CN_hypnogram[email] = CN_data[CN_data['EMAIL'] == email]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "9f461a00",
   "metadata": {},
   "outputs": [],
   "source": [
    "CN_concatenated_hypnogram = {}\n",
    "\n",
    "# 각 이메일 주소별로 데이터를 이어붙임\n",
    "for email, group in CN_data.groupby('EMAIL'):\n",
    "    CN_concatenated_hypnogram[email] = ''.join(group['CONVERT(sleep_hypnogram_5min USING utf8)'].str.replace('/', ''))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "d090752a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>EMAIL</th>\n",
       "      <th>Length</th>\n",
       "      <th>Count_13</th>\n",
       "      <th>Count_31</th>\n",
       "      <th>Total_Count</th>\n",
       "      <th>Rating</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>nia+005@rowan.kr</td>\n",
       "      <td>11389</td>\n",
       "      <td>109</td>\n",
       "      <td>39</td>\n",
       "      <td>148</td>\n",
       "      <td>0.012995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>nia+015@rowan.kr</td>\n",
       "      <td>3331</td>\n",
       "      <td>17</td>\n",
       "      <td>12</td>\n",
       "      <td>29</td>\n",
       "      <td>0.008706</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>nia+021@rowan.kr</td>\n",
       "      <td>6743</td>\n",
       "      <td>34</td>\n",
       "      <td>30</td>\n",
       "      <td>64</td>\n",
       "      <td>0.009491</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>nia+031@rowan.kr</td>\n",
       "      <td>9138</td>\n",
       "      <td>109</td>\n",
       "      <td>60</td>\n",
       "      <td>169</td>\n",
       "      <td>0.018494</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>nia+032@rowan.kr</td>\n",
       "      <td>7396</td>\n",
       "      <td>33</td>\n",
       "      <td>8</td>\n",
       "      <td>41</td>\n",
       "      <td>0.005544</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>80</th>\n",
       "      <td>nia+445@rowan.kr</td>\n",
       "      <td>2002</td>\n",
       "      <td>23</td>\n",
       "      <td>7</td>\n",
       "      <td>30</td>\n",
       "      <td>0.014985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>nia+451@rowan.kr</td>\n",
       "      <td>3467</td>\n",
       "      <td>39</td>\n",
       "      <td>17</td>\n",
       "      <td>56</td>\n",
       "      <td>0.016152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>nia+456@rowan.kr</td>\n",
       "      <td>6136</td>\n",
       "      <td>41</td>\n",
       "      <td>31</td>\n",
       "      <td>72</td>\n",
       "      <td>0.011734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>nia+458@rowan.kr</td>\n",
       "      <td>6198</td>\n",
       "      <td>38</td>\n",
       "      <td>46</td>\n",
       "      <td>84</td>\n",
       "      <td>0.013553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>nia+475@rowan.kr</td>\n",
       "      <td>3624</td>\n",
       "      <td>51</td>\n",
       "      <td>15</td>\n",
       "      <td>66</td>\n",
       "      <td>0.018212</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>85 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               EMAIL  Length  Count_13  Count_31  Total_Count    Rating\n",
       "0   nia+005@rowan.kr   11389       109        39          148  0.012995\n",
       "1   nia+015@rowan.kr    3331        17        12           29  0.008706\n",
       "2   nia+021@rowan.kr    6743        34        30           64  0.009491\n",
       "3   nia+031@rowan.kr    9138       109        60          169  0.018494\n",
       "4   nia+032@rowan.kr    7396        33         8           41  0.005544\n",
       "..               ...     ...       ...       ...          ...       ...\n",
       "80  nia+445@rowan.kr    2002        23         7           30  0.014985\n",
       "81  nia+451@rowan.kr    3467        39        17           56  0.016152\n",
       "82  nia+456@rowan.kr    6136        41        31           72  0.011734\n",
       "83  nia+458@rowan.kr    6198        38        46           84  0.013553\n",
       "84  nia+475@rowan.kr    3624        51        15           66  0.018212\n",
       "\n",
       "[85 rows x 6 columns]"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 이메일, 길이, 1과 3이 연속해서 나오는 횟수, 3과 1이 연속해서 나오는 횟수를 저장할 리스트 초기화\n",
    "emails = []\n",
    "lengths = []\n",
    "count_13 = []\n",
    "count_31 = []\n",
    "\n",
    "# 각 이메일 주소별로 데이터를 처리하여 리스트에 저장\n",
    "for email, hypnogram in CN_concatenated_hypnogram.items():\n",
    "    emails.append(email)\n",
    "    lengths.append(len(hypnogram))\n",
    "\n",
    "    # 연속된 1과 3, 3과 1의 횟수 초기화\n",
    "    count_13.append(0)\n",
    "    count_31.append(0)\n",
    "\n",
    "    # hypnogram 문자열을 순회하면서 연속된 숫자 쌍을 찾음\n",
    "    for i in range(len(hypnogram) - 1):\n",
    "        if hypnogram[i:i+2] == '13':\n",
    "            count_13[-1] += 1\n",
    "        elif hypnogram[i:i+2] == '31':\n",
    "            count_31[-1] += 1\n",
    "\n",
    "# 데이터프레임 생성\n",
    "CN_hypnogram_count = pd.DataFrame({\n",
    "    'EMAIL': emails,\n",
    "    'Length': lengths,\n",
    "    'Count_13': count_13,\n",
    "    'Count_31': count_31\n",
    "})\n",
    "\n",
    "# 1과 3이 연속해서 나오는 횟수와 3과 1이 연속해서 나오는 횟수를 더한 값을 새로운 열로 추가\n",
    "CN_hypnogram_count['Total_Count'] = CN_hypnogram_count['Count_13'] + CN_hypnogram_count['Count_31']\n",
    "\n",
    "# 길이에 따른 1-3, 3-1 연속적으로 나타나는 횟수 비율\n",
    "CN_hypnogram_count['Rating'] = (CN_hypnogram_count['Count_13'] + CN_hypnogram_count['Count_31'])/CN_hypnogram_count['Length']\n",
    "\n",
    "# 결과 확인\n",
    "CN_hypnogram_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "2c1b9dd6",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "일반인의 평균 Rating : 0.013613963195989431\n"
     ]
    }
   ],
   "source": [
    "print(\"일반인의 평균 Rating : \"+ str(CN_hypnogram_count['Rating'].mean()))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c16bd169",
   "metadata": {},
   "source": [
    "# 경증 환자"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "6852acdd",
   "metadata": {},
   "outputs": [],
   "source": [
    "MCI_data=MCI_data[['EMAIL','CONVERT(sleep_hypnogram_5min USING utf8)']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "effa80f1",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\82102\\AppData\\Local\\Temp/ipykernel_20708/419365315.py:3: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
      "  MCI_hypnogram[email] = MCI_data[CN_data['EMAIL'] == email]\n"
     ]
    }
   ],
   "source": [
    "MCI_hypnogram = {}\n",
    "for email in MCI_data['EMAIL'].unique():\n",
    "    MCI_hypnogram[email] = MCI_data[CN_data['EMAIL'] == email]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "48e687d7",
   "metadata": {},
   "outputs": [],
   "source": [
    "MCI_concatenated_hypnogram = {}\n",
    "\n",
    "# 각 이메일 주소별로 데이터를 이어붙임\n",
    "for email, group in MCI_data.groupby('EMAIL'):\n",
    "    MCI_concatenated_hypnogram[email] = ''.join(group['CONVERT(sleep_hypnogram_5min USING utf8)'].str.replace('/', ''))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "50e03168",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>EMAIL</th>\n",
       "      <th>Length</th>\n",
       "      <th>Count_13</th>\n",
       "      <th>Count_31</th>\n",
       "      <th>Total_Count</th>\n",
       "      <th>Rating</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>nia+003@rowan.kr</td>\n",
       "      <td>6477</td>\n",
       "      <td>78</td>\n",
       "      <td>62</td>\n",
       "      <td>140</td>\n",
       "      <td>0.021615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>nia+010@rowan.kr</td>\n",
       "      <td>5337</td>\n",
       "      <td>30</td>\n",
       "      <td>11</td>\n",
       "      <td>41</td>\n",
       "      <td>0.007682</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>nia+014@rowan.kr</td>\n",
       "      <td>6495</td>\n",
       "      <td>33</td>\n",
       "      <td>14</td>\n",
       "      <td>47</td>\n",
       "      <td>0.007236</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>nia+016@rowan.kr</td>\n",
       "      <td>5706</td>\n",
       "      <td>22</td>\n",
       "      <td>6</td>\n",
       "      <td>28</td>\n",
       "      <td>0.004907</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>nia+037@rowan.kr</td>\n",
       "      <td>5732</td>\n",
       "      <td>27</td>\n",
       "      <td>15</td>\n",
       "      <td>42</td>\n",
       "      <td>0.007327</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>nia+043@rowan.kr</td>\n",
       "      <td>9060</td>\n",
       "      <td>73</td>\n",
       "      <td>51</td>\n",
       "      <td>124</td>\n",
       "      <td>0.013687</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>nia+044@rowan.kr</td>\n",
       "      <td>6619</td>\n",
       "      <td>45</td>\n",
       "      <td>18</td>\n",
       "      <td>63</td>\n",
       "      <td>0.009518</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>nia+046@rowan.kr</td>\n",
       "      <td>6150</td>\n",
       "      <td>66</td>\n",
       "      <td>59</td>\n",
       "      <td>125</td>\n",
       "      <td>0.020325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>nia+059@rowan.kr</td>\n",
       "      <td>10797</td>\n",
       "      <td>77</td>\n",
       "      <td>56</td>\n",
       "      <td>133</td>\n",
       "      <td>0.012318</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>nia+061@rowan.kr</td>\n",
       "      <td>7312</td>\n",
       "      <td>30</td>\n",
       "      <td>14</td>\n",
       "      <td>44</td>\n",
       "      <td>0.006018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>nia+066@rowan.kr</td>\n",
       "      <td>5159</td>\n",
       "      <td>44</td>\n",
       "      <td>11</td>\n",
       "      <td>55</td>\n",
       "      <td>0.010661</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>nia+068@rowan.kr</td>\n",
       "      <td>11127</td>\n",
       "      <td>74</td>\n",
       "      <td>39</td>\n",
       "      <td>113</td>\n",
       "      <td>0.010155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>nia+069@rowan.kr</td>\n",
       "      <td>7518</td>\n",
       "      <td>107</td>\n",
       "      <td>67</td>\n",
       "      <td>174</td>\n",
       "      <td>0.023144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>nia+083@rowan.kr</td>\n",
       "      <td>8471</td>\n",
       "      <td>53</td>\n",
       "      <td>51</td>\n",
       "      <td>104</td>\n",
       "      <td>0.012277</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>nia+088@rowan.kr</td>\n",
       "      <td>3412</td>\n",
       "      <td>45</td>\n",
       "      <td>15</td>\n",
       "      <td>60</td>\n",
       "      <td>0.017585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>nia+092@rowan.kr</td>\n",
       "      <td>5929</td>\n",
       "      <td>39</td>\n",
       "      <td>10</td>\n",
       "      <td>49</td>\n",
       "      <td>0.008264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>nia+096@rowan.kr</td>\n",
       "      <td>4018</td>\n",
       "      <td>33</td>\n",
       "      <td>18</td>\n",
       "      <td>51</td>\n",
       "      <td>0.012693</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>nia+106@rowan.kr</td>\n",
       "      <td>8291</td>\n",
       "      <td>39</td>\n",
       "      <td>21</td>\n",
       "      <td>60</td>\n",
       "      <td>0.007237</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>nia+126@rowan.kr</td>\n",
       "      <td>6862</td>\n",
       "      <td>75</td>\n",
       "      <td>63</td>\n",
       "      <td>138</td>\n",
       "      <td>0.020111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>nia+131@rowan.kr</td>\n",
       "      <td>10716</td>\n",
       "      <td>71</td>\n",
       "      <td>62</td>\n",
       "      <td>133</td>\n",
       "      <td>0.012411</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>nia+135@rowan.kr</td>\n",
       "      <td>7907</td>\n",
       "      <td>113</td>\n",
       "      <td>72</td>\n",
       "      <td>185</td>\n",
       "      <td>0.023397</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>nia+144@rowan.kr</td>\n",
       "      <td>6090</td>\n",
       "      <td>36</td>\n",
       "      <td>19</td>\n",
       "      <td>55</td>\n",
       "      <td>0.009031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>nia+153@rowan.kr</td>\n",
       "      <td>9123</td>\n",
       "      <td>70</td>\n",
       "      <td>24</td>\n",
       "      <td>94</td>\n",
       "      <td>0.010304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>nia+154@rowan.kr</td>\n",
       "      <td>7209</td>\n",
       "      <td>34</td>\n",
       "      <td>18</td>\n",
       "      <td>52</td>\n",
       "      <td>0.007213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>nia+155@rowan.kr</td>\n",
       "      <td>7362</td>\n",
       "      <td>34</td>\n",
       "      <td>25</td>\n",
       "      <td>59</td>\n",
       "      <td>0.008014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>nia+161@rowan.kr</td>\n",
       "      <td>5127</td>\n",
       "      <td>17</td>\n",
       "      <td>9</td>\n",
       "      <td>26</td>\n",
       "      <td>0.005071</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>nia+171@rowan.kr</td>\n",
       "      <td>7444</td>\n",
       "      <td>51</td>\n",
       "      <td>33</td>\n",
       "      <td>84</td>\n",
       "      <td>0.011284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>nia+175@rowan.kr</td>\n",
       "      <td>7449</td>\n",
       "      <td>34</td>\n",
       "      <td>22</td>\n",
       "      <td>56</td>\n",
       "      <td>0.007518</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>nia+182@rowan.kr</td>\n",
       "      <td>4990</td>\n",
       "      <td>33</td>\n",
       "      <td>23</td>\n",
       "      <td>56</td>\n",
       "      <td>0.011222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>nia+187@rowan.kr</td>\n",
       "      <td>6547</td>\n",
       "      <td>23</td>\n",
       "      <td>15</td>\n",
       "      <td>38</td>\n",
       "      <td>0.005804</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>nia+190@rowan.kr</td>\n",
       "      <td>5719</td>\n",
       "      <td>34</td>\n",
       "      <td>18</td>\n",
       "      <td>52</td>\n",
       "      <td>0.009092</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>nia+204@rowan.kr</td>\n",
       "      <td>7329</td>\n",
       "      <td>79</td>\n",
       "      <td>57</td>\n",
       "      <td>136</td>\n",
       "      <td>0.018556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>nia+213@rowan.kr</td>\n",
       "      <td>9194</td>\n",
       "      <td>55</td>\n",
       "      <td>46</td>\n",
       "      <td>101</td>\n",
       "      <td>0.010985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>nia+238@rowan.kr</td>\n",
       "      <td>6625</td>\n",
       "      <td>99</td>\n",
       "      <td>32</td>\n",
       "      <td>131</td>\n",
       "      <td>0.019774</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>nia+252@rowan.kr</td>\n",
       "      <td>7667</td>\n",
       "      <td>68</td>\n",
       "      <td>27</td>\n",
       "      <td>95</td>\n",
       "      <td>0.012391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>nia+265@rowan.kr</td>\n",
       "      <td>11606</td>\n",
       "      <td>116</td>\n",
       "      <td>45</td>\n",
       "      <td>161</td>\n",
       "      <td>0.013872</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>nia+268@rowan.kr</td>\n",
       "      <td>7370</td>\n",
       "      <td>20</td>\n",
       "      <td>13</td>\n",
       "      <td>33</td>\n",
       "      <td>0.004478</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>nia+279@rowan.kr</td>\n",
       "      <td>6122</td>\n",
       "      <td>50</td>\n",
       "      <td>39</td>\n",
       "      <td>89</td>\n",
       "      <td>0.014538</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>nia+283@rowan.kr</td>\n",
       "      <td>7701</td>\n",
       "      <td>44</td>\n",
       "      <td>16</td>\n",
       "      <td>60</td>\n",
       "      <td>0.007791</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>nia+284@rowan.kr</td>\n",
       "      <td>8160</td>\n",
       "      <td>14</td>\n",
       "      <td>13</td>\n",
       "      <td>27</td>\n",
       "      <td>0.003309</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>nia+288@rowan.kr</td>\n",
       "      <td>6775</td>\n",
       "      <td>38</td>\n",
       "      <td>20</td>\n",
       "      <td>58</td>\n",
       "      <td>0.008561</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>nia+291@rowan.kr</td>\n",
       "      <td>7950</td>\n",
       "      <td>104</td>\n",
       "      <td>56</td>\n",
       "      <td>160</td>\n",
       "      <td>0.020126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>nia+332@rowan.kr</td>\n",
       "      <td>4525</td>\n",
       "      <td>65</td>\n",
       "      <td>40</td>\n",
       "      <td>105</td>\n",
       "      <td>0.023204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>nia+336@rowan.kr</td>\n",
       "      <td>6702</td>\n",
       "      <td>87</td>\n",
       "      <td>36</td>\n",
       "      <td>123</td>\n",
       "      <td>0.018353</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>nia+433@rowan.kr</td>\n",
       "      <td>4760</td>\n",
       "      <td>44</td>\n",
       "      <td>14</td>\n",
       "      <td>58</td>\n",
       "      <td>0.012185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>nia+448@rowan.kr</td>\n",
       "      <td>3561</td>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>19</td>\n",
       "      <td>0.005336</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>nia+462@rowan.kr</td>\n",
       "      <td>4185</td>\n",
       "      <td>38</td>\n",
       "      <td>19</td>\n",
       "      <td>57</td>\n",
       "      <td>0.013620</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               EMAIL  Length  Count_13  Count_31  Total_Count    Rating\n",
       "0   nia+003@rowan.kr    6477        78        62          140  0.021615\n",
       "1   nia+010@rowan.kr    5337        30        11           41  0.007682\n",
       "2   nia+014@rowan.kr    6495        33        14           47  0.007236\n",
       "3   nia+016@rowan.kr    5706        22         6           28  0.004907\n",
       "4   nia+037@rowan.kr    5732        27        15           42  0.007327\n",
       "5   nia+043@rowan.kr    9060        73        51          124  0.013687\n",
       "6   nia+044@rowan.kr    6619        45        18           63  0.009518\n",
       "7   nia+046@rowan.kr    6150        66        59          125  0.020325\n",
       "8   nia+059@rowan.kr   10797        77        56          133  0.012318\n",
       "9   nia+061@rowan.kr    7312        30        14           44  0.006018\n",
       "10  nia+066@rowan.kr    5159        44        11           55  0.010661\n",
       "11  nia+068@rowan.kr   11127        74        39          113  0.010155\n",
       "12  nia+069@rowan.kr    7518       107        67          174  0.023144\n",
       "13  nia+083@rowan.kr    8471        53        51          104  0.012277\n",
       "14  nia+088@rowan.kr    3412        45        15           60  0.017585\n",
       "15  nia+092@rowan.kr    5929        39        10           49  0.008264\n",
       "16  nia+096@rowan.kr    4018        33        18           51  0.012693\n",
       "17  nia+106@rowan.kr    8291        39        21           60  0.007237\n",
       "18  nia+126@rowan.kr    6862        75        63          138  0.020111\n",
       "19  nia+131@rowan.kr   10716        71        62          133  0.012411\n",
       "20  nia+135@rowan.kr    7907       113        72          185  0.023397\n",
       "21  nia+144@rowan.kr    6090        36        19           55  0.009031\n",
       "22  nia+153@rowan.kr    9123        70        24           94  0.010304\n",
       "23  nia+154@rowan.kr    7209        34        18           52  0.007213\n",
       "24  nia+155@rowan.kr    7362        34        25           59  0.008014\n",
       "25  nia+161@rowan.kr    5127        17         9           26  0.005071\n",
       "26  nia+171@rowan.kr    7444        51        33           84  0.011284\n",
       "27  nia+175@rowan.kr    7449        34        22           56  0.007518\n",
       "28  nia+182@rowan.kr    4990        33        23           56  0.011222\n",
       "29  nia+187@rowan.kr    6547        23        15           38  0.005804\n",
       "30  nia+190@rowan.kr    5719        34        18           52  0.009092\n",
       "31  nia+204@rowan.kr    7329        79        57          136  0.018556\n",
       "32  nia+213@rowan.kr    9194        55        46          101  0.010985\n",
       "33  nia+238@rowan.kr    6625        99        32          131  0.019774\n",
       "34  nia+252@rowan.kr    7667        68        27           95  0.012391\n",
       "35  nia+265@rowan.kr   11606       116        45          161  0.013872\n",
       "36  nia+268@rowan.kr    7370        20        13           33  0.004478\n",
       "37  nia+279@rowan.kr    6122        50        39           89  0.014538\n",
       "38  nia+283@rowan.kr    7701        44        16           60  0.007791\n",
       "39  nia+284@rowan.kr    8160        14        13           27  0.003309\n",
       "40  nia+288@rowan.kr    6775        38        20           58  0.008561\n",
       "41  nia+291@rowan.kr    7950       104        56          160  0.020126\n",
       "42  nia+332@rowan.kr    4525        65        40          105  0.023204\n",
       "43  nia+336@rowan.kr    6702        87        36          123  0.018353\n",
       "44  nia+433@rowan.kr    4760        44        14           58  0.012185\n",
       "45  nia+448@rowan.kr    3561         9        10           19  0.005336\n",
       "46  nia+462@rowan.kr    4185        38        19           57  0.013620"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 이메일, 길이, 1과 3이 연속해서 나오는 횟수, 3과 1이 연속해서 나오는 횟수를 저장할 리스트 초기화\n",
    "emails = []\n",
    "lengths = []\n",
    "count_13 = []\n",
    "count_31 = []\n",
    "\n",
    "# 각 이메일 주소별로 데이터를 처리하여 리스트에 저장\n",
    "for email, hypnogram in MCI_concatenated_hypnogram.items():\n",
    "    emails.append(email)\n",
    "    lengths.append(len(hypnogram))\n",
    "\n",
    "    # 연속된 1과 3, 3과 1의 횟수 초기화\n",
    "    count_13.append(0)\n",
    "    count_31.append(0)\n",
    "\n",
    "    # hypnogram 문자열을 순회하면서 연속된 숫자 쌍을 찾음\n",
    "    for i in range(len(hypnogram) - 1):\n",
    "        if hypnogram[i:i+2] == '13':\n",
    "            count_13[-1] += 1\n",
    "        elif hypnogram[i:i+2] == '31':\n",
    "            count_31[-1] += 1\n",
    "\n",
    "# 데이터프레임 생성\n",
    "MCI_hypnogram_count = pd.DataFrame({\n",
    "    'EMAIL': emails,\n",
    "    'Length': lengths,\n",
    "    'Count_13': count_13,\n",
    "    'Count_31': count_31\n",
    "})\n",
    "\n",
    "# 1과 3이 연속해서 나오는 횟수와 3과 1이 연속해서 나오는 횟수를 더한 값을 새로운 열로 추가\n",
    "MCI_hypnogram_count['Total_Count'] = MCI_hypnogram_count['Count_13'] + MCI_hypnogram_count['Count_31']\n",
    "\n",
    "# 길이에 따른 1-3, 3-1 연속적으로 나타나는 횟수 비율\n",
    "MCI_hypnogram_count['Rating'] = (MCI_hypnogram_count['Count_13'] + MCI_hypnogram_count['Count_31'])/MCI_hypnogram_count['Length']\n",
    "\n",
    "# 결과 확인\n",
    "MCI_hypnogram_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "eb59060b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "경증의 평균 Rating : 0.011919197575439584\n"
     ]
    }
   ],
   "source": [
    "print(\"경증의 평균 Rating : \"+ str(MCI_hypnogram_count['Rating'].mean()))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3ba2945d",
   "metadata": {},
   "source": [
    "# hypnogram 결과"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "6a18969f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "일반인의 평균 Rating : 0.013613963195989431\n",
      "경증의 평균 Rating : 0.011919197575439584\n",
      "치매 환자의 평균 Rating : 0.008752040475790765\n"
     ]
    }
   ],
   "source": [
    "print(\"일반인의 평균 Rating : \"+ str(CN_hypnogram_count['Rating'].mean()))\n",
    "print(\"경증의 평균 Rating : \"+ str(MCI_hypnogram_count['Rating'].mean()))\n",
    "print(\"치매 환자의 평균 Rating : \"+ str(Dem_hypnogram_count['Rating'].mean()))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "aaff5198",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "153d2d6e",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "177f6e0c",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0a956471",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e53c46f1",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a6e727fc",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "97b214bf",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3223a8f3",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8213cd70",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d5d7e025",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6779bcae",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "7b200ca9",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}