BookRecs.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "f5e939a9",
   "metadata": {},
   "outputs": [],
   "source": [
    "liked_books = [\"703663\",\"197710\",\"34373\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "9aeb9ed0",
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "#reads the file into our dictionary\n",
    "csv_book_mapping = {}\n",
    "\n",
    "with open(\"book_id_map.csv\", \"r\") as f:\n",
    "    while True:\n",
    "        line = f.readline()\n",
    "        if not line:\n",
    "            break\n",
    "        csv_id, book_id = line.strip().split(\",\")\n",
    "        csv_book_mapping[csv_id] = book_id\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "958de173",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'34684622'"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "csv_book_mapping['0']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "f77b264a",
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "\n",
    "overlap_users = set()\n",
    "#uses a set to make every element unique\n",
    "with open(\"goodreads_interactions.csv\", 'r') as f:\n",
    "    while True:\n",
    "        line = f.readline()\n",
    "        if not line: #prevent infinite loop\n",
    "            break\n",
    "        user_id, csv_id, _, rating, _ = line.split(\",\")\n",
    "        \n",
    "        if user_id in overlap_users: #if we have already added this user as an overlapped user\n",
    "            continue\n",
    "\n",
    "        try: #try to parse the rating as an int\n",
    "            rating = int(rating)\n",
    "        except ValueError:\n",
    "            continue\n",
    "        \n",
    "        book_id = csv_book_mapping[csv_id]\n",
    "        #checks if the user has a similar liked book AND if they gave it above a 4 rating\n",
    "        if book_id in liked_books and rating >= 4: \n",
    "                overlap_users.add(user_id)\n",
    "        #if they did add the user to the set\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "835c6ee1",
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "\n",
    "rec_lines = []\n",
    "#similar to before just runs through the file\n",
    "with open(\"goodreads_interactions.csv\", 'r') as f:\n",
    "    while True:\n",
    "        line = f.readline()\n",
    "        if not line:\n",
    "            break\n",
    "        user_id, csv_id, _, rating, _ = line.split(\",\")\n",
    "        #if the user is in the overlap section add their rated books into the reclines\n",
    "        if user_id in overlap_users:\n",
    "            book_id = csv_book_mapping[csv_id]\n",
    "            rec_lines.append([user_id, book_id, rating])\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9c0e7975",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "842db9fa",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "7d7a5ba0",
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "\n",
    "import pandas as pd\n",
    "#sets up a chart to visualize the current data we have using pandas\n",
    "recs = pd.DataFrame(rec_lines, columns=[\"user_id\", \"book_id\", \"rating\"])\n",
    "recs[\"book_id\"] = recs[\"book_id\"].astype(str)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "aeb1e685",
   "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>book_id</th>\n",
       "      <th>rating</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2867</td>\n",
       "      <td>48855</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2867</td>\n",
       "      <td>6493208</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2867</td>\n",
       "      <td>13214</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2867</td>\n",
       "      <td>36529</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2867</td>\n",
       "      <td>318742</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68224</th>\n",
       "      <td>875425</td>\n",
       "      <td>52036</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68225</th>\n",
       "      <td>875425</td>\n",
       "      <td>231804</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68226</th>\n",
       "      <td>875425</td>\n",
       "      <td>28676</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68227</th>\n",
       "      <td>875425</td>\n",
       "      <td>9915</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68228</th>\n",
       "      <td>875425</td>\n",
       "      <td>7126</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>68229 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      user_id  book_id rating\n",
       "0        2867    48855      4\n",
       "1        2867  6493208      5\n",
       "2        2867    13214      5\n",
       "3        2867    36529      4\n",
       "4        2867   318742      4\n",
       "...       ...      ...    ...\n",
       "68224  875425    52036      4\n",
       "68225  875425   231804      5\n",
       "68226  875425    28676      4\n",
       "68227  875425     9915      0\n",
       "68228  875425     7126      5\n",
       "\n",
       "[68229 rows x 3 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "recs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "c4413ae1",
   "metadata": {},
   "outputs": [],
   "source": [
    "top_recs = recs[\"book_id\"].value_counts().head(10) #top 10 book recs that occured the most frequently\n",
    "top_recs = top_recs.index.values\n",
    "books_titles = pd.read_json(\"books_titles.json\")#read in the json file from before \n",
    "books_titles[\"book_id\"] = books_titles[\"book_id\"].astype(str)#use the values to actually get to a title"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "b37340f2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>book_id</th>\n",
       "      <th>title</th>\n",
       "      <th>ratings</th>\n",
       "      <th>url</th>\n",
       "      <th>cover_image</th>\n",
       "      <th>mod_title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7327624</td>\n",
       "      <td>The Unschooled Wizard (Sun Wolf and Starhawk, ...</td>\n",
       "      <td>140</td>\n",
       "      <td>https://www.goodreads.com/book/show/7327624-th...</td>\n",
       "      <td>https://images.gr-assets.com/books/1304100136m...</td>\n",
       "      <td>the unschooled wizard sun wolf and starhawk 12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>6066819</td>\n",
       "      <td>Best Friends Forever</td>\n",
       "      <td>51184</td>\n",
       "      <td>https://www.goodreads.com/book/show/6066819-be...</td>\n",
       "      <td>https://s.gr-assets.com/assets/nophoto/book/11...</td>\n",
       "      <td>best friends forever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>287141</td>\n",
       "      <td>The Aeneid for Boys and Girls</td>\n",
       "      <td>46</td>\n",
       "      <td>https://www.goodreads.com/book/show/287141.The...</td>\n",
       "      <td>https://s.gr-assets.com/assets/nophoto/book/11...</td>\n",
       "      <td>the aeneid for boys and girls</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>6066812</td>\n",
       "      <td>All's Fairy in Love and War (Avalon: Web of Ma...</td>\n",
       "      <td>98</td>\n",
       "      <td>https://www.goodreads.com/book/show/6066812-al...</td>\n",
       "      <td>https://images.gr-assets.com/books/1316637798m...</td>\n",
       "      <td>alls fairy in love and war avalon web of magic 8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>287149</td>\n",
       "      <td>The Devil's Notebook</td>\n",
       "      <td>986</td>\n",
       "      <td>https://www.goodreads.com/book/show/287149.The...</td>\n",
       "      <td>https://images.gr-assets.com/books/1328768789m...</td>\n",
       "      <td>the devils notebook</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   book_id                                              title  ratings  \\\n",
       "0  7327624  The Unschooled Wizard (Sun Wolf and Starhawk, ...      140   \n",
       "1  6066819                               Best Friends Forever    51184   \n",
       "2   287141                      The Aeneid for Boys and Girls       46   \n",
       "3  6066812  All's Fairy in Love and War (Avalon: Web of Ma...       98   \n",
       "4   287149                               The Devil's Notebook      986   \n",
       "\n",
       "                                                 url  \\\n",
       "0  https://www.goodreads.com/book/show/7327624-th...   \n",
       "1  https://www.goodreads.com/book/show/6066819-be...   \n",
       "2  https://www.goodreads.com/book/show/287141.The...   \n",
       "3  https://www.goodreads.com/book/show/6066812-al...   \n",
       "4  https://www.goodreads.com/book/show/287149.The...   \n",
       "\n",
       "                                         cover_image  \\\n",
       "0  https://images.gr-assets.com/books/1304100136m...   \n",
       "1  https://s.gr-assets.com/assets/nophoto/book/11...   \n",
       "2  https://s.gr-assets.com/assets/nophoto/book/11...   \n",
       "3  https://images.gr-assets.com/books/1316637798m...   \n",
       "4  https://images.gr-assets.com/books/1328768789m...   \n",
       "\n",
       "                                          mod_title  \n",
       "0    the unschooled wizard sun wolf and starhawk 12  \n",
       "1                              best friends forever  \n",
       "2                     the aeneid for boys and girls  \n",
       "3  alls fairy in love and war avalon web of magic 8  \n",
       "4                               the devils notebook  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "books_titles.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "917c8caa",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>book_id</th>\n",
       "      <th>title</th>\n",
       "      <th>ratings</th>\n",
       "      <th>url</th>\n",
       "      <th>cover_image</th>\n",
       "      <th>mod_title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>140511</th>\n",
       "      <td>1885</td>\n",
       "      <td>Pride and Prejudice</td>\n",
       "      <td>2078406</td>\n",
       "      <td>https://www.goodreads.com/book/show/1885.Pride...</td>\n",
       "      <td>https://images.gr-assets.com/books/1320399351m...</td>\n",
       "      <td>pride and prejudice</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>463463</th>\n",
       "      <td>4671</td>\n",
       "      <td>The Great Gatsby</td>\n",
       "      <td>2758812</td>\n",
       "      <td>https://www.goodreads.com/book/show/4671.The_G...</td>\n",
       "      <td>https://images.gr-assets.com/books/1490528560m...</td>\n",
       "      <td>the great gatsby</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>615314</th>\n",
       "      <td>5470</td>\n",
       "      <td>1984</td>\n",
       "      <td>2023937</td>\n",
       "      <td>https://www.goodreads.com/book/show/5470.1984</td>\n",
       "      <td>https://images.gr-assets.com/books/1348990566m...</td>\n",
       "      <td>1984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>770177</th>\n",
       "      <td>7613</td>\n",
       "      <td>Animal Farm</td>\n",
       "      <td>1928931</td>\n",
       "      <td>https://www.goodreads.com/book/show/7613.Anima...</td>\n",
       "      <td>https://images.gr-assets.com/books/1424037542m...</td>\n",
       "      <td>animal farm</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>790927</th>\n",
       "      <td>2657</td>\n",
       "      <td>To Kill a Mockingbird</td>\n",
       "      <td>3255518</td>\n",
       "      <td>https://www.goodreads.com/book/show/2657.To_Ki...</td>\n",
       "      <td>https://images.gr-assets.com/books/1361975680m...</td>\n",
       "      <td>to kill a mockingbird</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>878545</th>\n",
       "      <td>3</td>\n",
       "      <td>Harry Potter and the Sorcerer's Stone (Harry P...</td>\n",
       "      <td>4765497</td>\n",
       "      <td>https://www.goodreads.com/book/show/3.Harry_Po...</td>\n",
       "      <td>https://images.gr-assets.com/books/1474154022m...</td>\n",
       "      <td>harry potter and the sorcerers stone harry pot...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>882752</th>\n",
       "      <td>18135</td>\n",
       "      <td>Romeo and Juliet</td>\n",
       "      <td>1656919</td>\n",
       "      <td>https://www.goodreads.com/book/show/18135.Rome...</td>\n",
       "      <td>https://images.gr-assets.com/books/1503315424m...</td>\n",
       "      <td>romeo and juliet</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>960610</th>\n",
       "      <td>34373</td>\n",
       "      <td>Dante's Inferno (the Divine Comedy, Volume 1, ...</td>\n",
       "      <td>1106</td>\n",
       "      <td>https://www.goodreads.com/book/show/34373.Dant...</td>\n",
       "      <td>https://s.gr-assets.com/assets/nophoto/book/11...</td>\n",
       "      <td>dantes inferno the divine comedy volume 1 hell</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995137</th>\n",
       "      <td>15881</td>\n",
       "      <td>Harry Potter and the Chamber of Secrets (Harry...</td>\n",
       "      <td>1821802</td>\n",
       "      <td>https://www.goodreads.com/book/show/15881.Harr...</td>\n",
       "      <td>https://images.gr-assets.com/books/1474169725m...</td>\n",
       "      <td>harry potter and the chamber of secrets harry ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1248586</th>\n",
       "      <td>6</td>\n",
       "      <td>Harry Potter and the Goblet of Fire (Harry Pot...</td>\n",
       "      <td>1792561</td>\n",
       "      <td>https://www.goodreads.com/book/show/6.Harry_Po...</td>\n",
       "      <td>https://images.gr-assets.com/books/1361482611m...</td>\n",
       "      <td>harry potter and the goblet of fire harry pott...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        book_id                                              title  ratings  \\\n",
       "140511     1885                                Pride and Prejudice  2078406   \n",
       "463463     4671                                   The Great Gatsby  2758812   \n",
       "615314     5470                                               1984  2023937   \n",
       "770177     7613                                        Animal Farm  1928931   \n",
       "790927     2657                              To Kill a Mockingbird  3255518   \n",
       "878545        3  Harry Potter and the Sorcerer's Stone (Harry P...  4765497   \n",
       "882752    18135                                   Romeo and Juliet  1656919   \n",
       "960610    34373  Dante's Inferno (the Divine Comedy, Volume 1, ...     1106   \n",
       "995137    15881  Harry Potter and the Chamber of Secrets (Harry...  1821802   \n",
       "1248586       6  Harry Potter and the Goblet of Fire (Harry Pot...  1792561   \n",
       "\n",
       "                                                       url  \\\n",
       "140511   https://www.goodreads.com/book/show/1885.Pride...   \n",
       "463463   https://www.goodreads.com/book/show/4671.The_G...   \n",
       "615314       https://www.goodreads.com/book/show/5470.1984   \n",
       "770177   https://www.goodreads.com/book/show/7613.Anima...   \n",
       "790927   https://www.goodreads.com/book/show/2657.To_Ki...   \n",
       "878545   https://www.goodreads.com/book/show/3.Harry_Po...   \n",
       "882752   https://www.goodreads.com/book/show/18135.Rome...   \n",
       "960610   https://www.goodreads.com/book/show/34373.Dant...   \n",
       "995137   https://www.goodreads.com/book/show/15881.Harr...   \n",
       "1248586  https://www.goodreads.com/book/show/6.Harry_Po...   \n",
       "\n",
       "                                               cover_image  \\\n",
       "140511   https://images.gr-assets.com/books/1320399351m...   \n",
       "463463   https://images.gr-assets.com/books/1490528560m...   \n",
       "615314   https://images.gr-assets.com/books/1348990566m...   \n",
       "770177   https://images.gr-assets.com/books/1424037542m...   \n",
       "790927   https://images.gr-assets.com/books/1361975680m...   \n",
       "878545   https://images.gr-assets.com/books/1474154022m...   \n",
       "882752   https://images.gr-assets.com/books/1503315424m...   \n",
       "960610   https://s.gr-assets.com/assets/nophoto/book/11...   \n",
       "995137   https://images.gr-assets.com/books/1474169725m...   \n",
       "1248586  https://images.gr-assets.com/books/1361482611m...   \n",
       "\n",
       "                                                 mod_title  \n",
       "140511                                 pride and prejudice  \n",
       "463463                                    the great gatsby  \n",
       "615314                                                1984  \n",
       "770177                                         animal farm  \n",
       "790927                               to kill a mockingbird  \n",
       "878545   harry potter and the sorcerers stone harry pot...  \n",
       "882752                                    romeo and juliet  \n",
       "960610      dantes inferno the divine comedy volume 1 hell  \n",
       "995137   harry potter and the chamber of secrets harry ...  \n",
       "1248586  harry potter and the goblet of fire harry pott...  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "\n",
    "books_titles[books_titles[\"book_id\"].isin(top_recs)] \n",
    "#reads through the data\n",
    "\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "4739db1b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>book_id</th>\n",
       "      <th>book_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>34373</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2657</td>\n",
       "      <td>62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4671</td>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5470</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  book_id  book_count\n",
       "0   34373          81\n",
       "1    2657          62\n",
       "2    4671          58\n",
       "3       3          55\n",
       "4    5470          55"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#creates a dataset of how many times a book appears in our set\n",
    "all_recs = recs[\"book_id\"].value_counts()\n",
    "#makes the index a seperate column\n",
    "all_recs = all_recs.to_frame().reset_index()\n",
    "all_recs.columns = [\"book_id\", \"book_count\"]\n",
    "all_recs.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "760cec85",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>book_id</th>\n",
       "      <th>book_count</th>\n",
       "      <th>title</th>\n",
       "      <th>ratings</th>\n",
       "      <th>url</th>\n",
       "      <th>cover_image</th>\n",
       "      <th>mod_title</th>\n",
       "      <th>score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>34373</td>\n",
       "      <td>81</td>\n",
       "      <td>Dante's Inferno (the Divine Comedy, Volume 1, ...</td>\n",
       "      <td>1106</td>\n",
       "      <td>https://www.goodreads.com/book/show/34373.Dant...</td>\n",
       "      <td>https://s.gr-assets.com/assets/nophoto/book/11...</td>\n",
       "      <td>dantes inferno the divine comedy volume 1 hell</td>\n",
       "      <td>5.932188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>703663</td>\n",
       "      <td>25</td>\n",
       "      <td>When Bad Things Happen to Good People</td>\n",
       "      <td>218</td>\n",
       "      <td>https://www.goodreads.com/book/show/703663.Whe...</td>\n",
       "      <td>https://s.gr-assets.com/assets/nophoto/book/11...</td>\n",
       "      <td>when bad things happen to good people</td>\n",
       "      <td>2.866972</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7756</th>\n",
       "      <td>18125076</td>\n",
       "      <td>2</td>\n",
       "      <td>A Modern Celt: Seeking the Ancestors</td>\n",
       "      <td>16</td>\n",
       "      <td>https://www.goodreads.com/book/show/18125076-a...</td>\n",
       "      <td>https://images.gr-assets.com/books/1378681247m...</td>\n",
       "      <td>a modern celt seeking the ancestors</td>\n",
       "      <td>0.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7055</th>\n",
       "      <td>2033009</td>\n",
       "      <td>2</td>\n",
       "      <td>Marriage and the Family in the Middle Ages</td>\n",
       "      <td>18</td>\n",
       "      <td>https://www.goodreads.com/book/show/2033009.Ma...</td>\n",
       "      <td>https://images.gr-assets.com/books/1373071385m...</td>\n",
       "      <td>marriage and the family in the middle ages</td>\n",
       "      <td>0.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4413</th>\n",
       "      <td>1354693</td>\n",
       "      <td>2</td>\n",
       "      <td>Edmund Dulac's Fairy Book</td>\n",
       "      <td>18</td>\n",
       "      <td>https://www.goodreads.com/book/show/1354693.Ed...</td>\n",
       "      <td>https://images.gr-assets.com/books/1331061173m...</td>\n",
       "      <td>edmund dulacs fairy book</td>\n",
       "      <td>0.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6244</th>\n",
       "      <td>759991</td>\n",
       "      <td>2</td>\n",
       "      <td>Creation and Fall/Temptation: Two Biblical Stu...</td>\n",
       "      <td>21</td>\n",
       "      <td>https://www.goodreads.com/book/show/759991.Cre...</td>\n",
       "      <td>https://s.gr-assets.com/assets/nophoto/book/11...</td>\n",
       "      <td>creation and falltemptation two biblical studies</td>\n",
       "      <td>0.190476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5316</th>\n",
       "      <td>1322096</td>\n",
       "      <td>2</td>\n",
       "      <td>What Your Fourth Grader Needs to Know : Fundam...</td>\n",
       "      <td>21</td>\n",
       "      <td>https://www.goodreads.com/book/show/1322096.Wh...</td>\n",
       "      <td>https://images.gr-assets.com/books/1320548612m...</td>\n",
       "      <td>what your fourth grader needs to know fundamen...</td>\n",
       "      <td>0.190476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5213</th>\n",
       "      <td>1868914</td>\n",
       "      <td>2</td>\n",
       "      <td>Christmas Gifts, Christmas Voices: A Holiday N...</td>\n",
       "      <td>21</td>\n",
       "      <td>https://www.goodreads.com/book/show/1868914.Ch...</td>\n",
       "      <td>https://s.gr-assets.com/assets/nophoto/book/11...</td>\n",
       "      <td>christmas gifts christmas voices a holiday nov...</td>\n",
       "      <td>0.190476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7849</th>\n",
       "      <td>555520</td>\n",
       "      <td>2</td>\n",
       "      <td>Undercurrents</td>\n",
       "      <td>24</td>\n",
       "      <td>https://www.goodreads.com/book/show/555520.Und...</td>\n",
       "      <td>https://s.gr-assets.com/assets/nophoto/book/11...</td>\n",
       "      <td>undercurrents</td>\n",
       "      <td>0.166667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6324</th>\n",
       "      <td>1475504</td>\n",
       "      <td>2</td>\n",
       "      <td>An Introduction to the Apocrypha</td>\n",
       "      <td>27</td>\n",
       "      <td>https://www.goodreads.com/book/show/1475504.An...</td>\n",
       "      <td>https://s.gr-assets.com/assets/nophoto/book/11...</td>\n",
       "      <td>an introduction to the apocrypha</td>\n",
       "      <td>0.148148</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       book_id  book_count                                              title  \\\n",
       "0        34373          81  Dante's Inferno (the Divine Comedy, Volume 1, ...   \n",
       "69      703663          25              When Bad Things Happen to Good People   \n",
       "7756  18125076           2               A Modern Celt: Seeking the Ancestors   \n",
       "7055   2033009           2         Marriage and the Family in the Middle Ages   \n",
       "4413   1354693           2                          Edmund Dulac's Fairy Book   \n",
       "6244    759991           2  Creation and Fall/Temptation: Two Biblical Stu...   \n",
       "5316   1322096           2  What Your Fourth Grader Needs to Know : Fundam...   \n",
       "5213   1868914           2  Christmas Gifts, Christmas Voices: A Holiday N...   \n",
       "7849    555520           2                                      Undercurrents   \n",
       "6324   1475504           2                   An Introduction to the Apocrypha   \n",
       "\n",
       "      ratings                                                url  \\\n",
       "0        1106  https://www.goodreads.com/book/show/34373.Dant...   \n",
       "69        218  https://www.goodreads.com/book/show/703663.Whe...   \n",
       "7756       16  https://www.goodreads.com/book/show/18125076-a...   \n",
       "7055       18  https://www.goodreads.com/book/show/2033009.Ma...   \n",
       "4413       18  https://www.goodreads.com/book/show/1354693.Ed...   \n",
       "6244       21  https://www.goodreads.com/book/show/759991.Cre...   \n",
       "5316       21  https://www.goodreads.com/book/show/1322096.Wh...   \n",
       "5213       21  https://www.goodreads.com/book/show/1868914.Ch...   \n",
       "7849       24  https://www.goodreads.com/book/show/555520.Und...   \n",
       "6324       27  https://www.goodreads.com/book/show/1475504.An...   \n",
       "\n",
       "                                            cover_image  \\\n",
       "0     https://s.gr-assets.com/assets/nophoto/book/11...   \n",
       "69    https://s.gr-assets.com/assets/nophoto/book/11...   \n",
       "7756  https://images.gr-assets.com/books/1378681247m...   \n",
       "7055  https://images.gr-assets.com/books/1373071385m...   \n",
       "4413  https://images.gr-assets.com/books/1331061173m...   \n",
       "6244  https://s.gr-assets.com/assets/nophoto/book/11...   \n",
       "5316  https://images.gr-assets.com/books/1320548612m...   \n",
       "5213  https://s.gr-assets.com/assets/nophoto/book/11...   \n",
       "7849  https://s.gr-assets.com/assets/nophoto/book/11...   \n",
       "6324  https://s.gr-assets.com/assets/nophoto/book/11...   \n",
       "\n",
       "                                              mod_title     score  \n",
       "0        dantes inferno the divine comedy volume 1 hell  5.932188  \n",
       "69                when bad things happen to good people  2.866972  \n",
       "7756                a modern celt seeking the ancestors  0.250000  \n",
       "7055         marriage and the family in the middle ages  0.222222  \n",
       "4413                           edmund dulacs fairy book  0.222222  \n",
       "6244   creation and falltemptation two biblical studies  0.190476  \n",
       "5316  what your fourth grader needs to know fundamen...  0.190476  \n",
       "5213  christmas gifts christmas voices a holiday nov...  0.190476  \n",
       "7849                                      undercurrents  0.166667  \n",
       "6324                   an introduction to the apocrypha  0.148148  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_recs = all_recs.merge(books_titles, how=\"inner\", on=\"book_id\") #if the data doesn't exist in all rows get rid of it\n",
    "\n",
    "#finally sorts through all books \n",
    "all_recs[\"score\"] = all_recs[\"book_count\"] * (all_recs[\"book_count\"] / all_recs[\"ratings\"])\n",
    "\n",
    "\n",
    "all_recs.sort_values(\"score\", ascending=False).head(10)\n",
    "\n",
    "\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}