擅长:python、mysql、java
<p>像下面这样的事情将是一个好的开始:</p>
<pre><code>import csv, collections
with open("mydata.csv", 'r') as f_input:
csv_input = csv.reader(f_input)
# Assuming the first row contains the heading names, otherwise remove.
headings = csv_input.next()
d_max_rows = collections.OrderedDict()
for cols in csv_input:
reference = cols[0]
if reference in d_max_rows:
cur_max = d_max_rows[reference]
if int(cols[1]) >= int(cur_max[1]):
d_max_rows[reference] = cols
else:
d_max_rows[reference] = cols
lrows = [headings] + list(d_max_rows.itervalues())
for reference, amount, col3, col4 in lrows:
print "%-15s %-10s %-10s %-10s" % (reference, amount, col3, col4)
</code></pre>
<p>这将为您提供以下输出:</p>
^{pr2}$