根据提供的数据和核心分析维度,我们可以从以下几个方面进行详细分析:
import pandas as pd
# 假设数据存储在data.csv文件中
df = pd.read_csv('data.csv')
regions = df['区域'].unique()
for region in regions:
region_data = df[df['区域'] == region]
avg_index = region_data['传播指数'].mean()
std_index = region_data['传播指数'].std()
print(f"Region: {region}, Avg Index: {avg_index:.2f}, Std Deviation: {std_index:.2f}")
df['互动等级'] = pd.qcut(df['总点赞数'], q=4, labels=['低', '中等', '高'])
for level in df['互动等级'].unique():
level_data = df[df['互动等级'] == level]
avg_index = level_data['传播指数'].mean()
print(f"Level: {level}, Avg Index: {avg_index:.2f}")
top_10 = df.sort_values(by='传播指数', ascending=False).head(10)
for index, row in top_10.iterrows():
print(f"Top 10: {row['账号']} - Index: {row['传播指数']:.2f}, 点赞数: {row['总点赞数']}")
通过以上分析,我们可以得出以下几个结论:
以上分析数据来源:互联岛