Superstore Sales Dataset

Predict Sales using Time Series

@kaggle.rohitsahoo_sales_forecasting

Table List

1 table(385.84 KB)

Train

@kaggle.rohitsahoo_sales_forecasting.train

385.84 KB
9800 rows
18 columns

row_id Row ID	order_id Order ID	order_date Order Date	ship_date Ship Date	ship_mode Ship Mode	customer_id Customer ID	customer_name Customer Name	segment Segment	country Country	city City	state State	postal_code Postal Code	region Region	product_id Product ID	category Category	sub_category Sub-Category	product_name Product Name	sales Sales
1	CA-2017-152156	Wed Nov 08 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Nov 11 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Second Class	CG-12520	Claire Gute	Consumer	United States	Henderson	Kentucky	42420	South	FUR-BO-10001798	Furniture	Bookcases	Bush Somerset Collection Bookcase	261.96
2	CA-2017-152156	Wed Nov 08 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Nov 11 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Second Class	CG-12520	Claire Gute	Consumer	United States	Henderson	Kentucky	42420	South	FUR-CH-10000454	Furniture	Chairs	Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back	731.94
3	CA-2017-138688	Mon Jun 12 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 16 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Second Class	DV-13045	Darrin Van Huff	Corporate	United States	Los Angeles	California	90036	West	OFF-LA-10000240	Office Supplies	Labels	Self-Adhesive Address Labels for Typewriters by Universal	14.62
4	US-2016-108966	Tue Oct 11 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Oct 18 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Standard Class	SO-20335	Sean O'Donnell	Consumer	United States	Fort Lauderdale	Florida	33311	South	FUR-TA-10000577	Furniture	Tables	Bretford CR4500 Series Slim Rectangular Table	957.5775
5	US-2016-108966	Tue Oct 11 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Oct 18 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Standard Class	SO-20335	Sean O'Donnell	Consumer	United States	Fort Lauderdale	Florida	33311	South	OFF-ST-10000760	Office Supplies	Storage	Eldon Fold 'N Roll Cart System	22.368
6	CA-2015-115812	Tue Jun 09 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 14 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Standard Class	BH-11710	Brosina Hoffman	Consumer	United States	Los Angeles	California	90032	West	FUR-FU-10001487	Furniture	Furnishings	Eldon Expressions Wood and Plastic Desk Accessories, Cherry Wood	48.86
7	CA-2015-115812	Tue Jun 09 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 14 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Standard Class	BH-11710	Brosina Hoffman	Consumer	United States	Los Angeles	California	90032	West	OFF-AR-10002833	Office Supplies	Art	Newell 322	7.28
8	CA-2015-115812	Tue Jun 09 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 14 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Standard Class	BH-11710	Brosina Hoffman	Consumer	United States	Los Angeles	California	90032	West	TEC-PH-10002275	Technology	Phones	Mitel 5320 IP Phone VoIP phone	907.152
9	CA-2015-115812	Tue Jun 09 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 14 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Standard Class	BH-11710	Brosina Hoffman	Consumer	United States	Los Angeles	California	90032	West	OFF-BI-10003910	Office Supplies	Binders	DXL Angle-View Binders with Locking Rings by Samsill	18.504
10	CA-2015-115812	Tue Jun 09 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 14 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Standard Class	BH-11710	Brosina Hoffman	Consumer	United States	Los Angeles	California	90032	West	OFF-AP-10002892	Office Supplies	Appliances	Belkin F5C206VTEL 6 Outlet Surge	114.9


CREATE TABLE train (
  "row_id" BIGINT,
  "order_id" VARCHAR,
  "order_date" TIMESTAMP,
  "ship_date" TIMESTAMP,
  "ship_mode" VARCHAR,
  "customer_id" VARCHAR,
  "customer_name" VARCHAR,
  "segment" VARCHAR,
  "country" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "postal_code" DOUBLE,
  "region" VARCHAR,
  "product_id" VARCHAR,
  "category" VARCHAR,
  "sub_category" VARCHAR,
  "product_name" VARCHAR,
  "sales" DOUBLE
);