AmazonWebScrapping.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/ayushwattal/AmazonWebScrapping/blob/main/AmazonWebScrapping.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Amazon WebScrapping using BeautifulSoup\n",
        "\n"
      ],
      "metadata": {
        "id": "LgH4pg8zkx6N"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "This is an academic project for scrapping item listing from amazon. The data is not used for any commercial purpose. Before web scrapping check your local raw related to web scrapping."
      ],
      "metadata": {
        "id": "JLkhScebk9LM"
      }
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "53IkytVJscSC",
        "outputId": "11e1c586-97e6-4e0c-882a-f4b4f9c1922f"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Looking in indexes: https://pypi.org/simple, https://us-python.pkg.dev/colab-wheels/public/simple/\n",
            "Requirement already satisfied: bs4 in /usr/local/lib/python3.7/dist-packages (0.0.1)\n",
            "Requirement already satisfied: beautifulsoup4 in /usr/local/lib/python3.7/dist-packages (from bs4) (4.6.3)\n"
          ]
        }
      ],
      "source": [
        "# Installing BeautifulSoup\n",
        "!pip install bs4"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 41,
      "metadata": {
        "id": "iuHk8xDKscUp"
      },
      "outputs": [],
      "source": [
        "# Import Libraries\n",
        "from bs4 import BeautifulSoup\n",
        "import requests\n",
        "import time\n",
        "import datetime\n",
        "import smtplib\n",
        "import csv\n",
        "import pandas as pd\n",
        "import random\n",
        "import sys\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 42,
      "metadata": {
        "id": "wt_uyT7qroFb"
      },
      "outputs": [],
      "source": [
        "# Replace User Agent with 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/102.0.0.0 Safari/537.36\" , \"Accept-Encoding\":\"gzip, deflate\", \"Accept\":\"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8\", \"DNT\":\"1\",\"Connection\":\"close\", \"Upgrade-Insecure-Requests\":\"1\"}\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 43,
      "metadata": {
        "id": "7e_Oc_npiOCS"
      },
      "outputs": [],
      "source": [
        "\n",
        "# Generate URL based on input search and for 20 pages\n",
        "def generate_url(search_term):\n",
        "  urlList = []\n",
        "  template = 'https://www.amazon.com/s?k={}'\n",
        "  search_term = search_term.replace(' ', '+')\n",
        "  # Add query\n",
        "  url = template.format(search_term)\n",
        "  # Add pages\n",
        "  url += '&page={}&qid=1656114267&ref=sr_pg_{}'\n",
        "  # generate pages\n",
        "  for i in range (1,21):\n",
        "    urlList.append(url.format(i,i))\n",
        "  return urlList\n",
        "\n",
        "# Method to get Soup by passing url\n",
        "def getSoup(url):\n",
        "    page = requests.get(url, headers = headers)\n",
        "    soup1 = BeautifulSoup(page.content,\"html.parser\")\n",
        "    soup2 = BeautifulSoup(soup1.prettify(),\"html.parser\")\n",
        "    return soup2\n",
        "\n",
        "# Method to extract data from each listed product\n",
        "def get_item_data(item):\n",
        "\n",
        "  # Product Title and URL\n",
        "  title = item.h2.a.text.strip()\n",
        "  url = 'https://www.amazon.com' + item.h2.a.get('href')\n",
        "\n",
        "  # Prodict Rating and Customer Reviews\n",
        "  try:\n",
        "    rating = item.find('span', {'class' : 'a-icon-alt'}).getText().strip()[:-14]\n",
        "    customerReview = item.find('span', {'class' : 'a-size-base s-underline-text'}).getText().strip()\n",
        "  except AttributeError:\n",
        "    rating = '0'\n",
        "    customerReview = '0'\n",
        "  # Product Price \n",
        "  try:\n",
        "    price = item.find('span', {'class' : 'a-price'}).find('span', {'class' : 'a-offscreen'}).text.strip()[1:] \n",
        "  except AttributeError:\n",
        "     price = '0' \n",
        "  result = (title, price, rating, customerReview,url )\n",
        " \n",
        "  return result"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 44,
      "metadata": {
        "id": "cvdFE2Mnrn3Q"
      },
      "outputs": [],
      "source": [
        "# Searching for mobile phones\n",
        "\n",
        "url_List = generate_url('mobile phones')\n",
        "itemList = []\n",
        "\n",
        "# Getting item data from all the pages\n",
        "for url in url_List:\n",
        "  page = requests.get(url, headers = headers)\n",
        "  soup1 = BeautifulSoup(page.content,\"html.parser\")\n",
        "  soup2 = BeautifulSoup(soup1.prettify(),\"html.parser\")\n",
        "  totalItems = soup2.find_all('div', {'data-component-type':'s-search-result'})\n",
        "  for item in totalItems:\n",
        "    itemData = get_item_data(item)\n",
        "    if itemData:\n",
        "      itemList.append(itemData)\n"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "In case number of pages for the product is less than 20, change the loop count or else items in page number 1 are repeated resulting in duplicates."
      ],
      "metadata": {
        "id": "hxs83gTo6_8y"
      }
    },
    {
      "cell_type": "code",
      "execution_count": 45,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "WUaXnj0RW7_g",
        "outputId": "476d087c-30d2-4909-996f-845ea7ce4b13"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                                 Title  Price($)  \\\n",
              "0    SAMSUNG Galaxy A13 5G Cell Phone, Factory Unlo...    249.99   \n",
              "1    SAMSUNG Galaxy S20 FE 5G Cell Phone, Factory U...    499.99   \n",
              "2    Samsung Galaxy A12 (SM-A125F/DS) Dual SIM,128 ...    187.50   \n",
              "3    Moto G stylus | 2020 | Unlocked | Made for US ...    252.00   \n",
              "4      Apple iPhone 8, 64GB, Gold - Unlocked (Renewed)    169.99   \n",
              "..                                                 ...       ...   \n",
              "421  PLMOKN Mobile Phone Live Selfie Ring ​Lights L...     16.99   \n",
              "422  Mobile Phone Bracket Gravity Linkage Elastic B...     16.90   \n",
              "423  Cel-Fi GO X | 100 dB 4G/5G Cell Phone Signal B...  1,099.99   \n",
              "424  SNKINE New 360° Rotatable and Retractable Car ...     16.99   \n",
              "425  Smartphone Fingerprint Rugged Phones 3-Day-Bat...    169.99   \n",
              "\n",
              "    Rating(Out of 5) Customer_Review  \\\n",
              "0               4.3            1,523   \n",
              "1               4.6           10,726   \n",
              "2               4.1            1,032   \n",
              "3               4.5            6,413   \n",
              "4               4.4           45,107   \n",
              "..               ...             ...   \n",
              "421                0               0   \n",
              "422                0               0   \n",
              "423             4.6              317   \n",
              "424                0               0   \n",
              "425             3.8               37   \n",
              "\n",
              "                                                   URL  \n",
              "0    https://www.amazon.com/gp/slredirect/picassoRe...  \n",
              "1    https://www.amazon.com/Samsung-Factory-Unlocke...  \n",
              "2    https://www.amazon.com/Samsung-SM-A125F-Factor...  \n",
              "3    https://www.amazon.com/Stylus-Unlocked-Motorol...  \n",
              "4    https://www.amazon.com/Apple-iPhone-Fully-Unlo...  \n",
              "..                                                 ...  \n",
              "421  https://www.amazon.com/gp/slredirect/picassoRe...  \n",
              "422  https://www.amazon.com/gp/slredirect/picassoRe...  \n",
              "423  https://www.amazon.com/gp/slredirect/picassoRe...  \n",
              "424  https://www.amazon.com/gp/slredirect/picassoRe...  \n",
              "425  https://www.amazon.com/Unlocked-Smartphone-OUK...  \n",
              "\n",
              "[426 rows x 5 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-ed7a0a93-b578-4daf-ab2e-a0dee6f05ce1\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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(Out of 5)</th>\n",
              "      <th>Customer_Review</th>\n",
              "      <th>URL</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>SAMSUNG Galaxy A13 5G Cell Phone, Factory Unlo...</td>\n",
              "      <td>249.99</td>\n",
              "      <td>4.3</td>\n",
              "      <td>1,523</td>\n",
              "      <td>https://www.amazon.com/gp/slredirect/picassoRe...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>SAMSUNG Galaxy S20 FE 5G Cell Phone, Factory U...</td>\n",
              "      <td>499.99</td>\n",
              "      <td>4.6</td>\n",
              "      <td>10,726</td>\n",
              "      <td>https://www.amazon.com/Samsung-Factory-Unlocke...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Samsung Galaxy A12 (SM-A125F/DS) Dual SIM,128 ...</td>\n",
              "      <td>187.50</td>\n",
              "      <td>4.1</td>\n",
              "      <td>1,032</td>\n",
              "      <td>https://www.amazon.com/Samsung-SM-A125F-Factor...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Moto G stylus | 2020 | Unlocked | Made for US ...</td>\n",
              "      <td>252.00</td>\n",
              "      <td>4.5</td>\n",
              "      <td>6,413</td>\n",
              "      <td>https://www.amazon.com/Stylus-Unlocked-Motorol...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Apple iPhone 8, 64GB, Gold - Unlocked (Renewed)</td>\n",
              "      <td>169.99</td>\n",
              "      <td>4.4</td>\n",
              "      <td>45,107</td>\n",
              "      <td>https://www.amazon.com/Apple-iPhone-Fully-Unlo...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>421</th>\n",
              "      <td>PLMOKN Mobile Phone Live Selfie Ring ​Lights L...</td>\n",
              "      <td>16.99</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>https://www.amazon.com/gp/slredirect/picassoRe...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>422</th>\n",
              "      <td>Mobile Phone Bracket Gravity Linkage Elastic B...</td>\n",
              "      <td>16.90</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>https://www.amazon.com/gp/slredirect/picassoRe...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>423</th>\n",
              "      <td>Cel-Fi GO X | 100 dB 4G/5G Cell Phone Signal B...</td>\n",
              "      <td>1,099.99</td>\n",
              "      <td>4.6</td>\n",
              "      <td>317</td>\n",
              "      <td>https://www.amazon.com/gp/slredirect/picassoRe...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>424</th>\n",
              "      <td>SNKINE New 360° Rotatable and Retractable Car ...</td>\n",
              "      <td>16.99</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>https://www.amazon.com/gp/slredirect/picassoRe...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>425</th>\n",
              "      <td>Smartphone Fingerprint Rugged Phones 3-Day-Bat...</td>\n",
              "      <td>169.99</td>\n",
              "      <td>3.8</td>\n",
              "      <td>37</td>\n",
              "      <td>https://www.amazon.com/Unlocked-Smartphone-OUK...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>426 rows × 5 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-ed7a0a93-b578-4daf-ab2e-a0dee6f05ce1')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-ed7a0a93-b578-4daf-ab2e-a0dee6f05ce1 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-ed7a0a93-b578-4daf-ab2e-a0dee6f05ce1');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 45
        }
      ],
      "source": [
        "# Creating a dataset\n",
        "dataset = pd.DataFrame(itemList, columns = ['Title', 'Price($)', 'Rating(Out of 5)', 'Customer_Review','URL'] )\n",
        "dataset"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Get dataset information\n",
        "dataset.info()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "xD5igbeBmdLW",
        "outputId": "361a90a1-693a-41ca-fd14-2e500c1226e5"
      },
      "execution_count": 46,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 426 entries, 0 to 425\n",
            "Data columns (total 5 columns):\n",
            " #   Column            Non-Null Count  Dtype \n",
            "---  ------            --------------  ----- \n",
            " 0   Title             426 non-null    object\n",
            " 1   Price($)          426 non-null    object\n",
            " 2   Rating(Out of 5)  426 non-null    object\n",
            " 3   Customer_Review   426 non-null    object\n",
            " 4   URL               426 non-null    object\n",
            "dtypes: object(5)\n",
            "memory usage: 16.8+ KB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Dropping dulicates rows if any\n",
        "dataset = dataset.drop_duplicates(subset=[\"Title\", \"Price($)\", \"Rating(Out of 5)\", \"Customer_Review\"], keep=False)\n",
        "dataset.reset_index(drop=True)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "dyWQ61oxI-Kh",
        "outputId": "0c4836f9-11fc-4232-b05d-d49278a5eb06"
      },
      "execution_count": 47,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                                 Title Price($)  \\\n",
              "0    SAMSUNG Galaxy A13 5G Cell Phone, Factory Unlo...   249.99   \n",
              "1    SAMSUNG Galaxy S20 FE 5G Cell Phone, Factory U...   499.99   \n",
              "2    Samsung Galaxy A12 (SM-A125F/DS) Dual SIM,128 ...   187.50   \n",
              "3    Moto G stylus | 2020 | Unlocked | Made for US ...   252.00   \n",
              "4      Apple iPhone 8, 64GB, Gold - Unlocked (Renewed)   169.99   \n",
              "..                                                 ...      ...   \n",
              "184  Rugged Smartphone, Blackview BV4900 Pro Waterp...   149.99   \n",
              "185  Smartphone,5.45 inch HD Full Screen face Recog...    78.99   \n",
              "186  Unlocked Rugged Phone, Ulefone Armor X10 Andro...   127.49   \n",
              "187  SNKINE New 360° Rotatable and Retractable Car ...    16.99   \n",
              "188  Smartphone Fingerprint Rugged Phones 3-Day-Bat...   169.99   \n",
              "\n",
              "    Rating(Out of 5) Customer_Review  \\\n",
              "0               4.3            1,523   \n",
              "1               4.6           10,726   \n",
              "2               4.1            1,032   \n",
              "3               4.5            6,413   \n",
              "4               4.4           45,107   \n",
              "..               ...             ...   \n",
              "184             4.0              487   \n",
              "185             2.8               63   \n",
              "186             4.4                4   \n",
              "187                0               0   \n",
              "188             3.8               37   \n",
              "\n",
              "                                                   URL  \n",
              "0    https://www.amazon.com/gp/slredirect/picassoRe...  \n",
              "1    https://www.amazon.com/Samsung-Factory-Unlocke...  \n",
              "2    https://www.amazon.com/Samsung-SM-A125F-Factor...  \n",
              "3    https://www.amazon.com/Stylus-Unlocked-Motorol...  \n",
              "4    https://www.amazon.com/Apple-iPhone-Fully-Unlo...  \n",
              "..                                                 ...  \n",
              "184  https://www.amazon.com/Smartphone-Blackview-BV...  \n",
              "185  https://www.amazon.com/Smartphone-Screen-Recog...  \n",
              "186  https://www.amazon.com/Unlocked-Ulefone-Androi...  \n",
              "187  https://www.amazon.com/gp/slredirect/picassoRe...  \n",
              "188  https://www.amazon.com/Unlocked-Smartphone-OUK...  \n",
              "\n",
              "[189 rows x 5 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-7e5f8770-ee94-4974-992a-dd31297422ca\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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(Out of 5)</th>\n",
              "      <th>Customer_Review</th>\n",
              "      <th>URL</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>SAMSUNG Galaxy A13 5G Cell Phone, Factory Unlo...</td>\n",
              "      <td>249.99</td>\n",
              "      <td>4.3</td>\n",
              "      <td>1,523</td>\n",
              "      <td>https://www.amazon.com/gp/slredirect/picassoRe...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>SAMSUNG Galaxy S20 FE 5G Cell Phone, Factory U...</td>\n",
              "      <td>499.99</td>\n",
              "      <td>4.6</td>\n",
              "      <td>10,726</td>\n",
              "      <td>https://www.amazon.com/Samsung-Factory-Unlocke...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Samsung Galaxy A12 (SM-A125F/DS) Dual SIM,128 ...</td>\n",
              "      <td>187.50</td>\n",
              "      <td>4.1</td>\n",
              "      <td>1,032</td>\n",
              "      <td>https://www.amazon.com/Samsung-SM-A125F-Factor...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Moto G stylus | 2020 | Unlocked | Made for US ...</td>\n",
              "      <td>252.00</td>\n",
              "      <td>4.5</td>\n",
              "      <td>6,413</td>\n",
              "      <td>https://www.amazon.com/Stylus-Unlocked-Motorol...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Apple iPhone 8, 64GB, Gold - Unlocked (Renewed)</td>\n",
              "      <td>169.99</td>\n",
              "      <td>4.4</td>\n",
              "      <td>45,107</td>\n",
              "      <td>https://www.amazon.com/Apple-iPhone-Fully-Unlo...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>184</th>\n",
              "      <td>Rugged Smartphone, Blackview BV4900 Pro Waterp...</td>\n",
              "      <td>149.99</td>\n",
              "      <td>4.0</td>\n",
              "      <td>487</td>\n",
              "      <td>https://www.amazon.com/Smartphone-Blackview-BV...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>185</th>\n",
              "      <td>Smartphone,5.45 inch HD Full Screen face Recog...</td>\n",
              "      <td>78.99</td>\n",
              "      <td>2.8</td>\n",
              "      <td>63</td>\n",
              "      <td>https://www.amazon.com/Smartphone-Screen-Recog...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>186</th>\n",
              "      <td>Unlocked Rugged Phone, Ulefone Armor X10 Andro...</td>\n",
              "      <td>127.49</td>\n",
              "      <td>4.4</td>\n",
              "      <td>4</td>\n",
              "      <td>https://www.amazon.com/Unlocked-Ulefone-Androi...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>187</th>\n",
              "      <td>SNKINE New 360° Rotatable and Retractable Car ...</td>\n",
              "      <td>16.99</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>https://www.amazon.com/gp/slredirect/picassoRe...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>188</th>\n",
              "      <td>Smartphone Fingerprint Rugged Phones 3-Day-Bat...</td>\n",
              "      <td>169.99</td>\n",
              "      <td>3.8</td>\n",
              "      <td>37</td>\n",
              "      <td>https://www.amazon.com/Unlocked-Smartphone-OUK...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>189 rows × 5 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-7e5f8770-ee94-4974-992a-dd31297422ca')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-7e5f8770-ee94-4974-992a-dd31297422ca button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-7e5f8770-ee94-4974-992a-dd31297422ca');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 47
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Converting Price($) columns from string to float and int\n",
        "dataset['Price($)'] = dataset['Price($)'].str.replace(',','')\n",
        "dataset['Price($)'] = dataset['Price($)'].astype(float)\n",
        "\n",
        "# Converting Customer_Review columns from string to int\n",
        "dataset['Customer_Review'] = dataset['Customer_Review'].str.replace(',', '')\n",
        "dataset['Customer_Review'] = dataset['Customer_Review'].astype(int)\n",
        "\n",
        "# Converting 'Rating(Out of 5)' columns from string to float\n",
        "dataset['Rating(Out of 5)'] = dataset['Rating(Out of 5)'].astype(float)"
      ],
      "metadata": {
        "id": "1XtxJPgkvqXB"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "dataset.info()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "gVD5-lMSqMj1",
        "outputId": "84e0891f-9d3c-4748-82ed-4ec45b072ce6"
      },
      "execution_count": 51,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 189 entries, 0 to 188\n",
            "Data columns (total 5 columns):\n",
            " #   Column            Non-Null Count  Dtype  \n",
            "---  ------            --------------  -----  \n",
            " 0   Title             189 non-null    object \n",
            " 1   Price($)          189 non-null    float64\n",
            " 2   Rating(Out of 5)  189 non-null    float64\n",
            " 3   Customer_Review   189 non-null    int64  \n",
            " 4   URL               189 non-null    object \n",
            "dtypes: float64(2), int64(1), object(2)\n",
            "memory usage: 7.5+ KB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Sorting rows based on most customer reviews and ratings\n",
        "dataset = dataset.sort_values(by=['Customer_Review', 'Rating(Out of 5)'],ascending=False)\n",
        "dataset = dataset.reset_index(drop=True)\n",
        "dataset"
      ],
      "metadata": {
        "id": "9WsCAhpzvqag",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "outputId": "fea026ae-2a8d-4758-cd02-b3e8c2f1f8de"
      },
      "execution_count": 49,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                                 Title  Price($)  \\\n",
              "0    Apple iPhone 7, 32GB, Gold - Fully Unlocked (R...     95.86   \n",
              "1      Apple iPhone 8, 64GB, Gold - Unlocked (Renewed)    169.99   \n",
              "2    OnePlus Nord CE 2,​ 5G Unlocked Android Smartp...    347.00   \n",
              "3    Samsung Galaxy Note 9, 128GB, Lavender Purple ...    214.99   \n",
              "4    Samsung Galaxy S10+, 128GB, Prism Black - Unlo...    217.00   \n",
              "..                                                 ...       ...   \n",
              "184  Evil Eye Beaded Phone Charm Pearl Beaded Phone...      7.90   \n",
              "185  WWJ 4G Smartphone SIM Free Android Phones Unlo...    118.95   \n",
              "186  Unlocked Phone KXD 6C Android Cell Phones 5.5\"...     74.99   \n",
              "187  Realme C35 128GB 4GB RAM Factory Unlocked (GSM...    204.00   \n",
              "188  SNKINE New 360° Rotatable and Retractable Car ...     16.99   \n",
              "\n",
              "     Rating(Out of 5)  Customer_Review  \\\n",
              "0                 4.2            48681   \n",
              "1                 4.4            45107   \n",
              "2                 4.3            18699   \n",
              "3                 4.4            15036   \n",
              "4                 4.4            12616   \n",
              "..                ...              ...   \n",
              "184               0.0                0   \n",
              "185               0.0                0   \n",
              "186               0.0                0   \n",
              "187               0.0                0   \n",
              "188               0.0                0   \n",
              "\n",
              "                                                   URL  \n",
              "0    https://www.amazon.com/Apple-iPhone-Fully-Unlo...  \n",
              "1    https://www.amazon.com/Apple-iPhone-Fully-Unlo...  \n",
              "2    https://www.amazon.com/OnePlus-Unlocked-Androi...  \n",
              "3    https://www.amazon.com/Samsung-Unlocked-Warran...  \n",
              "4    https://www.amazon.com/Samsung-Factory-Unlocke...  \n",
              "..                                                 ...  \n",
              "184  https://www.amazon.com/Beaded-Mobile-Bracelet-...  \n",
              "185  https://www.amazon.com/WWJ-Smartphone-Android-...  \n",
              "186  https://www.amazon.com/Unlocked-KXD-6C-Android...  \n",
              "187  https://www.amazon.com/Realme-128GB-Factory-Un...  \n",
              "188  https://www.amazon.com/gp/slredirect/picassoRe...  \n",
              "\n",
              "[189 rows x 5 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-b27953aa-fa05-4581-b552-2d88baad044f\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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(Out of 5)</th>\n",
              "      <th>Customer_Review</th>\n",
              "      <th>URL</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Apple iPhone 7, 32GB, Gold - Fully Unlocked (R...</td>\n",
              "      <td>95.86</td>\n",
              "      <td>4.2</td>\n",
              "      <td>48681</td>\n",
              "      <td>https://www.amazon.com/Apple-iPhone-Fully-Unlo...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Apple iPhone 8, 64GB, Gold - Unlocked (Renewed)</td>\n",
              "      <td>169.99</td>\n",
              "      <td>4.4</td>\n",
              "      <td>45107</td>\n",
              "      <td>https://www.amazon.com/Apple-iPhone-Fully-Unlo...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>OnePlus Nord CE 2,​ 5G Unlocked Android Smartp...</td>\n",
              "      <td>347.00</td>\n",
              "      <td>4.3</td>\n",
              "      <td>18699</td>\n",
              "      <td>https://www.amazon.com/OnePlus-Unlocked-Androi...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Samsung Galaxy Note 9, 128GB, Lavender Purple ...</td>\n",
              "      <td>214.99</td>\n",
              "      <td>4.4</td>\n",
              "      <td>15036</td>\n",
              "      <td>https://www.amazon.com/Samsung-Unlocked-Warran...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Samsung Galaxy S10+, 128GB, Prism Black - Unlo...</td>\n",
              "      <td>217.00</td>\n",
              "      <td>4.4</td>\n",
              "      <td>12616</td>\n",
              "      <td>https://www.amazon.com/Samsung-Factory-Unlocke...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>184</th>\n",
              "      <td>Evil Eye Beaded Phone Charm Pearl Beaded Phone...</td>\n",
              "      <td>7.90</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>https://www.amazon.com/Beaded-Mobile-Bracelet-...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>185</th>\n",
              "      <td>WWJ 4G Smartphone SIM Free Android Phones Unlo...</td>\n",
              "      <td>118.95</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>https://www.amazon.com/WWJ-Smartphone-Android-...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>186</th>\n",
              "      <td>Unlocked Phone KXD 6C Android Cell Phones 5.5\"...</td>\n",
              "      <td>74.99</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>https://www.amazon.com/Unlocked-KXD-6C-Android...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>187</th>\n",
              "      <td>Realme C35 128GB 4GB RAM Factory Unlocked (GSM...</td>\n",
              "      <td>204.00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>https://www.amazon.com/Realme-128GB-Factory-Un...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>188</th>\n",
              "      <td>SNKINE New 360° Rotatable and Retractable Car ...</td>\n",
              "      <td>16.99</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>https://www.amazon.com/gp/slredirect/picassoRe...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>189 rows × 5 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-b27953aa-fa05-4581-b552-2d88baad044f')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-b27953aa-fa05-4581-b552-2d88baad044f button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-b27953aa-fa05-4581-b552-2d88baad044f');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 49
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Saving dataset to Excel Format\n",
        "dataset.to_excel(\"Item_Listing.xlsx\",index = False)"
      ],
      "metadata": {
        "id": "JfbtuzikIeIX"
      },
      "execution_count": 50,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "References: -\n",
        "\n",
        "*   https://beautiful-soup-4.readthedocs.io/en/latest/\n",
        "*   https://github.com/jhnwr/amazon-pagination\n",
        "*   https://github.com/AlexTheAnalyst/PortfolioProjects/blob/main/Amazon%20Web%20Scraper%20Project.ipynb\n",
        "\n",
        "\n",
        "\n",
        "\n"
      ],
      "metadata": {
        "id": "cIx_y4sVjOLT"
      }
    }
  ],
  "metadata": {
    "colab": {
      "collapsed_sections": [],
      "name": "AmazonWebScrapping.ipynb",
      "provenance": [],
      "include_colab_link": true
    },
    "kernelspec": {
      "display_name": "Python 3",
      "name": "python3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}