关于颗粒批发意向分析数据
收藏资源简介:
通过收集和分析批发商对颗粒类产品相关数据,了解批发商的采购水平和意向度,从而了解该产品是否畅销,从而为本行业的所有企业制定生产策略,更好地为批发商提供个性化的产品和服务1、数据处理:对采集到的数据进行降噪、清洗、脱敏、聚集、分析。 2.数据加工:重复率评分=满分上限100-(ROUND(重复批发排名/总记录数(1099)*100,2);单笔评分=满分上限100-(ROUND(单笔批发最大金额排名/总记录数(1099)*100,2);平均分=(RFM评分+重复率评分+单笔评分)/3;综合得分=ROUND(SQRT(((RFM评分-平均分)^2+(重复率评分-平均分)^2+(单笔评分-平均分)^2)/3),2);得到的综合评分:0-10分标记为“高意向度批发商”,10-25分区间内标记为“中意向度批发商”,25分以上标记为“低意向度批发商”。
This dataset is developed by collecting and analyzing wholesalers' data related to granular products, aiming to understand the procurement levels and purchase intentions of wholesalers, evaluate the market sales performance of the products, and assist all enterprises in the industry to formulate production strategies and provide personalized products and services to wholesalers. 1. Data Preprocessing: Perform denoising, cleaning, anonymization, aggregation and analysis on the collected data. 2. Data Scoring: - Repeat Rate Score = 100 (full score) - ROUND( (Ranked Repeat Wholesale Volume / Total Records (1099)) * 100, 2 ) - Single-Transaction Score = 100 (full score) - ROUND( (Ranked Maximum Single Wholesale Transaction Amount / Total Records (1099)) * 100, 2 ) - Average Score = (RFM Score + Repeat Rate Score + Single-Transaction Score) / 3 - Comprehensive Score = ROUND( SQRT( ((RFM Score - Average Score)^2 + (Repeat Rate Score - Average Score)^2 + (Single-Transaction Score - Average Score)^2) / 3 ), 2 ) Wholesalers are categorized based on their comprehensive scores: those with 0-10 points are marked as "High-intent Wholesalers", those with scores between 10 and 25 are marked as "Medium-intent Wholesalers", and those with scores above 25 are marked as "Low-intent Wholesalers".




