Skip to content

Instantly share code, notes, and snippets.

@arjunprakash027

arjunprakash027/collobrative-filtering.ipynb

Last active September 24, 2023 07:06
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save arjunprakash027/fd1c60d315551d55161e2c7a1b12e9e1 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save arjunprakash027/fd1c60d315551d55161e2c7a1b12e9e1 to your computer and use it in GitHub Desktop.
Download ZIP
A collobrative filtering notebook for book dataset using svd in python
Display the source blob
Display the rendered blob
Raw
collobrative-filtering.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"import numpy as np\n",
"import pandas as pd"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Analysis of the Dataset"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": [
"books_df = pd.read_csv('archive/BX-Books.csv',on_bad_lines='warn', delimiter=';', encoding = 'ISO-8859-1')\n",
"users_df = pd.read_csv('archive/BX-Users.csv',on_bad_lines='warn', delimiter=';', encoding = 'ISO-8859-1')\n",
"rating_df = pd.read_csv('archive/BX-Book-Ratings.csv',on_bad_lines='warn', delimiter=';', encoding = 'ISO-8859-1')"
]
},
{
"cell_type": "code",
"execution_count": 3,
"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>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",
" <tr>\n",
" <th>5</th>\n",
" <td>0399135782</td>\n",
" <td>The Kitchen God's Wife</td>\n",
" <td>Amy Tan</td>\n",
" <td>1991</td>\n",
" <td>Putnam Pub Group</td>\n",
" <td>http://images.amazon.com/images/P/0399135782.0...</td>\n",
" <td>http://images.amazon.com/images/P/0399135782.0...</td>\n",
" <td>http://images.amazon.com/images/P/0399135782.0...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>0425176428</td>\n",
" <td>What If?: The World's Foremost Military Histor...</td>\n",
" <td>Robert Cowley</td>\n",
" <td>2000</td>\n",
" <td>Berkley Publishing Group</td>\n",
" <td>http://images.amazon.com/images/P/0425176428.0...</td>\n",
" <td>http://images.amazon.com/images/P/0425176428.0...</td>\n",
" <td>http://images.amazon.com/images/P/0425176428.0...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>0671870432</td>\n",
" <td>PLEADING GUILTY</td>\n",
" <td>Scott Turow</td>\n",
" <td>1993</td>\n",
" <td>Audioworks</td>\n",
" <td>http://images.amazon.com/images/P/0671870432.0...</td>\n",
" <td>http://images.amazon.com/images/P/0671870432.0...</td>\n",
" <td>http://images.amazon.com/images/P/0671870432.0...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>0679425608</td>\n",
" <td>Under the Black Flag: The Romance and the Real...</td>\n",
" <td>David Cordingly</td>\n",
" <td>1996</td>\n",
" <td>Random House</td>\n",
" <td>http://images.amazon.com/images/P/0679425608.0...</td>\n",
" <td>http://images.amazon.com/images/P/0679425608.0...</td>\n",
" <td>http://images.amazon.com/images/P/0679425608.0...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>074322678X</td>\n",
" <td>Where You'll Find Me: And Other Stories</td>\n",
" <td>Ann Beattie</td>\n",
" <td>2002</td>\n",
" <td>Scribner</td>\n",
" <td>http://images.amazon.com/images/P/074322678X.0...</td>\n",
" <td>http://images.amazon.com/images/P/074322678X.0...</td>\n",
" <td>http://images.amazon.com/images/P/074322678X.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",
"5 0399135782 The Kitchen God's Wife \n",
"6 0425176428 What If?: The World's Foremost Military Histor... \n",
"7 0671870432 PLEADING GUILTY \n",
"8 0679425608 Under the Black Flag: The Romance and the Real... \n",
"9 074322678X Where You'll Find Me: And Other Stories \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",
"5 Amy Tan 1991 Putnam Pub Group \n",
"6 Robert Cowley 2000 Berkley Publishing Group \n",
"7 Scott Turow 1993 Audioworks \n",
"8 David Cordingly 1996 Random House \n",
"9 Ann Beattie 2002 Scribner \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",
"5 http://images.amazon.com/images/P/0399135782.0... \n",
"6 http://images.amazon.com/images/P/0425176428.0... \n",
"7 http://images.amazon.com/images/P/0671870432.0... \n",
"8 http://images.amazon.com/images/P/0679425608.0... \n",
"9 http://images.amazon.com/images/P/074322678X.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",
"5 http://images.amazon.com/images/P/0399135782.0... \n",
"6 http://images.amazon.com/images/P/0425176428.0... \n",
"7 http://images.amazon.com/images/P/0671870432.0... \n",
"8 http://images.amazon.com/images/P/0679425608.0... \n",
"9 http://images.amazon.com/images/P/074322678X.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... \n",
"5 http://images.amazon.com/images/P/0399135782.0... \n",
"6 http://images.amazon.com/images/P/0425176428.0... \n",
"7 http://images.amazon.com/images/P/0671870432.0... \n",
"8 http://images.amazon.com/images/P/0679425608.0... \n",
"9 http://images.amazon.com/images/P/074322678X.0... "
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"books_df.head(10)"
]
},
{
"cell_type": "code",
"execution_count": 4,
"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": [
"books_df.info()"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [],
"source": [
"books_df = books_df.drop_duplicates(subset='Book-Title')"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"<class 'pandas.core.frame.DataFrame'>\n",
"Index: 242135 entries, 0 to 271359\n",
"Data columns (total 8 columns):\n",
" # Column Non-Null Count Dtype \n",
"--- ------ -------------- ----- \n",
" 0 ISBN 242135 non-null object\n",
" 1 Book-Title 242135 non-null object\n",
" 2 Book-Author 242133 non-null object\n",
" 3 Year-Of-Publication 242135 non-null object\n",
" 4 Publisher 242134 non-null object\n",
" 5 Image-URL-S 242135 non-null object\n",
" 6 Image-URL-M 242135 non-null object\n",
" 7 Image-URL-L 242132 non-null object\n",
"dtypes: object(8)\n",
"memory usage: 16.6+ MB\n"
]
}
],
"source": [
"books_df.info()"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>User-ID</th>\n",
" <th>Location</th>\n",
" <th>Age</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1</td>\n",
" <td>nyc, new york, usa</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2</td>\n",
" <td>stockton, california, usa</td>\n",
" <td>18.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>3</td>\n",
" <td>moscow, yukon territory, russia</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>4</td>\n",
" <td>porto, v.n.gaia, portugal</td>\n",
" <td>17.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>5</td>\n",
" <td>farnborough, hants, united kingdom</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" User-ID Location Age\n",
"0 1 nyc, new york, usa NaN\n",
"1 2 stockton, california, usa 18.0\n",
"2 3 moscow, yukon territory, russia NaN\n",
"3 4 porto, v.n.gaia, portugal 17.0\n",
"4 5 farnborough, hants, united kingdom NaN"
]
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"users_df.head()\n",
"#users df has no use for us, atlest not for this collobrative filtering "
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>User-ID</th>\n",
" <th>ISBN</th>\n",
" <th>Book-Rating</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>276725</td>\n",
" <td>034545104X</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>276726</td>\n",
" <td>0155061224</td>\n",
" <td>5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>276727</td>\n",
" <td>0446520802</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>276729</td>\n",
" <td>052165615X</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>276729</td>\n",
" <td>0521795028</td>\n",
" <td>6</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" User-ID ISBN Book-Rating\n",
"0 276725 034545104X 0\n",
"1 276726 0155061224 5\n",
"2 276727 0446520802 0\n",
"3 276729 052165615X 3\n",
"4 276729 0521795028 6"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"rating_df.head()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Merging and creating a new dataset"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"This dataset is suitable for our purpose"
]
},
{
"cell_type": "code",
"execution_count": 9,
"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>User-ID</th>\n",
" <th>Book-Rating</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>0195153448</td>\n",
" <td>Classical Mythology</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>0002005018</td>\n",
" <td>Clara Callan</td>\n",
" <td>8</td>\n",
" <td>5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>0002005018</td>\n",
" <td>Clara Callan</td>\n",
" <td>11400</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>0002005018</td>\n",
" <td>Clara Callan</td>\n",
" <td>11676</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>0002005018</td>\n",
" <td>Clara Callan</td>\n",
" <td>41385</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>0002005018</td>\n",
" <td>Clara Callan</td>\n",
" <td>67544</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>0002005018</td>\n",
" <td>Clara Callan</td>\n",
" <td>85526</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>0002005018</td>\n",
" <td>Clara Callan</td>\n",
" <td>96054</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>0002005018</td>\n",
" <td>Clara Callan</td>\n",
" <td>116866</td>\n",
" <td>9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>0002005018</td>\n",
" <td>Clara Callan</td>\n",
" <td>123629</td>\n",
" <td>9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>0002005018</td>\n",
" <td>Clara Callan</td>\n",
" <td>177458</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>0002005018</td>\n",
" <td>Clara Callan</td>\n",
" <td>200273</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>0002005018</td>\n",
" <td>Clara Callan</td>\n",
" <td>210926</td>\n",
" <td>9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>0002005018</td>\n",
" <td>Clara Callan</td>\n",
" <td>219008</td>\n",
" <td>7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>0002005018</td>\n",
" <td>Clara Callan</td>\n",
" <td>263325</td>\n",
" <td>6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>0060973129</td>\n",
" <td>Decision in Normandy</td>\n",
" <td>8</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>0060973129</td>\n",
" <td>Decision in Normandy</td>\n",
" <td>2954</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>0060973129</td>\n",
" <td>Decision in Normandy</td>\n",
" <td>152827</td>\n",
" <td>7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>0374157065</td>\n",
" <td>Flu: The Story of the Great Influenza Pandemic...</td>\n",
" <td>8</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>0374157065</td>\n",
" <td>Flu: The Story of the Great Influenza Pandemic...</td>\n",
" <td>35704</td>\n",
" <td>6</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" ISBN Book-Title User-ID \\\n",
"0 0195153448 Classical Mythology 2 \n",
"1 0002005018 Clara Callan 8 \n",
"2 0002005018 Clara Callan 11400 \n",
"3 0002005018 Clara Callan 11676 \n",
"4 0002005018 Clara Callan 41385 \n",
"5 0002005018 Clara Callan 67544 \n",
"6 0002005018 Clara Callan 85526 \n",
"7 0002005018 Clara Callan 96054 \n",
"8 0002005018 Clara Callan 116866 \n",
"9 0002005018 Clara Callan 123629 \n",
"10 0002005018 Clara Callan 177458 \n",
"11 0002005018 Clara Callan 200273 \n",
"12 0002005018 Clara Callan 210926 \n",
"13 0002005018 Clara Callan 219008 \n",
"14 0002005018 Clara Callan 263325 \n",
"15 0060973129 Decision in Normandy 8 \n",
"16 0060973129 Decision in Normandy 2954 \n",
"17 0060973129 Decision in Normandy 152827 \n",
"18 0374157065 Flu: The Story of the Great Influenza Pandemic... 8 \n",
"19 0374157065 Flu: The Story of the Great Influenza Pandemic... 35704 \n",
"\n",
" Book-Rating \n",
"0 0 \n",
"1 5 \n",
"2 0 \n",
"3 8 \n",
"4 0 \n",
"5 8 \n",
"6 0 \n",
"7 0 \n",
"8 9 \n",
"9 9 \n",
"10 0 \n",
"11 8 \n",
"12 9 \n",
"13 7 \n",
"14 6 \n",
"15 0 \n",
"16 8 \n",
"17 7 \n",
"18 0 \n",
"19 6 "
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#combing books df and rating df togather\n",
"books_df = books_df.loc[:,['ISBN','Book-Title']]\n",
"df = pd.merge(books_df,rating_df,on='ISBN')\n",
"\n",
"df.head(20)"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"(883079, 4)"
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.shape"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {},
"outputs": [],
"source": [
"sample_size = 15000\n",
"df = df.sample(n=sample_size,replace=False, random_state=490)\n",
"#since the dataset is large we sample it down only to 15k entreis "
]
},
{
"cell_type": "code",
"execution_count": 12,
"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>User-ID</th>\n",
" <th>Book-Rating</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>683535</th>\n",
" <td>0140186417</td>\n",
" <td>In Dubious Battle (20th Century Classics)</td>\n",
" <td>141450</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>877401</th>\n",
" <td>0835605833</td>\n",
" <td>A Spiritual Approach to Male/Female Relations ...</td>\n",
" <td>230522</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>60796</th>\n",
" <td>0553258001</td>\n",
" <td>The Cider House Rules</td>\n",
" <td>98741</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>659619</th>\n",
" <td>0061053120</td>\n",
" <td>Love in Vein: Twenty Original Tales of Vampiri...</td>\n",
" <td>150124</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>493146</th>\n",
" <td>0373483589</td>\n",
" <td>Mother'S Gift (Silhouette Promo)</td>\n",
" <td>190807</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>526994</th>\n",
" <td>0425141438</td>\n",
" <td>By a Woman's Hand: A Guide to Mystery Fiction ...</td>\n",
" <td>30735</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>808102</th>\n",
" <td>0440408997</td>\n",
" <td>Maizon at Blue Hill</td>\n",
" <td>174791</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>492773</th>\n",
" <td>0836220552</td>\n",
" <td>Men Should Come With Instructi</td>\n",
" <td>39616</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>678659</th>\n",
" <td>0671529447</td>\n",
" <td>Nightmare in 3-D (Ghosts of Fear Street #4)</td>\n",
" <td>62239</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>221322</th>\n",
" <td>0060987324</td>\n",
" <td>Girlfriend in a Coma</td>\n",
" <td>64215</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>303921</th>\n",
" <td>0671693816</td>\n",
" <td>Wifey</td>\n",
" <td>241982</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>854467</th>\n",
" <td>0553566385</td>\n",
" <td>In Love With the Enemy (Sweet Valley High , No...</td>\n",
" <td>151790</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>198134</th>\n",
" <td>3257211945</td>\n",
" <td>Das Hotel New Hampshire</td>\n",
" <td>34521</td>\n",
" <td>5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>869656</th>\n",
" <td>1551101408</td>\n",
" <td>Coyotes in the Crosswalk: Canadian Wildlife in...</td>\n",
" <td>173650</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>700218</th>\n",
" <td>038097519X</td>\n",
" <td>Faint Echoes, Distant Stars: The Science and P...</td>\n",
" <td>98391</td>\n",
" <td>9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>685939</th>\n",
" <td>3458344497</td>\n",
" <td>Die Buchhandlung</td>\n",
" <td>88726</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>783284</th>\n",
" <td>0340829656</td>\n",
" <td>Crossing the Lines</td>\n",
" <td>179791</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>728039</th>\n",
" <td>0743445341</td>\n",
" <td>Tuesday the Rabbi Saw Red (Rabbi Small Mysteri...</td>\n",
" <td>234623</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>639923</th>\n",
" <td>0684844400</td>\n",
" <td>Into the Twilight, Endlessly Grousing</td>\n",
" <td>206695</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>618852</th>\n",
" <td>0451144465</td>\n",
" <td>The Unicorn Gambit (The Gaming Magi, Book 3)</td>\n",
" <td>44595</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>401772</th>\n",
" <td>2070366073</td>\n",
" <td>Les Mots</td>\n",
" <td>141752</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>681727</th>\n",
" <td>0070191727</td>\n",
" <td>Dynasty: A Novel</td>\n",
" <td>243759</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>377579</th>\n",
" <td>0684853299</td>\n",
" <td>Morgan'S Run</td>\n",
" <td>65791</td>\n",
" <td>6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>318747</th>\n",
" <td>0373074808</td>\n",
" <td>Diamond Willow (Silhouette Intimate Moments, N...</td>\n",
" <td>4385</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>331472</th>\n",
" <td>0385498055</td>\n",
" <td>The Daydreamer</td>\n",
" <td>267545</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>646754</th>\n",
" <td>0373245475</td>\n",
" <td>Alaskan Nights</td>\n",
" <td>215728</td>\n",
" <td>6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>367986</th>\n",
" <td>0394800869</td>\n",
" <td>Thidwick the Big-Hearted Moose</td>\n",
" <td>256251</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>690581</th>\n",
" <td>0007126972</td>\n",
" <td>Unless I'm Very Much Mistaken: My Autobiography</td>\n",
" <td>152726</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>640626</th>\n",
" <td>1566199239</td>\n",
" <td>100 Hair Raising Little Horror Stories</td>\n",
" <td>271598</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121644</th>\n",
" <td>0439064872</td>\n",
" <td>Harry Potter and the Chamber of Secrets (Book 2)</td>\n",
" <td>121561</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>546711</th>\n",
" <td>006019443X</td>\n",
" <td>The Sinister Pig (Hillerman, Tony)</td>\n",
" <td>125403</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>802018</th>\n",
" <td>2253170429</td>\n",
" <td>Expiation</td>\n",
" <td>172888</td>\n",
" <td>7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>103738</th>\n",
" <td>080411935X</td>\n",
" <td>Standing in the Rainbow</td>\n",
" <td>88620</td>\n",
" <td>7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>806189</th>\n",
" <td>2070426793</td>\n",
" <td>Le Festin chez la comtesse Fritouille et autre...</td>\n",
" <td>142649</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>543485</th>\n",
" <td>0671496174</td>\n",
" <td>Robert Frost's Poems</td>\n",
" <td>138198</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>646209</th>\n",
" <td>0785329307</td>\n",
" <td>Cherished Teddies ~ Angels Amoung Us ~ Heavenl...</td>\n",
" <td>51883</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>864101</th>\n",
" <td>0380706121</td>\n",
" <td>In Trouble Again, Zelda Hammersmith?</td>\n",
" <td>69042</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>729827</th>\n",
" <td>0451411048</td>\n",
" <td>Silent Proof</td>\n",
" <td>204591</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>833444</th>\n",
" <td>2020549824</td>\n",
" <td>M�¨re agit�©e</td>\n",
" <td>154511</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>390677</th>\n",
" <td>0446603643</td>\n",
" <td>The Eagle and the Rose : A Remarkable True Story</td>\n",
" <td>14966</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>151970</th>\n",
" <td>0399142789</td>\n",
" <td>Conversations with God : An Uncommon Dialogue ...</td>\n",
" <td>4017</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>440916</th>\n",
" <td>0425182673</td>\n",
" <td>Cybernation (Tom Clancy's Net Force, No. 6)</td>\n",
" <td>185327</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>140306</th>\n",
" <td>0316284955</td>\n",
" <td>White Oleander : A Novel (Oprah's Book Club)</td>\n",
" <td>235209</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>65372</th>\n",
" <td>0553377868</td>\n",
" <td>The Flanders Panel</td>\n",
" <td>1075</td>\n",
" <td>9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>709440</th>\n",
" <td>3257016786</td>\n",
" <td>Das Parfum: Die Geschichte eines Mörders</td>\n",
" <td>163665</td>\n",
" <td>9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>89527</th>\n",
" <td>1558747028</td>\n",
" <td>Chicken Soup for the College Soul : Inspiring ...</td>\n",
" <td>235842</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>336181</th>\n",
" <td>0156027127</td>\n",
" <td>The Life Before Her Eyes</td>\n",
" <td>190741</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>350049</th>\n",
" <td>0679738290</td>\n",
" <td>The Virgin in the Garden</td>\n",
" <td>254064</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3408</th>\n",
" <td>0345402871</td>\n",
" <td>Airframe</td>\n",
" <td>199927</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>533091</th>\n",
" <td>0553577360</td>\n",
" <td>The Garden Tour Affair (Gardening Mysteries (P...</td>\n",
" <td>134797</td>\n",
" <td>0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" ISBN Book-Title \\\n",
"683535 0140186417 In Dubious Battle (20th Century Classics) \n",
"877401 0835605833 A Spiritual Approach to Male/Female Relations ... \n",
"60796 0553258001 The Cider House Rules \n",
"659619 0061053120 Love in Vein: Twenty Original Tales of Vampiri... \n",
"493146 0373483589 Mother'S Gift (Silhouette Promo) \n",
"526994 0425141438 By a Woman's Hand: A Guide to Mystery Fiction ... \n",
"808102 0440408997 Maizon at Blue Hill \n",
"492773 0836220552 Men Should Come With Instructi \n",
"678659 0671529447 Nightmare in 3-D (Ghosts of Fear Street #4) \n",
"221322 0060987324 Girlfriend in a Coma \n",
"303921 0671693816 Wifey \n",
"854467 0553566385 In Love With the Enemy (Sweet Valley High , No... \n",
"198134 3257211945 Das Hotel New Hampshire \n",
"869656 1551101408 Coyotes in the Crosswalk: Canadian Wildlife in... \n",
"700218 038097519X Faint Echoes, Distant Stars: The Science and P... \n",
"685939 3458344497 Die Buchhandlung \n",
"783284 0340829656 Crossing the Lines \n",
"728039 0743445341 Tuesday the Rabbi Saw Red (Rabbi Small Mysteri... \n",
"639923 0684844400 Into the Twilight, Endlessly Grousing \n",
"618852 0451144465 The Unicorn Gambit (The Gaming Magi, Book 3) \n",
"401772 2070366073 Les Mots \n",
"681727 0070191727 Dynasty: A Novel \n",
"377579 0684853299 Morgan'S Run \n",
"318747 0373074808 Diamond Willow (Silhouette Intimate Moments, N... \n",
"331472 0385498055 The Daydreamer \n",
"646754 0373245475 Alaskan Nights \n",
"367986 0394800869 Thidwick the Big-Hearted Moose \n",
"690581 0007126972 Unless I'm Very Much Mistaken: My Autobiography \n",
"640626 1566199239 100 Hair Raising Little Horror Stories \n",
"121644 0439064872 Harry Potter and the Chamber of Secrets (Book 2) \n",
"546711 006019443X The Sinister Pig (Hillerman, Tony) \n",
"802018 2253170429 Expiation \n",
"103738 080411935X Standing in the Rainbow \n",
"806189 2070426793 Le Festin chez la comtesse Fritouille et autre... \n",
"543485 0671496174 Robert Frost's Poems \n",
"646209 0785329307 Cherished Teddies ~ Angels Amoung Us ~ Heavenl... \n",
"864101 0380706121 In Trouble Again, Zelda Hammersmith? \n",
"729827 0451411048 Silent Proof \n",
"833444 2020549824 M�¨re agit�©e \n",
"390677 0446603643 The Eagle and the Rose : A Remarkable True Story \n",
"151970 0399142789 Conversations with God : An Uncommon Dialogue ... \n",
"440916 0425182673 Cybernation (Tom Clancy's Net Force, No. 6) \n",
"140306 0316284955 White Oleander : A Novel (Oprah's Book Club) \n",
"65372 0553377868 The Flanders Panel \n",
"709440 3257016786 Das Parfum: Die Geschichte eines Mörders \n",
"89527 1558747028 Chicken Soup for the College Soul : Inspiring ... \n",
"336181 0156027127 The Life Before Her Eyes \n",
"350049 0679738290 The Virgin in the Garden \n",
"3408 0345402871 Airframe \n",
"533091 0553577360 The Garden Tour Affair (Gardening Mysteries (P... \n",
"\n",
" User-ID Book-Rating \n",
"683535 141450 0 \n",
"877401 230522 0 \n",
"60796 98741 0 \n",
"659619 150124 0 \n",
"493146 190807 0 \n",
"526994 30735 8 \n",
"808102 174791 0 \n",
"492773 39616 0 \n",
"678659 62239 0 \n",
"221322 64215 0 \n",
"303921 241982 0 \n",
"854467 151790 0 \n",
"198134 34521 5 \n",
"869656 173650 0 \n",
"700218 98391 9 \n",
"685939 88726 8 \n",
"783284 179791 0 \n",
"728039 234623 0 \n",
"639923 206695 10 \n",
"618852 44595 0 \n",
"401772 141752 8 \n",
"681727 243759 0 \n",
"377579 65791 6 \n",
"318747 4385 10 \n",
"331472 267545 0 \n",
"646754 215728 6 \n",
"367986 256251 0 \n",
"690581 152726 0 \n",
"640626 271598 8 \n",
"121644 121561 10 \n",
"546711 125403 0 \n",
"802018 172888 7 \n",
"103738 88620 7 \n",
"806189 142649 0 \n",
"543485 138198 0 \n",
"646209 51883 0 \n",
"864101 69042 0 \n",
"729827 204591 0 \n",
"833444 154511 0 \n",
"390677 14966 0 \n",
"151970 4017 10 \n",
"440916 185327 0 \n",
"140306 235209 10 \n",
"65372 1075 9 \n",
"709440 163665 9 \n",
"89527 235842 0 \n",
"336181 190741 0 \n",
"350049 254064 0 \n",
"3408 199927 0 \n",
"533091 134797 0 "
]
},
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.head(50)"
]
},
{
"cell_type": "code",
"execution_count": 13,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"(15000, 4)"
]
},
"execution_count": 13,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.shape"
]
},
{
"cell_type": "code",
"execution_count": 14,
"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>Deceived</th>\n",
" <th>Murder of a Sleeping Beauty (Scumble River Mysteries (Paperback))</th>\n",
" <th>'Salem's Lot</th>\n",
" <th>'The Moon by Whale Light: And Other Adventures Among Bats, Penguins, Crocodilians, and Whales</th>\n",
" <th>'Til Death Do Us Part</th>\n",
" <th>...And Ladies of the Club</th>\n",
" <th>1,000 Places to See Before You Die</th>\n",
" <th>10 Minute Guide to Paying for Grad School (10 Minute Guides)</th>\n",
" <th>10 Minute Marketing - A Daily Routine for Success (Book, Video, Cassette, &amp;amp; Disk/Windows)</th>\n",
" <th>10,000 Ways to Say I Love You: The Biggest Collection of Romantic Ideas Ever Gathered in One Place</th>\n",
" <th>...</th>\n",
" <th>\\The Happy Prince\\\" and Other Stories (Penguin Popular Classics)\"</th>\n",
" <th>\\Time Out\\\" Book of London Short Stories (\\\"Time Out\\\" Guides)\"</th>\n",
" <th>\\Which?\\\" Way to Buy, Sell and Move House\"</th>\n",
" <th>dtv - Atlas Musik 2. Musikgeschichte vom Barock bis zur Gegenwart.</th>\n",
" <th>iI Paradiso Degli Orchi</th>\n",
" <th>murder@maggody.com : An Arly Hanks Mystery (Arly Hanks Mysteries (Paperback))</th>\n",
" <th>one hundred years of solitude</th>\n",
" <th>stardust</th>\n",
" <th>the Heiress Bride (sister brides)</th>\n",
" <th>Ã?Â?sterlich leben.</th>\n",
" </tr>\n",
" <tr>\n",
" <th>User-ID</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>243</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>254</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>383</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>388</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>408</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>441</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>507</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>628</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>638</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>643</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>10 rows × 12233 columns</p>\n",
"</div>"
],
"text/plain": [
"Book-Title Deceived \\\n",
"User-ID \n",
"243 NaN \n",
"254 NaN \n",
"383 NaN \n",
"388 NaN \n",
"408 NaN \n",
"441 NaN \n",
"507 NaN \n",
"628 NaN \n",
"638 NaN \n",
"643 NaN \n",
"\n",
"Book-Title Murder of a Sleeping Beauty (Scumble River Mysteries (Paperback)) \\\n",
"User-ID \n",
"243 NaN \n",
"254 NaN \n",
"383 NaN \n",
"388 NaN \n",
"408 NaN \n",
"441 NaN \n",
"507 NaN \n",
"628 NaN \n",
"638 NaN \n",
"643 NaN \n",
"\n",
"Book-Title 'Salem's Lot \\\n",
"User-ID \n",
"243 NaN \n",
"254 NaN \n",
"383 NaN \n",
"388 NaN \n",
"408 NaN \n",
"441 NaN \n",
"507 NaN \n",
"628 NaN \n",
"638 NaN \n",
"643 NaN \n",
"\n",
"Book-Title 'The Moon by Whale Light: And Other Adventures Among Bats, Penguins, Crocodilians, and Whales \\\n",
"User-ID \n",
"243 NaN \n",
"254 NaN \n",
"383 NaN \n",
"388 NaN \n",
"408 NaN \n",
"441 NaN \n",
"507 NaN \n",
"628 NaN \n",
"638 NaN \n",
"643 NaN \n",
"\n",
"Book-Title 'Til Death Do Us Part ...And Ladies of the Club \\\n",
"User-ID \n",
"243 NaN NaN \n",
"254 NaN NaN \n",
"383 NaN NaN \n",
"388 NaN NaN \n",
"408 NaN NaN \n",
"441 NaN NaN \n",
"507 NaN NaN \n",
"628 NaN NaN \n",
"638 NaN NaN \n",
"643 NaN NaN \n",
"\n",
"Book-Title 1,000 Places to See Before You Die \\\n",
"User-ID \n",
"243 NaN \n",
"254 NaN \n",
"383 NaN \n",
"388 NaN \n",
"408 NaN \n",
"441 NaN \n",
"507 NaN \n",
"628 NaN \n",
"638 NaN \n",
"643 NaN \n",
"\n",
"Book-Title 10 Minute Guide to Paying for Grad School (10 Minute Guides) \\\n",
"User-ID \n",
"243 NaN \n",
"254 NaN \n",
"383 NaN \n",
"388 NaN \n",
"408 NaN \n",
"441 NaN \n",
"507 NaN \n",
"628 NaN \n",
"638 NaN \n",
"643 NaN \n",
"\n",
"Book-Title 10 Minute Marketing - A Daily Routine for Success (Book, Video, Cassette, &amp; Disk/Windows) \\\n",
"User-ID \n",
"243 NaN \n",
"254 NaN \n",
"383 NaN \n",
"388 NaN \n",
"408 NaN \n",
"441 NaN \n",
"507 NaN \n",
"628 NaN \n",
"638 NaN \n",
"643 NaN \n",
"\n",
"Book-Title 10,000 Ways to Say I Love You: The Biggest Collection of Romantic Ideas Ever Gathered in One Place \\\n",
"User-ID \n",
"243 NaN \n",
"254 NaN \n",
"383 NaN \n",
"388 NaN \n",
"408 NaN \n",
"441 NaN \n",
"507 NaN \n",
"628 NaN \n",
"638 NaN \n",
"643 NaN \n",
"\n",
"Book-Title ... \\\n",
"User-ID ... \n",
"243 ... \n",
"254 ... \n",
"383 ... \n",
"388 ... \n",
"408 ... \n",
"441 ... \n",
"507 ... \n",
"628 ... \n",
"638 ... \n",
"643 ... \n",
"\n",
"Book-Title \\The Happy Prince\\\" and Other Stories (Penguin Popular Classics)\" \\\n",
"User-ID \n",
"243 NaN \n",
"254 NaN \n",
"383 NaN \n",
"388 NaN \n",
"408 NaN \n",
"441 NaN \n",
"507 NaN \n",
"628 NaN \n",
"638 NaN \n",
"643 NaN \n",
"\n",
"Book-Title \\Time Out\\\" Book of London Short Stories (\\\"Time Out\\\" Guides)\" \\\n",
"User-ID \n",
"243 NaN \n",
"254 NaN \n",
"383 NaN \n",
"388 NaN \n",
"408 NaN \n",
"441 NaN \n",
"507 NaN \n",
"628 NaN \n",
"638 NaN \n",
"643 NaN \n",
"\n",
"Book-Title \\Which?\\\" Way to Buy, Sell and Move House\" \\\n",
"User-ID \n",
"243 NaN \n",
"254 NaN \n",
"383 NaN \n",
"388 NaN \n",
"408 NaN \n",
"441 NaN \n",
"507 NaN \n",
"628 NaN \n",
"638 NaN \n",
"643 NaN \n",
"\n",
"Book-Title dtv - Atlas Musik 2. Musikgeschichte vom Barock bis zur Gegenwart. \\\n",
"User-ID \n",
"243 NaN \n",
"254 NaN \n",
"383 NaN \n",
"388 NaN \n",
"408 NaN \n",
"441 NaN \n",
"507 NaN \n",
"628 NaN \n",
"638 NaN \n",
"643 NaN \n",
"\n",
"Book-Title iI Paradiso Degli Orchi \\\n",
"User-ID \n",
"243 NaN \n",
"254 NaN \n",
"383 NaN \n",
"388 NaN \n",
"408 NaN \n",
"441 NaN \n",
"507 NaN \n",
"628 NaN \n",
"638 NaN \n",
"643 NaN \n",
"\n",
"Book-Title murder@maggody.com : An Arly Hanks Mystery (Arly Hanks Mysteries (Paperback)) \\\n",
"User-ID \n",
"243 NaN \n",
"254 NaN \n",
"383 NaN \n",
"388 NaN \n",
"408 NaN \n",
"441 NaN \n",
"507 NaN \n",
"628 NaN \n",
"638 NaN \n",
"643 NaN \n",
"\n",
"Book-Title one hundred years of solitude stardust \\\n",
"User-ID \n",
"243 NaN NaN \n",
"254 NaN NaN \n",
"383 NaN NaN \n",
"388 NaN NaN \n",
"408 NaN NaN \n",
"441 NaN NaN \n",
"507 NaN NaN \n",
"628 NaN NaN \n",
"638 NaN NaN \n",
"643 NaN NaN \n",
"\n",
"Book-Title the Heiress Bride (sister brides) Ã?Â?sterlich leben. \n",
"User-ID \n",
"243 NaN NaN \n",
"254 NaN NaN \n",
"383 NaN NaN \n",
"388 NaN NaN \n",
"408 NaN NaN \n",
"441 NaN NaN \n",
"507 NaN NaN \n",
"628 NaN NaN \n",
"638 NaN NaN \n",
"643 NaN NaN \n",
"\n",
"[10 rows x 12233 columns]"
]
},
"execution_count": 14,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#creating the matrix of user rating and books\n",
"\n",
"pivot_table = df.pivot_table(index=['User-ID'],columns=['Book-Title'],values=\"Book-Rating\")\n",
"pivot_table.head(10)\n",
"#pivot table shows the relation ship between all users and all the movies in matrix format."
]
},
{
"cell_type": "code",
"execution_count": 15,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"<class 'pandas.core.frame.DataFrame'>\n",
"Index: 6787 entries, 243 to 278789\n",
"Columns: 12233 entries, Deceived to Ã?Â?sterlich leben.\n",
"dtypes: float64(12233)\n",
"memory usage: 633.5 MB\n"
]
}
],
"source": [
"pivot_table.info()"
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"[' Deceived',\n",
" ' Murder of a Sleeping Beauty (Scumble River Mysteries (Paperback))',\n",
" \"'Salem's Lot\",\n",
" \"'The Moon by Whale Light: And Other Adventures Among Bats, Penguins, Crocodilians, and Whales\",\n",
" \"'Til Death Do Us Part\",\n",
" '...And Ladies of the Club',\n",
" '1,000 Places to See Before You Die',\n",
" '10 Minute Guide to Paying for Grad School (10 Minute Guides)',\n",
" '10 Minute Marketing - A Daily Routine for Success (Book, Video, Cassette, &amp; Disk/Windows)',\n",
" '10,000 Ways to Say I Love You: The Biggest Collection of Romantic Ideas Ever Gathered in One Place',\n",
" '100 Hair Raising Little Horror Stories',\n",
" '100 Questions Every First-Time Home Buyer Should Ask : With Answers from Top Brokers from Around the Country',\n",
" '100 Selected Stories (Wordsworth Classics)',\n",
" '100 Ways to Motivate Yourself',\n",
" '100 hikes in the South Cascades and Olympics',\n",
" '1000 Facts About the Earth (1000 Facts about)',\n",
" '101 Dalmatians',\n",
" '101 Ethical Dilemmas',\n",
" '101 Hamburger Jokes',\n",
" '101 Reasons for Time-out in Kindergarten &amp; Preschool',\n",
" '101 Reykjavik',\n",
" '101 School Jokes',\n",
" '101 Silly Summertime Jokes',\n",
" '101 cuentos clásicos de la China',\n",
" '11 Harrow House',\n",
" '12 Days on the Road: The Sex Pistols and America',\n",
" '12 Steps to Raw Foods: How to End Your Addiction to Cooked Food',\n",
" '12 steps to living without fear',\n",
" '13 Short Espionage Novels',\n",
" '13th Gen: Abort, Retry, Ignore, Fail?',\n",
" '16 Lighthouse Road',\n",
" '1632 (Assiti Shards (Paperback))',\n",
" '1812 (The American Story)',\n",
" '1916',\n",
" '1921 : The Great Novel of the Irish Civil War (Irish Century)',\n",
" '1939',\n",
" '1984',\n",
" \"1984 (Everyman's Library)\",\n",
" '1984 (Signet Classics (Paperback))',\n",
" '1ST AMONG EQUALS',\n",
" '1st to Die: A Novel',\n",
" '20,000 Leagues Under the Sea (Scholastic Classics)',\n",
" '20,000 Leagues Under the Sea (Wordsworth Collection)',\n",
" '2001',\n",
" '2001: On the Edge of Eternity',\n",
" '2002 ESPN Information Please Sports Almanac: The Definitive Sports Reference Book',\n",
" \"2002 Novel &amp; Short Story Writers Market (Novel and Short Story Writer's Market)\",\n",
" '2010: Odyssey Two',\n",
" '2020 VISION',\n",
" '204 Rosewood Lane',\n",
" '2061: Odyssey Three',\n",
" '21 Dog Years : Doing Time @ Amazon.com',\n",
" '24 Hours',\n",
" '2nd Chance',\n",
" '3 Culinary Mysteries: An Audio Book Trilogy of Best Sellers : Dying for Chocolate/Catering to Nobody/the Last Suppers',\n",
" '3-D Cross Stitch: More Than 25 Original Designs',\n",
" '30 Days to a More Powerful Vocabulary',\n",
" '300 Incredible Things for Sports Fans on the Internet',\n",
" '300 Tips for Making Life with Multiple Sclerosis Easier',\n",
" '3001: The Final Odyssey',\n",
" '311 Pelican Court',\n",
" '35,000+ Baby Names: The Largest Selection of Popular and Unusual Names from Around the World',\n",
" '36 Hours Christmas (Silhouette Promo)',\n",
" '365 Tao : Daily Meditations',\n",
" '365 science projects &amp; activities',\n",
" '3rd Degree',\n",
" '4 Blondes',\n",
" '4 Classic American Novels: The Scarlet Letter, Adventures of Huckleberry Finn, Red Badge of Courage, and Billy Budd (Signet Classics (Paperback))',\n",
" '40 TO 60 YR MALE',\n",
" '4:50 From Paddington (Miss Marple Mysteries (Paperback))',\n",
" '500 Terrific Ideas for Organizing Everything',\n",
" '501 Spanish Verbs: Fully Conjugated in All the Tenses and Moods in a New Easy-To-Learn Format',\n",
" '501 Spanish Verbs: Fully Conjugated in All the Tenses in a New Easy-to-Learn Format Alphabetically Arranged',\n",
" '52 Simple Ways to Make Christmas Special',\n",
" '600 Crises or Growing Up Italian',\n",
" '61 Cooperative Learning Activities: Thinking, Writing, and Speaking Skills',\n",
" '722 Miles: The Building of the Subways and How They Transformed New York',\n",
" '99 1/2 Creepy Crawly Jokes, Ribbles &amp; Nonsense',\n",
" 'A 4: Hand of Oberon (Amber Novels (Paperback))',\n",
" 'A 2nd Helping of Chicken Soup for the Soul (Chicken Soup for the Soul Series (Paper))',\n",
" 'A 3rd Serving of Chicken Soup for the Soul (Chicken Soup for the Soul Series (Paper))',\n",
" 'A 4th Course of Chicken Soup for the Soul: 101 More Stories to Open the Heart and Rekindle the Spirit',\n",
" 'A BEAUTIFUL MIND: A Biography of John Forbes Nash, Jr., Winner of the Nobel Prize in Economics, 1994',\n",
" 'A Baby For Emily (Silhouette Special Edition, No. 1466)',\n",
" 'A Bad Spell for the Worst Witch',\n",
" 'A Beautiful Mind: The Life of Mathematical Genius and Nobel Laureate John Nash',\n",
" 'A Bed by the Window: A Novel of Mystery and Redemption',\n",
" 'A Belated Bride',\n",
" 'A Bell for Adano',\n",
" 'A Bloodsmoor Romance',\n",
" 'A Book About Planets and Stars',\n",
" 'A Book Without Covers',\n",
" 'A Book of Angels',\n",
" 'A Book of Angels: Reflections on Angels Past and Present and True Stories of How They Touch Our Lives',\n",
" 'A Book of Psalms: Selected and Adapted from the Hebrew',\n",
" 'A Bouquet of Flowers: Sweet Thoughts, Recipes, and Gifts from the Garden With \\\\the Language of Flowers\\\\\"\"',\n",
" 'A Boy I Once Knew: What a Teacher Learned from Her Student',\n",
" 'A Boy at the Leafs Camp (Hockey Stories)',\n",
" 'A Breach of Promise (William Monk Novels (Paperback))',\n",
" 'A Bride for Lord Beaumont (Zebra Regency Romance)',\n",
" 'A Brief History of Time : From the Big Bang to Black Holes',\n",
" 'A Brief History of Time: From the Big Bang to Black Holes',\n",
" 'A Broken Vessel',\n",
" 'A Bundle for the Toff',\n",
" 'A Burden of Earth',\n",
" 'A CORNER OF THE VEIL : A Novel',\n",
" 'A CRIME FOR CHRISTMAS NANCY DREW &amp; HARDY BOYS SUPERMYSTERY (Nancy Drew Hardy Boys Super Mystery)',\n",
" 'A Cafecito Story',\n",
" 'A Calculus of Angels (The Age of Unreason, Book 2)',\n",
" \"A Candle for d'Artagnan\",\n",
" 'A Canticle for Leibowitz (Bantam Spectra Book)',\n",
" 'A Capital Holiday (Zebra Book.)',\n",
" 'A Caribbean Mystery',\n",
" 'A Case of Need',\n",
" 'A Cast of Killers',\n",
" 'A Cast of Killers (Hubbert &amp; Lil : Partners in Crime Series)',\n",
" \"A Cat's Little Instruction Book\",\n",
" 'A Cavern of Black Ice (Sword of Shadows, Book 1)',\n",
" 'A Certain Justice: A Novel',\n",
" 'A Child Called \\\\It\\\\\": One Child\\'s Courage to Survive\"',\n",
" \"A Child's Book of Myths and Enchantment Tales\",\n",
" \"A Child's Book of True Crime\",\n",
" 'A Christmas Carol (Fun-to-Read Fairy Tales)',\n",
" 'A Christmas Carol (Tor Classics)',\n",
" 'A Christmas Dozen: Christmas Stories to Warm the Heart',\n",
" 'A Christmas Story',\n",
" 'A Civil Action',\n",
" 'A Clean Slate (Red Dress Ink)',\n",
" 'A Coffin for Dimitrios (Vintage Crime/Black Lizard)',\n",
" 'A Cold Day for Murder',\n",
" 'A Cold Heart (Alex Delaware Novels (Paperback))',\n",
" 'A Cold Heart: An Alex Delaware Novel',\n",
" 'A Cold-Blooded Business: A Kate Shugak Mystery',\n",
" 'A Collection of Beauties at the Height of Their Popularity: A Novel',\n",
" 'A College of Magics',\n",
" 'A Common Life : The Wedding Story (The Mitford Years)',\n",
" 'A Confederacy of Crime',\n",
" 'A Confederacy of Dunces',\n",
" 'A Confederacy of Dunces (Evergreen Book)',\n",
" \"A Connecticut Yankee in King Arthur's Court\",\n",
" \"A Connecticut Yankee in King Arthur's Court (Bantam Classic)\",\n",
" \"A Conspiracy of Paper : A Novel (Ballantine Reader's Circle)\",\n",
" 'A Conspiracy of Paper: A Novel',\n",
" 'A Constellation of Cats (Daw Book Collectors)',\n",
" 'A Convenient Marriage: The Reasons for Marriage/ A Lady of Expectations',\n",
" 'A Conventional Corpse : A Claire Malloy Mystery (A Claire Malloy Mystery)',\n",
" \"A Cook's Tour : Global Adventures in Extreme Cuisines\",\n",
" 'A Cool Kid-- Like Me!',\n",
" 'A Couple of Kooks and Other Stories About Love',\n",
" 'A Course of Love: The Complete Course',\n",
" 'A Courtship for Mama (Zebra Regency Romance)',\n",
" 'A Cowboy for Christmas (Zebra Historical Romance)',\n",
" 'A Crime in the Neighborhood',\n",
" 'A Crown of Lights',\n",
" 'A Crown of Swords (The Wheel of Time, Book 7)',\n",
" 'A Cry In The Night',\n",
" 'A Cup of Comfort for Friends: Stories That Celebrate the Special People in Our Lives',\n",
" 'A Cup of Comfort: Stories That Warm Your Heart, Lift Your Spirit, and Enrich Your Life',\n",
" 'A Cup of Light',\n",
" 'A Curtain of Green: and Other Stories',\n",
" 'A Dangerous Temptation',\n",
" 'A Dangerous Woman',\n",
" 'A Dark Adapted Eye',\n",
" 'A Darker Place',\n",
" 'A Darkness More Than Night',\n",
" 'A Day Late and a Dollar Short',\n",
" 'A Day No Pigs Would Die',\n",
" 'A Day at the Fair (Alf)',\n",
" 'A Deadly Quiet : An Inupiat Eskimo Mystery (Inupiat Eskimo Mysteries)',\n",
" 'A Deal With the Devil',\n",
" 'A Death in China (Vintage Crime/Black Lizard)',\n",
" 'A Death in the Family',\n",
" 'A Dictionary of Australian Colloquialisms',\n",
" 'A Dictionary of Linguistics and Phonetics (Language Library)',\n",
" 'A Different Angle: Fly Fishing Stories by Women',\n",
" 'A Dilly of a Death',\n",
" \"A Distant Presence: The Story Behind Paul's Letter to the Philippians (Narrative Commentary Series)\",\n",
" 'A Distant Star (Love Spell)',\n",
" 'A Dog Called Demolition',\n",
" \"A Doll's House\",\n",
" 'A Drink Before the War (Patrick Kenzie/Angela Gennaro Novels)',\n",
" 'A Fairly Honourable Defeat (Penguin Twentieth Century Classics)',\n",
" 'A Fall in Denver: An Em Hansen Mystery',\n",
" 'A Fatal Inversion (Plume Fiction)',\n",
" \"A Father's Fortune\",\n",
" 'A Fearsome Doubt (Inspector Ian Rutledge Mysteries (Paperback))',\n",
" 'A Few Minutes with Andy Rooney',\n",
" 'A Field Guide to Wildflowers of Northeastern and North-Central North America',\n",
" 'A Fine Balance',\n",
" 'A Fine Daughter (Fiction)',\n",
" 'A Fine and Pleasant Misery',\n",
" 'A First Book of Opposites (Dinosaur Playhouse book)',\n",
" 'A Fish Caught in Time : The Search for the Coelacanth',\n",
" \"A Fishkeeper's Guide to Aquarium Plants: A Superbly Illustrated Guide to Growing Healthy Aquarium Plants, Featuring over 60 Species\",\n",
" 'A Fit of Tempera (Bed-And-Breakfast Mysteries (Paperback))',\n",
" 'A Force Of Habit (Sister Abigail Mysteries)',\n",
" 'A Free Man of Color (Benjamin January (Paperback))',\n",
" 'A Free Woman',\n",
" 'A Friend Is Someone Special',\n",
" 'A Friend for Frances (Tale from the Care Bears)',\n",
" 'A Frozen Fire',\n",
" 'A Game for the Living',\n",
" 'A Game of Scandal',\n",
" 'A Game of Thrones (A Song of Ice and Fire, Book 1)',\n",
" 'A Garth Williams Treasury of Best-Loved Golden Books',\n",
" 'A Gathering Of Finches (Dreamcatcher)',\n",
" 'A Gentle Feuding',\n",
" 'A Gentle Giving',\n",
" 'A Gift To Last',\n",
" 'A Girl Named Disaster',\n",
" 'A Girl Named Zippy: Growing Up Small in Mooreland Indiana (Today Show Book Club #3)',\n",
" \"A Girl's Best Friend\",\n",
" 'A Good Hanging (Inspector John Rebus Series)',\n",
" 'A Good Old-Fashioned Future: Stories',\n",
" 'A Gown of Spanish Lace',\n",
" 'A Grand Man',\n",
" 'A Great Day for the Deadly',\n",
" 'A Great Deliverance',\n",
" 'A Habit of the Blood',\n",
" 'A Handbook of Catholic Sacramentals',\n",
" 'A Handful of Time',\n",
" 'A Haven in Winter',\n",
" 'A Heart Full of Love',\n",
" 'A Heartbreaking Work Of Staggering Genius : A Memoir Based on a True Story',\n",
" 'A Heartbreaking Work of Staggering Genius',\n",
" 'A Hidden Magic',\n",
" 'A History of God: The 4,000-Year Quest of Judaism, Christianity and Islam',\n",
" 'A History of the World in 10-1/2 Chapters',\n",
" 'A Home at the End of the World: A Novel',\n",
" 'A Hope in the Unseen : An American Odyssey from the Inner City to the Ivy League',\n",
" 'A Is for Alibi (Kinsey Millhone Mysteries (Paperback))',\n",
" 'A Jest of God (Phoenix Fiction)',\n",
" \"A Journey North: One woman's story of hiking the Appalachian Trail\",\n",
" 'A Journey in Ladakh: Encounters with Buddhism',\n",
" 'A Journey to the New World: The Diary of Remember Patience Whipple, Mayflower, 1620 (Dear America Series)',\n",
" 'A June Bride (Zebra Holiday Regency Romance)',\n",
" 'A KNIGHT IN SHINING ARMOR (SS-CARRESS SOAP)',\n",
" 'A Killing Season',\n",
" 'A Kind of Loving',\n",
" 'A Kingdom of Dreams',\n",
" 'A Kiss Gone Bad',\n",
" 'A Kiss of Shadows (Meredith Gentry Novels (Hardcover))',\n",
" 'A Kiss of Shadows (Meredith Gentry Novels (Paperback))',\n",
" 'A Kiss to Remember',\n",
" 'A LITTLE YELLOW DOG : Featuring an Original Easy Rawlins Short Story \\\\Gray-Eyed Death\\\\\" (Easy Rawlins Mysteries (Paperback))\"',\n",
" 'A Lady of the West',\n",
" 'A Lamp for the Lambchops (A Magnet Book)',\n",
" 'A Lesson Before Dying (Vintage Contemporaries (Paperback))',\n",
" 'A Lesson Before Dying (Vintage Contemporaries)',\n",
" 'A Light in the Attic',\n",
" 'A Light in the Window (The Mitford Trilogy : Book 2)',\n",
" 'A Literary Christmas: Great Contemporary Christmas Stories',\n",
" 'A Literature of Their Own: British Women Novelists from Bronte to Lessing',\n",
" 'A Little Book of Aloha',\n",
" 'A Little Book of Hugs to Encourage and Inspire (Little Book of Hugs Series)',\n",
" 'A Little Help from Above',\n",
" 'A Little Magic',\n",
" 'A Little Mischief (Berkley Sensation)',\n",
" 'A Little Princess (Apple Classics)',\n",
" \"A Long Day's Dying\",\n",
" 'A Long Strange Trip : The Inside History of the Grateful Dead',\n",
" 'A Long Walk in Wintertime',\n",
" 'A Long Way from Chicago: A Novel in Stories',\n",
" 'A Love Worth Waiting For',\n",
" 'A Love of My Own',\n",
" \"A Love' Like No Otha'\",\n",
" \"A Maiden's Grave\",\n",
" 'A Man Betrayed (The Book of Words, Book 2)',\n",
" \"A Man Rides Through (Mordant's Need, Vol 2)\",\n",
" 'A Man for All Seasons: A Play in Two Acts (Vintage International)',\n",
" 'A Man in Full',\n",
" 'A Marriage Made In Texas (The Brothers Kincaid)',\n",
" 'A Marriage Made in Heaven : Or Too Tired for an Affair',\n",
" 'A Matter of Honour',\n",
" 'A Medicine for Melancholy and Other Stories',\n",
" 'A Meeting by the River',\n",
" 'A Memory of Lions',\n",
" 'A Midnight Carol',\n",
" 'A Midnight Clear',\n",
" \"A Midsummer Night's Dream (The Pelican Shakespeare)\",\n",
" 'A Midsummer Nights Dream - Arden Shakespeare : Second Series - Paperback',\n",
" \"A Midwife's Story\",\n",
" \"A Midwinter's Tale (O'Malley Novels (Forge Paperback))\",\n",
" \"A Miracle for St. Cecilia's\",\n",
" 'A Modern Herbal (Volume 2, I-Z and Indexes)',\n",
" 'A Monk Swimming',\n",
" 'A Monk Swimming : A Memoir',\n",
" 'A Month in the Country (New York Review Books Classics)',\n",
" 'A Monumental Journey: Our Journey Begins',\n",
" 'A Morning Affair',\n",
" \"A Mother's Heart (Valuebooks)\",\n",
" 'A Murder Is Announced (Miss Marple Mysteries (Paperback))',\n",
" 'A Murder of Quality (Rediscovery Series)',\n",
" 'A Murder of Quality (Thorndike Press Large Print Basic Series)',\n",
" 'A Murder on the Appian Way (Dead Letter Mysteries)',\n",
" 'A Mystery of Venice: Farewell to the Flesh',\n",
" 'A Necessary Bride',\n",
" 'A Necessary Evil, A',\n",
" 'A Necessary Marriage (Rainbow Romance)',\n",
" 'A New Beginning/Daily Devotions for Women Survivors of Sexual Abuse (The Serenity Meditation Series)',\n",
" 'A New Hope (Star Wars (Econo-Clad Hardcover))',\n",
" 'A New Ireland: Politics, Peace, and Reconciliation',\n",
" 'A Painted House',\n",
" 'A Parchment of Leaves: A Novel',\n",
" 'A Passion for Golf: The Best of Golf Writing',\n",
" 'A Patchwork Planet',\n",
" 'A Patchwork of Blessings &amp; Graces',\n",
" \"A People's History of the United States : 1492-Present (Perennial Classics)\",\n",
" 'A Perfect Crime',\n",
" \"A Perfect Little Piglet (Disney's Out &amp; about with Pooh)\",\n",
" 'A Perfect Stranger',\n",
" 'A Personal Matter',\n",
" \"A Picture's Worth (Cyber.Kdz, No 2)\",\n",
" 'A Pirate Looks At Fifty',\n",
" 'A Pirate Looks at Fifty',\n",
" 'A Place Called Freedom',\n",
" 'A Place for Noah',\n",
" 'A Place of Execution',\n",
" 'A Pocket Full of Rye (Miss Marple Mysteries (Paperback))',\n",
" 'A Pocketful of Karma',\n",
" 'A Portrait of the Artist As a Young Man (Dover Thrift Editions)',\n",
" 'A Poultice for a Healer (Chronicles of Issac of Girona)',\n",
" \"A Practical Guide to the Runes: Their Uses in Divination and Magick (Llewellyn's New Age)\",\n",
" 'A Prayer for Owen Meany',\n",
" \"A Prayer for Owen Meany (Ballantine Reader's Circle)\",\n",
" 'A Prince Among Them (Shadow of Liberty Series #3)',\n",
" 'A Proper Affair (Sonnet Books)',\n",
" 'A Public Faith: A Balanced Approach to Social and Political Action',\n",
" \"A Rambler's Guide to the Trails of the East Bay Hills/Map: Northern Section\",\n",
" 'A Random Walk Down Wall Street: Including a Life-Cycle Guide to Personal Investing',\n",
" 'A Really Cute Corpse (A Claire Malloy Mystery)',\n",
" 'A Regency Christmas IV: Five New Stories (Signet Super Regency)',\n",
" \"A Reporter's Life\",\n",
" 'A Ring of Endless Light (Austin Family)',\n",
" \"A Rose For Her Grave &amp; Other True Cases (Ann Rule's Crime Files)\",\n",
" 'A Royal Murder',\n",
" 'A Royal Murder (Romancing The Crown) (Silhouette Intimate Moments, No. 1172)',\n",
" 'A SONG OF STONE: A Novel',\n",
" 'A Sand County Almanac (Outdoor Essays &amp; Reflections)',\n",
" 'A Scandalous Marriage (Zebra Regency Romance)',\n",
" 'A Scientific Romance : A Novel',\n",
" 'A Season for Goodbye (One Last Wish)',\n",
" 'A Season in the West',\n",
" 'A Season of Mists',\n",
" 'A Secret Affair',\n",
" 'A Secret History : The Book Of Ash, #1 (Book of Ash)',\n",
" 'A Secret Love (Cynster Novels)',\n",
" 'A Separate Peace',\n",
" 'A Series of Unfortunate Events #6: The Ersatz Elevator (A Series of Unfortunate Events)',\n",
" 'A Series of Unfortunate Events: Lemony Snicket : The Unauthorized Autobiography (A Series of Unfortunate Events)',\n",
" 'A Sharpness On The Neck (The Dracula Series)',\n",
" 'A Shocker on Shock Street (Goosebumps, No 35)',\n",
" 'A Short Guide to Writing about Biology (4th Edition)',\n",
" 'A Short Guide to a Happy Life',\n",
" 'A Short History of Nearly Everything',\n",
" 'A Short Walk in the Hindu Kush',\n",
" 'A Signal Shattered',\n",
" 'A Silly Snowy Day',\n",
" 'A Simple Path',\n",
" 'A Simple Plan',\n",
" 'A Single Shard',\n",
" \"A Skeleton In God's Closet\",\n",
" 'A Slipping-Down Life',\n",
" 'A Slow Walk to Hell',\n",
" 'A Small Book of Fairies',\n",
" 'A Small Death in Lisbon',\n",
" 'A Sociable God : Eye to Eye (The Collected Works of Ken Wilber Series)',\n",
" 'A Soft Place to Fall',\n",
" 'A Soldier of the Great War',\n",
" \"A Soldier's Life in the Civil War (Dover Pictorial Archives)\",\n",
" 'A Solitary Blue (Point)',\n",
" 'A Son of the Circus',\n",
" 'A Song for Uncle Harry',\n",
" 'A Southern Belle Primer: Or Why Princess Margaret Will Never Be a Kappa Kappa Gamma',\n",
" 'A Spell for Chameleon (Xanth Novels (Paperback))',\n",
" 'A Spiritual Approach to Male/Female Relations (A Quest Book)',\n",
" 'A Spy in Isengard (Middle-Earth Quest)',\n",
" \"A Starfarer's Dozen: Stories of Things to Come\",\n",
" 'A Steadfast Surrender',\n",
" 'A Step Further',\n",
" 'A Stockingful of Joy',\n",
" 'A Stone Boat',\n",
" 'A Stone, a Leaf, a Door: Poems',\n",
" 'A Stranger in the Family: A True Story of Murder, Madness, and Unconditional Love',\n",
" \"A Stranger's Touch (Midnight Fantasies) (Blaze, 37)\",\n",
" 'A String in the Harp',\n",
" 'A Study Course in Homeopathy',\n",
" 'A Study in Scarlet (Sherlock Holmes)',\n",
" 'A Sudden Change of Heart',\n",
" 'A Summer in the Country',\n",
" 'A Summer to Remember (Get Connected Romances)',\n",
" 'A Summons to Memphis',\n",
" 'A Sunday at the Pool in Kigali',\n",
" \"A Survivor's Guide: Love Etc. (A Survivor's Guide)\",\n",
" 'A Swiftly Tilting Planet',\n",
" 'A Tale of Two Cities',\n",
" 'A Taste for Murder',\n",
" 'A Taste of Fire (Zebra Historical Romance S.)',\n",
" 'A Tempting Engagement (Silhouette Desire, 1571)',\n",
" 'A Test of Wills (Inspector Ian Rutledge Mysteries (Paperback))',\n",
" 'A Theatre of Love (Camfield Novel of Love, No. 100)',\n",
" 'A Theory of Relativity',\n",
" 'A Thief of Time (Joe Leaphorn/Jim Chee Novels)',\n",
" 'A Thin Dark Line',\n",
" 'A Thing (or Two) About Curtis and Camilla',\n",
" 'A Thoroughly Modern Princess',\n",
" \"A Thousand Days in Venice: An Unexpected Romance (Ballantine Reader's Circle)\",\n",
" 'A Time of Exile: A Novel of the Westlands',\n",
" 'A Time on Earth',\n",
" 'A Time to Kill',\n",
" 'A Time-Travel Christmas',\n",
" 'A Token of Friendship: A Collection of Sentiments, Thoughts, Gift Ideas, and Recipes for Special Friends',\n",
" 'A Town Like Alice',\n",
" 'A Treatise on White Magic or The Way of the Disciple',\n",
" 'A Tree Grows in Brooklyn',\n",
" 'A Trial by Jury',\n",
" 'A Tribe Apart: A Journey into the Heart of American Adolescence',\n",
" 'A Tryst in Time',\n",
" 'A Twist Of Fate',\n",
" 'A Twist at The End',\n",
" 'A Valentine for Daisy',\n",
" 'A Veiled Journy',\n",
" 'A Venetian Affair',\n",
" \"A Very Brady Guide to Life: Groovy Solutions to Life's Most Puzzling Dilemmas\",\n",
" 'A Very Young Dancer',\n",
" \"A Vineyard Killing : A Martha's Vineyard Mystery\",\n",
" 'A Virtual Soul (del Rey Discovery)',\n",
" \"A Virtuous Woman (Oprah's Book Club (Paperback))\",\n",
" 'A Vision of Light',\n",
" 'A Volte Ritornano',\n",
" 'A Walk Through the Fire',\n",
" 'A Walk in the Woods: Rediscovering America on the Appalachian Trail',\n",
" 'A Walk in the Woods: Rediscovering America on the Appalachian Trail (Official Guides to the Appalachian Trail)',\n",
" 'A Walk to Remember',\n",
" 'A Walking Tour of the Shambles',\n",
" \"A Warrior's Mission Colorado Confidential (Harlequin Intrigue, No. 741)\",\n",
" 'A Wedding Story',\n",
" 'A White Romance',\n",
" 'A Widow for One Year',\n",
" 'A Wild Justice',\n",
" 'A Wild Justice (Harlequin Historical, No. 617)',\n",
" 'A Wild and Lonely Place (Sharon McCone Mysteries (Paperback))',\n",
" 'A Will and a Way (Silhouette Special Edition #345)',\n",
" 'A Willfull Marriage (Greatest Texas Love Stories of All Time, Heading to the Hitching Post)',\n",
" 'A Wind in the Door',\n",
" 'A Winter Spy',\n",
" \"A Witch's Guide to Faery Folk: Reclaiming Our Working Relationship With Invisible Helpers (Llewellyn's New Age Series)\",\n",
" \"A Witch's Runes: How to Make and Use Your Own Magick Stones\",\n",
" 'A Wizard of Earthsea (Earthsea Trilogy, Book 1)',\n",
" \"A Wolf In Sheep's Clothing\",\n",
" 'A Woman Clothed with the Sun',\n",
" 'A Woman of Independent Means',\n",
" \"A Woman's Agenda 2003: Celebrating Movers and Shakers\",\n",
" \"A Woman's Guide to a Simpler Life\",\n",
" \"A Woman's Worth\",\n",
" \"A Women's Journey Through I Peter (Woman's Journey Through)\",\n",
" 'A Wreath for Rivera',\n",
" 'A Wrinkle In Time',\n",
" 'A Wrinkle in Time',\n",
" 'A Year Down Yonder',\n",
" 'A Year in Provence',\n",
" 'A Year in Van Nuys',\n",
" 'A Yellow Raft in Blue Water: A Novel',\n",
" 'A Zoo for All Seasons: The Smithsonian Animal World',\n",
" 'A first reader of contemporary American poetry',\n",
" \"A journey to the center of the earth (World's best reading)\",\n",
" 'A postillion struck by lightning',\n",
" 'A spell for Chameleon (Magic of Xanth)',\n",
" 'A third treasury of Kahlil Gibran',\n",
" 'A turning wheel: Three decades of the Asian revolution as witnessed by a correspondent for The New Yorker',\n",
" 'ABC Of Anarchism',\n",
" 'ADOLESCENC OF P-1',\n",
" 'ALANNA: THE FIRST ADVENT (Pierce, Tamora. Song of the Lioness, Bk. 1.)',\n",
" 'ALICE WHIPPLE,FIFTH/',\n",
" 'ALL YOU NEED IS LOVE : ...AND 99 OTHER LIFE LESSONS FROM CLASSIC ROCK SONGS',\n",
" 'ALONE AGAINST TOMORROW',\n",
" 'ANCIENT EVIL (CHAIN LETTER 2) : ANCIENT EVIL',\n",
" 'ANGEL BOOK : A HANDBOOK FOR ASPIRING ANGELS',\n",
" \"ANGELA'S ASHES\",\n",
" 'ANIMAL WIFE',\n",
" 'ANNUAL WHOPPER BOOK (ANNUAL WHOOPER BOOK, volume 1)',\n",
" 'ARIZONA AMES',\n",
" 'AT ALL COSTS NANCY DREW HARDY BOYS SUPERMYSTERY',\n",
" 'AT BERTRAMS HOTEL',\n",
" 'AT PARADISE GATE',\n",
" 'AVAILABLE LIGHT',\n",
" 'Abblocken.',\n",
" 'Abc Murders',\n",
" 'Abduction',\n",
" \"Abel's Daughter\",\n",
" 'Abenteuer der Meere. Der Seewolf / Moby Dick / Die Schatzinsel.',\n",
" 'Abhorsen (The Abhorsen Trilogy)',\n",
" 'Abigail Adams: An American Woman (2nd Edition)',\n",
" 'Abode Of Princes (Harlequin Presents)',\n",
" 'About Face',\n",
" 'About Last Night ... (The Wrong Bed) (Harlequin Temptation, No. 751)',\n",
" 'About Teddy Robinson (Young Puffin)',\n",
" 'About a Boy',\n",
" 'About a Boy (Movie Tie-In)',\n",
" 'Above And Beyond (Brown, Sandra)',\n",
" 'Above the Thunder: A Novel',\n",
" 'Absalom, Absalom!',\n",
" 'Absalom, Absalom!: The Corrected Text (Vintage International)',\n",
" \"Absolute Beginner's Guide to Creating Web Pages\",\n",
" 'Absolute Pleasure',\n",
" 'Absolute Power',\n",
" 'Abusing Science: The Case Against Creationism',\n",
" 'Acceptable Loss',\n",
" 'Acceptable Risk',\n",
" 'Access Minneapolis/St. Paul (Serial)',\n",
" 'Accident',\n",
" 'Accidental Heiress (Harlequin Silhouette Intimate Moments, No 840)',\n",
" 'Accidental Tourist',\n",
" 'Ace Ventura: Pet Detective (Pictureback)',\n",
" 'Achthundertachtundachtzig Cocktails, Longdrinks und andere Mixgetr�¤nke f�¼r die Bar zu Hause.',\n",
" 'Acorna: The Unicorn Girl (Acorna (Paperback))',\n",
" 'Acres of Diamonds',\n",
" 'Across Five Aprils',\n",
" 'Across Time (Big Book) (Harlequin Historical, No 203)',\n",
" 'Across Time And Death : The Extraordinary Search For My Past Life Family',\n",
" 'Across the Wide and Lonesome Prairie: The Oregon Trail Diary of Hattie Campbell, 1847 (Dear America)',\n",
" 'Act of Revenge',\n",
" 'Active Server Pages Solutions: An Essential Guide for Dynamic, Interactive Web Site Development',\n",
" 'Acts and Omissions',\n",
" 'Acts of Faith',\n",
" 'Acts of Light: Poems',\n",
" 'Acts of Malice',\n",
" \"Acts of War (Tom Clancy's Op Center (Paperback))\",\n",
" 'Actual Innocence: When Justice Goes Wrong and How to Make It Right',\n",
" 'Adam',\n",
" \"Addicted to War : Why the U.S. Can't Kick Militarism\",\n",
" 'Adlai Stevenson of Illinois: The Life of Adlai E. Stevenson',\n",
" 'Admissions',\n",
" 'Adorable Crochet for Babies and Toddlers: 22 Projects to Make for Babies from Birth to Two Years',\n",
" 'Adrian Mole: The Cappuccino Years',\n",
" 'Advanced Electronic Communication Systems',\n",
" 'Advanced French for Exceptional Cats',\n",
" 'Adventures of Huckleberry Finn (Dover Thrift Editions)',\n",
" 'Adventures of Sherlock Holmes (Wordsworth Collection)',\n",
" 'Adventures of Tom Sawyer (Signet Classic Series)',\n",
" 'Adventures of Tom Thumb',\n",
" 'Adversary',\n",
" 'Advertising and Society',\n",
" \"Aesop's Fables (Wordsworth Collection)\",\n",
" 'Affaire Royale (Silhouette Intimate Moments)',\n",
" 'Affirmations from the Heart of God',\n",
" 'Affliction',\n",
" 'Affluenza: The All-Consuming Epidemic',\n",
" 'Afluentes de la memoria 1996 (Fenice poesÃ\\xada)',\n",
" \"Africans in America: AMERICAN (AMERI)ca's Journey through Slavery\",\n",
" 'After All These Years',\n",
" 'After Anne (Henke, Roxanne, Coming Home to Brewster, 1.)',\n",
" 'After The Ball (Harlequin Romance)',\n",
" 'After Things Fell Apart',\n",
" \"After You'd Gone\",\n",
" 'After the Banquet',\n",
" 'After the Fire',\n",
" 'After the First Death (Laurel Leaf Books)',\n",
" 'After the Garden',\n",
" 'After the Plague (Contents)',\n",
" 'After the Reunion',\n",
" 'Aftershocks',\n",
" 'Aftershocks (Colonization, Book 3)',\n",
" 'Afueras de Dios, Las',\n",
" 'Against War with Iraq: An Anti-War Primer',\n",
" 'Against the Brotherhood: A Mycroft Holmes Novel (Mycroft Holmes Novels (Paperback))',\n",
" 'Against the Odds (Serenity House)',\n",
" 'Agatha Raisin and the Fairies of Fryfam (An Agatha Raisin Mystery)',\n",
" 'Agatha Raisin and the Murderous Marriage (An Agatha Raisin Mystery)',\n",
" 'Agatha Raisin and the Wizard of Evesham (An Agatha Raisin Mystery)',\n",
" 'Age Erasers for Women: Actions You Can Take Right Now to Look Younger and Feel Great',\n",
" 'Age Protectors: Your Guide to Perpetual Youth',\n",
" 'Age of Innocence (Wordsworth Classics)',\n",
" 'Agnes Browne',\n",
" \"Ahab's Wife: Or, The Star-Gazer: A Novel\",\n",
" 'Airframe',\n",
" 'Airport',\n",
" 'Akiko and the Alpha Centauri 5000 (Akiko)',\n",
" 'Aladdin',\n",
" 'Aladdin and Other Stories (Great Little Stories)',\n",
" 'Aladdin: Master of the Lamp',\n",
" 'Alaskan Nights',\n",
" 'Alateen: A Day at a Time',\n",
" 'Albert Angelo',\n",
" 'Aldo Applesauce',\n",
" 'Aldo Ice Cream',\n",
" 'Alexander And The Terrible, Horrible, No Good, Very Bad Day',\n",
" 'Alfred Hitchcock and the Making of Psycho',\n",
" 'Algebra and Trigonometry',\n",
" 'Algunos Muchachos (Colección Destinolibro ; v. 165)',\n",
" 'Ali Baba and the Forty Thieves',\n",
" 'Ali and Nino: A Love Story',\n",
" 'Alias Grace : A Novel',\n",
" 'Alias Smith and Jones (The Tremaine Tradition)',\n",
" 'Alice Walker: Color Purple/Meridian/the Third Life of Grange Copeland',\n",
" 'Alice at Heart (Waterlilies Series)',\n",
" 'Alice in La-LA Land',\n",
" 'Alice in La-La Land',\n",
" 'Alice in Wonderland',\n",
" 'Alice in Wonderland (Fairy Tale Classics Storybook)',\n",
" 'Alice in Wonderland (Wordsworth Collection)',\n",
" 'Alice in Wonderland and Through the Looking Glass (Illustrated Junior Library)',\n",
" \"Alice's Adventures in Wonderland (Penguin Popular Classics)\",\n",
" \"Alice's Adventures in Wonderland (Puffin Classics)\",\n",
" \"Alice's Adventures in Wonderland ; And, Through the Looking-Glass and What Alice Found There (The World's Classics)\",\n",
" 'Alien Contacts and Abductions: The Real Story from the Other Side',\n",
" \"Alistair MacLean's Rendezvous. Roman\",\n",
" 'Alive : The Story of the Andes Survivors (Avon Nonfiction)',\n",
" 'All About Houseplants',\n",
" 'All About Seeds (Do-It-Yourself Science)',\n",
" 'All Around the Town',\n",
" 'All Fall Down (Mira)',\n",
" 'All He Ever Wanted: A Novel',\n",
" 'All I Desire',\n",
" \"All I Know About Animal Behavior I Learned in Loehmann's Dressing Room\",\n",
" 'All I Know About Animal Behaviori Learned in Loehmans Dressing Room',\n",
" 'All I Need Is You',\n",
" 'All I Need to Know I Learned from My Cat',\n",
" 'All I Really Need to Know',\n",
" 'All I Really Need to Know I Learned in Kindergarten: Uncommon Thoughts on Common Things',\n",
" 'All In The Family (Silhouette Intimate Moments, No 205)',\n",
" \"All Kinds of Minds: A Young Student's Book About Learning Abilities and Learning Disorders\",\n",
" 'All Men Are Brothers / Shui Hu Chuan',\n",
" 'All Mimes Must Die: The Best of We Recommend',\n",
" 'All New People: A Novel',\n",
" 'All Politics Is Local and Other Rules of the Game',\n",
" 'All Quiet on the Western Front',\n",
" 'All Rivers Run to the Sea: Memoirs',\n",
" 'All Smiles',\n",
" 'All Summer Long: A Novel',\n",
" 'All That Glitters',\n",
" 'All That Glitters (Landry)',\n",
" 'All That Remains (Kay Scarpetta Mysteries (Paperback))',\n",
" 'All The Possibilitie (Silhouette Special Edition, No 247)',\n",
" 'All Things Are Possible-Pass the Word',\n",
" 'All Through The Night : A Suspense Story',\n",
" 'All Through the Night (Holiday Classics)',\n",
" \"All Tomorrow's Parties\",\n",
" 'All Too Human : A Political Education',\n",
" 'All Year Round With Little Frog (Squeeze-and Squeak Books)',\n",
" 'All about lawns',\n",
" 'All of Me: A Voluptuous Tale',\n",
" 'All over Creation',\n",
" \"All over but the Shoutin'\",\n",
" 'All the Bells on Earth',\n",
" 'All the Names',\n",
" 'All the Pretty Horses (The Border Trilogy, Vol 1)',\n",
" 'All the Seas of the World',\n",
" 'All the Sweet Tomorrows',\n",
" 'All the Trouble in the World: The Lighter Side of Overpopulation, Famine, Ecological Disaster, Ethnic Hatred, Plague, and Poverty',\n",
" 'All the Weyrs of Pern (Dragonriders of Pern (Paperback))',\n",
" 'All too Human',\n",
" 'All-American Girl',\n",
" 'Allegheny Captive',\n",
" 'Almanac of the Dead: A Novel',\n",
" 'Almost A Family (Almost, Texas) (Harlequin Intimate Moments, No 815)',\n",
" 'Almost Adam',\n",
" 'Almost Innocent',\n",
" 'Almost Innocent: A Novel (Voices of the South)',\n",
" 'Almost Paradise',\n",
" 'Almost a Woman',\n",
" 'Almost blue (Stile libero)',\n",
" 'Almost: A Novel',\n",
" 'Alone Against the Atlantic',\n",
" 'Alone in Community: Journeys into Monastic Life Around the World',\n",
" 'Alone in the Crowd (Sweet Valley High, No 28)',\n",
" 'Along Came Trouble',\n",
" 'Along Came a Spider (Alex Cross Novels)',\n",
" 'Along Comes Baby (First Comes Marriage) (Silhouette Romance, No 1116)',\n",
" 'Along the Edge of America',\n",
" 'Along the Garden Path: More Quilters and Their Gardens',\n",
" 'Alpha Teach Yourself American Sign Language in 24 Hours (Alpha Teach Yourself in 24 Hours)',\n",
" 'Alquimista Impaciente el (Coleccion Ancora y Delfin)',\n",
" 'Alternative Medicine',\n",
" 'Alternative Medicine: A Step-By-Step Guide (\\\\in a Nutshell\\\\\" Series)\"',\n",
" 'Alvin Journeyman (Tales of Alvin Maker, Book 4)',\n",
" 'Always',\n",
" 'Always Coming Home',\n",
" 'Always Coming Home (California Fiction)',\n",
" 'Always Coming Home/Paperback Book and Cassette',\n",
" 'Always True to You',\n",
" 'Always a Bride',\n",
" 'Always in My Heart',\n",
" 'Amadoro',\n",
" 'Aman: The Story of a Somali Girl As Told to Virginia Lee Barnes and Janice Boddy',\n",
" 'Amanda Rose',\n",
" \"Amazing Gracie: A Dog's Tale\",\n",
" 'Amazing Pranks and Blunders',\n",
" 'Ambassador of the Dead',\n",
" 'Ambush at Corellia (Star Wars: The Corellian Trilogy, Book 1)',\n",
" 'Ambushed (The Men Of Whiskey River) (Harlequin Temptation, No 613)',\n",
" \"Amelia Bedelia's Treasury\",\n",
" 'Amelia Earhart: The Final Story',\n",
" 'America on Six Rubles a Day or How to Become a Capitalist Pig',\n",
" \"America's Dumbest Criminals : Wild and Weird Stories of Fumbling Felons, Clumsy Crooks, and Ridiculous Robbers\",\n",
" \"America's Fascinating Indian Heritage\",\n",
" \"America's National Historic Trails\",\n",
" 'American Baroness',\n",
" 'American Dynasty: Aristocracy, Fortune, and the Politics of Deceit in the House of Bush',\n",
" 'American Gods',\n",
" 'American Gods: A Novel',\n",
" 'American Heroes: Riley',\n",
" 'American Indian Myths and Legends (Pantheon Fairy Tale and Folklore Library)',\n",
" 'American Map Road Atlas 2003 United States: Large Scale, Large Type AUTHOR: American Map Corporation',\n",
" 'American Pie',\n",
" 'American Psycho (Vintage Contemporaries)',\n",
" 'American Rhapsody',\n",
" 'American Short Story Masterpieces',\n",
" 'American Star',\n",
" 'Americana Annual, 1983',\n",
" \"Amerigo : R�©cit d'une erreur historique\",\n",
" 'Amityville Horror 2',\n",
" 'Amok Journal Sensurround Edition',\n",
" 'Among men and beasts',\n",
" 'Among the Hidden',\n",
" 'Among the Thugs',\n",
" 'Amphigorey Also',\n",
" 'Amrita',\n",
" 'Amsterdam : A Novel',\n",
" 'Amy (Sisters) (Harlequin Super Romances, No 734)',\n",
" 'Amy Girl',\n",
" 'Amy Grant: A Biography',\n",
" \"Amy's True Love (Sweet Valley High, No 75)\",\n",
" 'An Accidental Goddess',\n",
" 'An Accidental Mom (Love Inspired)',\n",
" 'An Accidental Woman',\n",
" 'An African Prayer Book',\n",
" 'An Aleut bibliography (ISEGR report series ; no. 44)',\n",
" 'An Alien Affair (Mission Earth)',\n",
" 'An American Dream (Vintage International (Paperback))',\n",
" 'An American Story',\n",
" 'An Artist Of The Floating World',\n",
" 'An Artist of the Floating World (Vintage International)',\n",
" 'An Easy Thing (Penguin Crime Mystery)',\n",
" 'An Echo in the Darkness (Mark of the Lion #2)',\n",
" 'An Echo of Heaven',\n",
" 'An Imaginary Life: A Novel',\n",
" 'An Imperfect Spy (Kate Fansler Novels (Hardcover))',\n",
" 'An Indecent Obsession',\n",
" 'An Innocent Deceit (Historical Romance: Regency)',\n",
" 'An Innocent Millionaire (Phoenix Fiction Series)',\n",
" 'An Instance of the Fingerpost',\n",
" 'An Introduction to Drawing (The Dk Art School)',\n",
" 'An Introduction to Political Philosophy (Culture of Jewish Modernity)',\n",
" 'An Island Called California: An Ecological Introduction to Its Natural Communities',\n",
" 'An OCEAN IN IOWA: A NOVEL',\n",
" 'An Owl Too Many (Peter Shandy Mysteries)',\n",
" 'An Uncertain Death',\n",
" 'An Unquiet Mind',\n",
" 'An Unwilling Bride',\n",
" 'An incidental memoir',\n",
" 'An irreverent and thoroughly incomplete social history of almost everything',\n",
" 'Anachronisms',\n",
" 'Anackire',\n",
" 'Anastasia (A Golden Look Look Book)',\n",
" 'Anatomy of the Spirit: The Seven Stages of Power and Healing',\n",
" 'Ancestral Vices',\n",
" 'Ancient Evenings',\n",
" 'Ancients of Days : The Second Book of Confluence (Confluence Trilogy (Paperback))',\n",
" 'And Baby Makes Six (9 Months Later) (Superrromance, 920)',\n",
" 'And I Alone Survived',\n",
" 'And Ladies of the Club',\n",
" 'And More by Andy Rooney',\n",
" 'And Never Let Her Go : Thomas Capano: The Deadly Seducer',\n",
" 'And Then There Were None : A Novel',\n",
" 'And Then You Die',\n",
" 'And There Was Light: Autobiography of Jacques Lusseyran, Blind Hero of the French Resistance',\n",
" 'And the Devil Will Drag You Under',\n",
" 'And the Sea Will Tell',\n",
" \"Andersen's Fairy Tales\",\n",
" 'Andre Gide: A Life in the Present',\n",
" 'André Simon: Gourmet and wine lover',\n",
" 'Angel Falls',\n",
" 'Angel Fire East (The Word and the Void Trilogy, Book 3)',\n",
" 'Angel Light: An Old-Fashioned Love Story',\n",
" 'Angel Love',\n",
" 'Angel Pavement',\n",
" 'Angel Rock (Vintage Contemporaries)',\n",
" 'Angel Rogue (Fallen Angels)',\n",
" 'Angel Visions: True Stories of People Who Have Seen Angels, and How You Can See Angels, Too!',\n",
" 'Angel Wisdom : 365 Meditations and Insights from the Heavens',\n",
" 'Angel in Scarlet',\n",
" 'Angel: City of (Angel)',\n",
" \"Angela Lansbury's Positive Moves\",\n",
" \"Angela's Ashes (MMP) : A Memoir\",\n",
" \"Angela's Ashes: A Memoir\",\n",
" 'Angelas Ashes: A Memoir',\n",
" 'Angelhead : A Memoir',\n",
" 'Angels',\n",
" 'Angels &amp; Aliens: A Journey West',\n",
" 'Angels &amp; Demons',\n",
" 'Angels Among Us',\n",
" 'Angels Crest : A Novel',\n",
" 'Angels Everywhere: A Season of Angels/Touched by Angels (Avon Romance)',\n",
" 'Angels and Demons',\n",
" 'Angels in Heaven',\n",
" 'Angels of September',\n",
" 'Anger: Wisdom for Cooling the Flames',\n",
" 'Angle of Repose (Contemporary American Fiction)',\n",
" \"Angry Housewives Eating Bon Bons (Ballantine Reader's Circle)\",\n",
" \"Angus'S Lost Lady (Families Are Forever) (Intimate Moments , No 853)\",\n",
" 'Angus, Thongs and Full-Frontal Snogging: Confessions of Georgia Nicolson',\n",
" \"Anil's Ghost (Vintage International)\",\n",
" 'Animal Crackers',\n",
" 'Animal Dreams',\n",
" 'Animal Farm',\n",
" 'Animal Farm: A Fairy Story',\n",
" 'Animal Go-Round',\n",
" 'Animal Homes (First Discovery Look-It-Up Board Books)',\n",
" 'Animal-Speak: The Spiritual &amp; Magical Powers of Creatures Great &amp; Small',\n",
" 'Animales En General',\n",
" 'Animalia (Picture Puffins)',\n",
" 'Animalia Midi',\n",
" 'Animist',\n",
" 'Anleitung zum Unschuldigsein. Das �bungsbuch für ein schlechtes Gewissen.',\n",
" 'Anna Pavlova: A Legend Among Dancers',\n",
" 'Annapolis',\n",
" \"Anne Frank's Tales from the Secret Annex\",\n",
" 'Anne Frank: The Diary of a Young Girl',\n",
" 'Anne of Avonlea (Anne of Green Gables Novels (Paperback))',\n",
" 'Anne of Avonlea (Skylark Yearling ed)',\n",
" 'Anne of Avonlea: An Anne of Green Gables Story (Illustrated Junior Library Edition)',\n",
" 'Anne of Green Gables (Anne of Green Gables Novels (Paperback))',\n",
" 'Anne of Ingleside (Anne of Green Gables Novels (Paperback))',\n",
" 'Annie John',\n",
" \"Annie's Song\",\n",
" 'Anniversary Songs',\n",
" 'Anonymity: The Secret Life of an American Family',\n",
" 'Another City, Not My Own: A Novel in the Form of a Memoir',\n",
" 'Another Homecoming',\n",
" \"Another Man'S Child (9 Months Later) (Harlequin Super Romance, No 729)\",\n",
" 'Another Round at the Spaceport Bar',\n",
" 'Another Time Another Place : U2 - the Early Years',\n",
" 'Ansel Adams (American Photography Series)',\n",
" 'Ansichten Eines Clowns',\n",
" 'Answered Prayers',\n",
" 'Antimatter (Star Trek Deep Space Nine, No 8)',\n",
" 'Antologia Del Grupo Poetico Del 1927',\n",
" 'Antony and Cleopatra (Folger Shakespeare Library)',\n",
" 'Ants on the Melon: A Collection of Poems',\n",
" 'Any Advice? (Alloy Books)',\n",
" 'Anything But an Autobiography',\n",
" 'Anything You Say Can and Will Be Used Against You : Stories',\n",
" 'Apache Bride',\n",
" 'Apache Summer',\n",
" \"Aphrodite's Passion (Aphrodite)\",\n",
" 'Apollo 13 : Lost Moon',\n",
" 'Apollyon: The Destroyer Is Unleashed (Left Behind No. 5)',\n",
" 'Appearance Of Evil',\n",
" 'Applied Mathematics',\n",
" \"April Fool's Day: A Modern Love Story\",\n",
" 'Apron Full of Gold: The Letters of Mary Jane Megquier from San Francisco 1849-1856',\n",
" 'Apt Pupil : A Novella in Different Seasons',\n",
" 'Aquamarine',\n",
" 'Arabian Nights (Hallmark Entertainment Books)',\n",
" 'Aransas',\n",
" 'Archangel',\n",
" 'Archangel (Samaria Trilogy, Book 1)',\n",
" 'Arco 10 Minute Guide to Applying to Grad School (10 Minute Guides)',\n",
" 'Are You Experienced?',\n",
" \"Are You Paid What You're Worth?: The Complete Guide to Calculating and Negotiating the Salary, Benefits, Bonus and Raise You Deserve\",\n",
" 'Are You Somebody? : The Accidental Memoir of a Dublin Woman',\n",
" 'Are You in the House Alone? (Laurel-Leaf Mystery)',\n",
" 'Area 7',\n",
" 'Arenas del tiempo',\n",
" 'Aria: The Soul Market (Aria)',\n",
" 'Arizona (New Enchantment of America State Books)',\n",
" 'Arkansas Traveler (Benni Harper Mystery)',\n",
" 'Armchair Economist: Economics And Everyday Experience',\n",
" 'Armed Forces guide to personal financial planning: Strategies for managing your budget, savings, insurance, taxes, and investments',\n",
" 'Armed for Battle: A Balanced Approach to Spiritual Warfare',\n",
" 'Arnes Nachlass: Roman',\n",
" 'Around America: A Tour of Our Magnificent Coastline',\n",
" 'Arresting God in Kathmandu',\n",
" \"Arrow's Fall (The Heralds of Valdemar, Book 3)\",\n",
" 'Art Deco: Flights of Artistic Fancy (Art Movements)',\n",
" 'Artemis Fowl (Artemis Fowl, Book 1)',\n",
" 'Artemis Fowl the Arctic Incident',\n",
" 'Artemis Fowl. Der Geheimcode. Dritter Band der Artemis-Fowl-Trilogie',\n",
" 'Artemis Fowl: The Arctic Incident - Book #2 (Artemis Fowl (Mass Market))',\n",
" \"Arthur's Truck Adventure (Arthur Adventures (Board Books))\",\n",
" 'Artificial Mythologies: A Guide to Cultural Invention',\n",
" 'Artificial Paradises: A Drugs Reader (Penguin Twentieth Century Classics S.)',\n",
" 'Arts &amp; Crafts of Morocco',\n",
" 'As I Lay Dying: The Corrected Text (Vintage International)',\n",
" 'As I have loved you: Activity ideas for children',\n",
" 'As It Is in Heaven',\n",
" 'As Long As Life: Memoirs of a Frontier Woman Doctor',\n",
" 'As My Sparks Fly Upward',\n",
" 'As Nature Made Him: The Boy Who Was Raised As a Girl',\n",
" 'As She Climbed Across the Table (Vintage Contemporaries)',\n",
" 'As You Like It (The New Cambridge Shakespeare)',\n",
" 'As a Driven Leaf',\n",
" 'As for Me and My House (New Canadian Library)',\n",
" 'As the Crow Flies',\n",
" 'Asesinatos en la ciudad real',\n",
" 'Ash Wednesday: A Novel (Vintage Contemporaries (Paperback))',\n",
" 'Ashes in the Wind',\n",
" 'Ashes to Ashes',\n",
" \"Asimov's Chronology of the World\",\n",
" 'Ask Anyone',\n",
" 'Ask for May, Settle for June',\n",
" 'Asking for Trouble: A Novel',\n",
" 'Assassin (Kirk McGarvey Novels (Hardcover))',\n",
" \"Assassin's Quest (The Farseer Trilogy, Book 3)\",\n",
" 'Assassination of Federico Garcia Lorca',\n",
" 'Assassins: Assignment: Jerusalem, Target: Antichrist (Left Behind No. 6)',\n",
" 'Assault at Selonia (Star Wars: The Corellian Trilogy, Book 2)',\n",
" 'Assault of the Super Carrier',\n",
" 'Assignment: Baby (9 To 5) (Romance, 3688)',\n",
" 'Assumed Identity',\n",
" 'Asterix Mundart Geb, Bd.15, Zoff im Pott',\n",
" 'Asterix and the Great Divide (Asterix (Orion Paperback))',\n",
" 'Asterix and the Magic Carpet (Asterix Comic)',\n",
" 'Asterix und Latraviata. (Bd. 31)',\n",
" 'Asterix. Die ganze Wahrheit.',\n",
" 'Astrology for Lovers',\n",
" \"Astérix chez les Bretons (Une Aventure d'Astérix)\",\n",
" 'Asya: A Novel',\n",
" 'Asylum (Blackstone Chronicles, No 6)',\n",
" 'At Home in Mitford (The Mitford Years)',\n",
" \"At Large : The Strange Case of the World's Biggest Internet Invasion\",\n",
" 'At Large: A Josephine Fuller Mystery',\n",
" 'At Last There is Nothing Left to Say',\n",
" 'At The Corner Of Love And Heartache',\n",
" 'At the Altar of Speed: The Fast Life and Tragic Death of Dale Earnhardt',\n",
" 'At the Corner of Mundane and Grace: Finding Glimpses of Glory in Ordinary Days',\n",
" 'At the Manger: The Stories of Those Who Were There',\n",
" 'Atlanta Graves (Sunny Childs Mysteries)',\n",
" 'Atlantis Found',\n",
" 'Atlantis Found (Dirk Pitt Adventures (Hardcover))',\n",
" 'Atlas of the Human Heart: A Memoir',\n",
" 'Atonement : A Novel',\n",
" 'Atroz Encanto de Ser Argentinos',\n",
" 'Atrévete a ser tú',\n",
" 'Au lit !',\n",
" 'Audition For Murder (Morgan Taylor Mysteries)',\n",
" 'Audrey Hepburns Neck',\n",
" 'August Derleth: A Bibliography (Scarecrow Author Bibliographies)',\n",
" 'Aunt Dimity Beats the Devil (Penguin Mysteries (Paperback))',\n",
" \"Aunt Erma's Cope Book\",\n",
" 'Aunt Margarets Lover',\n",
" 'Auntie Mame: An Irreverent Escapade',\n",
" 'Auntie Mayhem (Bed-And-Breakfast Mysteries (Paperback))',\n",
" 'Aunties: Our Older, Cooler, Wiser Friends',\n",
" 'Aurora',\n",
" 'Australia: Four Inspirational Love Stories from the Land Down Under (Inspirational Romance Collections)',\n",
" 'Australian Poverty: Then and Now',\n",
" 'Autobiography of a Fat Bride : True Tales of a Pretend Adulthood',\n",
" 'Autumn Maze (G. K. Hall Mystery)',\n",
" 'Aux fruits de la passion: Roman',\n",
" 'Ava',\n",
" \"Avant-Guide Prague 2 Ed: Insiders' Guide for Cosmopolitan Travelers\",\n",
" 'Avenger (Forsyth, Frederick)',\n",
" 'Avon Books Presents: Haunting Love Stories',\n",
" 'Awakening',\n",
" 'Away',\n",
" 'Ax: An 87th Precinct Mystery',\n",
" 'Axis Of Conflict The Terror File',\n",
" 'Azrael.',\n",
" 'Azure Bonds (Forgotten Realms Novel)',\n",
" 'B Is for Burglar (Kinsey Millhone Mysteries (Audio))',\n",
" 'B Is for Burglar (Kinsey Millhone Mysteries (Paperback))',\n",
" 'B-17 Fortress at War',\n",
" 'B-E-S-T Friends (New Kids at the Polk Street School)',\n",
" 'BACK TO THE TIME TRAP',\n",
" 'BACKWARD GLANCE (Scribner Library of Contemporary Classics)',\n",
" 'BAG OF BONES : A NOVEL',\n",
" 'BELOVED ENEMY: THE PASSIONS OF ELEANOR OF AQUITAINE, A NOVEL',\n",
" 'BLESS THE BEASTS AND CHILDREN',\n",
" 'BLOOD FEVER',\n",
" 'BLOODSTREAM',\n",
" 'BLUE WORLD : BLUE WORLD',\n",
" 'BOWIE',\n",
" 'BOX GARDEN OPEN MARKET ED PB',\n",
" \"BOYD'S CURIOSITY SHOP\",\n",
" 'BRIEF VIEW IN GLOBAL STUDIES',\n",
" 'BROKEN DATE : BROKEN DATE',\n",
" \"BUDGIE AT BENDICK'S POINT\",\n",
" 'BUM STEER',\n",
" 'BUSHIDO CODE (MUSASHI 4) (Musashi Book IV)',\n",
" 'BUSHMAN WHO CAME BACK (Inspector Napoleon Mystery)',\n",
" 'BY PRICKING THUMB',\n",
" \"Babar's Little Circus Star (Step into Reading Series Step 1: Preschool - Grade 1)\",\n",
" 'Babies &amp; Bachelors USA: Indiana',\n",
" 'Babies On Board (That Special Woman!) (Silhouette Special Editon, No 913)',\n",
" 'Baby Be-Bop (Weetzie Bat)',\n",
" \"Baby Bop's Toys\",\n",
" 'Baby Business (9 Months Later) (Harlequin Superromance, 955)',\n",
" 'Baby Christmas (Harlequin American Romance, No 854)',\n",
" 'Baby Contract (9 Months Later) (Harlequin Superromance, No 690)',\n",
" 'Baby Cougar (Look Look)',\n",
" 'Baby Discovery (Bachelor Dads) (Harlequin Romance)',\n",
" 'Baby Doll Games (Sigrid Harald Mystery)',\n",
" 'Baby Eats!: Homemade Recipes for Healthy, Happy Babies',\n",
" 'Baby Einstein: Language Nursery (Baby Einstein Books)',\n",
" 'Baby Hunger: The New Battle for Motherhood',\n",
" 'Baby In The Back Seat (American Baby) (Harlequin American Romance, No. 897)',\n",
" 'Baby Lamb (Look Look Nature Book Series)',\n",
" 'Baby on the Car Roof and 222 Other Urban Legends: Absolutely True Stories That Happened to a Friend of a Friend of a Friend',\n",
" ...]"
]
},
"execution_count": 16,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"list(pivot_table.columns) #list of all the movies present in our sampled dataset"
]
},
{
"cell_type": "code",
"execution_count": 17,
"metadata": {},
"outputs": [],
"source": [
"book_read = pivot_table['Clara Callan']"
]
},
{
"cell_type": "code",
"execution_count": 18,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"<class 'pandas.core.series.Series'>\n",
"Index: 6787 entries, 243 to 278789\n",
"Series name: Clara Callan\n",
"Non-Null Count Dtype \n",
"-------------- ----- \n",
"1 non-null float64\n",
"dtypes: float64(1)\n",
"memory usage: 106.0 KB\n"
]
}
],
"source": [
"book_read.info()"
]
},
{
"cell_type": "code",
"execution_count": 19,
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"/home/arjunrao/.local/lib/python3.10/site-packages/numpy/lib/function_base.py:2889: RuntimeWarning: Degrees of freedom <= 0 for slice\n",
" c = cov(x, y, rowvar, dtype=dtype)\n",
"/home/arjunrao/.local/lib/python3.10/site-packages/numpy/lib/function_base.py:2748: RuntimeWarning: divide by zero encountered in divide\n",
" c *= np.true_divide(1, fact)\n",
"/home/arjunrao/.local/lib/python3.10/site-packages/numpy/lib/function_base.py:2748: RuntimeWarning: invalid value encountered in multiply\n",
" c *= np.true_divide(1, fact)\n"
]
}
],
"source": [
"similarity_with_other_books = pivot_table.corrwith(book_read) #fiding correlation of clara callan with other books"
]
},
{
"cell_type": "code",
"execution_count": 20,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"Book-Title\n",
" Deceived NaN\n",
" Murder of a Sleeping Beauty (Scumble River Mysteries (Paperback)) NaN\n",
"'Salem's Lot NaN\n",
"'The Moon by Whale Light: And Other Adventures Among Bats, Penguins, Crocodilians, and Whales NaN\n",
"'Til Death Do Us Part NaN\n",
"dtype: float64"
]
},
"execution_count": 20,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"similarity_with_other_books.sort_values(ascending=False).head() #getting pnly the top entreis"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Performing SVD"
]
},
{
"cell_type": "code",
"execution_count": 21,
"metadata": {},
"outputs": [],
"source": [
"from surprise import Reader, Dataset, SVD\n",
"from surprise.model_selection import cross_validate\n"
]
},
{
"cell_type": "code",
"execution_count": 25,
"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>index</th>\n",
" <th>ISBN</th>\n",
" <th>Book-Title</th>\n",
" <th>User-ID</th>\n",
" <th>Book-Rating</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>683535</td>\n",
" <td>0140186417</td>\n",
" <td>In Dubious Battle (20th Century Classics)</td>\n",
" <td>141450</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>877401</td>\n",
" <td>0835605833</td>\n",
" <td>A Spiritual Approach to Male/Female Relations ...</td>\n",
" <td>230522</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>60796</td>\n",
" <td>0553258001</td>\n",
" <td>The Cider House Rules</td>\n",
" <td>98741</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>659619</td>\n",
" <td>0061053120</td>\n",
" <td>Love in Vein: Twenty Original Tales of Vampiri...</td>\n",
" <td>150124</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>493146</td>\n",
" <td>0373483589</td>\n",
" <td>Mother'S Gift (Silhouette Promo)</td>\n",
" <td>190807</td>\n",
" <td>0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" index ISBN Book-Title \\\n",
"0 683535 0140186417 In Dubious Battle (20th Century Classics) \n",
"1 877401 0835605833 A Spiritual Approach to Male/Female Relations ... \n",
"2 60796 0553258001 The Cider House Rules \n",
"3 659619 0061053120 Love in Vein: Twenty Original Tales of Vampiri... \n",
"4 493146 0373483589 Mother'S Gift (Silhouette Promo) \n",
"\n",
" User-ID Book-Rating \n",
"0 141450 0 \n",
"1 230522 0 \n",
"2 98741 0 \n",
"3 150124 0 \n",
"4 190807 0 "
]
},
"execution_count": 25,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df = df.reset_index()"
]
},
{
"cell_type": "code",
"execution_count": 27,
"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>User-ID</th>\n",
" <th>Book-Rating</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>0140186417</td>\n",
" <td>In Dubious Battle (20th Century Classics)</td>\n",
" <td>141450</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>0835605833</td>\n",
" <td>A Spiritual Approach to Male/Female Relations ...</td>\n",
" <td>230522</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>0553258001</td>\n",
" <td>The Cider House Rules</td>\n",
" <td>98741</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>0061053120</td>\n",
" <td>Love in Vein: Twenty Original Tales of Vampiri...</td>\n",
" <td>150124</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>0373483589</td>\n",
" <td>Mother'S Gift (Silhouette Promo)</td>\n",
" <td>190807</td>\n",
" <td>0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" ISBN Book-Title User-ID \\\n",
"0 0140186417 In Dubious Battle (20th Century Classics) 141450 \n",
"1 0835605833 A Spiritual Approach to Male/Female Relations ... 230522 \n",
"2 0553258001 The Cider House Rules 98741 \n",
"3 0061053120 Love in Vein: Twenty Original Tales of Vampiri... 150124 \n",
"4 0373483589 Mother'S Gift (Silhouette Promo) 190807 \n",
"\n",
" Book-Rating \n",
"0 0 \n",
"1 0 \n",
"2 0 \n",
"3 0 \n",
"4 0 "
]
},
"execution_count": 27,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df = df.drop('index',axis=1)\n",
"df.head()\n"
]
},
{
"cell_type": "code",
"execution_count": 31,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"<class 'pandas.core.frame.DataFrame'>\n",
"RangeIndex: 15000 entries, 0 to 14999\n",
"Data columns (total 4 columns):\n",
" # Column Non-Null Count Dtype \n",
"--- ------ -------------- ----- \n",
" 0 ISBN 15000 non-null object\n",
" 1 Book-Title 15000 non-null object\n",
" 2 User-ID 15000 non-null int64 \n",
" 3 Book-Rating 15000 non-null int64 \n",
"dtypes: int64(2), object(2)\n",
"memory usage: 468.9+ KB\n"
]
}
],
"source": [
"df.info()"
]
},
{
"cell_type": "code",
"execution_count": 30,
"metadata": {},
"outputs": [],
"source": [
"reader = Reader() #the reader module is used to parse a normal dataset into a suprise dataset object\n",
"data_svd = Dataset.load_from_df(df[['User-ID','ISBN','Book-Rating']],reader) #Dataset is used to load and manipulate datas in suprise dataset"
]
},
{
"cell_type": "code",
"execution_count": 32,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"<surprise.dataset.DatasetAutoFolds at 0x7f4085faf3a0>"
]
},
"execution_count": 32,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data_svd"
]
},
{
"cell_type": "code",
"execution_count": 34,
"metadata": {},
"outputs": [],
"source": [
"svd = SVD() #svd implements the collobrative filtering algorithm on our suprise dataset"
]
},
{
"cell_type": "code",
"execution_count": 35,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Evaluating RMSE, MAE of algorithm SVD on 3 split(s).\n",
"\n",
" Fold 1 Fold 2 Fold 3 Mean Std \n",
"RMSE (testset) 3.6560 3.6782 3.7477 3.6940 0.0390 \n",
"MAE (testset) 3.2673 3.2803 3.3334 3.2937 0.0286 \n",
"Fit time 0.16 0.15 0.16 0.16 0.01 \n",
"Test time 0.02 0.02 0.01 0.02 0.00 \n"
]
},
{
"data": {
"text/plain": [
"{'test_rmse': array([3.6560166 , 3.67824959, 3.74768467]),\n",
" 'test_mae': array([3.26734441, 3.28025425, 3.33343815]),\n",
" 'fit_time': (0.1581125259399414, 0.14933037757873535, 0.1620798110961914),\n",
" 'test_time': (0.015313148498535156,\n",
" 0.016367435455322266,\n",
" 0.014063358306884766)}"
]
},
"execution_count": 35,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"cross_validate(svd, data_svd, measures=['RMSE', 'MAE'], cv=3, verbose=True) #performs svd and validates its accuracy"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### explaining the parameters\n",
"\n",
"#### RMSE (testset): \n",
"This is the Root Mean Squared Error (RMSE) of the SVD algorithm on the test set of each fold in cross-validation. RMSE is a commonly used metric to evaluate the accuracy of a recommendation system. It measures the average squared difference between the predicted and actual ratings. Lower RMSE values indicate better accuracy.\n",
"\n",
"#### MAE (testset): \n",
"This is the Mean Absolute Error (MAE) of the SVD algorithm on the test set of each fold in cross-validation. MAE is another metric used to evaluate the accuracy of a recommendation system. It measures the average absolute difference between the predicted and actual ratings. Lower MAE values indicate better accuracy.\n",
"\n",
"#### Fit time: \n",
"This is the time taken by the SVD algorithm to fit the model to the training data in each fold of cross-validation. It measures the time required for model training.\n",
"\n",
"#### Test time: \n",
"This is the time taken by the SVD algorithm to make predictions on the test data in each fold of cross-validation. It measures the time required for prediction.\n",
"\n"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Prediction"
]
},
{
"cell_type": "code",
"execution_count": 41,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"array([ 0, 8, 5, 9, 10, 6, 7, 3, 1, 4, 2])"
]
},
"execution_count": 41,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df['Book-Rating'].unique()"
]
},
{
"cell_type": "code",
"execution_count": 42,
"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>User-ID</th>\n",
" <th>Book-Rating</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>0425141438</td>\n",
" <td>By a Woman's Hand: A Guide to Mystery Fiction ...</td>\n",
" <td>30735</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>3257211945</td>\n",
" <td>Das Hotel New Hampshire</td>\n",
" <td>34521</td>\n",
" <td>5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>038097519X</td>\n",
" <td>Faint Echoes, Distant Stars: The Science and P...</td>\n",
" <td>98391</td>\n",
" <td>9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>3458344497</td>\n",
" <td>Die Buchhandlung</td>\n",
" <td>88726</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>0684844400</td>\n",
" <td>Into the Twilight, Endlessly Grousing</td>\n",
" <td>206695</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14994</th>\n",
" <td>0061044636</td>\n",
" <td>Mars and Venus on a Date : A Guide to Navigati...</td>\n",
" <td>73923</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14995</th>\n",
" <td>0816734615</td>\n",
" <td>Mel's Diner</td>\n",
" <td>142005</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14996</th>\n",
" <td>0061020060</td>\n",
" <td>Deepsix</td>\n",
" <td>27222</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14997</th>\n",
" <td>0804111359</td>\n",
" <td>Secret History</td>\n",
" <td>255546</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14998</th>\n",
" <td>0486235467</td>\n",
" <td>Movie-Star Portraits of the Forties: 163 Glamo...</td>\n",
" <td>91423</td>\n",
" <td>10</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5562 rows × 4 columns</p>\n",
"</div>"
],
"text/plain": [
" ISBN Book-Title User-ID \\\n",
"5 0425141438 By a Woman's Hand: A Guide to Mystery Fiction ... 30735 \n",
"12 3257211945 Das Hotel New Hampshire 34521 \n",
"14 038097519X Faint Echoes, Distant Stars: The Science and P... 98391 \n",
"15 3458344497 Die Buchhandlung 88726 \n",
"18 0684844400 Into the Twilight, Endlessly Grousing 206695 \n",
"... ... ... ... \n",
"14994 0061044636 Mars and Venus on a Date : A Guide to Navigati... 73923 \n",
"14995 0816734615 Mel's Diner 142005 \n",
"14996 0061020060 Deepsix 27222 \n",
"14997 0804111359 Secret History 255546 \n",
"14998 0486235467 Movie-Star Portraits of the Forties: 163 Glamo... 91423 \n",
"\n",
" Book-Rating \n",
"5 8 \n",
"12 5 \n",
"14 9 \n",
"15 8 \n",
"18 10 \n",
"... ... \n",
"14994 8 \n",
"14995 10 \n",
"14996 8 \n",
"14997 8 \n",
"14998 10 \n",
"\n",
"[5562 rows x 4 columns]"
]
},
"execution_count": 42,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df[(df['Book-Rating'] > 1)]"
]
},
{
"cell_type": "code",
"execution_count": 49,
"metadata": {},
"outputs": [],
"source": [
"dataset_rec = df[(df['User-ID'] ==206695) & (df['Book-Rating'] > 1)] #predicting for user 206695 "
]
},
{
"cell_type": "code",
"execution_count": 52,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"18 0684844400\n",
"4393 0805000321\n",
"14179 0884946673\n",
"Name: ISBN, dtype: object"
]
},
"execution_count": 52,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"dataset_rec['ISBN']"
]
},
{
"cell_type": "code",
"execution_count": 68,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"3.9144246971175747"
]
},
"execution_count": 68,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"svd.predict(206695,18).est"
]
},
{
"cell_type": "code",
"execution_count": 70,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"18 3.067336\n",
"4393 2.725276\n",
"14179 3.086671\n",
"Name: ISBN, dtype: float64"
]
},
"execution_count": 70,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"dataset_rec['ISBN'].apply(lambda x:svd.predict(142005,x).est)"
]
},
{
"cell_type": "code",
"execution_count": 71,
"metadata": {},
"outputs": [],
"source": [
"df_userA_all = pd.DataFrame(df['ISBN'])['ISBN'].apply(lambda x: svd.predict(206695,x).est)"
]
},
{
"cell_type": "code",
"execution_count": 72,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"14004 5.0\n",
"9410 5.0\n",
"13598 5.0\n",
"5042 5.0\n",
"2418 5.0\n",
"4600 5.0\n",
"9325 5.0\n",
"1217 5.0\n",
"1215 5.0\n",
"3990 5.0\n",
"4105 5.0\n",
"4974 5.0\n",
"11602 5.0\n",
"9378 5.0\n",
"4609 5.0\n",
"14179 5.0\n",
"4103 5.0\n",
"4611 5.0\n",
"2494 5.0\n",
"12138 5.0\n",
"Name: ISBN, dtype: float64"
]
},
"execution_count": 72,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df_userA_all.sort_values(ascending=False).head(20) #this is all the prediction for the user 206695."
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.10.12"
},
"orig_nbformat": 4
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment