household.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>विवरण 5.2: परिवार और सामान्य सरकार द्वारा व्यक्तिगत उपभोग व्यय (` करोड़)</th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>Unnamed: 2</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>Unnamed: 5</th>\n",
       "      <th>Unnamed: 6</th>\n",
       "      <th>Unnamed: 7</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>...</th>\n",
       "      <th>Unnamed: 27</th>\n",
       "      <th>Unnamed: 28</th>\n",
       "      <th>Unnamed: 29</th>\n",
       "      <th>Unnamed: 30</th>\n",
       "      <th>Unnamed: 31</th>\n",
       "      <th>Unnamed: 32</th>\n",
       "      <th>Unnamed: 33</th>\n",
       "      <th>Unnamed: 34</th>\n",
       "      <th>Unnamed: 35</th>\n",
       "      <th>Unnamed: 36</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2011-12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 37 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  विवरण 5.2: परिवार और सामान्य सरकार द्वारा व्यक्तिगत उपभोग व्यय (` करोड़)  \\\n",
       "3                                                NaN                        \n",
       "\n",
       "  Unnamed: 1 Unnamed: 2 Unnamed: 3 Unnamed: 4 Unnamed: 5 Unnamed: 6  \\\n",
       "3        NaN    2011-12        NaN        NaN    2012-13        NaN   \n",
       "\n",
       "  Unnamed: 7 Unnamed: 8 Unnamed: 9  ... Unnamed: 27 Unnamed: 28 Unnamed: 29  \\\n",
       "3        NaN    2013-14        NaN  ...         NaN         NaN     2015-16   \n",
       "\n",
       "  Unnamed: 30 Unnamed: 31 Unnamed: 32 Unnamed: 33 Unnamed: 34 Unnamed: 35  \\\n",
       "3         NaN         NaN     2016-17         NaN         NaN         NaN   \n",
       "\n",
       "  Unnamed: 36  \n",
       "3         NaN  \n",
       "\n",
       "[1 rows x 37 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = pd.read_excel('data/2018/households/S5.2.xlsx')\n",
    "years = data.iloc[3:4]\n",
    "years"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>विवरण 5.2: परिवार और सामान्य सरकार द्वारा व्यक्तिगत उपभोग व्यय (` करोड़)</th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>Unnamed: 2</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>Unnamed: 5</th>\n",
       "      <th>Unnamed: 6</th>\n",
       "      <th>Unnamed: 7</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>...</th>\n",
       "      <th>Unnamed: 27</th>\n",
       "      <th>Unnamed: 28</th>\n",
       "      <th>Unnamed: 29</th>\n",
       "      <th>Unnamed: 30</th>\n",
       "      <th>Unnamed: 31</th>\n",
       "      <th>Unnamed: 32</th>\n",
       "      <th>Unnamed: 33</th>\n",
       "      <th>Unnamed: 34</th>\n",
       "      <th>Unnamed: 35</th>\n",
       "      <th>Unnamed: 36</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Statement 5.2: Individual Consumption Expendit...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>क्र. सं.</td>\n",
       "      <td>मद</td>\n",
       "      <td>प्रचलित भावों पर Current Prices</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>slno1</td>\n",
       "      <td>ItemName</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2011-12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>परिवारों का व्यक्तिगत उपभोग व्यय</td>\n",
       "      <td>सामान्य सरकार का व्यक्तिगत उपभोग व्यय</td>\n",
       "      <td>वास्तविक व्यक्तिगत उपभोग व्यय</td>\n",
       "      <td>परिवारों का व्यक्तिगत उपभोग व्यय</td>\n",
       "      <td>सामान्य सरकार का व्यक्तिगत उपभोग व्यय</td>\n",
       "      <td>वास्तविक व्यक्तिगत उपभोग व्यय</td>\n",
       "      <td>परिवारों का व्यक्तिगत उपभोग व्यय</td>\n",
       "      <td>सामान्य सरकार का व्यक्तिगत उपभोग व्यय</td>\n",
       "      <td>...</td>\n",
       "      <td>सामान्य सरकार का व्यक्तिगत उपभोग व्यय</td>\n",
       "      <td>वास्तविक व्यक्तिगत उपभोग व्यय</td>\n",
       "      <td>परिवारों का व्यक्तिगत उपभोग व्यय</td>\n",
       "      <td>सामान्य सरकार का व्यक्तिगत उपभोग व्यय</td>\n",
       "      <td>वास्तविक व्यक्तिगत उपभोग व्यय</td>\n",
       "      <td>परिवारों का व्यक्तिगत उपभोग व्यय</td>\n",
       "      <td>सामान्य सरकार का व्यक्तिगत उपभोग व्यय</td>\n",
       "      <td>वास्तविक व्यक्तिगत उपभोग व्यय</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Household individual consumption expenditure</td>\n",
       "      <td>General government individual consumption expe...</td>\n",
       "      <td>Actual individual consumption</td>\n",
       "      <td>Household individual consumption expenditure</td>\n",
       "      <td>General government individual consumption expe...</td>\n",
       "      <td>Actual individual consumption</td>\n",
       "      <td>Household individual consumption expenditure</td>\n",
       "      <td>General government individual consumption expe...</td>\n",
       "      <td>...</td>\n",
       "      <td>General government individual consumption expe...</td>\n",
       "      <td>Actual individual consumption</td>\n",
       "      <td>Household individual consumption expenditure</td>\n",
       "      <td>General government individual consumption expe...</td>\n",
       "      <td>Actual individual consumption</td>\n",
       "      <td>Household individual consumption expenditure</td>\n",
       "      <td>General government individual consumption expe...</td>\n",
       "      <td>Actual individual consumption</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1</td>\n",
       "      <td>खाद्य एवं गैर-एल्‍कोहलिक पेय पदार्थ</td>\n",
       "      <td>1499739</td>\n",
       "      <td>0</td>\n",
       "      <td>1499739</td>\n",
       "      <td>1750949</td>\n",
       "      <td>0</td>\n",
       "      <td>1750949</td>\n",
       "      <td>2060368</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1726037</td>\n",
       "      <td>1750052</td>\n",
       "      <td>0</td>\n",
       "      <td>1750052</td>\n",
       "      <td>1912153</td>\n",
       "      <td>0</td>\n",
       "      <td>1912153</td>\n",
       "      <td>1</td>\n",
       "      <td>Food and non-alcoholic beverages</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2</td>\n",
       "      <td>एल्‍कोहलिक पेय पदार्थ, तम्‍बाकु और स्‍वापक</td>\n",
       "      <td>137226</td>\n",
       "      <td>0</td>\n",
       "      <td>137226</td>\n",
       "      <td>142462</td>\n",
       "      <td>0</td>\n",
       "      <td>142462</td>\n",
       "      <td>157578</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>141540</td>\n",
       "      <td>144091</td>\n",
       "      <td>0</td>\n",
       "      <td>144091</td>\n",
       "      <td>134279</td>\n",
       "      <td>0</td>\n",
       "      <td>134279</td>\n",
       "      <td>2</td>\n",
       "      <td>Alcoholic beverages, tobacco and narcotics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3</td>\n",
       "      <td>वस्‍त्र तथा जूते</td>\n",
       "      <td>311547</td>\n",
       "      <td>0</td>\n",
       "      <td>311547</td>\n",
       "      <td>353906</td>\n",
       "      <td>0</td>\n",
       "      <td>353906</td>\n",
       "      <td>460752</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>385708</td>\n",
       "      <td>392294</td>\n",
       "      <td>0</td>\n",
       "      <td>392294</td>\n",
       "      <td>401263</td>\n",
       "      <td>0</td>\n",
       "      <td>401263</td>\n",
       "      <td>3</td>\n",
       "      <td>Clothing and footwear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>4</td>\n",
       "      <td>आवास, जल, बिजली, गैस और अन्‍य र्इंधन</td>\n",
       "      <td>807280</td>\n",
       "      <td>0</td>\n",
       "      <td>807280</td>\n",
       "      <td>926534</td>\n",
       "      <td>0</td>\n",
       "      <td>926534</td>\n",
       "      <td>1048004</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>952309</td>\n",
       "      <td>981417</td>\n",
       "      <td>0</td>\n",
       "      <td>981417</td>\n",
       "      <td>1010551</td>\n",
       "      <td>0</td>\n",
       "      <td>1010551</td>\n",
       "      <td>4</td>\n",
       "      <td>Housing, water, electricity, gas and other fuels</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>5</td>\n",
       "      <td>सामान, घरेलू उपकरण और दिनचर्या घर के रखरखाव</td>\n",
       "      <td>158414</td>\n",
       "      <td>0</td>\n",
       "      <td>158414</td>\n",
       "      <td>180127</td>\n",
       "      <td>0</td>\n",
       "      <td>180127</td>\n",
       "      <td>207553</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>198844</td>\n",
       "      <td>221336</td>\n",
       "      <td>0</td>\n",
       "      <td>221336</td>\n",
       "      <td>219556</td>\n",
       "      <td>0</td>\n",
       "      <td>219556</td>\n",
       "      <td>5</td>\n",
       "      <td>Furnishings, household equipment and routine h...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>6</td>\n",
       "      <td>स्‍वास्‍थ्‍य</td>\n",
       "      <td>181334</td>\n",
       "      <td>52073</td>\n",
       "      <td>233407</td>\n",
       "      <td>214348</td>\n",
       "      <td>58267</td>\n",
       "      <td>272615</td>\n",
       "      <td>248829</td>\n",
       "      <td>58771</td>\n",
       "      <td>...</td>\n",
       "      <td>56612</td>\n",
       "      <td>305055</td>\n",
       "      <td>273543</td>\n",
       "      <td>64497</td>\n",
       "      <td>338040</td>\n",
       "      <td>306560</td>\n",
       "      <td>73768</td>\n",
       "      <td>380328</td>\n",
       "      <td>6</td>\n",
       "      <td>Health</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>7</td>\n",
       "      <td>परिवहन</td>\n",
       "      <td>744691</td>\n",
       "      <td>0</td>\n",
       "      <td>744691</td>\n",
       "      <td>824901</td>\n",
       "      <td>0</td>\n",
       "      <td>824901</td>\n",
       "      <td>907412</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>856691</td>\n",
       "      <td>953552</td>\n",
       "      <td>0</td>\n",
       "      <td>953552</td>\n",
       "      <td>1056032</td>\n",
       "      <td>0</td>\n",
       "      <td>1056032</td>\n",
       "      <td>7</td>\n",
       "      <td>Transport</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>8</td>\n",
       "      <td>संचार</td>\n",
       "      <td>114138</td>\n",
       "      <td>0</td>\n",
       "      <td>114138</td>\n",
       "      <td>126680</td>\n",
       "      <td>0</td>\n",
       "      <td>126680</td>\n",
       "      <td>142173</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>154098</td>\n",
       "      <td>176115</td>\n",
       "      <td>0</td>\n",
       "      <td>176115</td>\n",
       "      <td>176735</td>\n",
       "      <td>0</td>\n",
       "      <td>176735</td>\n",
       "      <td>8</td>\n",
       "      <td>Communication</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>9</td>\n",
       "      <td>मनोविनोद और संस्‍कृति</td>\n",
       "      <td>50721</td>\n",
       "      <td>5930</td>\n",
       "      <td>56651</td>\n",
       "      <td>54517</td>\n",
       "      <td>6223</td>\n",
       "      <td>60740</td>\n",
       "      <td>60442</td>\n",
       "      <td>5945</td>\n",
       "      <td>...</td>\n",
       "      <td>5116</td>\n",
       "      <td>62679</td>\n",
       "      <td>54467</td>\n",
       "      <td>700</td>\n",
       "      <td>55167</td>\n",
       "      <td>54033</td>\n",
       "      <td>8137</td>\n",
       "      <td>62170</td>\n",
       "      <td>9</td>\n",
       "      <td>Recreation and culture</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>10</td>\n",
       "      <td>शिक्षा</td>\n",
       "      <td>182378</td>\n",
       "      <td>171545</td>\n",
       "      <td>353923</td>\n",
       "      <td>211470</td>\n",
       "      <td>193568</td>\n",
       "      <td>405038</td>\n",
       "      <td>240539</td>\n",
       "      <td>219398</td>\n",
       "      <td>...</td>\n",
       "      <td>182450</td>\n",
       "      <td>400530</td>\n",
       "      <td>239029</td>\n",
       "      <td>198640</td>\n",
       "      <td>437669</td>\n",
       "      <td>265188</td>\n",
       "      <td>214905</td>\n",
       "      <td>480093</td>\n",
       "      <td>10</td>\n",
       "      <td>Education</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>11</td>\n",
       "      <td>जलपान गृह और होटल</td>\n",
       "      <td>116491</td>\n",
       "      <td>0</td>\n",
       "      <td>116491</td>\n",
       "      <td>129318</td>\n",
       "      <td>0</td>\n",
       "      <td>129318</td>\n",
       "      <td>138559</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>128614</td>\n",
       "      <td>144010</td>\n",
       "      <td>0</td>\n",
       "      <td>144010</td>\n",
       "      <td>153945</td>\n",
       "      <td>0</td>\n",
       "      <td>153945</td>\n",
       "      <td>11</td>\n",
       "      <td>Restaurants and hotels</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>12</td>\n",
       "      <td>विविध वस्‍तुएं और सेवाएं</td>\n",
       "      <td>632039</td>\n",
       "      <td>36152</td>\n",
       "      <td>668191</td>\n",
       "      <td>735948</td>\n",
       "      <td>41997</td>\n",
       "      <td>777946</td>\n",
       "      <td>843777</td>\n",
       "      <td>45890</td>\n",
       "      <td>...</td>\n",
       "      <td>36810</td>\n",
       "      <td>911677</td>\n",
       "      <td>1063687</td>\n",
       "      <td>39241</td>\n",
       "      <td>1102928</td>\n",
       "      <td>1166590</td>\n",
       "      <td>45738</td>\n",
       "      <td>1212328</td>\n",
       "      <td>12</td>\n",
       "      <td>Miscellaneous goods and services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>NaN</td>\n",
       "      <td>कुल</td>\n",
       "      <td>4935996</td>\n",
       "      <td>265700</td>\n",
       "      <td>5201696</td>\n",
       "      <td>5651159</td>\n",
       "      <td>300055</td>\n",
       "      <td>5951214</td>\n",
       "      <td>6515986</td>\n",
       "      <td>330005</td>\n",
       "      <td>...</td>\n",
       "      <td>280988</td>\n",
       "      <td>6223783</td>\n",
       "      <td>6393593</td>\n",
       "      <td>303078</td>\n",
       "      <td>6696671</td>\n",
       "      <td>6856887</td>\n",
       "      <td>342548</td>\n",
       "      <td>7199435</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TOTAL</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>19 rows × 37 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   विवरण 5.2: परिवार और सामान्य सरकार द्वारा व्यक्तिगत उपभोग व्यय (` करोड़)  \\\n",
       "0   Statement 5.2: Individual Consumption Expendit...                        \n",
       "1                                                 NaN                        \n",
       "2                                            क्र. सं.                        \n",
       "3                                                 NaN                        \n",
       "4                                                 NaN                        \n",
       "5                                                 NaN                        \n",
       "6                                                   1                        \n",
       "7                                                   2                        \n",
       "8                                                   3                        \n",
       "9                                                   4                        \n",
       "10                                                  5                        \n",
       "11                                                  6                        \n",
       "12                                                  7                        \n",
       "13                                                  8                        \n",
       "14                                                  9                        \n",
       "15                                                 10                        \n",
       "16                                                 11                        \n",
       "17                                                 12                        \n",
       "18                                                NaN                        \n",
       "\n",
       "                                     Unnamed: 1  \\\n",
       "0                                           NaN   \n",
       "1                                           NaN   \n",
       "2                                            मद   \n",
       "3                                           NaN   \n",
       "4                                           NaN   \n",
       "5                                           NaN   \n",
       "6           खाद्य एवं गैर-एल्‍कोहलिक पेय पदार्थ   \n",
       "7    एल्‍कोहलिक पेय पदार्थ, तम्‍बाकु और स्‍वापक   \n",
       "8                              वस्‍त्र तथा जूते   \n",
       "9          आवास, जल, बिजली, गैस और अन्‍य र्इंधन   \n",
       "10  सामान, घरेलू उपकरण और दिनचर्या घर के रखरखाव   \n",
       "11                                 स्‍वास्‍थ्‍य   \n",
       "12                                       परिवहन   \n",
       "13                                        संचार   \n",
       "14                        मनोविनोद और संस्‍कृति   \n",
       "15                                       शिक्षा   \n",
       "16                            जलपान गृह और होटल   \n",
       "17                     विविध वस्‍तुएं और सेवाएं   \n",
       "18                                          कुल   \n",
       "\n",
       "                                      Unnamed: 2  \\\n",
       "0                                            NaN   \n",
       "1                                            NaN   \n",
       "2                प्रचलित भावों पर Current Prices   \n",
       "3                                        2011-12   \n",
       "4               परिवारों का व्यक्तिगत उपभोग व्यय   \n",
       "5   Household individual consumption expenditure   \n",
       "6                                        1499739   \n",
       "7                                         137226   \n",
       "8                                         311547   \n",
       "9                                         807280   \n",
       "10                                        158414   \n",
       "11                                        181334   \n",
       "12                                        744691   \n",
       "13                                        114138   \n",
       "14                                         50721   \n",
       "15                                        182378   \n",
       "16                                        116491   \n",
       "17                                        632039   \n",
       "18                                       4935996   \n",
       "\n",
       "                                           Unnamed: 3  \\\n",
       "0                                                 NaN   \n",
       "1                                                 NaN   \n",
       "2                                                 NaN   \n",
       "3                                                 NaN   \n",
       "4               सामान्य सरकार का व्यक्तिगत उपभोग व्यय   \n",
       "5   General government individual consumption expe...   \n",
       "6                                                   0   \n",
       "7                                                   0   \n",
       "8                                                   0   \n",
       "9                                                   0   \n",
       "10                                                  0   \n",
       "11                                              52073   \n",
       "12                                                  0   \n",
       "13                                                  0   \n",
       "14                                               5930   \n",
       "15                                             171545   \n",
       "16                                                  0   \n",
       "17                                              36152   \n",
       "18                                             265700   \n",
       "\n",
       "                       Unnamed: 4  \\\n",
       "0                             NaN   \n",
       "1                             NaN   \n",
       "2                             NaN   \n",
       "3                             NaN   \n",
       "4   वास्तविक व्यक्तिगत उपभोग व्यय   \n",
       "5   Actual individual consumption   \n",
       "6                         1499739   \n",
       "7                          137226   \n",
       "8                          311547   \n",
       "9                          807280   \n",
       "10                         158414   \n",
       "11                         233407   \n",
       "12                         744691   \n",
       "13                         114138   \n",
       "14                          56651   \n",
       "15                         353923   \n",
       "16                         116491   \n",
       "17                         668191   \n",
       "18                        5201696   \n",
       "\n",
       "                                      Unnamed: 5  \\\n",
       "0                                            NaN   \n",
       "1                                            NaN   \n",
       "2                                            NaN   \n",
       "3                                        2012-13   \n",
       "4               परिवारों का व्यक्तिगत उपभोग व्यय   \n",
       "5   Household individual consumption expenditure   \n",
       "6                                        1750949   \n",
       "7                                         142462   \n",
       "8                                         353906   \n",
       "9                                         926534   \n",
       "10                                        180127   \n",
       "11                                        214348   \n",
       "12                                        824901   \n",
       "13                                        126680   \n",
       "14                                         54517   \n",
       "15                                        211470   \n",
       "16                                        129318   \n",
       "17                                        735948   \n",
       "18                                       5651159   \n",
       "\n",
       "                                           Unnamed: 6  \\\n",
       "0                                                 NaN   \n",
       "1                                                 NaN   \n",
       "2                                                 NaN   \n",
       "3                                                 NaN   \n",
       "4               सामान्य सरकार का व्यक्तिगत उपभोग व्यय   \n",
       "5   General government individual consumption expe...   \n",
       "6                                                   0   \n",
       "7                                                   0   \n",
       "8                                                   0   \n",
       "9                                                   0   \n",
       "10                                                  0   \n",
       "11                                              58267   \n",
       "12                                                  0   \n",
       "13                                                  0   \n",
       "14                                               6223   \n",
       "15                                             193568   \n",
       "16                                                  0   \n",
       "17                                              41997   \n",
       "18                                             300055   \n",
       "\n",
       "                       Unnamed: 7  \\\n",
       "0                             NaN   \n",
       "1                             NaN   \n",
       "2                             NaN   \n",
       "3                             NaN   \n",
       "4   वास्तविक व्यक्तिगत उपभोग व्यय   \n",
       "5   Actual individual consumption   \n",
       "6                         1750949   \n",
       "7                          142462   \n",
       "8                          353906   \n",
       "9                          926534   \n",
       "10                         180127   \n",
       "11                         272615   \n",
       "12                         824901   \n",
       "13                         126680   \n",
       "14                          60740   \n",
       "15                         405038   \n",
       "16                         129318   \n",
       "17                         777946   \n",
       "18                        5951214   \n",
       "\n",
       "                                      Unnamed: 8  \\\n",
       "0                                            NaN   \n",
       "1                                            NaN   \n",
       "2                                            NaN   \n",
       "3                                        2013-14   \n",
       "4               परिवारों का व्यक्तिगत उपभोग व्यय   \n",
       "5   Household individual consumption expenditure   \n",
       "6                                        2060368   \n",
       "7                                         157578   \n",
       "8                                         460752   \n",
       "9                                        1048004   \n",
       "10                                        207553   \n",
       "11                                        248829   \n",
       "12                                        907412   \n",
       "13                                        142173   \n",
       "14                                         60442   \n",
       "15                                        240539   \n",
       "16                                        138559   \n",
       "17                                        843777   \n",
       "18                                       6515986   \n",
       "\n",
       "                                           Unnamed: 9  ...  \\\n",
       "0                                                 NaN  ...   \n",
       "1                                                 NaN  ...   \n",
       "2                                                 NaN  ...   \n",
       "3                                                 NaN  ...   \n",
       "4               सामान्य सरकार का व्यक्तिगत उपभोग व्यय  ...   \n",
       "5   General government individual consumption expe...  ...   \n",
       "6                                                   0  ...   \n",
       "7                                                   0  ...   \n",
       "8                                                   0  ...   \n",
       "9                                                   0  ...   \n",
       "10                                                  0  ...   \n",
       "11                                              58771  ...   \n",
       "12                                                  0  ...   \n",
       "13                                                  0  ...   \n",
       "14                                               5945  ...   \n",
       "15                                             219398  ...   \n",
       "16                                                  0  ...   \n",
       "17                                              45890  ...   \n",
       "18                                             330005  ...   \n",
       "\n",
       "                                          Unnamed: 27  \\\n",
       "0                                                 NaN   \n",
       "1                                                 NaN   \n",
       "2                                                 NaN   \n",
       "3                                                 NaN   \n",
       "4               सामान्य सरकार का व्यक्तिगत उपभोग व्यय   \n",
       "5   General government individual consumption expe...   \n",
       "6                                                   0   \n",
       "7                                                   0   \n",
       "8                                                   0   \n",
       "9                                                   0   \n",
       "10                                                  0   \n",
       "11                                              56612   \n",
       "12                                                  0   \n",
       "13                                                  0   \n",
       "14                                               5116   \n",
       "15                                             182450   \n",
       "16                                                  0   \n",
       "17                                              36810   \n",
       "18                                             280988   \n",
       "\n",
       "                      Unnamed: 28  \\\n",
       "0                             NaN   \n",
       "1                             NaN   \n",
       "2                             NaN   \n",
       "3                             NaN   \n",
       "4   वास्तविक व्यक्तिगत उपभोग व्यय   \n",
       "5   Actual individual consumption   \n",
       "6                         1726037   \n",
       "7                          141540   \n",
       "8                          385708   \n",
       "9                          952309   \n",
       "10                         198844   \n",
       "11                         305055   \n",
       "12                         856691   \n",
       "13                         154098   \n",
       "14                          62679   \n",
       "15                         400530   \n",
       "16                         128614   \n",
       "17                         911677   \n",
       "18                        6223783   \n",
       "\n",
       "                                     Unnamed: 29  \\\n",
       "0                                            NaN   \n",
       "1                                            NaN   \n",
       "2                                            NaN   \n",
       "3                                        2015-16   \n",
       "4               परिवारों का व्यक्तिगत उपभोग व्यय   \n",
       "5   Household individual consumption expenditure   \n",
       "6                                        1750052   \n",
       "7                                         144091   \n",
       "8                                         392294   \n",
       "9                                         981417   \n",
       "10                                        221336   \n",
       "11                                        273543   \n",
       "12                                        953552   \n",
       "13                                        176115   \n",
       "14                                         54467   \n",
       "15                                        239029   \n",
       "16                                        144010   \n",
       "17                                       1063687   \n",
       "18                                       6393593   \n",
       "\n",
       "                                          Unnamed: 30  \\\n",
       "0                                                 NaN   \n",
       "1                                                 NaN   \n",
       "2                                                 NaN   \n",
       "3                                                 NaN   \n",
       "4               सामान्य सरकार का व्यक्तिगत उपभोग व्यय   \n",
       "5   General government individual consumption expe...   \n",
       "6                                                   0   \n",
       "7                                                   0   \n",
       "8                                                   0   \n",
       "9                                                   0   \n",
       "10                                                  0   \n",
       "11                                              64497   \n",
       "12                                                  0   \n",
       "13                                                  0   \n",
       "14                                                700   \n",
       "15                                             198640   \n",
       "16                                                  0   \n",
       "17                                              39241   \n",
       "18                                             303078   \n",
       "\n",
       "                      Unnamed: 31  \\\n",
       "0                             NaN   \n",
       "1                             NaN   \n",
       "2                             NaN   \n",
       "3                             NaN   \n",
       "4   वास्तविक व्यक्तिगत उपभोग व्यय   \n",
       "5   Actual individual consumption   \n",
       "6                         1750052   \n",
       "7                          144091   \n",
       "8                          392294   \n",
       "9                          981417   \n",
       "10                         221336   \n",
       "11                         338040   \n",
       "12                         953552   \n",
       "13                         176115   \n",
       "14                          55167   \n",
       "15                         437669   \n",
       "16                         144010   \n",
       "17                        1102928   \n",
       "18                        6696671   \n",
       "\n",
       "                                     Unnamed: 32  \\\n",
       "0                                            NaN   \n",
       "1                                            NaN   \n",
       "2                                            NaN   \n",
       "3                                        2016-17   \n",
       "4               परिवारों का व्यक्तिगत उपभोग व्यय   \n",
       "5   Household individual consumption expenditure   \n",
       "6                                        1912153   \n",
       "7                                         134279   \n",
       "8                                         401263   \n",
       "9                                        1010551   \n",
       "10                                        219556   \n",
       "11                                        306560   \n",
       "12                                       1056032   \n",
       "13                                        176735   \n",
       "14                                         54033   \n",
       "15                                        265188   \n",
       "16                                        153945   \n",
       "17                                       1166590   \n",
       "18                                       6856887   \n",
       "\n",
       "                                          Unnamed: 33  \\\n",
       "0                                                 NaN   \n",
       "1                                                 NaN   \n",
       "2                                                 NaN   \n",
       "3                                                 NaN   \n",
       "4               सामान्य सरकार का व्यक्तिगत उपभोग व्यय   \n",
       "5   General government individual consumption expe...   \n",
       "6                                                   0   \n",
       "7                                                   0   \n",
       "8                                                   0   \n",
       "9                                                   0   \n",
       "10                                                  0   \n",
       "11                                              73768   \n",
       "12                                                  0   \n",
       "13                                                  0   \n",
       "14                                               8137   \n",
       "15                                             214905   \n",
       "16                                                  0   \n",
       "17                                              45738   \n",
       "18                                             342548   \n",
       "\n",
       "                      Unnamed: 34 Unnamed: 35  \\\n",
       "0                             NaN         NaN   \n",
       "1                             NaN         NaN   \n",
       "2                             NaN       slno1   \n",
       "3                             NaN         NaN   \n",
       "4   वास्तविक व्यक्तिगत उपभोग व्यय         NaN   \n",
       "5   Actual individual consumption         NaN   \n",
       "6                         1912153           1   \n",
       "7                          134279           2   \n",
       "8                          401263           3   \n",
       "9                         1010551           4   \n",
       "10                         219556           5   \n",
       "11                         380328           6   \n",
       "12                        1056032           7   \n",
       "13                         176735           8   \n",
       "14                          62170           9   \n",
       "15                         480093          10   \n",
       "16                         153945          11   \n",
       "17                        1212328          12   \n",
       "18                        7199435         NaN   \n",
       "\n",
       "                                          Unnamed: 36  \n",
       "0                                                 NaN  \n",
       "1                                                 NaN  \n",
       "2                                            ItemName  \n",
       "3                                                 NaN  \n",
       "4                                                 NaN  \n",
       "5                                                 NaN  \n",
       "6                    Food and non-alcoholic beverages  \n",
       "7          Alcoholic beverages, tobacco and narcotics  \n",
       "8                               Clothing and footwear  \n",
       "9    Housing, water, electricity, gas and other fuels  \n",
       "10  Furnishings, household equipment and routine h...  \n",
       "11                                             Health  \n",
       "12                                          Transport  \n",
       "13                                      Communication  \n",
       "14                             Recreation and culture  \n",
       "15                                          Education  \n",
       "16                             Restaurants and hotels  \n",
       "17                   Miscellaneous goods and services  \n",
       "18                                              TOTAL  \n",
       "\n",
       "[19 rows x 37 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>विवरण 5.2: परिवार और सामान्य सरकार द्वारा व्यक्तिगत उपभोग व्यय (` करोड़)</th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>Unnamed: 2</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>Unnamed: 5</th>\n",
       "      <th>Unnamed: 6</th>\n",
       "      <th>Unnamed: 7</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>...</th>\n",
       "      <th>Unnamed: 27</th>\n",
       "      <th>Unnamed: 28</th>\n",
       "      <th>Unnamed: 29</th>\n",
       "      <th>Unnamed: 30</th>\n",
       "      <th>Unnamed: 31</th>\n",
       "      <th>Unnamed: 32</th>\n",
       "      <th>Unnamed: 33</th>\n",
       "      <th>Unnamed: 34</th>\n",
       "      <th>Unnamed: 35</th>\n",
       "      <th>Unnamed: 36</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1</td>\n",
       "      <td>खाद्य एवं गैर-एल्‍कोहलिक पेय पदार्थ</td>\n",
       "      <td>1499739</td>\n",
       "      <td>0</td>\n",
       "      <td>1499739</td>\n",
       "      <td>1750949</td>\n",
       "      <td>0</td>\n",
       "      <td>1750949</td>\n",
       "      <td>2060368</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1726037</td>\n",
       "      <td>1750052</td>\n",
       "      <td>0</td>\n",
       "      <td>1750052</td>\n",
       "      <td>1912153</td>\n",
       "      <td>0</td>\n",
       "      <td>1912153</td>\n",
       "      <td>1</td>\n",
       "      <td>Food and non-alcoholic beverages</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2</td>\n",
       "      <td>एल्‍कोहलिक पेय पदार्थ, तम्‍बाकु और स्‍वापक</td>\n",
       "      <td>137226</td>\n",
       "      <td>0</td>\n",
       "      <td>137226</td>\n",
       "      <td>142462</td>\n",
       "      <td>0</td>\n",
       "      <td>142462</td>\n",
       "      <td>157578</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>141540</td>\n",
       "      <td>144091</td>\n",
       "      <td>0</td>\n",
       "      <td>144091</td>\n",
       "      <td>134279</td>\n",
       "      <td>0</td>\n",
       "      <td>134279</td>\n",
       "      <td>2</td>\n",
       "      <td>Alcoholic beverages, tobacco and narcotics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3</td>\n",
       "      <td>वस्‍त्र तथा जूते</td>\n",
       "      <td>311547</td>\n",
       "      <td>0</td>\n",
       "      <td>311547</td>\n",
       "      <td>353906</td>\n",
       "      <td>0</td>\n",
       "      <td>353906</td>\n",
       "      <td>460752</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>385708</td>\n",
       "      <td>392294</td>\n",
       "      <td>0</td>\n",
       "      <td>392294</td>\n",
       "      <td>401263</td>\n",
       "      <td>0</td>\n",
       "      <td>401263</td>\n",
       "      <td>3</td>\n",
       "      <td>Clothing and footwear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>4</td>\n",
       "      <td>आवास, जल, बिजली, गैस और अन्‍य र्इंधन</td>\n",
       "      <td>807280</td>\n",
       "      <td>0</td>\n",
       "      <td>807280</td>\n",
       "      <td>926534</td>\n",
       "      <td>0</td>\n",
       "      <td>926534</td>\n",
       "      <td>1048004</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>952309</td>\n",
       "      <td>981417</td>\n",
       "      <td>0</td>\n",
       "      <td>981417</td>\n",
       "      <td>1010551</td>\n",
       "      <td>0</td>\n",
       "      <td>1010551</td>\n",
       "      <td>4</td>\n",
       "      <td>Housing, water, electricity, gas and other fuels</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>5</td>\n",
       "      <td>सामान, घरेलू उपकरण और दिनचर्या घर के रखरखाव</td>\n",
       "      <td>158414</td>\n",
       "      <td>0</td>\n",
       "      <td>158414</td>\n",
       "      <td>180127</td>\n",
       "      <td>0</td>\n",
       "      <td>180127</td>\n",
       "      <td>207553</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>198844</td>\n",
       "      <td>221336</td>\n",
       "      <td>0</td>\n",
       "      <td>221336</td>\n",
       "      <td>219556</td>\n",
       "      <td>0</td>\n",
       "      <td>219556</td>\n",
       "      <td>5</td>\n",
       "      <td>Furnishings, household equipment and routine h...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>6</td>\n",
       "      <td>स्‍वास्‍थ्‍य</td>\n",
       "      <td>181334</td>\n",
       "      <td>52073</td>\n",
       "      <td>233407</td>\n",
       "      <td>214348</td>\n",
       "      <td>58267</td>\n",
       "      <td>272615</td>\n",
       "      <td>248829</td>\n",
       "      <td>58771</td>\n",
       "      <td>...</td>\n",
       "      <td>56612</td>\n",
       "      <td>305055</td>\n",
       "      <td>273543</td>\n",
       "      <td>64497</td>\n",
       "      <td>338040</td>\n",
       "      <td>306560</td>\n",
       "      <td>73768</td>\n",
       "      <td>380328</td>\n",
       "      <td>6</td>\n",
       "      <td>Health</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>7</td>\n",
       "      <td>परिवहन</td>\n",
       "      <td>744691</td>\n",
       "      <td>0</td>\n",
       "      <td>744691</td>\n",
       "      <td>824901</td>\n",
       "      <td>0</td>\n",
       "      <td>824901</td>\n",
       "      <td>907412</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>856691</td>\n",
       "      <td>953552</td>\n",
       "      <td>0</td>\n",
       "      <td>953552</td>\n",
       "      <td>1056032</td>\n",
       "      <td>0</td>\n",
       "      <td>1056032</td>\n",
       "      <td>7</td>\n",
       "      <td>Transport</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>8</td>\n",
       "      <td>संचार</td>\n",
       "      <td>114138</td>\n",
       "      <td>0</td>\n",
       "      <td>114138</td>\n",
       "      <td>126680</td>\n",
       "      <td>0</td>\n",
       "      <td>126680</td>\n",
       "      <td>142173</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>154098</td>\n",
       "      <td>176115</td>\n",
       "      <td>0</td>\n",
       "      <td>176115</td>\n",
       "      <td>176735</td>\n",
       "      <td>0</td>\n",
       "      <td>176735</td>\n",
       "      <td>8</td>\n",
       "      <td>Communication</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>9</td>\n",
       "      <td>मनोविनोद और संस्‍कृति</td>\n",
       "      <td>50721</td>\n",
       "      <td>5930</td>\n",
       "      <td>56651</td>\n",
       "      <td>54517</td>\n",
       "      <td>6223</td>\n",
       "      <td>60740</td>\n",
       "      <td>60442</td>\n",
       "      <td>5945</td>\n",
       "      <td>...</td>\n",
       "      <td>5116</td>\n",
       "      <td>62679</td>\n",
       "      <td>54467</td>\n",
       "      <td>700</td>\n",
       "      <td>55167</td>\n",
       "      <td>54033</td>\n",
       "      <td>8137</td>\n",
       "      <td>62170</td>\n",
       "      <td>9</td>\n",
       "      <td>Recreation and culture</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>10</td>\n",
       "      <td>शिक्षा</td>\n",
       "      <td>182378</td>\n",
       "      <td>171545</td>\n",
       "      <td>353923</td>\n",
       "      <td>211470</td>\n",
       "      <td>193568</td>\n",
       "      <td>405038</td>\n",
       "      <td>240539</td>\n",
       "      <td>219398</td>\n",
       "      <td>...</td>\n",
       "      <td>182450</td>\n",
       "      <td>400530</td>\n",
       "      <td>239029</td>\n",
       "      <td>198640</td>\n",
       "      <td>437669</td>\n",
       "      <td>265188</td>\n",
       "      <td>214905</td>\n",
       "      <td>480093</td>\n",
       "      <td>10</td>\n",
       "      <td>Education</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>11</td>\n",
       "      <td>जलपान गृह और होटल</td>\n",
       "      <td>116491</td>\n",
       "      <td>0</td>\n",
       "      <td>116491</td>\n",
       "      <td>129318</td>\n",
       "      <td>0</td>\n",
       "      <td>129318</td>\n",
       "      <td>138559</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>128614</td>\n",
       "      <td>144010</td>\n",
       "      <td>0</td>\n",
       "      <td>144010</td>\n",
       "      <td>153945</td>\n",
       "      <td>0</td>\n",
       "      <td>153945</td>\n",
       "      <td>11</td>\n",
       "      <td>Restaurants and hotels</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>12</td>\n",
       "      <td>विविध वस्‍तुएं और सेवाएं</td>\n",
       "      <td>632039</td>\n",
       "      <td>36152</td>\n",
       "      <td>668191</td>\n",
       "      <td>735948</td>\n",
       "      <td>41997</td>\n",
       "      <td>777946</td>\n",
       "      <td>843777</td>\n",
       "      <td>45890</td>\n",
       "      <td>...</td>\n",
       "      <td>36810</td>\n",
       "      <td>911677</td>\n",
       "      <td>1063687</td>\n",
       "      <td>39241</td>\n",
       "      <td>1102928</td>\n",
       "      <td>1166590</td>\n",
       "      <td>45738</td>\n",
       "      <td>1212328</td>\n",
       "      <td>12</td>\n",
       "      <td>Miscellaneous goods and services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>NaN</td>\n",
       "      <td>कुल</td>\n",
       "      <td>4935996</td>\n",
       "      <td>265700</td>\n",
       "      <td>5201696</td>\n",
       "      <td>5651159</td>\n",
       "      <td>300055</td>\n",
       "      <td>5951214</td>\n",
       "      <td>6515986</td>\n",
       "      <td>330005</td>\n",
       "      <td>...</td>\n",
       "      <td>280988</td>\n",
       "      <td>6223783</td>\n",
       "      <td>6393593</td>\n",
       "      <td>303078</td>\n",
       "      <td>6696671</td>\n",
       "      <td>6856887</td>\n",
       "      <td>342548</td>\n",
       "      <td>7199435</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TOTAL</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>13 rows × 37 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   विवरण 5.2: परिवार और सामान्य सरकार द्वारा व्यक्तिगत उपभोग व्यय (` करोड़)  \\\n",
       "6                                                   1                        \n",
       "7                                                   2                        \n",
       "8                                                   3                        \n",
       "9                                                   4                        \n",
       "10                                                  5                        \n",
       "11                                                  6                        \n",
       "12                                                  7                        \n",
       "13                                                  8                        \n",
       "14                                                  9                        \n",
       "15                                                 10                        \n",
       "16                                                 11                        \n",
       "17                                                 12                        \n",
       "18                                                NaN                        \n",
       "\n",
       "                                     Unnamed: 1 Unnamed: 2 Unnamed: 3  \\\n",
       "6           खाद्य एवं गैर-एल्‍कोहलिक पेय पदार्थ    1499739          0   \n",
       "7    एल्‍कोहलिक पेय पदार्थ, तम्‍बाकु और स्‍वापक     137226          0   \n",
       "8                              वस्‍त्र तथा जूते     311547          0   \n",
       "9          आवास, जल, बिजली, गैस और अन्‍य र्इंधन     807280          0   \n",
       "10  सामान, घरेलू उपकरण और दिनचर्या घर के रखरखाव     158414          0   \n",
       "11                                 स्‍वास्‍थ्‍य     181334      52073   \n",
       "12                                       परिवहन     744691          0   \n",
       "13                                        संचार     114138          0   \n",
       "14                        मनोविनोद और संस्‍कृति      50721       5930   \n",
       "15                                       शिक्षा     182378     171545   \n",
       "16                            जलपान गृह और होटल     116491          0   \n",
       "17                     विविध वस्‍तुएं और सेवाएं     632039      36152   \n",
       "18                                          कुल    4935996     265700   \n",
       "\n",
       "   Unnamed: 4 Unnamed: 5 Unnamed: 6 Unnamed: 7 Unnamed: 8 Unnamed: 9  ...  \\\n",
       "6     1499739    1750949          0    1750949    2060368          0  ...   \n",
       "7      137226     142462          0     142462     157578          0  ...   \n",
       "8      311547     353906          0     353906     460752          0  ...   \n",
       "9      807280     926534          0     926534    1048004          0  ...   \n",
       "10     158414     180127          0     180127     207553          0  ...   \n",
       "11     233407     214348      58267     272615     248829      58771  ...   \n",
       "12     744691     824901          0     824901     907412          0  ...   \n",
       "13     114138     126680          0     126680     142173          0  ...   \n",
       "14      56651      54517       6223      60740      60442       5945  ...   \n",
       "15     353923     211470     193568     405038     240539     219398  ...   \n",
       "16     116491     129318          0     129318     138559          0  ...   \n",
       "17     668191     735948      41997     777946     843777      45890  ...   \n",
       "18    5201696    5651159     300055    5951214    6515986     330005  ...   \n",
       "\n",
       "   Unnamed: 27 Unnamed: 28 Unnamed: 29 Unnamed: 30 Unnamed: 31 Unnamed: 32  \\\n",
       "6            0     1726037     1750052           0     1750052     1912153   \n",
       "7            0      141540      144091           0      144091      134279   \n",
       "8            0      385708      392294           0      392294      401263   \n",
       "9            0      952309      981417           0      981417     1010551   \n",
       "10           0      198844      221336           0      221336      219556   \n",
       "11       56612      305055      273543       64497      338040      306560   \n",
       "12           0      856691      953552           0      953552     1056032   \n",
       "13           0      154098      176115           0      176115      176735   \n",
       "14        5116       62679       54467         700       55167       54033   \n",
       "15      182450      400530      239029      198640      437669      265188   \n",
       "16           0      128614      144010           0      144010      153945   \n",
       "17       36810      911677     1063687       39241     1102928     1166590   \n",
       "18      280988     6223783     6393593      303078     6696671     6856887   \n",
       "\n",
       "   Unnamed: 33 Unnamed: 34 Unnamed: 35  \\\n",
       "6            0     1912153           1   \n",
       "7            0      134279           2   \n",
       "8            0      401263           3   \n",
       "9            0     1010551           4   \n",
       "10           0      219556           5   \n",
       "11       73768      380328           6   \n",
       "12           0     1056032           7   \n",
       "13           0      176735           8   \n",
       "14        8137       62170           9   \n",
       "15      214905      480093          10   \n",
       "16           0      153945          11   \n",
       "17       45738     1212328          12   \n",
       "18      342548     7199435         NaN   \n",
       "\n",
       "                                          Unnamed: 36  \n",
       "6                    Food and non-alcoholic beverages  \n",
       "7          Alcoholic beverages, tobacco and narcotics  \n",
       "8                               Clothing and footwear  \n",
       "9    Housing, water, electricity, gas and other fuels  \n",
       "10  Furnishings, household equipment and routine h...  \n",
       "11                                             Health  \n",
       "12                                          Transport  \n",
       "13                                      Communication  \n",
       "14                             Recreation and culture  \n",
       "15                                          Education  \n",
       "16                             Restaurants and hotels  \n",
       "17                   Miscellaneous goods and services  \n",
       "18                                              TOTAL  \n",
       "\n",
       "[13 rows x 37 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "process = data[6:]\n",
    "process"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['1', 'खाद्य एवं गैर-एल्\\u200dकोहलिक पेय पदार्थ', 1499739, 0,\n",
       "       1499739, 1750949, 0, 1750949, 2060368, 0, 2060368, 2250584, 0,\n",
       "       2250584, 2365895, 0, 2365895, 1499739, 0, 1499739, 1590262, 0,\n",
       "       1590262, 1705929, 0, 1705929, 1726037, 0, 1726037, 1750052, 0,\n",
       "       1750052, 1912153, 0, 1912153, '1',\n",
       "       'Food and non-alcoholic beverages'], dtype=object)"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "process.iloc[0].values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "labels = process.iloc[:, -1]\n",
    "selected = labels.iloc[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Unnamed: 2          Household individual consumption expenditure\n",
       "Unnamed: 3     General government individual consumption expe...\n",
       "Unnamed: 4                         Actual individual consumption\n",
       "Unnamed: 5          Household individual consumption expenditure\n",
       "Unnamed: 6     General government individual consumption expe...\n",
       "Unnamed: 7                         Actual individual consumption\n",
       "Unnamed: 8          Household individual consumption expenditure\n",
       "Unnamed: 9     General government individual consumption expe...\n",
       "Unnamed: 10                        Actual individual consumption\n",
       "Unnamed: 11         Household individual consumption expenditure\n",
       "Unnamed: 12    General government individual consumption expe...\n",
       "Unnamed: 13                        Actual individual consumption\n",
       "Unnamed: 14         Household individual consumption expenditure\n",
       "Unnamed: 15    General government individual consumption expe...\n",
       "Unnamed: 16                        Actual individual consumption\n",
       "Unnamed: 17         Household individual consumption expenditure\n",
       "Unnamed: 18    General government individual consumption expe...\n",
       "Unnamed: 19                        Actual individual consumption\n",
       "Unnamed: 20         Household individual consumption expenditure\n",
       "Unnamed: 21    General government individual consumption expe...\n",
       "Unnamed: 22                        Actual individual consumption\n",
       "Unnamed: 23         Household individual consumption expenditure\n",
       "Unnamed: 24    General government individual consumption expe...\n",
       "Unnamed: 25                        Actual individual consumption\n",
       "Unnamed: 26         Household individual consumption expenditure\n",
       "Unnamed: 27    General government individual consumption expe...\n",
       "Unnamed: 28                        Actual individual consumption\n",
       "Unnamed: 29         Household individual consumption expenditure\n",
       "Unnamed: 30    General government individual consumption expe...\n",
       "Unnamed: 31                        Actual individual consumption\n",
       "Unnamed: 32         Household individual consumption expenditure\n",
       "Unnamed: 33    General government individual consumption expe...\n",
       "Unnamed: 34                        Actual individual consumption\n",
       "Name: 5, dtype: object"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "headers = data.iloc[5][2:-2]\n",
    "headers"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Food and non-alcoholic beverages'"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "selected"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([1499739, 0, 1499739, 1750949, 0, 1750949, 2060368, 0, 2060368,\n",
       "       2250584, 0, 2250584, 2365895, 0, 2365895, 1499739, 0, 1499739,\n",
       "       1590262, 0, 1590262, 1705929, 0, 1705929, 1726037, 0, 1726037,\n",
       "       1750052, 0, 1750052, 1912153, 0, 1912153], dtype=object)"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "row = process.iloc[0][2:-2].values\n",
    "row"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "'RangeIndex' object has no attribute 'value'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-11-82c9f4195151>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mlabels\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mindex\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mvalue\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;31mAttributeError\u001b[0m: 'RangeIndex' object has no attribute 'value'"
     ]
    }
   ],
   "source": [
    "labels.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "6                      Food and non-alcoholic beverages\n",
       "7            Alcoholic beverages, tobacco and narcotics\n",
       "8                                 Clothing and footwear\n",
       "9      Housing, water, electricity, gas and other fuels\n",
       "10    Furnishings, household equipment and routine h...\n",
       "11                                               Health\n",
       "12                                            Transport\n",
       "13                                        Communication\n",
       "14                               Recreation and culture\n",
       "15                                            Education\n",
       "16                               Restaurants and hotels\n",
       "17                     Miscellaneous goods and services\n",
       "18                                                TOTAL\n",
       "Name: Unnamed: 36, dtype: object"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sections = process.iloc[:, -1]\n",
    "sections"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}