book-recommendation-system.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 124,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\PURVESH\\AppData\\Local\\Temp\\ipykernel_15476\\2063755278.py:3: DtypeWarning: Columns (3) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  df = pd.read_csv('csv/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": 124,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df = pd.read_csv('csv/books.csv',on_bad_lines='skip',encoding='latin-1',sep=';')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 125,
   "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          271358 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": 126,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "29225"
      ]
     },
     "execution_count": 126,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# No of duplicate records with same title \n",
    "\n",
    "# len(df) - len(df['Book-Title'].unique())\n",
    "\n",
    "\n",
    "df.duplicated(subset='Book-Title').sum()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 127,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "242135\n"
     ]
    }
   ],
   "source": [
    "df1 = df.drop_duplicates(subset='Book-Title')\n",
    "\n",
    "print(len(df1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 128,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 128,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.duplicated(subset='Book-Title').sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "metadata": {},
   "outputs": [],
   "source": [
    "sample_size = 8000\n",
    "df8k = df1.sample(n=sample_size, replace=False, random_state=490)\n",
    "\n",
    "df8k = df8k.reset_index()\n",
    "df8k = df8k.drop('index',axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "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": 130,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df8k.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "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>Book-Title</th>\n",
       "      <th>Book-Author</th>\n",
       "      <th>Publisher</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Thank You, Jeeves</td>\n",
       "      <td>P.G. Wodehouse</td>\n",
       "      <td>Perennial</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Pincher Martin: The Two Deaths of Christopher ...</td>\n",
       "      <td>William Golding</td>\n",
       "      <td>Harvest Books</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>The Nutcracker (Christmas Fun-to-Read Fairy Ta...</td>\n",
       "      <td>Roberta Collier-Morales</td>\n",
       "      <td>Modern Publishing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>I Know a Rhino</td>\n",
       "      <td>Charles Fuge</td>\n",
       "      <td>Sterling</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Norby and the Oldest Dragon</td>\n",
       "      <td>Janet Asimov</td>\n",
       "      <td>Ace Books</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7995</th>\n",
       "      <td>Algebra (Teach Yourself)</td>\n",
       "      <td>P. Abbott</td>\n",
       "      <td>McGraw-Hill</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7996</th>\n",
       "      <td>Sweepers: A Novel of Suspense</td>\n",
       "      <td>Peter T. Deutermann</td>\n",
       "      <td>St. Martin's Press</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7997</th>\n",
       "      <td>Prince of Kisses (Faerie Tale Romance Series ,...</td>\n",
       "      <td>Colleen Shannon</td>\n",
       "      <td>Love Spell</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7998</th>\n",
       "      <td>I'm a Little Teapot</td>\n",
       "      <td>Iza Trapani</td>\n",
       "      <td>Charlesbridge Publishing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7999</th>\n",
       "      <td>Klar Schiff zum Gefecht. Richard Bolitho - Kap...</td>\n",
       "      <td>Alexander Kent</td>\n",
       "      <td>Ullstein Buchverlage GmbH &amp;amp; Co. KG / Ullst...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8000 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             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",
       "7995                           Algebra (Teach Yourself)   \n",
       "7996                      Sweepers: A Novel of Suspense   \n",
       "7997  Prince of Kisses (Faerie Tale Romance Series ,...   \n",
       "7998                                I'm a Little Teapot   \n",
       "7999  Klar Schiff zum Gefecht. Richard Bolitho - Kap...   \n",
       "\n",
       "                  Book-Author  \\\n",
       "0              P.G. Wodehouse   \n",
       "1             William Golding   \n",
       "2     Roberta Collier-Morales   \n",
       "3                Charles Fuge   \n",
       "4                Janet Asimov   \n",
       "...                       ...   \n",
       "7995                P. Abbott   \n",
       "7996      Peter T. Deutermann   \n",
       "7997          Colleen Shannon   \n",
       "7998              Iza Trapani   \n",
       "7999           Alexander Kent   \n",
       "\n",
       "                                              Publisher  \n",
       "0                                             Perennial  \n",
       "1                                         Harvest Books  \n",
       "2                                     Modern Publishing  \n",
       "3                                              Sterling  \n",
       "4                                             Ace Books  \n",
       "...                                                 ...  \n",
       "7995                                        McGraw-Hill  \n",
       "7996                                 St. Martin's Press  \n",
       "7997                                         Love Spell  \n",
       "7998                           Charlesbridge Publishing  \n",
       "7999  Ullstein Buchverlage GmbH &amp; Co. KG / Ullst...  \n",
       "\n",
       "[8000 rows x 3 columns]"
      ]
     },
     "execution_count": 131,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df8k[['Book-Title', 'Book-Author', 'Publisher']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "metadata": {},
   "outputs": [],
   "source": [
    "def clean_text(text):\n",
    "    result = str(text).lower()\n",
    "    return result.replace(\" \", \"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "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>Book-Title</th>\n",
       "      <th>Book-Author</th>\n",
       "      <th>Publisher</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Thank You, Jeeves</td>\n",
       "      <td>p.g.wodehouse</td>\n",
       "      <td>Perennial</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Pincher Martin: The Two Deaths of Christopher ...</td>\n",
       "      <td>williamgolding</td>\n",
       "      <td>Harvest Books</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>The Nutcracker (Christmas Fun-to-Read Fairy Ta...</td>\n",
       "      <td>robertacollier-morales</td>\n",
       "      <td>Modern Publishing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>I Know a Rhino</td>\n",
       "      <td>charlesfuge</td>\n",
       "      <td>Sterling</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Norby and the Oldest Dragon</td>\n",
       "      <td>janetasimov</td>\n",
       "      <td>Ace Books</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          Book-Title             Book-Author  \\\n",
       "0                                  Thank You, Jeeves           p.g.wodehouse   \n",
       "1  Pincher Martin: The Two Deaths of Christopher ...          williamgolding   \n",
       "2  The Nutcracker (Christmas Fun-to-Read Fairy Ta...  robertacollier-morales   \n",
       "3                                     I Know a Rhino             charlesfuge   \n",
       "4                        Norby and the Oldest Dragon             janetasimov   \n",
       "\n",
       "           Publisher  \n",
       "0          Perennial  \n",
       "1      Harvest Books  \n",
       "2  Modern Publishing  \n",
       "3           Sterling  \n",
       "4          Ace Books  "
      ]
     },
     "execution_count": 133,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# df1[['Book-Title', 'Book-Author', 'Publisher']].head()\n",
    "\n",
    "df8k['Book-Author'] = df8k['Book-Author'].apply(clean_text)\n",
    "\n",
    "df8k[['Book-Title', 'Book-Author', 'Publisher']].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "metadata": {},
   "outputs": [],
   "source": [
    "df8k['Book-Title'] = df8k['Book-Title'].str.lower()\n",
    "df8k['Publisher'] = df8k['Publisher'].str.lower()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "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>Book-Title</th>\n",
       "      <th>Book-Author</th>\n",
       "      <th>Publisher</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>thank you, jeeves</td>\n",
       "      <td>p.g.wodehouse</td>\n",
       "      <td>perennial</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>pincher martin: the two deaths of christopher ...</td>\n",
       "      <td>williamgolding</td>\n",
       "      <td>harvest books</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>the nutcracker (christmas fun-to-read fairy ta...</td>\n",
       "      <td>robertacollier-morales</td>\n",
       "      <td>modern publishing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>i know a rhino</td>\n",
       "      <td>charlesfuge</td>\n",
       "      <td>sterling</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>norby and the oldest dragon</td>\n",
       "      <td>janetasimov</td>\n",
       "      <td>ace books</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7995</th>\n",
       "      <td>algebra (teach yourself)</td>\n",
       "      <td>p.abbott</td>\n",
       "      <td>mcgraw-hill</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7996</th>\n",
       "      <td>sweepers: a novel of suspense</td>\n",
       "      <td>petert.deutermann</td>\n",
       "      <td>st. martin's press</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7997</th>\n",
       "      <td>prince of kisses (faerie tale romance series ,...</td>\n",
       "      <td>colleenshannon</td>\n",
       "      <td>love spell</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7998</th>\n",
       "      <td>i'm a little teapot</td>\n",
       "      <td>izatrapani</td>\n",
       "      <td>charlesbridge publishing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7999</th>\n",
       "      <td>klar schiff zum gefecht. richard bolitho - kap...</td>\n",
       "      <td>alexanderkent</td>\n",
       "      <td>ullstein buchverlage gmbh &amp;amp; co. kg / ullst...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8000 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             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",
       "7995                           algebra (teach yourself)   \n",
       "7996                      sweepers: a novel of suspense   \n",
       "7997  prince of kisses (faerie tale romance series ,...   \n",
       "7998                                i'm a little teapot   \n",
       "7999  klar schiff zum gefecht. richard bolitho - kap...   \n",
       "\n",
       "                 Book-Author  \\\n",
       "0              p.g.wodehouse   \n",
       "1             williamgolding   \n",
       "2     robertacollier-morales   \n",
       "3                charlesfuge   \n",
       "4                janetasimov   \n",
       "...                      ...   \n",
       "7995                p.abbott   \n",
       "7996       petert.deutermann   \n",
       "7997          colleenshannon   \n",
       "7998              izatrapani   \n",
       "7999           alexanderkent   \n",
       "\n",
       "                                              Publisher  \n",
       "0                                             perennial  \n",
       "1                                         harvest books  \n",
       "2                                     modern publishing  \n",
       "3                                              sterling  \n",
       "4                                             ace books  \n",
       "...                                                 ...  \n",
       "7995                                        mcgraw-hill  \n",
       "7996                                 st. martin's press  \n",
       "7997                                         love spell  \n",
       "7998                           charlesbridge publishing  \n",
       "7999  ullstein buchverlage gmbh &amp; co. kg / ullst...  \n",
       "\n",
       "[8000 rows x 3 columns]"
      ]
     },
     "execution_count": 135,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df8k[['Book-Title', 'Book-Author', 'Publisher']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "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",
       "    <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>7995</th>\n",
       "      <td>0844239046</td>\n",
       "      <td>algebra (teach yourself)</td>\n",
       "      <td>p.abbott</td>\n",
       "      <td>1992</td>\n",
       "      <td>mcgraw-hill</td>\n",
       "      <td>http://images.amazon.com/images/P/0844239046.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0844239046.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0844239046.0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7996</th>\n",
       "      <td>0312156693</td>\n",
       "      <td>sweepers: a novel of suspense</td>\n",
       "      <td>petert.deutermann</td>\n",
       "      <td>1997</td>\n",
       "      <td>st. martin's press</td>\n",
       "      <td>http://images.amazon.com/images/P/0312156693.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0312156693.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0312156693.0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7997</th>\n",
       "      <td>0505522004</td>\n",
       "      <td>prince of kisses (faerie tale romance series ,...</td>\n",
       "      <td>colleenshannon</td>\n",
       "      <td>1997</td>\n",
       "      <td>love spell</td>\n",
       "      <td>http://images.amazon.com/images/P/0505522004.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0505522004.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/0505522004.0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7998</th>\n",
       "      <td>1580890105</td>\n",
       "      <td>i'm a little teapot</td>\n",
       "      <td>izatrapani</td>\n",
       "      <td>1998</td>\n",
       "      <td>charlesbridge publishing</td>\n",
       "      <td>http://images.amazon.com/images/P/1580890105.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/1580890105.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/1580890105.0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7999</th>\n",
       "      <td>3548239323</td>\n",
       "      <td>klar schiff zum gefecht. richard bolitho - kap...</td>\n",
       "      <td>alexanderkent</td>\n",
       "      <td>1996</td>\n",
       "      <td>ullstein buchverlage gmbh &amp;amp; co. kg / ullst...</td>\n",
       "      <td>http://images.amazon.com/images/P/3548239323.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/3548239323.0...</td>\n",
       "      <td>http://images.amazon.com/images/P/3548239323.0...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8000 rows × 8 columns</p>\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",
       "7995  0844239046                           algebra (teach yourself)   \n",
       "7996  0312156693                      sweepers: a novel of suspense   \n",
       "7997  0505522004  prince of kisses (faerie tale romance series ,...   \n",
       "7998  1580890105                                i'm a little teapot   \n",
       "7999  3548239323  klar schiff zum gefecht. richard bolitho - kap...   \n",
       "\n",
       "                 Book-Author Year-Of-Publication  \\\n",
       "0              p.g.wodehouse                1989   \n",
       "1             williamgolding                2002   \n",
       "2     robertacollier-morales                1992   \n",
       "3                charlesfuge                2003   \n",
       "4                janetasimov                1993   \n",
       "...                      ...                 ...   \n",
       "7995                p.abbott                1992   \n",
       "7996       petert.deutermann                1997   \n",
       "7997          colleenshannon                1997   \n",
       "7998              izatrapani                1998   \n",
       "7999           alexanderkent                1996   \n",
       "\n",
       "                                              Publisher  \\\n",
       "0                                             perennial   \n",
       "1                                         harvest books   \n",
       "2                                     modern publishing   \n",
       "3                                              sterling   \n",
       "4                                             ace books   \n",
       "...                                                 ...   \n",
       "7995                                        mcgraw-hill   \n",
       "7996                                 st. martin's press   \n",
       "7997                                         love spell   \n",
       "7998                           charlesbridge publishing   \n",
       "7999  ullstein buchverlage gmbh &amp; co. kg / ullst...   \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",
       "7995  http://images.amazon.com/images/P/0844239046.0...   \n",
       "7996  http://images.amazon.com/images/P/0312156693.0...   \n",
       "7997  http://images.amazon.com/images/P/0505522004.0...   \n",
       "7998  http://images.amazon.com/images/P/1580890105.0...   \n",
       "7999  http://images.amazon.com/images/P/3548239323.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",
       "7995  http://images.amazon.com/images/P/0844239046.0...   \n",
       "7996  http://images.amazon.com/images/P/0312156693.0...   \n",
       "7997  http://images.amazon.com/images/P/0505522004.0...   \n",
       "7998  http://images.amazon.com/images/P/1580890105.0...   \n",
       "7999  http://images.amazon.com/images/P/3548239323.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...  \n",
       "...                                                 ...  \n",
       "7995  http://images.amazon.com/images/P/0844239046.0...  \n",
       "7996  http://images.amazon.com/images/P/0312156693.0...  \n",
       "7997  http://images.amazon.com/images/P/0505522004.0...  \n",
       "7998  http://images.amazon.com/images/P/1580890105.0...  \n",
       "7999  http://images.amazon.com/images/P/3548239323.0...  \n",
       "\n",
       "[8000 rows x 8 columns]"
      ]
     },
     "execution_count": 136,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df8k"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "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>Book-Title</th>\n",
       "      <th>Book-Author</th>\n",
       "      <th>Publisher</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>thank you, jeeves</td>\n",
       "      <td>p.g.wodehouse</td>\n",
       "      <td>perennial</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>pincher martin: the two deaths of christopher ...</td>\n",
       "      <td>williamgolding</td>\n",
       "      <td>harvest books</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>the nutcracker (christmas fun-to-read fairy ta...</td>\n",
       "      <td>robertacollier-morales</td>\n",
       "      <td>modern publishing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>i know a rhino</td>\n",
       "      <td>charlesfuge</td>\n",
       "      <td>sterling</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>norby and the oldest dragon</td>\n",
       "      <td>janetasimov</td>\n",
       "      <td>ace books</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7995</th>\n",
       "      <td>algebra (teach yourself)</td>\n",
       "      <td>p.abbott</td>\n",
       "      <td>mcgraw-hill</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7996</th>\n",
       "      <td>sweepers: a novel of suspense</td>\n",
       "      <td>petert.deutermann</td>\n",
       "      <td>st. martin's press</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7997</th>\n",
       "      <td>prince of kisses (faerie tale romance series ,...</td>\n",
       "      <td>colleenshannon</td>\n",
       "      <td>love spell</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7998</th>\n",
       "      <td>i'm a little teapot</td>\n",
       "      <td>izatrapani</td>\n",
       "      <td>charlesbridge publishing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7999</th>\n",
       "      <td>klar schiff zum gefecht. richard bolitho - kap...</td>\n",
       "      <td>alexanderkent</td>\n",
       "      <td>ullstein buchverlage gmbh &amp;amp; co. kg / ullst...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8000 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             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",
       "7995                           algebra (teach yourself)   \n",
       "7996                      sweepers: a novel of suspense   \n",
       "7997  prince of kisses (faerie tale romance series ,...   \n",
       "7998                                i'm a little teapot   \n",
       "7999  klar schiff zum gefecht. richard bolitho - kap...   \n",
       "\n",
       "                 Book-Author  \\\n",
       "0              p.g.wodehouse   \n",
       "1             williamgolding   \n",
       "2     robertacollier-morales   \n",
       "3                charlesfuge   \n",
       "4                janetasimov   \n",
       "...                      ...   \n",
       "7995                p.abbott   \n",
       "7996       petert.deutermann   \n",
       "7997          colleenshannon   \n",
       "7998              izatrapani   \n",
       "7999           alexanderkent   \n",
       "\n",
       "                                              Publisher  \n",
       "0                                             perennial  \n",
       "1                                         harvest books  \n",
       "2                                     modern publishing  \n",
       "3                                              sterling  \n",
       "4                                             ace books  \n",
       "...                                                 ...  \n",
       "7995                                        mcgraw-hill  \n",
       "7996                                 st. martin's press  \n",
       "7997                                         love spell  \n",
       "7998                           charlesbridge publishing  \n",
       "7999  ullstein buchverlage gmbh &amp; co. kg / ullst...  \n",
       "\n",
       "[8000 rows x 3 columns]"
      ]
     },
     "execution_count": 137,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "_df2 = df8k.drop(['ISBN','Image-URL-S','Image-URL-M','Image-URL-L','Year-Of-Publication'],axis=1)\n",
    "\n",
    "_df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 138,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0               thank you, jeeves p.g.wodehouse perennial\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 charlesfuge sterling\n",
      "4       norby and the oldest dragon janetasimov ace books\n",
      "                              ...                        \n",
      "7995        algebra (teach yourself) p.abbott mcgraw-hill\n",
      "7996    sweepers: a novel of suspense petert.deuterman...\n",
      "7997    prince of kisses (faerie tale romance series ,...\n",
      "7998    i'm a little teapot izatrapani charlesbridge p...\n",
      "7999    klar schiff zum gefecht. richard bolitho - kap...\n",
      "Name: data, Length: 8000, dtype: object\n"
     ]
    }
   ],
   "source": [
    "df2 = _df2\n",
    "df2['data'] = df2['Book-Title'].astype('str')+ ' ' + df2['Book-Author'].astype('str') + ' ' + df2['Publisher'].astype('str')\n",
    "\n",
    "print(df2['data'])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 139,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.feature_extraction.text import CountVectorizer\n",
    "\n",
    "#test = pd.DataFrame({'data': ['Hello Beautiful Word', 'Hello There']})\n",
    "\n",
    "vectorizer = CountVectorizer()\n",
    "vectorized = vectorizer.fit_transform(df2['data'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 140,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['00' '000' '003' ... 'â¼ter' 'â¼tz' 'â¼tzt']\n"
     ]
    },
    {
     "ename": "MemoryError",
     "evalue": "Unable to allocate 1.19 GiB for an array with shape (8000, 20033) and data type int64",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mMemoryError\u001b[0m                               Traceback (most recent call last)",
      "Cell \u001b[1;32mIn[140], line 9\u001b[0m\n\u001b[0;32m      7\u001b[0m \u001b[39mprint\u001b[39m(vectorizer\u001b[39m.\u001b[39mget_feature_names_out())\n\u001b[0;32m      8\u001b[0m \u001b[39m# print(vectorized)\u001b[39;00m\n\u001b[1;32m----> 9\u001b[0m \u001b[39mprint\u001b[39m(vectorized\u001b[39m.\u001b[39;49mtoarray())\n\u001b[0;32m     10\u001b[0m \u001b[39mprint\u001b[39m(vectorized\u001b[39m.\u001b[39mshape)\n",
      "File \u001b[1;32mc:\\Users\\PURVESH\\Desktop\\WORKSPACE\\recommndation system\\venv\\lib\\site-packages\\scipy\\sparse\\_compressed.py:1050\u001b[0m, in \u001b[0;36m_cs_matrix.toarray\u001b[1;34m(self, order, out)\u001b[0m\n\u001b[0;32m   1048\u001b[0m \u001b[39mif\u001b[39;00m out \u001b[39mis\u001b[39;00m \u001b[39mNone\u001b[39;00m \u001b[39mand\u001b[39;00m order \u001b[39mis\u001b[39;00m \u001b[39mNone\u001b[39;00m:\n\u001b[0;32m   1049\u001b[0m     order \u001b[39m=\u001b[39m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_swap(\u001b[39m'\u001b[39m\u001b[39mcf\u001b[39m\u001b[39m'\u001b[39m)[\u001b[39m0\u001b[39m]\n\u001b[1;32m-> 1050\u001b[0m out \u001b[39m=\u001b[39m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_process_toarray_args(order, out)\n\u001b[0;32m   1051\u001b[0m \u001b[39mif\u001b[39;00m \u001b[39mnot\u001b[39;00m (out\u001b[39m.\u001b[39mflags\u001b[39m.\u001b[39mc_contiguous \u001b[39mor\u001b[39;00m out\u001b[39m.\u001b[39mflags\u001b[39m.\u001b[39mf_contiguous):\n\u001b[0;32m   1052\u001b[0m     \u001b[39mraise\u001b[39;00m \u001b[39mValueError\u001b[39;00m(\u001b[39m'\u001b[39m\u001b[39mOutput array must be C or F contiguous\u001b[39m\u001b[39m'\u001b[39m)\n",
      "File \u001b[1;32mc:\\Users\\PURVESH\\Desktop\\WORKSPACE\\recommndation system\\venv\\lib\\site-packages\\scipy\\sparse\\_base.py:1267\u001b[0m, in \u001b[0;36m_spbase._process_toarray_args\u001b[1;34m(self, order, out)\u001b[0m\n\u001b[0;32m   1265\u001b[0m     \u001b[39mreturn\u001b[39;00m out\n\u001b[0;32m   1266\u001b[0m \u001b[39melse\u001b[39;00m:\n\u001b[1;32m-> 1267\u001b[0m     \u001b[39mreturn\u001b[39;00m np\u001b[39m.\u001b[39;49mzeros(\u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49mshape, dtype\u001b[39m=\u001b[39;49m\u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49mdtype, order\u001b[39m=\u001b[39;49morder)\n",
      "\u001b[1;31mMemoryError\u001b[0m: Unable to allocate 1.19 GiB for an array with shape (8000, 20033) and data type int64"
     ]
    }
   ],
   "source": [
    "# xx = {'a': ['hello', 'there'], 'b': [1, None]}\n",
    "\n",
    "# test = pd.DataFrame(xx)\n",
    "\n",
    "\n",
    "# test.dropna()\n",
    "print(vectorizer.get_feature_names_out())\n",
    "# print(vectorized)\n",
    "print(vectorized.toarray())\n",
    "print(vectorized.shape)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[[1.         0.         0.         ... 0.         0.         0.        ]\n",
      " [0.         1.         0.07692308 ... 0.0836242  0.         0.        ]\n",
      " [0.         0.07692308 1.         ... 0.         0.12403473 0.        ]\n",
      " ...\n",
      " [0.         0.0836242  0.         ... 1.         0.         0.        ]\n",
      " [0.         0.         0.12403473 ... 0.         1.         0.        ]\n",
      " [0.         0.         0.         ... 0.         0.         1.        ]]\n",
      "(8000, 8000)\n"
     ]
    }
   ],
   "source": [
    "from sklearn.metrics.pairwise import cosine_similarity\n",
    "\n",
    "similarities = cosine_similarity(vectorized)\n",
    "\n",
    "print(similarities)\n",
    "print(similarities.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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 four witnesses : the rebel, the rabbi, the chronicler, and the mystic -- why the gospels present strikingly different visions of jesus?</th>\n",
       "      <th>html prorammer's reference</th>\n",
       "      <th>the executed god: the way of the cross in lockdown america</th>\n",
       "      <th>algebra (teach yourself)</th>\n",
       "      <th>sweepers: a novel of suspense</th>\n",
       "      <th>prince of kisses (faerie tale romance series , no 2)</th>\n",
       "      <th>i'm a little teapot</th>\n",
       "      <th>klar schiff zum gefecht. richard bolitho - kapitã?â¤n des kã?â¶nigs.</th>\n",
       "      <th>Year-Of-Publication</th>\n",
       "      <th>Image-URL-M</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.000000</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.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2002</td>\n",
       "      <td>http://images.amazon.com/images/P/0195153448.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.076923</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.196116</td>\n",
       "      <td>0.098058</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.113228</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.264198</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.236525</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.27735</td>\n",
       "      <td>0.083624</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2001</td>\n",
       "      <td>http://images.amazon.com/images/P/0002005018.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.076923</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.098058</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.069338</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.226455</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.177394</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.124035</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1991</td>\n",
       "      <td>http://images.amazon.com/images/P/0060973129.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.000000</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.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1999</td>\n",
       "      <td>http://images.amazon.com/images/P/0374157065.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.196116</td>\n",
       "      <td>0.098058</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.250000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.144338</td>\n",
       "      <td>0.158114</td>\n",
       "      <td>...</td>\n",
       "      <td>0.336788</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.226134</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1999</td>\n",
       "      <td>http://images.amazon.com/images/P/0393045218.0...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 8003 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.076923      \n",
       "3                                                    0.000000      \n",
       "4                                                    0.196116      \n",
       "\n",
       "Book-Title  the nutcracker (christmas fun-to-read fairy tales ser)  \\\n",
       "0                                                    0.000000        \n",
       "1                                                    0.076923        \n",
       "2                                                    1.000000        \n",
       "3                                                    0.000000        \n",
       "4                                                    0.098058        \n",
       "\n",
       "Book-Title  i know a rhino  norby and the oldest dragon  \\\n",
       "0                      0.0                     0.000000   \n",
       "1                      0.0                     0.196116   \n",
       "2                      0.0                     0.098058   \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.098058   \n",
       "2                            0.000000   \n",
       "3                            0.000000   \n",
       "4                            0.250000   \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.069338   \n",
       "3                                                   0.000000   \n",
       "4                                                   0.000000   \n",
       "\n",
       "Book-Title  celestine insights  \\\n",
       "0                     0.000000   \n",
       "1                     0.113228   \n",
       "2                     0.000000   \n",
       "3                     0.000000   \n",
       "4                     0.144338   \n",
       "\n",
       "Book-Title  feng shui and money: a nine-week program for creating wealth using ancient principles and techniques  \\\n",
       "0                                                    0.000000                                                      \n",
       "1                                                    0.000000                                                      \n",
       "2                                                    0.000000                                                      \n",
       "3                                                    0.000000                                                      \n",
       "4                                                    0.158114                                                      \n",
       "\n",
       "Book-Title  ...  \\\n",
       "0           ...   \n",
       "1           ...   \n",
       "2           ...   \n",
       "3           ...   \n",
       "4           ...   \n",
       "\n",
       "Book-Title  the four witnesses : the rebel, the rabbi, the chronicler, and the mystic -- why the gospels present strikingly different visions of jesus?  \\\n",
       "0                                                    0.000000                                                                                             \n",
       "1                                                    0.264198                                                                                             \n",
       "2                                                    0.226455                                                                                             \n",
       "3                                                    0.000000                                                                                             \n",
       "4                                                    0.336788                                                                                             \n",
       "\n",
       "Book-Title  html prorammer's reference  \\\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 executed god: the way of the cross in lockdown america  \\\n",
       "0                                                    0.000000            \n",
       "1                                                    0.236525            \n",
       "2                                                    0.177394            \n",
       "3                                                    0.000000            \n",
       "4                                                    0.226134            \n",
       "\n",
       "Book-Title  algebra (teach yourself)  sweepers: a novel of suspense  \\\n",
       "0                                0.0                        0.00000   \n",
       "1                                0.0                        0.27735   \n",
       "2                                0.0                        0.00000   \n",
       "3                                0.0                        0.00000   \n",
       "4                                0.0                        0.00000   \n",
       "\n",
       "Book-Title  prince of kisses (faerie tale romance series , no 2)  \\\n",
       "0                                                    0.000000      \n",
       "1                                                    0.083624      \n",
       "2                                                    0.000000      \n",
       "3                                                    0.000000      \n",
       "4                                                    0.000000      \n",
       "\n",
       "Book-Title  i'm a little teapot  \\\n",
       "0                      0.000000   \n",
       "1                      0.000000   \n",
       "2                      0.124035   \n",
       "3                      0.000000   \n",
       "4                      0.000000   \n",
       "\n",
       "Book-Title  klar schiff zum gefecht. richard bolitho - kapitã?â¤n des kã?â¶nigs.  \\\n",
       "0                                                         0.0                      \n",
       "1                                                         0.0                      \n",
       "2                                                         0.0                      \n",
       "3                                                         0.0                      \n",
       "4                                                         0.0                      \n",
       "\n",
       "Book-Title  Year-Of-Publication  \\\n",
       "0                          2002   \n",
       "1                          2001   \n",
       "2                          1991   \n",
       "3                          1999   \n",
       "4                          1999   \n",
       "\n",
       "Book-Title                                        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",
       "[5 rows x 8003 columns]"
      ]
     },
     "execution_count": 120,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Remapping the simailarties vector back to the previos dataframe\n",
    "\n",
    "df2 = pd.DataFrame(similarities , columns=df8k['Book-Title'], index=df8k['Book-Title']).reset_index()\n",
    "df2['Year-Of-Publication'] = df1['Year-Of-Publication']\n",
    "df2['Image-URL-M'] = df1['Image-URL-M']\n",
    "df2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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>Year-Of-Publication</th>\n",
       "      <th>Image-URL-M</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>881</th>\n",
       "      <td>dragon's domain</td>\n",
       "      <td>2001</td>\n",
       "      <td>http://images.amazon.com/images/P/0743211383.0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7302</th>\n",
       "      <td>the windsingers</td>\n",
       "      <td>1998</td>\n",
       "      <td>http://images.amazon.com/images/P/1853260770.0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>923</th>\n",
       "      <td>the guardians (ace fantasy)</td>\n",
       "      <td>1987</td>\n",
       "      <td>http://images.amazon.com/images/P/0345346971.0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1235</th>\n",
       "      <td>the dragon and the unicorn</td>\n",
       "      <td>1974</td>\n",
       "      <td>http://images.amazon.com/images/P/3518367064.0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3850</th>\n",
       "      <td>the city and the pillar</td>\n",
       "      <td>1997</td>\n",
       "      <td>http://images.amazon.com/images/P/3423123222.0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4855</th>\n",
       "      <td>the best and the brightest</td>\n",
       "      <td>1998</td>\n",
       "      <td>http://images.amazon.com/images/P/0385333498.0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5719</th>\n",
       "      <td>ou lu khen and the beautiful madwoman</td>\n",
       "      <td>2002</td>\n",
       "      <td>http://images.amazon.com/images/P/8472234320.0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5980</th>\n",
       "      <td>the quark and the jaguar: adventures in the si...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2138</th>\n",
       "      <td>the black castle</td>\n",
       "      <td>1998</td>\n",
       "      <td>http://images.amazon.com/images/P/0373301529.0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2740</th>\n",
       "      <td>jed the dead</td>\n",
       "      <td>2002</td>\n",
       "      <td>http://images.amazon.com/images/P/0380811065.0...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Book-Title                                         Book-Title  \\\n",
       "881                                           dragon's domain   \n",
       "7302                                          the windsingers   \n",
       "923                               the guardians (ace fantasy)   \n",
       "1235                               the dragon and the unicorn   \n",
       "3850                                  the city and the pillar   \n",
       "4855                               the best and the brightest   \n",
       "5719                    ou lu khen and the beautiful madwoman   \n",
       "5980        the quark and the jaguar: adventures in the si...   \n",
       "2138                                         the black castle   \n",
       "2740                                             jed the dead   \n",
       "\n",
       "Book-Title Year-Of-Publication  \\\n",
       "881                       2001   \n",
       "7302                      1998   \n",
       "923                       1987   \n",
       "1235                      1974   \n",
       "3850                      1997   \n",
       "4855                      1998   \n",
       "5719                      2002   \n",
       "5980                       NaN   \n",
       "2138                      1998   \n",
       "2740                      2002   \n",
       "\n",
       "Book-Title                                        Image-URL-M  \n",
       "881         http://images.amazon.com/images/P/0743211383.0...  \n",
       "7302        http://images.amazon.com/images/P/1853260770.0...  \n",
       "923         http://images.amazon.com/images/P/0345346971.0...  \n",
       "1235        http://images.amazon.com/images/P/3518367064.0...  \n",
       "3850        http://images.amazon.com/images/P/3423123222.0...  \n",
       "4855        http://images.amazon.com/images/P/0385333498.0...  \n",
       "5719        http://images.amazon.com/images/P/8472234320.0...  \n",
       "5980                                                      NaN  \n",
       "2138        http://images.amazon.com/images/P/0373301529.0...  \n",
       "2740        http://images.amazon.com/images/P/0380811065.0...  "
      ]
     },
     "execution_count": 121,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "input_book = 'norby and the oldest dragon'\n",
    "recommendations = pd.DataFrame(df2.nlargest(11,input_book)[['Book-Title', 'Year-Of-Publication', 'Image-URL-M']])\n",
    "recommendations = recommendations[recommendations['Book-Title']!=input_book]\n",
    "recommendations\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# import json\n",
    "# recommendations.to_numpy().tolist()\n",
    "# recommendations.to_json(orient='records')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# import json\n",
    "\n",
    "# df8k[df8k['Book-Title'].str.contains(\"golden\")][:3].to_json(orient='records')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "venv",
   "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.2"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}