DATS 6103 - Individual Project 2 - Amanraj Singh.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "IOPub data rate exceeded.\n",
      "The notebook server will temporarily stop sending output\n",
      "to the client in order to avoid crashing it.\n",
      "To change this limit, set the config variable\n",
      "`--NotebookApp.iopub_data_rate_limit`.\n"
     ]
    }
   ],
   "source": [
    "#India Pollution on different states \n",
    "\n",
    "import math\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as pp\n",
    "import plotly\n",
    "from plotly import tools\n",
    "import plotly.plotly as py\n",
    "import plotly.graph_objs as go\n",
    "py.sign_in('monicams89','Z9lw6RBF9YBbVmD8NUKC')\n",
    "plotly.offline.init_notebook_mode()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sampling_date</th>\n",
       "      <th>State_location</th>\n",
       "      <th>agency</th>\n",
       "      <th>type</th>\n",
       "      <th>so2</th>\n",
       "      <th>no2</th>\n",
       "      <th>pm2_rspm</th>\n",
       "      <th>location_monitoring_station</th>\n",
       "      <th>date</th>\n",
       "      <th>Year</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stn_code</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>796</th>\n",
       "      <td>27-02-15</td>\n",
       "      <td>Madhya Pradesh,Bhopal</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27.0</td>\n",
       "      <td>pm2 174,rspm 174</td>\n",
       "      <td>Kolar Thana, Kolar Road, Bhopal</td>\n",
       "      <td>2/27/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476</th>\n",
       "      <td>20-10-15</td>\n",
       "      <td>West Bengal,Kolkata</td>\n",
       "      <td>West Bengal State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>NaN</td>\n",
       "      <td>93.0</td>\n",
       "      <td>pm2 114,rspm 225</td>\n",
       "      <td>Behala Chowrasta,Kolkata</td>\n",
       "      <td>10/20/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>475</th>\n",
       "      <td>10/11/2015</td>\n",
       "      <td>West Bengal,Kolkata</td>\n",
       "      <td>West Bengal State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>NaN</td>\n",
       "      <td>68.0</td>\n",
       "      <td>pm2 137,rspm 177</td>\n",
       "      <td>Minto Park, Kolkata</td>\n",
       "      <td>11/10/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473</th>\n",
       "      <td>22-10-15</td>\n",
       "      <td>West Bengal,Kolkata</td>\n",
       "      <td>West Bengal State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>NaN</td>\n",
       "      <td>94.0</td>\n",
       "      <td>pm2 97,rspm 205</td>\n",
       "      <td>Moulali, Kolkata</td>\n",
       "      <td>10/22/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>12/11/2015</td>\n",
       "      <td>Delhi,Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>NaN</td>\n",
       "      <td>59.0</td>\n",
       "      <td>pm2 262,rspm 281</td>\n",
       "      <td>Shahadra, Delhi</td>\n",
       "      <td>11/12/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>15-01-15</td>\n",
       "      <td>Delhi,Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>NaN</td>\n",
       "      <td>59.0</td>\n",
       "      <td>pm2 152,rspm 266</td>\n",
       "      <td>Shahadra, Delhi</td>\n",
       "      <td>1/15/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>334</th>\n",
       "      <td>23-02-15</td>\n",
       "      <td>Gujarat,Vadodara</td>\n",
       "      <td>Gujarat State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23.0</td>\n",
       "      <td>pm2 36,rspm 89</td>\n",
       "      <td>CETP Nandesari, Vadodara</td>\n",
       "      <td>2/23/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>531</th>\n",
       "      <td>9/11/2015</td>\n",
       "      <td>Delhi,Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>90.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>pm2 197,rspm 334</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>11/9/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>West Bengal,Howrah</td>\n",
       "      <td>West Bengal State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>84.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>pm2 303,rspm 389</td>\n",
       "      <td>Bator, Howrah</td>\n",
       "      <td>11/11/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>10/11/2015</td>\n",
       "      <td>Bihar,Howrah</td>\n",
       "      <td>West Bengal State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>63.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>pm2 182,rspm 248</td>\n",
       "      <td>Bator, Howrah</td>\n",
       "      <td>11/10/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         sampling_date         State_location  \\\n",
       "stn_code                                        \n",
       "796           27-02-15  Madhya Pradesh,Bhopal   \n",
       "476           20-10-15    West Bengal,Kolkata   \n",
       "475         10/11/2015    West Bengal,Kolkata   \n",
       "473           22-10-15    West Bengal,Kolkata   \n",
       "58          12/11/2015            Delhi,Delhi   \n",
       "58            15-01-15            Delhi,Delhi   \n",
       "334           23-02-15       Gujarat,Vadodara   \n",
       "531          9/11/2015            Delhi,Delhi   \n",
       "11          11/11/2015     West Bengal,Howrah   \n",
       "11          10/11/2015           Bihar,Howrah   \n",
       "\n",
       "                                                agency  \\\n",
       "stn_code                                                 \n",
       "796       Madhya Pradesh State Pollution Control Board   \n",
       "476          West Bengal State Pollution Control Board   \n",
       "475          West Bengal State Pollution Control Board   \n",
       "473          West Bengal State Pollution Control Board   \n",
       "58                     Central Pollution Control Board   \n",
       "58                     Central Pollution Control Board   \n",
       "334              Gujarat State Pollution Control Board   \n",
       "531                    Central Pollution Control Board   \n",
       "11           West Bengal State Pollution Control Board   \n",
       "11           West Bengal State Pollution Control Board   \n",
       "\n",
       "                                        type   so2    no2          pm2_rspm  \\\n",
       "stn_code                                                                      \n",
       "796       Residential, Rural and other Areas   NaN   27.0  pm2 174,rspm 174   \n",
       "476                          Industrial Area   NaN   93.0  pm2 114,rspm 225   \n",
       "475       Residential, Rural and other Areas   NaN   68.0  pm2 137,rspm 177   \n",
       "473       Residential, Rural and other Areas   NaN   94.0   pm2 97,rspm 205   \n",
       "58                           Industrial Area   NaN   59.0  pm2 262,rspm 281   \n",
       "58                           Industrial Area   NaN   59.0  pm2 152,rspm 266   \n",
       "334                          Industrial Area   NaN   23.0    pm2 36,rspm 89   \n",
       "531       Residential, Rural and other Areas  90.0  140.0  pm2 197,rspm 334   \n",
       "11        Residential, Rural and other Areas  84.0  125.0  pm2 303,rspm 389   \n",
       "11        Residential, Rural and other Areas  63.0   90.0  pm2 182,rspm 248   \n",
       "\n",
       "              location_monitoring_station             date  Year  \n",
       "stn_code                                                          \n",
       "796       Kolar Thana, Kolar Road, Bhopal   2/27/2015 0:00  2015  \n",
       "476              Behala Chowrasta,Kolkata  10/20/2015 0:00  2015  \n",
       "475                   Minto Park, Kolkata  11/10/2015 0:00  2015  \n",
       "473                      Moulali, Kolkata  10/22/2015 0:00  2015  \n",
       "58                        Shahadra, Delhi  11/12/2015 0:00  2015  \n",
       "58                        Shahadra, Delhi   1/15/2015 0:00  2015  \n",
       "334              CETP Nandesari, Vadodara   2/23/2015 0:00  2015  \n",
       "531                     Pritampura, Delhi   11/9/2015 0:00  2015  \n",
       "11                          Bator, Howrah  11/11/2015 0:00  2015  \n",
       "11                          Bator, Howrah  11/10/2015 0:00  2015  "
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Read Data excluding p_value column\n",
    "col_names=['stn_code','sampling_date','State_location','agency','type','so2','no2','pm2_rspm','location_monitoring_station','date','Year']\n",
    "indiapoll = pd.read_csv('India_Pollution.csv',encoding=\"cp1252\", index_col=0,header=0,usecols=[0,1,2,3,4,6,7,8,9,10,11],skiprows=5,na_values=\"na\",names=col_names)\n",
    "indiapoll.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(9194, 10)"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Dimension of dataset\n",
    "indiapoll.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(9157, 10)"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Remove Na and blank values\n",
    "indiapoll.dropna(how=\"any\",inplace=True)\n",
    "indiapoll.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sampling_date</th>\n",
       "      <th>State_location</th>\n",
       "      <th>agency</th>\n",
       "      <th>type</th>\n",
       "      <th>so2</th>\n",
       "      <th>no2</th>\n",
       "      <th>pm2_rspm</th>\n",
       "      <th>location_monitoring_station</th>\n",
       "      <th>date</th>\n",
       "      <th>Year</th>\n",
       "      <th>State</th>\n",
       "      <th>location</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stn_code</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>531</th>\n",
       "      <td>9/11/2015</td>\n",
       "      <td>Delhi,Delhi</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>90.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>pm2 197,rspm 334</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>11/9/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>West Bengal,Howrah</td>\n",
       "      <td>West Bengal State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>84.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>pm2 303,rspm 389</td>\n",
       "      <td>Bator, Howrah</td>\n",
       "      <td>11/11/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>West Bengal</td>\n",
       "      <td>Howrah</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>10/11/2015</td>\n",
       "      <td>Bihar,Howrah</td>\n",
       "      <td>West Bengal State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>63.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>pm2 182,rspm 248</td>\n",
       "      <td>Bator, Howrah</td>\n",
       "      <td>11/10/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Bihar</td>\n",
       "      <td>Howrah</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>27-06-15</td>\n",
       "      <td>Chhattisgarh,Nagda</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>56.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>pm2 42,rspm 51</td>\n",
       "      <td>B C I Labour Club, Nagda</td>\n",
       "      <td>6/27/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Chhattisgarh</td>\n",
       "      <td>Nagda</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>3/9/2015</td>\n",
       "      <td>Madhya Pradesh,Nagda</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>40.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>pm2 29,rspm 53</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>9/3/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Madhya Pradesh</td>\n",
       "      <td>Nagda</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>17-09-15</td>\n",
       "      <td>Jharkhand,Nagda</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>39.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>pm2 24.8,rspm 47</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>9/17/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Jharkhand</td>\n",
       "      <td>Nagda</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>15-10-15</td>\n",
       "      <td>Karnataka,Nagda</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>38.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>pm2 32,rspm 55</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>10/15/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Karnataka</td>\n",
       "      <td>Nagda</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>692</th>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>Odisha,Paradeep</td>\n",
       "      <td>Odisha State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>37.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>pm2 122,rspm 306</td>\n",
       "      <td>Over the Guest House of M/s PPL</td>\n",
       "      <td>11/11/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Odisha</td>\n",
       "      <td>Paradeep</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>12/11/2015</td>\n",
       "      <td>Maharashtra,Nagda</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>37.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>pm2 50,rspm 59</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>11/12/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Maharashtra</td>\n",
       "      <td>Nagda</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>1/10/2015</td>\n",
       "      <td>Manipur,Nagda</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>35.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>pm2 29,rspm 55</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>10/1/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Manipur</td>\n",
       "      <td>Nagda</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         sampling_date        State_location  \\\n",
       "stn_code                                       \n",
       "531          9/11/2015           Delhi,Delhi   \n",
       "11          11/11/2015    West Bengal,Howrah   \n",
       "11          10/11/2015          Bihar,Howrah   \n",
       "84            27-06-15    Chhattisgarh,Nagda   \n",
       "82            3/9/2015  Madhya Pradesh,Nagda   \n",
       "82            17-09-15       Jharkhand,Nagda   \n",
       "82            15-10-15       Karnataka,Nagda   \n",
       "692         11/11/2015       Odisha,Paradeep   \n",
       "82          12/11/2015     Maharashtra,Nagda   \n",
       "82           1/10/2015         Manipur,Nagda   \n",
       "\n",
       "                                                agency  \\\n",
       "stn_code                                                 \n",
       "531                    Central Pollution Control Board   \n",
       "11           West Bengal State Pollution Control Board   \n",
       "11           West Bengal State Pollution Control Board   \n",
       "84        Madhya Pradesh State Pollution Control Board   \n",
       "82        Madhya Pradesh State Pollution Control Board   \n",
       "82        Madhya Pradesh State Pollution Control Board   \n",
       "82        Madhya Pradesh State Pollution Control Board   \n",
       "692               Odisha State Pollution Control Board   \n",
       "82        Madhya Pradesh State Pollution Control Board   \n",
       "82        Madhya Pradesh State Pollution Control Board   \n",
       "\n",
       "                                        type   so2    no2          pm2_rspm  \\\n",
       "stn_code                                                                      \n",
       "531       Residential, Rural and other Areas  90.0  140.0  pm2 197,rspm 334   \n",
       "11        Residential, Rural and other Areas  84.0  125.0  pm2 303,rspm 389   \n",
       "11        Residential, Rural and other Areas  63.0   90.0  pm2 182,rspm 248   \n",
       "84        Residential, Rural and other Areas  56.0   27.0    pm2 42,rspm 51   \n",
       "82                           Industrial Area  40.0   21.0    pm2 29,rspm 53   \n",
       "82                           Industrial Area  39.0   18.0  pm2 24.8,rspm 47   \n",
       "82                           Industrial Area  38.0   20.0    pm2 32,rspm 55   \n",
       "692       Residential, Rural and other Areas  37.0   24.0  pm2 122,rspm 306   \n",
       "82                           Industrial Area  37.0   20.0    pm2 50,rspm 59   \n",
       "82                           Industrial Area  35.0   23.0    pm2 29,rspm 55   \n",
       "\n",
       "                   location_monitoring_station             date  Year  \\\n",
       "stn_code                                                                \n",
       "531                          Pritampura, Delhi   11/9/2015 0:00  2015   \n",
       "11                               Bator, Howrah  11/11/2015 0:00  2015   \n",
       "11                               Bator, Howrah  11/10/2015 0:00  2015   \n",
       "84                    B C I Labour Club, Nagda   6/27/2015 0:00  2015   \n",
       "82        Chemical Division Labour Club, Nagda    9/3/2015 0:00  2015   \n",
       "82        Chemical Division Labour Club, Nagda   9/17/2015 0:00  2015   \n",
       "82        Chemical Division Labour Club, Nagda  10/15/2015 0:00  2015   \n",
       "692            Over the Guest House of M/s PPL  11/11/2015 0:00  2015   \n",
       "82        Chemical Division Labour Club, Nagda  11/12/2015 0:00  2015   \n",
       "82        Chemical Division Labour Club, Nagda   10/1/2015 0:00  2015   \n",
       "\n",
       "                   State  location  \n",
       "stn_code                            \n",
       "531                Delhi     Delhi  \n",
       "11           West Bengal    Howrah  \n",
       "11                 Bihar    Howrah  \n",
       "84          Chhattisgarh     Nagda  \n",
       "82        Madhya Pradesh     Nagda  \n",
       "82             Jharkhand     Nagda  \n",
       "82             Karnataka     Nagda  \n",
       "692               Odisha  Paradeep  \n",
       "82           Maharashtra     Nagda  \n",
       "82               Manipur     Nagda  "
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Split state_location column in 2 different attributes state and location\n",
    "\n",
    "indiapoll[['State','location']] = indiapoll['State_location'].str.split(',',expand=True)\n",
    "indiapoll.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Drop State_location column\n",
    "indiapoll.drop('State_location',axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sampling_date</th>\n",
       "      <th>agency</th>\n",
       "      <th>type</th>\n",
       "      <th>so2</th>\n",
       "      <th>no2</th>\n",
       "      <th>pm2_rspm</th>\n",
       "      <th>location_monitoring_station</th>\n",
       "      <th>date</th>\n",
       "      <th>Year</th>\n",
       "      <th>State</th>\n",
       "      <th>location</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stn_code</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>531</th>\n",
       "      <td>9/11/2015</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>90.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>pm2 197,rspm 334</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>11/9/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>West Bengal State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>84.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>pm2 303,rspm 389</td>\n",
       "      <td>Bator, Howrah</td>\n",
       "      <td>11/11/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>West Bengal</td>\n",
       "      <td>Howrah</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>10/11/2015</td>\n",
       "      <td>West Bengal State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>63.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>pm2 182,rspm 248</td>\n",
       "      <td>Bator, Howrah</td>\n",
       "      <td>11/10/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Bihar</td>\n",
       "      <td>Howrah</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>27-06-15</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>56.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>pm2 42,rspm 51</td>\n",
       "      <td>B C I Labour Club, Nagda</td>\n",
       "      <td>6/27/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Chhattisgarh</td>\n",
       "      <td>Nagda</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>3/9/2015</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>40.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>pm2 29,rspm 53</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>9/3/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Madhya Pradesh</td>\n",
       "      <td>Nagda</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>17-09-15</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>39.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>pm2 24.8,rspm 47</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>9/17/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Jharkhand</td>\n",
       "      <td>Nagda</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>15-10-15</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>38.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>pm2 32,rspm 55</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>10/15/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Karnataka</td>\n",
       "      <td>Nagda</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>692</th>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>Odisha State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>37.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>pm2 122,rspm 306</td>\n",
       "      <td>Over the Guest House of M/s PPL</td>\n",
       "      <td>11/11/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Odisha</td>\n",
       "      <td>Paradeep</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>12/11/2015</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>37.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>pm2 50,rspm 59</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>11/12/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Maharashtra</td>\n",
       "      <td>Nagda</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>1/10/2015</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>35.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>pm2 29,rspm 55</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>10/1/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Manipur</td>\n",
       "      <td>Nagda</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         sampling_date                                        agency  \\\n",
       "stn_code                                                               \n",
       "531          9/11/2015               Central Pollution Control Board   \n",
       "11          11/11/2015     West Bengal State Pollution Control Board   \n",
       "11          10/11/2015     West Bengal State Pollution Control Board   \n",
       "84            27-06-15  Madhya Pradesh State Pollution Control Board   \n",
       "82            3/9/2015  Madhya Pradesh State Pollution Control Board   \n",
       "82            17-09-15  Madhya Pradesh State Pollution Control Board   \n",
       "82            15-10-15  Madhya Pradesh State Pollution Control Board   \n",
       "692         11/11/2015          Odisha State Pollution Control Board   \n",
       "82          12/11/2015  Madhya Pradesh State Pollution Control Board   \n",
       "82           1/10/2015  Madhya Pradesh State Pollution Control Board   \n",
       "\n",
       "                                        type   so2    no2          pm2_rspm  \\\n",
       "stn_code                                                                      \n",
       "531       Residential, Rural and other Areas  90.0  140.0  pm2 197,rspm 334   \n",
       "11        Residential, Rural and other Areas  84.0  125.0  pm2 303,rspm 389   \n",
       "11        Residential, Rural and other Areas  63.0   90.0  pm2 182,rspm 248   \n",
       "84        Residential, Rural and other Areas  56.0   27.0    pm2 42,rspm 51   \n",
       "82                           Industrial Area  40.0   21.0    pm2 29,rspm 53   \n",
       "82                           Industrial Area  39.0   18.0  pm2 24.8,rspm 47   \n",
       "82                           Industrial Area  38.0   20.0    pm2 32,rspm 55   \n",
       "692       Residential, Rural and other Areas  37.0   24.0  pm2 122,rspm 306   \n",
       "82                           Industrial Area  37.0   20.0    pm2 50,rspm 59   \n",
       "82                           Industrial Area  35.0   23.0    pm2 29,rspm 55   \n",
       "\n",
       "                   location_monitoring_station             date  Year  \\\n",
       "stn_code                                                                \n",
       "531                          Pritampura, Delhi   11/9/2015 0:00  2015   \n",
       "11                               Bator, Howrah  11/11/2015 0:00  2015   \n",
       "11                               Bator, Howrah  11/10/2015 0:00  2015   \n",
       "84                    B C I Labour Club, Nagda   6/27/2015 0:00  2015   \n",
       "82        Chemical Division Labour Club, Nagda    9/3/2015 0:00  2015   \n",
       "82        Chemical Division Labour Club, Nagda   9/17/2015 0:00  2015   \n",
       "82        Chemical Division Labour Club, Nagda  10/15/2015 0:00  2015   \n",
       "692            Over the Guest House of M/s PPL  11/11/2015 0:00  2015   \n",
       "82        Chemical Division Labour Club, Nagda  11/12/2015 0:00  2015   \n",
       "82        Chemical Division Labour Club, Nagda   10/1/2015 0:00  2015   \n",
       "\n",
       "                   State  location  \n",
       "stn_code                            \n",
       "531                Delhi     Delhi  \n",
       "11           West Bengal    Howrah  \n",
       "11                 Bihar    Howrah  \n",
       "84          Chhattisgarh     Nagda  \n",
       "82        Madhya Pradesh     Nagda  \n",
       "82             Jharkhand     Nagda  \n",
       "82             Karnataka     Nagda  \n",
       "692               Odisha  Paradeep  \n",
       "82           Maharashtra     Nagda  \n",
       "82               Manipur     Nagda  "
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "indiapoll.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sampling_date</th>\n",
       "      <th>agency</th>\n",
       "      <th>type</th>\n",
       "      <th>so2</th>\n",
       "      <th>no2</th>\n",
       "      <th>pm2_rspm</th>\n",
       "      <th>location_monitoring_station</th>\n",
       "      <th>date</th>\n",
       "      <th>Year</th>\n",
       "      <th>State</th>\n",
       "      <th>location</th>\n",
       "      <th>pm2</th>\n",
       "      <th>rspm</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stn_code</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>531</th>\n",
       "      <td>9/11/2015</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>90.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>pm2 197,rspm 334</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>11/9/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>pm2 197</td>\n",
       "      <td>rspm 334</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>West Bengal State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>84.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>pm2 303,rspm 389</td>\n",
       "      <td>Bator, Howrah</td>\n",
       "      <td>11/11/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>West Bengal</td>\n",
       "      <td>Howrah</td>\n",
       "      <td>pm2 303</td>\n",
       "      <td>rspm 389</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>10/11/2015</td>\n",
       "      <td>West Bengal State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>63.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>pm2 182,rspm 248</td>\n",
       "      <td>Bator, Howrah</td>\n",
       "      <td>11/10/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Bihar</td>\n",
       "      <td>Howrah</td>\n",
       "      <td>pm2 182</td>\n",
       "      <td>rspm 248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>27-06-15</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>56.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>pm2 42,rspm 51</td>\n",
       "      <td>B C I Labour Club, Nagda</td>\n",
       "      <td>6/27/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Chhattisgarh</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>pm2 42</td>\n",
       "      <td>rspm 51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>3/9/2015</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>40.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>pm2 29,rspm 53</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>9/3/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Madhya Pradesh</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>pm2 29</td>\n",
       "      <td>rspm 53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>17-09-15</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>39.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>pm2 24.8,rspm 47</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>9/17/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Jharkhand</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>pm2 24.8</td>\n",
       "      <td>rspm 47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>15-10-15</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>38.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>pm2 32,rspm 55</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>10/15/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Karnataka</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>pm2 32</td>\n",
       "      <td>rspm 55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>692</th>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>Odisha State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>37.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>pm2 122,rspm 306</td>\n",
       "      <td>Over the Guest House of M/s PPL</td>\n",
       "      <td>11/11/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Odisha</td>\n",
       "      <td>Paradeep</td>\n",
       "      <td>pm2 122</td>\n",
       "      <td>rspm 306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>12/11/2015</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>37.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>pm2 50,rspm 59</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>11/12/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Maharashtra</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>pm2 50</td>\n",
       "      <td>rspm 59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>1/10/2015</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>35.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>pm2 29,rspm 55</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>10/1/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Manipur</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>pm2 29</td>\n",
       "      <td>rspm 55</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         sampling_date                                        agency  \\\n",
       "stn_code                                                               \n",
       "531          9/11/2015               Central Pollution Control Board   \n",
       "11          11/11/2015     West Bengal State Pollution Control Board   \n",
       "11          10/11/2015     West Bengal State Pollution Control Board   \n",
       "84            27-06-15  Madhya Pradesh State Pollution Control Board   \n",
       "82            3/9/2015  Madhya Pradesh State Pollution Control Board   \n",
       "82            17-09-15  Madhya Pradesh State Pollution Control Board   \n",
       "82            15-10-15  Madhya Pradesh State Pollution Control Board   \n",
       "692         11/11/2015          Odisha State Pollution Control Board   \n",
       "82          12/11/2015  Madhya Pradesh State Pollution Control Board   \n",
       "82           1/10/2015  Madhya Pradesh State Pollution Control Board   \n",
       "\n",
       "                                        type   so2    no2          pm2_rspm  \\\n",
       "stn_code                                                                      \n",
       "531       Residential, Rural and other Areas  90.0  140.0  pm2 197,rspm 334   \n",
       "11        Residential, Rural and other Areas  84.0  125.0  pm2 303,rspm 389   \n",
       "11        Residential, Rural and other Areas  63.0   90.0  pm2 182,rspm 248   \n",
       "84        Residential, Rural and other Areas  56.0   27.0    pm2 42,rspm 51   \n",
       "82                           Industrial Area  40.0   21.0    pm2 29,rspm 53   \n",
       "82                           Industrial Area  39.0   18.0  pm2 24.8,rspm 47   \n",
       "82                           Industrial Area  38.0   20.0    pm2 32,rspm 55   \n",
       "692       Residential, Rural and other Areas  37.0   24.0  pm2 122,rspm 306   \n",
       "82                           Industrial Area  37.0   20.0    pm2 50,rspm 59   \n",
       "82                           Industrial Area  35.0   23.0    pm2 29,rspm 55   \n",
       "\n",
       "                   location_monitoring_station             date  Year  \\\n",
       "stn_code                                                                \n",
       "531                          Pritampura, Delhi   11/9/2015 0:00  2015   \n",
       "11                               Bator, Howrah  11/11/2015 0:00  2015   \n",
       "11                               Bator, Howrah  11/10/2015 0:00  2015   \n",
       "84                    B C I Labour Club, Nagda   6/27/2015 0:00  2015   \n",
       "82        Chemical Division Labour Club, Nagda    9/3/2015 0:00  2015   \n",
       "82        Chemical Division Labour Club, Nagda   9/17/2015 0:00  2015   \n",
       "82        Chemical Division Labour Club, Nagda  10/15/2015 0:00  2015   \n",
       "692            Over the Guest House of M/s PPL  11/11/2015 0:00  2015   \n",
       "82        Chemical Division Labour Club, Nagda  11/12/2015 0:00  2015   \n",
       "82        Chemical Division Labour Club, Nagda   10/1/2015 0:00  2015   \n",
       "\n",
       "                   State  location       pm2      rspm  \n",
       "stn_code                                                \n",
       "531                Delhi     Delhi   pm2 197  rspm 334  \n",
       "11           West Bengal    Howrah   pm2 303  rspm 389  \n",
       "11                 Bihar    Howrah   pm2 182  rspm 248  \n",
       "84          Chhattisgarh     Nagda    pm2 42   rspm 51  \n",
       "82        Madhya Pradesh     Nagda    pm2 29   rspm 53  \n",
       "82             Jharkhand     Nagda  pm2 24.8   rspm 47  \n",
       "82             Karnataka     Nagda    pm2 32   rspm 55  \n",
       "692               Odisha  Paradeep   pm2 122  rspm 306  \n",
       "82           Maharashtra     Nagda    pm2 50   rspm 59  \n",
       "82               Manipur     Nagda    pm2 29   rspm 55  "
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Split pm2 and rspm column\n",
    "indiapoll[['pm2','rspm']] = indiapoll['pm2_rspm'].str.split(',',expand=True)\n",
    "indiapoll.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sampling_date</th>\n",
       "      <th>agency</th>\n",
       "      <th>type</th>\n",
       "      <th>so2</th>\n",
       "      <th>no2</th>\n",
       "      <th>pm2_rspm</th>\n",
       "      <th>location_monitoring_station</th>\n",
       "      <th>date</th>\n",
       "      <th>Year</th>\n",
       "      <th>State</th>\n",
       "      <th>location</th>\n",
       "      <th>pm2</th>\n",
       "      <th>rspm</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stn_code</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>531</th>\n",
       "      <td>9/11/2015</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>90.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>pm2 197,rspm 334</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>11/9/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>197</td>\n",
       "      <td>334</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>West Bengal State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>84.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>pm2 303,rspm 389</td>\n",
       "      <td>Bator, Howrah</td>\n",
       "      <td>11/11/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>West Bengal</td>\n",
       "      <td>Howrah</td>\n",
       "      <td>303</td>\n",
       "      <td>389</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>10/11/2015</td>\n",
       "      <td>West Bengal State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>63.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>pm2 182,rspm 248</td>\n",
       "      <td>Bator, Howrah</td>\n",
       "      <td>11/10/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Bihar</td>\n",
       "      <td>Howrah</td>\n",
       "      <td>182</td>\n",
       "      <td>248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>27-06-15</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>56.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>pm2 42,rspm 51</td>\n",
       "      <td>B C I Labour Club, Nagda</td>\n",
       "      <td>6/27/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Chhattisgarh</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>42</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>3/9/2015</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>40.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>pm2 29,rspm 53</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>9/3/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Madhya Pradesh</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>29</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>17-09-15</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>39.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>pm2 24.8,rspm 47</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>9/17/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Jharkhand</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>24.8</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>15-10-15</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>38.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>pm2 32,rspm 55</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>10/15/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Karnataka</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>32</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>692</th>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>Odisha State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>37.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>pm2 122,rspm 306</td>\n",
       "      <td>Over the Guest House of M/s PPL</td>\n",
       "      <td>11/11/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Odisha</td>\n",
       "      <td>Paradeep</td>\n",
       "      <td>122</td>\n",
       "      <td>306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>12/11/2015</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>37.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>pm2 50,rspm 59</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>11/12/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Maharashtra</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>50</td>\n",
       "      <td>59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>1/10/2015</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>35.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>pm2 29,rspm 55</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>10/1/2015 0:00</td>\n",
       "      <td>2015</td>\n",
       "      <td>Manipur</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>29</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         sampling_date                                        agency  \\\n",
       "stn_code                                                               \n",
       "531          9/11/2015               Central Pollution Control Board   \n",
       "11          11/11/2015     West Bengal State Pollution Control Board   \n",
       "11          10/11/2015     West Bengal State Pollution Control Board   \n",
       "84            27-06-15  Madhya Pradesh State Pollution Control Board   \n",
       "82            3/9/2015  Madhya Pradesh State Pollution Control Board   \n",
       "82            17-09-15  Madhya Pradesh State Pollution Control Board   \n",
       "82            15-10-15  Madhya Pradesh State Pollution Control Board   \n",
       "692         11/11/2015          Odisha State Pollution Control Board   \n",
       "82          12/11/2015  Madhya Pradesh State Pollution Control Board   \n",
       "82           1/10/2015  Madhya Pradesh State Pollution Control Board   \n",
       "\n",
       "                                        type   so2    no2          pm2_rspm  \\\n",
       "stn_code                                                                      \n",
       "531       Residential, Rural and other Areas  90.0  140.0  pm2 197,rspm 334   \n",
       "11        Residential, Rural and other Areas  84.0  125.0  pm2 303,rspm 389   \n",
       "11        Residential, Rural and other Areas  63.0   90.0  pm2 182,rspm 248   \n",
       "84        Residential, Rural and other Areas  56.0   27.0    pm2 42,rspm 51   \n",
       "82                           Industrial Area  40.0   21.0    pm2 29,rspm 53   \n",
       "82                           Industrial Area  39.0   18.0  pm2 24.8,rspm 47   \n",
       "82                           Industrial Area  38.0   20.0    pm2 32,rspm 55   \n",
       "692       Residential, Rural and other Areas  37.0   24.0  pm2 122,rspm 306   \n",
       "82                           Industrial Area  37.0   20.0    pm2 50,rspm 59   \n",
       "82                           Industrial Area  35.0   23.0    pm2 29,rspm 55   \n",
       "\n",
       "                   location_monitoring_station             date  Year  \\\n",
       "stn_code                                                                \n",
       "531                          Pritampura, Delhi   11/9/2015 0:00  2015   \n",
       "11                               Bator, Howrah  11/11/2015 0:00  2015   \n",
       "11                               Bator, Howrah  11/10/2015 0:00  2015   \n",
       "84                    B C I Labour Club, Nagda   6/27/2015 0:00  2015   \n",
       "82        Chemical Division Labour Club, Nagda    9/3/2015 0:00  2015   \n",
       "82        Chemical Division Labour Club, Nagda   9/17/2015 0:00  2015   \n",
       "82        Chemical Division Labour Club, Nagda  10/15/2015 0:00  2015   \n",
       "692            Over the Guest House of M/s PPL  11/11/2015 0:00  2015   \n",
       "82        Chemical Division Labour Club, Nagda  11/12/2015 0:00  2015   \n",
       "82        Chemical Division Labour Club, Nagda   10/1/2015 0:00  2015   \n",
       "\n",
       "                   State  location   pm2 rspm  \n",
       "stn_code                                       \n",
       "531                Delhi     Delhi   197  334  \n",
       "11           West Bengal    Howrah   303  389  \n",
       "11                 Bihar    Howrah   182  248  \n",
       "84          Chhattisgarh     Nagda    42   51  \n",
       "82        Madhya Pradesh     Nagda    29   53  \n",
       "82             Jharkhand     Nagda  24.8   47  \n",
       "82             Karnataka     Nagda    32   55  \n",
       "692               Odisha  Paradeep   122  306  \n",
       "82           Maharashtra     Nagda    50   59  \n",
       "82               Manipur     Nagda    29   55  "
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Split pm2 and rspm column and fetch only value\n",
    "indiapoll['pm2'] = indiapoll['pm2'].str.split().str[-1]\n",
    "indiapoll['rspm'] = indiapoll['rspm'].str.split().str[-1]\n",
    "indiapoll.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#Drop pm2_rspm column\n",
    "indiapoll.drop('pm2_rspm',axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sampling_date</th>\n",
       "      <th>agency</th>\n",
       "      <th>type</th>\n",
       "      <th>so2</th>\n",
       "      <th>no2</th>\n",
       "      <th>location_monitoring_station</th>\n",
       "      <th>date</th>\n",
       "      <th>Year</th>\n",
       "      <th>State</th>\n",
       "      <th>location</th>\n",
       "      <th>pm2</th>\n",
       "      <th>rspm</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stn_code</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>531</th>\n",
       "      <td>9/11/2015</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>90.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>11/9/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>197</td>\n",
       "      <td>334</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>West Bengal State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>84.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>Bator, Howrah</td>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>West Bengal</td>\n",
       "      <td>Howrah</td>\n",
       "      <td>303</td>\n",
       "      <td>389</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>10/11/2015</td>\n",
       "      <td>West Bengal State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>63.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>Bator, Howrah</td>\n",
       "      <td>11/10/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Bihar</td>\n",
       "      <td>Howrah</td>\n",
       "      <td>182</td>\n",
       "      <td>248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>27-06-15</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>56.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>B C I Labour Club, Nagda</td>\n",
       "      <td>6/27/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Chhattisgarh</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>42</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>3/9/2015</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>40.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>9/3/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Madhya Pradesh</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>29</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>17-09-15</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>39.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>9/17/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Jharkhand</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>24.8</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>15-10-15</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>38.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>10/15/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Karnataka</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>32</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>692</th>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>Odisha State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>37.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Over the Guest House of M/s PPL</td>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Odisha</td>\n",
       "      <td>Paradeep</td>\n",
       "      <td>122</td>\n",
       "      <td>306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>12/11/2015</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>37.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>11/12/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Maharashtra</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>50</td>\n",
       "      <td>59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>1/10/2015</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>35.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>10/1/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Manipur</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>29</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         sampling_date                                        agency  \\\n",
       "stn_code                                                               \n",
       "531          9/11/2015               Central Pollution Control Board   \n",
       "11          11/11/2015     West Bengal State Pollution Control Board   \n",
       "11          10/11/2015     West Bengal State Pollution Control Board   \n",
       "84            27-06-15  Madhya Pradesh State Pollution Control Board   \n",
       "82            3/9/2015  Madhya Pradesh State Pollution Control Board   \n",
       "82            17-09-15  Madhya Pradesh State Pollution Control Board   \n",
       "82            15-10-15  Madhya Pradesh State Pollution Control Board   \n",
       "692         11/11/2015          Odisha State Pollution Control Board   \n",
       "82          12/11/2015  Madhya Pradesh State Pollution Control Board   \n",
       "82           1/10/2015  Madhya Pradesh State Pollution Control Board   \n",
       "\n",
       "                                        type   so2    no2  \\\n",
       "stn_code                                                    \n",
       "531       Residential, Rural and other Areas  90.0  140.0   \n",
       "11        Residential, Rural and other Areas  84.0  125.0   \n",
       "11        Residential, Rural and other Areas  63.0   90.0   \n",
       "84        Residential, Rural and other Areas  56.0   27.0   \n",
       "82                           Industrial Area  40.0   21.0   \n",
       "82                           Industrial Area  39.0   18.0   \n",
       "82                           Industrial Area  38.0   20.0   \n",
       "692       Residential, Rural and other Areas  37.0   24.0   \n",
       "82                           Industrial Area  37.0   20.0   \n",
       "82                           Industrial Area  35.0   23.0   \n",
       "\n",
       "                   location_monitoring_station        date  Year  \\\n",
       "stn_code                                                           \n",
       "531                          Pritampura, Delhi   11/9/2015  2015   \n",
       "11                               Bator, Howrah  11/11/2015  2015   \n",
       "11                               Bator, Howrah  11/10/2015  2015   \n",
       "84                    B C I Labour Club, Nagda   6/27/2015  2015   \n",
       "82        Chemical Division Labour Club, Nagda    9/3/2015  2015   \n",
       "82        Chemical Division Labour Club, Nagda   9/17/2015  2015   \n",
       "82        Chemical Division Labour Club, Nagda  10/15/2015  2015   \n",
       "692            Over the Guest House of M/s PPL  11/11/2015  2015   \n",
       "82        Chemical Division Labour Club, Nagda  11/12/2015  2015   \n",
       "82        Chemical Division Labour Club, Nagda   10/1/2015  2015   \n",
       "\n",
       "                   State  location   pm2 rspm  \n",
       "stn_code                                       \n",
       "531                Delhi     Delhi   197  334  \n",
       "11           West Bengal    Howrah   303  389  \n",
       "11                 Bihar    Howrah   182  248  \n",
       "84          Chhattisgarh     Nagda    42   51  \n",
       "82        Madhya Pradesh     Nagda    29   53  \n",
       "82             Jharkhand     Nagda  24.8   47  \n",
       "82             Karnataka     Nagda    32   55  \n",
       "692               Odisha  Paradeep   122  306  \n",
       "82           Maharashtra     Nagda    50   59  \n",
       "82               Manipur     Nagda    29   55  "
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Fetch Date and remove unwanted value\n",
    "indiapoll['date'] = indiapoll['date'].str.split().str[0]\n",
    "indiapoll.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sampling_date</th>\n",
       "      <th>agency</th>\n",
       "      <th>type</th>\n",
       "      <th>so2</th>\n",
       "      <th>no2</th>\n",
       "      <th>location_monitoring_station</th>\n",
       "      <th>date</th>\n",
       "      <th>Year</th>\n",
       "      <th>State</th>\n",
       "      <th>location</th>\n",
       "      <th>pm2</th>\n",
       "      <th>rspm</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stn_code</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>531</th>\n",
       "      <td>9/11/2015</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>90.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>11/9/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>197</td>\n",
       "      <td>334</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>West Bengal State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>84.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>Bator, Howrah</td>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>West Bengal</td>\n",
       "      <td>Howrah</td>\n",
       "      <td>303</td>\n",
       "      <td>389</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>10/11/2015</td>\n",
       "      <td>West Bengal State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>63.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>Bator, Howrah</td>\n",
       "      <td>11/10/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Bihar</td>\n",
       "      <td>Howrah</td>\n",
       "      <td>182</td>\n",
       "      <td>248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>27-06-15</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>56.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>B C I Labour Club, Nagda</td>\n",
       "      <td>6/27/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Chhattisgarh</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>42</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>3/9/2015</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>40.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>9/3/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Madhya Pradesh</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>29</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>17-09-15</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>39.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>9/17/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Jharkhand</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>24.8</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>15-10-15</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>38.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>10/15/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Karnataka</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>32</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>692</th>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>Odisha State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>37.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Over the Guest House of M/s PPL</td>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Odisha</td>\n",
       "      <td>Paradeep</td>\n",
       "      <td>122</td>\n",
       "      <td>306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>12/11/2015</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>37.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>11/12/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Maharashtra</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>50</td>\n",
       "      <td>59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>1/10/2015</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>35.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>Chemical Division Labour Club, Nagda</td>\n",
       "      <td>10/1/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Manipur</td>\n",
       "      <td>Nagda</td>\n",
       "      <td>29</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         sampling_date                                        agency  \\\n",
       "stn_code                                                               \n",
       "531          9/11/2015               Central Pollution Control Board   \n",
       "11          11/11/2015     West Bengal State Pollution Control Board   \n",
       "11          10/11/2015     West Bengal State Pollution Control Board   \n",
       "84            27-06-15  Madhya Pradesh State Pollution Control Board   \n",
       "82            3/9/2015  Madhya Pradesh State Pollution Control Board   \n",
       "82            17-09-15  Madhya Pradesh State Pollution Control Board   \n",
       "82            15-10-15  Madhya Pradesh State Pollution Control Board   \n",
       "692         11/11/2015          Odisha State Pollution Control Board   \n",
       "82          12/11/2015  Madhya Pradesh State Pollution Control Board   \n",
       "82           1/10/2015  Madhya Pradesh State Pollution Control Board   \n",
       "\n",
       "                                        type   so2    no2  \\\n",
       "stn_code                                                    \n",
       "531       Residential, Rural and other Areas  90.0  140.0   \n",
       "11        Residential, Rural and other Areas  84.0  125.0   \n",
       "11        Residential, Rural and other Areas  63.0   90.0   \n",
       "84        Residential, Rural and other Areas  56.0   27.0   \n",
       "82                           Industrial Area  40.0   21.0   \n",
       "82                           Industrial Area  39.0   18.0   \n",
       "82                           Industrial Area  38.0   20.0   \n",
       "692       Residential, Rural and other Areas  37.0   24.0   \n",
       "82                           Industrial Area  37.0   20.0   \n",
       "82                           Industrial Area  35.0   23.0   \n",
       "\n",
       "                   location_monitoring_station        date  Year  \\\n",
       "stn_code                                                           \n",
       "531                          Pritampura, Delhi   11/9/2015  2015   \n",
       "11                               Bator, Howrah  11/11/2015  2015   \n",
       "11                               Bator, Howrah  11/10/2015  2015   \n",
       "84                    B C I Labour Club, Nagda   6/27/2015  2015   \n",
       "82        Chemical Division Labour Club, Nagda    9/3/2015  2015   \n",
       "82        Chemical Division Labour Club, Nagda   9/17/2015  2015   \n",
       "82        Chemical Division Labour Club, Nagda  10/15/2015  2015   \n",
       "692            Over the Guest House of M/s PPL  11/11/2015  2015   \n",
       "82        Chemical Division Labour Club, Nagda  11/12/2015  2015   \n",
       "82        Chemical Division Labour Club, Nagda   10/1/2015  2015   \n",
       "\n",
       "                   State  location   pm2 rspm  \n",
       "stn_code                                       \n",
       "531                Delhi     Delhi   197  334  \n",
       "11           West Bengal    Howrah   303  389  \n",
       "11                 Bihar    Howrah   182  248  \n",
       "84          Chhattisgarh     Nagda    42   51  \n",
       "82        Madhya Pradesh     Nagda    29   53  \n",
       "82             Jharkhand     Nagda  24.8   47  \n",
       "82             Karnataka     Nagda    32   55  \n",
       "692               Odisha  Paradeep   122  306  \n",
       "82           Maharashtra     Nagda    50   59  \n",
       "82               Manipur     Nagda    29   55  "
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Top 10 states emiting So2\n",
    "\n",
    "top_SO2 = indiapoll.sort_values(by='so2', ascending= False) \n",
    "top_SO2 = top_SO2.head(10)\n",
    "top_SO2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sampling_date</th>\n",
       "      <th>agency</th>\n",
       "      <th>type</th>\n",
       "      <th>so2</th>\n",
       "      <th>no2</th>\n",
       "      <th>location_monitoring_station</th>\n",
       "      <th>date</th>\n",
       "      <th>Year</th>\n",
       "      <th>State</th>\n",
       "      <th>location</th>\n",
       "      <th>pm2</th>\n",
       "      <th>rspm</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stn_code</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>531</th>\n",
       "      <td>9/11/2015</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>90.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>11/9/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>197</td>\n",
       "      <td>334</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>744</th>\n",
       "      <td>2/4/2014</td>\n",
       "      <td>Andhra Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>17.4</td>\n",
       "      <td>134.0</td>\n",
       "      <td>APIIC Building, IDA, Pashamylaram</td>\n",
       "      <td>4/2/2014</td>\n",
       "      <td>2014</td>\n",
       "      <td>Telangana</td>\n",
       "      <td>Sangareddy</td>\n",
       "      <td>76</td>\n",
       "      <td>167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>West Bengal State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>84.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>Bator, Howrah</td>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>West Bengal</td>\n",
       "      <td>Howrah</td>\n",
       "      <td>303</td>\n",
       "      <td>389</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>744</th>\n",
       "      <td>2/5/2014</td>\n",
       "      <td>Andhra Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>22.2</td>\n",
       "      <td>119.5</td>\n",
       "      <td>APIIC Building, IDA, Pashamylaram</td>\n",
       "      <td>5/2/2014</td>\n",
       "      <td>2014</td>\n",
       "      <td>Punjab</td>\n",
       "      <td>Sangareddy</td>\n",
       "      <td>82</td>\n",
       "      <td>162</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>744</th>\n",
       "      <td>2/5/2015</td>\n",
       "      <td>Andhra Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>10.0</td>\n",
       "      <td>119.5</td>\n",
       "      <td>APIIC Building, IDA, Pashamylaram</td>\n",
       "      <td>5/2/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Punjab</td>\n",
       "      <td>Sangareddy</td>\n",
       "      <td>82</td>\n",
       "      <td>162</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473</th>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>West Bengal State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>21.0</td>\n",
       "      <td>118.0</td>\n",
       "      <td>Moulali, Kolkata</td>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Rajasthan</td>\n",
       "      <td>Kolkata</td>\n",
       "      <td>251</td>\n",
       "      <td>378</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476</th>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>West Bengal State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>17.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>Behala Chowrasta,Kolkata</td>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Tamil Nadu</td>\n",
       "      <td>Kolkata</td>\n",
       "      <td>206</td>\n",
       "      <td>411</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>744</th>\n",
       "      <td>1/3/2014</td>\n",
       "      <td>Andhra Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>4.2</td>\n",
       "      <td>109.2</td>\n",
       "      <td>APIIC Building, IDA, Pashamylaram</td>\n",
       "      <td>3/1/2014</td>\n",
       "      <td>2014</td>\n",
       "      <td>Tripura</td>\n",
       "      <td>Sangareddy</td>\n",
       "      <td>98</td>\n",
       "      <td>184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>744</th>\n",
       "      <td>2/3/2014</td>\n",
       "      <td>Andhra Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>22.2</td>\n",
       "      <td>107.9</td>\n",
       "      <td>APIIC Building, IDA, Pashamylaram</td>\n",
       "      <td>3/2/2014</td>\n",
       "      <td>2014</td>\n",
       "      <td>Lucknow</td>\n",
       "      <td>Sangareddy</td>\n",
       "      <td>64</td>\n",
       "      <td>193</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>744</th>\n",
       "      <td>2/3/2015</td>\n",
       "      <td>Andhra Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>7.5</td>\n",
       "      <td>107.9</td>\n",
       "      <td>APIIC Building, IDA, Pashamylaram</td>\n",
       "      <td>3/2/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Lucknow</td>\n",
       "      <td>Sangareddy</td>\n",
       "      <td>64</td>\n",
       "      <td>193</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         sampling_date                                        agency  \\\n",
       "stn_code                                                               \n",
       "531          9/11/2015               Central Pollution Control Board   \n",
       "744           2/4/2014  Andhra Pradesh State Pollution Control Board   \n",
       "11          11/11/2015     West Bengal State Pollution Control Board   \n",
       "744           2/5/2014  Andhra Pradesh State Pollution Control Board   \n",
       "744           2/5/2015  Andhra Pradesh State Pollution Control Board   \n",
       "473         11/11/2015     West Bengal State Pollution Control Board   \n",
       "476         11/11/2015     West Bengal State Pollution Control Board   \n",
       "744           1/3/2014  Andhra Pradesh State Pollution Control Board   \n",
       "744           2/3/2014  Andhra Pradesh State Pollution Control Board   \n",
       "744           2/3/2015  Andhra Pradesh State Pollution Control Board   \n",
       "\n",
       "                                        type   so2    no2  \\\n",
       "stn_code                                                    \n",
       "531       Residential, Rural and other Areas  90.0  140.0   \n",
       "744                          Industrial Area  17.4  134.0   \n",
       "11        Residential, Rural and other Areas  84.0  125.0   \n",
       "744                          Industrial Area  22.2  119.5   \n",
       "744                          Industrial Area  10.0  119.5   \n",
       "473       Residential, Rural and other Areas  21.0  118.0   \n",
       "476                          Industrial Area  17.0  113.0   \n",
       "744                          Industrial Area   4.2  109.2   \n",
       "744                          Industrial Area  22.2  107.9   \n",
       "744                          Industrial Area   7.5  107.9   \n",
       "\n",
       "                location_monitoring_station        date  Year        State  \\\n",
       "stn_code                                                                     \n",
       "531                       Pritampura, Delhi   11/9/2015  2015        Delhi   \n",
       "744       APIIC Building, IDA, Pashamylaram    4/2/2014  2014    Telangana   \n",
       "11                            Bator, Howrah  11/11/2015  2015  West Bengal   \n",
       "744       APIIC Building, IDA, Pashamylaram    5/2/2014  2014       Punjab   \n",
       "744       APIIC Building, IDA, Pashamylaram    5/2/2015  2015       Punjab   \n",
       "473                        Moulali, Kolkata  11/11/2015  2015    Rajasthan   \n",
       "476                Behala Chowrasta,Kolkata  11/11/2015  2015   Tamil Nadu   \n",
       "744       APIIC Building, IDA, Pashamylaram    3/1/2014  2014      Tripura   \n",
       "744       APIIC Building, IDA, Pashamylaram    3/2/2014  2014      Lucknow   \n",
       "744       APIIC Building, IDA, Pashamylaram    3/2/2015  2015      Lucknow   \n",
       "\n",
       "            location  pm2 rspm  \n",
       "stn_code                        \n",
       "531            Delhi  197  334  \n",
       "744       Sangareddy   76  167  \n",
       "11            Howrah  303  389  \n",
       "744       Sangareddy   82  162  \n",
       "744       Sangareddy   82  162  \n",
       "473          Kolkata  251  378  \n",
       "476          Kolkata  206  411  \n",
       "744       Sangareddy   98  184  \n",
       "744       Sangareddy   64  193  \n",
       "744       Sangareddy   64  193  "
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Top 10 states emiting NO2\n",
    "\n",
    "top_NO2 = indiapoll.sort_values(by='no2', ascending= False) \n",
    "top_NO2 = top_NO2.head(10)\n",
    "top_NO2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Converting rspm value to numeric value\n",
    "indiapoll['rspm']=pd.to_numeric(indiapoll['rspm'])\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sampling_date</th>\n",
       "      <th>agency</th>\n",
       "      <th>type</th>\n",
       "      <th>so2</th>\n",
       "      <th>no2</th>\n",
       "      <th>location_monitoring_station</th>\n",
       "      <th>date</th>\n",
       "      <th>Year</th>\n",
       "      <th>State</th>\n",
       "      <th>location</th>\n",
       "      <th>pm2</th>\n",
       "      <th>rspm</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stn_code</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>423</th>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>Odisha State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>18.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>IRC Vilage, Bhubaneshwar</td>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Odisha</td>\n",
       "      <td>Bhubaneswar</td>\n",
       "      <td>262</td>\n",
       "      <td>590.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>322</th>\n",
       "      <td>23-10-14</td>\n",
       "      <td>Odisha State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>14.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>SPCB Building, Bhubaneshwar</td>\n",
       "      <td>10/23/2014</td>\n",
       "      <td>2014</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Bhubaneswar</td>\n",
       "      <td>504</td>\n",
       "      <td>551.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>2/6/2015</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>9.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>Shahadra, Delhi</td>\n",
       "      <td>6/2/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>44</td>\n",
       "      <td>543.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>424</th>\n",
       "      <td>23-10-14</td>\n",
       "      <td>Odisha State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>29.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>Capital Police Station, Bhubaneshwar</td>\n",
       "      <td>10/23/2014</td>\n",
       "      <td>2014</td>\n",
       "      <td>Odisha</td>\n",
       "      <td>Bhubaneswar</td>\n",
       "      <td>214</td>\n",
       "      <td>529.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>322</th>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>Odisha State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>18.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>SPCB Building, Bhubaneshwar</td>\n",
       "      <td>11/11/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Odisha</td>\n",
       "      <td>Bhubaneswar</td>\n",
       "      <td>331</td>\n",
       "      <td>511.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>531</th>\n",
       "      <td>13-11-15</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>9.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>Pritampura, Delhi</td>\n",
       "      <td>11/13/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>192</td>\n",
       "      <td>504.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>28-02-15</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>2.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Govindpura, AKUN, Bhopal</td>\n",
       "      <td>2/28/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Madhya Pradesh</td>\n",
       "      <td>Bhopal</td>\n",
       "      <td>86</td>\n",
       "      <td>475.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>797</th>\n",
       "      <td>26-02-15</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>8.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>AKVN Office, Industrial Area Mandideep, Raisen</td>\n",
       "      <td>2/26/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Madhya Pradesh</td>\n",
       "      <td>Bhopal</td>\n",
       "      <td>110</td>\n",
       "      <td>471.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>797</th>\n",
       "      <td>30-03-15</td>\n",
       "      <td>Madhya Pradesh State Pollution Control Board</td>\n",
       "      <td>Residential, Rural and other Areas</td>\n",
       "      <td>8.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>AKVN Office, Industrial Area Mandideep, Raisen</td>\n",
       "      <td>3/30/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Madhya Pradesh</td>\n",
       "      <td>Bhopal</td>\n",
       "      <td>260</td>\n",
       "      <td>471.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>26-11-15</td>\n",
       "      <td>Central Pollution Control Board</td>\n",
       "      <td>Industrial Area</td>\n",
       "      <td>9.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>Shahadra, Delhi</td>\n",
       "      <td>11/26/2015</td>\n",
       "      <td>2015</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>210</td>\n",
       "      <td>470.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         sampling_date                                        agency  \\\n",
       "stn_code                                                               \n",
       "423         11/11/2015          Odisha State Pollution Control Board   \n",
       "322           23-10-14          Odisha State Pollution Control Board   \n",
       "58            2/6/2015               Central Pollution Control Board   \n",
       "424           23-10-14          Odisha State Pollution Control Board   \n",
       "322         11/11/2015          Odisha State Pollution Control Board   \n",
       "531           13-11-15               Central Pollution Control Board   \n",
       "123           28-02-15  Madhya Pradesh State Pollution Control Board   \n",
       "797           26-02-15  Madhya Pradesh State Pollution Control Board   \n",
       "797           30-03-15  Madhya Pradesh State Pollution Control Board   \n",
       "58            26-11-15               Central Pollution Control Board   \n",
       "\n",
       "                                        type   so2   no2  \\\n",
       "stn_code                                                   \n",
       "423       Residential, Rural and other Areas  18.0  38.0   \n",
       "322       Residential, Rural and other Areas  14.0  34.0   \n",
       "58                           Industrial Area   9.0  49.0   \n",
       "424       Residential, Rural and other Areas  29.0  33.0   \n",
       "322       Residential, Rural and other Areas  18.0  26.0   \n",
       "531       Residential, Rural and other Areas   9.0  41.0   \n",
       "123                          Industrial Area   2.0  20.0   \n",
       "797       Residential, Rural and other Areas   8.0  42.0   \n",
       "797       Residential, Rural and other Areas   8.0  47.0   \n",
       "58                           Industrial Area   9.0  67.0   \n",
       "\n",
       "                             location_monitoring_station        date  Year  \\\n",
       "stn_code                                                                     \n",
       "423                             IRC Vilage, Bhubaneshwar  11/11/2015  2015   \n",
       "322                          SPCB Building, Bhubaneshwar  10/23/2014  2014   \n",
       "58                                       Shahadra, Delhi    6/2/2015  2015   \n",
       "424                 Capital Police Station, Bhubaneshwar  10/23/2014  2014   \n",
       "322                          SPCB Building, Bhubaneshwar  11/11/2015  2015   \n",
       "531                                    Pritampura, Delhi  11/13/2015  2015   \n",
       "123                             Govindpura, AKUN, Bhopal   2/28/2015  2015   \n",
       "797       AKVN Office, Industrial Area Mandideep, Raisen   2/26/2015  2015   \n",
       "797       AKVN Office, Industrial Area Mandideep, Raisen   3/30/2015  2015   \n",
       "58                                       Shahadra, Delhi  11/26/2015  2015   \n",
       "\n",
       "                   State     location  pm2   rspm  \n",
       "stn_code                                           \n",
       "423               Odisha  Bhubaneswar  262  590.0  \n",
       "322                Delhi  Bhubaneswar  504  551.0  \n",
       "58                 Delhi        Delhi   44  543.0  \n",
       "424               Odisha  Bhubaneswar  214  529.0  \n",
       "322               Odisha  Bhubaneswar  331  511.0  \n",
       "531                Delhi        Delhi  192  504.0  \n",
       "123       Madhya Pradesh       Bhopal   86  475.0  \n",
       "797       Madhya Pradesh       Bhopal  110  471.0  \n",
       "797       Madhya Pradesh       Bhopal  260  471.0  \n",
       "58                 Delhi        Delhi  210  470.0  "
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Top 10 states emiting RSPM\n",
    "\n",
    "top_rspm = indiapoll.sort_values(by='rspm', ascending= False) \n",
    "top_rspm = top_rspm.head(10)\n",
    "top_rspm"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<iframe id=\"igraph\" scrolling=\"no\" style=\"border:none;\" seamless=\"seamless\" src=\"https://plot.ly/~monicams89/43.embed\" height=\"525px\" width=\"100%\"></iframe>"
      ],
      "text/plain": [
       "<plotly.tools.PlotlyDisplay object>"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Comparing Top 10 Emitters for SO2, NO2 and rspm \n",
    "\n",
    "trace1 = go.Bar(\n",
    "    x=top_SO2['State'],\n",
    "    y=top_SO2['so2'],\n",
    "    name='so2'\n",
    ")\n",
    "trace2 = go.Bar(\n",
    "    x=top_NO2['State'],\n",
    "    y=top_NO2['no2'],\n",
    "    name='no2'\n",
    ")\n",
    "trace3 = go.Bar(\n",
    "    x=top_rspm['State'],\n",
    "    y=top_rspm['rspm'],\n",
    "    name='rspm'\n",
    ")\n",
    "data = [trace1, trace2,trace3]\n",
    "layout = go.Layout(\n",
    "    barmode='stack'\n",
    ")\n",
    "\n",
    "fig = go.Figure(data=data, layout=layout)\n",
    "py.iplot(fig, filename='Bar-Plot')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Pollution levels(So2,No2,rspm) for a particular state\n",
    "def state_pollution(state):\n",
    "    indiapoll_indexed_state = indiapoll.set_index(['State']).sort_index()\n",
    "    indiapoll_indexed_state.head()\n",
    "\n",
    "    state_data = indiapoll_indexed_state.loc[state]\n",
    "    state_so2= sum(state_data['so2'])\n",
    "    state_no2= sum(state_data['no2'])\n",
    "    state_rspm= sum(state_data['rspm'])\n",
    "\n",
    "    return[state_so2,state_no2,state_rspm]\n",
    "    \n",
    "    \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [],
   "source": [
    "state_name=state_pollution('Delhi')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "High five! You successfully sent some data to your account on plotly. View your plot in your browser at https://plot.ly/~monicams89/0 or inside your plot.ly account where it is named 'basic_pie_chart'\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<iframe id=\"igraph\" scrolling=\"no\" style=\"border:none;\" seamless=\"seamless\" src=\"https://plot.ly/~monicams89/0.embed\" height=\"525px\" width=\"100%\"></iframe>"
      ],
      "text/plain": [
       "<plotly.tools.PlotlyDisplay object>"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "labels1 = ['so2','no2','rspm']\n",
    "values1 = state_name\n",
    "\n",
    "trace1 = go.Pie(labels=labels1, values=values1,pull=.2,hole=.2)\n",
    "\n",
    "\n",
    "py.iplot([trace1], filename='basic_pie_chart')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "This is the format of your plot grid:\n",
      "[ (1,1) x1,y1 ]  [ (1,2) x2,y2 ]  [ (1,3) x3,y3 ]\n",
      "\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<iframe id=\"igraph\" scrolling=\"no\" style=\"border:none;\" seamless=\"seamless\" src=\"https://plot.ly/~monicams89/24.embed\" height=\"600px\" width=\"1000px\"></iframe>"
      ],
      "text/plain": [
       "<plotly.tools.PlotlyDisplay object>"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Subplots to show comparison for SO2 NO2 and rspm\n",
    "\n",
    "trace1 = go.Scatter(\n",
    "    x=top_NO2['State'],\n",
    "    y=top_NO2['no2'],\n",
    "    name = 'no2'\n",
    ")\n",
    "trace2 = go.Scatter(\n",
    "    x=top_SO2['State'],\n",
    "    y=top_SO2['so2'],\n",
    "    name = 'so2'\n",
    ")\n",
    "\n",
    "trace3 = go.Scatter(\n",
    "    x=top_rspm['State'],\n",
    "    y=top_rspm['rspm'],\n",
    "    name = 'rspm'\n",
    ")\n",
    "fig = tools.make_subplots(rows=1, cols=3)\n",
    "\n",
    "fig.append_trace(trace1, 1, 1)\n",
    "fig.append_trace(trace2, 1, 2)\n",
    "fig.append_trace(trace3, 1, 3)\n",
    "\n",
    "fig['layout'].update(height=600, width=1000, title='Subplots Showing The Comparison')\n",
    "py.iplot(fig, filename='multiple-subplots')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Examine pollution levels in type of areas i.e Residential vs Rural vs RIRUO\n",
    "\n",
    "indiapoll_indexed = indiapoll.set_index(['type']).sort_index()\n",
    "indiapoll_indexed.head()\n",
    "\n",
    "\n",
    "indiapoll_type_industry = indiapoll_indexed.loc['Industrial Area']\n",
    "Sum_industry_so2 = sum(indiapoll_type_industry['so2'])\n",
    "Sum_industry_no2 = sum(indiapoll_type_industry['no2'])\n",
    "Sum_industry_rspm = sum(indiapoll_type_industry['rspm'])\n",
    "\n",
    "indiapoll_type_residential = indiapoll_indexed.loc['Residential, Rural and other Areas']\n",
    "Sum_residential_so2 = sum(indiapoll_type_residential['so2'])\n",
    "Sum_residential_no2 = sum(indiapoll_type_residential['no2'])\n",
    "Sum_residential_rspm = sum(indiapoll_type_residential['rspm'])\n",
    "\n",
    "\n",
    "indiapoll_type_riruo = indiapoll_indexed.loc['RIRUO']\n",
    "Sum_riruo_so2 = sum(indiapoll_type_riruo['so2'])\n",
    "Sum_riruo_no2 = sum(indiapoll_type_riruo['no2'])\n",
    "Sum_riruo_rspm = sum(indiapoll_type_riruo['rspm'])\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<iframe id=\"igraph\" scrolling=\"no\" style=\"border:none;\" seamless=\"seamless\" src=\"https://plot.ly/~monicams89/43.embed\" height=\"525px\" width=\"100%\"></iframe>"
      ],
      "text/plain": [
       "<plotly.tools.PlotlyDisplay object>"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Ploting graph\n",
    "\n",
    "trace11 = go.Bar(\n",
    "    x=['Industrial Area','Residential, Rural and other Areas','RIRUO'],\n",
    "    y=[Sum_industry_so2,Sum_residential_so2,Sum_riruo_so2],\n",
    "    name='so2'\n",
    ")\n",
    "trace22 = go.Bar(\n",
    "    #x=indiapoll['type'],\n",
    "    x=['Industrial Area','Residential, Rural and other Areas','RIRUO'],\n",
    "    y=[Sum_industry_no2,Sum_residential_no2,Sum_riruo_no2],\n",
    "    name='no2'\n",
    ")\n",
    "trace33 = go.Bar(\n",
    "    #x=indiapoll['type'],\n",
    "    x=['Industrial Area','Residential, Rural and other Areas','RIRUO'],\n",
    "    y=[Sum_industry_rspm,Sum_residential_rspm,Sum_riruo_rspm],\n",
    "    name='rspm'\n",
    ")\n",
    "\n",
    "data11 = [trace11,trace22,trace33]\n",
    "layout = go.Layout(\n",
    "    barmode='bar'\n",
    ")\n",
    "\n",
    "fig = go.Figure(data=data11, layout=layout)\n",
    "py.iplot(fig, filename='Bar-Plot')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "This is the format of your plot grid:\n",
      "[ (1,1) x1,y1 ]  [ (1,2) x2,y2 ]\n",
      "[ (2,1) x3,y3 ]  [ (2,2) x4,y4 ]\n",
      "\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<iframe id=\"igraph\" scrolling=\"no\" style=\"border:none;\" seamless=\"seamless\" src=\"https://plot.ly/~monicams89/24.embed\" height=\"600px\" width=\"1000px\"></iframe>"
      ],
      "text/plain": [
       "<plotly.tools.PlotlyDisplay object>"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Plot trend for 2014 and show comparison between States for North India and South India \n",
    "\n",
    "northIndia=['Haryana','Lucknow','Punjab']\n",
    "southIndia=['Karnataka','Odisha', 'Tripura']\n",
    "\n",
    "indiapoll_indexed_year = indiapoll.set_index(['Year']).sort_index()\n",
    "indiapoll_indexed_year.head()\n",
    "\n",
    "indiapoll_indexed_state2014=indiapoll_indexed_year.loc[2014].set_index(['State'])\n",
    "indiapoll_indexed_state2015=indiapoll_indexed_year.loc[2015].set_index(['State'])\n",
    "\n",
    "trace1=go.Scatter(\n",
    "    x=northIndia,\n",
    "    y=indiapoll_indexed_state2014.loc[northIndia]['so2'],\n",
    "    fill='tonexty',\n",
    "    name = 'North India - 2014'\n",
    ")\n",
    "trace2=go.Scatter(\n",
    "    x=southIndia,\n",
    "    y=indiapoll_indexed_state2014.loc[southIndia]['so2'],\n",
    "    fill='tonexty',\n",
    "    name = 'South India - 2014'\n",
    ")\n",
    "\n",
    "trace3=go.Scatter(\n",
    "    x=northIndia,\n",
    "    y=indiapoll_indexed_state2015.loc[northIndia]['so2'],\n",
    "    fill='tonexty',\n",
    "    name = 'North India - 2015'\n",
    ")\n",
    "trace4=go.Scatter(\n",
    "    x=southIndia,\n",
    "    y=indiapoll_indexed_state2015.loc[southIndia]['so2'],\n",
    "    fill='tonexty',\n",
    "    name = 'South India - 2015'\n",
    ")\n",
    "\n",
    "fig = tools.make_subplots(rows=2, cols=2)\n",
    "\n",
    "fig.append_trace(trace1, 1, 1)\n",
    "fig.append_trace(trace2, 1, 2)\n",
    "fig.append_trace(trace3, 2, 1)\n",
    "fig.append_trace(trace4, 2, 2)\n",
    "\n",
    "\n",
    "fig['layout'].update(height=600, width=1000, title='Subplots Showing The Comparison for North and South India (2014) vs (2015)')\n",
    "py.iplot(fig, filename='multiple-subplots')\n"
   ]
  }
 ],
 "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.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}