根据两列聚合两个相同的列表，并对第三列求和

list1 = [{'key1': 'A', 'key2': 'X', 'value': 1},
         {'key1': 'B', 'key2': 'Y', 'value': 2},
         {'key1': 'C', 'key2': 'Z', 'value': 3}]

list2 = [{'key1': 'A', 'key2': 'X', 'value': 4},
         {'key1': 'B', 'key2': 'Y', 'value': 5},
         {'key1': 'D', 'key2': 'W', 'value': 6}]

result = {}

for item in list1 + list2:
    key = (item['key1'], item['key2'])
    if key in result:
        result[key] += item['value']
    else:
        result[key] = item['value']

for key, value in result.items():
    print(key, value)

('A', 'X') 5
('B', 'Y') 7
('C', 'Z') 3
('D', 'W') 6