8. 시계열 데이터(datetime) 소개 및 푸드코트 판매량 분석 및 시각화.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 필요한 라이브러리 불러오기"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import datetime\n",
    "import random\n",
    "import matplotlib.pyplot as plt\n",
    "%matplotlib inline\n",
    "\n",
    "from datetime import datetime, timedelta # datetime (전자)으로부터 datetime (후자)만 불러올 것\n",
    "# sklearn : import sklearn이 아니라 from sklearn import ~~"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 1. 시계열 데이터 소개 (datetime)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "datetime.datetime(2020, 5, 14, 19, 12, 24, 211846)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 현재 날짜\n",
    "now = datetime.now()\n",
    "now"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 현재 일\n",
    "now.day\n",
    "\n",
    "# 현재 월\n",
    "now.month"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<img src=\"img/예제실습/datetime.jpg\" alt=\"datetime\" style=\"width: 1200px;\"/>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "datetime.datetime(2020, 6, 11, 19, 12, 24, 211846)"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 4주뒤에 날짜 계산\n",
    "now + timedelta(weeks=4)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "datetime.datetime(2020, 5, 24, 19, 12, 24, 211846)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 10일 뒤에 날짜 계산\n",
    "now + timedelta(days=10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "datetime.datetime(2020, 5, 14, 22, 42, 24, 211846)"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 3시간 30분 뒤에 계산\n",
    "now + timedelta(hours =3, minutes = 30)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## date_range(start, end, periods)\n",
    "### start : 시작 기간\n",
    "### end : 끝 기간\n",
    "### periods : 기간\n",
    "### periods는 start부터 시작해서 periods기간 만큼\n",
    "### freq : 'D' or 'M' or 'Y' or 'W-요일(영어로 앞에 3글자)' or 'B'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DatetimeIndex(['1998-10-05', '1998-10-06', '1998-10-07', '1998-10-08',\n",
       "               '1998-10-09', '1998-10-10', '1998-10-11', '1998-10-12',\n",
       "               '1998-10-13', '1998-10-14',\n",
       "               ...\n",
       "               '2020-05-05', '2020-05-06', '2020-05-07', '2020-05-08',\n",
       "               '2020-05-09', '2020-05-10', '2020-05-11', '2020-05-12',\n",
       "               '2020-05-13', '2020-05-14'],\n",
       "              dtype='datetime64[ns]', length=7893, freq='D')"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# period 쓸 때는 end 쓰지 않음\n",
    "# pandas 함수\n",
    "# freq : 'D'\n",
    "pd.date_range(start = '19981005', end = '20200514', freq = 'D')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DatetimeIndex(['1998-10-31', '1998-11-30', '1998-12-31', '1999-01-31',\n",
       "               '1999-02-28', '1999-03-31', '1999-04-30', '1999-05-31',\n",
       "               '1999-06-30', '1999-07-31',\n",
       "               ...\n",
       "               '2019-07-31', '2019-08-31', '2019-09-30', '2019-10-31',\n",
       "               '2019-11-30', '2019-12-31', '2020-01-31', '2020-02-29',\n",
       "               '2020-03-31', '2020-04-30'],\n",
       "              dtype='datetime64[ns]', length=259, freq='M')"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# freq: 'M'\n",
    "pd.date_range(start = '19981005', end = '20200514', freq = 'M')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "22"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# freq: 'Y'\n",
    "len(pd.date_range(start = '19981005', end = '20200514', freq = 'Y'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DatetimeIndex(['1998-10-05', '1998-10-12', '1998-10-19', '1998-10-26',\n",
       "               '1998-11-02', '1998-11-09', '1998-11-16', '1998-11-23',\n",
       "               '1998-11-30', '1998-12-07',\n",
       "               ...\n",
       "               '2020-03-09', '2020-03-16', '2020-03-23', '2020-03-30',\n",
       "               '2020-04-06', '2020-04-13', '2020-04-20', '2020-04-27',\n",
       "               '2020-05-04', '2020-05-11'],\n",
       "              dtype='datetime64[ns]', length=1128, freq='W-MON')"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# freq: 'W-MON' 월요일 ... 특정 날짜만 추출\n",
    "pd.date_range(start = '19981005', end = '20200514', freq = 'W-MON')\n",
    "# 월요일에 태어났구나..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DatetimeIndex(['1998-10-05', '1998-10-06', '1998-10-07', '1998-10-08',\n",
       "               '1998-10-09', '1998-10-12', '1998-10-13', '1998-10-14',\n",
       "               '1998-10-15', '1998-10-16',\n",
       "               ...\n",
       "               '2020-05-01', '2020-05-04', '2020-05-05', '2020-05-06',\n",
       "               '2020-05-07', '2020-05-08', '2020-05-11', '2020-05-12',\n",
       "               '2020-05-13', '2020-05-14'],\n",
       "              dtype='datetime64[ns]', length=5639, freq='B')"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# freq: 'B'\n",
    "pd.date_range(start = '19981005', end = '20200514', freq = 'B')\n",
    "# 주말 빼고"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "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>count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>2020-01-01</td>\n",
       "      <td>998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>2020-01-02</td>\n",
       "      <td>667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>2020-01-03</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>2020-01-04</td>\n",
       "      <td>917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>2020-01-05</td>\n",
       "      <td>614</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>361</td>\n",
       "      <td>2020-12-27</td>\n",
       "      <td>441</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>362</td>\n",
       "      <td>2020-12-28</td>\n",
       "      <td>598</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>363</td>\n",
       "      <td>2020-12-29</td>\n",
       "      <td>177</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>364</td>\n",
       "      <td>2020-12-30</td>\n",
       "      <td>139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>365</td>\n",
       "      <td>2020-12-31</td>\n",
       "      <td>860</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>366 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          date  count\n",
       "0   2020-01-01    998\n",
       "1   2020-01-02    667\n",
       "2   2020-01-03     35\n",
       "3   2020-01-04    917\n",
       "4   2020-01-05    614\n",
       "..         ...    ...\n",
       "361 2020-12-27    441\n",
       "362 2020-12-28    598\n",
       "363 2020-12-29    177\n",
       "364 2020-12-30    139\n",
       "365 2020-12-31    860\n",
       "\n",
       "[366 rows x 2 columns]"
      ]
     },
     "execution_count": 114,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 2020년 sample dataframe 생성\n",
    "sample = pd.DataFrame()\n",
    "sample['date'] = pd.date_range(start = '20200101', periods=366)\n",
    "sample['count'] = random.sample(range(1, 1000), 366) # 윤년\n",
    "sample"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "date     datetime64[ns]\n",
       "count             int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# type 확인\n",
    "sample.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>121</td>\n",
       "      <td>2020-05-01</td>\n",
       "      <td>441</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>122</td>\n",
       "      <td>2020-05-02</td>\n",
       "      <td>878</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>123</td>\n",
       "      <td>2020-05-03</td>\n",
       "      <td>307</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>124</td>\n",
       "      <td>2020-05-04</td>\n",
       "      <td>826</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>125</td>\n",
       "      <td>2020-05-05</td>\n",
       "      <td>137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>126</td>\n",
       "      <td>2020-05-06</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>127</td>\n",
       "      <td>2020-05-07</td>\n",
       "      <td>343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>128</td>\n",
       "      <td>2020-05-08</td>\n",
       "      <td>622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>129</td>\n",
       "      <td>2020-05-09</td>\n",
       "      <td>354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>130</td>\n",
       "      <td>2020-05-10</td>\n",
       "      <td>103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>131</td>\n",
       "      <td>2020-05-11</td>\n",
       "      <td>257</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>132</td>\n",
       "      <td>2020-05-12</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>133</td>\n",
       "      <td>2020-05-13</td>\n",
       "      <td>652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>134</td>\n",
       "      <td>2020-05-14</td>\n",
       "      <td>350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>135</td>\n",
       "      <td>2020-05-15</td>\n",
       "      <td>865</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>136</td>\n",
       "      <td>2020-05-16</td>\n",
       "      <td>984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>137</td>\n",
       "      <td>2020-05-17</td>\n",
       "      <td>700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>138</td>\n",
       "      <td>2020-05-18</td>\n",
       "      <td>703</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>139</td>\n",
       "      <td>2020-05-19</td>\n",
       "      <td>225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>140</td>\n",
       "      <td>2020-05-20</td>\n",
       "      <td>619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>141</td>\n",
       "      <td>2020-05-21</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>142</td>\n",
       "      <td>2020-05-22</td>\n",
       "      <td>936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>143</td>\n",
       "      <td>2020-05-23</td>\n",
       "      <td>706</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>144</td>\n",
       "      <td>2020-05-24</td>\n",
       "      <td>787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>145</td>\n",
       "      <td>2020-05-25</td>\n",
       "      <td>314</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>146</td>\n",
       "      <td>2020-05-26</td>\n",
       "      <td>178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>147</td>\n",
       "      <td>2020-05-27</td>\n",
       "      <td>488</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>148</td>\n",
       "      <td>2020-05-28</td>\n",
       "      <td>890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>149</td>\n",
       "      <td>2020-05-29</td>\n",
       "      <td>319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>150</td>\n",
       "      <td>2020-05-30</td>\n",
       "      <td>578</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>151</td>\n",
       "      <td>2020-05-31</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          date  count\n",
       "121 2020-05-01    441\n",
       "122 2020-05-02    878\n",
       "123 2020-05-03    307\n",
       "124 2020-05-04    826\n",
       "125 2020-05-05    137\n",
       "126 2020-05-06     49\n",
       "127 2020-05-07    343\n",
       "128 2020-05-08    622\n",
       "129 2020-05-09    354\n",
       "130 2020-05-10    103\n",
       "131 2020-05-11    257\n",
       "132 2020-05-12      9\n",
       "133 2020-05-13    652\n",
       "134 2020-05-14    350\n",
       "135 2020-05-15    865\n",
       "136 2020-05-16    984\n",
       "137 2020-05-17    700\n",
       "138 2020-05-18    703\n",
       "139 2020-05-19    225\n",
       "140 2020-05-20    619\n",
       "141 2020-05-21     35\n",
       "142 2020-05-22    936\n",
       "143 2020-05-23    706\n",
       "144 2020-05-24    787\n",
       "145 2020-05-25    314\n",
       "146 2020-05-26    178\n",
       "147 2020-05-27    488\n",
       "148 2020-05-28    890\n",
       "149 2020-05-29    319\n",
       "150 2020-05-30    578\n",
       "151 2020-05-31     78"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 2020년 5월달만 불러오기\n",
    "sample[sample.date.isin(pd.date_range(start = '20200501', end = '20200531'))]\n",
    "# isin : 안에 있는가? - true false 반환"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>count</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2020-01-01</td>\n",
       "      <td>538</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-01-02</td>\n",
       "      <td>461</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-01-03</td>\n",
       "      <td>515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-01-04</td>\n",
       "      <td>829</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-01-05</td>\n",
       "      <td>570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-12-27</td>\n",
       "      <td>536</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-12-28</td>\n",
       "      <td>380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-12-29</td>\n",
       "      <td>122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-12-30</td>\n",
       "      <td>812</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-12-31</td>\n",
       "      <td>611</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>366 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            count\n",
       "date             \n",
       "2020-01-01    538\n",
       "2020-01-02    461\n",
       "2020-01-03    515\n",
       "2020-01-04    829\n",
       "2020-01-05    570\n",
       "...           ...\n",
       "2020-12-27    536\n",
       "2020-12-28    380\n",
       "2020-12-29    122\n",
       "2020-12-30    812\n",
       "2020-12-31    611\n",
       "\n",
       "[366 rows x 1 columns]"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "# date를 index로 설정하기\n",
    "sample.set_index('date', inplace = True) # 원본데이터 손상, 되돌리려면 리셋 (reset)!!!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "metadata": {},
   "outputs": [],
   "source": [
    "# sample2 = sample.set_index('date')\n",
    "# sample2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {},
   "outputs": [],
   "source": [
    "sample.reset_index(inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "# 2020년 5월만 뽑아오기\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "# 2020년 뽑아오기\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    631\n",
       "Name: 2020-10-05 00:00:00, dtype: int64"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample.loc['2020-10-05']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## food_order data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 데이터 불러오기\n",
    "data = pd.read_excel('input/food_order.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "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>dine_type</th>\n",
       "      <th>corner</th>\n",
       "      <th>menu</th>\n",
       "      <th>is_sold_out</th>\n",
       "      <th>use_count</th>\n",
       "      <th>pred_count</th>\n",
       "      <th>additional</th>\n",
       "      <th>good</th>\n",
       "      <th>ok</th>\n",
       "      <th>bad</th>\n",
       "      <th>diff_use_pred</th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>wday</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>2013-08-06</td>\n",
       "      <td>dinner</td>\n",
       "      <td>grill &amp; fry</td>\n",
       "      <td>훈제연어벤또(200개)</td>\n",
       "      <td>F</td>\n",
       "      <td>213</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-213</td>\n",
       "      <td>2013</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>2013-08-06</td>\n",
       "      <td>dinner</td>\n",
       "      <td>rice &amp; soup 1</td>\n",
       "      <td>뚝배기 우거지 갈비탕</td>\n",
       "      <td>F</td>\n",
       "      <td>261</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-261</td>\n",
       "      <td>2013</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>2013-08-06</td>\n",
       "      <td>lunch</td>\n",
       "      <td>noodle bar</td>\n",
       "      <td>판모밀정식</td>\n",
       "      <td>F</td>\n",
       "      <td>267</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-267</td>\n",
       "      <td>2013</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>2013-08-06</td>\n",
       "      <td>breakfast</td>\n",
       "      <td>rice &amp; soup 1</td>\n",
       "      <td>설렁탕정식</td>\n",
       "      <td>F</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-1</td>\n",
       "      <td>2013</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>2013-08-06</td>\n",
       "      <td>lunch</td>\n",
       "      <td>rice &amp; soup 1</td>\n",
       "      <td>A. 부대찌개정식</td>\n",
       "      <td>F</td>\n",
       "      <td>376</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-376</td>\n",
       "      <td>2013</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>2013-08-12</td>\n",
       "      <td>dinner</td>\n",
       "      <td>noodle bar</td>\n",
       "      <td>차슈라멘</td>\n",
       "      <td>F</td>\n",
       "      <td>179</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-179</td>\n",
       "      <td>2013</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6</td>\n",
       "      <td>2013-08-12</td>\n",
       "      <td>breakfast</td>\n",
       "      <td>rice &amp; soup 1</td>\n",
       "      <td>뚝배기순대국</td>\n",
       "      <td>F</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-26</td>\n",
       "      <td>2013</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>7</td>\n",
       "      <td>2013-08-12</td>\n",
       "      <td>lunch</td>\n",
       "      <td>rice &amp; soup 1</td>\n",
       "      <td>A:누룽지장각백숙</td>\n",
       "      <td>F</td>\n",
       "      <td>504</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-504</td>\n",
       "      <td>2013</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8</td>\n",
       "      <td>2013-08-12</td>\n",
       "      <td>lunch</td>\n",
       "      <td>noodle bar</td>\n",
       "      <td>유니자장면</td>\n",
       "      <td>F</td>\n",
       "      <td>167</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-167</td>\n",
       "      <td>2013</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>9</td>\n",
       "      <td>2013-08-12</td>\n",
       "      <td>dinner</td>\n",
       "      <td>rice &amp; soup 1</td>\n",
       "      <td>김치날치알밥</td>\n",
       "      <td>F</td>\n",
       "      <td>216</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-216</td>\n",
       "      <td>2013</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        date  dine_type         corner          menu is_sold_out  use_count  \\\n",
       "0 2013-08-06     dinner    grill & fry  훈제연어벤또(200개)           F        213   \n",
       "1 2013-08-06     dinner  rice & soup 1   뚝배기 우거지 갈비탕           F        261   \n",
       "2 2013-08-06      lunch     noodle bar         판모밀정식           F        267   \n",
       "3 2013-08-06  breakfast  rice & soup 1         설렁탕정식           F          1   \n",
       "4 2013-08-06      lunch  rice & soup 1     A. 부대찌개정식           F        376   \n",
       "5 2013-08-12     dinner     noodle bar          차슈라멘           F        179   \n",
       "6 2013-08-12  breakfast  rice & soup 1        뚝배기순대국           F         26   \n",
       "7 2013-08-12      lunch  rice & soup 1     A:누룽지장각백숙           F        504   \n",
       "8 2013-08-12      lunch     noodle bar         유니자장면           F        167   \n",
       "9 2013-08-12     dinner  rice & soup 1        김치날치알밥           F        216   \n",
       "\n",
       "   pred_count  additional  good  ok  bad  diff_use_pred  year  month  day  \\\n",
       "0           0           0     0   0    0           -213  2013      8    6   \n",
       "1           0           0     0   0    0           -261  2013      8    6   \n",
       "2           0           0     0   0    0           -267  2013      8    6   \n",
       "3           0           0     0   0    0             -1  2013      8    6   \n",
       "4           0           0     0   0    0           -376  2013      8    6   \n",
       "5           0           0     0   0    0           -179  2013      8   12   \n",
       "6           0           0     0   0    0            -26  2013      8   12   \n",
       "7           0           0     0   0    0           -504  2013      8   12   \n",
       "8           0           0     0   0    0           -167  2013      8   12   \n",
       "9           0           0     0   0    0           -216  2013      8   12   \n",
       "\n",
       "   wday  \n",
       "0     1  \n",
       "1     1  \n",
       "2     1  \n",
       "3     1  \n",
       "4     1  \n",
       "5     0  \n",
       "6     0  \n",
       "7     0  \n",
       "8     0  \n",
       "9     0  "
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 상위 10개 데이터 확인하기\n",
    "data.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>use_count</th>\n",
       "      <th>pred_count</th>\n",
       "      <th>additional</th>\n",
       "      <th>good</th>\n",
       "      <th>ok</th>\n",
       "      <th>bad</th>\n",
       "      <th>diff_use_pred</th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>wday</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>count</td>\n",
       "      <td>6825.000000</td>\n",
       "      <td>6825.000000</td>\n",
       "      <td>6825.000000</td>\n",
       "      <td>6825.000000</td>\n",
       "      <td>6825.000000</td>\n",
       "      <td>6825.000000</td>\n",
       "      <td>6825.000000</td>\n",
       "      <td>6825.000000</td>\n",
       "      <td>6825.000000</td>\n",
       "      <td>6825.000000</td>\n",
       "      <td>6825.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>mean</td>\n",
       "      <td>189.974652</td>\n",
       "      <td>72.377582</td>\n",
       "      <td>8.569963</td>\n",
       "      <td>6.894799</td>\n",
       "      <td>3.179048</td>\n",
       "      <td>0.792088</td>\n",
       "      <td>-109.027106</td>\n",
       "      <td>2014.116484</td>\n",
       "      <td>6.469011</td>\n",
       "      <td>16.056264</td>\n",
       "      <td>1.938168</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>std</td>\n",
       "      <td>118.012211</td>\n",
       "      <td>99.659671</td>\n",
       "      <td>13.765606</td>\n",
       "      <td>22.679150</td>\n",
       "      <td>10.652367</td>\n",
       "      <td>3.202065</td>\n",
       "      <td>152.218334</td>\n",
       "      <td>0.682471</td>\n",
       "      <td>3.474275</td>\n",
       "      <td>8.656009</td>\n",
       "      <td>1.411304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>min</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-787.000000</td>\n",
       "      <td>2013.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>25%</td>\n",
       "      <td>101.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-206.000000</td>\n",
       "      <td>2014.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>50%</td>\n",
       "      <td>175.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-58.000000</td>\n",
       "      <td>2014.000000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>75%</td>\n",
       "      <td>259.000000</td>\n",
       "      <td>130.000000</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>2015.000000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>24.000000</td>\n",
       "      <td>3.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>max</td>\n",
       "      <td>814.000000</td>\n",
       "      <td>720.000000</td>\n",
       "      <td>110.000000</td>\n",
       "      <td>198.000000</td>\n",
       "      <td>99.000000</td>\n",
       "      <td>52.000000</td>\n",
       "      <td>434.000000</td>\n",
       "      <td>2015.000000</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>31.000000</td>\n",
       "      <td>4.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         use_count   pred_count   additional         good           ok  \\\n",
       "count  6825.000000  6825.000000  6825.000000  6825.000000  6825.000000   \n",
       "mean    189.974652    72.377582     8.569963     6.894799     3.179048   \n",
       "std     118.012211    99.659671    13.765606    22.679150    10.652367   \n",
       "min       1.000000     0.000000     0.000000     0.000000     0.000000   \n",
       "25%     101.000000     0.000000     0.000000     0.000000     0.000000   \n",
       "50%     175.000000     0.000000     0.000000     0.000000     0.000000   \n",
       "75%     259.000000   130.000000    20.000000     0.000000     0.000000   \n",
       "max     814.000000   720.000000   110.000000   198.000000    99.000000   \n",
       "\n",
       "               bad  diff_use_pred         year        month          day  \\\n",
       "count  6825.000000    6825.000000  6825.000000  6825.000000  6825.000000   \n",
       "mean      0.792088    -109.027106  2014.116484     6.469011    16.056264   \n",
       "std       3.202065     152.218334     0.682471     3.474275     8.656009   \n",
       "min       0.000000    -787.000000  2013.000000     1.000000     1.000000   \n",
       "25%       0.000000    -206.000000  2014.000000     3.000000     9.000000   \n",
       "50%       0.000000     -58.000000  2014.000000     6.000000    16.000000   \n",
       "75%       0.000000      10.000000  2015.000000    10.000000    24.000000   \n",
       "max      52.000000     434.000000  2015.000000    12.000000    31.000000   \n",
       "\n",
       "              wday  \n",
       "count  6825.000000  \n",
       "mean      1.938168  \n",
       "std       1.411304  \n",
       "min       0.000000  \n",
       "25%       1.000000  \n",
       "50%       2.000000  \n",
       "75%       3.000000  \n",
       "max       4.000000  "
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 데이터프레임 요약 통계 \n",
    "data.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 6825 entries, 0 to 6824\n",
      "Data columns (total 16 columns):\n",
      "date             6825 non-null datetime64[ns]\n",
      "dine_type        6825 non-null object\n",
      "corner           6825 non-null object\n",
      "menu             6825 non-null object\n",
      "is_sold_out      6825 non-null object\n",
      "use_count        6825 non-null int64\n",
      "pred_count       6825 non-null int64\n",
      "additional       6825 non-null int64\n",
      "good             6825 non-null int64\n",
      "ok               6825 non-null int64\n",
      "bad              6825 non-null int64\n",
      "diff_use_pred    6825 non-null int64\n",
      "year             6825 non-null int64\n",
      "month            6825 non-null int64\n",
      "day              6825 non-null int64\n",
      "wday             6825 non-null int64\n",
      "dtypes: datetime64[ns](1), int64(11), object(4)\n",
      "memory usage: 853.2+ KB\n"
     ]
    }
   ],
   "source": [
    "data.info() # dtypes와 다르게 null 인지 아닌지도 ... 더 자주 씀"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "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>dine_type</th>\n",
       "      <th>corner</th>\n",
       "      <th>menu</th>\n",
       "      <th>is_sold_out</th>\n",
       "      <th>use_count</th>\n",
       "      <th>pred_count</th>\n",
       "      <th>additional</th>\n",
       "      <th>good</th>\n",
       "      <th>ok</th>\n",
       "      <th>bad</th>\n",
       "      <th>diff_use_pred</th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>wday</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2013-08-06</td>\n",
       "      <td>dinner</td>\n",
       "      <td>grill &amp; fry</td>\n",
       "      <td>훈제연어벤또(200개)</td>\n",
       "      <td>F</td>\n",
       "      <td>213</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-213</td>\n",
       "      <td>2013</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-08-06</td>\n",
       "      <td>dinner</td>\n",
       "      <td>rice &amp; soup 1</td>\n",
       "      <td>뚝배기 우거지 갈비탕</td>\n",
       "      <td>F</td>\n",
       "      <td>261</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-261</td>\n",
       "      <td>2013</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-08-06</td>\n",
       "      <td>lunch</td>\n",
       "      <td>noodle bar</td>\n",
       "      <td>판모밀정식</td>\n",
       "      <td>F</td>\n",
       "      <td>267</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-267</td>\n",
       "      <td>2013</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-08-06</td>\n",
       "      <td>breakfast</td>\n",
       "      <td>rice &amp; soup 1</td>\n",
       "      <td>설렁탕정식</td>\n",
       "      <td>F</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-1</td>\n",
       "      <td>2013</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-08-06</td>\n",
       "      <td>lunch</td>\n",
       "      <td>rice &amp; soup 1</td>\n",
       "      <td>A. 부대찌개정식</td>\n",
       "      <td>F</td>\n",
       "      <td>376</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-376</td>\n",
       "      <td>2013</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-07-27</td>\n",
       "      <td>lunch</td>\n",
       "      <td>grill &amp; fry</td>\n",
       "      <td>돼지고기채소비빔밥</td>\n",
       "      <td>F</td>\n",
       "      <td>268</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-268</td>\n",
       "      <td>2015</td>\n",
       "      <td>7</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-07-27</td>\n",
       "      <td>lunch</td>\n",
       "      <td>rice &amp; soup 2</td>\n",
       "      <td>생오리고추장불고기&amp;부추생채</td>\n",
       "      <td>F</td>\n",
       "      <td>264</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-264</td>\n",
       "      <td>2015</td>\n",
       "      <td>7</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-07-27</td>\n",
       "      <td>breakfast</td>\n",
       "      <td>take out</td>\n",
       "      <td>샌드위치콤보&amp;음료&amp;과일</td>\n",
       "      <td>F</td>\n",
       "      <td>58</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-58</td>\n",
       "      <td>2015</td>\n",
       "      <td>7</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-07-27</td>\n",
       "      <td>lunch</td>\n",
       "      <td>noodle bar</td>\n",
       "      <td>김치비빔국수</td>\n",
       "      <td>F</td>\n",
       "      <td>202</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-202</td>\n",
       "      <td>2015</td>\n",
       "      <td>7</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-07-27</td>\n",
       "      <td>lunch</td>\n",
       "      <td>take out</td>\n",
       "      <td>닭가슴살크랜베리샐러드</td>\n",
       "      <td>F</td>\n",
       "      <td>304</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-304</td>\n",
       "      <td>2015</td>\n",
       "      <td>7</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6825 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            dine_type         corner            menu is_sold_out  use_count  \\\n",
       "date                                                                          \n",
       "2013-08-06     dinner    grill & fry    훈제연어벤또(200개)           F        213   \n",
       "2013-08-06     dinner  rice & soup 1     뚝배기 우거지 갈비탕           F        261   \n",
       "2013-08-06      lunch     noodle bar           판모밀정식           F        267   \n",
       "2013-08-06  breakfast  rice & soup 1           설렁탕정식           F          1   \n",
       "2013-08-06      lunch  rice & soup 1       A. 부대찌개정식           F        376   \n",
       "...               ...            ...             ...         ...        ...   \n",
       "2015-07-27      lunch    grill & fry       돼지고기채소비빔밥           F        268   \n",
       "2015-07-27      lunch  rice & soup 2  생오리고추장불고기&부추생채           F        264   \n",
       "2015-07-27  breakfast       take out    샌드위치콤보&음료&과일           F         58   \n",
       "2015-07-27      lunch     noodle bar          김치비빔국수           F        202   \n",
       "2015-07-27      lunch       take out     닭가슴살크랜베리샐러드           F        304   \n",
       "\n",
       "            pred_count  additional  good  ok  bad  diff_use_pred  year  month  \\\n",
       "date                                                                            \n",
       "2013-08-06           0           0     0   0    0           -213  2013      8   \n",
       "2013-08-06           0           0     0   0    0           -261  2013      8   \n",
       "2013-08-06           0           0     0   0    0           -267  2013      8   \n",
       "2013-08-06           0           0     0   0    0             -1  2013      8   \n",
       "2013-08-06           0           0     0   0    0           -376  2013      8   \n",
       "...                ...         ...   ...  ..  ...            ...   ...    ...   \n",
       "2015-07-27           0           0     0   0    0           -268  2015      7   \n",
       "2015-07-27           0           0     0   0    0           -264  2015      7   \n",
       "2015-07-27           0           0     0   0    0            -58  2015      7   \n",
       "2015-07-27           0           0     0   0    0           -202  2015      7   \n",
       "2015-07-27           0           0     0   0    0           -304  2015      7   \n",
       "\n",
       "            day  wday  \n",
       "date                   \n",
       "2013-08-06    6     1  \n",
       "2013-08-06    6     1  \n",
       "2013-08-06    6     1  \n",
       "2013-08-06    6     1  \n",
       "2013-08-06    6     1  \n",
       "...         ...   ...  \n",
       "2015-07-27   27     0  \n",
       "2015-07-27   27     0  \n",
       "2015-07-27   27     0  \n",
       "2015-07-27   27     0  \n",
       "2015-07-27   27     0  \n",
       "\n",
       "[6825 rows x 15 columns]"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# date index 설정하기\n",
    "# data.set_index('date', inplace = True)\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "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>dine_type</th>\n",
       "      <th>corner</th>\n",
       "      <th>menu</th>\n",
       "      <th>is_sold_out</th>\n",
       "      <th>use_count</th>\n",
       "      <th>pred_count</th>\n",
       "      <th>additional</th>\n",
       "      <th>good</th>\n",
       "      <th>ok</th>\n",
       "      <th>bad</th>\n",
       "      <th>diff_use_pred</th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>wday</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2014-01-02</td>\n",
       "      <td>breakfast</td>\n",
       "      <td>take out</td>\n",
       "      <td>쿡살라미샌드위치</td>\n",
       "      <td>F</td>\n",
       "      <td>51</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-51</td>\n",
       "      <td>2014</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-01-02</td>\n",
       "      <td>dinner</td>\n",
       "      <td>noodle bar</td>\n",
       "      <td>오징어비빔국수</td>\n",
       "      <td>F</td>\n",
       "      <td>111</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-111</td>\n",
       "      <td>2014</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-01-02</td>\n",
       "      <td>dinner</td>\n",
       "      <td>take out</td>\n",
       "      <td>날치알캘리포니아롤</td>\n",
       "      <td>F</td>\n",
       "      <td>386</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-386</td>\n",
       "      <td>2014</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-01-02</td>\n",
       "      <td>lunch</td>\n",
       "      <td>burger&amp;pizza</td>\n",
       "      <td>갈릭오일파스타</td>\n",
       "      <td>T</td>\n",
       "      <td>142</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-142</td>\n",
       "      <td>2014</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-01-02</td>\n",
       "      <td>dinner</td>\n",
       "      <td>burger&amp;pizza</td>\n",
       "      <td>참치김치그라탕</td>\n",
       "      <td>T</td>\n",
       "      <td>151</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-151</td>\n",
       "      <td>2014</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>lunch</td>\n",
       "      <td>noodle bar</td>\n",
       "      <td>짬뽕&amp;탕수육</td>\n",
       "      <td>F</td>\n",
       "      <td>152</td>\n",
       "      <td>160</td>\n",
       "      <td>60</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>68</td>\n",
       "      <td>2014</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>lunch</td>\n",
       "      <td>take out</td>\n",
       "      <td>연어레몬샐러드</td>\n",
       "      <td>F</td>\n",
       "      <td>124</td>\n",
       "      <td>170</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>46</td>\n",
       "      <td>2014</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>dinner</td>\n",
       "      <td>after school</td>\n",
       "      <td>얼큰김치라면&amp;계란말이</td>\n",
       "      <td>F</td>\n",
       "      <td>2</td>\n",
       "      <td>80</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>108</td>\n",
       "      <td>2014</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>breakfast</td>\n",
       "      <td>rice &amp; soup 1</td>\n",
       "      <td>북어국&amp;떡갈비엿장구이</td>\n",
       "      <td>F</td>\n",
       "      <td>38</td>\n",
       "      <td>30</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>2014</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>dinner</td>\n",
       "      <td>rice &amp; soup 1</td>\n",
       "      <td>설렁탕</td>\n",
       "      <td>F</td>\n",
       "      <td>28</td>\n",
       "      <td>220</td>\n",
       "      <td>60</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>252</td>\n",
       "      <td>2014</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3554 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            dine_type         corner         menu is_sold_out  use_count  \\\n",
       "date                                                                       \n",
       "2014-01-02  breakfast       take out     쿡살라미샌드위치           F         51   \n",
       "2014-01-02     dinner     noodle bar      오징어비빔국수           F        111   \n",
       "2014-01-02     dinner       take out    날치알캘리포니아롤           F        386   \n",
       "2014-01-02      lunch   burger&pizza      갈릭오일파스타           T        142   \n",
       "2014-01-02     dinner   burger&pizza      참치김치그라탕           T        151   \n",
       "...               ...            ...          ...         ...        ...   \n",
       "2014-12-31      lunch     noodle bar       짬뽕&탕수육           F        152   \n",
       "2014-12-31      lunch       take out      연어레몬샐러드           F        124   \n",
       "2014-12-31     dinner   after school  얼큰김치라면&계란말이           F          2   \n",
       "2014-12-31  breakfast  rice & soup 1  북어국&떡갈비엿장구이           F         38   \n",
       "2014-12-31     dinner  rice & soup 1          설렁탕           F         28   \n",
       "\n",
       "            pred_count  additional  good  ok  bad  diff_use_pred  year  month  \\\n",
       "date                                                                            \n",
       "2014-01-02           0           0     0   0    0            -51  2014      1   \n",
       "2014-01-02           0           0     0   0    0           -111  2014      1   \n",
       "2014-01-02           0           0     0   0    0           -386  2014      1   \n",
       "2014-01-02           0           0     0   0    0           -142  2014      1   \n",
       "2014-01-02           0           0     0   0    0           -151  2014      1   \n",
       "...                ...         ...   ...  ..  ...            ...   ...    ...   \n",
       "2014-12-31         160          60     0   0    0             68  2014     12   \n",
       "2014-12-31         170           0     0   0    0             46  2014     12   \n",
       "2014-12-31          80          30     0   0    0            108  2014     12   \n",
       "2014-12-31          30          20     0   0    0             12  2014     12   \n",
       "2014-12-31         220          60     0   0    0            252  2014     12   \n",
       "\n",
       "            day  wday  \n",
       "date                   \n",
       "2014-01-02    2     3  \n",
       "2014-01-02    2     3  \n",
       "2014-01-02    2     3  \n",
       "2014-01-02    2     3  \n",
       "2014-01-02    2     3  \n",
       "...         ...   ...  \n",
       "2014-12-31   31     2  \n",
       "2014-12-31   31     2  \n",
       "2014-12-31   31     2  \n",
       "2014-12-31   31     2  \n",
       "2014-12-31   31     2  \n",
       "\n",
       "[3554 rows x 15 columns]"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 2014년 데이터만 불러오기\n",
    "data['2014']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>dine_type</th>\n",
       "      <th>corner</th>\n",
       "      <th>menu</th>\n",
       "      <th>is_sold_out</th>\n",
       "      <th>use_count</th>\n",
       "      <th>pred_count</th>\n",
       "      <th>additional</th>\n",
       "      <th>good</th>\n",
       "      <th>ok</th>\n",
       "      <th>bad</th>\n",
       "      <th>diff_use_pred</th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>wday</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2015-01-02</td>\n",
       "      <td>dinner</td>\n",
       "      <td>after school</td>\n",
       "      <td>참깨라면&amp;볶음김치김밥</td>\n",
       "      <td>F</td>\n",
       "      <td>39</td>\n",
       "      <td>80</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>51</td>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-01-02</td>\n",
       "      <td>lunch</td>\n",
       "      <td>after school</td>\n",
       "      <td>오징어김치볶음밥&amp;계란후라이</td>\n",
       "      <td>F</td>\n",
       "      <td>158</td>\n",
       "      <td>170</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-01-02</td>\n",
       "      <td>breakfast</td>\n",
       "      <td>rice &amp; soup 1</td>\n",
       "      <td>감자호박국&amp;소고기야채볶음</td>\n",
       "      <td>F</td>\n",
       "      <td>35</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-5</td>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-01-02</td>\n",
       "      <td>lunch</td>\n",
       "      <td>rice &amp; soup 1</td>\n",
       "      <td>청국장찌개&amp;돼지고기고추장볶음</td>\n",
       "      <td>F</td>\n",
       "      <td>235</td>\n",
       "      <td>380</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>195</td>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-01-02</td>\n",
       "      <td>lunch</td>\n",
       "      <td>noodle bar</td>\n",
       "      <td>자장면&amp;김치만두찜</td>\n",
       "      <td>F</td>\n",
       "      <td>218</td>\n",
       "      <td>230</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-01-30</td>\n",
       "      <td>dinner</td>\n",
       "      <td>burger&amp;pizza</td>\n",
       "      <td>퀘사디아&amp;카레볶음밥</td>\n",
       "      <td>F</td>\n",
       "      <td>36</td>\n",
       "      <td>70</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>44</td>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-01-30</td>\n",
       "      <td>dinner</td>\n",
       "      <td>grill &amp; fry</td>\n",
       "      <td>추억의도시락비빔밥</td>\n",
       "      <td>F</td>\n",
       "      <td>139</td>\n",
       "      <td>120</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-01-30</td>\n",
       "      <td>breakfast</td>\n",
       "      <td>take out</td>\n",
       "      <td>샌드위치콤보&amp;음료&amp;과일</td>\n",
       "      <td>F</td>\n",
       "      <td>45</td>\n",
       "      <td>38</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-01-30</td>\n",
       "      <td>lunch</td>\n",
       "      <td>take out</td>\n",
       "      <td>훈제오리&amp;단호박샐러드</td>\n",
       "      <td>F</td>\n",
       "      <td>265</td>\n",
       "      <td>250</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-15</td>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-01-30</td>\n",
       "      <td>dinner</td>\n",
       "      <td>rice &amp; soup 1</td>\n",
       "      <td>비지찌개&amp;깻잎고기전</td>\n",
       "      <td>F</td>\n",
       "      <td>145</td>\n",
       "      <td>130</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>306 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            dine_type         corner             menu is_sold_out  use_count  \\\n",
       "date                                                                           \n",
       "2015-01-02     dinner   after school      참깨라면&볶음김치김밥           F         39   \n",
       "2015-01-02      lunch   after school   오징어김치볶음밥&계란후라이           F        158   \n",
       "2015-01-02  breakfast  rice & soup 1    감자호박국&소고기야채볶음           F         35   \n",
       "2015-01-02      lunch  rice & soup 1  청국장찌개&돼지고기고추장볶음           F        235   \n",
       "2015-01-02      lunch     noodle bar        자장면&김치만두찜           F        218   \n",
       "...               ...            ...              ...         ...        ...   \n",
       "2015-01-30     dinner   burger&pizza       퀘사디아&카레볶음밥           F         36   \n",
       "2015-01-30     dinner    grill & fry        추억의도시락비빔밥           F        139   \n",
       "2015-01-30  breakfast       take out     샌드위치콤보&음료&과일           F         45   \n",
       "2015-01-30      lunch       take out      훈제오리&단호박샐러드           F        265   \n",
       "2015-01-30     dinner  rice & soup 1       비지찌개&깻잎고기전           F        145   \n",
       "\n",
       "            pred_count  additional  good  ok  bad  diff_use_pred  year  month  \\\n",
       "date                                                                            \n",
       "2015-01-02          80          10     0   0    0             51  2015      1   \n",
       "2015-01-02         170          40     0   0    0             52  2015      1   \n",
       "2015-01-02          20          10     0   0    0             -5  2015      1   \n",
       "2015-01-02         380          50     0   0    0            195  2015      1   \n",
       "2015-01-02         230          40     0   0    0             52  2015      1   \n",
       "...                ...         ...   ...  ..  ...            ...   ...    ...   \n",
       "2015-01-30          70          10     0   0    0             44  2015      1   \n",
       "2015-01-30         120          30     0   0    0             11  2015      1   \n",
       "2015-01-30          38          20     0   0    0             13  2015      1   \n",
       "2015-01-30         250           0     0   0    0            -15  2015      1   \n",
       "2015-01-30         130          30     0   0    0             15  2015      1   \n",
       "\n",
       "            day  wday  \n",
       "date                   \n",
       "2015-01-02    2     4  \n",
       "2015-01-02    2     4  \n",
       "2015-01-02    2     4  \n",
       "2015-01-02    2     4  \n",
       "2015-01-02    2     4  \n",
       "...         ...   ...  \n",
       "2015-01-30   30     4  \n",
       "2015-01-30   30     4  \n",
       "2015-01-30   30     4  \n",
       "2015-01-30   30     4  \n",
       "2015-01-30   30     4  \n",
       "\n",
       "[306 rows x 15 columns]"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 2015년 1월 데이터 불러오기\n",
    "data['2015-01']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "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>dine_type</th>\n",
       "      <th>corner</th>\n",
       "      <th>menu</th>\n",
       "      <th>is_sold_out</th>\n",
       "      <th>use_count</th>\n",
       "      <th>pred_count</th>\n",
       "      <th>additional</th>\n",
       "      <th>good</th>\n",
       "      <th>ok</th>\n",
       "      <th>bad</th>\n",
       "      <th>diff_use_pred</th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>wday</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2014-08-01</td>\n",
       "      <td>dinner</td>\n",
       "      <td>after school</td>\n",
       "      <td>햄모듬라면&amp;콩도너츠</td>\n",
       "      <td>F</td>\n",
       "      <td>137</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-137</td>\n",
       "      <td>2014</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-08-01</td>\n",
       "      <td>lunch</td>\n",
       "      <td>after school</td>\n",
       "      <td>카레라면&amp;비빔채소만두</td>\n",
       "      <td>T</td>\n",
       "      <td>129</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-129</td>\n",
       "      <td>2014</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-08-01</td>\n",
       "      <td>dinner</td>\n",
       "      <td>grill &amp; fry</td>\n",
       "      <td>취나물밥&amp;양념장</td>\n",
       "      <td>F</td>\n",
       "      <td>68</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-68</td>\n",
       "      <td>2014</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-08-01</td>\n",
       "      <td>breakfast</td>\n",
       "      <td>take out</td>\n",
       "      <td>7곡빵샌드위치</td>\n",
       "      <td>F</td>\n",
       "      <td>39</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-39</td>\n",
       "      <td>2014</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-08-01</td>\n",
       "      <td>lunch</td>\n",
       "      <td>grill &amp; fry</td>\n",
       "      <td>더덕비빔밥</td>\n",
       "      <td>F</td>\n",
       "      <td>158</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-158</td>\n",
       "      <td>2014</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-09-25</td>\n",
       "      <td>lunch</td>\n",
       "      <td>rice &amp; soup 2</td>\n",
       "      <td>돼지고기고추장깻잎볶음</td>\n",
       "      <td>F</td>\n",
       "      <td>246</td>\n",
       "      <td>330</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>124</td>\n",
       "      <td>2014</td>\n",
       "      <td>9</td>\n",
       "      <td>25</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-09-25</td>\n",
       "      <td>lunch</td>\n",
       "      <td>grill &amp; fry</td>\n",
       "      <td>왕새우&amp;카레라이스</td>\n",
       "      <td>F</td>\n",
       "      <td>321</td>\n",
       "      <td>350</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>79</td>\n",
       "      <td>2014</td>\n",
       "      <td>9</td>\n",
       "      <td>25</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-09-25</td>\n",
       "      <td>dinner</td>\n",
       "      <td>grill &amp; fry</td>\n",
       "      <td>황해도식해주비빔밥</td>\n",
       "      <td>F</td>\n",
       "      <td>87</td>\n",
       "      <td>140</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>68</td>\n",
       "      <td>2014</td>\n",
       "      <td>9</td>\n",
       "      <td>25</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-09-25</td>\n",
       "      <td>breakfast</td>\n",
       "      <td>take out</td>\n",
       "      <td>샌드위치</td>\n",
       "      <td>F</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-30</td>\n",
       "      <td>2014</td>\n",
       "      <td>9</td>\n",
       "      <td>25</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2014-09-25</td>\n",
       "      <td>lunch</td>\n",
       "      <td>take out</td>\n",
       "      <td>콥샐러드</td>\n",
       "      <td>F</td>\n",
       "      <td>275</td>\n",
       "      <td>240</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-35</td>\n",
       "      <td>2014</td>\n",
       "      <td>9</td>\n",
       "      <td>25</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>537 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            dine_type         corner         menu is_sold_out  use_count  \\\n",
       "date                                                                       \n",
       "2014-08-01     dinner   after school   햄모듬라면&콩도너츠           F        137   \n",
       "2014-08-01      lunch   after school  카레라면&비빔채소만두           T        129   \n",
       "2014-08-01     dinner    grill & fry     취나물밥&양념장           F         68   \n",
       "2014-08-01  breakfast       take out      7곡빵샌드위치           F         39   \n",
       "2014-08-01      lunch    grill & fry        더덕비빔밥           F        158   \n",
       "...               ...            ...          ...         ...        ...   \n",
       "2014-09-25      lunch  rice & soup 2  돼지고기고추장깻잎볶음           F        246   \n",
       "2014-09-25      lunch    grill & fry    왕새우&카레라이스           F        321   \n",
       "2014-09-25     dinner    grill & fry    황해도식해주비빔밥           F         87   \n",
       "2014-09-25  breakfast       take out         샌드위치           F         30   \n",
       "2014-09-25      lunch       take out         콥샐러드           F        275   \n",
       "\n",
       "            pred_count  additional  good  ok  bad  diff_use_pred  year  month  \\\n",
       "date                                                                            \n",
       "2014-08-01           0           0     0   0    0           -137  2014      8   \n",
       "2014-08-01           0           0     0   0    0           -129  2014      8   \n",
       "2014-08-01           0           0     0   0    0            -68  2014      8   \n",
       "2014-08-01           0           0     0   0    0            -39  2014      8   \n",
       "2014-08-01           0           0     0   0    0           -158  2014      8   \n",
       "...                ...         ...   ...  ..  ...            ...   ...    ...   \n",
       "2014-09-25         330          40     0   0    0            124  2014      9   \n",
       "2014-09-25         350          50     0   0    0             79  2014      9   \n",
       "2014-09-25         140          15     0   0    0             68  2014      9   \n",
       "2014-09-25           0           0     0   0    0            -30  2014      9   \n",
       "2014-09-25         240           0     0   0    0            -35  2014      9   \n",
       "\n",
       "            day  wday  \n",
       "date                   \n",
       "2014-08-01    1     4  \n",
       "2014-08-01    1     4  \n",
       "2014-08-01    1     4  \n",
       "2014-08-01    1     4  \n",
       "2014-08-01    1     4  \n",
       "...         ...   ...  \n",
       "2014-09-25   25     3  \n",
       "2014-09-25   25     3  \n",
       "2014-09-25   25     3  \n",
       "2014-09-25   25     3  \n",
       "2014-09-25   25     3  \n",
       "\n",
       "[537 rows x 15 columns]"
      ]
     },
     "execution_count": 81,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 14년 8월 1일 부터 14년 9월 25일까지 데이터 불러오기\n",
    "# in R, [1:5] ...\n",
    "data['20140801' : '20140925']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>dine_type</th>\n",
       "      <th>corner</th>\n",
       "      <th>menu</th>\n",
       "      <th>is_sold_out</th>\n",
       "      <th>use_count</th>\n",
       "      <th>pred_count</th>\n",
       "      <th>additional</th>\n",
       "      <th>good</th>\n",
       "      <th>ok</th>\n",
       "      <th>bad</th>\n",
       "      <th>diff_use_pred</th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>wday</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>dinner</td>\n",
       "      <td>take out</td>\n",
       "      <td>비엔나소시지컵밥</td>\n",
       "      <td>F</td>\n",
       "      <td>116</td>\n",
       "      <td>110</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>2015</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>lunch</td>\n",
       "      <td>take out</td>\n",
       "      <td>콥샐러드</td>\n",
       "      <td>F</td>\n",
       "      <td>281</td>\n",
       "      <td>300</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>2015</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>lunch</td>\n",
       "      <td>rice &amp; soup 1</td>\n",
       "      <td>감자탕</td>\n",
       "      <td>F</td>\n",
       "      <td>230</td>\n",
       "      <td>250</td>\n",
       "      <td>10</td>\n",
       "      <td>63</td>\n",
       "      <td>46</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>2015</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>lunch</td>\n",
       "      <td>after school</td>\n",
       "      <td>짜파게티</td>\n",
       "      <td>F</td>\n",
       "      <td>147</td>\n",
       "      <td>190</td>\n",
       "      <td>0</td>\n",
       "      <td>85</td>\n",
       "      <td>21</td>\n",
       "      <td>2</td>\n",
       "      <td>43</td>\n",
       "      <td>2015</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>lunch</td>\n",
       "      <td>burger&amp;pizza</td>\n",
       "      <td>콤비네이션피자</td>\n",
       "      <td>F</td>\n",
       "      <td>93</td>\n",
       "      <td>140</td>\n",
       "      <td>0</td>\n",
       "      <td>44</td>\n",
       "      <td>15</td>\n",
       "      <td>3</td>\n",
       "      <td>47</td>\n",
       "      <td>2015</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>dinner</td>\n",
       "      <td>grill &amp; fry</td>\n",
       "      <td>불고기채소비빔밥</td>\n",
       "      <td>F</td>\n",
       "      <td>145</td>\n",
       "      <td>200</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "      <td>55</td>\n",
       "      <td>2015</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>breakfast</td>\n",
       "      <td>take out</td>\n",
       "      <td>샌드위치콤보&amp;음료&amp;과일</td>\n",
       "      <td>F</td>\n",
       "      <td>60</td>\n",
       "      <td>40</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>-10</td>\n",
       "      <td>2015</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>dinner</td>\n",
       "      <td>after school</td>\n",
       "      <td>햄모둠라면</td>\n",
       "      <td>T</td>\n",
       "      <td>113</td>\n",
       "      <td>100</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "      <td>16</td>\n",
       "      <td>3</td>\n",
       "      <td>-3</td>\n",
       "      <td>2015</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>dinner</td>\n",
       "      <td>burger&amp;pizza</td>\n",
       "      <td>왕소시지김치그라탕</td>\n",
       "      <td>F</td>\n",
       "      <td>82</td>\n",
       "      <td>110</td>\n",
       "      <td>10</td>\n",
       "      <td>14</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>38</td>\n",
       "      <td>2015</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>breakfast</td>\n",
       "      <td>rice &amp; soup 1</td>\n",
       "      <td>감자계란국*청량고추</td>\n",
       "      <td>F</td>\n",
       "      <td>68</td>\n",
       "      <td>60</td>\n",
       "      <td>10</td>\n",
       "      <td>21</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2015</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>lunch</td>\n",
       "      <td>rice &amp; soup 2</td>\n",
       "      <td>생오리고추장불고기</td>\n",
       "      <td>F</td>\n",
       "      <td>227</td>\n",
       "      <td>250</td>\n",
       "      <td>30</td>\n",
       "      <td>107</td>\n",
       "      <td>34</td>\n",
       "      <td>8</td>\n",
       "      <td>53</td>\n",
       "      <td>2015</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>lunch</td>\n",
       "      <td>noodle bar</td>\n",
       "      <td>황태짬뽕</td>\n",
       "      <td>F</td>\n",
       "      <td>225</td>\n",
       "      <td>280</td>\n",
       "      <td>20</td>\n",
       "      <td>87</td>\n",
       "      <td>51</td>\n",
       "      <td>20</td>\n",
       "      <td>75</td>\n",
       "      <td>2015</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>lunch</td>\n",
       "      <td>grill &amp; fry</td>\n",
       "      <td>오므라이스&amp;치킨텐더</td>\n",
       "      <td>F</td>\n",
       "      <td>234</td>\n",
       "      <td>260</td>\n",
       "      <td>20</td>\n",
       "      <td>75</td>\n",
       "      <td>48</td>\n",
       "      <td>18</td>\n",
       "      <td>46</td>\n",
       "      <td>2015</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>dinner</td>\n",
       "      <td>rice &amp; soup 1</td>\n",
       "      <td>(뚝)감자고추장찌개</td>\n",
       "      <td>F</td>\n",
       "      <td>147</td>\n",
       "      <td>190</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>16</td>\n",
       "      <td>2</td>\n",
       "      <td>43</td>\n",
       "      <td>2015</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>dinner</td>\n",
       "      <td>noodle bar</td>\n",
       "      <td>돼지갈비찜</td>\n",
       "      <td>F</td>\n",
       "      <td>96</td>\n",
       "      <td>100</td>\n",
       "      <td>10</td>\n",
       "      <td>21</td>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "      <td>14</td>\n",
       "      <td>2015</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            dine_type         corner          menu is_sold_out  use_count  \\\n",
       "date                                                                        \n",
       "2015-06-30     dinner       take out      비엔나소시지컵밥           F        116   \n",
       "2015-06-30      lunch       take out          콥샐러드           F        281   \n",
       "2015-06-30      lunch  rice & soup 1           감자탕           F        230   \n",
       "2015-06-30      lunch   after school          짜파게티           F        147   \n",
       "2015-06-30      lunch   burger&pizza       콤비네이션피자           F         93   \n",
       "2015-06-30     dinner    grill & fry      불고기채소비빔밥           F        145   \n",
       "2015-06-30  breakfast       take out  샌드위치콤보&음료&과일           F         60   \n",
       "2015-06-30     dinner   after school         햄모둠라면           T        113   \n",
       "2015-06-30     dinner   burger&pizza     왕소시지김치그라탕           F         82   \n",
       "2015-06-30  breakfast  rice & soup 1    감자계란국*청량고추           F         68   \n",
       "2015-06-30      lunch  rice & soup 2     생오리고추장불고기           F        227   \n",
       "2015-06-30      lunch     noodle bar          황태짬뽕           F        225   \n",
       "2015-06-30      lunch    grill & fry    오므라이스&치킨텐더           F        234   \n",
       "2015-06-30     dinner  rice & soup 1    (뚝)감자고추장찌개           F        147   \n",
       "2015-06-30     dinner     noodle bar         돼지갈비찜           F         96   \n",
       "\n",
       "            pred_count  additional  good  ok  bad  diff_use_pred  year  month  \\\n",
       "date                                                                            \n",
       "2015-06-30         110          10     0   0    0              4  2015      6   \n",
       "2015-06-30         300           0     3   0    0             19  2015      6   \n",
       "2015-06-30         250          10    63  46   30             30  2015      6   \n",
       "2015-06-30         190           0    85  21    2             43  2015      6   \n",
       "2015-06-30         140           0    44  15    3             47  2015      6   \n",
       "2015-06-30         200           0    31  11    2             55  2015      6   \n",
       "2015-06-30          40          10     0   1    0            -10  2015      6   \n",
       "2015-06-30         100          10    20  16    3             -3  2015      6   \n",
       "2015-06-30         110          10    14  12    2             38  2015      6   \n",
       "2015-06-30          60          10    21   4    2              2  2015      6   \n",
       "2015-06-30         250          30   107  34    8             53  2015      6   \n",
       "2015-06-30         280          20    87  51   20             75  2015      6   \n",
       "2015-06-30         260          20    75  48   18             46  2015      6   \n",
       "2015-06-30         190           0    20  16    2             43  2015      6   \n",
       "2015-06-30         100          10    21  11    2             14  2015      6   \n",
       "\n",
       "            day  wday  \n",
       "date                   \n",
       "2015-06-30   30     1  \n",
       "2015-06-30   30     1  \n",
       "2015-06-30   30     1  \n",
       "2015-06-30   30     1  \n",
       "2015-06-30   30     1  \n",
       "2015-06-30   30     1  \n",
       "2015-06-30   30     1  \n",
       "2015-06-30   30     1  \n",
       "2015-06-30   30     1  \n",
       "2015-06-30   30     1  \n",
       "2015-06-30   30     1  \n",
       "2015-06-30   30     1  \n",
       "2015-06-30   30     1  \n",
       "2015-06-30   30     1  \n",
       "2015-06-30   30     1  "
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 2015년 6월 30일 데이터 불러오기\n",
    "data.loc['2015-06-30']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timestamp('2013-08-06 00:00:00')"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# index 최소값\n",
    "data.index.min()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timestamp('2015-07-27 00:00:00')"
      ]
     },
     "execution_count": 85,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# index 최대값\n",
    "data.index.max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 월요일만 뽑아오기\n",
    "monday = pd.date_range(start = data.index.min(),\n",
    "                 end = data.index.max(),\n",
    "                 freq= 'W-MON')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[Timestamp('2013-08-12 00:00:00', freq='W-MON'),\n",
       " Timestamp('2013-08-19 00:00:00', freq='W-MON'),\n",
       " Timestamp('2013-08-26 00:00:00', freq='W-MON'),\n",
       " Timestamp('2013-09-02 00:00:00', freq='W-MON'),\n",
       " Timestamp('2013-09-09 00:00:00', freq='W-MON'),\n",
       " Timestamp('2013-09-16 00:00:00', freq='W-MON'),\n",
       " Timestamp('2013-09-23 00:00:00', freq='W-MON'),\n",
       " Timestamp('2013-09-30 00:00:00', freq='W-MON'),\n",
       " Timestamp('2013-10-07 00:00:00', freq='W-MON'),\n",
       " Timestamp('2013-10-14 00:00:00', freq='W-MON'),\n",
       " Timestamp('2013-10-21 00:00:00', freq='W-MON'),\n",
       " Timestamp('2013-10-28 00:00:00', freq='W-MON'),\n",
       " Timestamp('2013-11-04 00:00:00', freq='W-MON'),\n",
       " Timestamp('2013-11-11 00:00:00', freq='W-MON'),\n",
       " Timestamp('2013-11-18 00:00:00', freq='W-MON'),\n",
       " Timestamp('2013-11-25 00:00:00', freq='W-MON'),\n",
       " Timestamp('2013-12-02 00:00:00', freq='W-MON'),\n",
       " Timestamp('2013-12-09 00:00:00', freq='W-MON'),\n",
       " Timestamp('2013-12-16 00:00:00', freq='W-MON'),\n",
       " Timestamp('2013-12-23 00:00:00', freq='W-MON'),\n",
       " Timestamp('2013-12-30 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-01-06 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-01-13 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-01-20 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-01-27 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-02-03 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-02-10 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-02-17 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-02-24 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-03-03 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-03-10 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-03-17 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-03-24 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-03-31 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-04-07 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-04-14 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-04-21 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-04-28 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-05-05 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-05-12 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-05-19 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-05-26 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-06-02 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-06-09 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-06-16 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-06-23 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-06-30 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-07-07 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-07-14 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-07-21 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-07-28 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-08-04 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-08-11 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-08-18 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-08-25 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-09-01 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-09-08 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-09-15 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-09-22 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-09-29 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-10-06 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-10-13 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-10-20 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-10-27 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-11-03 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-11-10 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-11-17 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-11-24 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-12-01 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-12-08 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-12-15 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-12-22 00:00:00', freq='W-MON'),\n",
       " Timestamp('2014-12-29 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-01-05 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-01-12 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-01-19 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-01-26 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-02-02 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-02-09 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-02-16 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-02-23 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-03-02 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-03-09 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-03-16 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-03-23 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-03-30 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-04-06 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-04-13 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-04-20 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-04-27 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-05-04 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-05-11 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-05-18 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-05-25 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-06-01 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-06-08 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-06-15 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-06-22 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-06-29 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-07-06 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-07-13 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-07-20 00:00:00', freq='W-MON'),\n",
       " Timestamp('2015-07-27 00:00:00', freq='W-MON')]"
      ]
     },
     "execution_count": 88,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# tolist() : list로 바꾸기 \n",
    "monday.tolist()\n",
    "# list로 감싸면 계속 괄호가 ..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "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>dine_type</th>\n",
       "      <th>corner</th>\n",
       "      <th>menu</th>\n",
       "      <th>is_sold_out</th>\n",
       "      <th>use_count</th>\n",
       "      <th>pred_count</th>\n",
       "      <th>additional</th>\n",
       "      <th>good</th>\n",
       "      <th>ok</th>\n",
       "      <th>bad</th>\n",
       "      <th>diff_use_pred</th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>wday</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2013-08-12</td>\n",
       "      <td>dinner</td>\n",
       "      <td>noodle bar</td>\n",
       "      <td>차슈라멘</td>\n",
       "      <td>F</td>\n",
       "      <td>179</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-179</td>\n",
       "      <td>2013</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-08-12</td>\n",
       "      <td>breakfast</td>\n",
       "      <td>rice &amp; soup 1</td>\n",
       "      <td>뚝배기순대국</td>\n",
       "      <td>F</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-26</td>\n",
       "      <td>2013</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-08-12</td>\n",
       "      <td>lunch</td>\n",
       "      <td>rice &amp; soup 1</td>\n",
       "      <td>A:누룽지장각백숙</td>\n",
       "      <td>F</td>\n",
       "      <td>504</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-504</td>\n",
       "      <td>2013</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-08-12</td>\n",
       "      <td>lunch</td>\n",
       "      <td>noodle bar</td>\n",
       "      <td>유니자장면</td>\n",
       "      <td>F</td>\n",
       "      <td>167</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-167</td>\n",
       "      <td>2013</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-08-12</td>\n",
       "      <td>dinner</td>\n",
       "      <td>rice &amp; soup 1</td>\n",
       "      <td>김치날치알밥</td>\n",
       "      <td>F</td>\n",
       "      <td>216</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-216</td>\n",
       "      <td>2013</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-07-27</td>\n",
       "      <td>lunch</td>\n",
       "      <td>grill &amp; fry</td>\n",
       "      <td>돼지고기채소비빔밥</td>\n",
       "      <td>F</td>\n",
       "      <td>268</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-268</td>\n",
       "      <td>2015</td>\n",
       "      <td>7</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-07-27</td>\n",
       "      <td>lunch</td>\n",
       "      <td>rice &amp; soup 2</td>\n",
       "      <td>생오리고추장불고기&amp;부추생채</td>\n",
       "      <td>F</td>\n",
       "      <td>264</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-264</td>\n",
       "      <td>2015</td>\n",
       "      <td>7</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-07-27</td>\n",
       "      <td>breakfast</td>\n",
       "      <td>take out</td>\n",
       "      <td>샌드위치콤보&amp;음료&amp;과일</td>\n",
       "      <td>F</td>\n",
       "      <td>58</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-58</td>\n",
       "      <td>2015</td>\n",
       "      <td>7</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-07-27</td>\n",
       "      <td>lunch</td>\n",
       "      <td>noodle bar</td>\n",
       "      <td>김치비빔국수</td>\n",
       "      <td>F</td>\n",
       "      <td>202</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-202</td>\n",
       "      <td>2015</td>\n",
       "      <td>7</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-07-27</td>\n",
       "      <td>lunch</td>\n",
       "      <td>take out</td>\n",
       "      <td>닭가슴살크랜베리샐러드</td>\n",
       "      <td>F</td>\n",
       "      <td>304</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-304</td>\n",
       "      <td>2015</td>\n",
       "      <td>7</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1433 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            dine_type         corner            menu is_sold_out  use_count  \\\n",
       "date                                                                          \n",
       "2013-08-12     dinner     noodle bar            차슈라멘           F        179   \n",
       "2013-08-12  breakfast  rice & soup 1          뚝배기순대국           F         26   \n",
       "2013-08-12      lunch  rice & soup 1       A:누룽지장각백숙           F        504   \n",
       "2013-08-12      lunch     noodle bar           유니자장면           F        167   \n",
       "2013-08-12     dinner  rice & soup 1          김치날치알밥           F        216   \n",
       "...               ...            ...             ...         ...        ...   \n",
       "2015-07-27      lunch    grill & fry       돼지고기채소비빔밥           F        268   \n",
       "2015-07-27      lunch  rice & soup 2  생오리고추장불고기&부추생채           F        264   \n",
       "2015-07-27  breakfast       take out    샌드위치콤보&음료&과일           F         58   \n",
       "2015-07-27      lunch     noodle bar          김치비빔국수           F        202   \n",
       "2015-07-27      lunch       take out     닭가슴살크랜베리샐러드           F        304   \n",
       "\n",
       "            pred_count  additional  good  ok  bad  diff_use_pred  year  month  \\\n",
       "date                                                                            \n",
       "2013-08-12           0           0     0   0    0           -179  2013      8   \n",
       "2013-08-12           0           0     0   0    0            -26  2013      8   \n",
       "2013-08-12           0           0     0   0    0           -504  2013      8   \n",
       "2013-08-12           0           0     0   0    0           -167  2013      8   \n",
       "2013-08-12           0           0     0   0    0           -216  2013      8   \n",
       "...                ...         ...   ...  ..  ...            ...   ...    ...   \n",
       "2015-07-27           0           0     0   0    0           -268  2015      7   \n",
       "2015-07-27           0           0     0   0    0           -264  2015      7   \n",
       "2015-07-27           0           0     0   0    0            -58  2015      7   \n",
       "2015-07-27           0           0     0   0    0           -202  2015      7   \n",
       "2015-07-27           0           0     0   0    0           -304  2015      7   \n",
       "\n",
       "            day  wday  \n",
       "date                   \n",
       "2013-08-12   12     0  \n",
       "2013-08-12   12     0  \n",
       "2013-08-12   12     0  \n",
       "2013-08-12   12     0  \n",
       "2013-08-12   12     0  \n",
       "...         ...   ...  \n",
       "2015-07-27   27     0  \n",
       "2015-07-27   27     0  \n",
       "2015-07-27   27     0  \n",
       "2015-07-27   27     0  \n",
       "2015-07-27   27     0  \n",
       "\n",
       "[1433 rows x 15 columns]"
      ]
     },
     "execution_count": 90,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 매주 월요일 데이터만 불러오기\n",
    "data[data.index.isin(monday)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    1433\n",
       "1    1432\n",
       "2    1373\n",
       "3    1298\n",
       "4    1289\n",
       "Name: wday, dtype: int64"
      ]
     },
     "execution_count": 93,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# wday: 월화수목금을 숫자로 01234표시\n",
    "data['wday'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DatetimeIndex(['2013-08-06', '2013-08-07', '2013-08-08', '2013-08-09',\n",
       "               '2013-08-12', '2013-08-13', '2013-08-14', '2013-08-15',\n",
       "               '2013-08-16', '2013-08-19',\n",
       "               ...\n",
       "               '2015-07-14', '2015-07-15', '2015-07-16', '2015-07-17',\n",
       "               '2015-07-20', '2015-07-21', '2015-07-22', '2015-07-23',\n",
       "               '2015-07-24', '2015-07-27'],\n",
       "              dtype='datetime64[ns]', length=515, freq='B')"
      ]
     },
     "execution_count": 96,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 평일만 불러오기\n",
    "weekday = pd.date_range(start = data.index.min(),\n",
    "                 end = data.index.max(),\n",
    "                 freq= 'B')\n",
    "weekday"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "480"
      ]
     },
     "execution_count": 98,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 실제 데이터 날짜 길이\n",
    "data.index.unique().size\n",
    "# 평일에 다 팔지 않았다는 것..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "515"
      ]
     },
     "execution_count": 99,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 평일 날짜 길이\n",
    "weekday.size"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DatetimeIndex(['2013-08-07', '2013-08-08', '2013-08-09', '2013-08-15',\n",
       "               '2013-08-16', '2013-09-18', '2013-09-19', '2013-09-20',\n",
       "               '2013-10-03', '2013-10-09', '2013-12-25', '2014-01-01',\n",
       "               '2014-01-30', '2014-01-31', '2014-04-04', '2014-05-01',\n",
       "               '2014-05-05', '2014-05-06', '2014-06-04', '2014-06-06',\n",
       "               '2014-08-15', '2014-09-08', '2014-09-09', '2014-09-10',\n",
       "               '2014-10-03', '2014-10-09', '2014-12-25', '2015-01-01',\n",
       "               '2015-02-18', '2015-02-19', '2015-02-20', '2015-04-03',\n",
       "               '2015-05-01', '2015-05-05', '2015-05-25'],\n",
       "              dtype='datetime64[ns]', freq=None)"
      ]
     },
     "execution_count": 101,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 포함되지 않는 날짜 확인\n",
    "weekday[~weekday.isin(data.index.unique())]\n",
    "# ~ 명제, R에서는 !\n",
    "# 휴무일 이유 예측 가능"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "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>use_count</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2013-08-06</td>\n",
       "      <td>1118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-08-12</td>\n",
       "      <td>1787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-08-13</td>\n",
       "      <td>1714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-08-14</td>\n",
       "      <td>1450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-08-19</td>\n",
       "      <td>2647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-07-21</td>\n",
       "      <td>2737</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-07-22</td>\n",
       "      <td>2755</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-07-23</td>\n",
       "      <td>2480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-07-24</td>\n",
       "      <td>2193</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-07-27</td>\n",
       "      <td>1901</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>480 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            use_count\n",
       "date                 \n",
       "2013-08-06       1118\n",
       "2013-08-12       1787\n",
       "2013-08-13       1714\n",
       "2013-08-14       1450\n",
       "2013-08-19       2647\n",
       "...               ...\n",
       "2015-07-21       2737\n",
       "2015-07-22       2755\n",
       "2015-07-23       2480\n",
       "2015-07-24       2193\n",
       "2015-07-27       1901\n",
       "\n",
       "[480 rows x 1 columns]"
      ]
     },
     "execution_count": 103,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# groupby를 사용하여 date별로 use_count의 합 구하기\n",
    "data.groupby('date')['use_count'].sum()\n",
    "pd.DataFrame(data.groupby('date')['use_count'].sum())\n",
    "# column이 하나이기 때문에 씌워줘야 함"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>use_count</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2013-08-06</td>\n",
       "      <td>1118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-08-12</td>\n",
       "      <td>1787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-08-13</td>\n",
       "      <td>1714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-08-14</td>\n",
       "      <td>1450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2013-08-19</td>\n",
       "      <td>2647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-07-21</td>\n",
       "      <td>2737</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-07-22</td>\n",
       "      <td>2755</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-07-23</td>\n",
       "      <td>2480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-07-24</td>\n",
       "      <td>2193</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-07-27</td>\n",
       "      <td>1901</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>480 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            use_count\n",
       "date                 \n",
       "2013-08-06       1118\n",
       "2013-08-12       1787\n",
       "2013-08-13       1714\n",
       "2013-08-14       1450\n",
       "2013-08-19       2647\n",
       "...               ...\n",
       "2015-07-21       2737\n",
       "2015-07-22       2755\n",
       "2015-07-23       2480\n",
       "2015-07-24       2193\n",
       "2015-07-27       1901\n",
       "\n",
       "[480 rows x 1 columns]"
      ]
     },
     "execution_count": 104,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# pivot_table을 사용하여 date별로 use_count의 합 구하기\n",
    "data.pivot_table(index = 'date', aggfunc='sum', values= 'use_count' )"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 실습"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 1. 전체 기간 동안, 아침, 점심, 저녁 메뉴로 가장 인기 있었던 메뉴를 각각 착기"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "metadata": {},
   "outputs": [],
   "source": [
    "#data.groupby(['dine_type'])['use_count'].apply(ascending = False)\n",
    "\n",
    "temp = pd.DataFrame(data.groupby(['dine_type', 'menu'])['use_count'].sum().unstack(level = 0))\n",
    "# 상위레벨"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "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>dine_type</th>\n",
       "      <th>breakfast</th>\n",
       "      <th>dinner</th>\n",
       "      <th>lunch</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>menu</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>샌드위치콤보&amp;음료&amp;과일</td>\n",
       "      <td>7754.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>A: 샌드위치 SET 510kcal</td>\n",
       "      <td>1593.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>A: 샌드위치 SET 510</td>\n",
       "      <td>1377.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>샌드위치콤보&amp;음료&amp;사과</td>\n",
       "      <td>1202.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>NC모닝</td>\n",
       "      <td>1198.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>흑미밥&amp;찜닭</td>\n",
       "      <td>NaN</td>\n",
       "      <td>90.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>흑미밥&amp;콩나물국</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>흑미버거</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>328.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>흑임자두부스테이크&amp;생선가스</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>165.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>흰살생선스테이크&amp;크림소스</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>258.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2776 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "dine_type            breakfast  dinner  lunch\n",
       "menu                                         \n",
       "샌드위치콤보&음료&과일            7754.0     NaN    NaN\n",
       "A: 샌드위치 SET 510kcal     1593.0     NaN    NaN\n",
       "A: 샌드위치 SET 510         1377.0     NaN    NaN\n",
       "샌드위치콤보&음료&사과            1202.0     NaN    NaN\n",
       "NC모닝                    1198.0     NaN    NaN\n",
       "...                        ...     ...    ...\n",
       "흑미밥&찜닭                     NaN    90.0    NaN\n",
       "흑미밥&콩나물국                   NaN    44.0    NaN\n",
       "흑미버거                       NaN     NaN  328.0\n",
       "흑임자두부스테이크&생선가스             NaN     NaN  165.0\n",
       "흰살생선스테이크&크림소스              NaN     NaN  258.0\n",
       "\n",
       "[2776 rows x 3 columns]"
      ]
     },
     "execution_count": 132,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "temp.sort_values(by = 'breakfast', ascending = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "temp.sort_values(by = 'dinner', ascending = False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 2. 2014년 한 해 동안, 각 코너 별  월별 판매량 구해보기 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "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>month</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>10</th>\n",
       "      <th>11</th>\n",
       "      <th>12</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>corner</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",
       "      <td>after school</td>\n",
       "      <td>6799.0</td>\n",
       "      <td>6731.0</td>\n",
       "      <td>7180.0</td>\n",
       "      <td>6826.0</td>\n",
       "      <td>5220.0</td>\n",
       "      <td>5389.0</td>\n",
       "      <td>6702.0</td>\n",
       "      <td>5161.0</td>\n",
       "      <td>4276.0</td>\n",
       "      <td>5014.0</td>\n",
       "      <td>4619.0</td>\n",
       "      <td>4288.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>burger&amp;pizza</td>\n",
       "      <td>5549.0</td>\n",
       "      <td>5497.0</td>\n",
       "      <td>6447.0</td>\n",
       "      <td>6145.0</td>\n",
       "      <td>4505.0</td>\n",
       "      <td>4898.0</td>\n",
       "      <td>7228.0</td>\n",
       "      <td>6436.0</td>\n",
       "      <td>5855.0</td>\n",
       "      <td>6441.0</td>\n",
       "      <td>5707.0</td>\n",
       "      <td>4447.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>grill &amp; fry</td>\n",
       "      <td>8896.0</td>\n",
       "      <td>8591.0</td>\n",
       "      <td>9316.0</td>\n",
       "      <td>9218.0</td>\n",
       "      <td>8317.0</td>\n",
       "      <td>8684.0</td>\n",
       "      <td>11008.0</td>\n",
       "      <td>8740.0</td>\n",
       "      <td>7600.0</td>\n",
       "      <td>8261.0</td>\n",
       "      <td>8491.0</td>\n",
       "      <td>7254.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>noodle bar</td>\n",
       "      <td>7985.0</td>\n",
       "      <td>7437.0</td>\n",
       "      <td>7622.0</td>\n",
       "      <td>7159.0</td>\n",
       "      <td>6614.0</td>\n",
       "      <td>6772.0</td>\n",
       "      <td>9254.0</td>\n",
       "      <td>7229.0</td>\n",
       "      <td>5751.0</td>\n",
       "      <td>6303.0</td>\n",
       "      <td>6040.0</td>\n",
       "      <td>5241.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>rice &amp; soup 1</td>\n",
       "      <td>19027.0</td>\n",
       "      <td>16191.0</td>\n",
       "      <td>12832.0</td>\n",
       "      <td>11837.0</td>\n",
       "      <td>9877.0</td>\n",
       "      <td>11046.0</td>\n",
       "      <td>13793.0</td>\n",
       "      <td>11623.0</td>\n",
       "      <td>9232.0</td>\n",
       "      <td>11550.0</td>\n",
       "      <td>10674.0</td>\n",
       "      <td>11125.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>rice &amp; soup 2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>798.0</td>\n",
       "      <td>5148.0</td>\n",
       "      <td>4820.0</td>\n",
       "      <td>4665.0</td>\n",
       "      <td>4649.0</td>\n",
       "      <td>6052.0</td>\n",
       "      <td>5368.0</td>\n",
       "      <td>4272.0</td>\n",
       "      <td>4222.0</td>\n",
       "      <td>4077.0</td>\n",
       "      <td>3986.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>take out</td>\n",
       "      <td>14963.0</td>\n",
       "      <td>14499.0</td>\n",
       "      <td>15634.0</td>\n",
       "      <td>15354.0</td>\n",
       "      <td>13481.0</td>\n",
       "      <td>13263.0</td>\n",
       "      <td>15816.0</td>\n",
       "      <td>11125.0</td>\n",
       "      <td>6540.0</td>\n",
       "      <td>7907.0</td>\n",
       "      <td>7242.0</td>\n",
       "      <td>7145.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "month               1        2        3        4        5        6        7   \\\n",
       "corner                                                                         \n",
       "after school    6799.0   6731.0   7180.0   6826.0   5220.0   5389.0   6702.0   \n",
       "burger&pizza    5549.0   5497.0   6447.0   6145.0   4505.0   4898.0   7228.0   \n",
       "grill & fry     8896.0   8591.0   9316.0   9218.0   8317.0   8684.0  11008.0   \n",
       "noodle bar      7985.0   7437.0   7622.0   7159.0   6614.0   6772.0   9254.0   \n",
       "rice & soup 1  19027.0  16191.0  12832.0  11837.0   9877.0  11046.0  13793.0   \n",
       "rice & soup 2      NaN    798.0   5148.0   4820.0   4665.0   4649.0   6052.0   \n",
       "take out       14963.0  14499.0  15634.0  15354.0  13481.0  13263.0  15816.0   \n",
       "\n",
       "month               8       9        10       11       12  \n",
       "corner                                                     \n",
       "after school    5161.0  4276.0   5014.0   4619.0   4288.0  \n",
       "burger&pizza    6436.0  5855.0   6441.0   5707.0   4447.0  \n",
       "grill & fry     8740.0  7600.0   8261.0   8491.0   7254.0  \n",
       "noodle bar      7229.0  5751.0   6303.0   6040.0   5241.0  \n",
       "rice & soup 1  11623.0  9232.0  11550.0  10674.0  11125.0  \n",
       "rice & soup 2   5368.0  4272.0   4222.0   4077.0   3986.0  \n",
       "take out       11125.0  6540.0   7907.0   7242.0   7145.0  "
      ]
     },
     "execution_count": 135,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data2014 = data['2014']\n",
    "# 코너를 기준으로 월별로\n",
    "data2014.pivot_table(index = 'corner', columns = 'month', aggfunc = 'sum', values = 'use_count')\n",
    "# pivot 에서는 unstack 말고 columns로 추가\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 140,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.collections.PathCollection at 0x1eefccb1f08>"
      ]
     },
     "execution_count": 140,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYgAAAD4CAYAAAD2FnFTAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjEsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy8QZhcZAAAgAElEQVR4nO3de5xcdX3/8dc7mwALKEtgoWQTCGqMFaMEVonFC4oa8dJEhCIFiZY2tqI//VmiYLHeqOAvPqo/vGBBLPECcimEYGkjDUGqBXQhIeGWEhFJNgirsKmSRZbNp3+c7yazkzO7M9nZncu+n4/HPObMZ75z5ntmzpzP+X7POd9RRGBmZlZsUq0rYGZm9ckJwszMcjlBmJlZLicIMzPL5QRhZma5Jte6AgAHHnhgzJw5s9bVMDNrKHfddddvIqJ9rOZfFwli5syZdHV11boaZmYNRdKvxnL+7mIyM7NcThBmZpbLCcLMzHI5QZiZWS4nCDMzy1UXZzGZ1Zvla7pZunIDW3r7mNbWypL5s1k4t6PW1TIbV04QZkWWr+lmybX30D+QjXTc3dvHkmvvAXCSsAnFXUxmRT574307ksOg/oHgszfeV6MamdWGE4RZkae29VcUN2tWThBmZpbLCcKsiCqMmzUrJwizIqX+hNd/zmsTjROEWZEW5bcVSsXNmpUThFmRgchvK5SKmzUrJwizIvvvPaWiuFmzcoIwK1KqoeAGhE00ThBmRbb25V/vUCpu1qycIMyKTGtrrShu1qycIMyKvOEl+X/xWypu1qxGTBCSZktaW3D7H0kflTRV0s2SHkr3+6fyknSRpI2S1kk6auwXw6x6fnjPYxXFzZrViAkiIjZExJERcSRwNLANuB44B1gVEbOAVekxwAnArHRbDFw8FhU3Gyu9JY41lIqbNatKu5iOB34REb8CFgDLUnwZsDBNLwC+E5k7gDZJh1SltmZmNm4qTRDvAa5M0wdHxGMA6f6gFO8ANhW8ZnOKDSFpsaQuSV09PT0VVsPMzMZa2QlC0h7AnwLXjFQ0J7bLGeQRcUlEdEZEZ3u7D/6ZmdWbSloQJwB3R8Tj6fHjg11H6f6JFN8MzCh43XRgy2gramZm46uSBHEqO7uXAFYAi9L0IuCGgvgZ6WymecDWwa4oMzNrHGX9J7WkvYE3Ax8oCF8IXC3pTOBR4OQUvwl4G7CR7Iyn91ettmZmNm7KShARsQ04oCj2W7KzmorLBnBWVWpnZmY14yupzYrs0ZL/vw+l4mbNygnCrMizA/nDtpaKmzUrJwgzM8vlBGFWxH8YZJZxgjAr8ul3HkHLpKHHG1omiU+/84ga1cisNpwgzHIMbI9hH5tNBE4QZkWWXLO2orhZs3KCMCvSv72yuFmzcoIwM7NcThBmZpbLCcLMzHI5QZiZWS4nCLMiU0r8KkrFzZqVV3mzIvvulX/FdKm4WbNygjAr0rutv6K4WbNygjArMq2ttaK4WbNygjArsmT+bFqntAyJtU5pYcn82TWqkVltlJUgJLVJulbSg5IekPRqSVMl3SzpoXS/fyorSRdJ2ihpnaSjxnYRzKpr4dwOLjhxDh1trQjoaGvlghPnsHBuR62rZjauym1B/H/g3yPiJcArgAeAc4BVETELWJUeA5wAzEq3xcDFVa2x2Tjo+tWT/HrrMwTw663P0PWrJ2tdJbNxN2KCkPR84HXAZQAR8WxE9AILgGWp2DJgYZpeAHwnMncAbZIOqXrNzcbIecvX8707HmUgshFcByL43h2Pct7y9TWumdn4KqcF8QKgB/hnSWskfUvSPsDBEfEYQLo/KJXvADYVvH5zig0habGkLkldPT09o1oIs2q68s5NFcXNmlU5CWIycBRwcUTMBZ5mZ3dSnrx/dt9lMP2IuCQiOiOis729vazKmo2HwZZDuXGzZlVOgtgMbI6IO9Pja8kSxuODXUfp/omC8jMKXj8d2FKd6pqZ2XgZMUFExK+BTZIGz/E7HrgfWAEsSrFFwA1pegVwRjqbaR6wdbAryszMGsfkMst9GPi+pD2Ah4H3kyWXqyWdCTwKnJzK3gS8DdgIbEtlzcyswZSVICJiLdCZ89TxOWUDOGuU9TIzsxrzldRmRfacnP+zKBU3a1Ze482KfPHdL2dS0bl4k5TFzSaSco9BmE0Yg0NqLF25gS29fUxra2XJ/NkeasMmHCcIsxwL53Y4IdiE5wRhlmP5mm63IGzCc4IwK7J8TTfnXreevv4BALp7+zj3umwcJicJm0h8kNqsyNKVG3Ykh0F9/QMsXbmhRjUyqw0nCLMiW3r7KoqbNSsnCLMi+7VOqShu1qycIMyKKG884mHiZs3KCcKsyFPb+iuKmzUrJwizIi0lmgql4mbNygnCrIj/MMgs4wRhVmT/vfMPRpeKmzUrJwizIqUaCm5A2ETjBGFWZGtf/sHoUnGzZuUEYVZkWltrRXGzZuUEYVZkyfzZtE5pGRJrndLCkvmzS7zCrDmVlSAkPSJpvaS1krpSbKqkmyU9lO73T3FJukjSRknrJB01lgtgVm0L53ZwwYlz6GhrRUBHWysXnDjHA/XZhFPJaK5viIjfFDw+B1gVERdKOic9/gRwAjAr3Y4BLk73Zg3D/wdhNrrhvhcAx6XpZcCtZAliAfCdiAjgDkltkg6JiMdGU9E8HrPfzGzslHsMIoAfSbpL0uIUO3hwo5/uD0rxDmBTwWs3p9gQkhZL6pLU1dPTU3HFB8fs7+7tI9g5Zv/yNd0Vz8vMzHZVboI4NiKOIus+OkvS64YpmzcewS5nkEfEJRHRGRGd7e3tZVZjJ4/Zb2Y2tsrqYoqILen+CUnXA68CHh/sOpJ0CPBEKr4ZmFHw8unAlirWGfCY/Ta23H1pVkYLQtI+kp43OA28BbgXWAEsSsUWATek6RXAGelspnnA1rE4/uAx+22suPvSLFNOC+Jg4HplI1lOBq6IiH+X9HPgaklnAo8CJ6fyNwFvAzYC24D3V73WeMx+GzvDdV+6FWETyYgJIiIeBl6RE/8tcHxOPICzqlK7YXjMfhsr7r40yzTsldQes9/GiofaMMs0bILwmP02VjzUhllmNBfKmTWlweMMPovJJjonCLMcHmrDrIG7mMzMbGw5QZiZWS53MZnl8JXUZk4QZrtYvqabJdfcQ//27Iy47t4+llxzD4CThE0o7mIyK/KZFfftSA6D+rcHn1lxX41qZFYbThBmRXr78q/GLxU3a1ZOEGZmlssJwszMcjlBmJlZLicIMzPL5QRhZma5nCDMzCyXE4SZmeUq+0pqSS1AF9AdEe+QdDjwA2AqcDfw3oh4VtKewHeAo4HfAqdExCNVr7nVJQ9RYdY8KmlBfAR4oODxF4EvR8Qs4CngzBQ/E3gqIl4EfDmVswlg+Zpuzr1uPd29fQTZEBXnXree5Wu6a101M9sNZSUISdOBtwPfSo8FvBG4NhVZBixM0wvSY9Lzx6fy1uSWrtxAX//AkFhf/wBLV26oUY3MbDTKbUF8Bfg4sD09PgDojYjn0uPNwGA/QgewCSA9vzWVH0LSYkldkrp6enp2s/pWT7b09lUUN7P6NmKCkPQO4ImIuKswnFM0ynhuZyDikojojIjO9vb2sipr9W1aW2tFcbOJavmabo698BYOP+dfOfbCW+q2G7acFsSxwJ9KeoTsoPQbyVoUbZIGD3JPB7ak6c3ADID0/H7Ak1Wss9WpJfNn0zqlZUisdUoLS+bPrlGNzOpPIx2rGzFBRMS5ETE9ImYC7wFuiYjTgNXASanYIuCGNL0iPSY9f0tE7NKCsOazcG4HF5w4h462VgR0tLVywYlzfBaTWYFGOlY3mj8M+gTwA0nnA2uAy1L8MuC7kjaStRzeM7oqWiNZOLfDCaHOnLd8PVfeuYmBCFokTj1mBucvnFPrak1YjXSsrqIEERG3Arem6YeBV+WUeQY4uQp1M7NROm/5er53x6M7Hg9E7HjsJFEb09pa6c5JBvV4rM5XUps1sSvv3FRR3MZeIx2r839SmzWxgRKH/0rFbewNdsE2wogDThBmTUyCvFzgS1drq1GO1TVsgmiRcveCWrzmm+3QOnkS2/q358atdhplzLKGTRCnHjNjyMG3wrjVTqOs+BNFXnIYLm5jb/mabj561dodj7t7+3Y8rrffSsPuRpy/cA6nzzt0R4uhReL0eYf6zIwaWr6mmyXX3jPkAqAl195TlxcAmdXKkmvWVhSvpYZtQQB0HjaV1Q/2sKW3jz/aby86D5ta6yrtltMuvZ2f/mLnxebHvnAq3/+rV9ewRrvnszfeR//A0G6//oHgszfeV3d7Rma1UqrxVo+NuoZtQSxf083Hrlo7ZG/1Y1etbbi91eLkAPDTXzzJaZfeXqMa7b6ntvVXFDez+tawCeLc69ZRnHC3p3gjKU4OI8XNzMZLwyaIvhLtsVJxMzOrTMMmCKs/pc4w9pnHZo3JCcKqptTFub5o16wxOUFY1XSUGGysVNzM6psThFVNIw1CZmYjc4Kwqlk4t4OjDt1vSOyoQ/fzNRBmDcoJwqrmvOXrc6/pOG/5+hrVyMxGwwnCquaKO3cdG2u4uJnVtxEThKS9JP1M0j2S7pP02RQ/XNKdkh6SdJWkPVJ8z/R4Y3p+5tgugtWL7SXOVioVN7P6Vk4L4g/AGyPiFcCRwFslzQO+CHw5ImYBTwFnpvJnAk9FxIuAL6dyZmbWYEZMEJH5fXo4Jd0CeCNwbYovAxam6QXpMen54yVfKmVm1mjKOgYhqUXSWuAJ4GbgF0BvRDyXimwGBk9V6QA2AaTntwIH5MxzsaQuSV09PT2jWwozM6u6shJERAxExJHAdOBVwB/nFUv3ea2FXXqhI+KSiOiMiM729vZy62tmZuOkorOYIqIXuBWYB7RJGvw/ienAljS9GZgBkJ7fD/DQpGZmDaacs5jaJbWl6VbgTcADwGrgpFRsEXBDml6RHpOevyXCo/GYmTWacv5R7hBgmaQWsoRydUT8UNL9wA8knQ+sAS5L5S8DvitpI1nL4T1jUG8zMxtjIyaIiFgHzM2JP0x2PKI4/gxwclVqZ2ZWYPmabpau3MCW3j6mtbWyZP5sD+Uyhhr6P6nNbOJYvqabc69bT1//AJD9zfC512XDuDhJjA0PtWFmDWHpyg07ksOgvv4Blq7cUKMaNT8nCDNrCN29fRXFbfScIMysIbSUGJChVNxGzwnCzBrCQImz5UvFbfScIMysIfgvbcefE4SZNYQ3vCR/SJ5ScRs9JwgzawirH8wf1LNU3EbPCcLMGsKWEmcrlYrb6DlBmFlD2GNy/uaqVNxGz5+smTWEPzy3vaK4jZ4ThJmZ5XKCMDOzXE4QZmaWywnCzMxyOUGYmVkuJwgzM8vlBGFmZrlGTBCSZkhaLekBSfdJ+kiKT5V0s6SH0v3+KS5JF0naKGmdpKPGeiHMzKz6ymlBPAf8bUT8MTAPOEvSS4FzgFURMQtYlR4DnADMSrfFwMVVr7WZmY25ERNERDwWEXen6d8BDwAdwAJgWSq2DFiYphcA34nMHUCbpEOqXnMzMxtTFR2DkDQTmAvcCRwcEY9BlkSAg1KxDmBTwcs2p1jxvBZL6pLU1dPj0RjNzOpN2QlC0r7AvwAfjYj/Ga5oTmyXv3yKiEsiojMiOtvbPZ67mVm9KStBSJpClhy+HxHXpfDjg11H6f6JFN8MzCh4+XRgS3Wqa2Zm46Wcs5gEXAY8EBH/WPDUCmBRml4E3FAQPyOdzTQP2DrYFWVmZo1jchlljgXeC6yXtDbFPglcCFwt6UzgUeDk9NxNwNuAjcA24P1VrbGZmY2LERNERPyE/OMKAMfnlA/grFHWy8zMasxXUpuZWS4nCDMzy+UEYWZmuRo2Qew9Jb/qpeJmZlaZht2a7jG5paK4mZlVpmETxNa+/oriZmZWmYZNENPaWiuKm5lZZRo2Qcw8ID8RlIqbmVllGjZB3PHwUxXFzcysMg2bIAZilwFih42bmVllGjZBtCh/9I9ScTMzq0zDJohTj5lRUdzMzCrTsAmi87CptEwa2lpomSQ6D5taoxqZmTWXhk0QS1duYGD70OMNA9uDpSs31KhGZmbNpWETxJbevoriZmZWmYZNEL5QzsxsbDVsgnjDS9oripuZ1YOOEjuxpeK1VM5/Un9b0hOS7i2ITZV0s6SH0v3+KS5JF0naKGmdpKPGquLX3bW5oriZWT1opFEgymlBXA68tSh2DrAqImYBq9JjgBOAWem2GLi4OtXc1bb+7RXFzcpVasR4jyRv1XD7w09WFK+lEVf5iLgNKK75AmBZml4GLCyIfycydwBtkg6pVmXNxkOpfQzve1g1bC8x2EOpeC3t7j7RwRHxGEC6PyjFO4BNBeU2p9guJC2W1CWpq6enZzerYWZmY6Xajea8cS5y82JEXBIRnRHR2d7uA8tmNjG0luirLBWvpd2t0eODXUfp/okU3wwUjnUxHdiy+9UzM2suF5z48oritbS7CWIFsChNLwJuKIifkc5mmgdsHeyKMjOzzJQWDfu4XpRzmuuVwO3AbEmbJZ0JXAi8WdJDwJvTY4CbgIeBjcClwAfHpNZmZg1q6coN9A8M7XnvH6jPYYImj1QgIk4t8dTxOWUDOGu0lTIza1aNNExQ/R0VMTNrYo00TJAThJnZOGqkYYKcIMzMxtHqB/Ov+yoVryUnCDOzceRjEGZmlsvHIMzMLNeS+bNpndIyJNY6pYUl82fXqEaljXiaq5k1LgkiZ7Ab1ed1WRPCwrnZ8HRLV25gS28f09paWTJ/9o54PXGCMGtieclhuLiNj4VzO+oyIRRzF5NZE2ukfy+z+uMEYdbElsyfzZRJReP+TFJd9ndb/XGCMGt2xccbfPzByuQEYdbEGmlgOKs/ThBmTayRLsoayd4l/lCnVNxGz5+sVc3+e0+pKG5jr5EuyhrJiUdPryhuo+cEYVXz6XcekftHKJ9+5xE1qpE10kVZI2mkMYyaha+DsKpppAuAJopm+k6aqbusUThBWFU1ygVAE0mzfCfT2lrpzkkGjdhd1ijGpItJ0lslbZC0UdI5Y/EezaKlxJgHpeJmE5Wv6Rh/VU8QklqArwMnAC8FTpX00mq/T7M49ZgZFcXNJjRf0zGuxqIF8SpgY0Q8HBHPAj8AFozB+zSF8xfO4fR5h+5oMbRInD7vUM5fOKfGNZu4PDxFffI1HeNvLI5BdACbCh5vBo4pLiRpMbAY4NBDD634TQTkjTfWiDsU5y+c44RQR5bMn825162nr39gR6xRz/xpJj5IPf7GogWRt43eZVseEZdERGdEdLa3V/5frKfNy08qpeJm5Vo4t4MLTpxDR1srIms5XHDinKY40NvImumajkYxFi2IzUBhB/p0YEu132Rwj/vKOzcxEEGLxKnHzPCeuFVFs5z500zcsht/iioPDC9pMvDfwPFAN/Bz4M8j4r5Sr+ns7Iyurq6q1sPMms/yNd1NcU1HtUi6KyI6x2r+VW9BRMRzkj4ErARagG8PlxzMzMrllt34GpML5SLiJuCmsZi3mZmND4/FZGZmuZwgzMwslxOEmZnlcoIwM7NcVT/NdbcqIfUAvxrFLA4EflOl6tRSsywHNM+yNMtygJelHo12OQ6LiMqvNC5TXSSI0ZLUNZbnAo+XZlkOaJ5laZblAC9LPar35XAXk5mZ5XKCMDOzXM2SIC6pdQWqpFmWA5pnWZplOcDLUo/qejma4hiEmZlVX7O0IMzMrMqcIMzMLNe4JwhJbZI+WEa5mZLuHY86pfd7n6Rp4/V+6T13LKOk4yT9sILXliw/3p9dKZI+I+lBSfdKeleZr/lrSWcM8/xNktqqULd5ku6RtF7SstHOrxokHSBptaTfS/paGeV3fFaSLpd0Upq+VdIup04qc4mk+9Nyv3qYeb9W0n2S1krarX/kkXSypAfSMh0p6W27M5/dfO/3lfMZ5rxul/VL0iOSDqxwPvW4fr1Z0l2pTndJeuNIrxmT0VxH0AZ8EPhGDd57OO8D7mUM/tyoHklqiYiBnPjkiHhutPMGpgGnAS8l+0fBPyrntRHxzRLzFNkxs2ptZP4B+GhErJZ0eJXmOVrPAJ8CXpZuJaXvKfezGsZrgFnAEUAr8Lxhyp4GfCki/rnofXPXmxLOBD6YPuP3AZ1UMMpzNdbFCt5rIqxfvwHeGRFbJL2M7C8Zhh87PSLG9Qb8AOgD1gJLgX2BVcDdwHpgQSo3E7g3Tb8AWAO8kuw/JpaS/RHROuADJd7nY2Qb/HvJvqgh80yPzwY+A5wE/B7YkOrVWjSvmcADwKXAfcCPBssARwJ3pLpcD+w/Qvxo4B7g9rQcg8t4HPDDNL0P8O20jGsGP5OiOh0H3JbmfT/wTWBSeu576TPuBR4HrgX2Bp4DLgR+AnwSuDWV/wzZ2RQ/Aq5IZa9Odb8KuBPoTGXfkup+N3ANsG+KPwL8fZr3e4BD0nvvX+L7eQT4IvCzdHtRQV3OJksw95NtNH9DlmT+BHiWbD1Zm6Z/QfYHVU+kz+pnZCv+z9Pt2BLv/2/Ae8tYX49I81ybPo9Zla5fafpW4CvAf6XXvGqY97wOeAq4GbgSOLtgHl8Afgz87eBnlZ67HDipoFxnznyPSZ/pHiMs818CTwK/BL5Ptq6tTuvG/cDngY8UlN8APEr221icYn/Pzt/Ul9PzPelzPIUS6zjZjto1wI3ALUX12gf4V7Lfz73AKSn+yvS53pO+q+el+VwH/DvwEPD/CuZzalqHNpCtW99IdfhwWqceIFs3z0jf+bPA1em17cC/0MDrVyov4LfAnsOWG83GfnduOQs5GXh+mj4Q2JgqPzMt6Oz05R2ZyiwGzkvTewJdwOFF73F0WgH2IUtA9wFzy/iAd/lRFdT5uYI6XA2cnqbXAa9P058DvlJBvFSC+ELB/NvINoD7FNXpOLKN5wvIkubN7NxAvIJsg/ratFzXp2V9rmB5OxmaIO5iZ9I7G/inNP2y9LrO9P3cNlgX4BPA36fpR4CPF9RvalrW1XkrYSr/d2n6jIJl/ww7N3ozge3pc7q64HUHAmcB28haJs8H2tPzqwqW61DggRLf6dfI/h439zsvKPdV4LQ0vQfZnvfurl+XpunXFZYrer9Oso3pxWQbuocYmiC+UVC28LO6nJETxMy0zFeQzmAcZrkL53cc8DTpd5bmc3eankSWSA5In829wAHF9SDbYH+tYP6563gqtxmYmlOndw9+hunxfuk7eRh4ZYo9n2yb8r4U3w/Yi2wonxlkOx6Pkm3oX0j2O/l4QfxR4GCynaJusnXtEXbuwFwBvKZR16+C154E/MdwZSKiLg5SC/iCpHXAf5A1eQ5Oz7UDN5CtSGtT7C3AGZLWkn2JB5A1mwu9Brg+Ip6OiN+T7Um8dpT1/GVBHe4CZkraD2iLiB+n+DLgdRXEv1vivd4CnJOW8VayFfzQnHI/i4iHI2vyX0m23ADvAPqBr5Ptodxb8NzyEu+5IiL60vRryFp6RMS9ZBt6gHlkXUY/TXVbBBxWMI+rCqYvA/4vcAtwhaRJkj4u6ayCMlcW3JfqD/818CbgLwpiLyDbQ700In5NthG4JB13eT0wL9VvBfB8SUO6UiQtSK85IdVtlqR2ST/Pef/bgU9K+gTZuDd97P76dSVARNyW6pV3LOU1ZK2zgYj4HdmedKGrdn1J2a4l+yvgbWR79Uj6hqS3l/Han0XELwEi4hHgt5Lmkq2rfWTf8x1kG+Hi32Oe4dbxmyPiyZzXrAfeJOmLkl4bEVvJdiAfi4ifp7r9T+zslloVEVsj4hmyls9hZK2NWyOiBxgga0H80WCcbIdkgGxHdXNEDI6T1Jvu3wR8rYHXLyQdQdZC+sBIM6zFMYhip5ElgqMjol/SI2QrC8BWYBNwLFkWhSyhfDgiVg4zT5WIP8fQA/N7lSiX5w8F0wNkmb5SIttjKafcuyNiwwjliucVqb/zr4DHI+Llki4n2zOJdHsmlS1e9qeL3r9UvW6OiFNLPF84jzeR7YGukvRVsmb8bLLWQl798z6XdrIdgOPSD2WwDt8i+zEMxj4PrI6Id0l6EvhdRBxZoo4A88k2HuslnUm2E3INORvfiLhC0p3A24GVkv6S3V+/dvm+cuZRat6Dnh7h+VySDgIOjIgNkj4A/IukT5O1WJaUMYvi9/0W2V76HLLleHVEbJN0K+X9rnLXcUnH5LwXABHx35KOBt4GXCDpR2Q7PKV+U8W/2cns+vk+W1Cf4vrlzXcS2bL25Tw3qG7XL0nTyXoUzoiIXwyzDEBtTnP9HUMPju0HPJGSwxsYukf6LLCQrMXw5ym2EvgbSVMAJL1Y0j5F73EbsFDS3um5dwH/SdYnflA6W2RPsj3tUvUaUdqDeUrSYHZ/L/DjYeK9wFZJg3vzp5WY9Urgw+nAGWlPLc+rJB0uaRJZv+5PyJrY24Dp6ayRE8j6nn9CtoK9Ir323cMs2k+AP0vv/VKyjQBke4jHSnpRem5vSS8uMY91wOlp+uNkCeMPEbGpoMwpBfe3F744fb9fB34dEf9d8NSBZMnhUuDPJB1Atg5tTc93U/A9SspLFGuAUyTtFRH/SfaD+Tt2tmgK6/EC4OGIuIhsj/Hl7N76tWN50/e/Na0nxX5CdvyqRdK+ZBuOaujJ3lpvSC3OxcBHyLqKdifpXA+8laxF+XBKDi8ha2XmKf59lbuO76DsLMNtEfE94EvAUcCDwDRJr0xlnidpuB3fO4HXp7OSJpGtOz8ejKfYJOBwYEZavyDrBoPsON2HCurUMOtXalH8K3BuRPx0mM9oh3FvQUTEbyX9NHUH/BtZU+dGSV1kB2oeLCr/tKR3ADdLeppsz2UmcHdauXrIkkjha+5Oe84/S6FvRcQaAEmfI1sZfln0XpcD35TUx8h7CIUWpdftTdbn+f4R4u8Hvi1pG9mPJM/nyQ44rUvL+Ai7rgyQbVQvJNuA30bWLN0u6X6y/tWLyfYy9k3TZwP/IOlD6TMo5RvAstTtt4ZsY781InqUnY1yZVpBAc4j6z8udgbwT5L+lqzV8iXg3ZI+FhH/mMrsmfaeJpEdOCz0J2TJbHtqzgMsIDuA/udkP4Y903IE8EZJi9m5A7GObP2+DfjronlfRtYNsmiFtyQAAAFXSURBVFbS79PynQ1cK+n4iNhWUPYU4HRJ/WTdXZ+LiCd3Y/2CbKfhv8iS+F+Q7xqyLtYPkK0rN7Mz+e22iAhJ7wYuSuvkNrIN3cclnRQR11Y4v2clrSbb8L8sfd4byHYi8qxmZ5fSBZS/jheaAyyVtJ2sC/VvUj1OAb6q7HTcPrKdkVL1fkzSuak+ewB9EXEDQIpfTpYwbiTrtfgx2fGJz5Oto/8H+HqDrl8fAl4EfErSp1LsLRHxRKnPy0Nt2C6UnaY6JSKekfRCsgO/L46IZ0d4aSXv8QjZAbxmGNN/RKnr5eyI6Cqj7L4R8fu0Ib+N7Mygu8e6jpVIrda7gZMj4qFa12eiq2T9qkQ9HIOw+rM3sDp184i0p1bjOk0kl6Suvb2AZXWYHF4K/JCsxerk0MTcgjAzs1z1cJqrmZnVIScIMzPL5QRhZma5nCDMzCyXE4SZmeX6X30mDhwfUrJ9AAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.scatter(data2014['corner'], data2014['use_count'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 3. 매진을 가장 많이 기록한 상위 10개 메뉴와 매진횟수를 출력"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 142,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "치즈돈가스           14\n",
       "등심돈가스           13\n",
       "김치볶음밥&계란후라이     11\n",
       "고구마돈가스           9\n",
       "고르곤졸라피자          9\n",
       "                ..\n",
       "버섯된장찌개&깻잎고기전     1\n",
       "야채김밥set          1\n",
       "류산슬덮밥            1\n",
       "왕새우카레덮밥          1\n",
       "현미밥&콩나무국         1\n",
       "Name: menu, Length: 797, dtype: int64"
      ]
     },
     "execution_count": 142,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "soldOut = data[data.is_sold_out == 'T']\n",
    "soldOut['menu'].value_counts()"
   ]
  }
 ],
 "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.4"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}