data_combining .ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "4d1cc6d4",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "154caff3",
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>가락1동</td>\n",
       "      <td>11710631</td>\n",
       "      <td>42.58</td>\n",
       "      <td>42.35</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>가락2동</td>\n",
       "      <td>11710632</td>\n",
       "      <td>47.42</td>\n",
       "      <td>46.97</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>가락본동</td>\n",
       "      <td>11710620</td>\n",
       "      <td>29.90</td>\n",
       "      <td>31.00</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>가리봉동</td>\n",
       "      <td>11530595</td>\n",
       "      <td>27.84</td>\n",
       "      <td>28.74</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>가산동</td>\n",
       "      <td>11545510</td>\n",
       "      <td>43.42</td>\n",
       "      <td>43.35</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>효창동</td>\n",
       "      <td>11170580</td>\n",
       "      <td>19.81</td>\n",
       "      <td>21.13</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>412</th>\n",
       "      <td>후암동</td>\n",
       "      <td>11170510</td>\n",
       "      <td>13.26</td>\n",
       "      <td>14.65</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413</th>\n",
       "      <td>휘경1동</td>\n",
       "      <td>11230720</td>\n",
       "      <td>41.19</td>\n",
       "      <td>41.10</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414</th>\n",
       "      <td>휘경2동</td>\n",
       "      <td>11230730</td>\n",
       "      <td>54.03</td>\n",
       "      <td>53.26</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>흑석동</td>\n",
       "      <td>11590605</td>\n",
       "      <td>16.94</td>\n",
       "      <td>18.58</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>416 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     행정동명    행정동_코드  대여소당_하루평균_반납건수  대여소당_하루평균_대여건수  대여소수\n",
       "0    가락1동  11710631           42.58           42.35     7\n",
       "1    가락2동  11710632           47.42           46.97     5\n",
       "2    가락본동  11710620           29.90           31.00     6\n",
       "3    가리봉동  11530595           27.84           28.74     1\n",
       "4     가산동  11545510           43.42           43.35    19\n",
       "..    ...       ...             ...             ...   ...\n",
       "411   효창동  11170580           19.81           21.13     2\n",
       "412   후암동  11170510           13.26           14.65     2\n",
       "413  휘경1동  11230720           41.19           41.10     4\n",
       "414  휘경2동  11230730           54.03           53.26     7\n",
       "415   흑석동  11590605           16.94           18.58    11\n",
       "\n",
       "[416 rows x 5 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bike= pd.read_csv('행정동별_반납건수_대여건수_대여소수_대여소당_하루평균.csv', encoding='cp949')\n",
    "bike"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c0d02c57",
   "metadata": {},
   "source": [
    "# 행정동코드, 행정동명으로 join"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "1b1d358d",
   "metadata": {},
   "outputs": [],
   "source": [
    "rc= pd.read_csv('행정동별_대규모점포개수.csv',encoding='cp949')\n",
    "business= pd.read_csv('행정동별_사업체수.csv',encoding='cp949')\n",
    "hospital= pd.read_csv('행정동별_병원수.csv',encoding='cp949')\n",
    "food= pd.read_csv('행정동별_음식점수.csv',encoding='cp949')\n",
    "park= pd.read_csv('행정동별_공원수.csv',encoding='cp949')\n",
    "cafe= pd.read_csv('행정동별_카페수.csv',encoding='cp949')\n",
    "house= pd.read_csv('행정동별_주거단지수.csv',encoding='cp949')\n",
    "bank= pd.read_csv('행정동별_은행.csv',encoding='cp949')\n",
    "car= pd.read_csv('행정동별_자동차수.csv',encoding='cp949')\n",
    "school= pd.read_csv('행정동별_학교수.csv',encoding='cp949')\n",
    "bus_real= pd.read_csv('행정동별_버스_정류장수_승하차인원.csv',encoding='cp949')\n",
    "subway_real= pd.read_csv('행정동별_지하철역_역사수_승하차인원.csv',encoding='cp949')\n",
    "people= pd.read_csv('행정동별_연령대_생활인구.csv',encoding='cp949')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "aae0d910",
   "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>행정동명_x</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>남자60대</th>\n",
       "      <th>남자70대이상</th>\n",
       "      <th>여자0~9세</th>\n",
       "      <th>여자10대</th>\n",
       "      <th>여자20대</th>\n",
       "      <th>여자30대</th>\n",
       "      <th>여자40대</th>\n",
       "      <th>여자50대</th>\n",
       "      <th>여자60대</th>\n",
       "      <th>여자70대이상</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>가락1동</td>\n",
       "      <td>11710631</td>\n",
       "      <td>42.58</td>\n",
       "      <td>42.35</td>\n",
       "      <td>7</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2988.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>287.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>39279.78</td>\n",
       "      <td>25572.03</td>\n",
       "      <td>21462.96</td>\n",
       "      <td>26269.89</td>\n",
       "      <td>37340.87</td>\n",
       "      <td>63199.29</td>\n",
       "      <td>53669.20</td>\n",
       "      <td>56419.00</td>\n",
       "      <td>46770.79</td>\n",
       "      <td>33483.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>가락2동</td>\n",
       "      <td>11710632</td>\n",
       "      <td>47.42</td>\n",
       "      <td>46.97</td>\n",
       "      <td>5</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1901.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>144.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>36486.47</td>\n",
       "      <td>27235.70</td>\n",
       "      <td>27266.29</td>\n",
       "      <td>37623.89</td>\n",
       "      <td>43008.96</td>\n",
       "      <td>53467.95</td>\n",
       "      <td>61379.82</td>\n",
       "      <td>59961.07</td>\n",
       "      <td>47852.46</td>\n",
       "      <td>40968.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>가락본동</td>\n",
       "      <td>11710620</td>\n",
       "      <td>29.90</td>\n",
       "      <td>31.00</td>\n",
       "      <td>6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3489.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>1986.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>47993.64</td>\n",
       "      <td>29118.88</td>\n",
       "      <td>28307.03</td>\n",
       "      <td>33042.97</td>\n",
       "      <td>67452.62</td>\n",
       "      <td>81496.19</td>\n",
       "      <td>76617.26</td>\n",
       "      <td>78745.07</td>\n",
       "      <td>55112.75</td>\n",
       "      <td>39906.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>가리봉동</td>\n",
       "      <td>11530595</td>\n",
       "      <td>27.84</td>\n",
       "      <td>28.74</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>993.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>326.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>16501.66</td>\n",
       "      <td>9796.51</td>\n",
       "      <td>1628.15</td>\n",
       "      <td>3141.69</td>\n",
       "      <td>24724.62</td>\n",
       "      <td>23998.43</td>\n",
       "      <td>17637.52</td>\n",
       "      <td>21234.31</td>\n",
       "      <td>14367.82</td>\n",
       "      <td>15249.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>가산동</td>\n",
       "      <td>11545510</td>\n",
       "      <td>43.42</td>\n",
       "      <td>43.35</td>\n",
       "      <td>19</td>\n",
       "      <td>7.0</td>\n",
       "      <td>16661.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>2419.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>56961.42</td>\n",
       "      <td>25773.79</td>\n",
       "      <td>11959.29</td>\n",
       "      <td>16029.77</td>\n",
       "      <td>163080.66</td>\n",
       "      <td>141960.79</td>\n",
       "      <td>92089.70</td>\n",
       "      <td>75059.80</td>\n",
       "      <td>42315.15</td>\n",
       "      <td>28966.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>효창동</td>\n",
       "      <td>11170580</td>\n",
       "      <td>19.81</td>\n",
       "      <td>21.13</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>418.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>10387.09</td>\n",
       "      <td>10073.41</td>\n",
       "      <td>10420.71</td>\n",
       "      <td>10713.03</td>\n",
       "      <td>20631.12</td>\n",
       "      <td>24206.48</td>\n",
       "      <td>19457.64</td>\n",
       "      <td>19675.08</td>\n",
       "      <td>14148.53</td>\n",
       "      <td>19063.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>412</th>\n",
       "      <td>후암동</td>\n",
       "      <td>11170510</td>\n",
       "      <td>13.26</td>\n",
       "      <td>14.65</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>928.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>301.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>17221.31</td>\n",
       "      <td>12924.93</td>\n",
       "      <td>8083.37</td>\n",
       "      <td>11368.53</td>\n",
       "      <td>25913.49</td>\n",
       "      <td>32108.32</td>\n",
       "      <td>29707.73</td>\n",
       "      <td>24658.22</td>\n",
       "      <td>20501.38</td>\n",
       "      <td>24725.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413</th>\n",
       "      <td>휘경1동</td>\n",
       "      <td>11230720</td>\n",
       "      <td>41.19</td>\n",
       "      <td>41.10</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>929.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>455.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>17359.21</td>\n",
       "      <td>15414.41</td>\n",
       "      <td>9111.12</td>\n",
       "      <td>16476.38</td>\n",
       "      <td>60679.10</td>\n",
       "      <td>27767.30</td>\n",
       "      <td>22969.57</td>\n",
       "      <td>25412.94</td>\n",
       "      <td>20482.21</td>\n",
       "      <td>25691.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414</th>\n",
       "      <td>휘경2동</td>\n",
       "      <td>11230730</td>\n",
       "      <td>54.03</td>\n",
       "      <td>53.26</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1221.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>20807.92</td>\n",
       "      <td>20109.40</td>\n",
       "      <td>14059.11</td>\n",
       "      <td>23551.61</td>\n",
       "      <td>52511.26</td>\n",
       "      <td>28566.01</td>\n",
       "      <td>31472.69</td>\n",
       "      <td>33902.75</td>\n",
       "      <td>28311.26</td>\n",
       "      <td>32882.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>흑석동</td>\n",
       "      <td>11590605</td>\n",
       "      <td>16.94</td>\n",
       "      <td>18.58</td>\n",
       "      <td>11</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1557.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>591.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>35901.53</td>\n",
       "      <td>31130.74</td>\n",
       "      <td>24733.47</td>\n",
       "      <td>28175.61</td>\n",
       "      <td>78056.37</td>\n",
       "      <td>55454.68</td>\n",
       "      <td>52868.71</td>\n",
       "      <td>52909.51</td>\n",
       "      <td>43969.54</td>\n",
       "      <td>55797.41</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>416 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    행정동명_x    행정동_코드  대여소당_하루평균_반납건수  대여소당_하루평균_대여건수  대여소수  대규모점포개수     사업체수  \\\n",
       "0     가락1동  11710631           42.58           42.35     7      2.0   2988.0   \n",
       "1     가락2동  11710632           47.42           46.97     5      6.0   1901.0   \n",
       "2     가락본동  11710620           29.90           31.00     6      2.0   3489.0   \n",
       "3     가리봉동  11530595           27.84           28.74     1      NaN    993.0   \n",
       "4      가산동  11545510           43.42           43.35    19      7.0  16661.0   \n",
       "..     ...       ...             ...             ...   ...      ...      ...   \n",
       "411    효창동  11170580           19.81           21.13     2      NaN    418.0   \n",
       "412    후암동  11170510           13.26           14.65     2      NaN    928.0   \n",
       "413   휘경1동  11230720           41.19           41.10     4      NaN    929.0   \n",
       "414   휘경2동  11230730           54.03           53.26     7      NaN   1221.0   \n",
       "415    흑석동  11590605           16.94           18.58    11      1.0   1557.0   \n",
       "\n",
       "      병원수    음식점수  공원수  ...     남자60대   남자70대이상    여자0~9세     여자10대  \\\n",
       "0     5.0   287.0  NaN  ...  39279.78  25572.03  21462.96  26269.89   \n",
       "1    44.0   144.0  1.0  ...  36486.47  27235.70  27266.29  37623.89   \n",
       "2    44.0  1986.0  NaN  ...  47993.64  29118.88  28307.03  33042.97   \n",
       "3     8.0   326.0  NaN  ...  16501.66   9796.51   1628.15   3141.69   \n",
       "4    57.0  2419.0  NaN  ...  56961.42  25773.79  11959.29  16029.77   \n",
       "..    ...     ...  ...  ...       ...       ...       ...       ...   \n",
       "411  14.0   110.0  1.0  ...  10387.09  10073.41  10420.71  10713.03   \n",
       "412  15.0   301.0  NaN  ...  17221.31  12924.93   8083.37  11368.53   \n",
       "413  39.0   455.0  NaN  ...  17359.21  15414.41   9111.12  16476.38   \n",
       "414  28.0    59.0  NaN  ...  20807.92  20109.40  14059.11  23551.61   \n",
       "415  32.0   591.0  NaN  ...  35901.53  31130.74  24733.47  28175.61   \n",
       "\n",
       "         여자20대      여자30대     여자40대     여자50대     여자60대   여자70대이상  \n",
       "0     37340.87   63199.29  53669.20  56419.00  46770.79  33483.47  \n",
       "1     43008.96   53467.95  61379.82  59961.07  47852.46  40968.07  \n",
       "2     67452.62   81496.19  76617.26  78745.07  55112.75  39906.06  \n",
       "3     24724.62   23998.43  17637.52  21234.31  14367.82  15249.66  \n",
       "4    163080.66  141960.79  92089.70  75059.80  42315.15  28966.70  \n",
       "..         ...        ...       ...       ...       ...       ...  \n",
       "411   20631.12   24206.48  19457.64  19675.08  14148.53  19063.61  \n",
       "412   25913.49   32108.32  29707.73  24658.22  20501.38  24725.54  \n",
       "413   60679.10   27767.30  22969.57  25412.94  20482.21  25691.09  \n",
       "414   52511.26   28566.01  31472.69  33902.75  28311.26  32882.45  \n",
       "415   78056.37   55454.68  52868.71  52909.51  43969.54  55797.41  \n",
       "\n",
       "[416 rows x 39 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bike=pd.merge(bike,rc,on='행정동_코드',how='left')\n",
    "bike=pd.merge(bike,business,on='행정동명',how='left')\n",
    "bike=pd.merge(bike,hospital,on='행정동_코드',how='left')\n",
    "bike=pd.merge(bike,food,on='행정동명',how='left')\n",
    "bike=pd.merge(bike,park,on='행정동_코드',how='left')\n",
    "bike=pd.merge(bike,cafe,on='행정동_코드',how='left')\n",
    "bike=pd.merge(bike,house,on=\"행정동명\",how='left')\n",
    "bike=pd.merge(bike,bank,on='행정동명',how='left')\n",
    "bike=pd.merge(bike,car,on='행정동명',how='left')\n",
    "bike=pd.merge(bike,school,on='행정동_코드',how='left')\n",
    "bike=pd.merge(bike,bus_real,on='행정동_코드',how='left')\n",
    "bike=pd.merge(bike,subway_real,on='행정동_코드',how='left')\n",
    "bike=pd.merge(bike,people,on='행정동_코드',how='left')\n",
    "bike"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "e146e208",
   "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>남자60대</th>\n",
       "      <th>남자70대이상</th>\n",
       "      <th>여자0~9세</th>\n",
       "      <th>여자10대</th>\n",
       "      <th>여자20대</th>\n",
       "      <th>여자30대</th>\n",
       "      <th>여자40대</th>\n",
       "      <th>여자50대</th>\n",
       "      <th>여자60대</th>\n",
       "      <th>여자70대이상</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>가락1동</td>\n",
       "      <td>11710631</td>\n",
       "      <td>42.58</td>\n",
       "      <td>42.35</td>\n",
       "      <td>7</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2988.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>287.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>39279.78</td>\n",
       "      <td>25572.03</td>\n",
       "      <td>21462.96</td>\n",
       "      <td>26269.89</td>\n",
       "      <td>37340.87</td>\n",
       "      <td>63199.29</td>\n",
       "      <td>53669.20</td>\n",
       "      <td>56419.00</td>\n",
       "      <td>46770.79</td>\n",
       "      <td>33483.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>가락2동</td>\n",
       "      <td>11710632</td>\n",
       "      <td>47.42</td>\n",
       "      <td>46.97</td>\n",
       "      <td>5</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1901.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>144.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>36486.47</td>\n",
       "      <td>27235.70</td>\n",
       "      <td>27266.29</td>\n",
       "      <td>37623.89</td>\n",
       "      <td>43008.96</td>\n",
       "      <td>53467.95</td>\n",
       "      <td>61379.82</td>\n",
       "      <td>59961.07</td>\n",
       "      <td>47852.46</td>\n",
       "      <td>40968.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>가락본동</td>\n",
       "      <td>11710620</td>\n",
       "      <td>29.90</td>\n",
       "      <td>31.00</td>\n",
       "      <td>6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3489.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>1986.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>47993.64</td>\n",
       "      <td>29118.88</td>\n",
       "      <td>28307.03</td>\n",
       "      <td>33042.97</td>\n",
       "      <td>67452.62</td>\n",
       "      <td>81496.19</td>\n",
       "      <td>76617.26</td>\n",
       "      <td>78745.07</td>\n",
       "      <td>55112.75</td>\n",
       "      <td>39906.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>가리봉동</td>\n",
       "      <td>11530595</td>\n",
       "      <td>27.84</td>\n",
       "      <td>28.74</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>993.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>326.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>16501.66</td>\n",
       "      <td>9796.51</td>\n",
       "      <td>1628.15</td>\n",
       "      <td>3141.69</td>\n",
       "      <td>24724.62</td>\n",
       "      <td>23998.43</td>\n",
       "      <td>17637.52</td>\n",
       "      <td>21234.31</td>\n",
       "      <td>14367.82</td>\n",
       "      <td>15249.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>가산동</td>\n",
       "      <td>11545510</td>\n",
       "      <td>43.42</td>\n",
       "      <td>43.35</td>\n",
       "      <td>19</td>\n",
       "      <td>7.0</td>\n",
       "      <td>16661.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>2419.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>56961.42</td>\n",
       "      <td>25773.79</td>\n",
       "      <td>11959.29</td>\n",
       "      <td>16029.77</td>\n",
       "      <td>163080.66</td>\n",
       "      <td>141960.79</td>\n",
       "      <td>92089.70</td>\n",
       "      <td>75059.80</td>\n",
       "      <td>42315.15</td>\n",
       "      <td>28966.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>효창동</td>\n",
       "      <td>11170580</td>\n",
       "      <td>19.81</td>\n",
       "      <td>21.13</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>418.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>10387.09</td>\n",
       "      <td>10073.41</td>\n",
       "      <td>10420.71</td>\n",
       "      <td>10713.03</td>\n",
       "      <td>20631.12</td>\n",
       "      <td>24206.48</td>\n",
       "      <td>19457.64</td>\n",
       "      <td>19675.08</td>\n",
       "      <td>14148.53</td>\n",
       "      <td>19063.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>412</th>\n",
       "      <td>후암동</td>\n",
       "      <td>11170510</td>\n",
       "      <td>13.26</td>\n",
       "      <td>14.65</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>928.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>301.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>17221.31</td>\n",
       "      <td>12924.93</td>\n",
       "      <td>8083.37</td>\n",
       "      <td>11368.53</td>\n",
       "      <td>25913.49</td>\n",
       "      <td>32108.32</td>\n",
       "      <td>29707.73</td>\n",
       "      <td>24658.22</td>\n",
       "      <td>20501.38</td>\n",
       "      <td>24725.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413</th>\n",
       "      <td>휘경1동</td>\n",
       "      <td>11230720</td>\n",
       "      <td>41.19</td>\n",
       "      <td>41.10</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>929.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>455.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>17359.21</td>\n",
       "      <td>15414.41</td>\n",
       "      <td>9111.12</td>\n",
       "      <td>16476.38</td>\n",
       "      <td>60679.10</td>\n",
       "      <td>27767.30</td>\n",
       "      <td>22969.57</td>\n",
       "      <td>25412.94</td>\n",
       "      <td>20482.21</td>\n",
       "      <td>25691.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414</th>\n",
       "      <td>휘경2동</td>\n",
       "      <td>11230730</td>\n",
       "      <td>54.03</td>\n",
       "      <td>53.26</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1221.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>20807.92</td>\n",
       "      <td>20109.40</td>\n",
       "      <td>14059.11</td>\n",
       "      <td>23551.61</td>\n",
       "      <td>52511.26</td>\n",
       "      <td>28566.01</td>\n",
       "      <td>31472.69</td>\n",
       "      <td>33902.75</td>\n",
       "      <td>28311.26</td>\n",
       "      <td>32882.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>흑석동</td>\n",
       "      <td>11590605</td>\n",
       "      <td>16.94</td>\n",
       "      <td>18.58</td>\n",
       "      <td>11</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1557.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>591.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>35901.53</td>\n",
       "      <td>31130.74</td>\n",
       "      <td>24733.47</td>\n",
       "      <td>28175.61</td>\n",
       "      <td>78056.37</td>\n",
       "      <td>55454.68</td>\n",
       "      <td>52868.71</td>\n",
       "      <td>52909.51</td>\n",
       "      <td>43969.54</td>\n",
       "      <td>55797.41</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>416 rows × 37 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     행정동명    행정동_코드  대여소당_하루평균_반납건수  대여소당_하루평균_대여건수  대여소수  대규모점포개수     사업체수  \\\n",
       "0    가락1동  11710631           42.58           42.35     7      2.0   2988.0   \n",
       "1    가락2동  11710632           47.42           46.97     5      6.0   1901.0   \n",
       "2    가락본동  11710620           29.90           31.00     6      2.0   3489.0   \n",
       "3    가리봉동  11530595           27.84           28.74     1      NaN    993.0   \n",
       "4     가산동  11545510           43.42           43.35    19      7.0  16661.0   \n",
       "..    ...       ...             ...             ...   ...      ...      ...   \n",
       "411   효창동  11170580           19.81           21.13     2      NaN    418.0   \n",
       "412   후암동  11170510           13.26           14.65     2      NaN    928.0   \n",
       "413  휘경1동  11230720           41.19           41.10     4      NaN    929.0   \n",
       "414  휘경2동  11230730           54.03           53.26     7      NaN   1221.0   \n",
       "415   흑석동  11590605           16.94           18.58    11      1.0   1557.0   \n",
       "\n",
       "      병원수    음식점수  공원수  ...     남자60대   남자70대이상    여자0~9세     여자10대  \\\n",
       "0     5.0   287.0  NaN  ...  39279.78  25572.03  21462.96  26269.89   \n",
       "1    44.0   144.0  1.0  ...  36486.47  27235.70  27266.29  37623.89   \n",
       "2    44.0  1986.0  NaN  ...  47993.64  29118.88  28307.03  33042.97   \n",
       "3     8.0   326.0  NaN  ...  16501.66   9796.51   1628.15   3141.69   \n",
       "4    57.0  2419.0  NaN  ...  56961.42  25773.79  11959.29  16029.77   \n",
       "..    ...     ...  ...  ...       ...       ...       ...       ...   \n",
       "411  14.0   110.0  1.0  ...  10387.09  10073.41  10420.71  10713.03   \n",
       "412  15.0   301.0  NaN  ...  17221.31  12924.93   8083.37  11368.53   \n",
       "413  39.0   455.0  NaN  ...  17359.21  15414.41   9111.12  16476.38   \n",
       "414  28.0    59.0  NaN  ...  20807.92  20109.40  14059.11  23551.61   \n",
       "415  32.0   591.0  NaN  ...  35901.53  31130.74  24733.47  28175.61   \n",
       "\n",
       "         여자20대      여자30대     여자40대     여자50대     여자60대   여자70대이상  \n",
       "0     37340.87   63199.29  53669.20  56419.00  46770.79  33483.47  \n",
       "1     43008.96   53467.95  61379.82  59961.07  47852.46  40968.07  \n",
       "2     67452.62   81496.19  76617.26  78745.07  55112.75  39906.06  \n",
       "3     24724.62   23998.43  17637.52  21234.31  14367.82  15249.66  \n",
       "4    163080.66  141960.79  92089.70  75059.80  42315.15  28966.70  \n",
       "..         ...        ...       ...       ...       ...       ...  \n",
       "411   20631.12   24206.48  19457.64  19675.08  14148.53  19063.61  \n",
       "412   25913.49   32108.32  29707.73  24658.22  20501.38  24725.54  \n",
       "413   60679.10   27767.30  22969.57  25412.94  20482.21  25691.09  \n",
       "414   52511.26   28566.01  31472.69  33902.75  28311.26  32882.45  \n",
       "415   78056.37   55454.68  52868.71  52909.51  43969.54  55797.41  \n",
       "\n",
       "[416 rows x 37 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# join하면서 발생한 column 수정\n",
    "bike=bike.drop(['행정동명_y'],axis=1)\n",
    "bike=bike.drop(['행정동명'],axis=1)\n",
    "bike.rename(columns={'행정동명_x':'행정동명'},inplace=True)\n",
    "bike"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "61cae2af",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "52313.21\n"
     ]
    }
   ],
   "source": [
    "bike[['남자0~9세','남자10대','남자20대','남자30대','남자40대','남자50대','남자60대','남자70대이상']] = bike[['남자0~9세','남자10대','남자20대','남자30대','남자40대','남자50대','남자60대','남자70대이상']].astype(float)\n",
    "print(bike['남자70대이상'][1]+bike['남자0~9세'][1])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "91347c07",
   "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>여자0~9세</th>\n",
       "      <th>여자10대</th>\n",
       "      <th>여자20대</th>\n",
       "      <th>여자30대</th>\n",
       "      <th>여자40대</th>\n",
       "      <th>여자50대</th>\n",
       "      <th>여자60대</th>\n",
       "      <th>여자70대이상</th>\n",
       "      <th>남_생활인구</th>\n",
       "      <th>여_생활인구</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>가락1동</td>\n",
       "      <td>11710631</td>\n",
       "      <td>42.58</td>\n",
       "      <td>42.35</td>\n",
       "      <td>7</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2988.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>287.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>21462.96</td>\n",
       "      <td>26269.89</td>\n",
       "      <td>37340.87</td>\n",
       "      <td>63199.29</td>\n",
       "      <td>53669.20</td>\n",
       "      <td>56419.00</td>\n",
       "      <td>46770.79</td>\n",
       "      <td>33483.47</td>\n",
       "      <td>321525.67</td>\n",
       "      <td>338615.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>가락2동</td>\n",
       "      <td>11710632</td>\n",
       "      <td>47.42</td>\n",
       "      <td>46.97</td>\n",
       "      <td>5</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1901.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>144.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>27266.29</td>\n",
       "      <td>37623.89</td>\n",
       "      <td>43008.96</td>\n",
       "      <td>53467.95</td>\n",
       "      <td>61379.82</td>\n",
       "      <td>59961.07</td>\n",
       "      <td>47852.46</td>\n",
       "      <td>40968.07</td>\n",
       "      <td>314295.99</td>\n",
       "      <td>371528.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>가락본동</td>\n",
       "      <td>11710620</td>\n",
       "      <td>29.90</td>\n",
       "      <td>31.00</td>\n",
       "      <td>6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3489.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>1986.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>28307.03</td>\n",
       "      <td>33042.97</td>\n",
       "      <td>67452.62</td>\n",
       "      <td>81496.19</td>\n",
       "      <td>76617.26</td>\n",
       "      <td>78745.07</td>\n",
       "      <td>55112.75</td>\n",
       "      <td>39906.06</td>\n",
       "      <td>449157.07</td>\n",
       "      <td>460679.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>가리봉동</td>\n",
       "      <td>11530595</td>\n",
       "      <td>27.84</td>\n",
       "      <td>28.74</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>993.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>326.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1628.15</td>\n",
       "      <td>3141.69</td>\n",
       "      <td>24724.62</td>\n",
       "      <td>23998.43</td>\n",
       "      <td>17637.52</td>\n",
       "      <td>21234.31</td>\n",
       "      <td>14367.82</td>\n",
       "      <td>15249.66</td>\n",
       "      <td>152135.15</td>\n",
       "      <td>121982.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>가산동</td>\n",
       "      <td>11545510</td>\n",
       "      <td>43.42</td>\n",
       "      <td>43.35</td>\n",
       "      <td>19</td>\n",
       "      <td>7.0</td>\n",
       "      <td>16661.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>2419.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>11959.29</td>\n",
       "      <td>16029.77</td>\n",
       "      <td>163080.66</td>\n",
       "      <td>141960.79</td>\n",
       "      <td>92089.70</td>\n",
       "      <td>75059.80</td>\n",
       "      <td>42315.15</td>\n",
       "      <td>28966.70</td>\n",
       "      <td>814951.84</td>\n",
       "      <td>571461.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>효창동</td>\n",
       "      <td>11170580</td>\n",
       "      <td>19.81</td>\n",
       "      <td>21.13</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>418.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>10420.71</td>\n",
       "      <td>10713.03</td>\n",
       "      <td>20631.12</td>\n",
       "      <td>24206.48</td>\n",
       "      <td>19457.64</td>\n",
       "      <td>19675.08</td>\n",
       "      <td>14148.53</td>\n",
       "      <td>19063.61</td>\n",
       "      <td>106881.68</td>\n",
       "      <td>138316.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>412</th>\n",
       "      <td>후암동</td>\n",
       "      <td>11170510</td>\n",
       "      <td>13.26</td>\n",
       "      <td>14.65</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>928.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>301.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8083.37</td>\n",
       "      <td>11368.53</td>\n",
       "      <td>25913.49</td>\n",
       "      <td>32108.32</td>\n",
       "      <td>29707.73</td>\n",
       "      <td>24658.22</td>\n",
       "      <td>20501.38</td>\n",
       "      <td>24725.54</td>\n",
       "      <td>162641.75</td>\n",
       "      <td>177066.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413</th>\n",
       "      <td>휘경1동</td>\n",
       "      <td>11230720</td>\n",
       "      <td>41.19</td>\n",
       "      <td>41.10</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>929.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>455.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>9111.12</td>\n",
       "      <td>16476.38</td>\n",
       "      <td>60679.10</td>\n",
       "      <td>27767.30</td>\n",
       "      <td>22969.57</td>\n",
       "      <td>25412.94</td>\n",
       "      <td>20482.21</td>\n",
       "      <td>25691.09</td>\n",
       "      <td>174686.46</td>\n",
       "      <td>208589.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414</th>\n",
       "      <td>휘경2동</td>\n",
       "      <td>11230730</td>\n",
       "      <td>54.03</td>\n",
       "      <td>53.26</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1221.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>14059.11</td>\n",
       "      <td>23551.61</td>\n",
       "      <td>52511.26</td>\n",
       "      <td>28566.01</td>\n",
       "      <td>31472.69</td>\n",
       "      <td>33902.75</td>\n",
       "      <td>28311.26</td>\n",
       "      <td>32882.45</td>\n",
       "      <td>218512.85</td>\n",
       "      <td>245257.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>흑석동</td>\n",
       "      <td>11590605</td>\n",
       "      <td>16.94</td>\n",
       "      <td>18.58</td>\n",
       "      <td>11</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1557.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>591.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>24733.47</td>\n",
       "      <td>28175.61</td>\n",
       "      <td>78056.37</td>\n",
       "      <td>55454.68</td>\n",
       "      <td>52868.71</td>\n",
       "      <td>52909.51</td>\n",
       "      <td>43969.54</td>\n",
       "      <td>55797.41</td>\n",
       "      <td>340907.45</td>\n",
       "      <td>391965.30</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>416 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     행정동명    행정동_코드  대여소당_하루평균_반납건수  대여소당_하루평균_대여건수  대여소수  대규모점포개수     사업체수  \\\n",
       "0    가락1동  11710631           42.58           42.35     7      2.0   2988.0   \n",
       "1    가락2동  11710632           47.42           46.97     5      6.0   1901.0   \n",
       "2    가락본동  11710620           29.90           31.00     6      2.0   3489.0   \n",
       "3    가리봉동  11530595           27.84           28.74     1      NaN    993.0   \n",
       "4     가산동  11545510           43.42           43.35    19      7.0  16661.0   \n",
       "..    ...       ...             ...             ...   ...      ...      ...   \n",
       "411   효창동  11170580           19.81           21.13     2      NaN    418.0   \n",
       "412   후암동  11170510           13.26           14.65     2      NaN    928.0   \n",
       "413  휘경1동  11230720           41.19           41.10     4      NaN    929.0   \n",
       "414  휘경2동  11230730           54.03           53.26     7      NaN   1221.0   \n",
       "415   흑석동  11590605           16.94           18.58    11      1.0   1557.0   \n",
       "\n",
       "      병원수    음식점수  공원수  ...    여자0~9세     여자10대      여자20대      여자30대  \\\n",
       "0     5.0   287.0  NaN  ...  21462.96  26269.89   37340.87   63199.29   \n",
       "1    44.0   144.0  1.0  ...  27266.29  37623.89   43008.96   53467.95   \n",
       "2    44.0  1986.0  NaN  ...  28307.03  33042.97   67452.62   81496.19   \n",
       "3     8.0   326.0  NaN  ...   1628.15   3141.69   24724.62   23998.43   \n",
       "4    57.0  2419.0  NaN  ...  11959.29  16029.77  163080.66  141960.79   \n",
       "..    ...     ...  ...  ...       ...       ...        ...        ...   \n",
       "411  14.0   110.0  1.0  ...  10420.71  10713.03   20631.12   24206.48   \n",
       "412  15.0   301.0  NaN  ...   8083.37  11368.53   25913.49   32108.32   \n",
       "413  39.0   455.0  NaN  ...   9111.12  16476.38   60679.10   27767.30   \n",
       "414  28.0    59.0  NaN  ...  14059.11  23551.61   52511.26   28566.01   \n",
       "415  32.0   591.0  NaN  ...  24733.47  28175.61   78056.37   55454.68   \n",
       "\n",
       "        여자40대     여자50대     여자60대   여자70대이상     남_생활인구     여_생활인구  \n",
       "0    53669.20  56419.00  46770.79  33483.47  321525.67  338615.47  \n",
       "1    61379.82  59961.07  47852.46  40968.07  314295.99  371528.51  \n",
       "2    76617.26  78745.07  55112.75  39906.06  449157.07  460679.95  \n",
       "3    17637.52  21234.31  14367.82  15249.66  152135.15  121982.20  \n",
       "4    92089.70  75059.80  42315.15  28966.70  814951.84  571461.86  \n",
       "..        ...       ...       ...       ...        ...        ...  \n",
       "411  19457.64  19675.08  14148.53  19063.61  106881.68  138316.20  \n",
       "412  29707.73  24658.22  20501.38  24725.54  162641.75  177066.58  \n",
       "413  22969.57  25412.94  20482.21  25691.09  174686.46  208589.71  \n",
       "414  31472.69  33902.75  28311.26  32882.45  218512.85  245257.14  \n",
       "415  52868.71  52909.51  43969.54  55797.41  340907.45  391965.30  \n",
       "\n",
       "[416 rows x 39 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#남/여 전체 생활인구 column 추가하기\n",
    "bike['남_생활인구']=bike[['남자0~9세','남자10대','남자20대','남자30대','남자40대','남자50대','남자60대','남자70대이상']].sum(axis=1)\n",
    "bike['여_생활인구']=bike[['여자0~9세','여자10대','여자20대','여자30대','여자40대','여자50대','여자60대','여자70대이상']].sum(axis=1)\n",
    "bike"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "436b726f",
   "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>여자0~9세</th>\n",
       "      <th>여자10대</th>\n",
       "      <th>여자20대</th>\n",
       "      <th>여자30대</th>\n",
       "      <th>여자40대</th>\n",
       "      <th>여자50대</th>\n",
       "      <th>여자60대</th>\n",
       "      <th>여자70대이상</th>\n",
       "      <th>남_생활인구</th>\n",
       "      <th>여_생활인구</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>가락1동</td>\n",
       "      <td>11710631</td>\n",
       "      <td>42.58</td>\n",
       "      <td>42.35</td>\n",
       "      <td>7</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2988.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>287.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>21462.96</td>\n",
       "      <td>26269.89</td>\n",
       "      <td>37340.87</td>\n",
       "      <td>63199.29</td>\n",
       "      <td>53669.20</td>\n",
       "      <td>56419.00</td>\n",
       "      <td>46770.79</td>\n",
       "      <td>33483.47</td>\n",
       "      <td>321525.67</td>\n",
       "      <td>338615.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>가락2동</td>\n",
       "      <td>11710632</td>\n",
       "      <td>47.42</td>\n",
       "      <td>46.97</td>\n",
       "      <td>5</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1901.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>144.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>27266.29</td>\n",
       "      <td>37623.89</td>\n",
       "      <td>43008.96</td>\n",
       "      <td>53467.95</td>\n",
       "      <td>61379.82</td>\n",
       "      <td>59961.07</td>\n",
       "      <td>47852.46</td>\n",
       "      <td>40968.07</td>\n",
       "      <td>314295.99</td>\n",
       "      <td>371528.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>가락본동</td>\n",
       "      <td>11710620</td>\n",
       "      <td>29.90</td>\n",
       "      <td>31.00</td>\n",
       "      <td>6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3489.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>1986.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>28307.03</td>\n",
       "      <td>33042.97</td>\n",
       "      <td>67452.62</td>\n",
       "      <td>81496.19</td>\n",
       "      <td>76617.26</td>\n",
       "      <td>78745.07</td>\n",
       "      <td>55112.75</td>\n",
       "      <td>39906.06</td>\n",
       "      <td>449157.07</td>\n",
       "      <td>460679.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>가리봉동</td>\n",
       "      <td>11530595</td>\n",
       "      <td>27.84</td>\n",
       "      <td>28.74</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>993.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>326.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1628.15</td>\n",
       "      <td>3141.69</td>\n",
       "      <td>24724.62</td>\n",
       "      <td>23998.43</td>\n",
       "      <td>17637.52</td>\n",
       "      <td>21234.31</td>\n",
       "      <td>14367.82</td>\n",
       "      <td>15249.66</td>\n",
       "      <td>152135.15</td>\n",
       "      <td>121982.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>가산동</td>\n",
       "      <td>11545510</td>\n",
       "      <td>43.42</td>\n",
       "      <td>43.35</td>\n",
       "      <td>19</td>\n",
       "      <td>7.0</td>\n",
       "      <td>16661.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>2419.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>11959.29</td>\n",
       "      <td>16029.77</td>\n",
       "      <td>163080.66</td>\n",
       "      <td>141960.79</td>\n",
       "      <td>92089.70</td>\n",
       "      <td>75059.80</td>\n",
       "      <td>42315.15</td>\n",
       "      <td>28966.70</td>\n",
       "      <td>814951.84</td>\n",
       "      <td>571461.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>효창동</td>\n",
       "      <td>11170580</td>\n",
       "      <td>19.81</td>\n",
       "      <td>21.13</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>10420.71</td>\n",
       "      <td>10713.03</td>\n",
       "      <td>20631.12</td>\n",
       "      <td>24206.48</td>\n",
       "      <td>19457.64</td>\n",
       "      <td>19675.08</td>\n",
       "      <td>14148.53</td>\n",
       "      <td>19063.61</td>\n",
       "      <td>106881.68</td>\n",
       "      <td>138316.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>412</th>\n",
       "      <td>후암동</td>\n",
       "      <td>11170510</td>\n",
       "      <td>13.26</td>\n",
       "      <td>14.65</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>928.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>301.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8083.37</td>\n",
       "      <td>11368.53</td>\n",
       "      <td>25913.49</td>\n",
       "      <td>32108.32</td>\n",
       "      <td>29707.73</td>\n",
       "      <td>24658.22</td>\n",
       "      <td>20501.38</td>\n",
       "      <td>24725.54</td>\n",
       "      <td>162641.75</td>\n",
       "      <td>177066.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413</th>\n",
       "      <td>휘경1동</td>\n",
       "      <td>11230720</td>\n",
       "      <td>41.19</td>\n",
       "      <td>41.10</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>929.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>455.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9111.12</td>\n",
       "      <td>16476.38</td>\n",
       "      <td>60679.10</td>\n",
       "      <td>27767.30</td>\n",
       "      <td>22969.57</td>\n",
       "      <td>25412.94</td>\n",
       "      <td>20482.21</td>\n",
       "      <td>25691.09</td>\n",
       "      <td>174686.46</td>\n",
       "      <td>208589.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414</th>\n",
       "      <td>휘경2동</td>\n",
       "      <td>11230730</td>\n",
       "      <td>54.03</td>\n",
       "      <td>53.26</td>\n",
       "      <td>7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1221.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>14059.11</td>\n",
       "      <td>23551.61</td>\n",
       "      <td>52511.26</td>\n",
       "      <td>28566.01</td>\n",
       "      <td>31472.69</td>\n",
       "      <td>33902.75</td>\n",
       "      <td>28311.26</td>\n",
       "      <td>32882.45</td>\n",
       "      <td>218512.85</td>\n",
       "      <td>245257.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>흑석동</td>\n",
       "      <td>11590605</td>\n",
       "      <td>16.94</td>\n",
       "      <td>18.58</td>\n",
       "      <td>11</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1557.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>591.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>24733.47</td>\n",
       "      <td>28175.61</td>\n",
       "      <td>78056.37</td>\n",
       "      <td>55454.68</td>\n",
       "      <td>52868.71</td>\n",
       "      <td>52909.51</td>\n",
       "      <td>43969.54</td>\n",
       "      <td>55797.41</td>\n",
       "      <td>340907.45</td>\n",
       "      <td>391965.30</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>416 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     행정동명    행정동_코드  대여소당_하루평균_반납건수  대여소당_하루평균_대여건수  대여소수  대규모점포개수     사업체수  \\\n",
       "0    가락1동  11710631           42.58           42.35     7      2.0   2988.0   \n",
       "1    가락2동  11710632           47.42           46.97     5      6.0   1901.0   \n",
       "2    가락본동  11710620           29.90           31.00     6      2.0   3489.0   \n",
       "3    가리봉동  11530595           27.84           28.74     1      0.0    993.0   \n",
       "4     가산동  11545510           43.42           43.35    19      7.0  16661.0   \n",
       "..    ...       ...             ...             ...   ...      ...      ...   \n",
       "411   효창동  11170580           19.81           21.13     2      0.0    418.0   \n",
       "412   후암동  11170510           13.26           14.65     2      0.0    928.0   \n",
       "413  휘경1동  11230720           41.19           41.10     4      0.0    929.0   \n",
       "414  휘경2동  11230730           54.03           53.26     7      0.0   1221.0   \n",
       "415   흑석동  11590605           16.94           18.58    11      1.0   1557.0   \n",
       "\n",
       "      병원수    음식점수  공원수  ...    여자0~9세     여자10대      여자20대      여자30대  \\\n",
       "0     5.0   287.0  0.0  ...  21462.96  26269.89   37340.87   63199.29   \n",
       "1    44.0   144.0  1.0  ...  27266.29  37623.89   43008.96   53467.95   \n",
       "2    44.0  1986.0  0.0  ...  28307.03  33042.97   67452.62   81496.19   \n",
       "3     8.0   326.0  0.0  ...   1628.15   3141.69   24724.62   23998.43   \n",
       "4    57.0  2419.0  0.0  ...  11959.29  16029.77  163080.66  141960.79   \n",
       "..    ...     ...  ...  ...       ...       ...        ...        ...   \n",
       "411  14.0   110.0  1.0  ...  10420.71  10713.03   20631.12   24206.48   \n",
       "412  15.0   301.0  0.0  ...   8083.37  11368.53   25913.49   32108.32   \n",
       "413  39.0   455.0  0.0  ...   9111.12  16476.38   60679.10   27767.30   \n",
       "414  28.0    59.0  0.0  ...  14059.11  23551.61   52511.26   28566.01   \n",
       "415  32.0   591.0  0.0  ...  24733.47  28175.61   78056.37   55454.68   \n",
       "\n",
       "        여자40대     여자50대     여자60대   여자70대이상     남_생활인구     여_생활인구  \n",
       "0    53669.20  56419.00  46770.79  33483.47  321525.67  338615.47  \n",
       "1    61379.82  59961.07  47852.46  40968.07  314295.99  371528.51  \n",
       "2    76617.26  78745.07  55112.75  39906.06  449157.07  460679.95  \n",
       "3    17637.52  21234.31  14367.82  15249.66  152135.15  121982.20  \n",
       "4    92089.70  75059.80  42315.15  28966.70  814951.84  571461.86  \n",
       "..        ...       ...       ...       ...        ...        ...  \n",
       "411  19457.64  19675.08  14148.53  19063.61  106881.68  138316.20  \n",
       "412  29707.73  24658.22  20501.38  24725.54  162641.75  177066.58  \n",
       "413  22969.57  25412.94  20482.21  25691.09  174686.46  208589.71  \n",
       "414  31472.69  33902.75  28311.26  32882.45  218512.85  245257.14  \n",
       "415  52868.71  52909.51  43969.54  55797.41  340907.45  391965.30  \n",
       "\n",
       "[416 rows x 39 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#결측치는 0으로 바꿔주기\n",
    "bike=bike.fillna(0)\n",
    "bike"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "1f05187d",
   "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>Dong_name</th>\n",
       "      <th>code_dong</th>\n",
       "      <th>return_day</th>\n",
       "      <th>rent_day</th>\n",
       "      <th>rental_stop</th>\n",
       "      <th>large_store</th>\n",
       "      <th>company</th>\n",
       "      <th>hospital</th>\n",
       "      <th>restaurant</th>\n",
       "      <th>park</th>\n",
       "      <th>...</th>\n",
       "      <th>W_child</th>\n",
       "      <th>W_teenager</th>\n",
       "      <th>W_20</th>\n",
       "      <th>W_30</th>\n",
       "      <th>W_40</th>\n",
       "      <th>W_50</th>\n",
       "      <th>W_60</th>\n",
       "      <th>W_over70</th>\n",
       "      <th>M_sum</th>\n",
       "      <th>W_sum</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>가락1동</td>\n",
       "      <td>11710631</td>\n",
       "      <td>42.58</td>\n",
       "      <td>42.35</td>\n",
       "      <td>7</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2988.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>287.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>21462.96</td>\n",
       "      <td>26269.89</td>\n",
       "      <td>37340.87</td>\n",
       "      <td>63199.29</td>\n",
       "      <td>53669.20</td>\n",
       "      <td>56419.00</td>\n",
       "      <td>46770.79</td>\n",
       "      <td>33483.47</td>\n",
       "      <td>321525.67</td>\n",
       "      <td>338615.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>가락2동</td>\n",
       "      <td>11710632</td>\n",
       "      <td>47.42</td>\n",
       "      <td>46.97</td>\n",
       "      <td>5</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1901.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>144.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>27266.29</td>\n",
       "      <td>37623.89</td>\n",
       "      <td>43008.96</td>\n",
       "      <td>53467.95</td>\n",
       "      <td>61379.82</td>\n",
       "      <td>59961.07</td>\n",
       "      <td>47852.46</td>\n",
       "      <td>40968.07</td>\n",
       "      <td>314295.99</td>\n",
       "      <td>371528.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>가락본동</td>\n",
       "      <td>11710620</td>\n",
       "      <td>29.90</td>\n",
       "      <td>31.00</td>\n",
       "      <td>6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3489.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>1986.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>28307.03</td>\n",
       "      <td>33042.97</td>\n",
       "      <td>67452.62</td>\n",
       "      <td>81496.19</td>\n",
       "      <td>76617.26</td>\n",
       "      <td>78745.07</td>\n",
       "      <td>55112.75</td>\n",
       "      <td>39906.06</td>\n",
       "      <td>449157.07</td>\n",
       "      <td>460679.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>가리봉동</td>\n",
       "      <td>11530595</td>\n",
       "      <td>27.84</td>\n",
       "      <td>28.74</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>993.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>326.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1628.15</td>\n",
       "      <td>3141.69</td>\n",
       "      <td>24724.62</td>\n",
       "      <td>23998.43</td>\n",
       "      <td>17637.52</td>\n",
       "      <td>21234.31</td>\n",
       "      <td>14367.82</td>\n",
       "      <td>15249.66</td>\n",
       "      <td>152135.15</td>\n",
       "      <td>121982.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>가산동</td>\n",
       "      <td>11545510</td>\n",
       "      <td>43.42</td>\n",
       "      <td>43.35</td>\n",
       "      <td>19</td>\n",
       "      <td>7.0</td>\n",
       "      <td>16661.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>2419.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>11959.29</td>\n",
       "      <td>16029.77</td>\n",
       "      <td>163080.66</td>\n",
       "      <td>141960.79</td>\n",
       "      <td>92089.70</td>\n",
       "      <td>75059.80</td>\n",
       "      <td>42315.15</td>\n",
       "      <td>28966.70</td>\n",
       "      <td>814951.84</td>\n",
       "      <td>571461.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>효창동</td>\n",
       "      <td>11170580</td>\n",
       "      <td>19.81</td>\n",
       "      <td>21.13</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>10420.71</td>\n",
       "      <td>10713.03</td>\n",
       "      <td>20631.12</td>\n",
       "      <td>24206.48</td>\n",
       "      <td>19457.64</td>\n",
       "      <td>19675.08</td>\n",
       "      <td>14148.53</td>\n",
       "      <td>19063.61</td>\n",
       "      <td>106881.68</td>\n",
       "      <td>138316.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>412</th>\n",
       "      <td>후암동</td>\n",
       "      <td>11170510</td>\n",
       "      <td>13.26</td>\n",
       "      <td>14.65</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>928.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>301.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8083.37</td>\n",
       "      <td>11368.53</td>\n",
       "      <td>25913.49</td>\n",
       "      <td>32108.32</td>\n",
       "      <td>29707.73</td>\n",
       "      <td>24658.22</td>\n",
       "      <td>20501.38</td>\n",
       "      <td>24725.54</td>\n",
       "      <td>162641.75</td>\n",
       "      <td>177066.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413</th>\n",
       "      <td>휘경1동</td>\n",
       "      <td>11230720</td>\n",
       "      <td>41.19</td>\n",
       "      <td>41.10</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>929.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>455.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9111.12</td>\n",
       "      <td>16476.38</td>\n",
       "      <td>60679.10</td>\n",
       "      <td>27767.30</td>\n",
       "      <td>22969.57</td>\n",
       "      <td>25412.94</td>\n",
       "      <td>20482.21</td>\n",
       "      <td>25691.09</td>\n",
       "      <td>174686.46</td>\n",
       "      <td>208589.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414</th>\n",
       "      <td>휘경2동</td>\n",
       "      <td>11230730</td>\n",
       "      <td>54.03</td>\n",
       "      <td>53.26</td>\n",
       "      <td>7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1221.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>14059.11</td>\n",
       "      <td>23551.61</td>\n",
       "      <td>52511.26</td>\n",
       "      <td>28566.01</td>\n",
       "      <td>31472.69</td>\n",
       "      <td>33902.75</td>\n",
       "      <td>28311.26</td>\n",
       "      <td>32882.45</td>\n",
       "      <td>218512.85</td>\n",
       "      <td>245257.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>흑석동</td>\n",
       "      <td>11590605</td>\n",
       "      <td>16.94</td>\n",
       "      <td>18.58</td>\n",
       "      <td>11</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1557.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>591.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>24733.47</td>\n",
       "      <td>28175.61</td>\n",
       "      <td>78056.37</td>\n",
       "      <td>55454.68</td>\n",
       "      <td>52868.71</td>\n",
       "      <td>52909.51</td>\n",
       "      <td>43969.54</td>\n",
       "      <td>55797.41</td>\n",
       "      <td>340907.45</td>\n",
       "      <td>391965.30</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>416 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Dong_name  code_dong  return_day  rent_day  rental_stop  large_store  \\\n",
       "0        가락1동   11710631       42.58     42.35            7          2.0   \n",
       "1        가락2동   11710632       47.42     46.97            5          6.0   \n",
       "2        가락본동   11710620       29.90     31.00            6          2.0   \n",
       "3        가리봉동   11530595       27.84     28.74            1          0.0   \n",
       "4         가산동   11545510       43.42     43.35           19          7.0   \n",
       "..        ...        ...         ...       ...          ...          ...   \n",
       "411       효창동   11170580       19.81     21.13            2          0.0   \n",
       "412       후암동   11170510       13.26     14.65            2          0.0   \n",
       "413      휘경1동   11230720       41.19     41.10            4          0.0   \n",
       "414      휘경2동   11230730       54.03     53.26            7          0.0   \n",
       "415       흑석동   11590605       16.94     18.58           11          1.0   \n",
       "\n",
       "     company  hospital  restaurant  park  ...   W_child  W_teenager  \\\n",
       "0     2988.0       5.0       287.0   0.0  ...  21462.96    26269.89   \n",
       "1     1901.0      44.0       144.0   1.0  ...  27266.29    37623.89   \n",
       "2     3489.0      44.0      1986.0   0.0  ...  28307.03    33042.97   \n",
       "3      993.0       8.0       326.0   0.0  ...   1628.15     3141.69   \n",
       "4    16661.0      57.0      2419.0   0.0  ...  11959.29    16029.77   \n",
       "..       ...       ...         ...   ...  ...       ...         ...   \n",
       "411    418.0      14.0       110.0   1.0  ...  10420.71    10713.03   \n",
       "412    928.0      15.0       301.0   0.0  ...   8083.37    11368.53   \n",
       "413    929.0      39.0       455.0   0.0  ...   9111.12    16476.38   \n",
       "414   1221.0      28.0        59.0   0.0  ...  14059.11    23551.61   \n",
       "415   1557.0      32.0       591.0   0.0  ...  24733.47    28175.61   \n",
       "\n",
       "          W_20       W_30      W_40      W_50      W_60  W_over70      M_sum  \\\n",
       "0     37340.87   63199.29  53669.20  56419.00  46770.79  33483.47  321525.67   \n",
       "1     43008.96   53467.95  61379.82  59961.07  47852.46  40968.07  314295.99   \n",
       "2     67452.62   81496.19  76617.26  78745.07  55112.75  39906.06  449157.07   \n",
       "3     24724.62   23998.43  17637.52  21234.31  14367.82  15249.66  152135.15   \n",
       "4    163080.66  141960.79  92089.70  75059.80  42315.15  28966.70  814951.84   \n",
       "..         ...        ...       ...       ...       ...       ...        ...   \n",
       "411   20631.12   24206.48  19457.64  19675.08  14148.53  19063.61  106881.68   \n",
       "412   25913.49   32108.32  29707.73  24658.22  20501.38  24725.54  162641.75   \n",
       "413   60679.10   27767.30  22969.57  25412.94  20482.21  25691.09  174686.46   \n",
       "414   52511.26   28566.01  31472.69  33902.75  28311.26  32882.45  218512.85   \n",
       "415   78056.37   55454.68  52868.71  52909.51  43969.54  55797.41  340907.45   \n",
       "\n",
       "         W_sum  \n",
       "0    338615.47  \n",
       "1    371528.51  \n",
       "2    460679.95  \n",
       "3    121982.20  \n",
       "4    571461.86  \n",
       "..         ...  \n",
       "411  138316.20  \n",
       "412  177066.58  \n",
       "413  208589.71  \n",
       "414  245257.14  \n",
       "415  391965.30  \n",
       "\n",
       "[416 rows x 39 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#colunms 이름 영어로 바꾸기\n",
    "bike.rename(columns = {'행정동명':'Dong_name','행정동_코드':'code_dong','대여소당_하루평균_반납건수':'return_day',\n",
    "                            '대여소당_하루평균_대여건수':'rent_day','대여소수':'rental_stop','대규모점포개수':'large_store',\n",
    "                           '사업체수':'company','병원수':'hospital','음식점수':'restaurant',\n",
    "                           '공원수':'park','카페수':'cafe','주거단지수':'house','자동차수':'car',\n",
    "                           '은행 수':'bank','남자0~9세':'M_child','남자10대':'M_teenager','남자20대':'M_20',\n",
    "                           '남자30대':'M_30','남자40대':'M_40','남자50대':'M_50','남자60대':'M_60','남자70대이상':'M_over70',\n",
    "                           '여자0~9세':'W_child','여자10대':'W_teenager','여자20대':'W_20',\n",
    "                           '여자30대':'W_30','여자40대':'W_40','여자50대':'W_50','여자60대':'W_60','여자70대이상':'W_over70',\n",
    "                           '남_생활인구':'M_sum','여_생활인구':'W_sum','정류장수':'bus_stop',\n",
    "                           '정류장별_승차승객수':'bus_geton_people','정류장별_하차승객수':'bus_getoff_people',\n",
    "                           '역사수':'subway_station','역사별_승차승객수':'subway_geton_people','역사별_하차승객수':'subway_getoff_people',\n",
    "                           '학교수':'school'},inplace=True)\n",
    "bike"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "6d8560a3",
   "metadata": {},
   "outputs": [],
   "source": [
    "data=pd.DataFrame(bike)\n",
    "data.to_csv(\"최종데이터.csv\",mode=\"w\",encoding='euc-kr',index=False)"
   ]
  }
 ],
 "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"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}