Completed

Batch script to find values in multiple json files and replace with corresponding values from json list

I have a list of json files ([login to view URL], [login to view URL], ... ) Within each vp_***.json I need to replace 3 values which are different in each file. These 3 values should be replaced with corresponding values matching the file name from the list with corresponding values ([login to view URL]).

I need a script to batch process the file list on a Window 10 pc.

The 3 values to find are "yaw", "pitch" and "roll" within the position params, in each json file the. In the json file this looks like:

"position": {

"params": {

"yaw": -1.04677981999999986e2,

"pitch": -1.6903053837154232e1,

"roll": 4.40330644235072555,

Note that "yaw", "pitch" and "roll" occur a couple of times in each file for different parameters, "yaw", "pitch" and "roll" occur 4 times as “position” “params” only the values of the first occurrence should be replaced

In [login to view URL] the script should find the corresponding values for each file: lookup "vp_***" and find “ptgui_yaw” “ptgui_pitch” “ptgui_roll” values and use these values to replace "yaw", "pitch" and "roll" in "vp_***.json"

For [login to view URL] in the [login to view URL] this looks like:

vp_001", "ptgui_yaw": 255.322018, "ptgui_pitch": -12.96181767, "ptgui_roll": 3.821169483,

Note that the values in "vp_***" have a scientific notation eg. -1.04677981999999986e, the values to replace with do not have a scientific notation yet in the [login to view URL] but should get the same scientific notation.

For [login to view URL] the result should be:

"position": {

"params": {

"yaw": 2.55322018e2,

"pitch": -1.296181767e1,

"roll": 3.821169483,

Skills: Python

See more: parse json file in batch script, create json file in batch script, powershell json = get value by key, bash script to read values from json file, read json file in batch script, javascript replace multiple strings with one string, batch-file parse json, javascript replace multiple matches

About the Employer:
( 1 review ) ROTTERDAM, Netherlands

Project ID: #27545044

Awarded to:

DRG1990

Hi I have read your project details carefully I can do your project with my skill If you award me i will give good result Thanks

€140 EUR in 2 days
(5 Reviews)
4.0

14 freelancers are bidding on average €143 for this job

(64 Reviews)
6.3
asin1987

Dear Employer, I will write a tool which will take care of the three values from the JSON file that you are looking for. I am an expert with over a decade of experience. Kindly check my previous reviews here for your More

€200 EUR in 1 day
(29 Reviews)
6.4
(13 Reviews)
6.0
(56 Reviews)
5.5
sgadou

Hi, there. I am an applied data scientist. I am proficient in Python and JSON. Carefully checked your requirements. I can help you with this project. Hope we can discuss more deeply via chat. Best regards, Sgadou

€150 EUR in 1 day
(8 Reviews)
4.6
letsstartcoding

yes i m expert with python so i can replace 3 values which are different in each file

€200 EUR in 2 days
(10 Reviews)
4.6
ashikmohann

hi i have been working as data analyst for past 3 years and is proficient in python and r. i have gone through your project description and i can write the script for making the json files and provide detailed explana More

€160 EUR in 1 day
(17 Reviews)
4.7
Pashakolp31

✨✔⭐⭐Hello⭐⭐✔✨ My name is ✨Pavel✨ and strong experience in Python. If you hire me in the project, I will do my best. Best Regards

€140 EUR in 1 day
(6 Reviews)
4.1
alexeygrigorev91

Hello, sir. How are you? I have just read your project description and I can help you as my rich experiences. I have rich experiences in python I will give you the perfect result you are satisfied with. My clients have More

€150 EUR in 3 days
(6 Reviews)
4.2
CrazyProger

I'm a Python expert familiar with JSON. I read the job details extremely carefully. I think I can finish it for a short time with perfect result. I can achieve the results that you are asking for. I will wait for y More

€100 EUR in 1 day
(10 Reviews)
4.4
andrey0savelev

Hi, There. I am a python expert. I can do it perfectly on a short time Maybe we can use the python panda to parse the json or csv. Wish your kind response. Thank you, Andrey

€150 EUR in 3 days
(2 Reviews)
3.8
yurijklimov98

Hello Potential Client. I am professional software developer with 10 years experiences of JSON and Python. I have developed many Project. I can start working right now and can do it successfully. I’m waiting for your p More

€50 EUR in 1 day
(3 Reviews)
2.7
EkoLike

Hello. in desktop application, i am very excellent. java, c++, c#, vba, python etc. and also i am good at algorithm project just DFS, BFS, A*, Uniform, Greedy Algorithm before I was in many desktop app such as c++, c More

€140 EUR in 1 day
(1 Review)
2.3