So, here I did got my answer but instead of printing it once, It is printing 7 times. You can install pandas using pip running this command: pip install pandas Step 2: Load the JSON file Let’s load the JSON file using the json Python module: import json with open('input.json', encoding'utf-8') as file: data json.loads(file. 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, import json import csv print('Program to demostrate conversion of json to csv') print(' ') with open('JSONdata.json') as jsonfile: info json.load( jsonfile) print('JSON file JSONdata.json is opened for reading') print(' ') empinfo info 'empdetails' csvfile open('convertercsvfile.
0 kommentar(er)
