11w_seoul_metro_station.ipynb

{
  "cells": [
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "a17ca338",
      "metadata": {
        "id": "a17ca338"
      },
      "outputs": [],
      "source": [
        "# 데이터 출처: https://www.kaggle.com/datasets/kimjmin/seoul-metro-usage"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 11,
      "id": "a087f5c9",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 969
        },
        "id": "a087f5c9",
        "outputId": "a8c31be4-bdb1-4033-cee1-8f853b60b562"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<folium.folium.Map at 0x7fbf19cf3760>"
            ],
            "text/html": [
              "<div style=\"width:100%;\"><div style=\"position:relative;width:100%;height:0;padding-bottom:60%;\"><span style=\"color:#565656\">Make this Notebook Trusted to load map: File -> Trust Notebook</span><iframe srcdoc=\"&lt;!DOCTYPE html&gt;\n",
              "&lt;html&gt;\n",
              "&lt;head&gt;\n",
              "    \n",
              "    &lt;meta http-equiv=&quot;content-type&quot; content=&quot;text/html; charset=UTF-8&quot; /&gt;\n",
              "    \n",
              "        &lt;script&gt;\n",
              "            L_NO_TOUCH = false;\n",
              "            L_DISABLE_3D = false;\n",
              "        &lt;/script&gt;\n",
              "    \n",
              "    &lt;style&gt;html, body {width: 100%;height: 100%;margin: 0;padding: 0;}&lt;/style&gt;\n",
              "    &lt;style&gt;#map {position:absolute;top:0;bottom:0;right:0;left:0;}&lt;/style&gt;\n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.9.3/dist/leaflet.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://code.jquery.com/jquery-1.12.4.min.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/js/bootstrap.bundle.min.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.9.3/dist/leaflet.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/css/bootstrap.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://netdna.bootstrapcdn.com/bootstrap/3.0.0/css/bootstrap.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/@fortawesome/fontawesome-free@6.2.0/css/all.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/gh/python-visualization/folium/folium/templates/leaflet.awesome.rotate.min.css&quot;/&gt;\n",
              "    \n",
              "            &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width,\n",
              "                initial-scale=1.0, maximum-scale=1.0, user-scalable=no&quot; /&gt;\n",
              "            &lt;style&gt;\n",
              "                #map_b733686e4c43e9cb51d3fa39732c22ac {\n",
              "                    position: relative;\n",
              "                    width: 100.0%;\n",
              "                    height: 100.0%;\n",
              "                    left: 0.0%;\n",
              "                    top: 0.0%;\n",
              "                }\n",
              "                .leaflet-container { font-size: 1rem; }\n",
              "            &lt;/style&gt;\n",
              "        \n",
              "&lt;/head&gt;\n",
              "&lt;body&gt;\n",
              "    \n",
              "    \n",
              "            &lt;div class=&quot;folium-map&quot; id=&quot;map_b733686e4c43e9cb51d3fa39732c22ac&quot; &gt;&lt;/div&gt;\n",
              "        \n",
              "&lt;/body&gt;\n",
              "&lt;script&gt;\n",
              "    \n",
              "    \n",
              "            var map_b733686e4c43e9cb51d3fa39732c22ac = L.map(\n",
              "                &quot;map_b733686e4c43e9cb51d3fa39732c22ac&quot;,\n",
              "                {\n",
              "                    center: [37.55, 126.98],\n",
              "                    crs: L.CRS.EPSG3857,\n",
              "                    zoom: 12,\n",
              "                    zoomControl: true,\n",
              "                    preferCanvas: false,\n",
              "                }\n",
              "            );\n",
              "\n",
              "            \n",
              "\n",
              "        \n",
              "    \n",
              "            var tile_layer_606206c025b51a908cc25ce3abe765ea = L.tileLayer(\n",
              "                &quot;https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png&quot;,\n",
              "                {&quot;attribution&quot;: &quot;Data by \\u0026copy; \\u003ca target=\\&quot;_blank\\&quot; href=\\&quot;http://openstreetmap.org\\&quot;\\u003eOpenStreetMap\\u003c/a\\u003e, under \\u003ca target=\\&quot;_blank\\&quot; href=\\&quot;http://www.openstreetmap.org/copyright\\&quot;\\u003eODbL\\u003c/a\\u003e.&quot;, &quot;detectRetina&quot;: false, &quot;maxNativeZoom&quot;: 18, &quot;maxZoom&quot;: 18, &quot;minZoom&quot;: 0, &quot;noWrap&quot;: false, &quot;opacity&quot;: 1, &quot;subdomains&quot;: &quot;abc&quot;, &quot;tms&quot;: false}\n",
              "            ).addTo(map_b733686e4c43e9cb51d3fa39732c22ac);\n",
              "        \n",
              "&lt;/script&gt;\n",
              "&lt;/html&gt;\" style=\"position:absolute;width:100%;height:100%;left:0;top:0;border:none !important;\" allowfullscreen webkitallowfullscreen mozallowfullscreen></iframe></div></div>"
            ]
          },
          "metadata": {},
          "execution_count": 11
        }
      ],
      "source": [
        "# 라이브러리 탑재\n",
        "import folium\n",
        "\n",
        "# 기본 서울 지도 그래프 표기\n",
        "seoul = folium.Map(location=[37.55, 126.98], zoom_start = 12)\n",
        "seoul "
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 1,
      "id": "fe494a13",
      "metadata": {
        "id": "fe494a13",
        "outputId": "fd6d1311-fbed-43cc-c164-dabde104ec27",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 423
        }
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                           timestamp  station_code  people_in  people_out\n",
              "0      2021-01-01T05:00:00.000+09:00           150         86          85\n",
              "1      2021-01-01T06:00:00.000+09:00           150        111         355\n",
              "2      2021-01-01T07:00:00.000+09:00           150        157         438\n",
              "3      2021-01-01T08:00:00.000+09:00           150        306         592\n",
              "4      2021-01-01T09:00:00.000+09:00           150        333         841\n",
              "...                              ...           ...        ...         ...\n",
              "24866  2021-01-05T19:00:00.000+09:00          2638         57         320\n",
              "24867  2021-01-05T20:00:00.000+09:00          2638         95         175\n",
              "24868  2021-01-05T21:00:00.000+09:00          2638         47         171\n",
              "24869  2021-01-05T22:00:00.000+09:00          2638         20          78\n",
              "24870  2021-01-05T23:00:00.000+09:00          2638          7          31\n",
              "\n",
              "[24871 rows x 4 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-f3dda848-467d-441a-a688-9131d857fc49\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>timestamp</th>\n",
              "      <th>station_code</th>\n",
              "      <th>people_in</th>\n",
              "      <th>people_out</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2021-01-01T05:00:00.000+09:00</td>\n",
              "      <td>150</td>\n",
              "      <td>86</td>\n",
              "      <td>85</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2021-01-01T06:00:00.000+09:00</td>\n",
              "      <td>150</td>\n",
              "      <td>111</td>\n",
              "      <td>355</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2021-01-01T07:00:00.000+09:00</td>\n",
              "      <td>150</td>\n",
              "      <td>157</td>\n",
              "      <td>438</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2021-01-01T08:00:00.000+09:00</td>\n",
              "      <td>150</td>\n",
              "      <td>306</td>\n",
              "      <td>592</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2021-01-01T09:00:00.000+09:00</td>\n",
              "      <td>150</td>\n",
              "      <td>333</td>\n",
              "      <td>841</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>24866</th>\n",
              "      <td>2021-01-05T19:00:00.000+09:00</td>\n",
              "      <td>2638</td>\n",
              "      <td>57</td>\n",
              "      <td>320</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24867</th>\n",
              "      <td>2021-01-05T20:00:00.000+09:00</td>\n",
              "      <td>2638</td>\n",
              "      <td>95</td>\n",
              "      <td>175</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24868</th>\n",
              "      <td>2021-01-05T21:00:00.000+09:00</td>\n",
              "      <td>2638</td>\n",
              "      <td>47</td>\n",
              "      <td>171</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24869</th>\n",
              "      <td>2021-01-05T22:00:00.000+09:00</td>\n",
              "      <td>2638</td>\n",
              "      <td>20</td>\n",
              "      <td>78</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24870</th>\n",
              "      <td>2021-01-05T23:00:00.000+09:00</td>\n",
              "      <td>2638</td>\n",
              "      <td>7</td>\n",
              "      <td>31</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>24871 rows × 4 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-f3dda848-467d-441a-a688-9131d857fc49')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-f3dda848-467d-441a-a688-9131d857fc49 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-f3dda848-467d-441a-a688-9131d857fc49');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 1
        }
      ],
      "source": [
        "# 판다스 모듈 탑재\n",
        "import pandas as pd\n",
        "\n",
        "# 승하차 인원 CSV 파일 읽어오기\n",
        "data = pd.read_csv(\"seoul-metro-2021.logs.csv\")\n",
        "\n",
        "# 데이터 확인하기\n",
        "data"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 4,
      "id": "614e8e2b",
      "metadata": {
        "id": "614e8e2b",
        "outputId": "2b059b6c-ac6a-42df-ea57-defc51d71be7",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 834
        }
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "     station.code station.fr_code  line.num line.name line.name_sub  \\\n",
              "0             158             124         1       1호선        지하철1호선   \n",
              "1             157             125         1       1호선        지하철1호선   \n",
              "2             156             126         1       1호선        지하철1호선   \n",
              "3             159             127         1       1호선        지하철1호선   \n",
              "4             155             128         1       1호선        지하철1호선   \n",
              "..            ...             ...       ...       ...           ...   \n",
              "280          2823             823         8       8호선        지하철8호선   \n",
              "281          2824             824         8       8호선        지하철8호선   \n",
              "282          2825             825         8       8호선        지하철8호선   \n",
              "283          2826             826         8       8호선        지하철8호선   \n",
              "284          2827             827         8       8호선        지하철8호선   \n",
              "\n",
              "     line.station_seq station.name_full     station.name  station.name_chc  \\\n",
              "0                   1      청량리(서울시립대입구)      청량리|서울시립대입구               祭基洞   \n",
              "1                   2               제기동              제기동               新設洞   \n",
              "2                   3               신설동              신설동               東廟앞   \n",
              "3                   4               동묘앞              동묘앞      淸凉里(서울市立大入口)   \n",
              "4                   5               동대문              동대문               東大門   \n",
              "..                ...               ...              ...               ...   \n",
              "280                14  남한산성입구(성남법원.검찰청)  남한산성입구|성남법원|검찰청  南漢山城入口(城南法院檢察廳)    \n",
              "281                15             단대오거리            단대오거리             丹垈오거리   \n",
              "282                16                신흥               신흥                新興   \n",
              "283                17                수진               수진                壽進   \n",
              "284                18                모란               모란                牡丹   \n",
              "\n",
              "    station.name_chn                                    station.name_en  \\\n",
              "0                祭基洞                                           Jegidong   \n",
              "1                新设洞                                        Sinseoldong   \n",
              "2                 东庙                                            Dongmyo   \n",
              "3        清凉里(首尔市立大学)                 Cheongnyangni(University of Seoul)   \n",
              "4                东大门                                         Dongdaemun   \n",
              "..               ...                                                ...   \n",
              "280   南汉山城(城南法院·检察厅)  Namhansanseong(Seongnam Court & Prosecutors' O...   \n",
              "281           丹垈五岔路口                                       Dandaeogeori   \n",
              "282               新兴                                           Sinheung   \n",
              "283               寿进                                              Sujin   \n",
              "284               牡丹                                              Moran   \n",
              "\n",
              "    station.name_jp  geo.latitude  geo.longitude  geo.sigungu_code  \\\n",
              "0             チェギドン     37.580178     127.046835             11060   \n",
              "1            シンソルトン     37.578103     127.034893             11060   \n",
              "2            トンミョアプ     37.575297     127.025087             11060   \n",
              "3           チョンニャンニ     37.572627     127.016429             11010   \n",
              "4             トンデムン     37.571420     127.009745             11010   \n",
              "..              ...           ...            ...               ...   \n",
              "280     ナムハンサンソンイック     37.451535     127.159816             31021   \n",
              "281          タンデオゴリ     37.445210     127.156866             31021   \n",
              "282            シンフン     37.440918     127.147564             31021   \n",
              "283             スジン     37.437428     127.140722             31021   \n",
              "284             モラン     37.432130     127.129087             31021   \n",
              "\n",
              "    geo.sigungu_name              geo.addres_road  \\\n",
              "0               동대문구    서울특별시 동대문구 왕산로 지하205(전농동)   \n",
              "1               동대문구     서울특별시 동대문구 왕산로 지하93(제기동)   \n",
              "2               동대문구      서울특별시 동대문구 왕산로 지하1(신설동)   \n",
              "3                종로구        서울특별시 종로구 종로 359(숭인동)   \n",
              "4                종로구      서울특별시 종로구 종로 지하302(창신동)   \n",
              "..               ...                          ...   \n",
              "280           성남시수정구  경기도 성남시 수정구 산성대로 지하445(단대동)   \n",
              "281           성남시수정구  경기도 성남시 수정구 산성대로 지하365(신흥동)   \n",
              "282           성남시수정구  경기도 성남시 수정구 산성대로 지하280(신흥동)   \n",
              "283           성남시수정구  경기도 성남시 수정구 산성대로 지하200(수진동)   \n",
              "284           성남시수정구  경기도 성남시 수정구 산성대로 지하100(수진동)   \n",
              "\n",
              "                     geo.address_land     geo.phone  \n",
              "0     서울특별시 동대문구 전농동 620-69 청량리역(1호선)  02-6110-1241  \n",
              "1         서울특별시 동대문구 제기동 65 제기동역(1호선)  02-6110-1251  \n",
              "2       서울특별시 동대문구 신설동 76-5 신설동역(1호선)  02-6110-1261  \n",
              "3         서울특별시 종로구 숭인동 117 동묘앞역(1호선)  02-6110-1271  \n",
              "4       서울특별시 종로구 창신동 492-1 동대문역(1호선)  02-6110-1281  \n",
              "..                                ...           ...  \n",
              "280   경기도 성남시 수정구 단대동 96 남한산성입구역(8호선)  02-6311-8231  \n",
              "281  경기도 성남시 수정구 신흥동 2467 단대오거리역(8호선)  02-6311-8241  \n",
              "282     경기도 성남시 수정구 신흥동 2467 신흥역(8호선)  02-6311-8251  \n",
              "283   경기도 성남시 수정구 수진동 2205-1 수진역(8호선)  02-6311-8261  \n",
              "284     경기도 성남시 수정구 수진동 4518 모란역(8호선)  02-6311-8271  \n",
              "\n",
              "[285 rows x 19 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-19639e83-c9f8-4fb2-a62e-4f4310e65d41\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>station.code</th>\n",
              "      <th>station.fr_code</th>\n",
              "      <th>line.num</th>\n",
              "      <th>line.name</th>\n",
              "      <th>line.name_sub</th>\n",
              "      <th>line.station_seq</th>\n",
              "      <th>station.name_full</th>\n",
              "      <th>station.name</th>\n",
              "      <th>station.name_chc</th>\n",
              "      <th>station.name_chn</th>\n",
              "      <th>station.name_en</th>\n",
              "      <th>station.name_jp</th>\n",
              "      <th>geo.latitude</th>\n",
              "      <th>geo.longitude</th>\n",
              "      <th>geo.sigungu_code</th>\n",
              "      <th>geo.sigungu_name</th>\n",
              "      <th>geo.addres_road</th>\n",
              "      <th>geo.address_land</th>\n",
              "      <th>geo.phone</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>158</td>\n",
              "      <td>124</td>\n",
              "      <td>1</td>\n",
              "      <td>1호선</td>\n",
              "      <td>지하철1호선</td>\n",
              "      <td>1</td>\n",
              "      <td>청량리(서울시립대입구)</td>\n",
              "      <td>청량리|서울시립대입구</td>\n",
              "      <td>祭基洞</td>\n",
              "      <td>祭基洞</td>\n",
              "      <td>Jegidong</td>\n",
              "      <td>チェギドン</td>\n",
              "      <td>37.580178</td>\n",
              "      <td>127.046835</td>\n",
              "      <td>11060</td>\n",
              "      <td>동대문구</td>\n",
              "      <td>서울특별시 동대문구 왕산로 지하205(전농동)</td>\n",
              "      <td>서울특별시 동대문구 전농동 620-69 청량리역(1호선)</td>\n",
              "      <td>02-6110-1241</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>157</td>\n",
              "      <td>125</td>\n",
              "      <td>1</td>\n",
              "      <td>1호선</td>\n",
              "      <td>지하철1호선</td>\n",
              "      <td>2</td>\n",
              "      <td>제기동</td>\n",
              "      <td>제기동</td>\n",
              "      <td>新設洞</td>\n",
              "      <td>新设洞</td>\n",
              "      <td>Sinseoldong</td>\n",
              "      <td>シンソルトン</td>\n",
              "      <td>37.578103</td>\n",
              "      <td>127.034893</td>\n",
              "      <td>11060</td>\n",
              "      <td>동대문구</td>\n",
              "      <td>서울특별시 동대문구 왕산로 지하93(제기동)</td>\n",
              "      <td>서울특별시 동대문구 제기동 65 제기동역(1호선)</td>\n",
              "      <td>02-6110-1251</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>156</td>\n",
              "      <td>126</td>\n",
              "      <td>1</td>\n",
              "      <td>1호선</td>\n",
              "      <td>지하철1호선</td>\n",
              "      <td>3</td>\n",
              "      <td>신설동</td>\n",
              "      <td>신설동</td>\n",
              "      <td>東廟앞</td>\n",
              "      <td>东庙</td>\n",
              "      <td>Dongmyo</td>\n",
              "      <td>トンミョアプ</td>\n",
              "      <td>37.575297</td>\n",
              "      <td>127.025087</td>\n",
              "      <td>11060</td>\n",
              "      <td>동대문구</td>\n",
              "      <td>서울특별시 동대문구 왕산로 지하1(신설동)</td>\n",
              "      <td>서울특별시 동대문구 신설동 76-5 신설동역(1호선)</td>\n",
              "      <td>02-6110-1261</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>159</td>\n",
              "      <td>127</td>\n",
              "      <td>1</td>\n",
              "      <td>1호선</td>\n",
              "      <td>지하철1호선</td>\n",
              "      <td>4</td>\n",
              "      <td>동묘앞</td>\n",
              "      <td>동묘앞</td>\n",
              "      <td>淸凉里(서울市立大入口)</td>\n",
              "      <td>清凉里(首尔市立大学)</td>\n",
              "      <td>Cheongnyangni(University of Seoul)</td>\n",
              "      <td>チョンニャンニ</td>\n",
              "      <td>37.572627</td>\n",
              "      <td>127.016429</td>\n",
              "      <td>11010</td>\n",
              "      <td>종로구</td>\n",
              "      <td>서울특별시 종로구 종로 359(숭인동)</td>\n",
              "      <td>서울특별시 종로구 숭인동 117 동묘앞역(1호선)</td>\n",
              "      <td>02-6110-1271</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>155</td>\n",
              "      <td>128</td>\n",
              "      <td>1</td>\n",
              "      <td>1호선</td>\n",
              "      <td>지하철1호선</td>\n",
              "      <td>5</td>\n",
              "      <td>동대문</td>\n",
              "      <td>동대문</td>\n",
              "      <td>東大門</td>\n",
              "      <td>东大门</td>\n",
              "      <td>Dongdaemun</td>\n",
              "      <td>トンデムン</td>\n",
              "      <td>37.571420</td>\n",
              "      <td>127.009745</td>\n",
              "      <td>11010</td>\n",
              "      <td>종로구</td>\n",
              "      <td>서울특별시 종로구 종로 지하302(창신동)</td>\n",
              "      <td>서울특별시 종로구 창신동 492-1 동대문역(1호선)</td>\n",
              "      <td>02-6110-1281</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>280</th>\n",
              "      <td>2823</td>\n",
              "      <td>823</td>\n",
              "      <td>8</td>\n",
              "      <td>8호선</td>\n",
              "      <td>지하철8호선</td>\n",
              "      <td>14</td>\n",
              "      <td>남한산성입구(성남법원.검찰청)</td>\n",
              "      <td>남한산성입구|성남법원|검찰청</td>\n",
              "      <td>南漢山城入口(城南法院檢察廳)</td>\n",
              "      <td>南汉山城(城南法院·检察厅)</td>\n",
              "      <td>Namhansanseong(Seongnam Court &amp; Prosecutors' O...</td>\n",
              "      <td>ナムハンサンソンイック</td>\n",
              "      <td>37.451535</td>\n",
              "      <td>127.159816</td>\n",
              "      <td>31021</td>\n",
              "      <td>성남시수정구</td>\n",
              "      <td>경기도 성남시 수정구 산성대로 지하445(단대동)</td>\n",
              "      <td>경기도 성남시 수정구 단대동 96 남한산성입구역(8호선)</td>\n",
              "      <td>02-6311-8231</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>281</th>\n",
              "      <td>2824</td>\n",
              "      <td>824</td>\n",
              "      <td>8</td>\n",
              "      <td>8호선</td>\n",
              "      <td>지하철8호선</td>\n",
              "      <td>15</td>\n",
              "      <td>단대오거리</td>\n",
              "      <td>단대오거리</td>\n",
              "      <td>丹垈오거리</td>\n",
              "      <td>丹垈五岔路口</td>\n",
              "      <td>Dandaeogeori</td>\n",
              "      <td>タンデオゴリ</td>\n",
              "      <td>37.445210</td>\n",
              "      <td>127.156866</td>\n",
              "      <td>31021</td>\n",
              "      <td>성남시수정구</td>\n",
              "      <td>경기도 성남시 수정구 산성대로 지하365(신흥동)</td>\n",
              "      <td>경기도 성남시 수정구 신흥동 2467 단대오거리역(8호선)</td>\n",
              "      <td>02-6311-8241</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>282</th>\n",
              "      <td>2825</td>\n",
              "      <td>825</td>\n",
              "      <td>8</td>\n",
              "      <td>8호선</td>\n",
              "      <td>지하철8호선</td>\n",
              "      <td>16</td>\n",
              "      <td>신흥</td>\n",
              "      <td>신흥</td>\n",
              "      <td>新興</td>\n",
              "      <td>新兴</td>\n",
              "      <td>Sinheung</td>\n",
              "      <td>シンフン</td>\n",
              "      <td>37.440918</td>\n",
              "      <td>127.147564</td>\n",
              "      <td>31021</td>\n",
              "      <td>성남시수정구</td>\n",
              "      <td>경기도 성남시 수정구 산성대로 지하280(신흥동)</td>\n",
              "      <td>경기도 성남시 수정구 신흥동 2467 신흥역(8호선)</td>\n",
              "      <td>02-6311-8251</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>283</th>\n",
              "      <td>2826</td>\n",
              "      <td>826</td>\n",
              "      <td>8</td>\n",
              "      <td>8호선</td>\n",
              "      <td>지하철8호선</td>\n",
              "      <td>17</td>\n",
              "      <td>수진</td>\n",
              "      <td>수진</td>\n",
              "      <td>壽進</td>\n",
              "      <td>寿进</td>\n",
              "      <td>Sujin</td>\n",
              "      <td>スジン</td>\n",
              "      <td>37.437428</td>\n",
              "      <td>127.140722</td>\n",
              "      <td>31021</td>\n",
              "      <td>성남시수정구</td>\n",
              "      <td>경기도 성남시 수정구 산성대로 지하200(수진동)</td>\n",
              "      <td>경기도 성남시 수정구 수진동 2205-1 수진역(8호선)</td>\n",
              "      <td>02-6311-8261</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>284</th>\n",
              "      <td>2827</td>\n",
              "      <td>827</td>\n",
              "      <td>8</td>\n",
              "      <td>8호선</td>\n",
              "      <td>지하철8호선</td>\n",
              "      <td>18</td>\n",
              "      <td>모란</td>\n",
              "      <td>모란</td>\n",
              "      <td>牡丹</td>\n",
              "      <td>牡丹</td>\n",
              "      <td>Moran</td>\n",
              "      <td>モラン</td>\n",
              "      <td>37.432130</td>\n",
              "      <td>127.129087</td>\n",
              "      <td>31021</td>\n",
              "      <td>성남시수정구</td>\n",
              "      <td>경기도 성남시 수정구 산성대로 지하100(수진동)</td>\n",
              "      <td>경기도 성남시 수정구 수진동 4518 모란역(8호선)</td>\n",
              "      <td>02-6311-8271</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>285 rows × 19 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-19639e83-c9f8-4fb2-a62e-4f4310e65d41')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-19639e83-c9f8-4fb2-a62e-4f4310e65d41 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-19639e83-c9f8-4fb2-a62e-4f4310e65d41');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 4
        }
      ],
      "source": [
        "# 지하철 역 정보 CSV 파일 읽어오기\n",
        "station_info = pd.read_csv(\"seoul-metro-station-info.csv\")\n",
        "\n",
        "# 데이터 확인하기\n",
        "station_info"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 3,
      "id": "a8035ff3",
      "metadata": {
        "id": "a8035ff3",
        "outputId": "305404b7-a74a-4800-b5f6-1aeb9a91a923",
        "colab": {
          "base_uri": "https://localhost:8080/"
        }
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 24871 entries, 0 to 24870\n",
            "Data columns (total 4 columns):\n",
            " #   Column        Non-Null Count  Dtype \n",
            "---  ------        --------------  ----- \n",
            " 0   timestamp     24871 non-null  object\n",
            " 1   station_code  24871 non-null  int64 \n",
            " 2   people_in     24871 non-null  int64 \n",
            " 3   people_out    24871 non-null  int64 \n",
            "dtypes: int64(3), object(1)\n",
            "memory usage: 777.3+ KB\n"
          ]
        }
      ],
      "source": [
        "# 승하차 인원 데이터 상세 정보 확인하기\n",
        "data.info()"
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "2ZtMNw7S7txB"
      },
      "id": "2ZtMNw7S7txB",
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "execution_count": 5,
      "id": "0a882e8e",
      "metadata": {
        "id": "0a882e8e",
        "outputId": "17c90183-ed88-4369-c154-8a67c4627fd3",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 512
        }
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "<ipython-input-5-d28ba1a68930>:2: FutureWarning: The default value of numeric_only in DataFrameGroupBy.sum is deprecated. In a future version, numeric_only will default to False. Either specify numeric_only or select only columns which should be valid for the function.\n",
            "  station_sum = data.groupby(\"station_code\").sum()\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "              people_in  people_out\n",
              "station_code                       \n",
              "150              100535       90029\n",
              "151               45330       44127\n",
              "152               74896       71097\n",
              "153               58696       53818\n",
              "154               52707       52630\n",
              "...                 ...         ...\n",
              "2823              24284       22885\n",
              "2824              19095       18656\n",
              "2825               9720       10320\n",
              "2826              10330        9691\n",
              "2827               9416        7379\n",
              "\n",
              "[279 rows x 2 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-c8cc539d-0391-4454-a834-8ed2cd2f7aa4\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>people_in</th>\n",
              "      <th>people_out</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>station_code</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>150</th>\n",
              "      <td>100535</td>\n",
              "      <td>90029</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>151</th>\n",
              "      <td>45330</td>\n",
              "      <td>44127</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>152</th>\n",
              "      <td>74896</td>\n",
              "      <td>71097</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>153</th>\n",
              "      <td>58696</td>\n",
              "      <td>53818</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>154</th>\n",
              "      <td>52707</td>\n",
              "      <td>52630</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2823</th>\n",
              "      <td>24284</td>\n",
              "      <td>22885</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2824</th>\n",
              "      <td>19095</td>\n",
              "      <td>18656</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2825</th>\n",
              "      <td>9720</td>\n",
              "      <td>10320</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2826</th>\n",
              "      <td>10330</td>\n",
              "      <td>9691</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2827</th>\n",
              "      <td>9416</td>\n",
              "      <td>7379</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>279 rows × 2 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-c8cc539d-0391-4454-a834-8ed2cd2f7aa4')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-c8cc539d-0391-4454-a834-8ed2cd2f7aa4 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-c8cc539d-0391-4454-a834-8ed2cd2f7aa4');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 5
        }
      ],
      "source": [
        "# 승하차 인원 그룹화하여 더하기\n",
        "station_sum = data.groupby(\"station_code\").sum()\n",
        "\n",
        "# 데이터 확인하기\n",
        "station_sum"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 6,
      "id": "4905c442",
      "metadata": {
        "id": "4905c442",
        "outputId": "44b57ba4-752e-496a-ee1b-61f23c158c97",
        "colab": {
          "base_uri": "https://localhost:8080/"
        }
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 285 entries, 0 to 284\n",
            "Data columns (total 19 columns):\n",
            " #   Column             Non-Null Count  Dtype  \n",
            "---  ------             --------------  -----  \n",
            " 0   station.code       285 non-null    int64  \n",
            " 1   station.fr_code    285 non-null    object \n",
            " 2   line.num           285 non-null    int64  \n",
            " 3   line.name          285 non-null    object \n",
            " 4   line.name_sub      285 non-null    object \n",
            " 5   line.station_seq   285 non-null    int64  \n",
            " 6   station.name_full  285 non-null    object \n",
            " 7   station.name       285 non-null    object \n",
            " 8   station.name_chc   285 non-null    object \n",
            " 9   station.name_chn   285 non-null    object \n",
            " 10  station.name_en    285 non-null    object \n",
            " 11  station.name_jp    285 non-null    object \n",
            " 12  geo.latitude       285 non-null    float64\n",
            " 13  geo.longitude      285 non-null    float64\n",
            " 14  geo.sigungu_code   285 non-null    int64  \n",
            " 15  geo.sigungu_name   285 non-null    object \n",
            " 16  geo.addres_road    285 non-null    object \n",
            " 17  geo.address_land   285 non-null    object \n",
            " 18  geo.phone          285 non-null    object \n",
            "dtypes: float64(2), int64(4), object(13)\n",
            "memory usage: 42.4+ KB\n"
          ]
        }
      ],
      "source": [
        "# 지하철 역 정보 확인하기\n",
        "station_info.info()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 7,
      "id": "260c147e",
      "metadata": {
        "id": "260c147e",
        "outputId": "9f677250-aa22-48a5-9a37-5ab38fb27383",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 423
        }
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "     station.code  geo.latitude  geo.longitude\n",
              "0             158     37.580178     127.046835\n",
              "1             157     37.578103     127.034893\n",
              "2             156     37.575297     127.025087\n",
              "3             159     37.572627     127.016429\n",
              "4             155     37.571420     127.009745\n",
              "..            ...           ...            ...\n",
              "280          2823     37.451535     127.159816\n",
              "281          2824     37.445210     127.156866\n",
              "282          2825     37.440918     127.147564\n",
              "283          2826     37.437428     127.140722\n",
              "284          2827     37.432130     127.129087\n",
              "\n",
              "[285 rows x 3 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-cbc843af-0ece-40c4-b789-f9ddb1b80065\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>station.code</th>\n",
              "      <th>geo.latitude</th>\n",
              "      <th>geo.longitude</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>158</td>\n",
              "      <td>37.580178</td>\n",
              "      <td>127.046835</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>157</td>\n",
              "      <td>37.578103</td>\n",
              "      <td>127.034893</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>156</td>\n",
              "      <td>37.575297</td>\n",
              "      <td>127.025087</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>159</td>\n",
              "      <td>37.572627</td>\n",
              "      <td>127.016429</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>155</td>\n",
              "      <td>37.571420</td>\n",
              "      <td>127.009745</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>280</th>\n",
              "      <td>2823</td>\n",
              "      <td>37.451535</td>\n",
              "      <td>127.159816</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>281</th>\n",
              "      <td>2824</td>\n",
              "      <td>37.445210</td>\n",
              "      <td>127.156866</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>282</th>\n",
              "      <td>2825</td>\n",
              "      <td>37.440918</td>\n",
              "      <td>127.147564</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>283</th>\n",
              "      <td>2826</td>\n",
              "      <td>37.437428</td>\n",
              "      <td>127.140722</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>284</th>\n",
              "      <td>2827</td>\n",
              "      <td>37.432130</td>\n",
              "      <td>127.129087</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>285 rows × 3 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-cbc843af-0ece-40c4-b789-f9ddb1b80065')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-cbc843af-0ece-40c4-b789-f9ddb1b80065 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-cbc843af-0ece-40c4-b789-f9ddb1b80065');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 7
        }
      ],
      "source": [
        "# 필요한 행만 추려내기\n",
        "station_info = station_info[['station.code', 'geo.latitude', 'geo.longitude']]\n",
        "\n",
        "# 데이터 확인하기\n",
        "station_info"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 8,
      "id": "bd76a7e8",
      "metadata": {
        "id": "bd76a7e8",
        "outputId": "a7b4840a-c1d6-4a3d-ea83-eb5578da549e",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 455
        }
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "              geo.latitude  geo.longitude\n",
              "station.code                             \n",
              "158              37.580178     127.046835\n",
              "157              37.578103     127.034893\n",
              "156              37.575297     127.025087\n",
              "159              37.572627     127.016429\n",
              "155              37.571420     127.009745\n",
              "...                    ...            ...\n",
              "2823             37.451535     127.159816\n",
              "2824             37.445210     127.156866\n",
              "2825             37.440918     127.147564\n",
              "2826             37.437428     127.140722\n",
              "2827             37.432130     127.129087\n",
              "\n",
              "[285 rows x 2 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-1809edc7-3e87-4e83-99af-b9f671c84381\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>geo.latitude</th>\n",
              "      <th>geo.longitude</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>station.code</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>158</th>\n",
              "      <td>37.580178</td>\n",
              "      <td>127.046835</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>157</th>\n",
              "      <td>37.578103</td>\n",
              "      <td>127.034893</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>156</th>\n",
              "      <td>37.575297</td>\n",
              "      <td>127.025087</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>159</th>\n",
              "      <td>37.572627</td>\n",
              "      <td>127.016429</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>155</th>\n",
              "      <td>37.571420</td>\n",
              "      <td>127.009745</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2823</th>\n",
              "      <td>37.451535</td>\n",
              "      <td>127.159816</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2824</th>\n",
              "      <td>37.445210</td>\n",
              "      <td>127.156866</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2825</th>\n",
              "      <td>37.440918</td>\n",
              "      <td>127.147564</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2826</th>\n",
              "      <td>37.437428</td>\n",
              "      <td>127.140722</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2827</th>\n",
              "      <td>37.432130</td>\n",
              "      <td>127.129087</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>285 rows × 2 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-1809edc7-3e87-4e83-99af-b9f671c84381')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-1809edc7-3e87-4e83-99af-b9f671c84381 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-1809edc7-3e87-4e83-99af-b9f671c84381');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 8
        }
      ],
      "source": [
        "# 색인 변경하기\n",
        "station_info = station_info.set_index('station.code')\n",
        "\n",
        "# 데이터 확인하기\n",
        "station_info"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 9,
      "id": "8b71fd31",
      "metadata": {
        "id": "8b71fd31",
        "outputId": "65ee1d11-1726-4c70-c35d-24b3fd1eaef0",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 455
        }
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "              people_in  people_out  geo.latitude  geo.longitude\n",
              "station_code                                                    \n",
              "150              100535       90029     37.554648     126.972559\n",
              "151               45330       44127     37.564718     126.977108\n",
              "152               74896       71097     37.570161     126.982923\n",
              "153               58696       53818     37.571607     126.991806\n",
              "154               52707       52630     37.570926     127.001849\n",
              "...                 ...         ...           ...            ...\n",
              "2823              24284       22885     37.451535     127.159816\n",
              "2824              19095       18656     37.445210     127.156866\n",
              "2825               9720       10320     37.440918     127.147564\n",
              "2826              10330        9691     37.437428     127.140722\n",
              "2827               9416        7379     37.432130     127.129087\n",
              "\n",
              "[279 rows x 4 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-b61f3a91-1e61-49d7-a9ef-ae6564ee29ac\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>people_in</th>\n",
              "      <th>people_out</th>\n",
              "      <th>geo.latitude</th>\n",
              "      <th>geo.longitude</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>station_code</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>150</th>\n",
              "      <td>100535</td>\n",
              "      <td>90029</td>\n",
              "      <td>37.554648</td>\n",
              "      <td>126.972559</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>151</th>\n",
              "      <td>45330</td>\n",
              "      <td>44127</td>\n",
              "      <td>37.564718</td>\n",
              "      <td>126.977108</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>152</th>\n",
              "      <td>74896</td>\n",
              "      <td>71097</td>\n",
              "      <td>37.570161</td>\n",
              "      <td>126.982923</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>153</th>\n",
              "      <td>58696</td>\n",
              "      <td>53818</td>\n",
              "      <td>37.571607</td>\n",
              "      <td>126.991806</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>154</th>\n",
              "      <td>52707</td>\n",
              "      <td>52630</td>\n",
              "      <td>37.570926</td>\n",
              "      <td>127.001849</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>2823</th>\n",
              "      <td>24284</td>\n",
              "      <td>22885</td>\n",
              "      <td>37.451535</td>\n",
              "      <td>127.159816</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2824</th>\n",
              "      <td>19095</td>\n",
              "      <td>18656</td>\n",
              "      <td>37.445210</td>\n",
              "      <td>127.156866</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2825</th>\n",
              "      <td>9720</td>\n",
              "      <td>10320</td>\n",
              "      <td>37.440918</td>\n",
              "      <td>127.147564</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2826</th>\n",
              "      <td>10330</td>\n",
              "      <td>9691</td>\n",
              "      <td>37.437428</td>\n",
              "      <td>127.140722</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2827</th>\n",
              "      <td>9416</td>\n",
              "      <td>7379</td>\n",
              "      <td>37.432130</td>\n",
              "      <td>127.129087</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>279 rows × 4 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-b61f3a91-1e61-49d7-a9ef-ae6564ee29ac')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-b61f3a91-1e61-49d7-a9ef-ae6564ee29ac button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-b61f3a91-1e61-49d7-a9ef-ae6564ee29ac');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 9
        }
      ],
      "source": [
        "# 데이터 셋 합치기\n",
        "joined_data = station_sum.join(station_info)\n",
        "\n",
        "# 데이터 확인하기\n",
        "joined_data"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 12,
      "id": "0ba3a1af",
      "metadata": {
        "id": "0ba3a1af",
        "outputId": "3d30666e-aadb-4e44-8261-89fbb2e71bfb",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 969
        }
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<folium.folium.Map at 0x7fbf19532110>"
            ],
            "text/html": [
              "<div style=\"width:100%;\"><div style=\"position:relative;width:100%;height:0;padding-bottom:60%;\"><span style=\"color:#565656\">Make this Notebook Trusted to load map: File -> Trust Notebook</span><iframe srcdoc=\"&lt;!DOCTYPE html&gt;\n",
              "&lt;html&gt;\n",
              "&lt;head&gt;\n",
              "    \n",
              "    &lt;meta http-equiv=&quot;content-type&quot; content=&quot;text/html; charset=UTF-8&quot; /&gt;\n",
              "    \n",
              "        &lt;script&gt;\n",
              "            L_NO_TOUCH = false;\n",
              "            L_DISABLE_3D = false;\n",
              "        &lt;/script&gt;\n",
              "    \n",
              "    &lt;style&gt;html, body {width: 100%;height: 100%;margin: 0;padding: 0;}&lt;/style&gt;\n",
              "    &lt;style&gt;#map {position:absolute;top:0;bottom:0;right:0;left:0;}&lt;/style&gt;\n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.9.3/dist/leaflet.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://code.jquery.com/jquery-1.12.4.min.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/js/bootstrap.bundle.min.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.9.3/dist/leaflet.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/css/bootstrap.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://netdna.bootstrapcdn.com/bootstrap/3.0.0/css/bootstrap.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/@fortawesome/fontawesome-free@6.2.0/css/all.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/gh/python-visualization/folium/folium/templates/leaflet.awesome.rotate.min.css&quot;/&gt;\n",
              "    \n",
              "            &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width,\n",
              "                initial-scale=1.0, maximum-scale=1.0, user-scalable=no&quot; /&gt;\n",
              "            &lt;style&gt;\n",
              "                #map_efcddfb0c943ae68b178f9857c30944d {\n",
              "                    position: relative;\n",
              "                    width: 100.0%;\n",
              "                    height: 100.0%;\n",
              "                    left: 0.0%;\n",
              "                    top: 0.0%;\n",
              "                }\n",
              "                .leaflet-container { font-size: 1rem; }\n",
              "            &lt;/style&gt;\n",
              "        \n",
              "&lt;/head&gt;\n",
              "&lt;body&gt;\n",
              "    \n",
              "    \n",
              "            &lt;div class=&quot;folium-map&quot; id=&quot;map_efcddfb0c943ae68b178f9857c30944d&quot; &gt;&lt;/div&gt;\n",
              "        \n",
              "&lt;/body&gt;\n",
              "&lt;script&gt;\n",
              "    \n",
              "    \n",
              "            var map_efcddfb0c943ae68b178f9857c30944d = L.map(\n",
              "                &quot;map_efcddfb0c943ae68b178f9857c30944d&quot;,\n",
              "                {\n",
              "                    center: [37.55, 126.98],\n",
              "                    crs: L.CRS.EPSG3857,\n",
              "                    zoom: 12,\n",
              "                    zoomControl: true,\n",
              "                    preferCanvas: false,\n",
              "                }\n",
              "            );\n",
              "\n",
              "            \n",
              "\n",
              "        \n",
              "    \n",
              "            var tile_layer_f7d9ede114947c8d6d9f81e20ec4457b = L.tileLayer(\n",
              "                &quot;https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png&quot;,\n",
              "                {&quot;attribution&quot;: &quot;Data by \\u0026copy; \\u003ca target=\\&quot;_blank\\&quot; href=\\&quot;http://openstreetmap.org\\&quot;\\u003eOpenStreetMap\\u003c/a\\u003e, under \\u003ca target=\\&quot;_blank\\&quot; href=\\&quot;http://www.openstreetmap.org/copyright\\&quot;\\u003eODbL\\u003c/a\\u003e.&quot;, &quot;detectRetina&quot;: false, &quot;maxNativeZoom&quot;: 18, &quot;maxZoom&quot;: 18, &quot;minZoom&quot;: 0, &quot;noWrap&quot;: false, &quot;opacity&quot;: 1, &quot;subdomains&quot;: &quot;abc&quot;, &quot;tms&quot;: false}\n",
              "            ).addTo(map_efcddfb0c943ae68b178f9857c30944d);\n",
              "        \n",
              "&lt;/script&gt;\n",
              "&lt;/html&gt;\" style=\"position:absolute;width:100%;height:100%;left:0;top:0;border:none !important;\" allowfullscreen webkitallowfullscreen mozallowfullscreen></iframe></div></div>"
            ]
          },
          "metadata": {},
          "execution_count": 12
        }
      ],
      "source": [
        "# 승차용 서울 지도 만들기\n",
        "seoul_in = folium.Map(location=[37.55, 126.98], zoom_start = 12)\n",
        "\n",
        "# 지도 확인하기\n",
        "seoul_in"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 13,
      "id": "b65390ee",
      "metadata": {
        "scrolled": false,
        "id": "b65390ee",
        "outputId": "24806aaf-8e0b-48d6-c0b3-047bb7b81748",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 969
        }
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<folium.folium.Map at 0x7fbf19532110>"
            ],
            "text/html": [
              "<div style=\"width:100%;\"><div style=\"position:relative;width:100%;height:0;padding-bottom:60%;\"><span style=\"color:#565656\">Make this Notebook Trusted to load map: File -> Trust Notebook</span><iframe srcdoc=\"&lt;!DOCTYPE html&gt;\n",
              "&lt;html&gt;\n",
              "&lt;head&gt;\n",
              "    \n",
              "    &lt;meta http-equiv=&quot;content-type&quot; content=&quot;text/html; charset=UTF-8&quot; /&gt;\n",
              "    \n",
              "        &lt;script&gt;\n",
              "            L_NO_TOUCH = false;\n",
              "            L_DISABLE_3D = false;\n",
              "        &lt;/script&gt;\n",
              "    \n",
              "    &lt;style&gt;html, body {width: 100%;height: 100%;margin: 0;padding: 0;}&lt;/style&gt;\n",
              "    &lt;style&gt;#map {position:absolute;top:0;bottom:0;right:0;left:0;}&lt;/style&gt;\n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.9.3/dist/leaflet.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://code.jquery.com/jquery-1.12.4.min.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/js/bootstrap.bundle.min.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.9.3/dist/leaflet.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/css/bootstrap.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://netdna.bootstrapcdn.com/bootstrap/3.0.0/css/bootstrap.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/@fortawesome/fontawesome-free@6.2.0/css/all.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/gh/python-visualization/folium/folium/templates/leaflet.awesome.rotate.min.css&quot;/&gt;\n",
              "    \n",
              "            &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width,\n",
              "                initial-scale=1.0, maximum-scale=1.0, user-scalable=no&quot; /&gt;\n",
              "            &lt;style&gt;\n",
              "                #map_efcddfb0c943ae68b178f9857c30944d {\n",
              "                    position: relative;\n",
              "                    width: 100.0%;\n",
              "                    height: 100.0%;\n",
              "                    left: 0.0%;\n",
              "                    top: 0.0%;\n",
              "                }\n",
              "                .leaflet-container { font-size: 1rem; }\n",
              "            &lt;/style&gt;\n",
              "        \n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/gh/python-visualization/folium@main/folium/templates/leaflet_heat.min.js&quot;&gt;&lt;/script&gt;\n",
              "&lt;/head&gt;\n",
              "&lt;body&gt;\n",
              "    \n",
              "    \n",
              "            &lt;div class=&quot;folium-map&quot; id=&quot;map_efcddfb0c943ae68b178f9857c30944d&quot; &gt;&lt;/div&gt;\n",
              "        \n",
              "&lt;/body&gt;\n",
              "&lt;script&gt;\n",
              "    \n",
              "    \n",
              "            var map_efcddfb0c943ae68b178f9857c30944d = L.map(\n",
              "                &quot;map_efcddfb0c943ae68b178f9857c30944d&quot;,\n",
              "                {\n",
              "                    center: [37.55, 126.98],\n",
              "                    crs: L.CRS.EPSG3857,\n",
              "                    zoom: 12,\n",
              "                    zoomControl: true,\n",
              "                    preferCanvas: false,\n",
              "                }\n",
              "            );\n",
              "\n",
              "            \n",
              "\n",
              "        \n",
              "    \n",
              "            var tile_layer_f7d9ede114947c8d6d9f81e20ec4457b = L.tileLayer(\n",
              "                &quot;https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png&quot;,\n",
              "                {&quot;attribution&quot;: &quot;Data by \\u0026copy; \\u003ca target=\\&quot;_blank\\&quot; href=\\&quot;http://openstreetmap.org\\&quot;\\u003eOpenStreetMap\\u003c/a\\u003e, under \\u003ca target=\\&quot;_blank\\&quot; href=\\&quot;http://www.openstreetmap.org/copyright\\&quot;\\u003eODbL\\u003c/a\\u003e.&quot;, &quot;detectRetina&quot;: false, &quot;maxNativeZoom&quot;: 18, &quot;maxZoom&quot;: 18, &quot;minZoom&quot;: 0, &quot;noWrap&quot;: false, &quot;opacity&quot;: 1, &quot;subdomains&quot;: &quot;abc&quot;, &quot;tms&quot;: false}\n",
              "            ).addTo(map_efcddfb0c943ae68b178f9857c30944d);\n",
              "        \n",
              "    \n",
              "            var heat_map_b4a095f3cced9db5fd5670a8a81f9649 = L.heatLayer(\n",
              "                [[37.554648, 126.972559, 100535.0], [37.564718, 126.977108, 45330.0], [37.570161, 126.982923, 74896.0], [37.571607, 126.991806, 58696.0], [37.570926, 127.001849, 52707.0], [37.57142, 127.009745, 32238.0], [37.575297, 127.025087, 35441.0], [37.578103, 127.034893, 48845.0], [37.580178, 127.046835, 59487.0], [37.572627, 127.016429, 31584.0], [37.564718, 126.977108, 46315.0], [37.566014, 126.982618, 90216.0], [37.566295, 126.99191, 44541.0], [37.566941, 126.998079, 28985.0], [37.565138, 127.007896, 31343.0], [37.565972, 127.01782, 36702.0], [37.564354, 127.029354, 34620.0], [37.561533, 127.037732, 38702.0], [37.555273, 127.043655, 14712.0], [37.547184, 127.047367, 46102.0], [37.544581, 127.055961, 75254.0], [37.540693, 127.07023, 88695.0], [37.537077, 127.085916, 60064.0], [37.535095, 127.094681, 78988.0], [37.520733, 127.10379, 32354.0], [37.51395, 127.102234, 165251.0], [37.511687, 127.086162, 50617.0], [37.510997, 127.073642, 16172.0], [37.508844, 127.06316, 111072.0], [37.504503, 127.049008, 119243.0], [37.500622, 127.036456, 107571.0], [37.497175, 127.027926, 183659.0], [37.493415, 127.01408, 71921.0], [37.491897, 127.007917, 45187.0], [37.481426, 126.997596, 37954.0], [37.47653, 126.981685, 90568.0], [37.47693, 126.963693, 70842.0], [37.481247, 126.952739, 120713.0], [37.482362, 126.941892, 63210.0], [37.484201, 126.929715, 171651.0], [37.487462, 126.913149, 72099.0], [37.485266, 126.901401, 147773.0], [37.49297, 126.895801, 68679.0], [37.508725, 126.891295, 124561.0], [37.517933, 126.89476, 48084.0], [37.52497, 126.895951, 54935.0], [37.53438, 126.902281, 45283.0], [37.549463, 126.913739, 72053.0], [37.557192, 126.925381, 119874.0], [37.555134, 126.936893, 78993.0], [37.556733, 126.946013, 27490.0], [37.557345, 126.956141, 25729.0], [37.559973, 126.963672, 23686.0], [37.561904, 127.050899, 7837.0], [37.57004, 127.046481, 4042.0], [37.575297, 127.025087, 10113.0], [37.514287, 126.882768, 3655.0], [37.512398, 126.865819, 16566.0], [37.520074, 126.852912, 25367.0], [37.574028, 127.038091, 6380.0], [37.648048, 126.913951, 8835.0], [37.636763, 126.918821, 53604.0], [37.619001, 126.921008, 102825.0], [37.610469, 126.929887, 44919.0], [37.600927, 126.935756, 37581.0], [37.589066, 126.943736, 45414.0], [37.582299, 126.950291, 10265.0], [37.574571, 126.957748, 18135.0], [37.575762, 126.97353, 40688.0], [37.576477, 126.985443, 38737.0], [37.571607, 126.991806, 21190.0], [37.566295, 126.99191, 22357.0], [37.561243, 126.99428, 0.0], [37.559052, 127.005602, 18388.0], [37.55434, 127.010655, 32687.0], [37.548034, 127.015872, 21244.0], [37.540685, 127.017965, 23290.0], [37.527072, 127.028461, 76624.0], [37.516334, 127.020114, 73110.0], [37.512759, 127.01122, 10845.0], [37.50481, 127.004943, 116766.0], [37.493415, 127.01408, 28125.0], [37.485013, 127.016189, 70637.0], [37.484147, 127.034631, 83407.0], [37.486947, 127.046769, 28367.0], [37.490858, 127.055381, 12744.0], [37.494612, 127.063642, 25991.0], [37.496663, 127.070594, 4212.0], [37.493514, 127.079532, 23262.0], [37.483681, 127.08439, 21946.0], [37.487371, 127.10188, 40848.0], [37.492522, 127.118234, 22467.0], [37.495918, 127.12454, 18267.0], [37.502162, 127.128111, 14921.0], [37.670272, 127.079066, 34926.0], [37.660878, 127.073572, 52498.0], [37.655128, 127.061368, 51011.0], [37.653166, 127.047731, 69425.0], [37.648627, 127.034709, 79157.0], [37.638052, 127.025732, 95168.0], [37.62667, 127.025983, 40671.0], [37.613292, 127.030053, 76341.0], [37.603407, 127.025053, 49861.0], [37.592624, 127.016403, 51790.0], [37.588458, 127.006221, 33657.0], [37.582336, 127.001844, 70512.0], [37.57142, 127.009745, 45363.0], [37.565138, 127.007896, 36725.0], [37.561243, 126.99428, 58105.0], [37.560989, 126.986325, 41773.0], [37.558514, 126.978246, 51789.0], [37.554648, 126.972559, 24224.0], [37.54456, 126.972106, 30118.0], [37.534777, 126.97311, 10620.0], [37.52917, 126.967894, 35833.0], [37.522272, 126.974345, 16043.0], [37.502971, 126.979306, 8249.0], [37.486263, 126.981989, 48723.0], [37.47653, 126.981685, 59599.0], [37.463873, 126.989134, 2759.0], [37.577446, 126.812741, 18047.0], [37.572399, 126.806171, 13916.0], [37.562434, 126.801058, 22605.0], [37.561184, 126.811973, 17953.0], [37.560183, 126.825448, 22045.0], [37.558598, 126.837668, 44453.0], [37.548768, 126.836318, 34197.0], [37.541513, 126.840461, 74100.0], [37.531768, 126.846683, 77914.0], [37.524997, 126.856191, 35797.0], [37.526065, 126.864931, 41643.0], [37.524496, 126.875181, 55516.0], [37.525648, 126.885778, 17996.0], [37.52497, 126.895951, 10541.0], [37.522669, 126.905139, 23855.0], [37.517122, 126.917169, 9973.0], [37.521624, 126.924191, 56230.0], [37.527098, 126.932901, 18238.0], [37.539574, 126.945932, 32725.0], [37.544018, 126.951592, 31709.0], [37.553736, 126.95682, 15948.0], [37.559973, 126.963672, 10775.0], [37.565773, 126.966641, 40374.0], [37.571026, 126.976669, 66766.0], [37.571607, 126.991806, 25601.0], [37.566941, 126.998079, 13499.0], [37.565138, 127.007896, 6717.0], [37.560245, 127.013828, 9996.0], [37.554548, 127.020331, 16124.0], [37.557322, 127.029476, 20964.0], [37.561533, 127.037732, 12275.0], [37.5661, 127.042973, 14426.0], [37.566747, 127.052704, 42709.0], [37.56144, 127.064623, 45558.0], [37.557121, 127.079542, 29239.0], [37.551691, 127.089761, 41405.0], [37.545303, 127.10357, 33938.0], [37.538397, 127.123572, 51004.0], [37.535804, 127.132481, 50061.0], [37.537801, 127.140004, 21136.0], [37.545477, 127.142853, 25208.0], [37.55137, 127.143999, 20688.0], [37.555004, 127.154151, 21524.0], [37.556712, 127.166417, 39892.0], [37.527788, 127.136248, 21277.0], [37.516078, 127.130848, 10251.0], [37.508857, 127.126133, 17406.0], [37.502162, 127.128111, 9164.0], [37.498079, 127.13482, 15603.0], [37.493105, 127.14415, 19580.0], [37.49499, 127.152781, 16273.0], [37.563118, 127.192932, 35156.0], [37.552059, 127.20388, 12803.0], [37.598605, 126.915577, 47593.0], [37.606021, 126.922744, 10174.0], [37.610469, 126.929887, 12210.0], [37.618456, 126.933031, 7937.0], [37.619001, 126.921008, 0.0], [37.611377, 126.91727, 18919.0], [37.591148, 126.913629, 33648.0], [37.583876, 126.909645, 27599.0], [37.576646, 126.900984, 34069.0], [37.569532, 126.899298, 13784.0], [37.563515, 126.903343, 36175.0], [37.556094, 126.910052, 36573.0], [37.549463, 126.913739, 32603.0], [37.547716, 126.922852, 18790.0], [37.547456, 126.931993, 20673.0], [37.547771, 126.942069, 19183.0], [37.544018, 126.951592, 42818.0], [37.539261, 126.961351, 17155.0], [37.534777, 126.97311, 12842.0], [37.534675, 126.986695, 11963.0], [37.534488, 126.994302, 24917.0], [37.539631, 127.001725, 17577.0], [37.548013, 127.007055, 5789.0], [37.55434, 127.010655, 8960.0], [37.560245, 127.013828, 9608.0], [37.565972, 127.01782, 17929.0], [37.572627, 127.016429, 23314.0], [37.579661, 127.015241, 8757.0], [37.585286, 127.019381, 12719.0], [37.586272, 127.029005, 15304.0], [37.590508, 127.036296, 13021.0], [37.601948, 127.041518, 19498.0], [37.606377, 127.048491, 11073.0], [37.610537, 127.056431, 14890.0], [37.614805, 127.065851, 22525.0], [37.617983, 127.07512, 9548.0], [37.620064, 127.084689, 17327.0], [37.617283, 127.091401, 15271.0], [37.700109, 127.053196, 4076.0], [37.689313, 127.046222, 16901.0], [37.67785, 127.055315, 25586.0], [37.66494, 127.057675, 22690.0], [37.655128, 127.061368, 36924.0], [37.644583, 127.064303, 24660.0], [37.636352, 127.06799, 30572.0], [37.625742, 127.072896, 21047.0], [37.617983, 127.07512, 14959.0], [37.610637, 127.077725, 18916.0], [37.602545, 127.079264, 20488.0], [37.596362, 127.085032, 32260.0], [37.588579, 127.087503, 29279.0], [37.580894, 127.088478, 32017.0], [37.573647, 127.086727, 11457.0], [37.565923, 127.08432, 18046.0], [37.557121, 127.079542, 26705.0], [37.548014, 127.074658, 25112.0], [37.540693, 127.07023, 24339.0], [37.53154, 127.066704, 13436.0], [37.519365, 127.05335, 29526.0], [37.517186, 127.04128, 23486.0], [37.514229, 127.031656, 31967.0], [37.511093, 127.021415, 31024.0], [37.508178, 127.011727, 10119.0], [37.50481, 127.004943, 32904.0], [37.487618, 126.993513, 22619.0], [37.486263, 126.981989, 26798.0], [37.484596, 126.971251, 19960.0], [37.496029, 126.953822, 19771.0], [37.502834, 126.94791, 17457.0], [37.504898, 126.93915, 17812.0], [37.499701, 126.928276, 29085.0], [37.499872, 126.920428, 15578.0], [37.50008, 126.90993, 21843.0], [37.49297, 126.895801, 17899.0], [37.486056, 126.887249, 28583.0], [37.481072, 126.882343, 64011.0], [37.47605, 126.867911, 36990.0], [37.479252, 126.854876, 43559.0], [37.486637, 126.838713, 18396.0], [37.492258, 126.823388, 17289.0], [37.506207, 126.810939, 12994.0], [37.50538, 126.797337, 8265.0], [37.503663, 126.787036, 15794.0], [37.503048, 126.77596, 24290.0], [37.504631, 126.763538, 22441.0], [37.505781, 126.753083, 21726.0], [37.506411, 126.742153, 7830.0], [37.506997, 126.73128, 15845.0], [37.508336, 126.720548, 19298.0], [37.55021, 127.127562, 33522.0], [37.538397, 127.123572, 30253.0], [37.530341, 127.120508, 17375.0], [37.517409, 127.112359, 10475.0], [37.51395, 127.102234, 29037.0], [37.505431, 127.106979, 13855.0], [37.499703, 127.112183, 13300.0], [37.492522, 127.118234, 13938.0], [37.485855, 127.1225, 28652.0], [37.478703, 127.126191, 32162.0], [37.470047, 127.126662, 16917.0], [37.457122, 127.149908, 12907.0], [37.451535, 127.159816, 24284.0], [37.44521, 127.156866, 19095.0], [37.440918, 127.147564, 9720.0], [37.437428, 127.140722, 10330.0], [37.43213, 127.129087, 9416.0]],\n",
              "                {&quot;blur&quot;: 15, &quot;maxZoom&quot;: 18, &quot;minOpacity&quot;: 0.5, &quot;radius&quot;: 25}\n",
              "            ).addTo(map_efcddfb0c943ae68b178f9857c30944d);\n",
              "        \n",
              "&lt;/script&gt;\n",
              "&lt;/html&gt;\" style=\"position:absolute;width:100%;height:100%;left:0;top:0;border:none !important;\" allowfullscreen webkitallowfullscreen mozallowfullscreen></iframe></div></div>"
            ]
          },
          "metadata": {},
          "execution_count": 13
        }
      ],
      "source": [
        "# 히트맵 플러그인 모듈 탑재\n",
        "from folium.plugins import HeatMap \n",
        "\n",
        "# 히트맵 플러그인 지도에 추가하기\n",
        "HeatMap(data = joined_data[['geo.latitude', 'geo.longitude', 'people_in']]).add_to(seoul_in)\n",
        "\n",
        "# 지도 확인하기\n",
        "seoul_in"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 14,
      "id": "1d452c58",
      "metadata": {
        "scrolled": false,
        "id": "1d452c58",
        "outputId": "59893d31-373c-47a6-8425-03f576537cb6",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 969
        }
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<folium.folium.Map at 0x7fbf195217b0>"
            ],
            "text/html": [
              "<div style=\"width:100%;\"><div style=\"position:relative;width:100%;height:0;padding-bottom:60%;\"><span style=\"color:#565656\">Make this Notebook Trusted to load map: File -> Trust Notebook</span><iframe srcdoc=\"&lt;!DOCTYPE html&gt;\n",
              "&lt;html&gt;\n",
              "&lt;head&gt;\n",
              "    \n",
              "    &lt;meta http-equiv=&quot;content-type&quot; content=&quot;text/html; charset=UTF-8&quot; /&gt;\n",
              "    \n",
              "        &lt;script&gt;\n",
              "            L_NO_TOUCH = false;\n",
              "            L_DISABLE_3D = false;\n",
              "        &lt;/script&gt;\n",
              "    \n",
              "    &lt;style&gt;html, body {width: 100%;height: 100%;margin: 0;padding: 0;}&lt;/style&gt;\n",
              "    &lt;style&gt;#map {position:absolute;top:0;bottom:0;right:0;left:0;}&lt;/style&gt;\n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.9.3/dist/leaflet.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://code.jquery.com/jquery-1.12.4.min.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/js/bootstrap.bundle.min.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.9.3/dist/leaflet.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/css/bootstrap.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://netdna.bootstrapcdn.com/bootstrap/3.0.0/css/bootstrap.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/@fortawesome/fontawesome-free@6.2.0/css/all.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/gh/python-visualization/folium/folium/templates/leaflet.awesome.rotate.min.css&quot;/&gt;\n",
              "    \n",
              "            &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width,\n",
              "                initial-scale=1.0, maximum-scale=1.0, user-scalable=no&quot; /&gt;\n",
              "            &lt;style&gt;\n",
              "                #map_96e5aaa763b1c76727ce04c7b67320e8 {\n",
              "                    position: relative;\n",
              "                    width: 100.0%;\n",
              "                    height: 100.0%;\n",
              "                    left: 0.0%;\n",
              "                    top: 0.0%;\n",
              "                }\n",
              "                .leaflet-container { font-size: 1rem; }\n",
              "            &lt;/style&gt;\n",
              "        \n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/gh/python-visualization/folium@main/folium/templates/leaflet_heat.min.js&quot;&gt;&lt;/script&gt;\n",
              "&lt;/head&gt;\n",
              "&lt;body&gt;\n",
              "    \n",
              "    \n",
              "            &lt;div class=&quot;folium-map&quot; id=&quot;map_96e5aaa763b1c76727ce04c7b67320e8&quot; &gt;&lt;/div&gt;\n",
              "        \n",
              "&lt;/body&gt;\n",
              "&lt;script&gt;\n",
              "    \n",
              "    \n",
              "            var map_96e5aaa763b1c76727ce04c7b67320e8 = L.map(\n",
              "                &quot;map_96e5aaa763b1c76727ce04c7b67320e8&quot;,\n",
              "                {\n",
              "                    center: [37.55, 126.98],\n",
              "                    crs: L.CRS.EPSG3857,\n",
              "                    zoom: 12,\n",
              "                    zoomControl: true,\n",
              "                    preferCanvas: false,\n",
              "                }\n",
              "            );\n",
              "\n",
              "            \n",
              "\n",
              "        \n",
              "    \n",
              "            var tile_layer_51d2c423c41c5240a40fc4e1c2231e70 = L.tileLayer(\n",
              "                &quot;https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png&quot;,\n",
              "                {&quot;attribution&quot;: &quot;Data by \\u0026copy; \\u003ca target=\\&quot;_blank\\&quot; href=\\&quot;http://openstreetmap.org\\&quot;\\u003eOpenStreetMap\\u003c/a\\u003e, under \\u003ca target=\\&quot;_blank\\&quot; href=\\&quot;http://www.openstreetmap.org/copyright\\&quot;\\u003eODbL\\u003c/a\\u003e.&quot;, &quot;detectRetina&quot;: false, &quot;maxNativeZoom&quot;: 18, &quot;maxZoom&quot;: 18, &quot;minZoom&quot;: 0, &quot;noWrap&quot;: false, &quot;opacity&quot;: 1, &quot;subdomains&quot;: &quot;abc&quot;, &quot;tms&quot;: false}\n",
              "            ).addTo(map_96e5aaa763b1c76727ce04c7b67320e8);\n",
              "        \n",
              "    \n",
              "            var heat_map_1e5a855d08e81451aa0316a3ad08314f = L.heatLayer(\n",
              "                [[37.554648, 126.972559, 90029.0], [37.564718, 126.977108, 44127.0], [37.570161, 126.982923, 71097.0], [37.571607, 126.991806, 53818.0], [37.570926, 127.001849, 52630.0], [37.57142, 127.009745, 31690.0], [37.575297, 127.025087, 35530.0], [37.578103, 127.034893, 50798.0], [37.580178, 127.046835, 59592.0], [37.572627, 127.016429, 32748.0], [37.564718, 126.977108, 43726.0], [37.566014, 126.982618, 89852.0], [37.566295, 126.99191, 43174.0], [37.566941, 126.998079, 28360.0], [37.565138, 127.007896, 34312.0], [37.565972, 127.01782, 38362.0], [37.564354, 127.029354, 34578.0], [37.561533, 127.037732, 32303.0], [37.555273, 127.043655, 15338.0], [37.547184, 127.047367, 49421.0], [37.544581, 127.055961, 81171.0], [37.540693, 127.07023, 95507.0], [37.537077, 127.085916, 60392.0], [37.535095, 127.094681, 75526.0], [37.520733, 127.10379, 31659.0], [37.51395, 127.102234, 160859.0], [37.511687, 127.086162, 51308.0], [37.510997, 127.073642, 17380.0], [37.508844, 127.06316, 110202.0], [37.504503, 127.049008, 106267.0], [37.500622, 127.036456, 115583.0], [37.497175, 127.027926, 178430.0], [37.493415, 127.01408, 78683.0], [37.491897, 127.007917, 43754.0], [37.481426, 126.997596, 39468.0], [37.47653, 126.981685, 97372.0], [37.47693, 126.963693, 71748.0], [37.481247, 126.952739, 121298.0], [37.482362, 126.941892, 61233.0], [37.484201, 126.929715, 171034.0], [37.487462, 126.913149, 71264.0], [37.485266, 126.901401, 149539.0], [37.49297, 126.895801, 70513.0], [37.508725, 126.891295, 121582.0], [37.517933, 126.89476, 48870.0], [37.52497, 126.895951, 55829.0], [37.53438, 126.902281, 51069.0], [37.549463, 126.913739, 74500.0], [37.557192, 126.925381, 122238.0], [37.555134, 126.936893, 80969.0], [37.556733, 126.946013, 29181.0], [37.557345, 126.956141, 25558.0], [37.559973, 126.963672, 24408.0], [37.561904, 127.050899, 7819.0], [37.57004, 127.046481, 4647.0], [37.575297, 127.025087, 10266.0], [37.514287, 126.882768, 3704.0], [37.512398, 126.865819, 17732.0], [37.520074, 126.852912, 26456.0], [37.574028, 127.038091, 6845.0], [37.648048, 126.913951, 8812.0], [37.636763, 126.918821, 52231.0], [37.619001, 126.921008, 97865.0], [37.610469, 126.929887, 49110.0], [37.600927, 126.935756, 34859.0], [37.589066, 126.943736, 44328.0], [37.582299, 126.950291, 10599.0], [37.574571, 126.957748, 19346.0], [37.575762, 126.97353, 40252.0], [37.576477, 126.985443, 39263.0], [37.571607, 126.991806, 24677.0], [37.566295, 126.99191, 22719.0], [37.561243, 126.99428, 0.0], [37.559052, 127.005602, 20130.0], [37.55434, 127.010655, 32056.0], [37.548034, 127.015872, 20626.0], [37.540685, 127.017965, 24460.0], [37.527072, 127.028461, 79987.0], [37.516334, 127.020114, 75618.0], [37.512759, 127.01122, 10979.0], [37.50481, 127.004943, 105211.0], [37.493415, 127.01408, 19192.0], [37.485013, 127.016189, 70509.0], [37.484147, 127.034631, 90904.0], [37.486947, 127.046769, 27136.0], [37.490858, 127.055381, 12760.0], [37.494612, 127.063642, 25470.0], [37.496663, 127.070594, 4298.0], [37.493514, 127.079532, 21759.0], [37.483681, 127.08439, 22040.0], [37.487371, 127.10188, 41415.0], [37.492522, 127.118234, 22271.0], [37.495918, 127.12454, 18539.0], [37.502162, 127.128111, 13743.0], [37.670272, 127.079066, 32667.0], [37.660878, 127.073572, 49206.0], [37.655128, 127.061368, 56304.0], [37.653166, 127.047731, 74081.0], [37.648627, 127.034709, 73778.0], [37.638052, 127.025732, 94061.0], [37.62667, 127.025983, 40038.0], [37.613292, 127.030053, 74695.0], [37.603407, 127.025053, 49207.0], [37.592624, 127.016403, 50447.0], [37.588458, 127.006221, 33457.0], [37.582336, 127.001844, 70449.0], [37.57142, 127.009745, 47137.0], [37.565138, 127.007896, 34288.0], [37.561243, 126.99428, 59671.0], [37.560989, 126.986325, 42951.0], [37.558514, 126.978246, 53525.0], [37.554648, 126.972559, 32616.0], [37.54456, 126.972106, 29393.0], [37.534777, 126.97311, 11758.0], [37.52917, 126.967894, 36910.0], [37.522272, 126.974345, 18184.0], [37.502971, 126.979306, 9418.0], [37.486263, 126.981989, 53016.0], [37.47653, 126.981685, 53797.0], [37.463873, 126.989134, 2558.0], [37.577446, 126.812741, 17591.0], [37.572399, 126.806171, 13876.0], [37.562434, 126.801058, 20590.0], [37.561184, 126.811973, 17457.0], [37.560183, 126.825448, 21477.0], [37.558598, 126.837668, 44972.0], [37.548768, 126.836318, 35157.0], [37.541513, 126.840461, 70018.0], [37.531768, 126.846683, 77326.0], [37.524997, 126.856191, 29727.0], [37.526065, 126.864931, 45519.0], [37.524496, 126.875181, 59178.0], [37.525648, 126.885778, 18478.0], [37.52497, 126.895951, 10613.0], [37.522669, 126.905139, 24681.0], [37.517122, 126.917169, 11374.0], [37.521624, 126.924191, 57778.0], [37.527098, 126.932901, 18286.0], [37.539574, 126.945932, 33545.0], [37.544018, 126.951592, 33612.0], [37.553736, 126.95682, 16325.0], [37.559973, 126.963672, 11087.0], [37.565773, 126.966641, 40934.0], [37.571026, 126.976669, 67665.0], [37.571607, 126.991806, 25298.0], [37.566941, 126.998079, 13546.0], [37.565138, 127.007896, 7573.0], [37.560245, 127.013828, 9168.0], [37.554548, 127.020331, 17142.0], [37.557322, 127.029476, 18916.0], [37.561533, 127.037732, 13282.0], [37.5661, 127.042973, 13822.0], [37.566747, 127.052704, 40350.0], [37.56144, 127.064623, 45643.0], [37.557121, 127.079542, 32183.0], [37.551691, 127.089761, 41801.0], [37.545303, 127.10357, 32095.0], [37.538397, 127.123572, 49752.0], [37.535804, 127.132481, 47651.0], [37.537801, 127.140004, 22235.0], [37.545477, 127.142853, 23991.0], [37.55137, 127.143999, 21511.0], [37.555004, 127.154151, 21566.0], [37.556712, 127.166417, 37264.0], [37.527788, 127.136248, 21628.0], [37.516078, 127.130848, 9040.0], [37.508857, 127.126133, 17853.0], [37.502162, 127.128111, 8791.0], [37.498079, 127.13482, 16706.0], [37.493105, 127.14415, 18913.0], [37.49499, 127.152781, 16849.0], [37.563118, 127.192932, 35261.0], [37.552059, 127.20388, 13177.0], [37.598605, 126.915577, 48203.0], [37.606021, 126.922744, 11721.0], [37.610469, 126.929887, 12077.0], [37.618456, 126.933031, 8926.0], [37.619001, 126.921008, 0.0], [37.611377, 126.91727, 14904.0], [37.591148, 126.913629, 32140.0], [37.583876, 126.909645, 27875.0], [37.576646, 126.900984, 37067.0], [37.569532, 126.899298, 13610.0], [37.563515, 126.903343, 33485.0], [37.556094, 126.910052, 39865.0], [37.549463, 126.913739, 30876.0], [37.547716, 126.922852, 20724.0], [37.547456, 126.931993, 20252.0], [37.547771, 126.942069, 19896.0], [37.544018, 126.951592, 41330.0], [37.539261, 126.961351, 15735.0], [37.534777, 126.97311, 11360.0], [37.534675, 126.986695, 11583.0], [37.534488, 126.994302, 25100.0], [37.539631, 127.001725, 19714.0], [37.548013, 127.007055, 6009.0], [37.55434, 127.010655, 8894.0], [37.560245, 127.013828, 10042.0], [37.565972, 127.01782, 19611.0], [37.572627, 127.016429, 23047.0], [37.579661, 127.015241, 7347.0], [37.585286, 127.019381, 12118.0], [37.586272, 127.029005, 15704.0], [37.590508, 127.036296, 13051.0], [37.601948, 127.041518, 19865.0], [37.606377, 127.048491, 10151.0], [37.610537, 127.056431, 14129.0], [37.614805, 127.065851, 22880.0], [37.617983, 127.07512, 10193.0], [37.620064, 127.084689, 14539.0], [37.617283, 127.091401, 14826.0], [37.700109, 127.053196, 2031.0], [37.689313, 127.046222, 22655.0], [37.67785, 127.055315, 25907.0], [37.66494, 127.057675, 22216.0], [37.655128, 127.061368, 37655.0], [37.644583, 127.064303, 22712.0], [37.636352, 127.06799, 29298.0], [37.625742, 127.072896, 21619.0], [37.617983, 127.07512, 13766.0], [37.610637, 127.077725, 18897.0], [37.602545, 127.079264, 20184.0], [37.596362, 127.085032, 30995.0], [37.588579, 127.087503, 29206.0], [37.580894, 127.088478, 31813.0], [37.573647, 127.086727, 11615.0], [37.565923, 127.08432, 17591.0], [37.557121, 127.079542, 21638.0], [37.548014, 127.074658, 25106.0], [37.540693, 127.07023, 24415.0], [37.53154, 127.066704, 13210.0], [37.519365, 127.05335, 31545.0], [37.517186, 127.04128, 25499.0], [37.514229, 127.031656, 33267.0], [37.511093, 127.021415, 33061.0], [37.508178, 127.011727, 9728.0], [37.50481, 127.004943, 23094.0], [37.487618, 126.993513, 22817.0], [37.486263, 126.981989, 26135.0], [37.484596, 126.971251, 19502.0], [37.496029, 126.953822, 20930.0], [37.502834, 126.94791, 17488.0], [37.504898, 126.93915, 17714.0], [37.499701, 126.928276, 29082.0], [37.499872, 126.920428, 15556.0], [37.50008, 126.90993, 21115.0], [37.49297, 126.895801, 17479.0], [37.486056, 126.887249, 29192.0], [37.481072, 126.882343, 62979.0], [37.47605, 126.867911, 37295.0], [37.479252, 126.854876, 43344.0], [37.486637, 126.838713, 17736.0], [37.492258, 126.823388, 16314.0], [37.506207, 126.810939, 12866.0], [37.50538, 126.797337, 7502.0], [37.503663, 126.787036, 15328.0], [37.503048, 126.77596, 23596.0], [37.504631, 126.763538, 22139.0], [37.505781, 126.753083, 21795.0], [37.506411, 126.742153, 7301.0], [37.506997, 126.73128, 16260.0], [37.508336, 126.720548, 16438.0], [37.55021, 127.127562, 31128.0], [37.538397, 127.123572, 34108.0], [37.530341, 127.120508, 18296.0], [37.517409, 127.112359, 10763.0], [37.51395, 127.102234, 30493.0], [37.505431, 127.106979, 15936.0], [37.499703, 127.112183, 13777.0], [37.492522, 127.118234, 15650.0], [37.485855, 127.1225, 29742.0], [37.478703, 127.126191, 32737.0], [37.470047, 127.126662, 15318.0], [37.457122, 127.149908, 13052.0], [37.451535, 127.159816, 22885.0], [37.44521, 127.156866, 18656.0], [37.440918, 127.147564, 10320.0], [37.437428, 127.140722, 9691.0], [37.43213, 127.129087, 7379.0]],\n",
              "                {&quot;blur&quot;: 15, &quot;maxZoom&quot;: 18, &quot;minOpacity&quot;: 0.5, &quot;radius&quot;: 25}\n",
              "            ).addTo(map_96e5aaa763b1c76727ce04c7b67320e8);\n",
              "        \n",
              "&lt;/script&gt;\n",
              "&lt;/html&gt;\" style=\"position:absolute;width:100%;height:100%;left:0;top:0;border:none !important;\" allowfullscreen webkitallowfullscreen mozallowfullscreen></iframe></div></div>"
            ]
          },
          "metadata": {},
          "execution_count": 14
        }
      ],
      "source": [
        "# 하차용 지도 생성\n",
        "seoul_out = folium.Map(location=[37.55, 126.98], zoom_start = 12)\n",
        "\n",
        "# 히트맵 지도에 추가하기\n",
        "HeatMap(data = joined_data[['geo.latitude', 'geo.longitude', 'people_out']]).add_to(seoul_out)\n",
        "\n",
        "# 지도 확인하기\n",
        "seoul_out"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 15,
      "id": "de0783bd",
      "metadata": {
        "scrolled": true,
        "id": "de0783bd",
        "outputId": "25422cdf-5340-4164-db51-63243dd2c3ec",
        "colab": {
          "base_uri": "https://localhost:8080/"
        }
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 24871 entries, 0 to 24870\n",
            "Data columns (total 4 columns):\n",
            " #   Column        Non-Null Count  Dtype \n",
            "---  ------        --------------  ----- \n",
            " 0   timestamp     24871 non-null  object\n",
            " 1   station_code  24871 non-null  int64 \n",
            " 2   people_in     24871 non-null  int64 \n",
            " 3   people_out    24871 non-null  int64 \n",
            "dtypes: int64(3), object(1)\n",
            "memory usage: 777.3+ KB\n"
          ]
        }
      ],
      "source": [
        "# 데이터 상세 정보 확인하기\n",
        "data.info()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 16,
      "id": "a8223381",
      "metadata": {
        "scrolled": true,
        "id": "a8223381",
        "outputId": "78b97eff-1739-4c3a-da38-3f0a837b307a",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 423
        }
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                           timestamp  station_code  people_in  people_out\n",
              "0      2021-01-01T05:00:00.000+09:00           150         86          85\n",
              "1      2021-01-01T06:00:00.000+09:00           150        111         355\n",
              "2      2021-01-01T07:00:00.000+09:00           150        157         438\n",
              "3      2021-01-01T08:00:00.000+09:00           150        306         592\n",
              "19     2021-01-01T05:00:00.000+09:00           151         43          40\n",
              "...                              ...           ...        ...         ...\n",
              "24836  2021-01-05T08:00:00.000+09:00          2637        428         966\n",
              "24852  2021-01-05T05:00:00.000+09:00          2638         71           4\n",
              "24853  2021-01-05T06:00:00.000+09:00          2638        182          91\n",
              "24854  2021-01-05T07:00:00.000+09:00          2638        485         110\n",
              "24855  2021-01-05T08:00:00.000+09:00          2638        596         194\n",
              "\n",
              "[5236 rows x 4 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-4a36cf81-f273-46da-bd18-9b3319c84ee8\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>timestamp</th>\n",
              "      <th>station_code</th>\n",
              "      <th>people_in</th>\n",
              "      <th>people_out</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2021-01-01T05:00:00.000+09:00</td>\n",
              "      <td>150</td>\n",
              "      <td>86</td>\n",
              "      <td>85</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2021-01-01T06:00:00.000+09:00</td>\n",
              "      <td>150</td>\n",
              "      <td>111</td>\n",
              "      <td>355</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2021-01-01T07:00:00.000+09:00</td>\n",
              "      <td>150</td>\n",
              "      <td>157</td>\n",
              "      <td>438</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2021-01-01T08:00:00.000+09:00</td>\n",
              "      <td>150</td>\n",
              "      <td>306</td>\n",
              "      <td>592</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>2021-01-01T05:00:00.000+09:00</td>\n",
              "      <td>151</td>\n",
              "      <td>43</td>\n",
              "      <td>40</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>24836</th>\n",
              "      <td>2021-01-05T08:00:00.000+09:00</td>\n",
              "      <td>2637</td>\n",
              "      <td>428</td>\n",
              "      <td>966</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24852</th>\n",
              "      <td>2021-01-05T05:00:00.000+09:00</td>\n",
              "      <td>2638</td>\n",
              "      <td>71</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24853</th>\n",
              "      <td>2021-01-05T06:00:00.000+09:00</td>\n",
              "      <td>2638</td>\n",
              "      <td>182</td>\n",
              "      <td>91</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24854</th>\n",
              "      <td>2021-01-05T07:00:00.000+09:00</td>\n",
              "      <td>2638</td>\n",
              "      <td>485</td>\n",
              "      <td>110</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24855</th>\n",
              "      <td>2021-01-05T08:00:00.000+09:00</td>\n",
              "      <td>2638</td>\n",
              "      <td>596</td>\n",
              "      <td>194</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5236 rows × 4 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-4a36cf81-f273-46da-bd18-9b3319c84ee8')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-4a36cf81-f273-46da-bd18-9b3319c84ee8 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-4a36cf81-f273-46da-bd18-9b3319c84ee8');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 16
        }
      ],
      "source": [
        "# 출근용 데이터 추출\n",
        "morning_data = data[pd.to_datetime(data.timestamp).dt.hour < 9]\n",
        "morning_data"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 17,
      "id": "9d54289a",
      "metadata": {
        "id": "9d54289a",
        "outputId": "76c5da1b-e15a-408e-fb92-162a6e51dbb3",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 423
        }
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                           timestamp  station_code  people_in  people_out\n",
              "13     2021-01-01T18:00:00.000+09:00           150        658         437\n",
              "14     2021-01-01T19:00:00.000+09:00           150        579         425\n",
              "15     2021-01-01T20:00:00.000+09:00           150        479         354\n",
              "16     2021-01-01T21:00:00.000+09:00           150        510         307\n",
              "17     2021-01-01T22:00:00.000+09:00           150        445         134\n",
              "...                              ...           ...        ...         ...\n",
              "24866  2021-01-05T19:00:00.000+09:00          2638         57         320\n",
              "24867  2021-01-05T20:00:00.000+09:00          2638         95         175\n",
              "24868  2021-01-05T21:00:00.000+09:00          2638         47         171\n",
              "24869  2021-01-05T22:00:00.000+09:00          2638         20          78\n",
              "24870  2021-01-05T23:00:00.000+09:00          2638          7          31\n",
              "\n",
              "[7854 rows x 4 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-47b8857c-def2-4087-b2e8-6866ce0cde35\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>timestamp</th>\n",
              "      <th>station_code</th>\n",
              "      <th>people_in</th>\n",
              "      <th>people_out</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>2021-01-01T18:00:00.000+09:00</td>\n",
              "      <td>150</td>\n",
              "      <td>658</td>\n",
              "      <td>437</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>2021-01-01T19:00:00.000+09:00</td>\n",
              "      <td>150</td>\n",
              "      <td>579</td>\n",
              "      <td>425</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>2021-01-01T20:00:00.000+09:00</td>\n",
              "      <td>150</td>\n",
              "      <td>479</td>\n",
              "      <td>354</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>2021-01-01T21:00:00.000+09:00</td>\n",
              "      <td>150</td>\n",
              "      <td>510</td>\n",
              "      <td>307</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>2021-01-01T22:00:00.000+09:00</td>\n",
              "      <td>150</td>\n",
              "      <td>445</td>\n",
              "      <td>134</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>24866</th>\n",
              "      <td>2021-01-05T19:00:00.000+09:00</td>\n",
              "      <td>2638</td>\n",
              "      <td>57</td>\n",
              "      <td>320</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24867</th>\n",
              "      <td>2021-01-05T20:00:00.000+09:00</td>\n",
              "      <td>2638</td>\n",
              "      <td>95</td>\n",
              "      <td>175</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24868</th>\n",
              "      <td>2021-01-05T21:00:00.000+09:00</td>\n",
              "      <td>2638</td>\n",
              "      <td>47</td>\n",
              "      <td>171</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24869</th>\n",
              "      <td>2021-01-05T22:00:00.000+09:00</td>\n",
              "      <td>2638</td>\n",
              "      <td>20</td>\n",
              "      <td>78</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24870</th>\n",
              "      <td>2021-01-05T23:00:00.000+09:00</td>\n",
              "      <td>2638</td>\n",
              "      <td>7</td>\n",
              "      <td>31</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>7854 rows × 4 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-47b8857c-def2-4087-b2e8-6866ce0cde35')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-47b8857c-def2-4087-b2e8-6866ce0cde35 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-47b8857c-def2-4087-b2e8-6866ce0cde35');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 17
        }
      ],
      "source": [
        "# 퇴근용 데이터 추출\n",
        "evening_data = data[pd.to_datetime(data.timestamp).dt.hour > 17]\n",
        "evening_data"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 18,
      "id": "59d32ae8",
      "metadata": {
        "scrolled": true,
        "id": "59d32ae8",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "ebe91a7b-6be1-415c-d0dd-cf6d111adf89"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "<ipython-input-18-bd458904a7a7>:2: FutureWarning: The default value of numeric_only in DataFrameGroupBy.sum is deprecated. In a future version, numeric_only will default to False. Either specify numeric_only or select only columns which should be valid for the function.\n",
            "  morning_station_sum = morning_data.groupby(\"station_code\").sum()\n",
            "<ipython-input-18-bd458904a7a7>:3: FutureWarning: The default value of numeric_only in DataFrameGroupBy.sum is deprecated. In a future version, numeric_only will default to False. Either specify numeric_only or select only columns which should be valid for the function.\n",
            "  evening_station_sum = evening_data.groupby(\"station_code\").sum()\n"
          ]
        }
      ],
      "source": [
        "# 역 기준으로 그룹화하여 데이터 더하기\n",
        "morning_station_sum = morning_data.groupby(\"station_code\").sum()\n",
        "evening_station_sum = evening_data.groupby(\"station_code\").sum()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 19,
      "id": "bbd835cd",
      "metadata": {
        "id": "bbd835cd"
      },
      "outputs": [],
      "source": [
        "# 역 정보 합치기\n",
        "morning_joined_data = morning_station_sum.join(station_info)\n",
        "evening_joined_data = evening_station_sum.join(station_info)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 21,
      "id": "11e2e776",
      "metadata": {
        "id": "11e2e776",
        "outputId": "d39f8e47-aac6-44b8-e5a4-785f19860169",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 969
        }
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<folium.folium.Map at 0x7fbf19cf2b90>"
            ],
            "text/html": [
              "<div style=\"width:100%;\"><div style=\"position:relative;width:100%;height:0;padding-bottom:60%;\"><span style=\"color:#565656\">Make this Notebook Trusted to load map: File -> Trust Notebook</span><iframe srcdoc=\"&lt;!DOCTYPE html&gt;\n",
              "&lt;html&gt;\n",
              "&lt;head&gt;\n",
              "    \n",
              "    &lt;meta http-equiv=&quot;content-type&quot; content=&quot;text/html; charset=UTF-8&quot; /&gt;\n",
              "    \n",
              "        &lt;script&gt;\n",
              "            L_NO_TOUCH = false;\n",
              "            L_DISABLE_3D = false;\n",
              "        &lt;/script&gt;\n",
              "    \n",
              "    &lt;style&gt;html, body {width: 100%;height: 100%;margin: 0;padding: 0;}&lt;/style&gt;\n",
              "    &lt;style&gt;#map {position:absolute;top:0;bottom:0;right:0;left:0;}&lt;/style&gt;\n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.9.3/dist/leaflet.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://code.jquery.com/jquery-1.12.4.min.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/js/bootstrap.bundle.min.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.9.3/dist/leaflet.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/css/bootstrap.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://netdna.bootstrapcdn.com/bootstrap/3.0.0/css/bootstrap.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/@fortawesome/fontawesome-free@6.2.0/css/all.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/gh/python-visualization/folium/folium/templates/leaflet.awesome.rotate.min.css&quot;/&gt;\n",
              "    \n",
              "            &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width,\n",
              "                initial-scale=1.0, maximum-scale=1.0, user-scalable=no&quot; /&gt;\n",
              "            &lt;style&gt;\n",
              "                #map_4666b8b25de93ce530703a991168b5f7 {\n",
              "                    position: relative;\n",
              "                    width: 100.0%;\n",
              "                    height: 100.0%;\n",
              "                    left: 0.0%;\n",
              "                    top: 0.0%;\n",
              "                }\n",
              "                .leaflet-container { font-size: 1rem; }\n",
              "            &lt;/style&gt;\n",
              "        \n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/gh/python-visualization/folium@main/folium/templates/leaflet_heat.min.js&quot;&gt;&lt;/script&gt;\n",
              "&lt;/head&gt;\n",
              "&lt;body&gt;\n",
              "    \n",
              "    \n",
              "            &lt;div class=&quot;folium-map&quot; id=&quot;map_4666b8b25de93ce530703a991168b5f7&quot; &gt;&lt;/div&gt;\n",
              "        \n",
              "&lt;/body&gt;\n",
              "&lt;script&gt;\n",
              "    \n",
              "    \n",
              "            var map_4666b8b25de93ce530703a991168b5f7 = L.map(\n",
              "                &quot;map_4666b8b25de93ce530703a991168b5f7&quot;,\n",
              "                {\n",
              "                    center: [37.55, 126.98],\n",
              "                    crs: L.CRS.EPSG3857,\n",
              "                    zoom: 12,\n",
              "                    zoomControl: true,\n",
              "                    preferCanvas: false,\n",
              "                }\n",
              "            );\n",
              "\n",
              "            \n",
              "\n",
              "        \n",
              "    \n",
              "            var tile_layer_86d1681592c42a5eb99abe433e667938 = L.tileLayer(\n",
              "                &quot;https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png&quot;,\n",
              "                {&quot;attribution&quot;: &quot;Data by \\u0026copy; \\u003ca target=\\&quot;_blank\\&quot; href=\\&quot;http://openstreetmap.org\\&quot;\\u003eOpenStreetMap\\u003c/a\\u003e, under \\u003ca target=\\&quot;_blank\\&quot; href=\\&quot;http://www.openstreetmap.org/copyright\\&quot;\\u003eODbL\\u003c/a\\u003e.&quot;, &quot;detectRetina&quot;: false, &quot;maxNativeZoom&quot;: 18, &quot;maxZoom&quot;: 18, &quot;minZoom&quot;: 0, &quot;noWrap&quot;: false, &quot;opacity&quot;: 1, &quot;subdomains&quot;: &quot;abc&quot;, &quot;tms&quot;: false}\n",
              "            ).addTo(map_4666b8b25de93ce530703a991168b5f7);\n",
              "        \n",
              "    \n",
              "            var heat_map_dd2a7679462e5ed692ad77322ba7f16f = L.heatLayer(\n",
              "                [[37.554648, 126.972559, 10234.0], [37.564718, 126.977108, 1895.0], [37.570161, 126.982923, 2008.0], [37.571607, 126.991806, 1850.0], [37.570926, 127.001849, 1528.0], [37.57142, 127.009745, 4782.0], [37.575297, 127.025087, 5350.0], [37.578103, 127.034893, 5704.0], [37.580178, 127.046835, 9433.0], [37.572627, 127.016429, 2000.0], [37.564718, 126.977108, 1524.0], [37.566014, 126.982618, 2416.0], [37.566295, 126.99191, 1552.0], [37.566941, 126.998079, 1024.0], [37.565138, 127.007896, 2959.0], [37.565972, 127.01782, 7334.0], [37.564354, 127.029354, 9969.0], [37.561533, 127.037732, 7512.0], [37.555273, 127.043655, 1525.0], [37.547184, 127.047367, 5049.0], [37.544581, 127.055961, 6400.0], [37.540693, 127.07023, 15703.0], [37.537077, 127.085916, 19017.0], [37.535095, 127.094681, 18494.0], [37.520733, 127.10379, 7948.0], [37.51395, 127.102234, 27907.0], [37.511687, 127.086162, 11562.0], [37.510997, 127.073642, 3809.0], [37.508844, 127.06316, 4397.0], [37.504503, 127.049008, 5884.0], [37.500622, 127.036456, 4811.0], [37.497175, 127.027926, 11119.0], [37.493415, 127.01408, 6317.0], [37.491897, 127.007917, 3929.0], [37.481426, 126.997596, 5520.0], [37.47653, 126.981685, 18522.0], [37.47693, 126.963693, 20835.0], [37.481247, 126.952739, 33568.0], [37.482362, 126.941892, 21883.0], [37.484201, 126.929715, 56847.0], [37.487462, 126.913149, 25485.0], [37.485266, 126.901401, 37565.0], [37.49297, 126.895801, 20881.0], [37.508725, 126.891295, 30990.0], [37.517933, 126.89476, 8831.0], [37.52497, 126.895951, 9251.0], [37.53438, 126.902281, 10519.0], [37.549463, 126.913739, 10711.0], [37.557192, 126.925381, 14269.0], [37.555134, 126.936893, 8172.0], [37.556733, 126.946013, 4631.0], [37.557345, 126.956141, 6783.0], [37.559973, 126.963672, 4160.0], [37.561904, 127.050899, 2360.0], [37.57004, 127.046481, 1634.0], [37.575297, 127.025087, 1120.0], [37.514287, 126.882768, 736.0], [37.512398, 126.865819, 6580.0], [37.520074, 126.852912, 9619.0], [37.574028, 127.038091, 1391.0], [37.648048, 126.913951, 3355.0], [37.636763, 126.918821, 17353.0], [37.619001, 126.921008, 33223.0], [37.610469, 126.929887, 12174.0], [37.600927, 126.935756, 14789.0], [37.589066, 126.943736, 14156.0], [37.582299, 126.950291, 3357.0], [37.574571, 126.957748, 4039.0], [37.575762, 126.97353, 3580.0], [37.576477, 126.985443, 1870.0], [37.571607, 126.991806, 621.0], [37.566295, 126.99191, 625.0], [37.561243, 126.99428, 0.0], [37.559052, 127.005602, 1603.0], [37.55434, 127.010655, 6854.0], [37.548034, 127.015872, 6723.0], [37.540685, 127.017965, 5617.0], [37.527072, 127.028461, 4362.0], [37.516334, 127.020114, 3369.0], [37.512759, 127.01122, 2540.0], [37.50481, 127.004943, 6951.0], [37.493415, 127.01408, 2032.0], [37.485013, 127.016189, 6579.0], [37.484147, 127.034631, 8488.0], [37.486947, 127.046769, 3529.0], [37.490858, 127.055381, 2029.0], [37.494612, 127.063642, 5224.0], [37.496663, 127.070594, 850.0], [37.493514, 127.079532, 5948.0], [37.483681, 127.08439, 4457.0], [37.487371, 127.10188, 7987.0], [37.492522, 127.118234, 4155.0], [37.495918, 127.12454, 4906.0], [37.502162, 127.128111, 5634.0], [37.670272, 127.079066, 11610.0], [37.660878, 127.073572, 19417.0], [37.655128, 127.061368, 13162.0], [37.653166, 127.047731, 20293.0], [37.648627, 127.034709, 30185.0], [37.638052, 127.025732, 27953.0], [37.62667, 127.025983, 12245.0], [37.613292, 127.030053, 22421.0], [37.603407, 127.025053, 17654.0], [37.592624, 127.016403, 10625.0], [37.588458, 127.006221, 7629.0], [37.582336, 127.001844, 4567.0], [37.57142, 127.009745, 1844.0], [37.565138, 127.007896, 2390.0], [37.561243, 126.99428, 2504.0], [37.560989, 126.986325, 1092.0], [37.558514, 126.978246, 1684.0], [37.554648, 126.972559, 3333.0], [37.54456, 126.972106, 4523.0], [37.534777, 126.97311, 1331.0], [37.52917, 126.967894, 2791.0], [37.522272, 126.974345, 2937.0], [37.502971, 126.979306, 1268.0], [37.486263, 126.981989, 10846.0], [37.47653, 126.981685, 15798.0], [37.463873, 126.989134, 557.0], [37.577446, 126.812741, 6191.0], [37.572399, 126.806171, 4430.0], [37.562434, 126.801058, 1327.0], [37.561184, 126.811973, 4850.0], [37.560183, 126.825448, 4422.0], [37.558598, 126.837668, 5731.0], [37.548768, 126.836318, 11545.0], [37.541513, 126.840461, 28431.0], [37.531768, 126.846683, 30399.0], [37.524997, 126.856191, 16127.0], [37.526065, 126.864931, 13679.0], [37.524496, 126.875181, 10362.0], [37.525648, 126.885778, 4899.0], [37.52497, 126.895951, 1975.0], [37.522669, 126.905139, 4848.0], [37.517122, 126.917169, 3249.0], [37.521624, 126.924191, 2670.0], [37.527098, 126.932901, 1597.0], [37.539574, 126.945932, 5822.0], [37.544018, 126.951592, 4818.0], [37.553736, 126.95682, 4108.0], [37.559973, 126.963672, 1696.0], [37.565773, 126.966641, 4306.0], [37.571026, 126.976669, 2538.0], [37.571607, 126.991806, 877.0], [37.566941, 126.998079, 366.0], [37.565138, 127.007896, 305.0], [37.560245, 127.013828, 1894.0], [37.554548, 127.020331, 5003.0], [37.557322, 127.029476, 7750.0], [37.561533, 127.037732, 1686.0], [37.5661, 127.042973, 3902.0], [37.566747, 127.052704, 14004.0], [37.56144, 127.064623, 12706.0], [37.557121, 127.079542, 8826.0], [37.551691, 127.089761, 11550.0], [37.545303, 127.10357, 9189.0], [37.538397, 127.123572, 7072.0], [37.535804, 127.132481, 14444.0], [37.537801, 127.140004, 5667.0], [37.545477, 127.142853, 8583.0], [37.55137, 127.143999, 7405.0], [37.555004, 127.154151, 6282.0], [37.556712, 127.166417, 16715.0], [37.527788, 127.136248, 5640.0], [37.516078, 127.130848, 2539.0], [37.508857, 127.126133, 3972.0], [37.502162, 127.128111, 1866.0], [37.498079, 127.13482, 4894.0], [37.493105, 127.14415, 6756.0], [37.49499, 127.152781, 5857.0], [37.563118, 127.192932, 13044.0], [37.552059, 127.20388, 4091.0], [37.598605, 126.915577, 17372.0], [37.606021, 126.922744, 3489.0], [37.610469, 126.929887, 2382.0], [37.618456, 126.933031, 3041.0], [37.619001, 126.921008, 0.0], [37.611377, 126.91727, 6857.0], [37.591148, 126.913629, 12950.0], [37.583876, 126.909645, 9857.0], [37.576646, 126.900984, 9292.0], [37.569532, 126.899298, 1977.0], [37.563515, 126.903343, 9585.0], [37.556094, 126.910052, 6855.0], [37.549463, 126.913739, 3637.0], [37.547716, 126.922852, 2151.0], [37.547456, 126.931993, 4221.0], [37.547771, 126.942069, 3516.0], [37.544018, 126.951592, 5057.0], [37.539261, 126.961351, 4060.0], [37.534777, 126.97311, 1776.0], [37.534675, 126.986695, 1334.0], [37.534488, 126.994302, 2774.0], [37.539631, 127.001725, 1069.0], [37.548013, 127.007055, 1335.0], [37.55434, 127.010655, 1315.0], [37.560245, 127.013828, 1853.0], [37.565972, 127.01782, 2614.0], [37.572627, 127.016429, 2559.0], [37.579661, 127.015241, 3268.0], [37.585286, 127.019381, 3063.0], [37.586272, 127.029005, 1434.0], [37.590508, 127.036296, 2830.0], [37.601948, 127.041518, 5086.0], [37.606377, 127.048491, 3484.0], [37.610537, 127.056431, 4568.0], [37.614805, 127.065851, 7111.0], [37.617983, 127.07512, 2699.0], [37.620064, 127.084689, 6796.0], [37.617283, 127.091401, 5619.0], [37.700109, 127.053196, 1668.0], [37.689313, 127.046222, 5898.0], [37.67785, 127.055315, 7108.0], [37.66494, 127.057675, 8147.0], [37.655128, 127.061368, 5374.0], [37.644583, 127.064303, 8597.0], [37.636352, 127.06799, 9051.0], [37.625742, 127.072896, 5427.0], [37.617983, 127.07512, 3494.0], [37.610637, 127.077725, 5500.0], [37.602545, 127.079264, 6129.0], [37.596362, 127.085032, 8296.0], [37.588579, 127.087503, 9493.0], [37.580894, 127.088478, 8958.0], [37.573647, 127.086727, 3797.0], [37.565923, 127.08432, 5262.0], [37.557121, 127.079542, 6389.0], [37.548014, 127.074658, 3263.0], [37.540693, 127.07023, 2345.0], [37.53154, 127.066704, 3484.0], [37.519365, 127.05335, 2199.0], [37.517186, 127.04128, 1322.0], [37.514229, 127.031656, 1816.0], [37.511093, 127.021415, 2056.0], [37.508178, 127.011727, 1162.0], [37.50481, 127.004943, 2251.0], [37.487618, 126.993513, 2976.0], [37.486263, 126.981989, 4334.0], [37.484596, 126.971251, 6008.0], [37.496029, 126.953822, 5342.0], [37.502834, 126.94791, 4511.0], [37.504898, 126.93915, 5066.0], [37.499701, 126.928276, 8419.0], [37.499872, 126.920428, 3784.0], [37.50008, 126.90993, 6707.0], [37.49297, 126.895801, 3462.0], [37.486056, 126.887249, 6344.0], [37.481072, 126.882343, 3842.0], [37.47605, 126.867911, 10695.0], [37.479252, 126.854876, 12605.0], [37.486637, 126.838713, 6674.0], [37.492258, 126.823388, 6919.0], [37.506207, 126.810939, 4240.0], [37.50538, 126.797337, 2421.0], [37.503663, 126.787036, 3473.0], [37.503048, 126.77596, 5736.0], [37.504631, 126.763538, 5448.0], [37.505781, 126.753083, 4771.0], [37.506411, 126.742153, 2965.0], [37.506997, 126.73128, 4961.0], [37.508336, 126.720548, 7380.0], [37.55021, 127.127562, 11591.0], [37.538397, 127.123572, 7190.0], [37.530341, 127.120508, 4625.0], [37.517409, 127.112359, 1601.0], [37.51395, 127.102234, 1709.0], [37.505431, 127.106979, 2500.0], [37.499703, 127.112183, 3367.0], [37.492522, 127.118234, 1611.0], [37.485855, 127.1225, 3083.0], [37.478703, 127.126191, 6304.0], [37.470047, 127.126662, 4209.0], [37.457122, 127.149908, 4048.0], [37.451535, 127.159816, 7787.0], [37.44521, 127.156866, 5744.0], [37.440918, 127.147564, 2309.0], [37.437428, 127.140722, 2855.0], [37.43213, 127.129087, 1534.0]],\n",
              "                {&quot;blur&quot;: 15, &quot;maxZoom&quot;: 18, &quot;minOpacity&quot;: 0.5, &quot;radius&quot;: 25}\n",
              "            ).addTo(map_4666b8b25de93ce530703a991168b5f7);\n",
              "        \n",
              "&lt;/script&gt;\n",
              "&lt;/html&gt;\" style=\"position:absolute;width:100%;height:100%;left:0;top:0;border:none !important;\" allowfullscreen webkitallowfullscreen mozallowfullscreen></iframe></div></div>"
            ]
          },
          "metadata": {},
          "execution_count": 21
        }
      ],
      "source": [
        "# 출근 시간 승차 인원\n",
        "morning_seoul_in = folium.Map(location=[37.55, 126.98], zoom_start = 12)\n",
        "HeatMap(data = morning_joined_data[['geo.latitude', 'geo.longitude', 'people_in']]).add_to(morning_seoul_in)\n",
        "morning_seoul_in"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 22,
      "id": "de270406",
      "metadata": {
        "id": "de270406",
        "outputId": "149af629-a797-4bfb-8735-4a3cbf1556c3",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 969
        }
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<folium.folium.Map at 0x7fbf19583a60>"
            ],
            "text/html": [
              "<div style=\"width:100%;\"><div style=\"position:relative;width:100%;height:0;padding-bottom:60%;\"><span style=\"color:#565656\">Make this Notebook Trusted to load map: File -> Trust Notebook</span><iframe srcdoc=\"&lt;!DOCTYPE html&gt;\n",
              "&lt;html&gt;\n",
              "&lt;head&gt;\n",
              "    \n",
              "    &lt;meta http-equiv=&quot;content-type&quot; content=&quot;text/html; charset=UTF-8&quot; /&gt;\n",
              "    \n",
              "        &lt;script&gt;\n",
              "            L_NO_TOUCH = false;\n",
              "            L_DISABLE_3D = false;\n",
              "        &lt;/script&gt;\n",
              "    \n",
              "    &lt;style&gt;html, body {width: 100%;height: 100%;margin: 0;padding: 0;}&lt;/style&gt;\n",
              "    &lt;style&gt;#map {position:absolute;top:0;bottom:0;right:0;left:0;}&lt;/style&gt;\n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.9.3/dist/leaflet.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://code.jquery.com/jquery-1.12.4.min.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/js/bootstrap.bundle.min.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.9.3/dist/leaflet.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/css/bootstrap.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://netdna.bootstrapcdn.com/bootstrap/3.0.0/css/bootstrap.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/@fortawesome/fontawesome-free@6.2.0/css/all.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/gh/python-visualization/folium/folium/templates/leaflet.awesome.rotate.min.css&quot;/&gt;\n",
              "    \n",
              "            &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width,\n",
              "                initial-scale=1.0, maximum-scale=1.0, user-scalable=no&quot; /&gt;\n",
              "            &lt;style&gt;\n",
              "                #map_d6781ae8f3c636e259fc5075306c82db {\n",
              "                    position: relative;\n",
              "                    width: 100.0%;\n",
              "                    height: 100.0%;\n",
              "                    left: 0.0%;\n",
              "                    top: 0.0%;\n",
              "                }\n",
              "                .leaflet-container { font-size: 1rem; }\n",
              "            &lt;/style&gt;\n",
              "        \n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/gh/python-visualization/folium@main/folium/templates/leaflet_heat.min.js&quot;&gt;&lt;/script&gt;\n",
              "&lt;/head&gt;\n",
              "&lt;body&gt;\n",
              "    \n",
              "    \n",
              "            &lt;div class=&quot;folium-map&quot; id=&quot;map_d6781ae8f3c636e259fc5075306c82db&quot; &gt;&lt;/div&gt;\n",
              "        \n",
              "&lt;/body&gt;\n",
              "&lt;script&gt;\n",
              "    \n",
              "    \n",
              "            var map_d6781ae8f3c636e259fc5075306c82db = L.map(\n",
              "                &quot;map_d6781ae8f3c636e259fc5075306c82db&quot;,\n",
              "                {\n",
              "                    center: [37.55, 126.98],\n",
              "                    crs: L.CRS.EPSG3857,\n",
              "                    zoom: 12,\n",
              "                    zoomControl: true,\n",
              "                    preferCanvas: false,\n",
              "                }\n",
              "            );\n",
              "\n",
              "            \n",
              "\n",
              "        \n",
              "    \n",
              "            var tile_layer_deea050c66f3a6475f71bb7dab9d777c = L.tileLayer(\n",
              "                &quot;https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png&quot;,\n",
              "                {&quot;attribution&quot;: &quot;Data by \\u0026copy; \\u003ca target=\\&quot;_blank\\&quot; href=\\&quot;http://openstreetmap.org\\&quot;\\u003eOpenStreetMap\\u003c/a\\u003e, under \\u003ca target=\\&quot;_blank\\&quot; href=\\&quot;http://www.openstreetmap.org/copyright\\&quot;\\u003eODbL\\u003c/a\\u003e.&quot;, &quot;detectRetina&quot;: false, &quot;maxNativeZoom&quot;: 18, &quot;maxZoom&quot;: 18, &quot;minZoom&quot;: 0, &quot;noWrap&quot;: false, &quot;opacity&quot;: 1, &quot;subdomains&quot;: &quot;abc&quot;, &quot;tms&quot;: false}\n",
              "            ).addTo(map_d6781ae8f3c636e259fc5075306c82db);\n",
              "        \n",
              "    \n",
              "            var heat_map_aad81a2a0582fc2a175a5ebcb0bd0c83 = L.heatLayer(\n",
              "                [[37.554648, 126.972559, 26246.0], [37.564718, 126.977108, 21552.0], [37.570161, 126.982923, 28434.0], [37.571607, 126.991806, 9061.0], [37.570926, 127.001849, 14022.0], [37.57142, 127.009745, 3501.0], [37.575297, 127.025087, 8303.0], [37.578103, 127.034893, 6206.0], [37.580178, 127.046835, 6635.0], [37.572627, 127.016429, 3029.0], [37.564718, 126.977108, 24421.0], [37.566014, 126.982618, 38794.0], [37.566295, 126.99191, 20753.0], [37.566941, 126.998079, 10261.0], [37.565138, 127.007896, 6898.0], [37.565972, 127.01782, 5305.0], [37.564354, 127.029354, 4819.0], [37.561533, 127.037732, 4042.0], [37.555273, 127.043655, 3338.0], [37.547184, 127.047367, 16359.0], [37.544581, 127.055961, 33357.0], [37.540693, 127.07023, 10086.0], [37.537077, 127.085916, 6079.0], [37.535095, 127.094681, 7999.0], [37.520733, 127.10379, 6257.0], [37.51395, 127.102234, 24849.0], [37.511687, 127.086162, 5049.0], [37.510997, 127.073642, 2949.0], [37.508844, 127.06316, 41774.0], [37.504503, 127.049008, 37772.0], [37.500622, 127.036456, 43991.0], [37.497175, 127.027926, 45113.0], [37.493415, 127.01408, 21309.0], [37.491897, 127.007917, 15963.0], [37.481426, 126.997596, 10356.0], [37.47653, 126.981685, 13285.0], [37.47693, 126.963693, 6149.0], [37.481247, 126.952739, 9966.0], [37.482362, 126.941892, 4330.0], [37.484201, 126.929715, 11305.0], [37.487462, 126.913149, 5965.0], [37.485266, 126.901401, 32300.0], [37.49297, 126.895801, 8977.0], [37.508725, 126.891295, 16447.0], [37.517933, 126.89476, 15087.0], [37.52497, 126.895951, 16290.0], [37.53438, 126.902281, 10765.0], [37.549463, 126.913739, 12550.0], [37.557192, 126.925381, 12738.0], [37.555134, 126.936893, 10920.0], [37.556733, 126.946013, 4515.0], [37.557345, 126.956141, 3157.0], [37.559973, 126.963672, 7295.0], [37.561904, 127.050899, 645.0], [37.57004, 127.046481, 357.0], [37.575297, 127.025087, 2097.0], [37.514287, 126.882768, 893.0], [37.512398, 126.865819, 1742.0], [37.520074, 126.852912, 2360.0], [37.574028, 127.038091, 971.0], [37.648048, 126.913951, 818.0], [37.636763, 126.918821, 5789.0], [37.619001, 126.921008, 6242.0], [37.610469, 126.929887, 4717.0], [37.600927, 126.935756, 3176.0], [37.589066, 126.943736, 4399.0], [37.582299, 126.950291, 1136.0], [37.574571, 126.957748, 3463.0], [37.575762, 126.97353, 13387.0], [37.576477, 126.985443, 16743.0], [37.571607, 126.991806, 5816.0], [37.566295, 126.99191, 10198.0], [37.561243, 126.99428, 0.0], [37.559052, 127.005602, 6806.0], [37.55434, 127.010655, 4823.0], [37.548034, 127.015872, 1792.0], [37.540685, 127.017965, 2996.0], [37.527072, 127.028461, 19070.0], [37.516334, 127.020114, 16026.0], [37.512759, 127.01122, 1843.0], [37.50481, 127.004943, 13581.0], [37.493415, 127.01408, 6232.0], [37.485013, 127.016189, 20992.0], [37.484147, 127.034631, 33725.0], [37.486947, 127.046769, 9124.0], [37.490858, 127.055381, 3609.0], [37.494612, 127.063642, 5070.0], [37.496663, 127.070594, 1122.0], [37.493514, 127.079532, 3939.0], [37.483681, 127.08439, 5502.0], [37.487371, 127.10188, 8823.0], [37.492522, 127.118234, 4253.0], [37.495918, 127.12454, 3930.0], [37.502162, 127.128111, 1907.0], [37.670272, 127.079066, 2713.0], [37.660878, 127.073572, 3763.0], [37.655128, 127.061368, 4510.0], [37.653166, 127.047731, 7059.0], [37.648627, 127.034709, 5136.0], [37.638052, 127.025732, 8822.0], [37.62667, 127.025983, 4293.0], [37.613292, 127.030053, 5932.0], [37.603407, 127.025053, 4375.0], [37.592624, 127.016403, 5216.0], [37.588458, 127.006221, 4388.0], [37.582336, 127.001844, 16867.0], [37.57142, 127.009745, 11364.0], [37.565138, 127.007896, 9856.0], [37.561243, 126.99428, 22746.0], [37.560989, 126.986325, 13507.0], [37.558514, 126.978246, 16674.0], [37.554648, 126.972559, 9875.0], [37.54456, 126.972106, 6354.0], [37.534777, 126.97311, 3585.0], [37.52917, 126.967894, 11190.0], [37.522272, 126.974345, 4319.0], [37.502971, 126.979306, 1690.0], [37.486263, 126.981989, 6646.0], [37.47653, 126.981685, 6642.0], [37.463873, 126.989134, 707.0], [37.577446, 126.812741, 2029.0], [37.572399, 126.806171, 1991.0], [37.562434, 126.801058, 3964.0], [37.561184, 126.811973, 2385.0], [37.560183, 126.825448, 5277.0], [37.558598, 126.837668, 12355.0], [37.548768, 126.836318, 3211.0], [37.541513, 126.840461, 4989.0], [37.531768, 126.846683, 4296.0], [37.524997, 126.856191, 2331.0], [37.526065, 126.864931, 4496.0], [37.524496, 126.875181, 10417.0], [37.525648, 126.885778, 4835.0], [37.52497, 126.895951, 2963.0], [37.522669, 126.905139, 5182.0], [37.517122, 126.917169, 1950.0], [37.521624, 126.924191, 32678.0], [37.527098, 126.932901, 10232.0], [37.539574, 126.945932, 9730.0], [37.544018, 126.951592, 10731.0], [37.553736, 126.95682, 3571.0], [37.559973, 126.963672, 3945.0], [37.565773, 126.966641, 19915.0], [37.571026, 126.976669, 30126.0], [37.571607, 126.991806, 5109.0], [37.566941, 126.998079, 5629.0], [37.565138, 127.007896, 3822.0], [37.560245, 127.013828, 1752.0], [37.554548, 127.020331, 2096.0], [37.557322, 127.029476, 1709.0], [37.561533, 127.037732, 2457.0], [37.5661, 127.042973, 2371.0], [37.566747, 127.052704, 6199.0], [37.56144, 127.064623, 9488.0], [37.557121, 127.079542, 3491.0], [37.551691, 127.089761, 3906.0], [37.545303, 127.10357, 4821.0], [37.538397, 127.123572, 6352.0], [37.535804, 127.132481, 8551.0], [37.537801, 127.140004, 2783.0], [37.545477, 127.142853, 2132.0], [37.55137, 127.143999, 1719.0], [37.555004, 127.154151, 3210.0], [37.556712, 127.166417, 3771.0], [37.527788, 127.136248, 3501.0], [37.516078, 127.130848, 1638.0], [37.508857, 127.126133, 3575.0], [37.502162, 127.128111, 2599.0], [37.498079, 127.13482, 2418.0], [37.493105, 127.14415, 2791.0], [37.49499, 127.152781, 1901.0], [37.563118, 127.192932, 3137.0], [37.552059, 127.20388, 1739.0], [37.598605, 126.915577, 3218.0], [37.606021, 126.922744, 1300.0], [37.610469, 126.929887, 1246.0], [37.618456, 126.933031, 602.0], [37.619001, 126.921008, 0.0], [37.611377, 126.91727, 1342.0], [37.591148, 126.913629, 2397.0], [37.583876, 126.909645, 2004.0], [37.576646, 126.900984, 10140.0], [37.569532, 126.899298, 1660.0], [37.563515, 126.903343, 5539.0], [37.556094, 126.910052, 4271.0], [37.549463, 126.913739, 5848.0], [37.547716, 126.922852, 2822.0], [37.547456, 126.931993, 4951.0], [37.547771, 126.942069, 3990.0], [37.544018, 126.951592, 12719.0], [37.539261, 126.961351, 2740.0], [37.534777, 126.97311, 3539.0], [37.534675, 126.986695, 2701.0], [37.534488, 126.994302, 4016.0], [37.539631, 127.001725, 5735.0], [37.548013, 127.007055, 961.0], [37.55434, 127.010655, 2230.0], [37.560245, 127.013828, 2852.0], [37.565972, 127.01782, 4852.0], [37.572627, 127.016429, 3435.0], [37.579661, 127.015241, 1043.0], [37.585286, 127.019381, 1619.0], [37.586272, 127.029005, 2820.0], [37.590508, 127.036296, 1989.0], [37.601948, 127.041518, 1956.0], [37.606377, 127.048491, 943.0], [37.610537, 127.056431, 1328.0], [37.614805, 127.065851, 1679.0], [37.617983, 127.07512, 901.0], [37.620064, 127.084689, 1123.0], [37.617283, 127.091401, 1542.0], [37.700109, 127.053196, 274.0], [37.689313, 127.046222, 1670.0], [37.67785, 127.055315, 2151.0], [37.66494, 127.057675, 1637.0], [37.655128, 127.061368, 3799.0], [37.644583, 127.064303, 2221.0], [37.636352, 127.06799, 2667.0], [37.625742, 127.072896, 2045.0], [37.617983, 127.07512, 1812.0], [37.610637, 127.077725, 1478.0], [37.602545, 127.079264, 2234.0], [37.596362, 127.085032, 3278.0], [37.588579, 127.087503, 2358.0], [37.580894, 127.088478, 3304.0], [37.573647, 127.086727, 1092.0], [37.565923, 127.08432, 1842.0], [37.557121, 127.079542, 2497.0], [37.548014, 127.074658, 5185.0], [37.540693, 127.07023, 3416.0], [37.53154, 127.066704, 1498.0], [37.519365, 127.05335, 12334.0], [37.517186, 127.04128, 7912.0], [37.514229, 127.031656, 13484.0], [37.511093, 127.021415, 9937.0], [37.508178, 127.011727, 2290.0], [37.50481, 127.004943, 6855.0], [37.487618, 126.993513, 6398.0], [37.486263, 126.981989, 3971.0], [37.484596, 126.971251, 1654.0], [37.496029, 126.953822, 1684.0], [37.502834, 126.94791, 1854.0], [37.504898, 126.93915, 1960.0], [37.499701, 126.928276, 3072.0], [37.499872, 126.920428, 3141.0], [37.50008, 126.90993, 2570.0], [37.49297, 126.895801, 1755.0], [37.486056, 126.887249, 7351.0], [37.481072, 126.882343, 25602.0], [37.47605, 126.867911, 3975.0], [37.479252, 126.854876, 4124.0], [37.486637, 126.838713, 1550.0], [37.492258, 126.823388, 1465.0], [37.506207, 126.810939, 1180.0], [37.50538, 126.797337, 1220.0], [37.503663, 126.787036, 4610.0], [37.503048, 126.77596, 3671.0], [37.504631, 126.763538, 2614.0], [37.505781, 126.753083, 2574.0], [37.506411, 126.742153, 493.0], [37.506997, 126.73128, 1243.0], [37.508336, 126.720548, 1630.0], [37.55021, 127.127562, 2345.0], [37.538397, 127.123572, 3385.0], [37.530341, 127.120508, 3163.0], [37.517409, 127.112359, 2392.0], [37.51395, 127.102234, 5827.0], [37.505431, 127.106979, 2000.0], [37.499703, 127.112183, 1780.0], [37.492522, 127.118234, 3349.0], [37.485855, 127.1225, 10991.0], [37.478703, 127.126191, 5805.0], [37.470047, 127.126662, 2618.0], [37.457122, 127.149908, 972.0], [37.451535, 127.159816, 2459.0], [37.44521, 127.156866, 2386.0], [37.440918, 127.147564, 932.0], [37.437428, 127.140722, 915.0], [37.43213, 127.129087, 857.0]],\n",
              "                {&quot;blur&quot;: 15, &quot;maxZoom&quot;: 18, &quot;minOpacity&quot;: 0.5, &quot;radius&quot;: 25}\n",
              "            ).addTo(map_d6781ae8f3c636e259fc5075306c82db);\n",
              "        \n",
              "&lt;/script&gt;\n",
              "&lt;/html&gt;\" style=\"position:absolute;width:100%;height:100%;left:0;top:0;border:none !important;\" allowfullscreen webkitallowfullscreen mozallowfullscreen></iframe></div></div>"
            ]
          },
          "metadata": {},
          "execution_count": 22
        }
      ],
      "source": [
        "# 출근 시간 하차 인원\n",
        "morning_seoul_out = folium.Map(location=[37.55, 126.98], zoom_start = 12)\n",
        "HeatMap(data = morning_joined_data[['geo.latitude', 'geo.longitude', 'people_out']]).add_to(morning_seoul_out)\n",
        "morning_seoul_out"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 23,
      "id": "e9a2dbcd",
      "metadata": {
        "scrolled": false,
        "id": "e9a2dbcd",
        "outputId": "93e48ca1-2482-40b9-80db-602a059e1438",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 969
        }
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<folium.folium.Map at 0x7fbf195824d0>"
            ],
            "text/html": [
              "<div style=\"width:100%;\"><div style=\"position:relative;width:100%;height:0;padding-bottom:60%;\"><span style=\"color:#565656\">Make this Notebook Trusted to load map: File -> Trust Notebook</span><iframe srcdoc=\"&lt;!DOCTYPE html&gt;\n",
              "&lt;html&gt;\n",
              "&lt;head&gt;\n",
              "    \n",
              "    &lt;meta http-equiv=&quot;content-type&quot; content=&quot;text/html; charset=UTF-8&quot; /&gt;\n",
              "    \n",
              "        &lt;script&gt;\n",
              "            L_NO_TOUCH = false;\n",
              "            L_DISABLE_3D = false;\n",
              "        &lt;/script&gt;\n",
              "    \n",
              "    &lt;style&gt;html, body {width: 100%;height: 100%;margin: 0;padding: 0;}&lt;/style&gt;\n",
              "    &lt;style&gt;#map {position:absolute;top:0;bottom:0;right:0;left:0;}&lt;/style&gt;\n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.9.3/dist/leaflet.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://code.jquery.com/jquery-1.12.4.min.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/js/bootstrap.bundle.min.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.9.3/dist/leaflet.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/css/bootstrap.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://netdna.bootstrapcdn.com/bootstrap/3.0.0/css/bootstrap.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/@fortawesome/fontawesome-free@6.2.0/css/all.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/gh/python-visualization/folium/folium/templates/leaflet.awesome.rotate.min.css&quot;/&gt;\n",
              "    \n",
              "            &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width,\n",
              "                initial-scale=1.0, maximum-scale=1.0, user-scalable=no&quot; /&gt;\n",
              "            &lt;style&gt;\n",
              "                #map_b6e906447f37b35c05a320e28f448d2a {\n",
              "                    position: relative;\n",
              "                    width: 100.0%;\n",
              "                    height: 100.0%;\n",
              "                    left: 0.0%;\n",
              "                    top: 0.0%;\n",
              "                }\n",
              "                .leaflet-container { font-size: 1rem; }\n",
              "            &lt;/style&gt;\n",
              "        \n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/gh/python-visualization/folium@main/folium/templates/leaflet_heat.min.js&quot;&gt;&lt;/script&gt;\n",
              "&lt;/head&gt;\n",
              "&lt;body&gt;\n",
              "    \n",
              "    \n",
              "            &lt;div class=&quot;folium-map&quot; id=&quot;map_b6e906447f37b35c05a320e28f448d2a&quot; &gt;&lt;/div&gt;\n",
              "        \n",
              "&lt;/body&gt;\n",
              "&lt;script&gt;\n",
              "    \n",
              "    \n",
              "            var map_b6e906447f37b35c05a320e28f448d2a = L.map(\n",
              "                &quot;map_b6e906447f37b35c05a320e28f448d2a&quot;,\n",
              "                {\n",
              "                    center: [37.55, 126.98],\n",
              "                    crs: L.CRS.EPSG3857,\n",
              "                    zoom: 12,\n",
              "                    zoomControl: true,\n",
              "                    preferCanvas: false,\n",
              "                }\n",
              "            );\n",
              "\n",
              "            \n",
              "\n",
              "        \n",
              "    \n",
              "            var tile_layer_6d646b037e1f273547996cf5facda3bb = L.tileLayer(\n",
              "                &quot;https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png&quot;,\n",
              "                {&quot;attribution&quot;: &quot;Data by \\u0026copy; \\u003ca target=\\&quot;_blank\\&quot; href=\\&quot;http://openstreetmap.org\\&quot;\\u003eOpenStreetMap\\u003c/a\\u003e, under \\u003ca target=\\&quot;_blank\\&quot; href=\\&quot;http://www.openstreetmap.org/copyright\\&quot;\\u003eODbL\\u003c/a\\u003e.&quot;, &quot;detectRetina&quot;: false, &quot;maxNativeZoom&quot;: 18, &quot;maxZoom&quot;: 18, &quot;minZoom&quot;: 0, &quot;noWrap&quot;: false, &quot;opacity&quot;: 1, &quot;subdomains&quot;: &quot;abc&quot;, &quot;tms&quot;: false}\n",
              "            ).addTo(map_b6e906447f37b35c05a320e28f448d2a);\n",
              "        \n",
              "    \n",
              "            var heat_map_913a017c45264482b9277d142da98023 = L.heatLayer(\n",
              "                [[37.554648, 126.972559, 38446.0], [37.564718, 126.977108, 24483.0], [37.570161, 126.982923, 39264.0], [37.571607, 126.991806, 21402.0], [37.570926, 127.001849, 18063.0], [37.57142, 127.009745, 7056.0], [37.575297, 127.025087, 10559.0], [37.578103, 127.034893, 7635.0], [37.580178, 127.046835, 9574.0], [37.572627, 127.016429, 4512.0], [37.564718, 126.977108, 26370.0], [37.566014, 126.982618, 48775.0], [37.566295, 126.99191, 23631.0], [37.566941, 126.998079, 11989.0], [37.565138, 127.007896, 11368.0], [37.565972, 127.01782, 8897.0], [37.564354, 127.029354, 6824.0], [37.561533, 127.037732, 11619.0], [37.555273, 127.043655, 5630.0], [37.547184, 127.047367, 21901.0], [37.544581, 127.055961, 39218.0], [37.540693, 127.07023, 31088.0], [37.537077, 127.085916, 11087.0], [37.535095, 127.094681, 17405.0], [37.520733, 127.10379, 6090.0], [37.51395, 127.102234, 56011.0], [37.511687, 127.086162, 13347.0], [37.510997, 127.073642, 3463.0], [37.508844, 127.06316, 59560.0], [37.504503, 127.049008, 58933.0], [37.500622, 127.036456, 56013.0], [37.497175, 127.027926, 87298.0], [37.493415, 127.01408, 30269.0], [37.491897, 127.007917, 19164.0], [37.481426, 126.997596, 13315.0], [37.47653, 126.981685, 27183.0], [37.47693, 126.963693, 12497.0], [37.481247, 126.952739, 25185.0], [37.482362, 126.941892, 8987.0], [37.484201, 126.929715, 28498.0], [37.487462, 126.913149, 10546.0], [37.485266, 126.901401, 45167.0], [37.49297, 126.895801, 13165.0], [37.508725, 126.891295, 32764.0], [37.517933, 126.89476, 18292.0], [37.52497, 126.895951, 20007.0], [37.53438, 126.902281, 13100.0], [37.549463, 126.913739, 29496.0], [37.557192, 126.925381, 50920.0], [37.555134, 126.936893, 29217.0], [37.556733, 126.946013, 7746.0], [37.557345, 126.956141, 4485.0], [37.559973, 126.963672, 7731.0], [37.561904, 127.050899, 1117.0], [37.57004, 127.046481, 460.0], [37.575297, 127.025087, 2181.0], [37.514287, 126.882768, 851.0], [37.512398, 126.865819, 1880.0], [37.520074, 126.852912, 3190.0], [37.574028, 127.038091, 1181.0], [37.648048, 126.913951, 895.0], [37.636763, 126.918821, 8833.0], [37.619001, 126.921008, 15655.0], [37.610469, 126.929887, 8075.0], [37.600927, 126.935756, 4300.0], [37.589066, 126.943736, 6208.0], [37.582299, 126.950291, 1531.0], [37.574571, 126.957748, 3221.0], [37.575762, 126.97353, 16414.0], [37.576477, 126.985443, 17365.0], [37.571607, 126.991806, 10884.0], [37.566295, 126.99191, 12024.0], [37.561243, 126.99428, 0.0], [37.559052, 127.005602, 6555.0], [37.55434, 127.010655, 7972.0], [37.548034, 127.015872, 3161.0], [37.540685, 127.017965, 4609.0], [37.527072, 127.028461, 35696.0], [37.516334, 127.020114, 36112.0], [37.512759, 127.01122, 2310.0], [37.50481, 127.004943, 46023.0], [37.493415, 127.01408, 12397.0], [37.485013, 127.016189, 28251.0], [37.484147, 127.034631, 38138.0], [37.486947, 127.046769, 11823.0], [37.490858, 127.055381, 4218.0], [37.494612, 127.063642, 8035.0], [37.496663, 127.070594, 1169.0], [37.493514, 127.079532, 4982.0], [37.483681, 127.08439, 3516.0], [37.487371, 127.10188, 11357.0], [37.492522, 127.118234, 5983.0], [37.495918, 127.12454, 4026.0], [37.502162, 127.128111, 2409.0], [37.670272, 127.079066, 4450.0], [37.660878, 127.073572, 6902.0], [37.655128, 127.061368, 12575.0], [37.653166, 127.047731, 11902.0], [37.648627, 127.034709, 9413.0], [37.638052, 127.025732, 17830.0], [37.62667, 127.025983, 6549.0], [37.613292, 127.030053, 14045.0], [37.603407, 127.025053, 7160.0], [37.592624, 127.016403, 14277.0], [37.588458, 127.006221, 7002.0], [37.582336, 127.001844, 27797.0], [37.57142, 127.009745, 14172.0], [37.565138, 127.007896, 16903.0], [37.561243, 126.99428, 29994.0], [37.560989, 126.986325, 20566.0], [37.558514, 126.978246, 21677.0], [37.554648, 126.972559, 9829.0], [37.54456, 126.972106, 10133.0], [37.534777, 126.97311, 4309.0], [37.52917, 126.967894, 16593.0], [37.522272, 126.974345, 4192.0], [37.502971, 126.979306, 1534.0], [37.486263, 126.981989, 11767.0], [37.47653, 126.981685, 13464.0], [37.463873, 126.989134, 595.0], [37.577446, 126.812741, 2445.0], [37.572399, 126.806171, 2331.0], [37.562434, 126.801058, 9233.0], [37.561184, 126.811973, 3374.0], [37.560183, 126.825448, 7155.0], [37.558598, 126.837668, 16883.0], [37.548768, 126.836318, 4543.0], [37.541513, 126.840461, 9475.0], [37.531768, 126.846683, 9455.0], [37.524997, 126.856191, 3798.0], [37.526065, 126.864931, 7919.0], [37.524496, 126.875181, 19975.0], [37.525648, 126.885778, 5530.0], [37.52497, 126.895951, 3530.0], [37.522669, 126.905139, 7134.0], [37.517122, 126.917169, 2519.0], [37.521624, 126.924191, 29698.0], [37.527098, 126.932901, 8165.0], [37.539574, 126.945932, 11992.0], [37.544018, 126.951592, 13287.0], [37.553736, 126.95682, 4065.0], [37.559973, 126.963672, 4441.0], [37.565773, 126.966641, 17768.0], [37.571026, 126.976669, 36330.0], [37.571607, 126.991806, 11818.0], [37.566941, 126.998079, 6415.0], [37.565138, 127.007896, 3859.0], [37.560245, 127.013828, 3030.0], [37.554548, 127.020331, 2632.0], [37.557322, 127.029476, 2756.0], [37.561533, 127.037732, 4435.0], [37.5661, 127.042973, 2868.0], [37.566747, 127.052704, 8636.0], [37.56144, 127.064623, 11725.0], [37.557121, 127.079542, 6613.0], [37.551691, 127.089761, 6539.0], [37.545303, 127.10357, 6553.0], [37.538397, 127.123572, 16820.0], [37.535804, 127.132481, 10715.0], [37.537801, 127.140004, 4308.0], [37.545477, 127.142853, 3903.0], [37.55137, 127.143999, 2811.0], [37.555004, 127.154151, 3792.0], [37.556712, 127.166417, 4778.0], [37.527788, 127.136248, 4667.0], [37.516078, 127.130848, 1911.0], [37.508857, 127.126133, 5139.0], [37.502162, 127.128111, 2656.0], [37.498079, 127.13482, 2858.0], [37.493105, 127.14415, 3021.0], [37.49499, 127.152781, 1943.0], [37.563118, 127.192932, 6216.0], [37.552059, 127.20388, 3072.0], [37.598605, 126.915577, 6211.0], [37.606021, 126.922744, 1382.0], [37.610469, 126.929887, 2587.0], [37.618456, 126.933031, 745.0], [37.619001, 126.921008, 0.0], [37.611377, 126.91727, 2373.0], [37.591148, 126.913629, 4027.0], [37.583876, 126.909645, 3422.0], [37.576646, 126.900984, 9488.0], [37.569532, 126.899298, 2981.0], [37.563515, 126.903343, 8206.0], [37.556094, 126.910052, 10105.0], [37.549463, 126.913739, 13738.0], [37.547716, 126.922852, 8289.0], [37.547456, 126.931993, 6143.0], [37.547771, 126.942069, 5788.0], [37.544018, 126.951592, 17155.0], [37.539261, 126.961351, 4287.0], [37.534777, 126.97311, 4385.0], [37.534675, 126.986695, 4601.0], [37.534488, 126.994302, 9181.0], [37.539631, 127.001725, 8216.0], [37.548013, 127.007055, 1359.0], [37.55434, 127.010655, 2805.0], [37.560245, 127.013828, 3088.0], [37.565972, 127.01782, 6436.0], [37.572627, 127.016429, 5133.0], [37.579661, 127.015241, 1121.0], [37.585286, 127.019381, 2830.0], [37.586272, 127.029005, 5090.0], [37.590508, 127.036296, 2981.0], [37.601948, 127.041518, 3678.0], [37.606377, 127.048491, 1529.0], [37.610537, 127.056431, 2278.0], [37.614805, 127.065851, 3298.0], [37.617983, 127.07512, 1694.0], [37.620064, 127.084689, 1843.0], [37.617283, 127.091401, 1869.0], [37.700109, 127.053196, 484.0], [37.689313, 127.046222, 1703.0], [37.67785, 127.055315, 3782.0], [37.66494, 127.057675, 2498.0], [37.655128, 127.061368, 9671.0], [37.644583, 127.064303, 2943.0], [37.636352, 127.06799, 4769.0], [37.625742, 127.072896, 4022.0], [37.617983, 127.07512, 3278.0], [37.610637, 127.077725, 3025.0], [37.602545, 127.079264, 3275.0], [37.596362, 127.085032, 7197.0], [37.588579, 127.087503, 4146.0], [37.580894, 127.088478, 5341.0], [37.573647, 127.086727, 1443.0], [37.565923, 127.08432, 2747.0], [37.557121, 127.079542, 6212.0], [37.548014, 127.074658, 6239.0], [37.540693, 127.07023, 9258.0], [37.53154, 127.066704, 2624.0], [37.519365, 127.05335, 13920.0], [37.517186, 127.04128, 12192.0], [37.514229, 127.031656, 17505.0], [37.511093, 127.021415, 15383.0], [37.508178, 127.011727, 3744.0], [37.50481, 127.004943, 12950.0], [37.487618, 126.993513, 8342.0], [37.486263, 126.981989, 8215.0], [37.484596, 126.971251, 3078.0], [37.496029, 126.953822, 3568.0], [37.502834, 126.94791, 3312.0], [37.504898, 126.93915, 2990.0], [37.499701, 126.928276, 5331.0], [37.499872, 126.920428, 3901.0], [37.50008, 126.90993, 3628.0], [37.49297, 126.895801, 3854.0], [37.486056, 126.887249, 9263.0], [37.481072, 126.882343, 33800.0], [37.47605, 126.867911, 7589.0], [37.479252, 126.854876, 7324.0], [37.486637, 126.838713, 2220.0], [37.492258, 126.823388, 2037.0], [37.506207, 126.810939, 1875.0], [37.50538, 126.797337, 1305.0], [37.503663, 126.787036, 4572.0], [37.503048, 126.77596, 6679.0], [37.504631, 126.763538, 6131.0], [37.505781, 126.753083, 6238.0], [37.506411, 126.742153, 955.0], [37.506997, 126.73128, 2769.0], [37.508336, 126.720548, 2853.0], [37.55021, 127.127562, 4441.0], [37.538397, 127.123572, 6972.0], [37.530341, 127.120508, 3609.0], [37.517409, 127.112359, 3201.0], [37.51395, 127.102234, 12608.0], [37.505431, 127.106979, 3595.0], [37.499703, 127.112183, 2478.0], [37.492522, 127.118234, 4573.0], [37.485855, 127.1225, 12665.0], [37.478703, 127.126191, 10732.0], [37.470047, 127.126662, 3832.0], [37.457122, 127.149908, 1486.0], [37.451535, 127.159816, 3165.0], [37.44521, 127.156866, 3142.0], [37.440918, 127.147564, 1866.0], [37.437428, 127.140722, 1540.0], [37.43213, 127.129087, 2015.0]],\n",
              "                {&quot;blur&quot;: 15, &quot;maxZoom&quot;: 18, &quot;minOpacity&quot;: 0.5, &quot;radius&quot;: 25}\n",
              "            ).addTo(map_b6e906447f37b35c05a320e28f448d2a);\n",
              "        \n",
              "&lt;/script&gt;\n",
              "&lt;/html&gt;\" style=\"position:absolute;width:100%;height:100%;left:0;top:0;border:none !important;\" allowfullscreen webkitallowfullscreen mozallowfullscreen></iframe></div></div>"
            ]
          },
          "metadata": {},
          "execution_count": 23
        }
      ],
      "source": [
        "# 퇴근 시간 승차 인원\n",
        "evening_seoul_in = folium.Map(location=[37.55, 126.98], zoom_start = 12)\n",
        "HeatMap(data = evening_joined_data[['geo.latitude', 'geo.longitude', 'people_in']]).add_to(evening_seoul_in)\n",
        "evening_seoul_in"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 24,
      "id": "97aa522d",
      "metadata": {
        "scrolled": false,
        "id": "97aa522d",
        "outputId": "c826187c-cd03-44fb-8c94-8b4fc7c636df",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 969
        }
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<folium.folium.Map at 0x7fbf19581de0>"
            ],
            "text/html": [
              "<div style=\"width:100%;\"><div style=\"position:relative;width:100%;height:0;padding-bottom:60%;\"><span style=\"color:#565656\">Make this Notebook Trusted to load map: File -> Trust Notebook</span><iframe srcdoc=\"&lt;!DOCTYPE html&gt;\n",
              "&lt;html&gt;\n",
              "&lt;head&gt;\n",
              "    \n",
              "    &lt;meta http-equiv=&quot;content-type&quot; content=&quot;text/html; charset=UTF-8&quot; /&gt;\n",
              "    \n",
              "        &lt;script&gt;\n",
              "            L_NO_TOUCH = false;\n",
              "            L_DISABLE_3D = false;\n",
              "        &lt;/script&gt;\n",
              "    \n",
              "    &lt;style&gt;html, body {width: 100%;height: 100%;margin: 0;padding: 0;}&lt;/style&gt;\n",
              "    &lt;style&gt;#map {position:absolute;top:0;bottom:0;right:0;left:0;}&lt;/style&gt;\n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.9.3/dist/leaflet.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://code.jquery.com/jquery-1.12.4.min.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/js/bootstrap.bundle.min.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.9.3/dist/leaflet.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/css/bootstrap.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://netdna.bootstrapcdn.com/bootstrap/3.0.0/css/bootstrap.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/@fortawesome/fontawesome-free@6.2.0/css/all.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/gh/python-visualization/folium/folium/templates/leaflet.awesome.rotate.min.css&quot;/&gt;\n",
              "    \n",
              "            &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width,\n",
              "                initial-scale=1.0, maximum-scale=1.0, user-scalable=no&quot; /&gt;\n",
              "            &lt;style&gt;\n",
              "                #map_b0a3528faa494b2c94b834a261522a99 {\n",
              "                    position: relative;\n",
              "                    width: 100.0%;\n",
              "                    height: 100.0%;\n",
              "                    left: 0.0%;\n",
              "                    top: 0.0%;\n",
              "                }\n",
              "                .leaflet-container { font-size: 1rem; }\n",
              "            &lt;/style&gt;\n",
              "        \n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/gh/python-visualization/folium@main/folium/templates/leaflet_heat.min.js&quot;&gt;&lt;/script&gt;\n",
              "&lt;/head&gt;\n",
              "&lt;body&gt;\n",
              "    \n",
              "    \n",
              "            &lt;div class=&quot;folium-map&quot; id=&quot;map_b0a3528faa494b2c94b834a261522a99&quot; &gt;&lt;/div&gt;\n",
              "        \n",
              "&lt;/body&gt;\n",
              "&lt;script&gt;\n",
              "    \n",
              "    \n",
              "            var map_b0a3528faa494b2c94b834a261522a99 = L.map(\n",
              "                &quot;map_b0a3528faa494b2c94b834a261522a99&quot;,\n",
              "                {\n",
              "                    center: [37.55, 126.98],\n",
              "                    crs: L.CRS.EPSG3857,\n",
              "                    zoom: 12,\n",
              "                    zoomControl: true,\n",
              "                    preferCanvas: false,\n",
              "                }\n",
              "            );\n",
              "\n",
              "            \n",
              "\n",
              "        \n",
              "    \n",
              "            var tile_layer_0f7a0f47676da0e0a45b23c098fd8ff7 = L.tileLayer(\n",
              "                &quot;https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png&quot;,\n",
              "                {&quot;attribution&quot;: &quot;Data by \\u0026copy; \\u003ca target=\\&quot;_blank\\&quot; href=\\&quot;http://openstreetmap.org\\&quot;\\u003eOpenStreetMap\\u003c/a\\u003e, under \\u003ca target=\\&quot;_blank\\&quot; href=\\&quot;http://www.openstreetmap.org/copyright\\&quot;\\u003eODbL\\u003c/a\\u003e.&quot;, &quot;detectRetina&quot;: false, &quot;maxNativeZoom&quot;: 18, &quot;maxZoom&quot;: 18, &quot;minZoom&quot;: 0, &quot;noWrap&quot;: false, &quot;opacity&quot;: 1, &quot;subdomains&quot;: &quot;abc&quot;, &quot;tms&quot;: false}\n",
              "            ).addTo(map_b0a3528faa494b2c94b834a261522a99);\n",
              "        \n",
              "    \n",
              "            var heat_map_136279e656263c3cbebfdcfa12190546 = L.heatLayer(\n",
              "                [[37.554648, 126.972559, 15444.0], [37.564718, 126.977108, 2519.0], [37.570161, 126.982923, 4888.0], [37.571607, 126.991806, 4047.0], [37.570926, 127.001849, 3462.0], [37.57142, 127.009745, 8111.0], [37.575297, 127.025087, 8029.0], [37.578103, 127.034893, 7753.0], [37.580178, 127.046835, 13069.0], [37.572627, 127.016429, 3382.0], [37.564718, 126.977108, 2213.0], [37.566014, 126.982618, 6460.0], [37.566295, 126.99191, 2932.0], [37.566941, 126.998079, 1817.0], [37.565138, 127.007896, 7478.0], [37.565972, 127.01782, 12162.0], [37.564354, 127.029354, 13725.0], [37.561533, 127.037732, 11580.0], [37.555273, 127.043655, 2626.0], [37.547184, 127.047367, 8923.0], [37.544581, 127.055961, 11037.0], [37.540693, 127.07023, 33240.0], [37.537077, 127.085916, 27605.0], [37.535095, 127.094681, 28377.0], [37.520733, 127.10379, 10471.0], [37.51395, 127.102234, 50556.0], [37.511687, 127.086162, 18454.0], [37.510997, 127.073642, 6382.0], [37.508844, 127.06316, 9681.0], [37.504503, 127.049008, 11261.0], [37.500622, 127.036456, 11202.0], [37.497175, 127.027926, 26528.0], [37.493415, 127.01408, 12390.0], [37.491897, 127.007917, 5401.0], [37.481426, 126.997596, 10279.0], [37.47653, 126.981685, 36369.0], [37.47693, 126.963693, 34146.0], [37.481247, 126.952739, 54167.0], [37.482362, 126.941892, 29599.0], [37.484201, 126.929715, 87251.0], [37.487462, 126.913149, 35613.0], [37.485266, 126.901401, 52289.0], [37.49297, 126.895801, 25843.0], [37.508725, 126.891295, 45262.0], [37.517933, 126.89476, 12609.0], [37.52497, 126.895951, 13568.0], [37.53438, 126.902281, 18057.0], [37.549463, 126.913739, 20896.0], [37.557192, 126.925381, 32223.0], [37.555134, 126.936893, 20431.0], [37.556733, 126.946013, 8738.0], [37.557345, 126.956141, 10253.0], [37.559973, 126.963672, 6264.0], [37.561904, 127.050899, 3404.0], [37.57004, 127.046481, 2450.0], [37.575297, 127.025087, 1648.0], [37.514287, 126.882768, 1029.0], [37.512398, 126.865819, 8829.0], [37.520074, 126.852912, 12625.0], [37.574028, 127.038091, 2087.0], [37.648048, 126.913951, 4390.0], [37.636763, 126.918821, 20857.0], [37.619001, 126.921008, 44507.0], [37.610469, 126.929887, 17294.0], [37.600927, 126.935756, 18152.0], [37.589066, 126.943736, 18978.0], [37.582299, 126.950291, 4949.0], [37.574571, 126.957748, 5516.0], [37.575762, 126.97353, 6143.0], [37.576477, 126.985443, 3065.0], [37.571607, 126.991806, 1764.0], [37.566295, 126.99191, 1444.0], [37.561243, 126.99428, 0.0], [37.559052, 127.005602, 2762.0], [37.55434, 127.010655, 11064.0], [37.548034, 127.015872, 9023.0], [37.540685, 127.017965, 9546.0], [37.527072, 127.028461, 8939.0], [37.516334, 127.020114, 9370.0], [37.512759, 127.01122, 3731.0], [37.50481, 127.004943, 19471.0], [37.493415, 127.01408, 2612.0], [37.485013, 127.016189, 12588.0], [37.484147, 127.034631, 17323.0], [37.486947, 127.046769, 5439.0], [37.490858, 127.055381, 2905.0], [37.494612, 127.063642, 7227.0], [37.496663, 127.070594, 1214.0], [37.493514, 127.079532, 8092.0], [37.483681, 127.08439, 5765.0], [37.487371, 127.10188, 12599.0], [37.492522, 127.118234, 6160.0], [37.495918, 127.12454, 6152.0], [37.502162, 127.128111, 6223.0], [37.670272, 127.079066, 14345.0], [37.660878, 127.073572, 23320.0], [37.655128, 127.061368, 21856.0], [37.653166, 127.047731, 29981.0], [37.648627, 127.034709, 37740.0], [37.638052, 127.025732, 41243.0], [37.62667, 127.025983, 16187.0], [37.613292, 127.030053, 30926.0], [37.603407, 127.025053, 23282.0], [37.592624, 127.016403, 18513.0], [37.588458, 127.006221, 12037.0], [37.582336, 127.001844, 11718.0], [37.57142, 127.009745, 4582.0], [37.565138, 127.007896, 6131.0], [37.561243, 126.99428, 5820.0], [37.560989, 126.986325, 3641.0], [37.558514, 126.978246, 2857.0], [37.554648, 126.972559, 6550.0], [37.54456, 126.972106, 8098.0], [37.534777, 126.97311, 2595.0], [37.52917, 126.967894, 5874.0], [37.522272, 126.974345, 5229.0], [37.502971, 126.979306, 2183.0], [37.486263, 126.981989, 17507.0], [37.47653, 126.981685, 19944.0], [37.463873, 126.989134, 596.0], [37.577446, 126.812741, 7566.0], [37.572399, 126.806171, 5447.0], [37.562434, 126.801058, 2935.0], [37.561184, 126.811973, 6324.0], [37.560183, 126.825448, 5884.0], [37.558598, 126.837668, 9653.0], [37.548768, 126.836318, 15444.0], [37.541513, 126.840461, 35615.0], [37.531768, 126.846683, 40019.0], [37.524997, 126.856191, 15307.0], [37.526065, 126.864931, 20886.0], [37.524496, 126.875181, 16843.0], [37.525648, 126.885778, 6414.0], [37.52497, 126.895951, 2593.0], [37.522669, 126.905139, 6866.0], [37.517122, 126.917169, 5030.0], [37.521624, 126.924191, 4837.0], [37.527098, 126.932901, 2280.0], [37.539574, 126.945932, 8652.0], [37.544018, 126.951592, 7993.0], [37.553736, 126.95682, 5730.0], [37.559973, 126.963672, 2749.0], [37.565773, 126.966641, 5837.0], [37.571026, 126.976669, 5273.0], [37.571607, 126.991806, 2490.0], [37.566941, 126.998079, 652.0], [37.565138, 127.007896, 625.0], [37.560245, 127.013828, 3136.0], [37.554548, 127.020331, 7163.0], [37.557322, 127.029476, 8935.0], [37.561533, 127.037732, 3469.0], [37.5661, 127.042973, 4876.0], [37.566747, 127.052704, 16893.0], [37.56144, 127.064623, 16750.0], [37.557121, 127.079542, 13949.0], [37.551691, 127.089761, 15811.0], [37.545303, 127.10357, 11071.0], [37.538397, 127.123572, 14298.0], [37.535804, 127.132481, 18285.0], [37.537801, 127.140004, 7952.0], [37.545477, 127.142853, 11129.0], [37.55137, 127.143999, 10111.0], [37.555004, 127.154151, 8206.0], [37.556712, 127.166417, 19285.0], [37.527788, 127.136248, 7562.0], [37.516078, 127.130848, 2774.0], [37.508857, 127.126133, 5655.0], [37.502162, 127.128111, 2511.0], [37.498079, 127.13482, 6751.0], [37.493105, 127.14415, 7863.0], [37.49499, 127.152781, 6859.0], [37.563118, 127.192932, 19018.0], [37.552059, 127.20388, 5126.0], [37.598605, 126.915577, 23810.0], [37.606021, 126.922744, 5330.0], [37.610469, 126.929887, 4121.0], [37.618456, 126.933031, 4193.0], [37.619001, 126.921008, 0.0], [37.611377, 126.91727, 6593.0], [37.591148, 126.913629, 15944.0], [37.583876, 126.909645, 13616.0], [37.576646, 126.900984, 12439.0], [37.569532, 126.899298, 3038.0], [37.563515, 126.903343, 13152.0], [37.556094, 126.910052, 12274.0], [37.549463, 126.913739, 7748.0], [37.547716, 126.922852, 5305.0], [37.547456, 126.931993, 6113.0], [37.547771, 126.942069, 5915.0], [37.544018, 126.951592, 8872.0], [37.539261, 126.961351, 5346.0], [37.534777, 126.97311, 3019.0], [37.534675, 126.986695, 2859.0], [37.534488, 126.994302, 6538.0], [37.539631, 127.001725, 2419.0], [37.548013, 127.007055, 2170.0], [37.55434, 127.010655, 1994.0], [37.560245, 127.013828, 2457.0], [37.565972, 127.01782, 5806.0], [37.572627, 127.016429, 5620.0], [37.579661, 127.015241, 3202.0], [37.585286, 127.019381, 4970.0], [37.586272, 127.029005, 3913.0], [37.590508, 127.036296, 5053.0], [37.601948, 127.041518, 7752.0], [37.606377, 127.048491, 4408.0], [37.610537, 127.056431, 6067.0], [37.614805, 127.065851, 10274.0], [37.617983, 127.07512, 4314.0], [37.620064, 127.084689, 7134.0], [37.617283, 127.091401, 6798.0], [37.700109, 127.053196, 516.0], [37.689313, 127.046222, 8802.0], [37.67785, 127.055315, 10173.0], [37.66494, 127.057675, 10198.0], [37.655128, 127.061368, 9533.0], [37.644583, 127.064303, 10636.0], [37.636352, 127.06799, 12719.0], [37.625742, 127.072896, 8793.0], [37.617983, 127.07512, 5194.0], [37.610637, 127.077725, 8328.0], [37.602545, 127.079264, 8749.0], [37.596362, 127.085032, 12271.0], [37.588579, 127.087503, 13286.0], [37.580894, 127.088478, 13158.0], [37.573647, 127.086727, 5039.0], [37.565923, 127.08432, 7532.0], [37.557121, 127.079542, 8748.0], [37.548014, 127.074658, 6601.0], [37.540693, 127.07023, 6271.0], [37.53154, 127.066704, 5131.0], [37.519365, 127.05335, 3400.0], [37.517186, 127.04128, 2961.0], [37.514229, 127.031656, 3095.0], [37.511093, 127.021415, 4717.0], [37.508178, 127.011727, 1773.0], [37.50481, 127.004943, 3072.0], [37.487618, 126.993513, 5161.0], [37.486263, 126.981989, 8173.0], [37.484596, 126.971251, 8517.0], [37.496029, 126.953822, 8984.0], [37.502834, 126.94791, 7147.0], [37.504898, 126.93915, 7209.0], [37.499701, 126.928276, 12527.0], [37.499872, 126.920428, 5622.0], [37.50008, 126.90993, 8748.0], [37.49297, 126.895801, 5030.0], [37.486056, 126.887249, 7719.0], [37.481072, 126.882343, 6196.0], [37.47605, 126.867911, 15126.0], [37.479252, 126.854876, 16589.0], [37.486637, 126.838713, 8446.0], [37.492258, 126.823388, 8284.0], [37.506207, 126.810939, 6205.0], [37.50538, 126.797337, 2790.0], [37.503663, 126.787036, 4727.0], [37.503048, 126.77596, 8301.0], [37.504631, 126.763538, 7803.0], [37.505781, 126.753083, 7242.0], [37.506411, 126.742153, 3671.0], [37.506997, 126.73128, 7760.0], [37.508336, 126.720548, 8512.0], [37.55021, 127.127562, 14565.0], [37.538397, 127.123572, 11958.0], [37.530341, 127.120508, 6856.0], [37.517409, 127.112359, 2675.0], [37.51395, 127.102234, 4922.0], [37.505431, 127.106979, 4984.0], [37.499703, 127.112183, 5325.0], [37.492522, 127.118234, 3736.0], [37.485855, 127.1225, 5550.0], [37.478703, 127.126191, 9408.0], [37.470047, 127.126662, 5831.0], [37.457122, 127.149908, 6052.0], [37.451535, 127.159816, 10140.0], [37.44521, 127.156866, 7817.0], [37.440918, 127.147564, 3749.0], [37.437428, 127.140722, 3719.0], [37.43213, 127.129087, 1802.0]],\n",
              "                {&quot;blur&quot;: 15, &quot;maxZoom&quot;: 18, &quot;minOpacity&quot;: 0.5, &quot;radius&quot;: 25}\n",
              "            ).addTo(map_b0a3528faa494b2c94b834a261522a99);\n",
              "        \n",
              "&lt;/script&gt;\n",
              "&lt;/html&gt;\" style=\"position:absolute;width:100%;height:100%;left:0;top:0;border:none !important;\" allowfullscreen webkitallowfullscreen mozallowfullscreen></iframe></div></div>"
            ]
          },
          "metadata": {},
          "execution_count": 24
        }
      ],
      "source": [
        "# 퇴근 시간 하차 인원\n",
        "evening_seoul_out = folium.Map(location=[37.55, 126.98], zoom_start = 12)\n",
        "HeatMap(data = evening_joined_data[['geo.latitude', 'geo.longitude', 'people_out']]).add_to(evening_seoul_out)\n",
        "evening_seoul_out"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "d7820b1c",
      "metadata": {
        "id": "d7820b1c"
      },
      "outputs": [],
      "source": []
    }
  ],
  "metadata": {
    "kernelspec": {
      "display_name": "Python 3 (ipykernel)",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "codemirror_mode": {
        "name": "ipython",
        "version": 3
      },
      "file_extension": ".py",
      "mimetype": "text/x-python",
      "name": "python",
      "nbconvert_exporter": "python",
      "pygments_lexer": "ipython3",
      "version": "3.9.12"
    },
    "colab": {
      "provenance": []
    }
  },
  "nbformat": 4,
  "nbformat_minor": 5
}