<p>我有一个这样的csv数据集:</p>
<pre><code>A, 10, USA
B,30, UK
C,4,IT
A,20,UK
B,10,USA
</code></pre>
<p>我想阅读此csv行并提供以下输出:</p>
<pre><code>A has ran 30 miles with average of 15.
B has ran 30 miles with average of 20.
C has ran 4 miles with average of 4.
</code></pre>
<p>到目前为止,我的解决方案是读取csv数据并将其转换为字典,然后对它们进行迭代,查看“A”重复了多少次,以及它必须为平均值计算哪些值,最后生成结果。我已经编写了这段代码,但是我很难有效地计算a被重复的次数,并将英里数相加以创建我的最终输出。在Python中有什么想法吗?用C#做这件事对我来说有点容易,但我对Python不是很在行。</p>
<pre><code>def main(filename):
f = open(filename,'r')
labels = ['name','miles','country']
data = csv.DictReader(f,labels,delimiter=',')
for line in data:
print (line['name']+" " + "has ran" +" "+ line['miles']+" "+"miles")
f.close()
</code></pre>