In Progress

write a python script to automate parse JSON files

1: I have a folder that has several hundred .json files (but this should not matter since files can be added or deleted)

2: Each .json files has several hundred JSON DATA OBJECTS with exact DATA STRUCTURE below...


"time": 1515513600,

"close": 2.31,

"high": 2.33,

"low": 2.27,

"open": 2.28,

"volumefrom": 5390392.99,

"volumeto": 12463380.06,

"reference": "CORN"

}, {




The above is array of JSON DATA object... values will change and will be different..BUT "keys" are same.

The "time": VALUE from one JSON DATA OBJECT are 1 hr EXACT difference..

3: What I need you to do is calculate -> mean, median, average, standard deviation, z-score for the "open" and "volumeto" datas ONLY.. FOR 1 YEAR EACH and 1 DAY EACH. 1st jan 2014 -> 31st december 2014 and so on... The new file generated by python script will have a JSON DATA OBJECT like this:


"timefrom": 1396944000,

"timeto": 1396964000,

"openmean": 472.23,

"openmedian": 472.23,

"openaverage": 472.23,

"openstddeviation": 472.23,

"openzscore": 472.23,

"volumetomean": 472.23,

"volumetomedian": 472.23,

"volumetoaverage": 472.23,

"volumetostddeviation": 472.23,

"volumetozscore": 472.23,

"reference": "CORN"

}, {






"timefrom":..... is 1st Jan 2014.. and "timeto":..... is 31st december 2014.. those values are in UNIX TIME...

remember that the python script has to do this automatically for all the files available on the folder that has files .json...also remember that alllll the files will have exact same JSON DATA OBJECT AND EACH JSON DATA OBJECT is 1 hour difference.. the "time"..

4: Things to note:... our data TIME starts from around 1st JAN 2014 ONLY... not before(like 2013)... and will go on.. it may go for 3 years like 2014 to 2017 or it may go from 2014 to 2015...

the generated file should be called yearly{filename}.json AND day{filename}.json ... here {filename} is the name of original file parsed..

This is a fixed budget of 30$ with reoccurring projects and enhancement...

Skills: Python, Scripting, Test Automation

See more: write python script, python script automate data download website, python script copy paste text files, writing json to csv in python, python parse json file example, python read json file line by line, pandas csv to json, csv string to json python, csv to json python pandas, csv2json python, python csv to nested json, python, python script parse log files error, python script parse log files, python script parse text files, python script automate website, python script convert excel json, python script automate data entry website, python script parse csv files, need write python script telit gc864quad module

About the Employer:
( 1 review ) SLC, United States

Project ID: #16068646

Awarded to:


Hi There, I am a software engineer with skill of PHP, Python, Software Architecture, Web Scraping, Java,, C#... I would like to complete your project as your requrement

$30 USD in 1 day
(4 Reviews)

24 freelancers are bidding on average $96 for this job


Hello, I'd be glad to develop the JSON parsing software for you. Looking forward to chat with you soon for more details. Best regards,

$188 USD in 2 days
(106 Reviews)

Dear,Sir How are you? I have read your project description and I have noticed that I have experienced in similar project so I am sure that I can help you in this project. I have experienced in developing JSON par More

$155 USD in 3 days
(25 Reviews)

"Budget is negotiable, according to your requirement." IIT Roorkee undergraduate student. 3+ years of experience in the Data Science domain. Proficient in Python, R Programming, SAS, Matlab etc. Relevant experience wi More

$45 USD in 3 days
(27 Reviews)

Hi there. My name is Daniel, and I would be glad to help you out. I am an engineer, which is why I dont have any issues performing the calculations that you required, plus I have over 3 yrs of experience coding in orde More

$199 USD in 5 days
(11 Reviews)

rich experience in parsing Json data using python.

$187 USD in 2 days
(12 Reviews)

I have experience with JSON and Python scripts. Is there dependency from reference? Multiple references from each json file? Or just one like "CORN"? I will use statistics module [login to view URL] More

$30 USD in 3 days
(10 Reviews)
$88 USD in 2 days
(17 Reviews)

Hi, I have lots of python and json experience. Let me do it for you. Thanks Relevant Skills and Experience Python

$30 USD in 1 day
(7 Reviews)

Hello! I can make json parsing script according to your requirements. It may take 1-2 days.

$30 USD in 3 days
(6 Reviews)

Hi! My name is Enrique. I am a Python developer with 4 years of experience. In the past, I have done projects like this were extraction from JSON files is needed. The last project similar to this one was to extract More

$133 USD in 3 days
(9 Reviews)

Hi, I am a python based developer with a 2+ years of industrial experience. Have done a lot of file handling and json data handling using python. Would like to discuss requirements over chat. Have a look at my rat More

$55 USD in 3 days
(4 Reviews)

I can do it in a short time. It is not hard job. I have familiar jobs done. It wont take much time . You dont worry

$55 USD in 1 day
(4 Reviews)

Hello I have read and understood your requirements. I have a lot of experience handling json files with python and I would love to help you build this tool. Don't hesitate to contact me with any question you might ha More

$30 USD in 2 days
(5 Reviews)

I have good hand experience in python and i am working on same technology since last two years. In addition to that working on Json

$30 USD in 5 days
(1 Review)

A proposal has not yet been provided

$150 USD in 2 days
(0 Reviews)

I have four years of industrial experience in python language I have expertise in json files. I have build 15 products. I already solve these problems. I will deliver quality work in a very short time

$50 USD in 1 day
(0 Reviews)

A proposal has not yet been provided

$30 USD in 1 day
(0 Reviews)

A proposal has not yet been provided

$222 USD in 10 days
(0 Reviews)
$155 USD in 3 days
(0 Reviews)

I am very familiar with writing code in Python and have done some work woth JSON. This would be right up my alley.

$35 USD in 3 days
(0 Reviews)