modeling.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "hello\n"
     ]
    }
   ],
   "source": [
    "print('hello')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# pip install --upgrade pip"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# pip install auto-sklearn"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# pip install auto-sklearn"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "import seaborn.objects as so\n",
    "import missingno as msno \n",
    "import os\n",
    "from fancyimpute import IterativeImputer# Window의 한글 폰트 설정\n",
    "plt.rc('font', family='Malgun Gothic')\n",
    "plt.rc('axes', unicode_minus=False)\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')\n",
    "from sklearn.preprocessing import StandardScaler\n",
    "from sklearn.preprocessing import MinMaxScaler\n",
    "from sklearn.preprocessing import MaxAbsScaler\n",
    "from sklearn.preprocessing import RobustScaler\n",
    "# import autosklearn.classification\n",
    "from sklearn.ensemble import GradientBoostingRegressor\n",
    "from sklearn.tree import DecisionTreeClassifier\n",
    "from sklearn.metrics import accuracy_score\n",
    "\n",
    "%config InlineBackend.figure_format = 'retina'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'c:\\\\Users\\\\정호원\\\\OneDrive\\\\바탕 화면\\\\baf\\\\치매 프로젝트\\\\0428 모델링'"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "os.getcwd()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('final_modeling_data.csv',encoding='cp949')\n",
    "df_val = pd.read_csv('final_modeling_val_data.csv',encoding='cp949')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>Unnamed: 0</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_high</th>\n",
       "      <th>activity_inactive</th>\n",
       "      <th>activity_inactivity_alerts</th>\n",
       "      <th>activity_low</th>\n",
       "      <th>...</th>\n",
       "      <th>sleep_onset_latency</th>\n",
       "      <th>sleep_period_id</th>\n",
       "      <th>sleep_rem</th>\n",
       "      <th>sleep_restless</th>\n",
       "      <th>sleep_rmssd</th>\n",
       "      <th>sleep_temperature_delta</th>\n",
       "      <th>sleep_total</th>\n",
       "      <th>DIAG_NM</th>\n",
       "      <th>Rating</th>\n",
       "      <th>TOTAL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>nia+279@rowan.kr</td>\n",
       "      <td>1.28125</td>\n",
       "      <td>196</td>\n",
       "      <td>2251</td>\n",
       "      <td>3353</td>\n",
       "      <td>0</td>\n",
       "      <td>714</td>\n",
       "      <td>0</td>\n",
       "      <td>201</td>\n",
       "      <td>...</td>\n",
       "      <td>630</td>\n",
       "      <td>0</td>\n",
       "      <td>3780</td>\n",
       "      <td>24</td>\n",
       "      <td>39</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29220</td>\n",
       "      <td>MCI</td>\n",
       "      <td>0.014538</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>nia+279@rowan.kr</td>\n",
       "      <td>1.25000</td>\n",
       "      <td>145</td>\n",
       "      <td>2159</td>\n",
       "      <td>2516</td>\n",
       "      <td>0</td>\n",
       "      <td>719</td>\n",
       "      <td>0</td>\n",
       "      <td>131</td>\n",
       "      <td>...</td>\n",
       "      <td>930</td>\n",
       "      <td>1</td>\n",
       "      <td>2850</td>\n",
       "      <td>25</td>\n",
       "      <td>38</td>\n",
       "      <td>0.34</td>\n",
       "      <td>22110</td>\n",
       "      <td>MCI</td>\n",
       "      <td>0.014538</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>nia+279@rowan.kr</td>\n",
       "      <td>1.21875</td>\n",
       "      <td>118</td>\n",
       "      <td>2140</td>\n",
       "      <td>1716</td>\n",
       "      <td>0</td>\n",
       "      <td>708</td>\n",
       "      <td>1</td>\n",
       "      <td>125</td>\n",
       "      <td>...</td>\n",
       "      <td>330</td>\n",
       "      <td>0</td>\n",
       "      <td>4530</td>\n",
       "      <td>35</td>\n",
       "      <td>47</td>\n",
       "      <td>-0.07</td>\n",
       "      <td>21510</td>\n",
       "      <td>MCI</td>\n",
       "      <td>0.014538</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>nia+279@rowan.kr</td>\n",
       "      <td>1.28125</td>\n",
       "      <td>180</td>\n",
       "      <td>2240</td>\n",
       "      <td>2791</td>\n",
       "      <td>0</td>\n",
       "      <td>705</td>\n",
       "      <td>0</td>\n",
       "      <td>203</td>\n",
       "      <td>...</td>\n",
       "      <td>510</td>\n",
       "      <td>3</td>\n",
       "      <td>4860</td>\n",
       "      <td>21</td>\n",
       "      <td>44</td>\n",
       "      <td>-0.14</td>\n",
       "      <td>21360</td>\n",
       "      <td>MCI</td>\n",
       "      <td>0.014538</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>nia+279@rowan.kr</td>\n",
       "      <td>1.46875</td>\n",
       "      <td>374</td>\n",
       "      <td>2559</td>\n",
       "      <td>5393</td>\n",
       "      <td>0</td>\n",
       "      <td>437</td>\n",
       "      <td>0</td>\n",
       "      <td>511</td>\n",
       "      <td>...</td>\n",
       "      <td>420</td>\n",
       "      <td>0</td>\n",
       "      <td>1740</td>\n",
       "      <td>29</td>\n",
       "      <td>56</td>\n",
       "      <td>-0.50</td>\n",
       "      <td>13530</td>\n",
       "      <td>MCI</td>\n",
       "      <td>0.014538</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 40 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0             EMAIL  activity_average_met  activity_cal_active  \\\n",
       "0           0  nia+279@rowan.kr               1.28125                  196   \n",
       "1           1  nia+279@rowan.kr               1.25000                  145   \n",
       "2           2  nia+279@rowan.kr               1.21875                  118   \n",
       "3           3  nia+279@rowan.kr               1.28125                  180   \n",
       "4           4  nia+279@rowan.kr               1.46875                  374   \n",
       "\n",
       "   activity_cal_total  activity_daily_movement  activity_high  \\\n",
       "0                2251                     3353              0   \n",
       "1                2159                     2516              0   \n",
       "2                2140                     1716              0   \n",
       "3                2240                     2791              0   \n",
       "4                2559                     5393              0   \n",
       "\n",
       "   activity_inactive  activity_inactivity_alerts  activity_low  ...  \\\n",
       "0                714                           0           201  ...   \n",
       "1                719                           0           131  ...   \n",
       "2                708                           1           125  ...   \n",
       "3                705                           0           203  ...   \n",
       "4                437                           0           511  ...   \n",
       "\n",
       "   sleep_onset_latency  sleep_period_id  sleep_rem  sleep_restless  \\\n",
       "0                  630                0       3780              24   \n",
       "1                  930                1       2850              25   \n",
       "2                  330                0       4530              35   \n",
       "3                  510                3       4860              21   \n",
       "4                  420                0       1740              29   \n",
       "\n",
       "   sleep_rmssd  sleep_temperature_delta  sleep_total  DIAG_NM    Rating  TOTAL  \n",
       "0           39                     0.00        29220      MCI  0.014538     72  \n",
       "1           38                     0.34        22110      MCI  0.014538     72  \n",
       "2           47                    -0.07        21510      MCI  0.014538     72  \n",
       "3           44                    -0.14        21360      MCI  0.014538     72  \n",
       "4           56                    -0.50        13530      MCI  0.014538     72  \n",
       "\n",
       "[5 rows x 40 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>Unnamed: 0</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_high</th>\n",
       "      <th>activity_inactive</th>\n",
       "      <th>activity_inactivity_alerts</th>\n",
       "      <th>activity_low</th>\n",
       "      <th>...</th>\n",
       "      <th>sleep_onset_latency</th>\n",
       "      <th>sleep_period_id</th>\n",
       "      <th>sleep_rem</th>\n",
       "      <th>sleep_restless</th>\n",
       "      <th>sleep_rmssd</th>\n",
       "      <th>sleep_temperature_delta</th>\n",
       "      <th>sleep_total</th>\n",
       "      <th>DIAG_NM</th>\n",
       "      <th>Rating</th>\n",
       "      <th>TOTAL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>nia+279@rowan.kr</td>\n",
       "      <td>1.28125</td>\n",
       "      <td>196</td>\n",
       "      <td>2251</td>\n",
       "      <td>3353</td>\n",
       "      <td>0</td>\n",
       "      <td>714</td>\n",
       "      <td>0</td>\n",
       "      <td>201</td>\n",
       "      <td>...</td>\n",
       "      <td>630</td>\n",
       "      <td>0</td>\n",
       "      <td>3780</td>\n",
       "      <td>24</td>\n",
       "      <td>39</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29220</td>\n",
       "      <td>MCI</td>\n",
       "      <td>0.014538</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>nia+279@rowan.kr</td>\n",
       "      <td>1.25000</td>\n",
       "      <td>145</td>\n",
       "      <td>2159</td>\n",
       "      <td>2516</td>\n",
       "      <td>0</td>\n",
       "      <td>719</td>\n",
       "      <td>0</td>\n",
       "      <td>131</td>\n",
       "      <td>...</td>\n",
       "      <td>930</td>\n",
       "      <td>1</td>\n",
       "      <td>2850</td>\n",
       "      <td>25</td>\n",
       "      <td>38</td>\n",
       "      <td>0.34</td>\n",
       "      <td>22110</td>\n",
       "      <td>MCI</td>\n",
       "      <td>0.014538</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>nia+279@rowan.kr</td>\n",
       "      <td>1.21875</td>\n",
       "      <td>118</td>\n",
       "      <td>2140</td>\n",
       "      <td>1716</td>\n",
       "      <td>0</td>\n",
       "      <td>708</td>\n",
       "      <td>1</td>\n",
       "      <td>125</td>\n",
       "      <td>...</td>\n",
       "      <td>330</td>\n",
       "      <td>0</td>\n",
       "      <td>4530</td>\n",
       "      <td>35</td>\n",
       "      <td>47</td>\n",
       "      <td>-0.07</td>\n",
       "      <td>21510</td>\n",
       "      <td>MCI</td>\n",
       "      <td>0.014538</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>nia+279@rowan.kr</td>\n",
       "      <td>1.28125</td>\n",
       "      <td>180</td>\n",
       "      <td>2240</td>\n",
       "      <td>2791</td>\n",
       "      <td>0</td>\n",
       "      <td>705</td>\n",
       "      <td>0</td>\n",
       "      <td>203</td>\n",
       "      <td>...</td>\n",
       "      <td>510</td>\n",
       "      <td>3</td>\n",
       "      <td>4860</td>\n",
       "      <td>21</td>\n",
       "      <td>44</td>\n",
       "      <td>-0.14</td>\n",
       "      <td>21360</td>\n",
       "      <td>MCI</td>\n",
       "      <td>0.014538</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>nia+279@rowan.kr</td>\n",
       "      <td>1.46875</td>\n",
       "      <td>374</td>\n",
       "      <td>2559</td>\n",
       "      <td>5393</td>\n",
       "      <td>0</td>\n",
       "      <td>437</td>\n",
       "      <td>0</td>\n",
       "      <td>511</td>\n",
       "      <td>...</td>\n",
       "      <td>420</td>\n",
       "      <td>0</td>\n",
       "      <td>1740</td>\n",
       "      <td>29</td>\n",
       "      <td>56</td>\n",
       "      <td>-0.50</td>\n",
       "      <td>13530</td>\n",
       "      <td>MCI</td>\n",
       "      <td>0.014538</td>\n",
       "      <td>72</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>9700</th>\n",
       "      <td>9700</td>\n",
       "      <td>nia+206@rowan.kr</td>\n",
       "      <td>1.34375</td>\n",
       "      <td>249</td>\n",
       "      <td>2351</td>\n",
       "      <td>4411</td>\n",
       "      <td>1</td>\n",
       "      <td>780</td>\n",
       "      <td>4</td>\n",
       "      <td>167</td>\n",
       "      <td>...</td>\n",
       "      <td>450</td>\n",
       "      <td>0</td>\n",
       "      <td>6330</td>\n",
       "      <td>52</td>\n",
       "      <td>18</td>\n",
       "      <td>-0.09</td>\n",
       "      <td>27360</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.010977</td>\n",
       "      <td>97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9701</th>\n",
       "      <td>9701</td>\n",
       "      <td>nia+206@rowan.kr</td>\n",
       "      <td>1.53125</td>\n",
       "      <td>570</td>\n",
       "      <td>2682</td>\n",
       "      <td>11057</td>\n",
       "      <td>1</td>\n",
       "      <td>518</td>\n",
       "      <td>1</td>\n",
       "      <td>332</td>\n",
       "      <td>...</td>\n",
       "      <td>600</td>\n",
       "      <td>0</td>\n",
       "      <td>5880</td>\n",
       "      <td>57</td>\n",
       "      <td>15</td>\n",
       "      <td>0.41</td>\n",
       "      <td>22020</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.010977</td>\n",
       "      <td>97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9702</th>\n",
       "      <td>9702</td>\n",
       "      <td>nia+206@rowan.kr</td>\n",
       "      <td>1.34375</td>\n",
       "      <td>295</td>\n",
       "      <td>2331</td>\n",
       "      <td>5135</td>\n",
       "      <td>4</td>\n",
       "      <td>578</td>\n",
       "      <td>0</td>\n",
       "      <td>173</td>\n",
       "      <td>...</td>\n",
       "      <td>1140</td>\n",
       "      <td>1</td>\n",
       "      <td>7740</td>\n",
       "      <td>52</td>\n",
       "      <td>17</td>\n",
       "      <td>0.27</td>\n",
       "      <td>30390</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.010977</td>\n",
       "      <td>97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9703</th>\n",
       "      <td>9703</td>\n",
       "      <td>nia+206@rowan.kr</td>\n",
       "      <td>1.31250</td>\n",
       "      <td>186</td>\n",
       "      <td>2280</td>\n",
       "      <td>3178</td>\n",
       "      <td>0</td>\n",
       "      <td>778</td>\n",
       "      <td>1</td>\n",
       "      <td>138</td>\n",
       "      <td>...</td>\n",
       "      <td>630</td>\n",
       "      <td>0</td>\n",
       "      <td>5700</td>\n",
       "      <td>48</td>\n",
       "      <td>16</td>\n",
       "      <td>-0.05</td>\n",
       "      <td>25800</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.010977</td>\n",
       "      <td>97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9704</th>\n",
       "      <td>9704</td>\n",
       "      <td>nia+206@rowan.kr</td>\n",
       "      <td>1.37500</td>\n",
       "      <td>83</td>\n",
       "      <td>1891</td>\n",
       "      <td>1554</td>\n",
       "      <td>0</td>\n",
       "      <td>69</td>\n",
       "      <td>0</td>\n",
       "      <td>61</td>\n",
       "      <td>...</td>\n",
       "      <td>870</td>\n",
       "      <td>0</td>\n",
       "      <td>5010</td>\n",
       "      <td>55</td>\n",
       "      <td>23</td>\n",
       "      <td>0.26</td>\n",
       "      <td>22470</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.010977</td>\n",
       "      <td>97</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9705 rows × 40 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0             EMAIL  activity_average_met  activity_cal_active  \\\n",
       "0              0  nia+279@rowan.kr               1.28125                  196   \n",
       "1              1  nia+279@rowan.kr               1.25000                  145   \n",
       "2              2  nia+279@rowan.kr               1.21875                  118   \n",
       "3              3  nia+279@rowan.kr               1.28125                  180   \n",
       "4              4  nia+279@rowan.kr               1.46875                  374   \n",
       "...          ...               ...                   ...                  ...   \n",
       "9700        9700  nia+206@rowan.kr               1.34375                  249   \n",
       "9701        9701  nia+206@rowan.kr               1.53125                  570   \n",
       "9702        9702  nia+206@rowan.kr               1.34375                  295   \n",
       "9703        9703  nia+206@rowan.kr               1.31250                  186   \n",
       "9704        9704  nia+206@rowan.kr               1.37500                   83   \n",
       "\n",
       "      activity_cal_total  activity_daily_movement  activity_high  \\\n",
       "0                   2251                     3353              0   \n",
       "1                   2159                     2516              0   \n",
       "2                   2140                     1716              0   \n",
       "3                   2240                     2791              0   \n",
       "4                   2559                     5393              0   \n",
       "...                  ...                      ...            ...   \n",
       "9700                2351                     4411              1   \n",
       "9701                2682                    11057              1   \n",
       "9702                2331                     5135              4   \n",
       "9703                2280                     3178              0   \n",
       "9704                1891                     1554              0   \n",
       "\n",
       "      activity_inactive  activity_inactivity_alerts  activity_low  ...  \\\n",
       "0                   714                           0           201  ...   \n",
       "1                   719                           0           131  ...   \n",
       "2                   708                           1           125  ...   \n",
       "3                   705                           0           203  ...   \n",
       "4                   437                           0           511  ...   \n",
       "...                 ...                         ...           ...  ...   \n",
       "9700                780                           4           167  ...   \n",
       "9701                518                           1           332  ...   \n",
       "9702                578                           0           173  ...   \n",
       "9703                778                           1           138  ...   \n",
       "9704                 69                           0            61  ...   \n",
       "\n",
       "      sleep_onset_latency  sleep_period_id  sleep_rem  sleep_restless  \\\n",
       "0                     630                0       3780              24   \n",
       "1                     930                1       2850              25   \n",
       "2                     330                0       4530              35   \n",
       "3                     510                3       4860              21   \n",
       "4                     420                0       1740              29   \n",
       "...                   ...              ...        ...             ...   \n",
       "9700                  450                0       6330              52   \n",
       "9701                  600                0       5880              57   \n",
       "9702                 1140                1       7740              52   \n",
       "9703                  630                0       5700              48   \n",
       "9704                  870                0       5010              55   \n",
       "\n",
       "      sleep_rmssd  sleep_temperature_delta  sleep_total  DIAG_NM    Rating  \\\n",
       "0              39                     0.00        29220      MCI  0.014538   \n",
       "1              38                     0.34        22110      MCI  0.014538   \n",
       "2              47                    -0.07        21510      MCI  0.014538   \n",
       "3              44                    -0.14        21360      MCI  0.014538   \n",
       "4              56                    -0.50        13530      MCI  0.014538   \n",
       "...           ...                      ...          ...      ...       ...   \n",
       "9700           18                    -0.09        27360       CN  0.010977   \n",
       "9701           15                     0.41        22020       CN  0.010977   \n",
       "9702           17                     0.27        30390       CN  0.010977   \n",
       "9703           16                    -0.05        25800       CN  0.010977   \n",
       "9704           23                     0.26        22470       CN  0.010977   \n",
       "\n",
       "      TOTAL  \n",
       "0        72  \n",
       "1        72  \n",
       "2        72  \n",
       "3        72  \n",
       "4        72  \n",
       "...     ...  \n",
       "9700     97  \n",
       "9701     97  \n",
       "9702     97  \n",
       "9703     97  \n",
       "9704     97  \n",
       "\n",
       "[9705 rows x 40 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>Unnamed: 0</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_high</th>\n",
       "      <th>activity_inactive</th>\n",
       "      <th>activity_inactivity_alerts</th>\n",
       "      <th>activity_low</th>\n",
       "      <th>...</th>\n",
       "      <th>sleep_onset_latency</th>\n",
       "      <th>sleep_period_id</th>\n",
       "      <th>sleep_rem</th>\n",
       "      <th>sleep_restless</th>\n",
       "      <th>sleep_rmssd</th>\n",
       "      <th>sleep_temperature_delta</th>\n",
       "      <th>sleep_total</th>\n",
       "      <th>DIAG_NM</th>\n",
       "      <th>Rating</th>\n",
       "      <th>TOTAL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>nia+404@rowan.kr</td>\n",
       "      <td>1.71875</td>\n",
       "      <td>730</td>\n",
       "      <td>2944</td>\n",
       "      <td>14346</td>\n",
       "      <td>0</td>\n",
       "      <td>417</td>\n",
       "      <td>0</td>\n",
       "      <td>545</td>\n",
       "      <td>...</td>\n",
       "      <td>960</td>\n",
       "      <td>0</td>\n",
       "      <td>4380</td>\n",
       "      <td>47</td>\n",
       "      <td>20</td>\n",
       "      <td>-0.12</td>\n",
       "      <td>21510</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.013152</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>nia+404@rowan.kr</td>\n",
       "      <td>1.40625</td>\n",
       "      <td>342</td>\n",
       "      <td>2449</td>\n",
       "      <td>6352</td>\n",
       "      <td>0</td>\n",
       "      <td>473</td>\n",
       "      <td>0</td>\n",
       "      <td>392</td>\n",
       "      <td>...</td>\n",
       "      <td>690</td>\n",
       "      <td>0</td>\n",
       "      <td>2400</td>\n",
       "      <td>56</td>\n",
       "      <td>19</td>\n",
       "      <td>-0.32</td>\n",
       "      <td>17040</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.013152</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>nia+404@rowan.kr</td>\n",
       "      <td>1.46875</td>\n",
       "      <td>401</td>\n",
       "      <td>2544</td>\n",
       "      <td>7297</td>\n",
       "      <td>0</td>\n",
       "      <td>586</td>\n",
       "      <td>0</td>\n",
       "      <td>362</td>\n",
       "      <td>...</td>\n",
       "      <td>1140</td>\n",
       "      <td>0</td>\n",
       "      <td>2760</td>\n",
       "      <td>48</td>\n",
       "      <td>26</td>\n",
       "      <td>0.07</td>\n",
       "      <td>21360</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.013152</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>nia+404@rowan.kr</td>\n",
       "      <td>0.34375</td>\n",
       "      <td>27</td>\n",
       "      <td>1850</td>\n",
       "      <td>491</td>\n",
       "      <td>0</td>\n",
       "      <td>176</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "      <td>...</td>\n",
       "      <td>1170</td>\n",
       "      <td>0</td>\n",
       "      <td>1980</td>\n",
       "      <td>59</td>\n",
       "      <td>30</td>\n",
       "      <td>-0.41</td>\n",
       "      <td>20100</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.013152</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>nia+404@rowan.kr</td>\n",
       "      <td>1.46875</td>\n",
       "      <td>333</td>\n",
       "      <td>2518</td>\n",
       "      <td>5861</td>\n",
       "      <td>0</td>\n",
       "      <td>646</td>\n",
       "      <td>0</td>\n",
       "      <td>377</td>\n",
       "      <td>...</td>\n",
       "      <td>3360</td>\n",
       "      <td>0</td>\n",
       "      <td>3570</td>\n",
       "      <td>42</td>\n",
       "      <td>23</td>\n",
       "      <td>-0.27</td>\n",
       "      <td>20730</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.013152</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 40 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0             EMAIL  activity_average_met  activity_cal_active  \\\n",
       "0           0  nia+404@rowan.kr               1.71875                  730   \n",
       "1           1  nia+404@rowan.kr               1.40625                  342   \n",
       "2           2  nia+404@rowan.kr               1.46875                  401   \n",
       "3           3  nia+404@rowan.kr               0.34375                   27   \n",
       "4           4  nia+404@rowan.kr               1.46875                  333   \n",
       "\n",
       "   activity_cal_total  activity_daily_movement  activity_high  \\\n",
       "0                2944                    14346              0   \n",
       "1                2449                     6352              0   \n",
       "2                2544                     7297              0   \n",
       "3                1850                      491              0   \n",
       "4                2518                     5861              0   \n",
       "\n",
       "   activity_inactive  activity_inactivity_alerts  activity_low  ...  \\\n",
       "0                417                           0           545  ...   \n",
       "1                473                           0           392  ...   \n",
       "2                586                           0           362  ...   \n",
       "3                176                           0            34  ...   \n",
       "4                646                           0           377  ...   \n",
       "\n",
       "   sleep_onset_latency  sleep_period_id  sleep_rem  sleep_restless  \\\n",
       "0                  960                0       4380              47   \n",
       "1                  690                0       2400              56   \n",
       "2                 1140                0       2760              48   \n",
       "3                 1170                0       1980              59   \n",
       "4                 3360                0       3570              42   \n",
       "\n",
       "   sleep_rmssd  sleep_temperature_delta  sleep_total  DIAG_NM    Rating  TOTAL  \n",
       "0           20                    -0.12        21510       CN  0.013152     88  \n",
       "1           19                    -0.32        17040       CN  0.013152     88  \n",
       "2           26                     0.07        21360       CN  0.013152     88  \n",
       "3           30                    -0.41        20100       CN  0.013152     88  \n",
       "4           23                    -0.27        20730       CN  0.013152     88  \n",
       "\n",
       "[5 rows x 40 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_val.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>Unnamed: 0</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_high</th>\n",
       "      <th>activity_inactive</th>\n",
       "      <th>activity_inactivity_alerts</th>\n",
       "      <th>activity_low</th>\n",
       "      <th>...</th>\n",
       "      <th>sleep_onset_latency</th>\n",
       "      <th>sleep_period_id</th>\n",
       "      <th>sleep_rem</th>\n",
       "      <th>sleep_restless</th>\n",
       "      <th>sleep_rmssd</th>\n",
       "      <th>sleep_temperature_delta</th>\n",
       "      <th>sleep_total</th>\n",
       "      <th>DIAG_NM</th>\n",
       "      <th>Rating</th>\n",
       "      <th>TOTAL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>nia+404@rowan.kr</td>\n",
       "      <td>1.71875</td>\n",
       "      <td>730</td>\n",
       "      <td>2944</td>\n",
       "      <td>14346</td>\n",
       "      <td>0</td>\n",
       "      <td>417</td>\n",
       "      <td>0</td>\n",
       "      <td>545</td>\n",
       "      <td>...</td>\n",
       "      <td>960</td>\n",
       "      <td>0</td>\n",
       "      <td>4380</td>\n",
       "      <td>47</td>\n",
       "      <td>20</td>\n",
       "      <td>-0.12</td>\n",
       "      <td>21510</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.013152</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>nia+404@rowan.kr</td>\n",
       "      <td>1.40625</td>\n",
       "      <td>342</td>\n",
       "      <td>2449</td>\n",
       "      <td>6352</td>\n",
       "      <td>0</td>\n",
       "      <td>473</td>\n",
       "      <td>0</td>\n",
       "      <td>392</td>\n",
       "      <td>...</td>\n",
       "      <td>690</td>\n",
       "      <td>0</td>\n",
       "      <td>2400</td>\n",
       "      <td>56</td>\n",
       "      <td>19</td>\n",
       "      <td>-0.32</td>\n",
       "      <td>17040</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.013152</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>nia+404@rowan.kr</td>\n",
       "      <td>1.46875</td>\n",
       "      <td>401</td>\n",
       "      <td>2544</td>\n",
       "      <td>7297</td>\n",
       "      <td>0</td>\n",
       "      <td>586</td>\n",
       "      <td>0</td>\n",
       "      <td>362</td>\n",
       "      <td>...</td>\n",
       "      <td>1140</td>\n",
       "      <td>0</td>\n",
       "      <td>2760</td>\n",
       "      <td>48</td>\n",
       "      <td>26</td>\n",
       "      <td>0.07</td>\n",
       "      <td>21360</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.013152</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>nia+404@rowan.kr</td>\n",
       "      <td>0.34375</td>\n",
       "      <td>27</td>\n",
       "      <td>1850</td>\n",
       "      <td>491</td>\n",
       "      <td>0</td>\n",
       "      <td>176</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "      <td>...</td>\n",
       "      <td>1170</td>\n",
       "      <td>0</td>\n",
       "      <td>1980</td>\n",
       "      <td>59</td>\n",
       "      <td>30</td>\n",
       "      <td>-0.41</td>\n",
       "      <td>20100</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.013152</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>nia+404@rowan.kr</td>\n",
       "      <td>1.46875</td>\n",
       "      <td>333</td>\n",
       "      <td>2518</td>\n",
       "      <td>5861</td>\n",
       "      <td>0</td>\n",
       "      <td>646</td>\n",
       "      <td>0</td>\n",
       "      <td>377</td>\n",
       "      <td>...</td>\n",
       "      <td>3360</td>\n",
       "      <td>0</td>\n",
       "      <td>3570</td>\n",
       "      <td>42</td>\n",
       "      <td>23</td>\n",
       "      <td>-0.27</td>\n",
       "      <td>20730</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.013152</td>\n",
       "      <td>88</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>2473</th>\n",
       "      <td>2473</td>\n",
       "      <td>nia+280@rowan.kr</td>\n",
       "      <td>1.59375</td>\n",
       "      <td>648</td>\n",
       "      <td>2760</td>\n",
       "      <td>12256</td>\n",
       "      <td>0</td>\n",
       "      <td>444</td>\n",
       "      <td>0</td>\n",
       "      <td>381</td>\n",
       "      <td>...</td>\n",
       "      <td>1140</td>\n",
       "      <td>0</td>\n",
       "      <td>1470</td>\n",
       "      <td>30</td>\n",
       "      <td>40</td>\n",
       "      <td>-0.27</td>\n",
       "      <td>12300</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.016051</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2474</th>\n",
       "      <td>2474</td>\n",
       "      <td>nia+280@rowan.kr</td>\n",
       "      <td>1.43750</td>\n",
       "      <td>379</td>\n",
       "      <td>2507</td>\n",
       "      <td>6973</td>\n",
       "      <td>0</td>\n",
       "      <td>623</td>\n",
       "      <td>0</td>\n",
       "      <td>361</td>\n",
       "      <td>...</td>\n",
       "      <td>930</td>\n",
       "      <td>0</td>\n",
       "      <td>6510</td>\n",
       "      <td>33</td>\n",
       "      <td>34</td>\n",
       "      <td>-0.13</td>\n",
       "      <td>28800</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.016051</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2475</th>\n",
       "      <td>2475</td>\n",
       "      <td>nia+280@rowan.kr</td>\n",
       "      <td>1.56250</td>\n",
       "      <td>670</td>\n",
       "      <td>2747</td>\n",
       "      <td>13008</td>\n",
       "      <td>0</td>\n",
       "      <td>422</td>\n",
       "      <td>0</td>\n",
       "      <td>366</td>\n",
       "      <td>...</td>\n",
       "      <td>450</td>\n",
       "      <td>0</td>\n",
       "      <td>4140</td>\n",
       "      <td>42</td>\n",
       "      <td>30</td>\n",
       "      <td>0.21</td>\n",
       "      <td>27030</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.016051</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2476</th>\n",
       "      <td>2476</td>\n",
       "      <td>nia+280@rowan.kr</td>\n",
       "      <td>1.46875</td>\n",
       "      <td>556</td>\n",
       "      <td>2570</td>\n",
       "      <td>11043</td>\n",
       "      <td>0</td>\n",
       "      <td>452</td>\n",
       "      <td>2</td>\n",
       "      <td>244</td>\n",
       "      <td>...</td>\n",
       "      <td>360</td>\n",
       "      <td>0</td>\n",
       "      <td>7650</td>\n",
       "      <td>27</td>\n",
       "      <td>31</td>\n",
       "      <td>0.69</td>\n",
       "      <td>35910</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.016051</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2477</th>\n",
       "      <td>2477</td>\n",
       "      <td>nia+280@rowan.kr</td>\n",
       "      <td>1.34375</td>\n",
       "      <td>311</td>\n",
       "      <td>2341</td>\n",
       "      <td>5943</td>\n",
       "      <td>0</td>\n",
       "      <td>595</td>\n",
       "      <td>0</td>\n",
       "      <td>277</td>\n",
       "      <td>...</td>\n",
       "      <td>1200</td>\n",
       "      <td>0</td>\n",
       "      <td>1590</td>\n",
       "      <td>53</td>\n",
       "      <td>31</td>\n",
       "      <td>-0.91</td>\n",
       "      <td>24300</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.016051</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2478 rows × 40 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0             EMAIL  activity_average_met  activity_cal_active  \\\n",
       "0              0  nia+404@rowan.kr               1.71875                  730   \n",
       "1              1  nia+404@rowan.kr               1.40625                  342   \n",
       "2              2  nia+404@rowan.kr               1.46875                  401   \n",
       "3              3  nia+404@rowan.kr               0.34375                   27   \n",
       "4              4  nia+404@rowan.kr               1.46875                  333   \n",
       "...          ...               ...                   ...                  ...   \n",
       "2473        2473  nia+280@rowan.kr               1.59375                  648   \n",
       "2474        2474  nia+280@rowan.kr               1.43750                  379   \n",
       "2475        2475  nia+280@rowan.kr               1.56250                  670   \n",
       "2476        2476  nia+280@rowan.kr               1.46875                  556   \n",
       "2477        2477  nia+280@rowan.kr               1.34375                  311   \n",
       "\n",
       "      activity_cal_total  activity_daily_movement  activity_high  \\\n",
       "0                   2944                    14346              0   \n",
       "1                   2449                     6352              0   \n",
       "2                   2544                     7297              0   \n",
       "3                   1850                      491              0   \n",
       "4                   2518                     5861              0   \n",
       "...                  ...                      ...            ...   \n",
       "2473                2760                    12256              0   \n",
       "2474                2507                     6973              0   \n",
       "2475                2747                    13008              0   \n",
       "2476                2570                    11043              0   \n",
       "2477                2341                     5943              0   \n",
       "\n",
       "      activity_inactive  activity_inactivity_alerts  activity_low  ...  \\\n",
       "0                   417                           0           545  ...   \n",
       "1                   473                           0           392  ...   \n",
       "2                   586                           0           362  ...   \n",
       "3                   176                           0            34  ...   \n",
       "4                   646                           0           377  ...   \n",
       "...                 ...                         ...           ...  ...   \n",
       "2473                444                           0           381  ...   \n",
       "2474                623                           0           361  ...   \n",
       "2475                422                           0           366  ...   \n",
       "2476                452                           2           244  ...   \n",
       "2477                595                           0           277  ...   \n",
       "\n",
       "      sleep_onset_latency  sleep_period_id  sleep_rem  sleep_restless  \\\n",
       "0                     960                0       4380              47   \n",
       "1                     690                0       2400              56   \n",
       "2                    1140                0       2760              48   \n",
       "3                    1170                0       1980              59   \n",
       "4                    3360                0       3570              42   \n",
       "...                   ...              ...        ...             ...   \n",
       "2473                 1140                0       1470              30   \n",
       "2474                  930                0       6510              33   \n",
       "2475                  450                0       4140              42   \n",
       "2476                  360                0       7650              27   \n",
       "2477                 1200                0       1590              53   \n",
       "\n",
       "      sleep_rmssd  sleep_temperature_delta  sleep_total  DIAG_NM    Rating  \\\n",
       "0              20                    -0.12        21510       CN  0.013152   \n",
       "1              19                    -0.32        17040       CN  0.013152   \n",
       "2              26                     0.07        21360       CN  0.013152   \n",
       "3              30                    -0.41        20100       CN  0.013152   \n",
       "4              23                    -0.27        20730       CN  0.013152   \n",
       "...           ...                      ...          ...      ...       ...   \n",
       "2473           40                    -0.27        12300       CN  0.016051   \n",
       "2474           34                    -0.13        28800       CN  0.016051   \n",
       "2475           30                     0.21        27030       CN  0.016051   \n",
       "2476           31                     0.69        35910       CN  0.016051   \n",
       "2477           31                    -0.91        24300       CN  0.016051   \n",
       "\n",
       "      TOTAL  \n",
       "0        88  \n",
       "1        88  \n",
       "2        88  \n",
       "3        88  \n",
       "4        88  \n",
       "...     ...  \n",
       "2473     88  \n",
       "2474     88  \n",
       "2475     88  \n",
       "2476     88  \n",
       "2477     88  \n",
       "\n",
       "[2478 rows x 40 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_val"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Unnamed: 0', 'EMAIL', 'activity_average_met', 'activity_cal_active',\n",
       "       'activity_cal_total', 'activity_daily_movement', 'activity_high',\n",
       "       'activity_inactive', 'activity_inactivity_alerts', 'activity_low',\n",
       "       'activity_medium', 'activity_met_min_high', 'activity_met_min_inactive',\n",
       "       'activity_met_min_low', 'activity_met_min_medium', 'activity_non_wear',\n",
       "       'activity_rest', 'activity_steps', 'activity_total', 'sleep_awake',\n",
       "       'sleep_breath_average', 'sleep_deep', 'sleep_duration',\n",
       "       'sleep_efficiency', 'sleep_hr_average', 'sleep_hr_lowest',\n",
       "       'sleep_is_longest', 'sleep_light', 'sleep_midpoint_at_delta',\n",
       "       'sleep_midpoint_time', 'sleep_onset_latency', 'sleep_period_id',\n",
       "       'sleep_rem', 'sleep_restless', 'sleep_rmssd', 'sleep_temperature_delta',\n",
       "       'sleep_total', 'DIAG_NM', 'Rating', 'TOTAL'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# ***** 한 번만 하고 말아야됨 *****\n",
    "df = df.drop(df.columns[[0, 1]], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "# ***** 한 번만 하고 말아야됨 *****\n",
    "df_val = df_val.drop(df_val.columns[[0, 1]], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>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_high</th>\n",
       "      <th>activity_inactive</th>\n",
       "      <th>activity_inactivity_alerts</th>\n",
       "      <th>activity_low</th>\n",
       "      <th>activity_medium</th>\n",
       "      <th>activity_met_min_high</th>\n",
       "      <th>...</th>\n",
       "      <th>sleep_onset_latency</th>\n",
       "      <th>sleep_period_id</th>\n",
       "      <th>sleep_rem</th>\n",
       "      <th>sleep_restless</th>\n",
       "      <th>sleep_rmssd</th>\n",
       "      <th>sleep_temperature_delta</th>\n",
       "      <th>sleep_total</th>\n",
       "      <th>DIAG_NM</th>\n",
       "      <th>Rating</th>\n",
       "      <th>TOTAL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.28125</td>\n",
       "      <td>196</td>\n",
       "      <td>2251</td>\n",
       "      <td>3353</td>\n",
       "      <td>0</td>\n",
       "      <td>714</td>\n",
       "      <td>0</td>\n",
       "      <td>201</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>630</td>\n",
       "      <td>0</td>\n",
       "      <td>3780</td>\n",
       "      <td>24</td>\n",
       "      <td>39</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29220</td>\n",
       "      <td>MCI</td>\n",
       "      <td>0.014538</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.25000</td>\n",
       "      <td>145</td>\n",
       "      <td>2159</td>\n",
       "      <td>2516</td>\n",
       "      <td>0</td>\n",
       "      <td>719</td>\n",
       "      <td>0</td>\n",
       "      <td>131</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>930</td>\n",
       "      <td>1</td>\n",
       "      <td>2850</td>\n",
       "      <td>25</td>\n",
       "      <td>38</td>\n",
       "      <td>0.34</td>\n",
       "      <td>22110</td>\n",
       "      <td>MCI</td>\n",
       "      <td>0.014538</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.21875</td>\n",
       "      <td>118</td>\n",
       "      <td>2140</td>\n",
       "      <td>1716</td>\n",
       "      <td>0</td>\n",
       "      <td>708</td>\n",
       "      <td>1</td>\n",
       "      <td>125</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>330</td>\n",
       "      <td>0</td>\n",
       "      <td>4530</td>\n",
       "      <td>35</td>\n",
       "      <td>47</td>\n",
       "      <td>-0.07</td>\n",
       "      <td>21510</td>\n",
       "      <td>MCI</td>\n",
       "      <td>0.014538</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.28125</td>\n",
       "      <td>180</td>\n",
       "      <td>2240</td>\n",
       "      <td>2791</td>\n",
       "      <td>0</td>\n",
       "      <td>705</td>\n",
       "      <td>0</td>\n",
       "      <td>203</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>510</td>\n",
       "      <td>3</td>\n",
       "      <td>4860</td>\n",
       "      <td>21</td>\n",
       "      <td>44</td>\n",
       "      <td>-0.14</td>\n",
       "      <td>21360</td>\n",
       "      <td>MCI</td>\n",
       "      <td>0.014538</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.46875</td>\n",
       "      <td>374</td>\n",
       "      <td>2559</td>\n",
       "      <td>5393</td>\n",
       "      <td>0</td>\n",
       "      <td>437</td>\n",
       "      <td>0</td>\n",
       "      <td>511</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>420</td>\n",
       "      <td>0</td>\n",
       "      <td>1740</td>\n",
       "      <td>29</td>\n",
       "      <td>56</td>\n",
       "      <td>-0.50</td>\n",
       "      <td>13530</td>\n",
       "      <td>MCI</td>\n",
       "      <td>0.014538</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 38 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   activity_average_met  activity_cal_active  activity_cal_total  \\\n",
       "0               1.28125                  196                2251   \n",
       "1               1.25000                  145                2159   \n",
       "2               1.21875                  118                2140   \n",
       "3               1.28125                  180                2240   \n",
       "4               1.46875                  374                2559   \n",
       "\n",
       "   activity_daily_movement  activity_high  activity_inactive  \\\n",
       "0                     3353              0                714   \n",
       "1                     2516              0                719   \n",
       "2                     1716              0                708   \n",
       "3                     2791              0                705   \n",
       "4                     5393              0                437   \n",
       "\n",
       "   activity_inactivity_alerts  activity_low  activity_medium  \\\n",
       "0                           0           201                6   \n",
       "1                           0           131                9   \n",
       "2                           1           125                6   \n",
       "3                           0           203                5   \n",
       "4                           0           511                6   \n",
       "\n",
       "   activity_met_min_high  ...  sleep_onset_latency  sleep_period_id  \\\n",
       "0                      0  ...                  630                0   \n",
       "1                      0  ...                  930                1   \n",
       "2                      0  ...                  330                0   \n",
       "3                      0  ...                  510                3   \n",
       "4                      0  ...                  420                0   \n",
       "\n",
       "   sleep_rem  sleep_restless  sleep_rmssd  sleep_temperature_delta  \\\n",
       "0       3780              24           39                     0.00   \n",
       "1       2850              25           38                     0.34   \n",
       "2       4530              35           47                    -0.07   \n",
       "3       4860              21           44                    -0.14   \n",
       "4       1740              29           56                    -0.50   \n",
       "\n",
       "   sleep_total  DIAG_NM    Rating  TOTAL  \n",
       "0        29220      MCI  0.014538     72  \n",
       "1        22110      MCI  0.014538     72  \n",
       "2        21510      MCI  0.014538     72  \n",
       "3        21360      MCI  0.014538     72  \n",
       "4        13530      MCI  0.014538     72  \n",
       "\n",
       "[5 rows x 38 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>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_high</th>\n",
       "      <th>activity_inactive</th>\n",
       "      <th>activity_inactivity_alerts</th>\n",
       "      <th>activity_low</th>\n",
       "      <th>activity_medium</th>\n",
       "      <th>activity_met_min_high</th>\n",
       "      <th>...</th>\n",
       "      <th>sleep_onset_latency</th>\n",
       "      <th>sleep_period_id</th>\n",
       "      <th>sleep_rem</th>\n",
       "      <th>sleep_restless</th>\n",
       "      <th>sleep_rmssd</th>\n",
       "      <th>sleep_temperature_delta</th>\n",
       "      <th>sleep_total</th>\n",
       "      <th>DIAG_NM</th>\n",
       "      <th>Rating</th>\n",
       "      <th>TOTAL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.71875</td>\n",
       "      <td>730</td>\n",
       "      <td>2944</td>\n",
       "      <td>14346</td>\n",
       "      <td>0</td>\n",
       "      <td>417</td>\n",
       "      <td>0</td>\n",
       "      <td>545</td>\n",
       "      <td>47</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>960</td>\n",
       "      <td>0</td>\n",
       "      <td>4380</td>\n",
       "      <td>47</td>\n",
       "      <td>20</td>\n",
       "      <td>-0.12</td>\n",
       "      <td>21510</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.013152</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.40625</td>\n",
       "      <td>342</td>\n",
       "      <td>2449</td>\n",
       "      <td>6352</td>\n",
       "      <td>0</td>\n",
       "      <td>473</td>\n",
       "      <td>0</td>\n",
       "      <td>392</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>690</td>\n",
       "      <td>0</td>\n",
       "      <td>2400</td>\n",
       "      <td>56</td>\n",
       "      <td>19</td>\n",
       "      <td>-0.32</td>\n",
       "      <td>17040</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.013152</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.46875</td>\n",
       "      <td>401</td>\n",
       "      <td>2544</td>\n",
       "      <td>7297</td>\n",
       "      <td>0</td>\n",
       "      <td>586</td>\n",
       "      <td>0</td>\n",
       "      <td>362</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1140</td>\n",
       "      <td>0</td>\n",
       "      <td>2760</td>\n",
       "      <td>48</td>\n",
       "      <td>26</td>\n",
       "      <td>0.07</td>\n",
       "      <td>21360</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.013152</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.34375</td>\n",
       "      <td>27</td>\n",
       "      <td>1850</td>\n",
       "      <td>491</td>\n",
       "      <td>0</td>\n",
       "      <td>176</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1170</td>\n",
       "      <td>0</td>\n",
       "      <td>1980</td>\n",
       "      <td>59</td>\n",
       "      <td>30</td>\n",
       "      <td>-0.41</td>\n",
       "      <td>20100</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.013152</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.46875</td>\n",
       "      <td>333</td>\n",
       "      <td>2518</td>\n",
       "      <td>5861</td>\n",
       "      <td>0</td>\n",
       "      <td>646</td>\n",
       "      <td>0</td>\n",
       "      <td>377</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>3360</td>\n",
       "      <td>0</td>\n",
       "      <td>3570</td>\n",
       "      <td>42</td>\n",
       "      <td>23</td>\n",
       "      <td>-0.27</td>\n",
       "      <td>20730</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.013152</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 38 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   activity_average_met  activity_cal_active  activity_cal_total  \\\n",
       "0               1.71875                  730                2944   \n",
       "1               1.40625                  342                2449   \n",
       "2               1.46875                  401                2544   \n",
       "3               0.34375                   27                1850   \n",
       "4               1.46875                  333                2518   \n",
       "\n",
       "   activity_daily_movement  activity_high  activity_inactive  \\\n",
       "0                    14346              0                417   \n",
       "1                     6352              0                473   \n",
       "2                     7297              0                586   \n",
       "3                      491              0                176   \n",
       "4                     5861              0                646   \n",
       "\n",
       "   activity_inactivity_alerts  activity_low  activity_medium  \\\n",
       "0                           0           545               47   \n",
       "1                           0           392                8   \n",
       "2                           0           362               24   \n",
       "3                           0            34                1   \n",
       "4                           0           377                6   \n",
       "\n",
       "   activity_met_min_high  ...  sleep_onset_latency  sleep_period_id  \\\n",
       "0                      0  ...                  960                0   \n",
       "1                      0  ...                  690                0   \n",
       "2                      0  ...                 1140                0   \n",
       "3                      0  ...                 1170                0   \n",
       "4                      0  ...                 3360                0   \n",
       "\n",
       "   sleep_rem  sleep_restless  sleep_rmssd  sleep_temperature_delta  \\\n",
       "0       4380              47           20                    -0.12   \n",
       "1       2400              56           19                    -0.32   \n",
       "2       2760              48           26                     0.07   \n",
       "3       1980              59           30                    -0.41   \n",
       "4       3570              42           23                    -0.27   \n",
       "\n",
       "   sleep_total  DIAG_NM    Rating  TOTAL  \n",
       "0        21510       CN  0.013152     88  \n",
       "1        17040       CN  0.013152     88  \n",
       "2        21360       CN  0.013152     88  \n",
       "3        20100       CN  0.013152     88  \n",
       "4        20730       CN  0.013152     88  \n",
       "\n",
       "[5 rows x 38 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_val.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['activity_average_met', 'activity_cal_active', 'activity_cal_total',\n",
       "       'activity_daily_movement', 'activity_high', 'activity_inactive',\n",
       "       'activity_inactivity_alerts', 'activity_low', 'activity_medium',\n",
       "       'activity_met_min_high', 'activity_met_min_inactive',\n",
       "       'activity_met_min_low', 'activity_met_min_medium', 'activity_non_wear',\n",
       "       'activity_rest', 'activity_steps', 'activity_total', 'sleep_awake',\n",
       "       'sleep_breath_average', 'sleep_deep', 'sleep_duration',\n",
       "       'sleep_efficiency', 'sleep_hr_average', 'sleep_hr_lowest',\n",
       "       'sleep_is_longest', 'sleep_light', 'sleep_midpoint_at_delta',\n",
       "       'sleep_midpoint_time', 'sleep_onset_latency', 'sleep_period_id',\n",
       "       'sleep_rem', 'sleep_restless', 'sleep_rmssd', 'sleep_temperature_delta',\n",
       "       'sleep_total', 'DIAG_NM', 'Rating', 'TOTAL'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['activity_average_met', 'activity_cal_active', 'activity_cal_total',\n",
       "       'activity_daily_movement', 'activity_high', 'activity_inactive',\n",
       "       'activity_inactivity_alerts', 'activity_low', 'activity_medium',\n",
       "       'activity_met_min_high', 'activity_met_min_inactive',\n",
       "       'activity_met_min_low', 'activity_met_min_medium', 'activity_non_wear',\n",
       "       'activity_rest', 'activity_steps', 'activity_total', 'sleep_awake',\n",
       "       'sleep_breath_average', 'sleep_deep', 'sleep_duration',\n",
       "       'sleep_efficiency', 'sleep_hr_average', 'sleep_hr_lowest',\n",
       "       'sleep_is_longest', 'sleep_light', 'sleep_midpoint_at_delta',\n",
       "       'sleep_midpoint_time', 'sleep_onset_latency', 'sleep_period_id',\n",
       "       'sleep_rem', 'sleep_restless', 'sleep_rmssd', 'sleep_temperature_delta',\n",
       "       'sleep_total', 'DIAG_NM', 'Rating', 'TOTAL'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_val.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Accuracy: 0.29539951573849876\n"
     ]
    }
   ],
   "source": [
    "X_train = df.drop('DIAG_NM', axis=1)  # 타겟 변수를 제외한 모든 열을 특성으로 선택\n",
    "y_train = df['DIAG_NM']  # 타겟 변수로 'DIAG_NM'을 선택\n",
    "\n",
    "X_val = df_val.drop('DIAG_NM', axis=1)\n",
    "y_val = df_val['DIAG_NM']\n",
    "\n",
    "# 의사 결정 트리 모델 생성\n",
    "model = DecisionTreeClassifier()\n",
    "\n",
    "# 모델 훈련\n",
    "model.fit(X_train, y_train)\n",
    "\n",
    "# 검증 데이터로 예측\n",
    "y_pred = model.predict(X_val)\n",
    "\n",
    "# 정확도 계산\n",
    "accuracy = accuracy_score(y_val, y_pred)\n",
    "print(\"Accuracy:\", accuracy)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Random Forest Accuracy: 0.2784503631961259\n"
     ]
    }
   ],
   "source": [
    "from sklearn.ensemble import RandomForestClassifier\n",
    "\n",
    "# 랜덤 포레스트 모델 생성\n",
    "rf_model = RandomForestClassifier()\n",
    "\n",
    "# 모델 훈련\n",
    "rf_model.fit(X_train, y_train)\n",
    "\n",
    "# 검증 데이터로 예측\n",
    "y_pred_rf = rf_model.predict(X_val)\n",
    "\n",
    "# 정확도 계산\n",
    "accuracy_rf = accuracy_score(y_val, y_pred_rf)\n",
    "print(\"Random Forest Accuracy:\", accuracy_rf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Logistic Regression Accuracy: 0.744955609362389\n"
     ]
    }
   ],
   "source": [
    "from sklearn.linear_model import LogisticRegression\n",
    "\n",
    "# 로지스틱 회귀 모델 생성\n",
    "logistic_model = LogisticRegression()\n",
    "\n",
    "# 모델 훈련\n",
    "logistic_model.fit(X_train, y_train)\n",
    "\n",
    "# 검증 데이터로 예측\n",
    "y_pred_logistic = logistic_model.predict(X_val)\n",
    "\n",
    "# 정확도 계산\n",
    "accuracy_logistic = accuracy_score(y_val, y_pred_logistic)\n",
    "print(\"Logistic Regression Accuracy:\", accuracy_logistic)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "SVM Accuracy: 0.7893462469733656\n"
     ]
    }
   ],
   "source": [
    "from sklearn.svm import SVC\n",
    "\n",
    "# SVM 모델 생성\n",
    "svm_model = SVC()\n",
    "\n",
    "# 모델 훈련\n",
    "svm_model.fit(X_train, y_train)\n",
    "\n",
    "# 검증 데이터로 예측\n",
    "y_pred_svm = svm_model.predict(X_val)\n",
    "\n",
    "# 정확도 계산\n",
    "accuracy_svm = accuracy_score(y_val, y_pred_svm)\n",
    "print(\"SVM Accuracy:\", accuracy_svm)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Confusion Matrix (SVM):\n",
      "[[1956    0    0]\n",
      " [ 214    0    0]\n",
      " [ 308    0    0]]\n"
     ]
    }
   ],
   "source": [
    "from sklearn.metrics import confusion_matrix\n",
    "\n",
    "# 혼동 행렬 계산\n",
    "conf_matrix_svm = confusion_matrix(y_val, y_pred_svm)\n",
    "\n",
    "# 혼동 행렬 출력\n",
    "print(\"Confusion Matrix (SVM):\")\n",
    "print(conf_matrix_svm)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Confusion Matrix (SVM):\n",
      "[[1956    0    0]\n",
      " [ 214    0    0]\n",
      " [ 308    0    0]]\n"
     ]
    }
   ],
   "source": [
    "from sklearn.metrics import confusion_matrix\n",
    "\n",
    "# 혼동 행렬 계산\n",
    "conf_matrix_svm = confusion_matrix(y_val, y_pred_svm)\n",
    "\n",
    "# 혼동 행렬 출력\n",
    "print(\"Confusion Matrix (SVM):\")\n",
    "print(conf_matrix_svm)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Confusion Matrix (Logistic Regression):\n",
      "[[1829    0  127]\n",
      " [ 177   13   24]\n",
      " [ 304    0    4]]\n"
     ]
    }
   ],
   "source": [
    "from sklearn.metrics import confusion_matrix\n",
    "\n",
    "# 혼동 행렬 계산\n",
    "conf_matrix_logistic = confusion_matrix(y_val, y_pred_logistic)\n",
    "\n",
    "# 혼동 행렬 출력\n",
    "print(\"Confusion Matrix (Logistic Regression):\")\n",
    "print(conf_matrix_logistic)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Confusion Matrix (Random Forest):\n",
      "[[ 473   15 1468]\n",
      " [   1  172   41]\n",
      " [ 234   29   45]]\n"
     ]
    }
   ],
   "source": [
    "from sklearn.metrics import confusion_matrix\n",
    "\n",
    "# 혼동 행렬 계산\n",
    "conf_matrix_rf = confusion_matrix(y_val, y_pred_rf)\n",
    "\n",
    "# 혼동 행렬 출력\n",
    "print(\"Confusion Matrix (Random Forest):\")\n",
    "print(conf_matrix_rf)\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}