Final Data Cleaning.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Essential oils and resinoids,perfumery</th>\n",
       "      <th>Fish and Crustaceans,Mollassesand other Aquatic invertebrates</th>\n",
       "      <th>Footwear,Guiters and Parts of such articles</th>\n",
       "      <th>Organic Chemicals</th>\n",
       "      <th>Other made up textiles articles sets worn clothing,worn textiles articles</th>\n",
       "      <th>Pharmaceutical Products</th>\n",
       "      <th>Raw Hides,Skins and leather</th>\n",
       "      <th>Vehicles other than Tramway,rolling stock and parts and accessories thereof</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Austria</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>China</th>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>53</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Finland</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>France</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Germany</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>161</td>\n",
       "      <td>31</td>\n",
       "      <td>6</td>\n",
       "      <td>15</td>\n",
       "      <td>42</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hong Kong</th>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>364</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hungary</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Indonesia</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Italy</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>228</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>39</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Japan</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>South Korea</th>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Netherlands</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Countries</th>\n",
       "      <td>80</td>\n",
       "      <td>28</td>\n",
       "      <td>129</td>\n",
       "      <td>127</td>\n",
       "      <td>18</td>\n",
       "      <td>95</td>\n",
       "      <td>47</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Portugal</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>56</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Singapore</th>\n",
       "      <td>0</td>\n",
       "      <td>36</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spain</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>58</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Switzerland</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thailand</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Turkey</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>United Kingdom</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>128</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>United States</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>47</td>\n",
       "      <td>53</td>\n",
       "      <td>36</td>\n",
       "      <td>179</td>\n",
       "      <td>10</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vietnam</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>63</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Essential oils and resinoids,perfumery  \\\n",
       "Austria                                               0   \n",
       "China                                                38   \n",
       "Finland                                               0   \n",
       "France                                                0   \n",
       "Germany                                               0   \n",
       "Hong Kong                                             0   \n",
       "Hungary                                               0   \n",
       "Indonesia                                             0   \n",
       "Italy                                                 0   \n",
       "Japan                                                 0   \n",
       "South Korea                                          16   \n",
       "Netherlands                                           0   \n",
       "Other Countries                                      80   \n",
       "Portugal                                              0   \n",
       "Singapore                                             0   \n",
       "Spain                                                 0   \n",
       "Switzerland                                           0   \n",
       "Thailand                                              0   \n",
       "Turkey                                                0   \n",
       "United Kingdom                                        0   \n",
       "United States                                         0   \n",
       "Vietnam                                               0   \n",
       "\n",
       "                 Fish and Crustaceans,Mollassesand other Aquatic invertebrates  \\\n",
       "Austria                                                          0               \n",
       "China                                                            0               \n",
       "Finland                                                          0               \n",
       "France                                                           0               \n",
       "Germany                                                          0               \n",
       "Hong Kong                                                       20               \n",
       "Hungary                                                          0               \n",
       "Indonesia                                                        0               \n",
       "Italy                                                            0               \n",
       "Japan                                                            0               \n",
       "South Korea                                                      0               \n",
       "Netherlands                                                      0               \n",
       "Other Countries                                                 28               \n",
       "Portugal                                                         0               \n",
       "Singapore                                                       36               \n",
       "Spain                                                            0               \n",
       "Switzerland                                                      0               \n",
       "Thailand                                                         0               \n",
       "Turkey                                                           0               \n",
       "United Kingdom                                                   0               \n",
       "United States                                                    0               \n",
       "Vietnam                                                          0               \n",
       "\n",
       "                 Footwear,Guiters and Parts of such articles  \\\n",
       "Austria                                                   28   \n",
       "China                                                      0   \n",
       "Finland                                                   11   \n",
       "France                                                   100   \n",
       "Germany                                                  161   \n",
       "Hong Kong                                                  0   \n",
       "Hungary                                                   25   \n",
       "Indonesia                                                  0   \n",
       "Italy                                                    228   \n",
       "Japan                                                      0   \n",
       "South Korea                                                0   \n",
       "Netherlands                                               13   \n",
       "Other Countries                                          129   \n",
       "Portugal                                                  56   \n",
       "Singapore                                                  0   \n",
       "Spain                                                     58   \n",
       "Switzerland                                               40   \n",
       "Thailand                                                  34   \n",
       "Turkey                                                     0   \n",
       "United Kingdom                                           128   \n",
       "United States                                             47   \n",
       "Vietnam                                                    0   \n",
       "\n",
       "                 Organic Chemicals  \\\n",
       "Austria                          0   \n",
       "China                           53   \n",
       "Finland                          0   \n",
       "France                           0   \n",
       "Germany                         31   \n",
       "Hong Kong                        0   \n",
       "Hungary                          0   \n",
       "Indonesia                        0   \n",
       "Italy                           15   \n",
       "Japan                            0   \n",
       "South Korea                     20   \n",
       "Netherlands                      0   \n",
       "Other Countries                127   \n",
       "Portugal                         0   \n",
       "Singapore                       34   \n",
       "Spain                            0   \n",
       "Switzerland                      0   \n",
       "Thailand                         0   \n",
       "Turkey                          21   \n",
       "United Kingdom                  10   \n",
       "United States                   53   \n",
       "Vietnam                          0   \n",
       "\n",
       "                 Other made up textiles articles sets worn clothing,worn textiles articles  \\\n",
       "Austria                                                          0                           \n",
       "China                                                            0                           \n",
       "Finland                                                          0                           \n",
       "France                                                           6                           \n",
       "Germany                                                          6                           \n",
       "Hong Kong                                                        0                           \n",
       "Hungary                                                          0                           \n",
       "Indonesia                                                        0                           \n",
       "Italy                                                            0                           \n",
       "Japan                                                            5                           \n",
       "South Korea                                                      0                           \n",
       "Netherlands                                                      0                           \n",
       "Other Countries                                                 18                           \n",
       "Portugal                                                         0                           \n",
       "Singapore                                                        0                           \n",
       "Spain                                                            0                           \n",
       "Switzerland                                                      0                           \n",
       "Thailand                                                         0                           \n",
       "Turkey                                                           0                           \n",
       "United Kingdom                                                  10                           \n",
       "United States                                                   36                           \n",
       "Vietnam                                                          0                           \n",
       "\n",
       "                 Pharmaceutical Products  Raw Hides,Skins and leather  \\\n",
       "Austria                                0                            0   \n",
       "China                                  5                           34   \n",
       "Finland                                0                            0   \n",
       "France                                 0                            8   \n",
       "Germany                               15                           42   \n",
       "Hong Kong                              0                          364   \n",
       "Hungary                                0                            0   \n",
       "Indonesia                              0                            8   \n",
       "Italy                                  5                           39   \n",
       "Japan                                  0                            9   \n",
       "South Korea                            0                           40   \n",
       "Netherlands                            0                            0   \n",
       "Other Countries                       95                           47   \n",
       "Portugal                               0                            0   \n",
       "Singapore                              0                            0   \n",
       "Spain                                  0                           13   \n",
       "Switzerland                            0                            0   \n",
       "Thailand                               0                            0   \n",
       "Turkey                                 0                            0   \n",
       "United Kingdom                         0                            0   \n",
       "United States                        179                           10   \n",
       "Vietnam                                0                           63   \n",
       "\n",
       "                 Vehicles other than Tramway,rolling stock and parts and accessories thereof  \n",
       "Austria                                                          0                            \n",
       "China                                                            0                            \n",
       "Finland                                                          0                            \n",
       "France                                                           0                            \n",
       "Germany                                                          9                            \n",
       "Hong Kong                                                        0                            \n",
       "Hungary                                                          0                            \n",
       "Indonesia                                                        0                            \n",
       "Italy                                                            0                            \n",
       "Japan                                                            0                            \n",
       "South Korea                                                      0                            \n",
       "Netherlands                                                      0                            \n",
       "Other Countries                                                 25                            \n",
       "Portugal                                                         0                            \n",
       "Singapore                                                        0                            \n",
       "Spain                                                            0                            \n",
       "Switzerland                                                      0                            \n",
       "Thailand                                                         0                            \n",
       "Turkey                                                           0                            \n",
       "United Kingdom                                                   6                            \n",
       "United States                                                   16                            \n",
       "Vietnam                                                          0                            "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_json('./final_datasets/export_commodities_by_air.json')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Algeria</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>386</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Argentina</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Australia</th>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>51</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Austria</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bahrain</th>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Belgium</th>\n",
       "      <td>0</td>\n",
       "      <td>153</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>256</td>\n",
       "      <td>63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Brazil</th>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>44</td>\n",
       "      <td>72</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Canada</th>\n",
       "      <td>0</td>\n",
       "      <td>75</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>China</th>\n",
       "      <td>121</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>341</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Colombia</th>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>251</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Czech Republic</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Denmark</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Egypt</th>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "      <td>140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Finland</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>France</th>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>56</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Germany</th>\n",
       "      <td>14</td>\n",
       "      <td>53</td>\n",
       "      <td>255</td>\n",
       "      <td>0</td>\n",
       "      <td>44</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>12</td>\n",
       "      <td>16</td>\n",
       "      <td>115</td>\n",
       "      <td>224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Greece</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>228</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hong Kong</th>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>220</td>\n",
       "      <td>0</td>\n",
       "      <td>112</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Indonesia</th>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>53</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>26</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Iran</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>43</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Italy</th>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>394</td>\n",
       "      <td>21</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>30</td>\n",
       "      <td>110</td>\n",
       "      <td>23</td>\n",
       "      <td>147</td>\n",
       "      <td>0</td>\n",
       "      <td>550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Japan</th>\n",
       "      <td>42</td>\n",
       "      <td>51</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kenya</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>South Korea</th>\n",
       "      <td>230</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>63</td>\n",
       "      <td>139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kuwait</th>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Malaysia</th>\n",
       "      <td>44</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mexico</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Netherlands</th>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>93</td>\n",
       "      <td>0</td>\n",
       "      <td>56</td>\n",
       "      <td>41</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>76</td>\n",
       "      <td>185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nigeria</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>66</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Norway</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Countries</th>\n",
       "      <td>406</td>\n",
       "      <td>111</td>\n",
       "      <td>61</td>\n",
       "      <td>114</td>\n",
       "      <td>176</td>\n",
       "      <td>261</td>\n",
       "      <td>135</td>\n",
       "      <td>66</td>\n",
       "      <td>249</td>\n",
       "      <td>109</td>\n",
       "      <td>185</td>\n",
       "      <td>472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pakistan</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>66</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Philippines</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>87</td>\n",
       "      <td>0</td>\n",
       "      <td>120</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Poland</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Portugal</th>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>60</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Russia</th>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>127</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Saudi Arabia</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Singapore</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>South Africa</th>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>61</td>\n",
       "      <td>293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spain</th>\n",
       "      <td>0</td>\n",
       "      <td>69</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sri Lanka</th>\n",
       "      <td>84</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>70</td>\n",
       "      <td>0</td>\n",
       "      <td>51</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sweden</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Switzerland</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Syria</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Taiwan</th>\n",
       "      <td>59</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>92</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thailand</th>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>32</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Turkey</th>\n",
       "      <td>143</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>United Arab Emirates</th>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>20</td>\n",
       "      <td>21</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>United Kingdom</th>\n",
       "      <td>11</td>\n",
       "      <td>133</td>\n",
       "      <td>192</td>\n",
       "      <td>11</td>\n",
       "      <td>27</td>\n",
       "      <td>58</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>63</td>\n",
       "      <td>293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>United States</th>\n",
       "      <td>40</td>\n",
       "      <td>222</td>\n",
       "      <td>375</td>\n",
       "      <td>39</td>\n",
       "      <td>143</td>\n",
       "      <td>26</td>\n",
       "      <td>75</td>\n",
       "      <td>15</td>\n",
       "      <td>62</td>\n",
       "      <td>85</td>\n",
       "      <td>25</td>\n",
       "      <td>366</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vietnam</th>\n",
       "      <td>55</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>22</td>\n",
       "      <td>11</td>\n",
       "      <td>67</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      Cotton  \\\n",
       "Algeria                    0   \n",
       "Argentina                  0   \n",
       "Australia                  0   \n",
       "Austria                    0   \n",
       "Bahrain                   26   \n",
       "Belgium                    0   \n",
       "Brazil                    14   \n",
       "Canada                     0   \n",
       "China                    121   \n",
       "Colombia                  13   \n",
       "Czech Republic             0   \n",
       "Denmark                    0   \n",
       "Egypt                     14   \n",
       "Finland                    0   \n",
       "France                     0   \n",
       "Germany                   14   \n",
       "Greece                     0   \n",
       "Hong Kong                 25   \n",
       "Indonesia                 18   \n",
       "Iran                       0   \n",
       "Italy                     24   \n",
       "Japan                     42   \n",
       "Kenya                      0   \n",
       "South Korea              230   \n",
       "Kuwait                     0   \n",
       "Malaysia                  44   \n",
       "Mexico                     0   \n",
       "Netherlands                0   \n",
       "Nigeria                    0   \n",
       "Norway                     0   \n",
       "Other Countries          406   \n",
       "Pakistan                   0   \n",
       "Philippines                0   \n",
       "Poland                     0   \n",
       "Portugal                  11   \n",
       "Russia                    50   \n",
       "Saudi Arabia               0   \n",
       "Singapore                  0   \n",
       "South Africa               0   \n",
       "Spain                      0   \n",
       "Sri Lanka                 84   \n",
       "Sweden                     0   \n",
       "Switzerland                0   \n",
       "Syria                      0   \n",
       "Taiwan                    59   \n",
       "Thailand                  19   \n",
       "Turkey                   143   \n",
       "United Arab Emirates      37   \n",
       "United Kingdom            11   \n",
       "United States             40   \n",
       "Vietnam                   55   \n",
       "\n",
       "                      Fish and Crustaceans,Molasses and other Acquatic invertibrates  \\\n",
       "Algeria                                                               0                \n",
       "Argentina                                                             0                \n",
       "Australia                                                            21                \n",
       "Austria                                                               0                \n",
       "Bahrain                                                               0                \n",
       "Belgium                                                             153                \n",
       "Brazil                                                                0                \n",
       "Canada                                                               75                \n",
       "China                                                                 0                \n",
       "Colombia                                                              0                \n",
       "Czech Republic                                                        0                \n",
       "Denmark                                                               0                \n",
       "Egypt                                                                 0                \n",
       "Finland                                                               0                \n",
       "France                                                               25                \n",
       "Germany                                                              53                \n",
       "Greece                                                                0                \n",
       "Hong Kong                                                             0                \n",
       "Indonesia                                                             0                \n",
       "Iran                                                                  0                \n",
       "Italy                                                                 0                \n",
       "Japan                                                                51                \n",
       "Kenya                                                                 0                \n",
       "South Korea                                                           0                \n",
       "Kuwait                                                               11                \n",
       "Malaysia                                                             23                \n",
       "Mexico                                                                0                \n",
       "Netherlands                                                          14                \n",
       "Nigeria                                                               0                \n",
       "Norway                                                                0                \n",
       "Other Countries                                                     111                \n",
       "Pakistan                                                              0                \n",
       "Philippines                                                           0                \n",
       "Poland                                                                0                \n",
       "Portugal                                                              0                \n",
       "Russia                                                                0                \n",
       "Saudi Arabia                                                          0                \n",
       "Singapore                                                             0                \n",
       "South Africa                                                         20                \n",
       "Spain                                                                69                \n",
       "Sri Lanka                                                             0                \n",
       "Sweden                                                                0                \n",
       "Switzerland                                                           0                \n",
       "Syria                                                                 0                \n",
       "Taiwan                                                                0                \n",
       "Thailand                                                              0                \n",
       "Turkey                                                                0                \n",
       "United Arab Emirates                                                 37                \n",
       "United Kingdom                                                      133                \n",
       "United States                                                       222                \n",
       "Vietnam                                                               0                \n",
       "\n",
       "                      Footwear,guiter and parts of such articles  \\\n",
       "Algeria                                                        0   \n",
       "Argentina                                                      0   \n",
       "Australia                                                     13   \n",
       "Austria                                                        0   \n",
       "Bahrain                                                        0   \n",
       "Belgium                                                       25   \n",
       "Brazil                                                         0   \n",
       "Canada                                                        12   \n",
       "China                                                          0   \n",
       "Colombia                                                       0   \n",
       "Czech Republic                                                 0   \n",
       "Denmark                                                        0   \n",
       "Egypt                                                          0   \n",
       "Finland                                                        0   \n",
       "France                                                        56   \n",
       "Germany                                                      255   \n",
       "Greece                                                         0   \n",
       "Hong Kong                                                     13   \n",
       "Indonesia                                                      0   \n",
       "Iran                                                           0   \n",
       "Italy                                                        394   \n",
       "Japan                                                          0   \n",
       "Kenya                                                          0   \n",
       "South Korea                                                    0   \n",
       "Kuwait                                                         0   \n",
       "Malaysia                                                       0   \n",
       "Mexico                                                         0   \n",
       "Netherlands                                                   93   \n",
       "Nigeria                                                        0   \n",
       "Norway                                                         0   \n",
       "Other Countries                                               61   \n",
       "Pakistan                                                       0   \n",
       "Philippines                                                    0   \n",
       "Poland                                                         0   \n",
       "Portugal                                                      60   \n",
       "Russia                                                         0   \n",
       "Saudi Arabia                                                   0   \n",
       "Singapore                                                      0   \n",
       "South Africa                                                   0   \n",
       "Spain                                                         14   \n",
       "Sri Lanka                                                      0   \n",
       "Sweden                                                         0   \n",
       "Switzerland                                                    0   \n",
       "Syria                                                          0   \n",
       "Taiwan                                                         0   \n",
       "Thailand                                                       0   \n",
       "Turkey                                                         0   \n",
       "United Arab Emirates                                          15   \n",
       "United Kingdom                                               192   \n",
       "United States                                                375   \n",
       "Vietnam                                                        0   \n",
       "\n",
       "                      Iron and Steel  Organic Chemicals  \\\n",
       "Algeria                            0                  0   \n",
       "Argentina                          0                 12   \n",
       "Australia                          0                  0   \n",
       "Austria                            0                  0   \n",
       "Bahrain                            0                  0   \n",
       "Belgium                            0                 13   \n",
       "Brazil                             0                 44   \n",
       "Canada                             0                 11   \n",
       "China                             12                 13   \n",
       "Colombia                           0                 13   \n",
       "Czech Republic                     0                  0   \n",
       "Denmark                            0                  0   \n",
       "Egypt                              0                  0   \n",
       "Finland                            0                  0   \n",
       "France                            14                  0   \n",
       "Germany                            0                 44   \n",
       "Greece                             0                  0   \n",
       "Hong Kong                          0                 29   \n",
       "Indonesia                         53                 25   \n",
       "Iran                               0                 12   \n",
       "Italy                             21                 24   \n",
       "Japan                              0                 23   \n",
       "Kenya                              0                  0   \n",
       "South Korea                        0                 25   \n",
       "Kuwait                             0                  0   \n",
       "Malaysia                          19                 13   \n",
       "Mexico                             0                  0   \n",
       "Netherlands                        0                 56   \n",
       "Nigeria                            0                 13   \n",
       "Norway                             0                  0   \n",
       "Other Countries                  114                176   \n",
       "Pakistan                           0                  0   \n",
       "Philippines                        0                  0   \n",
       "Poland                             0                 14   \n",
       "Portugal                           0                 15   \n",
       "Russia                             0                  0   \n",
       "Saudi Arabia                       0                  0   \n",
       "Singapore                          0                 52   \n",
       "South Africa                       0                  0   \n",
       "Spain                              0                 32   \n",
       "Sri Lanka                         70                  0   \n",
       "Sweden                            14                  0   \n",
       "Switzerland                        0                  0   \n",
       "Syria                              0                  0   \n",
       "Taiwan                            16                 19   \n",
       "Thailand                          18                 32   \n",
       "Turkey                             0                 17   \n",
       "United Arab Emirates               0                  0   \n",
       "United Kingdom                    11                 27   \n",
       "United States                     39                143   \n",
       "Vietnam                            0                 38   \n",
       "\n",
       "                      Pharmaceutical Products  Plastic and Articles there of  \\\n",
       "Algeria                                     0                              0   \n",
       "Argentina                                   0                              0   \n",
       "Australia                                  51                             13   \n",
       "Austria                                     0                              0   \n",
       "Bahrain                                     0                              0   \n",
       "Belgium                                     0                             12   \n",
       "Brazil                                     72                              0   \n",
       "Canada                                      0                              0   \n",
       "China                                       0                             14   \n",
       "Colombia                                    0                              0   \n",
       "Czech Republic                              0                              0   \n",
       "Denmark                                     0                             35   \n",
       "Egypt                                       0                              0   \n",
       "Finland                                     0                              0   \n",
       "France                                      0                              0   \n",
       "Germany                                    16                              0   \n",
       "Greece                                      0                              0   \n",
       "Hong Kong                                   0                             16   \n",
       "Indonesia                                   0                              0   \n",
       "Iran                                        0                             14   \n",
       "Italy                                       0                             30   \n",
       "Japan                                       0                              0   \n",
       "Kenya                                       0                              0   \n",
       "South Korea                                 0                              0   \n",
       "Kuwait                                      0                              0   \n",
       "Malaysia                                    0                              0   \n",
       "Mexico                                      0                              0   \n",
       "Netherlands                                41                              0   \n",
       "Nigeria                                    40                              0   \n",
       "Norway                                      0                              0   \n",
       "Other Countries                           261                            135   \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                             14   \n",
       "South Africa                               12                              0   \n",
       "Spain                                       0                             11   \n",
       "Sri Lanka                                  51                              0   \n",
       "Sweden                                      0                              0   \n",
       "Switzerland                                 0                              0   \n",
       "Syria                                       0                              0   \n",
       "Taiwan                                      0                              0   \n",
       "Thailand                                    0                             38   \n",
       "Turkey                                     27                              0   \n",
       "United Arab Emirates                        0                             25   \n",
       "United Kingdom                             58                             38   \n",
       "United States                              26                             75   \n",
       "Vietnam                                    35                              0   \n",
       "\n",
       "                      Raw hides,skins and leather  \\\n",
       "Algeria                                         0   \n",
       "Argentina                                       0   \n",
       "Australia                                       0   \n",
       "Austria                                         0   \n",
       "Bahrain                                         0   \n",
       "Belgium                                         0   \n",
       "Brazil                                          0   \n",
       "Canada                                          0   \n",
       "China                                          13   \n",
       "Colombia                                        0   \n",
       "Czech Republic                                  0   \n",
       "Denmark                                         0   \n",
       "Egypt                                           0   \n",
       "Finland                                         0   \n",
       "France                                         22   \n",
       "Germany                                        31   \n",
       "Greece                                          0   \n",
       "Hong Kong                                     220   \n",
       "Indonesia                                       0   \n",
       "Iran                                            0   \n",
       "Italy                                         110   \n",
       "Japan                                           0   \n",
       "Kenya                                           0   \n",
       "South Korea                                     0   \n",
       "Kuwait                                          0   \n",
       "Malaysia                                        0   \n",
       "Mexico                                          0   \n",
       "Netherlands                                    16   \n",
       "Nigeria                                         0   \n",
       "Norway                                          0   \n",
       "Other Countries                                66   \n",
       "Pakistan                                        0   \n",
       "Philippines                                     0   \n",
       "Poland                                          0   \n",
       "Portugal                                       17   \n",
       "Russia                                          0   \n",
       "Saudi Arabia                                    0   \n",
       "Singapore                                       0   \n",
       "South Africa                                   17   \n",
       "Spain                                          42   \n",
       "Sri Lanka                                       0   \n",
       "Sweden                                          0   \n",
       "Switzerland                                     0   \n",
       "Syria                                           0   \n",
       "Taiwan                                          0   \n",
       "Thailand                                        0   \n",
       "Turkey                                          0   \n",
       "United Arab Emirates                            0   \n",
       "United Kingdom                                  0   \n",
       "United States                                  15   \n",
       "Vietnam                                        24   \n",
       "\n",
       "                      Rubber and articles there of  \\\n",
       "Algeria                                          0   \n",
       "Argentina                                        0   \n",
       "Australia                                       32   \n",
       "Austria                                          0   \n",
       "Bahrain                                          0   \n",
       "Belgium                                          0   \n",
       "Brazil                                          10   \n",
       "Canada                                           0   \n",
       "China                                            0   \n",
       "Colombia                                         0   \n",
       "Czech Republic                                   0   \n",
       "Denmark                                          0   \n",
       "Egypt                                           20   \n",
       "Finland                                          0   \n",
       "France                                           0   \n",
       "Germany                                         12   \n",
       "Greece                                           0   \n",
       "Hong Kong                                        0   \n",
       "Indonesia                                       18   \n",
       "Iran                                            43   \n",
       "Italy                                           23   \n",
       "Japan                                            0   \n",
       "Kenya                                           22   \n",
       "South Korea                                      0   \n",
       "Kuwait                                           0   \n",
       "Malaysia                                        13   \n",
       "Mexico                                           0   \n",
       "Netherlands                                     13   \n",
       "Nigeria                                         66   \n",
       "Norway                                           0   \n",
       "Other Countries                                249   \n",
       "Pakistan                                        66   \n",
       "Philippines                                     87   \n",
       "Poland                                           0   \n",
       "Portugal                                         0   \n",
       "Russia                                           0   \n",
       "Saudi Arabia                                    18   \n",
       "Singapore                                       23   \n",
       "South Africa                                     0   \n",
       "Spain                                            0   \n",
       "Sri Lanka                                       16   \n",
       "Sweden                                           0   \n",
       "Switzerland                                      0   \n",
       "Syria                                            0   \n",
       "Taiwan                                           0   \n",
       "Thailand                                         0   \n",
       "Turkey                                           0   \n",
       "United Arab Emirates                            17   \n",
       "United Kingdom                                   0   \n",
       "United States                                   62   \n",
       "Vietnam                                         22   \n",
       "\n",
       "                      Salt,Sulphur,Plastering Materials,Lime and Cement  \\\n",
       "Algeria                                                               0   \n",
       "Argentina                                                             0   \n",
       "Australia                                                             0   \n",
       "Austria                                                               0   \n",
       "Bahrain                                                               0   \n",
       "Belgium                                                              24   \n",
       "Brazil                                                                0   \n",
       "Canada                                                               13   \n",
       "China                                                               341   \n",
       "Colombia                                                              0   \n",
       "Czech Republic                                                        0   \n",
       "Denmark                                                               0   \n",
       "Egypt                                                                 0   \n",
       "Finland                                                               0   \n",
       "France                                                                0   \n",
       "Germany                                                              16   \n",
       "Greece                                                                0   \n",
       "Hong Kong                                                           112   \n",
       "Indonesia                                                             0   \n",
       "Iran                                                                  0   \n",
       "Italy                                                               147   \n",
       "Japan                                                                28   \n",
       "Kenya                                                                 0   \n",
       "South Korea                                                           0   \n",
       "Kuwait                                                                0   \n",
       "Malaysia                                                              0   \n",
       "Mexico                                                               15   \n",
       "Netherlands                                                          13   \n",
       "Nigeria                                                               0   \n",
       "Norway                                                                0   \n",
       "Other Countries                                                     109   \n",
       "Pakistan                                                              0   \n",
       "Philippines                                                           0   \n",
       "Poland                                                                0   \n",
       "Portugal                                                              0   \n",
       "Russia                                                                0   \n",
       "Saudi Arabia                                                         35   \n",
       "Singapore                                                             0   \n",
       "South Africa                                                          0   \n",
       "Spain                                                                28   \n",
       "Sri Lanka                                                             0   \n",
       "Sweden                                                                0   \n",
       "Switzerland                                                           0   \n",
       "Syria                                                                 0   \n",
       "Taiwan                                                               92   \n",
       "Thailand                                                             12   \n",
       "Turkey                                                                0   \n",
       "United Arab Emirates                                                 20   \n",
       "United Kingdom                                                       17   \n",
       "United States                                                        85   \n",
       "Vietnam                                                              11   \n",
       "\n",
       "                      Tobacco and manufactured tobacco substitutes  \\\n",
       "Algeria                                                          0   \n",
       "Argentina                                                        0   \n",
       "Australia                                                       40   \n",
       "Austria                                                          0   \n",
       "Bahrain                                                          0   \n",
       "Belgium                                                        256   \n",
       "Brazil                                                          16   \n",
       "Canada                                                           0   \n",
       "China                                                            0   \n",
       "Colombia                                                         0   \n",
       "Czech Republic                                                   0   \n",
       "Denmark                                                          0   \n",
       "Egypt                                                           42   \n",
       "Finland                                                          0   \n",
       "France                                                          21   \n",
       "Germany                                                        115   \n",
       "Greece                                                           0   \n",
       "Hong Kong                                                        0   \n",
       "Indonesia                                                       26   \n",
       "Iran                                                             0   \n",
       "Italy                                                            0   \n",
       "Japan                                                            0   \n",
       "Kenya                                                            0   \n",
       "South Korea                                                     63   \n",
       "Kuwait                                                           0   \n",
       "Malaysia                                                        19   \n",
       "Mexico                                                           0   \n",
       "Netherlands                                                     76   \n",
       "Nigeria                                                         10   \n",
       "Norway                                                           0   \n",
       "Other Countries                                                185   \n",
       "Pakistan                                                         0   \n",
       "Philippines                                                    120   \n",
       "Poland                                                          24   \n",
       "Portugal                                                         0   \n",
       "Russia                                                         127   \n",
       "Saudi Arabia                                                     0   \n",
       "Singapore                                                       21   \n",
       "South Africa                                                    61   \n",
       "Spain                                                            0   \n",
       "Sri Lanka                                                        0   \n",
       "Sweden                                                           0   \n",
       "Switzerland                                                      0   \n",
       "Syria                                                            0   \n",
       "Taiwan                                                           0   \n",
       "Thailand                                                         0   \n",
       "Turkey                                                           0   \n",
       "United Arab Emirates                                            21   \n",
       "United Kingdom                                                  63   \n",
       "United States                                                   25   \n",
       "Vietnam                                                         67   \n",
       "\n",
       "                      Vehicles other than Railway,Tramway,Rolling Stock and parts and accessories there of  \n",
       "Algeria                                                             386                                     \n",
       "Argentina                                                           120                                     \n",
       "Australia                                                            30                                     \n",
       "Austria                                                              64                                     \n",
       "Bahrain                                                               0                                     \n",
       "Belgium                                                              63                                     \n",
       "Brazil                                                                0                                     \n",
       "Canada                                                                0                                     \n",
       "China                                                                21                                     \n",
       "Colombia                                                            251                                     \n",
       "Czech Republic                                                       77                                     \n",
       "Denmark                                                              46                                     \n",
       "Egypt                                                               140                                     \n",
       "Finland                                                              49                                     \n",
       "France                                                              128                                     \n",
       "Germany                                                             224                                     \n",
       "Greece                                                              228                                     \n",
       "Hong Kong                                                             0                                     \n",
       "Indonesia                                                            23                                     \n",
       "Iran                                                                 26                                     \n",
       "Italy                                                               550                                     \n",
       "Japan                                                                11                                     \n",
       "Kenya                                                                41                                     \n",
       "South Korea                                                         139                                     \n",
       "Kuwait                                                                0                                     \n",
       "Malaysia                                                             13                                     \n",
       "Mexico                                                              260                                     \n",
       "Netherlands                                                         185                                     \n",
       "Nigeria                                                              25                                     \n",
       "Norway                                                               23                                     \n",
       "Other Countries                                                     472                                     \n",
       "Pakistan                                                              0                                     \n",
       "Philippines                                                           0                                     \n",
       "Poland                                                               50                                     \n",
       "Portugal                                                             26                                     \n",
       "Russia                                                                0                                     \n",
       "Saudi Arabia                                                          0                                     \n",
       "Singapore                                                           146                                     \n",
       "South Africa                                                        293                                     \n",
       "Spain                                                               106                                     \n",
       "Sri Lanka                                                            75                                     \n",
       "Sweden                                                               66                                     \n",
       "Switzerland                                                          44                                     \n",
       "Syria                                                                24                                     \n",
       "Taiwan                                                                0                                     \n",
       "Thailand                                                            184                                     \n",
       "Turkey                                                               73                                     \n",
       "United Arab Emirates                                                 31                                     \n",
       "United Kingdom                                                      293                                     \n",
       "United States                                                       366                                     \n",
       "Vietnam                                                               0                                     "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_json('./final_datasets/export_commodities_by_sea.json')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Animal or Vegetable fats and Oil products</th>\n",
       "      <th>Articles of Iron and Steel</th>\n",
       "      <th>Ores,Slag and ash,Minerals,fuels,mineral oil,Bituminous substance and mineral wax</th>\n",
       "      <th>Organic Chemicals</th>\n",
       "      <th>Plastics and Articles</th>\n",
       "      <th>Pulp of wood or other fibrous cellulose material paper and paper boards</th>\n",
       "      <th>Raw hides and skins</th>\n",
       "      <th>Vehicles other than Railway or tramway parts and Accessories there of</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Algeria</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>503</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Argentina</th>\n",
       "      <td>240</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>65</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Australia</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>616</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Austria</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>36</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Belgium</th>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>78</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Belgium</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>83</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Canada</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>137</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>China</th>\n",
       "      <td>0</td>\n",
       "      <td>614</td>\n",
       "      <td>1227</td>\n",
       "      <td>1893</td>\n",
       "      <td>379</td>\n",
       "      <td>269</td>\n",
       "      <td>21</td>\n",
       "      <td>294</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Egypt</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>46</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Finland</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>France</th>\n",
       "      <td>0</td>\n",
       "      <td>287</td>\n",
       "      <td>0</td>\n",
       "      <td>63</td>\n",
       "      <td>26</td>\n",
       "      <td>24</td>\n",
       "      <td>15</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Germany</th>\n",
       "      <td>0</td>\n",
       "      <td>138</td>\n",
       "      <td>16</td>\n",
       "      <td>254</td>\n",
       "      <td>145</td>\n",
       "      <td>138</td>\n",
       "      <td>24</td>\n",
       "      <td>765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hong Kong</th>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>54</td>\n",
       "      <td>25</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Indonesia</th>\n",
       "      <td>1137</td>\n",
       "      <td>69</td>\n",
       "      <td>1253</td>\n",
       "      <td>305</td>\n",
       "      <td>21</td>\n",
       "      <td>283</td>\n",
       "      <td>26</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Iran</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1104</td>\n",
       "      <td>113</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Iraq</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9730</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Italy</th>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>75</td>\n",
       "      <td>58</td>\n",
       "      <td>112</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Japan</th>\n",
       "      <td>0</td>\n",
       "      <td>219</td>\n",
       "      <td>0</td>\n",
       "      <td>134</td>\n",
       "      <td>81</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kenya</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>South Korea</th>\n",
       "      <td>0</td>\n",
       "      <td>292</td>\n",
       "      <td>217</td>\n",
       "      <td>66</td>\n",
       "      <td>199</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>1522</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Malaysia</th>\n",
       "      <td>87</td>\n",
       "      <td>11</td>\n",
       "      <td>2798</td>\n",
       "      <td>72</td>\n",
       "      <td>70</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mexico</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Netherlands</th>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>180</td>\n",
       "      <td>89</td>\n",
       "      <td>28</td>\n",
       "      <td>49</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Newzealand</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>59</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nigeria</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>515</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Countries</th>\n",
       "      <td>149</td>\n",
       "      <td>128</td>\n",
       "      <td>5432</td>\n",
       "      <td>86</td>\n",
       "      <td>206</td>\n",
       "      <td>150</td>\n",
       "      <td>254</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Philipines</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Poland</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Russia</th>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>153</td>\n",
       "      <td>0</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Saudi Arabia</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10516</td>\n",
       "      <td>65</td>\n",
       "      <td>274</td>\n",
       "      <td>0</td>\n",
       "      <td>91</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Singapore</th>\n",
       "      <td>138</td>\n",
       "      <td>177</td>\n",
       "      <td>218</td>\n",
       "      <td>181</td>\n",
       "      <td>256</td>\n",
       "      <td>76</td>\n",
       "      <td>0</td>\n",
       "      <td>249</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>South Africa</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>612</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spain</th>\n",
       "      <td>0</td>\n",
       "      <td>65</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>51</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sri Lanka</th>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sweden</th>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>80</td>\n",
       "      <td>0</td>\n",
       "      <td>287</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Switzerland</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>77</td>\n",
       "      <td>72</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Taiwan</th>\n",
       "      <td>0</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>315</td>\n",
       "      <td>255</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thailand</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>114</td>\n",
       "      <td>180</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Turkey</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1310</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>United Arab Emirates</th>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>5711</td>\n",
       "      <td>15</td>\n",
       "      <td>90</td>\n",
       "      <td>12</td>\n",
       "      <td>51</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>United Kingdom</th>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "      <td>15</td>\n",
       "      <td>57</td>\n",
       "      <td>36</td>\n",
       "      <td>164</td>\n",
       "      <td>21</td>\n",
       "      <td>234</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>United States</th>\n",
       "      <td>0</td>\n",
       "      <td>77</td>\n",
       "      <td>347</td>\n",
       "      <td>119</td>\n",
       "      <td>168</td>\n",
       "      <td>200</td>\n",
       "      <td>27</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      Animal or Vegetable fats and Oil products  \\\n",
       "Algeria                                                       0   \n",
       "Argentina                                                   240   \n",
       "Australia                                                     0   \n",
       "Austria                                                       0   \n",
       "Belgium                                                       0   \n",
       "Belgium                                                       0   \n",
       "Canada                                                        0   \n",
       "China                                                         0   \n",
       "Egypt                                                         0   \n",
       "Finland                                                       0   \n",
       "France                                                        0   \n",
       "Germany                                                       0   \n",
       "Hong Kong                                                     0   \n",
       "Indonesia                                                  1137   \n",
       "Iran                                                          0   \n",
       "Iraq                                                          0   \n",
       "Italy                                                         0   \n",
       "Japan                                                         0   \n",
       "Kenya                                                         0   \n",
       "South Korea                                                   0   \n",
       "Malaysia                                                     87   \n",
       "Mexico                                                        0   \n",
       "Netherlands                                                   0   \n",
       "Newzealand                                                    0   \n",
       "Nigeria                                                       0   \n",
       "Other Countries                                             149   \n",
       "Philipines                                                    0   \n",
       "Poland                                                        0   \n",
       "Russia                                                       22   \n",
       "Saudi Arabia                                                  0   \n",
       "Singapore                                                   138   \n",
       "South Africa                                                  0   \n",
       "Spain                                                         0   \n",
       "Sri Lanka                                                    23   \n",
       "Sweden                                                        0   \n",
       "Switzerland                                                   0   \n",
       "Taiwan                                                        0   \n",
       "Thailand                                                      0   \n",
       "Turkey                                                        0   \n",
       "United Arab Emirates                                          0   \n",
       "United Kingdom                                                0   \n",
       "United States                                                 0   \n",
       "\n",
       "                      Articles of Iron and Steel  \\\n",
       "Algeria                                        0   \n",
       "Argentina                                      0   \n",
       "Australia                                      0   \n",
       "Austria                                        0   \n",
       "Belgium                                       38   \n",
       "Belgium                                        0   \n",
       "Canada                                         0   \n",
       "China                                        614   \n",
       "Egypt                                          0   \n",
       "Finland                                        0   \n",
       "France                                       287   \n",
       "Germany                                      138   \n",
       "Hong Kong                                     17   \n",
       "Indonesia                                     69   \n",
       "Iran                                           0   \n",
       "Iraq                                           0   \n",
       "Italy                                        100   \n",
       "Japan                                        219   \n",
       "Kenya                                          0   \n",
       "South Korea                                  292   \n",
       "Malaysia                                      11   \n",
       "Mexico                                         0   \n",
       "Netherlands                                   21   \n",
       "Newzealand                                     0   \n",
       "Nigeria                                        0   \n",
       "Other Countries                              128   \n",
       "Philipines                                     0   \n",
       "Poland                                         0   \n",
       "Russia                                         0   \n",
       "Saudi Arabia                                   0   \n",
       "Singapore                                    177   \n",
       "South Africa                                   0   \n",
       "Spain                                         65   \n",
       "Sri Lanka                                      0   \n",
       "Sweden                                        16   \n",
       "Switzerland                                    0   \n",
       "Taiwan                                        50   \n",
       "Thailand                                       0   \n",
       "Turkey                                         0   \n",
       "United Arab Emirates                          20   \n",
       "United Kingdom                                27   \n",
       "United States                                 77   \n",
       "\n",
       "                      Ores,Slag and ash,Minerals,fuels,mineral oil,Bituminous substance and mineral wax  \\\n",
       "Algeria                                                             503                                   \n",
       "Argentina                                                             0                                   \n",
       "Australia                                                           616                                   \n",
       "Austria                                                               0                                   \n",
       "Belgium                                                               0                                   \n",
       "Belgium                                                               0                                   \n",
       "Canada                                                                0                                   \n",
       "China                                                              1227                                   \n",
       "Egypt                                                                 0                                   \n",
       "Finland                                                               0                                   \n",
       "France                                                                0                                   \n",
       "Germany                                                              16                                   \n",
       "Hong Kong                                                             0                                   \n",
       "Indonesia                                                          1253                                   \n",
       "Iran                                                               1104                                   \n",
       "Iraq                                                               9730                                   \n",
       "Italy                                                                 0                                   \n",
       "Japan                                                                 0                                   \n",
       "Kenya                                                                 0                                   \n",
       "South Korea                                                         217                                   \n",
       "Malaysia                                                           2798                                   \n",
       "Mexico                                                                0                                   \n",
       "Netherlands                                                           0                                   \n",
       "Newzealand                                                            0                                   \n",
       "Nigeria                                                             515                                   \n",
       "Other Countries                                                    5432                                   \n",
       "Philipines                                                           29                                   \n",
       "Poland                                                                0                                   \n",
       "Russia                                                                0                                   \n",
       "Saudi Arabia                                                      10516                                   \n",
       "Singapore                                                           218                                   \n",
       "South Africa                                                        612                                   \n",
       "Spain                                                                 0                                   \n",
       "Sri Lanka                                                             0                                   \n",
       "Sweden                                                                0                                   \n",
       "Switzerland                                                          77                                   \n",
       "Taiwan                                                                0                                   \n",
       "Thailand                                                              0                                   \n",
       "Turkey                                                             1310                                   \n",
       "United Arab Emirates                                               5711                                   \n",
       "United Kingdom                                                       15                                   \n",
       "United States                                                       347                                   \n",
       "\n",
       "                      Organic Chemicals  Plastics and Articles  \\\n",
       "Algeria                               0                      0   \n",
       "Argentina                             0                      0   \n",
       "Australia                             0                     23   \n",
       "Austria                               0                      0   \n",
       "Belgium                              78                      0   \n",
       "Belgium                               0                     83   \n",
       "Canada                                0                      0   \n",
       "China                              1893                    379   \n",
       "Egypt                                 0                      0   \n",
       "Finland                               0                      0   \n",
       "France                               63                     26   \n",
       "Germany                             254                    145   \n",
       "Hong Kong                            24                     54   \n",
       "Indonesia                           305                     21   \n",
       "Iran                                113                      0   \n",
       "Iraq                                  0                      0   \n",
       "Italy                                17                     75   \n",
       "Japan                               134                     81   \n",
       "Kenya                                 0                      0   \n",
       "South Korea                          66                    199   \n",
       "Malaysia                             72                     70   \n",
       "Mexico                                0                     21   \n",
       "Netherlands                         180                     89   \n",
       "Newzealand                            0                      0   \n",
       "Nigeria                               0                      0   \n",
       "Other Countries                      86                    206   \n",
       "Philipines                            0                      0   \n",
       "Poland                                0                      0   \n",
       "Russia                               24                      0   \n",
       "Saudi Arabia                         65                    274   \n",
       "Singapore                           181                    256   \n",
       "South Africa                          0                      0   \n",
       "Spain                                21                     19   \n",
       "Sri Lanka                             0                      0   \n",
       "Sweden                                0                      0   \n",
       "Switzerland                          72                     27   \n",
       "Taiwan                              315                    255   \n",
       "Thailand                            114                    180   \n",
       "Turkey                                0                      0   \n",
       "United Arab Emirates                 15                     90   \n",
       "United Kingdom                       57                     36   \n",
       "United States                       119                    168   \n",
       "\n",
       "                      Pulp of wood or other fibrous cellulose material paper and paper boards  \\\n",
       "Algeria                                                               0                         \n",
       "Argentina                                                             0                         \n",
       "Australia                                                             0                         \n",
       "Austria                                                              36                         \n",
       "Belgium                                                               0                         \n",
       "Belgium                                                               0                         \n",
       "Canada                                                              137                         \n",
       "China                                                               269                         \n",
       "Egypt                                                                 0                         \n",
       "Finland                                                             100                         \n",
       "France                                                               24                         \n",
       "Germany                                                             138                         \n",
       "Hong Kong                                                            25                         \n",
       "Indonesia                                                           283                         \n",
       "Iran                                                                  0                         \n",
       "Iraq                                                                  0                         \n",
       "Italy                                                                58                         \n",
       "Japan                                                                16                         \n",
       "Kenya                                                                 0                         \n",
       "South Korea                                                           0                         \n",
       "Malaysia                                                              0                         \n",
       "Mexico                                                                0                         \n",
       "Netherlands                                                          28                         \n",
       "Newzealand                                                            0                         \n",
       "Nigeria                                                               0                         \n",
       "Other Countries                                                     150                         \n",
       "Philipines                                                            0                         \n",
       "Poland                                                                0                         \n",
       "Russia                                                              153                         \n",
       "Saudi Arabia                                                          0                         \n",
       "Singapore                                                            76                         \n",
       "South Africa                                                          0                         \n",
       "Spain                                                                 0                         \n",
       "Sri Lanka                                                             0                         \n",
       "Sweden                                                               80                         \n",
       "Switzerland                                                           0                         \n",
       "Taiwan                                                                0                         \n",
       "Thailand                                                              0                         \n",
       "Turkey                                                                0                         \n",
       "United Arab Emirates                                                 12                         \n",
       "United Kingdom                                                      164                         \n",
       "United States                                                       200                         \n",
       "\n",
       "                      Raw hides and skins  \\\n",
       "Algeria                                 0   \n",
       "Argentina                              65   \n",
       "Australia                              34   \n",
       "Austria                                 0   \n",
       "Belgium                                 0   \n",
       "Belgium                                 0   \n",
       "Canada                                  0   \n",
       "China                                  21   \n",
       "Egypt                                  46   \n",
       "Finland                                 0   \n",
       "France                                 15   \n",
       "Germany                                24   \n",
       "Hong Kong                              27   \n",
       "Indonesia                              26   \n",
       "Iran                                   26   \n",
       "Iraq                                    0   \n",
       "Italy                                 112   \n",
       "Japan                                   0   \n",
       "Kenya                                  18   \n",
       "South Korea                            18   \n",
       "Malaysia                                0   \n",
       "Mexico                                  0   \n",
       "Netherlands                            49   \n",
       "Newzealand                             59   \n",
       "Nigeria                                 0   \n",
       "Other Countries                       254   \n",
       "Philipines                              0   \n",
       "Poland                                  0   \n",
       "Russia                                  0   \n",
       "Saudi Arabia                           91   \n",
       "Singapore                               0   \n",
       "South Africa                            0   \n",
       "Spain                                  51   \n",
       "Sri Lanka                               0   \n",
       "Sweden                                  0   \n",
       "Switzerland                            17   \n",
       "Taiwan                                  0   \n",
       "Thailand                                0   \n",
       "Turkey                                  0   \n",
       "United Arab Emirates                   51   \n",
       "United Kingdom                         21   \n",
       "United States                          27   \n",
       "\n",
       "                      Vehicles other than Railway or tramway parts and Accessories there of  \n",
       "Algeria                                                               0                      \n",
       "Argentina                                                             0                      \n",
       "Australia                                                             0                      \n",
       "Austria                                                               0                      \n",
       "Belgium                                                               0                      \n",
       "Belgium                                                               0                      \n",
       "Canada                                                                0                      \n",
       "China                                                               294                      \n",
       "Egypt                                                                 0                      \n",
       "Finland                                                               0                      \n",
       "France                                                               86                      \n",
       "Germany                                                             765                      \n",
       "Hong Kong                                                             0                      \n",
       "Indonesia                                                            30                      \n",
       "Iran                                                                  0                      \n",
       "Iraq                                                                  0                      \n",
       "Italy                                                                72                      \n",
       "Japan                                                               264                      \n",
       "Kenya                                                                 0                      \n",
       "South Korea                                                        1522                      \n",
       "Malaysia                                                              0                      \n",
       "Mexico                                                                0                      \n",
       "Netherlands                                                          52                      \n",
       "Newzealand                                                            0                      \n",
       "Nigeria                                                               0                      \n",
       "Other Countries                                                      61                      \n",
       "Philipines                                                            0                      \n",
       "Poland                                                               24                      \n",
       "Russia                                                               54                      \n",
       "Saudi Arabia                                                          0                      \n",
       "Singapore                                                           249                      \n",
       "South Africa                                                          0                      \n",
       "Spain                                                                16                      \n",
       "Sri Lanka                                                             0                      \n",
       "Sweden                                                              287                      \n",
       "Switzerland                                                           0                      \n",
       "Taiwan                                                               14                      \n",
       "Thailand                                                             95                      \n",
       "Turkey                                                                0                      \n",
       "United Arab Emirates                                                  0                      \n",
       "United Kingdom                                                      234                      \n",
       "United States                                                        85                      "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_json('./final_datasets/import_commodities_by_sea.json')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>Electrical Machinery,.Equipment,and parts there of sound recorders and reproduces TV image</th>\n",
       "      <th>Natural or Cultural pearl precious or semi precious stones metals and precious metal and articles there.</th>\n",
       "      <th>Organic Chemicals</th>\n",
       "      <th>Pharmaceutical products</th>\n",
       "      <th>Printed books,Newspapers and Journals</th>\n",
       "      <th>Raw hides,skins and leather</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Australia</th>\n",
       "      <td>0</td>\n",
       "      <td>2251</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Austria</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>71</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Belgium</th>\n",
       "      <td>15</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Canada</th>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>China</th>\n",
       "      <td>3201</td>\n",
       "      <td>0</td>\n",
       "      <td>402</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Denmark</th>\n",
       "      <td>44</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Egypt</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Finland</th>\n",
       "      <td>572</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>France</th>\n",
       "      <td>141</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Germany</th>\n",
       "      <td>288</td>\n",
       "      <td>33</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hong Kong</th>\n",
       "      <td>811</td>\n",
       "      <td>80</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Indonesia</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Israel</th>\n",
       "      <td>203</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Italy</th>\n",
       "      <td>47</td>\n",
       "      <td>0</td>\n",
       "      <td>64</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Japan</th>\n",
       "      <td>164</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>South Korea</th>\n",
       "      <td>160</td>\n",
       "      <td>91</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Malaysia</th>\n",
       "      <td>290</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mexico</th>\n",
       "      <td>121</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Netherlands</th>\n",
       "      <td>98</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Countries</th>\n",
       "      <td>226</td>\n",
       "      <td>9</td>\n",
       "      <td>64</td>\n",
       "      <td>44</td>\n",
       "      <td>34</td>\n",
       "      <td>76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Russia</th>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Saudi Arabia</th>\n",
       "      <td>0</td>\n",
       "      <td>98</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Singapore</th>\n",
       "      <td>769</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>700</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>South Africa</th>\n",
       "      <td>0</td>\n",
       "      <td>1105</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spain</th>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sweden</th>\n",
       "      <td>368</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Switzerland</th>\n",
       "      <td>25</td>\n",
       "      <td>4390</td>\n",
       "      <td>22</td>\n",
       "      <td>634</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Taiwan</th>\n",
       "      <td>80</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thailand</th>\n",
       "      <td>24</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Turkey</th>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>United Arab Emirates</th>\n",
       "      <td>35</td>\n",
       "      <td>1086</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>United Kingdom</th>\n",
       "      <td>148</td>\n",
       "      <td>190</td>\n",
       "      <td>32</td>\n",
       "      <td>28</td>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>United States</th>\n",
       "      <td>771</td>\n",
       "      <td>216</td>\n",
       "      <td>18</td>\n",
       "      <td>37</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      Electrical Machinery,.Equipment,and parts there of sound recorders and reproduces TV image  \\\n",
       "Australia                                                             0                                            \n",
       "Austria                                                               0                                            \n",
       "Belgium                                                              15                                            \n",
       "Canada                                                               23                                            \n",
       "China                                                              3201                                            \n",
       "Denmark                                                              44                                            \n",
       "Egypt                                                                 0                                            \n",
       "Finland                                                             572                                            \n",
       "France                                                              141                                            \n",
       "Germany                                                             288                                            \n",
       "Hong Kong                                                           811                                            \n",
       "Indonesia                                                             0                                            \n",
       "Israel                                                              203                                            \n",
       "Italy                                                                47                                            \n",
       "Japan                                                               164                                            \n",
       "South Korea                                                         160                                            \n",
       "Malaysia                                                            290                                            \n",
       "Mexico                                                              121                                            \n",
       "Netherlands                                                          98                                            \n",
       "Other Countries                                                     226                                            \n",
       "Russia                                                               34                                            \n",
       "Saudi Arabia                                                          0                                            \n",
       "Singapore                                                           769                                            \n",
       "South Africa                                                          0                                            \n",
       "Spain                                                                10                                            \n",
       "Sweden                                                              368                                            \n",
       "Switzerland                                                          25                                            \n",
       "Taiwan                                                               80                                            \n",
       "Thailand                                                             24                                            \n",
       "Turkey                                                                0                                            \n",
       "United Arab Emirates                                                 35                                            \n",
       "United Kingdom                                                      148                                            \n",
       "United States                                                       771                                            \n",
       "\n",
       "                      Natural or Cultural pearl precious or semi precious stones metals and precious metal and articles there.  \\\n",
       "Australia                                                          2251                                                          \n",
       "Austria                                                               0                                                          \n",
       "Belgium                                                              35                                                          \n",
       "Canada                                                                0                                                          \n",
       "China                                                                 0                                                          \n",
       "Denmark                                                               0                                                          \n",
       "Egypt                                                                 0                                                          \n",
       "Finland                                                               0                                                          \n",
       "France                                                                0                                                          \n",
       "Germany                                                              33                                                          \n",
       "Hong Kong                                                            80                                                          \n",
       "Indonesia                                                             0                                                          \n",
       "Israel                                                                0                                                          \n",
       "Italy                                                                 0                                                          \n",
       "Japan                                                                 0                                                          \n",
       "South Korea                                                          91                                                          \n",
       "Malaysia                                                              0                                                          \n",
       "Mexico                                                                0                                                          \n",
       "Netherlands                                                           0                                                          \n",
       "Other Countries                                                       9                                                          \n",
       "Russia                                                                0                                                          \n",
       "Saudi Arabia                                                         98                                                          \n",
       "Singapore                                                            13                                                          \n",
       "South Africa                                                       1105                                                          \n",
       "Spain                                                                 0                                                          \n",
       "Sweden                                                                0                                                          \n",
       "Switzerland                                                        4390                                                          \n",
       "Taiwan                                                                0                                                          \n",
       "Thailand                                                             17                                                          \n",
       "Turkey                                                               40                                                          \n",
       "United Arab Emirates                                               1086                                                          \n",
       "United Kingdom                                                      190                                                          \n",
       "United States                                                       216                                                          \n",
       "\n",
       "                      Organic Chemicals  Pharmaceutical products  \\\n",
       "Australia                             0                        0   \n",
       "Austria                              71                        0   \n",
       "Belgium                               0                       45   \n",
       "Canada                                0                        0   \n",
       "China                               402                       10   \n",
       "Denmark                               0                        0   \n",
       "Egypt                                16                        0   \n",
       "Finland                               0                        0   \n",
       "France                                0                        0   \n",
       "Germany                              20                        0   \n",
       "Hong Kong                            25                        0   \n",
       "Indonesia                             0                        0   \n",
       "Israel                                0                        0   \n",
       "Italy                                64                        0   \n",
       "Japan                                31                        0   \n",
       "South Korea                           0                        0   \n",
       "Malaysia                              0                        0   \n",
       "Mexico                                0                        0   \n",
       "Netherlands                           0                        0   \n",
       "Other Countries                      64                       44   \n",
       "Russia                                0                        0   \n",
       "Saudi Arabia                          0                        0   \n",
       "Singapore                             0                        0   \n",
       "South Africa                          0                        0   \n",
       "Spain                                17                        0   \n",
       "Sweden                                0                        0   \n",
       "Switzerland                          22                      634   \n",
       "Taiwan                               23                        0   \n",
       "Thailand                              0                        0   \n",
       "Turkey                                0                        0   \n",
       "United Arab Emirates                  0                        0   \n",
       "United Kingdom                       32                       28   \n",
       "United States                        18                       37   \n",
       "\n",
       "                      Printed books,Newspapers and Journals  \\\n",
       "Australia                                                 0   \n",
       "Austria                                                   0   \n",
       "Belgium                                                   0   \n",
       "Canada                                                    0   \n",
       "China                                                     0   \n",
       "Denmark                                                   0   \n",
       "Egypt                                                     0   \n",
       "Finland                                                   0   \n",
       "France                                                    0   \n",
       "Germany                                                   0   \n",
       "Hong Kong                                                 0   \n",
       "Indonesia                                                 0   \n",
       "Israel                                                    0   \n",
       "Italy                                                     0   \n",
       "Japan                                                     0   \n",
       "South Korea                                               0   \n",
       "Malaysia                                                  0   \n",
       "Mexico                                                    0   \n",
       "Netherlands                                               0   \n",
       "Other Countries                                          34   \n",
       "Russia                                                    0   \n",
       "Saudi Arabia                                              0   \n",
       "Singapore                                               700   \n",
       "South Africa                                              0   \n",
       "Spain                                                     0   \n",
       "Sweden                                                    0   \n",
       "Switzerland                                               0   \n",
       "Taiwan                                                    0   \n",
       "Thailand                                                  0   \n",
       "Turkey                                                    0   \n",
       "United Arab Emirates                                     11   \n",
       "United Kingdom                                           13   \n",
       "United States                                            27   \n",
       "\n",
       "                      Raw hides,skins and leather  \n",
       "Australia                                       0  \n",
       "Austria                                        10  \n",
       "Belgium                                         0  \n",
       "Canada                                          0  \n",
       "China                                           0  \n",
       "Denmark                                         0  \n",
       "Egypt                                           0  \n",
       "Finland                                         0  \n",
       "France                                          0  \n",
       "Germany                                        20  \n",
       "Hong Kong                                       0  \n",
       "Indonesia                                      19  \n",
       "Israel                                          0  \n",
       "Italy                                         139  \n",
       "Japan                                           0  \n",
       "South Korea                                     0  \n",
       "Malaysia                                        0  \n",
       "Mexico                                          0  \n",
       "Netherlands                                     9  \n",
       "Other Countries                                76  \n",
       "Russia                                          0  \n",
       "Saudi Arabia                                    0  \n",
       "Singapore                                       0  \n",
       "South Africa                                    0  \n",
       "Spain                                           0  \n",
       "Sweden                                          0  \n",
       "Switzerland                                     0  \n",
       "Taiwan                                          0  \n",
       "Thailand                                        0  \n",
       "Turkey                                          0  \n",
       "United Arab Emirates                            0  \n",
       "United Kingdom                                 14  \n",
       "United States                                   0  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_json('./final_datasets/import_commodities_by_air.json')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>Item</th>\n",
       "      <th>By Sea Chennai (Value Rs. in Crores)</th>\n",
       "      <th>By Sea Cuddalore (Value Rs. in Crores)</th>\n",
       "      <th>By Sea Thoothukudi  (Value Rs. in Crores)</th>\n",
       "      <th>By Sea Nagapattinam (Value Rs. in Crores)</th>\n",
       "      <th>By Sea Py- 03 Port (Value Rs. in Crores)</th>\n",
       "      <th>By Sea Thirukadiyur (Value Rs. in Crores)</th>\n",
       "      <th>By Sea Ennore Port (Value Rs. in Crores)</th>\n",
       "      <th>By Sea Ennore Minor (Value Rs. in Crores)</th>\n",
       "      <th>By Sea Kudankulam (Value Rs. in Crores)</th>\n",
       "      <th>Total By Sea (Value Rs. in Crores)</th>\n",
       "      <th>By Air Chennai (Value Rs. in Crores)</th>\n",
       "      <th>By Air Coimbatore (Value Rs. in Crores)</th>\n",
       "      <th>By Air  Tiruchirappalli (Value Rs. in Crores)</th>\n",
       "      <th>Total By Air (Value Rs. in Crores)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Total Exports</td>\n",
       "      <td>42570</td>\n",
       "      <td>NA</td>\n",
       "      <td>39995</td>\n",
       "      <td>342</td>\n",
       "      <td>516</td>\n",
       "      <td>NA</td>\n",
       "      <td>700</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "      <td>84123</td>\n",
       "      <td>7366</td>\n",
       "      <td>272</td>\n",
       "      <td>1</td>\n",
       "      <td>7639</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Item  By Sea Chennai (Value Rs. in Crores)  \\\n",
       "1  Total Exports                                 42570   \n",
       "\n",
       "  By Sea Cuddalore (Value Rs. in Crores)   \\\n",
       "1                                      NA   \n",
       "\n",
       "   By Sea Thoothukudi  (Value Rs. in Crores)   \\\n",
       "1                                       39995   \n",
       "\n",
       "   By Sea Nagapattinam (Value Rs. in Crores)   \\\n",
       "1                                         342   \n",
       "\n",
       "   By Sea Py- 03 Port (Value Rs. in Crores)   \\\n",
       "1                                        516   \n",
       "\n",
       "  By Sea Thirukadiyur (Value Rs. in Crores)   \\\n",
       "1                                         NA   \n",
       "\n",
       "   By Sea Ennore Port (Value Rs. in Crores)   \\\n",
       "1                                        700   \n",
       "\n",
       "  By Sea Ennore Minor (Value Rs. in Crores)   \\\n",
       "1                                         NA   \n",
       "\n",
       "  By Sea Kudankulam (Value Rs. in Crores)   \\\n",
       "1                                       NA   \n",
       "\n",
       "   Total By Sea (Value Rs. in Crores)  By Air Chennai (Value Rs. in Crores)   \\\n",
       "1                               84123                                   7366   \n",
       "\n",
       "   By Air Coimbatore (Value Rs. in Crores)   \\\n",
       "1                                       272   \n",
       "\n",
       "   By Air  Tiruchirappalli (Value Rs. in Crores)  \\\n",
       "1                                              1   \n",
       "\n",
       "   Total By Air (Value Rs. in Crores)  \n",
       "1                                7639  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_json('./datasets/import_and_export_by_cities.json')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>Commodity Group</th>\n",
       "      <th>Value of Imports By Air (Rs. in Crores)</th>\n",
       "      <th>Value of Imports By Sea (Rs. in Crores)</th>\n",
       "      <th>Total Value of Imports (Rs. in Crores)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Chennai Port : Cereals</td>\n",
       "      <td>0</td>\n",
       "      <td>87</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Chennai Port : Dairy produce eggs,honey and ed...</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Chennai Port : Edible fruits and nuts,peel or ...</td>\n",
       "      <td>0</td>\n",
       "      <td>101</td>\n",
       "      <td>101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Chennai Port : Coffee,tea,mate and spices</td>\n",
       "      <td>1</td>\n",
       "      <td>218</td>\n",
       "      <td>219</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Chennai Port : Sugar and sugar confectionery</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Chennai Port : Oil seeds,oleaginous fruits,gra...</td>\n",
       "      <td>9</td>\n",
       "      <td>146</td>\n",
       "      <td>155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Chennai Port : Edible vegetables and certain r...</td>\n",
       "      <td>0</td>\n",
       "      <td>1012</td>\n",
       "      <td>1012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Chennai Port : Miscellaneous edible preparations</td>\n",
       "      <td>2</td>\n",
       "      <td>20</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Chennai Port : Salt,Sulpher,earths and stone p...</td>\n",
       "      <td>1</td>\n",
       "      <td>378</td>\n",
       "      <td>379</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Chennai Port : Ores,slag and ash,mineral fuels...</td>\n",
       "      <td>0</td>\n",
       "      <td>42246</td>\n",
       "      <td>42246</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Chennai Port : In- organic chemicals,organic o...</td>\n",
       "      <td>137</td>\n",
       "      <td>1021</td>\n",
       "      <td>1158</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Chennai Port : Organic chemicals</td>\n",
       "      <td>805</td>\n",
       "      <td>4268</td>\n",
       "      <td>5073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Chennai Port : Pharmaceutical products</td>\n",
       "      <td>798</td>\n",
       "      <td>85</td>\n",
       "      <td>883</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Chennai Port : Fertilisers</td>\n",
       "      <td>0</td>\n",
       "      <td>750</td>\n",
       "      <td>750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Chennai Port : Tanning or dyeing extract dyes,...</td>\n",
       "      <td>29</td>\n",
       "      <td>510</td>\n",
       "      <td>539</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Chennai Port : Essential oils and resinoids,pe...</td>\n",
       "      <td>44</td>\n",
       "      <td>189</td>\n",
       "      <td>233</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Chennai Port : Soap. Organic surface active ag...</td>\n",
       "      <td>14</td>\n",
       "      <td>230</td>\n",
       "      <td>244</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Chennai Port : Photographic or Cinematographic...</td>\n",
       "      <td>16</td>\n",
       "      <td>238</td>\n",
       "      <td>254</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Chennai Port : Miscellaneous chemical products</td>\n",
       "      <td>112</td>\n",
       "      <td>1159</td>\n",
       "      <td>1271</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Chennai Port : Plastic and articles thereof</td>\n",
       "      <td>109</td>\n",
       "      <td>2777</td>\n",
       "      <td>2886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Chennai Port : Rubber and articles thereof</td>\n",
       "      <td>119</td>\n",
       "      <td>1573</td>\n",
       "      <td>1692</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Chennai Port : Pulp of wood or other fibrous c...</td>\n",
       "      <td>50</td>\n",
       "      <td>2037</td>\n",
       "      <td>2087</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Chennai Port : Wood and articles of wood/wood ...</td>\n",
       "      <td>1</td>\n",
       "      <td>486</td>\n",
       "      <td>487</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Chennai Port : Silk</td>\n",
       "      <td>1</td>\n",
       "      <td>1010</td>\n",
       "      <td>1011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Chennai Port : Wool,fine or coarse animal hair...</td>\n",
       "      <td>24</td>\n",
       "      <td>89</td>\n",
       "      <td>113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Chennai Port : Man-made filaments</td>\n",
       "      <td>14</td>\n",
       "      <td>206</td>\n",
       "      <td>220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Chennai Port : Man-made Stapple fibres</td>\n",
       "      <td>15</td>\n",
       "      <td>151</td>\n",
       "      <td>166</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Chennai Port : Other madeup textile articles,s...</td>\n",
       "      <td>1</td>\n",
       "      <td>29</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Chennai Port : Raw hides and skins and leather</td>\n",
       "      <td>287</td>\n",
       "      <td>1052</td>\n",
       "      <td>1339</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Chennai Port : Articles of leather,saddlery,tr...</td>\n",
       "      <td>7</td>\n",
       "      <td>74</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Chennai Port : Animal or vegetable fats and oi...</td>\n",
       "      <td>0</td>\n",
       "      <td>1796</td>\n",
       "      <td>1796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Chennai Port : Cotton</td>\n",
       "      <td>49</td>\n",
       "      <td>616</td>\n",
       "      <td>665</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Chennai Port : Printed books newspapers journa...</td>\n",
       "      <td>785</td>\n",
       "      <td>42</td>\n",
       "      <td>827</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Chennai Port : Ceramic products</td>\n",
       "      <td>37</td>\n",
       "      <td>276</td>\n",
       "      <td>313</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Chennai Port : Glass and glassware</td>\n",
       "      <td>13</td>\n",
       "      <td>360</td>\n",
       "      <td>373</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Chennai Port : Natural or cultured pearl preci...</td>\n",
       "      <td>9654</td>\n",
       "      <td>850</td>\n",
       "      <td>10504</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Chennai Port : Iron and steel</td>\n",
       "      <td>18</td>\n",
       "      <td>5034</td>\n",
       "      <td>5052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Chennai Port : Articles of iron and steel</td>\n",
       "      <td>119</td>\n",
       "      <td>2366</td>\n",
       "      <td>2485</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Chennai Port : Copper and articles thereof</td>\n",
       "      <td>11</td>\n",
       "      <td>372</td>\n",
       "      <td>383</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Chennai Port : Nickel and articles thereof</td>\n",
       "      <td>16</td>\n",
       "      <td>137</td>\n",
       "      <td>153</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Chennai Port : Aluminum and articles thereof</td>\n",
       "      <td>8</td>\n",
       "      <td>976</td>\n",
       "      <td>984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Chennai Port : Lead and articles thereof</td>\n",
       "      <td>0</td>\n",
       "      <td>1009</td>\n",
       "      <td>1009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Chennai Port : Zinc and articles thereof</td>\n",
       "      <td>0</td>\n",
       "      <td>57</td>\n",
       "      <td>57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Chennai Port : Tin and articles thereof</td>\n",
       "      <td>1</td>\n",
       "      <td>77</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Chennai Port : Miscellaneous articles of base ...</td>\n",
       "      <td>60</td>\n",
       "      <td>249</td>\n",
       "      <td>309</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Chennai Port : Electrical machinery,equipments...</td>\n",
       "      <td>8668</td>\n",
       "      <td>9868</td>\n",
       "      <td>18536</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Chennai Port : Railway locomotives rolling sto...</td>\n",
       "      <td>1</td>\n",
       "      <td>110</td>\n",
       "      <td>111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Chennai Port : Vehicles other than Rly. or tra...</td>\n",
       "      <td>167</td>\n",
       "      <td>4204</td>\n",
       "      <td>4371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Chennai Port : Aircrafts,Spacecrafts and parts...</td>\n",
       "      <td>456</td>\n",
       "      <td>6</td>\n",
       "      <td>462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Chennai Port : Ships,boats floating structures</td>\n",
       "      <td>3</td>\n",
       "      <td>1226</td>\n",
       "      <td>1229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Chennai Port : Clocks and watches and parts th...</td>\n",
       "      <td>97</td>\n",
       "      <td>13</td>\n",
       "      <td>110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Chennai Port : Others</td>\n",
       "      <td>10507</td>\n",
       "      <td>26718</td>\n",
       "      <td>37225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total</th>\n",
       "      <td>Chennai Port Total</td>\n",
       "      <td>33267</td>\n",
       "      <td>118513</td>\n",
       "      <td>151780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Coimbatore</td>\n",
       "      <td>2465</td>\n",
       "      <td>NA</td>\n",
       "      <td>2465</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Thoothukkudi</td>\n",
       "      <td>NA</td>\n",
       "      <td>34002</td>\n",
       "      <td>34002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Thirukadayur</td>\n",
       "      <td>NA</td>\n",
       "      <td>110</td>\n",
       "      <td>110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Ennore Minor Port</td>\n",
       "      <td>NA</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>PY 03 port</td>\n",
       "      <td>NA</td>\n",
       "      <td>1740</td>\n",
       "      <td>1740</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Ennore Port (Government of India undertaking)</td>\n",
       "      <td>NA</td>\n",
       "      <td>1740</td>\n",
       "      <td>1740</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         Commodity Group  \\\n",
       "1                                 Chennai Port : Cereals   \n",
       "2      Chennai Port : Dairy produce eggs,honey and ed...   \n",
       "3      Chennai Port : Edible fruits and nuts,peel or ...   \n",
       "4              Chennai Port : Coffee,tea,mate and spices   \n",
       "5           Chennai Port : Sugar and sugar confectionery   \n",
       "6      Chennai Port : Oil seeds,oleaginous fruits,gra...   \n",
       "7      Chennai Port : Edible vegetables and certain r...   \n",
       "8       Chennai Port : Miscellaneous edible preparations   \n",
       "9      Chennai Port : Salt,Sulpher,earths and stone p...   \n",
       "10     Chennai Port : Ores,slag and ash,mineral fuels...   \n",
       "11     Chennai Port : In- organic chemicals,organic o...   \n",
       "12                      Chennai Port : Organic chemicals   \n",
       "13                Chennai Port : Pharmaceutical products   \n",
       "14                            Chennai Port : Fertilisers   \n",
       "15     Chennai Port : Tanning or dyeing extract dyes,...   \n",
       "16     Chennai Port : Essential oils and resinoids,pe...   \n",
       "17     Chennai Port : Soap. Organic surface active ag...   \n",
       "18     Chennai Port : Photographic or Cinematographic...   \n",
       "19        Chennai Port : Miscellaneous chemical products   \n",
       "20           Chennai Port : Plastic and articles thereof   \n",
       "21            Chennai Port : Rubber and articles thereof   \n",
       "22     Chennai Port : Pulp of wood or other fibrous c...   \n",
       "23     Chennai Port : Wood and articles of wood/wood ...   \n",
       "24                                   Chennai Port : Silk   \n",
       "25     Chennai Port : Wool,fine or coarse animal hair...   \n",
       "26                     Chennai Port : Man-made filaments   \n",
       "27                Chennai Port : Man-made Stapple fibres   \n",
       "28     Chennai Port : Other madeup textile articles,s...   \n",
       "29        Chennai Port : Raw hides and skins and leather   \n",
       "30     Chennai Port : Articles of leather,saddlery,tr...   \n",
       "31     Chennai Port : Animal or vegetable fats and oi...   \n",
       "32                                 Chennai Port : Cotton   \n",
       "33     Chennai Port : Printed books newspapers journa...   \n",
       "34                       Chennai Port : Ceramic products   \n",
       "35                    Chennai Port : Glass and glassware   \n",
       "36     Chennai Port : Natural or cultured pearl preci...   \n",
       "37                         Chennai Port : Iron and steel   \n",
       "38             Chennai Port : Articles of iron and steel   \n",
       "39            Chennai Port : Copper and articles thereof   \n",
       "40            Chennai Port : Nickel and articles thereof   \n",
       "41          Chennai Port : Aluminum and articles thereof   \n",
       "42              Chennai Port : Lead and articles thereof   \n",
       "43              Chennai Port : Zinc and articles thereof   \n",
       "44               Chennai Port : Tin and articles thereof   \n",
       "45     Chennai Port : Miscellaneous articles of base ...   \n",
       "46     Chennai Port : Electrical machinery,equipments...   \n",
       "47     Chennai Port : Railway locomotives rolling sto...   \n",
       "48     Chennai Port : Vehicles other than Rly. or tra...   \n",
       "49     Chennai Port : Aircrafts,Spacecrafts and parts...   \n",
       "50        Chennai Port : Ships,boats floating structures   \n",
       "51     Chennai Port : Clocks and watches and parts th...   \n",
       "52                                 Chennai Port : Others   \n",
       "Total                                 Chennai Port Total   \n",
       "54                                            Coimbatore   \n",
       "55                                          Thoothukkudi   \n",
       "56                                          Thirukadayur   \n",
       "57                                     Ennore Minor Port   \n",
       "58                                            PY 03 port   \n",
       "59         Ennore Port (Government of India undertaking)   \n",
       "\n",
       "      Value of Imports By Air (Rs. in Crores)  \\\n",
       "1                                           0   \n",
       "2                                           0   \n",
       "3                                           0   \n",
       "4                                           1   \n",
       "5                                           1   \n",
       "6                                           9   \n",
       "7                                           0   \n",
       "8                                           2   \n",
       "9                                           1   \n",
       "10                                          0   \n",
       "11                                        137   \n",
       "12                                        805   \n",
       "13                                        798   \n",
       "14                                          0   \n",
       "15                                         29   \n",
       "16                                         44   \n",
       "17                                         14   \n",
       "18                                         16   \n",
       "19                                        112   \n",
       "20                                        109   \n",
       "21                                        119   \n",
       "22                                         50   \n",
       "23                                          1   \n",
       "24                                          1   \n",
       "25                                         24   \n",
       "26                                         14   \n",
       "27                                         15   \n",
       "28                                          1   \n",
       "29                                        287   \n",
       "30                                          7   \n",
       "31                                          0   \n",
       "32                                         49   \n",
       "33                                        785   \n",
       "34                                         37   \n",
       "35                                         13   \n",
       "36                                       9654   \n",
       "37                                         18   \n",
       "38                                        119   \n",
       "39                                         11   \n",
       "40                                         16   \n",
       "41                                          8   \n",
       "42                                          0   \n",
       "43                                          0   \n",
       "44                                          1   \n",
       "45                                         60   \n",
       "46                                       8668   \n",
       "47                                          1   \n",
       "48                                        167   \n",
       "49                                        456   \n",
       "50                                          3   \n",
       "51                                         97   \n",
       "52                                      10507   \n",
       "Total                                   33267   \n",
       "54                                       2465   \n",
       "55                                         NA   \n",
       "56                                         NA   \n",
       "57                                         NA   \n",
       "58                                         NA   \n",
       "59                                         NA   \n",
       "\n",
       "      Value of Imports By Sea (Rs. in Crores)  \\\n",
       "1                                          87   \n",
       "2                                           3   \n",
       "3                                         101   \n",
       "4                                         218   \n",
       "5                                           6   \n",
       "6                                         146   \n",
       "7                                        1012   \n",
       "8                                          20   \n",
       "9                                         378   \n",
       "10                                      42246   \n",
       "11                                       1021   \n",
       "12                                       4268   \n",
       "13                                         85   \n",
       "14                                        750   \n",
       "15                                        510   \n",
       "16                                        189   \n",
       "17                                        230   \n",
       "18                                        238   \n",
       "19                                       1159   \n",
       "20                                       2777   \n",
       "21                                       1573   \n",
       "22                                       2037   \n",
       "23                                        486   \n",
       "24                                       1010   \n",
       "25                                         89   \n",
       "26                                        206   \n",
       "27                                        151   \n",
       "28                                         29   \n",
       "29                                       1052   \n",
       "30                                         74   \n",
       "31                                       1796   \n",
       "32                                        616   \n",
       "33                                         42   \n",
       "34                                        276   \n",
       "35                                        360   \n",
       "36                                        850   \n",
       "37                                       5034   \n",
       "38                                       2366   \n",
       "39                                        372   \n",
       "40                                        137   \n",
       "41                                        976   \n",
       "42                                       1009   \n",
       "43                                         57   \n",
       "44                                         77   \n",
       "45                                        249   \n",
       "46                                       9868   \n",
       "47                                        110   \n",
       "48                                       4204   \n",
       "49                                          6   \n",
       "50                                       1226   \n",
       "51                                         13   \n",
       "52                                      26718   \n",
       "Total                                  118513   \n",
       "54                                         NA   \n",
       "55                                      34002   \n",
       "56                                        110   \n",
       "57                                         64   \n",
       "58                                       1740   \n",
       "59                                       1740   \n",
       "\n",
       "       Total Value of Imports (Rs. in Crores)   \n",
       "1                                           87  \n",
       "2                                            3  \n",
       "3                                          101  \n",
       "4                                          219  \n",
       "5                                            7  \n",
       "6                                          155  \n",
       "7                                         1012  \n",
       "8                                           22  \n",
       "9                                          379  \n",
       "10                                       42246  \n",
       "11                                        1158  \n",
       "12                                        5073  \n",
       "13                                         883  \n",
       "14                                         750  \n",
       "15                                         539  \n",
       "16                                         233  \n",
       "17                                         244  \n",
       "18                                         254  \n",
       "19                                        1271  \n",
       "20                                        2886  \n",
       "21                                        1692  \n",
       "22                                        2087  \n",
       "23                                         487  \n",
       "24                                        1011  \n",
       "25                                         113  \n",
       "26                                         220  \n",
       "27                                         166  \n",
       "28                                          30  \n",
       "29                                        1339  \n",
       "30                                          81  \n",
       "31                                        1796  \n",
       "32                                         665  \n",
       "33                                         827  \n",
       "34                                         313  \n",
       "35                                         373  \n",
       "36                                       10504  \n",
       "37                                        5052  \n",
       "38                                        2485  \n",
       "39                                         383  \n",
       "40                                         153  \n",
       "41                                         984  \n",
       "42                                        1009  \n",
       "43                                          57  \n",
       "44                                          78  \n",
       "45                                         309  \n",
       "46                                       18536  \n",
       "47                                         111  \n",
       "48                                        4371  \n",
       "49                                         462  \n",
       "50                                        1229  \n",
       "51                                         110  \n",
       "52                                       37225  \n",
       "Total                                   151780  \n",
       "54                                        2465  \n",
       "55                                       34002  \n",
       "56                                         110  \n",
       "57                                          64  \n",
       "58                                        1740  \n",
       "59                                        1740  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_json('./datasets/imports_of_commodites_of_cities.json')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>Description</th>\n",
       "      <th>Value of Foreign Trade Tamil Nadu (Rs.in Crores)</th>\n",
       "      <th>Value of Foreign Trade All India* (Rs.in Crores)</th>\n",
       "      <th>Percentage share of Foreign Trade through Tamil Nadu Ports to All India</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Exports By Sea</td>\n",
       "      <td>84123</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Exports By Air</td>\n",
       "      <td>7639</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Total Exports</td>\n",
       "      <td>91762</td>\n",
       "      <td>655864</td>\n",
       "      <td>13.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Imports By Sea</td>\n",
       "      <td>154429</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Imports By Air</td>\n",
       "      <td>35732</td>\n",
       "      <td>NA</td>\n",
       "      <td>NA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Total Imports</td>\n",
       "      <td>190161</td>\n",
       "      <td>1012312</td>\n",
       "      <td>18.78</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Description  Value of Foreign Trade Tamil Nadu (Rs.in Crores)  \\\n",
       "1  Exports By Sea                                             84123   \n",
       "2  Exports By Air                                              7639   \n",
       "3   Total Exports                                             91762   \n",
       "4  Imports By Sea                                            154429   \n",
       "5  Imports By Air                                             35732   \n",
       "6   Total Imports                                            190161   \n",
       "\n",
       "  Value of Foreign Trade All India* (Rs.in Crores)  \\\n",
       "1                                               NA   \n",
       "2                                               NA   \n",
       "3                                           655864   \n",
       "4                                               NA   \n",
       "5                                               NA   \n",
       "6                                          1012312   \n",
       "\n",
       "  Percentage share of Foreign Trade through Tamil Nadu Ports to All India  \n",
       "1                                                 NA                       \n",
       "2                                                 NA                       \n",
       "3                                              13.99                       \n",
       "4                                                 NA                       \n",
       "5                                                 NA                       \n",
       "6                                              18.78                       "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_json('./datasets/net_import_and_exports_for_tamil_nadu.json')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>Years</th>\n",
       "      <th>Exports Value (Rs. in Crores)</th>\n",
       "      <th>Imports Value  (Rs. in Crores)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1991-92</td>\n",
       "      <td>5389.88</td>\n",
       "      <td>5359.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1992-93</td>\n",
       "      <td>6884.23</td>\n",
       "      <td>7310.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1993-94</td>\n",
       "      <td>9085.80</td>\n",
       "      <td>8111.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1994-95</td>\n",
       "      <td>12460.09</td>\n",
       "      <td>12541.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1995-96</td>\n",
       "      <td>15832.83</td>\n",
       "      <td>17416.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1996-97</td>\n",
       "      <td>17596.27</td>\n",
       "      <td>14966.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1997-98</td>\n",
       "      <td>16529.64</td>\n",
       "      <td>36877.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1998-99</td>\n",
       "      <td>18771.28</td>\n",
       "      <td>23482.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1999-00</td>\n",
       "      <td>26983.75</td>\n",
       "      <td>25600.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2000-01</td>\n",
       "      <td>11736.96</td>\n",
       "      <td>18821.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2001-02</td>\n",
       "      <td>12631.24</td>\n",
       "      <td>18628.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2002-03</td>\n",
       "      <td>25039.00</td>\n",
       "      <td>35697.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2003-04</td>\n",
       "      <td>33068.00</td>\n",
       "      <td>43798.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2004-05</td>\n",
       "      <td>34782.00</td>\n",
       "      <td>78740.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2005-06</td>\n",
       "      <td>51298.00</td>\n",
       "      <td>112983.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2006-07</td>\n",
       "      <td>67759.00</td>\n",
       "      <td>159035.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Years  Exports Value (Rs. in Crores)  Imports Value  (Rs. in Crores)\n",
       "1   1991-92                        5389.88                         5359.21\n",
       "2   1992-93                        6884.23                         7310.65\n",
       "3   1993-94                        9085.80                         8111.80\n",
       "4   1994-95                       12460.09                        12541.53\n",
       "5   1995-96                       15832.83                        17416.72\n",
       "6   1996-97                       17596.27                        14966.54\n",
       "7   1997-98                       16529.64                        36877.89\n",
       "8   1998-99                       18771.28                        23482.90\n",
       "9   1999-00                       26983.75                        25600.16\n",
       "10  2000-01                       11736.96                        18821.37\n",
       "11  2001-02                       12631.24                        18628.05\n",
       "12  2002-03                       25039.00                        35697.00\n",
       "13  2003-04                       33068.00                        43798.00\n",
       "14  2004-05                       34782.00                        78740.00\n",
       "15  2005-06                       51298.00                       112983.00\n",
       "16  2006-07                       67759.00                       159035.00"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_json('./datasets/yearwise_import_export.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.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}