PyDataCoffeeNCode- tameeshb.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<script src=\"//code.highcharts.com/stock/highstock.js\"></script>\n",
       "<script src=\"//code.highcharts.com/highcharts-more.js\"></script>\n",
       "<script src=\"//code.highcharts.com/modules/exporting.js\"></script>\n"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "from pandas_highcharts.core import serialize\n",
    "from pandas_highcharts.display import display_charts\n",
    "from IPython.display import display"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [],
   "source": [
    "dataCen = pd.read_csv('csvs/india-districts-census-2011.csv', encoding='utf-8')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "dataD = dataCen[['State Name','Literate']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [],
   "source": [
    "dataD2 = dataD.groupby(['State Name'])[['Literate']].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "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>Literate</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>State Name</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ANDAMAN AND NICOBAR ISLANDS</th>\n",
       "      <td>294281</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ANDHRA PRADESH</th>\n",
       "      <td>50556760</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ARUNACHAL PRADESH</th>\n",
       "      <td>766005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ASSAM</th>\n",
       "      <td>19177977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BIHAR</th>\n",
       "      <td>52504553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHANDIGARH</th>\n",
       "      <td>805438</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHHATTISGARH</th>\n",
       "      <td>15379922</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DADRA AND NAGAR HAVELI</th>\n",
       "      <td>223230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DAMAN AND DIU</th>\n",
       "      <td>188406</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GOA</th>\n",
       "      <td>1165487</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GUJARAT</th>\n",
       "      <td>41093358</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HARYANA</th>\n",
       "      <td>16598988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HIMACHAL PRADESH</th>\n",
       "      <td>5039736</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JAMMU AND KASHMIR</th>\n",
       "      <td>7067233</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JHARKHAND</th>\n",
       "      <td>18328069</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KARNATAKA</th>\n",
       "      <td>40647322</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KERALA</th>\n",
       "      <td>28135824</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LAKSHADWEEP</th>\n",
       "      <td>52553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MADHYA PRADESH</th>\n",
       "      <td>42851169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MAHARASHTRA</th>\n",
       "      <td>81554290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MANIPUR</th>\n",
       "      <td>1908476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MEGHALAYA</th>\n",
       "      <td>1785005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MIZORAM</th>\n",
       "      <td>848175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NAGALAND</th>\n",
       "      <td>1342434</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NCT OF DELHI</th>\n",
       "      <td>12737767</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ORISSA</th>\n",
       "      <td>26742595</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PONDICHERRY</th>\n",
       "      <td>957309</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PUNJAB</th>\n",
       "      <td>18707137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RAJASTHAN</th>\n",
       "      <td>38275282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SIKKIM</th>\n",
       "      <td>444952</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TAMIL NADU</th>\n",
       "      <td>51837507</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TRIPURA</th>\n",
       "      <td>2804783</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UTTAR PRADESH</th>\n",
       "      <td>114397555</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UTTARAKHAND</th>\n",
       "      <td>6880953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WEST BENGAL</th>\n",
       "      <td>61538281</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              Literate\n",
       "State Name                            \n",
       "ANDAMAN AND NICOBAR ISLANDS     294281\n",
       "ANDHRA PRADESH                50556760\n",
       "ARUNACHAL PRADESH               766005\n",
       "ASSAM                         19177977\n",
       "BIHAR                         52504553\n",
       "CHANDIGARH                      805438\n",
       "CHHATTISGARH                  15379922\n",
       "DADRA AND NAGAR HAVELI          223230\n",
       "DAMAN AND DIU                   188406\n",
       "GOA                            1165487\n",
       "GUJARAT                       41093358\n",
       "HARYANA                       16598988\n",
       "HIMACHAL PRADESH               5039736\n",
       "JAMMU AND KASHMIR              7067233\n",
       "JHARKHAND                     18328069\n",
       "KARNATAKA                     40647322\n",
       "KERALA                        28135824\n",
       "LAKSHADWEEP                      52553\n",
       "MADHYA PRADESH                42851169\n",
       "MAHARASHTRA                   81554290\n",
       "MANIPUR                        1908476\n",
       "MEGHALAYA                      1785005\n",
       "MIZORAM                         848175\n",
       "NAGALAND                       1342434\n",
       "NCT OF DELHI                  12737767\n",
       "ORISSA                        26742595\n",
       "PONDICHERRY                     957309\n",
       "PUNJAB                        18707137\n",
       "RAJASTHAN                     38275282\n",
       "SIKKIM                          444952\n",
       "TAMIL NADU                    51837507\n",
       "TRIPURA                        2804783\n",
       "UTTAR PRADESH                114397555\n",
       "UTTARAKHAND                    6880953\n",
       "WEST BENGAL                   61538281"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataD2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div id=\"chart_idXxnRseEM\"</div>\n",
       "    <script type=\"text/javascript\">new Highcharts.Chart({\"title\":{\"text\":\"Literacy in different states of India\"},\"series\":[{\"data\":[[\"ANDAMAN AND NICOBAR ISLANDS\",294281],[\"ANDHRA PRADESH\",50556760],[\"ARUNACHAL PRADESH\",766005],[\"ASSAM\",19177977],[\"BIHAR\",52504553],[\"CHANDIGARH\",805438],[\"CHHATTISGARH\",15379922],[\"DADRA AND NAGAR HAVELI\",223230],[\"DAMAN AND DIU\",188406],[\"GOA\",1165487],[\"GUJARAT\",41093358],[\"HARYANA\",16598988],[\"HIMACHAL PRADESH\",5039736],[\"JAMMU AND KASHMIR\",7067233],[\"JHARKHAND\",18328069],[\"KARNATAKA\",40647322],[\"KERALA\",28135824],[\"LAKSHADWEEP\",52553],[\"MADHYA PRADESH\",42851169],[\"MAHARASHTRA\",81554290],[\"MANIPUR\",1908476],[\"MEGHALAYA\",1785005],[\"MIZORAM\",848175],[\"NAGALAND\",1342434],[\"NCT OF DELHI\",12737767],[\"ORISSA\",26742595],[\"PONDICHERRY\",957309],[\"PUNJAB\",18707137],[\"RAJASTHAN\",38275282],[\"SIKKIM\",444952],[\"TAMIL NADU\",51837507],[\"TRIPURA\",2804783],[\"UTTAR PRADESH\",114397555],[\"UTTARAKHAND\",6880953],[\"WEST BENGAL\",61538281]],\"name\":\"Literate\",\"yAxis\":0}],\"yAxis\":[{}],\"chart\":{\"width\":1000,\"renderTo\":\"chart_idXxnRseEM\",\"type\":\"column\",\"height\":700},\"xAxis\":{\"categories\":[\"ANDAMAN AND NICOBAR ISLANDS\",\"ANDHRA PRADESH\",\"ARUNACHAL PRADESH\",\"ASSAM\",\"BIHAR\",\"CHANDIGARH\",\"CHHATTISGARH\",\"DADRA AND NAGAR HAVELI\",\"DAMAN AND DIU\",\"GOA\",\"GUJARAT\",\"HARYANA\",\"HIMACHAL PRADESH\",\"JAMMU AND KASHMIR\",\"JHARKHAND\",\"KARNATAKA\",\"KERALA\",\"LAKSHADWEEP\",\"MADHYA PRADESH\",\"MAHARASHTRA\",\"MANIPUR\",\"MEGHALAYA\",\"MIZORAM\",\"NAGALAND\",\"NCT OF DELHI\",\"ORISSA\",\"PONDICHERRY\",\"PUNJAB\",\"RAJASTHAN\",\"SIKKIM\",\"TAMIL NADU\",\"TRIPURA\",\"UTTAR PRADESH\",\"UTTARAKHAND\",\"WEST BENGAL\"],\"title\":{\"text\":\"State Name\"}},\"legend\":{\"enabled\":true}});</script>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display_charts(dataD2, title=\"Literacy in different states of India\",kind=\"bar\",figsize = (1000, 700))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [],
   "source": [
    "dataR = dataCen[['State Name','Hindus','Muslims','Christians','Sikhs','Buddhists','Jains','Others_Religions']]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [],
   "source": [
    "dataR = dataR.groupby(['State Name'])[['Hindus','Muslims','Christians','Sikhs','Buddhists','Jains','Others_Religions']].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "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>Hindus</th>\n",
       "      <th>Muslims</th>\n",
       "      <th>Christians</th>\n",
       "      <th>Sikhs</th>\n",
       "      <th>Buddhists</th>\n",
       "      <th>Jains</th>\n",
       "      <th>Others_Religions</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>State Name</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>ANDAMAN AND NICOBAR ISLANDS</th>\n",
       "      <td>264296</td>\n",
       "      <td>32413</td>\n",
       "      <td>80984</td>\n",
       "      <td>1286</td>\n",
       "      <td>338</td>\n",
       "      <td>31</td>\n",
       "      <td>564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ANDHRA PRADESH</th>\n",
       "      <td>74824149</td>\n",
       "      <td>8082412</td>\n",
       "      <td>1129784</td>\n",
       "      <td>40244</td>\n",
       "      <td>36692</td>\n",
       "      <td>53849</td>\n",
       "      <td>9547</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ARUNACHAL PRADESH</th>\n",
       "      <td>401876</td>\n",
       "      <td>27045</td>\n",
       "      <td>418732</td>\n",
       "      <td>3287</td>\n",
       "      <td>162815</td>\n",
       "      <td>771</td>\n",
       "      <td>362553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ASSAM</th>\n",
       "      <td>19180759</td>\n",
       "      <td>10679345</td>\n",
       "      <td>1165867</td>\n",
       "      <td>20672</td>\n",
       "      <td>54993</td>\n",
       "      <td>25949</td>\n",
       "      <td>27118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BIHAR</th>\n",
       "      <td>86078686</td>\n",
       "      <td>17557809</td>\n",
       "      <td>129247</td>\n",
       "      <td>23779</td>\n",
       "      <td>25453</td>\n",
       "      <td>18914</td>\n",
       "      <td>13437</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHANDIGARH</th>\n",
       "      <td>852574</td>\n",
       "      <td>51447</td>\n",
       "      <td>8720</td>\n",
       "      <td>138329</td>\n",
       "      <td>1160</td>\n",
       "      <td>1960</td>\n",
       "      <td>246</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHHATTISGARH</th>\n",
       "      <td>23819789</td>\n",
       "      <td>514998</td>\n",
       "      <td>490542</td>\n",
       "      <td>70036</td>\n",
       "      <td>70467</td>\n",
       "      <td>61510</td>\n",
       "      <td>494594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DADRA AND NAGAR HAVELI</th>\n",
       "      <td>322857</td>\n",
       "      <td>12922</td>\n",
       "      <td>5113</td>\n",
       "      <td>217</td>\n",
       "      <td>634</td>\n",
       "      <td>1186</td>\n",
       "      <td>293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DAMAN AND DIU</th>\n",
       "      <td>220150</td>\n",
       "      <td>19277</td>\n",
       "      <td>2820</td>\n",
       "      <td>172</td>\n",
       "      <td>217</td>\n",
       "      <td>287</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GOA</th>\n",
       "      <td>963877</td>\n",
       "      <td>121564</td>\n",
       "      <td>366130</td>\n",
       "      <td>1473</td>\n",
       "      <td>1095</td>\n",
       "      <td>1109</td>\n",
       "      <td>258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GUJARAT</th>\n",
       "      <td>53533988</td>\n",
       "      <td>5846761</td>\n",
       "      <td>316178</td>\n",
       "      <td>58246</td>\n",
       "      <td>30483</td>\n",
       "      <td>579654</td>\n",
       "      <td>16480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HARYANA</th>\n",
       "      <td>22171128</td>\n",
       "      <td>1781342</td>\n",
       "      <td>50353</td>\n",
       "      <td>1243752</td>\n",
       "      <td>7514</td>\n",
       "      <td>52613</td>\n",
       "      <td>2548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HIMACHAL PRADESH</th>\n",
       "      <td>6532765</td>\n",
       "      <td>149881</td>\n",
       "      <td>12646</td>\n",
       "      <td>79896</td>\n",
       "      <td>78659</td>\n",
       "      <td>1805</td>\n",
       "      <td>856</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JAMMU AND KASHMIR</th>\n",
       "      <td>3566674</td>\n",
       "      <td>8567485</td>\n",
       "      <td>35631</td>\n",
       "      <td>234848</td>\n",
       "      <td>112584</td>\n",
       "      <td>2490</td>\n",
       "      <td>1508</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JHARKHAND</th>\n",
       "      <td>22376051</td>\n",
       "      <td>4793994</td>\n",
       "      <td>1418608</td>\n",
       "      <td>71422</td>\n",
       "      <td>8956</td>\n",
       "      <td>14974</td>\n",
       "      <td>4235786</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KARNATAKA</th>\n",
       "      <td>51317472</td>\n",
       "      <td>7893065</td>\n",
       "      <td>1142647</td>\n",
       "      <td>28773</td>\n",
       "      <td>95710</td>\n",
       "      <td>440280</td>\n",
       "      <td>11263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KERALA</th>\n",
       "      <td>18282492</td>\n",
       "      <td>8873472</td>\n",
       "      <td>6141269</td>\n",
       "      <td>3814</td>\n",
       "      <td>4752</td>\n",
       "      <td>4489</td>\n",
       "      <td>7618</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LAKSHADWEEP</th>\n",
       "      <td>1788</td>\n",
       "      <td>62268</td>\n",
       "      <td>317</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MADHYA PRADESH</th>\n",
       "      <td>66007121</td>\n",
       "      <td>4774695</td>\n",
       "      <td>213282</td>\n",
       "      <td>151412</td>\n",
       "      <td>216052</td>\n",
       "      <td>567028</td>\n",
       "      <td>599594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MAHARASHTRA</th>\n",
       "      <td>89703057</td>\n",
       "      <td>12971152</td>\n",
       "      <td>1080073</td>\n",
       "      <td>223247</td>\n",
       "      <td>6531200</td>\n",
       "      <td>1400349</td>\n",
       "      <td>178965</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MANIPUR</th>\n",
       "      <td>1181876</td>\n",
       "      <td>239836</td>\n",
       "      <td>1179043</td>\n",
       "      <td>1527</td>\n",
       "      <td>7084</td>\n",
       "      <td>1692</td>\n",
       "      <td>233767</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MEGHALAYA</th>\n",
       "      <td>342078</td>\n",
       "      <td>130399</td>\n",
       "      <td>2213027</td>\n",
       "      <td>3045</td>\n",
       "      <td>9864</td>\n",
       "      <td>627</td>\n",
       "      <td>258271</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MIZORAM</th>\n",
       "      <td>30136</td>\n",
       "      <td>14832</td>\n",
       "      <td>956331</td>\n",
       "      <td>286</td>\n",
       "      <td>93411</td>\n",
       "      <td>376</td>\n",
       "      <td>808</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NAGALAND</th>\n",
       "      <td>173054</td>\n",
       "      <td>48963</td>\n",
       "      <td>1739651</td>\n",
       "      <td>1890</td>\n",
       "      <td>6759</td>\n",
       "      <td>2655</td>\n",
       "      <td>3214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NCT OF DELHI</th>\n",
       "      <td>13712100</td>\n",
       "      <td>2158684</td>\n",
       "      <td>146093</td>\n",
       "      <td>570581</td>\n",
       "      <td>18449</td>\n",
       "      <td>166231</td>\n",
       "      <td>2197</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ORISSA</th>\n",
       "      <td>39300341</td>\n",
       "      <td>911670</td>\n",
       "      <td>1161708</td>\n",
       "      <td>21991</td>\n",
       "      <td>13852</td>\n",
       "      <td>9420</td>\n",
       "      <td>478317</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PONDICHERRY</th>\n",
       "      <td>1089409</td>\n",
       "      <td>75556</td>\n",
       "      <td>78550</td>\n",
       "      <td>297</td>\n",
       "      <td>451</td>\n",
       "      <td>1400</td>\n",
       "      <td>168</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PUNJAB</th>\n",
       "      <td>10678138</td>\n",
       "      <td>535489</td>\n",
       "      <td>348230</td>\n",
       "      <td>16004754</td>\n",
       "      <td>33237</td>\n",
       "      <td>45040</td>\n",
       "      <td>10886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RAJASTHAN</th>\n",
       "      <td>60657103</td>\n",
       "      <td>6215377</td>\n",
       "      <td>96430</td>\n",
       "      <td>872930</td>\n",
       "      <td>12185</td>\n",
       "      <td>622023</td>\n",
       "      <td>4676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SIKKIM</th>\n",
       "      <td>352662</td>\n",
       "      <td>9867</td>\n",
       "      <td>60522</td>\n",
       "      <td>1868</td>\n",
       "      <td>167216</td>\n",
       "      <td>314</td>\n",
       "      <td>16300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TAMIL NADU</th>\n",
       "      <td>63188168</td>\n",
       "      <td>4229479</td>\n",
       "      <td>4418331</td>\n",
       "      <td>14601</td>\n",
       "      <td>11186</td>\n",
       "      <td>89265</td>\n",
       "      <td>7414</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TRIPURA</th>\n",
       "      <td>3063903</td>\n",
       "      <td>316042</td>\n",
       "      <td>159882</td>\n",
       "      <td>1070</td>\n",
       "      <td>125385</td>\n",
       "      <td>860</td>\n",
       "      <td>1514</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UTTAR PRADESH</th>\n",
       "      <td>159312654</td>\n",
       "      <td>38483967</td>\n",
       "      <td>356448</td>\n",
       "      <td>643500</td>\n",
       "      <td>206285</td>\n",
       "      <td>213267</td>\n",
       "      <td>13598</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UTTARAKHAND</th>\n",
       "      <td>8368636</td>\n",
       "      <td>1406825</td>\n",
       "      <td>37781</td>\n",
       "      <td>236340</td>\n",
       "      <td>14926</td>\n",
       "      <td>9183</td>\n",
       "      <td>993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WEST BENGAL</th>\n",
       "      <td>64385546</td>\n",
       "      <td>24654825</td>\n",
       "      <td>658618</td>\n",
       "      <td>63523</td>\n",
       "      <td>282898</td>\n",
       "      <td>60141</td>\n",
       "      <td>942297</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                Hindus   Muslims  Christians     Sikhs  \\\n",
       "State Name                                                               \n",
       "ANDAMAN AND NICOBAR ISLANDS     264296     32413       80984      1286   \n",
       "ANDHRA PRADESH                74824149   8082412     1129784     40244   \n",
       "ARUNACHAL PRADESH               401876     27045      418732      3287   \n",
       "ASSAM                         19180759  10679345     1165867     20672   \n",
       "BIHAR                         86078686  17557809      129247     23779   \n",
       "CHANDIGARH                      852574     51447        8720    138329   \n",
       "CHHATTISGARH                  23819789    514998      490542     70036   \n",
       "DADRA AND NAGAR HAVELI          322857     12922        5113       217   \n",
       "DAMAN AND DIU                   220150     19277        2820       172   \n",
       "GOA                             963877    121564      366130      1473   \n",
       "GUJARAT                       53533988   5846761      316178     58246   \n",
       "HARYANA                       22171128   1781342       50353   1243752   \n",
       "HIMACHAL PRADESH               6532765    149881       12646     79896   \n",
       "JAMMU AND KASHMIR              3566674   8567485       35631    234848   \n",
       "JHARKHAND                     22376051   4793994     1418608     71422   \n",
       "KARNATAKA                     51317472   7893065     1142647     28773   \n",
       "KERALA                        18282492   8873472     6141269      3814   \n",
       "LAKSHADWEEP                       1788     62268         317         8   \n",
       "MADHYA PRADESH                66007121   4774695      213282    151412   \n",
       "MAHARASHTRA                   89703057  12971152     1080073    223247   \n",
       "MANIPUR                        1181876    239836     1179043      1527   \n",
       "MEGHALAYA                       342078    130399     2213027      3045   \n",
       "MIZORAM                          30136     14832      956331       286   \n",
       "NAGALAND                        173054     48963     1739651      1890   \n",
       "NCT OF DELHI                  13712100   2158684      146093    570581   \n",
       "ORISSA                        39300341    911670     1161708     21991   \n",
       "PONDICHERRY                    1089409     75556       78550       297   \n",
       "PUNJAB                        10678138    535489      348230  16004754   \n",
       "RAJASTHAN                     60657103   6215377       96430    872930   \n",
       "SIKKIM                          352662      9867       60522      1868   \n",
       "TAMIL NADU                    63188168   4229479     4418331     14601   \n",
       "TRIPURA                        3063903    316042      159882      1070   \n",
       "UTTAR PRADESH                159312654  38483967      356448    643500   \n",
       "UTTARAKHAND                    8368636   1406825       37781    236340   \n",
       "WEST BENGAL                   64385546  24654825      658618     63523   \n",
       "\n",
       "                             Buddhists    Jains  Others_Religions  \n",
       "State Name                                                         \n",
       "ANDAMAN AND NICOBAR ISLANDS        338       31               564  \n",
       "ANDHRA PRADESH                   36692    53849              9547  \n",
       "ARUNACHAL PRADESH               162815      771            362553  \n",
       "ASSAM                            54993    25949             27118  \n",
       "BIHAR                            25453    18914             13437  \n",
       "CHANDIGARH                        1160     1960               246  \n",
       "CHHATTISGARH                     70467    61510            494594  \n",
       "DADRA AND NAGAR HAVELI             634     1186               293  \n",
       "DAMAN AND DIU                      217      287                79  \n",
       "GOA                               1095     1109               258  \n",
       "GUJARAT                          30483   579654             16480  \n",
       "HARYANA                           7514    52613              2548  \n",
       "HIMACHAL PRADESH                 78659     1805               856  \n",
       "JAMMU AND KASHMIR               112584     2490              1508  \n",
       "JHARKHAND                         8956    14974           4235786  \n",
       "KARNATAKA                        95710   440280             11263  \n",
       "KERALA                            4752     4489              7618  \n",
       "LAKSHADWEEP                         10       11                 7  \n",
       "MADHYA PRADESH                  216052   567028            599594  \n",
       "MAHARASHTRA                    6531200  1400349            178965  \n",
       "MANIPUR                           7084     1692            233767  \n",
       "MEGHALAYA                         9864      627            258271  \n",
       "MIZORAM                          93411      376               808  \n",
       "NAGALAND                          6759     2655              3214  \n",
       "NCT OF DELHI                     18449   166231              2197  \n",
       "ORISSA                           13852     9420            478317  \n",
       "PONDICHERRY                        451     1400               168  \n",
       "PUNJAB                           33237    45040             10886  \n",
       "RAJASTHAN                        12185   622023              4676  \n",
       "SIKKIM                          167216      314             16300  \n",
       "TAMIL NADU                       11186    89265              7414  \n",
       "TRIPURA                         125385      860              1514  \n",
       "UTTAR PRADESH                   206285   213267             13598  \n",
       "UTTARAKHAND                      14926     9183               993  \n",
       "WEST BENGAL                     282898    60141            942297  "
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataR"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div id=\"chart_idKZhfPvDF\"</div>\n",
       "    <script type=\"text/javascript\">new Highcharts.Chart({\"title\":{\"text\":\"Religion dist of India\"},\"series\":[{\"data\":[[\"ANDAMAN AND NICOBAR ISLANDS\",338],[\"ANDHRA PRADESH\",36692],[\"ARUNACHAL PRADESH\",162815],[\"ASSAM\",54993],[\"BIHAR\",25453],[\"CHANDIGARH\",1160],[\"CHHATTISGARH\",70467],[\"DADRA AND NAGAR HAVELI\",634],[\"DAMAN AND DIU\",217],[\"GOA\",1095],[\"GUJARAT\",30483],[\"HARYANA\",7514],[\"HIMACHAL PRADESH\",78659],[\"JAMMU AND KASHMIR\",112584],[\"JHARKHAND\",8956],[\"KARNATAKA\",95710],[\"KERALA\",4752],[\"LAKSHADWEEP\",10],[\"MADHYA PRADESH\",216052],[\"MAHARASHTRA\",6531200],[\"MANIPUR\",7084],[\"MEGHALAYA\",9864],[\"MIZORAM\",93411],[\"NAGALAND\",6759],[\"NCT OF DELHI\",18449],[\"ORISSA\",13852],[\"PONDICHERRY\",451],[\"PUNJAB\",33237],[\"RAJASTHAN\",12185],[\"SIKKIM\",167216],[\"TAMIL NADU\",11186],[\"TRIPURA\",125385],[\"UTTAR PRADESH\",206285],[\"UTTARAKHAND\",14926],[\"WEST BENGAL\",282898]],\"name\":\"Buddhists\",\"yAxis\":0},{\"data\":[[\"ANDAMAN AND NICOBAR ISLANDS\",80984],[\"ANDHRA PRADESH\",1129784],[\"ARUNACHAL PRADESH\",418732],[\"ASSAM\",1165867],[\"BIHAR\",129247],[\"CHANDIGARH\",8720],[\"CHHATTISGARH\",490542],[\"DADRA AND NAGAR HAVELI\",5113],[\"DAMAN AND DIU\",2820],[\"GOA\",366130],[\"GUJARAT\",316178],[\"HARYANA\",50353],[\"HIMACHAL PRADESH\",12646],[\"JAMMU AND KASHMIR\",35631],[\"JHARKHAND\",1418608],[\"KARNATAKA\",1142647],[\"KERALA\",6141269],[\"LAKSHADWEEP\",317],[\"MADHYA PRADESH\",213282],[\"MAHARASHTRA\",1080073],[\"MANIPUR\",1179043],[\"MEGHALAYA\",2213027],[\"MIZORAM\",956331],[\"NAGALAND\",1739651],[\"NCT OF DELHI\",146093],[\"ORISSA\",1161708],[\"PONDICHERRY\",78550],[\"PUNJAB\",348230],[\"RAJASTHAN\",96430],[\"SIKKIM\",60522],[\"TAMIL NADU\",4418331],[\"TRIPURA\",159882],[\"UTTAR PRADESH\",356448],[\"UTTARAKHAND\",37781],[\"WEST BENGAL\",658618]],\"name\":\"Christians\",\"yAxis\":0},{\"data\":[[\"ANDAMAN AND NICOBAR ISLANDS\",264296],[\"ANDHRA PRADESH\",74824149],[\"ARUNACHAL PRADESH\",401876],[\"ASSAM\",19180759],[\"BIHAR\",86078686],[\"CHANDIGARH\",852574],[\"CHHATTISGARH\",23819789],[\"DADRA AND NAGAR HAVELI\",322857],[\"DAMAN AND DIU\",220150],[\"GOA\",963877],[\"GUJARAT\",53533988],[\"HARYANA\",22171128],[\"HIMACHAL PRADESH\",6532765],[\"JAMMU AND KASHMIR\",3566674],[\"JHARKHAND\",22376051],[\"KARNATAKA\",51317472],[\"KERALA\",18282492],[\"LAKSHADWEEP\",1788],[\"MADHYA PRADESH\",66007121],[\"MAHARASHTRA\",89703057],[\"MANIPUR\",1181876],[\"MEGHALAYA\",342078],[\"MIZORAM\",30136],[\"NAGALAND\",173054],[\"NCT OF DELHI\",13712100],[\"ORISSA\",39300341],[\"PONDICHERRY\",1089409],[\"PUNJAB\",10678138],[\"RAJASTHAN\",60657103],[\"SIKKIM\",352662],[\"TAMIL NADU\",63188168],[\"TRIPURA\",3063903],[\"UTTAR PRADESH\",159312654],[\"UTTARAKHAND\",8368636],[\"WEST BENGAL\",64385546]],\"name\":\"Hindus\",\"yAxis\":0},{\"data\":[[\"ANDAMAN AND NICOBAR ISLANDS\",31],[\"ANDHRA PRADESH\",53849],[\"ARUNACHAL PRADESH\",771],[\"ASSAM\",25949],[\"BIHAR\",18914],[\"CHANDIGARH\",1960],[\"CHHATTISGARH\",61510],[\"DADRA AND NAGAR HAVELI\",1186],[\"DAMAN AND DIU\",287],[\"GOA\",1109],[\"GUJARAT\",579654],[\"HARYANA\",52613],[\"HIMACHAL PRADESH\",1805],[\"JAMMU AND KASHMIR\",2490],[\"JHARKHAND\",14974],[\"KARNATAKA\",440280],[\"KERALA\",4489],[\"LAKSHADWEEP\",11],[\"MADHYA PRADESH\",567028],[\"MAHARASHTRA\",1400349],[\"MANIPUR\",1692],[\"MEGHALAYA\",627],[\"MIZORAM\",376],[\"NAGALAND\",2655],[\"NCT OF DELHI\",166231],[\"ORISSA\",9420],[\"PONDICHERRY\",1400],[\"PUNJAB\",45040],[\"RAJASTHAN\",622023],[\"SIKKIM\",314],[\"TAMIL NADU\",89265],[\"TRIPURA\",860],[\"UTTAR PRADESH\",213267],[\"UTTARAKHAND\",9183],[\"WEST BENGAL\",60141]],\"name\":\"Jains\",\"yAxis\":0},{\"data\":[[\"ANDAMAN AND NICOBAR ISLANDS\",32413],[\"ANDHRA PRADESH\",8082412],[\"ARUNACHAL PRADESH\",27045],[\"ASSAM\",10679345],[\"BIHAR\",17557809],[\"CHANDIGARH\",51447],[\"CHHATTISGARH\",514998],[\"DADRA AND NAGAR HAVELI\",12922],[\"DAMAN AND DIU\",19277],[\"GOA\",121564],[\"GUJARAT\",5846761],[\"HARYANA\",1781342],[\"HIMACHAL PRADESH\",149881],[\"JAMMU AND KASHMIR\",8567485],[\"JHARKHAND\",4793994],[\"KARNATAKA\",7893065],[\"KERALA\",8873472],[\"LAKSHADWEEP\",62268],[\"MADHYA PRADESH\",4774695],[\"MAHARASHTRA\",12971152],[\"MANIPUR\",239836],[\"MEGHALAYA\",130399],[\"MIZORAM\",14832],[\"NAGALAND\",48963],[\"NCT OF DELHI\",2158684],[\"ORISSA\",911670],[\"PONDICHERRY\",75556],[\"PUNJAB\",535489],[\"RAJASTHAN\",6215377],[\"SIKKIM\",9867],[\"TAMIL NADU\",4229479],[\"TRIPURA\",316042],[\"UTTAR PRADESH\",38483967],[\"UTTARAKHAND\",1406825],[\"WEST BENGAL\",24654825]],\"name\":\"Muslims\",\"yAxis\":0},{\"data\":[[\"ANDAMAN AND NICOBAR ISLANDS\",564],[\"ANDHRA PRADESH\",9547],[\"ARUNACHAL PRADESH\",362553],[\"ASSAM\",27118],[\"BIHAR\",13437],[\"CHANDIGARH\",246],[\"CHHATTISGARH\",494594],[\"DADRA AND NAGAR HAVELI\",293],[\"DAMAN AND DIU\",79],[\"GOA\",258],[\"GUJARAT\",16480],[\"HARYANA\",2548],[\"HIMACHAL PRADESH\",856],[\"JAMMU AND KASHMIR\",1508],[\"JHARKHAND\",4235786],[\"KARNATAKA\",11263],[\"KERALA\",7618],[\"LAKSHADWEEP\",7],[\"MADHYA PRADESH\",599594],[\"MAHARASHTRA\",178965],[\"MANIPUR\",233767],[\"MEGHALAYA\",258271],[\"MIZORAM\",808],[\"NAGALAND\",3214],[\"NCT OF DELHI\",2197],[\"ORISSA\",478317],[\"PONDICHERRY\",168],[\"PUNJAB\",10886],[\"RAJASTHAN\",4676],[\"SIKKIM\",16300],[\"TAMIL NADU\",7414],[\"TRIPURA\",1514],[\"UTTAR PRADESH\",13598],[\"UTTARAKHAND\",993],[\"WEST BENGAL\",942297]],\"name\":\"Others_Religions\",\"yAxis\":0},{\"data\":[[\"ANDAMAN AND NICOBAR ISLANDS\",1286],[\"ANDHRA PRADESH\",40244],[\"ARUNACHAL PRADESH\",3287],[\"ASSAM\",20672],[\"BIHAR\",23779],[\"CHANDIGARH\",138329],[\"CHHATTISGARH\",70036],[\"DADRA AND NAGAR HAVELI\",217],[\"DAMAN AND DIU\",172],[\"GOA\",1473],[\"GUJARAT\",58246],[\"HARYANA\",1243752],[\"HIMACHAL PRADESH\",79896],[\"JAMMU AND KASHMIR\",234848],[\"JHARKHAND\",71422],[\"KARNATAKA\",28773],[\"KERALA\",3814],[\"LAKSHADWEEP\",8],[\"MADHYA PRADESH\",151412],[\"MAHARASHTRA\",223247],[\"MANIPUR\",1527],[\"MEGHALAYA\",3045],[\"MIZORAM\",286],[\"NAGALAND\",1890],[\"NCT OF DELHI\",570581],[\"ORISSA\",21991],[\"PONDICHERRY\",297],[\"PUNJAB\",16004754],[\"RAJASTHAN\",872930],[\"SIKKIM\",1868],[\"TAMIL NADU\",14601],[\"TRIPURA\",1070],[\"UTTAR PRADESH\",643500],[\"UTTARAKHAND\",236340],[\"WEST BENGAL\",63523]],\"name\":\"Sikhs\",\"yAxis\":0}],\"yAxis\":[{}],\"chart\":{\"width\":1000,\"renderTo\":\"chart_idKZhfPvDF\",\"type\":\"column\",\"height\":900},\"xAxis\":{\"categories\":[\"ANDAMAN AND NICOBAR ISLANDS\",\"ANDHRA PRADESH\",\"ARUNACHAL PRADESH\",\"ASSAM\",\"BIHAR\",\"CHANDIGARH\",\"CHHATTISGARH\",\"DADRA AND NAGAR HAVELI\",\"DAMAN AND DIU\",\"GOA\",\"GUJARAT\",\"HARYANA\",\"HIMACHAL PRADESH\",\"JAMMU AND KASHMIR\",\"JHARKHAND\",\"KARNATAKA\",\"KERALA\",\"LAKSHADWEEP\",\"MADHYA PRADESH\",\"MAHARASHTRA\",\"MANIPUR\",\"MEGHALAYA\",\"MIZORAM\",\"NAGALAND\",\"NCT OF DELHI\",\"ORISSA\",\"PONDICHERRY\",\"PUNJAB\",\"RAJASTHAN\",\"SIKKIM\",\"TAMIL NADU\",\"TRIPURA\",\"UTTAR PRADESH\",\"UTTARAKHAND\",\"WEST BENGAL\"],\"title\":{\"text\":\"State Name\"}},\"legend\":{\"enabled\":true}});</script>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display_charts(dataR, title=\"Religion dist of India\",kind=\"bar\",figsize = (1000, 900))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {},
   "outputs": [],
   "source": [
    "dataP = dataCen[['State Name','SC','Population']]\n",
    "dataP = dataP.groupby(['State Name'])[['SC','Population']].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "metadata": {
    "scrolled": true
   },
   "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>SC</th>\n",
       "      <th>Population</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>State Name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ANDAMAN AND NICOBAR ISLANDS</th>\n",
       "      <td>0</td>\n",
       "      <td>380581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ANDHRA PRADESH</th>\n",
       "      <td>13878078</td>\n",
       "      <td>84580777</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ARUNACHAL PRADESH</th>\n",
       "      <td>0</td>\n",
       "      <td>1383727</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ASSAM</th>\n",
       "      <td>2231321</td>\n",
       "      <td>31205576</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BIHAR</th>\n",
       "      <td>16567325</td>\n",
       "      <td>104099452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHANDIGARH</th>\n",
       "      <td>199086</td>\n",
       "      <td>1055450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHHATTISGARH</th>\n",
       "      <td>3274269</td>\n",
       "      <td>25545198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DADRA AND NAGAR HAVELI</th>\n",
       "      <td>6186</td>\n",
       "      <td>343709</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DAMAN AND DIU</th>\n",
       "      <td>6124</td>\n",
       "      <td>243247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GOA</th>\n",
       "      <td>25449</td>\n",
       "      <td>1458545</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GUJARAT</th>\n",
       "      <td>4074447</td>\n",
       "      <td>60439692</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HARYANA</th>\n",
       "      <td>5113615</td>\n",
       "      <td>25351462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HIMACHAL PRADESH</th>\n",
       "      <td>1729252</td>\n",
       "      <td>6864602</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JAMMU AND KASHMIR</th>\n",
       "      <td>924991</td>\n",
       "      <td>12541302</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JHARKHAND</th>\n",
       "      <td>3985644</td>\n",
       "      <td>32988134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KARNATAKA</th>\n",
       "      <td>10474992</td>\n",
       "      <td>61095297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KERALA</th>\n",
       "      <td>3039573</td>\n",
       "      <td>33406061</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LAKSHADWEEP</th>\n",
       "      <td>0</td>\n",
       "      <td>64473</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MADHYA PRADESH</th>\n",
       "      <td>11342320</td>\n",
       "      <td>72626809</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MAHARASHTRA</th>\n",
       "      <td>13275898</td>\n",
       "      <td>112374333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MANIPUR</th>\n",
       "      <td>97328</td>\n",
       "      <td>2855794</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MEGHALAYA</th>\n",
       "      <td>17355</td>\n",
       "      <td>2966889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MIZORAM</th>\n",
       "      <td>1218</td>\n",
       "      <td>1097206</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NAGALAND</th>\n",
       "      <td>0</td>\n",
       "      <td>1978502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NCT OF DELHI</th>\n",
       "      <td>2812309</td>\n",
       "      <td>16787941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ORISSA</th>\n",
       "      <td>7188463</td>\n",
       "      <td>41974218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PONDICHERRY</th>\n",
       "      <td>196325</td>\n",
       "      <td>1247953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PUNJAB</th>\n",
       "      <td>8860179</td>\n",
       "      <td>27743338</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RAJASTHAN</th>\n",
       "      <td>12221593</td>\n",
       "      <td>68548437</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SIKKIM</th>\n",
       "      <td>28275</td>\n",
       "      <td>610577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TAMIL NADU</th>\n",
       "      <td>14438445</td>\n",
       "      <td>72147030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TRIPURA</th>\n",
       "      <td>654918</td>\n",
       "      <td>3673917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UTTAR PRADESH</th>\n",
       "      <td>41357608</td>\n",
       "      <td>199812341</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UTTARAKHAND</th>\n",
       "      <td>1892516</td>\n",
       "      <td>10086292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WEST BENGAL</th>\n",
       "      <td>21463270</td>\n",
       "      <td>91276115</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   SC  Population\n",
       "State Name                                       \n",
       "ANDAMAN AND NICOBAR ISLANDS         0      380581\n",
       "ANDHRA PRADESH               13878078    84580777\n",
       "ARUNACHAL PRADESH                   0     1383727\n",
       "ASSAM                         2231321    31205576\n",
       "BIHAR                        16567325   104099452\n",
       "CHANDIGARH                     199086     1055450\n",
       "CHHATTISGARH                  3274269    25545198\n",
       "DADRA AND NAGAR HAVELI           6186      343709\n",
       "DAMAN AND DIU                    6124      243247\n",
       "GOA                             25449     1458545\n",
       "GUJARAT                       4074447    60439692\n",
       "HARYANA                       5113615    25351462\n",
       "HIMACHAL PRADESH              1729252     6864602\n",
       "JAMMU AND KASHMIR              924991    12541302\n",
       "JHARKHAND                     3985644    32988134\n",
       "KARNATAKA                    10474992    61095297\n",
       "KERALA                        3039573    33406061\n",
       "LAKSHADWEEP                         0       64473\n",
       "MADHYA PRADESH               11342320    72626809\n",
       "MAHARASHTRA                  13275898   112374333\n",
       "MANIPUR                         97328     2855794\n",
       "MEGHALAYA                       17355     2966889\n",
       "MIZORAM                          1218     1097206\n",
       "NAGALAND                            0     1978502\n",
       "NCT OF DELHI                  2812309    16787941\n",
       "ORISSA                        7188463    41974218\n",
       "PONDICHERRY                    196325     1247953\n",
       "PUNJAB                        8860179    27743338\n",
       "RAJASTHAN                    12221593    68548437\n",
       "SIKKIM                          28275      610577\n",
       "TAMIL NADU                   14438445    72147030\n",
       "TRIPURA                        654918     3673917\n",
       "UTTAR PRADESH                41357608   199812341\n",
       "UTTARAKHAND                   1892516    10086292\n",
       "WEST BENGAL                  21463270    91276115"
      ]
     },
     "execution_count": 107,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataP"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {},
   "outputs": [],
   "source": [
    "perc = (dataP.SC*100/dataP.Population)\n",
    "dataP['perc'] = perc"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "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>SC</th>\n",
       "      <th>Population</th>\n",
       "      <th>perc</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>State Name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ANDAMAN AND NICOBAR ISLANDS</th>\n",
       "      <td>0</td>\n",
       "      <td>380581</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ANDHRA PRADESH</th>\n",
       "      <td>13878078</td>\n",
       "      <td>84580777</td>\n",
       "      <td>16.408076</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ARUNACHAL PRADESH</th>\n",
       "      <td>0</td>\n",
       "      <td>1383727</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ASSAM</th>\n",
       "      <td>2231321</td>\n",
       "      <td>31205576</td>\n",
       "      <td>7.150392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BIHAR</th>\n",
       "      <td>16567325</td>\n",
       "      <td>104099452</td>\n",
       "      <td>15.914901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHANDIGARH</th>\n",
       "      <td>199086</td>\n",
       "      <td>1055450</td>\n",
       "      <td>18.862665</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHHATTISGARH</th>\n",
       "      <td>3274269</td>\n",
       "      <td>25545198</td>\n",
       "      <td>12.817552</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DADRA AND NAGAR HAVELI</th>\n",
       "      <td>6186</td>\n",
       "      <td>343709</td>\n",
       "      <td>1.799778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DAMAN AND DIU</th>\n",
       "      <td>6124</td>\n",
       "      <td>243247</td>\n",
       "      <td>2.517606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GOA</th>\n",
       "      <td>25449</td>\n",
       "      <td>1458545</td>\n",
       "      <td>1.744821</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GUJARAT</th>\n",
       "      <td>4074447</td>\n",
       "      <td>60439692</td>\n",
       "      <td>6.741343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HARYANA</th>\n",
       "      <td>5113615</td>\n",
       "      <td>25351462</td>\n",
       "      <td>20.170888</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HIMACHAL PRADESH</th>\n",
       "      <td>1729252</td>\n",
       "      <td>6864602</td>\n",
       "      <td>25.190856</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JAMMU AND KASHMIR</th>\n",
       "      <td>924991</td>\n",
       "      <td>12541302</td>\n",
       "      <td>7.375558</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JHARKHAND</th>\n",
       "      <td>3985644</td>\n",
       "      <td>32988134</td>\n",
       "      <td>12.082054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KARNATAKA</th>\n",
       "      <td>10474992</td>\n",
       "      <td>61095297</td>\n",
       "      <td>17.145333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KERALA</th>\n",
       "      <td>3039573</td>\n",
       "      <td>33406061</td>\n",
       "      <td>9.098867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LAKSHADWEEP</th>\n",
       "      <td>0</td>\n",
       "      <td>64473</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MADHYA PRADESH</th>\n",
       "      <td>11342320</td>\n",
       "      <td>72626809</td>\n",
       "      <td>15.617263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MAHARASHTRA</th>\n",
       "      <td>13275898</td>\n",
       "      <td>112374333</td>\n",
       "      <td>11.813995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MANIPUR</th>\n",
       "      <td>97328</td>\n",
       "      <td>2855794</td>\n",
       "      <td>3.408089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MEGHALAYA</th>\n",
       "      <td>17355</td>\n",
       "      <td>2966889</td>\n",
       "      <td>0.584956</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MIZORAM</th>\n",
       "      <td>1218</td>\n",
       "      <td>1097206</td>\n",
       "      <td>0.111009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NAGALAND</th>\n",
       "      <td>0</td>\n",
       "      <td>1978502</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NCT OF DELHI</th>\n",
       "      <td>2812309</td>\n",
       "      <td>16787941</td>\n",
       "      <td>16.751959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ORISSA</th>\n",
       "      <td>7188463</td>\n",
       "      <td>41974218</td>\n",
       "      <td>17.125901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PONDICHERRY</th>\n",
       "      <td>196325</td>\n",
       "      <td>1247953</td>\n",
       "      <td>15.731762</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PUNJAB</th>\n",
       "      <td>8860179</td>\n",
       "      <td>27743338</td>\n",
       "      <td>31.936240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RAJASTHAN</th>\n",
       "      <td>12221593</td>\n",
       "      <td>68548437</td>\n",
       "      <td>17.829134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SIKKIM</th>\n",
       "      <td>28275</td>\n",
       "      <td>610577</td>\n",
       "      <td>4.630866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TAMIL NADU</th>\n",
       "      <td>14438445</td>\n",
       "      <td>72147030</td>\n",
       "      <td>20.012529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TRIPURA</th>\n",
       "      <td>654918</td>\n",
       "      <td>3673917</td>\n",
       "      <td>17.826151</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UTTAR PRADESH</th>\n",
       "      <td>41357608</td>\n",
       "      <td>199812341</td>\n",
       "      <td>20.698225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UTTARAKHAND</th>\n",
       "      <td>1892516</td>\n",
       "      <td>10086292</td>\n",
       "      <td>18.763248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WEST BENGAL</th>\n",
       "      <td>21463270</td>\n",
       "      <td>91276115</td>\n",
       "      <td>23.514662</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   SC  Population       perc\n",
       "State Name                                                  \n",
       "ANDAMAN AND NICOBAR ISLANDS         0      380581   0.000000\n",
       "ANDHRA PRADESH               13878078    84580777  16.408076\n",
       "ARUNACHAL PRADESH                   0     1383727   0.000000\n",
       "ASSAM                         2231321    31205576   7.150392\n",
       "BIHAR                        16567325   104099452  15.914901\n",
       "CHANDIGARH                     199086     1055450  18.862665\n",
       "CHHATTISGARH                  3274269    25545198  12.817552\n",
       "DADRA AND NAGAR HAVELI           6186      343709   1.799778\n",
       "DAMAN AND DIU                    6124      243247   2.517606\n",
       "GOA                             25449     1458545   1.744821\n",
       "GUJARAT                       4074447    60439692   6.741343\n",
       "HARYANA                       5113615    25351462  20.170888\n",
       "HIMACHAL PRADESH              1729252     6864602  25.190856\n",
       "JAMMU AND KASHMIR              924991    12541302   7.375558\n",
       "JHARKHAND                     3985644    32988134  12.082054\n",
       "KARNATAKA                    10474992    61095297  17.145333\n",
       "KERALA                        3039573    33406061   9.098867\n",
       "LAKSHADWEEP                         0       64473   0.000000\n",
       "MADHYA PRADESH               11342320    72626809  15.617263\n",
       "MAHARASHTRA                  13275898   112374333  11.813995\n",
       "MANIPUR                         97328     2855794   3.408089\n",
       "MEGHALAYA                       17355     2966889   0.584956\n",
       "MIZORAM                          1218     1097206   0.111009\n",
       "NAGALAND                            0     1978502   0.000000\n",
       "NCT OF DELHI                  2812309    16787941  16.751959\n",
       "ORISSA                        7188463    41974218  17.125901\n",
       "PONDICHERRY                    196325     1247953  15.731762\n",
       "PUNJAB                        8860179    27743338  31.936240\n",
       "RAJASTHAN                    12221593    68548437  17.829134\n",
       "SIKKIM                          28275      610577   4.630866\n",
       "TAMIL NADU                   14438445    72147030  20.012529\n",
       "TRIPURA                        654918     3673917  17.826151\n",
       "UTTAR PRADESH                41357608   199812341  20.698225\n",
       "UTTARAKHAND                   1892516    10086292  18.763248\n",
       "WEST BENGAL                  21463270    91276115  23.514662"
      ]
     },
     "execution_count": 109,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataP"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div id=\"chart_idCvNIjHpq\"</div>\n",
       "    <script type=\"text/javascript\">new Highcharts.Chart({\"title\":{\"text\":\"SC % Statewise\"},\"series\":[{\"data\":[[\"ANDAMAN AND NICOBAR ISLANDS\",0.0],[\"ANDHRA PRADESH\",16.4080757972],[\"ARUNACHAL PRADESH\",0.0],[\"ASSAM\",7.1503919684],[\"BIHAR\",15.9149012619],[\"CHANDIGARH\",18.8626652139],[\"CHHATTISGARH\",12.8175518546],[\"DADRA AND NAGAR HAVELI\",1.7997783008],[\"DAMAN AND DIU\",2.5176055614],[\"GOA\",1.7448210374],[\"GUJARAT\",6.7413430896],[\"HARYANA\",20.1708879748],[\"HIMACHAL PRADESH\",25.1908559302],[\"JAMMU AND KASHMIR\",7.3755579764],[\"JHARKHAND\",12.0820535045],[\"KARNATAKA\",17.1453328069],[\"KERALA\",9.0988668194],[\"LAKSHADWEEP\",0.0],[\"MADHYA PRADESH\",15.6172633166],[\"MAHARASHTRA\",11.8139949271],[\"MANIPUR\",3.4080889588],[\"MEGHALAYA\",0.5849561612],[\"MIZORAM\",0.1110092362],[\"NAGALAND\",0.0],[\"NCT OF DELHI\",16.7519590401],[\"ORISSA\",17.1259009519],[\"PONDICHERRY\",15.731762334],[\"PUNJAB\",31.9362399723],[\"RAJASTHAN\",17.8291344557],[\"SIKKIM\",4.6308655583],[\"TAMIL NADU\",20.0125285823],[\"TRIPURA\",17.8261512168],[\"UTTAR PRADESH\",20.6982250411],[\"UTTARAKHAND\",18.7632481788],[\"WEST BENGAL\",23.5146620778]],\"name\":\"perc\",\"yAxis\":0}],\"yAxis\":[{}],\"chart\":{\"width\":1000,\"renderTo\":\"chart_idCvNIjHpq\",\"type\":\"column\",\"height\":900},\"xAxis\":{\"categories\":[\"ANDAMAN AND NICOBAR ISLANDS\",\"ANDHRA PRADESH\",\"ARUNACHAL PRADESH\",\"ASSAM\",\"BIHAR\",\"CHANDIGARH\",\"CHHATTISGARH\",\"DADRA AND NAGAR HAVELI\",\"DAMAN AND DIU\",\"GOA\",\"GUJARAT\",\"HARYANA\",\"HIMACHAL PRADESH\",\"JAMMU AND KASHMIR\",\"JHARKHAND\",\"KARNATAKA\",\"KERALA\",\"LAKSHADWEEP\",\"MADHYA PRADESH\",\"MAHARASHTRA\",\"MANIPUR\",\"MEGHALAYA\",\"MIZORAM\",\"NAGALAND\",\"NCT OF DELHI\",\"ORISSA\",\"PONDICHERRY\",\"PUNJAB\",\"RAJASTHAN\",\"SIKKIM\",\"TAMIL NADU\",\"TRIPURA\",\"UTTAR PRADESH\",\"UTTARAKHAND\",\"WEST BENGAL\"],\"title\":{\"text\":\"State Name\"}},\"legend\":{\"enabled\":true}});</script>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "dataP = dataP.groupby(['State Name'])[['perc']].sum()\n",
    "display_charts(dataP, title=\"SC % Statewise\",kind=\"bar\",figsize = (1000, 900))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div id=\"chart_idpbRWsvlf\"</div>\n",
       "    <script type=\"text/javascript\">new Highcharts.Chart({\"title\":{\"text\":\"ST % Statewise\"},\"series\":[{\"data\":[[\"ANDAMAN AND NICOBAR ISLANDS\",7.4964330852],[\"ANDHRA PRADESH\",6.9969480181],[\"ARUNACHAL PRADESH\",68.7867621287],[\"ASSAM\",12.447682427],[\"BIHAR\",1.2839385552],[\"CHANDIGARH\",0.0],[\"CHHATTISGARH\",30.6237673319],[\"DADRA AND NAGAR HAVELI\",51.9520873762],[\"DAMAN AND DIU\",6.3158024559],[\"GOA\",10.2345145333],[\"GUJARAT\",14.753837594],[\"HARYANA\",0.0],[\"HIMACHAL PRADESH\",5.7122903848],[\"JAMMU AND KASHMIR\",11.9070492043],[\"JHARKHAND\",26.2065201991],[\"KARNATAKA\",6.9546875269],[\"KERALA\",1.4513504002],[\"LAKSHADWEEP\",94.7993733811],[\"MADHYA PRADESH\",21.0897108257],[\"MAHARASHTRA\",9.3528590733],[\"MANIPUR\",40.8790690085],[\"MEGHALAYA\",86.1461618551],[\"MIZORAM\",94.4321303383],[\"NAGALAND\",86.4782042171],[\"NCT OF DELHI\",0.0],[\"ORISSA\",22.8491594531],[\"PONDICHERRY\",0.0],[\"PUNJAB\",0.0],[\"RAJASTHAN\",13.4773809649],[\"SIKKIM\",33.7975390491],[\"TAMIL NADU\",1.1014964857],[\"TRIPURA\",31.7593728982],[\"UTTAR PRADESH\",0.5676691411],[\"UTTARAKHAND\",2.8940566067],[\"WEST BENGAL\",5.8032191664]],\"name\":\"perc\",\"yAxis\":0}],\"yAxis\":[{}],\"chart\":{\"width\":1000,\"renderTo\":\"chart_idpbRWsvlf\",\"type\":\"column\",\"height\":900},\"xAxis\":{\"categories\":[\"ANDAMAN AND NICOBAR ISLANDS\",\"ANDHRA PRADESH\",\"ARUNACHAL PRADESH\",\"ASSAM\",\"BIHAR\",\"CHANDIGARH\",\"CHHATTISGARH\",\"DADRA AND NAGAR HAVELI\",\"DAMAN AND DIU\",\"GOA\",\"GUJARAT\",\"HARYANA\",\"HIMACHAL PRADESH\",\"JAMMU AND KASHMIR\",\"JHARKHAND\",\"KARNATAKA\",\"KERALA\",\"LAKSHADWEEP\",\"MADHYA PRADESH\",\"MAHARASHTRA\",\"MANIPUR\",\"MEGHALAYA\",\"MIZORAM\",\"NAGALAND\",\"NCT OF DELHI\",\"ORISSA\",\"PONDICHERRY\",\"PUNJAB\",\"RAJASTHAN\",\"SIKKIM\",\"TAMIL NADU\",\"TRIPURA\",\"UTTAR PRADESH\",\"UTTARAKHAND\",\"WEST BENGAL\"],\"title\":{\"text\":\"State Name\"}},\"legend\":{\"enabled\":true}});</script>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "dataP = dataCen[['State Name','ST','Population']]\n",
    "dataP = dataP.groupby(['State Name'])[['ST','Population']].sum()\n",
    "perc = (dataP.ST*100/dataP.Population)\n",
    "dataP['perc'] = perc\n",
    "dataP = dataP.groupby(['State Name'])[['perc']].sum()\n",
    "display_charts(dataP, title=\"ST % Statewise\",kind=\"bar\",figsize = (1000, 900))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}