TOP3商品日销量与趋势分析:
0佣金商品表现分析:
类目分布分析:
增长形态分析:
import pandas as pd
# 假设数据已经加载到DataFrame df 中
df_top3 = df[df['Top3'] == True] # 过滤出Top3商品
# 计算日均销量及趋势
df_top3['Daily_Sales'] = df_top3.groupby('Product_ID')['Sales'].apply(lambda x: (x.cumsum() - x.shift(1)).fillna(x))
df_top3['Average_Sales_15Days'] = df_top3.groupby('Product_ID')['Daily_Sales'].transform('mean').shift(-14)
df_top3['Average_Sales_30Days'] = df_top3.groupby('Product_ID')['Daily_Sales'].transform('mean')
# 0佣金商品分析
df_zero_commission = df[df['Commission'] == 0]
average_sales_zero_commission = df_zero_commission.groupby(['Date', 'Category'])['Sales'].sum().unstack(level=1).fillna(0)
average_sales_zero_commission['Total_Sales'] = average_sales_zero_commission.sum(axis=1)
# 类目分布分析
category_distribution_top3 = df_top3.groupby('Category')['Product_ID'].count()
# 突发型和平稳型商品划分
df_top3['Trend_Type'] = 'Stable'
df_top3.loc[df_top3['Average_Sales_15Days'] < 0.9 * df_top3['Average_Sales_30Days'], 'Trend_Type'] = 'Sudden'
# 可视化分析结果
import matplotlib.pyplot as plt
plt.figure(figsize=(12, 8))
df_top3.plot(x='Date', y=['Average_Sales_15Days', 'Average_Sales_30Days'])
plt.title('Top3商品日均销量趋势')
plt.xlabel('日期')
plt.ylabel('平均销量')
plt.show()
average_sales_zero_commission.plot(kind='bar', stacked=True)
plt
---
<small>以上分析数据来源:互联岛</small>