根据提供的数据,我们可以从以下几个方面进行核心分析:
头部效应:
转化效率:
类目特征:
账号类型:
具体数值计算如下:
头部效应:
top3_sales = df[df['排名'] <= 3]['销售额'].sum()
total_sales = df['销售额'].sum()
top3_percentage = (top3_sales / total_sales) * 100
print(f'TOP3达人销售额占比:{top3_percentage:.2f}%')
转化效率:
avg_sales_per_live = total_sales / df['直播场次'].sum()
avg_sales_per_order = total_sales / df['销量'].sum()
print(f'平均每场直播销售额:{avg_sales_per_live:.2f}')
print(f'平均每笔订单的销售额(客单价):{avg_sales_per_order:.2f}')
类目特征:
average_unit_price = total_sales / df['销量'].sum()
print(f'平均每笔订单的销售额(客单价):{average_unit_price:.2f}')
账号类型:
official_flagship_sales = df[df['账号类型'] == '官方旗舰店']['销售额'].sum()
total_sales = df['销售额'].sum()
official_percentage = (official_flagship_sales / total_sales) * 100
print(f'官方旗舰店总销售额占比:{official_percentage:.2f}%')
以上分析数据来源:互联岛