jsonline2csv.py

#!/usr/bin/env python3

# jsonline to csv converter for Andy

import csv
import json
import sys

if len(sys.argv) < 2:
    print("Use {} <file.jsonline>".format(sys.argv[0]))
    sys.exit(1)

writer = None

with open(sys.argv[1]) as fh:
    for line in fh:
        blob = json.loads(line.strip())
        if not writer:
            writer = csv.DictWriter(sys.stdout, fieldnames=blob.keys())
            writer.writeheader()
        writer.writerow(blob)