How to parse csv using DictReader?

**bvdet** · Mar 24 '11, 09:36 PM

I think this will do what you are looking for:

Code:

import csv

labels = ['station_id', 'datetime', 'sa', 'ra']
fn = r'D:\SDS2_7.0\macro\Work In Progress\station_data_1h.csv'

station = '1070000016'

f = open(fn, 'rb')

reader = csv.DictReader(f, labels, dialect='excel-tab')

station_data = [(item["sa"],
                 item["ra"],
                 item["datetime"]) for item in reader if \
                item['station_id'] == station]

f.close()

print "Data for station %s" % (station)
print "\n".join(["%s\t%s\t%s" % (item) for item in station_data])

Output:

Code:

>>> Data for station 1070000016
-999	-888	2011-03-24 20:10:00
-999	-888	2011-03-24 20:20:00
-999	-888	2011-03-24 20:30:00
-999	-888	2011-03-24 20:40:00
-999	-999	2011-03-24 20:50:00
>>>

**Ben D** · Apr 5 '11, 03:09 PM

That was surprisingly straight forward - thank you very much!

How to parse csv using DictReader?

How to parse csv using DictReader?

Comment

Comment