recommendation.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "dca5fda6",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "import sklearn\n",
    "from sklearn.decomposition import TruncatedSVD"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "779ceb94",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead 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>movie_id</th>\n",
       "      <th>rating</th>\n",
       "      <th>timestamp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>196</td>\n",
       "      <td>242</td>\n",
       "      <td>3</td>\n",
       "      <td>881250949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>186</td>\n",
       "      <td>302</td>\n",
       "      <td>3</td>\n",
       "      <td>891717742</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>22</td>\n",
       "      <td>377</td>\n",
       "      <td>1</td>\n",
       "      <td>878887116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>244</td>\n",
       "      <td>51</td>\n",
       "      <td>2</td>\n",
       "      <td>880606923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>166</td>\n",
       "      <td>346</td>\n",
       "      <td>1</td>\n",
       "      <td>886397596</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   user_id  movie_id  rating  timestamp\n",
       "0      196       242       3  881250949\n",
       "1      186       302       3  891717742\n",
       "2       22       377       1  878887116\n",
       "3      244        51       2  880606923\n",
       "4      166       346       1  886397596"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "columns = ['user_id', 'movie_id', 'rating', 'timestamp']\n",
    "user_data = pd.read_csv('ml-100k/u.data', names=columns, sep='\\t');\n",
    "user_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "370a05c5",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>movie_id</th>\n",
       "      <th>movie title</th>\n",
       "      <th>release date</th>\n",
       "      <th>video release date</th>\n",
       "      <th>IMDb URL</th>\n",
       "      <th>unknown</th>\n",
       "      <th>Action</th>\n",
       "      <th>Adventure</th>\n",
       "      <th>Animation</th>\n",
       "      <th>Childrens</th>\n",
       "      <th>...</th>\n",
       "      <th>Fantasy</th>\n",
       "      <th>Film-Noir</th>\n",
       "      <th>Horror</th>\n",
       "      <th>Musical</th>\n",
       "      <th>Mystery</th>\n",
       "      <th>Romance</th>\n",
       "      <th>Sci-Fi</th>\n",
       "      <th>Thriller</th>\n",
       "      <th>War</th>\n",
       "      <th>Western</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Toy Story (1995)</td>\n",
       "      <td>01-Jan-1995</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://us.imdb.com/M/title-exact?Toy%20Story%2...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>GoldenEye (1995)</td>\n",
       "      <td>01-Jan-1995</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://us.imdb.com/M/title-exact?GoldenEye%20(...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Four Rooms (1995)</td>\n",
       "      <td>01-Jan-1995</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://us.imdb.com/M/title-exact?Four%20Rooms%...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Get Shorty (1995)</td>\n",
       "      <td>01-Jan-1995</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://us.imdb.com/M/title-exact?Get%20Shorty%...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Copycat (1995)</td>\n",
       "      <td>01-Jan-1995</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://us.imdb.com/M/title-exact?Copycat%20(1995)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   movie_id        movie title release date  video release date  \\\n",
       "0         1   Toy Story (1995)  01-Jan-1995                 NaN   \n",
       "1         2   GoldenEye (1995)  01-Jan-1995                 NaN   \n",
       "2         3  Four Rooms (1995)  01-Jan-1995                 NaN   \n",
       "3         4  Get Shorty (1995)  01-Jan-1995                 NaN   \n",
       "4         5     Copycat (1995)  01-Jan-1995                 NaN   \n",
       "\n",
       "                                            IMDb URL  unknown  Action  \\\n",
       "0  http://us.imdb.com/M/title-exact?Toy%20Story%2...        0       0   \n",
       "1  http://us.imdb.com/M/title-exact?GoldenEye%20(...        0       1   \n",
       "2  http://us.imdb.com/M/title-exact?Four%20Rooms%...        0       0   \n",
       "3  http://us.imdb.com/M/title-exact?Get%20Shorty%...        0       1   \n",
       "4  http://us.imdb.com/M/title-exact?Copycat%20(1995)        0       0   \n",
       "\n",
       "   Adventure  Animation  Childrens  ...  Fantasy  Film-Noir  Horror  Musical  \\\n",
       "0          0          1          1  ...        0          0       0        0   \n",
       "1          1          0          0  ...        0          0       0        0   \n",
       "2          0          0          0  ...        0          0       0        0   \n",
       "3          0          0          0  ...        0          0       0        0   \n",
       "4          0          0          0  ...        0          0       0        0   \n",
       "\n",
       "   Mystery  Romance  Sci-Fi  Thriller  War  Western  \n",
       "0        0        0       0         0    0        0  \n",
       "1        0        0       0         1    0        0  \n",
       "2        0        0       0         1    0        0  \n",
       "3        0        0       0         0    0        0  \n",
       "4        0        0       0         1    0        0  \n",
       "\n",
       "[5 rows x 24 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "columns = ['movie_id', 'movie title', 'release date', 'video release date', 'IMDb URL', 'unknown', 'Action', 'Adventure',\n",
    "          'Animation', 'Childrens', 'Comedy', 'Crime', 'Documentary', 'Drama', 'Fantasy', 'Film-Noir', 'Horror',\n",
    "          'Musical', 'Mystery', 'Romance', 'Sci-Fi', 'Thriller', 'War', 'Western']\n",
    "movie_data = pd.read_csv('ml-100k/u.item', sep='|', encoding='latin-1', names=columns)\n",
    "movie_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "1353c7ba",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead 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>movie_id</th>\n",
       "      <th>rating</th>\n",
       "      <th>timestamp</th>\n",
       "      <th>movie title</th>\n",
       "      <th>release date</th>\n",
       "      <th>video release date</th>\n",
       "      <th>IMDb URL</th>\n",
       "      <th>unknown</th>\n",
       "      <th>Action</th>\n",
       "      <th>...</th>\n",
       "      <th>Fantasy</th>\n",
       "      <th>Film-Noir</th>\n",
       "      <th>Horror</th>\n",
       "      <th>Musical</th>\n",
       "      <th>Mystery</th>\n",
       "      <th>Romance</th>\n",
       "      <th>Sci-Fi</th>\n",
       "      <th>Thriller</th>\n",
       "      <th>War</th>\n",
       "      <th>Western</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>196</td>\n",
       "      <td>242</td>\n",
       "      <td>3</td>\n",
       "      <td>881250949</td>\n",
       "      <td>Kolya (1996)</td>\n",
       "      <td>24-Jan-1997</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://us.imdb.com/M/title-exact?Kolya%20(1996)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>63</td>\n",
       "      <td>242</td>\n",
       "      <td>3</td>\n",
       "      <td>875747190</td>\n",
       "      <td>Kolya (1996)</td>\n",
       "      <td>24-Jan-1997</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://us.imdb.com/M/title-exact?Kolya%20(1996)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>226</td>\n",
       "      <td>242</td>\n",
       "      <td>5</td>\n",
       "      <td>883888671</td>\n",
       "      <td>Kolya (1996)</td>\n",
       "      <td>24-Jan-1997</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://us.imdb.com/M/title-exact?Kolya%20(1996)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>154</td>\n",
       "      <td>242</td>\n",
       "      <td>3</td>\n",
       "      <td>879138235</td>\n",
       "      <td>Kolya (1996)</td>\n",
       "      <td>24-Jan-1997</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://us.imdb.com/M/title-exact?Kolya%20(1996)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>306</td>\n",
       "      <td>242</td>\n",
       "      <td>5</td>\n",
       "      <td>876503793</td>\n",
       "      <td>Kolya (1996)</td>\n",
       "      <td>24-Jan-1997</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://us.imdb.com/M/title-exact?Kolya%20(1996)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>296</td>\n",
       "      <td>242</td>\n",
       "      <td>4</td>\n",
       "      <td>884196057</td>\n",
       "      <td>Kolya (1996)</td>\n",
       "      <td>24-Jan-1997</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://us.imdb.com/M/title-exact?Kolya%20(1996)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>34</td>\n",
       "      <td>242</td>\n",
       "      <td>5</td>\n",
       "      <td>888601628</td>\n",
       "      <td>Kolya (1996)</td>\n",
       "      <td>24-Jan-1997</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://us.imdb.com/M/title-exact?Kolya%20(1996)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>271</td>\n",
       "      <td>242</td>\n",
       "      <td>4</td>\n",
       "      <td>885844495</td>\n",
       "      <td>Kolya (1996)</td>\n",
       "      <td>24-Jan-1997</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://us.imdb.com/M/title-exact?Kolya%20(1996)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>201</td>\n",
       "      <td>242</td>\n",
       "      <td>4</td>\n",
       "      <td>884110598</td>\n",
       "      <td>Kolya (1996)</td>\n",
       "      <td>24-Jan-1997</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://us.imdb.com/M/title-exact?Kolya%20(1996)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>209</td>\n",
       "      <td>242</td>\n",
       "      <td>4</td>\n",
       "      <td>883589606</td>\n",
       "      <td>Kolya (1996)</td>\n",
       "      <td>24-Jan-1997</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://us.imdb.com/M/title-exact?Kolya%20(1996)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>35</td>\n",
       "      <td>242</td>\n",
       "      <td>2</td>\n",
       "      <td>875459166</td>\n",
       "      <td>Kolya (1996)</td>\n",
       "      <td>24-Jan-1997</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://us.imdb.com/M/title-exact?Kolya%20(1996)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>354</td>\n",
       "      <td>242</td>\n",
       "      <td>5</td>\n",
       "      <td>891180399</td>\n",
       "      <td>Kolya (1996)</td>\n",
       "      <td>24-Jan-1997</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://us.imdb.com/M/title-exact?Kolya%20(1996)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>199</td>\n",
       "      <td>242</td>\n",
       "      <td>5</td>\n",
       "      <td>883782485</td>\n",
       "      <td>Kolya (1996)</td>\n",
       "      <td>24-Jan-1997</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://us.imdb.com/M/title-exact?Kolya%20(1996)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>113</td>\n",
       "      <td>242</td>\n",
       "      <td>2</td>\n",
       "      <td>875075887</td>\n",
       "      <td>Kolya (1996)</td>\n",
       "      <td>24-Jan-1997</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://us.imdb.com/M/title-exact?Kolya%20(1996)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1</td>\n",
       "      <td>242</td>\n",
       "      <td>5</td>\n",
       "      <td>889751633</td>\n",
       "      <td>Kolya (1996)</td>\n",
       "      <td>24-Jan-1997</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://us.imdb.com/M/title-exact?Kolya%20(1996)</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>15 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    user_id  movie_id  rating  timestamp   movie title release date  \\\n",
       "0       196       242       3  881250949  Kolya (1996)  24-Jan-1997   \n",
       "1        63       242       3  875747190  Kolya (1996)  24-Jan-1997   \n",
       "2       226       242       5  883888671  Kolya (1996)  24-Jan-1997   \n",
       "3       154       242       3  879138235  Kolya (1996)  24-Jan-1997   \n",
       "4       306       242       5  876503793  Kolya (1996)  24-Jan-1997   \n",
       "5       296       242       4  884196057  Kolya (1996)  24-Jan-1997   \n",
       "6        34       242       5  888601628  Kolya (1996)  24-Jan-1997   \n",
       "7       271       242       4  885844495  Kolya (1996)  24-Jan-1997   \n",
       "8       201       242       4  884110598  Kolya (1996)  24-Jan-1997   \n",
       "9       209       242       4  883589606  Kolya (1996)  24-Jan-1997   \n",
       "10       35       242       2  875459166  Kolya (1996)  24-Jan-1997   \n",
       "11      354       242       5  891180399  Kolya (1996)  24-Jan-1997   \n",
       "12      199       242       5  883782485  Kolya (1996)  24-Jan-1997   \n",
       "13      113       242       2  875075887  Kolya (1996)  24-Jan-1997   \n",
       "14        1       242       5  889751633  Kolya (1996)  24-Jan-1997   \n",
       "\n",
       "    video release date                                         IMDb URL  \\\n",
       "0                  NaN  http://us.imdb.com/M/title-exact?Kolya%20(1996)   \n",
       "1                  NaN  http://us.imdb.com/M/title-exact?Kolya%20(1996)   \n",
       "2                  NaN  http://us.imdb.com/M/title-exact?Kolya%20(1996)   \n",
       "3                  NaN  http://us.imdb.com/M/title-exact?Kolya%20(1996)   \n",
       "4                  NaN  http://us.imdb.com/M/title-exact?Kolya%20(1996)   \n",
       "5                  NaN  http://us.imdb.com/M/title-exact?Kolya%20(1996)   \n",
       "6                  NaN  http://us.imdb.com/M/title-exact?Kolya%20(1996)   \n",
       "7                  NaN  http://us.imdb.com/M/title-exact?Kolya%20(1996)   \n",
       "8                  NaN  http://us.imdb.com/M/title-exact?Kolya%20(1996)   \n",
       "9                  NaN  http://us.imdb.com/M/title-exact?Kolya%20(1996)   \n",
       "10                 NaN  http://us.imdb.com/M/title-exact?Kolya%20(1996)   \n",
       "11                 NaN  http://us.imdb.com/M/title-exact?Kolya%20(1996)   \n",
       "12                 NaN  http://us.imdb.com/M/title-exact?Kolya%20(1996)   \n",
       "13                 NaN  http://us.imdb.com/M/title-exact?Kolya%20(1996)   \n",
       "14                 NaN  http://us.imdb.com/M/title-exact?Kolya%20(1996)   \n",
       "\n",
       "    unknown  Action  ...  Fantasy  Film-Noir  Horror  Musical  Mystery  \\\n",
       "0         0       0  ...        0          0       0        0        0   \n",
       "1         0       0  ...        0          0       0        0        0   \n",
       "2         0       0  ...        0          0       0        0        0   \n",
       "3         0       0  ...        0          0       0        0        0   \n",
       "4         0       0  ...        0          0       0        0        0   \n",
       "5         0       0  ...        0          0       0        0        0   \n",
       "6         0       0  ...        0          0       0        0        0   \n",
       "7         0       0  ...        0          0       0        0        0   \n",
       "8         0       0  ...        0          0       0        0        0   \n",
       "9         0       0  ...        0          0       0        0        0   \n",
       "10        0       0  ...        0          0       0        0        0   \n",
       "11        0       0  ...        0          0       0        0        0   \n",
       "12        0       0  ...        0          0       0        0        0   \n",
       "13        0       0  ...        0          0       0        0        0   \n",
       "14        0       0  ...        0          0       0        0        0   \n",
       "\n",
       "    Romance  Sci-Fi  Thriller  War  Western  \n",
       "0         0       0         0    0        0  \n",
       "1         0       0         0    0        0  \n",
       "2         0       0         0    0        0  \n",
       "3         0       0         0    0        0  \n",
       "4         0       0         0    0        0  \n",
       "5         0       0         0    0        0  \n",
       "6         0       0         0    0        0  \n",
       "7         0       0         0    0        0  \n",
       "8         0       0         0    0        0  \n",
       "9         0       0         0    0        0  \n",
       "10        0       0         0    0        0  \n",
       "11        0       0         0    0        0  \n",
       "12        0       0         0    0        0  \n",
       "13        0       0         0    0        0  \n",
       "14        0       0         0    0        0  \n",
       "\n",
       "[15 rows x 27 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_data = pd.merge(user_data, movie_data, on='movie_id')\n",
    "merged_data.head(15)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "1982ac15",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>movie 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>1</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>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>939</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>940</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>941</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>942</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>943</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>943 rows × 1664 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "movie title  'Til There Was You (1997)  1-900 (1994)  101 Dalmatians (1996)  \\\n",
       "user_id                                                                       \n",
       "1                                    0             0                      2   \n",
       "2                                    0             0                      0   \n",
       "3                                    0             0                      0   \n",
       "4                                    0             0                      0   \n",
       "5                                    0             0                      2   \n",
       "...                                ...           ...                    ...   \n",
       "939                                  0             0                      0   \n",
       "940                                  0             0                      0   \n",
       "941                                  0             0                      0   \n",
       "942                                  0             0                      0   \n",
       "943                                  0             0                      0   \n",
       "\n",
       "movie title  12 Angry Men (1957)  187 (1997)  2 Days in the Valley (1996)  \\\n",
       "user_id                                                                     \n",
       "1                              5           0                            0   \n",
       "2                              0           0                            0   \n",
       "3                              0           2                            0   \n",
       "4                              0           0                            0   \n",
       "5                              0           0                            0   \n",
       "...                          ...         ...                          ...   \n",
       "939                            0           0                            0   \n",
       "940                            0           0                            0   \n",
       "941                            0           0                            0   \n",
       "942                            0           0                            0   \n",
       "943                            0           0                            2   \n",
       "\n",
       "movie title  20,000 Leagues Under the Sea (1954)  \\\n",
       "user_id                                            \n",
       "1                                              3   \n",
       "2                                              0   \n",
       "3                                              0   \n",
       "4                                              0   \n",
       "5                                              0   \n",
       "...                                          ...   \n",
       "939                                            0   \n",
       "940                                            0   \n",
       "941                                            0   \n",
       "942                                            0   \n",
       "943                                            0   \n",
       "\n",
       "movie title  2001: A Space Odyssey (1968)  \\\n",
       "user_id                                     \n",
       "1                                       4   \n",
       "2                                       0   \n",
       "3                                       0   \n",
       "4                                       0   \n",
       "5                                       4   \n",
       "...                                   ...   \n",
       "939                                     0   \n",
       "940                                     0   \n",
       "941                                     0   \n",
       "942                                     3   \n",
       "943                                     0   \n",
       "\n",
       "movie title  3 Ninjas: High Noon At Mega Mountain (1998)  \\\n",
       "user_id                                                    \n",
       "1                                                      0   \n",
       "2                                                      1   \n",
       "3                                                      0   \n",
       "4                                                      0   \n",
       "5                                                      0   \n",
       "...                                                  ...   \n",
       "939                                                    0   \n",
       "940                                                    0   \n",
       "941                                                    0   \n",
       "942                                                    0   \n",
       "943                                                    0   \n",
       "\n",
       "movie title  39 Steps, The (1935)  ...  Yankee Zulu (1994)  \\\n",
       "user_id                            ...                       \n",
       "1                               0  ...                   0   \n",
       "2                               0  ...                   0   \n",
       "3                               0  ...                   0   \n",
       "4                               0  ...                   0   \n",
       "5                               0  ...                   0   \n",
       "...                           ...  ...                 ...   \n",
       "939                             0  ...                   0   \n",
       "940                             0  ...                   0   \n",
       "941                             0  ...                   0   \n",
       "942                             3  ...                   0   \n",
       "943                             0  ...                   0   \n",
       "\n",
       "movie title  Year of the Horse (1997)  You So Crazy (1994)  \\\n",
       "user_id                                                      \n",
       "1                                   0                    0   \n",
       "2                                   0                    0   \n",
       "3                                   0                    0   \n",
       "4                                   0                    0   \n",
       "5                                   0                    0   \n",
       "...                               ...                  ...   \n",
       "939                                 0                    0   \n",
       "940                                 0                    0   \n",
       "941                                 0                    0   \n",
       "942                                 0                    0   \n",
       "943                                 0                    0   \n",
       "\n",
       "movie title  Young Frankenstein (1974)  Young Guns (1988)  \\\n",
       "user_id                                                     \n",
       "1                                    5                  3   \n",
       "2                                    0                  0   \n",
       "3                                    0                  0   \n",
       "4                                    0                  0   \n",
       "5                                    4                  0   \n",
       "...                                ...                ...   \n",
       "939                                  0                  0   \n",
       "940                                  0                  0   \n",
       "941                                  0                  0   \n",
       "942                                  0                  0   \n",
       "943                                  0                  4   \n",
       "\n",
       "movie title  Young Guns II (1990)  Young Poisoner's Handbook, The (1995)  \\\n",
       "user_id                                                                    \n",
       "1                               0                                      0   \n",
       "2                               0                                      0   \n",
       "3                               0                                      0   \n",
       "4                               0                                      0   \n",
       "5                               0                                      0   \n",
       "...                           ...                                    ...   \n",
       "939                             0                                      0   \n",
       "940                             0                                      0   \n",
       "941                             0                                      0   \n",
       "942                             0                                      0   \n",
       "943                             3                                      0   \n",
       "\n",
       "movie title  Zeus and Roxanne (1997)  unknown  \\\n",
       "user_id                                         \n",
       "1                                  0        4   \n",
       "2                                  0        0   \n",
       "3                                  0        0   \n",
       "4                                  0        0   \n",
       "5                                  0        4   \n",
       "...                              ...      ...   \n",
       "939                                0        0   \n",
       "940                                0        0   \n",
       "941                                0        0   \n",
       "942                                0        0   \n",
       "943                                0        0   \n",
       "\n",
       "movie title  Á köldum klaka (Cold Fever) (1994)  \n",
       "user_id                                          \n",
       "1                                             0  \n",
       "2                                             0  \n",
       "3                                             0  \n",
       "4                                             0  \n",
       "5                                             0  \n",
       "...                                         ...  \n",
       "939                                           0  \n",
       "940                                           0  \n",
       "941                                           0  \n",
       "942                                           0  \n",
       "943                                           0  \n",
       "\n",
       "[943 rows x 1664 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_pivot_table = merged_data.pivot_table(index='user_id', values='rating', columns='movie title', fill_value=0)\n",
    "data_pivot_table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "5e1eaf49",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1664, 943)"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "transposed_data = data_pivot_table.values.T\n",
    "transposed_data.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "6daa5ee8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1664, 12)"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "SVD = TruncatedSVD(n_components=12)\n",
    "resultant_matrix = SVD.fit_transform(transposed_data)\n",
    "resultant_matrix.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "90985ef8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1664, 1664)"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "correlation_matrix = np.corrcoef(resultant_matrix)\n",
    "correlation_matrix.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "09f56b6f",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[\"'Til There Was You (1997)\",\n",
       " '1-900 (1994)',\n",
       " '101 Dalmatians (1996)',\n",
       " '12 Angry Men (1957)',\n",
       " '187 (1997)',\n",
       " '2 Days in the Valley (1996)',\n",
       " '20,000 Leagues Under the Sea (1954)',\n",
       " '2001: A Space Odyssey (1968)',\n",
       " '3 Ninjas: High Noon At Mega Mountain (1998)',\n",
       " '39 Steps, The (1935)',\n",
       " '8 1/2 (1963)',\n",
       " '8 Heads in a Duffel Bag (1997)',\n",
       " '8 Seconds (1994)',\n",
       " 'A Chef in Love (1996)',\n",
       " 'Above the Rim (1994)',\n",
       " 'Absolute Power (1997)',\n",
       " 'Abyss, The (1989)',\n",
       " 'Ace Ventura: Pet Detective (1994)',\n",
       " 'Ace Ventura: When Nature Calls (1995)',\n",
       " 'Across the Sea of Time (1995)',\n",
       " 'Addams Family Values (1993)',\n",
       " 'Addicted to Love (1997)',\n",
       " 'Addiction, The (1995)',\n",
       " 'Adventures of Pinocchio, The (1996)',\n",
       " 'Adventures of Priscilla, Queen of the Desert, The (1994)',\n",
       " 'Adventures of Robin Hood, The (1938)',\n",
       " 'Affair to Remember, An (1957)',\n",
       " 'African Queen, The (1951)',\n",
       " 'Afterglow (1997)',\n",
       " 'Age of Innocence, The (1993)',\n",
       " 'Aiqing wansui (1994)',\n",
       " 'Air Bud (1997)',\n",
       " 'Air Force One (1997)',\n",
       " 'Air Up There, The (1994)',\n",
       " 'Airheads (1994)',\n",
       " 'Akira (1988)',\n",
       " 'Aladdin (1992)',\n",
       " 'Aladdin and the King of Thieves (1996)',\n",
       " 'Alaska (1996)',\n",
       " 'Albino Alligator (1996)',\n",
       " 'Alice in Wonderland (1951)',\n",
       " 'Alien (1979)',\n",
       " 'Alien 3 (1992)',\n",
       " 'Alien: Resurrection (1997)',\n",
       " 'Aliens (1986)',\n",
       " 'All About Eve (1950)',\n",
       " 'All Dogs Go to Heaven 2 (1996)',\n",
       " 'All Over Me (1997)',\n",
       " 'All Things Fair (1996)',\n",
       " 'Alphaville (1965)',\n",
       " 'Amadeus (1984)',\n",
       " 'Amateur (1994)',\n",
       " 'Amazing Panda Adventure, The (1995)',\n",
       " 'American Buffalo (1996)',\n",
       " 'American Dream (1990)',\n",
       " 'American President, The (1995)',\n",
       " 'American Strays (1996)',\n",
       " 'American Werewolf in London, An (1981)',\n",
       " 'American in Paris, An (1951)',\n",
       " 'Amistad (1997)',\n",
       " \"Amityville 1992: It's About Time (1992)\",\n",
       " 'Amityville 3-D (1983)',\n",
       " 'Amityville Curse, The (1990)',\n",
       " 'Amityville Horror, The (1979)',\n",
       " 'Amityville II: The Possession (1982)',\n",
       " 'Amityville: A New Generation (1993)',\n",
       " 'Amityville: Dollhouse (1996)',\n",
       " 'Amos & Andrew (1993)',\n",
       " 'An Unforgettable Summer (1994)',\n",
       " 'Anaconda (1997)',\n",
       " 'Anastasia (1997)',\n",
       " 'Andre (1994)',\n",
       " 'Angel Baby (1995)',\n",
       " 'Angel and the Badman (1947)',\n",
       " 'Angel on My Shoulder (1946)',\n",
       " 'Angela (1995)',\n",
       " 'Angels and Insects (1995)',\n",
       " 'Angels in the Outfield (1994)',\n",
       " 'Angus (1995)',\n",
       " 'Anna (1996)',\n",
       " 'Anna Karenina (1997)',\n",
       " 'Anne Frank Remembered (1995)',\n",
       " 'Annie Hall (1977)',\n",
       " 'Another Stakeout (1993)',\n",
       " \"Antonia's Line (1995)\",\n",
       " 'Aparajito (1956)',\n",
       " 'Apartment, The (1960)',\n",
       " 'Apocalypse Now (1979)',\n",
       " 'Apollo 13 (1995)',\n",
       " 'Apostle, The (1997)',\n",
       " 'Apple Dumpling Gang, The (1975)',\n",
       " \"April Fool's Day (1986)\",\n",
       " 'Apt Pupil (1998)',\n",
       " 'Aristocats, The (1970)',\n",
       " 'Army of Darkness (1993)',\n",
       " 'Around the World in 80 Days (1956)',\n",
       " 'Arrival, The (1996)',\n",
       " 'Arsenic and Old Lace (1944)',\n",
       " 'As Good As It Gets (1997)',\n",
       " 'Assassins (1995)',\n",
       " 'Assignment, The (1997)',\n",
       " 'Associate, The (1996)',\n",
       " 'Audrey Rose (1977)',\n",
       " 'August (1996)',\n",
       " 'Austin Powers: International Man of Mystery (1997)',\n",
       " 'Awfully Big Adventure, An (1995)',\n",
       " 'Ayn Rand: A Sense of Life (1997)',\n",
       " 'B*A*P*S (1997)',\n",
       " 'B. Monkey (1998)',\n",
       " 'Babe (1995)',\n",
       " 'Baby-Sitters Club, The (1995)',\n",
       " 'Babyfever (1994)',\n",
       " 'Babysitter, The (1995)',\n",
       " 'Back to the Future (1985)',\n",
       " 'Backbeat (1993)',\n",
       " 'Bad Boys (1995)',\n",
       " 'Bad Company (1995)',\n",
       " 'Bad Girls (1994)',\n",
       " 'Bad Moon (1996)',\n",
       " 'Bad Taste (1987)',\n",
       " 'Ballad of Narayama, The (Narayama Bushiko) (1958)',\n",
       " 'Balto (1995)',\n",
       " 'Bananas (1971)',\n",
       " 'Band Wagon, The (1953)',\n",
       " 'Barb Wire (1996)',\n",
       " 'Barbarella (1968)',\n",
       " 'Barcelona (1994)',\n",
       " 'Basic Instinct (1992)',\n",
       " 'Basketball Diaries, The (1995)',\n",
       " 'Basquiat (1996)',\n",
       " 'Bastard Out of Carolina (1996)',\n",
       " 'Batman & Robin (1997)',\n",
       " 'Batman (1989)',\n",
       " 'Batman Forever (1995)',\n",
       " 'Batman Returns (1992)',\n",
       " 'Baton Rouge (1988)',\n",
       " 'Bean (1997)',\n",
       " 'Beans of Egypt, Maine, The (1994)',\n",
       " 'Beat the Devil (1954)',\n",
       " 'Beautician and the Beast, The (1997)',\n",
       " 'Beautiful Girls (1996)',\n",
       " 'Beautiful Thing (1996)',\n",
       " 'Beauty and the Beast (1991)',\n",
       " 'Beavis and Butt-head Do America (1996)',\n",
       " 'Bed of Roses (1996)',\n",
       " 'Bedknobs and Broomsticks (1971)',\n",
       " 'Before Sunrise (1995)',\n",
       " 'Before and After (1996)',\n",
       " 'Before the Rain (Pred dozhdot) (1994)',\n",
       " 'Being Human (1993)',\n",
       " 'Being There (1979)',\n",
       " 'Believers, The (1987)',\n",
       " 'Belle de jour (1967)',\n",
       " 'Ben-Hur (1959)',\n",
       " 'Benny & Joon (1993)',\n",
       " 'Bent (1997)',\n",
       " 'Best Men (1997)',\n",
       " 'Best of the Best 3: No Turning Back (1995)',\n",
       " 'Better Off Dead... (1985)',\n",
       " 'Beverly Hillbillies, The (1993)',\n",
       " 'Beverly Hills Cop III (1994)',\n",
       " 'Beverly Hills Ninja (1997)',\n",
       " 'Bewegte Mann, Der (1994)',\n",
       " 'Beyond Bedlam (1993)',\n",
       " 'Beyond Rangoon (1995)',\n",
       " 'Bhaji on the Beach (1993)',\n",
       " 'Big Bang Theory, The (1994)',\n",
       " 'Big Blue, The (Grand bleu, Le) (1988)',\n",
       " 'Big Bully (1996)',\n",
       " 'Big Green, The (1995)',\n",
       " 'Big Lebowski, The (1998)',\n",
       " 'Big Night (1996)',\n",
       " 'Big One, The (1997)',\n",
       " 'Big Sleep, The (1946)',\n",
       " 'Big Squeeze, The (1996)',\n",
       " 'Billy Madison (1995)',\n",
       " 'Bio-Dome (1996)',\n",
       " 'Bird of Prey (1996)',\n",
       " 'Birdcage, The (1996)',\n",
       " 'Birds, The (1963)',\n",
       " 'Bitter Moon (1992)',\n",
       " 'Bitter Sugar (Azucar Amargo) (1996)',\n",
       " 'Black Beauty (1994)',\n",
       " 'Black Sheep (1996)',\n",
       " 'Blade Runner (1982)',\n",
       " 'Blink (1994)',\n",
       " 'Bliss (1997)',\n",
       " 'Blob, The (1958)',\n",
       " 'Blood & Wine (1997)',\n",
       " 'Blood Beach (1981)',\n",
       " \"Blood For Dracula (Andy Warhol's Dracula) (1974)\",\n",
       " 'Bloodsport 2 (1995)',\n",
       " 'Bloody Child, The (1996)',\n",
       " 'Blown Away (1994)',\n",
       " 'Blue Angel, The (Blaue Engel, Der) (1930)',\n",
       " 'Blue Chips (1994)',\n",
       " 'Blue Sky (1994)',\n",
       " 'Blue in the Face (1995)',\n",
       " 'Blues Brothers 2000 (1998)',\n",
       " 'Blues Brothers, The (1980)',\n",
       " 'Bob Roberts (1992)',\n",
       " 'Body Parts (1991)',\n",
       " 'Body Snatcher, The (1945)',\n",
       " 'Body Snatchers (1993)',\n",
       " 'Bogus (1996)',\n",
       " 'Bonheur, Le (1965)',\n",
       " 'Bonnie and Clyde (1967)',\n",
       " 'Boogie Nights (1997)',\n",
       " 'Boomerang (1992)',\n",
       " 'Boot, Das (1981)',\n",
       " 'Booty Call (1997)',\n",
       " 'Bottle Rocket (1996)',\n",
       " 'Bound (1996)',\n",
       " 'Boxing Helena (1993)',\n",
       " \"Boy's Life 2 (1997)\",\n",
       " 'Boys (1996)',\n",
       " 'Boys Life (1995)',\n",
       " 'Boys in Venice (1996)',\n",
       " 'Boys of St. Vincent, The (1993)',\n",
       " 'Boys on the Side (1995)',\n",
       " 'Boys, Les (1997)',\n",
       " 'Brady Bunch Movie, The (1995)',\n",
       " 'Braindead (1992)',\n",
       " \"Bram Stoker's Dracula (1992)\",\n",
       " 'Brassed Off (1996)',\n",
       " 'Braveheart (1995)',\n",
       " 'Brazil (1985)',\n",
       " 'Bread and Chocolate (Pane e cioccolata) (1973)',\n",
       " 'Breakdown (1997)',\n",
       " \"Breakfast at Tiffany's (1961)\",\n",
       " 'Breaking the Waves (1996)',\n",
       " 'Bride of Frankenstein (1935)',\n",
       " 'Bridge on the River Kwai, The (1957)',\n",
       " 'Bridges of Madison County, The (1995)',\n",
       " 'Bringing Up Baby (1938)',\n",
       " 'Broken Arrow (1996)',\n",
       " 'Broken English (1996)',\n",
       " 'Bronx Tale, A (1993)',\n",
       " 'Brother Minister: The Assassination of Malcolm X (1994)',\n",
       " \"Brother's Kiss, A (1997)\",\n",
       " 'Brothers McMullen, The (1995)',\n",
       " 'Brothers in Trouble (1995)',\n",
       " 'Browning Version, The (1994)',\n",
       " 'Buddy (1997)',\n",
       " 'Bulletproof (1996)',\n",
       " 'Bullets Over Broadway (1994)',\n",
       " 'Burnt By the Sun (1994)',\n",
       " 'Burnt Offerings (1976)',\n",
       " 'Bushwhacked (1995)',\n",
       " 'Butch Cassidy and the Sundance Kid (1969)',\n",
       " 'Butcher Boy, The (1998)',\n",
       " 'Butterfly Kiss (1995)',\n",
       " 'Bye Bye, Love (1995)',\n",
       " \"C'est arrivé près de chez vous (1992)\",\n",
       " 'Cabin Boy (1994)',\n",
       " 'Cable Guy, The (1996)',\n",
       " 'Calendar Girl (1993)',\n",
       " 'Canadian Bacon (1994)',\n",
       " 'Candidate, The (1972)',\n",
       " 'Candyman (1992)',\n",
       " 'Candyman: Farewell to the Flesh (1995)',\n",
       " 'Cape Fear (1962)',\n",
       " 'Cape Fear (1991)',\n",
       " 'Captives (1994)',\n",
       " 'Career Girls (1997)',\n",
       " 'Careful (1992)',\n",
       " \"Carlito's Way (1993)\",\n",
       " 'Carmen Miranda: Bananas Is My Business (1994)',\n",
       " 'Caro Diario (Dear Diary) (1994)',\n",
       " 'Carpool (1996)',\n",
       " 'Carrie (1976)',\n",
       " 'Carried Away (1996)',\n",
       " 'Carrington (1995)',\n",
       " 'Casablanca (1942)',\n",
       " 'Casino (1995)',\n",
       " 'Casper (1995)',\n",
       " 'Castle Freak (1995)',\n",
       " 'Cat People (1982)',\n",
       " 'Cat on a Hot Tin Roof (1958)',\n",
       " \"Cats Don't Dance (1997)\",\n",
       " 'Catwalk (1995)',\n",
       " 'Caught (1996)',\n",
       " 'Celestial Clockwork (1994)',\n",
       " 'Celluloid Closet, The (1995)',\n",
       " 'Celtic Pride (1996)',\n",
       " 'Cement Garden, The (1993)',\n",
       " 'Cemetery Man (Dellamorte Dellamore) (1994)',\n",
       " 'Century (1993)',\n",
       " 'Chain Reaction (1996)',\n",
       " 'Chairman of the Board (1998)',\n",
       " 'Chamber, The (1996)',\n",
       " 'Charade (1963)',\n",
       " 'Chasers (1994)',\n",
       " 'Chasing Amy (1997)',\n",
       " 'Children of the Corn: The Gathering (1996)',\n",
       " 'Children of the Revolution (1996)',\n",
       " 'Chinatown (1974)',\n",
       " 'Christmas Carol, A (1938)',\n",
       " 'Chungking Express (1994)',\n",
       " 'Ciao, Professore! (1993)',\n",
       " 'Cinderella (1950)',\n",
       " 'Cinema Paradiso (1988)',\n",
       " 'Circle of Friends (1995)',\n",
       " 'Citizen Kane (1941)',\n",
       " 'Citizen Ruth (1996)',\n",
       " 'City Hall (1996)',\n",
       " \"City Slickers II: The Legend of Curly's Gold (1994)\",\n",
       " 'City of Angels (1998)',\n",
       " 'City of Industry (1997)',\n",
       " 'City of Lost Children, The (1995)',\n",
       " 'Clean Slate (1994)',\n",
       " 'Clean Slate (Coup de Torchon) (1981)',\n",
       " 'Clear and Present Danger (1994)',\n",
       " 'Clerks (1994)',\n",
       " 'Client, The (1994)',\n",
       " 'Cliffhanger (1993)',\n",
       " 'Clockers (1995)',\n",
       " 'Clockwork Orange, A (1971)',\n",
       " 'Close Shave, A (1995)',\n",
       " 'Clueless (1995)',\n",
       " 'Cobb (1994)',\n",
       " 'Cold Comfort Farm (1995)',\n",
       " 'Coldblooded (1995)',\n",
       " 'Collectionneuse, La (1967)',\n",
       " 'Colonel Chabert, Le (1994)',\n",
       " 'Color of Night (1994)',\n",
       " 'Commandments (1997)',\n",
       " 'Con Air (1997)',\n",
       " 'Conan the Barbarian (1981)',\n",
       " 'Condition Red (1995)',\n",
       " 'Coneheads (1993)',\n",
       " 'Congo (1995)',\n",
       " 'Conspiracy Theory (1997)',\n",
       " 'Contact (1997)',\n",
       " 'Contempt (Mépris, Le) (1963)',\n",
       " 'Convent, The (Convento, O) (1995)',\n",
       " 'Cook the Thief His Wife & Her Lover, The (1989)',\n",
       " 'Cool Hand Luke (1967)',\n",
       " 'Cool Runnings (1993)',\n",
       " 'Cop Land (1997)',\n",
       " 'Cops and Robbersons (1994)',\n",
       " 'Copycat (1995)',\n",
       " 'Corrina, Corrina (1994)',\n",
       " 'Cosi (1996)',\n",
       " 'Country Life (1994)',\n",
       " 'Courage Under Fire (1996)',\n",
       " 'Cowboy Way, The (1994)',\n",
       " 'Craft, The (1996)',\n",
       " 'Crash (1996)',\n",
       " 'Crimson Tide (1995)',\n",
       " 'Critical Care (1997)',\n",
       " 'Cronos (1992)',\n",
       " 'Crooklyn (1994)',\n",
       " 'Crossfire (1947)',\n",
       " 'Crossing Guard, The (1995)',\n",
       " 'Crow, The (1994)',\n",
       " 'Crow: City of Angels, The (1996)',\n",
       " 'Crows and Sparrows (1949)',\n",
       " 'Crucible, The (1996)',\n",
       " 'Crude Oasis, The (1995)',\n",
       " 'Crumb (1994)',\n",
       " 'Cry, the Beloved Country (1995)',\n",
       " 'Crying Game, The (1992)',\n",
       " 'Curdled (1996)',\n",
       " 'Cure, The (1995)',\n",
       " 'Cutthroat Island (1995)',\n",
       " 'Cyclo (1995)',\n",
       " 'Cyrano de Bergerac (1990)',\n",
       " 'Cérémonie, La (1995)',\n",
       " 'D3: The Mighty Ducks (1996)',\n",
       " 'Dadetown (1995)',\n",
       " 'Daens (1992)',\n",
       " 'Damsel in Distress, A (1937)',\n",
       " 'Dances with Wolves (1990)',\n",
       " 'Dangerous Beauty (1998)',\n",
       " 'Dangerous Ground (1997)',\n",
       " 'Dangerous Minds (1995)',\n",
       " \"Daniel Defoe's Robinson Crusoe (1996)\",\n",
       " \"Dante's Peak (1997)\",\n",
       " 'Dark City (1998)',\n",
       " 'Dave (1993)',\n",
       " 'Davy Crockett, King of the Wild Frontier (1955)',\n",
       " 'Day the Earth Stood Still, The (1951)',\n",
       " 'Day the Sun Turned Cold, The (Tianguo niezi) (1994)',\n",
       " 'Daylight (1996)',\n",
       " 'Days of Thunder (1990)',\n",
       " 'Daytrippers, The (1996)',\n",
       " 'Dazed and Confused (1993)',\n",
       " 'Dead Man (1995)',\n",
       " 'Dead Man Walking (1995)',\n",
       " 'Dead Poets Society (1989)',\n",
       " 'Dead Presidents (1995)',\n",
       " 'Dear God (1996)',\n",
       " 'Death and the Maiden (1994)',\n",
       " 'Death in Brunswick (1991)',\n",
       " 'Death in the Garden (Mort en ce jardin, La) (1956)',\n",
       " 'Deceiver (1997)',\n",
       " 'Deconstructing Harry (1997)',\n",
       " 'Deep Rising (1998)',\n",
       " 'Deer Hunter, The (1978)',\n",
       " 'Delicatessen (1991)',\n",
       " 'Delta of Venus (1994)',\n",
       " 'Demolition Man (1993)',\n",
       " 'Denise Calls Up (1995)',\n",
       " 'Desert Winds (1995)',\n",
       " 'Designated Mourner, The (1997)',\n",
       " 'Desperado (1995)',\n",
       " 'Desperate Measures (1998)',\n",
       " 'Destiny Turns on the Radio (1995)',\n",
       " 'Devil in a Blue Dress (1995)',\n",
       " \"Devil's Advocate, The (1997)\",\n",
       " \"Devil's Own, The (1997)\",\n",
       " 'Diabolique (1996)',\n",
       " 'Dial M for Murder (1954)',\n",
       " 'Die Hard (1988)',\n",
       " 'Die Hard 2 (1990)',\n",
       " 'Die Hard: With a Vengeance (1995)',\n",
       " 'Die xue shuang xiong (Killer, The) (1989)',\n",
       " 'Dingo (1992)',\n",
       " 'Dirty Dancing (1987)',\n",
       " 'Disclosure (1994)',\n",
       " 'Diva (1981)',\n",
       " 'Dolores Claiborne (1994)',\n",
       " 'Don Juan DeMarco (1995)',\n",
       " \"Don't Be a Menace to South Central While Drinking Your Juice in the Hood (1996)\",\n",
       " 'Donnie Brasco (1997)',\n",
       " 'Doom Generation, The (1995)',\n",
       " 'Doors, The (1991)',\n",
       " 'Double Happiness (1994)',\n",
       " 'Double Team (1997)',\n",
       " 'Double vie de Véronique, La (Double Life of Veronique, The) (1991)',\n",
       " 'Down Periscope (1996)',\n",
       " 'Down by Law (1986)',\n",
       " 'Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb (1963)',\n",
       " 'Dracula: Dead and Loving It (1995)',\n",
       " 'Dragonheart (1996)',\n",
       " 'Dream Man (1995)',\n",
       " 'Dream With the Fishes (1997)',\n",
       " 'Drop Dead Fred (1991)',\n",
       " 'Drop Zone (1994)',\n",
       " 'Drunks (1995)',\n",
       " 'Duck Soup (1933)',\n",
       " 'Dumb & Dumber (1994)',\n",
       " 'Dumbo (1941)',\n",
       " 'Dunston Checks In (1996)',\n",
       " 'Duoluo tianshi (1995)',\n",
       " 'E.T. the Extra-Terrestrial (1982)',\n",
       " 'East of Eden (1955)',\n",
       " 'Eat Drink Man Woman (1994)',\n",
       " 'Ed (1996)',\n",
       " 'Ed Wood (1994)',\n",
       " \"Ed's Next Move (1996)\",\n",
       " 'Eddie (1996)',\n",
       " 'Edge, The (1997)',\n",
       " 'Eighth Day, The (1996)',\n",
       " 'Emma (1996)',\n",
       " 'Empire Strikes Back, The (1980)',\n",
       " 'Enchanted April (1991)',\n",
       " 'Endless Summer 2, The (1994)',\n",
       " \"Enfer, L' (1994)\",\n",
       " 'English Patient, The (1996)',\n",
       " 'Englishman Who Went Up a Hill, But Came Down a Mountain, The (1995)',\n",
       " 'Entertaining Angels: The Dorothy Day Story (1996)',\n",
       " 'Eraser (1996)',\n",
       " 'Escape from L.A. (1996)',\n",
       " 'Escape from New York (1981)',\n",
       " 'Escape to Witch Mountain (1975)',\n",
       " 'Etz Hadomim Tafus (Under the Domin Tree) (1994)',\n",
       " \"Eve's Bayou (1997)\",\n",
       " 'Even Cowgirls Get the Blues (1993)',\n",
       " 'Evening Star, The (1996)',\n",
       " 'Event Horizon (1997)',\n",
       " 'Everest (1998)',\n",
       " 'Every Other Weekend (1990)',\n",
       " 'Everyone Says I Love You (1996)',\n",
       " 'Evil Dead II (1987)',\n",
       " 'Evita (1996)',\n",
       " 'Excess Baggage (1997)',\n",
       " 'Executive Decision (1996)',\n",
       " 'Exit to Eden (1994)',\n",
       " 'Exotica (1994)',\n",
       " 'Extreme Measures (1996)',\n",
       " 'Eye for an Eye (1996)',\n",
       " \"Eye of Vichy, The (Oeil de Vichy, L') (1993)\",\n",
       " 'Face/Off (1997)',\n",
       " 'Faces (1968)',\n",
       " 'Fair Game (1995)',\n",
       " 'FairyTale: A True Story (1997)',\n",
       " 'Faithful (1996)',\n",
       " 'Fall (1997)',\n",
       " 'Fallen (1998)',\n",
       " 'Falling in Love Again (1980)',\n",
       " 'Family Thing, A (1996)',\n",
       " 'Fan, The (1996)',\n",
       " 'Fantasia (1940)',\n",
       " 'Far From Home: The Adventures of Yellow Dog (1995)',\n",
       " 'Farewell My Concubine (1993)',\n",
       " 'Farewell to Arms, A (1932)',\n",
       " 'Fargo (1996)',\n",
       " 'Farinelli: il castrato (1994)',\n",
       " 'Farmer & Chase (1995)',\n",
       " 'Fast, Cheap & Out of Control (1997)',\n",
       " 'Faster Pussycat! Kill! Kill! (1965)',\n",
       " 'Fatal Instinct (1993)',\n",
       " 'Father of the Bride (1950)',\n",
       " 'Father of the Bride Part II (1995)',\n",
       " \"Fathers' Day (1997)\",\n",
       " 'Faust (1994)',\n",
       " 'Fausto (1993)',\n",
       " 'Favor, The (1994)',\n",
       " 'Fear (1996)',\n",
       " 'Fear of a Black Hat (1993)',\n",
       " 'Fear, The (1995)',\n",
       " 'Fearless (1993)',\n",
       " 'Feast of July (1995)',\n",
       " 'Feeling Minnesota (1996)',\n",
       " 'Female Perversions (1996)',\n",
       " 'Field of Dreams (1989)',\n",
       " 'Fierce Creatures (1997)',\n",
       " 'Fifth Element, The (1997)',\n",
       " 'Fille seule, La (A Single Girl) (1995)',\n",
       " 'Fire Down Below (1997)',\n",
       " 'Fire on the Mountain (1996)',\n",
       " 'Firestorm (1998)',\n",
       " 'Firm, The (1993)',\n",
       " 'First Kid (1996)',\n",
       " 'First Knight (1995)',\n",
       " 'First Wives Club, The (1996)',\n",
       " 'Fish Called Wanda, A (1988)',\n",
       " 'Fled (1996)',\n",
       " 'Flesh and Bone (1993)',\n",
       " 'Flintstones, The (1994)',\n",
       " 'Flipper (1996)',\n",
       " 'Flirt (1995)',\n",
       " 'Flirting With Disaster (1996)',\n",
       " 'Flower of My Secret, The (Flor de mi secreto, La) (1995)',\n",
       " 'Flubber (1997)',\n",
       " 'Fluke (1995)',\n",
       " 'Fly Away Home (1996)',\n",
       " 'Fog, The (1980)',\n",
       " 'Fools Rush In (1997)',\n",
       " 'For Ever Mozart (1996)',\n",
       " 'For Love or Money (1993)',\n",
       " 'For Richer or Poorer (1997)',\n",
       " 'For Whom the Bell Tolls (1943)',\n",
       " 'For the Moment (1994)',\n",
       " 'Forbidden Christ, The (Cristo proibito, Il) (1950)',\n",
       " 'Forbidden Planet (1956)',\n",
       " 'Foreign Correspondent (1940)',\n",
       " 'Foreign Student (1994)',\n",
       " 'Forget Paris (1995)',\n",
       " 'Forrest Gump (1994)',\n",
       " 'Four Days in September (1997)',\n",
       " 'Four Rooms (1995)',\n",
       " 'Four Weddings and a Funeral (1994)',\n",
       " 'Fox and the Hound, The (1981)',\n",
       " 'Foxfire (1996)',\n",
       " 'Frankie Starlight (1995)',\n",
       " 'Free Willy (1993)',\n",
       " 'Free Willy 2: The Adventure Home (1995)',\n",
       " 'Free Willy 3: The Rescue (1997)',\n",
       " 'Freeway (1996)',\n",
       " 'French Kiss (1995)',\n",
       " 'French Twist (Gazon maudit) (1995)',\n",
       " 'Fresh (1994)',\n",
       " 'Friday (1995)',\n",
       " 'Fried Green Tomatoes (1991)',\n",
       " 'Frighteners, The (1996)',\n",
       " 'Frisk (1995)',\n",
       " 'From Dusk Till Dawn (1996)',\n",
       " 'Fugitive, The (1993)',\n",
       " 'Full Metal Jacket (1987)',\n",
       " 'Full Monty, The (1997)',\n",
       " 'Full Speed (1996)',\n",
       " 'Funeral, The (1996)',\n",
       " 'Funny Face (1957)',\n",
       " 'Further Gesture, A (1996)',\n",
       " 'G.I. Jane (1997)',\n",
       " 'Gabbeh (1996)',\n",
       " 'Game, The (1997)',\n",
       " 'Gandhi (1982)',\n",
       " 'Gang Related (1997)',\n",
       " 'Garden of Finzi-Contini, The (Giardino dei Finzi-Contini, Il) (1970)',\n",
       " 'Gaslight (1944)',\n",
       " 'Gate of Heavenly Peace, The (1995)',\n",
       " 'Gattaca (1997)',\n",
       " 'Gay Divorcee, The (1934)',\n",
       " 'George of the Jungle (1997)',\n",
       " 'Georgia (1995)',\n",
       " 'Germinal (1993)',\n",
       " 'Geronimo: An American Legend (1993)',\n",
       " 'Get Shorty (1995)',\n",
       " 'Get on the Bus (1996)',\n",
       " 'Getaway, The (1994)',\n",
       " 'Getting Away With Murder (1996)',\n",
       " 'Getting Even with Dad (1994)',\n",
       " 'Ghost (1990)',\n",
       " 'Ghost and Mrs. Muir, The (1947)',\n",
       " 'Ghost and the Darkness, The (1996)',\n",
       " 'Ghost in the Shell (Kokaku kidotai) (1995)',\n",
       " 'Ghosts of Mississippi (1996)',\n",
       " 'Giant (1956)',\n",
       " 'Gigi (1958)',\n",
       " \"Gilligan's Island: The Movie (1998)\",\n",
       " 'Girl 6 (1996)',\n",
       " 'Girl in the Cadillac (1995)',\n",
       " 'Girls Town (1996)',\n",
       " 'Glass Shield, The (1994)',\n",
       " 'Glengarry Glen Ross (1992)',\n",
       " 'Glimmer Man, The (1996)',\n",
       " 'Glory (1989)',\n",
       " 'Go Fish (1994)',\n",
       " 'Godfather, The (1972)',\n",
       " 'Godfather: Part II, The (1974)',\n",
       " 'Gold Diggers: The Secret of Bear Mountain (1995)',\n",
       " 'Golden Earrings (1947)',\n",
       " 'GoldenEye (1995)',\n",
       " \"Gone Fishin' (1997)\",\n",
       " 'Gone with the Wind (1939)',\n",
       " 'Good Man in Africa, A (1994)',\n",
       " 'Good Morning (1971)',\n",
       " 'Good Will Hunting (1997)',\n",
       " 'Good, The Bad and The Ugly, The (1966)',\n",
       " 'GoodFellas (1990)',\n",
       " 'Goofy Movie, A (1995)',\n",
       " 'Gordy (1995)',\n",
       " 'Grace of My Heart (1996)',\n",
       " 'Graduate, The (1967)',\n",
       " 'Grand Day Out, A (1992)',\n",
       " 'Grass Harp, The (1995)',\n",
       " 'Grateful Dead (1995)',\n",
       " 'Grease (1978)',\n",
       " 'Grease 2 (1982)',\n",
       " 'Great Day in Harlem, A (1994)',\n",
       " 'Great Dictator, The (1940)',\n",
       " 'Great Escape, The (1963)',\n",
       " 'Great Expectations (1998)',\n",
       " 'Great Race, The (1965)',\n",
       " 'Great White Hype, The (1996)',\n",
       " \"Gridlock'd (1997)\",\n",
       " 'Grifters, The (1990)',\n",
       " 'Grosse Fatigue (1994)',\n",
       " 'Grosse Pointe Blank (1997)',\n",
       " 'Groundhog Day (1993)',\n",
       " 'Grumpier Old Men (1995)',\n",
       " 'Guantanamera (1994)',\n",
       " 'Guilty as Sin (1993)',\n",
       " 'Gumby: The Movie (1995)',\n",
       " 'Hackers (1995)',\n",
       " 'Half Baked (1998)',\n",
       " 'Halloween: The Curse of Michael Myers (1995)',\n",
       " 'Hamlet (1996)',\n",
       " 'Hana-bi (1997)',\n",
       " 'Happy Gilmore (1996)',\n",
       " 'Hard Eight (1996)',\n",
       " 'Hard Rain (1998)',\n",
       " 'Hard Target (1993)',\n",
       " 'Harlem (1993)',\n",
       " 'Harold and Maude (1971)',\n",
       " 'Harriet the Spy (1996)',\n",
       " 'Hate (Haine, La) (1995)',\n",
       " 'Haunted World of Edward D. Wood Jr., The (1995)',\n",
       " 'He Walked by Night (1948)',\n",
       " 'Head Above Water (1996)',\n",
       " 'Hear My Song (1991)',\n",
       " 'Hearts and Minds (1996)',\n",
       " 'Heat (1995)',\n",
       " 'Heathers (1989)',\n",
       " 'Heaven & Earth (1993)',\n",
       " \"Heaven's Prisoners (1996)\",\n",
       " 'Heavenly Creatures (1994)',\n",
       " 'Heavy (1995)',\n",
       " 'Heavy Metal (1981)',\n",
       " 'Heavyweights (1994)',\n",
       " 'Hedd Wyn (1992)',\n",
       " 'Heidi Fleiss: Hollywood Madam (1995) ',\n",
       " 'Hellraiser: Bloodline (1996)',\n",
       " 'Henry V (1989)',\n",
       " 'Herbie Rides Again (1974)',\n",
       " 'Hercules (1997)',\n",
       " 'Here Comes Cookie (1935)',\n",
       " 'Hideaway (1995)',\n",
       " 'High Noon (1952)',\n",
       " 'High School High (1996)',\n",
       " 'Higher Learning (1995)',\n",
       " 'Highlander (1986)',\n",
       " 'Highlander III: The Sorcerer (1994)',\n",
       " 'His Girl Friday (1940)',\n",
       " 'Hollow Reed (1996)',\n",
       " 'Homage (1995)',\n",
       " 'Home Alone (1990)',\n",
       " 'Home Alone 3 (1997)',\n",
       " 'Home for the Holidays (1995)',\n",
       " 'Homeward Bound II: Lost in San Francisco (1996)',\n",
       " 'Homeward Bound: The Incredible Journey (1993)',\n",
       " 'Hoodlum (1997)',\n",
       " 'Hoop Dreams (1994)',\n",
       " 'Horse Whisperer, The (1998)',\n",
       " 'Horseman on the Roof, The (Hussard sur le toit, Le) (1995)',\n",
       " 'Hostile Intentions (1994)',\n",
       " 'Hot Shots! Part Deux (1993)',\n",
       " 'Hotel de Love (1996)',\n",
       " 'Hour of the Pig, The (1993)',\n",
       " 'House Arrest (1996)',\n",
       " 'House Party 3 (1994)',\n",
       " 'House of Yes, The (1997)',\n",
       " 'House of the Spirits, The (1993)',\n",
       " 'Houseguest (1994)',\n",
       " 'How to Be a Player (1997)',\n",
       " 'How to Make an American Quilt (1995)',\n",
       " 'Howling, The (1981)',\n",
       " 'Hudsucker Proxy, The (1994)',\n",
       " 'Hugo Pool (1997)',\n",
       " 'Hunchback of Notre Dame, The (1996)',\n",
       " 'Hungarian Fairy Tale, A (1987)',\n",
       " 'Hunt for Red October, The (1990)',\n",
       " 'Hunted, The (1995)',\n",
       " 'Hurricane Streets (1998)',\n",
       " 'Hush (1998)',\n",
       " \"I Can't Sleep (J'ai pas sommeil) (1994)\",\n",
       " \"I Don't Want to Talk About It (De eso no se habla) (1993)\",\n",
       " 'I Know What You Did Last Summer (1997)',\n",
       " 'I Like It Like That (1994)',\n",
       " 'I Love Trouble (1994)',\n",
       " 'I Shot Andy Warhol (1996)',\n",
       " \"I'll Do Anything (1994)\",\n",
       " \"I'm Not Rappaport (1996)\",\n",
       " 'I, Worst of All (Yo, la peor de todas) (1990)',\n",
       " 'I.Q. (1994)',\n",
       " 'Ice Storm, The (1997)',\n",
       " 'If Lucy Fell (1996)',\n",
       " 'Ill Gotten Gains (1997)',\n",
       " 'Immortal Beloved (1994)',\n",
       " 'In & Out (1997)',\n",
       " 'In Love and War (1996)',\n",
       " 'In the Army Now (1994)',\n",
       " 'In the Bleak Midwinter (1995)',\n",
       " 'In the Company of Men (1997)',\n",
       " 'In the Line of Duty 2 (1987)',\n",
       " 'In the Line of Fire (1993)',\n",
       " 'In the Mouth of Madness (1995)',\n",
       " 'In the Name of the Father (1993)',\n",
       " 'In the Realm of the Senses (Ai no corrida) (1976)',\n",
       " 'Incognito (1997)',\n",
       " 'Independence Day (ID4) (1996)',\n",
       " 'Indian Summer (1996)',\n",
       " 'Indian in the Cupboard, The (1995)',\n",
       " 'Indiana Jones and the Last Crusade (1989)',\n",
       " 'Infinity (1996)',\n",
       " 'Inkwell, The (1994)',\n",
       " 'Innocent Sleep, The (1995)',\n",
       " 'Innocents, The (1961)',\n",
       " 'Inspector General, The (1949)',\n",
       " 'Interview with the Vampire (1994)',\n",
       " 'Intimate Relations (1996)',\n",
       " 'Inventing the Abbotts (1997)',\n",
       " 'Invitation, The (Zaproszenie) (1986)',\n",
       " 'Island of Dr. Moreau, The (1996)',\n",
       " 'It Could Happen to You (1994)',\n",
       " 'It Happened One Night (1934)',\n",
       " 'It Takes Two (1995)',\n",
       " \"It's My Party (1995)\",\n",
       " \"It's a Wonderful Life (1946)\",\n",
       " 'JLG/JLG - autoportrait de décembre (1994)',\n",
       " 'Jack (1996)',\n",
       " 'Jack and Sarah (1995)',\n",
       " 'Jackal, The (1997)',\n",
       " 'Jackie Brown (1997)',\n",
       " \"Jackie Chan's First Strike (1996)\",\n",
       " 'Jade (1995)',\n",
       " 'James and the Giant Peach (1996)',\n",
       " 'Jane Eyre (1996)',\n",
       " \"Jason's Lyric (1994)\",\n",
       " 'Jaws (1975)',\n",
       " 'Jaws 2 (1978)',\n",
       " 'Jaws 3-D (1983)',\n",
       " 'Jean de Florette (1986)',\n",
       " 'Jefferson in Paris (1995)',\n",
       " 'Jeffrey (1995)',\n",
       " 'Jerky Boys, The (1994)',\n",
       " 'Jerry Maguire (1996)',\n",
       " 'Jimmy Hollywood (1994)',\n",
       " 'Jingle All the Way (1996)',\n",
       " \"Joe's Apartment (1996)\",\n",
       " 'Johnny 100 Pesos (1993)',\n",
       " 'Johnny Mnemonic (1995)',\n",
       " 'Johns (1996)',\n",
       " 'Journey of August King, The (1995)',\n",
       " 'Joy Luck Club, The (1993)',\n",
       " 'Jude (1996)',\n",
       " 'Judge Dredd (1995)',\n",
       " 'Judgment Night (1993)',\n",
       " 'Jumanji (1995)',\n",
       " 'Jungle Book, The (1994)',\n",
       " 'Jungle2Jungle (1997)',\n",
       " 'Junior (1994)',\n",
       " \"Jupiter's Wife (1994)\",\n",
       " 'Jurassic Park (1993)',\n",
       " 'Juror, The (1996)',\n",
       " 'Jury Duty (1995)',\n",
       " 'Just Cause (1995)',\n",
       " 'Kalifornia (1993)',\n",
       " 'Kama Sutra: A Tale of Love (1996)',\n",
       " 'Kansas City (1996)',\n",
       " 'Kaspar Hauser (1993)',\n",
       " 'Kazaam (1996)',\n",
       " 'Keys to Tulsa (1997)',\n",
       " 'Kicked in the Head (1997)',\n",
       " 'Kicking and Screaming (1995)',\n",
       " \"Kid in King Arthur's Court, A (1995)\",\n",
       " 'Kids (1995)',\n",
       " 'Kids in the Hall: Brain Candy (1996)',\n",
       " 'Kika (1993)',\n",
       " 'Killer (Bulletproof Heart) (1994)',\n",
       " 'Killer: A Journal of Murder (1995)',\n",
       " 'Killing Fields, The (1984)',\n",
       " 'Killing Zoe (1994)',\n",
       " 'Kim (1950)',\n",
       " 'King of New York (1990)',\n",
       " 'King of the Hill (1993)',\n",
       " 'Kingpin (1996)',\n",
       " 'Kiss Me, Guido (1997)',\n",
       " 'Kiss of Death (1995)',\n",
       " 'Kiss the Girls (1997)',\n",
       " 'Kissed (1996)',\n",
       " 'Kolya (1996)',\n",
       " 'Koyaanisqatsi (1983)',\n",
       " 'Kull the Conqueror (1997)',\n",
       " 'Kundun (1997)',\n",
       " 'L.A. Confidential (1997)',\n",
       " 'Lady of Burlesque (1943)',\n",
       " 'Ladybird Ladybird (1994)',\n",
       " 'Lamerica (1994)',\n",
       " 'Land Before Time III: The Time of the Great Giving (1995) (V)',\n",
       " 'Land and Freedom (Tierra y libertad) (1995)',\n",
       " 'Larger Than Life (1996)',\n",
       " 'Lashou shentan (1992)',\n",
       " 'Lassie (1994)',\n",
       " 'Last Action Hero (1993)',\n",
       " 'Last Dance (1996)',\n",
       " 'Last Klezmer: Leopold Kozlowski, His Life and Music, The (1995)',\n",
       " 'Last Man Standing (1996)',\n",
       " 'Last Summer in the Hamptons (1995)',\n",
       " 'Last Supper, The (1995)',\n",
       " 'Last Time I Committed Suicide, The (1997)',\n",
       " 'Last Time I Saw Paris, The (1954)',\n",
       " 'Last of the Mohicans, The (1992)',\n",
       " 'Late Bloomers (1996)',\n",
       " 'Laura (1944)',\n",
       " 'Lawnmower Man 2: Beyond Cyberspace (1996)',\n",
       " 'Lawnmower Man, The (1992)',\n",
       " 'Lawrence of Arabia (1962)',\n",
       " 'Lay of the Land, The (1997)',\n",
       " 'Leading Man, The (1996)',\n",
       " 'Leave It to Beaver (1997)',\n",
       " 'Leaving Las Vegas (1995)',\n",
       " 'Legal Deceit (1997)',\n",
       " 'Legends of the Fall (1994)',\n",
       " 'Leopard Son, The (1996)',\n",
       " 'Letter From Death Row, A (1998)',\n",
       " 'Liar Liar (1997)',\n",
       " 'Liebelei (1933)',\n",
       " 'Life Less Ordinary, A (1997)',\n",
       " 'Life with Mikey (1993)',\n",
       " 'Lightning Jack (1994)',\n",
       " 'Like Water For Chocolate (Como agua para chocolate) (1992)',\n",
       " 'Line King: Al Hirschfeld, The (1996)',\n",
       " 'Lion King, The (1994)',\n",
       " 'Little Big League (1994)',\n",
       " 'Little Buddha (1993)',\n",
       " 'Little City (1998)',\n",
       " 'Little Lord Fauntleroy (1936)',\n",
       " 'Little Odessa (1994)',\n",
       " 'Little Princess, A (1995)',\n",
       " 'Little Princess, The (1939)',\n",
       " 'Little Rascals, The (1994)',\n",
       " 'Little Women (1994)',\n",
       " 'Live Nude Girls (1995)',\n",
       " 'Living in Oblivion (1995)',\n",
       " 'Loaded (1994)',\n",
       " 'Local Hero (1983)',\n",
       " 'Loch Ness (1995)',\n",
       " 'Locusts, The (1997)',\n",
       " 'Lone Star (1996)',\n",
       " 'Long Kiss Goodnight, The (1996)',\n",
       " 'Looking for Richard (1996)',\n",
       " 'Lord of Illusions (1995)',\n",
       " 'Losing Chase (1996)',\n",
       " 'Losing Isaiah (1995)',\n",
       " 'Lost Highway (1997)',\n",
       " 'Lost Horizon (1937)',\n",
       " 'Lost World: Jurassic Park, The (1997)',\n",
       " 'Lost in Space (1998)',\n",
       " 'Lotto Land (1995)',\n",
       " 'Love & Human Remains (1993)',\n",
       " 'Love Affair (1994)',\n",
       " 'Love Bug, The (1969)',\n",
       " 'Love Is All There Is (1996)',\n",
       " 'Love Jones (1997)',\n",
       " 'Love Serenade (1996)',\n",
       " 'Love and Death on Long Island (1997)',\n",
       " 'Love and Other Catastrophes (1996)',\n",
       " 'Love and a .45 (1994)',\n",
       " 'Love in the Afternoon (1957)',\n",
       " 'Love! Valour! Compassion! (1997)',\n",
       " \"Lover's Knot (1996)\",\n",
       " 'Low Down Dirty Shame, A (1994)',\n",
       " 'Low Life, The (1994)',\n",
       " 'M (1931)',\n",
       " 'M*A*S*H (1970)',\n",
       " 'M. Butterfly (1993)',\n",
       " 'MURDER and murder (1996)',\n",
       " 'Ma vie en rose (My Life in Pink) (1997)',\n",
       " 'Machine, The (1994)',\n",
       " 'Mad City (1997)',\n",
       " 'Mad Dog Time (1996)',\n",
       " 'Mad Love (1995)',\n",
       " 'Madame Butterfly (1995)',\n",
       " 'Made in America (1993)',\n",
       " 'Madness of King George, The (1994)',\n",
       " 'Madonna: Truth or Dare (1991)',\n",
       " 'Magic Hour, The (1998)',\n",
       " 'Magnificent Seven, The (1954)',\n",
       " 'Major Payne (1994)',\n",
       " 'Malice (1993)',\n",
       " 'Mallrats (1995)',\n",
       " 'Maltese Falcon, The (1941)',\n",
       " 'Mamma Roma (1962)',\n",
       " 'Man Who Knew Too Little, The (1997)',\n",
       " 'Man Who Would Be King, The (1975)',\n",
       " 'Man Without a Face, The (1993)',\n",
       " 'Man from Down Under, The (1943)',\n",
       " 'Man in the Iron Mask, The (1998)',\n",
       " 'Man of No Importance, A (1994)',\n",
       " 'Man of the House (1995)',\n",
       " 'Man of the Year (1995)',\n",
       " 'Manchurian Candidate, The (1962)',\n",
       " 'Manhattan (1979)',\n",
       " 'Manhattan Murder Mystery (1993)',\n",
       " 'Manny & Lo (1996)',\n",
       " 'Manon of the Spring (Manon des sources) (1986)',\n",
       " \"Margaret's Museum (1995)\",\n",
       " 'Mark of Zorro, The (1940)',\n",
       " 'Marked for Death (1990)',\n",
       " 'Marlene Dietrich: Shadow and Light (1996) ',\n",
       " 'Mars Attacks! (1996)',\n",
       " \"Marvin's Room (1996)\",\n",
       " 'Mary Poppins (1964)',\n",
       " 'Mary Reilly (1996)',\n",
       " \"Mary Shelley's Frankenstein (1994)\",\n",
       " 'Mask, The (1994)',\n",
       " \"Mat' i syn (1997)\",\n",
       " 'MatchMaker, The (1997)',\n",
       " 'Matilda (1996)',\n",
       " 'Maverick (1994)',\n",
       " 'Maximum Risk (1996)',\n",
       " 'Maya Lin: A Strong Clear Vision (1994)',\n",
       " 'Maybe, Maybe Not (Bewegte Mann, Der) (1994)',\n",
       " \"McHale's Navy (1997)\",\n",
       " 'Mediterraneo (1991)',\n",
       " 'Meet John Doe (1941)',\n",
       " 'Meet Me in St. Louis (1944)',\n",
       " 'Meet Wally Sparks (1997)',\n",
       " 'Men With Guns (1997)',\n",
       " 'Men in Black (1997)',\n",
       " 'Men of Means (1998)',\n",
       " 'Menace II Society (1993)',\n",
       " 'Mercury Rising (1998)',\n",
       " 'Metisse (Café au Lait) (1993)',\n",
       " 'Metro (1997)',\n",
       " 'Miami Rhapsody (1995)',\n",
       " 'Michael (1996)',\n",
       " 'Michael Collins (1996)',\n",
       " \"Microcosmos: Le peuple de l'herbe (1996)\",\n",
       " 'Midnight Dancers (Sibak) (1994)',\n",
       " 'Midnight in the Garden of Good and Evil (1997)',\n",
       " 'Mighty Aphrodite (1995)',\n",
       " 'Mighty Morphin Power Rangers: The Movie (1995)',\n",
       " 'Mighty, The (1998)',\n",
       " 'Milk Money (1994)',\n",
       " 'Mille bolle blu (1993)',\n",
       " \"Miller's Crossing (1990)\",\n",
       " 'Mimic (1997)',\n",
       " 'Mina Tannenbaum (1994)',\n",
       " 'Miracle on 34th Street (1994)',\n",
       " 'Mirage (1995)',\n",
       " 'Mirror Has Two Faces, The (1996)',\n",
       " 'Mission: Impossible (1996)',\n",
       " 'Misérables, Les (1995)',\n",
       " 'Mixed Nuts (1994)',\n",
       " 'Modern Affair, A (1995)',\n",
       " 'Moll Flanders (1996)',\n",
       " 'Mondo (1996)',\n",
       " 'Money Talks (1997)',\n",
       " 'Money Train (1995)',\n",
       " 'Month by the Lake, A (1995)',\n",
       " 'Monty Python and the Holy Grail (1974)',\n",
       " \"Monty Python's Life of Brian (1979)\",\n",
       " 'Moonlight and Valentino (1995)',\n",
       " 'Mortal Kombat (1995)',\n",
       " ...]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movie_names = data_pivot_table.columns\n",
    "movie_list = list(movie_names)\n",
    "movie_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "e620becc",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "dalmations = movie_list.index('All Things Fair (1996)')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "044af275",
   "metadata": {},
   "outputs": [],
   "source": [
    "dalmations_corr = correlation_matrix[dalmations]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "9bb00bc6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Big Blue, The (Grand bleu, Le) (1988)',\n",
       "       'Four Weddings and a Funeral (1994)', 'Hoop Dreams (1994)',\n",
       "       'House of the Spirits, The (1993)', 'In the Name of the Father (1993)',\n",
       "       'Miller's Crossing (1990)', 'Newton Boys, The (1998)',\n",
       "       'Nobody's Fool (1994)',\n",
       "       'Old Lady Who Walked in the Sea, The (Vieille qui marchait dans la mer, La) (1991)',\n",
       "       'Scream of Stone (Schrei aus Stein) (1991)',\n",
       "       'Some Folks Call It a Sling Blade (1993)', 'You So Crazy (1994)'],\n",
       "      dtype='object', name='movie title')"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movie_names[(dalmations_corr > 0.7) & (dalmations_corr < 1)]"
   ]
  }
 ],
 "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.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}