MSA案例

【数据描述】
某礼品批发电商平台一年内的订单。其中包含三个文件：
ecommercedata-历史订单.xlsx：该文件包含网站一年的历史订单。此文件用于创造训练集的原数据。
ecommercedata-预测.xlsx：该文件包含网站在第13个月下单的客户ID。此文件用于预测销售情况。
ecommercedata-预测参考答案.xlsx: 该文件包含网站在第13个月下单的客户的购买情况。其中，产品代码列的“0/1”含义是该顾客是否购买该产品，购买为1、反之为0.

InvoiceNo: 发票号码，每笔交易分配唯一的6位整数。退货订单的代码以字母'c'开头。
StockCode: 产品代码，每个不同的产品分配唯一的5位整数。
Description: 产品描述。
Quantity: 每笔交易的每件产品数量。
InvoiceDate: 交易日期和时间。
UnitPrice: 单价（英镑）。
CustomerID:顾客ID。
Country: 客户所在国家/地区。

Data Description:
One year of order data from a gift wholesale e-commerce platform, which includes three files:
1. ecommercedata-Historical Orders.xlsx: This file contains one year of historical orders from the website, and is used as the raw data for creating the training set.
2. ecommercedata-Prediction.xlsx: This file contains the customer IDs of customers who placed orders on the website in the 13th month, and is used for sales forecasting.
3. ecommercedata-Prediction Reference Answer.xlsx: This file contains the purchase status of customers who placed orders in the 13th month on the website. The meaning of "0/1" in the product code column is: 1 indicates that the customer purchased the corresponding product, while 0 indicates no purchase.

Detailed field explanations are listed below:
- InvoiceNo: Invoice number, a unique 6-digit integer assigned to each transaction. Return orders are prefixed with the letter 'c'.
- StockCode: Product code, a unique 5-digit integer assigned to each distinct product.
- Description: Product description.
- Quantity: Quantity of each product per transaction.
- InvoiceDate: Transaction date and time.
- UnitPrice: Unit price (British Pound).
- CustomerID: Customer ID.
- Country: Customer's country/region.

搜集汇总

背景与挑战

背景概述

该数据集为某礼品批发电商平台的一年订单数据，包含历史订单、预测数据及参考答案，涉及产品代码、交易数量、顾客ID等多维度信息，适用于销售预测分析等场景。