Find Jobs
Hire Freelancers

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

£2-5 GBP / hour

Completed
Posted about 6 years ago

£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)
Project ID: 16535055

About the project

4 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Experienced professional in python. Have worked in multiple data extraction formats. Such as PDF, JSON, HTML using python.
£3 GBP in 5 days
5.0 (10 reviews)
3.1
3.1
4 freelancers are bidding on average £4 GBP/hour for this job
User Avatar
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!
£3 GBP in 40 days
4.8 (84 reviews)
7.4
7.4
User Avatar
A proposal has not yet been provided
£5 GBP in 15 days
5.0 (19 reviews)
6.1
6.1
User Avatar
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 in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
london, United Kingdom
5.0
2
Payment method verified
Member since Mar 21, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.