按多个键分组，并对字典列表的多个值进行汇总/平均

data = [
    {"key1": "A", "key2": "X", "value": 10},
    {"key1": "A", "key2": "Y", "value": 20},
    {"key1": "B", "key2": "X", "value": 30},
    {"key1": "B", "key2": "Y", "value": 40},
    {"key1": "C", "key2": "X", "value": 50},
    {"key1": "C", "key2": "Y", "value": 60}
]

from collections import defaultdict

# 创建一个默认值为0的字典，用于存储汇总结果
result = defaultdict(int)

# 遍历字典列表
for item in data:
    # 获取键的组合
    key = (item["key1"], item["key2"])
    # 汇总值
    result[key] += item["value"]

# 打印汇总结果
for key, value in result.items():
    print(key, value)

('A', 'X') 10
('A', 'Y') 20
('B', 'X') 30
('B', 'Y') 40
('C', 'X') 50
('C', 'Y') 60