

Method 1: Using CSV module: It is a built-in Python module that implements classes for reading & writing tabular data in CSV structure. These keys will be the headers for the CSV file and the values as descriptive data that remain indented in json. So, here I did got my answer but instead of printing it once, It is printing 7 times. import json import csv f open ('data.json') data json.load (f) f.close () f open ('data.csv') csvfile csv.writer (f) for item in data: csvfile.writerow (item) f.close () However, it did not work. JSON data usually contains data in key-value pairs. 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 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,
