Retail Supermarket

Supermarket store data

@kaggle.roopacalistus_superstore

Table List

1 table(175.44 KB)

Samplesuperstore

@kaggle.roopacalistus_superstore.samplesuperstore

175.44 KB
9994 rows
13 columns

ship_mode Ship Mode	segment Segment	country Country	city City	state State	postal_code Postal Code	region Region	category Category	sub_category Sub-Category	sales Sales	quantity Quantity	discount Discount	profit Profit
Second Class	Consumer	United States	Henderson	Kentucky	42420	South	Furniture	Bookcases	261.96	2		41.9136
Second Class	Consumer	United States	Henderson	Kentucky	42420	South	Furniture	Chairs	731.94	3		219.582
Second Class	Corporate	United States	Los Angeles	California	90036	West	Office Supplies	Labels	14.62	2		6.8714
Standard Class	Consumer	United States	Fort Lauderdale	Florida	33311	South	Furniture	Tables	957.5775	5	0.45	-383.031
Standard Class	Consumer	United States	Fort Lauderdale	Florida	33311	South	Office Supplies	Storage	22.368	2	0.2	2.5164
Standard Class	Consumer	United States	Los Angeles	California	90032	West	Furniture	Furnishings	48.86	7		14.1694
Standard Class	Consumer	United States	Los Angeles	California	90032	West	Office Supplies	Art	7.28	4		1.9656
Standard Class	Consumer	United States	Los Angeles	California	90032	West	Technology	Phones	907.152	6	0.2	90.7152
Standard Class	Consumer	United States	Los Angeles	California	90032	West	Office Supplies	Binders	18.504	3	0.2	5.7825
Standard Class	Consumer	United States	Los Angeles	California	90032	West	Office Supplies	Appliances	114.9	5		34.47


CREATE TABLE samplesuperstore (
  "ship_mode" VARCHAR,
  "segment" VARCHAR,
  "country" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "postal_code" BIGINT,
  "region" VARCHAR,
  "category" VARCHAR,
  "sub_category" VARCHAR,
  "sales" DOUBLE,
  "quantity" BIGINT,
  "discount" DOUBLE,
  "profit" DOUBLE
);