Convert JSON to CSV Using python in learncodepuython

 

Convert JSON to CSV  

This script will convert your JSON data to a CSV file. It takes .json a file as input and provides .csv the file as output.

Installation 

        pip install json  

import json

#code pythonic

if __name__ == '__main__':

  try:

    with open('input.json', 'r') as f:

      data = json.loads(f.read())

      output = ','.join([*data[0]])

      for obj in data:

       output += f'\n{obj["Name"]},{obj["age"]},{obj["birthyear"]}'

      with open('output.csv', 'w') as f:

       f.write(output)

  except Exception as ex:

   print(f'Error: {str(ex)}')