JSON To CSV using Python

[@xx-jl3gl]

Thank you! It works perfectly

[@AshishKumar-us2nd]

Thanks! Great help

[@iam9_39]

❤❤❤ thanks a lot

[@akbarxojaabduraximov7427]

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

[@soulmusic9274]

time 12:01 is solution

[@abisandy1481]

My json file structure is
[
{
"attributes":{
"Phone" : [
{
"Label": "abcd"
"Value":{
" Type":[
{
"Type": " Xyz"
}
]
In this structure, how could i read key values?

[@sujitreddy7702]

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

[@akashkumar-m5u9n]

not able to see csv in table form

[@akbarxojaabduraximov7427]

import json
def export_to_csv():
with open("D:/Scripting/ToShPfile.json") 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)) + "
")

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()

[@soulmusic9274]

in def add_items_to_ToShPfile change get_header_items to add_items_to_ToShPfile

[@millertk]

@@soulmusic9274 Yeah, he made this error in the video and then corrected himself. Whomever put the code in the comments used that version before he fixed it to be recursive.

[@marcosd3976]

key typiyng is anoying