Convert JSON to CSV

In [ ]:

    

import json
import csv


    

In [ ]:

    

# Open the file 'bills.json' in the project2/data/ directory
with open('../project2/data/bills.json', 'r') as f:
    # Convert it to a dict
    data = json.load(f)
    
    # Each bill is stored in an array in `data` with the key `objects`
    # Create a variable for easy access to the data we care about
    objects = data['objects']
    
    # Create a csv file to output in the same directory
    with open('../project2/data/bills.csv', 'w') as o:
        # Create a csv writer. This will help us format the file
        # correctly.
        writer = csv.writer(o)
        
        # Write out the header row
        writer.writerow([
            'title',
            'label',
            'number',
            'current_status'
        ])
        
        # Iterate through each dict in the array `objects`
        for bill in objects:
            writer.writerow([
                bill['title_without_number'],
                bill['bill_type_label'],
                bill['number'],
                bill['current_status']
            ])