Movie_Recommender.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyORDyasVtyRDmMD3p21hoWn",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/vishal-1230/Movie-Recommender-System/blob/main/Movie_Recommender.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import pandas as pd\n",
        "\n",
        "movies = pd.read_csv(\"tmdb_5000_movies.csv\")\n",
        "credits = pd.read_csv(\"tmdb_5000_credits.csv\")\n",
        "\n",
        "movies.info()\n",
        "credits.head()\n",
        "\n",
        "movies = movies.merge(credits, on=\"title\")\n",
        "\n",
        "import ast\n",
        "\n",
        "ast.literal_eval(credits['crew'][0])\n",
        "\n",
        "movies = movies[[\"movie_id\", \"title\", \"genres\", \"keywords\", \"overview\", \"cast\", \"crew\"]]\n",
        "movies.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 935
        },
        "id": "upvtGa3ha0Am",
        "outputId": "67200059-7a19-4b6c-9cb5-c032913c717e"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 4803 entries, 0 to 4802\n",
            "Data columns (total 20 columns):\n",
            " #   Column                Non-Null Count  Dtype  \n",
            "---  ------                --------------  -----  \n",
            " 0   budget                4803 non-null   int64  \n",
            " 1   genres                4803 non-null   object \n",
            " 2   homepage              1712 non-null   object \n",
            " 3   id                    4803 non-null   int64  \n",
            " 4   keywords              4803 non-null   object \n",
            " 5   original_language     4803 non-null   object \n",
            " 6   original_title        4803 non-null   object \n",
            " 7   overview              4800 non-null   object \n",
            " 8   popularity            4803 non-null   float64\n",
            " 9   production_companies  4803 non-null   object \n",
            " 10  production_countries  4803 non-null   object \n",
            " 11  release_date          4802 non-null   object \n",
            " 12  revenue               4803 non-null   int64  \n",
            " 13  runtime               4801 non-null   float64\n",
            " 14  spoken_languages      4803 non-null   object \n",
            " 15  status                4803 non-null   object \n",
            " 16  tagline               3959 non-null   object \n",
            " 17  title                 4803 non-null   object \n",
            " 18  vote_average          4803 non-null   float64\n",
            " 19  vote_count            4803 non-null   int64  \n",
            "dtypes: float64(3), int64(4), object(13)\n",
            "memory usage: 750.6+ KB\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   movie_id                                     title  \\\n",
              "0     19995                                    Avatar   \n",
              "1       285  Pirates of the Caribbean: At World's End   \n",
              "2    206647                                   Spectre   \n",
              "3     49026                     The Dark Knight Rises   \n",
              "4     49529                               John Carter   \n",
              "\n",
              "                                              genres  \\\n",
              "0  [{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...   \n",
              "1  [{\"id\": 12, \"name\": \"Adventure\"}, {\"id\": 14, \"...   \n",
              "2  [{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...   \n",
              "3  [{\"id\": 28, \"name\": \"Action\"}, {\"id\": 80, \"nam...   \n",
              "4  [{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...   \n",
              "\n",
              "                                            keywords  \\\n",
              "0  [{\"id\": 1463, \"name\": \"culture clash\"}, {\"id\":...   \n",
              "1  [{\"id\": 270, \"name\": \"ocean\"}, {\"id\": 726, \"na...   \n",
              "2  [{\"id\": 470, \"name\": \"spy\"}, {\"id\": 818, \"name...   \n",
              "3  [{\"id\": 849, \"name\": \"dc comics\"}, {\"id\": 853,...   \n",
              "4  [{\"id\": 818, \"name\": \"based on novel\"}, {\"id\":...   \n",
              "\n",
              "                                            overview  \\\n",
              "0  In the 22nd century, a paraplegic Marine is di...   \n",
              "1  Captain Barbossa, long believed to be dead, ha...   \n",
              "2  A cryptic message from Bond’s past sends him o...   \n",
              "3  Following the death of District Attorney Harve...   \n",
              "4  John Carter is a war-weary, former military ca...   \n",
              "\n",
              "                                                cast  \\\n",
              "0  [{\"cast_id\": 242, \"character\": \"Jake Sully\", \"...   \n",
              "1  [{\"cast_id\": 4, \"character\": \"Captain Jack Spa...   \n",
              "2  [{\"cast_id\": 1, \"character\": \"James Bond\", \"cr...   \n",
              "3  [{\"cast_id\": 2, \"character\": \"Bruce Wayne / Ba...   \n",
              "4  [{\"cast_id\": 5, \"character\": \"John Carter\", \"c...   \n",
              "\n",
              "                                                crew  \n",
              "0  [{\"credit_id\": \"52fe48009251416c750aca23\", \"de...  \n",
              "1  [{\"credit_id\": \"52fe4232c3a36847f800b579\", \"de...  \n",
              "2  [{\"credit_id\": \"54805967c3a36829b5002c41\", \"de...  \n",
              "3  [{\"credit_id\": \"52fe4781c3a36847f81398c3\", \"de...  \n",
              "4  [{\"credit_id\": \"52fe479ac3a36847f813eaa3\", \"de...  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-a7280b30-44d0-43db-ae00-8b2087eafa46\" 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>movie_id</th>\n",
              "      <th>title</th>\n",
              "      <th>genres</th>\n",
              "      <th>keywords</th>\n",
              "      <th>overview</th>\n",
              "      <th>cast</th>\n",
              "      <th>crew</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>19995</td>\n",
              "      <td>Avatar</td>\n",
              "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...</td>\n",
              "      <td>[{\"id\": 1463, \"name\": \"culture clash\"}, {\"id\":...</td>\n",
              "      <td>In the 22nd century, a paraplegic Marine is di...</td>\n",
              "      <td>[{\"cast_id\": 242, \"character\": \"Jake Sully\", \"...</td>\n",
              "      <td>[{\"credit_id\": \"52fe48009251416c750aca23\", \"de...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>285</td>\n",
              "      <td>Pirates of the Caribbean: At World's End</td>\n",
              "      <td>[{\"id\": 12, \"name\": \"Adventure\"}, {\"id\": 14, \"...</td>\n",
              "      <td>[{\"id\": 270, \"name\": \"ocean\"}, {\"id\": 726, \"na...</td>\n",
              "      <td>Captain Barbossa, long believed to be dead, ha...</td>\n",
              "      <td>[{\"cast_id\": 4, \"character\": \"Captain Jack Spa...</td>\n",
              "      <td>[{\"credit_id\": \"52fe4232c3a36847f800b579\", \"de...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>206647</td>\n",
              "      <td>Spectre</td>\n",
              "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...</td>\n",
              "      <td>[{\"id\": 470, \"name\": \"spy\"}, {\"id\": 818, \"name...</td>\n",
              "      <td>A cryptic message from Bond’s past sends him o...</td>\n",
              "      <td>[{\"cast_id\": 1, \"character\": \"James Bond\", \"cr...</td>\n",
              "      <td>[{\"credit_id\": \"54805967c3a36829b5002c41\", \"de...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>49026</td>\n",
              "      <td>The Dark Knight Rises</td>\n",
              "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 80, \"nam...</td>\n",
              "      <td>[{\"id\": 849, \"name\": \"dc comics\"}, {\"id\": 853,...</td>\n",
              "      <td>Following the death of District Attorney Harve...</td>\n",
              "      <td>[{\"cast_id\": 2, \"character\": \"Bruce Wayne / Ba...</td>\n",
              "      <td>[{\"credit_id\": \"52fe4781c3a36847f81398c3\", \"de...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>49529</td>\n",
              "      <td>John Carter</td>\n",
              "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...</td>\n",
              "      <td>[{\"id\": 818, \"name\": \"based on novel\"}, {\"id\":...</td>\n",
              "      <td>John Carter is a war-weary, former military ca...</td>\n",
              "      <td>[{\"cast_id\": 5, \"character\": \"John Carter\", \"c...</td>\n",
              "      <td>[{\"credit_id\": \"52fe479ac3a36847f813eaa3\", \"de...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a7280b30-44d0-43db-ae00-8b2087eafa46')\"\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 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\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",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\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-a7280b30-44d0-43db-ae00-8b2087eafa46 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-a7280b30-44d0-43db-ae00-8b2087eafa46');\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",
              "\n",
              "\n",
              "<div id=\"df-c7ed99d4-023a-486c-bfd3-783263a8ca06\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-c7ed99d4-023a-486c-bfd3-783263a8ca06')\"\n",
              "            title=\"Suggest charts\"\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",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-c7ed99d4-023a-486c-bfd3-783263a8ca06 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 1
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import ast\n",
        "movies[\"genres\"][0]\n",
        "\n",
        "def cleanGenres(genres):\n",
        "  genres = ast.literal_eval(genres)\n",
        "  new_genres = [i[\"name\"] for i in genres]\n",
        "  return \" \".join(new_genres)\n",
        "\n",
        "# print(cleanGenres('[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"name\": \"Adventure\"}, {\"id\": 14, \"name\": \"Fantasy\"}, {\"id\": 878, \"name\": \"Science Fiction\"}]'))\n",
        "movies[\"genres\"] = movies[\"genres\"].apply(cleanGenres)\n",
        "movies[\"keywords\"] = movies[\"keywords\"].apply(cleanGenres)\n",
        "movies.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 484
        },
        "id": "DRFiiuaJewOs",
        "outputId": "6cff052f-60b2-4db6-e53a-f2e234a67942"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   movie_id                                     title  \\\n",
              "0     19995                                    Avatar   \n",
              "1       285  Pirates of the Caribbean: At World's End   \n",
              "2    206647                                   Spectre   \n",
              "3     49026                     The Dark Knight Rises   \n",
              "4     49529                               John Carter   \n",
              "\n",
              "                                     genres  \\\n",
              "0  Action Adventure Fantasy Science Fiction   \n",
              "1                  Adventure Fantasy Action   \n",
              "2                    Action Adventure Crime   \n",
              "3               Action Crime Drama Thriller   \n",
              "4          Action Adventure Science Fiction   \n",
              "\n",
              "                                            keywords  \\\n",
              "0  culture clash future space war space colony so...   \n",
              "1  ocean drug abuse exotic island east india trad...   \n",
              "2  spy based on novel secret agent sequel mi6 bri...   \n",
              "3  dc comics crime fighter terrorist secret ident...   \n",
              "4  based on novel mars medallion space travel pri...   \n",
              "\n",
              "                                            overview  \\\n",
              "0  In the 22nd century, a paraplegic Marine is di...   \n",
              "1  Captain Barbossa, long believed to be dead, ha...   \n",
              "2  A cryptic message from Bond’s past sends him o...   \n",
              "3  Following the death of District Attorney Harve...   \n",
              "4  John Carter is a war-weary, former military ca...   \n",
              "\n",
              "                                                cast  \\\n",
              "0  [{\"cast_id\": 242, \"character\": \"Jake Sully\", \"...   \n",
              "1  [{\"cast_id\": 4, \"character\": \"Captain Jack Spa...   \n",
              "2  [{\"cast_id\": 1, \"character\": \"James Bond\", \"cr...   \n",
              "3  [{\"cast_id\": 2, \"character\": \"Bruce Wayne / Ba...   \n",
              "4  [{\"cast_id\": 5, \"character\": \"John Carter\", \"c...   \n",
              "\n",
              "                                                crew  \n",
              "0  [{\"credit_id\": \"52fe48009251416c750aca23\", \"de...  \n",
              "1  [{\"credit_id\": \"52fe4232c3a36847f800b579\", \"de...  \n",
              "2  [{\"credit_id\": \"54805967c3a36829b5002c41\", \"de...  \n",
              "3  [{\"credit_id\": \"52fe4781c3a36847f81398c3\", \"de...  \n",
              "4  [{\"credit_id\": \"52fe479ac3a36847f813eaa3\", \"de...  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-bbbc740e-1bdd-4473-af48-6a91148ab2c3\" 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>movie_id</th>\n",
              "      <th>title</th>\n",
              "      <th>genres</th>\n",
              "      <th>keywords</th>\n",
              "      <th>overview</th>\n",
              "      <th>cast</th>\n",
              "      <th>crew</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>19995</td>\n",
              "      <td>Avatar</td>\n",
              "      <td>Action Adventure Fantasy Science Fiction</td>\n",
              "      <td>culture clash future space war space colony so...</td>\n",
              "      <td>In the 22nd century, a paraplegic Marine is di...</td>\n",
              "      <td>[{\"cast_id\": 242, \"character\": \"Jake Sully\", \"...</td>\n",
              "      <td>[{\"credit_id\": \"52fe48009251416c750aca23\", \"de...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>285</td>\n",
              "      <td>Pirates of the Caribbean: At World's End</td>\n",
              "      <td>Adventure Fantasy Action</td>\n",
              "      <td>ocean drug abuse exotic island east india trad...</td>\n",
              "      <td>Captain Barbossa, long believed to be dead, ha...</td>\n",
              "      <td>[{\"cast_id\": 4, \"character\": \"Captain Jack Spa...</td>\n",
              "      <td>[{\"credit_id\": \"52fe4232c3a36847f800b579\", \"de...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>206647</td>\n",
              "      <td>Spectre</td>\n",
              "      <td>Action Adventure Crime</td>\n",
              "      <td>spy based on novel secret agent sequel mi6 bri...</td>\n",
              "      <td>A cryptic message from Bond’s past sends him o...</td>\n",
              "      <td>[{\"cast_id\": 1, \"character\": \"James Bond\", \"cr...</td>\n",
              "      <td>[{\"credit_id\": \"54805967c3a36829b5002c41\", \"de...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>49026</td>\n",
              "      <td>The Dark Knight Rises</td>\n",
              "      <td>Action Crime Drama Thriller</td>\n",
              "      <td>dc comics crime fighter terrorist secret ident...</td>\n",
              "      <td>Following the death of District Attorney Harve...</td>\n",
              "      <td>[{\"cast_id\": 2, \"character\": \"Bruce Wayne / Ba...</td>\n",
              "      <td>[{\"credit_id\": \"52fe4781c3a36847f81398c3\", \"de...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>49529</td>\n",
              "      <td>John Carter</td>\n",
              "      <td>Action Adventure Science Fiction</td>\n",
              "      <td>based on novel mars medallion space travel pri...</td>\n",
              "      <td>John Carter is a war-weary, former military ca...</td>\n",
              "      <td>[{\"cast_id\": 5, \"character\": \"John Carter\", \"c...</td>\n",
              "      <td>[{\"credit_id\": \"52fe479ac3a36847f813eaa3\", \"de...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-bbbc740e-1bdd-4473-af48-6a91148ab2c3')\"\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 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\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",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\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-bbbc740e-1bdd-4473-af48-6a91148ab2c3 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-bbbc740e-1bdd-4473-af48-6a91148ab2c3');\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",
              "\n",
              "\n",
              "<div id=\"df-73b59a43-188b-43a3-90fc-291938cbd98f\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-73b59a43-188b-43a3-90fc-291938cbd98f')\"\n",
              "            title=\"Suggest charts\"\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",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-73b59a43-188b-43a3-90fc-291938cbd98f button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 2
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "movies[\"cast\"][0]\n",
        "\n",
        "def cleanCast(cast):\n",
        "  cast = ast.literal_eval(cast)\n",
        "  chars = \"\"\n",
        "  for i in range(0, len(cast)):\n",
        "    if i < 3:\n",
        "      chars+=\" \"+cast[i]['character'].replace(\" \", \"\")\n",
        "    else:\n",
        "      break\n",
        "  return chars\n",
        "\n",
        "def cleanCrew(crew):\n",
        "  crew = ast.literal_eval(crew)\n",
        "  for i in crew:\n",
        "    if i['job'].lower() == \"director\":\n",
        "      return i['name'].replace(\" \", \"\")\n",
        "\n",
        "movies['cast'] = movies['cast'].apply(cleanCast)\n",
        "movies['crew'] = movies['crew'].apply(cleanCrew)"
      ],
      "metadata": {
        "id": "w1xLHmZAgmuV"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "movies.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 397
        },
        "id": "EXaf5d0_iss5",
        "outputId": "da2c1929-ec3f-48e2-df96-e14c107f94ad"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   movie_id                                     title  \\\n",
              "0     19995                                    Avatar   \n",
              "1       285  Pirates of the Caribbean: At World's End   \n",
              "2    206647                                   Spectre   \n",
              "3     49026                     The Dark Knight Rises   \n",
              "4     49529                               John Carter   \n",
              "\n",
              "                                     genres  \\\n",
              "0  Action Adventure Fantasy Science Fiction   \n",
              "1                  Adventure Fantasy Action   \n",
              "2                    Action Adventure Crime   \n",
              "3               Action Crime Drama Thriller   \n",
              "4          Action Adventure Science Fiction   \n",
              "\n",
              "                                            keywords  \\\n",
              "0  culture clash future space war space colony so...   \n",
              "1  ocean drug abuse exotic island east india trad...   \n",
              "2  spy based on novel secret agent sequel mi6 bri...   \n",
              "3  dc comics crime fighter terrorist secret ident...   \n",
              "4  based on novel mars medallion space travel pri...   \n",
              "\n",
              "                                            overview  \\\n",
              "0  In the 22nd century, a paraplegic Marine is di...   \n",
              "1  Captain Barbossa, long believed to be dead, ha...   \n",
              "2  A cryptic message from Bond’s past sends him o...   \n",
              "3  Following the death of District Attorney Harve...   \n",
              "4  John Carter is a war-weary, former military ca...   \n",
              "\n",
              "                                              cast              crew  \n",
              "0              JakeSully Neytiri Dr.GraceAugustine      JamesCameron  \n",
              "1     CaptainJackSparrow WillTurner ElizabethSwann     GoreVerbinski  \n",
              "2                      JamesBond Blofeld Madeleine         SamMendes  \n",
              "3   BruceWayne/Batman AlfredPennyworth JamesGordon  ChristopherNolan  \n",
              "4                      JohnCarter DejahThoris Sola     AndrewStanton  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-58144121-2f99-44ab-b66c-fc8d34daecfc\" 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>movie_id</th>\n",
              "      <th>title</th>\n",
              "      <th>genres</th>\n",
              "      <th>keywords</th>\n",
              "      <th>overview</th>\n",
              "      <th>cast</th>\n",
              "      <th>crew</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>19995</td>\n",
              "      <td>Avatar</td>\n",
              "      <td>Action Adventure Fantasy Science Fiction</td>\n",
              "      <td>culture clash future space war space colony so...</td>\n",
              "      <td>In the 22nd century, a paraplegic Marine is di...</td>\n",
              "      <td>JakeSully Neytiri Dr.GraceAugustine</td>\n",
              "      <td>JamesCameron</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>285</td>\n",
              "      <td>Pirates of the Caribbean: At World's End</td>\n",
              "      <td>Adventure Fantasy Action</td>\n",
              "      <td>ocean drug abuse exotic island east india trad...</td>\n",
              "      <td>Captain Barbossa, long believed to be dead, ha...</td>\n",
              "      <td>CaptainJackSparrow WillTurner ElizabethSwann</td>\n",
              "      <td>GoreVerbinski</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>206647</td>\n",
              "      <td>Spectre</td>\n",
              "      <td>Action Adventure Crime</td>\n",
              "      <td>spy based on novel secret agent sequel mi6 bri...</td>\n",
              "      <td>A cryptic message from Bond’s past sends him o...</td>\n",
              "      <td>JamesBond Blofeld Madeleine</td>\n",
              "      <td>SamMendes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>49026</td>\n",
              "      <td>The Dark Knight Rises</td>\n",
              "      <td>Action Crime Drama Thriller</td>\n",
              "      <td>dc comics crime fighter terrorist secret ident...</td>\n",
              "      <td>Following the death of District Attorney Harve...</td>\n",
              "      <td>BruceWayne/Batman AlfredPennyworth JamesGordon</td>\n",
              "      <td>ChristopherNolan</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>49529</td>\n",
              "      <td>John Carter</td>\n",
              "      <td>Action Adventure Science Fiction</td>\n",
              "      <td>based on novel mars medallion space travel pri...</td>\n",
              "      <td>John Carter is a war-weary, former military ca...</td>\n",
              "      <td>JohnCarter DejahThoris Sola</td>\n",
              "      <td>AndrewStanton</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-58144121-2f99-44ab-b66c-fc8d34daecfc')\"\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 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\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",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\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-58144121-2f99-44ab-b66c-fc8d34daecfc 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-58144121-2f99-44ab-b66c-fc8d34daecfc');\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",
              "\n",
              "\n",
              "<div id=\"df-e8e52013-9c61-49dd-976e-7a3ceed08083\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-e8e52013-9c61-49dd-976e-7a3ceed08083')\"\n",
              "            title=\"Suggest charts\"\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",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-e8e52013-9c61-49dd-976e-7a3ceed08083 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 4
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "movies['tags'] = movies['genres'] + \" \" + movies[\"overview\"] + \" \" + movies['keywords'] + \" \" + movies['cast'] + \" \" + movies['crew']\n",
        "final_data = movies.drop(columns=[\"genres\", \"overview\", \"keywords\", \"cast\", \"crew\"])\n",
        "final_data.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "S4YJTmaZjbfX",
        "outputId": "ba7aca02-6f63-4f00-f3c1-5aa49b419d01"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   movie_id                                     title  \\\n",
              "0     19995                                    Avatar   \n",
              "1       285  Pirates of the Caribbean: At World's End   \n",
              "2    206647                                   Spectre   \n",
              "3     49026                     The Dark Knight Rises   \n",
              "4     49529                               John Carter   \n",
              "\n",
              "                                                tags  \n",
              "0  Action Adventure Fantasy Science Fiction In th...  \n",
              "1  Adventure Fantasy Action Captain Barbossa, lon...  \n",
              "2  Action Adventure Crime A cryptic message from ...  \n",
              "3  Action Crime Drama Thriller Following the deat...  \n",
              "4  Action Adventure Science Fiction John Carter i...  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-689a130a-7e35-4973-8c7a-5c975f3b2236\" 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>movie_id</th>\n",
              "      <th>title</th>\n",
              "      <th>tags</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>19995</td>\n",
              "      <td>Avatar</td>\n",
              "      <td>Action Adventure Fantasy Science Fiction In th...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>285</td>\n",
              "      <td>Pirates of the Caribbean: At World's End</td>\n",
              "      <td>Adventure Fantasy Action Captain Barbossa, lon...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>206647</td>\n",
              "      <td>Spectre</td>\n",
              "      <td>Action Adventure Crime A cryptic message from ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>49026</td>\n",
              "      <td>The Dark Knight Rises</td>\n",
              "      <td>Action Crime Drama Thriller Following the deat...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>49529</td>\n",
              "      <td>John Carter</td>\n",
              "      <td>Action Adventure Science Fiction John Carter i...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-689a130a-7e35-4973-8c7a-5c975f3b2236')\"\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 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\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",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\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-689a130a-7e35-4973-8c7a-5c975f3b2236 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-689a130a-7e35-4973-8c7a-5c975f3b2236');\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",
              "\n",
              "\n",
              "<div id=\"df-e1e72947-7fe0-4e97-b1cf-b7fac85414a7\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-e1e72947-7fe0-4e97-b1cf-b7fac85414a7')\"\n",
              "            title=\"Suggest charts\"\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",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-e1e72947-7fe0-4e97-b1cf-b7fac85414a7 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# final_data.head()\n",
        "\n",
        "# print(final_data['tags'])\n",
        "\n",
        "from nltk.stem.porter import PorterStemmer\n",
        "\n",
        "ps = PorterStemmer()\n",
        "print(ps.stem(\"thriller\"))\n",
        "print(ps.stem(\"documentary\"))"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "pUg_ni48lG1-",
        "outputId": "9d50025d-7759-4e05-9f78-04f3d28abcb9"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "thriller\n",
            "documentari\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "from sklearn.feature_extraction.text import CountVectorizer\n",
        "\n",
        "cv = CountVectorizer(max_features=5000, stop_words=\"english\")\n",
        "# final_data['tags']\n",
        "final_data['tags'] = final_data['tags'].fillna('')\n",
        "# vector0 = cv.fit_transform(final_data['tags']).toarray()\n",
        "# print(cv.get_feature_names_out()[0:100])\n",
        "\n",
        "def stem(string):\n",
        "  new_str = []\n",
        "  for i in string.split():\n",
        "    new_str.append(ps.stem(i))\n",
        "  return \" \".join(new_str)\n",
        "\n",
        "print(\"Printing\")\n",
        "final_data['tags'] = final_data['tags'].apply(stem)\n",
        "vector = cv.fit_transform(final_data['tags']).toarray()\n",
        "print(cv.get_feature_names_out()[0:100])"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "bYUYqCc8tOY4",
        "outputId": "9cf7189f-023d-4f60-9fa9-cc21db3edb5c"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Printing\n",
            "['000' '007' '10' '100' '11' '12' '13' '14' '15' '16' '16th' '17' '17th'\n",
            " '18' '1890' '18th' '19' '1910' '1920' '1930' '1940' '1944' '1950' '1950s'\n",
            " '1955' '1959' '1960' '1960s' '1962' '1964' '1965' '1967' '1970' '1970s'\n",
            " '1974' '1976' '1979' '1980' '1980s' '1985' '1990' '1995' '1997' '1999'\n",
            " '19th' '20' '200' '2000' '2001' '2002' '2003' '2009' '20th' '21st' '23'\n",
            " '24' '25' '30' '300' '3d' '40' '50' '500' '51' '60' '60s' '66' '70' '80'\n",
            " 'aaron' 'abandon' 'abbi' 'abduct' 'abil' 'abl' 'aboard' 'aborigin' 'abov'\n",
            " 'abroad' 'abus' 'academ' 'academi' 'accent' 'accept' 'access' 'accid'\n",
            " 'accident' 'acclaim' 'accompani' 'accomplish' 'account' 'accus' 'ace'\n",
            " 'achiev' 'acquaint' 'act' 'action' 'activ' 'activist' 'activities']\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "from sklearn.metrics.pairwise import cosine_similarity\n",
        "\n",
        "simi = cosine_similarity(vector)"
      ],
      "metadata": {
        "id": "O_6r6ieqh4L4"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# sorted(simi[0], reverse=True)\n",
        "sorted(list(enumerate(simi[0])), reverse=True, key=lambda x:x[1])"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "ERq9CS8q9SsE",
        "outputId": "d2d08110-21d3-4e4a-96a3-0f87eb107b53"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[(0, 1.0),\n",
              " (2409, 0.4751310967331988),\n",
              " (4338, 0.4385290096535147),\n",
              " (373, 0.42059551209602997),\n",
              " (1537, 0.40684295655005165),\n",
              " (2021, 0.39729755265461353),\n",
              " (3163, 0.3774199245641313),\n",
              " (1920, 0.37723227517716057),\n",
              " (838, 0.3708099243547832),\n",
              " (278, 0.3599451773255667),\n",
              " (1082, 0.35355339059327384),\n",
              " (305, 0.35154713901054874),\n",
              " (2204, 0.34705369316298773),\n",
              " (507, 0.3404414533245951),\n",
              " (1321, 0.3396831102433787),\n",
              " (2971, 0.33196440215590134),\n",
              " (300, 0.3278050340535929),\n",
              " (461, 0.3266167279819513),\n",
              " (3737, 0.3237619541190881),\n",
              " (1355, 0.32158794041257743),\n",
              " (1216, 0.3177354158795988),\n",
              " (3539, 0.31687511114881495),\n",
              " (158, 0.31299035602229497),\n",
              " (539, 0.3125),\n",
              " (260, 0.31219527052723134),\n",
              " (778, 0.31219527052723134),\n",
              " (582, 0.3069122947930837),\n",
              " (239, 0.3064129385141706),\n",
              " (149, 0.30551482296115273),\n",
              " (4, 0.30463589792247125),\n",
              " (184, 0.3001225239993905),\n",
              " (1071, 0.29938207967349956),\n",
              " (577, 0.298142396999972),\n",
              " (1204, 0.29695693545824925),\n",
              " (61, 0.29484598755723446),\n",
              " (1765, 0.2843750615423936),\n",
              " (661, 0.28388748697883437),\n",
              " (595, 0.2834733547569204),\n",
              " (47, 0.2802242691589025),\n",
              " (1357, 0.2798964342196751),\n",
              " (56, 0.2797154638927579),\n",
              " (95, 0.2795745670376313),\n",
              " (973, 0.27783119144576074),\n",
              " (549, 0.2735583347674307),\n",
              " (972, 0.2726376271173233),\n",
              " (322, 0.26956456807360374),\n",
              " (4049, 0.2668724980820582),\n",
              " (581, 0.26669823045522095),\n",
              " (1965, 0.25871684190211097),\n",
              " (3410, 0.25767356084130866),\n",
              " (74, 0.2572478777137633),\n",
              " (541, 0.2568505834570407),\n",
              " (3676, 0.2566001196398337),\n",
              " (502, 0.2535362435247213),\n",
              " (94, 0.2518698839449418),\n",
              " (1957, 0.25175440748900674),\n",
              " (1715, 0.249485066394583),\n",
              " (2972, 0.24845199749997665),\n",
              " (432, 0.2466100126039053),\n",
              " (770, 0.24578099980700543),\n",
              " (1344, 0.2454865647728863),\n",
              " (1220, 0.2449489742783178),\n",
              " (1373, 0.24224069756247726),\n",
              " (83, 0.24056261216234412),\n",
              " (342, 0.23688968483956718),\n",
              " (1996, 0.23570226039551587),\n",
              " (692, 0.23448833510400427),\n",
              " (1089, 0.23426064283290912),\n",
              " (1201, 0.23249527748763857),\n",
              " (41, 0.23211917272131483),\n",
              " (52, 0.23103442669455737),\n",
              " (150, 0.2297341458681704),\n",
              " (91, 0.2294157338705618),\n",
              " (1056, 0.2288021576612147),\n",
              " (1031, 0.22838671990104964),\n",
              " (1278, 0.2282177322938192),\n",
              " (2702, 0.2282177322938192),\n",
              " (168, 0.22271770159368698),\n",
              " (236, 0.2224746041573049),\n",
              " (306, 0.22086305214969312),\n",
              " (270, 0.2175970699446223),\n",
              " (228, 0.2166445612065605),\n",
              " (27, 0.21516574145596762),\n",
              " (2939, 0.2145319676449461),\n",
              " (1479, 0.21437323142813608),\n",
              " (454, 0.2130032168075646),\n",
              " (3148, 0.21081851067789198),\n",
              " (230, 0.20887610455277095),\n",
              " (67, 0.20851441405707477),\n",
              " (643, 0.20851441405707477),\n",
              " (787, 0.20833333333333337),\n",
              " (1488, 0.20833333333333337),\n",
              " (4000, 0.20833333333333334),\n",
              " (773, 0.20833333333333331),\n",
              " (4194, 0.20801257358446096),\n",
              " (754, 0.20690147215059201),\n",
              " (2547, 0.20464687117164013),\n",
              " (1982, 0.20412414523193156),\n",
              " (3609, 0.20215947828770756),\n",
              " (557, 0.20116994969180618),\n",
              " (233, 0.20100756305184242),\n",
              " (1280, 0.20100756305184242),\n",
              " (4599, 0.20100756305184242),\n",
              " (1329, 0.2),\n",
              " (480, 0.19802950859533486),\n",
              " (1275, 0.19695964928958387),\n",
              " (466, 0.19658927487319622),\n",
              " (1496, 0.19641855032959654),\n",
              " (1002, 0.1944444444444445),\n",
              " (626, 0.19245008972987526),\n",
              " (1178, 0.19245008972987526),\n",
              " (1656, 0.19174124721184263),\n",
              " (1285, 0.1914555089647302),\n",
              " (4115, 0.19117977822546817),\n",
              " (1297, 0.19069251784911848),\n",
              " (1668, 0.18909389514744548),\n",
              " (889, 0.18857225582221437),\n",
              " (1361, 0.18844459036110228),\n",
              " (4345, 0.18762601192807785),\n",
              " (2917, 0.1873171623163388),\n",
              " (200, 0.18463723646899916),\n",
              " (2235, 0.18463723646899913),\n",
              " (3073, 0.1846372364689991),\n",
              " (3328, 0.1844661968431555),\n",
              " (3432, 0.18365772167311328),\n",
              " (2333, 0.18257418583505533),\n",
              " (87, 0.18184824186332701),\n",
              " (2790, 0.1814436846506058),\n",
              " (3219, 0.1814436846506058),\n",
              " (3731, 0.18002057495577392),\n",
              " (26, 0.17977312387666872),\n",
              " (108, 0.17977312387666872),\n",
              " (579, 0.17977312387666872),\n",
              " (2450, 0.17977312387666872),\n",
              " (2866, 0.17931460919717976),\n",
              " (1383, 0.17817416127494956),\n",
              " (1322, 0.17791499872137212),\n",
              " (2787, 0.17766726362967536),\n",
              " (1444, 0.17588161767036212),\n",
              " (3000, 0.17588161767036212),\n",
              " (2584, 0.17507524381296344),\n",
              " (2135, 0.1748907274323677),\n",
              " (4667, 0.17437145811572896),\n",
              " (223, 0.173762011714229),\n",
              " (931, 0.17206180040292135),\n",
              " (2788, 0.17206180040292135),\n",
              " (3450, 0.17206180040292135),\n",
              " (564, 0.17201561551404665),\n",
              " (1560, 0.17170739878997723),\n",
              " (222, 0.17129003992578723),\n",
              " (843, 0.17010345435994295),\n",
              " (4471, 0.17010345435994295),\n",
              " (401, 0.16984155512168939),\n",
              " (14, 0.16877201328135932),\n",
              " (680, 0.16877201328135932),\n",
              " (1928, 0.16877201328135932),\n",
              " (35, 0.16839382851364088),\n",
              " (1466, 0.16839382851364088),\n",
              " (3629, 0.1683587574253685),\n",
              " (2556, 0.16783627165933782),\n",
              " (1756, 0.16770509831248426),\n",
              " (1083, 0.16735967034880078),\n",
              " (2022, 0.16735967034880078),\n",
              " (36, 0.16735967034880075),\n",
              " (529, 0.16666666666666669),\n",
              " (2732, 0.16666666666666669),\n",
              " (4355, 0.16666666666666669),\n",
              " (2059, 0.1650245904961124),\n",
              " (2821, 0.1633263145020371),\n",
              " (1396, 0.16204530402191716),\n",
              " (31, 0.16188097705954405),\n",
              " (2439, 0.16178755723235855),\n",
              " (1774, 0.16169041669088863),\n",
              " (855, 0.16012815380508713),\n",
              " (1037, 0.15990053726670783),\n",
              " (1649, 0.15990053726670783),\n",
              " (483, 0.15936381457791915),\n",
              " (2515, 0.15936381457791915),\n",
              " (46, 0.15891043154093207),\n",
              " (2677, 0.15891043154093207),\n",
              " (229, 0.15718652085716922),\n",
              " (617, 0.15718652085716922),\n",
              " (156, 0.15660307954993902),\n",
              " (111, 0.1563858105428061),\n",
              " (220, 0.1563858105428061),\n",
              " (1097, 0.1563858105428061),\n",
              " (1589, 0.1563858105428061),\n",
              " (3756, 0.1563858105428061),\n",
              " (3189, 0.15609763526361567),\n",
              " (1883, 0.1560636973057706),\n",
              " (2903, 0.1552301051412666),\n",
              " (1570, 0.15471318693881903),\n",
              " (2347, 0.15471318693881903),\n",
              " (2488, 0.15471318693881903),\n",
              " (2763, 0.15471318693881903),\n",
              " (141, 0.15342910298305393),\n",
              " (127, 0.15339299776947407),\n",
              " (1379, 0.1532064692570853),\n",
              " (505, 0.153190838336343),\n",
              " (800, 0.15294382258037453),\n",
              " (2075, 0.15294382258037453),\n",
              " (1445, 0.1527777777777778),\n",
              " (628, 0.15249857033260467),\n",
              " (1109, 0.15249857033260467),\n",
              " (2209, 0.15152288168283162),\n",
              " (3820, 0.15152288168283162),\n",
              " (642, 0.15089291007086425),\n",
              " (249, 0.15061601901917734),\n",
              " (3094, 0.14967108502231244),\n",
              " (101, 0.14847846772912465),\n",
              " (1294, 0.14847846772912465),\n",
              " (3631, 0.14847846772912465),\n",
              " (3960, 0.14724203476646208),\n",
              " (2919, 0.14708710135363806),\n",
              " (1166, 0.14583333333333334),\n",
              " (2169, 0.1454785934906616),\n",
              " (2247, 0.1454785934906616),\n",
              " (2003, 0.14506471329641488),\n",
              " (18, 0.14433756729740646),\n",
              " (490, 0.14433756729740646),\n",
              " (3729, 0.14433756729740646),\n",
              " (3213, 0.14377703093791788),\n",
              " (267, 0.1436067394758882),\n",
              " (1018, 0.14301938838683886),\n",
              " (110, 0.1429154876187574),\n",
              " (3635, 0.1429154876187574),\n",
              " (169, 0.14285714285714288),\n",
              " (1015, 0.14187608845979144),\n",
              " (412, 0.14085904245475278),\n",
              " (1161, 0.1405456737852613),\n",
              " (473, 0.1404878717372541),\n",
              " (2058, 0.13944333775567927),\n",
              " (70, 0.13900960937138318),\n",
              " (1529, 0.13898464132279897),\n",
              " (4590, 0.13888888888888892),\n",
              " (1418, 0.13808619268474853),\n",
              " (2764, 0.13741414298257462),\n",
              " (4548, 0.13741414298257462),\n",
              " (2543, 0.13699915608779778),\n",
              " (365, 0.13699915608779775),\n",
              " (208, 0.13608276348795437),\n",
              " (487, 0.13608276348795437),\n",
              " (4098, 0.13608276348795437),\n",
              " (456, 0.13608276348795434),\n",
              " (495, 0.1356222452011225),\n",
              " (1721, 0.1356222452011225),\n",
              " (740, 0.13518451760896877),\n",
              " (3118, 0.13518451760896877),\n",
              " (939, 0.13483997249264845),\n",
              " (72, 0.13468700594029479),\n",
              " (3236, 0.13468700594029479),\n",
              " (1741, 0.1343038273375634),\n",
              " (430, 0.13430382733756338),\n",
              " (151, 0.13382584475782772),\n",
              " (275, 0.13382584475782772),\n",
              " (207, 0.1336306209562122),\n",
              " (1658, 0.1336306209562122),\n",
              " (2323, 0.1336306209562122),\n",
              " (3906, 0.13344012817090595),\n",
              " (2035, 0.13333333333333336),\n",
              " (3292, 0.13333333333333336),\n",
              " (2761, 0.13258252147247765),\n",
              " (362, 0.1320989873168695),\n",
              " (1474, 0.1320989873168695),\n",
              " (755, 0.13176156917368248),\n",
              " (785, 0.13176156917368248),\n",
              " (2941, 0.13176156917368248),\n",
              " (1467, 0.1307440900921227),\n",
              " (3557, 0.1305582419667734),\n",
              " (568, 0.13043729868748777),\n",
              " (878, 0.13043729868748777),\n",
              " (587, 0.12958026383720403),\n",
              " (1938, 0.12950478164763524),\n",
              " (1191, 0.12935842095105549),\n",
              " (3182, 0.12909944487358055),\n",
              " (3196, 0.12909944487358055),\n",
              " (102, 0.12862393885688167),\n",
              " (1498, 0.1278274981412284),\n",
              " (1019, 0.1276884796138123),\n",
              " (138, 0.1272937693043289),\n",
              " (632, 0.1272937693043289),\n",
              " (1768, 0.1272937693043289),\n",
              " (7, 0.12712834523274566),\n",
              " (2284, 0.12712834523274566),\n",
              " (4327, 0.12712834523274566),\n",
              " (2889, 0.12711879496828168),\n",
              " (1411, 0.1270821419438372),\n",
              " (3616, 0.12634967392981722),\n",
              " (419, 0.12598815766974242),\n",
              " (53, 0.1258772037445034),\n",
              " (75, 0.12580490207067815),\n",
              " (4180, 0.12532408662118827),\n",
              " (3442, 0.125),\n",
              " (4019, 0.12499999999999999),\n",
              " (536, 0.12487810821089254),\n",
              " (942, 0.12487810821089254),\n",
              " (232, 0.12436708454077278),\n",
              " (2733, 0.12422599874998834),\n",
              " (633, 0.12414088329035522),\n",
              " (870, 0.12414088329035522),\n",
              " (1299, 0.123299240479018),\n",
              " (1831, 0.12329924047901797),\n",
              " (389, 0.12309149097933275),\n",
              " (1929, 0.12297746456210365),\n",
              " (476, 0.12286829679574764),\n",
              " (3379, 0.12286829679574764),\n",
              " (4476, 0.12286829679574764),\n",
              " (4318, 0.12274328238644315),\n",
              " (1194, 0.12171612389003691),\n",
              " (3315, 0.1216334081999603),\n",
              " (4515, 0.1216334081999603),\n",
              " (147, 0.12163340819996028),\n",
              " (311, 0.12163340819996028),\n",
              " (2072, 0.12163340819996028),\n",
              " (2719, 0.12126781251816648),\n",
              " (174, 0.12071432805669138),\n",
              " (279, 0.12071432805669138),\n",
              " (2239, 0.12071432805669138),\n",
              " (3444, 0.12071432805669138),\n",
              " (172, 0.1203324787301926),\n",
              " (1092, 0.12033247873019258),\n",
              " (1501, 0.12028130608117206),\n",
              " (1446, 0.12028130608117205),\n",
              " (589, 0.12009611535381534),\n",
              " (592, 0.12009611535381534),\n",
              " (1439, 0.11973686801784995),\n",
              " (920, 0.11952286093343936),\n",
              " (3771, 0.11952286093343936),\n",
              " (413, 0.11907241805196007),\n",
              " (1039, 0.11907241805196007),\n",
              " (1293, 0.11907241805196007),\n",
              " (666, 0.11907241805196006),\n",
              " (1614, 0.11907241805196006),\n",
              " (2133, 0.11878277418329973),\n",
              " (107, 0.11785113019775793),\n",
              " (897, 0.11785113019775793),\n",
              " (997, 0.11785113019775793),\n",
              " (3955, 0.11785113019775793),\n",
              " (3023, 0.11785113019775792),\n",
              " (3782, 0.11785113019775792),\n",
              " (215, 0.11713032141645455),\n",
              " (3499, 0.11666666666666668),\n",
              " (3623, 0.11666666666666668),\n",
              " (185, 0.11666666666666667),\n",
              " (4232, 0.11666666666666667),\n",
              " (660, 0.1155625408802561),\n",
              " (935, 0.1155625408802561),\n",
              " (1171, 0.1155625408802561),\n",
              " (2053, 0.1155625408802561),\n",
              " (2656, 0.1155625408802561),\n",
              " (3662, 0.1155625408802561),\n",
              " (334, 0.11551721334727869),\n",
              " (3355, 0.11551721334727869),\n",
              " (462, 0.11548914453059722),\n",
              " (784, 0.11518245674418136),\n",
              " (2874, 0.11518245674418136),\n",
              " (790, 0.11504474832710557),\n",
              " (422, 0.1147078669352809),\n",
              " (3103, 0.1147078669352809),\n",
              " (3538, 0.1147078669352809),\n",
              " (371, 0.11440107883060738),\n",
              " (814, 0.11440107883060738),\n",
              " (51, 0.11437392774945351),\n",
              " (17, 0.11433239009500593),\n",
              " (1042, 0.1143323900950059),\n",
              " (3160, 0.11340230290662863),\n",
              " (16, 0.11331668394168083),\n",
              " (404, 0.11322770341445959),\n",
              " (3009, 0.11322770341445959),\n",
              " (4080, 0.11322770341445958),\n",
              " (2498, 0.11268723396380222),\n",
              " (1700, 0.11226255234242724),\n",
              " (5, 0.11189084777289189),\n",
              " (3765, 0.11180339887498951),\n",
              " (3757, 0.11157311356586719),\n",
              " (1274, 0.11135885079684349),\n",
              " (1421, 0.11135885079684349),\n",
              " (1942, 0.11135885079684349),\n",
              " (4238, 0.11135885079684349),\n",
              " (585, 0.11123730207865244),\n",
              " (900, 0.11123730207865244),\n",
              " (571, 0.1111873974991652),\n",
              " (1101, 0.11111111111111113),\n",
              " (2480, 0.11111111111111113),\n",
              " (2797, 0.11111111111111113),\n",
              " (4011, 0.11111111111111113),\n",
              " (1113, 0.11043152607484656),\n",
              " (4734, 0.11043152607484656),\n",
              " (3822, 0.11043152607484655),\n",
              " (813, 0.11034745181364908),\n",
              " (513, 0.11023963796102462),\n",
              " (3573, 0.11023963796102462),\n",
              " (3911, 0.11023963796102461),\n",
              " (2902, 0.1102396379610246),\n",
              " (1828, 0.10959932487023824),\n",
              " (586, 0.10959932487023821),\n",
              " (1524, 0.10942202738310215),\n",
              " (687, 0.10910894511799621),\n",
              " (2181, 0.10910894511799621),\n",
              " (2001, 0.10886621079036346),\n",
              " (674, 0.10832228060328025),\n",
              " (1531, 0.10832228060328025),\n",
              " (3554, 0.10832228060328025),\n",
              " (1574, 0.10825317547305485),\n",
              " (420, 0.10814761408717502),\n",
              " (1575, 0.10814761408717502),\n",
              " (1086, 0.10783277320343844),\n",
              " (524, 0.10783277320343843),\n",
              " (3451, 0.10783277320343843),\n",
              " (1158, 0.10758287072798381),\n",
              " (301, 0.10744306187005072),\n",
              " (1897, 0.1074430618700507),\n",
              " (508, 0.10740037208813775),\n",
              " (1273, 0.10740037208813775),\n",
              " (1237, 0.10660035817780522),\n",
              " (363, 0.10607430455676402),\n",
              " (1878, 0.10607430455676402),\n",
              " (3377, 0.10583343916682543),\n",
              " (3717, 0.10583343916682542),\n",
              " (1512, 0.10562503704960496),\n",
              " (2835, 0.10562503704960496),\n",
              " (438, 0.10540925533894599),\n",
              " (980, 0.10540925533894599),\n",
              " (1033, 0.10540925533894599),\n",
              " (1348, 0.10540925533894599),\n",
              " (1655, 0.10540925533894599),\n",
              " (1678, 0.10540925533894599),\n",
              " (1824, 0.10540925533894599),\n",
              " (2178, 0.10540925533894599),\n",
              " (2297, 0.10540925533894599),\n",
              " (2991, 0.10540925533894599),\n",
              " (4027, 0.10540925533894599),\n",
              " (3012, 0.10540925533894598),\n",
              " (1617, 0.10476975951561872),\n",
              " (1793, 0.1047697595156187),\n",
              " (3415, 0.1047697595156187),\n",
              " (253, 0.10475656017578483),\n",
              " (768, 0.10475656017578483),\n",
              " (1497, 0.10475656017578483),\n",
              " (4101, 0.10475656017578483),\n",
              " (793, 0.10425720702853739),\n",
              " (2444, 0.10425720702853739),\n",
              " (624, 0.10416666666666666),\n",
              " (2869, 0.10416666666666666),\n",
              " (3892, 0.10416666666666666),\n",
              " (4258, 0.10416666666666666),\n",
              " (1414, 0.10393492741038728),\n",
              " (1009, 0.10393492741038726),\n",
              " (10, 0.10393492741038725),\n",
              " (271, 0.10314212462587936),\n",
              " (1195, 0.10314212462587936),\n",
              " (48, 0.10311973892303819),\n",
              " (182, 0.10311973892303819),\n",
              " (4335, 0.10286889997472795),\n",
              " (4350, 0.10286889997472795),\n",
              " (449, 0.1025762424827773),\n",
              " (1047, 0.1025762424827773),\n",
              " (1927, 0.1025762424827773),\n",
              " (2634, 0.1025762424827773),\n",
              " (3290, 0.1025762424827773),\n",
              " (3664, 0.1025762424827773),\n",
              " (2291, 0.10257624248277729),\n",
              " (794, 0.10232343558582009),\n",
              " (246, 0.10226199851298273),\n",
              " (312, 0.10206207261596578),\n",
              " (534, 0.10206207261596578),\n",
              " (166, 0.10206207261596577),\n",
              " (9, 0.10154529930749041),\n",
              " (1534, 0.10154529930749041),\n",
              " (3465, 0.10154529930749041),\n",
              " (122, 0.10105651043180541),\n",
              " (2583, 0.10105651043180541),\n",
              " (187, 0.1010152544552211),\n",
              " (3936, 0.1010152544552211),\n",
              " (3839, 0.10101525445522108),\n",
              " (1168, 0.10078464965115869),\n",
              " (599, 0.10050378152592122),\n",
              " (319, 0.10050378152592121),\n",
              " (1327, 0.10050378152592121),\n",
              " (2161, 0.10050378152592121),\n",
              " (4278, 0.10050378152592121),\n",
              " (217, 0.10004084133313017),\n",
              " (4183, 0.10004084133313017),\n",
              " (2054, 0.10004084133313015),\n",
              " (1363, 0.10000000000000002),\n",
              " (859, 0.1),\n",
              " (2697, 0.1),\n",
              " (1324, 0.09960238411119947),\n",
              " (1884, 0.09960238411119947),\n",
              " (2378, 0.09960238411119947),\n",
              " (1233, 0.09931326192185402),\n",
              " (129, 0.09931326192185401),\n",
              " (3175, 0.09931326192185401),\n",
              " (4603, 0.099313261921854),\n",
              " (2448, 0.09913531291324379),\n",
              " (1823, 0.09901475429766744),\n",
              " (2158, 0.09901475429766744),\n",
              " (2528, 0.09901475429766744),\n",
              " (988, 0.09901475429766743),\n",
              " (1362, 0.09901475429766743),\n",
              " (1565, 0.09901475429766743),\n",
              " (3419, 0.09901475429766743),\n",
              " (531, 0.09860132971832694),\n",
              " (635, 0.09860132971832694),\n",
              " (307, 0.09847982464479194),\n",
              " (808, 0.09829463743659811),\n",
              " (1782, 0.09829463743659811),\n",
              " (2977, 0.09829463743659811),\n",
              " (3983, 0.09829463743659811),\n",
              " (4657, 0.09829463743659811),\n",
              " (1745, 0.0982946374365981),\n",
              " (33, 0.09820927516479827),\n",
              " (4001, 0.09820927516479827),\n",
              " (1808, 0.09805806756909204),\n",
              " (2330, 0.09805806756909204),\n",
              " (3519, 0.09805806756909204),\n",
              " (2915, 0.09805806756909202),\n",
              " (1639, 0.0979044918012804),\n",
              " (123, 0.09776474334756886),\n",
              " (333, 0.09724332766526304),\n",
              " (1833, 0.09687303228651607),\n",
              " (2060, 0.09687303228651607),\n",
              " (4341, 0.09687303228651607),\n",
              " (1098, 0.09655402033694294),\n",
              " (850, 0.09622504486493764),\n",
              " (2598, 0.09622504486493764),\n",
              " (2675, 0.09622504486493764),\n",
              " (4433, 0.09622504486493764),\n",
              " (4343, 0.09622504486493763),\n",
              " (2264, 0.09589940926145846),\n",
              " (1858, 0.09572775448236509),\n",
              " (731, 0.09558988911273408),\n",
              " (1306, 0.09558988911273408),\n",
              " (535, 0.09534625892455924),\n",
              " (304, 0.09527699174583826),\n",
              " (238, 0.09523809523809525),\n",
              " (2527, 0.09462916232627815),\n",
              " (2823, 0.09462916232627815),\n",
              " (4156, 0.09462916232627815),\n",
              " (1664, 0.09449111825230681),\n",
              " (3310, 0.0944911182523068),\n",
              " (71, 0.09435641951204965),\n",
              " (294, 0.09435641951204965),\n",
              " (764, 0.09435641951204965),\n",
              " (775, 0.09435641951204965),\n",
              " (1585, 0.09435641951204965),\n",
              " (2396, 0.09435641951204965),\n",
              " (4653, 0.09435641951204965),\n",
              " (715, 0.09428090415820635),\n",
              " (2017, 0.09428090415820635),\n",
              " (2114, 0.09428090415820635),\n",
              " (2456, 0.09428090415820635),\n",
              " (4493, 0.09428090415820635),\n",
              " (4541, 0.09365858115816941),\n",
              " (2243, 0.0936585811581694),\n",
              " (3910, 0.0936585811581694),\n",
              " (320, 0.09316949906249125),\n",
              " (329, 0.09316949906249125),\n",
              " (472, 0.09316949906249125),\n",
              " (1519, 0.09316949906249125),\n",
              " (2636, 0.09316949906249125),\n",
              " (4676, 0.09316949906249125),\n",
              " (728, 0.09284766908852593),\n",
              " (777, 0.09284766908852593),\n",
              " (1064, 0.09284766908852593),\n",
              " (1632, 0.09284766908852593),\n",
              " (2642, 0.09284766908852593),\n",
              " (2741, 0.09284766908852593),\n",
              " (4357, 0.09245003270420488),\n",
              " (812, 0.09231861823449956),\n",
              " (1516, 0.09223309842157774),\n",
              " (2644, 0.09205746178983236),\n",
              " (3067, 0.09205746178983236),\n",
              " (256, 0.0920262717290388),\n",
              " (330, 0.0920262717290388),\n",
              " (459, 0.0920262717290388),\n",
              " (556, 0.0920262717290388),\n",
              " (627, 0.0920262717290388),\n",
              " (853, 0.0920262717290388),\n",
              " (1004, 0.0920262717290388),\n",
              " (3811, 0.0920262717290388),\n",
              " (3202, 0.09200874124564724),\n",
              " (3401, 0.09128709291752769),\n",
              " (4561, 0.09128709291752769),\n",
              " (251, 0.09128709291752768),\n",
              " (704, 0.09128709291752768),\n",
              " (1301, 0.09128709291752768),\n",
              " (2857, 0.09128709291752768),\n",
              " (2881, 0.09128709291752768),\n",
              " (607, 0.09110136110168687),\n",
              " (112, 0.09092412093166351),\n",
              " (1843, 0.09092412093166351),\n",
              " (2093, 0.09092412093166351),\n",
              " (2148, 0.09092412093166351),\n",
              " (1034, 0.0909241209316635),\n",
              " (1521, 0.0907218423253029),\n",
              " (2620, 0.0907218423253029),\n",
              " (1623, 0.09053574604251854),\n",
              " (2899, 0.09053574604251854),\n",
              " (3882, 0.09053574604251854),\n",
              " (4697, 0.09053574604251854),\n",
              " (2496, 0.0898606443361987),\n",
              " (3471, 0.0898606443361987),\n",
              " (192, 0.08980265101338747),\n",
              " (752, 0.08980265101338747),\n",
              " (2969, 0.08980265101338747),\n",
              " (678, 0.0890870806374748),\n",
              " (1289, 0.0890870806374748),\n",
              " (3710, 0.0890870806374748),\n",
              " (3840, 0.0890870806374748),\n",
              " (4614, 0.0890870806374748),\n",
              " (170, 0.08908708063747478),\n",
              " (1896, 0.08908708063747478),\n",
              " (809, 0.08895749936068606),\n",
              " (400, 0.0888336318148377),\n",
              " (510, 0.0888336318148377),\n",
              " (2471, 0.0888336318148377),\n",
              " (3543, 0.0888336318148377),\n",
              " (3875, 0.0888336318148377),\n",
              " (618, 0.08844477175087208),\n",
              " (360, 0.08844477175087206),\n",
              " (2897, 0.08838834764831845),\n",
              " (3007, 0.08838834764831845),\n",
              " (3463, 0.08838834764831845),\n",
              " (4043, 0.08784104611578833),\n",
              " (332, 0.08784104611578832),\n",
              " (2818, 0.08784104611578832),\n",
              " (3029, 0.08784104611578832),\n",
              " (4207, 0.08784104611578832),\n",
              " (1701, 0.08770580193070295),\n",
              " (1832, 0.08770580193070295),\n",
              " (2652, 0.08753762190648172),\n",
              " (4405, 0.08753762190648172),\n",
              " (3390, 0.08703882797784893),\n",
              " (3391, 0.08703882797784893),\n",
              " (3608, 0.08695819912499184),\n",
              " (341, 0.08688100585711449),\n",
              " (744, 0.08688100585711449),\n",
              " (1465, 0.08688100585711449),\n",
              " (2241, 0.08688100585711449),\n",
              " (3038, 0.08688100585711449),\n",
              " (4331, 0.08688100585711449),\n",
              " (4660, 0.08688100585711449),\n",
              " (1452, 0.08647908694379515),\n",
              " (448, 0.08638684255813601),\n",
              " (677, 0.08638684255813601),\n",
              " (1011, 0.08638684255813601),\n",
              " (1802, 0.08638684255813601),\n",
              " (3135, 0.08638684255813601),\n",
              " (4069, 0.08638684255813601),\n",
              " (134, 0.08606629658238704),\n",
              " (356, 0.08606629658238704),\n",
              " (781, 0.08606629658238704),\n",
              " (1381, 0.08606629658238704),\n",
              " (4200, 0.08606629658238704),\n",
              " (1096, 0.08595177052156613),\n",
              " (1340, 0.08574929257125442),\n",
              " (1673, 0.08574929257125442),\n",
              " (2331, 0.08574929257125442),\n",
              " (2637, 0.08574929257125442),\n",
              " (3084, 0.08574929257125442),\n",
              " (163, 0.08512565307587487),\n",
              " (103, 0.08512565307587486),\n",
              " (203, 0.08505172717997148),\n",
              " (2542, 0.08505172717997148),\n",
              " (3784, 0.08505172717997148),\n",
              " (85, 0.0850102284084451),\n",
              " (532, 0.08466675133346034),\n",
              " (668, 0.08466675133346034),\n",
              " (2127, 0.08466675133346034),\n",
              " (4333, 0.08466675133346034),\n",
              " (1898, 0.08451542547285167),\n",
              " (82, 0.08417937871268424),\n",
              " (4282, 0.08417937871268424),\n",
              " (4643, 0.08417937871268424),\n",
              " (1426, 0.08391813582966891),\n",
              " (491, 0.08376178517206948),\n",
              " (32, 0.08333333333333334),\n",
              " (68, 0.08333333333333334),\n",
              " (81, 0.08333333333333334),\n",
              " (125, 0.08333333333333334),\n",
              " (337, 0.08333333333333334),\n",
              " (823, 0.08333333333333334),\n",
              " (1005, 0.08333333333333334),\n",
              " (1139, 0.08333333333333334),\n",
              " (1288, 0.08333333333333334),\n",
              " (2592, 0.08333333333333334),\n",
              " (4370, 0.08333333333333334),\n",
              " (4558, 0.08333333333333334),\n",
              " (4740, 0.08333333333333334),\n",
              " (368, 0.08333333333333333),\n",
              " (1304, 0.08333333333333333),\n",
              " (1434, 0.08333333333333333),\n",
              " (3366, 0.08333333333333333),\n",
              " (4208, 0.08333333333333333),\n",
              " (4488, 0.08333333333333333),\n",
              " (898, 0.0825122952480562),\n",
              " (2687, 0.0825122952480562),\n",
              " (2392, 0.08219949365267866),\n",
              " (4509, 0.08219949365267866),\n",
              " (653, 0.08206099398622184),\n",
              " (1241, 0.08206099398622184),\n",
              " (1870, 0.08206099398622184),\n",
              " (2660, 0.08206099398622184),\n",
              " (3136, 0.08206099398622184),\n",
              " (4218, 0.08206099398622184),\n",
              " (445, 0.0817150563075767),\n",
              " (634, 0.0817150563075767),\n",
              " (908, 0.0817150563075767),\n",
              " (1749, 0.0817150563075767),\n",
              " (3318, 0.0817150563075767),\n",
              " (555, 0.08144629623753682),\n",
              " (139, 0.08128551833402207),\n",
              " (189, 0.08111071056538127),\n",
              " (4167, 0.08111071056538127),\n",
              " (4279, 0.08111071056538127),\n",
              " (210, 0.08111071056538126),\n",
              " (844, 0.08094048852977202),\n",
              " (4111, 0.08094048852977202),\n",
              " (145, 0.08089377861617927),\n",
              " (506, 0.08084520834544433),\n",
              " (511, 0.08084520834544433),\n",
              " (1259, 0.08084520834544433),\n",
              " (1978, 0.08084520834544433),\n",
              " (2645, 0.08084520834544433),\n",
              " (3867, 0.08084520834544433),\n",
              " (63, 0.08058229640253804),\n",
              " (84, 0.08058229640253804),\n",
              " (1155, 0.08058229640253804),\n",
              " (1008, 0.0805496124440236),\n",
              " (266, 0.08018753738744804),\n",
              " (1207, 0.08018753738744802),\n",
              " (1457, 0.08018753738744802),\n",
              " (2591, 0.08006407690254358),\n",
              " (3232, 0.07975169148621072),\n",
              " (1242, 0.07968190728895957),\n",
              " (2386, 0.07968190728895957),\n",
              " (2404, 0.07955572841757301),\n",
              " (854, 0.07945521577046603),\n",
              " (1401, 0.07945521577046603),\n",
              " (2028, 0.07945521577046603),\n",
              " (3739, 0.07945521577046603),\n",
              " (3777, 0.07945521577046603),\n",
              " (1675, 0.07938161203464005),\n",
              " (3398, 0.0790569415042095),\n",
              " (4281, 0.0790569415042095),\n",
              " (3207, 0.07905694150420949),\n",
              " (1030, 0.07901663717250292),\n",
              " (3636, 0.07874259854358902),\n",
              " (2803, 0.078742598543589),\n",
              " (2520, 0.07865665062071159),\n",
              " (121, 0.07856742013183862),\n",
              " (2600, 0.07856742013183862),\n",
              " (2749, 0.07856742013183862),\n",
              " (4186, 0.07856742013183862),\n",
              " (3561, 0.07856742013183861),\n",
              " (206, 0.07829602926862714),\n",
              " (43, 0.07804881763180783),\n",
              " (196, 0.07804881763180783),\n",
              " (650, 0.07804881763180783),\n",
              " (4046, 0.07804881763180783),\n",
              " (469, 0.0776150525706333),\n",
              " (105, 0.07749842582921286),\n",
              " (894, 0.07749842582921286),\n",
              " (2538, 0.07749842582921286),\n",
              " (3354, 0.07749842582921286),\n",
              " (126, 0.07737305757377161),\n",
              " (3357, 0.07737305757377161),\n",
              " (4593, 0.07737305757377161),\n",
              " (100, 0.07715167498104597),\n",
              " (2326, 0.07715167498104597),\n",
              " (3056, 0.07715167498104597),\n",
              " (3070, 0.07715167498104597),\n",
              " (3915, 0.07715167498104597),\n",
              " (4675, 0.07715167498104597),\n",
              " (1202, 0.07715167498104596),\n",
              " (1990, 0.07715167498104596),\n",
              " (97, 0.07671455149152696),\n",
              " (262, 0.07671455149152696),\n",
              " (979, 0.07671455149152696),\n",
              " (3241, 0.07671455149152696),\n",
              " (4267, 0.07671455149152696),\n",
              " (2519, 0.0765954191681715),\n",
              " (50, 0.07647191129018727),\n",
              " (295, 0.07647191129018727),\n",
              " (1556, 0.07647191129018727),\n",
              " (4010, 0.07647191129018727),\n",
              " (4508, 0.07647191129018727),\n",
              " (1405, 0.07624928516630233),\n",
              " (4251, 0.07624928516630233),\n",
              " (369, 0.07607257743127308),\n",
              " (2492, 0.07607257743127308),\n",
              " (2832, 0.07607257743127308),\n",
              " (2812, 0.07599411162655387),\n",
              " (1215, 0.07580980435789034),\n",
              " (2570, 0.07580980435789034),\n",
              " (3378, 0.07562376774775253),\n",
              " (960, 0.07548513560963972),\n",
              " (2956, 0.07548513560963972),\n",
              " (4393, 0.07537783614444092),\n",
              " (1770, 0.07537783614444091),\n",
              " (2339, 0.07537783614444091),\n",
              " (3242, 0.07537783614444091),\n",
              " (3827, 0.07537783614444091),\n",
              " (4770, 0.07537783614444091),\n",
              " (160, 0.07530800950958867),\n",
              " (1873, 0.07495316889958616),\n",
              " (3345, 0.07495316889958616),\n",
              " (2254, 0.07483554251115622),\n",
              " (20, 0.074535599249993),\n",
              " (1073, 0.074535599249993),\n",
              " (2120, 0.074535599249993),\n",
              " (3711, 0.074535599249993),\n",
              " (475, 0.07423923386456233),\n",
              " (1906, 0.07423923386456233),\n",
              " (3783, 0.07423923386456233),\n",
              " (3823, 0.07423923386456233),\n",
              " (4228, 0.07412493166611013),\n",
              " (1246, 0.07372097807744858),\n",
              " (2851, 0.07372097807744858),\n",
              " (467, 0.0736569563735987),\n",
              " (795, 0.0736569563735987),\n",
              " (982, 0.0736569563735987),\n",
              " (1625, 0.0736569563735987),\n",
              " (1, 0.07362101738323104),\n",
              " (96, 0.07362101738323104),\n",
              " (1573, 0.07362101738323104),\n",
              " (1616, 0.07362101738323104),\n",
              " (1945, 0.07362101738323104),\n",
              " (3622, 0.07362101738323104),\n",
              " (3672, 0.07362101738323104),\n",
              " (30, 0.07308816827558579),\n",
              " (1847, 0.07308816827558579),\n",
              " (3931, 0.07308816827558579),\n",
              " (4456, 0.07308816827558579),\n",
              " (4698, 0.07308816827558579),\n",
              " (1138, 0.0727392967453308),\n",
              " (1263, 0.0727392967453308),\n",
              " (2383, 0.0727392967453308),\n",
              " (4678, 0.0727392967453308),\n",
              " (4454, 0.07253235664820744),\n",
              " (799, 0.07216878364870323),\n",
              " (1045, 0.07216878364870323),\n",
              " (2416, 0.07216878364870323),\n",
              " (3800, 0.07216878364870323),\n",
              " (4463, 0.07216878364870323),\n",
              " (471, 0.07198903546511334),\n",
              " (2099, 0.07198903546511334),\n",
              " (2215, 0.07198903546511334),\n",
              " (2648, 0.07198903546511334),\n",
              " (3778, 0.07198903546511334),\n",
              " (366, 0.07188851546895896),\n",
              " (1325, 0.07188851546895896),\n",
              " (1365, 0.07188851546895896),\n",
              " (4694, 0.07188851546895896),\n",
              " (144, 0.07179581586177383),\n",
              " (610, 0.07153292293991267),\n",
              " (331, 0.0714577438093787),\n",
              " (1538, 0.0714577438093787),\n",
              " (806, 0.07106690545187017),\n",
              " (292, 0.07106690545187015),\n",
              " (370, 0.07106690545187015),\n",
              " (945, 0.07106690545187015),\n",
              " (1364, 0.07106690545187015),\n",
              " (2012, 0.07106690545187015),\n",
              " (2219, 0.07106690545187015),\n",
              " (3924, 0.07106690545187015),\n",
              " (143, 0.07093804422989572),\n",
              " (572, 0.07093804422989572),\n",
              " (1430, 0.07093804422989572),\n",
              " (1926, 0.07093804422989572),\n",
              " (3333, 0.07093804422989572),\n",
              " (4088, 0.07093804422989572),\n",
              " (912, 0.07071067811865477),\n",
              " (2744, 0.07071067811865477),\n",
              " (3770, 0.07071067811865477),\n",
              " (3995, 0.07071067811865477),\n",
              " (19, 0.07042952122737639),\n",
              " (1775, 0.07042952122737639),\n",
              " (59, 0.0703597544730292),\n",
              " (119, 0.0703597544730292),\n",
              " (426, 0.0703597544730292),\n",
              " (675, 0.0703597544730292),\n",
              " (21, 0.07027283689263066),\n",
              " (998, 0.07027283689263066),\n",
              " (1523, 0.07027283689263066),\n",
              " (1771, 0.07027283689263066),\n",
              " (2395, 0.07027283689263066),\n",
              " (2742, 0.07027283689263066),\n",
              " (3234, 0.07027283689263066),\n",
              " (3473, 0.07027283689263066),\n",
              " (4150, 0.07027283689263066),\n",
              " (4755, 0.07027283689263066),\n",
              " (28, 0.06993177985805743),\n",
              " (124, 0.06993177985805743),\n",
              " (591, 0.06993177985805743),\n",
              " (1020, 0.06993177985805743),\n",
              " (1432, 0.06993177985805743),\n",
              " (3682, 0.06993177985805743),\n",
              " (131, 0.06950480468569159),\n",
              " (439, 0.06950480468569159),\n",
              " (1156, 0.06950480468569159),\n",
              " (4629, 0.06950480468569159),\n",
              " (2372, 0.06944444444444446),\n",
              " (1022, 0.06944444444444445),\n",
              " (654, 0.06933752452815366),\n",
              " (2871, 0.06933752452815366),\n",
              " (4062, 0.06933752452815366),\n",
              " (4205, 0.06933752452815366),\n",
              " (15, 0.06896715738353068),\n",
              " (862, 0.06896715738353068),\n",
              " (39, 0.0687614164172529),\n",
              " (372, 0.0687614164172529),\n",
              " (646, 0.0687614164172529),\n",
              " (786, 0.0687614164172529),\n",
              " (2163, 0.0687614164172529),\n",
              " (4265, 0.0687614164172529),\n",
              " (4683, 0.0687614164172529),\n",
              " (45, 0.06849957804389889),\n",
              " (79, 0.06849957804389889),\n",
              " (224, 0.06849957804389889),\n",
              " (718, 0.06849957804389889),\n",
              " (1218, 0.06849957804389889),\n",
              " (4792, 0.06849957804389889),\n",
              " (193, 0.06835859270246633),\n",
              " (922, 0.06804138174397718),\n",
              " (1010, 0.06804138174397718),\n",
              " (1026, 0.06804138174397718),\n",
              " (1240, 0.06804138174397718),\n",
              " (1605, 0.06804138174397718),\n",
              " (2311, 0.06804138174397718),\n",
              " (2730, 0.06804138174397718),\n",
              " (2978, 0.06804138174397718),\n",
              " (3157, 0.06804138174397718),\n",
              " (3429, 0.06804138174397718),\n",
              " (3722, 0.06804138174397718),\n",
              " (4025, 0.06804138174397718),\n",
              " (4605, 0.06804138174397718),\n",
              " (4706, 0.06804138174397718),\n",
              " (4780, 0.06804138174397718),\n",
              " (190, 0.06804138174397717),\n",
              " (199, 0.06759225880448438),\n",
              " (234, 0.06759225880448438),\n",
              " (827, 0.06759225880448438),\n",
              " (2005, 0.06759225880448438),\n",
              " (1596, 0.06734350297014739),\n",
              " (2650, 0.06734350297014739),\n",
              " (3408, 0.06734350297014739),\n",
              " (3494, 0.06734350297014739),\n",
              " (3861, 0.06734350297014739),\n",
              " (2686, 0.0671519136687817),\n",
              " (2759, 0.0671519136687817),\n",
              " (418, 0.0668153104781061),\n",
              " (1262, 0.0668153104781061),\n",
              " (4136, 0.0668153104781061),\n",
              " (4641, 0.0668153104781061),\n",
              " (76, 0.06666666666666668),\n",
              " (602, 0.06666666666666668),\n",
              " (833, 0.06666666666666668),\n",
              " (871, 0.06666666666666668),\n",
              " (961, 0.06666666666666668),\n",
              " (2722, 0.06666666666666668),\n",
              " (3153, 0.06666666666666668),\n",
              " (410, 0.06651901052377394),\n",
              " (1880, 0.06651901052377394),\n",
              " (1997, 0.0662964403479775),\n",
              " (291, 0.06600983619844496),\n",
              " (492, 0.06600983619844496),\n",
              " (1347, 0.06600983619844496),\n",
              " (1800, 0.06600983619844496),\n",
              " (4569, 0.06600983619844496),\n",
              " (670, 0.06593804733957871),\n",
              " (167, 0.06565321642986129),\n",
              " (205, 0.06565321642986129),\n",
              " (498, 0.06565321642986129),\n",
              " (1085, 0.06565321642986129),\n",
              " (1480, 0.06565321642986129),\n",
              " (2268, 0.06565321642986129),\n",
              " (2270, 0.06565321642986129),\n",
              " (2506, 0.06565321642986129),\n",
              " (2521, 0.06565321642986129),\n",
              " (3263, 0.06565321642986129),\n",
              " (3932, 0.06565321642986129),\n",
              " (38, 0.06547285010986552),\n",
              " (3261, 0.06547285010986552),\n",
              " (543, 0.06537204504606135),\n",
              " (782, 0.06537204504606135),\n",
              " (875, 0.06537204504606135),\n",
              " (1272, 0.06537204504606135),\n",
              " (1698, 0.06537204504606135),\n",
              " (3992, 0.06537204504606135),\n",
              " (1959, 0.0650724007869192),\n",
              " (11, 0.06475239082381762),\n",
              " (1123, 0.06475239082381762),\n",
              " (1692, 0.06475239082381762),\n",
              " (2018, 0.06475239082381762),\n",
              " (2091, 0.06475239082381762),\n",
              " (3331, 0.06475239082381762),\n",
              " (3449, 0.06475239082381762),\n",
              " (4400, 0.06475239082381762),\n",
              " ...]"
            ]
          },
          "metadata": {},
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "def recommend(movie):\n",
        "  movie_index = False\n",
        "  for i in range(0, len(final_data)):\n",
        "    if final_data['title'][i]==movie:\n",
        "      movie_index = i\n",
        "      print(\"Movie's index\", i)\n",
        "      break\n",
        "\n",
        "  if movie_index:\n",
        "    similarity_ids = sorted(list(enumerate(simi[movie_index])), reverse=True, key=lambda x:x[1])[1:10]\n",
        "    return [final_data['title'][i[0]] for i in similarity_ids]\n",
        "  else:\n",
        "    return \"Sorry, Movie not in database or there's a Typo\"\n",
        "\n",
        "recommend(\"Man of Steel\")"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "MlOapnt8mozr",
        "outputId": "4f40a28c-2b77-4dbc-cd8e-5d6768add845"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Movie's index 14\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['Superman III',\n",
              " 'Batman v Superman: Dawn of Justice',\n",
              " 'Superman',\n",
              " 'Superman II',\n",
              " 'Superman Returns',\n",
              " 'X-Men: Apocalypse',\n",
              " 'X-Men: First Class',\n",
              " 'Suicide Squad',\n",
              " 'Green Lantern']"
            ]
          },
          "metadata": {},
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "print(\"Available movies:\")\n",
        "print(final_data['title'][10:20])"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Odmz_Lnk_p9h",
        "outputId": "b1ac9445-6aca-4d3d-e65e-3ae8cf40a8cd"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Available movies:\n",
            "10                               Superman Returns\n",
            "11                              Quantum of Solace\n",
            "12     Pirates of the Caribbean: Dead Man's Chest\n",
            "13                                The Lone Ranger\n",
            "14                                   Man of Steel\n",
            "15       The Chronicles of Narnia: Prince Caspian\n",
            "16                                   The Avengers\n",
            "17    Pirates of the Caribbean: On Stranger Tides\n",
            "18                                 Men in Black 3\n",
            "19      The Hobbit: The Battle of the Five Armies\n",
            "Name: title, dtype: object\n"
          ]
        }
      ]
    }
  ]
}