Rec_movies.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "ddc6823c",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "5da95227",
   "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>TMDb_Id</th>\n",
       "      <th>IMDb_Id</th>\n",
       "      <th>Title</th>\n",
       "      <th>Original_Title</th>\n",
       "      <th>Overview</th>\n",
       "      <th>Genres</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Crew</th>\n",
       "      <th>Collection</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>...</th>\n",
       "      <th>Languages_Spoken</th>\n",
       "      <th>Runtime</th>\n",
       "      <th>Tagline</th>\n",
       "      <th>Popularity</th>\n",
       "      <th>Rating_average</th>\n",
       "      <th>Rating_Count</th>\n",
       "      <th>Production_Companies</th>\n",
       "      <th>Country_of_Origin</th>\n",
       "      <th>Budget</th>\n",
       "      <th>Revenue</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>419704</td>\n",
       "      <td>tt2935510</td>\n",
       "      <td>Ad Astra</td>\n",
       "      <td>Ad Astra</td>\n",
       "      <td>The near future, a time when both hope and har...</td>\n",
       "      <td>Drama | Science Fiction</td>\n",
       "      <td>Brad Pitt | Tommy Lee Jones | Ruth Negga | Joh...</td>\n",
       "      <td>Brad Pitt | Arnon Milchan | Gary Rydstrom | Ga...</td>\n",
       "      <td>Single</td>\n",
       "      <td>2019-09-17</td>\n",
       "      <td>...</td>\n",
       "      <td>English | Norsk</td>\n",
       "      <td>123.0</td>\n",
       "      <td>The answers we seek are just outside our reach</td>\n",
       "      <td>463.487</td>\n",
       "      <td>5.9</td>\n",
       "      <td>2863</td>\n",
       "      <td>New Regency Productions | Keep Your Head | Mad...</td>\n",
       "      <td>Brazil | China | United States of America</td>\n",
       "      <td>87500000.0</td>\n",
       "      <td>127175922.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>338762</td>\n",
       "      <td>tt1634106</td>\n",
       "      <td>Bloodshot</td>\n",
       "      <td>Bloodshot</td>\n",
       "      <td>After he and his wife are murdered, marine Ray...</td>\n",
       "      <td>Action | Science Fiction</td>\n",
       "      <td>Vin Diesel | Eiza González | Sam Heughan | Tob...</td>\n",
       "      <td>John Papsidera | Matthew Vaughn | Jim May | Ne...</td>\n",
       "      <td>Single</td>\n",
       "      <td>2020-03-05</td>\n",
       "      <td>...</td>\n",
       "      <td>English</td>\n",
       "      <td>110.0</td>\n",
       "      <td>Being a superhero is in his blood</td>\n",
       "      <td>235.701</td>\n",
       "      <td>7.2</td>\n",
       "      <td>1384</td>\n",
       "      <td>Sony Pictures | Cross Creek Pictures | Mimran ...</td>\n",
       "      <td>China | United States of America</td>\n",
       "      <td>42000000.0</td>\n",
       "      <td>24573617.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>38700</td>\n",
       "      <td>tt1502397</td>\n",
       "      <td>Bad Boys for Life</td>\n",
       "      <td>Bad Boys for Life</td>\n",
       "      <td>Marcus and Mike are forced to confront new thr...</td>\n",
       "      <td>Action | Crime | Thriller</td>\n",
       "      <td>Will Smith | Martin Lawrence | Paola Nuñez | V...</td>\n",
       "      <td>Jerry Bruckheimer | Mike Stenson | Chad Oman |...</td>\n",
       "      <td>Bad Boys Collection</td>\n",
       "      <td>2020-01-15</td>\n",
       "      <td>...</td>\n",
       "      <td>Español | English</td>\n",
       "      <td>124.0</td>\n",
       "      <td>Ride together. Die together.</td>\n",
       "      <td>255.068</td>\n",
       "      <td>7.1</td>\n",
       "      <td>2596</td>\n",
       "      <td>Columbia Pictures | Platinum Dunes | 2.0 Enter...</td>\n",
       "      <td>France | United States of America</td>\n",
       "      <td>0.0</td>\n",
       "      <td>191150000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>102899</td>\n",
       "      <td>tt0478970</td>\n",
       "      <td>Ant-Man</td>\n",
       "      <td>Ant-Man</td>\n",
       "      <td>Armed with the astonishing ability to shrink i...</td>\n",
       "      <td>Action | Adventure | Science Fiction</td>\n",
       "      <td>Paul Rudd | Michael Douglas | Evangeline Lilly...</td>\n",
       "      <td>David Lazan | Jackie Burch | Sala Baker | Sala...</td>\n",
       "      <td>Ant-Man Collection</td>\n",
       "      <td>2015-07-14</td>\n",
       "      <td>...</td>\n",
       "      <td>English</td>\n",
       "      <td>117.0</td>\n",
       "      <td>Heroes don't get any bigger.</td>\n",
       "      <td>134.294</td>\n",
       "      <td>7.1</td>\n",
       "      <td>13625</td>\n",
       "      <td>Marvel Studios</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>130000000.0</td>\n",
       "      <td>519311965.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>76285</td>\n",
       "      <td>tt1854564</td>\n",
       "      <td>Percy Jackson: Sea of Monsters</td>\n",
       "      <td>Percy Jackson: Sea of Monsters</td>\n",
       "      <td>In their quest to confront the ultimate evil, ...</td>\n",
       "      <td>Adventure | Fantasy | Family</td>\n",
       "      <td>Logan Lerman | Alexandra Daddario | Douglas Sm...</td>\n",
       "      <td>Mark Goldblatt | Shelly Johnson | Karen Rosenf...</td>\n",
       "      <td>Percy Jackson Collection</td>\n",
       "      <td>2013-08-07</td>\n",
       "      <td>...</td>\n",
       "      <td>English</td>\n",
       "      <td>106.0</td>\n",
       "      <td>Where There Are Gods, There Are Monsters.</td>\n",
       "      <td>124.417</td>\n",
       "      <td>5.9</td>\n",
       "      <td>3547</td>\n",
       "      <td>Fox 2000 Pictures | Sunswept Entertainment | 1...</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>90000000.0</td>\n",
       "      <td>199850315.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>495764</td>\n",
       "      <td>tt7713068</td>\n",
       "      <td>Birds of Prey (and the Fantabulous Emancipatio...</td>\n",
       "      <td>Birds of Prey (and the Fantabulous Emancipatio...</td>\n",
       "      <td>Harley Quinn joins forces with a singer, an as...</td>\n",
       "      <td>Action | Comedy | Crime</td>\n",
       "      <td>Margot Robbie | Ewan McGregor | Mary Elizabeth...</td>\n",
       "      <td>K.K. Barrett | K.K. Barrett | Matthew Libatiqu...</td>\n",
       "      <td>Single</td>\n",
       "      <td>2020-02-05</td>\n",
       "      <td>...</td>\n",
       "      <td>English</td>\n",
       "      <td>109.0</td>\n",
       "      <td>Mind Over Mayhem</td>\n",
       "      <td>192.582</td>\n",
       "      <td>7.1</td>\n",
       "      <td>2681</td>\n",
       "      <td>DC Entertainment | LuckyChap Entertainment | K...</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>75000000.0</td>\n",
       "      <td>199158461.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1571</td>\n",
       "      <td>tt0337978</td>\n",
       "      <td>Live Free or Die Hard</td>\n",
       "      <td>Live Free or Die Hard</td>\n",
       "      <td>John McClane is back and badder than ever, and...</td>\n",
       "      <td>Action | Thriller</td>\n",
       "      <td>Bruce Willis | Justin Long | Timothy Olyphant ...</td>\n",
       "      <td>William Wisher Jr. | Len Wiseman | Patrick Tat...</td>\n",
       "      <td>Die Hard Collection</td>\n",
       "      <td>2007-06-20</td>\n",
       "      <td>...</td>\n",
       "      <td>English | Italiano | Français</td>\n",
       "      <td>128.0</td>\n",
       "      <td>The old school cop is back!</td>\n",
       "      <td>101.430</td>\n",
       "      <td>6.5</td>\n",
       "      <td>3717</td>\n",
       "      <td>Dune Entertainment | Cheyenne Enterprises | Wi...</td>\n",
       "      <td>United Kingdom | United States of America</td>\n",
       "      <td>110000000.0</td>\n",
       "      <td>383531464.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>595985</td>\n",
       "      <td>tt9082020</td>\n",
       "      <td>Cold Blood</td>\n",
       "      <td>Cold Blood Legacy - La mémoire du sang</td>\n",
       "      <td>A legendary but retired hit man lives in peace...</td>\n",
       "      <td>Action | Thriller</td>\n",
       "      <td>Jean Reno | Sarah Lind | Joe Anderson | David ...</td>\n",
       "      <td>Thierry Arbogast | Olias Barco | Kelly Valenti...</td>\n",
       "      <td>Single</td>\n",
       "      <td>2019-05-15</td>\n",
       "      <td>...</td>\n",
       "      <td>Français | English</td>\n",
       "      <td>91.0</td>\n",
       "      <td>You can't outrun the past</td>\n",
       "      <td>97.705</td>\n",
       "      <td>5.1</td>\n",
       "      <td>123</td>\n",
       "      <td>Ascot Elite Entertainment Group | EastWest Pro...</td>\n",
       "      <td>France | Ukraine</td>\n",
       "      <td>2700000.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>443791</td>\n",
       "      <td>tt5774060</td>\n",
       "      <td>Underwater</td>\n",
       "      <td>Underwater</td>\n",
       "      <td>After an earthquake destroys their underwater ...</td>\n",
       "      <td>Action | Horror | Science Fiction | Thriller</td>\n",
       "      <td>Kristen Stewart | Vincent Cassel | Mamoudou At...</td>\n",
       "      <td>William Hoy | Brian Berdan | Marco Beltrami | ...</td>\n",
       "      <td>Single</td>\n",
       "      <td>2020-01-08</td>\n",
       "      <td>...</td>\n",
       "      <td>English</td>\n",
       "      <td>95.0</td>\n",
       "      <td>7 miles below the ocean surface something has ...</td>\n",
       "      <td>137.262</td>\n",
       "      <td>6.5</td>\n",
       "      <td>603</td>\n",
       "      <td>Chernin Entertainment | 20th Century Fox | TSG...</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>80000000.0</td>\n",
       "      <td>33617430.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>619264</td>\n",
       "      <td>tt8228288</td>\n",
       "      <td>The Platform</td>\n",
       "      <td>El hoyo</td>\n",
       "      <td>A mysterious place, an indescribable prison, a...</td>\n",
       "      <td>Drama | Science Fiction</td>\n",
       "      <td>Ivan Massagué | Antonia San Juan | Zorion Egui...</td>\n",
       "      <td>Elena Ruiz | Aránzazu Calleja | Pedro Rivero |...</td>\n",
       "      <td>Single</td>\n",
       "      <td>2019-11-08</td>\n",
       "      <td>...</td>\n",
       "      <td>Español</td>\n",
       "      <td>95.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>133.238</td>\n",
       "      <td>7.1</td>\n",
       "      <td>1976</td>\n",
       "      <td>Basque Films | Mr. Miyagi | Consejería de Cult...</td>\n",
       "      <td>Spain</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   TMDb_Id    IMDb_Id                                              Title  \\\n",
       "0   419704  tt2935510                                           Ad Astra   \n",
       "1   338762  tt1634106                                          Bloodshot   \n",
       "2    38700  tt1502397                                  Bad Boys for Life   \n",
       "3   102899  tt0478970                                            Ant-Man   \n",
       "4    76285  tt1854564                     Percy Jackson: Sea of Monsters   \n",
       "5   495764  tt7713068  Birds of Prey (and the Fantabulous Emancipatio...   \n",
       "6     1571  tt0337978                              Live Free or Die Hard   \n",
       "7   595985  tt9082020                                         Cold Blood   \n",
       "8   443791  tt5774060                                         Underwater   \n",
       "9   619264  tt8228288                                       The Platform   \n",
       "\n",
       "                                      Original_Title  \\\n",
       "0                                           Ad Astra   \n",
       "1                                          Bloodshot   \n",
       "2                                  Bad Boys for Life   \n",
       "3                                            Ant-Man   \n",
       "4                     Percy Jackson: Sea of Monsters   \n",
       "5  Birds of Prey (and the Fantabulous Emancipatio...   \n",
       "6                              Live Free or Die Hard   \n",
       "7             Cold Blood Legacy - La mémoire du sang   \n",
       "8                                         Underwater   \n",
       "9                                            El hoyo   \n",
       "\n",
       "                                            Overview  \\\n",
       "0  The near future, a time when both hope and har...   \n",
       "1  After he and his wife are murdered, marine Ray...   \n",
       "2  Marcus and Mike are forced to confront new thr...   \n",
       "3  Armed with the astonishing ability to shrink i...   \n",
       "4  In their quest to confront the ultimate evil, ...   \n",
       "5  Harley Quinn joins forces with a singer, an as...   \n",
       "6  John McClane is back and badder than ever, and...   \n",
       "7  A legendary but retired hit man lives in peace...   \n",
       "8  After an earthquake destroys their underwater ...   \n",
       "9  A mysterious place, an indescribable prison, a...   \n",
       "\n",
       "                                         Genres  \\\n",
       "0                       Drama | Science Fiction   \n",
       "1                      Action | Science Fiction   \n",
       "2                     Action | Crime | Thriller   \n",
       "3          Action | Adventure | Science Fiction   \n",
       "4                  Adventure | Fantasy | Family   \n",
       "5                       Action | Comedy | Crime   \n",
       "6                             Action | Thriller   \n",
       "7                             Action | Thriller   \n",
       "8  Action | Horror | Science Fiction | Thriller   \n",
       "9                       Drama | Science Fiction   \n",
       "\n",
       "                                                Cast  \\\n",
       "0  Brad Pitt | Tommy Lee Jones | Ruth Negga | Joh...   \n",
       "1  Vin Diesel | Eiza González | Sam Heughan | Tob...   \n",
       "2  Will Smith | Martin Lawrence | Paola Nuñez | V...   \n",
       "3  Paul Rudd | Michael Douglas | Evangeline Lilly...   \n",
       "4  Logan Lerman | Alexandra Daddario | Douglas Sm...   \n",
       "5  Margot Robbie | Ewan McGregor | Mary Elizabeth...   \n",
       "6  Bruce Willis | Justin Long | Timothy Olyphant ...   \n",
       "7  Jean Reno | Sarah Lind | Joe Anderson | David ...   \n",
       "8  Kristen Stewart | Vincent Cassel | Mamoudou At...   \n",
       "9  Ivan Massagué | Antonia San Juan | Zorion Egui...   \n",
       "\n",
       "                                                Crew  \\\n",
       "0  Brad Pitt | Arnon Milchan | Gary Rydstrom | Ga...   \n",
       "1  John Papsidera | Matthew Vaughn | Jim May | Ne...   \n",
       "2  Jerry Bruckheimer | Mike Stenson | Chad Oman |...   \n",
       "3  David Lazan | Jackie Burch | Sala Baker | Sala...   \n",
       "4  Mark Goldblatt | Shelly Johnson | Karen Rosenf...   \n",
       "5  K.K. Barrett | K.K. Barrett | Matthew Libatiqu...   \n",
       "6  William Wisher Jr. | Len Wiseman | Patrick Tat...   \n",
       "7  Thierry Arbogast | Olias Barco | Kelly Valenti...   \n",
       "8  William Hoy | Brian Berdan | Marco Beltrami | ...   \n",
       "9  Elena Ruiz | Aránzazu Calleja | Pedro Rivero |...   \n",
       "\n",
       "                 Collection Release_Date  ...               Languages_Spoken  \\\n",
       "0                    Single   2019-09-17  ...                English | Norsk   \n",
       "1                    Single   2020-03-05  ...                        English   \n",
       "2       Bad Boys Collection   2020-01-15  ...              Español | English   \n",
       "3        Ant-Man Collection   2015-07-14  ...                        English   \n",
       "4  Percy Jackson Collection   2013-08-07  ...                        English   \n",
       "5                    Single   2020-02-05  ...                        English   \n",
       "6       Die Hard Collection   2007-06-20  ...  English | Italiano | Français   \n",
       "7                    Single   2019-05-15  ...             Français | English   \n",
       "8                    Single   2020-01-08  ...                        English   \n",
       "9                    Single   2019-11-08  ...                        Español   \n",
       "\n",
       "  Runtime                                            Tagline  Popularity  \\\n",
       "0   123.0     The answers we seek are just outside our reach     463.487   \n",
       "1   110.0                  Being a superhero is in his blood     235.701   \n",
       "2   124.0                       Ride together. Die together.     255.068   \n",
       "3   117.0                       Heroes don't get any bigger.     134.294   \n",
       "4   106.0          Where There Are Gods, There Are Monsters.     124.417   \n",
       "5   109.0                                   Mind Over Mayhem     192.582   \n",
       "6   128.0                        The old school cop is back!     101.430   \n",
       "7    91.0                          You can't outrun the past      97.705   \n",
       "8    95.0  7 miles below the ocean surface something has ...     137.262   \n",
       "9    95.0                                                NaN     133.238   \n",
       "\n",
       "  Rating_average  Rating_Count  \\\n",
       "0            5.9          2863   \n",
       "1            7.2          1384   \n",
       "2            7.1          2596   \n",
       "3            7.1         13625   \n",
       "4            5.9          3547   \n",
       "5            7.1          2681   \n",
       "6            6.5          3717   \n",
       "7            5.1           123   \n",
       "8            6.5           603   \n",
       "9            7.1          1976   \n",
       "\n",
       "                                Production_Companies  \\\n",
       "0  New Regency Productions | Keep Your Head | Mad...   \n",
       "1  Sony Pictures | Cross Creek Pictures | Mimran ...   \n",
       "2  Columbia Pictures | Platinum Dunes | 2.0 Enter...   \n",
       "3                                     Marvel Studios   \n",
       "4  Fox 2000 Pictures | Sunswept Entertainment | 1...   \n",
       "5  DC Entertainment | LuckyChap Entertainment | K...   \n",
       "6  Dune Entertainment | Cheyenne Enterprises | Wi...   \n",
       "7  Ascot Elite Entertainment Group | EastWest Pro...   \n",
       "8  Chernin Entertainment | 20th Century Fox | TSG...   \n",
       "9  Basque Films | Mr. Miyagi | Consejería de Cult...   \n",
       "\n",
       "                           Country_of_Origin       Budget      Revenue  \n",
       "0  Brazil | China | United States of America   87500000.0  127175922.0  \n",
       "1           China | United States of America   42000000.0   24573617.0  \n",
       "2          France | United States of America          0.0  191150000.0  \n",
       "3                   United States of America  130000000.0  519311965.0  \n",
       "4                   United States of America   90000000.0  199850315.0  \n",
       "5                   United States of America   75000000.0  199158461.0  \n",
       "6  United Kingdom | United States of America  110000000.0  383531464.0  \n",
       "7                           France | Ukraine    2700000.0          0.0  \n",
       "8                   United States of America   80000000.0   33617430.0  \n",
       "9                                      Spain          0.0          0.0  \n",
       "\n",
       "[10 rows x 22 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies = pd.read_csv('TMDB_10000_Popular_Movies.csv')\n",
    "movies.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "2e882161",
   "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>TMDb_Id</th>\n",
       "      <th>Runtime</th>\n",
       "      <th>Popularity</th>\n",
       "      <th>Rating_average</th>\n",
       "      <th>Rating_Count</th>\n",
       "      <th>Budget</th>\n",
       "      <th>Revenue</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>10000.000000</td>\n",
       "      <td>9986.000000</td>\n",
       "      <td>10000.000000</td>\n",
       "      <td>10000.000000</td>\n",
       "      <td>10000.000000</td>\n",
       "      <td>9.999000e+03</td>\n",
       "      <td>9.999000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>152075.912000</td>\n",
       "      <td>102.805928</td>\n",
       "      <td>13.615456</td>\n",
       "      <td>6.307200</td>\n",
       "      <td>1021.559700</td>\n",
       "      <td>1.906091e+07</td>\n",
       "      <td>5.560842e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>196845.093333</td>\n",
       "      <td>26.501851</td>\n",
       "      <td>10.428176</td>\n",
       "      <td>1.352637</td>\n",
       "      <td>1993.732127</td>\n",
       "      <td>3.559811e+07</td>\n",
       "      <td>1.439128e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>4.838000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>10165.250000</td>\n",
       "      <td>91.000000</td>\n",
       "      <td>9.739750</td>\n",
       "      <td>5.800000</td>\n",
       "      <td>143.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>27124.000000</td>\n",
       "      <td>101.000000</td>\n",
       "      <td>11.620500</td>\n",
       "      <td>6.500000</td>\n",
       "      <td>332.000000</td>\n",
       "      <td>3.000000e+06</td>\n",
       "      <td>2.500000e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>301366.750000</td>\n",
       "      <td>115.000000</td>\n",
       "      <td>14.334000</td>\n",
       "      <td>7.100000</td>\n",
       "      <td>927.000000</td>\n",
       "      <td>2.300000e+07</td>\n",
       "      <td>4.611674e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>688131.000000</td>\n",
       "      <td>400.000000</td>\n",
       "      <td>463.487000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>25159.000000</td>\n",
       "      <td>3.870000e+08</td>\n",
       "      <td>2.797801e+09</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             TMDb_Id      Runtime    Popularity  Rating_average  Rating_Count  \\\n",
       "count   10000.000000  9986.000000  10000.000000    10000.000000  10000.000000   \n",
       "mean   152075.912000   102.805928     13.615456        6.307200   1021.559700   \n",
       "std    196845.093333    26.501851     10.428176        1.352637   1993.732127   \n",
       "min         2.000000     0.000000      4.838000        0.000000      0.000000   \n",
       "25%     10165.250000    91.000000      9.739750        5.800000    143.000000   \n",
       "50%     27124.000000   101.000000     11.620500        6.500000    332.000000   \n",
       "75%    301366.750000   115.000000     14.334000        7.100000    927.000000   \n",
       "max    688131.000000   400.000000    463.487000       10.000000  25159.000000   \n",
       "\n",
       "             Budget       Revenue  \n",
       "count  9.999000e+03  9.999000e+03  \n",
       "mean   1.906091e+07  5.560842e+07  \n",
       "std    3.559811e+07  1.439128e+08  \n",
       "min    0.000000e+00  0.000000e+00  \n",
       "25%    0.000000e+00  0.000000e+00  \n",
       "50%    3.000000e+06  2.500000e+06  \n",
       "75%    2.300000e+07  4.611674e+07  \n",
       "max    3.870000e+08  2.797801e+09  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "e9bbd347",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 10000 entries, 0 to 9999\n",
      "Data columns (total 22 columns):\n",
      " #   Column                Non-Null Count  Dtype  \n",
      "---  ------                --------------  -----  \n",
      " 0   TMDb_Id               10000 non-null  int64  \n",
      " 1   IMDb_Id               9929 non-null   object \n",
      " 2   Title                 10000 non-null  object \n",
      " 3   Original_Title        10000 non-null  object \n",
      " 4   Overview              9970 non-null   object \n",
      " 5   Genres                9934 non-null   object \n",
      " 6   Cast                  9948 non-null   object \n",
      " 7   Crew                  9987 non-null   object \n",
      " 8   Collection            9999 non-null   object \n",
      " 9   Release_Date          9997 non-null   object \n",
      " 10  Release_Status        9999 non-null   object \n",
      " 11  Original_Language     10000 non-null  object \n",
      " 12  Languages_Spoken      9916 non-null   object \n",
      " 13  Runtime               9986 non-null   float64\n",
      " 14  Tagline               7597 non-null   object \n",
      " 15  Popularity            10000 non-null  float64\n",
      " 16  Rating_average        10000 non-null  float64\n",
      " 17  Rating_Count          10000 non-null  int64  \n",
      " 18  Production_Companies  9697 non-null   object \n",
      " 19  Country_of_Origin     9882 non-null   object \n",
      " 20  Budget                9999 non-null   float64\n",
      " 21  Revenue               9999 non-null   float64\n",
      "dtypes: float64(5), int64(2), object(15)\n",
      "memory usage: 1.7+ MB\n"
     ]
    }
   ],
   "source": [
    "movies.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "ecbcf6f9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "TMDb_Id                    0\n",
       "IMDb_Id                   71\n",
       "Title                      0\n",
       "Original_Title             0\n",
       "Overview                  30\n",
       "Genres                    66\n",
       "Cast                      52\n",
       "Crew                      13\n",
       "Collection                 1\n",
       "Release_Date               3\n",
       "Release_Status             1\n",
       "Original_Language          0\n",
       "Languages_Spoken          84\n",
       "Runtime                   14\n",
       "Tagline                 2403\n",
       "Popularity                 0\n",
       "Rating_average             0\n",
       "Rating_Count               0\n",
       "Production_Companies     303\n",
       "Country_of_Origin        118\n",
       "Budget                     1\n",
       "Revenue                    1\n",
       "dtype: int64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "5332a192",
   "metadata": {},
   "outputs": [],
   "source": [
    "movies = movies[['TMDb_Id','Title','Overview','Genres']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "72001876",
   "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>TMDb_Id</th>\n",
       "      <th>Title</th>\n",
       "      <th>Overview</th>\n",
       "      <th>Genres</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>419704</td>\n",
       "      <td>Ad Astra</td>\n",
       "      <td>The near future, a time when both hope and har...</td>\n",
       "      <td>Drama | Science Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>338762</td>\n",
       "      <td>Bloodshot</td>\n",
       "      <td>After he and his wife are murdered, marine Ray...</td>\n",
       "      <td>Action | Science Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>38700</td>\n",
       "      <td>Bad Boys for Life</td>\n",
       "      <td>Marcus and Mike are forced to confront new thr...</td>\n",
       "      <td>Action | Crime | Thriller</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>102899</td>\n",
       "      <td>Ant-Man</td>\n",
       "      <td>Armed with the astonishing ability to shrink i...</td>\n",
       "      <td>Action | Adventure | Science Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>76285</td>\n",
       "      <td>Percy Jackson: Sea of Monsters</td>\n",
       "      <td>In their quest to confront the ultimate evil, ...</td>\n",
       "      <td>Adventure | Fantasy | Family</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   TMDb_Id                           Title  \\\n",
       "0   419704                        Ad Astra   \n",
       "1   338762                       Bloodshot   \n",
       "2    38700               Bad Boys for Life   \n",
       "3   102899                         Ant-Man   \n",
       "4    76285  Percy Jackson: Sea of Monsters   \n",
       "\n",
       "                                            Overview  \\\n",
       "0  The near future, a time when both hope and har...   \n",
       "1  After he and his wife are murdered, marine Ray...   \n",
       "2  Marcus and Mike are forced to confront new thr...   \n",
       "3  Armed with the astonishing ability to shrink i...   \n",
       "4  In their quest to confront the ultimate evil, ...   \n",
       "\n",
       "                                 Genres  \n",
       "0               Drama | Science Fiction  \n",
       "1              Action | Science Fiction  \n",
       "2             Action | Crime | Thriller  \n",
       "3  Action | Adventure | Science Fiction  \n",
       "4          Adventure | Fantasy | Family  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "c83455f8",
   "metadata": {},
   "outputs": [],
   "source": [
    "movies['Line']=movies['Overview']+movies['Genres']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "9a4ac8ba",
   "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>TMDb_Id</th>\n",
       "      <th>Title</th>\n",
       "      <th>Overview</th>\n",
       "      <th>Genres</th>\n",
       "      <th>Line</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>419704</td>\n",
       "      <td>Ad Astra</td>\n",
       "      <td>The near future, a time when both hope and har...</td>\n",
       "      <td>Drama | Science Fiction</td>\n",
       "      <td>The near future, a time when both hope and har...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>338762</td>\n",
       "      <td>Bloodshot</td>\n",
       "      <td>After he and his wife are murdered, marine Ray...</td>\n",
       "      <td>Action | Science Fiction</td>\n",
       "      <td>After he and his wife are murdered, marine Ray...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>38700</td>\n",
       "      <td>Bad Boys for Life</td>\n",
       "      <td>Marcus and Mike are forced to confront new thr...</td>\n",
       "      <td>Action | Crime | Thriller</td>\n",
       "      <td>Marcus and Mike are forced to confront new thr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>102899</td>\n",
       "      <td>Ant-Man</td>\n",
       "      <td>Armed with the astonishing ability to shrink i...</td>\n",
       "      <td>Action | Adventure | Science Fiction</td>\n",
       "      <td>Armed with the astonishing ability to shrink i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>76285</td>\n",
       "      <td>Percy Jackson: Sea of Monsters</td>\n",
       "      <td>In their quest to confront the ultimate evil, ...</td>\n",
       "      <td>Adventure | Fantasy | Family</td>\n",
       "      <td>In their quest to confront the ultimate evil, ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   TMDb_Id                           Title  \\\n",
       "0   419704                        Ad Astra   \n",
       "1   338762                       Bloodshot   \n",
       "2    38700               Bad Boys for Life   \n",
       "3   102899                         Ant-Man   \n",
       "4    76285  Percy Jackson: Sea of Monsters   \n",
       "\n",
       "                                            Overview  \\\n",
       "0  The near future, a time when both hope and har...   \n",
       "1  After he and his wife are murdered, marine Ray...   \n",
       "2  Marcus and Mike are forced to confront new thr...   \n",
       "3  Armed with the astonishing ability to shrink i...   \n",
       "4  In their quest to confront the ultimate evil, ...   \n",
       "\n",
       "                                 Genres  \\\n",
       "0               Drama | Science Fiction   \n",
       "1              Action | Science Fiction   \n",
       "2             Action | Crime | Thriller   \n",
       "3  Action | Adventure | Science Fiction   \n",
       "4          Adventure | Fantasy | Family   \n",
       "\n",
       "                                                Line  \n",
       "0  The near future, a time when both hope and har...  \n",
       "1  After he and his wife are murdered, marine Ray...  \n",
       "2  Marcus and Mike are forced to confront new thr...  \n",
       "3  Armed with the astonishing ability to shrink i...  \n",
       "4  In their quest to confront the ultimate evil, ...  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "f3a53ce9",
   "metadata": {},
   "outputs": [],
   "source": [
    "movies = movies.drop(columns=['Overview','Genres'])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5599e191",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "776bab47",
   "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>TMDb_Id</th>\n",
       "      <th>Title</th>\n",
       "      <th>Line</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>419704</td>\n",
       "      <td>Ad Astra</td>\n",
       "      <td>The near future, a time when both hope and har...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>338762</td>\n",
       "      <td>Bloodshot</td>\n",
       "      <td>After he and his wife are murdered, marine Ray...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>38700</td>\n",
       "      <td>Bad Boys for Life</td>\n",
       "      <td>Marcus and Mike are forced to confront new thr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>102899</td>\n",
       "      <td>Ant-Man</td>\n",
       "      <td>Armed with the astonishing ability to shrink i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>76285</td>\n",
       "      <td>Percy Jackson: Sea of Monsters</td>\n",
       "      <td>In their quest to confront the ultimate evil, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9995</th>\n",
       "      <td>603937</td>\n",
       "      <td>Bliss Point</td>\n",
       "      <td>Two boys row silently through a Dutch water la...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9996</th>\n",
       "      <td>22752</td>\n",
       "      <td>The Reluctant Dragon</td>\n",
       "      <td>Humorist Robert Benchley attempts to find Walt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9997</th>\n",
       "      <td>19592</td>\n",
       "      <td>Dead Birds</td>\n",
       "      <td>A group of Confederate soldiers hole up on an ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9998</th>\n",
       "      <td>9727</td>\n",
       "      <td>End Game</td>\n",
       "      <td>Alex Thomas was the man in charge of protectin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9999</th>\n",
       "      <td>323370</td>\n",
       "      <td>The Diabolical</td>\n",
       "      <td>When a single mother and her two young childre...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10000 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      TMDb_Id                           Title  \\\n",
       "0      419704                        Ad Astra   \n",
       "1      338762                       Bloodshot   \n",
       "2       38700               Bad Boys for Life   \n",
       "3      102899                         Ant-Man   \n",
       "4       76285  Percy Jackson: Sea of Monsters   \n",
       "...       ...                             ...   \n",
       "9995   603937                     Bliss Point   \n",
       "9996    22752            The Reluctant Dragon   \n",
       "9997    19592                      Dead Birds   \n",
       "9998     9727                        End Game   \n",
       "9999   323370                  The Diabolical   \n",
       "\n",
       "                                                   Line  \n",
       "0     The near future, a time when both hope and har...  \n",
       "1     After he and his wife are murdered, marine Ray...  \n",
       "2     Marcus and Mike are forced to confront new thr...  \n",
       "3     Armed with the astonishing ability to shrink i...  \n",
       "4     In their quest to confront the ultimate evil, ...  \n",
       "...                                                 ...  \n",
       "9995  Two boys row silently through a Dutch water la...  \n",
       "9996  Humorist Robert Benchley attempts to find Walt...  \n",
       "9997  A group of Confederate soldiers hole up on an ...  \n",
       "9998  Alex Thomas was the man in charge of protectin...  \n",
       "9999  When a single mother and her two young childre...  \n",
       "\n",
       "[10000 rows x 3 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "317a34e2",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "1b97afc3",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2730e8bf",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2723965c",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "ddd4da04",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.preprocessing import StandardScaler, OneHotEncoder\n",
    "from sklearn.feature_extraction.text import TfidfVectorizer\n",
    "from sklearn.feature_extraction.text import CountVectorizer"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ce9a0867",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d1fc8de8",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "57c33429",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8c187fb6",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "8f886339",
   "metadata": {},
   "outputs": [],
   "source": [
    "cv = CountVectorizer(max_features=10000,stop_words='english')\n",
    "vector_data = cv.fit_transform(movies['Line'].values.astype('U')).toarray()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "dd15e19b",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.metrics.pairwise import cosine_similarity"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "e015d8a6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[1.        , 0.08226127, 0.        , ..., 0.        , 0.02519763,\n",
       "        0.06761234],\n",
       "       [0.08226127, 1.        , 0.06131393, ..., 0.0433555 , 0.07254763,\n",
       "        0.06488857],\n",
       "       [0.        , 0.06131393, 1.        , ..., 0.05050763, 0.05634362,\n",
       "        0.03779645],\n",
       "       ...,\n",
       "       [0.        , 0.0433555 , 0.05050763, ..., 1.        , 0.03984095,\n",
       "        0.16035675],\n",
       "       [0.02519763, 0.07254763, 0.05634362, ..., 0.03984095, 1.        ,\n",
       "        0.02981424],\n",
       "       [0.06761234, 0.06488857, 0.03779645, ..., 0.16035675, 0.02981424,\n",
       "        1.        ]])"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "simi = cosine_similarity(vector_data)\n",
    "simi"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "88908db2",
   "metadata": {},
   "outputs": [],
   "source": [
    "def top_movies(movie):\n",
    "    idx = movies[movies['Title']==movie].index[0]\n",
    "    mov = sorted(list(enumerate(simi[idx])),reverse=True, key=lambda vector_data:vector_data[1])\n",
    "    for i in mov[:5]:\n",
    "        print(movies.iloc[i[0]].Title)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "5d2e0f59",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Iron Man\n",
      "Avatar 2\n",
      "Iron Man 3\n",
      "Avengers: Age of Ultron\n",
      "Guardians of the Galaxy Vol. 2\n"
     ]
    }
   ],
   "source": [
    "top_movies(\"Iron Man\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "660a8015",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pickle\n",
    "pickle.dump(movies,open('rec_movies.pkl','wb'))\n",
    "pickle.dump(simi,open('simi.pkl','wb'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "814da8b4",
   "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>TMDb_Id</th>\n",
       "      <th>Title</th>\n",
       "      <th>Line</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>419704</td>\n",
       "      <td>Ad Astra</td>\n",
       "      <td>The near future, a time when both hope and har...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>338762</td>\n",
       "      <td>Bloodshot</td>\n",
       "      <td>After he and his wife are murdered, marine Ray...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>38700</td>\n",
       "      <td>Bad Boys for Life</td>\n",
       "      <td>Marcus and Mike are forced to confront new thr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>102899</td>\n",
       "      <td>Ant-Man</td>\n",
       "      <td>Armed with the astonishing ability to shrink i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>76285</td>\n",
       "      <td>Percy Jackson: Sea of Monsters</td>\n",
       "      <td>In their quest to confront the ultimate evil, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9995</th>\n",
       "      <td>603937</td>\n",
       "      <td>Bliss Point</td>\n",
       "      <td>Two boys row silently through a Dutch water la...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9996</th>\n",
       "      <td>22752</td>\n",
       "      <td>The Reluctant Dragon</td>\n",
       "      <td>Humorist Robert Benchley attempts to find Walt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9997</th>\n",
       "      <td>19592</td>\n",
       "      <td>Dead Birds</td>\n",
       "      <td>A group of Confederate soldiers hole up on an ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9998</th>\n",
       "      <td>9727</td>\n",
       "      <td>End Game</td>\n",
       "      <td>Alex Thomas was the man in charge of protectin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9999</th>\n",
       "      <td>323370</td>\n",
       "      <td>The Diabolical</td>\n",
       "      <td>When a single mother and her two young childre...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10000 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      TMDb_Id                           Title  \\\n",
       "0      419704                        Ad Astra   \n",
       "1      338762                       Bloodshot   \n",
       "2       38700               Bad Boys for Life   \n",
       "3      102899                         Ant-Man   \n",
       "4       76285  Percy Jackson: Sea of Monsters   \n",
       "...       ...                             ...   \n",
       "9995   603937                     Bliss Point   \n",
       "9996    22752            The Reluctant Dragon   \n",
       "9997    19592                      Dead Birds   \n",
       "9998     9727                        End Game   \n",
       "9999   323370                  The Diabolical   \n",
       "\n",
       "                                                   Line  \n",
       "0     The near future, a time when both hope and har...  \n",
       "1     After he and his wife are murdered, marine Ray...  \n",
       "2     Marcus and Mike are forced to confront new thr...  \n",
       "3     Armed with the astonishing ability to shrink i...  \n",
       "4     In their quest to confront the ultimate evil, ...  \n",
       "...                                                 ...  \n",
       "9995  Two boys row silently through a Dutch water la...  \n",
       "9996  Humorist Robert Benchley attempts to find Walt...  \n",
       "9997  A group of Confederate soldiers hole up on an ...  \n",
       "9998  Alex Thomas was the man in charge of protectin...  \n",
       "9999  When a single mother and her two young childre...  \n",
       "\n",
       "[10000 rows x 3 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pickle.load(open('rec_movies.pkl','rb'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0d8a3fc7",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.10.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}