amazon_sales_dataset.xlsx

Amazon dataset was retrieved from data.world, an open-access repository. Created by @revanthkrishnaa.The DataSet contains historical sales data for 45 Amazon stores located in different regions.<b>Dataset Description</b>The DataSet contains historical sales data for 45 Amazon stores located in different regions. Each store contains a number of departments, and have to predict the department-wide sales for each store.In addition, Amazon runs several promotional markdown events throughout the year. These markdowns precede prominent holidays, the four largest of which are the Super Bowl, Labor Day, Thanksgiving, and Christmas. The weeks including these holidays are weighted five times higher in the evaluation than non-holiday weeks. Part of the Dataset is modeling the effects of markdowns on these holiday weeks in the absence of complete/ideal historical data.This file contains anonymized information about the 45 stores, indicating the type and size of store.This is the historical training data, which covers to 2019-02-05 to 2021-11-01. Within this file you following are the different fields:Store - the store number<br>Dept - the department number<br>Date - the week<br>Weekly_Sales - sales for the given department in the given store IsHoliday - whether the week is a special holiday week Temperature - average temperature in the region Fuel_Price - cost of fuel in the region<br>MarkDown1-5 - anonymized data related to promotional markdowns that Amazon is running. MarkDown data is only available after Nov 2020 and is not available for all stores all the time. Any missing value is marked with an NA.<br>CPI - the consumer price index<br>Unemployment - the unemployment rate<br>For convenience, the four holidays fall within the following weeks in the dataset (not all holidays are in the data):Super Bowl: 12-Feb-19, 11-Feb-20, 10-Feb-21, 8-Feb-18<br>Labor Day: 10-Sep-19, 9-Sep-20, 7-Sep-21, 6-Sep-18<br>Thanksgiving: 26-Nov-19, 25-Nov-20, 23-Nov-21, 29-Nov-18<br>Christmas: 31-Dec-19, 30-Dec-20, 28-Dec-21, 27-Dec-18Show less<br>

本数据集源自开源仓库data.world，由创作者@revanthkrishnaa构建。该数据集收录了分布于不同区域的45家亚马逊（Amazon）门店的历史销售数据。
数据集说明：
该数据集包含分布于不同区域的45家亚马逊门店的历史销售数据，每家门店下设多个部门，任务目标为预测各门店全部门的整体销售额。此外，亚马逊全年会举办多场促销降价活动，此类活动通常在重要节假日之前开展，其中规模最大的四个节假日分别为超级碗（Super Bowl）、劳动节（Labor Day）、感恩节（Thanksgiving）与圣诞节（Christmas）。在模型评估环节，包含上述节假日的周度数据权重为非节假日周的五倍。本数据集的部分内容用于建模在缺乏完整或理想历史数据的前提下，促销降价对节假日周销售额的影响。
本文件包含45家门店的匿名化信息，标注了各门店的类型与规模。
本文件为历史训练数据，覆盖时段为2019-02-05至2021-11-01。文件内包含以下字段：
- Store：门店编号
- Dept：部门编号
- Date：周度日期
- Weekly_Sales：对应门店、对应部门的周度销售额
- IsHoliday：该周是否为特殊节假日周
- Temperature：区域平均气温
- Fuel_Price：区域燃油价格
- MarkDown1-5：与亚马逊开展的促销降价活动相关的匿名化数据。此类降价数据仅在2020年11月之后可获取，且并非所有门店在所有时段均可获得相关数据，缺失值以NA标记。
- CPI：消费者物价指数（CPI）
- Unemployment：失业率
为便于参考，数据集中的四个节假日对应周度如下（注：数据中并非包含所有上述节假日）：
- 超级碗：2019-02-12、2020-02-11、2021-02-10、2018-02-08
- 劳动节：2019-09-10、2020-09-09、2021-09-07、2018-09-06
- 感恩节：2019-11-26、2020-11-25、2021-11-23、2018-11-29
- 圣诞节：2019-12-31、2020-12-30、2021-12-28、2018-12-27