(KDT)TMDB 인기영화 추천.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "(KDT) TMDB 인기영화 추천\u001c",
      "provenance": [],
      "collapsed_sections": [],
      "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/learn-programmers/programmers_kdt_II/blob/main/(KDT)TMDB%20%EC%9D%B8%EA%B8%B0%EC%98%81%ED%99%94%20%EC%B6%94%EC%B2%9C%1C.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "rBPspcq8cfC0"
      },
      "source": [
        "# 인기 영화 추천 시스템을 만들어 보자\n",
        "\n",
        "https://www.kaggle.com/tmdb/tmdb-movie-metadata\n",
        "\n",
        "이 데이터셋은 영화에 대한 정보(예산, 장르, 평점, 런닝시간, 제목, 키워드 등등)와 영화 연출팀과 배우들에 대한 별도 정보로 구성되어 있으며 일반 사용자들이 이 정보를 입력하여 구성되었다 (위키와 흡사)\n",
        "\n",
        "*   이를 바탕으로 인기 영화 추천을 만들어 보자. 넷플릭스를 보면 \"넷플릭스 인기 콘텐츠\"라는 추천 카테고리가 있는데 같은 거라 보면 된다\n",
        "*   장르를 기준으로 그 안에서 인기영화를 추천을 하도록 해보자.\n"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Txl6fsdQb9kF"
      },
      "source": [
        "## 입력 데이터 로딩\n",
        "\n",
        "*   영화 정보는 tmdb_5000_movies.csv라는 파일에 있다\n",
        "*   연출/배우에 대한 정보는 tmdb_5000_credits.csv라는 파일에 있다\n",
        "\n",
        "이 두 파일은 영화의 id 필드와 연출/배우의 movie_id 필드로 조인 가능하다.\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "y0D6ujudb98S"
      },
      "source": [
        "import pandas as pd\n",
        "import numpy as np"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "9rkuVyb3cEEA"
      },
      "source": [
        "movies = pd.read_csv(\"https://grepp-reco-test.s3.ap-northeast-2.amazonaws.com/tmdb_5000_movies.csv\")"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Q0Jk1LM5cMXP"
      },
      "source": [
        "credits = pd.read_csv(\"https://grepp-reco-test.s3.ap-northeast-2.amazonaws.com/tmdb_5000_credits.csv\")"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 652
        },
        "id": "blpvnvHPcSzq",
        "outputId": "a9098b6c-8b60-446c-c053-1053d63f78d6"
      },
      "source": [
        "movies.head()"
      ],
      "execution_count": null,
      "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>homepage</th>\n",
              "      <th>id</th>\n",
              "      <th>keywords</th>\n",
              "      <th>original_language</th>\n",
              "      <th>original_title</th>\n",
              "      <th>overview</th>\n",
              "      <th>popularity</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>production_countries</th>\n",
              "      <th>release_date</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>spoken_languages</th>\n",
              "      <th>status</th>\n",
              "      <th>tagline</th>\n",
              "      <th>title</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>genres_name</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>237000000</td>\n",
              "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...</td>\n",
              "      <td>http://www.avatarmovie.com/</td>\n",
              "      <td>19995</td>\n",
              "      <td>[{\"id\": 1463, \"name\": \"culture clash\"}, {\"id\":...</td>\n",
              "      <td>en</td>\n",
              "      <td>Avatar</td>\n",
              "      <td>In the 22nd century, a paraplegic Marine is di...</td>\n",
              "      <td>150.437577</td>\n",
              "      <td>[{\"name\": \"Ingenious Film Partners\", \"id\": 289...</td>\n",
              "      <td>[{\"iso_3166_1\": \"US\", \"name\": \"United States o...</td>\n",
              "      <td>2009-12-10</td>\n",
              "      <td>2787965087</td>\n",
              "      <td>162.0</td>\n",
              "      <td>[{\"iso_639_1\": \"en\", \"name\": \"English\"}, {\"iso...</td>\n",
              "      <td>Released</td>\n",
              "      <td>Enter the World of Pandora.</td>\n",
              "      <td>Avatar</td>\n",
              "      <td>7.2</td>\n",
              "      <td>11800</td>\n",
              "      <td>Action Adventure Fantasy Science Fiction</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>300000000</td>\n",
              "      <td>[{\"id\": 12, \"name\": \"Adventure\"}, {\"id\": 14, \"...</td>\n",
              "      <td>http://disney.go.com/disneypictures/pirates/</td>\n",
              "      <td>285</td>\n",
              "      <td>[{\"id\": 270, \"name\": \"ocean\"}, {\"id\": 726, \"na...</td>\n",
              "      <td>en</td>\n",
              "      <td>Pirates of the Caribbean: At World's End</td>\n",
              "      <td>Captain Barbossa, long believed to be dead, ha...</td>\n",
              "      <td>139.082615</td>\n",
              "      <td>[{\"name\": \"Walt Disney Pictures\", \"id\": 2}, {\"...</td>\n",
              "      <td>[{\"iso_3166_1\": \"US\", \"name\": \"United States o...</td>\n",
              "      <td>2007-05-19</td>\n",
              "      <td>961000000</td>\n",
              "      <td>169.0</td>\n",
              "      <td>[{\"iso_639_1\": \"en\", \"name\": \"English\"}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>At the end of the world, the adventure begins.</td>\n",
              "      <td>Pirates of the Caribbean: At World's End</td>\n",
              "      <td>6.9</td>\n",
              "      <td>4500</td>\n",
              "      <td>Action Adventure Fantasy</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>245000000</td>\n",
              "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...</td>\n",
              "      <td>http://www.sonypictures.com/movies/spectre/</td>\n",
              "      <td>206647</td>\n",
              "      <td>[{\"id\": 470, \"name\": \"spy\"}, {\"id\": 818, \"name...</td>\n",
              "      <td>en</td>\n",
              "      <td>Spectre</td>\n",
              "      <td>A cryptic message from Bond’s past sends him o...</td>\n",
              "      <td>107.376788</td>\n",
              "      <td>[{\"name\": \"Columbia Pictures\", \"id\": 5}, {\"nam...</td>\n",
              "      <td>[{\"iso_3166_1\": \"GB\", \"name\": \"United Kingdom\"...</td>\n",
              "      <td>2015-10-26</td>\n",
              "      <td>880674609</td>\n",
              "      <td>148.0</td>\n",
              "      <td>[{\"iso_639_1\": \"fr\", \"name\": \"Fran\\u00e7ais\"},...</td>\n",
              "      <td>Released</td>\n",
              "      <td>A Plan No One Escapes</td>\n",
              "      <td>Spectre</td>\n",
              "      <td>6.3</td>\n",
              "      <td>4466</td>\n",
              "      <td>Action Adventure Crime</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>250000000</td>\n",
              "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 80, \"nam...</td>\n",
              "      <td>http://www.thedarkknightrises.com/</td>\n",
              "      <td>49026</td>\n",
              "      <td>[{\"id\": 849, \"name\": \"dc comics\"}, {\"id\": 853,...</td>\n",
              "      <td>en</td>\n",
              "      <td>The Dark Knight Rises</td>\n",
              "      <td>Following the death of District Attorney Harve...</td>\n",
              "      <td>112.312950</td>\n",
              "      <td>[{\"name\": \"Legendary Pictures\", \"id\": 923}, {\"...</td>\n",
              "      <td>[{\"iso_3166_1\": \"US\", \"name\": \"United States o...</td>\n",
              "      <td>2012-07-16</td>\n",
              "      <td>1084939099</td>\n",
              "      <td>165.0</td>\n",
              "      <td>[{\"iso_639_1\": \"en\", \"name\": \"English\"}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>The Legend Ends</td>\n",
              "      <td>The Dark Knight Rises</td>\n",
              "      <td>7.6</td>\n",
              "      <td>9106</td>\n",
              "      <td>Action Crime Drama Thriller</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>260000000</td>\n",
              "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...</td>\n",
              "      <td>http://movies.disney.com/john-carter</td>\n",
              "      <td>49529</td>\n",
              "      <td>[{\"id\": 818, \"name\": \"based on novel\"}, {\"id\":...</td>\n",
              "      <td>en</td>\n",
              "      <td>John Carter</td>\n",
              "      <td>John Carter is a war-weary, former military ca...</td>\n",
              "      <td>43.926995</td>\n",
              "      <td>[{\"name\": \"Walt Disney Pictures\", \"id\": 2}]</td>\n",
              "      <td>[{\"iso_3166_1\": \"US\", \"name\": \"United States o...</td>\n",
              "      <td>2012-03-07</td>\n",
              "      <td>284139100</td>\n",
              "      <td>132.0</td>\n",
              "      <td>[{\"iso_639_1\": \"en\", \"name\": \"English\"}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Lost in our world, found in another.</td>\n",
              "      <td>John Carter</td>\n",
              "      <td>6.1</td>\n",
              "      <td>2124</td>\n",
              "      <td>Action Adventure Science Fiction</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      budget  ...                               genres_name\n",
              "0  237000000  ...  Action Adventure Fantasy Science Fiction\n",
              "1  300000000  ...                  Action Adventure Fantasy\n",
              "2  245000000  ...                    Action Adventure Crime\n",
              "3  250000000  ...               Action Crime Drama Thriller\n",
              "4  260000000  ...          Action Adventure Science Fiction\n",
              "\n",
              "[5 rows x 21 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "pxSppRXbccNr",
        "outputId": "ca07a4fc-3206-4b1c-9bff-9c69728f8d84"
      },
      "source": [
        "movies.shape"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(4803, 20)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "iVYfiao_salu"
      },
      "source": [
        "import json\n",
        "\n",
        "def add_genre_name(j):\n",
        "    genres = []\n",
        "    ar = json.loads(j)\n",
        "    for a in ar:\n",
        "        genres.append(a.get(\"name\"))\n",
        "    return \" \".join(sorted(genres))\n",
        "\n",
        "movies['genres_name'] = movies.apply(lambda x: add_genre_name(x.genres), axis=1)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 195
        },
        "id": "FhePVFKzvV2J",
        "outputId": "c1477acd-ccd6-44ce-e565-45c8499d15bf"
      },
      "source": [
        "movies[['genres_name']].head()   # vs. movies['genres_name'].head()"
      ],
      "execution_count": null,
      "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>genres_name</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Action Adventure Fantasy Science Fiction</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Action Adventure Fantasy</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Action Adventure Crime</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Action Crime Drama Thriller</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Action Adventure Science Fiction</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                genres_name\n",
              "0  Action Adventure Fantasy Science Fiction\n",
              "1                  Action Adventure Fantasy\n",
              "2                    Action Adventure Crime\n",
              "3               Action Crime Drama Thriller\n",
              "4          Action Adventure Science Fiction"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "UaBocamo0c7E",
        "outputId": "b00b1a9c-a832-4bca-dc6b-75eff775c041"
      },
      "source": [
        "movies['genres_name'].nunique()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "638"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "WVmQd9Gh2HKj",
        "outputId": "bf70dd22-ca6e-40ca-c4d4-55423baaaefe"
      },
      "source": [
        "movies.groupby('genres_name').size()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "genres_name\n",
              "                                            28\n",
              "Action                                      21\n",
              "Action Adventure                            15\n",
              "Action Adventure Animation                   1\n",
              "Action Adventure Animation Comedy Family     5\n",
              "                                            ..\n",
              "Science Fiction Thriller                    12\n",
              "Thriller                                    23\n",
              "War                                          2\n",
              "War Western                                  1\n",
              "Western                                     18\n",
              "Length: 638, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 195
        },
        "id": "3Q3xL6H1cP5S",
        "outputId": "035178ab-3390-49a0-96ee-fc3cf77f12b9"
      },
      "source": [
        "credits.head()"
      ],
      "execution_count": null,
      "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>movie_id</th>\n",
              "      <th>title</th>\n",
              "      <th>cast</th>\n",
              "      <th>crew</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>19995</td>\n",
              "      <td>Avatar</td>\n",
              "      <td>[{\"cast_id\": 242, \"character\": \"Jake Sully\", \"...</td>\n",
              "      <td>[{\"credit_id\": \"52fe48009251416c750aca23\", \"de...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>285</td>\n",
              "      <td>Pirates of the Caribbean: At World's End</td>\n",
              "      <td>[{\"cast_id\": 4, \"character\": \"Captain Jack Spa...</td>\n",
              "      <td>[{\"credit_id\": \"52fe4232c3a36847f800b579\", \"de...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>206647</td>\n",
              "      <td>Spectre</td>\n",
              "      <td>[{\"cast_id\": 1, \"character\": \"James Bond\", \"cr...</td>\n",
              "      <td>[{\"credit_id\": \"54805967c3a36829b5002c41\", \"de...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>49026</td>\n",
              "      <td>The Dark Knight Rises</td>\n",
              "      <td>[{\"cast_id\": 2, \"character\": \"Bruce Wayne / Ba...</td>\n",
              "      <td>[{\"credit_id\": \"52fe4781c3a36847f81398c3\", \"de...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>49529</td>\n",
              "      <td>John Carter</td>\n",
              "      <td>[{\"cast_id\": 5, \"character\": \"John Carter\", \"c...</td>\n",
              "      <td>[{\"credit_id\": \"52fe479ac3a36847f813eaa3\", \"de...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   movie_id  ...                                               crew\n",
              "0     19995  ...  [{\"credit_id\": \"52fe48009251416c750aca23\", \"de...\n",
              "1       285  ...  [{\"credit_id\": \"52fe4232c3a36847f800b579\", \"de...\n",
              "2    206647  ...  [{\"credit_id\": \"54805967c3a36829b5002c41\", \"de...\n",
              "3     49026  ...  [{\"credit_id\": \"52fe4781c3a36847f81398c3\", \"de...\n",
              "4     49529  ...  [{\"credit_id\": \"52fe479ac3a36847f813eaa3\", \"de...\n",
              "\n",
              "[5 rows x 4 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "WuHYCbQWcUMD",
        "outputId": "25bb249f-c1e1-4d98-f2d7-69d2be5bb755"
      },
      "source": [
        "credits.shape"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(4803, 4)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 12
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "kPkGeuzewnK_"
      },
      "source": [
        "### movies와 credits 데이터프레임을 조인"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "VFrDt_nuca3c"
      },
      "source": [
        "movie_credits = pd.merge(movies, credits, left_on='id', right_on='movie_id')"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 652
        },
        "id": "o6tOVyFAfGka",
        "outputId": "709e96f0-32c3-407f-fc77-ae7d133ba4aa"
      },
      "source": [
        "movie_credits.head()"
      ],
      "execution_count": null,
      "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>homepage</th>\n",
              "      <th>id</th>\n",
              "      <th>keywords</th>\n",
              "      <th>original_language</th>\n",
              "      <th>original_title</th>\n",
              "      <th>overview</th>\n",
              "      <th>popularity</th>\n",
              "      <th>production_companies</th>\n",
              "      <th>production_countries</th>\n",
              "      <th>release_date</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>spoken_languages</th>\n",
              "      <th>status</th>\n",
              "      <th>tagline</th>\n",
              "      <th>title_x</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>genres_name</th>\n",
              "      <th>movie_id</th>\n",
              "      <th>title_y</th>\n",
              "      <th>cast</th>\n",
              "      <th>crew</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>237000000</td>\n",
              "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...</td>\n",
              "      <td>http://www.avatarmovie.com/</td>\n",
              "      <td>19995</td>\n",
              "      <td>[{\"id\": 1463, \"name\": \"culture clash\"}, {\"id\":...</td>\n",
              "      <td>en</td>\n",
              "      <td>Avatar</td>\n",
              "      <td>In the 22nd century, a paraplegic Marine is di...</td>\n",
              "      <td>150.437577</td>\n",
              "      <td>[{\"name\": \"Ingenious Film Partners\", \"id\": 289...</td>\n",
              "      <td>[{\"iso_3166_1\": \"US\", \"name\": \"United States o...</td>\n",
              "      <td>2009-12-10</td>\n",
              "      <td>2787965087</td>\n",
              "      <td>162.0</td>\n",
              "      <td>[{\"iso_639_1\": \"en\", \"name\": \"English\"}, {\"iso...</td>\n",
              "      <td>Released</td>\n",
              "      <td>Enter the World of Pandora.</td>\n",
              "      <td>Avatar</td>\n",
              "      <td>7.2</td>\n",
              "      <td>11800</td>\n",
              "      <td>Action Adventure Fantasy Science Fiction</td>\n",
              "      <td>19995</td>\n",
              "      <td>Avatar</td>\n",
              "      <td>[{\"cast_id\": 242, \"character\": \"Jake Sully\", \"...</td>\n",
              "      <td>[{\"credit_id\": \"52fe48009251416c750aca23\", \"de...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>300000000</td>\n",
              "      <td>[{\"id\": 12, \"name\": \"Adventure\"}, {\"id\": 14, \"...</td>\n",
              "      <td>http://disney.go.com/disneypictures/pirates/</td>\n",
              "      <td>285</td>\n",
              "      <td>[{\"id\": 270, \"name\": \"ocean\"}, {\"id\": 726, \"na...</td>\n",
              "      <td>en</td>\n",
              "      <td>Pirates of the Caribbean: At World's End</td>\n",
              "      <td>Captain Barbossa, long believed to be dead, ha...</td>\n",
              "      <td>139.082615</td>\n",
              "      <td>[{\"name\": \"Walt Disney Pictures\", \"id\": 2}, {\"...</td>\n",
              "      <td>[{\"iso_3166_1\": \"US\", \"name\": \"United States o...</td>\n",
              "      <td>2007-05-19</td>\n",
              "      <td>961000000</td>\n",
              "      <td>169.0</td>\n",
              "      <td>[{\"iso_639_1\": \"en\", \"name\": \"English\"}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>At the end of the world, the adventure begins.</td>\n",
              "      <td>Pirates of the Caribbean: At World's End</td>\n",
              "      <td>6.9</td>\n",
              "      <td>4500</td>\n",
              "      <td>Action Adventure Fantasy</td>\n",
              "      <td>285</td>\n",
              "      <td>Pirates of the Caribbean: At World's End</td>\n",
              "      <td>[{\"cast_id\": 4, \"character\": \"Captain Jack Spa...</td>\n",
              "      <td>[{\"credit_id\": \"52fe4232c3a36847f800b579\", \"de...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>245000000</td>\n",
              "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...</td>\n",
              "      <td>http://www.sonypictures.com/movies/spectre/</td>\n",
              "      <td>206647</td>\n",
              "      <td>[{\"id\": 470, \"name\": \"spy\"}, {\"id\": 818, \"name...</td>\n",
              "      <td>en</td>\n",
              "      <td>Spectre</td>\n",
              "      <td>A cryptic message from Bond’s past sends him o...</td>\n",
              "      <td>107.376788</td>\n",
              "      <td>[{\"name\": \"Columbia Pictures\", \"id\": 5}, {\"nam...</td>\n",
              "      <td>[{\"iso_3166_1\": \"GB\", \"name\": \"United Kingdom\"...</td>\n",
              "      <td>2015-10-26</td>\n",
              "      <td>880674609</td>\n",
              "      <td>148.0</td>\n",
              "      <td>[{\"iso_639_1\": \"fr\", \"name\": \"Fran\\u00e7ais\"},...</td>\n",
              "      <td>Released</td>\n",
              "      <td>A Plan No One Escapes</td>\n",
              "      <td>Spectre</td>\n",
              "      <td>6.3</td>\n",
              "      <td>4466</td>\n",
              "      <td>Action Adventure Crime</td>\n",
              "      <td>206647</td>\n",
              "      <td>Spectre</td>\n",
              "      <td>[{\"cast_id\": 1, \"character\": \"James Bond\", \"cr...</td>\n",
              "      <td>[{\"credit_id\": \"54805967c3a36829b5002c41\", \"de...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>250000000</td>\n",
              "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 80, \"nam...</td>\n",
              "      <td>http://www.thedarkknightrises.com/</td>\n",
              "      <td>49026</td>\n",
              "      <td>[{\"id\": 849, \"name\": \"dc comics\"}, {\"id\": 853,...</td>\n",
              "      <td>en</td>\n",
              "      <td>The Dark Knight Rises</td>\n",
              "      <td>Following the death of District Attorney Harve...</td>\n",
              "      <td>112.312950</td>\n",
              "      <td>[{\"name\": \"Legendary Pictures\", \"id\": 923}, {\"...</td>\n",
              "      <td>[{\"iso_3166_1\": \"US\", \"name\": \"United States o...</td>\n",
              "      <td>2012-07-16</td>\n",
              "      <td>1084939099</td>\n",
              "      <td>165.0</td>\n",
              "      <td>[{\"iso_639_1\": \"en\", \"name\": \"English\"}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>The Legend Ends</td>\n",
              "      <td>The Dark Knight Rises</td>\n",
              "      <td>7.6</td>\n",
              "      <td>9106</td>\n",
              "      <td>Action Crime Drama Thriller</td>\n",
              "      <td>49026</td>\n",
              "      <td>The Dark Knight Rises</td>\n",
              "      <td>[{\"cast_id\": 2, \"character\": \"Bruce Wayne / Ba...</td>\n",
              "      <td>[{\"credit_id\": \"52fe4781c3a36847f81398c3\", \"de...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>260000000</td>\n",
              "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...</td>\n",
              "      <td>http://movies.disney.com/john-carter</td>\n",
              "      <td>49529</td>\n",
              "      <td>[{\"id\": 818, \"name\": \"based on novel\"}, {\"id\":...</td>\n",
              "      <td>en</td>\n",
              "      <td>John Carter</td>\n",
              "      <td>John Carter is a war-weary, former military ca...</td>\n",
              "      <td>43.926995</td>\n",
              "      <td>[{\"name\": \"Walt Disney Pictures\", \"id\": 2}]</td>\n",
              "      <td>[{\"iso_3166_1\": \"US\", \"name\": \"United States o...</td>\n",
              "      <td>2012-03-07</td>\n",
              "      <td>284139100</td>\n",
              "      <td>132.0</td>\n",
              "      <td>[{\"iso_639_1\": \"en\", \"name\": \"English\"}]</td>\n",
              "      <td>Released</td>\n",
              "      <td>Lost in our world, found in another.</td>\n",
              "      <td>John Carter</td>\n",
              "      <td>6.1</td>\n",
              "      <td>2124</td>\n",
              "      <td>Action Adventure Science Fiction</td>\n",
              "      <td>49529</td>\n",
              "      <td>John Carter</td>\n",
              "      <td>[{\"cast_id\": 5, \"character\": \"John Carter\", \"c...</td>\n",
              "      <td>[{\"credit_id\": \"52fe479ac3a36847f813eaa3\", \"de...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      budget  ...                                               crew\n",
              "0  237000000  ...  [{\"credit_id\": \"52fe48009251416c750aca23\", \"de...\n",
              "1  300000000  ...  [{\"credit_id\": \"52fe4232c3a36847f800b579\", \"de...\n",
              "2  245000000  ...  [{\"credit_id\": \"54805967c3a36829b5002c41\", \"de...\n",
              "3  250000000  ...  [{\"credit_id\": \"52fe4781c3a36847f81398c3\", \"de...\n",
              "4  260000000  ...  [{\"credit_id\": \"52fe479ac3a36847f813eaa3\", \"de...\n",
              "\n",
              "[5 rows x 25 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 652
        },
        "id": "Xn6tY6NSfKfv",
        "outputId": "06b5ee00-3d5c-464e-f7ef-cb2d9196d6c8"
      },
      "source": [
        "movie_credits = movie_credits.drop(columns=['homepage', 'title_x', 'title_y', 'status','production_countries', 'production_companies'])\n",
        "movie_credits.head()"
      ],
      "execution_count": null,
      "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>id</th>\n",
              "      <th>keywords</th>\n",
              "      <th>original_language</th>\n",
              "      <th>original_title</th>\n",
              "      <th>overview</th>\n",
              "      <th>popularity</th>\n",
              "      <th>release_date</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>spoken_languages</th>\n",
              "      <th>tagline</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>genres_name</th>\n",
              "      <th>movie_id</th>\n",
              "      <th>cast</th>\n",
              "      <th>crew</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>237000000</td>\n",
              "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...</td>\n",
              "      <td>19995</td>\n",
              "      <td>[{\"id\": 1463, \"name\": \"culture clash\"}, {\"id\":...</td>\n",
              "      <td>en</td>\n",
              "      <td>Avatar</td>\n",
              "      <td>In the 22nd century, a paraplegic Marine is di...</td>\n",
              "      <td>150.437577</td>\n",
              "      <td>2009-12-10</td>\n",
              "      <td>2787965087</td>\n",
              "      <td>162.0</td>\n",
              "      <td>[{\"iso_639_1\": \"en\", \"name\": \"English\"}, {\"iso...</td>\n",
              "      <td>Enter the World of Pandora.</td>\n",
              "      <td>7.2</td>\n",
              "      <td>11800</td>\n",
              "      <td>Action Adventure Fantasy Science Fiction</td>\n",
              "      <td>19995</td>\n",
              "      <td>[{\"cast_id\": 242, \"character\": \"Jake Sully\", \"...</td>\n",
              "      <td>[{\"credit_id\": \"52fe48009251416c750aca23\", \"de...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>300000000</td>\n",
              "      <td>[{\"id\": 12, \"name\": \"Adventure\"}, {\"id\": 14, \"...</td>\n",
              "      <td>285</td>\n",
              "      <td>[{\"id\": 270, \"name\": \"ocean\"}, {\"id\": 726, \"na...</td>\n",
              "      <td>en</td>\n",
              "      <td>Pirates of the Caribbean: At World's End</td>\n",
              "      <td>Captain Barbossa, long believed to be dead, ha...</td>\n",
              "      <td>139.082615</td>\n",
              "      <td>2007-05-19</td>\n",
              "      <td>961000000</td>\n",
              "      <td>169.0</td>\n",
              "      <td>[{\"iso_639_1\": \"en\", \"name\": \"English\"}]</td>\n",
              "      <td>At the end of the world, the adventure begins.</td>\n",
              "      <td>6.9</td>\n",
              "      <td>4500</td>\n",
              "      <td>Action Adventure Fantasy</td>\n",
              "      <td>285</td>\n",
              "      <td>[{\"cast_id\": 4, \"character\": \"Captain Jack Spa...</td>\n",
              "      <td>[{\"credit_id\": \"52fe4232c3a36847f800b579\", \"de...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>245000000</td>\n",
              "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...</td>\n",
              "      <td>206647</td>\n",
              "      <td>[{\"id\": 470, \"name\": \"spy\"}, {\"id\": 818, \"name...</td>\n",
              "      <td>en</td>\n",
              "      <td>Spectre</td>\n",
              "      <td>A cryptic message from Bond’s past sends him o...</td>\n",
              "      <td>107.376788</td>\n",
              "      <td>2015-10-26</td>\n",
              "      <td>880674609</td>\n",
              "      <td>148.0</td>\n",
              "      <td>[{\"iso_639_1\": \"fr\", \"name\": \"Fran\\u00e7ais\"},...</td>\n",
              "      <td>A Plan No One Escapes</td>\n",
              "      <td>6.3</td>\n",
              "      <td>4466</td>\n",
              "      <td>Action Adventure Crime</td>\n",
              "      <td>206647</td>\n",
              "      <td>[{\"cast_id\": 1, \"character\": \"James Bond\", \"cr...</td>\n",
              "      <td>[{\"credit_id\": \"54805967c3a36829b5002c41\", \"de...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>250000000</td>\n",
              "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 80, \"nam...</td>\n",
              "      <td>49026</td>\n",
              "      <td>[{\"id\": 849, \"name\": \"dc comics\"}, {\"id\": 853,...</td>\n",
              "      <td>en</td>\n",
              "      <td>The Dark Knight Rises</td>\n",
              "      <td>Following the death of District Attorney Harve...</td>\n",
              "      <td>112.312950</td>\n",
              "      <td>2012-07-16</td>\n",
              "      <td>1084939099</td>\n",
              "      <td>165.0</td>\n",
              "      <td>[{\"iso_639_1\": \"en\", \"name\": \"English\"}]</td>\n",
              "      <td>The Legend Ends</td>\n",
              "      <td>7.6</td>\n",
              "      <td>9106</td>\n",
              "      <td>Action Crime Drama Thriller</td>\n",
              "      <td>49026</td>\n",
              "      <td>[{\"cast_id\": 2, \"character\": \"Bruce Wayne / Ba...</td>\n",
              "      <td>[{\"credit_id\": \"52fe4781c3a36847f81398c3\", \"de...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>260000000</td>\n",
              "      <td>[{\"id\": 28, \"name\": \"Action\"}, {\"id\": 12, \"nam...</td>\n",
              "      <td>49529</td>\n",
              "      <td>[{\"id\": 818, \"name\": \"based on novel\"}, {\"id\":...</td>\n",
              "      <td>en</td>\n",
              "      <td>John Carter</td>\n",
              "      <td>John Carter is a war-weary, former military ca...</td>\n",
              "      <td>43.926995</td>\n",
              "      <td>2012-03-07</td>\n",
              "      <td>284139100</td>\n",
              "      <td>132.0</td>\n",
              "      <td>[{\"iso_639_1\": \"en\", \"name\": \"English\"}]</td>\n",
              "      <td>Lost in our world, found in another.</td>\n",
              "      <td>6.1</td>\n",
              "      <td>2124</td>\n",
              "      <td>Action Adventure Science Fiction</td>\n",
              "      <td>49529</td>\n",
              "      <td>[{\"cast_id\": 5, \"character\": \"John Carter\", \"c...</td>\n",
              "      <td>[{\"credit_id\": \"52fe479ac3a36847f813eaa3\", \"de...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      budget  ...                                               crew\n",
              "0  237000000  ...  [{\"credit_id\": \"52fe48009251416c750aca23\", \"de...\n",
              "1  300000000  ...  [{\"credit_id\": \"52fe4232c3a36847f800b579\", \"de...\n",
              "2  245000000  ...  [{\"credit_id\": \"54805967c3a36829b5002c41\", \"de...\n",
              "3  250000000  ...  [{\"credit_id\": \"52fe4781c3a36847f81398c3\", \"de...\n",
              "4  260000000  ...  [{\"credit_id\": \"52fe479ac3a36847f813eaa3\", \"de...\n",
              "\n",
              "[5 rows x 19 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "m4cvSITffXf6",
        "outputId": "b46eae69-fd9d-44e0-cb8b-d102fc2f76e5"
      },
      "source": [
        "movie_credits.info()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "Int64Index: 4803 entries, 0 to 4802\n",
            "Data columns (total 19 columns):\n",
            " #   Column             Non-Null Count  Dtype  \n",
            "---  ------             --------------  -----  \n",
            " 0   budget             4803 non-null   int64  \n",
            " 1   genres             4803 non-null   object \n",
            " 2   id                 4803 non-null   int64  \n",
            " 3   keywords           4803 non-null   object \n",
            " 4   original_language  4803 non-null   object \n",
            " 5   original_title     4803 non-null   object \n",
            " 6   overview           4800 non-null   object \n",
            " 7   popularity         4803 non-null   float64\n",
            " 8   release_date       4802 non-null   object \n",
            " 9   revenue            4803 non-null   int64  \n",
            " 10  runtime            4801 non-null   float64\n",
            " 11  spoken_languages   4803 non-null   object \n",
            " 12  tagline            3959 non-null   object \n",
            " 13  vote_average       4803 non-null   float64\n",
            " 14  vote_count         4803 non-null   int64  \n",
            " 15  genres_name        4803 non-null   object \n",
            " 16  movie_id           4803 non-null   int64  \n",
            " 17  cast               4803 non-null   object \n",
            " 18  crew               4803 non-null   object \n",
            "dtypes: float64(3), int64(5), object(11)\n",
            "memory usage: 750.5+ KB\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 284
        },
        "id": "swYB2Y4GfhB0",
        "outputId": "81dc67c1-6555-48ad-9599-73023e672804"
      },
      "source": [
        "movie_credits.describe()"
      ],
      "execution_count": null,
      "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>id</th>\n",
              "      <th>popularity</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>movie_id</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>count</th>\n",
              "      <td>4.803000e+03</td>\n",
              "      <td>4803.000000</td>\n",
              "      <td>4803.000000</td>\n",
              "      <td>4.803000e+03</td>\n",
              "      <td>4801.000000</td>\n",
              "      <td>4803.000000</td>\n",
              "      <td>4803.000000</td>\n",
              "      <td>4803.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>mean</th>\n",
              "      <td>2.904504e+07</td>\n",
              "      <td>57165.484281</td>\n",
              "      <td>21.492301</td>\n",
              "      <td>8.226064e+07</td>\n",
              "      <td>106.875859</td>\n",
              "      <td>6.092172</td>\n",
              "      <td>690.217989</td>\n",
              "      <td>57165.484281</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>std</th>\n",
              "      <td>4.072239e+07</td>\n",
              "      <td>88694.614033</td>\n",
              "      <td>31.816650</td>\n",
              "      <td>1.628571e+08</td>\n",
              "      <td>22.611935</td>\n",
              "      <td>1.194612</td>\n",
              "      <td>1234.585891</td>\n",
              "      <td>88694.614033</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>min</th>\n",
              "      <td>0.000000e+00</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000e+00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>5.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25%</th>\n",
              "      <td>7.900000e+05</td>\n",
              "      <td>9014.500000</td>\n",
              "      <td>4.668070</td>\n",
              "      <td>0.000000e+00</td>\n",
              "      <td>94.000000</td>\n",
              "      <td>5.600000</td>\n",
              "      <td>54.000000</td>\n",
              "      <td>9014.500000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50%</th>\n",
              "      <td>1.500000e+07</td>\n",
              "      <td>14629.000000</td>\n",
              "      <td>12.921594</td>\n",
              "      <td>1.917000e+07</td>\n",
              "      <td>103.000000</td>\n",
              "      <td>6.200000</td>\n",
              "      <td>235.000000</td>\n",
              "      <td>14629.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75%</th>\n",
              "      <td>4.000000e+07</td>\n",
              "      <td>58610.500000</td>\n",
              "      <td>28.313505</td>\n",
              "      <td>9.291719e+07</td>\n",
              "      <td>118.000000</td>\n",
              "      <td>6.800000</td>\n",
              "      <td>737.000000</td>\n",
              "      <td>58610.500000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>max</th>\n",
              "      <td>3.800000e+08</td>\n",
              "      <td>459488.000000</td>\n",
              "      <td>875.581305</td>\n",
              "      <td>2.787965e+09</td>\n",
              "      <td>338.000000</td>\n",
              "      <td>10.000000</td>\n",
              "      <td>13752.000000</td>\n",
              "      <td>459488.000000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "             budget             id  ...    vote_count       movie_id\n",
              "count  4.803000e+03    4803.000000  ...   4803.000000    4803.000000\n",
              "mean   2.904504e+07   57165.484281  ...    690.217989   57165.484281\n",
              "std    4.072239e+07   88694.614033  ...   1234.585891   88694.614033\n",
              "min    0.000000e+00       5.000000  ...      0.000000       5.000000\n",
              "25%    7.900000e+05    9014.500000  ...     54.000000    9014.500000\n",
              "50%    1.500000e+07   14629.000000  ...    235.000000   14629.000000\n",
              "75%    4.000000e+07   58610.500000  ...    737.000000   58610.500000\n",
              "max    3.800000e+08  459488.000000  ...  13752.000000  459488.000000\n",
              "\n",
              "[8 rows x 8 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "I9dXuX9Gkdv9"
      },
      "source": [
        "popularity = movie_credits.sort_values('popularity',ascending=False)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "nWHREhkMmRJk"
      },
      "source": [
        "import matplotlib.pyplot as plt\n",
        "import seaborn as sns"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 404
        },
        "id": "7R3NFJrIrEEd",
        "outputId": "a043049f-932b-4227-ff8b-1585825e1cb7"
      },
      "source": [
        "plt.figure(figsize=(12,6))\n",
        "ax=sns.barplot(\n",
        "    x=popularity['popularity'].head(10),\n",
        "    y=popularity['original_title'].head(10)\n",
        ")\n",
        "\n",
        "plt.title('Most Popular by Popularity', weight='bold')\n",
        "plt.xlabel('Score of Popularity', weight='bold')\n",
        "plt.ylabel('Movie Title', weight='bold')\n",
        "plt.savefig('best_popular_movies.png')"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAA8wAAAGDCAYAAAD+uZn+AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nOzdebQlVXn38e+PSWZQRAUUW1GZR1ujIAoKicYoDiAaHFAjjiAqvhqJiGNUYoyAgQAvAoJiEDUovoAREGTuhqabUSOgIkQEBWVwguf9o/aVw6Hu0MPte7v7+1nrrltn1669n6pzLounn111UlVIkiRJkqSHWm6qA5AkSZIkaToyYZYkSZIkqYcJsyRJkiRJPUyYJUmSJEnqYcIsSZIkSVIPE2ZJkiRJknqYMEuSJE2hJMclqSQHL+Jxd2rj3rQox50Okuzdzu3chRxnRhvH71mV1MuEWZIkTbokN40kJkmeM9D+nIH2mxbRXAe38Y4bp9+5A3NXkjuT/DDJrosijqXRwLUd+bkvydVJ9p3q2BbQb4EvtB/gIZ/VnaYsKknTxgpTHYAkSVrmvA34Ydt++1QG0pwHzAFmAjsA30myXVVdPbVhTVySFavqT4txyhuAbwOPB14BHJrk91V19GKMYaG0a/ZrYP+pjkXS9GWFWZIkLU6/AXZP8ugk6wK7t7aHaEtlT0lya5LfJDknyV8N7P/7JNe0Cuevk1zUqtUHAx9p3d4wwWW736yqdwPPA+4EVgJ2mWAcI1XqTyW5MMk9rc+Mtv9hy6IHjtm7L5gkuya5IsldSf6U5KdJPjqwf2Q58g+THJHkd8CBY51gkvcn+VWSXyR5X2vbvo1z/UC/v2ptPxrnms2rqv2ranfg9Nb2t22M1ZIckuQnSe5OMifJ6wbmGKlSn5LkK+2aXZPkBQN9RirYM4aOOW6U81svyXlJbm/X7FdJTkyydts/Y2DMtyW5BThreEl2e5+e2IY9p+17e1t9cH+Sx7d+K7X354GRNklLJxNmSZK0OB0PPAJ4U/tZCThusEOS1YCz6ZLpH7XtnYCzk2yUZJV2zBOBk+gStjWBjYCLgUvaUNfSLbX9+nhBJQnwDGD11nT7eHEMDXEA8BO6yutOwCnjzTmGDYDbgZOBLwNrAAclefVQvx2A5wNfafOO5gnA64EzgMcA/5LkJVV1Id01elqSZ7a+u7XfX5lIoEk2ADZuL29vv79Edz3uB/4TeCpwQpLXDB3+SmAdutUGmwKnJXnsRObtsQawCl3V+2i6f4TZC/h0T99PAv8PuLBn37HA79r2qXSfn9nAV+n+v/nv276d6D5z51XVzQsYs6QlgAmzJElanH4AXAO8FdinbZ831OfFwJPoksCdq+qVwLeAVYE3A8u3n9+09o9U1ebAiVV1Bl1iCHBpq4IePk5MnwceoEugVgBmAd+YQByDvlhVrwN2Bv4MzEyy+YSuyMOd0GL6OXAXXSIOXXI86HfAX1XVW6vqhDHGe6DF/zpg5Fq8vv3+v+33a9vvl7bf4yXMu7Wq7M10CfGv6RLxxwB7tD67VtWbgA+118P3Oc+pqr+pqr+hWxK/Kt0/Tsy3qvoR3efpWuBeYGQ5/fA1A9ijqt5cVQ+rylfVx9q5ABzePj+XAse0tvm9TpKWcN7DLEmSFrcjgUPbdt/Doma039dX1QNt+7r2+4lVdXeSt9Mtvf42QJKbgdcB5y5APOcBl9Mlp/OA/6qqP48sBx4tjqExrgWoqtuT3A48ju7+3j/0zLf8OPEcQZf8DVt36PXVVXXnOGMB/KqqRqq/I/GPLCM+AfhnYM8khwObA7NaAjqWkXuY723bp1TVXQOV6vuq6qdDcw5fs+uGtrcZiGvYmNesVa/7ktfhawZwwVhj9amq2UnmANsk2Qp4CfBHFm4lgaQlgBVmSZK0uJ1Al2jd07aH3dR+P60tlYYHl/2OJGHHV9UGwPrAu+kSrQ+3ffe33xP9/5xvVtV7qurgqjq1qv48H3GM2BQgyaOBR7e2m+nOEbolwyRZEXjaOPHs2X6/ji5RPKK9zlC/vmS8z7otLoBNBmKjqn4FnEa3VHuk+jyRqunIPcwfqqpjququ1n5T+71Kkg3b9mjXbJOe7ZHlzfe232u231uME8/INfsPuiX/I6+HrxlVNd51G+3zM1KN/xdgQ+CMqnrY/feSli5WmCVJ0mLVKpHPbdu/fTAX/YvT6ZKrjegevHQ78HLgPrp7TAF+2R7mdQuwZWsbqbb+vP1+UZLDgHOr6tQFCHUicYx4R0tKt6H7/6vL6Zabr0mX/D0qyQl0lefHjDPvL4G1gP2AF7U5F8ZyLf45wMh90F8e2H8M3f3Eu9It3z55QSeqqtuSfJ1uafX3klwAvKrtHl4av3WSM9v2NnTXaeR9uoLuHu3D20PJdmNsv2y//xZYsf1eUD8Hngx8LMlLgc9V1c+BE4FD6K4TuBxbWiZYYZYkSYtdVc2uqtmj7LuH7t7TU+kqj7vQ3fv8gqr6n9bte8B2dPcSb06X3L6v7TsFOBNYDXgX3X3FCxLjROIY8Wm6peQbtT57VOcuuq/RugV4Id39yBePM/U/0C1R3pKuMv0fCxL/gJ/TVfJfCPwK+EBVnTaw/yzgZ2373Kq6dSHnexPdPdgr0VV6bwDeWFXDCeYpwP8Cz6E735dX1f+2ffvSLY8fWab9pXHm/ChwDt0S7KcDn1qI+A8G/gd4Nt3qhccCtOXvIwn93XSVeUlLuVTVVMcgSZK0RGpV7ufRJYTHTW00Cy7JEXSJ/Zurarh6vqjnOpju/vPjq2rvyZxrUUuyJ+3p5VX1+vH6S1ryuSRbkiRpGZVkM7rlznvQPR36a1Mb0fSUZE26yv/I90kfMUZ3SUsRl2RLkiQtu55Jt3z5HmCvtgxdD/co4HN0y+7/saoumtpwJC0uLsmWJEmSJKmHFWZJkiRJknqYMEuSJEmS1MOHfkmath796EfXjBkzpjoMSZIkLeVmz559e1WtO9xuwixp2poxYwazZs2a6jAkSZK0lEvy0752l2RLkiRJktTDCrOkaevam+/g6e8/YarDkCRJ0iSbfcjrpzqEXlaYJUmSJEnqYcIsSZIkSVIPE2ZJkiRJknqYMEuSJEmS1MOEWZIkSZKkHibMkiRJkiT1MGGWJEmSJKmHCbMkSZIkST1MmCVJkiRJ6mHCLC1DklSSEwder5DkV0m+016/NMkHxxlj/SRfn+xYJUmSpKm2wlQHIGmxugfYIskqVXUfsCvwi5GdVXUacNpYA1TVLcDukxqlJEmSNA1YYZaWPd8FXty2XwN8dWRHkr2THN62j0tyaJILk9yQZPfWPiPJVW175SRfSjIvyRVJdh4Y5xtJzkjy4ySfbe3Lt3Gvase8ZzGetyRJkjRfrDBLy56TgYPaMuytgGOBHUfpux7wHGATusrz8FLsdwJVVVsm2QQ4K8nT2r5tgG2BPwDXJzkMeAywQVVtAZBk7eEJk+wD7AOw0hrrLPBJSpIkSQvLCrO0jKmqucAMuuryd8fp/q2qeqCqrgEe27P/OcCJbdzrgJ8CIwnz96vqrqr6PXAN8ETgBuDJSQ5L8kLgtz3xHVVVM6tq5gqrrjH/JyhJkiQtIibM0rLpNOBfGFiOPYo/DGxnPucYPPZ+YIWq+g2wNXAu8DbgmPkcU5IkSVpsTJilZdOxwEerat5CjnM+sBdAW4q9IXD9aJ2TPBpYrqpOBf4J2G4h55ckSZImjfcwS8ugqroZOHQRDPXvwBFJ5gF/Bvauqj8koxajNwC+lGTkH+v+cRHEIEmSJE2KVNVUxyBJvVZ73JNqk9d9dKrDkCRJ0iSbfcjrp3T+JLOrauZwu0uyJUmSJEnqYcIsSZIkSVIPE2ZJkiRJknqYMEuSJEmS1MOEWZIkSZKkHibMkiRJkiT1MGGWJEmSJKnHClMdgCSNZtPHr8OsKf5OPkmSJC27rDBLkiRJktTDhFmSJEmSpB4mzJIkSZIk9TBhliRJkiSphwmzJEmSJEk9TJglSZIkSerh10pJmrb+eOvV/OxjW051GJIkaQmy4UHzpjoELUWsMEuSJEmS1MOEWZIkSZKkHibMkiRJkiT1MGGWJEmSJKmHCbMkSZIkST1MmCVJkiRJ6mHCLEmSJElSDxNmSZIkSZJ6mDBLS4gkd0+gz/5JVl1E8+2UZPsJ9Ns7yeFt++AkByyK+SVJkqSpZsIsLV32B+YrYU6y/Ci7dgLGTZgXRpIVJnN8SZIkaWGYMEtLmFb5PTfJ15Ncl+SkdPYD1gfOSXJO6/vXSS5KcnmSU5Ks3tpvSvKZJJcDeyTZL8k1SeYmOTnJDOBtwHuSzEmyY5J1k5ya5LL2s8M4cb6l9buyHbdqaz8uyZFJLgE+O3lXSpIkSVo4VnekJdO2wObALcAFwA5VdWiS9wI7V9XtSR4N/BOwS1Xdk+QDwHuBj7Ux7qiq7QCS3AI8qar+kGTtqrozyZHA3VX1L63PV4DPV9UPk2wInAlsOkaM36iqo9uxnwDeDBzW9j0e2L6q7l9UF0SSJEla1EyYpSXTpVV1M0CSOcAM4IdDfZ4FbAZckARgJeCigf1fG9ieC5yU5FvAt0aZcxdgszYWwJojFetRbNES5bWB1ekS7BGnjJYsJ9kH2Adgg7VWHGN4SZIkaXKZMEtLpj8MbN9P/99ygO9V1WtGGeOege0XA88FXgIcmGTLnv7LAc+qqt8/ZJIHE+hhxwEvq6ork+xNd09039wPUVVHAUcBbLXBKjVaP0mSJGmyeQ+ztHT5HbBG274Y2CHJUwCSrJbkacMHJFkOeEJVnQN8AFiLriI8OBbAWcC+A8dtM04sawC3JlkR2GvBTkeSJEmaOibM0tLlKOCMJOdU1a+AvYGvJplLtxx7k55jlgdOTDIPuAI4tKruBL4NvHzkoV/AfsDM9mCwa+geCjaWDwOX0N1jfd0iODdJkiRpsUqVKx4lTU9bbbBKfeetT5nqMCRJ0hJkw4PmTXUIWgIlmV1VM4fbrTBLkiRJktTDhFmSJEmSpB4mzJIkSZIk9TBhliRJkiSphwmzJEmSJEk9TJglSZIkSephwixJkiRJUg8TZkmSJEmSeqww1QFI0mhWWm9zNjxo1lSHIUmSpGWUFWZJkiRJknqYMEuSJEmS1MOEWZIkSZKkHibMkiRJkiT1MGGWJEmSJKmHT8mWNG1dd9t17HDYDlMdhiRpEbpg3wumOgRJmjArzJIkSZIk9TBhliRJkiSphwmzJEmSJEk9TJglSZIkSephwixJkiRJUg8TZkmSJEmSepgwS5IkSZLUw4RZkiRJkqQeJsySJEmSJPUwYZaWEknuTzInydVJrkzyviSL5G88ycFJDlgUYw2MuXeSwxflmJIkSdKitMJUByBpkbmvqrYBSPIY4CvAmsBHpjQqSZIkaQllhVlaClXVbcA+wLvSWT7JIUkuSzI3yVsBkqye5PtJLk8yL8luI2MkOTDJj5L8ENh4oP3cJF9o1eyrkjyztT8qybfa+Bcn2WqsdkmSJGm6s8IsLaWq6oYkywOPAXYD7qqqZyR5BHBBkrOAnwMvr6rfJnk0cHGS04DtgFcD29D9d+JyYPbA8KtW1TZJngscC2wBfBS4oqpeluT5wAnt+NHaeyXZhy7ZZ6VHrrTIrockSZI0v0yYpWXDXwNbJdm9vV4LeCpwM/Cplvg+AGwAPBbYEfhmVd0L0JLoQV8FqKrzkqyZZG3gOcArW/vZSdZJsuYY7b2q6ijgKIDVN1y9Fv7UJUmSpAVjwiwtpZI8GbgfuA0IsG9VnTnUZ29gXeDpVfWnJDcBK09g+OFE1sRWkiRJSx3vYZaWQknWBY4EDq+qAs4E3p5kxbb/aUlWo6s039aS5Z2BJ7YhzgNelmSVJGsALxmaYs82znPolnrfBZwP7NXadwJur6rfjtEuSZIkTWtWmKWlxypJ5gArAn8Gvgz8a9t3DDADuDxJgF8BLwNOAr6dZB4wC7gOoKouT/I14Eq6CvVlQ3P9PskVba43tbaDgWOTzAXuBd4wTrskSZI0raUrPknSxCQ5FzigqmZN9lyrb7h6bf3+rSd7GknSYnTBvhdMdQiS9DBJZlfVzOF2l2RLkiRJktTDJdmS5ktV7TTVMUiSJEmLgxVmSZIkSZJ6mDBLkiRJktTDhFmSJEmSpB4mzJIkSZIk9TBhliRJkiSph0/JljRtbfKYTfy+TkmSJE0ZK8ySJEmSJPUwYZYkSZIkqYcJsyRJkiRJPUyYJUmSJEnqYcIsSZIkSVIPE2ZJkiRJknr4tVKSpq3fXX89P3ju86Y6DElaZjzvvB9MdQiSNK1YYZYkSZIkqYcJsyRJkiRJPUyYJUmSJEnqYcIsSZIkSVIPE2ZJkiRJknqYMEuSJEmS1MOEWZIkSZKkHibMkiRJkiT1MGHWtJfksUm+kuSGJLOTXJTk5ZM0105JvtO2X5rkg5MxzzgxbJJkTpIrkmw0tO9DA9szkly1kHO9MMmlSa5rc34tyYbjHHNwkgMWZl5JkiRpSWDCrGktSYBvAedV1ZOr6unAq4HHL6Lxlx9tX1WdVlWfXhTzzKeXAV+vqm2r6idD+z7Ud8CCSLIFcBjwhqrapKq2AU4CZiyqOSRJkqQlmQmzprvnA3+sqiNHGqrqp1V1GECSvZMcPrIvyXeS7NS2j0gyK8nVST460OemJJ9JcjmwR6uyXtdev2Kg31/GTvKSJJe0qu9/J3lsaz84ybFJzm0V8P1a+2pJTk9yZZKrkuw5fGJJtklycZK5Sb6Z5JFJ/hbYH3h7knOG+n8aWKVVgk9qzcsnObqd41lJVml9N0pyRqvIn59kk55r+wHgU1V17cC1Pa2qzmtjvCXJZe0cTk2yas859PZJ8l9JXt+235rkpBbT5QPHPnXwtSRJkjTdmDBrutscWNCk6sCqmglsBTwvyVYD++6oqu3oqtdHAy8Bng48bpSxfgg8q6q2BU4G/s/Avk2AvwGeCXwkyYrAC4FbqmrrqtoCOKNnzBOAD1TVVsA84CNV9V3gSODzVbXzYOeq+iBwX1VtU1V7teanAl+sqs2BO4FXtvajgH1bRf4A4N975h/v2n6jqp5RVVsD1wJvno8++wAHJdkReF+L5SfAXUm2aX3eCHxpjPklSZKkKWXCrCVKki+2auZlE+j+qlbBvIIuOdxsYN/X2u9NgBur6sdVVcCJo4z1eODMJPOA97fxRpxeVX+oqtuB24DH0iXAu7ZK9o5VddfQeawFrF1VP2hNxwPPncA5Dbuxqua07dnAjCSrA9sDpySZA/wHsN5YgyRZp1WufzRwf/IWrTo9D9hr6JwZq09V/RI4CDgHeF9V/br1PwZ4Y1sKvyfwlZ5Y9mkrA2bd9ac/TfhCSJIkSYuaCbOmu6uB7UZeVNU7gRcA67amP/PQz/HKAEmeRFdZfUGr4J4+sq+5Zz7jOAw4vKq2BN46NNYfBrbvB1aoqh+1uOcBn0hy0HzON1EPm5vuetzZKtEjP5v2HPuXa1tVd7R7mI8CVm/7jwPe1c75ozz0nJlAny2BO4D1B9pOBV4E/B0wu6ruGB6wqo6qqplVNXOtFVcc8+QlSZKkyWTCrOnubGDlJG8faBu8l/YmYJskyyV5At2yaIA16ZLiu9r9xi8aZfzr6KqyI0+jfs0o/dYCftG23zBe0EnWB+6tqhOBQxhI+gFaxfk3bckywOuAHzC+P7Ul36Oqqt8CNybZo8WSJFv3dP0scGCSwWR68NquAdza5tuLfr19kjyT7ppvCxzQ/gGDqvo9cCZwBC7HliRJ0jRnwqxprS2TfhndPcg3JrmUbvnyB1qXC4AbgWuAQ2n35FbVlXRLsa+jW/Z7wSjj/57uftvT2/Lt20YJ5WC6Jc6zgdsnEPqWwKVtSfRHgE/09HkDcEiSucA2wMcmMO5RwNyBh36NZi/gzUmupKsk7zbcoarmAe8GTkhyfZILgE15cJn0h4FL6K7ddaPM87A+SR5Bd1/4m6rqFrp7mI9NknbMScADwFnjn64kSZI0ddLlI5K0eLR7pNeqqg+P13fjNdaoo7bdbrxukqRF5HnnTWSxkyQtfZLMbg8MfogVpiIYScumJN8ENqL7ujBJkiRpWjNhlrTYVNXLpzoGSZIkaaK8h1mSJEmSpB4mzJIkSZIk9TBhliRJkiSphwmzJEmSJEk9TJglSZIkSephwixJkiRJUg+/VkrStLXGxhvzvPN+MNVhSJIkaRllhVmSJEmSpB4mzJIkSZIk9TBhliRJkiSphwmzJEmSJEk9TJglSZIkSeox7lOyk6wCfAzYFXgnsCfww6r6z0mOTdIy7rab7+Lw9317qsOQpEn3rs+9ZKpDkCT1mEiF+d+A9wBbAo8AlgfeP5lBSZIkSZI01SaSML8COGTg9Wxg48kJR5IkSZKk6WEiCfMDQAZebw3cPTnhSJIkSZI0PYx7DzNwOvDetv1l4HHAMZMWkSRJkiRJ08BEEub96SrMLwZWBI7He5glSZIkSUu5cRPmqvot8MbFEIskSZIkSdPGqAlzkrljHFdVtfUkxCNJkiRJ0rQwVoV5i8UWhSRJkiRJ08yoCXNVTeQJ2pIkSZIkLZXGTYqT3JDkbwdePy/JmZMbljR5klSSEwder5DkV0m+M5/jnJtk5ijtP0uSgbZvJVnkX8fW5ro+yZz2s/skzHF/G/uqJN9OsvYiGtevp5MkSdK0NmrCnGTNJE8EZgAzkmyYZEPgecAuiyk+aTLcA2yRZJX2elfgF4t4jjuBHQBagrneIh5/0F5VtU37+fpEDkgykSfkj7ivjb0F8GvgnQsUpSRJkrSEGavC/B7gBqCAw4Ab289HgJ9NfmjSpPou3VelAbwG+OrIjiTPTHJRkiuSXJhk49a+SpKTk1yb5JvAKg8f9i9OBl7dtl8BfGNg/NWTfD/J5UnmJdmttT8jydwkKydZLcnVSeb7WQJJjhusNI9UcpPslOT8JKcB1yT5WJL9B/p9Msm7xxn+ImCD1n+bJBe3mL+Z5JGt/S1JLktyZZJTk6za2p/Uruu8JJ+Y3/OSJEmSFrexEuYfAf+P7juY59AlGKcDJwJ7TX5o0qQ6GXh1kpWBrYBLBvZdB+xYVdsCBwGfau1vB+6tqk3p/uHo6WOM/33guUmWp0ucvzaw7/fAy6tqO2Bn4HNJUlWXAacBnwA+C5xYVVcBJJkzxlwnDSzJXmec894OeHdVPQ04Fnh9G3+5FueJox3YzuUFLUaAE4APVNVWwDy6awLwjap6RnuS/rXAm1v7F4AjqmpL4NYx5tknyawks+6+965xTkeSJEmaPGM99OurwFeTfAQ4paquWXxhSZOrquYmmUFXXf7u0O61gOOTPJVuhcWKrf25wKEDx4/11Wv3Az+kS0JXqaqbBm9pBj6V5LnAA3QV28cC/wt8DLiMLqnebyDebcaYa6+qmvWXwR+cp8+lVXVjG/OmJHck2bbNf0VV3dFzzCotYd+ALgH+XpK1gLWr6getz/HAKW17i1ZBXhtYHRh55sEOwCvb9peBz/QFWFVHAUcBbPi4p9ZYJyNJkiRNprG+h/lQugrUOsDbhv4nvKpqvKWb0nR3GvAvwE50n/MRHwfOqaqXt6T63AUc/2Tgm8DBQ+17AesCT6+qPyW5CVi57VuHLslcsbXdswDz/pm2eqRVjlca2Dc83jHA3sDj6P7e+9xXVdu0pdVn0t3DfPwY8x8HvKyqrkyyN931HWECLEmSpCXGWEuy3wVs3H73/UhLumOBj1bVvKH2tXjwIWB7D7SfB/w9QLu3eKtxxj8f+GcG7o8eGP+2lizvDDxxYN9/AB8GTmKUCuwE3MSDy8VfyoMV8j7fBF4IPIMHK8G9qupeuqr3++gS798k2bHtfh0wUm1eA7g1yYo89PaNC3jwvm5v65AkSdK0N9aTcncGrmm/paVOVd1MW2I95LN0S7L/ie6+/RFHAF9Kci3d0uTZ44xfdBXsYScB304yD5hFd880SV4P/KmqvtLuF74wyfOr6uwkc8ZZlj3oaOC/klwJnMEYVeqq+mOSc4A7q+r+8QauqivaUvTXAG8AjmyV5xuAN7ZuH6a7J/xX7fcarf3dwFeSfAD4rwmeiyRJkjRl0v0/fc+O5GzgY1V17mKNSNJi05ZsXw7sUVU/nup4hm34uKfW/9nrX6c6DEmadO/63EumOgRJWqYlmV1VM4fbx1qSvRPwmEmLSNKUSrIZ8D/A96djsixJkiRNtbGWZANs2p7k+zBVdd4kxCNpMWlPvn/yVMchSZIkTVfjJcwHtZ8+yy/iWCRJkiRJmjbGS5i/B7hUU5IkSZK0zBkvYT62qv5zsUQiSZIkSdI0MtZDvyRJkiRJWmaNWmGuKpNpSZIkSdIya7wl2ZI0ZR7z+LX8blJJkiRNGavIkiRJkiT1MGGWJEmSJKnHuAlzklWSHJJkTpIdkhya5FWLIzhJkiRJkqbKRCrM/wa8B9gSeASwPPD+yQxKkiRJkqSpNpGE+RXAIQOvZwMbT044kiRJkiRNDxNJmB8AMvB6a+DuyQlHkiRJkqTpYSJfK3U68N62/WXgccAxkxaRJDW33vgTPvna3ac6DElaIAee+PWpDkGStJAmkjDvT1dhfjGwInA83sMsSZIkSVrKjZswV9VvgTcuhlgkSZIkSZo2Rk2Yk8wFDgD+pWd3VdXWkxaVJEmSJElTbKwK8xbAI9tvSZIkSZKWKaMmzFU18gTtry2mWCRJkiRJmjbG/VqpJHOSvC/JeosjIEmSJEmSpoOJfA/zY4FDgJ8l+e8keydZfZLjkiRJkiRpSk0kYV4f2Bk4AtgE+L/A/05mUJIkSZIkTbVxE+aqKmAWcCFwaWteZTKDkiRJkiRpqk3kHuZvAb8CTqKrNH8J2GWS45KWSknunoI5L5xgv7WT3JEk7fWzk1SSx7fXayX5dZKJrEwhyYwkV42y79wkMyd6DpIkSdJUmMj/+L4QOAN4FfDYqvqHqjpncsOSlGT5RTFOVW0/wX53ArcCm7am7YEr2m+AZwGXVtUD442VZKyvrJMkSZKWCBNJmB8H7AFcA2y0qP4nXlpWJdkpyXcGXh+eZO+2fVOSzyS5HNgjyVuSXJbkyiSnJlm19dsjyVWt/bzWtnmSS289/XUAACAASURBVNuT7ecmeWprv3tgrg8kmdeO+3RPeBfyYIK8PfD5odcXJFk5yZfaOFck2bmNvXeS05KcDXx/6JxXSXJykmuTfBNv65AkSdISYCJVoPXo7l3eqL3+nyQvq6prJy8saZl2R1VtB5Bknao6um1/AngzcBhwEPA3VfWLJGu3494GfKGqTkqyEvCQf9xK8iJgN+CvqureJI/qmfsC4HnAMcCTgVOAt7Z92wOfBt5J93iDLZNsApyV5Gmtz3bAVlX16yQzBsZ9O3BvVW2aZCvg8tFOPsk+wD4Aa61qXi1JkqSpM5EK8xfpkuavtp/16P6HXdLk+NrA9hZJzk8yD9gL2Ly1XwAcl+QtPJgYXwR8KMkHgCdW1X1D4+4CfKmq7gWoql/3zH0hsH2SJwE3VdXvgbSvkns6cAnwHODENsZ1wE+BkYT5e6OM+9yBY+YCc0c7+ao6qqpmVtXM1VZ+xGjdJEmSpEk3kYR5JvCPVfXaqnot8CHgmZMblrRU+zMP/dtbeWj/PQPbxwHvqqotgY+O9K2qtwH/BDwBmN0q0V8BXgrcB3w3yfPnN7Cq+jGwNvASugQcYDbwRroEeryHlt0zzn5JkiRpiTGRhPnXwC5JnpzkycCuwB2TG5a0VPspsFmSR7Tl1C8Yo+8awK1JVqSrMAOQZKOquqSqDqJ7iv0T2t/nDVV1KPBfwFZDY30PeOPAfdB9S7IBLgbezYMJ80XA/nRVbYDzR2JpS7E3BK4f55zPA/6+HbNFT2ySJEnStDORhPkYuqrVj9vP3wFHT2ZQ0tKoPTn6D1X1c+A/gava7yvGOOzDdMugLwCuG2g/pD106yq6ZdRX0j3J/qokc4AtgBMGB6qqM4DTgFmtzwGjzHkBXeV6Vnt9Ed39zCNfT/XvwHJtmfjXgL2r6g/jnP4RwOpJrgU+Rle1liRJkqa1VNX4nZI3AX8LFHB6VR03yXFJS50kWwNHV5W3NEzQBus8st7xorEK8JI0fR144tenOgRJ0gQlmV1VM4fbJ/RdqVV1LHDsIo9KWkYkeRuwH93SZkmSJElLgFET5iT3j3FcVdWEkm1JUFVHAkdOdRySJEmSJm6spDd0S7BvAe5cPOFIkiRJkjQ9jPXQry/RfUXMo4F5wHurasuRn8USnSRJkiRJU2TUhLmq3gysB7yD7om5ZyS5KckLF1dwkiRJkiRNlTG/Vqqq7gFuAG4E/khXbV5jMcQlSZIkSdKUGjVhTnJgkh8DZwNPAfYF1quqUxZXcJIkSZIkTZVRv4c5yQN0D/26Abh2aHdV1W6THJukZdzMmTNr1qxZUx2GJEmSlnIL+j3MATZqP4P6s2xJkiRJkpYSYyXMT1psUUiSJEmSNM2MmjBX1U8XZyCSJEmSJE0nYz4lW5IkSZKkZZUJsyRJkiRJPUyYJUmSJEnqMd5TsiVpyvz+1t9x7SfPnuowpGll0wOfP9UhSJK0zLDCLEmSJElSDxNmSZIkSZJ6mDBLkiRJktTDhFmSJEmSpB4mzJIkSZIk9TBhliRJkiSphwmzJEmSJEk9TJglSZIkSeoxaQlzkvuTzElyVZJTkqyaZGaSQ+dznBlJ/n6y4mxz7Jjk6hbvKgPtayd5x8DrnZJ8ZyHnen27JvOSXJHkgPk8/qVJPti2j0uye0+fvZMcvjBxLogk67RrOCfJ/yb5xcDrpyW5aiHHf1GSWUmuadfuc4sq9oWIad0kl7R4dhzat3+SVQde370Q8+yU5K52Lecm+e8kj2n7Fvj9nkhMfX/LCzLXgswtSZIkTaXJrDDfV1XbVNUWwB+Bt1XVrKrab7hjkhXGGGcGMKkJM7AX8M8t3vsG2tcG3jHKMfMtyYuA/YG/rqotgWcBd83H8StU1WlV9elFFdOiVFV3tGu4DXAk8PmB139cmLGTbAEcDry2qjYDZgL/Mx/Hj/UZWxgvAOZV1bZVdf7Qvv2BRZJcNue367kVcBnwzkU49lge9re8MINN4nshSZIkLVKLa0n2+cBTBiu0SQ5O8uUkFwBfbpXk85Nc3n62b8d+GtixVbjek2T5JIckuaxV2t7axlsvyXkDlbAdh4NI8oJWCZyX5Ngkj0jyD8CrgI8nOWnokE8DG7UxD2ltqyf5epLrkpyUJG3spyf5QZLZSc5Msl7PdfhH4ICqugWgqv5QVUe349/SzunKJKeOVPFaFfnIJJcAn+2pJu7Sqq4/SvJ3A+1PSHJukh8n+cjANXhtkkvbOf1HkuVb+xFtnKuTfHSg/01JPtrek3lJNhntTZ6A5ZMc3eY4K62an2SjJGe0a3f+KHP8H+CTVXVdu3b3V9URA9foL5X2kcpl+7ydn+Q04JokqyU5vV3jq5Ls2fqN+961z+fZ7TP3/SQbJtkG+CywWx6+OmE/YH3gnCTnDLR/ss1/cZLHtrZ123t+WfvZYayL2D5zawC/6dn3kjxY8f7vgTlWT/Kl9h7OTfLKoeMeneSiJC8ea24e/Fterf0NXdrm2m3gOj3s73j4vRhnDkmSJGlamPSEOV016UXAvJ7dmwG7VNVrgNuAXatqO2BPYGTp9gd5sLL2eeDNwF1V9QzgGcBbkjyJrgp9Zqtmbg3MGYpjZeA4YM9W3V0BeHtVHQOcBry/qvYaiu+DwE/a3O9vbdvSVQ43A54M7JBkReAwYPeqejpwLPDJnvPdApg9yqX6RlU9o6q2Bq5t5zni8cD2VfXenuNmAM8EXgwc2c6T1vZKYCtgj3TL4Telu7Y7tOt0P111HeDAqprZ+j8vyVYDc9ze3pcjgAMA2njHjHIuo3kq8MWq2hy4s8UHcBSwb7t2BwD/3nPsWNduLNsB766qpwEvBG6pqq1btfSM+XjvDgOOb9Xdk4BDq2oOcBDwteHVCVV1KHALsHNV7dyaVwMubu/xecBbWvsX6Krxz2jXZLTrumOSOcDPgF1arMN+CDyrqrYFTqb7hwaAD9P93WzZzuHskQNaUn06cFBVnT7K3MN/ywcCZ1fVM4GdgUOSrMbof8fw0PdCkiRJmvYmc2nkKu1/7qGrSv1fYPuhPqcNJBkrAoe3qt39wGj/U/3XwFYDFcW16BKxy4BjWwL0rZbMDNoYuLGqftReH0+3pPXf5vO8Lq2qmwHa+c2gS/62AL7XFf9YHrh1PsfdIskn6JaBrw6cObDvlKq6f5Tj/rOqHgB+nOQGYKQ6+72quqPF+Q3gOcCfgacDl7U4V6FLcABelWQfus/EenT/IDC37ftG+z0beAVAVc0C/mE+z/HGgfdlNjAjyep0n4tTWkwAj5jPccdyaVXd2LbnAZ9L8hngO1V1frql3hN5755NO3fgy3SV5fn1R2DkHvjZwK5texdgs4HzXzPJ6lU1fI/v+VX1dwBJPtBiGF4e/Xjga61KvhIwcu67AK8e6VRVI9XpFYHvA++sqh+MEnff3/KFwEvz4D34KwMb0v0jwWh/x4Pvxaja53AfgPXWesx43SVJkqRJM5kJ832tivkXAwnBiHsGtt8D/JKuOrwc8PtRxg1dNfLMh+1InktXaT0uyb9W1QkLGPtY/jCwfT/dNQxwdVU9e5xjr6ZLWM/u2Xcc8LKqujLJ3sBOA/vu6ek/okZ53dceuirpPw7uaBX6A4BnVNVvkhxHlwCNGDnnkfNdUMPXbhW69/rO4c9Kj5Frd2XPvj+3cUiyHF2iOOIv166qfpRkO+BvgU8k+T7wTSb23i0Kf6qqkfdl8FouR1cVHu0z3+c04NSe9sOAf62q05LsBBw8zjh/pkve/wYYLWHu+1sO8Mqqun6o/WBG/zse63P8F1V1FN2qA7bYYOPhz7EkSZK02Eynr5VaC7i1VUtfR1fpA/gd3f2aI84E3t4qyaR7+vJqSZ4I/LLdE3wM3fLPQdfTVTSf0l6/jtEThBHDc4/memDdJM9uMa2YZPOefv9Mt3T1ca3fSunuoabNc2s7r+Gl4WPZI8lySTaiWyI+ksDsmuRR7b7alwEX0FUSd8+DT1d+VLtua9IlM3e15bkvmo/5F0pV/Ra4MckeLaYk2bqn6yHAh5I8rfVbLslIdfUmumQa4KV0VdOHSbI+cG9VndjG246Jv3cX8mCFdi+6Sut4Jvr5OQvYdyDO8f7xALoVAz/paV8L+EXbfsNA+/cYeEhYkke2zQLeBGzSqtYTdSawb0ucSbLtwPx9f8eSJEnSEmc6Jcz/DrwhyZV0y4pHqlFzgfvbg5LeQ5cMXwNcnu5riv6DrlK3E3Blkivo7p38wuDgrXr3Rrqlv/OAB+ie5DyqtqT5gnQPiDpkjH5/BHYHPtPin8PDl59TVd+le9Lzfye5GricLlmF7h7TS+gS2+vGimvIz4BLgf9H9yTykYrepXQVyLnAqe0J5dcA/wSclWQuXRK1XlVdCVzR5v1Ki2FMC3gP82j2At7crt3VwG7DHapqLt29419Nci1wFd0/EAAcTXff9ZV0S6dHq2RuCVzalhd/BPjERN87uoT2je26vQ549wTO6yi6+6TPGafffsDMdA/juobRn0I98vC7K1sM7+vpczDdZ3w2cPtA+yeAR7bP8pV09x0D3QPUgNcAz8/A16iN4+N0/zAxt32WP97aR/s7liRJkpY4eXCFqCRNL1tssHGd8o4jpjoMaVrZ9MDnT3UIkiQtdZLMbg9BfojpVGGWJEmSJGnaMGGWJEmSJKmHCbMkSZIkST1MmCVJkiRJ6mHCLEmSJElSDxNmSZIkSZJ6mDBLkiRJktTDhFmSJEmSpB4rTHUAkjSalddbg00PfP5UhyFJkqRllBVmSZIkSZJ6mDBLkiRJktTDhFmSJEmSpB4mzJIkSZIk9TBhliRJkiSph0/JljRt3XLLLRx88MFTHYa0UPwMS5K05LLCLEmSJElSDxNmSZIkSZJ6mDBLkiRJktTDhFmSJEmSpB4mzJIkSZIk9TBhliRJkiSphwmzJEmSJEk9TJglSZIkSephwixJkiRJUg8TZo0qyf1J5iS5OsmVSd6XZEo/M0nWTXJJkiuS7Di0b/8kqw68vnsh5tkpyV3t/K9N8pGB9u8s+BmMOt9DYp/gMTu292ZOklUG2tdO8o6B14sk5jbPyQs7jiRJkrSkMGHWWO6rqm2qanNgV+BFwEemOKYXAPOqatuqOn9o3/7AfCWd4zi/qrYBZgKvTbLdIhx72ILEvhfwz+09um+gfW3gHaMcs0CSbAosD+yYZLVFObYkSZI0XZkwa0Kq6jZgH+Bd6cxIcn6Sy9vP9gBJvpjkpW37m0mObdtvSvLJdty1SY5u1dGzBqujI1q/s5PMTfL9JBsm2Qb4LLBbT1V1P2B94Jwk5wy0f7JVxy9O8tjWtm6SU5Nc1n52GOfc7wFmA08ZivGZSS5q1e4Lk2zc2vdO8o0kZyT5cZLPDhzz1+2Yy5OckmT10WIfOOYFbY55SY5N8ogk/wC8Cvh4kpOGDvk0sFG7Roe0ttWTfD3JdUlOSpI29tOT/CDJ7CRnJllvlMvwGuDLwFnAbgOxnZvkC22uq5I8s7Wv1mK9tMW+W2vfvLXNae/tU8e69pIkSdJUMmHWhFXVDXRVxscAtwG7VtV2wJ7Aoa3b+cDIUukNgM3a9o7AeW37qcAXW+X6TuCVPdMdBhxfVVsBJwGHVtUc4CDga8NV1ao6FLgF2Lmqdm7NqwEXV9XWbe63tPYvAJ+vqme0uY8Z67yTrAM8C7h6aNd1wI5VtW2L61MD+7Zp12VLYM8kT0jyaOCfgF3adZsFvHeU2EfmXhk4DtizqrYEVgDeXlXHAKcB76+qvYbi+iDwk3aN3t/atqWrYm8GPBnYIcmKdNd596p6OnAs8MlRLsOewMnAV+mS50Grtkr8O9oYAAcCZ1fVM4GdgUNaZfptwBcGKvc3D0+UZJ8ks5LMuvfee0cJR5IkSZp8K0x1AFpirQgc3qq+9wNPa+3nA/sn2Qy4Bnhkq1o+G9gPWAe4sSW/0FVuZ/SM/2zgFW37y3SV5fn1R2Dk3t3ZdMvKAXYBNmtFVoA1k6xeVcP3PO+Y5ArgAeDTVXV1kp0G9q8FHN+qpEV3TUZ8v6ruAkhyDfBEuqXSmwEXtLlXAi4a5xw2prteP2qvjwfeCfzbOMcNu7Sqbm7xzKG75ncCWwDfa/EsD9w6fGCSmcDtVfWzJL8Ajk3yqKr6devyVYCqOi/JmknWBv4aeGmSA1qflYEN2/kemOTxwDeq6sfD81XVUcBRAOuvv37N53lKkiRJi4wJsyYsyZPpkuPb6O5l/iWwNd1Khd8DVNUvWsL0Qrqq7qPolg7fXVW/a9XaPwwMez/wsCXZi8ifqmok4bqfBz/vywHPqqrfj3P8+VX1d2Ps/zhwTlW9PMkM4NyBfcPnuAIQ4HtVNVyhXRxGi+fqqnr2OMe+BtgkyU3t9Zp0lfmj2+vhpLba2K+squuH9l2b5BLgxcB3k7y1qs6erzORJEmSFhOXZGtCkqwLHAkc3pLQtYBbq+oB4HV01ckRF9Mt/z2PruJ8QPs9Py4EXt2295rg8b8D1phAv7OAfUdetCr5glgL+EXb3nsC/S+mWwr9lDbvaklGKvOjxX49MGPkGLpr/YNx5pnodbgeWDfJs1s8KybZfLBDuqeivwrYsqpmVNUMunuYB5P+PVvf5wB3tcr6mcC+A/dKb9t+Pxm4oS1D/y9gqwnEKUmSJE0JE2aNZZX2cKargf+mSzQ/2vb9O/CGJFcCmwD3DBx3PrBCVf0PcDldlXl+E+Z9gTcmmUuXJL57AsccBZzR9+CsIfsBM9tDp66hu692QXwW+Oe2bHvc1RpV9Su6xPqr7bwuort2o8bequBvBE5JMo9uefiR48xzB92y76sGHvrV1++PwO7AZ9r7OAfYfqjbjsAvquqWgbbz6Ja0jzwg7PftGhwJvLm1fZxuifrc9vn5eGt/FXBVWxa+BXDCWOciSZIkTaU8uGJVkuZPknOBA6pq1mSMv/7669c+++wzGUNLi83BBx881SFIkqRxJJldVTOH260wS5IkSZLUw4d+SVpgVbXTVMcgSZIkTRYrzJIkSZIk9TBhliRJkiSphwmzJEmSJEk9TJglSZIkSephwixJkiRJUg+/h1nStDVz5syaNWtSvuJZkiRJ+gu/h1mSJEmSpPlgwixJkiRJUg8TZkmSJEmSepgwS5IkSZLUw4RZkiRJkqQeJsySJEmSJPVYYaoDkKTR/OY31/KfpzxzqsPQUuZVe1w61SFIkqQlhBVmSZIkSZJ6mDBLkiRJktTDhFmS/n979x6lSVXee/z7YwbEgQgoHmK8ZOQiOGAYcOCoSETkBFQiRAfUkAgccjAalCCciJyjYqLiBcV4ARdeUVEU1HCJR0AuEVC5M1xmYIWAclFAEEZAAYHn/FG75aWp7ume6Zm3x/l+1urVVbt27Xqquqamn9571ytJkiT1MGGWJEmSJKmHCbMkSZIkST1MmCVJkiRJ6mHCLEmSJElSDxNmSZIkSZJ6mDCvQEmeluSK9nVbklvb8j1JFi5Du/sk+fSosnOTzFv2qKdGkl2SXJTk2nbO30zynGHHNSLJ7CSV5P0DZesn+d3oazuJ9q7uKZ+X5JPLEOc/J9lpafef4DF+muSqJFcmOSPJH09i39lJ/nqc7d9v9/tpUxOtJEmStPyYMK9AVXVXVc2tqrnAZ4Gj2vJc4NHhRjd1kswctb4F8Clg76rarJ3z8cDsIYQ3nhuBVw+s7wFcM5UHqKpLqurty7D/e6rqB1MZ0xheXlV/BlwCHDaRHdrPfTYwZsIMfBT422WOTpIkSVoBTJinjxlJPpfkmtar92SAJBu1XrlLk5yXZLPJNpzkvoHl+Um+3Ja/nOSTSX6U5IYk81v5akmObr3BZyb53sC2Fyb5jxbP6Ume0crPTfKJJJcAB44K4Z3AB6tq0UhBVZ1SVT9s+/6vJBcnWZDk20lmDcR3TJKftPh2SPLFJItGzqHV+4skP05yWZITk6zdyj+UZGHrKT1yApfqN8CigZ751wPfGjjO7CRnt/bOGukhT7JBku+2+Bckecmo679hksuTbNPO4bRWfng7n3Pb+b19YJ93J7kuyflJvpHkkIFrMvKzeE+7blcnOTadjZJcNtDOJoPrS+GHwMZJtm3X+PJ2v2za2t8nySlJzgbOAj4EbJ9uFMFBoxurqrOAe5chHkmSJGmFMWGePjYBPlNVmwP3AK9r5ccCb6uqFwKHAEePsf/r89hw7yuAiQ7HfgbwUmBXumQH4LV0PYVz6HoDXwyQZHW6nuL5LZ4vAh8YaGuNqppXVR8bdYzNgfGStu9U1TZVtSWwCNhvYNt67fgHAacAR7X2XpBkbpL1gf8L7FRVW9P1iL4jydOAvwI2bz2l72/n8Jok/zxOLCcAb0jybOAR4OcD2z4FHNfaOx4YGVr9SeA/WvxbM9Ar3RLLbwP7VNXFPcfbDNgZ2BZ4b5LVk2xD9/PfEnglY/8sP92u2xbAk4Fdq+q/gMVJ5rY6+wJfGud8l2RX4CrgWmD7qtoKeA/wwYE6W9PdEy8DDgXOayMpjlqG40qSJElDN3PJVbSC3FhVV7TlS4HZraf0JcCJSUbqPWmM/b9ZVQeMrCQ5d4LH/beqehRYmGSDVvZS4MRWfluSc1r5psAWwJktnhnALwZjWNLBWiJ7FjALOLaqjgS2SDd3eF1gbeD0gV1OrapKchVwe1Vd1dq5hi6pfxZdYn9Bi2kN4MfAYuAB4AutR/c06Hq26RLvsXwf+Bfg9p7zeTHdHxMAvgp8pC3vCLyptf8IXcK6HvB04GTgtVU11hz1f6+qB4EHk9wBbABsB5xcVQ8ADyQ5dYx9X57kn+iu5VPpEvVTgc8D+yZ5B10v+bbjnO9YzknyCHAl3R8k1gGOS7IJUMDqA3XPrKpfLcUxeiXZH9gfYP3115iqZiVJkqRJM2GePh4cWH6ErsdwNeCeNud3WdTA8prjHDeML8A1VfXiMbbfP0b5NXS9kAuq6i5gbhtivHbb/mVg96pakGQfYIee+B4dFeujdPfvI3QJ2xufEGyyLfAKYD5wAF1iO66qeijJpcDBdIn4a5a0zzgWAzfR/QFirIR59M99Qv8mk6xJN9pgXlXdnORwHvvZfht4L3A2cGm75oP7PpsusQb4bFV9tucQL6+qOwf2+QRwTlX9VZLZwLkDdcf6uS+VqjqWbmQFG220Vi2huiRJkrTcOCR7GquqXwM3JtkDoM1R3XIpmro9yfOTrEY3THlJLgBel24u8wY8lsBeBzw9ye+HaCfZfALtfQT4P0meP1A2a2D5j4BftCHfe02gvUE/AbZLsnGLaa0kz2u98+tU1ffohnNP5rp9DHhnT6/pj4A3tOW9gPPa8lnAW9rxZyRZp5U/RHe935Rx3hzd4wLgL5Os2c5j1546I8nxna3O/JENrWf6dOAYeoZjV9XNIy+fGyNZ7rMOcGtb3mecevfS/TwlSZKklZ4J8/S3F7BfkgV0PbW7LUUbh9INSf4Rjx9CPZZvA7fQ9Yp+jW7+8eKqeoguMftwi+cKuiHj42rDqA8EvtJeZHUB8Hzg663Ku4EL6RLFaydxXlTVL+kSuG8kuZJuOPZmdEnbaa3sfOAdMKE5zFTVNVV1XM+mt9ENdb6Sbm73yMvNDqQbHn0V3XD6OQNt3U+X8B6UZEK91W2u8yl0w6H/H90c4sWPr1L3AJ8DrqZLjkfPjz6erhf+jIkccwI+AhyR5HLG7wW/EnikvfzsCS/9SnIecCLwiiS3JNl5iuKTJEmSplyqHPGoJ0qydlXd1+YcXwRsV1W3DTuuVcXA9Z9F96bq/avqsjaf+eNVdc4S9j+Erof93Ssi3uVlo43WqiM+NJFBDNLE7bnHRcMOQZIkTTNJLq2qJ7xs1znMGstpSdale4nWv5gsr3DHJplDN/T6uJYsf5FuKPv54+2Y5LvARkxgzrYkSZKksZkwq1dV7TDsGFZlVfWEOc9V9T8nuO9E5qlLkiRJWgLnMEuSJEmS1MOEWZIkSZKkHibMkiRJkiT1MGGWJEmSJKmHCbMkSZIkST1MmCVJkiRJ6uHHSkmattZb7/nsucdFww5DkiRJqyh7mCVJkiRJ6mHCLEmSJElSDxNmSZIkSZJ6mDBLkiRJktTDhFmSJEmSpB6+JVvStLXw7l+z5UmnDzsM/YFYMH/nYYcgSZJWMvYwS5IkSZLUw4RZkiRJkqQeJsySJEmSJPUwYZYkSZIkqYcJsyRJkiRJPUyYJUmSJEnqYcIsSZIkSVIPE2ZJkiRJknqYMEuSJEmS1MOEWVoJJXkkyRVJFiS5LMlLWvmfJDlpkm2dm2TewPrsJFdPdcyt7eckOSPJoiQLk8xeHseRJEmSpsLMYQcgaan8tqrmAiTZGTgCeFlV/RyYvyIDSTKzqh6eYPWvAB+oqjOTrA08uhxDkyRJkpaJPczSyu8pwN3w+N7hJLOSfKv15H43yYWDPckTkWRGko8muTjJlUne3Mp3SHJeklOAhUnWTPKlJFcluTzJy3vamgPMrKozAarqvqr6zTKeuyRJkrTc2MMsrZyenOQKYE3gGcCOPXXeCtxdVXOSbAFcMU57xyf5bVteg8d6fvcDFlfVNkmeBFyQ5Iy2bWtgi6q6McnBQFXVC5JsBpyR5HlV9cDAMZ4H3JPkO8BzgR8Ah1bVI4OBJNkf2B9g9fX/20SuhSRJkrRc2MMsrZx+W1Vzq2ozYBfgK0kyqs5LgRMAqupq4Mpx2turtTcXeNVA+V8Ab2rJ+YXA04BN2raLqurGgWN9rR3rWuBndAnyoJnA9sAhwDbAhsA+owOpqmOral5VzZv5lHXGCVmSJElavkyYpZVcVf0YWB94+nJoPsDbRpLpqnpuVY30MN8/ybZuAa6oqhvanOd/o+ulliRJkqYlE2ZpJdeGQM8A7hq16QJgz1ZnDvCCpWj+dOAtSVZv7TwvyVo99c4D9hqpAzwHuG5UnYuBdZOMJPY7AguXIiZJkiRphXAOs7RyYg/KSAAACalJREFUGpnDDF0v8N5V9cioUdlHA8clWQhcC1wDLJ7kcT4PzAYua0O+fwns3lPvaOCYJFcBDwP7VNWDgxVafIcAZ7W2LgU+N8l4JEmSpBUmVTXsGCQtB0lmAKtX1QNJNqJ7ydamVfXQkEObsFkbPa82+fCnhh2G/kAsmL/zsEOQJEnTVJJLq+oJnyhjD7P0h2sWcE4bTh3grStTsixJkiQNmwmz9Aeqqu4FJvW5y5IkSZIe40u/JEmSJEnqYcIsSZIkSVIPE2ZJkiRJknqYMEuSJEmS1MOEWZIkSZKkHibMkiRJkiT18GOlJE1bc9Z7CpfM33nYYUiSJGkVZQ+zJEmSJEk9TJglSZIkSeqRqhp2DJLUK8m9wHXDjkMrvfWBO4cdhFZq3kOaCt5HmgreR8vPn1bV00cXOodZ0nR2XVXNG3YQWrklucT7SMvCe0hTwftIU8H7aMVzSLYkSZIkST1MmCVJkiRJ6mHCLGk6O3bYAegPgveRlpX3kKaC95GmgvfRCuZLvyRJkiRJ6mEPsyRJkiRJPUyYJU1LSXZJcl2S65McOux4ND0leXaSc5IsTHJNkgNb+VOTnJnkP9v39Vp5knyy3VdXJtl6uGeg6SLJjCSXJzmtrT83yYXtXvlmkjVa+ZPa+vVt++xhxq3pI8m6SU5Kcm2SRUle7LNIk5XkoPb/2dVJvpFkTZ9Hw2XCLGnaSTID+AzwSmAO8MYkc4Yblaaph4GDq2oO8CLgH9q9cihwVlVtApzV1qG7pzZpX/sDx6z4kDVNHQgsGlj/MHBUVW0M3A3s18r3A+5u5Ue1ehLAvwLfr6rNgC3p7iefRZqwJM8E3g7Mq6otgBnAG/B5NFQmzJKmo22B66vqhqp6CDgB2G3IMWkaqqpfVNVlbfleul9Qn0l3vxzXqh0H7N6WdwO+Up2fAOsmecYKDlvTTJJnAa8GPt/WA+wInNSqjL6HRu6tk4BXtPpahSVZB/hz4AsAVfVQVd2DzyJN3kzgyUlmArOAX+DzaKhMmCVNR88Ebh5Yv6WVSWNqQ9G2Ai4ENqiqX7RNtwEbtGXvLfX5BPBPwKNt/WnAPVX1cFsfvE9+fw+17Ytbfa3angv8EvhSG9r/+SRr4bNIk1BVtwJHAjfRJcqLgUvxeTRUJsySpJVekrWBbwP/WFW/HtxW3cdB+JEQ6pVkV+COqrp02LFopTYT2Bo4pqq2Au7nseHXgM8iLVmb474b3R9g/gRYC9hlqEHJhFnStHQr8OyB9We1MukJkqxOlywfX1XfacW3jwxvbN/vaOXeWxptO+A1SX5KN/1jR7q5qOu2IZHw+Pvk9/dQ274OcNeKDFjT0i3ALVV1YVs/iS6B9lmkydgJuLGqfllVvwO+Q/eM8nk0RCbMkqaji4FN2lsh16B74cUpQ45J01Cbq/UFYFFVfXxg0ynA3m15b+DkgfI3tTfUvghYPDBcUqugqnpXVT2rqmbTPWvOrqq9gHOA+a3a6Hto5N6a3+rba7iKq6rbgJuTbNqKXgEsxGeRJucm4EVJZrX/30buI59HQxSvqaTpKMmr6OYVzgC+WFUfGHJImoaSvBQ4D7iKx+afHkY3j/lbwHOAnwF7VtWv2i8gn6Yb4vYbYN+qumSFB65pKckOwCFVtWuSDel6nJ8KXA78TVU9mGRN4Kt08+V/Bbyhqm4YVsyaPpLMpXtx3BrADcC+dJ1TPos0YUneB7ye7lMgLgf+jm6uss+jITFhliRJkiSph0OyJUmSJEnqYcIsSZIkSVIPE2ZJkiRJknqYMEuSJEmS1MOEWZIkSZKkHibMkiRplZVkjyTXJXkwyR1Jzk4y7X4/SvKRJPckqSR/N2rbDq185Ov2JJ9tHzmzvOL5aZL7lnLfL7c457XPmz08yT5THKIkTYlp9x+CJEnSipBkfeBrwEPA3wMfHtk0Re3PnKJ21gL+N7AY+Fvg7DGqngH8DbAIeHPbZ1pp1+QY4I3AfwGzgPcC+wwxLEkakwmzJElaVW0IrAHcBHy3qj5WVTtW1SMASbZN8sMk97be59e28t2SXJXk/iRXJ9mtlY/09H4vyUXAT1r5u5Lc2No5PcmGfcGM1S5wTfv+HOCr7Xuf/6yq43ks8f/vE4z31CTnJ7k7ycfTmd22ndbqHtLW9+mJe6ck1yd5IMmdSU5I8kdt20hv8jFJbgUOAN4CfAPYCLikNfOyVu/9SX6e5IqB9hckuTXJjDHOW5KWGxNmSZK0qloE3Am8CrgrySUjw52TPBX4HjAXeB9wBPBokk2BE4HVgYOAmcCJrXzETsB3gaOS7A18ELgQ+BDwZ23/x1lCu4cNxPtGYOEY57Nmkg2AV7f1myYY78uAE4ArW52/HOea9bkPOBp4O10i/Pq2PGh74D3Aj0eVjz63E4DPA1sm2SrJxnTX7PiRP2RI0oo0JUOFJEmSVjZVdW+S7YCDgV2AFwKfaz2hqwFPA46sqiNH9klyAF3y+bGq+lySAo6lS5JHeoJPq6ojWv2R5Pj17Qvgj5M8tap+NRDO/xin3W+2OndU1QnjnNJ+7QvgWrpEffcJxHtyVX06ySLgB8AOdMnzRD0ZeCtdj/GIF4yqc1hVnQKQ5C0D5WeMPrck99Al0vsCt7btX5lEPJI0ZUyYJUnSKinJ6nTDmN/c1t9H1wu6BWP34o6oUd8H/bynbC/gjra8GvCbpWh3SU4GPtWOs6iqHk5+Px17vHYz6jvASG/uyO+K645z3CPohrfvR9fb/E1g9AvH+q5JbzxVdUuSU4G/phsuf3lVXT3O8SVpuTFhliRJq6rNga8nOQH4GfDnrfwquiHUdwFvTnI78DDwU+BM4HfAwemy0YPa+g+AZ/Qc4zRgPrA33XDjDYEdqmr7UfXGa3eibqmqsybR7ki8r0nyD8Cebf1c4HbgAeCFSfZs8Y8nwPrAKycRL8CvgUeBjZPsBZxfVT+jezHY7nS9/P84yTYlaco4h1mSJK2qbqMbuvz3dMOUNwYOr6rvV9XddHObFwCH0w0RXq2qrgP2oEug/5Uu2duzlT9BVR0HHApswmNvh/5hT71JtTtRE2z37BbXlsBRwKlV9VCLe3W6XvcLxjnMYcDNwLuAK8ap1xff74CP0vVgf41urjN0if71Le6vT6ZNSZpKqVqaET+SJElamSXZATgH+ExVHTDkcH4vyTrAdsCXgfOq6nXDjUjSqsweZkmSJE0nWwH/TvcG83cOORZJqzh7mCVJkiRJ6mEPsyRJkiRJPUyYJUmSJEnqYcIsSZIkSVIPE2ZJkiRJknqYMEuSJEmS1MOEWZIkSZKkHv8fJh+o/AbY4igAAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 864x432 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "9gZWp5vQoB75"
      },
      "source": [
        "def reco_top_scored_one(n, genre=None):\n",
        "  if genre is None:\n",
        "    return popularity[\"original_title\"].head(n)\n",
        "  else:\n",
        "    return popularity[popularity['genres_name'].str.contains(genre)][\"original_title\"].head(n)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "3QKiQLllq8mC",
        "outputId": "da12a208-775d-4d22-d3d6-704641ce0e8a"
      },
      "source": [
        "print(reco_top_scored_one(10))"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "546                                              Minions\n",
            "95                                          Interstellar\n",
            "788                                             Deadpool\n",
            "94                               Guardians of the Galaxy\n",
            "127                                   Mad Max: Fury Road\n",
            "28                                        Jurassic World\n",
            "199    Pirates of the Caribbean: The Curse of the Bla...\n",
            "82                        Dawn of the Planet of the Apes\n",
            "200                The Hunger Games: Mockingjay - Part 1\n",
            "88                                            Big Hero 6\n",
            "Name: original_title, dtype: object\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "6FEkcquGxnKx",
        "outputId": "ebf92274-2ee6-44ab-c87e-3d927d80d9cb"
      },
      "source": [
        "print(reco_top_scored_one(10, \"Science Fiction\"))"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "95                              Interstellar\n",
            "94                   Guardians of the Galaxy\n",
            "127                       Mad Max: Fury Road\n",
            "28                            Jurassic World\n",
            "82            Dawn of the Planet of the Apes\n",
            "200    The Hunger Games: Mockingjay - Part 1\n",
            "108                       Terminator Genisys\n",
            "26                Captain America: Civil War\n",
            "270                              The Martian\n",
            "96                                 Inception\n",
            "Name: original_title, dtype: object\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "FUhmCpNyzkB_",
        "outputId": "060eb3c6-4f0a-408a-f7f4-e1eb01f2aa6a"
      },
      "source": [
        "print(reco_top_scored_one(10, \"Action\"))"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "788                                             Deadpool\n",
            "94                               Guardians of the Galaxy\n",
            "127                                   Mad Max: Fury Road\n",
            "28                                        Jurassic World\n",
            "199    Pirates of the Caribbean: The Curse of the Bla...\n",
            "82                        Dawn of the Planet of the Apes\n",
            "88                                            Big Hero 6\n",
            "108                                   Terminator Genisys\n",
            "26                            Captain America: Civil War\n",
            "65                                       The Dark Knight\n",
            "Name: original_title, dtype: object\n"
          ],
          "name": "stdout"
        }
      ]
    }
  ]
}