护眼贴在淘宝平台上的优势型号识别数据

根据护眼贴商品在淘宝平台的销售情况，计算出基于成分特征（叶黄素、花青素）的各种型号护眼贴的销售占比，识别出优势型号，有助于本公司及同行业内其他生产、销售护眼贴商品的企业制定、优化营销、仓储、物流和供应链方案。1.数据收集和预处理：（1）数据收集：收集公司在淘宝平台上护眼贴商品订单信息，包括商品类目、商品名称、统计时间、销售渠道/平台、订单编号、购买数量、成分特征。（2）数据预处理：对收集的原始数据进行清洗。
2.计算销售总量：利用SUM函数将历史采集的购买数量累加计算出护眼贴商品销售总量。
3.基于成分特征识别优势型号：（1）筛选成分特征为叶黄素的订单，利用SUM函数将购买数量累加计算出叶黄素护眼贴销售总量，并计算出销售占比=叶黄素护眼贴销售总量/护眼贴商品销售总量*100%。同理，计算花青素护眼贴销售总量及占比。（2）比较两种成分的销售占比，较大的为基于成分特征的优势型号。

Based on the sales data of eye protection patch products on the Taobao platform, calculating the sales proportions of various eye protection patch models based on their ingredient characteristics (lutein, anthocyanidin) and identifying the dominant models will help our company and other enterprises in the same industry that produce and sell eye protection patch products to formulate and optimize their marketing, warehousing, logistics and supply chain solutions.
1. Data Collection and Preprocessing:
(1) Data Collection: Collect the order information of the company's eye protection patch products on the Taobao platform, including product category, product name, statistical time, sales channel/platform, order number, purchase quantity, and ingredient 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 eye protection patch products.
3. Identify Dominant Product Models Based on Ingredient Characteristics:
(1) Filter the orders with lutein as the ingredient characteristic, use the SUM function to accumulate the purchase quantities to calculate the total sales volume of lutein-based eye protection patches, and calculate the sales proportion = total sales volume of lutein-based eye protection patches / total sales volume of eye protection patch products * 100%. Similarly, calculate the total sales volume and sales proportion of anthocyanidin-based eye protection patches.
(2) Compare the sales proportions of the two ingredients, and the one with the larger proportion is the dominant product model based on ingredient characteristics.

搜集汇总

背景与挑战

背景概述

该数据集包含淘宝平台护眼贴商品的销售订单数据，规模538条，每日更新，通过分析成分特征（如叶黄素和花青素）的销售占比识别优势型号（叶黄素占比50.04%），旨在帮助企业优化营销和供应链策略。