Name: E- Commerce Dataset
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

E- Commerce Dataset

E-Commerce Dataset: Products, Customers, and Trends

Description

This dataset provides a comprehensive view of an e-commerce platform, featuring detailed information about products, customers, pricing, and sales trends. It is designed for data analysis, machine learning, and insights into online retail operations. The dataset is structured to help researchers and analysts explore various aspects of e-commerce, such as product popularity, customer preferences, and shipping performance.

Columns and Their Descriptions

Product ID: Unique identifier for each product.
Product Name: The name or title of the product listed in the catalog.
Category: The category or type of the product (e.g., Electronics, Clothing, Home Decor).
Price: The price of the product in USD.
Discount: The discount applied to the product as a percentage of the original price.
Tax Rate: The applicable tax rate for the product as a percentage.
Stock Level: The number of units currently available in inventory.
Supplier ID: A unique identifier for the supplier of the product.
Customer Age Group: The age group of customers who frequently purchase this product (e.g., Teens, Adults, Seniors).
Customer Location: The geographical location of customers (e.g., Country, State, or City).
Customer Gender: The gender(s) of customers most likely to purchase this product (e.g., Male, Female, Both).
Shipping Cost: The cost of shipping the product in USD.
Shipping Method: The method of shipping used (e.g., Standard, Express, Overnight).
Return Rate: The percentage of orders for this product that are returned by customers.
Seasonality: The season(s) during which the product is most popular (e.g., Winter, Summer, All-Year).
Popularity Index: A score indicating the product's popularity on a scale of 0 to 100.

Use Cases

This dataset is ideal for:

Exploratory Data Analysis (EDA): Analyze sales trends, product popularity, and customer preferences.
Visualization: Create insightful charts to visualize product performance, regional sales, and shipping trends.
Customer Insights: Understand customer segmentation based on demographics, preferences, and location.
Machine Learning Applications:
- Regression: Predict product popularity based on price, discount, and stock level.
- Clustering: Identify similar product categories for targeted marketing.
- Classification: Predict whether a product will be returned based on its features.

Sample Data

Product ID	Product Name	Category	Price	Discount	Tax Rate	Stock Level	Supplier ID	Customer Age Group	Customer Location	Customer Gender	Shipping Cost	Shipping Method	Return Rate	Seasonality	Popularity Index
P001	Bluetooth Speaker	Electronics	49.99	10.0	5.0	200	S123	Adults	USA	Both	5.99	Standard	2.5	All-Year	85.0
P002	Yoga Mat	Sports	19.99	15.0	2.0	300	S456	Teens	Canada	Female	3.99	Express	1.5	All-Year	75.0
P003	Winter Jacket	Clothing	99.99	20.0	8.0	100	S789	Adults	UK	Male	9.99	Overnight	4.0	Winter	95.0

Tables

Diversified Ecommerce Dataset

@kaggle.malaiarasugraj_e_commerce_dataset.diversified_ecommerce_dataset

17.08 MB
1,000,000 rows
16 columns

CREATE TABLE diversified_ecommerce_dataset (
  "product_id" VARCHAR,
  "product_name" VARCHAR,
  "category" VARCHAR,
  "price" DOUBLE,
  "discount" BIGINT,
  "tax_rate" BIGINT,
  "stock_level" BIGINT,
  "supplier_id" VARCHAR,
  "customer_age_group" VARCHAR,
  "customer_location" VARCHAR,
  "customer_gender" VARCHAR,
  "shipping_cost" DOUBLE,
  "shipping_method" VARCHAR,
  "return_rate" DOUBLE,
  "seasonality" VARCHAR,
  "popularity_index" BIGINT
);