data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[['020711', '020711 生鮮/冷藏的整隻家禽'], ['020742', '020742 冷凍未切成肉塊(鴨)'], ['020745', '020745 冷凍肉塊及雜碎(鴨)'], ['020752', '020752 冷凍未切成肉塊(鵝)'], ['020755', '020755 冷凍肉塊及雜碎(鵝)'], ['040700', '040700 生鮮/冷藏/可保存的禽蛋'], ['040819', '040819 加工去殼的禽蛋'], ['060290', '060290 蘭花花苗'], ['020712', '020712 生鮮/冷藏的家禽肉塊及雜碎'], ['060313', '060313 蘭花切花'], ['160232', '160232 加工/可保藏的雞'], ['210410', '210410 雞的湯類及其調製品'], ['020714', '020714 冷凍肉塊及雜碎(雞)']]\n",
      "[2014 2015 2013 2011 2012 2010]\n"
     ]
    }
   ],
   "source": [
    "# Get pickle\n",
    "df = pd.read_pickle('./data/df_1015_sample.pickle')\n",
    "# print(len(df))\n",
    "\n",
    "# Get mapping\n",
    "with open(\"./data/ch_country_mapping.json\", \"r\") as file:\n",
    "    country_map = json.load(file)\n",
    "with open(\"./data/hs_cname_mapping.json\", \"r\") as file:\n",
    "    cname_map = json.load(file)\n",
    "\n",
    "\n",
    "# 產品項目\n",
    "product_item = []\n",
    "item_no_list = df[\"item_no\"].unique()\n",
    "for item_no in item_no_list:\n",
    "    product_item.append([item_no, cname_map[item_no]])\n",
    "output[\"filters\"][\"產品項目\"] = product_item\n",
    "print(product_item)\n",
    "\n",
    "# 年份\n",
    "print(df[\"date\"].unique())\n",
    "years = list(df[\"date\"].unique())\n",
    "years = [x for x in years if int(x) >= 2010 and int(x) <= 2015]\n",
    "years.sort()\n",
    "output[\"filters\"][\"年份\"] = years\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "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>country_a</th>\n",
       "      <th>country_b</th>\n",
       "      <th>date</th>\n",
       "      <th>ex_val</th>\n",
       "      <th>item_no</th>\n",
       "      <th>im_val</th>\n",
       "      <th>ex_qty</th>\n",
       "      <th>im_qty</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1040</th>\n",
       "      <td>World</td>\n",
       "      <td>China</td>\n",
       "      <td>2014</td>\n",
       "      <td>15552000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.905891e+06</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1041</th>\n",
       "      <td>World</td>\n",
       "      <td>China</td>\n",
       "      <td>2014</td>\n",
       "      <td>14394000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.449628e+06</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1042</th>\n",
       "      <td>World</td>\n",
       "      <td>China</td>\n",
       "      <td>2014</td>\n",
       "      <td>27710000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.429946e+06</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1043</th>\n",
       "      <td>World</td>\n",
       "      <td>China</td>\n",
       "      <td>2015</td>\n",
       "      <td>3125000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.031410e+06</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1044</th>\n",
       "      <td>World</td>\n",
       "      <td>China</td>\n",
       "      <td>2015</td>\n",
       "      <td>15405000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.608397e+06</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1045</th>\n",
       "      <td>World</td>\n",
       "      <td>China</td>\n",
       "      <td>2015</td>\n",
       "      <td>16524000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.856249e+06</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1046</th>\n",
       "      <td>World</td>\n",
       "      <td>China</td>\n",
       "      <td>2015</td>\n",
       "      <td>14858000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.363239e+06</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1047</th>\n",
       "      <td>World</td>\n",
       "      <td>China</td>\n",
       "      <td>2015</td>\n",
       "      <td>15302000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.474181e+06</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048</th>\n",
       "      <td>World</td>\n",
       "      <td>China</td>\n",
       "      <td>2015</td>\n",
       "      <td>15289000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.478318e+06</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1049</th>\n",
       "      <td>World</td>\n",
       "      <td>China</td>\n",
       "      <td>2015</td>\n",
       "      <td>15196000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.510154e+06</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1050</th>\n",
       "      <td>World</td>\n",
       "      <td>China</td>\n",
       "      <td>2015</td>\n",
       "      <td>15430000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.631458e+06</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1051</th>\n",
       "      <td>World</td>\n",
       "      <td>China</td>\n",
       "      <td>2015</td>\n",
       "      <td>15425000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.769970e+06</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1052</th>\n",
       "      <td>World</td>\n",
       "      <td>China</td>\n",
       "      <td>2015</td>\n",
       "      <td>15899000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.902850e+06</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1053</th>\n",
       "      <td>World</td>\n",
       "      <td>China</td>\n",
       "      <td>2015</td>\n",
       "      <td>15152000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.739731e+06</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1054</th>\n",
       "      <td>World</td>\n",
       "      <td>China</td>\n",
       "      <td>2015</td>\n",
       "      <td>29846000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.356980e+06</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1059</th>\n",
       "      <td>World</td>\n",
       "      <td>Poland</td>\n",
       "      <td>2014</td>\n",
       "      <td>11147000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>5.953853e+06</td>\n",
       "      <td>907.18474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1060</th>\n",
       "      <td>World</td>\n",
       "      <td>Poland</td>\n",
       "      <td>2014</td>\n",
       "      <td>9776000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>67000.0</td>\n",
       "      <td>5.456716e+06</td>\n",
       "      <td>51709.53018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1061</th>\n",
       "      <td>World</td>\n",
       "      <td>Poland</td>\n",
       "      <td>2014</td>\n",
       "      <td>8958000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>107000.0</td>\n",
       "      <td>4.911498e+06</td>\n",
       "      <td>60781.37758</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1062</th>\n",
       "      <td>World</td>\n",
       "      <td>Poland</td>\n",
       "      <td>2015</td>\n",
       "      <td>9357000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>5.789653e+06</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1063</th>\n",
       "      <td>World</td>\n",
       "      <td>Poland</td>\n",
       "      <td>2015</td>\n",
       "      <td>9499000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>5.846806e+06</td>\n",
       "      <td>907.18474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1064</th>\n",
       "      <td>World</td>\n",
       "      <td>Poland</td>\n",
       "      <td>2015</td>\n",
       "      <td>8810000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>14000.0</td>\n",
       "      <td>5.492096e+06</td>\n",
       "      <td>2721.55422</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1065</th>\n",
       "      <td>World</td>\n",
       "      <td>Poland</td>\n",
       "      <td>2015</td>\n",
       "      <td>7764000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>12000.0</td>\n",
       "      <td>4.930549e+06</td>\n",
       "      <td>1814.36948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1066</th>\n",
       "      <td>World</td>\n",
       "      <td>Poland</td>\n",
       "      <td>2015</td>\n",
       "      <td>8508000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>4.958672e+06</td>\n",
       "      <td>39008.94382</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1067</th>\n",
       "      <td>World</td>\n",
       "      <td>Poland</td>\n",
       "      <td>2015</td>\n",
       "      <td>9198000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>12000.0</td>\n",
       "      <td>5.064812e+06</td>\n",
       "      <td>3628.73896</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1068</th>\n",
       "      <td>World</td>\n",
       "      <td>Poland</td>\n",
       "      <td>2015</td>\n",
       "      <td>8857000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>69000.0</td>\n",
       "      <td>5.004938e+06</td>\n",
       "      <td>59874.19284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1069</th>\n",
       "      <td>World</td>\n",
       "      <td>Poland</td>\n",
       "      <td>2015</td>\n",
       "      <td>9287000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>5.083863e+06</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1070</th>\n",
       "      <td>World</td>\n",
       "      <td>Poland</td>\n",
       "      <td>2015</td>\n",
       "      <td>9389000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>5.481210e+06</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1071</th>\n",
       "      <td>World</td>\n",
       "      <td>Poland</td>\n",
       "      <td>2015</td>\n",
       "      <td>9942000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>11000.0</td>\n",
       "      <td>6.067252e+06</td>\n",
       "      <td>1814.36948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1072</th>\n",
       "      <td>World</td>\n",
       "      <td>Poland</td>\n",
       "      <td>2015</td>\n",
       "      <td>9675000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>13000.0</td>\n",
       "      <td>6.312191e+06</td>\n",
       "      <td>1814.36948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1073</th>\n",
       "      <td>World</td>\n",
       "      <td>Poland</td>\n",
       "      <td>2015</td>\n",
       "      <td>8050000.0</td>\n",
       "      <td>020711</td>\n",
       "      <td>18000.0</td>\n",
       "      <td>5.387770e+06</td>\n",
       "      <td>3628.73896</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165700</th>\n",
       "      <td>World</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>2010</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165701</th>\n",
       "      <td>World</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>2010</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165702</th>\n",
       "      <td>World</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>2010</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165703</th>\n",
       "      <td>World</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>2010</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165704</th>\n",
       "      <td>World</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>2011</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165705</th>\n",
       "      <td>World</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>2011</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165706</th>\n",
       "      <td>World</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>2011</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165707</th>\n",
       "      <td>World</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>2011</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165708</th>\n",
       "      <td>World</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>2011</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165709</th>\n",
       "      <td>World</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>2011</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165710</th>\n",
       "      <td>World</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>2011</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165711</th>\n",
       "      <td>World</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>2010</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165712</th>\n",
       "      <td>World</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>2010</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165713</th>\n",
       "      <td>World</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>2010</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>299.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165714</th>\n",
       "      <td>World</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>2010</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165715</th>\n",
       "      <td>World</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>2010</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165716</th>\n",
       "      <td>World</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>2010</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165717</th>\n",
       "      <td>World</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>2010</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165718</th>\n",
       "      <td>World</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>2010</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165719</th>\n",
       "      <td>World</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>2010</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1434.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165720</th>\n",
       "      <td>World</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>2010</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165721</th>\n",
       "      <td>World</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>2010</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1786.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165722</th>\n",
       "      <td>World</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>2010</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165723</th>\n",
       "      <td>World</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>2011</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165724</th>\n",
       "      <td>World</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>2011</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165725</th>\n",
       "      <td>World</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>2011</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>342.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165726</th>\n",
       "      <td>World</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>2011</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>166.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165727</th>\n",
       "      <td>World</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>2011</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>290.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165728</th>\n",
       "      <td>World</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>2011</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165729</th>\n",
       "      <td>World</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>2011</td>\n",
       "      <td>0.0</td>\n",
       "      <td>020712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>83018 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       country_a                         country_b  date      ex_val item_no  \\\n",
       "1040       World                             China  2014  15552000.0  020711   \n",
       "1041       World                             China  2014  14394000.0  020711   \n",
       "1042       World                             China  2014  27710000.0  020711   \n",
       "1043       World                             China  2015   3125000.0  020711   \n",
       "1044       World                             China  2015  15405000.0  020711   \n",
       "1045       World                             China  2015  16524000.0  020711   \n",
       "1046       World                             China  2015  14858000.0  020711   \n",
       "1047       World                             China  2015  15302000.0  020711   \n",
       "1048       World                             China  2015  15289000.0  020711   \n",
       "1049       World                             China  2015  15196000.0  020711   \n",
       "1050       World                             China  2015  15430000.0  020711   \n",
       "1051       World                             China  2015  15425000.0  020711   \n",
       "1052       World                             China  2015  15899000.0  020711   \n",
       "1053       World                             China  2015  15152000.0  020711   \n",
       "1054       World                             China  2015  29846000.0  020711   \n",
       "1059       World                            Poland  2014  11147000.0  020711   \n",
       "1060       World                            Poland  2014   9776000.0  020711   \n",
       "1061       World                            Poland  2014   8958000.0  020711   \n",
       "1062       World                            Poland  2015   9357000.0  020711   \n",
       "1063       World                            Poland  2015   9499000.0  020711   \n",
       "1064       World                            Poland  2015   8810000.0  020711   \n",
       "1065       World                            Poland  2015   7764000.0  020711   \n",
       "1066       World                            Poland  2015   8508000.0  020711   \n",
       "1067       World                            Poland  2015   9198000.0  020711   \n",
       "1068       World                            Poland  2015   8857000.0  020711   \n",
       "1069       World                            Poland  2015   9287000.0  020711   \n",
       "1070       World                            Poland  2015   9389000.0  020711   \n",
       "1071       World                            Poland  2015   9942000.0  020711   \n",
       "1072       World                            Poland  2015   9675000.0  020711   \n",
       "1073       World                            Poland  2015   8050000.0  020711   \n",
       "...          ...                               ...   ...         ...     ...   \n",
       "165700     World                            Malawi  2010         0.0  020712   \n",
       "165701     World                            Malawi  2010         0.0  020712   \n",
       "165702     World                            Malawi  2010         0.0  020712   \n",
       "165703     World                            Malawi  2010         0.0  020712   \n",
       "165704     World                            Malawi  2011         0.0  020712   \n",
       "165705     World                            Malawi  2011         0.0  020712   \n",
       "165706     World                            Malawi  2011         0.0  020712   \n",
       "165707     World                            Malawi  2011         0.0  020712   \n",
       "165708     World                            Malawi  2011         0.0  020712   \n",
       "165709     World                            Malawi  2011         0.0  020712   \n",
       "165710     World                            Malawi  2011         0.0  020712   \n",
       "165711     World  Saint Vincent and the Grenadines  2010         0.0  020712   \n",
       "165712     World  Saint Vincent and the Grenadines  2010         0.0  020712   \n",
       "165713     World  Saint Vincent and the Grenadines  2010         0.0  020712   \n",
       "165714     World  Saint Vincent and the Grenadines  2010         0.0  020712   \n",
       "165715     World  Saint Vincent and the Grenadines  2010         0.0  020712   \n",
       "165716     World  Saint Vincent and the Grenadines  2010         0.0  020712   \n",
       "165717     World  Saint Vincent and the Grenadines  2010         0.0  020712   \n",
       "165718     World  Saint Vincent and the Grenadines  2010         0.0  020712   \n",
       "165719     World  Saint Vincent and the Grenadines  2010         0.0  020712   \n",
       "165720     World  Saint Vincent and the Grenadines  2010         0.0  020712   \n",
       "165721     World  Saint Vincent and the Grenadines  2010         0.0  020712   \n",
       "165722     World  Saint Vincent and the Grenadines  2010         0.0  020712   \n",
       "165723     World  Saint Vincent and the Grenadines  2011         0.0  020712   \n",
       "165724     World  Saint Vincent and the Grenadines  2011         0.0  020712   \n",
       "165725     World  Saint Vincent and the Grenadines  2011         0.0  020712   \n",
       "165726     World  Saint Vincent and the Grenadines  2011         0.0  020712   \n",
       "165727     World  Saint Vincent and the Grenadines  2011         0.0  020712   \n",
       "165728     World  Saint Vincent and the Grenadines  2011         0.0  020712   \n",
       "165729     World  Saint Vincent and the Grenadines  2011         0.0  020712   \n",
       "\n",
       "          im_val        ex_qty       im_qty  \n",
       "1040         0.0  4.905891e+06      0.00000  \n",
       "1041         0.0  4.449628e+06      0.00000  \n",
       "1042         0.0  8.429946e+06      0.00000  \n",
       "1043         0.0  1.031410e+06      0.00000  \n",
       "1044         0.0  4.608397e+06      0.00000  \n",
       "1045         0.0  4.856249e+06      0.00000  \n",
       "1046         0.0  4.363239e+06      0.00000  \n",
       "1047         0.0  4.474181e+06      0.00000  \n",
       "1048         0.0  4.478318e+06      0.00000  \n",
       "1049         0.0  4.510154e+06      0.00000  \n",
       "1050         0.0  4.631458e+06      0.00000  \n",
       "1051         0.0  4.769970e+06      0.00000  \n",
       "1052         0.0  4.902850e+06      0.00000  \n",
       "1053         0.0  4.739731e+06      0.00000  \n",
       "1054         0.0  9.356980e+06      0.00000  \n",
       "1059      6000.0  5.953853e+06    907.18474  \n",
       "1060     67000.0  5.456716e+06  51709.53018  \n",
       "1061    107000.0  4.911498e+06  60781.37758  \n",
       "1062      8000.0  5.789653e+06      0.00000  \n",
       "1063      6000.0  5.846806e+06    907.18474  \n",
       "1064     14000.0  5.492096e+06   2721.55422  \n",
       "1065     12000.0  4.930549e+06   1814.36948  \n",
       "1066     50000.0  4.958672e+06  39008.94382  \n",
       "1067     12000.0  5.064812e+06   3628.73896  \n",
       "1068     69000.0  5.004938e+06  59874.19284  \n",
       "1069     10000.0  5.083863e+06      0.00000  \n",
       "1070      8000.0  5.481210e+06      0.00000  \n",
       "1071     11000.0  6.067252e+06   1814.36948  \n",
       "1072     13000.0  6.312191e+06   1814.36948  \n",
       "1073     18000.0  5.387770e+06   3628.73896  \n",
       "...          ...           ...          ...  \n",
       "165700       0.0  0.000000e+00      0.00000  \n",
       "165701       0.0  0.000000e+00      0.00000  \n",
       "165702       0.0  0.000000e+00      0.00000  \n",
       "165703       0.0  0.000000e+00      0.00000  \n",
       "165704       0.0  0.000000e+00      0.00000  \n",
       "165705       0.0  0.000000e+00      0.00000  \n",
       "165706       0.0  0.000000e+00      0.00000  \n",
       "165707       0.0  0.000000e+00      0.00000  \n",
       "165708       0.0  0.000000e+00      0.00000  \n",
       "165709       0.0  0.000000e+00      0.00000  \n",
       "165710       0.0  0.000000e+00      0.00000  \n",
       "165711       0.0  0.000000e+00      0.00000  \n",
       "165712       0.0  0.000000e+00      0.00000  \n",
       "165713    2000.0  0.000000e+00    299.00000  \n",
       "165714       0.0  0.000000e+00      0.00000  \n",
       "165715       0.0  0.000000e+00      0.00000  \n",
       "165716       0.0  0.000000e+00      0.00000  \n",
       "165717       0.0  0.000000e+00      0.00000  \n",
       "165718       0.0  0.000000e+00      0.00000  \n",
       "165719    1000.0  0.000000e+00   1434.00000  \n",
       "165720       0.0  0.000000e+00      0.00000  \n",
       "165721    5000.0  0.000000e+00   1786.00000  \n",
       "165722       0.0  0.000000e+00      0.00000  \n",
       "165723       0.0  0.000000e+00      0.00000  \n",
       "165724       0.0  0.000000e+00      0.00000  \n",
       "165725    1000.0  0.000000e+00    342.00000  \n",
       "165726    1000.0  0.000000e+00    166.00000  \n",
       "165727    1000.0  0.000000e+00    290.00000  \n",
       "165728       0.0  0.000000e+00      0.00000  \n",
       "165729       0.0  0.000000e+00      0.00000  \n",
       "\n",
       "[83018 rows x 8 columns]"
      ]
     },
     "execution_count": 149,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_df = pd.read_pickle('./data/df_1015_sample.pickle')\n",
    "sample_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 294,
   "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>country_a</th>\n",
       "      <th>country_b</th>\n",
       "      <th>item_no</th>\n",
       "      <th>date</th>\n",
       "      <th>im_qty</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>world</td>\n",
       "      <td>Barbados</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M04</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>world</td>\n",
       "      <td>Barbados</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M05</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>world</td>\n",
       "      <td>Barbados</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M06</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>world</td>\n",
       "      <td>Barbados</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>world</td>\n",
       "      <td>Barbados</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M08</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>world</td>\n",
       "      <td>Barbados</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M09</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>world</td>\n",
       "      <td>Barbados</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M10</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>world</td>\n",
       "      <td>Barbados</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M11</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>world</td>\n",
       "      <td>Barbados</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M12</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>world</td>\n",
       "      <td>Barbados</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2018-M01</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>world</td>\n",
       "      <td>Guyana</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M04</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>world</td>\n",
       "      <td>Guyana</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M05</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>world</td>\n",
       "      <td>Guyana</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M06</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>world</td>\n",
       "      <td>Guyana</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M07</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>world</td>\n",
       "      <td>Guyana</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M08</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>world</td>\n",
       "      <td>Guyana</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M09</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>world</td>\n",
       "      <td>Guyana</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M10</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>world</td>\n",
       "      <td>Guyana</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M11</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>world</td>\n",
       "      <td>Guyana</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M12</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>world</td>\n",
       "      <td>Guyana</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2018-M01</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>world</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M04</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>world</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M05</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>world</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M06</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>world</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>world</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M08</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>world</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M09</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>world</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M10</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>world</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M11</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>world</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M12</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>world</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2018-M01</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>world</td>\n",
       "      <td>Mozambique</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M04</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>world</td>\n",
       "      <td>Mozambique</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M05</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>world</td>\n",
       "      <td>Mozambique</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M06</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>world</td>\n",
       "      <td>Mozambique</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M07</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>world</td>\n",
       "      <td>Mozambique</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M08</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>world</td>\n",
       "      <td>Mozambique</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M09</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>world</td>\n",
       "      <td>Mozambique</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M10</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>world</td>\n",
       "      <td>Mozambique</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M11</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>world</td>\n",
       "      <td>Mozambique</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M12</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>world</td>\n",
       "      <td>Mozambique</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2018-M01</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M04</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M05</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M06</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M08</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M09</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M10</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M11</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2017-M12</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>020711</td>\n",
       "      <td>Exported value in 2018-M01</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   country_a    country_b item_no                        date  im_qty\n",
       "0      world     Barbados  020711  Exported value in 2017-M04     0.0\n",
       "1      world     Barbados  020711  Exported value in 2017-M05     0.0\n",
       "2      world     Barbados  020711  Exported value in 2017-M06     0.0\n",
       "3      world     Barbados  020711  Exported value in 2017-M07     NaN\n",
       "4      world     Barbados  020711  Exported value in 2017-M08     NaN\n",
       "5      world     Barbados  020711  Exported value in 2017-M09     0.0\n",
       "6      world     Barbados  020711  Exported value in 2017-M10     0.0\n",
       "7      world     Barbados  020711  Exported value in 2017-M11     0.0\n",
       "8      world     Barbados  020711  Exported value in 2017-M12     0.0\n",
       "9      world     Barbados  020711  Exported value in 2018-M01     NaN\n",
       "10     world       Guyana  020711  Exported value in 2017-M04     NaN\n",
       "11     world       Guyana  020711  Exported value in 2017-M05     0.0\n",
       "12     world       Guyana  020711  Exported value in 2017-M06     0.0\n",
       "13     world       Guyana  020711  Exported value in 2017-M07     0.0\n",
       "14     world       Guyana  020711  Exported value in 2017-M08     0.0\n",
       "15     world       Guyana  020711  Exported value in 2017-M09     NaN\n",
       "16     world       Guyana  020711  Exported value in 2017-M10     NaN\n",
       "17     world       Guyana  020711  Exported value in 2017-M11     NaN\n",
       "18     world       Guyana  020711  Exported value in 2017-M12     NaN\n",
       "19     world       Guyana  020711  Exported value in 2018-M01     NaN\n",
       "20     world       Malawi  020711  Exported value in 2017-M04     NaN\n",
       "21     world       Malawi  020711  Exported value in 2017-M05     NaN\n",
       "22     world       Malawi  020711  Exported value in 2017-M06     NaN\n",
       "23     world       Malawi  020711  Exported value in 2017-M07     NaN\n",
       "24     world       Malawi  020711  Exported value in 2017-M08     NaN\n",
       "25     world       Malawi  020711  Exported value in 2017-M09     NaN\n",
       "26     world       Malawi  020711  Exported value in 2017-M10     NaN\n",
       "27     world       Malawi  020711  Exported value in 2017-M11     NaN\n",
       "28     world       Malawi  020711  Exported value in 2017-M12     NaN\n",
       "29     world       Malawi  020711  Exported value in 2018-M01     NaN\n",
       "30     world   Mozambique  020711  Exported value in 2017-M04     0.0\n",
       "31     world   Mozambique  020711  Exported value in 2017-M05     0.0\n",
       "32     world   Mozambique  020711  Exported value in 2017-M06     0.0\n",
       "33     world   Mozambique  020711  Exported value in 2017-M07     0.0\n",
       "34     world   Mozambique  020711  Exported value in 2017-M08     0.0\n",
       "35     world   Mozambique  020711  Exported value in 2017-M09     0.0\n",
       "36     world   Mozambique  020711  Exported value in 2017-M10     NaN\n",
       "37     world   Mozambique  020711  Exported value in 2017-M11     NaN\n",
       "38     world   Mozambique  020711  Exported value in 2017-M12     NaN\n",
       "39     world   Mozambique  020711  Exported value in 2018-M01     NaN\n",
       "40     world  Philippines  020711  Exported value in 2017-M04     NaN\n",
       "41     world  Philippines  020711  Exported value in 2017-M05     NaN\n",
       "42     world  Philippines  020711  Exported value in 2017-M06     NaN\n",
       "43     world  Philippines  020711  Exported value in 2017-M07     NaN\n",
       "44     world  Philippines  020711  Exported value in 2017-M08     NaN\n",
       "45     world  Philippines  020711  Exported value in 2017-M09     0.0\n",
       "46     world  Philippines  020711  Exported value in 2017-M10     0.0\n",
       "47     world  Philippines  020711  Exported value in 2017-M11     0.0\n",
       "48     world  Philippines  020711  Exported value in 2017-M12     0.0\n",
       "49     world  Philippines  020711  Exported value in 2018-M01     0.0"
      ]
     },
     "execution_count": 294,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## from matplotlib.cbook import flatten\n",
    "\n",
    "def unit_transform(arg):\n",
    "    if (arg[0] == \"0\") or (arg[0] == 'No Quantity'):\n",
    "        return 0.0\n",
    "    elif arg[1] == \"Tons\":\n",
    "        return float(arg[0]) * 907.18474\n",
    "    elif arg[1] == \"Pounds\":\n",
    "        return float(arg[0]) * 0.45359237\n",
    "    elif arg[1] == \"Hundreds units\":\n",
    "        return float(arg[0]) * 100\n",
    "    elif arg[1] == \"Thousands units\":\n",
    "        return float(arg[0]) * 1000\n",
    "    elif arg[1] in [\"Dozens\", \"Heads\"]:\n",
    "        return 0.0\n",
    "    elif arg[1] in [\"Kilograms\", 'Units', 'Unit', 'Mixed']:\n",
    "        return float(arg[0])\n",
    "    \n",
    "\n",
    "\n",
    "def parser_row_val(df,row_no,item_no):\n",
    "    country_a =\"world\"\n",
    "#     row_no = 3\n",
    "    country_b = df.loc[row_no][1]\n",
    "    row_val = df.loc[row_no][2:].tolist()\n",
    "\n",
    "\n",
    "    date_list = df.loc[0][2:].dropna().tolist()\n",
    "    date_list =list(flatten(zip(date_list,date_list))) # 複製一份 date\n",
    "    \n",
    "    # parser row_val value\n",
    "    allrow=[]\n",
    "    for i in range(0,len(row_val),2):\n",
    "        arg = (row_val[i],row_val[i+1])\n",
    "        v = unit_transform(arg)\n",
    "        row = [country_a,country_b,item_no,date_list[i],v]\n",
    "        allrow.append(row)\n",
    "#         print(i)\n",
    "    return allrow\n",
    "        \n",
    "\n",
    "# columns = ['country_a', 'country_b', 'date', 'ex_val', 'item_no', 'im_val', 'ex_qty', 'im_qty']\n",
    "columns = ['country_a', 'country_b', 'item_no' , 'date', 'im_qty']\n",
    "\n",
    "df = pd.read_pickle('./sameple-data/test.pickle')\n",
    "item_no = \"020711\"\n",
    "\n",
    "records=[]\n",
    "for row_no in range(2,len(df)): # 資料從第三行開始\n",
    "    allrow = parser_row_val(df,row_no, item_no)\n",
    "    for row in allrow:\n",
    "        records.append(row)\n",
    "# records\n",
    "df2 = pd.DataFrame.from_records(records,columns = columns)\n",
    "df2.head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 292,
   "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>country_a</th>\n",
       "      <th>country_b</th>\n",
       "      <th>item_no</th>\n",
       "      <th>date</th>\n",
       "      <th>ex_val</th>\n",
       "      <th>ex_qty</th>\n",
       "      <th>im_val</th>\n",
       "      <th>im_qty</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>world</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.204292e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.720464e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>world</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.093865e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.683750e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>world</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.443549e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.259262e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>world</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.593346e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.962157e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>world</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.575089e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.667500e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>world</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.761258e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.327750e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>world</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.671864e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.259475e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>world</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.973943e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.851182e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>world</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.426706e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.546189e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>world</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.899553e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.914109e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>world</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.888375e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.581960e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>world</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.770127e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.434680e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>world</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.603678e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.889600e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>world</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.867459e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.133100e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>world</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.245241e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.392900e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>world</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.657977e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.802010e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>world</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.969066e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.405480e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>world</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.272272e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.570930e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>world</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.775716e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.530700e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>world</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.472496e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.574690e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>world</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.066567e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.204459e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>world</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.860636e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.986735e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>world</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.669220e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.503830e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>world</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.232582e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.104669e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>world</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.794411e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.431255e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>world</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.053241e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.676195e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>world</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.226069e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.458471e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>world</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.669220e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.966494e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>world</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.896923e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.921135e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>world</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.712765e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.095597e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2017-M03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.640000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2017-M04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.537000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2017-M05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.239000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2017-M06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2017-M07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.090000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2017-M08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.171000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2017-M09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.155000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2017-M10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.346000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2017-M11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.888000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2017-M12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.030000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.480000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5080 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    country_a                         country_b item_no      date  ex_val  \\\n",
       "0       world                Russian Federation  020711  2017-M03     NaN   \n",
       "1       world                Russian Federation  020711  2017-M04     NaN   \n",
       "2       world                Russian Federation  020711  2017-M05     NaN   \n",
       "3       world                Russian Federation  020711  2017-M06     NaN   \n",
       "4       world                Russian Federation  020711  2017-M07     NaN   \n",
       "5       world                Russian Federation  020711  2017-M08     NaN   \n",
       "6       world                Russian Federation  020711  2017-M09     NaN   \n",
       "7       world                Russian Federation  020711  2017-M10     NaN   \n",
       "8       world                Russian Federation  020711  2017-M11     NaN   \n",
       "9       world                Russian Federation  020711  2017-M12     NaN   \n",
       "10      world          United States of America  020711  2017-M03     NaN   \n",
       "11      world          United States of America  020711  2017-M04     NaN   \n",
       "12      world          United States of America  020711  2017-M05     NaN   \n",
       "13      world          United States of America  020711  2017-M06     NaN   \n",
       "14      world          United States of America  020711  2017-M07     NaN   \n",
       "15      world          United States of America  020711  2017-M08     NaN   \n",
       "16      world          United States of America  020711  2017-M09     NaN   \n",
       "17      world          United States of America  020711  2017-M10     NaN   \n",
       "18      world          United States of America  020711  2017-M11     NaN   \n",
       "19      world          United States of America  020711  2017-M12     NaN   \n",
       "20      world                          Portugal  020711  2017-M03     NaN   \n",
       "21      world                          Portugal  020711  2017-M04     NaN   \n",
       "22      world                          Portugal  020711  2017-M05     NaN   \n",
       "23      world                          Portugal  020711  2017-M06     NaN   \n",
       "24      world                          Portugal  020711  2017-M07     NaN   \n",
       "25      world                          Portugal  020711  2017-M08     NaN   \n",
       "26      world                          Portugal  020711  2017-M09     NaN   \n",
       "27      world                          Portugal  020711  2017-M10     NaN   \n",
       "28      world                          Portugal  020711  2017-M11     NaN   \n",
       "29      world                          Portugal  020711  2017-M12     NaN   \n",
       "..        ...                               ...     ...       ...     ...   \n",
       "130     world                       Philippines  040700  2018-M01     NaN   \n",
       "131     world                       Philippines  040700  2018-M02     NaN   \n",
       "132     world                       Philippines  040700  2018-M03     NaN   \n",
       "133     world                       Philippines  040700  2018-M04     NaN   \n",
       "134     world                       Philippines  040700  2018-M05     NaN   \n",
       "135     world                       Philippines  040700  2018-M06     NaN   \n",
       "136     world                       Philippines  040700  2018-M07     NaN   \n",
       "137     world                       Philippines  040700  2018-M08     NaN   \n",
       "138     world                       Philippines  040700  2018-M09     NaN   \n",
       "139     world                       Philippines  040700  2018-M10     NaN   \n",
       "140     world  Saint Vincent and the Grenadines  040700  2017-M03     NaN   \n",
       "141     world  Saint Vincent and the Grenadines  040700  2017-M04     NaN   \n",
       "142     world  Saint Vincent and the Grenadines  040700  2017-M05     NaN   \n",
       "143     world  Saint Vincent and the Grenadines  040700  2017-M06     NaN   \n",
       "144     world  Saint Vincent and the Grenadines  040700  2017-M07     NaN   \n",
       "145     world  Saint Vincent and the Grenadines  040700  2017-M08     NaN   \n",
       "146     world  Saint Vincent and the Grenadines  040700  2017-M09     NaN   \n",
       "147     world  Saint Vincent and the Grenadines  040700  2017-M10     NaN   \n",
       "148     world  Saint Vincent and the Grenadines  040700  2017-M11     NaN   \n",
       "149     world  Saint Vincent and the Grenadines  040700  2017-M12     NaN   \n",
       "150     world  Saint Vincent and the Grenadines  040700  2018-M01     NaN   \n",
       "151     world  Saint Vincent and the Grenadines  040700  2018-M02     NaN   \n",
       "152     world  Saint Vincent and the Grenadines  040700  2018-M03     NaN   \n",
       "153     world  Saint Vincent and the Grenadines  040700  2018-M04     NaN   \n",
       "154     world  Saint Vincent and the Grenadines  040700  2018-M05     NaN   \n",
       "155     world  Saint Vincent and the Grenadines  040700  2018-M06     NaN   \n",
       "156     world  Saint Vincent and the Grenadines  040700  2018-M07     NaN   \n",
       "157     world  Saint Vincent and the Grenadines  040700  2018-M08     NaN   \n",
       "158     world  Saint Vincent and the Grenadines  040700  2018-M09     NaN   \n",
       "159     world  Saint Vincent and the Grenadines  040700  2018-M10     NaN   \n",
       "\n",
       "           ex_qty  im_val        im_qty  \n",
       "0    2.204292e+06     NaN  4.720464e+06  \n",
       "1    2.093865e+06     NaN  4.683750e+06  \n",
       "2    2.443549e+06     NaN  5.259262e+06  \n",
       "3    1.593346e+06     NaN  5.962157e+06  \n",
       "4    1.575089e+06     NaN  4.667500e+06  \n",
       "5    1.761258e+06     NaN  4.327750e+06  \n",
       "6    1.671864e+06     NaN  4.259475e+06  \n",
       "7    1.973943e+06     NaN  5.851182e+06  \n",
       "8    2.426706e+06     NaN  5.546189e+06  \n",
       "9    1.899553e+06     NaN  3.914109e+06  \n",
       "10   2.888375e+06     NaN  2.581960e+05  \n",
       "11   2.770127e+06     NaN  1.434680e+05  \n",
       "12   3.603678e+06     NaN  1.889600e+05  \n",
       "13   4.867459e+06     NaN  2.133100e+05  \n",
       "14   3.245241e+06     NaN  1.392900e+05  \n",
       "15   2.657977e+06     NaN  1.802010e+05  \n",
       "16   1.969066e+06     NaN  2.405480e+05  \n",
       "17   2.272272e+06     NaN  1.570930e+05  \n",
       "18   1.775716e+06     NaN  2.530700e+05  \n",
       "19   1.472496e+06     NaN  1.574690e+05  \n",
       "20   2.066567e+06     NaN  2.204459e+05  \n",
       "21   1.860636e+06     NaN  1.986735e+05  \n",
       "22   1.669220e+06     NaN  2.503830e+05  \n",
       "23   2.232582e+06     NaN  2.104669e+05  \n",
       "24   1.794411e+06     NaN  2.431255e+05  \n",
       "25   1.053241e+06     NaN  2.676195e+05  \n",
       "26   9.226069e+05     NaN  2.458471e+05  \n",
       "27   1.669220e+06     NaN  2.966494e+05  \n",
       "28   1.896923e+06     NaN  2.921135e+05  \n",
       "29   1.712765e+06     NaN  2.095597e+05  \n",
       "..            ...     ...           ...  \n",
       "130  0.000000e+00     NaN  0.000000e+00  \n",
       "131  0.000000e+00     NaN  0.000000e+00  \n",
       "132  0.000000e+00     NaN  0.000000e+00  \n",
       "133  0.000000e+00     NaN  0.000000e+00  \n",
       "134  0.000000e+00     NaN  0.000000e+00  \n",
       "135  0.000000e+00     NaN  0.000000e+00  \n",
       "136           NaN     NaN           NaN  \n",
       "137           NaN     NaN           NaN  \n",
       "138           NaN     NaN           NaN  \n",
       "139           NaN     NaN           NaN  \n",
       "140           NaN     NaN  8.640000e+02  \n",
       "141           NaN     NaN  2.537000e+03  \n",
       "142           NaN     NaN  1.239000e+03  \n",
       "143           NaN     NaN  0.000000e+00  \n",
       "144           NaN     NaN  4.090000e+02  \n",
       "145           NaN     0.0  1.171000e+03  \n",
       "146           NaN     0.0  1.155000e+03  \n",
       "147           NaN     NaN  1.346000e+03  \n",
       "148           NaN     NaN  1.888000e+03  \n",
       "149           NaN     NaN  6.030000e+03  \n",
       "150           NaN     NaN  0.000000e+00  \n",
       "151           NaN     NaN  6.480000e+02  \n",
       "152           NaN     NaN  0.000000e+00  \n",
       "153           NaN     NaN           NaN  \n",
       "154           NaN     NaN           NaN  \n",
       "155           NaN     NaN           NaN  \n",
       "156           NaN     NaN           NaN  \n",
       "157           NaN     NaN           NaN  \n",
       "158           NaN     NaN           NaN  \n",
       "159           NaN     NaN           NaN  \n",
       "\n",
       "[5080 rows x 8 columns]"
      ]
     },
     "execution_count": 292,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from functools import reduce\n",
    "\n",
    "n = 16\n",
    "df_all =pd.DataFrame()\n",
    "for x in range(0,16,4):\n",
    "    data_frames = [pd.read_pickle(str(i)+'.pickle') for i in range(x,x+4)]\n",
    "\n",
    "    df_merge = reduce(lambda  left,right: pd.merge(left,right,on=[\"country_a\",\"country_b\",\"date\",\"item_no\"],\n",
    "                                                how='outer'), data_frames) # 每四個 df merge一次\n",
    "\n",
    "\n",
    "\n",
    "    df_all = pd.concat([df_all,df_merge])\n",
    "\n",
    "df_all.to_pickle(\"df_sample.pickle\")\n",
    "df_all"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 293,
   "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>country_a</th>\n",
       "      <th>country_b</th>\n",
       "      <th>item_no</th>\n",
       "      <th>date</th>\n",
       "      <th>ex_val</th>\n",
       "      <th>ex_qty</th>\n",
       "      <th>im_val</th>\n",
       "      <th>im_qty</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>world</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.204292e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.720464e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>world</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.093865e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.683750e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>world</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.443549e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.259262e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>world</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.593346e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.962157e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>world</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.575089e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.667500e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>world</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.761258e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.327750e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>world</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.671864e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.259475e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>world</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.973943e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.851182e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>world</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.426706e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.546189e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>world</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.899553e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.914109e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>world</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.888375e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.581960e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>world</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.770127e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.434680e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>world</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.603678e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.889600e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>world</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.867459e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.133100e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>world</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.245241e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.392900e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>world</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.657977e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.802010e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>world</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.969066e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.405480e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>world</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.272272e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.570930e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>world</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.775716e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.530700e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>world</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.472496e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.574690e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>world</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.066567e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.204459e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>world</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.860636e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.986735e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>world</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.669220e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.503830e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>world</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.232582e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.104669e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>world</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.794411e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.431255e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>world</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.053241e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.676195e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>world</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.226069e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.458471e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>world</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.669220e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.966494e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>world</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.896923e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.921135e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>world</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>020711</td>\n",
       "      <td>2017-M12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.712765e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.095597e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>world</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2017-M03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.640000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2017-M04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.537000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2017-M05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.239000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2017-M06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2017-M07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.090000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2017-M08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.171000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2017-M09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.155000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2017-M10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.346000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2017-M11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.888000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2017-M12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.030000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.480000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>world</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>040700</td>\n",
       "      <td>2018-M10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5080 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    country_a                         country_b item_no      date  ex_val  \\\n",
       "0       world                Russian Federation  020711  2017-M03     NaN   \n",
       "1       world                Russian Federation  020711  2017-M04     NaN   \n",
       "2       world                Russian Federation  020711  2017-M05     NaN   \n",
       "3       world                Russian Federation  020711  2017-M06     NaN   \n",
       "4       world                Russian Federation  020711  2017-M07     NaN   \n",
       "5       world                Russian Federation  020711  2017-M08     NaN   \n",
       "6       world                Russian Federation  020711  2017-M09     NaN   \n",
       "7       world                Russian Federation  020711  2017-M10     NaN   \n",
       "8       world                Russian Federation  020711  2017-M11     NaN   \n",
       "9       world                Russian Federation  020711  2017-M12     NaN   \n",
       "10      world          United States of America  020711  2017-M03     NaN   \n",
       "11      world          United States of America  020711  2017-M04     NaN   \n",
       "12      world          United States of America  020711  2017-M05     NaN   \n",
       "13      world          United States of America  020711  2017-M06     NaN   \n",
       "14      world          United States of America  020711  2017-M07     NaN   \n",
       "15      world          United States of America  020711  2017-M08     NaN   \n",
       "16      world          United States of America  020711  2017-M09     NaN   \n",
       "17      world          United States of America  020711  2017-M10     NaN   \n",
       "18      world          United States of America  020711  2017-M11     NaN   \n",
       "19      world          United States of America  020711  2017-M12     NaN   \n",
       "20      world                          Portugal  020711  2017-M03     NaN   \n",
       "21      world                          Portugal  020711  2017-M04     NaN   \n",
       "22      world                          Portugal  020711  2017-M05     NaN   \n",
       "23      world                          Portugal  020711  2017-M06     NaN   \n",
       "24      world                          Portugal  020711  2017-M07     NaN   \n",
       "25      world                          Portugal  020711  2017-M08     NaN   \n",
       "26      world                          Portugal  020711  2017-M09     NaN   \n",
       "27      world                          Portugal  020711  2017-M10     NaN   \n",
       "28      world                          Portugal  020711  2017-M11     NaN   \n",
       "29      world                          Portugal  020711  2017-M12     NaN   \n",
       "..        ...                               ...     ...       ...     ...   \n",
       "130     world                       Philippines  040700  2018-M01     NaN   \n",
       "131     world                       Philippines  040700  2018-M02     NaN   \n",
       "132     world                       Philippines  040700  2018-M03     NaN   \n",
       "133     world                       Philippines  040700  2018-M04     NaN   \n",
       "134     world                       Philippines  040700  2018-M05     NaN   \n",
       "135     world                       Philippines  040700  2018-M06     NaN   \n",
       "136     world                       Philippines  040700  2018-M07     NaN   \n",
       "137     world                       Philippines  040700  2018-M08     NaN   \n",
       "138     world                       Philippines  040700  2018-M09     NaN   \n",
       "139     world                       Philippines  040700  2018-M10     NaN   \n",
       "140     world  Saint Vincent and the Grenadines  040700  2017-M03     NaN   \n",
       "141     world  Saint Vincent and the Grenadines  040700  2017-M04     NaN   \n",
       "142     world  Saint Vincent and the Grenadines  040700  2017-M05     NaN   \n",
       "143     world  Saint Vincent and the Grenadines  040700  2017-M06     NaN   \n",
       "144     world  Saint Vincent and the Grenadines  040700  2017-M07     NaN   \n",
       "145     world  Saint Vincent and the Grenadines  040700  2017-M08     NaN   \n",
       "146     world  Saint Vincent and the Grenadines  040700  2017-M09     NaN   \n",
       "147     world  Saint Vincent and the Grenadines  040700  2017-M10     NaN   \n",
       "148     world  Saint Vincent and the Grenadines  040700  2017-M11     NaN   \n",
       "149     world  Saint Vincent and the Grenadines  040700  2017-M12     NaN   \n",
       "150     world  Saint Vincent and the Grenadines  040700  2018-M01     NaN   \n",
       "151     world  Saint Vincent and the Grenadines  040700  2018-M02     NaN   \n",
       "152     world  Saint Vincent and the Grenadines  040700  2018-M03     NaN   \n",
       "153     world  Saint Vincent and the Grenadines  040700  2018-M04     NaN   \n",
       "154     world  Saint Vincent and the Grenadines  040700  2018-M05     NaN   \n",
       "155     world  Saint Vincent and the Grenadines  040700  2018-M06     NaN   \n",
       "156     world  Saint Vincent and the Grenadines  040700  2018-M07     NaN   \n",
       "157     world  Saint Vincent and the Grenadines  040700  2018-M08     NaN   \n",
       "158     world  Saint Vincent and the Grenadines  040700  2018-M09     NaN   \n",
       "159     world  Saint Vincent and the Grenadines  040700  2018-M10     NaN   \n",
       "\n",
       "           ex_qty  im_val        im_qty  \n",
       "0    2.204292e+06     NaN  4.720464e+06  \n",
       "1    2.093865e+06     NaN  4.683750e+06  \n",
       "2    2.443549e+06     NaN  5.259262e+06  \n",
       "3    1.593346e+06     NaN  5.962157e+06  \n",
       "4    1.575089e+06     NaN  4.667500e+06  \n",
       "5    1.761258e+06     NaN  4.327750e+06  \n",
       "6    1.671864e+06     NaN  4.259475e+06  \n",
       "7    1.973943e+06     NaN  5.851182e+06  \n",
       "8    2.426706e+06     NaN  5.546189e+06  \n",
       "9    1.899553e+06     NaN  3.914109e+06  \n",
       "10   2.888375e+06     NaN  2.581960e+05  \n",
       "11   2.770127e+06     NaN  1.434680e+05  \n",
       "12   3.603678e+06     NaN  1.889600e+05  \n",
       "13   4.867459e+06     NaN  2.133100e+05  \n",
       "14   3.245241e+06     NaN  1.392900e+05  \n",
       "15   2.657977e+06     NaN  1.802010e+05  \n",
       "16   1.969066e+06     NaN  2.405480e+05  \n",
       "17   2.272272e+06     NaN  1.570930e+05  \n",
       "18   1.775716e+06     NaN  2.530700e+05  \n",
       "19   1.472496e+06     NaN  1.574690e+05  \n",
       "20   2.066567e+06     NaN  2.204459e+05  \n",
       "21   1.860636e+06     NaN  1.986735e+05  \n",
       "22   1.669220e+06     NaN  2.503830e+05  \n",
       "23   2.232582e+06     NaN  2.104669e+05  \n",
       "24   1.794411e+06     NaN  2.431255e+05  \n",
       "25   1.053241e+06     NaN  2.676195e+05  \n",
       "26   9.226069e+05     NaN  2.458471e+05  \n",
       "27   1.669220e+06     NaN  2.966494e+05  \n",
       "28   1.896923e+06     NaN  2.921135e+05  \n",
       "29   1.712765e+06     NaN  2.095597e+05  \n",
       "..            ...     ...           ...  \n",
       "130  0.000000e+00     NaN  0.000000e+00  \n",
       "131  0.000000e+00     NaN  0.000000e+00  \n",
       "132  0.000000e+00     NaN  0.000000e+00  \n",
       "133  0.000000e+00     NaN  0.000000e+00  \n",
       "134  0.000000e+00     NaN  0.000000e+00  \n",
       "135  0.000000e+00     NaN  0.000000e+00  \n",
       "136           NaN     NaN           NaN  \n",
       "137           NaN     NaN           NaN  \n",
       "138           NaN     NaN           NaN  \n",
       "139           NaN     NaN           NaN  \n",
       "140           NaN     NaN  8.640000e+02  \n",
       "141           NaN     NaN  2.537000e+03  \n",
       "142           NaN     NaN  1.239000e+03  \n",
       "143           NaN     NaN  0.000000e+00  \n",
       "144           NaN     NaN  4.090000e+02  \n",
       "145           NaN     0.0  1.171000e+03  \n",
       "146           NaN     0.0  1.155000e+03  \n",
       "147           NaN     NaN  1.346000e+03  \n",
       "148           NaN     NaN  1.888000e+03  \n",
       "149           NaN     NaN  6.030000e+03  \n",
       "150           NaN     NaN  0.000000e+00  \n",
       "151           NaN     NaN  6.480000e+02  \n",
       "152           NaN     NaN  0.000000e+00  \n",
       "153           NaN     NaN           NaN  \n",
       "154           NaN     NaN           NaN  \n",
       "155           NaN     NaN           NaN  \n",
       "156           NaN     NaN           NaN  \n",
       "157           NaN     NaN           NaN  \n",
       "158           NaN     NaN           NaN  \n",
       "159           NaN     NaN           NaN  \n",
       "\n",
       "[5080 rows x 8 columns]"
      ]
     },
     "execution_count": 293,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_pickle('df_sample.pickle')\n",
    "df"
   ]
  },
  {
   "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.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}