Transactional Retail Dataset Of Electronics Store

Online Electronics Store Dataset

@kaggle.muhammadshahrayar_transactional_retail_of_electronics_store

Table List

3 tables(177.39 KB)

Dirty Data

Missing Data

Warehouses

Missing Data

@kaggle.muhammadshahrayar_transactional_retail_of_electronics_store.missing_data

87.51 KB
500 rows
16 columns

order_id Order Id	customer_id Customer Id	date Date	nearest_warehouse Nearest Warehouse	shopping_cart Shopping Cart	order_price Order Price	delivery_charges Delivery Charges	customer_lat Customer Lat	customer_long Customer Long	coupon_discount Coupon Discount	order_total Order Total	season Season	is_expedited_delivery Is Expedited Delivery	distance_to_nearest_warehouse Distance To Nearest Warehouse	latest_customer_review Latest Customer Review	is_happy_customer Is Happy Customer
ORD382112	ID0289597187	Wed Mar 06 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Thompson	[('pearTV', 1), ('Candle Inferno', 2)]	7170	61.72	-37.8117825	144.9519722	15	6156.22	Autumn	true	0.4425	to many adds in ui it has adds, sends info to manufacture,	False
ORD378488	ID1668523020	Sun May 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Thompson	[('Thunder line', 1), ('Lucent 330S', 2), ('Alcon 10', 1)]	13590	65.2	-37.8082365	144.9421811	10	12296.2	Autumn		0.6547	s10e haven't had this phone but a short time but i have fallen in love lol	True
ORD279446	ID0370751503	Sun Mar 24 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Bakers	[('Candle Inferno', 2), ('Universe Note', 1)]	4310	78.75	-37.8129413	144.9858829	15	3742.25	nan	true	0.8852	best bang for your buck! great overall android phone, no damages during shipping and after a month phone performance hasn't declined, would recommend to anyone who wants to get a upgrade.	True
ORD277196	ID0634774947	Sat Jan 12 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Thompson	[('pearTV', 1), ('Thunder line', 1), ('Olivia x460', 2)]	10940	92.59	-37.8117484	144.9381916	25	8297.59	Summer	true	0.7875	good it was a gift for my niece. it to her in jamaica.	True
ORD116193	ID3313210924	Mon Sep 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Nickolson	[('pearTV', 2), ('Universe Note', 2), ('Thunder line', 1)]	21700	95.62	-37.8183928	144.9670339	5	20710.62	Spring	true	0.2225	excellent product excellent product, was received as described, was delivered at the correct time.	True
ORD005004	ID0472236192	Tue May 07 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Nickolson	[('Thunder line', 2), ('Lucent 330S', 2)]	6820	84.09	-37.8015018	144.9661038		6904.09	Autumn	true	1.9268	i love it very nice and good product would recomend to others	True
ORD296379	ID0591306178	Sat Jan 19 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Nickolson	[('Thunder line', 1), ('pearTV', 1)]	8490	77.51	-37.8237	144.9563143		8567.51	Summer		1.2953	great phone great phone i am still using that and learning more and more about it everyday i still have it and have gone through one case and put a new case on	True
ORD447851	ID0591430562	Thu Feb 07 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	[('Alcon 10', 2), ('Toshika 750', 2), ('Universe Note', 1), ('Olivia x460', 2)]	32440	67.27	-37.8174124	144.96759	5	30885.27	Summer		0.2169	five stars it was a gift, my nephew is loving it.	True
ORD078449	ID0030287324	Sun Oct 20 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Nickolson	[('Olivia x460', 2), ('iAssist Line', 2)]	6900	105.5	-37.8070811	144.9672879	15	5970.5	Spring	true	1.2971	definitively would buy again. has been great to me for the past months. highly suggest for people who want to buy an up to date phone but do not want to pay for the newest universe out.	True
ORD018258	ID0245537598	Mon May 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Nickolson	[('Universe Note', 1), ('Lucent 330S', 1), ('iAssist Line', 1), ('iStream', 2)]	7205	65.39	-37.8101638	144.9668186	15	6189.64	Autumn		0.9688	my best snapchat phone my snapchats are crystal clear with nice zoom focus. has wide vertical lens capturing a lot in one frame. phones overall performance is smooth and fast. phone is large but overall is the perfect size for cargo pant pockets.	True


CREATE TABLE missing_data (
  "order_id" VARCHAR,
  "customer_id" VARCHAR,
  "date" TIMESTAMP,
  "nearest_warehouse" VARCHAR,
  "shopping_cart" VARCHAR,
  "order_price" DOUBLE,
  "delivery_charges" DOUBLE,
  "customer_lat" DOUBLE,
  "customer_long" DOUBLE,
  "coupon_discount" BIGINT,
  "order_total" DOUBLE,
  "season" VARCHAR,
  "is_expedited_delivery" BOOLEAN,
  "distance_to_nearest_warehouse" DOUBLE,
  "latest_customer_review" VARCHAR,
  "is_happy_customer" VARCHAR
);