json2csv & csv2json

csv2json

#!/usr/bin/env python
#
# Converts a CSV (with column headers) to JSONL
#

import sys, csv, json

for row in csv.DictReader(sys.stdin):
    print(json.dumps(row))

json2csv

#!/usr/bin/env python
#
# Converts a JSONL (Json object per line) to CSV
#
# Note that columns will reflect the first JSON object processed.
#

import sys, csv, json


writer = None
for ln, row in enumerate(sys.stdin):

    try:
        data = json.loads(row)
    except:
        sys.stderr.write('Unable to parse JSON at line {}\n'.format(ln))

    if not writer:
        writer = csv.DictWriter(sys.stdout, fieldnames=data.keys())
        writer.writeheader()

    filtered = dict((k, data[k]) for k in data.keys() if k in writer.fieldnames)

    writer.writerow(filtered)