根据提供的数据,我们可以从以下几个核心维度进行分析:
TOP3达人销售额占比:
类目集中度:
import pandas as pd
# 假设数据已经加载到 DataFrame df 中
top_3_sales = df[df['排名'].isin([1, 2, 3])]
total_sales = df['销售额'].sum()
top_3_sales_ratio = (top_3_sales['销售额'].sum() / total_sales) * 100
print(f"TOP3达人销售额占比: {top_3_sales_ratio:.2f}%")
average_sales_per_show = df.groupby('主播名称')['销售额'].mean()
average_units_sold_per_show = df.groupby('主播名称')['销量'].mean()
print("平均每场直播的销售额:")
print(average_sales_per_show)
print("\n平均每场直播的销量:")
print(average_units_sold_per_show)
jewelry_sales = df[df['类目'] == '珠宝文玩']
total_jewelry_sales = jewelry_sales['销售额'].sum()
total_jewelry_units_sold = jewelry_sales['销量'].sum()
print(f"珠宝文玩类目的总销售额: {total_jewelry_sales}")
print(f"珠宝文玩类目的总销量: {total_jewelry_units_sold}")
official_accounts = df[df['账号类型'] == '官方旗舰店']
non_official_accounts = df[df['账号类型'] == '普通达人']
average_sales_official = official_accounts['销售额'].mean()
average_sales_non_official = non_official_accounts['销售额'].mean()
print(f"官方旗舰店的平均销售额: {average_sales_official}")
print(f"普通达人的平均销售额: {average_sales_non_official}")
以上分析数据来源:互联岛