如何按周对订单总金额求和

import pandas as pd

# 创建一个示例订单数据集
data = {
    'OrderDate': ['2022-01-01', '2022-01-02', '2022-01-05', '2022-01-06', '2022-01-08'],
    'Amount': [100, 200, 150, 300, 250]
}
df = pd.DataFrame(data)

# 将OrderDate列转换为日期类型
df['OrderDate'] = pd.to_datetime(df['OrderDate'])

# 按周对订单总金额进行求和
df['Week'] = df['OrderDate'].dt.week
weekly_sum = df.groupby('Week')['Amount'].sum()

print(weekly_sum)