Supermarket Sales Dataset

Data Analysis Dataset

@kaggle.faresashraf1001_supermarket_sales

Table List

1 table(62.29 KB)

Supermarket Analysis

@kaggle.faresashraf1001_supermarket_sales.supermarket_analysis

62.29 KB
1000 rows
17 columns

invoice_id Invoice ID	branch Branch	city City	customer_type Customer Type	gender Gender	product_line Product Line	unit_price Unit Price	quantity Quantity	tax_5 Tax 5%	sales Sales	date Date	time Time	payment Payment	cogs Cogs	gross_margin_percentage Gross Margin Percentage	gross_income Gross Income	rating Rating
750-67-8428	Alex	Yangon	Member	Female	Health and beauty	74.69	7	26.1415	548.9715	Sat Jan 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1:08:00 PM	Ewallet	522.83	4.761904762	26.1415	9.1
226-31-3081	Giza	Naypyitaw	Normal	Female	Electronic accessories	15.28	5	3.82	80.22	Fri Mar 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	10:29:00 AM	Cash	76.4	4.761904762	3.82	9.6
631-41-3108	Alex	Yangon	Normal	Female	Home and lifestyle	46.33	7	16.2155	340.5255	Sun Mar 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1:23:00 PM	Credit card	324.31	4.761904762	16.2155	7.4
123-19-1176	Alex	Yangon	Member	Female	Health and beauty	58.22	8	23.288	489.048	Sun Jan 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	8:33:00 PM	Ewallet	465.76	4.761904762	23.288	8.4
373-73-7910	Alex	Yangon	Member	Female	Sports and travel	86.31	7	30.2085	634.3785	Fri Feb 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	10:37:00 AM	Ewallet	604.17	4.761904762	30.2085	5.3
699-14-3026	Giza	Naypyitaw	Member	Female	Electronic accessories	85.39	7	29.8865	627.6165	Mon Mar 25 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	6:30:00 PM	Ewallet	597.73	4.761904762	29.8865	4.1
355-53-5943	Alex	Yangon	Member	Female	Electronic accessories	68.84	6	20.652	433.692	Mon Feb 25 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	2:36:00 PM	Ewallet	413.04	4.761904762	20.652	5.8
315-22-5665	Giza	Naypyitaw	Member	Female	Home and lifestyle	73.56	10	36.78	772.38	Sun Feb 24 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	11:38:00 AM	Ewallet	735.6	4.761904762	36.78	8
665-32-9167	Alex	Yangon	Member	Female	Health and beauty	36.26	2	3.626	76.146	Thu Jan 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	5:15:00 PM	Credit card	72.52	4.761904762	3.626	7.2
692-92-5582	Cairo	Mandalay	Member	Female	Food and beverages	54.84	3	8.226	172.746	Wed Feb 20 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1:27:00 PM	Credit card	164.52	4.761904762	8.226	5.9


CREATE TABLE supermarket_analysis (
  "invoice_id" VARCHAR,
  "branch" VARCHAR,
  "city" VARCHAR,
  "customer_type" VARCHAR,
  "gender" VARCHAR,
  "product_line" VARCHAR,
  "unit_price" DOUBLE,
  "quantity" BIGINT,
  "tax_5" DOUBLE,
  "sales" DOUBLE,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "payment" VARCHAR,
  "cogs" DOUBLE,
  "gross_margin_percentage" DOUBLE,
  "gross_income" DOUBLE,
  "rating" DOUBLE
);