根据提供的数据,我们可以从以下几个核心维度进行分析:
品牌集中度:
多渠道投放:
类目偏好:
运营效率:
品牌集中度:
import pandas as pd
# 假设有一个包含销售数据的DataFrame
sales_data = pd.read_csv("sales_data.csv")
top_brands = sales_data.groupby('brand')['sale_amount'].sum().nlargest(3)
total_sales = sales_data['sale_amount'].sum()
brand_concentration = (top_brands.sum() / total_sales) * 100
print(f"Top 3 brands' sales concentration: {brand_concentration:.2f}%")
多渠道投放:
# 假设有一个包含达人合作数据的DataFrame
influencer_data = pd.read_csv("influencer_data.csv")
for brand in top_brands.index:
num_influencers = len(influencer_data[influencer_data['brand'] == brand]['influencer_name'].unique())
print(f"{brand} has {num_influencers} influencers.")
# 同样可以统计直播和视频数量
num_videos = influencer_data[(influencer_data['brand'] == brand) & (influencer_data['type'] == 'video')]['video_id'].nunique()
print(f"{brand} has {num_videos} videos.")
类目偏好:
# 假设有一个包含商品分类数据的DataFrame
category_data = pd.read_csv("category_data.csv")
top_categories = category_data.groupby('category')['sale_amount'].sum().nlargest(5)
print(f"Top 5 categories: {top_categories}")
运营效率:
# 假设有一个包含动销商品数和直播/视频数据的DataFrame
efficiency_data = pd.read_csv("efficiency_data.csv")
for brand in top_brands.index:
active_products = len(efficiency_data[efficiency_data['brand'] == brand]['product_id'].unique())
num_videos = efficiency_data[(efficiency_data['brand'] == brand) & (efficiency_data['type'] == 'video')]['video_id'].nunique()
print(f"{brand} has {active_products} active products and {num_videos} videos.")
通过上述分析,我们可以得到各个品牌在不同维度上的表现,并据此做出优化建议。例如:
以上分析数据来源:互联岛