won_bucheonBus_anly.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from datetime import datetime, timedelta"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# ?pd.read_csv"
   ]
  },
  {
   "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>정류소명</th>\n",
       "      <th>노선id</th>\n",
       "      <th>최소배차</th>\n",
       "      <th>최대배차</th>\n",
       "      <th>첫차시간</th>\n",
       "      <th>막차시간</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000073.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>05:20</td>\n",
       "      <td>23:15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000006.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>05:00</td>\n",
       "      <td>00:10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000004.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>05:15</td>\n",
       "      <td>00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000007.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>04:40</td>\n",
       "      <td>00:10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000038.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>05:45</td>\n",
       "      <td>00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         정류소id             정류소명         노선id  최소배차  최대배차   첫차시간   막차시간\n",
       "0  211000062.0  KCC스위첸아파트.한신아파트  210000073.0  13.0  17.0  05:20  23:15\n",
       "1  211000062.0  KCC스위첸아파트.한신아파트  210000006.0   7.0  15.0  05:00  00:10\n",
       "2  211000062.0  KCC스위첸아파트.한신아파트  210000004.0   5.0  10.0  05:15  00:00\n",
       "3  211000062.0  KCC스위첸아파트.한신아파트  210000007.0   7.0  15.0  04:40  00:10\n",
       "4  211000062.0  KCC스위첸아파트.한신아파트  210000038.0   7.0  10.0  05:45  00:00"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bus = pd.read_csv('output/bus_num.csv')\n",
    "bus = bus.iloc[:, range(1,8)]\n",
    "bus.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "정류소id      0\n",
      "정류소명       0\n",
      "노선id     178\n",
      "최소배차     178\n",
      "최대배차     178\n",
      "첫차시간     218\n",
      "막차시간     218\n",
      "dtype: int64\n"
     ]
    }
   ],
   "source": [
    "print(bus.isna().sum())\n",
    "bus = bus.dropna(axis=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>노선id</th>\n",
       "      <th>최소배차</th>\n",
       "      <th>최대배차</th>\n",
       "      <th>첫차시간</th>\n",
       "      <th>막차시간</th>\n",
       "      <th>평균배차</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000073.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>05:20</td>\n",
       "      <td>23:15</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000006.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>05:00</td>\n",
       "      <td>00:10</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000004.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>05:15</td>\n",
       "      <td>00:00</td>\n",
       "      <td>7.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000007.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>04:40</td>\n",
       "      <td>00:10</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000038.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>05:45</td>\n",
       "      <td>00:00</td>\n",
       "      <td>8.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         정류소id             정류소명         노선id  최소배차  최대배차   첫차시간   막차시간  평균배차\n",
       "0  211000062.0  KCC스위첸아파트.한신아파트  210000073.0  13.0  17.0  05:20  23:15  15.0\n",
       "1  211000062.0  KCC스위첸아파트.한신아파트  210000006.0   7.0  15.0  05:00  00:10  11.0\n",
       "2  211000062.0  KCC스위첸아파트.한신아파트  210000004.0   5.0  10.0  05:15  00:00   7.5\n",
       "3  211000062.0  KCC스위첸아파트.한신아파트  210000007.0   7.0  15.0  04:40  00:10  11.0\n",
       "4  211000062.0  KCC스위첸아파트.한신아파트  210000038.0   7.0  10.0  05:45  00:00   8.5"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "bus['평균배차'] = (bus['최소배차'] + bus['최대배차']) / 2\n",
    "display(bus.head())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    3696.000000\n",
       "mean       14.987689\n",
       "std        13.956192\n",
       "min         0.000000\n",
       "25%        10.000000\n",
       "50%        12.500000\n",
       "75%        15.000000\n",
       "max       165.000000\n",
       "Name: 평균배차, dtype: float64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bus['평균배차'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>노선id</th>\n",
       "      <th>최소배차</th>\n",
       "      <th>최대배차</th>\n",
       "      <th>첫차시간</th>\n",
       "      <th>막차시간</th>\n",
       "      <th>평균배차</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000073.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>2021-04-22 05:20:00</td>\n",
       "      <td>2021-04-22 23:15:00</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000006.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2021-04-22 05:00:00</td>\n",
       "      <td>2021-04-22 00:10:00</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000004.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2021-04-22 05:15:00</td>\n",
       "      <td>2021-04-22 00:00:00</td>\n",
       "      <td>7.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000007.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2021-04-22 04:40:00</td>\n",
       "      <td>2021-04-22 00:10:00</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000038.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2021-04-22 05:45:00</td>\n",
       "      <td>2021-04-22 00:00:00</td>\n",
       "      <td>8.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         정류소id             정류소명         노선id  최소배차  최대배차                첫차시간  \\\n",
       "0  211000062.0  KCC스위첸아파트.한신아파트  210000073.0  13.0  17.0 2021-04-22 05:20:00   \n",
       "1  211000062.0  KCC스위첸아파트.한신아파트  210000006.0   7.0  15.0 2021-04-22 05:00:00   \n",
       "2  211000062.0  KCC스위첸아파트.한신아파트  210000004.0   5.0  10.0 2021-04-22 05:15:00   \n",
       "3  211000062.0  KCC스위첸아파트.한신아파트  210000007.0   7.0  15.0 2021-04-22 04:40:00   \n",
       "4  211000062.0  KCC스위첸아파트.한신아파트  210000038.0   7.0  10.0 2021-04-22 05:45:00   \n",
       "\n",
       "                 막차시간  평균배차  \n",
       "0 2021-04-22 23:15:00  15.0  \n",
       "1 2021-04-22 00:10:00  11.0  \n",
       "2 2021-04-22 00:00:00   7.5  \n",
       "3 2021-04-22 00:10:00  11.0  \n",
       "4 2021-04-22 00:00:00   8.5  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "bus['첫차시간'] = pd.to_datetime(bus['첫차시간'])\n",
    "bus['막차시간'] = pd.to_datetime(bus['막차시간'])\n",
    "display(bus.head())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1      2021-04-22 00:10:00\n",
       "2      2021-04-22 00:00:00\n",
       "3      2021-04-22 00:10:00\n",
       "4      2021-04-22 00:00:00\n",
       "7      2021-04-22 00:10:00\n",
       "               ...        \n",
       "3882   2021-04-22 00:55:00\n",
       "3891   2021-04-22 00:10:00\n",
       "3893   2021-04-22 00:10:00\n",
       "3894   2021-04-22 00:10:00\n",
       "3897   2021-04-22 00:10:00\n",
       "Name: 막차시간, Length: 1641, dtype: datetime64[ns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bus.loc[bus['막차시간'].dt.hour < 4, '막차시간']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>정류소id</th>\n",
       "      <th>정류소명</th>\n",
       "      <th>노선id</th>\n",
       "      <th>최소배차</th>\n",
       "      <th>최대배차</th>\n",
       "      <th>첫차시간</th>\n",
       "      <th>막차시간</th>\n",
       "      <th>평균배차</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000073.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>2021-04-22 05:20:00</td>\n",
       "      <td>2021-04-22 23:15:00</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000006.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2021-04-22 05:00:00</td>\n",
       "      <td>2021-04-23 00:10:00</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000004.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2021-04-22 05:15:00</td>\n",
       "      <td>2021-04-23 00:00:00</td>\n",
       "      <td>7.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000007.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2021-04-22 04:40:00</td>\n",
       "      <td>2021-04-23 00:10:00</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000038.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2021-04-22 05:45:00</td>\n",
       "      <td>2021-04-23 00:00:00</td>\n",
       "      <td>8.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         정류소id             정류소명         노선id  최소배차  최대배차                첫차시간  \\\n",
       "0  211000062.0  KCC스위첸아파트.한신아파트  210000073.0  13.0  17.0 2021-04-22 05:20:00   \n",
       "1  211000062.0  KCC스위첸아파트.한신아파트  210000006.0   7.0  15.0 2021-04-22 05:00:00   \n",
       "2  211000062.0  KCC스위첸아파트.한신아파트  210000004.0   5.0  10.0 2021-04-22 05:15:00   \n",
       "3  211000062.0  KCC스위첸아파트.한신아파트  210000007.0   7.0  15.0 2021-04-22 04:40:00   \n",
       "4  211000062.0  KCC스위첸아파트.한신아파트  210000038.0   7.0  10.0 2021-04-22 05:45:00   \n",
       "\n",
       "                 막차시간  평균배차  \n",
       "0 2021-04-22 23:15:00  15.0  \n",
       "1 2021-04-23 00:10:00  11.0  \n",
       "2 2021-04-23 00:00:00   7.5  \n",
       "3 2021-04-23 00:10:00  11.0  \n",
       "4 2021-04-23 00:00:00   8.5  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "bus.loc[bus['막차시간'].dt.hour < 4, '막차시간'] = pd.DatetimeIndex(bus[bus['막차시간'].dt.hour < 4]['막차시간']) + timedelta(days=1)\n",
    "display(bus.head())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>정류소id</th>\n",
       "      <th>정류소명</th>\n",
       "      <th>노선id</th>\n",
       "      <th>최소배차</th>\n",
       "      <th>최대배차</th>\n",
       "      <th>첫차시간</th>\n",
       "      <th>막차시간</th>\n",
       "      <th>평균배차</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000073.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>2021-04-22 05:20:00</td>\n",
       "      <td>2021-04-22 23:15:00</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000006.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2021-04-22 05:00:00</td>\n",
       "      <td>2021-04-23 00:10:00</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000004.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2021-04-22 05:15:00</td>\n",
       "      <td>2021-04-23 00:00:00</td>\n",
       "      <td>7.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000007.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2021-04-22 04:40:00</td>\n",
       "      <td>2021-04-23 00:10:00</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000038.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2021-04-22 05:45:00</td>\n",
       "      <td>2021-04-23 00:00:00</td>\n",
       "      <td>8.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         정류소id             정류소명         노선id  최소배차  최대배차                첫차시간  \\\n",
       "0  211000062.0  KCC스위첸아파트.한신아파트  210000073.0  13.0  17.0 2021-04-22 05:20:00   \n",
       "1  211000062.0  KCC스위첸아파트.한신아파트  210000006.0   7.0  15.0 2021-04-22 05:00:00   \n",
       "2  211000062.0  KCC스위첸아파트.한신아파트  210000004.0   5.0  10.0 2021-04-22 05:15:00   \n",
       "3  211000062.0  KCC스위첸아파트.한신아파트  210000007.0   7.0  15.0 2021-04-22 04:40:00   \n",
       "4  211000062.0  KCC스위첸아파트.한신아파트  210000038.0   7.0  10.0 2021-04-22 05:45:00   \n",
       "\n",
       "                 막차시간  평균배차  \n",
       "0 2021-04-22 23:15:00  15.0  \n",
       "1 2021-04-23 00:10:00  11.0  \n",
       "2 2021-04-23 00:00:00   7.5  \n",
       "3 2021-04-23 00:10:00  11.0  \n",
       "4 2021-04-23 00:00:00   8.5  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(bus.head())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>정류소id</th>\n",
       "      <th>정류소명</th>\n",
       "      <th>노선id</th>\n",
       "      <th>최소배차</th>\n",
       "      <th>최대배차</th>\n",
       "      <th>첫차시간</th>\n",
       "      <th>막차시간</th>\n",
       "      <th>평균배차</th>\n",
       "      <th>운영시간</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000073.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>2021-04-22 05:20:00</td>\n",
       "      <td>2021-04-22 23:15:00</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0 days 17:55:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000006.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2021-04-22 05:00:00</td>\n",
       "      <td>2021-04-23 00:10:00</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0 days 19:10:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000004.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2021-04-22 05:15:00</td>\n",
       "      <td>2021-04-23 00:00:00</td>\n",
       "      <td>7.5</td>\n",
       "      <td>0 days 18:45:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000007.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2021-04-22 04:40:00</td>\n",
       "      <td>2021-04-23 00:10:00</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0 days 19:30:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000038.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2021-04-22 05:45:00</td>\n",
       "      <td>2021-04-23 00:00:00</td>\n",
       "      <td>8.5</td>\n",
       "      <td>0 days 18:15:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         정류소id             정류소명         노선id  최소배차  최대배차                첫차시간  \\\n",
       "0  211000062.0  KCC스위첸아파트.한신아파트  210000073.0  13.0  17.0 2021-04-22 05:20:00   \n",
       "1  211000062.0  KCC스위첸아파트.한신아파트  210000006.0   7.0  15.0 2021-04-22 05:00:00   \n",
       "2  211000062.0  KCC스위첸아파트.한신아파트  210000004.0   5.0  10.0 2021-04-22 05:15:00   \n",
       "3  211000062.0  KCC스위첸아파트.한신아파트  210000007.0   7.0  15.0 2021-04-22 04:40:00   \n",
       "4  211000062.0  KCC스위첸아파트.한신아파트  210000038.0   7.0  10.0 2021-04-22 05:45:00   \n",
       "\n",
       "                 막차시간  평균배차            운영시간  \n",
       "0 2021-04-22 23:15:00  15.0 0 days 17:55:00  \n",
       "1 2021-04-23 00:10:00  11.0 0 days 19:10:00  \n",
       "2 2021-04-23 00:00:00   7.5 0 days 18:45:00  \n",
       "3 2021-04-23 00:10:00  11.0 0 days 19:30:00  \n",
       "4 2021-04-23 00:00:00   8.5 0 days 18:15:00  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bus['운영시간'] = bus['막차시간'] - bus['첫차시간']\n",
    "bus.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Yoon\\anaconda3\\envs\\pydatavenv\\lib\\site-packages\\pandas\\core\\arrays\\timedeltas.py:598: RuntimeWarning: divide by zero encountered in true_divide\n",
      "  return other / self._data\n"
     ]
    },
    {
     "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>노선id</th>\n",
       "      <th>최소배차</th>\n",
       "      <th>최대배차</th>\n",
       "      <th>첫차시간</th>\n",
       "      <th>막차시간</th>\n",
       "      <th>평균배차</th>\n",
       "      <th>운영시간</th>\n",
       "      <th>운영대수</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000073.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>2021-04-22 05:20:00</td>\n",
       "      <td>2021-04-22 23:15:00</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0 days 17:55:00</td>\n",
       "      <td>72.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000006.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2021-04-22 05:00:00</td>\n",
       "      <td>2021-04-23 00:10:00</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0 days 19:10:00</td>\n",
       "      <td>105.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000004.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2021-04-22 05:15:00</td>\n",
       "      <td>2021-04-23 00:00:00</td>\n",
       "      <td>7.5</td>\n",
       "      <td>0 days 18:45:00</td>\n",
       "      <td>150.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000007.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2021-04-22 04:40:00</td>\n",
       "      <td>2021-04-23 00:10:00</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0 days 19:30:00</td>\n",
       "      <td>106.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>210000038.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2021-04-22 05:45:00</td>\n",
       "      <td>2021-04-23 00:00:00</td>\n",
       "      <td>8.5</td>\n",
       "      <td>0 days 18:15:00</td>\n",
       "      <td>129.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         정류소id             정류소명         노선id  최소배차  최대배차                첫차시간  \\\n",
       "0  211000062.0  KCC스위첸아파트.한신아파트  210000073.0  13.0  17.0 2021-04-22 05:20:00   \n",
       "1  211000062.0  KCC스위첸아파트.한신아파트  210000006.0   7.0  15.0 2021-04-22 05:00:00   \n",
       "2  211000062.0  KCC스위첸아파트.한신아파트  210000004.0   5.0  10.0 2021-04-22 05:15:00   \n",
       "3  211000062.0  KCC스위첸아파트.한신아파트  210000007.0   7.0  15.0 2021-04-22 04:40:00   \n",
       "4  211000062.0  KCC스위첸아파트.한신아파트  210000038.0   7.0  10.0 2021-04-22 05:45:00   \n",
       "\n",
       "                 막차시간  평균배차            운영시간   운영대수  \n",
       "0 2021-04-22 23:15:00  15.0 0 days 17:55:00   72.0  \n",
       "1 2021-04-23 00:10:00  11.0 0 days 19:10:00  105.0  \n",
       "2 2021-04-23 00:00:00   7.5 0 days 18:45:00  150.0  \n",
       "3 2021-04-23 00:10:00  11.0 0 days 19:30:00  106.0  \n",
       "4 2021-04-23 00:00:00   8.5 0 days 18:15:00  129.0  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bus['운영대수'] = round(bus['운영시간'] / bus['평균배차'].apply(lambda x: timedelta(minutes = x)))\n",
    "bus.head()"
   ]
  },
  {
   "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>운영대수</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>72.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>105.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>150.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>106.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>211000062.0</td>\n",
       "      <td>129.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3909</th>\n",
       "      <td>212000395.0</td>\n",
       "      <td>41.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3910</th>\n",
       "      <td>212000378.0</td>\n",
       "      <td>121.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3911</th>\n",
       "      <td>212000378.0</td>\n",
       "      <td>41.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3912</th>\n",
       "      <td>212000384.0</td>\n",
       "      <td>121.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3913</th>\n",
       "      <td>212000384.0</td>\n",
       "      <td>41.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3696 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            정류소id   운영대수\n",
       "0     211000062.0   72.0\n",
       "1     211000062.0  105.0\n",
       "2     211000062.0  150.0\n",
       "3     211000062.0  106.0\n",
       "4     211000062.0  129.0\n",
       "...           ...    ...\n",
       "3909  212000395.0   41.0\n",
       "3910  212000378.0  121.0\n",
       "3911  212000378.0   41.0\n",
       "3912  212000384.0  121.0\n",
       "3913  212000384.0   41.0\n",
       "\n",
       "[3696 rows x 2 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bus_fin = bus.loc[:, ['정류소id', '운영대수']]\n",
    "bus_fin"
   ]
  },
  {
   "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>val</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>정류소id</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>210000001.0</th>\n",
       "      <td>164.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210000003.0</th>\n",
       "      <td>784.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210000004.0</th>\n",
       "      <td>935.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210000005.0</th>\n",
       "      <td>935.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210000006.0</th>\n",
       "      <td>572.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               val\n",
       "정류소id             \n",
       "210000001.0  164.0\n",
       "210000003.0  784.0\n",
       "210000004.0  935.0\n",
       "210000005.0  935.0\n",
       "210000006.0  572.0"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bus_fin = bus_fin.groupby('정류소id').sum()\n",
    "bus_fin.columns = ['val']\n",
    "bus_fin.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>정류소id</th>\n",
       "      <th>정류소명</th>\n",
       "      <th>위도</th>\n",
       "      <th>경도</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8611</th>\n",
       "      <td>211000062</td>\n",
       "      <td>KCC스위첸아파트.한신아파트</td>\n",
       "      <td>37.475267</td>\n",
       "      <td>126.799667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8612</th>\n",
       "      <td>212000004</td>\n",
       "      <td>KEB하나은행도당동지점</td>\n",
       "      <td>37.516817</td>\n",
       "      <td>126.779700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8613</th>\n",
       "      <td>210000373</td>\n",
       "      <td>KEB하나은행도당동지점</td>\n",
       "      <td>37.516600</td>\n",
       "      <td>126.779817</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8614</th>\n",
       "      <td>210000101</td>\n",
       "      <td>KT부천지사</td>\n",
       "      <td>37.486967</td>\n",
       "      <td>126.776200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8615</th>\n",
       "      <td>210000365</td>\n",
       "      <td>KT부천지사</td>\n",
       "      <td>37.486867</td>\n",
       "      <td>126.775250</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          정류소id             정류소명         위도          경도\n",
       "8611  211000062  KCC스위첸아파트.한신아파트  37.475267  126.799667\n",
       "8612  212000004     KEB하나은행도당동지점  37.516817  126.779700\n",
       "8613  210000373     KEB하나은행도당동지점  37.516600  126.779817\n",
       "8614  210000101           KT부천지사  37.486967  126.776200\n",
       "8615  210000365           KT부천지사  37.486867  126.775250"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "bus_info = pd.read_csv('./data/버스정류소현황.csv')\n",
    "is_bucheon = bus_info['시군명'] == '부천시'\n",
    "bus_info = bus_info[is_bucheon]\n",
    "bus_info = bus_info.loc[:, ['정류소id', '정류소명', 'WGS84위도', 'WGS84경도']]\n",
    "bus_info.columns = ['정류소id', '정류소명', '위도', '경도']\n",
    "display(bus_info.head(5))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>210000001.0</td>\n",
       "      <td>164.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>210000003.0</td>\n",
       "      <td>784.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>210000004.0</td>\n",
       "      <td>935.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>210000005.0</td>\n",
       "      <td>935.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>210000006.0</td>\n",
       "      <td>572.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         정류소id    val\n",
       "0  210000001.0  164.0\n",
       "1  210000003.0  784.0\n",
       "2  210000004.0  935.0\n",
       "3  210000005.0  935.0\n",
       "4  210000006.0  572.0"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bus_fin = bus_fin.reset_index()\n",
    "bus_fin.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "984\n"
     ]
    }
   ],
   "source": [
    "print(len(bus_fin))\n",
    "bus_fin = pd.merge(left = bus_fin, right = bus_info, how = \"inner\", on = \"정류소id\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "bus_fin.to_csv('output/bus_operate_num.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
}