Book Recommender System.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "39635389",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\hicks\\AppData\\Local\\Temp\\ipykernel_22124\\2717951682.py:3: DtypeWarning: Columns (3) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  df = pd.read_csv('BX-Books.csv',on_bad_lines=\"skip\",encoding='latin-1',sep=';')\n"
     ]
    },
    {
     "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",
       "      <th>Publisher</th>\n",
       "      <th>Image-URL-S</th>\n",
       "      <th>Image-URL-M</th>\n",
       "      <th>Image-URL-L</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",
       "      <td>Oxford University Press</td>\n",
       "      <td>http://images.amazon.com/images/P/0195153448.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0195153448.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0195153448.0...</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",
       "      <td>HarperFlamingo Canada</td>\n",
       "      <td>http://images.amazon.com/images/P/0002005018.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0002005018.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0002005018.0...</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",
       "      <td>HarperPerennial</td>\n",
       "      <td>http://images.amazon.com/images/P/0060973129.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0060973129.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0060973129.0...</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",
       "      <td>Farrar Straus Giroux</td>\n",
       "      <td>http://images.amazon.com/images/P/0374157065.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0374157065.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0374157065.0...</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",
       "      <td>W. W. Norton &amp;amp; Company</td>\n",
       "      <td>http://images.amazon.com/images/P/0393045218.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0393045218.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0393045218.0...</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                   Publisher  \\\n",
       "0    Mark P. O. Morford                2002     Oxford University Press   \n",
       "1  Richard Bruce Wright                2001       HarperFlamingo Canada   \n",
       "2          Carlo D'Este                1991             HarperPerennial   \n",
       "3      Gina Bari Kolata                1999        Farrar Straus Giroux   \n",
       "4       E. J. W. Barber                1999  W. W. Norton &amp; Company   \n",
       "\n",
       "                                         Image-URL-S  \\\n",
       "0  http://images.amazon.com/images/P/0195153448.0...   \n",
       "1  http://images.amazon.com/images/P/0002005018.0...   \n",
       "2  http://images.amazon.com/images/P/0060973129.0...   \n",
       "3  http://images.amazon.com/images/P/0374157065.0...   \n",
       "4  http://images.amazon.com/images/P/0393045218.0...   \n",
       "\n",
       "                                         Image-URL-M  \\\n",
       "0  http://images.amazon.com/images/P/0195153448.0...   \n",
       "1  http://images.amazon.com/images/P/0002005018.0...   \n",
       "2  http://images.amazon.com/images/P/0060973129.0...   \n",
       "3  http://images.amazon.com/images/P/0374157065.0...   \n",
       "4  http://images.amazon.com/images/P/0393045218.0...   \n",
       "\n",
       "                                         Image-URL-L  \n",
       "0  http://images.amazon.com/images/P/0195153448.0...  \n",
       "1  http://images.amazon.com/images/P/0002005018.0...  \n",
       "2  http://images.amazon.com/images/P/0060973129.0...  \n",
       "3  http://images.amazon.com/images/P/0374157065.0...  \n",
       "4  http://images.amazon.com/images/P/0393045218.0...  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df = pd.read_csv('BX-Books.csv',on_bad_lines=\"skip\",encoding='latin-1',sep=';')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "b8fbc6d4",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 271360 entries, 0 to 271359\n",
      "Data columns (total 8 columns):\n",
      " #   Column               Non-Null Count   Dtype \n",
      "---  ------               --------------   ----- \n",
      " 0   ISBN                 271360 non-null  object\n",
      " 1   Book-Title           271360 non-null  object\n",
      " 2   Book-Author          271359 non-null  object\n",
      " 3   Year-Of-Publication  271360 non-null  object\n",
      " 4   Publisher            271358 non-null  object\n",
      " 5   Image-URL-S          271360 non-null  object\n",
      " 6   Image-URL-M          271360 non-null  object\n",
      " 7   Image-URL-L          271357 non-null  object\n",
      "dtypes: object(8)\n",
      "memory usage: 16.6+ MB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "0f91721a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "29225"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.duplicated(subset='Book-Title').sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "045145d5",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.drop_duplicates(subset='Book-Title')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "a5b3f292",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.duplicated(subset='Book-Title').sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "b30e5679",
   "metadata": {},
   "outputs": [],
   "source": [
    "sample_size = 15000\n",
    "df = df.sample(n=sample_size, replace=False, random_state=490)\n",
    "\n",
    "df = df.reset_index()\n",
    "df = df.drop('index',axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "611b4e3b",
   "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",
       "      <th>Publisher</th>\n",
       "      <th>Image-URL-S</th>\n",
       "      <th>Image-URL-M</th>\n",
       "      <th>Image-URL-L</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0060972491</td>\n",
       "      <td>Thank You, Jeeves</td>\n",
       "      <td>P.G. Wodehouse</td>\n",
       "      <td>1989</td>\n",
       "      <td>Perennial</td>\n",
       "      <td>http://images.amazon.com/images/P/0060972491.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0060972491.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0060972491.0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>015602781X</td>\n",
       "      <td>Pincher Martin: The Two Deaths of Christopher ...</td>\n",
       "      <td>William Golding</td>\n",
       "      <td>2002</td>\n",
       "      <td>Harvest Books</td>\n",
       "      <td>http://images.amazon.com/images/P/015602781X.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/015602781X.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/015602781X.0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1561441627</td>\n",
       "      <td>The Nutcracker (Christmas Fun-to-Read Fairy Ta...</td>\n",
       "      <td>Roberta Collier-Morales</td>\n",
       "      <td>1992</td>\n",
       "      <td>Modern Publishing</td>\n",
       "      <td>http://images.amazon.com/images/P/1561441627.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/1561441627.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/1561441627.0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1402708610</td>\n",
       "      <td>I Know a Rhino</td>\n",
       "      <td>Charles Fuge</td>\n",
       "      <td>2003</td>\n",
       "      <td>Sterling</td>\n",
       "      <td>http://images.amazon.com/images/P/1402708610.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/1402708610.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/1402708610.0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0441586325</td>\n",
       "      <td>Norby and the Oldest Dragon</td>\n",
       "      <td>Janet Asimov</td>\n",
       "      <td>1993</td>\n",
       "      <td>Ace Books</td>\n",
       "      <td>http://images.amazon.com/images/P/0441586325.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0441586325.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0441586325.0...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         ISBN                                         Book-Title  \\\n",
       "0  0060972491                                  Thank You, Jeeves   \n",
       "1  015602781X  Pincher Martin: The Two Deaths of Christopher ...   \n",
       "2  1561441627  The Nutcracker (Christmas Fun-to-Read Fairy Ta...   \n",
       "3  1402708610                                     I Know a Rhino   \n",
       "4  0441586325                        Norby and the Oldest Dragon   \n",
       "\n",
       "               Book-Author Year-Of-Publication          Publisher  \\\n",
       "0           P.G. Wodehouse                1989          Perennial   \n",
       "1          William Golding                2002      Harvest Books   \n",
       "2  Roberta Collier-Morales                1992  Modern Publishing   \n",
       "3             Charles Fuge                2003           Sterling   \n",
       "4             Janet Asimov                1993          Ace Books   \n",
       "\n",
       "                                         Image-URL-S  \\\n",
       "0  http://images.amazon.com/images/P/0060972491.0...   \n",
       "1  http://images.amazon.com/images/P/015602781X.0...   \n",
       "2  http://images.amazon.com/images/P/1561441627.0...   \n",
       "3  http://images.amazon.com/images/P/1402708610.0...   \n",
       "4  http://images.amazon.com/images/P/0441586325.0...   \n",
       "\n",
       "                                         Image-URL-M  \\\n",
       "0  http://images.amazon.com/images/P/0060972491.0...   \n",
       "1  http://images.amazon.com/images/P/015602781X.0...   \n",
       "2  http://images.amazon.com/images/P/1561441627.0...   \n",
       "3  http://images.amazon.com/images/P/1402708610.0...   \n",
       "4  http://images.amazon.com/images/P/0441586325.0...   \n",
       "\n",
       "                                         Image-URL-L  \n",
       "0  http://images.amazon.com/images/P/0060972491.0...  \n",
       "1  http://images.amazon.com/images/P/015602781X.0...  \n",
       "2  http://images.amazon.com/images/P/1561441627.0...  \n",
       "3  http://images.amazon.com/images/P/1402708610.0...  \n",
       "4  http://images.amazon.com/images/P/0441586325.0...  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "c80985fb",
   "metadata": {},
   "outputs": [],
   "source": [
    "def clean_text(author):\n",
    "    result = str(author).lower()\n",
    "    return(result.replace(' ',''))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "522a5edb",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Book-Author'] = df['Book-Author'].apply(clean_text)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "b23a7d05",
   "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",
       "      <th>Publisher</th>\n",
       "      <th>Image-URL-S</th>\n",
       "      <th>Image-URL-M</th>\n",
       "      <th>Image-URL-L</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0060972491</td>\n",
       "      <td>Thank You, Jeeves</td>\n",
       "      <td>p.g.wodehouse</td>\n",
       "      <td>1989</td>\n",
       "      <td>Perennial</td>\n",
       "      <td>http://images.amazon.com/images/P/0060972491.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0060972491.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0060972491.0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>015602781X</td>\n",
       "      <td>Pincher Martin: The Two Deaths of Christopher ...</td>\n",
       "      <td>williamgolding</td>\n",
       "      <td>2002</td>\n",
       "      <td>Harvest Books</td>\n",
       "      <td>http://images.amazon.com/images/P/015602781X.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/015602781X.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/015602781X.0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1561441627</td>\n",
       "      <td>The Nutcracker (Christmas Fun-to-Read Fairy Ta...</td>\n",
       "      <td>robertacollier-morales</td>\n",
       "      <td>1992</td>\n",
       "      <td>Modern Publishing</td>\n",
       "      <td>http://images.amazon.com/images/P/1561441627.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/1561441627.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/1561441627.0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1402708610</td>\n",
       "      <td>I Know a Rhino</td>\n",
       "      <td>charlesfuge</td>\n",
       "      <td>2003</td>\n",
       "      <td>Sterling</td>\n",
       "      <td>http://images.amazon.com/images/P/1402708610.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/1402708610.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/1402708610.0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0441586325</td>\n",
       "      <td>Norby and the Oldest Dragon</td>\n",
       "      <td>janetasimov</td>\n",
       "      <td>1993</td>\n",
       "      <td>Ace Books</td>\n",
       "      <td>http://images.amazon.com/images/P/0441586325.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0441586325.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0441586325.0...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         ISBN                                         Book-Title  \\\n",
       "0  0060972491                                  Thank You, Jeeves   \n",
       "1  015602781X  Pincher Martin: The Two Deaths of Christopher ...   \n",
       "2  1561441627  The Nutcracker (Christmas Fun-to-Read Fairy Ta...   \n",
       "3  1402708610                                     I Know a Rhino   \n",
       "4  0441586325                        Norby and the Oldest Dragon   \n",
       "\n",
       "              Book-Author Year-Of-Publication          Publisher  \\\n",
       "0           p.g.wodehouse                1989          Perennial   \n",
       "1          williamgolding                2002      Harvest Books   \n",
       "2  robertacollier-morales                1992  Modern Publishing   \n",
       "3             charlesfuge                2003           Sterling   \n",
       "4             janetasimov                1993          Ace Books   \n",
       "\n",
       "                                         Image-URL-S  \\\n",
       "0  http://images.amazon.com/images/P/0060972491.0...   \n",
       "1  http://images.amazon.com/images/P/015602781X.0...   \n",
       "2  http://images.amazon.com/images/P/1561441627.0...   \n",
       "3  http://images.amazon.com/images/P/1402708610.0...   \n",
       "4  http://images.amazon.com/images/P/0441586325.0...   \n",
       "\n",
       "                                         Image-URL-M  \\\n",
       "0  http://images.amazon.com/images/P/0060972491.0...   \n",
       "1  http://images.amazon.com/images/P/015602781X.0...   \n",
       "2  http://images.amazon.com/images/P/1561441627.0...   \n",
       "3  http://images.amazon.com/images/P/1402708610.0...   \n",
       "4  http://images.amazon.com/images/P/0441586325.0...   \n",
       "\n",
       "                                         Image-URL-L  \n",
       "0  http://images.amazon.com/images/P/0060972491.0...  \n",
       "1  http://images.amazon.com/images/P/015602781X.0...  \n",
       "2  http://images.amazon.com/images/P/1561441627.0...  \n",
       "3  http://images.amazon.com/images/P/1402708610.0...  \n",
       "4  http://images.amazon.com/images/P/0441586325.0...  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "4ab501c3",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Book-Title'] = df['Book-Title'].str.lower()\n",
    "df['Publisher'] = df['Publisher'].str.lower()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "cd1a3e42",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0                     p.g.wodehouse perennial\n",
      "1                williamgolding harvest books\n",
      "2    robertacollier-morales modern publishing\n",
      "3                        charlesfuge sterling\n",
      "4                       janetasimov ace books\n",
      "Name: data, dtype: object\n"
     ]
    }
   ],
   "source": [
    "df2 = df.drop(['ISBN','Image-URL-S','Image-URL-M','Image-URL-L','Year-Of-Publication'],axis=1)\n",
    "\n",
    "df2['data'] = df2[df2.columns[1:]].apply(\n",
    "    lambda x: ' '.join(x.dropna().astype(str)),\n",
    "    axis=1\n",
    ")\n",
    "\n",
    "print(df2['data'].head())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "da1ef5a0",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.feature_extraction.text import CountVectorizer\n",
    "\n",
    "vectorizer = CountVectorizer()\n",
    "vectorized = vectorizer.fit_transform(df2['data'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "836f3f7b",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.metrics.pairwise import cosine_similarity\n",
    "\n",
    "similarities = cosine_similarity(vectorized)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "2ec0195f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[[1. 0. 0. ... 0. 0. 0.]\n",
      " [0. 1. 0. ... 0. 0. 0.]\n",
      " [0. 0. 1. ... 0. 0. 0.]\n",
      " ...\n",
      " [0. 0. 0. ... 1. 0. 0.]\n",
      " [0. 0. 0. ... 0. 1. 0.]\n",
      " [0. 0. 0. ... 0. 0. 1.]]\n"
     ]
    }
   ],
   "source": [
    "print(similarities)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "e7e1bedf",
   "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>Book-Title</th>\n",
       "      <th>thank you, jeeves</th>\n",
       "      <th>pincher martin: the two deaths of christopher martin</th>\n",
       "      <th>the nutcracker (christmas fun-to-read fairy tales ser)</th>\n",
       "      <th>i know a rhino</th>\n",
       "      <th>norby and the oldest dragon</th>\n",
       "      <th>his eminence and hizzoner</th>\n",
       "      <th>el oro de los sueã±os (leer en espaã±ol nivel 4)</th>\n",
       "      <th>celestine insights</th>\n",
       "      <th>feng shui and money: a nine-week program for creating wealth using ancient principles and techniques</th>\n",
       "      <th>...</th>\n",
       "      <th>the santa suit (harlequin american romance, no. 708)</th>\n",
       "      <th>where the gods reign: plants and peoples of the colombian amazon</th>\n",
       "      <th>the terrible troll-bird</th>\n",
       "      <th>virginia embrace (magnolia road)</th>\n",
       "      <th>take 5, volume 4 (under the knife, adam's gift, return to yesterday, everything but time, marriage diamond style)</th>\n",
       "      <th>taking the anxiety out of taking tests: a step-by-step guide</th>\n",
       "      <th>encyclopedia of women's health issues</th>\n",
       "      <th>fodor's 2002 new york city (fodor's new york city)</th>\n",
       "      <th>c. s. lewis: a biography,revised edition</th>\n",
       "      <th>the late night muse: a novel</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>thank you, jeeves</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</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</th>\n",
       "      <td>pincher martin: the two deaths of christopher ...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.288675</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.288675</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.235702</td>\n",
       "      <td>0.288675</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>2</th>\n",
       "      <td>the nutcracker (christmas fun-to-read fairy ta...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.223607</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</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>3</th>\n",
       "      <td>i know a rhino</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</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>4</th>\n",
       "      <td>norby and the oldest dragon</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.288675</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.288675</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.235702</td>\n",
       "      <td>0.288675</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>5 rows × 15001 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Book-Title                                         Book-Title  \\\n",
       "0                                           thank you, jeeves   \n",
       "1           pincher martin: the two deaths of christopher ...   \n",
       "2           the nutcracker (christmas fun-to-read fairy ta...   \n",
       "3                                              i know a rhino   \n",
       "4                                 norby and the oldest dragon   \n",
       "\n",
       "Book-Title  thank you, jeeves  \\\n",
       "0                         1.0   \n",
       "1                         0.0   \n",
       "2                         0.0   \n",
       "3                         0.0   \n",
       "4                         0.0   \n",
       "\n",
       "Book-Title  pincher martin: the two deaths of christopher martin  \\\n",
       "0                                                    0.000000      \n",
       "1                                                    1.000000      \n",
       "2                                                    0.000000      \n",
       "3                                                    0.000000      \n",
       "4                                                    0.333333      \n",
       "\n",
       "Book-Title  the nutcracker (christmas fun-to-read fairy tales ser)  \\\n",
       "0                                                         0.0        \n",
       "1                                                         0.0        \n",
       "2                                                         1.0        \n",
       "3                                                         0.0        \n",
       "4                                                         0.0        \n",
       "\n",
       "Book-Title  i know a rhino  norby and the oldest dragon  \\\n",
       "0                      0.0                     0.000000   \n",
       "1                      0.0                     0.333333   \n",
       "2                      0.0                     0.000000   \n",
       "3                      1.0                     0.000000   \n",
       "4                      0.0                     1.000000   \n",
       "\n",
       "Book-Title  his eminence and hizzoner  \\\n",
       "0                            0.000000   \n",
       "1                            0.288675   \n",
       "2                            0.000000   \n",
       "3                            0.000000   \n",
       "4                            0.288675   \n",
       "\n",
       "Book-Title  el oro de los sueã±os (leer en espaã±ol nivel 4)  \\\n",
       "0                                                   0.000000   \n",
       "1                                                   0.000000   \n",
       "2                                                   0.223607   \n",
       "3                                                   0.000000   \n",
       "4                                                   0.000000   \n",
       "\n",
       "Book-Title  celestine insights  \\\n",
       "0                     0.000000   \n",
       "1                     0.288675   \n",
       "2                     0.000000   \n",
       "3                     0.000000   \n",
       "4                     0.288675   \n",
       "\n",
       "Book-Title  feng shui and money: a nine-week program for creating wealth using ancient principles and techniques  \\\n",
       "0                                                         0.0                                                      \n",
       "1                                                         0.0                                                      \n",
       "2                                                         0.0                                                      \n",
       "3                                                         0.0                                                      \n",
       "4                                                         0.0                                                      \n",
       "\n",
       "Book-Title  ...  the santa suit (harlequin american romance, no. 708)  \\\n",
       "0           ...                                                0.0      \n",
       "1           ...                                                0.0      \n",
       "2           ...                                                0.0      \n",
       "3           ...                                                0.0      \n",
       "4           ...                                                0.0      \n",
       "\n",
       "Book-Title  where the gods reign: plants and peoples of the colombian amazon  \\\n",
       "0                                                         0.0                  \n",
       "1                                                         0.0                  \n",
       "2                                                         0.0                  \n",
       "3                                                         0.0                  \n",
       "4                                                         0.0                  \n",
       "\n",
       "Book-Title  the terrible troll-bird  virginia embrace (magnolia road)  \\\n",
       "0                          0.000000                          0.000000   \n",
       "1                          0.235702                          0.288675   \n",
       "2                          0.000000                          0.000000   \n",
       "3                          0.000000                          0.000000   \n",
       "4                          0.235702                          0.288675   \n",
       "\n",
       "Book-Title  take 5, volume 4 (under the knife, adam's gift, return to yesterday, everything but time, marriage diamond style)  \\\n",
       "0                                                         0.0                                                                   \n",
       "1                                                         0.0                                                                   \n",
       "2                                                         0.0                                                                   \n",
       "3                                                         0.0                                                                   \n",
       "4                                                         0.0                                                                   \n",
       "\n",
       "Book-Title  taking the anxiety out of taking tests: a step-by-step guide  \\\n",
       "0                                                         0.0              \n",
       "1                                                         0.0              \n",
       "2                                                         0.0              \n",
       "3                                                         0.0              \n",
       "4                                                         0.0              \n",
       "\n",
       "Book-Title  encyclopedia of women's health issues  \\\n",
       "0                                             0.0   \n",
       "1                                             0.0   \n",
       "2                                             0.0   \n",
       "3                                             0.0   \n",
       "4                                             0.0   \n",
       "\n",
       "Book-Title  fodor's 2002 new york city (fodor's new york city)  \\\n",
       "0                                                         0.0    \n",
       "1                                                         0.0    \n",
       "2                                                         0.0    \n",
       "3                                                         0.0    \n",
       "4                                                         0.0    \n",
       "\n",
       "Book-Title  c. s. lewis: a biography,revised edition  \\\n",
       "0                                                0.0   \n",
       "1                                                0.0   \n",
       "2                                                0.0   \n",
       "3                                                0.0   \n",
       "4                                                0.0   \n",
       "\n",
       "Book-Title  the late night muse: a novel  \n",
       "0                                    0.0  \n",
       "1                                    0.0  \n",
       "2                                    0.0  \n",
       "3                                    0.0  \n",
       "4                                    0.0  \n",
       "\n",
       "[5 rows x 15001 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame(similarities, columns=df['Book-Title'], index=df['Book-Title']).reset_index()\n",
    "\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "ad463ae0",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                                             Book-Title\n",
      "768    to storm heaven (star trek: the next generation)\n",
      "802   the star trek chronology : a history of the fu...\n",
      "1472           gateways #1:  one small step (star trek)\n",
      "2051           reunion (star trek: the next generation)\n",
      "2891                marooned (star trek voyager, no 14)\n",
      "3727     maelstrom (ultima: the technocrat war, book 3)\n",
      "3991         belle terre (star trek: new earth, book 2)\n",
      "4567  the way of the warrior (star trek deep space n...\n",
      "4757  a rock and a hard place:star trek next generat...\n",
      "5812               the joy machine (star trek, book 80)\n"
     ]
    }
   ],
   "source": [
    "input_book = 'far beyond the stars (star trek deep space nine)'\n",
    "recommendations = pd.DataFrame(df.nlargest(11,input_book)['Book-Title'])\n",
    "recommendations = recommendations[recommendations['Book-Title']!=input_book]\n",
    "print(recommendations)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4a4f1e96",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}