如何在python中按连续日期分组？

import pandas as pd

# 创建示例数据
data = {
    'date': ['2023-01-01', '2023-01-02', '2023-01-03', '2023-01-04', '2023-01-05'],
    'sales': [100, 150, 200, 175, 225]
}

# 将数据转换为DataFrame
df = pd.DataFrame(data)

# 将日期列转换为日期时间格式
df['date'] = pd.to_datetime(df['date'])

# 按日期分组并计算每天的总销售额
grouped = df.groupby('date')['sales'].sum()

print(grouped)

date
2023-01-01    100
2023-01-02    150
2023-01-03    200
2023-01-04    175
2023-01-05    225
Name: sales, dtype: int64