Customer Purchase Behavior - Electronic Sales Data

Customer purchasing behavior and demographics in the electronics market.

@kaggle.cameronseamons_electronic_sales_sep2023_sep2024

Table List

1 table(318.15 KB)

Electronic Sales Sep2023 Sep2024

Electronic Sales Sep2023 Sep2024

@kaggle.cameronseamons_electronic_sales_sep2023_sep2024.electronic_sales_sep2023_sep2024

318.15 KB
20000 rows
16 columns

customer_id Customer ID	age Age	gender Gender	loyalty_member Loyalty Member	product_type Product Type	sku SKU	rating Rating	order_status Order Status	payment_method Payment Method	total_price Total Price	unit_price Unit Price	quantity Quantity	purchase_date Purchase Date	shipping_type Shipping Type	add_ons_purchased Add-ons Purchased	add_on_total Add-on Total
1000	53	Male	No	Smartphone	SKU1004	2	Cancelled	Credit Card	5538.33	791.19	7	Wed Mar 20 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Standard	Accessory,Accessory,Accessory	40.21
1000	53	Male	No	Tablet	SKU1002	3	Completed	Paypal	741.09	247.03	3	Sat Apr 20 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Overnight	Impulse Item	26.09
1002	41	Male	No	Laptop	SKU1005	3	Completed	Credit Card	1855.84	463.96	4	Tue Oct 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Express	nan
1002	41	Male	Yes	Smartphone	SKU1004	2	Completed	Cash	3164.76	791.19	4	Fri Aug 09 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Overnight	Impulse Item,Impulse Item	60.16
1003	75	Male	Yes	Smartphone	SKU1001	5	Completed	Cash	41.5	20.75	2	Tue May 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Express	Accessory	35.56
1004	41	Female	No	Smartphone	SKU1001	5	Completed	Credit Card	83	20.75	4	Sun May 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Standard	Impulse Item,Accessory	65.78
1005	25	Female	No	Smartwatch	SKU1003	3	Completed	Paypal	7603.47	844.83	9	Tue Jan 30 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Overnight	nan
1005	25	Female	No	Laptop	SKU1005	3	Completed	Debit Card	4175.64	463.96	9	Mon Jun 24 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Overnight	Extended Warranty,Extended Warranty	75.33
1006	24	Male	No	Smartphone	SKU1004	2	Cancelled	Debit Card	5538.33	791.19	7	Tue Oct 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Standard	Impulse Item	43.05
1006	24	Male	Yes	Laptop	SKU1005	3	Completed	Cash	4175.64	463.96	9	Mon Jan 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Express	nan


CREATE TABLE electronic_sales_sep2023_sep2024 (
  "customer_id" BIGINT,
  "age" BIGINT,
  "gender" VARCHAR,
  "loyalty_member" VARCHAR,
  "product_type" VARCHAR,
  "sku" VARCHAR,
  "rating" BIGINT,
  "order_status" VARCHAR,
  "payment_method" VARCHAR,
  "total_price" DOUBLE,
  "unit_price" DOUBLE,
  "quantity" BIGINT,
  "purchase_date" TIMESTAMP,
  "shipping_type" VARCHAR,
  "add_ons_purchased" VARCHAR,
  "add_on_total" DOUBLE
);