4_inference_pipeline.ipynb

{
  "cells": [
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {
        "id": "6_0Dc90zLc1T"
      },
      "outputs": [
        {
          "name": "stderr",
          "output_type": "stream",
          "text": [
            "/Users/martinbravodiaz/miniconda3/envs/imdb/lib/python3.10/site-packages/tqdm/auto.py:21: TqdmWarning: IProgress not found. Please update jupyter and ipywidgets. See https://ipywidgets.readthedocs.io/en/stable/user_install.html\n",
            "  from .autonotebook import tqdm as notebook_tqdm\n"
          ]
        }
      ],
      "source": [
        "from datetime import datetime, timedelta, timezone\n",
        "import pandas as pd\n",
        "from xgboost import XGBRegressor\n",
        "import hopsworks\n",
        "import json\n",
        "import os"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 2,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "6Czxc73zLgcJ",
        "outputId": "c49b1f4d-1fcb-471f-eea1-23b33875b7a4"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "2025-01-08 10:21:16,480 INFO: Initializing external client\n",
            "2025-01-08 10:21:16,481 INFO: Base URL: https://c.app.hopsworks.ai:443\n",
            "2025-01-08 10:21:18,147 INFO: Python Engine initialized.\n",
            "\n",
            "Logged in to project, explore it here https://c.app.hopsworks.ai:443/p/1169559\n"
          ]
        }
      ],
      "source": [
        "project = hopsworks.login(project=\"dbillLab1\")\n",
        "fs = project.get_feature_store()\n",
        "\n",
        "feature_view = fs.get_feature_view(\n",
        "    name='tmdb_fv',\n",
        "    version=3,\n",
        ")"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 3,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "iRmtZxaMMSHj",
        "outputId": "fc898625-bcbb-4dbb-d736-d81dd715160e"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "Downloading model artifact (0 dirs, 1 files)... DONE\r"
          ]
        }
      ],
      "source": [
        "mr= project.get_model_registry()\n",
        "\n",
        "retrieved_model=mr.get_model(\n",
        "    name=\"movie_rating_model_2\",\n",
        "    version=1,\n",
        ")\n",
        "\n",
        "saved_model_dir=retrieved_model.download()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 4,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 673
        },
        "id": "JhnLxnI2MVM2",
        "outputId": "7d358908-d2af-45ca-84c0-79f27aa3bc2c"
      },
      "outputs": [],
      "source": [
        "retrieved_xgboost_model=XGBRegressor()\n",
        "\n",
        "retrieved_xgboost_model.load_model(saved_model_dir+\"/model.json\")"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 5,
      "metadata": {},
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "2025-01-08 10:21:23,836 INFO: Closing external client and cleaning up certificates.\n",
            "Connection closed.\n",
            "2025-01-08 10:21:23,842 INFO: Initializing external client\n",
            "2025-01-08 10:21:23,842 INFO: Base URL: https://c.app.hopsworks.ai:443\n",
            "2025-01-08 10:21:25,126 INFO: Python Engine initialized.\n",
            "\n",
            "Logged in to project, explore it here https://c.app.hopsworks.ai:443/p/1169559\n",
            "Finished: Reading data from Hopsworks, using Hopsworks Feature Query Service (1.61s) \n"
          ]
        },
        {
          "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>id</th>\n",
              "      <th>title</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>status</th>\n",
              "      <th>release_date</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>budget</th>\n",
              "      <th>imdb_id</th>\n",
              "      <th>...</th>\n",
              "      <th>cast</th>\n",
              "      <th>director</th>\n",
              "      <th>director_of_photography</th>\n",
              "      <th>writers</th>\n",
              "      <th>producers</th>\n",
              "      <th>music_composer</th>\n",
              "      <th>imdb_rating</th>\n",
              "      <th>imdb_votes</th>\n",
              "      <th>poster_path</th>\n",
              "      <th>release_year</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1217624</td>\n",
              "      <td>The Evolution of Horror Cinema Worldwide</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-09-18 00:00:00+00:00</td>\n",
              "      <td>1000.0</td>\n",
              "      <td>90.0</td>\n",
              "      <td>1000.0</td>\n",
              "      <td>tt15679984</td>\n",
              "      <td>...</td>\n",
              "      <td>Kaiti Wallen, Zoe Berriatúa, Rosmary Yaneva, D...</td>\n",
              "      <td>Jhon Jatenjor</td>\n",
              "      <td>None</td>\n",
              "      <td>Jhon Jatenjor</td>\n",
              "      <td>David Conill, Ray Barlett</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>/q4GDeVerLjRNzlHfAFPaRoE28PF.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1266805</td>\n",
              "      <td>The Musicians</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-03-26 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>102.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>Valérie Donzelli, Frédéric Pierrot, Mathieu Sp...</td>\n",
              "      <td>Grégory Magne</td>\n",
              "      <td>None</td>\n",
              "      <td>Grégory Magne</td>\n",
              "      <td>Pierre-Louis Garnon, Frédéric Jouve</td>\n",
              "      <td>Grégoire Hetzel</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1315297</td>\n",
              "      <td>Dire Pines</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-01-24 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>3000.0</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>Isaac Stacey, Matthew Trueman</td>\n",
              "      <td>Jim Couroux, Taylor Allison</td>\n",
              "      <td>Camille Poon</td>\n",
              "      <td>Jim Couroux</td>\n",
              "      <td>Jim Couroux, Taylor Allison, David Daniels Won...</td>\n",
              "      <td>Jim Couroux</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>/mt2YmSyY6qz0VHrKsfATbd5YCPr.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>931942</td>\n",
              "      <td>BLKNWS: Terms and Conditions</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-01-24 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>113.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>tt17497960</td>\n",
              "      <td>...</td>\n",
              "      <td>Shaunette Renée Wilson, Peter Jay Fernandez, H...</td>\n",
              "      <td>Kahlil Joseph</td>\n",
              "      <td>Bradford Young</td>\n",
              "      <td>Saidiya Hartman, Kahlil Joseph, Irvin Hunt</td>\n",
              "      <td>Kahlil Joseph, Onye Anyanwu, Nicolas Gonda, An...</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>/7wQgClzJTgzdKAqyNDfhzyt0NjR.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1405751</td>\n",
              "      <td>Coroner to the Stars</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-02-20 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>Dr. Thomas Noguchi, Paul Guyet, Dan Medina, Dr...</td>\n",
              "      <td>Keita Ideno, Ben Hethcoat</td>\n",
              "      <td>Michelle Lawler, Erica Chan</td>\n",
              "      <td>None</td>\n",
              "      <td>Chiaki Yanagimoto, John Henry Hinkel, Tommy An...</td>\n",
              "      <td>Mike Schanzlin, Mike Griffin</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>/9doStrDXyrhRpY2o78AugRcgJGP.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>755</th>\n",
              "      <td>1389619</td>\n",
              "      <td>Parkside</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-01-15 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>150.0</td>\n",
              "      <td>tt32760279</td>\n",
              "      <td>...</td>\n",
              "      <td>Mattaya Braun, Benjamin Jorgensen, Gillian Garvie</td>\n",
              "      <td>Clay Cesmistruk</td>\n",
              "      <td>None</td>\n",
              "      <td>Clay Cesmistruk</td>\n",
              "      <td>Clay Cesmistruk</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>756</th>\n",
              "      <td>1235619</td>\n",
              "      <td>Les Bodin’s partent en vrille</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-03-19 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>tt32192665</td>\n",
              "      <td>...</td>\n",
              "      <td>Vincent Dubois, Jean-Christophe Fraiscinet, Lé...</td>\n",
              "      <td>Frédéric Forestier</td>\n",
              "      <td>Stéphane Le Parc, Christian Abomnes</td>\n",
              "      <td>Vincent Dubois, Jean-Christophe Fraiscinet</td>\n",
              "      <td>Claude Cyndecki, Frantz Richard</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>/4DUeoyYHwLIgzeCw8eszbjd0KgG.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>757</th>\n",
              "      <td>1379877</td>\n",
              "      <td>Azaad</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-01-17 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>Jiya Imran Amin, Amaan Devgn, Akshay Anand Koh...</td>\n",
              "      <td>Abhishek Kapoor</td>\n",
              "      <td>None</td>\n",
              "      <td>K. Hariharan, Abhishek Kapoor, Ritesh Shah, Su...</td>\n",
              "      <td>Pragya Kapoor, Ronnie Screwvala</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>/yWFpiJcUJfXRbm3om48kNJ0MU7A.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>758</th>\n",
              "      <td>1246595</td>\n",
              "      <td>El Set</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-06-01 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>Nelly Karim, Mona Zaki, Ahmed Dawood, Tamer Na...</td>\n",
              "      <td>Marwan Hamed</td>\n",
              "      <td>Abdelsalam Moussa</td>\n",
              "      <td>Ahmed Mourad</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>759</th>\n",
              "      <td>1411505</td>\n",
              "      <td>Solitude in my Mind</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-12-31 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>6000.0</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>Ethan King, Chase Bradshaw, Mason James, Conno...</td>\n",
              "      <td>Chase Bradshaw</td>\n",
              "      <td>Maddie Webbe</td>\n",
              "      <td>Chase Bradshaw</td>\n",
              "      <td>Ryan Mcfly, Chase Bradshaw, Breanna Johns, Lyd...</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>/uSCSYkKG77CzjNQfpxOTYrEam4x.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>760 rows × 29 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "          id                                     title  vote_average  \\\n",
              "0    1217624  The Evolution of Horror Cinema Worldwide           0.0   \n",
              "1    1266805                             The Musicians           0.0   \n",
              "2    1315297                                Dire Pines           0.0   \n",
              "3     931942              BLKNWS: Terms and Conditions           0.0   \n",
              "4    1405751                      Coroner to the Stars           0.0   \n",
              "..       ...                                       ...           ...   \n",
              "755  1389619                                  Parkside           0.0   \n",
              "756  1235619             Les Bodin’s partent en vrille           0.0   \n",
              "757  1379877                                     Azaad           0.0   \n",
              "758  1246595                                    El Set           0.0   \n",
              "759  1411505                       Solitude in my Mind           0.0   \n",
              "\n",
              "     vote_count           status              release_date  revenue  runtime  \\\n",
              "0           0.0  Post Production 2025-09-18 00:00:00+00:00   1000.0     90.0   \n",
              "1           0.0  Post Production 2025-03-26 00:00:00+00:00      0.0    102.0   \n",
              "2           0.0  Post Production 2025-01-24 00:00:00+00:00      0.0      0.0   \n",
              "3           0.0  Post Production 2025-01-24 00:00:00+00:00      0.0    113.0   \n",
              "4           0.0  Post Production 2025-02-20 00:00:00+00:00      0.0     83.0   \n",
              "..          ...              ...                       ...      ...      ...   \n",
              "755         0.0  Post Production 2025-01-15 00:00:00+00:00      0.0      0.0   \n",
              "756         0.0  Post Production 2025-03-19 00:00:00+00:00      0.0      0.0   \n",
              "757         0.0  Post Production 2025-01-17 00:00:00+00:00      0.0      0.0   \n",
              "758         0.0  Post Production 2025-06-01 00:00:00+00:00      0.0      0.0   \n",
              "759         0.0  Post Production 2025-12-31 00:00:00+00:00      0.0     30.0   \n",
              "\n",
              "     budget     imdb_id  ...  \\\n",
              "0    1000.0  tt15679984  ...   \n",
              "1       0.0        None  ...   \n",
              "2    3000.0        None  ...   \n",
              "3       0.0  tt17497960  ...   \n",
              "4       0.0        None  ...   \n",
              "..      ...         ...  ...   \n",
              "755   150.0  tt32760279  ...   \n",
              "756     0.0  tt32192665  ...   \n",
              "757     0.0        None  ...   \n",
              "758     0.0        None  ...   \n",
              "759  6000.0        None  ...   \n",
              "\n",
              "                                                  cast  \\\n",
              "0    Kaiti Wallen, Zoe Berriatúa, Rosmary Yaneva, D...   \n",
              "1    Valérie Donzelli, Frédéric Pierrot, Mathieu Sp...   \n",
              "2                        Isaac Stacey, Matthew Trueman   \n",
              "3    Shaunette Renée Wilson, Peter Jay Fernandez, H...   \n",
              "4    Dr. Thomas Noguchi, Paul Guyet, Dan Medina, Dr...   \n",
              "..                                                 ...   \n",
              "755  Mattaya Braun, Benjamin Jorgensen, Gillian Garvie   \n",
              "756  Vincent Dubois, Jean-Christophe Fraiscinet, Lé...   \n",
              "757  Jiya Imran Amin, Amaan Devgn, Akshay Anand Koh...   \n",
              "758  Nelly Karim, Mona Zaki, Ahmed Dawood, Tamer Na...   \n",
              "759  Ethan King, Chase Bradshaw, Mason James, Conno...   \n",
              "\n",
              "                        director              director_of_photography  \\\n",
              "0                  Jhon Jatenjor                                 None   \n",
              "1                  Grégory Magne                                 None   \n",
              "2    Jim Couroux, Taylor Allison                         Camille Poon   \n",
              "3                  Kahlil Joseph                       Bradford Young   \n",
              "4      Keita Ideno, Ben Hethcoat          Michelle Lawler, Erica Chan   \n",
              "..                           ...                                  ...   \n",
              "755              Clay Cesmistruk                                 None   \n",
              "756           Frédéric Forestier  Stéphane Le Parc, Christian Abomnes   \n",
              "757              Abhishek Kapoor                                 None   \n",
              "758                 Marwan Hamed                    Abdelsalam Moussa   \n",
              "759               Chase Bradshaw                         Maddie Webbe   \n",
              "\n",
              "                                               writers  \\\n",
              "0                                        Jhon Jatenjor   \n",
              "1                                        Grégory Magne   \n",
              "2                                          Jim Couroux   \n",
              "3           Saidiya Hartman, Kahlil Joseph, Irvin Hunt   \n",
              "4                                                 None   \n",
              "..                                                 ...   \n",
              "755                                    Clay Cesmistruk   \n",
              "756         Vincent Dubois, Jean-Christophe Fraiscinet   \n",
              "757  K. Hariharan, Abhishek Kapoor, Ritesh Shah, Su...   \n",
              "758                                       Ahmed Mourad   \n",
              "759                                     Chase Bradshaw   \n",
              "\n",
              "                                             producers  \\\n",
              "0                            David Conill, Ray Barlett   \n",
              "1                  Pierre-Louis Garnon, Frédéric Jouve   \n",
              "2    Jim Couroux, Taylor Allison, David Daniels Won...   \n",
              "3    Kahlil Joseph, Onye Anyanwu, Nicolas Gonda, An...   \n",
              "4    Chiaki Yanagimoto, John Henry Hinkel, Tommy An...   \n",
              "..                                                 ...   \n",
              "755                                    Clay Cesmistruk   \n",
              "756                    Claude Cyndecki, Frantz Richard   \n",
              "757                    Pragya Kapoor, Ronnie Screwvala   \n",
              "758                                               None   \n",
              "759  Ryan Mcfly, Chase Bradshaw, Breanna Johns, Lyd...   \n",
              "\n",
              "                   music_composer imdb_rating imdb_votes  \\\n",
              "0                            None         NaN        NaN   \n",
              "1                 Grégoire Hetzel         NaN        NaN   \n",
              "2                     Jim Couroux         NaN        NaN   \n",
              "3                            None         NaN        NaN   \n",
              "4    Mike Schanzlin, Mike Griffin         NaN        NaN   \n",
              "..                            ...         ...        ...   \n",
              "755                          None         NaN        NaN   \n",
              "756                          None         NaN        NaN   \n",
              "757                          None         NaN        NaN   \n",
              "758                          None         NaN        NaN   \n",
              "759                          None         NaN        NaN   \n",
              "\n",
              "                          poster_path release_year  \n",
              "0    /q4GDeVerLjRNzlHfAFPaRoE28PF.jpg         2025  \n",
              "1                                None         2025  \n",
              "2    /mt2YmSyY6qz0VHrKsfATbd5YCPr.jpg         2025  \n",
              "3    /7wQgClzJTgzdKAqyNDfhzyt0NjR.jpg         2025  \n",
              "4    /9doStrDXyrhRpY2o78AugRcgJGP.jpg         2025  \n",
              "..                                ...          ...  \n",
              "755                              None         2025  \n",
              "756  /4DUeoyYHwLIgzeCw8eszbjd0KgG.jpg         2025  \n",
              "757  /yWFpiJcUJfXRbm3om48kNJ0MU7A.jpg         2025  \n",
              "758                              None         2025  \n",
              "759  /uSCSYkKG77CzjNQfpxOTYrEam4x.jpg         2025  \n",
              "\n",
              "[760 rows x 29 columns]"
            ]
          },
          "execution_count": 5,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "project = hopsworks.login(project=\"dbillLab1\")\n",
        "fs = project.get_feature_store()\n",
        "\n",
        "movie_fg = fs.get_feature_group(\n",
        "    name='tmdb_upcoming_movies',\n",
        "    version=3,\n",
        ")\n",
        "\n",
        "df_new = movie_fg.read()\n",
        "\n",
        "df_new"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 6,
      "metadata": {},
      "outputs": [
        {
          "name": "stderr",
          "output_type": "stream",
          "text": [
            "SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame.\n",
            "Try using .loc[row_indexer,col_indexer] = value instead\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
            "SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame.\n",
            "Try using .loc[row_indexer,col_indexer] = value instead\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n"
          ]
        },
        {
          "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>id</th>\n",
              "      <th>title</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>status</th>\n",
              "      <th>release_date</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>budget</th>\n",
              "      <th>imdb_id</th>\n",
              "      <th>...</th>\n",
              "      <th>cast</th>\n",
              "      <th>director</th>\n",
              "      <th>director_of_photography</th>\n",
              "      <th>writers</th>\n",
              "      <th>producers</th>\n",
              "      <th>music_composer</th>\n",
              "      <th>imdb_rating</th>\n",
              "      <th>imdb_votes</th>\n",
              "      <th>poster_path</th>\n",
              "      <th>release_year</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>57</th>\n",
              "      <td>1100988</td>\n",
              "      <td>28 Years Later</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-06-16 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>75000000.0</td>\n",
              "      <td>tt10548174</td>\n",
              "      <td>...</td>\n",
              "      <td>Ralph Fiennes, Joe Blakemore, Nathan Hall, Edv...</td>\n",
              "      <td>Danny Boyle</td>\n",
              "      <td>Anthony Dod Mantle</td>\n",
              "      <td>Danny Boyle, Alex Garland</td>\n",
              "      <td>Danny Boyle, Peter Rice, Cillian Murphy, Berna...</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>/hVKHzr4GwSw0FepqhqQ0DDiYHNY.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>60</th>\n",
              "      <td>1101383</td>\n",
              "      <td>Flowervale Street</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2026-03-12 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>85000000.0</td>\n",
              "      <td>tt27165187</td>\n",
              "      <td>...</td>\n",
              "      <td>Jordan Alexa Davis, Anne Hathaway, Christian C...</td>\n",
              "      <td>David Robert Mitchell</td>\n",
              "      <td>Mike Gioulakis</td>\n",
              "      <td>David Robert Mitchell</td>\n",
              "      <td>David Robert Mitchell, Chris Bender, J.J. Abra...</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>None</td>\n",
              "      <td>2026</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>108</th>\n",
              "      <td>931285</td>\n",
              "      <td>Mortal Kombat 2</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-10-23 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>68000000.0</td>\n",
              "      <td>tt17490712</td>\n",
              "      <td>...</td>\n",
              "      <td>Desmond Chiam, Tati Gabrielle, Josh Lawson, Jo...</td>\n",
              "      <td>Simon McQuoid</td>\n",
              "      <td>Stephen F. Windon</td>\n",
              "      <td>Jeremy Slater</td>\n",
              "      <td>Michael Clear, Simon McQuoid, Toby Emmerich, J...</td>\n",
              "      <td>Benjamin Wallfisch</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>/yN1bQ8XLh7Q2bEu3YBtp68vUeXl.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>198</th>\n",
              "      <td>1277016</td>\n",
              "      <td>The Queen of Heaven</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-04-04 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>196.0</td>\n",
              "      <td>22000000.0</td>\n",
              "      <td>tt25049058</td>\n",
              "      <td>...</td>\n",
              "      <td>George Angelopoulos, Maria Aliferi, Yorgo Cons...</td>\n",
              "      <td>Yiannis Stravolaimos</td>\n",
              "      <td>None</td>\n",
              "      <td>Yiannis Stravolaimos</td>\n",
              "      <td>Ali Bakkioui, Yiannis Stravolaimos</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>/zY2vIC5q9waeSKDrYjAQnP6CyTz.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>257</th>\n",
              "      <td>1127674</td>\n",
              "      <td>La città proibita</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-03-13 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>18218260.0</td>\n",
              "      <td>tt27766538</td>\n",
              "      <td>...</td>\n",
              "      <td>Luca Zingaretti, Yaxi Liu, Sabrina Ferilli, Ma...</td>\n",
              "      <td>Gabriele Mainetti</td>\n",
              "      <td>Paolo Carnera</td>\n",
              "      <td>Stefano Bises, Gabriele Mainetti, Davide Serino</td>\n",
              "      <td>Lorenzo Gangarossa, Gabriele Mainetti, Mario G...</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>None</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>308</th>\n",
              "      <td>936075</td>\n",
              "      <td>Michael</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-10-01 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>155000000.0</td>\n",
              "      <td>tt11378946</td>\n",
              "      <td>...</td>\n",
              "      <td>Rhyan Hill, KeiLyn Durrel Jones, Kevin Shinick...</td>\n",
              "      <td>Antoine Fuqua</td>\n",
              "      <td>Dion Beebe</td>\n",
              "      <td>John Logan</td>\n",
              "      <td>David B. Householter, Graham King, John Branca...</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>/OJnvJXpRZZEfYj4L3WfEDQsaYQ.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>316</th>\n",
              "      <td>1317288</td>\n",
              "      <td>Marty Supreme</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-12-25 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>70000000.0</td>\n",
              "      <td>tt32916440</td>\n",
              "      <td>...</td>\n",
              "      <td>Timothée Chalamet, Gwyneth Paltrow, Odessa A'z...</td>\n",
              "      <td>Josh Safdie</td>\n",
              "      <td>Darius Khondji</td>\n",
              "      <td>Ronald Bronstein, Josh Safdie</td>\n",
              "      <td>Eli Bush, Sara Rossein, Ronald Bronstein, Timo...</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>None</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>416</th>\n",
              "      <td>1249289</td>\n",
              "      <td>Alarum</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-01-16 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>95.0</td>\n",
              "      <td>20000000.0</td>\n",
              "      <td>tt31456973</td>\n",
              "      <td>...</td>\n",
              "      <td>Beau Bommarito, La Monde Byrd, Anton Narinskiy...</td>\n",
              "      <td>Michael Polish</td>\n",
              "      <td>None</td>\n",
              "      <td>Alexander Vesha</td>\n",
              "      <td>Luke Taylor, Matthew Helderman, Joel Cohen, Gw...</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>/luIf8RCY8sKyluZUJ6bzwqhYC0x.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>461</th>\n",
              "      <td>680493</td>\n",
              "      <td>Return to Silent Hill</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-04-11 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>40000000.0</td>\n",
              "      <td>tt22868010</td>\n",
              "      <td>...</td>\n",
              "      <td>Melissa Graham, Slaviša Ivanović, Robert Stran...</td>\n",
              "      <td>Christophe Gans</td>\n",
              "      <td>Pablo Rosso</td>\n",
              "      <td>William Josef Schneider, Sandra Vo-Anh, Christ...</td>\n",
              "      <td>Joe Jenckes, Jay Taylor, David M. Wulf, Jonath...</td>\n",
              "      <td>Akira Yamaoka</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>/yFNDmvwVUiMrrtLGjnMNTIsW91z.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>477</th>\n",
              "      <td>83533</td>\n",
              "      <td>Avatar: Fire and Ash</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-12-17 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>400000000.0</td>\n",
              "      <td>tt1757678</td>\n",
              "      <td>...</td>\n",
              "      <td>Cliff Curtis, CCH Pounder, Giovanni Ribisi, Tr...</td>\n",
              "      <td>James Cameron</td>\n",
              "      <td>Russell Carpenter</td>\n",
              "      <td>James Cameron, Rick Jaffa, Shane Salerno, Aman...</td>\n",
              "      <td>Peter M. Tobyansen, Jon Landau, James Cameron</td>\n",
              "      <td>Simon Franglen</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>/vDdFxksDMkUJjZXd00OKJfwXKre.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>520</th>\n",
              "      <td>1233575</td>\n",
              "      <td>Black Bag</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-03-12 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>60000000.0</td>\n",
              "      <td>tt30988739</td>\n",
              "      <td>...</td>\n",
              "      <td>Regé-Jean Page, Cate Blanchett, Tom Burke, Mar...</td>\n",
              "      <td>Steven Soderbergh</td>\n",
              "      <td>Steven Soderbergh</td>\n",
              "      <td>David Koepp</td>\n",
              "      <td>Gregory Jacobs, Casey Silver</td>\n",
              "      <td>Thomas Newman</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>/yCVJ8joYTzf9tCby9o9H7zhEVG8.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>534</th>\n",
              "      <td>1266781</td>\n",
              "      <td>Natacha</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-04-02 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>15000000.0</td>\n",
              "      <td>tt32370862</td>\n",
              "      <td>...</td>\n",
              "      <td>Didier Bourdon, Elsa Zylberstein, Baptiste Lec...</td>\n",
              "      <td>Noémie Saglio</td>\n",
              "      <td>Nicolas Massart</td>\n",
              "      <td>Laurent Turner, François Walthéry, Noémie Sagl...</td>\n",
              "      <td>Nathalie Toulza Madar, Vanessa Djian</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>/c6BWAWAvuhT6ZuSdiHB9BJg2t7T.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>570</th>\n",
              "      <td>1238188</td>\n",
              "      <td>The Captive</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-10-17 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>10720500.0</td>\n",
              "      <td>tt31101921</td>\n",
              "      <td>...</td>\n",
              "      <td>Luna Berroa, Alessandro Borghi, César Saratxu,...</td>\n",
              "      <td>Alejandro Amenábar</td>\n",
              "      <td>Álex Catalán</td>\n",
              "      <td>Alejandro Amenábar</td>\n",
              "      <td>Fernando Bovaira</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>/8qSN7tMgJbzlvwEy6rpmvsZ1xZT.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>584</th>\n",
              "      <td>967941</td>\n",
              "      <td>Wicked: For Good</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-11-20 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>150000000.0</td>\n",
              "      <td>tt19847976</td>\n",
              "      <td>...</td>\n",
              "      <td>Jeff Goldblum, Aaron Teoh, Ricardo Ludgero Sou...</td>\n",
              "      <td>Jon M. Chu</td>\n",
              "      <td>Alice Brooks</td>\n",
              "      <td>Stephen Schwartz, Winnie Holzman, L. Frank Bau...</td>\n",
              "      <td>David Nicksay, Stephen Schwartz, Marc Platt, D...</td>\n",
              "      <td>John Powell, Stephen Schwartz</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>/cdlwS7DF4gw9F0jadfPHptuGuCt.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>609</th>\n",
              "      <td>575265</td>\n",
              "      <td>Mission: Impossible - The Final Reckoning</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-05-21 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>400000000.0</td>\n",
              "      <td>tt9603208</td>\n",
              "      <td>...</td>\n",
              "      <td>Mark Gatiss, Gabriella Piazza, Tom Cruise, Han...</td>\n",
              "      <td>Christopher McQuarrie</td>\n",
              "      <td>Fraser Taggart</td>\n",
              "      <td>Erik Jendresen, Christopher McQuarrie, Bruce G...</td>\n",
              "      <td>Jason Cloth, Dana Goldberg, Christopher McQuar...</td>\n",
              "      <td>Lorne Balfe</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>/z53D72EAOxGRqdr7KXXWp9dJiDe.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>667</th>\n",
              "      <td>1379520</td>\n",
              "      <td>Rule Breakers</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-03-21 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>15000000.0</td>\n",
              "      <td>tt23398348</td>\n",
              "      <td>...</td>\n",
              "      <td>Phoebe Waller-Bridge, Christopher Goh, Sami Fe...</td>\n",
              "      <td>Bill Guttentag</td>\n",
              "      <td>None</td>\n",
              "      <td>Elaha Mahboob, Jason Brown, Bill Guttentag</td>\n",
              "      <td>Samudrika Arora, Bill Guttentag</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>/8blxh0LUFRkYvBu2uw1Hc2s6IqP.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>674</th>\n",
              "      <td>950387</td>\n",
              "      <td>A Minecraft Movie</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-04-02 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>150000000.0</td>\n",
              "      <td>tt3566834</td>\n",
              "      <td>...</td>\n",
              "      <td>Jennifer Coolidge, Matt Berry, Emma Myers, Jas...</td>\n",
              "      <td>Jared Hess</td>\n",
              "      <td>Enrique Chediak</td>\n",
              "      <td>Hubbel Palmer, Chris Bowman</td>\n",
              "      <td>Kayleen Walters, Andrew Lary, Jon Spaihts, Lyd...</td>\n",
              "      <td>Mark Mothersbaugh</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>/wTxYZNj3NselE9H9dST2GUn4UYE.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>701</th>\n",
              "      <td>1233413</td>\n",
              "      <td>Sinners</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-04-16 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>90000000.0</td>\n",
              "      <td>tt31193180</td>\n",
              "      <td>...</td>\n",
              "      <td>Li Jun Li, Delroy Lindo, Thomas Pang, Wunmi Mo...</td>\n",
              "      <td>Ryan Coogler</td>\n",
              "      <td>Autumn Durald</td>\n",
              "      <td>Ryan Coogler</td>\n",
              "      <td>Zinzi Coogler, Ryan Coogler, Ludwig Göransson,...</td>\n",
              "      <td>Ludwig Göransson</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>/oLwgIMCgtpSO8LpPoEhzxETD3J4.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>732</th>\n",
              "      <td>696506</td>\n",
              "      <td>Mickey 17</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-03-06 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>137.0</td>\n",
              "      <td>150000000.0</td>\n",
              "      <td>tt12299608</td>\n",
              "      <td>...</td>\n",
              "      <td>Mark Ruffalo, Daniel Henshall, Tom Cawte, Pats...</td>\n",
              "      <td>Bong Joon-ho</td>\n",
              "      <td>Darius Khondji</td>\n",
              "      <td>Edward Ashton, Bong Joon-ho</td>\n",
              "      <td>Andrew Lary, Jesse Ehrman, Anthony Tittanegro,...</td>\n",
              "      <td>Jung Jae-il</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>/sY4n1osXuddwZokEmWUu1kq7U8g.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>741</th>\n",
              "      <td>777443</td>\n",
              "      <td>The Electric State</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-03-13 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>320000000.0</td>\n",
              "      <td>tt7766378</td>\n",
              "      <td>...</td>\n",
              "      <td>Anthony Mackie, Hank Azaria, Millie Bobby Brow...</td>\n",
              "      <td>Joe Russo, Anthony Russo</td>\n",
              "      <td>Stephen F. Windon</td>\n",
              "      <td>Simon Stålenhag, Stephen McFeely, Christopher ...</td>\n",
              "      <td>Chris Castaldi, Christopher Markus, Jeffrey Fo...</td>\n",
              "      <td>Alan Silvestri</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>/aD8NVgBnlnzZw9YPlLkh5q2v0Iq.jpg</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>745</th>\n",
              "      <td>1054867</td>\n",
              "      <td>The Battle of Baktan Cross</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-08-06 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>140000000.0</td>\n",
              "      <td>tt30144839</td>\n",
              "      <td>...</td>\n",
              "      <td>Bogdan Szumilas, Teyana Taylor, Justin S. McDa...</td>\n",
              "      <td>Paul Thomas Anderson</td>\n",
              "      <td>Paul Thomas Anderson, Michael Bauman</td>\n",
              "      <td>Paul Thomas Anderson</td>\n",
              "      <td>JoAnne Sellar, Sara Murphy, Paul Thomas Anders...</td>\n",
              "      <td>Jonny Greenwood</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>None</td>\n",
              "      <td>2025</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>21 rows × 29 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "          id                                      title  vote_average  \\\n",
              "57   1100988                             28 Years Later           0.0   \n",
              "60   1101383                          Flowervale Street           0.0   \n",
              "108   931285                            Mortal Kombat 2           0.0   \n",
              "198  1277016                        The Queen of Heaven           0.0   \n",
              "257  1127674                          La città proibita           0.0   \n",
              "308   936075                                    Michael           0.0   \n",
              "316  1317288                              Marty Supreme           0.0   \n",
              "416  1249289                                     Alarum           0.0   \n",
              "461   680493                      Return to Silent Hill           0.0   \n",
              "477    83533                       Avatar: Fire and Ash           0.0   \n",
              "520  1233575                                  Black Bag           0.0   \n",
              "534  1266781                                    Natacha           0.0   \n",
              "570  1238188                                The Captive           0.0   \n",
              "584   967941                           Wicked: For Good           0.0   \n",
              "609   575265  Mission: Impossible - The Final Reckoning           0.0   \n",
              "667  1379520                              Rule Breakers           0.0   \n",
              "674   950387                          A Minecraft Movie           0.0   \n",
              "701  1233413                                    Sinners           0.0   \n",
              "732   696506                                  Mickey 17           0.0   \n",
              "741   777443                         The Electric State           0.0   \n",
              "745  1054867                 The Battle of Baktan Cross           0.0   \n",
              "\n",
              "     vote_count           status              release_date  revenue  runtime  \\\n",
              "57          0.0  Post Production 2025-06-16 00:00:00+00:00      0.0    132.0   \n",
              "60          0.0  Post Production 2026-03-12 00:00:00+00:00      0.0    132.0   \n",
              "108         0.0  Post Production 2025-10-23 00:00:00+00:00      0.0    132.0   \n",
              "198         0.0  Post Production 2025-04-04 00:00:00+00:00      0.0    196.0   \n",
              "257         0.0  Post Production 2025-03-13 00:00:00+00:00      0.0    132.0   \n",
              "308         0.0  Post Production 2025-10-01 00:00:00+00:00      0.0    132.0   \n",
              "316         0.0  Post Production 2025-12-25 00:00:00+00:00      0.0    132.0   \n",
              "416         0.0  Post Production 2025-01-16 00:00:00+00:00      0.0     95.0   \n",
              "461         0.0  Post Production 2025-04-11 00:00:00+00:00      0.0    132.0   \n",
              "477         0.0  Post Production 2025-12-17 00:00:00+00:00      0.0    132.0   \n",
              "520         0.0  Post Production 2025-03-12 00:00:00+00:00      0.0    132.0   \n",
              "534         0.0  Post Production 2025-04-02 00:00:00+00:00      0.0    132.0   \n",
              "570         0.0  Post Production 2025-10-17 00:00:00+00:00      0.0    132.0   \n",
              "584         0.0  Post Production 2025-11-20 00:00:00+00:00      0.0    132.0   \n",
              "609         0.0  Post Production 2025-05-21 00:00:00+00:00      0.0    132.0   \n",
              "667         0.0  Post Production 2025-03-21 00:00:00+00:00      0.0    132.0   \n",
              "674         0.0  Post Production 2025-04-02 00:00:00+00:00      0.0    100.0   \n",
              "701         0.0  Post Production 2025-04-16 00:00:00+00:00      0.0    132.0   \n",
              "732         0.0  Post Production 2025-03-06 00:00:00+00:00      0.0    137.0   \n",
              "741         0.0  Post Production 2025-03-13 00:00:00+00:00      0.0    132.0   \n",
              "745         0.0  Post Production 2025-08-06 00:00:00+00:00      0.0    132.0   \n",
              "\n",
              "          budget     imdb_id  ...  \\\n",
              "57    75000000.0  tt10548174  ...   \n",
              "60    85000000.0  tt27165187  ...   \n",
              "108   68000000.0  tt17490712  ...   \n",
              "198   22000000.0  tt25049058  ...   \n",
              "257   18218260.0  tt27766538  ...   \n",
              "308  155000000.0  tt11378946  ...   \n",
              "316   70000000.0  tt32916440  ...   \n",
              "416   20000000.0  tt31456973  ...   \n",
              "461   40000000.0  tt22868010  ...   \n",
              "477  400000000.0   tt1757678  ...   \n",
              "520   60000000.0  tt30988739  ...   \n",
              "534   15000000.0  tt32370862  ...   \n",
              "570   10720500.0  tt31101921  ...   \n",
              "584  150000000.0  tt19847976  ...   \n",
              "609  400000000.0   tt9603208  ...   \n",
              "667   15000000.0  tt23398348  ...   \n",
              "674  150000000.0   tt3566834  ...   \n",
              "701   90000000.0  tt31193180  ...   \n",
              "732  150000000.0  tt12299608  ...   \n",
              "741  320000000.0   tt7766378  ...   \n",
              "745  140000000.0  tt30144839  ...   \n",
              "\n",
              "                                                  cast  \\\n",
              "57   Ralph Fiennes, Joe Blakemore, Nathan Hall, Edv...   \n",
              "60   Jordan Alexa Davis, Anne Hathaway, Christian C...   \n",
              "108  Desmond Chiam, Tati Gabrielle, Josh Lawson, Jo...   \n",
              "198  George Angelopoulos, Maria Aliferi, Yorgo Cons...   \n",
              "257  Luca Zingaretti, Yaxi Liu, Sabrina Ferilli, Ma...   \n",
              "308  Rhyan Hill, KeiLyn Durrel Jones, Kevin Shinick...   \n",
              "316  Timothée Chalamet, Gwyneth Paltrow, Odessa A'z...   \n",
              "416  Beau Bommarito, La Monde Byrd, Anton Narinskiy...   \n",
              "461  Melissa Graham, Slaviša Ivanović, Robert Stran...   \n",
              "477  Cliff Curtis, CCH Pounder, Giovanni Ribisi, Tr...   \n",
              "520  Regé-Jean Page, Cate Blanchett, Tom Burke, Mar...   \n",
              "534  Didier Bourdon, Elsa Zylberstein, Baptiste Lec...   \n",
              "570  Luna Berroa, Alessandro Borghi, César Saratxu,...   \n",
              "584  Jeff Goldblum, Aaron Teoh, Ricardo Ludgero Sou...   \n",
              "609  Mark Gatiss, Gabriella Piazza, Tom Cruise, Han...   \n",
              "667  Phoebe Waller-Bridge, Christopher Goh, Sami Fe...   \n",
              "674  Jennifer Coolidge, Matt Berry, Emma Myers, Jas...   \n",
              "701  Li Jun Li, Delroy Lindo, Thomas Pang, Wunmi Mo...   \n",
              "732  Mark Ruffalo, Daniel Henshall, Tom Cawte, Pats...   \n",
              "741  Anthony Mackie, Hank Azaria, Millie Bobby Brow...   \n",
              "745  Bogdan Szumilas, Teyana Taylor, Justin S. McDa...   \n",
              "\n",
              "                     director               director_of_photography  \\\n",
              "57                Danny Boyle                    Anthony Dod Mantle   \n",
              "60      David Robert Mitchell                        Mike Gioulakis   \n",
              "108             Simon McQuoid                     Stephen F. Windon   \n",
              "198      Yiannis Stravolaimos                                  None   \n",
              "257         Gabriele Mainetti                         Paolo Carnera   \n",
              "308             Antoine Fuqua                            Dion Beebe   \n",
              "316               Josh Safdie                        Darius Khondji   \n",
              "416            Michael Polish                                  None   \n",
              "461           Christophe Gans                           Pablo Rosso   \n",
              "477             James Cameron                     Russell Carpenter   \n",
              "520         Steven Soderbergh                     Steven Soderbergh   \n",
              "534             Noémie Saglio                       Nicolas Massart   \n",
              "570        Alejandro Amenábar                          Álex Catalán   \n",
              "584                Jon M. Chu                          Alice Brooks   \n",
              "609     Christopher McQuarrie                        Fraser Taggart   \n",
              "667            Bill Guttentag                                  None   \n",
              "674                Jared Hess                       Enrique Chediak   \n",
              "701              Ryan Coogler                         Autumn Durald   \n",
              "732              Bong Joon-ho                        Darius Khondji   \n",
              "741  Joe Russo, Anthony Russo                     Stephen F. Windon   \n",
              "745      Paul Thomas Anderson  Paul Thomas Anderson, Michael Bauman   \n",
              "\n",
              "                                               writers  \\\n",
              "57                           Danny Boyle, Alex Garland   \n",
              "60                               David Robert Mitchell   \n",
              "108                                      Jeremy Slater   \n",
              "198                               Yiannis Stravolaimos   \n",
              "257    Stefano Bises, Gabriele Mainetti, Davide Serino   \n",
              "308                                         John Logan   \n",
              "316                      Ronald Bronstein, Josh Safdie   \n",
              "416                                    Alexander Vesha   \n",
              "461  William Josef Schneider, Sandra Vo-Anh, Christ...   \n",
              "477  James Cameron, Rick Jaffa, Shane Salerno, Aman...   \n",
              "520                                        David Koepp   \n",
              "534  Laurent Turner, François Walthéry, Noémie Sagl...   \n",
              "570                                 Alejandro Amenábar   \n",
              "584  Stephen Schwartz, Winnie Holzman, L. Frank Bau...   \n",
              "609  Erik Jendresen, Christopher McQuarrie, Bruce G...   \n",
              "667         Elaha Mahboob, Jason Brown, Bill Guttentag   \n",
              "674                        Hubbel Palmer, Chris Bowman   \n",
              "701                                       Ryan Coogler   \n",
              "732                        Edward Ashton, Bong Joon-ho   \n",
              "741  Simon Stålenhag, Stephen McFeely, Christopher ...   \n",
              "745                               Paul Thomas Anderson   \n",
              "\n",
              "                                             producers  \\\n",
              "57   Danny Boyle, Peter Rice, Cillian Murphy, Berna...   \n",
              "60   David Robert Mitchell, Chris Bender, J.J. Abra...   \n",
              "108  Michael Clear, Simon McQuoid, Toby Emmerich, J...   \n",
              "198                 Ali Bakkioui, Yiannis Stravolaimos   \n",
              "257  Lorenzo Gangarossa, Gabriele Mainetti, Mario G...   \n",
              "308  David B. Householter, Graham King, John Branca...   \n",
              "316  Eli Bush, Sara Rossein, Ronald Bronstein, Timo...   \n",
              "416  Luke Taylor, Matthew Helderman, Joel Cohen, Gw...   \n",
              "461  Joe Jenckes, Jay Taylor, David M. Wulf, Jonath...   \n",
              "477      Peter M. Tobyansen, Jon Landau, James Cameron   \n",
              "520                       Gregory Jacobs, Casey Silver   \n",
              "534               Nathalie Toulza Madar, Vanessa Djian   \n",
              "570                                   Fernando Bovaira   \n",
              "584  David Nicksay, Stephen Schwartz, Marc Platt, D...   \n",
              "609  Jason Cloth, Dana Goldberg, Christopher McQuar...   \n",
              "667                    Samudrika Arora, Bill Guttentag   \n",
              "674  Kayleen Walters, Andrew Lary, Jon Spaihts, Lyd...   \n",
              "701  Zinzi Coogler, Ryan Coogler, Ludwig Göransson,...   \n",
              "732  Andrew Lary, Jesse Ehrman, Anthony Tittanegro,...   \n",
              "741  Chris Castaldi, Christopher Markus, Jeffrey Fo...   \n",
              "745  JoAnne Sellar, Sara Murphy, Paul Thomas Anders...   \n",
              "\n",
              "                    music_composer imdb_rating imdb_votes  \\\n",
              "57                            None         NaN        400   \n",
              "60                            None         NaN        400   \n",
              "108             Benjamin Wallfisch         NaN        400   \n",
              "198                           None         NaN        400   \n",
              "257                           None         NaN        400   \n",
              "308                           None         NaN        400   \n",
              "316                           None         NaN        400   \n",
              "416                           None         NaN        400   \n",
              "461                  Akira Yamaoka         NaN        400   \n",
              "477                 Simon Franglen         NaN        400   \n",
              "520                  Thomas Newman         NaN        400   \n",
              "534                           None         NaN        400   \n",
              "570                           None         NaN        400   \n",
              "584  John Powell, Stephen Schwartz         NaN        400   \n",
              "609                    Lorne Balfe         NaN        400   \n",
              "667                           None         NaN        400   \n",
              "674              Mark Mothersbaugh         NaN        400   \n",
              "701               Ludwig Göransson         NaN        400   \n",
              "732                    Jung Jae-il         NaN        400   \n",
              "741                 Alan Silvestri         NaN        400   \n",
              "745                Jonny Greenwood         NaN        400   \n",
              "\n",
              "                          poster_path release_year  \n",
              "57   /hVKHzr4GwSw0FepqhqQ0DDiYHNY.jpg         2025  \n",
              "60                               None         2026  \n",
              "108  /yN1bQ8XLh7Q2bEu3YBtp68vUeXl.jpg         2025  \n",
              "198  /zY2vIC5q9waeSKDrYjAQnP6CyTz.jpg         2025  \n",
              "257                              None         2025  \n",
              "308   /OJnvJXpRZZEfYj4L3WfEDQsaYQ.jpg         2025  \n",
              "316                              None         2025  \n",
              "416  /luIf8RCY8sKyluZUJ6bzwqhYC0x.jpg         2025  \n",
              "461  /yFNDmvwVUiMrrtLGjnMNTIsW91z.jpg         2025  \n",
              "477  /vDdFxksDMkUJjZXd00OKJfwXKre.jpg         2025  \n",
              "520  /yCVJ8joYTzf9tCby9o9H7zhEVG8.jpg         2025  \n",
              "534  /c6BWAWAvuhT6ZuSdiHB9BJg2t7T.jpg         2025  \n",
              "570  /8qSN7tMgJbzlvwEy6rpmvsZ1xZT.jpg         2025  \n",
              "584  /cdlwS7DF4gw9F0jadfPHptuGuCt.jpg         2025  \n",
              "609  /z53D72EAOxGRqdr7KXXWp9dJiDe.jpg         2025  \n",
              "667  /8blxh0LUFRkYvBu2uw1Hc2s6IqP.jpg         2025  \n",
              "674  /wTxYZNj3NselE9H9dST2GUn4UYE.jpg         2025  \n",
              "701  /oLwgIMCgtpSO8LpPoEhzxETD3J4.jpg         2025  \n",
              "732  /sY4n1osXuddwZokEmWUu1kq7U8g.jpg         2025  \n",
              "741  /aD8NVgBnlnzZw9YPlLkh5q2v0Iq.jpg         2025  \n",
              "745                              None         2025  \n",
              "\n",
              "[21 rows x 29 columns]"
            ]
          },
          "execution_count": 6,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# Have budget\n",
        "df_b = df_new[(df_new['budget'] > 10000000.0)]\n",
        "df_b[\"imdb_votes\"]=400\n",
        "\n",
        "# We only consider movies that have a release date in the future\n",
        "df_b[\"release_date\"] = pd.to_datetime(df_b[\"release_date\"])\n",
        "df_b = df_b[df_b[\"release_date\"] > datetime.now(timezone.utc)]\n",
        "\n",
        "# fill runtime zero values with the mean of the non-zero values\n",
        "runtime_without_zero = df_b[df_b[\"runtime\"] != 0]\n",
        "mean_runtime = runtime_without_zero[\"runtime\"].mean()\n",
        "df_b[\"runtime\"] = df_b[\"runtime\"].replace(0, mean_runtime)\n",
        "\n",
        "df_b"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 7,
      "metadata": {},
      "outputs": [],
      "source": [
        "from utils import new_features\n",
        "\n",
        "df1= new_features(df_b)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 8,
      "metadata": {},
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>title</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>status</th>\n",
              "      <th>release_date</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>budget</th>\n",
              "      <th>imdb_id</th>\n",
              "      <th>...</th>\n",
              "      <th>writers</th>\n",
              "      <th>producers</th>\n",
              "      <th>music_composer</th>\n",
              "      <th>imdb_rating</th>\n",
              "      <th>imdb_votes</th>\n",
              "      <th>poster_path</th>\n",
              "      <th>release_year</th>\n",
              "      <th>first_producer</th>\n",
              "      <th>first_actor</th>\n",
              "      <th>first_company</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>57</th>\n",
              "      <td>1100988</td>\n",
              "      <td>28 Years Later</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-06-16 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>75000000.0</td>\n",
              "      <td>tt10548174</td>\n",
              "      <td>...</td>\n",
              "      <td>Danny Boyle, Alex Garland</td>\n",
              "      <td>Danny Boyle, Peter Rice, Cillian Murphy, Berna...</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>/hVKHzr4GwSw0FepqhqQ0DDiYHNY.jpg</td>\n",
              "      <td>2025</td>\n",
              "      <td>3</td>\n",
              "      <td>16</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>60</th>\n",
              "      <td>1101383</td>\n",
              "      <td>Flowervale Street</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2026-03-12 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>85000000.0</td>\n",
              "      <td>tt27165187</td>\n",
              "      <td>...</td>\n",
              "      <td>David Robert Mitchell</td>\n",
              "      <td>David Robert Mitchell, Chris Bender, J.J. Abra...</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>None</td>\n",
              "      <td>2026</td>\n",
              "      <td>6</td>\n",
              "      <td>9</td>\n",
              "      <td>8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>108</th>\n",
              "      <td>931285</td>\n",
              "      <td>Mortal Kombat 2</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-10-23 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>68000000.0</td>\n",
              "      <td>tt17490712</td>\n",
              "      <td>...</td>\n",
              "      <td>Jeremy Slater</td>\n",
              "      <td>Michael Clear, Simon McQuoid, Toby Emmerich, J...</td>\n",
              "      <td>Benjamin Wallfisch</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>/yN1bQ8XLh7Q2bEu3YBtp68vUeXl.jpg</td>\n",
              "      <td>2025</td>\n",
              "      <td>16</td>\n",
              "      <td>4</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>198</th>\n",
              "      <td>1277016</td>\n",
              "      <td>The Queen of Heaven</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-04-04 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>196.0</td>\n",
              "      <td>22000000.0</td>\n",
              "      <td>tt25049058</td>\n",
              "      <td>...</td>\n",
              "      <td>Yiannis Stravolaimos</td>\n",
              "      <td>Ali Bakkioui, Yiannis Stravolaimos</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>/zY2vIC5q9waeSKDrYjAQnP6CyTz.jpg</td>\n",
              "      <td>2025</td>\n",
              "      <td>0</td>\n",
              "      <td>6</td>\n",
              "      <td>17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>257</th>\n",
              "      <td>1127674</td>\n",
              "      <td>La città proibita</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-03-13 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>18218260.0</td>\n",
              "      <td>tt27766538</td>\n",
              "      <td>...</td>\n",
              "      <td>Stefano Bises, Gabriele Mainetti, Davide Serino</td>\n",
              "      <td>Lorenzo Gangarossa, Gabriele Mainetti, Mario G...</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>400</td>\n",
              "      <td>None</td>\n",
              "      <td>2025</td>\n",
              "      <td>14</td>\n",
              "      <td>11</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 32 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "          id                title  vote_average  vote_count           status  \\\n",
              "57   1100988       28 Years Later           0.0         0.0  Post Production   \n",
              "60   1101383    Flowervale Street           0.0         0.0  Post Production   \n",
              "108   931285      Mortal Kombat 2           0.0         0.0  Post Production   \n",
              "198  1277016  The Queen of Heaven           0.0         0.0  Post Production   \n",
              "257  1127674    La città proibita           0.0         0.0  Post Production   \n",
              "\n",
              "                 release_date  revenue  runtime      budget     imdb_id  ...  \\\n",
              "57  2025-06-16 00:00:00+00:00      0.0    132.0  75000000.0  tt10548174  ...   \n",
              "60  2026-03-12 00:00:00+00:00      0.0    132.0  85000000.0  tt27165187  ...   \n",
              "108 2025-10-23 00:00:00+00:00      0.0    132.0  68000000.0  tt17490712  ...   \n",
              "198 2025-04-04 00:00:00+00:00      0.0    196.0  22000000.0  tt25049058  ...   \n",
              "257 2025-03-13 00:00:00+00:00      0.0    132.0  18218260.0  tt27766538  ...   \n",
              "\n",
              "                                             writers  \\\n",
              "57                         Danny Boyle, Alex Garland   \n",
              "60                             David Robert Mitchell   \n",
              "108                                    Jeremy Slater   \n",
              "198                             Yiannis Stravolaimos   \n",
              "257  Stefano Bises, Gabriele Mainetti, Davide Serino   \n",
              "\n",
              "                                             producers      music_composer  \\\n",
              "57   Danny Boyle, Peter Rice, Cillian Murphy, Berna...                None   \n",
              "60   David Robert Mitchell, Chris Bender, J.J. Abra...                None   \n",
              "108  Michael Clear, Simon McQuoid, Toby Emmerich, J...  Benjamin Wallfisch   \n",
              "198                 Ali Bakkioui, Yiannis Stravolaimos                None   \n",
              "257  Lorenzo Gangarossa, Gabriele Mainetti, Mario G...                None   \n",
              "\n",
              "     imdb_rating imdb_votes                       poster_path release_year  \\\n",
              "57           NaN        400  /hVKHzr4GwSw0FepqhqQ0DDiYHNY.jpg         2025   \n",
              "60           NaN        400                              None         2026   \n",
              "108          NaN        400  /yN1bQ8XLh7Q2bEu3YBtp68vUeXl.jpg         2025   \n",
              "198          NaN        400  /zY2vIC5q9waeSKDrYjAQnP6CyTz.jpg         2025   \n",
              "257          NaN        400                              None         2025   \n",
              "\n",
              "    first_producer first_actor first_company  \n",
              "57               3          16             4  \n",
              "60               6           9             8  \n",
              "108             16           4            11  \n",
              "198              0           6            17  \n",
              "257             14          11            16  \n",
              "\n",
              "[5 rows x 32 columns]"
            ]
          },
          "execution_count": 8,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df1.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 9,
      "metadata": {},
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "Index: 20 entries, 57 to 745\n",
            "Data columns (total 27 columns):\n",
            " #   Column             Non-Null Count  Dtype  \n",
            "---  ------             --------------  -----  \n",
            " 0   runtime            20 non-null     float64\n",
            " 1   release_year       20 non-null     int32  \n",
            " 2   imdb_votes         20 non-null     int64  \n",
            " 3   budget             20 non-null     float64\n",
            " 4   first_producer     20 non-null     int64  \n",
            " 5   first_actor        20 non-null     int64  \n",
            " 6   first_company      20 non-null     int64  \n",
            " 7   original_language  20 non-null     int64  \n",
            " 8   action             20 non-null     int64  \n",
            " 9   adventure          20 non-null     int64  \n",
            " 10  comedy             20 non-null     int64  \n",
            " 11  crime              20 non-null     int64  \n",
            " 12  drama              20 non-null     int64  \n",
            " 13  family             20 non-null     int64  \n",
            " 14  fantasy            20 non-null     int64  \n",
            " 15  history            20 non-null     int64  \n",
            " 16  horror             20 non-null     int64  \n",
            " 17  music              20 non-null     int64  \n",
            " 18  mystery            20 non-null     int64  \n",
            " 19  romance            20 non-null     int64  \n",
            " 20  science_fiction    20 non-null     int64  \n",
            " 21  thriller           20 non-null     int64  \n",
            " 22  animation          20 non-null     int64  \n",
            " 23  documentary        20 non-null     int64  \n",
            " 24  tv_movie           20 non-null     int64  \n",
            " 25  war                20 non-null     int64  \n",
            " 26  western            20 non-null     int64  \n",
            "dtypes: float64(2), int32(1), int64(24)\n",
            "memory usage: 4.3 KB\n"
          ]
        }
      ],
      "source": [
        "df_encoded = df1.copy()\n",
        "df_encoded = df_encoded[[\"runtime\", \"release_year\", \"imdb_votes\", \"budget\", \"genres\", \"first_producer\", \"first_actor\", \"first_company\", \"original_language\"]]\n",
        "df_encoded['genres'] = df_encoded['genres'].str.split(', ')  # Split by comma and space\n",
        "genres_encoded = df_encoded['genres'].explode()  # Flatten the list\n",
        "one_hot = pd.get_dummies(genres_encoded).groupby(level=0).sum()\n",
        "\n",
        "one_hot.columns = one_hot.columns.str.lower()  # Lowercase column names\n",
        "one_hot.columns = one_hot.columns.str.replace(' ', '_')  # Replace spaces with underscores\n",
        "\n",
        "# Add missing columns if not already in the DataFrame\n",
        "all_genres=['action', 'adventure', 'animation', 'comedy', 'crime', 'documentary', 'drama', 'family', 'fantasy', 'history', 'horror', 'music', 'mystery', 'romance', 'science_fiction', 'tv_movie', 'thriller', 'war', 'western']\n",
        "for col in all_genres:\n",
        "        if col not in one_hot.columns:\n",
        "            one_hot[col] = 0  # or df_encoded[col] = False if they were boolean flags\n",
        "\n",
        "# Merge one-hot encoding with the original DataFrame\n",
        "train_features = pd.concat([df_encoded, one_hot], axis=1)\n",
        "train_features=train_features.drop([\"genres\"], axis=1)\n",
        "train_features.info()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 10,
      "metadata": {},
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>release_year</th>\n",
              "      <th>runtime</th>\n",
              "      <th>budget</th>\n",
              "      <th>original_language</th>\n",
              "      <th>first_company</th>\n",
              "      <th>first_producer</th>\n",
              "      <th>first_actor</th>\n",
              "      <th>imdb_votes</th>\n",
              "      <th>action</th>\n",
              "      <th>adventure</th>\n",
              "      <th>...</th>\n",
              "      <th>history</th>\n",
              "      <th>horror</th>\n",
              "      <th>music</th>\n",
              "      <th>mystery</th>\n",
              "      <th>romance</th>\n",
              "      <th>science_fiction</th>\n",
              "      <th>tv_movie</th>\n",
              "      <th>thriller</th>\n",
              "      <th>war</th>\n",
              "      <th>western</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>57</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>75000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "      <td>16</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>60</th>\n",
              "      <td>2026</td>\n",
              "      <td>132.0</td>\n",
              "      <td>85000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>8</td>\n",
              "      <td>6</td>\n",
              "      <td>9</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>108</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>68000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>11</td>\n",
              "      <td>16</td>\n",
              "      <td>4</td>\n",
              "      <td>400</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>198</th>\n",
              "      <td>2025</td>\n",
              "      <td>196.0</td>\n",
              "      <td>22000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>17</td>\n",
              "      <td>0</td>\n",
              "      <td>6</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>257</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>18218260.0</td>\n",
              "      <td>3</td>\n",
              "      <td>16</td>\n",
              "      <td>14</td>\n",
              "      <td>11</td>\n",
              "      <td>400</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>308</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>155000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>10</td>\n",
              "      <td>4</td>\n",
              "      <td>18</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>316</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>70000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>7</td>\n",
              "      <td>19</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>416</th>\n",
              "      <td>2025</td>\n",
              "      <td>95.0</td>\n",
              "      <td>20000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>3</td>\n",
              "      <td>15</td>\n",
              "      <td>1</td>\n",
              "      <td>400</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>461</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>40000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>9</td>\n",
              "      <td>12</td>\n",
              "      <td>15</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>477</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>400000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>3</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>520</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>60000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>6</td>\n",
              "      <td>9</td>\n",
              "      <td>17</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>534</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>15000000.0</td>\n",
              "      <td>2</td>\n",
              "      <td>5</td>\n",
              "      <td>17</td>\n",
              "      <td>5</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>570</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>10720500.0</td>\n",
              "      <td>1</td>\n",
              "      <td>7</td>\n",
              "      <td>8</td>\n",
              "      <td>12</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>584</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>150000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>14</td>\n",
              "      <td>5</td>\n",
              "      <td>7</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>609</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>400000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>12</td>\n",
              "      <td>10</td>\n",
              "      <td>13</td>\n",
              "      <td>400</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>674</th>\n",
              "      <td>2025</td>\n",
              "      <td>100.0</td>\n",
              "      <td>150000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>15</td>\n",
              "      <td>13</td>\n",
              "      <td>8</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>701</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>90000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>13</td>\n",
              "      <td>19</td>\n",
              "      <td>10</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>732</th>\n",
              "      <td>2025</td>\n",
              "      <td>137.0</td>\n",
              "      <td>150000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>15</td>\n",
              "      <td>1</td>\n",
              "      <td>14</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>741</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>320000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>745</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>140000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>15</td>\n",
              "      <td>11</td>\n",
              "      <td>2</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>20 rows × 27 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "     release_year  runtime       budget  original_language  first_company  \\\n",
              "57           2025    132.0   75000000.0                  0              4   \n",
              "60           2026    132.0   85000000.0                  0              8   \n",
              "108          2025    132.0   68000000.0                  0             11   \n",
              "198          2025    196.0   22000000.0                  0             17   \n",
              "257          2025    132.0   18218260.0                  3             16   \n",
              "308          2025    132.0  155000000.0                  0             10   \n",
              "316          2025    132.0   70000000.0                  0              1   \n",
              "416          2025     95.0   20000000.0                  0              3   \n",
              "461          2025    132.0   40000000.0                  0              9   \n",
              "477          2025    132.0  400000000.0                  0              0   \n",
              "520          2025    132.0   60000000.0                  0              6   \n",
              "534          2025    132.0   15000000.0                  2              5   \n",
              "570          2025    132.0   10720500.0                  1              7   \n",
              "584          2025    132.0  150000000.0                  0             14   \n",
              "609          2025    132.0  400000000.0                  0             12   \n",
              "674          2025    100.0  150000000.0                  0             15   \n",
              "701          2025    132.0   90000000.0                  0             13   \n",
              "732          2025    137.0  150000000.0                  0             15   \n",
              "741          2025    132.0  320000000.0                  0              2   \n",
              "745          2025    132.0  140000000.0                  0             15   \n",
              "\n",
              "     first_producer  first_actor  imdb_votes  action  adventure  ...  history  \\\n",
              "57                3           16         400       0          0  ...        0   \n",
              "60                6            9         400       0          1  ...        0   \n",
              "108              16            4         400       1          1  ...        0   \n",
              "198               0            6         400       0          0  ...        0   \n",
              "257              14           11         400       1          0  ...        0   \n",
              "308               4           18         400       0          0  ...        1   \n",
              "316               7           19         400       0          0  ...        0   \n",
              "416              15            1         400       1          0  ...        0   \n",
              "461              12           15         400       0          0  ...        0   \n",
              "477              18            3         400       0          1  ...        0   \n",
              "520               9           17         400       0          0  ...        0   \n",
              "534              17            5         400       0          1  ...        0   \n",
              "570               8           12         400       0          0  ...        1   \n",
              "584               5            7         400       0          0  ...        0   \n",
              "609              10           13         400       1          1  ...        0   \n",
              "674              13            8         400       0          1  ...        0   \n",
              "701              19           10         400       0          0  ...        0   \n",
              "732               1           14         400       0          0  ...        0   \n",
              "741               2            0         400       0          1  ...        0   \n",
              "745              11            2         400       0          0  ...        0   \n",
              "\n",
              "     horror  music  mystery  romance  science_fiction  tv_movie  thriller  \\\n",
              "57        1      0        0        0                1         0         0   \n",
              "60        0      0        0        0                0         0         1   \n",
              "108       0      0        0        0                0         0         0   \n",
              "198       0      0        0        0                0         0         0   \n",
              "257       0      0        0        0                0         0         0   \n",
              "308       0      1        0        0                0         0         0   \n",
              "316       0      0        0        0                0         0         0   \n",
              "416       0      0        0        0                0         0         1   \n",
              "461       1      0        1        0                0         0         0   \n",
              "477       0      0        0        0                1         0         0   \n",
              "520       0      0        0        0                0         0         1   \n",
              "534       0      0        0        0                0         0         0   \n",
              "570       0      0        0        0                0         0         0   \n",
              "584       0      1        0        1                0         0         0   \n",
              "609       0      0        0        0                0         0         1   \n",
              "674       0      0        0        0                0         0         0   \n",
              "701       1      0        0        0                0         0         1   \n",
              "732       0      0        0        0                1         0         0   \n",
              "741       0      0        0        0                1         0         0   \n",
              "745       0      0        0        0                0         0         0   \n",
              "\n",
              "     war  western  \n",
              "57     0        0  \n",
              "60     0        0  \n",
              "108    0        0  \n",
              "198    0        0  \n",
              "257    0        0  \n",
              "308    0        0  \n",
              "316    0        0  \n",
              "416    0        0  \n",
              "461    0        0  \n",
              "477    0        0  \n",
              "520    0        0  \n",
              "534    0        0  \n",
              "570    0        0  \n",
              "584    0        0  \n",
              "609    0        0  \n",
              "674    0        0  \n",
              "701    0        0  \n",
              "732    0        0  \n",
              "741    0        0  \n",
              "745    0        0  \n",
              "\n",
              "[20 rows x 27 columns]"
            ]
          },
          "execution_count": 10,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# Ensure the column order matches the expected order\n",
        "expected_columns = ['release_year', 'runtime', 'budget', 'original_language', 'first_company', 'first_producer', 'first_actor', 'imdb_votes', 'action', 'adventure', 'animation', 'comedy', 'crime', 'documentary', 'drama', 'family', 'fantasy', 'history', 'horror', 'music', 'mystery', 'romance', 'science_fiction', 'tv_movie', 'thriller', 'war', 'western']\n",
        "train_features=train_features[expected_columns]\n",
        "\n",
        "train_features"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 11,
      "metadata": {},
      "outputs": [],
      "source": [
        "predicted = retrieved_xgboost_model.predict(train_features)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 12,
      "metadata": {},
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>release_year</th>\n",
              "      <th>runtime</th>\n",
              "      <th>budget</th>\n",
              "      <th>original_language</th>\n",
              "      <th>first_company</th>\n",
              "      <th>first_producer</th>\n",
              "      <th>first_actor</th>\n",
              "      <th>imdb_votes</th>\n",
              "      <th>action</th>\n",
              "      <th>adventure</th>\n",
              "      <th>...</th>\n",
              "      <th>horror</th>\n",
              "      <th>music</th>\n",
              "      <th>mystery</th>\n",
              "      <th>romance</th>\n",
              "      <th>science_fiction</th>\n",
              "      <th>tv_movie</th>\n",
              "      <th>thriller</th>\n",
              "      <th>war</th>\n",
              "      <th>western</th>\n",
              "      <th>predicted_rating</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>57</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>75000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "      <td>16</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>3.845231</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>60</th>\n",
              "      <td>2026</td>\n",
              "      <td>132.0</td>\n",
              "      <td>85000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>8</td>\n",
              "      <td>6</td>\n",
              "      <td>9</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>5.373774</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>108</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>68000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>11</td>\n",
              "      <td>16</td>\n",
              "      <td>4</td>\n",
              "      <td>400</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>5.110221</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>198</th>\n",
              "      <td>2025</td>\n",
              "      <td>196.0</td>\n",
              "      <td>22000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>17</td>\n",
              "      <td>0</td>\n",
              "      <td>6</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>7.384965</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>257</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>18218260.0</td>\n",
              "      <td>3</td>\n",
              "      <td>16</td>\n",
              "      <td>14</td>\n",
              "      <td>11</td>\n",
              "      <td>400</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>5.168054</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>308</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>155000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>10</td>\n",
              "      <td>4</td>\n",
              "      <td>18</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>6.168319</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>316</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>70000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>7</td>\n",
              "      <td>19</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>6.237243</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>416</th>\n",
              "      <td>2025</td>\n",
              "      <td>95.0</td>\n",
              "      <td>20000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>3</td>\n",
              "      <td>15</td>\n",
              "      <td>1</td>\n",
              "      <td>400</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>4.569636</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>461</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>40000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>9</td>\n",
              "      <td>12</td>\n",
              "      <td>15</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>5.308178</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>477</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>400000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>18</td>\n",
              "      <td>3</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>4.606920</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>520</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>60000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>6</td>\n",
              "      <td>9</td>\n",
              "      <td>17</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>5.884254</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>534</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>15000000.0</td>\n",
              "      <td>2</td>\n",
              "      <td>5</td>\n",
              "      <td>17</td>\n",
              "      <td>5</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>5.860930</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>570</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>10720500.0</td>\n",
              "      <td>1</td>\n",
              "      <td>7</td>\n",
              "      <td>8</td>\n",
              "      <td>12</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>6.317752</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>584</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>150000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>14</td>\n",
              "      <td>5</td>\n",
              "      <td>7</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>6.791449</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>609</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>400000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>12</td>\n",
              "      <td>10</td>\n",
              "      <td>13</td>\n",
              "      <td>400</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>5.198944</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>674</th>\n",
              "      <td>2025</td>\n",
              "      <td>100.0</td>\n",
              "      <td>150000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>15</td>\n",
              "      <td>13</td>\n",
              "      <td>8</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>4.923363</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>701</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>90000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>13</td>\n",
              "      <td>19</td>\n",
              "      <td>10</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>5.295504</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>732</th>\n",
              "      <td>2025</td>\n",
              "      <td>137.0</td>\n",
              "      <td>150000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>15</td>\n",
              "      <td>1</td>\n",
              "      <td>14</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>4.500335</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>741</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>320000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>5.073595</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>745</th>\n",
              "      <td>2025</td>\n",
              "      <td>132.0</td>\n",
              "      <td>140000000.0</td>\n",
              "      <td>0</td>\n",
              "      <td>15</td>\n",
              "      <td>11</td>\n",
              "      <td>2</td>\n",
              "      <td>400</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>6.554660</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>20 rows × 28 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "     release_year  runtime       budget  original_language  first_company  \\\n",
              "57           2025    132.0   75000000.0                  0              4   \n",
              "60           2026    132.0   85000000.0                  0              8   \n",
              "108          2025    132.0   68000000.0                  0             11   \n",
              "198          2025    196.0   22000000.0                  0             17   \n",
              "257          2025    132.0   18218260.0                  3             16   \n",
              "308          2025    132.0  155000000.0                  0             10   \n",
              "316          2025    132.0   70000000.0                  0              1   \n",
              "416          2025     95.0   20000000.0                  0              3   \n",
              "461          2025    132.0   40000000.0                  0              9   \n",
              "477          2025    132.0  400000000.0                  0              0   \n",
              "520          2025    132.0   60000000.0                  0              6   \n",
              "534          2025    132.0   15000000.0                  2              5   \n",
              "570          2025    132.0   10720500.0                  1              7   \n",
              "584          2025    132.0  150000000.0                  0             14   \n",
              "609          2025    132.0  400000000.0                  0             12   \n",
              "674          2025    100.0  150000000.0                  0             15   \n",
              "701          2025    132.0   90000000.0                  0             13   \n",
              "732          2025    137.0  150000000.0                  0             15   \n",
              "741          2025    132.0  320000000.0                  0              2   \n",
              "745          2025    132.0  140000000.0                  0             15   \n",
              "\n",
              "     first_producer  first_actor  imdb_votes  action  adventure  ...  horror  \\\n",
              "57                3           16         400       0          0  ...       1   \n",
              "60                6            9         400       0          1  ...       0   \n",
              "108              16            4         400       1          1  ...       0   \n",
              "198               0            6         400       0          0  ...       0   \n",
              "257              14           11         400       1          0  ...       0   \n",
              "308               4           18         400       0          0  ...       0   \n",
              "316               7           19         400       0          0  ...       0   \n",
              "416              15            1         400       1          0  ...       0   \n",
              "461              12           15         400       0          0  ...       1   \n",
              "477              18            3         400       0          1  ...       0   \n",
              "520               9           17         400       0          0  ...       0   \n",
              "534              17            5         400       0          1  ...       0   \n",
              "570               8           12         400       0          0  ...       0   \n",
              "584               5            7         400       0          0  ...       0   \n",
              "609              10           13         400       1          1  ...       0   \n",
              "674              13            8         400       0          1  ...       0   \n",
              "701              19           10         400       0          0  ...       1   \n",
              "732               1           14         400       0          0  ...       0   \n",
              "741               2            0         400       0          1  ...       0   \n",
              "745              11            2         400       0          0  ...       0   \n",
              "\n",
              "     music  mystery  romance  science_fiction  tv_movie  thriller  war  \\\n",
              "57       0        0        0                1         0         0    0   \n",
              "60       0        0        0                0         0         1    0   \n",
              "108      0        0        0                0         0         0    0   \n",
              "198      0        0        0                0         0         0    0   \n",
              "257      0        0        0                0         0         0    0   \n",
              "308      1        0        0                0         0         0    0   \n",
              "316      0        0        0                0         0         0    0   \n",
              "416      0        0        0                0         0         1    0   \n",
              "461      0        1        0                0         0         0    0   \n",
              "477      0        0        0                1         0         0    0   \n",
              "520      0        0        0                0         0         1    0   \n",
              "534      0        0        0                0         0         0    0   \n",
              "570      0        0        0                0         0         0    0   \n",
              "584      1        0        1                0         0         0    0   \n",
              "609      0        0        0                0         0         1    0   \n",
              "674      0        0        0                0         0         0    0   \n",
              "701      0        0        0                0         0         1    0   \n",
              "732      0        0        0                1         0         0    0   \n",
              "741      0        0        0                1         0         0    0   \n",
              "745      0        0        0                0         0         0    0   \n",
              "\n",
              "     western  predicted_rating  \n",
              "57         0          3.845231  \n",
              "60         0          5.373774  \n",
              "108        0          5.110221  \n",
              "198        0          7.384965  \n",
              "257        0          5.168054  \n",
              "308        0          6.168319  \n",
              "316        0          6.237243  \n",
              "416        0          4.569636  \n",
              "461        0          5.308178  \n",
              "477        0          4.606920  \n",
              "520        0          5.884254  \n",
              "534        0          5.860930  \n",
              "570        0          6.317752  \n",
              "584        0          6.791449  \n",
              "609        0          5.198944  \n",
              "674        0          4.923363  \n",
              "701        0          5.295504  \n",
              "732        0          4.500335  \n",
              "741        0          5.073595  \n",
              "745        0          6.554660  \n",
              "\n",
              "[20 rows x 28 columns]"
            ]
          },
          "execution_count": 12,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "train_features[\"predicted_rating\"]=predicted\n",
        "\n",
        "train_features"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 13,
      "metadata": {},
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>title</th>\n",
              "      <th>vote_average</th>\n",
              "      <th>vote_count</th>\n",
              "      <th>status</th>\n",
              "      <th>release_date</th>\n",
              "      <th>revenue</th>\n",
              "      <th>runtime</th>\n",
              "      <th>budget</th>\n",
              "      <th>imdb_id</th>\n",
              "      <th>...</th>\n",
              "      <th>horror</th>\n",
              "      <th>music</th>\n",
              "      <th>mystery</th>\n",
              "      <th>romance</th>\n",
              "      <th>science_fiction</th>\n",
              "      <th>tv_movie</th>\n",
              "      <th>thriller</th>\n",
              "      <th>war</th>\n",
              "      <th>western</th>\n",
              "      <th>predicted_rating</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>57</th>\n",
              "      <td>1100988</td>\n",
              "      <td>28 Years Later</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-06-16 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>75000000.0</td>\n",
              "      <td>tt10548174</td>\n",
              "      <td>...</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>3.845231</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>60</th>\n",
              "      <td>1101383</td>\n",
              "      <td>Flowervale Street</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2026-03-12 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>85000000.0</td>\n",
              "      <td>tt27165187</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>5.373774</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>108</th>\n",
              "      <td>931285</td>\n",
              "      <td>Mortal Kombat 2</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-10-23 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>68000000.0</td>\n",
              "      <td>tt17490712</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>5.110221</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>198</th>\n",
              "      <td>1277016</td>\n",
              "      <td>The Queen of Heaven</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-04-04 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>196.0</td>\n",
              "      <td>22000000.0</td>\n",
              "      <td>tt25049058</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>7.384965</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>257</th>\n",
              "      <td>1127674</td>\n",
              "      <td>La città proibita</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-03-13 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>18218260.0</td>\n",
              "      <td>tt27766538</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>5.168054</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>308</th>\n",
              "      <td>936075</td>\n",
              "      <td>Michael</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-10-01 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>155000000.0</td>\n",
              "      <td>tt11378946</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>6.168319</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>316</th>\n",
              "      <td>1317288</td>\n",
              "      <td>Marty Supreme</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-12-25 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>70000000.0</td>\n",
              "      <td>tt32916440</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>6.237243</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>416</th>\n",
              "      <td>1249289</td>\n",
              "      <td>Alarum</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-01-16 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>95.0</td>\n",
              "      <td>20000000.0</td>\n",
              "      <td>tt31456973</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>4.569636</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>461</th>\n",
              "      <td>680493</td>\n",
              "      <td>Return to Silent Hill</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-04-11 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>40000000.0</td>\n",
              "      <td>tt22868010</td>\n",
              "      <td>...</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>5.308178</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>477</th>\n",
              "      <td>83533</td>\n",
              "      <td>Avatar: Fire and Ash</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-12-17 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>400000000.0</td>\n",
              "      <td>tt1757678</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>4.606920</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>520</th>\n",
              "      <td>1233575</td>\n",
              "      <td>Black Bag</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-03-12 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>60000000.0</td>\n",
              "      <td>tt30988739</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>5.884254</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>534</th>\n",
              "      <td>1266781</td>\n",
              "      <td>Natacha</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-04-02 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>15000000.0</td>\n",
              "      <td>tt32370862</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>5.860930</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>570</th>\n",
              "      <td>1238188</td>\n",
              "      <td>The Captive</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-10-17 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>10720500.0</td>\n",
              "      <td>tt31101921</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>6.317752</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>584</th>\n",
              "      <td>967941</td>\n",
              "      <td>Wicked: For Good</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-11-20 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>150000000.0</td>\n",
              "      <td>tt19847976</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>6.791449</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>609</th>\n",
              "      <td>575265</td>\n",
              "      <td>Mission: Impossible - The Final Reckoning</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-05-21 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>400000000.0</td>\n",
              "      <td>tt9603208</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>5.198944</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>667</th>\n",
              "      <td>1379520</td>\n",
              "      <td>Rule Breakers</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-03-21 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>15000000.0</td>\n",
              "      <td>tt23398348</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>674</th>\n",
              "      <td>950387</td>\n",
              "      <td>A Minecraft Movie</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-04-02 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>150000000.0</td>\n",
              "      <td>tt3566834</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>4.923363</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>701</th>\n",
              "      <td>1233413</td>\n",
              "      <td>Sinners</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-04-16 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>90000000.0</td>\n",
              "      <td>tt31193180</td>\n",
              "      <td>...</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>5.295504</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>732</th>\n",
              "      <td>696506</td>\n",
              "      <td>Mickey 17</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-03-06 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>137.0</td>\n",
              "      <td>150000000.0</td>\n",
              "      <td>tt12299608</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>4.500335</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>741</th>\n",
              "      <td>777443</td>\n",
              "      <td>The Electric State</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-03-13 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>320000000.0</td>\n",
              "      <td>tt7766378</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>5.073595</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>745</th>\n",
              "      <td>1054867</td>\n",
              "      <td>The Battle of Baktan Cross</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>Post Production</td>\n",
              "      <td>2025-08-06 00:00:00+00:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>140000000.0</td>\n",
              "      <td>tt30144839</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>6.554660</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>21 rows × 57 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "          id                                      title  vote_average  \\\n",
              "57   1100988                             28 Years Later           0.0   \n",
              "60   1101383                          Flowervale Street           0.0   \n",
              "108   931285                            Mortal Kombat 2           0.0   \n",
              "198  1277016                        The Queen of Heaven           0.0   \n",
              "257  1127674                          La città proibita           0.0   \n",
              "308   936075                                    Michael           0.0   \n",
              "316  1317288                              Marty Supreme           0.0   \n",
              "416  1249289                                     Alarum           0.0   \n",
              "461   680493                      Return to Silent Hill           0.0   \n",
              "477    83533                       Avatar: Fire and Ash           0.0   \n",
              "520  1233575                                  Black Bag           0.0   \n",
              "534  1266781                                    Natacha           0.0   \n",
              "570  1238188                                The Captive           0.0   \n",
              "584   967941                           Wicked: For Good           0.0   \n",
              "609   575265  Mission: Impossible - The Final Reckoning           0.0   \n",
              "667  1379520                              Rule Breakers           0.0   \n",
              "674   950387                          A Minecraft Movie           0.0   \n",
              "701  1233413                                    Sinners           0.0   \n",
              "732   696506                                  Mickey 17           0.0   \n",
              "741   777443                         The Electric State           0.0   \n",
              "745  1054867                 The Battle of Baktan Cross           0.0   \n",
              "\n",
              "     vote_count           status              release_date  revenue  runtime  \\\n",
              "57          0.0  Post Production 2025-06-16 00:00:00+00:00      0.0    132.0   \n",
              "60          0.0  Post Production 2026-03-12 00:00:00+00:00      0.0    132.0   \n",
              "108         0.0  Post Production 2025-10-23 00:00:00+00:00      0.0    132.0   \n",
              "198         0.0  Post Production 2025-04-04 00:00:00+00:00      0.0    196.0   \n",
              "257         0.0  Post Production 2025-03-13 00:00:00+00:00      0.0    132.0   \n",
              "308         0.0  Post Production 2025-10-01 00:00:00+00:00      0.0    132.0   \n",
              "316         0.0  Post Production 2025-12-25 00:00:00+00:00      0.0    132.0   \n",
              "416         0.0  Post Production 2025-01-16 00:00:00+00:00      0.0     95.0   \n",
              "461         0.0  Post Production 2025-04-11 00:00:00+00:00      0.0    132.0   \n",
              "477         0.0  Post Production 2025-12-17 00:00:00+00:00      0.0    132.0   \n",
              "520         0.0  Post Production 2025-03-12 00:00:00+00:00      0.0    132.0   \n",
              "534         0.0  Post Production 2025-04-02 00:00:00+00:00      0.0    132.0   \n",
              "570         0.0  Post Production 2025-10-17 00:00:00+00:00      0.0    132.0   \n",
              "584         0.0  Post Production 2025-11-20 00:00:00+00:00      0.0    132.0   \n",
              "609         0.0  Post Production 2025-05-21 00:00:00+00:00      0.0    132.0   \n",
              "667         0.0  Post Production 2025-03-21 00:00:00+00:00      0.0    132.0   \n",
              "674         0.0  Post Production 2025-04-02 00:00:00+00:00      0.0    100.0   \n",
              "701         0.0  Post Production 2025-04-16 00:00:00+00:00      0.0    132.0   \n",
              "732         0.0  Post Production 2025-03-06 00:00:00+00:00      0.0    137.0   \n",
              "741         0.0  Post Production 2025-03-13 00:00:00+00:00      0.0    132.0   \n",
              "745         0.0  Post Production 2025-08-06 00:00:00+00:00      0.0    132.0   \n",
              "\n",
              "          budget     imdb_id  ... horror music mystery  romance  \\\n",
              "57    75000000.0  tt10548174  ...    1.0   0.0     0.0      0.0   \n",
              "60    85000000.0  tt27165187  ...    0.0   0.0     0.0      0.0   \n",
              "108   68000000.0  tt17490712  ...    0.0   0.0     0.0      0.0   \n",
              "198   22000000.0  tt25049058  ...    0.0   0.0     0.0      0.0   \n",
              "257   18218260.0  tt27766538  ...    0.0   0.0     0.0      0.0   \n",
              "308  155000000.0  tt11378946  ...    0.0   1.0     0.0      0.0   \n",
              "316   70000000.0  tt32916440  ...    0.0   0.0     0.0      0.0   \n",
              "416   20000000.0  tt31456973  ...    0.0   0.0     0.0      0.0   \n",
              "461   40000000.0  tt22868010  ...    1.0   0.0     1.0      0.0   \n",
              "477  400000000.0   tt1757678  ...    0.0   0.0     0.0      0.0   \n",
              "520   60000000.0  tt30988739  ...    0.0   0.0     0.0      0.0   \n",
              "534   15000000.0  tt32370862  ...    0.0   0.0     0.0      0.0   \n",
              "570   10720500.0  tt31101921  ...    0.0   0.0     0.0      0.0   \n",
              "584  150000000.0  tt19847976  ...    0.0   1.0     0.0      1.0   \n",
              "609  400000000.0   tt9603208  ...    0.0   0.0     0.0      0.0   \n",
              "667   15000000.0  tt23398348  ...    NaN   NaN     NaN      NaN   \n",
              "674  150000000.0   tt3566834  ...    0.0   0.0     0.0      0.0   \n",
              "701   90000000.0  tt31193180  ...    1.0   0.0     0.0      0.0   \n",
              "732  150000000.0  tt12299608  ...    0.0   0.0     0.0      0.0   \n",
              "741  320000000.0   tt7766378  ...    0.0   0.0     0.0      0.0   \n",
              "745  140000000.0  tt30144839  ...    0.0   0.0     0.0      0.0   \n",
              "\n",
              "    science_fiction tv_movie thriller  war western predicted_rating  \n",
              "57              1.0      0.0      0.0  0.0     0.0         3.845231  \n",
              "60              0.0      0.0      1.0  0.0     0.0         5.373774  \n",
              "108             0.0      0.0      0.0  0.0     0.0         5.110221  \n",
              "198             0.0      0.0      0.0  0.0     0.0         7.384965  \n",
              "257             0.0      0.0      0.0  0.0     0.0         5.168054  \n",
              "308             0.0      0.0      0.0  0.0     0.0         6.168319  \n",
              "316             0.0      0.0      0.0  0.0     0.0         6.237243  \n",
              "416             0.0      0.0      1.0  0.0     0.0         4.569636  \n",
              "461             0.0      0.0      0.0  0.0     0.0         5.308178  \n",
              "477             1.0      0.0      0.0  0.0     0.0         4.606920  \n",
              "520             0.0      0.0      1.0  0.0     0.0         5.884254  \n",
              "534             0.0      0.0      0.0  0.0     0.0         5.860930  \n",
              "570             0.0      0.0      0.0  0.0     0.0         6.317752  \n",
              "584             0.0      0.0      0.0  0.0     0.0         6.791449  \n",
              "609             0.0      0.0      1.0  0.0     0.0         5.198944  \n",
              "667             NaN      NaN      NaN  NaN     NaN              NaN  \n",
              "674             0.0      0.0      0.0  0.0     0.0         4.923363  \n",
              "701             0.0      0.0      1.0  0.0     0.0         5.295504  \n",
              "732             1.0      0.0      0.0  0.0     0.0         4.500335  \n",
              "741             1.0      0.0      0.0  0.0     0.0         5.073595  \n",
              "745             0.0      0.0      0.0  0.0     0.0         6.554660  \n",
              "\n",
              "[21 rows x 57 columns]"
            ]
          },
          "execution_count": 13,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df_rated = pd.concat([df_b, train_features], axis=1)\n",
        "\n",
        "df_rated"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 14,
      "metadata": {},
      "outputs": [],
      "source": [
        "df_rated.to_csv(\"movies.csv\", index=False,sep=\";\")"
      ]
    }
  ],
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "display_name": "imdb",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "codemirror_mode": {
        "name": "ipython",
        "version": 3
      },
      "file_extension": ".py",
      "mimetype": "text/x-python",
      "name": "python",
      "nbconvert_exporter": "python",
      "pygments_lexer": "ipython3",
      "version": "3.10.16"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}