International Financial Aid (per-capita) [World Bank 1960-2013]

Datasets:

In [1]:
#!pip install conda
#!conda install --yes pandas matplotlib
Requirement already satisfied (use --upgrade to upgrade): conda in /usr/local/lib/python2.7/site-packages
Requirement already satisfied (use --upgrade to upgrade): pycosat in /usr/local/lib/python2.7/site-packages (from conda)
Requirement already satisfied (use --upgrade to upgrade): pyyaml in /usr/local/lib/python2.7/site-packages (from conda)
Requirement already satisfied (use --upgrade to upgrade): requests in /usr/local/lib/python2.7/site-packages (from conda)
Cleaning up...
Fetching package metadata: ..
Solving package specifications: .
# All requested packages already installed.
# packages in environment at /usr/local/Cellar/python/2.7.5/Frameworks/Python.framework/Versions/2.7:
#
matplotlib                1.4.0                np18py27_0
pandas                    0.14.1               np18py27_0
Requirement already satisfied (use --upgrade to upgrade): quandl in /usr/local/lib/python2.7/site-packages
Cleaning up...

In [2]:
import pandas as pd
import matplotlib as mpl
import matplotlib.pyplot as plt
import numpy as np
import json
    
print(pd.__version__, np.__version__)
('0.14.1', '1.8.2')

In [103]:
datadir = "aid_data"

import os
os.path.exists(datadir) or os.makedirs(datadir)

# http://data.worldbank.org/indicator/DT.ODA.ALLD.CD/countries/1W
wb_net_aid_received_zip = os.path.join(datadir, "wb_net_aid_received.zip")
!wget --continue --no-clobber "http://api.worldbank.org/v2/en/indicator/dt.oda.alld.cd?downloadformat=csv" -O $wb_net_aid_received_zip
#!ls -al $datadir
wb_net_aid_received_csv_name = "dt.oda.alld.cd_Indicator_en_csv_v2.csv"
#!ls unzip -l $wb_net_aid_received_csv_name
!unzip -u $wb_net_aid_received_zip "$wb_net_aid_received_csv_name" -d $datadir
#!ls -al $datadir
wb_net_aid_received_csv = os.path.join(datadir, wb_net_aid_received_csv_name)

# http://data.worldbank.org/indicator/SP.POP.TOTL
wb_pop_total_zip = os.path.join(datadir, "wb_pop_total.zip")
!wget --continue --no-clobber "http://api.worldbank.org/v2/en/indicator/sp.pop.totl?downloadformat=csv" -O $wb_pop_total_zip
#!ls -al $datadir
#!unzip -l $wb_pop_total_zip
wb_pop_total_csv_name = "sp.pop.totl_Indicator_en_csv_v2.csv"
!unzip -u $wb_pop_total_zip $wb_pop_total_csv_name -d $datadir
#!ls -al $datadir
wb_pop_total_csv = os.path.join(datadir, wb_pop_total_csv_name)

# http://www.oecd.org/dac/stats/aidtopoorcountriesslipsfurtherasgovernmentstightenbudgets.htm
oecd_aid_statistics_xls = os.path.join(datadir, "oecd_aid_statistics.xls")
!wget --continue --no-clobber "http://www.oecd.org/development/stats/ODA%202012%20Tables%20and%20Charts.xls" -O $oecd_aid_statistics_xls

!ls -al $datadir
File `aid_data/wb_net_aid_received.zip' already there; not retrieving.
caution:  not extracting; -d ignored
Archive:  aid_data/wb_net_aid_received.zip
 Length   Method    Size  Ratio   Date   Time   CRC-32    Name
--------  ------  ------- -----   ----   ----   ------    ----
  152008  Defl:N    40747  73%  08-27-14 01:40  3a7d8b92  dt.oda.alld.cd_Indicator_en_csv_v2.csv
--------          -------  ---                            -------
  152008            40747  73%                            1 file
File `aid_data/wb_pop_total.zip' already there; not retrieving.
caution:  not extracting; -d ignored
Archive:  aid_data/wb_pop_total.zip
 Length   Method    Size  Ratio   Date   Time   CRC-32    Name
--------  ------  ------- -----   ----   ----   ------    ----
  152431  Defl:N    71147  53%  08-27-14 03:02  77d3fb2a  sp.pop.totl_Indicator_en_csv_v2.csv
--------          -------  ---                            -------
  152431            71147  53%                            1 file
