{ "cells": [ { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": true }, "outputs": [], "source": [ "import warnings\n", "warnings.simplefilter('ignore', FutureWarning)\n", "\n", "from pandas import *" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
ABCD
0fooonesmall1
1fooonelarge2
2fooonelarge2
3footwosmall3
4footwosmall3
\n", "
" ], "text/plain": [ " A B C D\n", "0 foo one small 1\n", "1 foo one large 2\n", "2 foo one large 2\n", "3 foo two small 3\n", "4 foo two small 3" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "data=[['foo','one','small',1],\n", " ['foo','one','large',2],\n", " ['foo','one','large',2],\n", " ['foo','two','small',3],\n", " ['foo','two','small',3],\n", " ['bar','one','large',4],\n", " ['bar','one','small',5],\n", " ['bar','two','small',6],\n", " ['foo','one','large',2],\n", " ['foo','one','large',2],\n", " ['foo','two','small',3],\n", " ['foo','two','small',3],\n", " ['bar','one','large',4],\n", " ['bar','one','small',5],\n", " ['foo','one','large',2],\n", " ['foo','one','large',2],\n", " ['foo','two','small',3],\n", " ['foo','two','small',3],\n", " ['bar','one','large',4],\n", " ['bar','one','small',5],\n", " ['bar','two','small',6],\n", " ['bar','two','small',6],\n", " ['bar','two','large',7]]\n", "\n", "df=DataFrame(data=data, columns=['A','B','C','D'])\n", "\n", "df.head()" ] }, { "cell_type": "code", "execution_count": 7, "metadata": { "collapsed": true }, "outputs": [], "source": [ "LOCATION='comtrade_milk_uk_monthly_14.csv'" ] }, { "cell_type": "code", "execution_count": 8, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
ClassificationYearPeriodPeriod Desc.Aggregate LevelIs Leaf CodeTrade Flow CodeTrade FlowReporter CodeReporter...QtyAlt Qty Unit CodeAlt Qty UnitAlt QtyNetweight (kg)Gross weight (kg)Trade Value (US$)CIF Trade Value (US$)FOB Trade Value (US$)Flag
0HS2014201401January 2014401Imports826United Kingdom...NaNNaNNaNNaN22404316NaN21950747NaNNaN0
1HS2014201401January 2014402Exports826United Kingdom...NaNNaNNaNNaN60497363NaN46923551NaNNaN0
2HS2014201401January 2014402Exports826United Kingdom...NaNNaNNaNNaN2520NaN3410NaNNaN0
\n", "

3 rows × 35 columns

\n", "
" ], "text/plain": [ " Classification Year Period Period Desc. Aggregate Level Is Leaf Code \\\n", "0 HS 2014 201401 January 2014 4 0 \n", "1 HS 2014 201401 January 2014 4 0 \n", "2 HS 2014 201401 January 2014 4 0 \n", "\n", " Trade Flow Code Trade Flow Reporter Code Reporter ... Qty \\\n", "0 1 Imports 826 United Kingdom ... NaN \n", "1 2 Exports 826 United Kingdom ... NaN \n", "2 2 Exports 826 United Kingdom ... NaN \n", "\n", " Alt Qty Unit Code Alt Qty Unit Alt Qty Netweight (kg) Gross weight (kg) \\\n", "0 NaN NaN NaN 22404316 NaN \n", "1 NaN NaN NaN 60497363 NaN \n", "2 NaN NaN NaN 2520 NaN \n", "\n", " Trade Value (US$) CIF Trade Value (US$) FOB Trade Value (US$) Flag \n", "0 21950747 NaN NaN 0 \n", "1 46923551 NaN NaN 0 \n", "2 3410 NaN NaN 0 \n", "\n", "[3 rows x 35 columns]" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "milk = read_csv(LOCATION, dtype={'Commodity Code':str, 'Reporter Code':str})\n", "milk.head(3)" ] }, { "cell_type": "code", "execution_count": 10, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
YearPeriodTrade FlowReporterPartnerCommodityCommodity CodeTrade Value (US$)
02014201401ImportsUnited KingdomWorldMilk and cream, neither concentrated nor sweet...040121950747
12014201401ExportsUnited KingdomWorldMilk and cream, neither concentrated nor sweet...040146923551
22014201401ExportsUnited KingdomAfghanistanMilk and cream, neither concentrated nor sweet...04013410
32014201401ExportsUnited KingdomAustriaMilk and cream, neither concentrated nor sweet...0401316
42014201401ImportsUnited KingdomBelgiumMilk and cream, neither concentrated nor sweet...04014472349
\n", "
" ], "text/plain": [ " Year Period Trade Flow Reporter Partner \\\n", "0 2014 201401 Imports United Kingdom World \n", "1 2014 201401 Exports United Kingdom World \n", "2 2014 201401 Exports United Kingdom Afghanistan \n", "3 2014 201401 Exports United Kingdom Austria \n", "4 2014 201401 Imports United Kingdom Belgium \n", "\n", " Commodity Commodity Code \\\n", "0 Milk and cream, neither concentrated nor sweet... 0401 \n", "1 Milk and cream, neither concentrated nor sweet... 0401 \n", "2 Milk and cream, neither concentrated nor sweet... 0401 \n", "3 Milk and cream, neither concentrated nor sweet... 0401 \n", "4 Milk and cream, neither concentrated nor sweet... 0401 \n", "\n", " Trade Value (US$) \n", "0 21950747 \n", "1 46923551 \n", "2 3410 \n", "3 316 \n", "4 4472349 " ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" } ], "source": [ "COLUMNS = ['Year', 'Period','Trade Flow','Reporter', 'Partner', 'Commodity','Commodity Code','Trade Value (US$)']\n", "milk = milk[COLUMNS]\n", "milk.head()" ] }, { "cell_type": "code", "execution_count": 11, "metadata": { "collapsed": true }, "outputs": [], "source": [ "milk_world = milk[milk['Partner'] == 'World']\n", "milk_countries = milk[milk['Partner'] != 'World']\n", "#milk_world.head()\n", "#milk_countries.head()" ] }, { "cell_type": "code", "execution_count": 15, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
YearPeriodTrade FlowReporterPartnerCommodityCommodity CodeTrade Value (US$)
22014201401ExportsUnited KingdomAfghanistanMilk and cream, neither concentrated nor sweet...04013410
32014201401ExportsUnited KingdomAustriaMilk and cream, neither concentrated nor sweet...0401316
42014201401ImportsUnited KingdomBelgiumMilk and cream, neither concentrated nor sweet...04014472349
52014201401ExportsUnited KingdomBelgiumMilk and cream, neither concentrated nor sweet...04015663128
62014201401ExportsUnited KingdomBr. Virgin IsdsMilk and cream, neither concentrated nor sweet...040134566
72014201401ExportsUnited KingdomCanadaMilk and cream, neither concentrated nor sweet...040151017
82014201401ExportsUnited KingdomChinaMilk and cream, neither concentrated nor sweet...0401265039
92014201401ExportsUnited KingdomCyprusMilk and cream, neither concentrated nor sweet...040118738
102014201401ImportsUnited KingdomDenmarkMilk and cream, neither concentrated nor sweet...04012233438
112014201401ExportsUnited KingdomDenmarkMilk and cream, neither concentrated nor sweet...0401417
122014201401ExportsUnited KingdomEquatorial GuineaMilk and cream, neither concentrated nor sweet...04013201
132014201401ExportsUnited KingdomFalkland Isds (Malvinas)Milk and cream, neither concentrated nor sweet...040126614
142014201401ExportsUnited KingdomFinlandMilk and cream, neither concentrated nor sweet...0401141697
152014201401ImportsUnited KingdomFranceMilk and cream, neither concentrated nor sweet...04011522872
162014201401ExportsUnited KingdomFranceMilk and cream, neither concentrated nor sweet...04012919079
172014201401ImportsUnited KingdomGermanyMilk and cream, neither concentrated nor sweet...04011028700
182014201401ExportsUnited KingdomGermanyMilk and cream, neither concentrated nor sweet...0401982240
192014201401ExportsUnited KingdomGibraltarMilk and cream, neither concentrated nor sweet...040111079
202014201401ExportsUnited KingdomGreeceMilk and cream, neither concentrated nor sweet...040120
212014201401ExportsUnited KingdomChina, Hong Kong SARMilk and cream, neither concentrated nor sweet...0401295201
222014201401ExportsUnited KingdomHungaryMilk and cream, neither concentrated nor sweet...04014735
232014201401ImportsUnited KingdomIrelandMilk and cream, neither concentrated nor sweet...040110676138
242014201401ExportsUnited KingdomIrelandMilk and cream, neither concentrated nor sweet...040132069689
252014201401ImportsUnited KingdomItalyMilk and cream, neither concentrated nor sweet...04014685
262014201401ExportsUnited KingdomItalyMilk and cream, neither concentrated nor sweet...0401947
272014201401ExportsUnited KingdomRep. of KoreaMilk and cream, neither concentrated nor sweet...04012825
282014201401ImportsUnited KingdomLithuaniaMilk and cream, neither concentrated nor sweet...04015629
292014201401ExportsUnited KingdomLuxembourgMilk and cream, neither concentrated nor sweet...040126
302014201401ExportsUnited KingdomMaltaMilk and cream, neither concentrated nor sweet...04019748
312014201401ExportsUnited KingdomOther Asia, nesMilk and cream, neither concentrated nor sweet...04014372
...........................
13072014201410ExportsUnited KingdomPhilippinesMilk and cream, concentrated or sweetened040279761
13352014201411ExportsUnited KingdomAustraliaMilk and cream, concentrated or sweetened04022639
13362014201411ImportsUnited KingdomAustriaMilk and cream, concentrated or sweetened0402144989
13382014201411ExportsUnited KingdomBangladeshMilk and cream, concentrated or sweetened0402701736
13412014201411ExportsUnited KingdomCameroonMilk and cream, concentrated or sweetened0402177395
13442014201411ExportsUnited KingdomCubaMilk and cream, concentrated or sweetened0402933206
13502014201411ExportsUnited KingdomDominicaMilk and cream, concentrated or sweetened040248359
13512014201411ExportsUnited KingdomDominican Rep.Milk and cream, concentrated or sweetened0402233666
13562014201411ExportsUnited KingdomGabonMilk and cream, concentrated or sweetened040250748
13572014201411ExportsUnited KingdomGambiaMilk and cream, concentrated or sweetened040211985
13602014201411ExportsUnited KingdomGhanaMilk and cream, concentrated or sweetened040290701
13622014201411ExportsUnited KingdomGuatemalaMilk and cream, concentrated or sweetened040263056
13722014201411ExportsUnited KingdomJordanMilk and cream, concentrated or sweetened04024354
13732014201411ExportsUnited KingdomKenyaMilk and cream, concentrated or sweetened040266726
13762014201411ExportsUnited KingdomLatviaMilk and cream, concentrated or sweetened040235
13802014201411ExportsUnited KingdomMexicoMilk and cream, concentrated or sweetened0402746926
13892014201411ExportsUnited KingdomSaint Kitts and NevisMilk and cream, concentrated or sweetened04023392
13902014201411ExportsUnited KingdomSaint LuciaMilk and cream, concentrated or sweetened040264440
13942014201411ExportsUnited KingdomSlovakiaMilk and cream, concentrated or sweetened040268
14112014201412ExportsUnited KingdomBangladeshMilk and cream, concentrated or sweetened040295797
14142014201412ExportsUnited KingdomMyanmarMilk and cream, concentrated or sweetened04026236
14152014201412ExportsUnited KingdomCameroonMilk and cream, concentrated or sweetened0402170651
14202014201412ExportsUnited KingdomCubaMilk and cream, concentrated or sweetened04021916244
14242014201412ExportsUnited KingdomDominican Rep.Milk and cream, concentrated or sweetened0402363535
14272014201412ExportsUnited KingdomGabonMilk and cream, concentrated or sweetened040268886
14312014201412ExportsUnited KingdomGuatemalaMilk and cream, concentrated or sweetened040264268
14492014201412ExportsUnited KingdomMauritaniaMilk and cream, concentrated or sweetened0402116367
14512014201412ExportsUnited KingdomNamibiaMilk and cream, concentrated or sweetened0402256335
14542014201412ExportsUnited KingdomNigerMilk and cream, concentrated or sweetened040284543
14562014201412ExportsUnited KingdomPakistanMilk and cream, concentrated or sweetened040257483
\n", "

601 rows × 8 columns

\n", "
" ], "text/plain": [ " Year Period Trade Flow Reporter Partner \\\n", "2 2014 201401 Exports United Kingdom Afghanistan \n", "3 2014 201401 Exports United Kingdom Austria \n", "4 2014 201401 Imports United Kingdom Belgium \n", "5 2014 201401 Exports United Kingdom Belgium \n", "6 2014 201401 Exports United Kingdom Br. Virgin Isds \n", "7 2014 201401 Exports United Kingdom Canada \n", "8 2014 201401 Exports United Kingdom China \n", "9 2014 201401 Exports United Kingdom Cyprus \n", "10 2014 201401 Imports United Kingdom Denmark \n", "11 2014 201401 Exports United Kingdom Denmark \n", "12 2014 201401 Exports United Kingdom Equatorial Guinea \n", "13 2014 201401 Exports United Kingdom Falkland Isds (Malvinas) \n", "14 2014 201401 Exports United Kingdom Finland \n", "15 2014 201401 Imports United Kingdom France \n", "16 2014 201401 Exports United Kingdom France \n", "17 2014 201401 Imports United Kingdom Germany \n", "18 2014 201401 Exports United Kingdom Germany \n", "19 2014 201401 Exports United Kingdom Gibraltar \n", "20 2014 201401 Exports United Kingdom Greece \n", "21 2014 201401 Exports United Kingdom China, Hong Kong SAR \n", "22 2014 201401 Exports United Kingdom Hungary \n", "23 2014 201401 Imports United Kingdom Ireland \n", "24 2014 201401 Exports United Kingdom Ireland \n", "25 2014 201401 Imports United Kingdom Italy \n", "26 2014 201401 Exports United Kingdom Italy \n", "27 2014 201401 Exports United Kingdom Rep. of Korea \n", "28 2014 201401 Imports United Kingdom Lithuania \n", "29 2014 201401 Exports United Kingdom Luxembourg \n", "30 2014 201401 Exports United Kingdom Malta \n", "31 2014 201401 Exports United Kingdom Other Asia, nes \n", "... ... ... ... ... ... \n", "1307 2014 201410 Exports United Kingdom Philippines \n", "1335 2014 201411 Exports United Kingdom Australia \n", "1336 2014 201411 Imports United Kingdom Austria \n", "1338 2014 201411 Exports United Kingdom Bangladesh \n", "1341 2014 201411 Exports United Kingdom Cameroon \n", "1344 2014 201411 Exports United Kingdom Cuba \n", "1350 2014 201411 Exports United Kingdom Dominica \n", "1351 2014 201411 Exports United Kingdom Dominican Rep. \n", "1356 2014 201411 Exports United Kingdom Gabon \n", "1357 2014 201411 Exports United Kingdom Gambia \n", "1360 2014 201411 Exports United Kingdom Ghana \n", "1362 2014 201411 Exports United Kingdom Guatemala \n", "1372 2014 201411 Exports United Kingdom Jordan \n", "1373 2014 201411 Exports United Kingdom Kenya \n", "1376 2014 201411 Exports United Kingdom Latvia \n", "1380 2014 201411 Exports United Kingdom Mexico \n", "1389 2014 201411 Exports United Kingdom Saint Kitts and Nevis \n", "1390 2014 201411 Exports United Kingdom Saint Lucia \n", "1394 2014 201411 Exports United Kingdom Slovakia \n", "1411 2014 201412 Exports United Kingdom Bangladesh \n", "1414 2014 201412 Exports United Kingdom Myanmar \n", "1415 2014 201412 Exports United Kingdom Cameroon \n", "1420 2014 201412 Exports United Kingdom Cuba \n", "1424 2014 201412 Exports United Kingdom Dominican Rep. \n", "1427 2014 201412 Exports United Kingdom Gabon \n", "1431 2014 201412 Exports United Kingdom Guatemala \n", "1449 2014 201412 Exports United Kingdom Mauritania \n", "1451 2014 201412 Exports United Kingdom Namibia \n", "1454 2014 201412 Exports United Kingdom Niger \n", "1456 2014 201412 Exports United Kingdom Pakistan \n", "\n", " Commodity Commodity Code \\\n", "2 Milk and cream, neither concentrated nor sweet... 0401 \n", "3 Milk and cream, neither concentrated nor sweet... 0401 \n", "4 Milk and cream, neither concentrated nor sweet... 0401 \n", "5 Milk and cream, neither concentrated nor sweet... 0401 \n", "6 Milk and cream, neither concentrated nor sweet... 0401 \n", "7 Milk and cream, neither concentrated nor sweet... 0401 \n", "8 Milk and cream, neither concentrated nor sweet... 0401 \n", "9 Milk and cream, neither concentrated nor sweet... 0401 \n", "10 Milk and cream, neither concentrated nor sweet... 0401 \n", "11 Milk and cream, neither concentrated nor sweet... 0401 \n", "12 Milk and cream, neither concentrated nor sweet... 0401 \n", "13 Milk and cream, neither concentrated nor sweet... 0401 \n", "14 Milk and cream, neither concentrated nor sweet... 0401 \n", "15 Milk and cream, neither concentrated nor sweet... 0401 \n", "16 Milk and cream, neither concentrated nor sweet... 0401 \n", "17 Milk and cream, neither concentrated nor sweet... 0401 \n", "18 Milk and cream, neither concentrated nor sweet... 0401 \n", "19 Milk and cream, neither concentrated nor sweet... 0401 \n", "20 Milk and cream, neither concentrated nor sweet... 0401 \n", "21 Milk and cream, neither concentrated nor sweet... 0401 \n", "22 Milk and cream, neither concentrated nor sweet... 0401 \n", "23 Milk and cream, neither concentrated nor sweet... 0401 \n", "24 Milk and cream, neither concentrated nor sweet... 0401 \n", "25 Milk and cream, neither concentrated nor sweet... 0401 \n", "26 Milk and cream, neither concentrated nor sweet... 0401 \n", "27 Milk and cream, neither concentrated nor sweet... 0401 \n", "28 Milk and cream, neither concentrated nor sweet... 0401 \n", "29 Milk and cream, neither concentrated nor sweet... 0401 \n", "30 Milk and cream, neither concentrated nor sweet... 0401 \n", "31 Milk and cream, neither concentrated nor sweet... 0401 \n", "... ... ... \n", "1307 Milk and cream, concentrated or sweetened 0402 \n", "1335 Milk and cream, concentrated or sweetened 0402 \n", "1336 Milk and cream, concentrated or sweetened 0402 \n", "1338 Milk and cream, concentrated or sweetened 0402 \n", "1341 Milk and cream, concentrated or sweetened 0402 \n", "1344 Milk and cream, concentrated or sweetened 0402 \n", "1350 Milk and cream, concentrated or sweetened 0402 \n", "1351 Milk and cream, concentrated or sweetened 0402 \n", "1356 Milk and cream, concentrated or sweetened 0402 \n", "1357 Milk and cream, concentrated or sweetened 0402 \n", "1360 Milk and cream, concentrated or sweetened 0402 \n", "1362 Milk and cream, concentrated or sweetened 0402 \n", "1372 Milk and cream, concentrated or sweetened 0402 \n", "1373 Milk and cream, concentrated or sweetened 0402 \n", "1376 Milk and cream, concentrated or sweetened 0402 \n", "1380 Milk and cream, concentrated or sweetened 0402 \n", "1389 Milk and cream, concentrated or sweetened 0402 \n", "1390 Milk and cream, concentrated or sweetened 0402 \n", "1394 Milk and cream, concentrated or sweetened 0402 \n", "1411 Milk and cream, concentrated or sweetened 0402 \n", "1414 Milk and cream, concentrated or sweetened 0402 \n", "1415 Milk and cream, concentrated or sweetened 0402 \n", "1420 Milk and cream, concentrated or sweetened 0402 \n", "1424 Milk and cream, concentrated or sweetened 0402 \n", "1427 Milk and cream, concentrated or sweetened 0402 \n", "1431 Milk and cream, concentrated or sweetened 0402 \n", "1449 Milk and cream, concentrated or sweetened 0402 \n", "1451 Milk and cream, concentrated or sweetened 0402 \n", "1454 Milk and cream, concentrated or sweetened 0402 \n", "1456 Milk and cream, concentrated or sweetened 0402 \n", "\n", " Trade Value (US$) \n", "2 3410 \n", "3 316 \n", "4 4472349 \n", "5 5663128 \n", "6 34566 \n", "7 51017 \n", "8 265039 \n", "9 18738 \n", "10 2233438 \n", "11 417 \n", "12 3201 \n", "13 26614 \n", "14 141697 \n", "15 1522872 \n", "16 2919079 \n", "17 1028700 \n", "18 982240 \n", "19 11079 \n", "20 20 \n", "21 295201 \n", "22 4735 \n", "23 10676138 \n", "24 32069689 \n", "25 4685 \n", "26 947 \n", "27 2825 \n", "28 5629 \n", "29 26 \n", "30 9748 \n", "31 4372 \n", "... ... \n", "1307 79761 \n", "1335 2639 \n", "1336 144989 \n", "1338 701736 \n", "1341 177395 \n", "1344 933206 \n", "1350 48359 \n", "1351 233666 \n", "1356 50748 \n", "1357 11985 \n", "1360 90701 \n", "1362 63056 \n", "1372 4354 \n", "1373 66726 \n", "1376 35 \n", "1380 746926 \n", "1389 3392 \n", "1390 64440 \n", "1394 68 \n", "1411 95797 \n", "1414 6236 \n", "1415 170651 \n", "1420 1916244 \n", "1424 363535 \n", "1427 68886 \n", "1431 64268 \n", "1449 116367 \n", "1451 256335 \n", "1454 84543 \n", "1456 57483 \n", "\n", "[601 rows x 8 columns]" ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#Chris's sandbox\n", "#def weedingOut(g):# TypeError: filter function returned a Series, but expected a scalar bool\n", " # return ((g['Partner']=='Netherlands') & (g['Trade Flow']=='Exports')) #& (g['Period']<201405))\n", "# filter out Partner == 'Netherlands\n", "# filter out == 'Exports\n", "# filter out 'Period' < 201405\n", "milk_countries.head()# head works OK\n", "result = milk_countries.groupby(['Trade Flow','Partner'])#.filter(weedingOut)\n", "#type(result)# pandas.core.groupby.DataFrameGroupBy\n", "result.head()# heade returns full table\n", "#get_option(\"display.max_rows\")" ] }, { "cell_type": "code", "execution_count": 16, "metadata": { "collapsed": true }, "outputs": [], "source": [ "result.head??" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Anaconda (Python 3)", "language": "python", "name": "anaconda3" }, "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.2" } }, "nbformat": 4, "nbformat_minor": 0 }