Step 3: Flatten JSON to df using pd.jsonnormalize. Convert Pandas Dataframe to CSV, thus converting the JSON file to CSV. Then, we can open a CSV file using the csv.writer() method and write the header row and data rows to the CSV file. First, we need to load the JSON data into a Python dictionary using the json.loads() method.

Convert the JSON file to Pandas Dataframe. We will use the built-in json and csv modules in Python to convert this JSON data to CSV format. Flatten the JSON file using jsonnormalize module. We will read the JSON file using json module.

So, here I did got my answer but instead of printing it once, It is printing 7 times. Step 2: Read the nested JSON file as line. You can easily convert a flat JSON file to CSV using Python Pandas module using the following steps:- 1. Output userID,Is salary credited before 5th,Avg Salary of last 3 months,Avg Salary of last 6 months,Avg Balance before salary of last 3 months,Avg Balance before salary of last 6 monthsĦ79d3bad-155e-4b39-9ff7-7d564f408942,Yes,15453.33,15290.5,113.15,105.22 Example: Suppose the JSON file looks like this: We want to convert the above JSON to CSV file with key as headers. Following is my json file input Ĭode with open('/Users/vrindabv/Documents/PycharmProjects/BankStatementEngine/test.json', 'r') as f:į = csv.writer(open('/Users/vrindabv/Documents/PycharmProjects/BankStatementEngine/test.csv', 'w'))į.writerow()į.writerow(, x, Converting JSON to CSV For simple JSON data consisting of key and value pairs, keys will be headers for the CSV file and values the descriptive data.

Convert json to csv python