计算各直播间的视频引流占比
def calculate_video引流_ratio(total_views, video_views):
return (video_views / total_views) * 100
筛选前10个高销售额直播间并统计其短视频引流占比
high_sales_top = sorted(data, key=lambda x: -x['销售额'])[:10]
high_sales_video_ratio = [calculate_video引流_ratio(item['总观看量'], item['视频观看量']) for item in high_sales_top]
计算TOP3直播的引流人次占比
top_3_total_views = sum([item['总观看量'] for item in data[:3]])
total_views_all = sum([item['总观看量'] for item in data])
top_3_percentage = (top_3_total_views / total_views_all) * 100
统计高引流占比直播间的产品类别
high_video_ratio_items = sorted(data, key=lambda x: -x['短视频引流占比'])[:10]
categories = [item['带货类目'] for item in high_video_ratio_items]
分析不同粉丝量级的引流效果
def group_by_fans_range(fan_counts):
groups = {'<10w': 0, '10-50w': 0, '>50w': 0}
for fan in fan_counts:
if fan < 100000:
groups['<10w'] += 1
elif fan >= 100000 and fan < 500000:
groups['10-50w'] += 1
else:
groups['>50w'] += 1
return groups
fans_groups = group_by_fans_range([item['粉丝数'] for item in data])
以上分析数据来源:互联岛