magic_baby_maker.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Data Thieves\n",
    "\n",
    "    - The utilities folder contains our source code"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# import our utility functions\n",
    "from utility import scrapers\n",
    "\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Scrape our data :)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "goodreads = scrapers.scrape_goodreads()\n",
    "nytimes = scrapers.scrape_nytimes()\n",
    "amazon = scrapers.scrape_amazon()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Store them as csv files so we can easily import to a database"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "nytimes.to_csv(\"data/ny_times.csv\" ,index=False)\n",
    "amazon.to_csv(\"data/amazon.csv\" ,index=False)\n",
    "goodreads.to_csv(\"data/goodreads.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Check DataFrame contents"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>author</th>\n",
       "      <th>weeks_in_ranking</th>\n",
       "      <th>synopsis</th>\n",
       "      <th>cover_url</th>\n",
       "      <th>common_genre</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The Vanishing Half</td>\n",
       "      <td>Brit Bennett</td>\n",
       "      <td>1</td>\n",
       "      <td>The lives of twin sisters who run away from a ...</td>\n",
       "      <td>https://s1.nyt.com/du/books/images/97805255362...</td>\n",
       "      <td>Combined Print &amp; E-Book Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Guest List</td>\n",
       "      <td>Lucy Foley</td>\n",
       "      <td>1</td>\n",
       "      <td>A wedding between a TV star and a magazine pub...</td>\n",
       "      <td>https://s1.nyt.com/du/books/images/97800628689...</td>\n",
       "      <td>Combined Print &amp; E-Book Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Where The Crawdads Sing</td>\n",
       "      <td>Delia Owens</td>\n",
       "      <td>91</td>\n",
       "      <td>In a quiet town on the North Carolina coast in...</td>\n",
       "      <td>https://s1.nyt.com/du/books/images/97807352190...</td>\n",
       "      <td>Combined Print &amp; E-Book Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>The Lies That Bind</td>\n",
       "      <td>Emily Giffin</td>\n",
       "      <td>1</td>\n",
       "      <td>When the new man in her life disappears on 9/1...</td>\n",
       "      <td>https://s1.nyt.com/du/books/images/97803991789...</td>\n",
       "      <td>Combined Print &amp; E-Book Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Hideaway</td>\n",
       "      <td>Nora Roberts</td>\n",
       "      <td>2</td>\n",
       "      <td>A child star escapes her abductors, gathers he...</td>\n",
       "      <td>https://s1.nyt.com/du/books/images/97812502071...</td>\n",
       "      <td>Combined Print &amp; E-Book Fiction</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     title        author  weeks_in_ranking  \\\n",
       "0       The Vanishing Half  Brit Bennett                 1   \n",
       "1           The Guest List    Lucy Foley                 1   \n",
       "2  Where The Crawdads Sing   Delia Owens                91   \n",
       "3       The Lies That Bind  Emily Giffin                 1   \n",
       "4                 Hideaway  Nora Roberts                 2   \n",
       "\n",
       "                                            synopsis  \\\n",
       "0  The lives of twin sisters who run away from a ...   \n",
       "1  A wedding between a TV star and a magazine pub...   \n",
       "2  In a quiet town on the North Carolina coast in...   \n",
       "3  When the new man in her life disappears on 9/1...   \n",
       "4  A child star escapes her abductors, gathers he...   \n",
       "\n",
       "                                           cover_url  \\\n",
       "0  https://s1.nyt.com/du/books/images/97805255362...   \n",
       "1  https://s1.nyt.com/du/books/images/97800628689...   \n",
       "2  https://s1.nyt.com/du/books/images/97807352190...   \n",
       "3  https://s1.nyt.com/du/books/images/97803991789...   \n",
       "4  https://s1.nyt.com/du/books/images/97812502071...   \n",
       "\n",
       "                      common_genre  \n",
       "0  Combined Print & E-Book Fiction  \n",
       "1  Combined Print & E-Book Fiction  \n",
       "2  Combined Print & E-Book Fiction  \n",
       "3  Combined Print & E-Book Fiction  \n",
       "4  Combined Print & E-Book Fiction  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nytimes = pd.read_csv(\"data/ny_times.csv\")\n",
    "nytimes.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>rank</th>\n",
       "      <th>title</th>\n",
       "      <th>author</th>\n",
       "      <th>ratings</th>\n",
       "      <th>reviews</th>\n",
       "      <th>price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>The Room Where It Happened: A White House Memoir</td>\n",
       "      <td>John Bolton</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>19.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Too Much And Never Enough: How My Family Creat...</td>\n",
       "      <td>Mary L. Trump Ph.D.</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>25.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>How To Be An Antiracist</td>\n",
       "      <td>Ibram X. Kendi</td>\n",
       "      <td>4.7</td>\n",
       "      <td>567</td>\n",
       "      <td>14.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>White Fragility: Why It'S So Hard For White Pe...</td>\n",
       "      <td>Robin DiAngelo</td>\n",
       "      <td>4.3</td>\n",
       "      <td>1916</td>\n",
       "      <td>11.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Stamped From The Beginning: The Definitive His...</td>\n",
       "      <td>Ibram X. Kendi</td>\n",
       "      <td>4.7</td>\n",
       "      <td>649</td>\n",
       "      <td>12.16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   rank                                              title  \\\n",
       "0     1   The Room Where It Happened: A White House Memoir   \n",
       "1     2  Too Much And Never Enough: How My Family Creat...   \n",
       "2     3                            How To Be An Antiracist   \n",
       "3     4  White Fragility: Why It'S So Hard For White Pe...   \n",
       "4     5  Stamped From The Beginning: The Definitive His...   \n",
       "\n",
       "                author  ratings  reviews  price  \n",
       "0          John Bolton      0.0        0  19.50  \n",
       "1  Mary L. Trump Ph.D.      0.0        0  25.20  \n",
       "2       Ibram X. Kendi      4.7      567  14.79  \n",
       "3       Robin DiAngelo      4.3     1916  11.35  \n",
       "4       Ibram X. Kendi      4.7      649  12.16  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon = pd.read_csv(\"data/amazon.csv\")\n",
    "amazon.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>rank</th>\n",
       "      <th>title</th>\n",
       "      <th>author</th>\n",
       "      <th>ratings</th>\n",
       "      <th>reviews</th>\n",
       "      <th>reads</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Where The Crawdads Sing</td>\n",
       "      <td>Delia Owens</td>\n",
       "      <td>4.48</td>\n",
       "      <td>783960</td>\n",
       "      <td>38943</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>The Ballad Of Songbirds And Snakes (The Hunger...</td>\n",
       "      <td>Suzanne Collins</td>\n",
       "      <td>3.91</td>\n",
       "      <td>59917</td>\n",
       "      <td>36867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Normal People</td>\n",
       "      <td>Sally Rooney</td>\n",
       "      <td>3.87</td>\n",
       "      <td>299196</td>\n",
       "      <td>36847</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Little Fires Everywhere</td>\n",
       "      <td>Celeste Ng</td>\n",
       "      <td>4.10</td>\n",
       "      <td>613328</td>\n",
       "      <td>29086</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>The Silent Patient</td>\n",
       "      <td>Alex Michaelides</td>\n",
       "      <td>4.09</td>\n",
       "      <td>387115</td>\n",
       "      <td>27879</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   rank                                              title            author  \\\n",
       "0     1                            Where The Crawdads Sing       Delia Owens   \n",
       "1     2  The Ballad Of Songbirds And Snakes (The Hunger...   Suzanne Collins   \n",
       "2     3                                      Normal People      Sally Rooney   \n",
       "3     4                            Little Fires Everywhere        Celeste Ng   \n",
       "4     5                                 The Silent Patient  Alex Michaelides   \n",
       "\n",
       "   ratings  reviews  reads  \n",
       "0     4.48   783960  38943  \n",
       "1     3.91    59917  36867  \n",
       "2     3.87   299196  36847  \n",
       "3     4.10   613328  29086  \n",
       "4     4.09   387115  27879  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "goodreads = pd.read_csv(\"data/goodreads.csv\")\n",
    "goodreads.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>author</th>\n",
       "      <th>ratings</th>\n",
       "      <th>reviews</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A Long Finish (Aurelio Zen, #6)</td>\n",
       "      <td>Michael Dibdin</td>\n",
       "      <td>3.78</td>\n",
       "      <td>1043</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Blood Rain (Aurelio Zen, #7)</td>\n",
       "      <td>Michael Dibdin</td>\n",
       "      <td>3.75</td>\n",
       "      <td>1024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Sizilianisches Finale (Aurelio Zen, #7)</td>\n",
       "      <td>Michael Dibdin</td>\n",
       "      <td>3.75</td>\n",
       "      <td>1024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>New Television, Globalisation, and the East As...</td>\n",
       "      <td>Anthony Y. H. Fung</td>\n",
       "      <td>4.00</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Medieval Machine: The Industrial Revolution of...</td>\n",
       "      <td>Jean Gimpel</td>\n",
       "      <td>3.89</td>\n",
       "      <td>222</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               title              author  \\\n",
       "0                    A Long Finish (Aurelio Zen, #6)      Michael Dibdin   \n",
       "1                       Blood Rain (Aurelio Zen, #7)      Michael Dibdin   \n",
       "2            Sizilianisches Finale (Aurelio Zen, #7)      Michael Dibdin   \n",
       "3  New Television, Globalisation, and the East As...  Anthony Y. H. Fung   \n",
       "4  Medieval Machine: The Industrial Revolution of...         Jean Gimpel   \n",
       "\n",
       "   ratings  reviews  \n",
       "0     3.78     1043  \n",
       "1     3.75     1024  \n",
       "2     3.75     1024  \n",
       "3     4.00        1  \n",
       "4     3.89      222  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kaggle_goodreads = pd.read_csv(\"data/kaggle_goodreads.csv\")\n",
    "kaggle_goodreads.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Select the common books between the pages"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 1. Amazon and Goodreads common books"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>rank_x</th>\n",
       "      <th>title</th>\n",
       "      <th>author_x</th>\n",
       "      <th>ratings_x</th>\n",
       "      <th>reviews_x</th>\n",
       "      <th>reads</th>\n",
       "      <th>rank_y</th>\n",
       "      <th>author_y</th>\n",
       "      <th>ratings_y</th>\n",
       "      <th>reviews_y</th>\n",
       "      <th>price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Where The Crawdads Sing</td>\n",
       "      <td>Delia Owens</td>\n",
       "      <td>4.48</td>\n",
       "      <td>783960</td>\n",
       "      <td>38943</td>\n",
       "      <td>8</td>\n",
       "      <td>Delia Owens</td>\n",
       "      <td>4.7</td>\n",
       "      <td>50243</td>\n",
       "      <td>9.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10</td>\n",
       "      <td>Untamed</td>\n",
       "      <td>Glennon Doyle</td>\n",
       "      <td>4.27</td>\n",
       "      <td>45969</td>\n",
       "      <td>17879</td>\n",
       "      <td>14</td>\n",
       "      <td>Glennon Doyle</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2301</td>\n",
       "      <td>16.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>14</td>\n",
       "      <td>Becoming</td>\n",
       "      <td>Michelle Obama</td>\n",
       "      <td>4.55</td>\n",
       "      <td>475528</td>\n",
       "      <td>14925</td>\n",
       "      <td>16</td>\n",
       "      <td>Michelle Obama</td>\n",
       "      <td>4.7</td>\n",
       "      <td>35376</td>\n",
       "      <td>11.89</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   rank_x                    title        author_x  ratings_x  reviews_x  \\\n",
       "0       1  Where The Crawdads Sing     Delia Owens       4.48     783960   \n",
       "1      10                  Untamed   Glennon Doyle       4.27      45969   \n",
       "2      14                 Becoming  Michelle Obama       4.55     475528   \n",
       "\n",
       "   reads  rank_y        author_y  ratings_y  reviews_y  price  \n",
       "0  38943       8     Delia Owens        4.7      50243   9.59  \n",
       "1  17879      14   Glennon Doyle        4.6       2301  16.80  \n",
       "2  14925      16  Michelle Obama        4.7      35376  11.89  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon_goodreads = pd.merge(goodreads, amazon, on=\"title\", how=\"inner\")\n",
    "amazon_goodreads"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 2. Amazon and NY Times common books"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>author_x</th>\n",
       "      <th>weeks_in_ranking</th>\n",
       "      <th>synopsis</th>\n",
       "      <th>cover_url</th>\n",
       "      <th>common_genre</th>\n",
       "      <th>rank</th>\n",
       "      <th>author_y</th>\n",
       "      <th>ratings</th>\n",
       "      <th>reviews</th>\n",
       "      <th>price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Where The Crawdads Sing</td>\n",
       "      <td>Delia Owens</td>\n",
       "      <td>91</td>\n",
       "      <td>In a quiet town on the North Carolina coast in...</td>\n",
       "      <td>https://s1.nyt.com/du/books/images/97807352190...</td>\n",
       "      <td>Combined Print &amp; E-Book Fiction</td>\n",
       "      <td>8</td>\n",
       "      <td>Delia Owens</td>\n",
       "      <td>4.7</td>\n",
       "      <td>50243</td>\n",
       "      <td>9.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>So You Want To Talk About Race</td>\n",
       "      <td>Ijeoma Oluo</td>\n",
       "      <td>3</td>\n",
       "      <td>A look at the contemporary racial landscape of...</td>\n",
       "      <td>https://s1.nyt.com/du/books/images/97815800567...</td>\n",
       "      <td>Combined Print &amp; E-Book Nonfiction</td>\n",
       "      <td>6</td>\n",
       "      <td>Ijeoma Oluo</td>\n",
       "      <td>4.7</td>\n",
       "      <td>560</td>\n",
       "      <td>11.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>How To Be An Antiracist</td>\n",
       "      <td>Ibram X. Kendi</td>\n",
       "      <td>6</td>\n",
       "      <td>A primer for creating a more just and equitabl...</td>\n",
       "      <td>https://s1.nyt.com/du/books/images/97805255092...</td>\n",
       "      <td>Combined Print &amp; E-Book Nonfiction</td>\n",
       "      <td>3</td>\n",
       "      <td>Ibram X. Kendi</td>\n",
       "      <td>4.7</td>\n",
       "      <td>567</td>\n",
       "      <td>14.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Camino Winds</td>\n",
       "      <td>John Grisham</td>\n",
       "      <td>6</td>\n",
       "      <td>The line between fact and fiction becomes blur...</td>\n",
       "      <td>https://s1.nyt.com/du/books/images/97803855459...</td>\n",
       "      <td>Hardcover Fiction</td>\n",
       "      <td>42</td>\n",
       "      <td>John Grisham</td>\n",
       "      <td>4.1</td>\n",
       "      <td>1332</td>\n",
       "      <td>17.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Untamed</td>\n",
       "      <td>Glennon Doyle</td>\n",
       "      <td>13</td>\n",
       "      <td>The activist and public speaker describes her ...</td>\n",
       "      <td>https://s1.nyt.com/du/books/images/97819848012...</td>\n",
       "      <td>Hardcover Nonfiction</td>\n",
       "      <td>14</td>\n",
       "      <td>Glennon Doyle</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2301</td>\n",
       "      <td>16.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Between The World And Me</td>\n",
       "      <td>Ta-Nehisi Coates</td>\n",
       "      <td>88</td>\n",
       "      <td>Winner of the 2015 National Book Award for non...</td>\n",
       "      <td>https://s1.nyt.com/du/books/images/97806796459...</td>\n",
       "      <td>Hardcover Nonfiction</td>\n",
       "      <td>24</td>\n",
       "      <td>Ta-Nehisi Coates</td>\n",
       "      <td>4.6</td>\n",
       "      <td>5639</td>\n",
       "      <td>13.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Becoming</td>\n",
       "      <td>Michelle Obama</td>\n",
       "      <td>78</td>\n",
       "      <td>The former first lady describes how she balanc...</td>\n",
       "      <td>https://s1.nyt.com/du/books/images/97815247631...</td>\n",
       "      <td>Hardcover Nonfiction</td>\n",
       "      <td>16</td>\n",
       "      <td>Michelle Obama</td>\n",
       "      <td>4.7</td>\n",
       "      <td>35376</td>\n",
       "      <td>11.89</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            title          author_x  weeks_in_ranking  \\\n",
       "0         Where The Crawdads Sing       Delia Owens                91   \n",
       "1  So You Want To Talk About Race       Ijeoma Oluo                 3   \n",
       "2         How To Be An Antiracist    Ibram X. Kendi                 6   \n",
       "3                    Camino Winds      John Grisham                 6   \n",
       "4                         Untamed     Glennon Doyle                13   \n",
       "5        Between The World And Me  Ta-Nehisi Coates                88   \n",
       "6                        Becoming    Michelle Obama                78   \n",
       "\n",
       "                                            synopsis  \\\n",
       "0  In a quiet town on the North Carolina coast in...   \n",
       "1  A look at the contemporary racial landscape of...   \n",
       "2  A primer for creating a more just and equitabl...   \n",
       "3  The line between fact and fiction becomes blur...   \n",
       "4  The activist and public speaker describes her ...   \n",
       "5  Winner of the 2015 National Book Award for non...   \n",
       "6  The former first lady describes how she balanc...   \n",
       "\n",
       "                                           cover_url  \\\n",
       "0  https://s1.nyt.com/du/books/images/97807352190...   \n",
       "1  https://s1.nyt.com/du/books/images/97815800567...   \n",
       "2  https://s1.nyt.com/du/books/images/97805255092...   \n",
       "3  https://s1.nyt.com/du/books/images/97803855459...   \n",
       "4  https://s1.nyt.com/du/books/images/97819848012...   \n",
       "5  https://s1.nyt.com/du/books/images/97806796459...   \n",
       "6  https://s1.nyt.com/du/books/images/97815247631...   \n",
       "\n",
       "                         common_genre  rank          author_y  ratings  \\\n",
       "0     Combined Print & E-Book Fiction     8       Delia Owens      4.7   \n",
       "1  Combined Print & E-Book Nonfiction     6       Ijeoma Oluo      4.7   \n",
       "2  Combined Print & E-Book Nonfiction     3    Ibram X. Kendi      4.7   \n",
       "3                   Hardcover Fiction    42      John Grisham      4.1   \n",
       "4                Hardcover Nonfiction    14     Glennon Doyle      4.6   \n",
       "5                Hardcover Nonfiction    24  Ta-Nehisi Coates      4.6   \n",
       "6                Hardcover Nonfiction    16    Michelle Obama      4.7   \n",
       "\n",
       "   reviews  price  \n",
       "0    50243   9.59  \n",
       "1      560  11.36  \n",
       "2      567  14.79  \n",
       "3     1332  17.37  \n",
       "4     2301  16.80  \n",
       "5     5639  13.11  \n",
       "6    35376  11.89  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon_nytimes = pd.merge(nytimes, amazon, on=\"title\", how=\"inner\")\n",
    "amazon_nytimes"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 3. Goodreads and NY Times common books"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>rank</th>\n",
       "      <th>title</th>\n",
       "      <th>author_x</th>\n",
       "      <th>ratings</th>\n",
       "      <th>reviews</th>\n",
       "      <th>reads</th>\n",
       "      <th>author_y</th>\n",
       "      <th>weeks_in_ranking</th>\n",
       "      <th>synopsis</th>\n",
       "      <th>cover_url</th>\n",
       "      <th>common_genre</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Where The Crawdads Sing</td>\n",
       "      <td>Delia Owens</td>\n",
       "      <td>4.48</td>\n",
       "      <td>783960</td>\n",
       "      <td>38943</td>\n",
       "      <td>Delia Owens</td>\n",
       "      <td>91</td>\n",
       "      <td>In a quiet town on the North Carolina coast in...</td>\n",
       "      <td>https://s1.nyt.com/du/books/images/97807352190...</td>\n",
       "      <td>Combined Print &amp; E-Book Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3</td>\n",
       "      <td>Normal People</td>\n",
       "      <td>Sally Rooney</td>\n",
       "      <td>3.87</td>\n",
       "      <td>299196</td>\n",
       "      <td>36847</td>\n",
       "      <td>Sally Rooney</td>\n",
       "      <td>16</td>\n",
       "      <td>The connection between a high school star athl...</td>\n",
       "      <td>https://s1.nyt.com/du/books/images/97819848221...</td>\n",
       "      <td>Paperback Trade Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4</td>\n",
       "      <td>Little Fires Everywhere</td>\n",
       "      <td>Celeste Ng</td>\n",
       "      <td>4.10</td>\n",
       "      <td>613328</td>\n",
       "      <td>29086</td>\n",
       "      <td>Celeste Ng</td>\n",
       "      <td>57</td>\n",
       "      <td>An artist with a mysterious past and a disrega...</td>\n",
       "      <td>https://s1.nyt.com/du/books/images/97807352243...</td>\n",
       "      <td>Paperback Trade Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>10</td>\n",
       "      <td>Untamed</td>\n",
       "      <td>Glennon Doyle</td>\n",
       "      <td>4.27</td>\n",
       "      <td>45969</td>\n",
       "      <td>17879</td>\n",
       "      <td>Glennon Doyle</td>\n",
       "      <td>13</td>\n",
       "      <td>The activist and public speaker describes her ...</td>\n",
       "      <td>https://s1.nyt.com/du/books/images/97819848012...</td>\n",
       "      <td>Hardcover Nonfiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>14</td>\n",
       "      <td>Becoming</td>\n",
       "      <td>Michelle Obama</td>\n",
       "      <td>4.55</td>\n",
       "      <td>475528</td>\n",
       "      <td>14925</td>\n",
       "      <td>Michelle Obama</td>\n",
       "      <td>78</td>\n",
       "      <td>The former first lady describes how she balanc...</td>\n",
       "      <td>https://s1.nyt.com/du/books/images/97815247631...</td>\n",
       "      <td>Hardcover Nonfiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>23</td>\n",
       "      <td>Circe</td>\n",
       "      <td>Madeline Miller</td>\n",
       "      <td>4.27</td>\n",
       "      <td>285049</td>\n",
       "      <td>11644</td>\n",
       "      <td>Madeline Miller</td>\n",
       "      <td>7</td>\n",
       "      <td>Zeus banishes Helios' daughter to an island, w...</td>\n",
       "      <td>https://s1.nyt.com/du/books/images/97803165563...</td>\n",
       "      <td>Paperback Trade Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>35</td>\n",
       "      <td>The Woman In The Window</td>\n",
       "      <td>A.J. Finn</td>\n",
       "      <td>3.94</td>\n",
       "      <td>402231</td>\n",
       "      <td>9661</td>\n",
       "      <td>A.J. Finn</td>\n",
       "      <td>59</td>\n",
       "      <td>A recluse who drinks heavily and takes prescri...</td>\n",
       "      <td>https://s1.nyt.com/du/books/images/97800626784...</td>\n",
       "      <td>Paperback Trade Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>45</td>\n",
       "      <td>The Guest List</td>\n",
       "      <td>Lucy Foley</td>\n",
       "      <td>3.98</td>\n",
       "      <td>25778</td>\n",
       "      <td>8354</td>\n",
       "      <td>Lucy Foley</td>\n",
       "      <td>1</td>\n",
       "      <td>A wedding between a TV star and a magazine pub...</td>\n",
       "      <td>https://s1.nyt.com/du/books/images/97800628689...</td>\n",
       "      <td>Combined Print &amp; E-Book Fiction</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   rank                    title         author_x  ratings  reviews  reads  \\\n",
       "0     1  Where The Crawdads Sing      Delia Owens     4.48   783960  38943   \n",
       "1     3            Normal People     Sally Rooney     3.87   299196  36847   \n",
       "2     4  Little Fires Everywhere       Celeste Ng     4.10   613328  29086   \n",
       "3    10                  Untamed    Glennon Doyle     4.27    45969  17879   \n",
       "4    14                 Becoming   Michelle Obama     4.55   475528  14925   \n",
       "5    23                    Circe  Madeline Miller     4.27   285049  11644   \n",
       "6    35  The Woman In The Window        A.J. Finn     3.94   402231   9661   \n",
       "7    45           The Guest List       Lucy Foley     3.98    25778   8354   \n",
       "\n",
       "          author_y  weeks_in_ranking  \\\n",
       "0      Delia Owens                91   \n",
       "1     Sally Rooney                16   \n",
       "2       Celeste Ng                57   \n",
       "3    Glennon Doyle                13   \n",
       "4   Michelle Obama                78   \n",
       "5  Madeline Miller                 7   \n",
       "6        A.J. Finn                59   \n",
       "7       Lucy Foley                 1   \n",
       "\n",
       "                                            synopsis  \\\n",
       "0  In a quiet town on the North Carolina coast in...   \n",
       "1  The connection between a high school star athl...   \n",
       "2  An artist with a mysterious past and a disrega...   \n",
       "3  The activist and public speaker describes her ...   \n",
       "4  The former first lady describes how she balanc...   \n",
       "5  Zeus banishes Helios' daughter to an island, w...   \n",
       "6  A recluse who drinks heavily and takes prescri...   \n",
       "7  A wedding between a TV star and a magazine pub...   \n",
       "\n",
       "                                           cover_url  \\\n",
       "0  https://s1.nyt.com/du/books/images/97807352190...   \n",
       "1  https://s1.nyt.com/du/books/images/97819848221...   \n",
       "2  https://s1.nyt.com/du/books/images/97807352243...   \n",
       "3  https://s1.nyt.com/du/books/images/97819848012...   \n",
       "4  https://s1.nyt.com/du/books/images/97815247631...   \n",
       "5  https://s1.nyt.com/du/books/images/97803165563...   \n",
       "6  https://s1.nyt.com/du/books/images/97800626784...   \n",
       "7  https://s1.nyt.com/du/books/images/97800628689...   \n",
       "\n",
       "                      common_genre  \n",
       "0  Combined Print & E-Book Fiction  \n",
       "1          Paperback Trade Fiction  \n",
       "2          Paperback Trade Fiction  \n",
       "3             Hardcover Nonfiction  \n",
       "4             Hardcover Nonfiction  \n",
       "5          Paperback Trade Fiction  \n",
       "6          Paperback Trade Fiction  \n",
       "7  Combined Print & E-Book Fiction  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "goodreads_nytimes = pd.merge(goodreads, nytimes, on=\"title\", how=\"inner\")\n",
    "goodreads_nytimes"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 4. Top Common Books!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>rank</th>\n",
       "      <th>title</th>\n",
       "      <th>author_x_x</th>\n",
       "      <th>ratings</th>\n",
       "      <th>reviews</th>\n",
       "      <th>reads_x</th>\n",
       "      <th>author_y_x</th>\n",
       "      <th>weeks_in_ranking</th>\n",
       "      <th>synopsis</th>\n",
       "      <th>cover_url</th>\n",
       "      <th>...</th>\n",
       "      <th>rank_x</th>\n",
       "      <th>author_x_y</th>\n",
       "      <th>ratings_x</th>\n",
       "      <th>reviews_x</th>\n",
       "      <th>reads_y</th>\n",
       "      <th>rank_y</th>\n",
       "      <th>author_y_y</th>\n",
       "      <th>ratings_y</th>\n",
       "      <th>reviews_y</th>\n",
       "      <th>price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Where The Crawdads Sing</td>\n",
       "      <td>Delia Owens</td>\n",
       "      <td>4.48</td>\n",
       "      <td>783960</td>\n",
       "      <td>38943</td>\n",
       "      <td>Delia Owens</td>\n",
       "      <td>91</td>\n",
       "      <td>In a quiet town on the North Carolina coast in...</td>\n",
       "      <td>https://s1.nyt.com/du/books/images/97807352190...</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>Delia Owens</td>\n",
       "      <td>4.48</td>\n",
       "      <td>783960</td>\n",
       "      <td>38943</td>\n",
       "      <td>8</td>\n",
       "      <td>Delia Owens</td>\n",
       "      <td>4.7</td>\n",
       "      <td>50243</td>\n",
       "      <td>9.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10</td>\n",
       "      <td>Untamed</td>\n",
       "      <td>Glennon Doyle</td>\n",
       "      <td>4.27</td>\n",
       "      <td>45969</td>\n",
       "      <td>17879</td>\n",
       "      <td>Glennon Doyle</td>\n",
       "      <td>13</td>\n",
       "      <td>The activist and public speaker describes her ...</td>\n",
       "      <td>https://s1.nyt.com/du/books/images/97819848012...</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>Glennon Doyle</td>\n",
       "      <td>4.27</td>\n",
       "      <td>45969</td>\n",
       "      <td>17879</td>\n",
       "      <td>14</td>\n",
       "      <td>Glennon Doyle</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2301</td>\n",
       "      <td>16.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>14</td>\n",
       "      <td>Becoming</td>\n",
       "      <td>Michelle Obama</td>\n",
       "      <td>4.55</td>\n",
       "      <td>475528</td>\n",
       "      <td>14925</td>\n",
       "      <td>Michelle Obama</td>\n",
       "      <td>78</td>\n",
       "      <td>The former first lady describes how she balanc...</td>\n",
       "      <td>https://s1.nyt.com/du/books/images/97815247631...</td>\n",
       "      <td>...</td>\n",
       "      <td>14</td>\n",
       "      <td>Michelle Obama</td>\n",
       "      <td>4.55</td>\n",
       "      <td>475528</td>\n",
       "      <td>14925</td>\n",
       "      <td>16</td>\n",
       "      <td>Michelle Obama</td>\n",
       "      <td>4.7</td>\n",
       "      <td>35376</td>\n",
       "      <td>11.89</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   rank                    title      author_x_x  ratings  reviews  reads_x  \\\n",
       "0     1  Where The Crawdads Sing     Delia Owens     4.48   783960    38943   \n",
       "1    10                  Untamed   Glennon Doyle     4.27    45969    17879   \n",
       "2    14                 Becoming  Michelle Obama     4.55   475528    14925   \n",
       "\n",
       "       author_y_x  weeks_in_ranking  \\\n",
       "0     Delia Owens                91   \n",
       "1   Glennon Doyle                13   \n",
       "2  Michelle Obama                78   \n",
       "\n",
       "                                            synopsis  \\\n",
       "0  In a quiet town on the North Carolina coast in...   \n",
       "1  The activist and public speaker describes her ...   \n",
       "2  The former first lady describes how she balanc...   \n",
       "\n",
       "                                           cover_url  ... rank_x  \\\n",
       "0  https://s1.nyt.com/du/books/images/97807352190...  ...      1   \n",
       "1  https://s1.nyt.com/du/books/images/97819848012...  ...     10   \n",
       "2  https://s1.nyt.com/du/books/images/97815247631...  ...     14   \n",
       "\n",
       "       author_x_y ratings_x  reviews_x  reads_y  rank_y      author_y_y  \\\n",
       "0     Delia Owens      4.48     783960    38943       8     Delia Owens   \n",
       "1   Glennon Doyle      4.27      45969    17879      14   Glennon Doyle   \n",
       "2  Michelle Obama      4.55     475528    14925      16  Michelle Obama   \n",
       "\n",
       "  ratings_y  reviews_y  price  \n",
       "0       4.7      50243   9.59  \n",
       "1       4.6       2301  16.80  \n",
       "2       4.7      35376  11.89  \n",
       "\n",
       "[3 rows x 21 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_common = pd.merge(goodreads_nytimes, amazon_goodreads, on=\"title\", how=\"inner\")\n",
    "top_common"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 5. Average ratings on top books\n",
    "    - Amazon vs Goodreads"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>pages</th>\n",
       "      <th>Becoming</th>\n",
       "      <th>Untamed</th>\n",
       "      <th>Where The Crawdads Sing</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Goodreads</td>\n",
       "      <td>4.55</td>\n",
       "      <td>4.27</td>\n",
       "      <td>4.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Amazon</td>\n",
       "      <td>4.70</td>\n",
       "      <td>4.60</td>\n",
       "      <td>4.70</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       pages  Becoming  Untamed  Where The Crawdads Sing\n",
       "0  Goodreads      4.55     4.27                     4.48\n",
       "1     Amazon      4.70     4.60                     4.70"
      ]
     },
     "execution_count": 130,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# create a new dataframe with the reviews from both amazon and goodreads\n",
    "data = pd.DataFrame({\n",
    "    \"pages\": [\"Goodreads\", \"Amazon\"],\n",
    "    \"Becoming\": [amazon_goodreads[\"ratings_x\"].loc[2], amazon_goodreads[\"ratings_y\"].loc[2]],\n",
    "    \"Untamed\": [amazon_goodreads[\"ratings_x\"].loc[1], amazon_goodreads[\"ratings_y\"].loc[1]],\n",
    "    \"Where The Crawdads Sing\": [amazon_goodreads[\"ratings_x\"].loc[0], amazon_goodreads[\"ratings_y\"].loc[0]],\n",
    "})\n",
    "\n",
    "# check.\n",
    "data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Difference in reviews count between Amazon and Goodreads"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>pages</th>\n",
       "      <th>reviews</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Amazon</td>\n",
       "      <td>248926</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Goodreads</td>\n",
       "      <td>47111910</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       pages   reviews\n",
       "0     Amazon    248926\n",
       "1  Goodreads  47111910"
      ]
     },
     "execution_count": 99,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# create a new dataframe with the reviews from both amazon and goodreads\n",
    "data = pd.DataFrame({\n",
    "    \"pages\": [\"Amazon\", \"Goodreads\"],\n",
    "    \"reviews\": [amazon.agg({\"reviews\": \"sum\"})[\"reviews\"],\n",
    "                goodreads.agg({\"reviews\": \"sum\"})[\"reviews\"]]\n",
    "})\n",
    "\n",
    "# check.\n",
    "data.loc()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## We want to see the distribution of the reviews count that we obtained from the different websites, for that we can use a pie chart."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAi0AAAJKCAYAAADgGHWQAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAgAElEQVR4nOzdd5xcVd3H8c+ZsjW7k56QEBJI2RASahAIAULobREBKYJSBBQFlCIgAuMjKihi97Ei2B5BUCnSpUkTpShIUVqQngTY1K1znj/Onczd2Zmd7WfK9/16zWun3HvnN7Nz7/3dU421FhEREZFiF/EdgIiIiEhfKGkRERGRkqCkRUREREqCkhYREREpCUpaREREpCQoaREREZGSoKRliBhjbHC713csA2GMuSr0GWbkeH1J6PXkiAc4RMrlc4wUY8w0Y8y3jTHPGGPWhL67J33HVmyMMXuGvp8v+I5HpBzFfAcwkowx+QalaQdWAS3AMuBx4K/An6y160covF6FTrCvWGuv8hhKUTHGjAY+Ezx80lr7R5/xlBNjzFzgIWDMEGxrCXBPnpdTuP3vTeAx4BrcvqdBpCqMMcYA+wa3nYGNgPG4Y/S7wFPAg8BvrbUv+4rTJ2PMUmDX4OGV1tpXfcYz0ioqaelFFW7HGA/MBJYGz79vjLkauNha2+IruMDFwd/7gKs8xlFsRpP5bq4GlLQMna+RSVhuBm4AVgSPh3J/iOD+j6OBzYFjgAeMMYdZa98ewveRImaM2R/3m9six8tVwChgE+AA4MvGmJuBc621z45clEVhKXBBcP8uQElLhTgkdN8ACdwBemtcFjsDdxA9AzjUGHOUtfaBfBuz1prhC3X4WWuPA47zHMaws9bei/t/Sy+MMXFgr+Dhs8DB1trUEG3+X0C4+iSCu2DYFfgwEAcWA38yxuxgre0aovcdVtbau9Bvq9+C0pWLcBcf6e9vJXAb8CiwHHeumgwsAvYAGoCDgDpgzxEOWTyq2KSlt2qEYCfaD/gWMBvYGHcAXWSt/dcIhSji03igJrj/jyFMWABW5Nn/fmyM+R7wZ9zJaDvgSODXQ/jeUnzOA5LB/RTwP8Dl1tq1uRY2xtQDpwPnjkh0UlTUEDcH69wCLATSpSuNwO+MMfrOpBJUh+63jdSbWmsfAX4Qeqp5pN5bRp4xZmfgS8FDCxxurf1ivoQFwFq71lr7VWAbXBsoqSTW2oq54XYK6z52n9fZCHgvtO5RBbZ9by/bmoK7ingY16isI9j2f3BtVS4Gts8Xc4HbktA6S0LPJ4PnmnAlR8/iGj1a4LjQOleF1pmRI/Zc21wA/Bh4EViPK8a9K993FNrWcaFtHTeQZXHVd339bmb09jl6ee864LO4BqRv4U7e7+AS2fOBRIH1k9n/H2BHXMnBstD2bgb2HeLf+ljgwuC3thzXkPHN4P9zGlCTZ73w76BP32kf4wl/73n3kWDZ5tCyT/Rx+wuAbwL/wO1bbcDruHY4RwEmz3r/DN6nFRjdh/eZiNtvLfDXrNf2DMX9hT5saz9cO6wXgNXA2uD+z4FFvax3b/AeK4FInmW+H4rluV62dUOwTBtQm+P1hcCPgKeDGDuC3+wzwE3Ap/v7W8ja/p9DcV4xxPtAPXBm8H29HewD7wB/wZXuNBZY/4Egrs4+vFevywKXhD7n4uC5RcD/kTkWvB18p3v3YRu93e4ayu+x2G7eAxjRDzuApCVY77LQuncW2Pa9eV4/INjpC/3g3s8Xc4HbktA6S0LPJ4GPAutyrHNcaJ2rQs/PyBF/9jaPxR3o88VzM/lPjMfliqE/yzLMSQsuuXi9wHZXkOcAE2wjGf7/AJ8HunrZ3heH6Hd+MN0T7Vy3ZcA2Oda9qsB6eX8jBWIKf+8595HQsvuEln22wLIx4HsFvleL6wU1Mcf654SWOakPn+P00PKfznqtT0kLMAmXCBf6jn8ExAr8rnr8D4Nl/pW1rY1yLBPBJXgWuD/H65fgqmsKxXndAH+nC0LbaAXGD8XvP9j2zrgkvbe4lwN79LKNYUtacG14evvNXlhgG73dyjppqdg2Lf30G+Bzwf1Fxpi4tbajrysbY6YCv8W1fgf4E3An8AbuwDER2ArX8DGRtXq6wfAfgr/ZjRjTns7z9jvjWpp3AT/DdRdsxZW8vNXXz5Ble9wJGOBK4P5g+9sDJ+KucA4AfgUcNsD3KOQd3HczEXdwB3ci+E6eZfvMGLM1cDdQGzz1BO438CquMeCHcd/rOOBmY8ze1jXw7c3JuCv+13GJwb9wPSL2BY7ANUC8yBhzn7X27v7EmxX7/sD1QDR46n7gOtxV3HRcsrkA1wvjPmPMB6y1z4U28R1cD6xC32u/vtN+CvceydszImh7dj2ZKqR3cP+nJ3FJ+nRcm5jtgJ2Au4KGveFhDH4DXIrbD48BflIgtmOCvx24fbpfjDHjcaVfmwZP/Qv4Ha60NQXMB47HlcqejPs/fjxrM/eQ6TG3O+73GX6PScC8rHV2x33WsK3J9A67J2sbh5LpobIuWPdRXJJTA0zDlcLsxcCF173NWrsi75L9YIxZiDu+pvffx3Hxv4bbf4/A/R7GA7cYY/a01v5lKN67j07FHQtewx0LnsEdC/YHDscdC/7HGHO/tfa+0Hq/Bv4OHB0sB+44nN17ajj3Tf98Z00jeSOUjfZzvSiwJrT+Vr1s+94cr50dev1zvbyPAXYpEHuP7edYdgndM+83gXkF1rkqtPyMPmxzFbBjjuVm072E4tAcyxwXev24AnH1uizdS1yu6ud3k8zxegSXAKaX+RY5iuBxVS/pZV4lR6kS3a+ILXAHUJ9juc+GlrllEL/vBlxykt7WWTmWieGq9NLL/C3Ptvr1vfbze8/7G8a1HXuxt/9RaNmzQstdBzTk2acuDS13SY5l7gpeSwGb9PJ+c0LbuSnH6wVLWnDF/+llziNHtVXwf7wrtNxeWa9X46pj88VxRPBaB+4kZ4Gf5FjuzNB77J712m2hbezQy3dSQ1aVdj9+E9eH3v/cwf7Ggm1GcSfx9HYvz95/g9/EF0PLvAJU59jWcJW0WOBWoC7HcuGSvxv7sK3FQ/G9ldJNjUr7wLoul6+FnprQz03MCt3PeyVnneHI+E+x1j4zxNs8x7pGk91Ya/+DK21JO3uI33e4HUjmSv8R4LM2R88Za+2XcCVm4K46j8leJstK4Aibu4Hht8mUKCw1xgy0BPR4XAkJwLXW2m9kL2Ct7QQ+iWv7AbDQGOO1y6gxJmKMmRBc3T8IbBa8tAbXNiPXOnW4dkXgSiuOstauzl4u2KfOw1UPAXzKGFOVtdgv05sFPtJLqOH/8S/zLpWHMeYDuN8XwI+ttZfa4CyUFfNqXAlR+vN8Nuv1NlxpDcCuxpgo3e0e/H0UlySFn8u1XHh7aelj1j+ttX/N/YnAWttqrf1bvtcLmBq6/8IAt5HtYGBucP9B3HGq2/4b/CYuBm4PnpqOK/kYKe8AR1pr1+V47QpcCTzAnjn+txVPSUvfvRe6P66f64Z/nLkGThpOy8gcuIbKe7jGgjlZa2/DFXkC7GiMmTzE7z+cPhS6//VcJ5WQS/Osl8svrLXv5XohOKimi4GrcQMcDkQ4hsvyLRQk4ZfnWW8k7BYa7t7iqhbfwZWWzA+WWQPsb61dnmcb+5HZD79tC1fXprtNjwY+kPXa9WT20d6Sz3RCswq4scD75XJs6P7leZcCrKsquS14uCQYNyfs3uBvI7Bt1mvpZOQeMtU+M40x09ILBL0gdwkePmytbc3aRvr7mGaMaegt1kEIH0ffH6Jthn/LXxvC/XcoXW3zDFYa7JvpY0EtrsRTQtSmpe/CCV5vO0Iud5K5Wvq9MearwO+sta/1ss5QeaDAjjsQf7HWthdY5m4y9erbM/SJ03BJn9As7v/Wm4dwJ9dRwA4Flu1RKpXl9dD9fg+bH7Tv2D54uMJa+3iBVW4P3S8U+0j7NXCmtba3uvldQvcbjTEfLLDNjUL3NyczlAHW2jXGmHQvo3nGmG2stdntRBaRKQG6LsdJvi/SMbcCWxhjCl3ApBOV9MnrP6HX7sFVcYBLUv4WxLkRrhorvcwjuKqk2mC5XwSvbUum/dy9Od77Tlzbpwm4tk+X4aoue5RmFZn0/pvC9UzqzV/IfDcjuQ8M67Gg3Clp6bvRofvv9mdFa+2txpjf4BpQTcAVAV5hjPkP7sR3P3BzgYP0QL1eeJF+60tRbniZKcMQw3BJn9zeKnSAttamjDEv4hpRjzXGVPWSzBVqZBgeC6Um71L5NeK6aEP3k1tO1trlxpgW3Ilro0LLD7HsxuSjcUX6J+D2j8NxJ5y8pXl0vwLttdQih1wngl+SqSI4hqzGrQyyaigwI/hbQ6ZhfV9lx/xXMifcpbjh7yFTytIOPGStbTfGPIQbRXYpmaRlSWhb99DTl3ENQ+fixkP5LdAZTJT5YLDO7QNM3tJWkqmGGt3bgv2Q/i2/nqcqdgNrbZcx5iVc6fcEY0zUjszoy8N9LChrqh7qg6BecePQU/mKrHtzDK4XQHhE3dnAx3C9et4wxvwmuFIaSsMx4WOuuths4QPGqLxLFZ90UXivB7yQNTnWzWUoR5TNJfze/Y19uIr/81lhrf1j6HZV0O5kJq5tRRXwM2PMPr1sI7uXXX9kt2kB10g6Pc/RUeFBJIOqmQ8HD18lU3zfX40DXA+yYg6S43Q7ncWh6qN00vKIzfSSuifrtfD99bgEqBtr7bu40oevkumNEsP1GDoD18PsbWNMMkfVVV+9Ebo/0CrRbPXB3/7uA4aRO04N97GgrClp6ZsFZK5i15Jpr9FnQeOvn1lr5+N20I/hupSmr4qjuCu9vwZdFotZXeFFNhw8oPuJvb9G+jeaLl2p73WpjPCBzmfRefi9+xt7URT5ByVbh+PiMcBVvbSnCP+mNrbWmn7cLsnx3l24gb7AXa3vEXo53H7m14Oobk2fSF/oZ7zG5p737N7gbz2ZqsFwe5bs5TYxxmwWXIQtDp57KGjY24O1dpW19vO472M73Bg115IpKWjEdb0e6CSlD4buLxrgNrKlv+P+7gOW0jpOVSx90X1zdOj+Q31o9Ncra+1L1tpfWGs/Ya2dgzsgpIujp+G6vRWzWYUX6bbMG1mvhQ+Sua56w8b3KaKh82bwd3KhBohBO5L0FeLKPrTzGU6ryJSAzS60sDFmApnSiuz/jzfW2teBrwcPJ5N/fplwtedQNW7/Vej+MXnuh5fpr3TM04P5cwYrnJjsHjS0nZnjtUfJnMx3xx1v0qU+9xZ6E2ttylr7uLX2u9baI3D/l8PINJ7d3xiz7wDivyN0f99gDJvBSu+/U4IeZnkFyVu6ndI7OaqG0sepaB968Yz0capiKWkpIKiuOSn01M+G+j2CRpPhngWLcy2WDmmo338AFufoNpotXBSd3SUy3FOgUHuXQg3kwkWtQ/HdPBra1h69LYi7OkxfqT3a24LDLbj6T3/P44MB8nqzd+i+19hz+DaQ7l3xmSDByhauojkkx+v9Zq19jMxAXR8yxtQZYxpxswkDPD7IoQPSMcfJdH0ejEfJJKq7073KZ0Njz+Ai68HQcktC28jVnqVX1toua+31ZCY5hNzHrELbeSr0/tVkurAPRvq3HMW14enNYjID0OXaB8LHqbzV9saYcQxd9VZfDPUxr6QoaelFcKV9LZlGYs/iRq8cDq+E7udqIJ0uuhyKK7TBGour3srJGLM3mavfh6212SPvhg/8eQ8sxphNyZww8gkX6Q7Fd3N96P7ZQWlKPuFSgOvzLjVywjHkLa0LrhrPyrOed9baVWTGZ6kn92e5mUyD+OONMXNzLDMQ6Ua2o3BjfhxGpjHkQBvgpl0dun9xoZKAQrKSkUW46Q8gd5VPuF1LOrlZx+AS1ldC9wfaqeMiMifhzxpj+tz12BizadCrKaxP+0Cg0P7bp+MUbv6lkTyXDvUxr6QoacnBOPvhRpNMX0Gsws1A2u9GVMaYi4wxexWYIfrU0P1/5Hj95eDvXGNMbY7XR9rlxpjts580xszEDe2flmuAs2Vkrmh3Mcb0SEyCq+vryHT7zCloMJi+Kt+6QJLRF38i01h6Z+Druf5vxpjPk0mo/ktmHBCfriLTaPJoY8zp2QsECcv3cD1CwI2IW6hrqA/fItOI/NTs0pag/Ut6duBq4FZjzDb0whizgzHm0t6Wwf0f06Wax5CpGgq3eRkQa+1DuAkKwXW7viFPKRIAxpiYMeZDxphP9LLZe4O/tWQaC+cqPUk/NwU3ci/Ag7mquo0xUWPMD40x2VMBdIuN7iXQuY5ZBQVtdS5Obxa4Njhe5k3ojDH1xpjzcMPzb5f18o1AelqKXY0xl+U6JhhjLsS1VQI3llWuKRluC92/wBjTo/F3cOz6fPbzw+zl0P3sMXrKXsV2ec4a18HgelCMxc3HsSuZuUHAjYZ7lLU23POnP5bixlR4yxhzO25ulLdwSeMU3Nwp6TEc2nBdorP9GdgSl1nfZIy5GtcgLn2AfTQ4gY+EW3DzhjwYxPEXus89lK4y+X1QjJzL5WSq2q43xqTnMDK4E+rxuBKu35GZZyOfu3FVBDOBa4wxv6d70e59tvt8M3kF3ZiPxV3B1uJKJHY3xvwa9zuYhDs5pJPZDuCjg+z6OSSstauNMcfjDtxR4NvGmENwyd9y3HxDx+J+R+AavH7UR6yFBF2yf4a7iq3Hzf11TtYy3zJunpmP4LoT/90Ycyvu9/A67rc0AdeQfk/cPv08bvj8fO/7qjHmfmA3XBVaOmG901r7dr71+uE43G9rXhDTy8aY63DVOStwpTpTcCejvXFdnX+Uc0tOOEGJ5Xgu7THc/7uhwHLgvrdTgFOMMU/jEqOncSVb9bh2IEeRabf2HP3vwh32ZVzi+QXc7/aLwOnB//JR3G83hmtLswj3veVsbxZ0Yz4GNw5PDe53szQYcuJ13P57JJmGv+3AsbkaI1trHzTGPIybp2gO8IQx5oe4pGEcLulpxl2AdZDZr4bb/UAn7js5N0jKnsJ9FnC98/4+QrGMPFsEcwmM1I3ucz/05fYern69L1PW551XBXcQ7cv7LSf/tORTcVfR+dZdElp2Sej5ZB+/m6tC68zI8Xq3beKuQHub5flP5JnlOdieofcZhdtwXcSPCz13XJ5tbU3uWax7fJ6+fje4A9UbBf5fK4F9etlGMtf/Z7DL9uF/eTAuaest9mXAtr1sY0Zo2auGYN8Lf+899pE860zHnQwsriHphDy/o4sL/BbDt4Iz4OIS7+z1ju7Den2d5TmBS8b7Em8KuKiXbcXoPi/aGiCeZ9k/ZW27x9xhwXLRPsZmcR0I8s7X1M/fyEH0nJ26t+/lemB2nm0tpm+zPO9ZIKaZuG7u+bbxTLBMv2Z5LvCeBZfFjcsz4N94Kd9UPeR04E5AL+OuPr6Bu5qeYq09w1o72CGmD8TN5vt13I/7reA924P7f8bN0TPbWntHrg1Y16tiW1wS9TSZA5UX1tpf4UpWfgq8hDtpvItL0D5irT3A9lL6YN2edzzuiu1uXILYhqsnvxJYaK39aR9jeRJXTPxT3JV0X8aRKbTNh3G9cM7ENaBcTuZ38jBuBtyZ1trb827EE2vtDbgD6UW4MThW4mJ/B/ddnwHMtYVHzfXKumrE9MzEdWRmWg8vY621X8Rd/V+MK/V7G/d51+Oq7u4E/gc38V9f5lm6Dvd7TlvDwLv19mCtbbHWHo77zX4HV/L6Lq60cg1uGIQ/4EbRnmmt/Z9ettVJaHRf3AjY+Xo33hO6vwZX/Z1rm124Uo2jcfvUE7j9swv3nb4C/B637y601uadibs/rLU34UrFDsRVYT6BOz6245LWV3GJ13m4C5FDrZvrLNe2HsDtv2fjSibS++8K3Pg2nwdmWWvvKhDTi7iLoktxJSrrcU0FHse1idk+WGZEWWs/hythvJ3M770imCBrExERESlqKmkRERGRkqCkRUREREqCkhYREREpCUpaREREpCQoaREREZGSoKRFRERESoKSFhERESkJSlpERESkJChpERERkZKgpEVERERKgpIWERERKQlKWkRERKQkKGkRERGRkqCkRUREREqCkhYREREpCUpaREREpCQoaREREZGSoKRFRERESoKSFhERESkJSlpERESkJChpERERkZKgpEVERERKgpIWERERKQlKWkRERKQkKGkRERGRkqCkRUREREqCkhYREREpCUpaREREpCQoaREREZGSoKRFRERESoKSFhERESkJSlpERESkJChpERERkZKgpEVERERKgpIWERERKQlKWkRERKQkKGkRERGRkqCkRUREREqCkhYREREpCUpaREREpCQoaREREZGSoKRFRERESoKSFhERESkJSlpERESkJChpERERkZKgpEVERERKgpIWERERKQlKWkRERKQkKGkRERGRkqCkRUREREqCkhYREREpCUpaREREpCQoaREREZGSoKRFRERESoKSFhERESkJSlpERESkJChpERERkZKgpEVERERKQsx3ACJSApKJOqARaMi6NQLVgAndyPMYoBVYE7qt7XE/2ZIa5k8jIiXKWGt9xyAiIy2ZqAGmABsFf7Nvk4AELjEZBURHMLr1wPvA28Bbwe3N0P3M42TL6hGMS0Q8U9IyxIwxrwDTgd2ttff6jWboGGOWAPcAy6y1M/xGIwUlEzFgBjAbmBX8nYn7bU4BxniLbWitBV4B/gP8O/jrbsmWNzzGJSLDwGv1kDGmBjgW2BfYFpgAxIH3gGeAB4HfWWv/6S1IkWKWTFQD84HNs24zcftSuasHtghu3SUTa4EXyCQyzwFPAM+SbOkcwRhFZIh4K2kxxhwE/AhXPJ3WiisaTtC9kfCdwNHW2hUjF+HAqKRFhk0yUQVsCSwEtgtu86mM5GQotQJPAY+Hbk+RbGnzGpWIFOSlpMUYcyLwY1xi8jxwGXCbtfbN4PUosBWwP/BJYC9gY6DokxaRIZFMxHEJynZkkpT5QJXPsMpEDbB9cEvrIJl4FpfAPAY8DDxJsqXLQ3wikseIl7QYY7bFHRCqgBuAI621rb0sXwVcCPzWWvuvkYly4FTSIgPi2qAsBHYHlgA746o+xJ/VuGPVA8BfgEdItuQ9VonI8PORtNwC7AcsA+Zba9cMYluNwJnAIbg6fICXgD8AV1hrW3pZdybwOVwpzhRctdRTwC+An1tr815hGWM+ApyGu/JtB54EvmGt/VO+pMUYkwQuBq4GTgBOBT4KzMFVh21jrX0ytPyE4LMdCGyK6zL6Mi7R+4a19t0ccY0FDgKacXX8U3GlWcuA24DLrbV5GycaYxK4BPFQXLXd8mC9L+Iac+ZMWoLE8pPAEcA83Mn2XVwvjweAX1lrH873vhUpmYji2nHtHtx2xvXUkeLVBjyC2w/uBv5KsqXdb0gilWVEkxZjzDTg1eDhmdbabw5iW7OAu3AJAsC64G9d8PdVYE9r7X9yrHsg8DtcMTFAS7Beum3AXcAHrbVrc6z7PeBTwcMUsAqXdBjgDFyi0VvS8otg+YOBLtzV3GhCSYsxZjEuORkbrN4eLFsbPP4vsJe19vms2C4Hzgo9tQqXQKS7qy4PvpMeDZuNMRsB9+OSE3D1/p247q7LgfOBn5KVtBhjYsH3tVvwlMV9nw2h973GWntk9ntWnGRiJi6p3BPYBTfGiZSudcB9wM3AzSRbXi2wvIgM0kiPiLtb6P6fBrqR4Mr+elxy8F9gb9zJdRTuhPAqsAnwB2NMdda6M4Hf4hKW+4C51trRuJPsKbirqT2Bb+d434+QSVguB8ZZa8fgSiV+ETw3oUD4H8L1ljoVaAzWn4QrIcIYMx24CZew/BSYi0tW6nElO7cB04DfB21/wl4HLsVdwTdYaxO4gb8WArcHsf3GGGPo6WpcwrICl1DVW2sbgF1xyc838nyeo3H/13W4nmB1wWeqxv1/Pg38o8B3Up6SiQjJxE4kE18lmXgG15Plm8ABKGEpB3W4UuPvA8tIJv5BMvFlkokdSSY02rjIMBjpkpYvA5/HXcXX2QG+uTHmWFyS0IkroXg66/UtcF0b48CJ1torQ6/9DFc98yKwpbV2Xda6J+N6NVlgjrX2heB5gxsHYhZwtbX2uKz1DHAHLuGB/CUtAKdYa3+c57P9CvgI8B1r7Rk5Xq8CHsU1VD7cWntdru3kWK8a18hwHrDEWntf6LVdcKUsAEuttfdkrTsLeBqXiGSXtPwAVzX0Q2vtJ/sSS1lzI8fuhauiOwCXkErleQe4BVcKc4cGwRMZGiN9NZCu7ng/X8JijLnAGPNWjlu45OOw4O8fsxMWgKDBbvpk/uHQtg2uvQbAN7MTlsBPcSUWJvQ+AFuTqTr5ao73tMBXcn2mLCuBK3O9YIypBQ4PHl6RaxlrbTuZz7ZXH94vvV4brus4uPYTYenP+Uh2whKs+wJwTZ5Nrwr+bpTn9fKXTIwmmTiBZOImXEnVH3GJsRKWyjUROA63r64gmbiFZOJYkolRfsMSKW3FOPdQA7kP9onQ/W2Dvz1OsCF3A0eFlgXYLLSdnOtaa1PGmHtxpR3hddP338luSxLyEK70p7fv9e/W2nwDWy0k06X1r7lrcYBM25Zp2S8YY+biqmR2xY2IOorMvC9pU7Iepz/bfeR3H67hcLZbgXOBg40xNwJXAfdZa1f2sq3S58ZMOQA4Jvhb3fsKUsGqcNVI+wHrguT2N8CtJFs6vEYmUmJGOmlJ93gZbYwxuUpbrLXnAeelH4eqS8LS7UZe7+W9Xgv+jgu9V7i9SV/WDS9f8D2ttW3GmBXA5F62vbyX18KlFX25Sq8LPzDGHImrNks3KE7hGsWmB80ahWsbk92VNv3Zehv2POfnttbeZ4y5CLgI18j0oCCW53Dtln6UqzF0SUomDLAYl6gcTvkMhS8jpw7Xy+4I4F2SieuBXwP3k2zRnCoiBYx09dCzwd8a3FwogzWYq9vhujLOWzwS6G2wqvT/4z1rrenDbcmGN3VdpH+CS1iuwZXa1Fhrx1hrJ1trJ+MagfYlxn59Lmvtl3Bdt8/HNfhdhWtAfBbwjDEmVwlN6Ugm5pJMfBnXWPp+4GSUsMjgjQVOAu4FXiWZ+Pm5+6cAACAASURBVDrJxAK/IYkUt5EuaQlXPxyAa9g6EMtxI+RO72WZjYO/K0MlOuFSjum4xnK9rRtePn0/u2plg6CR7LheYirk7eDvGGPMZGvtW/1Ydz9cScozuCkPUjmWyVd6sxxoopfPRoE2K9bal3E9ly4NejXtghvfZVfgB8aY26y1+b7v4pNM1OKqFz9B95FTRYbDxsDZwNkkEw8BPwSu1dQCIt2NaEmLtfa/uDYQAGcYYwbaKO3x4O/uvSyzNGtZcFfK7/e2rjEmghuRNHvd9P1Jxpg5ed5zEYNLBP+OaxMDrmt0f6QTrX/mSliCRshLs58PpD/brr1sf7deXuvGWtsV9Jw6EOjAVUct7Ov6XiUTs0kmrsBVh/0MJSwy8hbhqnlfD0pfZhVaQaRS+BhL4Au4wdKmA78KZnrur3Tvmf2MMdtkvxh0eU73iLk2/XxQ4vL74OEZxpi67HWBj+NGkrWh9wE36u0Lwf1zc7ynIdQWZyCstatx488AfMEYk7ddizEmlpX0pUf/nZ9nHJaTyIwanO13wd+djDE9EhdjzGa4OvhccfQ2F056UDwo5oaqyUSUZOJgkonbcXNhfRZV/4h/43ClL/8mmbiDZOJDwXQPIhVrxJMWa+3juIHVUrhBzJ40xpwQjMgKuATAGDPTGHMOsE+OzVwDpEd1/aMxZs/0idoYswdufIQ48C9cI7ewrwBrcVUhfzLGNAXrVRtjTgK+Eyz3s/QYLUHcFkgGD08wxlxmjBkdrDsJ1415KZmReQfqPFyD5Y2Ah4wxh4QHyDPGzDLGfAbXPihcenEXLtGaD3wnFFtj8D1+H9fdugdr7QNkukNfZ4w5MChxwhizM25Au3zF1L8wxvzcGLOPMWbDMPTGmBm4AetqcFMk/KXvX8EISSYmkkxcgCuB+yNukMKBtPcRGU4GN7zB9bhB7L5IMlG5QwxIRRvxuYc2vLExB+Fmeg73tGkF1uC6PYevzG8FPhvuatzHYfz3stb2aDcTvPe1ZIbxfx9XhZHudfNn4OA+DOPfhWt0Opq+D+PfY2C6HO+xPe4kmm5j0okrSRlF9+8le5C4K3ClBGnv4UZejeIayP4duCBXDDmG8V8ffL5Cw/j/EZd8QmYI/yoy/4cu4Hhr7S97+8wjKpmYhystOxLNmiylqQ34JfA1ki3l0TtPpA+8DTVtrb0JN27KybgJDpfhSl8acSfb+3ClIltYa/fPHhslKAXZCvgf3GitaU8DX8KNdpuzoW/w3gtwvW1ewZ1g1+Em9zsZ2CdXwhKs+2lcl9e/4g4cJoj1QGvtd3Kt01/W2r/het+cixv7JT0/0Xpc4nEZsH04YQnWOzOI/4kgthiuWuszuIbP+caHwVr7Jq79xhW4/0UUl4D8DDeOy4t5Vj0PN/HkbbgSi6pg3ReBnwPbFk3CkkzsQDLxR9xv5KMoYZHSVY2ryn6OZOI6konSaDMmMkjeSlpERkwysSeupChfQ2SRcnA3cCnJljsLLilSopS0SHlyA8EdgktWdBUqleRxXGnsdSRbcg19IFKylLRIeUkmorjqu3OBzT1HI+LTC7jOA/+n5EXKhZIWKR/JxKHAl3ED5YmI8xRwAcmWm3wHIjJYSlqk9CUTu+NG4/2A71BEithDwOdJtvQ2MapIUVPSIqUrmdgal6zkGstHRHK7HZe8PF5wSZEio6RFSk8ysRlwCW6cFQ0GJ9J/6RG/LyTZ8nyhhUWKhZIWKR3JxETgItxYNPECS4tIYV3Aj4AvkGx5z3cwIoUoaZHi5+ZbOQ03onDCczQi5WgFbrTsn6qnkRQzJS1S3JKJPXDzQc3zHYpIBXgMOI1ky8O+AxHJRUmLFKdkYhrwTeBQ36GIVBgL/AI4l2TL276DEQlT0iLFJZmI4ybHvMgYU+87HJEKtgr4IvAdki155y0TGUlKWqR4JBO7Aj8AtvAdiohs8AxwqsZ3kWKgpEX8SyYSuKqg432HIiI5WeB/cVVGa3wHI5VLSYv4lUzsZ639iTFmqu9QRKSgZcBJmklafFHSIn6odEWklP0MOItkS4vvQKSyKGmRkZdM7Juy9qcRla6IlLLXgFNIttziOxCpHEpaZOQkE43W2iuMMSf6DkVEhswvgM9oRF0ZCUpaZGQkE3unrL1SpSsiZekt4ESVushwU9IiwyuZqA5KV071HYqIDLvvAueQbGnzHYiUJyUtMnySiTldKXt9NGLm+w5FREbMP4GjSLY84zsQKT8R3wFIeUpd3HhMV8o+oYRFpOJsCfydZOIU34FI+VFJiwytZKKutdP+pCZmjvYdioh4dy1uXJdVvgOR8qCkRYZM50WN87tS3FAdM5v5jkVEisaLwBEkWx7zHYiUPlUPyZBo+0LjJw08poRFRLLMBB4imfi070Ck9KmkRQYnmahb32F/VRs3h/gORUSK3i9wA9K1+g5ESpOSFhmw9gsbN+lKcWdt3MzxHYuIlIy/AYeQbHnddyBSelQ9JAPy3rmNS63lKSUsItJP2+N6F+3kOxApPUpapN/eOKvh7MZq7qiOmUbfsYhISZoM3Esy8XHfgUhpUfWQ9NkLpzfE6uL835SGyGG+YxGRsvF93NxFnb4DkeKnpEX6ZNlnGibUV/Hn8XWRBb5jEZGycx9wOMmW5b4DkeKmpEUKevH0hoUT681tDdVmnO9YRKRsLQMOINnyL9+BSPFSmxbp1XOfHnXEtIR5UAmLiAyz6cADJBO7+g5EipeSFsnr6VNHnT17bOQ3VVFT5TsWEakIo4E7SCYO9R2IFCclLdJDc1PcPPmJUf+7xYTI16MRo9+IiIykauBakolP+Q5Eio/atEg3zU3x6kuWVv9hy0nR/XzHIiIV71KSLef7DkKKh5IW2eBzO1ePOX7r+F2bT4hu6zsWEZHAL4AT1SVaQEmLBL6yR83GR82P37PpmMgs37GIiGS5HTiMZMsa34GIX0pahB8cUDv/g3Njd0xpiGzkOxYRkTz+DuxLsmWl70DEHyUtFe6HB9budNi82J/G10XG+I5FRKSAfwB7kmxZ4TsQ8UM9QyrYN/au2ePwebFblbCISInYCriHZGKi70DED5W0VKDmprjZfkrk4FO3r7p6XF1Ekx6KSKl5BlhKsuVt34HIyFJJS4VpboqbrSZFjlXCIiIlbB5ulmi1w6swSloqSHNTPDJvQuQTn9mx6rtKWESkxM3FJS5TfAciI0dJS4VobopHNh8f+cQ5i6ouVcIiImViDnAfycTGvgORkaE2LRWguSke2WJC5BNnL6r6qhIWESlDLwG7k2x51XcgMryUtJS5oErok+csqvqKEhYRKWP/ARaTbHnHdyAyfFQ9VMaam+KRaY3mxLN2qrpECYuIlLnZwG0kEzrWlTElLWWquSkeGV3DR89bXH3JhPrIaN/xiIiMgG2AG0kmanwHIsNDSUsZam6KR6qjfOSCXaq/NC0R0SBMIlJJdgN+SzIR9R2IDD0lLWWmuSkeAY46b3H1xU3jo2pRLyKV6GDgJ76DkKGnpKWMNDfFDfChM3eqOm+7KdGZvuMREfHoeJKJr/sOQoaWkpbystcJ28TPXTIjNt93ICIiReBskonP+Q5Cho6SljLR3BTf6UObxy48uCm20HcsIiJF5DKSiRN8ByFDQ+O0lIHmpvj8pZtGrzjtA1V7RCNGiaiISHedwN4kW+7xHYgMjk5wJa65Kb7Z5uMjF39yYdWuSlhERHKKAdeRTMzyHYgMjk5yJay5KT5lXK254Pxdqvesjplq3/GIiBSxscBNJBMJ34HIwClpKVHNTfFxsQjnXLykeq/RNUaDx4mIFDYXuEZjuJQuJS0lqLkpPgo489ydq/aYMToyzXc8IiIlZB/gm76DkIFR0lJimpviMeATH1kQ33WHjWMLfMcjIlKCTiOZOMV3ENJ/SlpKSDB43OE7T4vucdi82CLf8YiIlLDvkUzs7jsI6R8lLaVll+kJc9jpO6inkIjIIKlHUQnSia9ENDfF59THOSm5pHpxbdzU+Y5HRKQMjAWuJ5mo9R2I9I2SlhLQ3BSfAJx+4W7VC8fVadZmEZEhtCXwHd9BSN8oaSlyzU3xOuD0j20VXzBvQnSu73hERMrQx0kmjvEdhBSmpKWINTfFo8AJ20yOzP/g3NjOvuMRESljPySZ2Nx3ENI7JS3F7aDRNSw6a1H1btGI0WBIIiLDpx74HcmE2gwWMSUtRaq5Kb4VcMiFu1Zv3VhtxviOR0SkAmwB/MB3EJKfkpYiFDS8/cQJ28Q3mj0uquJKEZGR8zGSieN9ByG5KWkpMs1N8Srgk1tOiow9cE5MAx+JiIy875NMzPcdhPSkpKWIBCPeHlobY9ZZO1XvHouYmO+YREQqUC1wLclEje9ApDslLcVla2C/83epnjem1kzwHYyISAXbHPiK7yCkOyUtRSJox3LyvrNiNVtPjm7nOx4REeEzJBO7+Q5CMpS0FIFg5uaTE9XEP7pVfG/f8YiICAAG+DnJxCjfgYijpKU4HAjMOXdx9TajqkzCdzAiIrLBpsA3fAchjrHW+o6hojU3xZuAzx8wOxY/ZWHVUb7jKVbWWn7zVCdXPtnOk2+lWNtu2ajBsM/MGOfuXM2mY/Ln3w//t5NvPtLOA692sXK9ZUyNYdG0KGfsUMVuM4a2rfMHf7uOG57vBOBjW8W56oM952FL3tvKF+9r79P2lsyIcs/H6rs9t+z9FOfe1codL3ayvhMWTIxw4a7VHNQUz7ud8+9q5dIH2/n9h2s5ZPP8y4lIXvuSbLnddxCVTiUtHgXzCp08psasOWbL+AG+4ylWHV2WQ65ZzzF/WM/dL3exqs1SF4dX3rf86LEOtvzhGu5+uTPnupc90MbOV67jd8908tYaS30cVqyz/OG5Tna/eh2XPdA2ZHHe8FzHhoSlN6OqDJPq898m1JkNy247uftAyCvWpdj5yrVc869OWtpc2fXf3khx8G/Xc83THTnf77kVXVzxSDv7zYopYREZuJ+RTIz2HUSlU5davw4FRp+7uGrb+irT6DuYYnXuXW3c8HwnsQh8fa9qTt6uirq44bVVKc68vZXfPdPJh65Zx7OfGsVGDZk8/MbnOzjvzy4pOW7rOJfuUc2kURFWt1m+89d2LrynjfP+3MaCSRH2nz24k/madstpt7bSWA1TGiI8tyKVd9mzF1Vz9qLqvK//4dkOPnTt+g1xh13xcDuvr7bsMzPKbw+ro7EafvC3Dk67tZWz72zlw1vEMMZ0W+dTt7QSMfDd/dR7U2QQpgLfBY71HUglU0mLJ81N8XnAngc3xWrnTYhu7TueYvXO2hTf/5urSjlzxyo+s2M1dXF3Ut64McL/HVrL5uMjtLTBJfd3LzW5+F73eIepUX5+cC2TRrmfe0O14YJdq/n4ti4hOOfOwZe2XHh3G/9dZfnS7tVMqjeFV+jF1f9wJSbbTI6wYFL3kpY/ByVKV+xTw+gaQ8QYPv2BKrbbKMJrqyz/Xtk9Wfr1Pzu4++Uuztu5mpljtbuLDNIxJBOH+A6ikuko5kFzU7weOGlcrVlz1IL4gb7jKWZ3v9xFe5e7/9mdqnq8Ho0YTt/BPf9/T3fQ0eXaaL25OsWTb7kT+Gd27LkewJnB9p5ZnuKxN7oGHOPjb3bx3Ufb2XpyhE9tn/u9+mrFuhS3/MclJtmlLAAr17nPt1lWG550QrJiXaaN2qo2y9l3tjJzjOHcxYOLS0Q2+F9VE/mjpMWPw4DGsxdV7VQXNw2+gylmy953iUeiGiaPyv1znTvePf9eq0sgAF5tSfV4PdussRFiwUt3vVS4LUouKWs55eb1pCz8YP8aopHBlbL85qkOOlIQj8BR83smLeOC9i4vvde9ROXFd1PdXge44M+tvLXG8t39aqiJDS4uEdlgEnCZ7yAqlZKWEdbcFN8C2GPJjKiZNyGyje94il26eUaql05unaHz97+Wp4L1MifprjzNS1I2s930ev31vUfb+fsbKU7YJs5O0wbfRCxdNbT/7BgT6nvunkuD3k5n3dHK+62WlLX879/aeezNFBs3GprGuXWeeLOL//17Bx/aPMZ+g2yvIyI9nEQysch3EJVIScsIam6KjwJOihpWfnSr+H7ZDSalp+kJ9xNd3Q7/bcmdWDyzPFO188ZqG6xncr4e9tyK1Iak5Y3V/U9aXl+V4gt3tzGu1nDZnvkb1vbV0+908fibLo5cVUPgqsg2GmW47YUuxn1tNaO+sppTb2kF4Gt71mCMwVrLJ//USk0MvrmPGt+KDAMD/JBkQp1ZRpiSlhESTIZ4ONBw8nbxpvF1kcm+YyoFu28apSpoi3rZgz0bzLZ3Wb71SGbMk9VtLguZNCrCVpPcz/vyh9tJ5RiPKLy91e39H6/o9NtaWd0Ol+5Zzbi6we9KVz3pSlnG1RoOmJ37WDixPsKDJ9Rz+LwYjdWupGjhlAh/OKKWoxa4ROfHj3Xw19e7uHDXajZJRFjTbjnj1lYmX76amktW8YGfrOHOFwdWHSYiGywAzvQdRKVR0jJy5gFLpjaY9/bYLLbUdzClYmJ9hE9s5xqR/uBvHVzw51ZeW5Wio8vyxJtd7P/rdbz8viUe/JLDTUou3s2Vfvzz7RSHXLOep9/poqPLsuz9FGfc2spvnuoMrde/Uq+b/93B75/tZMeNo5y4zeCrX7pSll8/5ZKWoxfEiUfzx7PpmAjXHl7He+c20vqFRv520ig+ONfFsGJdis/f3cbm4yOcuVMV1loOuWYd33m0nemjDYdvEef5lSn2/8067skzto2I9NlFJBMb+w6ikqhoawQ0N8WrgeOAd0/foWrPqqgZfF1CBfnaXtW8/H6Km/7dyVceaOcrD3QfTfZT28e566Uunl+ZYnRN5mR/yOZxvrzUVeHc+HwnN2YN/LbD1Cizxkb49VMdjO5HLcradsunbmklalzj26Go5rv9RTf4HeSvGuqLc+5s4931lusOryUeNdz0fAd3vdTFAbNj3HhULRFjeODVOLv8fB1n39nKYydrShWRQagHrgA+7DuQSqGSlpGxJzB+j02jibnjI1v5DqbUVMcMNxxZy7WH1XJwU4xZYyNsOtqw36wYv/9wLd/at2ZDb6HZ47r/pD+/SzWPfLye47eOs8WECJsk3BD+V+xdzV+Or+OdtcF6Y6M93jefrz3YxqstlhO2iTN7nKt+Cd+CXtd0ptjwXKHpMtINcOdPjLDtRn2PJezBVzu5+skOjl4QY/dN3fXIzf92idqp28c3lCYt3iTGthtFePzNFG+tGVgDZBHZ4HCSiT19B1EpVNIyzJqb4hOBQ6KGt47dKn68Gt8OjDGuauPwLXqWQjz6ehfrg0KUHTfuecL/wNQoH5jacw6gji7Lo6+7Rro75Vgvn2UtLgH5yeMd/OTx3EPnA/z6qY4NVT4vnzGKGaNz/+/fb7UbSoE+ttXASlk6U67xbUM1fGPvTLHRsiCZ23R092Ru1liXtCx7P5W3K7mI9Nn3SCa2JNnSt0nFZMB0tBpGQePbI4GuT25ftc3Y2sgk3zGVo58/4Y4TS2ZEmdLQ95/075918/c0VMFBTf7y998+3UFrJ0QNHLPlwJKWbz/SzlPvpPjS7tXdkpB0+U5rVvOV9flzLRHpvybgNN9BVAKVtAyv+cB2UxrMO0tmRJf4DqYcPfzfTn76hDsDn7+4702Flq91MyUDfPoDVYyq6nsJ2FUfrM05e3PakqvWct+yrryzPGdLVw3tMys2oFKP11el+OJ9bTlH5J2RiABdPPZmF9sE1U5dKcsTb7kSpumjdd0iMkQuIJm4kmTLe74DKWc6Yg2T5qZ4Da7x7cqTt6vaRY1vB+6elzv55sNtvPReiq5gYJX31lu++9d29vnVOjpTcPK2cfae2T0Hf3tNivPvauXxN7to63TrtXVabniug52vXMeyFsuWkyJctFvuf82Mb63GfHEVx/1x/bB9tn+v7OKR11wCMdCqoc/c3sqa9twj8u4fdJ3+yl/aePFd9/1dcn87r62ybLtRRFVDIkNnDHC+7yDKnUpahs9ewNi54yMtW02KLPQdTClb1pLizDvaOPOONmIRGFUFLa2Zqo+PbxPnBwf07P6zvhMufbCdSx9sxwCja2BVGxsayu4wNcpNR9V6HeL+6mBsltE1cPAAqqjueLGT657p5MQ8I/I2N8VYMiPKva90Meu7a6iJuaqiWAQu30sDz4kMsdNIJr5HsuVV34GUK11mDYPmpvgk4IPAGyduE18ajZiBdQcRwPV2OWOHKraZHCFRbVjXARs3Go6cH+Puj9bxk+banHP+TKgzJHerZtfpUSaPMqztcHPz7LlZlJ8fXMNDJ9blHCp/pKSs5Zf/dEnLkVvEqe5n8tTWafn0La2MrTVcmmdEXmMMNx5Zx6e2jzOx3mAtbD8lwi1H123oYSQiQ6YGuMR3EOXMFOqKKf0TNL49Hdh8x42jnL+46hT1GBIRqRgpYFuSLf/wHUg5UknL0JsNbAu8fcyW8T2VsIiIVJQI8DXfQZQrJS1DqLkpHgGOAFbtOys2fZNEZKbvmEREZMTtTTKxl+8gypGSlqG1JTATWHn4vJh+sCIilesykgkVtQ8xJS1DpLkpHgOOAt47cn5s3oT6yBTfMYmIiDfb4M4JMoSUtAydHYBJsQirDpgd1yzOIiLyBZW2DC0lLUMgGEjuCOCdoxfEFyRqzDjfMYmIiHebA4f6DqKcKGkZGrsBDQbW7bFpbLHvYEREpGhc4DuAcqKkZZCam+INwCHAW4fOi80dU2sm+I5JRESKxtYkEwf6DqJcKGkZvH2AONC27yyVsoiISA8qbRkiSloGobkpnsAlLW/uPzu22cT6yFTfMYmISNHZkWRiD99BlAMlLYOzO+477DxoTmwX38GIiEjR+oLvAMqBkpYBam6KjwL2Bd7ebXp046mNkRmeQxIRkeK1hGRiZ99BlDolLQO3GKgC2g+dF1cpi4iIFKLSlkFS0jIAwbgsBwHvbD8lMnF6wszxHZOIiBS9fUkmFvgOopQpaRmYHYE6oPWwefFFmslZRET66NO+AyhlSlr6qbkpXgV8EFg+pcHUzRkXme87JhERKRnHkEyM8R1EqVLS0n/bAaOBdUdsEd82GjFR3wGJiEjJqANO8B1EqVLS0g/NTfEo8CFgZcRgtp8aXeg7JhERKTmfIpnQ+XcA9KX1zwJgPLD6kLmxOaOqTMJ3QCIiUnI2BQ7wHUQpUtLSR81NcQPsB6wGWLppbHu/EYmISAlTg9wBUNLSd1OBOcC78ydGxm7caGb6DkhERErWXiQTTb6DKDVKWvpuV6AT4NDN49urm7OIiAyCQaUt/aakpQ+am+L1wBLg7YYq4vMnRrb2HJKIiJS+j5FMNPgOopQoaemb7YA40HnE/PiC6pip8R2QiIiUvAbgCN9BlBIlLQU0N8UjwP7AuwA7bhzd1m9EIiJSRj7qO4BSoqSlsNnAJGD1lpMi4ybWR6b6DkhERMrGYpKJTX0HUSqUtBS2J9AKsP/s2JaeYxERkfJiUGlLnylp6UVzU3wcrj3LcgMsmBhV0iIiIkPtWN8BlAolLb3bAbBAaumm0U0aqs1o3wGJiEjZmUkysbPvIEqBkpY8gga4ewArAZZuqqohEREZNh/zHUApUNKS3wxgDLCuNkZ0zrjIFp7jERGR8nU4yYSG0yhASUt+OwJdAAc1xeZobBYRERlGo4Fm30EUOyUtOTQ3xauAXYDlAIumqWpIRESGnXoRFaCkJbcmoBpon1RvaqcnzGzfAYmISNnbm2Qi4TuIYqakJbddyYzN0hSNmKjneEREpPzFgQN8B1HMlLRkaW6KjwK2BVYAbD05OtdvRCIiUkE+6DuAYqakpaf5uO8lNaqK2LSE2cx3QCIiUjH2I5mo9h1EsVLS0tMewCqAvWfGNotFTNxzPCIiUjlG4aaPkRyUtIQEw/bPAt4HWDhFVUMiIjLiDvEdQLFS0tLdXNyw/TZiMDPHROb4DkhERCrOQSQTOj/noC+lu0XAGoBdp0en1sZNved4RESk8kzEnY8ki5KWQHNTvB5X0vI+wM7TVDUkIiLeqIooByUtGXMAA6QAmsZHm/yGIyIiFUxdn3NQ0pKxEGgD2HJSZNzoGjPeczwiIlK5NiOZULvKLEpagOameBzYDngXYNfpMQ3bLyIivu3hO4Bio6TF2Qw3fHIHwJxxEQ0oJyIivi31HUCxUdLibEXQliUeITK1wUz3HI+IiMjuJBPGdxDFpOKTluamuMF1LXsXYJfp0anxqKnyG5WIiAjjgK19B1FMKj5pAaYCjcB6gO02iqpqSEREioXatYQoaYGZ3R6MjWzqKxAREZEsSlpClLTAtsBagLo4sUn1ZmPP8YiIiKTtQjKhiXsDFZ20BF2dNycYBXfxJtGp0YiJ+o1KRERkg3pgB99BFIuKTlqATYAo0AWw1aToDK/RiIiI9KQqokClJy2zcEP3A7DZmIi6OouISLHZzXcAxaLSk5ZtgFXgxmeZNMpM8xyPiIhItu1IJir9fA1UcNLS3BSvwpW0rAJYOCU6MRYxMb9RiYiI9NAIaBJfKjhpAaYRmtV5i4mRKX7DERERyesDvgMoBpWctGxGqD3LpqOVtIiISNFS0kJlJy1bA6vTDzZqMEpaRESkWClpoUKTluameBSYTdCepTZGdEyNmeg3KhERkby2JJmo+HnxKjJpASYQGp9l4ZToJA0qJyIiRawKTZ5YsUnLFELtWeZNUHsWEREpehVfRVSpScsMgl5DADPUCFdERIqfkhbfAXgyFzXCFRGR0rLQdwC+VVzSEjTC3RRYAzCqitjoGjPBb1QiIiIFzSGZqPYdhE8Vl7QAE3GfuwtgwcTo+Igxlfg9iIhIaYlS4SPjVuLJulsj3M3GRMZ7jEVERKQ/tvAdgE+VmLRsRlDKAjC10YzzGIuIiEh/zPMdgE+VmLR0a4Q7sd6opEVEREqFSloqRXNTPAJsaVw/4wAAIABJREFUQtAIF2BsrUpaRESkZGzuOwCfKippAcbgPvOGMVoS1UpaRESkZGxGMlGxI7hXWtLSrSpo09GmIR41FT+Xg4iIlIwq3LAdFanSkpZxhHoONY2Pqj2LiIiUmjm+A/Cl0pKWaUBn+sGM0WqEKyIiJadix2qpxKRlXfrB5FERtWcREZFSs5nvAHypxKRlffrBuFoz1mMsIiIiA7Gx7wB8qZikpbkpXgs0Am3p5xqqafQXkYiIyIAoaakA4wiNhAtQFzdKWkREpNQoaakA4wn1HKqNEa2JmVqP8YiIiAzERJKJuO8gfKikpGUCoaRl+uhIg8dYREREBiqCm/y34lRS0jIZaE8/mNJglLSIiEipqsgqokpKWsYTaoQ7sV5Ji4iIlCwlLWVuHKGSlvF1ETXCFRGRUqWkpcyNJVTSMrpGJS0iIlKylLSUq+ameDVQS2gI/0Q1SlpERKRUTfUdgA8VkbQAo4BU+ImGapW0iIhIyarIEd0rJWlpBGz4iZqYqfMUi4iIyGAlfAfgQ6UkLQ2ExmgBqIpS7SkWERGRwRrtOwAfKjZpiUeUtIiISMlSSUsZG0tWm5a4SlpERKR0KWkpY+OAjvSDxmriEWNML8uLiIgUsyqSiYqbP69SkpZRhLo7j64xKmUREZFSV3GlLZWStNShpEVERMpLxTXGrZSkpR7oSj9orFbSIiIiJU8lLWWqW0nLqColLSIiUvKUtJSpWkIlLaOq1HNIRERKXsWN7F72SUtzU9yQlbTUxU2Vv4hERESGRNR3ACOt7JMWIIb7nBvGaYkY1N1ZRERKXSWcw7uphA9cTdbAcgYlLSIiUvJU0lKGqsmaLNGopEVEREqfkpYy1KPRrTIWEREpA0paylCPf6pKWkREpAwoaakEatMiIiJlQElLGeqRoGiqRJHh15WyqcJLicggVMI5vJtK+MA9kxaVtIgMOwtdXSnbVXhJERkglbRUArVpERl+sYiJr+9kre84RMqYkpYypARFxJPqKDVrOljtOw6RMtXhO4CRVpFJS8p2H7dFRIZHPGqq1nZG1qes1T4nMvTW+w5gpFVC0tJDayftvmMQqRQTaromvLau6i3fcYiUoXW+AxhplZC09Chpae20FVekJuJLxBhTHUnF1nawxncsImVGSUsZ6pG0rO9QSYvISJpU2zXhP+sbV/iOQ6TMqHqoDPWoS1/XoZIWkZG2Wc3qsS+trXnDdxwiZUQlLWWoM/uJtSppERlxjVW28Y2OhtbOlO2xT4rIgChpKUM9EpQ17VZJi4gHOzS8M+2eVRsv8x2HSJlQ9VAZ6lEVtKZd1UMiPsSjJj4usi62vDW60ncsImVAJS1lqJ2sxrir21Q9JOLLNg3vTr9x7YJ3NXSLyKCppKUM9UhaVrWppEXEF2MM+9b9K/GXVRu97DsWkRJXccMIVELS0kFW0tKRIqWJ3ET8mVrbMfGZro271nVWXvG2yBBZS7Kl1XcQI63sk5Ybn+9I4RKXbp+1VQdLEa+Oafj75B+v2vlN33GIlKi3fQfgQ9knLYE2smbDXN9pK65YTaSYjIozarp5hxfW1GnsFpH+e8d3AD5UbNKytr3y6gJFik1z4t8zvtXe3KGxW0T6TUlLGWsl67OuaVdJi4hv0YiJnhy/NXJNy3yN3SLSP0paythaIB5+YnW7XespFhEJ2bKhZdojzI+tbIu85zsWkRKipKWMvUtW0vJ+q6qHRIrFhbXX1Z+/7hjtkyJ9p6SljK0AqsJPvLde1UMixWJiTdf4ebzU8VDLxFd8xyJSItR7qIytJKukZcW6lJIWkSJySsMDGyU5qb61s/JG+RQZAJW0lLE1QLcxw99Zq5IWkWJSG6P2LPvLNd9avfQt37GIlAAlLWVsLZAKP/HaKiUtIsVmr8Sy6Q9EFta/vLZGg86J9O413wH4UClJS48EZeV629bRpTmIRIpJxJjIN6Lf7zi187MxTbUhkte7JFve9x2ED5WUtJjsJ1e3oy6WIkWmadTaqXNTL6z/fctcjd0iktuLvgPwpZKSlh6ftaXVKmkRKUIX1V3f+KX4aZPfa4tU5NWkSAFKWsrZjc93dOBGxY2Fn393vZIWkWI0pjo1+vSOK986f91HVvuORaQIveQ7AF8qImkJvEfWWC3L16WUtIgUqY82Pj718fhWox9dNU7VRCLdqaSlArwN1ISfeH2VSlpEilVVlOrLuy5feVrk/LFtnbT6jkekiChpqQCvA7XhJ158L7XSUywi0geLG9+cPq3rv2u/v2rXN3zHIlJElLRUgDfJatPy/IrU+10pm8qzvIh4FjHGXB77Id+tPXHGq+uqKnLYcpEsrbiL8IpUSUnLe0C3cR86UqTU7VmkuM2ob5t8zPprXz2t4wyTsrrIkIr3CskWW3ix8lRpSUvPJ9fbFSMdiIj0zzmjbhn779ic0Te2zH7Fdywinr3gOwCfKilpeReIZj+5fJ1VuxaRItdYZRsvbP/Wf8+PnzO1pd2s8h2PiEf/9B2ATxWTtNz4fEcb8D5QHX7+1ZaU6slFSsDhiac3Gde1cv1Faz+sAeekkj3pOwCfKiZpCbwG1IWfeGZ5l2aUFSkB8YiJf5NvtNxQe/AmT6we/arveEQ8+YfvAHyqtKTlVbK6PT/5Vmp5Z8p2eopHRPph+8aV03dtvfeNUzk/0d5Fm+94REbYGtSmpaK8Tla3584U9t31VlVEIiXi0uqfx96MTWn80aqdKrbbp1Ssp0i2VHQPukpLWpYDPbqKvbXGqopIpERMqe2Y+InWn79yRc0nZ7y+Pv6O73hERlBFVw1B5SUtbwEm+8ll76fe9BCLiAzQaaPunljftabt9Pb/b+++46Ou7z+Avz7fm9kEwggbAYODuke1pSp11TZVO6zd+6dWrbVapa01ah1VUdtaZ2vVatW6T8QJgjJkIyNwBEIChAyyLuPWd3x+f3wukHEJCST3zeVez8cjD8h975J3GHev+4z351fSkjJle1ZQyknpRbhAioUWn19vBhBApx1EW2sZWoiSSYYLGXcacyvXeE4d/W5gyk676yFKEIYWuwuwwQ4AWe1vWFNp1rDTJlFy+Wr29knTo1vrbnTdNLY5KprtrodogFkANtpdhN1SMbT40Wnbc1CH0RgGO+MSJRGHJhwPiIeCrY4c722tl9TbXQ/RACtBUSBodxF2S8XQUoE4i3GrWzhFRJRsZmY1Tbgg9M7uV9K+OWljc/Zuu+shGkCr7C5gMEjF0BJ3MW5Zo7XXhlqI6DD9Oe2/6Zqlm1fJm7J0E1G76yEaIMvsLmAwSMXQ0gAgBMDV/sa1lVa5PeUQ0eHI85ojfhN5rHy3e8qwfzedvMfueogGyFK7CxgMUi60+Py6BFAKILP97av2mjURQ4btqYqIDscvspbnD9drWu7xXDOpKuTcZ3c9RP2sCcAmu4sYDFIutMRsA5DR/gZLQla2SJ5nQpSEvE6k/cWcW2NpLsd1kSsM9m6hIebTVO+E2yZVQ8suxFnXsqOeU0REyWp2zq7JMyPraz71npG/IDChzO56iPrRErsLGCxSObR0+dnXVppliS+FiPqDJoT2oONhAwCud84Z06Kjxe6aiPrJYrsLGCxSNbQ0AqhDpxOfl+8xK3VTcvcBUZKalhkc+83Qq+XNzty0u1u+yt5LNBSEAaywu4jBIiVDS2wx7gYAOe1vNyzIqhbJXg9ESeyP6a/luK2w/nzadydvacnkbiJKditQFIjYXcRgkZKhJaYYgLvzjTsauK6FKJkN88hhN0f+vgsArpS/y9AtqdtdE9Fh4NRQO6kcWuKGk8+qTIYWoiT3/ex1E0brFU1lrmm5zwVO4K5ASmYf2V3AYJLKoaUWau97hxOfl+42KwxLGvaURET9we2Ae651fz0A3Om5dtK+sKPO7pqIDkET2FSug5QNLbF1LRsBDGt/e9iAuadJ8qh7oiR3ZnbV5NPCy6sMzeu8PvzzCFu3UBL6EEUBTm+2k7KhJWYTOo20AMCmGnObDbUQUT8SQuA+9+MC0pKfeL80dnHTWL4ZoWQz3+4CBptUDy3liHPi84JSg6GFaAiYmB4d/ePw82UA8BvHnFFBA0GbSyLqC4aWTlI9tNRAHZ7YYRfRjgbZVBe0qu0piYj6028z3s1LM5sjDc68jPuaLqixux6iXlqPokCl3UUMNikdWnx+3QKwHkBu52vb6iyOthANAVlumVUUfagCAP6d9oPJJS3pFXbXRNQLHGWJI6VDS8waxOnXsnwP17UQDRXfyCmeODG6owFC4CrrBi93CFISYGiJg6EFKIE6PLHDAYofl5sVYUNy/ptoCHBqwvkgHmgGgBL3jBEvBWaydwsNZvUAPrW7iMEo5UOLz6+3QAWXDi39LQm5s8EqsacqIupvJ2U3TDwrtLACAIo810+si2gNdtdE1I33UBQw7S5iMEr50BLzKYDszjeur2JoIRpK7vY+7RbSsHTN67wx9GOOpNJg9bbdBQxWDC3K1ng3vr/D2G5a0kp0MUQ0MPLTjJFXhZ4qA4CF3i+PWxoYVWZvRURdhAH47C5isGJoUaoANABIa39jXUhGdjfJHfaUREQD4VfZi8ZkGfVBAPi1Y87IsIGQ3TURtTMfRYFmu4sYrBhasL+l/6cAhne+tqrC3Jj4iohooKQ7kX63MbcKAGqdozMebJpdZXdNRO28aHcBgxlDywEbEefP402/vtXg0fZEQ8qF2aWTj4wW1wHA42k/mbyz1csmXjQYtACYZ3cRgxlDywGlAEwAzvY3NkWg72xgozmiocShCe0h7a9qWkho4irjN07TktytQXbzoSjA6coeMLTE+Px6FMBaACM6X1u2m1NEREPN0ZnN4y8KzdsNAFs8M0e+Gjiq3O6aKOVxauggGFo6WgbA2/nGt0uM7RFDhm2oh4gG0O1pL2Y4rKgJAH/y/HZCQ0RrtLsmSlkNAN6zu4jBjqGlo60AogBc7W8MGzBL6q1ie0oiooEywmsNvyHySDkAhLUM15zg97hrg+zyOooCUbuLGOwYWtqJTREtBTCy87WPy81Nia+IiAbaT7NWjh1hVLcAwLtpF05Y2TSC00RkB04N9QJDS1cr0WkxLgC8v8MoC+qS78KIhhiPE957zfv3tX1+tTZneMQAp4MpkaoBLLS7iGTA0NLVdgBBAJ72N1oSsnifxdEWoiHo7Ow9k4+LrK0GgBrn2Kx/NM/aa3dNlFKe4VlDvcPQ0onPrxsAPgaQ1/na29v0dYmviIgGmiaEeMD5DxNSAgD+5v3FlF1Bd7XNZVFqkACetLuIZMHQEt8qAI7ON66ptPZVNls80p5oCJqaERr7nfD/1HoW4RBX678WPHuMEuAjFAW2211EsmBoia8cavtZeucLS3aZqxNfDhElwpwM3zCPFdQBYIPnhFFvNU0vs7kkGvqesLuAZMLQEofPr1sAFiFOo7lXivXisCF5pD3REJTjljl/iPxt/2jqHNeN4wJREbCzJhrS9gF43e4ikglDS/dWQ/35iPY3hgyYG6ut9faUREQD7fLsDRPy9d0BAAg5sjy3tH6boYUGyjPszdI3DC3d8Pn1SgB+ALmdr722RV8jYwv2iGhocTngfkDev78zri/t6xPXNQ3jWjYaCJwa6iOGlp69ByCr842b91n1Fc2y1IZ6iCgBTs+qmfT58NL9256vEnNyoiYidtZEQ84iFAVK7C4i2TC09Gwz4vRsAYDFZQYX5BINUUII3Od+0gFpSgCodE3Iebzp8xV210VDCkdZDgFDSw9ibf0/ADCq87XXthj+oC5bEl8VESXC+PTo6J+Gnitr+/wB75WTK0KuGhtLoqGjBsBrdheRjBhaDm4Z4izI1S1Y6yrNtfaURESJcH3WeyPTzUAYAKRwatdGfyUtLmijw/cwigKcbjwEDC0H4fPrNQA2Ic725+c36isNSxqJr4qIEiHThczbow/tX9uyxnPq6HcDU3baWRMlvSCAR+wuIlkxtPTOBwAyOt+4p0m2Fu+zPrOhHiJKkItztk6cEi2pb/v8BtdNY5ujgoen0qF6CkWBOruLSFYMLb1TDKAJQFrnCy9s1JdxuJho6HJqwvkAHty/fi3oyPHe1npJfU+PIeqGCeABu4tIZgwtvRA7RPF9ACM7X9u8z6ovbZBbEl8VESXKCdmNE2eHP9jT9vkrad+ctLE5e7edNVFSehVFAU4vHgaGlt5bDnUaZ5eDFF/boi9NfDlElEh3ef/jFVLff4DilfLmLN0Eu5lSX9xndwHJjqGll3x+vR7AxwBGd762ZJe5t6LJYnomGsJGe428a0L/LGv7fI978rCnAqdwtIV6azGKAuzvdZgYWvrmfQBudNr+DADzSwyOthANcVdmf5I/zKjbf2DqX7xXT64KOffZWRMlDY6y9AOGlj6InUe0BnFGW97aZuyoC1pVia+KiBIlzYm0u4y5+/+fW5rLcV3kCoOL8ekgigHMt7uIoYChpe/mA/DGu7Bgp7kswbUQUYKdn71z8ozIpv2jK596z8hfEJjI6WHqyV0oCjDY9gOGlr4rBbANcZrNvbhJ3xQIS26FJBrCHJrQHnL8tUM30+udN+e36OCxHhTPZgAv2F3EUMHQ0kc+vy4B+BDn9GfDgnx3u/FR4qsiokSakdk6/uuhN3e1fd7szE27u+VrtXbWRIPWrSgKWAe/G/UGQ8uhKQawF0BO5wv/3ahvqg9Z1YkviYgS6db0l7OcVnj/MR7Pp10+eUtL5p6eHkMpZy14MGK/Ymg5BD6/bgF4HUBu52sSwJtbjYUJL4qIEmq4x8q9MfxoefvbrpS/y9AtqdtVEw06t3AtS/9iaDl06wE0IM6ZRK9vNbZVtVjs30A0xP04Z9W4kUbl/rUsZa5puc8FTuD/fQKAZSgKcMdQP2NoOUQ+v64DeBlxWvsDwCvF+oLEVkREieZxwHufObfDWpY/e66bVBN28EA8+qPdBQxFDC2HZyWAfQCyO194f4dZvjtglSa+JCJKpFnZFZNOCK/ev47N1NyO68O/iLB1S0pbiKIAN2UMAIaWwxA7SPFFAMPjXX9hE0dbiIY6TQjxgOsRC+1CyhLvrLGLm8aV2VcV2YyjLANE8N3A4SkscDkA3Aa1Bbqh8/UHz/d+e+pw7aiEF0ZE+1W1WLj7kyjmleioaJLI8QqcOs6B605zY/YRzj5/vUVlBs5+JnjQ+5Vdl9k6KUfrsO4tako8tU7HygoT66tMVLVI1AYlvE5g2nAN50914trT3MjPiv+esrzRwk0fhvH+DgMhA5g5SsMtszz4WoGr2zrmfBjGPUujeO3babjkqO7vR/1iHooCX7O7iKGKoaUfFBa4ZgK4AUCXrpgnjNHybj3Lc5UmRJfzioho4G2oNnHOM0HUhdRzXbYHaIkCllSHiN0124Obv+Dp09dsCy2aAEamq//aloSsR7aQ7f6rX3/5l8rvG/fRpPaPrWqxkD/3QB86h1A1NYbV7kMAyPEAr1+WjrOndAxUtUELxz/WiopmCU0AHgcQMtTP8cI30nDZsV0DydZaE8c91orZU5yY/730Pv2c1Gc6gGNRFNhmdyFDVd/fYlA8mwCUABgDoMOivHVVVu2Gamv18WMcp9hSGVEKC+kShS+owHLCGA3/uSQNx4xyoCkicfviCOYuj2LOgghOzHfgvKl9fzqckC1Qdt3+PpPiuYZjdvwx7fdT2254WcpJv2xZUTE9Mziu7TavU+C609yYNcmB08Y7MCZTQBMCUVNiQamB69+PYGuthW+9HML2azMxzHsgBD2wPIqKZonzpzrw4jfTke0BHlml45p3wrjhgzC+fYwTnd8f/Wp+GJoA/n5h3NNHqH/9lYFlYHFNSz+Idcn9H9QUUZcRlUdWRT+KGDKc8MKIUtzja6IoD0hkuoG3Lk/HMaMcAIBsj8D953lx8QwVVOYs6J//npdlb5w4Ti9v3H+DELjKusFrWHJ/E7phXoEHL/DikqNcGJulQYuFDLdD4MLpLsy7XI2G1IUk3vJ3bPmyYKf6Mg+c78Uwrwo7V5/qxkn5GvY0SWyr69h49fkNOhbuNHHzmR5MHc6n+wFWDeAOu4sY6vivuP+UANgAYFTnC1UtMvRRmbko4RURpbjnN6oX/e8e68K47K5Pdzee4QYArK20sLXWPOzv53II1wPy/kD720rcM0a8GJhZ3t1jOps6XENubFBkb3PH6fu6oPr8iFyty2MAoDZ44P5NEYkbPghjaq7ATV9w9+GnoEP0exQFmuwuYqhjaOknsdGWVwGkIc5oy5NroqsaQnJflwcS0YBojkis2atGHs6fFn/q5/TxDuTElrMs3Hn4oQUATs2qnXRm+JO97W+7zXP9pLqI1mWhfjz+WhMNsYGfKZ3CyYjY+pnSho4jKjvqrQ7XAeAPC8KoapH4+4VeeJ1cUjfAVgP4t91FpAKGln7k8+tlAJYDyO98TbdgvbRZfzfhRRGlqC211v6FrceMjP9UpwmBgjx1rXhf30PLvqDEiY+3IOOuJmTc1YQj/96C/5sXxg8bHvNCmvuHPXTN67wx9ONutxtZUqKy2cJLm3Rc9F91t4k5Al87smPYOmey+vy374fRGJawpMSjq6JYU2lhfLZAwQj1s6yrNPHoah2XHuXEhdO5WygBfs12/YnBhbj971UApwBwQa0k329+iVH65SOcxdOGa0fbUhlRCqlsPjAaMbab7cMHrlmobOn7a05QB9ZVWcj1Aq06UFJvoaTewlPrAsPPPvXm+pKz7tvfw2mh98vjlgbmlZ2ZUzO57baf+0L417quRxUdP0bD/76ZhjRXxxGS33zejWc+0/HudhMj7m3ev3sIAO79shdCCEgpceXbYXidwIPnc/FtAjyPosAyu4tIFRxp6Wc+v14L4E3EGW0BgEdWRd/TTR6oRjTQWtv9L0vrYbAhPXatJdr70DLMK3DjGW6s/kUGQn/IQv1N2Qj+PguLf5yOMyY4YErgwxVbhusb3+7wf/1ax5y8kIFQ2+c5HoHRGWL/GhZABZa/X+jF9BGOLt93VIaGpT/NwLeOdiLbo7ZtnzxWw+uXpeHymeoHeWKNjhUVJm6Z5cHEHA0tUYlfvxPGmPub4f1zE059sgUf7DC6fG3qOyllK4Cb7K4jlbBPywAoLHClAbgHaqSlpfP135zu/sLZU5yzE14YUQp5foOO77+u8oF+SxacWvx1Hd97LYj/bjRw3lQH3vt+l/NP+yxqSpzzTBBLd5vITXeZWVe/6hDiwPvD/wv+a+ec4QumdH5cU0RifomBmz8Mozwg8dvPu3H/eX0bKakNWih4uBWjMwQ+uyIDTg0477kgPiw1ceo4DUeOcMDn1xHUgfe/37UPDPXZH1EUuNPuIlIJR1oGgM+vhwD8B90cpvjo6ujyxrDkgWpEAyiz3YaZUA9jm0G97f79s1jV7RC442y1urchqDtG7lrQ2P7642k/mbyz1VvZ+XHZHoHvHOvC0p9mINsDzF0exetb+jYoe+MHEdSHJP7xFS9cDoF52wx8WGrioulOLP9ZBv5zSRre/m46DAu44QN2YThMGwHca3cRqYahZeCsBbAFcbZAhw2Yz34W9XGUi2jgtF/HsrfZ6vZ+bdfyM/tvh81p4w9M7Vza+J+OczFCE1ca1ztNS8Zd+TsuW8MlM9RUz1Prex9alu4y8Mx6Hd+d6dw/gjJvm/rWV53i2t8P5gsTnTgxX8PaSgtVLd3/uVD3pJQmgJ+hKMCp/gRjaBkgPr9uAXgOagt0l8npD0vNXZ9VW6sSXhhRipiRp+3vPbB5X/wXZ0tK+GvVtaNHdl1D0h+OzArlnRd6b0/727Z6jh35auCobnu3jMtSlbdtZT4Yw1KLb7M8wNx2U0rlAfX4KcM6PtVPi/V1KW9kaDkUQoi/oijA528bMLQMIJ9f3wPgHQBj412fuyzyYXNENsa7RkSHJ8sjcPJY9RTX3cLTFXtMBCLq97On9F9oWbHnwCDK5GEa/pz2XJpm6R1GVv7k+e2EhogW9///zliYyOxlT7i/fhrFxhoLd5ztwZjMA0/rbWO54U4/fk/TZdQzKWUpgFvsriNVMbQMvLcBtALossIvEEH0+Y36W4kviSg1fDe2o+b5jXqHLdBt7l8eBQCclK+hIK/3oaWnqV3dlPjTIpWE8jMFTszXMMprjrgu8ng5AEhLZZewluG6Ofi95s6PL6kz8cZWlTK+OPHgC2UrmizctjiC48do+NUpHVPO5Bz1FL+m8kBeMi2JdVXq80nD+BLQV0KIX6AocPAjvmlA8F/sAPP59VaoRbmjEadT7vwSo3RTjbku4YURpYD/O8mNSTkCzVHgqy8E9zeQa45I/O6DMF7bosLBXbO77tIRtzVB3NaEokVdF6we+2gr/r4iipI6c3+AMS2JJbsMzH42iCW71Pe5e7Zn/1qSX2Yty881alvrP3wc9R8+jvCeLXjXNXvCyqYR5QDQGJZ4en0UX3o6iJABZLlVX5aDue69MFqiwCNf8cLRaYfUV6ar0HPXJxHsqLdgWhJ//jiKPU0SJ+ZrHUZlqFf+haLAQruLSGXc75YYq2MfxwLY2/ni3GXR9x7+indahltkdXkkER2yNJfAm99Jx+xng1hbaeGYR1qR7QFaoqrHiQBw12xPn094Lt5n4dp3VZjxONRUVFNEIhob0HAI4M5zPPjR8QdCh9eJtHuM+0u/oY8+omXTAjSveQsQGs5weydlIrh/mgoAxmQKvPytNIyPc15Se+/vMPBKsYGfneDC5yd0/RkKC5w4a7IDi8pMTPt7C7xONVXk1ID7z2Xjub6QUlYJIW6wu45Uxz4tCVJY4BoO4C4AAeBAc6k2F89wTv/pCe7vJrwwohRQ1WLh7k+imFeio6JJItsjcOo4B35zuhuzj4gfWMRt6uy7W7/kRtFZHV/gn1gTxdLdJtbsNVHTKtEQlkhzqvUrX5rkwJWnuOMu7DWltM7e+dPGjbsCw8MCFjS/AAAgAElEQVTln8ForITZ2gjNjCAvDTh2lIaLpjvx0xPcyPH2vJspYkjMfLQVdSEJ/9UZyEuPH3CaIxJzFoTxcrGBQFjic6M13HmOF+f2MagRLkFR4A27i0h1DC0JVFjgOhPALwHsjHf9vnM9lxbkOWYmtioiSqRtLekV5zn/Oa7DjdKUH8ufV09Mj4yxqSzqgZTyZXFb07ftroO4piXRlgPYACDuE9P9y6LvhHTZmtiSiCiRjswMjrs09NquDjcKh7hav1YzLck9yIOMJWWlEOIKu+sghaElgWK9W56F+nPvMqFc3SpD/9mgv87RL6Kh7Y/pr+W4rI4bkTd4Thj1VtP0MptKojiklFIT4ocoCtTbXQspDC0J5vPr+wD8F90cqDhvm7Fj9V6LJ4YSDWHDPVbOTZGHd3W+fY7rd+MCURGwoybqSgIPoSjwod110AEMLfb4BKrF/+h4F/+yNLJgX6vVZZcREQ0dP8haO2GUvrdDn5aQI9NzS+u3GVoGAcOSxZoQc+yugzpiaLGBz6+bAJ4G4ALg6Xw9asKauzz6StSU0UTXRkSJ4XHCdb91f5eDU31pX5+4rmlYl1EYShxLyohTE99CUfuN6DQYMLTYxOfXq6CmicYhTtO54n1Ww5tbjXkJL4yIEuYL2ZWTT4msqOp8+1Xi98MiJviCaRMp8WsUBYrtroO6Ymix1yIAa9DN2UT/2aBv3LLP/CyhFRFRwmhC4F7HYw5Iq8Pq+0rX+OwnAp+vsKuuVBY15euO25set7sOio+hxUax3URPAwgCyI53n7s+icwPhCVXrhMNUVMyIyN/EHqhrPPtD6RdObki5KpJfEWpSzdlhdshfmJ3HdQ9hhab+fx6AMCjAEYgzrEKgQiij66OvmJa0uzyYCIaEq7PmD8mzWztsIZNCqd2TeRqabEHQkKYltQ1gUtRFOBC6EGMoWUQ8Pn1rQDeADA+3vVlu83K93cY7ye2KiJKlFyPTLsl8mCX6aC13lNGvxOYEreDNvWvqIlrHLc3rbS7DuoZQ8vgMQ9ACbrZBv3oan3l5hpzfWJLIqJE+UZO8aQJ0Z2NnW+/0XXT2OaoaI73GOofzRH5XNqdXMeSDBhaBgmfX9cBPAG1kyg93n1uXxyZV9NqcXEe0RDkcUC715rb5TDVoCPHW9R6Kde1DZCWqNyc5RE/s7sO6h2GlkEk1i33n1BnE3X5uwkZMO/8OPJSUJctCS+OiAbc54fV588KfdSlseSrad+YtLE5e7cdNQ1lYUMGXBrORVGAPbGSBEPL4LMGwIfoZn3LzkbZ/Pjq6P+4MJdoaLrd9XQWpNnl4MQr5c1Zugm+uPYT05JWICwv9fy5qdLuWqj3GFoGGZ9flwBeAlCObta3fFRm7n67xJif0MKIKCEmZ+pZVwT/tafz7Xvck4c91XRKl9vp0NQG5R9G39+80O46qG8Ed9MNToUFrjwAtwLQATTFu8+fz/Fc9LnRjpMTWhgRDbhABPqZ+j+MFmduWvvbNUs3l4mf1Y9JM0baVdtQUBe0Xh9xb/OldtdBfceRlkHK59drAfwdQC7inE8EALcvjrxT2WzxjBKiISbHA9et4bld+oVYmstxXeQKg71bDl1TRG4bka5dbncddGgYWgYxn1/fBuAZqPOJuvxdRU1Yd3wc+V9LVLIZEtEQc/Hw0tHTI1u67Br61HtG/oeBiWU2lJT0WqKyNmLIWTwIMXkxtAx+iwEsADAh3sU9TbL1vqWR5yKGDCe2LCIaSC4N4i7robjP0b913jymRQd3EfZBSJehPU3W7JH3NVfbXQsdOoaWQS62MPcFANuhtkJ3sa7Kqn1sdfQFw5JGQosjogF1Sm7zsAta53U5BbrZmZt2V0thrR01JSPdlOaWWuuyGQ+3bLC7Fjo8DC1JwOfXowAeARAGMCzefRbsNHe9uEl/jXPdREPLHzwv5TqsaJcWB/9N+87kLS2Z3E10EJaUcm2ledOJj7e8ZXctdPgYWpKEz683APgb1GnQ3nj3+d9mY8t72413E1oYEQ2oCZmm51ctj8TtiHul/F2Gbkk90TUlk7WV1pOn/bN1rt11UP9gaEkiPr9eCtXqfywAV7z7PLpaX7mywlia0MKIaED9YtjK4cP16tbOt5e5puX+J3AidxB2Y3ON+e7tiyNX2l0H9R+GliTj8+ufQq1xmYBu/v7u/Dj64dZak3O3RENElhuOW8P3xx1RudPz68k1YUddomsa7HY2WOsfWRUt9Pn1Lt2FKXkxtCSnd2Mfk6AOWOxAAvjjwsibe5qs0kQXRkQD46sjKobNDK3pcgq0qbkd14d/EeFytgP2Nlvl7+0wzv7HqiinzoYYhpYk1K7V/woAE+PdJ2rC+sOC8Ev7Wi2eq0E0BDg04A48GrfR5BLvrLGLm8aVJbikQamy2ap8c6vxxSvmhboEPEp+DC1JyufXTQD/ArANqvlcFw1hROcsiDxbF7S6bJkkouRzfG4w7eKmFxviXbvOcfPIoI4u615SSVWLte+lzfo5V74d4onYQxRDSxLz+fUIgIcB7EM3hyvWtMrwnAWRZ+tDsiahxRHRgLgp8+1MtxnqMu3R6MzLuLflgpT9f17dYtU/tU6/6Lp3w1vtroUGDkNLkvP59WYADwCIABge7z5VLTL0+wXhZxpCcl9CiyOifpefbrp+3fxQKN61p70/mFLSkr430TXZbV+r1fjY6uh3fr8gvMruWmhgMbQMAbHDFR+AOlgxK9599jbL4C0fhZ9tDEvuMiBKcj/J25g5JrKra3ARAldaN3hTqTt2XdBqenhl9P9uXRT5wO5aaOAxtAwRPr++C8BcADkAMuPdZ1dAtvzpo/AzgbCM26iKiJJDuhPardEH4m7l3e6eMfzFwMzyRNdkh4aQbHl4ZfTqdVXWy3bXQonB0DKExE6Fvh9ALroJLmWNsrloUfiZpoiMu5iPiJLD+Xk1GSe3LI57aOJtnusn1YW1If3mJBCWrY+sil63ptJ6LrajklIAQ8sQ4/PrW6FGXIYDyIh3nx0Nsum2RZFnmiOSWwKJkpQmgNtczzghrS4v2Lrmdd4Y+klwqPZuaQzLlkdWRW9cUWE+xcCSWhhahiCfXy+GWuMyAkB6vPuU1FuBokWRpwNc40KUtI7JCXsvDzwdd5vzwrTZ45c2jS5LcEkDbl+r1Xjv0siNy/eYjzGwpB4xVJM4AYUFrs8B+A3UluhgvPuMzRLpfz7H8/28dC0/ocURUb+oDWvRLxr/0ELOHGfnayOM6pYl3t840pxIs6O2/lbRZNXesyTyh/KA/Cfb86cmjrQMYT6/vgHqZOhRQPwnrb3NMnjD+5Fn9jZbKbFwj2ioyfNa7htaHgrHu1bnHJ35UNPsIdFccmeDVXXLRwwsqY4jLSmgsMB1EoBrAVQCiPvklu6C8+7Z3m9OydUKElocER22iAnzy023GrvTCrq2+ZeWXGj9vOqIjHDSjqZurTV337Yocnerjidi3cApRXGkJQX4/PoaqM65Y9DNGpegDuO374dfKt5nfpbQ4ojosHkccNxmPhz/cEChiauM612mJZPyxX59lVl6y8LInxhYCGBoSRk+v74KwIMA8tBNAzrDgpzzYeSNNXvNTxNaHBEdtnPy6jK/0PRO3LVrWz3H5r0aOCrppoCX7za2Fi2K3BQx8SwDCwGcHko5hQWuAgC/BRAC0G2vlus/7/7iWZOd5ySsMCI6bDtaPK1f1p5Il5pLdL7msYL6p45ftuZ6rGF21NZX7+8wPnt4ZfQPAOZzlxC14UhLivH5dT+AuwA4oLZEx/XA8ugnb2zVfaYlueCNKElMzYxk/LjpybhboCNauuvm4PeaE11TX5mWNJ9eH/3k4ZXR68DAQp1wpCVFFRa48gHcALXGpbq7+5031THp5ye6L/M6xZDYMkk01AWiWuSL4QcdTe6RXbZAA8BL0WvKT8uum5TounojpMvgg59GF326x7zD59c5TU1dcKQlRfn8eiXUiEsDgLHd3e/9HWZ50aLIk41hWZuw4ojokOW4Lc9N4b/Fbe8PANdoc4ZHjPi7CO1UH7Lq5iwIz/t0jzmHgYW6w9CSwnx+vQ7APQB2A5jQ3f2K91kNv3k3/M9dAWtHwoojokN2Wd6O7Omt6yPxrtU4x2Y93PylvYmuqSdljdau694Nv1XaIP8U6y9FFBenhwiFBa50AFcBOBbALgBx17E4NYhbZnkuOCHfcWoi6yOivvu0cVjDd7yP5Ma9KE25WP68elJ6ZEyCy+piVYW5+e4lkQWGhQd8fj3pdjhRYnGkheDz60GozrmLAEwG4Ip3P8OCvHVR5J35Jfp8S3KBLtFgdvqwxtwvN70Rf5pIOMQ1+rWanQvtLSnlG1v1FXd8HHnZsHAbAwv1BkdaaL/CApcAcC6A7wGoARB3FwIAfGW684ifHO/6lscpvImqj4j6piLkbpplPZZlOrxdtkADwIPhP5VeMmz7EYmuK2zI0JNross+KDXfAPAvn18PJboGSk4MLdRF7KDFq6Fa/td3d79jRmrDbzzT/e3hadrohBVHRH3yl+rT6x/NuXZ4vGtpZkvkU9f/hXPcMidR9dS0WpV3LI4sLw/I/wJ4g03jqC8YWiiuwgLXBADXQXXP7XbRXqYbzj/O8nz16JGO4xJWHBH1WsgQkTNb/+Ko94yPuwX6a6G3dv0994WJiahlzV5z/d1LIhujJp4EsIQ9WKivGFqoW4UFrmEAfgVgGtQC3W7/sfz8RNeJF013fsWhCUei6iOi3nmjbnL1dRl3dTsi+lr0V7tOzG4YsOCim1J/cZP+0cvFRimAv/r8+taB+l40tDG0UI8KC1weAD8AMAtqa3T8Q9kAnDHBkX/VKe5vZXtE/B0LRGQLS0J+tf66UHHGqXEPTM3X9zQtSv+dx+NA11OiD1NDSNb+ZWlkcfE+qxTAg7EeUUSHhLuHqEc+vx4B8BSAFwGMB5DZ3X2X7TYrr30n/HhJnbk5UfUR0cFpAuJez1Mt6GazUKVrfPbjgTMq+vv7bq01N1/1duj94n3WYgB3MLDQ4eJIC/VaYYHrWKh+LgI9tP4HgF+e5Dr5gmnO852aiDuPTkSJd82+i+veyvp23DPHhDSsJfJntePS9VGH+30MSxpvbzM+/tc6fTeAlwC85/PrbJNAh42hhfqksMCVBxVcpkBNF3X7RHTaOMfoq05xfyM3TYxMVH1E1L26qDPw+egjWVFnZtxR9hPDq6pfyXlglCZE3C3SvVEbtKoeWB79ZFONVQXgH7FDWon6BUML9VlhgcsN4FsAzgdQBSDY3X3TXXD+9vOec04aq51+OE+ERNQ//lF78p77Mq8f3+318B9KLxq2s8+9Wywp5ad7zKVzl0V36hY2A3jC59cbDqtYok4YWuiQxBrRnQzgFwAMqGZ03fryEY6JPznefUmWRwxLRH1EFF/EFNFZzXda1d7JcRtDppuB8ArXVdEst8zu7ddsisiGJ9ZE3/m43DQBvAngTZ9fN/qrZqI2DC10WAoLXGMAXAlgIg4yXZTjgft3Z3rOmznacVKi6iOirhYExu/6mefebrc4fyP0avnc3Fcn9eZrbaw219y9JLKuJQoTwKM+v/5ZvxVK1AlDCx222Lbob0JNF1Wjh/b/6v7Oad+d6SpMd4msRNRHRB1JCXyj/ur6tRlnxO2UCwBv6VfsnpnV1O3p70Fdtvx3oz7f5zfCALZDTQf1uECf6HAxtFC/iE0XHQc1XeSG6qLb7T+uURnCe+MZ7q8U5DlmJqhEImpnRzCjejYeGw0tfj/I8dGyxo8yfp/ucsDd5bH11pZ7lkSWVLdKF4BXoHYHcTqIBhxDC/WrwgJXDlQzulMBVALo8SC0y45xHn3JUa4L012i2/4vRDQwbq67aPeLGd/rdjTl5tCDpVfkrtq/KDeoy+ZXivV3Xyk2WqBGVR/3+fWyBJRKBIChhQZAbNTlNAA/hurp0mNDqRFpwnPtae5zjhujncIdRkSJE9AdLadH/uEJObNd8a5rlm4uEz+rH+3VR26otlbPXR5Z0RhGFoB3oA47DCe2Ykp1DC00YAoLXCOggsvnoKaLIj3d/8wJjvyfnuD66sgMbWwCyiMiAM80fK701rSbu93ifFJ4ReWZW+57Z1GZIQG0QI2ubElchUQHMLTQgCoscGlQ5xZ9D2prdI8L9TQB8cuTXCd/+QjnbLdD9Ps5KETUkW7BOKv59mCFZ1q3W5xHb3lh2eitLz0N4AWfX29JXHVEHTG0UELEtkb/DMCR6MWoy4RskXHtae7zuVCXaOAtbxq163L3Q91ugXZEmpYcM/+Hs3x+nS8YZCuGFkqYwgKXE8CXAFwWu6kSPewwAoALpjmnfHem66JhXhH3vBQi6h/fq//l3qXpZ3WYmhVmtFUzI7833Vl/L7vnIr5YkO0YWijhYmtdLoNarFsHoKmn+3udcPz8RPcpsyY5ZnmdIi0RNRKlkqAhQvfunPbxv8f96VyhOTRICWek8WXDm3tV2T0X1dpdH1EbhhayRWyH0dEAfgJgBNSUkd7TY/LShfeKk11fODHfcRpPjyY6fKYFa2FVxqprVo5ZtKvVFc454/LzXBnZM/TKbTdWvn7Pv+yuj6gzhhayVayb7vkAvg4gioMs1AWA6cO1nJ+f6DpnRp72Oe6QJjo0Gxs82363ZtT7i6sz6tpuE063QxrRbAAOANcGS1Z0eywHkR0YWmhQKCxw5QP4PoBjoQ5f7PEoAAA4fbxjzA+Pc507Plvr84m0RKmqoskqn7tai75QOX5FAJk72l0SAMYA0AC8GCxZscCeCom6x9BCg0Zse/RJUB11MwFUQY2+9OhrRzqnfuNo57nD07TRA1wiUdKqarF2v7bF+Ojd7UZZVDqOr5B5I3dg3IdQh5zmABgOYCWAl4IlK7iOhQYlhhYadAoLXOkAzgFQCPWurxKA2dNjNAFx+bGuY86b6pyVmyZGJqBMoqSwr9WqfNNvLPT5je1Q68eyAKxcYc1wNyP9+NjdqgE8C6A4WLKCLwo0aDG00KBVWODKBXARgNlQfV2qcZAt0gLAt45xHnXBNOesvHRtzMBXSTQ41Ydkzbxt+kevFBtbAWQAGAVgJ4DnAWz/0DoxF8CvASwFsChYsuKgo5pEdmNooUGvsMA1FsA3AZwIoBlqm/RBXTLDeeRFRzpnjcrQxg1kfUSDSWNY1r673Vj0wkZ9swTSAIwG0AjgBQCrfX69x1FLosGMoYWSQmyL9HQA3wEwFUAtVIA5qIumO48oLHDOys/SJg1giUS2qmy2yt/bYSx7fYuxTQJeqLDSAuA1AMt8fr3HLtREyYChhZJKbLHu8QC+CyAPatSlV+Hl3CMcky6e4frihBxt6gCWSJQwlpSytMHa8sZWY9nH5WYFAA9UWAlDhZUldp/ELIS4GMDrsU8/kFKeZ2c9lNwYWigpFRa4XFA7jb4BYCSABgCB3jz2pHxt5CVHuU49Kk87zuUQrgEsk2hA6KbUN9VY617YpC/fWms1AnBDbVeOAvABWOTz60Fbi4wRQrwO4OLYpxaASVLKPTaWREmMoYWSWuw8o+Og1rzkQ83dN/bmsXnpwnv5sa4TThvvOCXbI3IHsEyifhHUZcvKCnPlcxv0VTWtMgwVVkZD7a57C8BHg+kUZiHECKjdfzqAN6BGSOdIKe+xtTBKWgwtNCQUFrgcAGZCjbxMgDrPqL43j9UExMUznNO/fITzNDaqo8GostkqX7LLXPNKsV4cMmACSIcaYYwCeA/AAp9f79VIYyIJIa4B8DeoRcCPAVgMYKuU8ihbC6OkxdBCQ0pszcsxAC4BcATUQsQ6HGSrdJsTxmh5lx7lOu3okZw6InuFDRncWG195vPraz6rttp2zOUAyIUaTXwLwKc+v37Q7tF2EUKshprG/SqA+QDKAEwEcJqUcmWc+xcBuBXAM1Dnkl0F4OcAjoR6I/I+gD+0TS8JIaYD+CNUW4Q8ANsB/FVK+WQ39RwL9dxwHoBJOLBYeSOA5wD8W0ppdnrMjwH8uxc/brmUcnKnx2qxn+OHUG+q0qFGnj4AcK+UcnucGs8C8FHb1xNCnAlgDoDTobaubwPwJIB/yBR8AWdooSEptttoBoCvATgKgAHV58XozeNzvXBfPMN19GnjHcfnZ4pJPOOIEkFKiYpmWfpJubn29a361rAaVRFQL8gZAHYDeBPAZz6/3uMBo3YTQhwDYBPUm4Z8KaUuhLgHwE0AHpFS/irOY4pwILR4oU6Dj0JNL2XE7rYT6oT4qQDeATAMaj1bNtSfFQD8Tkp5X5yvXwvVYA9QU2otUEGwzXwAX5dSGu0ecxmAv/bwo2ZDbS3vEFqEEOlQC5DbFh7rAILtvl8YwHeklG92qvEsxEILgCIA/4RqstnUqda/Simv66GuIYmhhYa8wgLXOABnxT4cUE+ivX53WjBCG1ZY4DzuuDGO47j2hQZCUJctG6rN9a9vMdZuqbUaYjc7oBrCeaBGAt4G4Pf59aR40hZC3AvgRgCPSimvit02E8AGqKnbfClltNNjiqBCSwDq578CwMtQL/hfAPA/qAXHjwO4AOrP5ddSylIhRDaAv8QeEwYwXkpZ1+nrvwYVTN4HsFdKaQghMqBGX+6Lfe24gaebn3ECgNVQf0+PSSmvbHftMQD/B9UY89cAnpZSRoQQR8bqPwsqxJwgpdzW7nFnQYWWIAAngCcA/FlKWS2EGAbgdgDXQI0ez5RSbu5NrUMFQwuljMICVyaAU6G67A6HCi69njoCgNlTHBNnH+E87sgR2jFuh/AMTKWUCqKmjGyvt7Ys221ufqfEKNUttJ2onAE1GiABLAHwoc+v77at0EMghHBAjQrlA/iilHJJu2sboKZKvimlfLXT44qgQgsA/FhK+Uyn6z+AOm4AAEoAHN1pVEQD4AcwDcCPpJTPopeEEF8E8DGAMinllF7cPx3q7+cEqK7C57SFMCHEJAClUCMkV0gpH4/z2A1Qo0X/kVL+sN21s6BCCwD8U0r5izjfu+3P8FYp5e29/RmHAqfdBRAlSmxXxcLCAtdiAEdDvVM7GmrKqAbq3VyPFuw0dy3Yae7KdOOdrxe4Zpw+3vG58dniCIcmHANaPA0JuimjpQ2W/9M95ub5Jcb22KJaQI0q5EPtBqqFarW/xufXe7UTbhA6D+rnKYd6QW/veQD3APgRgFcR3x4A/4lz+4ftfn9f+8ACAFJKSwjxEVRoObYvBUspPxFCNAKYLIQYK6Xce5CH/AsqsOwGcGmnUaNLoQJLFdT0TufvFYyNRD0O4FIhxE86r6WJubub7/0mVGjp0884FDC0UMqJtTHfCGBj7IiAL8U+POjl6EtLFMbzG/VNz2/UNw1PE54Lpzmnn5ivzZg8TJvucgj3QP8MlDwMSxpljda2FXvMTW+XGCUt0Q7rqrKgFtZaUCcsLwKw3efXrThfKpn8KPbrC3EWi74A9WJ8oRBipJRyX5zHF0sp4/0Z1LT7/aZuvnd17Ne4U7lCiG8C+D7UsSAjodbOdDYWQLehRQgxB6o7dxBqDUxNp7ucGPv1k27CCAAsjP2aAaAAQHGn6/VSytJuHlsR+zXlpqsZWiil+fz6XgAvFBa4XocadTkbavcRoObdD9rzoj4kIyrAYFOaE47zpzmPOHWc46hpw7UCr1OkD1z1NFhFDBneFbB2rK20ts7bpm8LRND+XXjbWhU3DpyuvMbn13vV2XmwE0LkAPh67NP/dr4updwlhPgEwCyovi3xFrlWxvvaUkqz3aL4uPfBgRPhO+z+E0I4odbEXNLu5gjUyFbbY0ZCjZBkoBtCiIsA/Dn26U+llOvi3K3tpPmKONfatG+wF+9k+p7+PbR1OU65HY4MLUQAYq3O1wJYW1jgGg417Hsu1PZME8A+AAc9BTdkwHxjq1HyxlajxKlBnD3ZMfGMCc4ZR47QZmR5xLCB/BnIPlJK1IVkVUmdVbKiwiz5uNzcY1gdRus0qHUqaVD/npZBrZ8oTZaFtX1wGQ6MXmw4yM67H6HnnTn96RdQgSUItYX4tc6deYUQuwGMx4FdSOh0fQZUENMA3CmlfOkg37OndW9D7e89IRhaiDrx+fV6AAsKC1wLoXo5nA71rjAN6h1OHXqxddqwID8oNcs/KDXLAbx37Cht+BcmOqYeleeYOi5bTHFzGimpRU0Z2RWQOzZWmyULdxrbywOy86icBrXgOwMqqKyHCitbfH49lOByE+lHB7/LficIIWZKKTcOWDUHfCv26x1Syr91vhhbPJzX3YNjO3d8UFucfQBu6eF7tU159XRI64Q496eDYGgh6kbsHXAZgLLCAtdrUP1eToear3ZBBZda9GIEBgA21Vj1m2qsekBf5dKgzZrkGH9CvmPy1FxtyuhMMd6pCf5/HMQMS+o1rbJiZ4O1a22lWbqozNzdbsdPG4EDQUVCrbv4BCqoDNomcP1FCDENwBmxT4+HWojbnWeh+ij9CMANA1waoEZQACDedA4AnIn461vadiW9AHXSfDGA7x+ksdtaqHUzpwkh0qWU8c6BOif2ayvUjifqBT5JEvWCz69HAXwG4LPCApcbanfCSVAhxgu1kLIeQK/eQesWrLadSAA+TnfBOWuSc/xxo7Upk4Zp40dliHHcUm2vsCGDe5vlrtIGa9f6KnPXp3vMyqjZJaQA6nk0F2okDgC2QE39FA+VdSp90DbK8pmU8rOe7iiEeBkqtHxPCHFTDwtW+0vbMQczoY4+aF+LEwfWqcTzF6jdhvUACqWUB/t7fQ3A/VBTgr8E8FCn75cO1cMGUNNUA/2zDxkMLUR9FAswxQCKCwtc/wUwBerQxjOhFtRJqDbrvX7BCuow3t1ulL27HWWAert+3Bgt77jRjnFTh2vjxmWJccPTxGhurR4YUko0RVBX0WztLqmzdq3ea+5q1zo/ngyooCKgRtw2AlgFYOtgPAMoEYRavPKD2Kev9eIhb0G1Gf4h/ZkAAAY/SURBVBgD4Hyopm8D6QMAJwO4RQhRAmBebGHvDAAPQvVwakWnRbhCiO9AjQSZAL4tpdxxsG8kpSwXQjwB1ejuHiFEEMAznZrLTYNaX9NTWKJOGFqIDkNs+/R2ANtjO5DGQb2TOx1qES+gnpjroXYq9IoEsL7Kql1fZdVCjfAgzQnHKeMcY44dpY2bPEwbNzpDy8/2YIRDE1o//khDnm7KaH1I1lS3yqpdAat6W51Vta7SrOm0w6czB1RIaZv2qQYwD8BmAGWDvaV+gpyFA2s4uuu/sp+UslEIsRAqsPwIAx9a7gfwbaiGbm8A0IUQIag1KibUGUdF6Lpz6IK2kgE838PC4t1SylPaff7b2Pc6FyqkPCyEaIU6dgBQzwffbd8Nlw6OoYWon8R6a+yOfcwvLHDlQB3a+DmoqaRRUO/MQ1AjMX16oQsZMD8uNys+Ljf3b6N0adCOHqnlHjlCGzkhRxs5JlPk5aWLkcO8Is+ppfaBj5aUVksUjfUhWbu32ara2WBVb95nVW2usep7sW3DAfVilgX1YtXW22cVVCfW+iG46+dwtU0NbetDa/lXoULL12MLXQeMlLJeCHE6VBv8r0EdlhiC6pdyv5Ryaawjb3ecscd0J9z+k1gDuQsB/Bjqz+ZzUAcmluPAgYklh/bTpC628SdKgNgBjmMATIZaoHgs1BoIAfVk14RerofpDQFg+ggtZ0aeNnJSjpY3Il0My/GI7CwPsjPdIsfrRIY2BE6BjBgy3BKVjYEIGhtCsrGm1WqoaJb12+utupI6KxBnoWx33FCH0aVBhRQL6jTdz6AO6CuPTQsSkY0YWohsUFjg0qDanE+GOo16BtR2Swsqc7RCBZkBmXZwO6BNHqZlTcgWOWMytey8dJGdmyaysz3I8jiE1+uE1+0QXo8TXpcGTyLX0kRNGQkbaA3pMhjU0dqqy9bmiGxtjiLYGJatDSHZui8oW0sbrEBtUIYP/hW7EFBTAFlQu8Ak1NqCYqjRlF0A9vr8eq9OBCeixGFoIRokCgtcWVDtwydAdectwIF3/hIqyATRh7Ux/SXLDdeIdOEdnia8OR7hzfIIj9sBp0NAODShaQKaQ0DTBIRDQ7vPhRACImpKI2pCDxtSjxgwwgb0sCGNsAE9ZEgjqEMP6tKoC8pwu/N4+oMLQGbso729UNtMt0KFlH2c7iEa/BhaiAap2JTSCKjFvVOgFvVNgFpr0f4/bjD2EUbqdtl0QgW8tg8TqrlbCGp6ZxtU2/QqqIDChbNESYihhSjJFBa40qC2Vo+EWidzBNROpTyoF2sB9YJtQo3KtH1EkbyhRkD1w2n7cENNpUmoRbMhqLNoKgCUQoWTKgABjqAQDR0MLURDRKzpXR5UR9bs2O9HQ+1ayoNaaNo21SRw4HwVo4ePgTptWIMKG67Yhzv2a9uOxrY60a7OOqitxpWxj4bYbfUAggwnREMfQwtRiigscDmgFp9mQwWYbKi1Hm1bezPbfWRAbc904sCIxqES7X5t+70ONfrTDLX9uxEqhLSdrN22fqe17fexLeVElMIYWogortiaGifUdIwHanSkbepJ6+ZzDSrkGFDBJN6vBkdFiOhQMLQQERFRUmD7byIiIkoKDC1ERESUFBhaiIiIKCkwtBAREVFSYGghIiKipMDQQkREREmBoYWIiIiSAkMLERERJQWGFiIiIkoKDC1ERESUFBhaiIiIKCkwtBAREVFSYGghIiKipMDQQkREREmBoYWIiIiSAkMLERERJQWGFiIiIkoKDC1ERESUFBhaiIiIKCkwtBAREVFSYGghIiKipMDQQkREREmBoYWIiIiSAkMLERERJQWGFiIiIkoKDC1ERESUFBhaiIiIKCkwtBAREVFSYGghIiKipMDQQkREREmBoYWIiIiSAkMLERERJQWGFiIiIkoKDC1ERESUFBhaiIiIKCkwtBAREVFSYGghIiKipMDQQkREREmBoYWIiIiSAkMLERERJQWGFiIiIkoKDC1ERESUFBhaiIiIKCkwtBAREVFSYGghIiKipMDQQkREREmBoYWIiIiSAkMLERERJQWGFiIiIkoKDC1ERESUFBhaiIiIKCkwtBAREVFSYGghIiKipMDQQkREREmBoYWIiIiSwv8D90nND0Jmit4AAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 720x720 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Create the fig and axes\n",
    "fig, ax = plt.subplots(figsize=(10,10))\n",
    "\n",
    "# set title and font size\n",
    "ax.set_title(\"Distribution of Reviews Count\", fontsize=30)\n",
    "\n",
    "# plot the chart\n",
    "pie = (ax.pie(\n",
    "        data[\"reviews\"],\n",
    "        explode=(0.01, 0),\n",
    "        labels=data[\"pages\"],\n",
    "        autopct=\"%0.2f%%\",\n",
    "        shadow=True,\n",
    "        startangle=300,\n",
    "        textprops={'fontsize': 24}))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Recommended titles\n",
    "\n",
    "    - The union of our sets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>author</th>\n",
       "      <th>ratings</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Becoming</td>\n",
       "      <td>Michelle Obama</td>\n",
       "      <td>4.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Where The Crawdads Sing</td>\n",
       "      <td>Delia Owens</td>\n",
       "      <td>4.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Untamed</td>\n",
       "      <td>Glennon Doyle</td>\n",
       "      <td>4.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Circe</td>\n",
       "      <td>Madeline Miller</td>\n",
       "      <td>4.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Little Fires Everywhere</td>\n",
       "      <td>Celeste Ng</td>\n",
       "      <td>4.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>The Guest List</td>\n",
       "      <td>Lucy Foley</td>\n",
       "      <td>3.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>The Woman In The Window</td>\n",
       "      <td>A.J. Finn</td>\n",
       "      <td>3.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Normal People</td>\n",
       "      <td>Sally Rooney</td>\n",
       "      <td>3.87</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     title           author  ratings\n",
       "4                 Becoming   Michelle Obama     4.55\n",
       "0  Where The Crawdads Sing      Delia Owens     4.48\n",
       "3                  Untamed    Glennon Doyle     4.27\n",
       "5                    Circe  Madeline Miller     4.27\n",
       "2  Little Fires Everywhere       Celeste Ng     4.10\n",
       "7           The Guest List       Lucy Foley     3.98\n",
       "6  The Woman In The Window        A.J. Finn     3.94\n",
       "1            Normal People     Sally Rooney     3.87"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# \n",
    "top = pd.merge(goodreads_nytimes, amazon_goodreads, on=\"title\", how=\"left\")\n",
    "\n",
    "\n",
    "top = top[[\"title\", \"author_x_x\", \"ratings\"]].rename(columns={\"author_x_x\": \"author\"})\n",
    "top.sort_values(by=\"ratings\", ascending=False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.8.3 64-bit ('ironhack': conda)",
   "language": "python",
   "name": "python38364bitironhackcondae22397c42f6b4fd29a9381c81ac70f68"
  },
  "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.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}