Retail Data Analytics

Historical sales data from 45 stores

@kaggle.manjeetsingh_retaildataset

Table List

3 tables(2.68 MB)

Features Data Set

Sales Data Set

Stores Data Set

Features Data Set

@kaggle.manjeetsingh_retaildataset.features_data_set

205.4 KB
8190 rows
12 columns

store Store	date Date	temperature Temperature	fuel_price Fuel Price	cpi CPI	unemployment Unemployment	isholiday IsHoliday
1	Fri Feb 05 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	42.31	2.572	211.0963582	8.106
1	Fri Feb 12 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	38.51	2.548	211.2421698	8.106	true
1	Fri Feb 19 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	39.93	2.514	211.2891429	8.106
1	Fri Feb 26 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	46.63	2.561	211.3196429	8.106
1	Fri Mar 05 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	46.5	2.625	211.3501429	8.106
1	Fri Mar 12 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	57.79	2.667	211.3806429	8.106
1	Fri Mar 19 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	54.58	2.72	211.215635	8.106
1	Fri Mar 26 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	51.45	2.732	211.0180424	8.106
1	Fri Apr 02 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	62.27	2.719	210.8204499	7.808
1	Fri Apr 09 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	65.86	2.77	210.6228574	7.808


CREATE TABLE features_data_set (
  "store" BIGINT,
  "date" TIMESTAMP,
  "temperature" DOUBLE,
  "fuel_price" DOUBLE,
  "markdown1" DOUBLE,
  "markdown2" DOUBLE,
  "markdown3" DOUBLE,
  "markdown4" DOUBLE,
  "markdown5" DOUBLE,
  "cpi" DOUBLE,
  "unemployment" DOUBLE,
  "isholiday" BOOLEAN
);