python读取csv文件，并创建成字典

清华大佬耗费三个月吐血整理的几百G的资源，免费分享！....>>>

本文主要介绍python读取csv文件，并创建成字典的方法，有需要的朋友可以参考一下：

我有一个像这样的csv数据集：

Copy
A, 10, USA
B,30, UK
C,4,IT
A,20,UK
B,10,USA

Copy
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. 

Copy
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()

最佳答案

您可以使用defaultdict存储值,然后将其打印出来：

Copy
import csv
 
from collections import defaultdict
 
with open(filename, 'r') as handle:
    reader = csv.DictReader(handle, ['name', 'miles', 'country'])
    data = defaultdict(list)
 
    for line in reader:
        data[line['name']).append(int(line['miles']))
 
    for runner, distances in data.items():
        print '{} ran a total of {} miles and an average of {} miles'.format(
            runner, sum(distances), sum(distances) / float(len(distances))
        )