Pivoting Notebook.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import sklearn\n",
    "import json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 146,
   "metadata": {},
   "outputs": [],
   "source": [
    "commodities = pd.read_json('./datasets/export_commodities_by_sea.json')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "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>S.No</th>\n",
       "      <th>Commodity Group</th>\n",
       "      <th>Name of the Country</th>\n",
       "      <th>Value (Rs. in Crores)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Italy</td>\n",
       "      <td>550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>386</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>US</td>\n",
       "      <td>366</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>UK</td>\n",
       "      <td>293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Columbia</td>\n",
       "      <td>251</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Greece</td>\n",
       "      <td>228</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Germany</td>\n",
       "      <td>224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Netherland</td>\n",
       "      <td>185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Thailand</td>\n",
       "      <td>184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Singapore</td>\n",
       "      <td>146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Korea</td>\n",
       "      <td>139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>France</td>\n",
       "      <td>128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Spain</td>\n",
       "      <td>106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Czechoslovakia</td>\n",
       "      <td>77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Austria</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Poland</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Finland</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Denmark</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Kenya</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Australia</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>UAE</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>214</td>\n",
       "      <td>Raw hides,skins and leather</td>\n",
       "      <td>Netherland</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>215</td>\n",
       "      <td>Raw hides,skins and leather</td>\n",
       "      <td>US</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>216</td>\n",
       "      <td>Raw hides,skins and leather</td>\n",
       "      <td>China</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>217</td>\n",
       "      <td>Raw hides,skins and leather</td>\n",
       "      <td>Other Countries</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>218</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>US</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>219</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>UK</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>220</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>Thailand</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>221</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>Denmark</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>222</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>Italy</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>223</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>UAE</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>224</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>Hong Kong</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>225</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>Singapore</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>226</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>China</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>227</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>Iran</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>228</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>Australia</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>229</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>230</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>Spain</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>231</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>Other Countries</td>\n",
       "      <td>135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>232</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>233</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>234</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>US</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>235</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>Italy</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>236</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>237</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>Thailand</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>238</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>Taiwan</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>239</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>France</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>240</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>241</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>China</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>242</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>UK</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>243</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>Other Countries</td>\n",
       "      <td>114</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>228 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     S.No                                    Commodity Group  \\\n",
       "0       1  Vehicles other than Railway,Tramway,Rolling St...   \n",
       "1       2  Vehicles other than Railway,Tramway,Rolling St...   \n",
       "2       3  Vehicles other than Railway,Tramway,Rolling St...   \n",
       "3       4  Vehicles other than Railway,Tramway,Rolling St...   \n",
       "4       5  Vehicles other than Railway,Tramway,Rolling St...   \n",
       "..    ...                                                ...   \n",
       "250   239                                     Iron and Steel   \n",
       "251   240                                     Iron and Steel   \n",
       "252   241                                     Iron and Steel   \n",
       "253   242                                     Iron and Steel   \n",
       "254   243                                     Iron and Steel   \n",
       "\n",
       "    Name of the Country  Value (Rs. in Crores)  \n",
       "0                 Italy                    550  \n",
       "1               Algeria                    386  \n",
       "2                    US                    366  \n",
       "3          South Africa                    293  \n",
       "4                    UK                    293  \n",
       "..                  ...                    ...  \n",
       "250              France                     14  \n",
       "251              Sweden                     14  \n",
       "252               China                     12  \n",
       "253                  UK                     11  \n",
       "254     Other Countries                    114  \n",
       "\n",
       "[228 rows x 4 columns]"
      ]
     },
     "execution_count": 147,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "commodities"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "     S.No                                    Commodity Group  \\\n",
      "0       1  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "1       2  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "2       3  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "3       4  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "4       5  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "5       6  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "6       7  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "7       8  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "8       9  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "9      10  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "10     11  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "11     12  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "12     13  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "13     14  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "14     15  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "15     16  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "16     17  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "17     18  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "18     19  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "19     20  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "20     21  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "21     22  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "22     23  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "23     24  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "24     25  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "25     26  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "26     27  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "27     28  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "28     29  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "29     30  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "30     31  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "31     32  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "32     33  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "33     34  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "34     35  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "35     36  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "36     37  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "37     38  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "38     39  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "39     40  Vehicles other than Railway,Tramway,Rolling St...   \n",
      "41     41         Footwear,guiter and parts of such articles   \n",
      "42     42         Footwear,guiter and parts of such articles   \n",
      "43     43         Footwear,guiter and parts of such articles   \n",
      "44     44         Footwear,guiter and parts of such articles   \n",
      "45     45         Footwear,guiter and parts of such articles   \n",
      "46     46         Footwear,guiter and parts of such articles   \n",
      "47     47         Footwear,guiter and parts of such articles   \n",
      "48     48         Footwear,guiter and parts of such articles   \n",
      "49     49         Footwear,guiter and parts of such articles   \n",
      "50     50         Footwear,guiter and parts of such articles   \n",
      "51     51         Footwear,guiter and parts of such articles   \n",
      "52     52         Footwear,guiter and parts of such articles   \n",
      "53     53         Footwear,guiter and parts of such articles   \n",
      "54     54         Footwear,guiter and parts of such articles   \n",
      "56     55                                             Cotton   \n",
      "57     56                                             Cotton   \n",
      "58     57                                             Cotton   \n",
      "59     58                                             Cotton   \n",
      "60     59                                             Cotton   \n",
      "61     60                                             Cotton   \n",
      "62     61                                             Cotton   \n",
      "63     62                                             Cotton   \n",
      "64     63                                             Cotton   \n",
      "65     64                                             Cotton   \n",
      "66     65                                             Cotton   \n",
      "67     66                                             Cotton   \n",
      "68     67                                             Cotton   \n",
      "69     68                                             Cotton   \n",
      "70     69                                             Cotton   \n",
      "71     70                                             Cotton   \n",
      "72     71                                             Cotton   \n",
      "73     72                                             Cotton   \n",
      "74     73                                             Cotton   \n",
      "75     74                                             Cotton   \n",
      "76     75                                             Cotton   \n",
      "77     76                                             Cotton   \n",
      "78     77                                             Cotton   \n",
      "80     78       Tobacco and manufactured tobacco substitutes   \n",
      "81     79       Tobacco and manufactured tobacco substitutes   \n",
      "82     80       Tobacco and manufactured tobacco substitutes   \n",
      "83     81       Tobacco and manufactured tobacco substitutes   \n",
      "84     82       Tobacco and manufactured tobacco substitutes   \n",
      "85     83       Tobacco and manufactured tobacco substitutes   \n",
      "86     84       Tobacco and manufactured tobacco substitutes   \n",
      "87     85       Tobacco and manufactured tobacco substitutes   \n",
      "88     86       Tobacco and manufactured tobacco substitutes   \n",
      "89     87       Tobacco and manufactured tobacco substitutes   \n",
      "90     88       Tobacco and manufactured tobacco substitutes   \n",
      "91     89       Tobacco and manufactured tobacco substitutes   \n",
      "92     90       Tobacco and manufactured tobacco substitutes   \n",
      "93     91       Tobacco and manufactured tobacco substitutes   \n",
      "94     92       Tobacco and manufactured tobacco substitutes   \n",
      "95     93       Tobacco and manufactured tobacco substitutes   \n",
      "96     94       Tobacco and manufactured tobacco substitutes   \n",
      "97     95       Tobacco and manufactured tobacco substitutes   \n",
      "98     96       Tobacco and manufactured tobacco substitutes   \n",
      "99     97       Tobacco and manufactured tobacco substitutes   \n",
      "100    98       Tobacco and manufactured tobacco substitutes   \n",
      "102    99  Salt,Sulphur,Plastering Materials,Lime and Cement   \n",
      "103   100  Salt,Sulphur,Plastering Materials,Lime and Cement   \n",
      "104   101  Salt,Sulphur,Plastering Materials,Lime and Cement   \n",
      "105   102  Salt,Sulphur,Plastering Materials,Lime and Cement   \n",
      "106   103  Salt,Sulphur,Plastering Materials,Lime and Cement   \n",
      "107   104  Salt,Sulphur,Plastering Materials,Lime and Cement   \n",
      "108   105  Salt,Sulphur,Plastering Materials,Lime and Cement   \n",
      "109   106  Salt,Sulphur,Plastering Materials,Lime and Cement   \n",
      "110   107  Salt,Sulphur,Plastering Materials,Lime and Cement   \n",
      "111   108  Salt,Sulphur,Plastering Materials,Lime and Cement   \n",
      "112   109  Salt,Sulphur,Plastering Materials,Lime and Cement   \n",
      "113   110  Salt,Sulphur,Plastering Materials,Lime and Cement   \n",
      "114   111  Salt,Sulphur,Plastering Materials,Lime and Cement   \n",
      "115   112  Salt,Sulphur,Plastering Materials,Lime and Cement   \n",
      "116   113  Salt,Sulphur,Plastering Materials,Lime and Cement   \n",
      "117   114  Salt,Sulphur,Plastering Materials,Lime and Cement   \n",
      "118   115  Salt,Sulphur,Plastering Materials,Lime and Cement   \n",
      "119   116  Salt,Sulphur,Plastering Materials,Lime and Cement   \n",
      "121   117  Fish and Crustaceans,Molasses and other Acquat...   \n",
      "122   118  Fish and Crustaceans,Molasses and other Acquat...   \n",
      "123   119  Fish and Crustaceans,Molasses and other Acquat...   \n",
      "124   120  Fish and Crustaceans,Molasses and other Acquat...   \n",
      "125   121  Fish and Crustaceans,Molasses and other Acquat...   \n",
      "126   122  Fish and Crustaceans,Molasses and other Acquat...   \n",
      "127   123  Fish and Crustaceans,Molasses and other Acquat...   \n",
      "128   124  Fish and Crustaceans,Molasses and other Acquat...   \n",
      "129   125  Fish and Crustaceans,Molasses and other Acquat...   \n",
      "130   126  Fish and Crustaceans,Molasses and other Acquat...   \n",
      "131   127  Fish and Crustaceans,Molasses and other Acquat...   \n",
      "132   128  Fish and Crustaceans,Molasses and other Acquat...   \n",
      "133   129  Fish and Crustaceans,Molasses and other Acquat...   \n",
      "134   130  Fish and Crustaceans,Molasses and other Acquat...   \n",
      "135   131  Fish and Crustaceans,Molasses and other Acquat...   \n",
      "137   132                                  Organic Chemicals   \n",
      "138   133                                  Organic Chemicals   \n",
      "139   134                                  Organic Chemicals   \n",
      "140   135                                  Organic Chemicals   \n",
      "141   136                                  Organic Chemicals   \n",
      "142   137                                  Organic Chemicals   \n",
      "143   138                                  Organic Chemicals   \n",
      "144   139                                  Organic Chemicals   \n",
      "145   140                                  Organic Chemicals   \n",
      "146   141                                  Organic Chemicals   \n",
      "147   142                                  Organic Chemicals   \n",
      "148   143                                  Organic Chemicals   \n",
      "149   144                                  Organic Chemicals   \n",
      "150   145                                  Organic Chemicals   \n",
      "151   146                                  Organic Chemicals   \n",
      "152   147                                  Organic Chemicals   \n",
      "153   148                                  Organic Chemicals   \n",
      "154   149                                  Organic Chemicals   \n",
      "155   150                                  Organic Chemicals   \n",
      "156   151                                  Organic Chemicals   \n",
      "157   152                                  Organic Chemicals   \n",
      "158   153                                  Organic Chemicals   \n",
      "159   154                                  Organic Chemicals   \n",
      "160   155                                  Organic Chemicals   \n",
      "161   156                                  Organic Chemicals   \n",
      "162   157                                  Organic Chemicals   \n",
      "163   158                                  Organic Chemicals   \n",
      "181   174                       Rubber and articles there of   \n",
      "182   175                       Rubber and articles there of   \n",
      "183   176                       Rubber and articles there of   \n",
      "184   177                       Rubber and articles there of   \n",
      "185   178                       Rubber and articles there of   \n",
      "186   179                       Rubber and articles there of   \n",
      "187   180                       Rubber and articles there of   \n",
      "188   181                       Rubber and articles there of   \n",
      "189   182                       Rubber and articles there of   \n",
      "190   183                       Rubber and articles there of   \n",
      "191   184                       Rubber and articles there of   \n",
      "192   185                       Rubber and articles there of   \n",
      "193   186                       Rubber and articles there of   \n",
      "194   187                       Rubber and articles there of   \n",
      "195   188                       Rubber and articles there of   \n",
      "196   189                       Rubber and articles there of   \n",
      "197   190                       Rubber and articles there of   \n",
      "198   191                       Rubber and articles there of   \n",
      "199   192                       Rubber and articles there of   \n",
      "200   193                       Rubber and articles there of   \n",
      "202   194                            Pharmaceutical Products   \n",
      "203   195                            Pharmaceutical Products   \n",
      "204   196                            Pharmaceutical Products   \n",
      "205   197                            Pharmaceutical Products   \n",
      "206   198                            Pharmaceutical Products   \n",
      "207   199                            Pharmaceutical Products   \n",
      "208   200                            Pharmaceutical Products   \n",
      "209   201                            Pharmaceutical Products   \n",
      "210   202                            Pharmaceutical Products   \n",
      "211   203                            Pharmaceutical Products   \n",
      "212   204                            Pharmaceutical Products   \n",
      "213   205                            Pharmaceutical Products   \n",
      "215   206                        Raw hides,skins and leather   \n",
      "216   207                        Raw hides,skins and leather   \n",
      "217   208                        Raw hides,skins and leather   \n",
      "218   209                        Raw hides,skins and leather   \n",
      "219   210                        Raw hides,skins and leather   \n",
      "220   211                        Raw hides,skins and leather   \n",
      "221   212                        Raw hides,skins and leather   \n",
      "222   213                        Raw hides,skins and leather   \n",
      "223   214                        Raw hides,skins and leather   \n",
      "224   215                        Raw hides,skins and leather   \n",
      "225   216                        Raw hides,skins and leather   \n",
      "226   217                        Raw hides,skins and leather   \n",
      "228   218                      Plastic and Articles there of   \n",
      "229   219                      Plastic and Articles there of   \n",
      "230   220                      Plastic and Articles there of   \n",
      "231   221                      Plastic and Articles there of   \n",
      "232   222                      Plastic and Articles there of   \n",
      "233   223                      Plastic and Articles there of   \n",
      "234   224                      Plastic and Articles there of   \n",
      "235   225                      Plastic and Articles there of   \n",
      "236   226                      Plastic and Articles there of   \n",
      "237   227                      Plastic and Articles there of   \n",
      "238   228                      Plastic and Articles there of   \n",
      "239   229                      Plastic and Articles there of   \n",
      "240   230                      Plastic and Articles there of   \n",
      "241   231                      Plastic and Articles there of   \n",
      "243   232                                     Iron and Steel   \n",
      "244   233                                     Iron and Steel   \n",
      "245   234                                     Iron and Steel   \n",
      "246   235                                     Iron and Steel   \n",
      "247   236                                     Iron and Steel   \n",
      "248   237                                     Iron and Steel   \n",
      "249   238                                     Iron and Steel   \n",
      "250   239                                     Iron and Steel   \n",
      "251   240                                     Iron and Steel   \n",
      "252   241                                     Iron and Steel   \n",
      "253   242                                     Iron and Steel   \n",
      "254   243                                     Iron and Steel   \n",
      "\n",
      "    Name of the Country  Value (Rs. in Crores)  \n",
      "0                 Italy                    550  \n",
      "1               Algeria                    386  \n",
      "2                    US                    366  \n",
      "3          South Africa                    293  \n",
      "4                    UK                    293  \n",
      "5                Mexico                    260  \n",
      "6              Columbia                    251  \n",
      "7                Greece                    228  \n",
      "8               Germany                    224  \n",
      "9            Netherland                    185  \n",
      "10             Thailand                    184  \n",
      "11            Singapore                    146  \n",
      "12                Egypt                    140  \n",
      "13                Korea                    139  \n",
      "14               France                    128  \n",
      "15            Argentina                    120  \n",
      "16                Spain                    106  \n",
      "17      Czechoslovakia                      77  \n",
      "18            Sri Lanka                     75  \n",
      "19               Turkey                     73  \n",
      "20               Sweden                     66  \n",
      "21              Austria                     64  \n",
      "22              Belgium                     63  \n",
      "23               Poland                     50  \n",
      "24              Finland                     49  \n",
      "25              Denmark                     46  \n",
      "26          Switzerland                     44  \n",
      "27                Kenya                     41  \n",
      "28            Australia                     30  \n",
      "29                  UAE                     31  \n",
      "30                 Iran                     26  \n",
      "31             Portugal                     26  \n",
      "32              Nigeria                     25  \n",
      "33                Syria                     24  \n",
      "34               Norway                     23  \n",
      "35            Indonesia                     23  \n",
      "36                China                     21  \n",
      "37             Malaysia                     13  \n",
      "38                Japan                     11  \n",
      "39      Other Countries                    472  \n",
      "41                Italy                    394  \n",
      "42                   US                    375  \n",
      "43              Germany                    255  \n",
      "44                   UK                    192  \n",
      "45           Netherland                     93  \n",
      "46             Portugal                     60  \n",
      "47               France                     56  \n",
      "48              Belgium                     25  \n",
      "49                  UAE                     15  \n",
      "50                Spain                     14  \n",
      "51            Hong Kong                     13  \n",
      "52            Australia                     13  \n",
      "53               Canada                     12  \n",
      "54      Other Countries                     61  \n",
      "56                Korea                    230  \n",
      "57               Turkey                    143  \n",
      "58                China                    121  \n",
      "59            Sri Lanka                     84  \n",
      "60               Taiwan                     59  \n",
      "61              Vietnam                     55  \n",
      "62               Russia                     50  \n",
      "63             Malaysia                     44  \n",
      "64                Japan                     42  \n",
      "65                   US                     40  \n",
      "66                  UAE                     37  \n",
      "67              Bahrain                     26  \n",
      "68            Hong Kong                     25  \n",
      "69                Italy                     24  \n",
      "70             Thailand                     19  \n",
      "71            Indonesia                     18  \n",
      "72                Egypt                     14  \n",
      "73               Brazil                     14  \n",
      "74              Germany                     14  \n",
      "75             Columbia                     13  \n",
      "76             Portugal                     11  \n",
      "77                   UK                     11  \n",
      "78      Other Countries                    406  \n",
      "80              Belgium                    256  \n",
      "81               Russia                    127  \n",
      "82          Philippines                    120  \n",
      "83              Germany                    115  \n",
      "84           Netherland                     76  \n",
      "85              Vietnam                     67  \n",
      "86         South Africa                     61  \n",
      "87                Korea                     63  \n",
      "88                   UK                     63  \n",
      "89                Egypt                     42  \n",
      "90            Australia                     40  \n",
      "91            Indonesia                     26  \n",
      "92                   US                     25  \n",
      "93               Poland                     24  \n",
      "94            Singapore                     21  \n",
      "95                  UAE                     21  \n",
      "96               France                     21  \n",
      "97             Malaysia                     19  \n",
      "98               Brazil                     16  \n",
      "99              Nigeria                     10  \n",
      "100     Other Countries                    185  \n",
      "102               China                    341  \n",
      "103               Italy                    147  \n",
      "104           Hong Kong                    112  \n",
      "105              Taiwan                     92  \n",
      "106                  US                     85  \n",
      "107        Saudi Arabia                     35  \n",
      "108               Japan                     28  \n",
      "109               Spain                     28  \n",
      "110             Belgium                     24  \n",
      "111                 UAE                     20  \n",
      "112                  UK                     17  \n",
      "113             Germany                     16  \n",
      "114              Mexico                     15  \n",
      "115              Canada                     13  \n",
      "116          Netherland                     13  \n",
      "117            Thailand                     12  \n",
      "118             Vietnam                     11  \n",
      "119     Other Countries                    109  \n",
      "121                  US                    222  \n",
      "122             Belgium                    153  \n",
      "123                  UK                    133  \n",
      "124              Canada                     75  \n",
      "125               Spain                     69  \n",
      "126             Germany                     53  \n",
      "127               Japan                     51  \n",
      "128                 UAE                     37  \n",
      "129            Malaysia                     23  \n",
      "130           Australia                     21  \n",
      "131        South Africa                     20  \n",
      "132              France                     25  \n",
      "133          Netherland                     14  \n",
      "134              Kuwait                     11  \n",
      "135     Other Countries                    111  \n",
      "137                  US                    143  \n",
      "138          Netherland                     56  \n",
      "139           Singapore                     52  \n",
      "140              Brazil                     44  \n",
      "141             Germany                     44  \n",
      "142             Vietnam                     38  \n",
      "143            Thailand                     32  \n",
      "144               Spain                     32  \n",
      "145           Hong Kong                     29  \n",
      "146                  UK                     27  \n",
      "147           Indonesia                     25  \n",
      "148               Korea                     25  \n",
      "149               Italy                     24  \n",
      "150               Japan                     23  \n",
      "151              Taiwan                     19  \n",
      "152              Turkey                     17  \n",
      "153            Portugal                     15  \n",
      "154              Poland                     14  \n",
      "155            Malaysia                     13  \n",
      "156               China                     13  \n",
      "157             Nigeria                     13  \n",
      "158             Belgium                     13  \n",
      "159            Columbia                     13  \n",
      "160           Argentina                     12  \n",
      "161                Iran                     12  \n",
      "162              Canada                     11  \n",
      "163     Other Countries                    176  \n",
      "181         Philippines                     87  \n",
      "182            Pakistan                     66  \n",
      "183             Nigeria                     66  \n",
      "184                  US                     62  \n",
      "185                Iran                     43  \n",
      "186           Australia                     32  \n",
      "187           Singapore                     23  \n",
      "188               Italy                     23  \n",
      "189               Kenya                     22  \n",
      "190             Vietnam                     22  \n",
      "191               Egypt                     20  \n",
      "192        Saudi Arabia                     18  \n",
      "193           Indonesia                     18  \n",
      "194                 UAE                     17  \n",
      "195           Sri Lanka                     16  \n",
      "196          Netherland                     13  \n",
      "197            Malaysia                     13  \n",
      "198             Germany                     12  \n",
      "199              Brazil                     10  \n",
      "200     Other Countries                    249  \n",
      "202              Brazil                     72  \n",
      "203                  UK                     58  \n",
      "204           Sri Lanka                     51  \n",
      "205           Australia                     51  \n",
      "206          Netherland                     41  \n",
      "207             Nigeria                     40  \n",
      "208             Vietnam                     35  \n",
      "209              Turkey                     27  \n",
      "210                  US                     26  \n",
      "211             Germany                     16  \n",
      "212        South Africa                     12  \n",
      "213     Other Countries                    261  \n",
      "215           Hong Kong                    220  \n",
      "216               Italy                    110  \n",
      "217               Spain                     42  \n",
      "218             Germany                     31  \n",
      "219             Vietnam                     24  \n",
      "220              France                     22  \n",
      "221        South Africa                     17  \n",
      "222            Portugal                     17  \n",
      "223          Netherland                     16  \n",
      "224                  US                     15  \n",
      "225               China                     13  \n",
      "226     Other Countries                     66  \n",
      "228                  US                     75  \n",
      "229                  UK                     38  \n",
      "230            Thailand                     38  \n",
      "231             Denmark                     35  \n",
      "232               Italy                     30  \n",
      "233                 UAE                     25  \n",
      "234           Hong Kong                     16  \n",
      "235           Singapore                     14  \n",
      "236               China                     14  \n",
      "237                Iran                     14  \n",
      "238           Australia                     13  \n",
      "239             Belgium                     12  \n",
      "240               Spain                     11  \n",
      "241     Other Countries                    135  \n",
      "243           Sri Lanka                     70  \n",
      "244           Indonesia                     53  \n",
      "245                  US                     39  \n",
      "246               Italy                     21  \n",
      "247            Malaysia                     19  \n",
      "248            Thailand                     18  \n",
      "249              Taiwan                     16  \n",
      "250              France                     14  \n",
      "251              Sweden                     14  \n",
      "252               China                     12  \n",
      "253                  UK                     11  \n",
      "254     Other Countries                    114  \n"
     ]
    }
   ],
   "source": [
    "with pd.option_context('display.max_rows', None, 'display.max_columns', None):  # more options can be specified also\n",
    "    print(commodities)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "metadata": {},
   "outputs": [],
   "source": [
    "commodities = commodities[commodities['S.No'] != 'Total']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 150,
   "metadata": {},
   "outputs": [],
   "source": [
    "commodities = commodities[commodities['Commodity Group'] != False]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 151,
   "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>S.No</th>\n",
       "      <th>Commodity Group</th>\n",
       "      <th>Name of the Country</th>\n",
       "      <th>Value (Rs. in Crores)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Italy</td>\n",
       "      <td>550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>386</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>US</td>\n",
       "      <td>366</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>UK</td>\n",
       "      <td>293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Columbia</td>\n",
       "      <td>251</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Greece</td>\n",
       "      <td>228</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Germany</td>\n",
       "      <td>224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Netherland</td>\n",
       "      <td>185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Thailand</td>\n",
       "      <td>184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Singapore</td>\n",
       "      <td>146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Korea</td>\n",
       "      <td>139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>France</td>\n",
       "      <td>128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Spain</td>\n",
       "      <td>106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Czechoslovakia</td>\n",
       "      <td>77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Austria</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Poland</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Finland</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Denmark</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Kenya</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>Australia</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>Vehicles other than Railway,Tramway,Rolling St...</td>\n",
       "      <td>UAE</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>214</td>\n",
       "      <td>Raw hides,skins and leather</td>\n",
       "      <td>Netherland</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>215</td>\n",
       "      <td>Raw hides,skins and leather</td>\n",
       "      <td>US</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>216</td>\n",
       "      <td>Raw hides,skins and leather</td>\n",
       "      <td>China</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>217</td>\n",
       "      <td>Raw hides,skins and leather</td>\n",
       "      <td>Other Countries</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>218</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>US</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>219</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>UK</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>220</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>Thailand</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>221</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>Denmark</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>222</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>Italy</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>223</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>UAE</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>224</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>Hong Kong</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>225</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>Singapore</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>226</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>China</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>227</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>Iran</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>228</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>Australia</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>229</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>230</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>Spain</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>231</td>\n",
       "      <td>Plastic and Articles there of</td>\n",
       "      <td>Other Countries</td>\n",
       "      <td>135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>232</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>233</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>234</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>US</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>235</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>Italy</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>236</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>237</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>Thailand</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>238</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>Taiwan</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>239</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>France</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>240</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>241</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>China</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>242</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>UK</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>243</td>\n",
       "      <td>Iron and Steel</td>\n",
       "      <td>Other Countries</td>\n",
       "      <td>114</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>228 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     S.No                                    Commodity Group  \\\n",
       "0       1  Vehicles other than Railway,Tramway,Rolling St...   \n",
       "1       2  Vehicles other than Railway,Tramway,Rolling St...   \n",
       "2       3  Vehicles other than Railway,Tramway,Rolling St...   \n",
       "3       4  Vehicles other than Railway,Tramway,Rolling St...   \n",
       "4       5  Vehicles other than Railway,Tramway,Rolling St...   \n",
       "..    ...                                                ...   \n",
       "250   239                                     Iron and Steel   \n",
       "251   240                                     Iron and Steel   \n",
       "252   241                                     Iron and Steel   \n",
       "253   242                                     Iron and Steel   \n",
       "254   243                                     Iron and Steel   \n",
       "\n",
       "    Name of the Country  Value (Rs. in Crores)  \n",
       "0                 Italy                    550  \n",
       "1               Algeria                    386  \n",
       "2                    US                    366  \n",
       "3          South Africa                    293  \n",
       "4                    UK                    293  \n",
       "..                  ...                    ...  \n",
       "250              France                     14  \n",
       "251              Sweden                     14  \n",
       "252               China                     12  \n",
       "253                  UK                     11  \n",
       "254     Other Countries                    114  \n",
       "\n",
       "[228 rows x 4 columns]"
      ]
     },
     "execution_count": 151,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "commodities"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 152,
   "metadata": {},
   "outputs": [],
   "source": [
    "pivot_table = commodities.pivot(index='Name of the Country', columns='Commodity Group', values='Value (Rs. in Crores)')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 153,
   "metadata": {},
   "outputs": [],
   "source": [
    "pivot_table.fillna(0, inplace=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "usa, korea, usa, other countries, hongkong"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 154,
   "metadata": {
    "scrolled": false
   },
   "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>Commodity Group</th>\n",
       "      <th>Cotton</th>\n",
       "      <th>Fish and Crustaceans,Molasses and other Acquatic invertibrates</th>\n",
       "      <th>Footwear,guiter and parts of such articles</th>\n",
       "      <th>Iron and Steel</th>\n",
       "      <th>Organic Chemicals</th>\n",
       "      <th>Pharmaceutical Products</th>\n",
       "      <th>Plastic and Articles there of</th>\n",
       "      <th>Raw hides,skins and leather</th>\n",
       "      <th>Rubber and articles there of</th>\n",
       "      <th>Salt,Sulphur,Plastering Materials,Lime and Cement</th>\n",
       "      <th>Tobacco and manufactured tobacco substitutes</th>\n",
       "      <th>Vehicles other than Railway,Tramway,Rolling Stock and parts and accessories there of</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Name of the Country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Algeria</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>386.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Argentina</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>120.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Australia</th>\n",
       "      <td>0.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Austria</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bahrain</th>\n",
       "      <td>26.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Belgium</th>\n",
       "      <td>0.0</td>\n",
       "      <td>153.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>256.0</td>\n",
       "      <td>63.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Brazil</th>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Canada</th>\n",
       "      <td>0.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>China</th>\n",
       "      <td>121.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>341.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Columbia</th>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>251.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Czechoslovakia</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>77.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Denmark</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>46.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Egypt</th>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>140.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Finland</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>49.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>France</th>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>128.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Germany</th>\n",
       "      <td>14.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>115.0</td>\n",
       "      <td>224.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Greece</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>228.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hong Kong</th>\n",
       "      <td>25.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>112.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Indonesia</th>\n",
       "      <td>18.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>23.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Iran</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>26.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Italy</th>\n",
       "      <td>24.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>394.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>550.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Japan</th>\n",
       "      <td>42.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kenya</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>41.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Korea</th>\n",
       "      <td>230.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>139.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kuwait</th>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Malaysia</th>\n",
       "      <td>44.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mexico</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>260.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Netherland</th>\n",
       "      <td>0.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>185.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nigeria</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Norway</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Countries</th>\n",
       "      <td>406.0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>114.0</td>\n",
       "      <td>176.0</td>\n",
       "      <td>261.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>249.0</td>\n",
       "      <td>109.0</td>\n",
       "      <td>185.0</td>\n",
       "      <td>472.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pakistan</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Philippines</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Poland</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Portugal</th>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>26.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Russia</th>\n",
       "      <td>50.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>127.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Saudi Arabia</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Singapore</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>146.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>South Africa</th>\n",
       "      <td>0.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>293.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spain</th>\n",
       "      <td>0.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>106.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sri Lanka</th>\n",
       "      <td>84.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>75.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sweden</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Switzerland</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>44.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Syria</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Taiwan</th>\n",
       "      <td>59.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thailand</th>\n",
       "      <td>19.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>184.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Turkey</th>\n",
       "      <td>143.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>73.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UAE</th>\n",
       "      <td>37.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>31.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UK</th>\n",
       "      <td>11.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>192.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>293.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>US</th>\n",
       "      <td>40.0</td>\n",
       "      <td>222.0</td>\n",
       "      <td>375.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>143.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>366.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vietnam</th>\n",
       "      <td>55.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Commodity Group      Cotton  \\\n",
       "Name of the Country           \n",
       "Algeria                 0.0   \n",
       "Argentina               0.0   \n",
       "Australia               0.0   \n",
       "Austria                 0.0   \n",
       "Bahrain                26.0   \n",
       "Belgium                 0.0   \n",
       "Brazil                 14.0   \n",
       "Canada                  0.0   \n",
       "China                 121.0   \n",
       "Columbia               13.0   \n",
       "Czechoslovakia          0.0   \n",
       "Denmark                 0.0   \n",
       "Egypt                  14.0   \n",
       "Finland                 0.0   \n",
       "France                  0.0   \n",
       "Germany                14.0   \n",
       "Greece                  0.0   \n",
       "Hong Kong              25.0   \n",
       "Indonesia              18.0   \n",
       "Iran                    0.0   \n",
       "Italy                  24.0   \n",
       "Japan                  42.0   \n",
       "Kenya                   0.0   \n",
       "Korea                 230.0   \n",
       "Kuwait                  0.0   \n",
       "Malaysia               44.0   \n",
       "Mexico                  0.0   \n",
       "Netherland              0.0   \n",
       "Nigeria                 0.0   \n",
       "Norway                  0.0   \n",
       "Other Countries       406.0   \n",
       "Pakistan                0.0   \n",
       "Philippines             0.0   \n",
       "Poland                  0.0   \n",
       "Portugal               11.0   \n",
       "Russia                 50.0   \n",
       "Saudi Arabia            0.0   \n",
       "Singapore               0.0   \n",
       "South Africa            0.0   \n",
       "Spain                   0.0   \n",
       "Sri Lanka              84.0   \n",
       "Sweden                  0.0   \n",
       "Switzerland             0.0   \n",
       "Syria                   0.0   \n",
       "Taiwan                 59.0   \n",
       "Thailand               19.0   \n",
       "Turkey                143.0   \n",
       "UAE                    37.0   \n",
       "UK                     11.0   \n",
       "US                     40.0   \n",
       "Vietnam                55.0   \n",
       "\n",
       "Commodity Group      Fish and Crustaceans,Molasses and other Acquatic invertibrates  \\\n",
       "Name of the Country                                                                   \n",
       "Algeria                                                            0.0                \n",
       "Argentina                                                          0.0                \n",
       "Australia                                                         21.0                \n",
       "Austria                                                            0.0                \n",
       "Bahrain                                                            0.0                \n",
       "Belgium                                                          153.0                \n",
       "Brazil                                                             0.0                \n",
       "Canada                                                            75.0                \n",
       "China                                                              0.0                \n",
       "Columbia                                                           0.0                \n",
       "Czechoslovakia                                                     0.0                \n",
       "Denmark                                                            0.0                \n",
       "Egypt                                                              0.0                \n",
       "Finland                                                            0.0                \n",
       "France                                                            25.0                \n",
       "Germany                                                           53.0                \n",
       "Greece                                                             0.0                \n",
       "Hong Kong                                                          0.0                \n",
       "Indonesia                                                          0.0                \n",
       "Iran                                                               0.0                \n",
       "Italy                                                              0.0                \n",
       "Japan                                                             51.0                \n",
       "Kenya                                                              0.0                \n",
       "Korea                                                              0.0                \n",
       "Kuwait                                                            11.0                \n",
       "Malaysia                                                          23.0                \n",
       "Mexico                                                             0.0                \n",
       "Netherland                                                        14.0                \n",
       "Nigeria                                                            0.0                \n",
       "Norway                                                             0.0                \n",
       "Other Countries                                                  111.0                \n",
       "Pakistan                                                           0.0                \n",
       "Philippines                                                        0.0                \n",
       "Poland                                                             0.0                \n",
       "Portugal                                                           0.0                \n",
       "Russia                                                             0.0                \n",
       "Saudi Arabia                                                       0.0                \n",
       "Singapore                                                          0.0                \n",
       "South Africa                                                      20.0                \n",
       "Spain                                                             69.0                \n",
       "Sri Lanka                                                          0.0                \n",
       "Sweden                                                             0.0                \n",
       "Switzerland                                                        0.0                \n",
       "Syria                                                              0.0                \n",
       "Taiwan                                                             0.0                \n",
       "Thailand                                                           0.0                \n",
       "Turkey                                                             0.0                \n",
       "UAE                                                               37.0                \n",
       "UK                                                               133.0                \n",
       "US                                                               222.0                \n",
       "Vietnam                                                            0.0                \n",
       "\n",
       "Commodity Group      Footwear,guiter and parts of such articles  \\\n",
       "Name of the Country                                               \n",
       "Algeria                                                     0.0   \n",
       "Argentina                                                   0.0   \n",
       "Australia                                                  13.0   \n",
       "Austria                                                     0.0   \n",
       "Bahrain                                                     0.0   \n",
       "Belgium                                                    25.0   \n",
       "Brazil                                                      0.0   \n",
       "Canada                                                     12.0   \n",
       "China                                                       0.0   \n",
       "Columbia                                                    0.0   \n",
       "Czechoslovakia                                              0.0   \n",
       "Denmark                                                     0.0   \n",
       "Egypt                                                       0.0   \n",
       "Finland                                                     0.0   \n",
       "France                                                     56.0   \n",
       "Germany                                                   255.0   \n",
       "Greece                                                      0.0   \n",
       "Hong Kong                                                  13.0   \n",
       "Indonesia                                                   0.0   \n",
       "Iran                                                        0.0   \n",
       "Italy                                                     394.0   \n",
       "Japan                                                       0.0   \n",
       "Kenya                                                       0.0   \n",
       "Korea                                                       0.0   \n",
       "Kuwait                                                      0.0   \n",
       "Malaysia                                                    0.0   \n",
       "Mexico                                                      0.0   \n",
       "Netherland                                                 93.0   \n",
       "Nigeria                                                     0.0   \n",
       "Norway                                                      0.0   \n",
       "Other Countries                                            61.0   \n",
       "Pakistan                                                    0.0   \n",
       "Philippines                                                 0.0   \n",
       "Poland                                                      0.0   \n",
       "Portugal                                                   60.0   \n",
       "Russia                                                      0.0   \n",
       "Saudi Arabia                                                0.0   \n",
       "Singapore                                                   0.0   \n",
       "South Africa                                                0.0   \n",
       "Spain                                                      14.0   \n",
       "Sri Lanka                                                   0.0   \n",
       "Sweden                                                      0.0   \n",
       "Switzerland                                                 0.0   \n",
       "Syria                                                       0.0   \n",
       "Taiwan                                                      0.0   \n",
       "Thailand                                                    0.0   \n",
       "Turkey                                                      0.0   \n",
       "UAE                                                        15.0   \n",
       "UK                                                        192.0   \n",
       "US                                                        375.0   \n",
       "Vietnam                                                     0.0   \n",
       "\n",
       "Commodity Group      Iron and Steel  Organic Chemicals  \\\n",
       "Name of the Country                                      \n",
       "Algeria                         0.0                0.0   \n",
       "Argentina                       0.0               12.0   \n",
       "Australia                       0.0                0.0   \n",
       "Austria                         0.0                0.0   \n",
       "Bahrain                         0.0                0.0   \n",
       "Belgium                         0.0               13.0   \n",
       "Brazil                          0.0               44.0   \n",
       "Canada                          0.0               11.0   \n",
       "China                          12.0               13.0   \n",
       "Columbia                        0.0               13.0   \n",
       "Czechoslovakia                  0.0                0.0   \n",
       "Denmark                         0.0                0.0   \n",
       "Egypt                           0.0                0.0   \n",
       "Finland                         0.0                0.0   \n",
       "France                         14.0                0.0   \n",
       "Germany                         0.0               44.0   \n",
       "Greece                          0.0                0.0   \n",
       "Hong Kong                       0.0               29.0   \n",
       "Indonesia                      53.0               25.0   \n",
       "Iran                            0.0               12.0   \n",
       "Italy                          21.0               24.0   \n",
       "Japan                           0.0               23.0   \n",
       "Kenya                           0.0                0.0   \n",
       "Korea                           0.0               25.0   \n",
       "Kuwait                          0.0                0.0   \n",
       "Malaysia                       19.0               13.0   \n",
       "Mexico                          0.0                0.0   \n",
       "Netherland                      0.0               56.0   \n",
       "Nigeria                         0.0               13.0   \n",
       "Norway                          0.0                0.0   \n",
       "Other Countries               114.0              176.0   \n",
       "Pakistan                        0.0                0.0   \n",
       "Philippines                     0.0                0.0   \n",
       "Poland                          0.0               14.0   \n",
       "Portugal                        0.0               15.0   \n",
       "Russia                          0.0                0.0   \n",
       "Saudi Arabia                    0.0                0.0   \n",
       "Singapore                       0.0               52.0   \n",
       "South Africa                    0.0                0.0   \n",
       "Spain                           0.0               32.0   \n",
       "Sri Lanka                      70.0                0.0   \n",
       "Sweden                         14.0                0.0   \n",
       "Switzerland                     0.0                0.0   \n",
       "Syria                           0.0                0.0   \n",
       "Taiwan                         16.0               19.0   \n",
       "Thailand                       18.0               32.0   \n",
       "Turkey                          0.0               17.0   \n",
       "UAE                             0.0                0.0   \n",
       "UK                             11.0               27.0   \n",
       "US                             39.0              143.0   \n",
       "Vietnam                         0.0               38.0   \n",
       "\n",
       "Commodity Group      Pharmaceutical Products  Plastic and Articles there of  \\\n",
       "Name of the Country                                                           \n",
       "Algeria                                  0.0                            0.0   \n",
       "Argentina                                0.0                            0.0   \n",
       "Australia                               51.0                           13.0   \n",
       "Austria                                  0.0                            0.0   \n",
       "Bahrain                                  0.0                            0.0   \n",
       "Belgium                                  0.0                           12.0   \n",
       "Brazil                                  72.0                            0.0   \n",
       "Canada                                   0.0                            0.0   \n",
       "China                                    0.0                           14.0   \n",
       "Columbia                                 0.0                            0.0   \n",
       "Czechoslovakia                           0.0                            0.0   \n",
       "Denmark                                  0.0                           35.0   \n",
       "Egypt                                    0.0                            0.0   \n",
       "Finland                                  0.0                            0.0   \n",
       "France                                   0.0                            0.0   \n",
       "Germany                                 16.0                            0.0   \n",
       "Greece                                   0.0                            0.0   \n",
       "Hong Kong                                0.0                           16.0   \n",
       "Indonesia                                0.0                            0.0   \n",
       "Iran                                     0.0                           14.0   \n",
       "Italy                                    0.0                           30.0   \n",
       "Japan                                    0.0                            0.0   \n",
       "Kenya                                    0.0                            0.0   \n",
       "Korea                                    0.0                            0.0   \n",
       "Kuwait                                   0.0                            0.0   \n",
       "Malaysia                                 0.0                            0.0   \n",
       "Mexico                                   0.0                            0.0   \n",
       "Netherland                              41.0                            0.0   \n",
       "Nigeria                                 40.0                            0.0   \n",
       "Norway                                   0.0                            0.0   \n",
       "Other Countries                        261.0                          135.0   \n",
       "Pakistan                                 0.0                            0.0   \n",
       "Philippines                              0.0                            0.0   \n",
       "Poland                                   0.0                            0.0   \n",
       "Portugal                                 0.0                            0.0   \n",
       "Russia                                   0.0                            0.0   \n",
       "Saudi Arabia                             0.0                            0.0   \n",
       "Singapore                                0.0                           14.0   \n",
       "South Africa                            12.0                            0.0   \n",
       "Spain                                    0.0                           11.0   \n",
       "Sri Lanka                               51.0                            0.0   \n",
       "Sweden                                   0.0                            0.0   \n",
       "Switzerland                              0.0                            0.0   \n",
       "Syria                                    0.0                            0.0   \n",
       "Taiwan                                   0.0                            0.0   \n",
       "Thailand                                 0.0                           38.0   \n",
       "Turkey                                  27.0                            0.0   \n",
       "UAE                                      0.0                           25.0   \n",
       "UK                                      58.0                           38.0   \n",
       "US                                      26.0                           75.0   \n",
       "Vietnam                                 35.0                            0.0   \n",
       "\n",
       "Commodity Group      Raw hides,skins and leather  \\\n",
       "Name of the Country                                \n",
       "Algeria                                      0.0   \n",
       "Argentina                                    0.0   \n",
       "Australia                                    0.0   \n",
       "Austria                                      0.0   \n",
       "Bahrain                                      0.0   \n",
       "Belgium                                      0.0   \n",
       "Brazil                                       0.0   \n",
       "Canada                                       0.0   \n",
       "China                                       13.0   \n",
       "Columbia                                     0.0   \n",
       "Czechoslovakia                               0.0   \n",
       "Denmark                                      0.0   \n",
       "Egypt                                        0.0   \n",
       "Finland                                      0.0   \n",
       "France                                      22.0   \n",
       "Germany                                     31.0   \n",
       "Greece                                       0.0   \n",
       "Hong Kong                                  220.0   \n",
       "Indonesia                                    0.0   \n",
       "Iran                                         0.0   \n",
       "Italy                                      110.0   \n",
       "Japan                                        0.0   \n",
       "Kenya                                        0.0   \n",
       "Korea                                        0.0   \n",
       "Kuwait                                       0.0   \n",
       "Malaysia                                     0.0   \n",
       "Mexico                                       0.0   \n",
       "Netherland                                  16.0   \n",
       "Nigeria                                      0.0   \n",
       "Norway                                       0.0   \n",
       "Other Countries                             66.0   \n",
       "Pakistan                                     0.0   \n",
       "Philippines                                  0.0   \n",
       "Poland                                       0.0   \n",
       "Portugal                                    17.0   \n",
       "Russia                                       0.0   \n",
       "Saudi Arabia                                 0.0   \n",
       "Singapore                                    0.0   \n",
       "South Africa                                17.0   \n",
       "Spain                                       42.0   \n",
       "Sri Lanka                                    0.0   \n",
       "Sweden                                       0.0   \n",
       "Switzerland                                  0.0   \n",
       "Syria                                        0.0   \n",
       "Taiwan                                       0.0   \n",
       "Thailand                                     0.0   \n",
       "Turkey                                       0.0   \n",
       "UAE                                          0.0   \n",
       "UK                                           0.0   \n",
       "US                                          15.0   \n",
       "Vietnam                                     24.0   \n",
       "\n",
       "Commodity Group      Rubber and articles there of  \\\n",
       "Name of the Country                                 \n",
       "Algeria                                       0.0   \n",
       "Argentina                                     0.0   \n",
       "Australia                                    32.0   \n",
       "Austria                                       0.0   \n",
       "Bahrain                                       0.0   \n",
       "Belgium                                       0.0   \n",
       "Brazil                                       10.0   \n",
       "Canada                                        0.0   \n",
       "China                                         0.0   \n",
       "Columbia                                      0.0   \n",
       "Czechoslovakia                                0.0   \n",
       "Denmark                                       0.0   \n",
       "Egypt                                        20.0   \n",
       "Finland                                       0.0   \n",
       "France                                        0.0   \n",
       "Germany                                      12.0   \n",
       "Greece                                        0.0   \n",
       "Hong Kong                                     0.0   \n",
       "Indonesia                                    18.0   \n",
       "Iran                                         43.0   \n",
       "Italy                                        23.0   \n",
       "Japan                                         0.0   \n",
       "Kenya                                        22.0   \n",
       "Korea                                         0.0   \n",
       "Kuwait                                        0.0   \n",
       "Malaysia                                     13.0   \n",
       "Mexico                                        0.0   \n",
       "Netherland                                   13.0   \n",
       "Nigeria                                      66.0   \n",
       "Norway                                        0.0   \n",
       "Other Countries                             249.0   \n",
       "Pakistan                                     66.0   \n",
       "Philippines                                  87.0   \n",
       "Poland                                        0.0   \n",
       "Portugal                                      0.0   \n",
       "Russia                                        0.0   \n",
       "Saudi Arabia                                 18.0   \n",
       "Singapore                                    23.0   \n",
       "South Africa                                  0.0   \n",
       "Spain                                         0.0   \n",
       "Sri Lanka                                    16.0   \n",
       "Sweden                                        0.0   \n",
       "Switzerland                                   0.0   \n",
       "Syria                                         0.0   \n",
       "Taiwan                                        0.0   \n",
       "Thailand                                      0.0   \n",
       "Turkey                                        0.0   \n",
       "UAE                                          17.0   \n",
       "UK                                            0.0   \n",
       "US                                           62.0   \n",
       "Vietnam                                      22.0   \n",
       "\n",
       "Commodity Group      Salt,Sulphur,Plastering Materials,Lime and Cement  \\\n",
       "Name of the Country                                                      \n",
       "Algeria                                                            0.0   \n",
       "Argentina                                                          0.0   \n",
       "Australia                                                          0.0   \n",
       "Austria                                                            0.0   \n",
       "Bahrain                                                            0.0   \n",
       "Belgium                                                           24.0   \n",
       "Brazil                                                             0.0   \n",
       "Canada                                                            13.0   \n",
       "China                                                            341.0   \n",
       "Columbia                                                           0.0   \n",
       "Czechoslovakia                                                     0.0   \n",
       "Denmark                                                            0.0   \n",
       "Egypt                                                              0.0   \n",
       "Finland                                                            0.0   \n",
       "France                                                             0.0   \n",
       "Germany                                                           16.0   \n",
       "Greece                                                             0.0   \n",
       "Hong Kong                                                        112.0   \n",
       "Indonesia                                                          0.0   \n",
       "Iran                                                               0.0   \n",
       "Italy                                                            147.0   \n",
       "Japan                                                             28.0   \n",
       "Kenya                                                              0.0   \n",
       "Korea                                                              0.0   \n",
       "Kuwait                                                             0.0   \n",
       "Malaysia                                                           0.0   \n",
       "Mexico                                                            15.0   \n",
       "Netherland                                                        13.0   \n",
       "Nigeria                                                            0.0   \n",
       "Norway                                                             0.0   \n",
       "Other Countries                                                  109.0   \n",
       "Pakistan                                                           0.0   \n",
       "Philippines                                                        0.0   \n",
       "Poland                                                             0.0   \n",
       "Portugal                                                           0.0   \n",
       "Russia                                                             0.0   \n",
       "Saudi Arabia                                                      35.0   \n",
       "Singapore                                                          0.0   \n",
       "South Africa                                                       0.0   \n",
       "Spain                                                             28.0   \n",
       "Sri Lanka                                                          0.0   \n",
       "Sweden                                                             0.0   \n",
       "Switzerland                                                        0.0   \n",
       "Syria                                                              0.0   \n",
       "Taiwan                                                            92.0   \n",
       "Thailand                                                          12.0   \n",
       "Turkey                                                             0.0   \n",
       "UAE                                                               20.0   \n",
       "UK                                                                17.0   \n",
       "US                                                                85.0   \n",
       "Vietnam                                                           11.0   \n",
       "\n",
       "Commodity Group      Tobacco and manufactured tobacco substitutes  \\\n",
       "Name of the Country                                                 \n",
       "Algeria                                                       0.0   \n",
       "Argentina                                                     0.0   \n",
       "Australia                                                    40.0   \n",
       "Austria                                                       0.0   \n",
       "Bahrain                                                       0.0   \n",
       "Belgium                                                     256.0   \n",
       "Brazil                                                       16.0   \n",
       "Canada                                                        0.0   \n",
       "China                                                         0.0   \n",
       "Columbia                                                      0.0   \n",
       "Czechoslovakia                                                0.0   \n",
       "Denmark                                                       0.0   \n",
       "Egypt                                                        42.0   \n",
       "Finland                                                       0.0   \n",
       "France                                                       21.0   \n",
       "Germany                                                     115.0   \n",
       "Greece                                                        0.0   \n",
       "Hong Kong                                                     0.0   \n",
       "Indonesia                                                    26.0   \n",
       "Iran                                                          0.0   \n",
       "Italy                                                         0.0   \n",
       "Japan                                                         0.0   \n",
       "Kenya                                                         0.0   \n",
       "Korea                                                        63.0   \n",
       "Kuwait                                                        0.0   \n",
       "Malaysia                                                     19.0   \n",
       "Mexico                                                        0.0   \n",
       "Netherland                                                   76.0   \n",
       "Nigeria                                                      10.0   \n",
       "Norway                                                        0.0   \n",
       "Other Countries                                             185.0   \n",
       "Pakistan                                                      0.0   \n",
       "Philippines                                                 120.0   \n",
       "Poland                                                       24.0   \n",
       "Portugal                                                      0.0   \n",
       "Russia                                                      127.0   \n",
       "Saudi Arabia                                                  0.0   \n",
       "Singapore                                                    21.0   \n",
       "South Africa                                                 61.0   \n",
       "Spain                                                         0.0   \n",
       "Sri Lanka                                                     0.0   \n",
       "Sweden                                                        0.0   \n",
       "Switzerland                                                   0.0   \n",
       "Syria                                                         0.0   \n",
       "Taiwan                                                        0.0   \n",
       "Thailand                                                      0.0   \n",
       "Turkey                                                        0.0   \n",
       "UAE                                                          21.0   \n",
       "UK                                                           63.0   \n",
       "US                                                           25.0   \n",
       "Vietnam                                                      67.0   \n",
       "\n",
       "Commodity Group      Vehicles other than Railway,Tramway,Rolling Stock and parts and accessories there of  \n",
       "Name of the Country                                                                                        \n",
       "Algeria                                                          386.0                                     \n",
       "Argentina                                                        120.0                                     \n",
       "Australia                                                         30.0                                     \n",
       "Austria                                                           64.0                                     \n",
       "Bahrain                                                            0.0                                     \n",
       "Belgium                                                           63.0                                     \n",
       "Brazil                                                             0.0                                     \n",
       "Canada                                                             0.0                                     \n",
       "China                                                             21.0                                     \n",
       "Columbia                                                         251.0                                     \n",
       "Czechoslovakia                                                    77.0                                     \n",
       "Denmark                                                           46.0                                     \n",
       "Egypt                                                            140.0                                     \n",
       "Finland                                                           49.0                                     \n",
       "France                                                           128.0                                     \n",
       "Germany                                                          224.0                                     \n",
       "Greece                                                           228.0                                     \n",
       "Hong Kong                                                          0.0                                     \n",
       "Indonesia                                                         23.0                                     \n",
       "Iran                                                              26.0                                     \n",
       "Italy                                                            550.0                                     \n",
       "Japan                                                             11.0                                     \n",
       "Kenya                                                             41.0                                     \n",
       "Korea                                                            139.0                                     \n",
       "Kuwait                                                             0.0                                     \n",
       "Malaysia                                                          13.0                                     \n",
       "Mexico                                                           260.0                                     \n",
       "Netherland                                                       185.0                                     \n",
       "Nigeria                                                           25.0                                     \n",
       "Norway                                                            23.0                                     \n",
       "Other Countries                                                  472.0                                     \n",
       "Pakistan                                                           0.0                                     \n",
       "Philippines                                                        0.0                                     \n",
       "Poland                                                            50.0                                     \n",
       "Portugal                                                          26.0                                     \n",
       "Russia                                                             0.0                                     \n",
       "Saudi Arabia                                                       0.0                                     \n",
       "Singapore                                                        146.0                                     \n",
       "South Africa                                                     293.0                                     \n",
       "Spain                                                            106.0                                     \n",
       "Sri Lanka                                                         75.0                                     \n",
       "Sweden                                                            66.0                                     \n",
       "Switzerland                                                       44.0                                     \n",
       "Syria                                                             24.0                                     \n",
       "Taiwan                                                             0.0                                     \n",
       "Thailand                                                         184.0                                     \n",
       "Turkey                                                            73.0                                     \n",
       "UAE                                                               31.0                                     \n",
       "UK                                                               293.0                                     \n",
       "US                                                               366.0                                     \n",
       "Vietnam                                                            0.0                                     "
      ]
     },
     "execution_count": 154,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pivot_table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 155,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Commodity Group      Cotton  \\\n",
      "Name of the Country           \n",
      "Algeria                 0.0   \n",
      "Argentina               0.0   \n",
      "Australia               0.0   \n",
      "Austria                 0.0   \n",
      "Bahrain                26.0   \n",
      "Belgium                 0.0   \n",
      "Brazil                 14.0   \n",
      "Canada                  0.0   \n",
      "China                 121.0   \n",
      "Columbia               13.0   \n",
      "Czechoslovakia          0.0   \n",
      "Denmark                 0.0   \n",
      "Egypt                  14.0   \n",
      "Finland                 0.0   \n",
      "France                  0.0   \n",
      "Germany                14.0   \n",
      "Greece                  0.0   \n",
      "Hong Kong              25.0   \n",
      "Indonesia              18.0   \n",
      "Iran                    0.0   \n",
      "Italy                  24.0   \n",
      "Japan                  42.0   \n",
      "Kenya                   0.0   \n",
      "Korea                 230.0   \n",
      "Kuwait                  0.0   \n",
      "Malaysia               44.0   \n",
      "Mexico                  0.0   \n",
      "Netherland              0.0   \n",
      "Nigeria                 0.0   \n",
      "Norway                  0.0   \n",
      "Other Countries       406.0   \n",
      "Pakistan                0.0   \n",
      "Philippines             0.0   \n",
      "Poland                  0.0   \n",
      "Portugal               11.0   \n",
      "Russia                 50.0   \n",
      "Saudi Arabia            0.0   \n",
      "Singapore               0.0   \n",
      "South Africa            0.0   \n",
      "Spain                   0.0   \n",
      "Sri Lanka              84.0   \n",
      "Sweden                  0.0   \n",
      "Switzerland             0.0   \n",
      "Syria                   0.0   \n",
      "Taiwan                 59.0   \n",
      "Thailand               19.0   \n",
      "Turkey                143.0   \n",
      "UAE                    37.0   \n",
      "UK                     11.0   \n",
      "US                     40.0   \n",
      "Vietnam                55.0   \n",
      "\n",
      "Commodity Group      Fish and Crustaceans,Molasses and other Acquatic invertibrates  \\\n",
      "Name of the Country                                                                   \n",
      "Algeria                                                            0.0                \n",
      "Argentina                                                          0.0                \n",
      "Australia                                                         21.0                \n",
      "Austria                                                            0.0                \n",
      "Bahrain                                                            0.0                \n",
      "Belgium                                                          153.0                \n",
      "Brazil                                                             0.0                \n",
      "Canada                                                            75.0                \n",
      "China                                                              0.0                \n",
      "Columbia                                                           0.0                \n",
      "Czechoslovakia                                                     0.0                \n",
      "Denmark                                                            0.0                \n",
      "Egypt                                                              0.0                \n",
      "Finland                                                            0.0                \n",
      "France                                                            25.0                \n",
      "Germany                                                           53.0                \n",
      "Greece                                                             0.0                \n",
      "Hong Kong                                                          0.0                \n",
      "Indonesia                                                          0.0                \n",
      "Iran                                                               0.0                \n",
      "Italy                                                              0.0                \n",
      "Japan                                                             51.0                \n",
      "Kenya                                                              0.0                \n",
      "Korea                                                              0.0                \n",
      "Kuwait                                                            11.0                \n",
      "Malaysia                                                          23.0                \n",
      "Mexico                                                             0.0                \n",
      "Netherland                                                        14.0                \n",
      "Nigeria                                                            0.0                \n",
      "Norway                                                             0.0                \n",
      "Other Countries                                                  111.0                \n",
      "Pakistan                                                           0.0                \n",
      "Philippines                                                        0.0                \n",
      "Poland                                                             0.0                \n",
      "Portugal                                                           0.0                \n",
      "Russia                                                             0.0                \n",
      "Saudi Arabia                                                       0.0                \n",
      "Singapore                                                          0.0                \n",
      "South Africa                                                      20.0                \n",
      "Spain                                                             69.0                \n",
      "Sri Lanka                                                          0.0                \n",
      "Sweden                                                             0.0                \n",
      "Switzerland                                                        0.0                \n",
      "Syria                                                              0.0                \n",
      "Taiwan                                                             0.0                \n",
      "Thailand                                                           0.0                \n",
      "Turkey                                                             0.0                \n",
      "UAE                                                               37.0                \n",
      "UK                                                               133.0                \n",
      "US                                                               222.0                \n",
      "Vietnam                                                            0.0                \n",
      "\n",
      "Commodity Group      Footwear,guiter and parts of such articles  \\\n",
      "Name of the Country                                               \n",
      "Algeria                                                     0.0   \n",
      "Argentina                                                   0.0   \n",
      "Australia                                                  13.0   \n",
      "Austria                                                     0.0   \n",
      "Bahrain                                                     0.0   \n",
      "Belgium                                                    25.0   \n",
      "Brazil                                                      0.0   \n",
      "Canada                                                     12.0   \n",
      "China                                                       0.0   \n",
      "Columbia                                                    0.0   \n",
      "Czechoslovakia                                              0.0   \n",
      "Denmark                                                     0.0   \n",
      "Egypt                                                       0.0   \n",
      "Finland                                                     0.0   \n",
      "France                                                     56.0   \n",
      "Germany                                                   255.0   \n",
      "Greece                                                      0.0   \n",
      "Hong Kong                                                  13.0   \n",
      "Indonesia                                                   0.0   \n",
      "Iran                                                        0.0   \n",
      "Italy                                                     394.0   \n",
      "Japan                                                       0.0   \n",
      "Kenya                                                       0.0   \n",
      "Korea                                                       0.0   \n",
      "Kuwait                                                      0.0   \n",
      "Malaysia                                                    0.0   \n",
      "Mexico                                                      0.0   \n",
      "Netherland                                                 93.0   \n",
      "Nigeria                                                     0.0   \n",
      "Norway                                                      0.0   \n",
      "Other Countries                                            61.0   \n",
      "Pakistan                                                    0.0   \n",
      "Philippines                                                 0.0   \n",
      "Poland                                                      0.0   \n",
      "Portugal                                                   60.0   \n",
      "Russia                                                      0.0   \n",
      "Saudi Arabia                                                0.0   \n",
      "Singapore                                                   0.0   \n",
      "South Africa                                                0.0   \n",
      "Spain                                                      14.0   \n",
      "Sri Lanka                                                   0.0   \n",
      "Sweden                                                      0.0   \n",
      "Switzerland                                                 0.0   \n",
      "Syria                                                       0.0   \n",
      "Taiwan                                                      0.0   \n",
      "Thailand                                                    0.0   \n",
      "Turkey                                                      0.0   \n",
      "UAE                                                        15.0   \n",
      "UK                                                        192.0   \n",
      "US                                                        375.0   \n",
      "Vietnam                                                     0.0   \n",
      "\n",
      "Commodity Group      Iron and Steel  Organic Chemicals  \\\n",
      "Name of the Country                                      \n",
      "Algeria                         0.0                0.0   \n",
      "Argentina                       0.0               12.0   \n",
      "Australia                       0.0                0.0   \n",
      "Austria                         0.0                0.0   \n",
      "Bahrain                         0.0                0.0   \n",
      "Belgium                         0.0               13.0   \n",
      "Brazil                          0.0               44.0   \n",
      "Canada                          0.0               11.0   \n",
      "China                          12.0               13.0   \n",
      "Columbia                        0.0               13.0   \n",
      "Czechoslovakia                  0.0                0.0   \n",
      "Denmark                         0.0                0.0   \n",
      "Egypt                           0.0                0.0   \n",
      "Finland                         0.0                0.0   \n",
      "France                         14.0                0.0   \n",
      "Germany                         0.0               44.0   \n",
      "Greece                          0.0                0.0   \n",
      "Hong Kong                       0.0               29.0   \n",
      "Indonesia                      53.0               25.0   \n",
      "Iran                            0.0               12.0   \n",
      "Italy                          21.0               24.0   \n",
      "Japan                           0.0               23.0   \n",
      "Kenya                           0.0                0.0   \n",
      "Korea                           0.0               25.0   \n",
      "Kuwait                          0.0                0.0   \n",
      "Malaysia                       19.0               13.0   \n",
      "Mexico                          0.0                0.0   \n",
      "Netherland                      0.0               56.0   \n",
      "Nigeria                         0.0               13.0   \n",
      "Norway                          0.0                0.0   \n",
      "Other Countries               114.0              176.0   \n",
      "Pakistan                        0.0                0.0   \n",
      "Philippines                     0.0                0.0   \n",
      "Poland                          0.0               14.0   \n",
      "Portugal                        0.0               15.0   \n",
      "Russia                          0.0                0.0   \n",
      "Saudi Arabia                    0.0                0.0   \n",
      "Singapore                       0.0               52.0   \n",
      "South Africa                    0.0                0.0   \n",
      "Spain                           0.0               32.0   \n",
      "Sri Lanka                      70.0                0.0   \n",
      "Sweden                         14.0                0.0   \n",
      "Switzerland                     0.0                0.0   \n",
      "Syria                           0.0                0.0   \n",
      "Taiwan                         16.0               19.0   \n",
      "Thailand                       18.0               32.0   \n",
      "Turkey                          0.0               17.0   \n",
      "UAE                             0.0                0.0   \n",
      "UK                             11.0               27.0   \n",
      "US                             39.0              143.0   \n",
      "Vietnam                         0.0               38.0   \n",
      "\n",
      "Commodity Group      Pharmaceutical Products  Plastic and Articles there of  \\\n",
      "Name of the Country                                                           \n",
      "Algeria                                  0.0                            0.0   \n",
      "Argentina                                0.0                            0.0   \n",
      "Australia                               51.0                           13.0   \n",
      "Austria                                  0.0                            0.0   \n",
      "Bahrain                                  0.0                            0.0   \n",
      "Belgium                                  0.0                           12.0   \n",
      "Brazil                                  72.0                            0.0   \n",
      "Canada                                   0.0                            0.0   \n",
      "China                                    0.0                           14.0   \n",
      "Columbia                                 0.0                            0.0   \n",
      "Czechoslovakia                           0.0                            0.0   \n",
      "Denmark                                  0.0                           35.0   \n",
      "Egypt                                    0.0                            0.0   \n",
      "Finland                                  0.0                            0.0   \n",
      "France                                   0.0                            0.0   \n",
      "Germany                                 16.0                            0.0   \n",
      "Greece                                   0.0                            0.0   \n",
      "Hong Kong                                0.0                           16.0   \n",
      "Indonesia                                0.0                            0.0   \n",
      "Iran                                     0.0                           14.0   \n",
      "Italy                                    0.0                           30.0   \n",
      "Japan                                    0.0                            0.0   \n",
      "Kenya                                    0.0                            0.0   \n",
      "Korea                                    0.0                            0.0   \n",
      "Kuwait                                   0.0                            0.0   \n",
      "Malaysia                                 0.0                            0.0   \n",
      "Mexico                                   0.0                            0.0   \n",
      "Netherland                              41.0                            0.0   \n",
      "Nigeria                                 40.0                            0.0   \n",
      "Norway                                   0.0                            0.0   \n",
      "Other Countries                        261.0                          135.0   \n",
      "Pakistan                                 0.0                            0.0   \n",
      "Philippines                              0.0                            0.0   \n",
      "Poland                                   0.0                            0.0   \n",
      "Portugal                                 0.0                            0.0   \n",
      "Russia                                   0.0                            0.0   \n",
      "Saudi Arabia                             0.0                            0.0   \n",
      "Singapore                                0.0                           14.0   \n",
      "South Africa                            12.0                            0.0   \n",
      "Spain                                    0.0                           11.0   \n",
      "Sri Lanka                               51.0                            0.0   \n",
      "Sweden                                   0.0                            0.0   \n",
      "Switzerland                              0.0                            0.0   \n",
      "Syria                                    0.0                            0.0   \n",
      "Taiwan                                   0.0                            0.0   \n",
      "Thailand                                 0.0                           38.0   \n",
      "Turkey                                  27.0                            0.0   \n",
      "UAE                                      0.0                           25.0   \n",
      "UK                                      58.0                           38.0   \n",
      "US                                      26.0                           75.0   \n",
      "Vietnam                                 35.0                            0.0   \n",
      "\n",
      "Commodity Group      Raw hides,skins and leather  \\\n",
      "Name of the Country                                \n",
      "Algeria                                      0.0   \n",
      "Argentina                                    0.0   \n",
      "Australia                                    0.0   \n",
      "Austria                                      0.0   \n",
      "Bahrain                                      0.0   \n",
      "Belgium                                      0.0   \n",
      "Brazil                                       0.0   \n",
      "Canada                                       0.0   \n",
      "China                                       13.0   \n",
      "Columbia                                     0.0   \n",
      "Czechoslovakia                               0.0   \n",
      "Denmark                                      0.0   \n",
      "Egypt                                        0.0   \n",
      "Finland                                      0.0   \n",
      "France                                      22.0   \n",
      "Germany                                     31.0   \n",
      "Greece                                       0.0   \n",
      "Hong Kong                                  220.0   \n",
      "Indonesia                                    0.0   \n",
      "Iran                                         0.0   \n",
      "Italy                                      110.0   \n",
      "Japan                                        0.0   \n",
      "Kenya                                        0.0   \n",
      "Korea                                        0.0   \n",
      "Kuwait                                       0.0   \n",
      "Malaysia                                     0.0   \n",
      "Mexico                                       0.0   \n",
      "Netherland                                  16.0   \n",
      "Nigeria                                      0.0   \n",
      "Norway                                       0.0   \n",
      "Other Countries                             66.0   \n",
      "Pakistan                                     0.0   \n",
      "Philippines                                  0.0   \n",
      "Poland                                       0.0   \n",
      "Portugal                                    17.0   \n",
      "Russia                                       0.0   \n",
      "Saudi Arabia                                 0.0   \n",
      "Singapore                                    0.0   \n",
      "South Africa                                17.0   \n",
      "Spain                                       42.0   \n",
      "Sri Lanka                                    0.0   \n",
      "Sweden                                       0.0   \n",
      "Switzerland                                  0.0   \n",
      "Syria                                        0.0   \n",
      "Taiwan                                       0.0   \n",
      "Thailand                                     0.0   \n",
      "Turkey                                       0.0   \n",
      "UAE                                          0.0   \n",
      "UK                                           0.0   \n",
      "US                                          15.0   \n",
      "Vietnam                                     24.0   \n",
      "\n",
      "Commodity Group      Rubber and articles there of  \\\n",
      "Name of the Country                                 \n",
      "Algeria                                       0.0   \n",
      "Argentina                                     0.0   \n",
      "Australia                                    32.0   \n",
      "Austria                                       0.0   \n",
      "Bahrain                                       0.0   \n",
      "Belgium                                       0.0   \n",
      "Brazil                                       10.0   \n",
      "Canada                                        0.0   \n",
      "China                                         0.0   \n",
      "Columbia                                      0.0   \n",
      "Czechoslovakia                                0.0   \n",
      "Denmark                                       0.0   \n",
      "Egypt                                        20.0   \n",
      "Finland                                       0.0   \n",
      "France                                        0.0   \n",
      "Germany                                      12.0   \n",
      "Greece                                        0.0   \n",
      "Hong Kong                                     0.0   \n",
      "Indonesia                                    18.0   \n",
      "Iran                                         43.0   \n",
      "Italy                                        23.0   \n",
      "Japan                                         0.0   \n",
      "Kenya                                        22.0   \n",
      "Korea                                         0.0   \n",
      "Kuwait                                        0.0   \n",
      "Malaysia                                     13.0   \n",
      "Mexico                                        0.0   \n",
      "Netherland                                   13.0   \n",
      "Nigeria                                      66.0   \n",
      "Norway                                        0.0   \n",
      "Other Countries                             249.0   \n",
      "Pakistan                                     66.0   \n",
      "Philippines                                  87.0   \n",
      "Poland                                        0.0   \n",
      "Portugal                                      0.0   \n",
      "Russia                                        0.0   \n",
      "Saudi Arabia                                 18.0   \n",
      "Singapore                                    23.0   \n",
      "South Africa                                  0.0   \n",
      "Spain                                         0.0   \n",
      "Sri Lanka                                    16.0   \n",
      "Sweden                                        0.0   \n",
      "Switzerland                                   0.0   \n",
      "Syria                                         0.0   \n",
      "Taiwan                                        0.0   \n",
      "Thailand                                      0.0   \n",
      "Turkey                                        0.0   \n",
      "UAE                                          17.0   \n",
      "UK                                            0.0   \n",
      "US                                           62.0   \n",
      "Vietnam                                      22.0   \n",
      "\n",
      "Commodity Group      Salt,Sulphur,Plastering Materials,Lime and Cement  \\\n",
      "Name of the Country                                                      \n",
      "Algeria                                                            0.0   \n",
      "Argentina                                                          0.0   \n",
      "Australia                                                          0.0   \n",
      "Austria                                                            0.0   \n",
      "Bahrain                                                            0.0   \n",
      "Belgium                                                           24.0   \n",
      "Brazil                                                             0.0   \n",
      "Canada                                                            13.0   \n",
      "China                                                            341.0   \n",
      "Columbia                                                           0.0   \n",
      "Czechoslovakia                                                     0.0   \n",
      "Denmark                                                            0.0   \n",
      "Egypt                                                              0.0   \n",
      "Finland                                                            0.0   \n",
      "France                                                             0.0   \n",
      "Germany                                                           16.0   \n",
      "Greece                                                             0.0   \n",
      "Hong Kong                                                        112.0   \n",
      "Indonesia                                                          0.0   \n",
      "Iran                                                               0.0   \n",
      "Italy                                                            147.0   \n",
      "Japan                                                             28.0   \n",
      "Kenya                                                              0.0   \n",
      "Korea                                                              0.0   \n",
      "Kuwait                                                             0.0   \n",
      "Malaysia                                                           0.0   \n",
      "Mexico                                                            15.0   \n",
      "Netherland                                                        13.0   \n",
      "Nigeria                                                            0.0   \n",
      "Norway                                                             0.0   \n",
      "Other Countries                                                  109.0   \n",
      "Pakistan                                                           0.0   \n",
      "Philippines                                                        0.0   \n",
      "Poland                                                             0.0   \n",
      "Portugal                                                           0.0   \n",
      "Russia                                                             0.0   \n",
      "Saudi Arabia                                                      35.0   \n",
      "Singapore                                                          0.0   \n",
      "South Africa                                                       0.0   \n",
      "Spain                                                             28.0   \n",
      "Sri Lanka                                                          0.0   \n",
      "Sweden                                                             0.0   \n",
      "Switzerland                                                        0.0   \n",
      "Syria                                                              0.0   \n",
      "Taiwan                                                            92.0   \n",
      "Thailand                                                          12.0   \n",
      "Turkey                                                             0.0   \n",
      "UAE                                                               20.0   \n",
      "UK                                                                17.0   \n",
      "US                                                                85.0   \n",
      "Vietnam                                                           11.0   \n",
      "\n",
      "Commodity Group      Tobacco and manufactured tobacco substitutes  \\\n",
      "Name of the Country                                                 \n",
      "Algeria                                                       0.0   \n",
      "Argentina                                                     0.0   \n",
      "Australia                                                    40.0   \n",
      "Austria                                                       0.0   \n",
      "Bahrain                                                       0.0   \n",
      "Belgium                                                     256.0   \n",
      "Brazil                                                       16.0   \n",
      "Canada                                                        0.0   \n",
      "China                                                         0.0   \n",
      "Columbia                                                      0.0   \n",
      "Czechoslovakia                                                0.0   \n",
      "Denmark                                                       0.0   \n",
      "Egypt                                                        42.0   \n",
      "Finland                                                       0.0   \n",
      "France                                                       21.0   \n",
      "Germany                                                     115.0   \n",
      "Greece                                                        0.0   \n",
      "Hong Kong                                                     0.0   \n",
      "Indonesia                                                    26.0   \n",
      "Iran                                                          0.0   \n",
      "Italy                                                         0.0   \n",
      "Japan                                                         0.0   \n",
      "Kenya                                                         0.0   \n",
      "Korea                                                        63.0   \n",
      "Kuwait                                                        0.0   \n",
      "Malaysia                                                     19.0   \n",
      "Mexico                                                        0.0   \n",
      "Netherland                                                   76.0   \n",
      "Nigeria                                                      10.0   \n",
      "Norway                                                        0.0   \n",
      "Other Countries                                             185.0   \n",
      "Pakistan                                                      0.0   \n",
      "Philippines                                                 120.0   \n",
      "Poland                                                       24.0   \n",
      "Portugal                                                      0.0   \n",
      "Russia                                                      127.0   \n",
      "Saudi Arabia                                                  0.0   \n",
      "Singapore                                                    21.0   \n",
      "South Africa                                                 61.0   \n",
      "Spain                                                         0.0   \n",
      "Sri Lanka                                                     0.0   \n",
      "Sweden                                                        0.0   \n",
      "Switzerland                                                   0.0   \n",
      "Syria                                                         0.0   \n",
      "Taiwan                                                        0.0   \n",
      "Thailand                                                      0.0   \n",
      "Turkey                                                        0.0   \n",
      "UAE                                                          21.0   \n",
      "UK                                                           63.0   \n",
      "US                                                           25.0   \n",
      "Vietnam                                                      67.0   \n",
      "\n",
      "Commodity Group      Vehicles other than Railway,Tramway,Rolling Stock and parts and accessories there of  \n",
      "Name of the Country                                                                                        \n",
      "Algeria                                                          386.0                                     \n",
      "Argentina                                                        120.0                                     \n",
      "Australia                                                         30.0                                     \n",
      "Austria                                                           64.0                                     \n",
      "Bahrain                                                            0.0                                     \n",
      "Belgium                                                           63.0                                     \n",
      "Brazil                                                             0.0                                     \n",
      "Canada                                                             0.0                                     \n",
      "China                                                             21.0                                     \n",
      "Columbia                                                         251.0                                     \n",
      "Czechoslovakia                                                    77.0                                     \n",
      "Denmark                                                           46.0                                     \n",
      "Egypt                                                            140.0                                     \n",
      "Finland                                                           49.0                                     \n",
      "France                                                           128.0                                     \n",
      "Germany                                                          224.0                                     \n",
      "Greece                                                           228.0                                     \n",
      "Hong Kong                                                          0.0                                     \n",
      "Indonesia                                                         23.0                                     \n",
      "Iran                                                              26.0                                     \n",
      "Italy                                                            550.0                                     \n",
      "Japan                                                             11.0                                     \n",
      "Kenya                                                             41.0                                     \n",
      "Korea                                                            139.0                                     \n",
      "Kuwait                                                             0.0                                     \n",
      "Malaysia                                                          13.0                                     \n",
      "Mexico                                                           260.0                                     \n",
      "Netherland                                                       185.0                                     \n",
      "Nigeria                                                           25.0                                     \n",
      "Norway                                                            23.0                                     \n",
      "Other Countries                                                  472.0                                     \n",
      "Pakistan                                                           0.0                                     \n",
      "Philippines                                                        0.0                                     \n",
      "Poland                                                            50.0                                     \n",
      "Portugal                                                          26.0                                     \n",
      "Russia                                                             0.0                                     \n",
      "Saudi Arabia                                                       0.0                                     \n",
      "Singapore                                                        146.0                                     \n",
      "South Africa                                                     293.0                                     \n",
      "Spain                                                            106.0                                     \n",
      "Sri Lanka                                                         75.0                                     \n",
      "Sweden                                                            66.0                                     \n",
      "Switzerland                                                       44.0                                     \n",
      "Syria                                                             24.0                                     \n",
      "Taiwan                                                             0.0                                     \n",
      "Thailand                                                         184.0                                     \n",
      "Turkey                                                            73.0                                     \n",
      "UAE                                                               31.0                                     \n",
      "UK                                                               293.0                                     \n",
      "US                                                               366.0                                     \n",
      "Vietnam                                                            0.0                                     \n"
     ]
    }
   ],
   "source": [
    "with pd.option_context('display.max_rows', None, 'display.max_columns', None):  # more options can be specified also\n",
    "    print(pivot_table)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 156,
   "metadata": {},
   "outputs": [],
   "source": [
    "pivot_table.to_json('./datasets/export_commodities_by_sea.json')"
   ]
  },
  {
   "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}