QScend json -> csv

parse.py

# -*- coding: utf-8 -*-

import json
import csv
import urllib2

def load_from_url(url):
    raw_data = urllib2.urlopen(url).read().decode('utf-8').rstrip()

    # standardize file endings
    raw_data = raw_data.replace('\r\n', '\n').replace('\r', '\n')

    return json.loads(raw_data.rstrip('\n'))

def load_from_file(filename):
    with open(filename) as f:
        raw_data = f.read()

    raw_data = raw_data.replace('\r\n', '\n').replace('\r', '\n')

    return json.loads(raw_data.rstrip('\n'))

def load_json(target, from_file=False):
    if from_file:
        return load_from_file(target)
    return load_from_url(target)

if __name__ == '__main__':
    data = load_json('./input.json', from_file=True)

    with open('./output2.csv', 'w') as f:
        writer = csv.DictWriter(f, fieldnames=data[0].keys())
        writer.writeheader()
        for row in data:
            writer.writerow({k: unicode(v).encode('utf-8') for k, v in row.items()})