ETLProject_v2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import requests as r\n",
    "import sqlalchemy\n",
    "import time\n",
    "pd.options.display.max_columns = None\n",
    "\n",
    "#!kaggle datasets download -d palanjali007/amazons-top-50-bestselling-novels-20092020"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "#!unzip 'amazons-top-50-bestselling-novels-*.zip' "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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></th>\n",
       "      <th>User Rating</th>\n",
       "      <th>Reviews</th>\n",
       "      <th>Price</th>\n",
       "      <th>Year</th>\n",
       "      <th>Genre</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Name</th>\n",
       "      <th>Author</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",
       "      <td>10-Day Green Smoothie Cleanse</td>\n",
       "      <td>JJ Smith</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>11/22/63: A Novel</td>\n",
       "      <td>Stephen King</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>12 Rules for Life: An Antidote to Chaos</td>\n",
       "      <td>Jordan B. Peterson</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1984 (Signet Classics)</td>\n",
       "      <td>George Orwell</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5,000 Awesome Facts (About Everything!) (National Geographic Kids)</td>\n",
       "      <td>National Geographic Kids</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Winter of the World: Book Two of the Century Trilogy</td>\n",
       "      <td>Ken Follett</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Women Food and God: An Unexpected Path to Almost Everything</td>\n",
       "      <td>Geneen Roth</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Wonder</td>\n",
       "      <td>R. J. Palacio</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Wrecking Ball (Diary of a Wimpy Kid Book 14)</td>\n",
       "      <td>Jeff Kinney</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>You Are a Badass: How to Stop Doubting Your Greatness and Start Living an Awesome Life</td>\n",
       "      <td>Jen Sincero</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>392 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                             User Rating  \\\n",
       "Name                                               Author                                  \n",
       "10-Day Green Smoothie Cleanse                      JJ Smith                            1   \n",
       "11/22/63: A Novel                                  Stephen King                        1   \n",
       "12 Rules for Life: An Antidote to Chaos            Jordan B. Peterson                  1   \n",
       "1984 (Signet Classics)                             George Orwell                       1   \n",
       "5,000 Awesome Facts (About Everything!) (Nation... National Geographic Kids            1   \n",
       "...                                                                                  ...   \n",
       "Winter of the World: Book Two of the Century Tr... Ken Follett                         1   \n",
       "Women Food and God: An Unexpected Path to Almos... Geneen Roth                         1   \n",
       "Wonder                                             R. J. Palacio                       5   \n",
       "Wrecking Ball (Diary of a Wimpy Kid Book 14)       Jeff Kinney                         1   \n",
       "You Are a Badass: How to Stop Doubting Your Gre... Jen Sincero                         4   \n",
       "\n",
       "                                                                             Reviews  \\\n",
       "Name                                               Author                              \n",
       "10-Day Green Smoothie Cleanse                      JJ Smith                        1   \n",
       "11/22/63: A Novel                                  Stephen King                    1   \n",
       "12 Rules for Life: An Antidote to Chaos            Jordan B. Peterson              1   \n",
       "1984 (Signet Classics)                             George Orwell                   1   \n",
       "5,000 Awesome Facts (About Everything!) (Nation... National Geographic Kids        1   \n",
       "...                                                                              ...   \n",
       "Winter of the World: Book Two of the Century Tr... Ken Follett                     1   \n",
       "Women Food and God: An Unexpected Path to Almos... Geneen Roth                     1   \n",
       "Wonder                                             R. J. Palacio                   5   \n",
       "Wrecking Ball (Diary of a Wimpy Kid Book 14)       Jeff Kinney                     1   \n",
       "You Are a Badass: How to Stop Doubting Your Gre... Jen Sincero                     4   \n",
       "\n",
       "                                                                             Price  \\\n",
       "Name                                               Author                            \n",
       "10-Day Green Smoothie Cleanse                      JJ Smith                      1   \n",
       "11/22/63: A Novel                                  Stephen King                  1   \n",
       "12 Rules for Life: An Antidote to Chaos            Jordan B. Peterson            1   \n",
       "1984 (Signet Classics)                             George Orwell                 1   \n",
       "5,000 Awesome Facts (About Everything!) (Nation... National Geographic Kids      1   \n",
       "...                                                                            ...   \n",
       "Winter of the World: Book Two of the Century Tr... Ken Follett                   1   \n",
       "Women Food and God: An Unexpected Path to Almos... Geneen Roth                   1   \n",
       "Wonder                                             R. J. Palacio                 5   \n",
       "Wrecking Ball (Diary of a Wimpy Kid Book 14)       Jeff Kinney                   1   \n",
       "You Are a Badass: How to Stop Doubting Your Gre... Jen Sincero                   4   \n",
       "\n",
       "                                                                             Year  \\\n",
       "Name                                               Author                           \n",
       "10-Day Green Smoothie Cleanse                      JJ Smith                     1   \n",
       "11/22/63: A Novel                                  Stephen King                 1   \n",
       "12 Rules for Life: An Antidote to Chaos            Jordan B. Peterson           1   \n",
       "1984 (Signet Classics)                             George Orwell                1   \n",
       "5,000 Awesome Facts (About Everything!) (Nation... National Geographic Kids     1   \n",
       "...                                                                           ...   \n",
       "Winter of the World: Book Two of the Century Tr... Ken Follett                  1   \n",
       "Women Food and God: An Unexpected Path to Almos... Geneen Roth                  1   \n",
       "Wonder                                             R. J. Palacio                5   \n",
       "Wrecking Ball (Diary of a Wimpy Kid Book 14)       Jeff Kinney                  1   \n",
       "You Are a Badass: How to Stop Doubting Your Gre... Jen Sincero                  4   \n",
       "\n",
       "                                                                             Genre  \n",
       "Name                                               Author                           \n",
       "10-Day Green Smoothie Cleanse                      JJ Smith                      1  \n",
       "11/22/63: A Novel                                  Stephen King                  1  \n",
       "12 Rules for Life: An Antidote to Chaos            Jordan B. Peterson            1  \n",
       "1984 (Signet Classics)                             George Orwell                 1  \n",
       "5,000 Awesome Facts (About Everything!) (Nation... National Geographic Kids      1  \n",
       "...                                                                            ...  \n",
       "Winter of the World: Book Two of the Century Tr... Ken Follett                   1  \n",
       "Women Food and God: An Unexpected Path to Almos... Geneen Roth                   1  \n",
       "Wonder                                             R. J. Palacio                 5  \n",
       "Wrecking Ball (Diary of a Wimpy Kid Book 14)       Jeff Kinney                   1  \n",
       "You Are a Badass: How to Stop Doubting Your Gre... Jen Sincero                   4  \n",
       "\n",
       "[392 rows x 5 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "books_df=pd.read_csv('AmazonBooks - Sheet1.csv')\n",
    "#after=\"\"\n",
    "#data=[]\n",
    "#url=\"kaggle datasets download -d atahmasb/amazon-job-skills\"\n",
    "books_df.groupby([\"Name\", \"Author\"]).count()\n"
   ]
  },
  {
   "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>Unnamed: 0</th>\n",
       "      <th>Titles</th>\n",
       "      <th>Genre</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12 Rules for Life: An Antidote to Chaos</td>\n",
       "      <td>Self Help</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>12 Rules for Life: An Antidote to Chaos</td>\n",
       "      <td>Psychology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>5,000 Awesome Facts (About Everything!) (Natio...</td>\n",
       "      <td>Nonfiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>5,000 Awesome Facts (About Everything!) (Natio...</td>\n",
       "      <td>Science</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>5,000 Awesome Facts (About Everything!) (Natio...</td>\n",
       "      <td>Childrens</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2464</td>\n",
       "      <td>10</td>\n",
       "      <td>The Unofficial Harry Potter Cookbook: From Cau...</td>\n",
       "      <td>Magic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2465</td>\n",
       "      <td>11</td>\n",
       "      <td>The Unofficial Harry Potter Cookbook: From Cau...</td>\n",
       "      <td>Pop Culture</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2466</td>\n",
       "      <td>12</td>\n",
       "      <td>The Unofficial Harry Potter Cookbook: From Cau...</td>\n",
       "      <td>Fandom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2467</td>\n",
       "      <td>13</td>\n",
       "      <td>The Unofficial Harry Potter Cookbook: From Cau...</td>\n",
       "      <td>Childrens</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2468</td>\n",
       "      <td>14</td>\n",
       "      <td>The Unofficial Harry Potter Cookbook: From Cau...</td>\n",
       "      <td>Adult</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2469 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0                                             Titles  \\\n",
       "0              0            12 Rules for Life: An Antidote to Chaos   \n",
       "1              1            12 Rules for Life: An Antidote to Chaos   \n",
       "2              0  5,000 Awesome Facts (About Everything!) (Natio...   \n",
       "3              1  5,000 Awesome Facts (About Everything!) (Natio...   \n",
       "4              2  5,000 Awesome Facts (About Everything!) (Natio...   \n",
       "...          ...                                                ...   \n",
       "2464          10  The Unofficial Harry Potter Cookbook: From Cau...   \n",
       "2465          11  The Unofficial Harry Potter Cookbook: From Cau...   \n",
       "2466          12  The Unofficial Harry Potter Cookbook: From Cau...   \n",
       "2467          13  The Unofficial Harry Potter Cookbook: From Cau...   \n",
       "2468          14  The Unofficial Harry Potter Cookbook: From Cau...   \n",
       "\n",
       "            Genre  \n",
       "0       Self Help  \n",
       "1      Psychology  \n",
       "2      Nonfiction  \n",
       "3         Science  \n",
       "4       Childrens  \n",
       "...           ...  \n",
       "2464        Magic  \n",
       "2465  Pop Culture  \n",
       "2466       Fandom  \n",
       "2467    Childrens  \n",
       "2468        Adult  \n",
       "\n",
       "[2469 rows x 3 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "genre_df=pd.read_csv('genre.csv')\n",
    "genre_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "genre_df=genre_df.rename(columns={\"Titles\":\"Name\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>Name</th>\n",
       "      <th>Author</th>\n",
       "      <th>User Rating</th>\n",
       "      <th>Reviews</th>\n",
       "      <th>Price</th>\n",
       "      <th>Year</th>\n",
       "      <th>Genre_x</th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Genre_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>11/22/63: A Novel</td>\n",
       "      <td>Stephen King</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2052</td>\n",
       "      <td>22</td>\n",
       "      <td>2011</td>\n",
       "      <td>Fiction</td>\n",
       "      <td>0</td>\n",
       "      <td>Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>11/22/63: A Novel</td>\n",
       "      <td>Stephen King</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2052</td>\n",
       "      <td>22</td>\n",
       "      <td>2011</td>\n",
       "      <td>Fiction</td>\n",
       "      <td>1</td>\n",
       "      <td>Historical</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>11/22/63: A Novel</td>\n",
       "      <td>Stephen King</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2052</td>\n",
       "      <td>22</td>\n",
       "      <td>2011</td>\n",
       "      <td>Fiction</td>\n",
       "      <td>2</td>\n",
       "      <td>Historical Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>11/22/63: A Novel</td>\n",
       "      <td>Stephen King</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2052</td>\n",
       "      <td>22</td>\n",
       "      <td>2011</td>\n",
       "      <td>Fiction</td>\n",
       "      <td>3</td>\n",
       "      <td>Science Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>11/22/63: A Novel</td>\n",
       "      <td>Stephen King</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2052</td>\n",
       "      <td>22</td>\n",
       "      <td>2011</td>\n",
       "      <td>Fiction</td>\n",
       "      <td>4</td>\n",
       "      <td>Science Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3440</td>\n",
       "      <td>Burn After Writing</td>\n",
       "      <td>Sharon Jones</td>\n",
       "      <td>4.6</td>\n",
       "      <td>26423</td>\n",
       "      <td>8</td>\n",
       "      <td>2020</td>\n",
       "      <td>Non Fiction</td>\n",
       "      <td>4</td>\n",
       "      <td>Health</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3441</td>\n",
       "      <td>Burn After Writing</td>\n",
       "      <td>Sharon Jones</td>\n",
       "      <td>4.6</td>\n",
       "      <td>26423</td>\n",
       "      <td>8</td>\n",
       "      <td>2020</td>\n",
       "      <td>Non Fiction</td>\n",
       "      <td>5</td>\n",
       "      <td>Mental Health</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3442</td>\n",
       "      <td>Human Body Activity Book for Kids: Hands-On Fu...</td>\n",
       "      <td>Katie Stokes</td>\n",
       "      <td>4.7</td>\n",
       "      <td>14128</td>\n",
       "      <td>5</td>\n",
       "      <td>2020</td>\n",
       "      <td>Non Fiction</td>\n",
       "      <td>0</td>\n",
       "      <td>Childrens</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3443</td>\n",
       "      <td>Human Body Activity Book for Kids: Hands-On Fu...</td>\n",
       "      <td>Katie Stokes</td>\n",
       "      <td>4.7</td>\n",
       "      <td>14128</td>\n",
       "      <td>5</td>\n",
       "      <td>2020</td>\n",
       "      <td>Non Fiction</td>\n",
       "      <td>1</td>\n",
       "      <td>Science</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3444</td>\n",
       "      <td>Human Body Activity Book for Kids: Hands-On Fu...</td>\n",
       "      <td>Katie Stokes</td>\n",
       "      <td>4.7</td>\n",
       "      <td>14128</td>\n",
       "      <td>5</td>\n",
       "      <td>2020</td>\n",
       "      <td>Non Fiction</td>\n",
       "      <td>2</td>\n",
       "      <td>Nonfiction</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3445 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   Name        Author  \\\n",
       "0                                     11/22/63: A Novel  Stephen King   \n",
       "1                                     11/22/63: A Novel  Stephen King   \n",
       "2                                     11/22/63: A Novel  Stephen King   \n",
       "3                                     11/22/63: A Novel  Stephen King   \n",
       "4                                     11/22/63: A Novel  Stephen King   \n",
       "...                                                 ...           ...   \n",
       "3440                                 Burn After Writing  Sharon Jones   \n",
       "3441                                 Burn After Writing  Sharon Jones   \n",
       "3442  Human Body Activity Book for Kids: Hands-On Fu...  Katie Stokes   \n",
       "3443  Human Body Activity Book for Kids: Hands-On Fu...  Katie Stokes   \n",
       "3444  Human Body Activity Book for Kids: Hands-On Fu...  Katie Stokes   \n",
       "\n",
       "      User Rating  Reviews  Price  Year      Genre_x  Unnamed: 0  \\\n",
       "0             4.6     2052     22  2011      Fiction           0   \n",
       "1             4.6     2052     22  2011      Fiction           1   \n",
       "2             4.6     2052     22  2011      Fiction           2   \n",
       "3             4.6     2052     22  2011      Fiction           3   \n",
       "4             4.6     2052     22  2011      Fiction           4   \n",
       "...           ...      ...    ...   ...          ...         ...   \n",
       "3440          4.6    26423      8  2020  Non Fiction           4   \n",
       "3441          4.6    26423      8  2020  Non Fiction           5   \n",
       "3442          4.7    14128      5  2020  Non Fiction           0   \n",
       "3443          4.7    14128      5  2020  Non Fiction           1   \n",
       "3444          4.7    14128      5  2020  Non Fiction           2   \n",
       "\n",
       "                 Genre_y  \n",
       "0                Fiction  \n",
       "1             Historical  \n",
       "2     Historical Fiction  \n",
       "3        Science Fiction  \n",
       "4        Science Fiction  \n",
       "...                  ...  \n",
       "3440              Health  \n",
       "3441       Mental Health  \n",
       "3442           Childrens  \n",
       "3443             Science  \n",
       "3444          Nonfiction  \n",
       "\n",
       "[3445 rows x 9 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "book_genre_df=pd.merge(books_df, genre_df, on=\"Name\")\n",
    "book_genre_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>Name</th>\n",
       "      <th>Author</th>\n",
       "      <th>User Rating</th>\n",
       "      <th>Reviews</th>\n",
       "      <th>Price</th>\n",
       "      <th>Year</th>\n",
       "      <th>Gen_Genre</th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Spec_Genre</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>11/22/63: A Novel</td>\n",
       "      <td>Stephen King</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2052</td>\n",
       "      <td>22</td>\n",
       "      <td>2011</td>\n",
       "      <td>Fiction</td>\n",
       "      <td>0</td>\n",
       "      <td>Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>11/22/63: A Novel</td>\n",
       "      <td>Stephen King</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2052</td>\n",
       "      <td>22</td>\n",
       "      <td>2011</td>\n",
       "      <td>Fiction</td>\n",
       "      <td>1</td>\n",
       "      <td>Historical</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>11/22/63: A Novel</td>\n",
       "      <td>Stephen King</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2052</td>\n",
       "      <td>22</td>\n",
       "      <td>2011</td>\n",
       "      <td>Fiction</td>\n",
       "      <td>2</td>\n",
       "      <td>Historical Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>11/22/63: A Novel</td>\n",
       "      <td>Stephen King</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2052</td>\n",
       "      <td>22</td>\n",
       "      <td>2011</td>\n",
       "      <td>Fiction</td>\n",
       "      <td>3</td>\n",
       "      <td>Science Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>11/22/63: A Novel</td>\n",
       "      <td>Stephen King</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2052</td>\n",
       "      <td>22</td>\n",
       "      <td>2011</td>\n",
       "      <td>Fiction</td>\n",
       "      <td>4</td>\n",
       "      <td>Science Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3440</td>\n",
       "      <td>Burn After Writing</td>\n",
       "      <td>Sharon Jones</td>\n",
       "      <td>4.6</td>\n",
       "      <td>26423</td>\n",
       "      <td>8</td>\n",
       "      <td>2020</td>\n",
       "      <td>Non Fiction</td>\n",
       "      <td>4</td>\n",
       "      <td>Health</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3441</td>\n",
       "      <td>Burn After Writing</td>\n",
       "      <td>Sharon Jones</td>\n",
       "      <td>4.6</td>\n",
       "      <td>26423</td>\n",
       "      <td>8</td>\n",
       "      <td>2020</td>\n",
       "      <td>Non Fiction</td>\n",
       "      <td>5</td>\n",
       "      <td>Mental Health</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3442</td>\n",
       "      <td>Human Body Activity Book for Kids: Hands-On Fu...</td>\n",
       "      <td>Katie Stokes</td>\n",
       "      <td>4.7</td>\n",
       "      <td>14128</td>\n",
       "      <td>5</td>\n",
       "      <td>2020</td>\n",
       "      <td>Non Fiction</td>\n",
       "      <td>0</td>\n",
       "      <td>Childrens</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3443</td>\n",
       "      <td>Human Body Activity Book for Kids: Hands-On Fu...</td>\n",
       "      <td>Katie Stokes</td>\n",
       "      <td>4.7</td>\n",
       "      <td>14128</td>\n",
       "      <td>5</td>\n",
       "      <td>2020</td>\n",
       "      <td>Non Fiction</td>\n",
       "      <td>1</td>\n",
       "      <td>Science</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3444</td>\n",
       "      <td>Human Body Activity Book for Kids: Hands-On Fu...</td>\n",
       "      <td>Katie Stokes</td>\n",
       "      <td>4.7</td>\n",
       "      <td>14128</td>\n",
       "      <td>5</td>\n",
       "      <td>2020</td>\n",
       "      <td>Non Fiction</td>\n",
       "      <td>2</td>\n",
       "      <td>Nonfiction</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3445 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   Name        Author  \\\n",
       "0                                     11/22/63: A Novel  Stephen King   \n",
       "1                                     11/22/63: A Novel  Stephen King   \n",
       "2                                     11/22/63: A Novel  Stephen King   \n",
       "3                                     11/22/63: A Novel  Stephen King   \n",
       "4                                     11/22/63: A Novel  Stephen King   \n",
       "...                                                 ...           ...   \n",
       "3440                                 Burn After Writing  Sharon Jones   \n",
       "3441                                 Burn After Writing  Sharon Jones   \n",
       "3442  Human Body Activity Book for Kids: Hands-On Fu...  Katie Stokes   \n",
       "3443  Human Body Activity Book for Kids: Hands-On Fu...  Katie Stokes   \n",
       "3444  Human Body Activity Book for Kids: Hands-On Fu...  Katie Stokes   \n",
       "\n",
       "      User Rating  Reviews  Price  Year    Gen_Genre  Unnamed: 0  \\\n",
       "0             4.6     2052     22  2011      Fiction           0   \n",
       "1             4.6     2052     22  2011      Fiction           1   \n",
       "2             4.6     2052     22  2011      Fiction           2   \n",
       "3             4.6     2052     22  2011      Fiction           3   \n",
       "4             4.6     2052     22  2011      Fiction           4   \n",
       "...           ...      ...    ...   ...          ...         ...   \n",
       "3440          4.6    26423      8  2020  Non Fiction           4   \n",
       "3441          4.6    26423      8  2020  Non Fiction           5   \n",
       "3442          4.7    14128      5  2020  Non Fiction           0   \n",
       "3443          4.7    14128      5  2020  Non Fiction           1   \n",
       "3444          4.7    14128      5  2020  Non Fiction           2   \n",
       "\n",
       "              Spec_Genre  \n",
       "0                Fiction  \n",
       "1             Historical  \n",
       "2     Historical Fiction  \n",
       "3        Science Fiction  \n",
       "4        Science Fiction  \n",
       "...                  ...  \n",
       "3440              Health  \n",
       "3441       Mental Health  \n",
       "3442           Childrens  \n",
       "3443             Science  \n",
       "3444          Nonfiction  \n",
       "\n",
       "[3445 rows x 9 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "book_genre_df=book_genre_df.rename(columns={\"Genre_x\":\"Gen_Genre\", \"Genre_y\":\"Spec_Genre\"})\n",
    "book_genre_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>Name</th>\n",
       "      <th>Author</th>\n",
       "      <th>User Rating</th>\n",
       "      <th>Reviews</th>\n",
       "      <th>Price</th>\n",
       "      <th>Year</th>\n",
       "      <th>Gen_Genre</th>\n",
       "      <th>Spec_Genre</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>11/22/63: A Novel</td>\n",
       "      <td>Stephen King</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2052</td>\n",
       "      <td>22</td>\n",
       "      <td>2011</td>\n",
       "      <td>Fiction</td>\n",
       "      <td>Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>11/22/63: A Novel</td>\n",
       "      <td>Stephen King</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2052</td>\n",
       "      <td>22</td>\n",
       "      <td>2011</td>\n",
       "      <td>Fiction</td>\n",
       "      <td>Historical</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>11/22/63: A Novel</td>\n",
       "      <td>Stephen King</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2052</td>\n",
       "      <td>22</td>\n",
       "      <td>2011</td>\n",
       "      <td>Fiction</td>\n",
       "      <td>Historical Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>11/22/63: A Novel</td>\n",
       "      <td>Stephen King</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2052</td>\n",
       "      <td>22</td>\n",
       "      <td>2011</td>\n",
       "      <td>Fiction</td>\n",
       "      <td>Science Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>11/22/63: A Novel</td>\n",
       "      <td>Stephen King</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2052</td>\n",
       "      <td>22</td>\n",
       "      <td>2011</td>\n",
       "      <td>Fiction</td>\n",
       "      <td>Science Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3440</td>\n",
       "      <td>Burn After Writing</td>\n",
       "      <td>Sharon Jones</td>\n",
       "      <td>4.6</td>\n",
       "      <td>26423</td>\n",
       "      <td>8</td>\n",
       "      <td>2020</td>\n",
       "      <td>Non Fiction</td>\n",
       "      <td>Health</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3441</td>\n",
       "      <td>Burn After Writing</td>\n",
       "      <td>Sharon Jones</td>\n",
       "      <td>4.6</td>\n",
       "      <td>26423</td>\n",
       "      <td>8</td>\n",
       "      <td>2020</td>\n",
       "      <td>Non Fiction</td>\n",
       "      <td>Mental Health</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3442</td>\n",
       "      <td>Human Body Activity Book for Kids: Hands-On Fu...</td>\n",
       "      <td>Katie Stokes</td>\n",
       "      <td>4.7</td>\n",
       "      <td>14128</td>\n",
       "      <td>5</td>\n",
       "      <td>2020</td>\n",
       "      <td>Non Fiction</td>\n",
       "      <td>Childrens</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3443</td>\n",
       "      <td>Human Body Activity Book for Kids: Hands-On Fu...</td>\n",
       "      <td>Katie Stokes</td>\n",
       "      <td>4.7</td>\n",
       "      <td>14128</td>\n",
       "      <td>5</td>\n",
       "      <td>2020</td>\n",
       "      <td>Non Fiction</td>\n",
       "      <td>Science</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3444</td>\n",
       "      <td>Human Body Activity Book for Kids: Hands-On Fu...</td>\n",
       "      <td>Katie Stokes</td>\n",
       "      <td>4.7</td>\n",
       "      <td>14128</td>\n",
       "      <td>5</td>\n",
       "      <td>2020</td>\n",
       "      <td>Non Fiction</td>\n",
       "      <td>Nonfiction</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3445 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   Name        Author  \\\n",
       "0                                     11/22/63: A Novel  Stephen King   \n",
       "1                                     11/22/63: A Novel  Stephen King   \n",
       "2                                     11/22/63: A Novel  Stephen King   \n",
       "3                                     11/22/63: A Novel  Stephen King   \n",
       "4                                     11/22/63: A Novel  Stephen King   \n",
       "...                                                 ...           ...   \n",
       "3440                                 Burn After Writing  Sharon Jones   \n",
       "3441                                 Burn After Writing  Sharon Jones   \n",
       "3442  Human Body Activity Book for Kids: Hands-On Fu...  Katie Stokes   \n",
       "3443  Human Body Activity Book for Kids: Hands-On Fu...  Katie Stokes   \n",
       "3444  Human Body Activity Book for Kids: Hands-On Fu...  Katie Stokes   \n",
       "\n",
       "      User Rating  Reviews  Price  Year    Gen_Genre          Spec_Genre  \n",
       "0             4.6     2052     22  2011      Fiction             Fiction  \n",
       "1             4.6     2052     22  2011      Fiction          Historical  \n",
       "2             4.6     2052     22  2011      Fiction  Historical Fiction  \n",
       "3             4.6     2052     22  2011      Fiction     Science Fiction  \n",
       "4             4.6     2052     22  2011      Fiction     Science Fiction  \n",
       "...           ...      ...    ...   ...          ...                 ...  \n",
       "3440          4.6    26423      8  2020  Non Fiction              Health  \n",
       "3441          4.6    26423      8  2020  Non Fiction       Mental Health  \n",
       "3442          4.7    14128      5  2020  Non Fiction           Childrens  \n",
       "3443          4.7    14128      5  2020  Non Fiction             Science  \n",
       "3444          4.7    14128      5  2020  Non Fiction          Nonfiction  \n",
       "\n",
       "[3445 rows x 8 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "book_genre_df = book_genre_df.drop(columns=[\"Unnamed: 0\"])\n",
    "book_genre_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>Name</th>\n",
       "      <th>Author</th>\n",
       "      <th>User Rating</th>\n",
       "      <th>Reviews</th>\n",
       "      <th>Price</th>\n",
       "      <th>Year</th>\n",
       "      <th>Gen_Genre</th>\n",
       "      <th>Spec_Genre</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2422</td>\n",
       "      <td>The Hate U Give</td>\n",
       "      <td>Angie Thomas</td>\n",
       "      <td>4.8</td>\n",
       "      <td>9947</td>\n",
       "      <td>11</td>\n",
       "      <td>2018</td>\n",
       "      <td>Fiction</td>\n",
       "      <td>Race</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3393</td>\n",
       "      <td>The Vanishing Half</td>\n",
       "      <td>Brit Bennett</td>\n",
       "      <td>4.4</td>\n",
       "      <td>42235</td>\n",
       "      <td>16</td>\n",
       "      <td>2020</td>\n",
       "      <td>Fiction</td>\n",
       "      <td>Race</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Name        Author  User Rating  Reviews  Price  Year  \\\n",
       "2422     The Hate U Give  Angie Thomas          4.8     9947     11  2018   \n",
       "3393  The Vanishing Half  Brit Bennett          4.4    42235     16  2020   \n",
       "\n",
       "     Gen_Genre Spec_Genre  \n",
       "2422   Fiction       Race  \n",
       "3393   Fiction       Race  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "race_df = book_genre_df[book_genre_df[\"Spec_Genre\"]==\"Race\"]\n",
    "race_df"
   ]
  },
  {
   "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>Name</th>\n",
       "      <th>Author</th>\n",
       "      <th>User Rating</th>\n",
       "      <th>Reviews</th>\n",
       "      <th>Price</th>\n",
       "      <th>Year</th>\n",
       "      <th>Gen_Genre</th>\n",
       "      <th>Spec_Genre</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2424</td>\n",
       "      <td>The Hate U Give</td>\n",
       "      <td>Angie Thomas</td>\n",
       "      <td>4.8</td>\n",
       "      <td>9947</td>\n",
       "      <td>11</td>\n",
       "      <td>2018</td>\n",
       "      <td>Fiction</td>\n",
       "      <td>Social Justice</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Name        Author  User Rating  Reviews  Price  Year  \\\n",
       "2424  The Hate U Give  Angie Thomas          4.8     9947     11  2018   \n",
       "\n",
       "     Gen_Genre      Spec_Genre  \n",
       "2424   Fiction  Social Justice  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "social_justice_df = book_genre_df[book_genre_df[\"Spec_Genre\"]==\"Social Justice\"]\n",
    "social_justice_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>Name</th>\n",
       "      <th>Author</th>\n",
       "      <th>User Rating</th>\n",
       "      <th>Reviews</th>\n",
       "      <th>Price</th>\n",
       "      <th>Year</th>\n",
       "      <th>Gen_Genre</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spec_Genre</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",
       "      <td>Childrens</td>\n",
       "      <td>254</td>\n",
       "      <td>254</td>\n",
       "      <td>254</td>\n",
       "      <td>254</td>\n",
       "      <td>254</td>\n",
       "      <td>254</td>\n",
       "      <td>254</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Food and Drink</td>\n",
       "      <td>156</td>\n",
       "      <td>156</td>\n",
       "      <td>156</td>\n",
       "      <td>156</td>\n",
       "      <td>156</td>\n",
       "      <td>156</td>\n",
       "      <td>156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Nonfiction</td>\n",
       "      <td>149</td>\n",
       "      <td>149</td>\n",
       "      <td>149</td>\n",
       "      <td>149</td>\n",
       "      <td>149</td>\n",
       "      <td>149</td>\n",
       "      <td>149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Fiction</td>\n",
       "      <td>145</td>\n",
       "      <td>145</td>\n",
       "      <td>145</td>\n",
       "      <td>145</td>\n",
       "      <td>145</td>\n",
       "      <td>145</td>\n",
       "      <td>145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Fantasy</td>\n",
       "      <td>125</td>\n",
       "      <td>125</td>\n",
       "      <td>125</td>\n",
       "      <td>125</td>\n",
       "      <td>125</td>\n",
       "      <td>125</td>\n",
       "      <td>125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Humor</td>\n",
       "      <td>85</td>\n",
       "      <td>85</td>\n",
       "      <td>85</td>\n",
       "      <td>85</td>\n",
       "      <td>85</td>\n",
       "      <td>85</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Religion</td>\n",
       "      <td>70</td>\n",
       "      <td>70</td>\n",
       "      <td>70</td>\n",
       "      <td>70</td>\n",
       "      <td>70</td>\n",
       "      <td>70</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Self Help</td>\n",
       "      <td>67</td>\n",
       "      <td>67</td>\n",
       "      <td>67</td>\n",
       "      <td>67</td>\n",
       "      <td>67</td>\n",
       "      <td>67</td>\n",
       "      <td>67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Young Adult</td>\n",
       "      <td>66</td>\n",
       "      <td>66</td>\n",
       "      <td>66</td>\n",
       "      <td>66</td>\n",
       "      <td>66</td>\n",
       "      <td>66</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Audiobook</td>\n",
       "      <td>65</td>\n",
       "      <td>65</td>\n",
       "      <td>65</td>\n",
       "      <td>65</td>\n",
       "      <td>65</td>\n",
       "      <td>65</td>\n",
       "      <td>65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Adult</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Reference</td>\n",
       "      <td>54</td>\n",
       "      <td>54</td>\n",
       "      <td>54</td>\n",
       "      <td>54</td>\n",
       "      <td>54</td>\n",
       "      <td>54</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Picture Books</td>\n",
       "      <td>52</td>\n",
       "      <td>52</td>\n",
       "      <td>52</td>\n",
       "      <td>52</td>\n",
       "      <td>52</td>\n",
       "      <td>52</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Biography</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Christian</td>\n",
       "      <td>49</td>\n",
       "      <td>49</td>\n",
       "      <td>49</td>\n",
       "      <td>49</td>\n",
       "      <td>49</td>\n",
       "      <td>49</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Animals</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Health</td>\n",
       "      <td>42</td>\n",
       "      <td>42</td>\n",
       "      <td>42</td>\n",
       "      <td>42</td>\n",
       "      <td>42</td>\n",
       "      <td>42</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Kids</td>\n",
       "      <td>41</td>\n",
       "      <td>41</td>\n",
       "      <td>41</td>\n",
       "      <td>41</td>\n",
       "      <td>41</td>\n",
       "      <td>41</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Politics</td>\n",
       "      <td>41</td>\n",
       "      <td>41</td>\n",
       "      <td>41</td>\n",
       "      <td>41</td>\n",
       "      <td>41</td>\n",
       "      <td>41</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Storytime</td>\n",
       "      <td>39</td>\n",
       "      <td>39</td>\n",
       "      <td>39</td>\n",
       "      <td>39</td>\n",
       "      <td>39</td>\n",
       "      <td>39</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Name  Author  User Rating  Reviews  Price  Year  Gen_Genre\n",
       "Spec_Genre                                                                \n",
       "Childrens        254     254          254      254    254   254        254\n",
       "Food and Drink   156     156          156      156    156   156        156\n",
       "Nonfiction       149     149          149      149    149   149        149\n",
       "Fiction          145     145          145      145    145   145        145\n",
       "Fantasy          125     125          125      125    125   125        125\n",
       "Humor             85      85           85       85     85    85         85\n",
       "Religion          70      70           70       70     70    70         70\n",
       "Self Help         67      67           67       67     67    67         67\n",
       "Young Adult       66      66           66       66     66    66         66\n",
       "Audiobook         65      65           65       65     65    65         65\n",
       "Adult             56      56           56       56     56    56         56\n",
       "Reference         54      54           54       54     54    54         54\n",
       "Picture Books     52      52           52       52     52    52         52\n",
       "Biography         50      50           50       50     50    50         50\n",
       "Christian         49      49           49       49     49    49         49\n",
       "Animals           45      45           45       45     45    45         45\n",
       "Health            42      42           42       42     42    42         42\n",
       "Kids              41      41           41       41     41    41         41\n",
       "Politics          41      41           41       41     41    41         41\n",
       "Storytime         39      39           39       39     39    39         39"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "genre_count = book_genre_df.groupby(book_genre_df[\"Spec_Genre\"]).count()\n",
    "genre_count = genre_count.sort_values(by=[\"Name\"],ascending=False)\n",
    "genre_count.head(20)"
   ]
  },
  {
   "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.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}