Item based collaborative filtering .ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "58f25cac",
   "metadata": {},
   "source": [
    "# Recommendation system based on collaborative filtering "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "77230c8d",
   "metadata": {},
   "source": [
    "# item based collaborative filtering "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "6910019d",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import warnings\n",
    "import neattext.functions as nfx\n",
    "from scipy.sparse import csr_matrix\n",
    "from sklearn.neighbors import NearestNeighbors\n",
    "from sklearn.feature_extraction.text import TfidfVectorizer\n",
    "from sklearn.metrics.pairwise import cosine_similarity"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "82dfd2d3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>movieId</th>\n",
       "      <th>title</th>\n",
       "      <th>genres</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>Adventure|Animation|Children|Comedy|Fantasy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Jumanji (1995)</td>\n",
       "      <td>Adventure|Children|Fantasy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Grumpier Old Men (1995)</td>\n",
       "      <td>Comedy|Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Waiting to Exhale (1995)</td>\n",
       "      <td>Comedy|Drama|Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Father of the Bride Part II (1995)</td>\n",
       "      <td>Comedy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34203</th>\n",
       "      <td>151697</td>\n",
       "      <td>Grand Slam (1967)</td>\n",
       "      <td>Thriller</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34204</th>\n",
       "      <td>151701</td>\n",
       "      <td>Bloodmoney (2010)</td>\n",
       "      <td>(no genres listed)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34205</th>\n",
       "      <td>151703</td>\n",
       "      <td>The Butterfly Circus (2009)</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34206</th>\n",
       "      <td>151709</td>\n",
       "      <td>Zero (2015)</td>\n",
       "      <td>Drama|Sci-Fi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34207</th>\n",
       "      <td>151711</td>\n",
       "      <td>The 2000 Year Old Man (1975)</td>\n",
       "      <td>(no genres listed)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>34208 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       movieId                               title  \\\n",
       "0            1                    Toy Story (1995)   \n",
       "1            2                      Jumanji (1995)   \n",
       "2            3             Grumpier Old Men (1995)   \n",
       "3            4            Waiting to Exhale (1995)   \n",
       "4            5  Father of the Bride Part II (1995)   \n",
       "...        ...                                 ...   \n",
       "34203   151697                   Grand Slam (1967)   \n",
       "34204   151701                   Bloodmoney (2010)   \n",
       "34205   151703         The Butterfly Circus (2009)   \n",
       "34206   151709                         Zero (2015)   \n",
       "34207   151711        The 2000 Year Old Man (1975)   \n",
       "\n",
       "                                            genres  \n",
       "0      Adventure|Animation|Children|Comedy|Fantasy  \n",
       "1                       Adventure|Children|Fantasy  \n",
       "2                                   Comedy|Romance  \n",
       "3                             Comedy|Drama|Romance  \n",
       "4                                           Comedy  \n",
       "...                                            ...  \n",
       "34203                                     Thriller  \n",
       "34204                           (no genres listed)  \n",
       "34205                                        Drama  \n",
       "34206                                 Drama|Sci-Fi  \n",
       "34207                           (no genres listed)  \n",
       "\n",
       "[34208 rows x 3 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies=pd.read_csv('movies.csv.zip')\n",
    "\n",
    "\n",
    "#Checking:\n",
    "movies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "5a5d216c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>userId</th>\n",
       "      <th>movieId</th>\n",
       "      <th>rating</th>\n",
       "      <th>timestamp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>169</td>\n",
       "      <td>2.5</td>\n",
       "      <td>1204927694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2471</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1204927438</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>48516</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1204927435</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2</td>\n",
       "      <td>2571</td>\n",
       "      <td>3.5</td>\n",
       "      <td>1436165433</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2</td>\n",
       "      <td>109487</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1436165496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22884372</th>\n",
       "      <td>247753</td>\n",
       "      <td>49530</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1430437962</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22884373</th>\n",
       "      <td>247753</td>\n",
       "      <td>69481</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1430437984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22884374</th>\n",
       "      <td>247753</td>\n",
       "      <td>74458</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1430437968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22884375</th>\n",
       "      <td>247753</td>\n",
       "      <td>76093</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1430437811</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22884376</th>\n",
       "      <td>247753</td>\n",
       "      <td>130636</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1430437721</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>22884377 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          userId  movieId  rating   timestamp\n",
       "0              1      169     2.5  1204927694\n",
       "1              1     2471     3.0  1204927438\n",
       "2              1    48516     5.0  1204927435\n",
       "3              2     2571     3.5  1436165433\n",
       "4              2   109487     4.0  1436165496\n",
       "...          ...      ...     ...         ...\n",
       "22884372  247753    49530     5.0  1430437962\n",
       "22884373  247753    69481     3.0  1430437984\n",
       "22884374  247753    74458     4.0  1430437968\n",
       "22884375  247753    76093     5.0  1430437811\n",
       "22884376  247753   130636     0.5  1430437721\n",
       "\n",
       "[22884377 rows x 4 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ratings=pd.read_csv('ratings.csv.zip')\n",
    "\n",
    "\n",
    "ratings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "fcff2e9a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>userId</th>\n",
       "      <th>movieId</th>\n",
       "      <th>rating</th>\n",
       "      <th>timestamp</th>\n",
       "      <th>title</th>\n",
       "      <th>genres</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>169</td>\n",
       "      <td>2.5</td>\n",
       "      <td>1204927694</td>\n",
       "      <td>Free Willy 2: The Adventure Home (1995)</td>\n",
       "      <td>Adventure|Children|Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>13</td>\n",
       "      <td>169</td>\n",
       "      <td>1.0</td>\n",
       "      <td>974868393</td>\n",
       "      <td>Free Willy 2: The Adventure Home (1995)</td>\n",
       "      <td>Adventure|Children|Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>14</td>\n",
       "      <td>169</td>\n",
       "      <td>3.0</td>\n",
       "      <td>845470321</td>\n",
       "      <td>Free Willy 2: The Adventure Home (1995)</td>\n",
       "      <td>Adventure|Children|Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>17</td>\n",
       "      <td>169</td>\n",
       "      <td>1.0</td>\n",
       "      <td>944991371</td>\n",
       "      <td>Free Willy 2: The Adventure Home (1995)</td>\n",
       "      <td>Adventure|Children|Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>68</td>\n",
       "      <td>169</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1011092044</td>\n",
       "      <td>Free Willy 2: The Adventure Home (1995)</td>\n",
       "      <td>Adventure|Children|Drama</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22884372</th>\n",
       "      <td>247509</td>\n",
       "      <td>95581</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1341630851</td>\n",
       "      <td>Flying Fleet, The (1929)</td>\n",
       "      <td>Adventure|Drama|Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22884373</th>\n",
       "      <td>247534</td>\n",
       "      <td>111838</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1429019913</td>\n",
       "      <td>Man Named Rocca, A (Nommé La Rocca, Un) (Man C...</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22884374</th>\n",
       "      <td>247662</td>\n",
       "      <td>137437</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1436313628</td>\n",
       "      <td>Son of a Lion (2007)</td>\n",
       "      <td>(no genres listed)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22884375</th>\n",
       "      <td>247670</td>\n",
       "      <td>145939</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1446432935</td>\n",
       "      <td>Sandesham (1991)</td>\n",
       "      <td>Children|Comedy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22884376</th>\n",
       "      <td>247670</td>\n",
       "      <td>147053</td>\n",
       "      <td>4.5</td>\n",
       "      <td>1447852630</td>\n",
       "      <td>Devasuram (1993)</td>\n",
       "      <td>Action|Drama</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>22884377 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          userId  movieId  rating   timestamp  \\\n",
       "0              1      169     2.5  1204927694   \n",
       "1             13      169     1.0   974868393   \n",
       "2             14      169     3.0   845470321   \n",
       "3             17      169     1.0   944991371   \n",
       "4             68      169     1.0  1011092044   \n",
       "...          ...      ...     ...         ...   \n",
       "22884372  247509    95581     4.0  1341630851   \n",
       "22884373  247534   111838     4.0  1429019913   \n",
       "22884374  247662   137437     3.0  1436313628   \n",
       "22884375  247670   145939     5.0  1446432935   \n",
       "22884376  247670   147053     4.5  1447852630   \n",
       "\n",
       "                                                      title  \\\n",
       "0                   Free Willy 2: The Adventure Home (1995)   \n",
       "1                   Free Willy 2: The Adventure Home (1995)   \n",
       "2                   Free Willy 2: The Adventure Home (1995)   \n",
       "3                   Free Willy 2: The Adventure Home (1995)   \n",
       "4                   Free Willy 2: The Adventure Home (1995)   \n",
       "...                                                     ...   \n",
       "22884372                           Flying Fleet, The (1929)   \n",
       "22884373  Man Named Rocca, A (Nommé La Rocca, Un) (Man C...   \n",
       "22884374                               Son of a Lion (2007)   \n",
       "22884375                                   Sandesham (1991)   \n",
       "22884376                                   Devasuram (1993)   \n",
       "\n",
       "                            genres  \n",
       "0         Adventure|Children|Drama  \n",
       "1         Adventure|Children|Drama  \n",
       "2         Adventure|Children|Drama  \n",
       "3         Adventure|Children|Drama  \n",
       "4         Adventure|Children|Drama  \n",
       "...                            ...  \n",
       "22884372   Adventure|Drama|Romance  \n",
       "22884373                     Drama  \n",
       "22884374        (no genres listed)  \n",
       "22884375           Children|Comedy  \n",
       "22884376              Action|Drama  \n",
       "\n",
       "[22884377 rows x 6 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data=pd.merge(ratings, movies, on='movieId', how='inner')\n",
    "\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "a7eaeaae",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "userId       False\n",
       "movieId      False\n",
       "rating       False\n",
       "timestamp    False\n",
       "title        False\n",
       "genres       False\n",
       "dtype: bool"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.isnull().any()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "a3e7603c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>userId</th>\n",
       "      <th>rating</th>\n",
       "      <th>title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2.5</td>\n",
       "      <td>Free Willy 2: The Adventure Home (1995)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>13</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Free Willy 2: The Adventure Home (1995)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>14</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Free Willy 2: The Adventure Home (1995)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>17</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Free Willy 2: The Adventure Home (1995)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>68</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Free Willy 2: The Adventure Home (1995)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22884372</th>\n",
       "      <td>247509</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Flying Fleet, The (1929)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22884373</th>\n",
       "      <td>247534</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Man Named Rocca, A (Nommé La Rocca, Un) (Man C...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22884374</th>\n",
       "      <td>247662</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Son of a Lion (2007)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22884375</th>\n",
       "      <td>247670</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Sandesham (1991)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22884376</th>\n",
       "      <td>247670</td>\n",
       "      <td>4.5</td>\n",
       "      <td>Devasuram (1993)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>22884377 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          userId  rating                                              title\n",
       "0              1     2.5            Free Willy 2: The Adventure Home (1995)\n",
       "1             13     1.0            Free Willy 2: The Adventure Home (1995)\n",
       "2             14     3.0            Free Willy 2: The Adventure Home (1995)\n",
       "3             17     1.0            Free Willy 2: The Adventure Home (1995)\n",
       "4             68     1.0            Free Willy 2: The Adventure Home (1995)\n",
       "...          ...     ...                                                ...\n",
       "22884372  247509     4.0                           Flying Fleet, The (1929)\n",
       "22884373  247534     4.0  Man Named Rocca, A (Nommé La Rocca, Un) (Man C...\n",
       "22884374  247662     3.0                               Son of a Lion (2007)\n",
       "22884375  247670     5.0                                   Sandesham (1991)\n",
       "22884376  247670     4.5                                   Devasuram (1993)\n",
       "\n",
       "[22884377 rows x 3 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.drop(['timestamp', 'movieId', 'genres'], axis=1, inplace=True)\n",
    "\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "2e5caaf4",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['1', '2', '3', '4', '5', '6', '7', '8', '9', '10',\n",
      "       ...\n",
      "       '245940', '246415', '246533', '246887', '246994', '247081', '247509',\n",
      "       '247534', '247662', '247670'],\n",
      "      dtype='object', name='userId', length=4607)\n"
     ]
    }
   ],
   "source": [
    "print(data.columns)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "a91ade84",
   "metadata": {},
   "outputs": [],
   "source": [
    "data.columns = data.columns.str.strip()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "91638230",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "userId                                               1   2   3   4   5   6  \\\n",
      "title                                                                        \n",
      "\"Great Performances\" Cats (1998)                   NaN NaN NaN NaN NaN NaN   \n",
      "#1 Cheerleader Camp (2010)                         NaN NaN NaN NaN NaN NaN   \n",
      "#chicagoGirl: The Social Network Takes on a Dic... NaN NaN NaN NaN NaN NaN   \n",
      "$ (Dollars) (1971)                                 NaN NaN NaN NaN NaN NaN   \n",
      "$5 a Day (2008)                                    NaN NaN NaN NaN NaN NaN   \n",
      "\n",
      "userId                                               7   8   9  10  ...  \\\n",
      "title                                                               ...   \n",
      "\"Great Performances\" Cats (1998)                   NaN NaN NaN NaN  ...   \n",
      "#1 Cheerleader Camp (2010)                         NaN NaN NaN NaN  ...   \n",
      "#chicagoGirl: The Social Network Takes on a Dic... NaN NaN NaN NaN  ...   \n",
      "$ (Dollars) (1971)                                 NaN NaN NaN NaN  ...   \n",
      "$5 a Day (2008)                                    NaN NaN NaN NaN  ...   \n",
      "\n",
      "userId                                              245940  246415  246533  \\\n",
      "title                                                                        \n",
      "\"Great Performances\" Cats (1998)                       NaN     NaN     NaN   \n",
      "#1 Cheerleader Camp (2010)                             NaN     NaN     NaN   \n",
      "#chicagoGirl: The Social Network Takes on a Dic...     NaN     NaN     NaN   \n",
      "$ (Dollars) (1971)                                     NaN     NaN     NaN   \n",
      "$5 a Day (2008)                                        NaN     NaN     NaN   \n",
      "\n",
      "userId                                              246887  246994  247081  \\\n",
      "title                                                                        \n",
      "\"Great Performances\" Cats (1998)                       NaN     NaN     NaN   \n",
      "#1 Cheerleader Camp (2010)                             NaN     NaN     NaN   \n",
      "#chicagoGirl: The Social Network Takes on a Dic...     NaN     NaN     NaN   \n",
      "$ (Dollars) (1971)                                     NaN     NaN     NaN   \n",
      "$5 a Day (2008)                                        NaN     NaN     NaN   \n",
      "\n",
      "userId                                              247509  247534  247662  \\\n",
      "title                                                                        \n",
      "\"Great Performances\" Cats (1998)                       NaN     NaN     NaN   \n",
      "#1 Cheerleader Camp (2010)                             NaN     NaN     NaN   \n",
      "#chicagoGirl: The Social Network Takes on a Dic...     NaN     NaN     NaN   \n",
      "$ (Dollars) (1971)                                     NaN     NaN     NaN   \n",
      "$5 a Day (2008)                                        NaN     NaN     NaN   \n",
      "\n",
      "userId                                              247670  \n",
      "title                                                       \n",
      "\"Great Performances\" Cats (1998)                       NaN  \n",
      "#1 Cheerleader Camp (2010)                             NaN  \n",
      "#chicagoGirl: The Social Network Takes on a Dic...     NaN  \n",
      "$ (Dollars) (1971)                                     NaN  \n",
      "$5 a Day (2008)                                        NaN  \n",
      "\n",
      "[5 rows x 4607 columns]\n"
     ]
    }
   ],
   "source": [
    "print(data.head())\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "5a880148",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>userId</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>10</th>\n",
       "      <th>...</th>\n",
       "      <th>245940</th>\n",
       "      <th>246415</th>\n",
       "      <th>246533</th>\n",
       "      <th>246887</th>\n",
       "      <th>246994</th>\n",
       "      <th>247081</th>\n",
       "      <th>247509</th>\n",
       "      <th>247534</th>\n",
       "      <th>247662</th>\n",
       "      <th>247670</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>\"Great Performances\" Cats (1998)</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#1 Cheerleader Camp (2010)</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#chicagoGirl: The Social Network Takes on a Dictator (2013)</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>$ (Dollars) (1971)</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>$5 a Day (2008)</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Škola princů (2010)</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>أهواك (2015)</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>キサラギ (2007)</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ドラゴンボール Ｚ あつまれ！ 悟空ワールド (1992)</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>貞子3D (2012)</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>33647 rows × 4607 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "userId                                               1   2   3   4   5   6  \\\n",
       "title                                                                        \n",
       "\"Great Performances\" Cats (1998)                   NaN NaN NaN NaN NaN NaN   \n",
       "#1 Cheerleader Camp (2010)                         NaN NaN NaN NaN NaN NaN   \n",
       "#chicagoGirl: The Social Network Takes on a Dic... NaN NaN NaN NaN NaN NaN   \n",
       "$ (Dollars) (1971)                                 NaN NaN NaN NaN NaN NaN   \n",
       "$5 a Day (2008)                                    NaN NaN NaN NaN NaN NaN   \n",
       "...                                                 ..  ..  ..  ..  ..  ..   \n",
       "Škola princů (2010)                                NaN NaN NaN NaN NaN NaN   \n",
       "أهواك (2015)                                       NaN NaN NaN NaN NaN NaN   \n",
       "キサラギ (2007)                                        NaN NaN NaN NaN NaN NaN   \n",
       "ドラゴンボール Ｚ あつまれ！ 悟空ワールド (1992)                      NaN NaN NaN NaN NaN NaN   \n",
       "貞子3D (2012)                                        NaN NaN NaN NaN NaN NaN   \n",
       "\n",
       "userId                                               7   8   9  10  ...  \\\n",
       "title                                                               ...   \n",
       "\"Great Performances\" Cats (1998)                   NaN NaN NaN NaN  ...   \n",
       "#1 Cheerleader Camp (2010)                         NaN NaN NaN NaN  ...   \n",
       "#chicagoGirl: The Social Network Takes on a Dic... NaN NaN NaN NaN  ...   \n",
       "$ (Dollars) (1971)                                 NaN NaN NaN NaN  ...   \n",
       "$5 a Day (2008)                                    NaN NaN NaN NaN  ...   \n",
       "...                                                 ..  ..  ..  ..  ...   \n",
       "Škola princů (2010)                                NaN NaN NaN NaN  ...   \n",
       "أهواك (2015)                                       NaN NaN NaN NaN  ...   \n",
       "キサラギ (2007)                                        NaN NaN NaN NaN  ...   \n",
       "ドラゴンボール Ｚ あつまれ！ 悟空ワールド (1992)                      NaN NaN NaN NaN  ...   \n",
       "貞子3D (2012)                                        NaN NaN NaN NaN  ...   \n",
       "\n",
       "userId                                              245940  246415  246533  \\\n",
       "title                                                                        \n",
       "\"Great Performances\" Cats (1998)                       NaN     NaN     NaN   \n",
       "#1 Cheerleader Camp (2010)                             NaN     NaN     NaN   \n",
       "#chicagoGirl: The Social Network Takes on a Dic...     NaN     NaN     NaN   \n",
       "$ (Dollars) (1971)                                     NaN     NaN     NaN   \n",
       "$5 a Day (2008)                                        NaN     NaN     NaN   \n",
       "...                                                    ...     ...     ...   \n",
       "Škola princů (2010)                                    NaN     NaN     NaN   \n",
       "أهواك (2015)                                           NaN     NaN     NaN   \n",
       "キサラギ (2007)                                            NaN     NaN     NaN   \n",
       "ドラゴンボール Ｚ あつまれ！ 悟空ワールド (1992)                          NaN     NaN     NaN   \n",
       "貞子3D (2012)                                            NaN     NaN     NaN   \n",
       "\n",
       "userId                                              246887  246994  247081  \\\n",
       "title                                                                        \n",
       "\"Great Performances\" Cats (1998)                       NaN     NaN     NaN   \n",
       "#1 Cheerleader Camp (2010)                             NaN     NaN     NaN   \n",
       "#chicagoGirl: The Social Network Takes on a Dic...     NaN     NaN     NaN   \n",
       "$ (Dollars) (1971)                                     NaN     NaN     NaN   \n",
       "$5 a Day (2008)                                        NaN     NaN     NaN   \n",
       "...                                                    ...     ...     ...   \n",
       "Škola princů (2010)                                    NaN     NaN     NaN   \n",
       "أهواك (2015)                                           NaN     NaN     NaN   \n",
       "キサラギ (2007)                                            NaN     NaN     NaN   \n",
       "ドラゴンボール Ｚ あつまれ！ 悟空ワールド (1992)                          NaN     NaN     NaN   \n",
       "貞子3D (2012)                                            NaN     NaN     NaN   \n",
       "\n",
       "userId                                              247509  247534  247662  \\\n",
       "title                                                                        \n",
       "\"Great Performances\" Cats (1998)                       NaN     NaN     NaN   \n",
       "#1 Cheerleader Camp (2010)                             NaN     NaN     NaN   \n",
       "#chicagoGirl: The Social Network Takes on a Dic...     NaN     NaN     NaN   \n",
       "$ (Dollars) (1971)                                     NaN     NaN     NaN   \n",
       "$5 a Day (2008)                                        NaN     NaN     NaN   \n",
       "...                                                    ...     ...     ...   \n",
       "Škola princů (2010)                                    NaN     NaN     NaN   \n",
       "أهواك (2015)                                           NaN     NaN     NaN   \n",
       "キサラギ (2007)                                            NaN     NaN     NaN   \n",
       "ドラゴンボール Ｚ あつまれ！ 悟空ワールド (1992)                          NaN     NaN     NaN   \n",
       "貞子3D (2012)                                            NaN     NaN     NaN   \n",
       "\n",
       "userId                                              247670  \n",
       "title                                                       \n",
       "\"Great Performances\" Cats (1998)                       NaN  \n",
       "#1 Cheerleader Camp (2010)                             NaN  \n",
       "#chicagoGirl: The Social Network Takes on a Dic...     NaN  \n",
       "$ (Dollars) (1971)                                     NaN  \n",
       "$5 a Day (2008)                                        NaN  \n",
       "...                                                    ...  \n",
       "Škola princů (2010)                                    NaN  \n",
       "أهواك (2015)                                           NaN  \n",
       "キサラギ (2007)                                            NaN  \n",
       "ドラゴンボール Ｚ あつまれ！ 悟空ワールド (1992)                          NaN  \n",
       "貞子3D (2012)                                            NaN  \n",
       "\n",
       "[33647 rows x 4607 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "1d523477",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>userId</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>10</th>\n",
       "      <th>...</th>\n",
       "      <th>245940</th>\n",
       "      <th>246415</th>\n",
       "      <th>246533</th>\n",
       "      <th>246887</th>\n",
       "      <th>246994</th>\n",
       "      <th>247081</th>\n",
       "      <th>247509</th>\n",
       "      <th>247534</th>\n",
       "      <th>247662</th>\n",
       "      <th>247670</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>\"Great Performances\" Cats (1998)</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#1 Cheerleader Camp (2010)</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#chicagoGirl: The Social Network Takes on a Dictator (2013)</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>$ (Dollars) (1971)</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>$5 a Day (2008)</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>Škola princů (2010)</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>أهواك (2015)</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>キサラギ (2007)</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ドラゴンボール Ｚ あつまれ！ 悟空ワールド (1992)</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>貞子3D (2012)</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>33647 rows × 4607 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "userId                                                1    2    3    4    5  \\\n",
       "title                                                                         \n",
       "\"Great Performances\" Cats (1998)                    0.0  0.0  0.0  0.0  0.0   \n",
       "#1 Cheerleader Camp (2010)                          0.0  0.0  0.0  0.0  0.0   \n",
       "#chicagoGirl: The Social Network Takes on a Dic...  0.0  0.0  0.0  0.0  0.0   \n",
       "$ (Dollars) (1971)                                  0.0  0.0  0.0  0.0  0.0   \n",
       "$5 a Day (2008)                                     0.0  0.0  0.0  0.0  0.0   \n",
       "...                                                 ...  ...  ...  ...  ...   \n",
       "Škola princů (2010)                                 0.0  0.0  0.0  0.0  0.0   \n",
       "أهواك (2015)                                        0.0  0.0  0.0  0.0  0.0   \n",
       "キサラギ (2007)                                         0.0  0.0  0.0  0.0  0.0   \n",
       "ドラゴンボール Ｚ あつまれ！ 悟空ワールド (1992)                       0.0  0.0  0.0  0.0  0.0   \n",
       "貞子3D (2012)                                         0.0  0.0  0.0  0.0  0.0   \n",
       "\n",
       "userId                                                6    7    8    9   10  \\\n",
       "title                                                                         \n",
       "\"Great Performances\" Cats (1998)                    0.0  0.0  0.0  0.0  0.0   \n",
       "#1 Cheerleader Camp (2010)                          0.0  0.0  0.0  0.0  0.0   \n",
       "#chicagoGirl: The Social Network Takes on a Dic...  0.0  0.0  0.0  0.0  0.0   \n",
       "$ (Dollars) (1971)                                  0.0  0.0  0.0  0.0  0.0   \n",
       "$5 a Day (2008)                                     0.0  0.0  0.0  0.0  0.0   \n",
       "...                                                 ...  ...  ...  ...  ...   \n",
       "Škola princů (2010)                                 0.0  0.0  0.0  0.0  0.0   \n",
       "أهواك (2015)                                        0.0  0.0  0.0  0.0  0.0   \n",
       "キサラギ (2007)                                         0.0  0.0  0.0  0.0  0.0   \n",
       "ドラゴンボール Ｚ あつまれ！ 悟空ワールド (1992)                       0.0  0.0  0.0  0.0  0.0   \n",
       "貞子3D (2012)                                         0.0  0.0  0.0  0.0  0.0   \n",
       "\n",
       "userId                                              ...  245940  246415  \\\n",
       "title                                               ...                   \n",
       "\"Great Performances\" Cats (1998)                    ...     0.0     0.0   \n",
       "#1 Cheerleader Camp (2010)                          ...     0.0     0.0   \n",
       "#chicagoGirl: The Social Network Takes on a Dic...  ...     0.0     0.0   \n",
       "$ (Dollars) (1971)                                  ...     0.0     0.0   \n",
       "$5 a Day (2008)                                     ...     0.0     0.0   \n",
       "...                                                 ...     ...     ...   \n",
       "Škola princů (2010)                                 ...     0.0     0.0   \n",
       "أهواك (2015)                                        ...     0.0     0.0   \n",
       "キサラギ (2007)                                         ...     0.0     0.0   \n",
       "ドラゴンボール Ｚ あつまれ！ 悟空ワールド (1992)                       ...     0.0     0.0   \n",
       "貞子3D (2012)                                         ...     0.0     0.0   \n",
       "\n",
       "userId                                              246533  246887  246994  \\\n",
       "title                                                                        \n",
       "\"Great Performances\" Cats (1998)                       0.0     0.0     0.0   \n",
       "#1 Cheerleader Camp (2010)                             0.0     0.0     0.0   \n",
       "#chicagoGirl: The Social Network Takes on a Dic...     0.0     0.0     0.0   \n",
       "$ (Dollars) (1971)                                     0.0     0.0     0.0   \n",
       "$5 a Day (2008)                                        0.0     0.0     0.0   \n",
       "...                                                    ...     ...     ...   \n",
       "Škola princů (2010)                                    0.0     0.0     0.0   \n",
       "أهواك (2015)                                           0.0     0.0     0.0   \n",
       "キサラギ (2007)                                            0.0     0.0     0.0   \n",
       "ドラゴンボール Ｚ あつまれ！ 悟空ワールド (1992)                          0.0     0.0     0.0   \n",
       "貞子3D (2012)                                            0.0     0.0     0.0   \n",
       "\n",
       "userId                                              247081  247509  247534  \\\n",
       "title                                                                        \n",
       "\"Great Performances\" Cats (1998)                       0.0     0.0     0.0   \n",
       "#1 Cheerleader Camp (2010)                             0.0     0.0     0.0   \n",
       "#chicagoGirl: The Social Network Takes on a Dic...     0.0     0.0     0.0   \n",
       "$ (Dollars) (1971)                                     0.0     0.0     0.0   \n",
       "$5 a Day (2008)                                        0.0     0.0     0.0   \n",
       "...                                                    ...     ...     ...   \n",
       "Škola princů (2010)                                    0.0     0.0     0.0   \n",
       "أهواك (2015)                                           0.0     0.0     0.0   \n",
       "キサラギ (2007)                                            0.0     0.0     0.0   \n",
       "ドラゴンボール Ｚ あつまれ！ 悟空ワールド (1992)                          0.0     0.0     0.0   \n",
       "貞子3D (2012)                                            0.0     0.0     0.0   \n",
       "\n",
       "userId                                              247662  247670  \n",
       "title                                                               \n",
       "\"Great Performances\" Cats (1998)                       0.0     0.0  \n",
       "#1 Cheerleader Camp (2010)                             0.0     0.0  \n",
       "#chicagoGirl: The Social Network Takes on a Dic...     0.0     0.0  \n",
       "$ (Dollars) (1971)                                     0.0     0.0  \n",
       "$5 a Day (2008)                                        0.0     0.0  \n",
       "...                                                    ...     ...  \n",
       "Škola princů (2010)                                    0.0     0.0  \n",
       "أهواك (2015)                                           0.0     0.0  \n",
       "キサラギ (2007)                                            0.0     0.0  \n",
       "ドラゴンボール Ｚ あつまれ！ 悟空ワールド (1992)                          0.0     0.0  \n",
       "貞子3D (2012)                                            0.0     0.0  \n",
       "\n",
       "[33647 rows x 4607 columns]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data=data.fillna(0)\n",
    "\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "e40c41be",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<33647x4607 sparse matrix of type '<class 'numpy.float64'>'\n",
       "\twith 33647 stored elements in Compressed Sparse Row format>"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_sparse=csr_matrix(data)\n",
    "\n",
    "\n",
    "\n",
    "data_sparse"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "b6a8cb85",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style>#sk-container-id-1 {color: black;}#sk-container-id-1 pre{padding: 0;}#sk-container-id-1 div.sk-toggleable {background-color: white;}#sk-container-id-1 label.sk-toggleable__label {cursor: pointer;display: block;width: 100%;margin-bottom: 0;padding: 0.3em;box-sizing: border-box;text-align: center;}#sk-container-id-1 label.sk-toggleable__label-arrow:before {content: \"▸\";float: left;margin-right: 0.25em;color: #696969;}#sk-container-id-1 label.sk-toggleable__label-arrow:hover:before {color: black;}#sk-container-id-1 div.sk-estimator:hover label.sk-toggleable__label-arrow:before {color: black;}#sk-container-id-1 div.sk-toggleable__content {max-height: 0;max-width: 0;overflow: hidden;text-align: left;background-color: #f0f8ff;}#sk-container-id-1 div.sk-toggleable__content pre {margin: 0.2em;color: black;border-radius: 0.25em;background-color: #f0f8ff;}#sk-container-id-1 input.sk-toggleable__control:checked~div.sk-toggleable__content {max-height: 200px;max-width: 100%;overflow: auto;}#sk-container-id-1 input.sk-toggleable__control:checked~label.sk-toggleable__label-arrow:before {content: \"▾\";}#sk-container-id-1 div.sk-estimator input.sk-toggleable__control:checked~label.sk-toggleable__label {background-color: #d4ebff;}#sk-container-id-1 div.sk-label input.sk-toggleable__control:checked~label.sk-toggleable__label {background-color: #d4ebff;}#sk-container-id-1 input.sk-hidden--visually {border: 0;clip: rect(1px 1px 1px 1px);clip: rect(1px, 1px, 1px, 1px);height: 1px;margin: -1px;overflow: hidden;padding: 0;position: absolute;width: 1px;}#sk-container-id-1 div.sk-estimator {font-family: monospace;background-color: #f0f8ff;border: 1px dotted black;border-radius: 0.25em;box-sizing: border-box;margin-bottom: 0.5em;}#sk-container-id-1 div.sk-estimator:hover {background-color: #d4ebff;}#sk-container-id-1 div.sk-parallel-item::after {content: \"\";width: 100%;border-bottom: 1px solid gray;flex-grow: 1;}#sk-container-id-1 div.sk-label:hover label.sk-toggleable__label {background-color: #d4ebff;}#sk-container-id-1 div.sk-serial::before {content: \"\";position: absolute;border-left: 1px solid gray;box-sizing: border-box;top: 0;bottom: 0;left: 50%;z-index: 0;}#sk-container-id-1 div.sk-serial {display: flex;flex-direction: column;align-items: center;background-color: white;padding-right: 0.2em;padding-left: 0.2em;position: relative;}#sk-container-id-1 div.sk-item {position: relative;z-index: 1;}#sk-container-id-1 div.sk-parallel {display: flex;align-items: stretch;justify-content: center;background-color: white;position: relative;}#sk-container-id-1 div.sk-item::before, #sk-container-id-1 div.sk-parallel-item::before {content: \"\";position: absolute;border-left: 1px solid gray;box-sizing: border-box;top: 0;bottom: 0;left: 50%;z-index: -1;}#sk-container-id-1 div.sk-parallel-item {display: flex;flex-direction: column;z-index: 1;position: relative;background-color: white;}#sk-container-id-1 div.sk-parallel-item:first-child::after {align-self: flex-end;width: 50%;}#sk-container-id-1 div.sk-parallel-item:last-child::after {align-self: flex-start;width: 50%;}#sk-container-id-1 div.sk-parallel-item:only-child::after {width: 0;}#sk-container-id-1 div.sk-dashed-wrapped {border: 1px dashed gray;margin: 0 0.4em 0.5em 0.4em;box-sizing: border-box;padding-bottom: 0.4em;background-color: white;}#sk-container-id-1 div.sk-label label {font-family: monospace;font-weight: bold;display: inline-block;line-height: 1.2em;}#sk-container-id-1 div.sk-label-container {text-align: center;}#sk-container-id-1 div.sk-container {/* jupyter's `normalize.less` sets `[hidden] { display: none; }` but bootstrap.min.css set `[hidden] { display: none !important; }` so we also need the `!important` here to be able to override the default hidden behavior on the sphinx rendered scikit-learn.org. See: https://github.com/scikit-learn/scikit-learn/issues/21755 */display: inline-block !important;position: relative;}#sk-container-id-1 div.sk-text-repr-fallback {display: none;}</style><div id=\"sk-container-id-1\" class=\"sk-top-container\"><div class=\"sk-text-repr-fallback\"><pre>NearestNeighbors(metric=&#x27;euclidean&#x27;)</pre><b>In a Jupyter environment, please rerun this cell to show the HTML representation or trust the notebook. <br />On GitHub, the HTML representation is unable to render, please try loading this page with nbviewer.org.</b></div><div class=\"sk-container\" hidden><div class=\"sk-item\"><div class=\"sk-estimator sk-toggleable\"><input class=\"sk-toggleable__control sk-hidden--visually\" id=\"sk-estimator-id-1\" type=\"checkbox\" checked><label for=\"sk-estimator-id-1\" class=\"sk-toggleable__label sk-toggleable__label-arrow\">NearestNeighbors</label><div class=\"sk-toggleable__content\"><pre>NearestNeighbors(metric=&#x27;euclidean&#x27;)</pre></div></div></div></div></div>"
      ],
      "text/plain": [
       "NearestNeighbors(metric='euclidean')"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "model=NearestNeighbors(metric='euclidean')\n",
    "model.fit(data_sparse)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "0d4631e2",
   "metadata": {},
   "outputs": [],
   "source": [
    "distances, suggestions=model.kneighbors(data.iloc[2,:].values.reshape(1,-1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "9b5a3199",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[0.        , 5.02493781, 5.02493781, 5.02493781, 5.02493781]])"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "distances"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "adfa383d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[2, 4, 0, 3, 6]])"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "suggestions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "d1a64cdd",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['#chicagoGirl: The Social Network Takes on a Dictator (2013)',\n",
      "       '$5 a Day (2008)', '\"Great Performances\" Cats (1998)',\n",
      "       '$ (Dollars) (1971)', '$ellebrity (Sellebrity) (2012)'],\n",
      "      dtype='object', name='title')\n"
     ]
    }
   ],
   "source": [
    "for i in range(len(suggestions)):\n",
    "    print(data.index[suggestions[i]])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "296fc640",
   "metadata": {},
   "outputs": [],
   "source": [
    "distances, suggestions=model.kneighbors(data.iloc[32,:].values.reshape(1,-1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "d5a7a08b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "userId                           1    2    3    4    5    6    7    8    9  \\\n",
      "title                                                                        \n",
      "Act of Valor (2012)            0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0   \n",
      "10,000 BC (2008)               0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0   \n",
      "...And Justice for All (1979)  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0   \n",
      "Battle of the Year (2013)      0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0   \n",
      "As Above, So Below (2014)      0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0   \n",
      "\n",
      "userId                          10  ...  245940  246415  246533  246887  \\\n",
      "title                               ...                                   \n",
      "Act of Valor (2012)            0.0  ...     0.0     0.0     0.0     0.0   \n",
      "10,000 BC (2008)               0.0  ...     0.0     0.0     0.0     0.0   \n",
      "...And Justice for All (1979)  0.0  ...     0.0     0.0     0.0     0.0   \n",
      "Battle of the Year (2013)      0.0  ...     0.0     0.0     0.0     0.0   \n",
      "As Above, So Below (2014)      0.0  ...     0.0     0.0     0.0     0.0   \n",
      "\n",
      "userId                         246994  247081  247509  247534  247662  247670  \n",
      "title                                                                          \n",
      "Act of Valor (2012)               0.0     0.0     0.0     0.0     0.0     0.0  \n",
      "10,000 BC (2008)                  0.0     0.0     0.0     0.0     0.0     0.0  \n",
      "...And Justice for All (1979)     0.0     0.0     0.0     0.0     0.0     0.0  \n",
      "Battle of the Year (2013)         0.0     0.0     0.0     0.0     0.0     0.0  \n",
      "As Above, So Below (2014)         0.0     0.0     0.0     0.0     0.0     0.0  \n",
      "\n",
      "[5 rows x 4607 columns]\n"
     ]
    }
   ],
   "source": [
    "recommended_movies = data.iloc[suggestions[0]]\n",
    "print(recommended_movies)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "9211e6ae",
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'model' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "Cell \u001b[0;32mIn[1], line 1\u001b[0m\n\u001b[0;32m----> 1\u001b[0m distances, suggestions\u001b[38;5;241m=\u001b[39m\u001b[43mmodel\u001b[49m\u001b[38;5;241m.\u001b[39mkneighbors(data[data\u001b[38;5;241m.\u001b[39mindex\u001b[38;5;241m.\u001b[39mstr\u001b[38;5;241m.\u001b[39mstartswith(\u001b[38;5;124m'\u001b[39m\u001b[38;5;124mToy\u001b[39m\u001b[38;5;124m'\u001b[39m)]\u001b[38;5;241m.\u001b[39mvalues\u001b[38;5;241m.\u001b[39mreshape(\u001b[38;5;241m1\u001b[39m,\u001b[38;5;241m-\u001b[39m\u001b[38;5;241m1\u001b[39m))\n",
      "\u001b[0;31mNameError\u001b[0m: name 'model' is not defined"
     ]
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3dd166a8",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}