假设有以下数据:
data = [['January', 100, 200, 150],
['February', 130, 240, 100],
['March', 145, 180, 50],
['April', 110, 220, 170]]
可以使用字典来存储每个月份的总和:
result = {}
for row in data:
month = row[0]
for i in range(1, len(row)):
if month in result:
result[month] += row[i]
else:
result[month] = row[i]
print(result)
执行后,按照月份计算每列的总和可以得到以下结果:
{'January': 450, 'February': 470, 'March': 375, 'April': 500}