Gapminder Automation.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import pylab as plt\n",
    "import matplotlib\n",
    "from gapminderautomation as calculate_mean_over_time\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>pop</th>\n",
       "      <th>lifeexp</th>\n",
       "      <th>gdppercap</th>\n",
       "      <th>country</th>\n",
       "      <th>continent</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1952</td>\n",
       "      <td>8425333</td>\n",
       "      <td>28.801</td>\n",
       "      <td>779.445314</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1957</td>\n",
       "      <td>9240934</td>\n",
       "      <td>30.332</td>\n",
       "      <td>820.853030</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1962</td>\n",
       "      <td>10267083</td>\n",
       "      <td>31.997</td>\n",
       "      <td>853.100710</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1967</td>\n",
       "      <td>11537966</td>\n",
       "      <td>34.020</td>\n",
       "      <td>836.197138</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1972</td>\n",
       "      <td>13079460</td>\n",
       "      <td>36.088</td>\n",
       "      <td>739.981106</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   year       pop  lifeexp   gdppercap      country continent\n",
       "0  1952   8425333   28.801  779.445314  afghanistan      asia\n",
       "1  1957   9240934   30.332  820.853030  afghanistan      asia\n",
       "2  1962  10267083   31.997  853.100710  afghanistan      asia\n",
       "3  1967  11537966   34.020  836.197138  afghanistan      asia\n",
       "4  1972  13079460   36.088  739.981106  afghanistan      asia"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "status = True\n",
    "\n",
    "file = os.path.expanduser(\"~/Downloads/gapminder_cleaned.csv\")\n",
    "\n",
    "try:\n",
    "    df = pd.read_csv(file)\n",
    "\n",
    "except FileNotFoundError:\n",
    "    file = input(\"File not found. Try another path for the file: \")\n",
    "    \n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>pop</th>\n",
       "      <th>lifeexp</th>\n",
       "      <th>gdppercap</th>\n",
       "      <th>country</th>\n",
       "      <th>continent</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1952</td>\n",
       "      <td>8425333</td>\n",
       "      <td>28.801</td>\n",
       "      <td>779.445314</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1957</td>\n",
       "      <td>9240934</td>\n",
       "      <td>30.332</td>\n",
       "      <td>820.853030</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1962</td>\n",
       "      <td>10267083</td>\n",
       "      <td>31.997</td>\n",
       "      <td>853.100710</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1967</td>\n",
       "      <td>11537966</td>\n",
       "      <td>34.020</td>\n",
       "      <td>836.197138</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1972</td>\n",
       "      <td>13079460</td>\n",
       "      <td>36.088</td>\n",
       "      <td>739.981106</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1977</td>\n",
       "      <td>14880372</td>\n",
       "      <td>38.438</td>\n",
       "      <td>786.113360</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1982</td>\n",
       "      <td>12881816</td>\n",
       "      <td>39.854</td>\n",
       "      <td>978.011439</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1987</td>\n",
       "      <td>13867957</td>\n",
       "      <td>40.822</td>\n",
       "      <td>852.395945</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1992</td>\n",
       "      <td>16317921</td>\n",
       "      <td>41.674</td>\n",
       "      <td>649.341395</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1997</td>\n",
       "      <td>22227415</td>\n",
       "      <td>41.763</td>\n",
       "      <td>635.341351</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2002</td>\n",
       "      <td>25268405</td>\n",
       "      <td>42.129</td>\n",
       "      <td>726.734055</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2007</td>\n",
       "      <td>31889923</td>\n",
       "      <td>43.828</td>\n",
       "      <td>974.580338</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1952</td>\n",
       "      <td>1282697</td>\n",
       "      <td>55.230</td>\n",
       "      <td>1601.056136</td>\n",
       "      <td>albania</td>\n",
       "      <td>europe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1957</td>\n",
       "      <td>1476505</td>\n",
       "      <td>59.280</td>\n",
       "      <td>1942.284244</td>\n",
       "      <td>albania</td>\n",
       "      <td>europe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1962</td>\n",
       "      <td>1728137</td>\n",
       "      <td>64.820</td>\n",
       "      <td>2312.888958</td>\n",
       "      <td>albania</td>\n",
       "      <td>europe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1967</td>\n",
       "      <td>1984060</td>\n",
       "      <td>66.220</td>\n",
       "      <td>2760.196931</td>\n",
       "      <td>albania</td>\n",
       "      <td>europe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1972</td>\n",
       "      <td>2263554</td>\n",
       "      <td>67.690</td>\n",
       "      <td>3313.422188</td>\n",
       "      <td>albania</td>\n",
       "      <td>europe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1977</td>\n",
       "      <td>2509048</td>\n",
       "      <td>68.930</td>\n",
       "      <td>3533.003910</td>\n",
       "      <td>albania</td>\n",
       "      <td>europe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1982</td>\n",
       "      <td>2780097</td>\n",
       "      <td>70.420</td>\n",
       "      <td>3630.880722</td>\n",
       "      <td>albania</td>\n",
       "      <td>europe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1987</td>\n",
       "      <td>3075321</td>\n",
       "      <td>72.000</td>\n",
       "      <td>3738.932735</td>\n",
       "      <td>albania</td>\n",
       "      <td>europe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1992</td>\n",
       "      <td>3326498</td>\n",
       "      <td>71.581</td>\n",
       "      <td>2497.437901</td>\n",
       "      <td>albania</td>\n",
       "      <td>europe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1997</td>\n",
       "      <td>3428038</td>\n",
       "      <td>72.950</td>\n",
       "      <td>3193.054604</td>\n",
       "      <td>albania</td>\n",
       "      <td>europe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2002</td>\n",
       "      <td>3508512</td>\n",
       "      <td>75.651</td>\n",
       "      <td>4604.211737</td>\n",
       "      <td>albania</td>\n",
       "      <td>europe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2007</td>\n",
       "      <td>3600523</td>\n",
       "      <td>76.423</td>\n",
       "      <td>5937.029526</td>\n",
       "      <td>albania</td>\n",
       "      <td>europe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1952</td>\n",
       "      <td>9279525</td>\n",
       "      <td>43.077</td>\n",
       "      <td>2449.008185</td>\n",
       "      <td>algeria</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1957</td>\n",
       "      <td>10270856</td>\n",
       "      <td>45.685</td>\n",
       "      <td>3013.976023</td>\n",
       "      <td>algeria</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1962</td>\n",
       "      <td>11000948</td>\n",
       "      <td>48.303</td>\n",
       "      <td>2550.816880</td>\n",
       "      <td>algeria</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1967</td>\n",
       "      <td>12760499</td>\n",
       "      <td>51.407</td>\n",
       "      <td>3246.991771</td>\n",
       "      <td>algeria</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1972</td>\n",
       "      <td>14760787</td>\n",
       "      <td>54.518</td>\n",
       "      <td>4182.663766</td>\n",
       "      <td>algeria</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1977</td>\n",
       "      <td>17152804</td>\n",
       "      <td>58.014</td>\n",
       "      <td>4910.416756</td>\n",
       "      <td>algeria</td>\n",
       "      <td>africa</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1674</th>\n",
       "      <td>1982</td>\n",
       "      <td>9657618</td>\n",
       "      <td>49.113</td>\n",
       "      <td>1977.557010</td>\n",
       "      <td>yemen, rep.</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1675</th>\n",
       "      <td>1987</td>\n",
       "      <td>11219340</td>\n",
       "      <td>52.922</td>\n",
       "      <td>1971.741538</td>\n",
       "      <td>yemen, rep.</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1676</th>\n",
       "      <td>1992</td>\n",
       "      <td>13367997</td>\n",
       "      <td>55.599</td>\n",
       "      <td>1879.496673</td>\n",
       "      <td>yemen, rep.</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1677</th>\n",
       "      <td>1997</td>\n",
       "      <td>15826497</td>\n",
       "      <td>58.020</td>\n",
       "      <td>2117.484526</td>\n",
       "      <td>yemen, rep.</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1678</th>\n",
       "      <td>2002</td>\n",
       "      <td>18701257</td>\n",
       "      <td>60.308</td>\n",
       "      <td>2234.820827</td>\n",
       "      <td>yemen, rep.</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1679</th>\n",
       "      <td>2007</td>\n",
       "      <td>22211743</td>\n",
       "      <td>62.698</td>\n",
       "      <td>2280.769906</td>\n",
       "      <td>yemen, rep.</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1680</th>\n",
       "      <td>1952</td>\n",
       "      <td>2672000</td>\n",
       "      <td>42.038</td>\n",
       "      <td>1147.388831</td>\n",
       "      <td>zambia</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1681</th>\n",
       "      <td>1957</td>\n",
       "      <td>3016000</td>\n",
       "      <td>44.077</td>\n",
       "      <td>1311.956766</td>\n",
       "      <td>zambia</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1682</th>\n",
       "      <td>1962</td>\n",
       "      <td>3421000</td>\n",
       "      <td>46.023</td>\n",
       "      <td>1452.725766</td>\n",
       "      <td>zambia</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1683</th>\n",
       "      <td>1967</td>\n",
       "      <td>3900000</td>\n",
       "      <td>47.768</td>\n",
       "      <td>1777.077318</td>\n",
       "      <td>zambia</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1684</th>\n",
       "      <td>1972</td>\n",
       "      <td>4506497</td>\n",
       "      <td>50.107</td>\n",
       "      <td>1773.498265</td>\n",
       "      <td>zambia</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1685</th>\n",
       "      <td>1977</td>\n",
       "      <td>5216550</td>\n",
       "      <td>51.386</td>\n",
       "      <td>1588.688299</td>\n",
       "      <td>zambia</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1686</th>\n",
       "      <td>1982</td>\n",
       "      <td>6100407</td>\n",
       "      <td>51.821</td>\n",
       "      <td>1408.678565</td>\n",
       "      <td>zambia</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1687</th>\n",
       "      <td>1987</td>\n",
       "      <td>7272406</td>\n",
       "      <td>50.821</td>\n",
       "      <td>1213.315116</td>\n",
       "      <td>zambia</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1688</th>\n",
       "      <td>1992</td>\n",
       "      <td>8381163</td>\n",
       "      <td>46.100</td>\n",
       "      <td>1210.884633</td>\n",
       "      <td>zambia</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1689</th>\n",
       "      <td>1997</td>\n",
       "      <td>9417789</td>\n",
       "      <td>40.238</td>\n",
       "      <td>1071.353818</td>\n",
       "      <td>zambia</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1690</th>\n",
       "      <td>2002</td>\n",
       "      <td>10595811</td>\n",
       "      <td>39.193</td>\n",
       "      <td>1071.613938</td>\n",
       "      <td>zambia</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1691</th>\n",
       "      <td>2007</td>\n",
       "      <td>11746035</td>\n",
       "      <td>42.384</td>\n",
       "      <td>1271.211593</td>\n",
       "      <td>zambia</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1692</th>\n",
       "      <td>1952</td>\n",
       "      <td>3080907</td>\n",
       "      <td>48.451</td>\n",
       "      <td>406.884115</td>\n",
       "      <td>zimbabwe</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1693</th>\n",
       "      <td>1957</td>\n",
       "      <td>3646340</td>\n",
       "      <td>50.469</td>\n",
       "      <td>518.764268</td>\n",
       "      <td>zimbabwe</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1694</th>\n",
       "      <td>1962</td>\n",
       "      <td>4277736</td>\n",
       "      <td>52.358</td>\n",
       "      <td>527.272182</td>\n",
       "      <td>zimbabwe</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1695</th>\n",
       "      <td>1967</td>\n",
       "      <td>4995432</td>\n",
       "      <td>53.995</td>\n",
       "      <td>569.795071</td>\n",
       "      <td>zimbabwe</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1696</th>\n",
       "      <td>1972</td>\n",
       "      <td>5861135</td>\n",
       "      <td>55.635</td>\n",
       "      <td>799.362176</td>\n",
       "      <td>zimbabwe</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1697</th>\n",
       "      <td>1977</td>\n",
       "      <td>6642107</td>\n",
       "      <td>57.674</td>\n",
       "      <td>685.587682</td>\n",
       "      <td>zimbabwe</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1698</th>\n",
       "      <td>1982</td>\n",
       "      <td>7636524</td>\n",
       "      <td>60.363</td>\n",
       "      <td>788.855041</td>\n",
       "      <td>zimbabwe</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1699</th>\n",
       "      <td>1987</td>\n",
       "      <td>9216418</td>\n",
       "      <td>62.351</td>\n",
       "      <td>706.157306</td>\n",
       "      <td>zimbabwe</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1700</th>\n",
       "      <td>1992</td>\n",
       "      <td>10704340</td>\n",
       "      <td>60.377</td>\n",
       "      <td>693.420786</td>\n",
       "      <td>zimbabwe</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1701</th>\n",
       "      <td>1997</td>\n",
       "      <td>11404948</td>\n",
       "      <td>46.809</td>\n",
       "      <td>792.449960</td>\n",
       "      <td>zimbabwe</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1702</th>\n",
       "      <td>2002</td>\n",
       "      <td>11926563</td>\n",
       "      <td>39.989</td>\n",
       "      <td>672.038623</td>\n",
       "      <td>zimbabwe</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1703</th>\n",
       "      <td>2007</td>\n",
       "      <td>12311143</td>\n",
       "      <td>43.487</td>\n",
       "      <td>469.709298</td>\n",
       "      <td>zimbabwe</td>\n",
       "      <td>africa</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1704 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      year       pop  lifeexp    gdppercap      country continent\n",
       "0     1952   8425333   28.801   779.445314  afghanistan      asia\n",
       "1     1957   9240934   30.332   820.853030  afghanistan      asia\n",
       "2     1962  10267083   31.997   853.100710  afghanistan      asia\n",
       "3     1967  11537966   34.020   836.197138  afghanistan      asia\n",
       "4     1972  13079460   36.088   739.981106  afghanistan      asia\n",
       "5     1977  14880372   38.438   786.113360  afghanistan      asia\n",
       "6     1982  12881816   39.854   978.011439  afghanistan      asia\n",
       "7     1987  13867957   40.822   852.395945  afghanistan      asia\n",
       "8     1992  16317921   41.674   649.341395  afghanistan      asia\n",
       "9     1997  22227415   41.763   635.341351  afghanistan      asia\n",
       "10    2002  25268405   42.129   726.734055  afghanistan      asia\n",
       "11    2007  31889923   43.828   974.580338  afghanistan      asia\n",
       "12    1952   1282697   55.230  1601.056136      albania    europe\n",
       "13    1957   1476505   59.280  1942.284244      albania    europe\n",
       "14    1962   1728137   64.820  2312.888958      albania    europe\n",
       "15    1967   1984060   66.220  2760.196931      albania    europe\n",
       "16    1972   2263554   67.690  3313.422188      albania    europe\n",
       "17    1977   2509048   68.930  3533.003910      albania    europe\n",
       "18    1982   2780097   70.420  3630.880722      albania    europe\n",
       "19    1987   3075321   72.000  3738.932735      albania    europe\n",
       "20    1992   3326498   71.581  2497.437901      albania    europe\n",
       "21    1997   3428038   72.950  3193.054604      albania    europe\n",
       "22    2002   3508512   75.651  4604.211737      albania    europe\n",
       "23    2007   3600523   76.423  5937.029526      albania    europe\n",
       "24    1952   9279525   43.077  2449.008185      algeria    africa\n",
       "25    1957  10270856   45.685  3013.976023      algeria    africa\n",
       "26    1962  11000948   48.303  2550.816880      algeria    africa\n",
       "27    1967  12760499   51.407  3246.991771      algeria    africa\n",
       "28    1972  14760787   54.518  4182.663766      algeria    africa\n",
       "29    1977  17152804   58.014  4910.416756      algeria    africa\n",
       "...    ...       ...      ...          ...          ...       ...\n",
       "1674  1982   9657618   49.113  1977.557010  yemen, rep.      asia\n",
       "1675  1987  11219340   52.922  1971.741538  yemen, rep.      asia\n",
       "1676  1992  13367997   55.599  1879.496673  yemen, rep.      asia\n",
       "1677  1997  15826497   58.020  2117.484526  yemen, rep.      asia\n",
       "1678  2002  18701257   60.308  2234.820827  yemen, rep.      asia\n",
       "1679  2007  22211743   62.698  2280.769906  yemen, rep.      asia\n",
       "1680  1952   2672000   42.038  1147.388831       zambia    africa\n",
       "1681  1957   3016000   44.077  1311.956766       zambia    africa\n",
       "1682  1962   3421000   46.023  1452.725766       zambia    africa\n",
       "1683  1967   3900000   47.768  1777.077318       zambia    africa\n",
       "1684  1972   4506497   50.107  1773.498265       zambia    africa\n",
       "1685  1977   5216550   51.386  1588.688299       zambia    africa\n",
       "1686  1982   6100407   51.821  1408.678565       zambia    africa\n",
       "1687  1987   7272406   50.821  1213.315116       zambia    africa\n",
       "1688  1992   8381163   46.100  1210.884633       zambia    africa\n",
       "1689  1997   9417789   40.238  1071.353818       zambia    africa\n",
       "1690  2002  10595811   39.193  1071.613938       zambia    africa\n",
       "1691  2007  11746035   42.384  1271.211593       zambia    africa\n",
       "1692  1952   3080907   48.451   406.884115     zimbabwe    africa\n",
       "1693  1957   3646340   50.469   518.764268     zimbabwe    africa\n",
       "1694  1962   4277736   52.358   527.272182     zimbabwe    africa\n",
       "1695  1967   4995432   53.995   569.795071     zimbabwe    africa\n",
       "1696  1972   5861135   55.635   799.362176     zimbabwe    africa\n",
       "1697  1977   6642107   57.674   685.587682     zimbabwe    africa\n",
       "1698  1982   7636524   60.363   788.855041     zimbabwe    africa\n",
       "1699  1987   9216418   62.351   706.157306     zimbabwe    africa\n",
       "1700  1992  10704340   60.377   693.420786     zimbabwe    africa\n",
       "1701  1997  11404948   46.809   792.449960     zimbabwe    africa\n",
       "1702  2002  11926563   39.989   672.038623     zimbabwe    africa\n",
       "1703  2007  12311143   43.487   469.709298     zimbabwe    africa\n",
       "\n",
       "[1704 rows x 6 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>pop</th>\n",
       "      <th>lifeexp</th>\n",
       "      <th>gdppercap</th>\n",
       "      <th>country</th>\n",
       "      <th>continent</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1952</td>\n",
       "      <td>8425333</td>\n",
       "      <td>28.801</td>\n",
       "      <td>779.445314</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1957</td>\n",
       "      <td>9240934</td>\n",
       "      <td>30.332</td>\n",
       "      <td>820.853030</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1962</td>\n",
       "      <td>10267083</td>\n",
       "      <td>31.997</td>\n",
       "      <td>853.100710</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1967</td>\n",
       "      <td>11537966</td>\n",
       "      <td>34.020</td>\n",
       "      <td>836.197138</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1972</td>\n",
       "      <td>13079460</td>\n",
       "      <td>36.088</td>\n",
       "      <td>739.981106</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1977</td>\n",
       "      <td>14880372</td>\n",
       "      <td>38.438</td>\n",
       "      <td>786.113360</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1982</td>\n",
       "      <td>12881816</td>\n",
       "      <td>39.854</td>\n",
       "      <td>978.011439</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1987</td>\n",
       "      <td>13867957</td>\n",
       "      <td>40.822</td>\n",
       "      <td>852.395945</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1992</td>\n",
       "      <td>16317921</td>\n",
       "      <td>41.674</td>\n",
       "      <td>649.341395</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1997</td>\n",
       "      <td>22227415</td>\n",
       "      <td>41.763</td>\n",
       "      <td>635.341351</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2002</td>\n",
       "      <td>25268405</td>\n",
       "      <td>42.129</td>\n",
       "      <td>726.734055</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2007</td>\n",
       "      <td>31889923</td>\n",
       "      <td>43.828</td>\n",
       "      <td>974.580338</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>1952</td>\n",
       "      <td>120447</td>\n",
       "      <td>50.939</td>\n",
       "      <td>9867.084765</td>\n",
       "      <td>bahrain</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>1957</td>\n",
       "      <td>138655</td>\n",
       "      <td>53.832</td>\n",
       "      <td>11635.799450</td>\n",
       "      <td>bahrain</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>1962</td>\n",
       "      <td>171863</td>\n",
       "      <td>56.923</td>\n",
       "      <td>12753.275140</td>\n",
       "      <td>bahrain</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>1967</td>\n",
       "      <td>202182</td>\n",
       "      <td>59.923</td>\n",
       "      <td>14804.672700</td>\n",
       "      <td>bahrain</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>1972</td>\n",
       "      <td>230800</td>\n",
       "      <td>63.300</td>\n",
       "      <td>18268.658390</td>\n",
       "      <td>bahrain</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>1977</td>\n",
       "      <td>297410</td>\n",
       "      <td>65.593</td>\n",
       "      <td>19340.101960</td>\n",
       "      <td>bahrain</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>1982</td>\n",
       "      <td>377967</td>\n",
       "      <td>69.052</td>\n",
       "      <td>19211.147310</td>\n",
       "      <td>bahrain</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>1987</td>\n",
       "      <td>454612</td>\n",
       "      <td>70.750</td>\n",
       "      <td>18524.024060</td>\n",
       "      <td>bahrain</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>1992</td>\n",
       "      <td>529491</td>\n",
       "      <td>72.601</td>\n",
       "      <td>19035.579170</td>\n",
       "      <td>bahrain</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>1997</td>\n",
       "      <td>598561</td>\n",
       "      <td>73.925</td>\n",
       "      <td>20292.016790</td>\n",
       "      <td>bahrain</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>2002</td>\n",
       "      <td>656397</td>\n",
       "      <td>74.795</td>\n",
       "      <td>23403.559270</td>\n",
       "      <td>bahrain</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>2007</td>\n",
       "      <td>708573</td>\n",
       "      <td>75.635</td>\n",
       "      <td>29796.048340</td>\n",
       "      <td>bahrain</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>1952</td>\n",
       "      <td>46886859</td>\n",
       "      <td>37.484</td>\n",
       "      <td>684.244172</td>\n",
       "      <td>bangladesh</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>1957</td>\n",
       "      <td>51365468</td>\n",
       "      <td>39.348</td>\n",
       "      <td>661.637458</td>\n",
       "      <td>bangladesh</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>1962</td>\n",
       "      <td>56839289</td>\n",
       "      <td>41.216</td>\n",
       "      <td>686.341554</td>\n",
       "      <td>bangladesh</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>1967</td>\n",
       "      <td>62821884</td>\n",
       "      <td>43.453</td>\n",
       "      <td>721.186086</td>\n",
       "      <td>bangladesh</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>1972</td>\n",
       "      <td>70759295</td>\n",
       "      <td>45.252</td>\n",
       "      <td>630.233627</td>\n",
       "      <td>bangladesh</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>1977</td>\n",
       "      <td>80428306</td>\n",
       "      <td>46.923</td>\n",
       "      <td>659.877232</td>\n",
       "      <td>bangladesh</td>\n",
       "      <td>asia</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1650</th>\n",
       "      <td>1982</td>\n",
       "      <td>56142181</td>\n",
       "      <td>58.816</td>\n",
       "      <td>707.235786</td>\n",
       "      <td>vietnam</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651</th>\n",
       "      <td>1987</td>\n",
       "      <td>62826491</td>\n",
       "      <td>62.820</td>\n",
       "      <td>820.799445</td>\n",
       "      <td>vietnam</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1652</th>\n",
       "      <td>1992</td>\n",
       "      <td>69940728</td>\n",
       "      <td>67.662</td>\n",
       "      <td>989.023149</td>\n",
       "      <td>vietnam</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1653</th>\n",
       "      <td>1997</td>\n",
       "      <td>76048996</td>\n",
       "      <td>70.672</td>\n",
       "      <td>1385.896769</td>\n",
       "      <td>vietnam</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1654</th>\n",
       "      <td>2002</td>\n",
       "      <td>80908147</td>\n",
       "      <td>73.017</td>\n",
       "      <td>1764.456677</td>\n",
       "      <td>vietnam</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1655</th>\n",
       "      <td>2007</td>\n",
       "      <td>85262356</td>\n",
       "      <td>74.249</td>\n",
       "      <td>2441.576404</td>\n",
       "      <td>vietnam</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1656</th>\n",
       "      <td>1952</td>\n",
       "      <td>1030585</td>\n",
       "      <td>43.160</td>\n",
       "      <td>1515.592329</td>\n",
       "      <td>west bank and gaza</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1657</th>\n",
       "      <td>1957</td>\n",
       "      <td>1070439</td>\n",
       "      <td>45.671</td>\n",
       "      <td>1827.067742</td>\n",
       "      <td>west bank and gaza</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1658</th>\n",
       "      <td>1962</td>\n",
       "      <td>1133134</td>\n",
       "      <td>48.127</td>\n",
       "      <td>2198.956312</td>\n",
       "      <td>west bank and gaza</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1659</th>\n",
       "      <td>1967</td>\n",
       "      <td>1142636</td>\n",
       "      <td>51.631</td>\n",
       "      <td>2649.715007</td>\n",
       "      <td>west bank and gaza</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1660</th>\n",
       "      <td>1972</td>\n",
       "      <td>1089572</td>\n",
       "      <td>56.532</td>\n",
       "      <td>3133.409277</td>\n",
       "      <td>west bank and gaza</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1661</th>\n",
       "      <td>1977</td>\n",
       "      <td>1261091</td>\n",
       "      <td>60.765</td>\n",
       "      <td>3682.831494</td>\n",
       "      <td>west bank and gaza</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1662</th>\n",
       "      <td>1982</td>\n",
       "      <td>1425876</td>\n",
       "      <td>64.406</td>\n",
       "      <td>4336.032082</td>\n",
       "      <td>west bank and gaza</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1663</th>\n",
       "      <td>1987</td>\n",
       "      <td>1691210</td>\n",
       "      <td>67.046</td>\n",
       "      <td>5107.197384</td>\n",
       "      <td>west bank and gaza</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1664</th>\n",
       "      <td>1992</td>\n",
       "      <td>2104779</td>\n",
       "      <td>69.718</td>\n",
       "      <td>6017.654756</td>\n",
       "      <td>west bank and gaza</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1665</th>\n",
       "      <td>1997</td>\n",
       "      <td>2826046</td>\n",
       "      <td>71.096</td>\n",
       "      <td>7110.667619</td>\n",
       "      <td>west bank and gaza</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1666</th>\n",
       "      <td>2002</td>\n",
       "      <td>3389578</td>\n",
       "      <td>72.370</td>\n",
       "      <td>4515.487575</td>\n",
       "      <td>west bank and gaza</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1667</th>\n",
       "      <td>2007</td>\n",
       "      <td>4018332</td>\n",
       "      <td>73.422</td>\n",
       "      <td>3025.349798</td>\n",
       "      <td>west bank and gaza</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1668</th>\n",
       "      <td>1952</td>\n",
       "      <td>4963829</td>\n",
       "      <td>32.548</td>\n",
       "      <td>781.717576</td>\n",
       "      <td>yemen, rep.</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1669</th>\n",
       "      <td>1957</td>\n",
       "      <td>5498090</td>\n",
       "      <td>33.970</td>\n",
       "      <td>804.830455</td>\n",
       "      <td>yemen, rep.</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1670</th>\n",
       "      <td>1962</td>\n",
       "      <td>6120081</td>\n",
       "      <td>35.180</td>\n",
       "      <td>825.623201</td>\n",
       "      <td>yemen, rep.</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1671</th>\n",
       "      <td>1967</td>\n",
       "      <td>6740785</td>\n",
       "      <td>36.984</td>\n",
       "      <td>862.442146</td>\n",
       "      <td>yemen, rep.</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1672</th>\n",
       "      <td>1972</td>\n",
       "      <td>7407075</td>\n",
       "      <td>39.848</td>\n",
       "      <td>1265.047031</td>\n",
       "      <td>yemen, rep.</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1673</th>\n",
       "      <td>1977</td>\n",
       "      <td>8403990</td>\n",
       "      <td>44.175</td>\n",
       "      <td>1829.765177</td>\n",
       "      <td>yemen, rep.</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1674</th>\n",
       "      <td>1982</td>\n",
       "      <td>9657618</td>\n",
       "      <td>49.113</td>\n",
       "      <td>1977.557010</td>\n",
       "      <td>yemen, rep.</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1675</th>\n",
       "      <td>1987</td>\n",
       "      <td>11219340</td>\n",
       "      <td>52.922</td>\n",
       "      <td>1971.741538</td>\n",
       "      <td>yemen, rep.</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1676</th>\n",
       "      <td>1992</td>\n",
       "      <td>13367997</td>\n",
       "      <td>55.599</td>\n",
       "      <td>1879.496673</td>\n",
       "      <td>yemen, rep.</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1677</th>\n",
       "      <td>1997</td>\n",
       "      <td>15826497</td>\n",
       "      <td>58.020</td>\n",
       "      <td>2117.484526</td>\n",
       "      <td>yemen, rep.</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1678</th>\n",
       "      <td>2002</td>\n",
       "      <td>18701257</td>\n",
       "      <td>60.308</td>\n",
       "      <td>2234.820827</td>\n",
       "      <td>yemen, rep.</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1679</th>\n",
       "      <td>2007</td>\n",
       "      <td>22211743</td>\n",
       "      <td>62.698</td>\n",
       "      <td>2280.769906</td>\n",
       "      <td>yemen, rep.</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>396 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      year       pop  lifeexp     gdppercap             country continent\n",
       "0     1952   8425333   28.801    779.445314         afghanistan      asia\n",
       "1     1957   9240934   30.332    820.853030         afghanistan      asia\n",
       "2     1962  10267083   31.997    853.100710         afghanistan      asia\n",
       "3     1967  11537966   34.020    836.197138         afghanistan      asia\n",
       "4     1972  13079460   36.088    739.981106         afghanistan      asia\n",
       "5     1977  14880372   38.438    786.113360         afghanistan      asia\n",
       "6     1982  12881816   39.854    978.011439         afghanistan      asia\n",
       "7     1987  13867957   40.822    852.395945         afghanistan      asia\n",
       "8     1992  16317921   41.674    649.341395         afghanistan      asia\n",
       "9     1997  22227415   41.763    635.341351         afghanistan      asia\n",
       "10    2002  25268405   42.129    726.734055         afghanistan      asia\n",
       "11    2007  31889923   43.828    974.580338         afghanistan      asia\n",
       "84    1952    120447   50.939   9867.084765             bahrain      asia\n",
       "85    1957    138655   53.832  11635.799450             bahrain      asia\n",
       "86    1962    171863   56.923  12753.275140             bahrain      asia\n",
       "87    1967    202182   59.923  14804.672700             bahrain      asia\n",
       "88    1972    230800   63.300  18268.658390             bahrain      asia\n",
       "89    1977    297410   65.593  19340.101960             bahrain      asia\n",
       "90    1982    377967   69.052  19211.147310             bahrain      asia\n",
       "91    1987    454612   70.750  18524.024060             bahrain      asia\n",
       "92    1992    529491   72.601  19035.579170             bahrain      asia\n",
       "93    1997    598561   73.925  20292.016790             bahrain      asia\n",
       "94    2002    656397   74.795  23403.559270             bahrain      asia\n",
       "95    2007    708573   75.635  29796.048340             bahrain      asia\n",
       "96    1952  46886859   37.484    684.244172          bangladesh      asia\n",
       "97    1957  51365468   39.348    661.637458          bangladesh      asia\n",
       "98    1962  56839289   41.216    686.341554          bangladesh      asia\n",
       "99    1967  62821884   43.453    721.186086          bangladesh      asia\n",
       "100   1972  70759295   45.252    630.233627          bangladesh      asia\n",
       "101   1977  80428306   46.923    659.877232          bangladesh      asia\n",
       "...    ...       ...      ...           ...                 ...       ...\n",
       "1650  1982  56142181   58.816    707.235786             vietnam      asia\n",
       "1651  1987  62826491   62.820    820.799445             vietnam      asia\n",
       "1652  1992  69940728   67.662    989.023149             vietnam      asia\n",
       "1653  1997  76048996   70.672   1385.896769             vietnam      asia\n",
       "1654  2002  80908147   73.017   1764.456677             vietnam      asia\n",
       "1655  2007  85262356   74.249   2441.576404             vietnam      asia\n",
       "1656  1952   1030585   43.160   1515.592329  west bank and gaza      asia\n",
       "1657  1957   1070439   45.671   1827.067742  west bank and gaza      asia\n",
       "1658  1962   1133134   48.127   2198.956312  west bank and gaza      asia\n",
       "1659  1967   1142636   51.631   2649.715007  west bank and gaza      asia\n",
       "1660  1972   1089572   56.532   3133.409277  west bank and gaza      asia\n",
       "1661  1977   1261091   60.765   3682.831494  west bank and gaza      asia\n",
       "1662  1982   1425876   64.406   4336.032082  west bank and gaza      asia\n",
       "1663  1987   1691210   67.046   5107.197384  west bank and gaza      asia\n",
       "1664  1992   2104779   69.718   6017.654756  west bank and gaza      asia\n",
       "1665  1997   2826046   71.096   7110.667619  west bank and gaza      asia\n",
       "1666  2002   3389578   72.370   4515.487575  west bank and gaza      asia\n",
       "1667  2007   4018332   73.422   3025.349798  west bank and gaza      asia\n",
       "1668  1952   4963829   32.548    781.717576         yemen, rep.      asia\n",
       "1669  1957   5498090   33.970    804.830455         yemen, rep.      asia\n",
       "1670  1962   6120081   35.180    825.623201         yemen, rep.      asia\n",
       "1671  1967   6740785   36.984    862.442146         yemen, rep.      asia\n",
       "1672  1972   7407075   39.848   1265.047031         yemen, rep.      asia\n",
       "1673  1977   8403990   44.175   1829.765177         yemen, rep.      asia\n",
       "1674  1982   9657618   49.113   1977.557010         yemen, rep.      asia\n",
       "1675  1987  11219340   52.922   1971.741538         yemen, rep.      asia\n",
       "1676  1992  13367997   55.599   1879.496673         yemen, rep.      asia\n",
       "1677  1997  15826497   58.020   2117.484526         yemen, rep.      asia\n",
       "1678  2002  18701257   60.308   2234.820827         yemen, rep.      asia\n",
       "1679  2007  22211743   62.698   2280.769906         yemen, rep.      asia\n",
       "\n",
       "[396 rows x 6 columns]"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "asia_data = df['continent']=='asia'\n",
    "df_asia = df[asia_data]\n",
    "df_asia"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>pop</th>\n",
       "      <th>lifeexp</th>\n",
       "      <th>gdppercap</th>\n",
       "      <th>country</th>\n",
       "      <th>continent</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2002</td>\n",
       "      <td>25268405</td>\n",
       "      <td>42.129</td>\n",
       "      <td>726.734055</td>\n",
       "      <td>afghanistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>2002</td>\n",
       "      <td>656397</td>\n",
       "      <td>74.795</td>\n",
       "      <td>23403.559270</td>\n",
       "      <td>bahrain</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>2002</td>\n",
       "      <td>135656790</td>\n",
       "      <td>62.013</td>\n",
       "      <td>1136.390430</td>\n",
       "      <td>bangladesh</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>2002</td>\n",
       "      <td>12926707</td>\n",
       "      <td>56.752</td>\n",
       "      <td>896.226015</td>\n",
       "      <td>cambodia</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>2002</td>\n",
       "      <td>1280400000</td>\n",
       "      <td>72.028</td>\n",
       "      <td>3119.280896</td>\n",
       "      <td>china</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>670</th>\n",
       "      <td>2002</td>\n",
       "      <td>6762476</td>\n",
       "      <td>81.495</td>\n",
       "      <td>30209.015160</td>\n",
       "      <td>hong kong, china</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>706</th>\n",
       "      <td>2002</td>\n",
       "      <td>1034172547</td>\n",
       "      <td>62.879</td>\n",
       "      <td>1746.769454</td>\n",
       "      <td>india</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>718</th>\n",
       "      <td>2002</td>\n",
       "      <td>211060000</td>\n",
       "      <td>68.588</td>\n",
       "      <td>2873.912870</td>\n",
       "      <td>indonesia</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>730</th>\n",
       "      <td>2002</td>\n",
       "      <td>66907826</td>\n",
       "      <td>69.451</td>\n",
       "      <td>9240.761975</td>\n",
       "      <td>iran</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>742</th>\n",
       "      <td>2002</td>\n",
       "      <td>24001816</td>\n",
       "      <td>57.046</td>\n",
       "      <td>4390.717312</td>\n",
       "      <td>iraq</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>766</th>\n",
       "      <td>2002</td>\n",
       "      <td>6029529</td>\n",
       "      <td>79.696</td>\n",
       "      <td>21905.595140</td>\n",
       "      <td>israel</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>802</th>\n",
       "      <td>2002</td>\n",
       "      <td>127065841</td>\n",
       "      <td>82.000</td>\n",
       "      <td>28604.591900</td>\n",
       "      <td>japan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>814</th>\n",
       "      <td>2002</td>\n",
       "      <td>5307470</td>\n",
       "      <td>71.263</td>\n",
       "      <td>3844.917194</td>\n",
       "      <td>jordan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>838</th>\n",
       "      <td>2002</td>\n",
       "      <td>22215365</td>\n",
       "      <td>66.662</td>\n",
       "      <td>1646.758151</td>\n",
       "      <td>korea, dem. rep.</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>850</th>\n",
       "      <td>2002</td>\n",
       "      <td>47969150</td>\n",
       "      <td>77.045</td>\n",
       "      <td>19233.988180</td>\n",
       "      <td>korea, rep.</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>862</th>\n",
       "      <td>2002</td>\n",
       "      <td>2111561</td>\n",
       "      <td>76.904</td>\n",
       "      <td>35110.105660</td>\n",
       "      <td>kuwait</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>874</th>\n",
       "      <td>2002</td>\n",
       "      <td>3677780</td>\n",
       "      <td>71.028</td>\n",
       "      <td>9313.938830</td>\n",
       "      <td>lebanon</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>946</th>\n",
       "      <td>2002</td>\n",
       "      <td>22662365</td>\n",
       "      <td>73.044</td>\n",
       "      <td>10206.977940</td>\n",
       "      <td>malaysia</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1006</th>\n",
       "      <td>2002</td>\n",
       "      <td>2674234</td>\n",
       "      <td>65.033</td>\n",
       "      <td>2140.739323</td>\n",
       "      <td>mongolia</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1054</th>\n",
       "      <td>2002</td>\n",
       "      <td>45598081</td>\n",
       "      <td>59.908</td>\n",
       "      <td>611.000000</td>\n",
       "      <td>myanmar</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1078</th>\n",
       "      <td>2002</td>\n",
       "      <td>25873917</td>\n",
       "      <td>61.340</td>\n",
       "      <td>1057.206311</td>\n",
       "      <td>nepal</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1162</th>\n",
       "      <td>2002</td>\n",
       "      <td>2713462</td>\n",
       "      <td>74.193</td>\n",
       "      <td>19774.836870</td>\n",
       "      <td>oman</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1174</th>\n",
       "      <td>2002</td>\n",
       "      <td>153403524</td>\n",
       "      <td>63.610</td>\n",
       "      <td>2092.712441</td>\n",
       "      <td>pakistan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1222</th>\n",
       "      <td>2002</td>\n",
       "      <td>82995088</td>\n",
       "      <td>70.303</td>\n",
       "      <td>2650.921068</td>\n",
       "      <td>philippines</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1318</th>\n",
       "      <td>2002</td>\n",
       "      <td>24501530</td>\n",
       "      <td>71.626</td>\n",
       "      <td>19014.541180</td>\n",
       "      <td>saudi arabia</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1366</th>\n",
       "      <td>2002</td>\n",
       "      <td>4197776</td>\n",
       "      <td>78.770</td>\n",
       "      <td>36023.105400</td>\n",
       "      <td>singapore</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1438</th>\n",
       "      <td>2002</td>\n",
       "      <td>19576783</td>\n",
       "      <td>70.815</td>\n",
       "      <td>3015.378833</td>\n",
       "      <td>sri lanka</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1498</th>\n",
       "      <td>2002</td>\n",
       "      <td>17155814</td>\n",
       "      <td>73.053</td>\n",
       "      <td>4090.925331</td>\n",
       "      <td>syria</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1510</th>\n",
       "      <td>2002</td>\n",
       "      <td>22454239</td>\n",
       "      <td>76.990</td>\n",
       "      <td>23235.423290</td>\n",
       "      <td>taiwan</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1534</th>\n",
       "      <td>2002</td>\n",
       "      <td>62806748</td>\n",
       "      <td>68.564</td>\n",
       "      <td>5913.187529</td>\n",
       "      <td>thailand</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1654</th>\n",
       "      <td>2002</td>\n",
       "      <td>80908147</td>\n",
       "      <td>73.017</td>\n",
       "      <td>1764.456677</td>\n",
       "      <td>vietnam</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1666</th>\n",
       "      <td>2002</td>\n",
       "      <td>3389578</td>\n",
       "      <td>72.370</td>\n",
       "      <td>4515.487575</td>\n",
       "      <td>west bank and gaza</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1678</th>\n",
       "      <td>2002</td>\n",
       "      <td>18701257</td>\n",
       "      <td>60.308</td>\n",
       "      <td>2234.820827</td>\n",
       "      <td>yemen, rep.</td>\n",
       "      <td>asia</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      year         pop  lifeexp     gdppercap             country continent\n",
       "10    2002    25268405   42.129    726.734055         afghanistan      asia\n",
       "94    2002      656397   74.795  23403.559270             bahrain      asia\n",
       "106   2002   135656790   62.013   1136.390430          bangladesh      asia\n",
       "226   2002    12926707   56.752    896.226015            cambodia      asia\n",
       "298   2002  1280400000   72.028   3119.280896               china      asia\n",
       "670   2002     6762476   81.495  30209.015160    hong kong, china      asia\n",
       "706   2002  1034172547   62.879   1746.769454               india      asia\n",
       "718   2002   211060000   68.588   2873.912870           indonesia      asia\n",
       "730   2002    66907826   69.451   9240.761975                iran      asia\n",
       "742   2002    24001816   57.046   4390.717312                iraq      asia\n",
       "766   2002     6029529   79.696  21905.595140              israel      asia\n",
       "802   2002   127065841   82.000  28604.591900               japan      asia\n",
       "814   2002     5307470   71.263   3844.917194              jordan      asia\n",
       "838   2002    22215365   66.662   1646.758151    korea, dem. rep.      asia\n",
       "850   2002    47969150   77.045  19233.988180         korea, rep.      asia\n",
       "862   2002     2111561   76.904  35110.105660              kuwait      asia\n",
       "874   2002     3677780   71.028   9313.938830             lebanon      asia\n",
       "946   2002    22662365   73.044  10206.977940            malaysia      asia\n",
       "1006  2002     2674234   65.033   2140.739323            mongolia      asia\n",
       "1054  2002    45598081   59.908    611.000000             myanmar      asia\n",
       "1078  2002    25873917   61.340   1057.206311               nepal      asia\n",
       "1162  2002     2713462   74.193  19774.836870                oman      asia\n",
       "1174  2002   153403524   63.610   2092.712441            pakistan      asia\n",
       "1222  2002    82995088   70.303   2650.921068         philippines      asia\n",
       "1318  2002    24501530   71.626  19014.541180        saudi arabia      asia\n",
       "1366  2002     4197776   78.770  36023.105400           singapore      asia\n",
       "1438  2002    19576783   70.815   3015.378833           sri lanka      asia\n",
       "1498  2002    17155814   73.053   4090.925331               syria      asia\n",
       "1510  2002    22454239   76.990  23235.423290              taiwan      asia\n",
       "1534  2002    62806748   68.564   5913.187529            thailand      asia\n",
       "1654  2002    80908147   73.017   1764.456677             vietnam      asia\n",
       "1666  2002     3389578   72.370   4515.487575  west bank and gaza      asia\n",
       "1678  2002    18701257   60.308   2234.820827         yemen, rep.      asia"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "year_data = df_asia['year'] ==2002\n",
    "df_2002 = df_asia[year_data]\n",
    "df_2002"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('asia', '2002', 69.23387878787878)]"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "value = np.mean(df_2002['lifeexp'])\n",
    "result =[]\n",
    "result.append(('asia','2002',value))\n",
    "result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {},
   "outputs": [],
   "source": [
    "years = df_asia['year'].unique()\n",
    "result =[]\n",
    "\n",
    "for i in years:\n",
    "    year_data = df_asia['year'] == i\n",
    "    df_year = df_asia[year_data]\n",
    "    value = np.mean(df_year['lifeexp'])\n",
    "    result.append(('asia',i,value))\n",
    "\n",
    "summary = pd.DataFrame(result,columns=['continent','year','lifeexp'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>continent</th>\n",
       "      <th>year</th>\n",
       "      <th>lifeexp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>asia</td>\n",
       "      <td>1952</td>\n",
       "      <td>46.314394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>asia</td>\n",
       "      <td>1957</td>\n",
       "      <td>49.318544</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>asia</td>\n",
       "      <td>1962</td>\n",
       "      <td>51.563223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>asia</td>\n",
       "      <td>1967</td>\n",
       "      <td>54.663640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>asia</td>\n",
       "      <td>1972</td>\n",
       "      <td>57.319269</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>asia</td>\n",
       "      <td>1977</td>\n",
       "      <td>59.610556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>asia</td>\n",
       "      <td>1982</td>\n",
       "      <td>62.617939</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>asia</td>\n",
       "      <td>1987</td>\n",
       "      <td>64.851182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>asia</td>\n",
       "      <td>1992</td>\n",
       "      <td>66.537212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>asia</td>\n",
       "      <td>1997</td>\n",
       "      <td>68.020515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>asia</td>\n",
       "      <td>2002</td>\n",
       "      <td>69.233879</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>asia</td>\n",
       "      <td>2007</td>\n",
       "      <td>70.728485</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   continent  year    lifeexp\n",
       "0       asia  1952  46.314394\n",
       "1       asia  1957  49.318544\n",
       "2       asia  1962  51.563223\n",
       "3       asia  1967  54.663640\n",
       "4       asia  1972  57.319269\n",
       "5       asia  1977  59.610556\n",
       "6       asia  1982  62.617939\n",
       "7       asia  1987  64.851182\n",
       "8       asia  1992  66.537212\n",
       "9       asia  1997  68.020515\n",
       "10      asia  2002  69.233879\n",
       "11      asia  2007  70.728485"
      ]
     },
     "execution_count": 87,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "summary"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Input category: pop\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXcAAAERCAYAAACAbee5AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4wLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvpW3flQAAIABJREFUeJzt3Xl8VPW9//HXd7bMZCEkZF8ggMoO\nAgkgKIso4L5hq/ZaUavtbbX+eu91aev1Unu72dve1ltbpJVSq61FrJa6VIs7CkhYVBQEWbOvELJN\nZvv+/jgnk8kCGSBhJpPP8/GYx5zzPd8z+Z4E337ne875HqW1RgghRGyxRLoBQggh+p6EuxBCxCAJ\ndyGEiEES7kIIEYMk3IUQIgZJuAshRAyKaLgrpVYppaqVUjvDqDtcKfWmUmq7UuojpdSlZ6KNQggx\nEEW6574aWBJm3QeBNVrrqcANwK/7q1FCCDHQRTTctdbvAPWhZUqp0Uqpfyiltiql3lVKjW2vDgwx\nl5OB8jPYVCGEGFBskW5AD1YCX9Na71VKzcTooV8ILAdeU0rdDSQAF0WuiUIIEd2iKtyVUonAbOBZ\npVR7cZz5fiOwWmv9M6XUecAflVITtdaBCDRVCCGiWlSFO8Yw0VGt9bk9bLsdc3xea71RKeUE0oDq\nM9g+IYQYECJ9QrUTrfUx4IBS6noAZZhibj4MLDTLxwFOoCYiDRVCiCinIjkrpFLqz8B8jB54FfBf\nwBvAb4BswA48o7V+WCk1HvgtkIhxcvU+rfVrkWi3EEJEu4iGuxBCiP7R67BMbzcaKaW+ZN5U9JFS\n6v2QYRQhhBAR0mvPXSk1F2gCntRaT+xh+2xgl9b6iFLqEmC51npmbz84LS1NFxQUnFqrhRBikNq6\ndWut1jq9t3q9Xi2jtX5HKVVwgu3vh6xuAvLCaWBBQQHFxcXhVBVCCGFSSh0Kp15fXy1zO/DK8TYq\npe5UShUrpYprauRCFyGE6C99Fu5KqQUY4X7/8eporVdqrQu11oXp6b1+qxBCCHGK+uQmJqXUZOB3\nwCVa67q++EwhhBCn7rTDXSk1HPgrcLPWes/pfJbX66W0tBS32326zRq0nE4neXl52O32SDdFCBFB\nvYZ76I1GSqlSjBuN7ABa6xXAQ8Aw4NfmfDA+rXXhqTSmtLSUpKQkCgoKCJlbRoRJa01dXR2lpaWM\nHDky0s0RQkRQOFfL3NjL9q8AX+mLxrjdbgn206CUYtiwYcjJaiFEVM0tA0iwnyb5/QkhIPpmhRRC\nCNGD5jYfL39cEXZ9CffT8NBDDzF37lwuukieGyKE6HuBgGbT/jrWbivllY8rafX6w95Xwv00PPzw\nw5FughAiBh2sbea5baX8dVsZZUdbSYqzcfXUHK6blkfRT8L7DAn3Hlx99dWUlJTgdru55557uP32\n27n99tspLi5GKcVtt93Gt771LZYtW8bll1/O0qVLefjhh/n73/9Oa2srs2fP5vHHH5fxbyFE2I65\nvbz0UQXPbS2l+NARLArOPzud+5aMYfGELJx260l9XtSG+/f+/gmflh/r088cnzOE/7piQq/1Vq1a\nRWpqKq2trRQVFTF9+nTKysrYudOYGPPo0aPd9rnrrrt46KGHALj55pt58cUXueKKK/q0/UKI2OIP\naN77vJa1W0t59ZNK2nwBRqcncP+SsVwzNZesZOcpf3bUhnskPfroozz//PMAlJSU4PF42L9/P3ff\nfTeXXXYZixYt6rbPm2++ySOPPEJLSwv19fVMmDBBwl0I0aPPq5t4blspz28ro/KYm2SXnesL81g6\nPZ8pecl98q0/asM9nB52f3jrrbdYv349GzduJD4+nvnz59PW1saHH37Iq6++ymOPPcaaNWtYtWpV\ncB+3283Xv/51iouLyc/PZ/ny5XKXrRCik4YWL+s+Kue5raXsKDmK1aKYd046D10xnoXjMoizndyw\nS2+iNtwjpaGhgZSUFOLj49m9ezebNm2itraWQCDAddddx+jRo1m2bFmnfdqDPC0tjaamJtauXcvS\npUsj0HohRDTx+QO8s7eG57aW8c9Pq/D4A4zJTOK7l47jqqk5ZCSd+rBLbyTcu1iyZAkrVqxg8uTJ\njBkzhlmzZlFWVsb8+fMJBAIA/OhHP+q0z9ChQ7njjjuYNGkSBQUFFBUVRaLpQogo8VllI2u3lvDC\njnJqGttIibdz08zhLJ2ex4ScIWfkYouIPUO1sLBQd31Yx65duxg3blxE2hNL5PcoxJlX3+xh3Y4y\n1m4rZWfZMWwWxYKxGSydnseCMRk4bH0zIYBSams483dJz10IIU6R1x/gzd3VPLetlDd2V+P1aybk\nDOGhy8dz1bk5DEuMi1jbJNyFEOIkfVLewNqtpazbUU5ds4e0RAe3nFfAddPzGJc9JNLNAyTchRAi\nLA0tXv72YRl/2VLCJ+XHcFgtXDQ+g+um5TH3nHTs1uiah1HCXQghjiMQ0Gw6UMeaLSW8stO4yWh8\n9hC+d+UErjo3h6Hxjkg38bgk3IUQoovKBjdrt5awpriUw/UtJDltfKEwny8W5TMxNznSzQuLhLsQ\nQmCcHH19VzVrikt467NqAhpmjUrlWxefzSUTs096bpdIk3AXQgxqn1c3saa4hL9uK6W2yUNGUhz/\nOn8010/PpyAtIdLNO2US7n3I5/Nhs8mvVIho19zm46WPK1izpYTiQ0ewWRQXjs3gi0X5zDsnHVuU\nnRw9FZJEPXjqqad49NFH8Xg8zJw5k1//+tckJyfT1NQEwNq1a3nxxRdZvXo1y5YtIzU1le3btzNt\n2jS++93vctttt7F//37i4+NZuXIlkydPZvny5ezbt4+ysjJKSkq47777uOOOOwD46U9/ypo1a2hr\na+Oaa67he9/7XiQPX4iYpLVmR8lR1hSXsG5HOc0eP6PSEvj2JWO5dloe6UmRuya9P0RvuL/yAFR+\n3LefmTUJLvnxCavs2rWLv/zlL7z33nvY7Xa+/vWv8/TTT59wnz179rB+/XqsVit33303U6dO5YUX\nXuCNN97gy1/+Mjt27ADgo48+YtOmTTQ3NzN16lQuu+wydu7cyd69e/nggw/QWnPllVfyzjvvMHfu\n3D47bCEGs/pmD3/dVsqa4hL2VDXhslu5bHI2XyzKp3BESsw+dyF6wz1CXn/9dbZu3RqcH6a1tZWM\njIwT7nP99ddjtRonWzZs2MBzzz0HwIUXXkhdXR0NDQ0AXHXVVbhcLlwuFwsWLOCDDz5gw4YNvPba\na0ydOhWApqYm9u7dK+EuxGnwBzQbPq9lzZYSXvu0Eq9fMyV/KD+6dhKXT84myWmPdBP7XfSGey89\n7P6iteaWW27pNjnYz372s+By1+l8ExI6Trr0NFdPe8+gaw9BKYXWmm9/+9t89atfPe22CzHYldS3\n8OzWUtYWl1De4CYl3s7Nswr4YlE+Y7KSIt28M2rgnzXoYwsXLmTt2rVUV1cDUF9fz6FDh8jMzGTX\nrl0EAoHggzx6Mnfu3OAwzltvvUVaWhpDhhi3I//tb3/D7XZTV1fHW2+9RVFREYsXL2bVqlXB8fyy\nsrLgzxZC9K7N5+fvH5Zz8xObmfvTN/m/N/YyOiORX900lU3fWchDV4wfdMEO0dxzj5Dx48fz3//9\n3yxatIhAIIDdbuexxx7jxz/+MZdffjn5+flMnDgxGMZdLV++nFtvvZXJkycTHx/PH/7wh+C2GTNm\ncNlll3H48GH+8z//k5ycHHJycti1axfnnXceAImJiTz11FO9DgUJMdh9Xt3I05sP8/z2Mo62eMkd\n6uKehWezdHoeeSnxkW5exMmUv2fI8uXLSUxM5D/+4z/6/WfF8u9RDG5aG2Ppv3v3AG/vqcFhtXDx\nhEy+WJjPnLPSsFpi8+RoKJnyVwgRM9xeP+t2lPPEhgN8VtVIWmIc/3bxOXxp5vCITqsbzXoNd6XU\nKuByoFprPbGH7Qr4JXAp0AIs01pv6+uGDnTLly+PdBOEGHBqm9p4atMhntp0iNomD2Ozkvif66dw\nxZTsPn/maKwJp+e+GvgV8ORxtl8CnG2+ZgK/Md+FEOKUfFbZyKoNB3h+RxkeX4ALx2bwlfNHct7o\nYTF7XXpf6zXctdbvKKUKTlDlKuBJbQzeb1JKDVVKZWutK/qojUKIQUBrzdt7anhiwwHe3VuL027h\n+ul53DpnJGdlJEa6eQNOX4y55wIlIeulZlm3cFdK3QncCTB8+PA++NFCiIHO7fXz/PYyVm04wN7q\nJjKS4rh38RhumjGclITonS892vVFuPf0HanHS3C01iuBlWBcLdMHP1sIMUDVNLbxR3M8vb7Zw/js\nIfz8C1O4fHJOnz1MejDri3AvBfJD1vOA8j743Kjy7LPP8tBDD5GVlcWbb77ZaVt5eTnf/OY3Wbt2\nbYRaJ8TAsbvyGE+8e4C/7SjHGwiwcGwGt58/ilmjUmU8vQ/1RbivA+5SSj2DcSK1IRbH25944gl+\n/etfs2DBgk7lPp+PnJwcCXYhTiAQ6BhP3/B5LS67lS8W5XPrnAJGpct4en8I51LIPwPzgTSlVCnw\nX4AdQGu9AngZ4zLIzzEuhby1vxp7plx99dWUlJTgdru55557qKysZMOGDRw4cIArr7ySCRMm8NJL\nL+F2u2lubmbVqlVcfvnl7Ny5E7/fz/3338+rr76KUoo77riDu+++m4cffpi///3vtLa2Mnv2bB5/\n/HHppYiY1+rx89ftpazacIB9Nc1kDonjviXGeHo0P380FoRztcyNvWzXwDf6rEWmn3zwE3bX7+7T\nzxybOpb7Z9zfa71Vq1aRmppKa2srRUVFvP3227zxxhv8z//8D4WFhaxevZqNGzfy0UcfkZqaysGD\nB4P7rly5kgMHDrB9+3ZsNhv19fUA3HXXXTz00EMA3Hzzzbz44otcccUVfXp8QkSL6mNuntx4iKc3\nH+JIi5eJuUP4xRfP5dJJ2TKefobIHao9ePTRR4OTg5WUlLB3795udS6++GJSU1O7la9fv56vfe1r\nwScytdd58803eeSRR2hpaaG+vp4JEyZIuIuY80l5A09sOMDfPyzHF9BcPC6T288fyYyRMp5+pkVt\nuIfTw+4Pb731FuvXr2fjxo3Ex8czf/78blP8QudpfkNprbv9I3a73Xz961+nuLiY/Px8li9f3uNn\nCjEQBQKaNz+r5nfvHmDj/jriHVZumjGcW+eMHNDPIB3oojbcI6WhoYGUlBTi4+PZvXs3mzZtOqn9\nFy1axIoVK5g/f35wWMZiMb6GpqWl0dTUxNq1a1m6dGl/NF+IM6bN5+f5bWWsfHc/+2uayU528sAl\nY7mxaDjJ8bH/MIxoJ+HexZIlS1ixYgWTJ09mzJgxzJo166T2/8pXvsKePXuYPHkydrudO+64g7vu\nuos77riDSZMmUVBQEHzKkxAD0TG3l6c3HWbVeweoaWxjQs4QfnmDMZ5uj4EHS8cKmfI3BsnvUfSH\n6mNunnjvAH/adJjGNh/nn5XG1+aNZs5ZMt/LmSRT/goh+sT+miZWvrOfv24rwxcIcMmkbL42dzST\n8pIj3TRxAhLuQogefVhylBVv7+Mfn1Rit1q4vjCPOy4YJSdJBwgJdyFEUPvMjCve3sem/fUMcdr4\n+vzRLJs9kvQkeSjGQCLhLoTA5w/w0scVrHh7P7sqjpE1xMl3Lx3HjTOHkxgnMTEQyV9NiEGs1ePn\n2a0l/Pbd/ZTUtzI6PYFHlk7m6nNz5U7SAU7CXYhB6Eizhz9uOsTq9w9S3+xh2vCh/Odl47loXCaW\nQfCQ6cFAwj1CZs+ezfvvvx/pZohBpvxoK7979wDPbDlMi8fPhWMz+Nq80RQVpMjljDFGwv0M8/v9\nWK1WCXZxRu2pamTF2/tYt8N41MKVU3K4c94oxmYNiXDLRH+RQbUeXH311UyfPp0JEyawcuVKABIT\nE7n//vuZPn06F110ER988AHz589n1KhRrFu3DjCC+95776WoqIjJkyfz+OOPA8Z8NQsWLOCmm25i\n0qRJwc9r98gjjzBp0iSmTJnCAw88AMBvf/tbioqKmDJlCtdddx0tLS2A8dCQiRMnMmXKFObOnXvG\nfidiYNpysJ7bV29h0f++wysfV3LzeSN4+74F/PyL50qwx7iovUO18oc/pG1X3075GzduLFnf+U6v\n9err67tN+ZuWlsbLL7/MJZdcwjXXXENzczMvvfQSn376Kbfccgs7duxg5cqVVFdX8+CDD9LW1sac\nOXN49tlnOXToEJdddhk7d+5k5MiRgBHuTU1NvPLKK3z/+99n/fr1xMfHB392XV0dw4YNA+DBBx8k\nMzOTu+++m0mTJvGPf/yD3Nxcjh49ytChQ7u1X+5QHdwCAc3ru6tZ8fY+th46Qkq8nWWzR/Ll80bI\nM0ljgNyhehp6mvLX4XCwZMkSACZNmkRcXBx2u51JkyYF53N/7bXX+Oijj4JPZWpoaAjuO2PGjGCw\nh1q/fj233nor8fHxQMcUwTt37uTBBx/k6NGjNDU1sXjxYgDmzJnDsmXL+MIXvsC1117br78HMbB4\nfAH+tqOMle/sZ291E3kpLr535QS+UJiPy2GNdPPEGRa14R5OD7s/HG/KX7vdHjzhZLFYiIuLCy77\nfD7AuAHk//7v/4JBHPqZJzNFMMCyZct44YUXmDJlCqtXr+att94CYMWKFWzevJmXXnqJc889lx07\ndgR7+GJwamrz8cwHh3liwwEqGtyMzUrilzecy2WTsrHJRF6DlvzluzidKX8XL17Mb37zG7xeLwB7\n9uyhubn5hPssWrSIVatWBcfU25/c1NjYSHZ2Nl6vl6effjpYf9++fcycOZOHH36YtLQ0SkpKTvYQ\nRYyoaWzjp6/uZvaPXue/X9rFiGHxrL61iFfuuYCrzs2VYB/korbnHimnM+XvV77yFQ4ePMi0adPQ\nWpOens4LL7zQ68/bsWMHhYWFOBwOLr30Un74wx/y/e9/n5kzZzJixAgmTZpEY2MjAPfeey979+5F\na83ChQuZMmXKaR2vGHgO1jaz8t39rN1aitcfYMmELL46bzTn5nc//yIGr6g9oSpOnfweY9NHpcZE\nXq/srMRusXDd9DzuuGAko9ITe99ZxAw5oSpEDNBa887eWla8tY+N++tIctr413mjWTangIwkZ6Sb\nJ6KYhLsQUeh4E3ndMCOfJKc8wk70TsJdiCjS4vGxZksJv9twgNIjrZyVkSgTeYlTIuEuRBSob/bw\n5MaD/OH9gxxp8TJ9RAr/dcUEFo7NkIm8xCmRcBcigkrqW3hiwwH+sqWEVq+fi8YZE3kVFqRGumli\ngJNwFyICPi0/xuPv7OPFjyqwKLjq3Fy+OncUZ2cmRbppIkaEFe5KqSXALwEr8Dut9Y+7bB8O/AEY\natZ5QGv9ch+3NaZdeuml/OlPf+pxrhgRG7TWbNxfx4q39/POnhoSHFZum1PAbeePJDvZFenmiRjT\na7grpazAY8DFQCmwRSm1Tmv9aUi1B4E1WuvfKKXGAy8DBf3Q3pj18svy/8JY5Q9oXv2kksff3seH\npQ2kJcZx7+Ix/MvMESTHy5Uvon+Ec/p9BvC51nq/1toDPANc1aWOBtrnD00GyvuuiWfez3/+cyZO\nnMjEiRP5xS9+AcCTTz7J5MmTmTJlCjfffDMANTU1XHfddRQVFVFUVMR7770HwAcffMDs2bOZOnUq\ns2fP5rPPPgNg9erVXHvttSxZsoSzzz6b++67L/gzCwoKqK2tBXqeclgMPG6vn6c3H2Lhz97i609v\no6HVyw+vmcSG+xfwjQVnSbCLfhXOsEwuEDqBSSkws0ud5cBrSqm7gQTgotNt2Ltr9lBb0nS6H9NJ\nWn4iF3zhnBPW2bp1K7///e/ZvHkzWmtmzpxJUVERP/jBD3jvvfdIS0sLzv9yzz338K1vfYvzzz+f\nw4cPs3jxYnbt2sXYsWN55513sNlsrF+/nu985zs899xzAOzYsYPt27cTFxfHmDFjuPvuu8nPz+/U\nhlWrVnWacvi6666TycEGkIYWL09tPsTv3ztAbZOHKXnJ/OZL01g0IQurXPkizpBwwr2nf41d5yy4\nEVittf6ZUuo84I9KqYla60CnD1LqTuBOgOHDh59Ke/vdhg0buOaaa4KzOF577bUUFxezdOlS0tLS\ngI5pedevX8+nn3aMTh07dozGxkYaGhq45ZZb2Lt3L0qp4ERiAAsXLiQ5ORmA8ePHc+jQoW7h3tOU\nwxLu0W9fTRN/2nyYZz44TLPHz7xz0vnqvFGcN2qYPMJOnHHhhHspEJo+eXQfdrkdWAKgtd6olHIC\naUB1aCWt9UpgJRhzy5zoh/bWw+4vPc21o5Tq8T/OQCDAxo0bcbk6nwy7++67WbBgAc8//zwHDx5k\n/vz5wW3tUwUDWK3W4HTB7Y435bCITm0+P//YWcmfNh9m84F6bBbFZZOz+erc0YzPkScdicgJZ8x9\nC3C2UmqkUsoB3ACs61LnMLAQQCk1DnACNX3Z0DNl7ty5vPDCC7S0tNDc3Mzzzz/P9OnTWbNmDXV1\ndUDHtLyLFi3iV7/6VXDfHTt2AMa0wbm5uYAxzn4yTmfKYXHm7Ktp4r9f/JRZP3yde57ZQUWDm/uX\njGXjtxfyyxumSrCLiOu156619iml7gJexbjMcZXW+hOl1MNAsdZ6HfDvwG+VUt/CGLJZpiM13eRp\nmjZtGsuWLWPGjBmAMY3vnDlz+O53v8u8efOwWq1MnTqV1atX8+ijj/KNb3yDyZMn4/P5mDt3LitW\nrOC+++7jlltu4ec//zkXXnjhSf3805lyWPSvnnrpiyZkctOMEcwePUzuJBVRRab8jUHye+xb+2qa\neOaDw6zdWsqRFi/DU+O5YUY+10/PJz0prvcPEKIPyZS/QpyG9l76nz84zKb9Hb30G2cMZ87oNOml\ni6gn4S5EiP01Tfy5Sy/9viVjpJcuBpyoC/fjPTBahGeAnuqIKOmli1gUVeHudDqpq6tj2DC5LvhU\naK2pq6vD6ZQn9ITjeL30pdPz5ClHYsCLqnDPy8ujtLSUmpoBeRVlVHA6neTl5UW6GVGrzefn1U+q\n+NPmQ9JLFzEtqsLdbrczcuTISDdDxKD9NU08s6WEtVtLqW/2kJ/qkl66iGlRFe5C9KWeeukXj8/k\nppnSSxexT8JdxJyDtc38yRxLb++l37t4DNcXSi9dDB4S7iIm+AOaN3ZX88dNh3hnT4300sWgJ+Eu\nBrSaxjbWFJfwp82HKTvaStYQJ/928TncUJRPxhDppYvBS8JdDDhaa4oPHeGPGw/xys4KvH7N+Wel\n8Z+Xj+eicRnYrOHMhydEbJNwFwNGU5uPF7aX8dSmQ+yubCTJaePmWQV8adZwRqcnRrp5QkQVCXcR\n9fZUNfLUpkP8dVsZTW0+JuQM4SfXTeKKKTnEO+SfsBA9kf8yRFTy+gO89kkVf9x0kE3763HYLFw+\nOZubZ43g3PyhcgezEL2QcBdRpaKhlT9/UMKfPzhMTWMb+akuHrhkLF8ozCc1wRHp5gkxYEi4i4jT\nWvP+vjr+uPEQ/9xVRUBrFozJ4OZZI5h7Tro8VFqIUyDhLiKmodXLc1tLeWrzIfbXNJOa4OCOC0bx\npZnDyU+Nj3TzhBjQJNzFGbezrIGnNh3ihR1luL0Bpg0fyv9+cQqXTMzGabdGunlCxAQJd3FGuL1+\nXv64gj9uOsT2w0dx2a1cMzWXL80cwcTc5Eg3T4iYI+Eu+lVJfQtPbT7Emi0lHGnxMio9gf+6YjzX\nTssj2WWPdPOEiFkS7qLPaa3Z8Hktv3/vIG9+Vo1FKRaNz+TmWSM4b7Q8iEWIM0HCXfSZVo+f57eX\nsfr9A+ypaiIt0cHdC87ixpnDyU52Rbp5QgwqEu7itFU0tPLkxkP8+YPDHG3xMiFnCD+7fgqXT8km\nziYnSIWIBAl3cUq01mw7fJTfv3eAV3ZWorVm8YQsbp0zkqKCFBl6ESLCJNzFSfH4Aryys4JV7x3k\nw5KjJDlt3H7+SG6eNUKuTRciiki4i7DUNbXx5w8O8+TGQ1Q3tjEqPYHvXzWBa6flkRAn/4yEiDby\nX6U4od2Vx/j9hoM8v6MMjy/A3HPS+cnSAuadnS5PNxIiioUV7kqpJcAvASvwO631j3uo8wVgOaCB\nD7XWN/VhO8UZ1P7IulUbDrBxfx0uu5Xrp+dx65wCzspIinTzhBBh6DXclVJW4DHgYqAU2KKUWqe1\n/jSkztnAt4E5WusjSqmM/mqw6D+Nbi/PFpey+v2DHK5vISfZyQOXjOWGonyGxsuMjEIMJOH03GcA\nn2ut9wMopZ4BrgI+DalzB/CY1voIgNa6uq8bKvrPwdpmVr9/kLVbS2lq81E4IoX7l4xl8YRMeWSd\nEANUOOGeC5SErJcCM7vUOQdAKfUextDNcq31P7p+kFLqTuBOgOHDh59Ke0UfaZ9m9/fvHeD13dXY\nLIrLJ+dw65wCJucNjXTzhBCnKZxw7+msme7hc84G5gN5wLtKqYla66OddtJ6JbASoLCwsOtniDPA\n7fXzwvYyfv/eQT6ramRYgnEX6b/MGkHGEGekmyeE6CPhhHspkB+yngeU91Bnk9baCxxQSn2GEfZb\n+qSV4rRVNrj546aD/GnzYY60eBmXPYSfLp3MFVNyZJpdIWJQOOG+BThbKTUSKANuALpeCfMCcCOw\nWimVhjFMs78vGypOXiCg2bi/jr9sKeHljyvwa83F4zK57fyRzByZKneRChHDeg13rbVPKXUX8CrG\nePoqrfUnSqmHgWKt9Tpz2yKl1KeAH7hXa13Xnw0Xx7e/ponntpXy/LYyyhvcJDltLJtdwC2zC+Qu\nUiEGCaV1ZIa+CwsLdXFxcUR+dixqaPXy4kflrN1ayvbDR7EomHtOOtdNy+Pi8Zky9CJEjFBKbdVa\nF/ZWT+5QHcB8/gDv7q1l7bZS/vlpFR5fgDGZSXzn0rFcdW4umXKCVIhBS8J9ANpdeYzntpbywo5y\nahrbSIm3c9OM4SydnseEnCEyli6EkHAfKOqa2vjbjnKe21bKJ+XHsFsVC8ZkcN30PBaMycBhk5uN\nhBAdJNyjmMcX4I3dVazdWsZbn1XjC2gm5Saz/IrxXHluLqkJMiWAEKJnEu5RRmvNR6UNPLetlHUf\nlnO0xUtGUhy3nz+S66bncU4yQElZAAAgAElEQVSmTNwlhOidhHuUqGxw8/z2Mp7bVsrn1U3E2Sws\nmpDFddNyOf+sNJnjRQhxUiTcI6jV4+e1TytZu7WU9z6vJaChcEQKP7p2EpdOyibZZY90E4UQA5SE\n+xmmtab40BHWFpfy8scVNLb5yB3q4q4FZ3HttDwK0hIi3UQhRAyQcD8DAgHN3uom/rGzkr9uL+VQ\nXQvxDiuXTMzmuum5zBo5TJ5qJIToUxLu/cDjC/BxWQPFB+vZcrCe4kNHONriRSk4b9Qwvnnh2SyZ\nmCXPHhVC9BtJlz7Q1OZj26EjbDHDfEfJUdzeAACj0hJYND6TooJU5pyVRs5QV4RbK4QYDCTcT0FN\nYxvFB+v5wAzzT8uPEdBgUTAhJ5mbZoygqCCFwoJU0pPiIt1cIcQgJOHeC601h+pajCA/YAyxHKht\nBsBptzA1P4W7FpxF0chUpg5PIVGGWoQQUUCSqAt/QLOr4lhwiGXLwSPUNLYBMDTeTuGIVG6ckU9h\nQSoTc5Lltn8hRFQa9OHu9vrZUXLUHGY5wrZDR2hq8wGQO9TFnNHDKBqZyoyCVEanJ8pVLUKIAWHQ\nhXtDi5fiQ/XBYZaPyxrw+o057cdkJnH11ByKClIpKkiVk59CiAEr5sNda82eqiZe313FG7uq2Xb4\nCAENdqtiUm4yt50/khkFqUwfkcLQeJmISwgRG2Iy3N1eP5v21/HG7mpe31VN2dFWACblJnPXhWcz\ne/Qwzs0fKk8nEkLErJgJ96pjbt7cXc3ru6vZsLeWVq8fl93KnLPSuPvCs1gwNkOeTCSEGDQGbLgH\nApqd5Q28vquaN3ZX83FZA2CcBF06PY8Lx2Vw3qhh0jsXQgxKAyrcm9t8bPi8ljd2VfPGZ9XUNLah\nFEwbnsK9i8ewcFwGYzKT5DFzQohBL+rDvaS+xRg7313Npn11ePwBkuJszB2TzsKxGcwfkyFPJBJC\niC6iLtx9/gDbS46awy1V7KlqAow5Wr583gguHJdBUUEqdnl4hRBCHFdUhHtDi5e399bwxq4q3tpT\nw9EWLzaLYsbIVL5QmM+FYzMYlZ4Y6WYKIcSAEbFwb/MFWPnOPl7fVU3xoSP4A5rUBAcXjs1g4dhM\nLjgnjSFOeRKREEKcioiF+56qRn748m7GZiXxtXmjuHBsJufmD8Uqt/cLIcRpi1i45wx1seGBC8mV\nW/yFEKLPhXVWUim1RCn1mVLqc6XUAyeot1QppZVShb195rAEhwS7EEL0k17DXSllBR4DLgHGAzcq\npcb3UC8J+Cawua8bKYQQ4uSE03OfAXyutd6vtfYAzwBX9VDv+8AjgLsP2yeEEOIUhBPuuUBJyHqp\nWRaklJoK5GutXzzRByml7lRKFSulimtqak66sUIIIcITTrj3dPmKDm5UygL8L/DvvX2Q1nql1rpQ\na12Ynp4efiuFEEKclHDCvRTID1nPA8pD1pOAicBbSqmDwCxgXTgnVYUQQvSPcMJ9C3C2UmqkUsoB\n3ACsa9+otW7QWqdprQu01gXAJuBKrXVxv7RYCCFEr3oNd621D7gLeBXYBazRWn+ilHpYKXVlfzdQ\nCCHEyQvrJiat9cvAy13KHjpO3fmn3ywhhBCnIyomDhNCCNFBezx4q6vxVVTgrajAW1GJt6IcX0Vl\n2J8h4S6EEGeQDgTw19V1C21vZSXeigp8FRX4amtB6077WYcOxZadHfbPkXAXQog+5G9sxFtega+y\ne6/bW1mJr7IS7fV22ke5XNizsrBnZxM39wLs2TnYs411W1Y29uwsLC5zupYwnzQn4S6EEGHSXq/R\nwy4rN3rZlRV4yyvMXrcR4IHm5s47Wa3YMjOwZ+fgmjwZ+5LF2LKyggFuy8rCOnRonz8eVMJdCCFM\nAY/HGOcuK8NTVoa3vBxvWZkR5uXl+KqqIBDotI81NRV7djaOggISzptt9sCzsGVnGz3v9HSU1XrG\nj0XCXQgxaATcbqOnHQztsk7LvpqazmPdFgu2rEwcObkkzCjCnptrvHJyzCGTLCxOZ+QO6AQk3IUQ\nMSPQ2toR1iGh3d4L99fUdt7BasWenY09J4eEOXM6grs9xDMzUPaB+UQ4CXchxIChPR68FRV4Dpfg\nLS3BU1pqDJmYIe6vr++8g91uhHduDonz5mHPycER0vu2ZWSgbLEZg7F5VEKIAct/7BiekhK8JSVG\niJeUBNe9FRWdxryVwxHsaTvHju3ocecaZbb0dJQlrGcSxRwJdyHEGaX9fnxVVR2979D3khL8DQ2d\n6ltTU3Hk5+OaOpXkq67EnpePY3g+9vz8QR3evZFwF0L0uUBLizFk0t7rPlyCp9R495aVdb7O22Yz\nhkvy83FOnIAjfzj2/Dwcw4djz8vHmpgQuQMZwCTchRAnTWuNr6YGbzDAS/GWHMZTUoqn5HC3E5eW\npCQc+fnEjRlD0sUXdep927OyYnbcO5LkNyqE6FGw922+jAA3e+ClZWh3yBM1lcKWlYUjP5/EefNw\nhIS3Iz8fS3Jyn9+kI05Mwl2IQUoHAsbYd4kR1t7SkpAAL8Vf26X3nZCAPT+fuJEjSbxgrjF0kp+P\nPTcPe14uFocjQkcieiLhLkQM8zc1mb3uErwlpZ0CvNvYt8ViXDaYn0/SgvnG0El+njF0kpfXL7fI\ni/4j4S7EABbwePCVG7fGe8rKugW4/+jRTvUtyck48vKIGzvWGPvOzevogWdnD9gbdkR3Eu5CRLHu\nd1x2vvvSV1PTeYf2K0/y8nAuXmz0vPPyjQDPy8OanByZAxFnnIS7EBHkb2rqFtih7z3ecZmVhT03\nl4QLLjBu1snJ7XjPypQrTwQg4S5Ev9FaE2ho6Dy7YHvv21wPHDvWaR8VF2fccZmTg3P8+JB5Tsw7\nLtPSIjLDoBh4JNyFOEVaa/y1tUZQl5d3mR7WeA+0tHTaxxIfH+xlx089t/NEVTk5WIcNk5OWok9I\nuAtxHNrvx1ddffwx74oKdFtbp30sQ4YYQT18BPHnndcpuO05OXLFiThjJNzFoKU9HrxVVZ0exhAM\n7vJyvJWV4PN12sc6bBj2nBzixo4l8cILg6HdPnRiTUyM0NEI0ZmEu4hZxoMZuvS2QwLcV13d+cEM\nSmHLzMSek4Pr3HMZEtrrzjUezhB8jqUQUU7CXQxI2ucz5japqDQfRFzZ6TmW3spK/HV1nXey2Ywr\nTXJySJg9u1uv256ZiZK7LEWMkHAXUUdrjb++viO4zQcQh4a4r7oa/P5O+1kSErDnGE+Ld44fH7zC\npD3EbRkZcqWJGDQk3MUZ529sxFteERLWFUZvu6I9xCvRHk+nfZTDgS07C3tWNgkzZmDLycaelR18\nerw9OxtrUlKEjkiI6BNWuCullgC/BKzA77TWP+6y/d+ArwA+oAa4TWt9qI/bKgaAgNuNt6ICX2Wl\nEdwV5R3LZogHmps772S1YsvMwJ6VjWviRGwXX9QR3OYT5K0pKXKViRAnoddwV0pZgceAi4FSYItS\nap3W+tOQatuBQq11i1LqX4FHgC/2R4NF5GivF29VdZced8hQSUVFt7lMAKxpadizsogbOdIY6+7S\n47alp8twiRB9LJye+wzgc631fgCl1DPAVUAw3LXWb4bU3wT8S182UvQ/HQjgq6ntPlRSaS6XV+Cr\nre18dQnmdd3Z2dizsnBNmRwS3NnG+HdmpkwFK0QEhBPuuUBJyHopMPME9W8HXulpg1LqTuBOgOHD\nh4fZRHG6tNb4jx41h0cqOg+btId4dTWETv8KKJfLuLokO4u4Cy4wQrw9uLOzsGdlYUmQR6CJQURr\nCPgh4At5dV3vqSxkXft7r3Oizw1TOOHe00Cn7qEMpdS/AIXAvJ5/L3olsBKgsLCwx88QJ6d9/hKj\nh22cjDTeqzqtd3pqDhgTUGVkYM/OxjVtGkOysoInLO3ZxnCJPD1H9IlAAAJe8HvA7zVeAe8Jlj3g\n94WxT3s9X8e2gN9YDvg6PiPgM7f5wlz2dv7cgL/jZwZ8vR9vlAgn3EuB/JD1PKC8ayWl1EXAd4F5\nWuu2rtvFyQsruKuq0K2tnXe0WLBlZBjj3GPHkjhvXvASwfaxbltamjw1Plb5feBvA1/7y20Eoc8N\nvvb3NrNOSFnXOp0+o+0462b99hDuKYB1oP+P2WIHqx0sNuPV47IdLFZz3SyzuzqWrbaOep2Wzf06\n/Qxrx37BdVsv673VCeNzlBW+F975qXDCfQtwtlJqJFAG3ADcFFpBKTUVeBxYorWuPrm/yuDUPbir\njCGSkw3u+fOxZWUawydZIcEt0772Pa2NnpuvzQzC9oDzdH4P9jZDep1+T5fyHpY79VS71jleWWi5\n2SYd/lf341Ngc4ItLuTlBGvIelwSxKeBzQFW82Wxmcv2zsvtgdppuYd6J7tPewDG4DdMrTWN3kaq\nmiupaqmiuqWaquaqsPfvNQG01j6l1F3AqxiXQq7SWn+ilHoYKNZarwN+CiQCz5pf4w9rra88lQOK\nBVpr/EeOBAPaV1V1aj1uCW6D1iG9yjbwtnb0SH1t4Ouy7m0N6Ym29fDeQyD3WC+kJ9tep+cRyVOn\nLB3BaLV3ee+ybHNC3JAT1LF3hLAtrnMQB9edRhjbnB2fGVwPqWuxxWRgRouADlDvrqeqpYqq5qpO\n4R1cbqmi1dfa+4cdh9I6MkPfhYWFuri4OCI/+3Rovx9fba05RGIGd5UZ3FWV+Kqq8VVVdbsJJzS4\nbVlZ2DMzzTHuARbcWpsB2mKEqLfVCFdvq1nmDtnWcoLw7S2cQ7e7Oe1QtdjM8HJ0eY8zQ66n93Dq\nO7uU2Y16Jwrp0DC2yCWgscbr91LTWmME93HCu6alBp/uPH5vUzbS49PJiM8gMz6TzIRM4z0+0yhL\nyCTdlU6cLW6r1rqwt3ZEeZKcWQGPB1919fGDu7LKuBywy23vym4PBrZryhTjhpzMrGCv25aZiW3Y\nsP4N7vberac5JGjNkG0v87k7h3KwXmhA9xDSXfc7paA1v+bbnSFf952dX86hJ9ge12X/9jJX596q\n3dW912p1SIiK06a1ptnbTHVrNTUtNcHAruwybFLnruu2r9PqDIb19MzpwfDOiM8gKz6LzIRMUp2p\nWFTfnQcbFOGutSZw7Bi+mhpjfu6qanxV5pBJSHB3e6QZxsMVbFlZ2LMyiZs92wjszExj9kCzxx3W\nHN0BP7Q1gqel5+Dti7JTOXFlcxqBaI83l+PNdSe4hnbZ5grZ7jrOfiEvW/u70+ilytd8EaVavC3U\ntNZQ3WIEd+hydWs1ta21VLdU9zhMMsQxJBjU41LHdeppt/fChziGnPErzwZ0uOtAAH99vRHaoa/q\nmm5l3YZJAOvQocZwSGYGromTjB53Wgq21CHYUxOxDY3H6sAIUU+zEaCeZvDWgacESpvgQIsZ2M3G\nu6e5Y7m9vqfZGLM9WcHQjAdHfEeYOodCUjY4EsyyhI5A7amsfX+bq3NA25wgV8yIGOb2ualprQmG\ndE1Ll2VzW5O3qdu+TquT9Ph00l3pjEsdx9y8uWS4MoJl7eHtskXnNNBRGe7a68VXV9c5rKur8VVX\n4quuMpZr6/DVHzWuoe3CEh+HLdmFbYgTV7Yd29m52BKs2OLB5gpgd/mwxXmw6FbwfA7eD40wrmk1\nZsYJl8Vuhm6CEarty/HDYOhws7w9nBNCQjr05epe1h7EErxC9KjN30Zta223XnbX5WOeY932tVvs\nZMRnkO5K56yhZzE7ZzbpLmOsOz0+PRjgifbEAX2fR8TC3V95kPpvL8V3tAnf0RZ8x9z4GtvwNfnw\nt/Q8vGCN82NzBbC5/MQlBbBl+LE5O8pszgA2px9L6FF17a3anWbopoAjt0sAJ/YQxj2VmWFutZ+Z\nX5YQg4DWmoa2Bmpaa6htrQ2+2tfrWuuCy42exm7725SNtPg0MlwZFCQXUJRVFAzsdFd6MLiT4wbH\nzXkRu1pmotOlny0oMM6zxStsiRZsiXZsSXHYkp3YkuOxDU3EljIEW2oytmGpKGdCz2O79vie361x\n0vsVIsI8fk+noA4N6doWM8TdxruvhztAnVYnaa400uPTSXOlMcw5LLic5koL9sJTnCl9ekIyWiml\novtqmbizRnP2228bU7lKAAsxoGitOeY51qln3R7U7QHevtzT0IhCkeJMMULblc6ooaOCy+2h3f5K\nsCcMip52X4tYuCunE9uwYZH68UKIHrT52zr1rENDuuvQyIl62WmuNEYmj6Qoq6hzr9s1LNjLtlsG\n17CmDmj8vgA+bwC/t+O9vczn9Rvr7dt8AXye9jr+YP1wReUJVSFE3wnoQKex7BMFdk9j2V172SOT\nRwYDPN2VzjDXsODyQOll+/0B/B4zVD3+Tu9GeXtZAH/Icnu53xPA5wvgb9/H1xHKwdD2htTxBQj4\nTm8IXCmwOsK/X0PCXYgBKKADNHoaqXPXUd9aT73beIUOibQHeH1rfbe7IQFcNlcwlM8aehazsmf1\nGNgpzhRslv6PCr/fDFCP33x1rHvb173+TnW8njDC2NPRK/aZga4Dpxa07QFrs1uw2S1Yg+9GmcNl\nw5Vk6bS9ax2rLbSs58/pqY7Fagxff+3R8Noq4S5EFNBa0+Jrob613ghsdz1H3EeCoV3nruu0fsR9\nBH8PE4RZlIVUZ2owoM9OObvbGHb7uHa8PT6stgUCGo/b1z1oPd2D1tdjCAe6bA/pKYfUCZxC4CqL\nMoLUYYSg3WE1w9CKzWHBmWAzAtPRHrjmsqMjSI1t5n6OkDrmu1FuNQNWDYhvJiDhLkS/cfvcwUDu\nGs7dXq31eALdb7QDSLQnkupMJcWZQm5iLpPSJhnrcamk2FIZakthiHUoSZYhJJBIwEfnAHb78R0L\nBMtKPR4Oekp7COUuAW2++30nf+ezUmCLswZD0eawYncY785Eu1FurtvtVqwOS3B7cJsZrvbQsi51\nrFa5GON4JNyFCIPb5+Zo21Ea2ho42nbUeLmPBpcb3A00tDTS1NrEsZYmGlub8Xp82AJ2rAE7Vm3H\nFjBeTu1iiHUoiZZ80i3jSFCJOInHiQuHdmLXcdgDdiwBG8pvJeDV5jhux0k1nyfAMV+AY8AhWoFW\noCKsY2nvodq7BakVZ6KjW8ja46whPd7QwLV0DumQ5YHUw41VEu4ipmitCQR0x8mykLFWvy+Ap81H\nY2szja1NNLU00dTaQou7lZY2N63uNtraPHg8XrweX/DkmPZqVMCK1Qxn492GNeDAFsjFFSggUdvJ\nPcU2hw4tWGwWlMOKtltQ7cMELmtw3NVmt3Qa87U5rFht7cMJlmBvORjQ9u4hbLFI6A4GEu6i3xiX\ncvm7XfrV42Vf3pArEdrLQq9I8HUEtM/jNwPYj9drjAUHfJqAT6N9gD7Z8IoD4rAADuXDZvWhrQGw\napQdrDaFNc6C3W7F7rDhiLPjdDhwOeOId7qwO2w9Bm3w5Fh7zzhkbNgWsk2GFkR/kHAf5AIBja/N\nj7f95fF3rLcvewJ43cfb1rGvzxPoWG7zn9IJsnbaEkBbAgSsPvwWHz6LF5/y4FFteFQbfosXn8Vr\nvDt9+C0ec92oq2wau8OG0xGH0xmHKy6OBKeLeJeLJGcCSQlJJMcbr9SEFFISh5IcPwSbVaYGFrFB\nwj2KBQL6hFcf+DztJ8l6uULB6+8hwI0gPtmTZRabwupQKLtG2TXYA2irH7/NRyDJiy/Zi9fShsfq\npk214lattOoWmnUTLYEmmnUjHuXBb/HiV96QQPYEgxlrgMS4RBLtiSQ5kkhyJHVaTnckkmQfYpQ7\nzHJ752W7zPsjBjkJ91OgtQ7ePWb0WHsIXG9PIdz1Gl7zOl1v312lgML46m+zYHUoLHZQNsAeAFuA\ngNNPwGb0dANWDz6r0RM2griFVtVMC0200ESTPkajPkajbqBNteKzetDqxL1xh8VBgj2BeHs8CfYE\nEu2JJDoSSXMkkWjP6zGsuy67bC45GSfEaYqpcNdad4zpejrGe7teV9s5THsO1h6v5w3Z71QeRtRx\nwsscnzWDV9nAkhTAbgtgs/mNoQirzxx68OC1ePAod0gIm0GsW2jRTTRj9IibAo00BxppC4Q/d7zd\nYifBntARyDZjeZg9nnxbWudt7cu2+I51W8f2eHv8oLulXIhoFbFw97b5Kdldj9/s1fo7hXBPwdxl\n2CF4SVhImS9wSqFrsaqO62btCovd7PHaQbk0liEB7FYjeB1WI3wDVmMooT18vZY2PJY22nDjUW4j\nfGnBrYwAbtUtuP1uWn2ttPpacfvd4TUuYLxsFhsumwuX1UW8Ld5Ytrlw2V2k2DJx2Qpw2bpsM7e7\nbC4SbJ0Duj2kZfhCiNgUsXA/UtnCul/sOO52ZTGux7XYwWJXZg9Xo2wabBrtCkCin4DVeGH1oSw+\n/NaO3q7P4sWr2vCqNtosbtowxoFbaaaVFlpppjlgBG+br63HW7SPy2++MObecNqcOK1O4mxxxrsl\nLricak3BacvGaXUSb+8SvjZXj2XBoDbDWXrEQoiTEbFwb0k4wobpT+OmBTettNBEKy3BoYiA5RTG\nmzEm7Ldb7cRZ43BYHcRZ44LLDouxnmRzkmZN7hzG1rjuAW2N67Tssrk6l5nvdotdxoiFEFElYuFu\ni7MwalxW5/A1w7g9hIPrIds6lVsc3eqciQmOhBAi2kUsCfOS8vjB+T+I1I8XQoiYJrfGCSFEDJJw\nF0KIGCThLoQQMSiscFdKLVFKfaaU+lwp9UAP2+OUUn8xt29WShX0dUOFEEKEr9dwV0pZgceAS4Dx\nwI1KqfFdqt0OHNFanwX8L/CTvm6oEEKI8IXTc58BfK613q+19gDPAFd1qXMV8AdzeS2wUMmF30II\nETHhhHsuUBKyXmqW9VhHa+0DGoBhXT9IKXWnUqpYKVVcU1Nzai0WQgjRq3DCvaceeNcZXMKpg9Z6\npda6UGtdmJ6eHk77hBBCnIJwbmIqBfJD1vOA8uPUKVVK2YBkoP5EH7p169ZapdShk2hrNEoDaiPd\niDNMjnlwGGzHPJCOd0Q4lcIJ9y3A2UqpkUAZcANwU5c664BbgI3AUuANrfUJ52fUWg/4rrtSqlhr\nXRjpdpxJcsyDw2A75lg83l7DXWvtU0rdBbwKWIFVWutPlFIPA8Va63XAE8AflVKfY/TYb+jPRgsh\nhDixsOaW0Vq/DLzcpeyhkGU3cH3fNk0IIcSpkjtUT8/KSDcgAuSYB4fBdswxd7yql6FxIYQQA5D0\n3IUQIgZJuAshRAyScA+hlFqllKpWSu0MKZuilNqolPpYKfV3pdSQkG2TzW2fmNudZvl0c/1zpdSj\n0TwVw8kcs1LqS0qpHSGvgFLqXHNbrB6zXSn1B7N8l1Lq2yH7nHBCvWhyksfsUEr93iz/UCk1P2Sf\ngfR3zldKvWn+3T5RSt1jlqcqpf6plNprvqeY5co8ps+VUh8ppaaFfNYtZv29SqlbInVMJ0VrLS/z\nBcwFpgE7Q8q2APPM5duA75vLNuAjYIq5PgywmssfAOdh3Ln7CnBJpI+tL465y36TgP0h6zF5zBj3\ndDxjLscDB4ECjMuC9wGjAAfwITA+0sfWR8f8DeD35nIGsBWwDMC/czYwzVxOAvZgTH74CPCAWf4A\n8BNz+VLzmBQwC9hslqcC+833FHM5JdLH19tLeu4htNbv0P3O2jHAO+byP4HrzOVFwEda6w/Nfeu0\n1n6lVDYwRGu9URv/Mp4Eru7/1p+akzzmUDcCfwaI8WPWQIJ557UL8ADHCG9Cvahxksc8Hnjd3K8a\nOAoUDsC/c4XWepu53AjswpgHK3Siwz/QcQxXAU9qwyZgqHnMi4F/aq3rtdZHMH5XS87goZwSCffe\n7QSuNJevp2MqhnMArZR6VSm1TSl1n1meizEdQ7ueJlqLdsc75lBfxAx3YvuY1wLNQAVwGPgfrXU9\n4U2oF+2Od8wfAlcppWzmnenTzW0D9u9sPmNiKrAZyNRaV4DxPwCMbydw/L/pgPxbS7j37jbgG0qp\nrRhf7TxmuQ04H/iS+X6NUmohYU6iFuWOd8wAKKVmAi1a6/bx21g+5hmAH8gBRgL/rpQaRWwf8yqM\nACsGfgG8D/gYoMeslEoEngP+n9b62Imq9lCmT1Ae1cK6Q3Uw01rvxhiCQSl1DnCZuakUeFtrXWtu\nexljTPMpjMnV2vU00VpUO8Ext7uBjl47GL+LWD3mm4B/aK29QLVS6j2gEKMn19uEelHteMesjWm7\nv9VeTyn1PrAXOMIA+zsrpewYwf601vqvZnGVUipba11hDrtUm+XHmySxFJjfpfyt/mx3X5Ceey+U\nUhnmuwV4EFhhbnoVmKyUijfHY+cBn5pf8xqVUrPMKwm+DPwtAk0/ZSc45vay6zHGmIHgV9tYPebD\nwIXmlRQJGCfadhMyoZ5SyoHxP7x1Z77lp+54x2z+m04wly8GfFrrAfdv22zjE8AurfXPQza1T3SI\n+f63kPIvm3/rWUCDecyvAouUUinmlTWLzLLoFukzutH0wuiNVgBejP9b3w7cg3GWfQ/wY8y7es36\n/wJ8gjF2+UhIeaFZtg/4Veg+0fY6hWOeD2zq4XNi8piBROBZ8+/8KXBvyOdcatbfB3w30sfVh8dc\nAHyGcQJyPTBigP6dz8cYPvkI2GG+LsW4su11jG8jrwOpZn2F8UjRfcDHQGHIZ90GfG6+bo30sYXz\nkukHhBAiBsmwjBBCxCAJdyGEiEES7kIIEYMk3IUQIgZJuAshRAyScBdCiBgk4S7EaVBKWSPdBiF6\nIuEuBg2l1Pfb5/Q213+glPqmUupepdQWcw7v74Vsf0EptdWcC/zOkPImpdTDSqnNGNPfChF1JNzF\nYPIE5m3n5i33NwBVwNkYE4SdC0xXSs0169+mtZ6OcVfmN5VSw8zyBIx50WdqrTecyQMQIlwycZgY\nNLTWB5VSdUqpqUAmsB0owpgrZLtZLREj7N/BCPRrzPJ8s7wOY5bI585k24U4WRLuYrD5HbAMyMKY\n2nYh8COt9eOhlcxHy3q9+EsAAAC6SURBVF0EnKe1blFKvQU4zc1urbX/TDVYiFMhwzJisHke4yk6\nRRgz+70K3GbO+Y1SKtecLTEZOGIG+1iM2SCFGDCk5y4GFa21Ryn1JnDU7H2/ppQaB2w0n/XchDHb\n5z+ArymlPsKYIXFTpNosxKmQWSHFoGKeSN0GXK+13hvp9gjRX2RYRgwaSqnxGPNxvy7BLmKd9NyF\nECIGSc9dCCFikIS7EELEIAl3IYSIQRLuQggRgyTchRAiBv1/8E+Pl/3v0q0AAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x1154c2978>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "def calculate_mean_over_time(dataframe,column,continent_name,function):\n",
    "    '''Calculate values over time in years.\n",
    "    \n",
    "    Arguments:\n",
    "    dataframe: main dataframe we are interested in\n",
    "    column: category/label in dataframe\n",
    "    continent_name: self expalantory\n",
    "    function: mean, median, etc\n",
    "    \n",
    "    Returns: dataframe of continent, year, and value of category we are interested in.'''\n",
    "    \n",
    "    continent_data = dataframe['continent']==continent_name\n",
    "    df_continent = df[continent_data]\n",
    "\n",
    "    years = df_continent['year'].unique()\n",
    "    result =[]\n",
    "\n",
    "    for i in years:\n",
    "        year_data = df_continent['year'] == i\n",
    "        df_year = df_continent[year_data]\n",
    "        value = function(df_year[column])\n",
    "        result.append((continent_name,i,value))\n",
    "\n",
    "    summary = pd.DataFrame(result,columns=['continent','year',column])\n",
    "    return summary\n",
    "\n",
    "\n",
    "def calculate_median_over_time(continent_name):\n",
    "    continent_data = df['continent']==continent_name\n",
    "    df_continent = df[continent_data]\n",
    "\n",
    "    years = df_continent['year'].unique()\n",
    "    result =[]\n",
    "\n",
    "    for i in years:\n",
    "        year_data = df_continent['year'] == i\n",
    "        df_year = df_continent[year_data]\n",
    "        value = np.median(df_year['lifeexp'])\n",
    "        result.append((continent_name,i,value))\n",
    "\n",
    "    summary = pd.DataFrame(result,columns=['continent','year','lifeexp median'])\n",
    "    summary.plot.line('year','lifeexp median')    \n",
    "    \n",
    "def main():\n",
    "    fig, ax = plt.subplots()\n",
    "    category = input(\"Input category: \")\n",
    "    continents = df['continent'].unique()\n",
    "    for i in continents:\n",
    "        output = calculate_mean_over_time(df,category,i,np.mean)\n",
    "        output.plot.line('year',category,ax=ax,label=i)\n",
    "    \n",
    "main()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Help on function calculate_mean_over_time in module __main__:\n",
      "\n",
      "calculate_mean_over_time(dataframe, column, continent_name, function)\n",
      "    Calculate values over time in years.\n",
      "    \n",
      "    Arguments:\n",
      "    dataframe: main dataframe we are interested in\n",
      "    column: category/label in dataframe\n",
      "    continent_name: self expalantory\n",
      "    function: mean, median, etc\n",
      "\n"
     ]
    }
   ],
   "source": [
    "help(calculate_mean_over_time)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['asia', 'europe', 'africa', 'americas', 'oceania'], dtype=object)"
      ]
     },
     "execution_count": 133,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}