lessons/ETLPipelines/5_combinedata_exercise/5_combining_data-solution.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Combining Data\n",
    "\n",
    "Practice combining data from two different data sets. In the same folder as this Jupyter notebook, there are two csv files:\n",
    "* rural_population_percent.csv\n",
    "* electricity_access_percent.csv\n",
    "\n",
    "They both come from the World Bank Indicators data. \n",
    "* https://data.worldbank.org/indicator/SP.RUR.TOTL.ZS\n",
    "* https://data.worldbank.org/indicator/EG.ELC.ACCS.ZS\n",
    "\n",
    "The rural populaton data represents the percent of a country's population that is rural over time. The electricity access data shows the percentage of people with access to electricity.\n",
    "\n",
    "In this exercise, you will combine these two data sets together into one pandas data frame."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Exercise 1\n",
    "\n",
    "Combine the two data sets using the [pandas concat method](https://pandas.pydata.org/pandas-docs/stable/merging.html). In other words, find the union of the two data sets."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>Country Name</th>\n",
       "      <th>Country Code</th>\n",
       "      <th>Indicator Name</th>\n",
       "      <th>Indicator Code</th>\n",
       "      <th>1960</th>\n",
       "      <th>1961</th>\n",
       "      <th>1962</th>\n",
       "      <th>1963</th>\n",
       "      <th>1964</th>\n",
       "      <th>1965</th>\n",
       "      <th>...</th>\n",
       "      <th>2008</th>\n",
       "      <th>2009</th>\n",
       "      <th>2010</th>\n",
       "      <th>2011</th>\n",
       "      <th>2012</th>\n",
       "      <th>2013</th>\n",
       "      <th>2014</th>\n",
       "      <th>2015</th>\n",
       "      <th>2016</th>\n",
       "      <th>2017</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Aruba</td>\n",
       "      <td>ABW</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>49.224000</td>\n",
       "      <td>49.23900</td>\n",
       "      <td>49.25400</td>\n",
       "      <td>49.27000</td>\n",
       "      <td>49.285000</td>\n",
       "      <td>49.30000</td>\n",
       "      <td>...</td>\n",
       "      <td>56.217000</td>\n",
       "      <td>56.579000</td>\n",
       "      <td>56.941000</td>\n",
       "      <td>57.302000</td>\n",
       "      <td>57.636000</td>\n",
       "      <td>57.942000</td>\n",
       "      <td>58.221000</td>\n",
       "      <td>58.472000</td>\n",
       "      <td>58.696000</td>\n",
       "      <td>58.893000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>91.779000</td>\n",
       "      <td>91.49200</td>\n",
       "      <td>91.19500</td>\n",
       "      <td>90.89000</td>\n",
       "      <td>90.574000</td>\n",
       "      <td>90.25000</td>\n",
       "      <td>...</td>\n",
       "      <td>76.054000</td>\n",
       "      <td>75.687000</td>\n",
       "      <td>75.311000</td>\n",
       "      <td>74.926000</td>\n",
       "      <td>74.532000</td>\n",
       "      <td>74.129000</td>\n",
       "      <td>73.718000</td>\n",
       "      <td>73.297000</td>\n",
       "      <td>72.868000</td>\n",
       "      <td>72.430000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Angola</td>\n",
       "      <td>AGO</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>89.565000</td>\n",
       "      <td>89.20200</td>\n",
       "      <td>88.79600</td>\n",
       "      <td>88.37600</td>\n",
       "      <td>87.942000</td>\n",
       "      <td>87.49600</td>\n",
       "      <td>...</td>\n",
       "      <td>61.491000</td>\n",
       "      <td>60.701000</td>\n",
       "      <td>59.903000</td>\n",
       "      <td>59.100000</td>\n",
       "      <td>58.301000</td>\n",
       "      <td>57.510000</td>\n",
       "      <td>56.726000</td>\n",
       "      <td>55.950000</td>\n",
       "      <td>55.181000</td>\n",
       "      <td>54.422000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Albania</td>\n",
       "      <td>ALB</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>69.295000</td>\n",
       "      <td>69.05700</td>\n",
       "      <td>68.98500</td>\n",
       "      <td>68.91400</td>\n",
       "      <td>68.842000</td>\n",
       "      <td>68.77000</td>\n",
       "      <td>...</td>\n",
       "      <td>50.009000</td>\n",
       "      <td>48.924000</td>\n",
       "      <td>47.837000</td>\n",
       "      <td>46.753000</td>\n",
       "      <td>45.670000</td>\n",
       "      <td>44.617000</td>\n",
       "      <td>43.591000</td>\n",
       "      <td>42.593000</td>\n",
       "      <td>41.624000</td>\n",
       "      <td>40.684000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Andorra</td>\n",
       "      <td>AND</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>41.550000</td>\n",
       "      <td>39.01700</td>\n",
       "      <td>36.53800</td>\n",
       "      <td>34.12800</td>\n",
       "      <td>31.795000</td>\n",
       "      <td>29.55500</td>\n",
       "      <td>...</td>\n",
       "      <td>11.133000</td>\n",
       "      <td>11.648000</td>\n",
       "      <td>12.183000</td>\n",
       "      <td>12.740000</td>\n",
       "      <td>13.292000</td>\n",
       "      <td>13.835000</td>\n",
       "      <td>14.367000</td>\n",
       "      <td>14.885000</td>\n",
       "      <td>15.388000</td>\n",
       "      <td>15.873000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Arab World</td>\n",
       "      <td>ARB</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>68.708026</td>\n",
       "      <td>67.96558</td>\n",
       "      <td>67.21982</td>\n",
       "      <td>66.45096</td>\n",
       "      <td>65.652964</td>\n",
       "      <td>64.81343</td>\n",
       "      <td>...</td>\n",
       "      <td>44.518882</td>\n",
       "      <td>44.156769</td>\n",
       "      <td>43.804530</td>\n",
       "      <td>43.463488</td>\n",
       "      <td>43.128649</td>\n",
       "      <td>42.803731</td>\n",
       "      <td>42.491260</td>\n",
       "      <td>42.191790</td>\n",
       "      <td>41.906071</td>\n",
       "      <td>41.631967</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>United Arab Emirates</td>\n",
       "      <td>ARE</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>26.500000</td>\n",
       "      <td>25.61700</td>\n",
       "      <td>24.75200</td>\n",
       "      <td>23.90700</td>\n",
       "      <td>23.081000</td>\n",
       "      <td>22.27700</td>\n",
       "      <td>...</td>\n",
       "      <td>16.623000</td>\n",
       "      <td>16.277000</td>\n",
       "      <td>15.945000</td>\n",
       "      <td>15.625000</td>\n",
       "      <td>15.316000</td>\n",
       "      <td>15.019000</td>\n",
       "      <td>14.734000</td>\n",
       "      <td>14.459000</td>\n",
       "      <td>14.196000</td>\n",
       "      <td>13.942000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>ARG</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>26.389000</td>\n",
       "      <td>25.78300</td>\n",
       "      <td>25.23300</td>\n",
       "      <td>24.69100</td>\n",
       "      <td>24.156000</td>\n",
       "      <td>23.63100</td>\n",
       "      <td>...</td>\n",
       "      <td>9.378000</td>\n",
       "      <td>9.205000</td>\n",
       "      <td>9.034000</td>\n",
       "      <td>8.867000</td>\n",
       "      <td>8.705000</td>\n",
       "      <td>8.548000</td>\n",
       "      <td>8.396000</td>\n",
       "      <td>8.249000</td>\n",
       "      <td>8.107000</td>\n",
       "      <td>7.970000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Armenia</td>\n",
       "      <td>ARM</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>48.725000</td>\n",
       "      <td>47.85300</td>\n",
       "      <td>46.98100</td>\n",
       "      <td>46.11100</td>\n",
       "      <td>45.242000</td>\n",
       "      <td>44.37800</td>\n",
       "      <td>...</td>\n",
       "      <td>36.003000</td>\n",
       "      <td>36.211000</td>\n",
       "      <td>36.420000</td>\n",
       "      <td>36.629000</td>\n",
       "      <td>36.839000</td>\n",
       "      <td>37.025000</td>\n",
       "      <td>37.188000</td>\n",
       "      <td>37.327000</td>\n",
       "      <td>37.442000</td>\n",
       "      <td>37.533000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>American Samoa</td>\n",
       "      <td>ASM</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>33.789000</td>\n",
       "      <td>33.35900</td>\n",
       "      <td>32.93200</td>\n",
       "      <td>32.50700</td>\n",
       "      <td>32.084000</td>\n",
       "      <td>31.66600</td>\n",
       "      <td>...</td>\n",
       "      <td>12.201000</td>\n",
       "      <td>12.303000</td>\n",
       "      <td>12.406000</td>\n",
       "      <td>12.500000</td>\n",
       "      <td>12.587000</td>\n",
       "      <td>12.666000</td>\n",
       "      <td>12.736000</td>\n",
       "      <td>12.798000</td>\n",
       "      <td>12.852000</td>\n",
       "      <td>12.897000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Antigua and Barbuda</td>\n",
       "      <td>ATG</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>60.344000</td>\n",
       "      <td>60.96000</td>\n",
       "      <td>61.57300</td>\n",
       "      <td>62.18300</td>\n",
       "      <td>62.789000</td>\n",
       "      <td>63.39000</td>\n",
       "      <td>...</td>\n",
       "      <td>72.594000</td>\n",
       "      <td>73.181000</td>\n",
       "      <td>73.761000</td>\n",
       "      <td>74.333000</td>\n",
       "      <td>74.865000</td>\n",
       "      <td>75.357000</td>\n",
       "      <td>75.810000</td>\n",
       "      <td>76.227000</td>\n",
       "      <td>76.607000</td>\n",
       "      <td>76.953000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Australia</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>18.471000</td>\n",
       "      <td>18.05900</td>\n",
       "      <td>17.66300</td>\n",
       "      <td>17.27300</td>\n",
       "      <td>16.890000</td>\n",
       "      <td>16.51500</td>\n",
       "      <td>...</td>\n",
       "      <td>11.555000</td>\n",
       "      <td>11.410000</td>\n",
       "      <td>11.267000</td>\n",
       "      <td>11.125000</td>\n",
       "      <td>10.985000</td>\n",
       "      <td>10.847000</td>\n",
       "      <td>10.711000</td>\n",
       "      <td>10.577000</td>\n",
       "      <td>10.446000</td>\n",
       "      <td>10.317000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Austria</td>\n",
       "      <td>AUT</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>35.280000</td>\n",
       "      <td>35.18600</td>\n",
       "      <td>35.13700</td>\n",
       "      <td>35.08700</td>\n",
       "      <td>35.038000</td>\n",
       "      <td>34.98900</td>\n",
       "      <td>...</td>\n",
       "      <td>34.159000</td>\n",
       "      <td>34.153000</td>\n",
       "      <td>34.148000</td>\n",
       "      <td>34.142000</td>\n",
       "      <td>34.136000</td>\n",
       "      <td>34.116000</td>\n",
       "      <td>34.081000</td>\n",
       "      <td>34.032000</td>\n",
       "      <td>33.968000</td>\n",
       "      <td>33.890000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Azerbaijan</td>\n",
       "      <td>AZE</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>47.337000</td>\n",
       "      <td>47.63600</td>\n",
       "      <td>47.93600</td>\n",
       "      <td>48.23600</td>\n",
       "      <td>48.536000</td>\n",
       "      <td>48.83600</td>\n",
       "      <td>...</td>\n",
       "      <td>47.010000</td>\n",
       "      <td>46.810000</td>\n",
       "      <td>46.599000</td>\n",
       "      <td>46.377000</td>\n",
       "      <td>46.144000</td>\n",
       "      <td>45.900000</td>\n",
       "      <td>45.645000</td>\n",
       "      <td>45.380000</td>\n",
       "      <td>45.105000</td>\n",
       "      <td>44.819000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Burundi</td>\n",
       "      <td>BDI</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>97.923000</td>\n",
       "      <td>97.88500</td>\n",
       "      <td>97.84600</td>\n",
       "      <td>97.80700</td>\n",
       "      <td>97.767000</td>\n",
       "      <td>97.70600</td>\n",
       "      <td>...</td>\n",
       "      <td>89.882000</td>\n",
       "      <td>89.624000</td>\n",
       "      <td>89.359000</td>\n",
       "      <td>89.088000</td>\n",
       "      <td>88.811000</td>\n",
       "      <td>88.528000</td>\n",
       "      <td>88.239000</td>\n",
       "      <td>87.943000</td>\n",
       "      <td>87.641000</td>\n",
       "      <td>87.333000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Belgium</td>\n",
       "      <td>BEL</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>7.540000</td>\n",
       "      <td>7.44600</td>\n",
       "      <td>7.32100</td>\n",
       "      <td>7.16500</td>\n",
       "      <td>7.012000</td>\n",
       "      <td>6.86300</td>\n",
       "      <td>...</td>\n",
       "      <td>2.454000</td>\n",
       "      <td>2.406000</td>\n",
       "      <td>2.359000</td>\n",
       "      <td>2.313000</td>\n",
       "      <td>2.268000</td>\n",
       "      <td>2.224000</td>\n",
       "      <td>2.182000</td>\n",
       "      <td>2.142000</td>\n",
       "      <td>2.103000</td>\n",
       "      <td>2.066000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Benin</td>\n",
       "      <td>BEN</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>90.725000</td>\n",
       "      <td>90.14400</td>\n",
       "      <td>89.53000</td>\n",
       "      <td>88.88200</td>\n",
       "      <td>88.199000</td>\n",
       "      <td>87.48100</td>\n",
       "      <td>...</td>\n",
       "      <td>58.922000</td>\n",
       "      <td>58.539000</td>\n",
       "      <td>58.146000</td>\n",
       "      <td>57.744000</td>\n",
       "      <td>57.333000</td>\n",
       "      <td>56.914000</td>\n",
       "      <td>56.486000</td>\n",
       "      <td>56.050000</td>\n",
       "      <td>55.605000</td>\n",
       "      <td>55.153000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Burkina Faso</td>\n",
       "      <td>BFA</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>95.300000</td>\n",
       "      <td>95.20400</td>\n",
       "      <td>95.10700</td>\n",
       "      <td>95.00700</td>\n",
       "      <td>94.905000</td>\n",
       "      <td>94.80200</td>\n",
       "      <td>...</td>\n",
       "      <td>76.007000</td>\n",
       "      <td>75.172000</td>\n",
       "      <td>74.335000</td>\n",
       "      <td>73.495000</td>\n",
       "      <td>72.654000</td>\n",
       "      <td>71.814000</td>\n",
       "      <td>70.976000</td>\n",
       "      <td>70.141000</td>\n",
       "      <td>69.312000</td>\n",
       "      <td>68.489000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Bangladesh</td>\n",
       "      <td>BGD</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>94.865000</td>\n",
       "      <td>94.72200</td>\n",
       "      <td>94.50200</td>\n",
       "      <td>94.27300</td>\n",
       "      <td>94.036000</td>\n",
       "      <td>93.78900</td>\n",
       "      <td>...</td>\n",
       "      <td>71.032000</td>\n",
       "      <td>70.291000</td>\n",
       "      <td>69.538000</td>\n",
       "      <td>68.775000</td>\n",
       "      <td>68.010000</td>\n",
       "      <td>67.247000</td>\n",
       "      <td>66.484000</td>\n",
       "      <td>65.723000</td>\n",
       "      <td>64.965000</td>\n",
       "      <td>64.210000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Bulgaria</td>\n",
       "      <td>BGR</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>62.900000</td>\n",
       "      <td>61.21800</td>\n",
       "      <td>59.50600</td>\n",
       "      <td>57.77000</td>\n",
       "      <td>56.013000</td>\n",
       "      <td>54.24500</td>\n",
       "      <td>...</td>\n",
       "      <td>28.378000</td>\n",
       "      <td>28.037000</td>\n",
       "      <td>27.698000</td>\n",
       "      <td>27.362000</td>\n",
       "      <td>27.029000</td>\n",
       "      <td>26.700000</td>\n",
       "      <td>26.374000</td>\n",
       "      <td>26.052000</td>\n",
       "      <td>25.734000</td>\n",
       "      <td>25.419000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Bahrain</td>\n",
       "      <td>BHR</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>17.680000</td>\n",
       "      <td>17.66300</td>\n",
       "      <td>17.64500</td>\n",
       "      <td>17.62800</td>\n",
       "      <td>17.611000</td>\n",
       "      <td>17.50000</td>\n",
       "      <td>...</td>\n",
       "      <td>11.532000</td>\n",
       "      <td>11.500000</td>\n",
       "      <td>11.465000</td>\n",
       "      <td>11.425000</td>\n",
       "      <td>11.381000</td>\n",
       "      <td>11.333000</td>\n",
       "      <td>11.281000</td>\n",
       "      <td>11.225000</td>\n",
       "      <td>11.165000</td>\n",
       "      <td>11.101000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Bahamas, The</td>\n",
       "      <td>BHS</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>40.288000</td>\n",
       "      <td>39.54600</td>\n",
       "      <td>38.80700</td>\n",
       "      <td>38.07400</td>\n",
       "      <td>37.358000</td>\n",
       "      <td>36.65700</td>\n",
       "      <td>...</td>\n",
       "      <td>17.558000</td>\n",
       "      <td>17.505000</td>\n",
       "      <td>17.451000</td>\n",
       "      <td>17.394000</td>\n",
       "      <td>17.333000</td>\n",
       "      <td>17.268000</td>\n",
       "      <td>17.199000</td>\n",
       "      <td>17.126000</td>\n",
       "      <td>17.049000</td>\n",
       "      <td>16.969000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Bosnia and Herzegovina</td>\n",
       "      <td>BIH</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>80.960000</td>\n",
       "      <td>80.31400</td>\n",
       "      <td>79.56300</td>\n",
       "      <td>78.79100</td>\n",
       "      <td>77.996000</td>\n",
       "      <td>77.18300</td>\n",
       "      <td>...</td>\n",
       "      <td>60.839000</td>\n",
       "      <td>60.817000</td>\n",
       "      <td>60.774000</td>\n",
       "      <td>60.709000</td>\n",
       "      <td>60.622000</td>\n",
       "      <td>60.514000</td>\n",
       "      <td>60.384000</td>\n",
       "      <td>60.233000</td>\n",
       "      <td>60.060000</td>\n",
       "      <td>59.865000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Belarus</td>\n",
       "      <td>BLR</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>67.599000</td>\n",
       "      <td>66.47800</td>\n",
       "      <td>65.33700</td>\n",
       "      <td>64.17800</td>\n",
       "      <td>63.000000</td>\n",
       "      <td>61.87300</td>\n",
       "      <td>...</td>\n",
       "      <td>26.274000</td>\n",
       "      <td>25.828000</td>\n",
       "      <td>25.385000</td>\n",
       "      <td>24.954000</td>\n",
       "      <td>24.533000</td>\n",
       "      <td>24.123000</td>\n",
       "      <td>23.723000</td>\n",
       "      <td>23.333000</td>\n",
       "      <td>22.954000</td>\n",
       "      <td>22.584000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Belize</td>\n",
       "      <td>BLZ</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>45.972000</td>\n",
       "      <td>46.28000</td>\n",
       "      <td>46.59000</td>\n",
       "      <td>46.89900</td>\n",
       "      <td>47.210000</td>\n",
       "      <td>47.51900</td>\n",
       "      <td>...</td>\n",
       "      <td>54.499000</td>\n",
       "      <td>54.768000</td>\n",
       "      <td>55.037000</td>\n",
       "      <td>55.282000</td>\n",
       "      <td>55.504000</td>\n",
       "      <td>55.702000</td>\n",
       "      <td>55.876000</td>\n",
       "      <td>56.027000</td>\n",
       "      <td>56.155000</td>\n",
       "      <td>56.258000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Bermuda</td>\n",
       "      <td>BMU</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Bolivia</td>\n",
       "      <td>BOL</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>63.238000</td>\n",
       "      <td>62.94100</td>\n",
       "      <td>62.64300</td>\n",
       "      <td>62.34400</td>\n",
       "      <td>62.043000</td>\n",
       "      <td>61.74300</td>\n",
       "      <td>...</td>\n",
       "      <td>34.450000</td>\n",
       "      <td>34.009000</td>\n",
       "      <td>33.574000</td>\n",
       "      <td>33.145000</td>\n",
       "      <td>32.721000</td>\n",
       "      <td>32.304000</td>\n",
       "      <td>31.893000</td>\n",
       "      <td>31.488000</td>\n",
       "      <td>31.089000</td>\n",
       "      <td>30.697000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Brazil</td>\n",
       "      <td>BRA</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>53.861000</td>\n",
       "      <td>52.87800</td>\n",
       "      <td>51.90100</td>\n",
       "      <td>50.92200</td>\n",
       "      <td>49.941000</td>\n",
       "      <td>48.96300</td>\n",
       "      <td>...</td>\n",
       "      <td>16.251000</td>\n",
       "      <td>15.956000</td>\n",
       "      <td>15.665000</td>\n",
       "      <td>15.377000</td>\n",
       "      <td>15.099000</td>\n",
       "      <td>14.829000</td>\n",
       "      <td>14.567000</td>\n",
       "      <td>14.313000</td>\n",
       "      <td>14.067000</td>\n",
       "      <td>13.828000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Barbados</td>\n",
       "      <td>BRB</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>63.223000</td>\n",
       "      <td>63.15100</td>\n",
       "      <td>63.07800</td>\n",
       "      <td>63.00500</td>\n",
       "      <td>62.932000</td>\n",
       "      <td>62.85900</td>\n",
       "      <td>...</td>\n",
       "      <td>67.590000</td>\n",
       "      <td>67.765000</td>\n",
       "      <td>67.940000</td>\n",
       "      <td>68.095000</td>\n",
       "      <td>68.231000</td>\n",
       "      <td>68.348000</td>\n",
       "      <td>68.446000</td>\n",
       "      <td>68.525000</td>\n",
       "      <td>68.585000</td>\n",
       "      <td>68.626000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Brunei Darussalam</td>\n",
       "      <td>BRN</td>\n",
       "      <td>Rural population (% of total population)</td>\n",
       "      <td>SP.RUR.TOTL.ZS</td>\n",
       "      <td>56.599000</td>\n",
       "      <td>54.77200</td>\n",
       "      <td>52.93000</td>\n",
       "      <td>51.08000</td>\n",
       "      <td>49.224000</td>\n",
       "      <td>47.37500</td>\n",
       "      <td>...</td>\n",
       "      <td>25.254000</td>\n",
       "      <td>24.866000</td>\n",
       "      <td>24.490000</td>\n",
       "      <td>24.128000</td>\n",
       "      <td>23.777000</td>\n",
       "      <td>23.439000</td>\n",
       "      <td>23.113000</td>\n",
       "      <td>22.798000</td>\n",
       "      <td>22.495000</td>\n",
       "      <td>22.203000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>Latin America &amp; the Caribbean (IDA &amp; IBRD coun...</td>\n",
       "      <td>TLA</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>95.186103</td>\n",
       "      <td>95.441090</td>\n",
       "      <td>95.801052</td>\n",
       "      <td>96.161153</td>\n",
       "      <td>96.522279</td>\n",
       "      <td>96.922377</td>\n",
       "      <td>96.936467</td>\n",
       "      <td>97.183215</td>\n",
       "      <td>97.742979</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>Timor-Leste</td>\n",
       "      <td>TLS</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>41.100101</td>\n",
       "      <td>43.844738</td>\n",
       "      <td>38.000000</td>\n",
       "      <td>49.385078</td>\n",
       "      <td>52.174774</td>\n",
       "      <td>54.973484</td>\n",
       "      <td>57.778198</td>\n",
       "      <td>67.281534</td>\n",
       "      <td>63.394138</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>Middle East &amp; North Africa (IDA &amp; IBRD countries)</td>\n",
       "      <td>TMN</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>94.760384</td>\n",
       "      <td>95.008710</td>\n",
       "      <td>95.297786</td>\n",
       "      <td>95.910895</td>\n",
       "      <td>96.376501</td>\n",
       "      <td>97.506184</td>\n",
       "      <td>96.325711</td>\n",
       "      <td>97.493216</td>\n",
       "      <td>97.671447</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>Tonga</td>\n",
       "      <td>TON</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>90.780235</td>\n",
       "      <td>91.511932</td>\n",
       "      <td>92.261650</td>\n",
       "      <td>92.175456</td>\n",
       "      <td>92.800000</td>\n",
       "      <td>94.588905</td>\n",
       "      <td>95.380676</td>\n",
       "      <td>96.175453</td>\n",
       "      <td>97.020000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>South Asia (IDA &amp; IBRD)</td>\n",
       "      <td>TSA</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>70.641563</td>\n",
       "      <td>74.025057</td>\n",
       "      <td>75.117519</td>\n",
       "      <td>69.326529</td>\n",
       "      <td>79.352935</td>\n",
       "      <td>79.318324</td>\n",
       "      <td>81.448690</td>\n",
       "      <td>86.513987</td>\n",
       "      <td>85.569150</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>Sub-Saharan Africa (IDA &amp; IBRD countries)</td>\n",
       "      <td>TSS</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>31.973327</td>\n",
       "      <td>32.490060</td>\n",
       "      <td>32.633561</td>\n",
       "      <td>34.880128</td>\n",
       "      <td>35.770348</td>\n",
       "      <td>36.542705</td>\n",
       "      <td>37.760013</td>\n",
       "      <td>38.459815</td>\n",
       "      <td>42.813754</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>Trinidad and Tobago</td>\n",
       "      <td>TTO</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>97.827667</td>\n",
       "      <td>99.000000</td>\n",
       "      <td>99.298363</td>\n",
       "      <td>99.736145</td>\n",
       "      <td>99.936935</td>\n",
       "      <td>99.992935</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>Tunisia</td>\n",
       "      <td>TUN</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>99.400000</td>\n",
       "      <td>99.500000</td>\n",
       "      <td>99.500000</td>\n",
       "      <td>99.500000</td>\n",
       "      <td>99.500000</td>\n",
       "      <td>99.700000</td>\n",
       "      <td>99.800000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>Turkey</td>\n",
       "      <td>TUR</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>98.806900</td>\n",
       "      <td>99.310745</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>99.910782</td>\n",
       "      <td>99.985657</td>\n",
       "      <td>99.999252</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>Tuvalu</td>\n",
       "      <td>TUV</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>96.450043</td>\n",
       "      <td>96.779938</td>\n",
       "      <td>97.127861</td>\n",
       "      <td>97.490799</td>\n",
       "      <td>97.671777</td>\n",
       "      <td>98.249725</td>\n",
       "      <td>98.639702</td>\n",
       "      <td>99.032677</td>\n",
       "      <td>99.426155</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>Tanzania</td>\n",
       "      <td>TZA</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>11.500000</td>\n",
       "      <td>11.200000</td>\n",
       "      <td>14.800000</td>\n",
       "      <td>14.200000</td>\n",
       "      <td>15.300000</td>\n",
       "      <td>16.400000</td>\n",
       "      <td>18.910179</td>\n",
       "      <td>18.500000</td>\n",
       "      <td>32.800000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>Uganda</td>\n",
       "      <td>UGA</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>13.383857</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>14.769371</td>\n",
       "      <td>14.600000</td>\n",
       "      <td>16.214964</td>\n",
       "      <td>13.900000</td>\n",
       "      <td>20.400000</td>\n",
       "      <td>18.500000</td>\n",
       "      <td>26.700000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>Ukraine</td>\n",
       "      <td>UKR</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>99.782707</td>\n",
       "      <td>99.872482</td>\n",
       "      <td>99.945076</td>\n",
       "      <td>99.985046</td>\n",
       "      <td>99.867491</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>Upper middle income</td>\n",
       "      <td>UMC</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>97.951365</td>\n",
       "      <td>98.322811</td>\n",
       "      <td>98.775502</td>\n",
       "      <td>98.866005</td>\n",
       "      <td>99.059438</td>\n",
       "      <td>99.214211</td>\n",
       "      <td>99.235891</td>\n",
       "      <td>99.268934</td>\n",
       "      <td>99.379714</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>Uruguay</td>\n",
       "      <td>URY</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>98.784355</td>\n",
       "      <td>98.830696</td>\n",
       "      <td>98.989487</td>\n",
       "      <td>99.170000</td>\n",
       "      <td>99.349075</td>\n",
       "      <td>99.611808</td>\n",
       "      <td>99.657085</td>\n",
       "      <td>99.709480</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>United States</td>\n",
       "      <td>USA</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>Uzbekistan</td>\n",
       "      <td>UZB</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>99.902954</td>\n",
       "      <td>99.955498</td>\n",
       "      <td>99.986694</td>\n",
       "      <td>99.997910</td>\n",
       "      <td>99.999908</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>St. Vincent and the Grenadines</td>\n",
       "      <td>VCT</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>90.470222</td>\n",
       "      <td>91.837242</td>\n",
       "      <td>93.222282</td>\n",
       "      <td>94.622345</td>\n",
       "      <td>96.034424</td>\n",
       "      <td>97.455513</td>\n",
       "      <td>98.598648</td>\n",
       "      <td>99.455063</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>Venezuela, RB</td>\n",
       "      <td>VEN</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>98.630798</td>\n",
       "      <td>98.710304</td>\n",
       "      <td>98.807846</td>\n",
       "      <td>98.840000</td>\n",
       "      <td>99.044968</td>\n",
       "      <td>99.178551</td>\n",
       "      <td>99.318146</td>\n",
       "      <td>99.460739</td>\n",
       "      <td>99.603836</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>British Virgin Islands</td>\n",
       "      <td>VGB</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>Virgin Islands (U.S.)</td>\n",
       "      <td>VIR</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>Vietnam</td>\n",
       "      <td>VNM</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>95.208260</td>\n",
       "      <td>96.100000</td>\n",
       "      <td>97.591133</td>\n",
       "      <td>99.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>99.200000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>Vanuatu</td>\n",
       "      <td>VUT</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>33.873974</td>\n",
       "      <td>33.291115</td>\n",
       "      <td>36.898365</td>\n",
       "      <td>38.434589</td>\n",
       "      <td>39.982830</td>\n",
       "      <td>31.700000</td>\n",
       "      <td>43.103348</td>\n",
       "      <td>44.669613</td>\n",
       "      <td>57.820000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>World</td>\n",
       "      <td>WLD</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>82.278317</td>\n",
       "      <td>83.211382</td>\n",
       "      <td>83.539093</td>\n",
       "      <td>82.504609</td>\n",
       "      <td>85.041356</td>\n",
       "      <td>85.163456</td>\n",
       "      <td>85.690892</td>\n",
       "      <td>87.028468</td>\n",
       "      <td>87.351269</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>Samoa</td>\n",
       "      <td>WSM</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>94.694328</td>\n",
       "      <td>97.900000</td>\n",
       "      <td>96.606010</td>\n",
       "      <td>96.668575</td>\n",
       "      <td>98.504707</td>\n",
       "      <td>99.255646</td>\n",
       "      <td>97.900000</td>\n",
       "      <td>99.938278</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>Kosovo</td>\n",
       "      <td>XKX</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>97.794670</td>\n",
       "      <td>98.377060</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>99.430435</td>\n",
       "      <td>99.773651</td>\n",
       "      <td>99.942505</td>\n",
       "      <td>99.993134</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>Yemen, Rep.</td>\n",
       "      <td>YEM</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>60.386539</td>\n",
       "      <td>61.751400</td>\n",
       "      <td>63.134281</td>\n",
       "      <td>64.532181</td>\n",
       "      <td>65.942101</td>\n",
       "      <td>75.600000</td>\n",
       "      <td>66.100000</td>\n",
       "      <td>70.213905</td>\n",
       "      <td>71.642349</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>261</th>\n",
       "      <td>South Africa</td>\n",
       "      <td>ZAF</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>81.900000</td>\n",
       "      <td>82.700000</td>\n",
       "      <td>82.900000</td>\n",
       "      <td>84.700000</td>\n",
       "      <td>85.300000</td>\n",
       "      <td>85.400000</td>\n",
       "      <td>86.000000</td>\n",
       "      <td>85.500000</td>\n",
       "      <td>84.200000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262</th>\n",
       "      <td>Zambia</td>\n",
       "      <td>ZMB</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>22.714685</td>\n",
       "      <td>23.235649</td>\n",
       "      <td>22.000000</td>\n",
       "      <td>24.328644</td>\n",
       "      <td>24.894667</td>\n",
       "      <td>25.469702</td>\n",
       "      <td>27.900000</td>\n",
       "      <td>31.100000</td>\n",
       "      <td>27.219337</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>Access to electricity (% of population)</td>\n",
       "      <td>EG.ELC.ACCS.ZS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>35.457310</td>\n",
       "      <td>43.369082</td>\n",
       "      <td>36.063057</td>\n",
       "      <td>36.900000</td>\n",
       "      <td>36.728878</td>\n",
       "      <td>37.076813</td>\n",
       "      <td>32.300000</td>\n",
       "      <td>33.700000</td>\n",
       "      <td>38.145138</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>528 rows × 62 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          Country Name Country Code  \\\n",
       "0                                                Aruba          ABW   \n",
       "1                                          Afghanistan          AFG   \n",
       "2                                               Angola          AGO   \n",
       "3                                              Albania          ALB   \n",
       "4                                              Andorra          AND   \n",
       "5                                           Arab World          ARB   \n",
       "6                                 United Arab Emirates          ARE   \n",
       "7                                            Argentina          ARG   \n",
       "8                                              Armenia          ARM   \n",
       "9                                       American Samoa          ASM   \n",
       "10                                 Antigua and Barbuda          ATG   \n",
       "11                                           Australia          AUS   \n",
       "12                                             Austria          AUT   \n",
       "13                                          Azerbaijan          AZE   \n",
       "14                                             Burundi          BDI   \n",
       "15                                             Belgium          BEL   \n",
       "16                                               Benin          BEN   \n",
       "17                                        Burkina Faso          BFA   \n",
       "18                                          Bangladesh          BGD   \n",
       "19                                            Bulgaria          BGR   \n",
       "20                                             Bahrain          BHR   \n",
       "21                                        Bahamas, The          BHS   \n",
       "22                              Bosnia and Herzegovina          BIH   \n",
       "23                                             Belarus          BLR   \n",
       "24                                              Belize          BLZ   \n",
       "25                                             Bermuda          BMU   \n",
       "26                                             Bolivia          BOL   \n",
       "27                                              Brazil          BRA   \n",
       "28                                            Barbados          BRB   \n",
       "29                                   Brunei Darussalam          BRN   \n",
       "..                                                 ...          ...   \n",
       "234  Latin America & the Caribbean (IDA & IBRD coun...          TLA   \n",
       "235                                        Timor-Leste          TLS   \n",
       "236  Middle East & North Africa (IDA & IBRD countries)          TMN   \n",
       "237                                              Tonga          TON   \n",
       "238                            South Asia (IDA & IBRD)          TSA   \n",
       "239          Sub-Saharan Africa (IDA & IBRD countries)          TSS   \n",
       "240                                Trinidad and Tobago          TTO   \n",
       "241                                            Tunisia          TUN   \n",
       "242                                             Turkey          TUR   \n",
       "243                                             Tuvalu          TUV   \n",
       "244                                           Tanzania          TZA   \n",
       "245                                             Uganda          UGA   \n",
       "246                                            Ukraine          UKR   \n",
       "247                                Upper middle income          UMC   \n",
       "248                                            Uruguay          URY   \n",
       "249                                      United States          USA   \n",
       "250                                         Uzbekistan          UZB   \n",
       "251                     St. Vincent and the Grenadines          VCT   \n",
       "252                                      Venezuela, RB          VEN   \n",
       "253                             British Virgin Islands          VGB   \n",
       "254                              Virgin Islands (U.S.)          VIR   \n",
       "255                                            Vietnam          VNM   \n",
       "256                                            Vanuatu          VUT   \n",
       "257                                              World          WLD   \n",
       "258                                              Samoa          WSM   \n",
       "259                                             Kosovo          XKX   \n",
       "260                                        Yemen, Rep.          YEM   \n",
       "261                                       South Africa          ZAF   \n",
       "262                                             Zambia          ZMB   \n",
       "263                                           Zimbabwe          ZWE   \n",
       "\n",
       "                               Indicator Name  Indicator Code       1960  \\\n",
       "0    Rural population (% of total population)  SP.RUR.TOTL.ZS  49.224000   \n",
       "1    Rural population (% of total population)  SP.RUR.TOTL.ZS  91.779000   \n",
       "2    Rural population (% of total population)  SP.RUR.TOTL.ZS  89.565000   \n",
       "3    Rural population (% of total population)  SP.RUR.TOTL.ZS  69.295000   \n",
       "4    Rural population (% of total population)  SP.RUR.TOTL.ZS  41.550000   \n",
       "5    Rural population (% of total population)  SP.RUR.TOTL.ZS  68.708026   \n",
       "6    Rural population (% of total population)  SP.RUR.TOTL.ZS  26.500000   \n",
       "7    Rural population (% of total population)  SP.RUR.TOTL.ZS  26.389000   \n",
       "8    Rural population (% of total population)  SP.RUR.TOTL.ZS  48.725000   \n",
       "9    Rural population (% of total population)  SP.RUR.TOTL.ZS  33.789000   \n",
       "10   Rural population (% of total population)  SP.RUR.TOTL.ZS  60.344000   \n",
       "11   Rural population (% of total population)  SP.RUR.TOTL.ZS  18.471000   \n",
       "12   Rural population (% of total population)  SP.RUR.TOTL.ZS  35.280000   \n",
       "13   Rural population (% of total population)  SP.RUR.TOTL.ZS  47.337000   \n",
       "14   Rural population (% of total population)  SP.RUR.TOTL.ZS  97.923000   \n",
       "15   Rural population (% of total population)  SP.RUR.TOTL.ZS   7.540000   \n",
       "16   Rural population (% of total population)  SP.RUR.TOTL.ZS  90.725000   \n",
       "17   Rural population (% of total population)  SP.RUR.TOTL.ZS  95.300000   \n",
       "18   Rural population (% of total population)  SP.RUR.TOTL.ZS  94.865000   \n",
       "19   Rural population (% of total population)  SP.RUR.TOTL.ZS  62.900000   \n",
       "20   Rural population (% of total population)  SP.RUR.TOTL.ZS  17.680000   \n",
       "21   Rural population (% of total population)  SP.RUR.TOTL.ZS  40.288000   \n",
       "22   Rural population (% of total population)  SP.RUR.TOTL.ZS  80.960000   \n",
       "23   Rural population (% of total population)  SP.RUR.TOTL.ZS  67.599000   \n",
       "24   Rural population (% of total population)  SP.RUR.TOTL.ZS  45.972000   \n",
       "25   Rural population (% of total population)  SP.RUR.TOTL.ZS   0.000000   \n",
       "26   Rural population (% of total population)  SP.RUR.TOTL.ZS  63.238000   \n",
       "27   Rural population (% of total population)  SP.RUR.TOTL.ZS  53.861000   \n",
       "28   Rural population (% of total population)  SP.RUR.TOTL.ZS  63.223000   \n",
       "29   Rural population (% of total population)  SP.RUR.TOTL.ZS  56.599000   \n",
       "..                                        ...             ...        ...   \n",
       "234   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "235   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "236   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "237   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "238   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "239   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "240   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "241   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "242   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "243   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "244   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "245   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "246   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "247   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "248   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "249   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "250   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "251   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "252   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "253   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "254   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "255   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "256   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "257   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "258   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "259   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "260   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "261   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "262   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "263   Access to electricity (% of population)  EG.ELC.ACCS.ZS        NaN   \n",
       "\n",
       "         1961      1962      1963       1964      1965    ...            2008  \\\n",
       "0    49.23900  49.25400  49.27000  49.285000  49.30000    ...       56.217000   \n",
       "1    91.49200  91.19500  90.89000  90.574000  90.25000    ...       76.054000   \n",
       "2    89.20200  88.79600  88.37600  87.942000  87.49600    ...       61.491000   \n",
       "3    69.05700  68.98500  68.91400  68.842000  68.77000    ...       50.009000   \n",
       "4    39.01700  36.53800  34.12800  31.795000  29.55500    ...       11.133000   \n",
       "5    67.96558  67.21982  66.45096  65.652964  64.81343    ...       44.518882   \n",
       "6    25.61700  24.75200  23.90700  23.081000  22.27700    ...       16.623000   \n",
       "7    25.78300  25.23300  24.69100  24.156000  23.63100    ...        9.378000   \n",
       "8    47.85300  46.98100  46.11100  45.242000  44.37800    ...       36.003000   \n",
       "9    33.35900  32.93200  32.50700  32.084000  31.66600    ...       12.201000   \n",
       "10   60.96000  61.57300  62.18300  62.789000  63.39000    ...       72.594000   \n",
       "11   18.05900  17.66300  17.27300  16.890000  16.51500    ...       11.555000   \n",
       "12   35.18600  35.13700  35.08700  35.038000  34.98900    ...       34.159000   \n",
       "13   47.63600  47.93600  48.23600  48.536000  48.83600    ...       47.010000   \n",
       "14   97.88500  97.84600  97.80700  97.767000  97.70600    ...       89.882000   \n",
       "15    7.44600   7.32100   7.16500   7.012000   6.86300    ...        2.454000   \n",
       "16   90.14400  89.53000  88.88200  88.199000  87.48100    ...       58.922000   \n",
       "17   95.20400  95.10700  95.00700  94.905000  94.80200    ...       76.007000   \n",
       "18   94.72200  94.50200  94.27300  94.036000  93.78900    ...       71.032000   \n",
       "19   61.21800  59.50600  57.77000  56.013000  54.24500    ...       28.378000   \n",
       "20   17.66300  17.64500  17.62800  17.611000  17.50000    ...       11.532000   \n",
       "21   39.54600  38.80700  38.07400  37.358000  36.65700    ...       17.558000   \n",
       "22   80.31400  79.56300  78.79100  77.996000  77.18300    ...       60.839000   \n",
       "23   66.47800  65.33700  64.17800  63.000000  61.87300    ...       26.274000   \n",
       "24   46.28000  46.59000  46.89900  47.210000  47.51900    ...       54.499000   \n",
       "25    0.00000   0.00000   0.00000   0.000000   0.00000    ...        0.000000   \n",
       "26   62.94100  62.64300  62.34400  62.043000  61.74300    ...       34.450000   \n",
       "27   52.87800  51.90100  50.92200  49.941000  48.96300    ...       16.251000   \n",
       "28   63.15100  63.07800  63.00500  62.932000  62.85900    ...       67.590000   \n",
       "29   54.77200  52.93000  51.08000  49.224000  47.37500    ...       25.254000   \n",
       "..        ...       ...       ...        ...       ...    ...             ...   \n",
       "234       NaN       NaN       NaN        NaN       NaN    ...       95.186103   \n",
       "235       NaN       NaN       NaN        NaN       NaN    ...       41.100101   \n",
       "236       NaN       NaN       NaN        NaN       NaN    ...       94.760384   \n",
       "237       NaN       NaN       NaN        NaN       NaN    ...       90.780235   \n",
       "238       NaN       NaN       NaN        NaN       NaN    ...       70.641563   \n",
       "239       NaN       NaN       NaN        NaN       NaN    ...       31.973327   \n",
       "240       NaN       NaN       NaN        NaN       NaN    ...       97.827667   \n",
       "241       NaN       NaN       NaN        NaN       NaN    ...       99.400000   \n",
       "242       NaN       NaN       NaN        NaN       NaN    ...       98.806900   \n",
       "243       NaN       NaN       NaN        NaN       NaN    ...       96.450043   \n",
       "244       NaN       NaN       NaN        NaN       NaN    ...       11.500000   \n",
       "245       NaN       NaN       NaN        NaN       NaN    ...       13.383857   \n",
       "246       NaN       NaN       NaN        NaN       NaN    ...       99.782707   \n",
       "247       NaN       NaN       NaN        NaN       NaN    ...       97.951365   \n",
       "248       NaN       NaN       NaN        NaN       NaN    ...       98.784355   \n",
       "249       NaN       NaN       NaN        NaN       NaN    ...      100.000000   \n",
       "250       NaN       NaN       NaN        NaN       NaN    ...       99.902954   \n",
       "251       NaN       NaN       NaN        NaN       NaN    ...       90.470222   \n",
       "252       NaN       NaN       NaN        NaN       NaN    ...       98.630798   \n",
       "253       NaN       NaN       NaN        NaN       NaN    ...             NaN   \n",
       "254       NaN       NaN       NaN        NaN       NaN    ...      100.000000   \n",
       "255       NaN       NaN       NaN        NaN       NaN    ...       95.208260   \n",
       "256       NaN       NaN       NaN        NaN       NaN    ...       33.873974   \n",
       "257       NaN       NaN       NaN        NaN       NaN    ...       82.278317   \n",
       "258       NaN       NaN       NaN        NaN       NaN    ...       94.694328   \n",
       "259       NaN       NaN       NaN        NaN       NaN    ...       97.794670   \n",
       "260       NaN       NaN       NaN        NaN       NaN    ...       60.386539   \n",
       "261       NaN       NaN       NaN        NaN       NaN    ...       81.900000   \n",
       "262       NaN       NaN       NaN        NaN       NaN    ...       22.714685   \n",
       "263       NaN       NaN       NaN        NaN       NaN    ...       35.457310   \n",
       "\n",
       "           2009        2010        2011        2012        2013        2014  \\\n",
       "0     56.579000   56.941000   57.302000   57.636000   57.942000   58.221000   \n",
       "1     75.687000   75.311000   74.926000   74.532000   74.129000   73.718000   \n",
       "2     60.701000   59.903000   59.100000   58.301000   57.510000   56.726000   \n",
       "3     48.924000   47.837000   46.753000   45.670000   44.617000   43.591000   \n",
       "4     11.648000   12.183000   12.740000   13.292000   13.835000   14.367000   \n",
       "5     44.156769   43.804530   43.463488   43.128649   42.803731   42.491260   \n",
       "6     16.277000   15.945000   15.625000   15.316000   15.019000   14.734000   \n",
       "7      9.205000    9.034000    8.867000    8.705000    8.548000    8.396000   \n",
       "8     36.211000   36.420000   36.629000   36.839000   37.025000   37.188000   \n",
       "9     12.303000   12.406000   12.500000   12.587000   12.666000   12.736000   \n",
       "10    73.181000   73.761000   74.333000   74.865000   75.357000   75.810000   \n",
       "11    11.410000   11.267000   11.125000   10.985000   10.847000   10.711000   \n",
       "12    34.153000   34.148000   34.142000   34.136000   34.116000   34.081000   \n",
       "13    46.810000   46.599000   46.377000   46.144000   45.900000   45.645000   \n",
       "14    89.624000   89.359000   89.088000   88.811000   88.528000   88.239000   \n",
       "15     2.406000    2.359000    2.313000    2.268000    2.224000    2.182000   \n",
       "16    58.539000   58.146000   57.744000   57.333000   56.914000   56.486000   \n",
       "17    75.172000   74.335000   73.495000   72.654000   71.814000   70.976000   \n",
       "18    70.291000   69.538000   68.775000   68.010000   67.247000   66.484000   \n",
       "19    28.037000   27.698000   27.362000   27.029000   26.700000   26.374000   \n",
       "20    11.500000   11.465000   11.425000   11.381000   11.333000   11.281000   \n",
       "21    17.505000   17.451000   17.394000   17.333000   17.268000   17.199000   \n",
       "22    60.817000   60.774000   60.709000   60.622000   60.514000   60.384000   \n",
       "23    25.828000   25.385000   24.954000   24.533000   24.123000   23.723000   \n",
       "24    54.768000   55.037000   55.282000   55.504000   55.702000   55.876000   \n",
       "25     0.000000    0.000000    0.000000    0.000000    0.000000    0.000000   \n",
       "26    34.009000   33.574000   33.145000   32.721000   32.304000   31.893000   \n",
       "27    15.956000   15.665000   15.377000   15.099000   14.829000   14.567000   \n",
       "28    67.765000   67.940000   68.095000   68.231000   68.348000   68.446000   \n",
       "29    24.866000   24.490000   24.128000   23.777000   23.439000   23.113000   \n",
       "..          ...         ...         ...         ...         ...         ...   \n",
       "234   95.441090   95.801052   96.161153   96.522279   96.922377   96.936467   \n",
       "235   43.844738   38.000000   49.385078   52.174774   54.973484   57.778198   \n",
       "236   95.008710   95.297786   95.910895   96.376501   97.506184   96.325711   \n",
       "237   91.511932   92.261650   92.175456   92.800000   94.588905   95.380676   \n",
       "238   74.025057   75.117519   69.326529   79.352935   79.318324   81.448690   \n",
       "239   32.490060   32.633561   34.880128   35.770348   36.542705   37.760013   \n",
       "240   99.000000   99.298363   99.736145   99.936935   99.992935  100.000000   \n",
       "241   99.500000   99.500000   99.500000   99.500000   99.700000   99.800000   \n",
       "242   99.310745  100.000000   99.910782   99.985657   99.999252  100.000000   \n",
       "243   96.779938   97.127861   97.490799   97.671777   98.249725   98.639702   \n",
       "244   11.200000   14.800000   14.200000   15.300000   16.400000   18.910179   \n",
       "245   10.000000   14.769371   14.600000   16.214964   13.900000   20.400000   \n",
       "246   99.872482   99.945076   99.985046   99.867491  100.000000  100.000000   \n",
       "247   98.322811   98.775502   98.866005   99.059438   99.214211   99.235891   \n",
       "248   98.830696   98.989487   99.170000   99.349075   99.611808   99.657085   \n",
       "249  100.000000  100.000000  100.000000  100.000000  100.000000  100.000000   \n",
       "250   99.955498   99.986694   99.997910   99.999908  100.000000  100.000000   \n",
       "251   91.837242   93.222282   94.622345   96.034424   97.455513   98.598648   \n",
       "252   98.710304   98.807846   98.840000   99.044968   99.178551   99.318146   \n",
       "253         NaN         NaN         NaN         NaN         NaN         NaN   \n",
       "254  100.000000  100.000000  100.000000  100.000000  100.000000  100.000000   \n",
       "255   96.100000   97.591133   99.000000  100.000000  100.000000   99.200000   \n",
       "256   33.291115   36.898365   38.434589   39.982830   31.700000   43.103348   \n",
       "257   83.211382   83.539093   82.504609   85.041356   85.163456   85.690892   \n",
       "258   97.900000   96.606010   96.668575   98.504707   99.255646   97.900000   \n",
       "259   98.377060    0.000000   99.430435   99.773651   99.942505   99.993134   \n",
       "260   61.751400   63.134281   64.532181   65.942101   75.600000   66.100000   \n",
       "261   82.700000   82.900000   84.700000   85.300000   85.400000   86.000000   \n",
       "262   23.235649   22.000000   24.328644   24.894667   25.469702   27.900000   \n",
       "263   43.369082   36.063057   36.900000   36.728878   37.076813   32.300000   \n",
       "\n",
       "           2015        2016       2017  \n",
       "0     58.472000   58.696000  58.893000  \n",
       "1     73.297000   72.868000  72.430000  \n",
       "2     55.950000   55.181000  54.422000  \n",
       "3     42.593000   41.624000  40.684000  \n",
       "4     14.885000   15.388000  15.873000  \n",
       "5     42.191790   41.906071  41.631967  \n",
       "6     14.459000   14.196000  13.942000  \n",
       "7      8.249000    8.107000   7.970000  \n",
       "8     37.327000   37.442000  37.533000  \n",
       "9     12.798000   12.852000  12.897000  \n",
       "10    76.227000   76.607000  76.953000  \n",
       "11    10.577000   10.446000  10.317000  \n",
       "12    34.032000   33.968000  33.890000  \n",
       "13    45.380000   45.105000  44.819000  \n",
       "14    87.943000   87.641000  87.333000  \n",
       "15     2.142000    2.103000   2.066000  \n",
       "16    56.050000   55.605000  55.153000  \n",
       "17    70.141000   69.312000  68.489000  \n",
       "18    65.723000   64.965000  64.210000  \n",
       "19    26.052000   25.734000  25.419000  \n",
       "20    11.225000   11.165000  11.101000  \n",
       "21    17.126000   17.049000  16.969000  \n",
       "22    60.233000   60.060000  59.865000  \n",
       "23    23.333000   22.954000  22.584000  \n",
       "24    56.027000   56.155000  56.258000  \n",
       "25     0.000000    0.000000   0.000000  \n",
       "26    31.488000   31.089000  30.697000  \n",
       "27    14.313000   14.067000  13.828000  \n",
       "28    68.525000   68.585000  68.626000  \n",
       "29    22.798000   22.495000  22.203000  \n",
       "..          ...         ...        ...  \n",
       "234   97.183215   97.742979        NaN  \n",
       "235   67.281534   63.394138        NaN  \n",
       "236   97.493216   97.671447        NaN  \n",
       "237   96.175453   97.020000        NaN  \n",
       "238   86.513987   85.569150        NaN  \n",
       "239   38.459815   42.813754        NaN  \n",
       "240  100.000000  100.000000        NaN  \n",
       "241  100.000000  100.000000        NaN  \n",
       "242  100.000000  100.000000        NaN  \n",
       "243   99.032677   99.426155        NaN  \n",
       "244   18.500000   32.800000        NaN  \n",
       "245   18.500000   26.700000        NaN  \n",
       "246  100.000000  100.000000        NaN  \n",
       "247   99.268934   99.379714        NaN  \n",
       "248   99.709480  100.000000        NaN  \n",
       "249  100.000000  100.000000        NaN  \n",
       "250  100.000000  100.000000        NaN  \n",
       "251   99.455063  100.000000        NaN  \n",
       "252   99.460739   99.603836        NaN  \n",
       "253         NaN         NaN        NaN  \n",
       "254  100.000000  100.000000        NaN  \n",
       "255  100.000000  100.000000        NaN  \n",
       "256   44.669613   57.820000        NaN  \n",
       "257   87.028468   87.351269        NaN  \n",
       "258   99.938278  100.000000        NaN  \n",
       "259  100.000000  100.000000        NaN  \n",
       "260   70.213905   71.642349        NaN  \n",
       "261   85.500000   84.200000        NaN  \n",
       "262   31.100000   27.219337        NaN  \n",
       "263   33.700000   38.145138        NaN  \n",
       "\n",
       "[528 rows x 62 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# TODO: import the pandas library\n",
    "import pandas as pd\n",
    "\n",
    "# TODO: read in each csv file into a separate variable\n",
    "# HINT: remember from the Extract material that these csv file have some formatting issues\n",
    "df_rural = pd.read_csv('rural_population_percent.csv', skiprows=4)\n",
    "df_electricity = pd.read_csv('electricity_access_percent.csv', skiprows=4)\n",
    "\n",
    "# TODO: remove the 'Unnamed:62' column from each data set\n",
    "df_rural.drop('Unnamed: 62', axis=1, inplace=True)\n",
    "df_electricity.drop('Unnamed: 62', axis=1, inplace=True)\n",
    "\n",
    "# TODO: combine the two data sets together using the concat method\n",
    "df = pd.concat([df_rural, df_electricity])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Exercise 2 (Challenge)\n",
    "\n",
    "This exercise is more challenging. Combine the data in the csv file together to the output that look like the following:\n",
    "\n",
    "|Country Name|Country Code|Year|Rural_Value|Electricity_Value|\n",
    "|--|--|--|--|--|--|\n",
    "|Aruba|ABW|1960|49.224|49.239|\n",
    "... etc.\n",
    "\n",
    "Order the results in the dataframe by country and then by year\n",
    "\n",
    "Here are a few pandas methods that should be helpful:\n",
    "* [melt](http://pandas.pydata.org/pandas-docs/stable/generated/pandas.melt.html)\n",
    "* [merge](https://pandas.pydata.org/pandas-docs/version/0.23/generated/pandas.DataFrame.merge.html)\n",
    "* [sort_values](https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.sort_values.html)\n",
    "\n",
    "HINT: You can use country name, country code, and the year as common keys between the data sets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "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>Country Name</th>\n",
       "      <th>Country Code</th>\n",
       "      <th>Year</th>\n",
       "      <th>Rural_Value</th>\n",
       "      <th>Electricity_Value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1960</td>\n",
       "      <td>91.779</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>265</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1961</td>\n",
       "      <td>91.492</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>529</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1962</td>\n",
       "      <td>91.195</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>793</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1963</td>\n",
       "      <td>90.890</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1057</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1964</td>\n",
       "      <td>90.574</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1321</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1965</td>\n",
       "      <td>90.250</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1585</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1966</td>\n",
       "      <td>89.915</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1849</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1967</td>\n",
       "      <td>89.570</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2113</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1968</td>\n",
       "      <td>89.214</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2377</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1969</td>\n",
       "      <td>88.848</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2641</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1970</td>\n",
       "      <td>88.471</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2905</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1971</td>\n",
       "      <td>88.083</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3169</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1972</td>\n",
       "      <td>87.684</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3433</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1973</td>\n",
       "      <td>87.274</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3697</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1974</td>\n",
       "      <td>86.851</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3961</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1975</td>\n",
       "      <td>86.417</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4225</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1976</td>\n",
       "      <td>85.971</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4489</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1977</td>\n",
       "      <td>85.513</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4753</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1978</td>\n",
       "      <td>85.042</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5017</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1979</td>\n",
       "      <td>84.565</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5281</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1980</td>\n",
       "      <td>84.319</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5545</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1981</td>\n",
       "      <td>84.070</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5809</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1982</td>\n",
       "      <td>83.818</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6073</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1983</td>\n",
       "      <td>83.563</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6337</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1984</td>\n",
       "      <td>83.304</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6601</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1985</td>\n",
       "      <td>83.042</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6865</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1986</td>\n",
       "      <td>82.777</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7129</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1987</td>\n",
       "      <td>82.509</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7393</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1988</td>\n",
       "      <td>82.237</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7657</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1989</td>\n",
       "      <td>81.962</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7655</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>1988</td>\n",
       "      <td>72.476</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7919</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>1989</td>\n",
       "      <td>71.750</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8183</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>1990</td>\n",
       "      <td>71.012</td>\n",
       "      <td>30.357832</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8447</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>1991</td>\n",
       "      <td>70.262</td>\n",
       "      <td>30.718805</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8711</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>1992</td>\n",
       "      <td>69.501</td>\n",
       "      <td>28.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8975</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>1993</td>\n",
       "      <td>69.060</td>\n",
       "      <td>31.436678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9239</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>1994</td>\n",
       "      <td>68.665</td>\n",
       "      <td>28.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9503</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>1995</td>\n",
       "      <td>68.268</td>\n",
       "      <td>32.130077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9767</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>1996</td>\n",
       "      <td>67.868</td>\n",
       "      <td>32.459949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10031</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>1997</td>\n",
       "      <td>67.466</td>\n",
       "      <td>32.774529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10295</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>1998</td>\n",
       "      <td>67.061</td>\n",
       "      <td>33.070751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10559</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>1999</td>\n",
       "      <td>66.653</td>\n",
       "      <td>38.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10823</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>2000</td>\n",
       "      <td>66.242</td>\n",
       "      <td>33.597420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11087</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>2001</td>\n",
       "      <td>65.830</td>\n",
       "      <td>33.830868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11351</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>2002</td>\n",
       "      <td>65.415</td>\n",
       "      <td>34.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11615</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>2003</td>\n",
       "      <td>65.521</td>\n",
       "      <td>34.266785</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11879</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>2004</td>\n",
       "      <td>65.706</td>\n",
       "      <td>34.481380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12143</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>2005</td>\n",
       "      <td>65.890</td>\n",
       "      <td>34.701820</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12407</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>2006</td>\n",
       "      <td>66.074</td>\n",
       "      <td>37.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12671</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>2007</td>\n",
       "      <td>66.257</td>\n",
       "      <td>35.184479</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12935</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>2008</td>\n",
       "      <td>66.440</td>\n",
       "      <td>35.457310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13199</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>2009</td>\n",
       "      <td>66.622</td>\n",
       "      <td>43.369082</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13463</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>2010</td>\n",
       "      <td>66.804</td>\n",
       "      <td>36.063057</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13727</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>2011</td>\n",
       "      <td>66.985</td>\n",
       "      <td>36.900000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13991</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>2012</td>\n",
       "      <td>67.166</td>\n",
       "      <td>36.728878</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14255</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>2013</td>\n",
       "      <td>67.346</td>\n",
       "      <td>37.076813</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14519</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>2014</td>\n",
       "      <td>67.499</td>\n",
       "      <td>32.300000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14783</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>2015</td>\n",
       "      <td>67.624</td>\n",
       "      <td>33.700000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15047</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>2016</td>\n",
       "      <td>67.723</td>\n",
       "      <td>38.145138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15311</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>2017</td>\n",
       "      <td>67.793</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>15312 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Country Name Country Code  Year  Electricity_Value  Rural_Value\n",
       "1      Afghanistan          AFG  1960             91.779          NaN\n",
       "265    Afghanistan          AFG  1961             91.492          NaN\n",
       "529    Afghanistan          AFG  1962             91.195          NaN\n",
       "793    Afghanistan          AFG  1963             90.890          NaN\n",
       "1057   Afghanistan          AFG  1964             90.574          NaN\n",
       "1321   Afghanistan          AFG  1965             90.250          NaN\n",
       "1585   Afghanistan          AFG  1966             89.915          NaN\n",
       "1849   Afghanistan          AFG  1967             89.570          NaN\n",
       "2113   Afghanistan          AFG  1968             89.214          NaN\n",
       "2377   Afghanistan          AFG  1969             88.848          NaN\n",
       "2641   Afghanistan          AFG  1970             88.471          NaN\n",
       "2905   Afghanistan          AFG  1971             88.083          NaN\n",
       "3169   Afghanistan          AFG  1972             87.684          NaN\n",
       "3433   Afghanistan          AFG  1973             87.274          NaN\n",
       "3697   Afghanistan          AFG  1974             86.851          NaN\n",
       "3961   Afghanistan          AFG  1975             86.417          NaN\n",
       "4225   Afghanistan          AFG  1976             85.971          NaN\n",
       "4489   Afghanistan          AFG  1977             85.513          NaN\n",
       "4753   Afghanistan          AFG  1978             85.042          NaN\n",
       "5017   Afghanistan          AFG  1979             84.565          NaN\n",
       "5281   Afghanistan          AFG  1980             84.319          NaN\n",
       "5545   Afghanistan          AFG  1981             84.070          NaN\n",
       "5809   Afghanistan          AFG  1982             83.818          NaN\n",
       "6073   Afghanistan          AFG  1983             83.563          NaN\n",
       "6337   Afghanistan          AFG  1984             83.304          NaN\n",
       "6601   Afghanistan          AFG  1985             83.042          NaN\n",
       "6865   Afghanistan          AFG  1986             82.777          NaN\n",
       "7129   Afghanistan          AFG  1987             82.509          NaN\n",
       "7393   Afghanistan          AFG  1988             82.237          NaN\n",
       "7657   Afghanistan          AFG  1989             81.962          NaN\n",
       "...            ...          ...   ...                ...          ...\n",
       "7655      Zimbabwe          ZWE  1988             72.476          NaN\n",
       "7919      Zimbabwe          ZWE  1989             71.750          NaN\n",
       "8183      Zimbabwe          ZWE  1990             71.012    30.357832\n",
       "8447      Zimbabwe          ZWE  1991             70.262    30.718805\n",
       "8711      Zimbabwe          ZWE  1992             69.501    28.200000\n",
       "8975      Zimbabwe          ZWE  1993             69.060    31.436678\n",
       "9239      Zimbabwe          ZWE  1994             68.665    28.100000\n",
       "9503      Zimbabwe          ZWE  1995             68.268    32.130077\n",
       "9767      Zimbabwe          ZWE  1996             67.868    32.459949\n",
       "10031     Zimbabwe          ZWE  1997             67.466    32.774529\n",
       "10295     Zimbabwe          ZWE  1998             67.061    33.070751\n",
       "10559     Zimbabwe          ZWE  1999             66.653    38.400000\n",
       "10823     Zimbabwe          ZWE  2000             66.242    33.597420\n",
       "11087     Zimbabwe          ZWE  2001             65.830    33.830868\n",
       "11351     Zimbabwe          ZWE  2002             65.415    34.200000\n",
       "11615     Zimbabwe          ZWE  2003             65.521    34.266785\n",
       "11879     Zimbabwe          ZWE  2004             65.706    34.481380\n",
       "12143     Zimbabwe          ZWE  2005             65.890    34.701820\n",
       "12407     Zimbabwe          ZWE  2006             66.074    37.200000\n",
       "12671     Zimbabwe          ZWE  2007             66.257    35.184479\n",
       "12935     Zimbabwe          ZWE  2008             66.440    35.457310\n",
       "13199     Zimbabwe          ZWE  2009             66.622    43.369082\n",
       "13463     Zimbabwe          ZWE  2010             66.804    36.063057\n",
       "13727     Zimbabwe          ZWE  2011             66.985    36.900000\n",
       "13991     Zimbabwe          ZWE  2012             67.166    36.728878\n",
       "14255     Zimbabwe          ZWE  2013             67.346    37.076813\n",
       "14519     Zimbabwe          ZWE  2014             67.499    32.300000\n",
       "14783     Zimbabwe          ZWE  2015             67.624    33.700000\n",
       "15047     Zimbabwe          ZWE  2016             67.723    38.145138\n",
       "15311     Zimbabwe          ZWE  2017             67.793          NaN\n",
       "\n",
       "[15312 rows x 5 columns]"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# TODO: merge the data sets together according to the instructions. First, use the \n",
    "# melt method to change the formatting of each data frame so that it looks like this:\n",
    "# Country Name, Country Code, Year, Rural Value\n",
    "# Country Name, Country Code, Year, Electricity Value\n",
    "\n",
    "df_rural_melt = pd.melt(df_rural,\\\n",
    "                        id_vars=['Country Name', 'Country Code', 'Indicator Name', 'Indicator Code'],\\\n",
    "                       var_name = 'Year', value_name='Rural_Value')\n",
    "df_electricity_melt = pd.melt(df_electricity,\\\n",
    "                              id_vars=['Country Name', 'Country Code', 'Indicator Name', 'Indicator Code'],\\\n",
    "                             var_name='Year', value_name='Electricity_Value')\n",
    "\n",
    "# TODO: drop any columns from the data frames that aren't needed\n",
    "df_rural_melt.drop(['Indicator Name', 'Indicator Code'], axis=1, inplace=True)\n",
    "df_electricity_melt.drop(['Indicator Name', 'Indicator Code'], axis=1, inplace=True)\n",
    "\n",
    "# TODO: merge the data frames together based on their common columns\n",
    "# in this case, the common columns are Country Name, Country Code, and Year\n",
    "df_merge = df_rural_melt.merge(df_electricity_melt, how='outer',\\\n",
    "                               on=['Country Name', 'Country Code', 'Year'])\n",
    "\n",
    "# TODO: sort the results by country and then by year\n",
    "df_combined = df_merge.sort_values(['Country Name', 'Year'])\n",
    "df_combined"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [conda env:anaconda3]",
   "language": "python",
   "name": "conda-env-anaconda3-py"
  },
  "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.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}