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家亚马逊门店的历史销售数据。

**数据集说明**
该数据集包含分布于不同区域的45家亚马逊门店的历史销售数据，每家门店下设多个部门，任务目标为预测各门店全部门的整体销售额。此外，亚马逊每年会举办多场促销降价活动，此类活动多在重大节假日前夕开展，其中影响力最大的四项节假日分别为超级碗（Super Bowl）、劳动节（Labor Day）、感恩节（Thanksgiving）与圣诞节（Christmas）。在模型评估中，包含上述节假日的周次权重为非节假日周的五倍。本数据集的部分任务为：在缺乏完整/理想历史数据的前提下，建模促销降价活动对上述节假日周的影响。

本文件包含45家门店的匿名化信息，标注了各门店的类型与规模。本次提供的历史训练数据覆盖时段为2019年2月5日至2021年11月1日。该文件包含以下字段：
- Store：门店编号
- Dept：部门编号
- Date：周度日期
- Weekly_Sales：指定门店指定部门的周度销售额
- IsHoliday：该周是否为特殊节假日周
- Temperature：该区域的平均气温
- Fuel_Price：该区域的燃油价格
- MarkDown1-5：与亚马逊正在开展的促销降价活动相关的匿名化数据。此类降价数据仅在2020年11月之后可获取，且并非所有门店在所有时段都有对应数据，缺失值以NA标记。
- CPI：消费者价格指数（Consumer Price Index）
- Unemployment：失业率

为便于使用，本数据集中的四项节假日对应周次如下（并非所有数据集都包含全部节假日数据）：
- 超级碗（Super Bowl）：2019-02-12、2020-02-11、2021-02-10、2018-02-08
- 劳动节（Labor Day）：2019-09-10、2020-09-09、2021-09-07、2018-09-06
- 感恩节（Thanksgiving）：2019-11-26、2020-11-25、2021-11-23、2018-11-29
- 圣诞节（Christmas）：2019-12-31、2020-12-30、2021-12-28、2018-12-27