Breaking News: Grepper is joining You.com. Read the official announcement!

convert nested json to csv python

mnk answered on July 5, 2022 Popularity 8/10 Helpfulness 4/10

answer convert nested json to csv python

convert nested json to csv python

Comment

import json
import csv

def get_leaves(item, key=None):
    if isinstance(item, dict):
        leaves = []
        for i in item.keys():
            leaves.extend(get_leaves(item[i], i))
        return leaves
    elif isinstance(item, list):
        leaves = []
        for i in item:
            leaves.extend(get_leaves(i, key))
        return leaves
    else:
        return [(key, item)]


with open('json.txt') as f_input, open('output.csv', 'w', newline='') as f_output:
    csv_output = csv.writer(f_output)
    write_header = True

    for entry in json.load(f_input):
        leaf_entries = sorted(get_leaves(entry))

        if write_header:
            csv_output.writerow([k for k, v in leaf_entries])
            write_header = False

        csv_output.writerow([v for k, v in leaf_entries])

Popularity 8/10 Helpfulness 4/10 Language javascript

Source: stackoverflow.com

Tags: csv javascript nested-json python

Link to this answer
Share Copy Link