京东平台胸牌商品优势型号识别数据

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

Based on the sales data of badge products on the JD.com platform, this work calculates the sales proportions of various badge models based on two feature dimensions: fastening types (pin, magnetic) and sizes (large, small), and identifies the dominant models. This helps enterprises including our company and other peers in the badge production and sales 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 badge products on the JD.com platform from our company, including product category, product name, sales channel/platform, order number, purchase quantity, fastening feature and size feature.
(2) Data Preprocessing: Clean the collected raw data.
2. Calculate Total Sales Volume: Use the SUM function to accumulate the collected historical purchase quantities to calculate the total sales volume of badge products.
3. Identify Dominant Models Based on Fastening Features:
(1) Filter orders with the fastening type of pin, use the SUM function to accumulate the purchase quantities to calculate the total sales volume of pin badges, and calculate the sales proportion = total sales volume of pin badges / total sales volume of badge products * 100%. Similarly, calculate the total sales volume and proportion of magnetic badges.
(2) Compare the sales proportions of the two fastening types, and the one with the higher proportion is the dominant model based on the fastening feature.
4. Identify Dominant Models Based on Size Features:
(1) Filter orders with the size feature of large badges, use the SUM function to accumulate the purchase quantities to calculate the total sales volume of large badges, and calculate the sales proportion = total sales volume of large badges / total sales volume of badge products * 100%. Similarly, calculate the total sales volume and proportion of small badges.
(2) Compare the sales proportions of the two size features, and the one with the higher proportion is the dominant model based on the size feature.

搜集汇总

数据集介绍

特点

该数据集包含519条京东平台胸牌商品的销售数据，每日更新，用于识别基于固定方式特征和尺寸特征的优势型号，帮助企业优化营销和供应链管理。