Book Recommendation system.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "4c9612f1",
   "metadata": {},
   "source": [
    "# Importing necessary packages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 330,
   "id": "a045c6f0",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cf0ca503",
   "metadata": {},
   "source": [
    "# Importing  and reading datasets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 331,
   "id": "9fadaa7d",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Load the books dataset\n",
    "books_df = pd.read_csv(\"./dataset/Books.csv\", low_memory = False, usecols=[\"ISBN\", \"Book-Title\", \"Book-Author\",\"Year-Of-Publication\"])\n",
    "\n",
    "# Load the users dataset\n",
    "users_df = pd.read_csv(\"./dataset/Users.csv\", low_memory = False)\n",
    "\n",
    "# Load the ratings dataset\n",
    "ratings_df = pd.read_csv(\"./dataset/Ratings.csv\", low_memory = False)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 332,
   "id": "bd49b20c",
   "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>ISBN</th>\n",
       "      <th>Book-Title</th>\n",
       "      <th>Book-Author</th>\n",
       "      <th>Year-Of-Publication</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0195153448</td>\n",
       "      <td>Classical Mythology</td>\n",
       "      <td>Mark P. O. Morford</td>\n",
       "      <td>2002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0002005018</td>\n",
       "      <td>Clara Callan</td>\n",
       "      <td>Richard Bruce Wright</td>\n",
       "      <td>2001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0060973129</td>\n",
       "      <td>Decision in Normandy</td>\n",
       "      <td>Carlo D'Este</td>\n",
       "      <td>1991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0374157065</td>\n",
       "      <td>Flu: The Story of the Great Influenza Pandemic...</td>\n",
       "      <td>Gina Bari Kolata</td>\n",
       "      <td>1999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0393045218</td>\n",
       "      <td>The Mummies of Urumchi</td>\n",
       "      <td>E. J. W. Barber</td>\n",
       "      <td>1999</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         ISBN                                         Book-Title  \\\n",
       "0  0195153448                                Classical Mythology   \n",
       "1  0002005018                                       Clara Callan   \n",
       "2  0060973129                               Decision in Normandy   \n",
       "3  0374157065  Flu: The Story of the Great Influenza Pandemic...   \n",
       "4  0393045218                             The Mummies of Urumchi   \n",
       "\n",
       "            Book-Author Year-Of-Publication  \n",
       "0    Mark P. O. Morford                2002  \n",
       "1  Richard Bruce Wright                2001  \n",
       "2          Carlo D'Este                1991  \n",
       "3      Gina Bari Kolata                1999  \n",
       "4       E. J. W. Barber                1999  "
      ]
     },
     "execution_count": 332,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "books_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 333,
   "id": "beb8f1d0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>User-ID</th>\n",
       "      <th>ISBN</th>\n",
       "      <th>Book-Rating</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>276725</td>\n",
       "      <td>034545104X</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>276726</td>\n",
       "      <td>0155061224</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>276727</td>\n",
       "      <td>0446520802</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>276729</td>\n",
       "      <td>052165615X</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>276729</td>\n",
       "      <td>0521795028</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   User-ID        ISBN  Book-Rating\n",
       "0   276725  034545104X            0\n",
       "1   276726  0155061224            5\n",
       "2   276727  0446520802            0\n",
       "3   276729  052165615X            3\n",
       "4   276729  0521795028            6"
      ]
     },
     "execution_count": 333,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ratings_df.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 334,
   "id": "766da274",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>User-ID</th>\n",
       "      <th>Location</th>\n",
       "      <th>Age</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>nyc, new york, usa</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>stockton, california, usa</td>\n",
       "      <td>18.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>moscow, yukon territory, russia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>porto, v.n.gaia, portugal</td>\n",
       "      <td>17.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>farnborough, hants, united kingdom</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   User-ID                            Location   Age\n",
       "0        1                  nyc, new york, usa   NaN\n",
       "1        2           stockton, california, usa  18.0\n",
       "2        3     moscow, yukon territory, russia   NaN\n",
       "3        4           porto, v.n.gaia, portugal  17.0\n",
       "4        5  farnborough, hants, united kingdom   NaN"
      ]
     },
     "execution_count": 334,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "users_df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6dc6b14e",
   "metadata": {},
   "source": [
    "# Printing total datasets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 335,
   "id": "a7086a59",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(271360, 4)\n",
      "(1149780, 3)\n",
      "(278858, 3)\n"
     ]
    }
   ],
   "source": [
    "print(books_df.shape)\n",
    "print(ratings_df.shape)\n",
    "print(users_df.shape)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "eb4ca985",
   "metadata": {},
   "source": [
    "#  The condition of this recommendation system is that the user must have rated  atleast 100 books and the book must have at least 100 ratings to be considered\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 336,
   "id": "6baf62da",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>User-ID</th>\n",
       "      <th>Location</th>\n",
       "      <th>Age</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>183</td>\n",
       "      <td>porto, porto, portugal</td>\n",
       "      <td>27.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>254</td>\n",
       "      <td>minneapolis, minnesota, usa</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>506</th>\n",
       "      <td>507</td>\n",
       "      <td>dumas, arkansas, usa</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>881</th>\n",
       "      <td>882</td>\n",
       "      <td>berkeley, california, usa</td>\n",
       "      <td>23.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1423</th>\n",
       "      <td>1424</td>\n",
       "      <td>north avoca, new south wales, australia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277477</th>\n",
       "      <td>277478</td>\n",
       "      <td>schiedam, zuid-holland, netherlands</td>\n",
       "      <td>31.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277638</th>\n",
       "      <td>277639</td>\n",
       "      <td>forsyth, montana, usa</td>\n",
       "      <td>48.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278136</th>\n",
       "      <td>278137</td>\n",
       "      <td>san antonio, texas, usa</td>\n",
       "      <td>27.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278187</th>\n",
       "      <td>278188</td>\n",
       "      <td>lake george, new york, usa</td>\n",
       "      <td>34.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278417</th>\n",
       "      <td>278418</td>\n",
       "      <td>omaha, nebraska, usa</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1847 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        User-ID                                 Location   Age\n",
       "182         183                   porto, porto, portugal  27.0\n",
       "253         254              minneapolis, minnesota, usa  24.0\n",
       "506         507                     dumas, arkansas, usa   NaN\n",
       "881         882                berkeley, california, usa  23.0\n",
       "1423       1424  north avoca, new south wales, australia   NaN\n",
       "...         ...                                      ...   ...\n",
       "277477   277478      schiedam, zuid-holland, netherlands  31.0\n",
       "277638   277639                    forsyth, montana, usa  48.0\n",
       "278136   278137                  san antonio, texas, usa  27.0\n",
       "278187   278188               lake george, new york, usa  34.0\n",
       "278417   278418                     omaha, nebraska, usa   NaN\n",
       "\n",
       "[1847 rows x 3 columns]"
      ]
     },
     "execution_count": 336,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Filter out users who have reviewed fewer than 100 books\n",
    "users_filtered = users_df[users_df['User-ID'].isin(ratings_df['User-ID'].value_counts()[ratings_df['User-ID'].value_counts() >= 100].index)]\n",
    "users_filtered \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 337,
   "id": "7c5efc92",
   "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>ISBN</th>\n",
       "      <th>Book-Title</th>\n",
       "      <th>Book-Author</th>\n",
       "      <th>Year-Of-Publication</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0440234743</td>\n",
       "      <td>The Testament</td>\n",
       "      <td>John Grisham</td>\n",
       "      <td>1999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0452264464</td>\n",
       "      <td>Beloved (Plume Contemporary Fiction)</td>\n",
       "      <td>Toni Morrison</td>\n",
       "      <td>1994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>0971880107</td>\n",
       "      <td>Wild Animus</td>\n",
       "      <td>Rich Shapero</td>\n",
       "      <td>2004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>0345402871</td>\n",
       "      <td>Airframe</td>\n",
       "      <td>Michael Crichton</td>\n",
       "      <td>1997</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0345417623</td>\n",
       "      <td>Timeline</td>\n",
       "      <td>MICHAEL CRICHTON</td>\n",
       "      <td>2000</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>28071</th>\n",
       "      <td>0425178765</td>\n",
       "      <td>Easy Prey</td>\n",
       "      <td>John Sandford</td>\n",
       "      <td>2001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29214</th>\n",
       "      <td>0449223604</td>\n",
       "      <td>M Is for Malice</td>\n",
       "      <td>Sue Grafton</td>\n",
       "      <td>1998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30534</th>\n",
       "      <td>0345444884</td>\n",
       "      <td>The Talisman</td>\n",
       "      <td>STEPHEN KING</td>\n",
       "      <td>2001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30774</th>\n",
       "      <td>0060008032</td>\n",
       "      <td>Angels</td>\n",
       "      <td>Marian Keyes</td>\n",
       "      <td>2003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35704</th>\n",
       "      <td>0515135739</td>\n",
       "      <td>Eleventh Hour: An FBI Thriller (FBI Thriller (...</td>\n",
       "      <td>Catherine Coulter</td>\n",
       "      <td>2004</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>727 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             ISBN                                         Book-Title  \\\n",
       "18     0440234743                                      The Testament   \n",
       "19     0452264464               Beloved (Plume Contemporary Fiction)   \n",
       "26     0971880107                                        Wild Animus   \n",
       "27     0345402871                                           Airframe   \n",
       "28     0345417623                                           Timeline   \n",
       "...           ...                                                ...   \n",
       "28071  0425178765                                          Easy Prey   \n",
       "29214  0449223604                                    M Is for Malice   \n",
       "30534  0345444884                                       The Talisman   \n",
       "30774  0060008032                                             Angels   \n",
       "35704  0515135739  Eleventh Hour: An FBI Thriller (FBI Thriller (...   \n",
       "\n",
       "             Book-Author Year-Of-Publication  \n",
       "18          John Grisham                1999  \n",
       "19         Toni Morrison                1994  \n",
       "26          Rich Shapero                2004  \n",
       "27      Michael Crichton                1997  \n",
       "28      MICHAEL CRICHTON                2000  \n",
       "...                  ...                 ...  \n",
       "28071      John Sandford                2001  \n",
       "29214        Sue Grafton                1998  \n",
       "30534       STEPHEN KING                2001  \n",
       "30774       Marian Keyes                2003  \n",
       "35704  Catherine Coulter                2004  \n",
       "\n",
       "[727 rows x 4 columns]"
      ]
     },
     "execution_count": 337,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Filter out books that have fewer than 100 reviews\n",
    "books_filtered = books_df[books_df['ISBN'].isin(ratings_df['ISBN'].value_counts()[ratings_df['ISBN'].value_counts() >= 100].index)]\n",
    "books_filtered\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "16bd8e49",
   "metadata": {},
   "source": [
    "#  Merging the datasets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 338,
   "id": "567c779c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>User-ID</th>\n",
       "      <th>Location</th>\n",
       "      <th>Age</th>\n",
       "      <th>ISBN</th>\n",
       "      <th>Book-Rating</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>183</td>\n",
       "      <td>porto, porto, portugal</td>\n",
       "      <td>27.0</td>\n",
       "      <td>058608195X</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>183</td>\n",
       "      <td>porto, porto, portugal</td>\n",
       "      <td>27.0</td>\n",
       "      <td>100940/86</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>183</td>\n",
       "      <td>porto, porto, portugal</td>\n",
       "      <td>27.0</td>\n",
       "      <td>10622/86</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>183</td>\n",
       "      <td>porto, porto, portugal</td>\n",
       "      <td>27.0</td>\n",
       "      <td>10745/85</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>183</td>\n",
       "      <td>porto, porto, portugal</td>\n",
       "      <td>27.0</td>\n",
       "      <td>10756/85</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>658800</th>\n",
       "      <td>278418</td>\n",
       "      <td>omaha, nebraska, usa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5008601364</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>658801</th>\n",
       "      <td>278418</td>\n",
       "      <td>omaha, nebraska, usa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5008602064</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>658802</th>\n",
       "      <td>278418</td>\n",
       "      <td>omaha, nebraska, usa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>528826859</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>658803</th>\n",
       "      <td>278418</td>\n",
       "      <td>omaha, nebraska, usa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>684124645</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>658804</th>\n",
       "      <td>278418</td>\n",
       "      <td>omaha, nebraska, usa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9446617058</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>658805 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        User-ID                Location   Age        ISBN  Book-Rating\n",
       "0           183  porto, porto, portugal  27.0  058608195X            0\n",
       "1           183  porto, porto, portugal  27.0   100940/86            9\n",
       "2           183  porto, porto, portugal  27.0    10622/86            0\n",
       "3           183  porto, porto, portugal  27.0    10745/85            0\n",
       "4           183  porto, porto, portugal  27.0    10756/85            0\n",
       "...         ...                     ...   ...         ...          ...\n",
       "658800   278418    omaha, nebraska, usa   NaN  5008601364            0\n",
       "658801   278418    omaha, nebraska, usa   NaN  5008602064            0\n",
       "658802   278418    omaha, nebraska, usa   NaN   528826859            0\n",
       "658803   278418    omaha, nebraska, usa   NaN   684124645            0\n",
       "658804   278418    omaha, nebraska, usa   NaN  9446617058            0\n",
       "\n",
       "[658805 rows x 5 columns]"
      ]
     },
     "execution_count": 338,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Merge the filtered users and ratings dataframes\n",
    "ratings_filtered = pd.merge(users_filtered, ratings_df, on='User-ID')\n",
    "ratings_filtered"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 339,
   "id": "e0909c3c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>User-ID</th>\n",
       "      <th>Location</th>\n",
       "      <th>Age</th>\n",
       "      <th>ISBN</th>\n",
       "      <th>Book-Rating</th>\n",
       "      <th>Book-Title</th>\n",
       "      <th>Book-Author</th>\n",
       "      <th>Year-Of-Publication</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>254</td>\n",
       "      <td>minneapolis, minnesota, usa</td>\n",
       "      <td>24.0</td>\n",
       "      <td>0060930535</td>\n",
       "      <td>0</td>\n",
       "      <td>The Poisonwood Bible: A Novel</td>\n",
       "      <td>Barbara Kingsolver</td>\n",
       "      <td>1999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1424</td>\n",
       "      <td>north avoca, new south wales, australia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0060930535</td>\n",
       "      <td>7</td>\n",
       "      <td>The Poisonwood Bible: A Novel</td>\n",
       "      <td>Barbara Kingsolver</td>\n",
       "      <td>1999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2891</td>\n",
       "      <td>beaverton, oregon, usa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0060930535</td>\n",
       "      <td>0</td>\n",
       "      <td>The Poisonwood Bible: A Novel</td>\n",
       "      <td>Barbara Kingsolver</td>\n",
       "      <td>1999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5903</td>\n",
       "      <td>vienna, vienna, austria</td>\n",
       "      <td>25.0</td>\n",
       "      <td>0060930535</td>\n",
       "      <td>0</td>\n",
       "      <td>The Poisonwood Bible: A Novel</td>\n",
       "      <td>Barbara Kingsolver</td>\n",
       "      <td>1999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6251</td>\n",
       "      <td>wahiawa, hawaii, usa</td>\n",
       "      <td>32.0</td>\n",
       "      <td>0060930535</td>\n",
       "      <td>0</td>\n",
       "      <td>The Poisonwood Bible: A Novel</td>\n",
       "      <td>Barbara Kingsolver</td>\n",
       "      <td>1999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65518</th>\n",
       "      <td>263460</td>\n",
       "      <td>tampa, florida, usa</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0671867156</td>\n",
       "      <td>0</td>\n",
       "      <td>Pretend You Don't See Her</td>\n",
       "      <td>Mary Higgins Clark</td>\n",
       "      <td>1998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65519</th>\n",
       "      <td>269566</td>\n",
       "      <td>seattle, washington, usa</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0671867156</td>\n",
       "      <td>0</td>\n",
       "      <td>Pretend You Don't See Her</td>\n",
       "      <td>Mary Higgins Clark</td>\n",
       "      <td>1998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65520</th>\n",
       "      <td>271284</td>\n",
       "      <td>alexandria, virginia, usa</td>\n",
       "      <td>50.0</td>\n",
       "      <td>0671867156</td>\n",
       "      <td>0</td>\n",
       "      <td>Pretend You Don't See Her</td>\n",
       "      <td>Mary Higgins Clark</td>\n",
       "      <td>1998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65521</th>\n",
       "      <td>273979</td>\n",
       "      <td>bloomsburg, pennsylvania, usa</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0671867156</td>\n",
       "      <td>0</td>\n",
       "      <td>Pretend You Don't See Her</td>\n",
       "      <td>Mary Higgins Clark</td>\n",
       "      <td>1998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65522</th>\n",
       "      <td>274308</td>\n",
       "      <td>delray beach, florida, usa</td>\n",
       "      <td>33.0</td>\n",
       "      <td>0671867156</td>\n",
       "      <td>0</td>\n",
       "      <td>Pretend You Don't See Her</td>\n",
       "      <td>Mary Higgins Clark</td>\n",
       "      <td>1998</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>65523 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       User-ID                                 Location   Age        ISBN  \\\n",
       "0          254              minneapolis, minnesota, usa  24.0  0060930535   \n",
       "1         1424  north avoca, new south wales, australia   NaN  0060930535   \n",
       "2         2891                   beaverton, oregon, usa   NaN  0060930535   \n",
       "3         5903                  vienna, vienna, austria  25.0  0060930535   \n",
       "4         6251                     wahiawa, hawaii, usa  32.0  0060930535   \n",
       "...        ...                                      ...   ...         ...   \n",
       "65518   263460                      tampa, florida, usa  31.0  0671867156   \n",
       "65519   269566                 seattle, washington, usa   9.0  0671867156   \n",
       "65520   271284                alexandria, virginia, usa  50.0  0671867156   \n",
       "65521   273979            bloomsburg, pennsylvania, usa  20.0  0671867156   \n",
       "65522   274308               delray beach, florida, usa  33.0  0671867156   \n",
       "\n",
       "       Book-Rating                     Book-Title         Book-Author  \\\n",
       "0                0  The Poisonwood Bible: A Novel  Barbara Kingsolver   \n",
       "1                7  The Poisonwood Bible: A Novel  Barbara Kingsolver   \n",
       "2                0  The Poisonwood Bible: A Novel  Barbara Kingsolver   \n",
       "3                0  The Poisonwood Bible: A Novel  Barbara Kingsolver   \n",
       "4                0  The Poisonwood Bible: A Novel  Barbara Kingsolver   \n",
       "...            ...                            ...                 ...   \n",
       "65518            0      Pretend You Don't See Her  Mary Higgins Clark   \n",
       "65519            0      Pretend You Don't See Her  Mary Higgins Clark   \n",
       "65520            0      Pretend You Don't See Her  Mary Higgins Clark   \n",
       "65521            0      Pretend You Don't See Her  Mary Higgins Clark   \n",
       "65522            0      Pretend You Don't See Her  Mary Higgins Clark   \n",
       "\n",
       "      Year-Of-Publication  \n",
       "0                    1999  \n",
       "1                    1999  \n",
       "2                    1999  \n",
       "3                    1999  \n",
       "4                    1999  \n",
       "...                   ...  \n",
       "65518                1998  \n",
       "65519                1998  \n",
       "65520                1998  \n",
       "65521                1998  \n",
       "65522                1998  \n",
       "\n",
       "[65523 rows x 8 columns]"
      ]
     },
     "execution_count": 339,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Merge the filtered ratings and books dataframes\n",
    "df = pd.merge(ratings_filtered, books_filtered, on='ISBN')\n",
    "df\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2ba4ab5d",
   "metadata": {},
   "source": [
    "# Create pivot table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 340,
   "id": "d5511aaf",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create a pivot table of users and books, with ratings as the values\n",
    "user_item_matrix = df.pivot_table(index='User-ID', columns='Book-Title', values='Book-Rating')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 341,
   "id": "6c2708fe",
   "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>Book-Title</th>\n",
       "      <th>1984</th>\n",
       "      <th>1st to Die: A Novel</th>\n",
       "      <th>2nd Chance</th>\n",
       "      <th>4 Blondes</th>\n",
       "      <th>A Beautiful Mind: The Life of Mathematical Genius and Nobel Laureate John Nash</th>\n",
       "      <th>A Bend in the Road</th>\n",
       "      <th>A Case of Need</th>\n",
       "      <th>A Child Called \\It\\\": One Child's Courage to Survive\"</th>\n",
       "      <th>A Civil Action</th>\n",
       "      <th>A Confederacy of Dunces (Evergreen Book)</th>\n",
       "      <th>...</th>\n",
       "      <th>Wicked: The Life and Times of the Wicked Witch of the West</th>\n",
       "      <th>Wifey</th>\n",
       "      <th>Wild Animus</th>\n",
       "      <th>Winter Moon</th>\n",
       "      <th>Wish You Well</th>\n",
       "      <th>Without Remorse</th>\n",
       "      <th>Year of Wonders</th>\n",
       "      <th>You Belong To Me</th>\n",
       "      <th>Zen and the Art of Motorcycle Maintenance: An Inquiry into Values</th>\n",
       "      <th>\\O\\\" Is for Outlaw\"</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>254</th>\n",
       "      <td>9.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>507</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>882</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>1424</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>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1435</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>7.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>5.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>277478</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>277639</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>278137</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>278188</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>278418</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>1776 rows × 673 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Book-Title  1984  1st to Die: A Novel  2nd Chance  4 Blondes  \\\n",
       "User-ID                                                        \n",
       "254          9.0                  0.0         0.0        0.0   \n",
       "507          0.0                  0.0         0.0        0.0   \n",
       "882          0.0                  0.0         0.0        0.0   \n",
       "1424         0.0                  0.0         0.0        0.0   \n",
       "1435         0.0                  0.0         0.0        0.0   \n",
       "...          ...                  ...         ...        ...   \n",
       "277478       0.0                  0.0         0.0        0.0   \n",
       "277639       0.0                  0.0         0.0        0.0   \n",
       "278137       0.0                  0.0         0.0        0.0   \n",
       "278188       0.0                  0.0         0.0        0.0   \n",
       "278418       0.0                  0.0         0.0        0.0   \n",
       "\n",
       "Book-Title  A Beautiful Mind: The Life of Mathematical Genius and Nobel Laureate John Nash  \\\n",
       "User-ID                                                                                      \n",
       "254                                                       0.0                                \n",
       "507                                                       0.0                                \n",
       "882                                                       0.0                                \n",
       "1424                                                      0.0                                \n",
       "1435                                                      0.0                                \n",
       "...                                                       ...                                \n",
       "277478                                                    0.0                                \n",
       "277639                                                    0.0                                \n",
       "278137                                                    0.0                                \n",
       "278188                                                    0.0                                \n",
       "278418                                                    0.0                                \n",
       "\n",
       "Book-Title  A Bend in the Road  A Case of Need  \\\n",
       "User-ID                                          \n",
       "254                        0.0             0.0   \n",
       "507                        0.0             0.0   \n",
       "882                        0.0             0.0   \n",
       "1424                       0.0             0.0   \n",
       "1435                       0.0             7.0   \n",
       "...                        ...             ...   \n",
       "277478                     0.0             0.0   \n",
       "277639                     0.0             0.0   \n",
       "278137                     0.0             0.0   \n",
       "278188                     0.0             0.0   \n",
       "278418                     0.0             0.0   \n",
       "\n",
       "Book-Title  A Child Called \\It\\\": One Child's Courage to Survive\"  \\\n",
       "User-ID                                                             \n",
       "254                                                       0.0       \n",
       "507                                                       0.0       \n",
       "882                                                       0.0       \n",
       "1424                                                      0.0       \n",
       "1435                                                      0.0       \n",
       "...                                                       ...       \n",
       "277478                                                    0.0       \n",
       "277639                                                    0.0       \n",
       "278137                                                    0.0       \n",
       "278188                                                    0.0       \n",
       "278418                                                    0.0       \n",
       "\n",
       "Book-Title  A Civil Action  A Confederacy of Dunces (Evergreen Book)  ...  \\\n",
       "User-ID                                                               ...   \n",
       "254                    0.0                                       0.0  ...   \n",
       "507                    0.0                                       0.0  ...   \n",
       "882                    0.0                                       0.0  ...   \n",
       "1424                   0.0                                       0.0  ...   \n",
       "1435                   0.0                                       0.0  ...   \n",
       "...                    ...                                       ...  ...   \n",
       "277478                 0.0                                       0.0  ...   \n",
       "277639                 0.0                                       0.0  ...   \n",
       "278137                 0.0                                       0.0  ...   \n",
       "278188                 0.0                                       0.0  ...   \n",
       "278418                 0.0                                       0.0  ...   \n",
       "\n",
       "Book-Title  Wicked: The Life and Times of the Wicked Witch of the West  Wifey  \\\n",
       "User-ID                                                                         \n",
       "254                                                       0.0             0.0   \n",
       "507                                                       0.0             0.0   \n",
       "882                                                       0.0             0.0   \n",
       "1424                                                      0.0             0.0   \n",
       "1435                                                      0.0             0.0   \n",
       "...                                                       ...             ...   \n",
       "277478                                                    0.0             0.0   \n",
       "277639                                                    0.0             0.0   \n",
       "278137                                                    0.0             0.0   \n",
       "278188                                                    0.0             0.0   \n",
       "278418                                                    0.0             0.0   \n",
       "\n",
       "Book-Title  Wild Animus  Winter Moon  Wish You Well  Without Remorse  \\\n",
       "User-ID                                                                \n",
       "254                 0.0          0.0            0.0              0.0   \n",
       "507                 0.0          0.0            0.0              0.0   \n",
       "882                 0.0          0.0            0.0              0.0   \n",
       "1424                0.0          0.0            0.0              0.0   \n",
       "1435                5.0          0.0            0.0              0.0   \n",
       "...                 ...          ...            ...              ...   \n",
       "277478              0.0          0.0            0.0              0.0   \n",
       "277639              0.0          0.0            0.0              0.0   \n",
       "278137              0.0          0.0            0.0              0.0   \n",
       "278188              0.0          0.0            0.0              0.0   \n",
       "278418              0.0          0.0            0.0              0.0   \n",
       "\n",
       "Book-Title  Year of Wonders  You Belong To Me  \\\n",
       "User-ID                                         \n",
       "254                     0.0               0.0   \n",
       "507                     0.0               0.0   \n",
       "882                     0.0               0.0   \n",
       "1424                    7.0               0.0   \n",
       "1435                    0.0               0.0   \n",
       "...                     ...               ...   \n",
       "277478                  0.0               0.0   \n",
       "277639                  0.0               0.0   \n",
       "278137                  0.0               0.0   \n",
       "278188                  0.0               0.0   \n",
       "278418                  0.0               0.0   \n",
       "\n",
       "Book-Title  Zen and the Art of Motorcycle Maintenance: An Inquiry into Values  \\\n",
       "User-ID                                                                         \n",
       "254                                                       0.0                   \n",
       "507                                                       0.0                   \n",
       "882                                                       0.0                   \n",
       "1424                                                      0.0                   \n",
       "1435                                                      0.0                   \n",
       "...                                                       ...                   \n",
       "277478                                                    0.0                   \n",
       "277639                                                    0.0                   \n",
       "278137                                                    0.0                   \n",
       "278188                                                    0.0                   \n",
       "278418                                                    0.0                   \n",
       "\n",
       "Book-Title  \\O\\\" Is for Outlaw\"  \n",
       "User-ID                          \n",
       "254                         0.0  \n",
       "507                         0.0  \n",
       "882                         0.0  \n",
       "1424                        0.0  \n",
       "1435                        0.0  \n",
       "...                         ...  \n",
       "277478                      0.0  \n",
       "277639                      0.0  \n",
       "278137                      0.0  \n",
       "278188                      0.0  \n",
       "278418                      0.0  \n",
       "\n",
       "[1776 rows x 673 columns]"
      ]
     },
     "execution_count": 341,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "user_item_matrix.fillna(0,inplace=True)\n",
    "user_item_matrix\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "32a66a3b",
   "metadata": {},
   "source": [
    "# calculate cosine similarilty"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 342,
   "id": "81ab52ce",
   "metadata": {},
   "outputs": [],
   "source": [
    "#import cosine_similarity\n",
    "from sklearn.metrics.pairwise import cosine_similarity\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 343,
   "id": "63999647",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[1.        , 0.22016014, 0.        , ..., 0.        , 0.        ,\n",
       "        0.        ],\n",
       "       [0.22016014, 1.        , 0.        , ..., 0.        , 0.        ,\n",
       "        0.        ],\n",
       "       [0.        , 0.        , 1.        , ..., 0.        , 0.        ,\n",
       "        0.        ],\n",
       "       ...,\n",
       "       [0.        , 0.        , 0.        , ..., 1.        , 0.        ,\n",
       "        0.        ],\n",
       "       [0.        , 0.        , 0.        , ..., 0.        , 1.        ,\n",
       "        0.        ],\n",
       "       [0.        , 0.        , 0.        , ..., 0.        , 0.        ,\n",
       "        1.        ]])"
      ]
     },
     "execution_count": 343,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Compute the cosine similarity between users\n",
    "similarity = cosine_similarity(user_item_matrix)\n",
    "\n",
    "similarity\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 344,
   "id": "6b558ffc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1776, 1776)"
      ]
     },
     "execution_count": 344,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "similarity.shape\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fb455cfb",
   "metadata": {},
   "source": [
    "# Main recommendation function"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 409,
   "id": "cb33a1da",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to get the top n similar books for a given book\n",
    "def recommend_book(user_id, num_books):\n",
    "    #  Get the index of the user in the users list\n",
    "    user_index = user_item_matrix.index.get_loc(user_id)\n",
    "    # Get the ratings of the user\n",
    "    user_ratings = user_item_matrix.iloc[user_index].dropna()\n",
    "\n",
    "    # Compute the similarity of the user with all other users\n",
    "    similar_users = similarity[user_index]\n",
    "\n",
    "    # Get the indices of the most similar users\n",
    "    most_similar_users = similar_users.argsort()[::-1][1:]\n",
    "    \n",
    "    \n",
    "    # Get the ratings of the most similar users\n",
    "    most_similar_ratings = user_item_matrix.iloc[most_similar_users]\n",
    "\n",
    "    # Get the sum of the similarity of the user with the most similar users\n",
    "    sum_similarities = similar_users[most_similar_users].sum()\n",
    "\n",
    "    # Initialize a list to store the recommended books\n",
    "    recommendations = []\n",
    "\n",
    "    # Iterate through the user's ratings and add the weighted rating of each book to the list\n",
    "    for rating in user_ratings.index:\n",
    "        # Get the weight of the rating (the similarity of the user with the most similar users who rated the book)\n",
    "        weight = similar_users[most_similar_users][most_similar_ratings[rating].notnull()].sum() / sum_similarities\n",
    "\n",
    "        # Get the weighted rating of the book and add it to the list\n",
    "        recommendations.append((rating, user_ratings[rating] * weight))\n",
    "\n",
    "        # Sort the list of recommendations in descending order\n",
    "        recommendations = sorted(recommendations, key=lambda x: x[1], reverse=True)\n",
    "\n",
    "    # Return the top n recommendations\n",
    "    return recommendations[:num_books]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a1885b66",
   "metadata": {},
   "source": [
    "# Output"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 411,
   "id": "7c314001",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('American Gods', 10.0),\n",
       " ('1984', 9.0),\n",
       " ('Harry Potter and the Chamber of Secrets (Book 2)', 9.0),\n",
       " ('Harry Potter and the Goblet of Fire (Book 4)', 9.0),\n",
       " ('Harry Potter and the Prisoner of Azkaban (Book 3)', 9.0)]"
      ]
     },
     "execution_count": 411,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "recommend_book(254, 5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4bd274e0",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "37242019",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "47b14ab2",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ffb63e75",
   "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.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}