从您的数据来看,我们可以进行以下几个核心维度的分析:
引流效率:
头部效应:
类目特征:
粉丝体量:
计算引流效率指标:
# 示例数据
data = [
{'name': '直播间A', 'short_video_views': 1000, 'total_views': 5000, 'sales': 2000},
{'name': '直播间B', 'short_video_views': 800, 'total_views': 4000, 'sales': 1800},
# 其他直播间数据
]
for entry in data:
entry['video_conversion_rate'] = (entry['short_video_views'] / entry['total_views']) * 100
top_3 = sorted(data, key=lambda x: x['sales'], reverse=True)[:3]
total_views_sum = sum([entry['total_views'] for entry in data])
# TOP3引流占比
top_3_total_views = sum([entry['total_views'] for entry in top_3])
top_3_views_percentage = (top_3_total_views / total_views_sum) * 100
print("TOP3直播间引流占比:", top_3_views_percentage)
类目特征分析:
class_distribution = {'农产品': 0, '服饰': 0, '日用品': 0} # 示例类目分布
for entry in data:
if entry['class'] == '农产品':
class_distribution['农产品'] += entry['video_conversion_rate']
# 计算各类目的平均引流效率
avg_conversion_rates = {k: v / len([entry for entry in data if entry['class'] == k]) for k, v in class_distribution.items()}
print("各类型目平均引流效率:", avg_conversion_rates)
粉丝体量与引流能力关系:
# 假设我们有一些基础数据
fan_count_sales = [
{'name': '直播间A', 'fan_count': 1000, 'video_views': 500},
{'name': '直播间B', 'fan_count': 2000, 'video_views': 800}
]
import pandas as pd
df = pd.DataFrame(fan_count_sales)
df['sales'] = [100, 200] # 假设销售额数据
df.plot(x='fan_count', y='video_views')
以上分析数据来源:互联岛