python - How to create dict using csv file with first row as keys -
i'd create list of dictionaries reading large csv file uses entries first row keys. example, test.csv
header1, header2, header3 a, 1, 10 b, 2, 20 c, 3, 30 the resulting dict like:
mylist = [{'header1': a, 'header2': 1, 'header3: 10}, {'header1': b, 'header2': 2, 'header3: 20}, {'header1': c, 'header2': 3, 'header3: 30}] i know how read file, , think maybe defaultdict collections might way, can't syntax right.
this csv.dictreader made for.
import csv open('data.csv') f: reader = csv.dictreader(f) row in reader: print row for data.csv containing:
header1,header2,header3 a,1,10 b,2,20 c,3,30 it prints:
{'header2': '1', 'header3': '10', 'header1': 'a'} {'header2': '2', 'header3': '20', 'header1': 'b'} {'header2': '3', 'header3': '30', 'header1': 'c'}
Comments
Post a Comment