在Python中拆分跨日历季度的会计季度的收入

import datetime

# 定义会计季度的起始月份和结束月份
start_month = 1  # 1月
end_month = 3    # 3月

# 示例收入数据
income_data = [
    {'date': '2022-01-05', 'amount': 1000},
    {'date': '2022-02-15', 'amount': 1500},
    {'date': '2022-03-20', 'amount': 2000},
    {'date': '2022-04-10', 'amount': 1200},
    {'date': '2022-05-25', 'amount': 1800},
    {'date': '2022-06-30', 'amount': 2500},
]

# 定义会计季度收入统计字典
quarterly_income = {}

# 遍历收入数据
for data in income_data:
    # 将日期字符串转换为datetime对象
    date = datetime.datetime.strptime(data['date'], '%Y-%m-%d')
    # 获取月份信息
    month = date.month
    
    # 判断月份是否在会计季度范围内
    if start_month <= month <= end_month:
        # 计算会计季度
        quarter = (month - start_month) // 3 + 1
        
        # 将收入数据添加到相应的会计季度中
        if quarter in quarterly_income:
            quarterly_income[quarter].append(data['amount'])
        else:
            quarterly_income[quarter] = [data['amount']]

# 统计每个会计季度的收入数据
for quarter, income_list in quarterly_income.items():
    total_income = sum(income_list)
    print(f"会计季度 {quarter} 的收入总额为 {total_income}")