{ "metadata": { "name": "", "signature": "sha256:fd65daf14f9dfc883408c40ce1cc3c8702a60457a2232d1a9f7959e6a9710d2e" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "code", "collapsed": false, "input": [ "# This is my notebook for exploring data about economic inequality in Cambodia.\n", "\n", "%matplotlib inline\n", "import pandas as pd\n", "import matplotlib as mp\n", "import matplotlib.pyplot as plt\n", "import qgrid\n", "from pylab import *\n", "import seaborn as sb\n", "\n", "# Hey, good news! We can remotely access the World Bank's World Development Indicators Database\n", "# directly from pandas!\n", "\n", "from pandas.io import wb" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 1 }, { "cell_type": "code", "collapsed": false, "input": [ "# First, search the database for all poverty-related indicator names and store them.\n", "# I didn't use qgrid because it wouldn't display the id column correctly for some reason. It'd look nicer if it worked, though.\n", "\n", "pov = wb.search('pov.*%').iloc[:,:2]\n", "pov" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", " | id | \n", "name | \n", "
---|---|---|
5453 | \n", "IN.POV.HCR.EST.RURL | \n", "Poverty HCR Estimates (%) - Rural | \n", "
5454 | \n", "IN.POV.HCR.EST.TOTL | \n", "Poverty HCR Estimates (%) - Total | \n", "
5455 | \n", "IN.POV.HCR.EST.URBN | \n", "Poverty HCR Estimates (%) - Urban | \n", "
7529 | \n", "SI.POV.25DAY | \n", "Poverty headcount ratio at $2.5 a day (PPP) (%... | \n", "
7530 | \n", "SI.POV.2DAY | \n", "Poverty headcount ratio at $2 a day (PPP) (% o... | \n", "
7531 | \n", "SI.POV.4DAY | \n", "Poverty headcount ratio at $4 a day (PPP) (% o... | \n", "
7532 | \n", "SI.POV.5DAY | \n", "Poverty headcount ratio at $5 a day (PPP) (% o... | \n", "
7533 | \n", "SI.POV.DDAY | \n", "Poverty headcount ratio at $1.25 a day (PPP) (... | \n", "
7534 | \n", "SI.POV.GAP2 | \n", "Poverty gap at $2 a day (PPP) (%) | \n", "
7535 | \n", "SI.POV.GAP25 | \n", "Poverty gap at $2.5 a day (PPP) (%) | \n", "
7536 | \n", "SI.POV.GAP4 | \n", "Poverty gap at $4 a day (PPP) (%) | \n", "
7537 | \n", "SI.POV.GAP5 | \n", "Poverty gap at $5 a day (PPP) (%) | \n", "
7538 | \n", "SI.POV.GAPS | \n", "Poverty gap at $1.25 a day (PPP) (%) | \n", "
7540 | \n", "SI.POV.NAGP | \n", "Poverty gap at national poverty lines (%) | \n", "
7541 | \n", "SI.POV.NAHC | \n", "Poverty headcount ratio at national poverty li... | \n", "
7547 | \n", "SI.POV.RUGP | \n", "Rural poverty gap at national poverty lines (%) | \n", "
7548 | \n", "SI.POV.RUHC | \n", "Rural poverty headcount ratio at national pove... | \n", "
7549 | \n", "SI.POV.URGP | \n", "Urban poverty gap at national poverty lines (%) | \n", "
7550 | \n", "SI.POV.URHC | \n", "Urban poverty headcount ratio at national pove... | \n", "
10162 | \n", "ccx_povchi_40_fem | \n", "Poverty headcount of children (below bottom 40... | \n", "
10163 | \n", "ccx_povchi_40_mal | \n", "Poverty headcount of children (below bottom 40... | \n", "
10164 | \n", "ccx_povchi_40_rur | \n", "Poverty headcount of children (below bottom 40... | \n", "
10165 | \n", "ccx_povchi_40_tot | \n", "Poverty headcount of children (below bottom 40%) | \n", "
10166 | \n", "ccx_povchi_40_urb | \n", "Poverty headcount of children (below bottom 40... | \n", "
10167 | \n", "ccx_poveld_40_fem | \n", "Poverty headcount of the elderly (below bottom... | \n", "
10168 | \n", "ccx_poveld_40_mal | \n", "Poverty headcount of the elderly (below bottom... | \n", "
10169 | \n", "ccx_poveld_40_rur | \n", "Poverty headcount of the elderly (below bottom... | \n", "
10170 | \n", "ccx_poveld_40_tot | \n", "Poverty headcount of the elderly (below bottom... | \n", "
10171 | \n", "ccx_poveld_40_urb | \n", "Poverty headcount of the elderly (below bottom... | \n", "
10172 | \n", "ccx_povwka_40_fem | \n", "Poverty headcount of working age adults (below... | \n", "
... | \n", "... | \n", "... | \n", "
12761 | \n", "per_si_allsi_p1_ep_preT_tot | \n", "Poverty Gap reduction (%) - All Social Insura... | \n", "
12762 | \n", "per_si_allsi_p1_ep_tot | \n", "Poverty Gap reduction (%) - All Social Insura... | \n", "
12763 | \n", "per_si_allsi_p1_preT_tot | \n", "Poverty Gap reduction (%) - All Social Insura... | \n", "
12764 | \n", "per_si_allsi_p1_rur | \n", "Poverty Gap reduction (%) - All Social Insura... | \n", "
12765 | \n", "per_si_allsi_p1_tot | \n", "Poverty Gap reduction (%) - All Social Insura... | \n", "
12766 | \n", "per_si_allsi_p1_urb | \n", "Poverty Gap reduction (%) - All Social Insura... | \n", "
12901 | \n", "per_si_oa_p0_ep_preT_tot | \n", "Poverty Headcount reduction (%) - Old Age Con... | \n", "
12902 | \n", "per_si_oa_p0_ep_tot | \n", "Poverty Headcount reduction (%) - Old Age Con... | \n", "
12903 | \n", "per_si_oa_p0_preT_tot | \n", "Poverty Headcount reduction (%) - Old Age Con... | \n", "
12904 | \n", "per_si_oa_p0_rur | \n", "Poverty Headcount reduction (%) - Old Age Con... | \n", "
12905 | \n", "per_si_oa_p0_tot | \n", "Poverty Headcount reduction (%) - Old Age Con... | \n", "
12906 | \n", "per_si_oa_p0_urb | \n", "Poverty Headcount reduction (%) - Old Age Con... | \n", "
12907 | \n", "per_si_oa_p1_ep_preT_tot | \n", "Poverty Gap reduction (%) - Old Age Contribut... | \n", "
12908 | \n", "per_si_oa_p1_ep_tot | \n", "Poverty Gap reduction (%) - Old Age Contribut... | \n", "
12909 | \n", "per_si_oa_p1_preT_tot | \n", "Poverty Gap reduction (%) - Old Age Contribut... | \n", "
12910 | \n", "per_si_oa_p1_rur | \n", "Poverty Gap reduction (%) - Old Age Contribut... | \n", "
12911 | \n", "per_si_oa_p1_tot | \n", "Poverty Gap reduction (%) - Old Age Contribut... | \n", "
12912 | \n", "per_si_oa_p1_urb | \n", "Poverty Gap reduction (%) - Old Age Contribut... | \n", "
13047 | \n", "per_si_ss_p0_ep_preT_tot | \n", "Poverty Headcount reduction (%) - Other Socia... | \n", "
13048 | \n", "per_si_ss_p0_ep_tot | \n", "Poverty Headcount reduction (%) - Other Socia... | \n", "
13049 | \n", "per_si_ss_p0_preT_tot | \n", "Poverty Headcount reduction (%) - Other Socia... | \n", "
13050 | \n", "per_si_ss_p0_rur | \n", "Poverty Headcount reduction (%) - Other Socia... | \n", "
13051 | \n", "per_si_ss_p0_tot | \n", "Poverty Headcount reduction (%) - Other Socia... | \n", "
13052 | \n", "per_si_ss_p0_urb | \n", "Poverty Headcount reduction (%) - Other Socia... | \n", "
13053 | \n", "per_si_ss_p1_ep_preT_tot | \n", "Poverty Gap reduction (%) - Other Social Insu... | \n", "
13054 | \n", "per_si_ss_p1_ep_tot | \n", "Poverty Gap reduction (%) - Other Social Insu... | \n", "
13055 | \n", "per_si_ss_p1_preT_tot | \n", "Poverty Gap reduction (%) - Other Social Insu... | \n", "
13056 | \n", "per_si_ss_p1_rur | \n", "Poverty Gap reduction (%) - Other Social Insu... | \n", "
13057 | \n", "per_si_ss_p1_tot | \n", "Poverty Gap reduction (%) - Other Social Insu... | \n", "
13058 | \n", "per_si_ss_p1_urb | \n", "Poverty Gap reduction (%) - Other Social Insu... | \n", "
231 rows \u00d7 2 columns
\n", "\n", " | id | \n", "name | \n", "
---|---|---|
7522 | \n", "SI.DST.02ND.20 | \n", "Income share held by second 20% | \n", "
7523 | \n", "SI.DST.03RD.20 | \n", "Income share held by third 20% | \n", "
7524 | \n", "SI.DST.04TH.20 | \n", "Income share held by fourth 20% | \n", "
7525 | \n", "SI.DST.05TH.20 | \n", "Income share held by highest 20% | \n", "
7526 | \n", "SI.DST.10TH.10 | \n", "Income share held by highest 10% | \n", "
7527 | \n", "SI.DST.FRST.10 | \n", "Income share held by lowest 10% | \n", "
7528 | \n", "SI.DST.FRST.20 | \n", "Income share held by lowest 20% | \n", "
\n", " | \n", " | SI.POV.25DAY | \n", "SI.POV.2DAY | \n", "SI.POV.4DAY | \n", "SI.POV.5DAY | \n", "SI.POV.DDAY | \n", "SI.POV.GAP2 | \n", "SI.POV.GAP25 | \n", "SI.POV.GAP4 | \n", "SI.POV.GAP5 | \n", "SI.POV.GAPS | \n", "... | \n", "SI.POV.RUHC | \n", "SI.POV.URGP | \n", "SI.POV.URHC | \n", "SI.DST.02ND.20 | \n", "SI.DST.03RD.20 | \n", "SI.DST.04TH.20 | \n", "SI.DST.05TH.20 | \n", "SI.DST.10TH.10 | \n", "SI.DST.FRST.10 | \n", "SI.DST.FRST.20 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
country | \n", "year | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
Cambodia | \n", "2012 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "20.8 | \n", "NaN | \n", "6.4 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2011 | \n", "59.00 | \n", "41.26 | \n", "85.70 | \n", "91.83 | \n", "10.05 | \n", "10.25 | \n", "18.29 | \n", "39.60 | \n", "49.51 | \n", "1.43 | \n", "... | \n", "23.6 | \n", "NaN | \n", "8.7 | \n", "12.46 | \n", "16.11 | \n", "21.24 | \n", "41.20 | \n", "26.91 | \n", "4.04 | \n", "8.99 | \n", "|
2010 | \n", "57.59 | \n", "40.88 | \n", "84.06 | \n", "90.63 | \n", "11.25 | \n", "10.59 | \n", "18.37 | \n", "39.00 | \n", "48.74 | \n", "1.70 | \n", "... | \n", "25.3 | \n", "NaN | \n", "8.5 | \n", "12.02 | \n", "15.80 | \n", "21.18 | \n", "42.49 | \n", "28.01 | \n", "3.80 | \n", "8.51 | \n", "|
2009 | \n", "56.25 | \n", "40.74 | \n", "82.20 | \n", "89.25 | \n", "12.93 | \n", "11.21 | \n", "18.71 | \n", "38.50 | \n", "48.02 | \n", "2.08 | \n", "... | \n", "27.5 | \n", "NaN | \n", "8.0 | \n", "11.66 | \n", "15.68 | \n", "21.48 | \n", "43.15 | \n", "28.20 | \n", "3.55 | \n", "8.03 | \n", "|
2008 | \n", "65.90 | \n", "51.05 | \n", "87.33 | \n", "92.48 | \n", "20.89 | \n", "16.27 | \n", "24.78 | \n", "45.05 | \n", "54.08 | \n", "4.39 | \n", "... | \n", "38.5 | \n", "NaN | \n", "15.1 | \n", "11.60 | \n", "15.67 | \n", "21.43 | \n", "43.45 | \n", "28.57 | \n", "3.44 | \n", "7.85 | \n", "|
2007 | \n", "71.05 | \n", "59.39 | \n", "87.65 | \n", "92.07 | \n", "30.82 | \n", "21.92 | \n", "30.64 | \n", "49.51 | \n", "57.63 | \n", "7.24 | \n", "... | \n", "51.4 | \n", "NaN | \n", "18.3 | \n", "10.05 | \n", "13.95 | \n", "20.16 | \n", "48.89 | \n", "33.99 | \n", "3.12 | \n", "6.95 | \n", "|
2006 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "|
2005 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "|
2004 | \n", "76.54 | \n", "64.43 | \n", "91.55 | \n", "94.95 | \n", "32.77 | \n", "23.64 | \n", "33.09 | \n", "52.85 | \n", "60.96 | \n", "7.79 | \n", "... | \n", "54.2 | \n", "NaN | \n", "28.5 | \n", "11.43 | \n", "15.37 | \n", "21.22 | \n", "44.00 | \n", "29.09 | \n", "3.56 | \n", "7.98 | \n", "
9 rows \u00d7 23 columns
\n", "\n", " | Income share held by highest 10% | \n", "Income share held by lowest 10% | \n", "
---|---|---|
year | \n", "\n", " | \n", " |
2004 | \n", "29.09 | \n", "3.56 | \n", "
2005 | \n", "NaN | \n", "NaN | \n", "
2006 | \n", "NaN | \n", "NaN | \n", "
2007 | \n", "33.99 | \n", "3.12 | \n", "
2008 | \n", "28.57 | \n", "3.44 | \n", "
2009 | \n", "28.20 | \n", "3.55 | \n", "
2010 | \n", "28.01 | \n", "3.80 | \n", "
2011 | \n", "26.91 | \n", "4.04 | \n", "
\n", " | Income share held by lowest 20% | \n", "Income share held by second 20% | \n", "Income share held by third 20% | \n", "Income share held by fourth 20% | \n", "Income share held by highest 20% | \n", "
---|---|---|---|---|---|
year | \n", "\n", " | \n", " | \n", " | \n", " | \n", " |
2004 | \n", "7.98 | \n", "11.43 | \n", "15.37 | \n", "21.22 | \n", "44.00 | \n", "
2005 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2006 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2007 | \n", "6.95 | \n", "10.05 | \n", "13.95 | \n", "20.16 | \n", "48.89 | \n", "
2008 | \n", "7.85 | \n", "11.60 | \n", "15.67 | \n", "21.43 | \n", "43.45 | \n", "
2009 | \n", "8.03 | \n", "11.66 | \n", "15.68 | \n", "21.48 | \n", "43.15 | \n", "
2010 | \n", "8.51 | \n", "12.02 | \n", "15.80 | \n", "21.18 | \n", "42.49 | \n", "
2011 | \n", "8.99 | \n", "12.46 | \n", "16.11 | \n", "21.24 | \n", "41.20 | \n", "
\n", " | Poverty headcount ratio at $2.5 a day (PPP) (% of population) | \n", "Poverty headcount ratio at $2 a day (PPP) (% of population) | \n", "Poverty headcount ratio at $4 a day (PPP) (% of population) | \n", "Poverty headcount ratio at $5 a day (PPP) (% of population) | \n", "Poverty headcount ratio at $1.25 a day (PPP) (% of population) | \n", "Poverty headcount ratio at national poverty lines (% of population) | \n", "
---|---|---|---|---|---|---|
year | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
2004 | \n", "76.54 | \n", "64.43 | \n", "91.55 | \n", "94.95 | \n", "32.77 | \n", "50.2 | \n", "
2005 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2006 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2007 | \n", "71.05 | \n", "59.39 | \n", "87.65 | \n", "92.07 | \n", "30.82 | \n", "45.0 | \n", "
2008 | \n", "65.90 | \n", "51.05 | \n", "87.33 | \n", "92.48 | \n", "20.89 | \n", "34.0 | \n", "
2009 | \n", "56.25 | \n", "40.74 | \n", "82.20 | \n", "89.25 | \n", "12.93 | \n", "23.9 | \n", "
2010 | \n", "57.59 | \n", "40.88 | \n", "84.06 | \n", "90.63 | \n", "11.25 | \n", "22.1 | \n", "
2011 | \n", "59.00 | \n", "41.26 | \n", "85.70 | \n", "91.83 | \n", "10.05 | \n", "20.5 | \n", "
2012 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "17.7 | \n", "