I need to format the outfile in this code. Currently everything is printed on one line. How do I add columns, headers and in new rows?

See more:

Linux

Python

JSON

formatting

NVD - Data Feeds[^]

I am reading the json nvd feed in the above link and trying to output the ID and the impactScore. I did all these but I don't know how to format the output file, like add each in columns with headers and new rows. Please help me or guide me to a link that will teach me this. I tried online sources but couldn't find any. Thank you!

What I have tried:

#!/usr/bin/python
# -*- coding: utf-8 -*-

import json

with open('nvdcve.json', 'r') as f:
    cve_dict = json.loads(f.read())


i = 0

with open('analyse.json', 'w') as outfile:

    for i in range(0, 5949):
        try:
            nvd_impact = cve_dict['CVE_Items'][i]['impact'
                    ]['baseMetricV2']['impactScore']
            nvd_id = cve_dict['CVE_Items'][i]['cve']['CVE_data_meta']['ID']
            json.dump(nvd_impact, outfile)
            json.dump(nvd_id, outfile)
            print (nvd_id)
        except KeyError:
            continue