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:
github.com/bug...

[@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.

[@akashkumar-m5u9n]

not able to see csv in table form

[@iam9_39]

❤❤❤ thanks a lot

[@abisandy1481]

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

[@xx-jl3gl]

Thank you! It works perfectly

[@AshishKumar-us2nd]

Thanks! Great help

[@sujitreddy7702]

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

[@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

[@marcosd3976]

key typiyng is anoying