Nov-27-2019, 03:51 AM
using below script i am getting error at multilevel. When i use get for x["salary"][0]["SID"] i get error in script
import json import csv with open('/local/dummy.json') as f: json_data = json.load(f, strict=False) with open('/local/application.csv', 'w') as outfile: csv_write = csv.writer(outfile) csv_write.writerow(["id", "SID", "Type", "ttt"]) for x in json_data["dummy"]: csv_write.writerow([x["id"], x["name"], x.get("name",'None'), x["salary"][0]["SID"]])