Movide_Recommender_System.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "a2894105",
   "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,
   "id": "78f04cff",
   "metadata": {},
   "outputs": [],
   "source": [
    "movie_titles_df = pd.read_csv('Movie_Id_Titles')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "4b6d8ca3",
   "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>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1677</th>\n",
       "      <td>1678</td>\n",
       "      <td>Mat' i syn (1997)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1678</th>\n",
       "      <td>1679</td>\n",
       "      <td>B. Monkey (1998)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1679</th>\n",
       "      <td>1680</td>\n",
       "      <td>Sliding Doors (1998)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1680</th>\n",
       "      <td>1681</td>\n",
       "      <td>You So Crazy (1994)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1681</th>\n",
       "      <td>1682</td>\n",
       "      <td>Scream of Stone (Schrei aus Stein) (1991)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1682 rows × 2 columns</p>\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",
       "...       ...                                        ...\n",
       "1677     1678                          Mat' i syn (1997)\n",
       "1678     1679                           B. Monkey (1998)\n",
       "1679     1680                       Sliding Doors (1998)\n",
       "1680     1681                        You So Crazy (1994)\n",
       "1681     1682  Scream of Stone (Schrei aus Stein) (1991)\n",
       "\n",
       "[1682 rows x 2 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movie_titles_df "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "228d06da",
   "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",
       "  </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)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movie_titles_df.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "38eda750",
   "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>1677</th>\n",
       "      <td>1678</td>\n",
       "      <td>Mat' i syn (1997)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1678</th>\n",
       "      <td>1679</td>\n",
       "      <td>B. Monkey (1998)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1679</th>\n",
       "      <td>1680</td>\n",
       "      <td>Sliding Doors (1998)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1680</th>\n",
       "      <td>1681</td>\n",
       "      <td>You So Crazy (1994)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1681</th>\n",
       "      <td>1682</td>\n",
       "      <td>Scream of Stone (Schrei aus Stein) (1991)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      item_id                                      title\n",
       "1677     1678                          Mat' i syn (1997)\n",
       "1678     1679                           B. Monkey (1998)\n",
       "1679     1680                       Sliding Doors (1998)\n",
       "1680     1681                        You So Crazy (1994)\n",
       "1681     1682  Scream of Stone (Schrei aus Stein) (1991)"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movie_titles_df.tail(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "ee30379d",
   "metadata": {},
   "outputs": [],
   "source": [
    "movies_rating_df=pd.read_csv('u.data', sep = '\\t', names=['user_id','item_id','rating','timestamp'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "61dffbbd",
   "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>...</th>\n",
       "      <td>...</td>\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",
       "      <td>880175444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99999</th>\n",
       "      <td>716</td>\n",
       "      <td>204</td>\n",
       "      <td>5</td>\n",
       "      <td>879795543</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100000</th>\n",
       "      <td>276</td>\n",
       "      <td>1090</td>\n",
       "      <td>1</td>\n",
       "      <td>874795795</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100001</th>\n",
       "      <td>13</td>\n",
       "      <td>225</td>\n",
       "      <td>2</td>\n",
       "      <td>882399156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100002</th>\n",
       "      <td>12</td>\n",
       "      <td>203</td>\n",
       "      <td>3</td>\n",
       "      <td>879959583</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100003 rows × 4 columns</p>\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",
       "...         ...      ...     ...        ...\n",
       "99998       880      476       3  880175444\n",
       "99999       716      204       5  879795543\n",
       "100000      276     1090       1  874795795\n",
       "100001       13      225       2  882399156\n",
       "100002       12      203       3  879959583\n",
       "\n",
       "[100003 rows x 4 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_rating_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "61655546",
   "metadata": {},
   "outputs": [],
   "source": [
    "movies_rating_df.drop(['timestamp'],axis = 1,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "0d0a8a5a",
   "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": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_rating_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "1c97900d",
   "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": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_rating_df.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "12bc782c",
   "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": [
    "movies_rating_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "85d9f245",
   "metadata": {},
   "outputs": [],
   "source": [
    "movies_rating_df = pd.merge(movies_rating_df,movie_titles_df, on = 'item_id')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "b9daee15",
   "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": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_rating_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "d7332da1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(100003, 4)"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_rating_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "070501d6",
   "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": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_rating_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "df320aae",
   "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 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": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_rating_df.groupby('title').describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "a5c3d47f",
   "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": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_rating_df.groupby('title')['rating'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "f3d59b33",
   "metadata": {},
   "outputs": [],
   "source": [
    "ratings_df_mean=movies_rating_df.groupby('title')['rating'].describe()['mean']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "9c903f72",
   "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": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ratings_df_mean"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "15c4601b",
   "metadata": {},
   "outputs": [],
   "source": [
    "ratings_df_count=movies_rating_df.groupby('title')['rating'].describe()['count']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "4821e0e7",
   "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": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ratings_df_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "fc9fdfa8",
   "metadata": {},
   "outputs": [],
   "source": [
    "ratings_mean_count_df = pd.concat([ratings_df_count, ratings_df_mean],axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "ea1eb516",
   "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": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ratings_mean_count_df "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "e4836f53",
   "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": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ratings_mean_count_df.reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "7ebb9b9f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:ylabel='Frequency'>"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAjsAAAGdCAYAAAD0e7I1AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8qNh9FAAAACXBIWXMAAA9hAAAPYQGoP6dpAAAn80lEQVR4nO3df3RU5Z3H8c9IyJCwycgPmcksEaMGrQRZBEtBFGgkblEUOa2wqFCle3BBJAIFUrcremwi2E1tmyNK6wG0RdqqsXZXt0kVQpF6SiCIZFugkkKQTFNrdhICJCG5+wfLLJMfkEwmmXsf3q9z7jnOnWduvk+eMPPxee6947IsyxIAAIChLot1AQAAAD2JsAMAAIxG2AEAAEYj7AAAAKMRdgAAgNEIOwAAwGiEHQAAYDTCDgAAMFpcrAuwg5aWFh0/flxJSUlyuVyxLgcAAHSCZVmqq6uT3+/XZZd1PH9D2JF0/PhxpaamxroMAAAQgcrKSg0dOrTD5wk7kpKSkiSd/WUlJyfHuBoAANAZtbW1Sk1NDX2Od4SwI4WWrpKTkwk7AAA4zMVOQeEEZQAAYLSYhp3t27dr+vTp8vv9crlceuutt0LPNTU1aeXKlRo5cqT69+8vv9+vuXPn6vjx42HHaGho0OLFizV48GD1799fd999t44dO9bLPQEAAHYV07BTX1+vUaNGqaCgoM1zJ0+e1J49e/Ttb39be/bs0ZtvvqmDBw/q7rvvDmuXnZ2twsJCbdmyRTt27NCJEyd01113qbm5ube6AQAAbMxlWZYV6yKks+tthYWFmjFjRodtdu3apS9+8Ys6cuSIrrzySgWDQV1xxRV69dVXNWvWLEn/f2XVO++8ozvuuKNTP7u2tlYej0fBYJBzdgAAcIjOfn476pydYDAol8ulyy+/XJK0e/duNTU1KSsrK9TG7/crIyNDO3fu7PA4DQ0Nqq2tDdsAAICZHBN2Tp8+rVWrVmnOnDmh9BYIBBQfH68BAwaEtfV6vQoEAh0eKy8vTx6PJ7Rxjx0AAMzliLDT1NSk2bNnq6WlRS+88MJF21uWdcHL0HJychQMBkNbZWVlNMsFAAA2Yvuw09TUpPvuu08VFRUqLi4OW5Pz+XxqbGxUTU1N2Guqq6vl9Xo7PKbb7Q7dU4d76wAAYDZbh51zQefQoUP6zW9+o0GDBoU9P2bMGPXt21fFxcWhfVVVVdq/f78mTJjQ2+UCAAAbiukdlE+cOKE//elPoccVFRXau3evBg4cKL/fr69+9avas2eP/uM//kPNzc2h83AGDhyo+Ph4eTwezZ8/X8uWLdOgQYM0cOBALV++XCNHjtTtt98eq24BAAAbieml59u2bdOUKVPa7J83b55Wr16ttLS0dl+3detWTZ48WdLZE5e/+c1vavPmzTp16pQyMzP1wgsvdOmkYy49BwDAeTr7+W2b++zEEmEHAADnMfI+OwAAAF1F2AEAAEaL6QnKANArWt93i9V74JLCzA4AADAaYQcAABiNsAMAAIxG2AEAAEYj7AAAAKMRdgAAgNEIOwAAwGiEHQAAYDTCDgAAMBphBwAAGI2wAwAAjEbYAQAARiPsAAAAoxF2AACA0Qg7AADAaIQdAABgNMIOAAAwGmEHAAAYjbADAACMRtgBAABGI+wAAACjEXYAAIDRCDsAAMBohB0AAGA0wg4AADAaYQcAABiNsAMAAIxG2AEAAEYj7AAAAKMRdgAAgNEIOwAAwGiEHQAAYDTCDgAAMBphBwAAGI2wAwAAjEbYAQAARiPsAAAAoxF2AACA0Qg7AADAaIQdAABgNMIOAAAwGmEHAAAYjbADAACMRtgBAABGI+wAAACjEXYAAIDRYhp2tm/frunTp8vv98vlcumtt94Ke96yLK1evVp+v18JCQmaPHmyysvLw9o0NDRo8eLFGjx4sPr376+7775bx44d68VeAAAAO4tp2Kmvr9eoUaNUUFDQ7vNr165Vfn6+CgoKtGvXLvl8Pk2dOlV1dXWhNtnZ2SosLNSWLVu0Y8cOnThxQnfddZeam5t7qxsAAMDGXJZlWbEuQpJcLpcKCws1Y8YMSWdndfx+v7Kzs7Vy5UpJZ2dxvF6v1qxZowULFigYDOqKK67Qq6++qlmzZkmSjh8/rtTUVL3zzju64447OvWza2tr5fF4FAwGlZyc3CP9AxBDLlf4Y3u87QHops5+ftv2nJ2KigoFAgFlZWWF9rndbk2aNEk7d+6UJO3evVtNTU1hbfx+vzIyMkJt2tPQ0KDa2tqwDQAAmMm2YScQCEiSvF5v2H6v1xt6LhAIKD4+XgMGDOiwTXvy8vLk8XhCW2pqapSrBwAAdmHbsHOOq9X0s2VZbfa1drE2OTk5CgaDoa2ysjIqtQIAAPuxbdjx+XyS1GaGprq6OjTb4/P51NjYqJqamg7btMftdis5OTlsAwAAZrJt2ElLS5PP51NxcXFoX2Njo0pKSjRhwgRJ0pgxY9S3b9+wNlVVVdq/f3+oDQAAuLTFxfKHnzhxQn/6059CjysqKrR3714NHDhQV155pbKzs5Wbm6v09HSlp6crNzdXiYmJmjNnjiTJ4/Fo/vz5WrZsmQYNGqSBAwdq+fLlGjlypG6//fZYdQsAANhITMNOaWmppkyZEnq8dOlSSdK8efO0ceNGrVixQqdOndLChQtVU1OjcePGqaioSElJSaHXfO9731NcXJzuu+8+nTp1SpmZmdq4caP69OnT6/0BAAD2Y5v77MQS99kBDMd9dgAjOf4+OwAAANFA2AEAAEYj7AAAAKMRdgAAgNEIOwAAwGiEHQAAYDTCDgAAMBphBwAAGI2wAwAAjEbYAQAARiPsAAAAoxF2AACA0Qg7AADAaIQdAABgNMIOAAAwGmEHAAAYjbADAACMRtgBAABGI+wAAACjEXYAAIDRCDsAAMBohB0AAGA0wg4AADAaYQcAABiNsAMAAIxG2AEAAEYj7AAAAKMRdgAAgNEIOwAAwGiEHQAAYDTCDgAAMBphBwAAGI2wAwAAjEbYAQAARiPsAAAAoxF2AACA0Qg7AADAaIQdAABgNMIOAAAwGmEHAAAYjbADAACMRtgBAABGI+wAAACjEXYAAIDRCDsAAMBohB0AAGA0wg4AADAaYQcAABiNsAMAAIxm67Bz5swZ/eu//qvS0tKUkJCgq6++Wk8//bRaWlpCbSzL0urVq+X3+5WQkKDJkyervLw8hlUDAAA7sXXYWbNmjV588UUVFBToD3/4g9auXavnnntOP/zhD0Nt1q5dq/z8fBUUFGjXrl3y+XyaOnWq6urqYlg5AACwC1uHnd/97ne65557dOedd+qqq67SV7/6VWVlZam0tFTS2Vmd559/Xk888YRmzpypjIwMbdq0SSdPntTmzZtjXD0AALADW4ediRMn6r333tPBgwclSR999JF27NihadOmSZIqKioUCASUlZUVeo3b7dakSZO0c+fOmNQMAADsJS7WBVzIypUrFQwGdf3116tPnz5qbm7Wd77zHf3TP/2TJCkQCEiSvF5v2Ou8Xq+OHDnS4XEbGhrU0NAQelxbW9sD1QMAADuw9czOz372M/3kJz/R5s2btWfPHm3atEnf/e53tWnTprB2Lpcr7LFlWW32nS8vL08ejye0paam9kj9AAAg9mwddr75zW9q1apVmj17tkaOHKkHH3xQjz/+uPLy8iRJPp9P0v/P8JxTXV3dZrbnfDk5OQoGg6GtsrKy5zoBAABiytZh5+TJk7rssvAS+/TpE7r0PC0tTT6fT8XFxaHnGxsbVVJSogkTJnR4XLfbreTk5LANAACYydbn7EyfPl3f+c53dOWVV2rEiBEqKytTfn6+Hn74YUlnl6+ys7OVm5ur9PR0paenKzc3V4mJiZozZ06MqwcAAHZg67Dzwx/+UN/+9re1cOFCVVdXy+/3a8GCBfq3f/u3UJsVK1bo1KlTWrhwoWpqajRu3DgVFRUpKSkphpUDAAC7cFmWZcW6iFirra2Vx+NRMBhkSQswUesLFnjbA4zQ2c9vW5+zAwAA0F2EHQAAYDTCDgAAMBphBwAAGI2wAwAAjEbYAQAARiPsAAAAoxF2AACA0Qg7AADAaIQdAABgNMIOAAAwGmEHAAAYjbADAACMRtgBAABGI+wAAACjEXYAAIDRCDsAAMBoEYWdioqKaNcBAADQIyIKO9dee62mTJmin/zkJzp9+nS0awIAAIiaiMLORx99pNGjR2vZsmXy+XxasGCBfv/730e7NgAAgG6LKOxkZGQoPz9fn376qTZs2KBAIKCJEydqxIgRys/P11//+tdo1wkAABCRbp2gHBcXp3vvvVc///nPtWbNGn3yySdavny5hg4dqrlz56qqqipadQIAAESkW2GntLRUCxcuVEpKivLz87V8+XJ98sknev/99/Xpp5/qnnvuiVadAAAAEYmL5EX5+fnasGGDDhw4oGnTpumVV17RtGnTdNllZ7NTWlqaXnrpJV1//fVRLRYAAKCrIgo769at08MPP6yHHnpIPp+v3TZXXnmlXn755W4VBwAA0F0uy7KsWBcRa7W1tfJ4PAoGg0pOTo51OQCizeUKf8zbHmCEzn5+R3TOzoYNG/SLX/yizf5f/OIX2rRpUySHBAAA6BERhZ1nn31WgwcPbrN/yJAhys3N7XZRRnG52m4AAKDXRBR2jhw5orS0tDb7hw0bpqNHj3a7KAAAgGiJKOwMGTJE+/bta7P/o48+0qBBg7pdFAAAQLREFHZmz56txx57TFu3blVzc7Oam5v1/vvva8mSJZo9e3a0awQAAIhYRJeeP/PMMzpy5IgyMzMVF3f2EC0tLZo7dy7n7AAAAFvp1qXnBw8e1EcffaSEhASNHDlSw4YNi2ZtvaZHLz1v74RkLnsFeheXngNG6uznd0QzO+cMHz5cw4cP784hAAAAelREYae5uVkbN27Ue++9p+rqarW0tIQ9//7770elOAAAgO6KKOwsWbJEGzdu1J133qmMjAy5uHcMAACwqYjCzpYtW/Tzn/9c06ZNi3Y9AAAAURXRpefx8fG69tpro10LAABA1EUUdpYtW6bvf//74jtEAQCA3UW0jLVjxw5t3bpV7777rkaMGKG+ffuGPf/mm29GpTgAAIDuiijsXH755br33nujXQsAAEDURRR2NmzYEO06AAAAekRE5+xI0pkzZ/Sb3/xGL730kurq6iRJx48f14kTJ6JWHAAAQHdFNLNz5MgR/eM//qOOHj2qhoYGTZ06VUlJSVq7dq1Onz6tF198Mdp1AgAARCSimZ0lS5Zo7NixqqmpUUJCQmj/vffeq/feey9qxQEAAHRXxFdjffDBB4qPjw/bP2zYMH366adRKQwAACAaIprZaWlpUXNzc5v9x44dU1JSUreLAgAAiJaIws7UqVP1/PPPhx67XC6dOHFCTz75JF8hAQAAbMVlRXAb5OPHj2vKlCnq06ePDh06pLFjx+rQoUMaPHiwtm/friFDhvRErT2mtrZWHo9HwWBQycnJ0T14e1+Syp2ngd7V+t8h/wYBI3T28zuic3b8fr/27t2r1157TXv27FFLS4vmz5+v+++/P+yEZQAAgFiL+D47CQkJevjhh1VQUKAXXnhB3/jGN3ok6Hz66ad64IEHNGjQICUmJuof/uEftHv37tDzlmVp9erV8vv9SkhI0OTJk1VeXh71OgAAgDNFNLPzyiuvXPD5uXPnRlRMazU1Nbrllls0ZcoUvfvuuxoyZIg++eQTXX755aE2a9euVX5+vjZu3Kjhw4frmWee0dSpU3XgwAFOlgYAAJGdszNgwICwx01NTTp58qTi4+OVmJiozz//PCrFrVq1Sh988IF++9vftvu8ZVny+/3Kzs7WypUrJUkNDQ3yer1as2aNFixY0Kmfwzk7gOE4ZwcwUmc/vyNaxqqpqQnbTpw4oQMHDmjixIl67bXXIi66tbfffltjx47V1772NQ0ZMkSjR4/Wj370o9DzFRUVCgQCysrKCu1zu92aNGmSdu7c2eFxGxoaVFtbG7YBAAAzRXzOTmvp6el69tlntWTJkmgdUocPH9a6deuUnp6uX//613rkkUf02GOPhZbRAoGAJMnr9Ya9zuv1hp5rT15enjweT2hLTU2NWs0AAMBeohZ2JKlPnz46fvx41I7X0tKim266Sbm5uRo9erQWLFigf/7nf9a6devC2rlaTVFbltVm3/lycnIUDAZDW2VlZdRqBgAA9hLRCcpvv/122GPLslRVVaWCggLdcsstUSlMklJSUnTDDTeE7fvCF76gN954Q5Lk8/kknZ3hSUlJCbWprq5uM9tzPrfbLbfbHbU6AQCAfUUUdmbMmBH22OVy6YorrtCXv/xl/fu//3s06pIk3XLLLTpw4EDYvoMHD2rYsGGSpLS0NPl8PhUXF2v06NGSpMbGRpWUlGjNmjVRqwMAADhXRGGnpaUl2nW06/HHH9eECROUm5ur++67T7///e+1fv16rV+/XtLZkJWdna3c3Fylp6crPT1dubm5SkxM1Jw5c3qlRgAAYG8RhZ3ecvPNN6uwsFA5OTl6+umnlZaWpueff173339/qM2KFSt06tQpLVy4UDU1NRo3bpyKioq4xw4AAJAU4X12li5d2um2+fn5XT18r+M+O4DhuM+O8zGGaEePfjdWWVmZ9uzZozNnzui6666TdPZcmj59+uimm24KtbvQFVEAAAC9IaKwM336dCUlJWnTpk2huynX1NTooYce0q233qply5ZFtUgAAIBIRbSM9fd///cqKirSiBEjwvbv379fWVlZUb3XTm9gGQswHEsgzscYoh09+nURtbW1+stf/tJmf3V1terq6iI5JAAAQI+IKOzce++9euihh/T666/r2LFjOnbsmF5//XXNnz9fM2fOjHaNAAAAEYvonJ0XX3xRy5cv1wMPPKCmpqazB4qL0/z58/Xcc89FtUAAAIDuiOicnXPq6+v1ySefyLIsXXvtterfv380a+s1nLMDGI7zPZyPMUQ7evScnXOqqqpUVVWl4cOHq3///upGbgIAAOgREYWdv/3tb8rMzNTw4cM1bdo0VVVVSZK+8Y1vcNk5AACwlYjCzuOPP66+ffvq6NGjSkxMDO2fNWuW/uu//itqxQEAAHRXRCcoFxUV6de//rWGDh0atj89PV1HjhyJSmEAAADRENHMTn19fdiMzjmfffaZ3G53t4sCAACIlojCzm233aZXXnkl9NjlcqmlpUXPPfecpkyZErXiAAAAuiuiZaznnntOkydPVmlpqRobG7VixQqVl5fr888/1wcffBDtGgEAACIW0czODTfcoH379umLX/yipk6dqvr6es2cOVNlZWW65pprol0jEFsuV9sNAOAYXZ7ZaWpqUlZWll566SU99dRTPVETAABA1HR5Zqdv377av3+/XPzfLQAAcICIlrHmzp2rl19+Odq1AAAARF1EJyg3Njbqxz/+sYqLizV27Ng234mVn58fleIAAAC6q0th5/Dhw7rqqqu0f/9+3XTTTZKkgwcPhrVheQsAANhJl8JOenq6qqqqtHXrVklnvx7iBz/4gbxeb48UBwAA0F1dOmen9beav/vuu6qvr49qQQAAANEU0QnK57QOPwAAAHbTpbDjcrnanJPDOToAAMDOunTOjmVZ+vrXvx76ss/Tp0/rkUceaXM11ptvvhm9CgEAALqhS2Fn3rx5YY8feOCBqBYDAAAQbV0KOxs2bOipOgAAAHpEt05QBgAAsDvCDgAAMBphBwAAGI2wAwAAjEbYAQAARiPsAAAAoxF2AACA0Qg7AADAaIQdAABgNMIOAAAwGmEHAAAYjbADAACMRtgBAABGI+wAAACjEXYAAIDRCDsAAMBohB0AAGC0uFgXAACO5XK13WdZvV8HgAtiZgcAABiNsAMAAIxG2AEAAEYj7AAAAKM5Kuzk5eXJ5XIpOzs7tM+yLK1evVp+v18JCQmaPHmyysvLY1ckAACwFceEnV27dmn9+vW68cYbw/avXbtW+fn5Kigo0K5du+Tz+TR16lTV1dXFqFIAcBiXq+0GGMQRYefEiRO6//779aMf/UgDBgwI7bcsS88//7yeeOIJzZw5UxkZGdq0aZNOnjypzZs3x7BiAABgF44IO4sWLdKdd96p22+/PWx/RUWFAoGAsrKyQvvcbrcmTZqknTt3dni8hoYG1dbWhm0AAMBMtr+p4JYtW7R7926Vlpa2eS4QCEiSvF5v2H6v16sjR450eMy8vDw99dRT0S0UcBpuiOc8nVleYgyBNmw9s1NZWaklS5bopz/9qfr169dhO1erNwDLstrsO19OTo6CwWBoq6ysjFrNAADAXmw9s7N7925VV1drzJgxoX3Nzc3avn27CgoKdODAAUlnZ3hSUlJCbaqrq9vM9pzP7XbL7Xb3XOEAAMA2bD2zk5mZqY8//lh79+4NbWPHjtX999+vvXv36uqrr5bP51NxcXHoNY2NjSopKdGECRNiWDkAALALW8/sJCUlKSMjI2xf//79NWjQoND+7Oxs5ebmKj09Xenp6crNzVViYqLmzJkTi5IBAIDN2DrsdMaKFSt06tQpLVy4UDU1NRo3bpyKioqUlJQU69IAAIANuCyLU/dra2vl8XgUDAaVnJwc3YNzxYvzmTqGdutXT9bT+tidOW5n6unt32FPXY1lt7+F9kQyhjBeZz+/bX3ODgAAQHcRdgAAgNEcf84OADiOKUsypvQDxmNmBwAAGI2wAwAAjMYyFgDYUWeuvALQKczsAAAAoxF2AACA0VjGAtDznHDTuksJS2S4xDCzAwAAjEbYAQAARmMZCwA6qzPLP5fyjfZYroRNMbMDAACMRtgBAABGI+wAAACjEXYAAIDRCDsAAMBoXI0FABI32gMMxswOAAAwGmEHAAAYjWUsADDJpXxTQ6ADzOwAAACjEXYAAIDRWMYCgJ7EVV5AzDGzAwAAjEbYAQAARmMZC0D3tLdMwxVAAGyEmR0AAGA0wg4AADAay1gAgLa4OSEMwswOAAAwGmEHAAAYjWUsADAZNzUEmNkBAABmI+wAAACjsYwFAIgtrvxCD2NmBwAAGI2wAwAAjMYyFgDg4riqCw7GzA4AADAaYQcAABiNZSwAQM/hSivYADM7AADAaIQdAABgNJaxAHRNZ67K4cqdruH3BfQoZnYAAIDRCDsAAMBoLGMBsK+eupKHZSPgksLMDgAAMJqtw05eXp5uvvlmJSUlaciQIZoxY4YOHDgQ1sayLK1evVp+v18JCQmaPHmyysvLY1QxAACwG1uHnZKSEi1atEgffvihiouLdebMGWVlZam+vj7UZu3atcrPz1dBQYF27doln8+nqVOnqq6uLoaVAzHmcrXdADvgbxMx4LIs59zO8q9//auGDBmikpIS3XbbbbIsS36/X9nZ2Vq5cqUkqaGhQV6vV2vWrNGCBQs6ddza2lp5PB4Fg0ElJydHt+j2/iE751cOyZlj2JmaI+1XtD6cOlPPxV7TWXygOkt748ydmNGOzn5+23pmp7VgMChJGjhwoCSpoqJCgUBAWVlZoTZut1uTJk3Szp07OzxOQ0ODamtrwzYAAGAmx4Qdy7K0dOlSTZw4URkZGZKkQCAgSfJ6vWFtvV5v6Ln25OXlyePxhLbU1NSeKxxA9LAEgnP4W0AXOCbsPProo9q3b59ee+21Ns+5Wv2RW5bVZt/5cnJyFAwGQ1tlZWXU6wUAAPbgiPvsLF68WG+//ba2b9+uoUOHhvb7fD5JZ2d4UlJSQvurq6vbzPacz+12y+1291zBAADANmw9s2NZlh599FG9+eabev/995WWlhb2fFpamnw+n4qLi0P7GhsbVVJSogkTJvR2uYC9MeUP4BJl65mdRYsWafPmzfrlL3+ppKSk0Hk4Ho9HCQkJcrlcys7OVm5urtLT05Wenq7c3FwlJiZqzpw5Ma4eAADYga3Dzrp16yRJkydPDtu/YcMGff3rX5ckrVixQqdOndLChQtVU1OjcePGqaioSElJSb1cLQAAsCNH3Wenp3CfHVxQb45htH5WpMtUdr/PTiTHjeax0TsiHUPeWy85Rt5nBwAAoKsIOwAAwGiEHQAAYDTCDgAAMBphBwAAGM3Wl54DaIcpV/hxhRQ6EunfBt+Mjg4wswMAAIxG2AEAAEZjGQtAx1hqgpOZsuSLbmNmBwAAGI2wAwAAjMYyFmAClpsAoEPM7AAAAKMRdgAAgNFYxgJiieUnAOhxzOwAAACjEXYAAIDRCDsAAMBohB0AAGA0wg4AADAaV2Mhcq2vJOI7Z8JF60qr3rxii6vDAN7bDMTMDgAAMBphBwAAGI1lLADApYMlqt5hs98zMzsAAMBohB0AAGA0lrEAmIUrygC0wswOAAAwGmEHAAAYjWUsmMNmZ/8DcACWPS8JzOwAAACjEXYAAIDRWMZC7LH8BMDO2lvq4n3KUZjZAQAARiPsAAAAo7GMBXMx9QwAEDM7AADAcIQdAABgNJax4Aw9dcUWS10AIhHJe1JnbmDI+0+PYGYHAAAYjbADAACMxjIWEA18vw4A2BYzOwAAwGiEHQAAYDSWsS5Fsfwuqlgv98T65wMAeh0zOwAAwGiEHQAAYDSWsUwTyyWqaHHCUpMTagTQe7hBqa0xswMAAIxmTNh54YUXlJaWpn79+mnMmDH67W9/G+uSAACADRgRdn72s58pOztbTzzxhMrKynTrrbfqK1/5io4ePRrr0qLH5Wq79ebrolU3AKB7In1fv4S5LMv5i4rjxo3TTTfdpHXr1oX2feELX9CMGTOUl5d30dfX1tbK4/EoGAwqOTk5usVFax23s8eJ5I++M8eJVpto6cmf1frYvJEAiEQk7yWRfqGo3T7Ke+n80c5+fjv+BOXGxkbt3r1bq1atCtuflZWlnTt3tvuahoYGNTQ0hB4Hg0FJZ39pvSJaP6c3jxOtNtHSkz+rN/sBwFyRvJdE+v5j9/etHqrv3Of2xeZtHB92PvvsMzU3N8vr9Ybt93q9CgQC7b4mLy9PTz31VJv9qampPVJjGx6P844TrTbR0pM/qzf7AcBckbyXRPr+Y/f3rR6ur66uTp4L/AzHh51zXK2mzCzLarPvnJycHC1dujT0uKWlRZ9//rkGDRrU4WsiUVtbq9TUVFVWVkZ/ecwmTO+j6f2TzO8j/XM+0/tI/yJnWZbq6urk9/sv2M7xYWfw4MHq06dPm1mc6urqNrM957jdbrnd7rB9l19+eU+VqOTkZCP/gM9neh9N759kfh/pn/OZ3kf6F5kLzeic4/irseLj4zVmzBgVFxeH7S8uLtaECRNiVBUAALALx8/sSNLSpUv14IMPauzYsRo/frzWr1+vo0eP6pFHHol1aQAAIMaMCDuzZs3S3/72Nz399NOqqqpSRkaG3nnnHQ0bNiymdbndbj355JNtlsxMYnofTe+fZH4f6Z/zmd5H+tfzjLjPDgAAQEccf84OAADAhRB2AACA0Qg7AADAaIQdAABgNMJON2zfvl3Tp0+X3++Xy+XSW2+9ddHXlJSUaMyYMerXr5+uvvpqvfjiiz1faIS62r9t27bJ5XK12f74xz/2TsFdlJeXp5tvvllJSUkaMmSIZsyYoQMHDlz0dU4Zw0j657QxXLdunW688cbQzcrGjx+vd99994Kvccr4SV3vn9PGr7W8vDy5XC5lZ2dfsJ2TxrC1zvTRSeO4evXqNnX6fL4LviYW40fY6Yb6+nqNGjVKBQUFnWpfUVGhadOm6dZbb1VZWZm+9a1v6bHHHtMbb7zRw5VGpqv9O+fAgQOqqqoKbenp6T1UYfeUlJRo0aJF+vDDD1VcXKwzZ84oKytL9fX1Hb7GSWMYSf/OccoYDh06VM8++6xKS0tVWlqqL3/5y7rnnntUXl7ebnsnjZ/U9f6d45TxO9+uXbu0fv163XjjjRds57QxPF9n+3iOU8ZxxIgRYXV+/PHHHbaN2fhZiApJVmFh4QXbrFixwrr++uvD9i1YsMD60pe+1IOVRUdn+rd161ZLklVTU9MrNUVbdXW1JckqKSnpsI2Tx7Az/XP6GFqWZQ0YMMD68Y9/3O5zTh6/cy7UP6eOX11dnZWenm4VFxdbkyZNspYsWdJhW6eOYVf66KRxfPLJJ61Ro0Z1un2sxo+ZnV70u9/9TllZWWH77rjjDpWWlqqpqSlGVUXf6NGjlZKSoszMTG3dujXW5XRaMBiUJA0cOLDDNk4ew8707xwnjmFzc7O2bNmi+vp6jR8/vt02Th6/zvTvHKeN36JFi3TnnXfq9ttvv2hbp45hV/p4jlPG8dChQ/L7/UpLS9Ps2bN1+PDhDtvGavyMuIOyUwQCgTZfTur1enXmzBl99tlnSklJiVFl0ZGSkqL169drzJgxamho0KuvvqrMzExt27ZNt912W6zLuyDLsrR06VJNnDhRGRkZHbZz6hh2tn9OHMOPP/5Y48eP1+nTp/V3f/d3Kiws1A033NBuWyeOX1f658Tx27Jli3bv3q3S0tJOtXfiGHa1j04ax3HjxumVV17R8OHD9Ze//EXPPPOMJkyYoPLycg0aNKhN+1iNH2Gnl7lcrrDH1v/dwLr1fie67rrrdN1114Uejx8/XpWVlfrud79ru3+grT366KPat2+fduzYcdG2ThzDzvbPiWN43XXXae/evfqf//kfvfHGG5o3b55KSko6DAROG7+u9M9p41dZWaklS5aoqKhI/fr16/TrnDSGkfTRSeP4la98JfTfI0eO1Pjx43XNNddo06ZNWrp0abuvicX4sYzVi3w+nwKBQNi+6upqxcXFtZuATfClL31Jhw4dinUZF7R48WK9/fbb2rp1q4YOHXrBtk4cw670rz12H8P4+Hhde+21Gjt2rPLy8jRq1Ch9//vfb7etE8evK/1rj53Hb/fu3aqurtaYMWMUFxenuLg4lZSU6Ac/+IHi4uLU3Nzc5jVOG8NI+tgeO4/j+fr376+RI0d2WGusxo+ZnV40fvx4/epXvwrbV1RUpLFjx6pv374xqqpnlZWV2XJaWTr7fxOLFy9WYWGhtm3bprS0tIu+xkljGEn/2mPnMWyPZVlqaGho9zknjV9HLtS/9th5/DIzM9tcufPQQw/p+uuv18qVK9WnT582r3HaGEbSx/bYeRzP19DQoD/84Q+69dZb230+ZuPXo6c/G66urs4qKyuzysrKLElWfn6+VVZWZh05csSyLMtatWqV9eCDD4baHz582EpMTLQef/xx67//+7+tl19+2erbt6/1+uuvx6oLF9TV/n3ve9+zCgsLrYMHD1r79++3Vq1aZUmy3njjjVh14YL+5V/+xfJ4PNa2bdusqqqq0Hby5MlQGyePYST9c9oY5uTkWNu3b7cqKiqsffv2Wd/61resyy67zCoqKrIsy9njZ1ld75/Txq89ra9UcvoYtudifXTSOC5btszatm2bdfjwYevDDz+07rrrLispKcn685//bFmWfcaPsNMN5y4PbL3NmzfPsizLmjdvnjVp0qSw12zbts0aPXq0FR8fb1111VXWunXrer/wTupq/9asWWNdc801Vr9+/awBAwZYEydOtP7zP/8zNsV3Qnt9k2Rt2LAh1MbJYxhJ/5w2hg8//LA1bNgwKz4+3rriiiuszMzMUBCwLGePn2V1vX9OG7/2tA4CTh/D9lysj04ax1mzZlkpKSlW3759Lb/fb82cOdMqLy8PPW+X8XNZ1v+dGQQAAGAgTlAGAABGI+wAAACjEXYAAIDRCDsAAMBohB0AAGA0wg4AADAaYQcAABiNsAMAAIxG2AEAAEYj7AAAAKMRdgAAgNEIOwAAwGj/C/IiQgpimlQeAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 640x480 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "ratings_mean_count_df['mean'].plot(bins = 100, kind='hist', color='r')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "01d19d9a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:ylabel='Frequency'>"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAj8AAAGdCAYAAAD9kBJPAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8qNh9FAAAACXBIWXMAAA9hAAAPYQGoP6dpAAAvEUlEQVR4nO3dfXBUVZ7/8U+bhzbEpCWEdKeXmIljcAYTWE0cJDI8E2QFBFzB8QmUskSEIQssDlhb4q5LEMugFis+jAWCD3F2BIdZAYkDxGEoV4ggCU4haoRE0kYxdCcYOxju7w+X+7OToEnbSXdz36+qW2Wfe/r29x6R/njuubdthmEYAgAAsIgLwl0AAABATyL8AAAASyH8AAAASyH8AAAASyH8AAAASyH8AAAASyH8AAAASyH8AAAAS4kNdwGR4MyZMzp+/LiSkpJks9nCXQ4AAOgEwzDU2Ngot9utCy7o/HwO4UfS8ePHlZGREe4yAABAEGpqatSvX79O9yf8SEpKSpL03eAlJyeHuRoAANAZPp9PGRkZ5vd4ZxF+JPNSV3JyMuEHAIAo09UlKyx4BgAAlkL4AQAAlkL4AQAAlkL4AQAAlkL4AQAAlkL4AQAAlkL4AQAAlkL4AQAAlkL4AQAAlkL4AQAAlkL4AQAAlkL4AQAAlkL4AQAAlkL4AQAAlhIb7gLOezZb+zbD6Pk6AACAJGZ+AACAxRB+AACApRB+AACApRB+AACApRB+AACApURM+CkuLpbNZlNRUZHZZhiGli1bJrfbrYSEBI0YMUKHDh0KeJ/f79e8efOUmpqqxMRETZo0SbW1tT1cPQAAiBYREX727t2rZ599VgMHDgxoX7lypUpKSrR69Wrt3btXLpdLY8eOVWNjo9mnqKhImzZtUmlpqXbv3q2mpiZNmDBBra2tPX0aAAAgCoQ9/DQ1NenWW2/Vc889p969e5vthmHo8ccf1wMPPKCpU6cqJydHL7zwgr7++mu9/PLLkiSv16vnn39ejz32mMaMGaMrr7xSL774oiorK/XWW2+F65QAAEAEC3v4ue+++3T99ddrzJgxAe3V1dXyeDwqLCw02+x2u4YPH649e/ZIkioqKnT69OmAPm63Wzk5OWafjvj9fvl8voANAABYQ1if8FxaWqqKigrt27ev3T6PxyNJcjqdAe1Op1NHjx41+8THxwfMGJ3tc/b9HSkuLtZDDz30U8sHAABRKGwzPzU1NZo/f75eeuklXXjhhefsZ2vz8xCGYbRra+vH+ixZskRer9fcampqulY8AACIWmELPxUVFaqvr1deXp5iY2MVGxur8vJyPfnkk4qNjTVnfNrO4NTX15v7XC6XWlpa1NDQcM4+HbHb7UpOTg7YAACANYQt/IwePVqVlZU6cOCAueXn5+vWW2/VgQMHdOmll8rlcqmsrMx8T0tLi8rLy1VQUCBJysvLU1xcXECfuro6VVVVmX0AAAC+L2xrfpKSkpSTkxPQlpiYqD59+pjtRUVFWr58ubKzs5Wdna3ly5erV69euuWWWyRJDodDs2bN0sKFC9WnTx+lpKRo0aJFys3NbbeAGgAAQArzgucfs3jxYjU3N2vOnDlqaGjQ4MGDtX37diUlJZl9Vq1apdjYWE2bNk3Nzc0aPXq01q1bp5iYmDBWDgAAIpXNMAwj3EWEm8/nk8PhkNfrDf36n44WXjPkAAD8ZMF+f4f9OT8AAAA9ifADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAsJazhZ82aNRo4cKCSk5OVnJysIUOGaOvWreb+mTNnymazBWzXXHNNwDH8fr/mzZun1NRUJSYmatKkSaqtre3pUwEAAFEirOGnX79+WrFihfbt26d9+/Zp1KhRuuGGG3To0CGzz3XXXae6ujpz27JlS8AxioqKtGnTJpWWlmr37t1qamrShAkT1Nra2tOnAwAAooDNMAwj3EV8X0pKih599FHNmjVLM2fO1MmTJ/X666932Nfr9apv377asGGDpk+fLkk6fvy4MjIytGXLFo0bN65Tn+nz+eRwOOT1epWcnByqU/mOzda+LbKGHACAqBTs93fErPlpbW1VaWmpTp06pSFDhpjtu3btUlpamvr376+7775b9fX15r6KigqdPn1ahYWFZpvb7VZOTo727NnTo/UDAIDoEBvuAiorKzVkyBB98803uuiii7Rp0yYNGDBAkjR+/HjddNNNyszMVHV1tf7t3/5No0aNUkVFhex2uzwej+Lj49W7d++AYzqdTnk8nnN+pt/vl9/vN1/7fL7uOTkAABBxwh5+Lr/8ch04cEAnT57Ua6+9phkzZqi8vFwDBgwwL2VJUk5OjvLz85WZmak33nhDU6dOPecxDcOQraPLTf+nuLhYDz30UEjPAwAARIewX/aKj4/XZZddpvz8fBUXF2vQoEF64oknOuybnp6uzMxMHTlyRJLkcrnU0tKihoaGgH719fVyOp3n/MwlS5bI6/WaW01NTehOCAAARLSwh5+2DMMIuCT1fSdOnFBNTY3S09MlSXl5eYqLi1NZWZnZp66uTlVVVSooKDjnZ9jtdvP2+rMbAACwhrBe9lq6dKnGjx+vjIwMNTY2qrS0VLt27dK2bdvU1NSkZcuW6cYbb1R6ero+/fRTLV26VKmpqZoyZYokyeFwaNasWVq4cKH69OmjlJQULVq0SLm5uRozZkw4Tw0AAESosIafzz//XLfffrvq6urkcDg0cOBAbdu2TWPHjlVzc7MqKyu1fv16nTx5Uunp6Ro5cqReffVVJSUlmcdYtWqVYmNjNW3aNDU3N2v06NFat26dYmJiwnhmAAAgUkXcc37Cgef8AAAQfaL+OT8AAAA9gfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAshfADAAAsJazhZ82aNRo4cKCSk5OVnJysIUOGaOvWreZ+wzC0bNkyud1uJSQkaMSIETp06FDAMfx+v+bNm6fU1FQlJiZq0qRJqq2t7elTAQAAUSKs4adfv35asWKF9u3bp3379mnUqFG64YYbzICzcuVKlZSUaPXq1dq7d69cLpfGjh2rxsZG8xhFRUXatGmTSktLtXv3bjU1NWnChAlqbW0N12kBAIAIZjMMwwh3Ed+XkpKiRx99VHfddZfcbreKiop0//33S/pulsfpdOqRRx7RPffcI6/Xq759+2rDhg2aPn26JOn48ePKyMjQli1bNG7cuE59ps/nk8PhkNfrVXJycmhPyGZr3xZZQw4AQFQK9vs7Ytb8tLa2qrS0VKdOndKQIUNUXV0tj8ejwsJCs4/dbtfw4cO1Z88eSVJFRYVOnz4d0MftdisnJ8fs0xG/3y+fzxewAQAAawh7+KmsrNRFF10ku92u2bNna9OmTRowYIA8Ho8kyel0BvR3Op3mPo/Ho/j4ePXu3fucfTpSXFwsh8NhbhkZGSE+KwAAEKnCHn4uv/xyHThwQO+8847uvfdezZgxQx988IG539bmspFhGO3a2vqxPkuWLJHX6zW3mpqan3YSAAAgaoQ9/MTHx+uyyy5Tfn6+iouLNWjQID3xxBNyuVyS1G4Gp76+3pwNcrlcamlpUUNDwzn7dMRut5t3mJ3dAACANYQ9/LRlGIb8fr+ysrLkcrlUVlZm7mtpaVF5ebkKCgokSXl5eYqLiwvoU1dXp6qqKrMPAADA98WG88OXLl2q8ePHKyMjQ42NjSotLdWuXbu0bds22Ww2FRUVafny5crOzlZ2draWL1+uXr166ZZbbpEkORwOzZo1SwsXLlSfPn2UkpKiRYsWKTc3V2PGjAnnqQEAgAgV1vDz+eef6/bbb1ddXZ0cDocGDhyobdu2aezYsZKkxYsXq7m5WXPmzFFDQ4MGDx6s7du3KykpyTzGqlWrFBsbq2nTpqm5uVmjR4/WunXrFBMTE67TAgAAESzinvMTDjznBwCA6BP1z/kBAADoCYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKWENP8XFxbr66quVlJSktLQ0TZ48WYcPHw7oM3PmTNlstoDtmmuuCejj9/s1b948paamKjExUZMmTVJtbW1PngoAAIgSQYWf6urqkHx4eXm57rvvPr3zzjsqKyvTt99+q8LCQp06dSqg33XXXae6ujpz27JlS8D+oqIibdq0SaWlpdq9e7eampo0YcIEtba2hqROAABw/rAZhmF09U0xMTEaNmyYZs2apX/+53/WhRdeGJJivvjiC6Wlpam8vFzDhg2T9N3Mz8mTJ/X66693+B6v16u+fftqw4YNmj59uiTp+PHjysjI0JYtWzRu3Lgf/VyfzyeHwyGv16vk5OSQnIvJZmvf1vUhBwAAbQT7/R3UzM/777+vK6+8UgsXLpTL5dI999yjd999N5hDBfB6vZKklJSUgPZdu3YpLS1N/fv319133636+npzX0VFhU6fPq3CwkKzze12KycnR3v27Onwc/x+v3w+X8AGAACsIajwk5OTo5KSEn322Wdau3atPB6Phg4dqiuuuEIlJSX64osvunxMwzC0YMECDR06VDk5OWb7+PHj9dJLL2nHjh167LHHtHfvXo0aNUp+v1+S5PF4FB8fr969ewccz+l0yuPxdPhZxcXFcjgc5paRkdHlegEAQHT6SQueY2NjNWXKFP3hD3/QI488oo8//liLFi1Sv379dMcdd6iurq7Tx5o7d64OHjyoV155JaB9+vTpuv7665WTk6OJEydq69at+vDDD/XGG2/84PEMw5Cto0tOkpYsWSKv12tuNTU1na4TAABEt58Ufvbt26c5c+YoPT1dJSUlWrRokT7++GPt2LFDn332mW644YZOHWfevHnavHmzdu7cqX79+v1g3/T0dGVmZurIkSOSJJfLpZaWFjU0NAT0q6+vl9Pp7PAYdrtdycnJARsAALCGoMJPSUmJcnNzVVBQoOPHj2v9+vU6evSoHn74YWVlZenaa6/VM888o/fee+8Hj2MYhubOnauNGzdqx44dysrK+tHPPnHihGpqapSeni5JysvLU1xcnMrKysw+dXV1qqqqUkFBQTCnBwAAzmOxwbxpzZo1uuuuu3TnnXfK5XJ12OeSSy7R888//4PHue+++/Tyyy/rT3/6k5KSksw1Og6HQwkJCWpqatKyZct04403Kj09XZ9++qmWLl2q1NRUTZkyxew7a9YsLVy4UH369FFKSooWLVqk3NxcjRkzJpjTAwAA57GgbnUP2YefY03O2rVrNXPmTDU3N2vy5Mnav3+/Tp48qfT0dI0cOVL/8R//EbBI+ZtvvtG//uu/6uWXX1Zzc7NGjx6tp556qtMLmbnVHQCA6BPs93dQ4Wft2rW66KKLdNNNNwW0//d//7e+/vprzZgxo6uHDCvCDwAA0adHn/OzYsUKpaamtmtPS0vT8uXLgzkkAABAjwgq/Bw9erTDxcmZmZk6duzYTy4KAACguwQVftLS0nTw4MF27e+//7769Onzk4sCAADoLkGFn5tvvlm//e1vtXPnTrW2tqq1tVU7duzQ/PnzdfPNN4e6RgAAgJAJ6lb3hx9+WEePHtXo0aMVG/vdIc6cOaM77riDNT8AACCi/aRb3T/88EO9//77SkhIUG5urjIzM0NZW4/hbi8AAKJPsN/fQc38nNW/f3/179//pxwCAACgRwUVflpbW7Vu3Tr95S9/UX19vc6cOROwf8eOHSEpDgAAINSCCj/z58/XunXrzF9bP9eTmgEAACJNUOGntLRUf/jDH/RP//RPoa4HAACgWwV1q3t8fLwuu+yyUNcCAADQ7YIKPwsXLtQTTzyhMP4mKgAAQFCCuuy1e/du7dy5U1u3btUVV1yhuLi4gP0bN24MSXEAAAChFlT4ufjiizVlypRQ1wIAANDtggo/a9euDXUdAAAAPSKoNT+S9O233+qtt97SM888o8bGRknS8ePH1dTUFLLiAAAAQi2omZ+jR4/quuuu07Fjx+T3+zV27FglJSVp5cqV+uabb/T000+Huk4AAICQCGrmZ/78+crPz1dDQ4MSEhLM9ilTpugvf/lLyIoDAAAItaDv9vrb3/6m+Pj4gPbMzEx99tlnISkMAACgOwQ183PmzBm1tra2a6+trVVSUtJPLgoAAKC7BBV+xo4dq8cff9x8bbPZ1NTUpAcffJCfvAAAABHNZgTxmObjx49r5MiRiomJ0ZEjR5Sfn68jR44oNTVVb7/9ttLS0rqj1m7j8/nkcDjk9XqVnJwc2oN39KOvPBkbAICfLNjv76DW/Ljdbh04cECvvPKK3nvvPZ05c0azZs3SrbfeGrAAGgAAINIENfNzvmHmBwCA6NOjMz/r16//wf133HFHMIcFAADodkHN/PTu3Tvg9enTp/X1118rPj5evXr10ldffRWyAnsCMz8AAESfYL+/g7rbq6GhIWBramrS4cOHNXToUL3yyivBHBIAAKBHBP3bXm1lZ2drxYoVmj9/fqgOCQAAEHIhCz+SFBMTo+PHj4fykAAAACEV1ILnzZs3B7w2DEN1dXVavXq1rr322pAUBgAA0B2CCj+TJ08OeG2z2dS3b1+NGjVKjz32WCjqAgAA6BZBhZ8zZ86Eug4AAIAeEdI1P11VXFysq6++WklJSUpLS9PkyZN1+PDhgD6GYWjZsmVyu91KSEjQiBEjdOjQoYA+fr9f8+bNU2pqqhITEzVp0iTV1tb25KkAAIAoEdTMz4IFCzrdt6Sk5Jz7ysvLdd999+nqq6/Wt99+qwceeECFhYX64IMPlJiYKElauXKlSkpKtG7dOvXv318PP/ywxo4dq8OHD5u/IF9UVKQ///nPKi0tVZ8+fbRw4UJNmDBBFRUViomJCeYUAQDAeSqohxyOHDlS7733nr799ltdfvnlkqQPP/xQMTExuuqqq/7/wW027dixo9PH/eKLL5SWlqby8nINGzZMhmHI7XarqKhI999/v6TvZnmcTqceeeQR3XPPPfJ6verbt682bNig6dOnS/ruh1czMjK0ZcsWjRs37kc/l4ccAgAQfXr05y0mTpyopKQkvfDCC+bTnhsaGnTnnXfq17/+tRYuXBjMYeX1eiVJKSkpkqTq6mp5PB4VFhaafex2u4YPH649e/bonnvuUUVFhU6fPh3Qx+12KycnR3v27Okw/Pj9fvn9fvO1z+cLql4AABB9glrz89hjj6m4uDjgZy569+6thx9+OOi7vQzD0IIFCzR06FDl5ORIkjwejyTJ6XQG9HU6neY+j8ej+Pj4dj+58f0+bRUXF8vhcJhbRkZGUDUDAIDoE1T48fl8+vzzz9u119fXq7GxMahC5s6dq4MHD3b48xi2NpeODMNo19bWD/VZsmSJvF6vudXU1ARVMwAAiD5BhZ8pU6bozjvv1B//+EfV1taqtrZWf/zjHzVr1ixNnTq1y8ebN2+eNm/erJ07d6pfv35mu8vlkqR2Mzj19fXmbJDL5VJLS4saGhrO2actu92u5OTkgA0AAFhDUOHn6aef1vXXX6/bbrtNmZmZyszM1K233qrx48frqaee6vRxDMPQ3LlztXHjRu3YsUNZWVkB+7OysuRyuVRWVma2tbS0qLy8XAUFBZKkvLw8xcXFBfSpq6tTVVWV2QcAAOCsoO72OuvUqVP6+OOPZRiGLrvsMvP29M6aM2eOXn75Zf3pT38y7xqTJIfDoYSEBEnSI488ouLiYq1du1bZ2dlavny5du3aFXCr+7333qv/+Z//0bp165SSkqJFixbpxIkTnb7Vnbu9AACIPj16t9dZdXV1qqur07Bhw5SQkNCptTjft2bNGknSiBEjAtrXrl2rmTNnSpIWL16s5uZmzZkzRw0NDRo8eLC2b99uBh9JWrVqlWJjYzVt2jQ1Nzdr9OjRWrduHc/4AQAA7QQ183PixAlNmzZNO3fulM1m05EjR3TppZdq1qxZuvjii6Pu972Y+QEAIPoE+/0d1Jqff/mXf1FcXJyOHTumXr16me3Tp0/Xtm3bgjkkAABAjwjqstf27dv15ptvBtyZJUnZ2dk6evRoSAoDAADoDkGFn1OnTgXM+Jz15Zdfym63/+SiznttL4VxGQwAgB4T1GWvYcOGaf369eZrm82mM2fO6NFHH9XIkSNDVhwAAECoBTXz8+ijj2rEiBHat2+fWlpatHjxYh06dEhfffWV/va3v4W6RgAAgJAJauZnwIABOnjwoH71q19p7NixOnXqlKZOnar9+/fr5z//eahrBAAACJkuz/yc/QX1Z555Rg899FB31AQAANBtujzzExcXp6qqqi49zBAAACBSBHXZ64477tDzzz8f6loAAAC6XVALnltaWvT73/9eZWVlys/Pb/ebXiUlJSEpDgAAINS6FH4++eQT/exnP1NVVZWuuuoqSdKHH34Y0IfLYQAAIJJ1KfxkZ2errq5OO3fulPTdz1k8+eSTcjqd3VIcAABAqHVpzU/b30DdunWrTp06FdKCAAAAulNQC57PCuIH4QEAAMKqS+HHZrO1W9PDGh8AABBNurTmxzAMzZw50/zx0m+++UazZ89ud7fXxo0bQ1chAABACHUp/MyYMSPg9W233RbSYgAAALpbl8LP2rVru6sOAACAHvGTFjwDAABEG8IPAACwFMIPAACwFMIPAACwFMIPAACwFMIPAACwFMIPAACwFMIPAACwFMIPAACwFMIPAACwFMIPAACwFMIPAACwFMIPAACwFMIPAACwlLCGn7ffflsTJ06U2+2WzWbT66+/HrB/5syZstlsAds111wT0Mfv92vevHlKTU1VYmKiJk2apNra2h48CwAAEE3CGn5OnTqlQYMGafXq1efsc91116murs7ctmzZErC/qKhImzZtUmlpqXbv3q2mpiZNmDBBra2t3V0+AACIQrHh/PDx48dr/PjxP9jHbrfL5XJ1uM/r9er555/Xhg0bNGbMGEnSiy++qIyMDL311lsaN25cyGsGAADRLeLX/OzatUtpaWnq37+/7r77btXX15v7KioqdPr0aRUWFpptbrdbOTk52rNnzzmP6ff75fP5AjYAAGANER1+xo8fr5deekk7duzQY489pr1792rUqFHy+/2SJI/Ho/j4ePXu3TvgfU6nUx6P55zHLS4ulsPhMLeMjIxuPQ8AABA5wnrZ68dMnz7d/OecnBzl5+crMzNTb7zxhqZOnXrO9xmGIZvNds79S5Ys0YIFC8zXPp+PAAQAgEVE9MxPW+np6crMzNSRI0ckSS6XSy0tLWpoaAjoV19fL6fTec7j2O12JScnB2wAAMAaoir8nDhxQjU1NUpPT5ck5eXlKS4uTmVlZWafuro6VVVVqaCgIFxlAgCACBbWy15NTU366KOPzNfV1dU6cOCAUlJSlJKSomXLlunGG29Uenq6Pv30Uy1dulSpqamaMmWKJMnhcGjWrFlauHCh+vTpo5SUFC1atEi5ubnm3V8AAADfF9bws2/fPo0cOdJ8fXYdzowZM7RmzRpVVlZq/fr1OnnypNLT0zVy5Ei9+uqrSkpKMt+zatUqxcbGatq0aWpubtbo0aO1bt06xcTE9Pj5AACAyGczDMMIdxHh5vP55HA45PV6Q7/+5wcWXpv4VwAAQJcF+/0dVWt+AAAAfirCDwAAsBTCDwAAsBTCDwAAsBTCDwAAsBTCDwAAsBTCDwAAsBTCDwAAsBTCDwAAsBTCDwAAsBTCDwAAsBTCDwAAsBTCDwAAsBTCDwAAsBTCDwAAsBTCDwAAsBTCDwAAsBTCDwAAsBTCDwAAsBTCDwAAsBTCDwAAsBTCDwAAsBTCDwAAsBTCDwAAsJTYcBcASTZb+zbD6Pk6AACwAGZ+AACApRB+AACApRB+AACApRB+AACApRB+AACApRB+AACApYQ1/Lz99tuaOHGi3G63bDabXn/99YD9hmFo2bJlcrvdSkhI0IgRI3To0KGAPn6/X/PmzVNqaqoSExM1adIk1dbW9uBZAACAaBLW8HPq1CkNGjRIq1ev7nD/ypUrVVJSotWrV2vv3r1yuVwaO3asGhsbzT5FRUXatGmTSktLtXv3bjU1NWnChAlqbW3tqdMAAABRxGYYkfE0PZvNpk2bNmny5MmSvpv1cbvdKioq0v333y/pu1kep9OpRx55RPfcc4+8Xq/69u2rDRs2aPr06ZKk48ePKyMjQ1u2bNG4ceM69dk+n08Oh0Ner1fJycmhPrHg3hcZ/1oAAIhYwX5/R+yan+rqank8HhUWFpptdrtdw4cP1549eyRJFRUVOn36dEAft9utnJwcsw8AAMD3RezPW3g8HkmS0+kMaHc6nTp69KjZJz4+Xr17927X5+z7O+L3++X3+83XPp8vVGUDAIAIF7EzP2fZ2lw2MgyjXVtbP9anuLhYDofD3DIyMkJSKwAAiHwRG35cLpcktZvBqa+vN2eDXC6XWlpa1NDQcM4+HVmyZIm8Xq+51dTUhLh6AAAQqSI2/GRlZcnlcqmsrMxsa2lpUXl5uQoKCiRJeXl5iouLC+hTV1enqqoqs09H7Ha7kpOTAzYAAGANYV3z09TUpI8++sh8XV1drQMHDiglJUWXXHKJioqKtHz5cmVnZys7O1vLly9Xr169dMstt0iSHA6HZs2apYULF6pPnz5KSUnRokWLlJubqzFjxoTrtAAAQAQLa/jZt2+fRo4cab5esGCBJGnGjBlat26dFi9erObmZs2ZM0cNDQ0aPHiwtm/frqSkJPM9q1atUmxsrKZNm6bm5maNHj1a69atU0xMTI+fDwAAiHwR85yfcOI5PwAARJ/z7jk/AAAA3YHwAwAALIXwAwAALIXwAwAALIXwAwAALIXwAwAALIXwAwAALCVif9Xd8to+H4jn/gAAEBLM/AAAAEsh/AAAAEsh/AAAAEsh/AAAAEsh/AAAAEsh/AAAAEsh/AAAAEsh/AAAAEsh/AAAAEvhCc/Rou0TnyWe+gwAQBCY+QEAAJZC+AEAAJZC+AEAAJZC+AEAAJZC+AEAAJZC+AEAAJZC+AEAAJZC+AEAAJbCQw7PdzwcEQCAAMz8AAAASyH8AAAASyH8AAAAS2HNz/mmozU+AADAxMwPAACwlIgOP8uWLZPNZgvYXC6Xud8wDC1btkxut1sJCQkaMWKEDh06FMaKAQBApIvo8CNJV1xxherq6sytsrLS3Ldy5UqVlJRo9erV2rt3r1wul8aOHavGxsYwVgwAACJZxIef2NhYuVwuc+vbt6+k72Z9Hn/8cT3wwAOaOnWqcnJy9MILL+jrr7/Wyy+/HOaqAQBApIr48HPkyBG53W5lZWXp5ptv1ieffCJJqq6ulsfjUWFhodnXbrdr+PDh2rNnzw8e0+/3y+fzBWwAAMAaIjr8DB48WOvXr9ebb76p5557Th6PRwUFBTpx4oQ8Ho8kyel0BrzH6XSa+86luLhYDofD3DIyMrrtHLqVzdZ+AwAAPyiiw8/48eN14403Kjc3V2PGjNEbb7whSXrhhRfMPrY2X/iGYbRra2vJkiXyer3mVlNTE/riAQBARIro8NNWYmKicnNzdeTIEfOur7azPPX19e1mg9qy2+1KTk4O2AAAgDVEVfjx+/36+9//rvT0dGVlZcnlcqmsrMzc39LSovLychUUFISxSgAAEMki+gnPixYt0sSJE3XJJZeovr5eDz/8sHw+n2bMmCGbzaaioiItX75c2dnZys7O1vLly9WrVy/dcsst4S4dAABEqIgOP7W1tfrNb36jL7/8Un379tU111yjd955R5mZmZKkxYsXq7m5WXPmzFFDQ4MGDx6s7du3KykpKcyVAwCASGUzDMMIdxHh5vP55HA45PV6Q7/+JxruwOKPAAAgCgX7/R1Va34AAAB+KsIPAACwlIhe84Me0tGlubaXwjrTBwCAKMDMDwAAsBTCDwAAsBQue6Fj0XCXGgAAQWDmBwAAWArhBwAAWArhBwAAWArhBwAAWAoLnhE6PAsIABAFCD8IXjB3hPVkQCKMAQA6wGUvAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKYQfAABgKTznB92LX4cHAEQYwg/Cr21A6syDCHmAIQAgSIQfRB6CDQCgG7HmBwAAWAozPzh/RPr6Ima0ACAiEH6AH0NoAYDzCuEH1haqYENAAoCoQfgBwimYO92667N7+vMBIEwIP4gOkb6epyPRWDMAWADhBwgGwQYAohbhB9ZildDCJa1A4by8CCDiEH6AtsIZkDoTWqIh2BA2AEQwwg8Q6awyWwUAPeS8ecLzU089paysLF144YXKy8vTX//613CXBEQWmy1wC9VxOtoAIIKdF+Hn1VdfVVFRkR544AHt379fv/71rzV+/HgdO3Ys3KUBPeN8CDad+axQ1UNgAyzNZhjRfzF+8ODBuuqqq7RmzRqz7Ze//KUmT56s4uLiH32/z+eTw+GQ1+tVcnJyaIvjL1UgeKFa79SZ/w6DOU70//UJRLVgv7+jfs1PS0uLKioq9Lvf/S6gvbCwUHv27OnwPX6/X36/33zt9XolfTeIACJIZ0JLqP4Ho+1//w5Hz312R/7v76Uf1FGNbd/XmfPozno6c5y27+vMZ3Xm80N1nM7ozvGJRqH6d/Ejzn5vd3UeJ+rDz5dffqnW1lY5nc6AdqfTKY/H0+F7iouL9dBDD7Vrz8jI6JYaAUSBUIWEUAm2nu46j1AdtzPH6cnPCpVorLkndfN5NTY2ytGFz4j68HOWrc3/gRmG0a7trCVLlmjBggXm6zNnzuirr75Snz59zvmeYPh8PmVkZKimpib0l9POU4xZ1zFmwWHcuo4x6zrGLDidHTfDMNTY2Ci3292l40d9+ElNTVVMTEy7WZ76+vp2s0Fn2e122e32gLaLL764u0pUcnIyf+i7iDHrOsYsOIxb1zFmXceYBacz49aVGZ+zov5ur/j4eOXl5amsrCygvaysTAUFBWGqCgAARKqon/mRpAULFuj2229Xfn6+hgwZomeffVbHjh3T7Nmzw10aAACIMOdF+Jk+fbpOnDihf//3f1ddXZ1ycnK0ZcsWZWZmhrUuu92uBx98sN0lNpwbY9Z1jFlwGLeuY8y6jjELTneP23nxnB8AAIDOivo1PwAAAF1B+AEAAJZC+AEAAJZC+AEAAJZC+OkmTz31lLKysnThhRcqLy9Pf/3rX8NdUti8/fbbmjhxotxut2w2m15//fWA/YZhaNmyZXK73UpISNCIESN06NChgD5+v1/z5s1TamqqEhMTNWnSJNXW1vbgWfSs4uJiXX311UpKSlJaWpomT56sw4cPB/Rh3AKtWbNGAwcONB+KNmTIEG3dutXcz3j9uOLiYtlsNhUVFZltjFt7y5Ytk81mC9hcLpe5nzHr2GeffabbbrtNffr0Ua9evfSP//iPqqioMPf36LgZCLnS0lIjLi7OeO6554wPPvjAmD9/vpGYmGgcPXo03KWFxZYtW4wHHnjAeO211wxJxqZNmwL2r1ixwkhKSjJee+01o7Ky0pg+fbqRnp5u+Hw+s8/s2bONf/iHfzDKysqM9957zxg5cqQxaNAg49tvv+3hs+kZ48aNM9auXWtUVVUZBw4cMK6//nrjkksuMZqamsw+jFugzZs3G2+88YZx+PBh4/Dhw8bSpUuNuLg4o6qqyjAMxuvHvPvuu8bPfvYzY+DAgcb8+fPNdsatvQcffNC44oorjLq6OnOrr6839zNm7X311VdGZmamMXPmTON///d/jerqauOtt94yPvroI7NPT44b4acb/OpXvzJmz54d0PaLX/zC+N3vfhemiiJH2/Bz5swZw+VyGStWrDDbvvnmG8PhcBhPP/20YRiGcfLkSSMuLs4oLS01+3z22WfGBRdcYGzbtq3Hag+n+vp6Q5JRXl5uGAbj1lm9e/c2fv/73zNeP6KxsdHIzs42ysrKjOHDh5vhh3Hr2IMPPmgMGjSow32MWcfuv/9+Y+jQoefc39PjxmWvEGtpaVFFRYUKCwsD2gsLC7Vnz54wVRW5qqur5fF4AsbLbrdr+PDh5nhVVFTo9OnTAX3cbrdycnIsM6Zer1eSlJKSIolx+zGtra0qLS3VqVOnNGTIEMbrR9x33326/vrrNWbMmIB2xu3cjhw5IrfbraysLN1888365JNPJDFm57J582bl5+frpptuUlpamq688ko999xz5v6eHjfCT4h9+eWXam1tbfejqk6ns92Pr0LmmPzQeHk8HsXHx6t3797n7HM+MwxDCxYs0NChQ5WTkyOJcTuXyspKXXTRRbLb7Zo9e7Y2bdqkAQMGMF4/oLS0VBUVFSouLm63j3Hr2ODBg7V+/Xq9+eabeu655+TxeFRQUKATJ04wZufwySefaM2aNcrOztabb76p2bNn67e//a3Wr18vqef/rJ0XP28RiWw2W8BrwzDateH/C2a8rDKmc+fO1cGDB7V79+52+xi3QJdffrkOHDigkydP6rXXXtOMGTNUXl5u7me8AtXU1Gj+/Pnavn27LrzwwnP2Y9wCjR8/3vzn3NxcDRkyRD//+c/1wgsv6JprrpHEmLV15swZ5efna/ny5ZKkK6+8UocOHdKaNWt0xx13mP16atyY+Qmx1NRUxcTEtEuh9fX17RItZN4h8UPj5XK51NLSooaGhnP2OV/NmzdPmzdv1s6dO9WvXz+znXHrWHx8vC677DLl5+eruLhYgwYN0hNPPMF4nUNFRYXq6+uVl5en2NhYxcbGqry8XE8++aRiY2PN82bcflhiYqJyc3N15MgR/qydQ3p6ugYMGBDQ9stf/lLHjh2T1PN/pxF+Qiw+Pl55eXkqKysLaC8rK1NBQUGYqopcWVlZcrlcAePV0tKi8vJyc7zy8vIUFxcX0Keurk5VVVXn7ZgahqG5c+dq48aN2rFjh7KysgL2M26dYxiG/H4/43UOo0ePVmVlpQ4cOGBu+fn5uvXWW3XgwAFdeumljFsn+P1+/f3vf1d6ejp/1s7h2muvbfe4jg8//ND8AfIeH7cuLY9Gp5y91f355583PvjgA6OoqMhITEw0Pv3003CXFhaNjY3G/v37jf379xuSjJKSEmP//v3mrf8rVqwwHA6HsXHjRqOystL4zW9+0+Htjf369TPeeust47333jNGjRp1Xt8Weu+99xoOh8PYtWtXwO20X3/9tdmHcQu0ZMkS4+233zaqq6uNgwcPGkuXLjUuuOACY/v27YZhMF6d9f27vQyDcevIwoULjV27dhmffPKJ8c477xgTJkwwkpKSzL/jGbP23n33XSM2Ntb4z//8T+PIkSPGSy+9ZPTq1ct48cUXzT49OW6En27yX//1X0ZmZqYRHx9vXHXVVeYtyla0c+dOQ1K7bcaMGYZhfHeL44MPPmi4XC7Dbrcbw4YNMyorKwOO0dzcbMydO9dISUkxEhISjAkTJhjHjh0Lw9n0jI7GS5Kxdu1asw/jFuiuu+4y/5vr27evMXr0aDP4GAbj1Vltww/j1t7Z58/ExcUZbrfbmDp1qnHo0CFzP2PWsT//+c9GTk6OYbfbjV/84hfGs88+G7C/J8fNZhiG0bW5IgAAgOjFmh8AAGAphB8AAGAphB8AAGAphB8AAGAphB8AAGAphB8AAGAphB8AAGAphB8AAGAphB8AAGAphB8AAGAphB8AAGAphB8AAGAp/w8QgT4cdG4cPQAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 640x480 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "ratings_mean_count_df['count'].plot(bins = 100, kind='hist', color='r')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "a1f7d6e6",
   "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": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ratings_mean_count_df[ratings_mean_count_df['mean']==5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "119ef391",
   "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>Aladdin (1992)</th>\n",
       "      <td>219.0</td>\n",
       "      <td>3.812785</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Babe (1995)</th>\n",
       "      <td>219.0</td>\n",
       "      <td>3.995434</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Volcano (1997)</th>\n",
       "      <td>219.0</td>\n",
       "      <td>2.808219</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>To Kill a Mockingbird (1962)</th>\n",
       "      <td>219.0</td>\n",
       "      <td>4.292237</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Murder at 1600 (1997)</th>\n",
       "      <td>218.0</td>\n",
       "      <td>3.087156</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 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",
       "Aladdin (1992)                219.0  3.812785\n",
       "Babe (1995)                   219.0  3.995434\n",
       "Volcano (1997)                219.0  2.808219\n",
       "To Kill a Mockingbird (1962)  219.0  4.292237\n",
       "Murder at 1600 (1997)         218.0  3.087156\n",
       "\n",
       "[100 rows x 2 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ratings_mean_count_df.sort_values('count',ascending = False).head(100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "4a3fbe97",
   "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": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_rating_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "8d52382b",
   "metadata": {},
   "outputs": [],
   "source": [
    "userid_movietitle_matrix = movies_rating_df.pivot_table(index = 'user_id',columns='title',values = 'rating')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "abc78963",
   "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": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "userid_movietitle_matrix "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "54125069",
   "metadata": {},
   "outputs": [],
   "source": [
    "titanic = userid_movietitle_matrix ['Titanic (1997)']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "2e1ef09b",
   "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": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "titanic"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "671c0626",
   "metadata": {},
   "outputs": [],
   "source": [
    "starwars = userid_movietitle_matrix ['Star Wars (1977)']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "3bc911d5",
   "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": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "starwars"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "b0aa9742",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Divyanshi Garg\\anaconda3\\lib\\site-packages\\numpy\\lib\\function_base.py:2683: RuntimeWarning: Degrees of freedom <= 0 for slice\n",
      "  c = cov(x, y, rowvar, dtype=dtype)\n",
      "C:\\Users\\Divyanshi Garg\\anaconda3\\lib\\site-packages\\numpy\\lib\\function_base.py:2542: RuntimeWarning: divide by zero encountered in true_divide\n",
      "  c *= np.true_divide(1, fact)\n"
     ]
    }
   ],
   "source": [
    "titanic_correlations = pd.DataFrame(userid_movietitle_matrix.corrwith(titanic), columns = ['correlations']) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "63e903a5",
   "metadata": {},
   "outputs": [],
   "source": [
    "titanic_correlations = titanic_correlations.join(ratings_mean_count_df['count'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "7b0a00e9",
   "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": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "titanic_correlations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "97c7c49e",
   "metadata": {},
   "outputs": [],
   "source": [
    "titanic_correlations.dropna(inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "961a05ae",
   "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": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "titanic_correlations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "64fde303",
   "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": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "titanic_correlations.sort_values('correlations', ascending = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "822b7aab",
   "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",
       "  </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"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "titanic_correlations[titanic_correlations['count']>80].sort_values('correlations',ascending=False).head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "c41ed32e",
   "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": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "userid_movietitle_matrix"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "a0c7e6d5",
   "metadata": {},
   "outputs": [],
   "source": [
    "movie_correlations = userid_movietitle_matrix.corr(method = 'pearson')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "27ac15fb",
   "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>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.000000e+00</td>\n",
       "      <td>-0.500000</td>\n",
       "      <td>-0.500000</td>\n",
       "      <td>0.522233</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-4.264014e-01</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>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>-9.819805e-01</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>-0.944911</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>-1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>-0.049890</td>\n",
       "      <td>0.269191</td>\n",
       "      <td>0.048973</td>\n",
       "      <td>0.266928</td>\n",
       "      <td>-4.340657e-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.111111</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.158840</td>\n",
       "      <td>0.119234</td>\n",
       "      <td>0.680414</td>\n",
       "      <td>-4.875600e-17</td>\n",
       "      <td>0.707107</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12 Angry Men (1957)</th>\n",
       "      <td>-0.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-4.989024e-02</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.256625</td>\n",
       "      <td>0.274772</td>\n",
       "      <td>1.788483e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.457176</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.096546</td>\n",
       "      <td>0.068944</td>\n",
       "      <td>-0.361961</td>\n",
       "      <td>1.443376e-01</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187 (1997)</th>\n",
       "      <td>-0.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.691910e-01</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.596644</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-5.547002e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.866025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.455233</td>\n",
       "      <td>-0.500000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>4.753271e-01</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>6.804138e-01</td>\n",
       "      <td>-0.361961</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.132017</td>\n",
       "      <td>-0.518476</td>\n",
       "      <td>-1.547646e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.054554</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.355001</td>\n",
       "      <td>0.722460</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>8.660254e-01</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>-4.875600e-17</td>\n",
       "      <td>0.144338</td>\n",
       "      <td>0.475327</td>\n",
       "      <td>0.204926</td>\n",
       "      <td>0.623795</td>\n",
       "      <td>-3.417534e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.707107</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.413197</td>\n",
       "      <td>-0.019672</td>\n",
       "      <td>0.866025</td>\n",
       "      <td>1.000000e+00</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>7.071068e-01</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.000000e+00</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>1.000000</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>1.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.986027e-16</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>0.866025</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",
       "    </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)                                    1.0   \n",
       "1-900 (1994)                                                 NaN   \n",
       "101 Dalmatians (1996)                                       -1.0   \n",
       "12 Angry Men (1957)                                         -0.5   \n",
       "187 (1997)                                                  -0.5   \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          -1.000000e+00   \n",
       "1-900 (1994)                                    1.0                    NaN   \n",
       "101 Dalmatians (1996)                           NaN           1.000000e+00   \n",
       "12 Angry Men (1957)                             NaN          -4.989024e-02   \n",
       "187 (1997)                                      NaN           2.691910e-01   \n",
       "...                                             ...                    ...   \n",
       "Young Guns II (1990)                            NaN           6.804138e-01   \n",
       "Young Poisoner's Handbook, The (1995)           NaN          -4.875600e-17   \n",
       "Zeus and Roxanne (1997)                         NaN           7.071068e-01   \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)                        -0.500000   -0.500000   \n",
       "1-900 (1994)                                           NaN         NaN   \n",
       "101 Dalmatians (1996)                            -0.049890    0.269191   \n",
       "12 Angry Men (1957)                               1.000000    0.666667   \n",
       "187 (1997)                                        0.666667    1.000000   \n",
       "...                                                    ...         ...   \n",
       "Young Guns II (1990)                             -0.361961    0.500000   \n",
       "Young Poisoner's Handbook, The (1995)             0.144338    0.475327   \n",
       "Zeus and Roxanne (1997)                           1.000000         NaN   \n",
       "unknown                                           1.000000         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)                                 0.522233   \n",
       "1-900 (1994)                                                   NaN   \n",
       "101 Dalmatians (1996)                                     0.048973   \n",
       "12 Angry Men (1957)                                       0.256625   \n",
       "187 (1997)                                                0.596644   \n",
       "...                                                            ...   \n",
       "Young Guns II (1990)                                      0.132017   \n",
       "Young Poisoner's Handbook, The (1995)                     0.204926   \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)                                             0.266928   \n",
       "12 Angry Men (1957)                                               0.274772   \n",
       "187 (1997)                                                             NaN   \n",
       "...                                                                    ...   \n",
       "Young Guns II (1990)                                             -0.518476   \n",
       "Young Poisoner's Handbook, The (1995)                             0.623795   \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)                             -4.264014e-01   \n",
       "1-900 (1994)                                          -9.819805e-01   \n",
       "101 Dalmatians (1996)                                 -4.340657e-02   \n",
       "12 Angry Men (1957)                                    1.788483e-01   \n",
       "187 (1997)                                            -5.547002e-01   \n",
       "...                                                             ...   \n",
       "Young Guns II (1990)                                  -1.547646e-01   \n",
       "Young Poisoner's Handbook, The (1995)                 -3.417534e-01   \n",
       "Zeus and Roxanne (1997)                               -1.000000e+00   \n",
       "unknown                                               -1.986027e-16   \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)                              0.111111  ...   \n",
       "12 Angry Men (1957)                                0.457176  ...   \n",
       "187 (1997)                                         1.000000  ...   \n",
       "...                                                     ...  ...   \n",
       "Young Guns II (1990)                              -0.054554  ...   \n",
       "Young Poisoner's Handbook, The (1995)              0.707107  ...   \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)                                 -1.000000   \n",
       "12 Angry Men (1957)                                         NaN   \n",
       "187 (1997)                                             0.866025   \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)                                           -0.944911   \n",
       "101 Dalmatians (1996)                                   0.158840   \n",
       "12 Angry Men (1957)                                     0.096546   \n",
       "187 (1997)                                              0.455233   \n",
       "...                                                          ...   \n",
       "Young Guns II (1990)                                    0.355001   \n",
       "Young Poisoner's Handbook, The (1995)                  -0.413197   \n",
       "Zeus and Roxanne (1997)                                      NaN   \n",
       "unknown                                                 0.866025   \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)                           0.119234   \n",
       "12 Angry Men (1957)                             0.068944   \n",
       "187 (1997)                                     -0.500000   \n",
       "...                                                  ...   \n",
       "Young Guns II (1990)                            0.722460   \n",
       "Young Poisoner's Handbook, The (1995)          -0.019672   \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)                              0.680414   \n",
       "12 Angry Men (1957)                               -0.361961   \n",
       "187 (1997)                                         0.500000   \n",
       "...                                                     ...   \n",
       "Young Guns II (1990)                               1.000000   \n",
       "Young Poisoner's Handbook, The (1995)              0.866025   \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)                                          -4.875600e-17   \n",
       "12 Angry Men (1957)                                             1.443376e-01   \n",
       "187 (1997)                                                      4.753271e-01   \n",
       "...                                                                      ...   \n",
       "Young Guns II (1990)                                            8.660254e-01   \n",
       "Young Poisoner's Handbook, The (1995)                           1.000000e+00   \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)                                 0.707107      NaN   \n",
       "12 Angry Men (1957)                                   1.000000      1.0   \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)                               1.000000      NaN   \n",
       "unknown                                                    NaN      1.0   \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": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movie_correlations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "ad1c83a4",
   "metadata": {},
   "outputs": [],
   "source": [
    "myRatings = pd.read_csv('My_Ratings.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "604b57c0",
   "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>Liar Liar (1997)</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Star Wars (1977)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Movie Name  Ratings\n",
       "0  Liar Liar (1997)        5\n",
       "1  Star Wars (1977)        1"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "myRatings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "88281aa9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Liar Liar (1997)'"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "myRatings['Movie Name'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "b2eceeb4",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Divyanshi Garg\\AppData\\Local\\Temp\\ipykernel_52256\\2891736250.py:1: FutureWarning: 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",
      "  similar_movies_list = pd.Series()\n",
      "C:\\Users\\Divyanshi Garg\\AppData\\Local\\Temp\\ipykernel_52256\\2891736250.py:6: FutureWarning: The series.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  similar_movies_list = similar_movies_list.append(similar_movie)\n",
      "C:\\Users\\Divyanshi Garg\\AppData\\Local\\Temp\\ipykernel_52256\\2891736250.py:6: FutureWarning: The series.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  similar_movies_list = similar_movies_list.append(similar_movie)\n"
     ]
    }
   ],
   "source": [
    "similar_movies_list = pd.Series()\n",
    "\n",
    "for i in range(0,2):\n",
    "    similar_movie = movie_correlations[ myRatings[ 'Movie Name'][i]].dropna()\n",
    "    similar_movie=similar_movie.map(lambda x: x* myRatings ['Ratings'][i])\n",
    "    similar_movies_list = similar_movies_list.append(similar_movie)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "f0419bb8",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Liar Liar (1997)                        5.0\n",
      "Hearts and Minds (1996)                 5.0\n",
      "Journey of August King, The (1995)      5.0\n",
      "Machine, The (1994)                     5.0\n",
      "Frisk (1995)                            5.0\n",
      "Sliding Doors (1998)                    5.0\n",
      "Love and Death on Long Island (1997)    5.0\n",
      "For Ever Mozart (1996)                  5.0\n",
      "Wedding Gift, The (1994)                5.0\n",
      "To Live (Huozhe) (1994)                 5.0\n",
      "dtype: float64\n"
     ]
    }
   ],
   "source": [
    "similar_movies_list.sort_values(inplace = True, ascending = False)\n",
    "print(similar_movies_list.head(10))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6021748e",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}