Customer Shopping (Latest Trends) Dataset

"Consumer Shopping Trends: Insights into Purchase Behavior and Patterns"

@kaggle.bhadramohit_customer_shopping_latest_trends_dataset

Table List

1 table(63.94 KB)

Shopping Trends

@kaggle.bhadramohit_customer_shopping_latest_trends_dataset.shopping_trends

63.94 KB
3900 rows
19 columns

customer_id Customer ID	age Age	gender Gender	item_purchased Item Purchased	category Category	purchase_amount_usd Purchase Amount (USD)	location Location	size Size	color Color	season Season	review_rating Review Rating	subscription_status Subscription Status	payment_method Payment Method	shipping_type Shipping Type	discount_applied Discount Applied	promo_code_used Promo Code Used	previous_purchases Previous Purchases	preferred_payment_method Preferred Payment Method	frequency_of_purchases Frequency Of Purchases
1	55	Male	Blouse	Clothing	53	Kentucky	L	Gray	Winter	3.1	Yes	Credit Card	Express	Yes	Yes	14	Venmo	Fortnightly
2	19	Male	Sweater	Clothing	64	Maine	L	Maroon	Winter	3.1	Yes	Bank Transfer	Express	Yes	Yes	2	Cash	Fortnightly
3	50	Male	Jeans	Clothing	73	Massachusetts	S	Maroon	Spring	3.1	Yes	Cash	Free Shipping	Yes	Yes	23	Credit Card	Weekly
4	21	Male	Sandals	Footwear	90	Rhode Island	M	Maroon	Spring	3.5	Yes	PayPal	Next Day Air	Yes	Yes	49	PayPal	Weekly
5	45	Male	Blouse	Clothing	49	Oregon	M	Turquoise	Spring	2.7	Yes	Cash	Free Shipping	Yes	Yes	31	PayPal	Annually
6	46	Male	Sneakers	Footwear	20	Wyoming	M	White	Summer	2.9	Yes	Venmo	Standard	Yes	Yes	14	Venmo	Weekly
7	63	Male	Shirt	Clothing	85	Montana	M	Gray	Fall	3.2	Yes	Debit Card	Free Shipping	Yes	Yes	49	Cash	Quarterly
8	27	Male	Shorts	Clothing	34	Louisiana	L	Charcoal	Winter	3.2	Yes	Debit Card	Free Shipping	Yes	Yes	19	Credit Card	Weekly
9	26	Male	Coat	Outerwear	97	West Virginia	L	Silver	Summer	2.6	Yes	Venmo	Express	Yes	Yes	8	Venmo	Annually
10	57	Male	Handbag	Accessories	31	Missouri	M	Pink	Spring	4.8	Yes	PayPal	2-Day Shipping	Yes	Yes	4	Cash	Quarterly


CREATE TABLE shopping_trends (
  "customer_id" BIGINT,
  "age" BIGINT,
  "gender" VARCHAR,
  "item_purchased" VARCHAR,
  "category" VARCHAR,
  "purchase_amount_usd" BIGINT,
  "location" VARCHAR,
  "size" VARCHAR,
  "color" VARCHAR,
  "season" VARCHAR,
  "review_rating" DOUBLE,
  "subscription_status" VARCHAR,
  "payment_method" VARCHAR,
  "shipping_type" VARCHAR,
  "discount_applied" VARCHAR,
  "promo_code_used" VARCHAR,
  "previous_purchases" BIGINT,
  "preferred_payment_method" VARCHAR,
  "frequency_of_purchases" VARCHAR
);