TOP3小店的日销售额占比
类目分布
高销量小店的热门商品类目分布
热销商品的销售表现
# 假设已有数据df,包含列:'shop_name', 'daily_sales'
top3_shops = df.nlargest(3, 'daily_sales')
total_daily_sales = df['daily_sales'].sum()
top3_sales_sum = top3_shops['daily_sales'].sum()
head_effect_ratio = (top3_sales_sum / total_daily_sales) * 100
print(f"TOP3小店的日销售额占比为:{head_effect_ratio:.2f}%")
# 假设已有数据df,包含列:'shop_name', 'influencers_count', 'livestreams_count', 'videos_count', 'daily_sales'
channel_efficiency = df[['shop_name', 'influencers_count', 'livestreams_count', 'videos_count', 'daily_sales']].corr()
print("渠道效率相关性矩阵:\n", channel_efficiency)
# 假设已有数据df,包含列:'shop_name', 'category'
category_distribution = df['category'].value_counts(normalize=True) * 100
print("类目分布比例(前3名):\n", category_distribution.head(3))
# 假设已有数据df,包含列:'shop_name', 'active_products'
sales_per_product = df.groupby('shop_name')['daily_sales'].sum() / df['active_products']
print("动销商品数与销售额的关系:\n", sales_per_product)
以上分析数据来源:互联岛