Skip to content

Instantly share code, notes, and snippets.

@tadejm
Created November 16, 2013 21:56
Show Gist options
  • Select an option

  • Save tadejm/7505866 to your computer and use it in GitHub Desktop.

Select an option

Save tadejm/7505866 to your computer and use it in GitHub Desktop.
# test.csv
#
# A,B,"C D"
# 1,2,"3 4"
# 5,6,7
import csv
ifile = open('test.csv', "rb")
reader = csv.reader(ifile)
rownum = 0
colnum = 0
data = []
for row in reader:
if rownum == 0:
header = row
else:
colnum = 0
for col in row:
row_data = {}
row_data[header[colnum]] = col
data.append(row_data)
colnum += 1
rownum += 1
print data
# [{'A': '1'}, {'B': '2'}, {'C D': '3 4'}, {'A': '5'}, {'B': '6'}, {'C D': '7'}]
ifile.close()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment