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

Færdiggjort Opslået 5 år siden Betalt ved levering
Færdiggjort

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)

JSON Python Software Arkitektur

Projekt ID: #16535055

Om projektet

4 bud Remote projekt Aktiv 5 år siden

Tildelt til:

sanatana57

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

£3 GBP / time
(10 bedømmelser)
3.1

4 freelancere byder i gennemsnit £4/timen for dette 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 Flere

£3 GBP / time
(84 bedømmelser)
7.4
umg536

A proposal has not yet been provided

£5 GBP / time
(19 bedømmelser)
6.1
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 / time
(0 bedømmelser)
0.0