Movie Recommendation.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "972ee2e4",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "from sklearn.feature_extraction.text import TfidfVectorizer\n",
    "from sklearn.feature_extraction.text import CountVectorizer\n",
    "from sklearn.metrics.pairwise import linear_kernel\n",
    "from sklearn.metrics.pairwise import cosine_similarity\n",
    "from ast import literal_eval"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "57e89313",
   "metadata": {},
   "outputs": [],
   "source": [
    "path = \"./Desktop/DataFlair/movie_recommendation\"\n",
    "credits_df = pd.read_csv(path + \"/tmdb_credits.csv\")\n",
    "movies_df = pd.read_csv(path + \"/tmdb_movies.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "a2613d6b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>production_countries</th>\n",
       "      <th>release_date</th>\n",
       "      <th>revenue</th>\n",
       "      <th>runtime</th>\n",
       "      <th>spoken_languages</th>\n",
       "      <th>status</th>\n",
       "      <th>tagline</th>\n",
       "      <th>title</th>\n",
       "      <th>vote_average</th>\n",
       "      <th>vote_count</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>[{\"iso_3166_1\": \"US\", \"name\": \"United States o...</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>Released</td>\n",
       "      <td>Enter the World of Pandora.</td>\n",
       "      <td>Avatar</td>\n",
       "      <td>7.2</td>\n",
       "      <td>11800</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>[{\"iso_3166_1\": \"US\", \"name\": \"United States o...</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>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",
       "    </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>[{\"iso_3166_1\": \"GB\", \"name\": \"United Kingdom\"...</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>Released</td>\n",
       "      <td>A Plan No One Escapes</td>\n",
       "      <td>Spectre</td>\n",
       "      <td>6.3</td>\n",
       "      <td>4466</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>[{\"iso_3166_1\": \"US\", \"name\": \"United States o...</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>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",
       "    </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>[{\"iso_3166_1\": \"US\", \"name\": \"United States o...</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>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",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\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  \\\n",
       "0  [{\"name\": \"Ingenious Film Partners\", \"id\": 289...   \n",
       "1  [{\"name\": \"Walt Disney Pictures\", \"id\": 2}, {\"...   \n",
       "2  [{\"name\": \"Columbia Pictures\", \"id\": 5}, {\"nam...   \n",
       "3  [{\"name\": \"Legendary Pictures\", \"id\": 923}, {\"...   \n",
       "4        [{\"name\": \"Walt Disney Pictures\", \"id\": 2}]   \n",
       "\n",
       "                                production_countries release_date     revenue  \\\n",
       "0  [{\"iso_3166_1\": \"US\", \"name\": \"United States o...   2009-12-10  2787965087   \n",
       "1  [{\"iso_3166_1\": \"US\", \"name\": \"United States o...   2007-05-19   961000000   \n",
       "2  [{\"iso_3166_1\": \"GB\", \"name\": \"United Kingdom\"...   2015-10-26   880674609   \n",
       "3  [{\"iso_3166_1\": \"US\", \"name\": \"United States o...   2012-07-16  1084939099   \n",
       "4  [{\"iso_3166_1\": \"US\", \"name\": \"United States o...   2012-03-07   284139100   \n",
       "\n",
       "   runtime                                   spoken_languages    status  \\\n",
       "0    162.0  [{\"iso_639_1\": \"en\", \"name\": \"English\"}, {\"iso...  Released   \n",
       "1    169.0           [{\"iso_639_1\": \"en\", \"name\": \"English\"}]  Released   \n",
       "2    148.0  [{\"iso_639_1\": \"fr\", \"name\": \"Fran\\u00e7ais\"},...  Released   \n",
       "3    165.0           [{\"iso_639_1\": \"en\", \"name\": \"English\"}]  Released   \n",
       "4    132.0           [{\"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  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  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "906cd76c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>movie_id</th>\n",
       "      <th>title</th>\n",
       "      <th>cast</th>\n",
       "      <th>crew</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>19995</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>285</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>206647</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>49026</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>49529</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",
       "</div>"
      ],
      "text/plain": [
       "   movie_id                                     title  \\\n",
       "0     19995                                    Avatar   \n",
       "1       285  Pirates of the Caribbean: At World's End   \n",
       "2    206647                                   Spectre   \n",
       "3     49026                     The Dark Knight Rises   \n",
       "4     49529                               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...  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "credits_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "c5d62c11",
   "metadata": {},
   "outputs": [],
   "source": [
    "credits_df.columns = ['id','tittle','cast','crew']\n",
    "movies_df = movies_df.merge(credits_df, on=\"id\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "fa04d96d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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</th>\n",
       "      <th>vote_average</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>tittle</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 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",
       "                                     tittle  \\\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": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "02f0fcf9",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "C:  6.092171559442016\n",
      "m:  1838.4000000000015\n",
      "(481, 23)\n"
     ]
    }
   ],
   "source": [
    "# Demographic Filtering\n",
    "C = movies_df[\"vote_average\"].mean()\n",
    "m = movies_df[\"vote_count\"].quantile(0.9)\n",
    "\n",
    "print(\"C: \", C)\n",
    "print(\"m: \", m)\n",
    "\n",
    "new_movies_df = movies_df.copy().loc[movies_df[\"vote_count\"] >= m]\n",
    "print(new_movies_df.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "072d885a",
   "metadata": {},
   "outputs": [],
   "source": [
    "def weighted_rating(x, C=C, m=m):\n",
    "    v = x[\"vote_count\"]\n",
    "    R = x[\"vote_average\"]\n",
    "\n",
    "    return (v/(v + m) * R) + (m/(v + m) * C)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "cb2c7d9d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>vote_average</th>\n",
       "      <th>score</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.059258</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>7.939256</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>7.920020</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>7.904645</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>Inception</td>\n",
       "      <td>13752</td>\n",
       "      <td>8.1</td>\n",
       "      <td>7.863239</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>7.851236</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>Interstellar</td>\n",
       "      <td>10867</td>\n",
       "      <td>8.1</td>\n",
       "      <td>7.809479</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>7.803188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>329</th>\n",
       "      <td>The Lord of the Rings: The Return of the King</td>\n",
       "      <td>8064</td>\n",
       "      <td>8.1</td>\n",
       "      <td>7.727243</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>7.697884</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              title  vote_count  vote_average  \\\n",
       "1881                       The Shawshank Redemption        8205           8.5   \n",
       "662                                      Fight Club        9413           8.3   \n",
       "65                                  The Dark Knight       12002           8.2   \n",
       "3232                                   Pulp Fiction        8428           8.3   \n",
       "96                                        Inception       13752           8.1   \n",
       "3337                                  The Godfather        5893           8.4   \n",
       "95                                     Interstellar       10867           8.1   \n",
       "809                                    Forrest Gump        7927           8.2   \n",
       "329   The Lord of the Rings: The Return of the King        8064           8.1   \n",
       "1990                        The Empire Strikes Back        5879           8.2   \n",
       "\n",
       "         score  \n",
       "1881  8.059258  \n",
       "662   7.939256  \n",
       "65    7.920020  \n",
       "3232  7.904645  \n",
       "96    7.863239  \n",
       "3337  7.851236  \n",
       "95    7.809479  \n",
       "809   7.803188  \n",
       "329   7.727243  \n",
       "1990  7.697884  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_movies_df[\"score\"] = new_movies_df.apply(weighted_rating, axis=1)\n",
    "new_movies_df = new_movies_df.sort_values('score', ascending=False)\n",
    "\n",
    "new_movies_df[[\"title\", \"vote_count\", \"vote_average\", \"score\"]].head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "20ca0c46",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAA74AAAGDCAYAAAAMBcxbAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAABAfElEQVR4nO3deZgeVZn38e8PgrIKCIyoqFFHxbAlGngFAcHdcR9RdBgVx5HREXFjlNERcWfU1wUZ5UUGEY2IiAviwo7sW0hIWMcZwBEBFQRUVoH7/aNOy0PT3elOutNJ8f1cV67Uc+rUOXfVU63cuU9Vp6qQJEmSJKmvVpnuACRJkiRJmkomvpIkSZKkXjPxlSRJkiT1momvJEmSJKnXTHwlSZIkSb1m4itJkiRJ6jUTX0mSpAe5JB9Icsh0xyFJU8XEV5IkPWgk+dPAn3uT3D7webdJmuM1Sc5KcluSU0fYPzvJ/LZ/fpLZkzHvsqiqT1bVP053HJI0VUx8JUnSg0ZVrT30B/hf4KUDbfMmaZrfA18A9h++I8lDgB8C3wTWB74O/LC1S5KmiImvJEl60Evy0CRfSHJt+/OFJA9t+3ZKck1bDnxDkqvHqg5X1YlV9R3g2hF27wTMAL5QVXdW1QFAgGePEtdhSb6c5KetKn1mko1bfDcluTzJnIH+T01yapKbk1yS5GWt/RlJrk+y6kDfVyZZ1Lb3S/LNgX3PaFXrm5NclGSngX27J7kyyR+TXDVZlXJJmkomvpIkSfBB4BnAbGArYBvg3wb2bwxsCDwaeCNwcJKnLMU8mwGLqqoG2ha19tG8psWyIXAncDZwYfv8XeBzAElWA34EHA/8FfAOYF6Sp1TVOcCt3D/B/jvgW8MnS/Jo4MfAx4GHA3sDRyfZKMlawAHAi6pqHWA7YOEEzl+SpoWJryRJEuwGfLSqfltVvwM+Arx+WJ8PtSrtz+kSw9csxTxrA7cMa7sFWGeMY75fVfOr6g7g+8AdVXV4Vd0DHAkMVXyf0cbfv6ruqqqTgWOB17X9RwxtJ1kH+JvWNtzfAz+pqp9U1b1VdQJwQesPcC+weZI1quq6qrpk3GcvSdPExFeSJAkeBfxy4PMvW9uQm6rq1jH2j9efgIcNa3sY8McxjvnNwPbtI3xeu20/CvhVVd07LM5Ht+1vAX/blnD/LXBhVQ2e85DHAa9uy5xvTnIzsD3wyHYNdgXeClyX5MdJNh0jdklaIZj4SpIkdc/jPm7g82O5/zO667dlvqPtH69LgC2TZKBty9a+rK4FHpNk8L/vHgv8GqCqLqVLhF/EKMucm18B36iq9Qb+rFVV+7dxjquq5wGPBC4HvjoJsUvSlDLxlSRJ6pb8/lt7jnVDYF+6Ny8P+kiShyTZAXgJcNRIAyVZNcnqdC+xWiXJ6u35W4BTgXuAvdoLtfZs7SdPwjmcS/cc7/uSrNZeSPVS4NsDfb4F7AXsOFr8dOf90iQvGDqX9oKvTZI8IsnL2j8C3ElXwb5nEmKXpCll4itJktS9yOkCuhdNLaZ7edTHB/ZfD9xEV1WdB7y1qi4fZazX0y1B/gqwQ9v+KkBV3QW8AngDcDPwD8ArWvsyaWO8jK6iewPwZeANw+I8gu7N0idX1Q2jjPMr4OXAB4Df0VWA/4XuvxtXAd5Ldx1+DzwL+OdljV2Splru/1JBSZIkDWqV029W1SbTHIokaSlZ8ZUkSZIk9ZqJryRJkiSp11zqLEmSJEnqNSu+kiRJkqReM/GVJEmSJPXajOkOQFL/bbjhhjVz5szpDkOSJEk9N3/+/BuqaqPh7Sa+kqbczJkzueCCC6Y7DEmSJPVckl+O1O5SZ0mSJElSr5n4SpIkSZJ6zcRXkiRJktRrJr6SJEmSpF4z8ZUkSZIk9ZqJryRJkiSp10x8JUmSJEm9ZuIrSZIkSeo1E19JkiRJUq+Z+EqSJEmSes3EV5IkSZLUaya+kiRJkqRemzHdAUjqv+tvu5v9F9ww3WFIkiRpiu0zZ8PpDmFEVnwlSZIkSb1m4itJkiRJ6jUTX0mSJElSr5n4SpIkSZJ6zcRXkiRJktRrJr6SJEmSpF4z8ZUkSZIk9ZqJryRJkiSp10x8pZVQkkryjYHPM5L8Lsmx7fPLkuyzhDEeleS7Ux2rJEmSNN1mTHcAkpbKrcDmSdaoqtuB5wG/HtpZVccAx4w1QFVdC+wypVFKkiRJKwArvtLK66fAi9v264AjhnYk2T3JgW37sCQHJDkryZVJdmntM5Nc3LZXT/K1JIuTLEiy88A430vysyS/SPLp1r5qG/fidsy7l+N5S5IkSRNixVdaeX0b2Lctb94SOBTYYZS+jwS2BzalqwQPX+L8doCq2iLJpsDxSZ7c9s0G5gB3Alck+RLwV8Cjq2pzgCTrTdI5SZIkSZPOiq+0kqqqRcBMumrvT5bQ/QdVdW9VXQo8YoT92wPfaONeDvwSGEp8T6qqW6rqDuBS4HHAlcATknwpyQuBPwwfMMkeSS5IcsGtN9048ROUJEmSJomJr7RyOwb4LAPLnEdx58B2Rtg/UttIx94DzKiqm4CtgFPpqsWHDD+oqg6uqrlVNXet9TdYQniSJEnS1DHxlVZuhwIfrarFyzjOacBuAG2J82OBK0brnGRDYJWqOhr4EPC0ZZxfkiRJmjI+4yutxKrqGuCLkzDUl4GDkiwG7gZ2r6o7k1ELwY8GvpZk6B/P/nUSYpAkSZKmRKpqumOQ1HObzJpde847cbrDkCRJ0hTbZ86G0zp/kvlVNXd4u0udJUmSJEm9ZuIrSZIkSeo1E19JkiRJUq+Z+EqSJEmSes3EV5IkSZLUaya+kiRJkqReM/GVJEmSJPXajOkOQFL/bbzmjGn/nW6SJEl68LLiK0mSJEnqNRNfSZIkSVKvmfhKkiRJknrNxFeSJEmS1GsmvpIkSZKkXvOtzpKm3PW33c3+C26Y7jAkSdJKxN8IoclkxVeSJEmS1GsmvpIkSZKkXjPxlSRJkiT1momvJEmSJKnXTHwlSZIkSb1m4itJkiRJ6jUTX0mSJElSr5n4SstZkj+No8+7kqw5SfPtlGS7cfTbPcmBbXu/JHtPxvySJEnSdDPxlVZM7wImlPgmWXWUXTsBS0x8l0WSGVM5viRJkrQsTHyladIqsacm+W6Sy5PMS2cv4FHAKUlOaX2fn+TsJBcmOSrJ2q396iT7JjkDeHWSvZJcmmRRkm8nmQm8FXh3koVJdkiyUZKjk5zf/jxzCXG+pfW7qB23Zms/LMnnWoz/PoWXSpIkSVomVmmk6TUH2Ay4FjgTeGZVHZDkPcDOVXVDkg2BfwOeW1W3Jnk/8B7go22MO6pqe4Ak1wKPr6o7k6xXVTcnOQj4U1V9tvX5FvD5qjojyWOB44CnjhHj96rqq+3YjwNvBr7U9j25xXXPZF0QSZIkabKZ+ErT67yqugYgyUJgJnDGsD7PAGYBZyYBeAhw9sD+Iwe2FwHzkvwA+MEocz4XmNXGAnhYknXGiHHzlvCuB6xNlygPOWq0pDfJHsAeAOttvMkYw0uSJElTy8RXml53Dmzfw8g/kwFOqKrXjTLGrQPbLwZ2BF4GfCjJZiP0XwXYtqpuv98k9yXCwx0GvKKqLkqyO90zwyPNfT9VdTBwMMAms2bXaP0kSZKkqeYzvtKK6Y/AUBX2HOCZSf4aIMmaSZ48/IAkqwCPqapTgPdxX4V2cCyA44E9B46bvYRY1gGuS7IasNvSnIwkSZI0nUx8pRXTwcBPk5xSVb8DdgeOSLKILhHedIRjVgW+mWQxsIDuOd6bgR8Brxx6uRWwFzC3vQDrUrqXX43lQ8C5wAnA5ct+apIkSdLylSpXIEqaWpvMml17zjtxusOQJEkrkX3mbDjdIWgllGR+Vc0d3m7FV5IkSZLUaya+kiRJkqReM/GVJEmSJPWaia8kSZIkqddMfCVJkiRJvWbiK0mSJEnqNRNfSZIkSVKvzZjuACT138ZrzvB38UmSJGnaWPGVJEmSJPWaia8kSZIkqddMfCVJkiRJvWbiK0mSJEnqNRNfSZIkSVKv+VZnSVPu+tvuZv8FN0x3GJKkSeTb+iWtTKz4SpIkSZJ6zcRXkiRJktRrJr6SJEmSpF4z8ZUkSZIk9ZqJryRJkiSp10x8JUmSJEm9ZuIrSZIkSeo1E19JkiRJUq+Z+EormCT3JFmY5JIkFyV5T5JJ+VlNsl+SvSdjrIExd09y4GSOKUmSJE2mGdMdgKQHuL2qZgMk+SvgW8C6wIenMyhJkiRpZWXFV1qBVdVvgT2APdNZNclnkpyfZFGSfwJIsnaSk5JcmGRxkpcPjZHkg0muSHIi8JSB9lOTfCHJWUkuTrJNa394kh+08c9JsuVY7ZIkSdKKzoqvtIKrqivbUue/Al4O3FJVWyd5KHBmkuOBXwGvrKo/JNkQOCfJMcDTgNcCc+h+3i8E5g8Mv1ZVbZdkR+BQYHPgI8CCqnpFkmcDhwOzx2gfUZI96JJ21tt4k0m6GpIkSdLEmfhKK4e0v58PbJlkl/Z5XeBJwDXAJ1sCey/waOARwA7A96vqNoCWDA86AqCqTkvysCTrAdsDr2rtJyfZIMm6Y7SPqKoOBg4G2GTW7FqWk5ckSZKWhYmvtIJL8gTgHuC3dAnwO6rquGF9dgc2Ap5eVX9OcjWwets9VtI5fF9xX5I93nZJkiRpheYzvtIKLMlGwEHAgVVVwHHA25Ks1vY/OcladJXf37akd2fgcW2I04BXJlkjyTrAS4dNsWsbZ3u6JdS3tGN2a+07ATdU1R/GaJckSZJWaFZ8pRXPGkkWAqsBdwPfAD7X9h0CzAQuTBLgd8ArgHnAj5JcACwELgeoqguTHNnafgmcPmyum5KcBTwM+IfWth/wtSSLgNuANy6hXZIkSVqhpSsiSXqwSXIqsHdVXTDVc20ya3btOe/EqZ5GkrQc7TNnw+kOQZIeIMn8qpo7vN2lzpIkSZKkXnOps/QgVVU7TXcMkiRJ0vJgxVeSJEmS1GsmvpIkSZKkXjPxlSRJkiT1momvJEmSJKnXfLmVpCm38Zoz/LUXkiRJmjZWfCVJkiRJvWbiK0mSJEnqNRNfSZIkSVKvmfhKkiRJknrNxFeSJEmS1Gu+1VnSlLv+trvZf8EN0x2GJD1o+CZ9Sbo/K76SJEmSpF4z8ZUkSZIk9ZqJryRJkiSp10x8JUmSJEm9ZuIrSZIkSeo1E19JkiRJUq+Z+EqSJEmSes3EV5IkSZLUaya+Wm6SPCLJt5JcmWR+krOTvHKK5topybFt+2VJ9pmKeZYQw6ZJFiZZkOSJw/Z9YGB7ZpKLl3GuFyY5L8nlbc4jkzx2Ccfsl2TvZZlXkiRJWhmY+Gq5SBLgB8BpVfWEqno68Fpgk0kaf9XR9lXVMVW1/2TMM0GvAH5YVXOq6n+G7fvACP2XSpLNgS8Bb6yqTatqNjAPmDlZc0iSJEkrMxNfLS/PBu6qqoOGGqrql1X1JYAkuyc5cGhfkmOT7NS2v5LkgiSXJPnIQJ+rk+yb5Azg1a3qeXn7/LcD/f4ydpKXJjm3VWFPTPKI1r5fkkOTnNoq0nu19rWS/DjJRUkuTrLr8BNLMjvJOUkWJfl+kvWT/A3wLuAfk5wyrP/+wBqtMjuvNa+a5KvtHI9Pskbr+8QkP2sV8tOTbDrCtX0/8Mmqumzg2h5TVae1Md6S5Px2DkcnWXOEcxixT5IfJnlD2/6nJPNaTBcOHPukJPNHiEuSJElaIZj4annZDLhwib1G9sGqmgtsCTwryZYD++6oqu3pqslfBV4K7ABsPMpYZwDPqKo5wLeB9w3s2xR4AbAN8OEkqwEvBK6tqq2qanPgZyOMeTjw/qraElgMfLiqfgIcBHy+qnYe7FxV+wC3V9XsqtqtNT8J+I+q2gy4GXhVaz8YeEerkO8NfHmE+Zd0bb9XVVtX1VbAZcCbJ9BnD2DfJDsA722x/A9wS5LZrc+bgMOGD5hkj/YPFhfcetONY4QnSZIkTS0TX02LJP/Rqovnj6P7a1qFcQFdkjdrYN+R7e9Ngauq6hdVVcA3RxlrE+C4JIuBf2njDflxVd1ZVTcAvwUeQZfIPjfJvyfZoapuGXYe6wLrVdXPW9PXgR3HcU7DXVVVC9v2fGBmkrWB7YCjkiwE/h/wyLEGSbJBqyT/18Dzu5u3avFiYLdh58xYfarqN8C+wCnAe6vq963/IcCb2hLzXYFvDR+wqg6uqrlVNXet9TcY52WQJEmSJp+Jr5aXS4CnDX2oqrcDzwE2ak13c//7cXWAJI+nq3Q+p1VUfzy0r7l1YLvGEceXgAOragvgn4aNdefA9j3AjKr6L+DpdAnwp5LsO445lsYD5qa7Hje3yvDQn6eOcOxfrm1V3die8T0YWLvtPwzYs53zR7j/OTOOPlsANwKPGmg7GngR8BJgflVZ0pUkSdIKy8RXy8vJwOpJ3jbQNvis6dXA7CSrJHkM3XJjgIfRJbe3tOdxXzTK+JcDjx94e/LrRum3LvDrtv3GJQWd5FHAbVX1TeCzDCTvAK0CfFNbCgzweuDnLNmf21LqUVXVH4Crkry6xZIkW43Q9dPAB5MMJsWD13Yd4Lo2326MbMQ+Sbahu+ZzgL3bP0RQVXcAxwFfAb421nlIkiRJ023GdAegB4eqqiSvAD6f5H3A7+gS2ve3LmcCV9FVVi+mPbNaVRclWUBX1byy9Rtp/DuS7AH8OMkNdM/ybj5C1/3olg7/GjgHePwSQt8C+EySe4E/A28boc8bgYPaC6GupHvmdUkOBha1JdwfHKPfbsBXkvwbsBrdc8kXDXaoqsVJ3gkcnmQduurs/wIfbl0+BJwL/JLu+q4zwjwP6JPkoXTPTb+pqq5N8l7g0CTPbsvJ59G9ROz4cZyvJEmSNG3S/ferJE1Me4Z43ar60JL6bjJrdu0578TlEJUkCWCfORtOdwiSNC2SzG8vxr0fK76SJizJ94En0v2aKkmSJGmFZuIracKq6pXTHYMkSZI0Xr7cSpIkSZLUaya+kiRJkqReM/GVJEmSJPWaia8kSZIkqdd8uZWkKbfxmjP81RqSJEmaNlZ8JUmSJEm9ZuIrSZIkSeo1E19JkiRJUq+Z+EqSJEmSes3EV5IkSZLUa77VWdKUu/62u9l/wQ3THYYkTTnfYC9JKyYrvpIkSZKkXjPxlSRJkiT1momvJEmSJKnXTHwlSZIkSb1m4itJkiRJ6jUTX0mSJElSr5n4SpIkSZJ6zcRXkiRJktRrJr5aaSWpJN8Y+Dwjye+SHDvBcU5NMneU9v9NkoG2HyT507JFPmoMVyRZ2P7sMgVz3NPGvjjJj5KsN0njTvr1kCRJkiaTia9WZrcCmydZo31+HvDrSZ7jZuCZAC1RfOQkjz9ot6qa3f58dzwHJFl1AuPf3sbeHPg98PalilKSJElayZj4amX3U+DFbft1wBFDO5Jsk+SsJAva309p7Wsk+XaSRUmOBNZ44LB/8W3gtW37b4HvDYy/dpKTklyYZHGSl7f2rdvYqydZK8klSTaf6IklOWyw8jtUWU2yU5JTknwLWJzkY0neOdDvE0n2WsLwZwOPbv1nJzmnxfz9JOu39rckOT/JRUmOTrJma398krPbvo9N9LwkSZKk5c3EVyu7bwOvTbI6sCVw7sC+y4Edq2oOsC/wydb+NuC2qtoS+ATw9DHGPwnYsVVWXwscObDvDuCVVfU0YGfg/yZJVZ0PHAN8HPg08M2quhggycIx5po3sNR5gyWc9zbAB6tqFvCfwBvb+Ku0OOeNdmA7l+e0GAEOB97frsdi4MOt/XtVtXVVbQVcBry5tX8R+EpVbQ1cv4Q4JUmSpGk3Y7oDkJZFVS1KMpOu2vuTYbvXBb6e5ElAAau19h2BAwaOXzTGFPcAZwC7AmtU1dWDj/wCn0yyI3AvXQX1EXTJ4EeB8+mS479UX6tq9hhz7VZVF/xl8PvmGcl5VXVVG/PqJDcmmdPmX1BVN45wzBot8Z4JzAdOSLIusF5V/bz1+TpwVNvePMnHgfWAtYHjWvszgVe17W8A/z5SgEn2APYAWG/jTcY6F0mSJGlKWfFVHxwDfJaBZc7Nx4BT2jOtLwVWH9hXExj/28CXgO8Ma98N2Ah4ektofzMwx8PpksV1hs07EXfTfkbbC7YeMrDv1mF9DwF2B94EHDrKeLe3OB/XxlrSM76HAXtW1RbAR5jg9auqg6tqblXNXWv9JRWwJUmSpKlj4qs+OBT4aFUtHta+Lve97Gr3gfbT6JJW2rO3Wy5h/NOBT/HAxHpd4LdV9eckO9MllEMOBj5Et+R4xIroOFzNfcuwX859FeuRfB94IbA191VmR1RVt9BVofcGbgNuSrJD2/16YKj6uw5wXZLVaNerOZP7nnsebJckSZJWSCa+WulV1TVV9cURdn0a+FSSM4HBtx9/BVi7LXF+H3DeEsavqvpsVd0wbNc8YG6SC+gSwMsBkrwBuLuqvgXsD2yd5Nlt38IJnNpXgWclOQ/4PzywyjsY413AKcB3quqeJQ1cVQuAi+gS2DcCn2nXYzbdMm3oEvdzgROGzq15J/D2JOfTJf+SJEnSCi1VE1nxKWlF1F5qdSHw6qr6xXTHM9wms2bXnvNOnO4wJGnK7TNnw+kOQZIe1JLMr6q5w9ut+EoruSSzgP8GTloRk15JkiRpuvlWZ2klV1WXAk+Y7jgkSZKkFZUVX0mSJElSr5n4SpIkSZJ6zcRXkiRJktRrJr6SJEmSpF4z8ZUkSZIk9ZpvdZY05TZec4a/21KSJEnTxoqvJEmSJKnXTHwlSZIkSb1m4itJkiRJ6jUTX0mSJElSr5n4SpIkSZJ6zbc6S5py1992N/svuGG6w5CkpeJb6SVp5WfFV5IkSZLUaya+kiRJkqReM/GVJEmSJPWaia8kSZIkqddMfCVJkiRJvWbiK0mSJEnqNRNfSZIkSVKvmfhKSyHJn6ZhzrPG2W+9JDcmSfu8bZJKskn7vG6S3ycZ189/kplJLh5l36lJ5o73HCRJkqTpYOIrTbEkq07GOFW13Tj73QxcDzy1NW0HLGh/AzwDOLeq7l3SWElmTDxSSZIkacVi4istpSQ7JTl24POBSXZv21cn2TfJGcCrk7wlyflJLkpydJI1W79XJ7m4tZ/W2jZLcl6ShUkWJXlSa//TwFzvS7K4Hbf/COGdyX2J7nbA54d9PivJ6km+1sZZkGTnNvbuSY5K8iPg+GHnvEaSb7e4jgTWWMbLKEmSJE05qznS1LmjqrYHSLJBVX21bX8ceDPwJWBf4AVV9esk67Xj3gp8sarmJXkIcL+KcZIXAa8A/k9V3Zbk4SPMfRawI3AI8ATgKOCf2r7tgE8Bbweoqi2SbAocn+TJrc+2wJZV9fskMwfGfRtwW1VtmWRL4MKluC6SJEnScmXFV5o6Rw5sb57k9CSLgd2AzVr7mcBhSd7CfQnu2cAHkrwfeFxV3T5s3OcCX6uq2wCq6vcjzH0msF2SxwNXV9UdQJKsDTwdOA/YHvhGG+Ny4JfAUOJ7wijj7gh8sx2zCFg02skn2SPJBUkuuPWmG0frJkmSJE05E19p6d3N/X+GVh+2/9aB7cOAPatqC+AjQ32r6q3AvwGPARa2yvC3gJcBtwPHJXn2sHED1FiBVdUvgPWBl9Il0gDzgTcBV1XVn9o4o7l1jH1jzj0Qw8FVNbeq5q61/gbjOUSSJEmaEia+0tL7JTAryUOTrAs8Z4y+6wDXJVmNruILQJInVtW5VbUvcAPwmCRPAK6sqgOAY4Ath411PPAPA88Jj7TUGbqE953cl/ieDbyLbhk0wGlDsbQlzo8FrljCOQ8es/kIsUmSJEkrHBNfaYLam47vrKpfAd+hW+47j+7NyaP5EHAucAJw+UD7Z9rLpS6mSyovAnYFLk6yENgUOHxwoKr6GV1CfEHrs/coc55JV0m+oH0+m+5536HE98vAqm359ZHA7lV155gnD18B1k6yCHgf3ZJpSZIkaYWWqnGtWpTUJNkK+GpVbTPdsawsNpk1u/acd+J0hyFJS2WfORtOdwiSpHFKMr+q5g5vt+IrTUCStwJH0D2XK0mSJGkl4K8zkiagqg4CDpruOCRJkiSNnxVfSZIkSVKvmfhKkiRJknrNxFeSJEmS1GsmvpIkSZKkXjPxlSRJkiT1mm91ljTlNl5zhr8HU5IkSdPGiq8kSZIkqddMfCVJkiRJvWbiK0mSJEnqNRNfSZIkSVKvmfhKkiRJknrNtzpLmnLX33Y3+y+4YbrDkFYovulckqTlx4qvJEmSJKnXTHwlSZIkSb1m4itJkiRJ6jUTX0mSJElSr5n4SpIkSZJ6zcRXkiRJktRrJr6SJEmSpF4z8ZUkSZIk9doSE98k9yRZmOTiJEclWTPJ3CQHTGSiJDOT/N3ShzquOXZIckmLd42B9vWS/PPA552SHLuMc72hXZNLklyaZO8JHv+yJPu07cOS7DJCn92THLgscS6NJBu0a7gwyfVJfj3w+clJLl7G8V+U5IIklyW5PMlnJyv2ZYhpoyTnJlmQZIdh+96VZM2Bz39ahnl2SnJLu5aLkpyY5K/avqX+vscT00g/y0sz19LMLUmSJE2n8VR8b6+q2VW1OXAX8NaquqCq9hreMcmMMcaZCUxp4gvsBny2xXv7QPt6wD+PfMjEJXkR8C7g+VW1GfA04JYJHD+jqo6pqv0nK6bJVFU3tms4GzgI+PzA57uWZewkmwMHAn9fVU8FNgeunMDxqy7L/GN4DnB5Vc2pqtOH7XsXMClJYnN6u55bAucDb5/EscfygJ/lZRlsCr8LSZIkaVJNdKnz6cBfD1ZMk+yX5OAkxwOHt8ru6UkubH+2a8fuD+zQKk7vTrJqks8kOb9Vvv6pjffIJKcNVKZ2GB5Ekue0ytziJIcmeWiSfwReA+ybZN6wQ/YHntjG/ExrWzvJd1vFcV6StLGfnuTnSeYnOS7JI0e4Dv8K7F1V1wJU1R1V9dV2/FvaOV2U5Oihqlqr6n4uySnAv49Q3Xtuu27/leQlA+2PSfKzJFck+fDANfj7JOe1c/p/Q0lIkq+0auolST4y0P/qJB9p38niJJuO9iWPw6pJvtrmOD6tup7kiS3W+e1cRprjfcAnqurydu3urqovD1yjv1S+hyqJ7X47Jcm3gMVJ1kry43aNL06ya+u3xO8uyeOSnNTuuZOSPDbJbODTwN/kgasF9gIeBZzSvruh9k+0+c9J8ojWtlH7zs9vf5451kVs99w6wE0j7Htp7qtAnzgwx9pJvta+w0VJXjXsuA2TnJ3kxWPNzX0/y2u1n6Hz21wvb+OM+HM8/LtYwhySJEnSCmHciW+6au6LGPk/dp8OvLyq/g74LfC8qnoasCswtCR6H+6rdH0eeDNwS1VtDWwNvCXJ4+mqwse16uJWwMJhcawOHAbsWlVbADOAt1XVIcAxwL9U1W7D4tsH+J8297+0tjl0lbxZwBOAZyZZDfgSsEtVPR04FPjECOe7OTB/lEv1varauqq2Ai5r5znkycBzq+q9Ixw3E3gW8GLgoHaeANvQVbJnA69Ot8z8qXTX9pntOt3T+gB8sKrmAlsCz0qy5cAcN7Tv5SvA3gBtvENGOZfRPAn4j1btvhkYSr4OBt7Rrt3ewJdHOHasazeWbejObRbwQuDaqtqqVS9/NoHv7kDg8FZtnQccUFULgX2BI4evFqiqA4BrgZ2raufWvBZwTvuOTwPe0tq/SFcd35rumox2XXdIshD4X+C5LdbhzgCeUVVzgG/T/YMBwIfofm62aOdw8tABLTn+MbBvVf14lLmH/yx/EDi5xbwz8JkkazH6zzHc/7sYVZI92j/CXHDrTTeO1VWSJEmaUmMtTR6yRvuPdOiqRP8JbDeszzEDycJqwIGtinYPXbI3kucDWw5U+NalS6jOBw5ticwPWlIy6CnAVVX1X+3z1+mWin5hHOcy6Lyqugagnd9MuiRuc+CErhjHqsB1Exx38yQfp1tevTZw3MC+o6rqnlGO+05V3Qv8IsmVwFC19ISqurHF+T1ge+Buun9sOL/FuQZdogLwmiR70H23j6RL7Be1fd9rf88H/hagqi4A/nGC53jVwPcyH5iZZG26++KoFhPAQyc47ljOq6qr2vZi4LNJ/h04tqpOT7eEejzf3ba0cwe+QVfpnai7gKFnxOcDz2vbzwVmDZz/w5KsU1V/HHb86VX1EoAk728xDF92vAlwZKtaPwQYOvfnAq8d6lRVQ9Xi1YCTgLdX1c9HiXukn+WzgJflvmfUVwceS5fsj/ZzPPhdjKqqDqb7xxA2mTW7ltRfkiRJmirjSXxvb1XFvxj4D/shtw5svxv4DV21dhXgjlHGDV118LgH7Eh2pKt8fiPJZ6rq8GHHTYY7B7bvobsWAS6pqm2XcOwldInnySPsOwx4RVVdlGR3YKeBfbeO0H/I8MSgxmgP8PWq+tfBHa1ivjewdVXdlOQwukRmyNA5D53v0hp+7dag+65vHn6vjGDo2l00wr672zhDy4AfMrDvL9euqv4rydOBvwE+lW6Z/fcZ33c33NIkZH+uqqHjBq/lKsC2w54vX5JjgKNHaP8S8LmqOibJTsB+rT2MHPPddEn4C4DREt+RfpYDvKqqrhjWvh+j/xyPdR9LkiRJK5yp+HVG6wLXterl6+kqbwB/pHuecchxwNtaZZd0bwteK8njgN+2Z2b/k+7FUYMup6sw/nX7/HpG/w/9IcPnHs0VwEZJtm0xrZZksxH6fQr4dJKNW7+HtmdBafNc185r+JLrsbw6ySpJnki39HooEXlekoe3505fAZxJV9nbJfe9Dfjh7bo9jC4puaUte33RBOZfJlX1B+CqJK9uMSXJViN0/QzwgSRPbv1WSfKetu9quqQY4OV0VcwHSPIo4Laq+ibwWbp7ZLzf3VncVzHdjW5J8ZKM9/45HthzIM7Z4zhme+B/RmhfF/h1237jGHOs3zYL+Adg07S3hY/TccA7WgJMkjkD84/0cyxJkiStdKYi8f0y8MYk59AtjxyqDi0C7k73QqB30z3/eClwYbpfj/P/6CpnOwELkyyge07yi4ODV9UdwJvoltQuBu6le/PwqNpS4TPTvQjpM2P0uwvYhe7lUxfRPV88fFk3VfUT4D+AE5NcQldpG6r6fQg4FziBLkkfryvoEvif0r05e6jCdgbdktyFwNHtjdqXAv8GHJ9kUZvrkVV1EbCArqp6KF2SPKalfMZ3NLsBb27X7hK65PV+qmoR3bPVRyS5DLiYbkk2wFfpnks+D/g/jF5Z3AI4ry3b/SDw8fF+d8BewJvadXs98M5xnNfBwE8z8HKrUewFzE330qlLGf2tyUMvebuoxTDSM9/70d3jpwM3DLR/HFi/3csX0T2XC0BbRv9aYOcM/PquJfgY3T8wLGo/hx9r7aP9HEuSJEkrndy3YlOSpsYms2bXnvNOnO4wpBXKPnM2nO4QJEnqnSTz28t+72cqKr6SJEmSJK0wTHwlSZIkSb1m4itJkiRJ6jUTX0mSJElSr5n4SpIkSZJ6zcRXkiRJktRrM5bcRZKWzcZrzvBXt0iSJGnaWPGVJEmSJPWaia8kSZIkqddMfCVJkiRJvWbiK0mSJEnqNRNfSZIkSVKv+VZnSVPu+tvuZv8FN0x3GNIy8c3kkiStvKz4SpIkSZJ6zcRXkiRJktRrJr6SJEmSpF4z8ZUkSZIk9ZqJryRJkiSp10x8JUmSJEm9ZuIrSZIkSeo1E19JkiRJUq+Z+D4IJLknycIklyS5KMl7kkzrd59koyTnJlmQZIdh+96VZM2Bz39ahnl2SnJLm+eyJB8eaD926c9g1PnuF/s4j9mhfTcLk6wx0L5ekn8e+DwpMbd74IhlHUeSJElaWZj4PjjcXlWzq2oz4HnA3wAfnuaYngNcXlVzqur0YfveBUwoeVyC06tqDjAX+PskT5/EsYd7FxOPfTfgs+07un2gfT3gn0c+ZOkkeSrdz/2OSdaazLElSZKkFZWJ74NMVf0W2APYM52ZSU5PcmH7sx1Aki8neVnb/n6SQ9v2m5N8vB13WZKvtmrl8YPVyiFJHpfkpCSL2t+PTTIb+DTwNyNUOfcCHgWckuSUgfZPtErlOUke0do2SnJ0kvPbn2cu4dxvBeYDTxwW4zZJzmpV4bOSPKW1757ke0l+luQXST49cMzzk5zdrtlRSdYeLfaBY57T5lic5NAkD03yj8BrgH2TzBt2yP7AE9s1+kxrWzvJd5NcnmRekrSxn57k50nmJzkuySNHuQx/B3wDOB542UBspyb5Qjv/i5Ns09rXarGe32J/eWvfLMl5LbZFSZ401rWXJEmSppOJ74NQVV1J993/FfBb4HlV9TRgV+CA1u00YGgJ8qOBWW17e2CoQvsk4D9aJflm4FUjTHcgcHhVbQnMAw6oqoXAvsCRw6ucVXUAcC2wc1Xt3JrXAs6pqq1aXG9p7V8EPl9VW7e5DxnrvJNsADwDuGTYrsuBHVtVeF/gkwP7ZtNdly2AXZM8JsmGwL8Bz23X7QLgPaPEPjT36sBhwK5VtQUwA3hbVR0CHAP8S1XtNiyufYD/adfoX1rbHLqq8izgCcAzk6wGfAnYpaqeDhwKfGKUy7ArcCRwBPC6YfvWqqrt6KrMh7a2DwInt2u8M/CZVil+K/DFqppNV0m/ZvhESfZIckGSC2696cZRwpEkSZKm3ozpDkDTJu3v1YADWxX2HuDJrf104F1JZgGXAuu3KuK2wF7ABsBVLYmFrpI6c4R5tgX+tm1/g67SO1F3AUPPts6nW64N8FxgVit6AjwsyTpV9cdhx++QZAFwL7B/VV2SZKeB/esCX29Vy6K7JkNOqqpbAJJcCjyObgnyLODMNvdDgLOXcA5Pobte/9U+fx14O/CFJRw33HlVdU2LZyHdNb8Z2Bw4ocWzKnDd8AOTbA38rqp+meQa4NAk61fVTa3LEQBVdVqShyVZD3g+8LIke7c+qwOPbef7wSSbAN+rql8Mn6+qDgYOBthk1uya4HlKkiRJk8bE90EoyRPoktzf0j3r+xtgK7oq8B0AVfXrJOsDL6Srsj6cbknun6rqj616eufAsPcAD1jqPIKlSYD+XFVDx93DffftKsC2w56LHcnpVfWSMfZ/DDilql6ZZCZw6sC+4ec4g+4fDU6oquEV07FkyV3GZbR4LqmqbZdw7OuATZNc3T4/jPtXyod/N9XGflVVXTFs32VJzgVeDByX5B+r6uQJnYkkSZK0nLjU+UEmyUbAQcCBLZlcF7iuqu4FXk9XLRxyNt2y2tPoKsB7c98y5/E6C3ht294NOGMcx/wRWGcc/Y4H9hz60KrWS2Nd4Ndte/dx9D+HbonxX7d510wyVCkfLfbLgZlDx9Bd658vYZ7xXocrgI2SbNviWS3JZoMd0r3F+9XAllU1s6pmAi/n/sudd219twduaZXu44B3DDxLPKf9/QTgyra8+xhgy3HEKUmSJE0LE98HhzXaS4guAU6kSxg/0vZ9GXhjknPoljnfOnDc6cCMqvpv4EK6qu9EE9+9gDclWUSX7L1zHMccDPx0pBdEjTD23PZypUvpnjtdGp8GPpXkTO6f+I+oqn5HlyAf0c7rHGDTsWKvqjuANwFHJVlMt+z6oCXMcyPdcuqLB15uNVK/u4BdgH9PchGwENhuWLcdgV9X1a8H2k6jWyo+9CKsm5Kc1eJ6c2v7GN3S70VJLm6foUuSL27LrTcFDh/rXCRJkqTplPtWkEp6sEpyKrB3VV0wFeNvMmt27TnvxKkYWlpu9pmz4XSHIEmSliDJ/KqaO7zdiq8kSZIkqdd8uZUkqmqn6Y5BkiRJmipWfCVJkiRJvWbiK0mSJEnqNRNfSZIkSVKvmfhKkiRJknrNl1tJmnIbrznDXwUjSZKkaWPFV5IkSZLUaya+kiRJkqReM/GVJEmSJPWaia8kSZIkqddMfCVJkiRJvWbiK0mSJEnqNX+dkaQpd/1td7P/ghumOwz1jL8iS5IkjZcVX0mSJElSr5n4SpIkSZJ6zcRXkiRJktRrJr6SJEmSpF4z8ZUkSZIk9ZqJryRJkiSp10x8JUmSJEm9ZuK7FJJskGRh+3N9kl+37ZuTXLoM4+6e5MBhbacmmbvsUU+OJC9Mcl6Sy9s5H5nksdMd15AkM5NUko8NtG2Y5M/Dr+0Exrt4hPa5SQ5Yhjg/muS5S3v8OOe4OsniJBclOT7JxhM4dmaSvxtj/8/a/X7s5EQrSZIkTR0T36VQVTdW1eyqmg0cBHy+bc8G7p3G0CZVkhnDPm8OfAl4Y1Vt2s55HjBz+Uc3piuBlwx8fjVwyWROUFUXVNVey3D8vlV14mTGNIqdq2or4ALgA+M5oH3vM4FRE1/gM8Drlzk6SZIkaTkw8Z18qyb5apJLWpVtDYAkT2xVsvlJTk+y6UQHTvKnge1dkhzWtg9LckCSs5JcmWSX1r5Kki+3WI5N8pOBfU9P8vMWz3FJHtnaT03yySQ/B945LIT3A5+sqsuGGqrqmKo6rR37liTntwrj0UnWHIjvK0lOafE9K8mhSS4bOofW7/lJzk5yYZKjkqzd2vdPcmmSRUk+O45LdTtw2UClfFfgOwPzPC7JSW28k4Yq1kkekeT7Lf6Lkmw37Po/IcmCJFsn2Wmo2plkv3Y+p7bz22vgmA+16vgJSY5IsvfANRn6LvZt1+3iJAen88QkFw6M86Qk88dx7qM5DfjrJNu0+2RB+/spbfzd2zX/EXA8sD+wQ7qq/ruHD1ZVJwF/XIZ4JEmSpOXGxHfyPQn4j6raDLgZeFVrPxh4R1U9Hdgb+PIox++a+5ZRLwTGu8z5kcD2dJXO/Vvb39JV7rYA/hHYFiDJanSV211aPIcCnxgYa72qelZV/d9hc2wGXMjovldVW7cK42XAmwf2rQ88G3g38CPg8228LZLMTrIh8G/Ac6vqaXQVyvckeTjwSmCzqtoS+Hg7h5cl+egYsXwbeG2STYB7gGsH9h0IHN7GmwcMLVk+APh5i/9pDFSJW4J4NPCmqjp/hPk2BV4AbAN8OMlqLfF+FTCH7rsY7bs8sF23zYE1gJdU1f8AtySZ3fq8CThsjPNdkpcAi4HLgR2rag6wL/DJgT7b0lXznw3sA5zeVjZ8fhnmlSRJkqbdjCV30QRdVVUL2/Z8YGarXG4HHJVkqN9DRzn+yKrac+hDklPHOe8Pqupe4NIkj2ht2wNHtfbrk5zS2p8CbA6c0OJZFbhuMIYlTZZkA+AkYE3g4Kr6LLB5ko8D6wFrA8cNHPKjqqoki4HfVNXiNs4ldMn5JsAs4MwW00OAs4E/AHcAhyT5MXAsdJVm4JgxQvwZ8DHgNyOcz7Z0iSjAN4BPt+1nA29o499Dl3iuD2wE/BB4VVWNtmT6x1V1J3Bnkt8Cj6C7/j+sqtvbuf5olGN3TvI+umv5cLqE+0fAIcCbkryHrmq9zRjnO5pTktwDLKL7h4V1ga8neRJQwGoDfU+oqt8vxRwjSrIHsAfAehtvMlnDSpIkSRNm4jv57hzYvoeugrcKcHN7JnZZ1MD26mPMm2F/DxfgkqradpT9t47SfgldJfSiqroRmN2W7q7d9h8GvKKqLkqyO7DTCPHdOyzWe+nuw3voEq/XPSDYZBvgOcBrgT3pEtQxVdVdbWnwe+kqyy8dq/sShrsF+BXwTEZ/Vnj49z6D0a//XyRZna76P7eqfpVkP+77bo8GPgycDMxv13zw2MfQJcgAB1XVQSNMsXNV3TBwzBeAU6rqlUlmAqcO9B3te18qVXUw3UoHNpk1e0nXWJIkSZoyLnVeDqrqD8BVSV4N0J7h3GophvpNkqcmWYVu+e+SnAG8Kt2zvo/gvkT0CmCjJH9Z+pxks3GM92ngg0meOtC25sD2OsB1bSn1buMYb9A5wDOT/HWLac0kT27V8nWr6ifAu+heIDZe/xd4//CEETiLLommxXlG2z4JeFubf9UkD2vtdwGvAN6QMd50PIIzgJcmWb2dx4tH6DOU5N7Q+uwytKOq7qCrmn8F+NrwA6vqV0MvWRsl6R3JusCv2/buY/T7I933KUmSJK30THyXn92ANye5iK5q+PKlGGMfuqW+J3P/pcmjORq4BrgY+H/AucAtVXUXXYL17y2ehXRLscfUlie/Ezi8vbDpTOCpwLdalw+1OU6ge5Z03Krqd3SJ2BFJFtElwpvSJV/Htraf0z0jPJ5nfKmqS6rq6yPs2otuCfEiujcTD73E6510y44X0y1T/8s/BlTVrXTPyb47ybi+u/Ys8DHARcD36J5bvuX+Xepm4Kt0z9/+ABj+/PA8uor08eOZcxw+DXyqfXerjtFvEXB3upd8PeDlVklOB44CnpPkmiQvmKT4JEmSpEmXKlcg9lmStavqT+2Z3POAZ1bV9dMd14PFwPVfk+7NyntU1YXted/PVdUpSzh+b7qK94eWR7xTZZNZs2vPecvjtzfpwWSfORtOdwiSJGkFk2R+VT3gpbI+49t/xyZZj+5lUR8z6V3uDk4yi25J89db0nso3RLxM8Y6MMn3gScyjmeaJUmSJI3OxLfnqmqn6Y7hwayqHvBMcFX9wziPHc9z3JIkSZKWwGd8JUmSJEm9ZuIrSZIkSeo1E19JkiRJUq+Z+EqSJEmSes3EV5IkSZLUa77VWdKU23jNGf7OVUmSJE0bK76SJEmSpF4z8ZUkSZIk9ZqJryRJkiSp10x8JUmSJEm9ZuIrSZIkSeo13+osacpdf9vd7L/ghukOQz3hG8IlSdJEWfGVJEmSJPWaia8kSZIkqddMfCVJkiRJvWbiK0mSJEnqNRNfSZIkSVKvmfhKkiRJknrNxFeSJEmS1GsmvtI0SnJPkoVJLkpyYZLtWvujknx3gmOdmmTuwOeZSS6e7Jjb2I9NcnySy5JcmmTmVMwjSZIkTYYZ0x2A9CB3e1XNBkjyAuBTwLOq6lpgl+UZSJJVq+qecXY/HPhEVZ2QZG3g3ikMTZIkSVomVnylFcfDgJvg/tXaJGsm+U6SRUmOTHLuYGV3PJKsmuQzSc5v4/xTa98pySlJvgUsTrJ6kq8lWZxkQZKdRxhrFjCjqk4AqKo/VdVty3jukiRJ0pSx4itNrzWSLARWBx4JPHuEPv8M3FRVWybZHFg4xnjzktzeth/CfZXYNwO3VNXWSR4KnJnk+LZvG2DzqroqyXsBqmqLJJsCxyd5clXdMTDHk4Gbk3wPeDxwIrDPBKrFkiRJ0nJlxVeaXrdX1eyq2hR4IXB4kgzrsz3wbYCquhhYNMZ4u7XxZgN/M9D+fOANLck+F9gAeFLbd15VXTUw1zfaXJcDv6RLdAfNAHYA9ga2Bp4A7D48kCR7JLkgyQW33nTjGCFLkiRJU8vEV1pBVNXZwIbARsN2DU+El0aAdwwlxVX1+KoaqvjeOsG5rgEWVNWVVXU38APgacM7VdXBVTW3quautf4Gyxq/JEmStNRMfKUVRFtavCowvDx6BvCa1mcWsMVSDH8c8LYkq7VxnpxkrRH6nQbsNtQHeCxwxbA+5wPrJxlK0J8NXLoUMUmSJEnLhc/4StNr6Blf6Kqtb6yqe4atdv4y8PUki4AFdEudb5ngPIcAM4EL21Lq3wGvGKHfl4GDkiwG7gZ2r6o7Bzu0+PYGTmpjzQe+OsF4JEmSpOUmVTXdMUgaQ5JVgdWq6o4kTwROAp5cVXdNc2jjtsms2bXnvBOnOwz1xD5zNpzuECRJ0goqyfyqesBvQLHiK6341gROacuUA7xtZUp6JUmSpOlm4iut4Krqj8CEfm+vJEmSpPv4citJkiRJUq+Z+EqSJEmSes3EV5IkSZLUaya+kiRJkqReM/GVJEmSJPWab3WWNOU2XnOGv3tVkiRJ08aKryRJkiSp10x8JUmSJEm9ZuIrSZIkSeo1E19JkiRJUq+Z+EqSJEmSes3EV5IkSZLUaya+kiRJkqReM/GVJEmSJPWaia8kSZIkqddMfCVJkiRJvWbiK0mSJEnqNRNfSZIkSVKvmfhKkiRJknrNxFeSJEmS1GupqumOQVLPJfkjcMV0x6GV3obADdMdhFZq3kOaDN5HmgzeR1PncVW10fDGGdMRiaQHnSuqau50B6GVW5ILvI+0LLyHNBm8jzQZvI+WP5c6S5IkSZJ6zcRXkiRJktRrJr6SloeDpzsA9YL3kZaV95Amg/eRJoP30XLmy60kSZIkSb1mxVeSJEmS1GsmvpKmVJIXJrkiyX8n2We649GKKcljkpyS5LIklyR5Z2t/eJITkvyi/b3+wDH/2u6rK5K8YPqi14okyapJFiQ5tn32HtKEJFkvyXeTXN7+N2lb7yNNVJJ3t/8/uzjJEUlW9z6aXia+kqZMklWB/wBeBMwCXpdk1vRGpRXU3cB7q+qpwDOAt7d7ZR/gpKp6EnBS+0zb91pgM+CFwJfb/Sa9E7hs4LP3kCbqi8DPqmpTYCu6+8n7SOOW5NHAXsDcqtocWJXuPvE+mkYmvpKm0jbAf1fVlVV1F/Bt4OXTHJNWQFV1XVVd2Lb/SPcfmo+mu1++3rp9HXhF23458O2qurOqrgL+m+5+04NYkk2AFwOHDDR7D2nckjwM2BH4T4Cququqbsb7SBM3A1gjyQxgTeBavI+mlYmvpKn0aOBXA5+vaW3SqJLMBOYA5wKPqKrroEuOgb9q3by3NJIvAO8D7h1o8x7SRDwB+B3wtbZk/pAka+F9pAmoql8DnwX+F7gOuKWqjsf7aFqZ+EqaShmhzVfJa1RJ1gaOBt5VVX8Yq+sIbd5bD2JJXgL8tqrmj/eQEdq8hzQDeBrwlaqaA9xKW446Cu8jPUB7dvflwOOBRwFrJfn7sQ4Zoc37aJKZ+EqaStcAjxn4vAndUh/pAZKsRpf0zquq77Xm3yR5ZNv/SOC3rd17S8M9E3hZkqvpHqt4dpJv4j2kibkGuKaqzm2fv0uXCHsfaSKeC1xVVb+rqj8D3wO2w/toWpn4SppK5wNPSvL4JA+he3HDMdMck1ZASUL3TN1lVfW5gV3HAG9s228EfjjQ/tokD03yeOBJwHnLK16teKrqX6tqk6qaSfe/NSdX1d/jPaQJqKrrgV8leUpreg5wKd5Hmpj/BZ6RZM32/2/PoXt3hffRNJox3QFI6q+qujvJnsBxdG80PLSqLpnmsLRieibwemBxkoWt7QPA/sB3kryZ7j8kXg1QVZck+Q7df5DeDby9qu5Z7lFrZeA9pIl6BzCv/YPtlcCb6IpF3kcal6o6N8l3gQvp7osFwMHA2ngfTZtUuXxckiRJktRfLnWWJEmSJPWaia8kSZIkqddMfCVJkiRJvWbiK0mSJEnqNRNfSZIkSVKvmfhKkiQthST3JFmY5OIkRyVZc5LHPzXJ3Ake89Ekz23b75rsmCRpZWXiK0mStHRur6rZVbU5cBfw1ukMJsmqVbVvVZ3Ymt4FmPhKEia+kiRJk+F04K+TPDzJD5IsSnJOki0BkuyX5BtJTk7yiyRvae07JTl2aJAkBybZffjgSb6S5IIklyT5yED71Un2TXIG8OokhyXZJclewKOAU5KckuTNST4/cNxbknxuyq6GJK1gZkx3AJIkSSuzJDOAFwE/Az4CLKiqVyR5NnA4MLt13RJ4BrAWsCDJjycwzQer6vdJVgVOSrJlVS1q++6oqu1bLC8EqKoDkrwH2LmqbkiyFrAoyfuq6s/Am4B/WpbzlqSViRVfSZKkpbNGkoXABcD/Av8JbA98A6CqTgY2SLJu6//Dqrq9qm4ATgG2mcBcr0lyIbAA2AyYNbDvyCUdXFW3AicDL0myKbBaVS2ewPyStFKz4itJkrR0bq+q2YMNSTJCvxr292D73dy/ELH68IOTPB7YG9i6qm5KctiwfreOM95DgA8AlwNfG+cxktQLVnwlSZImz2nAbtA9vwvcUFV/aPtenmT1JBsAOwHnA78EZiV5aKsMP2eEMR9Gl9zekuQRdMuqx+OPwDpDH6rqXOAxwN8BR0zstCRp5WbFV5IkafLsB3wtySLgNuCNA/vOA34MPBb4WFVdC5DkO8Ai4Bd0S5nvp6ouSrIAuAS4EjhznLEcDPw0yXVVtXNr+w4wu6pumuiJSdLKLFXDV91IkiRpMiXZD/hTVX12muM4Fvh8VZ00nXFI0vLmUmdJkqSeS7Jekv+iey7ZpFfSg44VX0mSJElSr1nxlSRJkiT1momvJEmSJKnXTHwlSZIkSb1m4itJkiRJ6jUTX0mSJElSr5n4SpIkSZJ67f8DnMfsywlD1zIAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 864x432 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Plot top 10 movies\n",
    "def plot():\n",
    "    popularity = movies_df.sort_values(\"popularity\", ascending=False)\n",
    "    plt.figure(figsize=(12, 6))\n",
    "    plt.barh(popularity[\"title\"].head(10), popularity[\"popularity\"].head(10), align=\"center\", color=\"skyblue\")\n",
    "    plt.gca().invert_yaxis()\n",
    "    plt.title(\"Top 10 movies\")\n",
    "    plt.xlabel(\"Popularity\")\n",
    "    plt.show()\n",
    "    \n",
    "\n",
    "plot()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "24ddc5ae",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0    In the 22nd century, a paraplegic Marine is di...\n",
      "1    Captain Barbossa, long believed to be dead, ha...\n",
      "2    A cryptic message from Bond’s past sends him o...\n",
      "3    Following the death of District Attorney Harve...\n",
      "4    John Carter is a war-weary, former military ca...\n",
      "Name: overview, dtype: object\n"
     ]
    }
   ],
   "source": [
    "# Content based Filtering\n",
    "print(movies_df[\"overview\"].head(5))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "429aa994",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(4803, 20978)\n"
     ]
    }
   ],
   "source": [
    "tfidf = TfidfVectorizer(stop_words=\"english\")\n",
    "movies_df[\"overview\"] = movies_df[\"overview\"].fillna(\"\")\n",
    "\n",
    "tfidf_matrix = tfidf.fit_transform(movies_df[\"overview\"])\n",
    "print(tfidf_matrix.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "e14e0a03",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(4803, 4803)\n",
      "title\n",
      "Avatar                                      0\n",
      "Pirates of the Caribbean: At World's End    1\n",
      "Spectre                                     2\n",
      "The Dark Knight Rises                       3\n",
      "John Carter                                 4\n",
      "dtype: int64\n"
     ]
    }
   ],
   "source": [
    "# Compute similarity\n",
    "cosine_sim = linear_kernel(tfidf_matrix, tfidf_matrix)\n",
    "print(cosine_sim.shape)\n",
    "\n",
    "indices = pd.Series(movies_df.index, index=movies_df[\"title\"]).drop_duplicates()\n",
    "print(indices.head())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "39cdad1c",
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_recommendations(title, cosine_sim=cosine_sim):\n",
    "    \"\"\"\n",
    "    in this function,\n",
    "        we take the cosine score of given movie\n",
    "        sort them based on cosine score (movie_id, cosine_score)\n",
    "        take the next 10 values because the first entry is itself\n",
    "        get those movie indices\n",
    "        map those indices to titles\n",
    "        return title list\n",
    "    \"\"\"\n",
    "    idx = indices[title]\n",
    "    sim_scores = list(enumerate(cosine_sim[idx]))\n",
    "    sim_scores = sorted(sim_scores, key=lambda x: x[1], reverse=True)\n",
    "    sim_scores = sim_scores[1:11]\n",
    "    # (a, b) where a is id of movie, b is sim_score\n",
    "\n",
    "    movies_indices = [ind[0] for ind in sim_scores]\n",
    "    movies = movies_df[\"title\"].iloc[movies_indices]\n",
    "    return movies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "6aaeaee0",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "################ Demographic Filtering #############\n",
      "\n",
      "Recommendations for The Dark Knight Rises\n",
      "65                              The Dark Knight\n",
      "299                              Batman Forever\n",
      "428                              Batman Returns\n",
      "1359                                     Batman\n",
      "3854    Batman: The Dark Knight Returns, Part 2\n",
      "119                               Batman Begins\n",
      "2507                                  Slow Burn\n",
      "9            Batman v Superman: Dawn of Justice\n",
      "1181                                        JFK\n",
      "210                              Batman & Robin\n",
      "Name: title, dtype: object\n",
      "\n",
      "Recommendations for Avengers\n",
      "7               Avengers: Age of Ultron\n",
      "3144                            Plastic\n",
      "1715                            Timecop\n",
      "4124                 This Thing of Ours\n",
      "3311              Thank You for Smoking\n",
      "3033                      The Corruptor\n",
      "588     Wall Street: Money Never Sleeps\n",
      "2136         Team America: World Police\n",
      "1468                       The Fountain\n",
      "1286                        Snowpiercer\n",
      "Name: title, dtype: object\n"
     ]
    }
   ],
   "source": [
    "print(\"################ Demographic Filtering #############\")\n",
    "print()\n",
    "print(\"Recommendations for The Dark Knight Rises\")\n",
    "print(get_recommendations(\"The Dark Knight Rises\"))\n",
    "print()\n",
    "print(\"Recommendations for Avengers\")\n",
    "print(get_recommendations(\"The Avengers\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "317074a0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>cast</th>\n",
       "      <th>crew</th>\n",
       "      <th>keywords</th>\n",
       "      <th>genres</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'cast_id': 242, 'character': 'Jake Sully', '...</td>\n",
       "      <td>[{'credit_id': '52fe48009251416c750aca23', 'de...</td>\n",
       "      <td>[{'id': 1463, 'name': 'culture clash'}, {'id':...</td>\n",
       "      <td>[{'id': 28, 'name': 'Action'}, {'id': 12, 'nam...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>[{'cast_id': 4, 'character': 'Captain Jack Spa...</td>\n",
       "      <td>[{'credit_id': '52fe4232c3a36847f800b579', 'de...</td>\n",
       "      <td>[{'id': 270, 'name': 'ocean'}, {'id': 726, 'na...</td>\n",
       "      <td>[{'id': 12, 'name': 'Adventure'}, {'id': 14, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>[{'cast_id': 1, 'character': 'James Bond', 'cr...</td>\n",
       "      <td>[{'credit_id': '54805967c3a36829b5002c41', 'de...</td>\n",
       "      <td>[{'id': 470, 'name': 'spy'}, {'id': 818, 'name...</td>\n",
       "      <td>[{'id': 28, 'name': 'Action'}, {'id': 12, 'nam...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>[{'cast_id': 2, 'character': 'Bruce Wayne / Ba...</td>\n",
       "      <td>[{'credit_id': '52fe4781c3a36847f81398c3', 'de...</td>\n",
       "      <td>[{'id': 849, 'name': 'dc comics'}, {'id': 853,...</td>\n",
       "      <td>[{'id': 28, 'name': 'Action'}, {'id': 80, 'nam...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>[{'cast_id': 5, 'character': 'John Carter', 'c...</td>\n",
       "      <td>[{'credit_id': '52fe479ac3a36847f813eaa3', 'de...</td>\n",
       "      <td>[{'id': 818, 'name': 'based on novel'}, {'id':...</td>\n",
       "      <td>[{'id': 28, 'name': 'Action'}, {'id': 12, 'nam...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>[{'cast_id': 30, 'character': 'Peter Parker / ...</td>\n",
       "      <td>[{'credit_id': '52fe4252c3a36847f80151a5', 'de...</td>\n",
       "      <td>[{'id': 851, 'name': 'dual identity'}, {'id': ...</td>\n",
       "      <td>[{'id': 14, 'name': 'Fantasy'}, {'id': 28, 'na...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>[{'cast_id': 34, 'character': 'Flynn Rider (vo...</td>\n",
       "      <td>[{'credit_id': '52fe46db9251416c91062101', 'de...</td>\n",
       "      <td>[{'id': 1562, 'name': 'hostage'}, {'id': 2343,...</td>\n",
       "      <td>[{'id': 16, 'name': 'Animation'}, {'id': 10751...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>[{'cast_id': 76, 'character': 'Tony Stark / Ir...</td>\n",
       "      <td>[{'credit_id': '55d5f7d4c3a3683e7e0016eb', 'de...</td>\n",
       "      <td>[{'id': 8828, 'name': 'marvel comic'}, {'id': ...</td>\n",
       "      <td>[{'id': 28, 'name': 'Action'}, {'id': 12, 'nam...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>[{'cast_id': 3, 'character': 'Harry Potter', '...</td>\n",
       "      <td>[{'credit_id': '52fe4273c3a36847f801fab1', 'de...</td>\n",
       "      <td>[{'id': 616, 'name': 'witch'}, {'id': 2343, 'n...</td>\n",
       "      <td>[{'id': 12, 'name': 'Adventure'}, {'id': 14, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>[{'cast_id': 18, 'character': 'Bruce Wayne / B...</td>\n",
       "      <td>[{'credit_id': '553bf23692514135c8002886', 'de...</td>\n",
       "      <td>[{'id': 849, 'name': 'dc comics'}, {'id': 7002...</td>\n",
       "      <td>[{'id': 28, 'name': 'Action'}, {'id': 12, 'nam...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                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",
       "5  [{'cast_id': 30, 'character': 'Peter Parker / ...   \n",
       "6  [{'cast_id': 34, 'character': 'Flynn Rider (vo...   \n",
       "7  [{'cast_id': 76, 'character': 'Tony Stark / Ir...   \n",
       "8  [{'cast_id': 3, 'character': 'Harry Potter', '...   \n",
       "9  [{'cast_id': 18, 'character': 'Bruce Wayne / B...   \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",
       "5  [{'credit_id': '52fe4252c3a36847f80151a5', 'de...   \n",
       "6  [{'credit_id': '52fe46db9251416c91062101', 'de...   \n",
       "7  [{'credit_id': '55d5f7d4c3a3683e7e0016eb', 'de...   \n",
       "8  [{'credit_id': '52fe4273c3a36847f801fab1', 'de...   \n",
       "9  [{'credit_id': '553bf23692514135c8002886', 'de...   \n",
       "\n",
       "                                            keywords  \\\n",
       "0  [{'id': 1463, 'name': 'culture clash'}, {'id':...   \n",
       "1  [{'id': 270, 'name': 'ocean'}, {'id': 726, 'na...   \n",
       "2  [{'id': 470, 'name': 'spy'}, {'id': 818, 'name...   \n",
       "3  [{'id': 849, 'name': 'dc comics'}, {'id': 853,...   \n",
       "4  [{'id': 818, 'name': 'based on novel'}, {'id':...   \n",
       "5  [{'id': 851, 'name': 'dual identity'}, {'id': ...   \n",
       "6  [{'id': 1562, 'name': 'hostage'}, {'id': 2343,...   \n",
       "7  [{'id': 8828, 'name': 'marvel comic'}, {'id': ...   \n",
       "8  [{'id': 616, 'name': 'witch'}, {'id': 2343, 'n...   \n",
       "9  [{'id': 849, 'name': 'dc comics'}, {'id': 7002...   \n",
       "\n",
       "                                              genres  \n",
       "0  [{'id': 28, 'name': 'Action'}, {'id': 12, 'nam...  \n",
       "1  [{'id': 12, 'name': 'Adventure'}, {'id': 14, '...  \n",
       "2  [{'id': 28, 'name': 'Action'}, {'id': 12, 'nam...  \n",
       "3  [{'id': 28, 'name': 'Action'}, {'id': 80, 'nam...  \n",
       "4  [{'id': 28, 'name': 'Action'}, {'id': 12, 'nam...  \n",
       "5  [{'id': 14, 'name': 'Fantasy'}, {'id': 28, 'na...  \n",
       "6  [{'id': 16, 'name': 'Animation'}, {'id': 10751...  \n",
       "7  [{'id': 28, 'name': 'Action'}, {'id': 12, 'nam...  \n",
       "8  [{'id': 12, 'name': 'Adventure'}, {'id': 14, '...  \n",
       "9  [{'id': 28, 'name': 'Action'}, {'id': 12, 'nam...  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "features = [\"cast\", \"crew\", \"keywords\", \"genres\"]\n",
    "\n",
    "for feature in features:\n",
    "    movies_df[feature] = movies_df[feature].apply(literal_eval)\n",
    "\n",
    "movies_df[features].head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "6948b882",
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_director(x):\n",
    "    for i in x:\n",
    "        if i[\"job\"] == \"Director\":\n",
    "            return i[\"name\"]\n",
    "    return np.nan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "2506084e",
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_list(x):\n",
    "    if isinstance(x, list):\n",
    "        names = [i[\"name\"] for i in x]\n",
    "\n",
    "        if len(names) > 3:\n",
    "            names = names[:3]\n",
    "\n",
    "        return names\n",
    "\n",
    "    return []"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "883c4684",
   "metadata": {},
   "outputs": [],
   "source": [
    "movies_df[\"director\"] = movies_df[\"crew\"].apply(get_director)\n",
    "\n",
    "features = [\"cast\", \"keywords\", \"genres\"]\n",
    "for feature in features:\n",
    "    movies_df[feature] = movies_df[feature].apply(get_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "47d9dc03",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>cast</th>\n",
       "      <th>director</th>\n",
       "      <th>keywords</th>\n",
       "      <th>genres</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Avatar</td>\n",
       "      <td>[Sam Worthington, Zoe Saldana, Sigourney Weaver]</td>\n",
       "      <td>James Cameron</td>\n",
       "      <td>[culture clash, future, space war]</td>\n",
       "      <td>[Action, Adventure, Fantasy]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Pirates of the Caribbean: At World's End</td>\n",
       "      <td>[Johnny Depp, Orlando Bloom, Keira Knightley]</td>\n",
       "      <td>Gore Verbinski</td>\n",
       "      <td>[ocean, drug abuse, exotic island]</td>\n",
       "      <td>[Adventure, Fantasy, Action]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Spectre</td>\n",
       "      <td>[Daniel Craig, Christoph Waltz, Léa Seydoux]</td>\n",
       "      <td>Sam Mendes</td>\n",
       "      <td>[spy, based on novel, secret agent]</td>\n",
       "      <td>[Action, Adventure, Crime]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>The Dark Knight Rises</td>\n",
       "      <td>[Christian Bale, Michael Caine, Gary Oldman]</td>\n",
       "      <td>Christopher Nolan</td>\n",
       "      <td>[dc comics, crime fighter, terrorist]</td>\n",
       "      <td>[Action, Crime, Drama]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>John Carter</td>\n",
       "      <td>[Taylor Kitsch, Lynn Collins, Samantha Morton]</td>\n",
       "      <td>Andrew Stanton</td>\n",
       "      <td>[based on novel, mars, medallion]</td>\n",
       "      <td>[Action, Adventure, Science Fiction]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      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",
       "                                               cast           director  \\\n",
       "0  [Sam Worthington, Zoe Saldana, Sigourney Weaver]      James Cameron   \n",
       "1     [Johnny Depp, Orlando Bloom, Keira Knightley]     Gore Verbinski   \n",
       "2      [Daniel Craig, Christoph Waltz, Léa Seydoux]         Sam Mendes   \n",
       "3      [Christian Bale, Michael Caine, Gary Oldman]  Christopher Nolan   \n",
       "4    [Taylor Kitsch, Lynn Collins, Samantha Morton]     Andrew Stanton   \n",
       "\n",
       "                                keywords                                genres  \n",
       "0     [culture clash, future, space war]          [Action, Adventure, Fantasy]  \n",
       "1     [ocean, drug abuse, exotic island]          [Adventure, Fantasy, Action]  \n",
       "2    [spy, based on novel, secret agent]            [Action, Adventure, Crime]  \n",
       "3  [dc comics, crime fighter, terrorist]                [Action, Crime, Drama]  \n",
       "4      [based on novel, mars, medallion]  [Action, Adventure, Science Fiction]  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_df[['title', 'cast', 'director', 'keywords', 'genres']].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "58641b54",
   "metadata": {},
   "outputs": [],
   "source": [
    "def clean_data(x):\n",
    "    if isinstance(x, list):\n",
    "        return [str.lower(i.replace(\" \", \"\")) for i in x]\n",
    "    else:\n",
    "        if isinstance(x, str):\n",
    "            return str.lower(x.replace(\" \", \"\"))\n",
    "        else:\n",
    "            return \"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "b53336ce",
   "metadata": {},
   "outputs": [],
   "source": [
    "features = ['cast', 'keywords', 'director', 'genres']\n",
    "for feature in features:\n",
    "    movies_df[feature] = movies_df[feature].apply(clean_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "85aa3133",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0    cultureclash future spacewar samworthington zo...\n",
      "1    ocean drugabuse exoticisland johnnydepp orland...\n",
      "2    spy basedonnovel secretagent danielcraig chris...\n",
      "3    dccomics crimefighter terrorist christianbale ...\n",
      "4    basedonnovel mars medallion taylorkitsch lynnc...\n",
      "Name: soup, dtype: object\n"
     ]
    }
   ],
   "source": [
    "def create_soup(x):\n",
    "    return ' '.join(x['keywords']) + ' ' + ' '.join(x['cast']) + ' ' + x['director'] + ' ' + ' '.join(x['genres'])\n",
    "\n",
    "\n",
    "movies_df[\"soup\"] = movies_df.apply(create_soup, axis=1)\n",
    "print(movies_df[\"soup\"].head())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "e6c59e7f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(4803, 11520)\n",
      "(4803, 4803)\n"
     ]
    }
   ],
   "source": [
    "count_vectorizer = CountVectorizer(stop_words=\"english\")\n",
    "count_matrix = count_vectorizer.fit_transform(movies_df[\"soup\"])\n",
    "\n",
    "print(count_matrix.shape)\n",
    "\n",
    "cosine_sim2 = cosine_similarity(count_matrix, count_matrix)\n",
    "print(cosine_sim2.shape)\n",
    "\n",
    "movies_df = movies_df.reset_index()\n",
    "indices = pd.Series(movies_df.index, index=movies_df['title'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "66b89abb",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "################ Content Based System #############\n",
      "Recommendations for The Dark Knight Rises\n",
      "65               The Dark Knight\n",
      "119                Batman Begins\n",
      "4638    Amidst the Devil's Wings\n",
      "1196                The Prestige\n",
      "3073           Romeo Is Bleeding\n",
      "3326              Black November\n",
      "1503                      Takers\n",
      "1986                      Faster\n",
      "303                     Catwoman\n",
      "747               Gangster Squad\n",
      "Name: title, dtype: object\n",
      "\n",
      "Recommendations for Avengers\n",
      "7                  Avengers: Age of Ultron\n",
      "26              Captain America: Civil War\n",
      "79                              Iron Man 2\n",
      "169     Captain America: The First Avenger\n",
      "174                    The Incredible Hulk\n",
      "85     Captain America: The Winter Soldier\n",
      "31                              Iron Man 3\n",
      "33                   X-Men: The Last Stand\n",
      "68                                Iron Man\n",
      "94                 Guardians of the Galaxy\n",
      "Name: title, dtype: object\n"
     ]
    }
   ],
   "source": [
    "print(\"################ Content Based System #############\")\n",
    "print(\"Recommendations for The Dark Knight Rises\")\n",
    "print(get_recommendations(\"The Dark Knight Rises\", cosine_sim2))\n",
    "print()\n",
    "print(\"Recommendations for Avengers\")\n",
    "print(get_recommendations(\"The Avengers\", cosine_sim2))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6c89cd31",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}