Assignment 3 - Advanced Python Pandas.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---\n",
    "\n",
    "_You are currently looking at **version 1.5** of this notebook. To download notebooks and datafiles, as well as get help on Jupyter notebooks in the Coursera platform, visit the [Jupyter Notebook FAQ](https://www.coursera.org/learn/python-data-analysis/resources/0dhYG) course resource._\n",
    "\n",
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Assignment 3 - More Pandas\n",
    "This assignment requires more individual learning then the last one did - you are encouraged to check out the [pandas documentation](http://pandas.pydata.org/pandas-docs/stable/) to find functions or methods you might not have used yet, or ask questions on [Stack Overflow](http://stackoverflow.com/) and tag them as pandas and python related. And of course, the discussion forums are open for interaction with your peers and the course staff."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Question 1 (20%)\n",
    "Load the energy data from the file `Energy Indicators.xls`, which is a list of indicators of [energy supply and renewable electricity production](Energy%20Indicators.xls) from the [United Nations](http://unstats.un.org/unsd/environment/excel_file_tables/2013/Energy%20Indicators.xls) for the year 2013, and should be put into a DataFrame with the variable name of **energy**.\n",
    "\n",
    "Keep in mind that this is an Excel file, and not a comma separated values file. Also, make sure to exclude the footer and header information from the datafile. The first two columns are unneccessary, so you should get rid of them, and you should change the column labels so that the columns are:\n",
    "\n",
    "`['Country', 'Energy Supply', 'Energy Supply per Capita', '% Renewable']`\n",
    "\n",
    "Convert `Energy Supply` to gigajoules (there are 1,000,000 gigajoules in a petajoule). For all countries which have missing data (e.g. data with \"...\") make sure this is reflected as `np.NaN` values.\n",
    "\n",
    "Rename the following list of countries (for use in later questions):\n",
    "\n",
    "```\"Republic of Korea\": \"South Korea\",\n",
    "\"United States of America\": \"United States\",\n",
    "\"United Kingdom of Great Britain and Northern Ireland\": \"United Kingdom\",\n",
    "\"China, Hong Kong Special Administrative Region\": \"Hong Kong\"```\n",
    "\n",
    "There are also several countries with numbers and/or parenthesis in their name. Be sure to remove these, \n",
    "\n",
    "e.g. \n",
    "\n",
    "`'Bolivia (Plurinational State of)'` should be `'Bolivia'`, \n",
    "\n",
    "`'Switzerland17'` should be `'Switzerland'`.\n",
    "\n",
    "<br>\n",
    "\n",
    "Next, load the GDP data from the file `world_bank.csv`, which is a csv containing countries' GDP from 1960 to 2015 from [World Bank](http://data.worldbank.org/indicator/NY.GDP.MKTP.CD). Call this DataFrame **GDP**. \n",
    "\n",
    "Make sure to skip the header, and rename the following list of countries:\n",
    "\n",
    "```\"Korea, Rep.\": \"South Korea\", \n",
    "\"Iran, Islamic Rep.\": \"Iran\",\n",
    "\"Hong Kong SAR, China\": \"Hong Kong\"```\n",
    "\n",
    "<br>\n",
    "\n",
    "Finally, load the [Sciamgo Journal and Country Rank data for Energy Engineering and Power Technology](http://www.scimagojr.com/countryrank.php?category=2102) from the file `scimagojr-3.xlsx`, which ranks countries based on their journal contributions in the aforementioned area. Call this DataFrame **ScimEn**.\n",
    "\n",
    "Join the three datasets: GDP, Energy, and ScimEn into a new dataset (using the intersection of country names). Use only the last 10 years (2006-2015) of GDP data and only the top 15 countries by Scimagojr 'Rank' (Rank 1 through 15). \n",
    "\n",
    "The index of this DataFrame should be the name of the country, and the columns should be ['Rank', 'Documents', 'Citable documents', 'Citations', 'Self-citations',\n",
    "       'Citations per document', 'H index', 'Energy Supply',\n",
    "       'Energy Supply per Capita', '% Renewable', '2006', '2007', '2008',\n",
    "       '2009', '2010', '2011', '2012', '2013', '2014', '2015'].\n",
    "\n",
    "*This function should return a DataFrame with 20 columns and 15 entries.*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "umich_part_id": "009",
    "umich_partlist_id": "003"
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Energy Supply</th>\n",
       "      <th>Energy Supply per Capita</th>\n",
       "      <th>% Renewable</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Afghanistan</th>\n",
       "      <td>3.210000e+08</td>\n",
       "      <td>10.0</td>\n",
       "      <td>78.669280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Albania</th>\n",
       "      <td>1.020000e+08</td>\n",
       "      <td>35.0</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Algeria</th>\n",
       "      <td>1.959000e+09</td>\n",
       "      <td>51.0</td>\n",
       "      <td>0.551010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>American Samoa</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.641026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Andorra</th>\n",
       "      <td>9.000000e+06</td>\n",
       "      <td>121.0</td>\n",
       "      <td>88.695650</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Energy Supply  Energy Supply per Capita  % Renewable\n",
       "Country                                                             \n",
       "Afghanistan      3.210000e+08                      10.0    78.669280\n",
       "Albania          1.020000e+08                      35.0   100.000000\n",
       "Algeria          1.959000e+09                      51.0     0.551010\n",
       "American Samoa            NaN                       NaN     0.641026\n",
       "Andorra          9.000000e+06                     121.0    88.695650"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Energy Indicator file (\"energy\")\n",
    "#Load Excel file and skip headers and footer rows\n",
    "energy = pd.read_excel('Energy Indicators.xls', skiprows = 17, skip_footer = 38, usecols = [2,3,4,5], na_values = {'...'})\n",
    "#Add column names\n",
    "column_names = ['Country', 'Energy Supply', 'Energy Supply per Capita', '% Renewable']\n",
    "energy.columns = column_names\n",
    "#Replace non-values with Nan\n",
    "energy.replace('...', np.nan, inplace = True)\n",
    "#Convert megajoules into kilojoules\n",
    "energy['Energy Supply'] = energy['Energy Supply'] * 1000000\n",
    "#Remove names of countries in parenthesis\n",
    "energy['Country'] = energy['Country'].str.replace(r\" \\(.*\\)\",\"\")\n",
    "#Remove names of countries with numbers\n",
    "energy['Country'] = energy['Country'].str.replace(r\"([0-9]+)$\",\"\")\n",
    "#Replace country names with shorter versions\n",
    "update_countries = {\"Republic of Korea\" : \"South Korea\",\n",
    "                    \"United States of America\" : \"United States\",\n",
    "                    \"United Kingdom of Great Britain and Northern Ireland\" : \"United Kingdom\",\n",
    "                    \"China, Hong Kong Special Administrative Region\" : \"Hong Kong\"}\n",
    "energy['Country'].replace(to_replace = update_countries, inplace = True)\n",
    "#Reset index to Country\n",
    "energy.reset_index()\n",
    "energy = energy.set_index('Country')\n",
    "\n",
    "energy.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>2006</th>\n",
       "      <th>2007</th>\n",
       "      <th>2008</th>\n",
       "      <th>2009</th>\n",
       "      <th>2010</th>\n",
       "      <th>2011</th>\n",
       "      <th>2012</th>\n",
       "      <th>2013</th>\n",
       "      <th>2014</th>\n",
       "      <th>2015</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Aruba</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.467704e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Andorra</th>\n",
       "      <td>4.018196e+09</td>\n",
       "      <td>4.021331e+09</td>\n",
       "      <td>3.675728e+09</td>\n",
       "      <td>3.535389e+09</td>\n",
       "      <td>3.346317e+09</td>\n",
       "      <td>3.185605e+09</td>\n",
       "      <td>3.129538e+09</td>\n",
       "      <td>3.127550e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Afghanistan</th>\n",
       "      <td>1.030523e+10</td>\n",
       "      <td>1.172119e+10</td>\n",
       "      <td>1.214448e+10</td>\n",
       "      <td>1.469733e+10</td>\n",
       "      <td>1.593680e+10</td>\n",
       "      <td>1.691113e+10</td>\n",
       "      <td>1.935220e+10</td>\n",
       "      <td>1.973134e+10</td>\n",
       "      <td>1.999032e+10</td>\n",
       "      <td>2.029415e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Angola</th>\n",
       "      <td>5.581103e+10</td>\n",
       "      <td>6.842044e+10</td>\n",
       "      <td>7.787420e+10</td>\n",
       "      <td>7.975320e+10</td>\n",
       "      <td>8.247091e+10</td>\n",
       "      <td>8.570262e+10</td>\n",
       "      <td>9.012096e+10</td>\n",
       "      <td>9.626143e+10</td>\n",
       "      <td>1.008863e+11</td>\n",
       "      <td>1.039106e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Albania</th>\n",
       "      <td>9.771760e+09</td>\n",
       "      <td>1.034829e+10</td>\n",
       "      <td>1.112752e+10</td>\n",
       "      <td>1.150029e+10</td>\n",
       "      <td>1.192695e+10</td>\n",
       "      <td>1.223109e+10</td>\n",
       "      <td>1.240477e+10</td>\n",
       "      <td>1.254247e+10</td>\n",
       "      <td>1.279331e+10</td>\n",
       "      <td>1.312082e+10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     2006          2007          2008          2009  \\\n",
       "Country                                                               \n",
       "Aruba                 NaN           NaN           NaN           NaN   \n",
       "Andorra      4.018196e+09  4.021331e+09  3.675728e+09  3.535389e+09   \n",
       "Afghanistan  1.030523e+10  1.172119e+10  1.214448e+10  1.469733e+10   \n",
       "Angola       5.581103e+10  6.842044e+10  7.787420e+10  7.975320e+10   \n",
       "Albania      9.771760e+09  1.034829e+10  1.112752e+10  1.150029e+10   \n",
       "\n",
       "                     2010          2011          2012          2013  \\\n",
       "Country                                                               \n",
       "Aruba        2.467704e+09           NaN           NaN           NaN   \n",
       "Andorra      3.346317e+09  3.185605e+09  3.129538e+09  3.127550e+09   \n",
       "Afghanistan  1.593680e+10  1.691113e+10  1.935220e+10  1.973134e+10   \n",
       "Angola       8.247091e+10  8.570262e+10  9.012096e+10  9.626143e+10   \n",
       "Albania      1.192695e+10  1.223109e+10  1.240477e+10  1.254247e+10   \n",
       "\n",
       "                     2014          2015  \n",
       "Country                                  \n",
       "Aruba                 NaN           NaN  \n",
       "Andorra               NaN           NaN  \n",
       "Afghanistan  1.999032e+10  2.029415e+10  \n",
       "Angola       1.008863e+11  1.039106e+11  \n",
       "Albania      1.279331e+10  1.312082e+10  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#GDP file (\"GDP\")\n",
    "#Load csv file\n",
    "GDP = pd.read_csv('world_bank.csv', skiprows = 4)\n",
    "#Change country names\n",
    "update_countries = {\"Korea, Rep.\": \"South Korea\", \n",
    "                    \"Iran, Islamic Rep.\": \"Iran\",\n",
    "                    \"Hong Kong SAR, China\": \"Hong Kong\"}\n",
    "GDP['Country Name'].replace(to_replace = update_countries, inplace = True)\n",
    "#Keep only 10 years of data\n",
    "years_to_keep = np.arange(2006, 2016).astype(str)\n",
    "GDP = GDP[np.append(['Country Name'], years_to_keep)]\n",
    "#Reset index to Country, including change of name\n",
    "GDP.reset_index()\n",
    "GDP = GDP.rename(columns = {'Country Name' : 'Country'})\n",
    "GDP = GDP.set_index('Country')\n",
    "\n",
    "GDP.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Rank</th>\n",
       "      <th>Documents</th>\n",
       "      <th>Citable documents</th>\n",
       "      <th>Citations</th>\n",
       "      <th>Self-citations</th>\n",
       "      <th>Citations per document</th>\n",
       "      <th>H index</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>China</th>\n",
       "      <td>1</td>\n",
       "      <td>127050</td>\n",
       "      <td>126767</td>\n",
       "      <td>597237</td>\n",
       "      <td>411683</td>\n",
       "      <td>4.70</td>\n",
       "      <td>138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>United States</th>\n",
       "      <td>2</td>\n",
       "      <td>96661</td>\n",
       "      <td>94747</td>\n",
       "      <td>792274</td>\n",
       "      <td>265436</td>\n",
       "      <td>8.20</td>\n",
       "      <td>230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Japan</th>\n",
       "      <td>3</td>\n",
       "      <td>30504</td>\n",
       "      <td>30287</td>\n",
       "      <td>223024</td>\n",
       "      <td>61554</td>\n",
       "      <td>7.31</td>\n",
       "      <td>134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>United Kingdom</th>\n",
       "      <td>4</td>\n",
       "      <td>20944</td>\n",
       "      <td>20357</td>\n",
       "      <td>206091</td>\n",
       "      <td>37874</td>\n",
       "      <td>9.84</td>\n",
       "      <td>139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Russian Federation</th>\n",
       "      <td>5</td>\n",
       "      <td>18534</td>\n",
       "      <td>18301</td>\n",
       "      <td>34266</td>\n",
       "      <td>12422</td>\n",
       "      <td>1.85</td>\n",
       "      <td>57</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Rank  Documents  Citable documents  Citations  \\\n",
       "Country                                                             \n",
       "China                  1     127050             126767     597237   \n",
       "United States          2      96661              94747     792274   \n",
       "Japan                  3      30504              30287     223024   \n",
       "United Kingdom         4      20944              20357     206091   \n",
       "Russian Federation     5      18534              18301      34266   \n",
       "\n",
       "                    Self-citations  Citations per document  H index  \n",
       "Country                                                              \n",
       "China                       411683                    4.70      138  \n",
       "United States               265436                    8.20      230  \n",
       "Japan                        61554                    7.31      134  \n",
       "United Kingdom               37874                    9.84      139  \n",
       "Russian Federation           12422                    1.85       57  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Sciamgo rankings file (\"ScimEm\")\n",
    "#Load file\n",
    "ScimEm = pd.read_excel('scimagojr-3.xlsx', header = 0)\n",
    "#Reset index to country\n",
    "ScimEm = ScimEm.set_index('Country')\n",
    "\n",
    "ScimEm.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Rank</th>\n",
       "      <th>Documents</th>\n",
       "      <th>Citable documents</th>\n",
       "      <th>Citations</th>\n",
       "      <th>Self-citations</th>\n",
       "      <th>Citations per document</th>\n",
       "      <th>H index</th>\n",
       "      <th>Energy Supply</th>\n",
       "      <th>Energy Supply per Capita</th>\n",
       "      <th>% Renewable</th>\n",
       "      <th>2006</th>\n",
       "      <th>2007</th>\n",
       "      <th>2008</th>\n",
       "      <th>2009</th>\n",
       "      <th>2010</th>\n",
       "      <th>2011</th>\n",
       "      <th>2012</th>\n",
       "      <th>2013</th>\n",
       "      <th>2014</th>\n",
       "      <th>2015</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Australia</th>\n",
       "      <td>14.0</td>\n",
       "      <td>8831.0</td>\n",
       "      <td>8725.0</td>\n",
       "      <td>90765.0</td>\n",
       "      <td>15606.0</td>\n",
       "      <td>10.28</td>\n",
       "      <td>107.0</td>\n",
       "      <td>5.386000e+09</td>\n",
       "      <td>231.0</td>\n",
       "      <td>11.810810</td>\n",
       "      <td>1.021939e+12</td>\n",
       "      <td>1.060340e+12</td>\n",
       "      <td>1.099644e+12</td>\n",
       "      <td>1.119654e+12</td>\n",
       "      <td>1.142251e+12</td>\n",
       "      <td>1.169431e+12</td>\n",
       "      <td>1.211913e+12</td>\n",
       "      <td>1.241484e+12</td>\n",
       "      <td>1.272520e+12</td>\n",
       "      <td>1.301251e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Brazil</th>\n",
       "      <td>15.0</td>\n",
       "      <td>8668.0</td>\n",
       "      <td>8596.0</td>\n",
       "      <td>60702.0</td>\n",
       "      <td>14396.0</td>\n",
       "      <td>7.00</td>\n",
       "      <td>86.0</td>\n",
       "      <td>1.214900e+10</td>\n",
       "      <td>59.0</td>\n",
       "      <td>69.648030</td>\n",
       "      <td>1.845080e+12</td>\n",
       "      <td>1.957118e+12</td>\n",
       "      <td>2.056809e+12</td>\n",
       "      <td>2.054215e+12</td>\n",
       "      <td>2.208872e+12</td>\n",
       "      <td>2.295245e+12</td>\n",
       "      <td>2.339209e+12</td>\n",
       "      <td>2.409740e+12</td>\n",
       "      <td>2.412231e+12</td>\n",
       "      <td>2.319423e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Canada</th>\n",
       "      <td>6.0</td>\n",
       "      <td>17899.0</td>\n",
       "      <td>17620.0</td>\n",
       "      <td>215003.0</td>\n",
       "      <td>40930.0</td>\n",
       "      <td>12.01</td>\n",
       "      <td>149.0</td>\n",
       "      <td>1.043100e+10</td>\n",
       "      <td>296.0</td>\n",
       "      <td>61.945430</td>\n",
       "      <td>1.564469e+12</td>\n",
       "      <td>1.596740e+12</td>\n",
       "      <td>1.612713e+12</td>\n",
       "      <td>1.565145e+12</td>\n",
       "      <td>1.613406e+12</td>\n",
       "      <td>1.664087e+12</td>\n",
       "      <td>1.693133e+12</td>\n",
       "      <td>1.730688e+12</td>\n",
       "      <td>1.773486e+12</td>\n",
       "      <td>1.792609e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>China</th>\n",
       "      <td>1.0</td>\n",
       "      <td>127050.0</td>\n",
       "      <td>126767.0</td>\n",
       "      <td>597237.0</td>\n",
       "      <td>411683.0</td>\n",
       "      <td>4.70</td>\n",
       "      <td>138.0</td>\n",
       "      <td>1.271910e+11</td>\n",
       "      <td>93.0</td>\n",
       "      <td>19.754910</td>\n",
       "      <td>3.992331e+12</td>\n",
       "      <td>4.559041e+12</td>\n",
       "      <td>4.997775e+12</td>\n",
       "      <td>5.459247e+12</td>\n",
       "      <td>6.039659e+12</td>\n",
       "      <td>6.612490e+12</td>\n",
       "      <td>7.124978e+12</td>\n",
       "      <td>7.672448e+12</td>\n",
       "      <td>8.230121e+12</td>\n",
       "      <td>8.797999e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>France</th>\n",
       "      <td>9.0</td>\n",
       "      <td>13153.0</td>\n",
       "      <td>12973.0</td>\n",
       "      <td>130632.0</td>\n",
       "      <td>28601.0</td>\n",
       "      <td>9.93</td>\n",
       "      <td>114.0</td>\n",
       "      <td>1.059700e+10</td>\n",
       "      <td>166.0</td>\n",
       "      <td>17.020280</td>\n",
       "      <td>2.607840e+12</td>\n",
       "      <td>2.669424e+12</td>\n",
       "      <td>2.674637e+12</td>\n",
       "      <td>2.595967e+12</td>\n",
       "      <td>2.646995e+12</td>\n",
       "      <td>2.702032e+12</td>\n",
       "      <td>2.706968e+12</td>\n",
       "      <td>2.722567e+12</td>\n",
       "      <td>2.729632e+12</td>\n",
       "      <td>2.761185e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Germany</th>\n",
       "      <td>7.0</td>\n",
       "      <td>17027.0</td>\n",
       "      <td>16831.0</td>\n",
       "      <td>140566.0</td>\n",
       "      <td>27426.0</td>\n",
       "      <td>8.26</td>\n",
       "      <td>126.0</td>\n",
       "      <td>1.326100e+10</td>\n",
       "      <td>165.0</td>\n",
       "      <td>17.901530</td>\n",
       "      <td>3.332891e+12</td>\n",
       "      <td>3.441561e+12</td>\n",
       "      <td>3.478809e+12</td>\n",
       "      <td>3.283340e+12</td>\n",
       "      <td>3.417298e+12</td>\n",
       "      <td>3.542371e+12</td>\n",
       "      <td>3.556724e+12</td>\n",
       "      <td>3.567317e+12</td>\n",
       "      <td>3.624386e+12</td>\n",
       "      <td>3.685556e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>India</th>\n",
       "      <td>8.0</td>\n",
       "      <td>15005.0</td>\n",
       "      <td>14841.0</td>\n",
       "      <td>128763.0</td>\n",
       "      <td>37209.0</td>\n",
       "      <td>8.58</td>\n",
       "      <td>115.0</td>\n",
       "      <td>3.319500e+10</td>\n",
       "      <td>26.0</td>\n",
       "      <td>14.969080</td>\n",
       "      <td>1.265894e+12</td>\n",
       "      <td>1.374865e+12</td>\n",
       "      <td>1.428361e+12</td>\n",
       "      <td>1.549483e+12</td>\n",
       "      <td>1.708459e+12</td>\n",
       "      <td>1.821872e+12</td>\n",
       "      <td>1.924235e+12</td>\n",
       "      <td>2.051982e+12</td>\n",
       "      <td>2.200617e+12</td>\n",
       "      <td>2.367206e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Iran</th>\n",
       "      <td>13.0</td>\n",
       "      <td>8896.0</td>\n",
       "      <td>8819.0</td>\n",
       "      <td>57470.0</td>\n",
       "      <td>19125.0</td>\n",
       "      <td>6.46</td>\n",
       "      <td>72.0</td>\n",
       "      <td>9.172000e+09</td>\n",
       "      <td>119.0</td>\n",
       "      <td>5.707721</td>\n",
       "      <td>3.895523e+11</td>\n",
       "      <td>4.250646e+11</td>\n",
       "      <td>4.289909e+11</td>\n",
       "      <td>4.389208e+11</td>\n",
       "      <td>4.677902e+11</td>\n",
       "      <td>4.853309e+11</td>\n",
       "      <td>4.532569e+11</td>\n",
       "      <td>4.445926e+11</td>\n",
       "      <td>4.639027e+11</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Italy</th>\n",
       "      <td>11.0</td>\n",
       "      <td>10964.0</td>\n",
       "      <td>10794.0</td>\n",
       "      <td>111850.0</td>\n",
       "      <td>26661.0</td>\n",
       "      <td>10.20</td>\n",
       "      <td>106.0</td>\n",
       "      <td>6.530000e+09</td>\n",
       "      <td>109.0</td>\n",
       "      <td>33.667230</td>\n",
       "      <td>2.202170e+12</td>\n",
       "      <td>2.234627e+12</td>\n",
       "      <td>2.211154e+12</td>\n",
       "      <td>2.089938e+12</td>\n",
       "      <td>2.125185e+12</td>\n",
       "      <td>2.137439e+12</td>\n",
       "      <td>2.077184e+12</td>\n",
       "      <td>2.040871e+12</td>\n",
       "      <td>2.033868e+12</td>\n",
       "      <td>2.049316e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Japan</th>\n",
       "      <td>3.0</td>\n",
       "      <td>30504.0</td>\n",
       "      <td>30287.0</td>\n",
       "      <td>223024.0</td>\n",
       "      <td>61554.0</td>\n",
       "      <td>7.31</td>\n",
       "      <td>134.0</td>\n",
       "      <td>1.898400e+10</td>\n",
       "      <td>149.0</td>\n",
       "      <td>10.232820</td>\n",
       "      <td>5.496542e+12</td>\n",
       "      <td>5.617036e+12</td>\n",
       "      <td>5.558527e+12</td>\n",
       "      <td>5.251308e+12</td>\n",
       "      <td>5.498718e+12</td>\n",
       "      <td>5.473738e+12</td>\n",
       "      <td>5.569102e+12</td>\n",
       "      <td>5.644659e+12</td>\n",
       "      <td>5.642884e+12</td>\n",
       "      <td>5.669563e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Russian Federation</th>\n",
       "      <td>5.0</td>\n",
       "      <td>18534.0</td>\n",
       "      <td>18301.0</td>\n",
       "      <td>34266.0</td>\n",
       "      <td>12422.0</td>\n",
       "      <td>1.85</td>\n",
       "      <td>57.0</td>\n",
       "      <td>3.070900e+10</td>\n",
       "      <td>214.0</td>\n",
       "      <td>17.288680</td>\n",
       "      <td>1.385793e+12</td>\n",
       "      <td>1.504071e+12</td>\n",
       "      <td>1.583004e+12</td>\n",
       "      <td>1.459199e+12</td>\n",
       "      <td>1.524917e+12</td>\n",
       "      <td>1.589943e+12</td>\n",
       "      <td>1.645876e+12</td>\n",
       "      <td>1.666934e+12</td>\n",
       "      <td>1.678709e+12</td>\n",
       "      <td>1.616149e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>South Korea</th>\n",
       "      <td>10.0</td>\n",
       "      <td>11983.0</td>\n",
       "      <td>11923.0</td>\n",
       "      <td>114675.0</td>\n",
       "      <td>22595.0</td>\n",
       "      <td>9.57</td>\n",
       "      <td>104.0</td>\n",
       "      <td>1.100700e+10</td>\n",
       "      <td>221.0</td>\n",
       "      <td>2.279353</td>\n",
       "      <td>9.410199e+11</td>\n",
       "      <td>9.924316e+11</td>\n",
       "      <td>1.020510e+12</td>\n",
       "      <td>1.027730e+12</td>\n",
       "      <td>1.094499e+12</td>\n",
       "      <td>1.134796e+12</td>\n",
       "      <td>1.160809e+12</td>\n",
       "      <td>1.194429e+12</td>\n",
       "      <td>1.234340e+12</td>\n",
       "      <td>1.266580e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spain</th>\n",
       "      <td>12.0</td>\n",
       "      <td>9428.0</td>\n",
       "      <td>9330.0</td>\n",
       "      <td>123336.0</td>\n",
       "      <td>23964.0</td>\n",
       "      <td>13.08</td>\n",
       "      <td>115.0</td>\n",
       "      <td>4.923000e+09</td>\n",
       "      <td>106.0</td>\n",
       "      <td>37.968590</td>\n",
       "      <td>1.414823e+12</td>\n",
       "      <td>1.468146e+12</td>\n",
       "      <td>1.484530e+12</td>\n",
       "      <td>1.431475e+12</td>\n",
       "      <td>1.431673e+12</td>\n",
       "      <td>1.417355e+12</td>\n",
       "      <td>1.380216e+12</td>\n",
       "      <td>1.357139e+12</td>\n",
       "      <td>1.375605e+12</td>\n",
       "      <td>1.419821e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>United Kingdom</th>\n",
       "      <td>4.0</td>\n",
       "      <td>20944.0</td>\n",
       "      <td>20357.0</td>\n",
       "      <td>206091.0</td>\n",
       "      <td>37874.0</td>\n",
       "      <td>9.84</td>\n",
       "      <td>139.0</td>\n",
       "      <td>7.920000e+09</td>\n",
       "      <td>124.0</td>\n",
       "      <td>10.600470</td>\n",
       "      <td>2.419631e+12</td>\n",
       "      <td>2.482203e+12</td>\n",
       "      <td>2.470614e+12</td>\n",
       "      <td>2.367048e+12</td>\n",
       "      <td>2.403504e+12</td>\n",
       "      <td>2.450911e+12</td>\n",
       "      <td>2.479809e+12</td>\n",
       "      <td>2.533370e+12</td>\n",
       "      <td>2.605643e+12</td>\n",
       "      <td>2.666333e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>United States</th>\n",
       "      <td>2.0</td>\n",
       "      <td>96661.0</td>\n",
       "      <td>94747.0</td>\n",
       "      <td>792274.0</td>\n",
       "      <td>265436.0</td>\n",
       "      <td>8.20</td>\n",
       "      <td>230.0</td>\n",
       "      <td>9.083800e+10</td>\n",
       "      <td>286.0</td>\n",
       "      <td>11.570980</td>\n",
       "      <td>1.479230e+13</td>\n",
       "      <td>1.505540e+13</td>\n",
       "      <td>1.501149e+13</td>\n",
       "      <td>1.459484e+13</td>\n",
       "      <td>1.496437e+13</td>\n",
       "      <td>1.520402e+13</td>\n",
       "      <td>1.554216e+13</td>\n",
       "      <td>1.577367e+13</td>\n",
       "      <td>1.615662e+13</td>\n",
       "      <td>1.654857e+13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Rank  Documents  Citable documents  Citations  \\\n",
       "Country                                                             \n",
       "Australia           14.0     8831.0             8725.0    90765.0   \n",
       "Brazil              15.0     8668.0             8596.0    60702.0   \n",
       "Canada               6.0    17899.0            17620.0   215003.0   \n",
       "China                1.0   127050.0           126767.0   597237.0   \n",
       "France               9.0    13153.0            12973.0   130632.0   \n",
       "Germany              7.0    17027.0            16831.0   140566.0   \n",
       "India                8.0    15005.0            14841.0   128763.0   \n",
       "Iran                13.0     8896.0             8819.0    57470.0   \n",
       "Italy               11.0    10964.0            10794.0   111850.0   \n",
       "Japan                3.0    30504.0            30287.0   223024.0   \n",
       "Russian Federation   5.0    18534.0            18301.0    34266.0   \n",
       "South Korea         10.0    11983.0            11923.0   114675.0   \n",
       "Spain               12.0     9428.0             9330.0   123336.0   \n",
       "United Kingdom       4.0    20944.0            20357.0   206091.0   \n",
       "United States        2.0    96661.0            94747.0   792274.0   \n",
       "\n",
       "                    Self-citations  Citations per document  H index  \\\n",
       "Country                                                               \n",
       "Australia                  15606.0                   10.28    107.0   \n",
       "Brazil                     14396.0                    7.00     86.0   \n",
       "Canada                     40930.0                   12.01    149.0   \n",
       "China                     411683.0                    4.70    138.0   \n",
       "France                     28601.0                    9.93    114.0   \n",
       "Germany                    27426.0                    8.26    126.0   \n",
       "India                      37209.0                    8.58    115.0   \n",
       "Iran                       19125.0                    6.46     72.0   \n",
       "Italy                      26661.0                   10.20    106.0   \n",
       "Japan                      61554.0                    7.31    134.0   \n",
       "Russian Federation         12422.0                    1.85     57.0   \n",
       "South Korea                22595.0                    9.57    104.0   \n",
       "Spain                      23964.0                   13.08    115.0   \n",
       "United Kingdom             37874.0                    9.84    139.0   \n",
       "United States             265436.0                    8.20    230.0   \n",
       "\n",
       "                    Energy Supply  Energy Supply per Capita  % Renewable  \\\n",
       "Country                                                                    \n",
       "Australia            5.386000e+09                     231.0    11.810810   \n",
       "Brazil               1.214900e+10                      59.0    69.648030   \n",
       "Canada               1.043100e+10                     296.0    61.945430   \n",
       "China                1.271910e+11                      93.0    19.754910   \n",
       "France               1.059700e+10                     166.0    17.020280   \n",
       "Germany              1.326100e+10                     165.0    17.901530   \n",
       "India                3.319500e+10                      26.0    14.969080   \n",
       "Iran                 9.172000e+09                     119.0     5.707721   \n",
       "Italy                6.530000e+09                     109.0    33.667230   \n",
       "Japan                1.898400e+10                     149.0    10.232820   \n",
       "Russian Federation   3.070900e+10                     214.0    17.288680   \n",
       "South Korea          1.100700e+10                     221.0     2.279353   \n",
       "Spain                4.923000e+09                     106.0    37.968590   \n",
       "United Kingdom       7.920000e+09                     124.0    10.600470   \n",
       "United States        9.083800e+10                     286.0    11.570980   \n",
       "\n",
       "                            2006          2007          2008          2009  \\\n",
       "Country                                                                      \n",
       "Australia           1.021939e+12  1.060340e+12  1.099644e+12  1.119654e+12   \n",
       "Brazil              1.845080e+12  1.957118e+12  2.056809e+12  2.054215e+12   \n",
       "Canada              1.564469e+12  1.596740e+12  1.612713e+12  1.565145e+12   \n",
       "China               3.992331e+12  4.559041e+12  4.997775e+12  5.459247e+12   \n",
       "France              2.607840e+12  2.669424e+12  2.674637e+12  2.595967e+12   \n",
       "Germany             3.332891e+12  3.441561e+12  3.478809e+12  3.283340e+12   \n",
       "India               1.265894e+12  1.374865e+12  1.428361e+12  1.549483e+12   \n",
       "Iran                3.895523e+11  4.250646e+11  4.289909e+11  4.389208e+11   \n",
       "Italy               2.202170e+12  2.234627e+12  2.211154e+12  2.089938e+12   \n",
       "Japan               5.496542e+12  5.617036e+12  5.558527e+12  5.251308e+12   \n",
       "Russian Federation  1.385793e+12  1.504071e+12  1.583004e+12  1.459199e+12   \n",
       "South Korea         9.410199e+11  9.924316e+11  1.020510e+12  1.027730e+12   \n",
       "Spain               1.414823e+12  1.468146e+12  1.484530e+12  1.431475e+12   \n",
       "United Kingdom      2.419631e+12  2.482203e+12  2.470614e+12  2.367048e+12   \n",
       "United States       1.479230e+13  1.505540e+13  1.501149e+13  1.459484e+13   \n",
       "\n",
       "                            2010          2011          2012          2013  \\\n",
       "Country                                                                      \n",
       "Australia           1.142251e+12  1.169431e+12  1.211913e+12  1.241484e+12   \n",
       "Brazil              2.208872e+12  2.295245e+12  2.339209e+12  2.409740e+12   \n",
       "Canada              1.613406e+12  1.664087e+12  1.693133e+12  1.730688e+12   \n",
       "China               6.039659e+12  6.612490e+12  7.124978e+12  7.672448e+12   \n",
       "France              2.646995e+12  2.702032e+12  2.706968e+12  2.722567e+12   \n",
       "Germany             3.417298e+12  3.542371e+12  3.556724e+12  3.567317e+12   \n",
       "India               1.708459e+12  1.821872e+12  1.924235e+12  2.051982e+12   \n",
       "Iran                4.677902e+11  4.853309e+11  4.532569e+11  4.445926e+11   \n",
       "Italy               2.125185e+12  2.137439e+12  2.077184e+12  2.040871e+12   \n",
       "Japan               5.498718e+12  5.473738e+12  5.569102e+12  5.644659e+12   \n",
       "Russian Federation  1.524917e+12  1.589943e+12  1.645876e+12  1.666934e+12   \n",
       "South Korea         1.094499e+12  1.134796e+12  1.160809e+12  1.194429e+12   \n",
       "Spain               1.431673e+12  1.417355e+12  1.380216e+12  1.357139e+12   \n",
       "United Kingdom      2.403504e+12  2.450911e+12  2.479809e+12  2.533370e+12   \n",
       "United States       1.496437e+13  1.520402e+13  1.554216e+13  1.577367e+13   \n",
       "\n",
       "                            2014          2015  \n",
       "Country                                         \n",
       "Australia           1.272520e+12  1.301251e+12  \n",
       "Brazil              2.412231e+12  2.319423e+12  \n",
       "Canada              1.773486e+12  1.792609e+12  \n",
       "China               8.230121e+12  8.797999e+12  \n",
       "France              2.729632e+12  2.761185e+12  \n",
       "Germany             3.624386e+12  3.685556e+12  \n",
       "India               2.200617e+12  2.367206e+12  \n",
       "Iran                4.639027e+11           NaN  \n",
       "Italy               2.033868e+12  2.049316e+12  \n",
       "Japan               5.642884e+12  5.669563e+12  \n",
       "Russian Federation  1.678709e+12  1.616149e+12  \n",
       "South Korea         1.234340e+12  1.266580e+12  \n",
       "Spain               1.375605e+12  1.419821e+12  \n",
       "United Kingdom      2.605643e+12  2.666333e+12  \n",
       "United States       1.615662e+13  1.654857e+13  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_one():\n",
    "    #Join files and rank data\n",
    "    first_merge = pd.merge(energy, GDP, how = 'outer', left_index = True, right_index = True)\n",
    "    result_df = pd.merge(ScimEm, first_merge, how = 'outer', left_index = True, right_index = True)\n",
    "    result_df = result_df.reset_index().dropna(thresh = result_df.shape[1]-10).set_index('Country')\n",
    "    result_df = result_df.loc[result_df['Rank'] <= 15]\n",
    "    return result_df\n",
    "answer_one()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Question 2 (6.6%)\n",
    "The previous question joined three datasets then reduced this to just the top 15 entries. When you joined the datasets, but before you reduced this to the top 15 items, how many entries did you lose?\n",
    "\n",
    "*This function should return a single number.*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<svg width=\"800\" height=\"300\">\n",
       "  <circle cx=\"150\" cy=\"180\" r=\"80\" fill-opacity=\"0.2\" stroke=\"black\" stroke-width=\"2\" fill=\"blue\" />\n",
       "  <circle cx=\"200\" cy=\"100\" r=\"80\" fill-opacity=\"0.2\" stroke=\"black\" stroke-width=\"2\" fill=\"red\" />\n",
       "  <circle cx=\"100\" cy=\"100\" r=\"80\" fill-opacity=\"0.2\" stroke=\"black\" stroke-width=\"2\" fill=\"green\" />\n",
       "  <line x1=\"150\" y1=\"125\" x2=\"300\" y2=\"150\" stroke=\"black\" stroke-width=\"2\" fill=\"black\" stroke-dasharray=\"5,3\"/>\n",
       "  <text  x=\"300\" y=\"165\" font-family=\"Verdana\" font-size=\"35\">Everything but this!</text>\n",
       "</svg>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "%%HTML\n",
    "<svg width=\"800\" height=\"300\">\n",
    "  <circle cx=\"150\" cy=\"180\" r=\"80\" fill-opacity=\"0.2\" stroke=\"black\" stroke-width=\"2\" fill=\"blue\" />\n",
    "  <circle cx=\"200\" cy=\"100\" r=\"80\" fill-opacity=\"0.2\" stroke=\"black\" stroke-width=\"2\" fill=\"red\" />\n",
    "  <circle cx=\"100\" cy=\"100\" r=\"80\" fill-opacity=\"0.2\" stroke=\"black\" stroke-width=\"2\" fill=\"green\" />\n",
    "  <line x1=\"150\" y1=\"125\" x2=\"300\" y2=\"150\" stroke=\"black\" stroke-width=\"2\" fill=\"black\" stroke-dasharray=\"5,3\"/>\n",
    "  <text  x=\"300\" y=\"165\" font-family=\"Verdana\" font-size=\"35\">Everything but this!</text>\n",
    "</svg>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "umich_part_id": "010",
    "umich_partlist_id": "003"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "156"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_two():\n",
    "    first_merge_union = pd.merge(energy, GDP, how = 'outer', left_index = True, right_index = True)\n",
    "    union = pd.merge(ScimEm, first_merge_union, how = 'outer', left_index = True, right_index = True)\n",
    "    first_merge_intersect = pd.merge(energy, GDP, how = 'inner', left_index = True, right_index = True)\n",
    "    intersect = pd.merge(ScimEm, first_merge_intersect, how = 'inner', left_index = True, right_index = True)\n",
    "    return len(union) - len(intersect)\n",
    "answer_two()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Answer the following questions in the context of only the top 15 countries by Scimagojr Rank (aka the DataFrame returned by `answer_one()`)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Question 3 (6.6%)\n",
    "What is the average GDP over the last 10 years for each country? (exclude missing values from this calculation.)\n",
    "\n",
    "*This function should return a Series named `avgGDP` with 15 countries and their average GDP sorted in descending order.*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "scrolled": true,
    "umich_part_id": "011",
    "umich_partlist_id": "003"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Country\n",
       "United States         1.536434e+13\n",
       "China                 6.348609e+12\n",
       "Japan                 5.542208e+12\n",
       "Germany               3.493025e+12\n",
       "France                2.681725e+12\n",
       "United Kingdom        2.487907e+12\n",
       "Brazil                2.189794e+12\n",
       "Italy                 2.120175e+12\n",
       "India                 1.769297e+12\n",
       "Canada                1.660647e+12\n",
       "Russian Federation    1.565459e+12\n",
       "Spain                 1.418078e+12\n",
       "Australia             1.164043e+12\n",
       "South Korea           1.106715e+12\n",
       "Iran                  4.441558e+11\n",
       "Name: avg_GDP, dtype: float64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_three():\n",
    "    Top15 = answer_one()\n",
    "    GDP_years = np.arange(2006, 2016).astype(str)\n",
    "    Top15['avg_GDP'] = Top15[GDP_years].mean(axis = 1)\n",
    "    return Top15['avg_GDP'].sort_values(ascending = False)\n",
    "answer_three()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Question 4 (6.6%)\n",
    "By how much had the GDP changed over the 10 year span for the country with the 6th largest average GDP?\n",
    "\n",
    "*This function should return a single number.*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "scrolled": true,
    "umich_part_id": "012",
    "umich_partlist_id": "003"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "246702696075.3999"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_four():\n",
    "    Top15 = answer_one()\n",
    "    GDP_years = np.arange(2006, 2016).astype(str)\n",
    "    Top15['avg_GDP'] = Top15[GDP_years].mean(axis = 1)\n",
    "    Top15 = Top15.sort_values(['avg_GDP'], ascending = False)\n",
    "    Top15['Change_GDP'] = Top15['2015'] - Top15['2006']\n",
    "    Top15 = Top15.reset_index()\n",
    "    return Top15.loc[5, 'Change_GDP']\n",
    "answer_four()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Question 5 (6.6%)\n",
    "What is the mean `Energy Supply per Capita`?\n",
    "\n",
    "*This function should return a single number.*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "umich_part_id": "013",
    "umich_partlist_id": "003"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "157.6"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_five():\n",
    "    Top15 = answer_one()\n",
    "    result = Top15['Energy Supply per Capita'].mean(axis = 0)\n",
    "    return result\n",
    "answer_five()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Question 6 (6.6%)\n",
    "What country has the maximum % Renewable and what is the percentage?\n",
    "\n",
    "*This function should return a tuple with the name of the country and the percentage.*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "umich_part_id": "014",
    "umich_partlist_id": "003"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "('Brazil', 69.648030000000006)"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_six():\n",
    "    Top15 = answer_one()\n",
    "    result = Top15['% Renewable'].argmax()\n",
    "    return result, Top15['% Renewable'].max()\n",
    "answer_six()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Question 7 (6.6%)\n",
    "Create a new column that is the ratio of Self-Citations to Total Citations. \n",
    "What is the maximum value for this new column, and what country has the highest ratio?\n",
    "\n",
    "*This function should return a tuple with the name of the country and the ratio.*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "umich_part_id": "015",
    "umich_partlist_id": "003"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "('China', 0.68931261793894216)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_seven():\n",
    "    Top15 = answer_one()\n",
    "    Top15['Ratio citations'] = Top15['Self-citations'] / Top15['Citations']\n",
    "    result = Top15['Ratio citations'].argmax()\n",
    "    return result, Top15['Ratio citations'].max()\n",
    "answer_seven()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Question 8 (6.6%)\n",
    "\n",
    "Create a column that estimates the population using Energy Supply and Energy Supply per capita. \n",
    "What is the third most populous country according to this estimate?\n",
    "\n",
    "*This function should return a single string value.*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "umich_part_id": "016",
    "umich_partlist_id": "003"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'United States'"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_eight():\n",
    "    Top15 = answer_one()\n",
    "    Top15['Population'] = Top15['Energy Supply'] / Top15['Energy Supply per Capita']\n",
    "    Top15 = Top15.sort_values(['Population'], ascending = False)\n",
    "    Top15 = Top15.reset_index()\n",
    "    result = Top15.loc[2, 'Country']\n",
    "    return result\n",
    "answer_eight()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Question 9 (6.6%)\n",
    "Create a column that estimates the number of citable documents per person. \n",
    "What is the correlation between the number of citable documents per capita and the energy supply per capita? Use the `.corr()` method, (Pearson's correlation).\n",
    "\n",
    "*This function should return a single number.*\n",
    "\n",
    "*(Optional: Use the built-in function `plot9()` to visualize the relationship between Energy Supply per Capita vs. Citable docs per Capita)*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "umich_part_id": "017",
    "umich_partlist_id": "003"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.79400104354429446"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_nine():\n",
    "    import numpy as np\n",
    "    Top15 = answer_one()\n",
    "    Top15['Population'] = Top15['Energy Supply'] / Top15['Energy Supply per Capita']\n",
    "    Top15['Citable Documents per Capita'] = Top15['Citable documents'] / Top15['Population']\n",
    "    result = Top15['Citable Documents per Capita'].corr(Top15['Energy Supply per Capita'])\n",
    "    return result\n",
    "answer_nine()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZYAAAEKCAYAAAAxXHOuAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzt3XucXVV99/HPd5JxEkmEMIlpSIKBh0sNNkQcEYptFYsi\nakBjMWoVLBZpqbdHS0CfR1G85nnUR2rBB6s2KsrFgESrUoggXhBMMBkIiEYuzcRI4hggA8k4yfn1\nj70GToa57Ez2PmfOme/79Tqv2Wfty/mtM0l+2WvttZYiAjMzs6K01DsAMzNrLk4sZmZWKCcWMzMr\nlBOLmZkVyonFzMwK5cRiZmaFcmIxM7NCObGYmVmhnFjMzKxQE+sdwL6YPn16zJs3r95hmJk1lDVr\n1vw+ImaUdf2GTizz5s1j9erV9Q7DzKyhSHqwzOu7KczMzArlxGJmZoUqLbFImiTpdknrJK2X9KFU\nfqCkGyT9Ov2cVnXOBZI2SLpX0svKis3MzMpT5h1LL3BiRBwNLAROlnQccD6wKiIOB1al90iaDywB\njgJOBi6RNKHE+MzMrASlJZbI9KS3rekVwKnA8lS+HDgtbZ8KXBERvRFxP7ABOLas+MzMrByl9rFI\nmiBpLbAFuCEibgNmRsTmdMjvgJlpezawser0rlQ28JpnS1otafXWrVtLjN7MxqPunl7WbXyY7p7e\neofSsEp93DgidgMLJR0AXCvpOQP2h6S9WsIyIi4DLgPo6Ojw8pdmVpjr1m5i6YpOWlta6KtUWLZ4\nAYsWPuX/tzaCmjwVFhEPAzeR9Z08JGkWQPq5JR22CZhbddqcVGZmVrrunl6WruhkZ1+F7b272NlX\n4bwVnb5zGYUynwqbke5UkDQZOAn4JbASOCMddgZwXdpeCSyR1CbpEOBw4Pay4jMzq9a1bQetLXv+\nk9ja0kLXth11iqhxldkUNgtYnp7sagGuiojvSLoVuErSWcCDwOkAEbFe0lXA3cAu4NzUlGZmVro5\n0ybTV6nsUdZXqTBn2uQ6RdS4FNG43RQdHR3hKV3MrCgr127ivHHQxyJpTUR0lHX9hp4rzMysSIsW\nzuaEw6bTtW0Hc6ZNpn1KW71DakhOLGZmVdqntDmh7CPPFWZWMI+DsPHOdyxmBfI4CDPfsZgVxuMg\nzDJOLGYF8TgIs4wTi1lBPA7CLOPEYlaQ9iltLFu8gEmtLUxtm8ik1haWLV7gJ4xs3HHnvVmBPA7C\nzInFrHAeB2HjnZvCzMysUE4sZmZWKCcWMzMrlBOLmZkVyonFzMwK5cRiZmaFcmIxM7NCObGYmVmh\nnFjMzKxQTixmZlYoJxYzMyuUE4uZmRXKicXMzArlxGJmZoVyYjEzs0I5sZiZWaGcWMzMrFClJRZJ\ncyXdJOluSeslvTOVXyhpk6S16XVK1TkXSNog6V5JLysrNjMzK0+ZSxPvAt4TEXdImgqskXRD2veZ\niPi/1QdLmg8sAY4CDgJulHREROwuMUYzMytYaXcsEbE5Iu5I29uBe4DZw5xyKnBFRPRGxP3ABuDY\nsuIzM7Ny1KSPRdI84LnAbano7ZI6JX1J0rRUNhvYWHVaF8MnIjMzG4NKTyySpgArgHdFxKPApcCh\nwEJgM/Cpvbze2ZJWS1q9devWwuM1M7N9U2pikdRKllQuj4hrACLioYjYHREV4As82dy1CZhbdfqc\nVLaHiLgsIjoiomPGjBllhm9mZqNQ5lNhAr4I3BMRn64qn1V12KuBu9L2SmCJpDZJhwCHA7eXFZ+Z\nmZUj91Nhkp4JTOp/HxH/NcIpJwBvAu6UtDaVvQ94vaSFQAAPAG9L11sv6SrgbrInys71E2FmZo1n\nxMQiaRFZP8hBwBbgWWRPeB013HkR8WNAg+z67jDnfBT46EgxmZnZ2JWnKewi4DjgVxFxCPAS4Gel\nRmVmZg0rT2Lpi4huoEVSS0TcBHSUHJeZmTWoPH0sD6dHhm8BLpe0BXis3LDMzKxR5bljORV4HHg3\n8H3gN8ArywzKzMwaV57E8oGIqETErohYHhEXA0vLDszMzBpTnsRy0iBlLy86EDMzaw5D9rFI+gfg\nH4FDJXVW7ZoK/KTswMysXN09vXRt28GcaZNpn9JW73CsiQzXef914HvAx4Hzq8q3R8QfSo3KzEp1\n3dpNLF3RSWtLC32VCssWL2DRQs/5asUYriksIuIB4Fxge9ULSQeWH5qZlaG7p5elKzrZ2Vdhe+8u\ndvZVOG9FJ909vfUOzZrESHcsrwTWkE2/Uj2KPshmKDazBtO1bQetLS3spPJEWWtLC13bdrhJzAox\nZGKJiFemn4fULhwzK9ucaZPpq1T2KOurVJgzbXKdIrJmk2t2Y0mvkfRpSZ+SdFrZQZlZedqntLFs\n8QImtbYwtW0ik1pbWLZ4ge9WrDB5JqG8BDgM+EYqOkfSSRFxbqmRmVlpFi2czQmHTfdTYVaKPFO6\nnAg8OyICQNJyYH2pUZmNkh+hza99Spu/IytFnsSyATgYeDC9n5vKzMYUP0JrNjbk6WOZCtwj6WZJ\nN5EtxPUMSSslrSw3PLN8/Ait2diR547lA6VHYbaP/Ait2dgxYmKJiB/WIhCzfeFHaM3GjhGbwiQd\nJ+nnknok/VHSbkmP1iI4G53unl7WbXx4XDUD+RFas7EjT1PY54AlwNVkK0e+GTiizKBs9MZzB7Yf\noTUbG3INkIyIDcCEiNgdEV8GTi43LBsNd2Bndy5Hzz3AScWsjvLcsTwu6WnAWknLgM3kTEhWW+7A\nNrOxIE+CeFM67p/I1rqfCywuMygbHXdgm9lYMGRikTRD0vyIeDAidkbEoxHxIeCLwCO1C9Hycge2\nmY0FwzWF/QtwySDlBwLvB95QSkS2T9yBbWb1NlxiOSwibhlYGBE/knRpiTHZPvIcUGZWT8P1sUwd\nZl9r0YGYmVlzGC6xbJB0ysBCSS8H7isvJDMza2TDNYW9C/gPSaeTLU8M2QDJ48mWLB6WpLnAV4CZ\nZEsZXxYRn5V0IHAlMA94ADg9Iralcy4AzgJ2A++IiOtHUSczM6ujIe9YIuLXwJ8BPyRLAvPS9oKI\n+FWOa+8C3hMR84HjgHMlzQfOB1ZFxOHAqvSetG8JcBTZAMxLJE0YXbXMzKxehh0gGRG9wJdHc+GI\n2Ew2mJKI2C7pHmA2cCrwonTYcuBmYGkqvyJ95v2SNgDHAreO5vPNzKw+ajKCXtI84LnAbcDMlHQA\nfkfWVAZZ0tlYdVpXKjMzswZSemKRNAVYAbwrIvaYFTktdxx7eb2zJa2WtHrr1q0FRmpmZkUYNrFI\nmiDp8tFeXFIrWVK5PCKuScUPSZqV9s8CtqTyTWTTxfSbk8r2EBGXRURHRHTMmDFjtKGZmVlJhk0s\nEbEbeFaahHKvSBLZ9C/3RMSnq3atBM5I22cA11WVL5HUJukQ4HDg9r39XDMzq688sxvfB/wkrW//\nWH/hgGQxmBPIJrC8U9LaVPY+4BPAVZLOAh4ETk/XWy/pKuBusifKzk2JzczMGkiexPKb9Gph+NH4\ne4iIHwMaYvdLhjjno8BH836GmZmNPXnWvP8QgKSnR8Tj5YdkZmaNLM+a98dLuhv4ZXp/tKTBZj02\nMzPL9bjx/wNeBnQDRMQ64C/LDMrMzBpX3jXvNw4ocqe6mZkNKk/n/UZJfw5EGpfyTuCecsMyM7NG\nleeO5RzgXLLpVX4LLEzvzczMniLPU2G/B95Yg1jMzKwJ5Hkq7FBJ35a0VdIWSddJOrQWwZmZWePJ\n0xT2deAqYBZwEHA18I0ygzIzs8aVJ7E8PSK+GhG70utrwKSyAzMzs8aU56mw70k6H7iCbIr71wHf\nTUsMExF/KDE+MzNrMHkSy+np59sGlC8hSzTubzEzsyfkeSrskFoEYmZmzaEmSxObmdn44cRiZmaF\ncmIxM7NC5RkgeY2kV0hyErLCdff0sm7jw3T39NY7FDMrSJ6nwi4B3gJcLOlq4MsRcW+5Ydl4cN3a\nTSxd0UlrSwt9lQr/+xXzec7s/ZkzbTLtU9rqHZ6ZjVKep8JuBG6UtD/w+rS9EfgC8LWI6Cs5RmtC\n3T29LF3Ryc6+CjupAPD+b93FlLYJ7KoEyxYvYNHC2XWO0sxGI1fzlqR24EzgrcAvgM8CxwA3lBaZ\nNbWubTtobXnqH7+e3t3s7Ktw3opON4+ZNagR71gkXQscCXwVeFVEbE67rpS0uszgrHnNmTaZvkpl\nyP2tLS10bdvhJjGzBpTnjuXiiJgfER+vSioARERHSXFZk2uf0sayxQuY1NrCfk+b8JT9fZUKc6ZN\nrkNkZravhrxjkfSawbb7RcQ1ZQVl48OihbM54bDpdG3bwV2/fYSLvnP3Ex35yxYv8N2KWYMarins\nVcPsC8CJxfZZ+5Q22qe0cfTcAzj5qD+ha9sOPxVm1uCGTCwR8ZZaBmLWn2TMrLHlGSDZLuliSXdI\nWiPps+kpMTMzs6fI03l/BbAVWAy8Nm1fWWZQZmbWuPIkllkRcVFE3J9eHwFmjnSSpC9J2iLprqqy\nCyVtkrQ2vU6p2neBpA2S7pX0stFVx8zM6i1PYvlPSUsktaTX6cD1Oc77d+DkQco/ExEL0+u7AJLm\nky0cdlQ65xJJT30G1czMxrw8ieXvga8Df0yvK4C3Sdou6dGhToqIW4C8yxafClwREb0RcT+wATg2\n57lmgCe0NBsr8swVNrXgz3y7pDcDq4H3RMQ2YDbws6pjulKZWS4DJ7T0XGNm9ZN3rrDXSPq0pE9J\nOm0fPu9S4FBgIbAZ+NTeXkDS2ZJWS1q9devWfQjFmkX1hJbbe3d5rjGzOsvzuPElwDnAncBdwDmS\n/nU0HxYRD0XE7oiokM2O3N/ctQmYW3XonFQ22DUui4iOiOiYMWPGaMKwJjPYhJb9c42ZWe3lWY/l\nRODZEREAkpYD60fzYZJmVc039mqyRAWwEvi6pE8DBwGHA7eP5jNs/BlsQkvPNWZWP3mawjYAB1e9\nn5vKhiXpG8CtwJGSuiSdBSyTdKekTuDFwLsBImI9cBVwN/B94NyI2L1XNbFxq3pCy6ltE5nU2uK5\nxszqSOlGZOgDpB8Czye7gwiy5qvVwCMAEbGo5BiH1NHREatXe+Z+y3T39HquMbMcJK0pc3b6PE1h\nHyjrw82K5LnGzMaGPI8b/7AWgZiZWXPIs4LkdrImMICnAa3AYxHxjDIDMzOzxrRXAyQliWyU/HFl\nBmVmZo0r1wDJfpH5FuBJIs3MbFB5msKqlyVuATqAnaVFZGZmDS3PU2HVSxTvAh4gaw4zMzN7ijx9\nLF6i2MzMchuyj0XS30s6PG0rLdz1iKROScfULkQzM2skw3Xev5Os2Qvg9cDRZDMT/0/gs+WGZWZm\njWq4xLIrIvrS9iuBr0REd0TcCOxXfmhmZtaIhkssFUmzJE0CXgLcWLXP08aaFcCrXlozGq7z/gNk\nk01OAFamGYiR9FfAfTWIzaypedVLa1ZDJpaI+I6kZwFT0/LB/VYDrys9MrMmVr3q5U6ytWTOW9HJ\nCYdN90Sa1vCGHXkfEbsGJBUi4rGI6Ck3LLPm5lUvrZnt1ZQuNna4bb6xedVLa2Z5Rt7bGOO2+cbX\nv+rleQN+j24Gs2aQZ66wa4AvAt+LiMpIx1u53DbfPBYtnM0Jh033qpfWdPI0hV0CvAH4taRPSDqy\n5JhsGG6bby7tU9o4eu4BTirWVEZMLBFxY0S8ETiGbCT+jZJ+KuktklrLDtD25LZ5MxvrcnXeS2oH\nzgTeCvyCbEqXY4AbSovMBtXfNj+ptYWpbROZ1NritnkzG1Py9LFcCxwJfBV4VURsTruulLS6zOBs\ncG6bN7OxLM9TYRdHxE2D7YiIjoLjsZzap7SNuYTS3dPrZGdmuRLLtAGrSAI8AtwZEVtKiMkakB+B\nNrN+eRLLWcDxQP9dy4uANcAhkj4cEV8tKTZrEKN5BNp3N2bNK09iaQWeHREPAUiaCXwFeAFwC1nf\ni41j/Y9A9ycVePIR6MGShu9uzJpbnqfC5vQnlWQLMDci/gD0DXGOjSN78wh09d3N9t5d7OyrcN6K\nTk9NY9ZE8iSWmyV9R9IZks4Arktl+wEPlxueNYK9eQTaAzzNml+eprBzgdcAL0zvvwKsiIgAXjzU\nSZK+RLby5JaIeE4qOxC4EphHNtjy9P7ZkyVdQNafsxt4R0RcP4r6WJ3kfQTaAzzNmt+wdyySJgA/\niIgVEfHu9PpmSioj+Xfg5AFl5wOrIuJwYFV6j6T5wBLgqHTOJemzrYHkmZ7EAzzNmt+wdywRsVtS\nRdL+EfHI3lw4Im6RNG9A8alkT5UBLAduBpam8isiohe4X9IG4Fjg1r35TGsMHuBp1tzyNIX1AHdK\nugF4rL8wIt4xis+bWTVy/3fAzLQ9G/hZ1XFdqcya1Fgc4GlmxciTWK5Jr0JFREjK06S2B0lnA2cD\nHHzwwUWHZWZm+2jExBIRyyVNBg6OiHv38fMekjQrIjZLmkX26DLAJmBu1XFzUtlg8VwGXAbQ0dGx\n14nJzMzKNeLjxpJeBawFvp/eL5S0cpSftxI4I233P7rcX75EUpukQ4DDgdtH+RkNyUsNm1mzyNMU\ndiFZR/rNABGxVtKhI50k6RtkHfXTJXUBHwQ+AVwl6SzgQeD0dM31kq4C7gZ2AedGxO69rUyj8kh0\nM2smeRJLX0Q8Iqm6bMQliiPi9UPseskQx38U+GiOeJqKlxo2s2aTZ+T9eklvACZIOlzSvwA/LTmu\nccMj0c2s2eRJLG8nG7jYC3wDeBR4V5lBjSceiW5mzSbPmvePR8T7I+L5EdGRtnfWIrjxwCPRzazZ\n5Fma+AjgvWTzez1xfEScWF5Y44tHoptZM8nTeX818Hng38gmiLQSeCS6mTWLPIllV0RcWnokZmbW\nFPJ03n9b0j9KmiXpwP5X6ZGZmVlDynPH0j9S/p+rygIYcZCkmZmNP3nmCjukFoGYmVlzGLIpTNJ5\nVdt/M2Dfx8oMyszMGtdwfSxLqrYvGLBv4MqQZmZmwPCJRUNsD/bezMwMGD6xxBDbg703MzMDhu+8\nP1rSo2R3J5PTNun9pNIjMzOzhjRkYomICbUMxMzMmkOeAZJmZma5ObGYmVmhnFjMzKxQTixmZlYo\nJxYzMyuUE4uZmRXKicXMzArlxDKE7p5e1m18mO6e3nqHYmbWUPKsxzLuXLd2E0tXdNLa0kJfpcKy\nxQtYtHB2vcMyM2sIvmMZoLunl6UrOtnZV2F77y529lU4b0Wn71zMzHJyYhmga9sOWlv2/FpaW1ro\n2rajThGZmTUWJ5YB5kybTF+lskdZX6XCnGmT6xSRmVljcWIZoH1KG8sWL2BSawtT2yYyqbWFZYsX\n0D6lrd6hmZk1hLp03kt6ANgO7AZ2RUSHpAOBK4F5wAPA6RGxrR7xLVo4mxMOm07Xth3MmTbZScXM\nbC/U847lxRGxMCI60vvzgVURcTiwKr2vm/YpbRw99wAnFTOzvTSWmsJOBZan7eXAaXWMxczMRqle\niSWAGyWtkXR2KpsZEZvT9u+AmYOdKOlsSaslrd66dWstYjUzs71QrwGSL4yITZKeCdwg6ZfVOyMi\nJMVgJ0bEZcBlAB0dHYMeY2Zm9VOXO5aI2JR+bgGuBY4FHpI0CyD93FKP2MzMbN/UPLFI2k/S1P5t\n4KXAXcBK4Ix02BnAdbWOzczM9l09msJmAtdK6v/8r0fE9yX9HLhK0lnAg8DpdYjNzMz2Uc0TS0Tc\nBxw9SHk38JJax2NmZsUaS48bm5lZE3BiMTOzQjmxmJlZoZxYzMysUE4sZmZWKCcWMzMrlBOLmZkV\nyonFzMwK5cRiZmaFasrE0t3Ty7qND9Pd01vvUMzMxp16TZtfmuvWbmLpik5aW1roq1RYtngBixbO\nrndYZmbjRlPdsXT39LJ0RSc7+yps793Fzr4K563o9J2LmVkNNVVi6dq2g9aWPavU2tJC17YddYrI\nzGz8aarEMmfaZPoqlT3K+ioV5kybXKeIzMzGn6ZKLO1T2li2eAGTWluY2jaRSa0tLFu8gPYpbfUO\nzcxs3Gi6zvtFC2dzwmHT6dq2gznTJjupmJnVWNMlFsjuXJxQzMzqo6mawszMrP6cWMzMrFBOLGZm\nVignFjMzK5QTi5mZFUoRUe8YRk3SduDeesdRounA7+sdRIlcv8bWzPVr5roBHBkRU8u6eKM/bnxv\nRHTUO4iySFrt+jUu169xNXPdIKtfmdd3U5iZmRXKicXMzArV6InlsnoHUDLXr7G5fo2rmesGJdev\noTvvzcxs7Gn0OxYzMxtj6ppYJJ0s6V5JGySdP8h+Sbo47e+UdMxI50o6UNINkn6dfk6r2ndBOv5e\nSS9rpvpJapd0k6QeSZ8ru251qN9JktZIujP9PLHJ6nespLXptU7Sq5upflX7D05/Rt/bLHWTNE/S\njqrf3+fLrFut65f2LZB0q6T16e/gpGEDjIi6vIAJwG+AQ4GnAeuA+QOOOQX4HiDgOOC2kc4FlgHn\np+3zgU+m7fnpuDbgkHT+hCaq337AC4FzgM814e/vucBBafs5wKYmq9/TgYlpexawpf99M9Sv6prf\nBK4G3tssdQPmAXeV/XeujvWbCHQCR6f37Yzwb2c971iOBTZExH0R8UfgCuDUAcecCnwlMj8DDpA0\na4RzTwWWp+3lwGlV5VdERG9E3A9sSNcpS03rFxGPRcSPgZ0l1qlarev3i4j4bSpfD0yWVObaCLWu\n3+MRsSuVTwLK7vys9d8/JJ0G3E/2+ytTzetWY7Wu30uBzohYBxAR3RGxe7gA65lYZgMbq953pbI8\nxwx37syI2Jy2fwfM3IvPK1Kt61dr9azfYuCOiOgdXei51Lx+kl4gaT1wJ3BOVaIpQ03rJ2kKsBT4\nUBHBj6AefzYPSc1gP5T0F/sY/0hqXb8jgJB0vaQ7JJ03UoCNPvJ+WBERkpr2sbfxWD9JRwGfJPtf\nVEMbWL+IuA04StKzgeWSvhcRtboDLdyA+l0IfCYieiTVMapiDKjbZuDgiOiW9DzgW5KOiohH6xji\nPhlQv4lkzezPBx4HVklaExGrhjq/nncsm4C5Ve/npLI8xwx37kPplo/0c8tefF6Ral2/Wqt5/STN\nAa4F3hwRvymgDsOp2+8vIu4Besj6kspS6/q9AFgm6QHgXcD7JP3TvldjUDWtW2pe707ba8j6MI4o\npCaDq/Xvrgu4JSJ+HxGPA98FjmE4w3XAlPkiy4L3kXWk93ciHTXgmFewZwfU7SOdC/wf9uyAWpa2\nj2LPzvv7KLfzvqb1q7rmmdSm877Wv78D0nGvadI/n4fwZOf9s4DfAtObpX4Drnsh5Xbe1/p3N4P0\nbwlZp/gm4MAmqt804A7SAybAjcArho2xrMrn/IJOAX5FluHfn8rOIWtfJn0p/5r23wl0DHduKm8H\nVgG/Tl/AgVX73p+Ovxd4eRPW7wHgD2T/2+1iwJMijVw/4H8BjwFrq17PbKL6vYmsU3tt+kt8WrP9\n+aw65kJKTCx1+N0tHvC7e1Wz/e6Av011vItB/rMw8OWR92ZmViiPvDczs0I5sZiZWaGcWMzMrFBO\nLGZmVignFjMzK5QTi9WFpD+RdIWk3yibrfi7ko6QdJCkb6ZjFko6Jce1ztQQMzpL6tmHGIe87lgz\n1Pc5ymv9m6T5aft9xUZq44ETi9Wcsjk9rgVujoj/ERHPAy4gm6votxHx2nToQrJn7q2KpIkD3g/5\nfY7m+hHx1oi4O711YrG95sRi9fBioC8inli3IiLWRcSP0toWd0l6GvBh4HVpcr/XKVuz5FZJv5D0\nU0lHVl1zrqSb01oSHxzsQyX9s6Sfp/UpBp0MUdJbJP1K0u3ACVXl8yT9IJ27StLBqXympGuVraGy\nTtKfS9pP0n+k93dJet0gn3OzpM+mut0l6dhUvp+kL0m6PdXz1FR+pqSVkn5ANogt7/c5JcV7h7J1\nNPqvN0/SLyVdLukeSd+U9PSq2DokfYJsFum1ki5P+76V7ojWSzp70N+uWdkjRP3ya+ALeAfZhISD\n7ZtHWtuCAdPTAM/gyWlP/hpYUXXcZrKRw5PJRgd3pH096edLydb5Ftl/qL4D/OWAz54F/BfZFB1P\nA37S//nAt4Ez0vbfAd9K21cC70rbE4D9yUZif6HquvsPUs+b+48B/rKqzh8D/jZtH0A2Qnq/VMcu\nBh/JPtz3ORF4RtqeTrZchNL3HMAJad+XSKPhU2x7fH9V1+sfbd7/PbfX+8+TX2Pv5TsWayT7A1dL\nugv4DNn8b/1uiGydiB3ANWSzsVZ7aXr9gmzajT8FDh9wzAvImpO2RrZWxZVV+44Hvp62v1p1/ROB\nSwEiYndEPEI2hcZJkj4p6S9S2WC+kc67BXiGpANSjOdLWkv2D/wk4OCqOv5hiGsNRcDHJHWSTdMx\nmyebyDZGxE/S9td46nc2mHdIWgf8jGwyw4HfoVlzT5tvY9Z64LUjHvVUFwE3RcSrJc0j+4e338C5\niQa+F/DxiPj/o/jcvRIRv1K2FOwpwEckrYqIDw926CDvBSyOiHurd0h6AdlcaYMZ7vt8I9kd2PMi\noi/NLty/rOxI39keJL2I7E7x+Ih4XNLNVdcye4LvWKwefgC0VbfRK1tTe+ACSduBqVXv9+fJKb7P\nHHDsScrW7J5MtvLdTwbsvx74O2ULTiFptqRnDjjmNuCvJLVLagX+pmrfT4ElafuNwI/S9irgH9I1\nJ0jaX9JBwOMR8TWyGWOHmmL8dem8FwKPpDub64G3pw55JD13iHOrDfd97g9sSUnlxWQzJ/c7WNLx\nafsNwI8HuXZf+i5I19qWksqfks2aa/YUTixWcxERwKuBv06Px64HPk62al21m4D5/Z33ZGtyf1zS\nL3jq3fbtwAqytblXRMTqAZ/5n2RNWbdKupNs7fWpA47ZTDbz7q1kiemeqt1vB96SmpTeBLwzlb8T\neHG65hpgPvBnwO2pOeuDwEeG+Cp2prp8HjgrlV0EtAKd6Xu5aIhzq+Me7vu8HOhI8b0Z+GXVqfcC\n50q6h2xq9EsHufxlKZbLge8DE9PxnyBrDjN7Cs9ubFYHqRnpvQMTYA0/fx7wnYgoczExG6d8x2Jm\nZoXyHYuGnANCAAAALUlEQVSZmRXKdyxmZlYoJxYzMyuUE4uZmRXKicXMzArlxGJmZoVyYjEzs0L9\nN9CcEb+WeNHxAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7f58535406a0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#def plot9():\n",
    "#    import matplotlib as plt\n",
    "#    %matplotlib inline\n",
    "    \n",
    "#    Top15 = answer_one()\n",
    "#    Top15['Population'] = Top15['Energy Supply'] / Top15['Energy Supply per Capita']\n",
    "#    Top15['Citable docs per Capita'] = Top15['Citable documents'] / Top15['Population']\n",
    "#    Top15.plot(x='Citable docs per Capita', y='Energy Supply per Capita', kind='scatter', xlim=[0, 0.0006])\n",
    "#plot9()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#There seems to be certain correlation between the per capita numbers of citable docs and the energy supply, meaning that the higher the number of citable docs per capita, the higher the energy supply per capita. However, we must understand that correlation does not imply causationl "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Question 10 (6.6%)\n",
    "Create a new column with a 1 if the country's % Renewable value is at or above the median for all countries in the top 15, and a 0 if the country's % Renewable value is below the median.\n",
    "\n",
    "*This function should return a series named `HighRenew` whose index is the country name sorted in ascending order of rank.*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "umich_part_id": "018",
    "umich_partlist_id": "003"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Country\n",
       "Brazil                1\n",
       "Canada                1\n",
       "China                 1\n",
       "France                1\n",
       "Germany               1\n",
       "Italy                 1\n",
       "Russian Federation    1\n",
       "Spain                 1\n",
       "Australia             0\n",
       "India                 0\n",
       "Iran                  0\n",
       "Japan                 0\n",
       "South Korea           0\n",
       "United Kingdom        0\n",
       "United States         0\n",
       "Name: HighRenew, dtype: int64"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_ten():\n",
    "    Top15 = answer_one()\n",
    "#    Median = Top15['% Renewable'].median(axis = 0)\n",
    "    Top15['HighRenew'] = [1 if x >= Top15['% Renewable'].median(axis = 0) else 0 for x in Top15['% Renewable']]\n",
    "    Top15 = Top15.sort_values(['HighRenew'], ascending = False)\n",
    "    return Top15['HighRenew']\n",
    "answer_ten()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Question 11 (6.6%)\n",
    "Use the following dictionary to group the Countries by Continent, then create a dateframe that displays the sample size (the number of countries in each continent bin), and the sum, mean, and std deviation for the estimated population of each country.\n",
    "\n",
    "```python\n",
    "ContinentDict  = {'China':'Asia', \n",
    "                  'United States':'North America', \n",
    "                  'Japan':'Asia', \n",
    "                  'United Kingdom':'Europe', \n",
    "                  'Russian Federation':'Europe', \n",
    "                  'Canada':'North America', \n",
    "                  'Germany':'Europe', \n",
    "                  'India':'Asia',\n",
    "                  'France':'Europe', \n",
    "                  'South Korea':'Asia', \n",
    "                  'Italy':'Europe', \n",
    "                  'Spain':'Europe', \n",
    "                  'Iran':'Asia',\n",
    "                  'Australia':'Australia', \n",
    "                  'Brazil':'South America'}\n",
    "```\n",
    "\n",
    "*This function should return a DataFrame with index named Continent `['Asia', 'Australia', 'Europe', 'North America', 'South America']` and columns `['size', 'sum', 'mean', 'std']`*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "umich_part_id": "019",
    "umich_partlist_id": "003"
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Size</th>\n",
       "      <th>Sum</th>\n",
       "      <th>Mean</th>\n",
       "      <th>Std</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Continent</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Asia</th>\n",
       "      <td>5.0</td>\n",
       "      <td>2.898666e+09</td>\n",
       "      <td>5.797333e+08</td>\n",
       "      <td>6.790979e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Australia</th>\n",
       "      <td>1.0</td>\n",
       "      <td>2.331602e+07</td>\n",
       "      <td>2.331602e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Europe</th>\n",
       "      <td>6.0</td>\n",
       "      <td>4.579297e+08</td>\n",
       "      <td>7.632161e+07</td>\n",
       "      <td>3.464767e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>North America</th>\n",
       "      <td>2.0</td>\n",
       "      <td>3.528552e+08</td>\n",
       "      <td>1.764276e+08</td>\n",
       "      <td>1.996696e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>South America</th>\n",
       "      <td>1.0</td>\n",
       "      <td>2.059153e+08</td>\n",
       "      <td>2.059153e+08</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               Size           Sum          Mean           Std\n",
       "Continent                                                    \n",
       "Asia            5.0  2.898666e+09  5.797333e+08  6.790979e+08\n",
       "Australia       1.0  2.331602e+07  2.331602e+07           NaN\n",
       "Europe          6.0  4.579297e+08  7.632161e+07  3.464767e+07\n",
       "North America   2.0  3.528552e+08  1.764276e+08  1.996696e+08\n",
       "South America   1.0  2.059153e+08  2.059153e+08           NaN"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_eleven():\n",
    "    import pandas as pd\n",
    "    import numpy as np\n",
    "    Top15 = answer_one()\n",
    "    ContinentDict  = {'China':'Asia', \n",
    "                  'United States':'North America', \n",
    "                  'Japan':'Asia', \n",
    "                  'United Kingdom':'Europe', \n",
    "                  'Russian Federation':'Europe', \n",
    "                  'Canada':'North America', \n",
    "                  'Germany':'Europe', \n",
    "                  'India':'Asia',\n",
    "                  'France':'Europe', \n",
    "                  'South Korea':'Asia', \n",
    "                  'Italy':'Europe', \n",
    "                  'Spain':'Europe', \n",
    "                  'Iran':'Asia',\n",
    "                  'Australia':'Australia', \n",
    "                  'Brazil':'South America'}\n",
    "    Top15 = Top15.reset_index()\n",
    "    Top15['Continent'] = Top15['Country'].map(ContinentDict)\n",
    "    Top15['Population'] = Top15['Energy Supply'] / Top15['Energy Supply per Capita']\n",
    "    result = Top15.copy()\n",
    "    result = result[['Continent', 'Population']]\n",
    "    result = result.groupby('Continent')['Population'].agg({'Size': np.size,'Sum': np.sum,'Mean': np.mean,'Std': np.std})\n",
    "    return result\n",
    "answer_eleven()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Question 12 (6.6%)\n",
    "Cut % Renewable into 5 bins. Group Top15 by the Continent, as well as these new % Renewable bins. How many countries are in each of these groups?\n",
    "\n",
    "*This function should return a __Series__ with a MultiIndex of `Continent`, then the bins for `% Renewable`. Do not include groups with no countries.*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Continent      % Renewable bins\n",
       "Asia           (2.212, 15.753]     4\n",
       "               (15.753, 29.227]    1\n",
       "Australia      (2.212, 15.753]     1\n",
       "Europe         (2.212, 15.753]     1\n",
       "               (15.753, 29.227]    3\n",
       "               (29.227, 42.701]    2\n",
       "North America  (2.212, 15.753]     1\n",
       "               (56.174, 69.648]    1\n",
       "South America  (56.174, 69.648]    1\n",
       "Name: Country, dtype: int64"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_twelve():\n",
    "    import pandas as pd\n",
    "    import numpy as np\n",
    "    Top15 = answer_one()\n",
    "    ContinentDict  = {'China':'Asia', \n",
    "                  'United States':'North America', \n",
    "                  'Japan':'Asia', \n",
    "                  'United Kingdom':'Europe', \n",
    "                  'Russian Federation':'Europe', \n",
    "                  'Canada':'North America', \n",
    "                  'Germany':'Europe', \n",
    "                  'India':'Asia',\n",
    "                  'France':'Europe', \n",
    "                  'South Korea':'Asia', \n",
    "                  'Italy':'Europe', \n",
    "                  'Spain':'Europe', \n",
    "                  'Iran':'Asia',\n",
    "                  'Australia':'Australia', \n",
    "                  'Brazil':'South America'}\n",
    "    Top15 = Top15.reset_index()\n",
    "    Top15['Continent'] = Top15['Country'].map(ContinentDict)\n",
    "    Top15['% Renewable bins'] = pd.cut(Top15['% Renewable'], 5)\n",
    "    result = Top15.groupby(['Continent', '% Renewable bins'])['Country'].count()\n",
    "    result = result.reset_index()\n",
    "    result = result.set_index(['Continent', '% Renewable bins'])\n",
    "    return result['Country']\n",
    "    \n",
    "answer_twelve()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Question 13 (6.6%)\n",
    "Convert the Population Estimate series to a string with thousands separator (using commas). Do not round the results.\n",
    "\n",
    "e.g. 317615384.61538464 -> 317,615,384.61538464\n",
    "\n",
    "*This function should return a Series `PopEst` whose index is the country name and whose values are the population estimate string.*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "scrolled": true,
    "umich_part_id": "020",
    "umich_partlist_id": "003"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Country\n",
       "Australia              23,316,017.316017315\n",
       "Brazil                 205,915,254.23728815\n",
       "Canada                  35,239,864.86486486\n",
       "China                 1,367,645,161.2903225\n",
       "France                  63,837,349.39759036\n",
       "Germany                 80,369,696.96969697\n",
       "India                 1,276,730,769.2307692\n",
       "Iran                    77,075,630.25210084\n",
       "Italy                  59,908,256.880733944\n",
       "Japan                  127,409,395.97315437\n",
       "Russian Federation            143,500,000.0\n",
       "South Korea            49,805,429.864253394\n",
       "Spain                    46,443,396.2264151\n",
       "United Kingdom         63,870,967.741935484\n",
       "United States          317,615,384.61538464\n",
       "Name: Population, dtype: object"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_thirteen():\n",
    "    Top15 = answer_one()\n",
    "    Top15['Population'] = Top15['Energy Supply'] / Top15['Energy Supply per Capita']\n",
    "    Top15 = Top15.reset_index()\n",
    "    Top15 = Top15.set_index(['Country'])\n",
    "    result = Top15['PopEst'] = Top15['Population'].apply('{:,}'.format)\n",
    "    return result\n",
    "answer_thirteen()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Optional\n",
    "\n",
    "Use the built in function `plot_optional()` to see an example visualization."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "This is an example of a visualization that can be created to help understand the data. This is a bubble chart showing % Renewable vs. Rank. The size of the bubble corresponds to the countries' 2014 GDP, and the color corresponds to the continent.\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAA7AAAAF3CAYAAACcz6fnAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzs3Xec1dWd//HX53vb9BmGXkUUsYCNSWyJFdREY9m4thRj\n/Gmy2c1ustkkprqJKaaZmGyaKQbjJrasLVZE7AVBEcECSBUYhjK93Pr5/TEDAQVmBubeO3fm/cyD\nzL3f7/ee87nqY7jve873HHN3RERERERERPq7IN8FiIiIiIiIiPSEAqyIiIiIiIgUBAVYERERERER\nKQgKsCIiIiIiIlIQFGBFRERERESkICjAioiIiIiISEFQgBUREREREZGCoAArIiIiIiIiBUEBVkRE\nRERERAqCAqyIiIiIiIgUhHC+C+iJYcOG+cSJE/NdhoiIiIiISF40tyfZ1BwnMCOw7PSRcceBkRVF\nlMRyGxUXLFiw2d2Hd3ddQQTYiRMnMn/+/HyXISIiIiIiknOPLanlxrnLKS8KEwlldxJtRzJNRzLD\n1R86lMMnDMlqXzsys9U9uU5TiEVERERERPqpRWvq+d3c5ZTHsh9eAYoiIYoiAT++/3XWbG7Nen+9\npQArIiIiIiLSD7XGU/xy9lJikYBIOHfRrSgSwoH/mf0mqXQmZ/32hAKsiIiIiIhIP3TzUytoak9R\nEs39nZ9lsRBrt7Rx74K3c973nijAioiIiIiI9DOvrWvkyTc2UVmcn2WLzIzyojB/m7+W9fXtealh\nVxRgRURERERE+pm7568lFECQrSWHeyAcCnCHhxetz1sN76QAKyIiIiIi0o/UNXaw+O1Gyop2Hn39\nzRXHcfs1H+X2b36EO/7749QuX9Qn/c296btsXbcCgFu+eB7tzQ3bz5XFQsx9bSPtiVSf9LWvCmIb\nHRERERERkcHisSW1uENgO4++hqIxLvzWLQCsWfw8z9/5K867+jc7XZNJpwhCvYt5p1z+td2eC4cC\nUvE0zy/bzCmHjepVu9mQtQBrZlOA23Y4NAn4JnBz1/GJwCrgQnevz1YdIiIiIiIiheSppZsoie55\nsmyyvZVYaTkA695YwLy7fkustIKGDau49Pt38uAvvkjL1o2kkwkOn3ERh558PitffpIX774RgFQi\nTiad5KM/vJt7fvAvHHfhvzNi/0N22VckMJ58c9PADrDu/iZwJICZhYB1wF3A1cAcd7/OzK7uev7l\nbNUhIiIiIiJSKFrjKba2xKkqibzrXDoR5/ZrPko6maCtcTPnfPGX289tXv0mF137VyqGjwHglMu/\nTlFZJalEB3deezmTak5l/6NOZP+jTgTgkV99lTFTjupRTbFIwMpNLbg7Zvm7JxdyN4X4NOAtd19t\nZucCJ3cdnwU8jgKsiIiIiIgIaza3Eg5sl0FxxynEtctfZc7vv8VF1/4VgBGTDt0eXgFeffR2Vr70\nOACtWzfSsHENo8qmAfDyg38mFI0x9bR/7lFN4VBAazzJpuY4IyqK9uXt7bNcLeJ0MfDXrscj3X1D\n1+NaYGSOahAREREREenX1m5pJZXxbq8bdeA0OloaaG/uvBszEi3efm7dGwt4+7V5nP+1P3Dht/+X\nYROmkE4mAHh7yTzeenEOJ328d2OIZrB2S1uvXpMNWQ+wZhYFzgHueOc5d3dgl/92zOwqM5tvZvM3\nbdqU5SpFRERERETyr6EtiXefX6nfsArPZCgqq3zXuUR7C7HSCiKxIuo3rGLjW4sBaN68gSdv+RGn\nf+Z7hKO9G0nNOLR0JHv1mmzIxRTiDwAvufvGrucbzWy0u28ws9FA3a5e5O43AjcC1NTU9OBfoYiI\niIiISGGLpzLs7jbTbffAAuDOqVd8kyAIveu6CVOPY8ncu/jr1y6iatQERh4wFYA3nrmfeGsjD/3i\nSwCUVg3jrM//rEd1uTuJdKb3b6iPmfck3u9LB2a3Ag+7+01dz38EbNlhEadqd//Sntqoqanx+fPn\nZ7VOERERERGRfPvLsyu576V1DCmN5ruUndS3Jrny1AM49dDsrERsZgvcvaa767I6hdjMSoGZwP/t\ncPg6YKaZLQNmdD0XEREREREZ9IojoR5NIc61wCAaytUSSruX1SnE7t4KDH3HsS10rkosIiIiIiIi\nOxhbXUo4lN+tanYlMBgzpCTfZeRsFWIRERERERHpxoSh+Q+J7+TupDMwrjr/tSnAioiIiIiI9BMj\nK4sIAiPdg610ciWeyjCyqohoOP/xMf8ViIiIiIiICABmxiFjKmmNp/JdynYdiQxHjK/KdxmAAqyI\niIiIiEi/8oEjxvSbhZzcHQxOnZqd1Yd7SwFWRERERESkH5k2voryojDxZDrfpdAaT7P/8DImDC3N\ndymAAqyIiIiIiEi/EgqMs44aS1sivwHW3UmlM5xz9Ni81rEjBVgREREREZF+ZubU0Qwpjeb1Xtjm\njhT7jyijZtLQ7i/OEQVYERERERGRfqYoGuKzp08hkcrkZUXiZDqDYfzrzIMIBf1nX1oFWBERERER\nkX7okLGVnD5tNI3tyc7FlHLE3WnuSHHJ8fsxZkj+937dkQKsiIiIiIhIP3XJ8ROZPKqcxrbchFh3\np6EtyTEHDOWMw8dkvb/eUoAVERERERHpp4oiIa7+0GHsN7yMhrZUVkOsu1PfluTICUP4t5lT+tXU\n4W0UYEVERERERPqx0liYb5w3lUPGVNDQliSZzvR5H/Fkmoa2JMcfOIwvnHUIkXD/jIr9syoRERER\nERHZriQW5qvnHsYlx02kPZGmqY/ui902ZTidgX85bTKfPWMK4VD/jYnhfBcgIiJ7z93J1NWRaW6G\nZBIiEYLqaoIhQzDrf9N+REREZO+FQwHnTB/H9P2r+Z/ZS1m9uRUDyovDBL38ez+d6VyoCWDquEo+\ndepkhpbHslB131KAFREpMOmNG+l4dA7xF18k9eZSPJGAUIBhnd/EptMEZWWED55C7LhjKTr1VILK\nynyXLSIiIn1kbHUJ3/3nI3htfSMPLFzPwtX1uDvhwIhFQkRC9q4vst2dRCpDvGtbnlBgHD95GGcc\nPoYDR5YVzBfflsvlmPdWTU2Nz58/P99liIjkVWLxYlr/8lcSz78A7hCNYsXFWHjn7yLdHVIpvL0d\nUkkIhSg67TRKL76I8MSJ+SleREREsmZzc5z5K7awZF0jy2ubaWhLEA4FGOB0/l8qk2FYeYzJo8o5\ndGwl75k0lMqSaJ4r/wczW+DuNd1epwArItK/ZVpbafn1b2i//wEIAqyyEgt6fm+Kp9N4YyOYUXrZ\nxym95GIsEslixSIiIpJPze1J6tsSJFMZzIxwyBhWFqMk1n8n4PY0wPbfdyAiIiRfe52Gb3yDzNZ6\nrKoKC4V63YaFQlh1NZ5M0nrTn4jPfZzK73yb8NixWahYRERE8q28OEJ58cD8srr/Li8lIjLIxecv\noP5znyPT2kYwdOhehdcdWSSCVVeTWrOG+s/8K6mVK/uoUhEREZHcUIAVEemHEq++SuNXvgqRKEFZ\nWZ+1a2YEQ4aQaWun/nOfJ7VuXZ+1LSIiIpJtCrAiIv1MpqGBxq99Aw+HseLirPQRVFaSaWml8evf\nxJPJrPQhIiIi0tcUYEVE+hF3p+mGn5NpaSEoLc1qX1ZVRWrVSlr/emtW+xERERHpKwqwIiL9SOKF\nF4g//gRWVZX1vswMq6ikddbNpFatynp/IiIiIvtKAVZEpB+ora3l4osv5uDTz+D0BfO59NlneKu5\nOWv9Tbz7/4DOhZ1wp/X2O7LWl4iIiEhfUYAVEckzd+f888/n/YcexvM172H2zNP52tRpbIp35KR/\nq6igY/ZsMk1NOelPREREZG9pH1gRkTybO3cukUiEj5WX007n1N6pVVW0pFJ8+MknaEgmSGUyXH3Y\nVD4wZixrWlu55JmnOGboMF7csoVRxcXcfPwJFIdC/HnlCv68cgWJTIb9S8v45XveS0k4zOrWVj49\n73naUinOHPOP/V9bUikue/YZGtrbSU+bxvd+/nPOPffc/P3DEBEREdkDjcCKiOTZ4sWLmT59Oonn\nX8BKSrYfLwoC/nTc8cw5bSb/d+LJXLPoFdwdgBUtLVx+wIE8dfoZVEYi/H3d2wCcNWYsj5w6g8dn\nnM5BFRX8ZVXnXq9ff+VlPjHpAJ6YeQYjiore1cfsY4/jnnPP4wtf+ML2PkRERET6G43Aioj0A55M\nkq6rw6qr/3EM+O7iV3lu82YCg9r2duricQAmlJQyrWuhp8OHDGFtaysAbzQ18f0li2lKJmhNpTh5\n5CgA5m3Zwh+PPR6ACyfsx7WvLtq5j02bCOY9z7pEgo0bNzJq1KgcvXMRERGRnlOAFRHJs8MOO4w7\nZs2C6mGY2fbjf1uzhi2JOI+eNoNIEDD9wfuJp9MAxEL/mEATMqOja9T03+fP40/HncDUqipuXbWK\nZzbXbb/uHy3/w7Y+Zp82g3BDA8e8tYyOjtzceysiIiLSW5pCLCKSZ6eeeiod7e38+e23tx9b0tjA\n2rZWhsWKiAQBT9fVsbatrdu2WlIpRhYVkcxkuHPt6u3H3zt0KHe9vRaAO9es2X68KZlkWKyIaCjE\n001NrF67tg/fmYiIiEjfUoAVEckzM+O2//4WT27dzHseeoD3P/Iw3138KjNGjWZh/VZOmv0wt69Z\nzeTy8m7b+vKhU/nA3Dmc/fhjTC6v2H78O0ccxR/fWs5Jsx+mtqN9+/EPT5iwvY87a9czZdKkrLxH\nERERkb5ghbBYR01Njc+fPz/fZYiIZE3Hk0/SeO13CSor81ZDprGR6l//isiBB+StBhERERmczGyB\nu9d0d51GYEVE+oGgomLXN6nmUiZNUFnR/XUiIiIieaIAKyLSD4T33x9SqbxtYePJJFZURDBsWF76\nFxEREekJBVgRkX4gqKwkqBoCyWRe+veODiJTpuy0CrKIiIhIf5PVAGtmVWZ2p5m9YWavm9lxZlZt\nZrPNbFnXzyHZrEFEpFBEjz4K79rPNecSCaI10/PTt4iIiEgPZXsE9gbgIXc/GDgCeB24Gpjj7pOB\nOV3PRUQGveJzzwE859OIPZMBM4pmzsxpvyIiIiK9lbUAa2aVwInAHwDcPeHuDcC5wKyuy2YB52Wr\nBhGRQhKZOpXQqFF4D/Z77Uve2EjsuOMIDR+e035FREREeiubI7D7A5uAm8zsZTP7vZmVAiPdfUPX\nNbXAyCzWICJSMMyM0o9/HDo6cjYK6+k0eIaSSy7OSX8iIiIi+yKbATYMHA382t2PAlp5x3Rh7/yE\ntstPaWZ2lZnNN7P5mzZtymKZIiL9R9HpM4kcPg1vaMhJf97QQPHZZxOdelhO+hMRERHZF9kMsG8D\nb7v7C13P76Qz0G40s9EAXT/rdvVid7/R3WvcvWa4prWJyCBhZlR++csQDuHxeFb7yjQ3EwytpuzT\nn8pqPyIiIiJ9JWsB1t1rgbVmNqXr0GnAa8C9wGVdxy4D7slWDSIihSg0ZjQVX/kK3tKCJxJZ6cPb\n2jB3qr79bYKSkqz0ISIiItLXwllu/7PA/5pZFFgBXE5naL7dzK4AVgMXZrkGEZGCU3zySXjbF2j+\n0U+gtBQrKuqztjMtLVgmQ9V13ydy6CF91q6IiIhItmU1wLr7QqBmF6dOy2a/IiIDQckHP4iVltL8\nvevItLdjVVWY2V6355kM3tBAUF5O5Xe/o/teRUREpOBkex9YERHZB8UnncTQm/5IZOph+NatZFpb\ne71CsbuTaW7G6+spOvUUht78J4VXERERKUjZnkIsIiL7KDRmNEN+9lM6Hn2U1lk3k95QiwNWUgLR\n6C5HZd0d4vGuPWWdyJQplF7+CWLvfW/O6xcRERHpKwqwIiIFwMwonjmTohkzSC5ZQvs995J46WUy\n9VvxcLhzQzJ3MMMMPJkiNHIk0RmnUXLOOYQn7Z/vtyAiIiKyzxRgRUQKiJkRnTqV6NSpAGQaG0mt\nWkWmqRlSSQhHCFVXE5q0P0FxcZ6rFREREelbCrAiIgUsqKwkesQR+S5DREREJCe0iJOIiIiIiIgU\nBAVYERERERERKQgKsCIiIiIiIlIQFGBFRERERESkICjAioiIiIiISEFQgBUREREREZGCoAArIiIi\nIiIiBUEBVkRERERERAqCAqyIiIiIiIgUBAVYERERERERKQgKsCIiIiIiIlIQFGBFRERERESkICjA\nioiIiIiISEFQgBUREREREZGCoAArIiIiIiIiBUEBVkRERERERAqCAqyIiIiIiIgUBAVYERERERER\nKQgKsCIiIiIiIlIQFGBFRERERESkICjAioiIiIiISEFQgBUREREREZGCoAArIiIiIiIiBUEBVkRE\nRERERAqCAqyIiIiIiIgUBAVYERERERERKQgKsCIiIiIiIlIQFGBFRERERESkICjAioiIiIiISEFQ\ngBUREREREZGCEM5m42a2CmgG0kDK3WvMrBq4DZgIrAIudPf6bNYhIiIiIiIihS8XI7CnuPuR7l7T\n9fxqYI67TwbmdD0XERERERER2aN8TCE+F5jV9XgWcF4eahAREREREZECk+0A68CjZrbAzK7qOjbS\n3Td0Pa4FRma5BhERERERERkAsnoPLPA+d19nZiOA2Wb2xo4n3d3NzHf1wq7AexXAhAkTslymiIiI\niIiI9HdZHYF193VdP+uAu4D3AhvNbDRA18+63bz2Rnevcfea4cOHZ7NMERERERERKQBZC7BmVmpm\n5dseA6cDi4F7gcu6LrsMuCdbNYiIiIiIiMjAkc0pxCOBu8xsWz9/cfeHzOxF4HYzuwJYDVyYxRpE\nRERERERkgMhagHX3FcARuzi+BTgtW/2KiIiIiIjIwJSPbXREREREREREek0BVkRERERERAqCAqyI\niIiIiIgUBAVYERERERERKQgKsCIiIiIiIlIQFGBFRERERESkICjAioiIiIiISEFQgBUREREREZGC\noAArIiIiIiIiBUEBVkRERERERAqCAqyIiIiIiIgUBAVYERERERERKQgKsCIiIiIiIlIQFGBFRERE\nRESkICjAioiIiIiISEFQgBUREREREZGCoAArIiIiIiIiBUEBVkRERERERAqCAqyIiIiIiIgUBAVY\nERERERERKQgKsCIiIiIiIlIQFGBFRERERESkICjAioiIiIiISEFQgBUREREREZGCoAArIiIiIiIi\nBaHbAGtmB5nZHDNb3PX8cDP7evZLExEREREREfmHnozA/g74CpAEcPdFwMXZLEpERERERETknXoS\nYEvcfd47jqWyUYyIiIiIiIjI7vQkwG42swMABzCzC4ANWa1KRERERERE5B3CPbjmX4EbgYPNbB2w\nEvhoVqsSEREREREReYduA6y7rwBmmFkpELh7c/bLEhEREREREdnZbgOsmf3nbo4D4O7XZ6kmERER\nERERkXfZ0whsec6qEBEREREREenGbgOsu38rl4WIiIiIiPQXnkqRfGURiddfI7lwEalVK/F4HIIQ\nQWUlkamHEZ02leiRRxIaPTrf5YoMGt3eA2tmk4AbgGPpXIn4OeDzXffGioiIiIgMGJmGBtrvf4C2\nO+4k09IMqTTEYlgsBkGo85otW+h4+BE6HnoYgOj0oym58EKiNdO3324nItnRk1WI/wL8Eji/6/nF\nwF+BY3rSgZmFgPnAOnc/28yqgduAicAq4EJ3r+9d2SIiIiIifcfdiT/1FE0//BHe1oaVlBJUDdn1\nxZEIVlzc+bpMhsTLC0ksWEDsmGMp/+IXCFVX57BykcGlJ/vAlrj7n9091fXnFqCoF338B/D6Ds+v\nBua4+2RgTtdzEREREZG88Hicxm9fS+M1/w0OQfVQrKhnH3ctCAiqqrAh1cTnvcCWj36c+IsvZrdg\nkUFstwHWzKq7RksfNLOrzWyime1nZl8CHuhJ42Y2DjgL+P0Oh88FZnU9ngWct3eli4iIiIjsG+/o\noP7qrxB//AlsSPX2kdXeMjOCIdVgRsPVX6Xj6af7uFIRgT1PIV5A5z2v2ybyf2qHcw58pQft/wz4\nEjuvaDzS3Td0Pa4FRvasVBERERGRvuPuNH77WpILF2LVQ/vk/lUrLgYzGq/5FsFPf0L08MP7oFIR\n2Wa3I7Duvr+7T+r6+c4/k7pr2MzOBurcfcEe+nA6w/CuXn+Vmc03s/mbNm3qyXsREREREemx9gcf\nJP7sc30WXrexoiKIRGj89rVk2tr6rF0R6dkiTpjZVOBQdrj31d1v7uZlJwDnmNkHu15XYWa3ABvN\nbLS7bzCz0UDdrl7s7jcCNwLU1NTsMuSKiIiIiOyN9MaNXPsfn+Ou2lqCICAw+PHR05lePbRX7Ty0\nfj1Lm5v49ykH73Q8KCsjs2ULLb/5LRX/+fm+LF1kUOvJNjrXACfTGWAfAD4APA3sMcC6+1fommZs\nZicD/+XuHzWzHwGXAdd1/bxn78sXEREREem9ud/7PrPrNvLojJnEQiG2xOMkM5let3PmmDGcyZhd\nnrOqKtrvv5/Siy8mNEZ7xYr0hZ6MwF4AHAG87O6Xm9lI4JZ96PM64HYzuwJYDVy4D22JiIiIiPRK\nprWVtU88QXVxCbFQ596uQ2MxAKY/eD/njBvPY7UbKAqF+PV7j2VSWRkPr1/PT994nUQmw5BolF+/\n9xhGFBVx66pVLKzfynVHHc1n58+jPBxhYX09dR0dXDPtcM4qKabtgQco/39X5PMtiwwYPdlGp93d\nM0DKzCronPI7vjeduPvj7n521+Mt7n6au0929xnuvrX3ZYuIiIiI7J2OJ5/ipIoK1ne0c+zDD/Kl\nl1/i2R3WXKmIRHhi5hl88oAD+cYrCwE4ZtgwHjzlVB6bMZPzx4/nf5a+ucu2N3Z08PeTT+F/T3gf\n1y5ehJWV037X3XgqlZP3JjLQ9WQEdr6ZVQG/o3Nl4hbguaxWJSIiIiKSJcl58yiNxnj0tJk8v3kT\nT2/axJUvPMc3pnauGHz+uM6xmn8aP4FvLnoFgPXt7Vz5wvPUdbSTyGSYUFq6y7Y/MGYMgRlTKirY\nFI9j0SiZhgbSa9YSnrR/bt6gyADWbYB19890PfyNmT0EVLj7ouyWJSIiIiKSHYklr2HFxQRmnDB8\nBCcMH8GhFZXctnoVwE4rEm979NWFL/PpyQdx5pgxPLOpjh+99tou244Foe2POzfcAHBSK1YowIr0\ngW6nEJvZn83sSjM72N1XKbyKiIiISKHyeJzMpjqWx+OsaG7efnxxYwPjSkoAuOfttQDc/fZaarpW\nJW5KJhldXAzAbatX967PVJrk8uV9Ub7IoNeTKcR/BN4P/MLMDgBeBp509xuyWpmIiIiISB/zjg6w\ngLZ0mq8sfJmmZIKQBexfVsZPjp7O7NoNNCQSnDT7EWKhgN+891gAvnjooVzx/HNURSO8b/gI1rS2\n9rhPC4XI7BCWRWTv2T+mNuzhIrMQ8B7gFODTdC7sdPCeX9V3ampqfP78+bnqTkRERER6wN3pSHeQ\nzCTBnXAQoThcvNMU3P4m09jIpvM/TFBdvcvz0x+8n0dOnbF9VeI+6bO+nqIzz6Dyi//VZ22KDDRm\ntsDda7q7rif7wM4BSulcuOkp4D3uXrfvJYqIiIhIIXF3VjWtYmn9myyrX8bqplW0p9owC7rOZ4iF\nYkyo2I/JQw5ictVBHFh1YL8KtFZcDO64e87q8nSaUFVVTvoSGeh6MoV4ETAdmAo0Ag1m9py7t2e1\nMhERERHpF+KpDl6qe4lHVj/M5rZNpD1DNBQhFopREa3YKQimMilWNa5kaf2bBISoKqpixn4zec/I\n91ISKcnju+hk0SihMaPJNDZBUdG7zi/4wFl932c4TPigyX3ershg1JNViD8PYGblwCeAm4BRQN/N\nqxARERGRfmnJ5sXc/NosWpOtREMRyqPlexy5DAdhwkGYEkpwd9qSrdzx5u3c+9Y9XDrlIxw9cnre\nR2QjU6fS8egcbBcBNlvCkyblrC+RgawnU4j/jc5FnKYDq+hc1Omp7JYlIiIiIvnUlmzjjqW38WLt\nPGKhGJWxil63YWYUhYsoChcRT8f545I/8OLGeVx68EeoiFVmoeqeiR1zDB2PzslJX97RQVBWRmjs\n2Jz0JzLQ9WQKcRFwPbDA3VNZrkdERERE8qy+o54bXvopm9s3UR4tJ7Bud17sViwUIxpEWbx5MdfN\n+x6fm/4FRpSM6INq96KWE47HYjE8kcCi0az25W2tlF5xBRbs+z9DEenBPrDu/mMgAnwMwMyGm5l2\nYRYREREZgBriDfxk/g/Z0rGFylhln4TXbcyMylgFrclWfjz/h9S15WddUIvFKD7vXDzLW9t4KgVB\niKIzz8hqPyKDSbe/kczsGuDLwFe6DkWAW7JZlIiIiIjkXjzVwc9f+imNiSYqouVZ66csWkZHqoMb\nFlxPS6Ila/3sSemF/4yVleHt2VuX1BsbKbn0EkJDh2atD5HBpidfqZ0PnAO0Arj7eiB7v9FERERE\nJC/uW3EfG9vqshpetymPltGUaOL2N2/Nel+7ElRVUfHlL+JtrXgm0+ftZxobCY0fR9lHP9LnbYsM\nZj0JsAl3d8ABzKw0uyWJiIiISK691fAWj6+dS3m0LGd9lkXLWFA3n1c3LcpZnzuKnXACxR/8IF6/\ntU9DbKa1FQuFqLzmmqzfYysy2PQkwN5uZr8FqszsSuBR4HfZLUtEREREciXjGWYtuYlIECZkoZz1\nG1hAUaiIP79+M8l0Mmf9bmNmlH/+c8ROOQXfuhVPp/e5zUxzM2QyVP3oB0QO0NY5In2tp4s43Qn8\nDZgCfNPdf5HtwkREREQkN97c+gb18XpKIiXvOvej068HoGFDI0tmv9ZtWw0bGrnx43/ocd9F4SLa\nkm0s2vxKzwvuQxYOU/m1r1Jy8UV4Y0NnAN0Lnk6T2bqFoKKc6p//jOi0aX1cqYhAz0ZgcffZ7v5F\nd/8vd5+d7aJEREREJHceWzsH6+aaxtqeBdi9EQnCPLzqYTrvWss9C4Uo//SnGPLzGwgNGUJm61Yy\nzc09qsdTKTJbt+JNjRSfey5Db55FZMqUHFQtMjh1uw+smf0T8ANgBGBdf9zde7+btYiIiIj0K/Ud\n9by+5fUfxke4AAAgAElEQVRu732d+5vH2bJ6C7+//CYOP3MqB514EPd+5+8k2zun/p7x+RmMmzZu\np9f8+d/+l9P/YwYjJ48E4ObP3MIZ/3k6Iw/cef/X4nAxG1rXsb51PWPLxvbhu+ud6NSpDJ11E/Gn\nnqb11ltJrVzVuQiMO8RinXu5unduj5NIQCSCmVF89lmUnHce4UnaaVIk27oNsMAPgQ+5++vZLkZE\nREREcmt10yoCs273ez3l0yfzwl/nceEPLwAg2ZHk0usvIhwLs3XtVu7+1n188veX7fSaI846nEUP\nvsrMySPZsmYrqUT6XeEVOu9FdXdWNa7Ma4CFzj1ii2acRuy0U0mvXk1y6TKSr71GaulSMu3tWChE\nUF1N9IgjCB80mcghhxCU5W7hK5HBricBdqPCq4iIiMjAtKZpNelM7xcvSqcyPPLT2WxcvhELArau\n3fquaw455WCemfUsp37mFBY9sIjDPzB1t+2ZGW81LOeEse/rdS3ZYGaEJ04kPHEixafPzHc5ItKl\nJwF2vpndBtwNxLcddPf/y1pVIiIiIpITSxuWEQvHev26ebe/SGl1Cf/vpk/iGecHM378rmsiRREm\n1kxk6VPLeP2xN7j8D5/YbXuxUIwVjSt6XYeIDC49CbAVQBtw+g7HHFCAFRERESlwW9o3EQ66/0gY\nLYkSb0tsfx5viVMxohwLjEUPvoqnd73g0ZEfOoI7vvw3xh8xjuLyot22HwkibO3Y0vs3ICKDSre/\nrdz98lwUIiIiIiK5l8ykCHVz/yvAiAOGE4SM33/ijxz+gWlMP/8o/vb1u3n1ocVMOmYSkeLILl83\nesoooqVRDv/gnreVMYxUJoW7Y9bdmsgiMlj1ZBXig4BfAyPdfaqZHQ6c4+7fyXp1IiIiIpJV3UXF\nLz7ynwCEwiE+csMlO527ctYntz8+9V9OBqBqdCVX3XzF9uPNm5sh40x6T/cr9JoFCq8iskc92Qf2\nd8BXgCSAuy8CLs5mUSIiIiKSG9FQjIxnstL2qw8t5k+f+jMnXXUiFuw5mGY8QyTY9SiuiMg2PbkH\ntsTd573j27BUluoRERERkRwaVz6ON7a+TjQU7fO2p505lWln7n7l4R0lMglGl47u8xpEZGDpyQjs\nZjM7gM6FmzCzC4ANWa1KRERERHLiwKrJpPZiG52+lkgnOKDqwHyXISL9XE9GYP8VuBE42MzWASuB\nj2a1KhERERHJifHlEwhbKN9lYBawf2X398mKyODWk1WIVwAzzKwUCNy9OftliYiIiEgu7F8xEbOA\nVCbVo+10smHbPbiTqybnpX8RKRx7nEJsZiEzGwbg7q1A3MyuNLPXc1KdiIiIiGRVLFzECWNOoDXZ\nmrcaWhItHDH8SCpilXmrQUQKw24DrJldDGwFFpnZE2Z2OrAC+CDwkRzVJyIiIiJZ9v5xJwKGu+e8\nb3fHgVPGn5rzvkWk8OxpnsjXgenuvtzMjgaeAy5w9/tyU5qIiIiI5MKo0tEcNmwqr21eTEWsIqd9\ntyRa2K9iPyZVTsppvyJSmPY0hTjh7ssB3P0lYJnCq4iIiMjAdMnBlxIJRUmkEznrM5lJYmZcdtjl\nvGPLRhGRXdrTCOwIM/vPHZ5X7fjc3a/PXlkiIiIikktVsSouOfhS/rTkJsJBmMB6stvi3nN3WhOt\nXHDQhYwoGZHVvkRk4NjTb6bfAeU7/HnncxEREREZQGpGvodjRx9LU6Ipq/fDujtNiSamDT+cE8ef\nlLV+RGTg2e0IrLt/a18aNrMi4Ekg1tXPne5+jZlVA7cBE4FVwIXuXr8vfYmIiIjIvjMzLj34o8TT\ncV6ue4mKaEWfj8S6O42JJg4achBXTL2SUD/Yg1ZECkc254bEgVPd/QjgSOBMMzsWuBqY4+6TgTld\nz0VERESkHwgFIS4/7AqOH/M+mhJNdKQ6+qztRDpBY6KJI4YfyWeO+DcioUiftS0ig0PWAqx3aul6\nGun648C5wKyu47OA87JVg4iIiIj0XigIcenBH+HKaZ/CLKAp3kTGM3vdnrvTFG8i5Wk+duhlXDnt\nKoVXEdkre1rEaZ+ZWQhYABwI/NLdXzCzke6+oeuSWmBkNmsQERERkd4zM44ccRQHVB3IHUtv56WN\nCwCnJFzS4/CZzCRpS7YDMHXYVC6acjFDiqqzWLWIDHTW0xv0u6b//jdQBPzM3e/ucSdmVcBdwGeB\np929aodz9e4+ZBevuQq4CmDChAnTV69e3dPuRERERKSP1Xds5bn1zzF37WPE0/GuEVknGopiXf/L\nkCGZTuJAYAHhIMyJ407ihDHvY3jJ8Hy/BRHpx8xsgbvXdHvd7gKsmY1y99odnt8OXAYY8IK7T+tl\nQd8E2oArgZPdfYOZjQYed/cpe3ptTU2Nz58/vzfdiYiIiEgWpDNpNrSuZ13LOlY2rmBt81oS6QSO\nEw3FGFM6hklVkxhXNo7RpWM0VVhEeqSnAXZPU4h/Y2YvAT909w6gAbgAyABNPShgOJB09wYzKwZm\nAj8A7qUzCF/X9fOe7toSERERkf4hFIQYVz6eceXjOWb0sfkuR0QGmd0u4uTu5wEvA383s48Dn6Nz\nS5yh9GzhpdHAXDNbBLwIzHb3v9MZXGea2TJgRtdzERERERERkT3a4yJO7n6fmT0AfIbOe1i/6+5P\n9qRhd18EHLWL41uA0/aiVhERERERERnEdjsCa2bnmNlc4CFgMXARcK6Z3WpmB+SqQBERERERERHY\n8wjsd4D3AsXAw+7+XuALZjYZ+C5wcQ7qExEREREREQH2HGAbgX8CSoC6bQfdfRkKryIiIiIiIpJj\nu51CDJxP54JNYeDS3JQjIiIiIiIismu7HYF1983AL3JYS8FIe5pNbXWsa1lHbWstHakOEpkEiXSC\nwIxoECMWjlEeKWdM2RjGlo+jIlqR77JFREREREQK2h5XIZZOdW11rG1ew8rGlSxvWMb6lnUAOJDO\npAgswMwwrPO4O47j7oSCMBnPUBIpYb+KiUyumsz48vHsVzGRkkhJHt+ViIiIiIhIYVGA3Y1kJsni\nza/yyKpHeLtlDWC4Z4iGopRGSglsT7Ovd+bupDzFsvo3eW3zYkJBGMM4ZvSxnDjuJMaVj8veGxER\nERERERkgFGDfYWvHVp5d9zSPvz2XeCpBKAgoj5RjZnvdppkRsQiRIAKRzmPpTJpn1z/Ds+ufYXz5\neGbsN5PDhx1BJBTpo3ciIiIiIiIysCjAdlnfso67l9/Na1uWAE5JuISKWHnW+gsFISpjFbg7ta0b\n+NOSPxILYpw8/hRmTjyDWCiWtb5FREREREQK0aAPsOlMmkdXz+b+lffhDuXRsl5ND95XZrb9Xthk\nJslDqx5kXu0LfOKwTzKp6oCc1SEiIiIiItLfDeoAu75lHTctuYn1Lesoi5QSDvL7jyMSRKiMVdKU\naOL6BT/hlPGncvYBH9JorIiIiIiICIM0wO446gpGZbRin+5x7WulkVLSmTRz187hlU0vazRWRERE\nREQEyN1c2X6iId7AD1+8jntX3ENxuJjyaFm/Cq/bdN4ju2009sf8/a17cfd8lyUiIiIiIpI3g2oE\ndnP7Zn624Hoa4439btR1d7aNxj648gGaE81cdPAlOb1HV0REREREpL8YNAG2tnUDP11wPe2p9qyu\nLpwNoSBERayCp9c9RXu6g8sO/QShIJTvskRERERERHJqUAzlbW7fzE8XXE9HqoPyaFm+y9krgQVU\nxipZUPsit7x2MxnP5LskERERERGRnBrwAbYh3sBPF/yE9lQ7ZdHSfJezT8yMilgF82pf4M6ld+ie\nWBERERERGVQGdIBNpBP8/KUbaEo0FezI6zsFFlARq+CJt+fy6OrZ+S5HREREREQkZwZ0gL1/xd+p\na6ulIlpY97x2J7CAskgZ9624h/Ut6/JdjoiIiIiISE4M2AC7snElc9Y8SllkYIy8vlM4CAPGTUtu\nIp1J57scERERERGRrBuQATaRTnDT4j8QDkIDerXeskgp61vWaSqxiIiIiIgMCgMywP59xX1s7dhC\naaSwF23qjplRFinl/pX3aSqxiIiIiIgMeAMuwK5sXMlja+YM2KnD76SpxCIiIiIiMlgMqADr7vzl\n9VsG/NThdyqLlLK+eR0vbHg+36WIiIiIiIhkTTjfBfSlNc2rqW3dQPkAW3W4O2ZGLBxl9ppHOG7M\n8ZhZvksSEdln7k5dUwdrtrSxoq6FLS1xEskMGXei4YDyogj7jyhjwtASxg4pIRIeUN/JioiIyC4M\nqAD7+Nq5AIMywBWFitjctomVjSuYVHVAvssREdkrHck0L761hcdeq2VFXQuptGMGqYwTMiPo+vXu\nQDrjmBmBGe7OmCHFHDd5GCcfMpLqslhe34eIiIhkx4AJsC2JZhZsnE9pdGAv3LQ7ZoYDj789d98C\nrDu0boKGVdC+Bdq2QNM6aF4HHfWQSUMmBUEYghDEKqF8LFSMhZJhUDIUKveDspEwCL9IEJG9s6Gh\nnTmLa3l0SS3JVIZQYBRHQ4RiPfs9knFnc3OcO15Yy53z1nL0xCF88MixHDKmYlB+qSkiIjJQDZgA\nO692Hhl3QjZ47n19p/JoGS/XvUxToomKaEXPXpRog9qFULcY1r/Y+TPRAhYG7wqrFkAoAhbaOZS6\nd16TToJnOkOtBZ3HIiUwfCqMqYGRU2H00TBIv1wQkd1rjaf489MrePKNTYBTGgtTEo30up3AOgNv\ncTREJuO8vGorL62qZ8LQEv515kGMH6rfPyIiIgPBgAiwGc/w6OrZFIUH95SxwALcM7yw4Xlm7nf6\n7i9sqYO3n4Olf4d18wCDTBJCMYgUQ/HQfR89TSeh9mV4+3kIhTvD7ujpMOVsGH88lI/et/ZFpOAt\nWlPPL2cvpbkjRUVRmCDom5HSIDAqS6K4O29vbeMrty3kn4/Zj7OOHEM4pPtkRURECtmACLDL6pfS\nnGymYpAt3rQrxeFi5qx5lBkTZu48bS6VgFWPw8KbYOPizoC6bQpwNlZsDkUgVPmP55k0bFwIG+Z3\nPh96EBx1BUw6DQb5Fw8ig01HMs2fnnyLJ16vIxYJqCrp/YhrT5gZFcURUukMtz63imeXbeJzZx7M\n6KrirPQnIiIi2TcgAuxbjW+Rce2BChANRWlKNFMfr6e6qBqaN8Brd8Ki/4VkW+c035I+GGHtrSAE\nRVWdj90777F99GoIF8G0S+DQf4bKcbmtSURyrjWe4gf3LWFZbTOVxZE+G3Xdk3CoMySv29rG1+94\nha+fN5X9hw+OvcJFREQGmgERYJfVLyUaRPNdRr9hGLUbX6F65ZPw2t8670+NlXcG1/7ADGJd9+im\n4vDSH+Dlm+Cgs+GYz2p6scgA1RpP8e3/e5W1W1qpKonkdHGlbaOxrR2dNXzj/GlMGqEQm0sdqQ7W\ntaxjXcvbrGpcSUuyhWQmSTiIUBwqYkLFfowrH8/YsrGDbjs8ERHpuYIPsO7OmqbVREN9H2BbtrQw\n++dz2PBGLUVlMUqrSzno/ZNZ9vRyLvzhBe+6/v7rHuS9F72H4fsP6/NaeiqWinPk2pcY++oDEC6B\n4iGdo679VTgG4eGdU4zfvBeW3Q/TPgLTr+ysXUQGhI5kmh/ct4S1W1qpzHF43VFpUZjWeIrv3L2Y\nb19wOOOqS/JSx2DRnmrn5Y0vMWfNo9S21RK2EClPE7KAwAIMw3HcnQV1CwhbiLSnqYhVctLYkzl2\nzHFUxiq770hERAYNc/d819Ctmpoanz9//i7Pbe3YyjXPfr3nq+72kLtz87/cwrQzp3L0eUcBsHF5\nHcueXsb61zbsMsDmlTuHbFrKySufJ0gn8FgFYysn5ruq3ksnoaOhc0Gp478AUy+GQIuuiBS6385Z\nxuOvb8z5yOvutHSkqCiO8ONLj6YoOnhXr8+WLe2beXT1bJ7b8CzpTJpIKEJRqKhH/+7dnWQmSXuq\nHcM4YviRnD7xDCZU7JeDykVEJF/MbIG713R3XT8emuuZ9S3rCOj7gLP6pTUE4WB7eAUYeeAIOpo7\nWLVgNX/7+l1sWrmZ0VNGcc43zsbMuOWzf+G0fz2F0QeP5kenX897Lqhh+bPLCcfCXPD9D1NWXcqy\nZ5bzzKxnSafSFFcUc843P0RZ9b5t71Aeb2HG8icZ37SeeChGPFqKewoH8v8xsZdCESgd3jm1+Knv\nwrIHYMb3oXJ8viuTApL2NJva6ljXso6t7VtJZpKEghClkVJGl45hbNlYisJF+S5z0Fi0pp7HX99I\nZXH/CK8AZUVhtrTEue351Vx24qR8lzNgZDzD0+ue4m/L7iSVSVEWKSUc6d1HDTMjGooSDUXJeIZX\nNi1k4aaFnDrhNM6e9KGszLgSEZHCkbUAa2bjgZuBkYADN7r7DWZWDdwGTARWARe6e/3e9rOmeQ0p\nT+17we+waeUmRh00apfnNi7byJU3X0H5sHJu/swtvP3qOsYfvvMCRMn2JGMPG8PJV53IY7+ay8L7\nXuF9lx3PuMPHcdlvP4aZsfC+V3j+Ly8w499O3bsiu0ZdT1n5HKFMmtZICZhhQDqTJpVJEenP04f3\nJByD0HDYuAj+eg4c/yWYepFGY2W33J3lDcuZu/YxFm9+FXAcSGVS27/ICSwg1DWFcWTJSE6bMIOj\nR06nOKxVabOlNZ7il7OXEosEOVmwqTcqiiM8vGgDxxw4jIPH9O0snsFoc/tmbl7yJ95qWE5ppJSy\nyL7vvRtYQEWsgnQmzWNrHmVh3ctcPvUK9q/cvw8qFhGRQpTNdJMCvuDuL5lZObDAzGYDnwDmuPt1\nZnY1cDXw5b3tZGXjCiJBdrZg2J3Rh4ymYkTnh50RB46gcUPjuwJsKBLiwOMPAGDUlFGsfHEVAM11\nzdx9zT20bGkhncxQNXrv7u0Jp5PMfOspJm9Z0TXquvNWNIaRSMcLN8BC52JPJUO7RmO/A2uegpk/\nhJgWXpGdLdm8mNuX3sbW9i1gRlmklMB2/2WHu9MQr+fWN/7CHUtv48RxJ3PWpLOJhbSlU1+75emV\nNHeksrZVzr4IBUYkbPzPI29qKvE+Wt20ip+/fAOJdJzKWGWfj7SHghCVsUqaEo1cv+DHXH7YJzl6\n5PQ+7UNERApD1oaz3H2Du7/U9bgZeB0YC5wLzOq6bBZw3r70055s3+MH1b01bOIwapfW7vLcjtOh\nglBAJp151zVBONj+F7gFtv2aR342m+n/dDRXzrqCD3zxDFKJ3o8el8VbuHDxfUzesoLWSAmp0K5C\nqpMpgPubeyQcg5JhsPopuONCaFyb74qkn2hNtjJryU38+pVf0pxoojxaTkW0vNvfCWZGcbiYilgF\nsVCMOWse5TvPf5u3Gt7KUeWDQ21DO0+8UUdFUf/9Iq00FmZLS4Knl9blu5SCtbJxBT9bcD2ZTJqK\naEVWp4mXRkopCsX44+Lf8/yG57PWj4iI9F85mY9pZhOBo4AXgJHuvqHrVC2dU4z3WjKTxLJwp+fE\n6fuRTqR5+d6F24/VLa9j7Sv7Fp7irXHKh3duD/Dqg6/2+vWjmuu4dNFdVLc3bJ8yvCsOOO8O1gXL\nAigdBs3r4LYPw7oX812R5Fltay3fff5aXqx9kfJoOcXh4r364BwOwlTFKmlJNPPTBT/hsTWPZqHa\nwemxJbXg3u+mDr9TUSTgvpfWUQiLGvY3bze/zS9evgEzoySSmxWdo6EoJeESbnltFq/ULez+BSIi\nMqBkPcCaWRnwN+Bz7t604znv/LSwy08MZnaVmc03s/mbNm3abfvJTCIr3/aaGR/+3vmsnL+KX130\nW2782O+Z+9snKN3HBZfef/n7uOsbd/PHK/5EcWXv/rKfuHU1Fyz5O6FMmvZI8W7D6zYD8sNYcTXg\ncM8nYdlD+a5G8qS2dQM/mf8jWpOtVMYq+mQWRkmkhNJICX9bdicPr9J/W/sqnkzzyOJaSvvx6Os2\nRZGAzc1x3tzQ1P3Fsl08Hee3i35NxjM5v488EopQHC7mpiV/ZEv75pz2LSIi+ZXVbXTMLAL8HXjY\n3a/vOvYmcLK7bzCz0cDj7j5lT+3saRudbz93DU2JpgF/79qkLas4a+kcEqEIqVD395KlMilGlowc\nuPvnpTog3gynfRcOPjff1UgONSWa+N7z36E91U5ZdN8XiXmndCZNc7KZjx36CY4dfWyftz9YPLN0\nE7+avZRIsolnbv0ZG99aTKy0nFA4wpFnfoxJ00/Od4k7aWxPUjOxms9/8JB8l1Iw7lx6B4+vfSyv\nf880JZo5oPIA/uPoz/ebFa5FRGTv5H0bHev8m+QPwOvbwmuXe4HLgOu6ft6zL/1EgujAHGncwf7b\nw2t0N/e77tqA/ss8XAQYzPkaWBimnJXviiQH3J1b3/gLLcnmrH1oDgUhSsIl3PrGX5hcNZmhxUOz\n0s9AN2dxLYHBQ//zJaYcfxYzP3UtAM2bN7Bq4VM9aiOTThH04nfeviiPhZm/civxZJpYRIs5deet\nhrd4fO1jlEXyu6heeaSMZQ3LeGb907xv7PvzWouIiORGNj8ZnAB8DHjVzLbdpPJVOoPr7WZ2BbAa\nuHBfOokEka7NMv4/e/cdJlV1PnD8e+6dtrOzvcDuwtL77gKyNAUpIkVRERVLFBA1sWuMNbGgJkaN\niYnR/IjGHoNGUVBs9CAWEBQQ6b3D9mk77d7z+2NgESm7y84W4Hyex0d25pYzszvlvec973tqalm+\ni9Eb5tU+eEUgGmaJc+Ox2IEEmHMfWOOg7Qm2I1JOGt/v/44VRStIstVvyxObbiMQCfDm6tfVzM4J\nkFKyab+X0k3foelWug0ZW3VfQnoW+cPGYZoG37z3ArvXfocRCZM39BK6DR7LrrXLWPLBP7HHJ1K+\nZyujf/McH//lTpq1y2PvxpVktulK57NG8+2Ml6h0l3LOLx+jWdtu7Nv8I19O/QtGOIRutTNk0kOk\nZLVi7aKZbF3+BZFQAPf+nbQ5YzD9x93Gmi8+pGTHRgZcdRcAa7+Ywb4dm9h5aQHtmiU0+HPmDXnZ\n5d3JTu9Oivz7CRnR5TEO3UGOqwXZrhyyXFlNIttISslba97EolnQtcYN9oUQxFucTFv/Lmdk9mqw\ndbiKoihK46m3AFZKuQiOWV3pnFidx2l1YspTqFjRT6T4y7lg3WzCmqVWwetB2unwpdviACnh89/A\npVMho3Njj+iUpus6+fn5RCIR2rRpw5tvvklycnJMjr106VLeeOMNnnvuuaPeb5gG76ybSpzuqDag\n/Pdt/8Fb4sNij75uzhrfny5Dava3sfKTH9izbi/D7xzGxvIN/Fiyirz0/No9mAO2bt3KV199xVVX\nXQVU/xhPFUWeIBHDpGLPVjJaHX2FyNqFH2KPc3Hpw69hhEN88MQNtOwWTdku3raOyx+fSmJGNu7i\n3VTs38nwm59gyLUP8t7jE9mw+HPGPPAiW5cv5LuPX2PUbX8iJasVY+7/J5puYeePS1j8/j8YectT\n0eNtX89lk99Et1qZ+ttx5A8bR/vew/hu5mv0H3c7usXC2kUzOWPc3Wwr8TVYAOsJeViyZzHzd8yj\nPFiGJnQMGUHjUBX76OebQBcahjRomdCKYa2GUZDeHWsNlpPUh80Vm9nv30+ireED/aOx6lYqjUqW\n7VvKwBZnN/ZwFEVRlHrW9KtrVKNNUlt+LPmxsYcRc/ZIkIvWfoaQkrCl9l9SJBJbE7hS3yCscWCE\nYOaNcPm0aO9YpV7ExcWxfHk0oWLChAm88MIL/O53v4vJsQsLCyksPPayh1Ulq/CH/STaazb7etHD\no8nqnHXC4xFCoAududvnHDeAjUQiWCxHfyvdunUr//nPf6oC2Ooe46liR4nvqDXmFr75NHs3rECz\nWElIa07Jzo1sWjoPgFCll4p929EsVjLbdiUxI7tqv8T0LNJatAcgNbstOV16I4QgLac9nuI9B/b3\nMe9fj1G+fwcCgWkcalHWomtv7M5oqmtKVhs8xXtwdWxGTpdCtq1YREp2a0wjQkpOO9btdjO0a/P6\nemoAKKks5sNNM/hu/3dIKXFY7DVqPyOlZK9vN6+uegW7bmdIyyGc22o4doujXsf7cwt2zENwaJnK\nHwc9TUbbjKr7L31i7An3OD9RNs3G7G2zGJAzUGVMKIqinOJO+gC2ZUIuFnFqrVfSTJPz1s8jIejD\nb6t9OpSUEk1oWLST/tdbc44k8JfAJ7fBmNfAYmvsEZ3y+vfvz8qVKwFYsGABzzzzDDNnzgTg1ltv\npbCwkIkTJ3L//ffz4YcfYrFYGD58OM888wzvvvsujz76KLquk5SUxMKFCw87xpIlS7jjjjsIBALE\nxcXx6quvMtczm3Wz1rPtmx1EAmHKdpfTaWAHht48pMZjXvX5j3w7bRlG2CC7axYj7xqOpmus+Hgl\nX//7G+wJDpq1y0C3RV87wid47pG/85r/DSyahb/+9a+cddZZTJ48mU2bNrF582Zyc3P54x//yDXX\nXIPP5wPg+eef58wzz+T+++9nzZo19OjRgwkTJtCzZ8+qx1haWsqkSZPYvHkzTqeTF198kYKCAiZP\nnsz27dvZvHkz27dv58477+T222+P8W+vfm3e78MwJKk5bdm8bH7V7Wdfcy+VnnKmPTYRV1ozBvzi\nbnLzDi+UtWvtMqy2wyvaatZDr2ehaejWAxf1NIFpGgAs+eCfZHfuxcjbnsZdvJsPn7q5ah/9JxcB\nNU2r2qfLwAv57uPXSM5qTecBo7FbNdbv9cTmSTgKKSVf7lrEexv+S8Q0SLC5alVB+6etasJmmM+2\nfso3e77m2rzraJfcvr6GfRh3sILlRctx2Q6tfbXYLVz/6rXH3MeMmGiW+l3SYtftlAVL2Vi+gQ4p\nHev1XIqiKErjOukjnBxXNuYptga2785ltKzYFe3zegJMaeKwOOqhO24TF5cK+1bAl0/DoAcbezSn\nNMMwmDt3Ltddd91xtyspKeGDDz5g7dq1CCEoLy8H4LHHHuPzzz8nJyen6raf6ty5M1988QUWi4U5\ncyJ3UwQAACAASURBVOZw7/330vLWbGy6jf0b9jHplWuxWHWm/OIlCi/pRWKzI2dlZzw2syqF+Kq/\nXoG/zMfqeWsY/49foFt0PvvzLH6cvZo2ha354pVFXPuviThcdt66fSrNOkbbU89+bi7dLyngtrG3\n0472jBgxgjVr1gCwevVqFi1aRFxcHH6/n9mzZ+NwONiwYQNXXnklS5cu5cknnzwssF+wYEHV+B55\n5BF69uzJ9OnTmTdvHuPHj6+a3V67di3z58/H4/HQqVMnbrrpJqzWxkkXPRGl3iCaJsjpUsjiaf/H\nqvnTyBtyCQCRUACA3G79+HH+NHI6F6JbLJTv3U58SsbxDntcIb+3av91iz6u0T7N2uXhLd1P0bZ1\nXP7YW+iawF0ZPuExHI875OaVH/7FhvINxFucxNfx92nVrCTZk/CFfTy77M8MbjmUi9uPrfc1qevL\n1kd7+1YTeK/85AfWLVxPqDKEaUguf/pS3n3gfQKeAKZhMOj6s+k4sAPleyp4557/0jK/BTtX7SIh\nI4FL/zgWq91K6c4yPnvmc/zlfoSmMfbxi0jJSeGb/yxmzfy1REIGnc7uwNnXRWddTSn5oXilCmAV\nRVFOcSd9AJtsT8GmWYmYkVNixrGZt4jCXSvx16DP67FI5OlZyEIIiEuDVW9D+xGQ07uxR3TKqays\npEePHuzatYsuXbpw7rnnHnf7pKQkHA4H1113HaNHj2b06NEAnHXWWUycOJFx48YxduzYI/arqKhg\nwoQJbNiwASEEvqCP1qIlAkHrXq1wuKLp8emt06jY5z5qAPvzFOLVc1azd90+Xr3hDQAiwQjOFCe2\n1bvJ7ZlLfEr0NdPlnM6U7igDYOvSbezfsp9vpywjzZGG2+3G6/UCcOGFFxIXF50pDIfD3HrrrSxf\nvhxd11m/fn21z+WiRYuYNm0aAEOHDqWkpAS3O9qH9Pzzz8dut2O328nMzGTfvn20aNGi2mM2FaGI\niRDRGcORtz3NV28/y/JP3yQuIQWL3UG/y26hXeE5uEv28N6j45FI4hKSGXnrn074nD1GXcO8lx/l\nu5mvkltwVo33a9f7HEp2rMcen4hhSsIR44THcCylgVL+uuwvlAZKSapBqnBtHKwDMX/HXEoDpVyb\nNwmrVn8XO7a6tx5RODESjPCva18FIDkriUufiL6m967fy/WvTSIuMQ4zYnLpExdjj7fjL/fz+o1v\n0mFAdNa4dGcZYx65kPPuG8X7D09n3YL15I3oxoePfUT/q/vR6eyORIIRpJRsXrKF0p1lTHxxPEh4\n9/5pbF++g9weLbHrNjaWbay3x64oiqI0DSd9xCeEoFViazZXbDrpA1jdjDBy/XxMoSFrkVb2cwKB\nXW/YNVFNhqZHCzvNvheumgn10Cf0dHZwDazf72fEiBG88MIL3H777VgsFkzzUDG1QCA6y2axWFiy\nZAlz587lvffe4/nnn2fevHlMmTKFxYsX8/HHH9OrVy+WLVt22HkeeughhgwZwgcffMDWrVvpN7Af\nERkNLA6m98KBdFCjZkXcpIT8kXkMuXHQYbevW3jsYFNKyTX/+AUOZxxPDHjysPvi4w/9bT377LM0\na9aMFStWYJomDkfdXn92+6H167quE4lEjrN102P+pLVZfHI65974h6Nu1++Sm+l3yc2H3ZbTuRc5\nnXtV/ZyYns0Vj0+t+nnodQ8f9b7m7fO56o/vVd3Xd+yNAHQeMJrOA0ZX3X7enT/t6gZ7N6ygYPiV\nQLTqYKy7srlDbv667C+UBctIquH67drShEaSLYnl+7/ntVWvMCnv+nqbid1Qth6bfvgSjWOlELcp\nbE1cYvQij0Sy4MWFbF++A6EJPEVefKXRlPvkrGSadYhmPWR1ak753gqC/iCeYg+dzu5YdQ6ALd9u\nYcu3W3h50msAhCtDlO4sPRDA2tnp3YkhDfRTbGmRoiiKcsgp0WelQ0pHwmb9pH01pH47viMx6CFg\nrduXX4lsEq0WGo09AXxF8NWfG3skpyyn08lzzz3Hn//8ZyKRCK1atWL16tUEg0HKy8uZO3cuAF6v\nl4qKCs477zyeffZZVqxYAcCmTZvo27cvjz32GBkZGezYseOw41dUVJCTkwPAa6+9hmEada6q3bpX\nK9b+bx2+suiX5kp3JRV7K8jpms325TvwV1RiRAzWzF9XtU+b3q1ZPn0F5YFyDNOoSvH9uYqKCrKy\nstA0jTfffBPDiAbbCQkJeDxHX1M5cOBA3nrrLSCaWpyenk5iYv22B2ooNosW80Aw1oJ+D/954FJ0\nm50WXaPZGqaU2PTYfSwapsH/LX+BsmBZvVfsFUKQbI8GsTM3f1Qv5zBMg92+3TX+fLHGHQp0f5y1\nGn+5n0kvT+D6V68lPtVJJHTgotRP+u4KTRz3opSU0P/q/lz/6rVc/+q13PT2r+gxujvAgbRmSZG/\n6AQenaIoinKyOCUC2HbJ7dBO8qut6b4Sztj9A5V1DF5NaWIRlpN+NrrO4lLhx//Cnu8beySnrJ49\ne1JQUMDUqVNp2bIl48aNIy8vj3HjxtGzZ08APB4Po0ePpqCggAEDBvCXv0Rnv+655x7y8/PJy8vj\nzDPPpHv37ocd+9577+WBBx6gZ8+eRCIRJBKtjm9XGW3SGXT9QKbe9V9emvAKU3/9Dt4SL650FwOv\nPYs3bnyTN25+i/RWh6pYD79jGHvX7eOdX75LXl4eU6ZMOeqxb775Zl5//XW6d+/O2rVrq2ZnCwoK\n0HWd7t278+yzzx62z+TJk1m2bBkFBQXcf//9vP7663V6fE2Jy2E9bBa2KbI7E7jqj+8x4uY/Vt1m\nSnBYY/dZMm/HXLZ7tpNgdVW/cQwIIUiwJTBn+yy2VmyN+fH9EX+N1r8eTcAXxJnsRLfobP1uGxV7\n3cfd3u60k5CRUJUhEQlFCAfCtO3ThpUfryTkDwHgKfJUXZQCEELDEzr+sRVFUZSTm5BN/EsGQGFh\noVy6dOkx7zelyUNf/pZgJIjdchLOPErJ2NWfkO3ZR6U1rvrtjyNiRkiPyyDVkRKjwZ3EKssgrSNc\n9s4JrydWmoZXV73M8v3fH1b5tCGVByt4dvDfjkidVI5u0br9/N+cDSQ5T57CUwCeyjDdW6Vw9/ld\n63ysvb49PLH4D8RZHA1+QdEX9pFsT+F3fR+Kaa/YskApj3z1EAk/m03+0/C/cM+suw677WA/5RG/\njq6T95f7eff+aYQqQ2R1as6u1bu5/E/jAPjvfe/xyzeiBeG+mbqYUGWYsycNoHRHKZ8+8zn+8kp0\ni8bFj48hJTuZJe8uZcXMaDaHLc7GhQ+NJiUn+pnnDfn4Vfeb6JpW99+hoiiK0rCEEMuklNX2Gzwl\npuk0oTEsdzjTNrx3UgawLdx7yHHvjRZuqoODFyMSbadGGmKdOZKhaDVs/R+0GXzMzYzSMiKbNhHZ\nuJHwuvVIvx8ZDIBhIOx2hN2BlpmBtWtXLO3aYcltiTiJKsKeCuKtLgwZ++I6NWFKEwEqq6EWctPj\nT8prRhFT0iU7Nv1L31n3NlLKRvm7ibfGU1S5n4U7/8c5rYbF7LjHutz98+AVoOC8fArOO9Q/2Zns\nZMKUa466/8HgFaDflX2r/p3aMpVf/O3KI7bvc1khfS473vebpn9hXlEURTlxp8w3st7N+/DBxvcx\nTKPe2wjElJScvfUbTKHVeZbQkAYJtgQsJ9Pjr09CgMUOi56E3AGgR//czYoKAvPmEVy8hMiatZge\nD0LXkOEIWCyg6xwooQqmGV10FQ5T+dFM0ASYEkurXKwFBTiGDsGanx/TqqLKkXITcxGN1BgqZIRo\nHp99QmmTp6vs5DikBNOUaNrJ89qwaIJWGXUv/Lbfv58NZRuOuu71aLOVx7Pt++0snrqEcU9fyvpF\nGyjeWsKZV/erdr84Sxxzts9mcO6QmBU0smpNPzUcQb1WYVYURVEa3ykTwLpsLno3783iPYvrrdJj\nfWhbtp10fxm+Os6+HqyYkmxXqcOHsSWAeydywydE6Ij//Q8IzJsPpgEWK8LhQKSkIETNwyNpmkT2\n7iOy5UMqP/oIvVlznFdejmPoULR4VfW4PrRwtUA0UgAZNIK0T27XKOc+WVl0jRapTva7A8TZTo4L\nalJKIqakVVrdX8Nf7FwIyJhf2Oo4oAMdB3So0bZ23Y476GZd6Vq6pnWLyfmdFueBfqtmk72gI6V5\nRIqzoiiKcmo5ZQJYgEEtBrNkz2KkjP0Xh/rSZ+f3RDS9zrOvJiY2zYbDcpq2zzkGicCsDGO8cgtl\nSzsCApGUhNBP/Eu10DSE0wlOJ1JKjPJyPM/+De/fX8AxcgTxV1yBnp1V/YGUGmsW3xwhRCNlWAja\nJbdv4HOe/Pp3SOedb7adNAGsP2TQKj2ehLi6zd5FzAhf7l5EvPX4gfC277fzxSuLiEuKo2hLMVmd\nmnPhQ6MRQrBp8WZmPzcXq91Ky4JD/X9/uq50w5cb+fL1rzAiBnGJcVz48AW4Ug8/pxCCBTvmxSyA\n1TWd7PhsiiuLmuRnjSlNQJDhzGzsoSiKoij1qGleQj1BLRNyyXbl4Av7qt+4CUj3lZDhKyFY18Iw\nUmJKSYojtZGSLJsmMxgksmEDxs59CFmONUtDS02tU/D6c0IINKcTLTUVnE4qP5pJ8YSJ+D+YjjRr\n1p9UqZ5Vs9K3eV+8DfzajpgRLJqF/PSCBj3vqWBQl2ZoQmCaTTzl9ICwIbmwV4vqN6zGXt+eqr+b\n6uzbsI9zbz+HX715PeW7y9n5wy4iwQifPP0Z4568hEkvT8Bb6j3qvi0KWjDhn9dw3SvX0vWcLnzz\nn8VHbOO0ONlQtoFYFmtsn9yeoBGM2fFiKWgEyXHlqB6wiqIop7hTKoAVQnBVl19gYmKYjVPwpTby\n966J/iMGa1/tur3e+wyeLKQEo6iYyNq1SL8fLDbQNBzJ2+v1vMJiQUtLQ8TF4fnbc5TddgeRXbvq\n9Zynk7NbDAaI6Zfx6vjCPvpn9W+Ss01NXUq8jcK2qXgCkcYeSrXCERO7RaOwTVr1G1djl3cXUtbs\n4lVWlywSMxMRmiCzfSYVeyoo2V5CclYSqS1TEUKQN/zos6ee/R7e/s1/eWnCy3wzdQnFW4qP2EbX\ndCLSoCRQUqfH9FNtkto2Wjp/dYJGSGVLKIqinAaa5qdQHbRKbM2w3OF4w0e/at1U2CJBuhZtIFDH\nL8YHv8w3j886adKm61PVrOuunaDp0aJMgDRs2Fx7EXr9zxwImw2RlkZ43TpKJk5Ss7Ex0iKhBW2T\n2+EJNcxr2zANhNAY1HJwg5zvVDSqew6Shr3ocCK8wQgj8rOwWer+kbilYjOyhlVwLdZDs7SarmEa\nNX+fmPXX2fQaewY3vH4do+4ZQSR09AsFgmhQHSsdUjoeyPppWu9pUko0BAUZKltCURTlVHfKBbAA\n57U5n/S4jCadSty2bDuaNDG1OvwKpMSQBmlx6dhVf0pMv5/IgTY4WKw/m9kWIMDm2tcgYxFCoCUn\nV83Gup/6EzLStGaipJRIGUTKUJMPMA66uss1aEIQNsP1eh4pJZ6wlxGtR9I8Xq1nPlGdshJokxHf\npGdhQxETq64xLD82v+dd3t116heclptGxZ4KynaVAbB6zpqjbhf0BUnIiGbd/PDpD8c8XsSMUFJ5\n5OzsiUqyJ9E9owfeBrqQVFNBI0iyI4UOyR0beyiKoihKPTulijgdZNWtXJs3iWeWPt1k2+p0Kt4U\nbZ1TBwdTh1NU5WFMr5fIpk2AqJp1/TlpatgSdhOsyG2wcQmbDVJTCcz6HOn1kPTwQwh7w/cqljJI\nMPg94fAagsFvCYVWYpol8JNV05qWgc1WgN1eiM3WBZutB0I0rQsjmc5MLmp/MdPWv0uSPanesg68\nYR/Nnc0Z0XpkvRz/dCGE4OZhHbnv7e8JG9FAsSmRUuILRpg0qB3pCbF5XYbMYJ1aPlnsFkbdO5J3\n7n0vWsSpewtC/tAR2w28dgAfPDQdR4KDVme0onxPxbHHZBy5f10MyR3KiqLlTapgYtAIcVH7i5vM\neBRFaZqklJglJUS2bMEsrwBpIux29BYtsbTKRRzjO6TStIiTYealsLBQLl26tNb7zdg4ndnbPifJ\nHpvG9LFiMcLc+O2bBCx25AkGsfJAClduYqvTfvbV9PmIbNwYnXE97sUKiWYJUb55CNJs2OdMSoks\nKcF+Zn+SHnu0wd4gI5Gd+Hzv4vVORcoQEAasaJoTsFV92Yu+D4QwTT8QRggr4MDlupr4+EuwWJrO\nLKQhDf618kVWFq8kyZYY8y+s/rAfTdO5p/BeNfsaIzO/28VbX20h2WltUgFGhT9Mx6wEHr44dr2c\n/7j4D02qSm9ZoIwL241hZJtRMTumlJLHvplMWaC02mrLDSFshAmZYZ4Y8CROq7Oxh6MoShMU2bYN\n/4wZBGbPRfp8oOtwcHmXJgABpom1axecl12GvX8/hFX1lG5oQohlUsrC6rZrWpfDY+y8NufTPD4L\nd9DT2EM5TI57L0CdgldDGqSr1GHMysrozGu1wSuAACmwOEsbZGyHnVkIRFoawa++xv3U0/W+JjYS\n2UNx8c3s3TsKj+dlhLCg6ynoeia6noIQ9sO+sAshEMJetY2mRXvjejxT2Lt3OCUlv8Ywiup1zDWl\nC51JedfTJbUrFSF3TNfieUM+NKFzR887VfAaQ6N6ZNMmw4W7sumkEgcjBromuOmcjjENqm26rcZr\nYBuChDqlNB+NEIKru4wnYkYwZOMWTJRS4ov4GdvhEhW8KopyBGP3HsruupuSa6+jcvoMEAKRkoKW\nlISWkhL9LykZLSkJkZREeN16Kh59jKKxl1I5e/ZJs8TqdHNKB7BW3crtPe8g2ZHcpNbrtC/ZijjB\nF8TB4DXZnkKy4/ROHZaGEQ1eJTUIXg/sA9hce+p1XMcihECkphKYPQf/u+/VyzmklHi977Nv32gC\ngS/QtFR0PQMhap8eKYQDXc9A01KprJzD3r3n4fN90iTezK26lRu730T/rP64Qx4qI5V1Op5hGlQE\n3STZE/lN4T3kJraK0UgVAF0T3DGyE067jrcJrIcNGyb+oMFNwzqQmRTbmdKs+CzCRv2u0a4Nq2Yl\n1ZEa8+O2S27HoBZDGv2z1RP20C6pHQNyBjbqOBRFaVqklPhnzKB44rWEVqyIBq2padFCm8e4aCk0\nDS0xES0lBaTE/cQfKb//AYyS2FVyV2LjlA5gARLtSdx5xq+JszobrHppdXIrdhE6gSviB4PXRFsi\nGc6M077nq7FzF0Qi0TSQGpKmBauzFBpphkRoGiIpCe+//kVk27aYHtswyikuvp7y8ocQwoaup8ek\n3YUQGrqeDuiUld1DScmtmGbjv5YsmoWru47nlh63YdVslAfLa73Wz5Qm7qAbb9jH0Jbn8GC/R8h2\nZdfTiE9vzZLieGhMProuGjWIDRsm3kCE6wa3o3+HjJgfv21SuyY0/woSSY4rp16OfWG7C0m2pzRa\nwcSQEUITOuO7TURroq19FEVpeFJKPM/9Hc+zf0M4HGgpKbXOtBEOByI1jdC3Sym98SYiu3bX02iV\nE3FavOOnxaVzV6+7ibfG4wk1bjqxLRIiIeQjUsvCUj8NXps5m532wavpdmOWlUarDdeGFAgtgtBj\nW9SkNoTVCqak4g9PxKwysWEUUVR0NcHgYjQtAyFiv/5O0+LQtHQCgf9RVDQRwyiP+TlORNe0rjzS\n/1EuaHsRmtBwhzy4Q26CRvCI2WIpJREzgi/soyJYgTfso3tmT+7tfR9jO14S81RL5XC56fE8cnE+\nNovWKJWJgxGjKngdllc/KeLZrpwmE0wZpoEudNLjYh+oA9gtDm7sfhNCaHXOgqitsBmmMlLJxK6T\nSI9Lb9BzK4rSdEkp8b7wDyo/mI5ISYkW0zxBQgi01FTMsnLK7rgTo6hpLKVSTpMAFqLVS+/pfR/J\n9hTcIXejpUGm+cswhPazFi/HdyhtOJlm8c2bVBGUxiANg8i27XBCLYgEUgp0e+NeyBDJyUQ2bMQ/\n7f06H8swyikqmkAksu1AunD9/X0IoaFp6YTD6ygunoRpNo315U6rk5FtRvHEgKf4Zf6v6NO8Ly5r\nAu6QG0/IizfkxRPy4gl5MKWkQ3JHLm5/CX846wmuz79BpQw3oNYZLh67tICUeBvl/jCGWf/vxVJK\nKvxhwhHJ7SM61VvwCtEUYl1oRMzGT5WujFTSLrldvb4ntEhoya09bsOQZoMFsWEjjC/s46rOV9Oz\nWc8GOaeiKCeH0Fdf4582LRq81iJD73i05GTM0tLoxEMTWEalnOJViI/GHXIzZfk/2ObZhssaj0Vr\n2HLZ+XtWM3jr1/htNSs2YZgGEklaXBqpjrTTfuYVILJt+4nNvh6gWQL4izsSLG8b45HVjgyHkX4f\naf96CUurEwugpIywf//VhMM/HkjzbRhSSkyzGLu9kPT0V2KSqlwfQkaIimA5YTOMJnScVicJ1oTT\n/iJQUxAMG7y7eDufLN+NRRe4HPXzXhyKmHiDEbpkJ3LTsI5kJtZ/deB3173D/3YuaPQK+O6gh191\nv5G89Px6P9eWii08//3fCJthXFZXvb3G/GE/EdNgfLcJ9G7ep17OoShK0zV9+nQuvvhi1qxZQ+fO\nnQ+7zywvp/iaCWCaiLi4o+7/ya5dtEtIoFNiYq3OO3XrFpbv2cPzU6bwxq6dOJ1Oxo8ff8KPQzk6\nVYX4GBJt0SItF7cfS2UkgDvkadCrKdnefcgafLAfTHW0aBZaJuSSdiB43VpcSd6DSw7bdvL0LTzz\n6fbjHm/pFje3v7UBgAVry/hqw7F7Bh5L67u/pthzZOrtKwv3kP/gtxQ89C15Dy5hxnfFALy2aA+7\ny4LVHrem2wGYwWCdgleI9oO1NkIl4p8TVisYJr433jzhY3i9rxEO/4CmpcVwZNUTQqBp6QSD3+Lz\n/bdBz10bNt1GhjOTbFcOzeObk1gPbXeUE2O36lw9oA2PXppPstNKuT+EPxSJ2ftxKGJS5gsRiphc\nP7gdD1+c3yDBK8DAFmcTzfZovAvEISOE0+qkS2rXBjlfm6Q23N/nt+QmtqYi5CZsxraQVbTQWgUu\nWwK/7nWXCl4V5TQ1depUBgwYwNSpU4+4z/fvt5Be7zGDV4BP9+xivdt91Psix+kQIRAIqxXvP/7B\nL8ePV8FrIzstu/Xqms6wVueSl57Haz++yg7PjgabjU2urMAQx09pODjrmuJIJc2RhhaDL9yFbRIp\nbBO92rRgbTkuu86ZHeo+O7CzNMAfZm7ju8mFJDkteAMRijzRLy6vLdpLXk482SnHr4Bb0+0AzOK6\nV4KTUkezBOp8nFgQSUkE/reQhFvLolXvaiEc3khFxd/RtORGCcqiQWwSFRVP4XCchcXSssHHoJz8\nOjRP5E9XncFXG4r48Ltd7KsIIIAEhwVNq93ftZQSX9DAMCV2q8aYXi0ZltectITaV+Gui+bxWbRN\nasdW9xYSbK4GPfdB/oifC9uNQa9lvYW6yHBmclev37Bw5//4YMM0/NKPy+qq0xhMaeIN+5DSZHDL\noVzQ7kLsesP+PhVFaRq8Xi+LFi1i/vz5XHDBBTz66KMsWLCAZ555hg/ffZfKj2by261b6OHxcEXr\n1jz+w0o+37MbXWgMbtaM83Ny+Hz3br4uKuIva1fzSr8z+fWypeQlJ7O4uJiLW7aknSuBZ9euIWSa\npNhs/F+fvmQ6Dlz81HVkKMRDN9xASs+e3H333bz00ku8+OKLhEIh2rdvz5tvvonTqVp61bfTMoA9\nqHl8FvcU3sf8HfP4cNMMTGmSYHPVawGO+HAlxjHWbprSxJQmVs1K8/gs4iy1ny0Y/OT39G2byPy1\n5ZT7I7w8qRMDOyazYG0Zz3y2g+ev7sCU+bvRNcG/v97H36/uQOfmTm58Yz3bS6KzoH+9qj1ndUii\nxBvmyimr2VUWpH+7xKNW1tzvDpPg0HE5ol9QXA4LLoeF977dz9KtHn7x4hrirBpfP3gGf/p0Bx8t\nL6EybHBm+yT+OaEj05YWHbHd6t1+7np7I96AQbrLymvXdyYr2c7fZu1gyudbsGiCLmkW/j26dukf\nVaRAs9Rsxre+CV1HmiaVs2YTf/m4Gu8npUlp6X3RY4jGKzwkhB3T9FJa+lsyMt5Qs5vKCbFbdYZ0\nbc7gLs3YsNfDZyv3sHhjMUIITCkBicOio+ui6oJetDaAJBg2iZgSi6ZhmCZtMlxc2KsFZ7ROxWZp\nvCSjyztfwZNLnqjKpGlI/rCfVEcag1sOadDzAmhCY3DLIXRLy2P2tlks3vMNhjSw6zbsur1G7xFS\nygNFmqIXGvPT8xnRehStk1rX8+gVRWnKZsyYwciRI+nYsSNpaWksW7as6r7gwoXISLiqPkppMMgn\nu3fx1fCRCCGoCIVIstkYkZ3N8ObZXNCiRdW+IdNk9jnDACgPhfh0yFCEEPx7y2aeX7+Oxwq6HxqE\nzU74h1XQM7r+fuzYsdxwww0APPjgg7z88svcdttt9f1UnPZO6wAWDp+NnbFpBquKViKRxFniYl+R\nVEriQ34qrXGH3WZIE4lEExrpcekk21PqNOsaMSVLHu7FJytKeHTGVubc06Pqvtbpcdw4JBuXXefu\nUbkAXDVlNb8e3oIBHZPZXhJgxJ9XsuaJPjw6YysDOiTx8EWt+XhFCS9/sfeIc3XPddEs0Uabe77h\nnK4pjO2VzgU90rm0dybPz93FM5e3q5r5vfWcHB6+qDUA17y4hpkrSo7YLhwxue3fG5hxex4ZiTbe\nWbyf303bwivXdeapj7ex7poE7A4b5YFjp3lUTyC0EGDSFLLohdOJ/53/4rz0khoXHAgGvyUcXt/g\nqcNHo2mphELLCYdXYbPV/1o75dQlhKBjViIdsxIJndOBXaV+tpf4WL/Hzdo9btyVEUIRE1NKrLpG\nnM1C1xwX3XKSyE2PJzfNictx4ssLYinHlcN5bc5n5uaPSGrA1HVDGoTNCBO7TWrUmcoMZwZXmaZr\nhAAAIABJREFUdfkFY9pfzLJ9S5m3fQ5FlUXoQseQBprQ0ISGOFDZwZQmEdPAoukY0sRljef8NqPp\nl92flNO857miKFFTp07ljjvuAOCKK65g6tSpjB49GoDQN4vhJxNQiVYrdl3nzmVLOTcri+FZx26R\nN6bFoQyy3ZWV3LD4G/YHKgmZJrnx8YdtK5xOTI8HWRktWrdq1SoefPBBysvL8Xq9jBgxImaPVzm2\n0z6APah5fBa/KriR8mA5X+/+ivnb5+IOutE1HafFGZMvHzYjhACkEFWVhQEcFgepjlSclvhqA1dx\njDJOPx3f2F7Rlgm9Wiewtbj6VNk5q8tYvftQHz93ZQRvIMLCdeW8f2seAOd3TyMl/sg/F10TfPab\nAr7d4mHu6jJ+PXUjy7Z6mDymzRHbzl9bztOfbscfNCn1hemW4+SCHocXHlq318+qXT7OfWYFAIYJ\nWck2JJCfpjHhcz8XdjC5sH1dvpgJQEPoIaRR/2vitvt8XP3VIhaee+hN7enVPxJvsXBLx04IhwOz\nrIzQsmXY+xxa17V06VLeeOMNnnvuORYsWIDNZuPMM88EwOt9AxDV/l326fM1n37ai7Q02zFvX7nS\nww03/Mi//tWN3buDrF/v47bbal5U6uAYvN63SE19sur2g2k9M2fOrPGxFOUgm0WjTaaLNpkuBnVp\n1tjDOSHnthrOd/u/Y69vD4m2hHo/n5QST8jDkJbn0C65Xb2fryacVicDW5zNwBZn4w/72eXdxS7v\nTrZUbMYX9hE2w1g1K3bdTqvE1rRIaEmOK0etV1cU5TClpaXMmzePH374ASEEhmEghOCiiy7CNE1C\nq35ExMURPLCO1aJpfD7kHL7Yv5+Pdu3klU0bef/swUc9ttNyaPLgt8u/58YOHRmZnc2XRfv50+rV\nh20rhABNYJREa6lMnDiR6dOn0717d1577TUWLFhQL49fOZwKYH8m2Z7MqDbnMbzVCFaVrGLuttls\nqdgcfbFIA7tux6bZarWmp6ogk7+UsJQYplF1riR7MvZazPSmuSyU+Q5vz1Dqi9Am/dCsrt0S/dDX\nNYgY1RcRMaXkm4fOwGE9sXVKQgj6tE2kT9tEzu2WwrUvrzsigA2EDW5+cz1LH+5FyzQHk6dvIRA+\nchZVSuiWE8/XD55x+BiDQaaPdvLFXsnHm0M8udjPdxNSsNRyjdyhE4GmhzAaIICtqcCnnx0WwBYW\nFlJYGC3EtmDBAlwuF2eeeSaRyB4CgYVoWmqdz7l6tZcbbviRKVO6kp+fQH5+AiNG1L6asaYl4/d/\nSlLSfei6mi1RFACLZuHm7rfwzLdP4Ql563U9rJSSipCbbml5jGl/cb2dpy6cVicdUjrQIaVDo6Q3\nK4py8nrvvfe45ppr+Oc//1l126BBgzBNk9U//khl67YEExP5Yv8++qal441EqIxEGJaVRZ/0dHp/\n9gkALosVb+TYRebc4TBZB4pAvbNt29E3MsxoQVHA4/GQlZVFOBzmrbfeIicnJ0aPWDmexs+fbKJ0\nTad7RnfuKrybyWc+xrV51zO81QiyXTkEjCDukAdPyENZoIzyYDkVwQrcITfuoJuKYAXlgXLKA+V4\nQ17cITe6ZqFzSgeSHMnkJOTQLrkdmc7MWgWvEF1jmpVsY97qMgBKvWE++6GUAR1rXpApwWHBEzCq\nfh7eLZW/z9lV9fPy7dHenmd3SuY/3+wD4NOVJUcEzgC7y4J8t9Xzk329tEq3H3Geg8FqeoIVbyDC\ne0sPNYP+6XadspwUeUJ8vTFaJTkcMflxlw/D52eH12Rwro0nBsbjDkq8odpV+Ex97tA5JYBoGi2k\nxvxvAb/ftpUhf/sbHTt25IsvvgCiQevo0aPZunUrU6ZM4dlnn6VHjx7Mnfs8JSUhbrhhNaNGLWPU\nqGUsWRJ9vkpLw1xxxQoGD17Cb36zluMVQd240c+kSat47rnO9OwZTfN+5509/Pa36wG48841PPjg\nBi644Dv69fuGmTP3A2CakgceWM/AgYu5/PIVXH31Sj7+uBQw+Oijv9C5c2fOOOMM3n//UI/b0tJS\nxowZQ0FBAf369WPlypUATJ48mQkTJjBw4EBatWrF+++/z7333kt+fj4jR44kHI5tJVNFaWgpjhR+\nXXg3CbYEKoL104PclCYVITddUrtyff4vG3zNraIoSn2bOnUqF198+MW5Sy65hLfffpvLLrqIwd8u\n5oYli8lLjl5E94XDXP3VIgbNnsUFC+bx6IF1rGNatOSF9esYOmc2W7zeI85zT9euXPfN1wybO5tU\n2zG+o0uJDEW/nzz++OP07duXs84664i2Pkr9UZ9yNZAWl05aXDo9M6MLtqWUFFcWscu7i/3+/QSM\nSoJGiJARQhcaNs2OXbcTb4snx5VDtiuHeGs8FK+HFdPAUrfqZG9c34Vb/r2Bu97eCMAjF7WmXeax\nS4b/3AU90rj0hR+Z8X0xf7+6A8/9oj23vLmBgoe+JWJKzu6YxJQJnXjkotZcOWU13X63hDPbJ5Gb\ndmTabtiQ3P3OJnaXB3FYNTISbEyZ0BGAiQOac+Mb66uKM91wdhZ5D35L8yQbvdscKsD08+3eu6Ub\nt7+1kYrKCBFDcufwFrRtK5n4mQ932IeUcEvPOJIddbn+IppMAAsQEYJPu/fg21tv5tFHH2XOnDlV\n97Vu3Zobb7wRl8vF3XffTXHxzVx//X5uuKE1ffsms3NngKuuWsnChX34y1+20qdPEnfd1Zo5c0qY\nOvXIdcsHXXvtKv7+9y707Zt8zG327w8xY0ZPNm70M3HiD4wencknnxSxY0eA//2vD8XFIQYN+pYr\nrmhOIAC33PI3FixYRvv27bn88surjvPII4/Qs2dPpk+fzrx58xg/fjzLly8HYNOmTcyfP5/Vq1fT\nv39/pk2bxtNPP83FF1/Mxx9/zJgxY2LwDCtK40mPS+ee3vfxzxX/x3bP9phWva+MRD9/+mefyRWd\nrlTBq6Iop6T58+cfcdvtt98OgFlRwd2rVqOlHp6Z9vnQYUfs0zc9nUXDR1b9PH3Q4MPuH5Wdw6js\nI2dRr2jdmitatwbg7tZtSLjwQgBuuukmbrrpplo9FqXu1CfdCRBCkOHMJMOZWdsdY3L+rjnxzL+v\nx1HvW3B/z6p/pyfY2PpMfwAGd05hcOfoVamOzZ2sfLz3Yfu9c3O3I46V5rIy6+7uR9z+U63SHcw7\nxlguKczgksKMqp9/f0lbfn9J22q365GbwMIHeh62TXjdehZckQR1bAnhDUkumVFBecAkGPya+7sW\nMCo7h+0+H1cs+oKClBR+KC+jU2Iizxf2wWmx8Mya1czas5uAYdA7NY1nzuiFEIIx/1vAGampfFm0\nn4pwmL/2KqRfesYR5zzWb/2nt5+f0wIsFrqnprJ169bjPoZQ6AcWLfKyYcOGQ4/LG8Hni/DNN+W8\n/HJ03fKwYWkkJx/7JT5wYAr/+c8eBg9ORdePPsqRI9PRNEHHjvEUFUWvNi5ZUsHo0RlomiAz086Z\nZ0YD4M2bBS1bWujQoQMAV199NS+++CIAixYtYtq0aQAMHTqUkpIS3Af6sI0aNQqr1Up+fj6GYTBy\nZPSDJT8/v9rnQlFOFsn2ZO7ufS8Ldsxnxsbpda56HzEj+MI+XFYXN+T/ii5pDdPvVVEUpakRTicg\nkaaJOEanj5ieT9fQXI3TIk2JUinEDUnoHDenUzkqKSUyUFlVGr0uHBZ498JElkx0MeOcQh5ZuaIq\npW+j18O1bdvx5fCRJFisvLp5EwDXtWvPrKHDWHjuCCpNg1l79lQdLyIlnw8dxu8Lehyx0P+gFLud\n8lDosNvKQyFS7YdmtO26BpEI5rbtRCJHpmofZBhlmGYZpgkzZ57BnDm9mTOnN999dybxRymydTx/\n+EM00HzggfXH3MZmOxTYVp/6aEPKIKbpr9U47AeeB03TsFqtVYVbNE077nOhKCcbXeickzuM3/Z9\nkG7p3fCGvFQEKwgbNUuVl1JSGanEHXITNEIMbjmUh/s/qoJXRVFOa8JqRW/RAoIN0yJR6Bb0NkcW\nK1UajgpgG5Jug6N2U1WOR4ZCBxet1v1YEh5a5OOMVz2MnbeMvZWV7D/whpcTF0ff9GgBo0tzW7G4\nuBiARUX7GTlvLoNmf86i/ftZ53FXHe/8A2kmBSkp7PD7OBqXxUIzRxxf7I+uIS0LhZi3by99035W\nLEnXifz441GPkZCQgMfjwTB2AFYGDUrllVcOrVtetSq6Drlfv2Q++CC6bnnevBLKy48dAAoBL7zQ\nhY0b/Tz99JZjbvdzvXsn8cknRZimpKgoxNdflwPQoUM8O3eGWb/+ayC6XuWggQMH8tZbbwHRtb3p\n6ekkJp5gH19FOck1j2/OTd1v4bGzfs+oNueDELhDbjwhL+XBcjwhD76wD2/IiyfkoTxQEQ12Q25S\n7Clc1flqnhr4NJd2vAyntW5LUhRFUU4F1ry8qtY29UlKiYxEsLRVAWxjqrcUYiHEK8BoYL+UMu/A\nbanAO0BrYCswTkpZVl9jaHLiUsBUM0q1Fg7HInYFYOqaIMV+yZLxLnw7BnPGzDkEjWgBqZ+3bBAC\nAobBfd9/x+yhw8hxOnl69Y8EjEMFsOx69BqQLgTGcWYon+/dh/uXf8fDK6PrPu/u0pU2P08/sVox\nDgS5P3fBBRdw6aWXMn36VB5+WPL44+357W83cM453xKJSPr1S+Kppzpx112tufnm1QwevITCwiRy\nco7fbsjh0HnttXzGjv2ejAwbTmf117TOPz+DRYvKGDRoCdnZDvLyXCQkWHA4dJ56qiUXXXQD8fHJ\nDBw4EI8nGlhPnjyZSZMmUVBQgNPp5PXXX6/2PIpyqktxpHJ+29Gc1+Z8yoNl7PLuYrtnO/t8ewkZ\nITShYdfttEzIpUVCS7Jd2dF6CoqiKMphHAMGEPj883o/j3S7sebnoTnVxcPGJOqjIiKAEOJswAu8\n8ZMA9mmgVEr5pBDifiBFSnlfdccqLCyUS5curZdxNigpYUpPsCfWeS3n6cR0e4hs2Qx63a63pD5X\nxKMD4tlUZvDcCCsffdWDsV98wdKR5wFQ+NknfDx4KL3T0vj1sqV0SEjgF63b0H/WZywbdT6GlJw3\nfy6jc1pwb9dujPnfAiYXFNAjJZWSYJDh8+awbNT5Jzw+WVmJlplB+quvHHObQGAxxcU3ouvHLrzU\nEHy+CPHxFkpLw5x//jJmzOhJZqYdwygnM/N1bLaCRh2foiiKoiinDxmJUHzpOGQkgnDUX4tEs6yM\n5McexX7WmfV2jtOZEGKZlLKwuu3qbQZWSrlQCNH6ZzdfBAw+8O/XgQVAtQHsKUMIcKZB2K8C2NqI\nwUWWiCmx64IrOzsYO72CHi+HyY/fQYeEhKpt2rsSeGXTRu5c9i0dExKZ2LYdTouFa9q05ezZn5Pp\ncNAjpe69V49JCPjZWtkjN7HFqhZYnYwf/wMVFRHCYcmdd7YiMzM60xsd2/FnfRVFURRFUWJJWCw4\nLx+H98WX6i2ANX0+tKQkbH371MvxlZpr6CrEzaSUByvg7AWaNfD5G198JpRubOxRnFxiELCtLjZo\nm6yT7tRY+IsEpOHAvf1QJebtPh8WTfB/ffoese8D3fJ4oFveEbf/tPR6mt1ep9nXKvrxL2xoWjJS\nmnU/Tx1Nm9bzqLdLaaBpNe9JrCiKoiiKEgvOsRdT+cknGHv3oSXF9ruINE0IBEh87FGERTVxaWyN\nVsRJRnOXjzm1JoT4pRBiqRBiaVFRUQOOrJ4lt4FIw1RJO2WcYJuJg15cUck1H7uZfFb8gcOZGOEm\nuHbBNBHHapp9gMWSC0QDxaZGyjBCOND10++6lKIoiqIojUvY7SQ9+DswzWgB0BiRUiLLSnGMHIG9\nd7XZrUoDaOgAdp8QIgvgwP+PXrEGkFK+KKUslFIWZmQc2VvzpJXVE5rADNpJRavbFOwvu8ex4tpU\nzm0dDQ6FMIlUHp4KnBsfz8JzR9TpPHUlpUTYj59+K4SO1doRKeu/0l5tSenHZss7ohiWoiiKoihK\nQ7B26kTi3b9BetwxCWKllMjSUqxdu5F4+20xGKESCw0dwH4ITDjw7wnAjAY+f+NL6wSaSj2oDWGz\nx7R/rpQaRjCh+g0bWiCApUOHajez2wuRsna9VhuClEHs9t7Vb6goiqIoilJP4kaNJOGeu5E+L+aB\nbggnQkYiyNISrHndSH76SURcXAxHqdRFvQWwQoipwNdAJyHETiHEdcCTwLlCiA3AsAM/n15S20db\n6dRT9edTktUSrUAck+dMIoTECDXBAFbTsHbtWu1mDsdAoGkVAYuuCNCw21VVPkVRFEVRGpfzvPNI\n+dtf0VNSMEtLkOFwjfeVUmKWlyM9buLHX0PKn59Bi1ctzJqS+qxCfOUx7jqnvs55UrA5IbEFBMrB\nqq7k1IQAhNOJ9Hrq3EoHYSINK9I4/lrTRqEJLG3bVruZ3d4PXU/DNP1oWtNYyyulF4slV7XPURRF\nURSlSbDl5ZH26st4//0Wle9/EJ2NtViiM6kWy2FLnqRpIgMBCFQCAltBPq5bbsZag8w4peGpXNbG\nkDsAVr2tAtha0FwuDLe7zhOPQosQ8mTFZlAxJE0TTImlVW612wqh4XJdS0XFn4CmEsAGcbmuV+tf\nFUVRFEVpMkRcHAk3XI/r6l8QWLSIwKzZhNeuQ5aVIXU9OksiAdPE0ioXW58+xI0+H0uLFo09dOU4\nVADbGNoOgx/fbexRnFREXFydizkdOBJhX/MYHCfGAgEsubkIq7VGmzudF+J2/xUpgwjRuH1XpQwg\nhAOns3GLYCmKoiiKohyNiIsj7txziTv33GiKcGkpssKNNA2E3Y7evHmNv4MpjU8FsI0hqydoWnQt\nrCroVCPCGXeg6ZLkxBvDSoSA8M8qEDcFMlCJrRal2XU9mcTE31BR8QSaltFoM59SSkzTTUrK75tM\nOrOiKIqiKMqxCCHQ09IgLa2xh6KcoEbrA3tas9ijacRBd2OP5KQhLBZEUhJETrz/qdAiRCqTwWxa\nFw2iBZAEceeNqtV+LteV2GzdMc3S+hlYDZhmCXZ7f5zOMY02BkVRFEVRFOX0oQLYxtLhPNUPtpb0\njHQOTMOeEKGZBJvi+lePB2uXzlhat67VfkJopKT8ESF0TLPh+8Kaph8h7KSk/F6tfVUURVGUU4CU\nEtPvxygtxaysPHCRXVGalqY1FXU6aTUIdDsYIdCbYEXcJki4XGCzQSQCWm2rOZlIKQh7m+D6V9PA\necUVJ7Sr1dqKlJQ/UVp6J1JqDbYeVsoAUlaSnv4PLJYm+JwqiqIoilJjRmkZgVmz8P/3v5hl5QeW\nuploqSk4x40jbvi5aCkpjT1MRQHUDGzjsTmh22UQUGnENSUAPbMZmLWfudYsYUKebKTZtBboy2AQ\nEefE3q/vCR/D6RxGSsrjmKYbKQMxHN3RmaYf0/SSmvoMDseAej+foiiKoiix5XK5AJCRCO7n/k7x\nuMvxvvgSMhRGS0tDS0lBS0tDBkN4//kiRZeNw/P8C8hIpJFHrigqgG1c3S4/UL5bpRLXlJaSDEKr\n5XMWTX8JVlTfoqahSa8X52WX1LnyXXz8xaSm/hnT9GMYZfWS8iOlxDBKgRBpac/jdA6P+TkURVEU\nRWkYMhSi/Le/o/KDDxAJCZjJyQiH47BthMOBlpqKSEjEP20aFQ89jAyHG2nEihKlAtjGlNIamveE\nQEVjj+SkIXQdPScHjJoXcxJaBCOYgBFMqMeR1Z7p9aKlp+G87LKYHM/pHEFm5jtYLLmYZjFSxu4D\nRsoQplmE1dqBzMxpxMUNitmxFUVRFEVpeO4/PcP8WbO46IeVjF/8NQNmfw7A+K++ZNjc2Qyc9Tlv\nbN4MRL9/tf1iIZP/8x/yW7WiX79+7Nu3rzGHr5zGVADb2ApvjLbTUYvka0xLT0PEu6JrYaslEZpJ\nZWk7Trz9TuxJw4BgkKQHf4cWFxez49psnWnW7D0SEm7GND0YRhFShk58nDKEYRRhmj6Sku4iM/Nt\nrNa2MRuvoiiKoiiNQEoCc+chEhL5obyc33fvyTcjot0Q/lbYmznnnMusc4bxr00bKA0GAfAbBr2y\ns5nbuSsDCrrz0ksvNeYjUE5jqohTY2vZH5r3gP2rIE4tjq8JAVha5RJesyaaSiyOfR1GaGEiQRdh\nX2bDDbAGZEU5cWMuwta9e8yPLYSNpKSbcTrPx+ebis/3LqbpRggrQjgR4vjpylKGkdKHlBGEcJCQ\nMIn4+HFYLC1iPlZFURRFURrBgUkAoQl6pqbSKj6+6q6XNm7gk927ANjl97PZ6yXVbsemaYzIzkGW\nldEtEODLrVsbY+SKogLYRicEDLgP3ruy2mBMOUTYbPx/e3ceJWV953v8/a2lV+gGm0UCCMimCAiK\nuKCCiuIWcRlUYhSduTreJEa9eu+J5hoZjRmjicZEh1xXiNdlHE1mjCvImDgTjdpssg8uiCA7dDe9\nV1d954+nUBSQraqfrurP65w6VFdXPfX5UX2qnm/9tmjPXiRXfwax3f2fORZxGjYdRlvqfU3V1hKp\nqKDDNVdn9Xni8T506vQjysp+SEPDTOrr/5Xm5sWkUjUEgy9a8PRcYrMIwdtBCrNiCgqOorT0QoqK\nTiMSKfqGZxEREZFckqqpwZNJrKwMtm6hJPplOfCXjRt4a8N6Xhl3KiWxGOf/+U80pYJpWzGzYNu8\nsjJSCxaQGHpEWE2Qdk4FbFvQfRj0HQef/hlKuoSdJmdEulSQqqrCa7dBbOdeRYs2k2joTEvDQSGk\n2zVvaoJEgvKf3JbRocPfJBIpobT0fEpLz08vxLSORGI5qdSXw4vNCohEulNQMJhIpJv2dRUREclT\nLdvntcZ2LgNqEgk6xQsoicVYUVPDnC2bd7qPxWI4jtfWZj2ryK6ogG0rTrgJVv2H9oXdBwbE+vWj\n5cMP8Yb6rxWxKcxoU72v3tyM19ZSdvtPKBg2LJQMZkYs1oNYrEcozy8iIiLh8vqG3f7u1O4HM+Pj\njxkz8zX6d+jI0QdV7P442lJHQmLZ2G4j00aNGuWVlZVhx8i+OY/AX38FJV2DocWyV7ylhcSKD6Gp\n8Ysi1mJNNG7pR+OWQSGnC3hTE75tGx1vvomSc88JO46IiGRZMpVkff06apq3kfIU8UicriVdKS8o\n1ygXCVXT+5VU/fjHRMrK9/sYXlNNp5/fTcHIkRlMJu2dmc1x91F7up96YNuSEVfBildh60dQ3HaG\nvbZ1FosRHziAlo8+whsasAInlSihcWv/sKMB4I2NeF0dZbf8iOIJ2jtVRCRf1SfqmbthDv+55i3W\n1H6OAfbFhg9O0lMUxQoZ1HkwY3uNY1DnwSpmpdVFKyogmcTd9+vvz93xliSRLpr2JuFQAduWRGNw\n+j3w3EUaSryPLBYjNmAgLZ98CE1V1H52FHg01EzujldVQTRC+Z3/QNGJJ4aaR0REsqM52cwrn7zM\nm5/9O8lUkoJonA7xUiJfW5jR3Ul6koWbPmDhxg/oVNSZSwZPZmiXoSEll/Yo2q8vsd6H0LJuHdah\nwz4/3mtrifXvT6x378yHE9kLWvK2rakYAMdeDw1VwarEstcsYsQOLscHXEpLVQGprVsJa4i8Nzfj\nWzYTHzSIiscfU/EqIpKnPqn+hJ/+9Q7e+HQmxdEiygvLKI4V71S8QnodgkiMsoIyOhZ0pC5Ry7QF\nD/HEoseoT9SHkF7aIzOj5DuXQmI/94lvSVA6+dLMhhLZBypg26KRV8GACVC/GXJgjnKbUb8J63My\nBVc/TMXjjxIfPBjfshlv3s836P3g7kHh3NBAxx/8gM4P/ppYL+2fKiKSjxZsmM/9c35BTXM15YXl\nRCN7P/LHzCiOFVNW0JE56yu5t/LnVDVVZTGtyJeKTjqJSFkZqW3b9ulxqZoaIuWdKBxzQpaSieyZ\nCti2yAxOuwsqBkLj1rDT5Ib6LVDeG864FyJRYr160fnBX9PxuuugsZHUli14Y2PWnt5TqaBwrdoa\n9Lo+8RglF12IRcMdxiwiItmxZPNiHl34MIXRQkrjpft9nIhFKC8sZ2P9Rh6Ycz+1zdqaRLLPiovp\ndPc/YgT70++N1LZtWCRCp3vuxgoLsxtQ5BuogG2r4sVwzj9BvBSaasJO07Y110KsEM79LRR2/OJm\ni0QoufACKp59hg7XXI0VxElt3UqquhpPZWZ4tjc1kdq8Ga+qovC44+j8i3vp/E8PqtdVRCSPVTVV\n8ejCRyiMFlKQofUqygvL2NCwgaeXPRXa9BdpX+KDB9P5/vuwWCw4l2lq2uX9tp/rWGEBnR+4n/iA\nAa2cVOSrVMC2ZR17BEWZe1Ckyc4S9cGCV+c8BJ367PIu0YM6U3rpJXT5l+fo9LOfUjB8GF5VRaqq\niuSmTaTq6vBkco9P5e7Bm3h1NanNm0hVB0O9Sq+aQpdnn6bTXXdSMHKkVpQUEWnD7rrrLo444giG\nDx/OiBEjePfdd/fp8e7OU0ue5JO5K9m4dOMXt//xrpdZ+uayPT7+3jPu++L6h+98xG8nP0z1umoA\nygvKWLBxPvM3zNunTCL7Kz7kcCpmPEHplVMASG3dSnLDBpKbNpHcsIHU1i2YGaVXXUnF9CeIDx4c\ncmIRrULc9h08HL79MLz4P6C5Dgr2f5hS3knUQ6IBzp0GPY/Z490tGqXw2GMpPPZYkuvWkVi2jMTS\nZTQv+CDYgscdDHCCLw3cg+HckWAjBFpaiFRUUDByBPEjjyQ+oD/xIUOweDzbLRURkQx45513eOml\nl5g7dy6FhYVs2rSJ5n1cJ2HZlqUs3bKETQs3UlNSTa9h+zfi5pPKlcx64A0u/eXFlB8c7McZzIst\n4pnlTzOs63Bika+eprW0tBCL6dRNMitaUUGHKVdQ+p3JNL/7Hi2rV+PbtmFlZcR696Zg9DGY/u6k\nDdFfYy7oOSooYv/490FPbMG+L3med5rrINkEZz8Ih4zZ54dHDz6Y6MEHUzRuHACeTJLbDKmSAAAS\nF0lEQVRcs4bk6jV4cxPenIBUEosXQDxOpLyM2KGHEunY8ZsPLCIibdbatWvp0qULhen5e1122Mdy\n9uzZ3HzzzbS0tHDMMccwbdo0CgsL6du3L5WVlXTp0oXKykomXzuZMf/rOOa9uACLGItmLuGMG8YD\n8NmC1bz33PvUba7jlP85jsNPOWyXOVbN/4xX73mNi++dROeenQGoWlvNy3e/Qn1VA4XlBZz62Gmc\nOfIsrrzySoqKipg3bx5jxozhzjvv5LrrrmPRokUkEgmmTp3KxIkTWblyJZdffjl1dXUAPPjgg5xw\nghbakb1n8TiFJ45Bs1ulrVMBmyt6jYbzH4cXrw622CnuFHai8DQGQ60497fQ+/iMHNKiUWKHHELs\nkEMycjwREWl7zjjjDO644w4GDRrE+PHjueSSSxg7diyNjY1ceeWVzJ49m0GDBnHFFVcwbdo0brjh\nhq88vqapmvqWenr07sHIiSMoKI5z3ORjAVjw0gfUbq7lioe+y6ZPN/P8LS/ssoBNNid5/tbf891f\nT6ZLn4ovbp/5q1kMO3Mow88axnsvvs/NN/5vzvzTWQCsXr2at99+m2g0yq233sqpp57K448/TlVV\nFaNHj2b8+PF069aNWbNmUVRUxIoVK5g8eTKVlZVZ/N8UEQmH5sDmkh4jYdI/Q0kF1G1qf1vsuAdb\nCxV2hIuezljxKiIi7UOHDh2YM2cODz/8MF27duWSSy5h+vTpLF++nH79+jFo0CAApkyZwltvvbXT\n49fWrQXY5R6vAINOGohFjK79ulC3Zdf7ukZiEXoN7cn8lz/4yu1rFn/OEacPAWDkWSP4aN5HtKRa\nAJg0aRLR9Kr2M2fO5O6772bEiBGMGzeOxsZGVq1aRSKR4Oqrr2bYsGFMmjSJJUuW7Mf/kIhI26ce\n2FxzUH+4+Hl4/UZY8x4UV8A+7DuXszwF9Zug+/Bg2HBJxZ4fIyIi8jXRaJRx48Yxbtw4hg0bxowZ\nMxg5cuRu7x+LxUilV67/dPOn3/jlcTT+5eexs+v7WcS44I6JPH3Ds/zld+8w5oqdv4zdXiCvq1sH\nQGnpl+tfuDsvvPACg7+2mM7UqVPp3r07CxYsIJVKUVRUtNucIiK5TD2wuai4E3z7ERh2GTRsDuaD\n5rNEfVC8HnYBnD9dxauIiOyX5cuXs2LFii9+nj9/Pn369GHw4MGsXLmSDz/8EIAnn3ySsWPHAtC3\nb1/mzJkDwOt/fB1LF5eFJQU01+/bAlDbxYviXHzP37B41mLmv7QAgF5De7LkjaUALJ65hG8N68GG\n+vU7PXbChAn85je/+WKrnXnzghWLq6ur6dGjB5FIhCeffJLkXqyuLyKSi1TA5qpoDE6+NdgrNhqH\nuo1BL2U+2d7rCjDhfjj1zmC/VxERkf1QW1vLlClTGDJkCMOHD2fJkiVMnTqVoqIinnjiCSZNmsSw\nYcOIRCJce+21ANx+++1cf/31jBo1Cjdn+0ZpA04YwPK3VvDoVU+wasFn+5yluKyYS39xMX/53Tv8\n13+u4IwbxvPBqwt5ZMrjLHx9MSd9/0SakzsXyLfddhuJRILhw4dzxBFHcNtttwHwve99jxkzZnDk\nkUeybNmyr/TaiojkE8uFzbJHjRrlWojgGzRUwX/8DFa8DPGS/FilOFEfrLh86HgY+xP1uoqISOh+\n/t4/sqF+PUWx7A/PrWmq4fIhUxjd49isP5eISFtgZnPcfdSe7qce2HxQ3AnOuCfojY2XBL2xLY1h\np9o/LU1B/kgMJtwHZ/5KxauIiLQJnQs7f7GwUrZFLEJpXL2oIiJfpwI2n/QdC5fPhBNvCYbf1m2E\nXQw/apOSiXTeBBx/E1zxBgyYAGZ7fqyIiEgr6N95AC3eOgVsylP07NirVZ5LRCSXaBXifBMrhCMv\ng8MmwoLfwdxHobEG4sVB72xbKwgT9cHFonDU38HIv4Wi8rBTiYiI7KR3x95ELfunTi2pFgpjRZQX\n6PNQROTrVMDmq8IOMPp7cOTlsOIVmPsY1AbL8VPUKdytd1JJaKwKrpd0hdHXwaBzg6HQIiIibVS/\nskMpiMZJJBPEo/GsPU9dop6xvcZhbe1LZxGRNkAFbL4r7AhDL4EjLobP58AHT8LKPwMOqRQUlUG0\nIPs5ks3QVEMwat2h9xgYMQV6joaIRrKLiEjbF4/GGdvrFF5f+Srl0ez0jm5fXPOkXidl5fgiIrku\nlALWzM4EHgCiwKPufncYOdoVM+g5Krg018PnlfDRTPj4DWjeCqmW4D7xEogVgR1AUempYBGpRENw\nPRILtvoZeE4wr7XnaCjQwhQiIpJ7Tux5IrNXzcpaL2xN8zYOP+hwDi7tkfFji4jkg1YvYM0sCjwE\nnA6sBt43sxfdfUlrZ2m3Ckqg78nB5ZQ7YNOy4LJuHqydC1WrgiHGZkEBmkwEBW0k/ediBtu3X/Jk\nMCQ4Egse4x4Uw+W9od9I6HEUdDksuETV4S8iIrmtc9FBXDjwb/jnZc9QHinP6DDf5mQz8UiMyYdf\nlrFjiojkmzAqitHAh+7+MYCZPQtMBFTAhiESgW5DgsuQC4PbEo1Q8xnUb4aGzVC/CWrWQMOWoDhN\ntaQL1lgwn7asF5R0Cba7Ka4Iitd4cbjtEhERyZITe57EnPWVfFz1EWWFZRk5ZjKVpD7RwHeHXM5B\nRQdl5JgiIvkojAK2J/DZDj+vBrRLd1sSL4KKgcFFREREviJiEa4Zfi33z/kl6+vW0bGg4wH1xCZT\nSbYltnFWv7M5rsfxGUwqIpJ/2uzqOWZ2jZlVmlnlxo0bw44jIiIi8oXSeCk3Hn0Tfcr7Ut1cQ0tq\n//aHrUvUUZuo47z+53POod/WysMiInsQRgG7Bui9w8+90rd9hbs/7O6j3H1U165dWy2ciIiIyN4o\njZdy41E3ccGAC2loaaSqqZpkKrnHx7k7jS2NVDdVU1ZQxk2jbmZC3zNVvIqI7IUwhhC/Dww0s34E\nheulwHdCyCEiIiJyQKKRKOP7nM7wrkfy5qrZvLP2bZItKVKeojBaQCwSwzBSniKRSpBItRCxCOWF\nnThvwPkc3+MEClpjOzsRkTzR6gWsu7eY2Q+A1wm20Xnc3Re3dg4RERGRTOlW0o1LDpvMeQPOZ9mW\npXxS/Qkfbl1BVXMVyVSSwlgxh3boz4BOAzm0/FAOLe+vHlcRkf0Qyr4m7v4K8EoYzy0iIiKSLcWx\nYkZ2O4qR3Y4KO4qISF4y376fZxtmZhuBT8POsZe6AJvCDtEK2kM720MbQe3MJ+2hjaB25pv20M72\n0EZQO/NJe2gjqJ1tTR933+PiRzlRwOYSM6t091Fh58i29tDO9tBGUDvzSXtoI6id+aY9tLM9tBHU\nznzSHtoIameuarPb6IiIiIiIiIjsSAWsiIiIiIiI5AQVsJn3cNgBWkl7aGd7aCOonfmkPbQR1M58\n0x7a2R7aCGpnPmkPbQS1MydpDqyIiIiIiIjkBPXAioiIiIiISE5QAZshZva4mW0ws0VhZ8kWM+tt\nZm+a2RIzW2xm14edKRvMrMjM3jOzBel2/kPYmbLFzKJmNs/MXgo7S7aY2UozW2hm882sMuw82WJm\nnczseTNbZmZLzez4sDNlmpkNTr+O2y81ZnZD2LkyzcxuTL/3LDKzZ8ysKOxM2WBm16fbuDifXsdd\nnQ+Y2UFmNsvMVqT/7RxmxkzYTTsnpV/PlJnlxYqnu2nnven32g/M7A9m1inMjAdqN228M92++WY2\n08y+FWbGTPimc3Uzu8nM3My6hJEtk3bzek41szU7fH6eHWbGA6UCNnOmA2eGHSLLWoCb3H0IcBzw\nfTMbEnKmbGgCTnX3I4ERwJlmdlzImbLlemBp2CFawSnuPiKflpDfhQeA19z9MOBI8vB1dffl6ddx\nBHA0UA/8IeRYGWVmPYEfAqPcfSgQBS4NN1XmmdlQ4GpgNMHf67lmNiDcVBkznZ3PB34EzHb3gcDs\n9M+5bjo7t3MRcCHwVqunyZ7p7NzOWcBQdx8O/BdwS2uHyrDp7NzGe919ePr99iXgJ62eKvOms4tz\ndTPrDZwBrGrtQFkynV3XJPdv/wx191daOVNGqYDNEHd/C9gSdo5scve17j43fX0bwQlyz3BTZZ4H\natM/xtOXvJssbma9gHOAR8POIgfGzMqBk4HHANy92d2rwk2VdacBH7n7p2EHyYIYUGxmMaAE+Dzk\nPNlwOPCuu9e7ewvwZ4LCJ+ft5nxgIjAjfX0GcH6rhsqCXbXT3Ze6+/KQImXFbto5M/13C/BXoFer\nB8ug3bSxZocfS8mD86BvOFe/H/g/5EEboX3UJCpgZb+YWV9gJPBuuEmyIz20dj6wAZjl7vnYzl8R\nvGGnwg6SZQ68YWZzzOyasMNkST9gI/BEekj4o2ZWGnaoLLsUeCbsEJnm7muAXxD0BKwFqt19Zrip\nsmIRcJKZVZhZCXA20DvkTNnU3d3Xpq+vA7qHGUYy6m+BV8MOkQ1mdpeZfQZcRn70wO7EzCYCa9x9\nQdhZWsF16WHhj+f6NAYVsLLPzKwD8AJww9e+ocsb7p5MD5vpBYxOD3fLG2Z2LrDB3eeEnaUVnJh+\nLc8iGPZ+ctiBsiAGHAVMc/eRQB35MURxl8ysADgP+Jews2Ra+qRiIsGXEt8CSs3su+Gmyjx3Xwr8\nHJgJvAbMB5KhhmolHmz/kBc9Pe2dmf2YYHrVU2FnyQZ3/7G79yZo3w/CzpNp6S/PbiVPi/OvmQYc\nSjA1bi3wy3DjHBgVsLJPzCxOULw+5e6/DztPtqWHYb5J/s1vHgOcZ2YrgWeBU83s/4cbKTvSPVq4\n+waC+ZKjw02UFauB1TuMFHieoKDNV2cBc919fdhBsmA88Im7b3T3BPB74ISQM2WFuz/m7ke7+8nA\nVoK5hPlqvZn1AEj/uyHkPHKAzOxK4FzgMs//PSmfAi4KO0QW9Cf4snBB+nyoFzDXzA4ONVUWuPv6\ndOdMCniEHD8XUgEre83MjGCO3VJ3vy/sPNliZl23ryhoZsXA6cCycFNllrvf4u693L0vwVDMf3f3\nvOvlMbNSM+u4/TrBIg15t1K4u68DPjOzwembTgOWhBgp2yaTh8OH01YBx5lZSfo99zTycEEuADPr\nlv73EIL5r0+HmyirXgSmpK9PAf4txCxygMzsTIIpOOe5e33YebLBzAbu8ONE8uw8CMDdF7p7N3fv\nmz4fWg0clf5MzSvbv0BLu4AcPxeKhR0gX5jZM8A4oIuZrQZud/fHwk2VcWOAy4GF6fmhALfm+kpm\nu9ADmGFmUYIveZ5z97zdZibPdQf+ENQBxICn3f21cCNlzXXAU+nhtR8DV4WcJyvSX0ScDvx92Fmy\nwd3fNbPngbkEQxPnAQ+HmyprXjCzCiABfD9fFh7b1fkAcDfwnJn9HfApcHF4CTNjN+3cAvwG6Aq8\nbGbz3X1CeCkP3G7aeQtQCMxKf7781d2vDS3kAdpNG89OfymaIvibzdn2bddOztV393qOM7MRBNMX\nVpLjn6GW/6MeREREREREJB9oCLGIiIiIiIjkBBWwIiIiIiIikhNUwIqIiIiIiEhOUAErIiIiIiIi\nOUEFrIiIiIiIiOQEFbAiIiKtwMySZjbfzBaZ2R+37ze9n8f6k5mNymQ+ERGRXKACVkREpHU0uPsI\ndx9KsF/m98MOJCIikmtUwIqIiLS+d4CeAGbWwcxmm9lcM1toZhPTt/c1s6Vm9oiZLTazmWZWvONB\nzCxiZtPN7KchtEFERKTVqYAVERFpRWYWBU4DXkzf1Ahc4O5HAacAvzQzS/9uIPCQux8BVAEX7XCo\nGPAUsMLd/2+rhBcREQmZClgREZHWUWxm84F1QHdgVvp2A35mZh8AbxD0zHZP/+4Td5+fvj4H6LvD\n8f4fsMjd78p2cBERkbZCBayIiEjraHD3EUAfgqJ1+xzYy4CuwNHp368HitK/a9rh8UmCXtft3gZO\nMbMiRERE2gkVsCIiIq3I3euBHwI3mVkMKAc2uHvCzE4hKHD3xmPAK8Bz6eOIiIjkPRWwIiIirczd\n5wEfAJMJ5rGOMrOFwBXAsn04zn3APOBJM9NnuoiI5D1z97AziIiIiIiIiOyRvq0VERERERGRnKAC\nVkRERERERHKCClgRERERERHJCSpgRUREREREJCeogBUREREREZGcoAJWREREREREcoIKWBERERER\nEckJKmBFREREREQkJ/w3FAOdLntQNfAAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7f5853191f28>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#def plot_optional():\n",
    "#    import matplotlib as plt\n",
    "#    %matplotlib inline\n",
    "#    Top15 = answer_one()\n",
    "#    ax = Top15.plot(x='Rank', y='% Renewable', kind='scatter', \n",
    "#                    c=['#e41a1c','#377eb8','#e41a1c','#4daf4a','#4daf4a','#377eb8','#4daf4a','#e41a1c',\n",
    "#                       '#4daf4a','#e41a1c','#4daf4a','#4daf4a','#e41a1c','#dede00','#ff7f00'], \n",
    "#                    xticks=range(1,16), s=6*Top15['2014']/10**10, alpha=.75, figsize=[16,6]);\n",
    "\n",
    "#    for i, txt in enumerate(Top15.index):\n",
    "#        ax.annotate(txt, [Top15['Rank'][i], Top15['% Renewable'][i]], ha='center')\n",
    "\n",
    "#    print(\"This is an example of a visualization that can be created to help understand the data. \\\n",
    "#This is a bubble chart showing % Renewable vs. Rank. The size of the bubble corresponds to the countries' \\\n",
    "#2014 GDP, and the color corresponds to the continent.\")\n",
    "#plot_optional()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#Interesting to see that the country that ranks the lowest in citations (Brazil) has the highest % Renewable energy supply. Much the same as Canada that has a higher ranking. No correlation at all between these two variables."
   ]
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "coursera": {
   "course_slug": "python-data-analysis",
   "graded_item_id": "zAr06",
   "launcher_item_id": "KSSjT",
   "part_id": "SL3fU"
  },
  "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.0"
  },
  "umich": {
   "id": "Assignment 3",
   "version": "1.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}