01_Recommendation_System_for_TMDB_5000_Movie_Dataset.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true,
    "pycharm": {
     "name": "#%% md\n"
    }
   },
   "source": [
    "# Recommendation System using Python\n",
    "---\n",
    "\n",
    "A recommendation system (also commonly referred to as a recommendation/recommender engine/platform) seeks to predict a user’s interest in available items (songs on Spotify, for example) and give recommendations accordingly. There are two primary types of recommendation systems:\n",
    "\n",
    "- Content-based filtering systems make recommendations based on the characteristics of the items themselves. \n",
    "- Collaborative filtering systems make recommendations based on user interactions.\n",
    "\n",
    "Download the dataset from the url below and extract it in the /tmp/dataset/ folder.\n",
    "\n",
    "Dataset url: https://www.kaggle.com/tmdb/tmdb-movie-metadata\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-14T13:23:01.278721Z",
     "start_time": "2019-07-14T13:23:01.062812Z"
    },
    "pycharm": {
     "name": "#%%\n"
    }
   },
   "outputs": [],
   "source": [
    "# Import the packages\n",
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-14T13:23:01.586846Z",
     "start_time": "2019-07-14T13:23:01.279980Z"
    },
    "pycharm": {
     "name": "#%% \n"
    }
   },
   "outputs": [],
   "source": [
    "# Read the dataset\n",
    "credits = pd.read_csv('./tmp/dataset/tmdb_5000_credits.csv')\n",
    "movies_incomplete = pd.read_csv('./tmp/dataset/tmdb_5000_movies.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-14T13:23:01.596780Z",
     "start_time": "2019-07-14T13:23:01.590086Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "credits.shape:  (4803, 4)\n",
      "movies_incomplete.shape:  (4803, 20)\n"
     ]
    }
   ],
   "source": [
    "print(\"credits.shape: \",credits.shape)\n",
    "print(\"movies_incomplete.shape: \", movies_incomplete.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-14T13:23:01.624018Z",
     "start_time": "2019-07-14T13:23:01.599976Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "   movie_id   title                                               cast  \\\n",
      "0     19995  Avatar  [{\"cast_id\": 242, \"character\": \"Jake Sully\", \"...   \n",
      "\n",
      "                                                crew  \n",
      "0  [{\"credit_id\": \"52fe48009251416c750aca23\", \"de...  \n",
      "      budget                                             genres  \\\n",
      "0  237000000  [{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...   \n",
      "\n",
      "                      homepage     id  \\\n",
      "0  http://www.avatarmovie.com/  19995   \n",
      "\n",
      "                                            keywords original_language  \\\n",
      "0  [{\"id\": 1463, \"name\": \"culture clash\"}, {\"id\":...                en   \n",
      "\n",
      "  original_title                                           overview  \\\n",
      "0         Avatar  In the 22nd century, a paraplegic Marine is di...   \n",
      "\n",
      "   popularity                               production_companies  \\\n",
      "0  150.437577  [{\"name\": \"Ingenious Film Partners\", \"id\": 289...   \n",
      "\n",
      "                                production_countries release_date     revenue  \\\n",
      "0  [{\"iso_3166_1\": \"US\", \"name\": \"United States o...   2009-12-10  2787965087   \n",
      "\n",
      "   runtime                                   spoken_languages    status  \\\n",
      "0    162.0  [{\"iso_639_1\": \"en\", \"name\": \"English\"}, {\"iso...  Released   \n",
      "\n",
      "                       tagline   title  vote_average  vote_count  \n",
      "0  Enter the World of Pandora.  Avatar           7.2       11800  \n"
     ]
    }
   ],
   "source": [
    "print(credits.head(1))\n",
    "print(movies_incomplete.head(1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-14T13:23:01.681064Z",
     "start_time": "2019-07-14T13:23:01.626684Z"
    },
    "pycharm": {
     "name": "#%% \n"
    }
   },
   "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>budget</th>\n",
       "      <th>genres</th>\n",
       "      <th>homepage</th>\n",
       "      <th>id</th>\n",
       "      <th>keywords</th>\n",
       "      <th>original_language</th>\n",
       "      <th>original_title</th>\n",
       "      <th>overview</th>\n",
       "      <th>popularity</th>\n",
       "      <th>production_companies</th>\n",
       "      <th>...</th>\n",
       "      <th>runtime</th>\n",
       "      <th>spoken_languages</th>\n",
       "      <th>status</th>\n",
       "      <th>tagline</th>\n",
       "      <th>title_x</th>\n",
       "      <th>vote_average</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>title_y</th>\n",
       "      <th>cast</th>\n",
       "      <th>crew</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>237000000</td>\n",
       "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...</td>\n",
       "      <td>http://www.avatarmovie.com/</td>\n",
       "      <td>19995</td>\n",
       "      <td>[{\"id\": 1463, \"name\": \"culture clash\"}, {\"id\":...</td>\n",
       "      <td>en</td>\n",
       "      <td>Avatar</td>\n",
       "      <td>In the 22nd century, a paraplegic Marine is di...</td>\n",
       "      <td>150.437577</td>\n",
       "      <td>[{\"name\": \"Ingenious Film Partners\", \"id\": 289...</td>\n",
       "      <td>...</td>\n",
       "      <td>162.0</td>\n",
       "      <td>[{\"iso_639_1\": \"en\", \"name\": \"English\"}, {\"iso...</td>\n",
       "      <td>Released</td>\n",
       "      <td>Enter the World of Pandora.</td>\n",
       "      <td>Avatar</td>\n",
       "      <td>7.2</td>\n",
       "      <td>11800</td>\n",
       "      <td>Avatar</td>\n",
       "      <td>[{\"cast_id\": 242, \"character\": \"Jake Sully\", \"...</td>\n",
       "      <td>[{\"credit_id\": \"52fe48009251416c750aca23\", \"de...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>300000000</td>\n",
       "      <td>[{\"id\": 12, \"name\": \"Adventure\"}, {\"id\": 14, \"...</td>\n",
       "      <td>http://disney.go.com/disneypictures/pirates/</td>\n",
       "      <td>285</td>\n",
       "      <td>[{\"id\": 270, \"name\": \"ocean\"}, {\"id\": 726, \"na...</td>\n",
       "      <td>en</td>\n",
       "      <td>Pirates of the Caribbean: At World's End</td>\n",
       "      <td>Captain Barbossa, long believed to be dead, ha...</td>\n",
       "      <td>139.082615</td>\n",
       "      <td>[{\"name\": \"Walt Disney Pictures\", \"id\": 2}, {\"...</td>\n",
       "      <td>...</td>\n",
       "      <td>169.0</td>\n",
       "      <td>[{\"iso_639_1\": \"en\", \"name\": \"English\"}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>At the end of the world, the adventure begins.</td>\n",
       "      <td>Pirates of the Caribbean: At World's End</td>\n",
       "      <td>6.9</td>\n",
       "      <td>4500</td>\n",
       "      <td>Pirates of the Caribbean: At World's End</td>\n",
       "      <td>[{\"cast_id\": 4, \"character\": \"Captain Jack Spa...</td>\n",
       "      <td>[{\"credit_id\": \"52fe4232c3a36847f800b579\", \"de...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>245000000</td>\n",
       "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...</td>\n",
       "      <td>http://www.sonypictures.com/movies/spectre/</td>\n",
       "      <td>206647</td>\n",
       "      <td>[{\"id\": 470, \"name\": \"spy\"}, {\"id\": 818, \"name...</td>\n",
       "      <td>en</td>\n",
       "      <td>Spectre</td>\n",
       "      <td>A cryptic message from Bond’s past sends him o...</td>\n",
       "      <td>107.376788</td>\n",
       "      <td>[{\"name\": \"Columbia Pictures\", \"id\": 5}, {\"nam...</td>\n",
       "      <td>...</td>\n",
       "      <td>148.0</td>\n",
       "      <td>[{\"iso_639_1\": \"fr\", \"name\": \"Fran\\u00e7ais\"},...</td>\n",
       "      <td>Released</td>\n",
       "      <td>A Plan No One Escapes</td>\n",
       "      <td>Spectre</td>\n",
       "      <td>6.3</td>\n",
       "      <td>4466</td>\n",
       "      <td>Spectre</td>\n",
       "      <td>[{\"cast_id\": 1, \"character\": \"James Bond\", \"cr...</td>\n",
       "      <td>[{\"credit_id\": \"54805967c3a36829b5002c41\", \"de...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>250000000</td>\n",
       "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 80, \"nam...</td>\n",
       "      <td>http://www.thedarkknightrises.com/</td>\n",
       "      <td>49026</td>\n",
       "      <td>[{\"id\": 849, \"name\": \"dc comics\"}, {\"id\": 853,...</td>\n",
       "      <td>en</td>\n",
       "      <td>The Dark Knight Rises</td>\n",
       "      <td>Following the death of District Attorney Harve...</td>\n",
       "      <td>112.312950</td>\n",
       "      <td>[{\"name\": \"Legendary Pictures\", \"id\": 923}, {\"...</td>\n",
       "      <td>...</td>\n",
       "      <td>165.0</td>\n",
       "      <td>[{\"iso_639_1\": \"en\", \"name\": \"English\"}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>The Legend Ends</td>\n",
       "      <td>The Dark Knight Rises</td>\n",
       "      <td>7.6</td>\n",
       "      <td>9106</td>\n",
       "      <td>The Dark Knight Rises</td>\n",
       "      <td>[{\"cast_id\": 2, \"character\": \"Bruce Wayne / Ba...</td>\n",
       "      <td>[{\"credit_id\": \"52fe4781c3a36847f81398c3\", \"de...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>260000000</td>\n",
       "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...</td>\n",
       "      <td>http://movies.disney.com/john-carter</td>\n",
       "      <td>49529</td>\n",
       "      <td>[{\"id\": 818, \"name\": \"based on novel\"}, {\"id\":...</td>\n",
       "      <td>en</td>\n",
       "      <td>John Carter</td>\n",
       "      <td>John Carter is a war-weary, former military ca...</td>\n",
       "      <td>43.926995</td>\n",
       "      <td>[{\"name\": \"Walt Disney Pictures\", \"id\": 2}]</td>\n",
       "      <td>...</td>\n",
       "      <td>132.0</td>\n",
       "      <td>[{\"iso_639_1\": \"en\", \"name\": \"English\"}]</td>\n",
       "      <td>Released</td>\n",
       "      <td>Lost in our world, found in another.</td>\n",
       "      <td>John Carter</td>\n",
       "      <td>6.1</td>\n",
       "      <td>2124</td>\n",
       "      <td>John Carter</td>\n",
       "      <td>[{\"cast_id\": 5, \"character\": \"John Carter\", \"c...</td>\n",
       "      <td>[{\"credit_id\": \"52fe479ac3a36847f813eaa3\", \"de...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      budget                                             genres  \\\n",
       "0  237000000  [{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...   \n",
       "1  300000000  [{\"id\": 12, \"name\": \"Adventure\"}, {\"id\": 14, \"...   \n",
       "2  245000000  [{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...   \n",
       "3  250000000  [{\"id\": 28, \"name\": \"Action\"}, {\"id\": 80, \"nam...   \n",
       "4  260000000  [{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...   \n",
       "\n",
       "                                       homepage      id  \\\n",
       "0                   http://www.avatarmovie.com/   19995   \n",
       "1  http://disney.go.com/disneypictures/pirates/     285   \n",
       "2   http://www.sonypictures.com/movies/spectre/  206647   \n",
       "3            http://www.thedarkknightrises.com/   49026   \n",
       "4          http://movies.disney.com/john-carter   49529   \n",
       "\n",
       "                                            keywords original_language  \\\n",
       "0  [{\"id\": 1463, \"name\": \"culture clash\"}, {\"id\":...                en   \n",
       "1  [{\"id\": 270, \"name\": \"ocean\"}, {\"id\": 726, \"na...                en   \n",
       "2  [{\"id\": 470, \"name\": \"spy\"}, {\"id\": 818, \"name...                en   \n",
       "3  [{\"id\": 849, \"name\": \"dc comics\"}, {\"id\": 853,...                en   \n",
       "4  [{\"id\": 818, \"name\": \"based on novel\"}, {\"id\":...                en   \n",
       "\n",
       "                             original_title  \\\n",
       "0                                    Avatar   \n",
       "1  Pirates of the Caribbean: At World's End   \n",
       "2                                   Spectre   \n",
       "3                     The Dark Knight Rises   \n",
       "4                               John Carter   \n",
       "\n",
       "                                            overview  popularity  \\\n",
       "0  In the 22nd century, a paraplegic Marine is di...  150.437577   \n",
       "1  Captain Barbossa, long believed to be dead, ha...  139.082615   \n",
       "2  A cryptic message from Bond’s past sends him o...  107.376788   \n",
       "3  Following the death of District Attorney Harve...  112.312950   \n",
       "4  John Carter is a war-weary, former military ca...   43.926995   \n",
       "\n",
       "                                production_companies  ... runtime  \\\n",
       "0  [{\"name\": \"Ingenious Film Partners\", \"id\": 289...  ...   162.0   \n",
       "1  [{\"name\": \"Walt Disney Pictures\", \"id\": 2}, {\"...  ...   169.0   \n",
       "2  [{\"name\": \"Columbia Pictures\", \"id\": 5}, {\"nam...  ...   148.0   \n",
       "3  [{\"name\": \"Legendary Pictures\", \"id\": 923}, {\"...  ...   165.0   \n",
       "4        [{\"name\": \"Walt Disney Pictures\", \"id\": 2}]  ...   132.0   \n",
       "\n",
       "                                    spoken_languages    status  \\\n",
       "0  [{\"iso_639_1\": \"en\", \"name\": \"English\"}, {\"iso...  Released   \n",
       "1           [{\"iso_639_1\": \"en\", \"name\": \"English\"}]  Released   \n",
       "2  [{\"iso_639_1\": \"fr\", \"name\": \"Fran\\u00e7ais\"},...  Released   \n",
       "3           [{\"iso_639_1\": \"en\", \"name\": \"English\"}]  Released   \n",
       "4           [{\"iso_639_1\": \"en\", \"name\": \"English\"}]  Released   \n",
       "\n",
       "                                          tagline  \\\n",
       "0                     Enter the World of Pandora.   \n",
       "1  At the end of the world, the adventure begins.   \n",
       "2                           A Plan No One Escapes   \n",
       "3                                 The Legend Ends   \n",
       "4            Lost in our world, found in another.   \n",
       "\n",
       "                                    title_x vote_average vote_count  \\\n",
       "0                                    Avatar          7.2      11800   \n",
       "1  Pirates of the Caribbean: At World's End          6.9       4500   \n",
       "2                                   Spectre          6.3       4466   \n",
       "3                     The Dark Knight Rises          7.6       9106   \n",
       "4                               John Carter          6.1       2124   \n",
       "\n",
       "                                    title_y  \\\n",
       "0                                    Avatar   \n",
       "1  Pirates of the Caribbean: At World's End   \n",
       "2                                   Spectre   \n",
       "3                     The Dark Knight Rises   \n",
       "4                               John Carter   \n",
       "\n",
       "                                                cast  \\\n",
       "0  [{\"cast_id\": 242, \"character\": \"Jake Sully\", \"...   \n",
       "1  [{\"cast_id\": 4, \"character\": \"Captain Jack Spa...   \n",
       "2  [{\"cast_id\": 1, \"character\": \"James Bond\", \"cr...   \n",
       "3  [{\"cast_id\": 2, \"character\": \"Bruce Wayne / Ba...   \n",
       "4  [{\"cast_id\": 5, \"character\": \"John Carter\", \"c...   \n",
       "\n",
       "                                                crew  \n",
       "0  [{\"credit_id\": \"52fe48009251416c750aca23\", \"de...  \n",
       "1  [{\"credit_id\": \"52fe4232c3a36847f800b579\", \"de...  \n",
       "2  [{\"credit_id\": \"54805967c3a36829b5002c41\", \"de...  \n",
       "3  [{\"credit_id\": \"52fe4781c3a36847f81398c3\", \"de...  \n",
       "4  [{\"credit_id\": \"52fe479ac3a36847f813eaa3\", \"de...  \n",
       "\n",
       "[5 rows x 23 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "credits_renamed = credits.rename(index=str, columns={\"movie_id\":\"id\"})\n",
    "movies_dirty = movies_incomplete.merge(credits_renamed,on='id')\n",
    "movies_dirty.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-14T13:23:01.721987Z",
     "start_time": "2019-07-14T13:23:01.686175Z"
    }
   },
   "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>budget</th>\n",
       "      <th>genres</th>\n",
       "      <th>id</th>\n",
       "      <th>keywords</th>\n",
       "      <th>original_language</th>\n",
       "      <th>original_title</th>\n",
       "      <th>overview</th>\n",
       "      <th>popularity</th>\n",
       "      <th>production_companies</th>\n",
       "      <th>release_date</th>\n",
       "      <th>revenue</th>\n",
       "      <th>runtime</th>\n",
       "      <th>spoken_languages</th>\n",
       "      <th>tagline</th>\n",
       "      <th>vote_average</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>cast</th>\n",
       "      <th>crew</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>237000000</td>\n",
       "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...</td>\n",
       "      <td>19995</td>\n",
       "      <td>[{\"id\": 1463, \"name\": \"culture clash\"}, {\"id\":...</td>\n",
       "      <td>en</td>\n",
       "      <td>Avatar</td>\n",
       "      <td>In the 22nd century, a paraplegic Marine is di...</td>\n",
       "      <td>150.437577</td>\n",
       "      <td>[{\"name\": \"Ingenious Film Partners\", \"id\": 289...</td>\n",
       "      <td>2009-12-10</td>\n",
       "      <td>2787965087</td>\n",
       "      <td>162.0</td>\n",
       "      <td>[{\"iso_639_1\": \"en\", \"name\": \"English\"}, {\"iso...</td>\n",
       "      <td>Enter the World of Pandora.</td>\n",
       "      <td>7.2</td>\n",
       "      <td>11800</td>\n",
       "      <td>[{\"cast_id\": 242, \"character\": \"Jake Sully\", \"...</td>\n",
       "      <td>[{\"credit_id\": \"52fe48009251416c750aca23\", \"de...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>300000000</td>\n",
       "      <td>[{\"id\": 12, \"name\": \"Adventure\"}, {\"id\": 14, \"...</td>\n",
       "      <td>285</td>\n",
       "      <td>[{\"id\": 270, \"name\": \"ocean\"}, {\"id\": 726, \"na...</td>\n",
       "      <td>en</td>\n",
       "      <td>Pirates of the Caribbean: At World's End</td>\n",
       "      <td>Captain Barbossa, long believed to be dead, ha...</td>\n",
       "      <td>139.082615</td>\n",
       "      <td>[{\"name\": \"Walt Disney Pictures\", \"id\": 2}, {\"...</td>\n",
       "      <td>2007-05-19</td>\n",
       "      <td>961000000</td>\n",
       "      <td>169.0</td>\n",
       "      <td>[{\"iso_639_1\": \"en\", \"name\": \"English\"}]</td>\n",
       "      <td>At the end of the world, the adventure begins.</td>\n",
       "      <td>6.9</td>\n",
       "      <td>4500</td>\n",
       "      <td>[{\"cast_id\": 4, \"character\": \"Captain Jack Spa...</td>\n",
       "      <td>[{\"credit_id\": \"52fe4232c3a36847f800b579\", \"de...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>245000000</td>\n",
       "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...</td>\n",
       "      <td>206647</td>\n",
       "      <td>[{\"id\": 470, \"name\": \"spy\"}, {\"id\": 818, \"name...</td>\n",
       "      <td>en</td>\n",
       "      <td>Spectre</td>\n",
       "      <td>A cryptic message from Bond’s past sends him o...</td>\n",
       "      <td>107.376788</td>\n",
       "      <td>[{\"name\": \"Columbia Pictures\", \"id\": 5}, {\"nam...</td>\n",
       "      <td>2015-10-26</td>\n",
       "      <td>880674609</td>\n",
       "      <td>148.0</td>\n",
       "      <td>[{\"iso_639_1\": \"fr\", \"name\": \"Fran\\u00e7ais\"},...</td>\n",
       "      <td>A Plan No One Escapes</td>\n",
       "      <td>6.3</td>\n",
       "      <td>4466</td>\n",
       "      <td>[{\"cast_id\": 1, \"character\": \"James Bond\", \"cr...</td>\n",
       "      <td>[{\"credit_id\": \"54805967c3a36829b5002c41\", \"de...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>250000000</td>\n",
       "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 80, \"nam...</td>\n",
       "      <td>49026</td>\n",
       "      <td>[{\"id\": 849, \"name\": \"dc comics\"}, {\"id\": 853,...</td>\n",
       "      <td>en</td>\n",
       "      <td>The Dark Knight Rises</td>\n",
       "      <td>Following the death of District Attorney Harve...</td>\n",
       "      <td>112.312950</td>\n",
       "      <td>[{\"name\": \"Legendary Pictures\", \"id\": 923}, {\"...</td>\n",
       "      <td>2012-07-16</td>\n",
       "      <td>1084939099</td>\n",
       "      <td>165.0</td>\n",
       "      <td>[{\"iso_639_1\": \"en\", \"name\": \"English\"}]</td>\n",
       "      <td>The Legend Ends</td>\n",
       "      <td>7.6</td>\n",
       "      <td>9106</td>\n",
       "      <td>[{\"cast_id\": 2, \"character\": \"Bruce Wayne / Ba...</td>\n",
       "      <td>[{\"credit_id\": \"52fe4781c3a36847f81398c3\", \"de...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>260000000</td>\n",
       "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...</td>\n",
       "      <td>49529</td>\n",
       "      <td>[{\"id\": 818, \"name\": \"based on novel\"}, {\"id\":...</td>\n",
       "      <td>en</td>\n",
       "      <td>John Carter</td>\n",
       "      <td>John Carter is a war-weary, former military ca...</td>\n",
       "      <td>43.926995</td>\n",
       "      <td>[{\"name\": \"Walt Disney Pictures\", \"id\": 2}]</td>\n",
       "      <td>2012-03-07</td>\n",
       "      <td>284139100</td>\n",
       "      <td>132.0</td>\n",
       "      <td>[{\"iso_639_1\": \"en\", \"name\": \"English\"}]</td>\n",
       "      <td>Lost in our world, found in another.</td>\n",
       "      <td>6.1</td>\n",
       "      <td>2124</td>\n",
       "      <td>[{\"cast_id\": 5, \"character\": \"John Carter\", \"c...</td>\n",
       "      <td>[{\"credit_id\": \"52fe479ac3a36847f813eaa3\", \"de...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      budget                                             genres      id  \\\n",
       "0  237000000  [{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...   19995   \n",
       "1  300000000  [{\"id\": 12, \"name\": \"Adventure\"}, {\"id\": 14, \"...     285   \n",
       "2  245000000  [{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...  206647   \n",
       "3  250000000  [{\"id\": 28, \"name\": \"Action\"}, {\"id\": 80, \"nam...   49026   \n",
       "4  260000000  [{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...   49529   \n",
       "\n",
       "                                            keywords original_language  \\\n",
       "0  [{\"id\": 1463, \"name\": \"culture clash\"}, {\"id\":...                en   \n",
       "1  [{\"id\": 270, \"name\": \"ocean\"}, {\"id\": 726, \"na...                en   \n",
       "2  [{\"id\": 470, \"name\": \"spy\"}, {\"id\": 818, \"name...                en   \n",
       "3  [{\"id\": 849, \"name\": \"dc comics\"}, {\"id\": 853,...                en   \n",
       "4  [{\"id\": 818, \"name\": \"based on novel\"}, {\"id\":...                en   \n",
       "\n",
       "                             original_title  \\\n",
       "0                                    Avatar   \n",
       "1  Pirates of the Caribbean: At World's End   \n",
       "2                                   Spectre   \n",
       "3                     The Dark Knight Rises   \n",
       "4                               John Carter   \n",
       "\n",
       "                                            overview  popularity  \\\n",
       "0  In the 22nd century, a paraplegic Marine is di...  150.437577   \n",
       "1  Captain Barbossa, long believed to be dead, ha...  139.082615   \n",
       "2  A cryptic message from Bond’s past sends him o...  107.376788   \n",
       "3  Following the death of District Attorney Harve...  112.312950   \n",
       "4  John Carter is a war-weary, former military ca...   43.926995   \n",
       "\n",
       "                                production_companies release_date     revenue  \\\n",
       "0  [{\"name\": \"Ingenious Film Partners\", \"id\": 289...   2009-12-10  2787965087   \n",
       "1  [{\"name\": \"Walt Disney Pictures\", \"id\": 2}, {\"...   2007-05-19   961000000   \n",
       "2  [{\"name\": \"Columbia Pictures\", \"id\": 5}, {\"nam...   2015-10-26   880674609   \n",
       "3  [{\"name\": \"Legendary Pictures\", \"id\": 923}, {\"...   2012-07-16  1084939099   \n",
       "4        [{\"name\": \"Walt Disney Pictures\", \"id\": 2}]   2012-03-07   284139100   \n",
       "\n",
       "   runtime                                   spoken_languages  \\\n",
       "0    162.0  [{\"iso_639_1\": \"en\", \"name\": \"English\"}, {\"iso...   \n",
       "1    169.0           [{\"iso_639_1\": \"en\", \"name\": \"English\"}]   \n",
       "2    148.0  [{\"iso_639_1\": \"fr\", \"name\": \"Fran\\u00e7ais\"},...   \n",
       "3    165.0           [{\"iso_639_1\": \"en\", \"name\": \"English\"}]   \n",
       "4    132.0           [{\"iso_639_1\": \"en\", \"name\": \"English\"}]   \n",
       "\n",
       "                                          tagline  vote_average  vote_count  \\\n",
       "0                     Enter the World of Pandora.           7.2       11800   \n",
       "1  At the end of the world, the adventure begins.           6.9        4500   \n",
       "2                           A Plan No One Escapes           6.3        4466   \n",
       "3                                 The Legend Ends           7.6        9106   \n",
       "4            Lost in our world, found in another.           6.1        2124   \n",
       "\n",
       "                                                cast  \\\n",
       "0  [{\"cast_id\": 242, \"character\": \"Jake Sully\", \"...   \n",
       "1  [{\"cast_id\": 4, \"character\": \"Captain Jack Spa...   \n",
       "2  [{\"cast_id\": 1, \"character\": \"James Bond\", \"cr...   \n",
       "3  [{\"cast_id\": 2, \"character\": \"Bruce Wayne / Ba...   \n",
       "4  [{\"cast_id\": 5, \"character\": \"John Carter\", \"c...   \n",
       "\n",
       "                                                crew  \n",
       "0  [{\"credit_id\": \"52fe48009251416c750aca23\", \"de...  \n",
       "1  [{\"credit_id\": \"52fe4232c3a36847f800b579\", \"de...  \n",
       "2  [{\"credit_id\": \"54805967c3a36829b5002c41\", \"de...  \n",
       "3  [{\"credit_id\": \"52fe4781c3a36847f81398c3\", \"de...  \n",
       "4  [{\"credit_id\": \"52fe479ac3a36847f813eaa3\", \"de...  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_clean = movies_dirty.drop(columns=['homepage', 'title_x', 'title_y', 'status', 'production_countries'])\n",
    "movies_clean.head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Two Basic Recommendation System\n",
    "\n",
    "1. a list of the highest rated movies.\n",
    "2. a list of the most popular movies.\n",
    "\n",
    "We need to find the weighted average for each movie's average rating and use the formula IMDB used to it.\n",
    "\n",
    "![IMDB Rating](http://trailerpark.weebly.com/uploads/8/8/5/5/8855465/7628808.png?371)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-14T13:23:01.729153Z",
     "start_time": "2019-07-14T13:23:01.723369Z"
    }
   },
   "outputs": [],
   "source": [
    "V = movies_clean['vote_count']\n",
    "R = movies_clean['vote_average']\n",
    "C = movies_clean['vote_average'].mean()\n",
    "m = movies_clean['vote_count'].quantile(0.70)\n",
    "\n",
    "movies_clean['weighted_average'] = V / (V + m) * R + (m / (V + m) * C)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### MK1\n",
    "\n",
    "Let's recommend ten movies with highest weighted average ratings."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-14T13:23:01.743296Z",
     "start_time": "2019-07-14T13:23:01.730292Z"
    }
   },
   "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>original_title</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>vote_average</th>\n",
       "      <th>weighted_average</th>\n",
       "      <th>popularity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1881</th>\n",
       "      <td>The Shawshank Redemption</td>\n",
       "      <td>8205</td>\n",
       "      <td>8.5</td>\n",
       "      <td>8.340775</td>\n",
       "      <td>136.747729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3337</th>\n",
       "      <td>The Godfather</td>\n",
       "      <td>5893</td>\n",
       "      <td>8.4</td>\n",
       "      <td>8.192887</td>\n",
       "      <td>143.659698</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>662</th>\n",
       "      <td>Fight Club</td>\n",
       "      <td>9413</td>\n",
       "      <td>8.3</td>\n",
       "      <td>8.171648</td>\n",
       "      <td>146.757391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3232</th>\n",
       "      <td>Pulp Fiction</td>\n",
       "      <td>8428</td>\n",
       "      <td>8.3</td>\n",
       "      <td>8.157615</td>\n",
       "      <td>121.463076</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>The Dark Knight</td>\n",
       "      <td>12002</td>\n",
       "      <td>8.2</td>\n",
       "      <td>8.102674</td>\n",
       "      <td>187.322927</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>809</th>\n",
       "      <td>Forrest Gump</td>\n",
       "      <td>7927</td>\n",
       "      <td>8.2</td>\n",
       "      <td>8.056059</td>\n",
       "      <td>138.133331</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1818</th>\n",
       "      <td>Schindler's List</td>\n",
       "      <td>4329</td>\n",
       "      <td>8.3</td>\n",
       "      <td>8.038748</td>\n",
       "      <td>104.469351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3865</th>\n",
       "      <td>Whiplash</td>\n",
       "      <td>4254</td>\n",
       "      <td>8.3</td>\n",
       "      <td>8.034695</td>\n",
       "      <td>192.528841</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>Inception</td>\n",
       "      <td>13752</td>\n",
       "      <td>8.1</td>\n",
       "      <td>8.018611</td>\n",
       "      <td>167.583710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1990</th>\n",
       "      <td>The Empire Strikes Back</td>\n",
       "      <td>5879</td>\n",
       "      <td>8.2</td>\n",
       "      <td>8.010426</td>\n",
       "      <td>78.517830</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                original_title  vote_count  vote_average  weighted_average  \\\n",
       "1881  The Shawshank Redemption        8205           8.5          8.340775   \n",
       "3337             The Godfather        5893           8.4          8.192887   \n",
       "662                 Fight Club        9413           8.3          8.171648   \n",
       "3232              Pulp Fiction        8428           8.3          8.157615   \n",
       "65             The Dark Knight       12002           8.2          8.102674   \n",
       "809               Forrest Gump        7927           8.2          8.056059   \n",
       "1818          Schindler's List        4329           8.3          8.038748   \n",
       "3865                  Whiplash        4254           8.3          8.034695   \n",
       "96                   Inception       13752           8.1          8.018611   \n",
       "1990   The Empire Strikes Back        5879           8.2          8.010426   \n",
       "\n",
       "      popularity  \n",
       "1881  136.747729  \n",
       "3337  143.659698  \n",
       "662   146.757391  \n",
       "3232  121.463076  \n",
       "65    187.322927  \n",
       "809   138.133331  \n",
       "1818  104.469351  \n",
       "3865  192.528841  \n",
       "96    167.583710  \n",
       "1990   78.517830  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_ranked = movies_clean.sort_values('weighted_average', ascending=False)\n",
    "movies_ranked[['original_title', 'vote_count', 'vote_average','weighted_average', 'popularity']].head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-14T13:23:02.269855Z",
     "start_time": "2019-07-14T13:23:01.744350Z"
    }
   },
   "outputs": [],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "\n",
    "wavg = movies_ranked.sort_values('weighted_average', ascending=False)\n",
    "\n",
    "plt.figure(figsize=(16,6))\n",
    "\n",
    "ax = sns.barplot(x=wavg['weighted_average'].head(10), y=wavg['original_title'].head(10), data=wavg, palette='deep')\n",
    "\n",
    "plt.xlim(6.75, 8.35)\n",
    "plt.title('\"Best\" Movies by TMDB Votes', weight='bold')\n",
    "plt.xlabel('Weighted Average Score', weight='bold')\n",
    "plt.ylabel('Movie Title', weight='bold')\n",
    "\n",
    "plt.savefig('./tmp/best_movies.png')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### MK2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-14T13:23:02.581657Z",
     "start_time": "2019-07-14T13:23:02.271213Z"
    }
   },
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAABKwAAAGDCAYAAAAGZYgNAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjAsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+17YcXAAAgAElEQVR4nOzdebRkVXn38e+PQZlBARERbTWIIkMDLSqIAZUYMYooikqMjQqOIDiE1xk1OKDGgKhIkBkEESQ4BDFIy4x2Q9PNGCJgnGdRBhXhef84u0JxrTv0cPtW9/1+1up1T+2zz97POVVXuc969q5UFZIkSZIkSdKwWGmqA5AkSZIkSZL6mbCSJEmSJEnSUDFhJUmSJEmSpKFiwkqSJEmSJElDxYSVJEmSJEmShooJK0mSJEmSJA0VE1aSJElabiWZnaSSzJnqWCZLkhPaPR46CWPPaGPX0h5bkqQlYcJKkiRpSCS5LcmhSXZpSYQZrb2XsKgk7+nrv2aS2/vOzVgKMfTmvm2cfof2zVtJ7k5yXZIDljSGqdLuY3YvCTZGv2X2fjTnA0cAVyyl8SZNXwJxtH9zWr/e63uTPKrv+n8c2XdA/z8kuTnJ8UmeMGL+/rnuSfLjJCcl2WCUeE9qfU8Y0f7wJH9p57aawH1P6PdGkjRxJqwkSZKWL/sl6f033CuAdaYyGOAWumTK14EnAkcm2W9qQ1o0SVZdgssn/f2oqtOq6qCqOm9pjz0Jrqf7PBwBXNTaftzX9uUR/VcC9u97/YZxxj8dOAd4MDAbmJfk6QP6nQZ8vh2/Ejh8lPFOaT/3TLJaX/vewMrAgqpaOE5MkqRJYMJKkiRp+fFb4FHA89rrN7S2B2iVPh9P8v0kdySZn+SVfee3S3Jxkt+389cmeUOSXYALW7dHT3Cp2MKWTNmLLmkFsPsE4+hVaZ2Z5LQkdya5Psmz+vo8oFqp75oTBgWTZOMkFyX5Vauw+WWSU5Ks187P6Bvz9Ul+QlfBtDiW+P1I8tgk9yX5dS9xlqT37H+d5EEZsCQwyauTXNPGuznJu5Ks0neP5yX5bbrKt5uSfGC8m2nVTT9qz+zwJCsn2bRVNd3eS+i0Z3xff1tPVX23fR4OAr7Smv+n11ZVRw14hq9JsmqSrYEdBz3DPh+vqlcCT6BLiK0BHDtKvzcDH22vnzCgD8AFwE/pEo2797W/ov08ud3zqknemeTG9jm9IcnBSVYa6/cmyRpJPprkf9p1VyV5YW+SJLslmdfO3d7Ov2iM+5ekacOElSRJ0pCoqhlVdWhVzamqVNVtI7qcDfwBeEOSpwDbAicMGOp44O3AvcCXgM2Ak5K8vJ0/Eng6XaLmi3QJgu2BHwFntT5/4P6qmHEl2QTYvL381QTj6HkxsD5wCV2V1rlJNprIvAOsDawOfBX4d7p724f7Exf9DgP+E7gMoD3zE9q/TGCuJX4/quoW4FLgocCzW/+Xtp9nVNWfRw6W5HXAF4CHtPHubvfy7tblX4DnAN8DTgJ+CDxlAvfzAbrPxOrAO4A3VtUPW9s6wAtav+cDAb5SVX+cwLhjORF4OLAnXcLvvhbzmKrqLuAj7eXmSTYb0eUdSY4CDmmvz2KAqrqXrmoL4OUASR4H7NBiOa2dOwz4MN1zOB3YAPjXNv5YvzdfaH1ub2NtApzdklzQfTa2adef1ebccrz7l6TpwISVJEnS8uMOuiVMz6H7A/ovjKguSfIw4CXt5W5V9WrgXe11b3+p3hK4b9D9Yf1M4HVV9T9ArwLmN32VMmPZo1WT/IguEfMb4BMTjKNnflU9p6qeA8ynq5rZa5x5B6qq/6ZbYnYDcBdwXTv1zAHdX1JVr6mqdw84NxFL6/3oJWj2bj9fOqJ9pAPbz+8CvwcWtNe95XS99/dC4GjgH7i/CmwsL2rx9Z7HP7WfvXv6x/azl7jqJXOWxBl0n5mD6RKL5wG3TfDaH/QdP2zEuVcAb6JLEP2WbqniaHrLAp+XZG1a4gr4dlX9JEmAN7a2l1fVa4DXttcHjPZ7k2RD4GV0SajLgDvpPpcBXt/6rwr8ETgX+Bhdouywce9ckqYBE1aSJEnLl8/R/Tfcs4D/AH4y4vyM9vPuqur9QX9j+/no9vOtdEmOY4GFdAmDXhJkUfX2sPoIsB/w2Kq6aYJxMKK9//iRo8y38ljBtOqtq+j++H8b0Ft+teGA7peONdYELY3340t0SYsXpttEfBbw31U12ibrvTFfDLyFLtEDsFGStYBD6RIkH6J7Fr9jcIXZSDeMiK/3HpwL/BL4+3QbpD8L+Dndcrol9Ue6qrSn0lXHfW4Rru3/HP1ixLlt6T4re9JVop2RZM1Bg1TVVXT3vjrd56WXsOolsjYEeteOfEYbJ3nQKPHNaD9XAt5M9179bWv7m/bzdXRLEs9sY/6C+xOckjStmbCSJElajrQNoHuJlkF/3N/Wfq6e+799rbdUr5cwmVtV29D9Ib8LXZXHR9seSPe2PhP978TeHlbvqqpjq+r2RYij5wkDjn/Uft7VfvY2Mx9vuVSvSunzdBtz917/1RK/qvrTOGONa2m8H+2Z/QewLnBMOzfWsrjemHu0ZYxpSxgfW1V3ALdU1U5tvB3oEpJvT7LpOLfzxPbzAe9BVd3T4lmVLsm5Gt1yxXv/aoTFczRQdM/jGxO5IMkawDvbyxur6uaRfarqPuDi9nJtYOMxhuwlp94HbEH3uest8/sl938Oe8+m9x7+tC3bHPR7c1v7+Wdgw7736UF0iTSA/6yqzeiWGO5FtzTWCitJAlaZ6gAkSZK0yP4JeAzwbbqkxP+pql8k+TLdH7/fSnIp9y8x6y1b+mqSlYHvt+sfDPya7o/uH7Y+j0xyLHBzVX1sUQOcYBw92yT5ZjueyQOTBVcDOwFHJbkJ2GOcqX/efu5Ol2DZfYy+S8uSvh/QJYT2BnamS96cPMZ8RwGfBU5O8hW6JMksuuqcXYDPJtkcuImuymgDuvf2jnHu4+wk3+mLrz+GY+kq1nZrr5fGckAAqurmJM+gW053X7cCb1TvSHIfXaXSpnTL7F47Sr9fA89or38G3DrGuKfS7f3Vq3z6j5b8o6oqyWfp9iE7Lcl53L8ssvceDvy9SfIluud5ZZJv0SWkdqZL0h0KXJ3kNuB/2/1AVxEnSdOeFVaSJEnLmaq6paouqKrRvsHv1cCn6Co59qZbtrdvVfWSDHOAR9AtJXse3ebce1fnNuATdJtEvwZ4JYtvvDh6zqRLKDydblnUnlX1s3buALplizPplqgdP86cH6Dbu2lDuo3kP7wE8U/IUng/AL5J9wwAvlNV/zvGlEfTJWluoUuE7U5XBdTba+oyYC26RMlL6RJX+1TVWN++B/B+4O/olul9EvhM3z3eyP2VZN+vqivHGWuRVNUlVTXWPlM9L6erTuotJdy+qgYt7XwF3WdnE7pnu/tYFWFtueYlfU2njOjybuC9dMnUV9BVrb2DbukpY/zevIZuOeZ9wGy6b0G8nG6vLoD/oqvWehXd538OgxNwkjTtZPT/X5UkSZImT5JD6ZIkJ1bV7KmNRuNJcghd8uVDVfW+qY5HkrRic0mgJEmSpFEleSRdZdPrgXsY8U2IkiRNBpcESpIkSRrL3wCHA2sA+42zXFGSpKXCJYGSJEmSJEkaKlZYSZIkSZIkaaiYsJIkSZIkSdJQcdN1SUNtgw02qBkzZkx1GJIkSZKkSTBv3rxfVdWGI9tNWEkaajNmzGDu3LlTHYYkSZIkaRIk+cGgdpcESpIkSZIkaahYYSVpqN36o9/win8+darDkCRJkqTlxmmH7zPVISwxK6wkSZIkSZI0VExYSZIkSZIkaaiYsJIkSZIkSdJQMWElSZIkSZKkoWLCSpIkSZIkSUPFhJUkSZIkSZKGigkrSZIkSZIkDRUTVpIkSZIkSRoqJqwkSZIkSZI0VExYSdNIkkpySt/rVZL8MsnX2usXJPl/44zxiCRfnuxYJUmSJEnT1ypTHYCkZepOYMskq1fV3cBuwI97J6vqXODcsQaoqp8Ae01qlJIkSZKkac0KK2n6+QbwvHb8cuCLvRNJZic5qh2fkOTIJJcluSXJXq19RpJr2/FqSY5PsjDJ1Ul27Rvn7CTnJbk5yeGtfeU27rXtmoOX4X1LkiRJkpYTVlhJ08/pwPvaMsCtgeOAnUfpuzHwdOAJdJVXI5cCvgmoqtoqyROA85M8vp2bCWwL/Am4KcmngYcBm1TVlgBJ1hs0aZL9gf0B1lhn/cW6SUmSJEnS8ssKK2maqaoFwAy66qpvjNP9nKq6r6quBzYacP7pwClt3BuBHwC9hNUFVXV7Vf0RuB54NHAL8Ngkn07y98DvR4nxmKqaVVWzVlt9nUW7QUmSJEnScs+ElTQ9nQt8gr7lgKP4U99xFnGO/mvvBVapqt8C2wBzgNcDxy7imJIkSZKkacCElTQ9HQd8oKoWLuE4FwP7ALSlgI8Cbhqtc5INgJWq6izgPcB2Szi/JEmSJGkF5B5W0jRUVT8CjlwKQ30W+FyShcBfgNlV9adk1GKsTYDjk/SS5e9cCjFIkiRJklYwqaqpjkGSRrX+wx9bz/mnD011GJIkSZK03Djt8H2mOoQJSzKvqmaNbHdJoCRJkiRJkoaKCStJkiRJkiQNFRNWkiRJkiRJGiomrCRJkiRJkjRUTFhJkiRJkiRpqJiwkiRJkiRJ0lAxYSVJkiRJkqShsspUByBJY3nMIx/KaYfvM9VhSJIkSZKWISusJEmSJEmSNFRMWEmSJEmSJGmomLCSJEmSJEnSUDFhJUmSJEmSpKFiwkqSJEmSJElDxYSVJEmSJEmShsoqUx2AJI3lrp/9gHmHv3aqw5AkSZIm3fb/fOxUhyANDSusJEmSJEmSNFRMWEmSJEmSJGmomLCSJEmSJEnSUDFhJUmSJEmSpKFiwkqSJEmSJElDxYSVJEmSJEmShooJK0mSJEmSJA0VE1aSJEmSJEkaKiaspOVIkjsm0OegJGsspfl2SbLjBPrNTnJUOz40yduXxvySJEmSpOnJhJW04jkIWKSEVZKVRzm1CzBuwmpJJFllMseXJEmSJC1/TFhJy6FW+TQnyZeT3Jjk1HQOBB4BXJjkwtb375JcnuSqJGcmWau135bkY0muAl6S5MAk1ydZkOT0JDOA1wMHJ5mfZOckGyY5K8n32r+dxolzv9bvmnbdGq39hCRHJ7kSOHzynpQkSZIkaXlkZYO0/NoWeBLwE+BSYKeqOjLJW4Fdq+pXSTYA3gM8u6ruTHII8Fbgg22MX1fVdgBJfgI8pqr+lGS9qvpdkqOBO6rqE63PacCnquqSJI8Cvgk8cYwYz66qf2/X/gvwGuDT7dwjgR2r6t6l9UAkSZIkSSsGE1bS8uu7VfUjgCTzgRnAJSP6PBXYArg0CcCDgMv7zp/Rd7wAODXJOcA5o8z5bGCLNhbAOr2KrVFs2RJV6wFr0SW4es4cLVmVZH9gf4CHr7fmGMNLkiRJklZEJqyk5def+o7vZfDvc4BvVdXLRxnjzr7j5wHPAJ4PvDvJVgP6rwQ8tar++IBJ7k9gjXQC8MKquibJbLo9sQbN/QBVdQxwDMAWj9ywRusnSZIkSVoxuYeVtOL5A7B2O74C2CnJ3wAkWTPJ40dekGQlYNOquhA4BFiXriKqfyyA84ED+q6bOU4sawM/TbIqsM/i3Y4kSZIkaboxYSWteI4BzktyYVX9EpgNfDHJArrlgE8YcM3KwClJFgJXA0dW1e+ArwJ79jZdBw4EZrWN2a+n25R9LO8FrqTbY+vGpXBvkiRJkqRpIFWutpE0vLZ45IZ18oF7THUYkiRJ0qTb/p+PneoQpGUuybyqmjWy3QorSZIkSZIkDRUTVpIkSZIkSRoqJqwkSZIkSZI0VExYSZIkSZIkaaiYsJIkSZIkSdJQMWElSZIkSZKkoWLCSpIkSZIkSUPFhJUkSZIkSZKGyipTHYAkjWWNhz+a7f/52KkOQ5IkSZK0DFlhJUmSJEmSpKFiwkqSJEmSJElDxYSVJEmSJEmShooJK0mSJEmSJA0VE1aSJEmSJEkaKn5LoKShdtuvfsjs498y1WFIkqTFdMK+R0x1CJKk5ZAVVpIkSZIkSRoqJqwkSZIkSZI0VExYSZIkSZIkaaiYsJIkSZIkSdJQMWElSZIkSZKkoWLCSpIkSZIkSUPFhJUkSZIkSZKGigkrSZIkSZIkDRUTVpIkSZIkSRoqJqykFUSSe5PMT3JdkmuSvC3JUvkdT3JokrcvjbH6xpyd5KilOaYkSZIkacWwylQHIGmpubuqZgIkeRhwGrAO8P4pjUqSJEmSpEVkhZW0AqqqXwD7A29OZ+UkH0/yvSQLkrwOIMlaSS5IclWShUn26I2R5N1J/jvJJcDmfe1zkhzRqrmuTbJDa39oknPa+Fck2XqsdkmSJEmSRmOFlbSCqqpbkqwMPAzYA7i9qp6c5MHApUnOB34I7FlVv0+yAXBFknOB7YCXATPp/nfiKmBe3/BrVNXMJM8AjgO2BD4AXF1VL0zyTOCkdv1o7aNKsj9dwo011197qTwPSZIkSdLyw4SVND38HbB1kr3a63WBzYAfAR9uiaf7gE2AjYCdga9U1V0ALYnV74sAVXVRknWSrAc8HXhxa/92kvWTrDNG+6iq6hjgGIANZmxUS3brkiRJkqTljQkraQWV5LHAvcAvgAAHVNU3R/SZDWwIbF9V9yS5DVhtAsOPTCKZVJIkSZIkLTXuYSWtgJJsCBwNHFVVBXwTeEOSVdv5xydZk67S6hctWbUr8Og2xEXAC5OsnmRt4Pkjpti7jfN0uqWGtwMXA/u09l2AX1XV78dolyRJkiRpICuspBXH6knmA6sCfwFOBv61nTsWmAFclSTAL4EXAqcCX02yEJgL3AhQVVclOQO4hq5C63sj5vpjkqvbXK9ubYcCxyVZANwFvGqcdkmSJEmSBkpXfCFJE5NkDvD2qpq7LObbYMZG9Q/vf9mymEqSJE2CE/Y9YqpDkCQNsSTzqmrWyHaXBEqSJEmSJGmouCRQ0iKpql2mOgZJkiRJ0orNCitJkiRJkiQNFRNWkiRJkiRJGiomrCRJkiRJkjRUTFhJkiRJkiRpqJiwkiRJkiRJ0lDxWwIlDbUZG2zKCfseMdVhSJIkSZKWISusJEmSJEmSNFRMWEmSJEmSJGmomLCSJEmSJEnSUDFhJUmSJEmSpKFiwkqSJEmSJElDxYSVJEmSJEmShsoqUx2AJI3l9ltv4xv/tO9UhyFJ0nJr95OOn+oQJElaZFZYSZIkSZIkaaiYsJIkSZIkSdJQMWElSZIkSZKkoWLCSpIkSZIkSUPFhJUkSZIkSZKGigkrSZIkSZIkDRUTVpIkSZIkSRoqJqwkSZIkSZI0VExYaegl2SjJaUluSTIvyeVJ9pykuWYkubYdz0py5GTMM04MGya5MsnVSXYece6gJGv0vb5jCefaIcmcJDcnuSrJ15NsNc41s5MctSTzSpIkSZI0llWmOgBpLEkCnAOcWFWvaG2PBl6wlMZfuaruHXSuquYCc5fGPIvoWcDCqnrtgHMHAacAdy3pJEk2Ar4EvKKqLmttTwceByxc0vElSZIkSVpcVlhp2D0T+HNVHd1rqKofVNWn4a+rfZJ8Lcku7fhzSeYmuS7JB/r63JbkY0muAl6SZPsk1yS5BnhTX79dknytHe/QKruuTnJZks375j87yXmtSunw1r5ykhOSXJtkYZKDR95Yq+b6dpIFSS5I8qgkM4HDgT2SzE+yel//A4FHABcmubCv/bAW/xUtCdWr0joryffav50GPNs30yUCL+t7tpdU1TltjOf3VXr9V2/sEfcwsE+SI5K8rx0/J8lFSdZNcmuSVVv7Ov2vJUmSJEnqMWGlYfck4KrFvPbdVTUL2Br42yRb9537dVVtV1WnA8cDB1TVNmOMdSOwc1VtC7wP+HDfuZnA3sBWwN5JNm1tm1TVllW1VZtjpE/TJYy2Bk4Fjqyq+W38M6pqZlXd3etcVUcCPwF2rapdW/OawBUt9ouA/Vr7EcCnqurJwIuBYwfMP96zvQR4arvn04F/XoQ+72zPYlfgSGDfqrodmAM8r/V5GXB2Vd0zRgySJEmSpGnIJYFariT5DPB0uqqrJ4/T/aVJ9qf7nG8MbAEsaOfOaOOtB6xXVRe19pOB5w4Ya13gxCSbAQX0VwVd0JIxJLkeeDRwHfDYJJ8Gvg6cP2DMpwEv6pv38HHuZ5A/A19rx/OA3drxs4EtuhWVAKyTZK2qGnXPqyRXAusA51fVW4BHAmck2Rh4EHDrgMsG9qmqu5LsR5dEO7iqvt/6H0uX1DoH2Jf7E2wjY9kf2B9gwzXXHPMBSJIkSZJWPFZYadhdB2zXe1FVb6Lb42nD1vQXHvg5Xg0gyWOAtwPPahVMX++da+5cxDg+BFxYVVsCzx8x1p/6ju8FVqmq3wLb0FUUvZ7BFU5Lwz1VVf1zt+OV6CqfZrZ/mwxIVo18tk8B3kuXnIOuAuyoViH2Oh54z0ygz1bAr+mWMfbmuBSY0ZZtrlxV1w66qao6pqpmVdWsdR88aFpJkiRJ0orMhJWG3beB1ZK8oa9tjb7j24CZSVZqS/F2aO3r0CWlbm/7Kg2qmqKqfgf8rm02DrDPKHGsC/y4Hc8eL+gkGwArVdVZwHvoSwz1uYxuWVxv3ovHGxf4A7D2BPqdDxzQF8/MAX0+A8xOsmNfW/+z7b/nV40yz8A+bWP8twHbAs9N8pS+a04CTmPwMklJkiRJkkxYabi16qEX0u1BdWuS7wInAoe0LpfSLUO7nm6vpKvaddcAV9PtPXVa6zeafYHPJJkPZJQ+hwMfSXI1E1tKuwkwp415Ct2eTiMdAOybZAHwSuAtExj3GOC8/k3XR3EgMKtt6H49XZXXA1TVz+j23vpIkv9JchmwF9DbxP5Q4Mwk84BfjTLPX/Vp3+z4BeDtVfUT4DXAsUl6pVKnAg8BvjiB+5UkSZIkTUO5fzWRJE2+JHsBe1TVKyfSf7P1N6gjnvf8SY5KkqQV1+4nWdQsSRpeSea1L0x7ADddl7TMtE3onwvsPtWxSJIkSZKGlwkrSctMVR0wfi9JkiRJ0nTnHlaSJEmSJEkaKiasJEmSJEmSNFRMWEmSJEmSJGmomLCSJEmSJEnSUDFhJUmSJEmSpKFiwkqSJEmSJElDZZWpDkCSxrLuY2aw+0nHT3UYkiRJkqRlyAorSZIkSZIkDRUTVpIkSZIkSRoqJqwkSZIkSZI0VExYSZIkSZIkaaiYsJIkSZIkSdJQGfdbApOsDnwQ2A14E7A3cElVfWmSY5Mkfvrj3/Lhd395qsOQJIl3HbbXVIcgSdK0MZEKq38DDga2Ah4MrAy8YzKDkiRJkiRJ0vQ1kYTVi4CP972eB2w+OeFIkiRJkiRpuptIwuo+IH2vtwHumJxwJEmSJEmSNN2Nu4cV8HXgre34ZODhwLGTFpEkSZIkSZKmtYkkrA6iq7B6HrAqcCLuYSVJkiRJkqRJMm7Cqqp+D+y7DGKRJEmSJEmSRk9YJVkwxnVVVdtMQjySJEmSJEma5saqsNpymUUhSZIkSZIkNaMmrKpqIt8gKEmSJEmSJC1V4yalktySZPe+13+b5JuTG5Y0eZJUklP6Xq+S5JdJvraI48xJMmuU9v9Nkr62c5LcsWSRjxrDTUnmt397TcIchyb5cRv/+iQvX4pjL/VnIkmSJEla/o21h9U6wEOAGcCMJI9qp/4WePbkhyZNmjuBLZOsXlV3A7sBP17Kc/wO2Am4JMl6wMZLefx++1TV3EW9KMkqVfWXCXb/VFV9IslmwLwkX66qexZ1TkmSJEmSJmKsCquDgVuAAj4N3Nr+vR/438kPTZpU3wCe145fDnyxdyLJDkkuT3J1ksuSbN7aV09yepIbknwFWH2M8U8HXtaOXwSc3Tf+WkkuSHJVkoVJ9mjtT06yIMlqSdZMcl2SRd5LLsmMJNf2vX57kkPb8Zwk/5ZkLvDuJLcmWbWdW6f/9SBVdTNwF10ymyQzk1zR4v5Kkl77fkm+l+SaJGclWaO1P6Y924VJ/mVR702SJEmSND2MlbD6b+A/gQDz6f7A/zpwCrDP5IcmTarTgZclWQ3YGriy79yNwM5VtS3wPuDDrf0NwF1V9US6xO32Y4x/AfCMJCvTJa7O6Dv3R2DPqtoO2BX4ZJJU1feAc4F/AQ4HTqmqawGSzB9jrlP7lgSuP4F7f1BVzaqqDwBzuD9x9zLg7LEqp5JsB9xcVb9oTScBh1TV1sBCuudCG+fJ7dtEbwBe09qPAD5XVVsBPx1jnv2TzE0y9867fj+BW5IkSZIkrUjG2nT9i8AXk7wfOLOqrl92YUmTq6oWJJlBV131jRGn1wVObMvfCuhVHD0DOLLv+gVjTHEvcAldEmj1qrqtf0sr4MNJngHcB2wCbAT8DPgg8D26pNaBffHOHGOuBywJTLL2GH3hgcmzY4F/Bs4B9gX2G+Wag5PsCzweeH6bZ11gvar6TutzInBmO96yVVCtB6wF9Pa92wl4cTs+GfjYoMmq6hjgGIBNNn5cjXM/kiRJkqQVzFh7WB0JHAesD7y+749tgKqqt0xybNJkOxf4BLAL3ee850PAhVW1Z0tqzVnM8U8HvgIcOqJ9H2BDYPuquifJbcBq7dz6dAmeVVvbnYsx7194YPXkaiPO/9+YVXVpW0K4C7Byr6JrgN4eVi8AvpDkcePEcALwwqq6Jslsumf8f9OOfwuSJEmSpOlsrCWBbwY2bz8H/ZOWd8cBH6iqhSPa1+X+Tdhn97VfBLwCoO0ttfU4418MfIS+/bH6xv9FS1btCjy679zngfcCpzJK9dEE/Bx4WJL1kzwY+Idx+p8EnAYcP97AVXUuMBd4VVXdDvw2yc7t9CuBXrXV2sBP235Y/UuIL+X+vb1cWixJkiRJGmjUCiu6vXWubz+lFU5V/Yi2xG+Ew+mWBL6Hbt+2ns8Bxye5gW5fpnnjjF90FVwjnQp8NclCuuTPjQBJ/gm4p6pOa3tfXZbkmVX17STzx1kW2D/vPUk+CHyXLvF24ziXnEq3b9bIxNpoPgicluTfgVcBR7dN1W+hW1YIXdLtSuCX7WdvmeJb2rWHACyXL9AAACAASURBVP8xwfkkSZIkSdNMur+pB5xIvg18sKrmLNOIJC1TSfYC9qiqV051LINssvHj6k2vXtxiM0mSlp53HbbXVIcgSdIKJ8m8qpo1sn2sCqtdgKMnLSJJUy7Jp4HnArtPdSySJEmSJPWMlbACeGL7JrO/UlUXTUI8kpahqjpgqmOQJEmSJGmk8RJW72v/Bll5KcciSZIkSZIkjZuw+hZw87IIRJIkSZIkSYLxE1bHVdWXlkkkkiRJkiRJErDSVAcgSZIkSZIk9Ru1wqqqTGZJkiRJkiRpmRtvSaAkTamNN3kI7zpsr6kOQ5IkSZK0DFlFJUmSJEmSpKFiwkqSJEmSJElDZdyEVZLVk3w8yfwkOyU5MslLl0VwkiRJkiRJmn4mUmH1b8DBwFbAg4GVgXdMZlCSJEmSJEmaviaSsHoR8PG+1/OAzScnHEmSJEmSJE13E0lY3Qek7/U2wB2TE44kSZIkSZKmu1Um0OfrwFvb8cnAw4FjJy0iSerz8x//gH995+umOgxJ0grirR/5/FSHIEmSJmAiCauD6CqsngesCpyIe1hJkiRJkiRpkoybsKqq3wP7LoNYJEmSJEmSpNETVkkWAG8HPjHgdFXVNpMWlSRJkiRJkqatsSqstgQe0n5KkiRJkiRJy8SoCauq6n2D4BnLKBZJkiRJkiSJlcbrkGR+krcl2XhZBCRJkiRJkqTpbdyEFbAR8HHgf5P8V5LZSdaa5LgkSZIkSZI0TU0kYfUIYFfgc8ATgC8AP5vMoCRJkiRJkjR9jZuwqqoC5gKXAd9tzatPZlCSJEmSJEmaviayh9U5wC+BU+kqrY4Hnj3JcUkrpCR3TMGcl02w33pJfp0k7fXTklSSR7bX6yb5TZKJVGb2xjw0ydsHtM9Icu1Ex5EkSZIkTS8T+cPz74HzgJcCG1XVa6vqwskNS1KSlZfGOFW14wT7/Q74KfDE1rQjcHX7CfBU4LtVdd9Exksy6reQSpIkSZI0lokkrB4OvAS4Hnjc0vojWpqukuyS5Gt9r49KMrsd35bkY0muAl6SZL8k30tyTZKzkqzR+r0kybWt/aLW9qQk323f7LkgyWat/Y6+uQ5JsrBd99EB4V3G/QmqHYFPjXh9aRtnZpIr2jxfSfKQ1j4nyb8lmQu8ZcR9b9/mvQZ40xI9REmSJEnSCm0iCauNgRuAa9u/65M8cexLJC2BX1fVdlV1OnB2VT25qrah+z18TevzPuA5rf0Fre31wBFVNROYBfyof9AkzwX2AJ7Srjt8wNyXcn+C6rHAmW0sWntveeFJwCFVtTWwEHh/3xgPqqpZVfXJEWMfDxzQ5h5Tkv2TzE0y9867/jhed0mSJEnSCmYiCavP0CWtvtj+bQx8ejKDkqa5M/qOt0xycZKFwD7Ak1r7pcAJSfYDelWPlwPvSnII8OiqunvEuM8Gjq+quwCq6jcD5r4M2DHJY4DbquqPQJKsBWwPXJlkXWC9qvpOu+ZE4BmjxA/dAOu1ay5qTSeP9QCq6piW9Jq15hqrjdVVkiRJkrQCmkjCahbwzqr6x6r6R+BdwA6TG5a0QvsLD/zdG5mRubPv+ATgzVW1FfCBXt+qej3wHmBTYF6S9avqNLpqq7uBbyR55qIGVlU3A+sBz6dLgAHMA/alS2BNZNP4O8fvIkmSJEnS6CaSsPoN8Owkj03yWGA34NeTG5a0QvsBsEWSB7fKo2eN0Xdt4KdJVqWrsAIgyeOq6sqqeh/dt3hu2n4/b6mqI4H/ALYeMda3gH379sF66ChzXkG3/1QvYXU5cBBt/6qquh34bZKd2/lXAt8ZOUi/tqH775I8vTXtM1Z/SZIkSdL0NpFv8ToW+CBdxUXPeycnHGnF1b41709V9cMkX6LbE+5Wum/iG817gSvpklJX0iWwAD7eNlUPcAFwDXAI8Mok9wA/Az7cP1BVnZdkJjA3yZ+Bb9BVTI50KbA7MLe9vpxuP6vL+vq8Cji6Jb9uoavAGs++wHFJCjh/Av0lSZIkSdNUqmr8Tsmr6f6ALeDrVXXCJMclrXCSbAP8e1W5pHYRbLrxhnXw7BdNdRiSpBXEWz/y+akOQZIk9Ukyr6pmjWyfSIUVVXUccNxSj0qaJpK8HjiQbmmdJEmSJEkaw6gJqyT3jnFdVdWEkl2SoKqOBo6e6jgkSZIkSVoejJV0Ct0SwJ8Av1s24UiSJEmSJGm6G+tbAo+n+3r6DYCFwFuraqvev2USnSRJkiRJkqadURNWVfUaYGPgjcCmwHlJbkvy98sqOEmSJEmSJE0/Y1VYUVV30n1l/a3An+mqrdZeBnFJkiRJkiRpmho1YZXk3UluBr4N/A1wALBxVZ25rIKTJEmSJEnS9JOqGnwiuY9u0/VbgBtGnK6q2mOSY5MkZs2aVXPnzp3qMCRJkiRJkyDJvKqaNbJ9rG8JhO6bAh/X/vUbnOWSJEmSJEmSltBYCavHLLMoJEmSJEmSpGbUhFVV/WBZBiJJkiRJkiTBON8SKEmSJEmSJC1rJqwkSZIkSZI0VExYSZIkSZIkaaiM9y2BkjSl7v7lH7jms3OmOgxJQ2ibN+4y1SFIkiRpklhhJUmSJEmSpKFiwkqSJEmSJElDxYSVJEmSJEmShooJK0mSJEmSJA0VE1aSJEmSJEkaKiasJEmSJEmSNFRMWEmSJEmSJGmomLCSJEmSJEnSUJm0hFWSe5PMT3JtkjOTrNHaL1uMsd619CN8wPgbJrkyydVJdh5x7qBe7O31HUs41w5JLkpyU5vv2P7xJ3D9I5J8uR3PTnLUgD4zkly7JHEuriRfae/7/yS5vR3PT7JjktuSbLAEYz8+yTeS3JzkqiRfSrLR0ox/MeP6YpIFSQ4e0f7CJFv0vZ6TZNYSzNP7nbqm3f+OrX2x3++JxNT63NTmvTTJ5osz14BxB35+JUmSJEmazAqru6tqZlVtCfwZeD1AVe04smOSVcYZa1ITVsCzgIVVtW1VXTzi3EHAhBNKY2nJlTOBQ6pq86raFjgPWHuC169SVT+pqr2WRjyToar2rKqZwGuBi9tnYGZVLXKisl+S1YCvA5+rqs2qajvgs8CGizDGyksSwyhjPhx4clVtXVWfGnH6hcAWAy5bXL3fqW2AdwIfWYpjj2efNu+JwMeXdLAJ/M5LkiRJkqaxZbUk8GLgb+D+CqUkuyS5OMm5wPWt7Zwk85Jcl2T/1vZRYPVWWXJqa/vHJN9tbZ9PsnL7d0Kr6Fo4stqlXTcjybdbNcwFSR6VZCZwOLBHG2/1vv4HAo8ALkxyYV/7Ya3a5IpehU+r0joryffav50GPIc3ASdW1eW9hqr6clX9vFVeXd6qri7rVbG0KpRzk3wbuGBANc2mrQLm5iTv72tfJcmpSW5I8uW+Crftk3ynPedvJtm4te/X4r6m3Uev/wlJjmwx3ZJkSZNlB7TqoIVJntDmWDPJce09vTrJHgOuewVweVV9te/Zzamqa0dW6iT5WpJd2vEdST6Z5BrgaUk+muT69hn4ROsz7nuXZLUkx7e4r06yazt1PrBJ++zs3Nd/R+AFwMfbuce1Uy9p9/nfvf7ts/vxNveCJK+bwHNcB/jtgDhntN+rq9JXhdXOHdLiv6b9XvVft1J7r/9lnHkv4v7f5cX5LB2d5Eq63zlJkiRJkgaa9IRVukqK5wILB5zeDnhLVT2+vX51VW0PzAIOTLJ+Vf0/7q8s2SfJE4G9gZ1aJc+9wD7ATGCTqtqyqrYCjh8w36fpEkZbA6cCR1bVfOB9wBltjrt7navqSOAnwK5V1UtQrAlc0apNLgL2a+1HAJ+qqicDLwaOHTD/lsC8UR7VjcDOrerqfcCHRzynvarqbwdct0Obb2u6ZEhvedfmwGer6onA74E3Jlm1PYO92nM+Djis9T+7qp7c7usG4DV9c2wMPB34B+D/Eh1J5o9yL2P5VauO+hzw9tb2buDbVbUDsCtdkmfNEdeN9ezGsiZwZd997Qk8qX0GesmZibx3bwKqfbZeDpyYrurrBcD322fn/6rzWkXZucA72rnvt1OrtPs8COglGF8D3N7mfzKwX5LHDIihl7i9scX4oQF9fgHs1p7x3sCRAEmeC+wBPKU9i/6E0Sp0vw83V9V7BozZ7/nAwiX4LD0S2LGq3jrOPJIkSZKkaWwyl+Ws3pfQuBj4woA+362qW/teH5hkz3a8KbAZ8OsR1zwL2B74XhKA1en+SP8q8Ngkn6ZbOnb+gPmeBryoHZ/M4lV5/Bn4WjueB+zWjp8NbNFiAlgnyVpVNdE9r9alS4JsBhSwat+5b1XVb0a57ltV9WuAJGfTJZbOAX5YVZe2PqcAB9ItP9wS+FaLc2Xgp63Plq26Zj1gLeCbfXOcU1X3Adenb8+oljBcVGe3n/O4/734O+AFSXoJrNWAR9ElO5bUvcBZ7fh24I/AF5J8jfvfx4m8d0+nS9BQVTcm+QHweLpk4KLov/8Z7fjvgK37qtfWpfvs3/rAS7vELUCSpwEnJdlyRJ9VgaPSVQ7e22Ls3ePxVXVXu4f+z9PngS9V1WGM7tQkdwO3AQfQJUQX57N0ZlXdO8Y8tPvbH9gfYOOHTvk2ZZIkSZKkZWwyE1Z3TyChcWfvoC3hejbwtKq6K8kcusTFSKGrknrnX51ItgGeQ7df1kuBVy9e6GO6p6qqHd/L/c9wJeCpVfXHMa69ji7Z9h8Dzn0IuLCq9kwyA5jTd+7OAf17apTXg9oDXFdVTxswzgnAC6vqmiSzgV36zv2p7zgsmd5Y/c8uwIur6qYxrrsOGFRhBvAXHlgt2P+5+WMvQVJVf0myA13Scy/gzcAzmdh7t7SMdv8HVNU3B1/y16rq8nQb2I/cw+tg4OfANnT3NZF7ugzYNcknx3gG+1TV3N6LJOuxeJ+lsT7L/6eqjgGOAXjSozcf+VmWJEmSJK3gltUeVhOxLvDblqx6AvDUvnP3tCVIABcAeyV5GECShyZ5dPvjfaWqOgt4D90yupEuA17Wjvehq/wazx+Y2Kbo59NVntDiGpSsOwp4VZKn9PV7UataWhf4cWuePYH5enZrz2B1uk2+e1VVj2pVONDt/3QJcBOwYa89yapJntT6rA38tD3nfRZh/qXhm3R7W6XFte2APqcBOyZ5Xq8hyTNahdFtwMy2D9OmdMsk/0qStYB1q+obdImdbdqpibx3F9OeS5LH01WAjZVgg4l/dr4JvKH3GU/3bYgjl0Q+QPsdWZm/rkBcF/hpq4h7ZesD8C1g3779pB7ad80XgG8AX8rEN0Mf1s+SJEmSJGkFMEwJq/PoNgq/gW6fpCv6zh0DLEhyalVdT5eQOj/JAro/xDcGNgHmtGWIp9B9i9pIB9D90b6A7o/5t0wgrmOA89K36fooDgRmtU2zr6d9K2K/qvo5XcLsE0luavf6HLrExuHAR5JczaJVvn2XbsnbAuCsviqYm4A3tTkeQvften+mqyz6WLpNyOcDvU253wtcSZfwunEiEy/mHlaDfIhuKduCJNcxYG+mtrfYP9Altm5uz/iNwC9bzLfSbd5/JHDVKPOsDXytvf+XAL19lMZ97+i+kXClJAuBM4DZVfWnAf36nQ68I90m7Y8bo9+xLfar0m2o/3kGfwZ6e1jNbzG8asDyus/SJUWvAZ5Aq2iqqvPo9tSa265/e/9FVfWvwNXAyUnG/d+Fpf1ZkiRJkiSpX+5f3SZJw+dJj968Tjvk81MdhqQhtM0bd5nqECRJkrSEksyrqlkj24epwkqSJEmSJEkyYSVJkiRJkqThYsJKkiRJkiRJQ8WElSRJkiRJkoaKCStJkiRJkiQNFRNWkiRJkiRJGiomrCRJkiRJkjRUTFhJkiRJkiRpqKwy1QFI0lhW33BttnnjLlMdhiRJkiRpGbLCSpIkSZIkSUPFhJUkSZIkSZKGigkrSZIkSZIkDRUTVpIkSZIkSRoqJqwkSZIkSZI0VPyWQElD7ec//zmf/OQnpzoMSRPwtre9bapDkCRJ0grCCitJkiRJkiQNFRNWkiRJkiRJGiomrCRJkiRJkjRUTFhJkiRJkiRpqJiwkiRJkiRJ0lAxYSVJkiRJkqShYsJKkiRJkiRJQ8WElSRJkiRJkoaKCStJkiRJkiQNFRNWGlOSe5PMT3JdkmuSvC3JlH5ukmyY5MokVyfZecS5g5Ks0ff6jiWYZ5ckt7f7vyHJ+/vav7b4dzDqfA+IfYLX7Nzem/lJVu9rXy/JG/teL5WY2zynL+k4kiRJkiSNxYSVxnN3Vc2sqicBuwHPBd4/xTE9C1hYVdtW1cUjzh0ELFLSZxwXV9VMYBbwj0m2W4pjj7Q4se8DfKS9R3f3ta8HvHGUaxZLkicCKwM7J1lzaY4tSZIkSVI/E1aasKr6BbA/8OZ0ZiS5OMlV7d+OAEk+k+QF7fgrSY5rx69Ocli77oYk/96qg87vrw7qaf2+nWRBkguSPCrJTOBwYI8BVUUHAo8ALkxyYV/7Ya067IokG7W2DZOcleR77d9O49z7ncA84G9GxLhDkstbtddlSTZv7bOTnJ3kvCQ3Jzm875q/a9dcleTMJGuNFnvfNc9qcyxMclySByd5LfBS4ENJTh1xyUeBx7Vn9PHWtlaSLye5McmpSdLG3j7Jd5LMS/LNJBuP8hheDpwMnA/s0RfbnCRHtLmuTbJDa1+zxfrdFvserf1JrW1+e283G+vZS5IkSZKmHxNWWiRVdQtdlc3DgF8Au1XVdsDewJGt28VAb6neJsAW7Xhn4KJ2vBnwmVa59TvgxQOm+zRwYlVtDZwKHFlV84H3AWeMrCqqqiOBnwC7VtWurXlN4Iqq2qbNvV9rPwL4VFU9uc197Fj3nWR94KnAdSNO3QjsXFXbtrg+3HduZnsuWwF7J9k0yQbAe4Bnt+c2F3jrKLH35l4NOAHYu6q2AlYB3lBVxwLnAu+oqn1GxPX/gO+3Z/SO1rYtXRXXFsBjgZ2SrEr3nPeqqu2B44DDRnkMewOnw/9v787D7CjLvI9/fybsqyBvBgSNCxIRETE6oKi4jKJmUDSujALDK76jsgjMuKAjio6KiAyiYFQGdBAVlBHRV0B22fclAVwAWWUnsghouOePeloOTafTHZL0Sff3c119ddVTVU/dVedUTnNzP8/hSLrkVa8VWyXaB1sfAHsBJ1fVS4BXAV9ulVn/D/jPnsq1GwefKMlOSS5IcsH9998/n3AkSZIkSePV5LEOQEu1ZYCDWtXTPOA5rf0MYLckGwJzgCe3qp3NgV2ANYFrW/IJusqlqUP0vznw1rb8PbrKqtF6GBiYu+lCumGNAK8FNmxFRgCrJlm5qgbPefXyJBcDjwBfrKrZSbbs2b4acHirEiq6ezLgpKqaC5BkDvB0uqF6GwJntnMvC5y9gGvYgO5+/aatHw58CDhgAccNdl5V3djiuYTunt8DbASc2OKZBNwy+MAk04E7qur6JDcBhyZZo6ruarscCVBVpydZNcnqwOuArZPs2fZZHnhau969kqwL/KSqfjv4fFU1C5gFsN5669Uor1OSJEmStJQzYaVRSfJMuuTUbXRzWd0KvICuWu9BgKq6qSUstqKralqDbujafVV1b6tWeqin23nA44YELiJ/qaqBhMc8Hn3PPwnYrKoeXMDxZ1TVjGG27wOcUlXbJJkKnNqzbfA1TgYCnFhVgyuUloT5xTO7qjZfwLHvBqYlua6tr0pXmfattj44qVSt77dV1dWDtl2Z5FzgTcAvknygqk4e1ZVIkiRJksY1hwRqxJKsBRwCHNSSQKsBt1TVI8B76apzBpxDN/zsdLqKqz3b79E4C3hXW952hMffC6wygv1OAHYeWGlVYgtjNeCmtrz9CPY/h24o3rPbeVdKMlCZNr/YrwamDhxDd69PW8B5RnofrgbWSrJ5i2eZJM/r3SHdt0K+A3h+VU2tqql0c1j1Jt3e2fbdApjbKsuOB3bumSvrhe33M4Fr2jDInwIbjyBOSZIkSdIEYsJKC7JCmxx7NvArukTPZ9q2bwDbJbkUmAb0TjZ0BjC5qn4HXERXZTXahNXOwA5JLqNL0uw6gmNmAb8cauLyQXYBprdJv+fQzau0MPYFvtCGDS6wYrGqbqdLbB3Zrutsuns339hbFdgOwFFJLqcbnnjIAs5zJ92wwyt6Jl0far+HgZnAl9rreAnw0kG7vRy4qapu7mk7nW5I5cAE7Q+2e3AIsGNr24duiORl7f2zT2t/B3BFG5a4EfDd4a5FkiRJkjTx5NHRUpI0eklOBfasqgsWR//rrbde7bbbbouja0mL2B577DHWIUiSJGkpk+TCqpo+uN0KK0mSJEmSJPUVJ12X9IRU1ZZjHYMkSZIkaXyxwkqSJEmSJEl9xYSVJEmSJEmS+ooJK0mSJEmSJPUVE1aSJEmSJEnqKyasJEmSJEmS1Ff8lkBJfW3KlCnsscceYx2GJEmSJGkJssJKkiRJkiRJfcWElSRJkiRJkvqKCStJkiRJkiT1FRNWkiRJkiRJ6ismrCRJkiRJktRXTFhJkiRJkiSpr0we6wAkaTj3zb2Z04/be6zDkPrSK2bsPdYhSJIkSYuFFVaSJEmSJEnqKyasJEmSJEmS1FdMWEmSJEmSJKmvmLCSJEmSJElSXzFhJUmSJEmSpL5iwkqSJEmSJEl9xYSVJEmSJEmS+ooJK0mSJEmSJPUVE1ZLUJI1k1zSfv6Y5Ka2fE+SOU+g3+2THDSo7dQk05941ItGkq2SnJfkqnbNP0zytLGOa0CSqUkqyed62p6S5C+D7+0o+rtiiPbpSQ58AnF+NslrF/b4EZ7juiSXJ7ksyQlJ/m6Ux2+fZJ35bHt7ktlJHumn96ckSZIkqb+YsFqCqurOqtqkqjYBDgG+2pY3AR4Z2+gWnSSTB61vBHwN2K6qprVrPgKYOgbhDeda4E09628HZi/KE1TVBVW1yxM4/t+r6leLMqb5eFVVbQxcAHxipAclmQRsDwyZsAKuAN4KnP5EA5QkSZIkjV8mrPrHpCTfatUnJyRZASDJs5L8MsmFSc5IMm20HSe5r2d5ZpLD2vJhSQ5MclaSa5LMbO1PSvKNVg11YpJf9Gx7UZLTWjzHJ1m7tZ+a5IAkFwC7Dgrho8B/VNWVAw1VdWxVnd6OfX+S85NcmuTHSVbsie/gJOe0+LZMcmiSKweuoe33uiRnJ7koyVFJVm7tX0wyp1UK7TeCW/UAcGVP5c87gR/1nGdqkpNbfycNVIglmZLkmBb/pUleOuj+PzPJxUle3K7huNa+d7ueU9v17dJzzKeSXJ3k10mOTLJnzz0ZeC3+vd23K5LMSudZSS7q6Wf93vWFcDrw7NbXwUkuaO/Rz/Sc47okX2rneTcwHTgiXSXdCr2dVdWVVXX1E4hHkiRJkjQBmLDqH+sDX6+q5wH3AG9r7bOAnavqRcCewDfmc/w78+hww0vokgYjsTawBTAD+GJreytd9dOGwHuBzQGSLENXKTWzxXMo8PmevpatqulV9ZVB53geMFzS5CdV9eKqegFwJbBjz7Ynt/N/BDgW+Grr7/lJNknyFOCTwGuralO6iqDdk6wJbAM8r1UKfa5dw9ZJPjtMLD8A3pVkPWAecHPPtq8Bh7f+jgAGhvYdCJzW4t+UnqqsJBsAPwa2r6rzhzjfNOD1wEuATydZJsmL6V7/FwBvYP6v5UHtvm0ErADMqKrfA3OTbNL22QH4r2Gud0FmAJe35b2qajqwMfDKJBv37HdnVW1aVf9N9xps26oJ//wEzi1JkiRJmqAmL3gXLSHXVtUlbflCYGqrFHopcFSSgf2Wm8/xP6yqDw+sJDl1hOf9n6p6BJiTZEpr2wI4qrX/MckprX0DYCPgxBbPJOCW3hgWdLKWSDoJWBGYVVX7ARulmztqdWBl4PieQ35WVZXkcuDWqrq89TObLqm2Ll1i7cwW07LA2cBc4EHgO62i6TjoKrvoEl/z80tgH+DWIa5nc7pkHsD3gH3b8quB97X+59EljJ4MrAX8FHhrVc1vjrKfV9VDwENJbgOmAC8DflpVDwIPJvnZfI59VZJ/o7uXa9Alyn4GfBvYIcnudFViLxnmeufnlCTzgMvoEoIA70iyE92/G2vT3ffL2rYFvvaj0c6zE8CUtVZblF1LkiRJkpYCJqz6x0M9y/PoKmaeBNzT5nx6IqpneflhzhuGF2B2VW0+n+33z6d9Nl3l0aVVdSewSRvitnLbfhjwlqq6NMn2wJZDxPfIoFgfoXv/zgNOrKp3Py7Y5CXAa4CZwIfpEkvDqqqHk1wI7EGXkNl6QccMYy5wPV0CcH4Jq8Gv+4ieySTL01XbTa+qG5LszaOv7Y+BTwMnAxe2e9577Hp0iS2AQ6rqkCFO8aqquqPnmGfQVfi9uKrubkMye99L83vtF0pVzaKrLmTa+uvUAnaXJEmSJI0zDgnsY1X1J+DaJG8HaHMUvWAhuro1yXOTPIlumNyCnAm8Ld1cVlN4NIF0NbBWkr8NEUzyvBH0ty+wV5Ln9rSt2LO8CnBLG3K47Qj663UO8LIkA/MsrZTkOa06bbWq+gXdcMLR3LevAB+tqrsGtZ8FvKstbwuc0ZZPAv6lnX9SkoGSoIfp7vf7krxnFOc/E/jHJMu365gxxD4DyaI72j4zBza0yqzjgYMZYjhgVd0wMPn/fJJVQ1mVLik1t70n3jDMvvfSvaaSJEmSJC0UE1b9b1tgxySX0lUqvXkh+vgY3ZC4s3jsEL75+TFwI11V0H/TzT81t6oepkuMfKnFcwndkMVhtWF8uwLfbROJnwk8F/h+2+VTwLl0iZqrRnFdVNXtdN9Kd2SSy+iGA06jS5gc19p+DewOI5rDiqqaXVWHD7FpZ7qhdpfRze01MLn8rnTD8y6nG865YU9f99MlnD6SZETVWm2uq2Pphtv9f7o5pOY+dpe6B/gW3bfuHQ8Mnh/rCLoqtBNGcs4RxHQpcDHd6/N9utdqfg4DDhlq0vUk2yS58UteWgAADcdJREFUkW545c+THD9UB5IkSZKkiS1VjrbR4yVZuarua3NOnQe8rKr+ONZxTRQ9939Fum/q26mqLmrzWe1fVacs4Pg96SrMPrUk4l2cpq2/Ts366k5jHYbUl14xY++xDkGSJEl6QpJc2L7g6zGcw0rzc1yS1ekmMd/HZNUSNyvJhnRD/w5vyapD6YZS/nq4A5McAzyLEczZJUmSJElSPzJhpSFV1ZZjHcNEVlWPm/Oqqv55hMeOZJ4ySZIkSZL6lnNYSZIkSZIkqa+YsJIkSZIkSVJfMWElSZIkSZKkvmLCSpIkSZIkSX3FhJUkSZIkSZL6igkrSZIkSZIk9ZXJYx2AJA1n5dXW4RUz9h7rMCRJkiRJS5AVVpIkSZIkSeorJqwkSZIkSZLUV0xYSZIkSZIkqa+YsJIkSZIkSVJfMWElSZIkSZKkvuK3BErqazfccy+7H3PaWIch9ZX9t3nlWIcgSZIkLVZWWEmSJEmSJKmvmLCSJEmSJElSXzFhJUmSJEmSpL5iwkqSJEmSJEl9xYSVJEmSJEmS+ooJK0mSJEmSJPUVE1aSJEmSJEnqKyasJEmSJEmS1FdMWEmSJEmSJKmvmLCSlkJJ5iW5JMmlSS5K8tLWvk6So0fZ16lJpvesT01yxaKOufW9bJJZSX6T5Kokb1sc55EkSZIkLd0mj3UAkhbKn6tqE4Akrwe+ALyyqm4GZi7JQJJMrqq/jnD3vYDbquo5SZ4ErLEYQ5MkSZIkLaWssJKWfqsCd8Njq6OSrJjkR0nmJDkmybm9lVQjkWRSki8nOT/JZUk+0Nq3THJGkmOBOa1t9yRXtJ/d5tPlP9Ml16iqR6rqjoW7ZEmSJEnSeGaFlbR0WiHJJcDywNrAq4fY54PA3VW1YZKNgEuG6e+IJH9uy8sCj7TlHYG5VfXiJMsBZyY5oW3bFNioqq5N8iJgB+DvgQDnJjmtqi4eOEGS1dviPkm2BH4PfLiqbh0cTJKdgJ0AVllryrA3QpIkSZI0/lhhJS2d/lxVm1TVNGAr4LtJMmifLYAfAFTVFcBlw/S3betvE+CNPe2vA97XkmPnAmsC67dt51XVtT3nOqaq7q+q+4CfAC8fdI7JwLrAWVW1KXA2sN9QwVTVrKqaXlXTV1h1tWHCliRJkiSNR1ZYSUu5qjo7yVOAtRZD9wF2rqrjH9PYVUjdP8q+7gQeoEtmARxFV8ElSZIkSdJjWGElLeWSTAMm0SWEep0JvKPtsyHw/IXo/njgX5Is0/p5TpKVhtjvDOAtbd6slYBtWtvfVFUBPwO2bE2voc1/JUmSJElSLyuspKXTwBxW0FVBbVdV8waNCvwGcHiSOcBVwGxg7ijP821gKnBRG3J4O/CWwTtV1UVJDgPOGziud/6qHh8FvpfkgNbXDqOMR5IkSZI0AaQrepA03iSZBCxTVQ8meRbwK2CDqnp4jEMblSnP3qC2/fKssQ5D6iv7b/PKsQ5BkiRJWiSSXFhVj/tGeyuspPFrReCUNpwvwAeXtmSVJEmSJGliMmEljVNVdS/wuCy1JEmSJEn9zknXJUmSJEmS1FdMWEmSJEmSJKmvmLCSJEmSJElSXzFhJUmSJEmSpL5iwkqSJEmSJEl9xYSVJEmSJEmS+srksQ5Akoaz3uqrsP82rxzrMCRJkiRJS5AVVpIkSZIkSeorJqwkSZIkSZLUV1JVYx2DJM1XknuBq8c6DmmMPQW4Y6yDkMaYz4HkcyAN8FkYX55eVWsNbnQOK0n97uqqmj7WQUhjKckFPgea6HwOJJ8DaYDPwsTgkEBJkiRJkiT1FRNWkiRJkiRJ6ismrCT1u1ljHYDUB3wOJJ8DCXwOpAE+CxOAk65LkiRJkiSpr1hhJUmSJEmSpL5iwkpSX0qyVZKrk/wuycfGOh5pcUmyXpJTksxJMjvJrq19jSQnJvlt+/3k1p4kB7Zn47Ikm47tFUiLTpJJSS5Oclxbf0aSc9v7/YdJlm3ty7X137XtU8cybmlRSrJ6kqOTXJXkyiSb+5mgiSbJR9rfRVckOTLJ8n4mTDwmrCT1nSSTgK8DbwA2BN6dZMOxjUpabP4K7FFVGwKbAR9q7/ePASdV1frASW0duudi/fazE3Dwkg9ZWmx2Ba7sWf8S8NWqejZwN7Bja98RuLu1f7XtJ40X/wn8sqqmAS+geyb8TNCEkeSpwC7A9KraCJgEvAs/EyYcE1aS+tFLgN9V1TVV9TDwA+DNYxyTtFhU1S1VdVFbvpfuP0yeSveeP7ztdjjwlrb8ZuC71TkHWD3J2ks4bGmRS7Iu8Cbg2209wKuBo9sug5+DgefjaOA1bX9pqZZkNeAVwHcAqurhqroHPxM08UwGVkgyGVgRuAU/EyYcE1aS+tFTgRt61m9sbdK41krYXwicC0ypqlvapj8CU9qyz4fGqwOAfwMeaetrAvdU1V/beu97/W/PQds+t+0vLe2eAdwO/FcbHvvtJCvhZ4ImkKq6CdgPuJ4uUTUXuBA/EyYcE1aSJPWBJCsDPwZ2q6o/9W6r7it9/VpfjVtJZgC3VdWFYx2LNMYmA5sCB1fVC4H7eXT4H+Bngsa/Nkfbm+kSuOsAKwFbjWlQGhMmrCT1o5uA9XrW121t0riUZBm6ZNURVfWT1nzrwLCO9vu21u7zofHoZcDWSa6jGwb+arp5fFZvw0Hgse/1vz0HbftqwJ1LMmBpMbkRuLGqzm3rR9MlsPxM0ETyWuDaqrq9qv4C/ITuc8LPhAnGhJWkfnQ+sH77JpBl6SZZPHaMY5IWizbHwneAK6tq/55NxwLbteXtgJ/2tL+vfTPUZsDcnmEi0lKpqj5eVetW1VS6f/NPrqptgVOAmW23wc/BwPMxs+1vxYmWelX1R+CGJBu0ptcAc/AzQRPL9cBmSVZsfycNPAd+Jkww8XWU1I+SvJFuPpNJwKFV9fkxDklaLJJsAZwBXM6jc/d8gm4eqx8BTwP+ALyjqu5qf7gdRFca/wCwQ1VdsMQDlxaTJFsCe1bVjCTPpKu4WgO4GPinqnooyfLA9+jmfLsLeFdVXTNWMUuLUpJN6L58YFngGmAHukIDPxM0YST5DPBOum9Tvhj4v3RzVfmZMIGYsJIkSZIkSVJfcUigJEmSJEmS+ooJK0mSJEmSJPUVE1aSJEmSJEnqKyasJEmSJEmS1FdMWEmSJEmSJKmvmLCSJEnSuJJkapLq+bkryQ+SrLkYz3lqO9dTFuLYvduxM9v6J5LstpBxfDjJH5I8lOTmJN9fmH4kSRprJqwkSZI0Xl0MvAc4BXgnsO/YhvN4SSYDRwPvBs5pzZ8ARp2wSrIx8DXgD8BObXmFRRPp32KVJGmJMGElSZKk8ermqjoS+GRb/3uAJFskOTfJfUl+l2Sn1j5QmfXrJD9Pck+S7yVZrm2vJFe05Zltfe/BJ02yUZI5SR5offwiyVPbtoFqqkOTXAN8GZgJHAlsluRUYCXg6W2/w5Kcn+S2JMu0Pn6a5MEkqw869bT2+yrgqKr6QlVt0xPXVkkubHHdmGTz1v7+JL9Ncn+S85Js0dq3bzH8MMls4EdJlk2yX5Kb2rUdlWStJ/IiSZI0FBNWkiRJGq+WacmUt7T169uwwGOBpwN7ArcB30zy6p7jNgNOBU4G/gn4wCjP+zBwOLALcBDwemDvQfu8DvgScNyg9s8CDwF30FVdHdx+1gJmJFm5HXtsVd0z6Njz2rHvB+YmOSPJNgBJ1gf+B1gH+NfW56R23bOA24HdgacBxw4aPvl64JvAd4GPA3sAPwMOAN4AHDLyWyNJ0shY1itJkqTx6nV0CSmAm+iG2m0OPBn4j6o6JMnvgRPoEi9fb/ueXVVfTvIsYBtgS+DAUZx3ObqhiBv3tD1/0D77VtU3AZK8fKCxqk5O8lfg/qr6Qdt+OfAVYAdgWWB5uuTRY1TVda06alfgH4AtgJcleX67huWAz1XVwHWSZL+2+OmqOjHJ0+ju02Y9XR9aVQe2/fdqbb1JvH8Y/nZIkjR6JqwkSZI0Xp0L7AXcBcypqoeSrNu21aDfvTLo94BHePTv58HD8XrtRZes+hhwEfBzuiRTr5uHOf4xMVXVA0kOAz4MrEKXhPvl44JOlq2qC4D3JglwKLA9sOEw5xp8zqHux+BY/wrMAOa1dUdtSJIWORNWkiRJGq/uqKqTBrWdDdwN7JjkBuC9rf0XPftsluRf6aqxoBseCHAd8Iwk76FLHi3ImsBbgWVGGffdwFpJtgPOr6o5dMPudqOrlDqgqv46xHFvTPJx4BjgVuCFdAmo2cAldMMFP9nlslgVOIPuuvcAPtMqynZs5z8H+MchznEcMB3YDvgVXTLsGXRVapIkLTL+3xBJkiRNGFV1J7A1cD2wP/B3wAeq6pSe3c6iSwy9BjiCbv4mgI8CfwI+B1wwzGk+Tzfx+QfpqrvmjjLMfenmwTqMLuFFVV1NN6cWDDEcsPlNO99H6BJcqwAfrKo5VfVbuuGNN9NN9P4hYF5VnUz3jYL/h+5+3Ahs3e7TUL7Qjn853fxcbwBOG+X1SZK0QKkaqupXkiRJmliSTAWuBX5eVTPGNppHtW8pfAXdPFoPVNWLxjgkSZIWOyusJEmSpP62Nt2QuxXpKqMkSRr3rLCSJEmSJElSX7HCSpIkSZIkSX3FhJUkSZIkSZL6igkrSZIkSZIk9RUTVpIkSZIkSeorJqwkSZIkSZLUV0xYSZIkSZIkqa/8L+mDP99pu+nOAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 1152x432 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "popular = movies_ranked.sort_values('popularity',ascending=False)\n",
    "\n",
    "popular = movies_ranked.sort_values('popularity', ascending=False)\n",
    "\n",
    "plt.figure(figsize=(16,6))\n",
    "\n",
    "ax = sns.barplot(x=popular['popularity'].head(10), y=popular['original_title'].head(10), data=popular, palette='deep')\n",
    "\n",
    "plt.title('\"Most Popular\" Movies by TMDB Votes', weight='bold')\n",
    "plt.xlabel('Popularity Score', weight='bold')\n",
    "plt.ylabel('Movie Title', weight='bold')\n",
    "\n",
    "plt.savefig('./tmp/popular_movies.png')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### MK3\n",
    "\n",
    "Half/half recommendation based on scaled weighted average & popularity score"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-14T13:23:02.687699Z",
     "start_time": "2019-07-14T13:23:02.582864Z"
    }
   },
   "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>original_title</th>\n",
       "      <th>norm_weighted_average</th>\n",
       "      <th>norm_popularity</th>\n",
       "      <th>score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>Interstellar</td>\n",
       "      <td>0.906439</td>\n",
       "      <td>0.827162</td>\n",
       "      <td>0.866801</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>546</th>\n",
       "      <td>Minions</td>\n",
       "      <td>0.460630</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.730315</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>Guardians of the Galaxy</td>\n",
       "      <td>0.851874</td>\n",
       "      <td>0.549462</td>\n",
       "      <td>0.700668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>788</th>\n",
       "      <td>Deadpool</td>\n",
       "      <td>0.725217</td>\n",
       "      <td>0.587690</td>\n",
       "      <td>0.656453</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>Mad Max: Fury Road</td>\n",
       "      <td>0.670973</td>\n",
       "      <td>0.495989</td>\n",
       "      <td>0.583481</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1881</th>\n",
       "      <td>The Shawshank Redemption</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.156179</td>\n",
       "      <td>0.578090</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>The Dark Knight</td>\n",
       "      <td>0.934991</td>\n",
       "      <td>0.213941</td>\n",
       "      <td>0.574466</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3865</th>\n",
       "      <td>Whiplash</td>\n",
       "      <td>0.916431</td>\n",
       "      <td>0.219887</td>\n",
       "      <td>0.568159</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3337</th>\n",
       "      <td>The Godfather</td>\n",
       "      <td>0.959622</td>\n",
       "      <td>0.164074</td>\n",
       "      <td>0.561848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>662</th>\n",
       "      <td>Fight Club</td>\n",
       "      <td>0.953823</td>\n",
       "      <td>0.167611</td>\n",
       "      <td>0.560717</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                original_title  norm_weighted_average  norm_popularity  \\\n",
       "95                Interstellar               0.906439         0.827162   \n",
       "546                    Minions               0.460630         1.000000   \n",
       "94     Guardians of the Galaxy               0.851874         0.549462   \n",
       "788                   Deadpool               0.725217         0.587690   \n",
       "127         Mad Max: Fury Road               0.670973         0.495989   \n",
       "1881  The Shawshank Redemption               1.000000         0.156179   \n",
       "65             The Dark Knight               0.934991         0.213941   \n",
       "3865                  Whiplash               0.916431         0.219887   \n",
       "3337             The Godfather               0.959622         0.164074   \n",
       "662                 Fight Club               0.953823         0.167611   \n",
       "\n",
       "         score  \n",
       "95    0.866801  \n",
       "546   0.730315  \n",
       "94    0.700668  \n",
       "788   0.656453  \n",
       "127   0.583481  \n",
       "1881  0.578090  \n",
       "65    0.574466  \n",
       "3865  0.568159  \n",
       "3337  0.561848  \n",
       "662   0.560717  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from sklearn import preprocessing\n",
    "\n",
    "min_max_scaler = preprocessing.MinMaxScaler()\n",
    "movies_scaled = min_max_scaler.fit_transform(movies_clean[['weighted_average','popularity']])\n",
    "movies_norm = pd.DataFrame(movies_scaled, columns=['weighted_average','popularity'])\n",
    "movies_norm.head()\n",
    "\n",
    "movies_clean[['norm_weighted_average', 'norm_popularity']] = movies_norm\n",
    "\n",
    "movies_clean['score'] = movies_clean['norm_weighted_average'] * 0.5 + movies_clean['norm_popularity'] * 0.5\n",
    "movies_scored = movies_clean.sort_values(['score'], ascending=False)\n",
    "\n",
    "\n",
    "movies_scored[['original_title', 'norm_weighted_average', 'norm_popularity', 'score']].head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-14T13:23:03.007937Z",
     "start_time": "2019-07-14T13:23:02.691172Z"
    }
   },
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAABC4AAAGDCAYAAADklVExAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjAsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+17YcXAAAgAElEQVR4nOzdeZRlVXn38e+PQZlBARFQaSAoMisNiSAKxiGOoOJIFAgRRxAUxSEBJEYT1BARHBAFlUGCIiFgAAcI89ANTTcgyivggCKigkyiNs/7x9lXLkVNPVTX7arvZ61a95yz99n7OadrLbhPPWefVBWSJEmSJEmDaJnJDkCSJEmSJGkkJi4kSZIkSdLAMnEhSZIkSZIGlokLSZIkSZI0sExcSJIkSZKkgWXiQpIkSZIkDSwTF5IkadpIsleSSjJnsmOZbtp9ryQzJmHuw9rcJ0zgHDu3Oe6aqDkkaboycSFJ0hSV5Na+L4vzk9ye5FtJNlpM44/ry2CSC/rieCjJHUnOTPLUBZirl3C4YFHjHud8GyU5J8k9Se5KcnGStcY4Z+e+6/xRkvS1HdfXdthiirH377vzKH1m9M3b+z34eZITkjxxccQx2fp+D3s/dyeZneT1kx2bJGnxMHEhSdLUdxZwDHA3sBtw3CTFcSHw2RbHy4GvTFIc43E88CJgHnAG8BRglQU4fxPgbwGSrA68YXEHuBA+DxwLLA/sCXxzcsNZMEmWSTLa/7veDHwauAB4JnBikg2XRGySpIll4kKSpKnvS1W1P3BQ29+015BkzSRfaH+9vyfJJUl26mt/Y5IbkjyQ5LdJLkvy7FY1cGjrtuc4qyG+VVXvAv6x7W/dN8/ft3nuSfLHVrHwjta2F10iAeC5ba5bxxn/eknOS3JfkouA8X6RfVr7/FhV7dXO+/k4z30QeAB4e9vfE1gJ+N3QjklemeSqFvtPkhyTZI3W9pgkX2yVMg8m+VmS/2lttwIbtGHOb/dkrzHi+mBVvR14R9vfoW+u0eLor9rYJ8ltSX6d5Igky7Y+J/RXk/SfM1IwST7V/t3+kOT+JJf3V4/0Ver8e5IrgD/SJZBGMq+qDqiqXYHfAsvSJZBGmv8VSa5M8vt2zZ9KslJr61XP3JrkQ+mqhO5I8r6+81dPcmo7/1q6ZIkkaQKYuJAkaerbJ8lRwBFt/5vQ/QUb+G9gX+CnwH8BWwLnJXlakhWBE+i+IJ8EnA2sBmwMXA5c0cb7Ad1fur8xViBJlgO2a7tz+5o2oPuL+YnAqcCTgKOTPAu4AfhO63dbm+vLY8Xf+p8MvKC13wIcPFaMzSXt87NJnlRV86vqz+M89w/tGl6RZD3gbcCPgYv6OyV5CXA6sFX7vIcuqfD11uXNdEmeO4EvAbOBHVrbl1t/6P49P013n0aV5LHAjn1x3juOOPp9GDgXWBF4Hw8nQRbGhnS/Q18Czgf+GjgtyapD+r0PuAM4hS4pNJItk/xnkjOAx9Mlmq4crmOSF9H97mwIfKv1fQ9dZVK/DYC/By4G1gb+PUkvGXIU8Fq6CqLZwCFjXK8kaSGZuJAkaep7GbAfXaXFg3RfsgC2pfsSew9wdfv8f8AKwN50f7Felq5S4Azg0KraHDixqs4BzmnjXNn+0n30GHEcCfwJ+ARwHfDGvrZP0CVJbqf7ov4zIMAuVXUlXQIC4P+1uQ4fK/4kTwKe2857YVW9mUd/MX2UJB8AXkWXiHkyXSJkzSS7t7/Cjyf58TlguXZNTwe+AAytPnhX+/xYVe0J7Az8GXhRuvU/lm/t8+gSR3sDTwBo1//b1n50uyfDfknv8zu6ZMWBbf+QlowZK45+r6yqf6BLYECXXFlY/wh8j+6L/03A/cBadMmnfidW1cur6k1V9ctRxtsIeDewa9u/iq5KYzj7t89r6O7LtW1/z17VRTMfeF5VvYou+RVg61Zp0ltD443tnvzzKLFJkhbBcpMdgCRJmnCvpPvr8vZ0f/X/UpL/A2a09lXpvvD1+6uqujfJ2+keCek9ovBz4E106wgsqAvpEhKvBzYDZtJVWdDGf+Ew56w9yngz2uew8QPrt+0HqupnbftHowXYKiQ+CtxQVa9JcgjwEeDbdH/1h4erP0ZUVVcmuZqu2uNBukdddhzSrRf/D9o5dya5E3gi3V/6v0qXRNiV7p4V8N0kr6yq+8aKYRifp0sO/BL4TlX1vqyPFcdNfWP8oH3e2D6fNMJcy44WSJI16Spu1humeei/+SXD9BnOf1fVbkkeT1dF8Uq6x6MOH6bvjPb5gvbzl9DoEiA9t1fV7W37Lh5e62Qt4DHt+A/b56i/W5KkhWfFhSRJ00BVFV2lxX10//3fGLi1Nf8SWKGqUlWhW4+h91f4r1TV+nRfMN9N90W195fl+e1zvP8/8a2q+nu6L5LLAEcmeWxbS6GXtHhOa/vftt97M8dwc40V/22tfcUkT27bY73J5Al0X7rXTLJKq2z4El3S52XAyVV19Tiv93Pt87SqunOY9l78m8Jfvsz33lzyE+DPVfU6usdzng58l+5L9qtanwW9/x+sqvdW1Sf7khbjiaPf0/v78vC6H71Eymrtc4sxYtmJ7nfqdroEyWPpEgPw8L95z2iPhzxKVf2Whx9DGunf+9b2+e7e70373dm4qq7r69f/eFB/xcydPFzN0XssadxvyZEkLRgrLiRJmvr2SbIL3eKBa9D91X0u3Zevy4BnAVcluZTuS+Rz6R4nOAH4VbpFN3/BwyX8vS+YvSqGFyf5DHBBVY3nTRVH0iVB1gP2oluv4V66v2QfBvye9kaOPr25tk3yWboS/y+NFn9VnZDkQrpkyHlJrgJeN0Zs19P95fypwOx27dv2tT8uybJVNX+4k4c4ie4L8vUjtB8DvBj4ULpX1G5L9/9m36mqH6V7BezBwCy6+zPc/d8IODzJK4BP9VWWLIix4pjR1/f0Vq3z2rb/tfZ5TfvcM8mfgT3GmPNX7XNt4D/oEmkL8taW4WyZ5D/p1rfoxXfZCH2PAV5Ct2bFs+gWU90KWJNxLOBaVfOTnEpXfXRyku8Auy9i/JKkEVhxIUnS1Pcyumf6t6BbZPDlVXVHVT1E9xjC5+n+Ur4X8Ay6RTgvb+d+hy7hsQ+weWt7b2s7jW6hxpXpKhx2GU8wVXUP3WKS0C28+BDdmzd+CvwN3RfzoQt9Xki3zsV8urd17DrO+Pegq1TYgC4Z8R9jxPYnuuqPU4DV6b6YLt/inEf3Bf9T47zOB6rquyOty1BVZ9N9wb6e7kvv6nRrYfSSKz+kSy69hO7+/5HuMZazWvthdGt6PIsuEbTOeOJaiDj6HUp3f/5Adx96a4Z8je7fZ3m637cjx5jzMuBf6ZJUvft922jnjENvjYvX0iV1DuPhqpeh83+b7lGSa+nu76vofg8/PVz/EexP93u6Bl1FzscXMm5J0hjSVY5KkiRJj9YqLm4BaI9TSJK0RFlxIUmSJEmSBpaJC0mSJEmSNLB8VESSJEmSJA0sKy4kSZIkSdLAMnEhSZIkSZIG1nKTHYA0HmuttVbNmDFjssOQJEmSJE2A2bNn31lVaw/XZuJCS4UZM2Ywa9asyQ5DkiRJkjQBkvxkpDYfFZEkSZIkSQPLigstFW75+W954/tPmuwwJEmSJGmpcfIRe0x2CIuFFReSJEmSJGlgmbiQJEmSJEkDy8SFJEmSJEkaWCYuJEmSJEnSwDJxIUmSJEmSBpaJC0mSJEmSNLBMXEiSJEmSpIFl4kKSJEmSJA0sExeSJEmSJGlgmbhYSiW5dxx9Dkiy0mKab+ckO4yj315Jjm7bhyU5aHHML0mSJEmankxcTG0HAAuUuEiy7AhNOwNjJi4WRZLlJnJ8SZIkSdLSx8TFUq5VQlyQ5BtJbkxyUjr7A+sB5yc5v/V9YZLLklyd5LQkq7Tjtyb59yRXA69Jsn+SG5LMTfL1JDOAtwEHJpmTZKckayf5ZpKr2s+OY8T5ltbv2nbeSu34CUk+n+QK4IiJu1OSJEmSpKWRf+GeGp4BbA78ArgE2LGqjkryHmCXqrozyVrAPwHPr6r7khwMvAc4vI3xm6p6JkCSXwAbVtWDSdaoqruSfB64t6o+2fqcDBxZVRcneQpwLvD0UWI8vaq+2M79KLAP8JnW9iRgh6qa339Ckn2BfQFWWm3NRbg9kiRJkqSllYmLqeHKqvo5QJI5wAzg4iF9/gbYDLgkCcBjgMv62k/t254LnJTkDOCMEeZ8PrBZGwtgtV4Fxwi2aAmLNYBV6BIdPacNTVoAVNWxwLEAaz5xoxplbEmSJEnSFGXiYmp4sG97PsP/uwb4TlW9YYQx7uvbfinwHODlwIeTbDlM/2WAv6mqPzxikocTGUOdAOxWVdcm2YtuzYzh5pYkSZIk6S9c42JquwdYtW1fDuyY5K8Akqyc5KlDT0iyDPDkqjofOBhYna5Con8sgPOA/frO22aMWFYFfplkeWCPhbscSZIkSdJ0Y+JiajsWOCfJ+VX1a2Av4JQkc+keE9l0mHOWBU5MMg+4Bjiqqu4C/gd4ZW9xTmB/YGZbwPMGusU7R/PPwBV0a3DcuBiuTZIkSZI0DaTKpQM0+NZ84kb1ojf/y2SHIUmSJElLjZOPWHqK3ZPMrqqZw7VZcSFJkiRJkgaWiQtJkiRJkjSwTFxIkiRJkqSBZeJCkiRJkiQNLBMXkiRJkiRpYJm4kCRJkiRJA8vEhSRJkiRJGljLTXYA0nhs+KTHL1XvIJYkSZIkLR5WXEiSJEmSpIFl4kKSJEmSJA0sExeSJEmSJGlgmbiQJEmSJEkDy8SFJEmSJEkaWCYuJEmSJEnSwPJ1qFoq3H/7T5h9xD9OdhiSJEnSwNr2/cdNdgjShLDiQpIkSZIkDSwTF5IkSZIkaWCZuJAkSZIkSQPLxIUkSZIkSRpYJi4kSZIkSdLAMnEhSZIkSZIGlokLSZIkSZI0sExcSJIkSZKkgWXiYppKUklO7NtfLsmvk5zV9l+R5ANjjLFekm9MdKySJEmSpOlruckOQJPmPmCLJCtW1QPAC4Dbeo1VdSZw5mgDVNUvgN0nNEpJkiRJ0rRmxcX09m3gpW37DcApvYYkeyU5um2fkOSoJJcmuTnJ7u34jCTXte0VkhyfZF6Sa5Ls0jfO6UnOSXJTkiPa8WXbuNe1cw5cgtctSZIkSVpKWHExvX0dOKQ9HrIV8GVgpxH6rgs8G9iUrhJj6CMi7wSqqrZMsilwXpKntrZtgGcADwI/TPIZ4AnA+lW1BUCSNRbfZUmSJEmSpgorLqaxqpoLzKCrtvj2GN3PqKqHquoGYJ1h2p8NnNjGvRH4CdBLXHyvqu6uqj8ANwAbADcDGyX5TJK/A34/dMAk+yaZlWTW7+57YMEvUJIkSZK01DNxoTOBT9L3mMgIHuzbzgLO0X/ufGC5qvodsDVwAfA24LihJ1XVsVU1s6pmPm7lFRdwSkmSJEnSVGDiQl8GPlJV8xZxnIuAPQDaIyJPAX44UuckawHLVNU3gX8CnrmI80uSJEmSpiDXuJjmqurnwFGLYajPAp9LMg/4M7BXVT2YjFicsT5wfJJe8uyDiyEGSZIkSdIUk6qa7BikMW32pLXra/vvOtlhSJIkSQNr2/c/6ulraamRZHZVzRyuzUdFJEmSJEnSwDJxIUmSJEmSBpaJC0mSJEmSNLBMXEiSJEmSpIFl4kKSJEmSJA0sExeSJEmSJGlgmbiQJEmSJEkDy8SFJEmSJEkaWMtNdgDSeKz0xA3Y9v3HTXYYkiRJkqQlzIoLSZIkSZI0sExcSJIkSZKkgWXiQpIkSZIkDSwTF5IkSZIkaWCZuJAkSZIkSQPLt4poqXDrnT9jr+PfPdlhSJIkSeNywt6fnuwQpCnDigtJkiRJkjSwTFxIkiRJkqSBZeJCkiRJkiQNLBMXkiRJkiRpYJm4kCRJkiRJA8vEhSRJkiRJGlgmLiRJkiRJ0sAycSFJkiRJkgaWiQtJkiRJkjSwlqrERZJ1kpyc5OYks5NcluSVEzTXjCTXte2ZSY6aiHnGiGHtJFckuSbJTkPaDkiyUt/+vYs41/ZJLkhyU5Krk5ydZMsxztkrydGLMq8kSZIkSaNZbrIDGK8kAc4AvlJVb2zHNgBesZjGX7aq5g/XVlWzgFmLY54F9LfAvKr6x2HaDgBOBO5f1EmSrAP8F/DGqrq0HXs2sDEwb1HHlyRJkiRpYS1NFRfPA/5YVZ/vHaiqn1TVZ+DRf/1PclaSndv255LMSnJ9ko/09bk1yb8nuRp4TZJtk1yb5FrgnX39dk5yVtvevlV6XJPk0iRP65v/9CTntKqFI9rxZZOckOS6JPOSHDj0wlp1x/eTzE3yvSRPSbINcASwa5I5SVbs678/sB5wfpLz+47/a4v/8paM6FVtfDPJVe1nx2Hu7bvoEkKX9t3bi6vqjDbGy/sqP77bG3vINQzbJ8mnkxzStl+U5MIkqye5Jcny7fhq/fuSJEmSJPUsTYmLzYGrF/LcD1fVTGAr4LlJtupr+01VPbOqvg4cD+xXVVuPMtaNwE5V9QzgEOBjfW3bAK8DtgRel+TJ7dj6VbVFVW3Z5hjqM3SJg62Ak4CjqmpOG//Uqtqmqh7oda6qo4BfALtU1S7t8MrA5S32C4G3tOOfBo6squ2AVwPHDTP/WPf2YuBv2jV/HXj/AvT5YLsXuwBHAXtX1d3ABcBLW5/XA6dX1Z/6B0yyb0s4zfrDvQ8gSZIkSZp+lppHRYZKcgzwbLoqjO3G6P7aJPvSXe+6wGbA3NZ2ahtvDWCNqrqwHf8a8OJhxlod+EqSTYAC+qsEvte+lJPkBmAD4HpgoySfAc4GzhtmzGcBr+qb94gxrmc4fwTOatuzgRe07ecDm3VP2gCwWpJVqmrENTGSXAGsBpxXVe8GngScmmRd4DHALcOcNmyfqro/yVvokikHVtWPW//j6JIbZwB783Ci5S+q6ljgWIC1ZqxTY94BSZIkSdKUszRVXFwPPLO3U1XvpFsDYu126M888npWAEiyIXAQ8LetouHsXltz3wLG8S/A+VW1BfDyIWM92Lc9H1iuqn4HbE1XYfA2hq94WBz+VFW9L/fzeTgptQxdJcQ27Wf9YZIWQ+/tXwP/TJekga4i5OhWMfJWHnnNjKPPlsBv6B5v6c1xCTCjPc6zbFVdt6AXLEmSJEma+pamxMX3gRWSvL3v2Ep927cC2yRZpj2isX07vhpdcuLutu7CcFUUVNVdwF1tUUqAPUaIY3Xgtra911hBJ1kLWKaqvgn8E30Jgj6X0j0u0Zv3orHGBe4BVh1Hv/OA/fri2WaYPscAeyXZoe9Y/73tv+Y9R5hn2D5tAdX3As8AXpzkr/vO+SpwMsM/PiNJkiRJ0tKTuGjVBLvRrVFxS5Irga8AB7cul9A9nnAD3VoKV7fzrgWuoVub4uTWbyR7A8ckmQNkhD5HAB9Pcg3je9RmfeCCNuaJdGs+DLUfsHeSucCbgHePY9xjgXP6F+ccwf7AzLbw5w10VR+PUFW3063N8fEk/y/JpcDuQG+x08OA05LMBu4cYZ5H9WlvgvkScFBV/QLYBzguSa8a4yTgccAp47heSZIkSdI0lIefLpCWrCS7A7tW1ZvG6rvWjHXqZYe+fqxukiRJ0kA4Ye9PT3YI0lIlyez2Uo1HWWoX59TSrS1W+mLgJZMdiyRJkiRpcJm40KSoqv3G7iVJkiRJmu6WmjUuJEmSJEnS9GPiQpIkSZIkDSwTF5IkSZIkaWCZuJAkSZIkSQPLxIUkSZIkSRpYvlVES4UZaz3Zd2FLkiRJ0jRkxYUkSZIkSRpYJi4kSZIkSdLAMnEhSZIkSZIGlokLSZIkSZI0sExcSJIkSZKkgWXiQpIkSZIkDSxfh6qlwt233Mq337z3ZIchSZKkSfKSrx4/2SFImiRWXEiSJEmSpIFl4kKSJEmSJA0sExeSJEmSJGlgmbiQJEmSJEkDy8SFJEmSJEkaWCYuJEmSJEnSwDJxIUmSJEmSBpaJC0mSJEmSNLBMXExBSeYnmZPk+iTXJnlvksXyb53ksCQHLY6x+sbcK8nRi3NMSZIkSdLUsNxkB6AJ8UBVbQOQ5AnAycBqwKGTGpUkSZIkSQvIiosprqruAPYF3pXOskk+keSqJHOTvBUgySpJvpfk6iTzkuzaGyPJh5P8KMnFwNP6jl+Q5NOtuuO6JNu3449PckYb//IkW412XJIkSZKkkVhxMQ1U1c1JlgWeAOwK3F1V2yV5LHBJkvOAnwGvrKrfJ1kLuDzJmcAzgdcD29D9vlwNzO4bfqWq2ibJc4AvA1sAHwGuqardkjwP+Go7f6TjkiRJkiQNy8TF9PNCYKsku7f91YFNgJ8DH2sJiIeA9YF1gJ2Ab1XV/QAtmdHvFICqujDJaknWAJ4NvLod/36SNZOsNsrxYSXZl65ahLVXXnnRr1ySJEmStNQxcTENJNkImA/cAQTYr6rOHdJnL2BtYNuq+lOSW4EVxjF8jbG/0KrqWOBYgE3WXGuxjStJkiRJWnq4xsUUl2Rt4PPA0VVVwLnA25Ms39qfmmRlusqLO1rSYhdggzbEhcBuSVZMsirw8iFTvK6N82y6R1DuBi4C9mjHdwburKrfj3JckiRJkqRhWXExNa2YZA6wPPBn4GvAf7S244AZwNVJAvwa2A04CfifJPOAWcCNAFV1dZJTgWvpKjauGjLXH5Jc0+b6h3bsMODLSeYC9wN7jnFckiRJkqRhpfsjvLTgklwAHFRVsyZ6rk3WXKs+/dKhxR6SJEmaLl7y1eMnOwRJEyjJ7KqaOVybj4pIkiRJkqSB5aMiWmhVtfNkxyBJkiRJmtqsuJAkSZIkSQPLxIUkSZIkSRpYJi4kSZIkSdLAMnEhSZIkSZIGlokLSZIkSZI0sExcSJIkSZKkgeXrULVUWH3DGbzkq8dPdhiSJEmSpCXMigtJkiRJkjSwTFxIkiRJkqSBZeJCkiRJkiQNLBMXkiRJkiRpYJm4kCRJkiRJA2vMt4okWRE4HHgB8E7gdcDFVfVfExyb9Be/vO13fOzD35jsMCRJkibUh/5198kOQZIGzngqLv4TOBDYEngssCzwvokMSpIkSZIkCcaXuHgV8Im+/dnA0yYmHEmSJEmSpIeNJ3HxEJC+/a2BeycmHEmSJEmSpIeNucYFcDbwnrb9NeCJwHETFpEkSZIkSVIznsTFAXQVFy8Flge+gmtcSJIkSZKkJWDMxEVV/R7YewnEIkmSJEmS9AgjJi6SzB3lvKqqrScgHkmSJEmSpL8YreJiiyUWhSRJkiRJ0jBGTFxU1XjeOCJJkiRJkjRhxkxOJLk5yUv69p+b5NyJDWviJakkJ/btL5fk10nOWsBxLkgyc4TjP02SvmNnJFnsr5Jtc/0wyZz2s/sEzHFYktva+DckecNiHNvX60qSJEmShjXaGherAY8DZgAzkjylNT0XeP7Ehzbh7gO2SLJiVT0AvAC4bTHPcRewI3BxkjWAdRfz+P32qKpZC3pSkuWq6s/j7H5kVX0yySbA7CTfqKo/LeickiRJkiSN12gVFwcCNwMFfAa4pf0cCvx04kNbIr5N95pXgDcAp/Qakmyf5LIk1yS5NMnT2vEVk3w9yQ+SfAtYcZTxvw68vm2/Cji9b/xVknwvydVJ5iXZtR3fLsncJCskWTnJ9UkWeL2RJDOSXNe3f1CSw9r2BUn+M8ks4MNJbkmyfGtbrX9/OFV1E3A/XWKLJNskubzF/a0kveNvSXJVkmuTfDPJSu34hu3ezkvy0QW9NkmSJEnS9DFa4uJHwP8CAebQfck/GzgR2GPiQ1sivg68PskKwFbAFX1tNwI7VdUzgEOAj7Xjbwfur6qn0yVxth1l/O8Bz0myLF0C49S+tj8Ar6yqZwK7AJ9Kkqq6CjgT+ChwBHBiVV0HkGTOKHOd1PeoyJrjuPbHVNXMqvoIcAEPJ3BeD5w+WiVFkmcCN1XVHe3QV4GDq2orYB7dfaGNs117A80PgH3a8U8Dn6uqLYFfjjLPvklmJZl13/2/H8clSZIkSZKmmtEW5zwFOCXJocBpVXXDkgtryaiquUlm0FVbfHtI8+rAV9pjEQX0KhCeAxzVd/5or42dD1xMlwxYsapu7V/yAvhYkucADwHrA+sAtwOHA1fRJTf274t3m1HmesSjIklWHaUvPDKJchzwfuAMYG/gLSOcc2CSvYGnAi9v86wOrFFV/9f6fAU4rW1v0Soq1gBWAXpro+wIvLptfw349+Emq6pjgWMB1l934xrjeiRJkiRJU9Boa1wcBXwZWBN4W98XboCqqndPcGxLypnAJ4Gd6a6151+A86vqlS25ccFCjv914FvAYUOO7wGsDWxbVX9KciuwQmtbk+6L/vLt2H0LMe+feWRFzQpD2v8yZlVd0h4t2RlYtlfhMYzeGhevAL6UZOMxYjgB2K2qrk2yF909/su0Y1+CJEmSJGm6G+1RkXcBT2ufw/1MFV8GPlJV84YcX52HF+vcq+/4hcAbAdraE1uNMf5FwMfpWz+jb/w7WtJiF2CDvrYvAP8MnMQI1Qjj8CvgCUnWTPJY4GVj9P8qcDJw/FgDV9WZwCxgz6q6G/hdkp1a85uAXvXFqsAv23oZ/Y8XXcLDa39MlceOJEmSJEkTYMSKC7p1F25on1NWVf2c9ujHEEfQPSryT3Rre/R8Djg+yQ/o1m2YPcb4RVfRMdRJwP8kmUeXBLgRIMmbgT9V1cltbYxLkzyvqr6fZM4Yj4v0z/unJIcDV9IlYG4c45ST6NbVGJpgGcnhwMlJvgjsCXy+Lb55M93jJtAlX64Aft0+e4+vvLudezDw3+OcT5IkSZI0DaX7Xj1MQ/J94PCqumCJRqRJkWR3YNeqetNkxzKc9dfduN75DwtbfCJJkrR0+NC/7j7ZIUjSpEgyu6pmDtc2WsXFzsDnJyQiDZQknwFeDLxksmORJEmSJKnfaIkLgKe3t148SlVdOAHxaBJU1X6THYMkSZIkScMZK3FxSPsZzrKLORZJkiRJkqRHGCtx8R3gpiURiCRJkiRJ0lBjJS6+XFX/tUQikSRJkiRJGmKZyQ5AkiRJkiRpJCNWXFSVSQ1JkiRJkjSpxnpURBoI667/ON9rLkmSJEnTkOho8YUAAB4jSURBVFUVkiRJkiRpYJm4kCRJkiRJA2vMxEWSFZN8IsmcJDsmOSrJa5dEcJIkSZIkaXobT8XFfwIHAlsCjwWWBd43kUFJkiRJkiTB+BIXrwI+0bc/G3jaxIQjSZIkSZL0sPEkLh4C0re/NXDvxIQjSZIkSZL0sPG8DvVs4D1t+2vAE4HjJiwiaRi/uu0n/McH3zrZYUiSJC0W7/n4FyY7BElaaowncXEAXcXFS4Hlga/gGheSJEmSJGkJGDNxUVW/B/ZeArFIkiRJkiQ9woiJiyRzgYOATw7TXFW19YRFJUmSJEmSxOgVF1sAj2ufkiRJkiRJS9yIiYuq6r1x5NQlFIskSZIkSdIjjPk61CRzkrw3ybpLIiBJkiRJkqSeMRMXwDrAJ4CfJvlukr2SrDLBcUmSJEmSJI0rcbEesAvwOWBT4EvA7RMZlCRJkiRJEowjcVFVBcwCLgWubIdXnMigJEmSJEmSYHxrXJwB/Bo4ia7y4njg+WOcs2ZbG2NOktuT3Na270pyw8IGm2SdJGcluTbJDUm+3Y7vnOSshR13AebfK8nRi2msw5IcNI4+vXt3Q5I3LMQ89y58lOMaf0aSN/btz0xy1ETOKUmSJEmaPkZ7HWrP3wHfpktc/E9V/XGsE6rqN8A20H35Bu6tqk8mmQEsSoLhcOA7VfXpNvZWizDW0uLIdu82AWYn+UZV/Wmyg+ozA3gjcDJAVc2iq9CRJEmSJGmRjWeNiycCrwFuADZOsuwizrlski8muT7JeUlWBEiycZJzksxOclGSTYc5d13g572dqprb17ZKkm8kuTHJSUnSxj0kyVVJrktybDpPSDK7tW+dpJI8pe3/OMlKSV7Tzrk2yYV986zX4rwpyRG9g0k+l2RWu66P9B2/NclHklydZN5w15XkLUn+t3cvhlNVNwH3A48b7X4l2TDJZW2ujw6Z533tXsztxdgqJm5MckKSH7V79/wkl7Rr3L71OyzJ19rYNyV5Sxv234CdWlXIgf3VL0ken+SMNt/lvURTG+vLSS5IcnOS/Ue6bkmSJEnS9DaexMW6wA+A69rPDUmevghzbgIcU1WbA3cBr27HjwX2q6ptgYOAzw5z7jHAl5Kcn+TDSdbra3sGcACwGbARsGM7fnRVbVdVW9CtzfGyqroDWCHJasBOdBUCOyXZALijqu4HDgFeVFVbA6/om2cb4HXAlsDrkjy5Hf9wVc0EtgKeO6Qa5M6qeibdAqePeDwkybuAlwG7VdUDI920JM8Ebmqxj3a/Pg18rqq2BH7Zd/4L6e799u0atk3ynNb8V8Cn6BZf3ZSuguLZbdwP9YWxFfA84FnAIe3+fwC4qKq2qaojh4T9EeCaqtqqjfPVvrZNgRe1eA5Nsvww17xvSwbNuu/+P4x0ayRJkiRJU9h4EhfH0CUvTmk/6wKfWYQ5b6mqOW17NjAj3etVdwBOSzIH+EKb5xGq6ly6pMQX6b74XpNk7dZ8ZVX9vKoeAubQPcIAsEuSK5LMo/vSvXk7fildcuM5wMfa507ARa39EuCEVlnQX2Xyvaq6u6r+QFeFskE7/tokVwPXtDk26zvn9P7r7Tv+ZuDFwO5V9eAI9+vAJNcDVwD/CjDG/dqR7t8J4Gt947yw/VwDXE13/zZpbbdU1bx2765v11jAvCHx/ndVPVBVdwLn0yUdRvPsXgxV9X1gzZYsAji7qh5sY91B99rdR6iqY6tqZlXNXHmlFcaYSpIkSZI0FY1njYuZwAer6mj4S4XAxxZhzv4v6PPpqiCWAe6qqm3GOrmqfku3nsLJ7ZGE5wC/GWbc5ZKsQFeJMLOqfpZuvY3eN+AL6RIVGwD/DRwMFHB2m+dtSf4aeCnd2hLbjhD/ckk2pKtO2K6qfpfkhL55+s+ZzyPv+Ty66ocnAbeMcMm9NS5eQVdtsjFj368a5liAj1fVFx5xsFt3pP+aHurbf2hIvEPHHW6e8XrUfVyEsSRJkiRJU9R4Ki5+Czw/yUZJNgJeQJcoWGyq6vfALUleA9DWodh6aL8kz0uyUtteFdgY+OkoQ/eSB3e2KoXd+9ouAv6e7vGLh+iu8yXAxW38javqiqo6hO6tKk9mZKsB9wF3J1mHropiPK4B3gqcOeSxl0epqjPpHmnZc4z7dQnw+ra9R98Q5wL/0O4DSdZP8oRxxtmza5IVkqwJ7AxcBdwDrDpC/4t6MSTZme6Rmd8v4JySJEmSpGlsPImL4+jWeLip/byM7lGNxW0PYJ8k19I9rrDrMH22BWYlmQtcBhxXVVeNNGBV3dVivY7ui/tVfW230lUh9BbevJiuiuF3bf8TbYHL6+geK7l2lHmupUtC3EhXDXLJmFf78LkX01VrnJ1krTG6Hw68J8kyjHy/3g28sz0as37fPOe12C5rbd9g5ITDSObSPSJyOfAvVfWLdmx+ukVMDxzS/zC6tTTm0i3iuecCzidJkiRJmubSLWUwRqfkH+iqEYpubYITJjguDZj0vdZ2MuZ/8rpr14F7vWoyppYkSVrs3vPxL4zdSZKmkSSz2wsvHmVc6wpU1ZeBLy/WqCRJkiRJksYwYuIiyfxRzquqcjHFaaSqDpvsGCRJkiRJ089oyYfQPRryC+CuJROOJEmSJEnSw0ZbnPN4ujdlrEX32s73VNWWvZ8lEp0kSZIkSZrWRkxcVNU+wLrAO+heBXpOkluT/N2SCk6SJEmSJE1vo74OtaruA24GbgH+SFd9saCv0JQkSZIkSVooIyYuknw4yU3A94G/AvYD1q2q05ZUcJIkSZIkaXpLVQ3fkDxEtzjnzcAPhjRXVe06wbFJfzFz5syaNWvWZIchSZIkSZoASWZX1czh2sZ6pWmAjdtPv+GzHZIkSZIkSYvRaImLDZdYFJIkSZIkScMYMXFRVT9ZkoFIkiRJkiQNNepbRSRJkiRJkiaTiQtJkiRJkjSwTFxIkiRJkqSBNdZbRaSB8MCv7+Haz14w2WFIkiQttK3fsfNkhyBJSyUrLiRJkiRJ0sAycSFJkiRJkgaWiQtJkiRJkjSwTFxIkiRJkqSBZeJCkiRJkiQNLBMXkiRJkiRpYJm4kCRJkiRJA8vEhSRJkiRJGlgmLhaTJGsmmdN+bk9yW9u+K8kNizDuXkl+neSaJDclOTfJDgsxzmFJDhpvnyQrJPlOksPGOOfwJM9fmLmTrJHkHeMIX5IkSZI0TZm4WEyq6jdVtU1VbQN8HjiybW8DPLSIw59aVc+oqk2AfwNOT/L08Z6cZLkFmSzJY4BvArOr6rDR+lbVIVX13QUZv88agIkLSZIkSdKITFwsGcsm+WKS65Ocl2RFgCQbJzknyewkFyXZdKyBqup84Fhg3zbGW5JcleTaJN9MslI7fkKSzye5Ajiif4x2zv/24hhiOeBU4Kaq+kDrPyPJD0a4hhOS7N62X5LkxnY9RyU5q2/czZJckOTmJPu3Y/8GbNwqUz4x7rspSZIkSZo2TFwsGZsAx1TV5sBdwKvb8WOB/apqW+Ag4LPjHO9qoJfkOL2qtquqrYEfAPv09XsSsENVvad3IMm7gJcBu1XVA8OM/X7gj1V1wDivoTfuCsAXgBe361l7yPmbAi8CtgcOTbI88AHgx61S5X3jvHZJkiRJ0jSyQI8QaKHdUlVz2vZsYEaSVYAdgNOS9Po9dpzjpW97iyQfpXvsYhXg3L6206pqft/+m4Gf0SUt/jTC2BcDOyR5alX9aLRrGHLepsDNVXVL2z+FVhXSnF1VDwIPJrkDWGfUKwSS7NsbY93Hj9ldkiRJkjQFWXGxZDzYtz2fLmG0DHBXb12M9jPedSueQVddAXAC8K6q2hL4CLBCX7/7hpw3jy7h8KRRxr4QOAD43yTrjnENC2KBz6+qY6tqZlXNfNwqqy/gdJIkSZKkqcDExSSpqt8DtyR5DUA6W491XpLn0lUhfLEdWhX4ZXv0Yo8xTr8GeCtwZpL1Rontm8AngXOSrDHmxXR+CGyUZEbbf904zrmHLn5JkiRJkoZl4mJy7QHsk+Ra4Hpg1xH6va4tYPkj4EPAq6uqV3Hxz8AVwCXAjWNNWFUX062ncXaStUbp9zngW8CZPLKKY6T+D9C9IeScJLPpkhJ3j3HOb4BLklzn4pySJEmSpOGkqiY7Bk0RSVapqnvTLdpxDN2bSY5cHGNvvsHT6uSDv7A4hpIkSZoUW79j58kOQZIGVpLZVTVzuDYrLrQ4vSXJHLrqkdXp3jIiSZIkSdJC860iWmxadcViqbCQJEmSJAmsuJAkSZIkSQPMxIUkSZIkSRpYJi4kSZIkSdLAMnEhSZIkSZIGlokLSZIkSZI0sExcSJIkSZKkgeXrULVUWHHtVdn6HTtPdhiSJEmSpCXMigtJkiRJkjSwTFxIkiRJkqSBZeJCkiRJkiQNLBMXkiRJkiRpYJm4kCRJkiRJA8u3imip8Ktf/YpPfepTkx2GJEnSmN773vdOdgiSNKVYcSFJkiRJkgaWiQtJkiRJkjSwTFxIkiRJkqSBZeJCkiRJkiQNLBMXkiRJkiRpYJm4kCRJkiRJA8vEhSRJkiRJGlgmLiRJkiRJ0sAycSFJkiRJkgaWiYspKsmRSQ7o2z83yXF9+59K8p4kZ41w/nFJNhtjjhOS7L4QsR2W5KAFPU+SJEmSNP2YuJi6LgF2AEiyDLAWsHlf+w7AY0Y6uar+sapumNAIJUmSJEkag4mLqetS4Flte3PgOuCeJI9L8ljg6cDVwCpJvpHkxiQnJQlAkguSzGzb97YKjuuTfC/J2kMnS3JIkquSXJfk2L5x9k9yQ5K5Sb7ed8pmbY6bk+w/cbdBkiRJkrQ0M3ExRVXVL4A/J3kKXXXFZcAVdMmMmcA84I/AM4ADgM2AjYAdhxluZWBWVW0O/B9w6DB9jq6q7apqC2BF4GXt+AeAZ1TVVsDb+vpvCrwI2B44NMnyQwdMsm+SWUlm3XfffQt0/ZIkSZKkqcHExdR2KV3Sope4uKxv/5LW58qq+nlVPQTMAWYMM85DwKlt+0Tg2cP02SXJFUnmAc/j4cdS5gInJfl74M99/c+uqger6k7gDmCdoQNW1bFVNbOqZq688srjvWZJkiRJ0hRi4mJq661zsSXdoyKX01Vc7ECX1AB4sK//fGC5cYxb/TtJVgA+C+xeVVsCXwRWaM0vBY4BnglclaQ3/sLMK0mSJEmaZkxcTG2X0j2y8duqml9VvwXWoEteXDrqmY+0DNB7e8gbgYuHtPeSFHcmWaXXty0K+uSqOh84GFgdWGVhLkSSJEmSND35V+6pbR7d20ROHnJslaq6s62fOR73Adsn+Se6xzpe199YVXcl+SJdVcftwFWtaVngxCSrAwGOan0X9nokSZIkSdNMqmrsXprWktxbVZNaKfHkJz+5DjjggMkMQZIkaVze+973TnYIkrTUSTK7qmYO1+ajIpIkSZIkaWCZuNCYJrvaQpIkSZI0fZm4kCRJkiRJA8vEhSRJkiRJGlgmLiRJkiRJ0sAycSFJkiRJkgaWiQtJkiRJkjSwlpvsAKTxWGeddXwnuiRJkiRNQ1ZcSJIkSZKkgWXiQpIkSZIkDSwTF5IkSZIkaWCZuJAkSZIkSQPLxIUkSZIkSRpYJi4kSZIkSdLA8nWoWirce/cvuPCswyY7DEmSJACe87LDJjsESZo2rLiQJEmSJEkDy8SFJEmSJEkaWCYuJEmSJEnSwDJxIUmSJEmSBpaJC0mSJEmSNLBMXEiSJEmSpIFl4kKSJEmSJA0sExeSJEmSJGlgmbhYgpKsmWRO+7k9yW1t+64kNyzi2H+X5MokN7YxT03ylAU4f0aS6/r2T0kyN8mBo5yzW5LN+vYvSDJz4a9CkiRJkqRHWm6yA5hOquo3wDYASQ4D7q2qTyaZAZy1sOMm2QL4DPCKqvpBO/YKYAbw04UY74nAdlX1V2N03Y0u7kVKurQ5l6uqPy/qOJIkSZKkqcWKi8GxbJIvJrk+yXlJVgRIsnGSc5LMTnJRkk2HOfdg4GO9pAVAVZ1ZVRe2MbZJcnmroPhWkse149smuTbJtcA7+8Y7D1i/VW7slOQtSa5qfb+ZZKUkOwCvAD7R+m3czn1Nq/z4UZKd2jzLJvlEG2Nukre24zu3azqTxZD8kCRJkiRNPSYuBscmwDFVtTlwF/DqdvxYYL+q2hY4CPjsMOduDlw9ythfBQ6uqq2AecCh7fjxbeyth/R/BfDjqtqmqi4CTq+q7Vq/HwD7VNWlwJnA+1q/H7dzl6uq7YED+ubZB7i7qrYDtgPekmTD1vZM4N1V9dRR4pckSZIkTVM+KjI4bqmqOW17NjAjySrADsBpSXr9HjvaIEnWBL4HrESX9PgisEZV/V/r8pU23hrt+IXt+NeAF48w7BZJPgqsAawCnDtKCKf3X0PbfiGwVZLd2/7qdImaPwJXVtUtI1zLvsC+AOusvfooU0qSJEmSpioTF4Pjwb7t+cCKdBUxd1XVNmOcez1d5cK1vXU0khxEl2RYHE4Adquqa5PsBew8St/edczn4d+v0FV2PCLhkWRn4L6RBqqqY+mSL2y6yXq1EHFLkiRJkpZyPioywKrq98AtSV4DkM7QxzoAjgA+nOTpfcdWamPcDfyut94E8Cbg/6rqLuCuJM9ux/cYJZRVgV8mWX5Iv3ta21jOBd7ezifJU5OsPI7zJEmSJEnTnImLwbcHsE9bQPN6YNehHapqHvBu4KtJfpjkEuDpwMmty550i2jOpXuryeHt+N7AMUnm0FVFjOSfgSuAS4Ab+45/HXhfkmv6FuccznF0i29e3V65+gWs9pEkSZIkjUOqrMDX4Nt0k/Xq2CP3newwJP3/9u40Vq66jOP491fKllBQKaIoUJGCKBiQhkhUqAiGIIFU9oBKQpBq8IWgCWIiRV8QAjTRhIBFkxKVPWIIoIgCkhC2ElDZCqQsIrKILEX28vhiDul4uXAH2nvm3On3k9z0zNnmOS+ezOTX//8/kiQAdtt3wbBLkKSRkuS2qpoz3jFHXEiSJEmSpM4yuJAkSZIkSZ1lcCFJkiRJkjrL4EKSJEmSJHWWwYUkSZIkSeosgwtJkiRJktRZBheSJEmSJKmzDC4kSZIkSVJnTR92AdIgNthoM3bbd8Gwy5AkSZIktcwRF5IkSZIkqbMMLiRJkiRJUmcZXEiSJEmSpM4yuJAkSZIkSZ1lcCFJkiRJkjrLXxXRlPCPZ5dz3KV/GXYZkiRJLJy3+7BLkKQ1iiMuJEmSJElSZxlcSJIkSZKkzjK4kCRJkiRJnWVwIUmSJEmSOsvgQpIkSZIkdZbBhSRJkiRJ6iyDC0mSJEmS1FkGF5IkSZIkqbMMLiRJkiRJUmcZXIyAJCuS3NH3NyvJnCQ/m+C6WUnufJtjRybZ7B2u/V6Se5v3uzXJ15v91yWZM8H7Lk5y4CDPJkmSJElas00fdgFaLV6qqh3H7HsIWLIK9zwSuBN4bOyBJPOBvYBdqur5JBsC81bhvSRJkiRJGpcjLkZUkrlJLm+2N0lydZK7kvwiycNJZjanrpXknObYH5Os34yGmAP8phlRsf6Y258IfKuqngeoquer6txxanihb/vAJIv7Du+ZZEmS+5LsuxofXZIkSZI0QgwuRsP6fdNELh3n+EnANVX1KeASYIu+Y7OBM5tjzwIHVNUl9EZrHF5VO1bVS2+e3IyumFFVy1ax5lnALsBXgLOTrDf2hCTfbMKNJS89/9wqvp0kSZIkaSpyqshoGG+qSL/P00zlqKo/JHmm79iDVXVHs30bvUChDRdV1RvA/UmWAZ8A7ug/oaoWAYsANt1622qpLkmSJElShzjiQq/0ba9ggjCrmR7yQpKtBrh3f9gwdkTF2CDCYEKSJEmS9BYGF2uGG4CDAZJ8GXj/ANcsB2a8zbFTgDObaSMk2eDNXxUZ44kk2yWZxlsX7zwoybQkHwe2ApYOUJMkSZIkaQ3jVJE1w8nA+Um+BtwIPE4vmNjgHa5ZTG/tiZeAXfvXuQDOaq69NclrwGvAGePc4wTgcuApemtm9L/fI8AtwIbA/Kp6+T08lyRJkiRpxKXKEfqjLsm6wIqqej3JrsBZE6yJ0Tmbbr1tHX7aomGXIUmSxMJ5uw+7BEkaOUluq6o54x1zxMWaYQvgombKxqvA0UOuR5IkSZKkgRhcrAGq6n5gp2HXIUmSJEnSu+XinJIkSZIkqbMMLiRJkiRJUmcZXEiSJEmSpM4yuJAkSZIkSZ1lcCFJkiRJkjrL4EKSJEmSJHWWP4eqKWHz981g4bzdh12GJEmSJKlljriQJEmSJEmdZXAhSZIkSZI6K1U17BqkCSVZDiwddh1SR8wE/j3sIqQOsSeklewHaSX7YWrZsqo2Ge+Aa1xoqlhaVXOGXYTUBUmW2A/SSvaEtJL9IK1kP4wOp4pIkiRJkqTOMriQJEmSJEmdZXChqWLRsAuQOsR+kP6fPSGtZD9IK9kPI8LFOSVJkiRJUmc54kKSJEmSJHWWwYU6JcneSZYmeSDJCeMcXzfJhc3xm5PMar9KqR0D9MNxSe5O8rckf06y5TDqlNowUT/0nXdAkkriKvIaWYP0Q5KDm8+Iu5Kc13aNUpsG+M60RZJrk9zefG/aZxh16r1zqog6I8lawH3AXsCjwK3AYVV1d9853wY+XVXzkxwKzKuqQ4ZSsDSJBuyHLwI3V9WLSb4FzLUfNIoG6YfmvBnAFcA6wLFVtaTtWqXJNuDnw2zgImCPqnomyQer6smhFCxNsgF7YhFwe1WdleSTwJVVNWsY9eq9ccSFumQX4IGqWlZVrwIXAPuPOWd/4Nxm+xLgS0nSYo1SWybsh6q6tqpebF7eBHy05Rqltgzy+QDwE+BU4OU2i5NaNkg/HA2cWVXPABhaaMQN0hMFbNhsbwQ81mJ9Wg0MLtQlHwH+0ff60WbfuOdU1evAc8DGrVQntWuQfuh3FPD7Sa1IGp4J+yHJZ4DNq+qKNguThmCQz4dtgG2S3JDkpiR7t1ad1L5BemIBcESSR4Erge+0U5pWl+nDLkCStGqSHAHMAXYfdi3SMCSZBiwEjhxyKVJXTAdmA3Ppjca7PskOVfXsUKuShucwYHFVnZFkV+BXSbavqjeGXZgG44gLdck/gc37Xn+02TfuOUmm0xvq9XQr1UntGqQfSLIn8ENgv6p6paXapLZN1A8zgO2B65I8BHwWuMwFOjWiBvl8eBS4rKpeq6oH6c3/n91SfVLbBumJo+it+0JV3QisB8xspTqtFgYX6pJbgdlJPpZkHeBQ4LIx51wGfKPZPhC4plxhVqNpwn5IshPwc3qhhfOXNcresR+q6rmqmllVs5rF1m6i1xcuzqlRNMj3pd/RG21Bkpn0po4sa7NIqUWD9MQjwJcAkmxHL7h4qtUqtUoMLtQZzZoVxwJXAfcAF1XVXUl+nGS/5rRfAhsneQA4Dnjbn8STprIB++E0YAPg4iR3JBn7IS2NhAH7QVojDNgPVwFPJ7kbuBb4flU5QlUjacCeOB44OslfgfOBI/3Pz6nFn0OVJEmSJEmd5YgLSZIkSZLUWQYXkiRJkiSpswwuJEmSJElSZxlcSJIkSZKkzjK4kCRJkiRJnWVwIUmSNImSHJRkaZJXkjyZ5JokfgeTJGlAfmhKkiRNkiQzgV8DrwLzgVPfPLQa7j19Ve8hSdJUYHAhSZI0ebYC1gEeAS6tqjOqao+qWpFklyTXJ1nejMT4KkCS/ZP8Pcl/k9yZZP9m/9wkleTKJLcANzX7f5DkweY+VyXZalgPK0nSZEhVDbsGSZKkkZRkBrAMmAm8AdwOnA38FriPXqjxY2AF8CBwD/D35pqFwHH0wo8dgA8D1wKvASfRC0OmA4uBC5vrjgUeq6qd23g+SZLa4BBDSZKkSVJVy5N8Djge2BvYGTgH+BewMXB6VZ3+5vlJjgXWBs6oqnOSFLAI2BO4qznt8qo6pTn/4mbfIc0fwIeSfKCq/jO5TydJUjsMLiRJkiZJkrWB+6vqmOb1ycCPgDkTXFpj/u332Dj7DgeebLanAS+++2olSeomgwtJkqTJ8yngvCQXAA8DuzX77wOeBo5J8gTwOvAQcDW9qSDHJwnw3eb1n+hNFRnrcuBA4BvABfSmlcytqi9M1gNJktQ2F+eUJEmaPI8D99L7RZFFwNbAgqo6H9gH+CuwADgRmFZVS4GD6AUZP6W3LsbBzf63qKpzgROA2cBZwGHA9ZP4PJIktc7FOSVJkiRJUmc54kKSJEmSJHWWwYUkSZIkSeosgwtJkiRJktRZBheSJEmSJKmzDC4kSZIkSVJnGVxIkiRJkqTOMriQJEmSJEmdZXAhSZIkSZI663/ai9asmBFFzgAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 1152x432 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.figure(figsize=(16,6))\n",
    "\n",
    "ax = sns.barplot(x=movies_scored['score'].head(10), y=movies_scored['original_title'].head(10), data=movies_scored, palette='deep')\n",
    "\n",
    "#plt.xlim(3.55, 5.25)\n",
    "plt.title('Best Rated & Most Popular Blend', weight='bold')\n",
    "plt.xlabel('Score', weight='bold')\n",
    "plt.ylabel('Movie Title', weight='bold')\n",
    "\n",
    "plt.savefig('./tmp/scored_movies.png')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Content-Based Filtering\n",
    "\n",
    "Now we will use the characteristics of a movie in order to recommend other movies to the user.\n",
    "\n",
    "### Word Vectorization and TF-IDF"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-14T13:23:03.964818Z",
     "start_time": "2019-07-14T13:23:03.009395Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(4803, 10417)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from sklearn.feature_extraction.text import TfidfVectorizer\n",
    "\n",
    "tfv = TfidfVectorizer(min_df=3, max_features=None, strip_accents='unicode', analyzer='word', token_pattern=r'\\w{1,}',\\\n",
    "                      ngram_range=(1,3), use_idf=1, smooth_idf=1, sublinear_tf=1, stop_words='english')\n",
    "\n",
    "# Filling NaNs with empty string\n",
    "movies_clean['overview'] = movies_clean['overview'].fillna('')\n",
    "\n",
    "# Fitting TF-IDF on the 'overview' text\n",
    "\n",
    "tfv_matrix = tfv.fit_transform(movies_clean['overview'])\n",
    "\n",
    "tfv_matrix.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Calculating Similarity Scores"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-14T13:23:04.276542Z",
     "start_time": "2019-07-14T13:23:03.965926Z"
    }
   },
   "outputs": [],
   "source": [
    "from sklearn.metrics.pairwise import sigmoid_kernel\n",
    "\n",
    "# Compute the sigmoid kernel\n",
    "\n",
    "sig = sigmoid_kernel(tfv_matrix, tfv_matrix)\n",
    "\n",
    "# Reverse mapping of indices and movie titles\n",
    "indices = pd.Series(movies_clean.index, index= movies_clean['original_title']).drop_duplicates()\n",
    "\n",
    "\n",
    "# Credit to Ibtesam Ahmed for the skeleton code\n",
    "def give_rec(title, sig=sig):\n",
    "    # Get the index corresponding to original_title\n",
    "    idx = indices[title]\n",
    "    \n",
    "    # Get the pairwise similarity scores\n",
    "    sig_scores = list(enumerate(sig[idx]))\n",
    "\n",
    "    # Sort the movies\n",
    "    sig_scores = sorted(sig_scores, key=lambda x: x[1], reverse=True)\n",
    "    \n",
    "    # Scores of the 10 most similar movies\n",
    "    sig_scores = sig_scores[1:11]\n",
    "    \n",
    "    # Movie indices\n",
    "    movie_indices = [i[0] for i in sig_scores]\n",
    "    \n",
    "    # Top 10 most similar movies\n",
    "    return movies_clean['original_title'].iloc[movie_indices]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-14T13:23:04.284472Z",
     "start_time": "2019-07-14T13:23:04.277953Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1302    Spy Kids 2: The Island of Lost Dreams\n",
       "1155                  Spy Kids 3-D: Game Over\n",
       "1769      Spy Kids: All the Time in the World\n",
       "3359                              In Too Deep\n",
       "1631                                 Mr. 3000\n",
       "4044                               Go for It!\n",
       "339                           The Incredibles\n",
       "1081                       Revolutionary Road\n",
       "1825                Jimmy Neutron: Boy Genius\n",
       "2441                   Escobar: Paradise Lost\n",
       "Name: original_title, dtype: object"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "give_rec('Spy Kids')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Our recommendation system gave us some picks related to Spy Kids, but a few missteps such as In Too Deep and Escobar: Paradise Lost slipped in."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.8"
  },
  "pycharm": {
   "stem_cell": {
    "cell_type": "raw",
    "metadata": {
     "collapsed": false
    },
    "source": []
   }
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": true
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}