短视频引流占比与销售额的相关性:
TOP3直播的引流人次占比:
带货类目分布:
粉丝体量与引流能力的关系:
pearsonr函数计算相关系数。import pandas as pd
# 假设df为包含引流数据的DataFrame
correlation = df['短视频引流占比'].corr(df['销售额'])
print(f'相关性:{correlation}')
top_3_df = df.nlargest(3, '引流总人次')
total引流总人次 = df['引流总人次'].sum()
top_3_total = top_3_df['引流总人次'].sum()
ratio_top3 = (top_3_total / total引流总人次) * 100
print(f'TOP3直播间引流总占比:{ratio_top3}%')
high引流直播间 = df[df['短视频引流占比'] > 5]
product_categories = high引流直播间['带货品类'].value_counts()
print(f'高引流类目分布:\n{product_categories}')
df['粉丝组别'] = pd.cut(df['粉丝数'], bins=[0, 100000, 500000, float('inf')], labels=['小众', '中等', '大众'])
group_means = df.groupby('粉丝组别')['引流总人次'].mean()
print(f'每组平均引流人数:\n{group_means}')
以上分析数据来源:互联岛