Projects/Deep_Learning_Projects/Collaborative_Filtering/Movie_Recommender_System(Collaborative_Filtering).ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# <font color = \"red\">  Movie Recommender System </font> <font color = \"darkgreen\"> *By Harshit Dawar*</font>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## <font color = \"brown\">  Recommender Systens\n",
    "- These are the systems which have the ability to recommend items to the users.\n",
    "- Recommendation can be anything, some of the most popular recommendations are: -\n",
    "  -  Items on ecommerce webssited like Amazon or Flipkart.\n",
    "  -  Movies\n",
    "    \n",
    "### Types of Recommender Systems\n",
    "#### User Based Recommender Systems\n",
    "-  These systems use users searches as a base to recommend items.\n",
    "-  Matrix of what a user is watching is created, and if another user watches same movie than both the users are treated as equivalent and what a other user has watched is shown as recommendation to other.\n",
    "- Their Limitations are:\n",
    "    -  There are many more users than movies(which makes the problem really very complex).\n",
    "    -  Users taste may change over time. So, the recommendation will not be right one.\n",
    "   \n",
    "#### Item based Recommender Systems\n",
    "- Its benefits are: \n",
    "    -  They recommend items based on relationships between items like movies and not based on humans/users.\n",
    "    - Reduces complexity of the problem and enhances performance.\n",
    "    - Items features and tastes never change over time.\n",
    "   \n",
    "    "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## <font color = \"brown\">  Importing Libraries and Dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "movie_titles_data = pd.read_csv(\"Movie_Id_Titles\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1682, 2)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movie_titles_data.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>item_id</th>\n",
       "      <th>title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Toy Story (1995)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>GoldenEye (1995)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Four Rooms (1995)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Get Shorty (1995)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Copycat (1995)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>Shanghai Triad (Yao a yao yao dao waipo qiao) ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>Twelve Monkeys (1995)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>Babe (1995)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>Dead Man Walking (1995)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>Richard III (1995)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>Seven (Se7en) (1995)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>Usual Suspects, The (1995)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>Mighty Aphrodite (1995)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>Postino, Il (1994)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>Mr. Holland's Opus (1995)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    item_id                                              title\n",
       "0         1                                   Toy Story (1995)\n",
       "1         2                                   GoldenEye (1995)\n",
       "2         3                                  Four Rooms (1995)\n",
       "3         4                                  Get Shorty (1995)\n",
       "4         5                                     Copycat (1995)\n",
       "5         6  Shanghai Triad (Yao a yao yao dao waipo qiao) ...\n",
       "6         7                              Twelve Monkeys (1995)\n",
       "7         8                                        Babe (1995)\n",
       "8         9                            Dead Man Walking (1995)\n",
       "9        10                                 Richard III (1995)\n",
       "10       11                               Seven (Se7en) (1995)\n",
       "11       12                         Usual Suspects, The (1995)\n",
       "12       13                            Mighty Aphrodite (1995)\n",
       "13       14                                 Postino, Il (1994)\n",
       "14       15                          Mr. Holland's Opus (1995)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movie_titles_data.head(15)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "movie_ratings_data = pd.read_csv(\"u.data\", sep = \"\\t\", names = [\"user_id\",\"item_id\",\"rating\",\"Timestamp\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(100003, 4)"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movie_ratings_data.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>user_id</th>\n",
       "      <th>item_id</th>\n",
       "      <th>rating</th>\n",
       "      <th>Timestamp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>50</td>\n",
       "      <td>5</td>\n",
       "      <td>881250949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>172</td>\n",
       "      <td>5</td>\n",
       "      <td>881250949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>133</td>\n",
       "      <td>1</td>\n",
       "      <td>881250949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>196</td>\n",
       "      <td>242</td>\n",
       "      <td>3</td>\n",
       "      <td>881250949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>186</td>\n",
       "      <td>302</td>\n",
       "      <td>3</td>\n",
       "      <td>891717742</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>22</td>\n",
       "      <td>377</td>\n",
       "      <td>1</td>\n",
       "      <td>878887116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>244</td>\n",
       "      <td>51</td>\n",
       "      <td>2</td>\n",
       "      <td>880606923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>166</td>\n",
       "      <td>346</td>\n",
       "      <td>1</td>\n",
       "      <td>886397596</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>298</td>\n",
       "      <td>474</td>\n",
       "      <td>4</td>\n",
       "      <td>884182806</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>115</td>\n",
       "      <td>265</td>\n",
       "      <td>2</td>\n",
       "      <td>881171488</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>253</td>\n",
       "      <td>465</td>\n",
       "      <td>5</td>\n",
       "      <td>891628467</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>305</td>\n",
       "      <td>451</td>\n",
       "      <td>3</td>\n",
       "      <td>886324817</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>6</td>\n",
       "      <td>86</td>\n",
       "      <td>3</td>\n",
       "      <td>883603013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>62</td>\n",
       "      <td>257</td>\n",
       "      <td>2</td>\n",
       "      <td>879372434</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>286</td>\n",
       "      <td>1014</td>\n",
       "      <td>5</td>\n",
       "      <td>879781125</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    user_id  item_id  rating  Timestamp\n",
       "0         0       50       5  881250949\n",
       "1         0      172       5  881250949\n",
       "2         0      133       1  881250949\n",
       "3       196      242       3  881250949\n",
       "4       186      302       3  891717742\n",
       "5        22      377       1  878887116\n",
       "6       244       51       2  880606923\n",
       "7       166      346       1  886397596\n",
       "8       298      474       4  884182806\n",
       "9       115      265       2  881171488\n",
       "10      253      465       5  891628467\n",
       "11      305      451       3  886324817\n",
       "12        6       86       3  883603013\n",
       "13       62      257       2  879372434\n",
       "14      286     1014       5  879781125"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movie_ratings_data.head(15)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "movie_ratings_data = movie_ratings_data.drop(\"Timestamp\", axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>user_id</th>\n",
       "      <th>item_id</th>\n",
       "      <th>rating</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>50</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>172</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>133</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>196</td>\n",
       "      <td>242</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>186</td>\n",
       "      <td>302</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99998</th>\n",
       "      <td>880</td>\n",
       "      <td>476</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99999</th>\n",
       "      <td>716</td>\n",
       "      <td>204</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100000</th>\n",
       "      <td>276</td>\n",
       "      <td>1090</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100001</th>\n",
       "      <td>13</td>\n",
       "      <td>225</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100002</th>\n",
       "      <td>12</td>\n",
       "      <td>203</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100003 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        user_id  item_id  rating\n",
       "0             0       50       5\n",
       "1             0      172       5\n",
       "2             0      133       1\n",
       "3           196      242       3\n",
       "4           186      302       3\n",
       "...         ...      ...     ...\n",
       "99998       880      476       3\n",
       "99999       716      204       5\n",
       "100000      276     1090       1\n",
       "100001       13      225       2\n",
       "100002       12      203       3\n",
       "\n",
       "[100003 rows x 3 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movie_ratings_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>user_id</th>\n",
       "      <th>item_id</th>\n",
       "      <th>rating</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>100003.000000</td>\n",
       "      <td>100003.000000</td>\n",
       "      <td>100003.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>462.470876</td>\n",
       "      <td>425.520914</td>\n",
       "      <td>3.529864</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>266.622454</td>\n",
       "      <td>330.797791</td>\n",
       "      <td>1.125704</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>254.000000</td>\n",
       "      <td>175.000000</td>\n",
       "      <td>3.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>447.000000</td>\n",
       "      <td>322.000000</td>\n",
       "      <td>4.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>682.000000</td>\n",
       "      <td>631.000000</td>\n",
       "      <td>4.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>943.000000</td>\n",
       "      <td>1682.000000</td>\n",
       "      <td>5.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             user_id        item_id         rating\n",
       "count  100003.000000  100003.000000  100003.000000\n",
       "mean      462.470876     425.520914       3.529864\n",
       "std       266.622454     330.797791       1.125704\n",
       "min         0.000000       1.000000       1.000000\n",
       "25%       254.000000     175.000000       3.000000\n",
       "50%       447.000000     322.000000       4.000000\n",
       "75%       682.000000     631.000000       4.000000\n",
       "max       943.000000    1682.000000       5.000000"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movie_ratings_data.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 100003 entries, 0 to 100002\n",
      "Data columns (total 3 columns):\n",
      " #   Column   Non-Null Count   Dtype\n",
      "---  ------   --------------   -----\n",
      " 0   user_id  100003 non-null  int64\n",
      " 1   item_id  100003 non-null  int64\n",
      " 2   rating   100003 non-null  int64\n",
      "dtypes: int64(3)\n",
      "memory usage: 2.3 MB\n"
     ]
    }
   ],
   "source": [
    "movie_ratings_data.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Merging both Datasets\n",
    "\n",
    "Movies_Final_Data = pd.merge(movie_ratings_data, movie_titles_data, on = \"item_id\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "scrolled": false
   },
   "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>user_id</th>\n",
       "      <th>item_id</th>\n",
       "      <th>rating</th>\n",
       "      <th>title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>50</td>\n",
       "      <td>5</td>\n",
       "      <td>Star Wars (1977)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>290</td>\n",
       "      <td>50</td>\n",
       "      <td>5</td>\n",
       "      <td>Star Wars (1977)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>79</td>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>Star Wars (1977)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2</td>\n",
       "      <td>50</td>\n",
       "      <td>5</td>\n",
       "      <td>Star Wars (1977)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>8</td>\n",
       "      <td>50</td>\n",
       "      <td>5</td>\n",
       "      <td>Star Wars (1977)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99998</th>\n",
       "      <td>840</td>\n",
       "      <td>1674</td>\n",
       "      <td>4</td>\n",
       "      <td>Mamma Roma (1962)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99999</th>\n",
       "      <td>655</td>\n",
       "      <td>1640</td>\n",
       "      <td>3</td>\n",
       "      <td>Eighth Day, The (1996)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100000</th>\n",
       "      <td>655</td>\n",
       "      <td>1637</td>\n",
       "      <td>3</td>\n",
       "      <td>Girls Town (1996)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100001</th>\n",
       "      <td>655</td>\n",
       "      <td>1630</td>\n",
       "      <td>3</td>\n",
       "      <td>Silence of the Palace, The (Saimt el Qusur) (1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100002</th>\n",
       "      <td>655</td>\n",
       "      <td>1641</td>\n",
       "      <td>3</td>\n",
       "      <td>Dadetown (1995)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100003 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        user_id  item_id  rating  \\\n",
       "0             0       50       5   \n",
       "1           290       50       5   \n",
       "2            79       50       4   \n",
       "3             2       50       5   \n",
       "4             8       50       5   \n",
       "...         ...      ...     ...   \n",
       "99998       840     1674       4   \n",
       "99999       655     1640       3   \n",
       "100000      655     1637       3   \n",
       "100001      655     1630       3   \n",
       "100002      655     1641       3   \n",
       "\n",
       "                                                    title  \n",
       "0                                        Star Wars (1977)  \n",
       "1                                        Star Wars (1977)  \n",
       "2                                        Star Wars (1977)  \n",
       "3                                        Star Wars (1977)  \n",
       "4                                        Star Wars (1977)  \n",
       "...                                                   ...  \n",
       "99998                                   Mamma Roma (1962)  \n",
       "99999                              Eighth Day, The (1996)  \n",
       "100000                                  Girls Town (1996)  \n",
       "100001  Silence of the Palace, The (Saimt el Qusur) (1...  \n",
       "100002                                    Dadetown (1995)  \n",
       "\n",
       "[100003 rows x 4 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Movies_Final_Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(100003, 4)"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Movies_Final_Data.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## <font color = \"brown\">  Visualizing the Dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "scrolled": true
   },
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"8\" halign=\"left\">user_id</th>\n",
       "      <th colspan=\"5\" halign=\"left\">item_id</th>\n",
       "      <th colspan=\"8\" halign=\"left\">rating</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "      <th>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>...</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "      <th>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>'Til There Was You (1997)</th>\n",
       "      <td>9.0</td>\n",
       "      <td>383.777778</td>\n",
       "      <td>204.272354</td>\n",
       "      <td>152.0</td>\n",
       "      <td>223.0</td>\n",
       "      <td>342.0</td>\n",
       "      <td>530.0</td>\n",
       "      <td>782.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2.333333</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.00</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1-900 (1994)</th>\n",
       "      <td>5.0</td>\n",
       "      <td>477.000000</td>\n",
       "      <td>244.344020</td>\n",
       "      <td>181.0</td>\n",
       "      <td>385.0</td>\n",
       "      <td>405.0</td>\n",
       "      <td>581.0</td>\n",
       "      <td>833.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1353.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1353.0</td>\n",
       "      <td>1353.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.600000</td>\n",
       "      <td>1.516575</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101 Dalmatians (1996)</th>\n",
       "      <td>109.0</td>\n",
       "      <td>450.330275</td>\n",
       "      <td>295.142779</td>\n",
       "      <td>1.0</td>\n",
       "      <td>183.0</td>\n",
       "      <td>435.0</td>\n",
       "      <td>699.0</td>\n",
       "      <td>938.0</td>\n",
       "      <td>109.0</td>\n",
       "      <td>225.0</td>\n",
       "      <td>...</td>\n",
       "      <td>225.0</td>\n",
       "      <td>225.0</td>\n",
       "      <td>109.0</td>\n",
       "      <td>2.908257</td>\n",
       "      <td>1.076184</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.00</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12 Angry Men (1957)</th>\n",
       "      <td>125.0</td>\n",
       "      <td>453.552000</td>\n",
       "      <td>255.588677</td>\n",
       "      <td>1.0</td>\n",
       "      <td>268.0</td>\n",
       "      <td>429.0</td>\n",
       "      <td>661.0</td>\n",
       "      <td>932.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>178.0</td>\n",
       "      <td>...</td>\n",
       "      <td>178.0</td>\n",
       "      <td>178.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>4.344000</td>\n",
       "      <td>0.719588</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187 (1997)</th>\n",
       "      <td>41.0</td>\n",
       "      <td>517.097561</td>\n",
       "      <td>241.098300</td>\n",
       "      <td>3.0</td>\n",
       "      <td>416.0</td>\n",
       "      <td>532.0</td>\n",
       "      <td>698.0</td>\n",
       "      <td>894.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>330.0</td>\n",
       "      <td>...</td>\n",
       "      <td>330.0</td>\n",
       "      <td>330.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>3.024390</td>\n",
       "      <td>1.172344</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.00</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</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>Young Guns II (1990)</th>\n",
       "      <td>44.0</td>\n",
       "      <td>504.068182</td>\n",
       "      <td>254.101371</td>\n",
       "      <td>87.0</td>\n",
       "      <td>301.0</td>\n",
       "      <td>459.0</td>\n",
       "      <td>732.5</td>\n",
       "      <td>943.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>1188.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1188.0</td>\n",
       "      <td>1188.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>2.772727</td>\n",
       "      <td>1.008421</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.00</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Young Poisoner's Handbook, The (1995)</th>\n",
       "      <td>41.0</td>\n",
       "      <td>452.487805</td>\n",
       "      <td>286.352241</td>\n",
       "      <td>7.0</td>\n",
       "      <td>246.0</td>\n",
       "      <td>473.0</td>\n",
       "      <td>634.0</td>\n",
       "      <td>936.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>547.0</td>\n",
       "      <td>...</td>\n",
       "      <td>547.0</td>\n",
       "      <td>547.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>3.341463</td>\n",
       "      <td>1.237129</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zeus and Roxanne (1997)</th>\n",
       "      <td>6.0</td>\n",
       "      <td>532.833333</td>\n",
       "      <td>343.690219</td>\n",
       "      <td>82.0</td>\n",
       "      <td>251.5</td>\n",
       "      <td>627.5</td>\n",
       "      <td>796.5</td>\n",
       "      <td>881.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1164.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1164.0</td>\n",
       "      <td>1164.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.166667</td>\n",
       "      <td>0.983192</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.25</td>\n",
       "      <td>2.5</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unknown</th>\n",
       "      <td>9.0</td>\n",
       "      <td>311.888889</td>\n",
       "      <td>264.160200</td>\n",
       "      <td>1.0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>297.0</td>\n",
       "      <td>422.0</td>\n",
       "      <td>833.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>267.0</td>\n",
       "      <td>...</td>\n",
       "      <td>267.0</td>\n",
       "      <td>267.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>3.444444</td>\n",
       "      <td>1.130388</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Á köldum klaka (Cold Fever) (1994)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>655.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>655.0</td>\n",
       "      <td>655.0</td>\n",
       "      <td>655.0</td>\n",
       "      <td>655.0</td>\n",
       "      <td>655.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1633.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1633.0</td>\n",
       "      <td>1633.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.00</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1664 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      user_id                                 \\\n",
       "                                        count        mean         std    min   \n",
       "title                                                                          \n",
       "'Til There Was You (1997)                 9.0  383.777778  204.272354  152.0   \n",
       "1-900 (1994)                              5.0  477.000000  244.344020  181.0   \n",
       "101 Dalmatians (1996)                   109.0  450.330275  295.142779    1.0   \n",
       "12 Angry Men (1957)                     125.0  453.552000  255.588677    1.0   \n",
       "187 (1997)                               41.0  517.097561  241.098300    3.0   \n",
       "...                                       ...         ...         ...    ...   \n",
       "Young Guns II (1990)                     44.0  504.068182  254.101371   87.0   \n",
       "Young Poisoner's Handbook, The (1995)    41.0  452.487805  286.352241    7.0   \n",
       "Zeus and Roxanne (1997)                   6.0  532.833333  343.690219   82.0   \n",
       "unknown                                   9.0  311.888889  264.160200    1.0   \n",
       "Á köldum klaka (Cold Fever) (1994)        1.0  655.000000         NaN  655.0   \n",
       "\n",
       "                                                                  item_id  \\\n",
       "                                         25%    50%    75%    max   count   \n",
       "title                                                                       \n",
       "'Til There Was You (1997)              223.0  342.0  530.0  782.0     9.0   \n",
       "1-900 (1994)                           385.0  405.0  581.0  833.0     5.0   \n",
       "101 Dalmatians (1996)                  183.0  435.0  699.0  938.0   109.0   \n",
       "12 Angry Men (1957)                    268.0  429.0  661.0  932.0   125.0   \n",
       "187 (1997)                             416.0  532.0  698.0  894.0    41.0   \n",
       "...                                      ...    ...    ...    ...     ...   \n",
       "Young Guns II (1990)                   301.0  459.0  732.5  943.0    44.0   \n",
       "Young Poisoner's Handbook, The (1995)  246.0  473.0  634.0  936.0    41.0   \n",
       "Zeus and Roxanne (1997)                251.5  627.5  796.5  881.0     6.0   \n",
       "unknown                                130.0  297.0  422.0  833.0     9.0   \n",
       "Á köldum klaka (Cold Fever) (1994)     655.0  655.0  655.0  655.0     1.0   \n",
       "\n",
       "                                               ...                 rating  \\\n",
       "                                         mean  ...     75%     max  count   \n",
       "title                                          ...                          \n",
       "'Til There Was You (1997)              1300.0  ...  1300.0  1300.0    9.0   \n",
       "1-900 (1994)                           1353.0  ...  1353.0  1353.0    5.0   \n",
       "101 Dalmatians (1996)                   225.0  ...   225.0   225.0  109.0   \n",
       "12 Angry Men (1957)                     178.0  ...   178.0   178.0  125.0   \n",
       "187 (1997)                              330.0  ...   330.0   330.0   41.0   \n",
       "...                                       ...  ...     ...     ...    ...   \n",
       "Young Guns II (1990)                   1188.0  ...  1188.0  1188.0   44.0   \n",
       "Young Poisoner's Handbook, The (1995)   547.0  ...   547.0   547.0   41.0   \n",
       "Zeus and Roxanne (1997)                1164.0  ...  1164.0  1164.0    6.0   \n",
       "unknown                                 267.0  ...   267.0   267.0    9.0   \n",
       "Á köldum klaka (Cold Fever) (1994)     1633.0  ...  1633.0  1633.0    1.0   \n",
       "\n",
       "                                                                           \\\n",
       "                                           mean       std  min   25%  50%   \n",
       "title                                                                       \n",
       "'Til There Was You (1997)              2.333333  1.000000  1.0  2.00  2.0   \n",
       "1-900 (1994)                           2.600000  1.516575  1.0  1.00  3.0   \n",
       "101 Dalmatians (1996)                  2.908257  1.076184  1.0  2.00  3.0   \n",
       "12 Angry Men (1957)                    4.344000  0.719588  2.0  4.00  4.0   \n",
       "187 (1997)                             3.024390  1.172344  1.0  2.00  3.0   \n",
       "...                                         ...       ...  ...   ...  ...   \n",
       "Young Guns II (1990)                   2.772727  1.008421  1.0  2.00  3.0   \n",
       "Young Poisoner's Handbook, The (1995)  3.341463  1.237129  1.0  3.00  4.0   \n",
       "Zeus and Roxanne (1997)                2.166667  0.983192  1.0  1.25  2.5   \n",
       "unknown                                3.444444  1.130388  1.0  3.00  4.0   \n",
       "Á köldum klaka (Cold Fever) (1994)     3.000000       NaN  3.0  3.00  3.0   \n",
       "\n",
       "                                                 \n",
       "                                       75%  max  \n",
       "title                                            \n",
       "'Til There Was You (1997)              3.0  4.0  \n",
       "1-900 (1994)                           4.0  4.0  \n",
       "101 Dalmatians (1996)                  4.0  5.0  \n",
       "12 Angry Men (1957)                    5.0  5.0  \n",
       "187 (1997)                             4.0  5.0  \n",
       "...                                    ...  ...  \n",
       "Young Guns II (1990)                   3.0  5.0  \n",
       "Young Poisoner's Handbook, The (1995)  4.0  5.0  \n",
       "Zeus and Roxanne (1997)                3.0  3.0  \n",
       "unknown                                4.0  5.0  \n",
       "Á köldum klaka (Cold Fever) (1994)     3.0  3.0  \n",
       "\n",
       "[1664 rows x 24 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Movies_Final_Data.groupby(\"title\").describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "Movies_Grouped_Final_Data = Movies_Final_Data.groupby(\"title\")[\"rating\"].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "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>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>'Til There Was You (1997)</th>\n",
       "      <td>9.0</td>\n",
       "      <td>2.333333</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.00</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1-900 (1994)</th>\n",
       "      <td>5.0</td>\n",
       "      <td>2.600000</td>\n",
       "      <td>1.516575</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101 Dalmatians (1996)</th>\n",
       "      <td>109.0</td>\n",
       "      <td>2.908257</td>\n",
       "      <td>1.076184</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.00</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12 Angry Men (1957)</th>\n",
       "      <td>125.0</td>\n",
       "      <td>4.344000</td>\n",
       "      <td>0.719588</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187 (1997)</th>\n",
       "      <td>41.0</td>\n",
       "      <td>3.024390</td>\n",
       "      <td>1.172344</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.00</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Young Guns II (1990)</th>\n",
       "      <td>44.0</td>\n",
       "      <td>2.772727</td>\n",
       "      <td>1.008421</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.00</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Young Poisoner's Handbook, The (1995)</th>\n",
       "      <td>41.0</td>\n",
       "      <td>3.341463</td>\n",
       "      <td>1.237129</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zeus and Roxanne (1997)</th>\n",
       "      <td>6.0</td>\n",
       "      <td>2.166667</td>\n",
       "      <td>0.983192</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.25</td>\n",
       "      <td>2.5</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unknown</th>\n",
       "      <td>9.0</td>\n",
       "      <td>3.444444</td>\n",
       "      <td>1.130388</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Á köldum klaka (Cold Fever) (1994)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.00</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1664 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       count      mean       std  min   25%  \\\n",
       "title                                                                         \n",
       "'Til There Was You (1997)                9.0  2.333333  1.000000  1.0  2.00   \n",
       "1-900 (1994)                             5.0  2.600000  1.516575  1.0  1.00   \n",
       "101 Dalmatians (1996)                  109.0  2.908257  1.076184  1.0  2.00   \n",
       "12 Angry Men (1957)                    125.0  4.344000  0.719588  2.0  4.00   \n",
       "187 (1997)                              41.0  3.024390  1.172344  1.0  2.00   \n",
       "...                                      ...       ...       ...  ...   ...   \n",
       "Young Guns II (1990)                    44.0  2.772727  1.008421  1.0  2.00   \n",
       "Young Poisoner's Handbook, The (1995)   41.0  3.341463  1.237129  1.0  3.00   \n",
       "Zeus and Roxanne (1997)                  6.0  2.166667  0.983192  1.0  1.25   \n",
       "unknown                                  9.0  3.444444  1.130388  1.0  3.00   \n",
       "Á köldum klaka (Cold Fever) (1994)       1.0  3.000000       NaN  3.0  3.00   \n",
       "\n",
       "                                       50%  75%  max  \n",
       "title                                                 \n",
       "'Til There Was You (1997)              2.0  3.0  4.0  \n",
       "1-900 (1994)                           3.0  4.0  4.0  \n",
       "101 Dalmatians (1996)                  3.0  4.0  5.0  \n",
       "12 Angry Men (1957)                    4.0  5.0  5.0  \n",
       "187 (1997)                             3.0  4.0  5.0  \n",
       "...                                    ...  ...  ...  \n",
       "Young Guns II (1990)                   3.0  3.0  5.0  \n",
       "Young Poisoner's Handbook, The (1995)  4.0  4.0  5.0  \n",
       "Zeus and Roxanne (1997)                2.5  3.0  3.0  \n",
       "unknown                                4.0  4.0  5.0  \n",
       "Á köldum klaka (Cold Fever) (1994)     3.0  3.0  3.0  \n",
       "\n",
       "[1664 rows x 8 columns]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Movies_Grouped_Final_Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "Movies_Grouped_Final_Mean_Data = Movies_Final_Data.groupby(\"title\")[\"rating\"].describe()[\"mean\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "title\n",
       "'Til There Was You (1997)                2.333333\n",
       "1-900 (1994)                             2.600000\n",
       "101 Dalmatians (1996)                    2.908257\n",
       "12 Angry Men (1957)                      4.344000\n",
       "187 (1997)                               3.024390\n",
       "                                           ...   \n",
       "Young Guns II (1990)                     2.772727\n",
       "Young Poisoner's Handbook, The (1995)    3.341463\n",
       "Zeus and Roxanne (1997)                  2.166667\n",
       "unknown                                  3.444444\n",
       "Á köldum klaka (Cold Fever) (1994)       3.000000\n",
       "Name: mean, Length: 1664, dtype: float64"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Movies_Grouped_Final_Mean_Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "Movies_Grouped_Final_Count_Data = Movies_Final_Data.groupby(\"title\")[\"rating\"].describe()[\"count\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "title\n",
       "'Til There Was You (1997)                  9.0\n",
       "1-900 (1994)                               5.0\n",
       "101 Dalmatians (1996)                    109.0\n",
       "12 Angry Men (1957)                      125.0\n",
       "187 (1997)                                41.0\n",
       "                                         ...  \n",
       "Young Guns II (1990)                      44.0\n",
       "Young Poisoner's Handbook, The (1995)     41.0\n",
       "Zeus and Roxanne (1997)                    6.0\n",
       "unknown                                    9.0\n",
       "Á köldum klaka (Cold Fever) (1994)         1.0\n",
       "Name: count, Length: 1664, dtype: float64"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Movies_Grouped_Final_Count_Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "Movie_Mean_Count_Data = pd.concat([Movies_Grouped_Final_Count_Data, Movies_Grouped_Final_Mean_Data], axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "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>count</th>\n",
       "      <th>mean</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>'Til There Was You (1997)</th>\n",
       "      <td>9.0</td>\n",
       "      <td>2.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1-900 (1994)</th>\n",
       "      <td>5.0</td>\n",
       "      <td>2.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101 Dalmatians (1996)</th>\n",
       "      <td>109.0</td>\n",
       "      <td>2.908257</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12 Angry Men (1957)</th>\n",
       "      <td>125.0</td>\n",
       "      <td>4.344000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187 (1997)</th>\n",
       "      <td>41.0</td>\n",
       "      <td>3.024390</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Young Guns II (1990)</th>\n",
       "      <td>44.0</td>\n",
       "      <td>2.772727</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Young Poisoner's Handbook, The (1995)</th>\n",
       "      <td>41.0</td>\n",
       "      <td>3.341463</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zeus and Roxanne (1997)</th>\n",
       "      <td>6.0</td>\n",
       "      <td>2.166667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unknown</th>\n",
       "      <td>9.0</td>\n",
       "      <td>3.444444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Á köldum klaka (Cold Fever) (1994)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>3.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1664 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       count      mean\n",
       "title                                                 \n",
       "'Til There Was You (1997)                9.0  2.333333\n",
       "1-900 (1994)                             5.0  2.600000\n",
       "101 Dalmatians (1996)                  109.0  2.908257\n",
       "12 Angry Men (1957)                    125.0  4.344000\n",
       "187 (1997)                              41.0  3.024390\n",
       "...                                      ...       ...\n",
       "Young Guns II (1990)                    44.0  2.772727\n",
       "Young Poisoner's Handbook, The (1995)   41.0  3.341463\n",
       "Zeus and Roxanne (1997)                  6.0  2.166667\n",
       "unknown                                  9.0  3.444444\n",
       "Á köldum klaka (Cold Fever) (1994)       1.0  3.000000\n",
       "\n",
       "[1664 rows x 2 columns]"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Movie_Mean_Count_Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "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>count</th>\n",
       "      <th>mean</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>'Til There Was You (1997)</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1-900 (1994)</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>101 Dalmatians (1996)</td>\n",
       "      <td>109.0</td>\n",
       "      <td>2.908257</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>12 Angry Men (1957)</td>\n",
       "      <td>125.0</td>\n",
       "      <td>4.344000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>187 (1997)</td>\n",
       "      <td>41.0</td>\n",
       "      <td>3.024390</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1659</th>\n",
       "      <td>Young Guns II (1990)</td>\n",
       "      <td>44.0</td>\n",
       "      <td>2.772727</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1660</th>\n",
       "      <td>Young Poisoner's Handbook, The (1995)</td>\n",
       "      <td>41.0</td>\n",
       "      <td>3.341463</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1661</th>\n",
       "      <td>Zeus and Roxanne (1997)</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.166667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1662</th>\n",
       "      <td>unknown</td>\n",
       "      <td>9.0</td>\n",
       "      <td>3.444444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1663</th>\n",
       "      <td>Á köldum klaka (Cold Fever) (1994)</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1664 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      title  count      mean\n",
       "0                 'Til There Was You (1997)    9.0  2.333333\n",
       "1                              1-900 (1994)    5.0  2.600000\n",
       "2                     101 Dalmatians (1996)  109.0  2.908257\n",
       "3                       12 Angry Men (1957)  125.0  4.344000\n",
       "4                                187 (1997)   41.0  3.024390\n",
       "...                                     ...    ...       ...\n",
       "1659                   Young Guns II (1990)   44.0  2.772727\n",
       "1660  Young Poisoner's Handbook, The (1995)   41.0  3.341463\n",
       "1661                Zeus and Roxanne (1997)    6.0  2.166667\n",
       "1662                                unknown    9.0  3.444444\n",
       "1663     Á köldum klaka (Cold Fever) (1994)    1.0  3.000000\n",
       "\n",
       "[1664 rows x 3 columns]"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Removing Title from index and making a index of simple numbers\n",
    "\n",
    "Movie_Mean_Count_Data.reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "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>count</th>\n",
       "      <th>mean</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>'Til There Was You (1997)</th>\n",
       "      <td>9.0</td>\n",
       "      <td>2.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1-900 (1994)</th>\n",
       "      <td>5.0</td>\n",
       "      <td>2.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101 Dalmatians (1996)</th>\n",
       "      <td>109.0</td>\n",
       "      <td>2.908257</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12 Angry Men (1957)</th>\n",
       "      <td>125.0</td>\n",
       "      <td>4.344000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187 (1997)</th>\n",
       "      <td>41.0</td>\n",
       "      <td>3.024390</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Young Guns II (1990)</th>\n",
       "      <td>44.0</td>\n",
       "      <td>2.772727</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Young Poisoner's Handbook, The (1995)</th>\n",
       "      <td>41.0</td>\n",
       "      <td>3.341463</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zeus and Roxanne (1997)</th>\n",
       "      <td>6.0</td>\n",
       "      <td>2.166667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unknown</th>\n",
       "      <td>9.0</td>\n",
       "      <td>3.444444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Á köldum klaka (Cold Fever) (1994)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>3.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1664 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       count      mean\n",
       "title                                                 \n",
       "'Til There Was You (1997)                9.0  2.333333\n",
       "1-900 (1994)                             5.0  2.600000\n",
       "101 Dalmatians (1996)                  109.0  2.908257\n",
       "12 Angry Men (1957)                    125.0  4.344000\n",
       "187 (1997)                              41.0  3.024390\n",
       "...                                      ...       ...\n",
       "Young Guns II (1990)                    44.0  2.772727\n",
       "Young Poisoner's Handbook, The (1995)   41.0  3.341463\n",
       "Zeus and Roxanne (1997)                  6.0  2.166667\n",
       "unknown                                  9.0  3.444444\n",
       "Á köldum klaka (Cold Fever) (1994)       1.0  3.000000\n",
       "\n",
       "[1664 rows x 2 columns]"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Movie_Mean_Count_Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYUAAAEGCAYAAACKB4k+AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAcQklEQVR4nO3de5RddZnm8e+TECghmAiEMhAgESKhEgRSENAgJkCPtq2APdiNTXMTjA4g0I4zouNSpntp47SCl7SjKHQDTQyXqKRtb4CFBmwCCRdDEYEIWVANY9IJISkkQJJ3/ti7todKVWqfU+ecvVPn+axVq87Z16d+VXXeff1tRQRmZmYAo4oOYGZm5eGiYGZmGRcFMzPLuCiYmVnGRcHMzDK7FB1gOPbZZ5+YPHlyTfO+9NJL7LHHHvUNVAfOVR3nql5ZszlXdYaTa/ny5f8ZERMGHBkRO+1XZ2dn1Kqrq6vmeRvJuarjXNUrazbnqs5wcgHLYpDPVR8+MjOzjIuCmZllXBTMzCyzU59oNjMbymuvvUZPTw+bN2+uaf5x48axcuXKOqcavjy52tramDRpEmPGjMm9XBcFMxvRenp62HPPPZk8eTKSqp5/06ZN7Lnnng1INjxD5YoI1q1bR09PD1OmTMm9XB8+MrMRbfPmzey99941FYSdmST23nvvqveQXBTMbMRrtYLQp5af20XBzMwyPqdgZi1lwfTpdV3eX3V313V5RfOeglkDrO/urvuHj1kzuCiYmTXY6tWrmTZtGhdccAEzZszgzDPP5M4772T27NlMnTqV+++/n5deeokPf/jDHHPMMRx11FHcfvvt2bzvfOc7mTlzJjNnzuTXv/41AEuWLGHOnDmcfvrpTJs2jTPPPJOow5M0ffjIzKwJVq1axa233so111zDMcccw4IFC7jnnntYvHgxX/ziF+no6ODEE0/kuuuuY8OGDcyaNYuTTz6ZfffdlzvuuIO2tjaefPJJPvShD7Fs2TIAHnroIbq7u9lvv/2YPXs29957L8cff/ywcjasKEi6DngfsCYiZqTD9gJuBiYDq4G/iIgXlJwi/xrwXuAPwLkR8WCjspmZNduUKVM4/PDDAZg+fTonnXQSkjj88MNZvXo1PT09LF68mC9/+ctAcintM888w3777cfFF1/Mww8/zOjRo3niiSeyZc6aNYtJkyYBcOSRR7J69eryFgXgn4H5wA0Vwy4H7oqIKyVdnr7/FPCnwNT061jg/6bfzcxGhN122y17PWrUqOz9qFGj2LJlC6NHj2bRokUceuihr5vviiuuoL29nUceeYRt27bR1tY24DJHjx7Nli1bhp2zYecUIuJXwPp+g08Frk9fXw+cVjH8hrRX1/uA8ZImNiqbmVnZvPvd7+Yb3/hGdl7goYceAuDFF19k4sSJjBo1ihtvvJGtW7c2NEezzym0R8TzABHxvKR90+H7A89WTNeTDnu+/wIkzQPmAbS3t3P33XfXFKS3t7fmeRvJuapT1lyj9t2XtgsvLGW2srZZo3KNGzeOTZs2Ze/ff999Vc2/detWRo8ePej4ymUPpre3l23btmXTvvbaa7z88sts2rQpG3fZZZdx+eWXM2PGDCKCAw88kFtvvZWzzz6bs846i4ULF3LCCSewxx57sGnTJrZt28aWLVuyZb766qts3rx5uzybN2+url0He9BCPb5Izh08WvF+Q7/xL6Tf/w04vmL4XUDnUMv3Q3aax7mqs2j+/Lipo6PoGAMqa5s1Ktdjjz02rPk3btxYpyT1lTfXQD8/JXrIzu/7Dgul39ekw3uAAyqmmwQ81+RsZmYtr9lFYTFwTvr6HOD2iuFnK3Ec8GKkh5nMzKx5GnlJ6veAOcA+knqAzwNXArdIOh94BvhgOvmPSS5HXUVySep5jcplZq0nIlqyU7yo4Wa2hhWFiPjQIKNOGmDaAC5qVBYza11tbW2sW7eu5brPjvR5CpWXsObhO5rNbESbNGkSPT09rF27tqb5N2/eXPUHazPkydX35LVquCiY2Yg2ZsyYqp481t/dd9/NUUcdVcdE9dGoXO4Qz8zMMi4KZmaWcVEwM7OMi4KZmWVcFMzMLOOiYGZmGRcFMzPLuCiYmVnGRcHMzDIuCmZmlnFRMDOzjIuCmZllXBTMzCzjomBmZhkXBTMzy7gomJlZxkXBzMwyLgpmZpZxUTAzs4yLgpmZZVwUzMws46JgZmYZFwUzM8u4KJiZWcZFwczMMi4KZmaWcVEwM7OMi4KZmWVcFMzMLFNIUZD0N5K6JT0q6XuS2iRNkbRU0pOSbpa0axHZzMxaWdOLgqT9gUuAoyNiBjAaOAP4EnB1REwFXgDOb3Y2M7NWV9Tho12AN0jaBdgdeB44EbgtHX89cFpB2czMWpYiovkrlS4FvgC8DPwcuBS4LyIOSccfAPwk3ZPoP+88YB5Ae3t758KFC2vK0Nvby9ixY2v7ARrIuapT1lwb1q5l25o17DV9etFRtlPWNnOu6gwn19y5c5dHxNEDjoyIpn4BbwJ+AUwAxgA/BM4CVlVMcwCwYqhldXZ2Rq26urpqnreRnKs6Zc21aP78uKmjo+gYAyprmzlXdYaTC1gWg3yuFnH46GTg6YhYGxGvAd8H3gGMTw8nAUwCnisgm5lZSyuiKDwDHCdpd0kCTgIeA7qA09NpzgFuLyCbmVlLa3pRiIilJCeUHwRWpBmuAT4FfELSKmBv4NpmZzMza3W7DD1J/UXE54HP9xv8FDCrgDhmZpbyHc1mZpZxUTAzs4yLgpmZZVwUzMws46JgZmYZFwUzM8u4KJiZWcZFwczMMi4KZmaWcVEwM7OMi4KZmWVcFMzMLOOiYGZmGRcFMzPLuCiYmVnGRcHMzDItWxTWd3ezYPr0omOYmZVKyxYFMzPbnouCmZllXBTMzCzjomBmZhkXBTMzy+QqCpJmNDqImZkVL++ewrck3S/pQknjG5rIzMwKk6soRMTxwJnAAcAySQsk/UlDk5mZWdPlPqcQEU8CnwU+BbwL+Lqk30r680aFMzOz5sp7TuFtkq4GVgInAu+PiMPS11c3MJ+ZmTXRLjmnmw98B/hMRLzcNzAinpP02YYkMzOzpstbFN4LvBwRWwEkjQLaIuIPEXFjw9KZmVlT5T2ncCfwhor3u6fDzMxsBMlbFNoiorfvTfp698ZEMjOzouQtCi9Jmtn3RlIn8PIOpt8hSeMl3ZZevbRS0tsl7SXpDklPpt/fVOvyzcysNnmLwmXArZKWSFoC3AxcPIz1fg34aURMA44guarpcuCuiJgK3JW+NzOzJsp1ojkiHpA0DTgUEPDbiHitlhVKeiNwAnBuuuxXgVclnQrMSSe7Hrib5J4IMzNrEkVEvgmldwCTqSgkEXFD1SuUjgSuAR4j2UtYDlwK/EdEjK+Y7oWI2O4QkqR5wDyA9vb2zoULF1YbAYANa9eybc0a9irZ09d6e3sZO3Zs0TG241zVKevfF5S3zZyrOsPJNXfu3OURcfSAIyNiyC/gRuDXwDeBb6RfX88z7wDLOhrYAhybvv8a8HfAhn7TvTDUsjo7O6NWi+bPj5s6Omqev1G6urqKjjAg56pOWf++IsrbZs5VneHkApbFIJ+ree9TOBroSBc2XD1AT0QsTd/fRnL+4PeSJkbE85ImAmvqsC4zM6tC3hPNjwJvrscKI+L/Ac9KOjQddBLJoaTFwDnpsHOA2+uxPjMzyy/vnsI+wGOS7gde6RsYEafUuN6PAzdJ2hV4CjiPpEDdIul84BnggzUu28zMapS3KFxRz5VGxMMkh6T6O6me6zEzs+rkvST1l5IOAqZGxJ2SdgdGNzaamZk1W96usz9CckL42+mg/YEfNiqUmZkVI++J5ouA2cBGyB64s2+jQpmZWTHyFoVXIrnzGABJuwD1uDzVzMxKJG9R+KWkzwBvSJ/NfCvwr42LZWZmRchbFC4H1gIrgI8CPyZ5XrOZmY0gea8+2kbyOM7vNDaOmZkVKVdRkPQ0A5xDiIi31D2RmZkVppq+j/q0kdxtvFf945iZWZFynVOIiHUVX/8REV8FTmxwNjMza7K8h49mVrwdRbLnsGdDElkpre/uhjlzio5hZg2W9/DRVypebwFWA39R9zRmZlaovFcfzW10EDMzK17ew0ef2NH4iLiqPnHMzKxI1Vx9dAzJg3AA3g/8Cni2EaHMzKwY1TxkZ2ZEbAKQdAVwa0Rc0KhgZmbWfHm7uTgQeLXi/avA5LqnMTOzQuXdU7gRuF/SD0jubP4AcEPDUpmZWSHy3rz2BZLnKL8AbADOi4gvNjKYmbWOBdOnFx3BUnkPHwHsDmyMiK8BPZKmNCiTmZkVJO/jOD8PfAr4dDpoDPAvjQplZmbFyLun8AHgFOAlgIh4DndzYWY24uQtCq9GRJB2ny1pj8ZFMjOzouQtCrdI+jYwXtJHgDvxA3fMzEacvH0ffTl9NvNG4FDgcxFxR0OTmZlZ0w1ZFCSNBn4WEScDLgRmZiPYkIePImIr8AdJ45qQx8zMCpT3jubNwApJd5BegQQQEZc0JJWZmRUib1H4t/TLzMxGsB0WBUkHRsQzEXF9swKZmVlxhjqn8MO+F5IWNTiLmZkVbKiioIrXb6nniiWNlvSQpB+l76dIWirpSUk3S9q1nuszM7OhDVUUYpDX9XApsLLi/ZeAqyNiKklvrOfXeX1mZjaEoYrCEZI2StoEvC19vVHSJkkba12ppEnAnwHfTd8LOBG4LZ3keuC0WpdvZma1UdKlUZNXKt0G/D1Jp3qfBM4F7ouIQ9LxBwA/iYgZA8w7D5gH0N7e3rlw4cKaMmxYu5Zta9awV8n6ce/t7WXs2LFFx9jOhrVrGT9hQtExtlPm9irj3xeUs83Wd3ez60EHlS4XlLO9YHi55s6duzwijh5wZEQ09Qt4H/DN9PUc4EfABGBVxTQHACuGWlZnZ2fUatH8+XFTR0fN8zdKV1dX0REGtGj+/KIjDKjM7VXGv6+IcrbZTR0dpcwVUc72ihheLmBZDPK5mvc+hXqaDZwi6b1AG/BG4Kskne3tEhFbgEnAcwVkMzNradU8ea0uIuLTETEpIiYDZwC/iIgzgS7g9HSyc4Dbm53NzKzVNb0o7MCngE9IWgXsDVxbcB4zs5ZTxOGjTETcDdydvn4KmFVkHjOzVlemPQUzMyuYi4KZmWVcFMzMLOOiYGZmGRcFMzPLuCiYmVnGRcHMzDIuCmZmlnFRsJ3a+u7uoiOYjSguCmZmlnFRMDOzjIuCmZllXBTMzCzjomBmZhkXBTMzy7gomJlZxkXBzMwyLgpmZpZxUTAzs4yLgpmZZVwUzMws46JgZmYZFwUzM8u4KJiZWcZFwczMMi4KZjaoBdOns2D69KJjWBO5KJiZWcZFwczMMi4KZmaWcVGwllPWY+TNyFXWn93Kw0XBzMwyTS8Kkg6Q1CVppaRuSZemw/eSdIekJ9Pvb2p2NmttZd2KLmsuG5mK2FPYAvz3iDgMOA64SFIHcDlwV0RMBe5K35uZWRM1vShExPMR8WD6ehOwEtgfOBW4Pp3seuC0Zmcz25nsaA+icpz3NKwahZ5TkDQZOApYCrRHxPOQFA5g3+KSmZm1JkVEMSuWxgK/BL4QEd+XtCEixleMfyEitjuvIGkeMA+gvb29c+HChTWtf8PatWxbs4a9SrYV1dvby9ixY4uOsZ0Na9cyfsKEomNsp5Zc67u7B/y9Dza81lzV/n1Vm2tHeSvH9X+960EH5f4bW9/dDdDw/5NqczVTWf8nh5Nr7ty5yyPi6AFHRkTTv4AxwM+AT1QMexyYmL6eCDw+1HI6OzujVovmz4+bOjpqnr9Rurq6io4woEXz5xcdYUC15Brs917Pv4da/r6qzbWj5VeO6/+6mr+xmzo6mvJ/Um2uZhqJuYBlMcjnahFXHwm4FlgZEVdVjFoMnJO+Pge4vdnZzFqNzzdYf7sUsM7ZwFnACkkPp8M+A1wJ3CLpfOAZ4IMFZDMza2lNLwoRcQ+gQUaf1MwsZkVbMH06f5Uet6/ntGa18h3NZmaWcVEwK5kij/P7HIO5KJiZWcZFwUqjlZ7yVeafs9psrfR7awUuCmZmlnFRsJ3GSN0a3dGW9kj9ma28XBTMzCzjomCl5itxysl7NyOXi4KZmWVcFMyGMNRzCxqxZTyc5XpL3YbDRcHMzDIuCtYQeZ8KVs/llmmZjV5fPe8laMS5gYHm7RvmPZlyc1EwM7OMi0LJrHcvmHU13K3gHW3xlkWzzj307W1U03ZlaysbmouCmZllXBRsRCrLlTuN3lKuPE7fyHXlWXY9M3gPY3CN/l27KJiZWcZFwawG1WypDbY13+jzFWW816GWPRv32tpcLgpmZpZp+jOazYrQt+VY6zOO6zX/cA21nLLtGVRjfXc3zJmzw2n8nOrG856CmZllXBSsKcrY22ktx56HOidg9dO/rWu5S96/o+q5KJiZWcZFYSe3s28J1bsfoFqvPKn3MspsfXd3abIOdEVWWbK1KhcFMzPLuCi0qCK2xoZzZUzeO2qLVoYMzdTsO50HWmfRd3KPNC4KZmaW8X0KI9Rwr6tv9Prq1Vd/24UXDnt5O4OR/vNVy/crNI73FMzMLOOi0EBl27qr5lhsPY7/V9O3T7PaqtF9+lh91fv52DvLuakiuSiYmVnGRaEOmrmV24z+/nfGZxab5VXLnmwrKVVRkPQeSY9LWiXp8qLzmJm1mtJcfSRpNPCPwJ8APcADkhZHxGPFJktUc3VNnp4sq7lyov/0fe9ruV57uFtHlVnytMlwzk0M9+oSb/W1lmbevzDQekbK1VBl2lOYBayKiKci4lVgIXBqwZnMzFqKIqLoDABIOh14T0RckL4/Czg2Ii7uN908YF769lDg8RpXuQ/wnzXO20jOVR3nql5ZszlXdYaT66CImDDQiNIcPgI0wLDtKlZEXANcM+yVScsi4ujhLqfenKs6zlW9smZzruo0KleZDh/1AAdUvJ8EPFdQFjOzllSmovAAMFXSFEm7AmcAiwvOZGbWUkpz+Cgitki6GPgZMBq4LiIaeTp/2IegGsS5quNc1StrNueqTkNyleZEs5mZFa9Mh4/MzKxgLgpmZpYZ0UVB0nWS1kh6dJDxkvT1tFuN30iaWZJccyS9KOnh9OtzTcp1gKQuSSsldUu6dIBpmt5mOXM1vc0ktUm6X9Ijaa7/PcA0u0m6OW2vpZImlyTXuZLWVrTXBY3OVbHu0ZIekvSjAcY1vb1y5iqyvVZLWpGud9kA4+v7PxkRI/YLOAGYCTw6yPj3Aj8huUfiOGBpSXLNAX5UQHtNBGamr/cEngA6im6znLma3mZpG4xNX48BlgLH9ZvmQuBb6eszgJtLkutcYH6z/8bSdX8CWDDQ76uI9sqZq8j2Wg3ss4Pxdf2fHNF7ChHxK2D9DiY5FbghEvcB4yVNLEGuQkTE8xHxYPp6E7AS2L/fZE1vs5y5mi5tg9707Zj0q/+VG6cC16evbwNOkjTQjZrNzlUISZOAPwO+O8gkTW+vnLnKrK7/kyO6KOSwP/BsxfseSvBhk3p7uvv/E0lN79kt3W0/imQrs1KhbbaDXFBAm6WHHB4G1gB3RMSg7RURW4AXgb1LkAvgv6aHG26TdMAA4xvhq8D/BLYNMr6Q9sqRC4ppL0gK+s8lLVfSzU9/df2fbPWikKtrjQI8SNI3yRHAN4AfNnPlksYCi4DLImJj/9EDzNKUNhsiVyFtFhFbI+JIkjvwZ0ma0W+SQtorR65/BSZHxNuAO/nj1nnDSHofsCYilu9osgGGNbS9cuZqentVmB0RM4E/BS6SdEK/8XVts1YvCqXsWiMiNvbt/kfEj4ExkvZpxroljSH54L0pIr4/wCSFtNlQuYpss3SdG4C7gff0G5W1l6RdgHE08dDhYLkiYl1EvJK+/Q7Q2YQ4s4FTJK0m6QX5REn/0m+aItpryFwFtVffup9Lv68BfkDSo3Sluv5PtnpRWAycnZ69Pw54MSKeLzqUpDf3HUeVNIvk97SuCesVcC2wMiKuGmSyprdZnlxFtJmkCZLGp6/fAJwM/LbfZIuBc9LXpwO/iPTsYJG5+h1zPoXkPE1DRcSnI2JSREwmOYn8i4j4636TNb298uQqor3S9e4hac++18B/AfpftVjX/8nSdHPRCJK+R3JVyj6SeoDPk5x0IyK+BfyY5Mz9KuAPwHklyXU68N8kbQFeBs5o9D9GajZwFrAiPR4N8BngwIpsRbRZnlxFtNlE4HolD4gaBdwSET+S9LfAsohYTFLMbpS0imSL94wGZ8qb6xJJpwBb0lznNiHXgErQXnlyFdVe7cAP0u2dXYAFEfFTSR+DxvxPupsLMzPLtPrhIzMzq+CiYGZmGRcFMzPLuCiYmVnGRcHMzDIuClZKkkLSVyref1LSFXVa9j9LOr0ey0qXN07SDZJ+l37dIGlcxfh/UNJb6T/0m6+y583fSvqbYWT4mKSzh/NzmIGLgpXXK8CfN/Ou5DzSa//7uxZ4KiIOjoiDgad5fcdqHyXp5fV/DDDvzWl3FLOB/1VrnzoR8a2IuKGWec0quShYWW0heQbtdlvP/bf0JfWm3+dI+qWkWyQ9IelKSWcqebbACkkHVyzmZElL0unel84/Ot2qfyDt+OyjFcvtkrQAWNEvyyEkXR78XcXgvwWOlnSwpMXAHsBSSX852A8bEetIbj6amC53gqRFaZYHJM2WNEpJ3/rjK9a/SlK7pCskfTIddrCknyrpQG2JpGnpz/ZUetfreEnblPahk05ziKR36Y/PC3io705aay0j+o5m2+n9I/AbSf+ninmOAA4juev0KeC7ETFLyYN5Pg5clk43GXgXcDDQlX64n03SRcAxknYD7pX083T6WcCMiHi63/o6gIcjYmvfgIjYmt55PT0iTpHUm+4NDErSgUAb8Jt00NeAqyPinnTczyLiMEm3Ax8A/knSscDqiPi9Xt+79DXAxyLiyXSab0bEiZKeSPNOAZYD75S0FJgUEaskXQ1cFBH3Kul8cPOOMtvI5KJgpRURGyXdAFxC0nVFHg/09fsi6XdA34f6CmBuxXS3RMQ24ElJTwHTSPqVeVvFXsg4YCrwKnD/AAUBkh4qB+oWYLDh/f2lpLnAocBHIqLvg/hkoKPiw/6N6Zb7zcDngH8ifQjN61aafJi/A7i1Yt7d0u9LSB7wNAX4e+AjwC+BB9Lx9wJXSboJ+H5E9OTIbyOMDx9Z2X0VOJ/kEEyfLaR/u0o++XatGPdKxettFe+38fqNoP4f2EHyQf7xiDgy/ZoSEX1F5aVB8nUDR0nK/pfS10eQr9O0myNiOvBO4CuS3pwOHwW8vSLL/ukDhv4dOETSBOA0oH+PsaOADRXzHRkRh6XjlqTrmUXSX854kj64fgUQEVcCFwBvAO6TNC1HfhthXBSs1CJiPXALSWHos5o/dl18KmlnglX6YHqM/mDgLcDjwM9IOtUbAyDprUp6ptxRvlXAQ8BnKwZ/FngwHZdLRPw7cCPQ9/zpnwMX942XdGQ6XZB0n3wVSa+x6/otZyPwtKQPpvNJ0hHp6KUkexHb0j2Sh0lOgi9Jpz04IlZExJeAZSR7T9ZiXBRsZ/AVoPIqpO8A75J0P3Asg2/F78jjJIdOfkJy/H0zyRVDjwEPSnoU+Db5DrGeD7w1Pen7O+CtvL6I5fUl4Lz0MNElJCerfyPpMeBjFdPdDPw1/Q4dVTgTOF/SIyR7MqcCpM8DeBa4L51uCckzr/tOnl8m6dF0vpdJ2sZajHtJNTOzjPcUzMws46JgZmYZFwUzM8u4KJiZWcZFwczMMi4KZmaWcVEwM7PM/wcSUkvRXJ+g4AAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "Movie_Mean_Count_Data[\"mean\"].plot(bins = 250, kind = \"hist\", color = \"brown\")\n",
    "plt.grid()\n",
    "plt.xlabel(\"Number Of Reviews\")\n",
    "plt.legend()\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYcAAAEGCAYAAACO8lkDAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAdT0lEQVR4nO3de5RdZZnn8e8vFwmQdEII1gSLtrikxYTFLTGi0G2VsVugu406Ubl0CMpQThtBR2ZGUKcb22FJDy0ydAKKAhIFywgIadobhkQaFhASQJIiIhEilmFITIhQYIAkz/yx3wqH2lWnTlXOqXOp32ets87e797vPs9TqZyn9u3digjMzMwKjap2AGZmVntcHMzMLMfFwczMclwczMwsx8XBzMxyxlQ7gL0xZcqUaGlpGVLfF198kf3337+8AVWR86l9jZaT86ltxfJZs2bN7yPioGL967o4tLS0sHr16iH1XblyJa2treUNqIqcT+1rtJycT20rlo+k3wzU34eVzMwsx8XBzMxyXBzMzCynrs85mJkN5NVXX6Wrq4sdO3YUXW/ixImsX79+mKKqvIkTJ/LUU0/R3NzM2LFjB93fxcHMGlpXVxcTJkygpaUFSf2u98ILLzBhwoRhjKyynn/+eV555RW6uro49NBDB93fh5XMrKHt2LGDAw88sGhhaESSOPDAAwfcY+qPi4OZNbyRVhh67E3eLg5mZpbjcw5mNqLcNGNGWbd3RmdnWbc3WFdccQXt7e3st99+Zd3uiN1z2NbZWfZfEjOz4XbFFVfw0ksvlX27I7Y4mJkNlyVLlnD00UdzzDHHMH/+fH7zm98wZ84cjj76aObMmcPTTz8NwNlnn83NN9+8p9/48eOB14bCmDdvHkceeSRnnnkmEcGVV17Jpk2baGtro62trawx+7CSmVkFdXZ2cskll3DvvfcyZcoUtm3bxoIFCzjrrLNYsGAB1113Heeffz633XZb0e08/PDDdHZ2cvDBB3PiiSdy7733cv7553P55ZezYsUKpkyZUta4vedgZlZBd911F/Pmzdvz5T158mTuu+8+zjjjDADmz5/PPffcM+B2Zs+eTXNzM6NGjeLYY49l48aNlQzbxcHMrJIiYsBLSnuWjxkzht27d+/p98orr+xZZ5999tkzPXr0aHbu3FmBaF/j4mBmVkFz5sxh6dKlbN26FYBt27bxzne+k46ODgBuvPFGTjrpJCB7DMGaNWsAuP3223n11VcH3P6ECRN44YUXyh63zzmY2YjS36WnlRo+Y8aMGXz+85/nXe96F6NHj+a4447jyiuv5GMf+xiXXXYZBx10ENdffz0A5557LnPnzmX27NnMmTOnpIcPtbe3c8oppzB16lRWrFhRtrhdHMzMKmzBggUsWLDgdW133XVXbr2mpibuv//+PfNf/vKXAWhtbX3dg3sWLVq0Z/q8887jvPPOK3PEPqxkZmZ9cHEwM7McFwcza3gRUe0QqmJv8q5YcZA0TtIqSb+Q1Cnpi6n9UEkPSHpC0vckvSG175PmN6TlLZWKzcxGjnHjxrF169YRVyAigq1btzJu3Lgh9a/kCemXgXdHRLekscA9kn4EfAb4akR0SPoacA5wdXp/LiKOkHQa8M/ARyoYn5mNAM3NzXR1dbFly5ai6+3YsWPIX6S1aMeOHUyaNInm5uYh9a9YcYisTHen2bHpFcC7gTNS+w3AxWTFYW6aBrgZWCRJMdLKvZmV1dixY0t6EtrKlSs57rjjhiGi4bG3+aiS372SRgNrgCOAxcBlwP0RcURafgjwo4g4StI64OSI6ErLfg28PSJ+32ub7UA7QFNT08yeG0kGa/uWLezevJnJDTIya3d3955BuhpBo+UDjZeT86ltxfJpa2tbExGzim4gIir+AiYBK4A/BzYUtB8CrE3TnUBzwbJfAwcW2+7MmTNjqG5ZtChunD59yP1rzYoVK6odQlk1Wj4RjZeT86ltxfIBVscA39vDcrVSRGwHVgInAJMk9RzOagY2pemuVCxIyycC24YjPjMze71KXq10kKRJaXpf4D3AerI9iHlptQXA7Wl6WZonLb8rVTgzMxtmlbxaaSpwQzrvMApYGhF3SHoM6JD0v4GHgWvT+tcC35a0gWyP4bQKxmZmZkVU8mqlR4HcqfKIeBKY3Uf7DuBDlYrHzMxK5zukzcwsx8XBzMxyXBzMzCzHxcHMzHJcHMzMLMfFwczMclwczMwsx8XBzMxyXBzMzCzHxcHMzHJcHMzMLMfFwczMclwczMwsx8XBzMxyXBzMzCzHxcHMzHJcHMzMLMfFwczMclwczMwsx8XBzMxyXBzMzCzHxcHMzHJcHMzMLKdixUHSIZJWSFovqVPSp1L7xZJ+J+mR9Dq1oM9FkjZIelzSeysVm5mZFTemgtveCVwQEQ9JmgCskXRnWvbViPiXwpUlTQdOA2YABwM/k/RnEbGrgjGamVkfKrbnEBHPRMRDafoFYD3wpiJd5gIdEfFyRDwFbABmVyo+MzPrnyKi8h8itQB3A0cBnwHOBp4HVpPtXTwnaRFwf0R8J/W5FvhRRNzca1vtQDtAU1PTzI6OjiHFtH3LFnZv3szkGTOG1L/WdHd3M378+GqHUTaNlg80Xk7Op7YVy6etrW1NRMwquoGIqOgLGA+sAT6Y5puA0WR7LZcA16X2xcDfFfS7FvjPxbY9c+bMGKpbFi2KG6dPH3L/WrNixYpqh1BWjZZPROPl5HxqW7F8gNUxwHd3Ra9WkjQWuAW4MSJuTcXo2YjYFRG7gW/w2qGjLuCQgu7NwKZKxmdmZn2r5NVKIvvrf31EXF7QPrVgtQ8A69L0MuA0SftIOhSYBqyqVHxmZta/Sl6tdCIwH1gr6ZHU9jngdEnHAgFsBD4OEBGdkpYCj5Fd6bQwfKWSmVlVVKw4RMQ9gPpY9MMifS4hOw9hZmZV5Dukzcwsx8XBzMxyXBzMzCzHxcHMzHJcHMzMLMfFwczMclwczMwsx8XBzMxyXBzMzCzHxcHMzHJcHMzMLMfFwczMclwczMwsx8XBzMxyXBzMzCzHxcHMzHJcHMzMLMfFwczMclwczMwsx8XBzMxyXBzMzCzHxcHMzHJKKg6Sjqp0IGZmVjtK3XP4mqRVkj4haVIpHSQdImmFpPWSOiV9KrVPlnSnpCfS+wGpXZKulLRB0qOSjh9iTmZmtpdKKg4RcRJwJnAIsFrSTZL+coBuO4ELIuKtwAnAQknTgQuB5RExDVie5gFOAaalVztw9WCTMTOz8ij5nENEPAF8Afgs8C7gSkm/lPTBftZ/JiIeStMvAOuBNwFzgRvSajcA70/Tc4ElkbkfmCRp6hByMjOzvaSIGHgl6Wjgo8BfA3cC10bEQ5IOBu6LiDcP0L8FuBs4Cng6IiYVLHsuIg6QdAdwaUTck9qXA5+NiNW9ttVOtmdBU1PTzI6OjlJzfZ3tW7awe/NmJs+YMaT+taa7u5vx48dXO4yyabR8oPFycj61rVg+bW1tayJiVtENRMSAL7Iv9vnAvn0smz9A3/HAGuCDaX57r+XPpfd/B04qaF8OzCy27ZkzZ8ZQ3bJoUdw4ffqQ+9eaFStWVDuEsmq0fCIaLyfnU9uK5QOsjgG+98eUWIROBf4YEbsAJI0CxkXESxHx7f46SRoL3ALcGBG3puZnJU2NiGfSYaPNqb2L7JxGj2ZgU4nxmZlZGZV6zuFnwL4F8/ultn5JEnAtsD4iLi9YtAxYkKYXALcXtJ+Vrlo6AfhDRDxTYnxmZlZGpe45jIuI7p6ZiOiWtN8AfU4kOxS1VtIjqe1zwKXAUknnAE8DH0rLfki2h7IBeInsHIeZmVVBqcXhRUnHR7r6SNJM4I/FOkR2Yln9LJ7Tx/oBLCwxHjMzq6BSi8Onge9L6jkHMBX4SGVCMjOzaiupOETEg5KOBN5Ctjfwy4h4taKRmZlZ1ZS65wDwNqAl9TlOEhGxpCJRmZlZVZVUHCR9GzgceATYlZoDcHEwM2tApe45zAKmp5PGZmbW4Eq9z2Ed8J8qGYiZmdWOUvccpgCPSVoFvNzTGBHvq0hUZmZWVaUWh4srGYSZmdWWUi9l/bmkNwPTIuJn6e7o0ZUNzczMqqXUx4SeC9wMfD01vQm4rVJBmZlZdZV6Qnoh2VhJz8OeB/+8sVJBmZlZdZVaHF6OiFd6ZiSNIbvPwczMGlCpxeHnkj4H7JueHf194N8qF5aZmVVTqcXhQmALsBb4ONnw2l+oVFBmZlZdpV6ttBv4RnqZmVmDK3Vspafo4xxDRBxW9ojMzKzqBjO2Uo9xZE9vm1z+cMzMrBaUdM4hIrYWvH4XEVcA765wbGZmViWlHlY6vmB2FNmexISKRDTMbpoxA4AzOjurHImZWe0o9bDSVwqmdwIbgQ+XPRozM6sJpV6t1FbpQMzMrHaUeljpM8WWR8Tl5QnHzMxqwWCuVnobsCzN/y1wN/DbSgRlZmbVVeod0lOA4yPigoi4AJgJNEfEFyPii311kHSdpM2S1hW0XSzpd5IeSa9TC5ZdJGmDpMclvXdvkjIzs71TanH4U+CVgvlXgJYB+nwLOLmP9q9GxLHp9UMASdOB04AZqc9Vkvy8CDOzKin1sNK3gVWSfkB2p/QHgCXFOkTE3ZJaStz+XKAjIl4GnpK0AZgN3FdifzMzKyNFlDbydrrX4c/T7N0R8XAJfVqAOyLiqDR/MXA22XMhVgMXRMRzkhYB90fEd9J61wI/ioib+9hmO9AO0NTUNLOjo6Ok+HvbvmULuzdv3jM/Od3vUK+6u7sZP358tcMom0bLBxovJ+dT24rl09bWtiYiZvW5MCl1zwFgP+D5iLhe0kGSDo2IpwbRH+Bq4Etkex9fIrt/4mOA+li3z6oVEdcA1wDMmjUrWltbBxlC5tbFi9lx1VV75lvr/Ca4lStXMtSfRS1qtHyg8XJyPrVtb/Mp9TGh/wh8FrgoNY0FvjPYD4uIZyNiV8Eor7PToi7gkIJVm4FNg92+mZmVR6knpD8AvA94ESAiNjGE4TMkTe21zZ4rmZYBp0naR9KhwDRg1WC3b2Zm5VHqYaVXIiIkBYCk/QfqIOm7QCswRVIX8I9Aq6RjyQ4ZbSR7cBAR0SlpKfAY2fAcCyNi1yBzMTOzMim1OCyV9HVgkqRzyc4TFH3wT0Sc3kfztUXWvwS4pMR4zMysgkodW+lf0rOjnwfeAvxDRNxZ0cjMzKxqBiwO6Wa0n0TEewAXBDOzEWDAE9Lp2P9LkiYOQzxmZlYDSj3nsANYK+lO0hVLABFxfkWiMjOzqiq1OPx7epmZ2QhQtDhI+tOIeDoibhiugMzMrPoGOudwW8+EpFsqHIuZmdWIgYpD4ZhHh1UyEDMzqx0DFYfoZ9rMzBrYQCekj5H0PNkexL5pmjQfEfEnFY3OzMyqomhxiAg/jc3MbAQqdVRWMzMbQVwczMwsx8XBzMxyXBzMzCzHxcHMzHJKHVup4d00Y8ae6TM6O6sYiZlZ9XnPwczMclwczMwsx8XBzMxyXBzMzCzHxcHMzHJcHMzMLKdixUHSdZI2S1pX0DZZ0p2SnkjvB6R2SbpS0gZJj0o6vlJxmZnZwCq55/At4ORebRcCyyNiGrA8zQOcAkxLr3bg6grGZWZmA6hYcYiIu4FtvZrnAj3Po74BeH9B+5LI3A9MkjS1UrGZmVlxiqjcA94ktQB3RMRRaX57REwqWP5cRBwg6Q7g0oi4J7UvBz4bEav72GY72d4FTU1NMzs6OoYU2/YtW9i9eXOfyyYX3C1dL7q7uxk/fny1wyibRssHGi8n51PbiuXT1ta2JiJmFetfK8NnqI+2PqtWRFwDXAMwa9asaG1tHdIH3rp4MTuuuqrPZa11OHzGypUrGerPohY1Wj7QeDk5n9q2t/kM99VKz/YcLkrvPX+6dwGHFKzXDGwa5tjMzCwZ7uKwDFiQphcAtxe0n5WuWjoB+ENEPDPMsZmZWVKxw0qSvgu0AlMkdQH/CFwKLJV0DvA08KG0+g+BU4ENwEvARysVl5mZDaxixSEiTu9n0Zw+1g1gYaViMTOzwfEd0mZmluPiYGZmOS4OZmaW4+JgZmY5Lg5mZpbj4mBmZjkuDmZmluPi0IebZszgpjocfM/MrFxcHMzMLMfFwczMclwczMwsx8XBzMxyXBzMzCzHxcHMzHJcHMzMLMfFwczMclwczMwsx8XBzMxyXByK8DAaZjZSuTiYmVmOi4OZmeW4OJiZWY6Lg5mZ5YypxodK2gi8AOwCdkbELEmTge8BLcBG4MMR8Vw14utPz8npMzo7qxyJmVllVaU4JG0R8fuC+QuB5RFxqaQL0/xnqxPa6/mKJTMbaWrpsNJc4IY0fQPw/irGYmY2olWrOATwU0lrJLWntqaIeAYgvb+xSrGZmY14iojh/1Dp4IjYJOmNwJ3AecCyiJhUsM5zEXFAH33bgXaApqammR0dHUOKYfuWLezevHlIfSfX4GGm7u5uxo8fX+0wyqbR8oHGy8n51LZi+bS1ta2JiFnF+lflnENEbErvmyX9AJgNPCtpakQ8I2kq0Oc3d0RcA1wDMGvWrGhtbR1SDLcuXsyOq64aUt/WGjwhvXLlSob6s6hFjZYPNF5Ozqe27W0+w35YSdL+kib0TAN/BawDlgEL0moLgNuHO7ZSeVgNM2t01dhzaAJ+IKnn82+KiB9LehBYKukc4GngQ1WIzczMqEJxiIgngWP6aN8KzBnueMqp996E74cws3pVS5eyjjg+PGVmtcrFwczMclwczMwsx8XBzMxyXBzMzCynmgPvNQyfVDazRuM9BzMzy3FxMDOzHBeHCup9H4PvazCzeuHiYGZmOS4OZmaW4+JQw3wYysyqxZeyDgN/wZtZvXFx2Avl/tLv2Z5HczWzavNhJTMzy/GeQw0Y7B5IufYwvKdiZv1xcagCn4Mws1rn4lAHBiomN82YwbhPfAJq6OHo3isxq28uDjWo1D2Loa7X3xe2v9DNrIeLwwjkw1pmNhBfrWRlUa0b9nyjoFlleM/BBlT45etDTmYjg4tDAxmOv6B7n5co5WR5X1xkzGqbi4P5sEyF9fx8D168uMqRmJWu5oqDpJOB/wuMBr4ZEZdWOaQRq1jR6G9Zua60GveJT3DTwoW5PZSB9lj6u+Kqvyu2KnmFlouu1bOaKg6SRgOLgb8EuoAHJS2LiMeqG5lVS+8v2Ep94ZZaPHy578jgf+caKw7AbGBDRDwJIKkDmAu4OAyjevyLd7BFZLDLS9n+QHs12zo7X7c3VGos/W2/v88b6D6WUuMd7PZL+azey0v98h3q+r01wpf9cBUuRURFP2AwJM0DTo6I/5Lm5wNvj4hPFqzTDrSn2bcAjw/x46YAv9+LcGuN86l9jZaT86ltxfJ5c0QcVKxzre05qI+211WviLgGuGavP0haHRGz9nY7tcL51L5Gy8n51La9zafWboLrAg4pmG8GNlUpFjOzEavWisODwDRJh0p6A3AasKzKMZmZjTg1dVgpInZK+iTwE7JLWa+LiEqdddnrQ1M1xvnUvkbLyfnUtr3Kp6ZOSJuZWW2otcNKZmZWA1wczMwsZ8QVB0knS3pc0gZJF1Y7nlJJuk7SZknrCtomS7pT0hPp/YDULklXphwflXR89SLvm6RDJK2QtF5Sp6RPpfa6zEnSOEmrJP0i5fPF1H6opAdSPt9LF1ogaZ80vyEtb6lm/P2RNFrSw5LuSPN1m4+kjZLWSnpE0urUVpe/bwCSJkm6WdIv0/+jd5QznxFVHAqG5zgFmA6cLml6daMq2beAk3u1XQgsj4hpwPI0D1l+09KrHbh6mGIcjJ3ABRHxVuAEYGH6t6jXnF4G3h0RxwDHAidLOgH4Z+CrKZ/ngHPS+ucAz0XEEcBX03q16FPA+oL5es+nLSKOLbj+v15/3yAbg+7HEXEkcAzZv1P58omIEfMC3gH8pGD+IuCiasc1iPhbgHUF848DU9P0VODxNP114PS+1qvVF3A72ZhadZ8TsB/wEPB2sjtUx6T2Pb9/ZFfkvSNNj0nrqdqx98qjOX3BvBu4g+wm1XrOZyMwpVdbXf6+AX8CPNX7Z1zOfEbUngPwJuC3BfNdqa1eNUXEMwDp/Y2pva7yTIcgjgMeoI5zSodgHgE2A3cCvwa2R8TOtEphzHvyScv/ABw4vBEP6ArgfwK70/yB1Hc+AfxU0po0DA/U7+/bYcAW4Pp02O+bkvanjPmMtOIw4PAcDaJu8pQ0HrgF+HREPF9s1T7aaiqniNgVEceS/cU9G3hrX6ul95rOR9LfAJsjYk1hcx+r1kU+yYkRcTzZIZaFkv6iyLq1ns8Y4Hjg6og4DniR1w4h9WXQ+Yy04tBow3M8K2kqQHrfnNrrIk9JY8kKw40RcWtqruucACJiO7CS7FzKJEk9N5sWxrwnn7R8IrBteCMt6kTgfZI2Ah1kh5auoH7zISI2pffNwA/ICni9/r51AV0R8UCav5msWJQtn5FWHBpteI5lwII0vYDsuH1P+1npCoUTgD/07GrWCkkCrgXWR8TlBYvqMidJB0malKb3Bd5DdoJwBTAvrdY7n5485wF3RToYXAsi4qKIaI6IFrL/J3dFxJnUaT6S9pc0oWca+CtgHXX6+xYR/w/4raS3pKY5ZI82KF8+1T6xUoUTOacCvyI7Hvz5ascziLi/CzwDvEr2V8A5ZMd0lwNPpPfJaV2RXZX1a2AtMKva8feRz0lku7WPAo+k16n1mhNwNPBwymcd8A+p/TBgFbAB+D6wT2ofl+Y3pOWHVTuHIrm1AnfUcz4p7l+kV2fP//16/X1LMR4LrE6/c7cBB5QzHw+fYWZmOSPtsJKZmZXAxcHMzHJcHMzMLMfFwczMclwczMwsx8XBap6kkPSVgvn/LuniMm37W5LmDbxmydubKGmJpF+n1xJJEwuWX6Zs1NbLevU7O+U5p6DtA6ltSPFJ+mHPvRdmg+XiYPXgZeCDkqZUO5BCaZTf3q4FnoyIwyPicLLB0b5ZsPzjwPER8T/66LsWOL1g/jSy6/KHJCJOjexubbNBc3GwerCT7Hm4/633gt5/+UvqTu+tkn4uaamkX0m6VNKZyp65sFbS4QWbeY+k/0jr/U3qPzr9lf9gGv/+4wXbXSHpJrIv88JYjgBmAl8qaP4nYJakwyUtA/YHHpD0kT7y/A9gtqSxacypI8huDuzZ/pw0yNpaZc/32EfSKZKWFqzTKunf0vTGnoIq6e9S7o9I+nrKb3T6+a1L28z9fG3kGjPwKmY1YTHwqKT/M4g+x5ANfrcNeBL4ZkTMVvZgofOAT6f1WoB3AYcDK9KX/FlkQwy8TdI+wL2SfprWnw0cFRFP9fq86cAjEbGrpyEidikbqXVGRLxPUndkg/P1JYCfAe8lG5toGXAoZA8TInumx5yI+JWkJcDfA4uAr0vaPyJeBD4CfK9wo5LemtpPjIhXJV0FnEl2p/CbIuKotJ4PQdke3nOwuhDZiK1LgPMH0e3BiHgmIl4mGzag58t9LVlB6LE0InZHxBNkReRIsrF3zkpf7A+QDUswLa2/qo/CANkQBX0NOdBfe186yA4nnUY2ZEqPtwBPRcSv0vwNwF9ENjz2j4G/TQPe/TWvjafTYw7ZHs2DKZ85ZMNJPAkcJulfJZ0MFBsV10YY7zlYPbmC7CE61xe07ST9kZMG83tDwbKXC6Z3F8zv5vW/+72/uIPsC/28iPhJ4QJJrWTDI/elEzhO0qiI2J3WH8VrT+kaUESsknQU8Me0h7Dno4t0+x6wkGwP6cGIeKHXcgE3RMRFvTtKOoZsT2Uh8GHgY6XEaY3Pew5WNyJiG7CU1x5NCdnTvWam6bnA2CFs+kOSRqXzEIeRPSXrJ8DfKxtWHEl/lkbzLBbfBrLB975Q0PwF4KG0rFQXAZ/r1fZLoCUd8gKYD/w8Ta8kG675XHodUkqWA/MkvRH2PDf5zel8xKiIuAX4X2kbZoD3HKz+fAX4ZMH8N4DbJa0i+xLs76/6Yh4n+6JtAv5rROyQ9E2yQ08PpT2SLcD7S9jWOcC/StpA9hf7fby+mA0oIn7UR9sOSR8Fvp8OHz0IfC0t2yXpDuBsXhuuubDvY5K+QPYUtFFkI/suBP5I9iSxnj8Sc3sWNnJ5VFYzM8vxYSUzM8txcTAzsxwXBzMzy3FxMDOzHBcHMzPLcXEwM7McFwczM8v5/5Tv9lB/gMHHAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "Movie_Mean_Count_Data[\"count\"].plot(bins = 150, kind = \"hist\", color = \"brown\")\n",
    "plt.grid()\n",
    "plt.legend()\n",
    "plt.xlabel(\"Number Of Movies\")\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "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>count</th>\n",
       "      <th>mean</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Aiqing wansui (1994)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Entertaining Angels: The Dorothy Day Story (1996)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Great Day in Harlem, A (1994)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Marlene Dietrich: Shadow and Light (1996)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Prefontaine (1997)</th>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Saint of Fort Washington, The (1993)</th>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Santa with Muscles (1996)</th>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Someone Else's America (1995)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Star Kid (1997)</th>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>They Made Me a Criminal (1939)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   count  mean\n",
       "title                                                         \n",
       "Aiqing wansui (1994)                                 1.0   5.0\n",
       "Entertaining Angels: The Dorothy Day Story (1996)    1.0   5.0\n",
       "Great Day in Harlem, A (1994)                        1.0   5.0\n",
       "Marlene Dietrich: Shadow and Light (1996)            1.0   5.0\n",
       "Prefontaine (1997)                                   3.0   5.0\n",
       "Saint of Fort Washington, The (1993)                 2.0   5.0\n",
       "Santa with Muscles (1996)                            2.0   5.0\n",
       "Someone Else's America (1995)                        1.0   5.0\n",
       "Star Kid (1997)                                      3.0   5.0\n",
       "They Made Me a Criminal (1939)                       1.0   5.0"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Movie_Mean_Count_Data[Movie_Mean_Count_Data[\"mean\"] == 5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "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>count</th>\n",
       "      <th>mean</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Star Wars (1977)</th>\n",
       "      <td>584.0</td>\n",
       "      <td>4.359589</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Contact (1997)</th>\n",
       "      <td>509.0</td>\n",
       "      <td>3.803536</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fargo (1996)</th>\n",
       "      <td>508.0</td>\n",
       "      <td>4.155512</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Return of the Jedi (1983)</th>\n",
       "      <td>507.0</td>\n",
       "      <td>4.007890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Liar Liar (1997)</th>\n",
       "      <td>485.0</td>\n",
       "      <td>3.156701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Great Day in Harlem, A (1994)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>5.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Voices, Other Rooms (1997)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>3.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Good Morning (1971)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Girls Town (1996)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>3.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Á köldum klaka (Cold Fever) (1994)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>3.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1664 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    count      mean\n",
       "title                                              \n",
       "Star Wars (1977)                    584.0  4.359589\n",
       "Contact (1997)                      509.0  3.803536\n",
       "Fargo (1996)                        508.0  4.155512\n",
       "Return of the Jedi (1983)           507.0  4.007890\n",
       "Liar Liar (1997)                    485.0  3.156701\n",
       "...                                   ...       ...\n",
       "Great Day in Harlem, A (1994)         1.0  5.000000\n",
       "Other Voices, Other Rooms (1997)      1.0  3.000000\n",
       "Good Morning (1971)                   1.0  1.000000\n",
       "Girls Town (1996)                     1.0  3.000000\n",
       "Á köldum klaka (Cold Fever) (1994)    1.0  3.000000\n",
       "\n",
       "[1664 rows x 2 columns]"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Movie_Mean_Count_Data.sort_values(\"count\", ascending = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "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>count</th>\n",
       "      <th>mean</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Á köldum klaka (Cold Fever) (1994)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mille bolle blu (1993)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mat' i syn (1997)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Marlene Dietrich: Shadow and Light (1996)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Man from Down Under, The (1943)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mamma Roma (1962)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mad Dog Time (1996)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Big Bang Theory, The (1994)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MURDER and murder (1996)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Coldblooded (1995)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Low Life, The (1994)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Love Is All There Is (1996)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lotto Land (1995)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bird of Prey (1996)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Liebelei (1933)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Leopard Son, The (1996)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lashou shentan (1992)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Land and Freedom (Tierra y libertad) (1995)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lady of Burlesque (1943)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Big One, The (1997)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             count  mean\n",
       "title                                                   \n",
       "Á köldum klaka (Cold Fever) (1994)             1.0   3.0\n",
       "Mille bolle blu (1993)                         1.0   1.0\n",
       "Mat' i syn (1997)                              1.0   1.0\n",
       "Marlene Dietrich: Shadow and Light (1996)      1.0   5.0\n",
       "Man from Down Under, The (1943)                1.0   1.0\n",
       "Mamma Roma (1962)                              1.0   4.0\n",
       "Mad Dog Time (1996)                            1.0   3.0\n",
       "Big Bang Theory, The (1994)                    1.0   4.0\n",
       "MURDER and murder (1996)                       1.0   2.0\n",
       "Coldblooded (1995)                             1.0   2.0\n",
       "Low Life, The (1994)                           1.0   1.0\n",
       "Love Is All There Is (1996)                    1.0   3.0\n",
       "Lotto Land (1995)                              1.0   1.0\n",
       "Bird of Prey (1996)                            1.0   1.0\n",
       "Liebelei (1933)                                1.0   1.0\n",
       "Leopard Son, The (1996)                        1.0   1.0\n",
       "Lashou shentan (1992)                          1.0   1.0\n",
       "Land and Freedom (Tierra y libertad) (1995)    1.0   3.0\n",
       "Lady of Burlesque (1943)                       1.0   4.0\n",
       "Big One, The (1997)                            1.0   3.0"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Movie_Mean_Count_Data.sort_values(\"count\").head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "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>user_id</th>\n",
       "      <th>item_id</th>\n",
       "      <th>rating</th>\n",
       "      <th>title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>50</td>\n",
       "      <td>5</td>\n",
       "      <td>Star Wars (1977)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>290</td>\n",
       "      <td>50</td>\n",
       "      <td>5</td>\n",
       "      <td>Star Wars (1977)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>79</td>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>Star Wars (1977)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2</td>\n",
       "      <td>50</td>\n",
       "      <td>5</td>\n",
       "      <td>Star Wars (1977)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>8</td>\n",
       "      <td>50</td>\n",
       "      <td>5</td>\n",
       "      <td>Star Wars (1977)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99998</th>\n",
       "      <td>840</td>\n",
       "      <td>1674</td>\n",
       "      <td>4</td>\n",
       "      <td>Mamma Roma (1962)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99999</th>\n",
       "      <td>655</td>\n",
       "      <td>1640</td>\n",
       "      <td>3</td>\n",
       "      <td>Eighth Day, The (1996)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100000</th>\n",
       "      <td>655</td>\n",
       "      <td>1637</td>\n",
       "      <td>3</td>\n",
       "      <td>Girls Town (1996)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100001</th>\n",
       "      <td>655</td>\n",
       "      <td>1630</td>\n",
       "      <td>3</td>\n",
       "      <td>Silence of the Palace, The (Saimt el Qusur) (1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100002</th>\n",
       "      <td>655</td>\n",
       "      <td>1641</td>\n",
       "      <td>3</td>\n",
       "      <td>Dadetown (1995)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100003 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        user_id  item_id  rating  \\\n",
       "0             0       50       5   \n",
       "1           290       50       5   \n",
       "2            79       50       4   \n",
       "3             2       50       5   \n",
       "4             8       50       5   \n",
       "...         ...      ...     ...   \n",
       "99998       840     1674       4   \n",
       "99999       655     1640       3   \n",
       "100000      655     1637       3   \n",
       "100001      655     1630       3   \n",
       "100002      655     1641       3   \n",
       "\n",
       "                                                    title  \n",
       "0                                        Star Wars (1977)  \n",
       "1                                        Star Wars (1977)  \n",
       "2                                        Star Wars (1977)  \n",
       "3                                        Star Wars (1977)  \n",
       "4                                        Star Wars (1977)  \n",
       "...                                                   ...  \n",
       "99998                                   Mamma Roma (1962)  \n",
       "99999                              Eighth Day, The (1996)  \n",
       "100000                                  Girls Town (1996)  \n",
       "100001  Silence of the Palace, The (Saimt el Qusur) (1...  \n",
       "100002                                    Dadetown (1995)  \n",
       "\n",
       "[100003 rows x 4 columns]"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Movies_Final_Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [],
   "source": [
    "user_id_Movie_data = Movies_Final_Data.pivot_table(index = \"user_id\", columns = \"title\", values = \"rating\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "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>title</th>\n",
       "      <th>'Til There Was You (1997)</th>\n",
       "      <th>1-900 (1994)</th>\n",
       "      <th>101 Dalmatians (1996)</th>\n",
       "      <th>12 Angry Men (1957)</th>\n",
       "      <th>187 (1997)</th>\n",
       "      <th>2 Days in the Valley (1996)</th>\n",
       "      <th>20,000 Leagues Under the Sea (1954)</th>\n",
       "      <th>2001: A Space Odyssey (1968)</th>\n",
       "      <th>3 Ninjas: High Noon At Mega Mountain (1998)</th>\n",
       "      <th>39 Steps, The (1935)</th>\n",
       "      <th>...</th>\n",
       "      <th>Yankee Zulu (1994)</th>\n",
       "      <th>Year of the Horse (1997)</th>\n",
       "      <th>You So Crazy (1994)</th>\n",
       "      <th>Young Frankenstein (1974)</th>\n",
       "      <th>Young Guns (1988)</th>\n",
       "      <th>Young Guns II (1990)</th>\n",
       "      <th>Young Poisoner's Handbook, The (1995)</th>\n",
       "      <th>Zeus and Roxanne (1997)</th>\n",
       "      <th>unknown</th>\n",
       "      <th>Á köldum klaka (Cold Fever) (1994)</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>user_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</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>939</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>940</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>941</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>942</th>\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>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>943</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</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>944 rows × 1664 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "title    'Til There Was You (1997)  1-900 (1994)  101 Dalmatians (1996)  \\\n",
       "user_id                                                                   \n",
       "0                              NaN           NaN                    NaN   \n",
       "1                              NaN           NaN                    2.0   \n",
       "2                              NaN           NaN                    NaN   \n",
       "3                              NaN           NaN                    NaN   \n",
       "4                              NaN           NaN                    NaN   \n",
       "...                            ...           ...                    ...   \n",
       "939                            NaN           NaN                    NaN   \n",
       "940                            NaN           NaN                    NaN   \n",
       "941                            NaN           NaN                    NaN   \n",
       "942                            NaN           NaN                    NaN   \n",
       "943                            NaN           NaN                    NaN   \n",
       "\n",
       "title    12 Angry Men (1957)  187 (1997)  2 Days in the Valley (1996)  \\\n",
       "user_id                                                                 \n",
       "0                        NaN         NaN                          NaN   \n",
       "1                        5.0         NaN                          NaN   \n",
       "2                        NaN         NaN                          NaN   \n",
       "3                        NaN         2.0                          NaN   \n",
       "4                        NaN         NaN                          NaN   \n",
       "...                      ...         ...                          ...   \n",
       "939                      NaN         NaN                          NaN   \n",
       "940                      NaN         NaN                          NaN   \n",
       "941                      NaN         NaN                          NaN   \n",
       "942                      NaN         NaN                          NaN   \n",
       "943                      NaN         NaN                          2.0   \n",
       "\n",
       "title    20,000 Leagues Under the Sea (1954)  2001: A Space Odyssey (1968)  \\\n",
       "user_id                                                                      \n",
       "0                                        NaN                           NaN   \n",
       "1                                        3.0                           4.0   \n",
       "2                                        NaN                           NaN   \n",
       "3                                        NaN                           NaN   \n",
       "4                                        NaN                           NaN   \n",
       "...                                      ...                           ...   \n",
       "939                                      NaN                           NaN   \n",
       "940                                      NaN                           NaN   \n",
       "941                                      NaN                           NaN   \n",
       "942                                      NaN                           3.0   \n",
       "943                                      NaN                           NaN   \n",
       "\n",
       "title    3 Ninjas: High Noon At Mega Mountain (1998)  39 Steps, The (1935)  \\\n",
       "user_id                                                                      \n",
       "0                                                NaN                   NaN   \n",
       "1                                                NaN                   NaN   \n",
       "2                                                1.0                   NaN   \n",
       "3                                                NaN                   NaN   \n",
       "4                                                NaN                   NaN   \n",
       "...                                              ...                   ...   \n",
       "939                                              NaN                   NaN   \n",
       "940                                              NaN                   NaN   \n",
       "941                                              NaN                   NaN   \n",
       "942                                              NaN                   3.0   \n",
       "943                                              NaN                   NaN   \n",
       "\n",
       "title    ...  Yankee Zulu (1994)  Year of the Horse (1997)  \\\n",
       "user_id  ...                                                 \n",
       "0        ...                 NaN                       NaN   \n",
       "1        ...                 NaN                       NaN   \n",
       "2        ...                 NaN                       NaN   \n",
       "3        ...                 NaN                       NaN   \n",
       "4        ...                 NaN                       NaN   \n",
       "...      ...                 ...                       ...   \n",
       "939      ...                 NaN                       NaN   \n",
       "940      ...                 NaN                       NaN   \n",
       "941      ...                 NaN                       NaN   \n",
       "942      ...                 NaN                       NaN   \n",
       "943      ...                 NaN                       NaN   \n",
       "\n",
       "title    You So Crazy (1994)  Young Frankenstein (1974)  Young Guns (1988)  \\\n",
       "user_id                                                                      \n",
       "0                        NaN                        NaN                NaN   \n",
       "1                        NaN                        5.0                3.0   \n",
       "2                        NaN                        NaN                NaN   \n",
       "3                        NaN                        NaN                NaN   \n",
       "4                        NaN                        NaN                NaN   \n",
       "...                      ...                        ...                ...   \n",
       "939                      NaN                        NaN                NaN   \n",
       "940                      NaN                        NaN                NaN   \n",
       "941                      NaN                        NaN                NaN   \n",
       "942                      NaN                        NaN                NaN   \n",
       "943                      NaN                        NaN                4.0   \n",
       "\n",
       "title    Young Guns II (1990)  Young Poisoner's Handbook, The (1995)  \\\n",
       "user_id                                                                \n",
       "0                         NaN                                    NaN   \n",
       "1                         NaN                                    NaN   \n",
       "2                         NaN                                    NaN   \n",
       "3                         NaN                                    NaN   \n",
       "4                         NaN                                    NaN   \n",
       "...                       ...                                    ...   \n",
       "939                       NaN                                    NaN   \n",
       "940                       NaN                                    NaN   \n",
       "941                       NaN                                    NaN   \n",
       "942                       NaN                                    NaN   \n",
       "943                       3.0                                    NaN   \n",
       "\n",
       "title    Zeus and Roxanne (1997)  unknown  Á köldum klaka (Cold Fever) (1994)  \n",
       "user_id                                                                        \n",
       "0                            NaN      NaN                                 NaN  \n",
       "1                            NaN      4.0                                 NaN  \n",
       "2                            NaN      NaN                                 NaN  \n",
       "3                            NaN      NaN                                 NaN  \n",
       "4                            NaN      NaN                                 NaN  \n",
       "...                          ...      ...                                 ...  \n",
       "939                          NaN      NaN                                 NaN  \n",
       "940                          NaN      NaN                                 NaN  \n",
       "941                          NaN      NaN                                 NaN  \n",
       "942                          NaN      NaN                                 NaN  \n",
       "943                          NaN      NaN                                 NaN  \n",
       "\n",
       "[944 rows x 1664 columns]"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "user_id_Movie_data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## <font color = \"brown\">  Recommendation based on 1 Movie"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [],
   "source": [
    "titanic_data = user_id_Movie_data[\"Titanic (1997)\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "user_id\n",
       "0      NaN\n",
       "1      NaN\n",
       "2      5.0\n",
       "3      NaN\n",
       "4      NaN\n",
       "      ... \n",
       "939    NaN\n",
       "940    5.0\n",
       "941    NaN\n",
       "942    3.0\n",
       "943    NaN\n",
       "Name: Titanic (1997), Length: 944, dtype: float64"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "titanic_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {},
   "outputs": [],
   "source": [
    "star_wars = user_id_Movie_data[\"Star Wars (1977)\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "user_id\n",
       "0      5.0\n",
       "1      5.0\n",
       "2      5.0\n",
       "3      NaN\n",
       "4      5.0\n",
       "      ... \n",
       "939    NaN\n",
       "940    4.0\n",
       "941    NaN\n",
       "942    5.0\n",
       "943    4.0\n",
       "Name: Star Wars (1977), Length: 944, dtype: float64"
      ]
     },
     "execution_count": 81,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "star_wars"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "metadata": {},
   "outputs": [],
   "source": [
    "titanic_correlations = pd.DataFrame(user_id_Movie_data.corrwith(titanic_data), columns = [\"Correlations\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "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>Correlations</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>'Til There Was You (1997)</th>\n",
       "      <td>-0.062017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1-900 (1994)</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101 Dalmatians (1996)</th>\n",
       "      <td>0.120113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12 Angry Men (1957)</th>\n",
       "      <td>0.077700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187 (1997)</th>\n",
       "      <td>0.315654</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Young Guns II (1990)</th>\n",
       "      <td>0.317274</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Young Poisoner's Handbook, The (1995)</th>\n",
       "      <td>0.356783</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zeus and Roxanne (1997)</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unknown</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Á köldum klaka (Cold Fever) (1994)</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1664 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       Correlations\n",
       "title                                              \n",
       "'Til There Was You (1997)                 -0.062017\n",
       "1-900 (1994)                                    NaN\n",
       "101 Dalmatians (1996)                      0.120113\n",
       "12 Angry Men (1957)                        0.077700\n",
       "187 (1997)                                 0.315654\n",
       "...                                             ...\n",
       "Young Guns II (1990)                       0.317274\n",
       "Young Poisoner's Handbook, The (1995)      0.356783\n",
       "Zeus and Roxanne (1997)                         NaN\n",
       "unknown                                         NaN\n",
       "Á köldum klaka (Cold Fever) (1994)              NaN\n",
       "\n",
       "[1664 rows x 1 columns]"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "titanic_correlations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "metadata": {},
   "outputs": [],
   "source": [
    "titanic_correlations = titanic_correlations.join(Movie_Mean_Count_Data[\"count\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "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>Correlations</th>\n",
       "      <th>count</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>'Til There Was You (1997)</th>\n",
       "      <td>-0.062017</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1-900 (1994)</th>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101 Dalmatians (1996)</th>\n",
       "      <td>0.120113</td>\n",
       "      <td>109.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12 Angry Men (1957)</th>\n",
       "      <td>0.077700</td>\n",
       "      <td>125.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187 (1997)</th>\n",
       "      <td>0.315654</td>\n",
       "      <td>41.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Young Guns II (1990)</th>\n",
       "      <td>0.317274</td>\n",
       "      <td>44.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Young Poisoner's Handbook, The (1995)</th>\n",
       "      <td>0.356783</td>\n",
       "      <td>41.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zeus and Roxanne (1997)</th>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unknown</th>\n",
       "      <td>NaN</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Á köldum klaka (Cold Fever) (1994)</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1664 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       Correlations  count\n",
       "title                                                     \n",
       "'Til There Was You (1997)                 -0.062017    9.0\n",
       "1-900 (1994)                                    NaN    5.0\n",
       "101 Dalmatians (1996)                      0.120113  109.0\n",
       "12 Angry Men (1957)                        0.077700  125.0\n",
       "187 (1997)                                 0.315654   41.0\n",
       "...                                             ...    ...\n",
       "Young Guns II (1990)                       0.317274   44.0\n",
       "Young Poisoner's Handbook, The (1995)      0.356783   41.0\n",
       "Zeus and Roxanne (1997)                         NaN    6.0\n",
       "unknown                                         NaN    9.0\n",
       "Á köldum klaka (Cold Fever) (1994)              NaN    1.0\n",
       "\n",
       "[1664 rows x 2 columns]"
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "titanic_correlations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [],
   "source": [
    "titanic_correlations.dropna(inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "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>Correlations</th>\n",
       "      <th>count</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>'Til There Was You (1997)</th>\n",
       "      <td>-0.062017</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101 Dalmatians (1996)</th>\n",
       "      <td>0.120113</td>\n",
       "      <td>109.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12 Angry Men (1957)</th>\n",
       "      <td>0.077700</td>\n",
       "      <td>125.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187 (1997)</th>\n",
       "      <td>0.315654</td>\n",
       "      <td>41.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2 Days in the Valley (1996)</th>\n",
       "      <td>0.017295</td>\n",
       "      <td>93.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Year of the Horse (1997)</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Young Frankenstein (1974)</th>\n",
       "      <td>0.107666</td>\n",
       "      <td>200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Young Guns (1988)</th>\n",
       "      <td>0.199931</td>\n",
       "      <td>101.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Young Guns II (1990)</th>\n",
       "      <td>0.317274</td>\n",
       "      <td>44.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Young Poisoner's Handbook, The (1995)</th>\n",
       "      <td>0.356783</td>\n",
       "      <td>41.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1356 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       Correlations  count\n",
       "title                                                     \n",
       "'Til There Was You (1997)                 -0.062017    9.0\n",
       "101 Dalmatians (1996)                      0.120113  109.0\n",
       "12 Angry Men (1957)                        0.077700  125.0\n",
       "187 (1997)                                 0.315654   41.0\n",
       "2 Days in the Valley (1996)                0.017295   93.0\n",
       "...                                             ...    ...\n",
       "Year of the Horse (1997)                   1.000000    7.0\n",
       "Young Frankenstein (1974)                  0.107666  200.0\n",
       "Young Guns (1988)                          0.199931  101.0\n",
       "Young Guns II (1990)                       0.317274   44.0\n",
       "Young Poisoner's Handbook, The (1995)      0.356783   41.0\n",
       "\n",
       "[1356 rows x 2 columns]"
      ]
     },
     "execution_count": 88,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "titanic_correlations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "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>Correlations</th>\n",
       "      <th>count</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Nadja (1994)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pest, The (1997)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Savage Nights (Nuits fauves, Les) (1992)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>For Ever Mozart (1996)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jerky Boys, The (1994)</th>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pather Panchali (1955)</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Angel Baby (1995)</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Blood Beach (1981)</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Two Bits (1995)</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Faces (1968)</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1356 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          Correlations  count\n",
       "title                                                        \n",
       "Nadja (1994)                                       1.0    8.0\n",
       "Pest, The (1997)                                   1.0    8.0\n",
       "Savage Nights (Nuits fauves, Les) (1992)           1.0    3.0\n",
       "For Ever Mozart (1996)                             1.0    3.0\n",
       "Jerky Boys, The (1994)                             1.0    3.0\n",
       "...                                                ...    ...\n",
       "Pather Panchali (1955)                            -1.0    8.0\n",
       "Angel Baby (1995)                                 -1.0    4.0\n",
       "Blood Beach (1981)                                -1.0    6.0\n",
       "Two Bits (1995)                                   -1.0    5.0\n",
       "Faces (1968)                                      -1.0    4.0\n",
       "\n",
       "[1356 rows x 2 columns]"
      ]
     },
     "execution_count": 90,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "titanic_correlations.sort_values(\"Correlations\", ascending = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "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>Correlations</th>\n",
       "      <th>count</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Titanic (1997)</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>350.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>River Wild, The (1994)</th>\n",
       "      <td>0.497600</td>\n",
       "      <td>146.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Abyss, The (1989)</th>\n",
       "      <td>0.472103</td>\n",
       "      <td>151.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bram Stoker's Dracula (1992)</th>\n",
       "      <td>0.443560</td>\n",
       "      <td>120.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>True Lies (1994)</th>\n",
       "      <td>0.435104</td>\n",
       "      <td>208.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>William Shakespeare's Romeo and Juliet (1996)</th>\n",
       "      <td>0.430243</td>\n",
       "      <td>106.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Last of the Mohicans, The (1992)</th>\n",
       "      <td>0.427239</td>\n",
       "      <td>128.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Outbreak (1995)</th>\n",
       "      <td>0.426237</td>\n",
       "      <td>104.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Die Hard (1988)</th>\n",
       "      <td>0.403124</td>\n",
       "      <td>243.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Frighteners, The (1996)</th>\n",
       "      <td>0.398516</td>\n",
       "      <td>115.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Air Force One (1997)</th>\n",
       "      <td>0.383730</td>\n",
       "      <td>431.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jurassic Park (1993)</th>\n",
       "      <td>0.382785</td>\n",
       "      <td>261.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Star Trek: Generations (1994)</th>\n",
       "      <td>0.382300</td>\n",
       "      <td>116.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Father of the Bride Part II (1995)</th>\n",
       "      <td>0.381120</td>\n",
       "      <td>128.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waterworld (1995)</th>\n",
       "      <td>0.376446</td>\n",
       "      <td>102.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               Correlations  count\n",
       "title                                                             \n",
       "Titanic (1997)                                     1.000000  350.0\n",
       "River Wild, The (1994)                             0.497600  146.0\n",
       "Abyss, The (1989)                                  0.472103  151.0\n",
       "Bram Stoker's Dracula (1992)                       0.443560  120.0\n",
       "True Lies (1994)                                   0.435104  208.0\n",
       "William Shakespeare's Romeo and Juliet (1996)      0.430243  106.0\n",
       "Last of the Mohicans, The (1992)                   0.427239  128.0\n",
       "Outbreak (1995)                                    0.426237  104.0\n",
       "Die Hard (1988)                                    0.403124  243.0\n",
       "Frighteners, The (1996)                            0.398516  115.0\n",
       "Air Force One (1997)                               0.383730  431.0\n",
       "Jurassic Park (1993)                               0.382785  261.0\n",
       "Star Trek: Generations (1994)                      0.382300  116.0\n",
       "Father of the Bride Part II (1995)                 0.381120  128.0\n",
       "Waterworld (1995)                                  0.376446  102.0"
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "titanic_correlations[titanic_correlations[\"count\"] > 100].sort_values(\"Correlations\", ascending = False).head(15)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "metadata": {},
   "outputs": [],
   "source": [
    "star_wars_correlations = pd.DataFrame(user_id_Movie_data.corrwith(star_wars), columns = [\"Correlations\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "metadata": {},
   "outputs": [],
   "source": [
    "star_wars_correlations.dropna(inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "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>Correlations</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>'Til There Was You (1997)</th>\n",
       "      <td>0.872872</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1-900 (1994)</th>\n",
       "      <td>-0.645497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101 Dalmatians (1996)</th>\n",
       "      <td>0.211132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12 Angry Men (1957)</th>\n",
       "      <td>0.184289</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187 (1997)</th>\n",
       "      <td>0.027398</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Young Guns (1988)</th>\n",
       "      <td>0.186377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Young Guns II (1990)</th>\n",
       "      <td>0.228615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Young Poisoner's Handbook, The (1995)</th>\n",
       "      <td>-0.007374</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zeus and Roxanne (1997)</th>\n",
       "      <td>0.818182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unknown</th>\n",
       "      <td>0.723123</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1410 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       Correlations\n",
       "title                                              \n",
       "'Til There Was You (1997)                  0.872872\n",
       "1-900 (1994)                              -0.645497\n",
       "101 Dalmatians (1996)                      0.211132\n",
       "12 Angry Men (1957)                        0.184289\n",
       "187 (1997)                                 0.027398\n",
       "...                                             ...\n",
       "Young Guns (1988)                          0.186377\n",
       "Young Guns II (1990)                       0.228615\n",
       "Young Poisoner's Handbook, The (1995)     -0.007374\n",
       "Zeus and Roxanne (1997)                    0.818182\n",
       "unknown                                    0.723123\n",
       "\n",
       "[1410 rows x 1 columns]"
      ]
     },
     "execution_count": 106,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "star_wars_correlations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "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>Correlations</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Commandments (1997)</th>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cosi (1996)</th>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>No Escape (1994)</th>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Stripes (1981)</th>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Man of the Year (1995)</th>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>For Ever Mozart (1996)</th>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Frankie Starlight (1995)</th>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>I Like It Like That (1994)</th>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>American Dream (1990)</th>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Theodore Rex (1995)</th>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1410 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            Correlations\n",
       "title                                   \n",
       "Commandments (1997)                  1.0\n",
       "Cosi (1996)                          1.0\n",
       "No Escape (1994)                     1.0\n",
       "Stripes (1981)                       1.0\n",
       "Man of the Year (1995)               1.0\n",
       "...                                  ...\n",
       "For Ever Mozart (1996)              -1.0\n",
       "Frankie Starlight (1995)            -1.0\n",
       "I Like It Like That (1994)          -1.0\n",
       "American Dream (1990)               -1.0\n",
       "Theodore Rex (1995)                 -1.0\n",
       "\n",
       "[1410 rows x 1 columns]"
      ]
     },
     "execution_count": 107,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "star_wars_correlations.sort_values(\"Correlations\", ascending = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {},
   "outputs": [],
   "source": [
    "star_wars_correlations = star_wars_correlations.join(Movie_Mean_Count_Data[\"count\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "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>Correlations</th>\n",
       "      <th>count</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Star Wars (1977)</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>584.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Empire Strikes Back, The (1980)</th>\n",
       "      <td>0.748353</td>\n",
       "      <td>368.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Return of the Jedi (1983)</th>\n",
       "      <td>0.672556</td>\n",
       "      <td>507.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Raiders of the Lost Ark (1981)</th>\n",
       "      <td>0.536117</td>\n",
       "      <td>420.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Austin Powers: International Man of Mystery (1997)</th>\n",
       "      <td>0.377433</td>\n",
       "      <td>130.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sting, The (1973)</th>\n",
       "      <td>0.367538</td>\n",
       "      <td>241.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Indiana Jones and the Last Crusade (1989)</th>\n",
       "      <td>0.350107</td>\n",
       "      <td>331.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pinocchio (1940)</th>\n",
       "      <td>0.347868</td>\n",
       "      <td>101.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Frighteners, The (1996)</th>\n",
       "      <td>0.332729</td>\n",
       "      <td>115.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>L.A. Confidential (1997)</th>\n",
       "      <td>0.319065</td>\n",
       "      <td>297.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wag the Dog (1997)</th>\n",
       "      <td>0.318645</td>\n",
       "      <td>137.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dumbo (1941)</th>\n",
       "      <td>0.317656</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bridge on the River Kwai, The (1957)</th>\n",
       "      <td>0.316580</td>\n",
       "      <td>165.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Philadelphia Story, The (1940)</th>\n",
       "      <td>0.314272</td>\n",
       "      <td>104.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Miracle on 34th Street (1994)</th>\n",
       "      <td>0.310921</td>\n",
       "      <td>101.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    Correlations  count\n",
       "title                                                                  \n",
       "Star Wars (1977)                                        1.000000  584.0\n",
       "Empire Strikes Back, The (1980)                         0.748353  368.0\n",
       "Return of the Jedi (1983)                               0.672556  507.0\n",
       "Raiders of the Lost Ark (1981)                          0.536117  420.0\n",
       "Austin Powers: International Man of Mystery (1997)      0.377433  130.0\n",
       "Sting, The (1973)                                       0.367538  241.0\n",
       "Indiana Jones and the Last Crusade (1989)               0.350107  331.0\n",
       "Pinocchio (1940)                                        0.347868  101.0\n",
       "Frighteners, The (1996)                                 0.332729  115.0\n",
       "L.A. Confidential (1997)                                0.319065  297.0\n",
       "Wag the Dog (1997)                                      0.318645  137.0\n",
       "Dumbo (1941)                                            0.317656  123.0\n",
       "Bridge on the River Kwai, The (1957)                    0.316580  165.0\n",
       "Philadelphia Story, The (1940)                          0.314272  104.0\n",
       "Miracle on 34th Street (1994)                           0.310921  101.0"
      ]
     },
     "execution_count": 109,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "star_wars_correlations[star_wars_correlations[\"count\"] > 100].sort_values(\"Correlations\", ascending = False).head(15)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## <font color = \"brown\">  Full Movie Recommendation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "metadata": {},
   "outputs": [],
   "source": [
    "movie_correlations = user_id_Movie_data.corr(method = \"pearson\", min_periods = 100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "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>title</th>\n",
       "      <th>'Til There Was You (1997)</th>\n",
       "      <th>1-900 (1994)</th>\n",
       "      <th>101 Dalmatians (1996)</th>\n",
       "      <th>12 Angry Men (1957)</th>\n",
       "      <th>187 (1997)</th>\n",
       "      <th>2 Days in the Valley (1996)</th>\n",
       "      <th>20,000 Leagues Under the Sea (1954)</th>\n",
       "      <th>2001: A Space Odyssey (1968)</th>\n",
       "      <th>3 Ninjas: High Noon At Mega Mountain (1998)</th>\n",
       "      <th>39 Steps, The (1935)</th>\n",
       "      <th>...</th>\n",
       "      <th>Yankee Zulu (1994)</th>\n",
       "      <th>Year of the Horse (1997)</th>\n",
       "      <th>You So Crazy (1994)</th>\n",
       "      <th>Young Frankenstein (1974)</th>\n",
       "      <th>Young Guns (1988)</th>\n",
       "      <th>Young Guns II (1990)</th>\n",
       "      <th>Young Poisoner's Handbook, The (1995)</th>\n",
       "      <th>Zeus and Roxanne (1997)</th>\n",
       "      <th>unknown</th>\n",
       "      <th>Á köldum klaka (Cold Fever) (1994)</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>'Til There Was You (1997)</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1-900 (1994)</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101 Dalmatians (1996)</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</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>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12 Angry Men (1957)</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</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>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187 (1997)</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</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>Young Guns II (1990)</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Young Poisoner's Handbook, The (1995)</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zeus and Roxanne (1997)</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unknown</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Á köldum klaka (Cold Fever) (1994)</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1664 rows × 1664 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "title                                  'Til There Was You (1997)  \\\n",
       "title                                                              \n",
       "'Til There Was You (1997)                                    NaN   \n",
       "1-900 (1994)                                                 NaN   \n",
       "101 Dalmatians (1996)                                        NaN   \n",
       "12 Angry Men (1957)                                          NaN   \n",
       "187 (1997)                                                   NaN   \n",
       "...                                                          ...   \n",
       "Young Guns II (1990)                                         NaN   \n",
       "Young Poisoner's Handbook, The (1995)                        NaN   \n",
       "Zeus and Roxanne (1997)                                      NaN   \n",
       "unknown                                                      NaN   \n",
       "Á köldum klaka (Cold Fever) (1994)                           NaN   \n",
       "\n",
       "title                                  1-900 (1994)  101 Dalmatians (1996)  \\\n",
       "title                                                                        \n",
       "'Til There Was You (1997)                       NaN                    NaN   \n",
       "1-900 (1994)                                    NaN                    NaN   \n",
       "101 Dalmatians (1996)                           NaN                    1.0   \n",
       "12 Angry Men (1957)                             NaN                    NaN   \n",
       "187 (1997)                                      NaN                    NaN   \n",
       "...                                             ...                    ...   \n",
       "Young Guns II (1990)                            NaN                    NaN   \n",
       "Young Poisoner's Handbook, The (1995)           NaN                    NaN   \n",
       "Zeus and Roxanne (1997)                         NaN                    NaN   \n",
       "unknown                                         NaN                    NaN   \n",
       "Á köldum klaka (Cold Fever) (1994)              NaN                    NaN   \n",
       "\n",
       "title                                  12 Angry Men (1957)  187 (1997)  \\\n",
       "title                                                                    \n",
       "'Til There Was You (1997)                              NaN         NaN   \n",
       "1-900 (1994)                                           NaN         NaN   \n",
       "101 Dalmatians (1996)                                  NaN         NaN   \n",
       "12 Angry Men (1957)                                    1.0         NaN   \n",
       "187 (1997)                                             NaN         NaN   \n",
       "...                                                    ...         ...   \n",
       "Young Guns II (1990)                                   NaN         NaN   \n",
       "Young Poisoner's Handbook, The (1995)                  NaN         NaN   \n",
       "Zeus and Roxanne (1997)                                NaN         NaN   \n",
       "unknown                                                NaN         NaN   \n",
       "Á köldum klaka (Cold Fever) (1994)                     NaN         NaN   \n",
       "\n",
       "title                                  2 Days in the Valley (1996)  \\\n",
       "title                                                                \n",
       "'Til There Was You (1997)                                      NaN   \n",
       "1-900 (1994)                                                   NaN   \n",
       "101 Dalmatians (1996)                                          NaN   \n",
       "12 Angry Men (1957)                                            NaN   \n",
       "187 (1997)                                                     NaN   \n",
       "...                                                            ...   \n",
       "Young Guns II (1990)                                           NaN   \n",
       "Young Poisoner's Handbook, The (1995)                          NaN   \n",
       "Zeus and Roxanne (1997)                                        NaN   \n",
       "unknown                                                        NaN   \n",
       "Á köldum klaka (Cold Fever) (1994)                             NaN   \n",
       "\n",
       "title                                  20,000 Leagues Under the Sea (1954)  \\\n",
       "title                                                                        \n",
       "'Til There Was You (1997)                                              NaN   \n",
       "1-900 (1994)                                                           NaN   \n",
       "101 Dalmatians (1996)                                                  NaN   \n",
       "12 Angry Men (1957)                                                    NaN   \n",
       "187 (1997)                                                             NaN   \n",
       "...                                                                    ...   \n",
       "Young Guns II (1990)                                                   NaN   \n",
       "Young Poisoner's Handbook, The (1995)                                  NaN   \n",
       "Zeus and Roxanne (1997)                                                NaN   \n",
       "unknown                                                                NaN   \n",
       "Á köldum klaka (Cold Fever) (1994)                                     NaN   \n",
       "\n",
       "title                                  2001: A Space Odyssey (1968)  \\\n",
       "title                                                                 \n",
       "'Til There Was You (1997)                                       NaN   \n",
       "1-900 (1994)                                                    NaN   \n",
       "101 Dalmatians (1996)                                           NaN   \n",
       "12 Angry Men (1957)                                             NaN   \n",
       "187 (1997)                                                      NaN   \n",
       "...                                                             ...   \n",
       "Young Guns II (1990)                                            NaN   \n",
       "Young Poisoner's Handbook, The (1995)                           NaN   \n",
       "Zeus and Roxanne (1997)                                         NaN   \n",
       "unknown                                                         NaN   \n",
       "Á köldum klaka (Cold Fever) (1994)                              NaN   \n",
       "\n",
       "title                                  3 Ninjas: High Noon At Mega Mountain (1998)  \\\n",
       "title                                                                                \n",
       "'Til There Was You (1997)                                                      NaN   \n",
       "1-900 (1994)                                                                   NaN   \n",
       "101 Dalmatians (1996)                                                          NaN   \n",
       "12 Angry Men (1957)                                                            NaN   \n",
       "187 (1997)                                                                     NaN   \n",
       "...                                                                            ...   \n",
       "Young Guns II (1990)                                                           NaN   \n",
       "Young Poisoner's Handbook, The (1995)                                          NaN   \n",
       "Zeus and Roxanne (1997)                                                        NaN   \n",
       "unknown                                                                        NaN   \n",
       "Á köldum klaka (Cold Fever) (1994)                                             NaN   \n",
       "\n",
       "title                                  39 Steps, The (1935)  ...  \\\n",
       "title                                                        ...   \n",
       "'Til There Was You (1997)                               NaN  ...   \n",
       "1-900 (1994)                                            NaN  ...   \n",
       "101 Dalmatians (1996)                                   NaN  ...   \n",
       "12 Angry Men (1957)                                     NaN  ...   \n",
       "187 (1997)                                              NaN  ...   \n",
       "...                                                     ...  ...   \n",
       "Young Guns II (1990)                                    NaN  ...   \n",
       "Young Poisoner's Handbook, The (1995)                   NaN  ...   \n",
       "Zeus and Roxanne (1997)                                 NaN  ...   \n",
       "unknown                                                 NaN  ...   \n",
       "Á köldum klaka (Cold Fever) (1994)                      NaN  ...   \n",
       "\n",
       "title                                  Yankee Zulu (1994)  \\\n",
       "title                                                       \n",
       "'Til There Was You (1997)                             NaN   \n",
       "1-900 (1994)                                          NaN   \n",
       "101 Dalmatians (1996)                                 NaN   \n",
       "12 Angry Men (1957)                                   NaN   \n",
       "187 (1997)                                            NaN   \n",
       "...                                                   ...   \n",
       "Young Guns II (1990)                                  NaN   \n",
       "Young Poisoner's Handbook, The (1995)                 NaN   \n",
       "Zeus and Roxanne (1997)                               NaN   \n",
       "unknown                                               NaN   \n",
       "Á köldum klaka (Cold Fever) (1994)                    NaN   \n",
       "\n",
       "title                                  Year of the Horse (1997)  \\\n",
       "title                                                             \n",
       "'Til There Was You (1997)                                   NaN   \n",
       "1-900 (1994)                                                NaN   \n",
       "101 Dalmatians (1996)                                       NaN   \n",
       "12 Angry Men (1957)                                         NaN   \n",
       "187 (1997)                                                  NaN   \n",
       "...                                                         ...   \n",
       "Young Guns II (1990)                                        NaN   \n",
       "Young Poisoner's Handbook, The (1995)                       NaN   \n",
       "Zeus and Roxanne (1997)                                     NaN   \n",
       "unknown                                                     NaN   \n",
       "Á köldum klaka (Cold Fever) (1994)                          NaN   \n",
       "\n",
       "title                                  You So Crazy (1994)  \\\n",
       "title                                                        \n",
       "'Til There Was You (1997)                              NaN   \n",
       "1-900 (1994)                                           NaN   \n",
       "101 Dalmatians (1996)                                  NaN   \n",
       "12 Angry Men (1957)                                    NaN   \n",
       "187 (1997)                                             NaN   \n",
       "...                                                    ...   \n",
       "Young Guns II (1990)                                   NaN   \n",
       "Young Poisoner's Handbook, The (1995)                  NaN   \n",
       "Zeus and Roxanne (1997)                                NaN   \n",
       "unknown                                                NaN   \n",
       "Á köldum klaka (Cold Fever) (1994)                     NaN   \n",
       "\n",
       "title                                  Young Frankenstein (1974)  \\\n",
       "title                                                              \n",
       "'Til There Was You (1997)                                    NaN   \n",
       "1-900 (1994)                                                 NaN   \n",
       "101 Dalmatians (1996)                                        NaN   \n",
       "12 Angry Men (1957)                                          NaN   \n",
       "187 (1997)                                                   NaN   \n",
       "...                                                          ...   \n",
       "Young Guns II (1990)                                         NaN   \n",
       "Young Poisoner's Handbook, The (1995)                        NaN   \n",
       "Zeus and Roxanne (1997)                                      NaN   \n",
       "unknown                                                      NaN   \n",
       "Á köldum klaka (Cold Fever) (1994)                           NaN   \n",
       "\n",
       "title                                  Young Guns (1988)  \\\n",
       "title                                                      \n",
       "'Til There Was You (1997)                            NaN   \n",
       "1-900 (1994)                                         NaN   \n",
       "101 Dalmatians (1996)                                NaN   \n",
       "12 Angry Men (1957)                                  NaN   \n",
       "187 (1997)                                           NaN   \n",
       "...                                                  ...   \n",
       "Young Guns II (1990)                                 NaN   \n",
       "Young Poisoner's Handbook, The (1995)                NaN   \n",
       "Zeus and Roxanne (1997)                              NaN   \n",
       "unknown                                              NaN   \n",
       "Á köldum klaka (Cold Fever) (1994)                   NaN   \n",
       "\n",
       "title                                  Young Guns II (1990)  \\\n",
       "title                                                         \n",
       "'Til There Was You (1997)                               NaN   \n",
       "1-900 (1994)                                            NaN   \n",
       "101 Dalmatians (1996)                                   NaN   \n",
       "12 Angry Men (1957)                                     NaN   \n",
       "187 (1997)                                              NaN   \n",
       "...                                                     ...   \n",
       "Young Guns II (1990)                                    NaN   \n",
       "Young Poisoner's Handbook, The (1995)                   NaN   \n",
       "Zeus and Roxanne (1997)                                 NaN   \n",
       "unknown                                                 NaN   \n",
       "Á köldum klaka (Cold Fever) (1994)                      NaN   \n",
       "\n",
       "title                                  Young Poisoner's Handbook, The (1995)  \\\n",
       "title                                                                          \n",
       "'Til There Was You (1997)                                                NaN   \n",
       "1-900 (1994)                                                             NaN   \n",
       "101 Dalmatians (1996)                                                    NaN   \n",
       "12 Angry Men (1957)                                                      NaN   \n",
       "187 (1997)                                                               NaN   \n",
       "...                                                                      ...   \n",
       "Young Guns II (1990)                                                     NaN   \n",
       "Young Poisoner's Handbook, The (1995)                                    NaN   \n",
       "Zeus and Roxanne (1997)                                                  NaN   \n",
       "unknown                                                                  NaN   \n",
       "Á köldum klaka (Cold Fever) (1994)                                       NaN   \n",
       "\n",
       "title                                  Zeus and Roxanne (1997)  unknown  \\\n",
       "title                                                                     \n",
       "'Til There Was You (1997)                                  NaN      NaN   \n",
       "1-900 (1994)                                               NaN      NaN   \n",
       "101 Dalmatians (1996)                                      NaN      NaN   \n",
       "12 Angry Men (1957)                                        NaN      NaN   \n",
       "187 (1997)                                                 NaN      NaN   \n",
       "...                                                        ...      ...   \n",
       "Young Guns II (1990)                                       NaN      NaN   \n",
       "Young Poisoner's Handbook, The (1995)                      NaN      NaN   \n",
       "Zeus and Roxanne (1997)                                    NaN      NaN   \n",
       "unknown                                                    NaN      NaN   \n",
       "Á köldum klaka (Cold Fever) (1994)                         NaN      NaN   \n",
       "\n",
       "title                                  Á köldum klaka (Cold Fever) (1994)  \n",
       "title                                                                      \n",
       "'Til There Was You (1997)                                             NaN  \n",
       "1-900 (1994)                                                          NaN  \n",
       "101 Dalmatians (1996)                                                 NaN  \n",
       "12 Angry Men (1957)                                                   NaN  \n",
       "187 (1997)                                                            NaN  \n",
       "...                                                                   ...  \n",
       "Young Guns II (1990)                                                  NaN  \n",
       "Young Poisoner's Handbook, The (1995)                                 NaN  \n",
       "Zeus and Roxanne (1997)                                               NaN  \n",
       "unknown                                                               NaN  \n",
       "Á köldum klaka (Cold Fever) (1994)                                    NaN  \n",
       "\n",
       "[1664 rows x 1664 columns]"
      ]
     },
     "execution_count": 111,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movie_correlations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 171,
   "metadata": {},
   "outputs": [],
   "source": [
    "my_ratings = pd.DataFrame({\"Movie Name\":[\"Return of the Jedi (1983)\", \"Miracle on 34th Street (1994)\"],\"Ratings\":[1,5]})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 172,
   "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 Name</th>\n",
       "      <th>Ratings</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Return of the Jedi (1983)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Miracle on 34th Street (1994)</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      Movie Name  Ratings\n",
       "0      Return of the Jedi (1983)        1\n",
       "1  Miracle on 34th Street (1994)        5"
      ]
     },
     "execution_count": 172,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "my_ratings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 173,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/opt/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:1: DeprecationWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "similar_movie_list = pd.Series()\n",
    "\n",
    "for i in range(len(my_ratings)):\n",
    "    similar_movie = movie_correlations[my_ratings[\"Movie Name\"][i]].dropna()\n",
    "    similar_movie = similar_movie.map(lambda x: x * my_ratings[\"Ratings\"][i])\n",
    "    similar_movie_list = similar_movie_list.append(similar_movie)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 174,
   "metadata": {},
   "outputs": [],
   "source": [
    "similar_movie_list.sort_values(inplace = True, ascending = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 176,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Miracle on 34th Street (1994)                                                  5.000000\n",
      "Return of the Jedi (1983)                                                      1.000000\n",
      "Empire Strikes Back, The (1980)                                                0.721229\n",
      "Star Wars (1977)                                                               0.672556\n",
      "Raiders of the Lost Ark (1981)                                                 0.467391\n",
      "                                                                                 ...   \n",
      "Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb (1963)   -0.082562\n",
      "Pulp Fiction (1994)                                                           -0.106475\n",
      "Brazil (1985)                                                                 -0.111670\n",
      "Annie Hall (1977)                                                             -0.116004\n",
      "Trainspotting (1996)                                                          -0.133843\n",
      "Length: 246, dtype: float64\n"
     ]
    }
   ],
   "source": [
    "print(similar_movie_list)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# <font color = \"Brown\" >Hope You Like it! </font>"
   ]
  }
 ],
 "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.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}