comtrade_template.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import sqlalchemy as sa\n",
    "from sqlalchemy import Table,bindparam, and_, text\n",
    "from sqlalchemy.ext.declarative import declarative_base"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "conn = sa.create_engine(\"mysql+pymysql://CMARCINIAK:ifpri360@localhost/comtrade?charset=utf8mb4\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "#query = \"SELECT classification,year,commodity_code,partner_iso,reporter_iso,value,quantity,netweight_kg,kg_conversion_factor,qty_unit,trade_flow FROM comtradehs2015 where trade_flow_code < 3 and commodity_code like '0%%';\"\n",
    "\n",
    "#data = pd.read_sql(query,conn)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "def make_query(number):\n",
    "    query = \"SELECT classification,year,commodity_code,partner_iso,reporter_iso,value,quantity,netweight_kg,kg_conversion_factor,qty_unit,trade_flow FROM comtradehs2015 where trade_flow_code < 3 and commodity_code like '{0}%%';\"\n",
    "    return query.format(str(number))\n",
    "\n",
    "chapters = [0,1,20,21,22,23,24,50,51]\n",
    "\n",
    "queries = list(map(make_query,chapters))\n",
    "data = pd.DataFrame()\n",
    "for query in queries:\n",
    "    table = pd.read_sql(query,conn)\n",
    "    data = pd.concat([data,table])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([<class 'str'>], dtype=object)"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.commodity_code.map(type).unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        0101\n",
       "1        0101\n",
       "2        0101\n",
       "3        0101\n",
       "4        0101\n",
       "5        0101\n",
       "6        0101\n",
       "7        0101\n",
       "8        0101\n",
       "9        0101\n",
       "10       0101\n",
       "11       0101\n",
       "12       0101\n",
       "13       0101\n",
       "14       0101\n",
       "15       0101\n",
       "16       0101\n",
       "17       0101\n",
       "18       0101\n",
       "19       0101\n",
       "20       0101\n",
       "21       0101\n",
       "22       0101\n",
       "23       0101\n",
       "24       0101\n",
       "25       0101\n",
       "26       0101\n",
       "27       0101\n",
       "28       0101\n",
       "29       0101\n",
       "         ... \n",
       "35324    5113\n",
       "35325    5113\n",
       "35326    5113\n",
       "35327    5113\n",
       "35328    5113\n",
       "35329    5113\n",
       "35330    5113\n",
       "35331    5113\n",
       "35332    5113\n",
       "35333    5113\n",
       "35334    5113\n",
       "35335    5113\n",
       "35336    5113\n",
       "35337    5113\n",
       "35338    5113\n",
       "35339    5113\n",
       "35340    5113\n",
       "35341    5113\n",
       "35342    5113\n",
       "35343    5113\n",
       "35344    5113\n",
       "35345    5113\n",
       "35346    5113\n",
       "35347    5113\n",
       "35348    5113\n",
       "35349    5113\n",
       "35350    5113\n",
       "35351    5113\n",
       "35352    5113\n",
       "35353    5113\n",
       "Name: commodity_code, dtype: object"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.commodity_code.map(lambda x: x[0:4])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#data['HS4'] = pd.Series(map( lambda x: x[0:4], data.commodity_code))\n",
    "data['HS4'] = data.commodity_code.map(lambda x: x[0:4])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "agg = data.groupby([\"HS4\",\"reporter_iso\",\"partner_iso\",\"trade_flow\",\"year\"],as_index=False).sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 138,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>HS4</th>\n",
       "      <th>reporter_iso</th>\n",
       "      <th>partner_iso</th>\n",
       "      <th>trade_flow</th>\n",
       "      <th>year</th>\n",
       "      <th>value</th>\n",
       "      <th>quantity</th>\n",
       "      <th>netweight_kg</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARE</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>1075670.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARE</td>\n",
       "      <td>Import</td>\n",
       "      <td>2015</td>\n",
       "      <td>118005.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>5353.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>110582.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>BGR</td>\n",
       "      <td>Import</td>\n",
       "      <td>2015</td>\n",
       "      <td>7405.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>336.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>BHR</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>344866.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>BOL</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>88399.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>BRA</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>4001849.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>BRA</td>\n",
       "      <td>Import</td>\n",
       "      <td>2015</td>\n",
       "      <td>14938.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>678.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>CAN</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>3301500.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>CAN</td>\n",
       "      <td>Import</td>\n",
       "      <td>2015</td>\n",
       "      <td>12458.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>565.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>CHE</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>5282411.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>CHE</td>\n",
       "      <td>Import</td>\n",
       "      <td>2015</td>\n",
       "      <td>707285.0</td>\n",
       "      <td>169.0</td>\n",
       "      <td>27384.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>CHL</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>945515.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>CHN</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>2004790.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>COD</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>8540.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>COL</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>975354.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>CYP</td>\n",
       "      <td>Import</td>\n",
       "      <td>2015</td>\n",
       "      <td>416771.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>18906.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>CZE</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>1453720.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>DEU</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>3192850.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>DEU</td>\n",
       "      <td>Import</td>\n",
       "      <td>2015</td>\n",
       "      <td>3430078.0</td>\n",
       "      <td>460.0</td>\n",
       "      <td>28105.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>DNK</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>479800.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>DNK</td>\n",
       "      <td>Import</td>\n",
       "      <td>2015</td>\n",
       "      <td>277161.0</td>\n",
       "      <td>385.0</td>\n",
       "      <td>12338.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ECU</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>308675.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>EGY</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>1809902.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ESP</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>1652830.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ESP</td>\n",
       "      <td>Import</td>\n",
       "      <td>2015</td>\n",
       "      <td>345350.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>1942.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>FIN</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>456242.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>FRA</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>2031334.0</td>\n",
       "      <td>318.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>FRA</td>\n",
       "      <td>Import</td>\n",
       "      <td>2015</td>\n",
       "      <td>3673740.0</td>\n",
       "      <td>430.0</td>\n",
       "      <td>105614.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>GBR</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>1700606.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>NaN</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>775838</th>\n",
       "      <td>5112</td>\n",
       "      <td>BEL</td>\n",
       "      <td>SVK</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>56398.0</td>\n",
       "      <td>1080.0</td>\n",
       "      <td>1080.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775839</th>\n",
       "      <td>5112</td>\n",
       "      <td>BEL</td>\n",
       "      <td>SVK</td>\n",
       "      <td>Import</td>\n",
       "      <td>2015</td>\n",
       "      <td>69.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775840</th>\n",
       "      <td>5112</td>\n",
       "      <td>BEL</td>\n",
       "      <td>SVN</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>747.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775841</th>\n",
       "      <td>5112</td>\n",
       "      <td>BEL</td>\n",
       "      <td>SWE</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>84250.0</td>\n",
       "      <td>2072.0</td>\n",
       "      <td>2072.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775842</th>\n",
       "      <td>5112</td>\n",
       "      <td>BEL</td>\n",
       "      <td>SWE</td>\n",
       "      <td>Import</td>\n",
       "      <td>2015</td>\n",
       "      <td>3187.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>63.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775843</th>\n",
       "      <td>5112</td>\n",
       "      <td>BEL</td>\n",
       "      <td>THA</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>12359.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775844</th>\n",
       "      <td>5112</td>\n",
       "      <td>BEL</td>\n",
       "      <td>TUN</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>8487.0</td>\n",
       "      <td>127.0</td>\n",
       "      <td>127.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775845</th>\n",
       "      <td>5112</td>\n",
       "      <td>BEL</td>\n",
       "      <td>TUR</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>140273.0</td>\n",
       "      <td>3013.0</td>\n",
       "      <td>3013.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775846</th>\n",
       "      <td>5112</td>\n",
       "      <td>BEL</td>\n",
       "      <td>TUR</td>\n",
       "      <td>Import</td>\n",
       "      <td>2015</td>\n",
       "      <td>132266.0</td>\n",
       "      <td>2192.0</td>\n",
       "      <td>2192.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775847</th>\n",
       "      <td>5112</td>\n",
       "      <td>BEL</td>\n",
       "      <td>UKR</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>549039.0</td>\n",
       "      <td>12919.0</td>\n",
       "      <td>12919.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775848</th>\n",
       "      <td>5112</td>\n",
       "      <td>BEL</td>\n",
       "      <td>UKR</td>\n",
       "      <td>Import</td>\n",
       "      <td>2015</td>\n",
       "      <td>996.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775849</th>\n",
       "      <td>5112</td>\n",
       "      <td>BEL</td>\n",
       "      <td>USA</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>4137337.0</td>\n",
       "      <td>87119.0</td>\n",
       "      <td>87119.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775850</th>\n",
       "      <td>5112</td>\n",
       "      <td>BEL</td>\n",
       "      <td>USA</td>\n",
       "      <td>Import</td>\n",
       "      <td>2015</td>\n",
       "      <td>21094.0</td>\n",
       "      <td>399.0</td>\n",
       "      <td>399.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775851</th>\n",
       "      <td>5112</td>\n",
       "      <td>BEL</td>\n",
       "      <td>VNM</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>63885.0</td>\n",
       "      <td>1377.0</td>\n",
       "      <td>1377.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775852</th>\n",
       "      <td>5112</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ZAF</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>26283.0</td>\n",
       "      <td>580.0</td>\n",
       "      <td>580.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779216</th>\n",
       "      <td>5113</td>\n",
       "      <td>BEL</td>\n",
       "      <td>CHE</td>\n",
       "      <td>Import</td>\n",
       "      <td>2015</td>\n",
       "      <td>1018.0</td>\n",
       "      <td>79.0</td>\n",
       "      <td>79.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779217</th>\n",
       "      <td>5113</td>\n",
       "      <td>BEL</td>\n",
       "      <td>CHN</td>\n",
       "      <td>Import</td>\n",
       "      <td>2015</td>\n",
       "      <td>2120.0</td>\n",
       "      <td>164.0</td>\n",
       "      <td>164.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779218</th>\n",
       "      <td>5113</td>\n",
       "      <td>BEL</td>\n",
       "      <td>COD</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>124.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779219</th>\n",
       "      <td>5113</td>\n",
       "      <td>BEL</td>\n",
       "      <td>DEU</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>98.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779220</th>\n",
       "      <td>5113</td>\n",
       "      <td>BEL</td>\n",
       "      <td>DEU</td>\n",
       "      <td>Import</td>\n",
       "      <td>2015</td>\n",
       "      <td>4023.0</td>\n",
       "      <td>312.0</td>\n",
       "      <td>312.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779221</th>\n",
       "      <td>5113</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ESP</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>647.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>41.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779222</th>\n",
       "      <td>5113</td>\n",
       "      <td>BEL</td>\n",
       "      <td>FRA</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>33280.0</td>\n",
       "      <td>2116.0</td>\n",
       "      <td>2116.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779223</th>\n",
       "      <td>5113</td>\n",
       "      <td>BEL</td>\n",
       "      <td>FRA</td>\n",
       "      <td>Import</td>\n",
       "      <td>2015</td>\n",
       "      <td>1456.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>113.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779224</th>\n",
       "      <td>5113</td>\n",
       "      <td>BEL</td>\n",
       "      <td>HKG</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>8333.0</td>\n",
       "      <td>530.0</td>\n",
       "      <td>530.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779225</th>\n",
       "      <td>5113</td>\n",
       "      <td>BEL</td>\n",
       "      <td>IND</td>\n",
       "      <td>Import</td>\n",
       "      <td>2015</td>\n",
       "      <td>626.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>48.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779226</th>\n",
       "      <td>5113</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ITA</td>\n",
       "      <td>Import</td>\n",
       "      <td>2015</td>\n",
       "      <td>8176.0</td>\n",
       "      <td>633.0</td>\n",
       "      <td>633.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779227</th>\n",
       "      <td>5113</td>\n",
       "      <td>BEL</td>\n",
       "      <td>NLD</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>34.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779228</th>\n",
       "      <td>5113</td>\n",
       "      <td>BEL</td>\n",
       "      <td>NLD</td>\n",
       "      <td>Import</td>\n",
       "      <td>2015</td>\n",
       "      <td>3260.0</td>\n",
       "      <td>253.0</td>\n",
       "      <td>253.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779229</th>\n",
       "      <td>5113</td>\n",
       "      <td>BEL</td>\n",
       "      <td>PRT</td>\n",
       "      <td>Export</td>\n",
       "      <td>2015</td>\n",
       "      <td>61.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779230</th>\n",
       "      <td>5113</td>\n",
       "      <td>BEL</td>\n",
       "      <td>TUR</td>\n",
       "      <td>Import</td>\n",
       "      <td>2015</td>\n",
       "      <td>58.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17821 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         HS4 reporter_iso partner_iso trade_flow  year      value  quantity  \\\n",
       "112     0101          BEL         ARE     Export  2015  1075670.0      63.0   \n",
       "113     0101          BEL         ARE     Import  2015   118005.0      11.0   \n",
       "114     0101          BEL         ARG     Export  2015   110582.0      11.0   \n",
       "115     0101          BEL         BGR     Import  2015     7405.0      13.0   \n",
       "116     0101          BEL         BHR     Export  2015   344866.0      20.0   \n",
       "117     0101          BEL         BOL     Export  2015    88399.0       4.0   \n",
       "118     0101          BEL         BRA     Export  2015  4001849.0     132.0   \n",
       "119     0101          BEL         BRA     Import  2015    14938.0       2.0   \n",
       "120     0101          BEL         CAN     Export  2015  3301500.0      91.0   \n",
       "121     0101          BEL         CAN     Import  2015    12458.0       1.0   \n",
       "122     0101          BEL         CHE     Export  2015  5282411.0     135.0   \n",
       "123     0101          BEL         CHE     Import  2015   707285.0     169.0   \n",
       "124     0101          BEL         CHL     Export  2015   945515.0      36.0   \n",
       "125     0101          BEL         CHN     Export  2015  2004790.0      78.0   \n",
       "126     0101          BEL         COD     Export  2015     8540.0       1.0   \n",
       "127     0101          BEL         COL     Export  2015   975354.0      38.0   \n",
       "128     0101          BEL         CYP     Import  2015   416771.0       1.0   \n",
       "129     0101          BEL         CZE     Export  2015  1453720.0      33.0   \n",
       "130     0101          BEL         DEU     Export  2015  3192850.0     136.0   \n",
       "131     0101          BEL         DEU     Import  2015  3430078.0     460.0   \n",
       "132     0101          BEL         DNK     Export  2015   479800.0      15.0   \n",
       "133     0101          BEL         DNK     Import  2015   277161.0     385.0   \n",
       "134     0101          BEL         ECU     Export  2015   308675.0      11.0   \n",
       "135     0101          BEL         EGY     Export  2015  1809902.0      97.0   \n",
       "136     0101          BEL         ESP     Export  2015  1652830.0       8.0   \n",
       "137     0101          BEL         ESP     Import  2015   345350.0      38.0   \n",
       "138     0101          BEL         FIN     Export  2015   456242.0      10.0   \n",
       "139     0101          BEL         FRA     Export  2015  2031334.0     318.0   \n",
       "140     0101          BEL         FRA     Import  2015  3673740.0     430.0   \n",
       "141     0101          BEL         GBR     Export  2015  1700606.0      29.0   \n",
       "...      ...          ...         ...        ...   ...        ...       ...   \n",
       "775838  5112          BEL         SVK     Export  2015    56398.0    1080.0   \n",
       "775839  5112          BEL         SVK     Import  2015       69.0       1.0   \n",
       "775840  5112          BEL         SVN     Export  2015      747.0      14.0   \n",
       "775841  5112          BEL         SWE     Export  2015    84250.0    2072.0   \n",
       "775842  5112          BEL         SWE     Import  2015     3187.0      63.0   \n",
       "775843  5112          BEL         THA     Export  2015    12359.0     200.0   \n",
       "775844  5112          BEL         TUN     Export  2015     8487.0     127.0   \n",
       "775845  5112          BEL         TUR     Export  2015   140273.0    3013.0   \n",
       "775846  5112          BEL         TUR     Import  2015   132266.0    2192.0   \n",
       "775847  5112          BEL         UKR     Export  2015   549039.0   12919.0   \n",
       "775848  5112          BEL         UKR     Import  2015      996.0       9.0   \n",
       "775849  5112          BEL         USA     Export  2015  4137337.0   87119.0   \n",
       "775850  5112          BEL         USA     Import  2015    21094.0     399.0   \n",
       "775851  5112          BEL         VNM     Export  2015    63885.0    1377.0   \n",
       "775852  5112          BEL         ZAF     Export  2015    26283.0     580.0   \n",
       "779216  5113          BEL         CHE     Import  2015     1018.0      79.0   \n",
       "779217  5113          BEL         CHN     Import  2015     2120.0     164.0   \n",
       "779218  5113          BEL         COD     Export  2015      124.0       8.0   \n",
       "779219  5113          BEL         DEU     Export  2015       98.0       6.0   \n",
       "779220  5113          BEL         DEU     Import  2015     4023.0     312.0   \n",
       "779221  5113          BEL         ESP     Export  2015      647.0      41.0   \n",
       "779222  5113          BEL         FRA     Export  2015    33280.0    2116.0   \n",
       "779223  5113          BEL         FRA     Import  2015     1456.0     113.0   \n",
       "779224  5113          BEL         HKG     Export  2015     8333.0     530.0   \n",
       "779225  5113          BEL         IND     Import  2015      626.0      48.0   \n",
       "779226  5113          BEL         ITA     Import  2015     8176.0     633.0   \n",
       "779227  5113          BEL         NLD     Export  2015       34.0       2.0   \n",
       "779228  5113          BEL         NLD     Import  2015     3260.0     253.0   \n",
       "779229  5113          BEL         PRT     Export  2015       61.0       4.0   \n",
       "779230  5113          BEL         TUR     Import  2015       58.0       5.0   \n",
       "\n",
       "        netweight_kg  \n",
       "112              NaN  \n",
       "113           5353.0  \n",
       "114              NaN  \n",
       "115            336.0  \n",
       "116              NaN  \n",
       "117              NaN  \n",
       "118              NaN  \n",
       "119            678.0  \n",
       "120              NaN  \n",
       "121            565.0  \n",
       "122              NaN  \n",
       "123          27384.0  \n",
       "124              NaN  \n",
       "125              NaN  \n",
       "126              NaN  \n",
       "127              NaN  \n",
       "128          18906.0  \n",
       "129              NaN  \n",
       "130              NaN  \n",
       "131          28105.0  \n",
       "132              NaN  \n",
       "133          12338.0  \n",
       "134              NaN  \n",
       "135              NaN  \n",
       "136              NaN  \n",
       "137           1942.0  \n",
       "138              NaN  \n",
       "139              NaN  \n",
       "140         105614.0  \n",
       "141              NaN  \n",
       "...              ...  \n",
       "775838        1080.0  \n",
       "775839           1.0  \n",
       "775840          14.0  \n",
       "775841        2072.0  \n",
       "775842          63.0  \n",
       "775843         200.0  \n",
       "775844         127.0  \n",
       "775845        3013.0  \n",
       "775846        2192.0  \n",
       "775847       12919.0  \n",
       "775848           9.0  \n",
       "775849       87119.0  \n",
       "775850         399.0  \n",
       "775851        1377.0  \n",
       "775852         580.0  \n",
       "779216          79.0  \n",
       "779217         164.0  \n",
       "779218           8.0  \n",
       "779219           6.0  \n",
       "779220         312.0  \n",
       "779221          41.0  \n",
       "779222        2116.0  \n",
       "779223         113.0  \n",
       "779224         530.0  \n",
       "779225          48.0  \n",
       "779226         633.0  \n",
       "779227           2.0  \n",
       "779228         253.0  \n",
       "779229           4.0  \n",
       "779230           5.0  \n",
       "\n",
       "[17821 rows x 8 columns]"
      ]
     },
     "execution_count": 138,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "agg[agg.reporter_iso==\"BEL\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 139,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#output = agg[['value','quantity','netweight_kg']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 140,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "ename": "PermissionError",
     "evalue": "[Errno 13] Permission denied: 'output_2015a.csv'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mPermissionError\u001b[0m                           Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-140-f67adaa5b0cb>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0moutput\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mto_csv\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"output_2015a.csv\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;32mC:\\Miniconda3\\lib\\site-packages\\pandas\\core\\frame.py\u001b[0m in \u001b[0;36mto_csv\u001b[1;34m(self, path_or_buf, sep, na_rep, float_format, columns, header, index, index_label, mode, encoding, compression, quoting, quotechar, line_terminator, chunksize, tupleize_cols, date_format, doublequote, escapechar, decimal)\u001b[0m\n\u001b[0;32m   1381\u001b[0m                                      \u001b[0mdoublequote\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mdoublequote\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   1382\u001b[0m                                      escapechar=escapechar, decimal=decimal)\n\u001b[1;32m-> 1383\u001b[1;33m         \u001b[0mformatter\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0msave\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   1384\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   1385\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mpath_or_buf\u001b[0m \u001b[1;32mis\u001b[0m \u001b[1;32mNone\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mC:\\Miniconda3\\lib\\site-packages\\pandas\\formats\\format.py\u001b[0m in \u001b[0;36msave\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m   1458\u001b[0m             f = _get_handle(self.path_or_buf, self.mode,\n\u001b[0;32m   1459\u001b[0m                             \u001b[0mencoding\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mencoding\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 1460\u001b[1;33m                             compression=self.compression)\n\u001b[0m\u001b[0;32m   1461\u001b[0m             \u001b[0mclose\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;32mTrue\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   1462\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mC:\\Miniconda3\\lib\\site-packages\\pandas\\io\\common.py\u001b[0m in \u001b[0;36m_get_handle\u001b[1;34m(path, mode, encoding, compression, memory_map)\u001b[0m\n\u001b[0;32m    330\u001b[0m                 \u001b[0mf\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mopen\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mpath\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmode\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mencoding\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mencoding\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    331\u001b[0m             \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 332\u001b[1;33m                 \u001b[0mf\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mopen\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mpath\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmode\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0merrors\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;34m'replace'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    333\u001b[0m         \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    334\u001b[0m             \u001b[0mf\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mopen\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mpath\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmode\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mPermissionError\u001b[0m: [Errno 13] Permission denied: 'output_2015a.csv'"
     ]
    }
   ],
   "source": [
    "output.to_csv(\"output_2015a.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>value</th>\n",
       "      <th>quantity</th>\n",
       "      <th>netweight_kg</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20463.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2250.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10066.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>9010.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>68.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>45899.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>10033.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>89874.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>19107.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5700.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>16132.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>11905.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>17140.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>837809.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>541100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>5322.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>7982.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>32089.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>17783.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>5537.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>6466.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>6211.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>5943.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>456.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>707.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>25105.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>651.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>9719.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5490.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>1632.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1270.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>65.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>1500.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>72864.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20605.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277</th>\n",
       "      <td>24000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2314.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278</th>\n",
       "      <td>127000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8861.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284</th>\n",
       "      <td>479.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>754636</th>\n",
       "      <td>1067.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>754638</th>\n",
       "      <td>119.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>754639</th>\n",
       "      <td>14703.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>761169</th>\n",
       "      <td>624.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>761170</th>\n",
       "      <td>255.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>761191</th>\n",
       "      <td>209146.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>761758</th>\n",
       "      <td>1221.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>762091</th>\n",
       "      <td>3426.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>762161</th>\n",
       "      <td>155.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>762565</th>\n",
       "      <td>62.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>762861</th>\n",
       "      <td>22.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>762876</th>\n",
       "      <td>91.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>762910</th>\n",
       "      <td>237.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>763765</th>\n",
       "      <td>949.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>763766</th>\n",
       "      <td>1541.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>764699</th>\n",
       "      <td>1000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>765290</th>\n",
       "      <td>10.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>765364</th>\n",
       "      <td>119.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>770452</th>\n",
       "      <td>74746.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>771003</th>\n",
       "      <td>3000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>771655</th>\n",
       "      <td>102.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>772119</th>\n",
       "      <td>10.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>772198</th>\n",
       "      <td>205.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>772200</th>\n",
       "      <td>2051.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>772300</th>\n",
       "      <td>44.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>772388</th>\n",
       "      <td>119.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>772391</th>\n",
       "      <td>2728.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>772394</th>\n",
       "      <td>523.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>776673</th>\n",
       "      <td>61956.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>777364</th>\n",
       "      <td>32900.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6360 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           value  quantity  netweight_kg\n",
       "0        20463.0       NaN        2250.0\n",
       "1        10066.0       NaN        1000.0\n",
       "2         9010.0       NaN          68.0\n",
       "90       45899.0       NaN         800.0\n",
       "91       10033.0       NaN        1000.0\n",
       "92       89874.0       NaN        4900.0\n",
       "93       19107.0       NaN        5700.0\n",
       "94       16132.0       NaN         500.0\n",
       "95       11905.0       NaN        1000.0\n",
       "96       17140.0       NaN         400.0\n",
       "97      837809.0       NaN      541100.0\n",
       "98        5322.0       NaN         300.0\n",
       "99        7982.0       NaN         600.0\n",
       "100      32089.0       NaN        1400.0\n",
       "101      17783.0       NaN        1300.0\n",
       "102       5537.0       NaN         500.0\n",
       "149       6466.0       NaN           NaN\n",
       "171       6211.0       NaN           NaN\n",
       "188       5943.0       NaN        8300.0\n",
       "189        456.0       NaN       20000.0\n",
       "190        707.0       NaN        1300.0\n",
       "232      25105.0       NaN         651.0\n",
       "233       9719.0       NaN        5490.0\n",
       "234       1632.0       NaN        1270.0\n",
       "235         65.0       NaN          10.0\n",
       "246       1500.0       NaN           1.0\n",
       "247      72864.0       NaN       20605.0\n",
       "277      24000.0       NaN        2314.0\n",
       "278     127000.0       NaN        8861.0\n",
       "284        479.0       NaN         600.0\n",
       "...          ...       ...           ...\n",
       "754636    1067.0       NaN           NaN\n",
       "754638     119.0       NaN           NaN\n",
       "754639   14703.0       NaN           NaN\n",
       "761169     624.0       NaN           NaN\n",
       "761170     255.0       NaN           NaN\n",
       "761191  209146.0       NaN           NaN\n",
       "761758    1221.0       NaN           NaN\n",
       "762091    3426.0       NaN           NaN\n",
       "762161     155.0       NaN           NaN\n",
       "762565      62.0       NaN           NaN\n",
       "762861      22.0       NaN           NaN\n",
       "762876      91.0       NaN           NaN\n",
       "762910     237.0       NaN           NaN\n",
       "763765     949.0       NaN           NaN\n",
       "763766    1541.0       NaN           NaN\n",
       "764699    1000.0       NaN           NaN\n",
       "765290      10.0       NaN           NaN\n",
       "765364     119.0       NaN           NaN\n",
       "770452   74746.0       NaN           NaN\n",
       "771003    3000.0       NaN           NaN\n",
       "771655     102.0       NaN           NaN\n",
       "772119      10.0       NaN           NaN\n",
       "772198     205.0       NaN           NaN\n",
       "772200    2051.0       NaN           NaN\n",
       "772300      44.0       NaN           NaN\n",
       "772388     119.0       NaN           NaN\n",
       "772391    2728.0       NaN           NaN\n",
       "772394     523.0       NaN           NaN\n",
       "776673   61956.0       NaN           NaN\n",
       "777364   32900.0       NaN           NaN\n",
       "\n",
       "[6360 rows x 3 columns]"
      ]
     },
     "execution_count": 137,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "output[output.quantity.isnull()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 146,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "a = pd.read_csv(\"output_2013b.csv\",dtype={'HS4':str})\n",
    "b = pd.read_csv(\"output_2014b.csv\",dtype={'HS4':str})\n",
    "c = pd.read_csv(\"output_2015b.csv\",dtype={'HS4':str})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "out = pd.concat([a,b,c])\n",
    "# = out['']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "out['VALUE (1000USD)'] = out.value/1000\n",
    "out['REPORTER [ISO 3 LETTER]'] = out['reporter_iso']\n",
    "out['PARTNER [ISO 3 LETTER]'] = out['partner_iso']\n",
    "out['HS4 [4 digit]'] = out['HS4']\n",
    "out['YEAR'] = out['year']\n",
    "out['VOLUME (M Tons)'] = out['netweight_kg']/1000\n",
    "out['FLOWS (X or M)'] = out.trade_flow.map({\"Export\":\"X\",\"Import\":\"M\"})\n",
    "outfile = out[['REPORTER [ISO 3 LETTER]','PARTNER [ISO 3 LETTER]','HS4 [4 digit]','FLOWS (X or M)','YEAR','VALUE (1000USD)','VOLUME (M Tons)'] ]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 150,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['REPORTER [ISO 3 LETTER]', 'PARTNER [ISO 3 LETTER]', 'HS4 [4 digit]',\n",
       "       'FLOWS (X or M)', 'YEAR', 'VALUE (1000USD)', 'VOLUME (M Tons)'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 150,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "outfile.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 151,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "outfile.to_csv(\"template_COMTRADE.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2372646"
      ]
     },
     "execution_count": 116,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(outfile)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 127,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "product_codes = outfile[outfile['VOLUME (M Tons)'].isnull()].groupby([\"YEAR\"])[\"HS4 [4 digit]\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "HS4 [4 digit]\n",
       "0106    309\n",
       "0101    299\n",
       "0301    271\n",
       "0604    252\n",
       "2106    225\n",
       "1209    204\n",
       "0511    132\n",
       "1515     99\n",
       "0603     72\n",
       "0602     69\n",
       "1206     52\n",
       "0105     47\n",
       "0504     43\n",
       "1301     37\n",
       "1504     36\n",
       "1212     35\n",
       "1208     31\n",
       "1207     30\n",
       "5007     27\n",
       "1401     23\n",
       "5112     23\n",
       "0508     22\n",
       "1510     22\n",
       "2201     21\n",
       "1001     19\n",
       "1008     19\n",
       "2403     19\n",
       "0510     18\n",
       "2003     17\n",
       "0410     16\n",
       "       ... \n",
       "1806      4\n",
       "5102      4\n",
       "0102      3\n",
       "0206      3\n",
       "0305      3\n",
       "0402      3\n",
       "0703      3\n",
       "1108      3\n",
       "1513      3\n",
       "2102      3\n",
       "2306      3\n",
       "5105      3\n",
       "5109      3\n",
       "0210      2\n",
       "0302      2\n",
       "0304      2\n",
       "0809      2\n",
       "1522      2\n",
       "2009      2\n",
       "5104      2\n",
       "0208      1\n",
       "0408      1\n",
       "0714      1\n",
       "1003      1\n",
       "1103      1\n",
       "1104      1\n",
       "1205      1\n",
       "1702      1\n",
       "2008      1\n",
       "2204      1\n",
       "Name: HS4 [4 digit], dtype: int64"
      ]
     },
     "execution_count": 131,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "product_codes[2015]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "HS4 [4 digit]  REPORTER [ISO 3 LETTER]\n",
       "0101           USA                        241\n",
       "               BEL                        164\n",
       "               ZAF                         98\n",
       "               CAN                         85\n",
       "               THA                         70\n",
       "               CHL                         37\n",
       "               SGP                         31\n",
       "               JPN                         25\n",
       "               IND                         24\n",
       "               BRN                         23\n",
       "               MEX                         22\n",
       "               MYS                         21\n",
       "               PAK                         16\n",
       "               HKG                         15\n",
       "               LKA                          9\n",
       "               MUS                          8\n",
       "               NGA                          7\n",
       "               VNM                          6\n",
       "               EGY                          5\n",
       "               ISR                          5\n",
       "               MNG                          4\n",
       "               NPL                          4\n",
       "               BMU                          3\n",
       "               BWA                          3\n",
       "               DOM                          3\n",
       "               PSE                          3\n",
       "               KEN                          1\n",
       "               MLT                          1\n",
       "               PLW                          1\n",
       "               ROU                          1\n",
       "                                         ... \n",
       "5108           TON                          1\n",
       "               VNM                          1\n",
       "5109           EGY                          1\n",
       "               ISR                          1\n",
       "               PSE                          1\n",
       "5110           SWE                          6\n",
       "               AUT                          5\n",
       "               DOM                          5\n",
       "               THA                          2\n",
       "               ZAF                          2\n",
       "               HKG                          1\n",
       "               ISR                          1\n",
       "               MLT                          1\n",
       "5111           SGP                          8\n",
       "5112           SGP                         21\n",
       "               IND                          3\n",
       "               DOM                          1\n",
       "               MEX                          1\n",
       "               VNM                          1\n",
       "5113           CHN                         35\n",
       "               BEL                         16\n",
       "               IND                         12\n",
       "               SGP                          7\n",
       "               VNM                          5\n",
       "               ISR                          2\n",
       "               MEX                          2\n",
       "               MNG                          2\n",
       "               SWE                          2\n",
       "               WSM                          2\n",
       "               NGA                          1\n",
       "Name: REPORTER [ISO 3 LETTER], dtype: int64"
      ]
     },
     "execution_count": 132,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "outfile[outfile['VOLUME (M Tons)'].isnull()].groupby([\"HS4 [4 digit]\"])[\"REPORTER [ISO 3 LETTER]\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 153,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>REPORTER [ISO 3 LETTER]</th>\n",
       "      <th>PARTNER [ISO 3 LETTER]</th>\n",
       "      <th>HS4 [4 digit]</th>\n",
       "      <th>FLOWS (X or M)</th>\n",
       "      <th>YEAR</th>\n",
       "      <th>VALUE (1000USD)</th>\n",
       "      <th>VOLUME (M Tons)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>BEL</td>\n",
       "      <td>ARE</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>407.566</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>82.055</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>BEL</td>\n",
       "      <td>AUT</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>37.585</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>BEL</td>\n",
       "      <td>BHR</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>20.713</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>BEL</td>\n",
       "      <td>BOL</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>6.420</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>BEL</td>\n",
       "      <td>BRA</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>9196.386</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>BEL</td>\n",
       "      <td>BWA</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>172.872</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>BEL</td>\n",
       "      <td>CAN</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>2469.010</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>BEL</td>\n",
       "      <td>CHE</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>9651.890</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>BEL</td>\n",
       "      <td>CHL</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>498.003</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>BEL</td>\n",
       "      <td>CHN</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>223.061</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>BEL</td>\n",
       "      <td>COD</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>22.704</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200</th>\n",
       "      <td>BEL</td>\n",
       "      <td>COL</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>1738.560</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>BEL</td>\n",
       "      <td>DEU</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>3158.830</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204</th>\n",
       "      <td>BEL</td>\n",
       "      <td>DNK</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>639.990</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>BEL</td>\n",
       "      <td>DZA</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>11.127</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>BEL</td>\n",
       "      <td>ECU</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>512.593</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>BEL</td>\n",
       "      <td>EGY</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>1386.680</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>BEL</td>\n",
       "      <td>FRA</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>10543.790</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>BEL</td>\n",
       "      <td>GBR</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>3552.310</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>BEL</td>\n",
       "      <td>GRC</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>976.676</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>BEL</td>\n",
       "      <td>IRL</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>2556.290</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>BEL</td>\n",
       "      <td>ISR</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>349.662</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>BEL</td>\n",
       "      <td>ITA</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>308.710</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>BEL</td>\n",
       "      <td>JPN</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>10185.400</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>BEL</td>\n",
       "      <td>KOR</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>445.193</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>BEL</td>\n",
       "      <td>KWT</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>22.704</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>BEL</td>\n",
       "      <td>LBY</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>2024.220</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>BEL</td>\n",
       "      <td>LUX</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>92.148</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>BEL</td>\n",
       "      <td>MAR</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>198.631</td>\n",
       "      <td>0.0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775125</th>\n",
       "      <td>SGP</td>\n",
       "      <td>CHN</td>\n",
       "      <td>5111</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>412.969</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775126</th>\n",
       "      <td>SGP</td>\n",
       "      <td>GBR</td>\n",
       "      <td>5111</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>139.525</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775127</th>\n",
       "      <td>SGP</td>\n",
       "      <td>IDN</td>\n",
       "      <td>5111</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>140.967</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775128</th>\n",
       "      <td>SGP</td>\n",
       "      <td>IND</td>\n",
       "      <td>5111</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>51.870</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775129</th>\n",
       "      <td>SGP</td>\n",
       "      <td>ITA</td>\n",
       "      <td>5111</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>206.345</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775130</th>\n",
       "      <td>SGP</td>\n",
       "      <td>MYS</td>\n",
       "      <td>5111</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>67.897</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775131</th>\n",
       "      <td>SGP</td>\n",
       "      <td>USA</td>\n",
       "      <td>5111</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>19.605</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>776673</th>\n",
       "      <td>DOM</td>\n",
       "      <td>ESP</td>\n",
       "      <td>5112</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>61.956</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>777364</th>\n",
       "      <td>IND</td>\n",
       "      <td>THA</td>\n",
       "      <td>5112</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>32.900</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778690</th>\n",
       "      <td>SGP</td>\n",
       "      <td>ARE</td>\n",
       "      <td>5112</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>156.041</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778691</th>\n",
       "      <td>SGP</td>\n",
       "      <td>CHE</td>\n",
       "      <td>5112</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>197.157</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778692</th>\n",
       "      <td>SGP</td>\n",
       "      <td>CHN</td>\n",
       "      <td>5112</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>35.581</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778693</th>\n",
       "      <td>SGP</td>\n",
       "      <td>CHN</td>\n",
       "      <td>5112</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>1427.375</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778694</th>\n",
       "      <td>SGP</td>\n",
       "      <td>DEU</td>\n",
       "      <td>5112</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>674.631</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778695</th>\n",
       "      <td>SGP</td>\n",
       "      <td>ECU</td>\n",
       "      <td>5112</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>35.786</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778696</th>\n",
       "      <td>SGP</td>\n",
       "      <td>GBR</td>\n",
       "      <td>5112</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>81.528</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778697</th>\n",
       "      <td>SGP</td>\n",
       "      <td>GBR</td>\n",
       "      <td>5112</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>663.807</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778698</th>\n",
       "      <td>SGP</td>\n",
       "      <td>HKG</td>\n",
       "      <td>5112</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>208.439</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778699</th>\n",
       "      <td>SGP</td>\n",
       "      <td>IDN</td>\n",
       "      <td>5112</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>298.942</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778700</th>\n",
       "      <td>SGP</td>\n",
       "      <td>IND</td>\n",
       "      <td>5112</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>1051.290</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778701</th>\n",
       "      <td>SGP</td>\n",
       "      <td>IND</td>\n",
       "      <td>5112</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>138.931</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778702</th>\n",
       "      <td>SGP</td>\n",
       "      <td>IRL</td>\n",
       "      <td>5112</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>139.025</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778703</th>\n",
       "      <td>SGP</td>\n",
       "      <td>ITA</td>\n",
       "      <td>5112</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>2608.076</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778704</th>\n",
       "      <td>SGP</td>\n",
       "      <td>KHM</td>\n",
       "      <td>5112</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>53.953</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778705</th>\n",
       "      <td>SGP</td>\n",
       "      <td>MMR</td>\n",
       "      <td>5112</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>41.904</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778706</th>\n",
       "      <td>SGP</td>\n",
       "      <td>MYS</td>\n",
       "      <td>5112</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>405.706</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778707</th>\n",
       "      <td>SGP</td>\n",
       "      <td>THA</td>\n",
       "      <td>5112</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>385.776</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778708</th>\n",
       "      <td>SGP</td>\n",
       "      <td>THA</td>\n",
       "      <td>5112</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>69.113</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778709</th>\n",
       "      <td>SGP</td>\n",
       "      <td>USA</td>\n",
       "      <td>5112</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>93.536</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778710</th>\n",
       "      <td>SGP</td>\n",
       "      <td>VNM</td>\n",
       "      <td>5112</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>277.025</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10516 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       REPORTER [ISO 3 LETTER] PARTNER [ISO 3 LETTER] HS4 [4 digit]  \\\n",
       "185                        BEL                    ARE          0101   \n",
       "187                        BEL                    ARG          0101   \n",
       "188                        BEL                    AUT          0101   \n",
       "189                        BEL                    BHR          0101   \n",
       "190                        BEL                    BOL          0101   \n",
       "191                        BEL                    BRA          0101   \n",
       "192                        BEL                    BWA          0101   \n",
       "193                        BEL                    CAN          0101   \n",
       "195                        BEL                    CHE          0101   \n",
       "197                        BEL                    CHL          0101   \n",
       "198                        BEL                    CHN          0101   \n",
       "199                        BEL                    COD          0101   \n",
       "200                        BEL                    COL          0101   \n",
       "202                        BEL                    DEU          0101   \n",
       "204                        BEL                    DNK          0101   \n",
       "206                        BEL                    DZA          0101   \n",
       "207                        BEL                    ECU          0101   \n",
       "208                        BEL                    EGY          0101   \n",
       "212                        BEL                    FRA          0101   \n",
       "214                        BEL                    GBR          0101   \n",
       "216                        BEL                    GRC          0101   \n",
       "217                        BEL                    IRL          0101   \n",
       "220                        BEL                    ISR          0101   \n",
       "222                        BEL                    ITA          0101   \n",
       "224                        BEL                    JPN          0101   \n",
       "225                        BEL                    KOR          0101   \n",
       "226                        BEL                    KWT          0101   \n",
       "227                        BEL                    LBY          0101   \n",
       "228                        BEL                    LUX          0101   \n",
       "230                        BEL                    MAR          0101   \n",
       "...                        ...                    ...           ...   \n",
       "775125                     SGP                    CHN          5111   \n",
       "775126                     SGP                    GBR          5111   \n",
       "775127                     SGP                    IDN          5111   \n",
       "775128                     SGP                    IND          5111   \n",
       "775129                     SGP                    ITA          5111   \n",
       "775130                     SGP                    MYS          5111   \n",
       "775131                     SGP                    USA          5111   \n",
       "776673                     DOM                    ESP          5112   \n",
       "777364                     IND                    THA          5112   \n",
       "778690                     SGP                    ARE          5112   \n",
       "778691                     SGP                    CHE          5112   \n",
       "778692                     SGP                    CHN          5112   \n",
       "778693                     SGP                    CHN          5112   \n",
       "778694                     SGP                    DEU          5112   \n",
       "778695                     SGP                    ECU          5112   \n",
       "778696                     SGP                    GBR          5112   \n",
       "778697                     SGP                    GBR          5112   \n",
       "778698                     SGP                    HKG          5112   \n",
       "778699                     SGP                    IDN          5112   \n",
       "778700                     SGP                    IND          5112   \n",
       "778701                     SGP                    IND          5112   \n",
       "778702                     SGP                    IRL          5112   \n",
       "778703                     SGP                    ITA          5112   \n",
       "778704                     SGP                    KHM          5112   \n",
       "778705                     SGP                    MMR          5112   \n",
       "778706                     SGP                    MYS          5112   \n",
       "778707                     SGP                    THA          5112   \n",
       "778708                     SGP                    THA          5112   \n",
       "778709                     SGP                    USA          5112   \n",
       "778710                     SGP                    VNM          5112   \n",
       "\n",
       "       FLOWS (X or M)  YEAR  VALUE (1000USD)  VOLUME (M Tons)  \n",
       "185                 X  2013          407.566              0.0  \n",
       "187                 X  2013           82.055              0.0  \n",
       "188                 X  2013           37.585              0.0  \n",
       "189                 X  2013           20.713              0.0  \n",
       "190                 X  2013            6.420              0.0  \n",
       "191                 X  2013         9196.386              0.0  \n",
       "192                 X  2013          172.872              0.0  \n",
       "193                 X  2013         2469.010              0.0  \n",
       "195                 X  2013         9651.890              0.0  \n",
       "197                 X  2013          498.003              0.0  \n",
       "198                 X  2013          223.061              0.0  \n",
       "199                 X  2013           22.704              0.0  \n",
       "200                 X  2013         1738.560              0.0  \n",
       "202                 X  2013         3158.830              0.0  \n",
       "204                 X  2013          639.990              0.0  \n",
       "206                 X  2013           11.127              0.0  \n",
       "207                 X  2013          512.593              0.0  \n",
       "208                 X  2013         1386.680              0.0  \n",
       "212                 X  2013        10543.790              0.0  \n",
       "214                 X  2013         3552.310              0.0  \n",
       "216                 X  2013          976.676              0.0  \n",
       "217                 X  2013         2556.290              0.0  \n",
       "220                 X  2013          349.662              0.0  \n",
       "222                 X  2013          308.710              0.0  \n",
       "224                 X  2013        10185.400              0.0  \n",
       "225                 X  2013          445.193              0.0  \n",
       "226                 X  2013           22.704              0.0  \n",
       "227                 X  2013         2024.220              0.0  \n",
       "228                 X  2013           92.148              0.0  \n",
       "230                 X  2013          198.631              0.0  \n",
       "...               ...   ...              ...              ...  \n",
       "775125              M  2015          412.969              0.0  \n",
       "775126              M  2015          139.525              0.0  \n",
       "775127              X  2015          140.967              0.0  \n",
       "775128              M  2015           51.870              0.0  \n",
       "775129              M  2015          206.345              0.0  \n",
       "775130              X  2015           67.897              0.0  \n",
       "775131              M  2015           19.605              0.0  \n",
       "776673              M  2015           61.956              0.0  \n",
       "777364              M  2015           32.900              0.0  \n",
       "778690              X  2015          156.041              0.0  \n",
       "778691              M  2015          197.157              0.0  \n",
       "778692              X  2015           35.581              0.0  \n",
       "778693              M  2015         1427.375              0.0  \n",
       "778694              M  2015          674.631              0.0  \n",
       "778695              X  2015           35.786              0.0  \n",
       "778696              X  2015           81.528              0.0  \n",
       "778697              M  2015          663.807              0.0  \n",
       "778698              X  2015          208.439              0.0  \n",
       "778699              X  2015          298.942              0.0  \n",
       "778700              X  2015         1051.290              0.0  \n",
       "778701              M  2015          138.931              0.0  \n",
       "778702              M  2015          139.025              0.0  \n",
       "778703              M  2015         2608.076              0.0  \n",
       "778704              X  2015           53.953              0.0  \n",
       "778705              X  2015           41.904              0.0  \n",
       "778706              X  2015          405.706              0.0  \n",
       "778707              X  2015          385.776              0.0  \n",
       "778708              M  2015           69.113              0.0  \n",
       "778709              M  2015           93.536              0.0  \n",
       "778710              X  2015          277.025              0.0  \n",
       "\n",
       "[10516 rows x 7 columns]"
      ]
     },
     "execution_count": 153,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "outfile[outfile[\"VOLUME (M Tons)\"]==0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 152,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>REPORTER [ISO 3 LETTER]</th>\n",
       "      <th>PARTNER [ISO 3 LETTER]</th>\n",
       "      <th>HS4 [4 digit]</th>\n",
       "      <th>FLOWS (X or M)</th>\n",
       "      <th>YEAR</th>\n",
       "      <th>VALUE (1000USD)</th>\n",
       "      <th>VOLUME (M Tons)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [REPORTER [ISO 3 LETTER], PARTNER [ISO 3 LETTER], HS4 [4 digit], FLOWS (X or M), YEAR, VALUE (1000USD), VOLUME (M Tons)]\n",
       "Index: []"
      ]
     },
     "execution_count": 152,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "outfile[outfile[\"VOLUME (M Tons)\"].isnull()].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "counts = outfile.groupby([\"REPORTER [ISO 3 LETTER]\",\"PARTNER [ISO 3 LETTER]\",\"HS4 [4 digit]\",\"FLOWS (X or M)\",\"YEAR\"]).count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2372646"
      ]
     },
     "execution_count": 105,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(counts)\n",
    "#len(counts[counts[\"VALUE (1000USD)\"]==1])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>HS4</th>\n",
       "      <th>reporter_iso</th>\n",
       "      <th>partner_iso</th>\n",
       "      <th>year</th>\n",
       "      <th>value</th>\n",
       "      <th>VOLUME (M Tons)</th>\n",
       "      <th>FLOWS (X or M)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>725</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>121324</td>\n",
       "      <td>0.300</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>726</th>\n",
       "      <td>0101</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>11069830</td>\n",
       "      <td>1876.001</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11025</th>\n",
       "      <td>0102</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>45143</td>\n",
       "      <td>5.713</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11026</th>\n",
       "      <td>0102</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>141782</td>\n",
       "      <td>260.490</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25060</th>\n",
       "      <td>0104</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>78151</td>\n",
       "      <td>0.865</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31228</th>\n",
       "      <td>0105</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>26119500</td>\n",
       "      <td>48282.300</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40917</th>\n",
       "      <td>0106</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>281180</td>\n",
       "      <td>62.486</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40918</th>\n",
       "      <td>0106</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>2018382</td>\n",
       "      <td>3132.987</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57087</th>\n",
       "      <td>0201</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>1525680</td>\n",
       "      <td>656.182</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57088</th>\n",
       "      <td>0201</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>11004029</td>\n",
       "      <td>1126.308</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68317</th>\n",
       "      <td>0202</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>111820</td>\n",
       "      <td>92.078</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68318</th>\n",
       "      <td>0202</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>898390</td>\n",
       "      <td>1112.538</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80305</th>\n",
       "      <td>0203</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>48429</td>\n",
       "      <td>21.390</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80306</th>\n",
       "      <td>0203</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>10275207</td>\n",
       "      <td>2502.792</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91837</th>\n",
       "      <td>0204</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>278961</td>\n",
       "      <td>39.723</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103660</th>\n",
       "      <td>0205</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>21071780</td>\n",
       "      <td>4253.070</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106703</th>\n",
       "      <td>0206</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>14985</td>\n",
       "      <td>13.234</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118583</th>\n",
       "      <td>0207</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>367522</td>\n",
       "      <td>152.485</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118584</th>\n",
       "      <td>0207</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>110601</td>\n",
       "      <td>48.324</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134087</th>\n",
       "      <td>0208</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>167766</td>\n",
       "      <td>18.279</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141997</th>\n",
       "      <td>0209</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>2789</td>\n",
       "      <td>0.400</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147956</th>\n",
       "      <td>0210</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>5515</td>\n",
       "      <td>1.760</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147957</th>\n",
       "      <td>0210</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>1936</td>\n",
       "      <td>0.236</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158281</th>\n",
       "      <td>0301</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>6801200</td>\n",
       "      <td>3878.400</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168421</th>\n",
       "      <td>0302</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>2871</td>\n",
       "      <td>1.621</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168422</th>\n",
       "      <td>0302</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>5725092</td>\n",
       "      <td>3599.021</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182213</th>\n",
       "      <td>0303</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>82120</td>\n",
       "      <td>7.235</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182214</th>\n",
       "      <td>0303</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>2348401</td>\n",
       "      <td>740.478</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197683</th>\n",
       "      <td>0304</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>32743</td>\n",
       "      <td>4.686</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197684</th>\n",
       "      <td>0304</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>1407877</td>\n",
       "      <td>257.940</td>\n",
       "      <td>M</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286962</th>\n",
       "      <td>0408</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>701623</td>\n",
       "      <td>115.000</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291182</th>\n",
       "      <td>0409</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>1310720</td>\n",
       "      <td>438.025</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300391</th>\n",
       "      <td>0504</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>1544100</td>\n",
       "      <td>334.200</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>309638</th>\n",
       "      <td>0507</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>5490</td>\n",
       "      <td>0.270</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>316300</th>\n",
       "      <td>0511</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>91119</td>\n",
       "      <td>91.209</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>325294</th>\n",
       "      <td>0602</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>1553</td>\n",
       "      <td>0.567</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>325295</th>\n",
       "      <td>0602</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>4090760</td>\n",
       "      <td>3071.860</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>333599</th>\n",
       "      <td>0603</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>22</td>\n",
       "      <td>0.011</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>347318</th>\n",
       "      <td>0701</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>1175</td>\n",
       "      <td>0.427</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357483</th>\n",
       "      <td>0703</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>87068</td>\n",
       "      <td>15.432</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371340</th>\n",
       "      <td>0705</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>399336</td>\n",
       "      <td>149.789</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>377296</th>\n",
       "      <td>0706</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>220638</td>\n",
       "      <td>26.366</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>381979</th>\n",
       "      <td>0707</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>19942</td>\n",
       "      <td>3.360</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391783</th>\n",
       "      <td>0709</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>2386284</td>\n",
       "      <td>400.408</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391784</th>\n",
       "      <td>0709</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>24696</td>\n",
       "      <td>25.406</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>402708</th>\n",
       "      <td>0710</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>224559</td>\n",
       "      <td>144.278</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>428127</th>\n",
       "      <td>0713</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>1970316</td>\n",
       "      <td>1846.593</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>444508</th>\n",
       "      <td>0801</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>33118</td>\n",
       "      <td>2.177</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>453057</th>\n",
       "      <td>0802</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>61322</td>\n",
       "      <td>8.294</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>469750</th>\n",
       "      <td>0804</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>25451</td>\n",
       "      <td>3.370</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>477708</th>\n",
       "      <td>0805</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>5877478</td>\n",
       "      <td>4860.114</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>482631</th>\n",
       "      <td>0806</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>69857</td>\n",
       "      <td>28.152</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490551</th>\n",
       "      <td>0808</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>748999</td>\n",
       "      <td>450.155</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>494665</th>\n",
       "      <td>0809</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>87759</td>\n",
       "      <td>10.560</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498084</th>\n",
       "      <td>0810</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>2489144</td>\n",
       "      <td>228.771</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>503544</th>\n",
       "      <td>0811</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>1400710</td>\n",
       "      <td>482.173</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>509605</th>\n",
       "      <td>0813</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>118893</td>\n",
       "      <td>126.000</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>525329</th>\n",
       "      <td>0902</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>841864</td>\n",
       "      <td>371.960</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>533825</th>\n",
       "      <td>0904</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>1158</td>\n",
       "      <td>0.078</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>553431</th>\n",
       "      <td>0910</td>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2013</td>\n",
       "      <td>1096</td>\n",
       "      <td>0.120</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>69 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         HS4 reporter_iso partner_iso  year     value  VOLUME (M Tons)  \\\n",
       "725     0101          BEL         ARG  2013    121324            0.300   \n",
       "726     0101          BEL         ARG  2013  11069830         1876.001   \n",
       "11025   0102          BEL         ARG  2013     45143            5.713   \n",
       "11026   0102          BEL         ARG  2013    141782          260.490   \n",
       "25060   0104          BEL         ARG  2013     78151            0.865   \n",
       "31228   0105          BEL         ARG  2013  26119500        48282.300   \n",
       "40917   0106          BEL         ARG  2013    281180           62.486   \n",
       "40918   0106          BEL         ARG  2013   2018382         3132.987   \n",
       "57087   0201          BEL         ARG  2013   1525680          656.182   \n",
       "57088   0201          BEL         ARG  2013  11004029         1126.308   \n",
       "68317   0202          BEL         ARG  2013    111820           92.078   \n",
       "68318   0202          BEL         ARG  2013    898390         1112.538   \n",
       "80305   0203          BEL         ARG  2013     48429           21.390   \n",
       "80306   0203          BEL         ARG  2013  10275207         2502.792   \n",
       "91837   0204          BEL         ARG  2013    278961           39.723   \n",
       "103660  0205          BEL         ARG  2013  21071780         4253.070   \n",
       "106703  0206          BEL         ARG  2013     14985           13.234   \n",
       "118583  0207          BEL         ARG  2013    367522          152.485   \n",
       "118584  0207          BEL         ARG  2013    110601           48.324   \n",
       "134087  0208          BEL         ARG  2013    167766           18.279   \n",
       "141997  0209          BEL         ARG  2013      2789            0.400   \n",
       "147956  0210          BEL         ARG  2013      5515            1.760   \n",
       "147957  0210          BEL         ARG  2013      1936            0.236   \n",
       "158281  0301          BEL         ARG  2013   6801200         3878.400   \n",
       "168421  0302          BEL         ARG  2013      2871            1.621   \n",
       "168422  0302          BEL         ARG  2013   5725092         3599.021   \n",
       "182213  0303          BEL         ARG  2013     82120            7.235   \n",
       "182214  0303          BEL         ARG  2013   2348401          740.478   \n",
       "197683  0304          BEL         ARG  2013     32743            4.686   \n",
       "197684  0304          BEL         ARG  2013   1407877          257.940   \n",
       "...      ...          ...         ...   ...       ...              ...   \n",
       "286962  0408          BEL         ARG  2013    701623          115.000   \n",
       "291182  0409          BEL         ARG  2013   1310720          438.025   \n",
       "300391  0504          BEL         ARG  2013   1544100          334.200   \n",
       "309638  0507          BEL         ARG  2013      5490            0.270   \n",
       "316300  0511          BEL         ARG  2013     91119           91.209   \n",
       "325294  0602          BEL         ARG  2013      1553            0.567   \n",
       "325295  0602          BEL         ARG  2013   4090760         3071.860   \n",
       "333599  0603          BEL         ARG  2013        22            0.011   \n",
       "347318  0701          BEL         ARG  2013      1175            0.427   \n",
       "357483  0703          BEL         ARG  2013     87068           15.432   \n",
       "371340  0705          BEL         ARG  2013    399336          149.789   \n",
       "377296  0706          BEL         ARG  2013    220638           26.366   \n",
       "381979  0707          BEL         ARG  2013     19942            3.360   \n",
       "391783  0709          BEL         ARG  2013   2386284          400.408   \n",
       "391784  0709          BEL         ARG  2013     24696           25.406   \n",
       "402708  0710          BEL         ARG  2013    224559          144.278   \n",
       "428127  0713          BEL         ARG  2013   1970316         1846.593   \n",
       "444508  0801          BEL         ARG  2013     33118            2.177   \n",
       "453057  0802          BEL         ARG  2013     61322            8.294   \n",
       "469750  0804          BEL         ARG  2013     25451            3.370   \n",
       "477708  0805          BEL         ARG  2013   5877478         4860.114   \n",
       "482631  0806          BEL         ARG  2013     69857           28.152   \n",
       "490551  0808          BEL         ARG  2013    748999          450.155   \n",
       "494665  0809          BEL         ARG  2013     87759           10.560   \n",
       "498084  0810          BEL         ARG  2013   2489144          228.771   \n",
       "503544  0811          BEL         ARG  2013   1400710          482.173   \n",
       "509605  0813          BEL         ARG  2013    118893          126.000   \n",
       "525329  0902          BEL         ARG  2013    841864          371.960   \n",
       "533825  0904          BEL         ARG  2013      1158            0.078   \n",
       "553431  0910          BEL         ARG  2013      1096            0.120   \n",
       "\n",
       "       FLOWS (X or M)  \n",
       "725                 X  \n",
       "726                 M  \n",
       "11025               X  \n",
       "11026               M  \n",
       "25060               X  \n",
       "31228               M  \n",
       "40917               X  \n",
       "40918               M  \n",
       "57087               X  \n",
       "57088               M  \n",
       "68317               X  \n",
       "68318               M  \n",
       "80305               X  \n",
       "80306               M  \n",
       "91837               M  \n",
       "103660              M  \n",
       "106703              M  \n",
       "118583              X  \n",
       "118584              M  \n",
       "134087              M  \n",
       "141997              X  \n",
       "147956              X  \n",
       "147957              M  \n",
       "158281              M  \n",
       "168421              X  \n",
       "168422              M  \n",
       "182213              X  \n",
       "182214              M  \n",
       "197683              X  \n",
       "197684              M  \n",
       "...               ...  \n",
       "286962              M  \n",
       "291182              M  \n",
       "300391              M  \n",
       "309638              M  \n",
       "316300              X  \n",
       "325294              X  \n",
       "325295              M  \n",
       "333599              X  \n",
       "347318              X  \n",
       "357483              X  \n",
       "371340              M  \n",
       "377296              X  \n",
       "381979              X  \n",
       "391783              X  \n",
       "391784              M  \n",
       "402708              X  \n",
       "428127              M  \n",
       "444508              X  \n",
       "453057              X  \n",
       "469750              M  \n",
       "477708              M  \n",
       "482631              M  \n",
       "490551              M  \n",
       "494665              M  \n",
       "498084              M  \n",
       "503544              M  \n",
       "509605              M  \n",
       "525329              M  \n",
       "533825              X  \n",
       "553431              X  \n",
       "\n",
       "[69 rows x 7 columns]"
      ]
     },
     "execution_count": 106,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gbr = a[a.reporter_iso=='BEL']\n",
    "gbr[gbr.partner_iso==\"ARG\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>REPORTER [ISO 3 LETTER]</th>\n",
       "      <th>PARTNER [ISO 3 LETTER]</th>\n",
       "      <th>HS4 [4 digit]</th>\n",
       "      <th>FLOWS (X or M)</th>\n",
       "      <th>YEAR</th>\n",
       "      <th>VALUE (1000USD)</th>\n",
       "      <th>VOLUME (M Tons)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>BEL</td>\n",
       "      <td>ARE</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>407.566</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>BEL</td>\n",
       "      <td>ARE</td>\n",
       "      <td>0101</td>\n",
       "      <td>M</td>\n",
       "      <td>2013</td>\n",
       "      <td>7.303</td>\n",
       "      <td>0.406</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>BEL</td>\n",
       "      <td>ARG</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>82.055</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>BEL</td>\n",
       "      <td>AUT</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>37.585</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>BEL</td>\n",
       "      <td>BHR</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>20.713</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>BEL</td>\n",
       "      <td>BOL</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>6.420</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>BEL</td>\n",
       "      <td>BRA</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>9196.386</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>BEL</td>\n",
       "      <td>BWA</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>172.872</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>BEL</td>\n",
       "      <td>CAN</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>2469.010</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>BEL</td>\n",
       "      <td>CAN</td>\n",
       "      <td>0101</td>\n",
       "      <td>M</td>\n",
       "      <td>2013</td>\n",
       "      <td>13.279</td>\n",
       "      <td>0.739</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>BEL</td>\n",
       "      <td>CHE</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>9651.890</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>BEL</td>\n",
       "      <td>CHE</td>\n",
       "      <td>0101</td>\n",
       "      <td>M</td>\n",
       "      <td>2013</td>\n",
       "      <td>619.848</td>\n",
       "      <td>10.588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>BEL</td>\n",
       "      <td>CHL</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>498.003</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>BEL</td>\n",
       "      <td>CHN</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>223.061</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>BEL</td>\n",
       "      <td>COD</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>22.704</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200</th>\n",
       "      <td>BEL</td>\n",
       "      <td>COL</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>1738.560</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201</th>\n",
       "      <td>BEL</td>\n",
       "      <td>CZE</td>\n",
       "      <td>0101</td>\n",
       "      <td>M</td>\n",
       "      <td>2013</td>\n",
       "      <td>40.533</td>\n",
       "      <td>2.254</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>BEL</td>\n",
       "      <td>DEU</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>3158.830</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>BEL</td>\n",
       "      <td>DEU</td>\n",
       "      <td>0101</td>\n",
       "      <td>M</td>\n",
       "      <td>2013</td>\n",
       "      <td>6989.043</td>\n",
       "      <td>130.203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204</th>\n",
       "      <td>BEL</td>\n",
       "      <td>DNK</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>639.990</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>205</th>\n",
       "      <td>BEL</td>\n",
       "      <td>DNK</td>\n",
       "      <td>0101</td>\n",
       "      <td>M</td>\n",
       "      <td>2013</td>\n",
       "      <td>968.064</td>\n",
       "      <td>42.017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>BEL</td>\n",
       "      <td>DZA</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>11.127</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>BEL</td>\n",
       "      <td>ECU</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>512.593</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>BEL</td>\n",
       "      <td>EGY</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>1386.680</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>BEL</td>\n",
       "      <td>ESP</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>818.767</td>\n",
       "      <td>0.114</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>BEL</td>\n",
       "      <td>ESP</td>\n",
       "      <td>0101</td>\n",
       "      <td>M</td>\n",
       "      <td>2013</td>\n",
       "      <td>550.689</td>\n",
       "      <td>20.053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>BEL</td>\n",
       "      <td>FIN</td>\n",
       "      <td>0101</td>\n",
       "      <td>M</td>\n",
       "      <td>2013</td>\n",
       "      <td>28.083</td>\n",
       "      <td>1.562</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>BEL</td>\n",
       "      <td>FRA</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>10543.790</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>BEL</td>\n",
       "      <td>FRA</td>\n",
       "      <td>0101</td>\n",
       "      <td>M</td>\n",
       "      <td>2013</td>\n",
       "      <td>7136.350</td>\n",
       "      <td>229.790</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>BEL</td>\n",
       "      <td>GBR</td>\n",
       "      <td>0101</td>\n",
       "      <td>X</td>\n",
       "      <td>2013</td>\n",
       "      <td>3552.310</td>\n",
       "      <td>NaN</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775838</th>\n",
       "      <td>BEL</td>\n",
       "      <td>SVK</td>\n",
       "      <td>5112</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>56.398</td>\n",
       "      <td>1.080</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775839</th>\n",
       "      <td>BEL</td>\n",
       "      <td>SVK</td>\n",
       "      <td>5112</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>0.069</td>\n",
       "      <td>0.001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775840</th>\n",
       "      <td>BEL</td>\n",
       "      <td>SVN</td>\n",
       "      <td>5112</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>0.747</td>\n",
       "      <td>0.014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775841</th>\n",
       "      <td>BEL</td>\n",
       "      <td>SWE</td>\n",
       "      <td>5112</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>84.250</td>\n",
       "      <td>2.072</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775842</th>\n",
       "      <td>BEL</td>\n",
       "      <td>SWE</td>\n",
       "      <td>5112</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>3.187</td>\n",
       "      <td>0.063</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775843</th>\n",
       "      <td>BEL</td>\n",
       "      <td>THA</td>\n",
       "      <td>5112</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>12.359</td>\n",
       "      <td>0.200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775844</th>\n",
       "      <td>BEL</td>\n",
       "      <td>TUN</td>\n",
       "      <td>5112</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>8.487</td>\n",
       "      <td>0.127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775845</th>\n",
       "      <td>BEL</td>\n",
       "      <td>TUR</td>\n",
       "      <td>5112</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>140.273</td>\n",
       "      <td>3.013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775846</th>\n",
       "      <td>BEL</td>\n",
       "      <td>TUR</td>\n",
       "      <td>5112</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>132.266</td>\n",
       "      <td>2.192</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775847</th>\n",
       "      <td>BEL</td>\n",
       "      <td>UKR</td>\n",
       "      <td>5112</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>549.039</td>\n",
       "      <td>12.919</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775848</th>\n",
       "      <td>BEL</td>\n",
       "      <td>UKR</td>\n",
       "      <td>5112</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>0.996</td>\n",
       "      <td>0.009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775849</th>\n",
       "      <td>BEL</td>\n",
       "      <td>USA</td>\n",
       "      <td>5112</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>4137.337</td>\n",
       "      <td>87.119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775850</th>\n",
       "      <td>BEL</td>\n",
       "      <td>USA</td>\n",
       "      <td>5112</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>21.094</td>\n",
       "      <td>0.399</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775851</th>\n",
       "      <td>BEL</td>\n",
       "      <td>VNM</td>\n",
       "      <td>5112</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>63.885</td>\n",
       "      <td>1.377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775852</th>\n",
       "      <td>BEL</td>\n",
       "      <td>ZAF</td>\n",
       "      <td>5112</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>26.283</td>\n",
       "      <td>0.580</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779216</th>\n",
       "      <td>BEL</td>\n",
       "      <td>CHE</td>\n",
       "      <td>5113</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>1.018</td>\n",
       "      <td>0.079</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779217</th>\n",
       "      <td>BEL</td>\n",
       "      <td>CHN</td>\n",
       "      <td>5113</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>2.120</td>\n",
       "      <td>0.164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779218</th>\n",
       "      <td>BEL</td>\n",
       "      <td>COD</td>\n",
       "      <td>5113</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>0.124</td>\n",
       "      <td>0.008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779219</th>\n",
       "      <td>BEL</td>\n",
       "      <td>DEU</td>\n",
       "      <td>5113</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>0.098</td>\n",
       "      <td>0.006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779220</th>\n",
       "      <td>BEL</td>\n",
       "      <td>DEU</td>\n",
       "      <td>5113</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>4.023</td>\n",
       "      <td>0.312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779221</th>\n",
       "      <td>BEL</td>\n",
       "      <td>ESP</td>\n",
       "      <td>5113</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>0.647</td>\n",
       "      <td>0.041</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779222</th>\n",
       "      <td>BEL</td>\n",
       "      <td>FRA</td>\n",
       "      <td>5113</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>33.280</td>\n",
       "      <td>2.116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779223</th>\n",
       "      <td>BEL</td>\n",
       "      <td>FRA</td>\n",
       "      <td>5113</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>1.456</td>\n",
       "      <td>0.113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779224</th>\n",
       "      <td>BEL</td>\n",
       "      <td>HKG</td>\n",
       "      <td>5113</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>8.333</td>\n",
       "      <td>0.530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779225</th>\n",
       "      <td>BEL</td>\n",
       "      <td>IND</td>\n",
       "      <td>5113</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>0.626</td>\n",
       "      <td>0.048</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779226</th>\n",
       "      <td>BEL</td>\n",
       "      <td>ITA</td>\n",
       "      <td>5113</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>8.176</td>\n",
       "      <td>0.633</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779227</th>\n",
       "      <td>BEL</td>\n",
       "      <td>NLD</td>\n",
       "      <td>5113</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>0.034</td>\n",
       "      <td>0.002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779228</th>\n",
       "      <td>BEL</td>\n",
       "      <td>NLD</td>\n",
       "      <td>5113</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>3.260</td>\n",
       "      <td>0.253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779229</th>\n",
       "      <td>BEL</td>\n",
       "      <td>PRT</td>\n",
       "      <td>5113</td>\n",
       "      <td>X</td>\n",
       "      <td>2015</td>\n",
       "      <td>0.061</td>\n",
       "      <td>0.004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779230</th>\n",
       "      <td>BEL</td>\n",
       "      <td>TUR</td>\n",
       "      <td>5113</td>\n",
       "      <td>M</td>\n",
       "      <td>2015</td>\n",
       "      <td>0.058</td>\n",
       "      <td>0.005</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>52982 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       REPORTER [ISO 3 LETTER] PARTNER [ISO 3 LETTER] HS4 [4 digit]  \\\n",
       "185                        BEL                    ARE          0101   \n",
       "186                        BEL                    ARE          0101   \n",
       "187                        BEL                    ARG          0101   \n",
       "188                        BEL                    AUT          0101   \n",
       "189                        BEL                    BHR          0101   \n",
       "190                        BEL                    BOL          0101   \n",
       "191                        BEL                    BRA          0101   \n",
       "192                        BEL                    BWA          0101   \n",
       "193                        BEL                    CAN          0101   \n",
       "194                        BEL                    CAN          0101   \n",
       "195                        BEL                    CHE          0101   \n",
       "196                        BEL                    CHE          0101   \n",
       "197                        BEL                    CHL          0101   \n",
       "198                        BEL                    CHN          0101   \n",
       "199                        BEL                    COD          0101   \n",
       "200                        BEL                    COL          0101   \n",
       "201                        BEL                    CZE          0101   \n",
       "202                        BEL                    DEU          0101   \n",
       "203                        BEL                    DEU          0101   \n",
       "204                        BEL                    DNK          0101   \n",
       "205                        BEL                    DNK          0101   \n",
       "206                        BEL                    DZA          0101   \n",
       "207                        BEL                    ECU          0101   \n",
       "208                        BEL                    EGY          0101   \n",
       "209                        BEL                    ESP          0101   \n",
       "210                        BEL                    ESP          0101   \n",
       "211                        BEL                    FIN          0101   \n",
       "212                        BEL                    FRA          0101   \n",
       "213                        BEL                    FRA          0101   \n",
       "214                        BEL                    GBR          0101   \n",
       "...                        ...                    ...           ...   \n",
       "775838                     BEL                    SVK          5112   \n",
       "775839                     BEL                    SVK          5112   \n",
       "775840                     BEL                    SVN          5112   \n",
       "775841                     BEL                    SWE          5112   \n",
       "775842                     BEL                    SWE          5112   \n",
       "775843                     BEL                    THA          5112   \n",
       "775844                     BEL                    TUN          5112   \n",
       "775845                     BEL                    TUR          5112   \n",
       "775846                     BEL                    TUR          5112   \n",
       "775847                     BEL                    UKR          5112   \n",
       "775848                     BEL                    UKR          5112   \n",
       "775849                     BEL                    USA          5112   \n",
       "775850                     BEL                    USA          5112   \n",
       "775851                     BEL                    VNM          5112   \n",
       "775852                     BEL                    ZAF          5112   \n",
       "779216                     BEL                    CHE          5113   \n",
       "779217                     BEL                    CHN          5113   \n",
       "779218                     BEL                    COD          5113   \n",
       "779219                     BEL                    DEU          5113   \n",
       "779220                     BEL                    DEU          5113   \n",
       "779221                     BEL                    ESP          5113   \n",
       "779222                     BEL                    FRA          5113   \n",
       "779223                     BEL                    FRA          5113   \n",
       "779224                     BEL                    HKG          5113   \n",
       "779225                     BEL                    IND          5113   \n",
       "779226                     BEL                    ITA          5113   \n",
       "779227                     BEL                    NLD          5113   \n",
       "779228                     BEL                    NLD          5113   \n",
       "779229                     BEL                    PRT          5113   \n",
       "779230                     BEL                    TUR          5113   \n",
       "\n",
       "       FLOWS (X or M)  YEAR  VALUE (1000USD)  VOLUME (M Tons)  \n",
       "185                 X  2013          407.566              NaN  \n",
       "186                 M  2013            7.303            0.406  \n",
       "187                 X  2013           82.055              NaN  \n",
       "188                 X  2013           37.585              NaN  \n",
       "189                 X  2013           20.713              NaN  \n",
       "190                 X  2013            6.420              NaN  \n",
       "191                 X  2013         9196.386              NaN  \n",
       "192                 X  2013          172.872              NaN  \n",
       "193                 X  2013         2469.010              NaN  \n",
       "194                 M  2013           13.279            0.739  \n",
       "195                 X  2013         9651.890              NaN  \n",
       "196                 M  2013          619.848           10.588  \n",
       "197                 X  2013          498.003              NaN  \n",
       "198                 X  2013          223.061              NaN  \n",
       "199                 X  2013           22.704              NaN  \n",
       "200                 X  2013         1738.560              NaN  \n",
       "201                 M  2013           40.533            2.254  \n",
       "202                 X  2013         3158.830              NaN  \n",
       "203                 M  2013         6989.043          130.203  \n",
       "204                 X  2013          639.990              NaN  \n",
       "205                 M  2013          968.064           42.017  \n",
       "206                 X  2013           11.127              NaN  \n",
       "207                 X  2013          512.593              NaN  \n",
       "208                 X  2013         1386.680              NaN  \n",
       "209                 X  2013          818.767            0.114  \n",
       "210                 M  2013          550.689           20.053  \n",
       "211                 M  2013           28.083            1.562  \n",
       "212                 X  2013        10543.790              NaN  \n",
       "213                 M  2013         7136.350          229.790  \n",
       "214                 X  2013         3552.310              NaN  \n",
       "...               ...   ...              ...              ...  \n",
       "775838              X  2015           56.398            1.080  \n",
       "775839              M  2015            0.069            0.001  \n",
       "775840              X  2015            0.747            0.014  \n",
       "775841              X  2015           84.250            2.072  \n",
       "775842              M  2015            3.187            0.063  \n",
       "775843              X  2015           12.359            0.200  \n",
       "775844              X  2015            8.487            0.127  \n",
       "775845              X  2015          140.273            3.013  \n",
       "775846              M  2015          132.266            2.192  \n",
       "775847              X  2015          549.039           12.919  \n",
       "775848              M  2015            0.996            0.009  \n",
       "775849              X  2015         4137.337           87.119  \n",
       "775850              M  2015           21.094            0.399  \n",
       "775851              X  2015           63.885            1.377  \n",
       "775852              X  2015           26.283            0.580  \n",
       "779216              M  2015            1.018            0.079  \n",
       "779217              M  2015            2.120            0.164  \n",
       "779218              X  2015            0.124            0.008  \n",
       "779219              X  2015            0.098            0.006  \n",
       "779220              M  2015            4.023            0.312  \n",
       "779221              X  2015            0.647            0.041  \n",
       "779222              X  2015           33.280            2.116  \n",
       "779223              M  2015            1.456            0.113  \n",
       "779224              X  2015            8.333            0.530  \n",
       "779225              M  2015            0.626            0.048  \n",
       "779226              M  2015            8.176            0.633  \n",
       "779227              X  2015            0.034            0.002  \n",
       "779228              M  2015            3.260            0.253  \n",
       "779229              X  2015            0.061            0.004  \n",
       "779230              M  2015            0.058            0.005  \n",
       "\n",
       "[52982 rows x 7 columns]"
      ]
     },
     "execution_count": 107,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "outfile[outfile[\"REPORTER [ISO 3 LETTER]\"]==\"BEL\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 155,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['0101', '0102', '0103', '0104', '0105', '0106', '0201', '0202',\n",
       "       '0203', '0204', '0205', '0206', '0207', '0208', '0209', '0210',\n",
       "       '0301', '0302', '0303', '0304', '0305', '0306', '0307', '0308',\n",
       "       '0401', '0402', '0403', '0404', '0405', '0406', '0407', '0408',\n",
       "       '0409', '0410', '0501', '0502', '0503', '0504', '0505', '0506',\n",
       "       '0507', '0508', '0509', '0510', '0511', '0601', '0602', '0603',\n",
       "       '0604', '0701', '0702', '0703', '0704', '0705', '0706', '0707',\n",
       "       '0708', '0709', '0710', '0711', '0712', '0713', '0714', '0801',\n",
       "       '0802', '0803', '0804', '0805', '0806', '0807', '0808', '0809',\n",
       "       '0810', '0811', '0812', '0813', '0814', '0901', '0902', '0903',\n",
       "       '0904', '0905', '0906', '0907', '0908', '0909', '0910', '1001',\n",
       "       '1002', '1003', '1004', '1005', '1006', '1007', '1008', '1101',\n",
       "       '1102', '1103', '1104', '1105', '1106', '1107', '1108', '1109',\n",
       "       '1201', '1202', '1203', '1204', '1205', '1206', '1207', '1208',\n",
       "       '1209', '1210', '1211', '1212', '1213', '1214', '1301', '1302',\n",
       "       '1401', '1402', '1403', '1404', '1501', '1502', '1503', '1504',\n",
       "       '1505', '1506', '1507', '1508', '1509', '1510', '1511', '1512',\n",
       "       '1513', '1514', '1515', '1516', '1517', '1518', '1520', '1521',\n",
       "       '1522', '1601', '1602', '1603', '1604', '1605', '1701', '1702',\n",
       "       '1703', '1704', '1801', '1802', '1803', '1804', '1805', '1806',\n",
       "       '1901', '1902', '1903', '1904', '1905', '2001', '2002', '2003',\n",
       "       '2004', '2005', '2006', '2007', '2008', '2009', '2101', '2102',\n",
       "       '2103', '2104', '2105', '2106', '2201', '2202', '2203', '2204',\n",
       "       '2205', '2206', '2207', '2208', '2209', '2301', '2302', '2303',\n",
       "       '2304', '2305', '2306', '2307', '2308', '2309', '2401', '2402',\n",
       "       '2403', '5001', '5002', '5003', '5004', '5005', '5006', '5007',\n",
       "       '5101', '5102', '5103', '5104', '5105', '5106', '5107', '5108',\n",
       "       '5109', '5110', '5111', '5112', '5113'], dtype=object)"
      ]
     },
     "execution_count": 155,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "outfile[\"HS4 [4 digit]\"].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "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.5.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}