JSON concatenate, dump to CSV

json_concat_to_csv.py

import json
import csv

# open a file for writing
data = open('trumptweets.csv', 'w')

# create the csv writer object
csvwriter = csv.writer(data)

#write the header

data_files = ['2009.json', '2010.json', '2011.json',
	      '2012.json', '2013.json', '2014.json',
	      '2015.json', '2016.json', '2017.json']

count = 0
for data_file in data_files:
    with open(data_file) as f:    
        data = json.load(f)
        for tweet in data:
            if count == 0:
                csvwriter.writerow(tweet.keys())
            csvwriter.writerow(tweet.values())
            count += 1
        f.close()