Supermarket Dataset

your go-to destination for analyzing retail transactions

@kaggle.saurabhbadole_supermarket_data

Table List

1 table(3.42 MB)

Supermarket Data

@kaggle.saurabhbadole_supermarket_data.supermarket_data

3.42 MB
541910 rows
8 columns

invoice Invoice	stockcode StockCode	description Description	quantity Quantity	invoicedate InvoiceDate	price Price	customer_id Customer ID	country Country
536365	85123A	WHITE HANGING HEART T-LIGHT HOLDER	6	01/12/10 08:26	2.55	17850	United Kingdom
536365	71053	WHITE METAL LANTERN	6	01/12/10 08:26	3.39	17850	United Kingdom
536365	84406B	CREAM CUPID HEARTS COAT HANGER	8	01/12/10 08:26	2.75	17850	United Kingdom
536365	84029G	KNITTED UNION FLAG HOT WATER BOTTLE	6	01/12/10 08:26	3.39	17850	United Kingdom
536365	84029E	RED WOOLLY HOTTIE WHITE HEART.	6	01/12/10 08:26	3.39	17850	United Kingdom
536365	22752	SET 7 BABUSHKA NESTING BOXES	2	01/12/10 08:26	7.65	17850	United Kingdom
536365	21730	GLASS STAR FROSTED T-LIGHT HOLDER	6	01/12/10 08:26	4.25	17850	United Kingdom
536366	22633	HAND WARMER UNION JACK	6	01/12/10 08:28	1.85	17850	United Kingdom
536366	22632	HAND WARMER RED POLKA DOT	6	01/12/10 08:28	1.85	17850	United Kingdom
536368	22960	JAM MAKING SET WITH JARS	6	01/12/10 08:34	4.25	13047	United Kingdom


CREATE TABLE supermarket_data (
  "invoice" VARCHAR,
  "stockcode" VARCHAR,
  "description" VARCHAR,
  "quantity" BIGINT,
  "invoicedate" VARCHAR,
  "price" DOUBLE,
  "customer_id" DOUBLE,
  "country" VARCHAR
);