Movies_Recommendation_System.ipynb

{
  "cells": [
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "-7RI_KjlOUlW"
      },
      "outputs": [],
      "source": [
        "import numpy as np\n",
        "import pandas as pd\n",
        "import matplotlib.pyplot as plt\n",
        "from sklearn.neighbors import NearestNeighbors\n",
        "from sklearn.compose import ColumnTransformer\n",
        "from sklearn.preprocessing import OneHotEncoder, OrdinalEncoder, StandardScaler\n",
        "from sklearn.impute import SimpleImputer\n",
        "from sklearn.pipeline import Pipeline\n",
        "from sklearn.feature_extraction.text import CountVectorizer\n",
        "import joblib"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "RAFRmP97P7EU",
        "outputId": "d6ac1618-3b6b-4bcf-8508-0ae214a8a4be"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 731857 entries, 0 to 731856\n",
            "Data columns (total 20 columns):\n",
            " #   Column                Non-Null Count   Dtype  \n",
            "---  ------                --------------   -----  \n",
            " 0   id                    731857 non-null  int64  \n",
            " 1   title                 731853 non-null  object \n",
            " 2   genres                516089 non-null  object \n",
            " 3   original_language     731857 non-null  object \n",
            " 4   overview              610830 non-null  object \n",
            " 5   popularity            731857 non-null  float64\n",
            " 6   production_companies  340869 non-null  object \n",
            " 7   release_date          677487 non-null  object \n",
            " 8   budget                731857 non-null  float64\n",
            " 9   revenue               731857 non-null  float64\n",
            " 10  runtime               695638 non-null  float64\n",
            " 11  status                731857 non-null  object \n",
            " 12  tagline               108927 non-null  object \n",
            " 13  vote_average          731857 non-null  float64\n",
            " 14  vote_count            731857 non-null  float64\n",
            " 15  credits               503857 non-null  object \n",
            " 16  keywords              211643 non-null  object \n",
            " 17  poster_path           540225 non-null  object \n",
            " 18  backdrop_path         223163 non-null  object \n",
            " 19  recommendations       36556 non-null   object \n",
            "dtypes: float64(6), int64(1), object(13)\n",
            "memory usage: 111.7+ MB\n"
          ]
        }
      ],
      "source": [
        "movies = pd.read_csv(\"drive/MyDrive/data/movies.csv\", encoding=\"ISO-8859-1\")\n",
        "\n",
        "movies.info()\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "plgywtr3Y7IG",
        "outputId": "93035fe9-3ab9-4624-bdcf-c072565ad50f"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "          id                                              title  \\\n",
              "0      76600                           Avatar: The Way of Water   \n",
              "1     899112                                      Violent Night   \n",
              "2        411  The Chronicles of Narnia: The Lion, the Witch ...   \n",
              "3     436270                                         Black Adam   \n",
              "5     555604                     Guillermo del Toro's Pinocchio   \n",
              "...      ...                                                ...   \n",
              "2821    9473                 South Park: Bigger, Longer & Uncut   \n",
              "2822   11238                    Aladdin and the King of Thieves   \n",
              "2823  913862                  Downfall: The Case Against Boeing   \n",
              "2824     311                        Once Upon a Time in America   \n",
              "2825  763788                                          Dangerous   \n",
              "\n",
              "                                genres original_language  \\\n",
              "0     Science Fiction-Adventure-Action                en   \n",
              "1         Action-Comedy-Crime-Thriller                en   \n",
              "2             Adventure-Family-Fantasy                en   \n",
              "3       Action-Fantasy-Science Fiction                en   \n",
              "5              Animation-Fantasy-Drama                en   \n",
              "...                                ...               ...   \n",
              "2821                  Animation-Comedy                en   \n",
              "2822        Adventure-Animation-Family                en   \n",
              "2823                       Documentary                en   \n",
              "2824                       Drama-Crime                en   \n",
              "2825                   Action-Thriller                en   \n",
              "\n",
              "                                               overview  popularity  \\\n",
              "0     Set more than a decade after the events of the...   17043.610   \n",
              "1     When a team of mercenaries breaks into a wealt...    4870.915   \n",
              "2     Siblings Lucy Edmund Susan and Peter step thro...    4059.268   \n",
              "3     Nearly 5000 years after he was bestowed with t...    3964.678   \n",
              "5     During the rise of fascism in Mussolini's Ital...    2383.322   \n",
              "...                                                 ...         ...   \n",
              "2821  When the four boys see an R-rated movie featur...      31.530   \n",
              "2822  Legendary secrets are revealed as Aladdin and ...      31.526   \n",
              "2823  Investigators reveal how Boeingâs alleged pr...      31.523   \n",
              "2824  A former Prohibition-era Jewish gangster retur...      31.510   \n",
              "2825  A reformed sociopath heads to a remote island ...      31.500   \n",
              "\n",
              "                                   production_companies release_date  \\\n",
              "0         Lightstorm Entertainment-20th Century Studios   2022-12-14   \n",
              "1                Universal Pictures-87North Productions   2022-11-30   \n",
              "2     Walt Disney Pictures-Walden Media-C.S. Lewis C...   2005-12-07   \n",
              "3     New Line Cinema-Flynn Picture Company-Seven Bu...   2022-10-19   \n",
              "5     The Jim Henson Company-ShadowMachine-Double Da...   2022-11-09   \n",
              "...                                                 ...          ...   \n",
              "2821  Paramount-Warner Bros. Pictures-Scott Rudin Pr...   1999-06-30   \n",
              "2822                        Disney Television Animation   1996-05-20   \n",
              "2823      Moxie Firecracker Films-Imagine Documentaries   2022-02-09   \n",
              "2824  Warner Bros. Pictures-Rafran Cinematografica-P...   1984-05-23   \n",
              "2825  Benaroya Pictures-Minds Eye Entertainment-Misc...   2021-11-05   \n",
              "\n",
              "           budget      revenue  runtime    status  \\\n",
              "0     460000000.0  955081686.0    192.0  Released   \n",
              "1      20000000.0   55173750.0    112.0  Released   \n",
              "2     180000000.0  745013115.0    143.0  Released   \n",
              "3     200000000.0  389000000.0    125.0  Released   \n",
              "5      35000000.0          0.0    117.0  Released   \n",
              "...           ...          ...      ...       ...   \n",
              "2821   21000000.0   83137603.0     81.0  Released   \n",
              "2822          0.0          0.0     81.0  Released   \n",
              "2823          0.0          0.0     89.0  Released   \n",
              "2824   30000000.0    5472914.0    229.0  Released   \n",
              "2825          0.0          0.0     99.0  Released   \n",
              "\n",
              "                                          tagline  vote_average  vote_count  \\\n",
              "0                              Return to Pandora.         8.007      1421.0   \n",
              "1                           You better watch out.         7.718       535.0   \n",
              "2               Evil Has Reigned For 100 Years...         7.105      9016.0   \n",
              "3     The world needed a hero. It got Black Adam.         7.228      3268.0   \n",
              "5                        Love will give you life.         8.458      1112.0   \n",
              "...                                           ...           ...         ...   \n",
              "2821                                       UH-OH.         7.207      2208.0   \n",
              "2822         The Spectacular Adventure Continues!         6.265      1633.0   \n",
              "2823                                          NaN         7.100       108.0   \n",
              "2824           Crime, passion and lust for power.         8.442      4443.0   \n",
              "2825                   Killer instincts die hard.         6.200       351.0   \n",
              "\n",
              "                                                credits  \\\n",
              "0     Sam Worthington-Zoe SaldaÃ±a-Sigourney Weaver-...   \n",
              "1     David Harbour-John Leguizamo-Beverly D'Angelo-...   \n",
              "2     Skandar Keynes-Georgie Henley-William Moseley-...   \n",
              "3     Dwayne Johnson-Aldis Hodge-Noah Centineo-Sarah...   \n",
              "5     Gregory Mann-Ewan McGregor-David Bradley-Chris...   \n",
              "...                                                 ...   \n",
              "2821  Trey Parker-Matt Stone-Mary Kay Bergman-Isaac ...   \n",
              "2822  Scott Weinger-Linda Larkin-Robin Williams-John...   \n",
              "2823                                      John Fantasia   \n",
              "2824  Robert De Niro-James Woods-Elizabeth McGovern-...   \n",
              "2825  Scott Eastwood-Mel Gibson-Tyrese Gibson-Kevin ...   \n",
              "\n",
              "                                               keywords  \\\n",
              "0     loss of loved one-dying and death-alien life-f...   \n",
              "1     holiday-santa claus-mercenary-saving christmas...   \n",
              "2     saving the world-sibling relationship-witch-ba...   \n",
              "3     lightning-anti hero-superhero-based on comic-d...   \n",
              "5     italy-based on novel or book-fascism-woodcutte...   \n",
              "...                                                 ...   \n",
              "2821  hell-world supremacy-elementary school-atheist...   \n",
              "2822  musical-flying carpet-orient-sequel-genie-arab...   \n",
              "2823                            aviation-airplane crash   \n",
              "2824  new york city-life and death-corruption-street...   \n",
              "2825                                                NaN   \n",
              "\n",
              "                           poster_path                     backdrop_path  \\\n",
              "0     /t6HIqrRAclMCA60NsSmeqe9RmNV.jpg  /s16H6tpK2utvwDtzZ8Qy4qm5Emw.jpg   \n",
              "1     /1XSYOP0JjjyMz1irihvWywro82r.jpg  /g9Kb3RaLjsybI1jpqHQ3QZTCYpB.jpg   \n",
              "2     /clfyMMg00OiowO5uupKpVKjRwmV.jpg  /tuDhEdza074bA497bO9WFEPs6O6.jpg   \n",
              "3     /pFlaoHTZeyNkG83vxsAJiGzfSsa.jpg  /bQXAqRx2Fgc46uCVWgoPz5L5Dtr.jpg   \n",
              "5     /vx1u0uwxdlhV2MUzj4VlcMB0N6m.jpg  /9k7FnCP20c6FsXgBNJpQaB19LiU.jpg   \n",
              "...                                ...                               ...   \n",
              "2821  /tS0PedvA2mFO9VCHYwQpaU1K36U.jpg  /9MS8hAVIEJ1uPpyOmAOcr6fofvm.jpg   \n",
              "2822  /kTH7qEyvdDYMoQraQZm3LFKCge3.jpg  /ngYzIWyVgDor1TtGZ8fK7AFOdGr.jpg   \n",
              "2823   /LRPi6b6gpDyKuveut38S8R38NI.jpg  /5CUdP1wrg4S6yZrDHuW3JLohYLO.jpg   \n",
              "2824  /i0enkzsL5dPeneWnjl1fCWm6L7k.jpg  /uPYa165sraN2c8gZBM9C47g3JoU.jpg   \n",
              "2825  /vTtkQGC7qKlSRQJZYtAWAmYdH0A.jpg  /mo57hzhW3BcZL1f7MNteWKHsmlN.jpg   \n",
              "\n",
              "                                        recommendations  \n",
              "0     830784-663712-676701-829799-315162-1037858-881...  \n",
              "1     837881-668482-661374-860155-877269-791177-7365...  \n",
              "2     2454-10140-24257-21-1593-953-425-32657-950-809...  \n",
              "3     485470-855440-663712-829799-505642-642721-1023...  \n",
              "5             791177-774752-593643-505642-744114-661374  \n",
              "...                                                 ...  \n",
              "2821  39354-12133-784846-997439-400160-3989-8872-496...  \n",
              "2822  15969-812-14128-13761-10898-18269-10530-10545-...  \n",
              "2823  946327-923632-928338-20755-853354-653723-32041...  \n",
              "2824  389541-335-429-769-240-1578-11778-385910-524-1...  \n",
              "2825  962920-857700-893086-826241-859453-513692-7386...  \n",
              "\n",
              "[2000 rows x 20 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-af8e1a2b-9f51-4ab2-af0c-ee421e3fd55a\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>id</th>\n",
              "      <th>title</th>\n",
              "      <th>genres</th>\n",
              "      <th>original_language</th>\n",
              "      <th>overview</th>\n",
              "      <th>popularity</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>release_date</th>\n",
              "      <th>budget</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>status</th>\n",
              "      <th>tagline</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>credits</th>\n",
              "      <th>keywords</th>\n",
              "      <th>poster_path</th>\n",
              "      <th>backdrop_path</th>\n",
              "      <th>recommendations</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>76600</td>\n",
              "      <td>Avatar: The Way of Water</td>\n",
              "      <td>Science Fiction-Adventure-Action</td>\n",
              "      <td>en</td>\n",
              "      <td>Set more than a decade after the events of the...</td>\n",
              "      <td>17043.610</td>\n",
              "      <td>Lightstorm Entertainment-20th Century Studios</td>\n",
              "      <td>2022-12-14</td>\n",
              "      <td>460000000.0</td>\n",
              "      <td>955081686.0</td>\n",
              "      <td>192.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>Return to Pandora.</td>\n",
              "      <td>8.007</td>\n",
              "      <td>1421.0</td>\n",
              "      <td>Sam Worthington-Zoe SaldaÃ±a-Sigourney Weaver-...</td>\n",
              "      <td>loss of loved one-dying and death-alien life-f...</td>\n",
              "      <td>/t6HIqrRAclMCA60NsSmeqe9RmNV.jpg</td>\n",
              "      <td>/s16H6tpK2utvwDtzZ8Qy4qm5Emw.jpg</td>\n",
              "      <td>830784-663712-676701-829799-315162-1037858-881...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>899112</td>\n",
              "      <td>Violent Night</td>\n",
              "      <td>Action-Comedy-Crime-Thriller</td>\n",
              "      <td>en</td>\n",
              "      <td>When a team of mercenaries breaks into a wealt...</td>\n",
              "      <td>4870.915</td>\n",
              "      <td>Universal Pictures-87North Productions</td>\n",
              "      <td>2022-11-30</td>\n",
              "      <td>20000000.0</td>\n",
              "      <td>55173750.0</td>\n",
              "      <td>112.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>You better watch out.</td>\n",
              "      <td>7.718</td>\n",
              "      <td>535.0</td>\n",
              "      <td>David Harbour-John Leguizamo-Beverly D'Angelo-...</td>\n",
              "      <td>holiday-santa claus-mercenary-saving christmas...</td>\n",
              "      <td>/1XSYOP0JjjyMz1irihvWywro82r.jpg</td>\n",
              "      <td>/g9Kb3RaLjsybI1jpqHQ3QZTCYpB.jpg</td>\n",
              "      <td>837881-668482-661374-860155-877269-791177-7365...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>411</td>\n",
              "      <td>The Chronicles of Narnia: The Lion, the Witch ...</td>\n",
              "      <td>Adventure-Family-Fantasy</td>\n",
              "      <td>en</td>\n",
              "      <td>Siblings Lucy Edmund Susan and Peter step thro...</td>\n",
              "      <td>4059.268</td>\n",
              "      <td>Walt Disney Pictures-Walden Media-C.S. Lewis C...</td>\n",
              "      <td>2005-12-07</td>\n",
              "      <td>180000000.0</td>\n",
              "      <td>745013115.0</td>\n",
              "      <td>143.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>Evil Has Reigned For 100 Years...</td>\n",
              "      <td>7.105</td>\n",
              "      <td>9016.0</td>\n",
              "      <td>Skandar Keynes-Georgie Henley-William Moseley-...</td>\n",
              "      <td>saving the world-sibling relationship-witch-ba...</td>\n",
              "      <td>/clfyMMg00OiowO5uupKpVKjRwmV.jpg</td>\n",
              "      <td>/tuDhEdza074bA497bO9WFEPs6O6.jpg</td>\n",
              "      <td>2454-10140-24257-21-1593-953-425-32657-950-809...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>436270</td>\n",
              "      <td>Black Adam</td>\n",
              "      <td>Action-Fantasy-Science Fiction</td>\n",
              "      <td>en</td>\n",
              "      <td>Nearly 5000 years after he was bestowed with t...</td>\n",
              "      <td>3964.678</td>\n",
              "      <td>New Line Cinema-Flynn Picture Company-Seven Bu...</td>\n",
              "      <td>2022-10-19</td>\n",
              "      <td>200000000.0</td>\n",
              "      <td>389000000.0</td>\n",
              "      <td>125.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>The world needed a hero. It got Black Adam.</td>\n",
              "      <td>7.228</td>\n",
              "      <td>3268.0</td>\n",
              "      <td>Dwayne Johnson-Aldis Hodge-Noah Centineo-Sarah...</td>\n",
              "      <td>lightning-anti hero-superhero-based on comic-d...</td>\n",
              "      <td>/pFlaoHTZeyNkG83vxsAJiGzfSsa.jpg</td>\n",
              "      <td>/bQXAqRx2Fgc46uCVWgoPz5L5Dtr.jpg</td>\n",
              "      <td>485470-855440-663712-829799-505642-642721-1023...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>555604</td>\n",
              "      <td>Guillermo del Toro's Pinocchio</td>\n",
              "      <td>Animation-Fantasy-Drama</td>\n",
              "      <td>en</td>\n",
              "      <td>During the rise of fascism in Mussolini's Ital...</td>\n",
              "      <td>2383.322</td>\n",
              "      <td>The Jim Henson Company-ShadowMachine-Double Da...</td>\n",
              "      <td>2022-11-09</td>\n",
              "      <td>35000000.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>117.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>Love will give you life.</td>\n",
              "      <td>8.458</td>\n",
              "      <td>1112.0</td>\n",
              "      <td>Gregory Mann-Ewan McGregor-David Bradley-Chris...</td>\n",
              "      <td>italy-based on novel or book-fascism-woodcutte...</td>\n",
              "      <td>/vx1u0uwxdlhV2MUzj4VlcMB0N6m.jpg</td>\n",
              "      <td>/9k7FnCP20c6FsXgBNJpQaB19LiU.jpg</td>\n",
              "      <td>791177-774752-593643-505642-744114-661374</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2821</th>\n",
              "      <td>9473</td>\n",
              "      <td>South Park: Bigger, Longer &amp; Uncut</td>\n",
              "      <td>Animation-Comedy</td>\n",
              "      <td>en</td>\n",
              "      <td>When the four boys see an R-rated movie featur...</td>\n",
              "      <td>31.530</td>\n",
              "      <td>Paramount-Warner Bros. Pictures-Scott Rudin Pr...</td>\n",
              "      <td>1999-06-30</td>\n",
              "      <td>21000000.0</td>\n",
              "      <td>83137603.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>UH-OH.</td>\n",
              "      <td>7.207</td>\n",
              "      <td>2208.0</td>\n",
              "      <td>Trey Parker-Matt Stone-Mary Kay Bergman-Isaac ...</td>\n",
              "      <td>hell-world supremacy-elementary school-atheist...</td>\n",
              "      <td>/tS0PedvA2mFO9VCHYwQpaU1K36U.jpg</td>\n",
              "      <td>/9MS8hAVIEJ1uPpyOmAOcr6fofvm.jpg</td>\n",
              "      <td>39354-12133-784846-997439-400160-3989-8872-496...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2822</th>\n",
              "      <td>11238</td>\n",
              "      <td>Aladdin and the King of Thieves</td>\n",
              "      <td>Adventure-Animation-Family</td>\n",
              "      <td>en</td>\n",
              "      <td>Legendary secrets are revealed as Aladdin and ...</td>\n",
              "      <td>31.526</td>\n",
              "      <td>Disney Television Animation</td>\n",
              "      <td>1996-05-20</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>The Spectacular Adventure Continues!</td>\n",
              "      <td>6.265</td>\n",
              "      <td>1633.0</td>\n",
              "      <td>Scott Weinger-Linda Larkin-Robin Williams-John...</td>\n",
              "      <td>musical-flying carpet-orient-sequel-genie-arab...</td>\n",
              "      <td>/kTH7qEyvdDYMoQraQZm3LFKCge3.jpg</td>\n",
              "      <td>/ngYzIWyVgDor1TtGZ8fK7AFOdGr.jpg</td>\n",
              "      <td>15969-812-14128-13761-10898-18269-10530-10545-...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2823</th>\n",
              "      <td>913862</td>\n",
              "      <td>Downfall: The Case Against Boeing</td>\n",
              "      <td>Documentary</td>\n",
              "      <td>en</td>\n",
              "      <td>Investigators reveal how Boeingâs alleged pr...</td>\n",
              "      <td>31.523</td>\n",
              "      <td>Moxie Firecracker Films-Imagine Documentaries</td>\n",
              "      <td>2022-02-09</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>89.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7.100</td>\n",
              "      <td>108.0</td>\n",
              "      <td>John Fantasia</td>\n",
              "      <td>aviation-airplane crash</td>\n",
              "      <td>/LRPi6b6gpDyKuveut38S8R38NI.jpg</td>\n",
              "      <td>/5CUdP1wrg4S6yZrDHuW3JLohYLO.jpg</td>\n",
              "      <td>946327-923632-928338-20755-853354-653723-32041...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2824</th>\n",
              "      <td>311</td>\n",
              "      <td>Once Upon a Time in America</td>\n",
              "      <td>Drama-Crime</td>\n",
              "      <td>en</td>\n",
              "      <td>A former Prohibition-era Jewish gangster retur...</td>\n",
              "      <td>31.510</td>\n",
              "      <td>Warner Bros. Pictures-Rafran Cinematografica-P...</td>\n",
              "      <td>1984-05-23</td>\n",
              "      <td>30000000.0</td>\n",
              "      <td>5472914.0</td>\n",
              "      <td>229.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>Crime, passion and lust for power.</td>\n",
              "      <td>8.442</td>\n",
              "      <td>4443.0</td>\n",
              "      <td>Robert De Niro-James Woods-Elizabeth McGovern-...</td>\n",
              "      <td>new york city-life and death-corruption-street...</td>\n",
              "      <td>/i0enkzsL5dPeneWnjl1fCWm6L7k.jpg</td>\n",
              "      <td>/uPYa165sraN2c8gZBM9C47g3JoU.jpg</td>\n",
              "      <td>389541-335-429-769-240-1578-11778-385910-524-1...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2825</th>\n",
              "      <td>763788</td>\n",
              "      <td>Dangerous</td>\n",
              "      <td>Action-Thriller</td>\n",
              "      <td>en</td>\n",
              "      <td>A reformed sociopath heads to a remote island ...</td>\n",
              "      <td>31.500</td>\n",
              "      <td>Benaroya Pictures-Minds Eye Entertainment-Misc...</td>\n",
              "      <td>2021-11-05</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>99.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>Killer instincts die hard.</td>\n",
              "      <td>6.200</td>\n",
              "      <td>351.0</td>\n",
              "      <td>Scott Eastwood-Mel Gibson-Tyrese Gibson-Kevin ...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>/vTtkQGC7qKlSRQJZYtAWAmYdH0A.jpg</td>\n",
              "      <td>/mo57hzhW3BcZL1f7MNteWKHsmlN.jpg</td>\n",
              "      <td>962920-857700-893086-826241-859453-513692-7386...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>2000 rows × 20 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-af8e1a2b-9f51-4ab2-af0c-ee421e3fd55a')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-af8e1a2b-9f51-4ab2-af0c-ee421e3fd55a button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-af8e1a2b-9f51-4ab2-af0c-ee421e3fd55a');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 3
        }
      ],
      "source": [
        "\n",
        "movies = movies[(movies['original_language']=='hi') | (movies['original_language']=='en')]\n",
        "movies[movies.title== 'Jab We Met']\n",
        "movies.vote_average.value_counts()\n",
        "movies = movies[movies.vote_average>=4]\n",
        "movies.popularity.value_counts()\n",
        "movies = movies[movies.popularity>5]\n",
        "movies.head(2000)"
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "vZemnmlxMXNP"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "eelW6jZAbvvT",
        "outputId": "2142ea81-4d59-4f17-fab5-b1d56d4ff81d"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "/usr/local/lib/python3.8/dist-packages/pandas/util/_decorators.py:311: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
            "  return func(*args, **kwargs)\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "           id                                              title  \\\n",
              "0       76600                           Avatar: The Way of Water   \n",
              "1      899112                                      Violent Night   \n",
              "2         411  The Chronicles of Narnia: The Lion, the Witch ...   \n",
              "3      436270                                         Black Adam   \n",
              "4      555604                     Guillermo del Toro's Pinocchio   \n",
              "...       ...                                                ...   \n",
              "22556  435557                         The Party's Just Beginning   \n",
              "22557   35739                                          Do or Die   \n",
              "22558   43759                            The Boy with Green Hair   \n",
              "22559   80775                                     Away All Boats   \n",
              "22560  421628                               A Rose for Christmas   \n",
              "\n",
              "                                 genres original_language  \\\n",
              "0      Science Fiction-Adventure-Action                en   \n",
              "1          Action-Comedy-Crime-Thriller                en   \n",
              "2              Adventure-Family-Fantasy                en   \n",
              "3        Action-Fantasy-Science Fiction                en   \n",
              "4               Animation-Fantasy-Drama                en   \n",
              "...                                 ...               ...   \n",
              "22556                      Drama-Comedy                en   \n",
              "22557                   Action-Thriller                en   \n",
              "22558               Drama-Comedy-Family                en   \n",
              "22559                         War-Drama                en   \n",
              "22560            Drama-TV Movie-Romance                en   \n",
              "\n",
              "                                                overview  popularity  \\\n",
              "0      Set more than a decade after the events of the...   17043.610   \n",
              "1      When a team of mercenaries breaks into a wealt...    4870.915   \n",
              "2      Siblings Lucy Edmund Susan and Peter step thro...    4059.268   \n",
              "3      Nearly 5000 years after he was bestowed with t...    3964.678   \n",
              "4      During the rise of fascism in Mussolini's Ital...    2383.322   \n",
              "...                                                  ...         ...   \n",
              "22556  In a bleak Inverness midwinter Luisaidh is car...       5.001   \n",
              "22557  Asian crime boss Kaneshiro captures two volupt...       5.001   \n",
              "22558  Peter an orphaned boy is adopted by Gramp Frye...       5.001   \n",
              "22559  The story of USS 'Belinda' a U.S. naval ship a...       5.001   \n",
              "22560  Andy is a passionate artist whose family has b...       5.001   \n",
              "\n",
              "                                    production_companies release_date  \\\n",
              "0          Lightstorm Entertainment-20th Century Studios   2022-12-14   \n",
              "1                 Universal Pictures-87North Productions   2022-11-30   \n",
              "2      Walt Disney Pictures-Walden Media-C.S. Lewis C...   2005-12-07   \n",
              "3      New Line Cinema-Flynn Picture Company-Seven Bu...   2022-10-19   \n",
              "4      The Jim Henson Company-ShadowMachine-Double Da...   2022-11-09   \n",
              "...                                                  ...          ...   \n",
              "22556            Mt. Hollywood Films-Synchronicity Films   2018-12-07   \n",
              "22557                                   Malibu Bay Films   1991-06-28   \n",
              "22558                                 RKO Radio Pictures   1948-11-26   \n",
              "22559                                 Universal Pictures   1956-08-16   \n",
              "22560                                 Muse Entertainment   2017-01-01   \n",
              "\n",
              "            budget      revenue  runtime    status  \\\n",
              "0      460000000.0  955081686.0    192.0  Released   \n",
              "1       20000000.0   55173750.0    112.0  Released   \n",
              "2      180000000.0  745013115.0    143.0  Released   \n",
              "3      200000000.0  389000000.0    125.0  Released   \n",
              "4       35000000.0          0.0    117.0  Released   \n",
              "...            ...          ...      ...       ...   \n",
              "22556          0.0          0.0     91.0  Released   \n",
              "22557          0.0          0.0     97.0  Released   \n",
              "22558          0.0          0.0     82.0  Released   \n",
              "22559          0.0          0.0    114.0  Released   \n",
              "22560          0.0          0.0     84.0  Released   \n",
              "\n",
              "                                                 tagline  vote_average  \\\n",
              "0                                     Return to Pandora.         8.007   \n",
              "1                                  You better watch out.         7.718   \n",
              "2                      Evil Has Reigned For 100 Years...         7.105   \n",
              "3            The world needed a hero. It got Black Adam.         7.228   \n",
              "4                               Love will give you life.         8.458   \n",
              "...                                                  ...           ...   \n",
              "22556                                                NaN         6.500   \n",
              "22557  It's a new kind of game ... The Rules will kil...         4.600   \n",
              "22558       Please don't tell why his hair turned green!         6.300   \n",
              "22559                The battle cry of the South Pacific         5.400   \n",
              "22560                                                NaN         5.600   \n",
              "\n",
              "       vote_count                                            credits  \\\n",
              "0          1421.0  Sam Worthington-Zoe SaldaÃ±a-Sigourney Weaver-...   \n",
              "1           535.0  David Harbour-John Leguizamo-Beverly D'Angelo-...   \n",
              "2          9016.0  Skandar Keynes-Georgie Henley-William Moseley-...   \n",
              "3          3268.0  Dwayne Johnson-Aldis Hodge-Noah Centineo-Sarah...   \n",
              "4          1112.0  Gregory Mann-Ewan McGregor-David Bradley-Chris...   \n",
              "...           ...                                                ...   \n",
              "22556        43.0  Karen Gillan-Lee Pace-Matthew Beard-Paul Higgi...   \n",
              "22557        24.0  Pat Morita-Erik Estrada-Dona Speir-Roberta Vas...   \n",
              "22558        52.0  Pat OâBrien-Robert Ryan-Barbara Hale-Dean St...   \n",
              "22559        13.0  Jeff Chandler-George Nader-Lex Barker-Julie Ad...   \n",
              "22560        35.0  Rachel Boston-Marc Bendavid-Nels Lennarson-Dar...   \n",
              "\n",
              "                                                keywords  \\\n",
              "0      loss of loved one-dying and death-alien life-f...   \n",
              "1      holiday-santa claus-mercenary-saving christmas...   \n",
              "2      saving the world-sibling relationship-witch-ba...   \n",
              "3      lightning-anti hero-superhero-based on comic-d...   \n",
              "4      italy-based on novel or book-fascism-woodcutte...   \n",
              "...                                                  ...   \n",
              "22556  suicide-depression-best friend-drinking-midwin...   \n",
              "22557                             assassin-federal agent   \n",
              "22558  hair-pacifist message-conformism-early cold wa...   \n",
              "22559                               pacific-naval battle   \n",
              "22560      holiday-new year's eve-artist-float-christmas   \n",
              "\n",
              "                            poster_path                     backdrop_path  \n",
              "0      /t6HIqrRAclMCA60NsSmeqe9RmNV.jpg  /s16H6tpK2utvwDtzZ8Qy4qm5Emw.jpg  \n",
              "1      /1XSYOP0JjjyMz1irihvWywro82r.jpg  /g9Kb3RaLjsybI1jpqHQ3QZTCYpB.jpg  \n",
              "2      /clfyMMg00OiowO5uupKpVKjRwmV.jpg  /tuDhEdza074bA497bO9WFEPs6O6.jpg  \n",
              "3      /pFlaoHTZeyNkG83vxsAJiGzfSsa.jpg  /bQXAqRx2Fgc46uCVWgoPz5L5Dtr.jpg  \n",
              "4      /vx1u0uwxdlhV2MUzj4VlcMB0N6m.jpg  /9k7FnCP20c6FsXgBNJpQaB19LiU.jpg  \n",
              "...                                 ...                               ...  \n",
              "22556  /dkQGIm3g4gQIm6sme3P1cHHexnt.jpg  /aDidRYJQE69yUQWFNUtHw6uME09.jpg  \n",
              "22557  /Avtey3NxkTcrnn6youFa6GW0BFm.jpg  /wYZBJFSlAuQ29GmCXqDvTbM6ABZ.jpg  \n",
              "22558  /a2secYe7o6mDllV6PAgrnaCaCzz.jpg  /axLBB4Q6mgCuy1W0cTfkY4IdUSd.jpg  \n",
              "22559  /dyyRfeB45ZUx9JhFKL0L9FS9wOU.jpg  /6T5WkjSQlakJPq1slvb8WEPV85q.jpg  \n",
              "22560  /vnyZQbJ3iy01Jliaz43gTvLi5qs.jpg  /rSK14QXt6TZmGnPWB8Lpt1AqwHn.jpg  \n",
              "\n",
              "[22561 rows x 19 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-e4ca2645-3094-4143-b086-1968eeee5e2e\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>id</th>\n",
              "      <th>title</th>\n",
              "      <th>genres</th>\n",
              "      <th>original_language</th>\n",
              "      <th>overview</th>\n",
              "      <th>popularity</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>release_date</th>\n",
              "      <th>budget</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>status</th>\n",
              "      <th>tagline</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>credits</th>\n",
              "      <th>keywords</th>\n",
              "      <th>poster_path</th>\n",
              "      <th>backdrop_path</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>76600</td>\n",
              "      <td>Avatar: The Way of Water</td>\n",
              "      <td>Science Fiction-Adventure-Action</td>\n",
              "      <td>en</td>\n",
              "      <td>Set more than a decade after the events of the...</td>\n",
              "      <td>17043.610</td>\n",
              "      <td>Lightstorm Entertainment-20th Century Studios</td>\n",
              "      <td>2022-12-14</td>\n",
              "      <td>460000000.0</td>\n",
              "      <td>955081686.0</td>\n",
              "      <td>192.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>Return to Pandora.</td>\n",
              "      <td>8.007</td>\n",
              "      <td>1421.0</td>\n",
              "      <td>Sam Worthington-Zoe SaldaÃ±a-Sigourney Weaver-...</td>\n",
              "      <td>loss of loved one-dying and death-alien life-f...</td>\n",
              "      <td>/t6HIqrRAclMCA60NsSmeqe9RmNV.jpg</td>\n",
              "      <td>/s16H6tpK2utvwDtzZ8Qy4qm5Emw.jpg</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>899112</td>\n",
              "      <td>Violent Night</td>\n",
              "      <td>Action-Comedy-Crime-Thriller</td>\n",
              "      <td>en</td>\n",
              "      <td>When a team of mercenaries breaks into a wealt...</td>\n",
              "      <td>4870.915</td>\n",
              "      <td>Universal Pictures-87North Productions</td>\n",
              "      <td>2022-11-30</td>\n",
              "      <td>20000000.0</td>\n",
              "      <td>55173750.0</td>\n",
              "      <td>112.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>You better watch out.</td>\n",
              "      <td>7.718</td>\n",
              "      <td>535.0</td>\n",
              "      <td>David Harbour-John Leguizamo-Beverly D'Angelo-...</td>\n",
              "      <td>holiday-santa claus-mercenary-saving christmas...</td>\n",
              "      <td>/1XSYOP0JjjyMz1irihvWywro82r.jpg</td>\n",
              "      <td>/g9Kb3RaLjsybI1jpqHQ3QZTCYpB.jpg</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>411</td>\n",
              "      <td>The Chronicles of Narnia: The Lion, the Witch ...</td>\n",
              "      <td>Adventure-Family-Fantasy</td>\n",
              "      <td>en</td>\n",
              "      <td>Siblings Lucy Edmund Susan and Peter step thro...</td>\n",
              "      <td>4059.268</td>\n",
              "      <td>Walt Disney Pictures-Walden Media-C.S. Lewis C...</td>\n",
              "      <td>2005-12-07</td>\n",
              "      <td>180000000.0</td>\n",
              "      <td>745013115.0</td>\n",
              "      <td>143.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>Evil Has Reigned For 100 Years...</td>\n",
              "      <td>7.105</td>\n",
              "      <td>9016.0</td>\n",
              "      <td>Skandar Keynes-Georgie Henley-William Moseley-...</td>\n",
              "      <td>saving the world-sibling relationship-witch-ba...</td>\n",
              "      <td>/clfyMMg00OiowO5uupKpVKjRwmV.jpg</td>\n",
              "      <td>/tuDhEdza074bA497bO9WFEPs6O6.jpg</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>436270</td>\n",
              "      <td>Black Adam</td>\n",
              "      <td>Action-Fantasy-Science Fiction</td>\n",
              "      <td>en</td>\n",
              "      <td>Nearly 5000 years after he was bestowed with t...</td>\n",
              "      <td>3964.678</td>\n",
              "      <td>New Line Cinema-Flynn Picture Company-Seven Bu...</td>\n",
              "      <td>2022-10-19</td>\n",
              "      <td>200000000.0</td>\n",
              "      <td>389000000.0</td>\n",
              "      <td>125.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>The world needed a hero. It got Black Adam.</td>\n",
              "      <td>7.228</td>\n",
              "      <td>3268.0</td>\n",
              "      <td>Dwayne Johnson-Aldis Hodge-Noah Centineo-Sarah...</td>\n",
              "      <td>lightning-anti hero-superhero-based on comic-d...</td>\n",
              "      <td>/pFlaoHTZeyNkG83vxsAJiGzfSsa.jpg</td>\n",
              "      <td>/bQXAqRx2Fgc46uCVWgoPz5L5Dtr.jpg</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>555604</td>\n",
              "      <td>Guillermo del Toro's Pinocchio</td>\n",
              "      <td>Animation-Fantasy-Drama</td>\n",
              "      <td>en</td>\n",
              "      <td>During the rise of fascism in Mussolini's Ital...</td>\n",
              "      <td>2383.322</td>\n",
              "      <td>The Jim Henson Company-ShadowMachine-Double Da...</td>\n",
              "      <td>2022-11-09</td>\n",
              "      <td>35000000.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>117.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>Love will give you life.</td>\n",
              "      <td>8.458</td>\n",
              "      <td>1112.0</td>\n",
              "      <td>Gregory Mann-Ewan McGregor-David Bradley-Chris...</td>\n",
              "      <td>italy-based on novel or book-fascism-woodcutte...</td>\n",
              "      <td>/vx1u0uwxdlhV2MUzj4VlcMB0N6m.jpg</td>\n",
              "      <td>/9k7FnCP20c6FsXgBNJpQaB19LiU.jpg</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22556</th>\n",
              "      <td>435557</td>\n",
              "      <td>The Party's Just Beginning</td>\n",
              "      <td>Drama-Comedy</td>\n",
              "      <td>en</td>\n",
              "      <td>In a bleak Inverness midwinter Luisaidh is car...</td>\n",
              "      <td>5.001</td>\n",
              "      <td>Mt. Hollywood Films-Synchronicity Films</td>\n",
              "      <td>2018-12-07</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>91.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6.500</td>\n",
              "      <td>43.0</td>\n",
              "      <td>Karen Gillan-Lee Pace-Matthew Beard-Paul Higgi...</td>\n",
              "      <td>suicide-depression-best friend-drinking-midwin...</td>\n",
              "      <td>/dkQGIm3g4gQIm6sme3P1cHHexnt.jpg</td>\n",
              "      <td>/aDidRYJQE69yUQWFNUtHw6uME09.jpg</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22557</th>\n",
              "      <td>35739</td>\n",
              "      <td>Do or Die</td>\n",
              "      <td>Action-Thriller</td>\n",
              "      <td>en</td>\n",
              "      <td>Asian crime boss Kaneshiro captures two volupt...</td>\n",
              "      <td>5.001</td>\n",
              "      <td>Malibu Bay Films</td>\n",
              "      <td>1991-06-28</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>97.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>It's a new kind of game ... The Rules will kil...</td>\n",
              "      <td>4.600</td>\n",
              "      <td>24.0</td>\n",
              "      <td>Pat Morita-Erik Estrada-Dona Speir-Roberta Vas...</td>\n",
              "      <td>assassin-federal agent</td>\n",
              "      <td>/Avtey3NxkTcrnn6youFa6GW0BFm.jpg</td>\n",
              "      <td>/wYZBJFSlAuQ29GmCXqDvTbM6ABZ.jpg</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22558</th>\n",
              "      <td>43759</td>\n",
              "      <td>The Boy with Green Hair</td>\n",
              "      <td>Drama-Comedy-Family</td>\n",
              "      <td>en</td>\n",
              "      <td>Peter an orphaned boy is adopted by Gramp Frye...</td>\n",
              "      <td>5.001</td>\n",
              "      <td>RKO Radio Pictures</td>\n",
              "      <td>1948-11-26</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>Please don't tell why his hair turned green!</td>\n",
              "      <td>6.300</td>\n",
              "      <td>52.0</td>\n",
              "      <td>Pat OâBrien-Robert Ryan-Barbara Hale-Dean St...</td>\n",
              "      <td>hair-pacifist message-conformism-early cold wa...</td>\n",
              "      <td>/a2secYe7o6mDllV6PAgrnaCaCzz.jpg</td>\n",
              "      <td>/axLBB4Q6mgCuy1W0cTfkY4IdUSd.jpg</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22559</th>\n",
              "      <td>80775</td>\n",
              "      <td>Away All Boats</td>\n",
              "      <td>War-Drama</td>\n",
              "      <td>en</td>\n",
              "      <td>The story of USS 'Belinda' a U.S. naval ship a...</td>\n",
              "      <td>5.001</td>\n",
              "      <td>Universal Pictures</td>\n",
              "      <td>1956-08-16</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>114.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>The battle cry of the South Pacific</td>\n",
              "      <td>5.400</td>\n",
              "      <td>13.0</td>\n",
              "      <td>Jeff Chandler-George Nader-Lex Barker-Julie Ad...</td>\n",
              "      <td>pacific-naval battle</td>\n",
              "      <td>/dyyRfeB45ZUx9JhFKL0L9FS9wOU.jpg</td>\n",
              "      <td>/6T5WkjSQlakJPq1slvb8WEPV85q.jpg</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22560</th>\n",
              "      <td>421628</td>\n",
              "      <td>A Rose for Christmas</td>\n",
              "      <td>Drama-TV Movie-Romance</td>\n",
              "      <td>en</td>\n",
              "      <td>Andy is a passionate artist whose family has b...</td>\n",
              "      <td>5.001</td>\n",
              "      <td>Muse Entertainment</td>\n",
              "      <td>2017-01-01</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.600</td>\n",
              "      <td>35.0</td>\n",
              "      <td>Rachel Boston-Marc Bendavid-Nels Lennarson-Dar...</td>\n",
              "      <td>holiday-new year's eve-artist-float-christmas</td>\n",
              "      <td>/vnyZQbJ3iy01Jliaz43gTvLi5qs.jpg</td>\n",
              "      <td>/rSK14QXt6TZmGnPWB8Lpt1AqwHn.jpg</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>22561 rows × 19 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-e4ca2645-3094-4143-b086-1968eeee5e2e')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-e4ca2645-3094-4143-b086-1968eeee5e2e button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-e4ca2645-3094-4143-b086-1968eeee5e2e');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 4
        }
      ],
      "source": [
        "movies.head(2)\n",
        "movies = movies[movies['genres']!='Music']\n",
        "movies.dropna(subset=['genres', 'keywords'], how = 'all', inplace=True)\n",
        "movies= movies[movies['title'].isna()==False]\n",
        "movies['genres'].fillna('Unknown_genre', inplace=True)\n",
        "movies['keywords'].fillna('Unknown_keyword', inplace=True)\n",
        "movies.reset_index(inplace=True)\n",
        "movies.drop(['index', 'recommendations'], axis = 1, inplace=True)\n",
        "# movies.to_csv('movies_cleaned.csv')\n",
        "movies.isna().sum()\n",
        "moviesb= movies.copy()\n",
        "wanted_keywords = movies['keywords'].str.split('-').explode().value_counts().index.tolist()[:500]\n",
        "wanted_keywords\n",
        "movies"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "HOyXcbOVWzjJ",
        "outputId": "6a28bde8-8647-4b1c-dfc9-9e49c7fcaf54"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Unknown_keyword           3501\n",
              "based on novel or book    1505\n",
              "woman director            1233\n",
              "murder                    1106\n",
              "christmas                  717\n",
              "                          ... \n",
              "bank                        46\n",
              "supernatural power          46\n",
              "wheelchair                  45\n",
              "pornography                 45\n",
              "comedian                    45\n",
              "Name: keywords, Length: 500, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 5
        }
      ],
      "source": [
        "moviesb.genres = [[val.strip() for val in sublist] for sublist in moviesb['genres'].str.split('-')]\n",
        "moviesb.keywords = [[val.strip() for val in sublist] for sublist in moviesb.keywords.str.split('-')]\n",
        "moviesb[['genres', 'keywords']]\n",
        "moviesb['keywords'] = moviesb['keywords'].apply(lambda l: [x for x in l if x in wanted_keywords])\n",
        "moviesb['keywords'].explode().value_counts()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "juAPTWrYXRan",
        "outputId": "70118aa9-56dd-4c38-dae6-9da2cfb51868"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "           id                                              title  \\\n",
              "0       76600                           Avatar: The Way of Water   \n",
              "1      899112                                      Violent Night   \n",
              "2         411  The Chronicles of Narnia: The Lion, the Witch ...   \n",
              "3      436270                                         Black Adam   \n",
              "4      555604                     Guillermo del Toro's Pinocchio   \n",
              "...       ...                                                ...   \n",
              "22556  435557                         The Party's Just Beginning   \n",
              "22557   35739                                          Do or Die   \n",
              "22558   43759                            The Boy with Green Hair   \n",
              "22559   80775                                     Away All Boats   \n",
              "22560  421628                               A Rose for Christmas   \n",
              "\n",
              "                                     genres original_language  \\\n",
              "0      [Science Fiction, Adventure, Action]                en   \n",
              "1         [Action, Comedy, Crime, Thriller]                en   \n",
              "2              [Adventure, Family, Fantasy]                en   \n",
              "3        [Action, Fantasy, Science Fiction]                en   \n",
              "4               [Animation, Fantasy, Drama]                en   \n",
              "...                                     ...               ...   \n",
              "22556                       [Drama, Comedy]                en   \n",
              "22557                    [Action, Thriller]                en   \n",
              "22558               [Drama, Comedy, Family]                en   \n",
              "22559                          [War, Drama]                en   \n",
              "22560            [Drama, TV Movie, Romance]                en   \n",
              "\n",
              "                                                overview  popularity  \\\n",
              "0      Set more than a decade after the events of the...   17043.610   \n",
              "1      When a team of mercenaries breaks into a wealt...    4870.915   \n",
              "2      Siblings Lucy Edmund Susan and Peter step thro...    4059.268   \n",
              "3      Nearly 5000 years after he was bestowed with t...    3964.678   \n",
              "4      During the rise of fascism in Mussolini's Ital...    2383.322   \n",
              "...                                                  ...         ...   \n",
              "22556  In a bleak Inverness midwinter Luisaidh is car...       5.001   \n",
              "22557  Asian crime boss Kaneshiro captures two volupt...       5.001   \n",
              "22558  Peter an orphaned boy is adopted by Gramp Frye...       5.001   \n",
              "22559  The story of USS 'Belinda' a U.S. naval ship a...       5.001   \n",
              "22560  Andy is a passionate artist whose family has b...       5.001   \n",
              "\n",
              "                                    production_companies release_date  \\\n",
              "0          Lightstorm Entertainment-20th Century Studios   2022-12-14   \n",
              "1                 Universal Pictures-87North Productions   2022-11-30   \n",
              "2      Walt Disney Pictures-Walden Media-C.S. Lewis C...   2005-12-07   \n",
              "3      New Line Cinema-Flynn Picture Company-Seven Bu...   2022-10-19   \n",
              "4      The Jim Henson Company-ShadowMachine-Double Da...   2022-11-09   \n",
              "...                                                  ...          ...   \n",
              "22556            Mt. Hollywood Films-Synchronicity Films   2018-12-07   \n",
              "22557                                   Malibu Bay Films   1991-06-28   \n",
              "22558                                 RKO Radio Pictures   1948-11-26   \n",
              "22559                                 Universal Pictures   1956-08-16   \n",
              "22560                                 Muse Entertainment   2017-01-01   \n",
              "\n",
              "            budget      revenue  runtime    status  \\\n",
              "0      460000000.0  955081686.0    192.0  Released   \n",
              "1       20000000.0   55173750.0    112.0  Released   \n",
              "2      180000000.0  745013115.0    143.0  Released   \n",
              "3      200000000.0  389000000.0    125.0  Released   \n",
              "4       35000000.0          0.0    117.0  Released   \n",
              "...            ...          ...      ...       ...   \n",
              "22556          0.0          0.0     91.0  Released   \n",
              "22557          0.0          0.0     97.0  Released   \n",
              "22558          0.0          0.0     82.0  Released   \n",
              "22559          0.0          0.0    114.0  Released   \n",
              "22560          0.0          0.0     84.0  Released   \n",
              "\n",
              "                                                 tagline  vote_average  \\\n",
              "0                                     Return to Pandora.         8.007   \n",
              "1                                  You better watch out.         7.718   \n",
              "2                      Evil Has Reigned For 100 Years...         7.105   \n",
              "3            The world needed a hero. It got Black Adam.         7.228   \n",
              "4                               Love will give you life.         8.458   \n",
              "...                                                  ...           ...   \n",
              "22556                                                NaN         6.500   \n",
              "22557  It's a new kind of game ... The Rules will kil...         4.600   \n",
              "22558       Please don't tell why his hair turned green!         6.300   \n",
              "22559                The battle cry of the South Pacific         5.400   \n",
              "22560                                                NaN         5.600   \n",
              "\n",
              "       vote_count                                            credits  \\\n",
              "0          1421.0  Sam Worthington-Zoe SaldaÃ±a-Sigourney Weaver-...   \n",
              "1           535.0  David Harbour-John Leguizamo-Beverly D'Angelo-...   \n",
              "2          9016.0  Skandar Keynes-Georgie Henley-William Moseley-...   \n",
              "3          3268.0  Dwayne Johnson-Aldis Hodge-Noah Centineo-Sarah...   \n",
              "4          1112.0  Gregory Mann-Ewan McGregor-David Bradley-Chris...   \n",
              "...           ...                                                ...   \n",
              "22556        43.0  Karen Gillan-Lee Pace-Matthew Beard-Paul Higgi...   \n",
              "22557        24.0  Pat Morita-Erik Estrada-Dona Speir-Roberta Vas...   \n",
              "22558        52.0  Pat OâBrien-Robert Ryan-Barbara Hale-Dean St...   \n",
              "22559        13.0  Jeff Chandler-George Nader-Lex Barker-Julie Ad...   \n",
              "22560        35.0  Rachel Boston-Marc Bendavid-Nels Lennarson-Dar...   \n",
              "\n",
              "                                                keywords  \\\n",
              "0      [loss of loved one, dying and death, alien lif...   \n",
              "1      [holiday, santa claus, mercenary, duringcredit...   \n",
              "2      [saving the world, sibling relationship, witch...   \n",
              "3      [anti hero, superhero, based on comic, demon, ...   \n",
              "4      [italy, based on novel or book, musical, stop ...   \n",
              "...                                                  ...   \n",
              "22556                 [suicide, depression, best friend]   \n",
              "22557                                         [assassin]   \n",
              "22558                                                 []   \n",
              "22559                                                 []   \n",
              "22560                       [holiday, artist, christmas]   \n",
              "\n",
              "                            poster_path                     backdrop_path  \\\n",
              "0      /t6HIqrRAclMCA60NsSmeqe9RmNV.jpg  /s16H6tpK2utvwDtzZ8Qy4qm5Emw.jpg   \n",
              "1      /1XSYOP0JjjyMz1irihvWywro82r.jpg  /g9Kb3RaLjsybI1jpqHQ3QZTCYpB.jpg   \n",
              "2      /clfyMMg00OiowO5uupKpVKjRwmV.jpg  /tuDhEdza074bA497bO9WFEPs6O6.jpg   \n",
              "3      /pFlaoHTZeyNkG83vxsAJiGzfSsa.jpg  /bQXAqRx2Fgc46uCVWgoPz5L5Dtr.jpg   \n",
              "4      /vx1u0uwxdlhV2MUzj4VlcMB0N6m.jpg  /9k7FnCP20c6FsXgBNJpQaB19LiU.jpg   \n",
              "...                                 ...                               ...   \n",
              "22556  /dkQGIm3g4gQIm6sme3P1cHHexnt.jpg  /aDidRYJQE69yUQWFNUtHw6uME09.jpg   \n",
              "22557  /Avtey3NxkTcrnn6youFa6GW0BFm.jpg  /wYZBJFSlAuQ29GmCXqDvTbM6ABZ.jpg   \n",
              "22558  /a2secYe7o6mDllV6PAgrnaCaCzz.jpg  /axLBB4Q6mgCuy1W0cTfkY4IdUSd.jpg   \n",
              "22559  /dyyRfeB45ZUx9JhFKL0L9FS9wOU.jpg  /6T5WkjSQlakJPq1slvb8WEPV85q.jpg   \n",
              "22560  /vnyZQbJ3iy01Jliaz43gTvLi5qs.jpg  /rSK14QXt6TZmGnPWB8Lpt1AqwHn.jpg   \n",
              "\n",
              "                                         genres_keywords  \n",
              "0      [Science Fiction, Adventure, Action, loss of l...  \n",
              "1      [Action, Comedy, Crime, Thriller, holiday, san...  \n",
              "2      [Adventure, Family, Fantasy, saving the world,...  \n",
              "3      [Action, Fantasy, Science Fiction, anti hero, ...  \n",
              "4      [Animation, Fantasy, Drama, italy, based on no...  \n",
              "...                                                  ...  \n",
              "22556  [Drama, Comedy, suicide, depression, best friend]  \n",
              "22557                       [Action, Thriller, assassin]  \n",
              "22558                            [Drama, Comedy, Family]  \n",
              "22559                                       [War, Drama]  \n",
              "22560  [Drama, TV Movie, Romance, holiday, artist, ch...  \n",
              "\n",
              "[22561 rows x 20 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-13db75b6-37d8-4dd2-b315-6162ef841d7a\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>id</th>\n",
              "      <th>title</th>\n",
              "      <th>genres</th>\n",
              "      <th>original_language</th>\n",
              "      <th>overview</th>\n",
              "      <th>popularity</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>release_date</th>\n",
              "      <th>budget</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>status</th>\n",
              "      <th>tagline</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>credits</th>\n",
              "      <th>keywords</th>\n",
              "      <th>poster_path</th>\n",
              "      <th>backdrop_path</th>\n",
              "      <th>genres_keywords</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>76600</td>\n",
              "      <td>Avatar: The Way of Water</td>\n",
              "      <td>[Science Fiction, Adventure, Action]</td>\n",
              "      <td>en</td>\n",
              "      <td>Set more than a decade after the events of the...</td>\n",
              "      <td>17043.610</td>\n",
              "      <td>Lightstorm Entertainment-20th Century Studios</td>\n",
              "      <td>2022-12-14</td>\n",
              "      <td>460000000.0</td>\n",
              "      <td>955081686.0</td>\n",
              "      <td>192.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>Return to Pandora.</td>\n",
              "      <td>8.007</td>\n",
              "      <td>1421.0</td>\n",
              "      <td>Sam Worthington-Zoe SaldaÃ±a-Sigourney Weaver-...</td>\n",
              "      <td>[loss of loved one, dying and death, alien lif...</td>\n",
              "      <td>/t6HIqrRAclMCA60NsSmeqe9RmNV.jpg</td>\n",
              "      <td>/s16H6tpK2utvwDtzZ8Qy4qm5Emw.jpg</td>\n",
              "      <td>[Science Fiction, Adventure, Action, loss of l...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>899112</td>\n",
              "      <td>Violent Night</td>\n",
              "      <td>[Action, Comedy, Crime, Thriller]</td>\n",
              "      <td>en</td>\n",
              "      <td>When a team of mercenaries breaks into a wealt...</td>\n",
              "      <td>4870.915</td>\n",
              "      <td>Universal Pictures-87North Productions</td>\n",
              "      <td>2022-11-30</td>\n",
              "      <td>20000000.0</td>\n",
              "      <td>55173750.0</td>\n",
              "      <td>112.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>You better watch out.</td>\n",
              "      <td>7.718</td>\n",
              "      <td>535.0</td>\n",
              "      <td>David Harbour-John Leguizamo-Beverly D'Angelo-...</td>\n",
              "      <td>[holiday, santa claus, mercenary, duringcredit...</td>\n",
              "      <td>/1XSYOP0JjjyMz1irihvWywro82r.jpg</td>\n",
              "      <td>/g9Kb3RaLjsybI1jpqHQ3QZTCYpB.jpg</td>\n",
              "      <td>[Action, Comedy, Crime, Thriller, holiday, san...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>411</td>\n",
              "      <td>The Chronicles of Narnia: The Lion, the Witch ...</td>\n",
              "      <td>[Adventure, Family, Fantasy]</td>\n",
              "      <td>en</td>\n",
              "      <td>Siblings Lucy Edmund Susan and Peter step thro...</td>\n",
              "      <td>4059.268</td>\n",
              "      <td>Walt Disney Pictures-Walden Media-C.S. Lewis C...</td>\n",
              "      <td>2005-12-07</td>\n",
              "      <td>180000000.0</td>\n",
              "      <td>745013115.0</td>\n",
              "      <td>143.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>Evil Has Reigned For 100 Years...</td>\n",
              "      <td>7.105</td>\n",
              "      <td>9016.0</td>\n",
              "      <td>Skandar Keynes-Georgie Henley-William Moseley-...</td>\n",
              "      <td>[saving the world, sibling relationship, witch...</td>\n",
              "      <td>/clfyMMg00OiowO5uupKpVKjRwmV.jpg</td>\n",
              "      <td>/tuDhEdza074bA497bO9WFEPs6O6.jpg</td>\n",
              "      <td>[Adventure, Family, Fantasy, saving the world,...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>436270</td>\n",
              "      <td>Black Adam</td>\n",
              "      <td>[Action, Fantasy, Science Fiction]</td>\n",
              "      <td>en</td>\n",
              "      <td>Nearly 5000 years after he was bestowed with t...</td>\n",
              "      <td>3964.678</td>\n",
              "      <td>New Line Cinema-Flynn Picture Company-Seven Bu...</td>\n",
              "      <td>2022-10-19</td>\n",
              "      <td>200000000.0</td>\n",
              "      <td>389000000.0</td>\n",
              "      <td>125.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>The world needed a hero. It got Black Adam.</td>\n",
              "      <td>7.228</td>\n",
              "      <td>3268.0</td>\n",
              "      <td>Dwayne Johnson-Aldis Hodge-Noah Centineo-Sarah...</td>\n",
              "      <td>[anti hero, superhero, based on comic, demon, ...</td>\n",
              "      <td>/pFlaoHTZeyNkG83vxsAJiGzfSsa.jpg</td>\n",
              "      <td>/bQXAqRx2Fgc46uCVWgoPz5L5Dtr.jpg</td>\n",
              "      <td>[Action, Fantasy, Science Fiction, anti hero, ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>555604</td>\n",
              "      <td>Guillermo del Toro's Pinocchio</td>\n",
              "      <td>[Animation, Fantasy, Drama]</td>\n",
              "      <td>en</td>\n",
              "      <td>During the rise of fascism in Mussolini's Ital...</td>\n",
              "      <td>2383.322</td>\n",
              "      <td>The Jim Henson Company-ShadowMachine-Double Da...</td>\n",
              "      <td>2022-11-09</td>\n",
              "      <td>35000000.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>117.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>Love will give you life.</td>\n",
              "      <td>8.458</td>\n",
              "      <td>1112.0</td>\n",
              "      <td>Gregory Mann-Ewan McGregor-David Bradley-Chris...</td>\n",
              "      <td>[italy, based on novel or book, musical, stop ...</td>\n",
              "      <td>/vx1u0uwxdlhV2MUzj4VlcMB0N6m.jpg</td>\n",
              "      <td>/9k7FnCP20c6FsXgBNJpQaB19LiU.jpg</td>\n",
              "      <td>[Animation, Fantasy, Drama, italy, based on no...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22556</th>\n",
              "      <td>435557</td>\n",
              "      <td>The Party's Just Beginning</td>\n",
              "      <td>[Drama, Comedy]</td>\n",
              "      <td>en</td>\n",
              "      <td>In a bleak Inverness midwinter Luisaidh is car...</td>\n",
              "      <td>5.001</td>\n",
              "      <td>Mt. Hollywood Films-Synchronicity Films</td>\n",
              "      <td>2018-12-07</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>91.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6.500</td>\n",
              "      <td>43.0</td>\n",
              "      <td>Karen Gillan-Lee Pace-Matthew Beard-Paul Higgi...</td>\n",
              "      <td>[suicide, depression, best friend]</td>\n",
              "      <td>/dkQGIm3g4gQIm6sme3P1cHHexnt.jpg</td>\n",
              "      <td>/aDidRYJQE69yUQWFNUtHw6uME09.jpg</td>\n",
              "      <td>[Drama, Comedy, suicide, depression, best friend]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22557</th>\n",
              "      <td>35739</td>\n",
              "      <td>Do or Die</td>\n",
              "      <td>[Action, Thriller]</td>\n",
              "      <td>en</td>\n",
              "      <td>Asian crime boss Kaneshiro captures two volupt...</td>\n",
              "      <td>5.001</td>\n",
              "      <td>Malibu Bay Films</td>\n",
              "      <td>1991-06-28</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>97.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>It's a new kind of game ... The Rules will kil...</td>\n",
              "      <td>4.600</td>\n",
              "      <td>24.0</td>\n",
              "      <td>Pat Morita-Erik Estrada-Dona Speir-Roberta Vas...</td>\n",
              "      <td>[assassin]</td>\n",
              "      <td>/Avtey3NxkTcrnn6youFa6GW0BFm.jpg</td>\n",
              "      <td>/wYZBJFSlAuQ29GmCXqDvTbM6ABZ.jpg</td>\n",
              "      <td>[Action, Thriller, assassin]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22558</th>\n",
              "      <td>43759</td>\n",
              "      <td>The Boy with Green Hair</td>\n",
              "      <td>[Drama, Comedy, Family]</td>\n",
              "      <td>en</td>\n",
              "      <td>Peter an orphaned boy is adopted by Gramp Frye...</td>\n",
              "      <td>5.001</td>\n",
              "      <td>RKO Radio Pictures</td>\n",
              "      <td>1948-11-26</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>Please don't tell why his hair turned green!</td>\n",
              "      <td>6.300</td>\n",
              "      <td>52.0</td>\n",
              "      <td>Pat OâBrien-Robert Ryan-Barbara Hale-Dean St...</td>\n",
              "      <td>[]</td>\n",
              "      <td>/a2secYe7o6mDllV6PAgrnaCaCzz.jpg</td>\n",
              "      <td>/axLBB4Q6mgCuy1W0cTfkY4IdUSd.jpg</td>\n",
              "      <td>[Drama, Comedy, Family]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22559</th>\n",
              "      <td>80775</td>\n",
              "      <td>Away All Boats</td>\n",
              "      <td>[War, Drama]</td>\n",
              "      <td>en</td>\n",
              "      <td>The story of USS 'Belinda' a U.S. naval ship a...</td>\n",
              "      <td>5.001</td>\n",
              "      <td>Universal Pictures</td>\n",
              "      <td>1956-08-16</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>114.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>The battle cry of the South Pacific</td>\n",
              "      <td>5.400</td>\n",
              "      <td>13.0</td>\n",
              "      <td>Jeff Chandler-George Nader-Lex Barker-Julie Ad...</td>\n",
              "      <td>[]</td>\n",
              "      <td>/dyyRfeB45ZUx9JhFKL0L9FS9wOU.jpg</td>\n",
              "      <td>/6T5WkjSQlakJPq1slvb8WEPV85q.jpg</td>\n",
              "      <td>[War, Drama]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22560</th>\n",
              "      <td>421628</td>\n",
              "      <td>A Rose for Christmas</td>\n",
              "      <td>[Drama, TV Movie, Romance]</td>\n",
              "      <td>en</td>\n",
              "      <td>Andy is a passionate artist whose family has b...</td>\n",
              "      <td>5.001</td>\n",
              "      <td>Muse Entertainment</td>\n",
              "      <td>2017-01-01</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>Released</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.600</td>\n",
              "      <td>35.0</td>\n",
              "      <td>Rachel Boston-Marc Bendavid-Nels Lennarson-Dar...</td>\n",
              "      <td>[holiday, artist, christmas]</td>\n",
              "      <td>/vnyZQbJ3iy01Jliaz43gTvLi5qs.jpg</td>\n",
              "      <td>/rSK14QXt6TZmGnPWB8Lpt1AqwHn.jpg</td>\n",
              "      <td>[Drama, TV Movie, Romance, holiday, artist, ch...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>22561 rows × 20 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-13db75b6-37d8-4dd2-b315-6162ef841d7a')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-13db75b6-37d8-4dd2-b315-6162ef841d7a button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-13db75b6-37d8-4dd2-b315-6162ef841d7a');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 6
        }
      ],
      "source": [
        "moviesb['genres_keywords'] = moviesb['genres']+moviesb['keywords']\n",
        "moviesb"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "_Ixcyxy_Rk4x",
        "outputId": "942d829a-5011-496e-fa4c-6228b5ec7a68"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0        en\n",
              "1        en\n",
              "2        en\n",
              "3        en\n",
              "4        en\n",
              "         ..\n",
              "22556    en\n",
              "22557    en\n",
              "22558    en\n",
              "22559    en\n",
              "22560    en\n",
              "Name: original_language, Length: 22561, dtype: object"
            ]
          },
          "metadata": {},
          "execution_count": 7
        }
      ],
      "source": [
        "\n",
        "len(moviesb['genres_keywords'].explode().value_counts())\n",
        "moviesb.original_language.fillna('en')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "-dZWKab4beX7",
        "outputId": "6739b012-a76b-42b8-8f09-36e89e34c9fd"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['train_movies.sav']"
            ]
          },
          "metadata": {},
          "execution_count": 8
        }
      ],
      "source": [
        "# preprocess = Pipeline([('count_vectorizer', CountVectorizer(analyzer=set))])\n",
        "# pipelines = ColumnTransformer([('vectorizer', preprocess, 'genres_keywords')])\n",
        "# train_movies = pipelines.fit_transform(moviesb)\n",
        "\n",
        "train_movies = ColumnTransformer([\n",
        "                ('cnt_vect', Pipeline([('vectorizer', CountVectorizer(analyzer=set))]), 'genres_keywords'),\n",
        "                ('cat', Pipeline([('ord', OneHotEncoder()) ]), ['original_language'])]\n",
        "                ).fit_transform(moviesb)\n",
        "train_movies\n",
        "joblib.dump(train_movies, 'train_movies.sav')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "pWUGwsx9iIRX",
        "outputId": "0596ca97-ad56-4a89-8a33-f3352ef71b3f"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "NearestNeighbors(metric='cosine', n_neighbors=100)"
            ]
          },
          "metadata": {},
          "execution_count": 9
        }
      ],
      "source": [
        "movies_model = NearestNeighbors(n_neighbors= 100, metric='cosine')\n",
        "movies_model.fit(train_movies)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "STJzfn5ettJf",
        "outputId": "f87f32f7-635a-405a-95f3-fb20e0a34cf1"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(['Drishyam',\n",
              "  'Ittefaq',\n",
              "  'Ugly',\n",
              "  'Dhamaka',\n",
              "  'The Pledge',\n",
              "  'Passion',\n",
              "  'Badla',\n",
              "  'Te3n',\n",
              "  'The Big Sleep',\n",
              "  'Marlowe',\n",
              "  'Radhe',\n",
              "  'Deceiver',\n",
              "  \"River's Edge\",\n",
              "  'The Last House on the Left',\n",
              "  'Don',\n",
              "  'Woman of Desire',\n",
              "  'Midnight in the Garden of Good and Evil',\n",
              "  'A Wednesday!',\n",
              "  'The Girl on the Train',\n",
              "  'Chloe',\n",
              "  'Rustom',\n",
              "  'Revolver',\n",
              "  'Blind Date',\n",
              "  'Bubble',\n",
              "  'My Son, My Son, What Have Ye Done',\n",
              "  'Talvar',\n",
              "  'Raat Akeli Hai',\n",
              "  'Locked In',\n",
              "  'Vikram Vedha',\n",
              "  'Red Corner',\n",
              "  'In the Electric Mist',\n",
              "  'Double Indemnity',\n",
              "  'Murder',\n",
              "  'Talaash',\n",
              "  'In the Heat of the Night',\n",
              "  'Veronica Guerin',\n",
              "  'Berserk',\n",
              "  'Soni',\n",
              "  'Article 15',\n",
              "  'No One Killed Jessica',\n",
              "  'A Thursday',\n",
              "  'Soni',\n",
              "  'Omkara',\n",
              "  'Hustle',\n",
              "  'Mulholland Falls',\n",
              "  '11:14',\n",
              "  'I Confess',\n",
              "  'The Hollow',\n",
              "  'The Big Clock',\n",
              "  'Gaslight',\n",
              "  'The Narrow Margin',\n",
              "  'And Soon the Darkness',\n",
              "  \"The Cat's Meow\",\n",
              "  'Edge of Darkness',\n",
              "  'The Heart of Justice',\n",
              "  'Pride and Glory',\n",
              "  'Deadfall',\n",
              "  'Horsemen',\n",
              "  'Fire with Fire',\n",
              "  'The Limits of Control',\n",
              "  'Intrigo: Death of an Author',\n",
              "  'The Rake',\n",
              "  'Once Upon a Time in Mumbaai',\n",
              "  'The Blue Gardenia',\n",
              "  'Columbus Circle',\n",
              "  'Jesse Stone: Benefit of the Doubt',\n",
              "  'The Walker',\n",
              "  'Shimmer Lake',\n",
              "  'Jesse Stone: No Remorse',\n",
              "  'The Night Clerk',\n",
              "  'The Vanishing',\n",
              "  'Intrigo: Samaria',\n",
              "  'See No Evil',\n",
              "  'Cherry Crush',\n",
              "  'Judas Kiss',\n",
              "  'I Am All Girls',\n",
              "  'Secret in Their Eyes',\n",
              "  'Song of the Thin Man',\n",
              "  'Suburbicon',\n",
              "  'The Rake',\n",
              "  'Stolen',\n",
              "  'Red Stone',\n",
              "  'Raid',\n",
              "  'Into the Ashes',\n",
              "  'Mystery Street',\n",
              "  'Phantom Lady',\n",
              "  'Agneepath',\n",
              "  'Bandit',\n",
              "  'Race',\n",
              "  'Sleep, My Love',\n",
              "  'Haseen Dillruba',\n",
              "  '24 Exposures',\n",
              "  'Jesse Stone: Death in Paradise',\n",
              "  'Awakening the Zodiac',\n",
              "  'Perfect Sisters',\n",
              "  'The Stranger',\n",
              "  'Freeze Frame',\n",
              "  'Thar',\n",
              "  'City by the Sea',\n",
              "  'Meeting Evil'],\n",
              " array([[1.11022302e-16, 2.82862834e-01, 2.82862834e-01, 2.92893219e-01,\n",
              "         3.54502776e-01, 3.60990350e-01, 3.67544468e-01, 3.67544468e-01,\n",
              "         4.00000000e-01, 4.02385695e-01, 4.02385695e-01, 4.02385695e-01,\n",
              "         4.02385695e-01, 4.27922446e-01, 4.34314575e-01, 4.34314575e-01,\n",
              "         4.34314575e-01, 4.34314575e-01, 4.34314575e-01, 4.34314575e-01,\n",
              "         4.34314575e-01, 4.34314575e-01, 4.34314575e-01, 4.34314575e-01,\n",
              "         4.34314575e-01, 4.34314575e-01, 4.34314575e-01, 4.34314575e-01,\n",
              "         4.34314575e-01, 4.34314575e-01, 4.34314575e-01, 4.40983006e-01,\n",
              "         4.40983006e-01, 4.40983006e-01, 4.40983006e-01, 4.40983006e-01,\n",
              "         4.40983006e-01, 4.52277442e-01, 4.52277442e-01, 4.52277442e-01,\n",
              "         4.52277442e-01, 4.52277442e-01, 4.52277442e-01, 4.52277442e-01,\n",
              "         4.52277442e-01, 4.52277442e-01, 4.52277442e-01, 4.72953723e-01,\n",
              "         4.72953723e-01, 4.72953723e-01, 4.72953723e-01, 4.72953723e-01,\n",
              "         4.72953723e-01, 4.72953723e-01, 4.72953723e-01, 4.72953723e-01,\n",
              "         4.72953723e-01, 4.73765188e-01, 4.83602221e-01, 4.83602221e-01,\n",
              "         4.83602221e-01, 4.83602221e-01, 4.83602221e-01, 4.83602221e-01,\n",
              "         4.83602221e-01, 4.83602221e-01, 4.83602221e-01, 4.83602221e-01,\n",
              "         4.83602221e-01, 4.83602221e-01, 4.83602221e-01, 4.83602221e-01,\n",
              "         4.83602221e-01, 4.83602221e-01, 4.83602221e-01, 4.83602221e-01,\n",
              "         4.83602221e-01, 4.83602221e-01, 4.83602221e-01, 4.83602221e-01,\n",
              "         4.83602221e-01, 4.83602221e-01, 4.83602221e-01, 4.83602221e-01,\n",
              "         4.83602221e-01, 4.83602221e-01, 4.83602221e-01, 4.83602221e-01,\n",
              "         4.83602221e-01, 4.83602221e-01, 4.83602221e-01, 4.83602221e-01,\n",
              "         4.83602221e-01, 4.83602221e-01, 4.83602221e-01, 4.83602221e-01,\n",
              "         4.83602221e-01, 4.83602221e-01, 4.83602221e-01, 4.83602221e-01]]))"
            ]
          },
          "metadata": {},
          "execution_count": 10
        }
      ],
      "source": [
        "sample = train_movies.toarray()[moviesb.title[moviesb['title'].str.lower().str.contains('drishyam')].index[0]]\n",
        "distances_movies, indices_movies = movies_model.kneighbors([sample])\n",
        "\n",
        "recommended_movies = moviesb['title'].iloc[indices_movies.squeeze()].tolist()\n",
        "recommended_movies, distances_movies"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "3lPKU1yO7aS2",
        "outputId": "3061defe-899e-414b-e1ed-c640314f1d6b"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Looking in indexes: https://pypi.org/simple, https://us-python.pkg.dev/colab-wheels/public/simple/\n",
            "Collecting memory-profiler\n",
            "  Downloading memory_profiler-0.61.0-py3-none-any.whl (31 kB)\n",
            "Requirement already satisfied: psutil in /usr/local/lib/python3.8/dist-packages (from memory-profiler) (5.4.8)\n",
            "Installing collected packages: memory-profiler\n",
            "Successfully installed memory-profiler-0.61.0\n",
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 22561 entries, 0 to 22560\n",
            "Data columns (total 19 columns):\n",
            " #   Column                Non-Null Count  Dtype  \n",
            "---  ------                --------------  -----  \n",
            " 0   id                    22561 non-null  int64  \n",
            " 1   title                 22561 non-null  object \n",
            " 2   genres                22561 non-null  object \n",
            " 3   original_language     22561 non-null  object \n",
            " 4   overview              22542 non-null  object \n",
            " 5   popularity            22561 non-null  float64\n",
            " 6   production_companies  21187 non-null  object \n",
            " 7   release_date          22551 non-null  object \n",
            " 8   budget                22561 non-null  float64\n",
            " 9   revenue               22561 non-null  float64\n",
            " 10  runtime               22558 non-null  float64\n",
            " 11  status                22561 non-null  object \n",
            " 12  tagline               16164 non-null  object \n",
            " 13  vote_average          22561 non-null  float64\n",
            " 14  vote_count            22561 non-null  float64\n",
            " 15  credits               22375 non-null  object \n",
            " 16  keywords              22561 non-null  object \n",
            " 17  poster_path           22543 non-null  object \n",
            " 18  backdrop_path         21726 non-null  object \n",
            "dtypes: float64(6), int64(1), object(12)\n",
            "memory usage: 3.3+ MB\n"
          ]
        }
      ],
      "source": [
        "import json\n",
        "!pip install memory-profiler\n",
        "from memory_profiler import memory_usage\n",
        "\n",
        "def recommend(input='batman'):\n",
        "    input = [x.strip() for x in (input.lower()).split('|')]\n",
        "\n",
        "\n",
        "    samples=[]\n",
        "    for name in input:\n",
        "        samples.append(train_movies.toarray()[movies.index[movies['title'].str.lower().str.contains(name)]][0])\n",
        "    sample_mean = [sum(sub_list) / len(sub_list) for sub_list in zip(*samples)]\n",
        "    distances_movies, indices_movies = movies_model.kneighbors([sample_mean])\n",
        "    results = movies.loc[indices_movies.squeeze()]\n",
        "    results['Distances'] = distances_movies.squeeze()\n",
        "    return json.loads(results.to_json(orient='records'))\n",
        "\n",
        "train_movies.shape\n",
        "movies.info()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "mtAV2My073Vl",
        "outputId": "c2f2d770-1cae-48e4-ec33-e29cf638c16c"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "501.796875"
            ]
          },
          "metadata": {},
          "execution_count": 12
        }
      ],
      "source": [
        "max(memory_usage(proc=recommend))"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "uSCI5Hex8eIC",
        "outputId": "bae74bb6-fc23-4f51-ec17-b66233807047"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['Drishyam',\n",
              " 'Dhamaka',\n",
              " 'Andhadhun',\n",
              " 'Ittefaq',\n",
              " 'Ugly',\n",
              " 'Rustom',\n",
              " 'Vikram Vedha',\n",
              " 'An Action Hero',\n",
              " 'Raat Akeli Hai',\n",
              " 'Wanted',\n",
              " 'Darlings',\n",
              " 'Radhe',\n",
              " 'Raees',\n",
              " 'Wazir',\n",
              " 'Te3n',\n",
              " 'Baazigar',\n",
              " 'Hera Pheri',\n",
              " 'Badla',\n",
              " 'Article 15',\n",
              " 'A Thursday',\n",
              " 'Soni',\n",
              " 'Soni',\n",
              " 'No One Killed Jessica',\n",
              " 'Omkara',\n",
              " 'Song of the Thin Man',\n",
              " 'Monica, O My Darling',\n",
              " 'Special 26',\n",
              " 'Race',\n",
              " 'The Pledge',\n",
              " 'Thar',\n",
              " 'Raid',\n",
              " 'Deathtrap',\n",
              " 'Once Upon a Time in Mumbaai',\n",
              " 'Haseen Dillruba',\n",
              " 'Talaash',\n",
              " 'Holiday',\n",
              " 'Talvar',\n",
              " 'Raman Raghav 2.0',\n",
              " 'Bunty Aur Babli 2',\n",
              " 'Midnight in the Garden of Good and Evil',\n",
              " 'The Girl on the Train',\n",
              " 'Don',\n",
              " 'Badlapur',\n",
              " 'In the Electric Mist',\n",
              " 'Looop Lapeta',\n",
              " 'Revolver',\n",
              " 'A Wednesday!',\n",
              " 'Locked In',\n",
              " 'Red Corner',\n",
              " 'Walk All Over Me',\n",
              " 'Bhool Bhulaiyaa',\n",
              " 'Blackmail',\n",
              " 'Blind Date',\n",
              " 'My Son, My Son, What Have Ye Done',\n",
              " 'Dhoom',\n",
              " \"River's Edge\",\n",
              " 'Deceiver',\n",
              " 'Section 375',\n",
              " 'Burn Notice: The Fall of Sam Axe',\n",
              " 'Sooryavanshi',\n",
              " 'Passion',\n",
              " 'Jolly LLB 2',\n",
              " 'Take',\n",
              " 'Child of God',\n",
              " 'Sleeping with the Enemy',\n",
              " 'Guilty',\n",
              " 'Pihu',\n",
              " 'Emily the Criminal',\n",
              " 'Wetlands',\n",
              " 'The Oxford Murders',\n",
              " 'The Lookalike',\n",
              " 'A Death in the Gunj',\n",
              " 'Cops & Robbersons',\n",
              " 'The Sicilian',\n",
              " 'Jalsa',\n",
              " 'Pihu',\n",
              " 'Cecil B. Demented',\n",
              " 'Raja Natwarlal',\n",
              " 'Pihu',\n",
              " 'Maqbool',\n",
              " 'Nayak: The Real Hero',\n",
              " 'Vincent N Roxxy',\n",
              " 'Dobaaraa',\n",
              " 'Coolie No. 1',\n",
              " 'Jailbait',\n",
              " 'Runway 34',\n",
              " 'Murder by Decree',\n",
              " 'Layover',\n",
              " 'Raajneeti',\n",
              " 'Boiler Room',\n",
              " 'Dybbuk',\n",
              " 'Ray Donovan: The Movie',\n",
              " 'Basic Instinct 2',\n",
              " 'Kaminey',\n",
              " 'Veronica Guerin',\n",
              " 'Clue',\n",
              " 'A Shock to the System',\n",
              " 'Berserk',\n",
              " 'Zero Effect',\n",
              " 'Double Indemnity']"
            ]
          },
          "metadata": {},
          "execution_count": 13
        }
      ],
      "source": [
        "results_json = recommend('drishyam|andhadhun')\n",
        "results_df = pd.json_normalize(results_json)\n",
        "# results_df['English'].tolist()        # ise neeche likhde agar sirf naam ki predictions ki list dekhna chahta h to\n",
        "results_json\n",
        "results_df['title'].tolist()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "7SuIpSlk_v4D",
        "outputId": "fb4859e6-1fea-44e9-e0c4-cf971917268f"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['model_movies.sav']"
            ]
          },
          "metadata": {},
          "execution_count": 14
        }
      ],
      "source": [
        "\n",
        "\n",
        "movies.to_parquet('moviesfile.parquet', compression='GZIP')\n",
        "joblib.dump(train_movies, 'train_movies.sav')\n",
        "joblib.dump(movies_model, 'model_movies.sav')\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "s_Pk2bTFGHEp",
        "outputId": "e8b33d70-44fb-4111-d735-cc855875e878"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 22561 entries, 0 to 22560\n",
            "Data columns (total 19 columns):\n",
            " #   Column                Non-Null Count  Dtype  \n",
            "---  ------                --------------  -----  \n",
            " 0   id                    22561 non-null  int64  \n",
            " 1   title                 22561 non-null  object \n",
            " 2   genres                22561 non-null  object \n",
            " 3   original_language     22561 non-null  object \n",
            " 4   overview              22542 non-null  object \n",
            " 5   popularity            22561 non-null  float64\n",
            " 6   production_companies  21187 non-null  object \n",
            " 7   release_date          22551 non-null  object \n",
            " 8   budget                22561 non-null  float64\n",
            " 9   revenue               22561 non-null  float64\n",
            " 10  runtime               22558 non-null  float64\n",
            " 11  status                22561 non-null  object \n",
            " 12  tagline               16164 non-null  object \n",
            " 13  vote_average          22561 non-null  float64\n",
            " 14  vote_count            22561 non-null  float64\n",
            " 15  credits               22375 non-null  object \n",
            " 16  keywords              22561 non-null  object \n",
            " 17  poster_path           22543 non-null  object \n",
            " 18  backdrop_path         21726 non-null  object \n",
            "dtypes: float64(6), int64(1), object(12)\n",
            "memory usage: 3.3+ MB\n"
          ]
        }
      ],
      "source": [
        "# import fastparquet\n",
        "moviespar = pd.read_parquet('moviesfile.parquet')\n",
        "moviespar.info()"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "movies[['id', 'title', 'poster_path', 'release_date']].to_json(\"movies_list.json\", orient=\"records\")"
      ],
      "metadata": {
        "id": "sjNsnt0Y5g3L"
      },
      "execution_count": null,
      "outputs": []
    }
  ],
  "metadata": {
    "colab": {
      "provenance": [],
      "mount_file_id": "13kIxt2pyY_uew_oVxcjiZ7WNx_yuhGWU",
      "authorship_tag": "ABX9TyMXHKrcmFiH4/92VNjNRPjc"
    },
    "kernelspec": {
      "display_name": "Python 3",
      "name": "python3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}