根据提供的数据,我们可以从以下几个维度进行分析:
import pandas as pd
# 假设已有品牌销售数据的DataFrame df
df = pd.DataFrame({
'brand': ['美的', '巴拉巴拉', '欧莱雅', ...],
'sales': [10000, 5000, 3000, ...]
})
top_3_brands = df.nlargest(3, 'sales')
total_sales = df['sales'].sum()
top_3_sales = top_3_brands['sales'].sum()
brand_concentration = (top_3_sales / total_sales) * 100
print(f"TOP3品牌销售额占比: {brand_concentration:.2f}%")
df['num_reaches'] = df['reached_danawa'].fillna(0) + df['reached_live'].fillna(0) + df['reached_video'].fillna(0)
top_brands_by_channels = df.nlargest(3, 'num_reaches')
print(top_brands_by_channels[['brand', 'num_reaches']])
category_counts = df.groupby('category').size().reset_index(name='counts')
most_common_categories = category_counts.nlargest(5, 'counts')
print(most_common_categories)
df['active_products'] = df['num_product_sold']
df['live_video_frequency'] = df['live_video_count']
efficiency_analysis = df[['brand', 'active_products', 'live_video_frequency']].corr()
print(efficiency_analysis)
以上分析数据来源:互联岛