Movie_db_cleaning_final.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "7b35a3b2",
   "metadata": {},
   "source": [
    "# Movie Analysis & Extraction"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c32e75a2",
   "metadata": {},
   "source": [
    "### Import Dependencies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "7b068b36",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Data Cleaning\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "from scipy.stats import linregress\n",
    "\n",
    "#Data Visualization\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sn\n",
    "\n",
    "# Data Extraction\n",
    "import requests\n",
    "import json\n",
    "import time\n",
    "from sqlalchemy import create_engine"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "dd9b265f",
   "metadata": {},
   "source": [
    "## Import CSV file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "694749f0",
   "metadata": {},
   "outputs": [],
   "source": [
    "#csv --> df of four sources\n",
    "\n",
    "metacritic_df = pd.read_csv('./Resources/metacritic_movies.csv')\n",
    "mojo_budget_df = pd.read_csv('./Resources/Mojo_budget_data.csv')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "882f3558",
   "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>movie_title</th>\n",
       "      <th>release_date</th>\n",
       "      <th>genre</th>\n",
       "      <th>meta_mixed</th>\n",
       "      <th>meta_negative</th>\n",
       "      <th>meta_positive</th>\n",
       "      <th>metascore</th>\n",
       "      <th>user_mixed</th>\n",
       "      <th>user_negative</th>\n",
       "      <th>user_positive</th>\n",
       "      <th>userscore</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Anatomy of a Murder</td>\n",
       "      <td>1-Jul-59</td>\n",
       "      <td>Drama,Mystery,Thriller,Crime</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>95</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>tbd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Bringing Up Baby</td>\n",
       "      <td>18-Feb-38</td>\n",
       "      <td>Comedy,Romance,Family</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>91</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>tbd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>After Life</td>\n",
       "      <td>12-May-99</td>\n",
       "      <td>Drama,Fantasy</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>91</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>tbd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Gavagai</td>\n",
       "      <td>3-Aug-18</td>\n",
       "      <td>Drama</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>91</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>tbd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>The Hustler</td>\n",
       "      <td>25-Sep-61</td>\n",
       "      <td>Drama,Sport</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>tbd</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9116</th>\n",
       "      <td>Wild Reeds</td>\n",
       "      <td>10-May-95</td>\n",
       "      <td>Drama</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>80</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9117</th>\n",
       "      <td>No Home Movie</td>\n",
       "      <td>1-Apr-16</td>\n",
       "      <td>Documentary</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>78</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>7.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9118</th>\n",
       "      <td>Solas</td>\n",
       "      <td>8-Sep-00</td>\n",
       "      <td>Drama</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>75</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>7.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9119</th>\n",
       "      <td>J.T. Leroy</td>\n",
       "      <td>26-Apr-19</td>\n",
       "      <td>Biography,Drama</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>55</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9120</th>\n",
       "      <td>Donnybrook</td>\n",
       "      <td>15-Feb-19</td>\n",
       "      <td>Drama</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>53</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>5.3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9121 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              movie_title release_date                         genre  \\\n",
       "0     Anatomy of a Murder     1-Jul-59  Drama,Mystery,Thriller,Crime   \n",
       "1        Bringing Up Baby    18-Feb-38         Comedy,Romance,Family   \n",
       "2              After Life    12-May-99                 Drama,Fantasy   \n",
       "3                 Gavagai     3-Aug-18                         Drama   \n",
       "4             The Hustler    25-Sep-61                   Drama,Sport   \n",
       "...                   ...          ...                           ...   \n",
       "9116           Wild Reeds    10-May-95                         Drama   \n",
       "9117        No Home Movie     1-Apr-16                   Documentary   \n",
       "9118                Solas     8-Sep-00                         Drama   \n",
       "9119           J.T. Leroy    26-Apr-19               Biography,Drama   \n",
       "9120           Donnybrook    15-Feb-19                         Drama   \n",
       "\n",
       "      meta_mixed  meta_negative  meta_positive  metascore user_mixed  \\\n",
       "0              0              0             15         95          0   \n",
       "1              0              1             16         91          1   \n",
       "2              0              0             19         91          0   \n",
       "3              1              0              6         91          0   \n",
       "4              1              0             17         90          0   \n",
       "...          ...            ...            ...        ...        ...   \n",
       "9116           2              0             11         80          1   \n",
       "9117           3              0              7         78          1   \n",
       "9118           2              0             14         75          1   \n",
       "9119          13              0             10         55          2   \n",
       "9120           3              4              8         53          1   \n",
       "\n",
       "     user_negative user_positive userscore  \n",
       "0                0             3       tbd  \n",
       "1                0             2       tbd  \n",
       "2                2             1       tbd  \n",
       "3                1             2       tbd  \n",
       "4                0             3       tbd  \n",
       "...            ...           ...       ...  \n",
       "9116             0             3         8  \n",
       "9117             0             3       7.8  \n",
       "9118             0             3       7.5  \n",
       "9119             1             1       5.5  \n",
       "9120             1             2       5.3  \n",
       "\n",
       "[9121 rows x 11 columns]"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "metacritic_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "9ef8edee",
   "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>movie_id</th>\n",
       "      <th>movie_title</th>\n",
       "      <th>movie_year</th>\n",
       "      <th>director</th>\n",
       "      <th>writer</th>\n",
       "      <th>producer</th>\n",
       "      <th>composer</th>\n",
       "      <th>cinematographer</th>\n",
       "      <th>main_actor_1</th>\n",
       "      <th>main_actor_2</th>\n",
       "      <th>...</th>\n",
       "      <th>domestic</th>\n",
       "      <th>international</th>\n",
       "      <th>worldwide</th>\n",
       "      <th>mpaa</th>\n",
       "      <th>run_time</th>\n",
       "      <th>genre_1</th>\n",
       "      <th>genre_2</th>\n",
       "      <th>genre_3</th>\n",
       "      <th>genre_4</th>\n",
       "      <th>link</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>tt0118589</td>\n",
       "      <td>Glitter</td>\n",
       "      <td>2001</td>\n",
       "      <td>Vondie Curtis-Hall</td>\n",
       "      <td>Cheryl L. West</td>\n",
       "      <td>Laurence Mark</td>\n",
       "      <td>Terence Blanchard</td>\n",
       "      <td>Geoffrey Simpson</td>\n",
       "      <td>Mariah Carey</td>\n",
       "      <td>Eric Benét</td>\n",
       "      <td>...</td>\n",
       "      <td>4274407</td>\n",
       "      <td>997259</td>\n",
       "      <td>5271666</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>1 hr 44 min</td>\n",
       "      <td>Drama</td>\n",
       "      <td>Music</td>\n",
       "      <td>Romance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.boxofficemojo.com/title/tt0118589/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>tt0120630</td>\n",
       "      <td>Chicken Run</td>\n",
       "      <td>2000</td>\n",
       "      <td>Peter Lord</td>\n",
       "      <td>Peter Lord</td>\n",
       "      <td>Peter Lord</td>\n",
       "      <td>Harry Gregson-Williams</td>\n",
       "      <td>Simon Jacobs</td>\n",
       "      <td>Mel Gibson</td>\n",
       "      <td>Julia Sawalha</td>\n",
       "      <td>...</td>\n",
       "      <td>106834564</td>\n",
       "      <td>118000000</td>\n",
       "      <td>224834564</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1 hr 24 min</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>Animation</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>Drama</td>\n",
       "      <td>https://www.boxofficemojo.com/title/tt0120630/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>tt0120667</td>\n",
       "      <td>Fantastic Four</td>\n",
       "      <td>2005</td>\n",
       "      <td>Tim Story</td>\n",
       "      <td>Mark Frost</td>\n",
       "      <td>Avi Arad</td>\n",
       "      <td>John Ottman</td>\n",
       "      <td>Oliver Wood</td>\n",
       "      <td>Ioan Gruffudd</td>\n",
       "      <td>Michael Chiklis</td>\n",
       "      <td>...</td>\n",
       "      <td>154696080</td>\n",
       "      <td>178839854</td>\n",
       "      <td>333535934</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>1 hr 46 min</td>\n",
       "      <td>Action</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>Family</td>\n",
       "      <td>Fantasy</td>\n",
       "      <td>https://www.boxofficemojo.com/title/tt0120667/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>tt0120679</td>\n",
       "      <td>Frida</td>\n",
       "      <td>2002</td>\n",
       "      <td>Julie Taymor</td>\n",
       "      <td>Hayden Herrera</td>\n",
       "      <td>Lindsay Flickinger</td>\n",
       "      <td>Elliot Goldenthal</td>\n",
       "      <td>Rodrigo Prieto</td>\n",
       "      <td>Salma Hayek</td>\n",
       "      <td>Alfred Molina</td>\n",
       "      <td>...</td>\n",
       "      <td>25885000</td>\n",
       "      <td>30413474</td>\n",
       "      <td>56298474</td>\n",
       "      <td>R</td>\n",
       "      <td>2 hr 3 min</td>\n",
       "      <td>Biography</td>\n",
       "      <td>Drama</td>\n",
       "      <td>Romance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.boxofficemojo.com/title/tt0120679/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>tt0120681</td>\n",
       "      <td>From Hell</td>\n",
       "      <td>2001</td>\n",
       "      <td>Albert Hughes</td>\n",
       "      <td>Alan Moore</td>\n",
       "      <td>Jane Hamsher</td>\n",
       "      <td>Trevor Jones</td>\n",
       "      <td>Peter Deming</td>\n",
       "      <td>Johnny Depp</td>\n",
       "      <td>Heather Graham</td>\n",
       "      <td>...</td>\n",
       "      <td>31602566</td>\n",
       "      <td>42955549</td>\n",
       "      <td>74558115</td>\n",
       "      <td>R</td>\n",
       "      <td>2 hr 2 min</td>\n",
       "      <td>Horror</td>\n",
       "      <td>Mystery</td>\n",
       "      <td>Thriller</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.boxofficemojo.com/title/tt0120681/...</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>2471</th>\n",
       "      <td>tt8688634</td>\n",
       "      <td>21 Bridges</td>\n",
       "      <td>2019</td>\n",
       "      <td>Brian Kirk</td>\n",
       "      <td>Adam Mervis</td>\n",
       "      <td>Chadwick Boseman</td>\n",
       "      <td>Alex Belcher</td>\n",
       "      <td>Paul Cameron</td>\n",
       "      <td>Chadwick Boseman</td>\n",
       "      <td>Sienna Miller</td>\n",
       "      <td>...</td>\n",
       "      <td>28539757</td>\n",
       "      <td>21400000</td>\n",
       "      <td>49939757</td>\n",
       "      <td>R</td>\n",
       "      <td>1 hr 39 min</td>\n",
       "      <td>Action</td>\n",
       "      <td>Crime</td>\n",
       "      <td>Drama</td>\n",
       "      <td>Thriller</td>\n",
       "      <td>https://www.boxofficemojo.com/title/tt8688634/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2472</th>\n",
       "      <td>tt8946378</td>\n",
       "      <td>Knives Out</td>\n",
       "      <td>2019</td>\n",
       "      <td>Rian Johnson</td>\n",
       "      <td>Rian Johnson</td>\n",
       "      <td>Ram Bergman</td>\n",
       "      <td>Nathan Johnson</td>\n",
       "      <td>Steve Yedlin</td>\n",
       "      <td>Daniel Craig</td>\n",
       "      <td>Chris Evans</td>\n",
       "      <td>...</td>\n",
       "      <td>165363234</td>\n",
       "      <td>146189956</td>\n",
       "      <td>311553190</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>2 hr 11 min</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>Crime</td>\n",
       "      <td>Drama</td>\n",
       "      <td>Mystery</td>\n",
       "      <td>https://www.boxofficemojo.com/title/tt8946378/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2473</th>\n",
       "      <td>tt9024106</td>\n",
       "      <td>Unplanned</td>\n",
       "      <td>2019</td>\n",
       "      <td>Chuck Konzelman</td>\n",
       "      <td>Abby Johnson</td>\n",
       "      <td>Chris Jones</td>\n",
       "      <td>Stephen Blake Kanicka</td>\n",
       "      <td>Drew Maw</td>\n",
       "      <td>Ashley Bratcher</td>\n",
       "      <td>Brooks Ryan</td>\n",
       "      <td>...</td>\n",
       "      <td>19005109</td>\n",
       "      <td>2046806</td>\n",
       "      <td>21051915</td>\n",
       "      <td>R</td>\n",
       "      <td>1 hr 49 min</td>\n",
       "      <td>Biography</td>\n",
       "      <td>Drama</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.boxofficemojo.com/title/tt9024106/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2474</th>\n",
       "      <td>tt9134216</td>\n",
       "      <td>Playing with Fire</td>\n",
       "      <td>2019</td>\n",
       "      <td>Andy Fickman</td>\n",
       "      <td>Dan Ewen</td>\n",
       "      <td>Todd Garner</td>\n",
       "      <td>Nathan Wang</td>\n",
       "      <td>Dean Semler</td>\n",
       "      <td>John Cena</td>\n",
       "      <td>Keegan-Michael Key</td>\n",
       "      <td>...</td>\n",
       "      <td>44451847</td>\n",
       "      <td>24179822</td>\n",
       "      <td>68631669</td>\n",
       "      <td>PG</td>\n",
       "      <td>1 hr 36 min</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.boxofficemojo.com/title/tt9134216/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2475</th>\n",
       "      <td>tt9173418</td>\n",
       "      <td>Brahms: The Boy II</td>\n",
       "      <td>2020</td>\n",
       "      <td>William Brent Bell</td>\n",
       "      <td>Stacey Menear</td>\n",
       "      <td>Matt Berenson</td>\n",
       "      <td>Brett Detar</td>\n",
       "      <td>Karl Walter Lindenlaub</td>\n",
       "      <td>Katie Holmes</td>\n",
       "      <td>Owain Yeoman</td>\n",
       "      <td>...</td>\n",
       "      <td>12611536</td>\n",
       "      <td>7700000</td>\n",
       "      <td>20311536</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>1 hr 26 min</td>\n",
       "      <td>Drama</td>\n",
       "      <td>Horror</td>\n",
       "      <td>Mystery</td>\n",
       "      <td>Thriller</td>\n",
       "      <td>https://www.boxofficemojo.com/title/tt9173418/...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2476 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       movie_id         movie_title  movie_year            director  \\\n",
       "0     tt0118589             Glitter        2001  Vondie Curtis-Hall   \n",
       "1     tt0120630         Chicken Run        2000          Peter Lord   \n",
       "2     tt0120667      Fantastic Four        2005           Tim Story   \n",
       "3     tt0120679               Frida        2002        Julie Taymor   \n",
       "4     tt0120681           From Hell        2001       Albert Hughes   \n",
       "...         ...                 ...         ...                 ...   \n",
       "2471  tt8688634          21 Bridges        2019          Brian Kirk   \n",
       "2472  tt8946378          Knives Out        2019        Rian Johnson   \n",
       "2473  tt9024106           Unplanned        2019     Chuck Konzelman   \n",
       "2474  tt9134216   Playing with Fire        2019        Andy Fickman   \n",
       "2475  tt9173418  Brahms: The Boy II        2020  William Brent Bell   \n",
       "\n",
       "              writer            producer                composer  \\\n",
       "0     Cheryl L. West       Laurence Mark       Terence Blanchard   \n",
       "1         Peter Lord          Peter Lord  Harry Gregson-Williams   \n",
       "2         Mark Frost            Avi Arad             John Ottman   \n",
       "3     Hayden Herrera  Lindsay Flickinger       Elliot Goldenthal   \n",
       "4         Alan Moore        Jane Hamsher            Trevor Jones   \n",
       "...              ...                 ...                     ...   \n",
       "2471     Adam Mervis    Chadwick Boseman            Alex Belcher   \n",
       "2472    Rian Johnson         Ram Bergman          Nathan Johnson   \n",
       "2473    Abby Johnson         Chris Jones   Stephen Blake Kanicka   \n",
       "2474        Dan Ewen         Todd Garner             Nathan Wang   \n",
       "2475   Stacey Menear       Matt Berenson             Brett Detar   \n",
       "\n",
       "             cinematographer      main_actor_1        main_actor_2  ...  \\\n",
       "0           Geoffrey Simpson      Mariah Carey          Eric Benét  ...   \n",
       "1               Simon Jacobs        Mel Gibson       Julia Sawalha  ...   \n",
       "2                Oliver Wood     Ioan Gruffudd     Michael Chiklis  ...   \n",
       "3             Rodrigo Prieto       Salma Hayek       Alfred Molina  ...   \n",
       "4               Peter Deming       Johnny Depp      Heather Graham  ...   \n",
       "...                      ...               ...                 ...  ...   \n",
       "2471            Paul Cameron  Chadwick Boseman       Sienna Miller  ...   \n",
       "2472            Steve Yedlin      Daniel Craig         Chris Evans  ...   \n",
       "2473                Drew Maw   Ashley Bratcher         Brooks Ryan  ...   \n",
       "2474             Dean Semler         John Cena  Keegan-Michael Key  ...   \n",
       "2475  Karl Walter Lindenlaub      Katie Holmes        Owain Yeoman  ...   \n",
       "\n",
       "       domestic international  worldwide   mpaa     run_time    genre_1  \\\n",
       "0       4274407        997259    5271666  PG-13  1 hr 44 min      Drama   \n",
       "1     106834564     118000000  224834564    NaN  1 hr 24 min  Adventure   \n",
       "2     154696080     178839854  333535934  PG-13  1 hr 46 min     Action   \n",
       "3      25885000      30413474   56298474      R   2 hr 3 min  Biography   \n",
       "4      31602566      42955549   74558115      R   2 hr 2 min     Horror   \n",
       "...         ...           ...        ...    ...          ...        ...   \n",
       "2471   28539757      21400000   49939757      R  1 hr 39 min     Action   \n",
       "2472  165363234     146189956  311553190  PG-13  2 hr 11 min     Comedy   \n",
       "2473   19005109       2046806   21051915      R  1 hr 49 min  Biography   \n",
       "2474   44451847      24179822   68631669     PG  1 hr 36 min     Comedy   \n",
       "2475   12611536       7700000   20311536  PG-13  1 hr 26 min      Drama   \n",
       "\n",
       "        genre_2   genre_3   genre_4  \\\n",
       "0         Music   Romance       NaN   \n",
       "1     Animation    Comedy     Drama   \n",
       "2     Adventure    Family   Fantasy   \n",
       "3         Drama   Romance       NaN   \n",
       "4       Mystery  Thriller       NaN   \n",
       "...         ...       ...       ...   \n",
       "2471      Crime     Drama  Thriller   \n",
       "2472      Crime     Drama   Mystery   \n",
       "2473      Drama       NaN       NaN   \n",
       "2474     Family       NaN       NaN   \n",
       "2475     Horror   Mystery  Thriller   \n",
       "\n",
       "                                                   link  \n",
       "0     https://www.boxofficemojo.com/title/tt0118589/...  \n",
       "1     https://www.boxofficemojo.com/title/tt0120630/...  \n",
       "2     https://www.boxofficemojo.com/title/tt0120667/...  \n",
       "3     https://www.boxofficemojo.com/title/tt0120679/...  \n",
       "4     https://www.boxofficemojo.com/title/tt0120681/...  \n",
       "...                                                 ...  \n",
       "2471  https://www.boxofficemojo.com/title/tt8688634/...  \n",
       "2472  https://www.boxofficemojo.com/title/tt8946378/...  \n",
       "2473  https://www.boxofficemojo.com/title/tt9024106/...  \n",
       "2474  https://www.boxofficemojo.com/title/tt9134216/...  \n",
       "2475  https://www.boxofficemojo.com/title/tt9173418/...  \n",
       "\n",
       "[2476 rows x 23 columns]"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mojo_budget_df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6a4e945e",
   "metadata": {},
   "source": [
    "### CSV Data Cleaning"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "70e18a1a",
   "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>movie_title</th>\n",
       "      <th>movie_year</th>\n",
       "      <th>budget</th>\n",
       "      <th>domestic</th>\n",
       "      <th>international</th>\n",
       "      <th>worldwide</th>\n",
       "      <th>mpaa</th>\n",
       "      <th>run_time</th>\n",
       "      <th>genre_1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Glitter</td>\n",
       "      <td>2001</td>\n",
       "      <td>22000000</td>\n",
       "      <td>4274407</td>\n",
       "      <td>997259</td>\n",
       "      <td>5271666</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>1 hr 44 min</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Chicken Run</td>\n",
       "      <td>2000</td>\n",
       "      <td>45000000</td>\n",
       "      <td>106834564</td>\n",
       "      <td>118000000</td>\n",
       "      <td>224834564</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1 hr 24 min</td>\n",
       "      <td>Adventure</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Fantastic Four</td>\n",
       "      <td>2005</td>\n",
       "      <td>100000000</td>\n",
       "      <td>154696080</td>\n",
       "      <td>178839854</td>\n",
       "      <td>333535934</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>1 hr 46 min</td>\n",
       "      <td>Action</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Frida</td>\n",
       "      <td>2002</td>\n",
       "      <td>12000000</td>\n",
       "      <td>25885000</td>\n",
       "      <td>30413474</td>\n",
       "      <td>56298474</td>\n",
       "      <td>R</td>\n",
       "      <td>2 hr 3 min</td>\n",
       "      <td>Biography</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>From Hell</td>\n",
       "      <td>2001</td>\n",
       "      <td>35000000</td>\n",
       "      <td>31602566</td>\n",
       "      <td>42955549</td>\n",
       "      <td>74558115</td>\n",
       "      <td>R</td>\n",
       "      <td>2 hr 2 min</td>\n",
       "      <td>Horror</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2471</th>\n",
       "      <td>21 Bridges</td>\n",
       "      <td>2019</td>\n",
       "      <td>33000000</td>\n",
       "      <td>28539757</td>\n",
       "      <td>21400000</td>\n",
       "      <td>49939757</td>\n",
       "      <td>R</td>\n",
       "      <td>1 hr 39 min</td>\n",
       "      <td>Action</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2472</th>\n",
       "      <td>Knives Out</td>\n",
       "      <td>2019</td>\n",
       "      <td>40000000</td>\n",
       "      <td>165363234</td>\n",
       "      <td>146189956</td>\n",
       "      <td>311553190</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>2 hr 11 min</td>\n",
       "      <td>Comedy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2473</th>\n",
       "      <td>Unplanned</td>\n",
       "      <td>2019</td>\n",
       "      <td>6000000</td>\n",
       "      <td>19005109</td>\n",
       "      <td>2046806</td>\n",
       "      <td>21051915</td>\n",
       "      <td>R</td>\n",
       "      <td>1 hr 49 min</td>\n",
       "      <td>Biography</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2474</th>\n",
       "      <td>Playing with Fire</td>\n",
       "      <td>2019</td>\n",
       "      <td>29900000</td>\n",
       "      <td>44451847</td>\n",
       "      <td>24179822</td>\n",
       "      <td>68631669</td>\n",
       "      <td>PG</td>\n",
       "      <td>1 hr 36 min</td>\n",
       "      <td>Comedy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2475</th>\n",
       "      <td>Brahms: The Boy II</td>\n",
       "      <td>2020</td>\n",
       "      <td>10000000</td>\n",
       "      <td>12611536</td>\n",
       "      <td>7700000</td>\n",
       "      <td>20311536</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>1 hr 26 min</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2476 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             movie_title  movie_year     budget   domestic  international  \\\n",
       "0                Glitter        2001   22000000    4274407         997259   \n",
       "1            Chicken Run        2000   45000000  106834564      118000000   \n",
       "2         Fantastic Four        2005  100000000  154696080      178839854   \n",
       "3                  Frida        2002   12000000   25885000       30413474   \n",
       "4              From Hell        2001   35000000   31602566       42955549   \n",
       "...                  ...         ...        ...        ...            ...   \n",
       "2471          21 Bridges        2019   33000000   28539757       21400000   \n",
       "2472          Knives Out        2019   40000000  165363234      146189956   \n",
       "2473           Unplanned        2019    6000000   19005109        2046806   \n",
       "2474   Playing with Fire        2019   29900000   44451847       24179822   \n",
       "2475  Brahms: The Boy II        2020   10000000   12611536        7700000   \n",
       "\n",
       "      worldwide   mpaa     run_time    genre_1  \n",
       "0       5271666  PG-13  1 hr 44 min      Drama  \n",
       "1     224834564    NaN  1 hr 24 min  Adventure  \n",
       "2     333535934  PG-13  1 hr 46 min     Action  \n",
       "3      56298474      R   2 hr 3 min  Biography  \n",
       "4      74558115      R   2 hr 2 min     Horror  \n",
       "...         ...    ...          ...        ...  \n",
       "2471   49939757      R  1 hr 39 min     Action  \n",
       "2472  311553190  PG-13  2 hr 11 min     Comedy  \n",
       "2473   21051915      R  1 hr 49 min  Biography  \n",
       "2474   68631669     PG  1 hr 36 min     Comedy  \n",
       "2475   20311536  PG-13  1 hr 26 min      Drama  \n",
       "\n",
       "[2476 rows x 9 columns]"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#dropping columns with irrelevant data\n",
    "\n",
    "cleaned_mojo_df= mojo_budget_df.drop(columns= ['movie_id','director', 'writer', 'producer', 'composer', 'cinematographer', 'main_actor_1', 'main_actor_2', 'main_actor_3', 'main_actor_4', 'genre_2', 'genre_3', 'genre_4', 'link' ])\n",
    "\n",
    "cleaned_mojo_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "fb2cfea4",
   "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>movie_title</th>\n",
       "      <th>release_date</th>\n",
       "      <th>genre</th>\n",
       "      <th>meta_mixed</th>\n",
       "      <th>meta_negative</th>\n",
       "      <th>meta_positive</th>\n",
       "      <th>metascore</th>\n",
       "      <th>user_mixed</th>\n",
       "      <th>user_negative</th>\n",
       "      <th>user_positive</th>\n",
       "      <th>userscore</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Anatomy of a Murder</td>\n",
       "      <td>1-Jul-59</td>\n",
       "      <td>Drama,Mystery,Thriller,Crime</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>95</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>tbd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Bringing Up Baby</td>\n",
       "      <td>18-Feb-38</td>\n",
       "      <td>Comedy,Romance,Family</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>91</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>tbd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>After Life</td>\n",
       "      <td>12-May-99</td>\n",
       "      <td>Drama,Fantasy</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>91</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>tbd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Gavagai</td>\n",
       "      <td>3-Aug-18</td>\n",
       "      <td>Drama</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>91</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>tbd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>The Hustler</td>\n",
       "      <td>25-Sep-61</td>\n",
       "      <td>Drama,Sport</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>tbd</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9116</th>\n",
       "      <td>Wild Reeds</td>\n",
       "      <td>10-May-95</td>\n",
       "      <td>Drama</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>80</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9117</th>\n",
       "      <td>No Home Movie</td>\n",
       "      <td>1-Apr-16</td>\n",
       "      <td>Documentary</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>78</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>7.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9118</th>\n",
       "      <td>Solas</td>\n",
       "      <td>8-Sep-00</td>\n",
       "      <td>Drama</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>75</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>7.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9119</th>\n",
       "      <td>J.T. Leroy</td>\n",
       "      <td>26-Apr-19</td>\n",
       "      <td>Biography,Drama</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>55</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9120</th>\n",
       "      <td>Donnybrook</td>\n",
       "      <td>15-Feb-19</td>\n",
       "      <td>Drama</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>53</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>5.3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9121 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              movie_title release_date                         genre  \\\n",
       "0     Anatomy of a Murder     1-Jul-59  Drama,Mystery,Thriller,Crime   \n",
       "1        Bringing Up Baby    18-Feb-38         Comedy,Romance,Family   \n",
       "2              After Life    12-May-99                 Drama,Fantasy   \n",
       "3                 Gavagai     3-Aug-18                         Drama   \n",
       "4             The Hustler    25-Sep-61                   Drama,Sport   \n",
       "...                   ...          ...                           ...   \n",
       "9116           Wild Reeds    10-May-95                         Drama   \n",
       "9117        No Home Movie     1-Apr-16                   Documentary   \n",
       "9118                Solas     8-Sep-00                         Drama   \n",
       "9119           J.T. Leroy    26-Apr-19               Biography,Drama   \n",
       "9120           Donnybrook    15-Feb-19                         Drama   \n",
       "\n",
       "      meta_mixed  meta_negative  meta_positive  metascore user_mixed  \\\n",
       "0              0              0             15         95          0   \n",
       "1              0              1             16         91          1   \n",
       "2              0              0             19         91          0   \n",
       "3              1              0              6         91          0   \n",
       "4              1              0             17         90          0   \n",
       "...          ...            ...            ...        ...        ...   \n",
       "9116           2              0             11         80          1   \n",
       "9117           3              0              7         78          1   \n",
       "9118           2              0             14         75          1   \n",
       "9119          13              0             10         55          2   \n",
       "9120           3              4              8         53          1   \n",
       "\n",
       "     user_negative user_positive userscore  \n",
       "0                0             3       tbd  \n",
       "1                0             2       tbd  \n",
       "2                2             1       tbd  \n",
       "3                1             2       tbd  \n",
       "4                0             3       tbd  \n",
       "...            ...           ...       ...  \n",
       "9116             0             3         8  \n",
       "9117             0             3       7.8  \n",
       "9118             0             3       7.5  \n",
       "9119             1             1       5.5  \n",
       "9120             1             2       5.3  \n",
       "\n",
       "[9121 rows x 11 columns]"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "metacritic_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "ca44e743",
   "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>movie_title</th>\n",
       "      <th>meta_mixed</th>\n",
       "      <th>meta_negative</th>\n",
       "      <th>meta_positive</th>\n",
       "      <th>metascore</th>\n",
       "      <th>user_mixed</th>\n",
       "      <th>user_negative</th>\n",
       "      <th>user_positive</th>\n",
       "      <th>userscore</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Anatomy of a Murder</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>95</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>tbd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Bringing Up Baby</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>91</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>tbd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>After Life</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>91</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>tbd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Gavagai</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>91</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>tbd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>The Hustler</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>tbd</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9116</th>\n",
       "      <td>Wild Reeds</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>80</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9117</th>\n",
       "      <td>No Home Movie</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>78</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>7.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9118</th>\n",
       "      <td>Solas</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>75</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>7.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9119</th>\n",
       "      <td>J.T. Leroy</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>55</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9120</th>\n",
       "      <td>Donnybrook</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>53</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>5.3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9121 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              movie_title  meta_mixed  meta_negative  meta_positive  \\\n",
       "0     Anatomy of a Murder           0              0             15   \n",
       "1        Bringing Up Baby           0              1             16   \n",
       "2              After Life           0              0             19   \n",
       "3                 Gavagai           1              0              6   \n",
       "4             The Hustler           1              0             17   \n",
       "...                   ...         ...            ...            ...   \n",
       "9116           Wild Reeds           2              0             11   \n",
       "9117        No Home Movie           3              0              7   \n",
       "9118                Solas           2              0             14   \n",
       "9119           J.T. Leroy          13              0             10   \n",
       "9120           Donnybrook           3              4              8   \n",
       "\n",
       "      metascore user_mixed user_negative user_positive userscore  \n",
       "0            95          0             0             3       tbd  \n",
       "1            91          1             0             2       tbd  \n",
       "2            91          0             2             1       tbd  \n",
       "3            91          0             1             2       tbd  \n",
       "4            90          0             0             3       tbd  \n",
       "...         ...        ...           ...           ...       ...  \n",
       "9116         80          1             0             3         8  \n",
       "9117         78          1             0             3       7.8  \n",
       "9118         75          1             0             3       7.5  \n",
       "9119         55          2             1             1       5.5  \n",
       "9120         53          1             1             2       5.3  \n",
       "\n",
       "[9121 rows x 9 columns]"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cleaned_metacritic_df= metacritic_df.drop(columns= ['release_date', 'genre'])\n",
    "cleaned_metacritic_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "6afadf99",
   "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>movie_title</th>\n",
       "      <th>movie_year</th>\n",
       "      <th>budget</th>\n",
       "      <th>domestic</th>\n",
       "      <th>international</th>\n",
       "      <th>worldwide</th>\n",
       "      <th>mpaa</th>\n",
       "      <th>run_time</th>\n",
       "      <th>genre_1</th>\n",
       "      <th>meta_mixed</th>\n",
       "      <th>meta_negative</th>\n",
       "      <th>meta_positive</th>\n",
       "      <th>metascore</th>\n",
       "      <th>user_mixed</th>\n",
       "      <th>user_negative</th>\n",
       "      <th>user_positive</th>\n",
       "      <th>userscore</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Glitter</td>\n",
       "      <td>2001</td>\n",
       "      <td>22000000</td>\n",
       "      <td>4274407</td>\n",
       "      <td>997259</td>\n",
       "      <td>5271666</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>1 hr 44 min</td>\n",
       "      <td>Drama</td>\n",
       "      <td>3.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>9</td>\n",
       "      <td>59</td>\n",
       "      <td>31</td>\n",
       "      <td>3.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Chicken Run</td>\n",
       "      <td>2000</td>\n",
       "      <td>45000000</td>\n",
       "      <td>106834564</td>\n",
       "      <td>118000000</td>\n",
       "      <td>224834564</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1 hr 24 min</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>36</td>\n",
       "      <td>9</td>\n",
       "      <td>258</td>\n",
       "      <td>8.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Fantastic Four</td>\n",
       "      <td>2005</td>\n",
       "      <td>100000000</td>\n",
       "      <td>154696080</td>\n",
       "      <td>178839854</td>\n",
       "      <td>333535934</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>1 hr 46 min</td>\n",
       "      <td>Action</td>\n",
       "      <td>18.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>161</td>\n",
       "      <td>177</td>\n",
       "      <td>305</td>\n",
       "      <td>5.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Fantastic Four</td>\n",
       "      <td>2005</td>\n",
       "      <td>100000000</td>\n",
       "      <td>154696080</td>\n",
       "      <td>178839854</td>\n",
       "      <td>333535934</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>1 hr 46 min</td>\n",
       "      <td>Action</td>\n",
       "      <td>18.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>176</td>\n",
       "      <td>627</td>\n",
       "      <td>109</td>\n",
       "      <td>2.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Frida</td>\n",
       "      <td>2002</td>\n",
       "      <td>12000000</td>\n",
       "      <td>25885000</td>\n",
       "      <td>30413474</td>\n",
       "      <td>56298474</td>\n",
       "      <td>R</td>\n",
       "      <td>2 hr 3 min</td>\n",
       "      <td>Biography</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>34</td>\n",
       "      <td>7.4</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2580</th>\n",
       "      <td>21 Bridges</td>\n",
       "      <td>2019</td>\n",
       "      <td>33000000</td>\n",
       "      <td>28539757</td>\n",
       "      <td>21400000</td>\n",
       "      <td>49939757</td>\n",
       "      <td>R</td>\n",
       "      <td>1 hr 39 min</td>\n",
       "      <td>Action</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>2581</th>\n",
       "      <td>Knives Out</td>\n",
       "      <td>2019</td>\n",
       "      <td>40000000</td>\n",
       "      <td>165363234</td>\n",
       "      <td>146189956</td>\n",
       "      <td>311553190</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>2 hr 11 min</td>\n",
       "      <td>Comedy</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>2582</th>\n",
       "      <td>Unplanned</td>\n",
       "      <td>2019</td>\n",
       "      <td>6000000</td>\n",
       "      <td>19005109</td>\n",
       "      <td>2046806</td>\n",
       "      <td>21051915</td>\n",
       "      <td>R</td>\n",
       "      <td>1 hr 49 min</td>\n",
       "      <td>Biography</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1</td>\n",
       "      <td>51</td>\n",
       "      <td>687</td>\n",
       "      <td>9.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2583</th>\n",
       "      <td>Playing with Fire</td>\n",
       "      <td>2019</td>\n",
       "      <td>29900000</td>\n",
       "      <td>44451847</td>\n",
       "      <td>24179822</td>\n",
       "      <td>68631669</td>\n",
       "      <td>PG</td>\n",
       "      <td>1 hr 36 min</td>\n",
       "      <td>Comedy</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>2584</th>\n",
       "      <td>Brahms: The Boy II</td>\n",
       "      <td>2020</td>\n",
       "      <td>10000000</td>\n",
       "      <td>12611536</td>\n",
       "      <td>7700000</td>\n",
       "      <td>20311536</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>1 hr 26 min</td>\n",
       "      <td>Drama</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",
       "  </tbody>\n",
       "</table>\n",
       "<p>2585 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             movie_title  movie_year     budget   domestic  international  \\\n",
       "0                Glitter        2001   22000000    4274407         997259   \n",
       "1            Chicken Run        2000   45000000  106834564      118000000   \n",
       "2         Fantastic Four        2005  100000000  154696080      178839854   \n",
       "3         Fantastic Four        2005  100000000  154696080      178839854   \n",
       "4                  Frida        2002   12000000   25885000       30413474   \n",
       "...                  ...         ...        ...        ...            ...   \n",
       "2580          21 Bridges        2019   33000000   28539757       21400000   \n",
       "2581          Knives Out        2019   40000000  165363234      146189956   \n",
       "2582           Unplanned        2019    6000000   19005109        2046806   \n",
       "2583   Playing with Fire        2019   29900000   44451847       24179822   \n",
       "2584  Brahms: The Boy II        2020   10000000   12611536        7700000   \n",
       "\n",
       "      worldwide   mpaa     run_time    genre_1  meta_mixed  meta_negative  \\\n",
       "0       5271666  PG-13  1 hr 44 min      Drama         3.0           20.0   \n",
       "1     224834564    NaN  1 hr 24 min  Adventure         1.0            0.0   \n",
       "2     333535934  PG-13  1 hr 46 min     Action        18.0           11.0   \n",
       "3     333535934  PG-13  1 hr 46 min     Action        18.0           21.0   \n",
       "4      56298474      R   2 hr 3 min  Biography        17.0            1.0   \n",
       "...         ...    ...          ...        ...         ...            ...   \n",
       "2580   49939757      R  1 hr 39 min     Action         NaN            NaN   \n",
       "2581  311553190  PG-13  2 hr 11 min     Comedy         NaN            NaN   \n",
       "2582   21051915      R  1 hr 49 min  Biography         1.0            6.0   \n",
       "2583   68631669     PG  1 hr 36 min     Comedy         NaN            NaN   \n",
       "2584   20311536  PG-13  1 hr 26 min      Drama         NaN            NaN   \n",
       "\n",
       "      meta_positive  metascore user_mixed user_negative user_positive  \\\n",
       "0               0.0       14.0          9            59            31   \n",
       "1              33.0       88.0         36             9           258   \n",
       "2               6.0       40.0        161           177           305   \n",
       "3               1.0       27.0        176           627           109   \n",
       "4              20.0       61.0          4             2            34   \n",
       "...             ...        ...        ...           ...           ...   \n",
       "2580            NaN        NaN        NaN           NaN           NaN   \n",
       "2581            NaN        NaN        NaN           NaN           NaN   \n",
       "2582            0.0       10.0          1            51           687   \n",
       "2583            NaN        NaN        NaN           NaN           NaN   \n",
       "2584            NaN        NaN        NaN           NaN           NaN   \n",
       "\n",
       "     userscore  \n",
       "0          3.6  \n",
       "1          8.2  \n",
       "2          5.7  \n",
       "3          2.6  \n",
       "4          7.4  \n",
       "...        ...  \n",
       "2580       NaN  \n",
       "2581       NaN  \n",
       "2582       9.3  \n",
       "2583       NaN  \n",
       "2584       NaN  \n",
       "\n",
       "[2585 rows x 17 columns]"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Merge dfs on movie_title\n",
    "movie_db_df = pd.merge(cleaned_mojo_df, cleaned_metacritic_df, how=\"left\", on=\"movie_title\")\n",
    "movie_db_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "86a113a8",
   "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>movie_title</th>\n",
       "      <th>movie_year</th>\n",
       "      <th>budget</th>\n",
       "      <th>domestic</th>\n",
       "      <th>international</th>\n",
       "      <th>worldwide</th>\n",
       "      <th>mpaa</th>\n",
       "      <th>run_time</th>\n",
       "      <th>genre_1</th>\n",
       "      <th>meta_mixed</th>\n",
       "      <th>meta_negative</th>\n",
       "      <th>meta_positive</th>\n",
       "      <th>metascore</th>\n",
       "      <th>user_mixed</th>\n",
       "      <th>user_negative</th>\n",
       "      <th>user_positive</th>\n",
       "      <th>userscore</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Glitter</td>\n",
       "      <td>2001</td>\n",
       "      <td>22000000</td>\n",
       "      <td>4274407</td>\n",
       "      <td>997259</td>\n",
       "      <td>5271666</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>1 hr 44 min</td>\n",
       "      <td>Drama</td>\n",
       "      <td>3.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>9</td>\n",
       "      <td>59</td>\n",
       "      <td>31</td>\n",
       "      <td>3.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Chicken Run</td>\n",
       "      <td>2000</td>\n",
       "      <td>45000000</td>\n",
       "      <td>106834564</td>\n",
       "      <td>118000000</td>\n",
       "      <td>224834564</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1 hr 24 min</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>36</td>\n",
       "      <td>9</td>\n",
       "      <td>258</td>\n",
       "      <td>8.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Fantastic Four</td>\n",
       "      <td>2005</td>\n",
       "      <td>100000000</td>\n",
       "      <td>154696080</td>\n",
       "      <td>178839854</td>\n",
       "      <td>333535934</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>1 hr 46 min</td>\n",
       "      <td>Action</td>\n",
       "      <td>18.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>161</td>\n",
       "      <td>177</td>\n",
       "      <td>305</td>\n",
       "      <td>5.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Frida</td>\n",
       "      <td>2002</td>\n",
       "      <td>12000000</td>\n",
       "      <td>25885000</td>\n",
       "      <td>30413474</td>\n",
       "      <td>56298474</td>\n",
       "      <td>R</td>\n",
       "      <td>2 hr 3 min</td>\n",
       "      <td>Biography</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>34</td>\n",
       "      <td>7.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>From Hell</td>\n",
       "      <td>2001</td>\n",
       "      <td>35000000</td>\n",
       "      <td>31602566</td>\n",
       "      <td>42955549</td>\n",
       "      <td>74558115</td>\n",
       "      <td>R</td>\n",
       "      <td>2 hr 2 min</td>\n",
       "      <td>Horror</td>\n",
       "      <td>10.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>23</td>\n",
       "      <td>37</td>\n",
       "      <td>54</td>\n",
       "      <td>5.2</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2580</th>\n",
       "      <td>21 Bridges</td>\n",
       "      <td>2019</td>\n",
       "      <td>33000000</td>\n",
       "      <td>28539757</td>\n",
       "      <td>21400000</td>\n",
       "      <td>49939757</td>\n",
       "      <td>R</td>\n",
       "      <td>1 hr 39 min</td>\n",
       "      <td>Action</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>2581</th>\n",
       "      <td>Knives Out</td>\n",
       "      <td>2019</td>\n",
       "      <td>40000000</td>\n",
       "      <td>165363234</td>\n",
       "      <td>146189956</td>\n",
       "      <td>311553190</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>2 hr 11 min</td>\n",
       "      <td>Comedy</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>2582</th>\n",
       "      <td>Unplanned</td>\n",
       "      <td>2019</td>\n",
       "      <td>6000000</td>\n",
       "      <td>19005109</td>\n",
       "      <td>2046806</td>\n",
       "      <td>21051915</td>\n",
       "      <td>R</td>\n",
       "      <td>1 hr 49 min</td>\n",
       "      <td>Biography</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1</td>\n",
       "      <td>51</td>\n",
       "      <td>687</td>\n",
       "      <td>9.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2583</th>\n",
       "      <td>Playing with Fire</td>\n",
       "      <td>2019</td>\n",
       "      <td>29900000</td>\n",
       "      <td>44451847</td>\n",
       "      <td>24179822</td>\n",
       "      <td>68631669</td>\n",
       "      <td>PG</td>\n",
       "      <td>1 hr 36 min</td>\n",
       "      <td>Comedy</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>2584</th>\n",
       "      <td>Brahms: The Boy II</td>\n",
       "      <td>2020</td>\n",
       "      <td>10000000</td>\n",
       "      <td>12611536</td>\n",
       "      <td>7700000</td>\n",
       "      <td>20311536</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>1 hr 26 min</td>\n",
       "      <td>Drama</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",
       "  </tbody>\n",
       "</table>\n",
       "<p>2475 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             movie_title  movie_year     budget   domestic  international  \\\n",
       "0                Glitter        2001   22000000    4274407         997259   \n",
       "1            Chicken Run        2000   45000000  106834564      118000000   \n",
       "2         Fantastic Four        2005  100000000  154696080      178839854   \n",
       "4                  Frida        2002   12000000   25885000       30413474   \n",
       "5              From Hell        2001   35000000   31602566       42955549   \n",
       "...                  ...         ...        ...        ...            ...   \n",
       "2580          21 Bridges        2019   33000000   28539757       21400000   \n",
       "2581          Knives Out        2019   40000000  165363234      146189956   \n",
       "2582           Unplanned        2019    6000000   19005109        2046806   \n",
       "2583   Playing with Fire        2019   29900000   44451847       24179822   \n",
       "2584  Brahms: The Boy II        2020   10000000   12611536        7700000   \n",
       "\n",
       "      worldwide   mpaa     run_time    genre_1  meta_mixed  meta_negative  \\\n",
       "0       5271666  PG-13  1 hr 44 min      Drama         3.0           20.0   \n",
       "1     224834564    NaN  1 hr 24 min  Adventure         1.0            0.0   \n",
       "2     333535934  PG-13  1 hr 46 min     Action        18.0           11.0   \n",
       "4      56298474      R   2 hr 3 min  Biography        17.0            1.0   \n",
       "5      74558115      R   2 hr 2 min     Horror        10.0            7.0   \n",
       "...         ...    ...          ...        ...         ...            ...   \n",
       "2580   49939757      R  1 hr 39 min     Action         NaN            NaN   \n",
       "2581  311553190  PG-13  2 hr 11 min     Comedy         NaN            NaN   \n",
       "2582   21051915      R  1 hr 49 min  Biography         1.0            6.0   \n",
       "2583   68631669     PG  1 hr 36 min     Comedy         NaN            NaN   \n",
       "2584   20311536  PG-13  1 hr 26 min      Drama         NaN            NaN   \n",
       "\n",
       "      meta_positive  metascore user_mixed user_negative user_positive  \\\n",
       "0               0.0       14.0          9            59            31   \n",
       "1              33.0       88.0         36             9           258   \n",
       "2               6.0       40.0        161           177           305   \n",
       "4              20.0       61.0          4             2            34   \n",
       "5              15.0       54.0         23            37            54   \n",
       "...             ...        ...        ...           ...           ...   \n",
       "2580            NaN        NaN        NaN           NaN           NaN   \n",
       "2581            NaN        NaN        NaN           NaN           NaN   \n",
       "2582            0.0       10.0          1            51           687   \n",
       "2583            NaN        NaN        NaN           NaN           NaN   \n",
       "2584            NaN        NaN        NaN           NaN           NaN   \n",
       "\n",
       "     userscore  \n",
       "0          3.6  \n",
       "1          8.2  \n",
       "2          5.7  \n",
       "4          7.4  \n",
       "5          5.2  \n",
       "...        ...  \n",
       "2580       NaN  \n",
       "2581       NaN  \n",
       "2582       9.3  \n",
       "2583       NaN  \n",
       "2584       NaN  \n",
       "\n",
       "[2475 rows x 17 columns]"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_movie_db_df=movie_db_df.drop_duplicates(subset=[\"movie_title\", \"movie_year\"])\n",
    "final_movie_db_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "83799030",
   "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>Title</th>\n",
       "      <th>Year</th>\n",
       "      <th>Budget</th>\n",
       "      <th>Domestic Revenue</th>\n",
       "      <th>International Revenue</th>\n",
       "      <th>Worldwide Revenue</th>\n",
       "      <th>MPAA Rating</th>\n",
       "      <th>Run Time</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Metacritic Mixed Reviews</th>\n",
       "      <th>Metacritic Negative Reviews</th>\n",
       "      <th>Metacritic Positive Reviews</th>\n",
       "      <th>Metascore</th>\n",
       "      <th>Users Mixed Reviews</th>\n",
       "      <th>Users Negative Reviews</th>\n",
       "      <th>Users Positive Reviews</th>\n",
       "      <th>Userscore</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Glitter</td>\n",
       "      <td>2001</td>\n",
       "      <td>22000000</td>\n",
       "      <td>4274407</td>\n",
       "      <td>997259</td>\n",
       "      <td>5271666</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>1 hr 44 min</td>\n",
       "      <td>Drama</td>\n",
       "      <td>3.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>9</td>\n",
       "      <td>59</td>\n",
       "      <td>31</td>\n",
       "      <td>3.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Chicken Run</td>\n",
       "      <td>2000</td>\n",
       "      <td>45000000</td>\n",
       "      <td>106834564</td>\n",
       "      <td>118000000</td>\n",
       "      <td>224834564</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1 hr 24 min</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>36</td>\n",
       "      <td>9</td>\n",
       "      <td>258</td>\n",
       "      <td>8.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Fantastic Four</td>\n",
       "      <td>2005</td>\n",
       "      <td>100000000</td>\n",
       "      <td>154696080</td>\n",
       "      <td>178839854</td>\n",
       "      <td>333535934</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>1 hr 46 min</td>\n",
       "      <td>Action</td>\n",
       "      <td>18.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>161</td>\n",
       "      <td>177</td>\n",
       "      <td>305</td>\n",
       "      <td>5.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Frida</td>\n",
       "      <td>2002</td>\n",
       "      <td>12000000</td>\n",
       "      <td>25885000</td>\n",
       "      <td>30413474</td>\n",
       "      <td>56298474</td>\n",
       "      <td>R</td>\n",
       "      <td>2 hr 3 min</td>\n",
       "      <td>Biography</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>34</td>\n",
       "      <td>7.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>From Hell</td>\n",
       "      <td>2001</td>\n",
       "      <td>35000000</td>\n",
       "      <td>31602566</td>\n",
       "      <td>42955549</td>\n",
       "      <td>74558115</td>\n",
       "      <td>R</td>\n",
       "      <td>2 hr 2 min</td>\n",
       "      <td>Horror</td>\n",
       "      <td>10.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>23</td>\n",
       "      <td>37</td>\n",
       "      <td>54</td>\n",
       "      <td>5.2</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2580</th>\n",
       "      <td>21 Bridges</td>\n",
       "      <td>2019</td>\n",
       "      <td>33000000</td>\n",
       "      <td>28539757</td>\n",
       "      <td>21400000</td>\n",
       "      <td>49939757</td>\n",
       "      <td>R</td>\n",
       "      <td>1 hr 39 min</td>\n",
       "      <td>Action</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>2581</th>\n",
       "      <td>Knives Out</td>\n",
       "      <td>2019</td>\n",
       "      <td>40000000</td>\n",
       "      <td>165363234</td>\n",
       "      <td>146189956</td>\n",
       "      <td>311553190</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>2 hr 11 min</td>\n",
       "      <td>Comedy</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>2582</th>\n",
       "      <td>Unplanned</td>\n",
       "      <td>2019</td>\n",
       "      <td>6000000</td>\n",
       "      <td>19005109</td>\n",
       "      <td>2046806</td>\n",
       "      <td>21051915</td>\n",
       "      <td>R</td>\n",
       "      <td>1 hr 49 min</td>\n",
       "      <td>Biography</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1</td>\n",
       "      <td>51</td>\n",
       "      <td>687</td>\n",
       "      <td>9.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2583</th>\n",
       "      <td>Playing with Fire</td>\n",
       "      <td>2019</td>\n",
       "      <td>29900000</td>\n",
       "      <td>44451847</td>\n",
       "      <td>24179822</td>\n",
       "      <td>68631669</td>\n",
       "      <td>PG</td>\n",
       "      <td>1 hr 36 min</td>\n",
       "      <td>Comedy</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>2584</th>\n",
       "      <td>Brahms: The Boy II</td>\n",
       "      <td>2020</td>\n",
       "      <td>10000000</td>\n",
       "      <td>12611536</td>\n",
       "      <td>7700000</td>\n",
       "      <td>20311536</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>1 hr 26 min</td>\n",
       "      <td>Drama</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",
       "  </tbody>\n",
       "</table>\n",
       "<p>2475 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Title  Year     Budget  Domestic Revenue  \\\n",
       "0                Glitter  2001   22000000           4274407   \n",
       "1            Chicken Run  2000   45000000         106834564   \n",
       "2         Fantastic Four  2005  100000000         154696080   \n",
       "4                  Frida  2002   12000000          25885000   \n",
       "5              From Hell  2001   35000000          31602566   \n",
       "...                  ...   ...        ...               ...   \n",
       "2580          21 Bridges  2019   33000000          28539757   \n",
       "2581          Knives Out  2019   40000000         165363234   \n",
       "2582           Unplanned  2019    6000000          19005109   \n",
       "2583   Playing with Fire  2019   29900000          44451847   \n",
       "2584  Brahms: The Boy II  2020   10000000          12611536   \n",
       "\n",
       "      International Revenue  Worldwide Revenue MPAA Rating     Run Time  \\\n",
       "0                    997259            5271666       PG-13  1 hr 44 min   \n",
       "1                 118000000          224834564         NaN  1 hr 24 min   \n",
       "2                 178839854          333535934       PG-13  1 hr 46 min   \n",
       "4                  30413474           56298474           R   2 hr 3 min   \n",
       "5                  42955549           74558115           R   2 hr 2 min   \n",
       "...                     ...                ...         ...          ...   \n",
       "2580               21400000           49939757           R  1 hr 39 min   \n",
       "2581              146189956          311553190       PG-13  2 hr 11 min   \n",
       "2582                2046806           21051915           R  1 hr 49 min   \n",
       "2583               24179822           68631669          PG  1 hr 36 min   \n",
       "2584                7700000           20311536       PG-13  1 hr 26 min   \n",
       "\n",
       "          Genre  Metacritic Mixed Reviews  Metacritic Negative Reviews  \\\n",
       "0         Drama                       3.0                         20.0   \n",
       "1     Adventure                       1.0                          0.0   \n",
       "2        Action                      18.0                         11.0   \n",
       "4     Biography                      17.0                          1.0   \n",
       "5        Horror                      10.0                          7.0   \n",
       "...         ...                       ...                          ...   \n",
       "2580     Action                       NaN                          NaN   \n",
       "2581     Comedy                       NaN                          NaN   \n",
       "2582  Biography                       1.0                          6.0   \n",
       "2583     Comedy                       NaN                          NaN   \n",
       "2584      Drama                       NaN                          NaN   \n",
       "\n",
       "      Metacritic Positive Reviews  Metascore Users Mixed Reviews  \\\n",
       "0                             0.0       14.0                   9   \n",
       "1                            33.0       88.0                  36   \n",
       "2                             6.0       40.0                 161   \n",
       "4                            20.0       61.0                   4   \n",
       "5                            15.0       54.0                  23   \n",
       "...                           ...        ...                 ...   \n",
       "2580                          NaN        NaN                 NaN   \n",
       "2581                          NaN        NaN                 NaN   \n",
       "2582                          0.0       10.0                   1   \n",
       "2583                          NaN        NaN                 NaN   \n",
       "2584                          NaN        NaN                 NaN   \n",
       "\n",
       "     Users Negative Reviews Users Positive Reviews Userscore  \n",
       "0                        59                     31       3.6  \n",
       "1                         9                    258       8.2  \n",
       "2                       177                    305       5.7  \n",
       "4                         2                     34       7.4  \n",
       "5                        37                     54       5.2  \n",
       "...                     ...                    ...       ...  \n",
       "2580                    NaN                    NaN       NaN  \n",
       "2581                    NaN                    NaN       NaN  \n",
       "2582                     51                    687       9.3  \n",
       "2583                    NaN                    NaN       NaN  \n",
       "2584                    NaN                    NaN       NaN  \n",
       "\n",
       "[2475 rows x 17 columns]"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_movie_db_df=final_movie_db_df.rename(columns= {\"movie_title\":\"Title\", \"movie_year\":\"Year\", \"budget\":\"Budget\", \"domestic\":\"Domestic Revenue\", \"international\":\"International Revenue\", \"worldwide\":\"Worldwide Revenue\", \"mpaa\":\"MPAA Rating\", \"run_time\":\"Run Time\", \"genre_1\":\"Genre\", \"meta_mixed\":\"Metacritic Mixed Reviews\", \"meta_negative\":\"Metacritic Negative Reviews\", \"meta_positive\":\"Metacritic Positive Reviews\", \"metascore\":\"Metascore\", \"user_mixed\":\"Users Mixed Reviews\", \"user_negative\":\"Users Negative Reviews\", \"user_positive\":\"Users Positive Reviews\", \"userscore\": \"Userscore\"})\n",
    "final_movie_db_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "f002fde7",
   "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>Title</th>\n",
       "      <th>Year</th>\n",
       "      <th>Budget</th>\n",
       "      <th>Domestic Revenue</th>\n",
       "      <th>International Revenue</th>\n",
       "      <th>Worldwide Revenue</th>\n",
       "      <th>MPAA Rating</th>\n",
       "      <th>Run Time</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Metacritic Mixed Reviews</th>\n",
       "      <th>Metacritic Negative Reviews</th>\n",
       "      <th>Metacritic Positive Reviews</th>\n",
       "      <th>Metascore</th>\n",
       "      <th>Users Mixed Reviews</th>\n",
       "      <th>Users Negative Reviews</th>\n",
       "      <th>Users Positive Reviews</th>\n",
       "      <th>Userscore</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Glitter</td>\n",
       "      <td>2001</td>\n",
       "      <td>22000000</td>\n",
       "      <td>4274407</td>\n",
       "      <td>997259</td>\n",
       "      <td>5271666</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>1 hr 44 min</td>\n",
       "      <td>Drama</td>\n",
       "      <td>3.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>9</td>\n",
       "      <td>59</td>\n",
       "      <td>31</td>\n",
       "      <td>3.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Chicken Run</td>\n",
       "      <td>2000</td>\n",
       "      <td>45000000</td>\n",
       "      <td>106834564</td>\n",
       "      <td>118000000</td>\n",
       "      <td>224834564</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1 hr 24 min</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>36</td>\n",
       "      <td>9</td>\n",
       "      <td>258</td>\n",
       "      <td>8.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Fantastic Four</td>\n",
       "      <td>2005</td>\n",
       "      <td>100000000</td>\n",
       "      <td>154696080</td>\n",
       "      <td>178839854</td>\n",
       "      <td>333535934</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>1 hr 46 min</td>\n",
       "      <td>Action</td>\n",
       "      <td>18.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>161</td>\n",
       "      <td>177</td>\n",
       "      <td>305</td>\n",
       "      <td>5.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Frida</td>\n",
       "      <td>2002</td>\n",
       "      <td>12000000</td>\n",
       "      <td>25885000</td>\n",
       "      <td>30413474</td>\n",
       "      <td>56298474</td>\n",
       "      <td>R</td>\n",
       "      <td>2 hr 3 min</td>\n",
       "      <td>Biography</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>34</td>\n",
       "      <td>7.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>From Hell</td>\n",
       "      <td>2001</td>\n",
       "      <td>35000000</td>\n",
       "      <td>31602566</td>\n",
       "      <td>42955549</td>\n",
       "      <td>74558115</td>\n",
       "      <td>R</td>\n",
       "      <td>2 hr 2 min</td>\n",
       "      <td>Horror</td>\n",
       "      <td>10.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>23</td>\n",
       "      <td>37</td>\n",
       "      <td>54</td>\n",
       "      <td>5.2</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2580</th>\n",
       "      <td>21 Bridges</td>\n",
       "      <td>2019</td>\n",
       "      <td>33000000</td>\n",
       "      <td>28539757</td>\n",
       "      <td>21400000</td>\n",
       "      <td>49939757</td>\n",
       "      <td>R</td>\n",
       "      <td>1 hr 39 min</td>\n",
       "      <td>Action</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>2581</th>\n",
       "      <td>Knives Out</td>\n",
       "      <td>2019</td>\n",
       "      <td>40000000</td>\n",
       "      <td>165363234</td>\n",
       "      <td>146189956</td>\n",
       "      <td>311553190</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>2 hr 11 min</td>\n",
       "      <td>Comedy</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>2582</th>\n",
       "      <td>Unplanned</td>\n",
       "      <td>2019</td>\n",
       "      <td>6000000</td>\n",
       "      <td>19005109</td>\n",
       "      <td>2046806</td>\n",
       "      <td>21051915</td>\n",
       "      <td>R</td>\n",
       "      <td>1 hr 49 min</td>\n",
       "      <td>Biography</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1</td>\n",
       "      <td>51</td>\n",
       "      <td>687</td>\n",
       "      <td>9.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2583</th>\n",
       "      <td>Playing with Fire</td>\n",
       "      <td>2019</td>\n",
       "      <td>29900000</td>\n",
       "      <td>44451847</td>\n",
       "      <td>24179822</td>\n",
       "      <td>68631669</td>\n",
       "      <td>PG</td>\n",
       "      <td>1 hr 36 min</td>\n",
       "      <td>Comedy</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>2584</th>\n",
       "      <td>Brahms: The Boy II</td>\n",
       "      <td>2020</td>\n",
       "      <td>10000000</td>\n",
       "      <td>12611536</td>\n",
       "      <td>7700000</td>\n",
       "      <td>20311536</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>1 hr 26 min</td>\n",
       "      <td>Drama</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",
       "  </tbody>\n",
       "</table>\n",
       "<p>2475 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Title  Year     Budget  Domestic Revenue  \\\n",
       "0                Glitter  2001   22000000           4274407   \n",
       "1            Chicken Run  2000   45000000         106834564   \n",
       "2         Fantastic Four  2005  100000000         154696080   \n",
       "4                  Frida  2002   12000000          25885000   \n",
       "5              From Hell  2001   35000000          31602566   \n",
       "...                  ...   ...        ...               ...   \n",
       "2580          21 Bridges  2019   33000000          28539757   \n",
       "2581          Knives Out  2019   40000000         165363234   \n",
       "2582           Unplanned  2019    6000000          19005109   \n",
       "2583   Playing with Fire  2019   29900000          44451847   \n",
       "2584  Brahms: The Boy II  2020   10000000          12611536   \n",
       "\n",
       "      International Revenue  Worldwide Revenue MPAA Rating     Run Time  \\\n",
       "0                    997259            5271666       PG-13  1 hr 44 min   \n",
       "1                 118000000          224834564         NaN  1 hr 24 min   \n",
       "2                 178839854          333535934       PG-13  1 hr 46 min   \n",
       "4                  30413474           56298474           R   2 hr 3 min   \n",
       "5                  42955549           74558115           R   2 hr 2 min   \n",
       "...                     ...                ...         ...          ...   \n",
       "2580               21400000           49939757           R  1 hr 39 min   \n",
       "2581              146189956          311553190       PG-13  2 hr 11 min   \n",
       "2582                2046806           21051915           R  1 hr 49 min   \n",
       "2583               24179822           68631669          PG  1 hr 36 min   \n",
       "2584                7700000           20311536       PG-13  1 hr 26 min   \n",
       "\n",
       "          Genre  Metacritic Mixed Reviews  Metacritic Negative Reviews  \\\n",
       "0         Drama                       3.0                         20.0   \n",
       "1     Adventure                       1.0                          0.0   \n",
       "2        Action                      18.0                         11.0   \n",
       "4     Biography                      17.0                          1.0   \n",
       "5        Horror                      10.0                          7.0   \n",
       "...         ...                       ...                          ...   \n",
       "2580     Action                       NaN                          NaN   \n",
       "2581     Comedy                       NaN                          NaN   \n",
       "2582  Biography                       1.0                          6.0   \n",
       "2583     Comedy                       NaN                          NaN   \n",
       "2584      Drama                       NaN                          NaN   \n",
       "\n",
       "      Metacritic Positive Reviews  Metascore Users Mixed Reviews  \\\n",
       "0                             0.0       14.0                   9   \n",
       "1                            33.0       88.0                  36   \n",
       "2                             6.0       40.0                 161   \n",
       "4                            20.0       61.0                   4   \n",
       "5                            15.0       54.0                  23   \n",
       "...                           ...        ...                 ...   \n",
       "2580                          NaN        NaN                 NaN   \n",
       "2581                          NaN        NaN                 NaN   \n",
       "2582                          0.0       10.0                   1   \n",
       "2583                          NaN        NaN                 NaN   \n",
       "2584                          NaN        NaN                 NaN   \n",
       "\n",
       "     Users Negative Reviews Users Positive Reviews Userscore  \n",
       "0                        59                     31       3.6  \n",
       "1                         9                    258       8.2  \n",
       "2                       177                    305       5.7  \n",
       "4                         2                     34       7.4  \n",
       "5                        37                     54       5.2  \n",
       "...                     ...                    ...       ...  \n",
       "2580                    NaN                    NaN       NaN  \n",
       "2581                    NaN                    NaN       NaN  \n",
       "2582                     51                    687       9.3  \n",
       "2583                    NaN                    NaN       NaN  \n",
       "2584                    NaN                    NaN       NaN  \n",
       "\n",
       "[2475 rows x 17 columns]"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_movie_db_df = final_movie_db_df.replace('tbd', np.nan)\n",
    "final_movie_db_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "0d8ae03d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 2475 entries, 0 to 2584\n",
      "Data columns (total 17 columns):\n",
      " #   Column                       Non-Null Count  Dtype  \n",
      "---  ------                       --------------  -----  \n",
      " 0   Title                        2475 non-null   object \n",
      " 1   Year                         2475 non-null   int64  \n",
      " 2   Budget                       2475 non-null   int64  \n",
      " 3   Domestic Revenue             2475 non-null   int64  \n",
      " 4   International Revenue        2475 non-null   int64  \n",
      " 5   Worldwide Revenue            2475 non-null   int64  \n",
      " 6   MPAA Rating                  2413 non-null   object \n",
      " 7   Run Time                     2475 non-null   object \n",
      " 8   Genre                        2475 non-null   object \n",
      " 9   Metacritic Mixed Reviews     2283 non-null   float64\n",
      " 10  Metacritic Negative Reviews  2283 non-null   float64\n",
      " 11  Metacritic Positive Reviews  2283 non-null   float64\n",
      " 12  Metascore                    2283 non-null   float64\n",
      " 13  Users Mixed Reviews          2283 non-null   object \n",
      " 14  Users Negative Reviews       2283 non-null   object \n",
      " 15  Users Positive Reviews       2283 non-null   object \n",
      " 16  Userscore                    2278 non-null   object \n",
      "dtypes: float64(4), int64(5), object(8)\n",
      "memory usage: 348.0+ KB\n"
     ]
    }
   ],
   "source": [
    "final_movie_db_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "a8274e7a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Title                            0\n",
      "Year                             0\n",
      "Budget                           0\n",
      "Domestic Revenue                 0\n",
      "International Revenue            0\n",
      "Worldwide Revenue                0\n",
      "MPAA Rating                     62\n",
      "Run Time                         0\n",
      "Genre                            0\n",
      "Metacritic Mixed Reviews       192\n",
      "Metacritic Negative Reviews    192\n",
      "Metacritic Positive Reviews    192\n",
      "Metascore                      192\n",
      "Users Mixed Reviews            192\n",
      "Users Negative Reviews         192\n",
      "Users Positive Reviews         192\n",
      "Userscore                      197\n",
      "dtype: int64\n"
     ]
    }
   ],
   "source": [
    "print(final_movie_db_df.isnull().sum())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "d3ba4815",
   "metadata": {},
   "outputs": [],
   "source": [
    "#turn object types into floats\n",
    "final_movie_db_df[\"Userscore\"] = final_movie_db_df['Userscore'].astype(float)\n",
    "final_movie_db_df[\"Users Mixed Reviews\"] = final_movie_db_df[\"Users Mixed Reviews\"].str.replace(',','').astype(float)\n",
    "final_movie_db_df[\"Users Negative Reviews\"] = final_movie_db_df[\"Users Negative Reviews\"].str.replace(',','').astype(float)\n",
    "final_movie_db_df[\"Users Positive Reviews\"] = final_movie_db_df[\"Users Positive Reviews\"].str.replace(',','').astype(float)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "72c6e908",
   "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>Title</th>\n",
       "      <th>Year</th>\n",
       "      <th>Budget</th>\n",
       "      <th>Domestic Revenue</th>\n",
       "      <th>International Revenue</th>\n",
       "      <th>Worldwide Revenue</th>\n",
       "      <th>MPAA Rating</th>\n",
       "      <th>Run Time</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Metacritic Mixed Reviews</th>\n",
       "      <th>Metacritic Negative Reviews</th>\n",
       "      <th>Metacritic Positive Reviews</th>\n",
       "      <th>Metascore</th>\n",
       "      <th>Users Mixed Reviews</th>\n",
       "      <th>Users Negative Reviews</th>\n",
       "      <th>Users Positive Reviews</th>\n",
       "      <th>Userscore</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Glitter</td>\n",
       "      <td>2001</td>\n",
       "      <td>22000000</td>\n",
       "      <td>4274407</td>\n",
       "      <td>997259</td>\n",
       "      <td>5271666</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>1 hr 44 min</td>\n",
       "      <td>Drama</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>59.000000</td>\n",
       "      <td>31.00000</td>\n",
       "      <td>3.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Chicken Run</td>\n",
       "      <td>2000</td>\n",
       "      <td>45000000</td>\n",
       "      <td>106834564</td>\n",
       "      <td>118000000</td>\n",
       "      <td>224834564</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1 hr 24 min</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>33.00000</td>\n",
       "      <td>88.000000</td>\n",
       "      <td>36.000000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>258.00000</td>\n",
       "      <td>8.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Fantastic Four</td>\n",
       "      <td>2005</td>\n",
       "      <td>100000000</td>\n",
       "      <td>154696080</td>\n",
       "      <td>178839854</td>\n",
       "      <td>333535934</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>1 hr 46 min</td>\n",
       "      <td>Action</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>6.00000</td>\n",
       "      <td>40.000000</td>\n",
       "      <td>161.000000</td>\n",
       "      <td>177.000000</td>\n",
       "      <td>305.00000</td>\n",
       "      <td>5.700000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Frida</td>\n",
       "      <td>2002</td>\n",
       "      <td>12000000</td>\n",
       "      <td>25885000</td>\n",
       "      <td>30413474</td>\n",
       "      <td>56298474</td>\n",
       "      <td>R</td>\n",
       "      <td>2 hr 3 min</td>\n",
       "      <td>Biography</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>20.00000</td>\n",
       "      <td>61.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>34.00000</td>\n",
       "      <td>7.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>From Hell</td>\n",
       "      <td>2001</td>\n",
       "      <td>35000000</td>\n",
       "      <td>31602566</td>\n",
       "      <td>42955549</td>\n",
       "      <td>74558115</td>\n",
       "      <td>R</td>\n",
       "      <td>2 hr 2 min</td>\n",
       "      <td>Horror</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>15.00000</td>\n",
       "      <td>54.000000</td>\n",
       "      <td>23.000000</td>\n",
       "      <td>37.000000</td>\n",
       "      <td>54.00000</td>\n",
       "      <td>5.200000</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2580</th>\n",
       "      <td>21 Bridges</td>\n",
       "      <td>2019</td>\n",
       "      <td>33000000</td>\n",
       "      <td>28539757</td>\n",
       "      <td>21400000</td>\n",
       "      <td>49939757</td>\n",
       "      <td>R</td>\n",
       "      <td>1 hr 39 min</td>\n",
       "      <td>Action</td>\n",
       "      <td>11.341656</td>\n",
       "      <td>5.542269</td>\n",
       "      <td>15.08629</td>\n",
       "      <td>52.588261</td>\n",
       "      <td>51.708279</td>\n",
       "      <td>43.457293</td>\n",
       "      <td>207.64389</td>\n",
       "      <td>6.543854</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2581</th>\n",
       "      <td>Knives Out</td>\n",
       "      <td>2019</td>\n",
       "      <td>40000000</td>\n",
       "      <td>165363234</td>\n",
       "      <td>146189956</td>\n",
       "      <td>311553190</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>2 hr 11 min</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>11.341656</td>\n",
       "      <td>5.542269</td>\n",
       "      <td>15.08629</td>\n",
       "      <td>52.588261</td>\n",
       "      <td>51.708279</td>\n",
       "      <td>43.457293</td>\n",
       "      <td>207.64389</td>\n",
       "      <td>6.543854</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2582</th>\n",
       "      <td>Unplanned</td>\n",
       "      <td>2019</td>\n",
       "      <td>6000000</td>\n",
       "      <td>19005109</td>\n",
       "      <td>2046806</td>\n",
       "      <td>21051915</td>\n",
       "      <td>R</td>\n",
       "      <td>1 hr 49 min</td>\n",
       "      <td>Biography</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>51.000000</td>\n",
       "      <td>687.00000</td>\n",
       "      <td>9.300000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2583</th>\n",
       "      <td>Playing with Fire</td>\n",
       "      <td>2019</td>\n",
       "      <td>29900000</td>\n",
       "      <td>44451847</td>\n",
       "      <td>24179822</td>\n",
       "      <td>68631669</td>\n",
       "      <td>PG</td>\n",
       "      <td>1 hr 36 min</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>11.341656</td>\n",
       "      <td>5.542269</td>\n",
       "      <td>15.08629</td>\n",
       "      <td>52.588261</td>\n",
       "      <td>51.708279</td>\n",
       "      <td>43.457293</td>\n",
       "      <td>207.64389</td>\n",
       "      <td>6.543854</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2584</th>\n",
       "      <td>Brahms: The Boy II</td>\n",
       "      <td>2020</td>\n",
       "      <td>10000000</td>\n",
       "      <td>12611536</td>\n",
       "      <td>7700000</td>\n",
       "      <td>20311536</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>1 hr 26 min</td>\n",
       "      <td>Drama</td>\n",
       "      <td>11.341656</td>\n",
       "      <td>5.542269</td>\n",
       "      <td>15.08629</td>\n",
       "      <td>52.588261</td>\n",
       "      <td>51.708279</td>\n",
       "      <td>43.457293</td>\n",
       "      <td>207.64389</td>\n",
       "      <td>6.543854</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2475 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Title  Year     Budget  Domestic Revenue  \\\n",
       "0                Glitter  2001   22000000           4274407   \n",
       "1            Chicken Run  2000   45000000         106834564   \n",
       "2         Fantastic Four  2005  100000000         154696080   \n",
       "4                  Frida  2002   12000000          25885000   \n",
       "5              From Hell  2001   35000000          31602566   \n",
       "...                  ...   ...        ...               ...   \n",
       "2580          21 Bridges  2019   33000000          28539757   \n",
       "2581          Knives Out  2019   40000000         165363234   \n",
       "2582           Unplanned  2019    6000000          19005109   \n",
       "2583   Playing with Fire  2019   29900000          44451847   \n",
       "2584  Brahms: The Boy II  2020   10000000          12611536   \n",
       "\n",
       "      International Revenue  Worldwide Revenue MPAA Rating     Run Time  \\\n",
       "0                    997259            5271666       PG-13  1 hr 44 min   \n",
       "1                 118000000          224834564         NaN  1 hr 24 min   \n",
       "2                 178839854          333535934       PG-13  1 hr 46 min   \n",
       "4                  30413474           56298474           R   2 hr 3 min   \n",
       "5                  42955549           74558115           R   2 hr 2 min   \n",
       "...                     ...                ...         ...          ...   \n",
       "2580               21400000           49939757           R  1 hr 39 min   \n",
       "2581              146189956          311553190       PG-13  2 hr 11 min   \n",
       "2582                2046806           21051915           R  1 hr 49 min   \n",
       "2583               24179822           68631669          PG  1 hr 36 min   \n",
       "2584                7700000           20311536       PG-13  1 hr 26 min   \n",
       "\n",
       "          Genre  Metacritic Mixed Reviews  Metacritic Negative Reviews  \\\n",
       "0         Drama                  3.000000                    20.000000   \n",
       "1     Adventure                  1.000000                     0.000000   \n",
       "2        Action                 18.000000                    11.000000   \n",
       "4     Biography                 17.000000                     1.000000   \n",
       "5        Horror                 10.000000                     7.000000   \n",
       "...         ...                       ...                          ...   \n",
       "2580     Action                 11.341656                     5.542269   \n",
       "2581     Comedy                 11.341656                     5.542269   \n",
       "2582  Biography                  1.000000                     6.000000   \n",
       "2583     Comedy                 11.341656                     5.542269   \n",
       "2584      Drama                 11.341656                     5.542269   \n",
       "\n",
       "      Metacritic Positive Reviews  Metascore  Users Mixed Reviews  \\\n",
       "0                         0.00000  14.000000             9.000000   \n",
       "1                        33.00000  88.000000            36.000000   \n",
       "2                         6.00000  40.000000           161.000000   \n",
       "4                        20.00000  61.000000             4.000000   \n",
       "5                        15.00000  54.000000            23.000000   \n",
       "...                           ...        ...                  ...   \n",
       "2580                     15.08629  52.588261            51.708279   \n",
       "2581                     15.08629  52.588261            51.708279   \n",
       "2582                      0.00000  10.000000             1.000000   \n",
       "2583                     15.08629  52.588261            51.708279   \n",
       "2584                     15.08629  52.588261            51.708279   \n",
       "\n",
       "      Users Negative Reviews  Users Positive Reviews  Userscore  \n",
       "0                  59.000000                31.00000   3.600000  \n",
       "1                   9.000000               258.00000   8.200000  \n",
       "2                 177.000000               305.00000   5.700000  \n",
       "4                   2.000000                34.00000   7.400000  \n",
       "5                  37.000000                54.00000   5.200000  \n",
       "...                      ...                     ...        ...  \n",
       "2580               43.457293               207.64389   6.543854  \n",
       "2581               43.457293               207.64389   6.543854  \n",
       "2582               51.000000               687.00000   9.300000  \n",
       "2583               43.457293               207.64389   6.543854  \n",
       "2584               43.457293               207.64389   6.543854  \n",
       "\n",
       "[2475 rows x 17 columns]"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_movie_db_df= final_movie_db_df.fillna(final_movie_db_df.mean())\n",
    "final_movie_db_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "850a2fd6",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "17c197d1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "MPAA Rating\n",
       "G        2.444110e+08\n",
       "NC-17    2.518160e+07\n",
       "PG       2.156528e+08\n",
       "PG-13    1.937595e+08\n",
       "R        8.872000e+07\n",
       "Name: Worldwide Revenue, dtype: float64"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bar2_df = final_movie_db_df.groupby(final_movie_db_df['MPAA Rating']).mean()['Worldwide Revenue']\n",
    "bar2_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "6639616d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Budget\n",
       "220          6.385210e+05\n",
       "1100         2.627700e+05\n",
       "7000         5.454360e+05\n",
       "15000        1.933558e+08\n",
       "46000        3.910519e+06\n",
       "                 ...     \n",
       "270000000    3.910812e+08\n",
       "275000000    3.929248e+08\n",
       "300000000    9.609965e+08\n",
       "317000000    1.332540e+09\n",
       "356000000    2.797801e+09\n",
       "Name: Worldwide Revenue, Length: 258, dtype: float64"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bar3_df = final_movie_db_df.groupby(final_movie_db_df['Budget']).mean()['Worldwide Revenue']\n",
    "bar3_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "d83c04b8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYIAAAEWCAYAAABrDZDcAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3debgcVZnH8e+PEEAWRUgUEkgCiDjAsBnCqkZR2QdQFKKsOiAODKIyIw6M4DKK8zgoDGCMIyJbgBFUlCiirBFQEgxLQMYAEWICCQTCKhp4549zOik63X0rya3u5Nbv8zz3uV1LV71VXV1vnXOqTykiMDOz+lql1wGYmVlvORGYmdWcE4GZWc05EZiZ1ZwTgZlZzTkRmJnVnBNBP5J0hqRLOkyfKem9S7nM8ZL+vcP0kPSWpVmmdU9fx8TKRNJ0SWN7HceKqq/v6oqsVolA0uclTWoa98c24w7tbnStRcRxEfHl/l6upKMkvSLpeUnPSrpb0n79vZ5ekTRW0qt5+56X9GdJX+x1XFXJCSckndg0/qQ8/ozlXUdEbBURNy1DbGNzDFc3jd82j7+pMC4kvVD4zM6SNKgwvbGdY9qsS5IelnR/ibhmSnopr+txSRdKWrvkNh0laXJxXFXf1W6oVSIAbgF2axxYkjYABgM7NI17S563NEmr9nOs3XB7RKwNrAucD1wuad0ex9SfZkfE2nkbdwc+LunAXgdVof8Djmwad0Qe32vzgF0lrV8YdyStY9s2f2Z7AB8BjoF0kgcOB+az5HY2vBN4E7CppB1LxLV/Xtd2wPbA50u8Z8CpWyK4k3Ti3y4PvxO4EXiwadxDETFb0jBJ10iaL2mGpGMaC8pXJj+UdImkZ4Gjmlcm6XBJf5L0lKRTC+PXyFciQ/LwaZIWSnp9Hv6KpG/l1xdK+krhvf8iaY6k2ZI+1rS+1SV9Q9Kjkp7IRdXX9bVTIuJV4GJgLWDzvpYl6YFi6UHSqpKelLRDHt5Z0m2SnskljbGFeW+S9GVJv5H0nKRfFvbDWEmzmrZpUXWapFUknSLpobxPr5S0Xl/bl7fxEeA2YMvCss+W9FguEU2V9I7CtDGSpuRpT0g6qzCt0/ZtIunmvG3XA0M6xSXpmHxszc/H2rDCtJB0nFIJ9WlJ5+WTYTt3AmtK2iq/fyvgdXl8n+vMn/E3mub9iaTP5NfL81n8FfgxcGh+/yDgw8Cl7d4QEX8AbgW2zqPeAQwDPgUcKmm1Fm87EvgJMIn2yaLVuh4HrmPxeYDC9j0n6X5JB+XxfweMB3ZRKk08k8cv+q42jmVJn5U0N39njy4se31JP83H1535Oz85T5Okb+b3LZB0j6StqVCtEkFE/BX4LelkT/5/KzC5aVyjNDARmEU6+A4Gvippj8IiDwB+SLqifs0BLWlL4NukK5hhwPrARjmOv5C+nO8qrPNPwG6F4Zub45e0F3Ay8D7SCbu5veHrwFtJB/NbgOHAF9rukMXLHQQcDfwtx9HXsiYC4wqL2BN4MiLukjQcuBb4CrBejvcqSUML838kr+9NwGp5njJOBA4k7bdhwNPAeWXeKGlz0v69ozD6zrx96wGXAf8raY087Wzg7Ih4PbAZcGVeTl/bdxkwlZQAvkyHk5Gk9wBfI50QNyTt+8ubZtsP2BHYNs+3Zx+bejGpFEBe90VLsc7LgEMayUbSG4H3t4gJlu2zuKgQ257AdGB2u5nzd+gdwO8L2/NT4Io8vF/T/GuSvqeX5r92yaLVujYC9gZmFEY/lNf/BuCLwCWSNoyIB4DjyCXqiGhXit4gv3c48HHgvLxPIe2rF/I8R/La4+T9pHPAW0nnlkOAp8psxzKLiJXuD7gAmAvcV2LeEaSr/t8D95AOkB/laXeTTqh7NY07EtgYeAVYp7CsrwEX5tdnALc0resM4JL8+gvA5YVpa5Guit6bh78MnAOsCjxOuso5E1gDeAkYkue7EPhKYbvPLCzzrUCQTtQiHVibFabvAjzSZr8cBSwEniElgJeAD+dpHZeV1/ccsGYevhT4Qn79OeDipnVdBxyZX98EnFaY9k/AL/LrscCspvfOLOyzB4A9CtM2zLGv2mL7xgKv5u17Nu+nq4HVOhwrT5OqJSBdDHyx8TkU5mm7faRjbSGwVmHaZY1josX6vgf8Z2F47bw9o/JwALsXpl8JnNJmWWcAl+QYHiWVfB8lHceXAGf0tc78uT8KvDNPOwa4oZ8+i1n59R+BLUjJ5aPAPwI3FeaN/Hk9TToRf4V0wbpmHn9gnu87wE+a1nMYqQpqVWD1/Nkf1OHzngk8TzqWA/g1sG6H+acBBxS+P5Obpl/I4u/qWNJ3atXC9LnAzsCgvK+2KEz7SmN5wHtIVWY7A6t0Or/119/KWiK4kHTyLuM04MqI2J5ULN0D2D1n5qER8UdSlcGuedzWpJPAMGB+RDxXWNafSNm94bEO6x1WnB4RL/DarH4z6WDZAbgXuJ50dbUzMCMinuxrmSy+egcYSvqyTM1VFs8Av8jj27kj0tXMG4FrSFc/fS4rImaQTgT756uwfyCd8ABGAh9qvC+/d3fSiaLh8cLrF0knozJGAj8qLPcBUrJ+c5v5Z0fEupGu6tclfTF/0JiYi+0P5OL3M6Srt0ZVzsdJifYPuejeuPrstH3DgKfzZ91Q/IyaDStOj4jnScdI8Rhbqn0VEY+Srmq/CvwxIpqP0bbrjHQWupzFpb2P0L7qZmk/i4aLgROAdwM/ajPPDhHxxojYLCJOi1R1eRApyTZu7LgU2LuppHkk6bu+MCJeJiX+vqqHDoyIdUjfxbdRqMqTdISkaYVt3Jo+qvqaPBURCwvDjc9vKClZFT+b4rniBuBcUqnhCUkTlKuNq7IyNnASEbdIGlUcJ2kz0o4bStrhx0SqYwygsRPfQLoK2AE4FvhNXt6zkmbncbMj4hFJC4H1JK1TSAYjgD8XQ+kQ5hzg7wrxrUmqHmq4jXRldBBwc0TcL2kEsC8tqoUKy9y4MDyi8PpJ0oluq4j4M0shIp6X9E/AQ5IuIJWK+lpWo3poFeD+nBwgHdAXR8Qxbd7XyQukBAQsqrIqftEfAz4WEb9Z2gVHxAJJl5GrFZTaAz5HujCYHhGvSnqadFVMvkAYJ2kV4APAD5UaOttun6SRwBslrVVIBiNof5zMJp1QG+9fi3SMLNXn18JFpNLj0S2m9bXOicAvJZ0J7EQ6PltZ1s/iYlKiuigiXuzc5PEaR5JOoo82aq5IpZ5xwDm5auc9wBhJH8zvWRNYQ9KQNhdWi0TEzZIuBL4BHJg/y++Sjo/bI+IVSdPyeqHzd78v80hJbSMWN5YXv9dExDl5u95EKgn+C1DZrakra4mglQnAP0fE20n1tufn8WcAhyk1Qk4CjgemAJ8htQ80TM7jbgHIV1K3AV9TatzdhnSV2LZxq8kPgf0k7Z7rKb9EYX9HxIukuuTjWXzivw34BO0TwZXAUZK2zInl9MLyXiUduN/MBw+Shkvqq0658f6ngP8hVfGUWdblpLrMT7K4NACpGmJ/SXtKGpT33dj8Re3L/5G+uPtKGkwqza1emD4e+I/8JUXSUEkHlNk+pdsCDyXVSwOsQ/oyzgNWlfQFFl8wIOkwSUPzvngmj36l0/ZFxJ9Ix9YXJa0maXdg/w5hXQYcLWk7SauTruJ/GxEzy2xTB1eQPpsrl3adEfF70j75H+C6iHimxTJgGT+LSI327wJO7WvehtwuswepTWC7/LctqR2rccV/OOn42aIwz1tJbXzjKOdbwPskbUeqyg3SvkCpobfYYPsEsFHZNoiiiHiFVFo5Q9Kakt7G4rYTJO0oaaf8HXgB+Avp2KvMgEgE+Uu+K6mxbxqp/rBRFTGOVK+/EbAP6YrkZlJDZfE+4FvzuOJto+NIdaezScXY0yPi+jIxRcR00kn+MtKV/NOkg7LoZtJVze8Kw+vQ5tbViPg56WC9gXRVdUPTLJ/L4+9QupPpV6QvRlnfAvbJSa/jsiJiDnA7ab9fURj/GKkR/d9IX6LHSFczfR5rEbGA1GbwP6Qr1Bd47T47m1SF9UtJz5EafnfqsMhhyr8jIFWHrEeql4ZUr/9z0snjT6QvW7GovhcwPb/3bODQiPhLie37SI5pPilRv6axtml7f026yruKdIxsRr6rZnlExEsR8auIeGkZ1zmRdCPCZbS3tJ9FMYbJEdG2kbiFw4FpEfHLiHi88UdqY9tG6Y6aI4Hzi9PzPOMpefdQRMwjfV7/HhH3A/9FOsafAP6eXIOQ3UC6qHhcUsfSRhsnkGooHiedkyYCL+dpryddiD1NOjafIpVUKqPcOLHSyVVDP4uIrXP92YMRsWGL+aYDezXqSiU9DOwcEXO7Ga+ZWTuSvg5sEBGlb3ntTwOiRBARzwKPSPoQLLoPd9s8+VFSsbJx/+8a5OKemVkvSHqbpG3yuWoMqdq5XeN59fGsjCUCSRNJrfxDSMW200lFtW+TqoQGk27d/JLSvcjfJTU0BfCvEfHLXsRtZgapHYBUHTSMdFvpd0i3hvfkhLxSJgIzM+s/A6JqyMzMlt1K9zuCIUOGxKhRo3odhpnZSmXq1KlPRkTLH5iudIlg1KhRTJkypddhmJmtVCS1/ZW7q4bMzGquskQgaWNJNyr15TJd0qdazDNWqZ+Xafmvz54yzcysf1VZNbQQ+GykronXIXVgdn3+xV7RrRExYJ6MZWa2sqmsRBARcyLirvz6OVLvhMM7v8vMzLqtK20EuTuI7UkPhWm2i9JTnn6u/GSlFu8/VulpUVPmzfOPgs3M+lPliSB3CHcVcFLuCqLoLmBkRGwL/DfpUXZLiIgJETE6IkYPHdqpe30zM1talSaC3I3qVcClEXF18/SIeDY/GIOImAQMVn5+rZmZdUeVdw2J9Fi8ByLirDbzbCAtej7qmBxPtc/mNDOz16jyrqHdSP2I35ufEQCpD/cRABExnvSg6U8qPQ3sJVKf7+78yMysiypLBBExmcWPdWs3z7mkZ3N21ahTru32Kpcw88x9ex2CmRngXxabmdWeE4GZWc05EZiZ1ZwTgZlZzTkRmJnVnBOBmVnNORGYmdWcE4GZWc05EZiZ1ZwTgZlZzTkRmJnVnBOBmVnNORGYmdWcE4GZWc05EZiZ1ZwTgZlZzTkRmJnVnBOBmVnNORGYmdWcE4GZWc05EZiZ1ZwTgZlZzTkRmJnV3Kq9DsBsRTHqlGt7HQIzz9y31yFYDblEYGZWc04EZmY150RgZlZzTgRmZjXnRGBmVnNOBGZmNedEYGZWc04EZmY150RgZlZzlSUCSRtLulHSA5KmS/pUi3kk6RxJMyTdI2mHquIxM7PWquxiYiHw2Yi4S9I6wFRJ10fE/YV59gY2z387Ad/O/83MrEsqKxFExJyIuCu/fg54ABjeNNsBwEWR3AGsK2nDqmIyM7MldaWNQNIoYHvgt02ThgOPFYZnsWSyQNKxkqZImjJv3ryqwjQzq6XKE4GktYGrgJMi4tnmyS3eEkuMiJgQEaMjYvTQoUOrCNPMrLYqTQSSBpOSwKURcXWLWWYBGxeGNwJmVxmTmZm9VpV3DQn4HvBARJzVZrZrgCPy3UM7AwsiYk5VMZmZ2ZKqvGtoN+Bw4F5J0/K4fwNGAETEeGASsA8wA3gROLrCeMzMrIXKEkFETKZ1G0BxngCOryoGMzPrmx9VaWZL8GM768VdTJiZ1ZwTgZlZzTkRmJnVnBOBmVnNORGYmdWcE4GZWc2VTgSS1qoyEDMz640+E4GkXSXdT+pGGknbSjq/8sjMzKwrypQIvgnsCTwFEBF3A++sMigzM+ueUlVDEfFY06hXKojFzMx6oEwXE49J2hUISasBJ5KriczMbOVXpkRwHKljuOGk5wdshzuKMzMbMPosEUTEk8BHuxCLmZn1QJ+JQNL3af34yI9VEpGZmXVVmTaCnxVerwEchB8naWY2YJSpGrqqOCxpIvCryiIyM7OuWpYuJjYnP27SzMxWfmXaCJ4jtREo/38c+FzFcZmZWZeUqRpapxuBmJlZb5R6ZrGk4cDI4vwRcUtVQZmZWfeUqRr6OnAIcD+Lu5YIwInAzGwAKFMiOBDYIiJerjoYMzPrvjJ3DT0MDK46EDMz640yJYIXgWmSfg0sKhVExImVRWVmZl1TJhFck//MzGwAKnP76A8kvQ4YEREPdiEmMzProjKPqtwfmAb8Ig9vJ8klBDOzAaJMY/EZwBjgGYCImAZsUmFMZmbWRWUSwcKIWNA0boluqc3MbOVUprH4PkkfAQZJ2pz0qMrbqg3LzMy6pUyJ4J+BrUi3jl4GLABOqjIoMzPrnjIlgi0i4lTg1KqDMTOz7itTIjhL0h8kfVnSVpVHZGZmXdVnIoiIdwNjgXnABEn3Sjqtr/dJukDSXEn3tZk+VtICSdPy3xeWNngzM1t+pZ5QFhGPR8Q5wHGk3xSUOWlfCOzVxzy3RsR2+e9LZWIxM7P+VeYHZX8n6QxJ04FzSXcMbdTX+/LzCuYvf4hmZlalMo3F3wcmAu+LiNn9vP5dJN0NzAZOjojprWaSdCxwLMCIEX5csplZfyrT19DOjb6G+nnddwEjI+J5SfsAPwY2bxPDBGACwOjRo/1jNjOzftSzvoYi4tmIeD6/ngQMljRkeZdrZmZLZ1n7Ghq1vCuWtIEk5ddjcixPLe9yzcxs6ZRpI1gYEQvyObs0SRNJt50OkTQLOJ38pLOIGA8cDHxS0kLgJeDQiHC1j5lZl1XW11BEjOtj+rmku5DMzKyHlravoYmkvoY+VWVQZmbWPWV+WfxiRJwaETtGxGjgEnwlb2Y2YLRNBJK2kfRLSfflfobeLOkq4FfA/d0L0czMqtSpRPBdUrfTHwSeJN33/zDwloj4ZhdiMzOzLujUWLx6RFyYXz8o6WTglIh4pfqwzMysWzolgjUkbQ807ht9Htimce9/RNxVdXBmZla9TolgDnBWYfjxwnAA76kqKDMz6562iSA/h8DMzAa4Us8jMDOzgcuJwMys5pwIzMxqrkw31JJ0WOOZwpJG5N5CzcxsAChTIjgf2AVodCL3HHBeZRGZmVlXlel9dKeI2EHS7wEi4mlJq1Ucl5mZdUmZEsHfJA0i/XYASUOBVyuNyszMuqZMIjgH+BHwJkn/AUwGvlppVGZm1jVlHl5/qaSpwB6k7iYOjIgHKo/MzMy6om0ikLReYXAu6aE0i6ZFxPwqAzMzs+7oVCKYSmoXEDACeDq/Xhd4FNik8ujMzKxybdsIImKTiNgUuA7YPyKGRMT6wH7A1d0K0MzMqlWmsXjHiJjUGIiInwPvqi4kMzPrpjK/I3hS0mmkZxUHcBjwVKVRmZlZ15QpEYwDhpJuIf0x8CYW/8rYzMxWcmVuH50PfKoLsZiZWQ90un30WxFxkqSfkn9VXBQR/1BpZGZm1hWdSgQX5//f6EYgZmbWG50eVTk1vxwE3BERL3YnJDMz66Yydw0dBYyX9BRwa/6bHBFPVxmYmZl1R5nG4iMAJA0DDiY9i2BYmfeamdmKr8+TuaTDgHcAfw88CZxLKhWYmdkAUOaq/lvAQ8B44MaImFlpRGZm1lV9/qAsIoYAHwPWAP5D0u8kXdzH28zMbCVR5uH1ryf1PjoSGAW8AT+hzMxswCjTxcRkYH/gHuCQiNgiIo7s602SLpA0V9J9baZL0jmSZki6R9IOSxe6mZn1hzJ3DW2zjMu+kNSwfFGb6XsDm+e/nYBv5/9mZtZFnbqYaNm1RENfXUxExC2SRnWY5QDgoogI4A5J60raMCLmdA7ZzMz6U6cSQaNriQ8AG5C6oYbU8+jMflj3cOCxwvCsPG6JRCDpWOBYgBEjRvTDqs3MrKFTFxM3A0j6ckS8szDpp5Ju6Yd1q9Vq28QyAZgAMHr06LalFDMzW3plGouHStq0MSBpE9LzCZbXLGDjwvBGwOx+WK6ZmS2FMj8o+zRwk6SH8/Ao4BP9sO5rgBMkXU5qJF7g9gEzs+4rc9fQLyRtDrwtj/pDRLzc1/skTQTGAkMkzQJOBwbnZY4HJgH7ADOAF4Gjl2UDzMxs+XS6a+gDbSZtJomIuLrTgiOi4+Ms891Cx/cdopmZValTiWD/DtMC6JgIzMxs5dDprqGjJa0CHBwRV3YxJjMz66KOdw1FxKvACV2KxczMeqDM7aPXSzpZ0saS1mv8VR6ZmZl1RZnbRz+W/xcbdgPYtMW8ZmYDyqhTru11CMw8c99Kl1/m9tFNKo3AzMx6qsyjKgcDnwQa3UzcBHwnIv5WYVxmZtYlZaqGvk36Idj5efjwPO4fqwrKzMy6p0wi2DEiti0M3yDp7qoCMjOz7ipz19ArkjZrDOQO6F6pLiQzM+umMiWCfwFuzJ3OifTsYvcLZGY2QHTqa+gk4DfAzaTHSW5BSgSlOp0zM7OVQ6eqoY2As4G5wHXAoXncWl2Iy8zMuqRTX0MnA0haDRgN7Er6cdl3JT0TEVt2J0QzM6tSmTaC1wGvB96Q/2YD91YZlJmZdU+nNoIJwFbAc8BvgduAsyLi6S7FZmZmXdCpjWAEsDrwOPBn0jOGn+lGUGZm1j2d2gj2kiRSqWBX4LPA1pLmA7dHxOlditHMzCrUsY0gP07yPknPAAvy337AGNIziM3MbCXXqY3gRFJJYDfgb6TfFNwOXIAbi83MBoxOJYJRwA+BT0fEnO6EY2Zm3dapjeAz3QzEzMx6o0ync2ZmNoA5EZiZ1ZwTgZlZzTkRmJnVnBOBmVnNORGYmdWcE4GZWc05EZiZ1ZwTgZlZzTkRmJnVnBOBmVnNVZoIJO0l6UFJMySd0mL6WEkLJE3Lf1+oMh4zM1tSmWcWLxNJg4DzgPeRnm52p6RrIuL+pllvjYj9qorDzMw6q7JEMAaYEREPR8RfgcuBAypcn5mZLYMqE8Fw4LHC8Kw8rtkuku6W9HNJW7VakKRjJU2RNGXevHlVxGpmVltVJgK1GBdNw3cBIyNiW+C/gR+3WlBETIiI0RExeujQof0cpplZvVWZCGYBGxeGNwJmF2eIiGcj4vn8ehIwWNKQCmMyM7MmVSaCO4HNJW0iaTXgUOCa4gySNpCk/HpMjuepCmMyM7Mmld01FBELJZ0AXAcMAi6IiOmSjsvTxwMHA5+UtBB4CTg0Ipqrj8zMrEKVJQJYVN0zqWnc+MLrc4Fzq4zBzMw68y+LzcxqzonAzKzmnAjMzGrOicDMrOacCMzMas6JwMys5pwIzMxqzonAzKzmnAjMzGrOicDMrOacCMzMas6JwMys5pwIzMxqzonAzKzmnAjMzGqu0ucR2Ipv1CnX9joEZp65b69DMKs1lwjMzGrOicDMrOacCMzMas6JwMys5pwIzMxqzonAzKzmnAjMzGrOicDMrOacCMzMas6JwMys5pwIzMxqzonAzKzmnAjMzGrOicDMrOacCMzMas6JwMys5pwIzMxqzonAzKzmKk0EkvaS9KCkGZJOaTFdks7J0++RtEOV8ZiZ2ZIqSwSSBgHnAXsDWwLjJG3ZNNvewOb571jg21XFY2ZmrVVZIhgDzIiIhyPir8DlwAFN8xwAXBTJHcC6kjasMCYzM2uyaoXLHg48VhieBexUYp7hwJziTJKOJZUYAJ6X9GD/hrpMhgBPLuub9fV+jKT3vC8W875YzPtisRVhX4xsN6HKRKAW42IZ5iEiJgAT+iOo/iJpSkSM7nUcKwLvi8W8LxbzvlhsRd8XVVYNzQI2LgxvBMxehnnMzKxCVSaCO4HNJW0iaTXgUOCapnmuAY7Idw/tDCyIiDnNCzIzs+pUVjUUEQslnQBcBwwCLoiI6ZKOy9PHA5OAfYAZwIvA0VXFU4EVqqqqx7wvFvO+WMz7YrEVel8oYokqeTMzqxH/stjMrOacCMzMas6JYClIerOkyyQ9LGmqpNslHdTruPqDpJD0X4XhkyWdURg+QtJ9kqZLul/SyW2Wc4GkuZLuaxp/haRp+W+mpGmVbUwXSHolb8t9kv5X0pp5/IA6RvpjOyV9KB83r0oaXRg/pnBM3L0y76dWmvbdTyWt2+uY2nEiKEmSgB8Dt0TEphHxdtKdUBv1NrJ+8zLwAUlDmidI2hs4CXh/RGwF7AAsaLOcC4G9mkdGxCERsV1EbAdcBVzdX4H3yEt5e7YG/gocN0CPkf7YzvuADwC3tBg/Oh8TewHfkVTlb5u6rbjv5gPH9zqgdpwIynsP8Nd8txMAEfGniPjvHsbUnxaS7mz4dItpnwdOjojZABHxl4j4bquFRMQtpIO+pXwS+TAwcbkjXnHcCryFgX+MLNN2RsQDEbFEbwAR8WJELMyDa9Dix6QDyO2kXhNWSE4E5W0F3NXrICp2HvBRSW9oGr81MLWf1vEO4ImI+GM/La+n8hXs3sC9DOBjpKrtlLSTpOl5uccVEsOAkTvg3IMlf0e1wnAiWEaSzsv1mnf2Opb+EhHPAhcBJ1a4mnEMjNLA63I7xxTgUeB7zTMMkGOk0u2MiN/m6sYdgc9LWmO5I15xNPbdU8B6wPU9jqctJ4LyppPqxgGIiONJWX5ozyKqxreAjwNrFcZNB97ePKOkjQuNfcf1teB8VfkB4Ir+CraHGvW/20XEP+cedgfiMbLU2ynp+/mYmFR2JRHxAPACqfQ5ULyU2z9GAqvhNoIB4QZgDUmfLIxbs1fBVCUi5gNXkpJBw9eA/5S0AYCk1SWdGBGPFU4S41str8l7gT9ExKz+j3yFUItjhD62MyKOzsfEPp0WkrufWTW/HglsAcysIN6eiogFpFL2yZIG9zqeVpwISor0E+wDgXdJekTS74AfAJ/rbWSV+C9St7kARMQkUvvBr3J97lTadE8iaSKpYWwLSbMkFRPKoQyMaqGW6nKMLO12SjpI0ixgF+BaSdflSbsDd+fqkx8B/xQRy9xV84osIn4P3E36Dqxw3MWEmVnNuURgZlZzTgRmZjXnRGBmVnNOBGZmNedEYGZWc04ENuDknlQvLgyvKmmepJ/l4aPy8LTck+oxhXkPyu9/W4vlbp+n7dlh3TMl3SvpHkk35/vjO8U6StJHCsOjJZ2ztNtstjycCGwgegHYWtLr8vD7gD83zXNF/tXnWOCrkt6cx48DJtP6fu/GtHF9rP/dEbENcBNwWiLPIscAAAJ/SURBVB/zjgIWJYKImBIRVXbxYbYEJwIbqH4O7Jtft+3fKCLmAg8BIyWtDexG+lX1axJB7jX1YOAo4P0l+8RZ1ONkvvK/VdJd+W/XPM+ZwDty6eTTksYWSi5nKD3f4abc7/+iBCHp3yX9QdL1kiaqzfMhzMpwIrCB6nLg0HzC3gb4bauZJG0KbArMIP1a9hcR8X/AfEk7FGbdDXgkIh4iXel37D4h24vUbz/AXOB9EbEDcAjQqP45Bbg1d8nwzRbLeBuwJzAGOF3SYKWHu3wQ2J7Ud9PoFu8zK20gPQTCbJGIuEfSKFJpoFXnZ4dI2p30QJ5PRMR8SeNIne5BSiTjWNzd8rg8rjHtcNo/XOfGXNU0l8VVQ4OBcyVtB7wCvLXkplwbES8DL0uaC7yZ1DXDTyLiJQBJPy25LLOWnAhsILsG+AapHWD9pmlXRMQJjQFJ65MeuLK1pAAGASHpX0kl5w8C/yDpVEDA+pLWiYjnWqz33aR2iguBLwGfIT3w5wlg27y8v5TchpcLr18hfWdV8r1mpbhqyAayC4AvRcS9JeY9GLgoIkZGxKiI2Bh4hHT1/V7g7ojYOE8bSXrc5oHtFpav1k8CjpC0HvAGYE5EvEoqTQzKsz4HrLOU2zUZ2F/SGrldY9++3mDWiROBDVgRMSsizi45+zhSD5hFV5Hu6Ok0rdP655AaqY8HzgeOlHQHqVrohTzbPcDC/GCXVo8JbbXcO0mlnbtJ1VNTaP8MabM+ufdRs5WQpLUj4nlJa5IeCn9sRAzIx2Ra9dxGYLZymiBpS9JD33/gJGDLwyUCM7OacxuBmVnNORGYmdWcE4GZWc05EZiZ1ZwTgZlZzf0/ph4fdklyuS8AAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "#Visualize\n",
    "\n",
    "\n",
    "\n",
    "ax1 = bar2_df.plot.bar(x='MPAA Rating', y='Worldwide Revenue', rot=0)\n",
    "\n",
    "ax1.set_xlabel('MPAA Rating')\n",
    "# # plt.xticks(rotation = 75) # Rotates X-Axis Ticks by 45-degrees\n",
    "ax1.set_ylabel('Worldwide Revenue')\n",
    "ax1.set_title('Worldwide Revenue Based on Movie MPAA Ratings')\n",
    "\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "dd9b0cfd",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "dd796e9b",
   "metadata": {},
   "source": [
    "### Save to CSV for future use"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "4f897bdf",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Save df to csv\n",
    "\n",
    "#random_name_csv.to_csv('./Resources/Random_name2.csv',index=False)\n",
    "\n",
    "final_movie_db_df.to_csv('./Resources/movie_db.csv', index=False, header=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "bdf6326a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 2475 entries, 0 to 2584\n",
      "Data columns (total 17 columns):\n",
      " #   Column                       Non-Null Count  Dtype  \n",
      "---  ------                       --------------  -----  \n",
      " 0   Title                        2475 non-null   object \n",
      " 1   Year                         2475 non-null   int64  \n",
      " 2   Budget                       2475 non-null   int64  \n",
      " 3   Domestic Revenue             2475 non-null   int64  \n",
      " 4   International Revenue        2475 non-null   int64  \n",
      " 5   Worldwide Revenue            2475 non-null   int64  \n",
      " 6   MPAA Rating                  2413 non-null   object \n",
      " 7   Run Time                     2475 non-null   object \n",
      " 8   Genre                        2475 non-null   object \n",
      " 9   Metacritic Mixed Reviews     2475 non-null   float64\n",
      " 10  Metacritic Negative Reviews  2475 non-null   float64\n",
      " 11  Metacritic Positive Reviews  2475 non-null   float64\n",
      " 12  Metascore                    2475 non-null   float64\n",
      " 13  Users Mixed Reviews          2475 non-null   float64\n",
      " 14  Users Negative Reviews       2475 non-null   float64\n",
      " 15  Users Positive Reviews       2475 non-null   float64\n",
      " 16  Userscore                    2475 non-null   float64\n",
      "dtypes: float64(8), int64(5), object(4)\n",
      "memory usage: 348.0+ KB\n"
     ]
    }
   ],
   "source": [
    "final_movie_db_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "8b5f8c4c",
   "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>Year</th>\n",
       "      <th>Budget</th>\n",
       "      <th>Domestic Revenue</th>\n",
       "      <th>International Revenue</th>\n",
       "      <th>Worldwide Revenue</th>\n",
       "      <th>Metacritic Mixed Reviews</th>\n",
       "      <th>Metacritic Negative Reviews</th>\n",
       "      <th>Metacritic Positive Reviews</th>\n",
       "      <th>Metascore</th>\n",
       "      <th>Users Mixed Reviews</th>\n",
       "      <th>Users Negative Reviews</th>\n",
       "      <th>Users Positive Reviews</th>\n",
       "      <th>Userscore</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>2475.000000</td>\n",
       "      <td>2.475000e+03</td>\n",
       "      <td>2.475000e+03</td>\n",
       "      <td>2.475000e+03</td>\n",
       "      <td>2.475000e+03</td>\n",
       "      <td>2475.000000</td>\n",
       "      <td>2475.000000</td>\n",
       "      <td>2475.000000</td>\n",
       "      <td>2475.000000</td>\n",
       "      <td>2475.000000</td>\n",
       "      <td>2475.000000</td>\n",
       "      <td>2475.000000</td>\n",
       "      <td>2475.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>2008.868283</td>\n",
       "      <td>5.055986e+07</td>\n",
       "      <td>6.680369e+07</td>\n",
       "      <td>8.810686e+07</td>\n",
       "      <td>1.549105e+08</td>\n",
       "      <td>11.341656</td>\n",
       "      <td>5.542269</td>\n",
       "      <td>15.086290</td>\n",
       "      <td>52.588261</td>\n",
       "      <td>51.708279</td>\n",
       "      <td>43.457293</td>\n",
       "      <td>207.643890</td>\n",
       "      <td>6.543854</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>5.631900</td>\n",
       "      <td>4.956858e+07</td>\n",
       "      <td>8.275647e+07</td>\n",
       "      <td>1.509255e+08</td>\n",
       "      <td>2.256294e+08</td>\n",
       "      <td>5.870246</td>\n",
       "      <td>5.494565</td>\n",
       "      <td>11.618359</td>\n",
       "      <td>16.699239</td>\n",
       "      <td>69.065642</td>\n",
       "      <td>75.150167</td>\n",
       "      <td>382.062626</td>\n",
       "      <td>1.475199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>2000.000000</td>\n",
       "      <td>2.200000e+02</td>\n",
       "      <td>8.000000e+03</td>\n",
       "      <td>9.990000e+02</td>\n",
       "      <td>7.962400e+04</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2004.000000</td>\n",
       "      <td>1.600000e+07</td>\n",
       "      <td>1.695038e+07</td>\n",
       "      <td>7.737332e+06</td>\n",
       "      <td>2.967042e+07</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>41.000000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>5.800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>2009.000000</td>\n",
       "      <td>3.500000e+07</td>\n",
       "      <td>3.978503e+07</td>\n",
       "      <td>3.384364e+07</td>\n",
       "      <td>7.602513e+07</td>\n",
       "      <td>11.341656</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>52.588261</td>\n",
       "      <td>34.000000</td>\n",
       "      <td>24.000000</td>\n",
       "      <td>88.000000</td>\n",
       "      <td>6.543854</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>2014.000000</td>\n",
       "      <td>6.900000e+07</td>\n",
       "      <td>8.306080e+07</td>\n",
       "      <td>9.788564e+07</td>\n",
       "      <td>1.805854e+08</td>\n",
       "      <td>15.000000</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>23.000000</td>\n",
       "      <td>64.000000</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>45.000000</td>\n",
       "      <td>207.643890</td>\n",
       "      <td>7.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>2020.000000</td>\n",
       "      <td>3.560000e+08</td>\n",
       "      <td>9.366622e+08</td>\n",
       "      <td>2.029931e+09</td>\n",
       "      <td>2.797801e+09</td>\n",
       "      <td>36.000000</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>56.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>1197.000000</td>\n",
       "      <td>1423.000000</td>\n",
       "      <td>5128.000000</td>\n",
       "      <td>9.400000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Year        Budget  Domestic Revenue  International Revenue  \\\n",
       "count  2475.000000  2.475000e+03      2.475000e+03           2.475000e+03   \n",
       "mean   2008.868283  5.055986e+07      6.680369e+07           8.810686e+07   \n",
       "std       5.631900  4.956858e+07      8.275647e+07           1.509255e+08   \n",
       "min    2000.000000  2.200000e+02      8.000000e+03           9.990000e+02   \n",
       "25%    2004.000000  1.600000e+07      1.695038e+07           7.737332e+06   \n",
       "50%    2009.000000  3.500000e+07      3.978503e+07           3.384364e+07   \n",
       "75%    2014.000000  6.900000e+07      8.306080e+07           9.788564e+07   \n",
       "max    2020.000000  3.560000e+08      9.366622e+08           2.029931e+09   \n",
       "\n",
       "       Worldwide Revenue  Metacritic Mixed Reviews  \\\n",
       "count       2.475000e+03               2475.000000   \n",
       "mean        1.549105e+08                 11.341656   \n",
       "std         2.256294e+08                  5.870246   \n",
       "min         7.962400e+04                  0.000000   \n",
       "25%         2.967042e+07                  7.000000   \n",
       "50%         7.602513e+07                 11.341656   \n",
       "75%         1.805854e+08                 15.000000   \n",
       "max         2.797801e+09                 36.000000   \n",
       "\n",
       "       Metacritic Negative Reviews  Metacritic Positive Reviews    Metascore  \\\n",
       "count                  2475.000000                  2475.000000  2475.000000   \n",
       "mean                      5.542269                    15.086290    52.588261   \n",
       "std                       5.494565                    11.618359    16.699239   \n",
       "min                       0.000000                     0.000000     9.000000   \n",
       "25%                       1.000000                     5.000000    41.000000   \n",
       "50%                       4.000000                    14.000000    52.588261   \n",
       "75%                       8.000000                    23.000000    64.000000   \n",
       "max                      30.000000                    56.000000   100.000000   \n",
       "\n",
       "       Users Mixed Reviews  Users Negative Reviews  Users Positive Reviews  \\\n",
       "count          2475.000000             2475.000000             2475.000000   \n",
       "mean             51.708279               43.457293              207.643890   \n",
       "std              69.065642               75.150167              382.062626   \n",
       "min               0.000000                0.000000                0.000000   \n",
       "25%              13.000000                9.000000               30.000000   \n",
       "50%              34.000000               24.000000               88.000000   \n",
       "75%              60.000000               45.000000              207.643890   \n",
       "max            1197.000000             1423.000000             5128.000000   \n",
       "\n",
       "         Userscore  \n",
       "count  2475.000000  \n",
       "mean      6.543854  \n",
       "std       1.475199  \n",
       "min       1.000000  \n",
       "25%       5.800000  \n",
       "50%       6.543854  \n",
       "75%       7.600000  \n",
       "max       9.400000  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_movie_db_df.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "a4240589",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2021-06-16 19:11:17,119 INFO sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1\n",
      "2021-06-16 19:11:17,120 INFO sqlalchemy.engine.base.Engine ()\n",
      "2021-06-16 19:11:17,127 INFO sqlalchemy.engine.base.Engine SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1\n",
      "2021-06-16 19:11:17,129 INFO sqlalchemy.engine.base.Engine ()\n"
     ]
    }
   ],
   "source": [
    "engine=create_engine(\"sqlite:///final_movie_db.sqlite\", echo=True)\n",
    "sqlite_connection=engine.connect()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "7324ff60",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2021-06-16 19:11:17,148 INFO sqlalchemy.engine.base.Engine PRAGMA main.table_info(\"final_movie\")\n",
      "2021-06-16 19:11:17,149 INFO sqlalchemy.engine.base.Engine ()\n",
      "2021-06-16 19:11:17,154 INFO sqlalchemy.engine.base.Engine PRAGMA temp.table_info(\"final_movie\")\n",
      "2021-06-16 19:11:17,155 INFO sqlalchemy.engine.base.Engine ()\n",
      "2021-06-16 19:11:17,160 INFO sqlalchemy.engine.base.Engine \n",
      "CREATE TABLE final_movie (\n",
      "\t\"index\" BIGINT, \n",
      "\t\"Title\" TEXT, \n",
      "\t\"Year\" BIGINT, \n",
      "\t\"Budget\" BIGINT, \n",
      "\t\"Domestic Revenue\" BIGINT, \n",
      "\t\"International Revenue\" BIGINT, \n",
      "\t\"Worldwide Revenue\" BIGINT, \n",
      "\t\"MPAA Rating\" TEXT, \n",
      "\t\"Run Time\" TEXT, \n",
      "\t\"Genre\" TEXT, \n",
      "\t\"Metacritic Mixed Reviews\" FLOAT, \n",
      "\t\"Metacritic Negative Reviews\" FLOAT, \n",
      "\t\"Metacritic Positive Reviews\" FLOAT, \n",
      "\t\"Metascore\" FLOAT, \n",
      "\t\"Users Mixed Reviews\" FLOAT, \n",
      "\t\"Users Negative Reviews\" FLOAT, \n",
      "\t\"Users Positive Reviews\" FLOAT, \n",
      "\t\"Userscore\" FLOAT\n",
      ")\n",
      "\n",
      "\n",
      "2021-06-16 19:11:17,162 INFO sqlalchemy.engine.base.Engine ()\n",
      "2021-06-16 19:11:17,175 INFO sqlalchemy.engine.base.Engine COMMIT\n",
      "2021-06-16 19:11:17,177 INFO sqlalchemy.engine.base.Engine CREATE INDEX ix_final_movie_index ON final_movie (\"index\")\n",
      "2021-06-16 19:11:17,180 INFO sqlalchemy.engine.base.Engine ()\n",
      "2021-06-16 19:11:17,189 INFO sqlalchemy.engine.base.Engine COMMIT\n",
      "2021-06-16 19:11:17,196 INFO sqlalchemy.engine.base.Engine BEGIN (implicit)\n",
      "2021-06-16 19:11:17,255 INFO sqlalchemy.engine.base.Engine INSERT INTO final_movie (\"index\", \"Title\", \"Year\", \"Budget\", \"Domestic Revenue\", \"International Revenue\", \"Worldwide Revenue\", \"MPAA Rating\", \"Run Time\", \"Genre\", \"Metacritic Mixed Reviews\", \"Metacritic Negative Reviews\", \"Metacritic Positive Reviews\", \"Metascore\", \"Users Mixed Reviews\", \"Users Negative Reviews\", \"Users Positive Reviews\", \"Userscore\") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n",
      "2021-06-16 19:11:17,256 INFO sqlalchemy.engine.base.Engine ((0, 'Glitter', 2001, 22000000, 4274407, 997259, 5271666, 'PG-13', '1 hr 44 min', 'Drama', 3.0, 20.0, 0.0, 14.0, 9.0, 59.0, 31.0, 3.6), (1, 'Chicken Run', 2000, 45000000, 106834564, 118000000, 224834564, None, '1 hr 24 min', 'Adventure', 1.0, 0.0, 33.0, 88.0, 36.0, 9.0, 258.0, 8.2), (2, 'Fantastic Four', 2005, 100000000, 154696080, 178839854, 333535934, 'PG-13', '1 hr 46 min', 'Action', 18.0, 11.0, 6.0, 40.0, 161.0, 177.0, 305.0, 5.7), (4, 'Frida', 2002, 12000000, 25885000, 30413474, 56298474, 'R', '2 hr 3 min', 'Biography', 17.0, 1.0, 20.0, 61.0, 4.0, 2.0, 34.0, 7.4), (5, 'From Hell', 2001, 35000000, 31602566, 42955549, 74558115, 'R', '2 hr 2 min', 'Horror', 10.0, 7.0, 15.0, 54.0, 23.0, 37.0, 54.0, 5.2), (6, 'The Lord of the Rings: The Fellowship of the Ring', 2001, 93000000, 315544750, 572288076, 887832826, 'PG-13', '2 hr 58 min', 'Action', 1.0, 0.0, 33.0, 92.0, 50.0, 59.0, 1816.0, 9.1), (7, 'Mission: Impossible II', 2000, 125000000, 215409889, 330978219, 546388108, 'PG-13', '2 hr 3 min', 'Action', 14.0, 3.0, 23.0, 59.0, 159.0, 33.0, 361.0, 7.8), (8, 'Resident Evil', 2002, 33000000, 40119709, 62865153, 102984862, 'R', '1 hr 40 min', 'Action', 11.0, 11.0, 2.0, 33.0, 93.0, 46.0, 218.0, 6.8)  ... displaying 10 of 2475 total bound parameter sets ...  (2583, 'Playing with Fire', 2019, 29900000, 44451847, 24179822, 68631669, 'PG', '1 hr 36 min', 'Comedy', 11.341655716162943, 5.5422689443714415, 15.086289969338589, 52.58826106000876, 51.70827858081472, 43.45729303547963, 207.64388961892246, 6.543854258121159), (2584, 'Brahms: The Boy II', 2020, 10000000, 12611536, 7700000, 20311536, 'PG-13', '1 hr 26 min', 'Drama', 11.341655716162943, 5.5422689443714415, 15.086289969338589, 52.58826106000876, 51.70827858081472, 43.45729303547963, 207.64388961892246, 6.543854258121159))\n",
      "2021-06-16 19:11:17,276 INFO sqlalchemy.engine.base.Engine COMMIT\n"
     ]
    }
   ],
   "source": [
    "sqlite_table=\"final_movie\"\n",
    "final_movie_db_df.to_sql(sqlite_table, sqlite_connection, if_exists=\"fail\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "e69d6e26",
   "metadata": {},
   "outputs": [],
   "source": [
    "sqlite_connection.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6452d866",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.6.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}