天猫平台学生卡套商品优势型号分析数据

根据学生卡套商品在天猫平台的销售情况，计算出基于图案特征（卡通柠檬熊、兔子水蜜桃、小熊抱橘子、小熊抱柠檬）和挂绳特征（短款挂绳、配安全扣款）的各种型号学生卡套的销售占比，识别出优势型号，有助于本公司及同行业内其他生产、销售学生卡套商品的企业制定、优化营销、仓储、物流和供应链方案。1.数据收集和预处理：（1）数据收集：收集公司在天猫平台上学生卡套商品订单信息，包括商品类目、商品名称、销售渠道/平台、订单编号、购买数量、图案特征、挂绳特征。（2）数据预处理：对收集的原始数据进行清洗。 2.计算销售总量：利用SUM函数将历史采集的购买数量累加计算出学生卡套商品销售总量。 3.基于图案特征识别优势型号：（1）筛选图案特征为卡通柠檬熊的订单，利用SUM函数将购买数”累加计算出卡通柠檬熊图案学生卡套销售总量，并计算出销售占比=卡通柠檬熊图案学生卡套销售总量/学生卡套商品销售总量*100%。同理，计算兔子水蜜桃、小熊抱橘子、小熊抱柠檬图案学生卡套销售总量及占比。（2）比较四种图案的销售占比，最大的为基于图案特征的优势型号。 4.基于挂绳特征识别优势型号：（1）筛选挂绳特征为短款挂绳的订单，利用SUM函数将购买数量累加计算出短款挂绳学生卡套销售总量，并计算出销售占比=短款挂绳学生卡套销售总量/学生卡套商品销售总量*100%。同理，计算配安全扣款学生卡套销售总量及占比。（2）比较两种挂绳特征的销售占比，较大的为基于挂绳特征的优势型号。This dataset is developed based on the sales performance of student ID card sleeve products on the Tmall platform. It calculates the sales proportions of various models of student ID card sleeves based on pattern features (cartoon lemon bear, rabbit & peach, bear holding orange, bear holding lemon) and lanyard features (short lanyard, with safety buckle), and identifies the dominant models, which helps enterprises including our company and other peers engaged in the production and sales of student ID card sleeve 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 student ID card sleeve products on the Tmall platform, including product category, product name, sales channel/platform, order number, purchase quantity, pattern features, and lanyard features. (2) Data Preprocessing: Clean the collected raw data. 2. Total Sales Volume Calculation: Use the SUM function to accumulate the historically collected purchase quantities to calculate the total sales volume of student ID card sleeve products. 3. Dominant Model Identification Based on Pattern Features (1) Filter orders with the pattern feature of cartoon lemon bear, use the SUM function to accumulate the purchase quantities to calculate the total sales volume of cartoon lemon bear pattern student ID card sleeves, and calculate the sales proportion = total sales volume of cartoon lemon bear pattern student ID card sleeves / total sales volume of student ID card sleeve products * 100%. Similarly, calculate the total sales volume and sales proportion of student ID card sleeves with rabbit & peach, bear holding orange, and bear holding lemon patterns. (2) Compare the sales proportions of the four patterns, and the one with the largest proportion is the dominant model based on pattern features. 4. Dominant Model Identification Based on Lanyard Features (1) Filter orders with the lanyard feature of short lanyard, use the SUM function to accumulate the purchase quantities to calculate the total sales volume of short lanyard student ID card sleeves, and calculate the sales proportion = total sales volume of short lanyard student ID card sleeves / total sales volume of student ID card sleeve products * 100%. Similarly, calculate the total sales volume and sales proportion of student ID card sleeves with safety buckles. (2) Compare the sales proportions of the two lanyard features, and the one with the larger proportion is the dominant model based on lanyard features.