京东平台国旗商品优势型号识别数据
收藏资源简介：
根据国旗商品在京东平台的销售情况，计算出基于旗帜类型特征（国旗、党旗）和是否含杆特征（含杆、不含杆）的各种型号国旗的销售占比，识别出优势型号，有助于本公司及同行业内其他生产、销售国旗商品的企业制定、优化营销、仓储、物流和供应链方案。1.数据收集和预处理：（1）数据收集：收集公司在京东平台上国旗商品订单信息，包括商品类目、商品名称、销售渠道/平台、订单编号、购买数量、旗帜类型特征、是否含杆特征。（2）数据预处理：对收集的原始数据进行清洗。 2.计算销售总量：利用SUM函数将历史采集的购买数量累加计算出国旗商品销售总量。 3.基于图案特征识别优势型号：（1）筛选旗帜类型特征为卡国旗的订单，利用SUM函数将购买数”累加计算出国旗销售总量，并计算出销售占比=国旗销售总量/国旗商品销售总量*100%。同理，计算党旗销售总量及占比。（2）比较两种旗帜类型的销售占比，最大的为基于旗帜类型特征的优势型号。 4.基于是否含杆特征识别优势型号：（1）筛选是否含杆特征为含杆国旗的订单，利用SUM函数将购买数量累加计算出含杆销售总量，并计算出销售占比=含杆销售总量/国旗商品销售总量*100%。同理，计算不含杆销售总量及占比。（2）比较两种是否含杆特征的销售占比，较大的为基于是否含杆特征的优势型号。
Based on the sales performance of national flag products on the JD.com platform, this dataset calculates the sales proportions of various national flag models based on two sets of features: flag type (national flag, party flag) and pole inclusion status ("with pole", "without pole"), and identifies the dominant models. The results can help our company and other enterprises engaged in the production and sales of national flag products in the same industry to formulate and optimize their marketing, warehousing, logistics and supply chain strategies. 1. Data Collection and Preprocessing: (1) Data Collection: Collect the order information of national flag products sold by our company on the JD.com platform, including product category, product name, sales channel/platform, order number, purchase quantity, flag type feature, and pole inclusion feature. (2) Data Preprocessing: Clean the collected raw order data. 2. Calculate Total Sales Volume: Use the SUM function to accumulate the historically collected purchase quantities to calculate the total sales volume of all national flag products. 3. Identify Dominant Models Based on Flag Type Feature: (1) Filter orders where the flag type is national flag, use the SUM function to accumulate the purchase quantities to calculate the total sales volume of national flags, and calculate the sales proportion as (total national flag sales volume / total sales volume of all national flag products) * 100%. Similarly, calculate the total sales volume and sales proportion of party flags. (2) Compare the sales proportions of the two flag types, and the type with the higher proportion is the dominant model based on the flag type feature. 4. Identify Dominant Models Based on Pole Inclusion Feature: (1) Filter orders for national flags with the pole inclusion feature set to "with pole", use the SUM function to accumulate the purchase quantities to calculate the total sales volume of national flags with poles, and calculate the sales proportion as (total sales volume of flags with poles / total sales volume of all national flag products) * 100%. Similarly, calculate the total sales volume and sales proportion of national flags without poles. (2) Compare the sales proportions of the two pole inclusion types, and the type with the higher proportion is the dominant model based on the pole inclusion feature.
