quick csv2json example

gistfile1.py

#!/usr/bin/env python
"""
Usage: cat mycsvfile.csv | ./csv2json.py > myjson.json
"""
import fileinput
import json

rows = []
headers = []
first_row = True

for line in fileinput.input():
    if first_row:
        headers = [h.strip() for h in line.split(',')]
        first_row = False
    else:
        cols = [c.strip() for c in line.split(',')]
        seq = [(headers[i], cols[i]) for i in range(0, len(headers))]
        rows.append({key:val for (key, val) in seq})

print json.dumps(rows, indent=2)