A simple snippet that can be used to read CSV files with headers

dcsv.py

"""
A simple snippet that can be used to read CSV files with headers
"""

import csv
from contextlib import contextmanager

@contextmanager
def dcsv(filename):
    with open(filename) as reader:
        dialect = csv.Sniffer().sniff(freader.read(8096))
        freader.seek(0)

        fields = csv.reader(reader, dialect).next()
        yield csv.DictReader(reader, fields, dialect=dialect)
        
if __name__ == "__main__":
  with dcsv("example.csv") as reader:
    for line in reader:
      print(line["id"], line["name"])