Prediction_of_diner.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "athletic-hartford",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np \n",
    "import matplotlib\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "light-river",
   "metadata": {},
   "outputs": [],
   "source": [
    "train = pd.read_csv('D_train.csv')\n",
    "test = pd.read_csv('D_test.csv')\n",
    "submission = pd.read_csv('D_sample_submission.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "choice-employee",
   "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>일자</th>\n",
       "      <th>요일</th>\n",
       "      <th>본사정원수</th>\n",
       "      <th>본사휴가자수</th>\n",
       "      <th>본사출장자수</th>\n",
       "      <th>본사시간외근무명령서승인건수</th>\n",
       "      <th>현본사소속재택근무자수</th>\n",
       "      <th>조식메뉴</th>\n",
       "      <th>중식메뉴</th>\n",
       "      <th>석식메뉴</th>\n",
       "      <th>중식계</th>\n",
       "      <th>석식계</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2016-02-01</td>\n",
       "      <td>월</td>\n",
       "      <td>2601</td>\n",
       "      <td>50</td>\n",
       "      <td>150</td>\n",
       "      <td>238</td>\n",
       "      <td>0.0</td>\n",
       "      <td>모닝롤/찐빵  우유/두유/주스 계란후라이  호두죽/쌀밥 (쌀:국내산) 된장찌개  쥐...</td>\n",
       "      <td>쌀밥/잡곡밥 (쌀,현미흑미:국내산) 오징어찌개  쇠불고기 (쇠고기:호주산) 계란찜 ...</td>\n",
       "      <td>쌀밥/잡곡밥 (쌀,현미흑미:국내산) 육개장  자반고등어구이  두부조림  건파래무침 ...</td>\n",
       "      <td>1039.0</td>\n",
       "      <td>331.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2016-02-02</td>\n",
       "      <td>화</td>\n",
       "      <td>2601</td>\n",
       "      <td>50</td>\n",
       "      <td>173</td>\n",
       "      <td>319</td>\n",
       "      <td>0.0</td>\n",
       "      <td>모닝롤/단호박샌드  우유/두유/주스 계란후라이  팥죽/쌀밥 (쌀:국내산) 호박젓국찌...</td>\n",
       "      <td>쌀밥/잡곡밥 (쌀,현미흑미:국내산) 김치찌개  가자미튀김  모둠소세지구이  마늘쫑무...</td>\n",
       "      <td>콩나물밥*양념장 (쌀,현미흑미:국내산) 어묵국  유산슬 (쇠고기:호주산) 아삭고추무...</td>\n",
       "      <td>867.0</td>\n",
       "      <td>560.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2016-02-03</td>\n",
       "      <td>수</td>\n",
       "      <td>2601</td>\n",
       "      <td>56</td>\n",
       "      <td>180</td>\n",
       "      <td>111</td>\n",
       "      <td>0.0</td>\n",
       "      <td>모닝롤/베이글  우유/두유/주스 계란후라이  표고버섯죽/쌀밥 (쌀:국내산) 콩나물국...</td>\n",
       "      <td>카레덮밥 (쌀,현미흑미:국내산) 팽이장국  치킨핑거 (닭고기:국내산) 쫄면야채무침 ...</td>\n",
       "      <td>쌀밥/잡곡밥 (쌀,현미흑미:국내산) 청국장찌개  황태양념구이 (황태:러시아산) 고기...</td>\n",
       "      <td>1017.0</td>\n",
       "      <td>573.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2016-02-04</td>\n",
       "      <td>목</td>\n",
       "      <td>2601</td>\n",
       "      <td>104</td>\n",
       "      <td>220</td>\n",
       "      <td>355</td>\n",
       "      <td>0.0</td>\n",
       "      <td>모닝롤/토마토샌드  우유/두유/주스 계란후라이  닭죽/쌀밥 (쌀,닭:국내산) 근대국...</td>\n",
       "      <td>쌀밥/잡곡밥 (쌀,현미흑미:국내산) 쇠고기무국  주꾸미볶음  부추전  시금치나물  ...</td>\n",
       "      <td>미니김밥*겨자장 (쌀,현미흑미:국내산) 우동  멕시칸샐러드  군고구마  무피클  포...</td>\n",
       "      <td>978.0</td>\n",
       "      <td>525.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2016-02-05</td>\n",
       "      <td>금</td>\n",
       "      <td>2601</td>\n",
       "      <td>278</td>\n",
       "      <td>181</td>\n",
       "      <td>34</td>\n",
       "      <td>0.0</td>\n",
       "      <td>모닝롤/와플  우유/두유/주스 계란후라이  쇠고기죽/쌀밥 (쌀:국내산) 재첩국  방...</td>\n",
       "      <td>쌀밥/잡곡밥 (쌀,현미흑미:국내산) 떡국  돈육씨앗강정 (돼지고기:국내산) 우엉잡채...</td>\n",
       "      <td>쌀밥/잡곡밥 (쌀,현미흑미:국내산) 차돌박이찌개 (쇠고기:호주산) 닭갈비 (닭고기:...</td>\n",
       "      <td>925.0</td>\n",
       "      <td>330.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           일자 요일  본사정원수  본사휴가자수  본사출장자수  본사시간외근무명령서승인건수  현본사소속재택근무자수  \\\n",
       "0  2016-02-01  월   2601      50     150             238          0.0   \n",
       "1  2016-02-02  화   2601      50     173             319          0.0   \n",
       "2  2016-02-03  수   2601      56     180             111          0.0   \n",
       "3  2016-02-04  목   2601     104     220             355          0.0   \n",
       "4  2016-02-05  금   2601     278     181              34          0.0   \n",
       "\n",
       "                                                조식메뉴  \\\n",
       "0  모닝롤/찐빵  우유/두유/주스 계란후라이  호두죽/쌀밥 (쌀:국내산) 된장찌개  쥐...   \n",
       "1  모닝롤/단호박샌드  우유/두유/주스 계란후라이  팥죽/쌀밥 (쌀:국내산) 호박젓국찌...   \n",
       "2  모닝롤/베이글  우유/두유/주스 계란후라이  표고버섯죽/쌀밥 (쌀:국내산) 콩나물국...   \n",
       "3  모닝롤/토마토샌드  우유/두유/주스 계란후라이  닭죽/쌀밥 (쌀,닭:국내산) 근대국...   \n",
       "4  모닝롤/와플  우유/두유/주스 계란후라이  쇠고기죽/쌀밥 (쌀:국내산) 재첩국  방...   \n",
       "\n",
       "                                                중식메뉴  \\\n",
       "0  쌀밥/잡곡밥 (쌀,현미흑미:국내산) 오징어찌개  쇠불고기 (쇠고기:호주산) 계란찜 ...   \n",
       "1  쌀밥/잡곡밥 (쌀,현미흑미:국내산) 김치찌개  가자미튀김  모둠소세지구이  마늘쫑무...   \n",
       "2  카레덮밥 (쌀,현미흑미:국내산) 팽이장국  치킨핑거 (닭고기:국내산) 쫄면야채무침 ...   \n",
       "3  쌀밥/잡곡밥 (쌀,현미흑미:국내산) 쇠고기무국  주꾸미볶음  부추전  시금치나물  ...   \n",
       "4  쌀밥/잡곡밥 (쌀,현미흑미:국내산) 떡국  돈육씨앗강정 (돼지고기:국내산) 우엉잡채...   \n",
       "\n",
       "                                                석식메뉴     중식계    석식계  \n",
       "0  쌀밥/잡곡밥 (쌀,현미흑미:국내산) 육개장  자반고등어구이  두부조림  건파래무침 ...  1039.0  331.0  \n",
       "1  콩나물밥*양념장 (쌀,현미흑미:국내산) 어묵국  유산슬 (쇠고기:호주산) 아삭고추무...   867.0  560.0  \n",
       "2  쌀밥/잡곡밥 (쌀,현미흑미:국내산) 청국장찌개  황태양념구이 (황태:러시아산) 고기...  1017.0  573.0  \n",
       "3  미니김밥*겨자장 (쌀,현미흑미:국내산) 우동  멕시칸샐러드  군고구마  무피클  포...   978.0  525.0  \n",
       "4  쌀밥/잡곡밥 (쌀,현미흑미:국내산) 차돌박이찌개 (쇠고기:호주산) 닭갈비 (닭고기:...   925.0  330.0  "
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "conceptual-allocation",
   "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>일자</th>\n",
       "      <th>요일</th>\n",
       "      <th>본사정원수</th>\n",
       "      <th>본사휴가자수</th>\n",
       "      <th>본사출장자수</th>\n",
       "      <th>본사시간외근무명령서승인건수</th>\n",
       "      <th>현본사소속재택근무자수</th>\n",
       "      <th>조식메뉴</th>\n",
       "      <th>중식메뉴</th>\n",
       "      <th>석식메뉴</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-01-27</td>\n",
       "      <td>수</td>\n",
       "      <td>2983</td>\n",
       "      <td>88</td>\n",
       "      <td>182</td>\n",
       "      <td>5</td>\n",
       "      <td>358.0</td>\n",
       "      <td>모닝롤/연유버터베이글 우유/주스 계란후라이/찐계란 단호박죽/흑미밥 우거지국 고기완자...</td>\n",
       "      <td>쌀밥/흑미밥/찰현미밥 대구지리 매운돈갈비찜 오꼬노미계란말이 상추무침 포기김치 양상추...</td>\n",
       "      <td>흑미밥 얼큰순두부찌개 쇠고기우엉볶음 버섯햄볶음 (New)아삭이고추무절임 포기김치</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-01-28</td>\n",
       "      <td>목</td>\n",
       "      <td>2983</td>\n",
       "      <td>104</td>\n",
       "      <td>212</td>\n",
       "      <td>409</td>\n",
       "      <td>348.0</td>\n",
       "      <td>모닝롤/대만샌드위치 우유/주스 계란후라이/찐계란 누룽지탕/흑미밥 황태국 시래기지짐 ...</td>\n",
       "      <td>쌀밥/보리밥/찰현미밥 우렁된장찌개 오리주물럭 청양부추전 수제삼색무쌈 겉절이김치 양상...</td>\n",
       "      <td>충무김밥 우동국물 오징어무침 꽃맛살샐러드 얼갈이쌈장무침 석박지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-01-29</td>\n",
       "      <td>금</td>\n",
       "      <td>2983</td>\n",
       "      <td>270</td>\n",
       "      <td>249</td>\n",
       "      <td>0</td>\n",
       "      <td>294.0</td>\n",
       "      <td>모닝롤/핫케익 우유/주스 계란후라이/찐계란 오곡죽/흑미밥 매생이굴국 고구마순볶음 양...</td>\n",
       "      <td>쌀밥/흑미밥/찰현미밥 팽이장국 수제돈까스*소스 가자미조림 동초나물무침 포기김치 양상...</td>\n",
       "      <td>흑미밥 물만둣국 카레찜닭 숯불양념꼬지어묵 꼬시래기무침 포기김치</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-02-01</td>\n",
       "      <td>월</td>\n",
       "      <td>2924</td>\n",
       "      <td>108</td>\n",
       "      <td>154</td>\n",
       "      <td>538</td>\n",
       "      <td>322.0</td>\n",
       "      <td>모닝롤/촉촉한치즈케익 우유/주스 계란후라이/찐계란 누룽지탕/흑미밥 두부김칫국 새우완...</td>\n",
       "      <td>쌀밥/흑미밥/찰현미밥 배추들깨국 오리대패불고기 시금치프리타타 부추고추장무침 포기김치...</td>\n",
       "      <td>흑미밥 동태탕 돈육꽈리고추장조림 당면채소무침 모자반무침 포기김치</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-02-02</td>\n",
       "      <td>화</td>\n",
       "      <td>2924</td>\n",
       "      <td>62</td>\n",
       "      <td>186</td>\n",
       "      <td>455</td>\n",
       "      <td>314.0</td>\n",
       "      <td>모닝롤/토마토샌드 우유/주스 계란후라이/찐계란 채소죽/흑미밥 호박맑은국 오이생채 양...</td>\n",
       "      <td>쌀밥/팥밥/찰현미밥 부대찌개 닭살데리야끼조림 버섯탕수 세발나물무침 알타리김치/사과푸...</td>\n",
       "      <td>흑미밥 바지락살국 쇠고기청경채볶음 두부구이*볶은김치 머위된장무침 백김치</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           일자 요일  본사정원수  본사휴가자수  본사출장자수  본사시간외근무명령서승인건수  현본사소속재택근무자수  \\\n",
       "0  2021-01-27  수   2983      88     182               5        358.0   \n",
       "1  2021-01-28  목   2983     104     212             409        348.0   \n",
       "2  2021-01-29  금   2983     270     249               0        294.0   \n",
       "3  2021-02-01  월   2924     108     154             538        322.0   \n",
       "4  2021-02-02  화   2924      62     186             455        314.0   \n",
       "\n",
       "                                                조식메뉴  \\\n",
       "0  모닝롤/연유버터베이글 우유/주스 계란후라이/찐계란 단호박죽/흑미밥 우거지국 고기완자...   \n",
       "1  모닝롤/대만샌드위치 우유/주스 계란후라이/찐계란 누룽지탕/흑미밥 황태국 시래기지짐 ...   \n",
       "2  모닝롤/핫케익 우유/주스 계란후라이/찐계란 오곡죽/흑미밥 매생이굴국 고구마순볶음 양...   \n",
       "3  모닝롤/촉촉한치즈케익 우유/주스 계란후라이/찐계란 누룽지탕/흑미밥 두부김칫국 새우완...   \n",
       "4  모닝롤/토마토샌드 우유/주스 계란후라이/찐계란 채소죽/흑미밥 호박맑은국 오이생채 양...   \n",
       "\n",
       "                                                중식메뉴  \\\n",
       "0  쌀밥/흑미밥/찰현미밥 대구지리 매운돈갈비찜 오꼬노미계란말이 상추무침 포기김치 양상추...   \n",
       "1  쌀밥/보리밥/찰현미밥 우렁된장찌개 오리주물럭 청양부추전 수제삼색무쌈 겉절이김치 양상...   \n",
       "2  쌀밥/흑미밥/찰현미밥 팽이장국 수제돈까스*소스 가자미조림 동초나물무침 포기김치 양상...   \n",
       "3  쌀밥/흑미밥/찰현미밥 배추들깨국 오리대패불고기 시금치프리타타 부추고추장무침 포기김치...   \n",
       "4  쌀밥/팥밥/찰현미밥 부대찌개 닭살데리야끼조림 버섯탕수 세발나물무침 알타리김치/사과푸...   \n",
       "\n",
       "                                            석식메뉴  \n",
       "0  흑미밥 얼큰순두부찌개 쇠고기우엉볶음 버섯햄볶음 (New)아삭이고추무절임 포기김치   \n",
       "1            충무김밥 우동국물 오징어무침 꽃맛살샐러드 얼갈이쌈장무침 석박지   \n",
       "2            흑미밥 물만둣국 카레찜닭 숯불양념꼬지어묵 꼬시래기무침 포기김치   \n",
       "3           흑미밥 동태탕 돈육꽈리고추장조림 당면채소무침 모자반무침 포기김치   \n",
       "4       흑미밥 바지락살국 쇠고기청경채볶음 두부구이*볶은김치 머위된장무침 백김치   "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "stretch-commitment",
   "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>일자</th>\n",
       "      <th>중식계</th>\n",
       "      <th>석식계</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-01-27</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-01-28</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-01-29</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-02-01</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-02-02</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           일자  중식계  석식계\n",
       "0  2021-01-27    0    0\n",
       "1  2021-01-28    0    0\n",
       "2  2021-01-29    0    0\n",
       "3  2021-02-01    0    0\n",
       "4  2021-02-02    0    0"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "submission.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "unable-strategy",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " train shape:  (1205, 12) \n",
      " test shape:  (50, 10)\n"
     ]
    }
   ],
   "source": [
    "print(' train shape: ', train.shape, '\\n', 'test shape: ', test.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "composed-syracuse",
   "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>date</th>\n",
       "      <th>dow</th>\n",
       "      <th>employees</th>\n",
       "      <th>dayoff</th>\n",
       "      <th>bustrip</th>\n",
       "      <th>ovtime</th>\n",
       "      <th>remote</th>\n",
       "      <th>brk</th>\n",
       "      <th>ln</th>\n",
       "      <th>dn</th>\n",
       "      <th>target_ln</th>\n",
       "      <th>target_dn</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2016-02-01</td>\n",
       "      <td>월</td>\n",
       "      <td>2601</td>\n",
       "      <td>50</td>\n",
       "      <td>150</td>\n",
       "      <td>238</td>\n",
       "      <td>0.0</td>\n",
       "      <td>모닝롤/찐빵  우유/두유/주스 계란후라이  호두죽/쌀밥 (쌀:국내산) 된장찌개  쥐...</td>\n",
       "      <td>쌀밥/잡곡밥 (쌀,현미흑미:국내산) 오징어찌개  쇠불고기 (쇠고기:호주산) 계란찜 ...</td>\n",
       "      <td>쌀밥/잡곡밥 (쌀,현미흑미:국내산) 육개장  자반고등어구이  두부조림  건파래무침 ...</td>\n",
       "      <td>1039.0</td>\n",
       "      <td>331.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2016-02-02</td>\n",
       "      <td>화</td>\n",
       "      <td>2601</td>\n",
       "      <td>50</td>\n",
       "      <td>173</td>\n",
       "      <td>319</td>\n",
       "      <td>0.0</td>\n",
       "      <td>모닝롤/단호박샌드  우유/두유/주스 계란후라이  팥죽/쌀밥 (쌀:국내산) 호박젓국찌...</td>\n",
       "      <td>쌀밥/잡곡밥 (쌀,현미흑미:국내산) 김치찌개  가자미튀김  모둠소세지구이  마늘쫑무...</td>\n",
       "      <td>콩나물밥*양념장 (쌀,현미흑미:국내산) 어묵국  유산슬 (쇠고기:호주산) 아삭고추무...</td>\n",
       "      <td>867.0</td>\n",
       "      <td>560.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         date dow  employees  dayoff  bustrip  ovtime  remote  \\\n",
       "0  2016-02-01   월       2601      50      150     238     0.0   \n",
       "1  2016-02-02   화       2601      50      173     319     0.0   \n",
       "\n",
       "                                                 brk  \\\n",
       "0  모닝롤/찐빵  우유/두유/주스 계란후라이  호두죽/쌀밥 (쌀:국내산) 된장찌개  쥐...   \n",
       "1  모닝롤/단호박샌드  우유/두유/주스 계란후라이  팥죽/쌀밥 (쌀:국내산) 호박젓국찌...   \n",
       "\n",
       "                                                  ln  \\\n",
       "0  쌀밥/잡곡밥 (쌀,현미흑미:국내산) 오징어찌개  쇠불고기 (쇠고기:호주산) 계란찜 ...   \n",
       "1  쌀밥/잡곡밥 (쌀,현미흑미:국내산) 김치찌개  가자미튀김  모둠소세지구이  마늘쫑무...   \n",
       "\n",
       "                                                  dn  target_ln  target_dn  \n",
       "0  쌀밥/잡곡밥 (쌀,현미흑미:국내산) 육개장  자반고등어구이  두부조림  건파래무침 ...     1039.0      331.0  \n",
       "1  콩나물밥*양념장 (쌀,현미흑미:국내산) 어묵국  유산슬 (쇠고기:호주산) 아삭고추무...      867.0      560.0  "
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 편의상 칼럼을 수정해주겠습니다. \n",
    "train = train.copy()\n",
    "train.columns = ['date', 'dow', 'employees', 'dayoff', 'bustrip', 'ovtime', 'remote', 'brk', 'ln', 'dn', 'target_ln', 'target_dn']\n",
    "train.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "coordinated-scope",
   "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>date</th>\n",
       "      <th>dow</th>\n",
       "      <th>employees</th>\n",
       "      <th>dayoff</th>\n",
       "      <th>bustrip</th>\n",
       "      <th>ovtime</th>\n",
       "      <th>remote</th>\n",
       "      <th>brk</th>\n",
       "      <th>ln</th>\n",
       "      <th>dn</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-01-27</td>\n",
       "      <td>수</td>\n",
       "      <td>2983</td>\n",
       "      <td>88</td>\n",
       "      <td>182</td>\n",
       "      <td>5</td>\n",
       "      <td>358.0</td>\n",
       "      <td>모닝롤/연유버터베이글 우유/주스 계란후라이/찐계란 단호박죽/흑미밥 우거지국 고기완자...</td>\n",
       "      <td>쌀밥/흑미밥/찰현미밥 대구지리 매운돈갈비찜 오꼬노미계란말이 상추무침 포기김치 양상추...</td>\n",
       "      <td>흑미밥 얼큰순두부찌개 쇠고기우엉볶음 버섯햄볶음 (New)아삭이고추무절임 포기김치</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-01-28</td>\n",
       "      <td>목</td>\n",
       "      <td>2983</td>\n",
       "      <td>104</td>\n",
       "      <td>212</td>\n",
       "      <td>409</td>\n",
       "      <td>348.0</td>\n",
       "      <td>모닝롤/대만샌드위치 우유/주스 계란후라이/찐계란 누룽지탕/흑미밥 황태국 시래기지짐 ...</td>\n",
       "      <td>쌀밥/보리밥/찰현미밥 우렁된장찌개 오리주물럭 청양부추전 수제삼색무쌈 겉절이김치 양상...</td>\n",
       "      <td>충무김밥 우동국물 오징어무침 꽃맛살샐러드 얼갈이쌈장무침 석박지</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         date dow  employees  dayoff  bustrip  ovtime  remote  \\\n",
       "0  2021-01-27   수       2983      88      182       5   358.0   \n",
       "1  2021-01-28   목       2983     104      212     409   348.0   \n",
       "\n",
       "                                                 brk  \\\n",
       "0  모닝롤/연유버터베이글 우유/주스 계란후라이/찐계란 단호박죽/흑미밥 우거지국 고기완자...   \n",
       "1  모닝롤/대만샌드위치 우유/주스 계란후라이/찐계란 누룽지탕/흑미밥 황태국 시래기지짐 ...   \n",
       "\n",
       "                                                  ln  \\\n",
       "0  쌀밥/흑미밥/찰현미밥 대구지리 매운돈갈비찜 오꼬노미계란말이 상추무침 포기김치 양상추...   \n",
       "1  쌀밥/보리밥/찰현미밥 우렁된장찌개 오리주물럭 청양부추전 수제삼색무쌈 겉절이김치 양상...   \n",
       "\n",
       "                                              dn  \n",
       "0  흑미밥 얼큰순두부찌개 쇠고기우엉볶음 버섯햄볶음 (New)아삭이고추무절임 포기김치   \n",
       "1            충무김밥 우동국물 오징어무침 꽃맛살샐러드 얼갈이쌈장무침 석박지   "
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test = test.copy()\n",
    "test.columns = ['date', 'dow', 'employees', 'dayoff', 'bustrip', 'ovtime', 'remote', 'brk', 'ln', 'dn']\n",
    "test.head(2)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "figured-graduation",
   "metadata": {},
   "source": [
    "**편의상 날짜를 datetime형식으로 바꿔주고 동시에 요일 정보를 숫자로 바꾸겠습니다.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "bronze-helena",
   "metadata": {},
   "outputs": [],
   "source": [
    "def to_datetime(df, date):\n",
    "    df['date'] = pd.to_datetime(df[date])\n",
    "    df['dow'] = pd.to_datetime(df[date]).dt.weekday + 1\n",
    "to_datetime(train, 'date'); to_datetime(test, 'date')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "passing-dallas",
   "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>date</th>\n",
       "      <th>dow</th>\n",
       "      <th>employees</th>\n",
       "      <th>dayoff</th>\n",
       "      <th>bustrip</th>\n",
       "      <th>ovtime</th>\n",
       "      <th>remote</th>\n",
       "      <th>brk</th>\n",
       "      <th>ln</th>\n",
       "      <th>dn</th>\n",
       "      <th>target_ln</th>\n",
       "      <th>target_dn</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2016-02-01</td>\n",
       "      <td>1</td>\n",
       "      <td>2601</td>\n",
       "      <td>50</td>\n",
       "      <td>150</td>\n",
       "      <td>238</td>\n",
       "      <td>0.0</td>\n",
       "      <td>모닝롤/찐빵  우유/두유/주스 계란후라이  호두죽/쌀밥 (쌀:국내산) 된장찌개  쥐...</td>\n",
       "      <td>쌀밥/잡곡밥 (쌀,현미흑미:국내산) 오징어찌개  쇠불고기 (쇠고기:호주산) 계란찜 ...</td>\n",
       "      <td>쌀밥/잡곡밥 (쌀,현미흑미:국내산) 육개장  자반고등어구이  두부조림  건파래무침 ...</td>\n",
       "      <td>1039.0</td>\n",
       "      <td>331.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2016-02-02</td>\n",
       "      <td>2</td>\n",
       "      <td>2601</td>\n",
       "      <td>50</td>\n",
       "      <td>173</td>\n",
       "      <td>319</td>\n",
       "      <td>0.0</td>\n",
       "      <td>모닝롤/단호박샌드  우유/두유/주스 계란후라이  팥죽/쌀밥 (쌀:국내산) 호박젓국찌...</td>\n",
       "      <td>쌀밥/잡곡밥 (쌀,현미흑미:국내산) 김치찌개  가자미튀김  모둠소세지구이  마늘쫑무...</td>\n",
       "      <td>콩나물밥*양념장 (쌀,현미흑미:국내산) 어묵국  유산슬 (쇠고기:호주산) 아삭고추무...</td>\n",
       "      <td>867.0</td>\n",
       "      <td>560.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2016-02-03</td>\n",
       "      <td>3</td>\n",
       "      <td>2601</td>\n",
       "      <td>56</td>\n",
       "      <td>180</td>\n",
       "      <td>111</td>\n",
       "      <td>0.0</td>\n",
       "      <td>모닝롤/베이글  우유/두유/주스 계란후라이  표고버섯죽/쌀밥 (쌀:국내산) 콩나물국...</td>\n",
       "      <td>카레덮밥 (쌀,현미흑미:국내산) 팽이장국  치킨핑거 (닭고기:국내산) 쫄면야채무침 ...</td>\n",
       "      <td>쌀밥/잡곡밥 (쌀,현미흑미:국내산) 청국장찌개  황태양념구이 (황태:러시아산) 고기...</td>\n",
       "      <td>1017.0</td>\n",
       "      <td>573.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2016-02-04</td>\n",
       "      <td>4</td>\n",
       "      <td>2601</td>\n",
       "      <td>104</td>\n",
       "      <td>220</td>\n",
       "      <td>355</td>\n",
       "      <td>0.0</td>\n",
       "      <td>모닝롤/토마토샌드  우유/두유/주스 계란후라이  닭죽/쌀밥 (쌀,닭:국내산) 근대국...</td>\n",
       "      <td>쌀밥/잡곡밥 (쌀,현미흑미:국내산) 쇠고기무국  주꾸미볶음  부추전  시금치나물  ...</td>\n",
       "      <td>미니김밥*겨자장 (쌀,현미흑미:국내산) 우동  멕시칸샐러드  군고구마  무피클  포...</td>\n",
       "      <td>978.0</td>\n",
       "      <td>525.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2016-02-05</td>\n",
       "      <td>5</td>\n",
       "      <td>2601</td>\n",
       "      <td>278</td>\n",
       "      <td>181</td>\n",
       "      <td>34</td>\n",
       "      <td>0.0</td>\n",
       "      <td>모닝롤/와플  우유/두유/주스 계란후라이  쇠고기죽/쌀밥 (쌀:국내산) 재첩국  방...</td>\n",
       "      <td>쌀밥/잡곡밥 (쌀,현미흑미:국내산) 떡국  돈육씨앗강정 (돼지고기:국내산) 우엉잡채...</td>\n",
       "      <td>쌀밥/잡곡밥 (쌀,현미흑미:국내산) 차돌박이찌개 (쇠고기:호주산) 닭갈비 (닭고기:...</td>\n",
       "      <td>925.0</td>\n",
       "      <td>330.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        date  dow  employees  dayoff  bustrip  ovtime  remote  \\\n",
       "0 2016-02-01    1       2601      50      150     238     0.0   \n",
       "1 2016-02-02    2       2601      50      173     319     0.0   \n",
       "2 2016-02-03    3       2601      56      180     111     0.0   \n",
       "3 2016-02-04    4       2601     104      220     355     0.0   \n",
       "4 2016-02-05    5       2601     278      181      34     0.0   \n",
       "\n",
       "                                                 brk  \\\n",
       "0  모닝롤/찐빵  우유/두유/주스 계란후라이  호두죽/쌀밥 (쌀:국내산) 된장찌개  쥐...   \n",
       "1  모닝롤/단호박샌드  우유/두유/주스 계란후라이  팥죽/쌀밥 (쌀:국내산) 호박젓국찌...   \n",
       "2  모닝롤/베이글  우유/두유/주스 계란후라이  표고버섯죽/쌀밥 (쌀:국내산) 콩나물국...   \n",
       "3  모닝롤/토마토샌드  우유/두유/주스 계란후라이  닭죽/쌀밥 (쌀,닭:국내산) 근대국...   \n",
       "4  모닝롤/와플  우유/두유/주스 계란후라이  쇠고기죽/쌀밥 (쌀:국내산) 재첩국  방...   \n",
       "\n",
       "                                                  ln  \\\n",
       "0  쌀밥/잡곡밥 (쌀,현미흑미:국내산) 오징어찌개  쇠불고기 (쇠고기:호주산) 계란찜 ...   \n",
       "1  쌀밥/잡곡밥 (쌀,현미흑미:국내산) 김치찌개  가자미튀김  모둠소세지구이  마늘쫑무...   \n",
       "2  카레덮밥 (쌀,현미흑미:국내산) 팽이장국  치킨핑거 (닭고기:국내산) 쫄면야채무침 ...   \n",
       "3  쌀밥/잡곡밥 (쌀,현미흑미:국내산) 쇠고기무국  주꾸미볶음  부추전  시금치나물  ...   \n",
       "4  쌀밥/잡곡밥 (쌀,현미흑미:국내산) 떡국  돈육씨앗강정 (돼지고기:국내산) 우엉잡채...   \n",
       "\n",
       "                                                  dn  target_ln  target_dn  \n",
       "0  쌀밥/잡곡밥 (쌀,현미흑미:국내산) 육개장  자반고등어구이  두부조림  건파래무침 ...     1039.0      331.0  \n",
       "1  콩나물밥*양념장 (쌀,현미흑미:국내산) 어묵국  유산슬 (쇠고기:호주산) 아삭고추무...      867.0      560.0  \n",
       "2  쌀밥/잡곡밥 (쌀,현미흑미:국내산) 청국장찌개  황태양념구이 (황태:러시아산) 고기...     1017.0      573.0  \n",
       "3  미니김밥*겨자장 (쌀,현미흑미:국내산) 우동  멕시칸샐러드  군고구마  무피클  포...      978.0      525.0  \n",
       "4  쌀밥/잡곡밥 (쌀,현미흑미:국내산) 차돌박이찌개 (쇠고기:호주산) 닭갈비 (닭고기:...      925.0      330.0  "
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "lined-liberty",
   "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>date</th>\n",
       "      <th>dow</th>\n",
       "      <th>employees</th>\n",
       "      <th>dayoff</th>\n",
       "      <th>bustrip</th>\n",
       "      <th>ovtime</th>\n",
       "      <th>remote</th>\n",
       "      <th>brk</th>\n",
       "      <th>ln</th>\n",
       "      <th>dn</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-01-27</td>\n",
       "      <td>3</td>\n",
       "      <td>2983</td>\n",
       "      <td>88</td>\n",
       "      <td>182</td>\n",
       "      <td>5</td>\n",
       "      <td>358.0</td>\n",
       "      <td>모닝롤/연유버터베이글 우유/주스 계란후라이/찐계란 단호박죽/흑미밥 우거지국 고기완자...</td>\n",
       "      <td>쌀밥/흑미밥/찰현미밥 대구지리 매운돈갈비찜 오꼬노미계란말이 상추무침 포기김치 양상추...</td>\n",
       "      <td>흑미밥 얼큰순두부찌개 쇠고기우엉볶음 버섯햄볶음 (New)아삭이고추무절임 포기김치</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-01-28</td>\n",
       "      <td>4</td>\n",
       "      <td>2983</td>\n",
       "      <td>104</td>\n",
       "      <td>212</td>\n",
       "      <td>409</td>\n",
       "      <td>348.0</td>\n",
       "      <td>모닝롤/대만샌드위치 우유/주스 계란후라이/찐계란 누룽지탕/흑미밥 황태국 시래기지짐 ...</td>\n",
       "      <td>쌀밥/보리밥/찰현미밥 우렁된장찌개 오리주물럭 청양부추전 수제삼색무쌈 겉절이김치 양상...</td>\n",
       "      <td>충무김밥 우동국물 오징어무침 꽃맛살샐러드 얼갈이쌈장무침 석박지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-01-29</td>\n",
       "      <td>5</td>\n",
       "      <td>2983</td>\n",
       "      <td>270</td>\n",
       "      <td>249</td>\n",
       "      <td>0</td>\n",
       "      <td>294.0</td>\n",
       "      <td>모닝롤/핫케익 우유/주스 계란후라이/찐계란 오곡죽/흑미밥 매생이굴국 고구마순볶음 양...</td>\n",
       "      <td>쌀밥/흑미밥/찰현미밥 팽이장국 수제돈까스*소스 가자미조림 동초나물무침 포기김치 양상...</td>\n",
       "      <td>흑미밥 물만둣국 카레찜닭 숯불양념꼬지어묵 꼬시래기무침 포기김치</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-02-01</td>\n",
       "      <td>1</td>\n",
       "      <td>2924</td>\n",
       "      <td>108</td>\n",
       "      <td>154</td>\n",
       "      <td>538</td>\n",
       "      <td>322.0</td>\n",
       "      <td>모닝롤/촉촉한치즈케익 우유/주스 계란후라이/찐계란 누룽지탕/흑미밥 두부김칫국 새우완...</td>\n",
       "      <td>쌀밥/흑미밥/찰현미밥 배추들깨국 오리대패불고기 시금치프리타타 부추고추장무침 포기김치...</td>\n",
       "      <td>흑미밥 동태탕 돈육꽈리고추장조림 당면채소무침 모자반무침 포기김치</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-02-02</td>\n",
       "      <td>2</td>\n",
       "      <td>2924</td>\n",
       "      <td>62</td>\n",
       "      <td>186</td>\n",
       "      <td>455</td>\n",
       "      <td>314.0</td>\n",
       "      <td>모닝롤/토마토샌드 우유/주스 계란후라이/찐계란 채소죽/흑미밥 호박맑은국 오이생채 양...</td>\n",
       "      <td>쌀밥/팥밥/찰현미밥 부대찌개 닭살데리야끼조림 버섯탕수 세발나물무침 알타리김치/사과푸...</td>\n",
       "      <td>흑미밥 바지락살국 쇠고기청경채볶음 두부구이*볶은김치 머위된장무침 백김치</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        date  dow  employees  dayoff  bustrip  ovtime  remote  \\\n",
       "0 2021-01-27    3       2983      88      182       5   358.0   \n",
       "1 2021-01-28    4       2983     104      212     409   348.0   \n",
       "2 2021-01-29    5       2983     270      249       0   294.0   \n",
       "3 2021-02-01    1       2924     108      154     538   322.0   \n",
       "4 2021-02-02    2       2924      62      186     455   314.0   \n",
       "\n",
       "                                                 brk  \\\n",
       "0  모닝롤/연유버터베이글 우유/주스 계란후라이/찐계란 단호박죽/흑미밥 우거지국 고기완자...   \n",
       "1  모닝롤/대만샌드위치 우유/주스 계란후라이/찐계란 누룽지탕/흑미밥 황태국 시래기지짐 ...   \n",
       "2  모닝롤/핫케익 우유/주스 계란후라이/찐계란 오곡죽/흑미밥 매생이굴국 고구마순볶음 양...   \n",
       "3  모닝롤/촉촉한치즈케익 우유/주스 계란후라이/찐계란 누룽지탕/흑미밥 두부김칫국 새우완...   \n",
       "4  모닝롤/토마토샌드 우유/주스 계란후라이/찐계란 채소죽/흑미밥 호박맑은국 오이생채 양...   \n",
       "\n",
       "                                                  ln  \\\n",
       "0  쌀밥/흑미밥/찰현미밥 대구지리 매운돈갈비찜 오꼬노미계란말이 상추무침 포기김치 양상추...   \n",
       "1  쌀밥/보리밥/찰현미밥 우렁된장찌개 오리주물럭 청양부추전 수제삼색무쌈 겉절이김치 양상...   \n",
       "2  쌀밥/흑미밥/찰현미밥 팽이장국 수제돈까스*소스 가자미조림 동초나물무침 포기김치 양상...   \n",
       "3  쌀밥/흑미밥/찰현미밥 배추들깨국 오리대패불고기 시금치프리타타 부추고추장무침 포기김치...   \n",
       "4  쌀밥/팥밥/찰현미밥 부대찌개 닭살데리야끼조림 버섯탕수 세발나물무침 알타리김치/사과푸...   \n",
       "\n",
       "                                              dn  \n",
       "0  흑미밥 얼큰순두부찌개 쇠고기우엉볶음 버섯햄볶음 (New)아삭이고추무절임 포기김치   \n",
       "1            충무김밥 우동국물 오징어무침 꽃맛살샐러드 얼갈이쌈장무침 석박지   \n",
       "2            흑미밥 물만둣국 카레찜닭 숯불양념꼬지어묵 꼬시래기무침 포기김치   \n",
       "3           흑미밥 동태탕 돈육꽈리고추장조림 당면채소무침 모자반무침 포기김치   \n",
       "4       흑미밥 바지락살국 쇠고기청경채볶음 두부구이*볶은김치 머위된장무침 백김치   "
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "metallic-switch",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "expected-record",
   "metadata": {},
   "outputs": [],
   "source": [
    "lunch = []\n",
    "for day in range(len(train)):\n",
    "    tmp = train.iloc[day, 8].split(' ') # 공백으로 문자열 구분 \n",
    "    tmp = ' '.join(tmp).split()    # 빈 원소 삭제\n",
    "\n",
    "    search = '('   # 원산지 정보는 삭제\n",
    "    for menu in tmp:\n",
    "        if search in menu:\n",
    "            tmp.remove(menu)\n",
    "    \n",
    "    lunch.append(tmp) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "classified-hormone",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['쌀밥/잡곡밥', '오징어찌개', '쇠불고기', '계란찜', '청포묵무침', '요구르트', '포기김치'],\n",
       " ['쌀밥/잡곡밥', '김치찌개', '가자미튀김', '모둠소세지구이', '마늘쫑무침', '요구르트', '배추겉절이'],\n",
       " ['카레덮밥', '팽이장국', '치킨핑거', '쫄면야채무침', '견과류조림', '요구르트', '포기김치'],\n",
       " ['쌀밥/잡곡밥', '쇠고기무국', '주꾸미볶음', '부추전', '시금치나물', '요구르트', '포기김치'],\n",
       " ['쌀밥/잡곡밥', '떡국', '돈육씨앗강정', '우엉잡채', '청경채무침', '요구르트', '포기김치']]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "lunch[0:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "individual-clarity",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['쌀밥/잡곡밥', '매운소고기국', '굴비구이', '토마토프리타타', '도라지오이무침', '배추겉절이'],\n",
       " ['돈육버섯고추장덮밥', '팽이무국', '양파링카레튀김', '모듬어묵볶음', '참나물생채', '요구르트', '포기김치'],\n",
       " ['쌀밥/잡곡밥', '냉모밀국수', '매운돈갈비찜', '메밀전병*간장', '고구마순볶음', '포기김치', '양상추샐러드*딸기요거트'],\n",
       " ['쌀밥/잡곡밥', '대파육개장', '홍어미나리초무침', '어묵잡채', '콩자반', '배추겉절이', '양상추샐러드*오리엔탈'],\n",
       " ['카레라이스', '동태알탕', '부추고추전*간장', '쫄면야채무침', '과일요거트샐러드', '포기김치', '요구르트']]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "lunch[1065:1070]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "substantial-juice",
   "metadata": {},
   "source": [
    "**처음에는 밥/국/반찬3개/사이드(요구르트 등)/김치 순서로 기록되어 있다가, 2020-07-01부터 갑자기 사이드(샐러드 등)와 김치의 순서가 뒤바뀝니다.<br>\n",
    "+행으로 따지면 1067번 행부터!**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "paperback-annotation",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[Timestamp('2020-06-11 00:00:00'),\n",
       "        '쌀밥/잡곡밥 (쌀,현미,흑미:국내산) 매운소고기국  굴비구이  토마토프리타타  도라지오이무침  배추겉절이 (배추국내,고추가루:중국산) '],\n",
       "       [Timestamp('2020-06-12 00:00:00'),\n",
       "        '돈육버섯고추장덮밥 (쌀,돈육:국내산) 팽이무국  양파링카레튀김  모듬어묵볶음  참나물생채 요구르트 포기김치 (김치:국내산) '],\n",
       "       [Timestamp('2020-07-01 00:00:00'),\n",
       "        '쌀밥/잡곡밥 냉모밀국수 매운돈갈비찜 메밀전병*간장 고구마순볶음 포기김치 양상추샐러드*딸기요거트 '],\n",
       "       [Timestamp('2020-07-02 00:00:00'),\n",
       "        '쌀밥/잡곡밥 대파육개장 홍어미나리초무침 어묵잡채 콩자반 배추겉절이 양상추샐러드*오리엔탈 ']],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "np.array(train[ (train.index > 1064) & (train.index < 1069)][['date', 'ln']])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "governmental-martial",
   "metadata": {},
   "source": [
    "**말씀드린 것처럼 위에서 2020-07-01부터 순서가 바뀌는 것을 확인할 수 있었는데<br>\n",
    "또 새롭게 안 사실은 20/06/13 ~ 20/06/30 까지는 데이터가 아예 없는 것을 확인할 수 있었습니다.**"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "dynamic-creativity",
   "metadata": {},
   "source": [
    "**지금처럼 그대로 출력하면 그 날의 메뉴가 뭐가 나왔는지 한 눈에 보기는 어렵습니다.<br>\n",
    "그래서 밥이면 밥, 국이면 국 이렇게 따로 메뉴명별 칼럼을 나누려고 합니다.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "inappropriate-short",
   "metadata": {},
   "outputs": [],
   "source": [
    "bob = []; gook = []; banchan1 = []; banchan2 = []; banchan3 = []; kimchi = []; side = []\n",
    "for i, day_menu in enumerate(lunch):\n",
    "    bob_tmp = day_menu[0]; bob.append(bob_tmp)\n",
    "    gook_tmp = day_menu[1]; gook.append(gook_tmp)\n",
    "    banchan1_tmp = day_menu[2]; banchan1.append(banchan1_tmp)\n",
    "    banchan2_tmp = day_menu[3]; banchan2.append(banchan2_tmp)\n",
    "    banchan3_tmp = day_menu[4]; banchan3.append(banchan3_tmp)\n",
    "\n",
    "    if i < 1067:\n",
    "        kimchi_tmp = day_menu[-1]; kimchi.append(kimchi_tmp)\n",
    "        side_tmp = day_menu[-2]; side.append(side_tmp)\n",
    "    else: \n",
    "        kimchi_tmp = day_menu[-2]; kimchi.append(kimchi_tmp)\n",
    "        side_tmp  = day_menu[-1]; side.append(side_tmp)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "automatic-storage",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/opt/conda/lib/python3.7/site-packages/ipykernel_launcher.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  \n",
      "/opt/conda/lib/python3.7/site-packages/ipykernel_launcher.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  This is separate from the ipykernel package so we can avoid doing imports until\n"
     ]
    }
   ],
   "source": [
    "train_ln = train[['date', 'dow', 'employees', 'dayoff', 'bustrip', 'ovtime', 'remote', 'ln', 'target_ln']]\n",
    "train_ln['bob'] = bob\n",
    "train_ln['gook'] = gook\n",
    "train_ln['banchan1'] = banchan1; train_ln['banchan2'] = banchan2; train_ln['banchan3'] = banchan3\n",
    "train_ln['kimchi'] = kimchi \n",
    "train_ln['side'] = side"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "solid-cleaning",
   "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>ln</th>\n",
       "      <th>target_ln</th>\n",
       "      <th>bob</th>\n",
       "      <th>gook</th>\n",
       "      <th>banchan1</th>\n",
       "      <th>banchan2</th>\n",
       "      <th>banchan3</th>\n",
       "      <th>kimchi</th>\n",
       "      <th>side</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1065</th>\n",
       "      <td>쌀밥/잡곡밥 (쌀,현미,흑미:국내산) 매운소고기국  굴비구이  토마토프리타타  도라...</td>\n",
       "      <td>682.0</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>1066</th>\n",
       "      <td>돈육버섯고추장덮밥 (쌀,돈육:국내산) 팽이무국  양파링카레튀김  모듬어묵볶음  참나...</td>\n",
       "      <td>516.0</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>1067</th>\n",
       "      <td>쌀밥/잡곡밥 냉모밀국수 매운돈갈비찜 메밀전병*간장 고구마순볶음 포기김치 양상추샐러드...</td>\n",
       "      <td>866.0</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>1068</th>\n",
       "      <td>쌀밥/잡곡밥 대파육개장 홍어미나리초무침 어묵잡채 콩자반 배추겉절이 양상추샐러드*오리엔탈</td>\n",
       "      <td>675.0</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>1069</th>\n",
       "      <td>카레라이스 동태알탕 부추고추전*간장 쫄면야채무침 과일요거트샐러드 포기김치 요구르트</td>\n",
       "      <td>607.0</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",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                     ln  target_ln        bob  \\\n",
       "1065  쌀밥/잡곡밥 (쌀,현미,흑미:국내산) 매운소고기국  굴비구이  토마토프리타타  도라...      682.0     쌀밥/잡곡밥   \n",
       "1066  돈육버섯고추장덮밥 (쌀,돈육:국내산) 팽이무국  양파링카레튀김  모듬어묵볶음  참나...      516.0  돈육버섯고추장덮밥   \n",
       "1067  쌀밥/잡곡밥 냉모밀국수 매운돈갈비찜 메밀전병*간장 고구마순볶음 포기김치 양상추샐러드...      866.0     쌀밥/잡곡밥   \n",
       "1068  쌀밥/잡곡밥 대파육개장 홍어미나리초무침 어묵잡채 콩자반 배추겉절이 양상추샐러드*오리엔탈       675.0     쌀밥/잡곡밥   \n",
       "1069     카레라이스 동태알탕 부추고추전*간장 쫄면야채무침 과일요거트샐러드 포기김치 요구르트       607.0      카레라이스   \n",
       "\n",
       "        gook  banchan1 banchan2  banchan3 kimchi          side  \n",
       "1065  매운소고기국      굴비구이  토마토프리타타   도라지오이무침  배추겉절이       도라지오이무침  \n",
       "1066    팽이무국   양파링카레튀김   모듬어묵볶음     참나물생채   포기김치          요구르트  \n",
       "1067   냉모밀국수    매운돈갈비찜  메밀전병*간장    고구마순볶음   포기김치  양상추샐러드*딸기요거트  \n",
       "1068   대파육개장  홍어미나리초무침     어묵잡채       콩자반  배추겉절이   양상추샐러드*오리엔탈  \n",
       "1069    동태알탕  부추고추전*간장   쫄면야채무침  과일요거트샐러드   포기김치          요구르트  "
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_ln.iloc[1065:1070, 7:]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "decimal-folder",
   "metadata": {},
   "source": [
    "**메뉴명별 칼럼을 만들어주니 이제는 어떤 메뉴의 빈도수가 높은지 궁금해졌습니다.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "abandoned-banner",
   "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>index</th>\n",
       "      <th>gook</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>맑은국</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>콩나물국</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>된장찌개</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>어묵국</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>가쯔오장국</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>아욱국</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>배추된장국</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>근대국</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>꽃게탕</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>순두부찌개</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   index  gook\n",
       "0    맑은국    46\n",
       "1   콩나물국    44\n",
       "2   된장찌개    37\n",
       "3    어묵국    31\n",
       "4  가쯔오장국    28\n",
       "5    아욱국    28\n",
       "6  배추된장국    28\n",
       "7    근대국    26\n",
       "8    꽃게탕    25\n",
       "9  순두부찌개    23"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gook_df = pd.DataFrame(train_ln['gook'].value_counts().reset_index())\n",
    "gook_df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "individual-aberdeen",
   "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>index</th>\n",
       "      <th>gook</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>262</th>\n",
       "      <td>들깨버섯탕</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263</th>\n",
       "      <td>토란탕</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>264</th>\n",
       "      <td>돼지김치찌개</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>265</th>\n",
       "      <td>북어채국</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>266</th>\n",
       "      <td>짜글이돼지찌개</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>267</th>\n",
       "      <td>냉족발야채무침</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>268</th>\n",
       "      <td>새우살미역국</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>269</th>\n",
       "      <td>소고기떡국</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270</th>\n",
       "      <td>느타리버섯국</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271</th>\n",
       "      <td>건새우무채국</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       index  gook\n",
       "262    들깨버섯탕     1\n",
       "263      토란탕     1\n",
       "264   돼지김치찌개     1\n",
       "265     북어채국     1\n",
       "266  짜글이돼지찌개     1\n",
       "267  냉족발야채무침     1\n",
       "268   새우살미역국     1\n",
       "269    소고기떡국     1\n",
       "270   느타리버섯국     1\n",
       "271   건새우무채국     1"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gook_df.tail(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "described-frontier",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    272.000000\n",
       "mean       4.430147\n",
       "std        7.022545\n",
       "min        1.000000\n",
       "25%        1.000000\n",
       "50%        1.000000\n",
       "75%        5.000000\n",
       "max       46.000000\n",
       "Name: gook, dtype: float64"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gook_df.gook.describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "starting-planner",
   "metadata": {},
   "source": [
    "**Train dataset에는 1205개의 행이 있었는데 서로 다른 국 메뉴는 272개 입니다.<br>\n",
    "특이한 점이라고 할 수 있는것은 절반 이상이 단 1번만 나왔다는 사실입니다.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "lyric-display",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0      쇠불고기\n",
       "1     가자미튀김\n",
       "2      치킨핑거\n",
       "3     주꾸미볶음\n",
       "4    돈육씨앗강정\n",
       "Name: banchan1, dtype: object"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 반찬 1~5 \n",
    "train_ln[f'banchan1'][0:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "applied-generator",
   "metadata": {},
   "outputs": [],
   "source": [
    "banchan_list = []\n",
    "for i in range(3):\n",
    "    tmp = train_ln[f'banchan{i+1}']\n",
    "    for j in range(len(train_ln)):\n",
    "        tmp2 = tmp[j]\n",
    "        banchan_list.append(tmp2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "numerous-beast",
   "metadata": {},
   "outputs": [],
   "source": [
    "banchan_df = pd.DataFrame(pd.DataFrame(banchan_list).value_counts())\n",
    "banchan_df.columns = ['banchan']\n",
    "banchan_df.reset_index(inplace = True)\n",
    "banchan_df.columns = ['index', 'banchan']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "suspected-article",
   "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>index</th>\n",
       "      <th>banchan</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>오이무침</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>오징어볶음</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>닭갈비</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>버섯불고기</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>콩나물무침</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>계란말이</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>훈제오리구이</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>돈육굴소스볶음</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>계란찜</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>숙주나물</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     index  banchan\n",
       "0     오이무침       35\n",
       "1    오징어볶음       32\n",
       "2      닭갈비       30\n",
       "3    버섯불고기       29\n",
       "4    콩나물무침       28\n",
       "5     계란말이       28\n",
       "6   훈제오리구이       27\n",
       "7  돈육굴소스볶음       25\n",
       "8      계란찜       24\n",
       "9     숙주나물       24"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "banchan_df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "first-shelter",
   "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>index</th>\n",
       "      <th>banchan</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1164</th>\n",
       "      <td>봄동달래무침</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1165</th>\n",
       "      <td>봄동된장무침</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1166</th>\n",
       "      <td>봄동숙*간장양념</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1167</th>\n",
       "      <td>봄동전</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1168</th>\n",
       "      <td>봄동전*양념</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1169</th>\n",
       "      <td>봉추찜닭</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1170</th>\n",
       "      <td>부들어묵볶음</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1171</th>\n",
       "      <td>부추고추장무침</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1172</th>\n",
       "      <td>부추고추전*간장</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1173</th>\n",
       "      <td>히레카츠*소스</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         index  banchan\n",
       "1164    봄동달래무침        1\n",
       "1165    봄동된장무침        1\n",
       "1166  봄동숙*간장양념        1\n",
       "1167       봄동전        1\n",
       "1168    봄동전*양념        1\n",
       "1169      봉추찜닭        1\n",
       "1170    부들어묵볶음        1\n",
       "1171   부추고추장무침        1\n",
       "1172  부추고추전*간장        1\n",
       "1173   히레카츠*소스        1"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "banchan_df.tail(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "middle-characterization",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    1174.000000\n",
       "mean        3.079216\n",
       "std         4.371070\n",
       "min         1.000000\n",
       "25%         1.000000\n",
       "50%         1.000000\n",
       "75%         3.000000\n",
       "max        35.000000\n",
       "Name: banchan, dtype: float64"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "banchan_df.banchan.describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "incomplete-granny",
   "metadata": {},
   "source": [
    "**서로 다른 국 메뉴는 272개였던 것과 비교하여 서로 다른 반찬의 메뉴는 1174개로 많은 차이가 나는 것을 확인할 수 있습니다.<br>\n",
    "또한 같은 국이 최대 46번이 나왔지만 같은 반찬은 최대 35번밖에 나오지 않은 것으로 확인이 되어<br>\n",
    "국보다는 반찬이 훨씬 다양하게 공급이 되는것을 확인할 수 있습니다!**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "patent-bikini",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/opt/conda/lib/python3.7/site-packages/seaborn/distributions.py:2557: FutureWarning: `distplot` is a deprecated function and will be removed in a future version. Please adapt your code to use either `displot` (a figure-level function with similar flexibility) or `histplot` (an axes-level function for histograms).\n",
      "  warnings.warn(msg, FutureWarning)\n",
      "/opt/conda/lib/python3.7/site-packages/seaborn/distributions.py:2056: FutureWarning: The `axis` variable is no longer used and will be removed. Instead, assign variables directly to `x` or `y`.\n",
      "  warnings.warn(msg, FutureWarning)\n",
      "/opt/conda/lib/python3.7/site-packages/seaborn/distributions.py:2557: FutureWarning: `distplot` is a deprecated function and will be removed in a future version. Please adapt your code to use either `displot` (a figure-level function with similar flexibility) or `histplot` (an axes-level function for histograms).\n",
      "  warnings.warn(msg, FutureWarning)\n",
      "/opt/conda/lib/python3.7/site-packages/seaborn/distributions.py:2056: FutureWarning: The `axis` variable is no longer used and will be removed. Instead, assign variables directly to `x` or `y`.\n",
      "  warnings.warn(msg, FutureWarning)\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAABBQAAAEKCAYAAACi+wbQAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/Il7ecAAAACXBIWXMAAAsTAAALEwEAmpwYAAAjIElEQVR4nO3dfZBdZ30f8O8PydhRSGxsqw625NpBqjIuk4CtEgqdlAIldrAw09IMGSZxiDNbBtKkbWiCk2mBmbYhhQkhbQLZBGKToTgJocW4OKlxSGlD7ETixRiDqo15kYwdK5ZtQlwbW376xz1XulrtSnv23n3R7uczs3PPec5zznnOs+fe+9zfec5zqrUWAAAAgD6estIFAAAAAE49AgoAAABAbwIKAAAAQG8CCgAAAEBvAgoAAABAbwIKAAAAQG8nDShU1Xur6v6qunOOZT9dVa2qzu3mq6p+papmquqOqrp0KQoNAAAArKyF9FC4LsnlsxOramuSlyb56kjyFUm2d39TSd41fhEBAACA1WbjyTK01j5RVRfNsegdSX4myYdH0q5K8r7WWktyW1WdVVXPaK3de6J9nHvuue2ii+baBQCsb3v27Pmr1trmlS7HeqA9AgBzm689ctKAwlyq6qok97TWPltVo4suSLJ/ZP5Al3bCgMJFF12U3bt3L6YoALCmVdVXVroM64X2CADMbb72SO9BGatqU5KfS/LvxizQVFXtrqrdBw8eHGdTAMAaZ0wnAFh9FvOUh2cmuTjJZ6vqy0m2JPlUVX1HknuSbB3Ju6VLO05rbbq1trO1tnPzZj05AYATui7GdAKAVaV3QKG19rnW2t9qrV3UWrsog9saLm2t3ZfkxiQ/0l0ZeF6Sh082fgIAwMm01j6R5NAci4ZjOrWRtCNjOrXWbktyVlU9YxmKCQDrykIeG/mBJH+aZEdVHaiqa06Q/aNJ7k4yk+Q3krxuIqUEAJhldEynWYvmG9Nprm24BRMAFmkhT3n4oZMsv2hkuiV5/fjFAgCY38iYTi8dZzuttekk00myc+fOdpLsAMCIRT3lAQBghY2O6ZQcHdPpuekxphMAsHiLGZQRAGBFGdMJAFaegAIAsOoZ0wkAVh+3PAAAq54xnQBg9dFDAQAAAOhNQAEAAADoTUABAAAA6E1AAQAAAOhNQAEAAADoTUABAAAA6E1AAQAAAOhNQAEAAADoTUABAAAA6G3jShcAWEYz05PZzrapyWwHAGAVmd7Tr600dZk2EeubHgoAAABAbwIKAAAAQG8CCgAAAEBvAgoAAABAbwIKAAAAQG8CCgAAAEBvAgoAAABAbwIKAAAAQG8bT5ahqt6b5Mok97fWntWlvS3JriTfTPIXSV7TWnuoW3ZtkmuSHE7yk621P1yaosMpYGZ6MtvZNjWZ7QAAAEzIQnooXJfk8llptyR5Vmvtu5P83yTXJklVXZLkVUn+brfOr1XVhomVFgAAAFgVThpQaK19IsmhWWn/s7X2RDd7W5It3fRVSW5orT3WWvtSkpkkz51geQEAAIBVYBJjKPxYkpu76QuS7B9ZdqBLAwBYtKp6b1XdX1V3jqS9raq+WFV3VNV/q6qzRpZdW1UzVbW3qr5/RQoNAGvcScdQOJGq+vkkTyR5/yLWnUoylSQXXnjhOMWAtW9SYzEAnLquS/JfkrxvJO2WJNe21p6oql/M4BbMn511C+b5ST5WVX+ntXZ4mcsMAGvaonsoVNWPZjBY46tba61LvifJ1pFsW7q047TWpltrO1trOzdv3rzYYgAA64BbMAFg9VlUD4WqujzJzyT5h621R0YW3Zjkv1bVL2VwRWB7kj8bu5QAACf2Y0l+p5u+IIMAw9C8t2DqMQmnluk9/XptTl3mSVmwlBby2MgPJHlhknOr6kCSN2XQpfD0JLdUVZLc1lp7bWvt81X1u0nuyuBWiNfrXghr0CRvwfBITGBM49yC2VqbTjKdJDt37mwnyQ4AjDhpQKG19kNzJL/nBPn/Q5L/ME6hAAAWYuQWzBcv5hZMAGDxJvGUBwCAZTdyC+bL57gF81VVdXpVXRy3YALAkhjrKQ8AAMvBLZgAsPoIKAAAq55bMIHF6DuII9CPWx4AAACA3gQUAAAAgN4EFAAAAIDeBBQAAACA3gQUAAAAgN4EFAAAAIDeBBQAAACA3gQUAAAAgN4EFAAAAIDeBBQAAACA3gQUAAAAgN4EFAAAAIDeBBQAAACA3jaudAEAAID1aXrP9EoXARiDHgoAAABAbwIKAAAAQG8CCgAAAEBvAgoAAABAbwIKAAAAQG8nDShU1Xur6v6qunMk7eyquqWq9nWvT+/Sq6p+papmquqOqrp0KQsPAAAArIyF9FC4Lsnls9LemOTW1tr2JLd280lyRZLt3d9UkndNppgAAADAanLSgEJr7RNJDs1KvirJ9d309UleMZL+vjZwW5KzquoZEyorALBO6TEJAKvPYsdQOK+1dm83fV+S87rpC5LsH8l3oEs7TlVNVdXuqtp98ODBRRYDAFgnrosekwCwqow9KGNrrSVpi1hvurW2s7W2c/PmzeMWAwBYw/SYBIDVZ7EBhb8cfjF3r/d36fck2TqSb0uXBgAwaWP3mAQAFm+xAYUbk1zdTV+d5MMj6T/S3bv4vCQPj3zRAwAsicX2mHQLJgAs3kIeG/mBJH+aZEdVHaiqa5K8Nck/rqp9SV7SzSfJR5PcnWQmyW8ked2SlBoAYAI9Jt2CCQCLt/FkGVprPzTPohfPkbclef24hQIAWIBhj8m35vgekz9RVTck+d7oMQkAS+KkAQUAgJXW9Zh8YZJzq+pAkjdlEEj43a735FeS/GCX/aNJfiCDHpOPJHnNshcYANYBAQUAYNXTYxIAVp+xHxsJAAAArD8CCgAAAEBvbnkAAAAmZnrP9EoXAVgmeigAAAAAvQkoAAAAAL0JKAAAAAC9CSgAAAAAvRmUEQAAYBH6DkA5ddnUEpUEVoYeCgAAAEBvAgoAAABAbwIKAAAAQG8CCgAAAEBvAgoAAABAbwIKAAAAQG8CCgAAAEBvAgoAAABAbwIKAAAAQG8bV7oAwDo3Mz2Z7Wybmsx2AACABdFDAQAAAOhNQAEAAADobayAQlX9q6r6fFXdWVUfqKozquriqrq9qmaq6neq6qmTKiwAAACwOiw6oFBVFyT5ySQ7W2vPSrIhyauS/GKSd7TWtiV5MMk1kygoAAAAsHqMe8vDxiTfUlUbk2xKcm+SFyX5YLf8+iSvGHMfAADz0mMSAFbGogMKrbV7krw9yVczCCQ8nGRPkodaa0902Q4kuWCu9atqqqp2V9XugwcPLrYYAMA6psckAKyccW55eHqSq5JcnOT8JN+a5PKFrt9am26t7Wyt7dy8efNiiwEAoMckAKyAcW55eEmSL7XWDrbWHk/yoSQvSHJW94WeJFuS3DNmGQEA5qTHJACsnHECCl9N8ryq2lRVleTFSe5K8vEkr+zyXJ3kw+MVEQBgbnpMAsDKGWcMhdsz6Er4qSSf67Y1neRnk/zrqppJck6S90ygnAAAc9FjEgBWyMaTZ5lfa+1NSd40K/nuJM8dZ7sAAAt0pMdkkv+XQY/J3TnaY/KG6DEJAEti3MdGAgCsGD0mAWDljNVDAQBgpekxCZwqpvdM98o/ddnUEpUEJkMPBQAAAKA3AQUAAACgNwEFAAAAoDcBBQAAAKA3AQUAAACgNwEFAAAAoDePjYS5zPR7pA8AAMB6o4cCAAAA0JseCqwtehYAAAAsCz0UAAAAgN4EFAAAAIDeBBQAAACA3oyhAKwNkxo/Y9vUZLYDAGvE9B5jVAFz00MBAAAA6E1AAQAAAOhNQAEAAADoTUABAAAA6E1AAQAAAOhNQAEAAADoTUABAAAA6G2sgEJVnVVVH6yqL1bVF6rq71fV2VV1S1Xt616fPqnCAgAAAKvDuD0U3pnkD1pr35Xke5J8Ickbk9zaWtue5NZuHgBgSbjAAQArY9EBhao6M8n3JXlPkrTWvtlaeyjJVUmu77Jdn+QV4xURAOCEXOAAgBUwTg+Fi5McTPJbVfXpqvrNqvrWJOe11u7t8tyX5Ly5Vq6qqaraXVW7Dx48OEYxAID1ygUOAFg54wQUNia5NMm7WmvPSfI3mRX9b621JG2ulVtr0621na21nZs3bx6jGADAOjbWBQ4AYPE2jrHugSQHWmu3d/MfzCCg8JdV9YzW2r1V9Ywk949bSIBTzsz0ZLazbWoy24G1a3iB41+01m6vqndmjgscVTXnBY6qmkoylSQXXnjhUpcVANaURfdQaK3dl2R/Ve3okl6c5K4kNya5uku7OsmHxyohAMD85rrAcWm6CxxJcqILHHpMAsDijdNDIUn+RZL3V9VTk9yd5DUZBCl+t6quSfKVJD845j4AAObUWruvqvZX1Y7W2t4cvcBxVwYXNt4aFzgAYEmMFVBorX0myc45Fr14nO0CAPTgAgcArIBxeyjAZEzqfnMA1h0XOKCf6T3aXcBkjPOUBwAAAGCd0kMBYNRa7S3jqRMAAEyYHgoAAABAbwIKAAAAQG8CCgAAAEBvAgoAAABAbwIKAAAAQG8CCgAAAEBvHhsJAACwCk3vWfhjn6cu82hnlp8eCgAAAEBvAgoAAABAbwIKAAAAQG8CCgAAAEBvBmUEWM1mFj4YEwAALCc9FAAAAIDeBBQAAACA3gQUAAAAgN4EFAAAAIDeBBQAAACA3gQUAAAAgN4EFAAAAIDeNo67garakGR3kntaa1dW1cVJbkhyTpI9SX64tfbNcfcDAHCqmd4z3Sv/1GVTS1QS1rK+5xnApEyih8JPJfnCyPwvJnlHa21bkgeTXDOBfQAAzKuqNlTVp6vqpm7+4qq6vapmqup3quqpK11GAFhrxgooVNWWJC9L8pvdfCV5UZIPdlmuT/KKcfYBALAALnAAwDIbt4fCLyf5mSRPdvPnJHmotfZEN38gyQVzrVhVU1W1u6p2Hzx4cMxiAADrlQscALAyFj2GQlVdmeT+1tqeqnph3/Vba9NJppNk586dbbHlAADWvV/O4ALHt3XzvS5wJJlKkgsvvHBpSwkLZEwE4FQxTg+FFyR5eVV9OYNBGF+U5J1JzqqqYaBiS5J7xiohAMA8Ri9wLGb91tp0a21na23n5s2bJ1w6AFjbFh1QaK1d21rb0lq7KMmrkvxRa+3VST6e5JVdtquTfHjsUgIAzM0FDgBYIZN4ysNsP5vkX1fVTAZdDt+zBPsAAHCBAwBW0KLHUBjVWvvjJH/cTd+d5LmT2C4AwCL9bJIbqurfJ/l0XOAAgImbSECBdWzGoEEArA4ucADrWd/BPKcum1qikrCeLMUtDwAAAMAaJ6AAAAAA9OaWBwAWblK3OW3TzRIA4FSnhwIAAADQmx4K65XBFAEAABiDHgoAAABAbwIKAAAAQG8CCgAAAEBvAgoAAABAbwIKAAAAQG8CCgAAAEBvAgoAAABAbwIKAAAAQG8CCgAAAEBvAgoAAABAbwIKAAAAQG8CCgAAAEBvAgoAAABAbwIKAAAAQG8CCgAAAEBvAgoAAABAb4sOKFTV1qr6eFXdVVWfr6qf6tLPrqpbqmpf9/r0yRUXAOAo7REAWDnj9FB4IslPt9YuSfK8JK+vqkuSvDHJra217Ulu7eYBAJaC9ggArJBFBxRaa/e21j7VTf91ki8kuSDJVUmu77Jdn+QVY5YRAGBO2iMAsHI2TmIjVXVRkuckuT3Jea21e7tF9yU5b551ppJMJcmFF144iWIAAOuY9gjLZXrPdK/8U5dNLVFJYPGcx0zC2IMyVtXTkvx+kn/ZWvv66LLWWkvS5lqvtTbdWtvZWtu5efPmcYsBAKxj2iMAsPzGCihU1WkZfHm/v7X2oS75L6vqGd3yZyS5f7wiAgDMT3sEAFbGOE95qCTvSfKF1tovjSy6McnV3fTVST68+OIBAMxPewQAVs44Yyi8IMkPJ/lcVX2mS/u5JG9N8rtVdU2SryT5wbFKCAAwP+0RAFghiw4otNb+T5KaZ/GLF7tdAICF0h4BgJUz9qCMAAAAwPojoAAAAAD0Ns4YCqyEmX7PiwUA4OSm92hjAfSlhwIAAADQmx4KAACwhPR+ANYqAQUAlt+kbt/aNjWZ7QAAJ9Q3MDZ1me/o9cAtDwAAAEBvAgoAAABAbwIKAAAAQG8CCgAAAEBvBmUEAGDN8WQFgKWnhwIAAADQm4ACAAAA0JuAAgAAANCbMRQAOHXNTOge6W1Tk9kOALAs+o6TMnWZ7/qloIcCAAAA0JseCifj6hcAAMCS8mSWU5OAAgAAx9GdGICTccsDAAAA0Nva7aFwx5uT737zydMWsvzAR5Itu46fns+Bjxyd3rJrMD97G8NlCzF7n3e9PbnkDUe38/W9R+dH9/H1vYPpS94wf7mS5OAnk9PPSb59x2Cdb99xdPnoNj597SDfN+5OTjtzMD001zpJ8sj+5DtecnQfSfLYA8lzfmGwvccfTp72nYP1D34y2fz8o+s/sj/ZtPXo9IZNyeFHBvNPPp6cf0XytZsH8085bbCf+z6WPPloctrZg/THDw1en7Z9sN9Rhx9Jnnwsedq2wfHd9fbBfpJB+mlPP5pvw6bk8QcHaY8/3G2zK/fXbh7sf8OmwbKnnDYoXzKop8cf7sp608jOK4N43pM5Gtc73L1uOH76KWcMjuspZ3TbPtxtox3d3pGyHT5Bvvls6Mr64LF5h/udPX3MPg/NXebRbQ8q9dhjfdr25Bv7Zu3/0OB/9/ihY495+L9NBvU8eh4+/mBy/ssG9Tv8Pw/Pk01bB/s4/8rBefXI/qPnx+OHBvmH59noOTi6r6HRfQ7P09HzcliuoW/sGxzX+VckX/sfg/PssQcG6ybHpiUj53ZXvsOPHH3vDPefDPKffs6x6+185+D8HT325Oj6o++rJPnGzGDfw/N9mO/xhwfHNzyew48M6ma4z2/fMSj3U04frDP8vBjWRTIoy/CzYvi+Gn4+fPrawXt/+Fk1+pk03Nbo9DDP7M/K0fW37BrsIzn2c3Ghn6/D7Y3elnbHm0/8XXEi46zLmvTPb/rn+fUrf32li7FoH9n7kezasWvetLd/8u3Zcc6O7NqxK9N7pvP2T749b3j+G066XnJ8j4Y3//Gb8+YXvvmE07MNl82X/yN7P5K9D+w9pkzDMo6WdeiT+z+Z528dfE4P8ybJjnN2HNnO6Hp7H9ibHefsOKZMN8/cnNOeclo2nbYpz9/6/CPHPNz/cH/D6eHrx+7+2JF1hmU5Z9M52f/w/mw6bVMOPXooV26/Mnsf2JuZQzPZdva2JMndD96dJ9uTedn2l2XvA3uz79C+VCrvvvLded3/eF2u2HZFbtp3U7afvf1IGfcd2ndkW/sO7cuG2pAn25PZdva27H94fx49/Gg21OD7+8zTz8yDjz6Y0zecnkcPP5pK5fQNp2frmVtz94N3H9n+GRvOOLLe4Xb4yPzQhtpwJO+JnLHhjDx2+LEkSevaJLO3Ndze4XY4lTqSb3R6trPPODuHHj10wn0vxnz7HNbTsNzD8s5eZ5hv9JiHdX+4HT5mve1nbz/mfBjObz1za3acsyM3z9ycK7ZdkZtnbs6Zp5+ZJEf+d1vPHLSp9z+8Py/5zpdk145dee1Nr02SI+fO8FyefV4Pz/3X3vTavPvKdyc59r0/fC888MgD+YWX/MKR9UZ7OY2+z5Ic9/kwavQ9Mjt9WLbR98/wPTnbsIzDbZ3os2StmOszcamt3YDCnW9JNp1/8rSFLP/aTUcbp6PT8xn94bhl19H50W2Mzp/M7H0Of4R97ab5881edqJyJYMfV8PtfmPf8cuHeYY/0EenT7TO6H4fn/UhPpz/xr75j+nID87M+jE7K++Th48/nvm2M9vocc9VvtF9zz7m4TpPHj6a58mRH9PD/MfVS8vRH92HZy07fPz0kW2P1kE7dnqu8h6Xbz6Hj6+z2duZXf/H7HOOMs85PzJ9TH0fPvbcGt3fk4/O+l8/enze4fLZ/8P5zqvRc2/4Olfe0WMe3edceUbLNXpcs8s2uu585+Vc583otuf6X821reH6c70vR/PPtZ/hcQ3zjX5GjP5P5trv6OfDsG637Dr2uOb6vBjd1uhnyuzPytH1t+ya+1j6BBRml+POtyw+KDDOurAK3bTvpuMa9aNp+w7ty75D+46ZX8h6yfG3VLzlf70l53/b+Secnm24bL78oz9eh/sflnG0rLPLmWTOvHOtN7ps6PDhw3n08KPHHPNwenT7s9OG6wwNfwAPf5SOLpu939Flwx+rh9vhecs5mn/4g3U0zzBtdhlaWh49/Ohx9TBcPlxvdgBgtCwnMnu9+dKG+xn9MT9fMGH0OCZtvn0O62loWN7Z68zONzvv6PSwzof5R8/P2f+P0eMd/X8N8+zasetIOeY6R+Y6r0fLPfreX8j/dXaeEwUURt8jc6WP7nf0fTrbaL3s2rErb/lfb1nzAYXhMS7nsS7ZLQ9VdXlV7a2qmap641LtBwBgLtoiALC0lqSHQlVtSPKrSf5xkgNJ/ryqbmyt3bUU+wOAscx+os+knvDDitEWAWCt6DNI7nI/LWOpbnl4bpKZ1trdSVJVNyS5KokvcQBgOWiLAHCMhf7Y9tSahVuqWx4uSLJ/ZP5AlwYAsBy0RQBgiVVrCxmwredGq16Z5PLW2o938z+c5Htbaz8xkmcqyTD0syPJ3uM2tPacm+SvVroQq5S6OTH1Mz91c2LqZ36nSt387dba5pUuxKlmIW2RLn2p2yOnynm2Vqjv5aOul5f6Xl7q+3hztkeW6paHe5JsHZnf0qUd0VqbTrKublKtqt2ttZ0rXY7VSN2cmPqZn7o5MfUzP3Wz5p20LZIsfXvEeba81PfyUdfLS30vL/W9cEt1y8OfJ9leVRdX1VOTvCrJjUu0LwCA2bRFAGCJLUkPhdbaE1X1E0n+MMmGJO9trX1+KfYFADCbtggALL2luuUhrbWPJvnoUm3/FLWubvHoSd2cmPqZn7o5MfUzP3Wzxq2StojzbHmp7+WjrpeX+l5e6nuBlmRQRgAAAGBtW6oxFAAAAIA1TEBhwqpqQ1V9uqpu6uYvrqrbq2qmqn6nGxgqVXV6Nz/TLb9oRQu+DKrqrKr6YFV9saq+UFV/v6rOrqpbqmpf9/r0Lm9V1a909XNHVV260uVfSlX1r6rq81V1Z1V9oKrOWM/nTlW9t6rur6o7R9J6nytVdXWXf19VXb0SxzJp89TN27r31R1V9d+q6qyRZdd2dbO3qr5/JP3yLm2mqt64zIexZOaqn5FlP11VrarO7ebX1bnD8lqr77GVVFVbq+rjVXVX9535U126tsQS0a5dPtrJy0vbe3IEFCbvp5J8YWT+F5O8o7W2LcmDSa7p0q9J8mCX/o4u31r3ziR/0Fr7riTfk0E9vTHJra217Ulu7eaT5Iok27u/qSTvWv7iLo+quiDJTybZ2Vp7VgaDh70q6/vcuS7J5bPSep0rVXV2kjcl+d4kz03ypuEX8SnuuhxfN7ckeVZr7buT/N8k1yZJVV2Swbn0d7t1fq1rHG5I8qsZ1N0lSX6oy7sWXJfj6ydVtTXJS5N8dSR5vZ07LJM1/h5bSU8k+enW2iVJnpfk9V29rvu2xBLSrl0+2snLRNt7sgQUJqiqtiR5WZLf7OYryYuSfLDLcn2SV3TTV3Xz6Za/uMu/JlXVmUm+L8l7kqS19s3W2kM5th5m18/72sBtSc6qqmcsa6GX18Yk31JVG5NsSnJv1vG501r7RJJDs5L7nivfn+SW1tqh1tqDGfzoPu6H5qlmrrpprf3P1toT3extSbZ001cluaG19lhr7UtJZjL4gfzcJDOttbtba99MckOX95Q3z7mTDBoAP5NkdOCgdXXusKzW7HtsJbXW7m2tfaqb/usMfnBdEG2JJaFdu3y0k1eEtveECChM1i9n0GB9sps/J8lDIw39Axl88aV73Z8MHm2V5OEu/1p1cZKDSX6r6zr3m1X1rUnOa63d2+W5L8l53fSR+umM1t2a0lq7J8nbM7hyem8G58KeOHdm63uurJtzaJYfS3JzN61uklTVVUnuaa19dtYi9cNScQ4tsa7L8XOS3B5tiaXyy9GuXS7ayctI23uyBBQmpKquTHJ/a23PSpdlldqY5NIk72qtPSfJ3+Rot60kSRs8cmTdPXak60p9VQZfJucn+da4GnpC6/VcOZmq+vkMugS/f6XLslpU1aYkP5fk3610WYDJqKqnJfn9JP+ytfb10WW+HyZDu3bZaScvI23vyRJQmJwXJHl5VX05g66NL8rgXqizuq40yaAb8j3d9D1JtiZJt/zMJA8sZ4GX2YEkB1prt3fzH8zgg/Mvh120utf7u+VH6qczWndrzUuSfKm1drC19niSD2VwPjl3jtX3XFlP51Cq6keTXJnk1e3o84DVTfLMDBoMn+0+n7ck+VRVfUfUD0vHObREquq0DIIJ72+tfahL1paYPO3a5aWdvLy0vSdIQGFCWmvXtta2tNYuymBQjz9qrb06yceTvLLLdnWSD3fTN3bz6Zb/0ciPgDWntXZfkv1VtaNLenGSu3JsPcyunx/pRrF9XpKHR7p8rTVfTfK8qtrU3Y81rBvnzrH6nit/mOSlVfX0LhL90i5tzamqyzPolvry1tojI4tuTPKqbnTiizMYvOnPkvx5ku3daMZPzeAz68blLvdyaK19rrX2t1prF3WfzweSXNp9Jq37c4cls27eY8up+458T5IvtNZ+aWSRtsSEadcuL+3kZaftPUmtNX8T/kvywiQ3ddPfmUEDfibJ7yU5vUs/o5uf6ZZ/50qXexnq5dlJdie5I8l/T/L0DO4/ujXJviQfS3J2l7cyGCH7L5J8LoNRWFf8GJawbt6S5ItJ7kzy20lOX8/nTpIPZHBP2+MZ/AC8ZjHnSgbjCcx0f69Z6eNawrqZyeDevs90f+8eyf/zXd3sTXLFSPoPZPBEiL9I8vMrfVxLWT+zln85ybnr8dzxt7x/a/U9tsJ1+g8y6PJ9x8jn3Q9oSyx5vb8w2rXLUc/Pjnbycta3tveE/qqrJAAAAIAFc8sDAAAA0JuAAgAAANCbgAIAAADQm4ACAAAA0JuAAgAAANCbgAIAAADQm4ACnKKq6qyqet0y7OcVVXXJSfJcV1WvXOqyAACrw2pqh8zKf1FV3bmUZQKOElCAU9dZSRb8RV4Di3nPvyLJgr/IAYB14axoh8C6J6AAp663JnlmVX2mqt5RVbdW1aeq6nNVdVVyJEq/t6rel+TOJFur6t92af+nqj5QVW/o8j6zqv6gqvZU1f+uqu+qqucneXmSt3X7eebJClVVX66qt4yU5buWsA4AgJWxatohVXVZVX22qj6b5PUj6T9aVR/qtruvqv7TUlcKrDcbV7oAwKK9McmzWmvPrqqNSTa11r5eVecmua2qbuzybU9ydWvttqr6e0n+aZLvSXJakk8l2dPlm07y2tbavqr63iS/1lp7Ubedm1prH+xRtr9qrV3adYV8Q5IfH/toAYDVZDW1Q34ryU+01j5RVW+btezZSZ6T5LEke6vqP7fW9o999EASAQVYKyrJf6yq70vyZJILkpzXLftKa+22bvoFST7cWns0yaNV9ZEkqaqnJXl+kt+rquE2Tx+jPB/qXvck+SdjbAcAWP1WrB1SVWclOau19oku6beTXDGS5dbW2sNd3ruS/O0kAgowIQIKsDa8OsnmJJe11h6vqi8nOaNb9jcLWP8pSR5qrT17QuV5rHs9HJ8zALDWrbZ2yKjHRqa1S2DCjKEAp66/TvJt3fSZSe7vvsT/UQbR97n8SZJdVXVGdzXgyiRprX09yZeq6p8lRwZO+p459gMAkKySdkhr7aEkD1XVP+iSXj3GMQE9CSjAKaq19kCSP+kejfTsJDur6nNJfiTJF+dZ58+T3JjkjiQ3J/lckoe7xa9Ock03oNHnk1zVpd+Q5N9U1acXMigjALD2rbJ2yGuS/GpVfSaD2y+AZVKttZUuA7CMqupprbVvVNWmJJ9IMtVa+9RKlwsAWPu0Q2BtcQ8RrD/TVXVJBvc2Xu9LHABYRtohsIbooQAsWFX9agYjNI96Z2vtt1aiPADA+qEdAquPgAIAAADQm0EZAQAAgN4EFAAAAIDeBBQAAACA3gQUAAAAgN4EFAAAAIDe/j99WyaPKrC11AAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 1296x288 with 2 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "fig, ax = plt.subplots(nrows = 1, ncols = 2, figsize = (18, 4))\n",
    "sns.distplot(train[\"target_ln\"], ax = ax[0], color = 'orange', kde = False, rug = True)\n",
    "sns.distplot(train[\"target_dn\"], ax = ax[1], color = 'green', kde = False, rug = True)\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "hispanic-evaluation",
   "metadata": {},
   "source": [
    "**왼쪽이 점심 이용자수, 오른쪽이 저녁 이용자수를 시각화한 것인데요<br>\n",
    "전반적으로 저녁 이용자수가 상대적으로 적음을 확인할 수 있는데 0명인 날이 존재하는 것이 특이한 것 같습니다.**"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "aggressive-interaction",
   "metadata": {},
   "source": [
    "**그렇다면 왜 0명인 날이 있는지 한 번 살펴보겠습니다.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "peaceful-plaintiff",
   "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>date</th>\n",
       "      <th>dayoff</th>\n",
       "      <th>bustrip</th>\n",
       "      <th>ovtime</th>\n",
       "      <th>remote</th>\n",
       "      <th>dow</th>\n",
       "      <th>dn</th>\n",
       "      <th>target_dn</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>204</th>\n",
       "      <td>2016-11-30</td>\n",
       "      <td>68</td>\n",
       "      <td>207</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>2016-12-28</td>\n",
       "      <td>166</td>\n",
       "      <td>225</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>2017-01-25</td>\n",
       "      <td>79</td>\n",
       "      <td>203</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262</th>\n",
       "      <td>2017-02-22</td>\n",
       "      <td>75</td>\n",
       "      <td>252</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>281</th>\n",
       "      <td>2017-03-22</td>\n",
       "      <td>53</td>\n",
       "      <td>235</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306</th>\n",
       "      <td>2017-04-26</td>\n",
       "      <td>45</td>\n",
       "      <td>304</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>327</th>\n",
       "      <td>2017-05-31</td>\n",
       "      <td>43</td>\n",
       "      <td>265</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>자기계발의날</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>346</th>\n",
       "      <td>2017-06-28</td>\n",
       "      <td>58</td>\n",
       "      <td>259</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*자기계발의날*</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>366</th>\n",
       "      <td>2017-07-26</td>\n",
       "      <td>254</td>\n",
       "      <td>246</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>가정의날</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>392</th>\n",
       "      <td>2017-09-01</td>\n",
       "      <td>177</td>\n",
       "      <td>303</td>\n",
       "      <td>45</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>*</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>410</th>\n",
       "      <td>2017-09-27</td>\n",
       "      <td>70</td>\n",
       "      <td>265</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>쌀밥/잡곡밥 (쌀:국내산) 된장찌개  미니함박조림  계란말이  비름나물  포기김치 ...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>412</th>\n",
       "      <td>2017-09-29</td>\n",
       "      <td>214</td>\n",
       "      <td>248</td>\n",
       "      <td>22</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>*</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>424</th>\n",
       "      <td>2017-10-25</td>\n",
       "      <td>75</td>\n",
       "      <td>289</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>449</th>\n",
       "      <td>2017-11-29</td>\n",
       "      <td>78</td>\n",
       "      <td>261</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>2017-12-27</td>\n",
       "      <td>169</td>\n",
       "      <td>255</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>492</th>\n",
       "      <td>2018-01-31</td>\n",
       "      <td>56</td>\n",
       "      <td>223</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>502</th>\n",
       "      <td>2018-02-14</td>\n",
       "      <td>418</td>\n",
       "      <td>159</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>쌀밥/잡곡밥 (쌀:국내산) 쇠고기무국  고추잡채*꽃빵  계란찜  오이무침  포기김치...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510</th>\n",
       "      <td>2018-02-28</td>\n",
       "      <td>134</td>\n",
       "      <td>278</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>529</th>\n",
       "      <td>2018-03-28</td>\n",
       "      <td>45</td>\n",
       "      <td>252</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>549</th>\n",
       "      <td>2018-04-25</td>\n",
       "      <td>66</td>\n",
       "      <td>285</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>571</th>\n",
       "      <td>2018-05-30</td>\n",
       "      <td>80</td>\n",
       "      <td>281</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>589</th>\n",
       "      <td>2018-06-27</td>\n",
       "      <td>66</td>\n",
       "      <td>277</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>609</th>\n",
       "      <td>2018-07-25</td>\n",
       "      <td>226</td>\n",
       "      <td>256</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>633</th>\n",
       "      <td>2018-08-29</td>\n",
       "      <td>103</td>\n",
       "      <td>258</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>648</th>\n",
       "      <td>2018-09-19</td>\n",
       "      <td>77</td>\n",
       "      <td>288</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>667</th>\n",
       "      <td>2018-10-31</td>\n",
       "      <td>111</td>\n",
       "      <td>306</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>자기계발의날</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>687</th>\n",
       "      <td>2018-11-28</td>\n",
       "      <td>69</td>\n",
       "      <td>298</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>706</th>\n",
       "      <td>2018-12-26</td>\n",
       "      <td>184</td>\n",
       "      <td>241</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>자기계발의날</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>730</th>\n",
       "      <td>2019-01-30</td>\n",
       "      <td>66</td>\n",
       "      <td>226</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>자기개발의날</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>747</th>\n",
       "      <td>2019-02-27</td>\n",
       "      <td>100</td>\n",
       "      <td>274</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*  자기계발의날  *</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>766</th>\n",
       "      <td>2019-03-27</td>\n",
       "      <td>92</td>\n",
       "      <td>259</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*  자기개발의날  *</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>786</th>\n",
       "      <td>2019-04-24</td>\n",
       "      <td>59</td>\n",
       "      <td>273</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*  자기계발의날  *</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>809</th>\n",
       "      <td>2019-05-29</td>\n",
       "      <td>50</td>\n",
       "      <td>237</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*  자기개발의날  *</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>828</th>\n",
       "      <td>2019-06-26</td>\n",
       "      <td>69</td>\n",
       "      <td>282</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*  자기개발의날  *</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>853</th>\n",
       "      <td>2019-07-31</td>\n",
       "      <td>495</td>\n",
       "      <td>231</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>자기계발의날</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>872</th>\n",
       "      <td>2019-08-28</td>\n",
       "      <td>123</td>\n",
       "      <td>274</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>890</th>\n",
       "      <td>2019-09-25</td>\n",
       "      <td>60</td>\n",
       "      <td>285</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>912</th>\n",
       "      <td>2019-10-30</td>\n",
       "      <td>122</td>\n",
       "      <td>294</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>932</th>\n",
       "      <td>2019-11-27</td>\n",
       "      <td>134</td>\n",
       "      <td>288</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>*</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>955</th>\n",
       "      <td>2019-12-31</td>\n",
       "      <td>709</td>\n",
       "      <td>149</td>\n",
       "      <td>22</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2</td>\n",
       "      <td>*</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>973</th>\n",
       "      <td>2020-01-29</td>\n",
       "      <td>101</td>\n",
       "      <td>214</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>자기개발의날</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993</th>\n",
       "      <td>2020-02-26</td>\n",
       "      <td>109</td>\n",
       "      <td>190</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>자기개발의날</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1166</th>\n",
       "      <td>2020-11-25</td>\n",
       "      <td>206</td>\n",
       "      <td>191</td>\n",
       "      <td>3</td>\n",
       "      <td>387.0</td>\n",
       "      <td>3</td>\n",
       "      <td>＜자기 계발의 날＞</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           date  dayoff  bustrip  ovtime  remote  dow  \\\n",
       "204  2016-11-30      68      207       0     0.0    3   \n",
       "224  2016-12-28     166      225       0     0.0    3   \n",
       "244  2017-01-25      79      203       0     0.0    3   \n",
       "262  2017-02-22      75      252       0     0.0    3   \n",
       "281  2017-03-22      53      235       0     0.0    3   \n",
       "306  2017-04-26      45      304       0     0.0    3   \n",
       "327  2017-05-31      43      265       0     0.0    3   \n",
       "346  2017-06-28      58      259       0     0.0    3   \n",
       "366  2017-07-26     254      246       0     0.0    3   \n",
       "392  2017-09-01     177      303      45     0.0    5   \n",
       "410  2017-09-27      70      265       0     0.0    3   \n",
       "412  2017-09-29     214      248      22     0.0    5   \n",
       "424  2017-10-25      75      289       0     0.0    3   \n",
       "449  2017-11-29      78      261       0     0.0    3   \n",
       "468  2017-12-27     169      255       0     0.0    3   \n",
       "492  2018-01-31      56      223       0     0.0    3   \n",
       "502  2018-02-14     418      159       0     0.0    3   \n",
       "510  2018-02-28     134      278       0     0.0    3   \n",
       "529  2018-03-28      45      252       0     0.0    3   \n",
       "549  2018-04-25      66      285       0     0.0    3   \n",
       "571  2018-05-30      80      281       0     0.0    3   \n",
       "589  2018-06-27      66      277       0     0.0    3   \n",
       "609  2018-07-25     226      256       1     0.0    3   \n",
       "633  2018-08-29     103      258       0     0.0    3   \n",
       "648  2018-09-19      77      288       0     0.0    3   \n",
       "667  2018-10-31     111      306       0     0.0    3   \n",
       "687  2018-11-28      69      298       1     0.0    3   \n",
       "706  2018-12-26     184      241       0     0.0    3   \n",
       "730  2019-01-30      66      226       1     0.0    3   \n",
       "747  2019-02-27     100      274       0     0.0    3   \n",
       "766  2019-03-27      92      259       0     0.0    3   \n",
       "786  2019-04-24      59      273       0     0.0    3   \n",
       "809  2019-05-29      50      237       0     0.0    3   \n",
       "828  2019-06-26      69      282       0     0.0    3   \n",
       "853  2019-07-31     495      231       0     0.0    3   \n",
       "872  2019-08-28     123      274       0     0.0    3   \n",
       "890  2019-09-25      60      285       1     0.0    3   \n",
       "912  2019-10-30     122      294       1     0.0    3   \n",
       "932  2019-11-27     134      288       1     0.0    3   \n",
       "955  2019-12-31     709      149      22     0.0    2   \n",
       "973  2020-01-29     101      214       4     0.0    3   \n",
       "993  2020-02-26     109      190       4     0.0    3   \n",
       "1166 2020-11-25     206      191       3   387.0    3   \n",
       "\n",
       "                                                     dn  target_dn  \n",
       "204                                           *                0.0  \n",
       "224                                           *                0.0  \n",
       "244                                            *               0.0  \n",
       "262                                           *                0.0  \n",
       "281                                           *                0.0  \n",
       "306                                           *                0.0  \n",
       "327                                        자기계발의날              0.0  \n",
       "346                                      *자기계발의날*              0.0  \n",
       "366                                          가정의날              0.0  \n",
       "392                                           *                0.0  \n",
       "410   쌀밥/잡곡밥 (쌀:국내산) 된장찌개  미니함박조림  계란말이  비름나물  포기김치 ...        0.0  \n",
       "412                                           *                0.0  \n",
       "424                                           *                0.0  \n",
       "449                                           *                0.0  \n",
       "468                                           *                0.0  \n",
       "492                                           *                0.0  \n",
       "502   쌀밥/잡곡밥 (쌀:국내산) 쇠고기무국  고추잡채*꽃빵  계란찜  오이무침  포기김치...        0.0  \n",
       "510                                           *                0.0  \n",
       "529                                             *              0.0  \n",
       "549                                                            0.0  \n",
       "571                                                            0.0  \n",
       "589                                            *               0.0  \n",
       "609                                                            0.0  \n",
       "633                                           *                0.0  \n",
       "648                                                            0.0  \n",
       "667                                      자기계발의날                0.0  \n",
       "687                                           *                0.0  \n",
       "706                                      자기계발의날                0.0  \n",
       "730                                      자기개발의날                0.0  \n",
       "747                                    *  자기계발의날  *            0.0  \n",
       "766                                    *  자기개발의날  *            0.0  \n",
       "786                                    *  자기계발의날  *            0.0  \n",
       "809                                    *  자기개발의날  *            0.0  \n",
       "828                                   *  자기개발의날  *             0.0  \n",
       "853                                      자기계발의날                0.0  \n",
       "872                                           *                0.0  \n",
       "890                                           *                0.0  \n",
       "912                                           *                0.0  \n",
       "932                                           *                0.0  \n",
       "955                                           *                0.0  \n",
       "973                                      자기개발의날                0.0  \n",
       "993                                      자기개발의날                0.0  \n",
       "1166                                   ＜자기 계발의 날＞              0.0  "
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train[train.target_dn == 0][['date',  'dayoff', 'bustrip', 'ovtime', 'remote', 'dow', 'dn', 'target_dn']]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "blank-chapter",
   "metadata": {},
   "source": [
    "**LH에는 특이하게 '자기계발의날'이라고 있는데요. 월에 마지막주 수요일(dow=3)은 모두 정시 퇴근을 해야하는 날이라고 합니다.<br>\n",
    "그래서 저녁 이용자수가 0명인 것으로 확인이 됩니다.**\n",
    "\n",
    "**+이상한 점이 있었는데 17/09/27와 18/02/14 양일은 저녁 이용자수가 0명이지만 저녁 메뉴가 제공이 되었습니다.<br>**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "intellectual-florida",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/opt/conda/lib/python3.7/site-packages/ipykernel_launcher.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  \n"
     ]
    }
   ],
   "source": [
    "tmp = train[['date', 'dow', 'employees', 'dayoff', 'bustrip', 'ovtime', 'remote', 'target_ln', 'target_dn']]\n",
    "tmp['month'] = tmp['date'].dt.strftime(\"%m\")\n",
    "\n",
    "tmp_ln = tmp.groupby(['dow', 'month'])['target_ln'].mean().reset_index().pivot('dow', 'month', 'target_ln')\n",
    "tmp_dn = tmp.groupby(['dow', 'month'])['target_dn'].mean().reset_index().pivot('dow', 'month', 'target_dn')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "presidential-advisory",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAA14AAAEcCAYAAADX12W8AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/Il7ecAAAACXBIWXMAAAsTAAALEwEAmpwYAAAtV0lEQVR4nO3de7gldX3n+/dnd3MRUUFQRHCUKEqMo6gI5nhD8YKEI2TGu0mQkHScaDTj0YjjM/GSIUePiUYnRqcdETAqOmZQohhlSBBvgKiIIKKNoHTLReWqINC9v+ePVa2L7t671+69qnbV7vfreerZa/1WrfrWarr3h2/Vr2qlqpAkSZIktWdmqXdAkiRJkpY7Gy9JkiRJapmNlyRJkiS1zMZLkiRJklpm4yVJkiRJLbPxkiRJkqSW2XhJW5Hk7CR/tNT7IUnStkryviT/dan3Q9qe2XhpkJJcmeTpS70fkiT1QZOLtyW5JcmNSb6S5GVJZgCq6mVV9VdLvZ/S9szGS5IkaXn4v6vqHsADgbcCrwM+sJQ7lGTFUtaX+sTGS8tGkpOS/Lex54cmWTv2/Mokr0lyUZKbknwsyc5jrx+V5MIkNye5PMnhY5t/YJIvN0cSP59kz44+liRJC1JVN1XV6cALgGOSPGI8IzfmY5L/J8l1Sa5OcuzG9zfrvifJZ5rcOy/Jg8dePyDJmUmuT3JZkudv8t73JjkjyS+Ap3b40aVes/HS9ub5wOHAfsAjgZcCJDkYOAV4LbAb8GTgyrH3vRg4FrgvsCPwmo72V5KkbVJV5wNrgSdt4eX7AfcC9gGOA96TZPex118IvBnYHVgDnACQ5O7AmcBHGGXiC4F/SPLwsfe+uFn/HsCXpviRpEGz8dL25t1V9eOquh74Z+DAZvw44MSqOrOqZqtqXVV9d+x9H6yq71XVbcDHx94nSVKf/Ri49xbG7wTeUlV3VtUZwM+Bh429flpVnV9V64EP8+vcOxK4sqo+WFXrq+qbwD8Bzxt776eq6stNnv5y2h9IGqqVS70DUseuGXt8K3D/5vEDgDMW8L5dp7xfkiS1YR/g+i2M/6xpqjbaNNvmyr0HAockuXHs9ZXAh8aeX7XNeystYzZeWk5+Aewy9vx+C3jvVcCDt7qWJEkDkeRxjBqvLwGHTGmzVwFfqKpnzLNOTamWtKw41VBDtkOSnTcuwIXAEUnuneR+wJ8vYFsfAI5NcliSmST7JDmghX2WJKlVSe6Z5EjgVOAfq+rbU9z8p4GHJvn9JDs0y+OS/OYUa0jLko2XhuwM4Lax5WHAtxjdFOPzwMcm3VBzAfKxwDuBm4AvMJpOIUnSUPxzklsYnZV6A/AORtk2NVV1C/BMRjfV+DGjKYlvA3aaZh1pOUqVZ4MlSZIkqU2e8ZIkSZKkltl4SZIkSVLLbLwkSZIkqWU2XpIkSZLUMhsvSZIkSWqZjZckSZIktczGS5IkSZJaZuMlSZIkSS2z8ZIkSZKkltl4SZIkSVLLVi71DszlC/scUG3XWPfj1kuwsqM/4d8+7O6t19jzcXu3XgPgtqtubr3GzvfbtfUazLb/9wvgxsuub73GLvfZpfUaG25f33oNgN1f8PBO6swcuTrT2tZH8rCJ/jK9uC6bWk312+w5r279F8zph3+m7RLcelvrJTj6tfu1XwS420sOab1G/XBd6zWy156t1wCY/dE1rde47QtXtV4DYJcjH9p6jfVrftZ6jWtf+rTWawA8YNeXdZ6P0I+M9IyXJEmSJLWst2e8JEkjMx4ikyRpM0PLRxsvSeq5rqYsS5I0JEPLx4HtriRtf4Z2RE+SpC4MLR9tvCSp52aW/HJgSZL6Z2j5aOMlST03tCN6kiR1YWj5aOMlST03tGCRJKkLQ8tHGy9J6rmhBYskSV0YWj7aeElSzw3trk2SJHVhaPk4sN2VpO3P0I7oSZLUhaHlo42XJPXc0IJFkqQuDC0fbbwkqeeSgd0vV5KkDgwtHwfWJ0rS9mdmZrJlEklOTHJdkovHxt6e5LtJLkpyWpLdxl57fZI1SS5L8qyx8cObsTVJjp/ix5UkaSKT5mNfzoz1ZDckSXNZuXKyZUInAYdvMnYm8IiqeiTwPeD1AEkeDrwQ+K3mPf+QZEWSFcB7gGcDDwde1KwrSVJnJs3HvtyEw8ZLknpumkfzquoc4PpNxj5fVeubp+cC+zaPjwJOrarbq+oKYA1wcLOsqaofVNUdwKnNupIkdWbaZ7yS7JbkE80skEuT/HaSeyc5M8n3m5+7N+smybubmR8XJXnMVvd3cR9XktS2SUMlyaokF4wtq7ah3B8Cn20e7wNcNfba2mZsrnFJkjrTwlTDdwH/UlUHAI8CLgWOB86qqv2Bs5rnMJr1sX+zrALeu7WN9+TEmyRpLgs4m7UaWL2tdZK8AVgPfHhbtyFJUlemee1WknsBTwZeCtDM6LgjyVHAoc1qJwNnA69jNNPjlKoq4NzmbNneVXX1XDVsvCSp57q4KDjJS4EjgcOaEAFYBzxgbLV9mzHmGZckqRMLycdmFsj4TJDVzQHLjfYDfgJ8MMmjgK8DrwL2GmumrgH2ah7PNfvDxkuShqrtxivJ4cBfAE+pqlvHXjod+EiSdwD3ZzSd4nwgwP5J9mPUcL0QeHG7eylJ0l0tJB8nmBWyEngM8GdVdV6Sd/HraYUbt1FJaovvnoCNlyT13MoV09tWko8ymjKxZ5K1wBsZ3cVwJ+DM5jtRzq2ql1XVJUk+DnyH0RTEl1fVhmY7rwA+B6wATqyqS6a3l5Ikbd0085HRGau1VXVe8/wTjBqvazdOIUyyN3Bd8/p8s0K2vL9T3d0JJDm2qj7YdV1JGqppnvGqqhdtYfgD86x/AnDCFsbPAM6Y3p4JzEhJWogp5+M1Sa5K8rCqugw4jNGBx+8AxwBvbX5+qnnL6cArkpwKHALcNN/1XbA0dzV881wvjN+R659/cWOHuyRJ/TWkL4fUok2UkatPv6jLfZKkXmrhroZ/Bnw4yUXAgcBfM2q4npHk+8DTm+cwOvj4A0ZftfJ+4E+3tvFWzng1O7vFl/j1BWmbGZ97+YV9Dtjm+ZOStJzMzGSpd0FTNI2MnD3n1WakpO3etPOxqi4EDtrCS4dtYd0CXr6Q7bc11XAv4FnADZuMB/hKSzUlaVnKChuvZcaMlKQpGFo+ttV4fRrYteka7yLJ2S3VlKRlaWal8wiXGTNSkqZgaPnYSuNVVcfN85q3HJakBRjaET3Nz4yUpOkYWj56O3lJ6rl4jZckSZsZWj7aeElSzw3tiJ4kSV0YWj7aeElSz3lXQ0mSNje0fLTxkqSeG9pUCkmSujC0fLTxkqSem9lhxVLvgiRJvTO0fLTxkqSeG9ocdkmSujC0fLTxkqSeG9pUCkmSujC0fLTxkqSeG1qwSJLUhaHlo42XJPXc0KZSSJLUhaHlo42XJPXc0G6XK0lSF4aWjzZektRzMzvMLPUuSJLUO0PLRxsvSeq5oc1hlySpC0PLRxsvSeq5oc1hlySpC0PLRxsvSeq5zAxrKoUkSV0YWj7aeElSzw1tKoUkSV0YWj7aeElSz60Y2MXDkiR1YWj52NvG68nnHNt+kV/e3n6NPe7bfg3g+zv/vPUad9v137deA2DnlTu2XuO6W3/Yeo0VM93887r/Dnu1XqNuXNd6jXU73dF6DYBr77ihkzoPn+K2hjaHXe2becKzW6/x+CO+0nqNm394c+s1dn783q3XANjw7R+0XmNm1/bzMQc8qvUaALnlF63X2OXpD2q9BgDrN7ReYodnP7b1Gvvcff/Wa0zb0PKxt42XJGlkaFMpJEnqwtDy0cZLkvpuYEf0JEnqxMDy0cZLknpuaEf0JEnqwtDycVhXpEnS9mjFzGTLBJKcmOS6JBePjT0vySVJZpMctMn6r0+yJsllSZ41Nn54M7YmyfFT+6ySJE1q0nycMCPb5hkvSeq5TPeuTScBfw+cMjZ2MfAfgP9xl7rJw4EXAr8F3B/4P0ke2rz8HuAZwFrga0lOr6rvTHNHJUmaz5TzsXXD2ltJ2h7NZLJlAlV1DnD9JmOXVtVlW1j9KODUqrq9qq4A1gAHN8uaqvpBVd0BnNqsK0lSdybNxwkzMsmVSb6d5MIkFzRjb0qyrhm7MMkRY+tvcVbIXDzjJUl9N+HFw0lWAavGhlZX1epFVN4HOHfs+dpmDOCqTcYPWUQdSZIWrp2bazy1qn66ydg7q+pvxgfmmhVSVXN+v4CNlyT13KQXDzdN1mIaLUmSBmOJb67xq1khwBVJNs4K+epcb3CqoST13dJdOLwOeMDY832bsbnGJUnqzgJurpFkVZILxpZVW9hiAZ9P8vVNXn9FkouaG1Tt3oztw+azP/ZhHp7xkqSeW8IjeqcDH0nyDkbTKPYHzgcC7J9kP0YN1wuBFy/VTkqStk8LyccJZ4U8sarWJbkvcGaS7wLvBf6KUVP2V8DfAn+4Lftr4yVJfbfj9M5mJfkocCiwZ5K1wBsZ3WzjvwP3AT6T5MKqelZVXZLk48B3gPXAyzfOXU/yCuBzwArgxKq6ZGo7KUnSJKaYjwBVta75eV2S04CDm5tSAZDk/cCnm6cLnv1h4yVJPTfNM15V9aI5XjptjvVPAE7YwvgZwBlT2zFJkhZomvmY5O7ATFXd0jx+JvCWJHtX1dXNar/L6CtYYO5ZIXOy8ZKkvmvnrk2SJA3bdPNxL+C0JDDqkT5SVf+S5ENJDmQ01fBK4E8A5psVMhcbL0nquxnvgyRJ0mammI9V9QPgUVsY//153rPFWSFzsfGSpJ6LZ7wkSdrM0PLRxkuS+m4Hz3hJkrSZgeWjjZck9dwSf0GkJEm9NLR8tPGSpL5r58uRJUkatoHlo42XJPXdwOawS5LUiYHlo42XJPXc0KZSSJLUhaHlY2vn55IckOSwJLtuMn54WzUlaVlakckWDYL5KElTMmk+9iQjW2m8krwS+BTwZ8DFSY4ae/mv26gpSctVdpiZaFH/mY+SND2T5mNfMrKtvfhj4LFVdTRwKPBfk7yqeW3OljPJqiQXJLlg9anntbRrkjQwMzOTLRqCbcpH2CQj3/+ZdvdSkoZg0nzsSUa2dY3XTFX9HKCqrkxyKPCJJA9knmCpqtXAaoC6/G3V0r5J0rAMbA675rVN+dis/6uMZMOZZqQkDSwf22r/rk1y4MYnTcgcCewJ/PuWakrS8jSgo3naKvNRkqbFM14A/AGwfnygqtYDf5Dkf7RUU5KWp54EhqbCfJSkaRlYPrbSeFXV2nle+3IbNSVp2RrYVArNzXyUpCkaWD76PV6S1Hcr/VUtSdJmBpaPw9pbSdoeDeyIniRJnRhYPtp4SVLfDWwOuyRJnRhYPtp4SVLfDSxYJEnqxMDy0cZLkvpuYFMpJEnqxMDy0cZLkvpuYBcPS5LUiYHl47D2VpK2Q8mwjuhJktSFoeWjjZck9d3A5rBLktSJgeWjjZck9d3AgkWSpE4MLB9tvCSp7wZ28bAkSZ0YWD4Oq02UpO3RzMxkywSSnJjkuiQXj43dO8mZSb7f/Ny9GU+SdydZk+SiJI8Ze88xzfrfT3LM1D+zJElbM2k+9uTMWD/2QpI0t5UrJlsmcxJw+CZjxwNnVdX+wFnNc4BnA/s3yyrgvTBq1IA3AocABwNv3NisSZLUmUnzcfKMbJWNlyT13RSP5lXVOcD1mwwfBZzcPD4ZOHps/JQaORfYLcnewLOAM6vq+qq6ATiTzZs5SZLaNeUzXkmuTPLtJBcmuaAZW/CskDl3d1EfVpLUvplMtCRZleSCsWXVhBX2qqqrm8fXAHs1j/cBrhpbb20zNte4JEndmTAfF3gt2FOr6sCqOqh5vqBZIfPx5hqS1HeTn81aDaxeTKmqqiS1mG1IktSJbq7dOgo4tHl8MnA28DrGZoUA5ybZLcneYwcyN+MZL0nqu/YvHL62mUJI8/O6Znwd8ICx9fZtxuYalySpOwuYajjhrJACPp/k62OvL3RWyJx6e8Zr/X4Htl5j5aXntV6jK3vs3P4sn1q5Y+s1AH5y21VbX2mRLr/pitZr7LVLN/ca2HPHvVuvsWH39v9+3XjD11uvATAzsG+5B7q4KPh04Bjgrc3PT42NvyLJqYxupHFTVV2d5HPAX4/dUOOZwOvb3kn92o6vfUvrNQ598UNar/Gm335w6zX+9tJujgnsufcOrdf46W2zrdf45Mkfbb0GwCse3352ffHm21uvAfDWQw5ovcZj//K01mvs/ahzW68B8OOXHTa9jS0gHyecFfLEqlqX5L7AmUm+u8k2FjUrpLeNlySpkelNTkjyUUZTJvZMspbR3QnfCnw8yXHAD4HnN6ufARwBrAFuBY4FqKrrk/wV8LVmvbdU1aY37JAkqV1TzEeAqlrX/LwuyWmM7tx77cYphBPOCpmTjZck9d0Ug6WqXjTHS5sdgmzmrb98ju2cCJw4tR2TJGmhpntg8u7ATFXd0jx+JvAWFjgrZL4aNl6S1Hc9+eJHSZJ6Zbr5uBdwWkaXJKwEPlJV/5LkayxgVsh8bLwkqe+mPJVCkqRlYbozQn4APGoL4z9jgbNC5mLjJUl9Z+MlSdLmBpaPNl6S1Hcr/FUtSdJmBpaPw9pbSdoeDeyIniRJnRhYPtp4SVLfDSxYJEnqxMDy0cZLkvpuYMEiSVInBpaPNl6S1HcDCxZJkjoxsHy08ZKkvvN7vCRJ2tzA8tHGS5J6LjM7LPUuSJLUO0PLRxsvSeq7gU2lkCSpEwPLx4karyQ7V9Uv294ZSdIWDCxYtifmoyQtoYHl46RnvC5Oci3wxWb5UlXd1N5uSZJ+ZWBz2Lcz5qMkLZWB5eNEe1tVDwFeBHwb+B3gW0kubHG/JEkbZWayRZ0zHyVpCU2ajz3JyEmnGu4LPAF4EvAo4BLgSy3ulyRpoxkvx+0r81GSltDA8nHSvf0R8DXgr6vqZS3ujyRpUwObSrGdMR8laakMLB8n3dtHA6cAL07y1SSnJDmuxf2SJG00oGkU2yHzUZKWynKcalhV30pyOXA5o+kUvwc8BfjAXO9JcvDorfW1JA8HDge+W1VnLH63JWk70pPA0ObMR0laQgPLx0mv8boA2An4CqO7Nj25qn44z/pvBJ4NrExyJnAI8G/A8UkeXVUnLHrPJWl7MbBg2Z6Yj5K0hAaWj5Ne4/XsqvrJArb7XOBARmF0DbBvVd2c5G+A84AtBkuSVcAqgH947yv5o1VHLKCkJC1TAwuW7Uwn+Qh3zcgVhz2EmUfeb5t3WpKWhYHl46SN1x1J3gE8uXn+BeAt83xXyfqq2gDcmuTyqroZoKpuSzI7V5GqWg2sBrhz9nM14b5J0rI2y5y/Nu9iWPGzbHSSj806v8rIHV/9JDNS0nZv0nyEfmTkpPtwInAL8PxmuRn44Dzr35Fkl+bxYzcOJrkXLOBPSJLEbM1OtGhJmI+StEQmzce+ZOSkZ7weXFX/cez5m7fyBZFPrqrbAaru8kl3AI5Z2C5K0vat/P/xPjMfJWmJDC0fJ228bkvyxKr6EkCSJwC3zbXyxlDZwvhPgZ8ueC8laTvWlyN12iLzUZKWyNDycdLG62XAKc1UCIAb8MicJHViaEf0tjPmoyQtkaHl47yNV5JXjz09Bbh78/gXwNOBi1raL0lSY5pH9JK8CvhjIMD7q+rvktwb+BjwIOBK4PlVdUOSAO8CjgBuBV5aVd+Y2s4MmPkoSUtvaGe8tnZzjXs0y0GMjurdE7gX8CfAY9rdNUkSwIZaP9GyNUkewajpOhh4FHBkkocAxwNnVdX+wFnNcxh939T+zbIKeO/0P91gmY+StMQmzcdJMrIL857xqqo3AyQ5B3hMVd3SPH8T8JnW906SRE3viN5vAudV1a0ASb4A/AfgKODQZp2TgbOB1zXjp1RVAecm2S3J3lV19bR2aKjMR0laelPMRwCSrAAuANZV1ZFJTgKeAmz8ipCXVtWF2zojZNLbye8F3DH2/I5mTJLUsklvlZtkVZILxpZVm2zqYuBJSfZobml+BPAAYK+xZuoafv37fR/gqrH3r23G9GvmoyQtkRZuJ/8q4NJNxl5bVQc2y4XN2DbNCJn05hqnAOcnOa15fjRw0oTvlSQtwqQXD49/we4cr1+a5G3A5xldi3QhsGGTdSqJX847OfNRkpbING+ukWRf4HeAE4BXb2X1bZoRMtEZr6o6ATiW0d2abgCOrar/d5L3SpIWZ5pH86rqA1X12Kp6MqPf598Drk2yN0Dz87pm9XWMzohttG8zpob5KElLZyFnvCaYFfJ3wF+w+ZfZn5DkoiTvTLJTM7ZNM0ImPeNFM2/Ru1lJUsc21J1T21aS+1bVdUn+HaPrux4P7MfoFuhvbX5+qln9dOAVSU4FDgFu8vquzZmPkrQ0FpKP880KSXIkcF1VfT3JoWMvvZ7RFPwdm/e+DnjLNu7u5I2XJGlpTPni4X9KsgdwJ/DyqroxyVuBjyc5Dvgh8Pxm3TMYXQe2htHFw8dOc0ckSVqMKebjE4DnJDkC2Bm4Z5J/rKrfa16/PckHgdc0z7dpRoiNlyT13OwU57BX1ZO2MPYz4LAtjBfw8qkVlyRpiqaVj1X1ekZnt2jOeL2mqn5v43VbzV0Mj2Z0kyrYxhkhNl6S1HPTvl2uJEnLQQf5+OEk9wHC6IZUL2vGt2lGiI2XJPXcAm6DK0nSdqONfKyqsxl9nyVV9bQ51tmmGSE2XpLUc9O8Xa4kScvF0PLRxkuSem5DrV/qXZAkqXeGlo82XpLUc041lCRpc0PLRxsvSeo5b64hSdLmhpaPvW28Lrvhm63XeMRDH9d6jVvTzSnQy35yQes1vvGTc1qvAXC/XXZovcZlN9zeeo397vnT1msAXH5T+99n++/usWfrNU67/IrWawBsqE7K8KZDpretad5OXsvDBW84ovUaD33fua3XmFl7Ses1fvsJB7ReAyCPfmr7Re64tfUS7zl059ZrAKz8xY2t16jd17ReY+Q+rVeod7+x9Rp/f+nprdeYtqHlY28bL0nSyNCO6EmS1IWh5aONlyT13Gx1dJpOkqQBGVo+2nhJUs+tn92w1LsgSVLvDC0fbbwkqedmGdYRPUmSujC0fLTxkqSeG9pUCkmSujC0fLTxkqSeG9r3lEiS1IWh5aONlyT13NCO6EmS1IWh5aONlyT13NAuHpYkqQtDy0cbL0nquaEd0ZMkqQtDy0cbL0nquaHdtUmSpC4MLR9tvCSp54Z28bAkSV0YWj7aeElSzw1tKoUkSV0YWj7aeElSzw0tWCRJ6sLQ8tHGS5J6bmh3bZIkqQtDy0cbL0nquaEd0ZMkqQtDy0cbL0nquaEFiyRJXRhaPtp4SVLPzTKsuzZJktSFoeWjjZck9dzQjuhJktSFoeXjzFLvgCRpfutnZydaJpHkPye5JMnFST6aZOck+yU5L8maJB9LsmOz7k7N8zXN6w9q83NKkrQQk+bjpBnZNhsvSeq52ZqdaNmaJPsArwQOqqpHACuAFwJvA95ZVQ8BbgCOa95yHHBDM/7OZj1Jknph0nzsyxctd9Z4JTmlq1qStJzMVk20TGglcLckK4FdgKuBpwGfaF4/GTi6eXxU85zm9cOSZBqfSb9mPkrStpk0HyfNyCQrknwzyaeb51OdEdLKNV5JTt90CHhqkt0Aquo5bdSVpOVoAYGxClg1NrS6qlZvfFJV65L8DfAj4Dbg88DXgRuran2z2lpgn+bxPsBVzXvXJ7kJ2AP46bZ/mu2b+ShJ09PCNV6vAi4F7tk83zgj5NQk72M0E+S9jM0ISbJx5sgLtrbxts547QvcDLwD+NtmuWXs8RYlWZXkgiQX/K+Tz29p1yRpWCY9mldVq6vqoLFl9fh2kuzO6CzWfsD9gbsDhy/BR9qebVM+wl0z8hNmpCRN9YxXkn2B3wH+Z/M8THlGSFuN10GMjqK+Abipqs4GbquqL1TVF+Z60/j/NDzvmINb2jVJGpYNNdkygacDV1TVT6rqTuB/A08AdmumHsKoMVjXPF4HPACgef1ewM+m+NG2R9uUj3DXjHyuGSlJE+fjhrrrwatmWbXJ5v4O+Av41T3q92DCGSHAxhkh82plqmFVzQLvTPK/mp/XtlVLkpa7O2enNpXiR8Djk+zCaKrhYcAFwL8BzwVOBY4BPtWsf3rz/KvN6/9aNbB79/aM+ShJ07OQfGxmgaze0mtJjgSuq6qvJzl0Kju3Ba3+sq+qtcDzkvwOo6kVkqQFmlbfVVXnJfkE8A1gPfBNRiH0GeDUJP+tGftA85YPAB9Ksga4ntEdEDUF5qMkLd70jkvyBOA5SY4AdmZ0jde7aGaENGe1tjQjZO1CZoR0cpStqj7DKNglSQu0YYonmarqjcAbNxn+AbDZ3LWq+iXwvKkV12bMR0nadtPKx6p6PfB6gOaM12uq6iXN7ISpzQhxeoMk9dwUj+hJkrRsdJCPr2OKM0JsvCSp5ya8cYYkSduVNvKxuenR2c3jqc4IsfGSpJ7zjJckSZsbWj7aeElSz93pKS9JkjYztHy08ZKknhtYrkiS1Imh5aONlyT13NCmUkiS1IWh5aONlyT13DRvJy9J0nIxtHy08ZKknhvaET1JkrowtHy08ZKknrtzaMkiSVIHhpaPNl6S1HNDu3hYkqQuDC0fbbwkqecGdkBPkqRODC0fbbwkqeeGdkRPkqQuDC0fbbwkqedmh3ZIT5KkDgwtH228JKnnhnZET5KkLgwtH228JKnn7pxd6j2QJKl/hpaPNl6S1HOzA/uCSEmSujC0fOxt4/WcT36t9RovevgPWq/xT5dd33oNgGuv/nnrNW780Y2t1wDITFqvsdM9dmq9RlceeMCerde428orW69x0XlXtV4DYIe77dBJnTcdMr1tDW0qhdp3zroftV7jkf/lz1uvwfpftl7iKz89t/UaAGsv/2TrNVbOrGi9xhU3tf/fBLr5vfZvP/pF+0WA9xz2uNZr/PHp/9h6jfvs0k0+vuKR09vW0PKxt42XJGlkw8CO6EmS1IWh5aONlyT13IaBzWGXJKkLQ8tHGy9J6rmhHdGTJKkLQ8tHGy9J6rk7hnZIT5KkDgwtH228JKnnBpYrkiR1Ymj5aOMlST03tKkUkiR1YWj5aOMlST23YXZYwSJJUheGlo82XpLUc0M7oidJUheGlo82XpLUc3dM6RsikzwM+NjY0G8Afwmc0ow/CLgSeH5V3ZAkwLuAI4BbgZdW1TemsjOSJC3StPKxKzNLvQOSpPltqJpo2ZqquqyqDqyqA4HHMmqmTgOOB86qqv2Bs5rnAM8G9m+WVcB7p//pJEnaNpPmY1/OjHnGS5J6rqU57IcBl1fVD5McBRzajJ8MnA28DjgKOKWqCjg3yW5J9q6qq9vYIUmSFmJo13h5xkuSem5DTbYkWZXkgrFl1TybfSHw0ebxXmPN1DXAXs3jfYCrxt6zthmTJGnJTZqPk8xITLJzkvOTfCvJJUne3IyflOSKJBc2y4HNeJK8O8maJBcleczWanjGS5J6btIjelW1Gli9tfWS7Ag8B3j9FrZRSYZ1CFGStF2a8hmv24GnVdXPk+wAfCnJZ5vXXltVn9hk/fHp+Icwmo5/yHwFbLwkqedamJv+bOAbVXVt8/zajVMIk+wNXNeMrwMeMPa+fZsxSZKW3DTzsZlW//Pm6Q7NMl+BBU/Hd6qhJPXcHRtqomUBXsSvpxkCnA4c0zw+BvjU2PgfNNMpHg/c5PVdkqS+mDQf79hQE03HT7IiyYWMDkCeWVXnNS+d0EwnfGeSnZqxBU/H94yXJPXcNKdSJLk78AzgT8aG3wp8PMlxwA+B5zfjZzC6lfwaRndAPHZqOyJJ0iItJB8nmY5fVRuAA5PsBpyW5BGMpuVfA+zYvP91wFu2ZX9tvCSp56Y8leIXwB6bjP2M0V0ON123gJdPrbgkSVPU1m3iq+rGJP8GHF5Vf9MM357kg8BrmucLno7vVENJ6rkhfUeJJEldmeb3eCW5T3OmiyR3YzQ75LvNtc8kCXA0cHHzlgVPx/eMlyT13IbZpd4DSZL6Z8r5uDdwcpIVjE5OfbyqPp3kX5PcBwhwIfCyZv0FT8fvpPFK8kTgYODiqvp8FzUlabnwbNbyZkZK0raZ8lT8i4BHb2H8aXOsv+Dp+K1MNUxy/tjjPwb+HrgH8MYkx7dRU5KWqzs2zE60aBjMSEmajknzsS8Z2dY1XjuMPV4FPKOq3gw8E3jJXG8av83jzV+4oqVdk6RhmZ2dbNFgLDojv/yJ77S9j5LUe5PmY18ysq3GaybJ7kn2AFJVP4Ff3U1r/VxvqqrVVXVQVR10z6fs19KuSdKw1GxNtGgwFp2RT3juw7vaV0nqrUnzsS8Z2dY1XvcCvs7oIrTa+C3OSXZtxiRJE+pLYGhqzEhJmoKh5WMrjVdVPWiOl2aB322jpiQtV0MLFs3PjJSk6RhaPnZ6O/mquhXw4i1JWoDZnlwUrHaZkZK0MEPLR7/HS5J6bmhH9CRJ6sLQ8tHGS5J6bmjBIklSF4aWjzZektRzQwsWSZK6MLR8tPGSpJ4bWrBIktSFoeWjjZck9dzQgkWSpC4MLR9tvCSp52bXD+uuTZIkdWFo+WjjJUk9VzWsI3qSJHVhaPlo4yVJPTe0qRSSJHVhaPlo4yVJPTe0YJEkqQtDy0cbL0nquaEFiyRJXRhaPtp4SVLPDS1YJEnqwtDy0cZLknpuaHdtkiSpC0PLRxsvSeq5oR3RkySpC0PLRxsvSeq5od0uV5KkLgwtH228JKnnhnZET5KkLgwtH228JKnnhhYskiR1YWj5aOMlST03tIuHJUnqwuDysaqWzQKsWg41ltNn8c+rfzX8LP2s4eLS5uK/x37WWS41ltNn8c+rfzWW0zIz/VZuSa1aJjW6qrNcanRVZ7nU6KqOn0XqD/899rPOcqnRVZ3lUqOrOsulxrKx3BovSZIkSeodGy9JkiRJatlya7xWL5MaXdVZLjW6qrNcanRVx88i9Yf/HvtZZ7nU6KrOcqnRVZ3lUmPZSHNhnCRJkiSpJcvtjJckSZIk9Y6NlyRJkiS1bLCNV5LDk1yWZE2S45uxVzTPK8meLdb5cDN2cZITk+zQQo0PJPlWkouSfCLJrtOuMfbau5P8fDHbn69OkpOSXJHkwmY5sIUaSXJCku8luTTJK1uo8cWxz/DjJJ9cTI156hyW5BtNnS8leUgLNZ7W1Lg4yclJFvVl6s2/g+uSXDw2du8kZyb5fvNz9xZqPC/JJUlmkxy0mO1vpc7bk3y3+fd4WpLdplFLaksXGdlFPs5TZ3AZ2UU+zlNncBnZRT7OU8eMnLyG+bgQS/1FYtv4ZW0rgMuB3wB2BL4FPBx4NPAg4EpgzxbrHAGkWT4K/KcWatxzbJ13AMdPu0bz2kHAh4Cft/jndRLw3Jb/2x8LnALMNOvdt40/r7F1/gn4g5Y+y/eA32zW+VPgpBZqXAU8tFnnLcBxi/wsTwYeA1w8Nvb/bfx7CxwPvK2FGr8JPAw4GzhoSn/HtlTnmcDK5vHbFvtZXFzaXOb5dz+1jJynxtTycSt1BpWR83yOk5hSPm6lzqAycp7PMbV83EodM3LyGubjApahnvE6GFhTVT+oqjuAU4GjquqbVXVlB3XOqAZwPrBvCzVuhtFRKuBuwGLugrLFGklWAG8H/mIR295qnSlte2s1/hPwlqqaBaiq61qoAUCSewJPAz65iBrz1Sngns069wJ+POUa/xG4o6q+16xzZjO2zarqHOD6TYaPAk5uHp8MHD3tGlV1aVVdtpjtTljn81W1vnl6Lov7Ny+1rYuM7CIf56sztIzsIh/nqzO0jOwiH+eqY0YurIb5uABDbbz2YXQ0YqO1zVindZopFL8P/EsbNZJ8ELgGOAD47y3UeAVwelVdvYhtT1IH4ITmNPQ7k+zUQo0HAy9IckGSzybZv4UaGx0NnLUx+Fuo80fAGUnWMvr79dYp17gfsHJs2sFzgQcsosZc9hr7u3UNsFcLNZbCHwKfXeqdkObRRUZ2kY/z1hlYRnaRj/PVGVpGdpGPc9UxI7ed+bgVQ228+uIfgHOq6ottbLyqjgXuD1wKvGDKm98FeB6LC6tJvZ5RMD4OuDfwuhZq7AT8sqoOAt4PnNhCjY1exGgKTVv+M3BEVe0LfJDRNJppKuCFwDuTnA/cAmyYco27Fhwd/R78d1ckeQOwHvjwUu+L1HOt5iMsm4zsIh9h+WRk2/kIZuQ2MR8nM9TGax13PfqwbzPWWZ0kbwTuA7y6rRoAVbWBX5/6nmaNy4GHAGuSXAnskmTNImrMVWddVV3dzDy5ndEvyoOnXYPRUar/3YydBjyyhRpkdEH6wcBnFrH9+epcCzyqqs5rxj4G/F9TrrGuqr5aVU+qqoOBcxjNm5+2a5PsDdD8XMzUliWX5KXAkcBLmpCU+qqLjOwiH+etA4PKyC7ycc46DC8ju8jHueqYkQtkPk5uqI3X14D9k+yXZEdGRyZO76pOkj8CngW8aON86RZqPAR+NX/9OcB3p1zjk1V1v6p6UFU9CLi1qhZ7d6C5PsvGXyxhNAXh4rk3sW01GM0lf2qzzlNY3C/J+f5+PRf4dFX9chHb31qdeyV5aLPOMxgdzZ1qjST3BWimtbwOeN8iaszldOCY5vExwKdaqNGJJIczus7jOVV161Lvj7QVXWRkF/k4X52hZWQX+ThnHYaXkV3k45x1zMjJmY8LVD24w8e2LIzunPQ9Rkel3tCMvZLRUZ31jC64/J8t1VnfPL+wWf5ymjUYNcRfBr7N6Jfwhxm7g9O0Pscmry/6robz/Hn969hn+Udg1xZq7MboCNu3ga8yOio29T8vRncGOrzlv8e/23yObzX1fqOFGm9nFFiXAX8+hc/xUeBq4M7m3+BxwB7AWcD3gf8D3LuFGr/bPL6d0dHQz7X0WdYwug5g47/5903r74CLSxvLHP/up5qRc9SYaj5uqQ4Dzcg5/rymmo/z1NmNgWXkHJ9jqvk4Tx0zcvIa5uMCljR/kJIkSZKklgx1qqEkSZIkDYaNlyRJkiS1zMZLkiRJklpm4yVJkiRJLbPxkiRJkqSW2XhJY5LsluRPx54fmuTTS7lPkiT1gRkpLY6Nl3RXuwF/urWVJEnaDu2GGSltMxsvDVaSByX5bpKTknwvyYeTPD3Jl5N8P8nBSe6d5JNJLkpybpJHNu99U5ITk5yd5AdJXtls9q3Ag5NcmOTtzdiuST7R1PpwkizJB5YkaUJmpNQ/K5d6B6RFegjwPOAPga8BLwaeCDwH+C+Mvk39m1V1dJKnAacABzbvPQB4KnAP4LIk7wWOBx5RVQfCaBoF8Gjgt4AfA18GngB8qfVPJknS4piRUo94xktDd0VVfbuqZoFLgLOqqoBvAw9iFDAfAqiqfwX2SHLP5r2fqarbq+qnwHXAXnPUOL+q1jY1Lmy2K0lS35mRUo/YeGnobh97PDv2fJatn9Edf++GedafdD1JkvrEjJR6xMZLy90XgZfAr6ZE/LSqbp5n/VsYTauQJGm5MyOlDnlUQsvdm4ATk1wE3AocM9/KVfWz5sLji4HPAp9pfxclSVoSb8KMlDqT0VRfSZIkSVJbnGooSZIkSS2z8ZIkSZKkltl4SZIkSVLLbLwkSZIkqWU2XpIkSZLUMhsvSZIkSWqZjZckSZIktez/B86PmzuRlyIuAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 1080x288 with 4 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "fig, ax = plt.subplots(nrows = 1, ncols = 2, figsize = (15, 4))\n",
    "\n",
    "sns.heatmap(tmp_ln, cmap='RdYlGn_r', ax=ax[0])\n",
    "ax[0].set_title('Lunch', pad = 12)\n",
    "sns.heatmap(tmp_dn, cmap='RdYlGn_r', ax=ax[1])\n",
    "ax[1].set_title('Dinner', pad = 12)\n",
    "\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "polished-prospect",
   "metadata": {},
   "source": [
    "**점심과 저녁 이용자수는 둘 다 월요일에 제일 많은 것으로 나오는데 그 중에서 점심은 1100명이상이나 이용한다는 사실이 나옵니다.<br>\n",
    "또 점심 이용자수는 금요일에 가장 적은 반면, '자기개발의날' 때문에 저녁 이용자수는 수요일에 가장 적은 것을 알 수 있습니다.<br>**\n",
    "\n",
    "**특이한 점이 점심과 저녁 이용자수는 2월과 3월에 가장 많은 패턴을 보이는데 왜 그런지는 정확히 모르겠습니다**\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "outdoor-omega",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}