企业综合评估年末促销

import pandas as pd
import matplotlib.pyplot as plt

# 假设我们有一个销售数据的DataFrame
data = {
    'Date': pd.date_range(start='1/1/2023', periods=365),
    'Sales': [i + 50 * (i % 7) for i in range(365)]  # 模拟每日销售额
}
df = pd.DataFrame(data)

# 计算年末促销期间的销售额
promotion_start = pd.Timestamp('2023-12-01')
promotion_end = pd.Timestamp('2023-12-31')
promotion_sales = df[(df['Date'] >= promotion_start) & (df['Date'] <= promotion_end)]['Sales'].sum()

print(f"年末促销期间的总销售额: {promotion_sales}")

# 可视化销售额变化
plt.figure(figsize=(10, 5))
plt.plot(df['Date'], df['Sales'], label='Daily Sales')
plt.axvline(x=promotion_start, color='r', linestyle='--', label='Promotion Start')
plt.axvline(x=promotion_end, color='g', linestyle='--', label='Promotion End')
plt.xlabel('Date')
plt.ylabel('Sales')
plt.title('Sales Trend with Year-End Promotion')
plt.legend()
plt.show()