Overview_of_the_Datasets_Data_Wrangling_and_Data_Cleaning.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Overview of the Datasets -- Data Wrangling and Data Cleaning ",
      "provenance": [],
      "collapsed_sections": [],
      "machine_shape": "hm",
      "authorship_tag": "ABX9TyMbXggg6R7Hm7vuL9Xk3cQ/",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/disha2sinha/Movie-Recommendation-System/blob/master/Overview_of_the_Datasets_Data_Wrangling_and_Data_Cleaning.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "8KKs7NwcRp7L"
      },
      "source": [
        "**Libraries:**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "YLH84Eo6yd8w"
      },
      "source": [
        "%matplotlib inline\n",
        "import pandas as pd\n",
        "import numpy as np\n",
        "from ast import literal_eval\n",
        "import matplotlib.pyplot as plt\n",
        "!pip install -U -q google_trans_new\n",
        "from google_trans_new import google_translator\n",
        "import seaborn as sns\n"
      ],
      "execution_count": 1,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "FPERJZ06ySt0"
      },
      "source": [
        "!pip install -U -q PyDrive\n",
        "from pydrive.auth import GoogleAuth\n",
        "from pydrive.drive import GoogleDrive\n",
        "from google.colab import auth\n",
        "from oauth2client.client import GoogleCredentials"
      ],
      "execution_count": 2,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "vTu_Ui-MybLg"
      },
      "source": [
        "auth.authenticate_user()\n",
        "gauth = GoogleAuth()\n",
        "gauth.credentials = GoogleCredentials.get_application_default()\n",
        "drive = GoogleDrive(gauth)"
      ],
      "execution_count": 3,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Csiacp9O3Aqa"
      },
      "source": [
        "**IMPORTING 'movies_metadata.csv' :**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "_3pO9maMyv1x"
      },
      "source": [
        "link1='https://drive.google.com/file/d/1xjASvbR3qrZ_Xx1rwmb2YoTGt081ih0G/view?usp=sharing'"
      ],
      "execution_count": 4,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "4490zAj1zAyn",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 652
        },
        "outputId": "5d844f3c-2616-4a00-a318-0c0533065bdd"
      },
      "source": [
        "id='1xjASvbR3qrZ_Xx1rwmb2YoTGt081ih0G'\n",
        "downloaded = drive.CreateFile({'id':id}) \n",
        "downloaded.GetContentFile('movies_metadata.csv')  \n",
        "movies_metadata = pd.read_csv('movies_metadata.csv',engine='python')\n",
        "movies_metadata.head(5)"
      ],
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>adult</th>\n",
              "      <th>belongs_to_collection</th>\n",
              "      <th>budget</th>\n",
              "      <th>genres</th>\n",
              "      <th>homepage</th>\n",
              "      <th>id</th>\n",
              "      <th>imdb_id</th>\n",
              "      <th>original_language</th>\n",
              "      <th>original_title</th>\n",
              "      <th>overview</th>\n",
              "      <th>popularity</th>\n",
              "      <th>poster_path</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>production_countries</th>\n",
              "      <th>release_date</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>spoken_languages</th>\n",
              "      <th>status</th>\n",
              "      <th>tagline</th>\n",
              "      <th>title</th>\n",
              "      <th>video</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>False</td>\n",
              "      <td>{'id': 10194, 'name': 'Toy Story Collection', ...</td>\n",
              "      <td>30000000</td>\n",
              "      <td>[{'id': 16, 'name': 'Animation'}, {'id': 35, '...</td>\n",
              "      <td>http://toystory.disney.com/toy-story</td>\n",
              "      <td>862</td>\n",
              "      <td>tt0114709</td>\n",
              "      <td>en</td>\n",
              "      <td>Toy Story</td>\n",
              "      <td>Led by Woody, Andy's toys live happily in his ...</td>\n",
              "      <td>21.946943</td>\n",
              "      <td>/rhIRbceoE9lR4veEXuwCC2wARtG.jpg</td>\n",
              "      <td>[{'name': 'Pixar Animation Studios', 'id': 3}]</td>\n",
              "      <td>[{'iso_3166_1': 'US', 'name': 'United States o...</td>\n",
              "      <td>1995-10-30</td>\n",
              "      <td>373554033.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Toy Story</td>\n",
              "      <td>False</td>\n",
              "      <td>7.7</td>\n",
              "      <td>5415.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "      <td>65000000</td>\n",
              "      <td>[{'id': 12, 'name': 'Adventure'}, {'id': 14, '...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8844</td>\n",
              "      <td>tt0113497</td>\n",
              "      <td>en</td>\n",
              "      <td>Jumanji</td>\n",
              "      <td>When siblings Judy and Peter discover an encha...</td>\n",
              "      <td>17.015539</td>\n",
              "      <td>/vzmL6fP7aPKNKPRTFnZmiUfciyV.jpg</td>\n",
              "      <td>[{'name': 'TriStar Pictures', 'id': 559}, {'na...</td>\n",
              "      <td>[{'iso_3166_1': 'US', 'name': 'United States o...</td>\n",
              "      <td>1995-12-15</td>\n",
              "      <td>262797249.0</td>\n",
              "      <td>104.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
              "      <td>Released</td>\n",
              "      <td>Roll the dice and unleash the excitement!</td>\n",
              "      <td>Jumanji</td>\n",
              "      <td>False</td>\n",
              "      <td>6.9</td>\n",
              "      <td>2413.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>False</td>\n",
              "      <td>{'id': 119050, 'name': 'Grumpy Old Men Collect...</td>\n",
              "      <td>0</td>\n",
              "      <td>[{'id': 10749, 'name': 'Romance'}, {'id': 35, ...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>15602</td>\n",
              "      <td>tt0113228</td>\n",
              "      <td>en</td>\n",
              "      <td>Grumpier Old Men</td>\n",
              "      <td>A family wedding reignites the ancient feud be...</td>\n",
              "      <td>11.7129</td>\n",
              "      <td>/6ksm1sjKMFLbO7UY2i6G1ju9SML.jpg</td>\n",
              "      <td>[{'name': 'Warner Bros.', 'id': 6194}, {'name'...</td>\n",
              "      <td>[{'iso_3166_1': 'US', 'name': 'United States o...</td>\n",
              "      <td>1995-12-22</td>\n",
              "      <td>0.0</td>\n",
              "      <td>101.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Still Yelling. Still Fighting. Still Ready for...</td>\n",
              "      <td>Grumpier Old Men</td>\n",
              "      <td>False</td>\n",
              "      <td>6.5</td>\n",
              "      <td>92.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "      <td>16000000</td>\n",
              "      <td>[{'id': 35, 'name': 'Comedy'}, {'id': 18, 'nam...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>31357</td>\n",
              "      <td>tt0114885</td>\n",
              "      <td>en</td>\n",
              "      <td>Waiting to Exhale</td>\n",
              "      <td>Cheated on, mistreated and stepped on, the wom...</td>\n",
              "      <td>3.859495</td>\n",
              "      <td>/16XOMpEaLWkrcPqSQqhTmeJuqQl.jpg</td>\n",
              "      <td>[{'name': 'Twentieth Century Fox Film Corporat...</td>\n",
              "      <td>[{'iso_3166_1': 'US', 'name': 'United States o...</td>\n",
              "      <td>1995-12-22</td>\n",
              "      <td>81452156.0</td>\n",
              "      <td>127.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Friends are the people who let you be yourself...</td>\n",
              "      <td>Waiting to Exhale</td>\n",
              "      <td>False</td>\n",
              "      <td>6.1</td>\n",
              "      <td>34.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>False</td>\n",
              "      <td>{'id': 96871, 'name': 'Father of the Bride Col...</td>\n",
              "      <td>0</td>\n",
              "      <td>[{'id': 35, 'name': 'Comedy'}]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>11862</td>\n",
              "      <td>tt0113041</td>\n",
              "      <td>en</td>\n",
              "      <td>Father of the Bride Part II</td>\n",
              "      <td>Just when George Banks has recovered from his ...</td>\n",
              "      <td>8.387519</td>\n",
              "      <td>/e64sOI48hQXyru7naBFyssKFxVd.jpg</td>\n",
              "      <td>[{'name': 'Sandollar Productions', 'id': 5842}...</td>\n",
              "      <td>[{'iso_3166_1': 'US', 'name': 'United States o...</td>\n",
              "      <td>1995-02-10</td>\n",
              "      <td>76578911.0</td>\n",
              "      <td>106.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Just When His World Is Back To Normal... He's ...</td>\n",
              "      <td>Father of the Bride Part II</td>\n",
              "      <td>False</td>\n",
              "      <td>5.7</td>\n",
              "      <td>173.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   adult  ... vote_count\n",
              "0  False  ...     5415.0\n",
              "1  False  ...     2413.0\n",
              "2  False  ...       92.0\n",
              "3  False  ...       34.0\n",
              "4  False  ...      173.0\n",
              "\n",
              "[5 rows x 24 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "0T7QeK2wTYPP"
      },
      "source": [
        "**IMPORTING links.csv :** This dataset contains the TMDB and IMDB ids of the movies in **'movies_metadata.csv'** ."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "IRBYIa0_k-7z",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 195
        },
        "outputId": "cd26ac0b-4e93-447a-e3da-8f36cf962d03"
      },
      "source": [
        "id='1nKE39CrU55_PImhV1IRznySDkrmsywWG'\n",
        "downloaded = drive.CreateFile({'id':id}) \n",
        "downloaded.GetContentFile('links.csv')  \n",
        "links = pd.read_csv('links.csv',engine='python')\n",
        "links.head(5)"
      ],
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>movieId</th>\n",
              "      <th>imdbId</th>\n",
              "      <th>tmdbId</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>114709</td>\n",
              "      <td>862.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>113497</td>\n",
              "      <td>8844.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>113228</td>\n",
              "      <td>15602.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4</td>\n",
              "      <td>114885</td>\n",
              "      <td>31357.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>5</td>\n",
              "      <td>113041</td>\n",
              "      <td>11862.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   movieId  imdbId   tmdbId\n",
              "0        1  114709    862.0\n",
              "1        2  113497   8844.0\n",
              "2        3  113228  15602.0\n",
              "3        4  114885  31357.0\n",
              "4        5  113041  11862.0"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "F9QtZtqllQM3",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "1b1ddd78-f562-4b6f-ee83-cbe9db68ddd2"
      },
      "source": [
        "links.info()"
      ],
      "execution_count": 7,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 9125 entries, 0 to 9124\n",
            "Data columns (total 3 columns):\n",
            " #   Column   Non-Null Count  Dtype  \n",
            "---  ------   --------------  -----  \n",
            " 0   movieId  9125 non-null   int64  \n",
            " 1   imdbId   9125 non-null   int64  \n",
            " 2   tmdbId   9112 non-null   float64\n",
            "dtypes: float64(1), int64(2)\n",
            "memory usage: 214.0 KB\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "tOUVnMoAUuYy"
      },
      "source": [
        "**MERGING THE 'movies_metadata' DATAFRAME WITH THE 'links.csv'**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "5xZq_dsBlmtO",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "ac4c5ec6-52a4-48e0-997c-ccccf5daea6a"
      },
      "source": [
        "movies_metadata['id'] = pd.to_numeric(movies_metadata['id'],errors='coerce')\n",
        "movies_metadata.info()"
      ],
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 45466 entries, 0 to 45465\n",
            "Data columns (total 24 columns):\n",
            " #   Column                 Non-Null Count  Dtype  \n",
            "---  ------                 --------------  -----  \n",
            " 0   adult                  45466 non-null  object \n",
            " 1   belongs_to_collection  4494 non-null   object \n",
            " 2   budget                 45466 non-null  object \n",
            " 3   genres                 45466 non-null  object \n",
            " 4   homepage               7782 non-null   object \n",
            " 5   id                     45463 non-null  float64\n",
            " 6   imdb_id                45449 non-null  object \n",
            " 7   original_language      45455 non-null  object \n",
            " 8   original_title         45466 non-null  object \n",
            " 9   overview               44512 non-null  object \n",
            " 10  popularity             45461 non-null  object \n",
            " 11  poster_path            45080 non-null  object \n",
            " 12  production_companies   45463 non-null  object \n",
            " 13  production_countries   45463 non-null  object \n",
            " 14  release_date           45379 non-null  object \n",
            " 15  revenue                45460 non-null  float64\n",
            " 16  runtime                45203 non-null  float64\n",
            " 17  spoken_languages       45460 non-null  object \n",
            " 18  status                 45379 non-null  object \n",
            " 19  tagline                20412 non-null  object \n",
            " 20  title                  45460 non-null  object \n",
            " 21  video                  45460 non-null  object \n",
            " 22  vote_average           45460 non-null  float64\n",
            " 23  vote_count             45460 non-null  float64\n",
            "dtypes: float64(5), object(19)\n",
            "memory usage: 8.3+ MB\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "PAIidtzsl9nD",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "791f45f8-edb0-41c4-aa14-1fbba7ef9624"
      },
      "source": [
        "links['tmdbId']=np.array(links['tmdbId'], np.int64)\n",
        "links.info()"
      ],
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 9125 entries, 0 to 9124\n",
            "Data columns (total 3 columns):\n",
            " #   Column   Non-Null Count  Dtype\n",
            "---  ------   --------------  -----\n",
            " 0   movieId  9125 non-null   int64\n",
            " 1   imdbId   9125 non-null   int64\n",
            " 2   tmdbId   9125 non-null   int64\n",
            "dtypes: int64(3)\n",
            "memory usage: 214.0 KB\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "jQaThxWbnQbI",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 652
        },
        "outputId": "a3acb2a6-dec6-449a-e75c-447754c53c80"
      },
      "source": [
        "movies_metadata.rename(columns={'id':'tmdbId'}, inplace=True)\n",
        "movies_metadata = pd.merge(movies_metadata,links,on='tmdbId')\n",
        "movies_metadata.head()"
      ],
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>adult</th>\n",
              "      <th>belongs_to_collection</th>\n",
              "      <th>budget</th>\n",
              "      <th>genres</th>\n",
              "      <th>homepage</th>\n",
              "      <th>tmdbId</th>\n",
              "      <th>imdb_id</th>\n",
              "      <th>original_language</th>\n",
              "      <th>original_title</th>\n",
              "      <th>overview</th>\n",
              "      <th>popularity</th>\n",
              "      <th>poster_path</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>production_countries</th>\n",
              "      <th>release_date</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>spoken_languages</th>\n",
              "      <th>status</th>\n",
              "      <th>tagline</th>\n",
              "      <th>title</th>\n",
              "      <th>video</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>movieId</th>\n",
              "      <th>imdbId</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>False</td>\n",
              "      <td>{'id': 10194, 'name': 'Toy Story Collection', ...</td>\n",
              "      <td>30000000</td>\n",
              "      <td>[{'id': 16, 'name': 'Animation'}, {'id': 35, '...</td>\n",
              "      <td>http://toystory.disney.com/toy-story</td>\n",
              "      <td>862.0</td>\n",
              "      <td>tt0114709</td>\n",
              "      <td>en</td>\n",
              "      <td>Toy Story</td>\n",
              "      <td>Led by Woody, Andy's toys live happily in his ...</td>\n",
              "      <td>21.946943</td>\n",
              "      <td>/rhIRbceoE9lR4veEXuwCC2wARtG.jpg</td>\n",
              "      <td>[{'name': 'Pixar Animation Studios', 'id': 3}]</td>\n",
              "      <td>[{'iso_3166_1': 'US', 'name': 'United States o...</td>\n",
              "      <td>1995-10-30</td>\n",
              "      <td>373554033.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Toy Story</td>\n",
              "      <td>False</td>\n",
              "      <td>7.7</td>\n",
              "      <td>5415.0</td>\n",
              "      <td>1</td>\n",
              "      <td>114709</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "      <td>65000000</td>\n",
              "      <td>[{'id': 12, 'name': 'Adventure'}, {'id': 14, '...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8844.0</td>\n",
              "      <td>tt0113497</td>\n",
              "      <td>en</td>\n",
              "      <td>Jumanji</td>\n",
              "      <td>When siblings Judy and Peter discover an encha...</td>\n",
              "      <td>17.015539</td>\n",
              "      <td>/vzmL6fP7aPKNKPRTFnZmiUfciyV.jpg</td>\n",
              "      <td>[{'name': 'TriStar Pictures', 'id': 559}, {'na...</td>\n",
              "      <td>[{'iso_3166_1': 'US', 'name': 'United States o...</td>\n",
              "      <td>1995-12-15</td>\n",
              "      <td>262797249.0</td>\n",
              "      <td>104.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
              "      <td>Released</td>\n",
              "      <td>Roll the dice and unleash the excitement!</td>\n",
              "      <td>Jumanji</td>\n",
              "      <td>False</td>\n",
              "      <td>6.9</td>\n",
              "      <td>2413.0</td>\n",
              "      <td>2</td>\n",
              "      <td>113497</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>False</td>\n",
              "      <td>{'id': 119050, 'name': 'Grumpy Old Men Collect...</td>\n",
              "      <td>0</td>\n",
              "      <td>[{'id': 10749, 'name': 'Romance'}, {'id': 35, ...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>15602.0</td>\n",
              "      <td>tt0113228</td>\n",
              "      <td>en</td>\n",
              "      <td>Grumpier Old Men</td>\n",
              "      <td>A family wedding reignites the ancient feud be...</td>\n",
              "      <td>11.7129</td>\n",
              "      <td>/6ksm1sjKMFLbO7UY2i6G1ju9SML.jpg</td>\n",
              "      <td>[{'name': 'Warner Bros.', 'id': 6194}, {'name'...</td>\n",
              "      <td>[{'iso_3166_1': 'US', 'name': 'United States o...</td>\n",
              "      <td>1995-12-22</td>\n",
              "      <td>0.0</td>\n",
              "      <td>101.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Still Yelling. Still Fighting. Still Ready for...</td>\n",
              "      <td>Grumpier Old Men</td>\n",
              "      <td>False</td>\n",
              "      <td>6.5</td>\n",
              "      <td>92.0</td>\n",
              "      <td>3</td>\n",
              "      <td>113228</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "      <td>16000000</td>\n",
              "      <td>[{'id': 35, 'name': 'Comedy'}, {'id': 18, 'nam...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>31357.0</td>\n",
              "      <td>tt0114885</td>\n",
              "      <td>en</td>\n",
              "      <td>Waiting to Exhale</td>\n",
              "      <td>Cheated on, mistreated and stepped on, the wom...</td>\n",
              "      <td>3.859495</td>\n",
              "      <td>/16XOMpEaLWkrcPqSQqhTmeJuqQl.jpg</td>\n",
              "      <td>[{'name': 'Twentieth Century Fox Film Corporat...</td>\n",
              "      <td>[{'iso_3166_1': 'US', 'name': 'United States o...</td>\n",
              "      <td>1995-12-22</td>\n",
              "      <td>81452156.0</td>\n",
              "      <td>127.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Friends are the people who let you be yourself...</td>\n",
              "      <td>Waiting to Exhale</td>\n",
              "      <td>False</td>\n",
              "      <td>6.1</td>\n",
              "      <td>34.0</td>\n",
              "      <td>4</td>\n",
              "      <td>114885</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>False</td>\n",
              "      <td>{'id': 96871, 'name': 'Father of the Bride Col...</td>\n",
              "      <td>0</td>\n",
              "      <td>[{'id': 35, 'name': 'Comedy'}]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>11862.0</td>\n",
              "      <td>tt0113041</td>\n",
              "      <td>en</td>\n",
              "      <td>Father of the Bride Part II</td>\n",
              "      <td>Just when George Banks has recovered from his ...</td>\n",
              "      <td>8.387519</td>\n",
              "      <td>/e64sOI48hQXyru7naBFyssKFxVd.jpg</td>\n",
              "      <td>[{'name': 'Sandollar Productions', 'id': 5842}...</td>\n",
              "      <td>[{'iso_3166_1': 'US', 'name': 'United States o...</td>\n",
              "      <td>1995-02-10</td>\n",
              "      <td>76578911.0</td>\n",
              "      <td>106.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Just When His World Is Back To Normal... He's ...</td>\n",
              "      <td>Father of the Bride Part II</td>\n",
              "      <td>False</td>\n",
              "      <td>5.7</td>\n",
              "      <td>173.0</td>\n",
              "      <td>5</td>\n",
              "      <td>113041</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   adult                              belongs_to_collection  ... movieId  imdbId\n",
              "0  False  {'id': 10194, 'name': 'Toy Story Collection', ...  ...       1  114709\n",
              "1  False                                                NaN  ...       2  113497\n",
              "2  False  {'id': 119050, 'name': 'Grumpy Old Men Collect...  ...       3  113228\n",
              "3  False                                                NaN  ...       4  114885\n",
              "4  False  {'id': 96871, 'name': 'Father of the Bride Col...  ...       5  113041\n",
              "\n",
              "[5 rows x 26 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "H6YDblUMoxrW",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "efd322bc-f9ea-4977-c68e-d1fcc458b36b"
      },
      "source": [
        "movies_metadata=movies_metadata[movies_metadata['title']!=\"Unknown\"]\n",
        "movies_metadata['tmdbId']=movies_metadata['tmdbId'].astype(int)\n",
        "movies_metadata.reset_index(drop=True)\n",
        "movies_metadata.info()"
      ],
      "execution_count": 11,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "Int64Index: 9098 entries, 0 to 9098\n",
            "Data columns (total 26 columns):\n",
            " #   Column                 Non-Null Count  Dtype  \n",
            "---  ------                 --------------  -----  \n",
            " 0   adult                  9098 non-null   object \n",
            " 1   belongs_to_collection  1674 non-null   object \n",
            " 2   budget                 9098 non-null   object \n",
            " 3   genres                 9098 non-null   object \n",
            " 4   homepage               1973 non-null   object \n",
            " 5   tmdbId                 9098 non-null   int64  \n",
            " 6   imdb_id                9098 non-null   object \n",
            " 7   original_language      9098 non-null   object \n",
            " 8   original_title         9098 non-null   object \n",
            " 9   overview               9086 non-null   object \n",
            " 10  popularity             9098 non-null   object \n",
            " 11  poster_path            9095 non-null   object \n",
            " 12  production_companies   9098 non-null   object \n",
            " 13  production_countries   9098 non-null   object \n",
            " 14  release_date           9098 non-null   object \n",
            " 15  revenue                9098 non-null   float64\n",
            " 16  runtime                9098 non-null   float64\n",
            " 17  spoken_languages       9098 non-null   object \n",
            " 18  status                 9096 non-null   object \n",
            " 19  tagline                7032 non-null   object \n",
            " 20  title                  9098 non-null   object \n",
            " 21  video                  9098 non-null   object \n",
            " 22  vote_average           9098 non-null   float64\n",
            " 23  vote_count             9098 non-null   float64\n",
            " 24  movieId                9098 non-null   int64  \n",
            " 25  imdbId                 9098 non-null   int64  \n",
            "dtypes: float64(4), int64(3), object(19)\n",
            "memory usage: 1.9+ MB\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "bO8tT9H3DZnS"
      },
      "source": [
        "**Exploring movies_metadata.csv :** \n",
        "Showing Shape and Column of the **movies_metadata** dataset."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "usdpqKZdGNQz",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "1af09f3d-55cd-4088-8c3e-6fe65efacedb"
      },
      "source": [
        "movies_metadata.shape"
      ],
      "execution_count": 12,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(9098, 26)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 12
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "_bmxanNxDQ9R",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "a7e56f2a-037a-41be-e11d-65a4b73f3dc8"
      },
      "source": [
        "movies_metadata.columns"
      ],
      "execution_count": 13,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['adult', 'belongs_to_collection', 'budget', 'genres', 'homepage',\n",
              "       'tmdbId', 'imdb_id', 'original_language', 'original_title', 'overview',\n",
              "       'popularity', 'poster_path', 'production_companies',\n",
              "       'production_countries', 'release_date', 'revenue', 'runtime',\n",
              "       'spoken_languages', 'status', 'tagline', 'title', 'video',\n",
              "       'vote_average', 'vote_count', 'movieId', 'imdbId'],\n",
              "      dtype='object')"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "sa8JggCpQUJR"
      },
      "source": [
        "**Modifying the columns 'genre' , 'production_companies' , 'production_countries' , 'spoken_languages' :** Keeping only the value of the 'name' key in the list of these columns for ease of understanding and analysis."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "O77_MtMiEKQv",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 652
        },
        "outputId": "91f77650-4c47-43b8-eb19-378826925139"
      },
      "source": [
        "movies_metadata['genres'] = movies_metadata['genres'].fillna('[]').apply(literal_eval).apply(lambda x: [i['name'] for i in x] if isinstance(x, list) else [])\n",
        "movies_metadata['production_companies'] = movies_metadata['production_companies'].fillna('[]').apply(literal_eval).apply(lambda x: [i['name'] for i in x] if isinstance(x, list) else [])\n",
        "movies_metadata['production_countries'] = movies_metadata['production_countries'].fillna('[]').apply(literal_eval).apply(lambda x: [i['name'] for i in x] if isinstance(x, list) else [])\n",
        "movies_metadata.head(5)"
      ],
      "execution_count": 14,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>adult</th>\n",
              "      <th>belongs_to_collection</th>\n",
              "      <th>budget</th>\n",
              "      <th>genres</th>\n",
              "      <th>homepage</th>\n",
              "      <th>tmdbId</th>\n",
              "      <th>imdb_id</th>\n",
              "      <th>original_language</th>\n",
              "      <th>original_title</th>\n",
              "      <th>overview</th>\n",
              "      <th>popularity</th>\n",
              "      <th>poster_path</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>production_countries</th>\n",
              "      <th>release_date</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>spoken_languages</th>\n",
              "      <th>status</th>\n",
              "      <th>tagline</th>\n",
              "      <th>title</th>\n",
              "      <th>video</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>movieId</th>\n",
              "      <th>imdbId</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>False</td>\n",
              "      <td>{'id': 10194, 'name': 'Toy Story Collection', ...</td>\n",
              "      <td>30000000</td>\n",
              "      <td>[Animation, Comedy, Family]</td>\n",
              "      <td>http://toystory.disney.com/toy-story</td>\n",
              "      <td>862</td>\n",
              "      <td>tt0114709</td>\n",
              "      <td>en</td>\n",
              "      <td>Toy Story</td>\n",
              "      <td>Led by Woody, Andy's toys live happily in his ...</td>\n",
              "      <td>21.946943</td>\n",
              "      <td>/rhIRbceoE9lR4veEXuwCC2wARtG.jpg</td>\n",
              "      <td>[Pixar Animation Studios]</td>\n",
              "      <td>[United States of America]</td>\n",
              "      <td>1995-10-30</td>\n",
              "      <td>373554033.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Toy Story</td>\n",
              "      <td>False</td>\n",
              "      <td>7.7</td>\n",
              "      <td>5415.0</td>\n",
              "      <td>1</td>\n",
              "      <td>114709</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "      <td>65000000</td>\n",
              "      <td>[Adventure, Fantasy, Family]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8844</td>\n",
              "      <td>tt0113497</td>\n",
              "      <td>en</td>\n",
              "      <td>Jumanji</td>\n",
              "      <td>When siblings Judy and Peter discover an encha...</td>\n",
              "      <td>17.015539</td>\n",
              "      <td>/vzmL6fP7aPKNKPRTFnZmiUfciyV.jpg</td>\n",
              "      <td>[TriStar Pictures, Teitler Film, Interscope Co...</td>\n",
              "      <td>[United States of America]</td>\n",
              "      <td>1995-12-15</td>\n",
              "      <td>262797249.0</td>\n",
              "      <td>104.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
              "      <td>Released</td>\n",
              "      <td>Roll the dice and unleash the excitement!</td>\n",
              "      <td>Jumanji</td>\n",
              "      <td>False</td>\n",
              "      <td>6.9</td>\n",
              "      <td>2413.0</td>\n",
              "      <td>2</td>\n",
              "      <td>113497</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>False</td>\n",
              "      <td>{'id': 119050, 'name': 'Grumpy Old Men Collect...</td>\n",
              "      <td>0</td>\n",
              "      <td>[Romance, Comedy]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>15602</td>\n",
              "      <td>tt0113228</td>\n",
              "      <td>en</td>\n",
              "      <td>Grumpier Old Men</td>\n",
              "      <td>A family wedding reignites the ancient feud be...</td>\n",
              "      <td>11.7129</td>\n",
              "      <td>/6ksm1sjKMFLbO7UY2i6G1ju9SML.jpg</td>\n",
              "      <td>[Warner Bros., Lancaster Gate]</td>\n",
              "      <td>[United States of America]</td>\n",
              "      <td>1995-12-22</td>\n",
              "      <td>0.0</td>\n",
              "      <td>101.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Still Yelling. Still Fighting. Still Ready for...</td>\n",
              "      <td>Grumpier Old Men</td>\n",
              "      <td>False</td>\n",
              "      <td>6.5</td>\n",
              "      <td>92.0</td>\n",
              "      <td>3</td>\n",
              "      <td>113228</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "      <td>16000000</td>\n",
              "      <td>[Comedy, Drama, Romance]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>31357</td>\n",
              "      <td>tt0114885</td>\n",
              "      <td>en</td>\n",
              "      <td>Waiting to Exhale</td>\n",
              "      <td>Cheated on, mistreated and stepped on, the wom...</td>\n",
              "      <td>3.859495</td>\n",
              "      <td>/16XOMpEaLWkrcPqSQqhTmeJuqQl.jpg</td>\n",
              "      <td>[Twentieth Century Fox Film Corporation]</td>\n",
              "      <td>[United States of America]</td>\n",
              "      <td>1995-12-22</td>\n",
              "      <td>81452156.0</td>\n",
              "      <td>127.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Friends are the people who let you be yourself...</td>\n",
              "      <td>Waiting to Exhale</td>\n",
              "      <td>False</td>\n",
              "      <td>6.1</td>\n",
              "      <td>34.0</td>\n",
              "      <td>4</td>\n",
              "      <td>114885</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>False</td>\n",
              "      <td>{'id': 96871, 'name': 'Father of the Bride Col...</td>\n",
              "      <td>0</td>\n",
              "      <td>[Comedy]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>11862</td>\n",
              "      <td>tt0113041</td>\n",
              "      <td>en</td>\n",
              "      <td>Father of the Bride Part II</td>\n",
              "      <td>Just when George Banks has recovered from his ...</td>\n",
              "      <td>8.387519</td>\n",
              "      <td>/e64sOI48hQXyru7naBFyssKFxVd.jpg</td>\n",
              "      <td>[Sandollar Productions, Touchstone Pictures]</td>\n",
              "      <td>[United States of America]</td>\n",
              "      <td>1995-02-10</td>\n",
              "      <td>76578911.0</td>\n",
              "      <td>106.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Just When His World Is Back To Normal... He's ...</td>\n",
              "      <td>Father of the Bride Part II</td>\n",
              "      <td>False</td>\n",
              "      <td>5.7</td>\n",
              "      <td>173.0</td>\n",
              "      <td>5</td>\n",
              "      <td>113041</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   adult                              belongs_to_collection  ... movieId  imdbId\n",
              "0  False  {'id': 10194, 'name': 'Toy Story Collection', ...  ...       1  114709\n",
              "1  False                                                NaN  ...       2  113497\n",
              "2  False  {'id': 119050, 'name': 'Grumpy Old Men Collect...  ...       3  113228\n",
              "3  False                                                NaN  ...       4  114885\n",
              "4  False  {'id': 96871, 'name': 'Father of the Bride Col...  ...       5  113041\n",
              "\n",
              "[5 rows x 26 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "vetujTa3xK3V",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 652
        },
        "outputId": "3eb2c054-e0c1-4be8-f972-d76ead79fb39"
      },
      "source": [
        "def try_join(l):\n",
        "  try:\n",
        "    return '|'.join(map(str,l))\n",
        "  except TypeError:\n",
        "    return 'Unknown'\n",
        "movies_metadata['genres']=[try_join(l)for l in movies_metadata['genres']]\n",
        "movies_metadata['production_companies']=[try_join(l)for l in movies_metadata['production_companies']]\n",
        "movies_metadata['production_countries']=[try_join(l)for l in movies_metadata['production_countries']]\n",
        "movies_metadata.head()"
      ],
      "execution_count": 15,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>adult</th>\n",
              "      <th>belongs_to_collection</th>\n",
              "      <th>budget</th>\n",
              "      <th>genres</th>\n",
              "      <th>homepage</th>\n",
              "      <th>tmdbId</th>\n",
              "      <th>imdb_id</th>\n",
              "      <th>original_language</th>\n",
              "      <th>original_title</th>\n",
              "      <th>overview</th>\n",
              "      <th>popularity</th>\n",
              "      <th>poster_path</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>production_countries</th>\n",
              "      <th>release_date</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>spoken_languages</th>\n",
              "      <th>status</th>\n",
              "      <th>tagline</th>\n",
              "      <th>title</th>\n",
              "      <th>video</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>movieId</th>\n",
              "      <th>imdbId</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>False</td>\n",
              "      <td>{'id': 10194, 'name': 'Toy Story Collection', ...</td>\n",
              "      <td>30000000</td>\n",
              "      <td>Animation|Comedy|Family</td>\n",
              "      <td>http://toystory.disney.com/toy-story</td>\n",
              "      <td>862</td>\n",
              "      <td>tt0114709</td>\n",
              "      <td>en</td>\n",
              "      <td>Toy Story</td>\n",
              "      <td>Led by Woody, Andy's toys live happily in his ...</td>\n",
              "      <td>21.946943</td>\n",
              "      <td>/rhIRbceoE9lR4veEXuwCC2wARtG.jpg</td>\n",
              "      <td>Pixar Animation Studios</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-10-30</td>\n",
              "      <td>373554033.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Toy Story</td>\n",
              "      <td>False</td>\n",
              "      <td>7.7</td>\n",
              "      <td>5415.0</td>\n",
              "      <td>1</td>\n",
              "      <td>114709</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "      <td>65000000</td>\n",
              "      <td>Adventure|Fantasy|Family</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8844</td>\n",
              "      <td>tt0113497</td>\n",
              "      <td>en</td>\n",
              "      <td>Jumanji</td>\n",
              "      <td>When siblings Judy and Peter discover an encha...</td>\n",
              "      <td>17.015539</td>\n",
              "      <td>/vzmL6fP7aPKNKPRTFnZmiUfciyV.jpg</td>\n",
              "      <td>TriStar Pictures|Teitler Film|Interscope Commu...</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-12-15</td>\n",
              "      <td>262797249.0</td>\n",
              "      <td>104.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
              "      <td>Released</td>\n",
              "      <td>Roll the dice and unleash the excitement!</td>\n",
              "      <td>Jumanji</td>\n",
              "      <td>False</td>\n",
              "      <td>6.9</td>\n",
              "      <td>2413.0</td>\n",
              "      <td>2</td>\n",
              "      <td>113497</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>False</td>\n",
              "      <td>{'id': 119050, 'name': 'Grumpy Old Men Collect...</td>\n",
              "      <td>0</td>\n",
              "      <td>Romance|Comedy</td>\n",
              "      <td>NaN</td>\n",
              "      <td>15602</td>\n",
              "      <td>tt0113228</td>\n",
              "      <td>en</td>\n",
              "      <td>Grumpier Old Men</td>\n",
              "      <td>A family wedding reignites the ancient feud be...</td>\n",
              "      <td>11.7129</td>\n",
              "      <td>/6ksm1sjKMFLbO7UY2i6G1ju9SML.jpg</td>\n",
              "      <td>Warner Bros.|Lancaster Gate</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-12-22</td>\n",
              "      <td>0.0</td>\n",
              "      <td>101.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Still Yelling. Still Fighting. Still Ready for...</td>\n",
              "      <td>Grumpier Old Men</td>\n",
              "      <td>False</td>\n",
              "      <td>6.5</td>\n",
              "      <td>92.0</td>\n",
              "      <td>3</td>\n",
              "      <td>113228</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "      <td>16000000</td>\n",
              "      <td>Comedy|Drama|Romance</td>\n",
              "      <td>NaN</td>\n",
              "      <td>31357</td>\n",
              "      <td>tt0114885</td>\n",
              "      <td>en</td>\n",
              "      <td>Waiting to Exhale</td>\n",
              "      <td>Cheated on, mistreated and stepped on, the wom...</td>\n",
              "      <td>3.859495</td>\n",
              "      <td>/16XOMpEaLWkrcPqSQqhTmeJuqQl.jpg</td>\n",
              "      <td>Twentieth Century Fox Film Corporation</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-12-22</td>\n",
              "      <td>81452156.0</td>\n",
              "      <td>127.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Friends are the people who let you be yourself...</td>\n",
              "      <td>Waiting to Exhale</td>\n",
              "      <td>False</td>\n",
              "      <td>6.1</td>\n",
              "      <td>34.0</td>\n",
              "      <td>4</td>\n",
              "      <td>114885</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>False</td>\n",
              "      <td>{'id': 96871, 'name': 'Father of the Bride Col...</td>\n",
              "      <td>0</td>\n",
              "      <td>Comedy</td>\n",
              "      <td>NaN</td>\n",
              "      <td>11862</td>\n",
              "      <td>tt0113041</td>\n",
              "      <td>en</td>\n",
              "      <td>Father of the Bride Part II</td>\n",
              "      <td>Just when George Banks has recovered from his ...</td>\n",
              "      <td>8.387519</td>\n",
              "      <td>/e64sOI48hQXyru7naBFyssKFxVd.jpg</td>\n",
              "      <td>Sandollar Productions|Touchstone Pictures</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-02-10</td>\n",
              "      <td>76578911.0</td>\n",
              "      <td>106.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Just When His World Is Back To Normal... He's ...</td>\n",
              "      <td>Father of the Bride Part II</td>\n",
              "      <td>False</td>\n",
              "      <td>5.7</td>\n",
              "      <td>173.0</td>\n",
              "      <td>5</td>\n",
              "      <td>113041</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   adult                              belongs_to_collection  ... movieId  imdbId\n",
              "0  False  {'id': 10194, 'name': 'Toy Story Collection', ...  ...       1  114709\n",
              "1  False                                                NaN  ...       2  113497\n",
              "2  False  {'id': 119050, 'name': 'Grumpy Old Men Collect...  ...       3  113228\n",
              "3  False                                                NaN  ...       4  114885\n",
              "4  False  {'id': 96871, 'name': 'Father of the Bride Col...  ...       5  113041\n",
              "\n",
              "[5 rows x 26 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "b9xgyPYQRU03"
      },
      "source": [
        "**Removing unnecessary columns from the dataset :**  The **'belongs_to_collection'** column contains the movie series in which the movie belongs along with some other irrelevant informations. So let's drop this column. Let's drop the **'poster_path'** , **'video'** , **'imdb_id'** and **'homepage'** column as well because we won't require it in our analysis."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "5mxNss6KSIKl",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 652
        },
        "outputId": "768b020a-165d-43f1-dcde-d9a874104313"
      },
      "source": [
        "movies_metadata.drop('belongs_to_collection',inplace=True,axis=1)\n",
        "movies_metadata.drop('poster_path',inplace=True,axis=1)\n",
        "movies_metadata.drop('homepage',inplace=True,axis=1)\n",
        "movies_metadata.drop('video',inplace=True,axis=1)\n",
        "movies_metadata.drop('imdb_id',inplace=True,axis=1)\n",
        "movies_metadata.head(5)"
      ],
      "execution_count": 16,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>adult</th>\n",
              "      <th>budget</th>\n",
              "      <th>genres</th>\n",
              "      <th>tmdbId</th>\n",
              "      <th>original_language</th>\n",
              "      <th>original_title</th>\n",
              "      <th>overview</th>\n",
              "      <th>popularity</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>production_countries</th>\n",
              "      <th>release_date</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>spoken_languages</th>\n",
              "      <th>status</th>\n",
              "      <th>tagline</th>\n",
              "      <th>title</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>movieId</th>\n",
              "      <th>imdbId</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>False</td>\n",
              "      <td>30000000</td>\n",
              "      <td>Animation|Comedy|Family</td>\n",
              "      <td>862</td>\n",
              "      <td>en</td>\n",
              "      <td>Toy Story</td>\n",
              "      <td>Led by Woody, Andy's toys live happily in his ...</td>\n",
              "      <td>21.946943</td>\n",
              "      <td>Pixar Animation Studios</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-10-30</td>\n",
              "      <td>373554033.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Toy Story</td>\n",
              "      <td>7.7</td>\n",
              "      <td>5415.0</td>\n",
              "      <td>1</td>\n",
              "      <td>114709</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>False</td>\n",
              "      <td>65000000</td>\n",
              "      <td>Adventure|Fantasy|Family</td>\n",
              "      <td>8844</td>\n",
              "      <td>en</td>\n",
              "      <td>Jumanji</td>\n",
              "      <td>When siblings Judy and Peter discover an encha...</td>\n",
              "      <td>17.015539</td>\n",
              "      <td>TriStar Pictures|Teitler Film|Interscope Commu...</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-12-15</td>\n",
              "      <td>262797249.0</td>\n",
              "      <td>104.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
              "      <td>Released</td>\n",
              "      <td>Roll the dice and unleash the excitement!</td>\n",
              "      <td>Jumanji</td>\n",
              "      <td>6.9</td>\n",
              "      <td>2413.0</td>\n",
              "      <td>2</td>\n",
              "      <td>113497</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>False</td>\n",
              "      <td>0</td>\n",
              "      <td>Romance|Comedy</td>\n",
              "      <td>15602</td>\n",
              "      <td>en</td>\n",
              "      <td>Grumpier Old Men</td>\n",
              "      <td>A family wedding reignites the ancient feud be...</td>\n",
              "      <td>11.7129</td>\n",
              "      <td>Warner Bros.|Lancaster Gate</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-12-22</td>\n",
              "      <td>0.0</td>\n",
              "      <td>101.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Still Yelling. Still Fighting. Still Ready for...</td>\n",
              "      <td>Grumpier Old Men</td>\n",
              "      <td>6.5</td>\n",
              "      <td>92.0</td>\n",
              "      <td>3</td>\n",
              "      <td>113228</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>False</td>\n",
              "      <td>16000000</td>\n",
              "      <td>Comedy|Drama|Romance</td>\n",
              "      <td>31357</td>\n",
              "      <td>en</td>\n",
              "      <td>Waiting to Exhale</td>\n",
              "      <td>Cheated on, mistreated and stepped on, the wom...</td>\n",
              "      <td>3.859495</td>\n",
              "      <td>Twentieth Century Fox Film Corporation</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-12-22</td>\n",
              "      <td>81452156.0</td>\n",
              "      <td>127.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Friends are the people who let you be yourself...</td>\n",
              "      <td>Waiting to Exhale</td>\n",
              "      <td>6.1</td>\n",
              "      <td>34.0</td>\n",
              "      <td>4</td>\n",
              "      <td>114885</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>False</td>\n",
              "      <td>0</td>\n",
              "      <td>Comedy</td>\n",
              "      <td>11862</td>\n",
              "      <td>en</td>\n",
              "      <td>Father of the Bride Part II</td>\n",
              "      <td>Just when George Banks has recovered from his ...</td>\n",
              "      <td>8.387519</td>\n",
              "      <td>Sandollar Productions|Touchstone Pictures</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-02-10</td>\n",
              "      <td>76578911.0</td>\n",
              "      <td>106.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Just When His World Is Back To Normal... He's ...</td>\n",
              "      <td>Father of the Bride Part II</td>\n",
              "      <td>5.7</td>\n",
              "      <td>173.0</td>\n",
              "      <td>5</td>\n",
              "      <td>113041</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   adult    budget                    genres  ...  vote_count movieId  imdbId\n",
              "0  False  30000000   Animation|Comedy|Family  ...      5415.0       1  114709\n",
              "1  False  65000000  Adventure|Fantasy|Family  ...      2413.0       2  113497\n",
              "2  False         0            Romance|Comedy  ...        92.0       3  113228\n",
              "3  False  16000000      Comedy|Drama|Romance  ...        34.0       4  114885\n",
              "4  False         0                    Comedy  ...       173.0       5  113041\n",
              "\n",
              "[5 rows x 21 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "JNX4C3mcbBwJ"
      },
      "source": [
        "**Exploring remaining Columns :** "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "CDbu0SXgggZL",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 343
        },
        "outputId": "e0d785cc-3439-4b9f-fd18-c3122ba9284d"
      },
      "source": [
        "movies_metadata[movies_metadata['original_title'] != movies_metadata['title']][['title', 'original_title']].head(10)"
      ],
      "execution_count": 17,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>title</th>\n",
              "      <th>original_title</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>The City of Lost Children</td>\n",
              "      <td>La Cité des Enfants Perdus</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>Shanghai Triad</td>\n",
              "      <td>摇啊摇，摇到外婆桥</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>54</th>\n",
              "      <td>The Postman</td>\n",
              "      <td>Il postino</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>55</th>\n",
              "      <td>The Confessional</td>\n",
              "      <td>Le confessionnal</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>63</th>\n",
              "      <td>French Twist</td>\n",
              "      <td>Gazon maudit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>68</th>\n",
              "      <td>Les Miserables</td>\n",
              "      <td>Les misérables</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>74</th>\n",
              "      <td>The White Balloon</td>\n",
              "      <td>بادکنک سفید</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>76</th>\n",
              "      <td>Antonia's Line</td>\n",
              "      <td>Antonia</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>102</th>\n",
              "      <td>Rumble in the Bronx</td>\n",
              "      <td>紅番區</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>111</th>\n",
              "      <td>Chungking Express</td>\n",
              "      <td>重慶森林</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                         title              original_title\n",
              "28   The City of Lost Children  La Cité des Enfants Perdus\n",
              "29              Shanghai Triad                   摇啊摇，摇到外婆桥\n",
              "54                 The Postman                  Il postino\n",
              "55            The Confessional            Le confessionnal\n",
              "63                French Twist                Gazon maudit\n",
              "68              Les Miserables              Les misérables\n",
              "74           The White Balloon                 بادکنک سفید\n",
              "76              Antonia's Line                     Antonia\n",
              "102        Rumble in the Bronx                         紅番區\n",
              "111          Chungking Express                        重慶森林"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "w9sP-NS2g9Le"
      },
      "source": [
        "The **'original_title'** refers to the title of the movie in the native language in which the movie was shot.So let's drop this column too."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "j_SpZmh9g8Q4",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 652
        },
        "outputId": "ce9b6cb7-abd8-44b5-a78a-5fba11161b48"
      },
      "source": [
        "movies_metadata.drop('original_title',inplace=True,axis=1)\n",
        "movies_metadata.head(5)"
      ],
      "execution_count": 18,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>adult</th>\n",
              "      <th>budget</th>\n",
              "      <th>genres</th>\n",
              "      <th>tmdbId</th>\n",
              "      <th>original_language</th>\n",
              "      <th>overview</th>\n",
              "      <th>popularity</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>production_countries</th>\n",
              "      <th>release_date</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>spoken_languages</th>\n",
              "      <th>status</th>\n",
              "      <th>tagline</th>\n",
              "      <th>title</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>movieId</th>\n",
              "      <th>imdbId</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>False</td>\n",
              "      <td>30000000</td>\n",
              "      <td>Animation|Comedy|Family</td>\n",
              "      <td>862</td>\n",
              "      <td>en</td>\n",
              "      <td>Led by Woody, Andy's toys live happily in his ...</td>\n",
              "      <td>21.946943</td>\n",
              "      <td>Pixar Animation Studios</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-10-30</td>\n",
              "      <td>373554033.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Toy Story</td>\n",
              "      <td>7.7</td>\n",
              "      <td>5415.0</td>\n",
              "      <td>1</td>\n",
              "      <td>114709</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>False</td>\n",
              "      <td>65000000</td>\n",
              "      <td>Adventure|Fantasy|Family</td>\n",
              "      <td>8844</td>\n",
              "      <td>en</td>\n",
              "      <td>When siblings Judy and Peter discover an encha...</td>\n",
              "      <td>17.015539</td>\n",
              "      <td>TriStar Pictures|Teitler Film|Interscope Commu...</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-12-15</td>\n",
              "      <td>262797249.0</td>\n",
              "      <td>104.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
              "      <td>Released</td>\n",
              "      <td>Roll the dice and unleash the excitement!</td>\n",
              "      <td>Jumanji</td>\n",
              "      <td>6.9</td>\n",
              "      <td>2413.0</td>\n",
              "      <td>2</td>\n",
              "      <td>113497</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>False</td>\n",
              "      <td>0</td>\n",
              "      <td>Romance|Comedy</td>\n",
              "      <td>15602</td>\n",
              "      <td>en</td>\n",
              "      <td>A family wedding reignites the ancient feud be...</td>\n",
              "      <td>11.7129</td>\n",
              "      <td>Warner Bros.|Lancaster Gate</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-12-22</td>\n",
              "      <td>0.0</td>\n",
              "      <td>101.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Still Yelling. Still Fighting. Still Ready for...</td>\n",
              "      <td>Grumpier Old Men</td>\n",
              "      <td>6.5</td>\n",
              "      <td>92.0</td>\n",
              "      <td>3</td>\n",
              "      <td>113228</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>False</td>\n",
              "      <td>16000000</td>\n",
              "      <td>Comedy|Drama|Romance</td>\n",
              "      <td>31357</td>\n",
              "      <td>en</td>\n",
              "      <td>Cheated on, mistreated and stepped on, the wom...</td>\n",
              "      <td>3.859495</td>\n",
              "      <td>Twentieth Century Fox Film Corporation</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-12-22</td>\n",
              "      <td>81452156.0</td>\n",
              "      <td>127.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Friends are the people who let you be yourself...</td>\n",
              "      <td>Waiting to Exhale</td>\n",
              "      <td>6.1</td>\n",
              "      <td>34.0</td>\n",
              "      <td>4</td>\n",
              "      <td>114885</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>False</td>\n",
              "      <td>0</td>\n",
              "      <td>Comedy</td>\n",
              "      <td>11862</td>\n",
              "      <td>en</td>\n",
              "      <td>Just when George Banks has recovered from his ...</td>\n",
              "      <td>8.387519</td>\n",
              "      <td>Sandollar Productions|Touchstone Pictures</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-02-10</td>\n",
              "      <td>76578911.0</td>\n",
              "      <td>106.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Just When His World Is Back To Normal... He's ...</td>\n",
              "      <td>Father of the Bride Part II</td>\n",
              "      <td>5.7</td>\n",
              "      <td>173.0</td>\n",
              "      <td>5</td>\n",
              "      <td>113041</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   adult    budget                    genres  ...  vote_count movieId  imdbId\n",
              "0  False  30000000   Animation|Comedy|Family  ...      5415.0       1  114709\n",
              "1  False  65000000  Adventure|Fantasy|Family  ...      2413.0       2  113497\n",
              "2  False         0            Romance|Comedy  ...        92.0       3  113228\n",
              "3  False  16000000      Comedy|Drama|Romance  ...        34.0       4  114885\n",
              "4  False         0                    Comedy  ...       173.0       5  113041\n",
              "\n",
              "[5 rows x 20 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 18
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "CYapdjXAko_V",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "fc03789a-bd24-4f87-9c51-288676e556de"
      },
      "source": [
        "movies_metadata['adult'].unique()"
      ],
      "execution_count": 19,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array(['False'], dtype=object)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 19
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "qEu93jLcnQST"
      },
      "source": [
        "There are negligible number of adult movies in this dataset. The adult feature therefore is not of much use to us and can be safely dropped."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ct5xsgKvnpdJ",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 652
        },
        "outputId": "59cc1cde-5fae-4ecb-9d9e-65f602f8d757"
      },
      "source": [
        "movies_metadata.drop('adult',inplace=True,axis=1)\n",
        "movies_metadata.head()"
      ],
      "execution_count": 20,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>budget</th>\n",
              "      <th>genres</th>\n",
              "      <th>tmdbId</th>\n",
              "      <th>original_language</th>\n",
              "      <th>overview</th>\n",
              "      <th>popularity</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>production_countries</th>\n",
              "      <th>release_date</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>spoken_languages</th>\n",
              "      <th>status</th>\n",
              "      <th>tagline</th>\n",
              "      <th>title</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>movieId</th>\n",
              "      <th>imdbId</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>30000000</td>\n",
              "      <td>Animation|Comedy|Family</td>\n",
              "      <td>862</td>\n",
              "      <td>en</td>\n",
              "      <td>Led by Woody, Andy's toys live happily in his ...</td>\n",
              "      <td>21.946943</td>\n",
              "      <td>Pixar Animation Studios</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-10-30</td>\n",
              "      <td>373554033.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Toy Story</td>\n",
              "      <td>7.7</td>\n",
              "      <td>5415.0</td>\n",
              "      <td>1</td>\n",
              "      <td>114709</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>65000000</td>\n",
              "      <td>Adventure|Fantasy|Family</td>\n",
              "      <td>8844</td>\n",
              "      <td>en</td>\n",
              "      <td>When siblings Judy and Peter discover an encha...</td>\n",
              "      <td>17.015539</td>\n",
              "      <td>TriStar Pictures|Teitler Film|Interscope Commu...</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-12-15</td>\n",
              "      <td>262797249.0</td>\n",
              "      <td>104.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
              "      <td>Released</td>\n",
              "      <td>Roll the dice and unleash the excitement!</td>\n",
              "      <td>Jumanji</td>\n",
              "      <td>6.9</td>\n",
              "      <td>2413.0</td>\n",
              "      <td>2</td>\n",
              "      <td>113497</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>0</td>\n",
              "      <td>Romance|Comedy</td>\n",
              "      <td>15602</td>\n",
              "      <td>en</td>\n",
              "      <td>A family wedding reignites the ancient feud be...</td>\n",
              "      <td>11.7129</td>\n",
              "      <td>Warner Bros.|Lancaster Gate</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-12-22</td>\n",
              "      <td>0.0</td>\n",
              "      <td>101.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Still Yelling. Still Fighting. Still Ready for...</td>\n",
              "      <td>Grumpier Old Men</td>\n",
              "      <td>6.5</td>\n",
              "      <td>92.0</td>\n",
              "      <td>3</td>\n",
              "      <td>113228</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>16000000</td>\n",
              "      <td>Comedy|Drama|Romance</td>\n",
              "      <td>31357</td>\n",
              "      <td>en</td>\n",
              "      <td>Cheated on, mistreated and stepped on, the wom...</td>\n",
              "      <td>3.859495</td>\n",
              "      <td>Twentieth Century Fox Film Corporation</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-12-22</td>\n",
              "      <td>81452156.0</td>\n",
              "      <td>127.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Friends are the people who let you be yourself...</td>\n",
              "      <td>Waiting to Exhale</td>\n",
              "      <td>6.1</td>\n",
              "      <td>34.0</td>\n",
              "      <td>4</td>\n",
              "      <td>114885</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>0</td>\n",
              "      <td>Comedy</td>\n",
              "      <td>11862</td>\n",
              "      <td>en</td>\n",
              "      <td>Just when George Banks has recovered from his ...</td>\n",
              "      <td>8.387519</td>\n",
              "      <td>Sandollar Productions|Touchstone Pictures</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-02-10</td>\n",
              "      <td>76578911.0</td>\n",
              "      <td>106.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Just When His World Is Back To Normal... He's ...</td>\n",
              "      <td>Father of the Bride Part II</td>\n",
              "      <td>5.7</td>\n",
              "      <td>173.0</td>\n",
              "      <td>5</td>\n",
              "      <td>113041</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "     budget                    genres  tmdbId  ... vote_count movieId  imdbId\n",
              "0  30000000   Animation|Comedy|Family     862  ...     5415.0       1  114709\n",
              "1  65000000  Adventure|Fantasy|Family    8844  ...     2413.0       2  113497\n",
              "2         0            Romance|Comedy   15602  ...       92.0       3  113228\n",
              "3  16000000      Comedy|Drama|Romance   31357  ...       34.0       4  114885\n",
              "4         0                    Comedy   11862  ...      173.0       5  113041\n",
              "\n",
              "[5 rows x 19 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 20
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "D41Ytyk66aOG"
      },
      "source": [
        "Let's explore the dataset a bit more."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "EfmLa7Tjoou1",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "4668ef19-a26f-4edc-abd1-96b3314af639"
      },
      "source": [
        "movies_metadata['status'].value_counts()\n"
      ],
      "execution_count": 21,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Released           9077\n",
              "Rumored              11\n",
              "Post Production       7\n",
              "In Production         1\n",
              "Name: status, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 21
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "SZ9JdEtQ1Cka",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "e2663bd0-9587-4237-c740-dfe2a9a5f186"
      },
      "source": [
        "movies_metadata.info()"
      ],
      "execution_count": 22,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "Int64Index: 9098 entries, 0 to 9098\n",
            "Data columns (total 19 columns):\n",
            " #   Column                Non-Null Count  Dtype  \n",
            "---  ------                --------------  -----  \n",
            " 0   budget                9098 non-null   object \n",
            " 1   genres                9098 non-null   object \n",
            " 2   tmdbId                9098 non-null   int64  \n",
            " 3   original_language     9098 non-null   object \n",
            " 4   overview              9086 non-null   object \n",
            " 5   popularity            9098 non-null   object \n",
            " 6   production_companies  9098 non-null   object \n",
            " 7   production_countries  9098 non-null   object \n",
            " 8   release_date          9098 non-null   object \n",
            " 9   revenue               9098 non-null   float64\n",
            " 10  runtime               9098 non-null   float64\n",
            " 11  spoken_languages      9098 non-null   object \n",
            " 12  status                9096 non-null   object \n",
            " 13  tagline               7032 non-null   object \n",
            " 14  title                 9098 non-null   object \n",
            " 15  vote_average          9098 non-null   float64\n",
            " 16  vote_count            9098 non-null   float64\n",
            " 17  movieId               9098 non-null   int64  \n",
            " 18  imdbId                9098 non-null   int64  \n",
            "dtypes: float64(4), int64(3), object(12)\n",
            "memory usage: 1.4+ MB\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Cx-vMb_c7Fdl"
      },
      "source": [
        "Since both the columns **'overview'** and **'tagline'** contains description of the movie...let's combine these two column and form a single column **'content'** ."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "SwdrdQCI7wvK",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 652
        },
        "outputId": "e051a382-d103-4541-caf9-f519d4167e59"
      },
      "source": [
        "movies_metadata['overview'] = movies_metadata['overview'].fillna('')\n",
        "movies_metadata['tagline'] = movies_metadata['tagline'].fillna('')\n",
        "movies_metadata['content'] = movies_metadata['overview']+movies_metadata['tagline']\n",
        "movies_metadata.drop('overview',inplace=True,axis=1)\n",
        "movies_metadata.drop('tagline',inplace=True,axis=1)\n",
        "movies_metadata.head(5)"
      ],
      "execution_count": 23,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>budget</th>\n",
              "      <th>genres</th>\n",
              "      <th>tmdbId</th>\n",
              "      <th>original_language</th>\n",
              "      <th>popularity</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>production_countries</th>\n",
              "      <th>release_date</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>spoken_languages</th>\n",
              "      <th>status</th>\n",
              "      <th>title</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>movieId</th>\n",
              "      <th>imdbId</th>\n",
              "      <th>content</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>30000000</td>\n",
              "      <td>Animation|Comedy|Family</td>\n",
              "      <td>862</td>\n",
              "      <td>en</td>\n",
              "      <td>21.946943</td>\n",
              "      <td>Pixar Animation Studios</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-10-30</td>\n",
              "      <td>373554033.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Toy Story</td>\n",
              "      <td>7.7</td>\n",
              "      <td>5415.0</td>\n",
              "      <td>1</td>\n",
              "      <td>114709</td>\n",
              "      <td>Led by Woody, Andy's toys live happily in his ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>65000000</td>\n",
              "      <td>Adventure|Fantasy|Family</td>\n",
              "      <td>8844</td>\n",
              "      <td>en</td>\n",
              "      <td>17.015539</td>\n",
              "      <td>TriStar Pictures|Teitler Film|Interscope Commu...</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-12-15</td>\n",
              "      <td>262797249.0</td>\n",
              "      <td>104.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
              "      <td>Released</td>\n",
              "      <td>Jumanji</td>\n",
              "      <td>6.9</td>\n",
              "      <td>2413.0</td>\n",
              "      <td>2</td>\n",
              "      <td>113497</td>\n",
              "      <td>When siblings Judy and Peter discover an encha...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>0</td>\n",
              "      <td>Romance|Comedy</td>\n",
              "      <td>15602</td>\n",
              "      <td>en</td>\n",
              "      <td>11.7129</td>\n",
              "      <td>Warner Bros.|Lancaster Gate</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-12-22</td>\n",
              "      <td>0.0</td>\n",
              "      <td>101.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Grumpier Old Men</td>\n",
              "      <td>6.5</td>\n",
              "      <td>92.0</td>\n",
              "      <td>3</td>\n",
              "      <td>113228</td>\n",
              "      <td>A family wedding reignites the ancient feud be...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>16000000</td>\n",
              "      <td>Comedy|Drama|Romance</td>\n",
              "      <td>31357</td>\n",
              "      <td>en</td>\n",
              "      <td>3.859495</td>\n",
              "      <td>Twentieth Century Fox Film Corporation</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-12-22</td>\n",
              "      <td>81452156.0</td>\n",
              "      <td>127.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Waiting to Exhale</td>\n",
              "      <td>6.1</td>\n",
              "      <td>34.0</td>\n",
              "      <td>4</td>\n",
              "      <td>114885</td>\n",
              "      <td>Cheated on, mistreated and stepped on, the wom...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>0</td>\n",
              "      <td>Comedy</td>\n",
              "      <td>11862</td>\n",
              "      <td>en</td>\n",
              "      <td>8.387519</td>\n",
              "      <td>Sandollar Productions|Touchstone Pictures</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1995-02-10</td>\n",
              "      <td>76578911.0</td>\n",
              "      <td>106.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Father of the Bride Part II</td>\n",
              "      <td>5.7</td>\n",
              "      <td>173.0</td>\n",
              "      <td>5</td>\n",
              "      <td>113041</td>\n",
              "      <td>Just when George Banks has recovered from his ...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "     budget  ...                                            content\n",
              "0  30000000  ...  Led by Woody, Andy's toys live happily in his ...\n",
              "1  65000000  ...  When siblings Judy and Peter discover an encha...\n",
              "2         0  ...  A family wedding reignites the ancient feud be...\n",
              "3  16000000  ...  Cheated on, mistreated and stepped on, the wom...\n",
              "4         0  ...  Just when George Banks has recovered from his ...\n",
              "\n",
              "[5 rows x 18 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 23
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "gKk-Vle_Boxl"
      },
      "source": [
        "Now let's count the number of movies with the **'content'** column empty.We may require this data while creating **Content-based Recommendation System**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "CoaqqixvBRQs",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "beab3ef9-fda1-449a-c4e9-5760438b9f85"
      },
      "source": [
        "movies_metadata[movies_metadata['content']==''].movieId.count()"
      ],
      "execution_count": 24,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "12"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 24
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "tc8jzTTgXOHo"
      },
      "source": [
        "We are provided with the **release_date** of the movies but we really don't require the date as such but the **year** and **dayofweek** of release might be useful. So we extract them and store them in two new columns **'release_day'** and **'release_year'**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "PRCpid2mN_UW",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 652
        },
        "outputId": "d7fda188-2050-4bca-f594-43a59454d88c"
      },
      "source": [
        "movies_metadata['release_year'] = pd.to_datetime(movies_metadata['release_date'], errors='coerce').apply(lambda x: str(x).split('-')[0] if x != np.nan else np.nan)\n",
        "movies_metadata['release_day'] = pd.to_datetime(movies_metadata['release_date'], errors='coerce').dt.day_name()\n",
        "movies_metadata.drop('release_date',inplace=True,axis=1)\n",
        "movies_metadata.head()"
      ],
      "execution_count": 25,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>budget</th>\n",
              "      <th>genres</th>\n",
              "      <th>tmdbId</th>\n",
              "      <th>original_language</th>\n",
              "      <th>popularity</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>production_countries</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>spoken_languages</th>\n",
              "      <th>status</th>\n",
              "      <th>title</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>movieId</th>\n",
              "      <th>imdbId</th>\n",
              "      <th>content</th>\n",
              "      <th>release_year</th>\n",
              "      <th>release_day</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>30000000</td>\n",
              "      <td>Animation|Comedy|Family</td>\n",
              "      <td>862</td>\n",
              "      <td>en</td>\n",
              "      <td>21.946943</td>\n",
              "      <td>Pixar Animation Studios</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>373554033.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Toy Story</td>\n",
              "      <td>7.7</td>\n",
              "      <td>5415.0</td>\n",
              "      <td>1</td>\n",
              "      <td>114709</td>\n",
              "      <td>Led by Woody, Andy's toys live happily in his ...</td>\n",
              "      <td>1995</td>\n",
              "      <td>Monday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>65000000</td>\n",
              "      <td>Adventure|Fantasy|Family</td>\n",
              "      <td>8844</td>\n",
              "      <td>en</td>\n",
              "      <td>17.015539</td>\n",
              "      <td>TriStar Pictures|Teitler Film|Interscope Commu...</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>262797249.0</td>\n",
              "      <td>104.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
              "      <td>Released</td>\n",
              "      <td>Jumanji</td>\n",
              "      <td>6.9</td>\n",
              "      <td>2413.0</td>\n",
              "      <td>2</td>\n",
              "      <td>113497</td>\n",
              "      <td>When siblings Judy and Peter discover an encha...</td>\n",
              "      <td>1995</td>\n",
              "      <td>Friday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>0</td>\n",
              "      <td>Romance|Comedy</td>\n",
              "      <td>15602</td>\n",
              "      <td>en</td>\n",
              "      <td>11.7129</td>\n",
              "      <td>Warner Bros.|Lancaster Gate</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>0.0</td>\n",
              "      <td>101.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Grumpier Old Men</td>\n",
              "      <td>6.5</td>\n",
              "      <td>92.0</td>\n",
              "      <td>3</td>\n",
              "      <td>113228</td>\n",
              "      <td>A family wedding reignites the ancient feud be...</td>\n",
              "      <td>1995</td>\n",
              "      <td>Friday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>16000000</td>\n",
              "      <td>Comedy|Drama|Romance</td>\n",
              "      <td>31357</td>\n",
              "      <td>en</td>\n",
              "      <td>3.859495</td>\n",
              "      <td>Twentieth Century Fox Film Corporation</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>81452156.0</td>\n",
              "      <td>127.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Waiting to Exhale</td>\n",
              "      <td>6.1</td>\n",
              "      <td>34.0</td>\n",
              "      <td>4</td>\n",
              "      <td>114885</td>\n",
              "      <td>Cheated on, mistreated and stepped on, the wom...</td>\n",
              "      <td>1995</td>\n",
              "      <td>Friday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>0</td>\n",
              "      <td>Comedy</td>\n",
              "      <td>11862</td>\n",
              "      <td>en</td>\n",
              "      <td>8.387519</td>\n",
              "      <td>Sandollar Productions|Touchstone Pictures</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>76578911.0</td>\n",
              "      <td>106.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Father of the Bride Part II</td>\n",
              "      <td>5.7</td>\n",
              "      <td>173.0</td>\n",
              "      <td>5</td>\n",
              "      <td>113041</td>\n",
              "      <td>Just when George Banks has recovered from his ...</td>\n",
              "      <td>1995</td>\n",
              "      <td>Friday</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "     budget                    genres  ...  release_year release_day\n",
              "0  30000000   Animation|Comedy|Family  ...          1995      Monday\n",
              "1  65000000  Adventure|Fantasy|Family  ...          1995      Friday\n",
              "2         0            Romance|Comedy  ...          1995      Friday\n",
              "3  16000000      Comedy|Drama|Romance  ...          1995      Friday\n",
              "4         0                    Comedy  ...          1995      Friday\n",
              "\n",
              "[5 rows x 19 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 25
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "LYkfiaKoVEoC"
      },
      "source": [
        "Let's now focus on the three columns of the dataset : **'popularity','vote_average','vote_count'** "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "efeFxx5TNL9d",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "e4a85a87-9c6e-4c2e-9024-fa2fd5d6b313"
      },
      "source": [
        "movies_metadata['popularity'].describe()"
      ],
      "execution_count": 26,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "count         9098\n",
              "unique        9086\n",
              "top       2.587911\n",
              "freq             2\n",
              "Name: popularity, dtype: object"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 26
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "4nuOkWzFW0nE"
      },
      "source": [
        "On trying to convert the dtype of **'popularity'** column from object to float.it was found that there is a faulty row.So the row is filtered and then the conversion was made successfully"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "5NNXRwosPZj8",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 652
        },
        "outputId": "abd932d8-743b-4f6f-9c85-f8a8530cb03a"
      },
      "source": [
        "#movies_metadata=movies_metadata[movies_metadata['popularity']!='Beware Of Frost Bites']\n",
        "movies_metadata['popularity']=movies_metadata['popularity'].astype(float)\n",
        "movies_metadata.head()"
      ],
      "execution_count": 27,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>budget</th>\n",
              "      <th>genres</th>\n",
              "      <th>tmdbId</th>\n",
              "      <th>original_language</th>\n",
              "      <th>popularity</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>production_countries</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>spoken_languages</th>\n",
              "      <th>status</th>\n",
              "      <th>title</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>movieId</th>\n",
              "      <th>imdbId</th>\n",
              "      <th>content</th>\n",
              "      <th>release_year</th>\n",
              "      <th>release_day</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>30000000</td>\n",
              "      <td>Animation|Comedy|Family</td>\n",
              "      <td>862</td>\n",
              "      <td>en</td>\n",
              "      <td>21.946943</td>\n",
              "      <td>Pixar Animation Studios</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>373554033.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Toy Story</td>\n",
              "      <td>7.7</td>\n",
              "      <td>5415.0</td>\n",
              "      <td>1</td>\n",
              "      <td>114709</td>\n",
              "      <td>Led by Woody, Andy's toys live happily in his ...</td>\n",
              "      <td>1995</td>\n",
              "      <td>Monday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>65000000</td>\n",
              "      <td>Adventure|Fantasy|Family</td>\n",
              "      <td>8844</td>\n",
              "      <td>en</td>\n",
              "      <td>17.015539</td>\n",
              "      <td>TriStar Pictures|Teitler Film|Interscope Commu...</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>262797249.0</td>\n",
              "      <td>104.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
              "      <td>Released</td>\n",
              "      <td>Jumanji</td>\n",
              "      <td>6.9</td>\n",
              "      <td>2413.0</td>\n",
              "      <td>2</td>\n",
              "      <td>113497</td>\n",
              "      <td>When siblings Judy and Peter discover an encha...</td>\n",
              "      <td>1995</td>\n",
              "      <td>Friday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>0</td>\n",
              "      <td>Romance|Comedy</td>\n",
              "      <td>15602</td>\n",
              "      <td>en</td>\n",
              "      <td>11.712900</td>\n",
              "      <td>Warner Bros.|Lancaster Gate</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>0.0</td>\n",
              "      <td>101.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Grumpier Old Men</td>\n",
              "      <td>6.5</td>\n",
              "      <td>92.0</td>\n",
              "      <td>3</td>\n",
              "      <td>113228</td>\n",
              "      <td>A family wedding reignites the ancient feud be...</td>\n",
              "      <td>1995</td>\n",
              "      <td>Friday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>16000000</td>\n",
              "      <td>Comedy|Drama|Romance</td>\n",
              "      <td>31357</td>\n",
              "      <td>en</td>\n",
              "      <td>3.859495</td>\n",
              "      <td>Twentieth Century Fox Film Corporation</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>81452156.0</td>\n",
              "      <td>127.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Waiting to Exhale</td>\n",
              "      <td>6.1</td>\n",
              "      <td>34.0</td>\n",
              "      <td>4</td>\n",
              "      <td>114885</td>\n",
              "      <td>Cheated on, mistreated and stepped on, the wom...</td>\n",
              "      <td>1995</td>\n",
              "      <td>Friday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>0</td>\n",
              "      <td>Comedy</td>\n",
              "      <td>11862</td>\n",
              "      <td>en</td>\n",
              "      <td>8.387519</td>\n",
              "      <td>Sandollar Productions|Touchstone Pictures</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>76578911.0</td>\n",
              "      <td>106.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Father of the Bride Part II</td>\n",
              "      <td>5.7</td>\n",
              "      <td>173.0</td>\n",
              "      <td>5</td>\n",
              "      <td>113041</td>\n",
              "      <td>Just when George Banks has recovered from his ...</td>\n",
              "      <td>1995</td>\n",
              "      <td>Friday</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "     budget                    genres  ...  release_year release_day\n",
              "0  30000000   Animation|Comedy|Family  ...          1995      Monday\n",
              "1  65000000  Adventure|Fantasy|Family  ...          1995      Friday\n",
              "2         0            Romance|Comedy  ...          1995      Friday\n",
              "3  16000000      Comedy|Drama|Romance  ...          1995      Friday\n",
              "4         0                    Comedy  ...          1995      Friday\n",
              "\n",
              "[5 rows x 19 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 27
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "zBsSdoEFcqqr"
      },
      "source": [
        "Now we replace the Nan values of **'popularity' , 'vote_average' and 'vote_count'** with the median of the available values and then sort the entire dataset in descending order of the three columns."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "06R_b9mSHTW5"
      },
      "source": [
        "popularity_list = movies_metadata[movies_metadata['popularity']!=np.nan]['popularity']\n",
        "movies_metadata['popularity']=movies_metadata['popularity'].replace(np.nan,popularity_list.median())\n",
        "voteavg_list = movies_metadata[movies_metadata['vote_average']!=np.nan]['vote_average']\n",
        "movies_metadata['vote_average']=movies_metadata['vote_average'].replace(np.nan,voteavg_list.median())\n",
        "votecnt_list = movies_metadata[movies_metadata['vote_count']!=np.nan]['vote_count']\n",
        "movies_metadata['vote_count']=movies_metadata['vote_count'].replace(np.nan,votecnt_list.median())\n",
        "movies_metadata.sort_values(by=['popularity','vote_average','vote_count'],inplace=True,axis=0,ascending=False)"
      ],
      "execution_count": 28,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "bqD79g17Ufh8",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "e930ab59-f38d-4a30-cc84-9b33cd58c772"
      },
      "source": [
        "movies_metadata.head(20)"
      ],
      "execution_count": 29,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>budget</th>\n",
              "      <th>genres</th>\n",
              "      <th>tmdbId</th>\n",
              "      <th>original_language</th>\n",
              "      <th>popularity</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>production_countries</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>spoken_languages</th>\n",
              "      <th>status</th>\n",
              "      <th>title</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>movieId</th>\n",
              "      <th>imdbId</th>\n",
              "      <th>content</th>\n",
              "      <th>release_year</th>\n",
              "      <th>release_day</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>8906</th>\n",
              "      <td>74000000</td>\n",
              "      <td>Family|Animation|Adventure|Comedy</td>\n",
              "      <td>211672</td>\n",
              "      <td>en</td>\n",
              "      <td>547.488298</td>\n",
              "      <td>Universal Pictures|Illumination Entertainment</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1.156731e+09</td>\n",
              "      <td>91.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Minions</td>\n",
              "      <td>6.4</td>\n",
              "      <td>4729.0</td>\n",
              "      <td>135887</td>\n",
              "      <td>2293640</td>\n",
              "      <td>Minions Stuart, Kevin and Bob are recruited by...</td>\n",
              "      <td>2015</td>\n",
              "      <td>Wednesday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8681</th>\n",
              "      <td>165000000</td>\n",
              "      <td>Adventure|Family|Animation|Action|Comedy</td>\n",
              "      <td>177572</td>\n",
              "      <td>en</td>\n",
              "      <td>213.849907</td>\n",
              "      <td>Walt Disney Pictures|Walt Disney Animation Stu...</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>6.521054e+08</td>\n",
              "      <td>102.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Big Hero 6</td>\n",
              "      <td>7.8</td>\n",
              "      <td>6289.0</td>\n",
              "      <td>115617</td>\n",
              "      <td>2245084</td>\n",
              "      <td>The special bond that develops between plus-si...</td>\n",
              "      <td>2014</td>\n",
              "      <td>Friday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8769</th>\n",
              "      <td>58000000</td>\n",
              "      <td>Action|Adventure|Comedy</td>\n",
              "      <td>293660</td>\n",
              "      <td>en</td>\n",
              "      <td>187.860492</td>\n",
              "      <td>Twentieth Century Fox Film Corporation|Marvel ...</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>7.831130e+08</td>\n",
              "      <td>108.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Deadpool</td>\n",
              "      <td>7.4</td>\n",
              "      <td>11444.0</td>\n",
              "      <td>122904</td>\n",
              "      <td>1431045</td>\n",
              "      <td>Deadpool tells the origin story of former Spec...</td>\n",
              "      <td>2016</td>\n",
              "      <td>Tuesday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7404</th>\n",
              "      <td>237000000</td>\n",
              "      <td>Action|Adventure|Fantasy|Science Fiction</td>\n",
              "      <td>19995</td>\n",
              "      <td>en</td>\n",
              "      <td>185.070892</td>\n",
              "      <td>Ingenious Film Partners|Twentieth Century Fox ...</td>\n",
              "      <td>United States of America|United Kingdom</td>\n",
              "      <td>2.787965e+09</td>\n",
              "      <td>162.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
              "      <td>Released</td>\n",
              "      <td>Avatar</td>\n",
              "      <td>7.2</td>\n",
              "      <td>12114.0</td>\n",
              "      <td>72998</td>\n",
              "      <td>499549</td>\n",
              "      <td>In the 22nd century, a paraplegic Marine is di...</td>\n",
              "      <td>2009</td>\n",
              "      <td>Thursday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8671</th>\n",
              "      <td>20000000</td>\n",
              "      <td>Action|Thriller</td>\n",
              "      <td>245891</td>\n",
              "      <td>en</td>\n",
              "      <td>183.870374</td>\n",
              "      <td>Summit Entertainment|Warner Bros.|87Eleven|Def...</td>\n",
              "      <td>Canada|China|United States of America</td>\n",
              "      <td>8.876166e+07</td>\n",
              "      <td>101.0</td>\n",
              "      <td>[{'iso_639_1': 'hu', 'name': 'Magyar'}, {'iso_...</td>\n",
              "      <td>Released</td>\n",
              "      <td>John Wick</td>\n",
              "      <td>7.0</td>\n",
              "      <td>5499.0</td>\n",
              "      <td>115149</td>\n",
              "      <td>2911666</td>\n",
              "      <td>Ex-lunatic John Wick comes off his meds to tra...</td>\n",
              "      <td>2014</td>\n",
              "      <td>Wednesday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8602</th>\n",
              "      <td>61000000</td>\n",
              "      <td>Mystery|Thriller|Drama</td>\n",
              "      <td>210577</td>\n",
              "      <td>en</td>\n",
              "      <td>154.801009</td>\n",
              "      <td>Twentieth Century Fox Film Corporation|Regency...</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>3.693304e+08</td>\n",
              "      <td>145.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Gone Girl</td>\n",
              "      <td>7.9</td>\n",
              "      <td>6023.0</td>\n",
              "      <td>112556</td>\n",
              "      <td>2267998</td>\n",
              "      <td>With his wife's disappearance having become th...</td>\n",
              "      <td>2014</td>\n",
              "      <td>Wednesday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8700</th>\n",
              "      <td>125000000</td>\n",
              "      <td>Science Fiction|Adventure|Thriller</td>\n",
              "      <td>131631</td>\n",
              "      <td>en</td>\n",
              "      <td>147.098006</td>\n",
              "      <td>Lionsgate|Color Force</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>7.521002e+08</td>\n",
              "      <td>123.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>The Hunger Games: Mockingjay - Part 1</td>\n",
              "      <td>6.6</td>\n",
              "      <td>5767.0</td>\n",
              "      <td>116823</td>\n",
              "      <td>1951265</td>\n",
              "      <td>Katniss Everdeen reluctantly becomes the symbo...</td>\n",
              "      <td>2014</td>\n",
              "      <td>Tuesday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8770</th>\n",
              "      <td>250000000</td>\n",
              "      <td>Adventure|Action|Science Fiction</td>\n",
              "      <td>271110</td>\n",
              "      <td>en</td>\n",
              "      <td>145.882135</td>\n",
              "      <td>Studio Babelsberg|Marvel Studios|Walt Disney S...</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1.153304e+09</td>\n",
              "      <td>147.0</td>\n",
              "      <td>[{'iso_639_1': 'ro', 'name': 'Română'}, {'iso_...</td>\n",
              "      <td>Released</td>\n",
              "      <td>Captain America: Civil War</td>\n",
              "      <td>7.1</td>\n",
              "      <td>7462.0</td>\n",
              "      <td>122920</td>\n",
              "      <td>3498820</td>\n",
              "      <td>Following the events of Age of Ultron, the col...</td>\n",
              "      <td>2016</td>\n",
              "      <td>Wednesday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>266</th>\n",
              "      <td>8000000</td>\n",
              "      <td>Thriller|Crime</td>\n",
              "      <td>680</td>\n",
              "      <td>en</td>\n",
              "      <td>140.950236</td>\n",
              "      <td>Miramax Films|A Band Apart|Jersey Films</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>2.139288e+08</td>\n",
              "      <td>154.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
              "      <td>Released</td>\n",
              "      <td>Pulp Fiction</td>\n",
              "      <td>8.3</td>\n",
              "      <td>8670.0</td>\n",
              "      <td>296</td>\n",
              "      <td>110912</td>\n",
              "      <td>A burger-loving hit man, his philosophical par...</td>\n",
              "      <td>1994</td>\n",
              "      <td>Saturday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6909</th>\n",
              "      <td>185000000</td>\n",
              "      <td>Drama|Action|Crime|Thriller</td>\n",
              "      <td>155</td>\n",
              "      <td>en</td>\n",
              "      <td>123.167259</td>\n",
              "      <td>DC Comics|Legendary Pictures|Warner Bros.|DC E...</td>\n",
              "      <td>United Kingdom|United States of America</td>\n",
              "      <td>1.004558e+09</td>\n",
              "      <td>152.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
              "      <td>Released</td>\n",
              "      <td>The Dark Knight</td>\n",
              "      <td>8.3</td>\n",
              "      <td>12269.0</td>\n",
              "      <td>58559</td>\n",
              "      <td>468569</td>\n",
              "      <td>Batman raises the stakes in his war on crime. ...</td>\n",
              "      <td>2008</td>\n",
              "      <td>Wednesday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>485</th>\n",
              "      <td>28000000</td>\n",
              "      <td>Science Fiction|Drama|Thriller</td>\n",
              "      <td>78</td>\n",
              "      <td>en</td>\n",
              "      <td>96.272374</td>\n",
              "      <td>Shaw Brothers|Warner Bros.|The Ladd Company</td>\n",
              "      <td>United States of America|Hong Kong|United Kingdom</td>\n",
              "      <td>3.313962e+07</td>\n",
              "      <td>117.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
              "      <td>Released</td>\n",
              "      <td>Blade Runner</td>\n",
              "      <td>7.9</td>\n",
              "      <td>3833.0</td>\n",
              "      <td>541</td>\n",
              "      <td>83658</td>\n",
              "      <td>In the smog-choked dystopian Los Angeles of 20...</td>\n",
              "      <td>1982</td>\n",
              "      <td>Friday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7879</th>\n",
              "      <td>220000000</td>\n",
              "      <td>Science Fiction|Action|Adventure</td>\n",
              "      <td>24428</td>\n",
              "      <td>en</td>\n",
              "      <td>89.887648</td>\n",
              "      <td>Paramount Pictures|Marvel Studios</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1.519558e+09</td>\n",
              "      <td>143.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>The Avengers</td>\n",
              "      <td>7.4</td>\n",
              "      <td>12000.0</td>\n",
              "      <td>89745</td>\n",
              "      <td>848228</td>\n",
              "      <td>When an unexpected enemy emerges and threatens...</td>\n",
              "      <td>2012</td>\n",
              "      <td>Wednesday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8649</th>\n",
              "      <td>34000000</td>\n",
              "      <td>Action|Mystery|Science Fiction|Thriller</td>\n",
              "      <td>198663</td>\n",
              "      <td>en</td>\n",
              "      <td>76.937890</td>\n",
              "      <td>Ingenious Media|Twentieth Century Fox Film Cor...</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>3.483199e+08</td>\n",
              "      <td>113.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>The Maze Runner</td>\n",
              "      <td>7.0</td>\n",
              "      <td>5540.0</td>\n",
              "      <td>114180</td>\n",
              "      <td>1790864</td>\n",
              "      <td>Set in a post-apocalyptic world, young Thomas ...</td>\n",
              "      <td>2014</td>\n",
              "      <td>Wednesday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8605</th>\n",
              "      <td>170000000</td>\n",
              "      <td>Science Fiction|Action|Drama|Thriller</td>\n",
              "      <td>119450</td>\n",
              "      <td>en</td>\n",
              "      <td>75.385211</td>\n",
              "      <td>Ingenious Media|Chernin Entertainment|TSG Ente...</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>7.106446e+08</td>\n",
              "      <td>130.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Dawn of the Planet of the Apes</td>\n",
              "      <td>7.3</td>\n",
              "      <td>4511.0</td>\n",
              "      <td>112623</td>\n",
              "      <td>2103281</td>\n",
              "      <td>A group of scientists in San Francisco struggl...</td>\n",
              "      <td>2014</td>\n",
              "      <td>Thursday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8601</th>\n",
              "      <td>3300000</td>\n",
              "      <td>Drama</td>\n",
              "      <td>244786</td>\n",
              "      <td>en</td>\n",
              "      <td>64.299990</td>\n",
              "      <td>Bold Films|Blumhouse Productions|Right of Way ...</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1.309200e+07</td>\n",
              "      <td>105.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Whiplash</td>\n",
              "      <td>8.3</td>\n",
              "      <td>4376.0</td>\n",
              "      <td>112552</td>\n",
              "      <td>2582802</td>\n",
              "      <td>Under the direction of a ruthless instructor, ...</td>\n",
              "      <td>2014</td>\n",
              "      <td>Friday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2372</th>\n",
              "      <td>63000000</td>\n",
              "      <td>Drama</td>\n",
              "      <td>550</td>\n",
              "      <td>en</td>\n",
              "      <td>63.869599</td>\n",
              "      <td>Twentieth Century Fox Film Corporation|Regency...</td>\n",
              "      <td>Germany|United States of America</td>\n",
              "      <td>1.008538e+08</td>\n",
              "      <td>139.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Fight Club</td>\n",
              "      <td>8.3</td>\n",
              "      <td>9678.0</td>\n",
              "      <td>2959</td>\n",
              "      <td>137523</td>\n",
              "      <td>A ticking-time-bomb insomniac and a slippery s...</td>\n",
              "      <td>1999</td>\n",
              "      <td>Friday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8616</th>\n",
              "      <td>170000000</td>\n",
              "      <td>Action|Science Fiction|Adventure</td>\n",
              "      <td>118340</td>\n",
              "      <td>en</td>\n",
              "      <td>53.291601</td>\n",
              "      <td>Marvel Studios|Moving Picture Company (MPC)|Bu...</td>\n",
              "      <td>United Kingdom|United States of America</td>\n",
              "      <td>7.733286e+08</td>\n",
              "      <td>121.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Guardians of the Galaxy</td>\n",
              "      <td>7.9</td>\n",
              "      <td>10014.0</td>\n",
              "      <td>112852</td>\n",
              "      <td>2015381</td>\n",
              "      <td>Light years from Earth, 26 years after being a...</td>\n",
              "      <td>2014</td>\n",
              "      <td>Wednesday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>284</th>\n",
              "      <td>25000000</td>\n",
              "      <td>Drama|Crime</td>\n",
              "      <td>278</td>\n",
              "      <td>en</td>\n",
              "      <td>51.645403</td>\n",
              "      <td>Castle Rock Entertainment|Warner Bros.</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>2.834147e+07</td>\n",
              "      <td>142.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>The Shawshank Redemption</td>\n",
              "      <td>8.5</td>\n",
              "      <td>8358.0</td>\n",
              "      <td>318</td>\n",
              "      <td>111161</td>\n",
              "      <td>Framed in the 1940s for the double murder of h...</td>\n",
              "      <td>1994</td>\n",
              "      <td>Friday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>321</th>\n",
              "      <td>55000000</td>\n",
              "      <td>Comedy|Drama|Romance</td>\n",
              "      <td>13</td>\n",
              "      <td>en</td>\n",
              "      <td>48.307194</td>\n",
              "      <td>Paramount Pictures</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>6.779454e+08</td>\n",
              "      <td>142.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Forrest Gump</td>\n",
              "      <td>8.2</td>\n",
              "      <td>8147.0</td>\n",
              "      <td>356</td>\n",
              "      <td>109830</td>\n",
              "      <td>A man with a low IQ has accomplished great thi...</td>\n",
              "      <td>1994</td>\n",
              "      <td>Wednesday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4693</th>\n",
              "      <td>140000000</td>\n",
              "      <td>Adventure|Fantasy|Action</td>\n",
              "      <td>22</td>\n",
              "      <td>en</td>\n",
              "      <td>47.326665</td>\n",
              "      <td>Walt Disney Pictures|Jerry Bruckheimer Films</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>6.550112e+08</td>\n",
              "      <td>143.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Pirates of the Caribbean: The Curse of the Bla...</td>\n",
              "      <td>7.5</td>\n",
              "      <td>7191.0</td>\n",
              "      <td>6539</td>\n",
              "      <td>325980</td>\n",
              "      <td>Jack Sparrow, a freewheeling 17th-century pira...</td>\n",
              "      <td>2003</td>\n",
              "      <td>Wednesday</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "         budget  ... release_day\n",
              "8906   74000000  ...   Wednesday\n",
              "8681  165000000  ...      Friday\n",
              "8769   58000000  ...     Tuesday\n",
              "7404  237000000  ...    Thursday\n",
              "8671   20000000  ...   Wednesday\n",
              "8602   61000000  ...   Wednesday\n",
              "8700  125000000  ...     Tuesday\n",
              "8770  250000000  ...   Wednesday\n",
              "266     8000000  ...    Saturday\n",
              "6909  185000000  ...   Wednesday\n",
              "485    28000000  ...      Friday\n",
              "7879  220000000  ...   Wednesday\n",
              "8649   34000000  ...   Wednesday\n",
              "8605  170000000  ...    Thursday\n",
              "8601    3300000  ...      Friday\n",
              "2372   63000000  ...      Friday\n",
              "8616  170000000  ...   Wednesday\n",
              "284    25000000  ...      Friday\n",
              "321    55000000  ...   Wednesday\n",
              "4693  140000000  ...   Wednesday\n",
              "\n",
              "[20 rows x 19 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 29
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "tleRn5YKeFDn"
      },
      "source": [
        "**Resetting Index post Sorting**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "kpRucm0VeM9N",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 618
        },
        "outputId": "fa710278-fd5f-4d9a-82c9-bef384826cf9"
      },
      "source": [
        "movies_metadata=movies_metadata.reset_index(drop=True)\n",
        "movies_metadata.head()"
      ],
      "execution_count": 30,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>budget</th>\n",
              "      <th>genres</th>\n",
              "      <th>tmdbId</th>\n",
              "      <th>original_language</th>\n",
              "      <th>popularity</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>production_countries</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>spoken_languages</th>\n",
              "      <th>status</th>\n",
              "      <th>title</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>movieId</th>\n",
              "      <th>imdbId</th>\n",
              "      <th>content</th>\n",
              "      <th>release_year</th>\n",
              "      <th>release_day</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>74000000</td>\n",
              "      <td>Family|Animation|Adventure|Comedy</td>\n",
              "      <td>211672</td>\n",
              "      <td>en</td>\n",
              "      <td>547.488298</td>\n",
              "      <td>Universal Pictures|Illumination Entertainment</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1.156731e+09</td>\n",
              "      <td>91.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Minions</td>\n",
              "      <td>6.4</td>\n",
              "      <td>4729.0</td>\n",
              "      <td>135887</td>\n",
              "      <td>2293640</td>\n",
              "      <td>Minions Stuart, Kevin and Bob are recruited by...</td>\n",
              "      <td>2015</td>\n",
              "      <td>Wednesday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>165000000</td>\n",
              "      <td>Adventure|Family|Animation|Action|Comedy</td>\n",
              "      <td>177572</td>\n",
              "      <td>en</td>\n",
              "      <td>213.849907</td>\n",
              "      <td>Walt Disney Pictures|Walt Disney Animation Stu...</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>6.521054e+08</td>\n",
              "      <td>102.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Big Hero 6</td>\n",
              "      <td>7.8</td>\n",
              "      <td>6289.0</td>\n",
              "      <td>115617</td>\n",
              "      <td>2245084</td>\n",
              "      <td>The special bond that develops between plus-si...</td>\n",
              "      <td>2014</td>\n",
              "      <td>Friday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>58000000</td>\n",
              "      <td>Action|Adventure|Comedy</td>\n",
              "      <td>293660</td>\n",
              "      <td>en</td>\n",
              "      <td>187.860492</td>\n",
              "      <td>Twentieth Century Fox Film Corporation|Marvel ...</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>7.831130e+08</td>\n",
              "      <td>108.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Deadpool</td>\n",
              "      <td>7.4</td>\n",
              "      <td>11444.0</td>\n",
              "      <td>122904</td>\n",
              "      <td>1431045</td>\n",
              "      <td>Deadpool tells the origin story of former Spec...</td>\n",
              "      <td>2016</td>\n",
              "      <td>Tuesday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>237000000</td>\n",
              "      <td>Action|Adventure|Fantasy|Science Fiction</td>\n",
              "      <td>19995</td>\n",
              "      <td>en</td>\n",
              "      <td>185.070892</td>\n",
              "      <td>Ingenious Film Partners|Twentieth Century Fox ...</td>\n",
              "      <td>United States of America|United Kingdom</td>\n",
              "      <td>2.787965e+09</td>\n",
              "      <td>162.0</td>\n",
              "      <td>[{'iso_639_1': 'en', 'name': 'English'}, {'iso...</td>\n",
              "      <td>Released</td>\n",
              "      <td>Avatar</td>\n",
              "      <td>7.2</td>\n",
              "      <td>12114.0</td>\n",
              "      <td>72998</td>\n",
              "      <td>499549</td>\n",
              "      <td>In the 22nd century, a paraplegic Marine is di...</td>\n",
              "      <td>2009</td>\n",
              "      <td>Thursday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>20000000</td>\n",
              "      <td>Action|Thriller</td>\n",
              "      <td>245891</td>\n",
              "      <td>en</td>\n",
              "      <td>183.870374</td>\n",
              "      <td>Summit Entertainment|Warner Bros.|87Eleven|Def...</td>\n",
              "      <td>Canada|China|United States of America</td>\n",
              "      <td>8.876166e+07</td>\n",
              "      <td>101.0</td>\n",
              "      <td>[{'iso_639_1': 'hu', 'name': 'Magyar'}, {'iso_...</td>\n",
              "      <td>Released</td>\n",
              "      <td>John Wick</td>\n",
              "      <td>7.0</td>\n",
              "      <td>5499.0</td>\n",
              "      <td>115149</td>\n",
              "      <td>2911666</td>\n",
              "      <td>Ex-lunatic John Wick comes off his meds to tra...</td>\n",
              "      <td>2014</td>\n",
              "      <td>Wednesday</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      budget                                    genres  ...  release_year release_day\n",
              "0   74000000         Family|Animation|Adventure|Comedy  ...          2015   Wednesday\n",
              "1  165000000  Adventure|Family|Animation|Action|Comedy  ...          2014      Friday\n",
              "2   58000000                   Action|Adventure|Comedy  ...          2016     Tuesday\n",
              "3  237000000  Action|Adventure|Fantasy|Science Fiction  ...          2009    Thursday\n",
              "4   20000000                           Action|Thriller  ...          2014   Wednesday\n",
              "\n",
              "[5 rows x 19 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 30
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "lmLiwAFteUoh"
      },
      "source": [
        "**Budget Column:** There are too many 0s in the 'budget' column which is absurd. Hence  the 0 values are replaced with median of the non-zero values of 'budget' column. Two rows with absurd value of budget is removed completely"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ic8Psgpnl9CG"
      },
      "source": [
        "movies_metadata=movies_metadata[movies_metadata['budget']!='/ff9qCepilowshEtG2GYWwzt2bs4.jpg']\n",
        "movies_metadata=movies_metadata[movies_metadata['budget']!='/zV8bHuSL6WXoD6FWogP9j4x80bL.jpg']\n",
        "movies_metadata['budget']=movies_metadata['budget'].astype(int)\n",
        "budget_list = movies_metadata[movies_metadata['budget']!=0]['budget']\n",
        "movies_metadata['budget']=movies_metadata['budget'].replace(0,budget_list.median())"
      ],
      "execution_count": 31,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "1GwCf5VaqgRx",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "ff7744ab-e0ec-4f0f-b574-bbbf28a37937"
      },
      "source": [
        "movies_metadata.info()"
      ],
      "execution_count": 32,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "Int64Index: 9098 entries, 0 to 9097\n",
            "Data columns (total 19 columns):\n",
            " #   Column                Non-Null Count  Dtype  \n",
            "---  ------                --------------  -----  \n",
            " 0   budget                9098 non-null   int64  \n",
            " 1   genres                9098 non-null   object \n",
            " 2   tmdbId                9098 non-null   int64  \n",
            " 3   original_language     9098 non-null   object \n",
            " 4   popularity            9098 non-null   float64\n",
            " 5   production_companies  9098 non-null   object \n",
            " 6   production_countries  9098 non-null   object \n",
            " 7   revenue               9098 non-null   float64\n",
            " 8   runtime               9098 non-null   float64\n",
            " 9   spoken_languages      9098 non-null   object \n",
            " 10  status                9096 non-null   object \n",
            " 11  title                 9098 non-null   object \n",
            " 12  vote_average          9098 non-null   float64\n",
            " 13  vote_count            9098 non-null   float64\n",
            " 14  movieId               9098 non-null   int64  \n",
            " 15  imdbId                9098 non-null   int64  \n",
            " 16  content               9098 non-null   object \n",
            " 17  release_year          9098 non-null   object \n",
            " 18  release_day           9098 non-null   object \n",
            "dtypes: float64(5), int64(4), object(10)\n",
            "memory usage: 1.4+ MB\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "rWjdvXYFfF6L"
      },
      "source": [
        "**Original_language column:**  The **'original_language'** column has language code as its value. The **'spoken_languages'** column has both language code and language name as values. Hence the language codes are replaced with language name in the **'original_language'** column with the help of the **'spoken_languages'** column. Then the **'spoken_languages'** column is dropped."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "EHSQTYLYdrdd",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 618
        },
        "outputId": "e4f334c5-f176-47fc-baa0-6769c266b3b1"
      },
      "source": [
        "movies_metadata['spoken_languages'] = movies_metadata['spoken_languages'].fillna('[]').apply(literal_eval).apply(lambda x: [(i['iso_639_1'],i['name']) for i in x] if isinstance(x, list) else [])\n",
        "movies_metadata.head()"
      ],
      "execution_count": 33,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>budget</th>\n",
              "      <th>genres</th>\n",
              "      <th>tmdbId</th>\n",
              "      <th>original_language</th>\n",
              "      <th>popularity</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>production_countries</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>spoken_languages</th>\n",
              "      <th>status</th>\n",
              "      <th>title</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>movieId</th>\n",
              "      <th>imdbId</th>\n",
              "      <th>content</th>\n",
              "      <th>release_year</th>\n",
              "      <th>release_day</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>74000000</td>\n",
              "      <td>Family|Animation|Adventure|Comedy</td>\n",
              "      <td>211672</td>\n",
              "      <td>en</td>\n",
              "      <td>547.488298</td>\n",
              "      <td>Universal Pictures|Illumination Entertainment</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1.156731e+09</td>\n",
              "      <td>91.0</td>\n",
              "      <td>[(en, English)]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Minions</td>\n",
              "      <td>6.4</td>\n",
              "      <td>4729.0</td>\n",
              "      <td>135887</td>\n",
              "      <td>2293640</td>\n",
              "      <td>Minions Stuart, Kevin and Bob are recruited by...</td>\n",
              "      <td>2015</td>\n",
              "      <td>Wednesday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>165000000</td>\n",
              "      <td>Adventure|Family|Animation|Action|Comedy</td>\n",
              "      <td>177572</td>\n",
              "      <td>en</td>\n",
              "      <td>213.849907</td>\n",
              "      <td>Walt Disney Pictures|Walt Disney Animation Stu...</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>6.521054e+08</td>\n",
              "      <td>102.0</td>\n",
              "      <td>[(en, English)]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Big Hero 6</td>\n",
              "      <td>7.8</td>\n",
              "      <td>6289.0</td>\n",
              "      <td>115617</td>\n",
              "      <td>2245084</td>\n",
              "      <td>The special bond that develops between plus-si...</td>\n",
              "      <td>2014</td>\n",
              "      <td>Friday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>58000000</td>\n",
              "      <td>Action|Adventure|Comedy</td>\n",
              "      <td>293660</td>\n",
              "      <td>en</td>\n",
              "      <td>187.860492</td>\n",
              "      <td>Twentieth Century Fox Film Corporation|Marvel ...</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>7.831130e+08</td>\n",
              "      <td>108.0</td>\n",
              "      <td>[(en, English)]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Deadpool</td>\n",
              "      <td>7.4</td>\n",
              "      <td>11444.0</td>\n",
              "      <td>122904</td>\n",
              "      <td>1431045</td>\n",
              "      <td>Deadpool tells the origin story of former Spec...</td>\n",
              "      <td>2016</td>\n",
              "      <td>Tuesday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>237000000</td>\n",
              "      <td>Action|Adventure|Fantasy|Science Fiction</td>\n",
              "      <td>19995</td>\n",
              "      <td>en</td>\n",
              "      <td>185.070892</td>\n",
              "      <td>Ingenious Film Partners|Twentieth Century Fox ...</td>\n",
              "      <td>United States of America|United Kingdom</td>\n",
              "      <td>2.787965e+09</td>\n",
              "      <td>162.0</td>\n",
              "      <td>[(en, English), (es, Español)]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Avatar</td>\n",
              "      <td>7.2</td>\n",
              "      <td>12114.0</td>\n",
              "      <td>72998</td>\n",
              "      <td>499549</td>\n",
              "      <td>In the 22nd century, a paraplegic Marine is di...</td>\n",
              "      <td>2009</td>\n",
              "      <td>Thursday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>20000000</td>\n",
              "      <td>Action|Thriller</td>\n",
              "      <td>245891</td>\n",
              "      <td>en</td>\n",
              "      <td>183.870374</td>\n",
              "      <td>Summit Entertainment|Warner Bros.|87Eleven|Def...</td>\n",
              "      <td>Canada|China|United States of America</td>\n",
              "      <td>8.876166e+07</td>\n",
              "      <td>101.0</td>\n",
              "      <td>[(hu, Magyar), (en, English), (ru, Pусский)]</td>\n",
              "      <td>Released</td>\n",
              "      <td>John Wick</td>\n",
              "      <td>7.0</td>\n",
              "      <td>5499.0</td>\n",
              "      <td>115149</td>\n",
              "      <td>2911666</td>\n",
              "      <td>Ex-lunatic John Wick comes off his meds to tra...</td>\n",
              "      <td>2014</td>\n",
              "      <td>Wednesday</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      budget                                    genres  ...  release_year release_day\n",
              "0   74000000         Family|Animation|Adventure|Comedy  ...          2015   Wednesday\n",
              "1  165000000  Adventure|Family|Animation|Action|Comedy  ...          2014      Friday\n",
              "2   58000000                   Action|Adventure|Comedy  ...          2016     Tuesday\n",
              "3  237000000  Action|Adventure|Fantasy|Science Fiction  ...          2009    Thursday\n",
              "4   20000000                           Action|Thriller  ...          2014   Wednesday\n",
              "\n",
              "[5 rows x 19 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 33
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "1_Jp4RQtexdP"
      },
      "source": [
        "languages={}\n",
        "for index in movies_metadata.index:\n",
        "  for item in movies_metadata.loc[index,'spoken_languages']:\n",
        "    languages[item[0]]=item[1]"
      ],
      "execution_count": 34,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Ph1ueAF_iHfY",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "c8b52eac-3909-4be4-b105-167ee6b3770b"
      },
      "source": [
        "for key in languages.keys():\n",
        "  translator=google_translator()\n",
        "  eng=translator.translate(languages[key],lang_tgt='en')\n",
        "  languages[key]=eng\n",
        "languages"
      ],
      "execution_count": 35,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'af': 'Afrikaans ',\n",
              " 'ar': 'Arabic ',\n",
              " 'as': '',\n",
              " 'az': 'Azerbaijan ',\n",
              " 'be': 'Belarusian language ',\n",
              " 'bg': 'Bulgarian language ',\n",
              " 'bn': 'Bengali ',\n",
              " 'bo': '',\n",
              " 'br': '',\n",
              " 'bs': 'Bosnian ',\n",
              " 'ca': 'Catalan ',\n",
              " 'cn': 'Cantonese / Cantonese ',\n",
              " 'co': '',\n",
              " 'cr': '',\n",
              " 'cs': 'Czech ',\n",
              " 'cy': 'Welsh ',\n",
              " 'da': 'Dansk ',\n",
              " 'de': 'German ',\n",
              " 'el': 'Greek ',\n",
              " 'en': 'English ',\n",
              " 'eo': 'Esperanto ',\n",
              " 'es': 'Spanish ',\n",
              " 'et': 'Estonia ',\n",
              " 'eu': 'Basque ',\n",
              " 'fa': 'Farsi ',\n",
              " 'fi': 'Finland ',\n",
              " 'fr': 'French ',\n",
              " 'ga': 'Irish ',\n",
              " 'gd': '',\n",
              " 'gl': 'Galician ',\n",
              " 'gn': '',\n",
              " 'gu': '',\n",
              " 'he': 'Abrit ',\n",
              " 'hi': 'Hindi ',\n",
              " 'hr': 'Croatian ',\n",
              " 'hu': 'Hungarian ',\n",
              " 'hy': '',\n",
              " 'id': 'Indonesian ',\n",
              " 'is': 'Icelandic ',\n",
              " 'it': 'Italian ',\n",
              " 'iu': '',\n",
              " 'ja': 'Japanese ',\n",
              " 'jv': '',\n",
              " 'ka': 'Georgian ',\n",
              " 'kk': 'Kazakh ',\n",
              " 'km': '',\n",
              " 'ko': 'Korean, Korean language ',\n",
              " 'kw': '',\n",
              " 'la': 'Latin ',\n",
              " 'ln': '',\n",
              " 'lo': '',\n",
              " 'lv': 'Latvian ',\n",
              " 'mi': '',\n",
              " 'mk': '',\n",
              " 'mn': '',\n",
              " 'ms': 'Malay language ',\n",
              " 'mt': 'Maltese ',\n",
              " 'my': '',\n",
              " 'nb': 'Bokmål ',\n",
              " 'ne': '',\n",
              " 'nl': 'Dutch ',\n",
              " 'no': 'Norsk ',\n",
              " 'nv': '',\n",
              " 'ny': '',\n",
              " 'oc': '',\n",
              " 'pa': 'Punjabi ',\n",
              " 'pl': 'Polish ',\n",
              " 'ps': 'Pashto ',\n",
              " 'pt': 'Portuguese ',\n",
              " 'qu': '',\n",
              " 'ro': 'Romania ',\n",
              " 'ru': 'Pусский ',\n",
              " 'sa': '',\n",
              " 'sc': '',\n",
              " 'sg': '',\n",
              " 'sh': '',\n",
              " 'si': '',\n",
              " 'sk': 'Slovenčina ',\n",
              " 'sl': 'Slovene ',\n",
              " 'so': 'Somali ',\n",
              " 'sq': 'Albanian ',\n",
              " 'sr': 'Serbian ',\n",
              " 'st': '',\n",
              " 'sv': 'Swedish ',\n",
              " 'sw': 'Kiswahili ',\n",
              " 'ta': 'Tamil ',\n",
              " 'th': 'Thai language ',\n",
              " 'tl': '',\n",
              " 'tr': 'Turkish ',\n",
              " 'tt': '',\n",
              " 'ty': '',\n",
              " 'uk': 'Ukrainian ',\n",
              " 'ur': 'Urdu ',\n",
              " 'vi': 'Vietnamese ',\n",
              " 'wo': 'Wolof ',\n",
              " 'xh': '',\n",
              " 'xx': 'No Language ',\n",
              " 'yi': '',\n",
              " 'zh': 'Mandarin ',\n",
              " 'zu': 'isiZulu '}"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 35
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "3MnAIfnDhM4f",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "5cda47e7-3156-4f6d-8fa1-32029b9529cd"
      },
      "source": [
        "for index in movies_metadata.index:\n",
        "  if movies_metadata.loc[index,'original_language'] in languages.keys():\n",
        "    movies_metadata.loc[index,'original_language']=languages[movies_metadata.loc[index,'original_language']]\n",
        "movies_metadata['original_language'].fillna('Unknown',inplace=True)\n",
        "movies_metadata['original_language'].value_counts()"
      ],
      "execution_count": 36,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "English                     7954\n",
              "French                       274\n",
              "Japanese                     188\n",
              "German                       114\n",
              "Italian                       98\n",
              "Spanish                       88\n",
              "Cantonese / Cantonese         47\n",
              "Swedish                       42\n",
              "Mandarin                      39\n",
              "Dansk                         31\n",
              "Korean, Korean language       31\n",
              "Pусский                       27\n",
              "Portuguese                    25\n",
              "Dutch                         16\n",
              "Farsi                         15\n",
              "Hindi                         13\n",
              "Finland                       13\n",
              "Czech                         10\n",
              "Turkish                        8\n",
              "Thai language                  7\n",
              "Norsk                          7\n",
              "Polish                         6\n",
              "Abrit                          6\n",
              "Greek                          5\n",
              "Serbian                        4\n",
              "Hungarian                      4\n",
              "Indonesian                     3\n",
              "No Language                    3\n",
              "Bengali                        3\n",
              "Vietnamese                     2\n",
              "Bokmål                         2\n",
              "Romania                        2\n",
              "Arabic                         2\n",
              "                               2\n",
              "Bosnian                        1\n",
              "Estonia                        1\n",
              "Slovenčina                     1\n",
              "Pashto                         1\n",
              "Ukrainian                      1\n",
              "Afrikaans                      1\n",
              "Icelandic                      1\n",
              "Name: original_language, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 36
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "iPIudEN2huVc"
      },
      "source": [
        "**Filling Null Values Using Various Methods**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "v_wbBwxOqTRl",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "c9e2ed08-42e6-4cff-830e-2231fed73043"
      },
      "source": [
        "movies_metadata.info()"
      ],
      "execution_count": 37,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "Int64Index: 9098 entries, 0 to 9097\n",
            "Data columns (total 19 columns):\n",
            " #   Column                Non-Null Count  Dtype  \n",
            "---  ------                --------------  -----  \n",
            " 0   budget                9098 non-null   int64  \n",
            " 1   genres                9098 non-null   object \n",
            " 2   tmdbId                9098 non-null   int64  \n",
            " 3   original_language     9098 non-null   object \n",
            " 4   popularity            9098 non-null   float64\n",
            " 5   production_companies  9098 non-null   object \n",
            " 6   production_countries  9098 non-null   object \n",
            " 7   revenue               9098 non-null   float64\n",
            " 8   runtime               9098 non-null   float64\n",
            " 9   spoken_languages      9098 non-null   object \n",
            " 10  status                9096 non-null   object \n",
            " 11  title                 9098 non-null   object \n",
            " 12  vote_average          9098 non-null   float64\n",
            " 13  vote_count            9098 non-null   float64\n",
            " 14  movieId               9098 non-null   int64  \n",
            " 15  imdbId                9098 non-null   int64  \n",
            " 16  content               9098 non-null   object \n",
            " 17  release_year          9098 non-null   object \n",
            " 18  release_day           9098 non-null   object \n",
            "dtypes: float64(5), int64(4), object(10)\n",
            "memory usage: 1.7+ MB\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "jNhCvbU6Wdgx"
      },
      "source": [
        "movies_metadata['status'].fillna('Unknown',inplace=True)\n",
        "movies_metadata['title'].fillna('Unknown',inplace=True)\n",
        "movies_metadata['release_day'].fillna('Unknown',inplace=True)\n",
        "movies_metadata['revenue'].fillna(movies_metadata['revenue'].median(),inplace=True)\n",
        "movies_metadata['runtime'].fillna(movies_metadata['runtime'].mean(),inplace=True)"
      ],
      "execution_count": 38,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "FrFMz5rUUqUO",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "a7163d46-ae28-4210-824b-ddd1a37eb0e6"
      },
      "source": [
        "movies_metadata=movies_metadata.reset_index(drop=True)\n",
        "movies_metadata.info()"
      ],
      "execution_count": 39,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 9098 entries, 0 to 9097\n",
            "Data columns (total 19 columns):\n",
            " #   Column                Non-Null Count  Dtype  \n",
            "---  ------                --------------  -----  \n",
            " 0   budget                9098 non-null   int64  \n",
            " 1   genres                9098 non-null   object \n",
            " 2   tmdbId                9098 non-null   int64  \n",
            " 3   original_language     9098 non-null   object \n",
            " 4   popularity            9098 non-null   float64\n",
            " 5   production_companies  9098 non-null   object \n",
            " 6   production_countries  9098 non-null   object \n",
            " 7   revenue               9098 non-null   float64\n",
            " 8   runtime               9098 non-null   float64\n",
            " 9   spoken_languages      9098 non-null   object \n",
            " 10  status                9098 non-null   object \n",
            " 11  title                 9098 non-null   object \n",
            " 12  vote_average          9098 non-null   float64\n",
            " 13  vote_count            9098 non-null   float64\n",
            " 14  movieId               9098 non-null   int64  \n",
            " 15  imdbId                9098 non-null   int64  \n",
            " 16  content               9098 non-null   object \n",
            " 17  release_year          9098 non-null   object \n",
            " 18  release_day           9098 non-null   object \n",
            "dtypes: float64(5), int64(4), object(10)\n",
            "memory usage: 1.3+ MB\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "3kORtZMbTYbW"
      },
      "source": [
        "**Revenue Column:** There are too many 0s in the 'revenue' column which is absurd. Hence  the 0 values are replaced with median of the non-zero values of 'revenue' column."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "KxJcIcEbKKwM",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "cce56c5a-c4ce-475b-a141-55dcdc9947d3"
      },
      "source": [
        "movies_metadata[movies_metadata['revenue']==0].movieId.count()\n"
      ],
      "execution_count": 40,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "4330"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 40
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "7P33y3_tS3bF"
      },
      "source": [
        "revenue_list = movies_metadata[movies_metadata['revenue']!=0]['revenue']\n",
        "movies_metadata['revenue']=movies_metadata['revenue'].replace(0,revenue_list.median())"
      ],
      "execution_count": 41,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "yaMV4p3OfRSO"
      },
      "source": [
        "**FINDING PROFITS GAINED BY MOVIES FROM GIVEN BUDGET AND REVENUE:**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "YvUe-KUlfdMI",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 618
        },
        "outputId": "aee67a81-774e-484a-ebef-3738e0494a5a"
      },
      "source": [
        "movies_metadata['profit']=movies_metadata['revenue']-movies_metadata['budget']\n",
        "movies_metadata.head()"
      ],
      "execution_count": 42,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>budget</th>\n",
              "      <th>genres</th>\n",
              "      <th>tmdbId</th>\n",
              "      <th>original_language</th>\n",
              "      <th>popularity</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>production_countries</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>spoken_languages</th>\n",
              "      <th>status</th>\n",
              "      <th>title</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>movieId</th>\n",
              "      <th>imdbId</th>\n",
              "      <th>content</th>\n",
              "      <th>release_year</th>\n",
              "      <th>release_day</th>\n",
              "      <th>profit</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>74000000</td>\n",
              "      <td>Family|Animation|Adventure|Comedy</td>\n",
              "      <td>211672</td>\n",
              "      <td>English</td>\n",
              "      <td>547.488298</td>\n",
              "      <td>Universal Pictures|Illumination Entertainment</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>1.156731e+09</td>\n",
              "      <td>91.0</td>\n",
              "      <td>[(en, English)]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Minions</td>\n",
              "      <td>6.4</td>\n",
              "      <td>4729.0</td>\n",
              "      <td>135887</td>\n",
              "      <td>2293640</td>\n",
              "      <td>Minions Stuart, Kevin and Bob are recruited by...</td>\n",
              "      <td>2015</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>1.082731e+09</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>165000000</td>\n",
              "      <td>Adventure|Family|Animation|Action|Comedy</td>\n",
              "      <td>177572</td>\n",
              "      <td>English</td>\n",
              "      <td>213.849907</td>\n",
              "      <td>Walt Disney Pictures|Walt Disney Animation Stu...</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>6.521054e+08</td>\n",
              "      <td>102.0</td>\n",
              "      <td>[(en, English)]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Big Hero 6</td>\n",
              "      <td>7.8</td>\n",
              "      <td>6289.0</td>\n",
              "      <td>115617</td>\n",
              "      <td>2245084</td>\n",
              "      <td>The special bond that develops between plus-si...</td>\n",
              "      <td>2014</td>\n",
              "      <td>Friday</td>\n",
              "      <td>4.871054e+08</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>58000000</td>\n",
              "      <td>Action|Adventure|Comedy</td>\n",
              "      <td>293660</td>\n",
              "      <td>English</td>\n",
              "      <td>187.860492</td>\n",
              "      <td>Twentieth Century Fox Film Corporation|Marvel ...</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>7.831130e+08</td>\n",
              "      <td>108.0</td>\n",
              "      <td>[(en, English)]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Deadpool</td>\n",
              "      <td>7.4</td>\n",
              "      <td>11444.0</td>\n",
              "      <td>122904</td>\n",
              "      <td>1431045</td>\n",
              "      <td>Deadpool tells the origin story of former Spec...</td>\n",
              "      <td>2016</td>\n",
              "      <td>Tuesday</td>\n",
              "      <td>7.251130e+08</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>237000000</td>\n",
              "      <td>Action|Adventure|Fantasy|Science Fiction</td>\n",
              "      <td>19995</td>\n",
              "      <td>English</td>\n",
              "      <td>185.070892</td>\n",
              "      <td>Ingenious Film Partners|Twentieth Century Fox ...</td>\n",
              "      <td>United States of America|United Kingdom</td>\n",
              "      <td>2.787965e+09</td>\n",
              "      <td>162.0</td>\n",
              "      <td>[(en, English), (es, Español)]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Avatar</td>\n",
              "      <td>7.2</td>\n",
              "      <td>12114.0</td>\n",
              "      <td>72998</td>\n",
              "      <td>499549</td>\n",
              "      <td>In the 22nd century, a paraplegic Marine is di...</td>\n",
              "      <td>2009</td>\n",
              "      <td>Thursday</td>\n",
              "      <td>2.550965e+09</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>20000000</td>\n",
              "      <td>Action|Thriller</td>\n",
              "      <td>245891</td>\n",
              "      <td>English</td>\n",
              "      <td>183.870374</td>\n",
              "      <td>Summit Entertainment|Warner Bros.|87Eleven|Def...</td>\n",
              "      <td>Canada|China|United States of America</td>\n",
              "      <td>8.876166e+07</td>\n",
              "      <td>101.0</td>\n",
              "      <td>[(hu, Magyar), (en, English), (ru, Pусский)]</td>\n",
              "      <td>Released</td>\n",
              "      <td>John Wick</td>\n",
              "      <td>7.0</td>\n",
              "      <td>5499.0</td>\n",
              "      <td>115149</td>\n",
              "      <td>2911666</td>\n",
              "      <td>Ex-lunatic John Wick comes off his meds to tra...</td>\n",
              "      <td>2014</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>6.876166e+07</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      budget  ...        profit\n",
              "0   74000000  ...  1.082731e+09\n",
              "1  165000000  ...  4.871054e+08\n",
              "2   58000000  ...  7.251130e+08\n",
              "3  237000000  ...  2.550965e+09\n",
              "4   20000000  ...  6.876166e+07\n",
              "\n",
              "[5 rows x 20 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 42
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "EG-FmoE-iIxZ"
      },
      "source": [
        "**Rearranging Column Names :**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "I_YObcDWKP4J"
      },
      "source": [
        "movies_metadata=movies_metadata[['tmdbId','title','release_year','release_day','genres','original_language','runtime','content','production_companies','budget','revenue','production_countries','status','popularity','vote_average','vote_count']]"
      ],
      "execution_count": 43,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "aVQI0m9iiSW5"
      },
      "source": [
        "**Top 5 Bengali Movies According to Popularity, Vote Counts And Vote Average :**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Y-ODkupxqgnD",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 341
        },
        "outputId": "539b8303-2e9b-4595-b1c1-e99715f5397c"
      },
      "source": [
        "Bengali_movies=movies_metadata[movies_metadata['original_language']==\"Bengali \"]\r\n",
        "Bengali_movies.head()"
      ],
      "execution_count": 44,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>tmdbId</th>\n",
              "      <th>title</th>\n",
              "      <th>release_year</th>\n",
              "      <th>release_day</th>\n",
              "      <th>genres</th>\n",
              "      <th>original_language</th>\n",
              "      <th>runtime</th>\n",
              "      <th>content</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>budget</th>\n",
              "      <th>revenue</th>\n",
              "      <th>production_countries</th>\n",
              "      <th>status</th>\n",
              "      <th>popularity</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>6212</th>\n",
              "      <td>5801</td>\n",
              "      <td>Pather Panchali</td>\n",
              "      <td>1955</td>\n",
              "      <td>Friday</td>\n",
              "      <td>Drama</td>\n",
              "      <td>Bengali</td>\n",
              "      <td>125.0</td>\n",
              "      <td>The film is a coming-of-age story of a young b...</td>\n",
              "      <td>Government of West Bengal</td>\n",
              "      <td>18500000</td>\n",
              "      <td>536364.0</td>\n",
              "      <td>India</td>\n",
              "      <td>Released</td>\n",
              "      <td>3.900709</td>\n",
              "      <td>7.9</td>\n",
              "      <td>63.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6926</th>\n",
              "      <td>897</td>\n",
              "      <td>Aparajito</td>\n",
              "      <td>1956</td>\n",
              "      <td>Thursday</td>\n",
              "      <td>Drama</td>\n",
              "      <td>Bengali</td>\n",
              "      <td>110.0</td>\n",
              "      <td>The Unvanquished is the second part of the Ban...</td>\n",
              "      <td>Epic Productions</td>\n",
              "      <td>18500000</td>\n",
              "      <td>170215.0</td>\n",
              "      <td>India</td>\n",
              "      <td>Released</td>\n",
              "      <td>2.800510</td>\n",
              "      <td>7.9</td>\n",
              "      <td>44.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7253</th>\n",
              "      <td>896</td>\n",
              "      <td>The World of Apu</td>\n",
              "      <td>1959</td>\n",
              "      <td>Friday</td>\n",
              "      <td>Drama</td>\n",
              "      <td>Bengali</td>\n",
              "      <td>117.0</td>\n",
              "      <td>Apu is a jobless ex-student dreaming vaguely o...</td>\n",
              "      <td>Satyajit Ray Productions</td>\n",
              "      <td>18500000</td>\n",
              "      <td>16000.0</td>\n",
              "      <td>India</td>\n",
              "      <td>Released</td>\n",
              "      <td>2.381806</td>\n",
              "      <td>8.2</td>\n",
              "      <td>40.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      tmdbId             title  ... vote_average vote_count\n",
              "6212    5801   Pather Panchali  ...          7.9       63.0\n",
              "6926     897         Aparajito  ...          7.9       44.0\n",
              "7253     896  The World of Apu  ...          8.2       40.0\n",
              "\n",
              "[3 rows x 16 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 44
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Bdyy_4WljjRm"
      },
      "source": [
        "**Top 5 Hindi Movies According to Popularity, Vote Counts And Vote Average :**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "cJRPuoTsjhFI",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 602
        },
        "outputId": "bdd05fc2-b578-4062-d56a-ecc42b2c2a62"
      },
      "source": [
        "movies_metadata[movies_metadata['original_language']=='Hindi '].head()"
      ],
      "execution_count": 45,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>tmdbId</th>\n",
              "      <th>title</th>\n",
              "      <th>release_year</th>\n",
              "      <th>release_day</th>\n",
              "      <th>genres</th>\n",
              "      <th>original_language</th>\n",
              "      <th>runtime</th>\n",
              "      <th>content</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>budget</th>\n",
              "      <th>revenue</th>\n",
              "      <th>production_countries</th>\n",
              "      <th>status</th>\n",
              "      <th>popularity</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1595</th>\n",
              "      <td>26022</td>\n",
              "      <td>My Name Is Khan</td>\n",
              "      <td>2010</td>\n",
              "      <td>Friday</td>\n",
              "      <td>Drama|Romance</td>\n",
              "      <td>Hindi</td>\n",
              "      <td>145.0</td>\n",
              "      <td>Rizwan Khan, a Muslim from the Borivali sectio...</td>\n",
              "      <td>Fox Searchlight Pictures|Red Chillies Entertai...</td>\n",
              "      <td>12000000</td>\n",
              "      <td>42345360.0</td>\n",
              "      <td>India|United States of America</td>\n",
              "      <td>Released</td>\n",
              "      <td>11.264586</td>\n",
              "      <td>7.7</td>\n",
              "      <td>237.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1888</th>\n",
              "      <td>480</td>\n",
              "      <td>Monsoon Wedding</td>\n",
              "      <td>2001</td>\n",
              "      <td>Thursday</td>\n",
              "      <td>Comedy|Drama|Romance</td>\n",
              "      <td>Hindi</td>\n",
              "      <td>114.0</td>\n",
              "      <td>From an exciting Indian wedding comes a relati...</td>\n",
              "      <td>IFC Films|Mirabai Films|The Criterion Collection</td>\n",
              "      <td>18500000</td>\n",
              "      <td>33457866.5</td>\n",
              "      <td>India</td>\n",
              "      <td>Released</td>\n",
              "      <td>10.625504</td>\n",
              "      <td>6.8</td>\n",
              "      <td>59.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3641</th>\n",
              "      <td>20453</td>\n",
              "      <td>3 Idiots</td>\n",
              "      <td>2009</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>Drama|Comedy|Romance</td>\n",
              "      <td>Hindi</td>\n",
              "      <td>170.0</td>\n",
              "      <td>In the tradition of “Ferris Bueller’s Day Off”...</td>\n",
              "      <td>Vidhu Vinod Chopra Productions</td>\n",
              "      <td>9000000</td>\n",
              "      <td>70000000.0</td>\n",
              "      <td>India</td>\n",
              "      <td>Released</td>\n",
              "      <td>7.675621</td>\n",
              "      <td>7.8</td>\n",
              "      <td>850.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3902</th>\n",
              "      <td>392572</td>\n",
              "      <td>Rustom</td>\n",
              "      <td>2016</td>\n",
              "      <td>Friday</td>\n",
              "      <td>Thriller|Romance</td>\n",
              "      <td>Hindi</td>\n",
              "      <td>150.0</td>\n",
              "      <td>Rustom Pavri, an honourable officer of the Ind...</td>\n",
              "      <td>KriArj Entertainment</td>\n",
              "      <td>1000000</td>\n",
              "      <td>33457866.5</td>\n",
              "      <td>India</td>\n",
              "      <td>Released</td>\n",
              "      <td>7.333139</td>\n",
              "      <td>7.3</td>\n",
              "      <td>25.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5570</th>\n",
              "      <td>19666</td>\n",
              "      <td>Lagaan: Once Upon a Time in India</td>\n",
              "      <td>2001</td>\n",
              "      <td>Friday</td>\n",
              "      <td>Adventure|Drama|Music|Romance</td>\n",
              "      <td>Hindi</td>\n",
              "      <td>224.0</td>\n",
              "      <td>Lagaan tells the tale of the Indian village Ch...</td>\n",
              "      <td>Aamir Khan Productions</td>\n",
              "      <td>5200000</td>\n",
              "      <td>8100000.0</td>\n",
              "      <td>India</td>\n",
              "      <td>Released</td>\n",
              "      <td>4.974510</td>\n",
              "      <td>7.2</td>\n",
              "      <td>125.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      tmdbId                              title  ... vote_average vote_count\n",
              "1595   26022                    My Name Is Khan  ...          7.7      237.0\n",
              "1888     480                    Monsoon Wedding  ...          6.8       59.0\n",
              "3641   20453                           3 Idiots  ...          7.8      850.0\n",
              "3902  392572                             Rustom  ...          7.3       25.0\n",
              "5570   19666  Lagaan: Once Upon a Time in India  ...          7.2      125.0\n",
              "\n",
              "[5 rows x 16 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 45
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "vooScahLoBqn",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "e8178e47-0cd2-4926-d1f0-111722126bd1"
      },
      "source": [
        "movies_metadata.info()"
      ],
      "execution_count": 46,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 9098 entries, 0 to 9097\n",
            "Data columns (total 16 columns):\n",
            " #   Column                Non-Null Count  Dtype  \n",
            "---  ------                --------------  -----  \n",
            " 0   tmdbId                9098 non-null   int64  \n",
            " 1   title                 9098 non-null   object \n",
            " 2   release_year          9098 non-null   object \n",
            " 3   release_day           9098 non-null   object \n",
            " 4   genres                9098 non-null   object \n",
            " 5   original_language     9098 non-null   object \n",
            " 6   runtime               9098 non-null   float64\n",
            " 7   content               9098 non-null   object \n",
            " 8   production_companies  9098 non-null   object \n",
            " 9   budget                9098 non-null   int64  \n",
            " 10  revenue               9098 non-null   float64\n",
            " 11  production_countries  9098 non-null   object \n",
            " 12  status                9098 non-null   object \n",
            " 13  popularity            9098 non-null   float64\n",
            " 14  vote_average          9098 non-null   float64\n",
            " 15  vote_count            9098 non-null   float64\n",
            "dtypes: float64(5), int64(2), object(9)\n",
            "memory usage: 1.1+ MB\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "fYG_JRMQVXRs"
      },
      "source": [
        "**REMOVING ROWS WITH UNKNOWN TITLE (MOVIE NAME):**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "nGYwUOd_oRST",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "9f5c0726-0935-4c6e-9faf-044140d253d6"
      },
      "source": [
        "movies_metadata[movies_metadata['title']==\"Unknown\"].tmdbId.count()"
      ],
      "execution_count": 47,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 47
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Ya9eq1cNahhu"
      },
      "source": [
        "**IMPORTING 'keywords.csv'**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "vj99kjmtapYa",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 225
        },
        "outputId": "4905a2f5-0f6d-4d39-b61d-5dc339a8c7c6"
      },
      "source": [
        "id='1F7FQDgz1mwYBq3ed3VjZEJygzPSpuBLz'\r\n",
        "downloaded = drive.CreateFile({'id':id}) \r\n",
        "downloaded.GetContentFile('keywords.csv') \r\n",
        "keywords = pd.read_csv('keywords.csv',engine='python',index_col=0)\r\n",
        "keywords.head()"
      ],
      "execution_count": 48,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>keywords</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>id</th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>862</th>\n",
              "      <td>[{'id': 931, 'name': 'jealousy'}, {'id': 4290,...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8844</th>\n",
              "      <td>[{'id': 10090, 'name': 'board game'}, {'id': 1...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15602</th>\n",
              "      <td>[{'id': 1495, 'name': 'fishing'}, {'id': 12392...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31357</th>\n",
              "      <td>[{'id': 818, 'name': 'based on novel'}, {'id':...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11862</th>\n",
              "      <td>[{'id': 1009, 'name': 'baby'}, {'id': 1599, 'n...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                keywords\n",
              "id                                                      \n",
              "862    [{'id': 931, 'name': 'jealousy'}, {'id': 4290,...\n",
              "8844   [{'id': 10090, 'name': 'board game'}, {'id': 1...\n",
              "15602  [{'id': 1495, 'name': 'fishing'}, {'id': 12392...\n",
              "31357  [{'id': 818, 'name': 'based on novel'}, {'id':...\n",
              "11862  [{'id': 1009, 'name': 'baby'}, {'id': 1599, 'n..."
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 48
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "9oX3V_qVcPod",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 195
        },
        "outputId": "8c01ba05-7383-4f78-c000-e8a8430cfd34"
      },
      "source": [
        "keywords['tmdbId']=keywords.index.copy()\r\n",
        "keywords.reset_index(drop=True,inplace=True)\r\n",
        "keywords.head()"
      ],
      "execution_count": 49,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>keywords</th>\n",
              "      <th>tmdbId</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>[{'id': 931, 'name': 'jealousy'}, {'id': 4290,...</td>\n",
              "      <td>862</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>[{'id': 10090, 'name': 'board game'}, {'id': 1...</td>\n",
              "      <td>8844</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>[{'id': 1495, 'name': 'fishing'}, {'id': 12392...</td>\n",
              "      <td>15602</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>[{'id': 818, 'name': 'based on novel'}, {'id':...</td>\n",
              "      <td>31357</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>[{'id': 1009, 'name': 'baby'}, {'id': 1599, 'n...</td>\n",
              "      <td>11862</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                            keywords  tmdbId\n",
              "0  [{'id': 931, 'name': 'jealousy'}, {'id': 4290,...     862\n",
              "1  [{'id': 10090, 'name': 'board game'}, {'id': 1...    8844\n",
              "2  [{'id': 1495, 'name': 'fishing'}, {'id': 12392...   15602\n",
              "3  [{'id': 818, 'name': 'based on novel'}, {'id':...   31357\n",
              "4  [{'id': 1009, 'name': 'baby'}, {'id': 1599, 'n...   11862"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 49
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "9LNLuMWydS1E",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 195
        },
        "outputId": "2f292d3c-939b-494b-aead-243a1ce619d5"
      },
      "source": [
        "movies_metadata = pd.merge(movies_metadata,keywords,on='tmdbId')\r\n",
        "movies_metadata['keywords'] = movies_metadata['keywords'].fillna('[]').apply(literal_eval).apply(lambda x: [i['name'] for i in x] if isinstance(x, list) else [])\r\n",
        "movies_metadata[['title','keywords']].head()"
      ],
      "execution_count": 50,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>title</th>\n",
              "      <th>keywords</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Minions</td>\n",
              "      <td>[assistant, aftercreditsstinger, duringcredits...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Big Hero 6</td>\n",
              "      <td>[brother brother relationship, hero, talent, r...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Deadpool</td>\n",
              "      <td>[anti hero, mercenary, marvel comic, superhero...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Avatar</td>\n",
              "      <td>[culture clash, future, space war, space colon...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>John Wick</td>\n",
              "      <td>[hitman, russian mafia, revenge, murder, gangs...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "        title                                           keywords\n",
              "0     Minions  [assistant, aftercreditsstinger, duringcredits...\n",
              "1  Big Hero 6  [brother brother relationship, hero, talent, r...\n",
              "2    Deadpool  [anti hero, mercenary, marvel comic, superhero...\n",
              "3      Avatar  [culture clash, future, space war, space colon...\n",
              "4   John Wick  [hitman, russian mafia, revenge, murder, gangs..."
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 50
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "kusw8etiIMet",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "d36c4200-1a8e-4df8-e128-926694733c68"
      },
      "source": [
        "movies_metadata.info()"
      ],
      "execution_count": 51,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "Int64Index: 9150 entries, 0 to 9149\n",
            "Data columns (total 17 columns):\n",
            " #   Column                Non-Null Count  Dtype  \n",
            "---  ------                --------------  -----  \n",
            " 0   tmdbId                9150 non-null   int64  \n",
            " 1   title                 9150 non-null   object \n",
            " 2   release_year          9150 non-null   object \n",
            " 3   release_day           9150 non-null   object \n",
            " 4   genres                9150 non-null   object \n",
            " 5   original_language     9150 non-null   object \n",
            " 6   runtime               9150 non-null   float64\n",
            " 7   content               9150 non-null   object \n",
            " 8   production_companies  9150 non-null   object \n",
            " 9   budget                9150 non-null   int64  \n",
            " 10  revenue               9150 non-null   float64\n",
            " 11  production_countries  9150 non-null   object \n",
            " 12  status                9150 non-null   object \n",
            " 13  popularity            9150 non-null   float64\n",
            " 14  vote_average          9150 non-null   float64\n",
            " 15  vote_count            9150 non-null   float64\n",
            " 16  keywords              9150 non-null   object \n",
            "dtypes: float64(5), int64(2), object(10)\n",
            "memory usage: 1.3+ MB\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "su95yeIx3TBF"
      },
      "source": [
        "**IMPORTING 'credits.csv'**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ohuyu2544Uvj"
      },
      "source": [
        "link3='https://drive.google.com/file/d/1zucIWQqlWHXxwyfO1lc_hleV76RbYwGa/view?usp=sharing'"
      ],
      "execution_count": 52,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "1pYGN3WZ4Ycf",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 195
        },
        "outputId": "5b94d1a8-588b-4d21-d310-91d98ae914ac"
      },
      "source": [
        "id='1zucIWQqlWHXxwyfO1lc_hleV76RbYwGa'\n",
        "downloaded = drive.CreateFile({'id':id}) \n",
        "downloaded.GetContentFile('credits.csv')  \n",
        "credits = pd.read_csv('credits.csv',engine='python')\n",
        "credits.head(5)"
      ],
      "execution_count": 53,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>cast</th>\n",
              "      <th>crew</th>\n",
              "      <th>id</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>[{'cast_id': 14, 'character': 'Woody (voice)',...</td>\n",
              "      <td>[{'credit_id': '52fe4284c3a36847f8024f49', 'de...</td>\n",
              "      <td>862</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>[{'cast_id': 1, 'character': 'Alan Parrish', '...</td>\n",
              "      <td>[{'credit_id': '52fe44bfc3a36847f80a7cd1', 'de...</td>\n",
              "      <td>8844</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>[{'cast_id': 2, 'character': 'Max Goldman', 'c...</td>\n",
              "      <td>[{'credit_id': '52fe466a9251416c75077a89', 'de...</td>\n",
              "      <td>15602</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>[{'cast_id': 1, 'character': \"Savannah 'Vannah...</td>\n",
              "      <td>[{'credit_id': '52fe44779251416c91011acb', 'de...</td>\n",
              "      <td>31357</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>[{'cast_id': 1, 'character': 'George Banks', '...</td>\n",
              "      <td>[{'credit_id': '52fe44959251416c75039ed7', 'de...</td>\n",
              "      <td>11862</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                cast  ...     id\n",
              "0  [{'cast_id': 14, 'character': 'Woody (voice)',...  ...    862\n",
              "1  [{'cast_id': 1, 'character': 'Alan Parrish', '...  ...   8844\n",
              "2  [{'cast_id': 2, 'character': 'Max Goldman', 'c...  ...  15602\n",
              "3  [{'cast_id': 1, 'character': \"Savannah 'Vannah...  ...  31357\n",
              "4  [{'cast_id': 1, 'character': 'George Banks', '...  ...  11862\n",
              "\n",
              "[5 rows x 3 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 53
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "pXcog3RXVpZl"
      },
      "source": [
        "**EXTRACTING RELEVANT INFORMATION :** The actors' names from the 'cast' column and the director's name from the crew is extracted."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "0Z9JhNJ4deAi"
      },
      "source": [
        "credits['cast'] = credits['cast'].fillna('[]').apply(literal_eval).apply(lambda x: [i['name'] for i in x] if isinstance(x, list) else [])\n",
        "credits['cast']=[try_join(l)for l in credits['cast']]"
      ],
      "execution_count": 54,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "CLmk3oyjfRkg",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 343
        },
        "outputId": "95ce0ab6-effc-4024-e5d8-2bd9ba659d80"
      },
      "source": [
        "credits.head(10)"
      ],
      "execution_count": 55,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>cast</th>\n",
              "      <th>crew</th>\n",
              "      <th>id</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Tom Hanks|Tim Allen|Don Rickles|Jim Varney|Wal...</td>\n",
              "      <td>[{'credit_id': '52fe4284c3a36847f8024f49', 'de...</td>\n",
              "      <td>862</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Robin Williams|Jonathan Hyde|Kirsten Dunst|Bra...</td>\n",
              "      <td>[{'credit_id': '52fe44bfc3a36847f80a7cd1', 'de...</td>\n",
              "      <td>8844</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Walter Matthau|Jack Lemmon|Ann-Margret|Sophia ...</td>\n",
              "      <td>[{'credit_id': '52fe466a9251416c75077a89', 'de...</td>\n",
              "      <td>15602</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Whitney Houston|Angela Bassett|Loretta Devine|...</td>\n",
              "      <td>[{'credit_id': '52fe44779251416c91011acb', 'de...</td>\n",
              "      <td>31357</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Steve Martin|Diane Keaton|Martin Short|Kimberl...</td>\n",
              "      <td>[{'credit_id': '52fe44959251416c75039ed7', 'de...</td>\n",
              "      <td>11862</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Al Pacino|Robert De Niro|Val Kilmer|Jon Voight...</td>\n",
              "      <td>[{'credit_id': '52fe4292c3a36847f802916d', 'de...</td>\n",
              "      <td>949</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Harrison Ford|Julia Ormond|Greg Kinnear|Angie ...</td>\n",
              "      <td>[{'credit_id': '52fe44959251416c75039da9', 'de...</td>\n",
              "      <td>11860</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Jonathan Taylor Thomas|Brad Renfro|Rachael Lei...</td>\n",
              "      <td>[{'credit_id': '52fe46bdc3a36847f810f797', 'de...</td>\n",
              "      <td>45325</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Jean-Claude Van Damme|Powers Boothe|Dorian Har...</td>\n",
              "      <td>[{'credit_id': '52fe44dbc3a36847f80ae0f1', 'de...</td>\n",
              "      <td>9091</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Pierce Brosnan|Sean Bean|Izabella Scorupco|Fam...</td>\n",
              "      <td>[{'credit_id': '52fe426ec3a36847f801e14b', 'de...</td>\n",
              "      <td>710</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                cast  ...     id\n",
              "0  Tom Hanks|Tim Allen|Don Rickles|Jim Varney|Wal...  ...    862\n",
              "1  Robin Williams|Jonathan Hyde|Kirsten Dunst|Bra...  ...   8844\n",
              "2  Walter Matthau|Jack Lemmon|Ann-Margret|Sophia ...  ...  15602\n",
              "3  Whitney Houston|Angela Bassett|Loretta Devine|...  ...  31357\n",
              "4  Steve Martin|Diane Keaton|Martin Short|Kimberl...  ...  11862\n",
              "5  Al Pacino|Robert De Niro|Val Kilmer|Jon Voight...  ...    949\n",
              "6  Harrison Ford|Julia Ormond|Greg Kinnear|Angie ...  ...  11860\n",
              "7  Jonathan Taylor Thomas|Brad Renfro|Rachael Lei...  ...  45325\n",
              "8  Jean-Claude Van Damme|Powers Boothe|Dorian Har...  ...   9091\n",
              "9  Pierce Brosnan|Sean Bean|Izabella Scorupco|Fam...  ...    710\n",
              "\n",
              "[10 rows x 3 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 55
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "g9mZhJc_g5ao",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 195
        },
        "outputId": "b640dfc3-3c0b-4b7d-e079-27ff20de96b5"
      },
      "source": [
        "def get_director(x):\n",
        "    for i in x:\n",
        "        if i['job'] == 'Director':\n",
        "            return i['name']\n",
        "    return 'Unknown'\n",
        "\n",
        "credits['director'] =credits['crew'].apply(literal_eval).apply(get_director)\n",
        "credits.drop('crew',axis=1,inplace=True)\n",
        "credits.head()"
      ],
      "execution_count": 56,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>cast</th>\n",
              "      <th>id</th>\n",
              "      <th>director</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Tom Hanks|Tim Allen|Don Rickles|Jim Varney|Wal...</td>\n",
              "      <td>862</td>\n",
              "      <td>John Lasseter</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Robin Williams|Jonathan Hyde|Kirsten Dunst|Bra...</td>\n",
              "      <td>8844</td>\n",
              "      <td>Joe Johnston</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Walter Matthau|Jack Lemmon|Ann-Margret|Sophia ...</td>\n",
              "      <td>15602</td>\n",
              "      <td>Howard Deutch</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Whitney Houston|Angela Bassett|Loretta Devine|...</td>\n",
              "      <td>31357</td>\n",
              "      <td>Forest Whitaker</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Steve Martin|Diane Keaton|Martin Short|Kimberl...</td>\n",
              "      <td>11862</td>\n",
              "      <td>Charles Shyer</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                cast     id         director\n",
              "0  Tom Hanks|Tim Allen|Don Rickles|Jim Varney|Wal...    862    John Lasseter\n",
              "1  Robin Williams|Jonathan Hyde|Kirsten Dunst|Bra...   8844     Joe Johnston\n",
              "2  Walter Matthau|Jack Lemmon|Ann-Margret|Sophia ...  15602    Howard Deutch\n",
              "3  Whitney Houston|Angela Bassett|Loretta Devine|...  31357  Forest Whitaker\n",
              "4  Steve Martin|Diane Keaton|Martin Short|Kimberl...  11862    Charles Shyer"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 56
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "21I75S3un5iE",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "6877e924-ce9e-42d7-9976-8b54aea2974e"
      },
      "source": [
        "credits.info()"
      ],
      "execution_count": 57,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 45476 entries, 0 to 45475\n",
            "Data columns (total 3 columns):\n",
            " #   Column    Non-Null Count  Dtype \n",
            "---  ------    --------------  ----- \n",
            " 0   cast      45476 non-null  object\n",
            " 1   id        45476 non-null  int64 \n",
            " 2   director  45476 non-null  object\n",
            "dtypes: int64(1), object(2)\n",
            "memory usage: 1.0+ MB\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "p_hxExWqWQnn"
      },
      "source": [
        "**MERGING THE DATAFRAMES 'movies_data' and 'credits' :**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "3nr-bA-YrDjZ",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 618
        },
        "outputId": "162d41c0-22bf-454a-e7f5-1cbe4bfd3847"
      },
      "source": [
        "credits.rename(columns={'id':'tmdbId'}, inplace=True)\n",
        "movies_metadata = pd.merge(movies_metadata,credits,on='tmdbId')\n",
        "movies_metadata.head()"
      ],
      "execution_count": 58,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>tmdbId</th>\n",
              "      <th>title</th>\n",
              "      <th>release_year</th>\n",
              "      <th>release_day</th>\n",
              "      <th>genres</th>\n",
              "      <th>original_language</th>\n",
              "      <th>runtime</th>\n",
              "      <th>content</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>budget</th>\n",
              "      <th>revenue</th>\n",
              "      <th>production_countries</th>\n",
              "      <th>status</th>\n",
              "      <th>popularity</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>keywords</th>\n",
              "      <th>cast</th>\n",
              "      <th>director</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>211672</td>\n",
              "      <td>Minions</td>\n",
              "      <td>2015</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>Family|Animation|Adventure|Comedy</td>\n",
              "      <td>English</td>\n",
              "      <td>91.0</td>\n",
              "      <td>Minions Stuart, Kevin and Bob are recruited by...</td>\n",
              "      <td>Universal Pictures|Illumination Entertainment</td>\n",
              "      <td>74000000</td>\n",
              "      <td>1.156731e+09</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>Released</td>\n",
              "      <td>547.488298</td>\n",
              "      <td>6.4</td>\n",
              "      <td>4729.0</td>\n",
              "      <td>[assistant, aftercreditsstinger, duringcredits...</td>\n",
              "      <td>Sandra Bullock|Jon Hamm|Michael Keaton|Allison...</td>\n",
              "      <td>Kyle Balda</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>177572</td>\n",
              "      <td>Big Hero 6</td>\n",
              "      <td>2014</td>\n",
              "      <td>Friday</td>\n",
              "      <td>Adventure|Family|Animation|Action|Comedy</td>\n",
              "      <td>English</td>\n",
              "      <td>102.0</td>\n",
              "      <td>The special bond that develops between plus-si...</td>\n",
              "      <td>Walt Disney Pictures|Walt Disney Animation Stu...</td>\n",
              "      <td>165000000</td>\n",
              "      <td>6.521054e+08</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>Released</td>\n",
              "      <td>213.849907</td>\n",
              "      <td>7.8</td>\n",
              "      <td>6289.0</td>\n",
              "      <td>[brother brother relationship, hero, talent, r...</td>\n",
              "      <td>Scott Adsit|Ryan Potter|Daniel Henney|T.J. Mil...</td>\n",
              "      <td>Chris Williams</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>293660</td>\n",
              "      <td>Deadpool</td>\n",
              "      <td>2016</td>\n",
              "      <td>Tuesday</td>\n",
              "      <td>Action|Adventure|Comedy</td>\n",
              "      <td>English</td>\n",
              "      <td>108.0</td>\n",
              "      <td>Deadpool tells the origin story of former Spec...</td>\n",
              "      <td>Twentieth Century Fox Film Corporation|Marvel ...</td>\n",
              "      <td>58000000</td>\n",
              "      <td>7.831130e+08</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>Released</td>\n",
              "      <td>187.860492</td>\n",
              "      <td>7.4</td>\n",
              "      <td>11444.0</td>\n",
              "      <td>[anti hero, mercenary, marvel comic, superhero...</td>\n",
              "      <td>Ryan Reynolds|Morena Baccarin|Ed Skrein|T.J. M...</td>\n",
              "      <td>Tim Miller</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>19995</td>\n",
              "      <td>Avatar</td>\n",
              "      <td>2009</td>\n",
              "      <td>Thursday</td>\n",
              "      <td>Action|Adventure|Fantasy|Science Fiction</td>\n",
              "      <td>English</td>\n",
              "      <td>162.0</td>\n",
              "      <td>In the 22nd century, a paraplegic Marine is di...</td>\n",
              "      <td>Ingenious Film Partners|Twentieth Century Fox ...</td>\n",
              "      <td>237000000</td>\n",
              "      <td>2.787965e+09</td>\n",
              "      <td>United States of America|United Kingdom</td>\n",
              "      <td>Released</td>\n",
              "      <td>185.070892</td>\n",
              "      <td>7.2</td>\n",
              "      <td>12114.0</td>\n",
              "      <td>[culture clash, future, space war, space colon...</td>\n",
              "      <td>Sam Worthington|Zoe Saldana|Sigourney Weaver|S...</td>\n",
              "      <td>James Cameron</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>245891</td>\n",
              "      <td>John Wick</td>\n",
              "      <td>2014</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>Action|Thriller</td>\n",
              "      <td>English</td>\n",
              "      <td>101.0</td>\n",
              "      <td>Ex-lunatic John Wick comes off his meds to tra...</td>\n",
              "      <td>Summit Entertainment|Warner Bros.|87Eleven|Def...</td>\n",
              "      <td>20000000</td>\n",
              "      <td>8.876166e+07</td>\n",
              "      <td>Canada|China|United States of America</td>\n",
              "      <td>Released</td>\n",
              "      <td>183.870374</td>\n",
              "      <td>7.0</td>\n",
              "      <td>5499.0</td>\n",
              "      <td>[hitman, russian mafia, revenge, murder, gangs...</td>\n",
              "      <td>Keanu Reeves|Michael Nyqvist|Alfie Allen|Adria...</td>\n",
              "      <td>Chad Stahelski</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   tmdbId  ...        director\n",
              "0  211672  ...      Kyle Balda\n",
              "1  177572  ...  Chris Williams\n",
              "2  293660  ...      Tim Miller\n",
              "3   19995  ...   James Cameron\n",
              "4  245891  ...  Chad Stahelski\n",
              "\n",
              "[5 rows x 19 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 58
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "91gqXWLmrjl_",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "abee0e2e-3769-4d92-f0b1-281ac9a8af23"
      },
      "source": [
        "movies_metadata.info()"
      ],
      "execution_count": 59,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "Int64Index: 9218 entries, 0 to 9217\n",
            "Data columns (total 19 columns):\n",
            " #   Column                Non-Null Count  Dtype  \n",
            "---  ------                --------------  -----  \n",
            " 0   tmdbId                9218 non-null   int64  \n",
            " 1   title                 9218 non-null   object \n",
            " 2   release_year          9218 non-null   object \n",
            " 3   release_day           9218 non-null   object \n",
            " 4   genres                9218 non-null   object \n",
            " 5   original_language     9218 non-null   object \n",
            " 6   runtime               9218 non-null   float64\n",
            " 7   content               9218 non-null   object \n",
            " 8   production_companies  9218 non-null   object \n",
            " 9   budget                9218 non-null   int64  \n",
            " 10  revenue               9218 non-null   float64\n",
            " 11  production_countries  9218 non-null   object \n",
            " 12  status                9218 non-null   object \n",
            " 13  popularity            9218 non-null   float64\n",
            " 14  vote_average          9218 non-null   float64\n",
            " 15  vote_count            9218 non-null   float64\n",
            " 16  keywords              9218 non-null   object \n",
            " 17  cast                  9218 non-null   object \n",
            " 18  director              9218 non-null   object \n",
            "dtypes: float64(5), int64(2), object(12)\n",
            "memory usage: 1.4+ MB\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "pqyZBopHs3sw"
      },
      "source": [
        "**Top 5 Hrithik Roshan Movies Based on Popularity, vote counts and vote average:**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "rkfcfsbHr1vA",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 198
        },
        "outputId": "4c87e127-9523-4514-e594-ec2028439372"
      },
      "source": [
        "HRmovie = movies_metadata['cast'].str.contains('Hrithik Roshan')\n",
        "movies_metadata[HRmovie].head()\t"
      ],
      "execution_count": 60,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>tmdbId</th>\n",
              "      <th>title</th>\n",
              "      <th>release_year</th>\n",
              "      <th>release_day</th>\n",
              "      <th>genres</th>\n",
              "      <th>original_language</th>\n",
              "      <th>runtime</th>\n",
              "      <th>content</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>budget</th>\n",
              "      <th>revenue</th>\n",
              "      <th>production_countries</th>\n",
              "      <th>status</th>\n",
              "      <th>popularity</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>keywords</th>\n",
              "      <th>cast</th>\n",
              "      <th>director</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>8072</th>\n",
              "      <td>402672</td>\n",
              "      <td>Mohenjo Daro</td>\n",
              "      <td>2016</td>\n",
              "      <td>Thursday</td>\n",
              "      <td>Adventure|Drama|History|Romance</td>\n",
              "      <td>Hindi</td>\n",
              "      <td>155.0</td>\n",
              "      <td>Village lad Sarman is drawn to big, bad Mohenj...</td>\n",
              "      <td>UTV Motion Pictures|Ashutosh Gowariker Product...</td>\n",
              "      <td>15050000</td>\n",
              "      <td>16180000.0</td>\n",
              "      <td>India</td>\n",
              "      <td>Released</td>\n",
              "      <td>1.423358</td>\n",
              "      <td>6.7</td>\n",
              "      <td>26.0</td>\n",
              "      <td>[bollywood]</td>\n",
              "      <td>Hrithik Roshan|Pooja Hegde|Kabir Bedi|Arunoday...</td>\n",
              "      <td>Ashutosh Gowariker</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      tmdbId  ...            director\n",
              "8072  402672  ...  Ashutosh Gowariker\n",
              "\n",
              "[1 rows x 19 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 60
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "VAuPsOMqJerz"
      },
      "source": [
        "**IMPORTING Ratings.csv**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "nu0nHVw6Zn6h"
      },
      "source": [
        "link4='https://drive.google.com/file/d/1_uqqe2d-H8_NG8en8z5ehF27ajv7N9aq/view?usp=sharing'"
      ],
      "execution_count": 61,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "59io6ol5Z7TT",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 195
        },
        "outputId": "19b889d7-2b45-4e31-e302-1756f9b55090"
      },
      "source": [
        "id=\"1_uqqe2d-H8_NG8en8z5ehF27ajv7N9aq\"\n",
        "downloaded = drive.CreateFile({'id':id}) \n",
        "downloaded.GetContentFile('ratings.csv')  \n",
        "ratings = pd.read_csv('ratings.csv',engine='python')\n",
        "ratings.head(5)"
      ],
      "execution_count": 62,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>userId</th>\n",
              "      <th>movieId</th>\n",
              "      <th>rating</th>\n",
              "      <th>timestamp</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>31</td>\n",
              "      <td>2.5</td>\n",
              "      <td>1260759144</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>1029</td>\n",
              "      <td>3.0</td>\n",
              "      <td>1260759179</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1</td>\n",
              "      <td>1061</td>\n",
              "      <td>3.0</td>\n",
              "      <td>1260759182</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1</td>\n",
              "      <td>1129</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1260759185</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1</td>\n",
              "      <td>1172</td>\n",
              "      <td>4.0</td>\n",
              "      <td>1260759205</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   userId  movieId  rating   timestamp\n",
              "0       1       31     2.5  1260759144\n",
              "1       1     1029     3.0  1260759179\n",
              "2       1     1061     3.0  1260759182\n",
              "3       1     1129     2.0  1260759185\n",
              "4       1     1172     4.0  1260759205"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 62
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "bksbv_lD7QsW"
      },
      "source": [
        "#ratings.groupby('movieId').count()"
      ],
      "execution_count": 63,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Vn1lP5H7JmLF"
      },
      "source": [
        "The **'timestamp'** column seems irrelevant. So it is dropped"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "jT4CB7jzbTyE",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 195
        },
        "outputId": "174c8985-be38-403e-b671-e0b9a30bdd0d"
      },
      "source": [
        "ratings.drop('timestamp',axis=1,inplace=True)\n",
        "ratings.head()"
      ],
      "execution_count": 64,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>userId</th>\n",
              "      <th>movieId</th>\n",
              "      <th>rating</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>31</td>\n",
              "      <td>2.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>1029</td>\n",
              "      <td>3.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1</td>\n",
              "      <td>1061</td>\n",
              "      <td>3.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1</td>\n",
              "      <td>1129</td>\n",
              "      <td>2.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1</td>\n",
              "      <td>1172</td>\n",
              "      <td>4.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   userId  movieId  rating\n",
              "0       1       31     2.5\n",
              "1       1     1029     3.0\n",
              "2       1     1061     3.0\n",
              "3       1     1129     2.0\n",
              "4       1     1172     4.0"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 64
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "LwKNHlex9B21",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 195
        },
        "outputId": "4d2a8fe4-0a3e-4190-e341-22acb739a1f5"
      },
      "source": [
        "ratings = pd.merge(ratings,links,on='movieId')\r\n",
        "ratings.drop(columns=['movieId','imdbId'],inplace=True)\r\n",
        "ratings.head()"
      ],
      "execution_count": 65,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>userId</th>\n",
              "      <th>rating</th>\n",
              "      <th>tmdbId</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>2.5</td>\n",
              "      <td>9909</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>7</td>\n",
              "      <td>3.0</td>\n",
              "      <td>9909</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>31</td>\n",
              "      <td>4.0</td>\n",
              "      <td>9909</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>32</td>\n",
              "      <td>4.0</td>\n",
              "      <td>9909</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>36</td>\n",
              "      <td>3.0</td>\n",
              "      <td>9909</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   userId  rating  tmdbId\n",
              "0       1     2.5    9909\n",
              "1       7     3.0    9909\n",
              "2      31     4.0    9909\n",
              "3      32     4.0    9909\n",
              "4      36     3.0    9909"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 65
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "pbney6_NNS5P",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "feddcc36-a452-45c1-cce9-ee236e5b68ff"
      },
      "source": [
        "ratings.shape"
      ],
      "execution_count": 66,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(100004, 3)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 66
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "eN_haZc1JhHR",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "458e7312-7bf8-4af2-fa03-cd05a42d0bf0"
      },
      "source": [
        "for id in ratings['tmdbId'].unique().tolist():\r\n",
        "  if id not in movies_metadata['tmdbId'].values:\r\n",
        "    ratings=ratings[ratings.tmdbId!=id]\r\n",
        "ratings.shape "
      ],
      "execution_count": 67,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(99805, 3)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 67
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "FA0Km8zCXu99"
      },
      "source": [
        "**Let's find out the number of ratings each movie of our movies data recieved**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "SVTHA9EUUBUr",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 195
        },
        "outputId": "41915fc1-9e46-41bf-cbbb-618cc8b5490c"
      },
      "source": [
        "movies_metadata['rating_count']=pd.DataFrame(ratings.groupby('tmdbId')['rating'].count())\n",
        "movies_metadata[['title','rating_count']].head()"
      ],
      "execution_count": 68,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>title</th>\n",
              "      <th>rating_count</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Minions</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Big Hero 6</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Deadpool</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Avatar</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>John Wick</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "        title  rating_count\n",
              "0     Minions           NaN\n",
              "1  Big Hero 6           NaN\n",
              "2    Deadpool           1.0\n",
              "3      Avatar           NaN\n",
              "4   John Wick           NaN"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 68
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Lvpai8-5YmIR"
      },
      "source": [
        "**Let's count the number of movies for which there is no user rating . We replace Nan values with 0**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "BS4YZ3Y-Whbk",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "38bd1787-9b5e-4319-9187-582d2d6474ad"
      },
      "source": [
        "movies_metadata['rating_count'].isna().sum()"
      ],
      "execution_count": 69,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "7095"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 69
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "pQRajhGdZCiz",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "a3bfd20a-8a75-443e-e273-7123c0414f71"
      },
      "source": [
        "movies_metadata['rating_count']=movies_metadata['rating_count'].fillna(0)\n",
        "movies_metadata[movies_metadata['rating_count']==0].tmdbId.count()"
      ],
      "execution_count": 70,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "7095"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 70
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "eTyKustGbVn4",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 534
        },
        "outputId": "c1589d06-aa1a-4f50-bd57-11ff8cc80451"
      },
      "source": [
        "movies_metadata['mean_rating']=pd.DataFrame(ratings.groupby('tmdbId')['rating'].mean())\n",
        "movies_metadata['mean_rating']=movies_metadata['mean_rating'].fillna(0)\n",
        "movies_metadata.sort_values('rating_count',axis=0,ascending=False,inplace=True)\n",
        "movies_metadata.head()"
      ],
      "execution_count": 71,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>tmdbId</th>\n",
              "      <th>title</th>\n",
              "      <th>release_year</th>\n",
              "      <th>release_day</th>\n",
              "      <th>genres</th>\n",
              "      <th>original_language</th>\n",
              "      <th>runtime</th>\n",
              "      <th>content</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>budget</th>\n",
              "      <th>revenue</th>\n",
              "      <th>production_countries</th>\n",
              "      <th>status</th>\n",
              "      <th>popularity</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>keywords</th>\n",
              "      <th>cast</th>\n",
              "      <th>director</th>\n",
              "      <th>rating_count</th>\n",
              "      <th>mean_rating</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>119450</td>\n",
              "      <td>Dawn of the Planet of the Apes</td>\n",
              "      <td>2014</td>\n",
              "      <td>Thursday</td>\n",
              "      <td>Science Fiction|Action|Drama|Thriller</td>\n",
              "      <td>English</td>\n",
              "      <td>130.0</td>\n",
              "      <td>A group of scientists in San Francisco struggl...</td>\n",
              "      <td>Ingenious Media|Chernin Entertainment|TSG Ente...</td>\n",
              "      <td>170000000</td>\n",
              "      <td>7.106446e+08</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>Released</td>\n",
              "      <td>75.385211</td>\n",
              "      <td>7.3</td>\n",
              "      <td>4511.0</td>\n",
              "      <td>[leader, colony, post-apocalyptic, dystopia, f...</td>\n",
              "      <td>Andy Serkis|Jason Clarke|Gary Oldman|Keri Russ...</td>\n",
              "      <td>Matt Reeves</td>\n",
              "      <td>341.0</td>\n",
              "      <td>4.054252</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>680</th>\n",
              "      <td>2124</td>\n",
              "      <td>Color of Night</td>\n",
              "      <td>1994</td>\n",
              "      <td>Friday</td>\n",
              "      <td>Drama|Mystery|Romance|Thriller</td>\n",
              "      <td>English</td>\n",
              "      <td>121.0</td>\n",
              "      <td>When New York psychiatrist Bill Capa visits Lo...</td>\n",
              "      <td>Hollywood Pictures|Cinergi Pictures Entertainment</td>\n",
              "      <td>40000000</td>\n",
              "      <td>1.972605e+07</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>Released</td>\n",
              "      <td>14.228963</td>\n",
              "      <td>5.4</td>\n",
              "      <td>117.0</td>\n",
              "      <td>[suicide, california, sex, secret identity, er...</td>\n",
              "      <td>Bruce Willis|Jane March|Rubén Blades|Lesley An...</td>\n",
              "      <td>Richard Rush</td>\n",
              "      <td>324.0</td>\n",
              "      <td>4.256173</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>278</th>\n",
              "      <td>75656</td>\n",
              "      <td>Now You See Me</td>\n",
              "      <td>2013</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>Thriller|Crime</td>\n",
              "      <td>English</td>\n",
              "      <td>115.0</td>\n",
              "      <td>An FBI agent and an Interpol detective track a...</td>\n",
              "      <td>Summit Entertainment|K/O Paper Products|SOIXAN...</td>\n",
              "      <td>75000000</td>\n",
              "      <td>1.176989e+08</td>\n",
              "      <td>United States of America|France</td>\n",
              "      <td>Released</td>\n",
              "      <td>17.852022</td>\n",
              "      <td>7.3</td>\n",
              "      <td>5635.0</td>\n",
              "      <td>[paris, bank, secret, fbi, vault, magic, new o...</td>\n",
              "      <td>Jesse Eisenberg|Mark Ruffalo|Woody Harrelson|M...</td>\n",
              "      <td>Louis Leterrier</td>\n",
              "      <td>311.0</td>\n",
              "      <td>4.487138</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>274</th>\n",
              "      <td>567</td>\n",
              "      <td>Rear Window</td>\n",
              "      <td>1954</td>\n",
              "      <td>Sunday</td>\n",
              "      <td>Drama|Mystery|Thriller</td>\n",
              "      <td>English</td>\n",
              "      <td>112.0</td>\n",
              "      <td>Professional photographer L.B. \"Jeff\" Jeffries...</td>\n",
              "      <td>Paramount Pictures</td>\n",
              "      <td>1000000</td>\n",
              "      <td>3.676431e+07</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>Released</td>\n",
              "      <td>17.911314</td>\n",
              "      <td>8.2</td>\n",
              "      <td>1531.0</td>\n",
              "      <td>[nurse, photographer, suspicion of murder, gir...</td>\n",
              "      <td>James Stewart|Grace Kelly|Wendell Corey|Thelma...</td>\n",
              "      <td>Alfred Hitchcock</td>\n",
              "      <td>304.0</td>\n",
              "      <td>4.138158</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>24428</td>\n",
              "      <td>The Avengers</td>\n",
              "      <td>2012</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>Science Fiction|Action|Adventure</td>\n",
              "      <td>English</td>\n",
              "      <td>143.0</td>\n",
              "      <td>When an unexpected enemy emerges and threatens...</td>\n",
              "      <td>Paramount Pictures|Marvel Studios</td>\n",
              "      <td>220000000</td>\n",
              "      <td>1.519558e+09</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>Released</td>\n",
              "      <td>89.887648</td>\n",
              "      <td>7.4</td>\n",
              "      <td>12000.0</td>\n",
              "      <td>[new york, shield, marvel comic, superhero, ba...</td>\n",
              "      <td>Robert Downey Jr.|Chris Evans|Mark Ruffalo|Chr...</td>\n",
              "      <td>Joss Whedon</td>\n",
              "      <td>291.0</td>\n",
              "      <td>4.221649</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "     tmdbId                           title  ... rating_count mean_rating\n",
              "13   119450  Dawn of the Planet of the Apes  ...        341.0    4.054252\n",
              "680    2124                  Color of Night  ...        324.0    4.256173\n",
              "278   75656                  Now You See Me  ...        311.0    4.487138\n",
              "274     567                     Rear Window  ...        304.0    4.138158\n",
              "11    24428                    The Avengers  ...        291.0    4.221649\n",
              "\n",
              "[5 rows x 21 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 71
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "z9KmjXRHkO8q",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 534
        },
        "outputId": "ca1b09a2-de99-4522-ad1c-45c995e22dfd"
      },
      "source": [
        "movies_metadata=movies_metadata.reset_index(drop=True)\n",
        "movies_metadata.head()"
      ],
      "execution_count": 72,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>tmdbId</th>\n",
              "      <th>title</th>\n",
              "      <th>release_year</th>\n",
              "      <th>release_day</th>\n",
              "      <th>genres</th>\n",
              "      <th>original_language</th>\n",
              "      <th>runtime</th>\n",
              "      <th>content</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>budget</th>\n",
              "      <th>revenue</th>\n",
              "      <th>production_countries</th>\n",
              "      <th>status</th>\n",
              "      <th>popularity</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>keywords</th>\n",
              "      <th>cast</th>\n",
              "      <th>director</th>\n",
              "      <th>rating_count</th>\n",
              "      <th>mean_rating</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>119450</td>\n",
              "      <td>Dawn of the Planet of the Apes</td>\n",
              "      <td>2014</td>\n",
              "      <td>Thursday</td>\n",
              "      <td>Science Fiction|Action|Drama|Thriller</td>\n",
              "      <td>English</td>\n",
              "      <td>130.0</td>\n",
              "      <td>A group of scientists in San Francisco struggl...</td>\n",
              "      <td>Ingenious Media|Chernin Entertainment|TSG Ente...</td>\n",
              "      <td>170000000</td>\n",
              "      <td>7.106446e+08</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>Released</td>\n",
              "      <td>75.385211</td>\n",
              "      <td>7.3</td>\n",
              "      <td>4511.0</td>\n",
              "      <td>[leader, colony, post-apocalyptic, dystopia, f...</td>\n",
              "      <td>Andy Serkis|Jason Clarke|Gary Oldman|Keri Russ...</td>\n",
              "      <td>Matt Reeves</td>\n",
              "      <td>341.0</td>\n",
              "      <td>4.054252</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2124</td>\n",
              "      <td>Color of Night</td>\n",
              "      <td>1994</td>\n",
              "      <td>Friday</td>\n",
              "      <td>Drama|Mystery|Romance|Thriller</td>\n",
              "      <td>English</td>\n",
              "      <td>121.0</td>\n",
              "      <td>When New York psychiatrist Bill Capa visits Lo...</td>\n",
              "      <td>Hollywood Pictures|Cinergi Pictures Entertainment</td>\n",
              "      <td>40000000</td>\n",
              "      <td>1.972605e+07</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>Released</td>\n",
              "      <td>14.228963</td>\n",
              "      <td>5.4</td>\n",
              "      <td>117.0</td>\n",
              "      <td>[suicide, california, sex, secret identity, er...</td>\n",
              "      <td>Bruce Willis|Jane March|Rubén Blades|Lesley An...</td>\n",
              "      <td>Richard Rush</td>\n",
              "      <td>324.0</td>\n",
              "      <td>4.256173</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>75656</td>\n",
              "      <td>Now You See Me</td>\n",
              "      <td>2013</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>Thriller|Crime</td>\n",
              "      <td>English</td>\n",
              "      <td>115.0</td>\n",
              "      <td>An FBI agent and an Interpol detective track a...</td>\n",
              "      <td>Summit Entertainment|K/O Paper Products|SOIXAN...</td>\n",
              "      <td>75000000</td>\n",
              "      <td>1.176989e+08</td>\n",
              "      <td>United States of America|France</td>\n",
              "      <td>Released</td>\n",
              "      <td>17.852022</td>\n",
              "      <td>7.3</td>\n",
              "      <td>5635.0</td>\n",
              "      <td>[paris, bank, secret, fbi, vault, magic, new o...</td>\n",
              "      <td>Jesse Eisenberg|Mark Ruffalo|Woody Harrelson|M...</td>\n",
              "      <td>Louis Leterrier</td>\n",
              "      <td>311.0</td>\n",
              "      <td>4.487138</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>567</td>\n",
              "      <td>Rear Window</td>\n",
              "      <td>1954</td>\n",
              "      <td>Sunday</td>\n",
              "      <td>Drama|Mystery|Thriller</td>\n",
              "      <td>English</td>\n",
              "      <td>112.0</td>\n",
              "      <td>Professional photographer L.B. \"Jeff\" Jeffries...</td>\n",
              "      <td>Paramount Pictures</td>\n",
              "      <td>1000000</td>\n",
              "      <td>3.676431e+07</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>Released</td>\n",
              "      <td>17.911314</td>\n",
              "      <td>8.2</td>\n",
              "      <td>1531.0</td>\n",
              "      <td>[nurse, photographer, suspicion of murder, gir...</td>\n",
              "      <td>James Stewart|Grace Kelly|Wendell Corey|Thelma...</td>\n",
              "      <td>Alfred Hitchcock</td>\n",
              "      <td>304.0</td>\n",
              "      <td>4.138158</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>24428</td>\n",
              "      <td>The Avengers</td>\n",
              "      <td>2012</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>Science Fiction|Action|Adventure</td>\n",
              "      <td>English</td>\n",
              "      <td>143.0</td>\n",
              "      <td>When an unexpected enemy emerges and threatens...</td>\n",
              "      <td>Paramount Pictures|Marvel Studios</td>\n",
              "      <td>220000000</td>\n",
              "      <td>1.519558e+09</td>\n",
              "      <td>United States of America</td>\n",
              "      <td>Released</td>\n",
              "      <td>89.887648</td>\n",
              "      <td>7.4</td>\n",
              "      <td>12000.0</td>\n",
              "      <td>[new york, shield, marvel comic, superhero, ba...</td>\n",
              "      <td>Robert Downey Jr.|Chris Evans|Mark Ruffalo|Chr...</td>\n",
              "      <td>Joss Whedon</td>\n",
              "      <td>291.0</td>\n",
              "      <td>4.221649</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   tmdbId                           title  ... rating_count mean_rating\n",
              "0  119450  Dawn of the Planet of the Apes  ...        341.0    4.054252\n",
              "1    2124                  Color of Night  ...        324.0    4.256173\n",
              "2   75656                  Now You See Me  ...        311.0    4.487138\n",
              "3     567                     Rear Window  ...        304.0    4.138158\n",
              "4   24428                    The Avengers  ...        291.0    4.221649\n",
              "\n",
              "[5 rows x 21 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 72
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "H6qesCr_aPsR",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "e1464fe9-cd79-42a6-a4f6-c2beb615226d"
      },
      "source": [
        "movies_metadata.info()"
      ],
      "execution_count": 73,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 9218 entries, 0 to 9217\n",
            "Data columns (total 21 columns):\n",
            " #   Column                Non-Null Count  Dtype  \n",
            "---  ------                --------------  -----  \n",
            " 0   tmdbId                9218 non-null   int64  \n",
            " 1   title                 9218 non-null   object \n",
            " 2   release_year          9218 non-null   object \n",
            " 3   release_day           9218 non-null   object \n",
            " 4   genres                9218 non-null   object \n",
            " 5   original_language     9218 non-null   object \n",
            " 6   runtime               9218 non-null   float64\n",
            " 7   content               9218 non-null   object \n",
            " 8   production_companies  9218 non-null   object \n",
            " 9   budget                9218 non-null   int64  \n",
            " 10  revenue               9218 non-null   float64\n",
            " 11  production_countries  9218 non-null   object \n",
            " 12  status                9218 non-null   object \n",
            " 13  popularity            9218 non-null   float64\n",
            " 14  vote_average          9218 non-null   float64\n",
            " 15  vote_count            9218 non-null   float64\n",
            " 16  keywords              9218 non-null   object \n",
            " 17  cast                  9218 non-null   object \n",
            " 18  director              9218 non-null   object \n",
            " 19  rating_count          9218 non-null   float64\n",
            " 20  mean_rating           9218 non-null   float64\n",
            "dtypes: float64(7), int64(2), object(12)\n",
            "memory usage: 1.5+ MB\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "QpdWo2cRPBPY"
      },
      "source": [
        "**REMOVING DUPLICATE DATA FROM THE DATASET**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ylcVffVZNCFB"
      },
      "source": [
        "movies_metadata.duplicated(subset=['tmdbId'])\r\n",
        "movies_metadata=movies_metadata[movies_metadata.duplicated(subset=['tmdbId'])==False]"
      ],
      "execution_count": 74,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "YS93ZPvpOcJY",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "b00a465e-c695-4aae-d3e4-1100dc5a721d"
      },
      "source": [
        "movies_metadata.reset_index(inplace=True)\r\n",
        "movies_metadata.info()"
      ],
      "execution_count": 75,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 9081 entries, 0 to 9080\n",
            "Data columns (total 22 columns):\n",
            " #   Column                Non-Null Count  Dtype  \n",
            "---  ------                --------------  -----  \n",
            " 0   index                 9081 non-null   int64  \n",
            " 1   tmdbId                9081 non-null   int64  \n",
            " 2   title                 9081 non-null   object \n",
            " 3   release_year          9081 non-null   object \n",
            " 4   release_day           9081 non-null   object \n",
            " 5   genres                9081 non-null   object \n",
            " 6   original_language     9081 non-null   object \n",
            " 7   runtime               9081 non-null   float64\n",
            " 8   content               9081 non-null   object \n",
            " 9   production_companies  9081 non-null   object \n",
            " 10  budget                9081 non-null   int64  \n",
            " 11  revenue               9081 non-null   float64\n",
            " 12  production_countries  9081 non-null   object \n",
            " 13  status                9081 non-null   object \n",
            " 14  popularity            9081 non-null   float64\n",
            " 15  vote_average          9081 non-null   float64\n",
            " 16  vote_count            9081 non-null   float64\n",
            " 17  keywords              9081 non-null   object \n",
            " 18  cast                  9081 non-null   object \n",
            " 19  director              9081 non-null   object \n",
            " 20  rating_count          9081 non-null   float64\n",
            " 21  mean_rating           9081 non-null   float64\n",
            "dtypes: float64(7), int64(3), object(12)\n",
            "memory usage: 1.5+ MB\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "kCuzF2uyUik6"
      },
      "source": [
        "#movies_metadata.to_csv('MoviesData.csv',index=False)\n",
        "#from google.colab import files\n",
        "#files.download(\"MoviesData.csv\")"
      ],
      "execution_count": 76,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "pCUB2NwxX7N9"
      },
      "source": [
        "#ratings.to_csv('RevisedRatings.csv',index=False)\n",
        "#files.download(\"RevisedRatings.csv\")"
      ],
      "execution_count": 77,
      "outputs": []
    }
  ]
}