csv parser example

csv_parser.py

#!/usr/bin/python

import csv
from StringIO import StringIO

with open('test.csv', 'rb') as f:
    data = f.read().decode('utf8')
    # remove unicode byte-order marker if it exists
    if data.startswith(u'\uFEFF'):
        data = data[1:]
        
reader = csv.reader(StringIO(data))

rows = iter(reader)
header = next(rows)
for row in rows:
    fields = dict(zip(header, row))
    print fields['Team'], fields['Comment']

test.csv