Nov-26-2019, 01:24 PM
i have nested json inside json like below: -
[json]
<a>
<Id>3</Id>
<name>IT</name>
<axe>
<prog>
<progr>C#</progr>
</prog>
</axe>
[/json]
When i am trying pull selected column using below , i am getting blank values for column=progr
[json]
<a>
<Id>3</Id>
<name>IT</name>
<axe>
<prog>
<progr>C#</progr>
</prog>
</axe>
[/json]
When i am trying pull selected column using below , i am getting blank values for column=progr
import json import csv with open('/local/a.json','r') as f: json_data=json.load(f,strict=False) with open('/local/a.csv','w') as outfile: csv_write=csv.writer(outfile,quoting=csv.QUOTE_ALL) csv_write.writerow(["Id", "progr"]) for json_d in json_data["a"]: row_array = [] try: row_array.append(json_d["Id"]) except KeyError: row_array.append('') try: row_array.append(json_d["a"]["axe"]["prog"]["progr"]) except (KeyError,TypeError): row_array.append('') except TypeError: row_array.append('') csv_write.writerow(row_array) outfile.close()