Completed

write python script to change nested JSON bank statement files to CSV

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)

Skills: JSON, Python, Software Architecture

See more: json to csv github, nested json to csv python pandas, python flatten json to csv, json file to csv script, nested json to csv javascript, convert nested json to csv online, convert nested json to csv c#, convert nested json to csv python, bank statement excel csv, write a python script, python script to change text from html, python script write register, python script json processing, python script write, write python script

About the Employer:
( 0 reviews ) United Kingdom

Project ID: #16535055

Awarded to:

sanatana57

Experienced professional in python. Have worked in multiple data extraction formats. Such as PDF, JSON, HTML using python.

£3 GBP / hour
(3 Reviews)
2.1

5 freelancers are bidding on average £5/hour for this job

super2lao

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 Int More

£3 GBP / hour
(74 Reviews)
7.3
sergey4kim

Python Expert! . . .

£8 GBP / hour
(8 Reviews)
3.6
umg536

A proposal has not yet been provided

£5 GBP / hour
(0 Reviews)
0.0
chiragtech

Hi I have gone through your requirement. please send me your requirement. we have professional team for your project. please contact for work.

£5 GBP / hour
(0 Reviews)
0.0