擅长:python、mysql、java
<p>在纯Python中,您应该查看<a href="https://docs.python.org/3/library/csv.html" rel="nofollow noreferrer"><strong>^{<cd1>}</strong></a>模块以获取输入和<a href="https://docs.python.org/3/library/collections.html#collections.defaultdict" rel="nofollow noreferrer"><strong>^{<cd2>}</strong></a>以获取总计:</p>
<pre><code>from csv import reader
from collections import defaultdict
d = defaultdict(lambda: defaultdict(int))
with open('file.csv') as f:
r = reader(f)
next(r) # skip headers
for row in r:
if len(row) >= 3:
x, y, count = row
d[x][y] += int(count)
keys = sorted(d)
for x in keys:
print(' '.join(str(d[x][y]) for y in keys))
0 4 0
2 0 4
9 8 0
</code></pre>