拼多多平台红领巾商品优势型号识别数据

根据红领巾商品在拼多多平台的销售情况，计算出基于材质特征（棉布、纯棉）和长度特征（1.2米、1米）的各种型号红领巾的销售占比，识别出优势型号，有助于本公司及同行业内其他生产、销售红领巾商品的企业制定、优化营销、仓储、物流和供应链方案。1.数据收集和预处理：（1）数据收集：收集公司在拼多多平台上红领巾商品订单信息，包括商品类目、商品名称、销售渠道/平台、订单编号、购买数量、材质特征、长度特征。（2）数据预处理：对收集的原始数据进行清洗。
2.计算销售总量：利用SUM函数将历史采集的购买数量累加计算出红领巾商品销售总量。
3.基于图案特征识别优势型号：（1）筛选材质特征为卡棉布的订单，利用SUM函数将购买数”累加计算出棉布红领巾销售总量，并计算出销售占比=棉布红领巾销售总量/红领巾商品销售总量*100%。同理，计算纯棉红领巾销售总量及占比。（2）比较两种材质的销售占比，较大的为基于材质特征的优势型号。
4.基于长度特征识别优势型号：（1）筛选长度特征为1.2米红领巾的订单，利用SUM函数将购买数量累加计算出1.2米红领巾销售总量，并计算出销售占比=1.2米红领巾销售总量/红领巾商品销售总量*100%。同理，计算1米红领巾销售总量及占比。（2）比较两种长度特征的销售占比，较大的为基于长度特征的优势型号。

Based on the sales performance of red scarf products on the Pinduoduo platform, this work calculates the sales proportion of various red scarf models based on material characteristics (cotton cloth, pure cotton) and length characteristics (1.2m, 1m), and identifies the dominant models. This will assist both our company and other enterprises engaged in the production and sales of red scarf products in the same industry to formulate and optimize marketing, warehousing, logistics and supply chain solutions.

1. Data Collection and Preprocessing:
(1) Data Collection: Collect the order information of the company's red scarf products on the Pinduoduo platform, including product category, product name, sales channel/platform, order number, purchase quantity, material characteristics, and length characteristics.
(2) Data Preprocessing: Clean the collected raw data.

2. Calculate Total Sales Volume: Use the SUM function to accumulate the historically collected purchase quantities to calculate the total sales volume of red scarf products.

3. Identify Dominant Models Based on Material Characteristics:
(1) Filter orders with cotton cloth as the material characteristic, use the SUM function to accumulate the purchase quantities to calculate the total sales volume of cotton cloth red scarves, and calculate the sales proportion = (total sales volume of cotton cloth red scarves / total sales volume of red scarf products) * 100%. Similarly, calculate the total sales volume and sales proportion of pure cotton red scarves.
(2) Compare the sales proportions of the two material types, and the one with the higher proportion is the dominant model based on material characteristics.

4. Identify Dominant Models Based on Length Characteristics:
(1) Filter orders for 1.2m red scarves, use the SUM function to accumulate the purchase quantities to calculate the total sales volume of 1.2m red scarves, and calculate the sales proportion = (total sales volume of 1.2m red scarves / total sales volume of red scarf products) * 100%. Similarly, calculate the total sales volume and sales proportion of 1m red scarves.
(2) Compare the sales proportions of the two length characteristics, and the one with the higher proportion is the dominant model based on length characteristics.

搜集汇总

数据集介绍

特点

该数据集包含拼多多平台红领巾商品的销售信息，通过分析材质和长度特征的销售占比，识别出优势型号，适用于优化营销、仓储和供应链方案。