air_pollution_analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('./data/대기오염(구별).csv', encoding='utf-8')"
   ]
  },
  {
   "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>구분별(1)</th>\n",
       "      <th>2015</th>\n",
       "      <th>2015.1</th>\n",
       "      <th>2015.2</th>\n",
       "      <th>2015.3</th>\n",
       "      <th>2015.4</th>\n",
       "      <th>2015.5</th>\n",
       "      <th>2016</th>\n",
       "      <th>2016.1</th>\n",
       "      <th>2016.2</th>\n",
       "      <th>...</th>\n",
       "      <th>2021.2</th>\n",
       "      <th>2021.3</th>\n",
       "      <th>2021.4</th>\n",
       "      <th>2021.5</th>\n",
       "      <th>2022</th>\n",
       "      <th>2022.1</th>\n",
       "      <th>2022.2</th>\n",
       "      <th>2022.3</th>\n",
       "      <th>2022.4</th>\n",
       "      <th>2022.5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>구분별(1)</td>\n",
       "      <td>아황산가스(SO2) (ppm)</td>\n",
       "      <td>일산화탄소(CO) (ppm)</td>\n",
       "      <td>이산화질소(NO2) (ppm)</td>\n",
       "      <td>미세먼지(PM-10) (㎍/㎥)</td>\n",
       "      <td>초미세먼지(PM-2.5) (㎍/㎥)</td>\n",
       "      <td>오존(O3) (ppm)</td>\n",
       "      <td>아황산가스(SO2) (ppm)</td>\n",
       "      <td>일산화탄소(CO) (ppm)</td>\n",
       "      <td>이산화질소(NO2) (ppm)</td>\n",
       "      <td>...</td>\n",
       "      <td>이산화질소(NO2) (ppm)</td>\n",
       "      <td>미세먼지(PM-10) (㎍/㎥)</td>\n",
       "      <td>초미세먼지(PM-2.5) (㎍/㎥)</td>\n",
       "      <td>오존(O3) (ppm)</td>\n",
       "      <td>아황산가스(SO2) (ppm)</td>\n",
       "      <td>일산화탄소(CO) (ppm)</td>\n",
       "      <td>이산화질소(NO2) (ppm)</td>\n",
       "      <td>미세먼지(PM-10) (㎍/㎥)</td>\n",
       "      <td>초미세먼지(PM-2.5) (㎍/㎥)</td>\n",
       "      <td>오존(O3) (ppm)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>국가환경기준</td>\n",
       "      <td>0.02ppm/년</td>\n",
       "      <td>9ppm/8시간</td>\n",
       "      <td>0.03ppm/년</td>\n",
       "      <td>50㎍/㎥/년</td>\n",
       "      <td>25㎍/㎥/년</td>\n",
       "      <td>0.06ppm/8시간</td>\n",
       "      <td>0.02ppm/년</td>\n",
       "      <td>9ppm/8시간</td>\n",
       "      <td>0.03ppm/년</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>2</th>\n",
       "      <td>서울시환경기준</td>\n",
       "      <td>0.01ppm/년</td>\n",
       "      <td>9ppm/8시간</td>\n",
       "      <td>0.03ppm/년</td>\n",
       "      <td>50㎍/㎥/년</td>\n",
       "      <td>25㎍/㎥/년</td>\n",
       "      <td>0.06ppm/8시간</td>\n",
       "      <td>0.01ppm/년</td>\n",
       "      <td>9ppm/8시간</td>\n",
       "      <td>0.03ppm/년</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>3</th>\n",
       "      <td>평 균</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.032</td>\n",
       "      <td>45</td>\n",
       "      <td>23</td>\n",
       "      <td>0.022</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.031</td>\n",
       "      <td>...</td>\n",
       "      <td>0.024</td>\n",
       "      <td>38</td>\n",
       "      <td>20</td>\n",
       "      <td>0.028</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.021</td>\n",
       "      <td>33</td>\n",
       "      <td>18</td>\n",
       "      <td>0.029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>종로구</td>\n",
       "      <td>0.006</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.033</td>\n",
       "      <td>50</td>\n",
       "      <td>25</td>\n",
       "      <td>0.022</td>\n",
       "      <td>0.004</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.030</td>\n",
       "      <td>...</td>\n",
       "      <td>0.023</td>\n",
       "      <td>39</td>\n",
       "      <td>20</td>\n",
       "      <td>0.029</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.021</td>\n",
       "      <td>32</td>\n",
       "      <td>19</td>\n",
       "      <td>0.031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>중구</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.036</td>\n",
       "      <td>44</td>\n",
       "      <td>23</td>\n",
       "      <td>0.023</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.036</td>\n",
       "      <td>...</td>\n",
       "      <td>0.027</td>\n",
       "      <td>42</td>\n",
       "      <td>21</td>\n",
       "      <td>0.026</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.024</td>\n",
       "      <td>30</td>\n",
       "      <td>19</td>\n",
       "      <td>0.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>용산구</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.033</td>\n",
       "      <td>42</td>\n",
       "      <td>24</td>\n",
       "      <td>0.021</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.032</td>\n",
       "      <td>...</td>\n",
       "      <td>0.022</td>\n",
       "      <td>37</td>\n",
       "      <td>19</td>\n",
       "      <td>0.023</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.021</td>\n",
       "      <td>33</td>\n",
       "      <td>19</td>\n",
       "      <td>0.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>성동구</td>\n",
       "      <td>0.004</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.033</td>\n",
       "      <td>46</td>\n",
       "      <td>23</td>\n",
       "      <td>0.021</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.034</td>\n",
       "      <td>...</td>\n",
       "      <td>0.027</td>\n",
       "      <td>38</td>\n",
       "      <td>19</td>\n",
       "      <td>0.030</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.021</td>\n",
       "      <td>35</td>\n",
       "      <td>16</td>\n",
       "      <td>0.028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>광진구</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.031</td>\n",
       "      <td>45</td>\n",
       "      <td>22</td>\n",
       "      <td>0.021</td>\n",
       "      <td>0.004</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.032</td>\n",
       "      <td>...</td>\n",
       "      <td>0.020</td>\n",
       "      <td>37</td>\n",
       "      <td>19</td>\n",
       "      <td>0.027</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.019</td>\n",
       "      <td>31</td>\n",
       "      <td>18</td>\n",
       "      <td>0.027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>동대문구</td>\n",
       "      <td>0.006</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.035</td>\n",
       "      <td>44</td>\n",
       "      <td>23</td>\n",
       "      <td>0.023</td>\n",
       "      <td>0.006</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.033</td>\n",
       "      <td>...</td>\n",
       "      <td>0.025</td>\n",
       "      <td>38</td>\n",
       "      <td>20</td>\n",
       "      <td>0.029</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.022</td>\n",
       "      <td>34</td>\n",
       "      <td>19</td>\n",
       "      <td>0.032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>중랑구</td>\n",
       "      <td>0.006</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.034</td>\n",
       "      <td>45</td>\n",
       "      <td>23</td>\n",
       "      <td>0.023</td>\n",
       "      <td>0.006</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.032</td>\n",
       "      <td>...</td>\n",
       "      <td>0.023</td>\n",
       "      <td>38</td>\n",
       "      <td>18</td>\n",
       "      <td>0.028</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.021</td>\n",
       "      <td>33</td>\n",
       "      <td>18</td>\n",
       "      <td>0.031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>성북구</td>\n",
       "      <td>0.006</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.032</td>\n",
       "      <td>42</td>\n",
       "      <td>21</td>\n",
       "      <td>0.022</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.034</td>\n",
       "      <td>...</td>\n",
       "      <td>0.026</td>\n",
       "      <td>39</td>\n",
       "      <td>18</td>\n",
       "      <td>0.027</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.023</td>\n",
       "      <td>33</td>\n",
       "      <td>18</td>\n",
       "      <td>0.028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>강북구</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.030</td>\n",
       "      <td>45</td>\n",
       "      <td>22</td>\n",
       "      <td>0.021</td>\n",
       "      <td>0.004</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.030</td>\n",
       "      <td>...</td>\n",
       "      <td>0.016</td>\n",
       "      <td>40</td>\n",
       "      <td>19</td>\n",
       "      <td>0.029</td>\n",
       "      <td>0.002</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.015</td>\n",
       "      <td>34</td>\n",
       "      <td>18</td>\n",
       "      <td>0.032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>도봉구</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.030</td>\n",
       "      <td>43</td>\n",
       "      <td>22</td>\n",
       "      <td>0.025</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.028</td>\n",
       "      <td>...</td>\n",
       "      <td>0.017</td>\n",
       "      <td>37</td>\n",
       "      <td>18</td>\n",
       "      <td>0.029</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.016</td>\n",
       "      <td>30</td>\n",
       "      <td>17</td>\n",
       "      <td>0.031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>노원구</td>\n",
       "      <td>0.006</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.030</td>\n",
       "      <td>46</td>\n",
       "      <td>20</td>\n",
       "      <td>0.022</td>\n",
       "      <td>0.006</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.028</td>\n",
       "      <td>...</td>\n",
       "      <td>0.022</td>\n",
       "      <td>38</td>\n",
       "      <td>21</td>\n",
       "      <td>0.028</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.021</td>\n",
       "      <td>34</td>\n",
       "      <td>20</td>\n",
       "      <td>0.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>은평구</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.032</td>\n",
       "      <td>45</td>\n",
       "      <td>23</td>\n",
       "      <td>0.021</td>\n",
       "      <td>0.006</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.030</td>\n",
       "      <td>...</td>\n",
       "      <td>0.018</td>\n",
       "      <td>37</td>\n",
       "      <td>20</td>\n",
       "      <td>0.031</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.017</td>\n",
       "      <td>32</td>\n",
       "      <td>19</td>\n",
       "      <td>0.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>서대문구</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.034</td>\n",
       "      <td>42</td>\n",
       "      <td>21</td>\n",
       "      <td>0.024</td>\n",
       "      <td>0.004</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.026</td>\n",
       "      <td>...</td>\n",
       "      <td>0.018</td>\n",
       "      <td>34</td>\n",
       "      <td>20</td>\n",
       "      <td>0.029</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.018</td>\n",
       "      <td>31</td>\n",
       "      <td>16</td>\n",
       "      <td>0.029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>마포구</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.031</td>\n",
       "      <td>46</td>\n",
       "      <td>26</td>\n",
       "      <td>0.025</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.033</td>\n",
       "      <td>...</td>\n",
       "      <td>0.027</td>\n",
       "      <td>36</td>\n",
       "      <td>19</td>\n",
       "      <td>0.027</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.023</td>\n",
       "      <td>30</td>\n",
       "      <td>18</td>\n",
       "      <td>0.029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>양천구</td>\n",
       "      <td>0.006</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.036</td>\n",
       "      <td>47</td>\n",
       "      <td>23</td>\n",
       "      <td>0.022</td>\n",
       "      <td>0.004</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.033</td>\n",
       "      <td>...</td>\n",
       "      <td>0.026</td>\n",
       "      <td>41</td>\n",
       "      <td>21</td>\n",
       "      <td>0.027</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.021</td>\n",
       "      <td>34</td>\n",
       "      <td>20</td>\n",
       "      <td>0.027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>강서구</td>\n",
       "      <td>0.006</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.030</td>\n",
       "      <td>48</td>\n",
       "      <td>25</td>\n",
       "      <td>0.023</td>\n",
       "      <td>0.006</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.029</td>\n",
       "      <td>...</td>\n",
       "      <td>0.026</td>\n",
       "      <td>40</td>\n",
       "      <td>21</td>\n",
       "      <td>0.029</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.022</td>\n",
       "      <td>37</td>\n",
       "      <td>18</td>\n",
       "      <td>0.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>구로구</td>\n",
       "      <td>0.006</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.028</td>\n",
       "      <td>46</td>\n",
       "      <td>23</td>\n",
       "      <td>0.025</td>\n",
       "      <td>0.006</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.026</td>\n",
       "      <td>...</td>\n",
       "      <td>0.024</td>\n",
       "      <td>40</td>\n",
       "      <td>20</td>\n",
       "      <td>0.031</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.019</td>\n",
       "      <td>35</td>\n",
       "      <td>17</td>\n",
       "      <td>0.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>금천구</td>\n",
       "      <td>0.006</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.033</td>\n",
       "      <td>47</td>\n",
       "      <td>27</td>\n",
       "      <td>0.019</td>\n",
       "      <td>0.004</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.034</td>\n",
       "      <td>...</td>\n",
       "      <td>0.026</td>\n",
       "      <td>39</td>\n",
       "      <td>22</td>\n",
       "      <td>0.027</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.022</td>\n",
       "      <td>31</td>\n",
       "      <td>19</td>\n",
       "      <td>0.029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>영등포구</td>\n",
       "      <td>0.006</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.029</td>\n",
       "      <td>48</td>\n",
       "      <td>24</td>\n",
       "      <td>0.022</td>\n",
       "      <td>0.004</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.027</td>\n",
       "      <td>...</td>\n",
       "      <td>0.027</td>\n",
       "      <td>37</td>\n",
       "      <td>21</td>\n",
       "      <td>0.026</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.023</td>\n",
       "      <td>32</td>\n",
       "      <td>19</td>\n",
       "      <td>0.028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>동작구</td>\n",
       "      <td>0.006</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.034</td>\n",
       "      <td>44</td>\n",
       "      <td>24</td>\n",
       "      <td>0.025</td>\n",
       "      <td>0.004</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.033</td>\n",
       "      <td>...</td>\n",
       "      <td>0.024</td>\n",
       "      <td>41</td>\n",
       "      <td>21</td>\n",
       "      <td>0.027</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.021</td>\n",
       "      <td>35</td>\n",
       "      <td>20</td>\n",
       "      <td>0.031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>관악구</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.036</td>\n",
       "      <td>51</td>\n",
       "      <td>26</td>\n",
       "      <td>0.022</td>\n",
       "      <td>0.006</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.035</td>\n",
       "      <td>...</td>\n",
       "      <td>0.027</td>\n",
       "      <td>36</td>\n",
       "      <td>19</td>\n",
       "      <td>0.028</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.024</td>\n",
       "      <td>34</td>\n",
       "      <td>18</td>\n",
       "      <td>0.027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>서초구</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.030</td>\n",
       "      <td>47</td>\n",
       "      <td>23</td>\n",
       "      <td>0.021</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.031</td>\n",
       "      <td>...</td>\n",
       "      <td>0.025</td>\n",
       "      <td>40</td>\n",
       "      <td>20</td>\n",
       "      <td>0.028</td>\n",
       "      <td>0.002</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.022</td>\n",
       "      <td>32</td>\n",
       "      <td>17</td>\n",
       "      <td>0.028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>강남구</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.035</td>\n",
       "      <td>46</td>\n",
       "      <td>23</td>\n",
       "      <td>0.021</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.033</td>\n",
       "      <td>...</td>\n",
       "      <td>0.024</td>\n",
       "      <td>37</td>\n",
       "      <td>20</td>\n",
       "      <td>0.027</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.023</td>\n",
       "      <td>32</td>\n",
       "      <td>18</td>\n",
       "      <td>0.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>송파구</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.029</td>\n",
       "      <td>44</td>\n",
       "      <td>22</td>\n",
       "      <td>0.023</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.032</td>\n",
       "      <td>...</td>\n",
       "      <td>0.027</td>\n",
       "      <td>37</td>\n",
       "      <td>19</td>\n",
       "      <td>0.028</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.024</td>\n",
       "      <td>34</td>\n",
       "      <td>18</td>\n",
       "      <td>0.027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>강동구</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.031</td>\n",
       "      <td>44</td>\n",
       "      <td>22</td>\n",
       "      <td>0.021</td>\n",
       "      <td>0.004</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.033</td>\n",
       "      <td>...</td>\n",
       "      <td>0.022</td>\n",
       "      <td>39</td>\n",
       "      <td>21</td>\n",
       "      <td>0.025</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.020</td>\n",
       "      <td>34</td>\n",
       "      <td>19</td>\n",
       "      <td>0.025</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>29 rows × 49 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     구분별(1)              2015           2015.1            2015.2  \\\n",
       "0    구분별(1)  아황산가스(SO2) (ppm)  일산화탄소(CO) (ppm)  이산화질소(NO2) (ppm)   \n",
       "1    국가환경기준         0.02ppm/년         9ppm/8시간         0.03ppm/년   \n",
       "2   서울시환경기준         0.01ppm/년         9ppm/8시간         0.03ppm/년   \n",
       "3       평 균             0.005              0.5             0.032   \n",
       "4       종로구             0.006              0.4             0.033   \n",
       "5        중구             0.005              0.6             0.036   \n",
       "6       용산구             0.005              0.4             0.033   \n",
       "7       성동구             0.004              0.5             0.033   \n",
       "8       광진구             0.005              0.5             0.031   \n",
       "9      동대문구             0.006              0.5             0.035   \n",
       "10      중랑구             0.006              0.5             0.034   \n",
       "11      성북구             0.006              0.6             0.032   \n",
       "12      강북구             0.005              0.4             0.030   \n",
       "13      도봉구             0.005              0.5             0.030   \n",
       "14      노원구             0.006              0.5             0.030   \n",
       "15      은평구             0.005              0.5             0.032   \n",
       "16     서대문구             0.005              0.5             0.034   \n",
       "17      마포구             0.005              0.5             0.031   \n",
       "18      양천구             0.006              0.5             0.036   \n",
       "19      강서구             0.006              0.4             0.030   \n",
       "20      구로구             0.006              0.6             0.028   \n",
       "21      금천구             0.006              0.6             0.033   \n",
       "22     영등포구             0.006              0.6             0.029   \n",
       "23      동작구             0.006              0.5             0.034   \n",
       "24      관악구             0.005              0.7             0.036   \n",
       "25      서초구             0.005              0.5             0.030   \n",
       "26      강남구             0.005              0.5             0.035   \n",
       "27      송파구             0.005              0.6             0.029   \n",
       "28      강동구             0.005              0.5             0.031   \n",
       "\n",
       "               2015.3               2015.4        2015.5              2016  \\\n",
       "0   미세먼지(PM-10) (㎍/㎥)  초미세먼지(PM-2.5) (㎍/㎥)  오존(O3) (ppm)  아황산가스(SO2) (ppm)   \n",
       "1             50㎍/㎥/년              25㎍/㎥/년   0.06ppm/8시간         0.02ppm/년   \n",
       "2             50㎍/㎥/년              25㎍/㎥/년   0.06ppm/8시간         0.01ppm/년   \n",
       "3                  45                   23         0.022             0.005   \n",
       "4                  50                   25         0.022             0.004   \n",
       "5                  44                   23         0.023             0.005   \n",
       "6                  42                   24         0.021             0.005   \n",
       "7                  46                   23         0.021             0.005   \n",
       "8                  45                   22         0.021             0.004   \n",
       "9                  44                   23         0.023             0.006   \n",
       "10                 45                   23         0.023             0.006   \n",
       "11                 42                   21         0.022             0.005   \n",
       "12                 45                   22         0.021             0.004   \n",
       "13                 43                   22         0.025             0.005   \n",
       "14                 46                   20         0.022             0.006   \n",
       "15                 45                   23         0.021             0.006   \n",
       "16                 42                   21         0.024             0.004   \n",
       "17                 46                   26         0.025             0.005   \n",
       "18                 47                   23         0.022             0.004   \n",
       "19                 48                   25         0.023             0.006   \n",
       "20                 46                   23         0.025             0.006   \n",
       "21                 47                   27         0.019             0.004   \n",
       "22                 48                   24         0.022             0.004   \n",
       "23                 44                   24         0.025             0.004   \n",
       "24                 51                   26         0.022             0.006   \n",
       "25                 47                   23         0.021             0.005   \n",
       "26                 46                   23         0.021             0.005   \n",
       "27                 44                   22         0.023             0.005   \n",
       "28                 44                   22         0.021             0.004   \n",
       "\n",
       "             2016.1            2016.2  ...            2021.2  \\\n",
       "0   일산화탄소(CO) (ppm)  이산화질소(NO2) (ppm)  ...  이산화질소(NO2) (ppm)   \n",
       "1          9ppm/8시간         0.03ppm/년  ...                 -   \n",
       "2          9ppm/8시간         0.03ppm/년  ...                 -   \n",
       "3               0.5             0.031  ...             0.024   \n",
       "4               0.4             0.030  ...             0.023   \n",
       "5               0.5             0.036  ...             0.027   \n",
       "6               0.5             0.032  ...             0.022   \n",
       "7               0.5             0.034  ...             0.027   \n",
       "8               0.6             0.032  ...             0.020   \n",
       "9               0.6             0.033  ...             0.025   \n",
       "10              0.5             0.032  ...             0.023   \n",
       "11              0.6             0.034  ...             0.026   \n",
       "12              0.5             0.030  ...             0.016   \n",
       "13              0.5             0.028  ...             0.017   \n",
       "14              0.5             0.028  ...             0.022   \n",
       "15              0.4             0.030  ...             0.018   \n",
       "16              0.5             0.026  ...             0.018   \n",
       "17              0.6             0.033  ...             0.027   \n",
       "18              0.5             0.033  ...             0.026   \n",
       "19              0.4             0.029  ...             0.026   \n",
       "20              0.5             0.026  ...             0.024   \n",
       "21              0.5             0.034  ...             0.026   \n",
       "22              0.6             0.027  ...             0.027   \n",
       "23              0.5             0.033  ...             0.024   \n",
       "24              0.6             0.035  ...             0.027   \n",
       "25              0.5             0.031  ...             0.025   \n",
       "26              0.4             0.033  ...             0.024   \n",
       "27              0.5             0.032  ...             0.027   \n",
       "28              0.5             0.033  ...             0.022   \n",
       "\n",
       "               2021.3               2021.4        2021.5              2022  \\\n",
       "0   미세먼지(PM-10) (㎍/㎥)  초미세먼지(PM-2.5) (㎍/㎥)  오존(O3) (ppm)  아황산가스(SO2) (ppm)   \n",
       "1                   -                    -             -                 -   \n",
       "2                   -                    -             -                 -   \n",
       "3                  38                   20         0.028             0.003   \n",
       "4                  39                   20         0.029             0.003   \n",
       "5                  42                   21         0.026             0.003   \n",
       "6                  37                   19         0.023             0.003   \n",
       "7                  38                   19         0.030             0.003   \n",
       "8                  37                   19         0.027             0.003   \n",
       "9                  38                   20         0.029             0.003   \n",
       "10                 38                   18         0.028             0.003   \n",
       "11                 39                   18         0.027             0.003   \n",
       "12                 40                   19         0.029             0.002   \n",
       "13                 37                   18         0.029             0.003   \n",
       "14                 38                   21         0.028             0.003   \n",
       "15                 37                   20         0.031             0.003   \n",
       "16                 34                   20         0.029             0.003   \n",
       "17                 36                   19         0.027             0.003   \n",
       "18                 41                   21         0.027             0.003   \n",
       "19                 40                   21         0.029             0.003   \n",
       "20                 40                   20         0.031             0.003   \n",
       "21                 39                   22         0.027             0.003   \n",
       "22                 37                   21         0.026             0.003   \n",
       "23                 41                   21         0.027             0.003   \n",
       "24                 36                   19         0.028             0.003   \n",
       "25                 40                   20         0.028             0.002   \n",
       "26                 37                   20         0.027             0.003   \n",
       "27                 37                   19         0.028             0.003   \n",
       "28                 39                   21         0.025             0.003   \n",
       "\n",
       "             2022.1            2022.2             2022.3               2022.4  \\\n",
       "0   일산화탄소(CO) (ppm)  이산화질소(NO2) (ppm)  미세먼지(PM-10) (㎍/㎥)  초미세먼지(PM-2.5) (㎍/㎥)   \n",
       "1                 -                 -                  -                    -   \n",
       "2                 -                 -                  -                    -   \n",
       "3               0.4             0.021                 33                   18   \n",
       "4               0.5             0.021                 32                   19   \n",
       "5               0.4             0.024                 30                   19   \n",
       "6               0.4             0.021                 33                   19   \n",
       "7               0.4             0.021                 35                   16   \n",
       "8               0.5             0.019                 31                   18   \n",
       "9               0.4             0.022                 34                   19   \n",
       "10              0.4             0.021                 33                   18   \n",
       "11              0.5             0.023                 33                   18   \n",
       "12              0.4             0.015                 34                   18   \n",
       "13              0.5             0.016                 30                   17   \n",
       "14              0.5             0.021                 34                   20   \n",
       "15              0.5             0.017                 32                   19   \n",
       "16              0.6             0.018                 31                   16   \n",
       "17              0.4             0.023                 30                   18   \n",
       "18              0.5             0.021                 34                   20   \n",
       "19              0.5             0.022                 37                   18   \n",
       "20              0.4             0.019                 35                   17   \n",
       "21              0.4             0.022                 31                   19   \n",
       "22              0.5             0.023                 32                   19   \n",
       "23              0.4             0.021                 35                   20   \n",
       "24              0.5             0.024                 34                   18   \n",
       "25              0.4             0.022                 32                   17   \n",
       "26              0.4             0.023                 32                   18   \n",
       "27              0.5             0.024                 34                   18   \n",
       "28              0.4             0.020                 34                   19   \n",
       "\n",
       "          2022.5  \n",
       "0   오존(O3) (ppm)  \n",
       "1              -  \n",
       "2              -  \n",
       "3          0.029  \n",
       "4          0.031  \n",
       "5          0.030  \n",
       "6          0.030  \n",
       "7          0.028  \n",
       "8          0.027  \n",
       "9          0.032  \n",
       "10         0.031  \n",
       "11         0.028  \n",
       "12         0.032  \n",
       "13         0.031  \n",
       "14         0.030  \n",
       "15         0.030  \n",
       "16         0.029  \n",
       "17         0.029  \n",
       "18         0.027  \n",
       "19         0.030  \n",
       "20         0.030  \n",
       "21         0.029  \n",
       "22         0.028  \n",
       "23         0.031  \n",
       "24         0.027  \n",
       "25         0.028  \n",
       "26         0.030  \n",
       "27         0.027  \n",
       "28         0.025  \n",
       "\n",
       "[29 rows x 49 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "selected_columns = df[['구분별(1)']].join(df.filter(like='2022', axis=1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>구분별(1)</th>\n",
       "      <th>2022</th>\n",
       "      <th>2022.1</th>\n",
       "      <th>2022.2</th>\n",
       "      <th>2022.3</th>\n",
       "      <th>2022.4</th>\n",
       "      <th>2022.5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>구분별(1)</td>\n",
       "      <td>아황산가스(SO2) (ppm)</td>\n",
       "      <td>일산화탄소(CO) (ppm)</td>\n",
       "      <td>이산화질소(NO2) (ppm)</td>\n",
       "      <td>미세먼지(PM-10) (㎍/㎥)</td>\n",
       "      <td>초미세먼지(PM-2.5) (㎍/㎥)</td>\n",
       "      <td>오존(O3) (ppm)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\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>2</th>\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>3</th>\n",
       "      <td>평 균</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.021</td>\n",
       "      <td>33</td>\n",
       "      <td>18</td>\n",
       "      <td>0.029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>종로구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.021</td>\n",
       "      <td>32</td>\n",
       "      <td>19</td>\n",
       "      <td>0.031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>중구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.024</td>\n",
       "      <td>30</td>\n",
       "      <td>19</td>\n",
       "      <td>0.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>용산구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.021</td>\n",
       "      <td>33</td>\n",
       "      <td>19</td>\n",
       "      <td>0.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>성동구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.021</td>\n",
       "      <td>35</td>\n",
       "      <td>16</td>\n",
       "      <td>0.028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>광진구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.019</td>\n",
       "      <td>31</td>\n",
       "      <td>18</td>\n",
       "      <td>0.027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>동대문구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.022</td>\n",
       "      <td>34</td>\n",
       "      <td>19</td>\n",
       "      <td>0.032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>중랑구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.021</td>\n",
       "      <td>33</td>\n",
       "      <td>18</td>\n",
       "      <td>0.031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>성북구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.023</td>\n",
       "      <td>33</td>\n",
       "      <td>18</td>\n",
       "      <td>0.028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>강북구</td>\n",
       "      <td>0.002</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.015</td>\n",
       "      <td>34</td>\n",
       "      <td>18</td>\n",
       "      <td>0.032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>도봉구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.016</td>\n",
       "      <td>30</td>\n",
       "      <td>17</td>\n",
       "      <td>0.031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>노원구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.021</td>\n",
       "      <td>34</td>\n",
       "      <td>20</td>\n",
       "      <td>0.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>은평구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.017</td>\n",
       "      <td>32</td>\n",
       "      <td>19</td>\n",
       "      <td>0.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>서대문구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.018</td>\n",
       "      <td>31</td>\n",
       "      <td>16</td>\n",
       "      <td>0.029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>마포구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.023</td>\n",
       "      <td>30</td>\n",
       "      <td>18</td>\n",
       "      <td>0.029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>양천구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.021</td>\n",
       "      <td>34</td>\n",
       "      <td>20</td>\n",
       "      <td>0.027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>강서구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.022</td>\n",
       "      <td>37</td>\n",
       "      <td>18</td>\n",
       "      <td>0.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>구로구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.019</td>\n",
       "      <td>35</td>\n",
       "      <td>17</td>\n",
       "      <td>0.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>금천구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.022</td>\n",
       "      <td>31</td>\n",
       "      <td>19</td>\n",
       "      <td>0.029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>영등포구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.023</td>\n",
       "      <td>32</td>\n",
       "      <td>19</td>\n",
       "      <td>0.028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>동작구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.021</td>\n",
       "      <td>35</td>\n",
       "      <td>20</td>\n",
       "      <td>0.031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>관악구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.024</td>\n",
       "      <td>34</td>\n",
       "      <td>18</td>\n",
       "      <td>0.027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>서초구</td>\n",
       "      <td>0.002</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.022</td>\n",
       "      <td>32</td>\n",
       "      <td>17</td>\n",
       "      <td>0.028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>강남구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.023</td>\n",
       "      <td>32</td>\n",
       "      <td>18</td>\n",
       "      <td>0.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>송파구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.024</td>\n",
       "      <td>34</td>\n",
       "      <td>18</td>\n",
       "      <td>0.027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>강동구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.020</td>\n",
       "      <td>34</td>\n",
       "      <td>19</td>\n",
       "      <td>0.025</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     구분별(1)              2022           2022.1            2022.2  \\\n",
       "0    구분별(1)  아황산가스(SO2) (ppm)  일산화탄소(CO) (ppm)  이산화질소(NO2) (ppm)   \n",
       "1    국가환경기준                 -                -                 -   \n",
       "2   서울시환경기준                 -                -                 -   \n",
       "3       평 균             0.003              0.4             0.021   \n",
       "4       종로구             0.003              0.5             0.021   \n",
       "5        중구             0.003              0.4             0.024   \n",
       "6       용산구             0.003              0.4             0.021   \n",
       "7       성동구             0.003              0.4             0.021   \n",
       "8       광진구             0.003              0.5             0.019   \n",
       "9      동대문구             0.003              0.4             0.022   \n",
       "10      중랑구             0.003              0.4             0.021   \n",
       "11      성북구             0.003              0.5             0.023   \n",
       "12      강북구             0.002              0.4             0.015   \n",
       "13      도봉구             0.003              0.5             0.016   \n",
       "14      노원구             0.003              0.5             0.021   \n",
       "15      은평구             0.003              0.5             0.017   \n",
       "16     서대문구             0.003              0.6             0.018   \n",
       "17      마포구             0.003              0.4             0.023   \n",
       "18      양천구             0.003              0.5             0.021   \n",
       "19      강서구             0.003              0.5             0.022   \n",
       "20      구로구             0.003              0.4             0.019   \n",
       "21      금천구             0.003              0.4             0.022   \n",
       "22     영등포구             0.003              0.5             0.023   \n",
       "23      동작구             0.003              0.4             0.021   \n",
       "24      관악구             0.003              0.5             0.024   \n",
       "25      서초구             0.002              0.4             0.022   \n",
       "26      강남구             0.003              0.4             0.023   \n",
       "27      송파구             0.003              0.5             0.024   \n",
       "28      강동구             0.003              0.4             0.020   \n",
       "\n",
       "               2022.3               2022.4        2022.5  \n",
       "0   미세먼지(PM-10) (㎍/㎥)  초미세먼지(PM-2.5) (㎍/㎥)  오존(O3) (ppm)  \n",
       "1                   -                    -             -  \n",
       "2                   -                    -             -  \n",
       "3                  33                   18         0.029  \n",
       "4                  32                   19         0.031  \n",
       "5                  30                   19         0.030  \n",
       "6                  33                   19         0.030  \n",
       "7                  35                   16         0.028  \n",
       "8                  31                   18         0.027  \n",
       "9                  34                   19         0.032  \n",
       "10                 33                   18         0.031  \n",
       "11                 33                   18         0.028  \n",
       "12                 34                   18         0.032  \n",
       "13                 30                   17         0.031  \n",
       "14                 34                   20         0.030  \n",
       "15                 32                   19         0.030  \n",
       "16                 31                   16         0.029  \n",
       "17                 30                   18         0.029  \n",
       "18                 34                   20         0.027  \n",
       "19                 37                   18         0.030  \n",
       "20                 35                   17         0.030  \n",
       "21                 31                   19         0.029  \n",
       "22                 32                   19         0.028  \n",
       "23                 35                   20         0.031  \n",
       "24                 34                   18         0.027  \n",
       "25                 32                   17         0.028  \n",
       "26                 32                   18         0.030  \n",
       "27                 34                   18         0.027  \n",
       "28                 34                   19         0.025  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "selected_columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "selected_columns.drop(index=range(1,4), inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "selected_columns.columns = ['자치구명', '아황산가스', '일산화탄소', '이산화질소', '미세먼지', '초미세먼지', '오존']\n",
    "selected_columns.drop(index=0, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>종로구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.021</td>\n",
       "      <td>32</td>\n",
       "      <td>19</td>\n",
       "      <td>0.031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>중구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.024</td>\n",
       "      <td>30</td>\n",
       "      <td>19</td>\n",
       "      <td>0.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>용산구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.021</td>\n",
       "      <td>33</td>\n",
       "      <td>19</td>\n",
       "      <td>0.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>성동구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.021</td>\n",
       "      <td>35</td>\n",
       "      <td>16</td>\n",
       "      <td>0.028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>광진구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.019</td>\n",
       "      <td>31</td>\n",
       "      <td>18</td>\n",
       "      <td>0.027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>동대문구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.022</td>\n",
       "      <td>34</td>\n",
       "      <td>19</td>\n",
       "      <td>0.032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>중랑구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.021</td>\n",
       "      <td>33</td>\n",
       "      <td>18</td>\n",
       "      <td>0.031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>성북구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.023</td>\n",
       "      <td>33</td>\n",
       "      <td>18</td>\n",
       "      <td>0.028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>강북구</td>\n",
       "      <td>0.002</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.015</td>\n",
       "      <td>34</td>\n",
       "      <td>18</td>\n",
       "      <td>0.032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>도봉구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.016</td>\n",
       "      <td>30</td>\n",
       "      <td>17</td>\n",
       "      <td>0.031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>노원구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.021</td>\n",
       "      <td>34</td>\n",
       "      <td>20</td>\n",
       "      <td>0.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>은평구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.017</td>\n",
       "      <td>32</td>\n",
       "      <td>19</td>\n",
       "      <td>0.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>서대문구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.018</td>\n",
       "      <td>31</td>\n",
       "      <td>16</td>\n",
       "      <td>0.029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>마포구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.023</td>\n",
       "      <td>30</td>\n",
       "      <td>18</td>\n",
       "      <td>0.029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>양천구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.021</td>\n",
       "      <td>34</td>\n",
       "      <td>20</td>\n",
       "      <td>0.027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>강서구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.022</td>\n",
       "      <td>37</td>\n",
       "      <td>18</td>\n",
       "      <td>0.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>구로구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.019</td>\n",
       "      <td>35</td>\n",
       "      <td>17</td>\n",
       "      <td>0.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>금천구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.022</td>\n",
       "      <td>31</td>\n",
       "      <td>19</td>\n",
       "      <td>0.029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>영등포구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.023</td>\n",
       "      <td>32</td>\n",
       "      <td>19</td>\n",
       "      <td>0.028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>동작구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.021</td>\n",
       "      <td>35</td>\n",
       "      <td>20</td>\n",
       "      <td>0.031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>관악구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.024</td>\n",
       "      <td>34</td>\n",
       "      <td>18</td>\n",
       "      <td>0.027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>서초구</td>\n",
       "      <td>0.002</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.022</td>\n",
       "      <td>32</td>\n",
       "      <td>17</td>\n",
       "      <td>0.028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>강남구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.023</td>\n",
       "      <td>32</td>\n",
       "      <td>18</td>\n",
       "      <td>0.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>송파구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.024</td>\n",
       "      <td>34</td>\n",
       "      <td>18</td>\n",
       "      <td>0.027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>강동구</td>\n",
       "      <td>0.003</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.020</td>\n",
       "      <td>34</td>\n",
       "      <td>19</td>\n",
       "      <td>0.025</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    자치구명  아황산가스 일산화탄소  이산화질소 미세먼지 초미세먼지     오존\n",
       "4    종로구  0.003   0.5  0.021   32    19  0.031\n",
       "5     중구  0.003   0.4  0.024   30    19  0.030\n",
       "6    용산구  0.003   0.4  0.021   33    19  0.030\n",
       "7    성동구  0.003   0.4  0.021   35    16  0.028\n",
       "8    광진구  0.003   0.5  0.019   31    18  0.027\n",
       "9   동대문구  0.003   0.4  0.022   34    19  0.032\n",
       "10   중랑구  0.003   0.4  0.021   33    18  0.031\n",
       "11   성북구  0.003   0.5  0.023   33    18  0.028\n",
       "12   강북구  0.002   0.4  0.015   34    18  0.032\n",
       "13   도봉구  0.003   0.5  0.016   30    17  0.031\n",
       "14   노원구  0.003   0.5  0.021   34    20  0.030\n",
       "15   은평구  0.003   0.5  0.017   32    19  0.030\n",
       "16  서대문구  0.003   0.6  0.018   31    16  0.029\n",
       "17   마포구  0.003   0.4  0.023   30    18  0.029\n",
       "18   양천구  0.003   0.5  0.021   34    20  0.027\n",
       "19   강서구  0.003   0.5  0.022   37    18  0.030\n",
       "20   구로구  0.003   0.4  0.019   35    17  0.030\n",
       "21   금천구  0.003   0.4  0.022   31    19  0.029\n",
       "22  영등포구  0.003   0.5  0.023   32    19  0.028\n",
       "23   동작구  0.003   0.4  0.021   35    20  0.031\n",
       "24   관악구  0.003   0.5  0.024   34    18  0.027\n",
       "25   서초구  0.002   0.4  0.022   32    17  0.028\n",
       "26   강남구  0.003   0.4  0.023   32    18  0.030\n",
       "27   송파구  0.003   0.5  0.024   34    18  0.027\n",
       "28   강동구  0.003   0.4  0.020   34    19  0.025"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "selected_columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "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.11.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}