disaggregated.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "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>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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Unnamed: 2 Unnamed: 3 Unnamed: 4 Unnamed: 5 Unnamed: 6 Unnamed: 7  \\\n",
       "5          3          4          5          6          7          8   \n",
       "\n",
       "  Unnamed: 8 Unnamed: 9 Unnamed: 10 Unnamed: 11 Unnamed: 12 Unnamed: 13  \n",
       "5          9         10          11          12          13          14  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = pd.read_excel('data/2018/disaggregated-statements/S8.1.2.xlsx')\n",
    "years = data.iloc[5:6,2:-2]\n",
    "years"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "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>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.1</td>\n",
       "      <td>धान</td>\n",
       "      <td>170595</td>\n",
       "      <td>198266</td>\n",
       "      <td>220635</td>\n",
       "      <td>226644</td>\n",
       "      <td>228079</td>\n",
       "      <td>253902</td>\n",
       "      <td>170595</td>\n",
       "      <td>169773</td>\n",
       "      <td>172144</td>\n",
       "      <td>170272</td>\n",
       "      <td>168028</td>\n",
       "      <td>177655</td>\n",
       "      <td>1.1</td>\n",
       "      <td>paddy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1.2</td>\n",
       "      <td>गेहूँ</td>\n",
       "      <td>118068</td>\n",
       "      <td>131710</td>\n",
       "      <td>142561</td>\n",
       "      <td>129011</td>\n",
       "      <td>145939</td>\n",
       "      <td>165304</td>\n",
       "      <td>118068</td>\n",
       "      <td>115884</td>\n",
       "      <td>119051</td>\n",
       "      <td>107828</td>\n",
       "      <td>114880</td>\n",
       "      <td>122307</td>\n",
       "      <td>1.2</td>\n",
       "      <td>wheat</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1.3</td>\n",
       "      <td>ज्वार</td>\n",
       "      <td>9807</td>\n",
       "      <td>8133</td>\n",
       "      <td>9073</td>\n",
       "      <td>9917</td>\n",
       "      <td>7812</td>\n",
       "      <td>9203</td>\n",
       "      <td>9807</td>\n",
       "      <td>8540</td>\n",
       "      <td>9144</td>\n",
       "      <td>8839</td>\n",
       "      <td>6769</td>\n",
       "      <td>7296</td>\n",
       "      <td>1.3</td>\n",
       "      <td>jowar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1.4</td>\n",
       "      <td>बाजरा</td>\n",
       "      <td>9940</td>\n",
       "      <td>10858</td>\n",
       "      <td>11807</td>\n",
       "      <td>11345</td>\n",
       "      <td>11296</td>\n",
       "      <td>15901</td>\n",
       "      <td>9940</td>\n",
       "      <td>8309</td>\n",
       "      <td>8949</td>\n",
       "      <td>8678</td>\n",
       "      <td>7645</td>\n",
       "      <td>9284</td>\n",
       "      <td>1.4</td>\n",
       "      <td>bajra</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1.5</td>\n",
       "      <td>जौ</td>\n",
       "      <td>1901</td>\n",
       "      <td>2133</td>\n",
       "      <td>2254</td>\n",
       "      <td>2049</td>\n",
       "      <td>2098</td>\n",
       "      <td>3047</td>\n",
       "      <td>1901</td>\n",
       "      <td>2075</td>\n",
       "      <td>2164</td>\n",
       "      <td>1916</td>\n",
       "      <td>1677</td>\n",
       "      <td>2027</td>\n",
       "      <td>1.5</td>\n",
       "      <td>barley</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1.6</td>\n",
       "      <td>मक्का</td>\n",
       "      <td>23539</td>\n",
       "      <td>27952</td>\n",
       "      <td>31875</td>\n",
       "      <td>31182</td>\n",
       "      <td>33095</td>\n",
       "      <td>42034</td>\n",
       "      <td>23539</td>\n",
       "      <td>23742</td>\n",
       "      <td>26049</td>\n",
       "      <td>25844</td>\n",
       "      <td>24240</td>\n",
       "      <td>28203</td>\n",
       "      <td>1.6</td>\n",
       "      <td>maize</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1.7</td>\n",
       "      <td>रागी</td>\n",
       "      <td>2015</td>\n",
       "      <td>2455</td>\n",
       "      <td>3382</td>\n",
       "      <td>3438</td>\n",
       "      <td>3040</td>\n",
       "      <td>2884</td>\n",
       "      <td>2015</td>\n",
       "      <td>1651</td>\n",
       "      <td>2102</td>\n",
       "      <td>2160</td>\n",
       "      <td>1899</td>\n",
       "      <td>1461</td>\n",
       "      <td>1.7</td>\n",
       "      <td>ragi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1.8</td>\n",
       "      <td>छोटा बाजरा</td>\n",
       "      <td>413</td>\n",
       "      <td>427</td>\n",
       "      <td>467</td>\n",
       "      <td>429</td>\n",
       "      <td>424</td>\n",
       "      <td>563</td>\n",
       "      <td>413</td>\n",
       "      <td>399</td>\n",
       "      <td>374</td>\n",
       "      <td>349</td>\n",
       "      <td>315</td>\n",
       "      <td>339</td>\n",
       "      <td>1.8</td>\n",
       "      <td>small millets</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1.9</td>\n",
       "      <td>अन्य अनाज</td>\n",
       "      <td>81</td>\n",
       "      <td>106</td>\n",
       "      <td>73</td>\n",
       "      <td>68</td>\n",
       "      <td>71</td>\n",
       "      <td>87</td>\n",
       "      <td>81</td>\n",
       "      <td>91</td>\n",
       "      <td>57</td>\n",
       "      <td>51</td>\n",
       "      <td>52</td>\n",
       "      <td>51</td>\n",
       "      <td>1.9</td>\n",
       "      <td>other cereals</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2</td>\n",
       "      <td>दालें</td>\n",
       "      <td>52151</td>\n",
       "      <td>62394</td>\n",
       "      <td>68129</td>\n",
       "      <td>72966</td>\n",
       "      <td>94869</td>\n",
       "      <td>159862</td>\n",
       "      <td>52151</td>\n",
       "      <td>55032</td>\n",
       "      <td>58138</td>\n",
       "      <td>51624</td>\n",
       "      <td>49023</td>\n",
       "      <td>69564</td>\n",
       "      <td>2</td>\n",
       "      <td>pulses</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2.1</td>\n",
       "      <td>चना</td>\n",
       "      <td>21781</td>\n",
       "      <td>27801</td>\n",
       "      <td>28264</td>\n",
       "      <td>24435</td>\n",
       "      <td>33653</td>\n",
       "      <td>68651</td>\n",
       "      <td>21781</td>\n",
       "      <td>24693</td>\n",
       "      <td>26728</td>\n",
       "      <td>20449</td>\n",
       "      <td>19315</td>\n",
       "      <td>25525</td>\n",
       "      <td>2.1</td>\n",
       "      <td>gram</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2.2</td>\n",
       "      <td>अरहर</td>\n",
       "      <td>8976</td>\n",
       "      <td>11615</td>\n",
       "      <td>12979</td>\n",
       "      <td>14707</td>\n",
       "      <td>19814</td>\n",
       "      <td>34679</td>\n",
       "      <td>8976</td>\n",
       "      <td>10183</td>\n",
       "      <td>10641</td>\n",
       "      <td>9405</td>\n",
       "      <td>8584</td>\n",
       "      <td>16029</td>\n",
       "      <td>2.2</td>\n",
       "      <td>arhar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2.3</td>\n",
       "      <td>उड़द</td>\n",
       "      <td>6399</td>\n",
       "      <td>6986</td>\n",
       "      <td>7180</td>\n",
       "      <td>10398</td>\n",
       "      <td>15553</td>\n",
       "      <td>25012</td>\n",
       "      <td>6399</td>\n",
       "      <td>6858</td>\n",
       "      <td>6056</td>\n",
       "      <td>6889</td>\n",
       "      <td>6704</td>\n",
       "      <td>9627</td>\n",
       "      <td>2.3</td>\n",
       "      <td>urd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2.4</td>\n",
       "      <td>मूंग</td>\n",
       "      <td>5987</td>\n",
       "      <td>5142</td>\n",
       "      <td>8242</td>\n",
       "      <td>9474</td>\n",
       "      <td>10738</td>\n",
       "      <td>12079</td>\n",
       "      <td>5987</td>\n",
       "      <td>4305</td>\n",
       "      <td>5993</td>\n",
       "      <td>5605</td>\n",
       "      <td>5946</td>\n",
       "      <td>8078</td>\n",
       "      <td>2.4</td>\n",
       "      <td>moong</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2.5</td>\n",
       "      <td>मसूर</td>\n",
       "      <td>3582</td>\n",
       "      <td>4290</td>\n",
       "      <td>4253</td>\n",
       "      <td>5196</td>\n",
       "      <td>6138</td>\n",
       "      <td>7025</td>\n",
       "      <td>3582</td>\n",
       "      <td>3752</td>\n",
       "      <td>3392</td>\n",
       "      <td>3432</td>\n",
       "      <td>3240</td>\n",
       "      <td>3941</td>\n",
       "      <td>2.5</td>\n",
       "      <td>masoor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2.6</td>\n",
       "      <td>काला चना</td>\n",
       "      <td>395</td>\n",
       "      <td>546</td>\n",
       "      <td>690</td>\n",
       "      <td>758</td>\n",
       "      <td>697</td>\n",
       "      <td>997</td>\n",
       "      <td>395</td>\n",
       "      <td>375</td>\n",
       "      <td>444</td>\n",
       "      <td>496</td>\n",
       "      <td>422</td>\n",
       "      <td>514</td>\n",
       "      <td>2.6</td>\n",
       "      <td>horse gram</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2.7</td>\n",
       "      <td>मोठ</td>\n",
       "      <td>986</td>\n",
       "      <td>1074</td>\n",
       "      <td>1205</td>\n",
       "      <td>1822</td>\n",
       "      <td>1717</td>\n",
       "      <td>2456</td>\n",
       "      <td>986</td>\n",
       "      <td>536</td>\n",
       "      <td>629</td>\n",
       "      <td>716</td>\n",
       "      <td>666</td>\n",
       "      <td>810</td>\n",
       "      <td>2.7</td>\n",
       "      <td>moth</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2.8</td>\n",
       "      <td>वाल</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.8</td>\n",
       "      <td>val</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2.9</td>\n",
       "      <td>राजमा</td>\n",
       "      <td>69</td>\n",
       "      <td>74</td>\n",
       "      <td>185</td>\n",
       "      <td>174</td>\n",
       "      <td>154</td>\n",
       "      <td>192</td>\n",
       "      <td>69</td>\n",
       "      <td>76</td>\n",
       "      <td>128</td>\n",
       "      <td>117</td>\n",
       "      <td>95</td>\n",
       "      <td>116</td>\n",
       "      <td>2.9</td>\n",
       "      <td>rajma</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2.10</td>\n",
       "      <td>लोबिया</td>\n",
       "      <td>122</td>\n",
       "      <td>154</td>\n",
       "      <td>152</td>\n",
       "      <td>184</td>\n",
       "      <td>241</td>\n",
       "      <td>312</td>\n",
       "      <td>122</td>\n",
       "      <td>148</td>\n",
       "      <td>147</td>\n",
       "      <td>166</td>\n",
       "      <td>188</td>\n",
       "      <td>229</td>\n",
       "      <td>2.10</td>\n",
       "      <td>cowpea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2.11</td>\n",
       "      <td>छोला</td>\n",
       "      <td>124</td>\n",
       "      <td>99</td>\n",
       "      <td>122</td>\n",
       "      <td>151</td>\n",
       "      <td>137</td>\n",
       "      <td>196</td>\n",
       "      <td>124</td>\n",
       "      <td>42</td>\n",
       "      <td>57</td>\n",
       "      <td>66</td>\n",
       "      <td>52</td>\n",
       "      <td>63</td>\n",
       "      <td>2.11</td>\n",
       "      <td>chola</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2.12</td>\n",
       "      <td>लाख / खेसरी</td>\n",
       "      <td>718</td>\n",
       "      <td>890</td>\n",
       "      <td>679</td>\n",
       "      <td>1100</td>\n",
       "      <td>1086</td>\n",
       "      <td>1553</td>\n",
       "      <td>718</td>\n",
       "      <td>843</td>\n",
       "      <td>609</td>\n",
       "      <td>978</td>\n",
       "      <td>726</td>\n",
       "      <td>883</td>\n",
       "      <td>2.12</td>\n",
       "      <td>lakh/khesri</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2.13</td>\n",
       "      <td>मटर / चौलाई/चवली</td>\n",
       "      <td>1769</td>\n",
       "      <td>2433</td>\n",
       "      <td>2715</td>\n",
       "      <td>2884</td>\n",
       "      <td>2562</td>\n",
       "      <td>3316</td>\n",
       "      <td>1769</td>\n",
       "      <td>2077</td>\n",
       "      <td>2130</td>\n",
       "      <td>2175</td>\n",
       "      <td>1875</td>\n",
       "      <td>2281</td>\n",
       "      <td>2.13</td>\n",
       "      <td>peas/chawali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2.14</td>\n",
       "      <td>बटना</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>39</td>\n",
       "      <td>48</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>33</td>\n",
       "      <td>2.14</td>\n",
       "      <td>batna</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2.15</td>\n",
       "      <td>अन्‍य दालें</td>\n",
       "      <td>1242</td>\n",
       "      <td>1290</td>\n",
       "      <td>1464</td>\n",
       "      <td>1645</td>\n",
       "      <td>2340</td>\n",
       "      <td>3347</td>\n",
       "      <td>1242</td>\n",
       "      <td>1143</td>\n",
       "      <td>1184</td>\n",
       "      <td>1102</td>\n",
       "      <td>1181</td>\n",
       "      <td>1437</td>\n",
       "      <td>2.15</td>\n",
       "      <td>others pulses</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>3</td>\n",
       "      <td>तिलहन</td>\n",
       "      <td>106654</td>\n",
       "      <td>113958</td>\n",
       "      <td>132506</td>\n",
       "      <td>126775</td>\n",
       "      <td>123501</td>\n",
       "      <td>149417</td>\n",
       "      <td>106654</td>\n",
       "      <td>104137</td>\n",
       "      <td>112420</td>\n",
       "      <td>97326</td>\n",
       "      <td>92977</td>\n",
       "      <td>111115</td>\n",
       "      <td>3</td>\n",
       "      <td>oilseeds</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>3.1</td>\n",
       "      <td>अलसी</td>\n",
       "      <td>517</td>\n",
       "      <td>632</td>\n",
       "      <td>524</td>\n",
       "      <td>594</td>\n",
       "      <td>490</td>\n",
       "      <td>763</td>\n",
       "      <td>517</td>\n",
       "      <td>517</td>\n",
       "      <td>404</td>\n",
       "      <td>435</td>\n",
       "      <td>355</td>\n",
       "      <td>437</td>\n",
       "      <td>3.1</td>\n",
       "      <td>linseed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>3.2</td>\n",
       "      <td>तिल</td>\n",
       "      <td>3649</td>\n",
       "      <td>4098</td>\n",
       "      <td>5978</td>\n",
       "      <td>6285</td>\n",
       "      <td>5158</td>\n",
       "      <td>5079</td>\n",
       "      <td>3649</td>\n",
       "      <td>2883</td>\n",
       "      <td>2998</td>\n",
       "      <td>3464</td>\n",
       "      <td>3607</td>\n",
       "      <td>3327</td>\n",
       "      <td>3.2</td>\n",
       "      <td>sesamum</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>3.3</td>\n",
       "      <td>मूंगफली</td>\n",
       "      <td>24500</td>\n",
       "      <td>20486</td>\n",
       "      <td>35549</td>\n",
       "      <td>29636</td>\n",
       "      <td>30281</td>\n",
       "      <td>36763</td>\n",
       "      <td>24500</td>\n",
       "      <td>16252</td>\n",
       "      <td>34344</td>\n",
       "      <td>25744</td>\n",
       "      <td>23424</td>\n",
       "      <td>26319</td>\n",
       "      <td>3.3</td>\n",
       "      <td>groundnut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>3.4</td>\n",
       "      <td>रेपसीड और सरसों</td>\n",
       "      <td>22335</td>\n",
       "      <td>28028</td>\n",
       "      <td>25056</td>\n",
       "      <td>21747</td>\n",
       "      <td>26056</td>\n",
       "      <td>31313</td>\n",
       "      <td>22335</td>\n",
       "      <td>26483</td>\n",
       "      <td>24755</td>\n",
       "      <td>19962</td>\n",
       "      <td>21800</td>\n",
       "      <td>25584</td>\n",
       "      <td>3.4</td>\n",
       "      <td>rapseed &amp; mustard</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>9.37</td>\n",
       "      <td>भिंडी</td>\n",
       "      <td>10700</td>\n",
       "      <td>11372</td>\n",
       "      <td>12765</td>\n",
       "      <td>12556</td>\n",
       "      <td>11993</td>\n",
       "      <td>12134</td>\n",
       "      <td>10700</td>\n",
       "      <td>10748</td>\n",
       "      <td>10451</td>\n",
       "      <td>9715</td>\n",
       "      <td>9897</td>\n",
       "      <td>10158</td>\n",
       "      <td>9.37</td>\n",
       "      <td>okra</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>9.38</td>\n",
       "      <td>टमाटर</td>\n",
       "      <td>20302</td>\n",
       "      <td>20830</td>\n",
       "      <td>27322</td>\n",
       "      <td>26141</td>\n",
       "      <td>30656</td>\n",
       "      <td>25691</td>\n",
       "      <td>20302</td>\n",
       "      <td>20118</td>\n",
       "      <td>20348</td>\n",
       "      <td>18274</td>\n",
       "      <td>20772</td>\n",
       "      <td>22964</td>\n",
       "      <td>9.38</td>\n",
       "      <td>tomato</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>9.39</td>\n",
       "      <td>सहजन की फली</td>\n",
       "      <td>1938</td>\n",
       "      <td>1831</td>\n",
       "      <td>3269</td>\n",
       "      <td>4399</td>\n",
       "      <td>4809</td>\n",
       "      <td>4999</td>\n",
       "      <td>1938</td>\n",
       "      <td>1831</td>\n",
       "      <td>2458</td>\n",
       "      <td>2828</td>\n",
       "      <td>2956</td>\n",
       "      <td>3113</td>\n",
       "      <td>9.39</td>\n",
       "      <td>drum sticks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>9.40</td>\n",
       "      <td>हरी मटर</td>\n",
       "      <td>6612</td>\n",
       "      <td>8017</td>\n",
       "      <td>8499</td>\n",
       "      <td>12635</td>\n",
       "      <td>11997</td>\n",
       "      <td>12112</td>\n",
       "      <td>6612</td>\n",
       "      <td>7122</td>\n",
       "      <td>6589</td>\n",
       "      <td>7490</td>\n",
       "      <td>7961</td>\n",
       "      <td>8844</td>\n",
       "      <td>9.40</td>\n",
       "      <td>green peas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>9.41</td>\n",
       "      <td>फलियां</td>\n",
       "      <td>2961</td>\n",
       "      <td>3878</td>\n",
       "      <td>4583</td>\n",
       "      <td>5873</td>\n",
       "      <td>7086</td>\n",
       "      <td>6361</td>\n",
       "      <td>2961</td>\n",
       "      <td>3172</td>\n",
       "      <td>3321</td>\n",
       "      <td>4338</td>\n",
       "      <td>4532</td>\n",
       "      <td>3907</td>\n",
       "      <td>9.41</td>\n",
       "      <td>beans</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>9.42</td>\n",
       "      <td>करेला</td>\n",
       "      <td>1342</td>\n",
       "      <td>1590</td>\n",
       "      <td>1552</td>\n",
       "      <td>1748</td>\n",
       "      <td>2388</td>\n",
       "      <td>3142</td>\n",
       "      <td>1342</td>\n",
       "      <td>1455</td>\n",
       "      <td>1275</td>\n",
       "      <td>1239</td>\n",
       "      <td>1600</td>\n",
       "      <td>1576</td>\n",
       "      <td>9.42</td>\n",
       "      <td>bittergourd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>9.43</td>\n",
       "      <td>लौकी</td>\n",
       "      <td>1512</td>\n",
       "      <td>1550</td>\n",
       "      <td>1763</td>\n",
       "      <td>1870</td>\n",
       "      <td>2327</td>\n",
       "      <td>2235</td>\n",
       "      <td>1512</td>\n",
       "      <td>1622</td>\n",
       "      <td>1376</td>\n",
       "      <td>1372</td>\n",
       "      <td>1762</td>\n",
       "      <td>1813</td>\n",
       "      <td>9.43</td>\n",
       "      <td>bottlegourd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>9.44</td>\n",
       "      <td>शिमला मिर्च</td>\n",
       "      <td>227</td>\n",
       "      <td>324</td>\n",
       "      <td>299</td>\n",
       "      <td>323</td>\n",
       "      <td>549</td>\n",
       "      <td>553</td>\n",
       "      <td>227</td>\n",
       "      <td>268</td>\n",
       "      <td>250</td>\n",
       "      <td>269</td>\n",
       "      <td>453</td>\n",
       "      <td>481</td>\n",
       "      <td>9.44</td>\n",
       "      <td>capsicum</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>9.45</td>\n",
       "      <td>गाजर</td>\n",
       "      <td>1239</td>\n",
       "      <td>1237</td>\n",
       "      <td>1366</td>\n",
       "      <td>1467</td>\n",
       "      <td>1803</td>\n",
       "      <td>1534</td>\n",
       "      <td>1239</td>\n",
       "      <td>1223</td>\n",
       "      <td>1178</td>\n",
       "      <td>1014</td>\n",
       "      <td>1251</td>\n",
       "      <td>1262</td>\n",
       "      <td>9.45</td>\n",
       "      <td>carrot</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>9.46</td>\n",
       "      <td>खीरा</td>\n",
       "      <td>559</td>\n",
       "      <td>621</td>\n",
       "      <td>730</td>\n",
       "      <td>835</td>\n",
       "      <td>1511</td>\n",
       "      <td>1591</td>\n",
       "      <td>559</td>\n",
       "      <td>606</td>\n",
       "      <td>573</td>\n",
       "      <td>579</td>\n",
       "      <td>1009</td>\n",
       "      <td>958</td>\n",
       "      <td>9.46</td>\n",
       "      <td>cucumber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>9.47</td>\n",
       "      <td>खरबूजा</td>\n",
       "      <td>657</td>\n",
       "      <td>695</td>\n",
       "      <td>728</td>\n",
       "      <td>767</td>\n",
       "      <td>924</td>\n",
       "      <td>1150</td>\n",
       "      <td>657</td>\n",
       "      <td>715</td>\n",
       "      <td>629</td>\n",
       "      <td>678</td>\n",
       "      <td>724</td>\n",
       "      <td>850</td>\n",
       "      <td>9.47</td>\n",
       "      <td>muskmelon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>9.48</td>\n",
       "      <td>परमल</td>\n",
       "      <td>47</td>\n",
       "      <td>259</td>\n",
       "      <td>341</td>\n",
       "      <td>670</td>\n",
       "      <td>519</td>\n",
       "      <td>563</td>\n",
       "      <td>47</td>\n",
       "      <td>226</td>\n",
       "      <td>245</td>\n",
       "      <td>470</td>\n",
       "      <td>328</td>\n",
       "      <td>333</td>\n",
       "      <td>9.48</td>\n",
       "      <td>parmal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>9.49</td>\n",
       "      <td>मूली</td>\n",
       "      <td>2477</td>\n",
       "      <td>2695</td>\n",
       "      <td>3232</td>\n",
       "      <td>3065</td>\n",
       "      <td>3479</td>\n",
       "      <td>4111</td>\n",
       "      <td>2477</td>\n",
       "      <td>2598</td>\n",
       "      <td>2645</td>\n",
       "      <td>2433</td>\n",
       "      <td>2657</td>\n",
       "      <td>2707</td>\n",
       "      <td>9.49</td>\n",
       "      <td>radish</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>9.50</td>\n",
       "      <td>कद्दू</td>\n",
       "      <td>255</td>\n",
       "      <td>322</td>\n",
       "      <td>366</td>\n",
       "      <td>1319</td>\n",
       "      <td>1643</td>\n",
       "      <td>2145</td>\n",
       "      <td>255</td>\n",
       "      <td>317</td>\n",
       "      <td>288</td>\n",
       "      <td>1008</td>\n",
       "      <td>1369</td>\n",
       "      <td>1509</td>\n",
       "      <td>9.50</td>\n",
       "      <td>pumpkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>9.51</td>\n",
       "      <td>तरबूज</td>\n",
       "      <td>2612</td>\n",
       "      <td>2799</td>\n",
       "      <td>3372</td>\n",
       "      <td>4013</td>\n",
       "      <td>4115</td>\n",
       "      <td>4093</td>\n",
       "      <td>2612</td>\n",
       "      <td>2728</td>\n",
       "      <td>2759</td>\n",
       "      <td>2919</td>\n",
       "      <td>3423</td>\n",
       "      <td>3212</td>\n",
       "      <td>9.51</td>\n",
       "      <td>watermelon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>9.52</td>\n",
       "      <td>अन्य सब्जियां</td>\n",
       "      <td>20581</td>\n",
       "      <td>24381</td>\n",
       "      <td>31645</td>\n",
       "      <td>42577</td>\n",
       "      <td>41903</td>\n",
       "      <td>37679</td>\n",
       "      <td>20581</td>\n",
       "      <td>21865</td>\n",
       "      <td>22572</td>\n",
       "      <td>27487</td>\n",
       "      <td>28549</td>\n",
       "      <td>27103</td>\n",
       "      <td>9.52</td>\n",
       "      <td>other vegetables</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>10</td>\n",
       "      <td>अन्य फसलें</td>\n",
       "      <td>91975</td>\n",
       "      <td>98494</td>\n",
       "      <td>104961</td>\n",
       "      <td>98236</td>\n",
       "      <td>99278</td>\n",
       "      <td>97122</td>\n",
       "      <td>91975</td>\n",
       "      <td>94805</td>\n",
       "      <td>103127</td>\n",
       "      <td>97607</td>\n",
       "      <td>92349</td>\n",
       "      <td>86752</td>\n",
       "      <td>10</td>\n",
       "      <td>other crops</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>10.1</td>\n",
       "      <td>रबर</td>\n",
       "      <td>17164</td>\n",
       "      <td>14422</td>\n",
       "      <td>11464</td>\n",
       "      <td>7319</td>\n",
       "      <td>5483</td>\n",
       "      <td>8035</td>\n",
       "      <td>17164</td>\n",
       "      <td>17259</td>\n",
       "      <td>14448</td>\n",
       "      <td>11820</td>\n",
       "      <td>10225</td>\n",
       "      <td>12572</td>\n",
       "      <td>10.1</td>\n",
       "      <td>rubber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>10.2</td>\n",
       "      <td>ग्वार बीज</td>\n",
       "      <td>22296</td>\n",
       "      <td>25398</td>\n",
       "      <td>30172</td>\n",
       "      <td>22230</td>\n",
       "      <td>17620</td>\n",
       "      <td>10916</td>\n",
       "      <td>22296</td>\n",
       "      <td>25345</td>\n",
       "      <td>37400</td>\n",
       "      <td>34075</td>\n",
       "      <td>28409</td>\n",
       "      <td>19994</td>\n",
       "      <td>10.2</td>\n",
       "      <td>guar seed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>10.3</td>\n",
       "      <td>विविध खाद्य फसलें</td>\n",
       "      <td>72</td>\n",
       "      <td>31</td>\n",
       "      <td>30</td>\n",
       "      <td>26</td>\n",
       "      <td>27</td>\n",
       "      <td>30</td>\n",
       "      <td>72</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>10.3</td>\n",
       "      <td>misc. food crops</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>10.4</td>\n",
       "      <td>विविध गैर खाद्य फसलें</td>\n",
       "      <td>1586</td>\n",
       "      <td>714</td>\n",
       "      <td>1223</td>\n",
       "      <td>1229</td>\n",
       "      <td>1251</td>\n",
       "      <td>1270</td>\n",
       "      <td>1586</td>\n",
       "      <td>1560</td>\n",
       "      <td>1553</td>\n",
       "      <td>1575</td>\n",
       "      <td>1603</td>\n",
       "      <td>1603</td>\n",
       "      <td>10.4</td>\n",
       "      <td>misc. non-food crops</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>10.5</td>\n",
       "      <td>चारा</td>\n",
       "      <td>32494</td>\n",
       "      <td>37161</td>\n",
       "      <td>39422</td>\n",
       "      <td>43562</td>\n",
       "      <td>46603</td>\n",
       "      <td>47980</td>\n",
       "      <td>32494</td>\n",
       "      <td>32372</td>\n",
       "      <td>31636</td>\n",
       "      <td>31822</td>\n",
       "      <td>31544</td>\n",
       "      <td>31845</td>\n",
       "      <td>10.5</td>\n",
       "      <td>fodder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>10.6</td>\n",
       "      <td>घास</td>\n",
       "      <td>17837</td>\n",
       "      <td>20389</td>\n",
       "      <td>22312</td>\n",
       "      <td>23409</td>\n",
       "      <td>25529</td>\n",
       "      <td>26230</td>\n",
       "      <td>17837</td>\n",
       "      <td>17914</td>\n",
       "      <td>17773</td>\n",
       "      <td>17920</td>\n",
       "      <td>18146</td>\n",
       "      <td>18281</td>\n",
       "      <td>10.6</td>\n",
       "      <td>grass</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>10.7</td>\n",
       "      <td>शहतूत</td>\n",
       "      <td>37</td>\n",
       "      <td>40</td>\n",
       "      <td>43</td>\n",
       "      <td>48</td>\n",
       "      <td>48</td>\n",
       "      <td>53</td>\n",
       "      <td>37</td>\n",
       "      <td>39</td>\n",
       "      <td>42</td>\n",
       "      <td>48</td>\n",
       "      <td>48</td>\n",
       "      <td>52</td>\n",
       "      <td>10.7</td>\n",
       "      <td>mulbery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>10.8</td>\n",
       "      <td>मशरूम</td>\n",
       "      <td>487</td>\n",
       "      <td>339</td>\n",
       "      <td>295</td>\n",
       "      <td>413</td>\n",
       "      <td>2718</td>\n",
       "      <td>2607</td>\n",
       "      <td>487</td>\n",
       "      <td>291</td>\n",
       "      <td>248</td>\n",
       "      <td>327</td>\n",
       "      <td>2354</td>\n",
       "      <td>2384</td>\n",
       "      <td>10.8</td>\n",
       "      <td>mushroom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>11</td>\n",
       "      <td>उपोत्‍पाद</td>\n",
       "      <td>68855</td>\n",
       "      <td>73937</td>\n",
       "      <td>86140</td>\n",
       "      <td>91553</td>\n",
       "      <td>93825</td>\n",
       "      <td>98557</td>\n",
       "      <td>68855</td>\n",
       "      <td>66885</td>\n",
       "      <td>68556</td>\n",
       "      <td>68765</td>\n",
       "      <td>67289</td>\n",
       "      <td>66669</td>\n",
       "      <td>11</td>\n",
       "      <td>by products</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>11.1</td>\n",
       "      <td>भूसा व डंठल</td>\n",
       "      <td>60887</td>\n",
       "      <td>65593</td>\n",
       "      <td>77014</td>\n",
       "      <td>82233</td>\n",
       "      <td>84492</td>\n",
       "      <td>89354</td>\n",
       "      <td>60887</td>\n",
       "      <td>59131</td>\n",
       "      <td>60712</td>\n",
       "      <td>60999</td>\n",
       "      <td>59662</td>\n",
       "      <td>59149</td>\n",
       "      <td>11.1</td>\n",
       "      <td>straw &amp; stalks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>11.2</td>\n",
       "      <td>अन्‍य</td>\n",
       "      <td>7968</td>\n",
       "      <td>8343</td>\n",
       "      <td>9127</td>\n",
       "      <td>9321</td>\n",
       "      <td>9334</td>\n",
       "      <td>9203</td>\n",
       "      <td>7968</td>\n",
       "      <td>7754</td>\n",
       "      <td>7844</td>\n",
       "      <td>7766</td>\n",
       "      <td>7626</td>\n",
       "      <td>7520</td>\n",
       "      <td>11.2</td>\n",
       "      <td>others</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>12</td>\n",
       "      <td>रसोई बागवानी</td>\n",
       "      <td>5107</td>\n",
       "      <td>6097</td>\n",
       "      <td>7295</td>\n",
       "      <td>8444</td>\n",
       "      <td>8058</td>\n",
       "      <td>8578</td>\n",
       "      <td>5107</td>\n",
       "      <td>5400</td>\n",
       "      <td>5501</td>\n",
       "      <td>5731</td>\n",
       "      <td>5529</td>\n",
       "      <td>5907</td>\n",
       "      <td>12</td>\n",
       "      <td>kitchen garden</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>13</td>\n",
       "      <td>फसलों से उत्पादन का मूल्य</td>\n",
       "      <td>1191483</td>\n",
       "      <td>1329582</td>\n",
       "      <td>1533426</td>\n",
       "      <td>1595498</td>\n",
       "      <td>1639523</td>\n",
       "      <td>1863390</td>\n",
       "      <td>1191483</td>\n",
       "      <td>1198611</td>\n",
       "      <td>1257133</td>\n",
       "      <td>1228006</td>\n",
       "      <td>1203146</td>\n",
       "      <td>1278398</td>\n",
       "      <td>13</td>\n",
       "      <td>value of output from crops</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>143 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Unnamed: 0                 Unnamed: 1 Unnamed: 2 Unnamed: 3 Unnamed: 4  \\\n",
       "7          1.1                        धान     170595     198266     220635   \n",
       "8          1.2                      गेहूँ     118068     131710     142561   \n",
       "9          1.3                      ज्वार       9807       8133       9073   \n",
       "10         1.4                      बाजरा       9940      10858      11807   \n",
       "11         1.5                         जौ       1901       2133       2254   \n",
       "12         1.6                      मक्का      23539      27952      31875   \n",
       "13         1.7                       रागी       2015       2455       3382   \n",
       "14         1.8                 छोटा बाजरा        413        427        467   \n",
       "15         1.9                  अन्य अनाज         81        106         73   \n",
       "16           2                      दालें      52151      62394      68129   \n",
       "17         2.1                        चना      21781      27801      28264   \n",
       "18         2.2                       अरहर       8976      11615      12979   \n",
       "19         2.3                       उड़द       6399       6986       7180   \n",
       "20         2.4                       मूंग       5987       5142       8242   \n",
       "21         2.5                       मसूर       3582       4290       4253   \n",
       "22         2.6                   काला चना        395        546        690   \n",
       "23         2.7                        मोठ        986       1074       1205   \n",
       "24         2.8                        वाल          0          0          0   \n",
       "25         2.9                      राजमा         69         74        185   \n",
       "26        2.10                     लोबिया        122        154        152   \n",
       "27        2.11                       छोला        124         99        122   \n",
       "28        2.12                लाख / खेसरी        718        890        679   \n",
       "29        2.13           मटर / चौलाई/चवली       1769       2433       2715   \n",
       "30        2.14                       बटना          0          0          0   \n",
       "31        2.15                अन्‍य दालें       1242       1290       1464   \n",
       "32           3                      तिलहन     106654     113958     132506   \n",
       "33         3.1                       अलसी        517        632        524   \n",
       "34         3.2                        तिल       3649       4098       5978   \n",
       "35         3.3                    मूंगफली      24500      20486      35549   \n",
       "36         3.4            रेपसीड और सरसों      22335      28028      25056   \n",
       "..         ...                        ...        ...        ...        ...   \n",
       "120       9.37                      भिंडी      10700      11372      12765   \n",
       "121       9.38                      टमाटर      20302      20830      27322   \n",
       "122       9.39                सहजन की फली       1938       1831       3269   \n",
       "123       9.40                    हरी मटर       6612       8017       8499   \n",
       "124       9.41                     फलियां       2961       3878       4583   \n",
       "125       9.42                      करेला       1342       1590       1552   \n",
       "126       9.43                       लौकी       1512       1550       1763   \n",
       "127       9.44                शिमला मिर्च        227        324        299   \n",
       "128       9.45                       गाजर       1239       1237       1366   \n",
       "129       9.46                       खीरा        559        621        730   \n",
       "130       9.47                     खरबूजा        657        695        728   \n",
       "131       9.48                       परमल         47        259        341   \n",
       "132       9.49                       मूली       2477       2695       3232   \n",
       "133       9.50                      कद्दू        255        322        366   \n",
       "134       9.51                      तरबूज       2612       2799       3372   \n",
       "135       9.52              अन्य सब्जियां      20581      24381      31645   \n",
       "136         10                 अन्य फसलें      91975      98494     104961   \n",
       "137       10.1                        रबर      17164      14422      11464   \n",
       "138       10.2                  ग्वार बीज      22296      25398      30172   \n",
       "139       10.3          विविध खाद्य फसलें         72         31         30   \n",
       "140       10.4      विविध गैर खाद्य फसलें       1586        714       1223   \n",
       "141       10.5                       चारा      32494      37161      39422   \n",
       "142       10.6                        घास      17837      20389      22312   \n",
       "143       10.7                      शहतूत         37         40         43   \n",
       "144       10.8                      मशरूम        487        339        295   \n",
       "145         11                  उपोत्‍पाद      68855      73937      86140   \n",
       "146       11.1                भूसा व डंठल      60887      65593      77014   \n",
       "147       11.2                      अन्‍य       7968       8343       9127   \n",
       "148         12               रसोई बागवानी       5107       6097       7295   \n",
       "149         13  फसलों से उत्पादन का मूल्य    1191483    1329582    1533426   \n",
       "\n",
       "    Unnamed: 5 Unnamed: 6 Unnamed: 7 Unnamed: 8 Unnamed: 9 Unnamed: 10  \\\n",
       "7       226644     228079     253902     170595     169773      172144   \n",
       "8       129011     145939     165304     118068     115884      119051   \n",
       "9         9917       7812       9203       9807       8540        9144   \n",
       "10       11345      11296      15901       9940       8309        8949   \n",
       "11        2049       2098       3047       1901       2075        2164   \n",
       "12       31182      33095      42034      23539      23742       26049   \n",
       "13        3438       3040       2884       2015       1651        2102   \n",
       "14         429        424        563        413        399         374   \n",
       "15          68         71         87         81         91          57   \n",
       "16       72966      94869     159862      52151      55032       58138   \n",
       "17       24435      33653      68651      21781      24693       26728   \n",
       "18       14707      19814      34679       8976      10183       10641   \n",
       "19       10398      15553      25012       6399       6858        6056   \n",
       "20        9474      10738      12079       5987       4305        5993   \n",
       "21        5196       6138       7025       3582       3752        3392   \n",
       "22         758        697        997        395        375         444   \n",
       "23        1822       1717       2456        986        536         629   \n",
       "24           0          0          0          0          0           0   \n",
       "25         174        154        192         69         76         128   \n",
       "26         184        241        312        122        148         147   \n",
       "27         151        137        196        124         42          57   \n",
       "28        1100       1086       1553        718        843         609   \n",
       "29        2884       2562       3316       1769       2077        2130   \n",
       "30          38         39         48          0          0           0   \n",
       "31        1645       2340       3347       1242       1143        1184   \n",
       "32      126775     123501     149417     106654     104137      112420   \n",
       "33         594        490        763        517        517         404   \n",
       "34        6285       5158       5079       3649       2883        2998   \n",
       "35       29636      30281      36763      24500      16252       34344   \n",
       "36       21747      26056      31313      22335      26483       24755   \n",
       "..         ...        ...        ...        ...        ...         ...   \n",
       "120      12556      11993      12134      10700      10748       10451   \n",
       "121      26141      30656      25691      20302      20118       20348   \n",
       "122       4399       4809       4999       1938       1831        2458   \n",
       "123      12635      11997      12112       6612       7122        6589   \n",
       "124       5873       7086       6361       2961       3172        3321   \n",
       "125       1748       2388       3142       1342       1455        1275   \n",
       "126       1870       2327       2235       1512       1622        1376   \n",
       "127        323        549        553        227        268         250   \n",
       "128       1467       1803       1534       1239       1223        1178   \n",
       "129        835       1511       1591        559        606         573   \n",
       "130        767        924       1150        657        715         629   \n",
       "131        670        519        563         47        226         245   \n",
       "132       3065       3479       4111       2477       2598        2645   \n",
       "133       1319       1643       2145        255        317         288   \n",
       "134       4013       4115       4093       2612       2728        2759   \n",
       "135      42577      41903      37679      20581      21865       22572   \n",
       "136      98236      99278      97122      91975      94805      103127   \n",
       "137       7319       5483       8035      17164      17259       14448   \n",
       "138      22230      17620      10916      22296      25345       37400   \n",
       "139         26         27         30         72         26          26   \n",
       "140       1229       1251       1270       1586       1560        1553   \n",
       "141      43562      46603      47980      32494      32372       31636   \n",
       "142      23409      25529      26230      17837      17914       17773   \n",
       "143         48         48         53         37         39          42   \n",
       "144        413       2718       2607        487        291         248   \n",
       "145      91553      93825      98557      68855      66885       68556   \n",
       "146      82233      84492      89354      60887      59131       60712   \n",
       "147       9321       9334       9203       7968       7754        7844   \n",
       "148       8444       8058       8578       5107       5400        5501   \n",
       "149    1595498    1639523    1863390    1191483    1198611     1257133   \n",
       "\n",
       "    Unnamed: 11 Unnamed: 12 Unnamed: 13 Unnamed: 14  \\\n",
       "7        170272      168028      177655         1.1   \n",
       "8        107828      114880      122307         1.2   \n",
       "9          8839        6769        7296         1.3   \n",
       "10         8678        7645        9284         1.4   \n",
       "11         1916        1677        2027         1.5   \n",
       "12        25844       24240       28203         1.6   \n",
       "13         2160        1899        1461         1.7   \n",
       "14          349         315         339         1.8   \n",
       "15           51          52          51         1.9   \n",
       "16        51624       49023       69564           2   \n",
       "17        20449       19315       25525         2.1   \n",
       "18         9405        8584       16029         2.2   \n",
       "19         6889        6704        9627         2.3   \n",
       "20         5605        5946        8078         2.4   \n",
       "21         3432        3240        3941         2.5   \n",
       "22          496         422         514         2.6   \n",
       "23          716         666         810         2.7   \n",
       "24            0           0           0         2.8   \n",
       "25          117          95         116         2.9   \n",
       "26          166         188         229        2.10   \n",
       "27           66          52          63        2.11   \n",
       "28          978         726         883        2.12   \n",
       "29         2175        1875        2281        2.13   \n",
       "30           27          27          33        2.14   \n",
       "31         1102        1181        1437        2.15   \n",
       "32        97326       92977      111115           3   \n",
       "33          435         355         437         3.1   \n",
       "34         3464        3607        3327         3.2   \n",
       "35        25744       23424       26319         3.3   \n",
       "36        19962       21800       25584         3.4   \n",
       "..          ...         ...         ...         ...   \n",
       "120        9715        9897       10158        9.37   \n",
       "121       18274       20772       22964        9.38   \n",
       "122        2828        2956        3113        9.39   \n",
       "123        7490        7961        8844        9.40   \n",
       "124        4338        4532        3907        9.41   \n",
       "125        1239        1600        1576        9.42   \n",
       "126        1372        1762        1813        9.43   \n",
       "127         269         453         481        9.44   \n",
       "128        1014        1251        1262        9.45   \n",
       "129         579        1009         958        9.46   \n",
       "130         678         724         850        9.47   \n",
       "131         470         328         333        9.48   \n",
       "132        2433        2657        2707        9.49   \n",
       "133        1008        1369        1509        9.50   \n",
       "134        2919        3423        3212        9.51   \n",
       "135       27487       28549       27103        9.52   \n",
       "136       97607       92349       86752          10   \n",
       "137       11820       10225       12572        10.1   \n",
       "138       34075       28409       19994        10.2   \n",
       "139          21          21          21        10.3   \n",
       "140        1575        1603        1603        10.4   \n",
       "141       31822       31544       31845        10.5   \n",
       "142       17920       18146       18281        10.6   \n",
       "143          48          48          52        10.7   \n",
       "144         327        2354        2384        10.8   \n",
       "145       68765       67289       66669          11   \n",
       "146       60999       59662       59149        11.1   \n",
       "147        7766        7626        7520        11.2   \n",
       "148        5731        5529        5907          12   \n",
       "149     1228006     1203146     1278398          13   \n",
       "\n",
       "                    Unnamed: 15  \n",
       "7                         paddy  \n",
       "8                         wheat  \n",
       "9                         jowar  \n",
       "10                        bajra  \n",
       "11                       barley  \n",
       "12                        maize  \n",
       "13                         ragi  \n",
       "14                small millets  \n",
       "15                other cereals  \n",
       "16                       pulses  \n",
       "17                         gram  \n",
       "18                        arhar  \n",
       "19                          urd  \n",
       "20                        moong  \n",
       "21                       masoor  \n",
       "22                   horse gram  \n",
       "23                         moth  \n",
       "24                          val  \n",
       "25                        rajma  \n",
       "26                       cowpea  \n",
       "27                        chola  \n",
       "28                  lakh/khesri  \n",
       "29                 peas/chawali  \n",
       "30                        batna  \n",
       "31                others pulses  \n",
       "32                     oilseeds  \n",
       "33                      linseed  \n",
       "34                      sesamum  \n",
       "35                    groundnut  \n",
       "36            rapseed & mustard  \n",
       "..                          ...  \n",
       "120                        okra  \n",
       "121                      tomato  \n",
       "122                 drum sticks  \n",
       "123                  green peas  \n",
       "124                       beans  \n",
       "125                 bittergourd  \n",
       "126                 bottlegourd  \n",
       "127                    capsicum  \n",
       "128                      carrot  \n",
       "129                    cucumber  \n",
       "130                   muskmelon  \n",
       "131                      parmal  \n",
       "132                      radish  \n",
       "133                     pumpkin  \n",
       "134                  watermelon  \n",
       "135            other vegetables  \n",
       "136                 other crops  \n",
       "137                      rubber  \n",
       "138                   guar seed  \n",
       "139            misc. food crops  \n",
       "140        misc. non-food crops  \n",
       "141                      fodder  \n",
       "142                       grass  \n",
       "143                     mulbery  \n",
       "144                    mushroom  \n",
       "145                 by products  \n",
       "146              straw & stalks  \n",
       "147                      others  \n",
       "148              kitchen garden  \n",
       "149  value of output from crops  \n",
       "\n",
       "[143 rows x 16 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "process = data[7:]\n",
    "process"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "6         1\n",
       "7       1.1\n",
       "8       1.2\n",
       "9       1.3\n",
       "10      1.4\n",
       "11      1.5\n",
       "12      1.6\n",
       "13      1.7\n",
       "14      1.8\n",
       "15      1.9\n",
       "16        2\n",
       "17      2.1\n",
       "18      2.2\n",
       "19      2.3\n",
       "20      2.4\n",
       "21      2.5\n",
       "22      2.6\n",
       "23      2.7\n",
       "24      2.8\n",
       "25      2.9\n",
       "26     2.10\n",
       "27     2.11\n",
       "28     2.12\n",
       "29     2.13\n",
       "30     2.14\n",
       "31     2.15\n",
       "32        3\n",
       "33      3.1\n",
       "34      3.2\n",
       "35      3.3\n",
       "       ... \n",
       "120    9.37\n",
       "121    9.38\n",
       "122    9.39\n",
       "123    9.40\n",
       "124    9.41\n",
       "125    9.42\n",
       "126    9.43\n",
       "127    9.44\n",
       "128    9.45\n",
       "129    9.46\n",
       "130    9.47\n",
       "131    9.48\n",
       "132    9.49\n",
       "133    9.50\n",
       "134    9.51\n",
       "135    9.52\n",
       "136      10\n",
       "137    10.1\n",
       "138    10.2\n",
       "139    10.3\n",
       "140    10.4\n",
       "141    10.5\n",
       "142    10.6\n",
       "143    10.7\n",
       "144    10.8\n",
       "145      11\n",
       "146    11.1\n",
       "147    11.2\n",
       "148      12\n",
       "149      13\n",
       "Name: Unnamed: 0, Length: 144, dtype: object"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sections = process.iloc[:,0]\n",
    "sections"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RangeIndex(start=6, stop=150, step=1)"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sections.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "main_sections = [index for index in sections.index if sections[index].isdigit()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[6, 16, 32, 45, 49, 55, 56, 66, 83, 136, 145, 148, 149]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_sections"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "336359"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "[data.iloc[idx] for idx in main_sections][0].values[2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Unnamed: 2', 'Unnamed: 8']"
      ]
     },
     "execution_count": 16,
     "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": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "rows = [data.iloc[idx] for idx in main_sections]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "values = [row['Unnamed: 2'] for row in rows[0:-1]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "all_sum=sum(values)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "values = [value/all_sum*100 for value in values]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[28.23028108667937,\n",
       " 4.3769822985304865,\n",
       " 8.951365651041602,\n",
       " 6.382634078706956,\n",
       " 6.877479577971318,\n",
       " 0.007217895681264441,\n",
       " 3.2293368852094404,\n",
       " 3.894306507100815,\n",
       " 24.123466302079006,\n",
       " 7.719371573073221,\n",
       " 5.77893264108678]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "values[0:-1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['cereals',\n",
       " 'pulses',\n",
       " 'oilseeds',\n",
       " 'sugars',\n",
       " 'fibres',\n",
       " 'indigo, dyes & tanning material',\n",
       " 'drugs & narcotics',\n",
       " 'condiments & spices',\n",
       " 'fruits & vegetables',\n",
       " 'other crops',\n",
       " 'by products',\n",
       " 'kitchen garden']"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "[row.iloc[-1] for row in rows[0:-1]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>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>6</th>\n",
       "      <td>1</td>\n",
       "      <td>अनाज</td>\n",
       "      <td>336359</td>\n",
       "      <td>382040</td>\n",
       "      <td>422128</td>\n",
       "      <td>414083</td>\n",
       "      <td>431853</td>\n",
       "      <td>492925</td>\n",
       "      <td>336359</td>\n",
       "      <td>330465</td>\n",
       "      <td>340034</td>\n",
       "      <td>325937</td>\n",
       "      <td>325506</td>\n",
       "      <td>348623</td>\n",
       "      <td>1</td>\n",
       "      <td>cereals</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1.1</td>\n",
       "      <td>धान</td>\n",
       "      <td>170595</td>\n",
       "      <td>198266</td>\n",
       "      <td>220635</td>\n",
       "      <td>226644</td>\n",
       "      <td>228079</td>\n",
       "      <td>253902</td>\n",
       "      <td>170595</td>\n",
       "      <td>169773</td>\n",
       "      <td>172144</td>\n",
       "      <td>170272</td>\n",
       "      <td>168028</td>\n",
       "      <td>177655</td>\n",
       "      <td>1.1</td>\n",
       "      <td>paddy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1.2</td>\n",
       "      <td>गेहूँ</td>\n",
       "      <td>118068</td>\n",
       "      <td>131710</td>\n",
       "      <td>142561</td>\n",
       "      <td>129011</td>\n",
       "      <td>145939</td>\n",
       "      <td>165304</td>\n",
       "      <td>118068</td>\n",
       "      <td>115884</td>\n",
       "      <td>119051</td>\n",
       "      <td>107828</td>\n",
       "      <td>114880</td>\n",
       "      <td>122307</td>\n",
       "      <td>1.2</td>\n",
       "      <td>wheat</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1.3</td>\n",
       "      <td>ज्वार</td>\n",
       "      <td>9807</td>\n",
       "      <td>8133</td>\n",
       "      <td>9073</td>\n",
       "      <td>9917</td>\n",
       "      <td>7812</td>\n",
       "      <td>9203</td>\n",
       "      <td>9807</td>\n",
       "      <td>8540</td>\n",
       "      <td>9144</td>\n",
       "      <td>8839</td>\n",
       "      <td>6769</td>\n",
       "      <td>7296</td>\n",
       "      <td>1.3</td>\n",
       "      <td>jowar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1.4</td>\n",
       "      <td>बाजरा</td>\n",
       "      <td>9940</td>\n",
       "      <td>10858</td>\n",
       "      <td>11807</td>\n",
       "      <td>11345</td>\n",
       "      <td>11296</td>\n",
       "      <td>15901</td>\n",
       "      <td>9940</td>\n",
       "      <td>8309</td>\n",
       "      <td>8949</td>\n",
       "      <td>8678</td>\n",
       "      <td>7645</td>\n",
       "      <td>9284</td>\n",
       "      <td>1.4</td>\n",
       "      <td>bajra</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1.5</td>\n",
       "      <td>जौ</td>\n",
       "      <td>1901</td>\n",
       "      <td>2133</td>\n",
       "      <td>2254</td>\n",
       "      <td>2049</td>\n",
       "      <td>2098</td>\n",
       "      <td>3047</td>\n",
       "      <td>1901</td>\n",
       "      <td>2075</td>\n",
       "      <td>2164</td>\n",
       "      <td>1916</td>\n",
       "      <td>1677</td>\n",
       "      <td>2027</td>\n",
       "      <td>1.5</td>\n",
       "      <td>barley</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1.6</td>\n",
       "      <td>मक्का</td>\n",
       "      <td>23539</td>\n",
       "      <td>27952</td>\n",
       "      <td>31875</td>\n",
       "      <td>31182</td>\n",
       "      <td>33095</td>\n",
       "      <td>42034</td>\n",
       "      <td>23539</td>\n",
       "      <td>23742</td>\n",
       "      <td>26049</td>\n",
       "      <td>25844</td>\n",
       "      <td>24240</td>\n",
       "      <td>28203</td>\n",
       "      <td>1.6</td>\n",
       "      <td>maize</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1.7</td>\n",
       "      <td>रागी</td>\n",
       "      <td>2015</td>\n",
       "      <td>2455</td>\n",
       "      <td>3382</td>\n",
       "      <td>3438</td>\n",
       "      <td>3040</td>\n",
       "      <td>2884</td>\n",
       "      <td>2015</td>\n",
       "      <td>1651</td>\n",
       "      <td>2102</td>\n",
       "      <td>2160</td>\n",
       "      <td>1899</td>\n",
       "      <td>1461</td>\n",
       "      <td>1.7</td>\n",
       "      <td>ragi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1.8</td>\n",
       "      <td>छोटा बाजरा</td>\n",
       "      <td>413</td>\n",
       "      <td>427</td>\n",
       "      <td>467</td>\n",
       "      <td>429</td>\n",
       "      <td>424</td>\n",
       "      <td>563</td>\n",
       "      <td>413</td>\n",
       "      <td>399</td>\n",
       "      <td>374</td>\n",
       "      <td>349</td>\n",
       "      <td>315</td>\n",
       "      <td>339</td>\n",
       "      <td>1.8</td>\n",
       "      <td>small millets</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1.9</td>\n",
       "      <td>अन्य अनाज</td>\n",
       "      <td>81</td>\n",
       "      <td>106</td>\n",
       "      <td>73</td>\n",
       "      <td>68</td>\n",
       "      <td>71</td>\n",
       "      <td>87</td>\n",
       "      <td>81</td>\n",
       "      <td>91</td>\n",
       "      <td>57</td>\n",
       "      <td>51</td>\n",
       "      <td>52</td>\n",
       "      <td>51</td>\n",
       "      <td>1.9</td>\n",
       "      <td>other cereals</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2</td>\n",
       "      <td>दालें</td>\n",
       "      <td>52151</td>\n",
       "      <td>62394</td>\n",
       "      <td>68129</td>\n",
       "      <td>72966</td>\n",
       "      <td>94869</td>\n",
       "      <td>159862</td>\n",
       "      <td>52151</td>\n",
       "      <td>55032</td>\n",
       "      <td>58138</td>\n",
       "      <td>51624</td>\n",
       "      <td>49023</td>\n",
       "      <td>69564</td>\n",
       "      <td>2</td>\n",
       "      <td>pulses</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2.1</td>\n",
       "      <td>चना</td>\n",
       "      <td>21781</td>\n",
       "      <td>27801</td>\n",
       "      <td>28264</td>\n",
       "      <td>24435</td>\n",
       "      <td>33653</td>\n",
       "      <td>68651</td>\n",
       "      <td>21781</td>\n",
       "      <td>24693</td>\n",
       "      <td>26728</td>\n",
       "      <td>20449</td>\n",
       "      <td>19315</td>\n",
       "      <td>25525</td>\n",
       "      <td>2.1</td>\n",
       "      <td>gram</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2.2</td>\n",
       "      <td>अरहर</td>\n",
       "      <td>8976</td>\n",
       "      <td>11615</td>\n",
       "      <td>12979</td>\n",
       "      <td>14707</td>\n",
       "      <td>19814</td>\n",
       "      <td>34679</td>\n",
       "      <td>8976</td>\n",
       "      <td>10183</td>\n",
       "      <td>10641</td>\n",
       "      <td>9405</td>\n",
       "      <td>8584</td>\n",
       "      <td>16029</td>\n",
       "      <td>2.2</td>\n",
       "      <td>arhar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2.3</td>\n",
       "      <td>उड़द</td>\n",
       "      <td>6399</td>\n",
       "      <td>6986</td>\n",
       "      <td>7180</td>\n",
       "      <td>10398</td>\n",
       "      <td>15553</td>\n",
       "      <td>25012</td>\n",
       "      <td>6399</td>\n",
       "      <td>6858</td>\n",
       "      <td>6056</td>\n",
       "      <td>6889</td>\n",
       "      <td>6704</td>\n",
       "      <td>9627</td>\n",
       "      <td>2.3</td>\n",
       "      <td>urd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2.4</td>\n",
       "      <td>मूंग</td>\n",
       "      <td>5987</td>\n",
       "      <td>5142</td>\n",
       "      <td>8242</td>\n",
       "      <td>9474</td>\n",
       "      <td>10738</td>\n",
       "      <td>12079</td>\n",
       "      <td>5987</td>\n",
       "      <td>4305</td>\n",
       "      <td>5993</td>\n",
       "      <td>5605</td>\n",
       "      <td>5946</td>\n",
       "      <td>8078</td>\n",
       "      <td>2.4</td>\n",
       "      <td>moong</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2.5</td>\n",
       "      <td>मसूर</td>\n",
       "      <td>3582</td>\n",
       "      <td>4290</td>\n",
       "      <td>4253</td>\n",
       "      <td>5196</td>\n",
       "      <td>6138</td>\n",
       "      <td>7025</td>\n",
       "      <td>3582</td>\n",
       "      <td>3752</td>\n",
       "      <td>3392</td>\n",
       "      <td>3432</td>\n",
       "      <td>3240</td>\n",
       "      <td>3941</td>\n",
       "      <td>2.5</td>\n",
       "      <td>masoor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2.6</td>\n",
       "      <td>काला चना</td>\n",
       "      <td>395</td>\n",
       "      <td>546</td>\n",
       "      <td>690</td>\n",
       "      <td>758</td>\n",
       "      <td>697</td>\n",
       "      <td>997</td>\n",
       "      <td>395</td>\n",
       "      <td>375</td>\n",
       "      <td>444</td>\n",
       "      <td>496</td>\n",
       "      <td>422</td>\n",
       "      <td>514</td>\n",
       "      <td>2.6</td>\n",
       "      <td>horse gram</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2.7</td>\n",
       "      <td>मोठ</td>\n",
       "      <td>986</td>\n",
       "      <td>1074</td>\n",
       "      <td>1205</td>\n",
       "      <td>1822</td>\n",
       "      <td>1717</td>\n",
       "      <td>2456</td>\n",
       "      <td>986</td>\n",
       "      <td>536</td>\n",
       "      <td>629</td>\n",
       "      <td>716</td>\n",
       "      <td>666</td>\n",
       "      <td>810</td>\n",
       "      <td>2.7</td>\n",
       "      <td>moth</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2.8</td>\n",
       "      <td>वाल</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.8</td>\n",
       "      <td>val</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2.9</td>\n",
       "      <td>राजमा</td>\n",
       "      <td>69</td>\n",
       "      <td>74</td>\n",
       "      <td>185</td>\n",
       "      <td>174</td>\n",
       "      <td>154</td>\n",
       "      <td>192</td>\n",
       "      <td>69</td>\n",
       "      <td>76</td>\n",
       "      <td>128</td>\n",
       "      <td>117</td>\n",
       "      <td>95</td>\n",
       "      <td>116</td>\n",
       "      <td>2.9</td>\n",
       "      <td>rajma</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2.10</td>\n",
       "      <td>लोबिया</td>\n",
       "      <td>122</td>\n",
       "      <td>154</td>\n",
       "      <td>152</td>\n",
       "      <td>184</td>\n",
       "      <td>241</td>\n",
       "      <td>312</td>\n",
       "      <td>122</td>\n",
       "      <td>148</td>\n",
       "      <td>147</td>\n",
       "      <td>166</td>\n",
       "      <td>188</td>\n",
       "      <td>229</td>\n",
       "      <td>2.10</td>\n",
       "      <td>cowpea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2.11</td>\n",
       "      <td>छोला</td>\n",
       "      <td>124</td>\n",
       "      <td>99</td>\n",
       "      <td>122</td>\n",
       "      <td>151</td>\n",
       "      <td>137</td>\n",
       "      <td>196</td>\n",
       "      <td>124</td>\n",
       "      <td>42</td>\n",
       "      <td>57</td>\n",
       "      <td>66</td>\n",
       "      <td>52</td>\n",
       "      <td>63</td>\n",
       "      <td>2.11</td>\n",
       "      <td>chola</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2.12</td>\n",
       "      <td>लाख / खेसरी</td>\n",
       "      <td>718</td>\n",
       "      <td>890</td>\n",
       "      <td>679</td>\n",
       "      <td>1100</td>\n",
       "      <td>1086</td>\n",
       "      <td>1553</td>\n",
       "      <td>718</td>\n",
       "      <td>843</td>\n",
       "      <td>609</td>\n",
       "      <td>978</td>\n",
       "      <td>726</td>\n",
       "      <td>883</td>\n",
       "      <td>2.12</td>\n",
       "      <td>lakh/khesri</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2.13</td>\n",
       "      <td>मटर / चौलाई/चवली</td>\n",
       "      <td>1769</td>\n",
       "      <td>2433</td>\n",
       "      <td>2715</td>\n",
       "      <td>2884</td>\n",
       "      <td>2562</td>\n",
       "      <td>3316</td>\n",
       "      <td>1769</td>\n",
       "      <td>2077</td>\n",
       "      <td>2130</td>\n",
       "      <td>2175</td>\n",
       "      <td>1875</td>\n",
       "      <td>2281</td>\n",
       "      <td>2.13</td>\n",
       "      <td>peas/chawali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2.14</td>\n",
       "      <td>बटना</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>39</td>\n",
       "      <td>48</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>33</td>\n",
       "      <td>2.14</td>\n",
       "      <td>batna</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2.15</td>\n",
       "      <td>अन्‍य दालें</td>\n",
       "      <td>1242</td>\n",
       "      <td>1290</td>\n",
       "      <td>1464</td>\n",
       "      <td>1645</td>\n",
       "      <td>2340</td>\n",
       "      <td>3347</td>\n",
       "      <td>1242</td>\n",
       "      <td>1143</td>\n",
       "      <td>1184</td>\n",
       "      <td>1102</td>\n",
       "      <td>1181</td>\n",
       "      <td>1437</td>\n",
       "      <td>2.15</td>\n",
       "      <td>others pulses</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>3</td>\n",
       "      <td>तिलहन</td>\n",
       "      <td>106654</td>\n",
       "      <td>113958</td>\n",
       "      <td>132506</td>\n",
       "      <td>126775</td>\n",
       "      <td>123501</td>\n",
       "      <td>149417</td>\n",
       "      <td>106654</td>\n",
       "      <td>104137</td>\n",
       "      <td>112420</td>\n",
       "      <td>97326</td>\n",
       "      <td>92977</td>\n",
       "      <td>111115</td>\n",
       "      <td>3</td>\n",
       "      <td>oilseeds</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>3.1</td>\n",
       "      <td>अलसी</td>\n",
       "      <td>517</td>\n",
       "      <td>632</td>\n",
       "      <td>524</td>\n",
       "      <td>594</td>\n",
       "      <td>490</td>\n",
       "      <td>763</td>\n",
       "      <td>517</td>\n",
       "      <td>517</td>\n",
       "      <td>404</td>\n",
       "      <td>435</td>\n",
       "      <td>355</td>\n",
       "      <td>437</td>\n",
       "      <td>3.1</td>\n",
       "      <td>linseed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>3.2</td>\n",
       "      <td>तिल</td>\n",
       "      <td>3649</td>\n",
       "      <td>4098</td>\n",
       "      <td>5978</td>\n",
       "      <td>6285</td>\n",
       "      <td>5158</td>\n",
       "      <td>5079</td>\n",
       "      <td>3649</td>\n",
       "      <td>2883</td>\n",
       "      <td>2998</td>\n",
       "      <td>3464</td>\n",
       "      <td>3607</td>\n",
       "      <td>3327</td>\n",
       "      <td>3.2</td>\n",
       "      <td>sesamum</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>3.3</td>\n",
       "      <td>मूंगफली</td>\n",
       "      <td>24500</td>\n",
       "      <td>20486</td>\n",
       "      <td>35549</td>\n",
       "      <td>29636</td>\n",
       "      <td>30281</td>\n",
       "      <td>36763</td>\n",
       "      <td>24500</td>\n",
       "      <td>16252</td>\n",
       "      <td>34344</td>\n",
       "      <td>25744</td>\n",
       "      <td>23424</td>\n",
       "      <td>26319</td>\n",
       "      <td>3.3</td>\n",
       "      <td>groundnut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>9.37</td>\n",
       "      <td>भिंडी</td>\n",
       "      <td>10700</td>\n",
       "      <td>11372</td>\n",
       "      <td>12765</td>\n",
       "      <td>12556</td>\n",
       "      <td>11993</td>\n",
       "      <td>12134</td>\n",
       "      <td>10700</td>\n",
       "      <td>10748</td>\n",
       "      <td>10451</td>\n",
       "      <td>9715</td>\n",
       "      <td>9897</td>\n",
       "      <td>10158</td>\n",
       "      <td>9.37</td>\n",
       "      <td>okra</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>9.38</td>\n",
       "      <td>टमाटर</td>\n",
       "      <td>20302</td>\n",
       "      <td>20830</td>\n",
       "      <td>27322</td>\n",
       "      <td>26141</td>\n",
       "      <td>30656</td>\n",
       "      <td>25691</td>\n",
       "      <td>20302</td>\n",
       "      <td>20118</td>\n",
       "      <td>20348</td>\n",
       "      <td>18274</td>\n",
       "      <td>20772</td>\n",
       "      <td>22964</td>\n",
       "      <td>9.38</td>\n",
       "      <td>tomato</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>9.39</td>\n",
       "      <td>सहजन की फली</td>\n",
       "      <td>1938</td>\n",
       "      <td>1831</td>\n",
       "      <td>3269</td>\n",
       "      <td>4399</td>\n",
       "      <td>4809</td>\n",
       "      <td>4999</td>\n",
       "      <td>1938</td>\n",
       "      <td>1831</td>\n",
       "      <td>2458</td>\n",
       "      <td>2828</td>\n",
       "      <td>2956</td>\n",
       "      <td>3113</td>\n",
       "      <td>9.39</td>\n",
       "      <td>drum sticks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>9.40</td>\n",
       "      <td>हरी मटर</td>\n",
       "      <td>6612</td>\n",
       "      <td>8017</td>\n",
       "      <td>8499</td>\n",
       "      <td>12635</td>\n",
       "      <td>11997</td>\n",
       "      <td>12112</td>\n",
       "      <td>6612</td>\n",
       "      <td>7122</td>\n",
       "      <td>6589</td>\n",
       "      <td>7490</td>\n",
       "      <td>7961</td>\n",
       "      <td>8844</td>\n",
       "      <td>9.40</td>\n",
       "      <td>green peas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>9.41</td>\n",
       "      <td>फलियां</td>\n",
       "      <td>2961</td>\n",
       "      <td>3878</td>\n",
       "      <td>4583</td>\n",
       "      <td>5873</td>\n",
       "      <td>7086</td>\n",
       "      <td>6361</td>\n",
       "      <td>2961</td>\n",
       "      <td>3172</td>\n",
       "      <td>3321</td>\n",
       "      <td>4338</td>\n",
       "      <td>4532</td>\n",
       "      <td>3907</td>\n",
       "      <td>9.41</td>\n",
       "      <td>beans</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>9.42</td>\n",
       "      <td>करेला</td>\n",
       "      <td>1342</td>\n",
       "      <td>1590</td>\n",
       "      <td>1552</td>\n",
       "      <td>1748</td>\n",
       "      <td>2388</td>\n",
       "      <td>3142</td>\n",
       "      <td>1342</td>\n",
       "      <td>1455</td>\n",
       "      <td>1275</td>\n",
       "      <td>1239</td>\n",
       "      <td>1600</td>\n",
       "      <td>1576</td>\n",
       "      <td>9.42</td>\n",
       "      <td>bittergourd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>9.43</td>\n",
       "      <td>लौकी</td>\n",
       "      <td>1512</td>\n",
       "      <td>1550</td>\n",
       "      <td>1763</td>\n",
       "      <td>1870</td>\n",
       "      <td>2327</td>\n",
       "      <td>2235</td>\n",
       "      <td>1512</td>\n",
       "      <td>1622</td>\n",
       "      <td>1376</td>\n",
       "      <td>1372</td>\n",
       "      <td>1762</td>\n",
       "      <td>1813</td>\n",
       "      <td>9.43</td>\n",
       "      <td>bottlegourd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>9.44</td>\n",
       "      <td>शिमला मिर्च</td>\n",
       "      <td>227</td>\n",
       "      <td>324</td>\n",
       "      <td>299</td>\n",
       "      <td>323</td>\n",
       "      <td>549</td>\n",
       "      <td>553</td>\n",
       "      <td>227</td>\n",
       "      <td>268</td>\n",
       "      <td>250</td>\n",
       "      <td>269</td>\n",
       "      <td>453</td>\n",
       "      <td>481</td>\n",
       "      <td>9.44</td>\n",
       "      <td>capsicum</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>9.45</td>\n",
       "      <td>गाजर</td>\n",
       "      <td>1239</td>\n",
       "      <td>1237</td>\n",
       "      <td>1366</td>\n",
       "      <td>1467</td>\n",
       "      <td>1803</td>\n",
       "      <td>1534</td>\n",
       "      <td>1239</td>\n",
       "      <td>1223</td>\n",
       "      <td>1178</td>\n",
       "      <td>1014</td>\n",
       "      <td>1251</td>\n",
       "      <td>1262</td>\n",
       "      <td>9.45</td>\n",
       "      <td>carrot</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>9.46</td>\n",
       "      <td>खीरा</td>\n",
       "      <td>559</td>\n",
       "      <td>621</td>\n",
       "      <td>730</td>\n",
       "      <td>835</td>\n",
       "      <td>1511</td>\n",
       "      <td>1591</td>\n",
       "      <td>559</td>\n",
       "      <td>606</td>\n",
       "      <td>573</td>\n",
       "      <td>579</td>\n",
       "      <td>1009</td>\n",
       "      <td>958</td>\n",
       "      <td>9.46</td>\n",
       "      <td>cucumber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>9.47</td>\n",
       "      <td>खरबूजा</td>\n",
       "      <td>657</td>\n",
       "      <td>695</td>\n",
       "      <td>728</td>\n",
       "      <td>767</td>\n",
       "      <td>924</td>\n",
       "      <td>1150</td>\n",
       "      <td>657</td>\n",
       "      <td>715</td>\n",
       "      <td>629</td>\n",
       "      <td>678</td>\n",
       "      <td>724</td>\n",
       "      <td>850</td>\n",
       "      <td>9.47</td>\n",
       "      <td>muskmelon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>9.48</td>\n",
       "      <td>परमल</td>\n",
       "      <td>47</td>\n",
       "      <td>259</td>\n",
       "      <td>341</td>\n",
       "      <td>670</td>\n",
       "      <td>519</td>\n",
       "      <td>563</td>\n",
       "      <td>47</td>\n",
       "      <td>226</td>\n",
       "      <td>245</td>\n",
       "      <td>470</td>\n",
       "      <td>328</td>\n",
       "      <td>333</td>\n",
       "      <td>9.48</td>\n",
       "      <td>parmal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>9.49</td>\n",
       "      <td>मूली</td>\n",
       "      <td>2477</td>\n",
       "      <td>2695</td>\n",
       "      <td>3232</td>\n",
       "      <td>3065</td>\n",
       "      <td>3479</td>\n",
       "      <td>4111</td>\n",
       "      <td>2477</td>\n",
       "      <td>2598</td>\n",
       "      <td>2645</td>\n",
       "      <td>2433</td>\n",
       "      <td>2657</td>\n",
       "      <td>2707</td>\n",
       "      <td>9.49</td>\n",
       "      <td>radish</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>9.50</td>\n",
       "      <td>कद्दू</td>\n",
       "      <td>255</td>\n",
       "      <td>322</td>\n",
       "      <td>366</td>\n",
       "      <td>1319</td>\n",
       "      <td>1643</td>\n",
       "      <td>2145</td>\n",
       "      <td>255</td>\n",
       "      <td>317</td>\n",
       "      <td>288</td>\n",
       "      <td>1008</td>\n",
       "      <td>1369</td>\n",
       "      <td>1509</td>\n",
       "      <td>9.50</td>\n",
       "      <td>pumpkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>9.51</td>\n",
       "      <td>तरबूज</td>\n",
       "      <td>2612</td>\n",
       "      <td>2799</td>\n",
       "      <td>3372</td>\n",
       "      <td>4013</td>\n",
       "      <td>4115</td>\n",
       "      <td>4093</td>\n",
       "      <td>2612</td>\n",
       "      <td>2728</td>\n",
       "      <td>2759</td>\n",
       "      <td>2919</td>\n",
       "      <td>3423</td>\n",
       "      <td>3212</td>\n",
       "      <td>9.51</td>\n",
       "      <td>watermelon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>9.52</td>\n",
       "      <td>अन्य सब्जियां</td>\n",
       "      <td>20581</td>\n",
       "      <td>24381</td>\n",
       "      <td>31645</td>\n",
       "      <td>42577</td>\n",
       "      <td>41903</td>\n",
       "      <td>37679</td>\n",
       "      <td>20581</td>\n",
       "      <td>21865</td>\n",
       "      <td>22572</td>\n",
       "      <td>27487</td>\n",
       "      <td>28549</td>\n",
       "      <td>27103</td>\n",
       "      <td>9.52</td>\n",
       "      <td>other vegetables</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>10</td>\n",
       "      <td>अन्य फसलें</td>\n",
       "      <td>91975</td>\n",
       "      <td>98494</td>\n",
       "      <td>104961</td>\n",
       "      <td>98236</td>\n",
       "      <td>99278</td>\n",
       "      <td>97122</td>\n",
       "      <td>91975</td>\n",
       "      <td>94805</td>\n",
       "      <td>103127</td>\n",
       "      <td>97607</td>\n",
       "      <td>92349</td>\n",
       "      <td>86752</td>\n",
       "      <td>10</td>\n",
       "      <td>other crops</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>10.1</td>\n",
       "      <td>रबर</td>\n",
       "      <td>17164</td>\n",
       "      <td>14422</td>\n",
       "      <td>11464</td>\n",
       "      <td>7319</td>\n",
       "      <td>5483</td>\n",
       "      <td>8035</td>\n",
       "      <td>17164</td>\n",
       "      <td>17259</td>\n",
       "      <td>14448</td>\n",
       "      <td>11820</td>\n",
       "      <td>10225</td>\n",
       "      <td>12572</td>\n",
       "      <td>10.1</td>\n",
       "      <td>rubber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>10.2</td>\n",
       "      <td>ग्वार बीज</td>\n",
       "      <td>22296</td>\n",
       "      <td>25398</td>\n",
       "      <td>30172</td>\n",
       "      <td>22230</td>\n",
       "      <td>17620</td>\n",
       "      <td>10916</td>\n",
       "      <td>22296</td>\n",
       "      <td>25345</td>\n",
       "      <td>37400</td>\n",
       "      <td>34075</td>\n",
       "      <td>28409</td>\n",
       "      <td>19994</td>\n",
       "      <td>10.2</td>\n",
       "      <td>guar seed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>10.3</td>\n",
       "      <td>विविध खाद्य फसलें</td>\n",
       "      <td>72</td>\n",
       "      <td>31</td>\n",
       "      <td>30</td>\n",
       "      <td>26</td>\n",
       "      <td>27</td>\n",
       "      <td>30</td>\n",
       "      <td>72</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>10.3</td>\n",
       "      <td>misc. food crops</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>10.4</td>\n",
       "      <td>विविध गैर खाद्य फसलें</td>\n",
       "      <td>1586</td>\n",
       "      <td>714</td>\n",
       "      <td>1223</td>\n",
       "      <td>1229</td>\n",
       "      <td>1251</td>\n",
       "      <td>1270</td>\n",
       "      <td>1586</td>\n",
       "      <td>1560</td>\n",
       "      <td>1553</td>\n",
       "      <td>1575</td>\n",
       "      <td>1603</td>\n",
       "      <td>1603</td>\n",
       "      <td>10.4</td>\n",
       "      <td>misc. non-food crops</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>10.5</td>\n",
       "      <td>चारा</td>\n",
       "      <td>32494</td>\n",
       "      <td>37161</td>\n",
       "      <td>39422</td>\n",
       "      <td>43562</td>\n",
       "      <td>46603</td>\n",
       "      <td>47980</td>\n",
       "      <td>32494</td>\n",
       "      <td>32372</td>\n",
       "      <td>31636</td>\n",
       "      <td>31822</td>\n",
       "      <td>31544</td>\n",
       "      <td>31845</td>\n",
       "      <td>10.5</td>\n",
       "      <td>fodder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>10.6</td>\n",
       "      <td>घास</td>\n",
       "      <td>17837</td>\n",
       "      <td>20389</td>\n",
       "      <td>22312</td>\n",
       "      <td>23409</td>\n",
       "      <td>25529</td>\n",
       "      <td>26230</td>\n",
       "      <td>17837</td>\n",
       "      <td>17914</td>\n",
       "      <td>17773</td>\n",
       "      <td>17920</td>\n",
       "      <td>18146</td>\n",
       "      <td>18281</td>\n",
       "      <td>10.6</td>\n",
       "      <td>grass</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>10.7</td>\n",
       "      <td>शहतूत</td>\n",
       "      <td>37</td>\n",
       "      <td>40</td>\n",
       "      <td>43</td>\n",
       "      <td>48</td>\n",
       "      <td>48</td>\n",
       "      <td>53</td>\n",
       "      <td>37</td>\n",
       "      <td>39</td>\n",
       "      <td>42</td>\n",
       "      <td>48</td>\n",
       "      <td>48</td>\n",
       "      <td>52</td>\n",
       "      <td>10.7</td>\n",
       "      <td>mulbery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>10.8</td>\n",
       "      <td>मशरूम</td>\n",
       "      <td>487</td>\n",
       "      <td>339</td>\n",
       "      <td>295</td>\n",
       "      <td>413</td>\n",
       "      <td>2718</td>\n",
       "      <td>2607</td>\n",
       "      <td>487</td>\n",
       "      <td>291</td>\n",
       "      <td>248</td>\n",
       "      <td>327</td>\n",
       "      <td>2354</td>\n",
       "      <td>2384</td>\n",
       "      <td>10.8</td>\n",
       "      <td>mushroom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>11</td>\n",
       "      <td>उपोत्‍पाद</td>\n",
       "      <td>68855</td>\n",
       "      <td>73937</td>\n",
       "      <td>86140</td>\n",
       "      <td>91553</td>\n",
       "      <td>93825</td>\n",
       "      <td>98557</td>\n",
       "      <td>68855</td>\n",
       "      <td>66885</td>\n",
       "      <td>68556</td>\n",
       "      <td>68765</td>\n",
       "      <td>67289</td>\n",
       "      <td>66669</td>\n",
       "      <td>11</td>\n",
       "      <td>by products</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>11.1</td>\n",
       "      <td>भूसा व डंठल</td>\n",
       "      <td>60887</td>\n",
       "      <td>65593</td>\n",
       "      <td>77014</td>\n",
       "      <td>82233</td>\n",
       "      <td>84492</td>\n",
       "      <td>89354</td>\n",
       "      <td>60887</td>\n",
       "      <td>59131</td>\n",
       "      <td>60712</td>\n",
       "      <td>60999</td>\n",
       "      <td>59662</td>\n",
       "      <td>59149</td>\n",
       "      <td>11.1</td>\n",
       "      <td>straw &amp; stalks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>11.2</td>\n",
       "      <td>अन्‍य</td>\n",
       "      <td>7968</td>\n",
       "      <td>8343</td>\n",
       "      <td>9127</td>\n",
       "      <td>9321</td>\n",
       "      <td>9334</td>\n",
       "      <td>9203</td>\n",
       "      <td>7968</td>\n",
       "      <td>7754</td>\n",
       "      <td>7844</td>\n",
       "      <td>7766</td>\n",
       "      <td>7626</td>\n",
       "      <td>7520</td>\n",
       "      <td>11.2</td>\n",
       "      <td>others</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>12</td>\n",
       "      <td>रसोई बागवानी</td>\n",
       "      <td>5107</td>\n",
       "      <td>6097</td>\n",
       "      <td>7295</td>\n",
       "      <td>8444</td>\n",
       "      <td>8058</td>\n",
       "      <td>8578</td>\n",
       "      <td>5107</td>\n",
       "      <td>5400</td>\n",
       "      <td>5501</td>\n",
       "      <td>5731</td>\n",
       "      <td>5529</td>\n",
       "      <td>5907</td>\n",
       "      <td>12</td>\n",
       "      <td>kitchen garden</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>13</td>\n",
       "      <td>फसलों से उत्पादन का मूल्य</td>\n",
       "      <td>1191483</td>\n",
       "      <td>1329582</td>\n",
       "      <td>1533426</td>\n",
       "      <td>1595498</td>\n",
       "      <td>1639523</td>\n",
       "      <td>1863390</td>\n",
       "      <td>1191483</td>\n",
       "      <td>1198611</td>\n",
       "      <td>1257133</td>\n",
       "      <td>1228006</td>\n",
       "      <td>1203146</td>\n",
       "      <td>1278398</td>\n",
       "      <td>13</td>\n",
       "      <td>value of output from crops</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>144 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Unnamed: 0                 Unnamed: 1 Unnamed: 2 Unnamed: 3 Unnamed: 4  \\\n",
       "6            1                       अनाज     336359     382040     422128   \n",
       "7          1.1                        धान     170595     198266     220635   \n",
       "8          1.2                      गेहूँ     118068     131710     142561   \n",
       "9          1.3                      ज्वार       9807       8133       9073   \n",
       "10         1.4                      बाजरा       9940      10858      11807   \n",
       "11         1.5                         जौ       1901       2133       2254   \n",
       "12         1.6                      मक्का      23539      27952      31875   \n",
       "13         1.7                       रागी       2015       2455       3382   \n",
       "14         1.8                 छोटा बाजरा        413        427        467   \n",
       "15         1.9                  अन्य अनाज         81        106         73   \n",
       "16           2                      दालें      52151      62394      68129   \n",
       "17         2.1                        चना      21781      27801      28264   \n",
       "18         2.2                       अरहर       8976      11615      12979   \n",
       "19         2.3                       उड़द       6399       6986       7180   \n",
       "20         2.4                       मूंग       5987       5142       8242   \n",
       "21         2.5                       मसूर       3582       4290       4253   \n",
       "22         2.6                   काला चना        395        546        690   \n",
       "23         2.7                        मोठ        986       1074       1205   \n",
       "24         2.8                        वाल          0          0          0   \n",
       "25         2.9                      राजमा         69         74        185   \n",
       "26        2.10                     लोबिया        122        154        152   \n",
       "27        2.11                       छोला        124         99        122   \n",
       "28        2.12                लाख / खेसरी        718        890        679   \n",
       "29        2.13           मटर / चौलाई/चवली       1769       2433       2715   \n",
       "30        2.14                       बटना          0          0          0   \n",
       "31        2.15                अन्‍य दालें       1242       1290       1464   \n",
       "32           3                      तिलहन     106654     113958     132506   \n",
       "33         3.1                       अलसी        517        632        524   \n",
       "34         3.2                        तिल       3649       4098       5978   \n",
       "35         3.3                    मूंगफली      24500      20486      35549   \n",
       "..         ...                        ...        ...        ...        ...   \n",
       "120       9.37                      भिंडी      10700      11372      12765   \n",
       "121       9.38                      टमाटर      20302      20830      27322   \n",
       "122       9.39                सहजन की फली       1938       1831       3269   \n",
       "123       9.40                    हरी मटर       6612       8017       8499   \n",
       "124       9.41                     फलियां       2961       3878       4583   \n",
       "125       9.42                      करेला       1342       1590       1552   \n",
       "126       9.43                       लौकी       1512       1550       1763   \n",
       "127       9.44                शिमला मिर्च        227        324        299   \n",
       "128       9.45                       गाजर       1239       1237       1366   \n",
       "129       9.46                       खीरा        559        621        730   \n",
       "130       9.47                     खरबूजा        657        695        728   \n",
       "131       9.48                       परमल         47        259        341   \n",
       "132       9.49                       मूली       2477       2695       3232   \n",
       "133       9.50                      कद्दू        255        322        366   \n",
       "134       9.51                      तरबूज       2612       2799       3372   \n",
       "135       9.52              अन्य सब्जियां      20581      24381      31645   \n",
       "136         10                 अन्य फसलें      91975      98494     104961   \n",
       "137       10.1                        रबर      17164      14422      11464   \n",
       "138       10.2                  ग्वार बीज      22296      25398      30172   \n",
       "139       10.3          विविध खाद्य फसलें         72         31         30   \n",
       "140       10.4      विविध गैर खाद्य फसलें       1586        714       1223   \n",
       "141       10.5                       चारा      32494      37161      39422   \n",
       "142       10.6                        घास      17837      20389      22312   \n",
       "143       10.7                      शहतूत         37         40         43   \n",
       "144       10.8                      मशरूम        487        339        295   \n",
       "145         11                  उपोत्‍पाद      68855      73937      86140   \n",
       "146       11.1                भूसा व डंठल      60887      65593      77014   \n",
       "147       11.2                      अन्‍य       7968       8343       9127   \n",
       "148         12               रसोई बागवानी       5107       6097       7295   \n",
       "149         13  फसलों से उत्पादन का मूल्य    1191483    1329582    1533426   \n",
       "\n",
       "    Unnamed: 5 Unnamed: 6 Unnamed: 7 Unnamed: 8 Unnamed: 9 Unnamed: 10  \\\n",
       "6       414083     431853     492925     336359     330465      340034   \n",
       "7       226644     228079     253902     170595     169773      172144   \n",
       "8       129011     145939     165304     118068     115884      119051   \n",
       "9         9917       7812       9203       9807       8540        9144   \n",
       "10       11345      11296      15901       9940       8309        8949   \n",
       "11        2049       2098       3047       1901       2075        2164   \n",
       "12       31182      33095      42034      23539      23742       26049   \n",
       "13        3438       3040       2884       2015       1651        2102   \n",
       "14         429        424        563        413        399         374   \n",
       "15          68         71         87         81         91          57   \n",
       "16       72966      94869     159862      52151      55032       58138   \n",
       "17       24435      33653      68651      21781      24693       26728   \n",
       "18       14707      19814      34679       8976      10183       10641   \n",
       "19       10398      15553      25012       6399       6858        6056   \n",
       "20        9474      10738      12079       5987       4305        5993   \n",
       "21        5196       6138       7025       3582       3752        3392   \n",
       "22         758        697        997        395        375         444   \n",
       "23        1822       1717       2456        986        536         629   \n",
       "24           0          0          0          0          0           0   \n",
       "25         174        154        192         69         76         128   \n",
       "26         184        241        312        122        148         147   \n",
       "27         151        137        196        124         42          57   \n",
       "28        1100       1086       1553        718        843         609   \n",
       "29        2884       2562       3316       1769       2077        2130   \n",
       "30          38         39         48          0          0           0   \n",
       "31        1645       2340       3347       1242       1143        1184   \n",
       "32      126775     123501     149417     106654     104137      112420   \n",
       "33         594        490        763        517        517         404   \n",
       "34        6285       5158       5079       3649       2883        2998   \n",
       "35       29636      30281      36763      24500      16252       34344   \n",
       "..         ...        ...        ...        ...        ...         ...   \n",
       "120      12556      11993      12134      10700      10748       10451   \n",
       "121      26141      30656      25691      20302      20118       20348   \n",
       "122       4399       4809       4999       1938       1831        2458   \n",
       "123      12635      11997      12112       6612       7122        6589   \n",
       "124       5873       7086       6361       2961       3172        3321   \n",
       "125       1748       2388       3142       1342       1455        1275   \n",
       "126       1870       2327       2235       1512       1622        1376   \n",
       "127        323        549        553        227        268         250   \n",
       "128       1467       1803       1534       1239       1223        1178   \n",
       "129        835       1511       1591        559        606         573   \n",
       "130        767        924       1150        657        715         629   \n",
       "131        670        519        563         47        226         245   \n",
       "132       3065       3479       4111       2477       2598        2645   \n",
       "133       1319       1643       2145        255        317         288   \n",
       "134       4013       4115       4093       2612       2728        2759   \n",
       "135      42577      41903      37679      20581      21865       22572   \n",
       "136      98236      99278      97122      91975      94805      103127   \n",
       "137       7319       5483       8035      17164      17259       14448   \n",
       "138      22230      17620      10916      22296      25345       37400   \n",
       "139         26         27         30         72         26          26   \n",
       "140       1229       1251       1270       1586       1560        1553   \n",
       "141      43562      46603      47980      32494      32372       31636   \n",
       "142      23409      25529      26230      17837      17914       17773   \n",
       "143         48         48         53         37         39          42   \n",
       "144        413       2718       2607        487        291         248   \n",
       "145      91553      93825      98557      68855      66885       68556   \n",
       "146      82233      84492      89354      60887      59131       60712   \n",
       "147       9321       9334       9203       7968       7754        7844   \n",
       "148       8444       8058       8578       5107       5400        5501   \n",
       "149    1595498    1639523    1863390    1191483    1198611     1257133   \n",
       "\n",
       "    Unnamed: 11 Unnamed: 12 Unnamed: 13 Unnamed: 14  \\\n",
       "6        325937      325506      348623           1   \n",
       "7        170272      168028      177655         1.1   \n",
       "8        107828      114880      122307         1.2   \n",
       "9          8839        6769        7296         1.3   \n",
       "10         8678        7645        9284         1.4   \n",
       "11         1916        1677        2027         1.5   \n",
       "12        25844       24240       28203         1.6   \n",
       "13         2160        1899        1461         1.7   \n",
       "14          349         315         339         1.8   \n",
       "15           51          52          51         1.9   \n",
       "16        51624       49023       69564           2   \n",
       "17        20449       19315       25525         2.1   \n",
       "18         9405        8584       16029         2.2   \n",
       "19         6889        6704        9627         2.3   \n",
       "20         5605        5946        8078         2.4   \n",
       "21         3432        3240        3941         2.5   \n",
       "22          496         422         514         2.6   \n",
       "23          716         666         810         2.7   \n",
       "24            0           0           0         2.8   \n",
       "25          117          95         116         2.9   \n",
       "26          166         188         229        2.10   \n",
       "27           66          52          63        2.11   \n",
       "28          978         726         883        2.12   \n",
       "29         2175        1875        2281        2.13   \n",
       "30           27          27          33        2.14   \n",
       "31         1102        1181        1437        2.15   \n",
       "32        97326       92977      111115           3   \n",
       "33          435         355         437         3.1   \n",
       "34         3464        3607        3327         3.2   \n",
       "35        25744       23424       26319         3.3   \n",
       "..          ...         ...         ...         ...   \n",
       "120        9715        9897       10158        9.37   \n",
       "121       18274       20772       22964        9.38   \n",
       "122        2828        2956        3113        9.39   \n",
       "123        7490        7961        8844        9.40   \n",
       "124        4338        4532        3907        9.41   \n",
       "125        1239        1600        1576        9.42   \n",
       "126        1372        1762        1813        9.43   \n",
       "127         269         453         481        9.44   \n",
       "128        1014        1251        1262        9.45   \n",
       "129         579        1009         958        9.46   \n",
       "130         678         724         850        9.47   \n",
       "131         470         328         333        9.48   \n",
       "132        2433        2657        2707        9.49   \n",
       "133        1008        1369        1509        9.50   \n",
       "134        2919        3423        3212        9.51   \n",
       "135       27487       28549       27103        9.52   \n",
       "136       97607       92349       86752          10   \n",
       "137       11820       10225       12572        10.1   \n",
       "138       34075       28409       19994        10.2   \n",
       "139          21          21          21        10.3   \n",
       "140        1575        1603        1603        10.4   \n",
       "141       31822       31544       31845        10.5   \n",
       "142       17920       18146       18281        10.6   \n",
       "143          48          48          52        10.7   \n",
       "144         327        2354        2384        10.8   \n",
       "145       68765       67289       66669          11   \n",
       "146       60999       59662       59149        11.1   \n",
       "147        7766        7626        7520        11.2   \n",
       "148        5731        5529        5907          12   \n",
       "149     1228006     1203146     1278398          13   \n",
       "\n",
       "                    Unnamed: 15  \n",
       "6                       cereals  \n",
       "7                         paddy  \n",
       "8                         wheat  \n",
       "9                         jowar  \n",
       "10                        bajra  \n",
       "11                       barley  \n",
       "12                        maize  \n",
       "13                         ragi  \n",
       "14                small millets  \n",
       "15                other cereals  \n",
       "16                       pulses  \n",
       "17                         gram  \n",
       "18                        arhar  \n",
       "19                          urd  \n",
       "20                        moong  \n",
       "21                       masoor  \n",
       "22                   horse gram  \n",
       "23                         moth  \n",
       "24                          val  \n",
       "25                        rajma  \n",
       "26                       cowpea  \n",
       "27                        chola  \n",
       "28                  lakh/khesri  \n",
       "29                 peas/chawali  \n",
       "30                        batna  \n",
       "31                others pulses  \n",
       "32                     oilseeds  \n",
       "33                      linseed  \n",
       "34                      sesamum  \n",
       "35                    groundnut  \n",
       "..                          ...  \n",
       "120                        okra  \n",
       "121                      tomato  \n",
       "122                 drum sticks  \n",
       "123                  green peas  \n",
       "124                       beans  \n",
       "125                 bittergourd  \n",
       "126                 bottlegourd  \n",
       "127                    capsicum  \n",
       "128                      carrot  \n",
       "129                    cucumber  \n",
       "130                   muskmelon  \n",
       "131                      parmal  \n",
       "132                      radish  \n",
       "133                     pumpkin  \n",
       "134                  watermelon  \n",
       "135            other vegetables  \n",
       "136                 other crops  \n",
       "137                      rubber  \n",
       "138                   guar seed  \n",
       "139            misc. food crops  \n",
       "140        misc. non-food crops  \n",
       "141                      fodder  \n",
       "142                       grass  \n",
       "143                     mulbery  \n",
       "144                    mushroom  \n",
       "145                 by products  \n",
       "146              straw & stalks  \n",
       "147                      others  \n",
       "148              kitchen garden  \n",
       "149  value of output from crops  \n",
       "\n",
       "[144 rows x 16 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "process"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['linseed',\n",
       " 'sesamum',\n",
       " 'groundnut',\n",
       " 'rapseed & mustard',\n",
       " 'castor',\n",
       " 'coconut',\n",
       " 'niger seed',\n",
       " 'safflower',\n",
       " 'sunflower',\n",
       " 'soyabean',\n",
       " 'taramira',\n",
       " 'other ']"
      ]
     },
     "execution_count": 25,
     "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.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}