Simple (incorrect) parsing of a csv file.

calories.csv

etl.py

def parse_file(path):
    with open(path, 'rb') as f:
        header = f.readline().split(",")
        for line in f:
            fields = line.split(",")
            entry  = {}
            
            for i, val in enumerate(fields):
                entry[header[i].strip()] = val.strip()
            
            yield entry

if __name__ == "__main__":
    for row in parse_file('calories.csv'):
        print row
            

etl2.py

import unicodecsv as csv

def parse_file(path):
    numeric_fields = ('Weight (g)','kCal','Fat (g)','Carbo(g)','Protein (g)')

    with open(path, 'rb') as f:
        reader = csv.DictReader(f, delimiter=',', quotechar='"')

        for idx, row in enumerate(reader):
            if idx == 0: continue
            for field in numeric_fields:
                row[field] = float(row[field])

            yield row

if __name__ == '__main__':
    for row in parse_file('calories2.csv'):
        print row