pandas_3.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "00575645",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "810f148d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>state</th>\n",
       "      <th>confirmed</th>\n",
       "      <th>active</th>\n",
       "      <th>passive</th>\n",
       "      <th>deaths</th>\n",
       "      <th>dose1</th>\n",
       "      <th>dose2</th>\n",
       "      <th>dose3</th>\n",
       "      <th>precaution_dose</th>\n",
       "      <th>total_doses</th>\n",
       "      <th>population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Andaman and Nicobar</td>\n",
       "      <td>10742</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10612</td>\n",
       "      <td>129.0</td>\n",
       "      <td>313284.0</td>\n",
       "      <td>320383</td>\n",
       "      <td>236936.0</td>\n",
       "      <td>53427.0</td>\n",
       "      <td>991263</td>\n",
       "      <td>426251.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Andhra Pradesh</td>\n",
       "      <td>2339067</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2324331</td>\n",
       "      <td>14733.0</td>\n",
       "      <td>40643161.0</td>\n",
       "      <td>43549055</td>\n",
       "      <td>11703273.0</td>\n",
       "      <td>6579565.0</td>\n",
       "      <td>110556756</td>\n",
       "      <td>52883163.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Arunachal Pradesh</td>\n",
       "      <td>66890</td>\n",
       "      <td>NaN</td>\n",
       "      <td>66594</td>\n",
       "      <td>296.0</td>\n",
       "      <td>860442.0</td>\n",
       "      <td>747177</td>\n",
       "      <td>NaN</td>\n",
       "      <td>58618.0</td>\n",
       "      <td>1911760</td>\n",
       "      <td>1528296.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Assam</td>\n",
       "      <td>746100</td>\n",
       "      <td>0.0</td>\n",
       "      <td>738065</td>\n",
       "      <td>8035.0</td>\n",
       "      <td>22549957.0</td>\n",
       "      <td>20561790</td>\n",
       "      <td>2082670.0</td>\n",
       "      <td>1259853.0</td>\n",
       "      <td>50284713</td>\n",
       "      <td>34586234.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Bihar</td>\n",
       "      <td>851379</td>\n",
       "      <td>15.0</td>\n",
       "      <td>839062</td>\n",
       "      <td>12302.0</td>\n",
       "      <td>62944633.0</td>\n",
       "      <td>59144387</td>\n",
       "      <td>11983504.0</td>\n",
       "      <td>3868082.0</td>\n",
       "      <td>157197041</td>\n",
       "      <td>119461013.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 state  confirmed  active  passive   deaths       dose1  \\\n",
       "0  Andaman and Nicobar      10742     1.0    10612    129.0    313284.0   \n",
       "1       Andhra Pradesh    2339067     3.0  2324331  14733.0  40643161.0   \n",
       "2    Arunachal Pradesh      66890     NaN    66594    296.0    860442.0   \n",
       "3                Assam     746100     0.0   738065   8035.0  22549957.0   \n",
       "4                Bihar     851379    15.0   839062  12302.0  62944633.0   \n",
       "\n",
       "      dose2       dose3  precaution_dose  total_doses   population  \n",
       "0    320383    236936.0          53427.0       991263     426251.0  \n",
       "1  43549055  11703273.0        6579565.0    110556756   52883163.0  \n",
       "2    747177         NaN          58618.0      1911760    1528296.0  \n",
       "3  20561790   2082670.0        1259853.0     50284713   34586234.0  \n",
       "4  59144387  11983504.0        3868082.0    157197041  119461013.0  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1 = pd.read_csv('Covid.csv')\n",
    "df1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "bba64987",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>state</th>\n",
       "      <th>confirmed</th>\n",
       "      <th>active</th>\n",
       "      <th>passive</th>\n",
       "      <th>deaths</th>\n",
       "      <th>dose1</th>\n",
       "      <th>dose2</th>\n",
       "      <th>dose3</th>\n",
       "      <th>precaution_dose</th>\n",
       "      <th>total_doses</th>\n",
       "      <th>population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Andaman and Nicobar</td>\n",
       "      <td>10742</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10612</td>\n",
       "      <td>129.0</td>\n",
       "      <td>313284.0</td>\n",
       "      <td>320383</td>\n",
       "      <td>236936.0</td>\n",
       "      <td>53427.0</td>\n",
       "      <td>991263</td>\n",
       "      <td>426251.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Andhra Pradesh</td>\n",
       "      <td>2339067</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2324331</td>\n",
       "      <td>14733.0</td>\n",
       "      <td>40643161.0</td>\n",
       "      <td>43549055</td>\n",
       "      <td>11703273.0</td>\n",
       "      <td>6579565.0</td>\n",
       "      <td>110556756</td>\n",
       "      <td>52883163.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Arunachal Pradesh</td>\n",
       "      <td>66890</td>\n",
       "      <td>NaN</td>\n",
       "      <td>66594</td>\n",
       "      <td>296.0</td>\n",
       "      <td>860442.0</td>\n",
       "      <td>747177</td>\n",
       "      <td>NaN</td>\n",
       "      <td>58618.0</td>\n",
       "      <td>1911760</td>\n",
       "      <td>1528296.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Assam</td>\n",
       "      <td>746100</td>\n",
       "      <td>0.0</td>\n",
       "      <td>738065</td>\n",
       "      <td>8035.0</td>\n",
       "      <td>22549957.0</td>\n",
       "      <td>20561790</td>\n",
       "      <td>2082670.0</td>\n",
       "      <td>1259853.0</td>\n",
       "      <td>50284713</td>\n",
       "      <td>34586234.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Bihar</td>\n",
       "      <td>851379</td>\n",
       "      <td>15.0</td>\n",
       "      <td>839062</td>\n",
       "      <td>12302.0</td>\n",
       "      <td>62944633.0</td>\n",
       "      <td>59144387</td>\n",
       "      <td>11983504.0</td>\n",
       "      <td>3868082.0</td>\n",
       "      <td>157197041</td>\n",
       "      <td>119461013.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Chandigarh</td>\n",
       "      <td>99348</td>\n",
       "      <td>6.0</td>\n",
       "      <td>98161</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1089254.0</td>\n",
       "      <td>917701</td>\n",
       "      <td>48480.0</td>\n",
       "      <td>63046.0</td>\n",
       "      <td>2282281</td>\n",
       "      <td>1182104.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Chhattisgarh</td>\n",
       "      <td>1177749</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1163597</td>\n",
       "      <td>14146.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18534989</td>\n",
       "      <td>5737679.0</td>\n",
       "      <td>1804891.0</td>\n",
       "      <td>49148991</td>\n",
       "      <td>28566990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Dadra and Nagar Haveli and Daman and Diu</td>\n",
       "      <td>11591</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11587</td>\n",
       "      <td>4.0</td>\n",
       "      <td>730746.0</td>\n",
       "      <td>594929</td>\n",
       "      <td>136967.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1578492</td>\n",
       "      <td>657391.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Delhi</td>\n",
       "      <td>2007188</td>\n",
       "      <td>35.0</td>\n",
       "      <td>1980632</td>\n",
       "      <td>26521.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14348835</td>\n",
       "      <td>2312803.0</td>\n",
       "      <td>1053393.0</td>\n",
       "      <td>37366540</td>\n",
       "      <td>18802494.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>NaN</td>\n",
       "      <td>259079</td>\n",
       "      <td>26.0</td>\n",
       "      <td>255040</td>\n",
       "      <td>4013.0</td>\n",
       "      <td>1354828.0</td>\n",
       "      <td>1224173</td>\n",
       "      <td>60838.0</td>\n",
       "      <td>76559.0</td>\n",
       "      <td>2872582</td>\n",
       "      <td>1542750.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Gujarat</td>\n",
       "      <td>1277557</td>\n",
       "      <td>41.0</td>\n",
       "      <td>1266473</td>\n",
       "      <td>11043.0</td>\n",
       "      <td>49314588.0</td>\n",
       "      <td>49428283</td>\n",
       "      <td>13459618.0</td>\n",
       "      <td>5938121.0</td>\n",
       "      <td>127793995</td>\n",
       "      <td>63907200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Haryana</td>\n",
       "      <td>1056602</td>\n",
       "      <td>43.0</td>\n",
       "      <td>1045845</td>\n",
       "      <td>10714.0</td>\n",
       "      <td>21955717.0</td>\n",
       "      <td>18732346</td>\n",
       "      <td>NaN</td>\n",
       "      <td>701811.0</td>\n",
       "      <td>45457359</td>\n",
       "      <td>27388008.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Himachal Pradesh</td>\n",
       "      <td>312644</td>\n",
       "      <td>23.0</td>\n",
       "      <td>308408</td>\n",
       "      <td>4213.0</td>\n",
       "      <td>6041658.0</td>\n",
       "      <td>5780254</td>\n",
       "      <td>1485328.0</td>\n",
       "      <td>823689.0</td>\n",
       "      <td>15278680</td>\n",
       "      <td>7316708.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Jammu and Kashmir</td>\n",
       "      <td>479410</td>\n",
       "      <td>17.0</td>\n",
       "      <td>474608</td>\n",
       "      <td>4785.0</td>\n",
       "      <td>9941757.0</td>\n",
       "      <td>10386967</td>\n",
       "      <td>930096.0</td>\n",
       "      <td>669871.0</td>\n",
       "      <td>24738045</td>\n",
       "      <td>14046258.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Jharkhand</td>\n",
       "      <td>442570</td>\n",
       "      <td>NaN</td>\n",
       "      <td>437236</td>\n",
       "      <td>5331.0</td>\n",
       "      <td>21300448.0</td>\n",
       "      <td>16046070</td>\n",
       "      <td>1306687.0</td>\n",
       "      <td>664308.0</td>\n",
       "      <td>43689818</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Karnataka</td>\n",
       "      <td>4071893</td>\n",
       "      <td>1275.0</td>\n",
       "      <td>4030311</td>\n",
       "      <td>40307.0</td>\n",
       "      <td>50016690.0</td>\n",
       "      <td>50455767</td>\n",
       "      <td>5727031.0</td>\n",
       "      <td>4726542.0</td>\n",
       "      <td>120928298</td>\n",
       "      <td>66165886.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Kerala</td>\n",
       "      <td>6828245</td>\n",
       "      <td>1389.0</td>\n",
       "      <td>6755304</td>\n",
       "      <td>71552.0</td>\n",
       "      <td>27013745.0</td>\n",
       "      <td>23791879</td>\n",
       "      <td>854595.0</td>\n",
       "      <td>2215656.0</td>\n",
       "      <td>57477992</td>\n",
       "      <td>35330888.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Ladakh</td>\n",
       "      <td>29412</td>\n",
       "      <td>3.0</td>\n",
       "      <td>29178</td>\n",
       "      <td>231.0</td>\n",
       "      <td>219564.0</td>\n",
       "      <td>186942</td>\n",
       "      <td>68766.0</td>\n",
       "      <td>53990.0</td>\n",
       "      <td>564943</td>\n",
       "      <td>307204.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Lakshadweep</td>\n",
       "      <td>11415</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11363</td>\n",
       "      <td>52.0</td>\n",
       "      <td>56908.0</td>\n",
       "      <td>55992</td>\n",
       "      <td>15757.0</td>\n",
       "      <td>6949.0</td>\n",
       "      <td>145008</td>\n",
       "      <td>72210.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Madhya Pradesh</td>\n",
       "      <td>1054918</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1044138</td>\n",
       "      <td>10776.0</td>\n",
       "      <td>54140166.0</td>\n",
       "      <td>54035268</td>\n",
       "      <td>9854998.0</td>\n",
       "      <td>3787239.0</td>\n",
       "      <td>133590886</td>\n",
       "      <td>82342793.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Maharashtra</td>\n",
       "      <td>8136588</td>\n",
       "      <td>164.0</td>\n",
       "      <td>7988008</td>\n",
       "      <td>148416.0</td>\n",
       "      <td>84644083.0</td>\n",
       "      <td>71593498</td>\n",
       "      <td>5022623.0</td>\n",
       "      <td>4450343.0</td>\n",
       "      <td>177678317</td>\n",
       "      <td>120837347.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Manipur</td>\n",
       "      <td>139922</td>\n",
       "      <td>0.0</td>\n",
       "      <td>137773</td>\n",
       "      <td>2149.0</td>\n",
       "      <td>1463998.0</td>\n",
       "      <td>1225599</td>\n",
       "      <td>114004.0</td>\n",
       "      <td>165096.0</td>\n",
       "      <td>3265933</td>\n",
       "      <td>3008546.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Meghalaya</td>\n",
       "      <td>96783</td>\n",
       "      <td>1.0</td>\n",
       "      <td>95158</td>\n",
       "      <td>1624.0</td>\n",
       "      <td>1332102.0</td>\n",
       "      <td>1024902</td>\n",
       "      <td>30706.0</td>\n",
       "      <td>56987.0</td>\n",
       "      <td>2621058</td>\n",
       "      <td>3276323.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Mizoram</td>\n",
       "      <td>238964</td>\n",
       "      <td>0.0</td>\n",
       "      <td>238238</td>\n",
       "      <td>726.0</td>\n",
       "      <td>785749.0</td>\n",
       "      <td>668814</td>\n",
       "      <td>79573.0</td>\n",
       "      <td>67619.0</td>\n",
       "      <td>1790818</td>\n",
       "      <td>1205974.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Nagaland</td>\n",
       "      <td>35986</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35204</td>\n",
       "      <td>782.0</td>\n",
       "      <td>837775.0</td>\n",
       "      <td>684306</td>\n",
       "      <td>26060.0</td>\n",
       "      <td>43640.0</td>\n",
       "      <td>1737554</td>\n",
       "      <td>2189297.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Odisha</td>\n",
       "      <td>1336552</td>\n",
       "      <td>91.0</td>\n",
       "      <td>1327256</td>\n",
       "      <td>9205.0</td>\n",
       "      <td>31453659.0</td>\n",
       "      <td>29949756</td>\n",
       "      <td>9995330.0</td>\n",
       "      <td>3199384.0</td>\n",
       "      <td>81445474</td>\n",
       "      <td>45429399.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Puducherry</td>\n",
       "      <td>175508</td>\n",
       "      <td>5.0</td>\n",
       "      <td>173528</td>\n",
       "      <td>1975.0</td>\n",
       "      <td>912901.0</td>\n",
       "      <td>801853</td>\n",
       "      <td>303475.0</td>\n",
       "      <td>106956.0</td>\n",
       "      <td>2272617</td>\n",
       "      <td>1397707.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Punjab</td>\n",
       "      <td>784205</td>\n",
       "      <td>49.0</td>\n",
       "      <td>764867</td>\n",
       "      <td>19289.0</td>\n",
       "      <td>22352681.0</td>\n",
       "      <td>19602907</td>\n",
       "      <td>799986.0</td>\n",
       "      <td>1041039.0</td>\n",
       "      <td>46970300</td>\n",
       "      <td>29611935.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Rajasthan</td>\n",
       "      <td>1315455</td>\n",
       "      <td>88.0</td>\n",
       "      <td>1305714</td>\n",
       "      <td>9653.0</td>\n",
       "      <td>51103054.0</td>\n",
       "      <td>46510275</td>\n",
       "      <td>4387205.0</td>\n",
       "      <td>2995864.0</td>\n",
       "      <td>115325059</td>\n",
       "      <td>78230816.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Sikkim</td>\n",
       "      <td>44319</td>\n",
       "      <td>1.0</td>\n",
       "      <td>43819</td>\n",
       "      <td>499.0</td>\n",
       "      <td>539927.0</td>\n",
       "      <td>509134</td>\n",
       "      <td>158276.0</td>\n",
       "      <td>55637.0</td>\n",
       "      <td>1360444</td>\n",
       "      <td>671720.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Tamil Nadu</td>\n",
       "      <td>3594388</td>\n",
       "      <td>60.0</td>\n",
       "      <td>3556279</td>\n",
       "      <td>38049.0</td>\n",
       "      <td>56659544.0</td>\n",
       "      <td>53499923</td>\n",
       "      <td>6033504.0</td>\n",
       "      <td>3021694.0</td>\n",
       "      <td>127442647</td>\n",
       "      <td>76481545.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Telengana</td>\n",
       "      <td>841324</td>\n",
       "      <td>71.0</td>\n",
       "      <td>837142</td>\n",
       "      <td>4111.0</td>\n",
       "      <td>29607672.0</td>\n",
       "      <td>29053708</td>\n",
       "      <td>10525975.0</td>\n",
       "      <td>2702159.0</td>\n",
       "      <td>77201709</td>\n",
       "      <td>38472769.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Tripura</td>\n",
       "      <td>108034</td>\n",
       "      <td>0.0</td>\n",
       "      <td>107094</td>\n",
       "      <td>940.0</td>\n",
       "      <td>2658852.0</td>\n",
       "      <td>2328613</td>\n",
       "      <td>271434.0</td>\n",
       "      <td>204733.0</td>\n",
       "      <td>5916312</td>\n",
       "      <td>4057847.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Uttar Pradesh</td>\n",
       "      <td>2128103</td>\n",
       "      <td>46.0</td>\n",
       "      <td>2104424</td>\n",
       "      <td>23633.0</td>\n",
       "      <td>154058287.0</td>\n",
       "      <td>147716010</td>\n",
       "      <td>35623544.0</td>\n",
       "      <td>9240735.0</td>\n",
       "      <td>390639497</td>\n",
       "      <td>228959599.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Uttarakhand</td>\n",
       "      <td>449379</td>\n",
       "      <td>28.0</td>\n",
       "      <td>441600</td>\n",
       "      <td>7751.0</td>\n",
       "      <td>8180312.0</td>\n",
       "      <td>7940592</td>\n",
       "      <td>1346150.0</td>\n",
       "      <td>867047.0</td>\n",
       "      <td>20051714</td>\n",
       "      <td>11090425.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>West Bengal</td>\n",
       "      <td>2118606</td>\n",
       "      <td>58.0</td>\n",
       "      <td>2097016</td>\n",
       "      <td>21532.0</td>\n",
       "      <td>67300236.0</td>\n",
       "      <td>61593452</td>\n",
       "      <td>10257324.0</td>\n",
       "      <td>5491943.0</td>\n",
       "      <td>155962840</td>\n",
       "      <td>97694960.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       state  confirmed  active  passive  \\\n",
       "0                        Andaman and Nicobar      10742     1.0    10612   \n",
       "1                             Andhra Pradesh    2339067     3.0  2324331   \n",
       "2                          Arunachal Pradesh      66890     NaN    66594   \n",
       "3                                      Assam     746100     0.0   738065   \n",
       "4                                      Bihar     851379    15.0   839062   \n",
       "5                                 Chandigarh      99348     6.0    98161   \n",
       "6                               Chhattisgarh    1177749     6.0  1163597   \n",
       "7   Dadra and Nagar Haveli and Daman and Diu      11591     0.0    11587   \n",
       "8                                      Delhi    2007188    35.0  1980632   \n",
       "9                                        NaN     259079    26.0   255040   \n",
       "10                                   Gujarat    1277557    41.0  1266473   \n",
       "11                                   Haryana    1056602    43.0  1045845   \n",
       "12                          Himachal Pradesh     312644    23.0   308408   \n",
       "13                         Jammu and Kashmir     479410    17.0   474608   \n",
       "14                                 Jharkhand     442570     NaN   437236   \n",
       "15                                 Karnataka    4071893  1275.0  4030311   \n",
       "16                                    Kerala    6828245  1389.0  6755304   \n",
       "17                                    Ladakh      29412     3.0    29178   \n",
       "18                               Lakshadweep      11415     0.0    11363   \n",
       "19                            Madhya Pradesh    1054918     4.0  1044138   \n",
       "20                               Maharashtra    8136588   164.0  7988008   \n",
       "21                                   Manipur     139922     0.0   137773   \n",
       "22                                 Meghalaya      96783     1.0    95158   \n",
       "23                                   Mizoram     238964     0.0   238238   \n",
       "24                                  Nagaland      35986     0.0    35204   \n",
       "25                                    Odisha    1336552    91.0  1327256   \n",
       "26                                Puducherry     175508     5.0   173528   \n",
       "27                                    Punjab     784205    49.0   764867   \n",
       "28                                 Rajasthan    1315455    88.0  1305714   \n",
       "29                                    Sikkim      44319     1.0    43819   \n",
       "30                                Tamil Nadu    3594388    60.0  3556279   \n",
       "31                                 Telengana     841324    71.0   837142   \n",
       "32                                   Tripura     108034     0.0   107094   \n",
       "33                             Uttar Pradesh    2128103    46.0  2104424   \n",
       "34                               Uttarakhand     449379    28.0   441600   \n",
       "35                               West Bengal    2118606    58.0  2097016   \n",
       "\n",
       "      deaths        dose1      dose2       dose3  precaution_dose  \\\n",
       "0      129.0     313284.0     320383    236936.0          53427.0   \n",
       "1    14733.0   40643161.0   43549055  11703273.0        6579565.0   \n",
       "2      296.0     860442.0     747177         NaN          58618.0   \n",
       "3     8035.0   22549957.0   20561790   2082670.0        1259853.0   \n",
       "4    12302.0   62944633.0   59144387  11983504.0        3868082.0   \n",
       "5        NaN    1089254.0     917701     48480.0          63046.0   \n",
       "6    14146.0          NaN   18534989   5737679.0        1804891.0   \n",
       "7        4.0     730746.0     594929    136967.0              NaN   \n",
       "8    26521.0          NaN   14348835   2312803.0        1053393.0   \n",
       "9     4013.0    1354828.0    1224173     60838.0          76559.0   \n",
       "10   11043.0   49314588.0   49428283  13459618.0        5938121.0   \n",
       "11   10714.0   21955717.0   18732346         NaN         701811.0   \n",
       "12    4213.0    6041658.0    5780254   1485328.0         823689.0   \n",
       "13    4785.0    9941757.0   10386967    930096.0         669871.0   \n",
       "14    5331.0   21300448.0   16046070   1306687.0         664308.0   \n",
       "15   40307.0   50016690.0   50455767   5727031.0        4726542.0   \n",
       "16   71552.0   27013745.0   23791879    854595.0        2215656.0   \n",
       "17     231.0     219564.0     186942     68766.0          53990.0   \n",
       "18      52.0      56908.0      55992     15757.0           6949.0   \n",
       "19   10776.0   54140166.0   54035268   9854998.0        3787239.0   \n",
       "20  148416.0   84644083.0   71593498   5022623.0        4450343.0   \n",
       "21    2149.0    1463998.0    1225599    114004.0         165096.0   \n",
       "22    1624.0    1332102.0    1024902     30706.0          56987.0   \n",
       "23     726.0     785749.0     668814     79573.0          67619.0   \n",
       "24     782.0     837775.0     684306     26060.0          43640.0   \n",
       "25    9205.0   31453659.0   29949756   9995330.0        3199384.0   \n",
       "26    1975.0     912901.0     801853    303475.0         106956.0   \n",
       "27   19289.0   22352681.0   19602907    799986.0        1041039.0   \n",
       "28    9653.0   51103054.0   46510275   4387205.0        2995864.0   \n",
       "29     499.0     539927.0     509134    158276.0          55637.0   \n",
       "30   38049.0   56659544.0   53499923   6033504.0        3021694.0   \n",
       "31    4111.0   29607672.0   29053708  10525975.0        2702159.0   \n",
       "32     940.0    2658852.0    2328613    271434.0         204733.0   \n",
       "33   23633.0  154058287.0  147716010  35623544.0        9240735.0   \n",
       "34    7751.0    8180312.0    7940592   1346150.0         867047.0   \n",
       "35   21532.0   67300236.0   61593452  10257324.0        5491943.0   \n",
       "\n",
       "    total_doses   population  \n",
       "0        991263     426251.0  \n",
       "1     110556756   52883163.0  \n",
       "2       1911760    1528296.0  \n",
       "3      50284713   34586234.0  \n",
       "4     157197041  119461013.0  \n",
       "5       2282281    1182104.0  \n",
       "6      49148991   28566990.0  \n",
       "7       1578492     657391.0  \n",
       "8      37366540   18802494.0  \n",
       "9       2872582    1542750.0  \n",
       "10    127793995   63907200.0  \n",
       "11     45457359   27388008.0  \n",
       "12     15278680    7316708.0  \n",
       "13     24738045   14046258.0  \n",
       "14     43689818          NaN  \n",
       "15    120928298   66165886.0  \n",
       "16     57477992   35330888.0  \n",
       "17       564943     307204.0  \n",
       "18       145008      72210.0  \n",
       "19    133590886   82342793.0  \n",
       "20    177678317  120837347.0  \n",
       "21      3265933    3008546.0  \n",
       "22      2621058    3276323.0  \n",
       "23      1790818    1205974.0  \n",
       "24      1737554    2189297.0  \n",
       "25     81445474   45429399.0  \n",
       "26      2272617    1397707.0  \n",
       "27     46970300   29611935.0  \n",
       "28    115325059   78230816.0  \n",
       "29      1360444     671720.0  \n",
       "30    127442647   76481545.0  \n",
       "31     77201709   38472769.0  \n",
       "32      5916312    4057847.0  \n",
       "33    390639497  228959599.0  \n",
       "34     20051714   11090425.0  \n",
       "35    155962840   97694960.0  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2 = pd.read_csv('Covid.csv', na_values = 'Goa')\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "1a728b6c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>state</th>\n",
       "      <th>confirmed</th>\n",
       "      <th>active</th>\n",
       "      <th>passive</th>\n",
       "      <th>deaths</th>\n",
       "      <th>dose1</th>\n",
       "      <th>dose2</th>\n",
       "      <th>dose3</th>\n",
       "      <th>precaution_dose</th>\n",
       "      <th>total_doses</th>\n",
       "      <th>population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Andaman and Nicobar</td>\n",
       "      <td>10742</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10612</td>\n",
       "      <td>129.0</td>\n",
       "      <td>313284.0</td>\n",
       "      <td>320383</td>\n",
       "      <td>236936.0</td>\n",
       "      <td>53427.0</td>\n",
       "      <td>991263</td>\n",
       "      <td>426251.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Andhra Pradesh</td>\n",
       "      <td>2339067</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2324331</td>\n",
       "      <td>14733.0</td>\n",
       "      <td>40643161.0</td>\n",
       "      <td>43549055</td>\n",
       "      <td>11703273.0</td>\n",
       "      <td>6579565.0</td>\n",
       "      <td>110556756</td>\n",
       "      <td>52883163.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Arunachal Pradesh</td>\n",
       "      <td>66890</td>\n",
       "      <td>NaN</td>\n",
       "      <td>66594</td>\n",
       "      <td>296.0</td>\n",
       "      <td>860442.0</td>\n",
       "      <td>747177</td>\n",
       "      <td>NaN</td>\n",
       "      <td>58618.0</td>\n",
       "      <td>1911760</td>\n",
       "      <td>1528296.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Assam</td>\n",
       "      <td>746100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>738065</td>\n",
       "      <td>8035.0</td>\n",
       "      <td>22549957.0</td>\n",
       "      <td>20561790</td>\n",
       "      <td>2082670.0</td>\n",
       "      <td>1259853.0</td>\n",
       "      <td>50284713</td>\n",
       "      <td>34586234.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Bihar</td>\n",
       "      <td>851379</td>\n",
       "      <td>15.0</td>\n",
       "      <td>839062</td>\n",
       "      <td>12302.0</td>\n",
       "      <td>62944633.0</td>\n",
       "      <td>59144387</td>\n",
       "      <td>11983504.0</td>\n",
       "      <td>3868082.0</td>\n",
       "      <td>157197041</td>\n",
       "      <td>119461013.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Chandigarh</td>\n",
       "      <td>99348</td>\n",
       "      <td>6.0</td>\n",
       "      <td>98161</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1089254.0</td>\n",
       "      <td>917701</td>\n",
       "      <td>48480.0</td>\n",
       "      <td>63046.0</td>\n",
       "      <td>2282281</td>\n",
       "      <td>1182104.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Chhattisgarh</td>\n",
       "      <td>1177749</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1163597</td>\n",
       "      <td>14146.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18534989</td>\n",
       "      <td>5737679.0</td>\n",
       "      <td>1804891.0</td>\n",
       "      <td>49148991</td>\n",
       "      <td>28566990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Dadra and Nagar Haveli and Daman and Diu</td>\n",
       "      <td>11591</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11587</td>\n",
       "      <td>4.0</td>\n",
       "      <td>730746.0</td>\n",
       "      <td>594929</td>\n",
       "      <td>136967.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1578492</td>\n",
       "      <td>657391.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Delhi</td>\n",
       "      <td>2007188</td>\n",
       "      <td>35.0</td>\n",
       "      <td>1980632</td>\n",
       "      <td>26521.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14348835</td>\n",
       "      <td>2312803.0</td>\n",
       "      <td>1053393.0</td>\n",
       "      <td>37366540</td>\n",
       "      <td>18802494.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Goa</td>\n",
       "      <td>259079</td>\n",
       "      <td>26.0</td>\n",
       "      <td>255040</td>\n",
       "      <td>4013.0</td>\n",
       "      <td>1354828.0</td>\n",
       "      <td>1224173</td>\n",
       "      <td>60838.0</td>\n",
       "      <td>76559.0</td>\n",
       "      <td>2872582</td>\n",
       "      <td>1542750.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Gujarat</td>\n",
       "      <td>1277557</td>\n",
       "      <td>41.0</td>\n",
       "      <td>1266473</td>\n",
       "      <td>11043.0</td>\n",
       "      <td>49314588.0</td>\n",
       "      <td>49428283</td>\n",
       "      <td>13459618.0</td>\n",
       "      <td>5938121.0</td>\n",
       "      <td>127793995</td>\n",
       "      <td>63907200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Haryana</td>\n",
       "      <td>1056602</td>\n",
       "      <td>43.0</td>\n",
       "      <td>1045845</td>\n",
       "      <td>10714.0</td>\n",
       "      <td>21955717.0</td>\n",
       "      <td>18732346</td>\n",
       "      <td>NaN</td>\n",
       "      <td>701811.0</td>\n",
       "      <td>45457359</td>\n",
       "      <td>27388008.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Himachal Pradesh</td>\n",
       "      <td>312644</td>\n",
       "      <td>23.0</td>\n",
       "      <td>308408</td>\n",
       "      <td>4213.0</td>\n",
       "      <td>6041658.0</td>\n",
       "      <td>5780254</td>\n",
       "      <td>1485328.0</td>\n",
       "      <td>823689.0</td>\n",
       "      <td>15278680</td>\n",
       "      <td>7316708.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Jammu and Kashmir</td>\n",
       "      <td>479410</td>\n",
       "      <td>17.0</td>\n",
       "      <td>474608</td>\n",
       "      <td>4785.0</td>\n",
       "      <td>9941757.0</td>\n",
       "      <td>10386967</td>\n",
       "      <td>930096.0</td>\n",
       "      <td>669871.0</td>\n",
       "      <td>24738045</td>\n",
       "      <td>14046258.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Jharkhand</td>\n",
       "      <td>442570</td>\n",
       "      <td>NaN</td>\n",
       "      <td>437236</td>\n",
       "      <td>5331.0</td>\n",
       "      <td>21300448.0</td>\n",
       "      <td>16046070</td>\n",
       "      <td>1306687.0</td>\n",
       "      <td>664308.0</td>\n",
       "      <td>43689818</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Karnataka</td>\n",
       "      <td>4071893</td>\n",
       "      <td>1275.0</td>\n",
       "      <td>4030311</td>\n",
       "      <td>40307.0</td>\n",
       "      <td>50016690.0</td>\n",
       "      <td>50455767</td>\n",
       "      <td>5727031.0</td>\n",
       "      <td>4726542.0</td>\n",
       "      <td>120928298</td>\n",
       "      <td>66165886.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Kerala</td>\n",
       "      <td>6828245</td>\n",
       "      <td>1389.0</td>\n",
       "      <td>6755304</td>\n",
       "      <td>71552.0</td>\n",
       "      <td>27013745.0</td>\n",
       "      <td>23791879</td>\n",
       "      <td>854595.0</td>\n",
       "      <td>2215656.0</td>\n",
       "      <td>57477992</td>\n",
       "      <td>35330888.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Ladakh</td>\n",
       "      <td>29412</td>\n",
       "      <td>3.0</td>\n",
       "      <td>29178</td>\n",
       "      <td>231.0</td>\n",
       "      <td>219564.0</td>\n",
       "      <td>186942</td>\n",
       "      <td>68766.0</td>\n",
       "      <td>53990.0</td>\n",
       "      <td>564943</td>\n",
       "      <td>307204.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Lakshadweep</td>\n",
       "      <td>11415</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11363</td>\n",
       "      <td>52.0</td>\n",
       "      <td>56908.0</td>\n",
       "      <td>55992</td>\n",
       "      <td>15757.0</td>\n",
       "      <td>6949.0</td>\n",
       "      <td>145008</td>\n",
       "      <td>72210.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Madhya Pradesh</td>\n",
       "      <td>1054918</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1044138</td>\n",
       "      <td>10776.0</td>\n",
       "      <td>54140166.0</td>\n",
       "      <td>54035268</td>\n",
       "      <td>9854998.0</td>\n",
       "      <td>3787239.0</td>\n",
       "      <td>133590886</td>\n",
       "      <td>82342793.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Maharashtra</td>\n",
       "      <td>8136588</td>\n",
       "      <td>164.0</td>\n",
       "      <td>7988008</td>\n",
       "      <td>148416.0</td>\n",
       "      <td>84644083.0</td>\n",
       "      <td>71593498</td>\n",
       "      <td>5022623.0</td>\n",
       "      <td>4450343.0</td>\n",
       "      <td>177678317</td>\n",
       "      <td>120837347.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Manipur</td>\n",
       "      <td>139922</td>\n",
       "      <td>NaN</td>\n",
       "      <td>137773</td>\n",
       "      <td>2149.0</td>\n",
       "      <td>1463998.0</td>\n",
       "      <td>1225599</td>\n",
       "      <td>114004.0</td>\n",
       "      <td>165096.0</td>\n",
       "      <td>3265933</td>\n",
       "      <td>3008546.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Meghalaya</td>\n",
       "      <td>96783</td>\n",
       "      <td>1.0</td>\n",
       "      <td>95158</td>\n",
       "      <td>1624.0</td>\n",
       "      <td>1332102.0</td>\n",
       "      <td>1024902</td>\n",
       "      <td>30706.0</td>\n",
       "      <td>56987.0</td>\n",
       "      <td>2621058</td>\n",
       "      <td>3276323.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Mizoram</td>\n",
       "      <td>238964</td>\n",
       "      <td>NaN</td>\n",
       "      <td>238238</td>\n",
       "      <td>726.0</td>\n",
       "      <td>785749.0</td>\n",
       "      <td>668814</td>\n",
       "      <td>79573.0</td>\n",
       "      <td>67619.0</td>\n",
       "      <td>1790818</td>\n",
       "      <td>1205974.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Nagaland</td>\n",
       "      <td>35986</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35204</td>\n",
       "      <td>782.0</td>\n",
       "      <td>837775.0</td>\n",
       "      <td>684306</td>\n",
       "      <td>26060.0</td>\n",
       "      <td>43640.0</td>\n",
       "      <td>1737554</td>\n",
       "      <td>2189297.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Odisha</td>\n",
       "      <td>1336552</td>\n",
       "      <td>91.0</td>\n",
       "      <td>1327256</td>\n",
       "      <td>9205.0</td>\n",
       "      <td>31453659.0</td>\n",
       "      <td>29949756</td>\n",
       "      <td>9995330.0</td>\n",
       "      <td>3199384.0</td>\n",
       "      <td>81445474</td>\n",
       "      <td>45429399.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Puducherry</td>\n",
       "      <td>175508</td>\n",
       "      <td>5.0</td>\n",
       "      <td>173528</td>\n",
       "      <td>1975.0</td>\n",
       "      <td>912901.0</td>\n",
       "      <td>801853</td>\n",
       "      <td>303475.0</td>\n",
       "      <td>106956.0</td>\n",
       "      <td>2272617</td>\n",
       "      <td>1397707.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Punjab</td>\n",
       "      <td>784205</td>\n",
       "      <td>49.0</td>\n",
       "      <td>764867</td>\n",
       "      <td>19289.0</td>\n",
       "      <td>22352681.0</td>\n",
       "      <td>19602907</td>\n",
       "      <td>799986.0</td>\n",
       "      <td>1041039.0</td>\n",
       "      <td>46970300</td>\n",
       "      <td>29611935.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Rajasthan</td>\n",
       "      <td>1315455</td>\n",
       "      <td>88.0</td>\n",
       "      <td>1305714</td>\n",
       "      <td>9653.0</td>\n",
       "      <td>51103054.0</td>\n",
       "      <td>46510275</td>\n",
       "      <td>4387205.0</td>\n",
       "      <td>2995864.0</td>\n",
       "      <td>115325059</td>\n",
       "      <td>78230816.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Sikkim</td>\n",
       "      <td>44319</td>\n",
       "      <td>1.0</td>\n",
       "      <td>43819</td>\n",
       "      <td>499.0</td>\n",
       "      <td>539927.0</td>\n",
       "      <td>509134</td>\n",
       "      <td>158276.0</td>\n",
       "      <td>55637.0</td>\n",
       "      <td>1360444</td>\n",
       "      <td>671720.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Tamil Nadu</td>\n",
       "      <td>3594388</td>\n",
       "      <td>60.0</td>\n",
       "      <td>3556279</td>\n",
       "      <td>38049.0</td>\n",
       "      <td>56659544.0</td>\n",
       "      <td>53499923</td>\n",
       "      <td>6033504.0</td>\n",
       "      <td>3021694.0</td>\n",
       "      <td>127442647</td>\n",
       "      <td>76481545.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Telengana</td>\n",
       "      <td>841324</td>\n",
       "      <td>71.0</td>\n",
       "      <td>837142</td>\n",
       "      <td>4111.0</td>\n",
       "      <td>29607672.0</td>\n",
       "      <td>29053708</td>\n",
       "      <td>10525975.0</td>\n",
       "      <td>2702159.0</td>\n",
       "      <td>77201709</td>\n",
       "      <td>38472769.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>NaN</td>\n",
       "      <td>108034</td>\n",
       "      <td>NaN</td>\n",
       "      <td>107094</td>\n",
       "      <td>940.0</td>\n",
       "      <td>2658852.0</td>\n",
       "      <td>2328613</td>\n",
       "      <td>271434.0</td>\n",
       "      <td>204733.0</td>\n",
       "      <td>5916312</td>\n",
       "      <td>4057847.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Uttar Pradesh</td>\n",
       "      <td>2128103</td>\n",
       "      <td>46.0</td>\n",
       "      <td>2104424</td>\n",
       "      <td>23633.0</td>\n",
       "      <td>154058287.0</td>\n",
       "      <td>147716010</td>\n",
       "      <td>35623544.0</td>\n",
       "      <td>9240735.0</td>\n",
       "      <td>390639497</td>\n",
       "      <td>228959599.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Uttarakhand</td>\n",
       "      <td>449379</td>\n",
       "      <td>28.0</td>\n",
       "      <td>441600</td>\n",
       "      <td>7751.0</td>\n",
       "      <td>8180312.0</td>\n",
       "      <td>7940592</td>\n",
       "      <td>1346150.0</td>\n",
       "      <td>867047.0</td>\n",
       "      <td>20051714</td>\n",
       "      <td>11090425.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>West Bengal</td>\n",
       "      <td>2118606</td>\n",
       "      <td>58.0</td>\n",
       "      <td>2097016</td>\n",
       "      <td>21532.0</td>\n",
       "      <td>67300236.0</td>\n",
       "      <td>61593452</td>\n",
       "      <td>10257324.0</td>\n",
       "      <td>5491943.0</td>\n",
       "      <td>155962840</td>\n",
       "      <td>97694960.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       state  confirmed  active  passive  \\\n",
       "0                        Andaman and Nicobar      10742     1.0    10612   \n",
       "1                             Andhra Pradesh    2339067     3.0  2324331   \n",
       "2                          Arunachal Pradesh      66890     NaN    66594   \n",
       "3                                      Assam     746100     NaN   738065   \n",
       "4                                      Bihar     851379    15.0   839062   \n",
       "5                                 Chandigarh      99348     6.0    98161   \n",
       "6                               Chhattisgarh    1177749     6.0  1163597   \n",
       "7   Dadra and Nagar Haveli and Daman and Diu      11591     NaN    11587   \n",
       "8                                      Delhi    2007188    35.0  1980632   \n",
       "9                                        Goa     259079    26.0   255040   \n",
       "10                                   Gujarat    1277557    41.0  1266473   \n",
       "11                                   Haryana    1056602    43.0  1045845   \n",
       "12                          Himachal Pradesh     312644    23.0   308408   \n",
       "13                         Jammu and Kashmir     479410    17.0   474608   \n",
       "14                                 Jharkhand     442570     NaN   437236   \n",
       "15                                 Karnataka    4071893  1275.0  4030311   \n",
       "16                                    Kerala    6828245  1389.0  6755304   \n",
       "17                                    Ladakh      29412     3.0    29178   \n",
       "18                               Lakshadweep      11415     NaN    11363   \n",
       "19                            Madhya Pradesh    1054918     4.0  1044138   \n",
       "20                               Maharashtra    8136588   164.0  7988008   \n",
       "21                                   Manipur     139922     NaN   137773   \n",
       "22                                 Meghalaya      96783     1.0    95158   \n",
       "23                                   Mizoram     238964     NaN   238238   \n",
       "24                                  Nagaland      35986     NaN    35204   \n",
       "25                                    Odisha    1336552    91.0  1327256   \n",
       "26                                Puducherry     175508     5.0   173528   \n",
       "27                                    Punjab     784205    49.0   764867   \n",
       "28                                 Rajasthan    1315455    88.0  1305714   \n",
       "29                                    Sikkim      44319     1.0    43819   \n",
       "30                                Tamil Nadu    3594388    60.0  3556279   \n",
       "31                                 Telengana     841324    71.0   837142   \n",
       "32                                       NaN     108034     NaN   107094   \n",
       "33                             Uttar Pradesh    2128103    46.0  2104424   \n",
       "34                               Uttarakhand     449379    28.0   441600   \n",
       "35                               West Bengal    2118606    58.0  2097016   \n",
       "\n",
       "      deaths        dose1      dose2       dose3  precaution_dose  \\\n",
       "0      129.0     313284.0     320383    236936.0          53427.0   \n",
       "1    14733.0   40643161.0   43549055  11703273.0        6579565.0   \n",
       "2      296.0     860442.0     747177         NaN          58618.0   \n",
       "3     8035.0   22549957.0   20561790   2082670.0        1259853.0   \n",
       "4    12302.0   62944633.0   59144387  11983504.0        3868082.0   \n",
       "5        NaN    1089254.0     917701     48480.0          63046.0   \n",
       "6    14146.0          NaN   18534989   5737679.0        1804891.0   \n",
       "7        4.0     730746.0     594929    136967.0              NaN   \n",
       "8    26521.0          NaN   14348835   2312803.0        1053393.0   \n",
       "9     4013.0    1354828.0    1224173     60838.0          76559.0   \n",
       "10   11043.0   49314588.0   49428283  13459618.0        5938121.0   \n",
       "11   10714.0   21955717.0   18732346         NaN         701811.0   \n",
       "12    4213.0    6041658.0    5780254   1485328.0         823689.0   \n",
       "13    4785.0    9941757.0   10386967    930096.0         669871.0   \n",
       "14    5331.0   21300448.0   16046070   1306687.0         664308.0   \n",
       "15   40307.0   50016690.0   50455767   5727031.0        4726542.0   \n",
       "16   71552.0   27013745.0   23791879    854595.0        2215656.0   \n",
       "17     231.0     219564.0     186942     68766.0          53990.0   \n",
       "18      52.0      56908.0      55992     15757.0           6949.0   \n",
       "19   10776.0   54140166.0   54035268   9854998.0        3787239.0   \n",
       "20  148416.0   84644083.0   71593498   5022623.0        4450343.0   \n",
       "21    2149.0    1463998.0    1225599    114004.0         165096.0   \n",
       "22    1624.0    1332102.0    1024902     30706.0          56987.0   \n",
       "23     726.0     785749.0     668814     79573.0          67619.0   \n",
       "24     782.0     837775.0     684306     26060.0          43640.0   \n",
       "25    9205.0   31453659.0   29949756   9995330.0        3199384.0   \n",
       "26    1975.0     912901.0     801853    303475.0         106956.0   \n",
       "27   19289.0   22352681.0   19602907    799986.0        1041039.0   \n",
       "28    9653.0   51103054.0   46510275   4387205.0        2995864.0   \n",
       "29     499.0     539927.0     509134    158276.0          55637.0   \n",
       "30   38049.0   56659544.0   53499923   6033504.0        3021694.0   \n",
       "31    4111.0   29607672.0   29053708  10525975.0        2702159.0   \n",
       "32     940.0    2658852.0    2328613    271434.0         204733.0   \n",
       "33   23633.0  154058287.0  147716010  35623544.0        9240735.0   \n",
       "34    7751.0    8180312.0    7940592   1346150.0         867047.0   \n",
       "35   21532.0   67300236.0   61593452  10257324.0        5491943.0   \n",
       "\n",
       "    total_doses   population  \n",
       "0        991263     426251.0  \n",
       "1     110556756   52883163.0  \n",
       "2       1911760    1528296.0  \n",
       "3      50284713   34586234.0  \n",
       "4     157197041  119461013.0  \n",
       "5       2282281    1182104.0  \n",
       "6      49148991   28566990.0  \n",
       "7       1578492     657391.0  \n",
       "8      37366540   18802494.0  \n",
       "9       2872582    1542750.0  \n",
       "10    127793995   63907200.0  \n",
       "11     45457359   27388008.0  \n",
       "12     15278680    7316708.0  \n",
       "13     24738045   14046258.0  \n",
       "14     43689818          NaN  \n",
       "15    120928298   66165886.0  \n",
       "16     57477992   35330888.0  \n",
       "17       564943     307204.0  \n",
       "18       145008      72210.0  \n",
       "19    133590886   82342793.0  \n",
       "20    177678317  120837347.0  \n",
       "21      3265933    3008546.0  \n",
       "22      2621058    3276323.0  \n",
       "23      1790818    1205974.0  \n",
       "24      1737554    2189297.0  \n",
       "25     81445474   45429399.0  \n",
       "26      2272617    1397707.0  \n",
       "27     46970300   29611935.0  \n",
       "28    115325059   78230816.0  \n",
       "29      1360444     671720.0  \n",
       "30    127442647   76481545.0  \n",
       "31     77201709   38472769.0  \n",
       "32      5916312    4057847.0  \n",
       "33    390639497  228959599.0  \n",
       "34     20051714   11090425.0  \n",
       "35    155962840   97694960.0  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4 = pd.read_csv('Covid.csv', na_values = ['Tripura', 0.0])\n",
    "df4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "7dbac1eb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>state</th>\n",
       "      <th>confirmed</th>\n",
       "      <th>active</th>\n",
       "      <th>passive</th>\n",
       "      <th>deaths</th>\n",
       "      <th>dose1</th>\n",
       "      <th>dose2</th>\n",
       "      <th>dose3</th>\n",
       "      <th>precaution_dose</th>\n",
       "      <th>total_doses</th>\n",
       "      <th>population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Andaman and Nicobar</td>\n",
       "      <td>10742</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10612</td>\n",
       "      <td>129.0</td>\n",
       "      <td>313284.0</td>\n",
       "      <td>320383</td>\n",
       "      <td>236936.0</td>\n",
       "      <td>53427.0</td>\n",
       "      <td>991263</td>\n",
       "      <td>426251.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Andhra Pradesh</td>\n",
       "      <td>2339067</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2324331</td>\n",
       "      <td>14733.0</td>\n",
       "      <td>40643161.0</td>\n",
       "      <td>43549055</td>\n",
       "      <td>11703273.0</td>\n",
       "      <td>6579565.0</td>\n",
       "      <td>110556756</td>\n",
       "      <td>52883163.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Arunachal Pradesh</td>\n",
       "      <td>66890</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66594</td>\n",
       "      <td>296.0</td>\n",
       "      <td>860442.0</td>\n",
       "      <td>747177</td>\n",
       "      <td>2082670.0</td>\n",
       "      <td>58618.0</td>\n",
       "      <td>1911760</td>\n",
       "      <td>1528296.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Assam</td>\n",
       "      <td>746100</td>\n",
       "      <td>0.0</td>\n",
       "      <td>738065</td>\n",
       "      <td>8035.0</td>\n",
       "      <td>22549957.0</td>\n",
       "      <td>20561790</td>\n",
       "      <td>2082670.0</td>\n",
       "      <td>1259853.0</td>\n",
       "      <td>50284713</td>\n",
       "      <td>34586234.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Bihar</td>\n",
       "      <td>851379</td>\n",
       "      <td>15.0</td>\n",
       "      <td>839062</td>\n",
       "      <td>12302.0</td>\n",
       "      <td>62944633.0</td>\n",
       "      <td>59144387</td>\n",
       "      <td>11983504.0</td>\n",
       "      <td>3868082.0</td>\n",
       "      <td>157197041</td>\n",
       "      <td>119461013.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Chandigarh</td>\n",
       "      <td>99348</td>\n",
       "      <td>6.0</td>\n",
       "      <td>98161</td>\n",
       "      <td>14146.0</td>\n",
       "      <td>1089254.0</td>\n",
       "      <td>917701</td>\n",
       "      <td>48480.0</td>\n",
       "      <td>63046.0</td>\n",
       "      <td>2282281</td>\n",
       "      <td>1182104.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Chhattisgarh</td>\n",
       "      <td>1177749</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1163597</td>\n",
       "      <td>14146.0</td>\n",
       "      <td>730746.0</td>\n",
       "      <td>18534989</td>\n",
       "      <td>5737679.0</td>\n",
       "      <td>1804891.0</td>\n",
       "      <td>49148991</td>\n",
       "      <td>28566990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Dadra and Nagar Haveli and Daman and Diu</td>\n",
       "      <td>11591</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11587</td>\n",
       "      <td>4.0</td>\n",
       "      <td>730746.0</td>\n",
       "      <td>594929</td>\n",
       "      <td>136967.0</td>\n",
       "      <td>1053393.0</td>\n",
       "      <td>1578492</td>\n",
       "      <td>657391.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Delhi</td>\n",
       "      <td>2007188</td>\n",
       "      <td>35.0</td>\n",
       "      <td>1980632</td>\n",
       "      <td>26521.0</td>\n",
       "      <td>1354828.0</td>\n",
       "      <td>14348835</td>\n",
       "      <td>2312803.0</td>\n",
       "      <td>1053393.0</td>\n",
       "      <td>37366540</td>\n",
       "      <td>18802494.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Gujarat</td>\n",
       "      <td>259079</td>\n",
       "      <td>26.0</td>\n",
       "      <td>255040</td>\n",
       "      <td>4013.0</td>\n",
       "      <td>1354828.0</td>\n",
       "      <td>1224173</td>\n",
       "      <td>60838.0</td>\n",
       "      <td>76559.0</td>\n",
       "      <td>2872582</td>\n",
       "      <td>1542750.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Gujarat</td>\n",
       "      <td>1277557</td>\n",
       "      <td>41.0</td>\n",
       "      <td>1266473</td>\n",
       "      <td>11043.0</td>\n",
       "      <td>49314588.0</td>\n",
       "      <td>49428283</td>\n",
       "      <td>13459618.0</td>\n",
       "      <td>5938121.0</td>\n",
       "      <td>127793995</td>\n",
       "      <td>63907200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Haryana</td>\n",
       "      <td>1056602</td>\n",
       "      <td>43.0</td>\n",
       "      <td>1045845</td>\n",
       "      <td>10714.0</td>\n",
       "      <td>21955717.0</td>\n",
       "      <td>18732346</td>\n",
       "      <td>1485328.0</td>\n",
       "      <td>701811.0</td>\n",
       "      <td>45457359</td>\n",
       "      <td>27388008.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Himachal Pradesh</td>\n",
       "      <td>312644</td>\n",
       "      <td>23.0</td>\n",
       "      <td>308408</td>\n",
       "      <td>4213.0</td>\n",
       "      <td>6041658.0</td>\n",
       "      <td>5780254</td>\n",
       "      <td>1485328.0</td>\n",
       "      <td>823689.0</td>\n",
       "      <td>15278680</td>\n",
       "      <td>7316708.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Jammu and Kashmir</td>\n",
       "      <td>479410</td>\n",
       "      <td>17.0</td>\n",
       "      <td>474608</td>\n",
       "      <td>4785.0</td>\n",
       "      <td>9941757.0</td>\n",
       "      <td>10386967</td>\n",
       "      <td>930096.0</td>\n",
       "      <td>669871.0</td>\n",
       "      <td>24738045</td>\n",
       "      <td>14046258.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Jharkhand</td>\n",
       "      <td>442570</td>\n",
       "      <td>1275.0</td>\n",
       "      <td>437236</td>\n",
       "      <td>5331.0</td>\n",
       "      <td>21300448.0</td>\n",
       "      <td>16046070</td>\n",
       "      <td>1306687.0</td>\n",
       "      <td>664308.0</td>\n",
       "      <td>43689818</td>\n",
       "      <td>66165886.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Karnataka</td>\n",
       "      <td>4071893</td>\n",
       "      <td>1275.0</td>\n",
       "      <td>4030311</td>\n",
       "      <td>40307.0</td>\n",
       "      <td>50016690.0</td>\n",
       "      <td>50455767</td>\n",
       "      <td>5727031.0</td>\n",
       "      <td>4726542.0</td>\n",
       "      <td>120928298</td>\n",
       "      <td>66165886.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Kerala</td>\n",
       "      <td>6828245</td>\n",
       "      <td>1389.0</td>\n",
       "      <td>6755304</td>\n",
       "      <td>71552.0</td>\n",
       "      <td>27013745.0</td>\n",
       "      <td>23791879</td>\n",
       "      <td>854595.0</td>\n",
       "      <td>2215656.0</td>\n",
       "      <td>57477992</td>\n",
       "      <td>35330888.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Ladakh</td>\n",
       "      <td>29412</td>\n",
       "      <td>3.0</td>\n",
       "      <td>29178</td>\n",
       "      <td>231.0</td>\n",
       "      <td>219564.0</td>\n",
       "      <td>186942</td>\n",
       "      <td>68766.0</td>\n",
       "      <td>53990.0</td>\n",
       "      <td>564943</td>\n",
       "      <td>307204.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Lakshadweep</td>\n",
       "      <td>11415</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11363</td>\n",
       "      <td>52.0</td>\n",
       "      <td>56908.0</td>\n",
       "      <td>55992</td>\n",
       "      <td>15757.0</td>\n",
       "      <td>6949.0</td>\n",
       "      <td>145008</td>\n",
       "      <td>72210.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Madhya Pradesh</td>\n",
       "      <td>1054918</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1044138</td>\n",
       "      <td>10776.0</td>\n",
       "      <td>54140166.0</td>\n",
       "      <td>54035268</td>\n",
       "      <td>9854998.0</td>\n",
       "      <td>3787239.0</td>\n",
       "      <td>133590886</td>\n",
       "      <td>82342793.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Maharashtra</td>\n",
       "      <td>8136588</td>\n",
       "      <td>164.0</td>\n",
       "      <td>7988008</td>\n",
       "      <td>148416.0</td>\n",
       "      <td>84644083.0</td>\n",
       "      <td>71593498</td>\n",
       "      <td>5022623.0</td>\n",
       "      <td>4450343.0</td>\n",
       "      <td>177678317</td>\n",
       "      <td>120837347.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Manipur</td>\n",
       "      <td>139922</td>\n",
       "      <td>0.0</td>\n",
       "      <td>137773</td>\n",
       "      <td>2149.0</td>\n",
       "      <td>1463998.0</td>\n",
       "      <td>1225599</td>\n",
       "      <td>114004.0</td>\n",
       "      <td>165096.0</td>\n",
       "      <td>3265933</td>\n",
       "      <td>3008546.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Meghalaya</td>\n",
       "      <td>96783</td>\n",
       "      <td>1.0</td>\n",
       "      <td>95158</td>\n",
       "      <td>1624.0</td>\n",
       "      <td>1332102.0</td>\n",
       "      <td>1024902</td>\n",
       "      <td>30706.0</td>\n",
       "      <td>56987.0</td>\n",
       "      <td>2621058</td>\n",
       "      <td>3276323.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Mizoram</td>\n",
       "      <td>238964</td>\n",
       "      <td>0.0</td>\n",
       "      <td>238238</td>\n",
       "      <td>726.0</td>\n",
       "      <td>785749.0</td>\n",
       "      <td>668814</td>\n",
       "      <td>79573.0</td>\n",
       "      <td>67619.0</td>\n",
       "      <td>1790818</td>\n",
       "      <td>1205974.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Nagaland</td>\n",
       "      <td>35986</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35204</td>\n",
       "      <td>782.0</td>\n",
       "      <td>837775.0</td>\n",
       "      <td>684306</td>\n",
       "      <td>26060.0</td>\n",
       "      <td>43640.0</td>\n",
       "      <td>1737554</td>\n",
       "      <td>2189297.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Odisha</td>\n",
       "      <td>1336552</td>\n",
       "      <td>91.0</td>\n",
       "      <td>1327256</td>\n",
       "      <td>9205.0</td>\n",
       "      <td>31453659.0</td>\n",
       "      <td>29949756</td>\n",
       "      <td>9995330.0</td>\n",
       "      <td>3199384.0</td>\n",
       "      <td>81445474</td>\n",
       "      <td>45429399.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Puducherry</td>\n",
       "      <td>175508</td>\n",
       "      <td>5.0</td>\n",
       "      <td>173528</td>\n",
       "      <td>1975.0</td>\n",
       "      <td>912901.0</td>\n",
       "      <td>801853</td>\n",
       "      <td>303475.0</td>\n",
       "      <td>106956.0</td>\n",
       "      <td>2272617</td>\n",
       "      <td>1397707.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Punjab</td>\n",
       "      <td>784205</td>\n",
       "      <td>49.0</td>\n",
       "      <td>764867</td>\n",
       "      <td>19289.0</td>\n",
       "      <td>22352681.0</td>\n",
       "      <td>19602907</td>\n",
       "      <td>799986.0</td>\n",
       "      <td>1041039.0</td>\n",
       "      <td>46970300</td>\n",
       "      <td>29611935.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Rajasthan</td>\n",
       "      <td>1315455</td>\n",
       "      <td>88.0</td>\n",
       "      <td>1305714</td>\n",
       "      <td>9653.0</td>\n",
       "      <td>51103054.0</td>\n",
       "      <td>46510275</td>\n",
       "      <td>4387205.0</td>\n",
       "      <td>2995864.0</td>\n",
       "      <td>115325059</td>\n",
       "      <td>78230816.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Sikkim</td>\n",
       "      <td>44319</td>\n",
       "      <td>1.0</td>\n",
       "      <td>43819</td>\n",
       "      <td>499.0</td>\n",
       "      <td>539927.0</td>\n",
       "      <td>509134</td>\n",
       "      <td>158276.0</td>\n",
       "      <td>55637.0</td>\n",
       "      <td>1360444</td>\n",
       "      <td>671720.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Tamil Nadu</td>\n",
       "      <td>3594388</td>\n",
       "      <td>60.0</td>\n",
       "      <td>3556279</td>\n",
       "      <td>38049.0</td>\n",
       "      <td>56659544.0</td>\n",
       "      <td>53499923</td>\n",
       "      <td>6033504.0</td>\n",
       "      <td>3021694.0</td>\n",
       "      <td>127442647</td>\n",
       "      <td>76481545.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Telengana</td>\n",
       "      <td>841324</td>\n",
       "      <td>71.0</td>\n",
       "      <td>837142</td>\n",
       "      <td>4111.0</td>\n",
       "      <td>29607672.0</td>\n",
       "      <td>29053708</td>\n",
       "      <td>10525975.0</td>\n",
       "      <td>2702159.0</td>\n",
       "      <td>77201709</td>\n",
       "      <td>38472769.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Tripura</td>\n",
       "      <td>108034</td>\n",
       "      <td>0.0</td>\n",
       "      <td>107094</td>\n",
       "      <td>940.0</td>\n",
       "      <td>2658852.0</td>\n",
       "      <td>2328613</td>\n",
       "      <td>271434.0</td>\n",
       "      <td>204733.0</td>\n",
       "      <td>5916312</td>\n",
       "      <td>4057847.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Uttar Pradesh</td>\n",
       "      <td>2128103</td>\n",
       "      <td>46.0</td>\n",
       "      <td>2104424</td>\n",
       "      <td>23633.0</td>\n",
       "      <td>154058287.0</td>\n",
       "      <td>147716010</td>\n",
       "      <td>35623544.0</td>\n",
       "      <td>9240735.0</td>\n",
       "      <td>390639497</td>\n",
       "      <td>228959599.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Uttarakhand</td>\n",
       "      <td>449379</td>\n",
       "      <td>28.0</td>\n",
       "      <td>441600</td>\n",
       "      <td>7751.0</td>\n",
       "      <td>8180312.0</td>\n",
       "      <td>7940592</td>\n",
       "      <td>1346150.0</td>\n",
       "      <td>867047.0</td>\n",
       "      <td>20051714</td>\n",
       "      <td>11090425.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>West Bengal</td>\n",
       "      <td>2118606</td>\n",
       "      <td>58.0</td>\n",
       "      <td>2097016</td>\n",
       "      <td>21532.0</td>\n",
       "      <td>67300236.0</td>\n",
       "      <td>61593452</td>\n",
       "      <td>10257324.0</td>\n",
       "      <td>5491943.0</td>\n",
       "      <td>155962840</td>\n",
       "      <td>97694960.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       state  confirmed  active  passive  \\\n",
       "0                        Andaman and Nicobar      10742     1.0    10612   \n",
       "1                             Andhra Pradesh    2339067     3.0  2324331   \n",
       "2                          Arunachal Pradesh      66890     0.0    66594   \n",
       "3                                      Assam     746100     0.0   738065   \n",
       "4                                      Bihar     851379    15.0   839062   \n",
       "5                                 Chandigarh      99348     6.0    98161   \n",
       "6                               Chhattisgarh    1177749     6.0  1163597   \n",
       "7   Dadra and Nagar Haveli and Daman and Diu      11591     0.0    11587   \n",
       "8                                      Delhi    2007188    35.0  1980632   \n",
       "9                                    Gujarat     259079    26.0   255040   \n",
       "10                                   Gujarat    1277557    41.0  1266473   \n",
       "11                                   Haryana    1056602    43.0  1045845   \n",
       "12                          Himachal Pradesh     312644    23.0   308408   \n",
       "13                         Jammu and Kashmir     479410    17.0   474608   \n",
       "14                                 Jharkhand     442570  1275.0   437236   \n",
       "15                                 Karnataka    4071893  1275.0  4030311   \n",
       "16                                    Kerala    6828245  1389.0  6755304   \n",
       "17                                    Ladakh      29412     3.0    29178   \n",
       "18                               Lakshadweep      11415     0.0    11363   \n",
       "19                            Madhya Pradesh    1054918     4.0  1044138   \n",
       "20                               Maharashtra    8136588   164.0  7988008   \n",
       "21                                   Manipur     139922     0.0   137773   \n",
       "22                                 Meghalaya      96783     1.0    95158   \n",
       "23                                   Mizoram     238964     0.0   238238   \n",
       "24                                  Nagaland      35986     0.0    35204   \n",
       "25                                    Odisha    1336552    91.0  1327256   \n",
       "26                                Puducherry     175508     5.0   173528   \n",
       "27                                    Punjab     784205    49.0   764867   \n",
       "28                                 Rajasthan    1315455    88.0  1305714   \n",
       "29                                    Sikkim      44319     1.0    43819   \n",
       "30                                Tamil Nadu    3594388    60.0  3556279   \n",
       "31                                 Telengana     841324    71.0   837142   \n",
       "32                                   Tripura     108034     0.0   107094   \n",
       "33                             Uttar Pradesh    2128103    46.0  2104424   \n",
       "34                               Uttarakhand     449379    28.0   441600   \n",
       "35                               West Bengal    2118606    58.0  2097016   \n",
       "\n",
       "      deaths        dose1      dose2       dose3  precaution_dose  \\\n",
       "0      129.0     313284.0     320383    236936.0          53427.0   \n",
       "1    14733.0   40643161.0   43549055  11703273.0        6579565.0   \n",
       "2      296.0     860442.0     747177   2082670.0          58618.0   \n",
       "3     8035.0   22549957.0   20561790   2082670.0        1259853.0   \n",
       "4    12302.0   62944633.0   59144387  11983504.0        3868082.0   \n",
       "5    14146.0    1089254.0     917701     48480.0          63046.0   \n",
       "6    14146.0     730746.0   18534989   5737679.0        1804891.0   \n",
       "7        4.0     730746.0     594929    136967.0        1053393.0   \n",
       "8    26521.0    1354828.0   14348835   2312803.0        1053393.0   \n",
       "9     4013.0    1354828.0    1224173     60838.0          76559.0   \n",
       "10   11043.0   49314588.0   49428283  13459618.0        5938121.0   \n",
       "11   10714.0   21955717.0   18732346   1485328.0         701811.0   \n",
       "12    4213.0    6041658.0    5780254   1485328.0         823689.0   \n",
       "13    4785.0    9941757.0   10386967    930096.0         669871.0   \n",
       "14    5331.0   21300448.0   16046070   1306687.0         664308.0   \n",
       "15   40307.0   50016690.0   50455767   5727031.0        4726542.0   \n",
       "16   71552.0   27013745.0   23791879    854595.0        2215656.0   \n",
       "17     231.0     219564.0     186942     68766.0          53990.0   \n",
       "18      52.0      56908.0      55992     15757.0           6949.0   \n",
       "19   10776.0   54140166.0   54035268   9854998.0        3787239.0   \n",
       "20  148416.0   84644083.0   71593498   5022623.0        4450343.0   \n",
       "21    2149.0    1463998.0    1225599    114004.0         165096.0   \n",
       "22    1624.0    1332102.0    1024902     30706.0          56987.0   \n",
       "23     726.0     785749.0     668814     79573.0          67619.0   \n",
       "24     782.0     837775.0     684306     26060.0          43640.0   \n",
       "25    9205.0   31453659.0   29949756   9995330.0        3199384.0   \n",
       "26    1975.0     912901.0     801853    303475.0         106956.0   \n",
       "27   19289.0   22352681.0   19602907    799986.0        1041039.0   \n",
       "28    9653.0   51103054.0   46510275   4387205.0        2995864.0   \n",
       "29     499.0     539927.0     509134    158276.0          55637.0   \n",
       "30   38049.0   56659544.0   53499923   6033504.0        3021694.0   \n",
       "31    4111.0   29607672.0   29053708  10525975.0        2702159.0   \n",
       "32     940.0    2658852.0    2328613    271434.0         204733.0   \n",
       "33   23633.0  154058287.0  147716010  35623544.0        9240735.0   \n",
       "34    7751.0    8180312.0    7940592   1346150.0         867047.0   \n",
       "35   21532.0   67300236.0   61593452  10257324.0        5491943.0   \n",
       "\n",
       "    total_doses   population  \n",
       "0        991263     426251.0  \n",
       "1     110556756   52883163.0  \n",
       "2       1911760    1528296.0  \n",
       "3      50284713   34586234.0  \n",
       "4     157197041  119461013.0  \n",
       "5       2282281    1182104.0  \n",
       "6      49148991   28566990.0  \n",
       "7       1578492     657391.0  \n",
       "8      37366540   18802494.0  \n",
       "9       2872582    1542750.0  \n",
       "10    127793995   63907200.0  \n",
       "11     45457359   27388008.0  \n",
       "12     15278680    7316708.0  \n",
       "13     24738045   14046258.0  \n",
       "14     43689818   66165886.0  \n",
       "15    120928298   66165886.0  \n",
       "16     57477992   35330888.0  \n",
       "17       564943     307204.0  \n",
       "18       145008      72210.0  \n",
       "19    133590886   82342793.0  \n",
       "20    177678317  120837347.0  \n",
       "21      3265933    3008546.0  \n",
       "22      2621058    3276323.0  \n",
       "23      1790818    1205974.0  \n",
       "24      1737554    2189297.0  \n",
       "25     81445474   45429399.0  \n",
       "26      2272617    1397707.0  \n",
       "27     46970300   29611935.0  \n",
       "28    115325059   78230816.0  \n",
       "29      1360444     671720.0  \n",
       "30    127442647   76481545.0  \n",
       "31     77201709   38472769.0  \n",
       "32      5916312    4057847.0  \n",
       "33    390639497  228959599.0  \n",
       "34     20051714   11090425.0  \n",
       "35    155962840   97694960.0  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.fillna(method = 'bfill')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "34c980ba",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>state</th>\n",
       "      <th>confirmed</th>\n",
       "      <th>active</th>\n",
       "      <th>passive</th>\n",
       "      <th>deaths</th>\n",
       "      <th>dose1</th>\n",
       "      <th>dose2</th>\n",
       "      <th>dose3</th>\n",
       "      <th>precaution_dose</th>\n",
       "      <th>total_doses</th>\n",
       "      <th>population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Andaman and Nicobar</td>\n",
       "      <td>10742</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10612</td>\n",
       "      <td>129.0</td>\n",
       "      <td>313284.0</td>\n",
       "      <td>320383</td>\n",
       "      <td>236936.0</td>\n",
       "      <td>53427.0</td>\n",
       "      <td>991263</td>\n",
       "      <td>426251.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Andhra Pradesh</td>\n",
       "      <td>2339067</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2324331</td>\n",
       "      <td>14733.0</td>\n",
       "      <td>40643161.0</td>\n",
       "      <td>43549055</td>\n",
       "      <td>11703273.0</td>\n",
       "      <td>6579565.0</td>\n",
       "      <td>110556756</td>\n",
       "      <td>52883163.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Arunachal Pradesh</td>\n",
       "      <td>66890</td>\n",
       "      <td>3.0</td>\n",
       "      <td>66594</td>\n",
       "      <td>296.0</td>\n",
       "      <td>860442.0</td>\n",
       "      <td>747177</td>\n",
       "      <td>11703273.0</td>\n",
       "      <td>58618.0</td>\n",
       "      <td>1911760</td>\n",
       "      <td>1528296.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Assam</td>\n",
       "      <td>746100</td>\n",
       "      <td>0.0</td>\n",
       "      <td>738065</td>\n",
       "      <td>8035.0</td>\n",
       "      <td>22549957.0</td>\n",
       "      <td>20561790</td>\n",
       "      <td>2082670.0</td>\n",
       "      <td>1259853.0</td>\n",
       "      <td>50284713</td>\n",
       "      <td>34586234.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Bihar</td>\n",
       "      <td>851379</td>\n",
       "      <td>15.0</td>\n",
       "      <td>839062</td>\n",
       "      <td>12302.0</td>\n",
       "      <td>62944633.0</td>\n",
       "      <td>59144387</td>\n",
       "      <td>11983504.0</td>\n",
       "      <td>3868082.0</td>\n",
       "      <td>157197041</td>\n",
       "      <td>119461013.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Chandigarh</td>\n",
       "      <td>99348</td>\n",
       "      <td>6.0</td>\n",
       "      <td>98161</td>\n",
       "      <td>12302.0</td>\n",
       "      <td>1089254.0</td>\n",
       "      <td>917701</td>\n",
       "      <td>48480.0</td>\n",
       "      <td>63046.0</td>\n",
       "      <td>2282281</td>\n",
       "      <td>1182104.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Chhattisgarh</td>\n",
       "      <td>1177749</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1163597</td>\n",
       "      <td>14146.0</td>\n",
       "      <td>1089254.0</td>\n",
       "      <td>18534989</td>\n",
       "      <td>5737679.0</td>\n",
       "      <td>1804891.0</td>\n",
       "      <td>49148991</td>\n",
       "      <td>28566990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Dadra and Nagar Haveli and Daman and Diu</td>\n",
       "      <td>11591</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11587</td>\n",
       "      <td>4.0</td>\n",
       "      <td>730746.0</td>\n",
       "      <td>594929</td>\n",
       "      <td>136967.0</td>\n",
       "      <td>1804891.0</td>\n",
       "      <td>1578492</td>\n",
       "      <td>657391.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Delhi</td>\n",
       "      <td>2007188</td>\n",
       "      <td>35.0</td>\n",
       "      <td>1980632</td>\n",
       "      <td>26521.0</td>\n",
       "      <td>730746.0</td>\n",
       "      <td>14348835</td>\n",
       "      <td>2312803.0</td>\n",
       "      <td>1053393.0</td>\n",
       "      <td>37366540</td>\n",
       "      <td>18802494.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Delhi</td>\n",
       "      <td>259079</td>\n",
       "      <td>26.0</td>\n",
       "      <td>255040</td>\n",
       "      <td>4013.0</td>\n",
       "      <td>1354828.0</td>\n",
       "      <td>1224173</td>\n",
       "      <td>60838.0</td>\n",
       "      <td>76559.0</td>\n",
       "      <td>2872582</td>\n",
       "      <td>1542750.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Gujarat</td>\n",
       "      <td>1277557</td>\n",
       "      <td>41.0</td>\n",
       "      <td>1266473</td>\n",
       "      <td>11043.0</td>\n",
       "      <td>49314588.0</td>\n",
       "      <td>49428283</td>\n",
       "      <td>13459618.0</td>\n",
       "      <td>5938121.0</td>\n",
       "      <td>127793995</td>\n",
       "      <td>63907200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Haryana</td>\n",
       "      <td>1056602</td>\n",
       "      <td>43.0</td>\n",
       "      <td>1045845</td>\n",
       "      <td>10714.0</td>\n",
       "      <td>21955717.0</td>\n",
       "      <td>18732346</td>\n",
       "      <td>13459618.0</td>\n",
       "      <td>701811.0</td>\n",
       "      <td>45457359</td>\n",
       "      <td>27388008.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Himachal Pradesh</td>\n",
       "      <td>312644</td>\n",
       "      <td>23.0</td>\n",
       "      <td>308408</td>\n",
       "      <td>4213.0</td>\n",
       "      <td>6041658.0</td>\n",
       "      <td>5780254</td>\n",
       "      <td>1485328.0</td>\n",
       "      <td>823689.0</td>\n",
       "      <td>15278680</td>\n",
       "      <td>7316708.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Jammu and Kashmir</td>\n",
       "      <td>479410</td>\n",
       "      <td>17.0</td>\n",
       "      <td>474608</td>\n",
       "      <td>4785.0</td>\n",
       "      <td>9941757.0</td>\n",
       "      <td>10386967</td>\n",
       "      <td>930096.0</td>\n",
       "      <td>669871.0</td>\n",
       "      <td>24738045</td>\n",
       "      <td>14046258.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Jharkhand</td>\n",
       "      <td>442570</td>\n",
       "      <td>17.0</td>\n",
       "      <td>437236</td>\n",
       "      <td>5331.0</td>\n",
       "      <td>21300448.0</td>\n",
       "      <td>16046070</td>\n",
       "      <td>1306687.0</td>\n",
       "      <td>664308.0</td>\n",
       "      <td>43689818</td>\n",
       "      <td>14046258.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Karnataka</td>\n",
       "      <td>4071893</td>\n",
       "      <td>1275.0</td>\n",
       "      <td>4030311</td>\n",
       "      <td>40307.0</td>\n",
       "      <td>50016690.0</td>\n",
       "      <td>50455767</td>\n",
       "      <td>5727031.0</td>\n",
       "      <td>4726542.0</td>\n",
       "      <td>120928298</td>\n",
       "      <td>66165886.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Kerala</td>\n",
       "      <td>6828245</td>\n",
       "      <td>1389.0</td>\n",
       "      <td>6755304</td>\n",
       "      <td>71552.0</td>\n",
       "      <td>27013745.0</td>\n",
       "      <td>23791879</td>\n",
       "      <td>854595.0</td>\n",
       "      <td>2215656.0</td>\n",
       "      <td>57477992</td>\n",
       "      <td>35330888.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Ladakh</td>\n",
       "      <td>29412</td>\n",
       "      <td>3.0</td>\n",
       "      <td>29178</td>\n",
       "      <td>231.0</td>\n",
       "      <td>219564.0</td>\n",
       "      <td>186942</td>\n",
       "      <td>68766.0</td>\n",
       "      <td>53990.0</td>\n",
       "      <td>564943</td>\n",
       "      <td>307204.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Lakshadweep</td>\n",
       "      <td>11415</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11363</td>\n",
       "      <td>52.0</td>\n",
       "      <td>56908.0</td>\n",
       "      <td>55992</td>\n",
       "      <td>15757.0</td>\n",
       "      <td>6949.0</td>\n",
       "      <td>145008</td>\n",
       "      <td>72210.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Madhya Pradesh</td>\n",
       "      <td>1054918</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1044138</td>\n",
       "      <td>10776.0</td>\n",
       "      <td>54140166.0</td>\n",
       "      <td>54035268</td>\n",
       "      <td>9854998.0</td>\n",
       "      <td>3787239.0</td>\n",
       "      <td>133590886</td>\n",
       "      <td>82342793.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Maharashtra</td>\n",
       "      <td>8136588</td>\n",
       "      <td>164.0</td>\n",
       "      <td>7988008</td>\n",
       "      <td>148416.0</td>\n",
       "      <td>84644083.0</td>\n",
       "      <td>71593498</td>\n",
       "      <td>5022623.0</td>\n",
       "      <td>4450343.0</td>\n",
       "      <td>177678317</td>\n",
       "      <td>120837347.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Manipur</td>\n",
       "      <td>139922</td>\n",
       "      <td>0.0</td>\n",
       "      <td>137773</td>\n",
       "      <td>2149.0</td>\n",
       "      <td>1463998.0</td>\n",
       "      <td>1225599</td>\n",
       "      <td>114004.0</td>\n",
       "      <td>165096.0</td>\n",
       "      <td>3265933</td>\n",
       "      <td>3008546.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Meghalaya</td>\n",
       "      <td>96783</td>\n",
       "      <td>1.0</td>\n",
       "      <td>95158</td>\n",
       "      <td>1624.0</td>\n",
       "      <td>1332102.0</td>\n",
       "      <td>1024902</td>\n",
       "      <td>30706.0</td>\n",
       "      <td>56987.0</td>\n",
       "      <td>2621058</td>\n",
       "      <td>3276323.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Mizoram</td>\n",
       "      <td>238964</td>\n",
       "      <td>0.0</td>\n",
       "      <td>238238</td>\n",
       "      <td>726.0</td>\n",
       "      <td>785749.0</td>\n",
       "      <td>668814</td>\n",
       "      <td>79573.0</td>\n",
       "      <td>67619.0</td>\n",
       "      <td>1790818</td>\n",
       "      <td>1205974.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Nagaland</td>\n",
       "      <td>35986</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35204</td>\n",
       "      <td>782.0</td>\n",
       "      <td>837775.0</td>\n",
       "      <td>684306</td>\n",
       "      <td>26060.0</td>\n",
       "      <td>43640.0</td>\n",
       "      <td>1737554</td>\n",
       "      <td>2189297.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Odisha</td>\n",
       "      <td>1336552</td>\n",
       "      <td>91.0</td>\n",
       "      <td>1327256</td>\n",
       "      <td>9205.0</td>\n",
       "      <td>31453659.0</td>\n",
       "      <td>29949756</td>\n",
       "      <td>9995330.0</td>\n",
       "      <td>3199384.0</td>\n",
       "      <td>81445474</td>\n",
       "      <td>45429399.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Puducherry</td>\n",
       "      <td>175508</td>\n",
       "      <td>5.0</td>\n",
       "      <td>173528</td>\n",
       "      <td>1975.0</td>\n",
       "      <td>912901.0</td>\n",
       "      <td>801853</td>\n",
       "      <td>303475.0</td>\n",
       "      <td>106956.0</td>\n",
       "      <td>2272617</td>\n",
       "      <td>1397707.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Punjab</td>\n",
       "      <td>784205</td>\n",
       "      <td>49.0</td>\n",
       "      <td>764867</td>\n",
       "      <td>19289.0</td>\n",
       "      <td>22352681.0</td>\n",
       "      <td>19602907</td>\n",
       "      <td>799986.0</td>\n",
       "      <td>1041039.0</td>\n",
       "      <td>46970300</td>\n",
       "      <td>29611935.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Rajasthan</td>\n",
       "      <td>1315455</td>\n",
       "      <td>88.0</td>\n",
       "      <td>1305714</td>\n",
       "      <td>9653.0</td>\n",
       "      <td>51103054.0</td>\n",
       "      <td>46510275</td>\n",
       "      <td>4387205.0</td>\n",
       "      <td>2995864.0</td>\n",
       "      <td>115325059</td>\n",
       "      <td>78230816.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Sikkim</td>\n",
       "      <td>44319</td>\n",
       "      <td>1.0</td>\n",
       "      <td>43819</td>\n",
       "      <td>499.0</td>\n",
       "      <td>539927.0</td>\n",
       "      <td>509134</td>\n",
       "      <td>158276.0</td>\n",
       "      <td>55637.0</td>\n",
       "      <td>1360444</td>\n",
       "      <td>671720.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Tamil Nadu</td>\n",
       "      <td>3594388</td>\n",
       "      <td>60.0</td>\n",
       "      <td>3556279</td>\n",
       "      <td>38049.0</td>\n",
       "      <td>56659544.0</td>\n",
       "      <td>53499923</td>\n",
       "      <td>6033504.0</td>\n",
       "      <td>3021694.0</td>\n",
       "      <td>127442647</td>\n",
       "      <td>76481545.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Telengana</td>\n",
       "      <td>841324</td>\n",
       "      <td>71.0</td>\n",
       "      <td>837142</td>\n",
       "      <td>4111.0</td>\n",
       "      <td>29607672.0</td>\n",
       "      <td>29053708</td>\n",
       "      <td>10525975.0</td>\n",
       "      <td>2702159.0</td>\n",
       "      <td>77201709</td>\n",
       "      <td>38472769.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Tripura</td>\n",
       "      <td>108034</td>\n",
       "      <td>0.0</td>\n",
       "      <td>107094</td>\n",
       "      <td>940.0</td>\n",
       "      <td>2658852.0</td>\n",
       "      <td>2328613</td>\n",
       "      <td>271434.0</td>\n",
       "      <td>204733.0</td>\n",
       "      <td>5916312</td>\n",
       "      <td>4057847.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Uttar Pradesh</td>\n",
       "      <td>2128103</td>\n",
       "      <td>46.0</td>\n",
       "      <td>2104424</td>\n",
       "      <td>23633.0</td>\n",
       "      <td>154058287.0</td>\n",
       "      <td>147716010</td>\n",
       "      <td>35623544.0</td>\n",
       "      <td>9240735.0</td>\n",
       "      <td>390639497</td>\n",
       "      <td>228959599.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Uttarakhand</td>\n",
       "      <td>449379</td>\n",
       "      <td>28.0</td>\n",
       "      <td>441600</td>\n",
       "      <td>7751.0</td>\n",
       "      <td>8180312.0</td>\n",
       "      <td>7940592</td>\n",
       "      <td>1346150.0</td>\n",
       "      <td>867047.0</td>\n",
       "      <td>20051714</td>\n",
       "      <td>11090425.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>West Bengal</td>\n",
       "      <td>2118606</td>\n",
       "      <td>58.0</td>\n",
       "      <td>2097016</td>\n",
       "      <td>21532.0</td>\n",
       "      <td>67300236.0</td>\n",
       "      <td>61593452</td>\n",
       "      <td>10257324.0</td>\n",
       "      <td>5491943.0</td>\n",
       "      <td>155962840</td>\n",
       "      <td>97694960.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       state  confirmed  active  passive  \\\n",
       "0                        Andaman and Nicobar      10742     1.0    10612   \n",
       "1                             Andhra Pradesh    2339067     3.0  2324331   \n",
       "2                          Arunachal Pradesh      66890     3.0    66594   \n",
       "3                                      Assam     746100     0.0   738065   \n",
       "4                                      Bihar     851379    15.0   839062   \n",
       "5                                 Chandigarh      99348     6.0    98161   \n",
       "6                               Chhattisgarh    1177749     6.0  1163597   \n",
       "7   Dadra and Nagar Haveli and Daman and Diu      11591     0.0    11587   \n",
       "8                                      Delhi    2007188    35.0  1980632   \n",
       "9                                      Delhi     259079    26.0   255040   \n",
       "10                                   Gujarat    1277557    41.0  1266473   \n",
       "11                                   Haryana    1056602    43.0  1045845   \n",
       "12                          Himachal Pradesh     312644    23.0   308408   \n",
       "13                         Jammu and Kashmir     479410    17.0   474608   \n",
       "14                                 Jharkhand     442570    17.0   437236   \n",
       "15                                 Karnataka    4071893  1275.0  4030311   \n",
       "16                                    Kerala    6828245  1389.0  6755304   \n",
       "17                                    Ladakh      29412     3.0    29178   \n",
       "18                               Lakshadweep      11415     0.0    11363   \n",
       "19                            Madhya Pradesh    1054918     4.0  1044138   \n",
       "20                               Maharashtra    8136588   164.0  7988008   \n",
       "21                                   Manipur     139922     0.0   137773   \n",
       "22                                 Meghalaya      96783     1.0    95158   \n",
       "23                                   Mizoram     238964     0.0   238238   \n",
       "24                                  Nagaland      35986     0.0    35204   \n",
       "25                                    Odisha    1336552    91.0  1327256   \n",
       "26                                Puducherry     175508     5.0   173528   \n",
       "27                                    Punjab     784205    49.0   764867   \n",
       "28                                 Rajasthan    1315455    88.0  1305714   \n",
       "29                                    Sikkim      44319     1.0    43819   \n",
       "30                                Tamil Nadu    3594388    60.0  3556279   \n",
       "31                                 Telengana     841324    71.0   837142   \n",
       "32                                   Tripura     108034     0.0   107094   \n",
       "33                             Uttar Pradesh    2128103    46.0  2104424   \n",
       "34                               Uttarakhand     449379    28.0   441600   \n",
       "35                               West Bengal    2118606    58.0  2097016   \n",
       "\n",
       "      deaths        dose1      dose2       dose3  precaution_dose  \\\n",
       "0      129.0     313284.0     320383    236936.0          53427.0   \n",
       "1    14733.0   40643161.0   43549055  11703273.0        6579565.0   \n",
       "2      296.0     860442.0     747177  11703273.0          58618.0   \n",
       "3     8035.0   22549957.0   20561790   2082670.0        1259853.0   \n",
       "4    12302.0   62944633.0   59144387  11983504.0        3868082.0   \n",
       "5    12302.0    1089254.0     917701     48480.0          63046.0   \n",
       "6    14146.0    1089254.0   18534989   5737679.0        1804891.0   \n",
       "7        4.0     730746.0     594929    136967.0        1804891.0   \n",
       "8    26521.0     730746.0   14348835   2312803.0        1053393.0   \n",
       "9     4013.0    1354828.0    1224173     60838.0          76559.0   \n",
       "10   11043.0   49314588.0   49428283  13459618.0        5938121.0   \n",
       "11   10714.0   21955717.0   18732346  13459618.0         701811.0   \n",
       "12    4213.0    6041658.0    5780254   1485328.0         823689.0   \n",
       "13    4785.0    9941757.0   10386967    930096.0         669871.0   \n",
       "14    5331.0   21300448.0   16046070   1306687.0         664308.0   \n",
       "15   40307.0   50016690.0   50455767   5727031.0        4726542.0   \n",
       "16   71552.0   27013745.0   23791879    854595.0        2215656.0   \n",
       "17     231.0     219564.0     186942     68766.0          53990.0   \n",
       "18      52.0      56908.0      55992     15757.0           6949.0   \n",
       "19   10776.0   54140166.0   54035268   9854998.0        3787239.0   \n",
       "20  148416.0   84644083.0   71593498   5022623.0        4450343.0   \n",
       "21    2149.0    1463998.0    1225599    114004.0         165096.0   \n",
       "22    1624.0    1332102.0    1024902     30706.0          56987.0   \n",
       "23     726.0     785749.0     668814     79573.0          67619.0   \n",
       "24     782.0     837775.0     684306     26060.0          43640.0   \n",
       "25    9205.0   31453659.0   29949756   9995330.0        3199384.0   \n",
       "26    1975.0     912901.0     801853    303475.0         106956.0   \n",
       "27   19289.0   22352681.0   19602907    799986.0        1041039.0   \n",
       "28    9653.0   51103054.0   46510275   4387205.0        2995864.0   \n",
       "29     499.0     539927.0     509134    158276.0          55637.0   \n",
       "30   38049.0   56659544.0   53499923   6033504.0        3021694.0   \n",
       "31    4111.0   29607672.0   29053708  10525975.0        2702159.0   \n",
       "32     940.0    2658852.0    2328613    271434.0         204733.0   \n",
       "33   23633.0  154058287.0  147716010  35623544.0        9240735.0   \n",
       "34    7751.0    8180312.0    7940592   1346150.0         867047.0   \n",
       "35   21532.0   67300236.0   61593452  10257324.0        5491943.0   \n",
       "\n",
       "    total_doses   population  \n",
       "0        991263     426251.0  \n",
       "1     110556756   52883163.0  \n",
       "2       1911760    1528296.0  \n",
       "3      50284713   34586234.0  \n",
       "4     157197041  119461013.0  \n",
       "5       2282281    1182104.0  \n",
       "6      49148991   28566990.0  \n",
       "7       1578492     657391.0  \n",
       "8      37366540   18802494.0  \n",
       "9       2872582    1542750.0  \n",
       "10    127793995   63907200.0  \n",
       "11     45457359   27388008.0  \n",
       "12     15278680    7316708.0  \n",
       "13     24738045   14046258.0  \n",
       "14     43689818   14046258.0  \n",
       "15    120928298   66165886.0  \n",
       "16     57477992   35330888.0  \n",
       "17       564943     307204.0  \n",
       "18       145008      72210.0  \n",
       "19    133590886   82342793.0  \n",
       "20    177678317  120837347.0  \n",
       "21      3265933    3008546.0  \n",
       "22      2621058    3276323.0  \n",
       "23      1790818    1205974.0  \n",
       "24      1737554    2189297.0  \n",
       "25     81445474   45429399.0  \n",
       "26      2272617    1397707.0  \n",
       "27     46970300   29611935.0  \n",
       "28    115325059   78230816.0  \n",
       "29      1360444     671720.0  \n",
       "30    127442647   76481545.0  \n",
       "31     77201709   38472769.0  \n",
       "32      5916312    4057847.0  \n",
       "33    390639497  228959599.0  \n",
       "34     20051714   11090425.0  \n",
       "35    155962840   97694960.0  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.fillna(method = 'ffill')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "89f67679",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>state</th>\n",
       "      <th>confirmed</th>\n",
       "      <th>active</th>\n",
       "      <th>passive</th>\n",
       "      <th>deaths</th>\n",
       "      <th>dose1</th>\n",
       "      <th>dose2</th>\n",
       "      <th>dose3</th>\n",
       "      <th>precaution_dose</th>\n",
       "      <th>total_doses</th>\n",
       "      <th>population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Andaman and Nicobar</td>\n",
       "      <td>10742</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10612</td>\n",
       "      <td>129.0</td>\n",
       "      <td>313284.0</td>\n",
       "      <td>320383</td>\n",
       "      <td>236936.0</td>\n",
       "      <td>53427.0</td>\n",
       "      <td>991263</td>\n",
       "      <td>426251.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Andhra Pradesh</td>\n",
       "      <td>2339067</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2324331</td>\n",
       "      <td>14733.0</td>\n",
       "      <td>40643161.0</td>\n",
       "      <td>43549055</td>\n",
       "      <td>11703273.0</td>\n",
       "      <td>6579565.0</td>\n",
       "      <td>110556756</td>\n",
       "      <td>52883163.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Arunachal Pradesh</td>\n",
       "      <td>66890</td>\n",
       "      <td>66594</td>\n",
       "      <td>66594</td>\n",
       "      <td>296.0</td>\n",
       "      <td>860442.0</td>\n",
       "      <td>747177</td>\n",
       "      <td>58618.0</td>\n",
       "      <td>58618.0</td>\n",
       "      <td>1911760</td>\n",
       "      <td>1528296.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Assam</td>\n",
       "      <td>746100</td>\n",
       "      <td>0.0</td>\n",
       "      <td>738065</td>\n",
       "      <td>8035.0</td>\n",
       "      <td>22549957.0</td>\n",
       "      <td>20561790</td>\n",
       "      <td>2082670.0</td>\n",
       "      <td>1259853.0</td>\n",
       "      <td>50284713</td>\n",
       "      <td>34586234.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Bihar</td>\n",
       "      <td>851379</td>\n",
       "      <td>15.0</td>\n",
       "      <td>839062</td>\n",
       "      <td>12302.0</td>\n",
       "      <td>62944633.0</td>\n",
       "      <td>59144387</td>\n",
       "      <td>11983504.0</td>\n",
       "      <td>3868082.0</td>\n",
       "      <td>157197041</td>\n",
       "      <td>119461013.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Chandigarh</td>\n",
       "      <td>99348</td>\n",
       "      <td>6.0</td>\n",
       "      <td>98161</td>\n",
       "      <td>1089254.0</td>\n",
       "      <td>1089254.0</td>\n",
       "      <td>917701</td>\n",
       "      <td>48480.0</td>\n",
       "      <td>63046.0</td>\n",
       "      <td>2282281</td>\n",
       "      <td>1182104.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Chhattisgarh</td>\n",
       "      <td>1177749</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1163597</td>\n",
       "      <td>14146.0</td>\n",
       "      <td>18534989</td>\n",
       "      <td>18534989</td>\n",
       "      <td>5737679.0</td>\n",
       "      <td>1804891.0</td>\n",
       "      <td>49148991</td>\n",
       "      <td>28566990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Dadra and Nagar Haveli and Daman and Diu</td>\n",
       "      <td>11591</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11587</td>\n",
       "      <td>4.0</td>\n",
       "      <td>730746.0</td>\n",
       "      <td>594929</td>\n",
       "      <td>136967.0</td>\n",
       "      <td>1578492</td>\n",
       "      <td>1578492</td>\n",
       "      <td>657391.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Delhi</td>\n",
       "      <td>2007188</td>\n",
       "      <td>35.0</td>\n",
       "      <td>1980632</td>\n",
       "      <td>26521.0</td>\n",
       "      <td>14348835</td>\n",
       "      <td>14348835</td>\n",
       "      <td>2312803.0</td>\n",
       "      <td>1053393.0</td>\n",
       "      <td>37366540</td>\n",
       "      <td>18802494.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>259079.0</td>\n",
       "      <td>259079.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>255040.0</td>\n",
       "      <td>4013.0</td>\n",
       "      <td>1354828.0</td>\n",
       "      <td>1224173.0</td>\n",
       "      <td>60838.0</td>\n",
       "      <td>76559.0</td>\n",
       "      <td>2872582.0</td>\n",
       "      <td>1542750.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Gujarat</td>\n",
       "      <td>1277557</td>\n",
       "      <td>41.0</td>\n",
       "      <td>1266473</td>\n",
       "      <td>11043.0</td>\n",
       "      <td>49314588.0</td>\n",
       "      <td>49428283</td>\n",
       "      <td>13459618.0</td>\n",
       "      <td>5938121.0</td>\n",
       "      <td>127793995</td>\n",
       "      <td>63907200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Haryana</td>\n",
       "      <td>1056602</td>\n",
       "      <td>43.0</td>\n",
       "      <td>1045845</td>\n",
       "      <td>10714.0</td>\n",
       "      <td>21955717.0</td>\n",
       "      <td>18732346</td>\n",
       "      <td>701811.0</td>\n",
       "      <td>701811.0</td>\n",
       "      <td>45457359</td>\n",
       "      <td>27388008.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Himachal Pradesh</td>\n",
       "      <td>312644</td>\n",
       "      <td>23.0</td>\n",
       "      <td>308408</td>\n",
       "      <td>4213.0</td>\n",
       "      <td>6041658.0</td>\n",
       "      <td>5780254</td>\n",
       "      <td>1485328.0</td>\n",
       "      <td>823689.0</td>\n",
       "      <td>15278680</td>\n",
       "      <td>7316708.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Jammu and Kashmir</td>\n",
       "      <td>479410</td>\n",
       "      <td>17.0</td>\n",
       "      <td>474608</td>\n",
       "      <td>4785.0</td>\n",
       "      <td>9941757.0</td>\n",
       "      <td>10386967</td>\n",
       "      <td>930096.0</td>\n",
       "      <td>669871.0</td>\n",
       "      <td>24738045</td>\n",
       "      <td>14046258.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Jharkhand</td>\n",
       "      <td>442570</td>\n",
       "      <td>437236</td>\n",
       "      <td>437236</td>\n",
       "      <td>5331.0</td>\n",
       "      <td>21300448.0</td>\n",
       "      <td>16046070</td>\n",
       "      <td>1306687.0</td>\n",
       "      <td>664308.0</td>\n",
       "      <td>43689818</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Karnataka</td>\n",
       "      <td>4071893</td>\n",
       "      <td>1275.0</td>\n",
       "      <td>4030311</td>\n",
       "      <td>40307.0</td>\n",
       "      <td>50016690.0</td>\n",
       "      <td>50455767</td>\n",
       "      <td>5727031.0</td>\n",
       "      <td>4726542.0</td>\n",
       "      <td>120928298</td>\n",
       "      <td>66165886.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Kerala</td>\n",
       "      <td>6828245</td>\n",
       "      <td>1389.0</td>\n",
       "      <td>6755304</td>\n",
       "      <td>71552.0</td>\n",
       "      <td>27013745.0</td>\n",
       "      <td>23791879</td>\n",
       "      <td>854595.0</td>\n",
       "      <td>2215656.0</td>\n",
       "      <td>57477992</td>\n",
       "      <td>35330888.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Ladakh</td>\n",
       "      <td>29412</td>\n",
       "      <td>3.0</td>\n",
       "      <td>29178</td>\n",
       "      <td>231.0</td>\n",
       "      <td>219564.0</td>\n",
       "      <td>186942</td>\n",
       "      <td>68766.0</td>\n",
       "      <td>53990.0</td>\n",
       "      <td>564943</td>\n",
       "      <td>307204.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Lakshadweep</td>\n",
       "      <td>11415</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11363</td>\n",
       "      <td>52.0</td>\n",
       "      <td>56908.0</td>\n",
       "      <td>55992</td>\n",
       "      <td>15757.0</td>\n",
       "      <td>6949.0</td>\n",
       "      <td>145008</td>\n",
       "      <td>72210.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Madhya Pradesh</td>\n",
       "      <td>1054918</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1044138</td>\n",
       "      <td>10776.0</td>\n",
       "      <td>54140166.0</td>\n",
       "      <td>54035268</td>\n",
       "      <td>9854998.0</td>\n",
       "      <td>3787239.0</td>\n",
       "      <td>133590886</td>\n",
       "      <td>82342793.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Maharashtra</td>\n",
       "      <td>8136588</td>\n",
       "      <td>164.0</td>\n",
       "      <td>7988008</td>\n",
       "      <td>148416.0</td>\n",
       "      <td>84644083.0</td>\n",
       "      <td>71593498</td>\n",
       "      <td>5022623.0</td>\n",
       "      <td>4450343.0</td>\n",
       "      <td>177678317</td>\n",
       "      <td>120837347.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Manipur</td>\n",
       "      <td>139922</td>\n",
       "      <td>0.0</td>\n",
       "      <td>137773</td>\n",
       "      <td>2149.0</td>\n",
       "      <td>1463998.0</td>\n",
       "      <td>1225599</td>\n",
       "      <td>114004.0</td>\n",
       "      <td>165096.0</td>\n",
       "      <td>3265933</td>\n",
       "      <td>3008546.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Meghalaya</td>\n",
       "      <td>96783</td>\n",
       "      <td>1.0</td>\n",
       "      <td>95158</td>\n",
       "      <td>1624.0</td>\n",
       "      <td>1332102.0</td>\n",
       "      <td>1024902</td>\n",
       "      <td>30706.0</td>\n",
       "      <td>56987.0</td>\n",
       "      <td>2621058</td>\n",
       "      <td>3276323.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Mizoram</td>\n",
       "      <td>238964</td>\n",
       "      <td>0.0</td>\n",
       "      <td>238238</td>\n",
       "      <td>726.0</td>\n",
       "      <td>785749.0</td>\n",
       "      <td>668814</td>\n",
       "      <td>79573.0</td>\n",
       "      <td>67619.0</td>\n",
       "      <td>1790818</td>\n",
       "      <td>1205974.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Nagaland</td>\n",
       "      <td>35986</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35204</td>\n",
       "      <td>782.0</td>\n",
       "      <td>837775.0</td>\n",
       "      <td>684306</td>\n",
       "      <td>26060.0</td>\n",
       "      <td>43640.0</td>\n",
       "      <td>1737554</td>\n",
       "      <td>2189297.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Odisha</td>\n",
       "      <td>1336552</td>\n",
       "      <td>91.0</td>\n",
       "      <td>1327256</td>\n",
       "      <td>9205.0</td>\n",
       "      <td>31453659.0</td>\n",
       "      <td>29949756</td>\n",
       "      <td>9995330.0</td>\n",
       "      <td>3199384.0</td>\n",
       "      <td>81445474</td>\n",
       "      <td>45429399.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Puducherry</td>\n",
       "      <td>175508</td>\n",
       "      <td>5.0</td>\n",
       "      <td>173528</td>\n",
       "      <td>1975.0</td>\n",
       "      <td>912901.0</td>\n",
       "      <td>801853</td>\n",
       "      <td>303475.0</td>\n",
       "      <td>106956.0</td>\n",
       "      <td>2272617</td>\n",
       "      <td>1397707.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Punjab</td>\n",
       "      <td>784205</td>\n",
       "      <td>49.0</td>\n",
       "      <td>764867</td>\n",
       "      <td>19289.0</td>\n",
       "      <td>22352681.0</td>\n",
       "      <td>19602907</td>\n",
       "      <td>799986.0</td>\n",
       "      <td>1041039.0</td>\n",
       "      <td>46970300</td>\n",
       "      <td>29611935.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Rajasthan</td>\n",
       "      <td>1315455</td>\n",
       "      <td>88.0</td>\n",
       "      <td>1305714</td>\n",
       "      <td>9653.0</td>\n",
       "      <td>51103054.0</td>\n",
       "      <td>46510275</td>\n",
       "      <td>4387205.0</td>\n",
       "      <td>2995864.0</td>\n",
       "      <td>115325059</td>\n",
       "      <td>78230816.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Sikkim</td>\n",
       "      <td>44319</td>\n",
       "      <td>1.0</td>\n",
       "      <td>43819</td>\n",
       "      <td>499.0</td>\n",
       "      <td>539927.0</td>\n",
       "      <td>509134</td>\n",
       "      <td>158276.0</td>\n",
       "      <td>55637.0</td>\n",
       "      <td>1360444</td>\n",
       "      <td>671720.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Tamil Nadu</td>\n",
       "      <td>3594388</td>\n",
       "      <td>60.0</td>\n",
       "      <td>3556279</td>\n",
       "      <td>38049.0</td>\n",
       "      <td>56659544.0</td>\n",
       "      <td>53499923</td>\n",
       "      <td>6033504.0</td>\n",
       "      <td>3021694.0</td>\n",
       "      <td>127442647</td>\n",
       "      <td>76481545.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Telengana</td>\n",
       "      <td>841324</td>\n",
       "      <td>71.0</td>\n",
       "      <td>837142</td>\n",
       "      <td>4111.0</td>\n",
       "      <td>29607672.0</td>\n",
       "      <td>29053708</td>\n",
       "      <td>10525975.0</td>\n",
       "      <td>2702159.0</td>\n",
       "      <td>77201709</td>\n",
       "      <td>38472769.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Tripura</td>\n",
       "      <td>108034</td>\n",
       "      <td>0.0</td>\n",
       "      <td>107094</td>\n",
       "      <td>940.0</td>\n",
       "      <td>2658852.0</td>\n",
       "      <td>2328613</td>\n",
       "      <td>271434.0</td>\n",
       "      <td>204733.0</td>\n",
       "      <td>5916312</td>\n",
       "      <td>4057847.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Uttar Pradesh</td>\n",
       "      <td>2128103</td>\n",
       "      <td>46.0</td>\n",
       "      <td>2104424</td>\n",
       "      <td>23633.0</td>\n",
       "      <td>154058287.0</td>\n",
       "      <td>147716010</td>\n",
       "      <td>35623544.0</td>\n",
       "      <td>9240735.0</td>\n",
       "      <td>390639497</td>\n",
       "      <td>228959599.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Uttarakhand</td>\n",
       "      <td>449379</td>\n",
       "      <td>28.0</td>\n",
       "      <td>441600</td>\n",
       "      <td>7751.0</td>\n",
       "      <td>8180312.0</td>\n",
       "      <td>7940592</td>\n",
       "      <td>1346150.0</td>\n",
       "      <td>867047.0</td>\n",
       "      <td>20051714</td>\n",
       "      <td>11090425.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>West Bengal</td>\n",
       "      <td>2118606</td>\n",
       "      <td>58.0</td>\n",
       "      <td>2097016</td>\n",
       "      <td>21532.0</td>\n",
       "      <td>67300236.0</td>\n",
       "      <td>61593452</td>\n",
       "      <td>10257324.0</td>\n",
       "      <td>5491943.0</td>\n",
       "      <td>155962840</td>\n",
       "      <td>97694960.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       state confirmed  active   passive  \\\n",
       "0                        Andaman and Nicobar     10742     1.0     10612   \n",
       "1                             Andhra Pradesh   2339067     3.0   2324331   \n",
       "2                          Arunachal Pradesh     66890   66594     66594   \n",
       "3                                      Assam    746100     0.0    738065   \n",
       "4                                      Bihar    851379    15.0    839062   \n",
       "5                                 Chandigarh     99348     6.0     98161   \n",
       "6                               Chhattisgarh   1177749     6.0   1163597   \n",
       "7   Dadra and Nagar Haveli and Daman and Diu     11591     0.0     11587   \n",
       "8                                      Delhi   2007188    35.0   1980632   \n",
       "9                                   259079.0  259079.0    26.0  255040.0   \n",
       "10                                   Gujarat   1277557    41.0   1266473   \n",
       "11                                   Haryana   1056602    43.0   1045845   \n",
       "12                          Himachal Pradesh    312644    23.0    308408   \n",
       "13                         Jammu and Kashmir    479410    17.0    474608   \n",
       "14                                 Jharkhand    442570  437236    437236   \n",
       "15                                 Karnataka   4071893  1275.0   4030311   \n",
       "16                                    Kerala   6828245  1389.0   6755304   \n",
       "17                                    Ladakh     29412     3.0     29178   \n",
       "18                               Lakshadweep     11415     0.0     11363   \n",
       "19                            Madhya Pradesh   1054918     4.0   1044138   \n",
       "20                               Maharashtra   8136588   164.0   7988008   \n",
       "21                                   Manipur    139922     0.0    137773   \n",
       "22                                 Meghalaya     96783     1.0     95158   \n",
       "23                                   Mizoram    238964     0.0    238238   \n",
       "24                                  Nagaland     35986     0.0     35204   \n",
       "25                                    Odisha   1336552    91.0   1327256   \n",
       "26                                Puducherry    175508     5.0    173528   \n",
       "27                                    Punjab    784205    49.0    764867   \n",
       "28                                 Rajasthan   1315455    88.0   1305714   \n",
       "29                                    Sikkim     44319     1.0     43819   \n",
       "30                                Tamil Nadu   3594388    60.0   3556279   \n",
       "31                                 Telengana    841324    71.0    837142   \n",
       "32                                   Tripura    108034     0.0    107094   \n",
       "33                             Uttar Pradesh   2128103    46.0   2104424   \n",
       "34                               Uttarakhand    449379    28.0    441600   \n",
       "35                               West Bengal   2118606    58.0   2097016   \n",
       "\n",
       "       deaths        dose1      dose2       dose3 precaution_dose total_doses  \\\n",
       "0       129.0     313284.0     320383    236936.0         53427.0      991263   \n",
       "1     14733.0   40643161.0   43549055  11703273.0       6579565.0   110556756   \n",
       "2       296.0     860442.0     747177     58618.0         58618.0     1911760   \n",
       "3      8035.0   22549957.0   20561790   2082670.0       1259853.0    50284713   \n",
       "4     12302.0   62944633.0   59144387  11983504.0       3868082.0   157197041   \n",
       "5   1089254.0    1089254.0     917701     48480.0         63046.0     2282281   \n",
       "6     14146.0     18534989   18534989   5737679.0       1804891.0    49148991   \n",
       "7         4.0     730746.0     594929    136967.0         1578492     1578492   \n",
       "8     26521.0     14348835   14348835   2312803.0       1053393.0    37366540   \n",
       "9      4013.0    1354828.0  1224173.0     60838.0         76559.0   2872582.0   \n",
       "10    11043.0   49314588.0   49428283  13459618.0       5938121.0   127793995   \n",
       "11    10714.0   21955717.0   18732346    701811.0        701811.0    45457359   \n",
       "12     4213.0    6041658.0    5780254   1485328.0        823689.0    15278680   \n",
       "13     4785.0    9941757.0   10386967    930096.0        669871.0    24738045   \n",
       "14     5331.0   21300448.0   16046070   1306687.0        664308.0    43689818   \n",
       "15    40307.0   50016690.0   50455767   5727031.0       4726542.0   120928298   \n",
       "16    71552.0   27013745.0   23791879    854595.0       2215656.0    57477992   \n",
       "17      231.0     219564.0     186942     68766.0         53990.0      564943   \n",
       "18       52.0      56908.0      55992     15757.0          6949.0      145008   \n",
       "19    10776.0   54140166.0   54035268   9854998.0       3787239.0   133590886   \n",
       "20   148416.0   84644083.0   71593498   5022623.0       4450343.0   177678317   \n",
       "21     2149.0    1463998.0    1225599    114004.0        165096.0     3265933   \n",
       "22     1624.0    1332102.0    1024902     30706.0         56987.0     2621058   \n",
       "23      726.0     785749.0     668814     79573.0         67619.0     1790818   \n",
       "24      782.0     837775.0     684306     26060.0         43640.0     1737554   \n",
       "25     9205.0   31453659.0   29949756   9995330.0       3199384.0    81445474   \n",
       "26     1975.0     912901.0     801853    303475.0        106956.0     2272617   \n",
       "27    19289.0   22352681.0   19602907    799986.0       1041039.0    46970300   \n",
       "28     9653.0   51103054.0   46510275   4387205.0       2995864.0   115325059   \n",
       "29      499.0     539927.0     509134    158276.0         55637.0     1360444   \n",
       "30    38049.0   56659544.0   53499923   6033504.0       3021694.0   127442647   \n",
       "31     4111.0   29607672.0   29053708  10525975.0       2702159.0    77201709   \n",
       "32      940.0    2658852.0    2328613    271434.0        204733.0     5916312   \n",
       "33    23633.0  154058287.0  147716010  35623544.0       9240735.0   390639497   \n",
       "34     7751.0    8180312.0    7940592   1346150.0        867047.0    20051714   \n",
       "35    21532.0   67300236.0   61593452  10257324.0       5491943.0   155962840   \n",
       "\n",
       "     population  \n",
       "0      426251.0  \n",
       "1    52883163.0  \n",
       "2     1528296.0  \n",
       "3    34586234.0  \n",
       "4   119461013.0  \n",
       "5     1182104.0  \n",
       "6    28566990.0  \n",
       "7      657391.0  \n",
       "8    18802494.0  \n",
       "9     1542750.0  \n",
       "10   63907200.0  \n",
       "11   27388008.0  \n",
       "12    7316708.0  \n",
       "13   14046258.0  \n",
       "14          NaN  \n",
       "15   66165886.0  \n",
       "16   35330888.0  \n",
       "17     307204.0  \n",
       "18      72210.0  \n",
       "19   82342793.0  \n",
       "20  120837347.0  \n",
       "21    3008546.0  \n",
       "22    3276323.0  \n",
       "23    1205974.0  \n",
       "24    2189297.0  \n",
       "25   45429399.0  \n",
       "26    1397707.0  \n",
       "27   29611935.0  \n",
       "28   78230816.0  \n",
       "29     671720.0  \n",
       "30   76481545.0  \n",
       "31   38472769.0  \n",
       "32    4057847.0  \n",
       "33  228959599.0  \n",
       "34   11090425.0  \n",
       "35   97694960.0  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.fillna(method = 'bfill', axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "bb9f78e1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>state</th>\n",
       "      <th>confirmed</th>\n",
       "      <th>active</th>\n",
       "      <th>passive</th>\n",
       "      <th>deaths</th>\n",
       "      <th>dose1</th>\n",
       "      <th>dose2</th>\n",
       "      <th>dose3</th>\n",
       "      <th>precaution_dose</th>\n",
       "      <th>total_doses</th>\n",
       "      <th>population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Andaman and Nicobar</td>\n",
       "      <td>10742</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10612</td>\n",
       "      <td>129.0</td>\n",
       "      <td>313284.0</td>\n",
       "      <td>320383</td>\n",
       "      <td>236936.0</td>\n",
       "      <td>53427.0</td>\n",
       "      <td>991263</td>\n",
       "      <td>426251.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Andhra Pradesh</td>\n",
       "      <td>2339067</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2324331</td>\n",
       "      <td>14733.0</td>\n",
       "      <td>40643161.0</td>\n",
       "      <td>43549055</td>\n",
       "      <td>11703273.0</td>\n",
       "      <td>6579565.0</td>\n",
       "      <td>110556756</td>\n",
       "      <td>52883163.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Arunachal Pradesh</td>\n",
       "      <td>66890</td>\n",
       "      <td>66890</td>\n",
       "      <td>66594</td>\n",
       "      <td>296.0</td>\n",
       "      <td>860442.0</td>\n",
       "      <td>747177</td>\n",
       "      <td>747177</td>\n",
       "      <td>58618.0</td>\n",
       "      <td>1911760</td>\n",
       "      <td>1528296.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Assam</td>\n",
       "      <td>746100</td>\n",
       "      <td>0.0</td>\n",
       "      <td>738065</td>\n",
       "      <td>8035.0</td>\n",
       "      <td>22549957.0</td>\n",
       "      <td>20561790</td>\n",
       "      <td>2082670.0</td>\n",
       "      <td>1259853.0</td>\n",
       "      <td>50284713</td>\n",
       "      <td>34586234.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Bihar</td>\n",
       "      <td>851379</td>\n",
       "      <td>15.0</td>\n",
       "      <td>839062</td>\n",
       "      <td>12302.0</td>\n",
       "      <td>62944633.0</td>\n",
       "      <td>59144387</td>\n",
       "      <td>11983504.0</td>\n",
       "      <td>3868082.0</td>\n",
       "      <td>157197041</td>\n",
       "      <td>119461013.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Chandigarh</td>\n",
       "      <td>99348</td>\n",
       "      <td>6.0</td>\n",
       "      <td>98161</td>\n",
       "      <td>98161</td>\n",
       "      <td>1089254.0</td>\n",
       "      <td>917701</td>\n",
       "      <td>48480.0</td>\n",
       "      <td>63046.0</td>\n",
       "      <td>2282281</td>\n",
       "      <td>1182104.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Chhattisgarh</td>\n",
       "      <td>1177749</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1163597</td>\n",
       "      <td>14146.0</td>\n",
       "      <td>14146.0</td>\n",
       "      <td>18534989</td>\n",
       "      <td>5737679.0</td>\n",
       "      <td>1804891.0</td>\n",
       "      <td>49148991</td>\n",
       "      <td>28566990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Dadra and Nagar Haveli and Daman and Diu</td>\n",
       "      <td>11591</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11587</td>\n",
       "      <td>4.0</td>\n",
       "      <td>730746.0</td>\n",
       "      <td>594929</td>\n",
       "      <td>136967.0</td>\n",
       "      <td>136967.0</td>\n",
       "      <td>1578492</td>\n",
       "      <td>657391.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Delhi</td>\n",
       "      <td>2007188</td>\n",
       "      <td>35.0</td>\n",
       "      <td>1980632</td>\n",
       "      <td>26521.0</td>\n",
       "      <td>26521.0</td>\n",
       "      <td>14348835</td>\n",
       "      <td>2312803.0</td>\n",
       "      <td>1053393.0</td>\n",
       "      <td>37366540</td>\n",
       "      <td>18802494.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>NaN</td>\n",
       "      <td>259079.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>255040.0</td>\n",
       "      <td>4013.0</td>\n",
       "      <td>1354828.0</td>\n",
       "      <td>1224173.0</td>\n",
       "      <td>60838.0</td>\n",
       "      <td>76559.0</td>\n",
       "      <td>2872582.0</td>\n",
       "      <td>1542750.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Gujarat</td>\n",
       "      <td>1277557</td>\n",
       "      <td>41.0</td>\n",
       "      <td>1266473</td>\n",
       "      <td>11043.0</td>\n",
       "      <td>49314588.0</td>\n",
       "      <td>49428283</td>\n",
       "      <td>13459618.0</td>\n",
       "      <td>5938121.0</td>\n",
       "      <td>127793995</td>\n",
       "      <td>63907200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Haryana</td>\n",
       "      <td>1056602</td>\n",
       "      <td>43.0</td>\n",
       "      <td>1045845</td>\n",
       "      <td>10714.0</td>\n",
       "      <td>21955717.0</td>\n",
       "      <td>18732346</td>\n",
       "      <td>18732346</td>\n",
       "      <td>701811.0</td>\n",
       "      <td>45457359</td>\n",
       "      <td>27388008.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Himachal Pradesh</td>\n",
       "      <td>312644</td>\n",
       "      <td>23.0</td>\n",
       "      <td>308408</td>\n",
       "      <td>4213.0</td>\n",
       "      <td>6041658.0</td>\n",
       "      <td>5780254</td>\n",
       "      <td>1485328.0</td>\n",
       "      <td>823689.0</td>\n",
       "      <td>15278680</td>\n",
       "      <td>7316708.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Jammu and Kashmir</td>\n",
       "      <td>479410</td>\n",
       "      <td>17.0</td>\n",
       "      <td>474608</td>\n",
       "      <td>4785.0</td>\n",
       "      <td>9941757.0</td>\n",
       "      <td>10386967</td>\n",
       "      <td>930096.0</td>\n",
       "      <td>669871.0</td>\n",
       "      <td>24738045</td>\n",
       "      <td>14046258.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Jharkhand</td>\n",
       "      <td>442570</td>\n",
       "      <td>442570</td>\n",
       "      <td>437236</td>\n",
       "      <td>5331.0</td>\n",
       "      <td>21300448.0</td>\n",
       "      <td>16046070</td>\n",
       "      <td>1306687.0</td>\n",
       "      <td>664308.0</td>\n",
       "      <td>43689818</td>\n",
       "      <td>43689818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Karnataka</td>\n",
       "      <td>4071893</td>\n",
       "      <td>1275.0</td>\n",
       "      <td>4030311</td>\n",
       "      <td>40307.0</td>\n",
       "      <td>50016690.0</td>\n",
       "      <td>50455767</td>\n",
       "      <td>5727031.0</td>\n",
       "      <td>4726542.0</td>\n",
       "      <td>120928298</td>\n",
       "      <td>66165886.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Kerala</td>\n",
       "      <td>6828245</td>\n",
       "      <td>1389.0</td>\n",
       "      <td>6755304</td>\n",
       "      <td>71552.0</td>\n",
       "      <td>27013745.0</td>\n",
       "      <td>23791879</td>\n",
       "      <td>854595.0</td>\n",
       "      <td>2215656.0</td>\n",
       "      <td>57477992</td>\n",
       "      <td>35330888.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Ladakh</td>\n",
       "      <td>29412</td>\n",
       "      <td>3.0</td>\n",
       "      <td>29178</td>\n",
       "      <td>231.0</td>\n",
       "      <td>219564.0</td>\n",
       "      <td>186942</td>\n",
       "      <td>68766.0</td>\n",
       "      <td>53990.0</td>\n",
       "      <td>564943</td>\n",
       "      <td>307204.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Lakshadweep</td>\n",
       "      <td>11415</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11363</td>\n",
       "      <td>52.0</td>\n",
       "      <td>56908.0</td>\n",
       "      <td>55992</td>\n",
       "      <td>15757.0</td>\n",
       "      <td>6949.0</td>\n",
       "      <td>145008</td>\n",
       "      <td>72210.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Madhya Pradesh</td>\n",
       "      <td>1054918</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1044138</td>\n",
       "      <td>10776.0</td>\n",
       "      <td>54140166.0</td>\n",
       "      <td>54035268</td>\n",
       "      <td>9854998.0</td>\n",
       "      <td>3787239.0</td>\n",
       "      <td>133590886</td>\n",
       "      <td>82342793.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Maharashtra</td>\n",
       "      <td>8136588</td>\n",
       "      <td>164.0</td>\n",
       "      <td>7988008</td>\n",
       "      <td>148416.0</td>\n",
       "      <td>84644083.0</td>\n",
       "      <td>71593498</td>\n",
       "      <td>5022623.0</td>\n",
       "      <td>4450343.0</td>\n",
       "      <td>177678317</td>\n",
       "      <td>120837347.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Manipur</td>\n",
       "      <td>139922</td>\n",
       "      <td>0.0</td>\n",
       "      <td>137773</td>\n",
       "      <td>2149.0</td>\n",
       "      <td>1463998.0</td>\n",
       "      <td>1225599</td>\n",
       "      <td>114004.0</td>\n",
       "      <td>165096.0</td>\n",
       "      <td>3265933</td>\n",
       "      <td>3008546.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Meghalaya</td>\n",
       "      <td>96783</td>\n",
       "      <td>1.0</td>\n",
       "      <td>95158</td>\n",
       "      <td>1624.0</td>\n",
       "      <td>1332102.0</td>\n",
       "      <td>1024902</td>\n",
       "      <td>30706.0</td>\n",
       "      <td>56987.0</td>\n",
       "      <td>2621058</td>\n",
       "      <td>3276323.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Mizoram</td>\n",
       "      <td>238964</td>\n",
       "      <td>0.0</td>\n",
       "      <td>238238</td>\n",
       "      <td>726.0</td>\n",
       "      <td>785749.0</td>\n",
       "      <td>668814</td>\n",
       "      <td>79573.0</td>\n",
       "      <td>67619.0</td>\n",
       "      <td>1790818</td>\n",
       "      <td>1205974.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Nagaland</td>\n",
       "      <td>35986</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35204</td>\n",
       "      <td>782.0</td>\n",
       "      <td>837775.0</td>\n",
       "      <td>684306</td>\n",
       "      <td>26060.0</td>\n",
       "      <td>43640.0</td>\n",
       "      <td>1737554</td>\n",
       "      <td>2189297.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Odisha</td>\n",
       "      <td>1336552</td>\n",
       "      <td>91.0</td>\n",
       "      <td>1327256</td>\n",
       "      <td>9205.0</td>\n",
       "      <td>31453659.0</td>\n",
       "      <td>29949756</td>\n",
       "      <td>9995330.0</td>\n",
       "      <td>3199384.0</td>\n",
       "      <td>81445474</td>\n",
       "      <td>45429399.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Puducherry</td>\n",
       "      <td>175508</td>\n",
       "      <td>5.0</td>\n",
       "      <td>173528</td>\n",
       "      <td>1975.0</td>\n",
       "      <td>912901.0</td>\n",
       "      <td>801853</td>\n",
       "      <td>303475.0</td>\n",
       "      <td>106956.0</td>\n",
       "      <td>2272617</td>\n",
       "      <td>1397707.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Punjab</td>\n",
       "      <td>784205</td>\n",
       "      <td>49.0</td>\n",
       "      <td>764867</td>\n",
       "      <td>19289.0</td>\n",
       "      <td>22352681.0</td>\n",
       "      <td>19602907</td>\n",
       "      <td>799986.0</td>\n",
       "      <td>1041039.0</td>\n",
       "      <td>46970300</td>\n",
       "      <td>29611935.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Rajasthan</td>\n",
       "      <td>1315455</td>\n",
       "      <td>88.0</td>\n",
       "      <td>1305714</td>\n",
       "      <td>9653.0</td>\n",
       "      <td>51103054.0</td>\n",
       "      <td>46510275</td>\n",
       "      <td>4387205.0</td>\n",
       "      <td>2995864.0</td>\n",
       "      <td>115325059</td>\n",
       "      <td>78230816.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Sikkim</td>\n",
       "      <td>44319</td>\n",
       "      <td>1.0</td>\n",
       "      <td>43819</td>\n",
       "      <td>499.0</td>\n",
       "      <td>539927.0</td>\n",
       "      <td>509134</td>\n",
       "      <td>158276.0</td>\n",
       "      <td>55637.0</td>\n",
       "      <td>1360444</td>\n",
       "      <td>671720.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Tamil Nadu</td>\n",
       "      <td>3594388</td>\n",
       "      <td>60.0</td>\n",
       "      <td>3556279</td>\n",
       "      <td>38049.0</td>\n",
       "      <td>56659544.0</td>\n",
       "      <td>53499923</td>\n",
       "      <td>6033504.0</td>\n",
       "      <td>3021694.0</td>\n",
       "      <td>127442647</td>\n",
       "      <td>76481545.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Telengana</td>\n",
       "      <td>841324</td>\n",
       "      <td>71.0</td>\n",
       "      <td>837142</td>\n",
       "      <td>4111.0</td>\n",
       "      <td>29607672.0</td>\n",
       "      <td>29053708</td>\n",
       "      <td>10525975.0</td>\n",
       "      <td>2702159.0</td>\n",
       "      <td>77201709</td>\n",
       "      <td>38472769.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Tripura</td>\n",
       "      <td>108034</td>\n",
       "      <td>0.0</td>\n",
       "      <td>107094</td>\n",
       "      <td>940.0</td>\n",
       "      <td>2658852.0</td>\n",
       "      <td>2328613</td>\n",
       "      <td>271434.0</td>\n",
       "      <td>204733.0</td>\n",
       "      <td>5916312</td>\n",
       "      <td>4057847.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Uttar Pradesh</td>\n",
       "      <td>2128103</td>\n",
       "      <td>46.0</td>\n",
       "      <td>2104424</td>\n",
       "      <td>23633.0</td>\n",
       "      <td>154058287.0</td>\n",
       "      <td>147716010</td>\n",
       "      <td>35623544.0</td>\n",
       "      <td>9240735.0</td>\n",
       "      <td>390639497</td>\n",
       "      <td>228959599.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Uttarakhand</td>\n",
       "      <td>449379</td>\n",
       "      <td>28.0</td>\n",
       "      <td>441600</td>\n",
       "      <td>7751.0</td>\n",
       "      <td>8180312.0</td>\n",
       "      <td>7940592</td>\n",
       "      <td>1346150.0</td>\n",
       "      <td>867047.0</td>\n",
       "      <td>20051714</td>\n",
       "      <td>11090425.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>West Bengal</td>\n",
       "      <td>2118606</td>\n",
       "      <td>58.0</td>\n",
       "      <td>2097016</td>\n",
       "      <td>21532.0</td>\n",
       "      <td>67300236.0</td>\n",
       "      <td>61593452</td>\n",
       "      <td>10257324.0</td>\n",
       "      <td>5491943.0</td>\n",
       "      <td>155962840</td>\n",
       "      <td>97694960.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       state confirmed  active   passive  \\\n",
       "0                        Andaman and Nicobar     10742     1.0     10612   \n",
       "1                             Andhra Pradesh   2339067     3.0   2324331   \n",
       "2                          Arunachal Pradesh     66890   66890     66594   \n",
       "3                                      Assam    746100     0.0    738065   \n",
       "4                                      Bihar    851379    15.0    839062   \n",
       "5                                 Chandigarh     99348     6.0     98161   \n",
       "6                               Chhattisgarh   1177749     6.0   1163597   \n",
       "7   Dadra and Nagar Haveli and Daman and Diu     11591     0.0     11587   \n",
       "8                                      Delhi   2007188    35.0   1980632   \n",
       "9                                        NaN  259079.0    26.0  255040.0   \n",
       "10                                   Gujarat   1277557    41.0   1266473   \n",
       "11                                   Haryana   1056602    43.0   1045845   \n",
       "12                          Himachal Pradesh    312644    23.0    308408   \n",
       "13                         Jammu and Kashmir    479410    17.0    474608   \n",
       "14                                 Jharkhand    442570  442570    437236   \n",
       "15                                 Karnataka   4071893  1275.0   4030311   \n",
       "16                                    Kerala   6828245  1389.0   6755304   \n",
       "17                                    Ladakh     29412     3.0     29178   \n",
       "18                               Lakshadweep     11415     0.0     11363   \n",
       "19                            Madhya Pradesh   1054918     4.0   1044138   \n",
       "20                               Maharashtra   8136588   164.0   7988008   \n",
       "21                                   Manipur    139922     0.0    137773   \n",
       "22                                 Meghalaya     96783     1.0     95158   \n",
       "23                                   Mizoram    238964     0.0    238238   \n",
       "24                                  Nagaland     35986     0.0     35204   \n",
       "25                                    Odisha   1336552    91.0   1327256   \n",
       "26                                Puducherry    175508     5.0    173528   \n",
       "27                                    Punjab    784205    49.0    764867   \n",
       "28                                 Rajasthan   1315455    88.0   1305714   \n",
       "29                                    Sikkim     44319     1.0     43819   \n",
       "30                                Tamil Nadu   3594388    60.0   3556279   \n",
       "31                                 Telengana    841324    71.0    837142   \n",
       "32                                   Tripura    108034     0.0    107094   \n",
       "33                             Uttar Pradesh   2128103    46.0   2104424   \n",
       "34                               Uttarakhand    449379    28.0    441600   \n",
       "35                               West Bengal   2118606    58.0   2097016   \n",
       "\n",
       "      deaths        dose1      dose2       dose3 precaution_dose total_doses  \\\n",
       "0      129.0     313284.0     320383    236936.0         53427.0      991263   \n",
       "1    14733.0   40643161.0   43549055  11703273.0       6579565.0   110556756   \n",
       "2      296.0     860442.0     747177      747177         58618.0     1911760   \n",
       "3     8035.0   22549957.0   20561790   2082670.0       1259853.0    50284713   \n",
       "4    12302.0   62944633.0   59144387  11983504.0       3868082.0   157197041   \n",
       "5      98161    1089254.0     917701     48480.0         63046.0     2282281   \n",
       "6    14146.0      14146.0   18534989   5737679.0       1804891.0    49148991   \n",
       "7        4.0     730746.0     594929    136967.0        136967.0     1578492   \n",
       "8    26521.0      26521.0   14348835   2312803.0       1053393.0    37366540   \n",
       "9     4013.0    1354828.0  1224173.0     60838.0         76559.0   2872582.0   \n",
       "10   11043.0   49314588.0   49428283  13459618.0       5938121.0   127793995   \n",
       "11   10714.0   21955717.0   18732346    18732346        701811.0    45457359   \n",
       "12    4213.0    6041658.0    5780254   1485328.0        823689.0    15278680   \n",
       "13    4785.0    9941757.0   10386967    930096.0        669871.0    24738045   \n",
       "14    5331.0   21300448.0   16046070   1306687.0        664308.0    43689818   \n",
       "15   40307.0   50016690.0   50455767   5727031.0       4726542.0   120928298   \n",
       "16   71552.0   27013745.0   23791879    854595.0       2215656.0    57477992   \n",
       "17     231.0     219564.0     186942     68766.0         53990.0      564943   \n",
       "18      52.0      56908.0      55992     15757.0          6949.0      145008   \n",
       "19   10776.0   54140166.0   54035268   9854998.0       3787239.0   133590886   \n",
       "20  148416.0   84644083.0   71593498   5022623.0       4450343.0   177678317   \n",
       "21    2149.0    1463998.0    1225599    114004.0        165096.0     3265933   \n",
       "22    1624.0    1332102.0    1024902     30706.0         56987.0     2621058   \n",
       "23     726.0     785749.0     668814     79573.0         67619.0     1790818   \n",
       "24     782.0     837775.0     684306     26060.0         43640.0     1737554   \n",
       "25    9205.0   31453659.0   29949756   9995330.0       3199384.0    81445474   \n",
       "26    1975.0     912901.0     801853    303475.0        106956.0     2272617   \n",
       "27   19289.0   22352681.0   19602907    799986.0       1041039.0    46970300   \n",
       "28    9653.0   51103054.0   46510275   4387205.0       2995864.0   115325059   \n",
       "29     499.0     539927.0     509134    158276.0         55637.0     1360444   \n",
       "30   38049.0   56659544.0   53499923   6033504.0       3021694.0   127442647   \n",
       "31    4111.0   29607672.0   29053708  10525975.0       2702159.0    77201709   \n",
       "32     940.0    2658852.0    2328613    271434.0        204733.0     5916312   \n",
       "33   23633.0  154058287.0  147716010  35623544.0       9240735.0   390639497   \n",
       "34    7751.0    8180312.0    7940592   1346150.0        867047.0    20051714   \n",
       "35   21532.0   67300236.0   61593452  10257324.0       5491943.0   155962840   \n",
       "\n",
       "     population  \n",
       "0      426251.0  \n",
       "1    52883163.0  \n",
       "2     1528296.0  \n",
       "3    34586234.0  \n",
       "4   119461013.0  \n",
       "5     1182104.0  \n",
       "6    28566990.0  \n",
       "7      657391.0  \n",
       "8    18802494.0  \n",
       "9     1542750.0  \n",
       "10   63907200.0  \n",
       "11   27388008.0  \n",
       "12    7316708.0  \n",
       "13   14046258.0  \n",
       "14     43689818  \n",
       "15   66165886.0  \n",
       "16   35330888.0  \n",
       "17     307204.0  \n",
       "18      72210.0  \n",
       "19   82342793.0  \n",
       "20  120837347.0  \n",
       "21    3008546.0  \n",
       "22    3276323.0  \n",
       "23    1205974.0  \n",
       "24    2189297.0  \n",
       "25   45429399.0  \n",
       "26    1397707.0  \n",
       "27   29611935.0  \n",
       "28   78230816.0  \n",
       "29     671720.0  \n",
       "30   76481545.0  \n",
       "31   38472769.0  \n",
       "32    4057847.0  \n",
       "33  228959599.0  \n",
       "34   11090425.0  \n",
       "35   97694960.0  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.fillna(method = 'ffill', axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "8cfe73d6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>state</th>\n",
       "      <th>confirmed</th>\n",
       "      <th>active</th>\n",
       "      <th>passive</th>\n",
       "      <th>deaths</th>\n",
       "      <th>dose1</th>\n",
       "      <th>dose2</th>\n",
       "      <th>dose3</th>\n",
       "      <th>precaution_dose</th>\n",
       "      <th>total_doses</th>\n",
       "      <th>population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Andaman and Nicobar</td>\n",
       "      <td>10742</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10612</td>\n",
       "      <td>129.0</td>\n",
       "      <td>313284.0</td>\n",
       "      <td>320383</td>\n",
       "      <td>236936.0</td>\n",
       "      <td>53427.0</td>\n",
       "      <td>991263</td>\n",
       "      <td>426251.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Andhra Pradesh</td>\n",
       "      <td>2339067</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2324331</td>\n",
       "      <td>14733.0</td>\n",
       "      <td>40643161.0</td>\n",
       "      <td>43549055</td>\n",
       "      <td>11703273.0</td>\n",
       "      <td>6579565.0</td>\n",
       "      <td>110556756</td>\n",
       "      <td>52883163.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Arunachal Pradesh</td>\n",
       "      <td>66890</td>\n",
       "      <td>NaN</td>\n",
       "      <td>66594</td>\n",
       "      <td>296.0</td>\n",
       "      <td>860442.0</td>\n",
       "      <td>747177</td>\n",
       "      <td>NaN</td>\n",
       "      <td>58618.0</td>\n",
       "      <td>1911760</td>\n",
       "      <td>1528296.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Assam</td>\n",
       "      <td>746100</td>\n",
       "      <td>0.0</td>\n",
       "      <td>738065</td>\n",
       "      <td>8035.0</td>\n",
       "      <td>22549957.0</td>\n",
       "      <td>20561790</td>\n",
       "      <td>2082670.0</td>\n",
       "      <td>1259853.0</td>\n",
       "      <td>50284713</td>\n",
       "      <td>34586234.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BIHAR</td>\n",
       "      <td>851379</td>\n",
       "      <td>15.0</td>\n",
       "      <td>839062</td>\n",
       "      <td>12302.0</td>\n",
       "      <td>62944633.0</td>\n",
       "      <td>59144387</td>\n",
       "      <td>11983504.0</td>\n",
       "      <td>3868082.0</td>\n",
       "      <td>157197041</td>\n",
       "      <td>119461013.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Chandigarh</td>\n",
       "      <td>99348</td>\n",
       "      <td>6.0</td>\n",
       "      <td>98161</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1089254.0</td>\n",
       "      <td>917701</td>\n",
       "      <td>48480.0</td>\n",
       "      <td>63046.0</td>\n",
       "      <td>2282281</td>\n",
       "      <td>1182104.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Chhattisgarh</td>\n",
       "      <td>1177749</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1163597</td>\n",
       "      <td>14146.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18534989</td>\n",
       "      <td>5737679.0</td>\n",
       "      <td>1804891.0</td>\n",
       "      <td>49148991</td>\n",
       "      <td>28566990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Dadra and Nagar Haveli and Daman and Diu</td>\n",
       "      <td>11591</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11587</td>\n",
       "      <td>4.0</td>\n",
       "      <td>730746.0</td>\n",
       "      <td>594929</td>\n",
       "      <td>136967.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1578492</td>\n",
       "      <td>657391.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Delhi</td>\n",
       "      <td>2007188</td>\n",
       "      <td>35.0</td>\n",
       "      <td>1980632</td>\n",
       "      <td>26521.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14348835</td>\n",
       "      <td>2312803.0</td>\n",
       "      <td>1053393.0</td>\n",
       "      <td>37366540</td>\n",
       "      <td>18802494.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>NaN</td>\n",
       "      <td>259079</td>\n",
       "      <td>26.0</td>\n",
       "      <td>255040</td>\n",
       "      <td>4013.0</td>\n",
       "      <td>1354828.0</td>\n",
       "      <td>1224173</td>\n",
       "      <td>60838.0</td>\n",
       "      <td>76559.0</td>\n",
       "      <td>2872582</td>\n",
       "      <td>1542750.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Gujarat</td>\n",
       "      <td>1277557</td>\n",
       "      <td>41.0</td>\n",
       "      <td>1266473</td>\n",
       "      <td>11043.0</td>\n",
       "      <td>49314588.0</td>\n",
       "      <td>49428283</td>\n",
       "      <td>13459618.0</td>\n",
       "      <td>5938121.0</td>\n",
       "      <td>127793995</td>\n",
       "      <td>63907200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Haryana</td>\n",
       "      <td>1056602</td>\n",
       "      <td>43.0</td>\n",
       "      <td>1045845</td>\n",
       "      <td>10714.0</td>\n",
       "      <td>21955717.0</td>\n",
       "      <td>18732346</td>\n",
       "      <td>NaN</td>\n",
       "      <td>701811.0</td>\n",
       "      <td>45457359</td>\n",
       "      <td>27388008.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Himachal Pradesh</td>\n",
       "      <td>312644</td>\n",
       "      <td>23.0</td>\n",
       "      <td>308408</td>\n",
       "      <td>4213.0</td>\n",
       "      <td>6041658.0</td>\n",
       "      <td>5780254</td>\n",
       "      <td>1485328.0</td>\n",
       "      <td>823689.0</td>\n",
       "      <td>15278680</td>\n",
       "      <td>7316708.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Jammu and Kashmir</td>\n",
       "      <td>479410</td>\n",
       "      <td>17.0</td>\n",
       "      <td>474608</td>\n",
       "      <td>4785.0</td>\n",
       "      <td>9941757.0</td>\n",
       "      <td>10386967</td>\n",
       "      <td>930096.0</td>\n",
       "      <td>669871.0</td>\n",
       "      <td>24738045</td>\n",
       "      <td>14046258.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Jharkhand</td>\n",
       "      <td>442570</td>\n",
       "      <td>NaN</td>\n",
       "      <td>437236</td>\n",
       "      <td>5331.0</td>\n",
       "      <td>21300448.0</td>\n",
       "      <td>16046070</td>\n",
       "      <td>1306687.0</td>\n",
       "      <td>664308.0</td>\n",
       "      <td>43689818</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Karnataka</td>\n",
       "      <td>4071893</td>\n",
       "      <td>1275.0</td>\n",
       "      <td>4030311</td>\n",
       "      <td>40307.0</td>\n",
       "      <td>50016690.0</td>\n",
       "      <td>50455767</td>\n",
       "      <td>5727031.0</td>\n",
       "      <td>4726542.0</td>\n",
       "      <td>120928298</td>\n",
       "      <td>66165886.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Kerala</td>\n",
       "      <td>6828245</td>\n",
       "      <td>1389.0</td>\n",
       "      <td>6755304</td>\n",
       "      <td>71552.0</td>\n",
       "      <td>27013745.0</td>\n",
       "      <td>23791879</td>\n",
       "      <td>854595.0</td>\n",
       "      <td>2215656.0</td>\n",
       "      <td>57477992</td>\n",
       "      <td>35330888.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Ladakh</td>\n",
       "      <td>29412</td>\n",
       "      <td>3.0</td>\n",
       "      <td>29178</td>\n",
       "      <td>231.0</td>\n",
       "      <td>219564.0</td>\n",
       "      <td>186942</td>\n",
       "      <td>68766.0</td>\n",
       "      <td>53990.0</td>\n",
       "      <td>564943</td>\n",
       "      <td>307204.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Lakshadweep</td>\n",
       "      <td>11415</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11363</td>\n",
       "      <td>52.0</td>\n",
       "      <td>56908.0</td>\n",
       "      <td>55992</td>\n",
       "      <td>15757.0</td>\n",
       "      <td>6949.0</td>\n",
       "      <td>145008</td>\n",
       "      <td>72210.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Madhya Pradesh</td>\n",
       "      <td>1054918</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1044138</td>\n",
       "      <td>10776.0</td>\n",
       "      <td>54140166.0</td>\n",
       "      <td>54035268</td>\n",
       "      <td>9854998.0</td>\n",
       "      <td>3787239.0</td>\n",
       "      <td>133590886</td>\n",
       "      <td>82342793.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Maharashtra</td>\n",
       "      <td>8136588</td>\n",
       "      <td>164.0</td>\n",
       "      <td>7988008</td>\n",
       "      <td>148416.0</td>\n",
       "      <td>84644083.0</td>\n",
       "      <td>71593498</td>\n",
       "      <td>5022623.0</td>\n",
       "      <td>4450343.0</td>\n",
       "      <td>177678317</td>\n",
       "      <td>120837347.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Manipur</td>\n",
       "      <td>139922</td>\n",
       "      <td>0.0</td>\n",
       "      <td>137773</td>\n",
       "      <td>2149.0</td>\n",
       "      <td>1463998.0</td>\n",
       "      <td>1225599</td>\n",
       "      <td>114004.0</td>\n",
       "      <td>165096.0</td>\n",
       "      <td>3265933</td>\n",
       "      <td>3008546.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Meghalaya</td>\n",
       "      <td>96783</td>\n",
       "      <td>1.0</td>\n",
       "      <td>95158</td>\n",
       "      <td>1624.0</td>\n",
       "      <td>1332102.0</td>\n",
       "      <td>1024902</td>\n",
       "      <td>30706.0</td>\n",
       "      <td>56987.0</td>\n",
       "      <td>2621058</td>\n",
       "      <td>3276323.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Mizoram</td>\n",
       "      <td>238964</td>\n",
       "      <td>0.0</td>\n",
       "      <td>238238</td>\n",
       "      <td>726.0</td>\n",
       "      <td>785749.0</td>\n",
       "      <td>668814</td>\n",
       "      <td>79573.0</td>\n",
       "      <td>67619.0</td>\n",
       "      <td>1790818</td>\n",
       "      <td>1205974.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Nagaland</td>\n",
       "      <td>35986</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35204</td>\n",
       "      <td>782.0</td>\n",
       "      <td>837775.0</td>\n",
       "      <td>684306</td>\n",
       "      <td>26060.0</td>\n",
       "      <td>43640.0</td>\n",
       "      <td>1737554</td>\n",
       "      <td>2189297.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Odisha</td>\n",
       "      <td>1336552</td>\n",
       "      <td>91.0</td>\n",
       "      <td>1327256</td>\n",
       "      <td>9205.0</td>\n",
       "      <td>31453659.0</td>\n",
       "      <td>29949756</td>\n",
       "      <td>9995330.0</td>\n",
       "      <td>3199384.0</td>\n",
       "      <td>81445474</td>\n",
       "      <td>45429399.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Puducherry</td>\n",
       "      <td>175508</td>\n",
       "      <td>5.0</td>\n",
       "      <td>173528</td>\n",
       "      <td>1975.0</td>\n",
       "      <td>912901.0</td>\n",
       "      <td>801853</td>\n",
       "      <td>303475.0</td>\n",
       "      <td>106956.0</td>\n",
       "      <td>2272617</td>\n",
       "      <td>1397707.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Punjab</td>\n",
       "      <td>784205</td>\n",
       "      <td>49.0</td>\n",
       "      <td>764867</td>\n",
       "      <td>19289.0</td>\n",
       "      <td>22352681.0</td>\n",
       "      <td>19602907</td>\n",
       "      <td>799986.0</td>\n",
       "      <td>1041039.0</td>\n",
       "      <td>46970300</td>\n",
       "      <td>29611935.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Rajasthan</td>\n",
       "      <td>1315455</td>\n",
       "      <td>88.0</td>\n",
       "      <td>1305714</td>\n",
       "      <td>9653.0</td>\n",
       "      <td>51103054.0</td>\n",
       "      <td>46510275</td>\n",
       "      <td>4387205.0</td>\n",
       "      <td>2995864.0</td>\n",
       "      <td>115325059</td>\n",
       "      <td>78230816.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Sikkim</td>\n",
       "      <td>44319</td>\n",
       "      <td>1.0</td>\n",
       "      <td>43819</td>\n",
       "      <td>499.0</td>\n",
       "      <td>539927.0</td>\n",
       "      <td>509134</td>\n",
       "      <td>158276.0</td>\n",
       "      <td>55637.0</td>\n",
       "      <td>1360444</td>\n",
       "      <td>671720.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Tamil Nadu</td>\n",
       "      <td>3594388</td>\n",
       "      <td>60.0</td>\n",
       "      <td>3556279</td>\n",
       "      <td>38049.0</td>\n",
       "      <td>56659544.0</td>\n",
       "      <td>53499923</td>\n",
       "      <td>6033504.0</td>\n",
       "      <td>3021694.0</td>\n",
       "      <td>127442647</td>\n",
       "      <td>76481545.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Telengana</td>\n",
       "      <td>841324</td>\n",
       "      <td>71.0</td>\n",
       "      <td>837142</td>\n",
       "      <td>4111.0</td>\n",
       "      <td>29607672.0</td>\n",
       "      <td>29053708</td>\n",
       "      <td>10525975.0</td>\n",
       "      <td>2702159.0</td>\n",
       "      <td>77201709</td>\n",
       "      <td>38472769.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Tripura</td>\n",
       "      <td>108034</td>\n",
       "      <td>0.0</td>\n",
       "      <td>107094</td>\n",
       "      <td>940.0</td>\n",
       "      <td>2658852.0</td>\n",
       "      <td>2328613</td>\n",
       "      <td>271434.0</td>\n",
       "      <td>204733.0</td>\n",
       "      <td>5916312</td>\n",
       "      <td>4057847.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Uttar Pradesh</td>\n",
       "      <td>2128103</td>\n",
       "      <td>46.0</td>\n",
       "      <td>2104424</td>\n",
       "      <td>23633.0</td>\n",
       "      <td>154058287.0</td>\n",
       "      <td>147716010</td>\n",
       "      <td>35623544.0</td>\n",
       "      <td>9240735.0</td>\n",
       "      <td>390639497</td>\n",
       "      <td>228959599.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Uttarakhand</td>\n",
       "      <td>449379</td>\n",
       "      <td>28.0</td>\n",
       "      <td>441600</td>\n",
       "      <td>7751.0</td>\n",
       "      <td>8180312.0</td>\n",
       "      <td>7940592</td>\n",
       "      <td>1346150.0</td>\n",
       "      <td>867047.0</td>\n",
       "      <td>20051714</td>\n",
       "      <td>11090425.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>West Bengal</td>\n",
       "      <td>2118606</td>\n",
       "      <td>58.0</td>\n",
       "      <td>2097016</td>\n",
       "      <td>21532.0</td>\n",
       "      <td>67300236.0</td>\n",
       "      <td>61593452</td>\n",
       "      <td>10257324.0</td>\n",
       "      <td>5491943.0</td>\n",
       "      <td>155962840</td>\n",
       "      <td>97694960.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       state  confirmed  active  passive  \\\n",
       "0                        Andaman and Nicobar      10742     1.0    10612   \n",
       "1                             Andhra Pradesh    2339067     3.0  2324331   \n",
       "2                          Arunachal Pradesh      66890     NaN    66594   \n",
       "3                                      Assam     746100     0.0   738065   \n",
       "4                                      BIHAR     851379    15.0   839062   \n",
       "5                                 Chandigarh      99348     6.0    98161   \n",
       "6                               Chhattisgarh    1177749     6.0  1163597   \n",
       "7   Dadra and Nagar Haveli and Daman and Diu      11591     0.0    11587   \n",
       "8                                      Delhi    2007188    35.0  1980632   \n",
       "9                                        NaN     259079    26.0   255040   \n",
       "10                                   Gujarat    1277557    41.0  1266473   \n",
       "11                                   Haryana    1056602    43.0  1045845   \n",
       "12                          Himachal Pradesh     312644    23.0   308408   \n",
       "13                         Jammu and Kashmir     479410    17.0   474608   \n",
       "14                                 Jharkhand     442570     NaN   437236   \n",
       "15                                 Karnataka    4071893  1275.0  4030311   \n",
       "16                                    Kerala    6828245  1389.0  6755304   \n",
       "17                                    Ladakh      29412     3.0    29178   \n",
       "18                               Lakshadweep      11415     0.0    11363   \n",
       "19                            Madhya Pradesh    1054918     4.0  1044138   \n",
       "20                               Maharashtra    8136588   164.0  7988008   \n",
       "21                                   Manipur     139922     0.0   137773   \n",
       "22                                 Meghalaya      96783     1.0    95158   \n",
       "23                                   Mizoram     238964     0.0   238238   \n",
       "24                                  Nagaland      35986     0.0    35204   \n",
       "25                                    Odisha    1336552    91.0  1327256   \n",
       "26                                Puducherry     175508     5.0   173528   \n",
       "27                                    Punjab     784205    49.0   764867   \n",
       "28                                 Rajasthan    1315455    88.0  1305714   \n",
       "29                                    Sikkim      44319     1.0    43819   \n",
       "30                                Tamil Nadu    3594388    60.0  3556279   \n",
       "31                                 Telengana     841324    71.0   837142   \n",
       "32                                   Tripura     108034     0.0   107094   \n",
       "33                             Uttar Pradesh    2128103    46.0  2104424   \n",
       "34                               Uttarakhand     449379    28.0   441600   \n",
       "35                               West Bengal    2118606    58.0  2097016   \n",
       "\n",
       "      deaths        dose1      dose2       dose3  precaution_dose  \\\n",
       "0      129.0     313284.0     320383    236936.0          53427.0   \n",
       "1    14733.0   40643161.0   43549055  11703273.0        6579565.0   \n",
       "2      296.0     860442.0     747177         NaN          58618.0   \n",
       "3     8035.0   22549957.0   20561790   2082670.0        1259853.0   \n",
       "4    12302.0   62944633.0   59144387  11983504.0        3868082.0   \n",
       "5        NaN    1089254.0     917701     48480.0          63046.0   \n",
       "6    14146.0          NaN   18534989   5737679.0        1804891.0   \n",
       "7        4.0     730746.0     594929    136967.0              NaN   \n",
       "8    26521.0          NaN   14348835   2312803.0        1053393.0   \n",
       "9     4013.0    1354828.0    1224173     60838.0          76559.0   \n",
       "10   11043.0   49314588.0   49428283  13459618.0        5938121.0   \n",
       "11   10714.0   21955717.0   18732346         NaN         701811.0   \n",
       "12    4213.0    6041658.0    5780254   1485328.0         823689.0   \n",
       "13    4785.0    9941757.0   10386967    930096.0         669871.0   \n",
       "14    5331.0   21300448.0   16046070   1306687.0         664308.0   \n",
       "15   40307.0   50016690.0   50455767   5727031.0        4726542.0   \n",
       "16   71552.0   27013745.0   23791879    854595.0        2215656.0   \n",
       "17     231.0     219564.0     186942     68766.0          53990.0   \n",
       "18      52.0      56908.0      55992     15757.0           6949.0   \n",
       "19   10776.0   54140166.0   54035268   9854998.0        3787239.0   \n",
       "20  148416.0   84644083.0   71593498   5022623.0        4450343.0   \n",
       "21    2149.0    1463998.0    1225599    114004.0         165096.0   \n",
       "22    1624.0    1332102.0    1024902     30706.0          56987.0   \n",
       "23     726.0     785749.0     668814     79573.0          67619.0   \n",
       "24     782.0     837775.0     684306     26060.0          43640.0   \n",
       "25    9205.0   31453659.0   29949756   9995330.0        3199384.0   \n",
       "26    1975.0     912901.0     801853    303475.0         106956.0   \n",
       "27   19289.0   22352681.0   19602907    799986.0        1041039.0   \n",
       "28    9653.0   51103054.0   46510275   4387205.0        2995864.0   \n",
       "29     499.0     539927.0     509134    158276.0          55637.0   \n",
       "30   38049.0   56659544.0   53499923   6033504.0        3021694.0   \n",
       "31    4111.0   29607672.0   29053708  10525975.0        2702159.0   \n",
       "32     940.0    2658852.0    2328613    271434.0         204733.0   \n",
       "33   23633.0  154058287.0  147716010  35623544.0        9240735.0   \n",
       "34    7751.0    8180312.0    7940592   1346150.0         867047.0   \n",
       "35   21532.0   67300236.0   61593452  10257324.0        5491943.0   \n",
       "\n",
       "    total_doses   population  \n",
       "0        991263     426251.0  \n",
       "1     110556756   52883163.0  \n",
       "2       1911760    1528296.0  \n",
       "3      50284713   34586234.0  \n",
       "4     157197041  119461013.0  \n",
       "5       2282281    1182104.0  \n",
       "6      49148991   28566990.0  \n",
       "7       1578492     657391.0  \n",
       "8      37366540   18802494.0  \n",
       "9       2872582    1542750.0  \n",
       "10    127793995   63907200.0  \n",
       "11     45457359   27388008.0  \n",
       "12     15278680    7316708.0  \n",
       "13     24738045   14046258.0  \n",
       "14     43689818          NaN  \n",
       "15    120928298   66165886.0  \n",
       "16     57477992   35330888.0  \n",
       "17       564943     307204.0  \n",
       "18       145008      72210.0  \n",
       "19    133590886   82342793.0  \n",
       "20    177678317  120837347.0  \n",
       "21      3265933    3008546.0  \n",
       "22      2621058    3276323.0  \n",
       "23      1790818    1205974.0  \n",
       "24      1737554    2189297.0  \n",
       "25     81445474   45429399.0  \n",
       "26      2272617    1397707.0  \n",
       "27     46970300   29611935.0  \n",
       "28    115325059   78230816.0  \n",
       "29      1360444     671720.0  \n",
       "30    127442647   76481545.0  \n",
       "31     77201709   38472769.0  \n",
       "32      5916312    4057847.0  \n",
       "33    390639497  228959599.0  \n",
       "34     20051714   11090425.0  \n",
       "35    155962840   97694960.0  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.replace(to_replace = 'Bihar', value = 'BIHAR')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "2c2d3dc3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>age</th>\n",
       "      <th>Address</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>soham</td>\n",
       "      <td>23</td>\n",
       "      <td>maninagar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>vishal</td>\n",
       "      <td>26</td>\n",
       "      <td>ghodasar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>vaibhavi</td>\n",
       "      <td>28</td>\n",
       "      <td>ab</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>shrusti</td>\n",
       "      <td>22</td>\n",
       "      <td>surat</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       name  age    Address\n",
       "0     soham   23  maninagar\n",
       "1    vishal   26   ghodasar\n",
       "2  vaibhavi   28         ab\n",
       "3   shrusti   22      surat"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fd = {\n",
    "    \"name\":[\"soham\",\"vishal\",\"vaibhavi\",\"shrusti\"],\n",
    "    \"age\" : [23,26,28,22],\n",
    "    \"Address\": [\"maninagar\",\"ghodasar\",\"ab\",\"surat\"]\n",
    "}\n",
    "\n",
    "sd = pd.DataFrame(fd)\n",
    "sd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "d47df7d1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>age</th>\n",
       "      <th>Address</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>soham</td>\n",
       "      <td>23</td>\n",
       "      <td>maninagar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>vishal</td>\n",
       "      <td>26</td>\n",
       "      <td>ghodasar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>vaibhavi</td>\n",
       "      <td>28</td>\n",
       "      <td>ab</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>shrusti</td>\n",
       "      <td>22</td>\n",
       "      <td>surat</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       name  age    Address\n",
       "0     soham   23  maninagar\n",
       "1    vishal   26   ghodasar\n",
       "2  vaibhavi   28         ab\n",
       "3   shrusti   22      surat"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fd1 = {\n",
    "    \"name\":[\"soham\",\"vishal\",\"vaibhavi\",\"shrusti\"],\n",
    "    \"age\" : [23,26,28,22],\n",
    "    \"Address\": [\"maninagar\",\"ghodasar\",\"ab\",\"surat\"]\n",
    "}\n",
    "\n",
    "sd1 = pd.DataFrame(fd1)\n",
    "sd1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "70565872",
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'concatnate' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m~\\AppData\\Local\\Temp\\ipykernel_14300\\3318130512.py\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mfdd2\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mconcatnate\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfd1\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0msd1\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m: name 'concatnate' is not defined"
     ]
    }
   ],
   "source": [
    "fdd2 = concatnate(fd1, sd1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "dee78f41",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}