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

Dirty Data

@kaggle.muhammadshahrayar_transactional_retail_of_electronics_store.dirty_data

87.2 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
ORD182494	ID6197211592	2019-06-22	Thompson	[('Lucent 330S', 1), ('Thunder line', 2), ('iStream', 2), ('pearTV', 1)]	12200	79.89	-37.8151052	144.9328434	10	11059.89	Winter	true	1.28	perfect phone and trusted seller. phone itself is amazing. i got this phone as shown here on the description. it came in with original packaging including all original accessories. yes this phone is unlocked, so no doubt about it.	true
ORD395518	ID0282825849	2019-12-29	Thompson	[('Thunder line', 1), ('Universe Note', 2)]	9080	62.71	-37.8027362	144.9511178		9142.71	Summer		1.1621	it keeps dropping calls the wifi don't work this is a waste of money this phone is worthless, it keeps dropping calls the wifi don't work this is a waste of money
ORD494479	ID0579391891	2019-03-02	Nickolson	[('Thunder line', 1), ('pearTV', 2)]	10670	65.87	-37.8213016	144.9575809	10	9668.87	Autumn		1.0949	five stars this is a great cheap phone.	true
ORD019224	ID4544561904	2019-01-12	Nickolson	[('Universe Note', 1), ('Alcon 10', 2), ('Olivia x460', 1), ('iAssist Line', 1)]	24800	57.61	-37.8114157	144.9730729	15	21137.61	Summer		0.8571	charger did not fit the charger didn't fit.
ORD104032	ID6231506320	2019-11-28	Nickolson	[('Universe Note', 1), ('Olivia x460', 1), ('iStream', 1), ('Toshika 750', 1)]	9145	75.54	37.8238586	144.9698923	25	6934.29	Spring		0.5867	four stars good	true
ORD146760	ID0311654900	2019-09-16	Bakers	[('Thunder line', 2), ('Universe Note', 1)]	7810	71.22	37.8202452	145.0149442	10	7100.22	Spring		2.0752	stolen phone sold us a stolen phone so we couldn't activate it. we ended up returning it and just purchasing a new one through our phone plan.
ORD337984	ID3394768956	2019-09-14	Thompson	[('Candle Inferno', 1), ('Alcon 10', 1), ('Toshika 750', 1)]	13700	74.84	-37.8077429	144.9515704	5	13089.84	Spring		0.6767	love our inferno stick,easy to set up and have loads of shows for free and plenty to rent or buy.we also use pluto tv and tubi so that's even more tv.iassist makes it so easy to find any show or movie i want.we love the money we save.	true
ORD072312	ID0774517121	2019-05-23	Thompson	[('Universe Note', 1), ('Thunder line', 2), ('iStream', 1)]	7960	52.28	-37.8063372	144.9595445	5	10789.79	Autumn		1.3043	it sucks mine came with dead pixels
ORD377837	ID4769265355	2019-10-09	Bakers	[('Alcon 10', 2), ('Thunder line', 1), ('Candle Inferno', 2), ('iAssist Line', 2)]	25390	107.58	-37.8108099	145.0140735	10	22958.58	Spring	true	1.6595	this is how top phone should look like! super fast phone. overall no single issue found. or at last i did not consider. works flawless. super slim design is amazing. screen color and brightness tuned perfectly. best phone for sure	true
ORD462194	ID5301568579	2019-03-21	Thompson	[('Universe Note', 1), ('Lucent 330S', 1), ('Toshika 750', 2)]	13320	62.26	-37.808675	144.9423368	15	11384.26	winter	true	0.6093	does not live up to its reputation. customer service at olivia is the worst. phone is horrible. do not buy this phone. the touch response is bad. customer service is horrible at olivia stay away.


CREATE TABLE dirty_data (
  "order_id" VARCHAR,
  "customer_id" VARCHAR,
  "date" VARCHAR,
  "nearest_warehouse" VARCHAR,
  "shopping_cart" VARCHAR,
  "order_price" BIGINT,
  "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" BOOLEAN
);