File `aid_data/oecd_aid_statistics.xls' already there; not retrieving.
total 1248
drwxr-xr-x   10 W  admin     340 Sep  5 10:42 .
drwx------+ 203 W  admin    6902 Sep  5 11:34 ..
-rw-r--r--    1 W  admin   44676 Aug 27 01:40 Metadata_Country_dt.oda.alld.cd_Indicator_en_csv_v2.csv
-rw-r--r--    1 W  admin    1567 Aug 27 01:40 Metadata_Indicator_dt.oda.alld.cd_Indicator_en_csv_v2.csv
-rw-r--r--    1 W  admin     182 Aug 27 03:02 [Content_Types].xml
-rw-r--r--    1 W  admin  152008 Aug 27 01:40 dt.oda.alld.cd_Indicator_en_csv_v2.csv
-rw-r--r--    1 W  admin  135168 Jul  4 18:59 oecd_aid_statistics.xls
-rw-r--r--    1 W  admin  152431 Aug 27 03:02 sp.pop.totl_Indicator_en_csv_v2.csv
-rw-r--r--    1 W  admin   53023 Sep  5 10:33 wb_net_aid_received.zip
-rw-r--r--    1 W  admin   83148 Sep  5 10:33 wb_pop_total.zip

In [104]:
df_net_aid = pd.read_csv(wb_net_aid_received_csv, header=2)
df_net_aid
Out[104]:
Country Name Country Code Indicator Name Indicator Code 1960 1961 1962 1963 1964 1965 ... 2005 2006 2007 2008 2009 2010 2011 2012 2013 Unnamed: 58
0 Aruba ABW Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
1 Andorra AND Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
2 Afghanistan AFG Net official development assistance and offici... DT.ODA.ALLD.CD 17180000 34670000 16930000 36670000 46170000 53930000 ... 2.837620e+09 2.961670e+09 4.964720e+09 4.875070e+09 6.235260e+09 6.426380e+09 6.884700e+09 6.725030e+09 NaN NaN
3 Angola AGO Net official development assistance and offici... DT.ODA.ALLD.CD -50000 23550000 NaN 30000 NaN 1110000 ... 4.145700e+08 1.635200e+08 2.476700e+08 3.688200e+08 2.387100e+08 2.382300e+08 1.942500e+08 2.423500e+08 NaN NaN
4 Albania ALB Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 3.191400e+08 3.217800e+08 3.071900e+08 3.632700e+08 3.569600e+08 3.407000e+08 3.507500e+08 3.416200e+08 NaN NaN
5 Andean Region ANR Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
6 Arab World ARB Net official development assistance and offici... DT.ODA.ALLD.CD 881990000 973930000 929090000 858610000 831420000 666060000 ... 2.927589e+10 1.755314e+10 1.905781e+10 2.275868e+10 1.424822e+10 1.236550e+10 1.303252e+10 1.495131e+10 0 NaN
7 United Arab Emirates ARE Net official development assistance and offici... DT.ODA.ALLD.CD 410000 540000 430000 390000 580000 20000 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
8 Argentina ARG Net official development assistance and offici... DT.ODA.ALLD.CD 28580000 29180000 39800000 37800000 17220000 -62200000 ... 9.618000e+07 1.150800e+08 1.013400e+08 1.305800e+08 1.267300e+08 1.211200e+08 8.696000e+07 1.789200e+08 NaN NaN
9 Armenia ARM Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 1.703400e+08 2.155100e+08 3.500200e+08 3.026300e+08 5.259700e+08 3.428200e+08 4.001000e+08 2.727700e+08 NaN NaN
10 American Samoa ASM Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
11 Antigua and Barbuda ATG Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 7.790000e+06 3.280000e+06 7.380000e+06 8.750000e+06 5.640000e+06 1.907000e+07 1.533000e+07 2.350000e+06 NaN NaN
12 Australia AUS Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
13 Austria AUT Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
14 Azerbaijan AZE Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 2.165100e+08 2.063900e+08 2.252100e+08 2.351000e+08 2.317700e+08 1.591100e+08 2.864100e+08 3.376100e+08 NaN NaN
15 Burundi BDI Net official development assistance and offici... DT.ODA.ALLD.CD 7530000 7190000 11070000 6160000 8090000 4860000 ... 3.639600e+08 4.308900e+08 4.790000e+08 5.222400e+08 5.613700e+08 6.299400e+08 5.748500e+08 5.227400e+08 NaN NaN
16 Belgium BEL Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
17 Benin BEN Net official development assistance and offici... DT.ODA.ALLD.CD 20000 1480000 3750000 4260000 18070000 17880000 ... 3.469300e+08 3.993200e+08 4.743700e+08 6.414800e+08 6.820600e+08 6.891100e+08 6.902900e+08 5.113300e+08 NaN NaN
18 Burkina Faso BFA Net official development assistance and offici... DT.ODA.ALLD.CD 200000 1350000 4430000 4140000 15400000 17270000 ... 6.933700e+08 9.014800e+08 9.504000e+08 1.001160e+09 1.082820e+09 1.062340e+09 9.951200e+08 1.158540e+09 NaN NaN
19 Bangladesh BGD Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 1.318850e+09 1.221180e+09 1.515240e+09 2.070630e+09 1.225820e+09 1.414950e+09 1.490020e+09 2.152090e+09 NaN NaN
20 Bulgaria BGR Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
21 Bahrain BHR Net official development assistance and offici... DT.ODA.ALLD.CD 40000 940000 1350000 640000 580000 880000 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
22 Bahamas, The BHS Net official development assistance and offici... DT.ODA.ALLD.CD -40000 NaN NaN 20000 60000 70000 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
23 Bosnia and Herzegovina BIH Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 5.485200e+08 5.349800e+08 5.994900e+08 4.669300e+08 4.143100e+08 5.103700e+08 6.254600e+08 5.711300e+08 NaN NaN
24 Belarus BLR Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 5.781000e+07 7.652000e+07 8.376000e+07 1.101800e+08 9.757000e+07 1.379200e+08 1.258600e+08 1.032200e+08 NaN NaN
25 Belize BLZ Net official development assistance and offici... DT.ODA.ALLD.CD 1820000 2820000 5520000 4060000 1550000 2130000 ... 1.217000e+07 8.630000e+06 2.177000e+07 2.386000e+07 2.756000e+07 2.476000e+07 2.256000e+07 2.518000e+07 NaN NaN
26 Bermuda BMU Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN 10000 50000 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
27 Bolivia BOL Net official development assistance and offici... DT.ODA.ALLD.CD 12080000 23630000 35910000 53500000 40920000 33960000 ... 6.430600e+08 8.499700e+08 4.758100e+08 6.278700e+08 7.252500e+08 7.409800e+08 7.218400e+08 6.586300e+08 NaN NaN
28 Brazil BRA Net official development assistance and offici... DT.ODA.ALLD.CD 24110000 266570000 166560000 197240000 249000000 236070000 ... 2.430700e+08 1.134300e+08 3.212000e+08 4.603600e+08 3.369300e+08 4.533100e+08 8.154900e+08 1.288220e+09 NaN NaN
29 Barbados BRB Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... -1.810000e+06 -2.080000e+06 1.751000e+07 7.120000e+06 1.196000e+07 1.620000e+07 NaN NaN NaN NaN
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
228 Togo TGO Net official development assistance and offici... DT.ODA.ALLD.CD 110000 2930000 4530000 6650000 14940000 13360000 ... 8.254000e+07 7.990000e+07 1.224200e+08 3.300700e+08 4.985200e+08 4.040400e+08 5.427300e+08 2.414600e+08 NaN NaN
229 Thailand THA Net official development assistance and offici... DT.ODA.ALLD.CD 43780000 29340000 37890000 36330000 31850000 49090000 ... -1.676600e+08 -2.170400e+08 -3.109900e+08 -6.185100e+08 -7.776000e+07 -1.140000e+07 -1.536700e+08 -1.347900e+08 NaN NaN
230 Tajikistan TJK Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 2.515000e+08 2.412400e+08 2.221100e+08 2.886800e+08 4.081200e+08 4.366500e+08 3.475100e+08 3.939100e+08 NaN NaN
231 Turkmenistan TKM Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 3.037000e+07 4.071000e+07 2.848000e+07 1.813000e+07 3.984000e+07 4.465000e+07 3.868000e+07 3.803000e+07 NaN NaN
232 Timor-Leste TLS Net official development assistance and offici... DT.ODA.ALLD.CD NaN 1640000 NaN NaN NaN NaN ... 1.847600e+08 2.090700e+08 2.782700e+08 2.775400e+08 2.164400e+08 2.915000e+08 2.792600e+08 2.830700e+08 NaN NaN
233 Tonga TON Net official development assistance and offici... DT.ODA.ALLD.CD 10000 20000 70000 50000 60000 500000 ... 3.198000e+07 2.149000e+07 3.086000e+07 2.571000e+07 3.924000e+07 7.045000e+07 9.379000e+07 7.826000e+07 NaN NaN
234 Trinidad and Tobago TTO Net official development assistance and offici... DT.ODA.ALLD.CD NaN 80000 550000 11520000 12030000 16240000 ... -1.980000e+06 1.382000e+07 2.080000e+07 9.290000e+06 6.840000e+06 4.330000e+06 NaN NaN NaN NaN
235 Tunisia TUN Net official development assistance and offici... DT.ODA.ALLD.CD 51830000 93820000 70110000 83560000 71070000 90920000 ... 3.624200e+08 4.313700e+08 3.211900e+08 3.749600e+08 5.027900e+08 5.503600e+08 9.210800e+08 1.017020e+09 NaN NaN
236 Turkey TUR Net official development assistance and offici... DT.ODA.ALLD.CD 137310000 188280000 229590000 222670000 162080000 189410000 ... 3.960200e+08 5.657400e+08 7.921400e+08 1.116140e+09 1.361520e+09 1.047160e+09 3.188930e+09 3.033130e+09 NaN NaN
237 Tuvalu TUV Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 9.200000e+06 1.534000e+07 1.174000e+07 1.612000e+07 1.747000e+07 1.333000e+07 3.880000e+07 2.449000e+07 NaN NaN
238 Tanzania TZA Net official development assistance and offici... DT.ODA.ALLD.CD 10360000 39190000 47010000 31060000 45650000 38630000 ... 1.499070e+09 1.883290e+09 2.821590e+09 2.331460e+09 2.933150e+09 2.958180e+09 2.445770e+09 2.831890e+09 NaN NaN
239 Uganda UGA Net official development assistance and offici... DT.ODA.ALLD.CD 20600000 21230000 28770000 19590000 22490000 20120000 ... 1.192160e+09 1.586430e+09 1.737300e+09 1.641470e+09 1.784700e+09 1.723470e+09 1.577820e+09 1.655190e+09 NaN NaN
240 Ukraine UKR Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 4.116900e+08 4.835000e+08 4.202800e+08 6.175800e+08 6.662000e+08 6.264000e+08 8.072300e+08 7.692300e+08 NaN NaN
241 Upper middle income UMC Net official development assistance and offici... DT.ODA.ALLD.CD 781640000 1416770000 1330280000 1224640000 952720000 1046010000 ... 3.222894e+10 1.980692e+10 2.021529e+10 2.319344e+10 1.525723e+10 1.318240e+10 1.715709e+10 1.559465e+10 0 NaN
242 Uruguay URY Net official development assistance and offici... DT.ODA.ALLD.CD 17330000 -570000 1950000 12270000 4420000 320000 ... 1.444000e+07 2.107000e+07 3.701000e+07 3.329000e+07 5.003000e+07 4.671000e+07 1.940000e+07 1.932000e+07 NaN NaN
243 United States USA Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
244 Uzbekistan UZB Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 1.697900e+08 1.493000e+08 1.698500e+08 1.873200e+08 1.897500e+08 2.308500e+08 2.031900e+08 2.552600e+08 NaN NaN
245 St. Vincent and the Grenadines VCT Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 7.690000e+06 4.730000e+06 6.585000e+07 2.686000e+07 3.076000e+07 1.685000e+07 1.787000e+07 8.560000e+06 NaN NaN
246 Venezuela, RB VEN Net official development assistance and offici... DT.ODA.ALLD.CD -7490000 -4880000 68890000 47720000 -51700000 3800000 ... 5.030000e+07 6.293000e+07 7.776000e+07 5.922000e+07 6.634000e+07 5.274000e+07 4.487000e+07 4.813000e+07 NaN NaN
247 Virgin Islands (U.S.) VIR Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
248 Vietnam VNM Net official development assistance and offici... DT.ODA.ALLD.CD 191850000 167110000 176030000 226670000 244990000 314150000 ... 1.913460e+09 1.844540e+09 2.510940e+09 2.551930e+09 3.731690e+09 2.940080e+09 3.595510e+09 4.115780e+09 NaN NaN
249 Vanuatu VUT Net official development assistance and offici... DT.ODA.ALLD.CD 150000 280000 410000 510000 650000 580000 ... 3.948000e+07 4.879000e+07 5.669000e+07 9.227000e+07 1.031900e+08 1.083100e+08 9.215000e+07 1.014200e+08 NaN NaN
250 West Bank and Gaza PSE Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 1.015710e+09 1.360250e+09 1.717110e+09 2.470080e+09 2.816640e+09 2.518700e+09 2.441970e+09 2.001390e+09 NaN NaN
251 World WLD Net official development assistance and offici... DT.ODA.ALLD.CD 4254390000 5219020000 5439680000 5962450000 5835340000 6242640000 ... 1.084508e+11 1.070030e+11 1.080812e+11 1.274432e+11 1.265768e+11 1.310664e+11 1.410584e+11 1.330394e+11 0 NaN
252 Samoa WSM Net official development assistance and offici... DT.ODA.ALLD.CD NaN 30000 90000 170000 210000 230000 ... 4.355000e+07 4.707000e+07 3.747000e+07 4.031000e+07 7.731000e+07 1.474800e+08 9.782000e+07 1.206700e+08 NaN NaN
253 Yemen, Rep. YEM Net official development assistance and offici... DT.ODA.ALLD.CD 14690000 14880000 18080000 21580000 23330000 31540000 ... 2.965300e+08 2.874100e+08 2.425600e+08 4.296100e+08 5.578500e+08 6.642300e+08 4.761200e+08 7.093900e+08 NaN NaN
254 South Africa ZAF Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 6.902000e+08 7.149900e+08 8.074900e+08 1.125180e+09 1.074540e+09 1.030540e+09 1.403150e+09 1.067150e+09 NaN NaN
255 Congo, Dem. Rep. COD Net official development assistance and offici... DT.ODA.ALLD.CD 82090000 91160000 120970000 111500000 127020000 142070000 ... 1.881700e+09 2.197280e+09 1.356710e+09 1.765970e+09 2.356850e+09 3.486160e+09 5.534410e+09 2.859380e+09 NaN NaN
256 Zambia ZMB Net official development assistance and offici... DT.ODA.ALLD.CD 920000 910000 5880000 5380000 20990000 10860000 ... 1.172050e+09 1.467540e+09 1.007840e+09 1.116240e+09 1.267060e+09 9.143700e+08 1.035060e+09 9.577200e+08 NaN NaN
257 Zimbabwe ZWE Net official development assistance and offici... DT.ODA.ALLD.CD NaN 10000 NaN 10860000 4570000 3720000 ... 3.727200e+08 2.782400e+08 4.781100e+08 6.124200e+08 7.362200e+08 7.324700e+08 7.156800e+08 1.001220e+09 NaN NaN

258 rows × 59 columns

In [20]:
df_pop_total = pd.read_csv(wb_pop_total_csv, header=2)
df_pop_total
Out[20]:
Country Name Country Code Indicator Name Indicator Code 1960 1961 1962 1963 1964 1965 ... 2005 2006 2007 2008 2009 2010 2011 2012 2013 Unnamed: 58
0 Aruba ABW Population (Total) SP.POP.TOTL 54208 55435 56226 56697 57029 57360 ... 100031 100830 101219 101344 101418 101597 101932 102384 102911 NaN
1 Andorra AND Population (Total) SP.POP.TOTL 13414 14376 15376 16410 17470 18551 ... 81223 81877 81292 79969 78659 77907 77865 78360 79218 NaN
2 Afghanistan AFG Population (Total) SP.POP.TOTL 8774440 8953544 9141783 9339507 9547131 9765015 ... 24860855 25631282 26349243 27032197 27708187 28397812 29105480 29824536 30551674 NaN
3 Angola AGO Population (Total) SP.POP.TOTL 4965988 5056688 5150076 5245015 5339893 5433841 ... 16544376 17122409 17712824 18314441 18926650 19549124 20180490 20820525 21471618 NaN
4 Albania ALB Population (Total) SP.POP.TOTL 1608800 1659800 1711319 1762621 1814135 1864791 ... 2992724 2968028 2940880 2912559 2884303 2856673 2829337 2801681 2773620 NaN
5 Andean Region ANR Population (Total) SP.POP.TOTL NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
6 Arab World ARB Population (Total) SP.POP.TOTL 93485943 96058179 98728995 101496308 104359772 107318159 ... 309824383 317125787 324693498 332424892 340149038 347737036 355137048 362466629 369761523 NaN
7 United Arab Emirates ARE Population (Total) SP.POP.TOTL 89608 97727 108774 121574 134411 146341 ... 4148883 4875639 5797347 6798635 7718319 8441537 8925096 9205651 9346129 NaN
8 Argentina ARG Population (Total) SP.POP.TOTL 20623998 20959241 21295290 21630854 21963952 22293817 ... 38647854 38988923 39331357 39676083 40023641 40374224 40728738 41086927 41446246 NaN
9 Armenia ARM Population (Total) SP.POP.TOTL 1867396 1934239 2002170 2070427 2138133 2204650 ... 3014917 3002911 2989882 2977488 2968154 2963496 2964120 2969081 2976566 NaN
10 American Samoa ASM Population (Total) SP.POP.TOTL 20012 20478 21118 21883 22701 23518 ... 59117 58652 57919 57053 56245 55636 55274 55128 55165 NaN
11 Antigua and Barbuda ATG Population (Total) SP.POP.TOTL 54681 55403 56311 57368 58500 59653 ... 82565 83467 84397 85349 86300 87233 88152 89069 89985 NaN
12 Australia AUS Population (Total) SP.POP.TOTL 10276477 10483000 10742000 10950000 11167000 11388000 ... 20394800 20697900 20827600 21249200 21691700 22031800 22340000 22723900 23130900 NaN
13 Austria AUT Population (Total) SP.POP.TOTL 7047539 7086299 7129864 7175811 7223801 7270889 ... 8227829 8268641 8300788 8336926 8365275 8389771 8406187 8429991 8473786 NaN
14 Azerbaijan AZE Population (Total) SP.POP.TOTL 3897889 4030130 4167558 4307315 4445653 4579759 ... 8391850 8484550 8581300 8763400 8947243 9054332 9173082 9295784 9416598 NaN
15 Burundi BDI Population (Total) SP.POP.TOTL 2786740 2840375 2894510 2950903 3011957 3079034 ... 7770392 8042579 8328312 8624280 8926687 9232753 9540362 9849569 10162532 NaN
16 Belgium BEL Population (Total) SP.POP.TOTL 9153489 9183948 9220578 9289770 9378113 9463667 ... 10478617 10547958 10625700 10709973 10796493 10920272 11047744 11128246 11195138 NaN
17 Benin BEN Population (Total) SP.POP.TOTL 2431620 2466002 2503232 2543335 2586362 2632360 ... 8182362 8443671 8707490 8973293 9240783 9509798 9779795 10050702 10323474 NaN
18 Burkina Faso BFA Population (Total) SP.POP.TOTL 4829291 4894578 4960325 5027818 5098892 5174869 ... 13421929 13822257 14235075 14659646 15094967 15540284 15995313 16460141 16934839 NaN
19 Bangladesh BGD Population (Total) SP.POP.TOTL 49537147 50953503 52403243 53909233 55503132 57200412 ... 143135180 144868702 146457067 147969967 149503100 151125475 152862431 154695368 156594962 NaN
20 Bulgaria BGR Population (Total) SP.POP.TOTL 7867374 7943118 8012946 8078145 8144340 8204168 ... 7739900 7699020 7545338 7492561 7444443 7395599 7348328 7305888 7265115 NaN
21 Bahrain BHR Population (Total) SP.POP.TOTL 162501 167924 173107 178048 182774 187348 ... 879534 950951 1032353 1116038 1191539 1251513 1292764 1317827 1332171 NaN
22 Bahamas, The BHS Population (Total) SP.POP.TOTL 109526 115108 121083 127331 133697 140049 ... 329088 335622 342049 348340 354492 360498 366331 371960 377374 NaN
23 Bosnia and Herzegovina BIH Population (Total) SP.POP.TOTL 3305501 3358202 3409319 3458189 3503878 3545862 ... 3879828 3875157 3868665 3861201 3853446 3845929 3839322 3833916 3829307 NaN
24 Belarus BLR Population (Total) SP.POP.TOTL 8198000 8271216 8351928 8437232 8524224 8610000 ... 9663000 9604000 9560000 9528000 9507000 9490000 9473000 9464000 9466000 NaN
25 Belize BLZ Population (Total) SP.POP.TOTL 92068 94701 97389 100166 103070 106121 ... 271920 278985 286196 293544 301016 308595 316280 324060 331900 NaN
26 Bermuda BMU Population (Total) SP.POP.TOTL 44400 45500 46600 47700 48900 50100 ... 64154 64523 64888 65273 65636 65124 64564 64798 65024 NaN
27 Bolivia BOL Population (Total) SP.POP.TOTL 3353125 3428270 3505427 3584782 3666584 3751047 ... 9354709 9517395 9676456 9834098 9993406 10156601 10324445 10496285 10671200 NaN
28 Brazil BRA Population (Total) SP.POP.TOTL 72775883 74988037 77286629 79643017 82017016 84379369 ... 186142403 188134315 189996976 191765567 193490922 195210154 196935134 198656019 200361925 NaN
29 Barbados BRB Population (Total) SP.POP.TOTL 230858 231599 232514 233520 234478 235294 ... 273568 274923 276277 277634 279006 280396 281804 283221 284644 NaN
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
228 Togo TGO Population (Total) SP.POP.TOTL 1580513 1597528 1612758 1631763 1662072 1708632 ... 5540214 5685845 5834806 5987491 6144457 6306014 6472304 6642928 6816982 NaN
229 Thailand THA Population (Total) SP.POP.TOTL 27362310 28195264 29058659 29951191 30870998 31816307 ... 65559487 65883961 66076927 66185340 66277335 66402316 66576332 66785001 67010502 NaN
230 Tajikistan TJK Population (Total) SP.POP.TOTL 2064035 2140413 2223956 2312193 2401598 2489648 ... 6805655 6954522 7111025 7275252 7447396 7627326 7814850 8008990 8207834 NaN
231 Turkmenistan TKM Population (Total) SP.POP.TOTL 1593501 1649914 1708711 1769008 1829697 1890000 ... 4747839 4801595 4858236 4917543 4978962 5041995 5106668 5172931 5240072 NaN
232 Timor-Leste TLS Population (Total) SP.POP.TOTL 499681 508504 517704 527291 537285 547688 ... 982889 999053 1015482 1032182 1049156 1066409 1120392 1148958 1178252 NaN
233 Tonga TON Population (Total) SP.POP.TOTL 61600 63740 66255 69000 71757 74363 ... 100960 101617 102289 102947 103557 104098 104554 104941 105323 NaN
234 Trinidad and Tobago TTO Population (Total) SP.POP.TOTL 848481 865356 880019 892571 903272 912419 ... 1296933 1303478 1310040 1316449 1322518 1328095 1333082 1337439 1341151 NaN
235 Tunisia TUN Population (Total) SP.POP.TOTL 4220701 4277371 4350811 4436643 4530835 4630000 ... 10029000 10127900 10225100 10328900 10439600 10549100 10673800 10777500 10886500 NaN
236 Turkey TUR Population (Total) SP.POP.TOTL 27553280 28229291 28909985 29597047 30292969 31000167 ... 67743052 68626337 69496513 70363511 71241080 72137546 73058638 73997128 74932641 NaN
237 Tuvalu TUV Population (Total) SP.POP.TOTL 6104 6242 6391 6542 6687 6819 ... 9694 9732 9764 9788 9808 9827 9844 9860 9876 NaN
238 Tanzania TZA Population (Total) SP.POP.TOTL 10074490 10373284 10683653 11005491 11338544 11682873 ... 38824384 39942347 41119693 42353790 43639752 44973330 46354607 47783107 49253126 NaN
239 Uganda UGA Population (Total) SP.POP.TOTL 6788211 7006629 7240155 7487412 7746181 8014376 ... 28724869 29711397 30728747 31778799 32864328 33987213 35148064 36345860 37578876 NaN
240 Ukraine UKR Population (Total) SP.POP.TOTL 42662162 43203646 43749474 44285898 44794336 45261976 ... 47105150 46787750 46509350 46258200 46053300 45870700 45706100 45593300 45489600 NaN
241 Upper middle income UMC Population (Total) SP.POP.TOTL 1062752609 1066276123 1082173926 1109380940 1136183050 1163862954 ... 2264763992 2283242974 2300791118 2318342943 2336270149 2354056585 2371969330 2390210774 2408656292 NaN
242 Uruguay URY Population (Total) SP.POP.TOTL 2538779 2571834 2604042 2635294 2665561 2694714 ... 3325155 3330217 3338384 3348898 3360431 3371982 3383486 3395253 3407062 NaN
243 United States USA Population (Total) SP.POP.TOTL 180671000 183691000 186538000 189242000 191889000 194303000 ... 295516599 298379912 301231207 304093966 306771529 309326295 311582564 313873685 316128839 NaN
244 Uzbekistan UZB Population (Total) SP.POP.TOTL 8558503 8871244 9201176 9542785 9888629 10233502 ... 26167000 26488250 26868000 27302800 27767400 28562400 29339400 29774500 30241100 NaN
245 St. Vincent and the Grenadines VCT Population (Total) SP.POP.TOTL 80948 82144 83206 84167 85076 85972 ... 108749 108908 109045 109158 109249 109316 109357 109373 109373 NaN
246 Venezuela, RB VEN Population (Total) SP.POP.TOTL 7580281 7872644 8172322 8477485 8785731 9095742 ... 26725897 27190882 27655937 28120312 28583040 29043283 29500625 29954782 30405207 NaN
247 Virgin Islands (U.S.) VIR Population (Total) SP.POP.TOTL 32000 34100 36300 38700 41300 44000 ... 107863 107700 107423 107091 106707 106267 105784 105275 104737 NaN
248 Vietnam VNM Population (Total) SP.POP.TOTL 34743000 35428000 36123000 36836000 37574000 38341000 ... 82393500 83313000 84221100 85122300 86025000 86932500 87840000 88772900 89708900 NaN
249 Vanuatu VUT Population (Total) SP.POP.TOTL 63701 65708 67806 69962 72131 74287 ... 209375 214654 220001 225398 230833 236299 241778 247262 252763 NaN
250 West Bank and Gaza PSE Population (Total) SP.POP.TOTL NaN NaN NaN NaN NaN NaN ... 3320396 3406334 3494496 3596688 3702218 3811102 3927051 4046901 4169506 NaN
251 World WLD Population (Total) SP.POP.TOTL 3036411561 3077508964 3130438533 3195291446 3260691352 3327432481 ... 6490176815 6567959806 6645716553 6724646992 6803742004 6883512372 6964638027 7043105591 7124543962 NaN
252 Samoa WSM Population (Total) SP.POP.TOTL 108645 112121 115786 119564 123354 127068 ... 179928 181073 182240 183444 184704 186029 187429 188889 190372 NaN
253 Yemen, Rep. YEM Population (Total) SP.POP.TOTL 5099785 5184477 5276093 5372934 5472775 5573959 ... 20139661 20661714 21182162 21703571 22229625 22763008 23304206 23852409 24407381 NaN
254 South Africa ZAF Population (Total) SP.POP.TOTL 17396000 17949962 18459442 18936138 19390554 19832000 ... 47639556 48269753 48910248 49561256 50222996 50895698 51579599 52274945 52981991 NaN
255 Congo, Dem. Rep. COD Population (Total) SP.POP.TOTL 15248246 15637715 16041247 16461914 16903899 17369859 ... 54028003 55590838 57187942 58819038 60486276 62191161 63931512 65705093 67513677 NaN
256 Zambia ZMB Population (Total) SP.POP.TOTL 3082627 3173662 3269151 3368961 3472843 3580708 ... 11470022 11781612 12109620 12456527 12825031 13216985 13633796 14075099 14538640 NaN
257 Zimbabwe ZWE Population (Total) SP.POP.TOTL 3752390 3876638 4006261 4140802 4279559 4422129 ... 12710589 12724308 12740160 12784041 12888918 13076978 13358738 13724317 14149648 NaN

258 rows × 59 columns

In [24]:
df_net_aid[['Country Name', 'Country Code', '2012']]
Out[24]:
Country Name Country Code 2012
0 Aruba ABW NaN
1 Andorra AND NaN
2 Afghanistan AFG 6.725030e+09
3 Angola AGO 2.423500e+08
4 Albania ALB 3.416200e+08
5 Andean Region ANR NaN
6 Arab World ARB 1.495131e+10
7 United Arab Emirates ARE NaN
8 Argentina ARG 1.789200e+08
9 Armenia ARM 2.727700e+08
10 American Samoa ASM NaN
11 Antigua and Barbuda ATG 2.350000e+06
12 Australia AUS NaN
13 Austria AUT NaN
14 Azerbaijan AZE 3.376100e+08
15 Burundi BDI 5.227400e+08
16 Belgium BEL NaN
17 Benin BEN 5.113300e+08
18 Burkina Faso BFA 1.158540e+09
19 Bangladesh BGD 2.152090e+09
20 Bulgaria BGR NaN
21 Bahrain BHR NaN
22 Bahamas, The BHS NaN
23 Bosnia and Herzegovina BIH 5.711300e+08
24 Belarus BLR 1.032200e+08
25 Belize BLZ 2.518000e+07
26 Bermuda BMU NaN
27 Bolivia BOL 6.586300e+08
28 Brazil BRA 1.288220e+09
29 Barbados BRB NaN
... ... ... ...
228 Togo TGO 2.414600e+08
229 Thailand THA -1.347900e+08
230 Tajikistan TJK 3.939100e+08
231 Turkmenistan TKM 3.803000e+07
232 Timor-Leste TLS 2.830700e+08
233 Tonga TON 7.826000e+07
234 Trinidad and Tobago TTO NaN
235 Tunisia TUN 1.017020e+09
236 Turkey TUR 3.033130e+09
237 Tuvalu TUV 2.449000e+07
238 Tanzania TZA 2.831890e+09
239 Uganda UGA 1.655190e+09
240 Ukraine UKR 7.692300e+08
241 Upper middle income UMC 1.559465e+10
242 Uruguay URY 1.932000e+07
243 United States USA NaN
244 Uzbekistan UZB 2.552600e+08
245 St. Vincent and the Grenadines VCT 8.560000e+06
246 Venezuela, RB VEN 4.813000e+07
247 Virgin Islands (U.S.) VIR NaN
248 Vietnam VNM 4.115780e+09
249 Vanuatu VUT 1.014200e+08
250 West Bank and Gaza PSE 2.001390e+09
251 World WLD 1.330394e+11
252 Samoa WSM 1.206700e+08
253 Yemen, Rep. YEM 7.093900e+08
254 South Africa ZAF 1.067150e+09
255 Congo, Dem. Rep. COD 2.859380e+09
256 Zambia ZMB 9.577200e+08
257 Zimbabwe ZWE 1.001220e+09

258 rows × 3 columns

In [25]:
df_pop_total[['Country Name', 'Country Code', '2012']]
Out[25]:
Country Name Country Code 2012
0 Aruba ABW 102384
1 Andorra AND 78360
2 Afghanistan AFG 29824536
3 Angola AGO 20820525
4 Albania ALB 2801681
5 Andean Region ANR NaN
6 Arab World ARB 362466629
7 United Arab Emirates ARE 9205651
8 Argentina ARG 41086927
9 Armenia ARM 2969081
10 American Samoa ASM 55128
11 Antigua and Barbuda ATG 89069
12 Australia AUS 22723900
13 Austria AUT 8429991
14 Azerbaijan AZE 9295784
15 Burundi BDI 9849569
16 Belgium BEL 11128246
17 Benin BEN 10050702
18 Burkina Faso BFA 16460141
19 Bangladesh BGD 154695368
20 Bulgaria BGR 7305888
21 Bahrain BHR 1317827
22 Bahamas, The BHS 371960
23 Bosnia and Herzegovina BIH 3833916
24 Belarus BLR 9464000
25 Belize BLZ 324060
26 Bermuda BMU 64798
27 Bolivia BOL 10496285
28 Brazil BRA 198656019
29 Barbados BRB 283221
... ... ... ...
228 Togo TGO 6642928
229 Thailand THA 66785001
230 Tajikistan TJK 8008990
231 Turkmenistan TKM 5172931
232 Timor-Leste TLS 1148958
233 Tonga TON 104941
234 Trinidad and Tobago TTO 1337439
235 Tunisia TUN 10777500
236 Turkey TUR 73997128
237 Tuvalu TUV 9860
238 Tanzania TZA 47783107
239 Uganda UGA 36345860
240 Ukraine UKR 45593300
241 Upper middle income UMC 2390210774
242 Uruguay URY 3395253
243 United States USA 313873685
244 Uzbekistan UZB 29774500
245 St. Vincent and the Grenadines VCT 109373
246 Venezuela, RB VEN 29954782
247 Virgin Islands (U.S.) VIR 105275
248 Vietnam VNM 88772900
249 Vanuatu VUT 247262
250 West Bank and Gaza PSE 4046901
251 World WLD 7043105591
252 Samoa WSM 188889
253 Yemen, Rep. YEM 23852409
254 South Africa ZAF 52274945
255 Congo, Dem. Rep. COD 65705093
256 Zambia ZMB 14075099
257 Zimbabwe ZWE 13724317

258 rows × 3 columns

In [31]:
df_aid_pop = pd.merge(df_net_aid, df_pop_total,
                      on='Country Code',
                      how='outer',
                      suffixes=('_aid', '_pop'))
df_aid_pop.head()
Out[31]:
Country Name_aid Country Code Indicator Name_aid Indicator Code_aid 1960_aid 1961_aid 1962_aid 1963_aid 1964_aid 1965_aid ... 2005_pop 2006_pop 2007_pop 2008_pop 2009_pop 2010_pop 2011_pop 2012_pop 2013_pop Unnamed: 58_pop
0 Aruba ABW Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 100031 100830 101219 101344 101418 101597 101932 102384 102911 NaN
1 Andorra AND Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 81223 81877 81292 79969 78659 77907 77865 78360 79218 NaN
2 Afghanistan AFG Net official development assistance and offici... DT.ODA.ALLD.CD 17180000 34670000 16930000 36670000 46170000 53930000 ... 24860855 25631282 26349243 27032197 27708187 28397812 29105480 29824536 30551674 NaN
3 Angola AGO Net official development assistance and offici... DT.ODA.ALLD.CD -50000 23550000 NaN 30000 NaN 1110000 ... 16544376 17122409 17712824 18314441 18926650 19549124 20180490 20820525 21471618 NaN
4 Albania ALB Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 2992724 2968028 2940880 2912559 2884303 2856673 2829337 2801681 2773620 NaN

5 rows × 117 columns

In [86]:
for year in xrange(1960, 2012 + 1):
    aidcolumn = '%d_aid' % year
    popcolumn = '%d_pop' % year
    aidpercapitacolumn = '%d_aid_per_capita' % year
    df_aid_pop[aidpercapitacolumn] = df_aid_pop[aidcolumn] / df_aid_pop[popcolumn]
    
path = 'wb_aid_per_capita_1960-2013.csv'
df_aid_pop.to_csv(path)

df_aid_pop
Out[86]:
Country Name_aid Country Code Indicator Name_aid Indicator Code_aid 1960_aid 1961_aid 1962_aid 1963_aid 1964_aid 1965_aid ... 2000_aid_per_capita 2001_aid_per_capita 2002_aid_per_capita 2003_aid_per_capita 2004_aid_per_capita 2005_aid_per_capita 2006_aid_per_capita 2007_aid_per_capita 2008_aid_per_capita 2009_aid_per_capita
0 Aruba ABW Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 126.571133 -18.300428 110.426865 785.651703 -114.642199 NaN NaN NaN NaN NaN
1 Andorra AND Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
2 Afghanistan AFG Net official development assistance and offici... DT.ODA.ALLD.CD 17180000 34670000 16930000 36670000 46170000 53930000 ... 6.603915 19.222606 58.991192 68.941868 96.237171 114.140081 115.549039 188.419834 180.343092 225.033128
3 Angola AGO Net official development assistance and offici... DT.ODA.ALLD.CD -50000 23550000 NaN 30000 NaN 1110000 ... 21.702802 19.654115 27.812309 32.016575 71.632998 25.058062 9.550058 13.982525 20.138207 12.612375
4 Albania ALB Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 102.896478 87.637165 100.746307 116.855586 99.499797 106.638634 108.415419 104.455129 124.725370 123.759536
5 Andean Region ANR Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
6 Arab World ARB Net official development assistance and offici... DT.ODA.ALLD.CD 881990000 973930000 929090000 858610000 831420000 666060000 ... 18.238197 19.283680 18.341212 30.669248 38.742913 94.491885 55.350718 58.694769 68.462623 41.888168
7 United Arab Emirates ARE Net official development assistance and offici... DT.ODA.ALLD.CD 410000 540000 430000 390000 580000 20000 ... 1.057379 0.756680 1.187977 1.472136 1.465018 NaN NaN NaN NaN NaN
8 Argentina ARG Net official development assistance and offici... DT.ODA.ALLD.CD 28580000 29180000 39800000 37800000 17220000 -62200000 ... 1.422375 3.905202 2.166498 2.808503 2.384310 2.488625 2.951608 2.576570 3.291151 3.166379
9 Armenia ARM Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 70.183070 69.161035 98.322876 83.595957 83.753849 56.499068 71.767029 117.068165 101.639368 177.204417
10 American Samoa ASM Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
11 Antigua and Barbuda ATG Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 126.081805 108.139594 168.311883 76.139622 19.946646 94.349906 39.296968 87.443866 102.520240 65.353418
12 Australia AUS Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
13 Austria AUT Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
14 Azerbaijan AZE Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 17.284994 28.326265 42.745000 36.518867 21.159333 25.800032 24.325391 26.244275 26.827487 25.904069
15 Burundi BDI Net official development assistance and offici... DT.ODA.ALLD.CD 7530000 7190000 11070000 6160000 8090000 4860000 ... 13.952054 20.343961 24.438288 31.353158 48.469059 46.839336 53.576098 57.514656 60.554620 62.886713
16 Belgium BEL Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
17 Benin BEN Net official development assistance and offici... DT.ODA.ALLD.CD 20000 1480000 3750000 4260000 18070000 17880000 ... 35.031973 38.730794 29.541141 39.111985 49.704675 42.399737 47.292226 54.478386 71.487691 73.809763
18 Burkina Faso BFA Net official development assistance and offici... DT.ODA.ALLD.CD 200000 1350000 4430000 4140000 15400000 17270000 ... 15.487669 33.981021 35.763316 42.732153 49.297781 51.659489 65.219450 66.764664 68.293600 71.733843
19 Bangladesh BGD Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 8.859428 7.746930 6.614660 10.021770 10.010618 9.214017 8.429564 10.345967 13.993583 8.199295
20 Bulgaria BGR Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 37.592844 44.144333 41.586240 54.121163 81.833546 NaN NaN NaN NaN NaN
21 Bahrain BHR Net official development assistance and offici... DT.ODA.ALLD.CD 40000 940000 1350000 640000 580000 880000 ... 90.431717 101.338249 84.063554 170.673706 70.956301 NaN NaN NaN NaN NaN
22 Bahamas, The BHS Net official development assistance and offici... DT.ODA.ALLD.CD -40000 NaN NaN 20000 60000 70000 ... 18.370561 28.646392 17.214656 12.895090 14.733251 NaN NaN NaN NaN NaN
23 Bosnia and Herzegovina BIH Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 192.451734 164.996586 142.596212 139.104400 176.554902 141.377401 138.053761 154.960432 120.928696 107.516753
24 Belarus BLR Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 3.447276 3.973610 3.981754 4.943350 5.096608 5.982614 7.967514 8.761506 11.563812 10.262964
25 Belize BLZ Net official development assistance and offici... DT.ODA.ALLD.CD 1820000 2820000 5520000 4060000 1550000 2130000 ... 61.445349 90.416724 88.892066 45.597764 28.599457 44.755811 30.933563 76.066751 81.282533 91.556595
26 Bermuda BMU Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN 10000 50000 ... 0.970356 0.319980 0.317904 0.473747 1.411986 NaN NaN NaN NaN NaN
27 Bolivia BOL Net official development assistance and offici... DT.ODA.ALLD.CD 12080000 23630000 35910000 53500000 40920000 33960000 ... 56.703312 85.790095 77.948967 104.073657 85.489044 68.741850 89.307000 49.171928 63.846222 72.572855
28 Brazil BRA Net official development assistance and offici... DT.ODA.ALLD.CD 24110000 266570000 166560000 197240000 249000000 236070000 ... 1.325865 1.240505 1.157955 1.090931 0.838975 1.305828 0.602920 1.690553 2.400640 1.741322
29 Barbados BRB Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 0.898237 -4.286311 12.280910 73.400186 105.839349 -6.616271 -7.565755 63.378421 25.645274 42.866462
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
228 Togo TGO Net official development assistance and offici... DT.ODA.ALLD.CD 110000 2930000 4530000 6650000 14940000 13360000 ... 14.296718 9.230353 10.022105 9.486674 12.023303 14.898341 14.052441 20.980989 55.126596 81.133288
229 Thailand THA Net official development assistance and offici... DT.ODA.ALLD.CD 43780000 29340000 37890000 36330000 31850000 49090000 ... 11.174082 4.445285 4.597648 -14.625125 0.727176 -2.557372 -3.294277 -4.706484 -9.345121 -1.173252
230 Tajikistan TJK Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 19.970411 26.282567 26.287773 22.682828 38.028616 36.954562 34.688222 31.234597 39.679725 54.800362
231 Turkmenistan TKM Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 7.841972 16.534256 9.506168 6.144529 11.552359 6.396594 8.478433 5.862210 3.686801 8.001668
232 Timor-Leste TLS Net official development assistance and offici... DT.ODA.ALLD.CD NaN 1640000 NaN NaN NaN NaN ... 270.939625 222.837358 243.560193 187.524977 166.744744 187.976465 209.268177 274.027506 268.886689 206.299159
233 Tonga TON Net official development assistance and offici... DT.ODA.ALLD.CD 10000 20000 70000 50000 60000 500000 ... 192.115310 205.778446 227.990674 279.363232 192.984380 316.759113 211.480363 301.694219 249.740158 378.921753
234 Trinidad and Tobago TTO Net official development assistance and offici... DT.ODA.ALLD.CD NaN 80000 550000 11520000 12030000 16240000 ... -1.206644 -1.359692 -6.715070 -2.258799 -1.402689 -1.526679 10.602404 15.877378 7.056863 5.171952
235 Tunisia TUN Net official development assistance and offici... DT.ODA.ALLD.CD 51830000 93820000 70110000 83560000 71070000 90920000 ... 23.185026 37.767739 22.579458 30.464034 35.470782 36.137202 42.592245 31.411918 36.302026 48.161807
236 Turkey TUR Net official development assistance and offici... DT.ODA.ALLD.CD 137310000 188280000 229590000 222670000 162080000 189410000 ... 5.175032 2.053345 4.292374 2.496426 4.268342 5.845913 8.243774 11.398270 15.862483 19.111445
237 Tuvalu TUV Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 427.858584 1004.117833 1228.751312 650.677789 829.359320 949.040644 1576.243321 1202.376075 1646.914589 1781.199021
238 Tanzania TZA Net official development assistance and offici... DT.ODA.ALLD.CD 10360000 39190000 47010000 31060000 45650000 38630000 ... 31.272898 36.515703 35.463955 46.935555 46.932437 38.611559 47.150209 68.618946 55.047258 67.212802
239 Uganda UGA Net official development assistance and offici... DT.ODA.ALLD.CD 20600000 21230000 28770000 19590000 22490000 20120000 ... 35.149638 32.772199 27.960439 37.172445 43.793734 41.502713 53.394662 56.536637 51.652990 54.305081
240 Ukraine UKR Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 10.954971 10.526486 9.865671 6.864667 7.923653 8.739809 10.333902 9.036463 13.350714 14.465847
241 Upper middle income UMC Net official development assistance and offici... DT.ODA.ALLD.CD 781640000 1416770000 1330280000 1224640000 952720000 1046010000 ... 4.758051 4.799290 5.248723 6.055169 7.777843 14.230595 8.674907 8.786234 10.004318 6.530593
242 Uruguay URY Net official development assistance and offici... DT.ODA.ALLD.CD 17330000 -570000 1950000 12270000 4420000 320000 ... 5.239637 4.566001 4.123216 7.090853 8.739939 4.342655 6.326915 11.086202 9.940583 14.887971
243 United States USA Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
244 Uzbekistan UZB Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 7.535375 6.163965 7.488569 7.609225 9.506908 6.488707 5.636461 6.321647 6.860835 6.833553
245 St. Vincent and the Grenadines VCT Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 57.276847 75.192844 42.256126 59.804528 97.824285 70.713294 43.431153 603.879132 246.065336 281.558641
246 Venezuela, RB VEN Net official development assistance and offici... DT.ODA.ALLD.CD -7490000 -4880000 68890000 47720000 -51700000 3800000 ... 3.116248 1.796510 2.231422 3.144137 1.710119 1.882070 2.314379 2.811693 2.105951 2.320957
247 Virgin Islands (U.S.) VIR Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
248 Vietnam VNM Net official development assistance and offici... DT.ODA.ALLD.CD 191850000 167110000 176030000 226670000 244990000 314150000 ... 21.658386 18.213327 16.095561 22.019948 22.671441 23.223434 22.139882 29.813669 29.979571 43.379134
249 Vanuatu VUT Net official development assistance and offici... DT.ODA.ALLD.CD 150000 280000 410000 510000 650000 580000 ... 247.489976 167.525160 141.686002 164.914150 189.776373 188.561194 227.296021 257.680647 409.364768 447.033137
250 West Bank and Gaza PSE Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 234.245093 332.775810 315.932409 330.221945 358.657441 305.900260 399.329602 491.375580 686.765157 760.797987
251 World WLD Net official development assistance and offici... DT.ODA.ALLD.CD 4254390000 5219020000 5439680000 5962450000 5835340000 6242640000 ... 9.447816 9.523241 10.940539 12.463048 13.864458 16.709992 16.291665 16.263288 18.951657 18.603998
252 Samoa WSM Net official development assistance and offici... DT.ODA.ALLD.CD NaN 30000 90000 170000 210000 230000 ... 155.428545 243.952451 214.449126 185.561440 172.992382 242.041261 259.950407 205.607989 219.740084 418.561590
253 Yemen, Rep. YEM Net official development assistance and offici... DT.ODA.ALLD.CD 14690000 14880000 18080000 21580000 23330000 31540000 ... 17.764551 20.542996 11.683963 12.776903 13.584568 14.723684 13.910269 11.451145 19.794438 25.094890
254 South Africa ZAF Net official development assistance and offici... DT.ODA.ALLD.CD NaN NaN NaN NaN NaN NaN ... 11.053864 9.471220 11.160317 14.128220 13.379356 14.487960 14.812382 16.509628 22.702814 21.395378
255 Congo, Dem. Rep. COD Net official development assistance and offici... DT.ODA.ALLD.CD 82090000 91160000 120970000 111500000 127020000 142070000 ... 3.772585 5.094147 23.728840 106.273163 36.561421 34.828235 39.525938 23.723707 30.023782 38.965037
256 Zambia ZMB Net official development assistance and offici... DT.ODA.ALLD.CD 920000 910000 5880000 5380000 20990000 10860000 ... 78.670577 55.089023 76.357431 71.094465 101.163795 102.183762 124.561902 83.226394 89.610852 98.795863
257 Zimbabwe ZWE Net official development assistance and offici... DT.ODA.ALLD.CD NaN 10000 NaN 10860000 4570000 3720000 ... 14.047096 12.785654 15.729074 14.753293 14.736414 29.323582 21.866808 37.527786 47.905040 57.120388

258 rows × 170 columns

In [92]:
df_per_capita_2012 = df_aid_pop[['Country Code', 'Country Name_aid',
                            '2012_aid', '2012_pop', '2012_aid_per_capita']]
df_per_capita_2012
Out[92]:
Country Code Country Name_aid 2012_aid 2012_pop 2012_aid_per_capita
0 ABW Aruba NaN 102384 NaN
1 AND Andorra NaN 78360 NaN
2 AFG Afghanistan 6.725030e+09 29824536 225.486492
3 AGO Angola 2.423500e+08 20820525 11.639956
4 ALB Albania 3.416200e+08 2801681 121.933939
5 ANR Andean Region NaN NaN NaN
6 ARB Arab World 1.495131e+10 362466629 41.248790
7 ARE United Arab Emirates NaN 9205651 NaN
8 ARG Argentina 1.789200e+08 41086927 4.354670
9 ARM Armenia 2.727700e+08 2969081 91.870178
10 ASM American Samoa NaN 55128 NaN
11 ATG Antigua and Barbuda 2.350000e+06 89069 26.384039
12 AUS Australia NaN 22723900 NaN
13 AUT Austria NaN 8429991 NaN
14 AZE Azerbaijan 3.376100e+08 9295784 36.318615
15 BDI Burundi 5.227400e+08 9849569 53.072373
16 BEL Belgium NaN 11128246 NaN
17 BEN Benin 5.113300e+08 10050702 50.875053
18 BFA Burkina Faso 1.158540e+09 16460141 70.384573
19 BGD Bangladesh 2.152090e+09 154695368 13.911793
20 BGR Bulgaria NaN 7305888 NaN
21 BHR Bahrain NaN 1317827 NaN
22 BHS Bahamas, The NaN 371960 NaN
23 BIH Bosnia and Herzegovina 5.711300e+08 3833916 148.967792
24 BLR Belarus 1.032200e+08 9464000 10.906593
25 BLZ Belize 2.518000e+07 324060 77.701660
26 BMU Bermuda NaN 64798 NaN
27 BOL Bolivia 6.586300e+08 10496285 62.748868
28 BRA Brazil 1.288220e+09 198656019 6.484676
29 BRB Barbados NaN 283221 NaN
... ... ... ... ... ...
228 TGO Togo 2.414600e+08 6642928 36.348429
229 THA Thailand -1.347900e+08 66785001 -2.018268
230 TJK Tajikistan 3.939100e+08 8008990 49.183480
231 TKM Turkmenistan 3.803000e+07 5172931 7.351732
232 TLS Timor-Leste 2.830700e+08 1148958 246.371060
233 TON Tonga 7.826000e+07 104941 745.752375
234 TTO Trinidad and Tobago NaN 1337439 NaN
235 TUN Tunisia 1.017020e+09 10777500 94.365113
236 TUR Turkey 3.033130e+09 73997128 40.989834
237 TUV Tuvalu 2.449000e+07 9860 2483.772819
238 TZA Tanzania 2.831890e+09 47783107 59.265506
239 UGA Uganda 1.655190e+09 36345860 45.539987
240 UKR Ukraine 7.692300e+08 45593300 16.871558
241 UMC Upper middle income 1.559465e+10 2390210774 6.524383
242 URY Uruguay 1.932000e+07 3395253 5.690298
243 USA United States NaN 313873685 NaN
244 UZB Uzbekistan 2.552600e+08 29774500 8.573108
245 VCT St. Vincent and the Grenadines 8.560000e+06 109373 78.264288
246 VEN Venezuela, RB 4.813000e+07 29954782 1.606755
247 VIR Virgin Islands (U.S.) NaN 105275 NaN
248 VNM Vietnam 4.115780e+09 88772900 46.363023
249 VUT Vanuatu 1.014200e+08 247262 410.172206
250 PSE West Bank and Gaza 2.001390e+09 4046901 494.548792
251 WLD World 1.330394e+11 7043105591 18.889309
252 WSM Samoa 1.206700e+08 188889 638.840801
253 YEM Yemen, Rep. 7.093900e+08 23852409 29.740812
254 ZAF South Africa 1.067150e+09 52274945 20.414177
255 COD Congo, Dem. Rep. 2.859380e+09 65705093 43.518392
256 ZMB Zambia 9.577200e+08 14075099 68.043571
257 ZWE Zimbabwe 1.001220e+09 13724317 72.952264

258 rows × 5 columns

In [93]:
df_per_capita_2012.sort(columns=['2012_aid_per_capita'])
Out[93]:
Country Code Country Name_aid 2012_aid 2012_pop 2012_aid_per_capita
229 THA Thailand -134790000 66785001 -2.018268
42 CHN China -194130000 1350695000 -0.143726
71 EMU Euro area 0 333228712 0.000000
169 NAC North America 0 348692795 0.000000
76 EUU European Union 0 505640311 0.000000
37 CEB Central Europe and the Baltics 0 104429039 0.000000
187 PHL Philippines 5140000 96706764 0.053150
180 OEC High income: OECD 125510000 1049561526 0.119583
97 HIC High income 188330000 1299489520 0.144926
176 NOC High income: nonOECD 57780000 249927994 0.231187
104 IDN Indonesia 67810000 246864191 0.274685
168 MYS Malaysia 15370000 29239927 0.525651
106 IND India 1667630000 1236686732 1.348466
246 VEN Venezuela, RB 48130000 29954782 1.606755
109 IRN Iran, Islamic Rep. 148890000 76424443 1.948199
181 OED OECD members 3576450000 1254326493 2.851291
153 MEX Mexico 417810000 120847477 3.457333
64 DZA Algeria 144500000 38481705 3.755031
66 EAS East Asia & Pacific (all income levels) 8796050000 2233723905 3.937841
192 PRK Korea, Dem. Rep. 98140000 24763188 3.963141
8 ARG Argentina 178920000 41086927 4.354670
65 EAP East Asia & Pacific (developing only) 8796050000 1991555125 4.416674
242 URY Uruguay 19320000 3395253 5.690298
28 BRA Brazil 1288220000 198656019 6.484676
241 UMC Upper middle income 15594650000 2390210774 6.524383
51 CRI Costa Rica 32700000 4805295 6.804993
41 CHL Chile 125510000 17464814 7.186449
231 TKM Turkmenistan 38030000 5172931 7.351732
117 KAZ Kazakhstan 129640000 16791425 7.720607
114 JAM Jamaica 21050000 2707805 7.773824
... ... ... ... ... ...
144 MAC Macao SAR, China NaN 556783 NaN
145 MAF St. Martin (French part) NaN 30959 NaN
147 MCA Mexico and Central America NaN NaN NaN
148 MCO Monaco NaN 37579 NaN
158 MLT Malta NaN 419455 NaN
163 MNP Northern Mariana Islands NaN 53305 NaN
171 NCL New Caledonia NaN 258000 NaN
175 NLD Netherlands NaN 16754962 NaN
177 NOR Norway NaN 5018573 NaN
179 NZL New Zealand NaN 4433000 NaN
182 OMN Oman NaN 3314001 NaN
190 POL Poland NaN 38535873 NaN
191 PRI Puerto Rico NaN 3651545 NaN
193 PRT Portugal NaN 10514844 NaN
196 PYF French Polynesia NaN 273814 NaN
197 QAT Qatar NaN 2050514 NaN
198 ROU Romania NaN 20076727 NaN
199 RUS Russian Federation NaN 143178000 NaN
202 SAU Saudi Arabia NaN 28287855 NaN
203 SCE Southern Cone Extended NaN NaN NaN
206 SGP Singapore NaN 5312400 NaN
210 SMR San Marino NaN 31247 NaN
219 SVK Slovak Republic NaN 5407579 NaN
220 SVN Slovenia NaN 2057159 NaN
221 SWE Sweden NaN 9519374 NaN
223 SXM Sint Maarten (Dutch part) NaN 39088 NaN
226 TCA Turks and Caicos Islands NaN 32427 NaN
234 TTO Trinidad and Tobago NaN 1337439 NaN
243 USA United States NaN 313873685 NaN
247 VIR Virgin Islands (U.S.) NaN 105275 NaN

258 rows × 5 columns

In [94]:
df_per_capita_2012.sort(columns=['2012_aid_per_capita'], ascending=False)
Out[94]:
Country Code Country Name_aid 2012_aid 2012_pop 2012_aid_per_capita
237 TUV Tuvalu 24490000 9860 2483.772819
154 MHL Marshall Islands 76010000 52555 1446.294358
82 FSM Micronesia, Fed. Sts. 115040000 103395 1112.626336
233 TON Tonga 78260000 104941 745.752375
188 PLW Palau 15000000 20754 722.752241
121 KIR Kiribati 64660000 100786 641.557359
252 WSM Samoa 120670000 188889 638.840801
207 SLB Solomon Islands 304980000 549598 554.914683
50 CPV Cabo Verde 246140000 494401 497.854980
250 PSE West Bank and Gaza 2001390000 4046901 494.548792
195 PSS Pacific island small states 1007870000 2252782 447.389051
249 VUT Vanuatu 101420000 247262 410.172206
122 KNA St. Kitts and Nevis 21910000 53584 408.890714
224 SYC Seychelles 35330000 88303 400.099657
61 DMA Dominica 25660000 71684 357.959935
124 KSV Kosovo 567680000 1807106 314.137632
217 STP Sao Tome and Principe 48790000 188098 259.386065
232 TLS Timor-Leste 283070000 1148958 246.371060
2 AFG Afghanistan 6725030000 29824536 225.486492
115 JOR Jordan 1416970000 6318000 224.275087
31 BTN Bhutan 161280000 741822 217.410646
151 MDV Maldives 58010000 338442 171.403076
60 DJI Djibouti 146590000 859652 170.522490
161 MNE Montenegro 103220000 621081 166.194104
128 LBN Lebanon 710240000 4424888 160.510277
162 MNG Mongolia 448780000 2796484 160.480089
212 SRB Serbia 1089870000 7199077 151.390241
23 BIH Bosnia and Herzegovina 571130000 3833916 148.967792
131 LCA St. Lucia 26840000 180870 148.393874
85 GEO Georgia 662210000 4490700 147.462534
... ... ... ... ... ...
144 MAC Macao SAR, China NaN 556783 NaN
145 MAF St. Martin (French part) NaN 30959 NaN
147 MCA Mexico and Central America NaN NaN NaN
148 MCO Monaco NaN 37579 NaN
158 MLT Malta NaN 419455 NaN
163 MNP Northern Mariana Islands NaN 53305 NaN
171 NCL New Caledonia NaN 258000 NaN
175 NLD Netherlands NaN 16754962 NaN
177 NOR Norway NaN 5018573 NaN
179 NZL New Zealand NaN 4433000 NaN
182 OMN Oman NaN 3314001 NaN
190 POL Poland NaN 38535873 NaN
191 PRI Puerto Rico NaN 3651545 NaN
193 PRT Portugal NaN 10514844 NaN
196 PYF French Polynesia NaN 273814 NaN
197 QAT Qatar NaN 2050514 NaN
198 ROU Romania NaN 20076727 NaN
199 RUS Russian Federation NaN 143178000 NaN
202 SAU Saudi Arabia NaN 28287855 NaN
203 SCE Southern Cone Extended NaN NaN NaN
206 SGP Singapore NaN 5312400 NaN
210 SMR San Marino NaN 31247 NaN
219 SVK Slovak Republic NaN 5407579 NaN
220 SVN Slovenia NaN 2057159 NaN
221 SWE Sweden NaN 9519374 NaN
223 SXM Sint Maarten (Dutch part) NaN 39088 NaN
226 TCA Turks and Caicos Islands NaN 32427 NaN
234 TTO Trinidad and Tobago NaN 1337439 NaN
243 USA United States NaN 313873685 NaN
247 VIR Virgin Islands (U.S.) NaN 105275 NaN

258 rows × 5 columns

In [95]:
df_per_capita_2012[
    df_per_capita_2012['2012_aid_per_capita']
    .isnull()
]
Out[95]:
Country Code Country Name_aid 2012_aid 2012_pop 2012_aid_per_capita
0 ABW Aruba NaN 102384 NaN
1 AND Andorra NaN 78360 NaN
5 ANR Andean Region NaN NaN NaN
7 ARE United Arab Emirates NaN 9205651 NaN
10 ASM American Samoa NaN 55128 NaN
12 AUS Australia NaN 22723900 NaN
13 AUT Austria NaN 8429991 NaN
16 BEL Belgium NaN 11128246 NaN
20 BGR Bulgaria NaN 7305888 NaN
21 BHR Bahrain NaN 1317827 NaN
22 BHS Bahamas, The NaN 371960 NaN
26 BMU Bermuda NaN 64798 NaN
29 BRB Barbados NaN 283221 NaN
30 BRN Brunei Darussalam NaN 412238 NaN
33 CAA Sub-Saharan Africa (IFC classification) NaN NaN NaN
35 CAN Canada NaN 34754312 NaN
36 CEA East Asia and the Pacific (IFC classification) NaN NaN NaN
38 CEU Europe and Central Asia (IFC classification) NaN NaN NaN
39 CHE Switzerland NaN 7996861 NaN
40 CHI Channel Islands NaN 161235 NaN
44 CLA Latin America and the Caribbean (IFC classific... NaN NaN NaN
45 CME Middle East and North Africa (IFC classification) NaN NaN NaN
52 CSA South Asia (IFC classification) NaN NaN NaN
55 CUW Curacao NaN 152056 NaN
56 CYM Cayman Islands NaN 57570 NaN
57 CYP Cyprus NaN 1128994 NaN
58 CZE Czech Republic NaN 10510785 NaN
59 DEU Germany NaN 80425823 NaN
62 DNK Denmark NaN 5591572 NaN
73 ESP Spain NaN 46761264 NaN
... ... ... ... ... ...
144 MAC Macao SAR, China NaN 556783 NaN
145 MAF St. Martin (French part) NaN 30959 NaN
147 MCA Mexico and Central America NaN NaN NaN
148 MCO Monaco NaN 37579 NaN
158 MLT Malta NaN 419455 NaN
163 MNP Northern Mariana Islands NaN 53305 NaN
171 NCL New Caledonia NaN 258000 NaN
175 NLD Netherlands NaN 16754962 NaN
177 NOR Norway NaN 5018573 NaN
179 NZL New Zealand NaN 4433000 NaN
182 OMN Oman NaN 3314001 NaN
190 POL Poland NaN 38535873 NaN
191 PRI Puerto Rico NaN 3651545 NaN
193 PRT Portugal NaN 10514844 NaN
196 PYF French Polynesia NaN 273814 NaN
197 QAT Qatar NaN 2050514 NaN
198 ROU Romania NaN 20076727 NaN
199 RUS Russian Federation NaN 143178000 NaN
202 SAU Saudi Arabia NaN 28287855 NaN
203 SCE Southern Cone Extended NaN NaN NaN
206 SGP Singapore NaN 5312400 NaN
210 SMR San Marino NaN 31247 NaN
219 SVK Slovak Republic NaN 5407579 NaN
220 SVN Slovenia NaN 2057159 NaN
221 SWE Sweden NaN 9519374 NaN
223 SXM Sint Maarten (Dutch part) NaN 39088 NaN
226 TCA Turks and Caicos Islands NaN 32427 NaN
234 TTO Trinidad and Tobago NaN 1337439 NaN
243 USA United States NaN 313873685 NaN
247 VIR Virgin Islands (U.S.) NaN 105275 NaN

85 rows × 5 columns

In [96]:
(df_per_capita_2012[
    df_per_capita_2012['2012_aid_per_capita']
    .notnull()
].sort('2012_aid_per_capita', ascending=False))
Out[96]:
Country Code Country Name_aid 2012_aid 2012_pop 2012_aid_per_capita
237 TUV Tuvalu 24490000 9860 2483.772819
154 MHL Marshall Islands 76010000 52555 1446.294358
82 FSM Micronesia, Fed. Sts. 115040000 103395 1112.626336
233 TON Tonga 78260000 104941 745.752375
188 PLW Palau 15000000 20754 722.752241
121 KIR Kiribati 64660000 100786 641.557359
252 WSM Samoa 120670000 188889 638.840801
207 SLB Solomon Islands 304980000 549598 554.914683
50 CPV Cabo Verde 246140000 494401 497.854980
250 PSE West Bank and Gaza 2001390000 4046901 494.548792
195 PSS Pacific island small states 1007870000 2252782 447.389051
249 VUT Vanuatu 101420000 247262 410.172206
122 KNA St. Kitts and Nevis 21910000 53584 408.890714
224 SYC Seychelles 35330000 88303 400.099657
61 DMA Dominica 25660000 71684 357.959935
124 KSV Kosovo 567680000 1807106 314.137632
217 STP Sao Tome and Principe 48790000 188098 259.386065
232 TLS Timor-Leste 283070000 1148958 246.371060
2 AFG Afghanistan 6725030000 29824536 225.486492
115 JOR Jordan 1416970000 6318000 224.275087
31 BTN Bhutan 161280000 741822 217.410646
151 MDV Maldives 58010000 338442 171.403076
60 DJI Djibouti 146590000 859652 170.522490
161 MNE Montenegro 103220000 621081 166.194104
128 LBN Lebanon 710240000 4424888 160.510277
162 MNG Mongolia 448780000 2796484 160.480089
212 SRB Serbia 1089870000 7199077 151.390241
23 BIH Bosnia and Herzegovina 571130000 3833916 148.967792
131 LCA St. Lucia 26840000 180870 148.393874
85 GEO Georgia 662210000 4490700 147.462534
... ... ... ... ... ...
114 JAM Jamaica 21050000 2707805 7.773824
117 KAZ Kazakhstan 129640000 16791425 7.720607
231 TKM Turkmenistan 38030000 5172931 7.351732
41 CHL Chile 125510000 17464814 7.186449
51 CRI Costa Rica 32700000 4805295 6.804993
241 UMC Upper middle income 15594650000 2390210774 6.524383
28 BRA Brazil 1288220000 198656019 6.484676
242 URY Uruguay 19320000 3395253 5.690298
65 EAP East Asia & Pacific (developing only) 8796050000 1991555125 4.416674
8 ARG Argentina 178920000 41086927 4.354670
192 PRK Korea, Dem. Rep. 98140000 24763188 3.963141
66 EAS East Asia & Pacific (all income levels) 8796050000 2233723905 3.937841
64 DZA Algeria 144500000 38481705 3.755031
153 MEX Mexico 417810000 120847477 3.457333
181 OED OECD members 3576450000 1254326493 2.851291
109 IRN Iran, Islamic Rep. 148890000 76424443 1.948199
246 VEN Venezuela, RB 48130000 29954782 1.606755
106 IND India 1667630000 1236686732 1.348466
168 MYS Malaysia 15370000 29239927 0.525651
104 IDN Indonesia 67810000 246864191 0.274685
176 NOC High income: nonOECD 57780000 249927994 0.231187
97 HIC High income 188330000 1299489520 0.144926
180 OEC High income: OECD 125510000 1049561526 0.119583
187 PHL Philippines 5140000 96706764 0.053150
169 NAC North America 0 348692795 0.000000
76 EUU European Union 0 505640311 0.000000
37 CEB Central Europe and the Baltics 0 104429039 0.000000
71 EMU Euro area 0 333228712 0.000000
42 CHN China -194130000 1350695000 -0.143726
229 THA Thailand -134790000 66785001 -2.018268

173 rows × 5 columns

In [98]:
!pwd
path = None  # "wb_aid_per_capita_2012.csv"
print(df_per_capita_2012.to_csv(path))
/Users/W/Downloads
,Country Code,Country Name_aid,2012_aid,2012_pop,2012_aid_per_capita
0,ABW,Aruba,,102384.0,
1,AND,Andorra,,78360.0,
2,AFG,Afghanistan,6725030000.0,29824536.0,225.4864920614356
3,AGO,Angola,242350000.0,20820525.0,11.639956245099487
4,ALB,Albania,341620000.0,2801681.0,121.93393894593996
5,ANR,Andean Region,,,
6,ARB,Arab World,14951310000.0,362466629.0,41.24879038174849
7,ARE,United Arab Emirates,,9205651.0,
8,ARG,Argentina,178920000.0,41086927.0,4.354669795577557
9,ARM,Armenia,272770000.0,2969081.0,91.87017801131057
10,ASM,American Samoa,,55128.0,
11,ATG,Antigua and Barbuda,2350000.0,89069.0,26.384039340286744
12,AUS,Australia,,22723900.0,
13,AUT,Austria,,8429991.0,
14,AZE,Azerbaijan,337610000.0,9295784.0,36.31861497642372
15,BDI,Burundi,522740000.0,9849569.0,53.07237301449434
16,BEL,Belgium,,11128246.0,
17,BEN,Benin,511330000.0,10050702.0,50.87505330473434
18,BFA,Burkina Faso,1158540000.0,16460141.0,70.38457325487066
19,BGD,Bangladesh,2152090000.0,154695368.0,13.911793402889737
20,BGR,Bulgaria,,7305888.0,
21,BHR,Bahrain,,1317827.0,
22,BHS,"Bahamas, The",,371960.0,
23,BIH,Bosnia and Herzegovina,571130000.0,3833916.0,148.96779167827358
24,BLR,Belarus,103220000.0,9464000.0,10.906593406593407
25,BLZ,Belize,25180000.0,324060.0,77.70166018638524
26,BMU,Bermuda,,64798.0,
27,BOL,Bolivia,658630000.0,10496285.0,62.74886781370742
28,BRA,Brazil,1288220000.0,198656019.0,6.484676409427091
29,BRB,Barbados,,283221.0,
30,BRN,Brunei Darussalam,,412238.0,
31,BTN,Bhutan,161280000.0,741822.0,217.41064568050018
32,BWA,Botswana,73860000.0,2003910.0,36.85794272197853
33,CAA,Sub-Saharan Africa (IFC classification),,,
34,CAF,Central African Republic,227250000.0,4525209.0,50.218674982746656
35,CAN,Canada,,34754312.0,
36,CEA,East Asia and the Pacific (IFC classification),,,
37,CEB,Central Europe and the Baltics,0.0,104429039.0,0.0
38,CEU,Europe and Central Asia (IFC classification),,,
39,CHE,Switzerland,,7996861.0,
40,CHI,Channel Islands,,161235.0,
41,CHL,Chile,125510000.0,17464814.0,7.186449280249993
42,CHN,China,-194130000.0,1350695000.0,-0.14372600772195054
43,CIV,Cote d'Ivoire,2635630000.0,19839750.0,132.84592799808465
44,CLA,Latin America and the Caribbean (IFC classification),,,
45,CME,Middle East and North Africa (IFC classification),,,
46,CMR,Cameroon,596240000.0,21699631.0,27.476964930878317
47,COG,"Congo, Rep.",138600000.0,4337051.0,31.95719856649138
48,COL,Colombia,764470000.0,47704427.0,16.025137457368473
49,COM,Comoros,68670000.0,717503.0,95.70691690487705
50,CPV,Cabo Verde,246140000.0,494401.0,497.8549800667879
51,CRI,Costa Rica,32700000.0,4805295.0,6.804993241830106
52,CSA,South Asia (IFC classification),,,
53,CSS,Caribbean small states,293250000.0,6964458.0,42.106650653934594
54,CUB,Cuba,87850000.0,11270957.0,7.794369191542475
55,CUW,Curacao,,152056.0,
56,CYM,Cayman Islands,,57570.0,
57,CYP,Cyprus,,1128994.0,
58,CZE,Czech Republic,,10510785.0,
59,DEU,Germany,,80425823.0,
60,DJI,Djibouti,146590000.0,859652.0,170.52249049615426
61,DMA,Dominica,25660000.0,71684.0,357.95993527146925
62,DNK,Denmark,,5591572.0,
63,DOM,Dominican Republic,261300000.0,10276621.0,25.426645587104943
64,DZA,Algeria,144500000.0,38481705.0,3.755031124530475
65,EAP,East Asia & Pacific (developing only),8796050000.0,1991555125.0,4.416674130473792
66,EAS,East Asia & Pacific (all income levels),8796050000.0,2233723905.0,3.9378411899119645
67,ECA,Europe & Central Asia (developing only),9969870000.0,270395971.0,36.87137039479039
68,ECS,Europe & Central Asia (all income levels),9969870000.0,895364677.0,11.134982489375108
69,ECU,Ecuador,149430000.0,15492264.0,9.645459178852104
70,EGY,"Egypt, Arab Rep.",1806630000.0,80721874.0,22.380922425066593
71,EMU,Euro area,0.0,333228712.0,0.0
72,ERI,Eritrea,133780000.0,6130922.0,21.82053531263324
73,ESP,Spain,,46761264.0,
74,EST,Estonia,,1325016.0,
75,ETH,Ethiopia,3261320000.0,91728849.0,35.55391826621525
76,EUU,European Union,0.0,505640311.0,0.0
77,FCS,Fragile and conflict affected situations,30482720000.0,436224882.0,69.8784531965327
78,FIN,Finland,,5413971.0,
79,FJI,Fiji,107340000.0,874742.0,122.71046777221169
80,FRA,France,,65676758.0,
81,FRO,Faeroe Islands,,49506.0,
82,FSM,"Micronesia, Fed. Sts.",115040000.0,103395.0,1112.62633589632
83,GAB,Gabon,73200000.0,1632572.0,44.83722616827926
84,GBR,United Kingdom,,63695687.0,
85,GEO,Georgia,662210000.0,4490700.0,147.46253368071794
86,GHA,Ghana,1807910000.0,25366462.0,71.27166571357094
87,GIN,Guinea,339650000.0,11451273.0,29.660457837307696
88,GMB,"Gambia, The",138800000.0,1791225.0,77.4888693491884
89,GNB,Guinea-Bissau,78870000.0,1663558.0,47.41042993391273
90,GNQ,Equatorial Guinea,14200000.0,736296.0,19.285722046568228
91,GRC,Greece,,11092771.0,
92,GRD,Grenada,7650000.0,105483.0,72.5235345979921
93,GRL,Greenland,,56810.0,
94,GTM,Guatemala,299430000.0,15082831.0,19.852373868009263
95,GUM,Guam,,162810.0,
96,GUY,Guyana,114450000.0,795369.0,143.89547493050395
97,HIC,High income,188330000.0,1299489520.0,0.14492613991992795
98,HKG,"Hong Kong SAR, China",,7154600.0,
99,HND,Honduras,571530000.0,7935846.0,72.01878665488216
100,HPC,Heavily indebted poor countries (HIPC),41486050000.0,655971763.0,63.24365215092345
101,HRV,Croatia,,4267558.0,
102,HTI,Haiti,1275190000.0,10173775.0,125.34088870650275
103,HUN,Hungary,,9920362.0,
104,IDN,Indonesia,67810000.0,246864191.0,0.27468544435430087
105,IMN,Isle of Man,,85284.0,
106,IND,India,1667630000.0,1236686732.0,1.3484659913049022
107,INX,Not classified,,,
108,IRL,Ireland,,4586897.0,
109,IRN,"Iran, Islamic Rep.",148890000.0,76424443.0,1.9481986934468074
110,IRQ,Iraq,1300790000.0,32578209.0,39.92822318746865
111,ISL,Iceland,,320716.0,
112,ISR,Israel,,7910500.0,
113,ITA,Italy,,59539717.0,
114,JAM,Jamaica,21050000.0,2707805.0,7.77382418601044
115,JOR,Jordan,1416970000.0,6318000.0,224.27508705286482
116,JPN,Japan,,127561489.0,
117,KAZ,Kazakhstan,129640000.0,16791425.0,7.720607393357026
118,KEN,Kenya,2654080000.0,43178141.0,61.46813963111566
119,KGZ,Kyrgyz Republic,472910000.0,5607200.0,84.33977742901983
120,KHM,Cambodia,807410000.0,14864646.0,54.31747247798568
121,KIR,Kiribati,64660000.0,100786.0,641.5573591570258
122,KNA,St. Kitts and Nevis,21910000.0,53584.0,408.8907136458644
123,KOR,"Korea, Rep.",,50004441.0,
124,KSV,Kosovo,567680000.0,1807106.0,314.137632214159
125,KWT,Kuwait,,3250496.0,
126,LAC,Latin America & Caribbean (developing only),10091280000.0,581379260.0,17.357481930125957
127,LAO,Lao PDR,408920000.0,6645827.0,61.530340768726
128,LBN,Lebanon,710240000.0,4424888.0,160.51027732227348
129,LBR,Liberia,570970000.0,4190435.0,136.2555438755165
130,LBY,Libya,87090000.0,6154623.0,14.150338696618785
131,LCA,St. Lucia,26840000.0,180870.0,148.39387405318737
132,LCN,Latin America & Caribbean (all income levels),10265410000.0,608545904.0,16.8687521064968
133,LCR,Latin America and the Caribbean,,,
134,LDC,Least developed countries: UN classification,42985980000.0,877943413.0,48.96213054678958
135,LIC,Low income,39333080000.0,830035274.0,47.38723911147901
136,LIE,Liechtenstein,,36656.0,
137,LKA,Sri Lanka,487500000.0,20328000.0,23.981700118063756
138,LMC,Lower middle income,38963950000.0,2523370023.0,15.441235191371694
139,LMY,Low & middle income,132851000000.0,5743616071.0,23.130202011721476
140,LSO,Lesotho,282680000.0,2051545.0,137.78883719343227
141,LTU,Lithuania,,2987773.0,
142,LUX,Luxembourg,,530946.0,
143,LVA,Latvia,,2034319.0,
144,MAC,"Macao SAR, China",,556783.0,
145,MAF,St. Martin (French part),,30959.0,
146,MAR,Morocco,1480360000.0,32521143.0,45.51992529905852
147,MCA,Mexico and Central America,,,
148,MCO,Monaco,,37579.0,
149,MDA,Moldova,473080000.0,3559519.0,132.9055976383326
150,MDG,Madagascar,378690000.0,22293914.0,16.98625014880743
151,MDV,Maldives,58010000.0,338442.0,171.40307645032237
152,MEA,Middle East & North Africa (all income levels),13893580000.0,395316900.0,35.14542383591493
153,MEX,Mexico,417810000.0,120847477.0,3.4573332466014164
154,MHL,Marshall Islands,76010000.0,52555.0,1446.2943582913138
155,MIC,Middle income,55583690000.0,4913580797.0,11.31225725115516
156,MKD,"Macedonia, FYR",148940000.0,2105575.0,70.73602222670768
157,MLI,Mali,1001300000.0,14853572.0,67.41139437705624
158,MLT,Malta,,419455.0,
159,MMR,Myanmar,504050000.0,52797319.0,9.546886272766994
160,MNA,Middle East & North Africa (developing only),13893580000.0,339560601.0,40.91634883164787
161,MNE,Montenegro,103220000.0,621081.0,166.19410350662795
162,MNG,Mongolia,448780000.0,2796484.0,160.4800885683594
163,MNP,Northern Mariana Islands,,53305.0,
164,MOZ,Mozambique,2096920000.0,25203395.0,83.19990223539328
165,MRT,Mauritania,408310000.0,3796141.0,107.55922922778684
166,MUS,Mauritius,177890000.0,1291167.0,137.77458686599022
167,MWI,Malawi,1174600000.0,15906483.0,73.84410494764933
168,MYS,Malaysia,15370000.0,29239927.0,0.525651107131697
169,NAC,North America,0.0,348692795.0,0.0
170,NAM,Namibia,264860000.0,2259393.0,117.22617534886582
171,NCL,New Caledonia,,258000.0,
172,NER,Niger,901870000.0,17157042.0,52.56558793759437
173,NGA,Nigeria,1915820000.0,168833776.0,11.347373999382683
174,NIC,Nicaragua,532380000.0,5991733.0,88.85242383130223
175,NLD,Netherlands,,16754962.0,
176,NOC,High income: nonOECD,57780000.0,249927994.0,0.23118658728561636
177,NOR,Norway,,5018573.0,
178,NPL,Nepal,769720000.0,27474377.0,28.015921889693804
179,NZL,New Zealand,,4433000.0,
180,OEC,High income: OECD,125510000.0,1049561526.0,0.11958327062381287
181,OED,OECD members,3576450000.0,1254326493.0,2.851291127118049
182,OMN,Oman,,3314001.0,
183,OSS,Other small states,2343610000.0,19858911.0,118.01301692726253
184,PAK,Pakistan,2019060000.0,179160111.0,11.269584444497246
185,PAN,Panama,50770000.0,3802281.0,13.352511295193596
186,PER,Peru,393820000.0,29987800.0,13.132673954074656
187,PHL,Philippines,5140000.0,96706764.0,0.0531503670208632
188,PLW,Palau,15000000.0,20754.0,722.7522405319456
189,PNG,Papua New Guinea,664840000.0,7167010.0,92.7639280536793
190,POL,Poland,,38535873.0,
191,PRI,Puerto Rico,,3651545.0,
192,PRK,"Korea, Dem. Rep.",98140000.0,24763188.0,3.963140771697085
193,PRT,Portugal,,10514844.0,
194,PRY,Paraguay,104410000.0,6687361.0,15.61303479803169
195,PSS,Pacific island small states,1007870000.0,2252782.0,447.38905051620617
196,PYF,French Polynesia,,273814.0,
197,QAT,Qatar,,2050514.0,
198,ROU,Romania,,20076727.0,
199,RUS,Russian Federation,,143178000.0,
200,RWA,Rwanda,878990000.0,11457801.0,76.71541860432032
201,SAS,South Asia,14170540000.0,1649249388.0,8.59211475420599
202,SAU,Saudi Arabia,,28287855.0,
203,SCE,Southern Cone Extended,,,
204,SDN,Sudan,983220000.0,37195349.0,26.433950115644834
205,SEN,Senegal,1080180000.0,13726021.0,78.69578518057054
206,SGP,Singapore,,5312400.0,
207,SLB,Solomon Islands,304980000.0,549598.0,554.9146830956445
208,SLE,Sierra Leone,442820000.0,5978727.0,74.06593410269444
209,SLV,El Salvador,230400000.0,6297394.0,36.58656263209829
210,SMR,San Marino,,31247.0,
211,SOM,Somalia,998620000.0,10195134.0,97.9506497903804
212,SRB,Serbia,1089870000.0,7199077.0,151.39024072113688
213,SSA,Sub-Saharan Africa (developing only),46273770000.0,911475726.0,50.767967462032004
214,SSD,South Sudan,1578000000.0,10837527.0,145.6051735788063
215,SSF,Sub-Saharan Africa (all income levels),46287970000.0,912212022.0,50.74255642730392
216,SST,Small states,3644730000.0,29076151.0,125.35118558161292
217,STP,Sao Tome and Principe,48790000.0,188098.0,259.3860647109486
218,SUR,Suriname,39600000.0,534541.0,74.0822500051446
219,SVK,Slovak Republic,,5407579.0,
220,SVN,Slovenia,,2057159.0,
221,SWE,Sweden,,9519374.0,
222,SWZ,Swaziland,88150000.0,1230985.0,71.60932099091379
223,SXM,Sint Maarten (Dutch part),,39088.0,
224,SYC,Seychelles,35330000.0,88303.0,400.09965686330025
225,SYR,Syrian Arab Republic,1671520000.0,22399254.0,74.62391381427257
226,TCA,Turks and Caicos Islands,,32427.0,
227,TCD,Chad,478590000.0,12448175.0,38.446599601949686
228,TGO,Togo,241460000.0,6642928.0,36.348429487719876
229,THA,Thailand,-134790000.0,66785001.0,-2.0182675448339067
230,TJK,Tajikistan,393910000.0,8008990.0,49.18348006427777
231,TKM,Turkmenistan,38030000.0,5172931.0,7.351731542523958
232,TLS,Timor-Leste,283070000.0,1148958.0,246.37105969060661
233,TON,Tonga,78260000.0,104941.0,745.7523751441286
234,TTO,Trinidad and Tobago,,1337439.0,
235,TUN,Tunisia,1017020000.0,10777500.0,94.36511250289956
236,TUR,Turkey,3033130000.0,73997128.0,40.98983409193935
237,TUV,Tuvalu,24490000.0,9860.0,2483.7728194726164
238,TZA,Tanzania,2831890000.0,47783107.0,59.26550569430322
239,UGA,Uganda,1655190000.0,36345860.0,45.539987222753844
240,UKR,Ukraine,769230000.0,45593300.0,16.871557882408162
241,UMC,Upper middle income,15594650000.0,2390210774.0,6.5243827739519675
242,URY,Uruguay,19320000.0,3395253.0,5.690297600797349
243,USA,United States,,313873685.0,
244,UZB,Uzbekistan,255260000.0,29774500.0,8.573107860753328
245,VCT,St. Vincent and the Grenadines,8560000.0,109373.0,78.26428826127106
246,VEN,"Venezuela, RB",48130000.0,29954782.0,1.6067551418000638
247,VIR,Virgin Islands (U.S.),,105275.0,
248,VNM,Vietnam,4115780000.0,88772900.0,46.363022949571324
249,VUT,Vanuatu,101420000.0,247262.0,410.17220600011325
250,PSE,West Bank and Gaza,2001390000.0,4046901.0,494.54879177919105
251,WLD,World,133039400000.0,7043105591.0,18.88930930838291
252,WSM,Samoa,120670000.0,188889.0,638.840800681882
253,YEM,"Yemen, Rep.",709390000.0,23852409.0,29.74081150461574
254,ZAF,South Africa,1067150000.0,52274945.0,20.414177384596005
255,COD,"Congo, Dem. Rep.",2859380000.0,65705093.0,43.51839209785457
256,ZMB,Zambia,957720000.0,14075099.0,68.04357113225278
257,ZWE,Zimbabwe,1001220000.0,13724317.0,72.95226421832139


In []: