AmazonDataExtraction/amazon_etl.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from bs4 import BeautifulSoup\n",
    "import requests\n",
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to extract Product Title\n",
    "def get_title(soup):\n",
    "\n",
    "    try:\n",
    "        # Outer Tag Object\n",
    "        title = soup.find(\"span\", attrs={\"id\":'productTitle'})\n",
    "        \n",
    "        # Inner NavigatableString Object\n",
    "        title_value = title.text\n",
    "\n",
    "        # Title as a string value\n",
    "        title_string = title_value.strip()\n",
    "\n",
    "    except AttributeError:\n",
    "        title_string = \"\"\n",
    "\n",
    "    return title_string\n",
    "\n",
    "# Function to extract Product Price\n",
    "def get_price(soup):\n",
    "\n",
    "    try:\n",
    "        price = soup.find(\"span\", attrs={'id':'price'}).text\n",
    "\n",
    "    except AttributeError:\n",
    "        price = \"\"\n",
    "\n",
    "    return price\n",
    "\n",
    "# Function to extract Product Rating\n",
    "def get_rating(soup):\n",
    "\n",
    "    try:\n",
    "        rating = soup.find(\"i\", attrs={'class':'a-icon a-icon-star a-star-4-5'}).string.strip()\n",
    "    \n",
    "    except AttributeError:\n",
    "        try:\n",
    "            rating = soup.find(\"span\", attrs={'class':'a-icon-alt'}).string.strip()\n",
    "        except:\n",
    "            rating = \"\"\t\n",
    "\n",
    "    return rating\n",
    "\n",
    "# Function to extract Number of User Reviews\n",
    "def get_review_count(soup):\n",
    "    try:\n",
    "        review_count = soup.find(\"span\", attrs={'id':'acrCustomerReviewText'}).string.strip()\n",
    "\n",
    "    except AttributeError:\n",
    "        review_count = \"\"\t\n",
    "\n",
    "    return review_count\n",
    "\n",
    "# Function to extract Availability Status\n",
    "def get_availability(soup):\n",
    "    try:\n",
    "        available = soup.find(\"div\", attrs={'id':'availability'})\n",
    "        available = available.find(\"span\").string.strip()\n",
    "\n",
    "    except AttributeError:\n",
    "        available = \"Not Available\"\t\n",
    "\n",
    "    return available"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_author(soup):\n",
    "    try:\n",
    "        author_elements = soup.find_all('span', {'class': 'author notFaded'})\n",
    "        authors = []\n",
    "        for author_element in author_elements:\n",
    "            author_name = author_element.find('a').text.strip()\n",
    "            author_name = author_name.replace('(Author)', '').strip()\n",
    "            authors.append(author_name)\n",
    "    except:\n",
    "        pass\n",
    "    return authors"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "if __name__ == '__main__':\n",
    "\n",
    "    # add your user agent \n",
    "    HEADERS = ({'User-Agent':'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36', 'Accept-Language': 'en-US, en;q=0.5'})\n",
    "\n",
    "    # The webpage URL\n",
    "    URL = \"https://www.amazon.in/s?k=data+engineering+books&crid=1ZXNN5TMBVGEO&sprefix=data+engin%2Caps%2C231&ref=nb_sb_ss_ts-doa-p_2_10\"\n",
    "    # HTTP Request\n",
    "    webpage = requests.get(URL, headers=HEADERS)\n",
    "\n",
    "    # Soup Object containing all data\n",
    "    soup = BeautifulSoup(webpage.content, \"html.parser\")\n",
    "\n",
    "    # Fetch links as List of Tag Objects\n",
    "    links = soup.find_all(\"a\", attrs={'class':'a-link-normal s-no-outline'})\n",
    "\n",
    "    # Store the links\n",
    "    links_list = []\n",
    "\n",
    "    # Loop for extracting links from Tag Objects\n",
    "    for link in links:\n",
    "            links_list.append(link.get('href'))\n",
    "\n",
    "    d = {\"title\":[], \"price\":[], \"rating\":[], \"reviews\":[],\"availability\":[], \"authors\": []}\n",
    "    \n",
    "    # Loop for extracting product details from each link \n",
    "    for link in links_list:\n",
    "        new_webpage = requests.get(\"https://www.amazon.in\" + link, headers=HEADERS)\n",
    "\n",
    "        new_soup = BeautifulSoup(new_webpage.content, \"html.parser\")\n",
    "\n",
    "        # Function calls to display all necessary product information\n",
    "        d['title'].append(get_title(new_soup))\n",
    "        d['price'].append(get_price(new_soup))\n",
    "        d['rating'].append(get_rating(new_soup))\n",
    "        d['reviews'].append(get_review_count(new_soup))\n",
    "        d['availability'].append(get_availability(new_soup))\n",
    "        d['authors'].append(get_author(new_soup))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "amazon_df = pd.DataFrame.from_dict(d)\n",
    "amazon_df['title'].replace('', np.nan, inplace=True)\n",
    "amazon_df = amazon_df.dropna(subset=['title'])\n",
    "amazon_df.to_csv(\"amazon_data.csv\", header=True, index=False)"
   ]
  },
  {
   "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>title</th>\n",
       "      <th>price</th>\n",
       "      <th>rating</th>\n",
       "      <th>reviews</th>\n",
       "      <th>availability</th>\n",
       "      <th>authors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Data Structures and Algorithms Made Easy</td>\n",
       "      <td>₹582.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>2,366 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Narasimha Karumanchi]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Kimball Group Reader: Relentlessly Practic...</td>\n",
       "      <td></td>\n",
       "      <td>4.6 out of 5 stars</td>\n",
       "      <td>64 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Ralph Kimball, Margy Ross]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Fundamentals of Data Engineering: Plan and Bui...</td>\n",
       "      <td>₹1,750.00</td>\n",
       "      <td>4.7 out of 5 stars</td>\n",
       "      <td>209 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Joe Reis, Matt Housley]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Data Engineering with Python: Work with massiv...</td>\n",
       "      <td>₹2,788.00</td>\n",
       "      <td>4.2 out of 5 stars</td>\n",
       "      <td>103 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Paul Crickard]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Data Science for Engineers</td>\n",
       "      <td>₹2,610.00</td>\n",
       "      <td>Previous page</td>\n",
       "      <td></td>\n",
       "      <td>Only 2 left in stock</td>\n",
       "      <td>[Raghunathan Rengaswamy, Resmi Suresh]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>PSG Design Data Handbook - Data Book of Engine...</td>\n",
       "      <td>₹465.00</td>\n",
       "      <td>Previous page</td>\n",
       "      <td></td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Coimbtore PSG College of Technology]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Data Engineering with AWS: Learn how to design...</td>\n",
       "      <td>₹3,126.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>62 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Gareth Eagar]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Azure Data Engineering Cookbook: Design and im...</td>\n",
       "      <td></td>\n",
       "      <td>3.2 out of 5 stars</td>\n",
       "      <td>10 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Ahmad Osama]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Data Engineering with Apache Spark, Delta Lake...</td>\n",
       "      <td></td>\n",
       "      <td>3.9 out of 5 stars</td>\n",
       "      <td>50 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Manoj Kukreja, Danil Zburivsky]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Data Science &amp; Analytics</td>\n",
       "      <td>₹280.00</td>\n",
       "      <td>3.8 out of 5 stars</td>\n",
       "      <td>13 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[VK Jain]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Data Structure and Algorithmic Thinking with P...</td>\n",
       "      <td>₹582.00</td>\n",
       "      <td>4.3 out of 5 stars</td>\n",
       "      <td>713 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Narasimha Karumanchi]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Data Structures and Algorithms Made Easy in Java</td>\n",
       "      <td>₹582.00</td>\n",
       "      <td>4.3 out of 5 stars</td>\n",
       "      <td>1,103 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Narasimha Karumanchi]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Azure Data Engineer Associate Certification Gu...</td>\n",
       "      <td></td>\n",
       "      <td>3.9 out of 5 stars</td>\n",
       "      <td>20 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Newton Alex]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Fundamentals of Data Engineering: Designing an...</td>\n",
       "      <td></td>\n",
       "      <td>4.9 out of 5 stars</td>\n",
       "      <td>29 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Brian  Murray]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Data Engineering with Google Cloud Platform: A...</td>\n",
       "      <td>₹3,464.00</td>\n",
       "      <td>4.8 out of 5 stars</td>\n",
       "      <td>10 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Adi Wijaya]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Design Data Handbook For Mechanical Engineers ...</td>\n",
       "      <td>₹383.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>924 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Mahadevan]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>An Engineering Data Book</td>\n",
       "      <td>₹3,702.00</td>\n",
       "      <td>4.2 out of 5 stars</td>\n",
       "      <td>13 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Dr J.R. Calvert, Professor R.A. Farrar]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Applied Data Science For Mumbai University B.E...</td>\n",
       "      <td>₹252.00</td>\n",
       "      <td>5.0 out of 5 stars</td>\n",
       "      <td>1 rating</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Dr. Harshali Patil, Mr. Loukik S. Salvi, Purv...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Design Data: Data Book of Engineers by PSG Col...</td>\n",
       "      <td>₹462.00</td>\n",
       "      <td>4.2 out of 5 stars</td>\n",
       "      <td>578 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Coimbtore PSG]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Simplifying Data Engineering and Analytics wit...</td>\n",
       "      <td>₹2,957.00</td>\n",
       "      <td>4.3 out of 5 stars</td>\n",
       "      <td>7 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Anindita Mahapatra, Doug May]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>The Data WarehouseETL Toolkit: Practical Techn...</td>\n",
       "      <td></td>\n",
       "      <td>4.5 out of 5 stars</td>\n",
       "      <td>162 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Ralph Kimball, Joe Caserta]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Introducing Data Science</td>\n",
       "      <td>₹690.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>97 ratings</td>\n",
       "      <td>Only 1 left in stock</td>\n",
       "      <td>[Davy Cielen, Arno D.B. Meysman, Mohamed Ali]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                title      price   \n",
       "0            Data Structures and Algorithms Made Easy    ₹582.00  \\\n",
       "1   The Kimball Group Reader: Relentlessly Practic...              \n",
       "2   Fundamentals of Data Engineering: Plan and Bui...  ₹1,750.00   \n",
       "3   Data Engineering with Python: Work with massiv...  ₹2,788.00   \n",
       "4                          Data Science for Engineers  ₹2,610.00   \n",
       "5   PSG Design Data Handbook - Data Book of Engine...    ₹465.00   \n",
       "6   Data Engineering with AWS: Learn how to design...  ₹3,126.00   \n",
       "7   Azure Data Engineering Cookbook: Design and im...              \n",
       "8   Data Engineering with Apache Spark, Delta Lake...              \n",
       "9                            Data Science & Analytics    ₹280.00   \n",
       "10  Data Structure and Algorithmic Thinking with P...    ₹582.00   \n",
       "11   Data Structures and Algorithms Made Easy in Java    ₹582.00   \n",
       "12  Azure Data Engineer Associate Certification Gu...              \n",
       "13  Fundamentals of Data Engineering: Designing an...              \n",
       "14  Data Engineering with Google Cloud Platform: A...  ₹3,464.00   \n",
       "15  Design Data Handbook For Mechanical Engineers ...    ₹383.00   \n",
       "16                           An Engineering Data Book  ₹3,702.00   \n",
       "17  Applied Data Science For Mumbai University B.E...    ₹252.00   \n",
       "18  Design Data: Data Book of Engineers by PSG Col...    ₹462.00   \n",
       "19  Simplifying Data Engineering and Analytics wit...  ₹2,957.00   \n",
       "20  The Data WarehouseETL Toolkit: Practical Techn...              \n",
       "21                           Introducing Data Science    ₹690.00   \n",
       "\n",
       "                rating        reviews          availability   \n",
       "0   4.4 out of 5 stars  2,366 ratings              In stock  \\\n",
       "1   4.6 out of 5 stars     64 ratings         Not Available   \n",
       "2   4.7 out of 5 stars    209 ratings              In stock   \n",
       "3   4.2 out of 5 stars    103 ratings              In stock   \n",
       "4        Previous page                 Only 2 left in stock   \n",
       "5        Previous page                             In stock   \n",
       "6   4.4 out of 5 stars     62 ratings              In stock   \n",
       "7   3.2 out of 5 stars     10 ratings         Not Available   \n",
       "8   3.9 out of 5 stars     50 ratings         Not Available   \n",
       "9   3.8 out of 5 stars     13 ratings              In stock   \n",
       "10  4.3 out of 5 stars    713 ratings              In stock   \n",
       "11  4.3 out of 5 stars  1,103 ratings              In stock   \n",
       "12  3.9 out of 5 stars     20 ratings         Not Available   \n",
       "13  4.9 out of 5 stars     29 ratings         Not Available   \n",
       "14  4.8 out of 5 stars     10 ratings              In stock   \n",
       "15  4.4 out of 5 stars    924 ratings              In stock   \n",
       "16  4.2 out of 5 stars     13 ratings              In stock   \n",
       "17  5.0 out of 5 stars       1 rating              In stock   \n",
       "18  4.2 out of 5 stars    578 ratings              In stock   \n",
       "19  4.3 out of 5 stars      7 ratings              In stock   \n",
       "20  4.5 out of 5 stars    162 ratings         Not Available   \n",
       "21  4.4 out of 5 stars     97 ratings  Only 1 left in stock   \n",
       "\n",
       "                                              authors  \n",
       "0                              [Narasimha Karumanchi]  \n",
       "1                         [Ralph Kimball, Margy Ross]  \n",
       "2                            [Joe Reis, Matt Housley]  \n",
       "3                                     [Paul Crickard]  \n",
       "4              [Raghunathan Rengaswamy, Resmi Suresh]  \n",
       "5               [Coimbtore PSG College of Technology]  \n",
       "6                                      [Gareth Eagar]  \n",
       "7                                       [Ahmad Osama]  \n",
       "8                    [Manoj Kukreja, Danil Zburivsky]  \n",
       "9                                           [VK Jain]  \n",
       "10                             [Narasimha Karumanchi]  \n",
       "11                             [Narasimha Karumanchi]  \n",
       "12                                      [Newton Alex]  \n",
       "13                                    [Brian  Murray]  \n",
       "14                                       [Adi Wijaya]  \n",
       "15                                        [Mahadevan]  \n",
       "16           [Dr J.R. Calvert, Professor R.A. Farrar]  \n",
       "17  [Dr. Harshali Patil, Mr. Loukik S. Salvi, Purv...  \n",
       "18                                    [Coimbtore PSG]  \n",
       "19                     [Anindita Mahapatra, Doug May]  \n",
       "20                       [Ralph Kimball, Joe Caserta]  \n",
       "21      [Davy Cielen, Arno D.B. Meysman, Mohamed Ali]  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon_df"
   ]
  },
  {
   "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>title</th>\n",
       "      <th>price</th>\n",
       "      <th>rating</th>\n",
       "      <th>reviews</th>\n",
       "      <th>availability</th>\n",
       "      <th>authors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique</th>\n",
       "      <td>22</td>\n",
       "      <td>15</td>\n",
       "      <td>13</td>\n",
       "      <td>19</td>\n",
       "      <td>4</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>top</th>\n",
       "      <td>Data Structures and Algorithms Made Easy</td>\n",
       "      <td></td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td></td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Narasimha Karumanchi]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>freq</th>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>14</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           title price              rating   \n",
       "count                                         22    22                  22  \\\n",
       "unique                                        22    15                  13   \n",
       "top     Data Structures and Algorithms Made Easy        4.4 out of 5 stars   \n",
       "freq                                           1     6                   4   \n",
       "\n",
       "       reviews availability                 authors  \n",
       "count       22           22                      22  \n",
       "unique      19            4                      20  \n",
       "top                In stock  [Narasimha Karumanchi]  \n",
       "freq         2           14                       3  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon_df.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 22 entries, 0 to 21\n",
      "Data columns (total 6 columns):\n",
      " #   Column        Non-Null Count  Dtype \n",
      "---  ------        --------------  ----- \n",
      " 0   title         22 non-null     object\n",
      " 1   price         22 non-null     object\n",
      " 2   rating        22 non-null     object\n",
      " 3   reviews       22 non-null     object\n",
      " 4   availability  22 non-null     object\n",
      " 5   authors       22 non-null     object\n",
      "dtypes: object(6)\n",
      "memory usage: 1.2+ KB\n"
     ]
    }
   ],
   "source": [
    "amazon_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Define a transformation function to extract the numerical rating\n",
    "def transform_rating(rating_str):\n",
    "    try:\n",
    "        rating = rating_str.split()[0]\n",
    "        return float(rating)\n",
    "    except:\n",
    "        return None"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "amazon_df['ratings_out_of_5Stars'] = amazon_df['rating'].str.strip().apply(transform_rating)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>title</th>\n",
       "      <th>price</th>\n",
       "      <th>rating</th>\n",
       "      <th>reviews</th>\n",
       "      <th>availability</th>\n",
       "      <th>authors</th>\n",
       "      <th>ratings_out_of_5Stars</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Data Structures and Algorithms Made Easy</td>\n",
       "      <td>₹582.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>2,366 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Narasimha Karumanchi]</td>\n",
       "      <td>4.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Kimball Group Reader: Relentlessly Practic...</td>\n",
       "      <td></td>\n",
       "      <td>4.6 out of 5 stars</td>\n",
       "      <td>64 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Ralph Kimball, Margy Ross]</td>\n",
       "      <td>4.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Fundamentals of Data Engineering: Plan and Bui...</td>\n",
       "      <td>₹1,750.00</td>\n",
       "      <td>4.7 out of 5 stars</td>\n",
       "      <td>209 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Joe Reis, Matt Housley]</td>\n",
       "      <td>4.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Data Engineering with Python: Work with massiv...</td>\n",
       "      <td>₹2,788.00</td>\n",
       "      <td>4.2 out of 5 stars</td>\n",
       "      <td>103 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Paul Crickard]</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Data Science for Engineers</td>\n",
       "      <td>₹2,610.00</td>\n",
       "      <td>Previous page</td>\n",
       "      <td></td>\n",
       "      <td>Only 2 left in stock</td>\n",
       "      <td>[Raghunathan Rengaswamy, Resmi Suresh]</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>PSG Design Data Handbook - Data Book of Engine...</td>\n",
       "      <td>₹465.00</td>\n",
       "      <td>Previous page</td>\n",
       "      <td></td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Coimbtore PSG College of Technology]</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Data Engineering with AWS: Learn how to design...</td>\n",
       "      <td>₹3,126.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>62 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Gareth Eagar]</td>\n",
       "      <td>4.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Azure Data Engineering Cookbook: Design and im...</td>\n",
       "      <td></td>\n",
       "      <td>3.2 out of 5 stars</td>\n",
       "      <td>10 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Ahmad Osama]</td>\n",
       "      <td>3.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Data Engineering with Apache Spark, Delta Lake...</td>\n",
       "      <td></td>\n",
       "      <td>3.9 out of 5 stars</td>\n",
       "      <td>50 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Manoj Kukreja, Danil Zburivsky]</td>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Data Science &amp; Analytics</td>\n",
       "      <td>₹280.00</td>\n",
       "      <td>3.8 out of 5 stars</td>\n",
       "      <td>13 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[VK Jain]</td>\n",
       "      <td>3.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Data Structure and Algorithmic Thinking with P...</td>\n",
       "      <td>₹582.00</td>\n",
       "      <td>4.3 out of 5 stars</td>\n",
       "      <td>713 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Narasimha Karumanchi]</td>\n",
       "      <td>4.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Data Structures and Algorithms Made Easy in Java</td>\n",
       "      <td>₹582.00</td>\n",
       "      <td>4.3 out of 5 stars</td>\n",
       "      <td>1,103 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Narasimha Karumanchi]</td>\n",
       "      <td>4.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Azure Data Engineer Associate Certification Gu...</td>\n",
       "      <td></td>\n",
       "      <td>3.9 out of 5 stars</td>\n",
       "      <td>20 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Newton Alex]</td>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Fundamentals of Data Engineering: Designing an...</td>\n",
       "      <td></td>\n",
       "      <td>4.9 out of 5 stars</td>\n",
       "      <td>29 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Brian  Murray]</td>\n",
       "      <td>4.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Data Engineering with Google Cloud Platform: A...</td>\n",
       "      <td>₹3,464.00</td>\n",
       "      <td>4.8 out of 5 stars</td>\n",
       "      <td>10 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Adi Wijaya]</td>\n",
       "      <td>4.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Design Data Handbook For Mechanical Engineers ...</td>\n",
       "      <td>₹383.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>924 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Mahadevan]</td>\n",
       "      <td>4.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>An Engineering Data Book</td>\n",
       "      <td>₹3,702.00</td>\n",
       "      <td>4.2 out of 5 stars</td>\n",
       "      <td>13 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Dr J.R. Calvert, Professor R.A. Farrar]</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Applied Data Science For Mumbai University B.E...</td>\n",
       "      <td>₹252.00</td>\n",
       "      <td>5.0 out of 5 stars</td>\n",
       "      <td>1 rating</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Dr. Harshali Patil, Mr. Loukik S. Salvi, Purv...</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Design Data: Data Book of Engineers by PSG Col...</td>\n",
       "      <td>₹462.00</td>\n",
       "      <td>4.2 out of 5 stars</td>\n",
       "      <td>578 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Coimbtore PSG]</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Simplifying Data Engineering and Analytics wit...</td>\n",
       "      <td>₹2,957.00</td>\n",
       "      <td>4.3 out of 5 stars</td>\n",
       "      <td>7 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Anindita Mahapatra, Doug May]</td>\n",
       "      <td>4.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>The Data WarehouseETL Toolkit: Practical Techn...</td>\n",
       "      <td></td>\n",
       "      <td>4.5 out of 5 stars</td>\n",
       "      <td>162 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Ralph Kimball, Joe Caserta]</td>\n",
       "      <td>4.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Introducing Data Science</td>\n",
       "      <td>₹690.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>97 ratings</td>\n",
       "      <td>Only 1 left in stock</td>\n",
       "      <td>[Davy Cielen, Arno D.B. Meysman, Mohamed Ali]</td>\n",
       "      <td>4.4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                title      price   \n",
       "0            Data Structures and Algorithms Made Easy    ₹582.00  \\\n",
       "1   The Kimball Group Reader: Relentlessly Practic...              \n",
       "2   Fundamentals of Data Engineering: Plan and Bui...  ₹1,750.00   \n",
       "3   Data Engineering with Python: Work with massiv...  ₹2,788.00   \n",
       "4                          Data Science for Engineers  ₹2,610.00   \n",
       "5   PSG Design Data Handbook - Data Book of Engine...    ₹465.00   \n",
       "6   Data Engineering with AWS: Learn how to design...  ₹3,126.00   \n",
       "7   Azure Data Engineering Cookbook: Design and im...              \n",
       "8   Data Engineering with Apache Spark, Delta Lake...              \n",
       "9                            Data Science & Analytics    ₹280.00   \n",
       "10  Data Structure and Algorithmic Thinking with P...    ₹582.00   \n",
       "11   Data Structures and Algorithms Made Easy in Java    ₹582.00   \n",
       "12  Azure Data Engineer Associate Certification Gu...              \n",
       "13  Fundamentals of Data Engineering: Designing an...              \n",
       "14  Data Engineering with Google Cloud Platform: A...  ₹3,464.00   \n",
       "15  Design Data Handbook For Mechanical Engineers ...    ₹383.00   \n",
       "16                           An Engineering Data Book  ₹3,702.00   \n",
       "17  Applied Data Science For Mumbai University B.E...    ₹252.00   \n",
       "18  Design Data: Data Book of Engineers by PSG Col...    ₹462.00   \n",
       "19  Simplifying Data Engineering and Analytics wit...  ₹2,957.00   \n",
       "20  The Data WarehouseETL Toolkit: Practical Techn...              \n",
       "21                           Introducing Data Science    ₹690.00   \n",
       "\n",
       "                rating        reviews          availability   \n",
       "0   4.4 out of 5 stars  2,366 ratings              In stock  \\\n",
       "1   4.6 out of 5 stars     64 ratings         Not Available   \n",
       "2   4.7 out of 5 stars    209 ratings              In stock   \n",
       "3   4.2 out of 5 stars    103 ratings              In stock   \n",
       "4        Previous page                 Only 2 left in stock   \n",
       "5        Previous page                             In stock   \n",
       "6   4.4 out of 5 stars     62 ratings              In stock   \n",
       "7   3.2 out of 5 stars     10 ratings         Not Available   \n",
       "8   3.9 out of 5 stars     50 ratings         Not Available   \n",
       "9   3.8 out of 5 stars     13 ratings              In stock   \n",
       "10  4.3 out of 5 stars    713 ratings              In stock   \n",
       "11  4.3 out of 5 stars  1,103 ratings              In stock   \n",
       "12  3.9 out of 5 stars     20 ratings         Not Available   \n",
       "13  4.9 out of 5 stars     29 ratings         Not Available   \n",
       "14  4.8 out of 5 stars     10 ratings              In stock   \n",
       "15  4.4 out of 5 stars    924 ratings              In stock   \n",
       "16  4.2 out of 5 stars     13 ratings              In stock   \n",
       "17  5.0 out of 5 stars       1 rating              In stock   \n",
       "18  4.2 out of 5 stars    578 ratings              In stock   \n",
       "19  4.3 out of 5 stars      7 ratings              In stock   \n",
       "20  4.5 out of 5 stars    162 ratings         Not Available   \n",
       "21  4.4 out of 5 stars     97 ratings  Only 1 left in stock   \n",
       "\n",
       "                                              authors  ratings_out_of_5Stars  \n",
       "0                              [Narasimha Karumanchi]                    4.4  \n",
       "1                         [Ralph Kimball, Margy Ross]                    4.6  \n",
       "2                            [Joe Reis, Matt Housley]                    4.7  \n",
       "3                                     [Paul Crickard]                    4.2  \n",
       "4              [Raghunathan Rengaswamy, Resmi Suresh]                    NaN  \n",
       "5               [Coimbtore PSG College of Technology]                    NaN  \n",
       "6                                      [Gareth Eagar]                    4.4  \n",
       "7                                       [Ahmad Osama]                    3.2  \n",
       "8                    [Manoj Kukreja, Danil Zburivsky]                    3.9  \n",
       "9                                           [VK Jain]                    3.8  \n",
       "10                             [Narasimha Karumanchi]                    4.3  \n",
       "11                             [Narasimha Karumanchi]                    4.3  \n",
       "12                                      [Newton Alex]                    3.9  \n",
       "13                                    [Brian  Murray]                    4.9  \n",
       "14                                       [Adi Wijaya]                    4.8  \n",
       "15                                        [Mahadevan]                    4.4  \n",
       "16           [Dr J.R. Calvert, Professor R.A. Farrar]                    4.2  \n",
       "17  [Dr. Harshali Patil, Mr. Loukik S. Salvi, Purv...                    5.0  \n",
       "18                                    [Coimbtore PSG]                    4.2  \n",
       "19                     [Anindita Mahapatra, Doug May]                    4.3  \n",
       "20                       [Ralph Kimball, Joe Caserta]                    4.5  \n",
       "21      [Davy Cielen, Arno D.B. Meysman, Mohamed Ali]                    4.4  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "def num_of_reviews(review_str):\n",
    "    try:\n",
    "        review_count = review_str.split()[0].replace(',','')\n",
    "        return int(review_count)\n",
    "    except:\n",
    "        return None"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "amazon_df['reviews_count'] = amazon_df['reviews'].str.strip().apply(num_of_reviews)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>title</th>\n",
       "      <th>price</th>\n",
       "      <th>rating</th>\n",
       "      <th>reviews</th>\n",
       "      <th>availability</th>\n",
       "      <th>authors</th>\n",
       "      <th>ratings_out_of_5Stars</th>\n",
       "      <th>reviews_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Data Structures and Algorithms Made Easy</td>\n",
       "      <td>₹582.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>2,366 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Narasimha Karumanchi]</td>\n",
       "      <td>4.4</td>\n",
       "      <td>2366.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Kimball Group Reader: Relentlessly Practic...</td>\n",
       "      <td></td>\n",
       "      <td>4.6 out of 5 stars</td>\n",
       "      <td>64 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Ralph Kimball, Margy Ross]</td>\n",
       "      <td>4.6</td>\n",
       "      <td>64.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Fundamentals of Data Engineering: Plan and Bui...</td>\n",
       "      <td>₹1,750.00</td>\n",
       "      <td>4.7 out of 5 stars</td>\n",
       "      <td>209 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Joe Reis, Matt Housley]</td>\n",
       "      <td>4.7</td>\n",
       "      <td>209.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Data Engineering with Python: Work with massiv...</td>\n",
       "      <td>₹2,788.00</td>\n",
       "      <td>4.2 out of 5 stars</td>\n",
       "      <td>103 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Paul Crickard]</td>\n",
       "      <td>4.2</td>\n",
       "      <td>103.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Data Science for Engineers</td>\n",
       "      <td>₹2,610.00</td>\n",
       "      <td>Previous page</td>\n",
       "      <td></td>\n",
       "      <td>Only 2 left in stock</td>\n",
       "      <td>[Raghunathan Rengaswamy, Resmi Suresh]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>PSG Design Data Handbook - Data Book of Engine...</td>\n",
       "      <td>₹465.00</td>\n",
       "      <td>Previous page</td>\n",
       "      <td></td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Coimbtore PSG College of Technology]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Data Engineering with AWS: Learn how to design...</td>\n",
       "      <td>₹3,126.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>62 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Gareth Eagar]</td>\n",
       "      <td>4.4</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Azure Data Engineering Cookbook: Design and im...</td>\n",
       "      <td></td>\n",
       "      <td>3.2 out of 5 stars</td>\n",
       "      <td>10 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Ahmad Osama]</td>\n",
       "      <td>3.2</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Data Engineering with Apache Spark, Delta Lake...</td>\n",
       "      <td></td>\n",
       "      <td>3.9 out of 5 stars</td>\n",
       "      <td>50 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Manoj Kukreja, Danil Zburivsky]</td>\n",
       "      <td>3.9</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Data Science &amp; Analytics</td>\n",
       "      <td>₹280.00</td>\n",
       "      <td>3.8 out of 5 stars</td>\n",
       "      <td>13 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[VK Jain]</td>\n",
       "      <td>3.8</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Data Structure and Algorithmic Thinking with P...</td>\n",
       "      <td>₹582.00</td>\n",
       "      <td>4.3 out of 5 stars</td>\n",
       "      <td>713 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Narasimha Karumanchi]</td>\n",
       "      <td>4.3</td>\n",
       "      <td>713.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Data Structures and Algorithms Made Easy in Java</td>\n",
       "      <td>₹582.00</td>\n",
       "      <td>4.3 out of 5 stars</td>\n",
       "      <td>1,103 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Narasimha Karumanchi]</td>\n",
       "      <td>4.3</td>\n",
       "      <td>1103.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Azure Data Engineer Associate Certification Gu...</td>\n",
       "      <td></td>\n",
       "      <td>3.9 out of 5 stars</td>\n",
       "      <td>20 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Newton Alex]</td>\n",
       "      <td>3.9</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Fundamentals of Data Engineering: Designing an...</td>\n",
       "      <td></td>\n",
       "      <td>4.9 out of 5 stars</td>\n",
       "      <td>29 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Brian  Murray]</td>\n",
       "      <td>4.9</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Data Engineering with Google Cloud Platform: A...</td>\n",
       "      <td>₹3,464.00</td>\n",
       "      <td>4.8 out of 5 stars</td>\n",
       "      <td>10 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Adi Wijaya]</td>\n",
       "      <td>4.8</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Design Data Handbook For Mechanical Engineers ...</td>\n",
       "      <td>₹383.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>924 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Mahadevan]</td>\n",
       "      <td>4.4</td>\n",
       "      <td>924.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>An Engineering Data Book</td>\n",
       "      <td>₹3,702.00</td>\n",
       "      <td>4.2 out of 5 stars</td>\n",
       "      <td>13 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Dr J.R. Calvert, Professor R.A. Farrar]</td>\n",
       "      <td>4.2</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Applied Data Science For Mumbai University B.E...</td>\n",
       "      <td>₹252.00</td>\n",
       "      <td>5.0 out of 5 stars</td>\n",
       "      <td>1 rating</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Dr. Harshali Patil, Mr. Loukik S. Salvi, Purv...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Design Data: Data Book of Engineers by PSG Col...</td>\n",
       "      <td>₹462.00</td>\n",
       "      <td>4.2 out of 5 stars</td>\n",
       "      <td>578 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Coimbtore PSG]</td>\n",
       "      <td>4.2</td>\n",
       "      <td>578.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Simplifying Data Engineering and Analytics wit...</td>\n",
       "      <td>₹2,957.00</td>\n",
       "      <td>4.3 out of 5 stars</td>\n",
       "      <td>7 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Anindita Mahapatra, Doug May]</td>\n",
       "      <td>4.3</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>The Data WarehouseETL Toolkit: Practical Techn...</td>\n",
       "      <td></td>\n",
       "      <td>4.5 out of 5 stars</td>\n",
       "      <td>162 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Ralph Kimball, Joe Caserta]</td>\n",
       "      <td>4.5</td>\n",
       "      <td>162.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Introducing Data Science</td>\n",
       "      <td>₹690.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>97 ratings</td>\n",
       "      <td>Only 1 left in stock</td>\n",
       "      <td>[Davy Cielen, Arno D.B. Meysman, Mohamed Ali]</td>\n",
       "      <td>4.4</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                title      price   \n",
       "0            Data Structures and Algorithms Made Easy    ₹582.00  \\\n",
       "1   The Kimball Group Reader: Relentlessly Practic...              \n",
       "2   Fundamentals of Data Engineering: Plan and Bui...  ₹1,750.00   \n",
       "3   Data Engineering with Python: Work with massiv...  ₹2,788.00   \n",
       "4                          Data Science for Engineers  ₹2,610.00   \n",
       "5   PSG Design Data Handbook - Data Book of Engine...    ₹465.00   \n",
       "6   Data Engineering with AWS: Learn how to design...  ₹3,126.00   \n",
       "7   Azure Data Engineering Cookbook: Design and im...              \n",
       "8   Data Engineering with Apache Spark, Delta Lake...              \n",
       "9                            Data Science & Analytics    ₹280.00   \n",
       "10  Data Structure and Algorithmic Thinking with P...    ₹582.00   \n",
       "11   Data Structures and Algorithms Made Easy in Java    ₹582.00   \n",
       "12  Azure Data Engineer Associate Certification Gu...              \n",
       "13  Fundamentals of Data Engineering: Designing an...              \n",
       "14  Data Engineering with Google Cloud Platform: A...  ₹3,464.00   \n",
       "15  Design Data Handbook For Mechanical Engineers ...    ₹383.00   \n",
       "16                           An Engineering Data Book  ₹3,702.00   \n",
       "17  Applied Data Science For Mumbai University B.E...    ₹252.00   \n",
       "18  Design Data: Data Book of Engineers by PSG Col...    ₹462.00   \n",
       "19  Simplifying Data Engineering and Analytics wit...  ₹2,957.00   \n",
       "20  The Data WarehouseETL Toolkit: Practical Techn...              \n",
       "21                           Introducing Data Science    ₹690.00   \n",
       "\n",
       "                rating        reviews          availability   \n",
       "0   4.4 out of 5 stars  2,366 ratings              In stock  \\\n",
       "1   4.6 out of 5 stars     64 ratings         Not Available   \n",
       "2   4.7 out of 5 stars    209 ratings              In stock   \n",
       "3   4.2 out of 5 stars    103 ratings              In stock   \n",
       "4        Previous page                 Only 2 left in stock   \n",
       "5        Previous page                             In stock   \n",
       "6   4.4 out of 5 stars     62 ratings              In stock   \n",
       "7   3.2 out of 5 stars     10 ratings         Not Available   \n",
       "8   3.9 out of 5 stars     50 ratings         Not Available   \n",
       "9   3.8 out of 5 stars     13 ratings              In stock   \n",
       "10  4.3 out of 5 stars    713 ratings              In stock   \n",
       "11  4.3 out of 5 stars  1,103 ratings              In stock   \n",
       "12  3.9 out of 5 stars     20 ratings         Not Available   \n",
       "13  4.9 out of 5 stars     29 ratings         Not Available   \n",
       "14  4.8 out of 5 stars     10 ratings              In stock   \n",
       "15  4.4 out of 5 stars    924 ratings              In stock   \n",
       "16  4.2 out of 5 stars     13 ratings              In stock   \n",
       "17  5.0 out of 5 stars       1 rating              In stock   \n",
       "18  4.2 out of 5 stars    578 ratings              In stock   \n",
       "19  4.3 out of 5 stars      7 ratings              In stock   \n",
       "20  4.5 out of 5 stars    162 ratings         Not Available   \n",
       "21  4.4 out of 5 stars     97 ratings  Only 1 left in stock   \n",
       "\n",
       "                                              authors  ratings_out_of_5Stars   \n",
       "0                              [Narasimha Karumanchi]                    4.4  \\\n",
       "1                         [Ralph Kimball, Margy Ross]                    4.6   \n",
       "2                            [Joe Reis, Matt Housley]                    4.7   \n",
       "3                                     [Paul Crickard]                    4.2   \n",
       "4              [Raghunathan Rengaswamy, Resmi Suresh]                    NaN   \n",
       "5               [Coimbtore PSG College of Technology]                    NaN   \n",
       "6                                      [Gareth Eagar]                    4.4   \n",
       "7                                       [Ahmad Osama]                    3.2   \n",
       "8                    [Manoj Kukreja, Danil Zburivsky]                    3.9   \n",
       "9                                           [VK Jain]                    3.8   \n",
       "10                             [Narasimha Karumanchi]                    4.3   \n",
       "11                             [Narasimha Karumanchi]                    4.3   \n",
       "12                                      [Newton Alex]                    3.9   \n",
       "13                                    [Brian  Murray]                    4.9   \n",
       "14                                       [Adi Wijaya]                    4.8   \n",
       "15                                        [Mahadevan]                    4.4   \n",
       "16           [Dr J.R. Calvert, Professor R.A. Farrar]                    4.2   \n",
       "17  [Dr. Harshali Patil, Mr. Loukik S. Salvi, Purv...                    5.0   \n",
       "18                                    [Coimbtore PSG]                    4.2   \n",
       "19                     [Anindita Mahapatra, Doug May]                    4.3   \n",
       "20                       [Ralph Kimball, Joe Caserta]                    4.5   \n",
       "21      [Davy Cielen, Arno D.B. Meysman, Mohamed Ali]                    4.4   \n",
       "\n",
       "    reviews_count  \n",
       "0          2366.0  \n",
       "1            64.0  \n",
       "2           209.0  \n",
       "3           103.0  \n",
       "4             NaN  \n",
       "5             NaN  \n",
       "6            62.0  \n",
       "7            10.0  \n",
       "8            50.0  \n",
       "9            13.0  \n",
       "10          713.0  \n",
       "11         1103.0  \n",
       "12           20.0  \n",
       "13           29.0  \n",
       "14           10.0  \n",
       "15          924.0  \n",
       "16           13.0  \n",
       "17            1.0  \n",
       "18          578.0  \n",
       "19            7.0  \n",
       "20          162.0  \n",
       "21           97.0  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "def ratio(num1, num2):\n",
    "    try:\n",
    "        ratio = num1/num2\n",
    "        return round(float(ratio),2)\n",
    "    except:\n",
    "        return None"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "amazon_df['Comparison'] = ratio((amazon_df['ratings_out_of_5Stars']*amazon_df['reviews_count']),(5 * amazon_df['reviews_count']))"
   ]
  },
  {
   "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>title</th>\n",
       "      <th>price</th>\n",
       "      <th>rating</th>\n",
       "      <th>reviews</th>\n",
       "      <th>availability</th>\n",
       "      <th>authors</th>\n",
       "      <th>ratings_out_of_5Stars</th>\n",
       "      <th>reviews_count</th>\n",
       "      <th>Comparison</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Data Structures and Algorithms Made Easy</td>\n",
       "      <td>₹582.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>2,366 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Narasimha Karumanchi]</td>\n",
       "      <td>4.4</td>\n",
       "      <td>2366.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Kimball Group Reader: Relentlessly Practic...</td>\n",
       "      <td></td>\n",
       "      <td>4.6 out of 5 stars</td>\n",
       "      <td>64 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Ralph Kimball, Margy Ross]</td>\n",
       "      <td>4.6</td>\n",
       "      <td>64.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Fundamentals of Data Engineering: Plan and Bui...</td>\n",
       "      <td>₹1,750.00</td>\n",
       "      <td>4.7 out of 5 stars</td>\n",
       "      <td>209 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Joe Reis, Matt Housley]</td>\n",
       "      <td>4.7</td>\n",
       "      <td>209.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Data Engineering with Python: Work with massiv...</td>\n",
       "      <td>₹2,788.00</td>\n",
       "      <td>4.2 out of 5 stars</td>\n",
       "      <td>103 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Paul Crickard]</td>\n",
       "      <td>4.2</td>\n",
       "      <td>103.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Data Science for Engineers</td>\n",
       "      <td>₹2,610.00</td>\n",
       "      <td>Previous page</td>\n",
       "      <td></td>\n",
       "      <td>Only 2 left in stock</td>\n",
       "      <td>[Raghunathan Rengaswamy, Resmi Suresh]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>PSG Design Data Handbook - Data Book of Engine...</td>\n",
       "      <td>₹465.00</td>\n",
       "      <td>Previous page</td>\n",
       "      <td></td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Coimbtore PSG College of Technology]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Data Engineering with AWS: Learn how to design...</td>\n",
       "      <td>₹3,126.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>62 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Gareth Eagar]</td>\n",
       "      <td>4.4</td>\n",
       "      <td>62.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Azure Data Engineering Cookbook: Design and im...</td>\n",
       "      <td></td>\n",
       "      <td>3.2 out of 5 stars</td>\n",
       "      <td>10 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Ahmad Osama]</td>\n",
       "      <td>3.2</td>\n",
       "      <td>10.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Data Engineering with Apache Spark, Delta Lake...</td>\n",
       "      <td></td>\n",
       "      <td>3.9 out of 5 stars</td>\n",
       "      <td>50 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Manoj Kukreja, Danil Zburivsky]</td>\n",
       "      <td>3.9</td>\n",
       "      <td>50.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Data Science &amp; Analytics</td>\n",
       "      <td>₹280.00</td>\n",
       "      <td>3.8 out of 5 stars</td>\n",
       "      <td>13 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[VK Jain]</td>\n",
       "      <td>3.8</td>\n",
       "      <td>13.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Data Structure and Algorithmic Thinking with P...</td>\n",
       "      <td>₹582.00</td>\n",
       "      <td>4.3 out of 5 stars</td>\n",
       "      <td>713 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Narasimha Karumanchi]</td>\n",
       "      <td>4.3</td>\n",
       "      <td>713.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Data Structures and Algorithms Made Easy in Java</td>\n",
       "      <td>₹582.00</td>\n",
       "      <td>4.3 out of 5 stars</td>\n",
       "      <td>1,103 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Narasimha Karumanchi]</td>\n",
       "      <td>4.3</td>\n",
       "      <td>1103.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Azure Data Engineer Associate Certification Gu...</td>\n",
       "      <td></td>\n",
       "      <td>3.9 out of 5 stars</td>\n",
       "      <td>20 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Newton Alex]</td>\n",
       "      <td>3.9</td>\n",
       "      <td>20.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Fundamentals of Data Engineering: Designing an...</td>\n",
       "      <td></td>\n",
       "      <td>4.9 out of 5 stars</td>\n",
       "      <td>29 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Brian  Murray]</td>\n",
       "      <td>4.9</td>\n",
       "      <td>29.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Data Engineering with Google Cloud Platform: A...</td>\n",
       "      <td>₹3,464.00</td>\n",
       "      <td>4.8 out of 5 stars</td>\n",
       "      <td>10 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Adi Wijaya]</td>\n",
       "      <td>4.8</td>\n",
       "      <td>10.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Design Data Handbook For Mechanical Engineers ...</td>\n",
       "      <td>₹383.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>924 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Mahadevan]</td>\n",
       "      <td>4.4</td>\n",
       "      <td>924.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>An Engineering Data Book</td>\n",
       "      <td>₹3,702.00</td>\n",
       "      <td>4.2 out of 5 stars</td>\n",
       "      <td>13 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Dr J.R. Calvert, Professor R.A. Farrar]</td>\n",
       "      <td>4.2</td>\n",
       "      <td>13.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Applied Data Science For Mumbai University B.E...</td>\n",
       "      <td>₹252.00</td>\n",
       "      <td>5.0 out of 5 stars</td>\n",
       "      <td>1 rating</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Dr. Harshali Patil, Mr. Loukik S. Salvi, Purv...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Design Data: Data Book of Engineers by PSG Col...</td>\n",
       "      <td>₹462.00</td>\n",
       "      <td>4.2 out of 5 stars</td>\n",
       "      <td>578 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Coimbtore PSG]</td>\n",
       "      <td>4.2</td>\n",
       "      <td>578.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Simplifying Data Engineering and Analytics wit...</td>\n",
       "      <td>₹2,957.00</td>\n",
       "      <td>4.3 out of 5 stars</td>\n",
       "      <td>7 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Anindita Mahapatra, Doug May]</td>\n",
       "      <td>4.3</td>\n",
       "      <td>7.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>The Data WarehouseETL Toolkit: Practical Techn...</td>\n",
       "      <td></td>\n",
       "      <td>4.5 out of 5 stars</td>\n",
       "      <td>162 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Ralph Kimball, Joe Caserta]</td>\n",
       "      <td>4.5</td>\n",
       "      <td>162.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Introducing Data Science</td>\n",
       "      <td>₹690.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>97 ratings</td>\n",
       "      <td>Only 1 left in stock</td>\n",
       "      <td>[Davy Cielen, Arno D.B. Meysman, Mohamed Ali]</td>\n",
       "      <td>4.4</td>\n",
       "      <td>97.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                title      price   \n",
       "0            Data Structures and Algorithms Made Easy    ₹582.00  \\\n",
       "1   The Kimball Group Reader: Relentlessly Practic...              \n",
       "2   Fundamentals of Data Engineering: Plan and Bui...  ₹1,750.00   \n",
       "3   Data Engineering with Python: Work with massiv...  ₹2,788.00   \n",
       "4                          Data Science for Engineers  ₹2,610.00   \n",
       "5   PSG Design Data Handbook - Data Book of Engine...    ₹465.00   \n",
       "6   Data Engineering with AWS: Learn how to design...  ₹3,126.00   \n",
       "7   Azure Data Engineering Cookbook: Design and im...              \n",
       "8   Data Engineering with Apache Spark, Delta Lake...              \n",
       "9                            Data Science & Analytics    ₹280.00   \n",
       "10  Data Structure and Algorithmic Thinking with P...    ₹582.00   \n",
       "11   Data Structures and Algorithms Made Easy in Java    ₹582.00   \n",
       "12  Azure Data Engineer Associate Certification Gu...              \n",
       "13  Fundamentals of Data Engineering: Designing an...              \n",
       "14  Data Engineering with Google Cloud Platform: A...  ₹3,464.00   \n",
       "15  Design Data Handbook For Mechanical Engineers ...    ₹383.00   \n",
       "16                           An Engineering Data Book  ₹3,702.00   \n",
       "17  Applied Data Science For Mumbai University B.E...    ₹252.00   \n",
       "18  Design Data: Data Book of Engineers by PSG Col...    ₹462.00   \n",
       "19  Simplifying Data Engineering and Analytics wit...  ₹2,957.00   \n",
       "20  The Data WarehouseETL Toolkit: Practical Techn...              \n",
       "21                           Introducing Data Science    ₹690.00   \n",
       "\n",
       "                rating        reviews          availability   \n",
       "0   4.4 out of 5 stars  2,366 ratings              In stock  \\\n",
       "1   4.6 out of 5 stars     64 ratings         Not Available   \n",
       "2   4.7 out of 5 stars    209 ratings              In stock   \n",
       "3   4.2 out of 5 stars    103 ratings              In stock   \n",
       "4        Previous page                 Only 2 left in stock   \n",
       "5        Previous page                             In stock   \n",
       "6   4.4 out of 5 stars     62 ratings              In stock   \n",
       "7   3.2 out of 5 stars     10 ratings         Not Available   \n",
       "8   3.9 out of 5 stars     50 ratings         Not Available   \n",
       "9   3.8 out of 5 stars     13 ratings              In stock   \n",
       "10  4.3 out of 5 stars    713 ratings              In stock   \n",
       "11  4.3 out of 5 stars  1,103 ratings              In stock   \n",
       "12  3.9 out of 5 stars     20 ratings         Not Available   \n",
       "13  4.9 out of 5 stars     29 ratings         Not Available   \n",
       "14  4.8 out of 5 stars     10 ratings              In stock   \n",
       "15  4.4 out of 5 stars    924 ratings              In stock   \n",
       "16  4.2 out of 5 stars     13 ratings              In stock   \n",
       "17  5.0 out of 5 stars       1 rating              In stock   \n",
       "18  4.2 out of 5 stars    578 ratings              In stock   \n",
       "19  4.3 out of 5 stars      7 ratings              In stock   \n",
       "20  4.5 out of 5 stars    162 ratings         Not Available   \n",
       "21  4.4 out of 5 stars     97 ratings  Only 1 left in stock   \n",
       "\n",
       "                                              authors  ratings_out_of_5Stars   \n",
       "0                              [Narasimha Karumanchi]                    4.4  \\\n",
       "1                         [Ralph Kimball, Margy Ross]                    4.6   \n",
       "2                            [Joe Reis, Matt Housley]                    4.7   \n",
       "3                                     [Paul Crickard]                    4.2   \n",
       "4              [Raghunathan Rengaswamy, Resmi Suresh]                    NaN   \n",
       "5               [Coimbtore PSG College of Technology]                    NaN   \n",
       "6                                      [Gareth Eagar]                    4.4   \n",
       "7                                       [Ahmad Osama]                    3.2   \n",
       "8                    [Manoj Kukreja, Danil Zburivsky]                    3.9   \n",
       "9                                           [VK Jain]                    3.8   \n",
       "10                             [Narasimha Karumanchi]                    4.3   \n",
       "11                             [Narasimha Karumanchi]                    4.3   \n",
       "12                                      [Newton Alex]                    3.9   \n",
       "13                                    [Brian  Murray]                    4.9   \n",
       "14                                       [Adi Wijaya]                    4.8   \n",
       "15                                        [Mahadevan]                    4.4   \n",
       "16           [Dr J.R. Calvert, Professor R.A. Farrar]                    4.2   \n",
       "17  [Dr. Harshali Patil, Mr. Loukik S. Salvi, Purv...                    5.0   \n",
       "18                                    [Coimbtore PSG]                    4.2   \n",
       "19                     [Anindita Mahapatra, Doug May]                    4.3   \n",
       "20                       [Ralph Kimball, Joe Caserta]                    4.5   \n",
       "21      [Davy Cielen, Arno D.B. Meysman, Mohamed Ali]                    4.4   \n",
       "\n",
       "    reviews_count Comparison  \n",
       "0          2366.0       None  \n",
       "1            64.0       None  \n",
       "2           209.0       None  \n",
       "3           103.0       None  \n",
       "4             NaN       None  \n",
       "5             NaN       None  \n",
       "6            62.0       None  \n",
       "7            10.0       None  \n",
       "8            50.0       None  \n",
       "9            13.0       None  \n",
       "10          713.0       None  \n",
       "11         1103.0       None  \n",
       "12           20.0       None  \n",
       "13           29.0       None  \n",
       "14           10.0       None  \n",
       "15          924.0       None  \n",
       "16           13.0       None  \n",
       "17            1.0       None  \n",
       "18          578.0       None  \n",
       "19            7.0       None  \n",
       "20          162.0       None  \n",
       "21           97.0       None  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "amazon_df = amazon_df.drop('Comparison', axis=1)"
   ]
  },
  {
   "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>title</th>\n",
       "      <th>price</th>\n",
       "      <th>rating</th>\n",
       "      <th>reviews</th>\n",
       "      <th>availability</th>\n",
       "      <th>authors</th>\n",
       "      <th>ratings_out_of_5Stars</th>\n",
       "      <th>reviews_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Data Structures and Algorithms Made Easy</td>\n",
       "      <td>₹582.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>2,366 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Narasimha Karumanchi]</td>\n",
       "      <td>4.4</td>\n",
       "      <td>2366.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Kimball Group Reader: Relentlessly Practic...</td>\n",
       "      <td></td>\n",
       "      <td>4.6 out of 5 stars</td>\n",
       "      <td>64 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Ralph Kimball, Margy Ross]</td>\n",
       "      <td>4.6</td>\n",
       "      <td>64.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Fundamentals of Data Engineering: Plan and Bui...</td>\n",
       "      <td>₹1,750.00</td>\n",
       "      <td>4.7 out of 5 stars</td>\n",
       "      <td>209 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Joe Reis, Matt Housley]</td>\n",
       "      <td>4.7</td>\n",
       "      <td>209.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Data Engineering with Python: Work with massiv...</td>\n",
       "      <td>₹2,788.00</td>\n",
       "      <td>4.2 out of 5 stars</td>\n",
       "      <td>103 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Paul Crickard]</td>\n",
       "      <td>4.2</td>\n",
       "      <td>103.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Data Science for Engineers</td>\n",
       "      <td>₹2,610.00</td>\n",
       "      <td>Previous page</td>\n",
       "      <td></td>\n",
       "      <td>Only 2 left in stock</td>\n",
       "      <td>[Raghunathan Rengaswamy, Resmi Suresh]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>PSG Design Data Handbook - Data Book of Engine...</td>\n",
       "      <td>₹465.00</td>\n",
       "      <td>Previous page</td>\n",
       "      <td></td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Coimbtore PSG College of Technology]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Data Engineering with AWS: Learn how to design...</td>\n",
       "      <td>₹3,126.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>62 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Gareth Eagar]</td>\n",
       "      <td>4.4</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Azure Data Engineering Cookbook: Design and im...</td>\n",
       "      <td></td>\n",
       "      <td>3.2 out of 5 stars</td>\n",
       "      <td>10 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Ahmad Osama]</td>\n",
       "      <td>3.2</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Data Engineering with Apache Spark, Delta Lake...</td>\n",
       "      <td></td>\n",
       "      <td>3.9 out of 5 stars</td>\n",
       "      <td>50 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Manoj Kukreja, Danil Zburivsky]</td>\n",
       "      <td>3.9</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Data Science &amp; Analytics</td>\n",
       "      <td>₹280.00</td>\n",
       "      <td>3.8 out of 5 stars</td>\n",
       "      <td>13 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[VK Jain]</td>\n",
       "      <td>3.8</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Data Structure and Algorithmic Thinking with P...</td>\n",
       "      <td>₹582.00</td>\n",
       "      <td>4.3 out of 5 stars</td>\n",
       "      <td>713 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Narasimha Karumanchi]</td>\n",
       "      <td>4.3</td>\n",
       "      <td>713.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Data Structures and Algorithms Made Easy in Java</td>\n",
       "      <td>₹582.00</td>\n",
       "      <td>4.3 out of 5 stars</td>\n",
       "      <td>1,103 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Narasimha Karumanchi]</td>\n",
       "      <td>4.3</td>\n",
       "      <td>1103.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Azure Data Engineer Associate Certification Gu...</td>\n",
       "      <td></td>\n",
       "      <td>3.9 out of 5 stars</td>\n",
       "      <td>20 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Newton Alex]</td>\n",
       "      <td>3.9</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Fundamentals of Data Engineering: Designing an...</td>\n",
       "      <td></td>\n",
       "      <td>4.9 out of 5 stars</td>\n",
       "      <td>29 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Brian  Murray]</td>\n",
       "      <td>4.9</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Data Engineering with Google Cloud Platform: A...</td>\n",
       "      <td>₹3,464.00</td>\n",
       "      <td>4.8 out of 5 stars</td>\n",
       "      <td>10 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Adi Wijaya]</td>\n",
       "      <td>4.8</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Design Data Handbook For Mechanical Engineers ...</td>\n",
       "      <td>₹383.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>924 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Mahadevan]</td>\n",
       "      <td>4.4</td>\n",
       "      <td>924.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>An Engineering Data Book</td>\n",
       "      <td>₹3,702.00</td>\n",
       "      <td>4.2 out of 5 stars</td>\n",
       "      <td>13 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Dr J.R. Calvert, Professor R.A. Farrar]</td>\n",
       "      <td>4.2</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Applied Data Science For Mumbai University B.E...</td>\n",
       "      <td>₹252.00</td>\n",
       "      <td>5.0 out of 5 stars</td>\n",
       "      <td>1 rating</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Dr. Harshali Patil, Mr. Loukik S. Salvi, Purv...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Design Data: Data Book of Engineers by PSG Col...</td>\n",
       "      <td>₹462.00</td>\n",
       "      <td>4.2 out of 5 stars</td>\n",
       "      <td>578 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Coimbtore PSG]</td>\n",
       "      <td>4.2</td>\n",
       "      <td>578.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Simplifying Data Engineering and Analytics wit...</td>\n",
       "      <td>₹2,957.00</td>\n",
       "      <td>4.3 out of 5 stars</td>\n",
       "      <td>7 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>[Anindita Mahapatra, Doug May]</td>\n",
       "      <td>4.3</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>The Data WarehouseETL Toolkit: Practical Techn...</td>\n",
       "      <td></td>\n",
       "      <td>4.5 out of 5 stars</td>\n",
       "      <td>162 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>[Ralph Kimball, Joe Caserta]</td>\n",
       "      <td>4.5</td>\n",
       "      <td>162.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Introducing Data Science</td>\n",
       "      <td>₹690.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>97 ratings</td>\n",
       "      <td>Only 1 left in stock</td>\n",
       "      <td>[Davy Cielen, Arno D.B. Meysman, Mohamed Ali]</td>\n",
       "      <td>4.4</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                title      price   \n",
       "0            Data Structures and Algorithms Made Easy    ₹582.00  \\\n",
       "1   The Kimball Group Reader: Relentlessly Practic...              \n",
       "2   Fundamentals of Data Engineering: Plan and Bui...  ₹1,750.00   \n",
       "3   Data Engineering with Python: Work with massiv...  ₹2,788.00   \n",
       "4                          Data Science for Engineers  ₹2,610.00   \n",
       "5   PSG Design Data Handbook - Data Book of Engine...    ₹465.00   \n",
       "6   Data Engineering with AWS: Learn how to design...  ₹3,126.00   \n",
       "7   Azure Data Engineering Cookbook: Design and im...              \n",
       "8   Data Engineering with Apache Spark, Delta Lake...              \n",
       "9                            Data Science & Analytics    ₹280.00   \n",
       "10  Data Structure and Algorithmic Thinking with P...    ₹582.00   \n",
       "11   Data Structures and Algorithms Made Easy in Java    ₹582.00   \n",
       "12  Azure Data Engineer Associate Certification Gu...              \n",
       "13  Fundamentals of Data Engineering: Designing an...              \n",
       "14  Data Engineering with Google Cloud Platform: A...  ₹3,464.00   \n",
       "15  Design Data Handbook For Mechanical Engineers ...    ₹383.00   \n",
       "16                           An Engineering Data Book  ₹3,702.00   \n",
       "17  Applied Data Science For Mumbai University B.E...    ₹252.00   \n",
       "18  Design Data: Data Book of Engineers by PSG Col...    ₹462.00   \n",
       "19  Simplifying Data Engineering and Analytics wit...  ₹2,957.00   \n",
       "20  The Data WarehouseETL Toolkit: Practical Techn...              \n",
       "21                           Introducing Data Science    ₹690.00   \n",
       "\n",
       "                rating        reviews          availability   \n",
       "0   4.4 out of 5 stars  2,366 ratings              In stock  \\\n",
       "1   4.6 out of 5 stars     64 ratings         Not Available   \n",
       "2   4.7 out of 5 stars    209 ratings              In stock   \n",
       "3   4.2 out of 5 stars    103 ratings              In stock   \n",
       "4        Previous page                 Only 2 left in stock   \n",
       "5        Previous page                             In stock   \n",
       "6   4.4 out of 5 stars     62 ratings              In stock   \n",
       "7   3.2 out of 5 stars     10 ratings         Not Available   \n",
       "8   3.9 out of 5 stars     50 ratings         Not Available   \n",
       "9   3.8 out of 5 stars     13 ratings              In stock   \n",
       "10  4.3 out of 5 stars    713 ratings              In stock   \n",
       "11  4.3 out of 5 stars  1,103 ratings              In stock   \n",
       "12  3.9 out of 5 stars     20 ratings         Not Available   \n",
       "13  4.9 out of 5 stars     29 ratings         Not Available   \n",
       "14  4.8 out of 5 stars     10 ratings              In stock   \n",
       "15  4.4 out of 5 stars    924 ratings              In stock   \n",
       "16  4.2 out of 5 stars     13 ratings              In stock   \n",
       "17  5.0 out of 5 stars       1 rating              In stock   \n",
       "18  4.2 out of 5 stars    578 ratings              In stock   \n",
       "19  4.3 out of 5 stars      7 ratings              In stock   \n",
       "20  4.5 out of 5 stars    162 ratings         Not Available   \n",
       "21  4.4 out of 5 stars     97 ratings  Only 1 left in stock   \n",
       "\n",
       "                                              authors  ratings_out_of_5Stars   \n",
       "0                              [Narasimha Karumanchi]                    4.4  \\\n",
       "1                         [Ralph Kimball, Margy Ross]                    4.6   \n",
       "2                            [Joe Reis, Matt Housley]                    4.7   \n",
       "3                                     [Paul Crickard]                    4.2   \n",
       "4              [Raghunathan Rengaswamy, Resmi Suresh]                    NaN   \n",
       "5               [Coimbtore PSG College of Technology]                    NaN   \n",
       "6                                      [Gareth Eagar]                    4.4   \n",
       "7                                       [Ahmad Osama]                    3.2   \n",
       "8                    [Manoj Kukreja, Danil Zburivsky]                    3.9   \n",
       "9                                           [VK Jain]                    3.8   \n",
       "10                             [Narasimha Karumanchi]                    4.3   \n",
       "11                             [Narasimha Karumanchi]                    4.3   \n",
       "12                                      [Newton Alex]                    3.9   \n",
       "13                                    [Brian  Murray]                    4.9   \n",
       "14                                       [Adi Wijaya]                    4.8   \n",
       "15                                        [Mahadevan]                    4.4   \n",
       "16           [Dr J.R. Calvert, Professor R.A. Farrar]                    4.2   \n",
       "17  [Dr. Harshali Patil, Mr. Loukik S. Salvi, Purv...                    5.0   \n",
       "18                                    [Coimbtore PSG]                    4.2   \n",
       "19                     [Anindita Mahapatra, Doug May]                    4.3   \n",
       "20                       [Ralph Kimball, Joe Caserta]                    4.5   \n",
       "21      [Davy Cielen, Arno D.B. Meysman, Mohamed Ali]                    4.4   \n",
       "\n",
       "    reviews_count  \n",
       "0          2366.0  \n",
       "1            64.0  \n",
       "2           209.0  \n",
       "3           103.0  \n",
       "4             NaN  \n",
       "5             NaN  \n",
       "6            62.0  \n",
       "7            10.0  \n",
       "8            50.0  \n",
       "9            13.0  \n",
       "10          713.0  \n",
       "11         1103.0  \n",
       "12           20.0  \n",
       "13           29.0  \n",
       "14           10.0  \n",
       "15          924.0  \n",
       "16           13.0  \n",
       "17            1.0  \n",
       "18          578.0  \n",
       "19            7.0  \n",
       "20          162.0  \n",
       "21           97.0  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "array_to_string = lambda arr: ','.join(map(str,arr))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "amazon_df['authors'] = amazon_df['authors'].apply(array_to_string)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "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>title</th>\n",
       "      <th>price</th>\n",
       "      <th>rating</th>\n",
       "      <th>reviews</th>\n",
       "      <th>availability</th>\n",
       "      <th>authors</th>\n",
       "      <th>ratings_out_of_5Stars</th>\n",
       "      <th>reviews_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Data Structures and Algorithms Made Easy</td>\n",
       "      <td>₹582.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>2,366 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>Narasimha Karumanchi</td>\n",
       "      <td>4.4</td>\n",
       "      <td>2366.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Kimball Group Reader: Relentlessly Practic...</td>\n",
       "      <td></td>\n",
       "      <td>4.6 out of 5 stars</td>\n",
       "      <td>64 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Ralph Kimball,Margy Ross</td>\n",
       "      <td>4.6</td>\n",
       "      <td>64.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Fundamentals of Data Engineering: Plan and Bui...</td>\n",
       "      <td>₹1,750.00</td>\n",
       "      <td>4.7 out of 5 stars</td>\n",
       "      <td>209 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>Joe Reis,Matt Housley</td>\n",
       "      <td>4.7</td>\n",
       "      <td>209.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Data Engineering with Python: Work with massiv...</td>\n",
       "      <td>₹2,788.00</td>\n",
       "      <td>4.2 out of 5 stars</td>\n",
       "      <td>103 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>Paul Crickard</td>\n",
       "      <td>4.2</td>\n",
       "      <td>103.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Data Science for Engineers</td>\n",
       "      <td>₹2,610.00</td>\n",
       "      <td>Previous page</td>\n",
       "      <td></td>\n",
       "      <td>Only 2 left in stock</td>\n",
       "      <td>Raghunathan Rengaswamy,Resmi Suresh</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>PSG Design Data Handbook - Data Book of Engine...</td>\n",
       "      <td>₹465.00</td>\n",
       "      <td>Previous page</td>\n",
       "      <td></td>\n",
       "      <td>In stock</td>\n",
       "      <td>Coimbtore PSG College of Technology</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Data Engineering with AWS: Learn how to design...</td>\n",
       "      <td>₹3,126.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>62 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>Gareth Eagar</td>\n",
       "      <td>4.4</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Azure Data Engineering Cookbook: Design and im...</td>\n",
       "      <td></td>\n",
       "      <td>3.2 out of 5 stars</td>\n",
       "      <td>10 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Ahmad Osama</td>\n",
       "      <td>3.2</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Data Engineering with Apache Spark, Delta Lake...</td>\n",
       "      <td></td>\n",
       "      <td>3.9 out of 5 stars</td>\n",
       "      <td>50 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Manoj Kukreja,Danil Zburivsky</td>\n",
       "      <td>3.9</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Data Science &amp; Analytics</td>\n",
       "      <td>₹280.00</td>\n",
       "      <td>3.8 out of 5 stars</td>\n",
       "      <td>13 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>VK Jain</td>\n",
       "      <td>3.8</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Data Structure and Algorithmic Thinking with P...</td>\n",
       "      <td>₹582.00</td>\n",
       "      <td>4.3 out of 5 stars</td>\n",
       "      <td>713 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>Narasimha Karumanchi</td>\n",
       "      <td>4.3</td>\n",
       "      <td>713.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Data Structures and Algorithms Made Easy in Java</td>\n",
       "      <td>₹582.00</td>\n",
       "      <td>4.3 out of 5 stars</td>\n",
       "      <td>1,103 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>Narasimha Karumanchi</td>\n",
       "      <td>4.3</td>\n",
       "      <td>1103.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Azure Data Engineer Associate Certification Gu...</td>\n",
       "      <td></td>\n",
       "      <td>3.9 out of 5 stars</td>\n",
       "      <td>20 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Newton Alex</td>\n",
       "      <td>3.9</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Fundamentals of Data Engineering: Designing an...</td>\n",
       "      <td></td>\n",
       "      <td>4.9 out of 5 stars</td>\n",
       "      <td>29 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Brian  Murray</td>\n",
       "      <td>4.9</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Data Engineering with Google Cloud Platform: A...</td>\n",
       "      <td>₹3,464.00</td>\n",
       "      <td>4.8 out of 5 stars</td>\n",
       "      <td>10 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>Adi Wijaya</td>\n",
       "      <td>4.8</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Design Data Handbook For Mechanical Engineers ...</td>\n",
       "      <td>₹383.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>924 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>Mahadevan</td>\n",
       "      <td>4.4</td>\n",
       "      <td>924.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>An Engineering Data Book</td>\n",
       "      <td>₹3,702.00</td>\n",
       "      <td>4.2 out of 5 stars</td>\n",
       "      <td>13 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>Dr J.R. Calvert,Professor R.A. Farrar</td>\n",
       "      <td>4.2</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Applied Data Science For Mumbai University B.E...</td>\n",
       "      <td>₹252.00</td>\n",
       "      <td>5.0 out of 5 stars</td>\n",
       "      <td>1 rating</td>\n",
       "      <td>In stock</td>\n",
       "      <td>Dr. Harshali Patil,Mr. Loukik S. Salvi,Purva Raut</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Design Data: Data Book of Engineers by PSG Col...</td>\n",
       "      <td>₹462.00</td>\n",
       "      <td>4.2 out of 5 stars</td>\n",
       "      <td>578 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>Coimbtore PSG</td>\n",
       "      <td>4.2</td>\n",
       "      <td>578.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Simplifying Data Engineering and Analytics wit...</td>\n",
       "      <td>₹2,957.00</td>\n",
       "      <td>4.3 out of 5 stars</td>\n",
       "      <td>7 ratings</td>\n",
       "      <td>In stock</td>\n",
       "      <td>Anindita Mahapatra,Doug May</td>\n",
       "      <td>4.3</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>The Data WarehouseETL Toolkit: Practical Techn...</td>\n",
       "      <td></td>\n",
       "      <td>4.5 out of 5 stars</td>\n",
       "      <td>162 ratings</td>\n",
       "      <td>Not Available</td>\n",
       "      <td>Ralph Kimball,Joe Caserta</td>\n",
       "      <td>4.5</td>\n",
       "      <td>162.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Introducing Data Science</td>\n",
       "      <td>₹690.00</td>\n",
       "      <td>4.4 out of 5 stars</td>\n",
       "      <td>97 ratings</td>\n",
       "      <td>Only 1 left in stock</td>\n",
       "      <td>Davy Cielen,Arno D.B. Meysman,Mohamed Ali</td>\n",
       "      <td>4.4</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                title      price   \n",
       "0            Data Structures and Algorithms Made Easy    ₹582.00  \\\n",
       "1   The Kimball Group Reader: Relentlessly Practic...              \n",
       "2   Fundamentals of Data Engineering: Plan and Bui...  ₹1,750.00   \n",
       "3   Data Engineering with Python: Work with massiv...  ₹2,788.00   \n",
       "4                          Data Science for Engineers  ₹2,610.00   \n",
       "5   PSG Design Data Handbook - Data Book of Engine...    ₹465.00   \n",
       "6   Data Engineering with AWS: Learn how to design...  ₹3,126.00   \n",
       "7   Azure Data Engineering Cookbook: Design and im...              \n",
       "8   Data Engineering with Apache Spark, Delta Lake...              \n",
       "9                            Data Science & Analytics    ₹280.00   \n",
       "10  Data Structure and Algorithmic Thinking with P...    ₹582.00   \n",
       "11   Data Structures and Algorithms Made Easy in Java    ₹582.00   \n",
       "12  Azure Data Engineer Associate Certification Gu...              \n",
       "13  Fundamentals of Data Engineering: Designing an...              \n",
       "14  Data Engineering with Google Cloud Platform: A...  ₹3,464.00   \n",
       "15  Design Data Handbook For Mechanical Engineers ...    ₹383.00   \n",
       "16                           An Engineering Data Book  ₹3,702.00   \n",
       "17  Applied Data Science For Mumbai University B.E...    ₹252.00   \n",
       "18  Design Data: Data Book of Engineers by PSG Col...    ₹462.00   \n",
       "19  Simplifying Data Engineering and Analytics wit...  ₹2,957.00   \n",
       "20  The Data WarehouseETL Toolkit: Practical Techn...              \n",
       "21                           Introducing Data Science    ₹690.00   \n",
       "\n",
       "                rating        reviews          availability   \n",
       "0   4.4 out of 5 stars  2,366 ratings              In stock  \\\n",
       "1   4.6 out of 5 stars     64 ratings         Not Available   \n",
       "2   4.7 out of 5 stars    209 ratings              In stock   \n",
       "3   4.2 out of 5 stars    103 ratings              In stock   \n",
       "4        Previous page                 Only 2 left in stock   \n",
       "5        Previous page                             In stock   \n",
       "6   4.4 out of 5 stars     62 ratings              In stock   \n",
       "7   3.2 out of 5 stars     10 ratings         Not Available   \n",
       "8   3.9 out of 5 stars     50 ratings         Not Available   \n",
       "9   3.8 out of 5 stars     13 ratings              In stock   \n",
       "10  4.3 out of 5 stars    713 ratings              In stock   \n",
       "11  4.3 out of 5 stars  1,103 ratings              In stock   \n",
       "12  3.9 out of 5 stars     20 ratings         Not Available   \n",
       "13  4.9 out of 5 stars     29 ratings         Not Available   \n",
       "14  4.8 out of 5 stars     10 ratings              In stock   \n",
       "15  4.4 out of 5 stars    924 ratings              In stock   \n",
       "16  4.2 out of 5 stars     13 ratings              In stock   \n",
       "17  5.0 out of 5 stars       1 rating              In stock   \n",
       "18  4.2 out of 5 stars    578 ratings              In stock   \n",
       "19  4.3 out of 5 stars      7 ratings              In stock   \n",
       "20  4.5 out of 5 stars    162 ratings         Not Available   \n",
       "21  4.4 out of 5 stars     97 ratings  Only 1 left in stock   \n",
       "\n",
       "                                              authors  ratings_out_of_5Stars   \n",
       "0                                Narasimha Karumanchi                    4.4  \\\n",
       "1                            Ralph Kimball,Margy Ross                    4.6   \n",
       "2                               Joe Reis,Matt Housley                    4.7   \n",
       "3                                       Paul Crickard                    4.2   \n",
       "4                 Raghunathan Rengaswamy,Resmi Suresh                    NaN   \n",
       "5                 Coimbtore PSG College of Technology                    NaN   \n",
       "6                                        Gareth Eagar                    4.4   \n",
       "7                                         Ahmad Osama                    3.2   \n",
       "8                       Manoj Kukreja,Danil Zburivsky                    3.9   \n",
       "9                                             VK Jain                    3.8   \n",
       "10                               Narasimha Karumanchi                    4.3   \n",
       "11                               Narasimha Karumanchi                    4.3   \n",
       "12                                        Newton Alex                    3.9   \n",
       "13                                      Brian  Murray                    4.9   \n",
       "14                                         Adi Wijaya                    4.8   \n",
       "15                                          Mahadevan                    4.4   \n",
       "16              Dr J.R. Calvert,Professor R.A. Farrar                    4.2   \n",
       "17  Dr. Harshali Patil,Mr. Loukik S. Salvi,Purva Raut                    5.0   \n",
       "18                                      Coimbtore PSG                    4.2   \n",
       "19                        Anindita Mahapatra,Doug May                    4.3   \n",
       "20                          Ralph Kimball,Joe Caserta                    4.5   \n",
       "21          Davy Cielen,Arno D.B. Meysman,Mohamed Ali                    4.4   \n",
       "\n",
       "    reviews_count  \n",
       "0          2366.0  \n",
       "1            64.0  \n",
       "2           209.0  \n",
       "3           103.0  \n",
       "4             NaN  \n",
       "5             NaN  \n",
       "6            62.0  \n",
       "7            10.0  \n",
       "8            50.0  \n",
       "9            13.0  \n",
       "10          713.0  \n",
       "11         1103.0  \n",
       "12           20.0  \n",
       "13           29.0  \n",
       "14           10.0  \n",
       "15          924.0  \n",
       "16           13.0  \n",
       "17            1.0  \n",
       "18          578.0  \n",
       "19            7.0  \n",
       "20          162.0  \n",
       "21           97.0  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "amazon_df.to_csv(\"final_amazon_data.csv\")"
   ]
  },
  {
   "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.6"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}