引流效率:
头部效应:
类目特征:
粉丝体量:
数据收集:
数据分析:
结果展示与解释:
import pandas as pd
import numpy as np
from scipy.stats import pearsonr
# 假设数据已经加载到DataFrame df中
df = pd.read_csv('livestream_data.csv')
# 计算视频引流占比与销售额的相关性
correlation, p_value = pearsonr(df['video_referral'], df['sales'])
print(f"Correlation: {correlation}, P-value: {p_value}")
# 计算TOP3直播的人次占比
top_3 = df.sort_values(by='referral', ascending=False).head(3)
total_referral = top_3['referral'].sum()
top3_ratio = (top_3['referral'] / total_referral) * 100
print(f"TOP3 Referral Ratio: {top3_ratio}")
# 分析引流效果与粉丝量的关系
fan_size_vs_reach = df.groupby('fans_count')['referral'].mean().reset_index()
import matplotlib.pyplot as plt
plt.scatter(fan_size_vs_reach['fans_count'], fan_size_vs_reach['referral'])
plt.xlabel('Fans Count')
plt.ylabel('Referral (Person)')
plt.title('Fan Size vs Referral Relationship')
plt.show()
# 可视化类目分布
category_sales = df.groupby('product_category')['sales'].sum().reset_index()
category_sales.plot(kind='bar', x='product_category', y='sales')
plt.xlabel('Product Category')
plt.ylabel('Sales (USD)')
plt.title('Sales by Product Category')
plt.show()
以上分析数据来源:互联岛