data_cleaning.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 228,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "df=pd.read_excel(r\"C:\\Users\\Angad\\Desktop\\Delhi.xlsx\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "I've used only Delhi for now because my laptop is unable to load the raw data dataset(30MB)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Data_Cleaning"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 229,
   "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>stn_code</th>\n",
       "      <th>sampling_date</th>\n",
       "      <th>state</th>\n",
       "      <th>location</th>\n",
       "      <th>agency</th>\n",
       "      <th>type</th>\n",
       "      <th>so2</th>\n",
       "      <th>no2</th>\n",
       "      <th>rspm</th>\n",
       "      <th>spm</th>\n",
       "      <th>location_monitoring_station</th>\n",
       "      <th>pm2_5</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>1987-09-01 00:00:00</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential</td>\n",
       "      <td>8.6</td>\n",
       "      <td>16.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>323.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1987-01-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>59.0</td>\n",
       "      <td>1987-09-02 00:00:00</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential</td>\n",
       "      <td>6.5</td>\n",
       "      <td>9.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>488.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1987-02-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>58.0</td>\n",
       "      <td>1987-09-03 00:00:00</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Industrial</td>\n",
       "      <td>25.8</td>\n",
       "      <td>10.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>487.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1987-03-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>57.0</td>\n",
       "      <td>1987-09-03 00:00:00</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Industrial</td>\n",
       "      <td>0.5</td>\n",
       "      <td>2.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>528.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1987-03-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>56.0</td>\n",
       "      <td>1987-09-02 00:00:00</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Industrial</td>\n",
       "      <td>2.5</td>\n",
       "      <td>12.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>506.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1987-02-09</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>8546</td>\n",
       "      <td>531.0</td>\n",
       "      <td>16-12-15</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>4.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>246.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8547</td>\n",
       "      <td>531.0</td>\n",
       "      <td>21-12-15</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>4.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>269.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8548</td>\n",
       "      <td>531.0</td>\n",
       "      <td>28-12-15</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>4.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>205.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8549</td>\n",
       "      <td>531.0</td>\n",
       "      <td>29-12-15</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>5.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>142.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8550</td>\n",
       "      <td>531.0</td>\n",
       "      <td>31-12-15</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>9.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>420.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-31</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8551 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      stn_code        sampling_date  state location  \\\n",
       "0         60.0  1987-09-01 00:00:00  Delhi    Delhi   \n",
       "1         59.0  1987-09-02 00:00:00  Delhi    Delhi   \n",
       "2         58.0  1987-09-03 00:00:00  Delhi    Delhi   \n",
       "3         57.0  1987-09-03 00:00:00  Delhi    Delhi   \n",
       "4         56.0  1987-09-02 00:00:00  Delhi    Delhi   \n",
       "...        ...                  ...    ...      ...   \n",
       "8546     531.0             16-12-15  Delhi    Delhi   \n",
       "8547     531.0             21-12-15  Delhi    Delhi   \n",
       "8548     531.0             28-12-15  Delhi    Delhi   \n",
       "8549     531.0             29-12-15  Delhi    Delhi   \n",
       "8550     531.0             31-12-15  Delhi    Delhi   \n",
       "\n",
       "                               agency                                type  \\\n",
       "0     Central Pollution Control Board                         Residential   \n",
       "1     Central Pollution Control Board                         Residential   \n",
       "2     Central Pollution Control Board                          Industrial   \n",
       "3     Central Pollution Control Board                          Industrial   \n",
       "4     Central Pollution Control Board                          Industrial   \n",
       "...                               ...                                 ...   \n",
       "8546  Central Pollution Control Board  Residential, Rural and other Areas   \n",
       "8547  Central Pollution Control Board  Residential, Rural and other Areas   \n",
       "8548  Central Pollution Control Board  Residential, Rural and other Areas   \n",
       "8549  Central Pollution Control Board  Residential, Rural and other Areas   \n",
       "8550  Central Pollution Control Board  Residential, Rural and other Areas   \n",
       "\n",
       "       so2   no2   rspm    spm location_monitoring_station  pm2_5       date  \n",
       "0      8.6  16.2    NaN  323.0                         NaN    NaN 1987-01-09  \n",
       "1      6.5   9.3    NaN  488.0                         NaN    NaN 1987-02-09  \n",
       "2     25.8  10.4    NaN  487.0                         NaN    NaN 1987-03-09  \n",
       "3      0.5   2.8    NaN  528.0                         NaN    NaN 1987-03-09  \n",
       "4      2.5  12.8    NaN  506.0                         NaN    NaN 1987-02-09  \n",
       "...    ...   ...    ...    ...                         ...    ...        ...  \n",
       "8546   4.0  56.0  246.0    NaN           Pritampura, Delhi    NaN 2015-12-16  \n",
       "8547   4.0  54.0  269.0    NaN           Pritampura, Delhi    NaN 2015-12-21  \n",
       "8548   4.0  53.0  205.0    NaN           Pritampura, Delhi    NaN 2015-12-28  \n",
       "8549   5.0  43.0  142.0    NaN           Pritampura, Delhi    NaN 2015-12-29  \n",
       "8550   9.0  44.0  420.0    NaN           Pritampura, Delhi    NaN 2015-12-31  \n",
       "\n",
       "[8551 rows x 13 columns]"
      ]
     },
     "execution_count": 229,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 209,
   "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>stn_code</th>\n",
       "      <th>so2</th>\n",
       "      <th>no2</th>\n",
       "      <th>rspm</th>\n",
       "      <th>spm</th>\n",
       "      <th>pm2_5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>count</td>\n",
       "      <td>5246.000000</td>\n",
       "      <td>7810.000000</td>\n",
       "      <td>8007.000000</td>\n",
       "      <td>6667.000000</td>\n",
       "      <td>5459.000000</td>\n",
       "      <td>371.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>mean</td>\n",
       "      <td>130.248761</td>\n",
       "      <td>8.737273</td>\n",
       "      <td>53.489147</td>\n",
       "      <td>196.639771</td>\n",
       "      <td>399.402088</td>\n",
       "      <td>95.113208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>std</td>\n",
       "      <td>118.997923</td>\n",
       "      <td>7.613131</td>\n",
       "      <td>27.494406</td>\n",
       "      <td>115.925078</td>\n",
       "      <td>188.775771</td>\n",
       "      <td>47.127178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>min</td>\n",
       "      <td>55.000000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>2.800000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>14.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>25%</td>\n",
       "      <td>57.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>111.000000</td>\n",
       "      <td>266.000000</td>\n",
       "      <td>62.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>50%</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>47.000000</td>\n",
       "      <td>171.000000</td>\n",
       "      <td>366.000000</td>\n",
       "      <td>86.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>75%</td>\n",
       "      <td>146.000000</td>\n",
       "      <td>11.600000</td>\n",
       "      <td>62.350000</td>\n",
       "      <td>256.000000</td>\n",
       "      <td>501.000000</td>\n",
       "      <td>118.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>max</td>\n",
       "      <td>531.000000</td>\n",
       "      <td>127.400000</td>\n",
       "      <td>224.000000</td>\n",
       "      <td>892.000000</td>\n",
       "      <td>1885.000000</td>\n",
       "      <td>318.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          stn_code          so2          no2         rspm          spm  \\\n",
       "count  5246.000000  7810.000000  8007.000000  6667.000000  5459.000000   \n",
       "mean    130.248761     8.737273    53.489147   196.639771   399.402088   \n",
       "std     118.997923     7.613131    27.494406   115.925078   188.775771   \n",
       "min      55.000000     0.500000     2.800000    13.000000    30.000000   \n",
       "25%      57.000000     4.000000    35.000000   111.000000   266.000000   \n",
       "50%      60.000000     6.000000    47.000000   171.000000   366.000000   \n",
       "75%     146.000000    11.600000    62.350000   256.000000   501.000000   \n",
       "max     531.000000   127.400000   224.000000   892.000000  1885.000000   \n",
       "\n",
       "            pm2_5  \n",
       "count  371.000000  \n",
       "mean    95.113208  \n",
       "std     47.127178  \n",
       "min     14.000000  \n",
       "25%     62.000000  \n",
       "50%     86.000000  \n",
       "75%    118.500000  \n",
       "max    318.000000  "
      ]
     },
     "execution_count": 209,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe()# just to show the amount of data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 230,
   "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>stn_code</th>\n",
       "      <th>sampling_date</th>\n",
       "      <th>state</th>\n",
       "      <th>location</th>\n",
       "      <th>agency</th>\n",
       "      <th>type</th>\n",
       "      <th>so2</th>\n",
       "      <th>no2</th>\n",
       "      <th>rspm</th>\n",
       "      <th>spm</th>\n",
       "      <th>location_monitoring_station</th>\n",
       "      <th>pm2_5</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>1987-01-09</td>\n",
       "      <td>60.0</td>\n",
       "      <td>1987-09-01 00:00:00</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential</td>\n",
       "      <td>8.6</td>\n",
       "      <td>16.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>323.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1987-02-09</td>\n",
       "      <td>59.0</td>\n",
       "      <td>1987-09-02 00:00:00</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential</td>\n",
       "      <td>6.5</td>\n",
       "      <td>9.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>488.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1987-03-09</td>\n",
       "      <td>58.0</td>\n",
       "      <td>1987-09-03 00:00:00</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Industrial</td>\n",
       "      <td>25.8</td>\n",
       "      <td>10.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>487.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1987-03-09</td>\n",
       "      <td>57.0</td>\n",
       "      <td>1987-09-03 00:00:00</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Industrial</td>\n",
       "      <td>0.5</td>\n",
       "      <td>2.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>528.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1987-02-09</td>\n",
       "      <td>56.0</td>\n",
       "      <td>1987-09-02 00:00:00</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Industrial</td>\n",
       "      <td>2.5</td>\n",
       "      <td>12.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>506.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>2015-12-16</td>\n",
       "      <td>531.0</td>\n",
       "      <td>16-12-15</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>4.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>246.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-12-21</td>\n",
       "      <td>531.0</td>\n",
       "      <td>21-12-15</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>4.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>269.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-12-28</td>\n",
       "      <td>531.0</td>\n",
       "      <td>28-12-15</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>4.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>205.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-12-29</td>\n",
       "      <td>531.0</td>\n",
       "      <td>29-12-15</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>5.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>142.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-12-31</td>\n",
       "      <td>531.0</td>\n",
       "      <td>31-12-15</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>9.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>420.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8551 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            stn_code        sampling_date  state location  \\\n",
       "date                                                        \n",
       "1987-01-09      60.0  1987-09-01 00:00:00  Delhi    Delhi   \n",
       "1987-02-09      59.0  1987-09-02 00:00:00  Delhi    Delhi   \n",
       "1987-03-09      58.0  1987-09-03 00:00:00  Delhi    Delhi   \n",
       "1987-03-09      57.0  1987-09-03 00:00:00  Delhi    Delhi   \n",
       "1987-02-09      56.0  1987-09-02 00:00:00  Delhi    Delhi   \n",
       "...              ...                  ...    ...      ...   \n",
       "2015-12-16     531.0             16-12-15  Delhi    Delhi   \n",
       "2015-12-21     531.0             21-12-15  Delhi    Delhi   \n",
       "2015-12-28     531.0             28-12-15  Delhi    Delhi   \n",
       "2015-12-29     531.0             29-12-15  Delhi    Delhi   \n",
       "2015-12-31     531.0             31-12-15  Delhi    Delhi   \n",
       "\n",
       "                                     agency  \\\n",
       "date                                          \n",
       "1987-01-09  Central Pollution Control Board   \n",
       "1987-02-09  Central Pollution Control Board   \n",
       "1987-03-09  Central Pollution Control Board   \n",
       "1987-03-09  Central Pollution Control Board   \n",
       "1987-02-09  Central Pollution Control Board   \n",
       "...                                     ...   \n",
       "2015-12-16  Central Pollution Control Board   \n",
       "2015-12-21  Central Pollution Control Board   \n",
       "2015-12-28  Central Pollution Control Board   \n",
       "2015-12-29  Central Pollution Control Board   \n",
       "2015-12-31  Central Pollution Control Board   \n",
       "\n",
       "                                          type   so2   no2   rspm    spm  \\\n",
       "date                                                                       \n",
       "1987-01-09                         Residential   8.6  16.2    NaN  323.0   \n",
       "1987-02-09                         Residential   6.5   9.3    NaN  488.0   \n",
       "1987-03-09                          Industrial  25.8  10.4    NaN  487.0   \n",
       "1987-03-09                          Industrial   0.5   2.8    NaN  528.0   \n",
       "1987-02-09                          Industrial   2.5  12.8    NaN  506.0   \n",
       "...                                        ...   ...   ...    ...    ...   \n",
       "2015-12-16  Residential, Rural and other Areas   4.0  56.0  246.0    NaN   \n",
       "2015-12-21  Residential, Rural and other Areas   4.0  54.0  269.0    NaN   \n",
       "2015-12-28  Residential, Rural and other Areas   4.0  53.0  205.0    NaN   \n",
       "2015-12-29  Residential, Rural and other Areas   5.0  43.0  142.0    NaN   \n",
       "2015-12-31  Residential, Rural and other Areas   9.0  44.0  420.0    NaN   \n",
       "\n",
       "           location_monitoring_station  pm2_5  \n",
       "date                                           \n",
       "1987-01-09                         NaN    NaN  \n",
       "1987-02-09                         NaN    NaN  \n",
       "1987-03-09                         NaN    NaN  \n",
       "1987-03-09                         NaN    NaN  \n",
       "1987-02-09                         NaN    NaN  \n",
       "...                                ...    ...  \n",
       "2015-12-16           Pritampura, Delhi    NaN  \n",
       "2015-12-21           Pritampura, Delhi    NaN  \n",
       "2015-12-28           Pritampura, Delhi    NaN  \n",
       "2015-12-29           Pritampura, Delhi    NaN  \n",
       "2015-12-31           Pritampura, Delhi    NaN  \n",
       "\n",
       "[8551 rows x 12 columns]"
      ]
     },
     "execution_count": 230,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.date=pd.to_datetime(df.date)\n",
    "df.set_index('date',inplace=True)#setting the date colomn as the index\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 245,
   "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>stn_code</th>\n",
       "      <th>sampling_date</th>\n",
       "      <th>state</th>\n",
       "      <th>location</th>\n",
       "      <th>agency</th>\n",
       "      <th>type</th>\n",
       "      <th>so2</th>\n",
       "      <th>no2</th>\n",
       "      <th>rspm</th>\n",
       "      <th>spm</th>\n",
       "      <th>location_monitoring_station</th>\n",
       "      <th>pm2_5</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>1987-01-09</td>\n",
       "      <td>60</td>\n",
       "      <td>1987-09-01 00:00:00</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential</td>\n",
       "      <td>8.6</td>\n",
       "      <td>16.2</td>\n",
       "      <td>149.0</td>\n",
       "      <td>323.0</td>\n",
       "      <td>No station</td>\n",
       "      <td>78.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1987-02-09</td>\n",
       "      <td>59</td>\n",
       "      <td>1987-09-02 00:00:00</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential</td>\n",
       "      <td>6.5</td>\n",
       "      <td>9.3</td>\n",
       "      <td>149.0</td>\n",
       "      <td>488.0</td>\n",
       "      <td>No station</td>\n",
       "      <td>78.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1987-03-09</td>\n",
       "      <td>58</td>\n",
       "      <td>1987-09-03 00:00:00</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Industrial</td>\n",
       "      <td>25.8</td>\n",
       "      <td>10.4</td>\n",
       "      <td>149.0</td>\n",
       "      <td>487.0</td>\n",
       "      <td>No station</td>\n",
       "      <td>78.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1987-03-09</td>\n",
       "      <td>57</td>\n",
       "      <td>1987-09-03 00:00:00</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Industrial</td>\n",
       "      <td>0.5</td>\n",
       "      <td>2.8</td>\n",
       "      <td>149.0</td>\n",
       "      <td>528.0</td>\n",
       "      <td>No station</td>\n",
       "      <td>78.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1987-02-09</td>\n",
       "      <td>56</td>\n",
       "      <td>1987-09-02 00:00:00</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Industrial</td>\n",
       "      <td>2.5</td>\n",
       "      <td>12.8</td>\n",
       "      <td>149.0</td>\n",
       "      <td>506.0</td>\n",
       "      <td>No station</td>\n",
       "      <td>78.0</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>2015-12-16</td>\n",
       "      <td>531</td>\n",
       "      <td>16-12-15</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>4.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>246.0</td>\n",
       "      <td>647.0</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>116.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-12-21</td>\n",
       "      <td>531</td>\n",
       "      <td>21-12-15</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>4.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>269.0</td>\n",
       "      <td>647.0</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>116.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-12-28</td>\n",
       "      <td>531</td>\n",
       "      <td>28-12-15</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>4.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>205.0</td>\n",
       "      <td>647.0</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>116.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-12-29</td>\n",
       "      <td>531</td>\n",
       "      <td>29-12-15</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>5.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>142.0</td>\n",
       "      <td>647.0</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>116.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-12-31</td>\n",
       "      <td>531</td>\n",
       "      <td>31-12-15</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>9.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>420.0</td>\n",
       "      <td>647.0</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>116.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8551 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           stn_code        sampling_date  state location  \\\n",
       "date                                                       \n",
       "1987-01-09       60  1987-09-01 00:00:00  Delhi    Delhi   \n",
       "1987-02-09       59  1987-09-02 00:00:00  Delhi    Delhi   \n",
       "1987-03-09       58  1987-09-03 00:00:00  Delhi    Delhi   \n",
       "1987-03-09       57  1987-09-03 00:00:00  Delhi    Delhi   \n",
       "1987-02-09       56  1987-09-02 00:00:00  Delhi    Delhi   \n",
       "...             ...                  ...    ...      ...   \n",
       "2015-12-16      531             16-12-15  Delhi    Delhi   \n",
       "2015-12-21      531             21-12-15  Delhi    Delhi   \n",
       "2015-12-28      531             28-12-15  Delhi    Delhi   \n",
       "2015-12-29      531             29-12-15  Delhi    Delhi   \n",
       "2015-12-31      531             31-12-15  Delhi    Delhi   \n",
       "\n",
       "                                     agency  \\\n",
       "date                                          \n",
       "1987-01-09  Central Pollution Control Board   \n",
       "1987-02-09  Central Pollution Control Board   \n",
       "1987-03-09  Central Pollution Control Board   \n",
       "1987-03-09  Central Pollution Control Board   \n",
       "1987-02-09  Central Pollution Control Board   \n",
       "...                                     ...   \n",
       "2015-12-16  Central Pollution Control Board   \n",
       "2015-12-21  Central Pollution Control Board   \n",
       "2015-12-28  Central Pollution Control Board   \n",
       "2015-12-29  Central Pollution Control Board   \n",
       "2015-12-31  Central Pollution Control Board   \n",
       "\n",
       "                                          type   so2   no2   rspm    spm  \\\n",
       "date                                                                       \n",
       "1987-01-09                         Residential   8.6  16.2  149.0  323.0   \n",
       "1987-02-09                         Residential   6.5   9.3  149.0  488.0   \n",
       "1987-03-09                          Industrial  25.8  10.4  149.0  487.0   \n",
       "1987-03-09                          Industrial   0.5   2.8  149.0  528.0   \n",
       "1987-02-09                          Industrial   2.5  12.8  149.0  506.0   \n",
       "...                                        ...   ...   ...    ...    ...   \n",
       "2015-12-16  Residential, Rural and other Areas   4.0  56.0  246.0  647.0   \n",
       "2015-12-21  Residential, Rural and other Areas   4.0  54.0  269.0  647.0   \n",
       "2015-12-28  Residential, Rural and other Areas   4.0  53.0  205.0  647.0   \n",
       "2015-12-29  Residential, Rural and other Areas   5.0  43.0  142.0  647.0   \n",
       "2015-12-31  Residential, Rural and other Areas   9.0  44.0  420.0  647.0   \n",
       "\n",
       "           location_monitoring_station  pm2_5  \n",
       "date                                           \n",
       "1987-01-09                  No station   78.0  \n",
       "1987-02-09                  No station   78.0  \n",
       "1987-03-09                  No station   78.0  \n",
       "1987-03-09                  No station   78.0  \n",
       "1987-02-09                  No station   78.0  \n",
       "...                                ...    ...  \n",
       "2015-12-16           Pritampura, Delhi  116.0  \n",
       "2015-12-21           Pritampura, Delhi  116.0  \n",
       "2015-12-28           Pritampura, Delhi  116.0  \n",
       "2015-12-29           Pritampura, Delhi  116.0  \n",
       "2015-12-31           Pritampura, Delhi  116.0  \n",
       "\n",
       "[8551 rows x 12 columns]"
      ]
     },
     "execution_count": 245,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=df.fillna({\n",
    "    'stn_code':'Other',\n",
    "    'location_monitoring_station':'No station',\n",
    "    'State':'Other',\n",
    "    'location':'Other',\n",
    "    'agency':'Unknown',\n",
    "    'type':'Undetermined'\n",
    "    \n",
    "    })\n",
    "df=df.interpolate(method='time')#very good for time index series\n",
    "df.loc[:,'rspm']=df.loc[:,'rspm'].bfill()\n",
    "df.loc[:,'pm2_5']=df.loc[:,'pm2_5'].bfill()# I had to use bfill as for thefirst few years there is no data for rspm and pm2_5(maybe they couldn't measure them at that point of time)\n",
    "\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 246,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "55.0\n",
      "           stn_code        sampling_date  state location  \\\n",
      "date                                                       \n",
      "1987-02-09       55  1987-09-02 00:00:00  Delhi    Delhi   \n",
      "1987-03-10       55  1987-10-03 00:00:00  Delhi    Delhi   \n",
      "1987-02-11       55  1987-11-02 00:00:00  Delhi    Delhi   \n",
      "1987-03-12       55  1987-12-03 00:00:00  Delhi    Delhi   \n",
      "1988-03-08       55  1988-08-03 00:00:00  Delhi    Delhi   \n",
      "...             ...                  ...    ...      ...   \n",
      "2015-12-11       55  2015-11-12 00:00:00  Delhi    Delhi   \n",
      "2015-12-16       55             16-12-15  Delhi    Delhi   \n",
      "2015-12-21       55             21-12-15  Delhi    Delhi   \n",
      "2015-12-29       55             29-12-15  Delhi    Delhi   \n",
      "2015-12-31       55             31-12-15  Delhi    Delhi   \n",
      "\n",
      "                                     agency  \\\n",
      "date                                          \n",
      "1987-02-09  Central Pollution Control Board   \n",
      "1987-03-10  Central Pollution Control Board   \n",
      "1987-02-11  Central Pollution Control Board   \n",
      "1987-03-12  Central Pollution Control Board   \n",
      "1988-03-08  Central Pollution Control Board   \n",
      "...                                     ...   \n",
      "2015-12-11  Central Pollution Control Board   \n",
      "2015-12-16  Central Pollution Control Board   \n",
      "2015-12-21  Central Pollution Control Board   \n",
      "2015-12-29  Central Pollution Control Board   \n",
      "2015-12-31  Central Pollution Control Board   \n",
      "\n",
      "                                          type        so2        no2   rspm  \\\n",
      "date                                                                          \n",
      "1987-02-09                          Industrial  16.400000  17.200000  149.0   \n",
      "1987-03-10                          Industrial  27.000000  20.600000  149.0   \n",
      "1987-02-11                          Industrial   9.400000  24.500000  149.0   \n",
      "1987-03-12                          Industrial  14.200000  30.600000  149.0   \n",
      "1988-03-08                     Industrial Area  13.801102  29.901928  149.0   \n",
      "...                                        ...        ...        ...    ...   \n",
      "2015-12-11  Residential, Rural and other Areas   4.000000  38.000000  428.0   \n",
      "2015-12-16  Residential, Rural and other Areas   4.000000  42.000000  149.0   \n",
      "2015-12-21  Residential, Rural and other Areas   4.000000  43.000000  296.0   \n",
      "2015-12-29  Residential, Rural and other Areas  13.000000  51.000000  253.0   \n",
      "2015-12-31  Residential, Rural and other Areas   9.000000  71.000000  270.0   \n",
      "\n",
      "              spm location_monitoring_station  pm2_5  \n",
      "date                                                  \n",
      "1987-02-09  371.0                  No station   78.0  \n",
      "1987-03-10  396.0                  No station   78.0  \n",
      "1987-02-11  522.0                  No station   78.0  \n",
      "1987-03-12  484.0                  No station   78.0  \n",
      "1988-03-08  133.0                  No station   78.0  \n",
      "...           ...                         ...    ...  \n",
      "2015-12-11  647.0           Nizamuddin, Delhi  116.0  \n",
      "2015-12-16  647.0           Nizamuddin, Delhi  116.0  \n",
      "2015-12-21  647.0           Nizamuddin, Delhi  116.0  \n",
      "2015-12-29  647.0           Nizamuddin, Delhi  116.0  \n",
      "2015-12-31  647.0           Nizamuddin, Delhi  116.0  \n",
      "\n",
      "[537 rows x 12 columns]\n",
      "56.0\n",
      "           stn_code        sampling_date  state location  \\\n",
      "date                                                       \n",
      "1987-02-09       56  1987-09-02 00:00:00  Delhi    Delhi   \n",
      "1987-03-10       56  1987-10-03 00:00:00  Delhi    Delhi   \n",
      "1987-03-11       56  1987-11-03 00:00:00  Delhi    Delhi   \n",
      "1987-01-12       56  1987-12-01 00:00:00  Delhi    Delhi   \n",
      "1988-01-08       56  1988-08-01 00:00:00  Delhi    Delhi   \n",
      "...             ...                  ...    ...      ...   \n",
      "2004-10-12       56  2004-12-10 00:00:00  Delhi    Delhi   \n",
      "2004-12-15       56             15-12-04  Delhi    Delhi   \n",
      "2004-12-20       56             20-12-04  Delhi    Delhi   \n",
      "2004-12-23       56             23-12-04  Delhi    Delhi   \n",
      "2004-12-28       56             28-12-04  Delhi    Delhi   \n",
      "\n",
      "                                     agency  \\\n",
      "date                                          \n",
      "1987-02-09  Central Pollution Control Board   \n",
      "1987-03-10  Central Pollution Control Board   \n",
      "1987-03-11  Central Pollution Control Board   \n",
      "1987-01-12  Central Pollution Control Board   \n",
      "1988-01-08  Central Pollution Control Board   \n",
      "...                                     ...   \n",
      "2004-10-12  Central Pollution Control Board   \n",
      "2004-12-15  Central Pollution Control Board   \n",
      "2004-12-20  Central Pollution Control Board   \n",
      "2004-12-23  Central Pollution Control Board   \n",
      "2004-12-28  Central Pollution Control Board   \n",
      "\n",
      "                                          type        so2        no2    rspm  \\\n",
      "date                                                                           \n",
      "1987-02-09                          Industrial   2.500000  12.800000  149.00   \n",
      "1987-03-10                          Industrial  58.789831  12.900000  149.00   \n",
      "1987-03-11                          Industrial   2.500000  20.500000  149.00   \n",
      "1987-01-12                          Industrial   3.700000  20.700000  149.00   \n",
      "1988-01-08                     Industrial Area  13.867218  30.017631  149.00   \n",
      "...                                        ...        ...        ...     ...   \n",
      "2004-10-12  Residential, Rural and other Areas   9.094181  64.410991   59.33   \n",
      "2004-12-15  Residential, Rural and other Areas   9.770043  63.845474  116.33   \n",
      "2004-12-20  Residential, Rural and other Areas   9.822845  63.801293  130.67   \n",
      "2004-12-23  Residential, Rural and other Areas   9.854526  63.774784  144.00   \n",
      "2004-12-28  Residential, Rural and other Areas   9.907328  63.730603  226.00   \n",
      "\n",
      "              spm location_monitoring_station  pm2_5  \n",
      "date                                                  \n",
      "1987-02-09  506.0                  No station   78.0  \n",
      "1987-03-10  505.0                  No station   78.0  \n",
      "1987-03-11  894.0                  No station   78.0  \n",
      "1987-01-12  909.0                  No station   78.0  \n",
      "1988-01-08  160.0                  No station   78.0  \n",
      "...           ...                         ...    ...  \n",
      "2004-10-12  140.0          Ashok Vihar, Delhi   78.0  \n",
      "2004-12-15  275.0          Ashok Vihar, Delhi   78.0  \n",
      "2004-12-20  257.0          Ashok Vihar, Delhi   78.0  \n",
      "2004-12-23  281.0          Ashok Vihar, Delhi   78.0  \n",
      "2004-12-28  405.0          Ashok Vihar, Delhi   78.0  \n",
      "\n",
      "[304 rows x 12 columns]\n",
      "57.0\n",
      "           stn_code        sampling_date  state location  \\\n",
      "date                                                       \n",
      "1987-03-09       57  1987-09-03 00:00:00  Delhi    Delhi   \n",
      "1987-01-10       57  1987-10-01 00:00:00  Delhi    Delhi   \n",
      "1987-02-11       57  1987-11-02 00:00:00  Delhi    Delhi   \n",
      "1987-03-12       57  1987-12-03 00:00:00  Delhi    Delhi   \n",
      "1988-02-08       57  1988-08-02 00:00:00  Delhi    Delhi   \n",
      "...             ...                  ...    ...      ...   \n",
      "2015-12-09       57  2015-09-12 00:00:00  Delhi    Delhi   \n",
      "2015-12-14       57             14-12-15  Delhi    Delhi   \n",
      "2015-12-17       57             17-12-15  Delhi    Delhi   \n",
      "2015-12-29       57             29-12-15  Delhi    Delhi   \n",
      "2015-12-30       57             30-12-15  Delhi    Delhi   \n",
      "\n",
      "                                     agency             type        so2  \\\n",
      "date                                                                      \n",
      "1987-03-09  Central Pollution Control Board       Industrial   0.500000   \n",
      "1987-01-10  Central Pollution Control Board       Industrial  40.500000   \n",
      "1987-02-11  Central Pollution Control Board       Industrial  46.200000   \n",
      "1987-03-12  Central Pollution Control Board       Industrial  60.400000   \n",
      "1988-02-08  Central Pollution Control Board  Industrial Area  13.833058   \n",
      "...                                     ...              ...        ...   \n",
      "2015-12-09  Central Pollution Control Board  Industrial Area   5.000000   \n",
      "2015-12-14  Central Pollution Control Board  Industrial Area   5.000000   \n",
      "2015-12-17  Central Pollution Control Board  Industrial Area   4.000000   \n",
      "2015-12-29  Central Pollution Control Board  Industrial Area   5.000000   \n",
      "2015-12-30  Central Pollution Control Board  Industrial Area   7.000000   \n",
      "\n",
      "                  no2   rspm    spm location_monitoring_station  pm2_5  \n",
      "date                                                                    \n",
      "1987-03-09   2.800000  149.0  528.0                  No station   78.0  \n",
      "1987-01-10  22.500000  149.0  638.0                  No station   78.0  \n",
      "1987-02-11  33.400000  149.0  777.0                  No station   78.0  \n",
      "1987-03-12  35.400000  149.0  895.0                  No station   78.0  \n",
      "1988-02-08  29.957851  149.0  169.0                  No station   78.0  \n",
      "...               ...    ...    ...                         ...    ...  \n",
      "2015-12-09  82.000000  257.0  647.0        Shahzada Bagh, Delhi  116.0  \n",
      "2015-12-14  85.000000  242.0  647.0        Shahzada Bagh, Delhi  116.0  \n",
      "2015-12-17  69.000000  450.0  647.0        Shahzada Bagh, Delhi  116.0  \n",
      "2015-12-29  52.000000  309.0  647.0        Shahzada Bagh, Delhi  116.0  \n",
      "2015-12-30  43.500000  301.0  647.0        Shahzada Bagh, Delhi  116.0  \n",
      "\n",
      "[534 rows x 12 columns]\n",
      "58.0\n",
      "           stn_code        sampling_date  state location  \\\n",
      "date                                                       \n",
      "1987-03-09       58  1987-09-03 00:00:00  Delhi    Delhi   \n",
      "1987-01-10       58  1987-10-01 00:00:00  Delhi    Delhi   \n",
      "1987-01-11       58  1987-11-01 00:00:00  Delhi    Delhi   \n",
      "1987-01-12       58  1987-12-01 00:00:00  Delhi    Delhi   \n",
      "1988-01-09       58  1988-09-01 00:00:00  Delhi    Delhi   \n",
      "...             ...                  ...    ...      ...   \n",
      "2015-12-10       58  2015-10-12 00:00:00  Delhi    Delhi   \n",
      "2015-12-15       58             15-12-15  Delhi    Delhi   \n",
      "2015-12-18       58             18-12-15  Delhi    Delhi   \n",
      "2015-12-23       58             23-12-15  Delhi    Delhi   \n",
      "2015-12-31       58             31-12-15  Delhi    Delhi   \n",
      "\n",
      "                                     agency             type   so2        no2  \\\n",
      "date                                                                            \n",
      "1987-03-09  Central Pollution Control Board       Industrial  25.8  10.400000   \n",
      "1987-01-10  Central Pollution Control Board       Industrial  27.3  13.200000   \n",
      "1987-01-11  Central Pollution Control Board       Industrial   7.5   8.200000   \n",
      "1987-01-12  Central Pollution Control Board       Industrial  12.9  22.100000   \n",
      "1988-01-09  Central Pollution Control Board  Industrial Area  16.2  16.000000   \n",
      "...                                     ...              ...   ...        ...   \n",
      "2015-12-10  Central Pollution Control Board  Industrial Area   5.0  73.000000   \n",
      "2015-12-15  Central Pollution Control Board  Industrial Area   5.0  87.000000   \n",
      "2015-12-18  Central Pollution Control Board  Industrial Area   4.0  66.000000   \n",
      "2015-12-23  Central Pollution Control Board  Industrial Area   4.0  53.714286   \n",
      "2015-12-31  Central Pollution Control Board  Industrial Area  14.0  49.000000   \n",
      "\n",
      "                  rspm     spm location_monitoring_station  pm2_5  \n",
      "date                                                               \n",
      "1987-03-09  149.000000  487.00                  No station   78.0  \n",
      "1987-01-10  149.000000  372.00                  No station   78.0  \n",
      "1987-01-11  149.000000  601.00                  No station   78.0  \n",
      "1987-01-12  149.000000  566.00                  No station   78.0  \n",
      "1988-01-09  149.000000  236.75                  No station   78.0  \n",
      "...                ...     ...                         ...    ...  \n",
      "2015-12-10  405.000000  647.00             Shahadra, Delhi  116.0  \n",
      "2015-12-15  292.000000  647.00             Shahadra, Delhi  116.0  \n",
      "2015-12-18  229.000000  647.00             Shahadra, Delhi  116.0  \n",
      "2015-12-23  250.714286  647.00             Shahadra, Delhi  116.0  \n",
      "2015-12-31  335.000000  647.00             Shahadra, Delhi  116.0  \n",
      "\n",
      "[529 rows x 12 columns]\n",
      "59.0\n",
      "           stn_code        sampling_date  state location  \\\n",
      "date                                                       \n",
      "1987-02-09       59  1987-09-02 00:00:00  Delhi    Delhi   \n",
      "1987-04-10       59  1987-10-04 00:00:00  Delhi    Delhi   \n",
      "1987-03-11       59  1987-11-03 00:00:00  Delhi    Delhi   \n",
      "1987-01-12       59  1987-12-01 00:00:00  Delhi    Delhi   \n",
      "1988-01-07       59  1988-07-01 00:00:00  Delhi    Delhi   \n",
      "...             ...                  ...    ...      ...   \n",
      "2015-12-10       59  2015-10-12 00:00:00  Delhi    Delhi   \n",
      "2015-12-15       59             15-12-15  Delhi    Delhi   \n",
      "2015-12-18       59             18-12-15  Delhi    Delhi   \n",
      "2015-12-23       59             23-12-15  Delhi    Delhi   \n",
      "2015-12-30       59             30-12-15  Delhi    Delhi   \n",
      "\n",
      "                                     agency  \\\n",
      "date                                          \n",
      "1987-02-09  Central Pollution Control Board   \n",
      "1987-04-10  Central Pollution Control Board   \n",
      "1987-03-11  Central Pollution Control Board   \n",
      "1987-01-12  Central Pollution Control Board   \n",
      "1988-01-07  Central Pollution Control Board   \n",
      "...                                     ...   \n",
      "2015-12-10  Central Pollution Control Board   \n",
      "2015-12-15  Central Pollution Control Board   \n",
      "2015-12-18  Central Pollution Control Board   \n",
      "2015-12-23  Central Pollution Control Board   \n",
      "2015-12-30  Central Pollution Control Board   \n",
      "\n",
      "                                          type       so2        no2   rspm  \\\n",
      "date                                                                         \n",
      "1987-02-09                         Residential   6.50000   9.300000  149.0   \n",
      "1987-04-10                         Residential  14.20000  14.600000  149.0   \n",
      "1987-03-11                         Residential   3.90000  14.300000  149.0   \n",
      "1987-01-12                         Residential  20.70000  26.700000  149.0   \n",
      "1988-01-07  Residential, Rural and other Areas  13.86832  30.019559  149.0   \n",
      "...                                        ...       ...        ...    ...   \n",
      "2015-12-10  Residential, Rural and other Areas   4.00000  59.000000  346.0   \n",
      "2015-12-15  Residential, Rural and other Areas   5.00000  67.000000  638.0   \n",
      "2015-12-18  Residential, Rural and other Areas   4.00000  58.000000  260.0   \n",
      "2015-12-23  Residential, Rural and other Areas   4.00000  56.000000  140.0   \n",
      "2015-12-30  Residential, Rural and other Areas  19.00000  63.000000  283.0   \n",
      "\n",
      "              spm location_monitoring_station  pm2_5  \n",
      "date                                                  \n",
      "1987-02-09  488.0                  No station   78.0  \n",
      "1987-04-10  337.0                  No station   78.0  \n",
      "1987-03-11  571.0                  No station   78.0  \n",
      "1987-01-12  440.0                  No station   78.0  \n",
      "1988-01-07  114.0                  No station   78.0  \n",
      "...           ...                         ...    ...  \n",
      "2015-12-10  647.0            Janakpuri, Delhi  116.0  \n",
      "2015-12-15  647.0            Janakpuri, Delhi  116.0  \n",
      "2015-12-18  647.0            Janakpuri, Delhi  116.0  \n",
      "2015-12-23  647.0            Janakpuri, Delhi  116.0  \n",
      "2015-12-30  647.0            Janakpuri, Delhi  116.0  \n",
      "\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[521 rows x 12 columns]\n",
      "60.0\n",
      "           stn_code        sampling_date  state location  \\\n",
      "date                                                       \n",
      "1987-01-09       60  1987-09-01 00:00:00  Delhi    Delhi   \n",
      "1987-03-10       60  1987-10-03 00:00:00  Delhi    Delhi   \n",
      "1987-02-11       60  1987-11-02 00:00:00  Delhi    Delhi   \n",
      "1987-01-12       60  1987-12-01 00:00:00  Delhi    Delhi   \n",
      "1988-02-08       60  1988-08-02 00:00:00  Delhi    Delhi   \n",
      "...             ...                  ...    ...      ...   \n",
      "2015-12-04       60  2015-04-12 00:00:00  Delhi    Delhi   \n",
      "2015-12-09       60  2015-09-12 00:00:00  Delhi    Delhi   \n",
      "2015-12-17       60             17-12-15  Delhi    Delhi   \n",
      "2015-12-22       60             22-12-15  Delhi    Delhi   \n",
      "2015-12-30       60             30-12-15  Delhi    Delhi   \n",
      "\n",
      "                                     agency  \\\n",
      "date                                          \n",
      "1987-01-09  Central Pollution Control Board   \n",
      "1987-03-10  Central Pollution Control Board   \n",
      "1987-02-11  Central Pollution Control Board   \n",
      "1987-01-12  Central Pollution Control Board   \n",
      "1988-02-08  Central Pollution Control Board   \n",
      "...                                     ...   \n",
      "2015-12-04  Central Pollution Control Board   \n",
      "2015-12-09  Central Pollution Control Board   \n",
      "2015-12-17  Central Pollution Control Board   \n",
      "2015-12-22  Central Pollution Control Board   \n",
      "2015-12-30  Central Pollution Control Board   \n",
      "\n",
      "                                          type        so2        no2   rspm  \\\n",
      "date                                                                          \n",
      "1987-01-09                         Residential   8.600000  16.200000  149.0   \n",
      "1987-03-10                         Residential   3.100000  14.900000  149.0   \n",
      "1987-02-11                         Residential  10.500000  14.200000  149.0   \n",
      "1987-01-12                         Residential   3.500000  30.800000  149.0   \n",
      "1988-02-08  Residential, Rural and other Areas  13.833058  29.957851  149.0   \n",
      "...                                        ...        ...        ...    ...   \n",
      "2015-12-04  Residential, Rural and other Areas   4.000000  49.000000  595.0   \n",
      "2015-12-09  Residential, Rural and other Areas   4.000000  56.000000  349.0   \n",
      "2015-12-17  Residential, Rural and other Areas   4.000000  57.000000  288.0   \n",
      "2015-12-22  Residential, Rural and other Areas   4.000000  58.000000  326.0   \n",
      "2015-12-30  Residential, Rural and other Areas   8.000000  75.000000  331.0   \n",
      "\n",
      "              spm location_monitoring_station  pm2_5  \n",
      "date                                                  \n",
      "1987-01-09  323.0                  No station   78.0  \n",
      "1987-03-10  414.0                  No station   78.0  \n",
      "1987-02-11  435.0                  No station   78.0  \n",
      "1987-01-12  714.0                  No station   78.0  \n",
      "1988-02-08  130.0                  No station   78.0  \n",
      "...           ...                         ...    ...  \n",
      "2015-12-04  647.0            Siri Fort, Delhi  116.0  \n",
      "2015-12-09  647.0            Siri Fort, Delhi  116.0  \n",
      "2015-12-17  647.0            Siri Fort, Delhi  116.0  \n",
      "2015-12-22  647.0            Siri Fort, Delhi  116.0  \n",
      "2015-12-30  647.0            Siri Fort, Delhi  116.0  \n",
      "\n",
      "[536 rows x 12 columns]\n",
      "144.0\n",
      "           stn_code        sampling_date  state location  \\\n",
      "date                                                       \n",
      "1990-01-01      144    January - M011990  Delhi    Delhi   \n",
      "1990-02-01      144   February - M021990  Delhi    Delhi   \n",
      "1990-03-01      144      March - M031990  Delhi    Delhi   \n",
      "1990-04-01      144      April - M041990  Delhi    Delhi   \n",
      "1990-05-01      144        May - M051990  Delhi    Delhi   \n",
      "...             ...                  ...    ...      ...   \n",
      "2015-12-10      144  2015-10-12 00:00:00  Delhi    Delhi   \n",
      "2015-12-16      144             16-12-15  Delhi    Delhi   \n",
      "2015-12-17      144             17-12-15  Delhi    Delhi   \n",
      "2015-12-29      144             29-12-15  Delhi    Delhi   \n",
      "2015-12-30      144             30-12-15  Delhi    Delhi   \n",
      "\n",
      "                                                       agency  \\\n",
      "date                                                            \n",
      "1990-01-01                                            Unknown   \n",
      "1990-02-01                                            Unknown   \n",
      "1990-03-01                                            Unknown   \n",
      "1990-04-01                                            Unknown   \n",
      "1990-05-01                                            Unknown   \n",
      "...                                                       ...   \n",
      "2015-12-10  National Environmental Engineering Research In...   \n",
      "2015-12-16  National Environmental Engineering Research In...   \n",
      "2015-12-17  National Environmental Engineering Research In...   \n",
      "2015-12-29  National Environmental Engineering Research In...   \n",
      "2015-12-30  National Environmental Engineering Research In...   \n",
      "\n",
      "                                          type   so2    no2   rspm    spm  \\\n",
      "date                                                                        \n",
      "1990-01-01  Residential, Rural and other Areas  34.2   52.1  149.0  263.0   \n",
      "1990-02-01  Residential, Rural and other Areas  29.5   47.5  149.0  261.0   \n",
      "1990-03-01  Residential, Rural and other Areas  19.4   38.0  149.0  294.0   \n",
      "1990-04-01  Residential, Rural and other Areas  27.3   30.3  149.0  305.0   \n",
      "1990-05-01  Residential, Rural and other Areas  15.4   43.3  149.0  650.0   \n",
      "...                                        ...   ...    ...    ...    ...   \n",
      "2015-12-10  Residential, Rural and other Areas   2.0  122.0  280.0  647.0   \n",
      "2015-12-16  Residential, Rural and other Areas   2.0  161.0  284.0  647.0   \n",
      "2015-12-17  Residential, Rural and other Areas   2.0  208.0  386.0  647.0   \n",
      "2015-12-29  Residential, Rural and other Areas  21.0  152.0  253.0  647.0   \n",
      "2015-12-30  Residential, Rural and other Areas  19.0  145.0  311.0  647.0   \n",
      "\n",
      "                   location_monitoring_station  pm2_5  \n",
      "date                                                   \n",
      "1990-01-01                          No station   78.0  \n",
      "1990-02-01                          No station   78.0  \n",
      "1990-03-01                          No station   78.0  \n",
      "1990-04-01                          No station   78.0  \n",
      "1990-05-01                          No station   78.0  \n",
      "...                                        ...    ...  \n",
      "2015-12-10  N.Y. SCHOOL, Sarojini Nagar, Delhi  116.0  \n",
      "2015-12-16  N.Y. SCHOOL, Sarojini Nagar, Delhi  116.0  \n",
      "2015-12-17  N.Y. SCHOOL, Sarojini Nagar, Delhi  116.0  \n",
      "2015-12-29  N.Y. SCHOOL, Sarojini Nagar, Delhi  116.0  \n",
      "2015-12-30  N.Y. SCHOOL, Sarojini Nagar, Delhi  116.0  \n",
      "\n",
      "[699 rows x 12 columns]\n",
      "145.0\n",
      "           stn_code        sampling_date  state location   agency  \\\n",
      "date                                                                \n",
      "1990-01-01      145    January - M011990  Delhi    Delhi  Unknown   \n",
      "1990-02-01      145   February - M021990  Delhi    Delhi  Unknown   \n",
      "1990-03-01      145      March - M031990  Delhi    Delhi  Unknown   \n",
      "1990-04-01      145      April - M041990  Delhi    Delhi  Unknown   \n",
      "1990-05-01      145        May - M051990  Delhi    Delhi  Unknown   \n",
      "...             ...                  ...    ...      ...      ...   \n",
      "2003-10-12      145  2003-12-10 00:00:00  Delhi    Delhi  Unknown   \n",
      "2003-12-16      145             16-12-03  Delhi    Delhi  Unknown   \n",
      "2003-12-17      145             17-12-03  Delhi    Delhi  Unknown   \n",
      "2003-12-27      145             27-12-03  Delhi    Delhi  Unknown   \n",
      "2003-12-28      145             28-12-03  Delhi    Delhi  Unknown   \n",
      "\n",
      "                       type   so2   no2        rspm    spm  \\\n",
      "date                                                         \n",
      "1990-01-01  Industrial Area  21.7  36.0  149.000000  277.0   \n",
      "1990-02-01  Industrial Area  41.3  36.5  149.000000  264.0   \n",
      "1990-03-01  Industrial Area  56.0  56.5  149.000000  412.0   \n",
      "1990-04-01  Industrial Area  43.0  36.4  149.000000  494.0   \n",
      "1990-05-01  Industrial Area  50.0  69.7  149.000000  776.0   \n",
      "...                     ...   ...   ...         ...    ...   \n",
      "2003-10-12  Industrial Area  13.0  71.0  119.098039  447.0   \n",
      "2003-12-16  Industrial Area  11.0  51.0   55.333333  311.0   \n",
      "2003-12-17  Industrial Area   6.0  52.0   59.666667  310.0   \n",
      "2003-12-27  Industrial Area  18.0  54.0  266.333333  505.0   \n",
      "2003-12-28  Industrial Area  12.0  52.0  277.666667  489.0   \n",
      "\n",
      "           location_monitoring_station  pm2_5  \n",
      "date                                           \n",
      "1990-01-01                  No station   78.0  \n",
      "1990-02-01                  No station   78.0  \n",
      "1990-03-01                  No station   78.0  \n",
      "1990-04-01                  No station   78.0  \n",
      "1990-05-01                  No station   78.0  \n",
      "...                                ...    ...  \n",
      "2003-10-12                  No station   78.0  \n",
      "2003-12-16                  No station   78.0  \n",
      "2003-12-17                  No station   78.0  \n",
      "2003-12-27                  No station   78.0  \n",
      "2003-12-28                  No station   78.0  \n",
      "\n",
      "[192 rows x 12 columns]\n",
      "146.0\n",
      "           stn_code       sampling_date  state location  \\\n",
      "date                                                      \n",
      "1990-01-01      146   January - M011990  Delhi    Delhi   \n",
      "1990-02-01      146  February - M021990  Delhi    Delhi   \n",
      "1990-03-01      146     March - M031990  Delhi    Delhi   \n",
      "1990-04-01      146     April - M041990  Delhi    Delhi   \n",
      "1990-05-01      146       May - M051990  Delhi    Delhi   \n",
      "...             ...                 ...    ...      ...   \n",
      "2015-12-15      146            15-12-15  Delhi    Delhi   \n",
      "2015-12-16      146            16-12-15  Delhi    Delhi   \n",
      "2015-12-17      146            17-12-15  Delhi    Delhi   \n",
      "2015-12-29      146            29-12-15  Delhi    Delhi   \n",
      "2015-12-30      146            30-12-15  Delhi    Delhi   \n",
      "\n",
      "                                                       agency  \\\n",
      "date                                                            \n",
      "1990-01-01                                            Unknown   \n",
      "1990-02-01                                            Unknown   \n",
      "1990-03-01                                            Unknown   \n",
      "1990-04-01                                            Unknown   \n",
      "1990-05-01                                            Unknown   \n",
      "...                                                       ...   \n",
      "2015-12-15  National Environmental Engineering Research In...   \n",
      "2015-12-16  National Environmental Engineering Research In...   \n",
      "2015-12-17  National Environmental Engineering Research In...   \n",
      "2015-12-29  National Environmental Engineering Research In...   \n",
      "2015-12-30  National Environmental Engineering Research In...   \n",
      "\n",
      "                                          type   so2    no2   rspm    spm  \\\n",
      "date                                                                        \n",
      "1990-01-01  Residential, Rural and other Areas  44.3   56.7  149.0  393.0   \n",
      "1990-02-01  Residential, Rural and other Areas  23.5   39.6  149.0  424.0   \n",
      "1990-03-01  Residential, Rural and other Areas  33.5   40.8  149.0  344.0   \n",
      "1990-04-01  Residential, Rural and other Areas  49.7   45.1  149.0  484.0   \n",
      "1990-05-01  Residential, Rural and other Areas  38.5   66.3  149.0  954.0   \n",
      "...                                        ...   ...    ...    ...    ...   \n",
      "2015-12-15  Residential, Rural and other Areas   5.0  136.0  264.0  647.0   \n",
      "2015-12-16  Residential, Rural and other Areas  13.0  178.0  346.0  647.0   \n",
      "2015-12-17  Residential, Rural and other Areas   3.0  174.0  346.0  647.0   \n",
      "2015-12-29  Residential, Rural and other Areas   2.0  130.0  271.0  647.0   \n",
      "2015-12-30  Residential, Rural and other Areas   2.0  161.0  318.0  647.0   \n",
      "\n",
      "                                  location_monitoring_station  pm2_5  \n",
      "date                                                                  \n",
      "1990-01-01                                         No station   78.0  \n",
      "1990-02-01                                         No station   78.0  \n",
      "1990-03-01                                         No station   78.0  \n",
      "1990-04-01                                         No station   78.0  \n",
      "1990-05-01                                         No station   78.0  \n",
      "...                                                       ...    ...  \n",
      "2015-12-15  Town Hall, Ayurvedic Dispensary, Chandni Chowk...  116.0  \n",
      "2015-12-16  Town Hall, Ayurvedic Dispensary, Chandni Chowk...  116.0  \n",
      "2015-12-17  Town Hall, Ayurvedic Dispensary, Chandni Chowk...  116.0  \n",
      "2015-12-29  Town Hall, Ayurvedic Dispensary, Chandni Chowk...  116.0  \n",
      "2015-12-30  Town Hall, Ayurvedic Dispensary, Chandni Chowk...  116.0  \n",
      "\n",
      "[701 rows x 12 columns]\n",
      "345.0\n",
      "           stn_code        sampling_date  state location  \\\n",
      "date                                                       \n",
      "2011-04-01      345  2011-01-04 00:00:00  Delhi    Delhi   \n",
      "2011-05-01      345  2011-01-05 00:00:00  Delhi    Delhi   \n",
      "2011-01-18      345           18/01/2011  Delhi    Delhi   \n",
      "2011-01-19      345           19/01/2011  Delhi    Delhi   \n",
      "2011-01-20      345           20/01/2011  Delhi    Delhi   \n",
      "...             ...                  ...    ...      ...   \n",
      "2015-12-08      345  2015-08-12 00:00:00  Delhi    Delhi   \n",
      "2015-12-14      345             14-12-15  Delhi    Delhi   \n",
      "2015-12-15      345             15-12-15  Delhi    Delhi   \n",
      "2015-12-21      345             21-12-15  Delhi    Delhi   \n",
      "2015-12-22      345             22-12-15  Delhi    Delhi   \n",
      "\n",
      "                                                       agency  \\\n",
      "date                                                            \n",
      "2011-04-01  National Environmental Engineering Research In...   \n",
      "2011-05-01  National Environmental Engineering Research In...   \n",
      "2011-01-18  National Environmental Engineering Research In...   \n",
      "2011-01-19  National Environmental Engineering Research In...   \n",
      "2011-01-20  National Environmental Engineering Research In...   \n",
      "...                                                       ...   \n",
      "2015-12-08  National Environmental Engineering Research In...   \n",
      "2015-12-14  National Environmental Engineering Research In...   \n",
      "2015-12-15  National Environmental Engineering Research In...   \n",
      "2015-12-21  National Environmental Engineering Research In...   \n",
      "2015-12-22  National Environmental Engineering Research In...   \n",
      "\n",
      "                       type   so2    no2   rspm    spm  \\\n",
      "date                                                     \n",
      "2011-04-01  Industrial Area  23.0   52.0  219.0  647.0   \n",
      "2011-05-01  Industrial Area  32.0   56.0  271.0  647.0   \n",
      "2011-01-18  Industrial Area  22.0  108.0  252.0  647.0   \n",
      "2011-01-19  Industrial Area  15.0  104.0  212.0  647.0   \n",
      "2011-01-20  Industrial Area  15.0  113.0  383.0  647.0   \n",
      "...                     ...   ...    ...    ...    ...   \n",
      "2015-12-08  Industrial Area   2.0  159.0  451.0  647.0   \n",
      "2015-12-14  Industrial Area   2.0   99.0  321.0  647.0   \n",
      "2015-12-15  Industrial Area   8.0  106.0  375.0  647.0   \n",
      "2015-12-21  Industrial Area   2.0  199.0  573.0  647.0   \n",
      "2015-12-22  Industrial Area  28.0  223.0  616.0  647.0   \n",
      "\n",
      "                location_monitoring_station  pm2_5  \n",
      "date                                                \n",
      "2011-04-01  Mayapuri Industrial Area, Delhi   78.0  \n",
      "2011-05-01  Mayapuri Industrial Area, Delhi   78.0  \n",
      "2011-01-18  Mayapuri Industrial Area, Delhi   78.0  \n",
      "2011-01-19  Mayapuri Industrial Area, Delhi   78.0  \n",
      "2011-01-20  Mayapuri Industrial Area, Delhi   78.0  \n",
      "...                                     ...    ...  \n",
      "2015-12-08  Mayapuri Industrial Area, Delhi  116.0  \n",
      "2015-12-14  Mayapuri Industrial Area, Delhi  116.0  \n",
      "2015-12-15  Mayapuri Industrial Area, Delhi  116.0  \n",
      "2015-12-21  Mayapuri Industrial Area, Delhi  116.0  \n",
      "2015-12-22  Mayapuri Industrial Area, Delhi  116.0  \n",
      "\n",
      "[463 rows x 12 columns]\n",
      "531.0\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "           stn_code        sampling_date  state location  \\\n",
      "date                                                       \n",
      "2011-04-01      531  2011-01-04 00:00:00  Delhi    Delhi   \n",
      "2011-07-01      531  2011-01-07 00:00:00  Delhi    Delhi   \n",
      "2011-12-01      531  2011-01-12 00:00:00  Delhi    Delhi   \n",
      "2011-01-17      531           17/01/2011  Delhi    Delhi   \n",
      "2011-01-20      531           20/01/2011  Delhi    Delhi   \n",
      "...             ...                  ...    ...      ...   \n",
      "2015-12-16      531             16-12-15  Delhi    Delhi   \n",
      "2015-12-21      531             21-12-15  Delhi    Delhi   \n",
      "2015-12-28      531             28-12-15  Delhi    Delhi   \n",
      "2015-12-29      531             29-12-15  Delhi    Delhi   \n",
      "2015-12-31      531             31-12-15  Delhi    Delhi   \n",
      "\n",
      "                                     agency  \\\n",
      "date                                          \n",
      "2011-04-01  Central Pollution Control Board   \n",
      "2011-07-01  Central Pollution Control Board   \n",
      "2011-12-01  Central Pollution Control Board   \n",
      "2011-01-17  Central Pollution Control Board   \n",
      "2011-01-20  Central Pollution Control Board   \n",
      "...                                     ...   \n",
      "2015-12-16  Central Pollution Control Board   \n",
      "2015-12-21  Central Pollution Control Board   \n",
      "2015-12-28  Central Pollution Control Board   \n",
      "2015-12-29  Central Pollution Control Board   \n",
      "2015-12-31  Central Pollution Control Board   \n",
      "\n",
      "                                          type  so2   no2   rspm    spm  \\\n",
      "date                                                                      \n",
      "2011-04-01  Residential, Rural and other Areas  4.0  38.0  109.0  647.0   \n",
      "2011-07-01  Residential, Rural and other Areas  4.0  44.0  331.0  647.0   \n",
      "2011-12-01  Residential, Rural and other Areas  5.0  52.0  193.0  647.0   \n",
      "2011-01-17  Residential, Rural and other Areas  5.0  43.0  264.0  647.0   \n",
      "2011-01-20  Residential, Rural and other Areas  5.0  41.0  225.0  647.0   \n",
      "...                                        ...  ...   ...    ...    ...   \n",
      "2015-12-16  Residential, Rural and other Areas  4.0  56.0  246.0  647.0   \n",
      "2015-12-21  Residential, Rural and other Areas  4.0  54.0  269.0  647.0   \n",
      "2015-12-28  Residential, Rural and other Areas  4.0  53.0  205.0  647.0   \n",
      "2015-12-29  Residential, Rural and other Areas  5.0  43.0  142.0  647.0   \n",
      "2015-12-31  Residential, Rural and other Areas  9.0  44.0  420.0  647.0   \n",
      "\n",
      "           location_monitoring_station  pm2_5  \n",
      "date                                           \n",
      "2011-04-01           Pritampura, Delhi   78.0  \n",
      "2011-07-01           Pritampura, Delhi   78.0  \n",
      "2011-12-01           Pritampura, Delhi   78.0  \n",
      "2011-01-17           Pritampura, Delhi   78.0  \n",
      "2011-01-20           Pritampura, Delhi   78.0  \n",
      "...                                ...    ...  \n",
      "2015-12-16           Pritampura, Delhi  116.0  \n",
      "2015-12-21           Pritampura, Delhi  116.0  \n",
      "2015-12-28           Pritampura, Delhi  116.0  \n",
      "2015-12-29           Pritampura, Delhi  116.0  \n",
      "2015-12-31           Pritampura, Delhi  116.0  \n",
      "\n",
      "[230 rows x 12 columns]\n",
      "Other\n",
      "           stn_code        sampling_date  state location   agency  \\\n",
      "date                                                                \n",
      "2005-04-01    Other  2005-01-04 00:00:00  Delhi    Delhi  Unknown   \n",
      "2005-05-01    Other  2005-01-05 00:00:00  Delhi    Delhi  Unknown   \n",
      "2005-01-14    Other             14-01-05  Delhi    Delhi  Unknown   \n",
      "2005-01-15    Other             15-01-05  Delhi    Delhi  Unknown   \n",
      "2005-01-18    Other             18-01-05  Delhi    Delhi  Unknown   \n",
      "...             ...                  ...    ...      ...      ...   \n",
      "2009-12-23    Other           23/12/2009  Delhi    Delhi  Unknown   \n",
      "2009-12-24    Other           24/12/2009  Delhi    Delhi  Unknown   \n",
      "2009-12-25    Other           25/12/2009  Delhi    Delhi  Unknown   \n",
      "2009-12-26    Other           26/12/2009  Delhi    Delhi  Unknown   \n",
      "2009-12-27    Other           27/12/2009  Delhi    Delhi  Unknown   \n",
      "\n",
      "                              type   so2   no2   rspm    spm  \\\n",
      "date                                                           \n",
      "2005-04-01        Industrial Areas  10.9  62.9  203.0  384.0   \n",
      "2005-05-01        Industrial Areas  25.1  64.1  381.0  601.0   \n",
      "2005-01-14        Industrial Areas  15.9  58.1  217.0  479.0   \n",
      "2005-01-15        Industrial Areas  17.5  77.8  246.0  558.0   \n",
      "2005-01-18        Industrial Areas   8.5  70.0  306.0  574.0   \n",
      "...                            ...   ...   ...    ...    ...   \n",
      "2009-12-23  Residential and others  13.7  94.0  587.0  976.0   \n",
      "2009-12-24  Residential and others  15.7  80.7  474.0  659.0   \n",
      "2009-12-25  Residential and others   9.2  98.5  537.0  869.0   \n",
      "2009-12-26  Residential and others  16.8  97.3  586.0  821.0   \n",
      "2009-12-27  Residential and others  28.5  87.7  468.0  647.0   \n",
      "\n",
      "           location_monitoring_station  pm2_5  \n",
      "date                                           \n",
      "2005-04-01         Mayapuri Indl. Area   78.0  \n",
      "2005-05-01         Mayapuri Indl. Area   78.0  \n",
      "2005-01-14         Mayapuri Indl. Area   78.0  \n",
      "2005-01-15         Mayapuri Indl. Area   78.0  \n",
      "2005-01-18         Mayapuri Indl. Area   78.0  \n",
      "...                                ...    ...  \n",
      "2009-12-23                   Town Hall   78.0  \n",
      "2009-12-24                   Town Hall   78.0  \n",
      "2009-12-25                   Town Hall   78.0  \n",
      "2009-12-26                   Town Hall   78.0  \n",
      "2009-12-27                   Town Hall   78.0  \n",
      "\n",
      "[3305 rows x 12 columns]\n"
     ]
    }
   ],
   "source": [
    "g=df.groupby('stn_code') #grouping stn_code-wise\n",
    "for code,code_df in g:\n",
    "    print(code)\n",
    "    print(code_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 247,
   "metadata": {},
   "outputs": [],
   "source": [
    "p=g.get_group(60.0)#I am starting of with only stn_code 60, once I finsih all the visualization and applying techniques on it, I will apply it all on"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 248,
   "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>stn_code</th>\n",
       "      <th>sampling_date</th>\n",
       "      <th>state</th>\n",
       "      <th>location</th>\n",
       "      <th>agency</th>\n",
       "      <th>type</th>\n",
       "      <th>so2</th>\n",
       "      <th>no2</th>\n",
       "      <th>rspm</th>\n",
       "      <th>spm</th>\n",
       "      <th>location_monitoring_station</th>\n",
       "      <th>pm2_5</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>1987-01-09</td>\n",
       "      <td>60</td>\n",
       "      <td>1987-09-01 00:00:00</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential</td>\n",
       "      <td>8.600000</td>\n",
       "      <td>16.200000</td>\n",
       "      <td>149.0</td>\n",
       "      <td>323.0</td>\n",
       "      <td>No station</td>\n",
       "      <td>78.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1987-03-10</td>\n",
       "      <td>60</td>\n",
       "      <td>1987-10-03 00:00:00</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential</td>\n",
       "      <td>3.100000</td>\n",
       "      <td>14.900000</td>\n",
       "      <td>149.0</td>\n",
       "      <td>414.0</td>\n",
       "      <td>No station</td>\n",
       "      <td>78.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1987-02-11</td>\n",
       "      <td>60</td>\n",
       "      <td>1987-11-02 00:00:00</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential</td>\n",
       "      <td>10.500000</td>\n",
       "      <td>14.200000</td>\n",
       "      <td>149.0</td>\n",
       "      <td>435.0</td>\n",
       "      <td>No station</td>\n",
       "      <td>78.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1987-01-12</td>\n",
       "      <td>60</td>\n",
       "      <td>1987-12-01 00:00:00</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>30.800000</td>\n",
       "      <td>149.0</td>\n",
       "      <td>714.0</td>\n",
       "      <td>No station</td>\n",
       "      <td>78.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1988-02-08</td>\n",
       "      <td>60</td>\n",
       "      <td>1988-08-02 00:00:00</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>13.833058</td>\n",
       "      <td>29.957851</td>\n",
       "      <td>149.0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>No station</td>\n",
       "      <td>78.0</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>2015-12-04</td>\n",
       "      <td>60</td>\n",
       "      <td>2015-04-12 00:00:00</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>49.000000</td>\n",
       "      <td>595.0</td>\n",
       "      <td>647.0</td>\n",
       "      <td>Siri Fort, Delhi</td>\n",
       "      <td>116.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-12-09</td>\n",
       "      <td>60</td>\n",
       "      <td>2015-09-12 00:00:00</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>56.000000</td>\n",
       "      <td>349.0</td>\n",
       "      <td>647.0</td>\n",
       "      <td>Siri Fort, Delhi</td>\n",
       "      <td>116.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-12-17</td>\n",
       "      <td>60</td>\n",
       "      <td>17-12-15</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>57.000000</td>\n",
       "      <td>288.0</td>\n",
       "      <td>647.0</td>\n",
       "      <td>Siri Fort, Delhi</td>\n",
       "      <td>116.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-12-22</td>\n",
       "      <td>60</td>\n",
       "      <td>22-12-15</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>58.000000</td>\n",
       "      <td>326.0</td>\n",
       "      <td>647.0</td>\n",
       "      <td>Siri Fort, Delhi</td>\n",
       "      <td>116.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2015-12-30</td>\n",
       "      <td>60</td>\n",
       "      <td>30-12-15</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>331.0</td>\n",
       "      <td>647.0</td>\n",
       "      <td>Siri Fort, Delhi</td>\n",
       "      <td>116.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>536 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           stn_code        sampling_date  state location  \\\n",
       "date                                                       \n",
       "1987-01-09       60  1987-09-01 00:00:00  Delhi    Delhi   \n",
       "1987-03-10       60  1987-10-03 00:00:00  Delhi    Delhi   \n",
       "1987-02-11       60  1987-11-02 00:00:00  Delhi    Delhi   \n",
       "1987-01-12       60  1987-12-01 00:00:00  Delhi    Delhi   \n",
       "1988-02-08       60  1988-08-02 00:00:00  Delhi    Delhi   \n",
       "...             ...                  ...    ...      ...   \n",
       "2015-12-04       60  2015-04-12 00:00:00  Delhi    Delhi   \n",
       "2015-12-09       60  2015-09-12 00:00:00  Delhi    Delhi   \n",
       "2015-12-17       60             17-12-15  Delhi    Delhi   \n",
       "2015-12-22       60             22-12-15  Delhi    Delhi   \n",
       "2015-12-30       60             30-12-15  Delhi    Delhi   \n",
       "\n",
       "                                     agency  \\\n",
       "date                                          \n",
       "1987-01-09  Central Pollution Control Board   \n",
       "1987-03-10  Central Pollution Control Board   \n",
       "1987-02-11  Central Pollution Control Board   \n",
       "1987-01-12  Central Pollution Control Board   \n",
       "1988-02-08  Central Pollution Control Board   \n",
       "...                                     ...   \n",
       "2015-12-04  Central Pollution Control Board   \n",
       "2015-12-09  Central Pollution Control Board   \n",
       "2015-12-17  Central Pollution Control Board   \n",
       "2015-12-22  Central Pollution Control Board   \n",
       "2015-12-30  Central Pollution Control Board   \n",
       "\n",
       "                                          type        so2        no2   rspm  \\\n",
       "date                                                                          \n",
       "1987-01-09                         Residential   8.600000  16.200000  149.0   \n",
       "1987-03-10                         Residential   3.100000  14.900000  149.0   \n",
       "1987-02-11                         Residential  10.500000  14.200000  149.0   \n",
       "1987-01-12                         Residential   3.500000  30.800000  149.0   \n",
       "1988-02-08  Residential, Rural and other Areas  13.833058  29.957851  149.0   \n",
       "...                                        ...        ...        ...    ...   \n",
       "2015-12-04  Residential, Rural and other Areas   4.000000  49.000000  595.0   \n",
       "2015-12-09  Residential, Rural and other Areas   4.000000  56.000000  349.0   \n",
       "2015-12-17  Residential, Rural and other Areas   4.000000  57.000000  288.0   \n",
       "2015-12-22  Residential, Rural and other Areas   4.000000  58.000000  326.0   \n",
       "2015-12-30  Residential, Rural and other Areas   8.000000  75.000000  331.0   \n",
       "\n",
       "              spm location_monitoring_station  pm2_5  \n",
       "date                                                  \n",
       "1987-01-09  323.0                  No station   78.0  \n",
       "1987-03-10  414.0                  No station   78.0  \n",
       "1987-02-11  435.0                  No station   78.0  \n",
       "1987-01-12  714.0                  No station   78.0  \n",
       "1988-02-08  130.0                  No station   78.0  \n",
       "...           ...                         ...    ...  \n",
       "2015-12-04  647.0            Siri Fort, Delhi  116.0  \n",
       "2015-12-09  647.0            Siri Fort, Delhi  116.0  \n",
       "2015-12-17  647.0            Siri Fort, Delhi  116.0  \n",
       "2015-12-22  647.0            Siri Fort, Delhi  116.0  \n",
       "2015-12-30  647.0            Siri Fort, Delhi  116.0  \n",
       "\n",
       "[536 rows x 12 columns]"
      ]
     },
     "execution_count": 248,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "p"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "q=p.groupby('type') #Different areas in that stn_code= Residential, Residential+Rural , Industrial\n",
    "for area,area_df in q:\n",
    "    print(area)\n",
    "#at the end, the report will be classified state_wise-->city_wise-->stn_code__wise-->area__wise  (too detailed??)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Data_Visualization"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 201,
   "metadata": {},
   "outputs": [],
   "source": [
    "d=p.groupby(p.date.dt.year)\n",
    "i=0\n",
    "a=[]\n",
    "b=[]\n",
    "for year,year_df in d:\n",
    "    a.append(year)\n",
    "    b.append(year_df.mean())\n",
    "    i=i+1\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 187,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[1987,\n",
       " 1988,\n",
       " 1990,\n",
       " 1991,\n",
       " 1992,\n",
       " 1993,\n",
       " 1994,\n",
       " 1995,\n",
       " 1996,\n",
       " 1997,\n",
       " 1998,\n",
       " 1999,\n",
       " 2000,\n",
       " 2001,\n",
       " 2002,\n",
       " 2003,\n",
       " 2004,\n",
       " 2011,\n",
       " 2014,\n",
       " 2015]"
      ]
     },
     "execution_count": 187,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "a"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 188,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[stn_code     60.000\n",
       " so2           6.425\n",
       " no2          19.025\n",
       " rspm          0.000\n",
       " spm         471.500\n",
       " pm2_5         0.000\n",
       " dtype: float64, stn_code     60.000\n",
       " so2           2.350\n",
       " no2          19.025\n",
       " rspm          0.000\n",
       " spm         219.500\n",
       " pm2_5         0.000\n",
       " dtype: float64, stn_code     60.000000\n",
       " so2           8.763636\n",
       " no2          21.090909\n",
       " rspm          0.000000\n",
       " spm         304.000000\n",
       " pm2_5         0.000000\n",
       " dtype: float64, stn_code     60.000000\n",
       " so2           8.808333\n",
       " no2          24.383333\n",
       " rspm          0.000000\n",
       " spm         278.250000\n",
       " pm2_5         0.000000\n",
       " dtype: float64, stn_code     60.0000\n",
       " so2          13.8875\n",
       " no2          22.9250\n",
       " rspm          0.0000\n",
       " spm         366.0000\n",
       " pm2_5         0.0000\n",
       " dtype: float64, stn_code    60.000000\n",
       " so2         16.683333\n",
       " no2         31.700000\n",
       " rspm         0.000000\n",
       " spm               NaN\n",
       " pm2_5        0.000000\n",
       " dtype: float64, stn_code     60.00\n",
       " so2          12.62\n",
       " no2          28.56\n",
       " rspm          0.00\n",
       " spm         329.50\n",
       " pm2_5         0.00\n",
       " dtype: float64, stn_code     60.000000\n",
       " so2          14.433333\n",
       " no2          28.875000\n",
       " rspm          0.000000\n",
       " spm         404.083333\n",
       " pm2_5         0.000000\n",
       " dtype: float64, stn_code     60.000000\n",
       " so2          15.075000\n",
       " no2          31.500000\n",
       " rspm          0.000000\n",
       " spm         351.333333\n",
       " pm2_5         0.000000\n",
       " dtype: float64, stn_code     60.000000\n",
       " so2          12.925000\n",
       " no2          29.291667\n",
       " rspm          0.000000\n",
       " spm         366.083333\n",
       " pm2_5         0.000000\n",
       " dtype: float64, stn_code     60.000000\n",
       " so2          15.750000\n",
       " no2          28.008333\n",
       " rspm          0.000000\n",
       " spm         384.250000\n",
       " pm2_5         0.000000\n",
       " dtype: float64, stn_code     60.000000\n",
       " so2          19.366667\n",
       " no2          24.533333\n",
       " rspm          0.000000\n",
       " spm         336.250000\n",
       " pm2_5         0.000000\n",
       " dtype: float64, stn_code     60.000000\n",
       " so2          15.975000\n",
       " no2          24.583333\n",
       " rspm          0.000000\n",
       " spm         225.250000\n",
       " pm2_5         0.000000\n",
       " dtype: float64, stn_code     60.000000\n",
       " so2          13.625000\n",
       " no2          22.341667\n",
       " rspm          0.000000\n",
       " spm         332.833333\n",
       " pm2_5         0.000000\n",
       " dtype: float64, stn_code     60.000000\n",
       " so2          11.966667\n",
       " no2          27.491667\n",
       " rspm          0.000000\n",
       " spm         275.833333\n",
       " pm2_5         0.000000\n",
       " dtype: float64, stn_code     60.000000\n",
       " so2           8.974359\n",
       " no2          32.128205\n",
       " rspm         99.410256\n",
       " spm         268.232877\n",
       " pm2_5         0.000000\n",
       " dtype: float64, stn_code     60.000000\n",
       " so2          11.000000\n",
       " no2          45.000000\n",
       " rspm        116.284103\n",
       " spm         339.058824\n",
       " pm2_5         0.000000\n",
       " dtype: float64, stn_code     60.000000\n",
       " so2           4.320000\n",
       " no2          47.293333\n",
       " rspm        202.493333\n",
       " spm                NaN\n",
       " pm2_5         0.000000\n",
       " dtype: float64, stn_code     60.000000\n",
       " so2           4.000000\n",
       " no2          39.527027\n",
       " rspm        191.945946\n",
       " spm                NaN\n",
       " pm2_5         0.000000\n",
       " dtype: float64, stn_code     60.000000\n",
       " so2           4.054054\n",
       " no2          49.513514\n",
       " rspm        183.770270\n",
       " spm                NaN\n",
       " pm2_5        73.270270\n",
       " dtype: float64]"
      ]
     },
     "execution_count": 188,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "b"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}