nv_eco.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "pd?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.read_excel('sih-2019/data/2018/economic-aggregates/S1.7r.xlsx')\n",
    "years = data.iloc[5:6,2:-2]\n",
    "years"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "process = data[7:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 249,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "7       1\n",
       "8     1.1\n",
       "9     1.2\n",
       "10    1.3\n",
       "11    1.4\n",
       "12      2\n",
       "13      3\n",
       "14    3.1\n",
       "15    3.2\n",
       "16    3.3\n",
       "17    3.4\n",
       "18    3.5\n",
       "19      4\n",
       "20      5\n",
       "21      6\n",
       "22    6.1\n",
       "23    6.2\n",
       "24      7\n",
       "25    7.1\n",
       "26    7.2\n",
       "27    7.3\n",
       "28    7.4\n",
       "29    7.5\n",
       "30    7.6\n",
       "31    7.7\n",
       "32      8\n",
       "33      9\n",
       "34     10\n",
       "35     11\n",
       "36     12\n",
       "Name: Unnamed: 0, dtype: object"
      ]
     },
     "execution_count": 249,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sections = process.iloc[:,0]\n",
    "sections"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 215,
   "metadata": {},
   "outputs": [],
   "source": [
    "main_sections = [index for index in sections.index if sections[index].isdigit()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 216,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[7, 12, 13, 19, 20, 21, 24, 32, 33, 34, 35, 36]"
      ]
     },
     "execution_count": 216,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_sections"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 250,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1501947"
      ]
     },
     "execution_count": 250,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "[data.iloc[idx] for idx in main_sections][0].values[2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 218,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Unnamed: 2', 'Unnamed: 8']"
      ]
     },
     "execution_count": 218,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "[index for index in years.transpose().index if years[index].iloc[0] == '2011-12']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 222,
   "metadata": {},
   "outputs": [],
   "source": [
    "rows = [data.iloc[idx] for idx in main_sections]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 242,
   "metadata": {},
   "outputs": [],
   "source": [
    "values = [row['Unnamed: 2'] for row in rows[0:-1]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 243,
   "metadata": {},
   "outputs": [],
   "source": [
    "all_sum=sum(values)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 244,
   "metadata": {},
   "outputs": [],
   "source": [
    "values = [value/all_sum*100 for value in values]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 245,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[18.526668365621283,\n",
       " 3.2198931632207737,\n",
       " 17.392320116601244,\n",
       " 2.302568686161225,\n",
       " 9.58850595526355,\n",
       " 10.899073461202283,\n",
       " 6.531855522412509,\n",
       " 5.923636348385693,\n",
       " 12.95988649733204,\n",
       " 6.058446670299765]"
      ]
     },
     "execution_count": 245,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "values[0:-1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 247,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Agriculture, forestry and fishing',\n",
       " 'Mining and quarrying',\n",
       " 'Manufacturing',\n",
       " 'Electricity, gas, water supply & other utility services',\n",
       " 'Construction',\n",
       " 'Trade, repair, hotels and restaurants',\n",
       " 'Transport, storage, communication & services related to broadcasting',\n",
       " 'Financial services',\n",
       " 'Real estate, ownership of dwelling & professional services',\n",
       " 'Public administration and defence',\n",
       " 'Other services']"
      ]
     },
     "execution_count": 247,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "[row.iloc[-1] for row in rows[0:-1]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 251,
   "metadata": {
    "scrolled": true
   },
   "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>Unnamed: 0</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>Unnamed: 10</th>\n",
       "      <th>Unnamed: 11</th>\n",
       "      <th>Unnamed: 12</th>\n",
       "      <th>Unnamed: 13</th>\n",
       "      <th>Unnamed: 14</th>\n",
       "      <th>Unnamed: 15</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1</td>\n",
       "      <td>कृषि, वानिकी और मत्‍स्‍यन</td>\n",
       "      <td>1501947</td>\n",
       "      <td>1675107</td>\n",
       "      <td>1926372</td>\n",
       "      <td>2093612</td>\n",
       "      <td>2225368</td>\n",
       "      <td>2484005</td>\n",
       "      <td>1501947</td>\n",
       "      <td>1524288</td>\n",
       "      <td>1609198</td>\n",
       "      <td>1605715</td>\n",
       "      <td>1615216</td>\n",
       "      <td>1716746</td>\n",
       "      <td>1</td>\n",
       "      <td>Agriculture, forestry and fishing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1.1</td>\n",
       "      <td>फसलें</td>\n",
       "      <td>982151</td>\n",
       "      <td>1088814</td>\n",
       "      <td>1248776</td>\n",
       "      <td>1292874</td>\n",
       "      <td>1327997</td>\n",
       "      <td>1530137</td>\n",
       "      <td>982151</td>\n",
       "      <td>983809</td>\n",
       "      <td>1037060</td>\n",
       "      <td>998425</td>\n",
       "      <td>966345</td>\n",
       "      <td>1033008</td>\n",
       "      <td>1.1</td>\n",
       "      <td>crops</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1.2</td>\n",
       "      <td>पशुधन</td>\n",
       "      <td>327334</td>\n",
       "      <td>368823</td>\n",
       "      <td>422733</td>\n",
       "      <td>510411</td>\n",
       "      <td>584070</td>\n",
       "      <td>639912</td>\n",
       "      <td>327334</td>\n",
       "      <td>344375</td>\n",
       "      <td>363558</td>\n",
       "      <td>390449</td>\n",
       "      <td>421369</td>\n",
       "      <td>448964</td>\n",
       "      <td>1.2</td>\n",
       "      <td>livestock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1.3</td>\n",
       "      <td>वानिकी और लट्ठा बनाना</td>\n",
       "      <td>124436</td>\n",
       "      <td>137558</td>\n",
       "      <td>156674</td>\n",
       "      <td>173760</td>\n",
       "      <td>182247</td>\n",
       "      <td>180465</td>\n",
       "      <td>124436</td>\n",
       "      <td>124743</td>\n",
       "      <td>132093</td>\n",
       "      <td>134609</td>\n",
       "      <td>137022</td>\n",
       "      <td>138779</td>\n",
       "      <td>1.3</td>\n",
       "      <td>forestry and logging</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1.4</td>\n",
       "      <td>मत्‍स्‍यन और जलीय कृषि</td>\n",
       "      <td>68027</td>\n",
       "      <td>79911</td>\n",
       "      <td>98190</td>\n",
       "      <td>116567</td>\n",
       "      <td>131053</td>\n",
       "      <td>133492</td>\n",
       "      <td>68027</td>\n",
       "      <td>71362</td>\n",
       "      <td>76487</td>\n",
       "      <td>82232</td>\n",
       "      <td>90480</td>\n",
       "      <td>95996</td>\n",
       "      <td>1.4</td>\n",
       "      <td>fishing and aquaculture</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2</td>\n",
       "      <td>खनन और उत्खनन</td>\n",
       "      <td>261035</td>\n",
       "      <td>285842</td>\n",
       "      <td>295794</td>\n",
       "      <td>308476</td>\n",
       "      <td>301230</td>\n",
       "      <td>332947</td>\n",
       "      <td>261035</td>\n",
       "      <td>262609</td>\n",
       "      <td>263107</td>\n",
       "      <td>288685</td>\n",
       "      <td>328453</td>\n",
       "      <td>371066</td>\n",
       "      <td>2</td>\n",
       "      <td>Mining and quarrying</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>3</td>\n",
       "      <td>विनिर्माण</td>\n",
       "      <td>1409986</td>\n",
       "      <td>1572837</td>\n",
       "      <td>1713452</td>\n",
       "      <td>1878369</td>\n",
       "      <td>2116119</td>\n",
       "      <td>2329220</td>\n",
       "      <td>1409986</td>\n",
       "      <td>1486873</td>\n",
       "      <td>1560709</td>\n",
       "      <td>1683938</td>\n",
       "      <td>1898790</td>\n",
       "      <td>2048711</td>\n",
       "      <td>3</td>\n",
       "      <td>Manufacturing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>3.1</td>\n",
       "      <td>खाद्य उत्‍पाद,  पेय पदार्थ और तम्‍बाकू</td>\n",
       "      <td>167524</td>\n",
       "      <td>168227</td>\n",
       "      <td>175673</td>\n",
       "      <td>185899</td>\n",
       "      <td>204599</td>\n",
       "      <td>212347</td>\n",
       "      <td>167524</td>\n",
       "      <td>154540</td>\n",
       "      <td>153560</td>\n",
       "      <td>157637</td>\n",
       "      <td>168932</td>\n",
       "      <td>174619</td>\n",
       "      <td>3.1</td>\n",
       "      <td>Food Products, Beverages and Tobacco</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>3.2</td>\n",
       "      <td>वस्‍त्र, परिधान और चर्म उत्‍पाद</td>\n",
       "      <td>153238</td>\n",
       "      <td>187981</td>\n",
       "      <td>246424</td>\n",
       "      <td>249573</td>\n",
       "      <td>296145</td>\n",
       "      <td>315236</td>\n",
       "      <td>153238</td>\n",
       "      <td>177398</td>\n",
       "      <td>216411</td>\n",
       "      <td>216429</td>\n",
       "      <td>259680</td>\n",
       "      <td>274256</td>\n",
       "      <td>3.2</td>\n",
       "      <td>Textiles,  Apparel and Leather Products</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>3.3</td>\n",
       "      <td>मेटल उत्‍पाद</td>\n",
       "      <td>229627</td>\n",
       "      <td>248915</td>\n",
       "      <td>286998</td>\n",
       "      <td>273621</td>\n",
       "      <td>233751</td>\n",
       "      <td>251748</td>\n",
       "      <td>229627</td>\n",
       "      <td>238520</td>\n",
       "      <td>277322</td>\n",
       "      <td>261206</td>\n",
       "      <td>237485</td>\n",
       "      <td>263186</td>\n",
       "      <td>3.3</td>\n",
       "      <td>Metal Products</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>3.4</td>\n",
       "      <td>मशीनरी और उपकरण</td>\n",
       "      <td>334670</td>\n",
       "      <td>356231</td>\n",
       "      <td>343383</td>\n",
       "      <td>388961</td>\n",
       "      <td>502712</td>\n",
       "      <td>548807</td>\n",
       "      <td>334670</td>\n",
       "      <td>345731</td>\n",
       "      <td>324994</td>\n",
       "      <td>357017</td>\n",
       "      <td>415289</td>\n",
       "      <td>442382</td>\n",
       "      <td>3.4</td>\n",
       "      <td>Machinery and Equipment</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>3.5</td>\n",
       "      <td>अन्‍य विनिर्मित वस्तुएं</td>\n",
       "      <td>524927</td>\n",
       "      <td>611483</td>\n",
       "      <td>660973</td>\n",
       "      <td>780315</td>\n",
       "      <td>878912</td>\n",
       "      <td>1001081</td>\n",
       "      <td>524927</td>\n",
       "      <td>570684</td>\n",
       "      <td>588422</td>\n",
       "      <td>691649</td>\n",
       "      <td>817404</td>\n",
       "      <td>894267</td>\n",
       "      <td>3.5</td>\n",
       "      <td>Other Manufactured Goods</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>4</td>\n",
       "      <td>बिजली, गैस, जलापूर्ति और अन्य उपयोगी सेवाएं</td>\n",
       "      <td>186668</td>\n",
       "      <td>215350</td>\n",
       "      <td>260155</td>\n",
       "      <td>282258</td>\n",
       "      <td>336978</td>\n",
       "      <td>363482</td>\n",
       "      <td>186668</td>\n",
       "      <td>191635</td>\n",
       "      <td>199601</td>\n",
       "      <td>214047</td>\n",
       "      <td>224198</td>\n",
       "      <td>244934</td>\n",
       "      <td>4</td>\n",
       "      <td>Electricity, gas, water supply &amp; other utility...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>5</td>\n",
       "      <td>निर्माण</td>\n",
       "      <td>777335</td>\n",
       "      <td>849365</td>\n",
       "      <td>921470</td>\n",
       "      <td>979086</td>\n",
       "      <td>992298</td>\n",
       "      <td>1028463</td>\n",
       "      <td>777335</td>\n",
       "      <td>780050</td>\n",
       "      <td>800771</td>\n",
       "      <td>835229</td>\n",
       "      <td>866440</td>\n",
       "      <td>878110</td>\n",
       "      <td>5</td>\n",
       "      <td>Construction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>6</td>\n",
       "      <td>व्यापार, मरम्मत, होटल और जलपान गृह</td>\n",
       "      <td>883582</td>\n",
       "      <td>1054533</td>\n",
       "      <td>1184560</td>\n",
       "      <td>1320833</td>\n",
       "      <td>1431016</td>\n",
       "      <td>1586238</td>\n",
       "      <td>883582</td>\n",
       "      <td>981620</td>\n",
       "      <td>1034506</td>\n",
       "      <td>1135841</td>\n",
       "      <td>1259039</td>\n",
       "      <td>1370909</td>\n",
       "      <td>6</td>\n",
       "      <td>Trade, repair, hotels and restaurants</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>6.1</td>\n",
       "      <td>व्यापार और मरम्मत सेवाएँ</td>\n",
       "      <td>793681</td>\n",
       "      <td>954683</td>\n",
       "      <td>1078421</td>\n",
       "      <td>1206474</td>\n",
       "      <td>1304935</td>\n",
       "      <td>1446832</td>\n",
       "      <td>793681</td>\n",
       "      <td>888665</td>\n",
       "      <td>941941</td>\n",
       "      <td>1037640</td>\n",
       "      <td>1148216</td>\n",
       "      <td>1250502</td>\n",
       "      <td>6.1</td>\n",
       "      <td>Trade &amp; repair services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>6.2</td>\n",
       "      <td>होटल और रेस्तरां</td>\n",
       "      <td>89901</td>\n",
       "      <td>99850</td>\n",
       "      <td>106140</td>\n",
       "      <td>114359</td>\n",
       "      <td>126082</td>\n",
       "      <td>139406</td>\n",
       "      <td>89901</td>\n",
       "      <td>92955</td>\n",
       "      <td>92565</td>\n",
       "      <td>98201</td>\n",
       "      <td>110823</td>\n",
       "      <td>120407</td>\n",
       "      <td>6.2</td>\n",
       "      <td>Hotels &amp; restaurants</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>7</td>\n",
       "      <td>परिवहन, भंडारण, संचार एवं प्रसारण से संबंधित स...</td>\n",
       "      <td>529534</td>\n",
       "      <td>609453</td>\n",
       "      <td>689906</td>\n",
       "      <td>786763</td>\n",
       "      <td>872233</td>\n",
       "      <td>935575</td>\n",
       "      <td>529534</td>\n",
       "      <td>569523</td>\n",
       "      <td>617556</td>\n",
       "      <td>671848</td>\n",
       "      <td>734588</td>\n",
       "      <td>766193</td>\n",
       "      <td>7</td>\n",
       "      <td>Transport, storage, communication &amp; services r...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>7.1</td>\n",
       "      <td>रेलवे</td>\n",
       "      <td>61150</td>\n",
       "      <td>72296</td>\n",
       "      <td>78724</td>\n",
       "      <td>92459</td>\n",
       "      <td>100436</td>\n",
       "      <td>106582</td>\n",
       "      <td>61150</td>\n",
       "      <td>69162</td>\n",
       "      <td>73685</td>\n",
       "      <td>80720</td>\n",
       "      <td>85452</td>\n",
       "      <td>84594</td>\n",
       "      <td>7.1</td>\n",
       "      <td>Railways</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>7.2</td>\n",
       "      <td>सड़क परिवहन</td>\n",
       "      <td>262442</td>\n",
       "      <td>300652</td>\n",
       "      <td>338306</td>\n",
       "      <td>370364</td>\n",
       "      <td>399976</td>\n",
       "      <td>434588</td>\n",
       "      <td>262442</td>\n",
       "      <td>282425</td>\n",
       "      <td>300563</td>\n",
       "      <td>320813</td>\n",
       "      <td>342021</td>\n",
       "      <td>362077</td>\n",
       "      <td>7.2</td>\n",
       "      <td>Road transport</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>7.3</td>\n",
       "      <td>जल परिवहन</td>\n",
       "      <td>6910</td>\n",
       "      <td>7190</td>\n",
       "      <td>6476</td>\n",
       "      <td>7590</td>\n",
       "      <td>7354</td>\n",
       "      <td>6848</td>\n",
       "      <td>6910</td>\n",
       "      <td>7052</td>\n",
       "      <td>7345</td>\n",
       "      <td>7954</td>\n",
       "      <td>8100</td>\n",
       "      <td>8578</td>\n",
       "      <td>7.3</td>\n",
       "      <td>Water transport</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>7.4</td>\n",
       "      <td>वायु परिवहन</td>\n",
       "      <td>4393</td>\n",
       "      <td>8128</td>\n",
       "      <td>6853</td>\n",
       "      <td>11820</td>\n",
       "      <td>20350</td>\n",
       "      <td>20655</td>\n",
       "      <td>4393</td>\n",
       "      <td>4183</td>\n",
       "      <td>4550</td>\n",
       "      <td>5188</td>\n",
       "      <td>6053</td>\n",
       "      <td>7184</td>\n",
       "      <td>7.4</td>\n",
       "      <td>Air transport</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>7.5</td>\n",
       "      <td>परिवहन संबंधी प्रासंगिक सेवाएं</td>\n",
       "      <td>63602</td>\n",
       "      <td>72054</td>\n",
       "      <td>75719</td>\n",
       "      <td>91681</td>\n",
       "      <td>94139</td>\n",
       "      <td>103496</td>\n",
       "      <td>63602</td>\n",
       "      <td>66480</td>\n",
       "      <td>70172</td>\n",
       "      <td>75596</td>\n",
       "      <td>80683</td>\n",
       "      <td>86617</td>\n",
       "      <td>7.5</td>\n",
       "      <td>Services incidental to transport</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>7.6</td>\n",
       "      <td>भंडारण</td>\n",
       "      <td>5108</td>\n",
       "      <td>6165</td>\n",
       "      <td>6026</td>\n",
       "      <td>6407</td>\n",
       "      <td>6655</td>\n",
       "      <td>6888</td>\n",
       "      <td>5108</td>\n",
       "      <td>5716</td>\n",
       "      <td>5210</td>\n",
       "      <td>5529</td>\n",
       "      <td>6061</td>\n",
       "      <td>5869</td>\n",
       "      <td>7.6</td>\n",
       "      <td>Storage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>7.7</td>\n",
       "      <td>संचार एवं प्रसारण से संबंधित सेवाएं</td>\n",
       "      <td>125930</td>\n",
       "      <td>142969</td>\n",
       "      <td>177804</td>\n",
       "      <td>206442</td>\n",
       "      <td>243323</td>\n",
       "      <td>256518</td>\n",
       "      <td>125930</td>\n",
       "      <td>134505</td>\n",
       "      <td>156031</td>\n",
       "      <td>176047</td>\n",
       "      <td>206218</td>\n",
       "      <td>211274</td>\n",
       "      <td>7.7</td>\n",
       "      <td>Communication &amp; services related to broadcasting</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>8</td>\n",
       "      <td>वित्तीय सेवाएं</td>\n",
       "      <td>480226</td>\n",
       "      <td>536819</td>\n",
       "      <td>599341</td>\n",
       "      <td>661411</td>\n",
       "      <td>727254</td>\n",
       "      <td>742936</td>\n",
       "      <td>480226</td>\n",
       "      <td>529792</td>\n",
       "      <td>577914</td>\n",
       "      <td>627255</td>\n",
       "      <td>674022</td>\n",
       "      <td>682553</td>\n",
       "      <td>8</td>\n",
       "      <td>Financial services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>9</td>\n",
       "      <td>स्‍थावर सम्‍पदा, आवास का स्वामित्व और व्‍यावसा...</td>\n",
       "      <td>1050651</td>\n",
       "      <td>1239813</td>\n",
       "      <td>1470167</td>\n",
       "      <td>1701935</td>\n",
       "      <td>1904030</td>\n",
       "      <td>2114386</td>\n",
       "      <td>1050651</td>\n",
       "      <td>1150239</td>\n",
       "      <td>1289493</td>\n",
       "      <td>1446460</td>\n",
       "      <td>1625891</td>\n",
       "      <td>1755304</td>\n",
       "      <td>9</td>\n",
       "      <td>Real estate, ownership of dwelling &amp; professio...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>10</td>\n",
       "      <td>लोक प्रशासन और रक्षा</td>\n",
       "      <td>491155</td>\n",
       "      <td>546231</td>\n",
       "      <td>601912</td>\n",
       "      <td>676818</td>\n",
       "      <td>731640</td>\n",
       "      <td>859615</td>\n",
       "      <td>491155</td>\n",
       "      <td>501383</td>\n",
       "      <td>510046</td>\n",
       "      <td>543853</td>\n",
       "      <td>565019</td>\n",
       "      <td>637056</td>\n",
       "      <td>10</td>\n",
       "      <td>Public administration and defence</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>11</td>\n",
       "      <td>अन्य सेवाएं</td>\n",
       "      <td>534827</td>\n",
       "      <td>617343</td>\n",
       "      <td>700023</td>\n",
       "      <td>814718</td>\n",
       "      <td>928480</td>\n",
       "      <td>1064724</td>\n",
       "      <td>534827</td>\n",
       "      <td>568262</td>\n",
       "      <td>600748</td>\n",
       "      <td>659262</td>\n",
       "      <td>711692</td>\n",
       "      <td>776047</td>\n",
       "      <td>11</td>\n",
       "      <td>Other services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>12</td>\n",
       "      <td>बुनियादी मूल्यों पर सकल मूल्य वर्धन</td>\n",
       "      <td>8106946</td>\n",
       "      <td>9202692</td>\n",
       "      <td>10363153</td>\n",
       "      <td>11504279</td>\n",
       "      <td>12566646</td>\n",
       "      <td>13841591</td>\n",
       "      <td>8106946</td>\n",
       "      <td>8546275</td>\n",
       "      <td>9063649</td>\n",
       "      <td>9712133</td>\n",
       "      <td>10503348</td>\n",
       "      <td>11247629</td>\n",
       "      <td>12</td>\n",
       "      <td>TOTAL GVA at basic prices</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0                                         Unnamed: 1 Unnamed: 2  \\\n",
       "7           1                         कृषि, वानिकी और मत्‍स्‍यन     1501947   \n",
       "8         1.1                                              फसलें     982151   \n",
       "9         1.2                                             पशुधन      327334   \n",
       "10        1.3                             वानिकी और लट्ठा बनाना      124436   \n",
       "11        1.4                             मत्‍स्‍यन और जलीय कृषि      68027   \n",
       "12          2                                      खनन और उत्खनन     261035   \n",
       "13          3                                          विनिर्माण    1409986   \n",
       "14        3.1            खाद्य उत्‍पाद,  पेय पदार्थ और तम्‍बाकू      167524   \n",
       "15        3.2                   वस्‍त्र, परिधान और चर्म उत्‍पाद      153238   \n",
       "16        3.3                                      मेटल उत्‍पाद      229627   \n",
       "17        3.4                                   मशीनरी और उपकरण      334670   \n",
       "18        3.5                           अन्‍य विनिर्मित वस्तुएं      524927   \n",
       "19          4       बिजली, गैस, जलापूर्ति और अन्य उपयोगी सेवाएं      186668   \n",
       "20          5                                            निर्माण     777335   \n",
       "21          6                 व्यापार, मरम्मत, होटल और जलपान गृह     883582   \n",
       "22        6.1                           व्यापार और मरम्मत सेवाएँ     793681   \n",
       "23        6.2                                   होटल और रेस्तरां      89901   \n",
       "24          7  परिवहन, भंडारण, संचार एवं प्रसारण से संबंधित स...     529534   \n",
       "25        7.1                                              रेलवे      61150   \n",
       "26        7.2                                        सड़क परिवहन     262442   \n",
       "27        7.3                                          जल परिवहन       6910   \n",
       "28        7.4                                        वायु परिवहन       4393   \n",
       "29        7.5                    परिवहन संबंधी प्रासंगिक सेवाएं       63602   \n",
       "30        7.6                                             भंडारण       5108   \n",
       "31        7.7              संचार एवं प्रसारण से संबंधित सेवाएं       125930   \n",
       "32          8                                    वित्तीय सेवाएं      480226   \n",
       "33          9  स्‍थावर सम्‍पदा, आवास का स्वामित्व और व्‍यावसा...    1050651   \n",
       "34         10                               लोक प्रशासन और रक्षा     491155   \n",
       "35         11                                        अन्य सेवाएं     534827   \n",
       "36         12                बुनियादी मूल्यों पर सकल मूल्य वर्धन    8106946   \n",
       "\n",
       "   Unnamed: 3 Unnamed: 4 Unnamed: 5 Unnamed: 6 Unnamed: 7 Unnamed: 8  \\\n",
       "7     1675107    1926372    2093612    2225368    2484005    1501947   \n",
       "8     1088814    1248776    1292874    1327997    1530137     982151   \n",
       "9      368823     422733     510411     584070     639912     327334   \n",
       "10     137558     156674     173760     182247     180465     124436   \n",
       "11      79911      98190     116567     131053     133492      68027   \n",
       "12     285842     295794     308476     301230     332947     261035   \n",
       "13    1572837    1713452    1878369    2116119    2329220    1409986   \n",
       "14     168227     175673     185899     204599     212347     167524   \n",
       "15     187981     246424     249573     296145     315236     153238   \n",
       "16     248915     286998     273621     233751     251748     229627   \n",
       "17     356231     343383     388961     502712     548807     334670   \n",
       "18     611483     660973     780315     878912    1001081     524927   \n",
       "19     215350     260155     282258     336978     363482     186668   \n",
       "20     849365     921470     979086     992298    1028463     777335   \n",
       "21    1054533    1184560    1320833    1431016    1586238     883582   \n",
       "22     954683    1078421    1206474    1304935    1446832     793681   \n",
       "23      99850     106140     114359     126082     139406      89901   \n",
       "24     609453     689906     786763     872233     935575     529534   \n",
       "25      72296      78724      92459     100436     106582      61150   \n",
       "26     300652     338306     370364     399976     434588     262442   \n",
       "27       7190       6476       7590       7354       6848       6910   \n",
       "28       8128       6853      11820      20350      20655       4393   \n",
       "29      72054      75719      91681      94139     103496      63602   \n",
       "30       6165       6026       6407       6655       6888       5108   \n",
       "31     142969     177804     206442     243323     256518     125930   \n",
       "32     536819     599341     661411     727254     742936     480226   \n",
       "33    1239813    1470167    1701935    1904030    2114386    1050651   \n",
       "34     546231     601912     676818     731640     859615     491155   \n",
       "35     617343     700023     814718     928480    1064724     534827   \n",
       "36    9202692   10363153   11504279   12566646   13841591    8106946   \n",
       "\n",
       "   Unnamed: 9 Unnamed: 10 Unnamed: 11 Unnamed: 12 Unnamed: 13 Unnamed: 14  \\\n",
       "7     1524288     1609198     1605715     1615216     1716746           1   \n",
       "8      983809     1037060      998425      966345     1033008         1.1   \n",
       "9      344375      363558      390449      421369      448964         1.2   \n",
       "10     124743      132093      134609      137022      138779         1.3   \n",
       "11      71362       76487       82232       90480       95996         1.4   \n",
       "12     262609      263107      288685      328453      371066           2   \n",
       "13    1486873     1560709     1683938     1898790     2048711           3   \n",
       "14     154540      153560      157637      168932      174619         3.1   \n",
       "15     177398      216411      216429      259680      274256         3.2   \n",
       "16     238520      277322      261206      237485      263186         3.3   \n",
       "17     345731      324994      357017      415289      442382         3.4   \n",
       "18     570684      588422      691649      817404      894267         3.5   \n",
       "19     191635      199601      214047      224198      244934           4   \n",
       "20     780050      800771      835229      866440      878110           5   \n",
       "21     981620     1034506     1135841     1259039     1370909           6   \n",
       "22     888665      941941     1037640     1148216     1250502         6.1   \n",
       "23      92955       92565       98201      110823      120407         6.2   \n",
       "24     569523      617556      671848      734588      766193           7   \n",
       "25      69162       73685       80720       85452       84594         7.1   \n",
       "26     282425      300563      320813      342021      362077         7.2   \n",
       "27       7052        7345        7954        8100        8578         7.3   \n",
       "28       4183        4550        5188        6053        7184         7.4   \n",
       "29      66480       70172       75596       80683       86617         7.5   \n",
       "30       5716        5210        5529        6061        5869         7.6   \n",
       "31     134505      156031      176047      206218      211274         7.7   \n",
       "32     529792      577914      627255      674022      682553           8   \n",
       "33    1150239     1289493     1446460     1625891     1755304           9   \n",
       "34     501383      510046      543853      565019      637056          10   \n",
       "35     568262      600748      659262      711692      776047          11   \n",
       "36    8546275     9063649     9712133    10503348    11247629          12   \n",
       "\n",
       "                                          Unnamed: 15  \n",
       "7                   Agriculture, forestry and fishing  \n",
       "8                                               crops  \n",
       "9                                           livestock  \n",
       "10                               forestry and logging  \n",
       "11                            fishing and aquaculture  \n",
       "12                               Mining and quarrying  \n",
       "13                                      Manufacturing  \n",
       "14               Food Products, Beverages and Tobacco  \n",
       "15            Textiles,  Apparel and Leather Products  \n",
       "16                                     Metal Products  \n",
       "17                            Machinery and Equipment  \n",
       "18                           Other Manufactured Goods  \n",
       "19  Electricity, gas, water supply & other utility...  \n",
       "20                                       Construction  \n",
       "21              Trade, repair, hotels and restaurants  \n",
       "22                            Trade & repair services  \n",
       "23                               Hotels & restaurants  \n",
       "24  Transport, storage, communication & services r...  \n",
       "25                                           Railways  \n",
       "26                                     Road transport  \n",
       "27                                    Water transport  \n",
       "28                                      Air transport  \n",
       "29                   Services incidental to transport  \n",
       "30                                            Storage  \n",
       "31   Communication & services related to broadcasting  \n",
       "32                                 Financial services  \n",
       "33  Real estate, ownership of dwelling & professio...  \n",
       "34                  Public administration and defence  \n",
       "35                                     Other services  \n",
       "36                          TOTAL GVA at basic prices  "
      ]
     },
     "execution_count": 251,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "process\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 297,
   "metadata": {},
   "outputs": [],
   "source": [
    "filtered = [data.iloc[index] for index in sections.index if float(sections[index]) > 3 and float(sections[index]) < 4]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 300,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Food Products, Beverages and Tobacco',\n",
       " 'Textiles,  Apparel and Leather Products',\n",
       " 'Metal Products',\n",
       " 'Machinery and Equipment',\n",
       " 'Other Manufactured Goods']"
      ]
     },
     "execution_count": 300,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "[row.iloc[-1] for row in filtered]"
   ]
  },
  {
   "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
}