write python script to change nested JSON bank statement files to CSV
£2-5 GBP / hour
已完成
已发布大约 6 年前
£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 '[login to view URL]' and '[login to view URL]' 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("[login to view URL]", "r") as inputFile: # open json file
data = [login to view URL]([login to view URL]()) # load json content
data['PTransactionDate'] = []
data ['PValueDate'] = []
data ['PNarration'] = []
with open("[login to view URL]", "w") as outputFile: # open csv file
output = [login to view URL](outputFile, [login to view URL]()) # create a writer
[login to view URL]()
[login to view URL](data)
Hi, Dear Employer!
How are you?
I am really interested in your project.
I have enough experience on python, C/C++, C#, java programming.
I am 100% sure i can satisfy your requirements perfectly.
User-Friendly Interface And Clear Algorithm Will Encourage Your Project.
I want a long term relationship with you.
Thank you and best regards!