#jsonTocsv #snippet

jsonTocsv.py

import json
import sys
from flatten_json import flatten
import pandas as pd 

#check if you pass the input file
if sys.argv[1] is not None:
  fileInput = sys.argv[1]
    
  inputFile = open(fileInput) #open json file
 
  data = json.load(inputFile) #load json content

  flattened = (flatten(d) for d in data)
  
  inputFile.close() #close the input file
  
  # for item in flattened.items():
  #   print(item)
  #   print(type(item))
  
  # print(type(flattened))
  
  df = pd.DataFrame(flattened)
  
  print(df) 
  
  df.to_csv('output.csv',index=False)  
    
"""
Usage

$ python jsonTocsv.py input.json
"""