Global Superstore Dataset

This notebook is a processed version of the Global SuperStore dataset.

@kaggle.fatihilhan_global_superstore_dataset

Table List

1 table(2.03 MB)

Superstore

@kaggle.fatihilhan_global_superstore_dataset.superstore

2.03 MB
51290 rows
27 columns

category Category	city City	country Country	customer_id Customer.ID	customer_name Customer.Name	market Market	n 记录数	order_date Order.Date	order_id Order.ID	order_priority Order.Priority	product_id Product.ID	product_name Product.Name	profit Profit	quantity Quantity	region Region	row_id Row.ID	sales Sales	segment Segment	ship_date Ship.Date	ship_mode Ship.Mode	shipping_cost Shipping.Cost	state State	sub_category Sub.Category	year Year	market2 Market2	weeknum Weeknum
Office Supplies	Los Angeles	United States	LS-172304	Lycoris Saunders	US	1	Fri Jan 07 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	CA-2011-130813	High	OFF-PA-10002005	Xerox 225	9.3312	3	West	36624	19	Consumer	Sun Jan 09 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Second Class	4.37	California	Paper	2011	North America	2
Office Supplies	Los Angeles	United States	MV-174854	Mark Van Huff	US	1	Fri Jan 21 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	CA-2011-148614	Medium	OFF-PA-10002893	Wirebound Service Call Books, 5 1/2" x 4"	9.2928	2	West	37033	19	Consumer	Wed Jan 26 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Standard Class	0.94	California	Paper	2011	North America	4
Office Supplies	Los Angeles	United States	CS-121304	Chad Sievert	US	1	Fri Aug 05 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	CA-2011-118962	Medium	OFF-PA-10000659	Adams Phone Message Book, Professional, 400 Message Capacity, 5 3/6” x 11”	9.8418	3	West	31468	21	Consumer	Tue Aug 09 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Standard Class	1.81	California	Paper	2011	North America	32
Office Supplies	Los Angeles	United States	CS-121304	Chad Sievert	US	1	Fri Aug 05 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	CA-2011-118962	Medium	OFF-PA-10001144	Xerox 1913	53.2608	2	West	31469	111	Consumer	Tue Aug 09 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Standard Class	4.59	California	Paper	2011	North America	32
Office Supplies	Los Angeles	United States	AP-109154	Arthur Prichep	US	1	Thu Sep 29 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	CA-2011-146969	High	OFF-PA-10002105	Xerox 223	3.1104	1	West	32440	6	Consumer	Mon Oct 03 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Standard Class	1.32	California	Paper	2011	North America	40
Office Supplies	Los Angeles	United States	JF-154904	Jeremy Farry	US	1	Wed Oct 19 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	CA-2011-117317	Critical	OFF-PA-10004519	Spiral Phone Message Books with Labels by Adams	6.5856	3	West	32890	13	Consumer	Wed Oct 19 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Same Day	2.39	California	Paper	2011	North America	43
Office Supplies	Los Angeles	United States	WB-218504	William Brown	US	1	Fri Nov 04 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	CA-2011-125829	Medium	OFF-PA-10000223	Xerox 2000	9.3312	3	West	35608	19	Consumer	Fri Nov 11 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Standard Class	1.15	California	Paper	2011	North America	45
Office Supplies	Los Angeles	United States	JA-159704	Joseph Airdo	US	1	Sat Nov 12 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	CA-2011-151295	High	OFF-PA-10001947	Xerox 1974	5.8604	2	West	33709	12	Consumer	Wed Nov 16 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Standard Class	0.92	California	Paper	2011	North America	46
Office Supplies	Los Angeles	United States	SP-209204	Susan Pistek	US	1	Tue Nov 22 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	CA-2011-135090	High	OFF-PA-10002245	Xerox 1895	24.219	9	West	35267	54	Consumer	Sat Nov 26 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Standard Class	6.98	California	Paper	2011	North America	48
Office Supplies	Los Angeles	United States	RL-196154	Rob Lucas	US	1	Mon Dec 05 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	CA-2011-133830	Medium	OFF-PA-10001363	Xerox 1933	23.0864	4	West	38866	49	Consumer	Sat Dec 10 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Standard Class	1.99	California	Paper	2011	North America	50


CREATE TABLE superstore (
  "category" VARCHAR,
  "city" VARCHAR,
  "country" VARCHAR,
  "customer_id" VARCHAR,
  "customer_name" VARCHAR,
  "discount" DOUBLE,
  "market" VARCHAR,
  "n" BIGINT,
  "order_date" TIMESTAMP,
  "order_id" VARCHAR,
  "order_priority" VARCHAR,
  "product_id" VARCHAR,
  "product_name" VARCHAR,
  "profit" DOUBLE,
  "quantity" BIGINT,
  "region" VARCHAR,
  "row_id" BIGINT,
  "sales" BIGINT,
  "segment" VARCHAR,
  "ship_date" TIMESTAMP,
  "ship_mode" VARCHAR,
  "shipping_cost" DOUBLE,
  "state" VARCHAR,
  "sub_category" VARCHAR,
  "year" BIGINT,
  "market2" VARCHAR,
  "weeknum" BIGINT
);