Dataset: [70,000+ Products] E-Commerce Data CLEAN

About this Dataset

[70,000+ Products] E-Commerce Data CLEAN

Transformed E-commerce Product Data: Ready for Analysis!

Sharpen your data analysis skills with this cleaned and enhanced e-commerce product dataset. This dataset was originally spread across 20+ CSV files with over 80,000 products, this dataset now offers a streamlined single CSV for you to focus on analysis.

What's Inside:

Clean and Consistent Data: Missing values, formatting inconsistencies, and errors have been addressed, ensuring a foundation for reliable analysis.

Organized Product Information: Explore a variety of product categories, including:

Apparel & Accessories
Electronics
Home & Kitchen
Men's Clothing
Women's Clothing
Swimsuits and Sleepwear
And more!

Detailed Product Records:

Product Title
Category
Price
Discount Information
Product subcategory
Product rank
Quantity sold
Color count
Image source URL

Dive right into creating new features from existing data, such as:

Extracting keywords from titles and descriptions
Deriving price categories
Calculating average discounts

Tables

Clean Ecommerce Products All Categories

@kaggle.oleksiimartusiuk_80000_products_e_commerce_data_clean.clean_ecommerce_products_all_categories

5.35 MB
82105 rows
11 columns


CREATE TABLE clean_ecommerce_products_all_categories (
  "unnamed_0" BIGINT,
  "rank" VARCHAR,
  "rank_category" VARCHAR,
  "price_usd" DOUBLE,
  "pct_discount" DOUBLE,
  "qty_sold" DOUBLE,
  "product_title" VARCHAR,
  "category_name" VARCHAR,
  "color_count" DOUBLE,
  "img_source_url" VARCHAR,
  "black_friday_off_usd" DOUBLE
);