namedtupleでcsvの各行をリストではなく定義した列名をキーとした辞書として扱う

gistfile1.py

import csv
import itertools
from collections import namedtuple

# 列名のリスト
fields = ['foo', 'bar', 'baz', 'spam']

Row = namedtuple('Row', ' '.join(fields))

def reader(fp):
    reader = csv.reader(fp)
    return itertools.imap(Row._make, reader)

for row in csv.reader(open('example.csv')):
    print row
    # -> ['FOO', 'BAR', 'BAZ', 'SPAM']

for row in reader(open('example.csv')):
    row = row._asdict()
    print row
    # -> OrderedDict([('foo', 'FOO'), ('bar', 'BAR'), ('baz', 'BAZ'), ('spam', 'SPAM')])
    print row['foo']
    # -> FOO