根据提供的数据和核心分析维度,我们可以从以下几个角度进行详细分析:
import pandas as pd
# 假设数据已经存入DataFrame df
region_sales = df.groupby('地区')['总销售额'].sum()
print(region_sales)
average_sales_per_session = df['总销售额'] / df['直播场次']
print(average_sales_per_session)
# 进行散点图分析
import matplotlib.pyplot as plt
plt.scatter(df['直播场次'], df['总销售额'])
plt.xlabel('直播场次')
plt.ylabel('总销售额')
plt.show()
# 计算TOP达人的销售额比例
top_10_percent = int(0.1 * len(df))
top_sales = df.sort_values(by='总销售额', ascending=False).head(top_10_percent)['总销售额'].sum()
total_sales = df['总销售额'].sum()
percentage_top_sales = (top_sales / total_sales) * 100
print(f"TOP10%达人的销售贡献率: {percentage_top_sales:.2f}%")
以上分析数据来源:互联岛