About this Dataset

Amazon All Categories Best Sellers + Reviews

Amazon Best Seller Dataset

Data from Amazon US on the top 50 selling products for all 40 listed categories.
Includes:

Product Name
Product Categories
Raking of product in its category
Product Review Count (Number of Reviews)
Product Review (First page of reviews)
- Includes Meta + Full Review + Rating given by review
Cost of item at the time of scraping.
Product URL

Data scraped using Python Selenium and cleaned manually
Scraping Notebook

Data Scraping History

File	Scraped Date
`abs080922 - clear.csv`	9 August 2022
`abs083122 - clear.csv`	31 August 2022

PS
Dataset will be updated every second week of the month for the time period of 2022 August -> 2023 June

Tables

Abs080922 Clear

@kaggle.tigboatnc_amazon_all_categories_best_sellers_reviews.abs080922_clear

4.71 MB
1316 rows
8 columns


CREATE TABLE abs080922_clear (
  "unnamed_0" BIGINT,
  "product_name" VARCHAR,
  "category" VARCHAR,
  "categoryrank" VARCHAR,
  "noratings" BIGINT,
  "cost" VARCHAR,
  "reviewlist" VARCHAR,
  "product_url" VARCHAR
);

Abs083122 Clear

@kaggle.tigboatnc_amazon_all_categories_best_sellers_reviews.abs083122_clear

4.82 MB
1450 rows
8 columns


CREATE TABLE abs083122_clear (
  "unnamed_0" BIGINT,
  "product_name" VARCHAR,
  "category" VARCHAR,
  "categoryrank" VARCHAR,
  "noratings" BIGINT,
  "cost" VARCHAR,
  "reviewlist" VARCHAR,
  "product_url" VARCHAR
);