根据提供的数据,我们可以从多个角度进行核心分析:
TOP3达人:
TOP3达人销售额占比:
销售额与直播场次的关系:
销售转化率:
高客单价/高销量商品表现:
整体类目占比:
数据预处理:
TOP3达人销售额占比计算:
top_3_sales = sum([data['销售额'][i] for i in range(0, 3)])
total_sales = data['销售额'].sum()
top_3_ratio = (top_3_sales / total_sales) * 100
相关性分析:
correlation_coefficient = np.corrcoef(data['直播场次'], data['销售额'])[0, 1]
类目特征分析:
账号类型差异对比:
official_flagships = data[data['账号类型'] == '官方旗舰店']
ordinary_influencers = data[data['账号类型'] == '普通达人']
avg_sales_official = official_flagships['销售额'].mean()
avg_sales_ordinary = ordinary_influencers['销售额'].mean()
roi_official = (official_flagships['净利润'] / official_flagships['成本']).mean()
roi_ordinary = (ordinary_influencers['净利润'] / ordinary_influencers['成本']).mean()
可视化:
通过上述步骤,可以得出以下结论:
以上分析数据来源:互联岛