根据您提供的数据,我们可以从以下几个方面进行分析:
引流效率
头部效应
类目特征
粉丝体量
引流效率
import pandas as pd
# 示例数据
df = pd.read_csv('live_data.csv')
# 计算引流效率
df['ShortVideoRatio'] = df['ShortVideoReferral'] / df['TotalReferral']
# 与销售额对比分析
correlation = df[['ShortVideoRatio', 'Sales']].corr().iloc[0, 1]
print(f"Correlation between Short Video Ratio and Sales: {correlation}")
头部效应
top3_livestreams = df.nlargest(3, 'TotalReferral')
total_referrals = df['TotalReferral'].sum()
top3_ratio = (top3_livestreams['TotalReferral'].sum() / total_referrals) * 100
print(f"Top 3 livestream referrals ratio: {top3_ratio}%")
类目特征
df['Category'] = pd.cut(df['ShortVideoRatio'], bins=[0, 0.1, 0.25, 0.5, 1], labels=['Low', 'Medium', 'High'])
category_stats = df.groupby('Category').agg({'TotalReferral': 'sum'})
print(category_stats)
粉丝体量
df['FanRatio'] = df['Fans'].apply(lambda x: math.log(x + 1))
correlation = df[['FanRatio', 'ShortVideoRatio']].corr().iloc[0, 1]
print(f"Correlation between Fan Ratio and Short Video Ratio: {correlation}")
以上分析数据来源:互联岛