基于上述数据,我们可以从以下几个维度进行分析:
计算短视频引流占比与销售额的相关性:
统计TOP3直播的引流人次占比:
分类并统计高引流比带货类目:
分析粉丝体量与引流能力的关系:
短视频引流与销售额的相关性分析:
import pandas as pd
from scipy.stats import pearsonr
# 假设df为包含所有数据的DataFrame
correlation, p_value = pearsonr(df['short_video_referral_ratio'], df['sales'])
print(f"Correlation: {correlation}, P-Value: {p_value}")
TOP3直播引流占比分析:
top_3_referrals = df.sort_values(by='short_video_referral_ratio', ascending=False).head(3)
total_referrals = df['total_referrals'].sum()
top_3_total_referrals = top_3_referrals['total_referrals'].sum()
print(f"TOP3直播间总引流占比: {top_3_total_referrals / total_referrals * 100}%")
高引流比带货类目分布:
high_referral_df = df[df['short_video_referral_ratio'] > 20]
category_distribution = high_referral_df['category'].value_counts(normalize=True)
print(category_distribution)
以上分析数据来源:互联岛