seoul_bus.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 자치구별 정류소번호 앞 2자리 (01~25)\n",
    "\n",
    "## 01 종로구\n",
    "\n",
    "## 02 중구\n",
    "\n",
    "## 03 용산구\n",
    "\n",
    "## 04 성동구\n",
    "\n",
    "## 05 광진구\n",
    "\n",
    "## 06 동대문구\n",
    "\n",
    "## 07 중랑구\n",
    "\n",
    "## 08 성북구\n",
    "\n",
    "## 09 강북구\n",
    "\n",
    "## 10 도봉구\n",
    "\n",
    "## 11 노원구\n",
    " \n",
    "## 12 은평구\n",
    "\n",
    "## 13 서대문구\n",
    "\n",
    "## 14 마포구\n",
    "\n",
    "## 15 양천구\n",
    "\n",
    "## 16 강서구\n",
    "\n",
    "## 17 구로구\n",
    "\n",
    "## 18 금천구\n",
    "\n",
    "## 19 영등포구\n",
    "\n",
    "## 20 동작구\n",
    "\n",
    "## 21 관악구\n",
    "\n",
    "## 22 서초구\n",
    "\n",
    "## 23 강남구\n",
    "\n",
    "## 24 송파구\n",
    "\n",
    "## 25 강동구"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>표준ID</th>\n",
       "      <th>ARS-ID</th>\n",
       "      <th>정류소명</th>\n",
       "      <th>X좌표</th>\n",
       "      <th>Y좌표</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>121000001</td>\n",
       "      <td>22001</td>\n",
       "      <td>교육개발원입구</td>\n",
       "      <td>127.038342</td>\n",
       "      <td>37.478514</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>121000002</td>\n",
       "      <td>22002</td>\n",
       "      <td>교육개발원입구</td>\n",
       "      <td>127.038676</td>\n",
       "      <td>37.477767</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>121000003</td>\n",
       "      <td>22003</td>\n",
       "      <td>양재역.서초문화예술회관</td>\n",
       "      <td>127.035847</td>\n",
       "      <td>37.482522</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>121000004</td>\n",
       "      <td>22004</td>\n",
       "      <td>양재역.서초문화예술회관</td>\n",
       "      <td>127.036825</td>\n",
       "      <td>37.481871</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>121000005</td>\n",
       "      <td>22005</td>\n",
       "      <td>뱅뱅사거리</td>\n",
       "      <td>127.032367</td>\n",
       "      <td>37.487592</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1161</th>\n",
       "      <td>122900097</td>\n",
       "      <td>23972</td>\n",
       "      <td>수서교회.수서동성당앞</td>\n",
       "      <td>127.094743</td>\n",
       "      <td>37.483491</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1162</th>\n",
       "      <td>122000286</td>\n",
       "      <td>23981</td>\n",
       "      <td>삼성서울병원사거리</td>\n",
       "      <td>127.082862</td>\n",
       "      <td>37.488968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1163</th>\n",
       "      <td>122900073</td>\n",
       "      <td>23993</td>\n",
       "      <td>강남신동아파밀리에2단지</td>\n",
       "      <td>127.101538</td>\n",
       "      <td>37.464601</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1164</th>\n",
       "      <td>122000287</td>\n",
       "      <td>23994</td>\n",
       "      <td>일원주유소.삼성서울병원후문</td>\n",
       "      <td>127.087681</td>\n",
       "      <td>37.490657</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1165</th>\n",
       "      <td>122900074</td>\n",
       "      <td>23995</td>\n",
       "      <td>리엔파크4단지.강남데시앙파크</td>\n",
       "      <td>127.101900</td>\n",
       "      <td>37.461227</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1166 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           표준ID  ARS-ID             정류소명         X좌표        Y좌표\n",
       "0     121000001   22001          교육개발원입구  127.038342  37.478514\n",
       "1     121000002   22002          교육개발원입구  127.038676  37.477767\n",
       "2     121000003   22003     양재역.서초문화예술회관  127.035847  37.482522\n",
       "3     121000004   22004     양재역.서초문화예술회관  127.036825  37.481871\n",
       "4     121000005   22005            뱅뱅사거리  127.032367  37.487592\n",
       "...         ...     ...              ...         ...        ...\n",
       "1161  122900097   23972      수서교회.수서동성당앞  127.094743  37.483491\n",
       "1162  122000286   23981        삼성서울병원사거리  127.082862  37.488968\n",
       "1163  122900073   23993     강남신동아파밀리에2단지  127.101538  37.464601\n",
       "1164  122000287   23994   일원주유소.삼성서울병원후문  127.087681  37.490657\n",
       "1165  122900074   23995  리엔파크4단지.강남데시앙파크  127.101900  37.461227\n",
       "\n",
       "[1166 rows x 5 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df1 = pd.read_excel('data/교통 데이터/강남구서초구버스정류장.xlsx')\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([22001, 22002, 22003, ..., 23993, 23994, 23995], dtype=int64)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1[\"ARS-ID\"].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>표준ID</th>\n",
       "      <th>ARS-ID</th>\n",
       "      <th>X좌표</th>\n",
       "      <th>Y좌표</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>1.166000e+03</td>\n",
       "      <td>1166.000000</td>\n",
       "      <td>1166.000000</td>\n",
       "      <td>1166.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>1.217670e+08</td>\n",
       "      <td>22906.771870</td>\n",
       "      <td>127.037236</td>\n",
       "      <td>37.489812</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>5.456143e+05</td>\n",
       "      <td>553.129535</td>\n",
       "      <td>0.031638</td>\n",
       "      <td>0.019543</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.200007e+08</td>\n",
       "      <td>22001.000000</td>\n",
       "      <td>126.980330</td>\n",
       "      <td>37.430780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>1.210010e+08</td>\n",
       "      <td>22387.500000</td>\n",
       "      <td>127.014053</td>\n",
       "      <td>37.478648</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>1.219003e+08</td>\n",
       "      <td>22933.500000</td>\n",
       "      <td>127.035452</td>\n",
       "      <td>37.489109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>1.220002e+08</td>\n",
       "      <td>23345.750000</td>\n",
       "      <td>127.056702</td>\n",
       "      <td>37.501328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1.229001e+08</td>\n",
       "      <td>23995.000000</td>\n",
       "      <td>127.121137</td>\n",
       "      <td>37.781594</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               표준ID        ARS-ID          X좌표          Y좌표\n",
       "count  1.166000e+03   1166.000000  1166.000000  1166.000000\n",
       "mean   1.217670e+08  22906.771870   127.037236    37.489812\n",
       "std    5.456143e+05    553.129535     0.031638     0.019543\n",
       "min    1.200007e+08  22001.000000   126.980330    37.430780\n",
       "25%    1.210010e+08  22387.500000   127.014053    37.478648\n",
       "50%    1.219003e+08  22933.500000   127.035452    37.489109\n",
       "75%    1.220002e+08  23345.750000   127.056702    37.501328\n",
       "max    1.229001e+08  23995.000000   127.121137    37.781594"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "표준ID        int64\n",
       "ARS-ID      int64\n",
       "정류소명       object\n",
       "X좌표       float64\n",
       "Y좌표       float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>사용년월</th>\n",
       "      <th>노선번호</th>\n",
       "      <th>노선명</th>\n",
       "      <th>표준버스정류장ID</th>\n",
       "      <th>버스정류장ARS번호</th>\n",
       "      <th>역명</th>\n",
       "      <th>00시승차총승객수</th>\n",
       "      <th>00시하차총승객수</th>\n",
       "      <th>1시승차총승객수</th>\n",
       "      <th>1시하차총승객수</th>\n",
       "      <th>...</th>\n",
       "      <th>19시하차총승객수</th>\n",
       "      <th>20시승차총승객수</th>\n",
       "      <th>20시하차총승객수</th>\n",
       "      <th>21시승차총승객수</th>\n",
       "      <th>21시하차총승객수</th>\n",
       "      <th>22시승차총승객수</th>\n",
       "      <th>22시하차총승객수</th>\n",
       "      <th>23시승차총승객수</th>\n",
       "      <th>23시하차총승객수</th>\n",
       "      <th>등록일자</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>202001</td>\n",
       "      <td>140</td>\n",
       "      <td>140번(도봉산역~AT센터)</td>\n",
       "      <td>121000001</td>\n",
       "      <td>22001</td>\n",
       "      <td>교육개발원입구</td>\n",
       "      <td>3</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>309</td>\n",
       "      <td>32</td>\n",
       "      <td>199</td>\n",
       "      <td>22</td>\n",
       "      <td>202</td>\n",
       "      <td>42</td>\n",
       "      <td>226</td>\n",
       "      <td>20</td>\n",
       "      <td>179</td>\n",
       "      <td>20200203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>202001</td>\n",
       "      <td>140</td>\n",
       "      <td>140번(도봉산역~AT센터)</td>\n",
       "      <td>121000002</td>\n",
       "      <td>22002</td>\n",
       "      <td>교육개발원입구</td>\n",
       "      <td>59</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>145</td>\n",
       "      <td>412</td>\n",
       "      <td>99</td>\n",
       "      <td>420</td>\n",
       "      <td>100</td>\n",
       "      <td>357</td>\n",
       "      <td>78</td>\n",
       "      <td>205</td>\n",
       "      <td>68</td>\n",
       "      <td>20200203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>202001</td>\n",
       "      <td>140</td>\n",
       "      <td>140번(도봉산역~AT센터)</td>\n",
       "      <td>121000003</td>\n",
       "      <td>22003</td>\n",
       "      <td>양재역.서초문화예술회관</td>\n",
       "      <td>43</td>\n",
       "      <td>55</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>527</td>\n",
       "      <td>144</td>\n",
       "      <td>378</td>\n",
       "      <td>168</td>\n",
       "      <td>340</td>\n",
       "      <td>202</td>\n",
       "      <td>349</td>\n",
       "      <td>118</td>\n",
       "      <td>246</td>\n",
       "      <td>20200203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>202001</td>\n",
       "      <td>140</td>\n",
       "      <td>140번(도봉산역~AT센터)</td>\n",
       "      <td>121000004</td>\n",
       "      <td>22004</td>\n",
       "      <td>양재역.서초문화예술회관</td>\n",
       "      <td>141</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>498</td>\n",
       "      <td>442</td>\n",
       "      <td>334</td>\n",
       "      <td>402</td>\n",
       "      <td>336</td>\n",
       "      <td>386</td>\n",
       "      <td>220</td>\n",
       "      <td>321</td>\n",
       "      <td>128</td>\n",
       "      <td>20200203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>202001</td>\n",
       "      <td>140</td>\n",
       "      <td>140번(도봉산역~AT센터)</td>\n",
       "      <td>121000005</td>\n",
       "      <td>22005</td>\n",
       "      <td>뱅뱅사거리</td>\n",
       "      <td>7</td>\n",
       "      <td>54</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>388</td>\n",
       "      <td>74</td>\n",
       "      <td>253</td>\n",
       "      <td>53</td>\n",
       "      <td>254</td>\n",
       "      <td>43</td>\n",
       "      <td>269</td>\n",
       "      <td>52</td>\n",
       "      <td>175</td>\n",
       "      <td>20200203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47101</th>\n",
       "      <td>202012</td>\n",
       "      <td>8541</td>\n",
       "      <td>8541번(호압사~강남역)</td>\n",
       "      <td>121000530</td>\n",
       "      <td>22033</td>\n",
       "      <td>정금마을</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20210103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47102</th>\n",
       "      <td>202012</td>\n",
       "      <td>8541</td>\n",
       "      <td>8541번(호압사~강남역)</td>\n",
       "      <td>121000531</td>\n",
       "      <td>22031</td>\n",
       "      <td>경문고등학교</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20210103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47103</th>\n",
       "      <td>202012</td>\n",
       "      <td>8541</td>\n",
       "      <td>8541번(호압사~강남역)</td>\n",
       "      <td>121000532</td>\n",
       "      <td>22029</td>\n",
       "      <td>총신대입구역.남성시장입구앞</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20210103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47104</th>\n",
       "      <td>202012</td>\n",
       "      <td>8541</td>\n",
       "      <td>8541번(호압사~강남역)</td>\n",
       "      <td>121000533</td>\n",
       "      <td>22027</td>\n",
       "      <td>이수역</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20210103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47105</th>\n",
       "      <td>202012</td>\n",
       "      <td>8541</td>\n",
       "      <td>8541번(호압사~강남역)</td>\n",
       "      <td>122000182</td>\n",
       "      <td>23285</td>\n",
       "      <td>강남역</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20210103</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>47106 rows × 55 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         사용년월  노선번호              노선명  표준버스정류장ID  버스정류장ARS번호              역명  \\\n",
       "0      202001   140  140번(도봉산역~AT센터)  121000001       22001         교육개발원입구   \n",
       "1      202001   140  140번(도봉산역~AT센터)  121000002       22002         교육개발원입구   \n",
       "2      202001   140  140번(도봉산역~AT센터)  121000003       22003    양재역.서초문화예술회관   \n",
       "3      202001   140  140번(도봉산역~AT센터)  121000004       22004    양재역.서초문화예술회관   \n",
       "4      202001   140  140번(도봉산역~AT센터)  121000005       22005           뱅뱅사거리   \n",
       "...       ...   ...              ...        ...         ...             ...   \n",
       "47101  202012  8541   8541번(호압사~강남역)  121000530       22033            정금마을   \n",
       "47102  202012  8541   8541번(호압사~강남역)  121000531       22031          경문고등학교   \n",
       "47103  202012  8541   8541번(호압사~강남역)  121000532       22029  총신대입구역.남성시장입구앞   \n",
       "47104  202012  8541   8541번(호압사~강남역)  121000533       22027             이수역   \n",
       "47105  202012  8541   8541번(호압사~강남역)  122000182       23285             강남역   \n",
       "\n",
       "       00시승차총승객수  00시하차총승객수  1시승차총승객수  1시하차총승객수  ...  19시하차총승객수  20시승차총승객수  \\\n",
       "0              3         35         0         0  ...        309         32   \n",
       "1             59         18         0         0  ...        145        412   \n",
       "2             43         55         0         0  ...        527        144   \n",
       "3            141         34         0         0  ...        498        442   \n",
       "4              7         54         0         0  ...        388         74   \n",
       "...          ...        ...       ...       ...  ...        ...        ...   \n",
       "47101          0          0         0         0  ...          0          0   \n",
       "47102          0          0         0         0  ...          0          0   \n",
       "47103          0          0         0         0  ...          0          0   \n",
       "47104          0          0         0         0  ...          0          0   \n",
       "47105          0          0         0         0  ...          0          0   \n",
       "\n",
       "       20시하차총승객수  21시승차총승객수  21시하차총승객수  22시승차총승객수  22시하차총승객수  23시승차총승객수  \\\n",
       "0            199         22        202         42        226         20   \n",
       "1             99        420        100        357         78        205   \n",
       "2            378        168        340        202        349        118   \n",
       "3            334        402        336        386        220        321   \n",
       "4            253         53        254         43        269         52   \n",
       "...          ...        ...        ...        ...        ...        ...   \n",
       "47101          0          0          0          0          0          0   \n",
       "47102          0          0          0          0          0          0   \n",
       "47103          0          0          0          0          0          0   \n",
       "47104          0          0          0          0          0          0   \n",
       "47105          0          0          0          0          0          0   \n",
       "\n",
       "       23시하차총승객수      등록일자  \n",
       "0            179  20200203  \n",
       "1             68  20200203  \n",
       "2            246  20200203  \n",
       "3            128  20200203  \n",
       "4            175  20200203  \n",
       "...          ...       ...  \n",
       "47101          0  20210103  \n",
       "47102          0  20210103  \n",
       "47103          0  20210103  \n",
       "47104          0  20210103  \n",
       "47105          0  20210103  \n",
       "\n",
       "[47106 rows x 55 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2 = pd.read_excel('data/교통 데이터/2020년_강남구서초구버스노선별_정류장별_시간대별_승하차_인원_정보.xlsx')\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([22001, 22002, 22003, ..., 22200, 23822, 23617], dtype=int64)"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2[\"버스정류장ARS번호\"].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([ 1002,  1003,  1005, ...,  4899,  4896, 13977], dtype=int64)"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2[\"버스정류장ARS번호\"].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>사용년월</th>\n",
       "      <th>표준버스정류장ID</th>\n",
       "      <th>버스정류장ARS번호</th>\n",
       "      <th>00시승차총승객수</th>\n",
       "      <th>00시하차총승객수</th>\n",
       "      <th>1시승차총승객수</th>\n",
       "      <th>1시하차총승객수</th>\n",
       "      <th>2시승차총승객수</th>\n",
       "      <th>2시하차총승객수</th>\n",
       "      <th>3시승차총승객수</th>\n",
       "      <th>...</th>\n",
       "      <th>19시하차총승객수</th>\n",
       "      <th>20시승차총승객수</th>\n",
       "      <th>20시하차총승객수</th>\n",
       "      <th>21시승차총승객수</th>\n",
       "      <th>21시하차총승객수</th>\n",
       "      <th>22시승차총승객수</th>\n",
       "      <th>22시하차총승객수</th>\n",
       "      <th>23시승차총승객수</th>\n",
       "      <th>23시하차총승객수</th>\n",
       "      <th>등록일자</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>47106.000000</td>\n",
       "      <td>4.710600e+04</td>\n",
       "      <td>47106.000000</td>\n",
       "      <td>47106.000000</td>\n",
       "      <td>47106.000000</td>\n",
       "      <td>47106.000000</td>\n",
       "      <td>47106.000000</td>\n",
       "      <td>47106.000000</td>\n",
       "      <td>47106.000000</td>\n",
       "      <td>47106.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>47106.000000</td>\n",
       "      <td>47106.000000</td>\n",
       "      <td>47106.000000</td>\n",
       "      <td>47106.000000</td>\n",
       "      <td>47106.000000</td>\n",
       "      <td>47106.000000</td>\n",
       "      <td>47106.000000</td>\n",
       "      <td>47106.000000</td>\n",
       "      <td>47106.000000</td>\n",
       "      <td>4.710600e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>202006.492612</td>\n",
       "      <td>1.218964e+08</td>\n",
       "      <td>22846.349573</td>\n",
       "      <td>28.692990</td>\n",
       "      <td>24.676708</td>\n",
       "      <td>6.229652</td>\n",
       "      <td>5.515752</td>\n",
       "      <td>3.150214</td>\n",
       "      <td>2.482083</td>\n",
       "      <td>2.676899</td>\n",
       "      <td>...</td>\n",
       "      <td>227.622277</td>\n",
       "      <td>175.714665</td>\n",
       "      <td>149.271685</td>\n",
       "      <td>173.044368</td>\n",
       "      <td>138.154120</td>\n",
       "      <td>155.927270</td>\n",
       "      <td>128.001295</td>\n",
       "      <td>76.624613</td>\n",
       "      <td>66.058846</td>\n",
       "      <td>2.020390e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>3.453563</td>\n",
       "      <td>4.805845e+06</td>\n",
       "      <td>561.848613</td>\n",
       "      <td>87.523974</td>\n",
       "      <td>59.894269</td>\n",
       "      <td>36.422317</td>\n",
       "      <td>25.940557</td>\n",
       "      <td>24.956784</td>\n",
       "      <td>17.416613</td>\n",
       "      <td>24.598915</td>\n",
       "      <td>...</td>\n",
       "      <td>297.697488</td>\n",
       "      <td>265.138396</td>\n",
       "      <td>189.414515</td>\n",
       "      <td>266.710636</td>\n",
       "      <td>175.382688</td>\n",
       "      <td>267.264127</td>\n",
       "      <td>164.958777</td>\n",
       "      <td>153.509846</td>\n",
       "      <td>92.764677</td>\n",
       "      <td>4.608754e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>202001.000000</td>\n",
       "      <td>1.020003e+08</td>\n",
       "      <td>22001.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>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</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>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.020020e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>202003.000000</td>\n",
       "      <td>1.210002e+08</td>\n",
       "      <td>22270.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>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>49.000000</td>\n",
       "      <td>23.000000</td>\n",
       "      <td>31.000000</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>29.000000</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>23.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>2.020040e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>202006.000000</td>\n",
       "      <td>1.220000e+08</td>\n",
       "      <td>23122.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>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>140.000000</td>\n",
       "      <td>88.000000</td>\n",
       "      <td>94.000000</td>\n",
       "      <td>83.000000</td>\n",
       "      <td>87.500000</td>\n",
       "      <td>65.000000</td>\n",
       "      <td>77.000000</td>\n",
       "      <td>24.000000</td>\n",
       "      <td>34.000000</td>\n",
       "      <td>2.020090e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>202009.000000</td>\n",
       "      <td>1.220002e+08</td>\n",
       "      <td>23315.000000</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>22.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>...</td>\n",
       "      <td>289.000000</td>\n",
       "      <td>216.000000</td>\n",
       "      <td>196.000000</td>\n",
       "      <td>212.000000</td>\n",
       "      <td>180.000000</td>\n",
       "      <td>180.000000</td>\n",
       "      <td>170.000000</td>\n",
       "      <td>83.000000</td>\n",
       "      <td>88.000000</td>\n",
       "      <td>2.021010e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>202012.000000</td>\n",
       "      <td>2.220006e+08</td>\n",
       "      <td>23998.000000</td>\n",
       "      <td>1935.000000</td>\n",
       "      <td>1049.000000</td>\n",
       "      <td>1016.000000</td>\n",
       "      <td>509.000000</td>\n",
       "      <td>761.000000</td>\n",
       "      <td>534.000000</td>\n",
       "      <td>830.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>5069.000000</td>\n",
       "      <td>5609.000000</td>\n",
       "      <td>2906.000000</td>\n",
       "      <td>5648.000000</td>\n",
       "      <td>2701.000000</td>\n",
       "      <td>5214.000000</td>\n",
       "      <td>2326.000000</td>\n",
       "      <td>3310.000000</td>\n",
       "      <td>1270.000000</td>\n",
       "      <td>2.021051e+07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8 rows × 52 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                사용년월     표준버스정류장ID    버스정류장ARS번호     00시승차총승객수     00시하차총승객수  \\\n",
       "count   47106.000000  4.710600e+04  47106.000000  47106.000000  47106.000000   \n",
       "mean   202006.492612  1.218964e+08  22846.349573     28.692990     24.676708   \n",
       "std         3.453563  4.805845e+06    561.848613     87.523974     59.894269   \n",
       "min    202001.000000  1.020003e+08  22001.000000      0.000000      0.000000   \n",
       "25%    202003.000000  1.210002e+08  22270.000000      0.000000      0.000000   \n",
       "50%    202006.000000  1.220000e+08  23122.000000      0.000000      0.000000   \n",
       "75%    202009.000000  1.220002e+08  23315.000000     18.000000     22.000000   \n",
       "max    202012.000000  2.220006e+08  23998.000000   1935.000000   1049.000000   \n",
       "\n",
       "           1시승차총승객수      1시하차총승객수      2시승차총승객수      2시하차총승객수      3시승차총승객수  \\\n",
       "count  47106.000000  47106.000000  47106.000000  47106.000000  47106.000000   \n",
       "mean       6.229652      5.515752      3.150214      2.482083      2.676899   \n",
       "std       36.422317     25.940557     24.956784     17.416613     24.598915   \n",
       "min        0.000000      0.000000      0.000000      0.000000      0.000000   \n",
       "25%        0.000000      0.000000      0.000000      0.000000      0.000000   \n",
       "50%        0.000000      0.000000      0.000000      0.000000      0.000000   \n",
       "75%        0.000000      0.000000      0.000000      0.000000      0.000000   \n",
       "max     1016.000000    509.000000    761.000000    534.000000    830.000000   \n",
       "\n",
       "       ...     19시하차총승객수     20시승차총승객수     20시하차총승객수     21시승차총승객수  \\\n",
       "count  ...  47106.000000  47106.000000  47106.000000  47106.000000   \n",
       "mean   ...    227.622277    175.714665    149.271685    173.044368   \n",
       "std    ...    297.697488    265.138396    189.414515    266.710636   \n",
       "min    ...      0.000000      0.000000      0.000000      0.000000   \n",
       "25%    ...     49.000000     23.000000     31.000000     20.000000   \n",
       "50%    ...    140.000000     88.000000     94.000000     83.000000   \n",
       "75%    ...    289.000000    216.000000    196.000000    212.000000   \n",
       "max    ...   5069.000000   5609.000000   2906.000000   5648.000000   \n",
       "\n",
       "          21시하차총승객수     22시승차총승객수     22시하차총승객수     23시승차총승객수     23시하차총승객수  \\\n",
       "count  47106.000000  47106.000000  47106.000000  47106.000000  47106.000000   \n",
       "mean     138.154120    155.927270    128.001295     76.624613     66.058846   \n",
       "std      175.382688    267.264127    164.958777    153.509846     92.764677   \n",
       "min        0.000000      0.000000      0.000000      0.000000      0.000000   \n",
       "25%       29.000000     14.000000     23.000000      2.000000      6.000000   \n",
       "50%       87.500000     65.000000     77.000000     24.000000     34.000000   \n",
       "75%      180.000000    180.000000    170.000000     83.000000     88.000000   \n",
       "max     2701.000000   5214.000000   2326.000000   3310.000000   1270.000000   \n",
       "\n",
       "               등록일자  \n",
       "count  4.710600e+04  \n",
       "mean   2.020390e+07  \n",
       "std    4.608754e+03  \n",
       "min    2.020020e+07  \n",
       "25%    2.020040e+07  \n",
       "50%    2.020090e+07  \n",
       "75%    2.021010e+07  \n",
       "max    2.021051e+07  \n",
       "\n",
       "[8 rows x 52 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2 = df2[df2[\"버스정류장ARS번호\"] <= 26000]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>사용년월</th>\n",
       "      <th>노선번호</th>\n",
       "      <th>노선명</th>\n",
       "      <th>표준버스정류장ID</th>\n",
       "      <th>버스정류장ARS번호</th>\n",
       "      <th>역명</th>\n",
       "      <th>00시승차총승객수</th>\n",
       "      <th>00시하차총승객수</th>\n",
       "      <th>1시승차총승객수</th>\n",
       "      <th>1시하차총승객수</th>\n",
       "      <th>...</th>\n",
       "      <th>19시하차총승객수</th>\n",
       "      <th>20시승차총승객수</th>\n",
       "      <th>20시하차총승객수</th>\n",
       "      <th>21시승차총승객수</th>\n",
       "      <th>21시하차총승객수</th>\n",
       "      <th>22시승차총승객수</th>\n",
       "      <th>22시하차총승객수</th>\n",
       "      <th>23시승차총승객수</th>\n",
       "      <th>23시하차총승객수</th>\n",
       "      <th>등록일자</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>202001</td>\n",
       "      <td>100</td>\n",
       "      <td>100번(하계동~용산구청)</td>\n",
       "      <td>100000002</td>\n",
       "      <td>1002</td>\n",
       "      <td>창경궁.서울대학교병원</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>34</td>\n",
       "      <td>82</td>\n",
       "      <td>16</td>\n",
       "      <td>44</td>\n",
       "      <td>37</td>\n",
       "      <td>49</td>\n",
       "      <td>27</td>\n",
       "      <td>20</td>\n",
       "      <td>15</td>\n",
       "      <td>20200203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>202001</td>\n",
       "      <td>100</td>\n",
       "      <td>100번(하계동~용산구청)</td>\n",
       "      <td>100000003</td>\n",
       "      <td>1003</td>\n",
       "      <td>명륜3가.성대입구</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>156</td>\n",
       "      <td>179</td>\n",
       "      <td>102</td>\n",
       "      <td>178</td>\n",
       "      <td>96</td>\n",
       "      <td>168</td>\n",
       "      <td>62</td>\n",
       "      <td>47</td>\n",
       "      <td>18</td>\n",
       "      <td>20200203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>202001</td>\n",
       "      <td>100</td>\n",
       "      <td>100번(하계동~용산구청)</td>\n",
       "      <td>100000005</td>\n",
       "      <td>1005</td>\n",
       "      <td>혜화동로터리.여운형활동터</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>318</td>\n",
       "      <td>24</td>\n",
       "      <td>143</td>\n",
       "      <td>38</td>\n",
       "      <td>103</td>\n",
       "      <td>47</td>\n",
       "      <td>76</td>\n",
       "      <td>6</td>\n",
       "      <td>28</td>\n",
       "      <td>20200203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>202001</td>\n",
       "      <td>100</td>\n",
       "      <td>100번(하계동~용산구청)</td>\n",
       "      <td>100000102</td>\n",
       "      <td>1198</td>\n",
       "      <td>원남동</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>98</td>\n",
       "      <td>167</td>\n",
       "      <td>85</td>\n",
       "      <td>109</td>\n",
       "      <td>87</td>\n",
       "      <td>97</td>\n",
       "      <td>35</td>\n",
       "      <td>26</td>\n",
       "      <td>13</td>\n",
       "      <td>20200203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>202001</td>\n",
       "      <td>100</td>\n",
       "      <td>100번(하계동~용산구청)</td>\n",
       "      <td>100000108</td>\n",
       "      <td>1204</td>\n",
       "      <td>종로5가.효제동.김상옥의거터</td>\n",
       "      <td>19</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>56</td>\n",
       "      <td>68</td>\n",
       "      <td>24</td>\n",
       "      <td>75</td>\n",
       "      <td>39</td>\n",
       "      <td>59</td>\n",
       "      <td>31</td>\n",
       "      <td>23</td>\n",
       "      <td>28</td>\n",
       "      <td>20200203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468780</th>\n",
       "      <td>202012</td>\n",
       "      <td>9714</td>\n",
       "      <td>9714번(교하운정~서울역)</td>\n",
       "      <td>111000008</td>\n",
       "      <td>12008</td>\n",
       "      <td>디지털미디어시티역</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>34</td>\n",
       "      <td>14</td>\n",
       "      <td>42</td>\n",
       "      <td>2</td>\n",
       "      <td>31</td>\n",
       "      <td>6</td>\n",
       "      <td>14</td>\n",
       "      <td>1</td>\n",
       "      <td>20210103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468781</th>\n",
       "      <td>202012</td>\n",
       "      <td>9714</td>\n",
       "      <td>9714번(교하운정~서울역)</td>\n",
       "      <td>112000005</td>\n",
       "      <td>13005</td>\n",
       "      <td>모래내시장.가좌역</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>20210103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468782</th>\n",
       "      <td>202012</td>\n",
       "      <td>9714</td>\n",
       "      <td>9714번(교하운정~서울역)</td>\n",
       "      <td>112000006</td>\n",
       "      <td>13006</td>\n",
       "      <td>모래내시장.가좌역</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>20210103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468783</th>\n",
       "      <td>202012</td>\n",
       "      <td>9714</td>\n",
       "      <td>9714번(교하운정~서울역)</td>\n",
       "      <td>112000012</td>\n",
       "      <td>13012</td>\n",
       "      <td>연세대앞</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>20210103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468784</th>\n",
       "      <td>202012</td>\n",
       "      <td>9714</td>\n",
       "      <td>9714번(교하운정~서울역)</td>\n",
       "      <td>112000013</td>\n",
       "      <td>13013</td>\n",
       "      <td>연세대앞</td>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>85</td>\n",
       "      <td>5</td>\n",
       "      <td>77</td>\n",
       "      <td>1</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>20210103</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>422171 rows × 55 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          사용년월  노선번호              노선명  표준버스정류장ID  버스정류장ARS번호               역명  \\\n",
       "0       202001   100   100번(하계동~용산구청)  100000002        1002      창경궁.서울대학교병원   \n",
       "1       202001   100   100번(하계동~용산구청)  100000003        1003        명륜3가.성대입구   \n",
       "2       202001   100   100번(하계동~용산구청)  100000005        1005    혜화동로터리.여운형활동터   \n",
       "3       202001   100   100번(하계동~용산구청)  100000102        1198              원남동   \n",
       "4       202001   100   100번(하계동~용산구청)  100000108        1204  종로5가.효제동.김상옥의거터   \n",
       "...        ...   ...              ...        ...         ...              ...   \n",
       "468780  202012  9714  9714번(교하운정~서울역)  111000008       12008        디지털미디어시티역   \n",
       "468781  202012  9714  9714번(교하운정~서울역)  112000005       13005        모래내시장.가좌역   \n",
       "468782  202012  9714  9714번(교하운정~서울역)  112000006       13006        모래내시장.가좌역   \n",
       "468783  202012  9714  9714번(교하운정~서울역)  112000012       13012             연세대앞   \n",
       "468784  202012  9714  9714번(교하운정~서울역)  112000013       13013             연세대앞   \n",
       "\n",
       "        00시승차총승객수  00시하차총승객수  1시승차총승객수  1시하차총승객수  ...  19시하차총승객수  20시승차총승객수  \\\n",
       "0               1          0         0         0  ...         34         82   \n",
       "1               0          0         0         0  ...        156        179   \n",
       "2               0          2         0         0  ...        318         24   \n",
       "3               0          0         0         0  ...         98        167   \n",
       "4              19         34         1         0  ...         56         68   \n",
       "...           ...        ...       ...       ...  ...        ...        ...   \n",
       "468780          7          1         4         3  ...         15         34   \n",
       "468781          2          6         5        10  ...          6          1   \n",
       "468782          3          1         1         0  ...          0          2   \n",
       "468783          0          5         0         7  ...          6          0   \n",
       "468784         16          1         9         1  ...          0         85   \n",
       "\n",
       "        20시하차총승객수  21시승차총승객수  21시하차총승객수  22시승차총승객수  22시하차총승객수  23시승차총승객수  \\\n",
       "0              16         44         37         49         27         20   \n",
       "1             102        178         96        168         62         47   \n",
       "2             143         38        103         47         76          6   \n",
       "3              85        109         87         97         35         26   \n",
       "4              24         75         39         59         31         23   \n",
       "...           ...        ...        ...        ...        ...        ...   \n",
       "468780         14         42          2         31          6         14   \n",
       "468781         11          0          7          0         11          0   \n",
       "468782          5          8          2         11          0          4   \n",
       "468783          7          0          7          2          7          1   \n",
       "468784          5         77          1         34          1         29   \n",
       "\n",
       "        23시하차총승객수      등록일자  \n",
       "0              15  20200203  \n",
       "1              18  20200203  \n",
       "2              28  20200203  \n",
       "3              13  20200203  \n",
       "4              28  20200203  \n",
       "...           ...       ...  \n",
       "468780          1  20210103  \n",
       "468781          6  20210103  \n",
       "468782          0  20210103  \n",
       "468783          6  20210103  \n",
       "468784          0  20210103  \n",
       "\n",
       "[422171 rows x 55 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "사용년월           int64\n",
       "노선번호          object\n",
       "노선명           object\n",
       "표준버스정류장ID     object\n",
       "버스정류장ARS번호     int64\n",
       "역명            object\n",
       "00시승차총승객수      int64\n",
       "00시하차총승객수      int64\n",
       "1시승차총승객수       int64\n",
       "1시하차총승객수       int64\n",
       "2시승차총승객수       int64\n",
       "2시하차총승객수       int64\n",
       "3시승차총승객수       int64\n",
       "3시하차총승객수       int64\n",
       "4시승차총승객수       int64\n",
       "4시하차총승객수       int64\n",
       "5시승차총승객수       int64\n",
       "5시하차총승객수       int64\n",
       "6시승차총승객수       int64\n",
       "6시하차총승객수       int64\n",
       "7시승차총승객수       int64\n",
       "7시하차총승객수       int64\n",
       "8시승차총승객수       int64\n",
       "8시하차총승객수       int64\n",
       "9시승차총승객수       int64\n",
       "9시하차총승객수       int64\n",
       "10시승차총승객수      int64\n",
       "10시하차총승객수      int64\n",
       "11시승차총승객수      int64\n",
       "11시하차총승객수      int64\n",
       "12시승차총승객수      int64\n",
       "12시하차총승객수      int64\n",
       "13시승차총승객수      int64\n",
       "13시하차총승객수      int64\n",
       "14시승차총승객수      int64\n",
       "14시하차총승객수      int64\n",
       "15시승차총승객수      int64\n",
       "15시하차총승객수      int64\n",
       "16시승차총승객수      int64\n",
       "16시하차총승객수      int64\n",
       "17시승차총승객수      int64\n",
       "17시하차총승객수      int64\n",
       "18시승차총승객수      int64\n",
       "18시하차총승객수      int64\n",
       "19시승차총승객수      int64\n",
       "19시하차총승객수      int64\n",
       "20시승차총승객수      int64\n",
       "20시하차총승객수      int64\n",
       "21시승차총승객수      int64\n",
       "21시하차총승객수      int64\n",
       "22시승차총승객수      int64\n",
       "22시하차총승객수      int64\n",
       "23시승차총승객수      int64\n",
       "23시하차총승객수      int64\n",
       "등록일자           int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>사용년월</th>\n",
       "      <th>노선번호</th>\n",
       "      <th>노선명</th>\n",
       "      <th>표준버스정류장ID</th>\n",
       "      <th>버스정류장ARS번호</th>\n",
       "      <th>역명</th>\n",
       "      <th>00시승차총승객수</th>\n",
       "      <th>00시하차총승객수</th>\n",
       "      <th>1시승차총승객수</th>\n",
       "      <th>1시하차총승객수</th>\n",
       "      <th>...</th>\n",
       "      <th>19시하차총승객수</th>\n",
       "      <th>20시승차총승객수</th>\n",
       "      <th>20시하차총승객수</th>\n",
       "      <th>21시승차총승객수</th>\n",
       "      <th>21시하차총승객수</th>\n",
       "      <th>22시승차총승객수</th>\n",
       "      <th>22시하차총승객수</th>\n",
       "      <th>23시승차총승객수</th>\n",
       "      <th>23시하차총승객수</th>\n",
       "      <th>등록일자</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6130</th>\n",
       "      <td>202002</td>\n",
       "      <td>강남06</td>\n",
       "      <td>강남06(세곡LH푸르지오아파트~코엑스)</td>\n",
       "      <td>122900072</td>\n",
       "      <td>23998</td>\n",
       "      <td>은곡마을입구.세곡리엔파크</td>\n",
       "      <td>0</td>\n",
       "      <td>43</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>856</td>\n",
       "      <td>13</td>\n",
       "      <td>595</td>\n",
       "      <td>11</td>\n",
       "      <td>508</td>\n",
       "      <td>30</td>\n",
       "      <td>496</td>\n",
       "      <td>15</td>\n",
       "      <td>379</td>\n",
       "      <td>20200303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21827</th>\n",
       "      <td>202006</td>\n",
       "      <td>강남06</td>\n",
       "      <td>강남06(세곡LH푸르지오아파트~코엑스)</td>\n",
       "      <td>122900072</td>\n",
       "      <td>23998</td>\n",
       "      <td>은곡마을입구.세곡리엔파크</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>458</td>\n",
       "      <td>15</td>\n",
       "      <td>287</td>\n",
       "      <td>5</td>\n",
       "      <td>276</td>\n",
       "      <td>12</td>\n",
       "      <td>295</td>\n",
       "      <td>3</td>\n",
       "      <td>175</td>\n",
       "      <td>20210512</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10050</th>\n",
       "      <td>202003</td>\n",
       "      <td>강남06</td>\n",
       "      <td>강남06(세곡LH푸르지오아파트~코엑스)</td>\n",
       "      <td>122900072</td>\n",
       "      <td>23998</td>\n",
       "      <td>은곡마을입구.세곡리엔파크</td>\n",
       "      <td>4</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>795</td>\n",
       "      <td>3</td>\n",
       "      <td>553</td>\n",
       "      <td>5</td>\n",
       "      <td>417</td>\n",
       "      <td>12</td>\n",
       "      <td>490</td>\n",
       "      <td>13</td>\n",
       "      <td>294</td>\n",
       "      <td>20200403</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2197</th>\n",
       "      <td>202001</td>\n",
       "      <td>강남06</td>\n",
       "      <td>강남06(세곡LH푸르지오아파트~코엑스)</td>\n",
       "      <td>122900072</td>\n",
       "      <td>23998</td>\n",
       "      <td>은곡마을입구.세곡리엔파크</td>\n",
       "      <td>3</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1046</td>\n",
       "      <td>11</td>\n",
       "      <td>714</td>\n",
       "      <td>12</td>\n",
       "      <td>617</td>\n",
       "      <td>29</td>\n",
       "      <td>627</td>\n",
       "      <td>18</td>\n",
       "      <td>504</td>\n",
       "      <td>20200203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13974</th>\n",
       "      <td>202004</td>\n",
       "      <td>강남06</td>\n",
       "      <td>강남06(세곡LH푸르지오아파트~코엑스)</td>\n",
       "      <td>122900072</td>\n",
       "      <td>23998</td>\n",
       "      <td>은곡마을입구.세곡리엔파크</td>\n",
       "      <td>2</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>857</td>\n",
       "      <td>14</td>\n",
       "      <td>637</td>\n",
       "      <td>3</td>\n",
       "      <td>481</td>\n",
       "      <td>10</td>\n",
       "      <td>516</td>\n",
       "      <td>9</td>\n",
       "      <td>342</td>\n",
       "      <td>20200503</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15335</th>\n",
       "      <td>202004</td>\n",
       "      <td>440</td>\n",
       "      <td>440번(송파공영차고지~압구정동)</td>\n",
       "      <td>121000001</td>\n",
       "      <td>22001</td>\n",
       "      <td>교육개발원입구</td>\n",
       "      <td>54</td>\n",
       "      <td>67</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>96</td>\n",
       "      <td>166</td>\n",
       "      <td>113</td>\n",
       "      <td>134</td>\n",
       "      <td>98</td>\n",
       "      <td>161</td>\n",
       "      <td>101</td>\n",
       "      <td>87</td>\n",
       "      <td>69</td>\n",
       "      <td>20200503</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11636</th>\n",
       "      <td>202003</td>\n",
       "      <td>9404</td>\n",
       "      <td>9404번(분당구미~신사역)</td>\n",
       "      <td>121000001</td>\n",
       "      <td>22001</td>\n",
       "      <td>교육개발원입구</td>\n",
       "      <td>23</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>176</td>\n",
       "      <td>2</td>\n",
       "      <td>153</td>\n",
       "      <td>2</td>\n",
       "      <td>124</td>\n",
       "      <td>4</td>\n",
       "      <td>75</td>\n",
       "      <td>3</td>\n",
       "      <td>20200403</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34778</th>\n",
       "      <td>202009</td>\n",
       "      <td>470</td>\n",
       "      <td>470번(상암차고지~안골마을)</td>\n",
       "      <td>121000001</td>\n",
       "      <td>22001</td>\n",
       "      <td>교육개발원입구</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>216</td>\n",
       "      <td>47</td>\n",
       "      <td>134</td>\n",
       "      <td>34</td>\n",
       "      <td>99</td>\n",
       "      <td>37</td>\n",
       "      <td>107</td>\n",
       "      <td>15</td>\n",
       "      <td>74</td>\n",
       "      <td>20210512</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11589</th>\n",
       "      <td>202003</td>\n",
       "      <td>9408</td>\n",
       "      <td>9408번(성남 분당~영등포)</td>\n",
       "      <td>121000001</td>\n",
       "      <td>22001</td>\n",
       "      <td>교육개발원입구</td>\n",
       "      <td>18</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>11</td>\n",
       "      <td>61</td>\n",
       "      <td>5</td>\n",
       "      <td>83</td>\n",
       "      <td>9</td>\n",
       "      <td>63</td>\n",
       "      <td>6</td>\n",
       "      <td>40</td>\n",
       "      <td>19</td>\n",
       "      <td>20200403</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>202001</td>\n",
       "      <td>140</td>\n",
       "      <td>140번(도봉산역~AT센터)</td>\n",
       "      <td>121000001</td>\n",
       "      <td>22001</td>\n",
       "      <td>교육개발원입구</td>\n",
       "      <td>3</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>309</td>\n",
       "      <td>32</td>\n",
       "      <td>199</td>\n",
       "      <td>22</td>\n",
       "      <td>202</td>\n",
       "      <td>42</td>\n",
       "      <td>226</td>\n",
       "      <td>20</td>\n",
       "      <td>179</td>\n",
       "      <td>20200203</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>47106 rows × 55 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         사용년월  노선번호                    노선명  표준버스정류장ID  버스정류장ARS번호  \\\n",
       "6130   202002  강남06  강남06(세곡LH푸르지오아파트~코엑스)  122900072       23998   \n",
       "21827  202006  강남06  강남06(세곡LH푸르지오아파트~코엑스)  122900072       23998   \n",
       "10050  202003  강남06  강남06(세곡LH푸르지오아파트~코엑스)  122900072       23998   \n",
       "2197   202001  강남06  강남06(세곡LH푸르지오아파트~코엑스)  122900072       23998   \n",
       "13974  202004  강남06  강남06(세곡LH푸르지오아파트~코엑스)  122900072       23998   \n",
       "...       ...   ...                    ...        ...         ...   \n",
       "15335  202004   440     440번(송파공영차고지~압구정동)  121000001       22001   \n",
       "11636  202003  9404        9404번(분당구미~신사역)  121000001       22001   \n",
       "34778  202009   470       470번(상암차고지~안골마을)  121000001       22001   \n",
       "11589  202003  9408       9408번(성남 분당~영등포)  121000001       22001   \n",
       "0      202001   140        140번(도봉산역~AT센터)  121000001       22001   \n",
       "\n",
       "                  역명  00시승차총승객수  00시하차총승객수  1시승차총승객수  1시하차총승객수  ...  \\\n",
       "6130   은곡마을입구.세곡리엔파크          0         43         0         0  ...   \n",
       "21827  은곡마을입구.세곡리엔파크          1         18         0         0  ...   \n",
       "10050  은곡마을입구.세곡리엔파크          4         27         0         0  ...   \n",
       "2197   은곡마을입구.세곡리엔파크          3         40         0         0  ...   \n",
       "13974  은곡마을입구.세곡리엔파크          2         25         0         0  ...   \n",
       "...              ...        ...        ...       ...       ...  ...   \n",
       "15335        교육개발원입구         54         67         0         0  ...   \n",
       "11636        교육개발원입구         23          5         0         0  ...   \n",
       "34778        교육개발원입구          0          0         0         0  ...   \n",
       "11589        교육개발원입구         18         12         0         0  ...   \n",
       "0            교육개발원입구          3         35         0         0  ...   \n",
       "\n",
       "       19시하차총승객수  20시승차총승객수  20시하차총승객수  21시승차총승객수  21시하차총승객수  22시승차총승객수  \\\n",
       "6130         856         13        595         11        508         30   \n",
       "21827        458         15        287          5        276         12   \n",
       "10050        795          3        553          5        417         12   \n",
       "2197        1046         11        714         12        617         29   \n",
       "13974        857         14        637          3        481         10   \n",
       "...          ...        ...        ...        ...        ...        ...   \n",
       "15335         96        166        113        134         98        161   \n",
       "11636          2        176          2        153          2        124   \n",
       "34778        216         47        134         34         99         37   \n",
       "11589         11         61          5         83          9         63   \n",
       "0            309         32        199         22        202         42   \n",
       "\n",
       "       22시하차총승객수  23시승차총승객수  23시하차총승객수      등록일자  \n",
       "6130         496         15        379  20200303  \n",
       "21827        295          3        175  20210512  \n",
       "10050        490         13        294  20200403  \n",
       "2197         627         18        504  20200203  \n",
       "13974        516          9        342  20200503  \n",
       "...          ...        ...        ...       ...  \n",
       "15335        101         87         69  20200503  \n",
       "11636          4         75          3  20200403  \n",
       "34778        107         15         74  20210512  \n",
       "11589          6         40         19  20200403  \n",
       "0            226         20        179  20200203  \n",
       "\n",
       "[47106 rows x 55 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.sort_values(by='버스정류장ARS번호',ascending = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>사용년월</th>\n",
       "      <th>노선번호</th>\n",
       "      <th>노선명</th>\n",
       "      <th>표준버스정류장ID</th>\n",
       "      <th>버스정류장ARS번호</th>\n",
       "      <th>역명</th>\n",
       "      <th>00시승차총승객수</th>\n",
       "      <th>00시하차총승객수</th>\n",
       "      <th>1시승차총승객수</th>\n",
       "      <th>1시하차총승객수</th>\n",
       "      <th>...</th>\n",
       "      <th>19시하차총승객수</th>\n",
       "      <th>20시승차총승객수</th>\n",
       "      <th>20시하차총승객수</th>\n",
       "      <th>21시승차총승객수</th>\n",
       "      <th>21시하차총승객수</th>\n",
       "      <th>22시승차총승객수</th>\n",
       "      <th>22시하차총승객수</th>\n",
       "      <th>23시승차총승객수</th>\n",
       "      <th>23시하차총승객수</th>\n",
       "      <th>등록일자</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>202001</td>\n",
       "      <td>100</td>\n",
       "      <td>100번(하계동~용산구청)</td>\n",
       "      <td>100000002</td>\n",
       "      <td>1002</td>\n",
       "      <td>창경궁.서울대학교병원</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>34</td>\n",
       "      <td>82</td>\n",
       "      <td>16</td>\n",
       "      <td>44</td>\n",
       "      <td>37</td>\n",
       "      <td>49</td>\n",
       "      <td>27</td>\n",
       "      <td>20</td>\n",
       "      <td>15</td>\n",
       "      <td>20200203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>202001</td>\n",
       "      <td>100</td>\n",
       "      <td>100번(하계동~용산구청)</td>\n",
       "      <td>100000003</td>\n",
       "      <td>1003</td>\n",
       "      <td>명륜3가.성대입구</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>156</td>\n",
       "      <td>179</td>\n",
       "      <td>102</td>\n",
       "      <td>178</td>\n",
       "      <td>96</td>\n",
       "      <td>168</td>\n",
       "      <td>62</td>\n",
       "      <td>47</td>\n",
       "      <td>18</td>\n",
       "      <td>20200203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>202001</td>\n",
       "      <td>100</td>\n",
       "      <td>100번(하계동~용산구청)</td>\n",
       "      <td>100000005</td>\n",
       "      <td>1005</td>\n",
       "      <td>혜화동로터리.여운형활동터</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>318</td>\n",
       "      <td>24</td>\n",
       "      <td>143</td>\n",
       "      <td>38</td>\n",
       "      <td>103</td>\n",
       "      <td>47</td>\n",
       "      <td>76</td>\n",
       "      <td>6</td>\n",
       "      <td>28</td>\n",
       "      <td>20200203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>202001</td>\n",
       "      <td>100</td>\n",
       "      <td>100번(하계동~용산구청)</td>\n",
       "      <td>100000102</td>\n",
       "      <td>1198</td>\n",
       "      <td>원남동</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>98</td>\n",
       "      <td>167</td>\n",
       "      <td>85</td>\n",
       "      <td>109</td>\n",
       "      <td>87</td>\n",
       "      <td>97</td>\n",
       "      <td>35</td>\n",
       "      <td>26</td>\n",
       "      <td>13</td>\n",
       "      <td>20200203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>202001</td>\n",
       "      <td>100</td>\n",
       "      <td>100번(하계동~용산구청)</td>\n",
       "      <td>100000108</td>\n",
       "      <td>1204</td>\n",
       "      <td>종로5가.효제동.김상옥의거터</td>\n",
       "      <td>19</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>56</td>\n",
       "      <td>68</td>\n",
       "      <td>24</td>\n",
       "      <td>75</td>\n",
       "      <td>39</td>\n",
       "      <td>59</td>\n",
       "      <td>31</td>\n",
       "      <td>23</td>\n",
       "      <td>28</td>\n",
       "      <td>20200203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468780</th>\n",
       "      <td>202012</td>\n",
       "      <td>9714</td>\n",
       "      <td>9714번(교하운정~서울역)</td>\n",
       "      <td>111000008</td>\n",
       "      <td>12008</td>\n",
       "      <td>디지털미디어시티역</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>34</td>\n",
       "      <td>14</td>\n",
       "      <td>42</td>\n",
       "      <td>2</td>\n",
       "      <td>31</td>\n",
       "      <td>6</td>\n",
       "      <td>14</td>\n",
       "      <td>1</td>\n",
       "      <td>20210103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468781</th>\n",
       "      <td>202012</td>\n",
       "      <td>9714</td>\n",
       "      <td>9714번(교하운정~서울역)</td>\n",
       "      <td>112000005</td>\n",
       "      <td>13005</td>\n",
       "      <td>모래내시장.가좌역</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>20210103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468782</th>\n",
       "      <td>202012</td>\n",
       "      <td>9714</td>\n",
       "      <td>9714번(교하운정~서울역)</td>\n",
       "      <td>112000006</td>\n",
       "      <td>13006</td>\n",
       "      <td>모래내시장.가좌역</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>20210103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468783</th>\n",
       "      <td>202012</td>\n",
       "      <td>9714</td>\n",
       "      <td>9714번(교하운정~서울역)</td>\n",
       "      <td>112000012</td>\n",
       "      <td>13012</td>\n",
       "      <td>연세대앞</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>20210103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468784</th>\n",
       "      <td>202012</td>\n",
       "      <td>9714</td>\n",
       "      <td>9714번(교하운정~서울역)</td>\n",
       "      <td>112000013</td>\n",
       "      <td>13013</td>\n",
       "      <td>연세대앞</td>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>85</td>\n",
       "      <td>5</td>\n",
       "      <td>77</td>\n",
       "      <td>1</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>20210103</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>422171 rows × 55 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          사용년월  노선번호              노선명  표준버스정류장ID  버스정류장ARS번호               역명  \\\n",
       "0       202001   100   100번(하계동~용산구청)  100000002        1002      창경궁.서울대학교병원   \n",
       "1       202001   100   100번(하계동~용산구청)  100000003        1003        명륜3가.성대입구   \n",
       "2       202001   100   100번(하계동~용산구청)  100000005        1005    혜화동로터리.여운형활동터   \n",
       "3       202001   100   100번(하계동~용산구청)  100000102        1198              원남동   \n",
       "4       202001   100   100번(하계동~용산구청)  100000108        1204  종로5가.효제동.김상옥의거터   \n",
       "...        ...   ...              ...        ...         ...              ...   \n",
       "468780  202012  9714  9714번(교하운정~서울역)  111000008       12008        디지털미디어시티역   \n",
       "468781  202012  9714  9714번(교하운정~서울역)  112000005       13005        모래내시장.가좌역   \n",
       "468782  202012  9714  9714번(교하운정~서울역)  112000006       13006        모래내시장.가좌역   \n",
       "468783  202012  9714  9714번(교하운정~서울역)  112000012       13012             연세대앞   \n",
       "468784  202012  9714  9714번(교하운정~서울역)  112000013       13013             연세대앞   \n",
       "\n",
       "        00시승차총승객수  00시하차총승객수  1시승차총승객수  1시하차총승객수  ...  19시하차총승객수  20시승차총승객수  \\\n",
       "0               1          0         0         0  ...         34         82   \n",
       "1               0          0         0         0  ...        156        179   \n",
       "2               0          2         0         0  ...        318         24   \n",
       "3               0          0         0         0  ...         98        167   \n",
       "4              19         34         1         0  ...         56         68   \n",
       "...           ...        ...       ...       ...  ...        ...        ...   \n",
       "468780          7          1         4         3  ...         15         34   \n",
       "468781          2          6         5        10  ...          6          1   \n",
       "468782          3          1         1         0  ...          0          2   \n",
       "468783          0          5         0         7  ...          6          0   \n",
       "468784         16          1         9         1  ...          0         85   \n",
       "\n",
       "        20시하차총승객수  21시승차총승객수  21시하차총승객수  22시승차총승객수  22시하차총승객수  23시승차총승객수  \\\n",
       "0              16         44         37         49         27         20   \n",
       "1             102        178         96        168         62         47   \n",
       "2             143         38        103         47         76          6   \n",
       "3              85        109         87         97         35         26   \n",
       "4              24         75         39         59         31         23   \n",
       "...           ...        ...        ...        ...        ...        ...   \n",
       "468780         14         42          2         31          6         14   \n",
       "468781         11          0          7          0         11          0   \n",
       "468782          5          8          2         11          0          4   \n",
       "468783          7          0          7          2          7          1   \n",
       "468784          5         77          1         34          1         29   \n",
       "\n",
       "        23시하차총승객수      등록일자  \n",
       "0              15  20200203  \n",
       "1              18  20200203  \n",
       "2              28  20200203  \n",
       "3              13  20200203  \n",
       "4              28  20200203  \n",
       "...           ...       ...  \n",
       "468780          1  20210103  \n",
       "468781          6  20210103  \n",
       "468782          0  20210103  \n",
       "468783          6  20210103  \n",
       "468784          0  20210103  \n",
       "\n",
       "[422171 rows x 55 columns]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        22001\n",
       "1        22002\n",
       "2        22003\n",
       "3        22004\n",
       "4        22005\n",
       "         ...  \n",
       "47101    22033\n",
       "47102    22031\n",
       "47103    22029\n",
       "47104    22027\n",
       "47105    23285\n",
       "Name: 버스정류장ARS번호, Length: 47106, dtype: int64"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2[\"버스정류장ARS번호\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>사용년월</th>\n",
       "      <th>노선번호</th>\n",
       "      <th>노선명</th>\n",
       "      <th>표준버스정류장ID</th>\n",
       "      <th>버스정류장ARS번호</th>\n",
       "      <th>역명</th>\n",
       "      <th>00시승차총승객수</th>\n",
       "      <th>00시하차총승객수</th>\n",
       "      <th>1시승차총승객수</th>\n",
       "      <th>1시하차총승객수</th>\n",
       "      <th>...</th>\n",
       "      <th>19시하차총승객수</th>\n",
       "      <th>20시승차총승객수</th>\n",
       "      <th>20시하차총승객수</th>\n",
       "      <th>21시승차총승객수</th>\n",
       "      <th>21시하차총승객수</th>\n",
       "      <th>22시승차총승객수</th>\n",
       "      <th>22시하차총승객수</th>\n",
       "      <th>23시승차총승객수</th>\n",
       "      <th>23시하차총승객수</th>\n",
       "      <th>등록일자</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>202001</td>\n",
       "      <td>140</td>\n",
       "      <td>140번(도봉산역~AT센터)</td>\n",
       "      <td>121000001</td>\n",
       "      <td>22001</td>\n",
       "      <td>교육개발원입구</td>\n",
       "      <td>3</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>309</td>\n",
       "      <td>32</td>\n",
       "      <td>199</td>\n",
       "      <td>22</td>\n",
       "      <td>202</td>\n",
       "      <td>42</td>\n",
       "      <td>226</td>\n",
       "      <td>20</td>\n",
       "      <td>179</td>\n",
       "      <td>20200203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>202001</td>\n",
       "      <td>140</td>\n",
       "      <td>140번(도봉산역~AT센터)</td>\n",
       "      <td>121000002</td>\n",
       "      <td>22002</td>\n",
       "      <td>교육개발원입구</td>\n",
       "      <td>59</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>145</td>\n",
       "      <td>412</td>\n",
       "      <td>99</td>\n",
       "      <td>420</td>\n",
       "      <td>100</td>\n",
       "      <td>357</td>\n",
       "      <td>78</td>\n",
       "      <td>205</td>\n",
       "      <td>68</td>\n",
       "      <td>20200203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>202001</td>\n",
       "      <td>140</td>\n",
       "      <td>140번(도봉산역~AT센터)</td>\n",
       "      <td>121000003</td>\n",
       "      <td>22003</td>\n",
       "      <td>양재역.서초문화예술회관</td>\n",
       "      <td>43</td>\n",
       "      <td>55</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>527</td>\n",
       "      <td>144</td>\n",
       "      <td>378</td>\n",
       "      <td>168</td>\n",
       "      <td>340</td>\n",
       "      <td>202</td>\n",
       "      <td>349</td>\n",
       "      <td>118</td>\n",
       "      <td>246</td>\n",
       "      <td>20200203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>202001</td>\n",
       "      <td>140</td>\n",
       "      <td>140번(도봉산역~AT센터)</td>\n",
       "      <td>121000004</td>\n",
       "      <td>22004</td>\n",
       "      <td>양재역.서초문화예술회관</td>\n",
       "      <td>141</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>498</td>\n",
       "      <td>442</td>\n",
       "      <td>334</td>\n",
       "      <td>402</td>\n",
       "      <td>336</td>\n",
       "      <td>386</td>\n",
       "      <td>220</td>\n",
       "      <td>321</td>\n",
       "      <td>128</td>\n",
       "      <td>20200203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>202001</td>\n",
       "      <td>140</td>\n",
       "      <td>140번(도봉산역~AT센터)</td>\n",
       "      <td>121000005</td>\n",
       "      <td>22005</td>\n",
       "      <td>뱅뱅사거리</td>\n",
       "      <td>7</td>\n",
       "      <td>54</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>388</td>\n",
       "      <td>74</td>\n",
       "      <td>253</td>\n",
       "      <td>53</td>\n",
       "      <td>254</td>\n",
       "      <td>43</td>\n",
       "      <td>269</td>\n",
       "      <td>52</td>\n",
       "      <td>175</td>\n",
       "      <td>20200203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47101</th>\n",
       "      <td>202012</td>\n",
       "      <td>8541</td>\n",
       "      <td>8541번(호압사~강남역)</td>\n",
       "      <td>121000530</td>\n",
       "      <td>22033</td>\n",
       "      <td>정금마을</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20210103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47102</th>\n",
       "      <td>202012</td>\n",
       "      <td>8541</td>\n",
       "      <td>8541번(호압사~강남역)</td>\n",
       "      <td>121000531</td>\n",
       "      <td>22031</td>\n",
       "      <td>경문고등학교</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20210103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47103</th>\n",
       "      <td>202012</td>\n",
       "      <td>8541</td>\n",
       "      <td>8541번(호압사~강남역)</td>\n",
       "      <td>121000532</td>\n",
       "      <td>22029</td>\n",
       "      <td>총신대입구역.남성시장입구앞</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20210103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47104</th>\n",
       "      <td>202012</td>\n",
       "      <td>8541</td>\n",
       "      <td>8541번(호압사~강남역)</td>\n",
       "      <td>121000533</td>\n",
       "      <td>22027</td>\n",
       "      <td>이수역</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20210103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47105</th>\n",
       "      <td>202012</td>\n",
       "      <td>8541</td>\n",
       "      <td>8541번(호압사~강남역)</td>\n",
       "      <td>122000182</td>\n",
       "      <td>23285</td>\n",
       "      <td>강남역</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20210103</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>47106 rows × 55 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         사용년월  노선번호              노선명  표준버스정류장ID  버스정류장ARS번호              역명  \\\n",
       "0      202001   140  140번(도봉산역~AT센터)  121000001       22001         교육개발원입구   \n",
       "1      202001   140  140번(도봉산역~AT센터)  121000002       22002         교육개발원입구   \n",
       "2      202001   140  140번(도봉산역~AT센터)  121000003       22003    양재역.서초문화예술회관   \n",
       "3      202001   140  140번(도봉산역~AT센터)  121000004       22004    양재역.서초문화예술회관   \n",
       "4      202001   140  140번(도봉산역~AT센터)  121000005       22005           뱅뱅사거리   \n",
       "...       ...   ...              ...        ...         ...             ...   \n",
       "47101  202012  8541   8541번(호압사~강남역)  121000530       22033            정금마을   \n",
       "47102  202012  8541   8541번(호압사~강남역)  121000531       22031          경문고등학교   \n",
       "47103  202012  8541   8541번(호압사~강남역)  121000532       22029  총신대입구역.남성시장입구앞   \n",
       "47104  202012  8541   8541번(호압사~강남역)  121000533       22027             이수역   \n",
       "47105  202012  8541   8541번(호압사~강남역)  122000182       23285             강남역   \n",
       "\n",
       "       00시승차총승객수  00시하차총승객수  1시승차총승객수  1시하차총승객수  ...  19시하차총승객수  20시승차총승객수  \\\n",
       "0              3         35         0         0  ...        309         32   \n",
       "1             59         18         0         0  ...        145        412   \n",
       "2             43         55         0         0  ...        527        144   \n",
       "3            141         34         0         0  ...        498        442   \n",
       "4              7         54         0         0  ...        388         74   \n",
       "...          ...        ...       ...       ...  ...        ...        ...   \n",
       "47101          0          0         0         0  ...          0          0   \n",
       "47102          0          0         0         0  ...          0          0   \n",
       "47103          0          0         0         0  ...          0          0   \n",
       "47104          0          0         0         0  ...          0          0   \n",
       "47105          0          0         0         0  ...          0          0   \n",
       "\n",
       "       20시하차총승객수  21시승차총승객수  21시하차총승객수  22시승차총승객수  22시하차총승객수  23시승차총승객수  \\\n",
       "0            199         22        202         42        226         20   \n",
       "1             99        420        100        357         78        205   \n",
       "2            378        168        340        202        349        118   \n",
       "3            334        402        336        386        220        321   \n",
       "4            253         53        254         43        269         52   \n",
       "...          ...        ...        ...        ...        ...        ...   \n",
       "47101          0          0          0          0          0          0   \n",
       "47102          0          0          0          0          0          0   \n",
       "47103          0          0          0          0          0          0   \n",
       "47104          0          0          0          0          0          0   \n",
       "47105          0          0          0          0          0          0   \n",
       "\n",
       "       23시하차총승객수      등록일자  \n",
       "0            179  20200203  \n",
       "1             68  20200203  \n",
       "2            246  20200203  \n",
       "3            128  20200203  \n",
       "4            175  20200203  \n",
       "...          ...       ...  \n",
       "47101          0  20210103  \n",
       "47102          0  20210103  \n",
       "47103          0  20210103  \n",
       "47104          0  20210103  \n",
       "47105          0  20210103  \n",
       "\n",
       "[47106 rows x 55 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>사용년월</th>\n",
       "      <th>표준버스정류장ID</th>\n",
       "      <th>00시승차총승객수</th>\n",
       "      <th>00시하차총승객수</th>\n",
       "      <th>1시승차총승객수</th>\n",
       "      <th>1시하차총승객수</th>\n",
       "      <th>2시승차총승객수</th>\n",
       "      <th>2시하차총승객수</th>\n",
       "      <th>3시승차총승객수</th>\n",
       "      <th>3시하차총승객수</th>\n",
       "      <th>...</th>\n",
       "      <th>19시하차총승객수</th>\n",
       "      <th>20시승차총승객수</th>\n",
       "      <th>20시하차총승객수</th>\n",
       "      <th>21시승차총승객수</th>\n",
       "      <th>21시하차총승객수</th>\n",
       "      <th>22시승차총승객수</th>\n",
       "      <th>22시하차총승객수</th>\n",
       "      <th>23시승차총승객수</th>\n",
       "      <th>23시하차총승객수</th>\n",
       "      <th>등록일자</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>버스정류장ARS번호</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>22001</th>\n",
       "      <td>202006.462185</td>\n",
       "      <td>121000001.0</td>\n",
       "      <td>20.882353</td>\n",
       "      <td>35.605042</td>\n",
       "      <td>4.764706</td>\n",
       "      <td>11.436975</td>\n",
       "      <td>0.008403</td>\n",
       "      <td>0.016807</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>140.571429</td>\n",
       "      <td>95.067227</td>\n",
       "      <td>99.974790</td>\n",
       "      <td>93.294118</td>\n",
       "      <td>98.445378</td>\n",
       "      <td>77.084034</td>\n",
       "      <td>92.260504</td>\n",
       "      <td>49.596639</td>\n",
       "      <td>65.478992</td>\n",
       "      <td>2.020393e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22002</th>\n",
       "      <td>202006.500000</td>\n",
       "      <td>121000002.0</td>\n",
       "      <td>20.181818</td>\n",
       "      <td>11.984848</td>\n",
       "      <td>0.765152</td>\n",
       "      <td>0.022727</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>173.606061</td>\n",
       "      <td>166.909091</td>\n",
       "      <td>98.053030</td>\n",
       "      <td>146.787879</td>\n",
       "      <td>80.636364</td>\n",
       "      <td>108.833333</td>\n",
       "      <td>71.946970</td>\n",
       "      <td>57.977273</td>\n",
       "      <td>44.742424</td>\n",
       "      <td>2.020391e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22003</th>\n",
       "      <td>202006.500000</td>\n",
       "      <td>121000003.0</td>\n",
       "      <td>138.673611</td>\n",
       "      <td>54.152778</td>\n",
       "      <td>28.347222</td>\n",
       "      <td>17.708333</td>\n",
       "      <td>0.027778</td>\n",
       "      <td>0.006944</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>190.777778</td>\n",
       "      <td>309.013889</td>\n",
       "      <td>147.277778</td>\n",
       "      <td>306.680556</td>\n",
       "      <td>138.680556</td>\n",
       "      <td>285.993056</td>\n",
       "      <td>134.097222</td>\n",
       "      <td>225.944444</td>\n",
       "      <td>91.868056</td>\n",
       "      <td>2.020391e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22004</th>\n",
       "      <td>202006.500000</td>\n",
       "      <td>121000004.0</td>\n",
       "      <td>36.602564</td>\n",
       "      <td>18.500000</td>\n",
       "      <td>1.108974</td>\n",
       "      <td>0.076923</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>453.198718</td>\n",
       "      <td>166.044872</td>\n",
       "      <td>236.583333</td>\n",
       "      <td>165.147436</td>\n",
       "      <td>194.467949</td>\n",
       "      <td>145.352564</td>\n",
       "      <td>135.807692</td>\n",
       "      <td>119.038462</td>\n",
       "      <td>71.641026</td>\n",
       "      <td>2.020391e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22005</th>\n",
       "      <td>202006.477833</td>\n",
       "      <td>121000005.0</td>\n",
       "      <td>46.674877</td>\n",
       "      <td>37.192118</td>\n",
       "      <td>12.871921</td>\n",
       "      <td>14.408867</td>\n",
       "      <td>0.812808</td>\n",
       "      <td>3.261084</td>\n",
       "      <td>0.418719</td>\n",
       "      <td>4.906404</td>\n",
       "      <td>...</td>\n",
       "      <td>186.187192</td>\n",
       "      <td>112.167488</td>\n",
       "      <td>140.990148</td>\n",
       "      <td>115.423645</td>\n",
       "      <td>126.561576</td>\n",
       "      <td>100.103448</td>\n",
       "      <td>123.596059</td>\n",
       "      <td>66.522167</td>\n",
       "      <td>84.630542</td>\n",
       "      <td>2.020392e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23983</th>\n",
       "      <td>202005.900000</td>\n",
       "      <td>122000712.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>0.100000</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</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>0.100000</td>\n",
       "      <td>0.300000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.100000</td>\n",
       "      <td>2.020262e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23993</th>\n",
       "      <td>202006.500000</td>\n",
       "      <td>122900073.0</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>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>221.583333</td>\n",
       "      <td>19.791667</td>\n",
       "      <td>120.541667</td>\n",
       "      <td>17.750000</td>\n",
       "      <td>106.708333</td>\n",
       "      <td>21.500000</td>\n",
       "      <td>103.250000</td>\n",
       "      <td>8.125000</td>\n",
       "      <td>40.458333</td>\n",
       "      <td>2.020391e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23994</th>\n",
       "      <td>202007.064516</td>\n",
       "      <td>122000287.0</td>\n",
       "      <td>4.161290</td>\n",
       "      <td>1.193548</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>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>390.516129</td>\n",
       "      <td>155.516129</td>\n",
       "      <td>266.258065</td>\n",
       "      <td>122.258065</td>\n",
       "      <td>280.838710</td>\n",
       "      <td>107.903226</td>\n",
       "      <td>233.451613</td>\n",
       "      <td>41.967742</td>\n",
       "      <td>71.064516</td>\n",
       "      <td>2.020447e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23995</th>\n",
       "      <td>202006.500000</td>\n",
       "      <td>122900074.0</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>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>250.854167</td>\n",
       "      <td>31.541667</td>\n",
       "      <td>163.000000</td>\n",
       "      <td>34.854167</td>\n",
       "      <td>152.395833</td>\n",
       "      <td>29.916667</td>\n",
       "      <td>149.604167</td>\n",
       "      <td>4.416667</td>\n",
       "      <td>70.562500</td>\n",
       "      <td>2.020391e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23998</th>\n",
       "      <td>202003.500000</td>\n",
       "      <td>122900072.0</td>\n",
       "      <td>1.833333</td>\n",
       "      <td>32.666667</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>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>816.000000</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>574.833333</td>\n",
       "      <td>7.833333</td>\n",
       "      <td>481.833333</td>\n",
       "      <td>19.333333</td>\n",
       "      <td>498.000000</td>\n",
       "      <td>12.500000</td>\n",
       "      <td>347.500000</td>\n",
       "      <td>2.020209e+07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1124 rows × 51 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     사용년월    표준버스정류장ID   00시승차총승객수  00시하차총승객수   1시승차총승객수  \\\n",
       "버스정류장ARS번호                                                                 \n",
       "22001       202006.462185  121000001.0   20.882353  35.605042   4.764706   \n",
       "22002       202006.500000  121000002.0   20.181818  11.984848   0.765152   \n",
       "22003       202006.500000  121000003.0  138.673611  54.152778  28.347222   \n",
       "22004       202006.500000  121000004.0   36.602564  18.500000   1.108974   \n",
       "22005       202006.477833  121000005.0   46.674877  37.192118  12.871921   \n",
       "...                   ...          ...         ...        ...        ...   \n",
       "23983       202005.900000  122000712.0    0.000000   0.200000   0.100000   \n",
       "23993       202006.500000  122900073.0    0.000000   0.000000   0.000000   \n",
       "23994       202007.064516  122000287.0    4.161290   1.193548   0.000000   \n",
       "23995       202006.500000  122900074.0    0.000000   0.000000   0.000000   \n",
       "23998       202003.500000  122900072.0    1.833333  32.666667   0.000000   \n",
       "\n",
       "             1시하차총승객수  2시승차총승객수  2시하차총승객수  3시승차총승객수  3시하차총승객수  ...  \\\n",
       "버스정류장ARS번호                                                     ...   \n",
       "22001       11.436975  0.008403  0.016807  0.000000  0.000000  ...   \n",
       "22002        0.022727  0.000000  0.000000  0.000000  0.000000  ...   \n",
       "22003       17.708333  0.027778  0.006944  0.000000  0.000000  ...   \n",
       "22004        0.076923  0.000000  0.000000  0.000000  0.000000  ...   \n",
       "22005       14.408867  0.812808  3.261084  0.418719  4.906404  ...   \n",
       "...               ...       ...       ...       ...       ...  ...   \n",
       "23983        0.200000  0.000000  0.000000  0.000000  0.000000  ...   \n",
       "23993        0.000000  0.000000  0.000000  0.000000  0.000000  ...   \n",
       "23994        0.000000  0.000000  0.000000  0.000000  0.000000  ...   \n",
       "23995        0.000000  0.000000  0.000000  0.000000  0.000000  ...   \n",
       "23998        0.000000  0.000000  0.000000  0.000000  0.000000  ...   \n",
       "\n",
       "             19시하차총승객수   20시승차총승객수   20시하차총승객수   21시승차총승객수   21시하차총승객수  \\\n",
       "버스정류장ARS번호                                                               \n",
       "22001       140.571429   95.067227   99.974790   93.294118   98.445378   \n",
       "22002       173.606061  166.909091   98.053030  146.787879   80.636364   \n",
       "22003       190.777778  309.013889  147.277778  306.680556  138.680556   \n",
       "22004       453.198718  166.044872  236.583333  165.147436  194.467949   \n",
       "22005       186.187192  112.167488  140.990148  115.423645  126.561576   \n",
       "...                ...         ...         ...         ...         ...   \n",
       "23983         0.000000    0.000000    0.000000    0.000000    0.000000   \n",
       "23993       221.583333   19.791667  120.541667   17.750000  106.708333   \n",
       "23994       390.516129  155.516129  266.258065  122.258065  280.838710   \n",
       "23995       250.854167   31.541667  163.000000   34.854167  152.395833   \n",
       "23998       816.000000   12.000000  574.833333    7.833333  481.833333   \n",
       "\n",
       "             22시승차총승객수   22시하차총승객수   23시승차총승객수   23시하차총승객수          등록일자  \n",
       "버스정류장ARS번호                                                                \n",
       "22001        77.084034   92.260504   49.596639   65.478992  2.020393e+07  \n",
       "22002       108.833333   71.946970   57.977273   44.742424  2.020391e+07  \n",
       "22003       285.993056  134.097222  225.944444   91.868056  2.020391e+07  \n",
       "22004       145.352564  135.807692  119.038462   71.641026  2.020391e+07  \n",
       "22005       100.103448  123.596059   66.522167   84.630542  2.020392e+07  \n",
       "...                ...         ...         ...         ...           ...  \n",
       "23983         0.100000    0.300000    0.000000    0.100000  2.020262e+07  \n",
       "23993        21.500000  103.250000    8.125000   40.458333  2.020391e+07  \n",
       "23994       107.903226  233.451613   41.967742   71.064516  2.020447e+07  \n",
       "23995        29.916667  149.604167    4.416667   70.562500  2.020391e+07  \n",
       "23998        19.333333  498.000000   12.500000  347.500000  2.020209e+07  \n",
       "\n",
       "[1124 rows x 51 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "grouped = df2.groupby(df2['버스정류장ARS번호']).mean()\n",
    "grouped"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['사용년월', '표준버스정류장ID', '00시승차총승객수', '00시하차총승객수', '1시승차총승객수', '1시하차총승객수',\n",
       "       '2시승차총승객수', '2시하차총승객수', '3시승차총승객수', '3시하차총승객수', '4시승차총승객수', '4시하차총승객수',\n",
       "       '5시승차총승객수', '5시하차총승객수', '6시승차총승객수', '6시하차총승객수', '7시승차총승객수', '7시하차총승객수',\n",
       "       '8시승차총승객수', '8시하차총승객수', '9시승차총승객수', '9시하차총승객수', '10시승차총승객수',\n",
       "       '10시하차총승객수', '11시승차총승객수', '11시하차총승객수', '12시승차총승객수', '12시하차총승객수',\n",
       "       '13시승차총승객수', '13시하차총승객수', '14시승차총승객수', '14시하차총승객수', '15시승차총승객수',\n",
       "       '15시하차총승객수', '16시승차총승객수', '16시하차총승객수', '17시승차총승객수', '17시하차총승객수',\n",
       "       '18시승차총승객수', '18시하차총승객수', '19시승차총승객수', '19시하차총승객수', '20시승차총승객수',\n",
       "       '20시하차총승객수', '21시승차총승객수', '21시하차총승객수', '22시승차총승객수', '22시하차총승객수',\n",
       "       '23시승차총승객수', '23시하차총승객수', '등록일자'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "grouped.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "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>00시승차총승객수</th>\n",
       "      <th>00시하차총승객수</th>\n",
       "      <th>1시승차총승객수</th>\n",
       "      <th>1시하차총승객수</th>\n",
       "      <th>2시승차총승객수</th>\n",
       "      <th>2시하차총승객수</th>\n",
       "      <th>3시승차총승객수</th>\n",
       "      <th>3시하차총승객수</th>\n",
       "      <th>4시승차총승객수</th>\n",
       "      <th>4시하차총승객수</th>\n",
       "      <th>...</th>\n",
       "      <th>19시승차총승객수</th>\n",
       "      <th>19시하차총승객수</th>\n",
       "      <th>20시승차총승객수</th>\n",
       "      <th>20시하차총승객수</th>\n",
       "      <th>21시승차총승객수</th>\n",
       "      <th>21시하차총승객수</th>\n",
       "      <th>22시승차총승객수</th>\n",
       "      <th>22시하차총승객수</th>\n",
       "      <th>23시승차총승객수</th>\n",
       "      <th>23시하차총승객수</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>버스정류장ARS번호</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>22001</th>\n",
       "      <td>20.882353</td>\n",
       "      <td>35.605042</td>\n",
       "      <td>4.764706</td>\n",
       "      <td>11.436975</td>\n",
       "      <td>0.008403</td>\n",
       "      <td>0.016807</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.008403</td>\n",
       "      <td>0.042017</td>\n",
       "      <td>...</td>\n",
       "      <td>112.638655</td>\n",
       "      <td>140.571429</td>\n",
       "      <td>95.067227</td>\n",
       "      <td>99.974790</td>\n",
       "      <td>93.294118</td>\n",
       "      <td>98.445378</td>\n",
       "      <td>77.084034</td>\n",
       "      <td>92.260504</td>\n",
       "      <td>49.596639</td>\n",
       "      <td>65.478992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22002</th>\n",
       "      <td>20.181818</td>\n",
       "      <td>11.984848</td>\n",
       "      <td>0.765152</td>\n",
       "      <td>0.022727</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>17.727273</td>\n",
       "      <td>11.121212</td>\n",
       "      <td>...</td>\n",
       "      <td>270.151515</td>\n",
       "      <td>173.606061</td>\n",
       "      <td>166.909091</td>\n",
       "      <td>98.053030</td>\n",
       "      <td>146.787879</td>\n",
       "      <td>80.636364</td>\n",
       "      <td>108.833333</td>\n",
       "      <td>71.946970</td>\n",
       "      <td>57.977273</td>\n",
       "      <td>44.742424</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22003</th>\n",
       "      <td>138.673611</td>\n",
       "      <td>54.152778</td>\n",
       "      <td>28.347222</td>\n",
       "      <td>17.708333</td>\n",
       "      <td>0.027778</td>\n",
       "      <td>0.006944</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.013889</td>\n",
       "      <td>0.069444</td>\n",
       "      <td>...</td>\n",
       "      <td>386.590278</td>\n",
       "      <td>190.777778</td>\n",
       "      <td>309.013889</td>\n",
       "      <td>147.277778</td>\n",
       "      <td>306.680556</td>\n",
       "      <td>138.680556</td>\n",
       "      <td>285.993056</td>\n",
       "      <td>134.097222</td>\n",
       "      <td>225.944444</td>\n",
       "      <td>91.868056</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22004</th>\n",
       "      <td>36.602564</td>\n",
       "      <td>18.500000</td>\n",
       "      <td>1.108974</td>\n",
       "      <td>0.076923</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>14.173077</td>\n",
       "      <td>15.057692</td>\n",
       "      <td>...</td>\n",
       "      <td>215.237179</td>\n",
       "      <td>453.198718</td>\n",
       "      <td>166.044872</td>\n",
       "      <td>236.583333</td>\n",
       "      <td>165.147436</td>\n",
       "      <td>194.467949</td>\n",
       "      <td>145.352564</td>\n",
       "      <td>135.807692</td>\n",
       "      <td>119.038462</td>\n",
       "      <td>71.641026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22005</th>\n",
       "      <td>46.674877</td>\n",
       "      <td>37.192118</td>\n",
       "      <td>12.871921</td>\n",
       "      <td>14.408867</td>\n",
       "      <td>0.812808</td>\n",
       "      <td>3.261084</td>\n",
       "      <td>0.418719</td>\n",
       "      <td>4.906404</td>\n",
       "      <td>0.206897</td>\n",
       "      <td>2.408867</td>\n",
       "      <td>...</td>\n",
       "      <td>134.817734</td>\n",
       "      <td>186.187192</td>\n",
       "      <td>112.167488</td>\n",
       "      <td>140.990148</td>\n",
       "      <td>115.423645</td>\n",
       "      <td>126.561576</td>\n",
       "      <td>100.103448</td>\n",
       "      <td>123.596059</td>\n",
       "      <td>66.522167</td>\n",
       "      <td>84.630542</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23983</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>0.100000</td>\n",
       "      <td>0.200000</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>0.000000</td>\n",
       "      <td>...</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>0.000000</td>\n",
       "      <td>0.100000</td>\n",
       "      <td>0.300000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23993</th>\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>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>...</td>\n",
       "      <td>20.291667</td>\n",
       "      <td>221.583333</td>\n",
       "      <td>19.791667</td>\n",
       "      <td>120.541667</td>\n",
       "      <td>17.750000</td>\n",
       "      <td>106.708333</td>\n",
       "      <td>21.500000</td>\n",
       "      <td>103.250000</td>\n",
       "      <td>8.125000</td>\n",
       "      <td>40.458333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23994</th>\n",
       "      <td>4.161290</td>\n",
       "      <td>1.193548</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>0.000000</td>\n",
       "      <td>183.419355</td>\n",
       "      <td>36.580645</td>\n",
       "      <td>...</td>\n",
       "      <td>190.741935</td>\n",
       "      <td>390.516129</td>\n",
       "      <td>155.516129</td>\n",
       "      <td>266.258065</td>\n",
       "      <td>122.258065</td>\n",
       "      <td>280.838710</td>\n",
       "      <td>107.903226</td>\n",
       "      <td>233.451613</td>\n",
       "      <td>41.967742</td>\n",
       "      <td>71.064516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23995</th>\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>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>...</td>\n",
       "      <td>61.583333</td>\n",
       "      <td>250.854167</td>\n",
       "      <td>31.541667</td>\n",
       "      <td>163.000000</td>\n",
       "      <td>34.854167</td>\n",
       "      <td>152.395833</td>\n",
       "      <td>29.916667</td>\n",
       "      <td>149.604167</td>\n",
       "      <td>4.416667</td>\n",
       "      <td>70.562500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23998</th>\n",
       "      <td>1.833333</td>\n",
       "      <td>32.666667</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>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>816.000000</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>574.833333</td>\n",
       "      <td>7.833333</td>\n",
       "      <td>481.833333</td>\n",
       "      <td>19.333333</td>\n",
       "      <td>498.000000</td>\n",
       "      <td>12.500000</td>\n",
       "      <td>347.500000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1124 rows × 48 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             00시승차총승객수  00시하차총승객수   1시승차총승객수   1시하차총승객수  2시승차총승객수  2시하차총승객수  \\\n",
       "버스정류장ARS번호                                                                    \n",
       "22001        20.882353  35.605042   4.764706  11.436975  0.008403  0.016807   \n",
       "22002        20.181818  11.984848   0.765152   0.022727  0.000000  0.000000   \n",
       "22003       138.673611  54.152778  28.347222  17.708333  0.027778  0.006944   \n",
       "22004        36.602564  18.500000   1.108974   0.076923  0.000000  0.000000   \n",
       "22005        46.674877  37.192118  12.871921  14.408867  0.812808  3.261084   \n",
       "...                ...        ...        ...        ...       ...       ...   \n",
       "23983         0.000000   0.200000   0.100000   0.200000  0.000000  0.000000   \n",
       "23993         0.000000   0.000000   0.000000   0.000000  0.000000  0.000000   \n",
       "23994         4.161290   1.193548   0.000000   0.000000  0.000000  0.000000   \n",
       "23995         0.000000   0.000000   0.000000   0.000000  0.000000  0.000000   \n",
       "23998         1.833333  32.666667   0.000000   0.000000  0.000000  0.000000   \n",
       "\n",
       "            3시승차총승객수  3시하차총승객수    4시승차총승객수   4시하차총승객수  ...   19시승차총승객수  \\\n",
       "버스정류장ARS번호                                             ...               \n",
       "22001       0.000000  0.000000    0.008403   0.042017  ...  112.638655   \n",
       "22002       0.000000  0.000000   17.727273  11.121212  ...  270.151515   \n",
       "22003       0.000000  0.000000    0.013889   0.069444  ...  386.590278   \n",
       "22004       0.000000  0.000000   14.173077  15.057692  ...  215.237179   \n",
       "22005       0.418719  4.906404    0.206897   2.408867  ...  134.817734   \n",
       "...              ...       ...         ...        ...  ...         ...   \n",
       "23983       0.000000  0.000000    0.000000   0.000000  ...    0.000000   \n",
       "23993       0.000000  0.000000    0.000000   0.000000  ...   20.291667   \n",
       "23994       0.000000  0.000000  183.419355  36.580645  ...  190.741935   \n",
       "23995       0.000000  0.000000    0.000000   0.000000  ...   61.583333   \n",
       "23998       0.000000  0.000000    0.000000   0.000000  ...   17.000000   \n",
       "\n",
       "             19시하차총승객수   20시승차총승객수   20시하차총승객수   21시승차총승객수   21시하차총승객수  \\\n",
       "버스정류장ARS번호                                                               \n",
       "22001       140.571429   95.067227   99.974790   93.294118   98.445378   \n",
       "22002       173.606061  166.909091   98.053030  146.787879   80.636364   \n",
       "22003       190.777778  309.013889  147.277778  306.680556  138.680556   \n",
       "22004       453.198718  166.044872  236.583333  165.147436  194.467949   \n",
       "22005       186.187192  112.167488  140.990148  115.423645  126.561576   \n",
       "...                ...         ...         ...         ...         ...   \n",
       "23983         0.000000    0.000000    0.000000    0.000000    0.000000   \n",
       "23993       221.583333   19.791667  120.541667   17.750000  106.708333   \n",
       "23994       390.516129  155.516129  266.258065  122.258065  280.838710   \n",
       "23995       250.854167   31.541667  163.000000   34.854167  152.395833   \n",
       "23998       816.000000   12.000000  574.833333    7.833333  481.833333   \n",
       "\n",
       "             22시승차총승객수   22시하차총승객수   23시승차총승객수   23시하차총승객수  \n",
       "버스정류장ARS번호                                                  \n",
       "22001        77.084034   92.260504   49.596639   65.478992  \n",
       "22002       108.833333   71.946970   57.977273   44.742424  \n",
       "22003       285.993056  134.097222  225.944444   91.868056  \n",
       "22004       145.352564  135.807692  119.038462   71.641026  \n",
       "22005       100.103448  123.596059   66.522167   84.630542  \n",
       "...                ...         ...         ...         ...  \n",
       "23983         0.100000    0.300000    0.000000    0.100000  \n",
       "23993        21.500000  103.250000    8.125000   40.458333  \n",
       "23994       107.903226  233.451613   41.967742   71.064516  \n",
       "23995        29.916667  149.604167    4.416667   70.562500  \n",
       "23998        19.333333  498.000000   12.500000  347.500000  \n",
       "\n",
       "[1124 rows x 48 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "grouped = grouped[['00시승차총승객수', '00시하차총승객수', '1시승차총승객수', '1시하차총승객수',\n",
    "       '2시승차총승객수', '2시하차총승객수', '3시승차총승객수', '3시하차총승객수', '4시승차총승객수', '4시하차총승객수',\n",
    "       '5시승차총승객수', '5시하차총승객수', '6시승차총승객수', '6시하차총승객수', '7시승차총승객수', '7시하차총승객수',\n",
    "       '8시승차총승객수', '8시하차총승객수', '9시승차총승객수', '9시하차총승객수', '10시승차총승객수',\n",
    "       '10시하차총승객수', '11시승차총승객수', '11시하차총승객수', '12시승차총승객수', '12시하차총승객수',\n",
    "       '13시승차총승객수', '13시하차총승객수', '14시승차총승객수', '14시하차총승객수', '15시승차총승객수',\n",
    "       '15시하차총승객수', '16시승차총승객수', '16시하차총승객수', '17시승차총승객수', '17시하차총승객수',\n",
    "       '18시승차총승객수', '18시하차총승객수', '19시승차총승객수', '19시하차총승객수', '20시승차총승객수',\n",
    "       '20시하차총승객수', '21시승차총승객수', '21시하차총승객수', '22시승차총승객수', '22시하차총승객수',\n",
    "       '23시승차총승객수', '23시하차총승객수']]\n",
    "\n",
    "grouped"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 아침 하차 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "아침하차 = grouped[['7시하차총승객수','8시하차총승객수','9시하차총승객수','10시하차총승객수']]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 저녁 승차"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "저녁승차 = grouped[['17시승차총승객수','18시승차총승객수','19시승차총승객수','20시승차총승객수']]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 아침승차"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "아침승차 = grouped[['6시승차총승객수','7시승차총승객수','8시승차총승객수','9시승차총승객수']]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 저녁하차"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "저녁하차 = grouped[['18시하차총승객수','19시하차총승객수','20시하차총승객수','21시하차총승객수']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "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>표준ID</th>\n",
       "      <th>정류소명</th>\n",
       "      <th>X좌표</th>\n",
       "      <th>Y좌표</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ARS-ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>22001</th>\n",
       "      <td>121000001</td>\n",
       "      <td>교육개발원입구</td>\n",
       "      <td>127.038342</td>\n",
       "      <td>37.478514</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22002</th>\n",
       "      <td>121000002</td>\n",
       "      <td>교육개발원입구</td>\n",
       "      <td>127.038676</td>\n",
       "      <td>37.477767</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22003</th>\n",
       "      <td>121000003</td>\n",
       "      <td>양재역.서초문화예술회관</td>\n",
       "      <td>127.035847</td>\n",
       "      <td>37.482522</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22004</th>\n",
       "      <td>121000004</td>\n",
       "      <td>양재역.서초문화예술회관</td>\n",
       "      <td>127.036825</td>\n",
       "      <td>37.481871</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22005</th>\n",
       "      <td>121000005</td>\n",
       "      <td>뱅뱅사거리</td>\n",
       "      <td>127.032367</td>\n",
       "      <td>37.487592</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23972</th>\n",
       "      <td>122900097</td>\n",
       "      <td>수서교회.수서동성당앞</td>\n",
       "      <td>127.094743</td>\n",
       "      <td>37.483491</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23981</th>\n",
       "      <td>122000286</td>\n",
       "      <td>삼성서울병원사거리</td>\n",
       "      <td>127.082862</td>\n",
       "      <td>37.488968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23993</th>\n",
       "      <td>122900073</td>\n",
       "      <td>강남신동아파밀리에2단지</td>\n",
       "      <td>127.101538</td>\n",
       "      <td>37.464601</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23994</th>\n",
       "      <td>122000287</td>\n",
       "      <td>일원주유소.삼성서울병원후문</td>\n",
       "      <td>127.087681</td>\n",
       "      <td>37.490657</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23995</th>\n",
       "      <td>122900074</td>\n",
       "      <td>리엔파크4단지.강남데시앙파크</td>\n",
       "      <td>127.101900</td>\n",
       "      <td>37.461227</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1166 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             표준ID             정류소명         X좌표        Y좌표\n",
       "ARS-ID                                                   \n",
       "22001   121000001          교육개발원입구  127.038342  37.478514\n",
       "22002   121000002          교육개발원입구  127.038676  37.477767\n",
       "22003   121000003     양재역.서초문화예술회관  127.035847  37.482522\n",
       "22004   121000004     양재역.서초문화예술회관  127.036825  37.481871\n",
       "22005   121000005            뱅뱅사거리  127.032367  37.487592\n",
       "...           ...              ...         ...        ...\n",
       "23972   122900097      수서교회.수서동성당앞  127.094743  37.483491\n",
       "23981   122000286        삼성서울병원사거리  127.082862  37.488968\n",
       "23993   122900073     강남신동아파밀리에2단지  127.101538  37.464601\n",
       "23994   122000287   일원주유소.삼성서울병원후문  127.087681  37.490657\n",
       "23995   122900074  리엔파크4단지.강남데시앙파크  127.101900  37.461227\n",
       "\n",
       "[1166 rows x 4 columns]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ndf1 = df1.set_index(['ARS-ID'])\n",
    "ndf1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "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>표준ID</th>\n",
       "      <th>정류소명</th>\n",
       "      <th>X좌표</th>\n",
       "      <th>Y좌표</th>\n",
       "      <th>7시하차총승객수</th>\n",
       "      <th>8시하차총승객수</th>\n",
       "      <th>9시하차총승객수</th>\n",
       "      <th>10시하차총승객수</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ARS-ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>22001</th>\n",
       "      <td>121000001</td>\n",
       "      <td>교육개발원입구</td>\n",
       "      <td>127.038342</td>\n",
       "      <td>37.478514</td>\n",
       "      <td>143.907563</td>\n",
       "      <td>422.840336</td>\n",
       "      <td>237.655462</td>\n",
       "      <td>90.336134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22002</th>\n",
       "      <td>121000002</td>\n",
       "      <td>교육개발원입구</td>\n",
       "      <td>127.038676</td>\n",
       "      <td>37.477767</td>\n",
       "      <td>183.606061</td>\n",
       "      <td>313.151515</td>\n",
       "      <td>201.439394</td>\n",
       "      <td>120.431818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22003</th>\n",
       "      <td>121000003</td>\n",
       "      <td>양재역.서초문화예술회관</td>\n",
       "      <td>127.035847</td>\n",
       "      <td>37.482522</td>\n",
       "      <td>166.201389</td>\n",
       "      <td>267.368056</td>\n",
       "      <td>171.500000</td>\n",
       "      <td>101.805556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22004</th>\n",
       "      <td>121000004</td>\n",
       "      <td>양재역.서초문화예술회관</td>\n",
       "      <td>127.036825</td>\n",
       "      <td>37.481871</td>\n",
       "      <td>264.807692</td>\n",
       "      <td>370.653846</td>\n",
       "      <td>253.243590</td>\n",
       "      <td>191.730769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22005</th>\n",
       "      <td>121000005</td>\n",
       "      <td>뱅뱅사거리</td>\n",
       "      <td>127.032367</td>\n",
       "      <td>37.487592</td>\n",
       "      <td>168.369458</td>\n",
       "      <td>251.847291</td>\n",
       "      <td>159.315271</td>\n",
       "      <td>117.536946</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23972</th>\n",
       "      <td>122900097</td>\n",
       "      <td>수서교회.수서동성당앞</td>\n",
       "      <td>127.094743</td>\n",
       "      <td>37.483491</td>\n",
       "      <td>87.333333</td>\n",
       "      <td>63.583333</td>\n",
       "      <td>55.583333</td>\n",
       "      <td>48.583333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23981</th>\n",
       "      <td>122000286</td>\n",
       "      <td>삼성서울병원사거리</td>\n",
       "      <td>127.082862</td>\n",
       "      <td>37.488968</td>\n",
       "      <td>226.000000</td>\n",
       "      <td>141.916667</td>\n",
       "      <td>137.916667</td>\n",
       "      <td>112.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23993</th>\n",
       "      <td>122900073</td>\n",
       "      <td>강남신동아파밀리에2단지</td>\n",
       "      <td>127.101538</td>\n",
       "      <td>37.464601</td>\n",
       "      <td>29.958333</td>\n",
       "      <td>70.666667</td>\n",
       "      <td>40.416667</td>\n",
       "      <td>48.916667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23994</th>\n",
       "      <td>122000287</td>\n",
       "      <td>일원주유소.삼성서울병원후문</td>\n",
       "      <td>127.087681</td>\n",
       "      <td>37.490657</td>\n",
       "      <td>530.580645</td>\n",
       "      <td>402.709677</td>\n",
       "      <td>346.483871</td>\n",
       "      <td>290.806452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23995</th>\n",
       "      <td>122900074</td>\n",
       "      <td>리엔파크4단지.강남데시앙파크</td>\n",
       "      <td>127.101900</td>\n",
       "      <td>37.461227</td>\n",
       "      <td>34.395833</td>\n",
       "      <td>48.395833</td>\n",
       "      <td>39.708333</td>\n",
       "      <td>50.604167</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1166 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             표준ID             정류소명         X좌표        Y좌표    7시하차총승객수  \\\n",
       "ARS-ID                                                                  \n",
       "22001   121000001          교육개발원입구  127.038342  37.478514  143.907563   \n",
       "22002   121000002          교육개발원입구  127.038676  37.477767  183.606061   \n",
       "22003   121000003     양재역.서초문화예술회관  127.035847  37.482522  166.201389   \n",
       "22004   121000004     양재역.서초문화예술회관  127.036825  37.481871  264.807692   \n",
       "22005   121000005            뱅뱅사거리  127.032367  37.487592  168.369458   \n",
       "...           ...              ...         ...        ...         ...   \n",
       "23972   122900097      수서교회.수서동성당앞  127.094743  37.483491   87.333333   \n",
       "23981   122000286        삼성서울병원사거리  127.082862  37.488968  226.000000   \n",
       "23993   122900073     강남신동아파밀리에2단지  127.101538  37.464601   29.958333   \n",
       "23994   122000287   일원주유소.삼성서울병원후문  127.087681  37.490657  530.580645   \n",
       "23995   122900074  리엔파크4단지.강남데시앙파크  127.101900  37.461227   34.395833   \n",
       "\n",
       "          8시하차총승객수    9시하차총승객수   10시하차총승객수  \n",
       "ARS-ID                                      \n",
       "22001   422.840336  237.655462   90.336134  \n",
       "22002   313.151515  201.439394  120.431818  \n",
       "22003   267.368056  171.500000  101.805556  \n",
       "22004   370.653846  253.243590  191.730769  \n",
       "22005   251.847291  159.315271  117.536946  \n",
       "...            ...         ...         ...  \n",
       "23972    63.583333   55.583333   48.583333  \n",
       "23981   141.916667  137.916667  112.333333  \n",
       "23993    70.666667   40.416667   48.916667  \n",
       "23994   402.709677  346.483871  290.806452  \n",
       "23995    48.395833   39.708333   50.604167  \n",
       "\n",
       "[1166 rows x 8 columns]"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "아침하차merge = ndf1.join(아침하차, how='left')\n",
    "아침하차merge"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [],
   "source": [
    "아침하차merge.to_csv(\"output/강남구서초구정류장아침하차.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "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>표준ID</th>\n",
       "      <th>정류소명</th>\n",
       "      <th>X좌표</th>\n",
       "      <th>Y좌표</th>\n",
       "      <th>6시승차총승객수</th>\n",
       "      <th>7시승차총승객수</th>\n",
       "      <th>8시승차총승객수</th>\n",
       "      <th>9시승차총승객수</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ARS-ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>22001</th>\n",
       "      <td>121000001</td>\n",
       "      <td>교육개발원입구</td>\n",
       "      <td>127.038342</td>\n",
       "      <td>37.478514</td>\n",
       "      <td>46.605042</td>\n",
       "      <td>75.453782</td>\n",
       "      <td>109.529412</td>\n",
       "      <td>55.630252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22002</th>\n",
       "      <td>121000002</td>\n",
       "      <td>교육개발원입구</td>\n",
       "      <td>127.038676</td>\n",
       "      <td>37.477767</td>\n",
       "      <td>63.765152</td>\n",
       "      <td>191.484848</td>\n",
       "      <td>283.583333</td>\n",
       "      <td>229.393939</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22003</th>\n",
       "      <td>121000003</td>\n",
       "      <td>양재역.서초문화예술회관</td>\n",
       "      <td>127.035847</td>\n",
       "      <td>37.482522</td>\n",
       "      <td>195.208333</td>\n",
       "      <td>433.201389</td>\n",
       "      <td>873.833333</td>\n",
       "      <td>440.826389</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22004</th>\n",
       "      <td>121000004</td>\n",
       "      <td>양재역.서초문화예술회관</td>\n",
       "      <td>127.036825</td>\n",
       "      <td>37.481871</td>\n",
       "      <td>53.070513</td>\n",
       "      <td>145.384615</td>\n",
       "      <td>220.884615</td>\n",
       "      <td>187.807692</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22005</th>\n",
       "      <td>121000005</td>\n",
       "      <td>뱅뱅사거리</td>\n",
       "      <td>127.032367</td>\n",
       "      <td>37.487592</td>\n",
       "      <td>94.743842</td>\n",
       "      <td>155.118227</td>\n",
       "      <td>197.305419</td>\n",
       "      <td>115.600985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23972</th>\n",
       "      <td>122900097</td>\n",
       "      <td>수서교회.수서동성당앞</td>\n",
       "      <td>127.094743</td>\n",
       "      <td>37.483491</td>\n",
       "      <td>22.833333</td>\n",
       "      <td>21.250000</td>\n",
       "      <td>44.166667</td>\n",
       "      <td>35.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23981</th>\n",
       "      <td>122000286</td>\n",
       "      <td>삼성서울병원사거리</td>\n",
       "      <td>127.082862</td>\n",
       "      <td>37.488968</td>\n",
       "      <td>16.416667</td>\n",
       "      <td>103.250000</td>\n",
       "      <td>119.250000</td>\n",
       "      <td>37.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23993</th>\n",
       "      <td>122900073</td>\n",
       "      <td>강남신동아파밀리에2단지</td>\n",
       "      <td>127.101538</td>\n",
       "      <td>37.464601</td>\n",
       "      <td>11.625000</td>\n",
       "      <td>15.958333</td>\n",
       "      <td>12.583333</td>\n",
       "      <td>9.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23994</th>\n",
       "      <td>122000287</td>\n",
       "      <td>일원주유소.삼성서울병원후문</td>\n",
       "      <td>127.087681</td>\n",
       "      <td>37.490657</td>\n",
       "      <td>237.806452</td>\n",
       "      <td>528.677419</td>\n",
       "      <td>688.774194</td>\n",
       "      <td>490.774194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23995</th>\n",
       "      <td>122900074</td>\n",
       "      <td>리엔파크4단지.강남데시앙파크</td>\n",
       "      <td>127.101900</td>\n",
       "      <td>37.461227</td>\n",
       "      <td>242.062500</td>\n",
       "      <td>470.604167</td>\n",
       "      <td>342.437500</td>\n",
       "      <td>247.895833</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1166 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             표준ID             정류소명         X좌표        Y좌표    6시승차총승객수  \\\n",
       "ARS-ID                                                                  \n",
       "22001   121000001          교육개발원입구  127.038342  37.478514   46.605042   \n",
       "22002   121000002          교육개발원입구  127.038676  37.477767   63.765152   \n",
       "22003   121000003     양재역.서초문화예술회관  127.035847  37.482522  195.208333   \n",
       "22004   121000004     양재역.서초문화예술회관  127.036825  37.481871   53.070513   \n",
       "22005   121000005            뱅뱅사거리  127.032367  37.487592   94.743842   \n",
       "...           ...              ...         ...        ...         ...   \n",
       "23972   122900097      수서교회.수서동성당앞  127.094743  37.483491   22.833333   \n",
       "23981   122000286        삼성서울병원사거리  127.082862  37.488968   16.416667   \n",
       "23993   122900073     강남신동아파밀리에2단지  127.101538  37.464601   11.625000   \n",
       "23994   122000287   일원주유소.삼성서울병원후문  127.087681  37.490657  237.806452   \n",
       "23995   122900074  리엔파크4단지.강남데시앙파크  127.101900  37.461227  242.062500   \n",
       "\n",
       "          7시승차총승객수    8시승차총승객수    9시승차총승객수  \n",
       "ARS-ID                                      \n",
       "22001    75.453782  109.529412   55.630252  \n",
       "22002   191.484848  283.583333  229.393939  \n",
       "22003   433.201389  873.833333  440.826389  \n",
       "22004   145.384615  220.884615  187.807692  \n",
       "22005   155.118227  197.305419  115.600985  \n",
       "...            ...         ...         ...  \n",
       "23972    21.250000   44.166667   35.250000  \n",
       "23981   103.250000  119.250000   37.666667  \n",
       "23993    15.958333   12.583333    9.333333  \n",
       "23994   528.677419  688.774194  490.774194  \n",
       "23995   470.604167  342.437500  247.895833  \n",
       "\n",
       "[1166 rows x 8 columns]"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "아침승차merge = ndf1.join(아침승차, how='left')\n",
    "아침승차merge"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [],
   "source": [
    "아침승차merge.to_csv(\"output/강남구서초구정류장아침승차.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "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>표준ID</th>\n",
       "      <th>정류소명</th>\n",
       "      <th>X좌표</th>\n",
       "      <th>Y좌표</th>\n",
       "      <th>18시하차총승객수</th>\n",
       "      <th>19시하차총승객수</th>\n",
       "      <th>20시하차총승객수</th>\n",
       "      <th>21시하차총승객수</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ARS-ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>22001</th>\n",
       "      <td>121000001</td>\n",
       "      <td>교육개발원입구</td>\n",
       "      <td>127.038342</td>\n",
       "      <td>37.478514</td>\n",
       "      <td>155.462185</td>\n",
       "      <td>140.571429</td>\n",
       "      <td>99.974790</td>\n",
       "      <td>98.445378</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22002</th>\n",
       "      <td>121000002</td>\n",
       "      <td>교육개발원입구</td>\n",
       "      <td>127.038676</td>\n",
       "      <td>37.477767</td>\n",
       "      <td>358.469697</td>\n",
       "      <td>173.606061</td>\n",
       "      <td>98.053030</td>\n",
       "      <td>80.636364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22003</th>\n",
       "      <td>121000003</td>\n",
       "      <td>양재역.서초문화예술회관</td>\n",
       "      <td>127.035847</td>\n",
       "      <td>37.482522</td>\n",
       "      <td>229.638889</td>\n",
       "      <td>190.777778</td>\n",
       "      <td>147.277778</td>\n",
       "      <td>138.680556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22004</th>\n",
       "      <td>121000004</td>\n",
       "      <td>양재역.서초문화예술회관</td>\n",
       "      <td>127.036825</td>\n",
       "      <td>37.481871</td>\n",
       "      <td>1097.993590</td>\n",
       "      <td>453.198718</td>\n",
       "      <td>236.583333</td>\n",
       "      <td>194.467949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22005</th>\n",
       "      <td>121000005</td>\n",
       "      <td>뱅뱅사거리</td>\n",
       "      <td>127.032367</td>\n",
       "      <td>37.487592</td>\n",
       "      <td>245.325123</td>\n",
       "      <td>186.187192</td>\n",
       "      <td>140.990148</td>\n",
       "      <td>126.561576</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23972</th>\n",
       "      <td>122900097</td>\n",
       "      <td>수서교회.수서동성당앞</td>\n",
       "      <td>127.094743</td>\n",
       "      <td>37.483491</td>\n",
       "      <td>32.166667</td>\n",
       "      <td>15.166667</td>\n",
       "      <td>13.083333</td>\n",
       "      <td>13.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23981</th>\n",
       "      <td>122000286</td>\n",
       "      <td>삼성서울병원사거리</td>\n",
       "      <td>127.082862</td>\n",
       "      <td>37.488968</td>\n",
       "      <td>229.083333</td>\n",
       "      <td>186.916667</td>\n",
       "      <td>161.333333</td>\n",
       "      <td>165.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23993</th>\n",
       "      <td>122900073</td>\n",
       "      <td>강남신동아파밀리에2단지</td>\n",
       "      <td>127.101538</td>\n",
       "      <td>37.464601</td>\n",
       "      <td>210.500000</td>\n",
       "      <td>221.583333</td>\n",
       "      <td>120.541667</td>\n",
       "      <td>106.708333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23994</th>\n",
       "      <td>122000287</td>\n",
       "      <td>일원주유소.삼성서울병원후문</td>\n",
       "      <td>127.087681</td>\n",
       "      <td>37.490657</td>\n",
       "      <td>483.064516</td>\n",
       "      <td>390.516129</td>\n",
       "      <td>266.258065</td>\n",
       "      <td>280.838710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23995</th>\n",
       "      <td>122900074</td>\n",
       "      <td>리엔파크4단지.강남데시앙파크</td>\n",
       "      <td>127.101900</td>\n",
       "      <td>37.461227</td>\n",
       "      <td>219.208333</td>\n",
       "      <td>250.854167</td>\n",
       "      <td>163.000000</td>\n",
       "      <td>152.395833</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1166 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             표준ID             정류소명         X좌표        Y좌표    18시하차총승객수  \\\n",
       "ARS-ID                                                                   \n",
       "22001   121000001          교육개발원입구  127.038342  37.478514   155.462185   \n",
       "22002   121000002          교육개발원입구  127.038676  37.477767   358.469697   \n",
       "22003   121000003     양재역.서초문화예술회관  127.035847  37.482522   229.638889   \n",
       "22004   121000004     양재역.서초문화예술회관  127.036825  37.481871  1097.993590   \n",
       "22005   121000005            뱅뱅사거리  127.032367  37.487592   245.325123   \n",
       "...           ...              ...         ...        ...          ...   \n",
       "23972   122900097      수서교회.수서동성당앞  127.094743  37.483491    32.166667   \n",
       "23981   122000286        삼성서울병원사거리  127.082862  37.488968   229.083333   \n",
       "23993   122900073     강남신동아파밀리에2단지  127.101538  37.464601   210.500000   \n",
       "23994   122000287   일원주유소.삼성서울병원후문  127.087681  37.490657   483.064516   \n",
       "23995   122900074  리엔파크4단지.강남데시앙파크  127.101900  37.461227   219.208333   \n",
       "\n",
       "         19시하차총승객수   20시하차총승객수   21시하차총승객수  \n",
       "ARS-ID                                      \n",
       "22001   140.571429   99.974790   98.445378  \n",
       "22002   173.606061   98.053030   80.636364  \n",
       "22003   190.777778  147.277778  138.680556  \n",
       "22004   453.198718  236.583333  194.467949  \n",
       "22005   186.187192  140.990148  126.561576  \n",
       "...            ...         ...         ...  \n",
       "23972    15.166667   13.083333   13.000000  \n",
       "23981   186.916667  161.333333  165.333333  \n",
       "23993   221.583333  120.541667  106.708333  \n",
       "23994   390.516129  266.258065  280.838710  \n",
       "23995   250.854167  163.000000  152.395833  \n",
       "\n",
       "[1166 rows x 8 columns]"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "저녁하차merge = ndf1.join(저녁하차, how='left')\n",
    "저녁하차merge"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [],
   "source": [
    "저녁하차merge.to_csv(\"output/강남구서초구정류장저녁하차.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "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>표준ID</th>\n",
       "      <th>정류소명</th>\n",
       "      <th>X좌표</th>\n",
       "      <th>Y좌표</th>\n",
       "      <th>17시승차총승객수</th>\n",
       "      <th>18시승차총승객수</th>\n",
       "      <th>19시승차총승객수</th>\n",
       "      <th>20시승차총승객수</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ARS-ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>22001</th>\n",
       "      <td>121000001</td>\n",
       "      <td>교육개발원입구</td>\n",
       "      <td>127.038342</td>\n",
       "      <td>37.478514</td>\n",
       "      <td>157.025210</td>\n",
       "      <td>203.605042</td>\n",
       "      <td>112.638655</td>\n",
       "      <td>95.067227</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22002</th>\n",
       "      <td>121000002</td>\n",
       "      <td>교육개발원입구</td>\n",
       "      <td>127.038676</td>\n",
       "      <td>37.477767</td>\n",
       "      <td>409.878788</td>\n",
       "      <td>659.681818</td>\n",
       "      <td>270.151515</td>\n",
       "      <td>166.909091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22003</th>\n",
       "      <td>121000003</td>\n",
       "      <td>양재역.서초문화예술회관</td>\n",
       "      <td>127.035847</td>\n",
       "      <td>37.482522</td>\n",
       "      <td>330.729167</td>\n",
       "      <td>466.736111</td>\n",
       "      <td>386.590278</td>\n",
       "      <td>309.013889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22004</th>\n",
       "      <td>121000004</td>\n",
       "      <td>양재역.서초문화예술회관</td>\n",
       "      <td>127.036825</td>\n",
       "      <td>37.481871</td>\n",
       "      <td>271.461538</td>\n",
       "      <td>333.762821</td>\n",
       "      <td>215.237179</td>\n",
       "      <td>166.044872</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22005</th>\n",
       "      <td>121000005</td>\n",
       "      <td>뱅뱅사거리</td>\n",
       "      <td>127.032367</td>\n",
       "      <td>37.487592</td>\n",
       "      <td>163.512315</td>\n",
       "      <td>203.635468</td>\n",
       "      <td>134.817734</td>\n",
       "      <td>112.167488</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23972</th>\n",
       "      <td>122900097</td>\n",
       "      <td>수서교회.수서동성당앞</td>\n",
       "      <td>127.094743</td>\n",
       "      <td>37.483491</td>\n",
       "      <td>62.666667</td>\n",
       "      <td>55.416667</td>\n",
       "      <td>15.500000</td>\n",
       "      <td>17.166667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23981</th>\n",
       "      <td>122000286</td>\n",
       "      <td>삼성서울병원사거리</td>\n",
       "      <td>127.082862</td>\n",
       "      <td>37.488968</td>\n",
       "      <td>307.250000</td>\n",
       "      <td>151.916667</td>\n",
       "      <td>92.500000</td>\n",
       "      <td>71.416667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23993</th>\n",
       "      <td>122900073</td>\n",
       "      <td>강남신동아파밀리에2단지</td>\n",
       "      <td>127.101538</td>\n",
       "      <td>37.464601</td>\n",
       "      <td>16.833333</td>\n",
       "      <td>20.041667</td>\n",
       "      <td>20.291667</td>\n",
       "      <td>19.791667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23994</th>\n",
       "      <td>122000287</td>\n",
       "      <td>일원주유소.삼성서울병원후문</td>\n",
       "      <td>127.087681</td>\n",
       "      <td>37.490657</td>\n",
       "      <td>511.419355</td>\n",
       "      <td>324.870968</td>\n",
       "      <td>190.741935</td>\n",
       "      <td>155.516129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23995</th>\n",
       "      <td>122900074</td>\n",
       "      <td>리엔파크4단지.강남데시앙파크</td>\n",
       "      <td>127.101900</td>\n",
       "      <td>37.461227</td>\n",
       "      <td>210.250000</td>\n",
       "      <td>165.458333</td>\n",
       "      <td>61.583333</td>\n",
       "      <td>31.541667</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1166 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             표준ID             정류소명         X좌표        Y좌표   17시승차총승객수  \\\n",
       "ARS-ID                                                                  \n",
       "22001   121000001          교육개발원입구  127.038342  37.478514  157.025210   \n",
       "22002   121000002          교육개발원입구  127.038676  37.477767  409.878788   \n",
       "22003   121000003     양재역.서초문화예술회관  127.035847  37.482522  330.729167   \n",
       "22004   121000004     양재역.서초문화예술회관  127.036825  37.481871  271.461538   \n",
       "22005   121000005            뱅뱅사거리  127.032367  37.487592  163.512315   \n",
       "...           ...              ...         ...        ...         ...   \n",
       "23972   122900097      수서교회.수서동성당앞  127.094743  37.483491   62.666667   \n",
       "23981   122000286        삼성서울병원사거리  127.082862  37.488968  307.250000   \n",
       "23993   122900073     강남신동아파밀리에2단지  127.101538  37.464601   16.833333   \n",
       "23994   122000287   일원주유소.삼성서울병원후문  127.087681  37.490657  511.419355   \n",
       "23995   122900074  리엔파크4단지.강남데시앙파크  127.101900  37.461227  210.250000   \n",
       "\n",
       "         18시승차총승객수   19시승차총승객수   20시승차총승객수  \n",
       "ARS-ID                                      \n",
       "22001   203.605042  112.638655   95.067227  \n",
       "22002   659.681818  270.151515  166.909091  \n",
       "22003   466.736111  386.590278  309.013889  \n",
       "22004   333.762821  215.237179  166.044872  \n",
       "22005   203.635468  134.817734  112.167488  \n",
       "...            ...         ...         ...  \n",
       "23972    55.416667   15.500000   17.166667  \n",
       "23981   151.916667   92.500000   71.416667  \n",
       "23993    20.041667   20.291667   19.791667  \n",
       "23994   324.870968  190.741935  155.516129  \n",
       "23995   165.458333   61.583333   31.541667  \n",
       "\n",
       "[1166 rows x 8 columns]"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "저녁승차merge = ndf1.join(저녁승차, how='left')\n",
    "저녁승차merge"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [],
   "source": [
    "저녁승차merge.to_csv(\"output/강남구서초구정류장저녁승차.csv\")"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "pydatavenv",
   "language": "python",
   "name": "pydatavenv"
  },
  "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.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}