JSON To CSV using Python

In this video we will convert a JSON object to CSV using python. The code for this video is located in the GitHub repo:

[sujitreddy]

Hey how can I contact you? I need some help with modifying this use case a bit.

[abisandy]

My json file structure is
[
{
"attributes":{
"Phone" : [
{
"Label": "abcd"
"Value":{
" Type":[
{
"Type": " Xyz"
}
]


In this structure, how could i read key values?

[akbarxojaabduraximov]

Hello,

I had a problem, I wrote a script according to your instructions and as a result I get only columns, and the data in these columns is not exported

[akbarxojaabduraximov]

import json

def export_to_csv():
with as f:
list1 = []
ToShPfile = json.loads(f.read())
temp = ToShPfile[0]
header_items = []
get_header_items(header_items, temp)
list1.append(header_items)

for obj in ToShPfile:
d = []
add_items_to_ToShPfile(d, obj)
list1.append(d)

with open ('output.csv', 'w') as output_file:
for a in list1:
output_file.write(', '.join(map(str, a)) + "\r")

def get_header_items(items, obj):
for x in obj:
if isinstance(obj[x], dict):
items.append(x)
get_header_items(items, obj[x])
else:
items.append(x)


def add_items_to_ToShPfile(items, obj):
for x in obj:
if isinstance(obj[x], dict):
items.append("")
get_header_items(items, obj[x])
else:
items.append(obj[x])

export_to_csv()