best way to index by value of the header in a 2d list

Question

This solution sort of works but is extremely ugly:

rowIndex = 3
sheet = list(csv.reader(open('ObserverLog.csv'))) 
print sheet[rowIndex][sheet[0].index("Message sent? (Y/N)")]

It seems like there ought to be a way to make it work like this:

print sheet[rowIndex]["Message sent? (Y/N)"]

score 2 · Accepted Answer · answered May 27 '15 at 00:14

2

DictReader will read each row as a dictionary:

list(csv.DictReader(open('ObserverLog.csv')))

Returns a list of dictionary, so

sheet[rowIndex]["Message sent? (Y/N)"]

would work.

answered May 27 '15 at 00:14

zw324

This works well enough. not totally what I wanted but it is exactly what I asked for. haha. An unanticipated consequence of this is I can't reference by index anymore. but that's OK. – gnarbarian May 27 '15 at 00:49
@gnarbarian Well if you really want to have all the power you can try using pandas, which is great :-) – zw324 May 27 '15 at 00:51

1 Answers1