天猫平台中性笔商品优势型号识别数据

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

According to the sales data of gel pen products on the Tmall platform, calculate the sales proportion of various gel pen models based on color characteristics (black, blue, red) and core-out mode characteristics (rotary, push-button), and identify the dominant models. This will assist enterprises in our company and other gel pen manufacturers and sellers 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 gel pen products on the Tmall platform, including product category, product name, sales channel/platform, order number, purchase quantity, color characteristics, and core-out mode characteristics.
(2) Data Preprocessing: Clean the collected raw data.

2. Calculation of Total Sales Volume: Use the SUM function to accumulate the historically collected purchase quantities to calculate the total sales volume of gel pen products.

3. Identification of Dominant Models Based on Color Characteristics:
(1) Filter the orders with black as the color characteristic, use the SUM function to accumulate the purchase quantities to calculate the total sales volume of black gel pens, and calculate the sales proportion = total sales volume of black gel pens / total sales volume of gel pen products * 100%. Similarly, calculate the total sales volume and sales proportion of blue and red gel pens.
(2) Compare the sales proportions of the three colors, and the one with the largest proportion is the dominant model based on color characteristics.

4. Identification of Dominant Models Based on Core-out Mode Characteristics:
(1) Filter the orders with rotary core-out mode, use the SUM function to accumulate the purchase quantities to calculate the total sales volume of rotary gel pens, and calculate the sales proportion = total sales volume of rotary gel pens / total sales volume of gel pen products * 100%. Similarly, calculate the total sales volume and sales proportion of push-button gel pens.
(2) Compare the sales proportions of the two core-out mode characteristics, and the one with the larger proportion is the dominant model based on core-out mode characteristics.

搜集汇总

背景与挑战

背景概述

该数据集包含天猫平台中性笔商品的销售数据，共计512条记录，每日更新。数据集通过分析颜色特征（黑色、蓝色、红色）和出芯方式特征（旋转、按动）的销售占比，识别出优势型号，适用于生产、销售中性笔商品的企业优化营销、仓储、物流和供应链方案。