天猫平台证件挂绳商品优势型号识别数据

根据证件挂绳商品在天猫平台的销售情况，计算出基于宽度特征（1cm、1.5cm、2cm）和伸缩特征（可伸缩、不可伸缩）的各种型号证件挂绳的销售占比，识别出优势型号，有助于本公司及同行业内其他生产、销售证件挂绳商品的企业制定、优化营销、仓储、物流和供应链方案。1.数据收集和预处理：（1）数据收集：收集公司在天猫平台上证件挂绳商品订单信息，包括商品类目、商品名称、销售渠道/平台、订单编号、购买数量、宽度特征、伸缩特征。（2）数据预处理：对收集的原始数据进行清洗。 2.计算销售总量：利用SUM函数将历史采集的购买数量累加计算出证件挂绳商品销售总量。 3.基于宽度特征识别优势型号：（1）筛选宽度特征为1cm的订单，利用SUM函数将购买数”累加计算出1cm证件挂绳销售总量，并计算出销售占比=1cm证件挂绳销售总量/证件挂绳商品销售总量*100%。同理，计算1.5cm、2cm证件挂绳销售总量及占比。（2）比较三种宽度的销售占比，最大的为基于宽度特征的优势型号。 4.基于伸缩特征识别优势型号：（1）筛选伸缩特征为可伸缩的订单，利用SUM函数将购买数量累加计算出可伸缩证件挂绳销售总量，并计算出销售占比=可伸缩证件挂绳销售总量/证件挂绳商品销售总量*100%。同理，计算配不可伸缩证件挂绳销售总量及占比。（2）比较两种伸缩特征的销售占比，较大的为基于伸缩特征的优势型号。Based on the sales data of ID card lanyard products on the Tmall platform, calculate the sales proportion of various models of ID card lanyards based on the width features (1cm, 1.5cm, 2cm) and retractable features (retractable, non-retractable), and identify the dominant models. This will help enterprises in our company and other manufacturers and sellers of ID card lanyard 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 ID card lanyard products on the Tmall platform, including product category, product name, sales channel/platform, order number, purchase quantity, width feature, and retractable feature. (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 ID card lanyard products. 3. Identify Dominant Models Based on Width Features: (1) Filter the orders with the width feature of 1cm, use the SUM function to accumulate the purchase quantities to calculate the total sales volume of 1cm ID card lanyards, and calculate the sales proportion = total sales volume of 1cm ID card lanyards / total sales volume of ID card lanyard products * 100%. Similarly, calculate the total sales volume and proportion of 1.5cm and 2cm ID card lanyards. (2) Compare the sales proportions of the three width types, and the one with the largest proportion is the dominant model based on the width feature. 4. Identify Dominant Models Based on Retractable Features: (1) Filter the orders with the retractable feature, use the SUM function to accumulate the purchase quantities to calculate the total sales volume of retractable ID card lanyards, and calculate the sales proportion = total sales volume of retractable ID card lanyards / total sales volume of ID card lanyard products * 100%. Similarly, calculate the total sales volume and proportion of non-retractable ID card lanyards. (2) Compare the sales proportions of the two retractable types, and the one with the larger proportion is the dominant model based on the retractable feature.