07 opening a csv textfile with pandas and os listdir.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Let's import a csv file into a notebook.  First, make sure that this notebook is running in your physics 320 work directory, and then make sure the gapminder data is in a subdirectory of wherever (pwd) is.  In the shell, the picture might look like:\n",
    "<pre>\n",
    "<code>\n",
    "sj5947pw@sj5947pw181 MINGW64 ~/Documents/wsu_classes/phys320_fall18\n",
    "$ ls\n",
    "'07 opening a csv textfile with pandas and os listdir.ipynb'\n",
    "'07 python-novice-gapminder-data.zip'\n",
    " 07_gapminder_data/\n",
    " homework-python.docx\n",
    " old_sections/\n",
    " shop_heater/\n",
    "'students phys320f18.xlsx'\n",
    " Untitled.ipynb\n",
    "\n",
    "sj5947pw@sj5947pw181 MINGW64 ~/Documents/wsu_classes/phys320_fall18\n",
    "$ ls ./07_gapminder_data/\n",
    "data/\n",
    "\n",
    "sj5947pw@sj5947pw181 MINGW64 ~/Documents/wsu_classes/phys320_fall18\n",
    "$ ls ./07_gapminder_data/data/\n",
    "gapminder_all.csv           gapminder_gdp_asia.csv\n",
    "gapminder_gdp_africa.csv    gapminder_gdp_europe.csv\n",
    "gapminder_gdp_americas.csv  gapminder_gdp_oceania.csv\n",
    "</code></pre>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# The error-prone fast way to import the file would be by specifying the full path.\n",
    "import pandas\n",
    "data2=pandas.read_csv(\"07_gapminder_data/data/gapminder_gdp_africa.csv\", index_col=\"country\")\n",
    "# the main drawbacks to this approach are typo's and typing speed"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# A more reliable way to import files that aren't in the same directory as the jupyter \n",
    "# notebook is to use the \"os\" module, which allows python to work with the filesystem.\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['.ipynb_checkpoints',\n",
       " '07 opening a csv textfile with pandas and os listdir.ipynb',\n",
       " '07 python-novice-gapminder-data.zip',\n",
       " '07_gapminder_data',\n",
       " 'homework-python.docx',\n",
       " 'old_sections',\n",
       " 'shop_heater',\n",
       " 'students phys320f18.xlsx',\n",
       " 'Untitled.ipynb']"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# what's in the current directory?\n",
    "os.listdir()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "07_gapminder_data\n"
     ]
    }
   ],
   "source": [
    "# assign the current directory contents to a list and then pull out the relevant folder we want to get stuff from\n",
    "p=os.listdir()\n",
    "print(p[3])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['data']"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# look inside this directory\n",
    "os.listdir(p[3])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "data\n"
     ]
    }
   ],
   "source": [
    "# again grab the names of the directory contents in a list and then save them\n",
    "q=os.listdir(p[3])\n",
    "print(q[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['gapminder_all.csv', 'gapminder_gdp_africa.csv', 'gapminder_gdp_americas.csv', 'gapminder_gdp_asia.csv', 'gapminder_gdp_europe.csv', 'gapminder_gdp_oceania.csv']\n"
     ]
    }
   ],
   "source": [
    "# now that we have the two directories listed, we can look at the .csv files inside the two.  \n",
    "file_path=p[3] + \"/\" + q[0] + \"/\"\n",
    "data_files=os.listdir(file_path)\n",
    "print(data_files)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "I'm going to open:  07_gapminder_data/data/gapminder_gdp_africa.csv\n"
     ]
    }
   ],
   "source": [
    "# now, we can access any of the csv files with the appropriate index of data_files\n",
    "# eg, for africa\n",
    "print(\"I'm going to open: \",file_path+data_files[1])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# the test worked, so, \n",
    "import pandas\n",
    "data=pandas.read_csv(file_path+data_files[1],index_col=\"country\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "3520.610273\n",
      "3520.610273\n"
     ]
    }
   ],
   "source": [
    "# to show that both csv import methods work, print out one value from Angola, 1952\n",
    "print(data.loc[\"Angola\",\"gdpPercap_1952\"])\n",
    "print(data2.loc[\"Angola\",\"gdpPercap_1952\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>gdpPercap_1952</th>\n",
       "      <th>gdpPercap_1957</th>\n",
       "      <th>gdpPercap_1962</th>\n",
       "      <th>gdpPercap_1967</th>\n",
       "      <th>gdpPercap_1972</th>\n",
       "      <th>gdpPercap_1977</th>\n",
       "      <th>gdpPercap_1982</th>\n",
       "      <th>gdpPercap_1987</th>\n",
       "      <th>gdpPercap_1992</th>\n",
       "      <th>gdpPercap_1997</th>\n",
       "      <th>gdpPercap_2002</th>\n",
       "      <th>gdpPercap_2007</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Algeria</th>\n",
       "      <td>2449.008185</td>\n",
       "      <td>3013.976023</td>\n",
       "      <td>2550.816880</td>\n",
       "      <td>3246.991771</td>\n",
       "      <td>4182.663766</td>\n",
       "      <td>4910.416756</td>\n",
       "      <td>5745.160213</td>\n",
       "      <td>5681.358539</td>\n",
       "      <td>5023.216647</td>\n",
       "      <td>4797.295051</td>\n",
       "      <td>5288.040382</td>\n",
       "      <td>6223.367465</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Angola</th>\n",
       "      <td>3520.610273</td>\n",
       "      <td>3827.940465</td>\n",
       "      <td>4269.276742</td>\n",
       "      <td>5522.776375</td>\n",
       "      <td>5473.288005</td>\n",
       "      <td>3008.647355</td>\n",
       "      <td>2756.953672</td>\n",
       "      <td>2430.208311</td>\n",
       "      <td>2627.845685</td>\n",
       "      <td>2277.140884</td>\n",
       "      <td>2773.287312</td>\n",
       "      <td>4797.231267</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Benin</th>\n",
       "      <td>1062.752200</td>\n",
       "      <td>959.601080</td>\n",
       "      <td>949.499064</td>\n",
       "      <td>1035.831411</td>\n",
       "      <td>1085.796879</td>\n",
       "      <td>1029.161251</td>\n",
       "      <td>1277.897616</td>\n",
       "      <td>1225.856010</td>\n",
       "      <td>1191.207681</td>\n",
       "      <td>1232.975292</td>\n",
       "      <td>1372.877931</td>\n",
       "      <td>1441.284873</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Botswana</th>\n",
       "      <td>851.241141</td>\n",
       "      <td>918.232535</td>\n",
       "      <td>983.653976</td>\n",
       "      <td>1214.709294</td>\n",
       "      <td>2263.611114</td>\n",
       "      <td>3214.857818</td>\n",
       "      <td>4551.142150</td>\n",
       "      <td>6205.883850</td>\n",
       "      <td>7954.111645</td>\n",
       "      <td>8647.142313</td>\n",
       "      <td>11003.605080</td>\n",
       "      <td>12569.851770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Burkina Faso</th>\n",
       "      <td>543.255241</td>\n",
       "      <td>617.183465</td>\n",
       "      <td>722.512021</td>\n",
       "      <td>794.826560</td>\n",
       "      <td>854.735976</td>\n",
       "      <td>743.387037</td>\n",
       "      <td>807.198586</td>\n",
       "      <td>912.063142</td>\n",
       "      <td>931.752773</td>\n",
       "      <td>946.294962</td>\n",
       "      <td>1037.645221</td>\n",
       "      <td>1217.032994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Burundi</th>\n",
       "      <td>339.296459</td>\n",
       "      <td>379.564628</td>\n",
       "      <td>355.203227</td>\n",
       "      <td>412.977514</td>\n",
       "      <td>464.099504</td>\n",
       "      <td>556.103265</td>\n",
       "      <td>559.603231</td>\n",
       "      <td>621.818819</td>\n",
       "      <td>631.699878</td>\n",
       "      <td>463.115148</td>\n",
       "      <td>446.403513</td>\n",
       "      <td>430.070692</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cameroon</th>\n",
       "      <td>1172.667655</td>\n",
       "      <td>1313.048099</td>\n",
       "      <td>1399.607441</td>\n",
       "      <td>1508.453148</td>\n",
       "      <td>1684.146528</td>\n",
       "      <td>1783.432873</td>\n",
       "      <td>2367.983282</td>\n",
       "      <td>2602.664206</td>\n",
       "      <td>1793.163278</td>\n",
       "      <td>1694.337469</td>\n",
       "      <td>1934.011449</td>\n",
       "      <td>2042.095240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Central African Republic</th>\n",
       "      <td>1071.310713</td>\n",
       "      <td>1190.844328</td>\n",
       "      <td>1193.068753</td>\n",
       "      <td>1136.056615</td>\n",
       "      <td>1070.013275</td>\n",
       "      <td>1109.374338</td>\n",
       "      <td>956.752991</td>\n",
       "      <td>844.876350</td>\n",
       "      <td>747.905525</td>\n",
       "      <td>740.506332</td>\n",
       "      <td>738.690607</td>\n",
       "      <td>706.016537</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chad</th>\n",
       "      <td>1178.665927</td>\n",
       "      <td>1308.495577</td>\n",
       "      <td>1389.817618</td>\n",
       "      <td>1196.810565</td>\n",
       "      <td>1104.103987</td>\n",
       "      <td>1133.984950</td>\n",
       "      <td>797.908101</td>\n",
       "      <td>952.386129</td>\n",
       "      <td>1058.064300</td>\n",
       "      <td>1004.961353</td>\n",
       "      <td>1156.181860</td>\n",
       "      <td>1704.063724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Comoros</th>\n",
       "      <td>1102.990936</td>\n",
       "      <td>1211.148548</td>\n",
       "      <td>1406.648278</td>\n",
       "      <td>1876.029643</td>\n",
       "      <td>1937.577675</td>\n",
       "      <td>1172.603047</td>\n",
       "      <td>1267.100083</td>\n",
       "      <td>1315.980812</td>\n",
       "      <td>1246.907370</td>\n",
       "      <td>1173.618235</td>\n",
       "      <td>1075.811558</td>\n",
       "      <td>986.147879</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Congo Dem. Rep.</th>\n",
       "      <td>780.542326</td>\n",
       "      <td>905.860230</td>\n",
       "      <td>896.314634</td>\n",
       "      <td>861.593242</td>\n",
       "      <td>904.896069</td>\n",
       "      <td>795.757282</td>\n",
       "      <td>673.747818</td>\n",
       "      <td>672.774812</td>\n",
       "      <td>457.719181</td>\n",
       "      <td>312.188423</td>\n",
       "      <td>241.165877</td>\n",
       "      <td>277.551859</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Congo Rep.</th>\n",
       "      <td>2125.621418</td>\n",
       "      <td>2315.056572</td>\n",
       "      <td>2464.783157</td>\n",
       "      <td>2677.939642</td>\n",
       "      <td>3213.152683</td>\n",
       "      <td>3259.178978</td>\n",
       "      <td>4879.507522</td>\n",
       "      <td>4201.194937</td>\n",
       "      <td>4016.239529</td>\n",
       "      <td>3484.164376</td>\n",
       "      <td>3484.061970</td>\n",
       "      <td>3632.557798</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cote d'Ivoire</th>\n",
       "      <td>1388.594732</td>\n",
       "      <td>1500.895925</td>\n",
       "      <td>1728.869428</td>\n",
       "      <td>2052.050473</td>\n",
       "      <td>2378.201111</td>\n",
       "      <td>2517.736547</td>\n",
       "      <td>2602.710169</td>\n",
       "      <td>2156.956069</td>\n",
       "      <td>1648.073791</td>\n",
       "      <td>1786.265407</td>\n",
       "      <td>1648.800823</td>\n",
       "      <td>1544.750112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Djibouti</th>\n",
       "      <td>2669.529475</td>\n",
       "      <td>2864.969076</td>\n",
       "      <td>3020.989263</td>\n",
       "      <td>3020.050513</td>\n",
       "      <td>3694.212352</td>\n",
       "      <td>3081.761022</td>\n",
       "      <td>2879.468067</td>\n",
       "      <td>2880.102568</td>\n",
       "      <td>2377.156192</td>\n",
       "      <td>1895.016984</td>\n",
       "      <td>1908.260867</td>\n",
       "      <td>2082.481567</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Egypt</th>\n",
       "      <td>1418.822445</td>\n",
       "      <td>1458.915272</td>\n",
       "      <td>1693.335853</td>\n",
       "      <td>1814.880728</td>\n",
       "      <td>2024.008147</td>\n",
       "      <td>2785.493582</td>\n",
       "      <td>3503.729636</td>\n",
       "      <td>3885.460710</td>\n",
       "      <td>3794.755195</td>\n",
       "      <td>4173.181797</td>\n",
       "      <td>4754.604414</td>\n",
       "      <td>5581.180998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Equatorial Guinea</th>\n",
       "      <td>375.643123</td>\n",
       "      <td>426.096408</td>\n",
       "      <td>582.841971</td>\n",
       "      <td>915.596003</td>\n",
       "      <td>672.412257</td>\n",
       "      <td>958.566812</td>\n",
       "      <td>927.825343</td>\n",
       "      <td>966.896815</td>\n",
       "      <td>1132.055034</td>\n",
       "      <td>2814.480755</td>\n",
       "      <td>7703.495900</td>\n",
       "      <td>12154.089750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Eritrea</th>\n",
       "      <td>328.940557</td>\n",
       "      <td>344.161886</td>\n",
       "      <td>380.995843</td>\n",
       "      <td>468.794970</td>\n",
       "      <td>514.324208</td>\n",
       "      <td>505.753808</td>\n",
       "      <td>524.875849</td>\n",
       "      <td>521.134133</td>\n",
       "      <td>582.858510</td>\n",
       "      <td>913.470790</td>\n",
       "      <td>765.350001</td>\n",
       "      <td>641.369524</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ethiopia</th>\n",
       "      <td>362.146280</td>\n",
       "      <td>378.904163</td>\n",
       "      <td>419.456416</td>\n",
       "      <td>516.118644</td>\n",
       "      <td>566.243944</td>\n",
       "      <td>556.808383</td>\n",
       "      <td>577.860747</td>\n",
       "      <td>573.741314</td>\n",
       "      <td>421.353465</td>\n",
       "      <td>515.889401</td>\n",
       "      <td>530.053532</td>\n",
       "      <td>690.805576</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gabon</th>\n",
       "      <td>4293.476475</td>\n",
       "      <td>4976.198099</td>\n",
       "      <td>6631.459222</td>\n",
       "      <td>8358.761987</td>\n",
       "      <td>11401.948410</td>\n",
       "      <td>21745.573280</td>\n",
       "      <td>15113.361940</td>\n",
       "      <td>11864.408440</td>\n",
       "      <td>13522.157520</td>\n",
       "      <td>14722.841880</td>\n",
       "      <td>12521.713920</td>\n",
       "      <td>13206.484520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gambia</th>\n",
       "      <td>485.230659</td>\n",
       "      <td>520.926711</td>\n",
       "      <td>599.650276</td>\n",
       "      <td>734.782912</td>\n",
       "      <td>756.086836</td>\n",
       "      <td>884.755251</td>\n",
       "      <td>835.809611</td>\n",
       "      <td>611.658861</td>\n",
       "      <td>665.624413</td>\n",
       "      <td>653.730170</td>\n",
       "      <td>660.585600</td>\n",
       "      <td>752.749726</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ghana</th>\n",
       "      <td>911.298937</td>\n",
       "      <td>1043.561537</td>\n",
       "      <td>1190.041118</td>\n",
       "      <td>1125.697160</td>\n",
       "      <td>1178.223708</td>\n",
       "      <td>993.223957</td>\n",
       "      <td>876.032569</td>\n",
       "      <td>847.006113</td>\n",
       "      <td>925.060154</td>\n",
       "      <td>1005.245812</td>\n",
       "      <td>1111.984578</td>\n",
       "      <td>1327.608910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Guinea</th>\n",
       "      <td>510.196492</td>\n",
       "      <td>576.267025</td>\n",
       "      <td>686.373674</td>\n",
       "      <td>708.759541</td>\n",
       "      <td>741.666231</td>\n",
       "      <td>874.685864</td>\n",
       "      <td>857.250358</td>\n",
       "      <td>805.572472</td>\n",
       "      <td>794.348438</td>\n",
       "      <td>869.449767</td>\n",
       "      <td>945.583584</td>\n",
       "      <td>942.654211</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Guinea-Bissau</th>\n",
       "      <td>299.850319</td>\n",
       "      <td>431.790457</td>\n",
       "      <td>522.034373</td>\n",
       "      <td>715.580640</td>\n",
       "      <td>820.224588</td>\n",
       "      <td>764.725963</td>\n",
       "      <td>838.123967</td>\n",
       "      <td>736.415392</td>\n",
       "      <td>745.539871</td>\n",
       "      <td>796.664468</td>\n",
       "      <td>575.704718</td>\n",
       "      <td>579.231743</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kenya</th>\n",
       "      <td>853.540919</td>\n",
       "      <td>944.438315</td>\n",
       "      <td>896.966373</td>\n",
       "      <td>1056.736457</td>\n",
       "      <td>1222.359968</td>\n",
       "      <td>1267.613204</td>\n",
       "      <td>1348.225791</td>\n",
       "      <td>1361.936856</td>\n",
       "      <td>1341.921721</td>\n",
       "      <td>1360.485021</td>\n",
       "      <td>1287.514732</td>\n",
       "      <td>1463.249282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lesotho</th>\n",
       "      <td>298.846212</td>\n",
       "      <td>335.997115</td>\n",
       "      <td>411.800627</td>\n",
       "      <td>498.639026</td>\n",
       "      <td>496.581592</td>\n",
       "      <td>745.369541</td>\n",
       "      <td>797.263107</td>\n",
       "      <td>773.993214</td>\n",
       "      <td>977.486272</td>\n",
       "      <td>1186.147994</td>\n",
       "      <td>1275.184575</td>\n",
       "      <td>1569.331442</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Liberia</th>\n",
       "      <td>575.572996</td>\n",
       "      <td>620.969990</td>\n",
       "      <td>634.195163</td>\n",
       "      <td>713.603648</td>\n",
       "      <td>803.005454</td>\n",
       "      <td>640.322438</td>\n",
       "      <td>572.199569</td>\n",
       "      <td>506.113857</td>\n",
       "      <td>636.622919</td>\n",
       "      <td>609.173951</td>\n",
       "      <td>531.482368</td>\n",
       "      <td>414.507341</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Libya</th>\n",
       "      <td>2387.548060</td>\n",
       "      <td>3448.284395</td>\n",
       "      <td>6757.030816</td>\n",
       "      <td>18772.751690</td>\n",
       "      <td>21011.497210</td>\n",
       "      <td>21951.211760</td>\n",
       "      <td>17364.275380</td>\n",
       "      <td>11770.589800</td>\n",
       "      <td>9640.138501</td>\n",
       "      <td>9467.446056</td>\n",
       "      <td>9534.677467</td>\n",
       "      <td>12057.499280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Madagascar</th>\n",
       "      <td>1443.011715</td>\n",
       "      <td>1589.202750</td>\n",
       "      <td>1643.387110</td>\n",
       "      <td>1634.047282</td>\n",
       "      <td>1748.562982</td>\n",
       "      <td>1544.228586</td>\n",
       "      <td>1302.878658</td>\n",
       "      <td>1155.441948</td>\n",
       "      <td>1040.676190</td>\n",
       "      <td>986.295896</td>\n",
       "      <td>894.637082</td>\n",
       "      <td>1044.770126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Malawi</th>\n",
       "      <td>369.165080</td>\n",
       "      <td>416.369806</td>\n",
       "      <td>427.901086</td>\n",
       "      <td>495.514781</td>\n",
       "      <td>584.621971</td>\n",
       "      <td>663.223677</td>\n",
       "      <td>632.803921</td>\n",
       "      <td>635.517363</td>\n",
       "      <td>563.200014</td>\n",
       "      <td>692.275810</td>\n",
       "      <td>665.423119</td>\n",
       "      <td>759.349910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mali</th>\n",
       "      <td>452.336981</td>\n",
       "      <td>490.382187</td>\n",
       "      <td>496.174343</td>\n",
       "      <td>545.009887</td>\n",
       "      <td>581.368876</td>\n",
       "      <td>686.395269</td>\n",
       "      <td>618.014064</td>\n",
       "      <td>684.171558</td>\n",
       "      <td>739.014375</td>\n",
       "      <td>790.257985</td>\n",
       "      <td>951.409752</td>\n",
       "      <td>1042.581557</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mauritania</th>\n",
       "      <td>743.115910</td>\n",
       "      <td>846.120261</td>\n",
       "      <td>1055.896036</td>\n",
       "      <td>1421.145193</td>\n",
       "      <td>1586.851781</td>\n",
       "      <td>1497.492223</td>\n",
       "      <td>1481.150189</td>\n",
       "      <td>1421.603576</td>\n",
       "      <td>1361.369784</td>\n",
       "      <td>1483.136136</td>\n",
       "      <td>1579.019543</td>\n",
       "      <td>1803.151496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mauritius</th>\n",
       "      <td>1967.955707</td>\n",
       "      <td>2034.037981</td>\n",
       "      <td>2529.067487</td>\n",
       "      <td>2475.387562</td>\n",
       "      <td>2575.484158</td>\n",
       "      <td>3710.982963</td>\n",
       "      <td>3688.037739</td>\n",
       "      <td>4783.586903</td>\n",
       "      <td>6058.253846</td>\n",
       "      <td>7425.705295</td>\n",
       "      <td>9021.815894</td>\n",
       "      <td>10956.991120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Morocco</th>\n",
       "      <td>1688.203570</td>\n",
       "      <td>1642.002314</td>\n",
       "      <td>1566.353493</td>\n",
       "      <td>1711.044770</td>\n",
       "      <td>1930.194975</td>\n",
       "      <td>2370.619976</td>\n",
       "      <td>2702.620356</td>\n",
       "      <td>2755.046991</td>\n",
       "      <td>2948.047252</td>\n",
       "      <td>2982.101858</td>\n",
       "      <td>3258.495584</td>\n",
       "      <td>3820.175230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mozambique</th>\n",
       "      <td>468.526038</td>\n",
       "      <td>495.586833</td>\n",
       "      <td>556.686354</td>\n",
       "      <td>566.669154</td>\n",
       "      <td>724.917804</td>\n",
       "      <td>502.319733</td>\n",
       "      <td>462.211415</td>\n",
       "      <td>389.876185</td>\n",
       "      <td>410.896824</td>\n",
       "      <td>472.346077</td>\n",
       "      <td>633.617947</td>\n",
       "      <td>823.685621</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Namibia</th>\n",
       "      <td>2423.780443</td>\n",
       "      <td>2621.448058</td>\n",
       "      <td>3173.215595</td>\n",
       "      <td>3793.694753</td>\n",
       "      <td>3746.080948</td>\n",
       "      <td>3876.485958</td>\n",
       "      <td>4191.100511</td>\n",
       "      <td>3693.731337</td>\n",
       "      <td>3804.537999</td>\n",
       "      <td>3899.524260</td>\n",
       "      <td>4072.324751</td>\n",
       "      <td>4811.060429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Niger</th>\n",
       "      <td>761.879376</td>\n",
       "      <td>835.523403</td>\n",
       "      <td>997.766113</td>\n",
       "      <td>1054.384891</td>\n",
       "      <td>954.209236</td>\n",
       "      <td>808.897073</td>\n",
       "      <td>909.722135</td>\n",
       "      <td>668.300023</td>\n",
       "      <td>581.182725</td>\n",
       "      <td>580.305209</td>\n",
       "      <td>601.074501</td>\n",
       "      <td>619.676892</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nigeria</th>\n",
       "      <td>1077.281856</td>\n",
       "      <td>1100.592563</td>\n",
       "      <td>1150.927478</td>\n",
       "      <td>1014.514104</td>\n",
       "      <td>1698.388838</td>\n",
       "      <td>1981.951806</td>\n",
       "      <td>1576.973750</td>\n",
       "      <td>1385.029563</td>\n",
       "      <td>1619.848217</td>\n",
       "      <td>1624.941275</td>\n",
       "      <td>1615.286395</td>\n",
       "      <td>2013.977305</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Reunion</th>\n",
       "      <td>2718.885295</td>\n",
       "      <td>2769.451844</td>\n",
       "      <td>3173.723340</td>\n",
       "      <td>4021.175739</td>\n",
       "      <td>5047.658563</td>\n",
       "      <td>4319.804067</td>\n",
       "      <td>5267.219353</td>\n",
       "      <td>5303.377488</td>\n",
       "      <td>6101.255823</td>\n",
       "      <td>6071.941411</td>\n",
       "      <td>6316.165200</td>\n",
       "      <td>7670.122558</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rwanda</th>\n",
       "      <td>493.323875</td>\n",
       "      <td>540.289398</td>\n",
       "      <td>597.473073</td>\n",
       "      <td>510.963714</td>\n",
       "      <td>590.580664</td>\n",
       "      <td>670.080601</td>\n",
       "      <td>881.570647</td>\n",
       "      <td>847.991217</td>\n",
       "      <td>737.068595</td>\n",
       "      <td>589.944505</td>\n",
       "      <td>785.653765</td>\n",
       "      <td>863.088464</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sao Tome and Principe</th>\n",
       "      <td>879.583586</td>\n",
       "      <td>860.736903</td>\n",
       "      <td>1071.551119</td>\n",
       "      <td>1384.840593</td>\n",
       "      <td>1532.985254</td>\n",
       "      <td>1737.561657</td>\n",
       "      <td>1890.218117</td>\n",
       "      <td>1516.525457</td>\n",
       "      <td>1428.777814</td>\n",
       "      <td>1339.076036</td>\n",
       "      <td>1353.092390</td>\n",
       "      <td>1598.435089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Senegal</th>\n",
       "      <td>1450.356983</td>\n",
       "      <td>1567.653006</td>\n",
       "      <td>1654.988723</td>\n",
       "      <td>1612.404632</td>\n",
       "      <td>1597.712056</td>\n",
       "      <td>1561.769116</td>\n",
       "      <td>1518.479984</td>\n",
       "      <td>1441.720720</td>\n",
       "      <td>1367.899369</td>\n",
       "      <td>1392.368347</td>\n",
       "      <td>1519.635262</td>\n",
       "      <td>1712.472136</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sierra Leone</th>\n",
       "      <td>879.787736</td>\n",
       "      <td>1004.484437</td>\n",
       "      <td>1116.639877</td>\n",
       "      <td>1206.043465</td>\n",
       "      <td>1353.759762</td>\n",
       "      <td>1348.285159</td>\n",
       "      <td>1465.010784</td>\n",
       "      <td>1294.447788</td>\n",
       "      <td>1068.696278</td>\n",
       "      <td>574.648158</td>\n",
       "      <td>699.489713</td>\n",
       "      <td>862.540756</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Somalia</th>\n",
       "      <td>1135.749842</td>\n",
       "      <td>1258.147413</td>\n",
       "      <td>1369.488336</td>\n",
       "      <td>1284.733180</td>\n",
       "      <td>1254.576127</td>\n",
       "      <td>1450.992513</td>\n",
       "      <td>1176.807031</td>\n",
       "      <td>1093.244963</td>\n",
       "      <td>926.960296</td>\n",
       "      <td>930.596428</td>\n",
       "      <td>882.081822</td>\n",
       "      <td>926.141068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>South Africa</th>\n",
       "      <td>4725.295531</td>\n",
       "      <td>5487.104219</td>\n",
       "      <td>5768.729717</td>\n",
       "      <td>7114.477971</td>\n",
       "      <td>7765.962636</td>\n",
       "      <td>8028.651439</td>\n",
       "      <td>8568.266228</td>\n",
       "      <td>7825.823398</td>\n",
       "      <td>7225.069258</td>\n",
       "      <td>7479.188244</td>\n",
       "      <td>7710.946444</td>\n",
       "      <td>9269.657808</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sudan</th>\n",
       "      <td>1615.991129</td>\n",
       "      <td>1770.337074</td>\n",
       "      <td>1959.593767</td>\n",
       "      <td>1687.997641</td>\n",
       "      <td>1659.652775</td>\n",
       "      <td>2202.988423</td>\n",
       "      <td>1895.544073</td>\n",
       "      <td>1507.819159</td>\n",
       "      <td>1492.197043</td>\n",
       "      <td>1632.210764</td>\n",
       "      <td>1993.398314</td>\n",
       "      <td>2602.394995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Swaziland</th>\n",
       "      <td>1148.376626</td>\n",
       "      <td>1244.708364</td>\n",
       "      <td>1856.182125</td>\n",
       "      <td>2613.101665</td>\n",
       "      <td>3364.836625</td>\n",
       "      <td>3781.410618</td>\n",
       "      <td>3895.384018</td>\n",
       "      <td>3984.839812</td>\n",
       "      <td>3553.022400</td>\n",
       "      <td>3876.768460</td>\n",
       "      <td>4128.116943</td>\n",
       "      <td>4513.480643</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tanzania</th>\n",
       "      <td>716.650072</td>\n",
       "      <td>698.535607</td>\n",
       "      <td>722.003807</td>\n",
       "      <td>848.218657</td>\n",
       "      <td>915.985059</td>\n",
       "      <td>962.492293</td>\n",
       "      <td>874.242607</td>\n",
       "      <td>831.822079</td>\n",
       "      <td>825.682454</td>\n",
       "      <td>789.186223</td>\n",
       "      <td>899.074211</td>\n",
       "      <td>1107.482182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Togo</th>\n",
       "      <td>859.808657</td>\n",
       "      <td>925.908320</td>\n",
       "      <td>1067.534810</td>\n",
       "      <td>1477.596760</td>\n",
       "      <td>1649.660188</td>\n",
       "      <td>1532.776998</td>\n",
       "      <td>1344.577953</td>\n",
       "      <td>1202.201361</td>\n",
       "      <td>1034.298904</td>\n",
       "      <td>982.286924</td>\n",
       "      <td>886.220577</td>\n",
       "      <td>882.969944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tunisia</th>\n",
       "      <td>1468.475631</td>\n",
       "      <td>1395.232468</td>\n",
       "      <td>1660.303210</td>\n",
       "      <td>1932.360167</td>\n",
       "      <td>2753.285994</td>\n",
       "      <td>3120.876811</td>\n",
       "      <td>3560.233174</td>\n",
       "      <td>3810.419296</td>\n",
       "      <td>4332.720164</td>\n",
       "      <td>4876.798614</td>\n",
       "      <td>5722.895655</td>\n",
       "      <td>7092.923025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Uganda</th>\n",
       "      <td>734.753484</td>\n",
       "      <td>774.371069</td>\n",
       "      <td>767.271740</td>\n",
       "      <td>908.918522</td>\n",
       "      <td>950.735869</td>\n",
       "      <td>843.733137</td>\n",
       "      <td>682.266227</td>\n",
       "      <td>617.724406</td>\n",
       "      <td>644.170797</td>\n",
       "      <td>816.559081</td>\n",
       "      <td>927.721002</td>\n",
       "      <td>1056.380121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zambia</th>\n",
       "      <td>1147.388831</td>\n",
       "      <td>1311.956766</td>\n",
       "      <td>1452.725766</td>\n",
       "      <td>1777.077318</td>\n",
       "      <td>1773.498265</td>\n",
       "      <td>1588.688299</td>\n",
       "      <td>1408.678565</td>\n",
       "      <td>1213.315116</td>\n",
       "      <td>1210.884633</td>\n",
       "      <td>1071.353818</td>\n",
       "      <td>1071.613938</td>\n",
       "      <td>1271.211593</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zimbabwe</th>\n",
       "      <td>406.884115</td>\n",
       "      <td>518.764268</td>\n",
       "      <td>527.272182</td>\n",
       "      <td>569.795071</td>\n",
       "      <td>799.362176</td>\n",
       "      <td>685.587682</td>\n",
       "      <td>788.855041</td>\n",
       "      <td>706.157306</td>\n",
       "      <td>693.420786</td>\n",
       "      <td>792.449960</td>\n",
       "      <td>672.038623</td>\n",
       "      <td>469.709298</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                          gdpPercap_1952  gdpPercap_1957  gdpPercap_1962  \\\n",
       "country                                                                    \n",
       "Algeria                      2449.008185     3013.976023     2550.816880   \n",
       "Angola                       3520.610273     3827.940465     4269.276742   \n",
       "Benin                        1062.752200      959.601080      949.499064   \n",
       "Botswana                      851.241141      918.232535      983.653976   \n",
       "Burkina Faso                  543.255241      617.183465      722.512021   \n",
       "Burundi                       339.296459      379.564628      355.203227   \n",
       "Cameroon                     1172.667655     1313.048099     1399.607441   \n",
       "Central African Republic     1071.310713     1190.844328     1193.068753   \n",
       "Chad                         1178.665927     1308.495577     1389.817618   \n",
       "Comoros                      1102.990936     1211.148548     1406.648278   \n",
       "Congo Dem. Rep.               780.542326      905.860230      896.314634   \n",
       "Congo Rep.                   2125.621418     2315.056572     2464.783157   \n",
       "Cote d'Ivoire                1388.594732     1500.895925     1728.869428   \n",
       "Djibouti                     2669.529475     2864.969076     3020.989263   \n",
       "Egypt                        1418.822445     1458.915272     1693.335853   \n",
       "Equatorial Guinea             375.643123      426.096408      582.841971   \n",
       "Eritrea                       328.940557      344.161886      380.995843   \n",
       "Ethiopia                      362.146280      378.904163      419.456416   \n",
       "Gabon                        4293.476475     4976.198099     6631.459222   \n",
       "Gambia                        485.230659      520.926711      599.650276   \n",
       "Ghana                         911.298937     1043.561537     1190.041118   \n",
       "Guinea                        510.196492      576.267025      686.373674   \n",
       "Guinea-Bissau                 299.850319      431.790457      522.034373   \n",
       "Kenya                         853.540919      944.438315      896.966373   \n",
       "Lesotho                       298.846212      335.997115      411.800627   \n",
       "Liberia                       575.572996      620.969990      634.195163   \n",
       "Libya                        2387.548060     3448.284395     6757.030816   \n",
       "Madagascar                   1443.011715     1589.202750     1643.387110   \n",
       "Malawi                        369.165080      416.369806      427.901086   \n",
       "Mali                          452.336981      490.382187      496.174343   \n",
       "Mauritania                    743.115910      846.120261     1055.896036   \n",
       "Mauritius                    1967.955707     2034.037981     2529.067487   \n",
       "Morocco                      1688.203570     1642.002314     1566.353493   \n",
       "Mozambique                    468.526038      495.586833      556.686354   \n",
       "Namibia                      2423.780443     2621.448058     3173.215595   \n",
       "Niger                         761.879376      835.523403      997.766113   \n",
       "Nigeria                      1077.281856     1100.592563     1150.927478   \n",
       "Reunion                      2718.885295     2769.451844     3173.723340   \n",
       "Rwanda                        493.323875      540.289398      597.473073   \n",
       "Sao Tome and Principe         879.583586      860.736903     1071.551119   \n",
       "Senegal                      1450.356983     1567.653006     1654.988723   \n",
       "Sierra Leone                  879.787736     1004.484437     1116.639877   \n",
       "Somalia                      1135.749842     1258.147413     1369.488336   \n",
       "South Africa                 4725.295531     5487.104219     5768.729717   \n",
       "Sudan                        1615.991129     1770.337074     1959.593767   \n",
       "Swaziland                    1148.376626     1244.708364     1856.182125   \n",
       "Tanzania                      716.650072      698.535607      722.003807   \n",
       "Togo                          859.808657      925.908320     1067.534810   \n",
       "Tunisia                      1468.475631     1395.232468     1660.303210   \n",
       "Uganda                        734.753484      774.371069      767.271740   \n",
       "Zambia                       1147.388831     1311.956766     1452.725766   \n",
       "Zimbabwe                      406.884115      518.764268      527.272182   \n",
       "\n",
       "                          gdpPercap_1967  gdpPercap_1972  gdpPercap_1977  \\\n",
       "country                                                                    \n",
       "Algeria                      3246.991771     4182.663766     4910.416756   \n",
       "Angola                       5522.776375     5473.288005     3008.647355   \n",
       "Benin                        1035.831411     1085.796879     1029.161251   \n",
       "Botswana                     1214.709294     2263.611114     3214.857818   \n",
       "Burkina Faso                  794.826560      854.735976      743.387037   \n",
       "Burundi                       412.977514      464.099504      556.103265   \n",
       "Cameroon                     1508.453148     1684.146528     1783.432873   \n",
       "Central African Republic     1136.056615     1070.013275     1109.374338   \n",
       "Chad                         1196.810565     1104.103987     1133.984950   \n",
       "Comoros                      1876.029643     1937.577675     1172.603047   \n",
       "Congo Dem. Rep.               861.593242      904.896069      795.757282   \n",
       "Congo Rep.                   2677.939642     3213.152683     3259.178978   \n",
       "Cote d'Ivoire                2052.050473     2378.201111     2517.736547   \n",
       "Djibouti                     3020.050513     3694.212352     3081.761022   \n",
       "Egypt                        1814.880728     2024.008147     2785.493582   \n",
       "Equatorial Guinea             915.596003      672.412257      958.566812   \n",
       "Eritrea                       468.794970      514.324208      505.753808   \n",
       "Ethiopia                      516.118644      566.243944      556.808383   \n",
       "Gabon                        8358.761987    11401.948410    21745.573280   \n",
       "Gambia                        734.782912      756.086836      884.755251   \n",
       "Ghana                        1125.697160     1178.223708      993.223957   \n",
       "Guinea                        708.759541      741.666231      874.685864   \n",
       "Guinea-Bissau                 715.580640      820.224588      764.725963   \n",
       "Kenya                        1056.736457     1222.359968     1267.613204   \n",
       "Lesotho                       498.639026      496.581592      745.369541   \n",
       "Liberia                       713.603648      803.005454      640.322438   \n",
       "Libya                       18772.751690    21011.497210    21951.211760   \n",
       "Madagascar                   1634.047282     1748.562982     1544.228586   \n",
       "Malawi                        495.514781      584.621971      663.223677   \n",
       "Mali                          545.009887      581.368876      686.395269   \n",
       "Mauritania                   1421.145193     1586.851781     1497.492223   \n",
       "Mauritius                    2475.387562     2575.484158     3710.982963   \n",
       "Morocco                      1711.044770     1930.194975     2370.619976   \n",
       "Mozambique                    566.669154      724.917804      502.319733   \n",
       "Namibia                      3793.694753     3746.080948     3876.485958   \n",
       "Niger                        1054.384891      954.209236      808.897073   \n",
       "Nigeria                      1014.514104     1698.388838     1981.951806   \n",
       "Reunion                      4021.175739     5047.658563     4319.804067   \n",
       "Rwanda                        510.963714      590.580664      670.080601   \n",
       "Sao Tome and Principe        1384.840593     1532.985254     1737.561657   \n",
       "Senegal                      1612.404632     1597.712056     1561.769116   \n",
       "Sierra Leone                 1206.043465     1353.759762     1348.285159   \n",
       "Somalia                      1284.733180     1254.576127     1450.992513   \n",
       "South Africa                 7114.477971     7765.962636     8028.651439   \n",
       "Sudan                        1687.997641     1659.652775     2202.988423   \n",
       "Swaziland                    2613.101665     3364.836625     3781.410618   \n",
       "Tanzania                      848.218657      915.985059      962.492293   \n",
       "Togo                         1477.596760     1649.660188     1532.776998   \n",
       "Tunisia                      1932.360167     2753.285994     3120.876811   \n",
       "Uganda                        908.918522      950.735869      843.733137   \n",
       "Zambia                       1777.077318     1773.498265     1588.688299   \n",
       "Zimbabwe                      569.795071      799.362176      685.587682   \n",
       "\n",
       "                          gdpPercap_1982  gdpPercap_1987  gdpPercap_1992  \\\n",
       "country                                                                    \n",
       "Algeria                      5745.160213     5681.358539     5023.216647   \n",
       "Angola                       2756.953672     2430.208311     2627.845685   \n",
       "Benin                        1277.897616     1225.856010     1191.207681   \n",
       "Botswana                     4551.142150     6205.883850     7954.111645   \n",
       "Burkina Faso                  807.198586      912.063142      931.752773   \n",
       "Burundi                       559.603231      621.818819      631.699878   \n",
       "Cameroon                     2367.983282     2602.664206     1793.163278   \n",
       "Central African Republic      956.752991      844.876350      747.905525   \n",
       "Chad                          797.908101      952.386129     1058.064300   \n",
       "Comoros                      1267.100083     1315.980812     1246.907370   \n",
       "Congo Dem. Rep.               673.747818      672.774812      457.719181   \n",
       "Congo Rep.                   4879.507522     4201.194937     4016.239529   \n",
       "Cote d'Ivoire                2602.710169     2156.956069     1648.073791   \n",
       "Djibouti                     2879.468067     2880.102568     2377.156192   \n",
       "Egypt                        3503.729636     3885.460710     3794.755195   \n",
       "Equatorial Guinea             927.825343      966.896815     1132.055034   \n",
       "Eritrea                       524.875849      521.134133      582.858510   \n",
       "Ethiopia                      577.860747      573.741314      421.353465   \n",
       "Gabon                       15113.361940    11864.408440    13522.157520   \n",
       "Gambia                        835.809611      611.658861      665.624413   \n",
       "Ghana                         876.032569      847.006113      925.060154   \n",
       "Guinea                        857.250358      805.572472      794.348438   \n",
       "Guinea-Bissau                 838.123967      736.415392      745.539871   \n",
       "Kenya                        1348.225791     1361.936856     1341.921721   \n",
       "Lesotho                       797.263107      773.993214      977.486272   \n",
       "Liberia                       572.199569      506.113857      636.622919   \n",
       "Libya                       17364.275380    11770.589800     9640.138501   \n",
       "Madagascar                   1302.878658     1155.441948     1040.676190   \n",
       "Malawi                        632.803921      635.517363      563.200014   \n",
       "Mali                          618.014064      684.171558      739.014375   \n",
       "Mauritania                   1481.150189     1421.603576     1361.369784   \n",
       "Mauritius                    3688.037739     4783.586903     6058.253846   \n",
       "Morocco                      2702.620356     2755.046991     2948.047252   \n",
       "Mozambique                    462.211415      389.876185      410.896824   \n",
       "Namibia                      4191.100511     3693.731337     3804.537999   \n",
       "Niger                         909.722135      668.300023      581.182725   \n",
       "Nigeria                      1576.973750     1385.029563     1619.848217   \n",
       "Reunion                      5267.219353     5303.377488     6101.255823   \n",
       "Rwanda                        881.570647      847.991217      737.068595   \n",
       "Sao Tome and Principe        1890.218117     1516.525457     1428.777814   \n",
       "Senegal                      1518.479984     1441.720720     1367.899369   \n",
       "Sierra Leone                 1465.010784     1294.447788     1068.696278   \n",
       "Somalia                      1176.807031     1093.244963      926.960296   \n",
       "South Africa                 8568.266228     7825.823398     7225.069258   \n",
       "Sudan                        1895.544073     1507.819159     1492.197043   \n",
       "Swaziland                    3895.384018     3984.839812     3553.022400   \n",
       "Tanzania                      874.242607      831.822079      825.682454   \n",
       "Togo                         1344.577953     1202.201361     1034.298904   \n",
       "Tunisia                      3560.233174     3810.419296     4332.720164   \n",
       "Uganda                        682.266227      617.724406      644.170797   \n",
       "Zambia                       1408.678565     1213.315116     1210.884633   \n",
       "Zimbabwe                      788.855041      706.157306      693.420786   \n",
       "\n",
       "                          gdpPercap_1997  gdpPercap_2002  gdpPercap_2007  \n",
       "country                                                                   \n",
       "Algeria                      4797.295051     5288.040382     6223.367465  \n",
       "Angola                       2277.140884     2773.287312     4797.231267  \n",
       "Benin                        1232.975292     1372.877931     1441.284873  \n",
       "Botswana                     8647.142313    11003.605080    12569.851770  \n",
       "Burkina Faso                  946.294962     1037.645221     1217.032994  \n",
       "Burundi                       463.115148      446.403513      430.070692  \n",
       "Cameroon                     1694.337469     1934.011449     2042.095240  \n",
       "Central African Republic      740.506332      738.690607      706.016537  \n",
       "Chad                         1004.961353     1156.181860     1704.063724  \n",
       "Comoros                      1173.618235     1075.811558      986.147879  \n",
       "Congo Dem. Rep.               312.188423      241.165877      277.551859  \n",
       "Congo Rep.                   3484.164376     3484.061970     3632.557798  \n",
       "Cote d'Ivoire                1786.265407     1648.800823     1544.750112  \n",
       "Djibouti                     1895.016984     1908.260867     2082.481567  \n",
       "Egypt                        4173.181797     4754.604414     5581.180998  \n",
       "Equatorial Guinea            2814.480755     7703.495900    12154.089750  \n",
       "Eritrea                       913.470790      765.350001      641.369524  \n",
       "Ethiopia                      515.889401      530.053532      690.805576  \n",
       "Gabon                       14722.841880    12521.713920    13206.484520  \n",
       "Gambia                        653.730170      660.585600      752.749726  \n",
       "Ghana                        1005.245812     1111.984578     1327.608910  \n",
       "Guinea                        869.449767      945.583584      942.654211  \n",
       "Guinea-Bissau                 796.664468      575.704718      579.231743  \n",
       "Kenya                        1360.485021     1287.514732     1463.249282  \n",
       "Lesotho                      1186.147994     1275.184575     1569.331442  \n",
       "Liberia                       609.173951      531.482368      414.507341  \n",
       "Libya                        9467.446056     9534.677467    12057.499280  \n",
       "Madagascar                    986.295896      894.637082     1044.770126  \n",
       "Malawi                        692.275810      665.423119      759.349910  \n",
       "Mali                          790.257985      951.409752     1042.581557  \n",
       "Mauritania                   1483.136136     1579.019543     1803.151496  \n",
       "Mauritius                    7425.705295     9021.815894    10956.991120  \n",
       "Morocco                      2982.101858     3258.495584     3820.175230  \n",
       "Mozambique                    472.346077      633.617947      823.685621  \n",
       "Namibia                      3899.524260     4072.324751     4811.060429  \n",
       "Niger                         580.305209      601.074501      619.676892  \n",
       "Nigeria                      1624.941275     1615.286395     2013.977305  \n",
       "Reunion                      6071.941411     6316.165200     7670.122558  \n",
       "Rwanda                        589.944505      785.653765      863.088464  \n",
       "Sao Tome and Principe        1339.076036     1353.092390     1598.435089  \n",
       "Senegal                      1392.368347     1519.635262     1712.472136  \n",
       "Sierra Leone                  574.648158      699.489713      862.540756  \n",
       "Somalia                       930.596428      882.081822      926.141068  \n",
       "South Africa                 7479.188244     7710.946444     9269.657808  \n",
       "Sudan                        1632.210764     1993.398314     2602.394995  \n",
       "Swaziland                    3876.768460     4128.116943     4513.480643  \n",
       "Tanzania                      789.186223      899.074211     1107.482182  \n",
       "Togo                          982.286924      886.220577      882.969944  \n",
       "Tunisia                      4876.798614     5722.895655     7092.923025  \n",
       "Uganda                        816.559081      927.721002     1056.380121  \n",
       "Zambia                       1071.353818     1071.613938     1271.211593  \n",
       "Zimbabwe                      792.449960      672.038623      469.709298  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# lets look at the data:\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}