transporation.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 기타는 PM"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>기간</th>\n",
       "      <th>대분류</th>\n",
       "      <th>분류</th>\n",
       "      <th>도보</th>\n",
       "      <th>자전거</th>\n",
       "      <th>자전거+기타교통수단</th>\n",
       "      <th>오토바이</th>\n",
       "      <th>버스</th>\n",
       "      <th>지하철(철도)</th>\n",
       "      <th>버스+지하철</th>\n",
       "      <th>택시</th>\n",
       "      <th>승용차</th>\n",
       "      <th>승용차+버스</th>\n",
       "      <th>승용차+지하철</th>\n",
       "      <th>기타</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020</td>\n",
       "      <td>서울시</td>\n",
       "      <td>서울시</td>\n",
       "      <td>18.2</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.9</td>\n",
       "      <td>23.3</td>\n",
       "      <td>14.3</td>\n",
       "      <td>21.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>16.5</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020</td>\n",
       "      <td>성별</td>\n",
       "      <td>남자</td>\n",
       "      <td>14.0</td>\n",
       "      <td>2.8</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.3</td>\n",
       "      <td>19.7</td>\n",
       "      <td>14.6</td>\n",
       "      <td>20.7</td>\n",
       "      <td>0.1</td>\n",
       "      <td>23.1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020</td>\n",
       "      <td>성별</td>\n",
       "      <td>여자</td>\n",
       "      <td>23.7</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.2</td>\n",
       "      <td>28.1</td>\n",
       "      <td>13.8</td>\n",
       "      <td>21.7</td>\n",
       "      <td>0.1</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.7</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020</td>\n",
       "      <td>연령별</td>\n",
       "      <td>10대</td>\n",
       "      <td>48.3</td>\n",
       "      <td>4.9</td>\n",
       "      <td>0.8</td>\n",
       "      <td>-</td>\n",
       "      <td>34.6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8.8</td>\n",
       "      <td>-</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020</td>\n",
       "      <td>연령별</td>\n",
       "      <td>20대</td>\n",
       "      <td>13.6</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.7</td>\n",
       "      <td>26.1</td>\n",
       "      <td>18.1</td>\n",
       "      <td>34.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>3.8</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2020</td>\n",
       "      <td>연령별</td>\n",
       "      <td>30대</td>\n",
       "      <td>9.9</td>\n",
       "      <td>2.9</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.5</td>\n",
       "      <td>20.6</td>\n",
       "      <td>19.5</td>\n",
       "      <td>24.9</td>\n",
       "      <td>0.2</td>\n",
       "      <td>17.7</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2020</td>\n",
       "      <td>연령별</td>\n",
       "      <td>40대</td>\n",
       "      <td>12.7</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.5</td>\n",
       "      <td>18.3</td>\n",
       "      <td>17.0</td>\n",
       "      <td>20.1</td>\n",
       "      <td>0.2</td>\n",
       "      <td>23.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2.3</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2020</td>\n",
       "      <td>연령별</td>\n",
       "      <td>50대</td>\n",
       "      <td>17.3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1</td>\n",
       "      <td>20.4</td>\n",
       "      <td>11.8</td>\n",
       "      <td>16.8</td>\n",
       "      <td>0.2</td>\n",
       "      <td>26.8</td>\n",
       "      <td>1.1</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2020</td>\n",
       "      <td>연령별</td>\n",
       "      <td>60대 이상</td>\n",
       "      <td>29.5</td>\n",
       "      <td>2.7</td>\n",
       "      <td>0.1</td>\n",
       "      <td>2.2</td>\n",
       "      <td>27.9</td>\n",
       "      <td>7.3</td>\n",
       "      <td>10.9</td>\n",
       "      <td>0.1</td>\n",
       "      <td>18.2</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2020</td>\n",
       "      <td>학력별</td>\n",
       "      <td>중졸 이하</td>\n",
       "      <td>50.7</td>\n",
       "      <td>2.8</td>\n",
       "      <td>0.3</td>\n",
       "      <td>2.6</td>\n",
       "      <td>24.6</td>\n",
       "      <td>4.2</td>\n",
       "      <td>8.2</td>\n",
       "      <td>0.2</td>\n",
       "      <td>5.9</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2020</td>\n",
       "      <td>학력별</td>\n",
       "      <td>고졸 이하</td>\n",
       "      <td>27.7</td>\n",
       "      <td>3.2</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1.5</td>\n",
       "      <td>30.0</td>\n",
       "      <td>8.4</td>\n",
       "      <td>13.6</td>\n",
       "      <td>0.1</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2020</td>\n",
       "      <td>학력별</td>\n",
       "      <td>대졸 이하</td>\n",
       "      <td>10.8</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.4</td>\n",
       "      <td>21.2</td>\n",
       "      <td>17.7</td>\n",
       "      <td>26.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>17.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>0.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2020</td>\n",
       "      <td>학력별</td>\n",
       "      <td>대학원 이상</td>\n",
       "      <td>12.8</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1</td>\n",
       "      <td>0.2</td>\n",
       "      <td>10.1</td>\n",
       "      <td>18.8</td>\n",
       "      <td>20.9</td>\n",
       "      <td>0.3</td>\n",
       "      <td>26.4</td>\n",
       "      <td>2.7</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2020</td>\n",
       "      <td>소득별</td>\n",
       "      <td>100 만원 미만</td>\n",
       "      <td>30.6</td>\n",
       "      <td>3.7</td>\n",
       "      <td>0.7</td>\n",
       "      <td>1.4</td>\n",
       "      <td>25.8</td>\n",
       "      <td>19.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2020</td>\n",
       "      <td>소득별</td>\n",
       "      <td>100-200만 미만</td>\n",
       "      <td>29.6</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.5</td>\n",
       "      <td>27.1</td>\n",
       "      <td>12.8</td>\n",
       "      <td>20.2</td>\n",
       "      <td>0.5</td>\n",
       "      <td>4.2</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2020</td>\n",
       "      <td>소득별</td>\n",
       "      <td>200-300만 미만</td>\n",
       "      <td>21.0</td>\n",
       "      <td>3.5</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.2</td>\n",
       "      <td>27.4</td>\n",
       "      <td>12.7</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>10.5</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2020</td>\n",
       "      <td>소득별</td>\n",
       "      <td>300-400만 미만</td>\n",
       "      <td>18.5</td>\n",
       "      <td>2.8</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.8</td>\n",
       "      <td>23.8</td>\n",
       "      <td>14.9</td>\n",
       "      <td>19.8</td>\n",
       "      <td>0.2</td>\n",
       "      <td>16.5</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2020</td>\n",
       "      <td>소득별</td>\n",
       "      <td>400-500만 미만</td>\n",
       "      <td>18.5</td>\n",
       "      <td>2.8</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1</td>\n",
       "      <td>24.3</td>\n",
       "      <td>13.8</td>\n",
       "      <td>20.7</td>\n",
       "      <td>0</td>\n",
       "      <td>16.7</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2020</td>\n",
       "      <td>소득별</td>\n",
       "      <td>500만 이상</td>\n",
       "      <td>15.2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.6</td>\n",
       "      <td>21.2</td>\n",
       "      <td>14.6</td>\n",
       "      <td>22.4</td>\n",
       "      <td>0.1</td>\n",
       "      <td>20.4</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2020</td>\n",
       "      <td>혼인상태별</td>\n",
       "      <td>기혼</td>\n",
       "      <td>15.7</td>\n",
       "      <td>2.6</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1</td>\n",
       "      <td>19.7</td>\n",
       "      <td>14.6</td>\n",
       "      <td>18.1</td>\n",
       "      <td>0.2</td>\n",
       "      <td>24.2</td>\n",
       "      <td>1.2</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2020</td>\n",
       "      <td>혼인상태별</td>\n",
       "      <td>미혼</td>\n",
       "      <td>19.3</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.3</td>\n",
       "      <td>26.2</td>\n",
       "      <td>15.5</td>\n",
       "      <td>27.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>6.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2020</td>\n",
       "      <td>혼인상태별</td>\n",
       "      <td>이혼/사별/기타</td>\n",
       "      <td>29.4</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0.2</td>\n",
       "      <td>2.1</td>\n",
       "      <td>34.1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>12.7</td>\n",
       "      <td>0.1</td>\n",
       "      <td>12.7</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2020</td>\n",
       "      <td>지역대분류</td>\n",
       "      <td>도심권</td>\n",
       "      <td>24.5</td>\n",
       "      <td>2.3</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.5</td>\n",
       "      <td>24.9</td>\n",
       "      <td>10.6</td>\n",
       "      <td>17.7</td>\n",
       "      <td>0.1</td>\n",
       "      <td>15.6</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2020</td>\n",
       "      <td>지역대분류</td>\n",
       "      <td>동북권</td>\n",
       "      <td>17.9</td>\n",
       "      <td>2.7</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.8</td>\n",
       "      <td>24.4</td>\n",
       "      <td>14.6</td>\n",
       "      <td>20.5</td>\n",
       "      <td>0.1</td>\n",
       "      <td>15.9</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2020</td>\n",
       "      <td>지역대분류</td>\n",
       "      <td>서북권</td>\n",
       "      <td>16.4</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.9</td>\n",
       "      <td>28.0</td>\n",
       "      <td>12.9</td>\n",
       "      <td>22.8</td>\n",
       "      <td>0.2</td>\n",
       "      <td>13.6</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2020</td>\n",
       "      <td>지역대분류</td>\n",
       "      <td>서남권</td>\n",
       "      <td>18.3</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.9</td>\n",
       "      <td>22.4</td>\n",
       "      <td>14.1</td>\n",
       "      <td>23.5</td>\n",
       "      <td>0.1</td>\n",
       "      <td>15.7</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2020</td>\n",
       "      <td>지역대분류</td>\n",
       "      <td>동남권</td>\n",
       "      <td>17.9</td>\n",
       "      <td>2.7</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.7</td>\n",
       "      <td>19.8</td>\n",
       "      <td>15.7</td>\n",
       "      <td>18.5</td>\n",
       "      <td>0.3</td>\n",
       "      <td>20.9</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2020</td>\n",
       "      <td>종로구</td>\n",
       "      <td>종로구</td>\n",
       "      <td>21.3</td>\n",
       "      <td>3.1</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1.4</td>\n",
       "      <td>27.9</td>\n",
       "      <td>9.7</td>\n",
       "      <td>17.9</td>\n",
       "      <td>0.2</td>\n",
       "      <td>16.3</td>\n",
       "      <td>1.6</td>\n",
       "      <td>0.4</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2020</td>\n",
       "      <td>중구</td>\n",
       "      <td>중구</td>\n",
       "      <td>23.4</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.9</td>\n",
       "      <td>22.5</td>\n",
       "      <td>14.9</td>\n",
       "      <td>21.6</td>\n",
       "      <td>-</td>\n",
       "      <td>11.1</td>\n",
       "      <td>0.4</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2020</td>\n",
       "      <td>용산구</td>\n",
       "      <td>용산구</td>\n",
       "      <td>27.2</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0.5</td>\n",
       "      <td>2</td>\n",
       "      <td>24.3</td>\n",
       "      <td>8.7</td>\n",
       "      <td>15.3</td>\n",
       "      <td>0</td>\n",
       "      <td>17.7</td>\n",
       "      <td>0.7</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2020</td>\n",
       "      <td>성동구</td>\n",
       "      <td>성동구</td>\n",
       "      <td>19.7</td>\n",
       "      <td>2.6</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.2</td>\n",
       "      <td>17.0</td>\n",
       "      <td>18.2</td>\n",
       "      <td>22.5</td>\n",
       "      <td>0</td>\n",
       "      <td>15.8</td>\n",
       "      <td>0.5</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2020</td>\n",
       "      <td>광진구</td>\n",
       "      <td>광진구</td>\n",
       "      <td>24.0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>-</td>\n",
       "      <td>0.5</td>\n",
       "      <td>21.6</td>\n",
       "      <td>18.0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>0.1</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2020</td>\n",
       "      <td>동대문구</td>\n",
       "      <td>동대문구</td>\n",
       "      <td>15.7</td>\n",
       "      <td>2.3</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.7</td>\n",
       "      <td>24.6</td>\n",
       "      <td>14.3</td>\n",
       "      <td>19.7</td>\n",
       "      <td>0.1</td>\n",
       "      <td>18.9</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.2</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2020</td>\n",
       "      <td>중랑구</td>\n",
       "      <td>중랑구</td>\n",
       "      <td>14.2</td>\n",
       "      <td>2.8</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>26.6</td>\n",
       "      <td>15.3</td>\n",
       "      <td>19.2</td>\n",
       "      <td>-</td>\n",
       "      <td>18.3</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2020</td>\n",
       "      <td>성북구</td>\n",
       "      <td>성북구</td>\n",
       "      <td>16.4</td>\n",
       "      <td>2.6</td>\n",
       "      <td>0.2</td>\n",
       "      <td>2.1</td>\n",
       "      <td>24.1</td>\n",
       "      <td>13.6</td>\n",
       "      <td>23.7</td>\n",
       "      <td>0.4</td>\n",
       "      <td>14.2</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2020</td>\n",
       "      <td>강북구</td>\n",
       "      <td>강북구</td>\n",
       "      <td>17.6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.8</td>\n",
       "      <td>24.5</td>\n",
       "      <td>11.6</td>\n",
       "      <td>20.5</td>\n",
       "      <td>0</td>\n",
       "      <td>20.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2020</td>\n",
       "      <td>도봉구</td>\n",
       "      <td>도봉구</td>\n",
       "      <td>23.3</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>23.0</td>\n",
       "      <td>14.2</td>\n",
       "      <td>19.0</td>\n",
       "      <td>-</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.7</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2020</td>\n",
       "      <td>노원구</td>\n",
       "      <td>노원구</td>\n",
       "      <td>15.4</td>\n",
       "      <td>3.1</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.3</td>\n",
       "      <td>29.9</td>\n",
       "      <td>12.8</td>\n",
       "      <td>20.0</td>\n",
       "      <td>-</td>\n",
       "      <td>15.2</td>\n",
       "      <td>0.5</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>2020</td>\n",
       "      <td>은평구</td>\n",
       "      <td>은평구</td>\n",
       "      <td>13.4</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0</td>\n",
       "      <td>30.6</td>\n",
       "      <td>13.4</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>10.4</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>2020</td>\n",
       "      <td>서대문구</td>\n",
       "      <td>서대문구</td>\n",
       "      <td>14.9</td>\n",
       "      <td>2.6</td>\n",
       "      <td>0.1</td>\n",
       "      <td>1</td>\n",
       "      <td>26.5</td>\n",
       "      <td>12.8</td>\n",
       "      <td>23.4</td>\n",
       "      <td>0.3</td>\n",
       "      <td>15.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>2020</td>\n",
       "      <td>마포구</td>\n",
       "      <td>마포구</td>\n",
       "      <td>21.2</td>\n",
       "      <td>2.6</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1.9</td>\n",
       "      <td>26.1</td>\n",
       "      <td>12.3</td>\n",
       "      <td>17.3</td>\n",
       "      <td>0.1</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>2020</td>\n",
       "      <td>양천구</td>\n",
       "      <td>양천구</td>\n",
       "      <td>17.9</td>\n",
       "      <td>2.7</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.1</td>\n",
       "      <td>21.1</td>\n",
       "      <td>8.8</td>\n",
       "      <td>26.3</td>\n",
       "      <td>0.1</td>\n",
       "      <td>20.1</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>2020</td>\n",
       "      <td>강서구</td>\n",
       "      <td>강서구</td>\n",
       "      <td>20.6</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.6</td>\n",
       "      <td>1.4</td>\n",
       "      <td>20.0</td>\n",
       "      <td>12.4</td>\n",
       "      <td>24.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>16.8</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>2020</td>\n",
       "      <td>구로구</td>\n",
       "      <td>구로구</td>\n",
       "      <td>20.4</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.8</td>\n",
       "      <td>21.1</td>\n",
       "      <td>15.0</td>\n",
       "      <td>20.6</td>\n",
       "      <td>-</td>\n",
       "      <td>17.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>2020</td>\n",
       "      <td>금천구</td>\n",
       "      <td>금천구</td>\n",
       "      <td>27.0</td>\n",
       "      <td>2.7</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.8</td>\n",
       "      <td>23.4</td>\n",
       "      <td>8.1</td>\n",
       "      <td>20.3</td>\n",
       "      <td>-</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>2020</td>\n",
       "      <td>영등포구</td>\n",
       "      <td>영등포구</td>\n",
       "      <td>15.8</td>\n",
       "      <td>2.6</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.2</td>\n",
       "      <td>19.1</td>\n",
       "      <td>19.5</td>\n",
       "      <td>23.5</td>\n",
       "      <td>-</td>\n",
       "      <td>15.8</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.8</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>2020</td>\n",
       "      <td>동작구</td>\n",
       "      <td>동작구</td>\n",
       "      <td>11.9</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.3</td>\n",
       "      <td>28.3</td>\n",
       "      <td>14.7</td>\n",
       "      <td>22.5</td>\n",
       "      <td>0</td>\n",
       "      <td>15.7</td>\n",
       "      <td>1.8</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>2020</td>\n",
       "      <td>관악구</td>\n",
       "      <td>관악구</td>\n",
       "      <td>17.3</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.1</td>\n",
       "      <td>24.2</td>\n",
       "      <td>18.0</td>\n",
       "      <td>25.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>9.5</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>2020</td>\n",
       "      <td>서초구</td>\n",
       "      <td>서초구</td>\n",
       "      <td>19.4</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.6</td>\n",
       "      <td>22.7</td>\n",
       "      <td>15.9</td>\n",
       "      <td>15.8</td>\n",
       "      <td>0.2</td>\n",
       "      <td>20.3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>2020</td>\n",
       "      <td>강남구</td>\n",
       "      <td>강남구</td>\n",
       "      <td>16.1</td>\n",
       "      <td>2.3</td>\n",
       "      <td>0</td>\n",
       "      <td>0.4</td>\n",
       "      <td>16.2</td>\n",
       "      <td>14.2</td>\n",
       "      <td>23.1</td>\n",
       "      <td>0.4</td>\n",
       "      <td>23.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.7</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>2020</td>\n",
       "      <td>송파구</td>\n",
       "      <td>송파구</td>\n",
       "      <td>17.1</td>\n",
       "      <td>3.3</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.8</td>\n",
       "      <td>18.4</td>\n",
       "      <td>17.1</td>\n",
       "      <td>16.4</td>\n",
       "      <td>-</td>\n",
       "      <td>23.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>2020</td>\n",
       "      <td>강동구</td>\n",
       "      <td>강동구</td>\n",
       "      <td>19.5</td>\n",
       "      <td>3.7</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1.1</td>\n",
       "      <td>23.5</td>\n",
       "      <td>15.5</td>\n",
       "      <td>18.9</td>\n",
       "      <td>0.5</td>\n",
       "      <td>15.2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      기간    대분류           분류    도보  자전거 자전거+기타교통수단 오토바이    버스  지하철(철도)  \\\n",
       "0   2020    서울시          서울시  18.2  2.5        0.3  0.9  23.3     14.3   \n",
       "1   2020     성별           남자  14.0  2.8        0.4  1.3  19.7     14.6   \n",
       "2   2020     성별           여자  23.7  2.0        0.3  0.2  28.1     13.8   \n",
       "3   2020    연령별          10대  48.3  4.9        0.8    -  34.6      2.0   \n",
       "4   2020    연령별          20대  13.6  1.5        0.3  0.7  26.1     18.1   \n",
       "5   2020    연령별          30대   9.9  2.9        0.3  0.5  20.6     19.5   \n",
       "6   2020    연령별          40대  12.7  2.5        0.4  0.5  18.3     17.0   \n",
       "7   2020    연령별          50대  17.3  2.0        0.3    1  20.4     11.8   \n",
       "8   2020    연령별       60대 이상  29.5  2.7        0.1  2.2  27.9      7.3   \n",
       "9   2020    학력별        중졸 이하  50.7  2.8        0.3  2.6  24.6      4.2   \n",
       "10  2020    학력별        고졸 이하  27.7  3.2        0.2  1.5  30.0      8.4   \n",
       "11  2020    학력별        대졸 이하  10.8  2.1        0.3  0.4  21.2     17.7   \n",
       "12  2020    학력별       대학원 이상  12.8  2.2          1  0.2  10.1     18.8   \n",
       "13  2020    소득별    100 만원 미만  30.6  3.7        0.7  1.4  25.8     19.0   \n",
       "14  2020    소득별  100-200만 미만  29.6  1.9        0.3  1.5  27.1     12.8   \n",
       "15  2020    소득별  200-300만 미만  21.0  3.5        0.4  1.2  27.4     12.7   \n",
       "16  2020    소득별  300-400만 미만  18.5  2.8        0.4  0.8  23.8     14.9   \n",
       "17  2020    소득별  400-500만 미만  18.5  2.8        0.4    1  24.3     13.8   \n",
       "18  2020    소득별      500만 이상  15.2  2.0        0.3  0.6  21.2     14.6   \n",
       "19  2020  혼인상태별           기혼  15.7  2.6        0.3    1  19.7     14.6   \n",
       "20  2020  혼인상태별           미혼  19.3  2.5        0.5  0.3  26.2     15.5   \n",
       "21  2020  혼인상태별     이혼/사별/기타  29.4  1.7        0.2  2.1  34.1      6.0   \n",
       "22  2020  지역대분류          도심권  24.5  2.3        0.4  1.5  24.9     10.6   \n",
       "23  2020  지역대분류          동북권  17.9  2.7        0.4  0.8  24.4     14.6   \n",
       "24  2020  지역대분류          서북권  16.4  2.5        0.2  0.9  28.0     12.9   \n",
       "25  2020  지역대분류          서남권  18.3  2.1        0.5  0.9  22.4     14.1   \n",
       "26  2020  지역대분류          동남권  17.9  2.7        0.1  0.7  19.8     15.7   \n",
       "27  2020    종로구          종로구  21.3  3.1        0.2  1.4  27.9      9.7   \n",
       "28  2020     중구           중구  23.4  1.7        0.5  0.9  22.5     14.9   \n",
       "29  2020    용산구          용산구  27.2  2.1        0.5    2  24.3      8.7   \n",
       "30  2020    성동구          성동구  19.7  2.6        1.3  0.2  17.0     18.2   \n",
       "31  2020    광진구          광진구  24.0  2.9          -  0.5  21.6     18.0   \n",
       "32  2020   동대문구         동대문구  15.7  2.3        0.5  1.7  24.6     14.3   \n",
       "33  2020    중랑구          중랑구  14.2  2.8        0.6  0.5  26.6     15.3   \n",
       "34  2020    성북구          성북구  16.4  2.6        0.2  2.1  24.1     13.6   \n",
       "35  2020    강북구          강북구  17.6  2.0        0.1  0.8  24.5     11.6   \n",
       "36  2020    도봉구          도봉구  23.3  3.0        0.1  0.1  23.0     14.2   \n",
       "37  2020    노원구          노원구  15.4  3.1        0.4  0.3  29.9     12.8   \n",
       "38  2020    은평구          은평구  13.4  2.2        0.3    0  30.6     13.4   \n",
       "39  2020   서대문구         서대문구  14.9  2.6        0.1    1  26.5     12.8   \n",
       "40  2020    마포구          마포구  21.2  2.6        0.2  1.9  26.1     12.3   \n",
       "41  2020    양천구          양천구  17.9  2.7        0.4  0.1  21.1      8.8   \n",
       "42  2020    강서구          강서구  20.6  1.4        0.6  1.4  20.0     12.4   \n",
       "43  2020    구로구          구로구  20.4  2.2        0.5  0.8  21.1     15.0   \n",
       "44  2020    금천구          금천구  27.0  2.7        0.3  0.8  23.4      8.1   \n",
       "45  2020   영등포구         영등포구  15.8  2.6        0.3  0.2  19.1     19.5   \n",
       "46  2020    동작구          동작구  11.9  2.1        0.5  1.3  28.3     14.7   \n",
       "47  2020    관악구          관악구  17.3  1.9        0.4  1.1  24.2     18.0   \n",
       "48  2020    서초구          서초구  19.4  1.5        0.2  0.6  22.7     15.9   \n",
       "49  2020    강남구          강남구  16.1  2.3          0  0.4  16.2     14.2   \n",
       "50  2020    송파구          송파구  17.1  3.3        0.1  0.8  18.4     17.1   \n",
       "51  2020    강동구          강동구  19.5  3.7        0.2  1.1  23.5     15.5   \n",
       "\n",
       "    버스+지하철   택시   승용차  승용차+버스  승용차+지하철   기타  \n",
       "0     21.2  0.1  16.5     0.9      1.5  0.3  \n",
       "1     20.7  0.1  23.1     1.0      1.9  0.3  \n",
       "2     21.7  0.1   8.0     0.7      1.1  0.3  \n",
       "3      8.8    -   0.3     0.0      0.2    -  \n",
       "4     34.2  0.1   3.8     0.5      0.7  0.4  \n",
       "5     24.9  0.2  17.7     1.0      2.1  0.3  \n",
       "6     20.1  0.2  23.8     1.6      2.3  0.5  \n",
       "7     16.8  0.2  26.8     1.1      2.2  0.2  \n",
       "8     10.9  0.1  18.2     0.5      0.6  0.1  \n",
       "9      8.2  0.2   5.9     0.1      0.2  0.1  \n",
       "10    13.6  0.1  14.0     0.5      0.7  0.2  \n",
       "11    26.2  0.1  17.9     1.0      1.8  0.4  \n",
       "12    20.9  0.3  26.4     2.7      4.0  0.7  \n",
       "13    17.0  0.1   0.2     0.3      0.7  0.5  \n",
       "14    20.2  0.5   4.2     0.7      0.8  0.4  \n",
       "15    20.0  0.2  10.5     1.4      1.4  0.3  \n",
       "16    19.8  0.2  16.5     1.1      1.1  0.2  \n",
       "17    20.7    0  16.7     0.5      1.0  0.4  \n",
       "18    22.4  0.1  20.4     0.9      1.9  0.3  \n",
       "19    18.1  0.2  24.2     1.2      2.2  0.3  \n",
       "20    27.2  0.1   6.6     0.6      0.7  0.4  \n",
       "21    12.7  0.1  12.7     0.3      0.6  0.1  \n",
       "22    17.7  0.1  15.6     0.9      1.4  0.2  \n",
       "23    20.5  0.1  15.9     0.8      1.7  0.2  \n",
       "24    22.8  0.2  13.6     0.8      1.4  0.2  \n",
       "25    23.5  0.1  15.7     0.9      1.2  0.4  \n",
       "26    18.5  0.3  20.9     1.2      1.9  0.3  \n",
       "27    17.9  0.2  16.3     1.6      0.4    -  \n",
       "28    21.6    -  11.1     0.4      2.5  0.5  \n",
       "29    15.3    0  17.7     0.7      1.3  0.2  \n",
       "30    22.5    0  15.8     0.5      2.0  0.3  \n",
       "31    19.6  0.1  11.0     0.9      1.0  0.3  \n",
       "32    19.7  0.1  18.9     1.2      1.2    -  \n",
       "33    19.2    -  18.3     0.8      1.5  0.1  \n",
       "34    23.7  0.4  14.2     0.9      1.3  0.5  \n",
       "35    20.5    0  20.5     0.6      1.7    0  \n",
       "36    19.0    -  14.0     0.7      2.2  0.4  \n",
       "37    20.0    -  15.2     0.5      2.2  0.2  \n",
       "38    27.0  0.3  10.4     0.5      1.7  0.1  \n",
       "39    23.4  0.3  15.5     1.0      1.5  0.4  \n",
       "40    17.3  0.1  16.0     0.9      1.1  0.3  \n",
       "41    26.3  0.1  20.1     0.9      1.2  0.4  \n",
       "42    24.1  0.1  16.8     0.8      1.6  0.2  \n",
       "43    20.6    -  17.6     0.6      1.1  0.1  \n",
       "44    20.3    -  15.0     1.2      0.7  0.4  \n",
       "45    23.5    -  15.8     1.1      1.8  0.2  \n",
       "46    22.5    0  15.7     1.8      0.8  0.3  \n",
       "47    25.2  0.1   9.5     0.4      0.9  1.1  \n",
       "48    15.8  0.2  20.3     2.0      1.2  0.2  \n",
       "49    23.1  0.4  23.5     1.0      2.7  0.2  \n",
       "50    16.4    -  23.0     1.0      2.2  0.5  \n",
       "51    18.9  0.5  15.2     1.0      0.9  0.2  "
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "data = pd.read_csv('data/교통 데이터/서울시 통근,통학시 이용 교통수단(2020) 기타는PM.txt', sep = \"\\t\", engine='python')\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>기간</th>\n",
       "      <th>대분류</th>\n",
       "      <th>분류</th>\n",
       "      <th>도보</th>\n",
       "      <th>자전거</th>\n",
       "      <th>자전거+기타교통수단</th>\n",
       "      <th>오토바이</th>\n",
       "      <th>버스</th>\n",
       "      <th>지하철(철도)</th>\n",
       "      <th>버스+지하철</th>\n",
       "      <th>택시</th>\n",
       "      <th>승용차</th>\n",
       "      <th>승용차+버스</th>\n",
       "      <th>승용차+지하철</th>\n",
       "      <th>기타</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020</td>\n",
       "      <td>서울시</td>\n",
       "      <td>서울시</td>\n",
       "      <td>18.2</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.9</td>\n",
       "      <td>23.3</td>\n",
       "      <td>14.3</td>\n",
       "      <td>21.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>16.5</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     기간  대분류   분류    도보  자전거 자전거+기타교통수단 오토바이    버스  지하철(철도)  버스+지하철   택시  \\\n",
       "0  2020  서울시  서울시  18.2  2.5        0.3  0.9  23.3     14.3    21.2  0.1   \n",
       "\n",
       "    승용차  승용차+버스  승용차+지하철   기타  \n",
       "0  16.5     0.9      1.5  0.3  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_total = data[data[\"대분류\"] == \"서울시\"]\n",
    "data_total"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>대분류</th>\n",
       "      <th>도보</th>\n",
       "      <th>자전거</th>\n",
       "      <th>자전거+기타교통수단</th>\n",
       "      <th>오토바이</th>\n",
       "      <th>버스</th>\n",
       "      <th>지하철(철도)</th>\n",
       "      <th>버스+지하철</th>\n",
       "      <th>택시</th>\n",
       "      <th>승용차</th>\n",
       "      <th>승용차+버스</th>\n",
       "      <th>승용차+지하철</th>\n",
       "      <th>기타</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>서울시</td>\n",
       "      <td>18.2</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.9</td>\n",
       "      <td>23.3</td>\n",
       "      <td>14.3</td>\n",
       "      <td>21.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>16.5</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   대분류    도보  자전거 자전거+기타교통수단 오토바이    버스  지하철(철도)  버스+지하철   택시   승용차  승용차+버스  \\\n",
       "0  서울시  18.2  2.5        0.3  0.9  23.3     14.3    21.2  0.1  16.5     0.9   \n",
       "\n",
       "   승용차+지하철   기타  \n",
       "0      1.5  0.3  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_total = data_total[['대분류','도보','자전거','자전거+기타교통수단','오토바이','버스','지하철(철도)','버스+지하철','택시','승용차','승용차+버스','승용차+지하철','기타']]\n",
    "data_total"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_total = data_total.set_index('대분류')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:xlabel='대분류'>"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAW8AAAEaCAYAAADe09ZmAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAAdGElEQVR4nO3de3RU9d3v8fcvhmtAQMgqVQqITwPCogiNFxQh50nA4BUeIVyW2hzDEy4qaIIBrcqlNdwiKxUU4eAjjw+FHEAtFMudQ0+hhWoWHrERTXv0SKREBJVICJrkd/5IMmaSSTIzmczMznxea7mcvfdv/+Y3AT/Z/ua3v9tYaxEREWeJCvUARETEdwpvEREHUniLiDiQwltExIEU3iIiDqTwFhFxoOhgvEmPHj1s3759g/FWIiKtRn5+/pfW2lhPx4IS3n379uXdd98NxluJiLQaxpj/19AxTZuIiDiQwltExIEU3iIiDhSUOW8RCQ/ff/89RUVFlJWVhXooUkv79u3p1asXbdq08fochbdIBCkqKqJz58707dsXY0yohyOAtZZz585RVFTEtdde6/V5mjYRiSBlZWV0795dwR1GjDF0797d5/8bUniLRBgFd/jx589E0yYiEazv/LcD2t+nS+/yum1cXBxXX321277Y2Fi2bt3q2k5KSmL//v1ubZKTk9m9e3fzBtoKKLylxQz+z8EB7/PEL04EvE8Jjd69e9cLZvGewltEwlZBQQEJCQlu+woLC0MzmDCj8BaRsDVw4ECP0yai8BaREOnWrRsJCQkUFxdjraVnz54A7Nq1iw4dOgDw7bffkpCQwIULF7DW0qVLF61Rr6bwFpGQqPlicuPGjZSXl5OamlqvzdGjR5tsE6m0VFBExIF05S0SwXxZ2hco+/bt4/nnn6+3f8OGDa7XmZmZvPDCC422mT9/fkTPfyu8RSSoRo8ezejRo5tsd8899wRhNM6laRMREQdSeIuIOJDCW0TEgRTeIiIOpPAWkbCxffv2JtscOHCAQ4cONdmusLCQkydPBmBU4UmrTUQk6O644w4qKip47733uOGGG+jZsycbN25k1apV3HfffQCMGTOG7777jhMnTjB48GB69uxJXl4ep06dIjr6h+h66KGH+OyzzwD4+uuvmThxIr/85S/Jz8+nrKyMAQMGhOQztjSFt0gkW9glwP1941WzPXv2AFUBvXfvXo9tavYPGjSo0Svt119/3fV6zZo1xMbGejlYZ1N4i0hIlJeXc/z48UbbHDt2jOLiYo4cOUJ+fj4HDx7ks88+IyMjw2P7gwcPsnbt2pYYbtjRnLeIhMS+ffto27YtBw8edO2rrKxkwoQJvPLKK5SVlZGdnc2RI0dYtGgRU6ZM4Xe/+x2zZ8/22N/evXvp1asXGzduZMKECeTm5gbpk4SGrrxFJOgqKyv5zW9+wx/+8AeefPJJRo4cSXR0NFFRUWzbto2vvvqK+++/n6effpr+/fvz0ksvkZqayrZt2zz298EHH5Cbm8u2bdvo2LEjs2fPJi8vr1VXINSVt4gE3bx580hJSWHIkCGkpaUxbdo0ysvLXce7devG2rVrue6667h48SI//elPefvtt12lYmtYa3n99dfJysri1VdfpWPHjsH+KCGjK2+JeC/NONh0Ix898sq/BrzP1uLMmTNcc801PPzwwwBMmjSJjh078v3337u169WrFwsXLiQpKYkRI0a49tcuC3vp0iWKi4vZvn07bdq0Ccr4w4XCW0SCqmfPnjz++ONu+/wtQtWxY0eefPLJAIzKeRTeIpHMy6V9ofTEE0/QpYv7ksY777yzwRUnkULhLSJho+7zKhcuXMjChQv96mvy5MkBGFH40heWIiIOpPAWEXEghbeIiAM1OedtjOkKvAL0pCrsfwG0BV4G2gN/ttZG5te9IhIwhYWFVFRUtNpCUoHmzZV3RyDDWpsALAPmArlAmrX2NqCvMebmFhuhiLQqSUlJHrfz8/M5evRovfZr1qxhzZo1QRmbkzR55W2tPV1r8yvgMtDeWvtp9b43gOHAsYCPTkRa1OD/HBzQ/k784kRA+6usrGTPnj0YY5g+fTpRUZrpreH1UkFjzDVUXXU/Bvym1qFzwPUBHpeItGIbN250vS4rK6OoqIjz58+73d5eWlrK3LlzSUtLIyoqipkzZ5KTk0Pnzp1DMeSw41V4G2PuBu4B/h0oBbrWOtwNOOvhnHQgHaB3797NHaeItCKdOnVyvT516hQ5OTl8/PHHpKSkALB48WIKCgqYN28eQ4cOBapyJD09nbi4OBYtWhSScYcTb76w/Blwj7V2eq197Ywx11hrPwf+Daj3k7TWrgPWAcTHx9vADVlEnG7cuHGu16tXryY3N9etCmBmZiYxMTFu5wwePJjNmzdTWloazKGGLW+uvJOB240xh6q3PwMygG3GmMvADmvthy00PhFphXbv3u16bW39a7u6wV1bJFUObIw3X1guB5Z7ODQ88MMRkdYuMzOToqIi13bdGiUHDhxgyZIljfaRlZXFmDFjWmR8TqHaJiISVGPHjm30eGJiIomJiUEajXMpvEUiWKCX9knwKLxFJCy09iqAgaYV7yIiDqTwFhFxIIW3iIgDKbxFRBxI4S0iYaOwsJCTJ0+67du+fXuj2zXuvfdet+0dO3awdevWRt/Pn3PChVabiEjQPfDAA5w5c4bjx4+7ape8+eab5OfnU1ZW5lbTe9WqVdx3330NbqekpHD+/HmOHz/uKi/729/+ltLSUtft9nX5ck5cXBxXX321277Y2NiQh7zCWySCfTggsAVBrz/pXaWMmqqCI0eOrPfQYYCCggIWL14MQNu2bV3LCOfMmVOv7ZYtW6ioqKBPnz6sX7+etm3b8tprr/H++++73YVZWFjI2rVrycnJ8focqCqI5WmMNZYvX86wYcPq1SlvaZo2EZGQKSws5OzZekVJGThwIHl5eaSmpjJ8+HBSUlLYvHkzw4d7rsrx1FNPkZGRQUZGBqWlpSQnJzNkyBC3NkuXLuXZZ5/16RxvZGRkkJOTQ0VFhc/nNofCW0RCIj8/n3bt2vHWW295PL5y5UqOHTvG1KlTOX36NFlZWa5jZ86coaSkhEuXLjFu3Dji4uLIyMggNzeX5557jq5du9KnTx9X+0uXLhEVFUWXLl28Psdb0dHR3Hjjjfz5z3/2/YfQDJo2caC+898OeJ+fLr0r4H2KNGbZsmVs376dOXPmMHnyZK688kq343v37nVVH3z00UdJTk4Gqp6us3TpUkaNGsX48ePZtGkTn3zyCatXrwbg1ltvZefOncAPj1j76KOPGDRoEAAdOnTw6pwa3bp1IyEhgeLiYqy19OzZE4Bdu3bRoUMHAIYNG8bx48e5/fbbA/tDaoTCW0SCbsmSJcTHxzNkyBBycnJIS0vj1VdfdWszbNgw8vLymDRpEvv37+cnP/kJAFFRUeTm5rradezYka5du9Z7cPGhQ4c4evQoAwYMoLS01K2UrDfn1Kj5YnLjxo2Ul5eTmppa7/PExMRw8eJFv34W/lJ4i0hQffPNNxhjXNMg8fHxZGZmUlJS4tZu8eLFrFu3junTp9O/f39efPHFBvvMz89n5cqVbvu++OIL13v07NmTvXv3+nSOL06fPl1vRUpLU3iLSFB16dKF+fPnu+275ZZb6rWLjo5m1qxZXvV5+vRpHn/8cbcn9NTWr1+/euvHmzpn3759PP/88/X2b9iwwfV6/vz5JCcnc/DgQY9tW5LCWySCebu0zwkWLFjgmsOukZSU5PpFMXz4cP74xz8yatQor84ZPXo0o0ePbvJ9//GPfxATE+Oa1gkWhbeIhA1vysJ6WnM9Y8YMZsyY0eh5jz32GG+88YZP53jjb3/7Gzk5Oc3ux1cKbxGJCFFRUUycODHg/da9xT5YtM5bRMSBFN4iIg6k8BYRcSCFt4iIAym8RSQseKrlHcz3acm64S1Bq01EIthLMw4GtL9HXvnXJtskJSW5Lfer2fZUyxtgzZo1AMycOdOnsfhSMxxapm54S1J4i0jYqqysZM+ePRhjmD59OlFR3k8WNFUzHFqmbniwKLxFJOhqghWgrKyMoqIizp8/71Y8qrS0lLlz55KWlkZUVBQzZ84kJyeHzp07+/ReNTXDY2Nj6x2rqRu+e/du3nnnHQYNGsT48eMxxnjsq3YN8OXLl5OcnNxg25am8BZpAS9Mujug/WX+z50B7S/UOnXq5Hp96tQpcnJy+Pjjj0lJSQGqilIVFBQwb94815RH7969SU9PJy4ujkWLFrn1l5qa6lZzpEbtmuHp6ekex7Jy5UpKSkp44IEH2LVrF1lZWaxYsQKoqhseExNDdHQ0U6ZM4e6772batGlMmDCB+fPnk52dTZ8+fTRtIiKRoXYxqNWrV5Obm0teXp4rBDMzM4mJiXE7Z/DgwWzevJnS0lLXvlmzZlFQUMDJkydJSEjgqquu4s0333Qdb6pmOAS2bngwKbxFJOhqwhLAWlvveN3grq321MrLL78MeL7y9qZmOAS2bngwKbxFJKgyMzMpKipybWdkZLgdP3DgAEuWLGm0j6ysrEa/JPS2ZjgEtm54MCm8RSKYN0v7Am3s2LGNHk9MTCQxMdGnPutedXtbMxwCWzc8mBTeIiI+aKpueLAovEUkLHhTyzuY7+Nv3fBg0e3xIiIOpPAWEXEghbeIiAM1Gd7GmFhjzPPGmF9Vbz9ojCkwxhwyxuxt+SGKSKQqLi7mueeeY/z48YwfP55nn32WM2fOeGz7+9//3m27oaqArYU3V94vAJeBNtXbXYGnrLUJ1trgV2MRkVYlNze33trpGlOnTmXkyJFs2rSJTZs2kZCQwJQpU1zHKyoqKCoqoqioiJUrV7pel5eXs2rVqmB9hJBocrWJtfYhY0wCkFy9qyvwf1puSCISLKGswVJZWcmWLVv44IMPiI6OZtu2bdx///1uhZ4uX77MTTfdRIcOHQC48cYbuXz5suv4hQsXXHdBfvrpp67Xc+fObf6HCXP+LBWMBpYbY74H/stau85TI2NMOpAOVQVlRERqrF69mhMnTjB27FjWr18PwNatW0lLSyMuLs61ZnrFihX079+foUOHUllZyXvvvedWu6Rbt27k5OQA8Ne//tX1OhL4HN7W2gXAAmNMR2C7MeaItfZvHtqtA9YBxMfH1y9eICIR6ezZs9xwww3ccMMNABw+fBiAH//4xzz88MNA1Vx39+7d+dnPfsawYcNc89f33XcfQ4YMoby8nCuuuMJ1lX7hwgWOHj3K559/zjXXXANU1UzJzc3l5ptvZvjw4UH+lC3P5/A2xkRba8uBS0AJoGAWEa+VlJTw97//vdE21lpXEanY2FimTZvmev3II48AMG3aNEaMGAHA8uXLyc7OZsGCBa4reWMMt9xyC7169WqpjxJS/kybLDHG3FR97lvW2oIAj0lEWrF+/frRr18/Pv/8c1auXElBQVWEXH/99TzxxBOuqn633347//znP1m1ahUnTpwAYNCgQTz22GOuq2uAzZs38+233/LrX/+a9evXM3v2bFdhq4bqmbQGXoW3tfYQcKj69ZMtOB4RiRBTp05l+fLl3HTTTUDVnPWUKVNc0ygAkyZN4plnnuGZZ54BqqZYJk2a5GpTXFzMiRMnXKtVpk2bxttvv82XX34Z5E8TfKptIiIhcenSJa6//nrXvPXAgQPdVpLUtLnttttcNbxvu+02Ll++jLUWYww/+tGPyM7OdjvnrrvuCs4HCDGFtzjKhwOuD3ynCS8Fvk+HCOXj1VasWMHEiRNd29Zali1b5tYmOzvb7ZmSlZWVZGdnh+y5keFE4S0iITFq1ChGjRrVaJvRo0czevRov/pv6InxrYVqm4iIOJDCW0TEgRTeIiIOpPAWEXEghbeIhK1Ql4QtLCzk5MmTze6nJSi8RSSkwqEkbFJSksft/Px8jh496vGcNWvWsGbNGq/fI9C0VFAkghXN/1NA++u19Hav2zq5JGxlZSV79uzBGMP06dOJigr+dbDCW0SCLhxLwm7cuNH1uqysjKKiIs6fP++6u7NGaWkpc+fOJS0tjaioKGbOnElOTg6dO3f2+739ofAWkaAKdUnY1NRUNmzYUG9cnTp1cr0+deoUOTk5fPzxx6SkpLj2L168mIKCAubNm8fQoUOBqucVpKenExcXx6JFiwL0U2qawltEgipUJWFnzZpFQUEBJ0+eJCEhgauuusrtKn7cuHGu16tXryY3N5e8vDzKyspc+zMzM4mJiXEb6+DBg9m8eTOlpaX+/Dj8pvAWkaAKVUnYl19+GWj4ynv37t2u19Z6fkxB3eCure70SktTeItISIRTSdjMzEyKiopc2xkZGfXaHDhwwPVLoSFZWVmMGROc57IrvEUkJEJVEtbTVffYsWObHG9iYiKJiYlNtgsWhbdIBPNlaV+gqSRs8yi8RSQknFASdvLkyc3uo6XoDksREQdSeIuIOJDCW0TEgRTeIiIOpPAWkbAVriVh6/bd0Hvde++9bts7duxg69atzR4XKLxFJMTCoSTsAw88QFJSEt27dycpKYmkpCQuXLjQYEnYun3X3U5JSSEpKYkjR464+isuLqa0tJSLFy96Pa7GaKmgSARbuHBhyPoLp5KwNRUFR44c2eASw4KCAhYvXgxA27ZtXcsI58yZU6/tli1bqKiooE+fPqxfv562bdvy2muv8f777wfsDkyFt4gEXTiWhIWqaZKzZ88SGxtb79jAgQPJy8tj9+7dvPPOOwwaNMjtBqK6nnrqKTIyMsjIyGD58uUkJycH9OYiTZuISFDVlIR98MEH6dGjB4cPH+bw4cOukrAjRoyguLiY8vJyV0nYHTt2sHPnTn7+85+7SsLWLh5VuyRsjZqSsH/5y1/c3j81NdXjuPLz82nXrh1vvfVWg2NfuXIlx44dY+rUqZw+fZqsrCzXsTNnzlBSUsKlS5cYN24ccXFxZGRkkJuby3PPPUfXrl3p06ePnz+1+nTlLSJBFa4lYZctW8b27duZM2cOkydP5sorr6w3rr1797qqDz766KMkJycDVVNAS5cuZdSoUYwfP55NmzbxySefsHr1agBuvfVWdu7cCdR/5Jq/FN4iElThWBJ2yZIlxMfHM2TIEHJyckhLS3P98qht2LBh5OXlMWnSJPbv3+8aa1RUlGu+HarKw3bt2pUBAwa4nX/o0CGOHj1ab78/FN4iEhLhUhL2m2++wRjjmgKJj48nMzOTkpKSem0XL17MunXrmD59Ov379+fFF19ssN/8/Px6q2i++OILt6mW5lB4i0hIhEtJ2C5duri+IK1R+4q9tujoaGbNmtXkZwM4ffo0jz/+uNsTegJJ4S0SwQK9VNAXkVASdsGCBa557xpJSUn1fln4Q+EtIiHRmkrCenqvGTNmMGPGjGaPoSFaKigi4kAKbxERB1J4i0SYhp6MLqHjz59Jk+FtjIk1xjxvjPlV9XZ/Y8wBY8wRY8wKP8YpIiHSvn17zp07pwAPI9Zazp07R/v27X06z5svLF8A/g50rN7OBdKstZ8aY7YaY2621h7z6V1FJCR69epFUVERZ8+eDfVQpJb27du77gT1VpPhba19yBiTACQbY6KB9tbaT6sPvwEMBxTeIg7Qpk0brr322lAPQwLA1znvWOBcre1zQDdPDY0x6caYd40x7+q3vIhIYPka3l8DXWttdwM8JrO1dp21Nt5aG++pvKKIiPjPp/C21l4C2hljaqrC/BtwIOCjEhGRRvlzh2UGsM0YcxnYYa39MMBjEhGRJngV3tbaQ8Ch6tfvUPUlpYiIhIhu0hERcSCFt4iIAym8RUQcSOEtIuJACm8REQdSeIuIOJDCW0TEgRTeIiIOpPAWEXEghbeIiAMpvEVEHEjhLSLiQApvEREHUniLiDiQwltExIEU3iIiDqTwFhFxIIW3iIgDKbxFRBxI4S0i4kAKbxERB1J4i4g4kMJbRMSBFN4iIg6k8BYRcSCFt4iIAym8RUQcSOEtIuJACm8REQdSeIuIOJDCW0TEgRTeIiIOpPAWEXEghbeIiAMpvEVEHEjhLSLiQApvEREHivb3RGPMCeBc9eY6a+2mwAxJRESa4nd4A8XW2qSAjURERLzWnGmTyoCNQkREfOJXeBtjYoDrjDH/2xizxRjzEw9t0o0x7xpj3j179myzByoiIj/wK7yttRettddZa0cC/wN4wUObddbaeGttfGxsbHPHKSIitfh75X1FrU1dVouIBJm/X1j+izHmP4Dvqv+ZGbghiYhIU/wKb2vtR8BtAR6LiIh4STfpiIg4kMJbRMSBFN4iIg6k8BYRcSCFt4iIAym8RUQcSOEtIuJACm8REQdSeIuIOJDCW0TEgRTeIiIOpPAWEXEghbeIiAMpvEVEHEjhLSLiQApvEREHUniLiDiQv49Bk9ZmYZfA93lt78D3KSKArrxFRBxJ4S0i4kAKbxERB1J4i4g4kMJbRMSBFN4iIg6k8BYRcSCFt4iIA+kmHZEItXDhQkf0KZ7pyltExIEU3iIiDqTwFhFxIIW3iIgD6QtLEQcomv+nwHfaPvBdSvDoyltExIEU3iIiDqTwFhFxIIW3iIgD+R3exphfGWP+aIw5YowZFMhBiYhI4/wKb2PM7cCPrLWjgOnAioCOSkREGuXvlfcYYDOAtfYD4KqAjUhERJpkrLW+n2TMWmBVdXBjjDkMjLTWVtZqkw6kV2/2Bz5q/nBFWkQP4MtQD0LEgz7W2lhPB/y9SecboFut7crawQ1grV0HrPOzf5GgMca8a62ND/U4RHzh77TJn4AJAMaYgUBRwEYkIiJN8vfK+23gTmPMn4ASqr60FBGRIPErvKunSGYGeCwioaLpPXEcv76wFBGR0NIdliIiDqTwFhFxIIW3iIgDKbxFRBxI4S0i4kB6DJpEBGPMz4E7mmpnrc0OwnBEmk3hLZHin8CRUA9CJFC0zlsimjHmKsBaa78K9VhEfKE5b4lYxphOwCbgulCPRcRXCm+JOMaYaGPMROBN4Flr7buhHpOIrzTnLRHDGLMLaAvEA6eAO6y1n4d2VCL+0Zy3RCRjzBjgUWC9tXZHqMcj4iuFt0QsY8wVwBpgv7V2S6jHI+ILhbdEtOoAv9paeyrUYxHxhb6wlIhUPW2CtbZCwS1OpPCWSDW/7g5jzE9DMRARfyi8JSIYY64zxhw3xrxljGlXtcv0MMa8b4z5rLrZ2lCOUcQXWiookWIW8ARwBXAXYKm6eHkduLO6jQnN0ER8pytviRRxwF+AY9WvASZRFeIijqPwlkhj+eEKuzyUAxFpDoW3RIoPgVuAG4GT1fveqNNGV+HiGApviRQvAy9QdVflH6r3VQLfAWXVt85rtYk4hm7SkYhkjPlf1tr/FupxiPhLV94SqZ4P9QBEmkNX3hIR9Bg0aW20zlsiRe3HoKUCh4BPQzQWkWZTeEtEsNaeBk4DGGMSgHestQXGmB5Vh+25EA5PxGea85ZItB84Y4zpDGwE+oR4PCI+05y3RBxjTDQwHvh34Gk9Bk2cSNMmEjH0GDRpTXTlLRFJj0ETp1N4S8TSY9DEyRTeEtH0GDRxKoW3iIgDaamgtHrGmBhjTGKoxyESSFptIq2GMWY3P/ydPm+tTaneNw14EDhQ3W6/tTap7rnW2uQ6+7YDXeq8TT9rbe8W+QAiPlB4S6tSN5QbcK0x5lCdfb08tCun/gMbNM8oYUHhLZHoSyCnzr6nPbSL8fKXgUjQKbyltRsKrAfO1No3F2hXp908D+d2Msbs97D/v2t1ioSawltau/eA6cAiY8xo4JcNNTTGACy11u4GsNaOCMYARfyh8JZWxRjzL8AVQAzwf6mao64AsNbuA/bVajsB6GGtfaVOH4nAU9X9DAROVB8aTNWzMMuB5dbavS36YUQaofCW1uQtYCZwGSgBfuupkTHmRWvt7IY6sdYeAA4YYzoBG6y1E6rP2wZMs9Z+HeiBi/hK4S2thrV2bd191VMhdQ2s/vcuqq6uRRxH4S2RaEjtLyJrBby+iBTH0O3xIg0wVanepWaaxBjTFfjG6j8aCQMKbxERB1JtExERB1J4i4g4kMJbRMSBFN4iIg6k8BYRcSCFt4iIA/1/SG5tExeOzKUAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "data_total.plot(kind='bar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>도보</th>\n",
       "      <th>자전거</th>\n",
       "      <th>자전거+기타교통수단</th>\n",
       "      <th>오토바이</th>\n",
       "      <th>버스</th>\n",
       "      <th>지하철(철도)</th>\n",
       "      <th>버스+지하철</th>\n",
       "      <th>택시</th>\n",
       "      <th>승용차</th>\n",
       "      <th>승용차+버스</th>\n",
       "      <th>승용차+지하철</th>\n",
       "      <th>기타</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>분류</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>남자</th>\n",
       "      <td>14.0</td>\n",
       "      <td>2.8</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.3</td>\n",
       "      <td>19.7</td>\n",
       "      <td>14.6</td>\n",
       "      <td>20.7</td>\n",
       "      <td>0.1</td>\n",
       "      <td>23.1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>여자</th>\n",
       "      <td>23.7</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.2</td>\n",
       "      <td>28.1</td>\n",
       "      <td>13.8</td>\n",
       "      <td>21.7</td>\n",
       "      <td>0.1</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.7</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      도보  자전거 자전거+기타교통수단 오토바이    버스  지하철(철도)  버스+지하철   택시   승용차  승용차+버스  \\\n",
       "분류                                                                        \n",
       "남자  14.0  2.8        0.4  1.3  19.7     14.6    20.7  0.1  23.1     1.0   \n",
       "여자  23.7  2.0        0.3  0.2  28.1     13.8    21.7  0.1   8.0     0.7   \n",
       "\n",
       "    승용차+지하철   기타  \n",
       "분류                \n",
       "남자      1.9  0.3  \n",
       "여자      1.1  0.3  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_sex = data[data[\"대분류\"] == \"성별\"]\n",
    "data_sex = data_sex[['분류','도보','자전거','자전거+기타교통수단','오토바이','버스','지하철(철도)','버스+지하철','택시','승용차','승용차+버스','승용차+지하철','기타']]\n",
    "data_sex = data_sex.set_index('분류')\n",
    "data_sex"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>도보</th>\n",
       "      <th>자전거</th>\n",
       "      <th>자전거+기타교통수단</th>\n",
       "      <th>오토바이</th>\n",
       "      <th>버스</th>\n",
       "      <th>지하철(철도)</th>\n",
       "      <th>버스+지하철</th>\n",
       "      <th>택시</th>\n",
       "      <th>승용차</th>\n",
       "      <th>승용차+버스</th>\n",
       "      <th>승용차+지하철</th>\n",
       "      <th>기타</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>분류</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10대</th>\n",
       "      <td>48.3</td>\n",
       "      <td>4.9</td>\n",
       "      <td>0.8</td>\n",
       "      <td>-</td>\n",
       "      <td>34.6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8.8</td>\n",
       "      <td>-</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20대</th>\n",
       "      <td>13.6</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.7</td>\n",
       "      <td>26.1</td>\n",
       "      <td>18.1</td>\n",
       "      <td>34.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>3.8</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30대</th>\n",
       "      <td>9.9</td>\n",
       "      <td>2.9</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.5</td>\n",
       "      <td>20.6</td>\n",
       "      <td>19.5</td>\n",
       "      <td>24.9</td>\n",
       "      <td>0.2</td>\n",
       "      <td>17.7</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40대</th>\n",
       "      <td>12.7</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.5</td>\n",
       "      <td>18.3</td>\n",
       "      <td>17.0</td>\n",
       "      <td>20.1</td>\n",
       "      <td>0.2</td>\n",
       "      <td>23.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2.3</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50대</th>\n",
       "      <td>17.3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1</td>\n",
       "      <td>20.4</td>\n",
       "      <td>11.8</td>\n",
       "      <td>16.8</td>\n",
       "      <td>0.2</td>\n",
       "      <td>26.8</td>\n",
       "      <td>1.1</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60대 이상</th>\n",
       "      <td>29.5</td>\n",
       "      <td>2.7</td>\n",
       "      <td>0.1</td>\n",
       "      <td>2.2</td>\n",
       "      <td>27.9</td>\n",
       "      <td>7.3</td>\n",
       "      <td>10.9</td>\n",
       "      <td>0.1</td>\n",
       "      <td>18.2</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          도보  자전거 자전거+기타교통수단 오토바이    버스  지하철(철도)  버스+지하철   택시   승용차  승용차+버스  \\\n",
       "분류                                                                            \n",
       "10대     48.3  4.9        0.8    -  34.6      2.0     8.8    -   0.3     0.0   \n",
       "20대     13.6  1.5        0.3  0.7  26.1     18.1    34.2  0.1   3.8     0.5   \n",
       "30대      9.9  2.9        0.3  0.5  20.6     19.5    24.9  0.2  17.7     1.0   \n",
       "40대     12.7  2.5        0.4  0.5  18.3     17.0    20.1  0.2  23.8     1.6   \n",
       "50대     17.3  2.0        0.3    1  20.4     11.8    16.8  0.2  26.8     1.1   \n",
       "60대 이상  29.5  2.7        0.1  2.2  27.9      7.3    10.9  0.1  18.2     0.5   \n",
       "\n",
       "        승용차+지하철   기타  \n",
       "분류                    \n",
       "10대         0.2    -  \n",
       "20대         0.7  0.4  \n",
       "30대         2.1  0.3  \n",
       "40대         2.3  0.5  \n",
       "50대         2.2  0.2  \n",
       "60대 이상      0.6  0.1  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_age = data[data[\"대분류\"] == \"연령별\"]\n",
    "data_age = data_age[['분류','도보','자전거','자전거+기타교통수단','오토바이','버스','지하철(철도)','버스+지하철','택시','승용차','승용차+버스','승용차+지하철','기타']]\n",
    "data_age = data_age.set_index('분류')\n",
    "data_age"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>도보</th>\n",
       "      <th>자전거</th>\n",
       "      <th>자전거+기타교통수단</th>\n",
       "      <th>오토바이</th>\n",
       "      <th>버스</th>\n",
       "      <th>지하철(철도)</th>\n",
       "      <th>버스+지하철</th>\n",
       "      <th>택시</th>\n",
       "      <th>승용차</th>\n",
       "      <th>승용차+버스</th>\n",
       "      <th>승용차+지하철</th>\n",
       "      <th>기타</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>분류</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>종로구</th>\n",
       "      <td>21.3</td>\n",
       "      <td>3.1</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1.4</td>\n",
       "      <td>27.9</td>\n",
       "      <td>9.7</td>\n",
       "      <td>17.9</td>\n",
       "      <td>0.2</td>\n",
       "      <td>16.3</td>\n",
       "      <td>1.6</td>\n",
       "      <td>0.4</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>중구</th>\n",
       "      <td>23.4</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.9</td>\n",
       "      <td>22.5</td>\n",
       "      <td>14.9</td>\n",
       "      <td>21.6</td>\n",
       "      <td>-</td>\n",
       "      <td>11.1</td>\n",
       "      <td>0.4</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>용산구</th>\n",
       "      <td>27.2</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0.5</td>\n",
       "      <td>2</td>\n",
       "      <td>24.3</td>\n",
       "      <td>8.7</td>\n",
       "      <td>15.3</td>\n",
       "      <td>0</td>\n",
       "      <td>17.7</td>\n",
       "      <td>0.7</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>성동구</th>\n",
       "      <td>19.7</td>\n",
       "      <td>2.6</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.2</td>\n",
       "      <td>17.0</td>\n",
       "      <td>18.2</td>\n",
       "      <td>22.5</td>\n",
       "      <td>0</td>\n",
       "      <td>15.8</td>\n",
       "      <td>0.5</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>광진구</th>\n",
       "      <td>24.0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>-</td>\n",
       "      <td>0.5</td>\n",
       "      <td>21.6</td>\n",
       "      <td>18.0</td>\n",
       "      <td>19.6</td>\n",
       "      <td>0.1</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>동대문구</th>\n",
       "      <td>15.7</td>\n",
       "      <td>2.3</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.7</td>\n",
       "      <td>24.6</td>\n",
       "      <td>14.3</td>\n",
       "      <td>19.7</td>\n",
       "      <td>0.1</td>\n",
       "      <td>18.9</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.2</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>중랑구</th>\n",
       "      <td>14.2</td>\n",
       "      <td>2.8</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>26.6</td>\n",
       "      <td>15.3</td>\n",
       "      <td>19.2</td>\n",
       "      <td>-</td>\n",
       "      <td>18.3</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>성북구</th>\n",
       "      <td>16.4</td>\n",
       "      <td>2.6</td>\n",
       "      <td>0.2</td>\n",
       "      <td>2.1</td>\n",
       "      <td>24.1</td>\n",
       "      <td>13.6</td>\n",
       "      <td>23.7</td>\n",
       "      <td>0.4</td>\n",
       "      <td>14.2</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>강북구</th>\n",
       "      <td>17.6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.8</td>\n",
       "      <td>24.5</td>\n",
       "      <td>11.6</td>\n",
       "      <td>20.5</td>\n",
       "      <td>0</td>\n",
       "      <td>20.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>도봉구</th>\n",
       "      <td>23.3</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>23.0</td>\n",
       "      <td>14.2</td>\n",
       "      <td>19.0</td>\n",
       "      <td>-</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.7</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>노원구</th>\n",
       "      <td>15.4</td>\n",
       "      <td>3.1</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.3</td>\n",
       "      <td>29.9</td>\n",
       "      <td>12.8</td>\n",
       "      <td>20.0</td>\n",
       "      <td>-</td>\n",
       "      <td>15.2</td>\n",
       "      <td>0.5</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>은평구</th>\n",
       "      <td>13.4</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0</td>\n",
       "      <td>30.6</td>\n",
       "      <td>13.4</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>10.4</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>서대문구</th>\n",
       "      <td>14.9</td>\n",
       "      <td>2.6</td>\n",
       "      <td>0.1</td>\n",
       "      <td>1</td>\n",
       "      <td>26.5</td>\n",
       "      <td>12.8</td>\n",
       "      <td>23.4</td>\n",
       "      <td>0.3</td>\n",
       "      <td>15.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>마포구</th>\n",
       "      <td>21.2</td>\n",
       "      <td>2.6</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1.9</td>\n",
       "      <td>26.1</td>\n",
       "      <td>12.3</td>\n",
       "      <td>17.3</td>\n",
       "      <td>0.1</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>양천구</th>\n",
       "      <td>17.9</td>\n",
       "      <td>2.7</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.1</td>\n",
       "      <td>21.1</td>\n",
       "      <td>8.8</td>\n",
       "      <td>26.3</td>\n",
       "      <td>0.1</td>\n",
       "      <td>20.1</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>강서구</th>\n",
       "      <td>20.6</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.6</td>\n",
       "      <td>1.4</td>\n",
       "      <td>20.0</td>\n",
       "      <td>12.4</td>\n",
       "      <td>24.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>16.8</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>구로구</th>\n",
       "      <td>20.4</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.8</td>\n",
       "      <td>21.1</td>\n",
       "      <td>15.0</td>\n",
       "      <td>20.6</td>\n",
       "      <td>-</td>\n",
       "      <td>17.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>금천구</th>\n",
       "      <td>27.0</td>\n",
       "      <td>2.7</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.8</td>\n",
       "      <td>23.4</td>\n",
       "      <td>8.1</td>\n",
       "      <td>20.3</td>\n",
       "      <td>-</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>영등포구</th>\n",
       "      <td>15.8</td>\n",
       "      <td>2.6</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.2</td>\n",
       "      <td>19.1</td>\n",
       "      <td>19.5</td>\n",
       "      <td>23.5</td>\n",
       "      <td>-</td>\n",
       "      <td>15.8</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.8</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>동작구</th>\n",
       "      <td>11.9</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.3</td>\n",
       "      <td>28.3</td>\n",
       "      <td>14.7</td>\n",
       "      <td>22.5</td>\n",
       "      <td>0</td>\n",
       "      <td>15.7</td>\n",
       "      <td>1.8</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>관악구</th>\n",
       "      <td>17.3</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.1</td>\n",
       "      <td>24.2</td>\n",
       "      <td>18.0</td>\n",
       "      <td>25.2</td>\n",
       "      <td>0.1</td>\n",
       "      <td>9.5</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>서초구</th>\n",
       "      <td>19.4</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.6</td>\n",
       "      <td>22.7</td>\n",
       "      <td>15.9</td>\n",
       "      <td>15.8</td>\n",
       "      <td>0.2</td>\n",
       "      <td>20.3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>강남구</th>\n",
       "      <td>16.1</td>\n",
       "      <td>2.3</td>\n",
       "      <td>0</td>\n",
       "      <td>0.4</td>\n",
       "      <td>16.2</td>\n",
       "      <td>14.2</td>\n",
       "      <td>23.1</td>\n",
       "      <td>0.4</td>\n",
       "      <td>23.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.7</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>송파구</th>\n",
       "      <td>17.1</td>\n",
       "      <td>3.3</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.8</td>\n",
       "      <td>18.4</td>\n",
       "      <td>17.1</td>\n",
       "      <td>16.4</td>\n",
       "      <td>-</td>\n",
       "      <td>23.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>강동구</th>\n",
       "      <td>19.5</td>\n",
       "      <td>3.7</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1.1</td>\n",
       "      <td>23.5</td>\n",
       "      <td>15.5</td>\n",
       "      <td>18.9</td>\n",
       "      <td>0.5</td>\n",
       "      <td>15.2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        도보  자전거 자전거+기타교통수단 오토바이    버스  지하철(철도)  버스+지하철   택시   승용차  승용차+버스  \\\n",
       "분류                                                                          \n",
       "종로구   21.3  3.1        0.2  1.4  27.9      9.7    17.9  0.2  16.3     1.6   \n",
       "중구    23.4  1.7        0.5  0.9  22.5     14.9    21.6    -  11.1     0.4   \n",
       "용산구   27.2  2.1        0.5    2  24.3      8.7    15.3    0  17.7     0.7   \n",
       "성동구   19.7  2.6        1.3  0.2  17.0     18.2    22.5    0  15.8     0.5   \n",
       "광진구   24.0  2.9          -  0.5  21.6     18.0    19.6  0.1  11.0     0.9   \n",
       "동대문구  15.7  2.3        0.5  1.7  24.6     14.3    19.7  0.1  18.9     1.2   \n",
       "중랑구   14.2  2.8        0.6  0.5  26.6     15.3    19.2    -  18.3     0.8   \n",
       "성북구   16.4  2.6        0.2  2.1  24.1     13.6    23.7  0.4  14.2     0.9   \n",
       "강북구   17.6  2.0        0.1  0.8  24.5     11.6    20.5    0  20.5     0.6   \n",
       "도봉구   23.3  3.0        0.1  0.1  23.0     14.2    19.0    -  14.0     0.7   \n",
       "노원구   15.4  3.1        0.4  0.3  29.9     12.8    20.0    -  15.2     0.5   \n",
       "은평구   13.4  2.2        0.3    0  30.6     13.4    27.0  0.3  10.4     0.5   \n",
       "서대문구  14.9  2.6        0.1    1  26.5     12.8    23.4  0.3  15.5     1.0   \n",
       "마포구   21.2  2.6        0.2  1.9  26.1     12.3    17.3  0.1  16.0     0.9   \n",
       "양천구   17.9  2.7        0.4  0.1  21.1      8.8    26.3  0.1  20.1     0.9   \n",
       "강서구   20.6  1.4        0.6  1.4  20.0     12.4    24.1  0.1  16.8     0.8   \n",
       "구로구   20.4  2.2        0.5  0.8  21.1     15.0    20.6    -  17.6     0.6   \n",
       "금천구   27.0  2.7        0.3  0.8  23.4      8.1    20.3    -  15.0     1.2   \n",
       "영등포구  15.8  2.6        0.3  0.2  19.1     19.5    23.5    -  15.8     1.1   \n",
       "동작구   11.9  2.1        0.5  1.3  28.3     14.7    22.5    0  15.7     1.8   \n",
       "관악구   17.3  1.9        0.4  1.1  24.2     18.0    25.2  0.1   9.5     0.4   \n",
       "서초구   19.4  1.5        0.2  0.6  22.7     15.9    15.8  0.2  20.3     2.0   \n",
       "강남구   16.1  2.3          0  0.4  16.2     14.2    23.1  0.4  23.5     1.0   \n",
       "송파구   17.1  3.3        0.1  0.8  18.4     17.1    16.4    -  23.0     1.0   \n",
       "강동구   19.5  3.7        0.2  1.1  23.5     15.5    18.9  0.5  15.2     1.0   \n",
       "\n",
       "      승용차+지하철   기타  \n",
       "분류                  \n",
       "종로구       0.4    -  \n",
       "중구        2.5  0.5  \n",
       "용산구       1.3  0.2  \n",
       "성동구       2.0  0.3  \n",
       "광진구       1.0  0.3  \n",
       "동대문구      1.2    -  \n",
       "중랑구       1.5  0.1  \n",
       "성북구       1.3  0.5  \n",
       "강북구       1.7    0  \n",
       "도봉구       2.2  0.4  \n",
       "노원구       2.2  0.2  \n",
       "은평구       1.7  0.1  \n",
       "서대문구      1.5  0.4  \n",
       "마포구       1.1  0.3  \n",
       "양천구       1.2  0.4  \n",
       "강서구       1.6  0.2  \n",
       "구로구       1.1  0.1  \n",
       "금천구       0.7  0.4  \n",
       "영등포구      1.8  0.2  \n",
       "동작구       0.8  0.3  \n",
       "관악구       0.9  1.1  \n",
       "서초구       1.2  0.2  \n",
       "강남구       2.7  0.2  \n",
       "송파구       2.2  0.5  \n",
       "강동구       0.9  0.2  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 27부터, 51행 \n",
    "\n",
    "data_gu = data.loc[27:51]\n",
    "data_gu = data_gu[['분류','도보','자전거','자전거+기타교통수단','오토바이','버스','지하철(철도)','버스+지하철','택시','승용차','승용차+버스','승용차+지하철','기타']]\n",
    "data_gu = data_gu.set_index('분류')\n",
    "data_gu"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "pydatavenv",
   "language": "python",
   "name": "pydatavenv"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}