Sales Of A Supermarket

Record of sales data in three different supermarkets.

@kaggle.lovishbansal123_sales_of_a_supermarket

Table List

1 table(61.58 KB)

Supermarket Sales

@kaggle.lovishbansal123_sales_of_a_supermarket.supermarket_sales

61.58 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%	total Total	date Date	time Time	payment Payment	cogs Cogs	gross_margin_percentage Gross Margin Percentage	gross_income Gross Income	rating Rating
750-67-8428	A	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)	13:08	Ewallet	522.83	4.761904762	26.1415	9.1
226-31-3081	C	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	Cash	76.4	4.761904762	3.82	9.6
631-41-3108	A	Yangon	Normal	Male	Home and lifestyle	46.33	7	16.2155	340.5255	Sun Mar 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	13:23	Credit card	324.31	4.761904762	16.2155	7.4
123-19-1176	A	Yangon	Member	Male	Health and beauty	58.22	8	23.288	489.048	Sun Jan 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	20:33	Ewallet	465.76	4.761904762	23.288	8.4
373-73-7910	A	Yangon	Normal	Male	Sports and travel	86.31	7	30.2085	634.3785	Fri Feb 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	10:37	Ewallet	604.17	4.761904762	30.2085	5.3
699-14-3026	C	Naypyitaw	Normal	Male	Electronic accessories	85.39	7	29.8865	627.6165	Mon Mar 25 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	18:30	Ewallet	597.73	4.761904762	29.8865	4.1
355-53-5943	A	Yangon	Member	Female	Electronic accessories	68.84	6	20.652	433.692	Mon Feb 25 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	14:36	Ewallet	413.04	4.761904762	20.652	5.8
315-22-5665	C	Naypyitaw	Normal	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	Ewallet	735.6	4.761904762	36.78	8
665-32-9167	A	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)	17:15	Credit card	72.52	4.761904762	3.626	7.2
692-92-5582	B	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)	13:27	Credit card	164.52	4.761904762	8.226	5.9


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