擅长:python、mysql、java
<p>假设您2012年的预期产出是一个输入错误(您的数据集显示11.23为总赢款),您可以使用<code>itertools.groupby</code>和<code>sum</code>按年度汇总总赢款/输款。您可以根据需要修改输出格式,但这应该可以让您继续。你知道吗</p>
<pre><code>from itertools import groupby
from operator import itemgetter
results = [['a', '2013', '10.22', 'won'], ['b', '2012', '11.23', 'won'], ['c', '2013', '12.62', 'lost']]
for year, values in groupby(sorted(results, key=itemgetter(1)), key=itemgetter(1)):
values = list(values)
won = sum(float(v[2]) for v in values if v[3] == 'won')
lost = sum(float(v[2]) for v in values if v[3] == 'lost')
print(f'Year: {year} Total Won: {won} Total Lost: {lost}')
# Year: 2012 Total Won: 11.23 Total Lost: 0
# Year: 2013 Total Won: 10.22 Total Lost: 12.62
</code></pre>