write python script to change nested JSON bank statement files to CSV
Budget £2-5 GBP / hour
I have the following JSON file(attached), I need it to be changed to a CSV file looking like the one that has been uploaded.
I can use a converter to do this, however I would like someone to write a short python script for me where I only have to change the '[url removed, login to view]' and '[url removed, login to view]' file names or something similar, or as close to that result as possible as I have many many different files with the exact same format that I need to convert to CSV.
I'm inexperienced in Python so I've tried this(below) and failed - thanks!
import csv
import json
with open("[url removed, login to view]", "r") as inputFile: # open json file
data = [url removed, login to view]([url removed, login to view]()) # load json content
data['PTransactionDate'] = []
data ['PValueDate'] = []
data ['PNarration'] = []
with open("[url removed, login to view]", "w") as outputFile: # open csv file
output = [url removed, login to view](outputFile, [url removed, login to view]()) # create a writer
[url removed, login to view]()
[url removed, login to view](data)
Awarded to:
Experienced professional in python. Have worked in multiple data extraction formats. Such as PDF, JSON, HTML using python.
5 freelancers are bidding on average £5/hour for this job
Hi I have gone through your requirement. please send me your requirement. we have professional team for your project. please contact for work.