基于提供的数据,我们可以进行以下几项具体分析:
头部效应:
# 假设销售额数据存储在DataFrame `sales` 中
top_3_sales = sales.head(3)['day_sales'].sum()
total_sales = sales['day_sales'].sum()
top_3_percentage = (top_3_sales / total_sales) * 100
print(f"TOP3小店日销售额占比: {top_3_percentage:.2f}%")
top_3_categories = sales.head(3)['category'].value_counts()
print("TOP3小店类目分布: ", top_3_categories)
渠道效率:
# 假设达人合作次数、直播场次和视频数量分别存储在 `influencers`, `livestreams` 和 `videos` 列中
correlation_data = sales[['influencers', 'livestreams', 'videos', 'day_sales']]
correlations = correlation_data.corr()
print("相关性矩阵: \n", correlations)
类目特征:
top_10_sales_stores = sales.nlargest(10, 'day_sales')
popular_categories = top_10_sales_stores['category'].value_counts()
print("高销量小店热门商品类目: ", popular_categories)
动销能力:
# 假设 `active_products` 列存储了每个小店活跃商品的数量
sales['day_sales_per_product'] = sales['day_sales'] / sales['active_products']
print("日均销售额/动销商品数: ", sales[['category', 'day_sales_per_product']].groupby('category').mean())
以上分析数据来源:互联岛