Simple code in python
Budget: $30 – $250 USD
PYTHON:
I have a folder containing a lot of .json files. I want to edit all of these json by adding a new key and values like
Original json:
{"type":{"version":"1.0","name":"TEXT"},"value":{"OLD_KEY1": "OLD_VAL1", "OLD_KEY2": "OLD_VAL2", etc
Desired json after update:
{"type":{"version":"1.0","name":"TEXT"},"value":{"NEW_KEY": ["NEW_VAL1", "NEW_VAL2", "NEW_VAL3", "NEW_VAL4", "NEW_VAL5", "NEW_VAL6", "NEW_VAL7"],"OLD_KEY1": "OLD_VAL1", "OLD_KEY2": "OLD_VAL2", etc
I also have a csv file containing two columns. First column is a unique substring of the name of the json file and the second column is the list of NEW_VAL1, NEW_VAL2, NEW_VAL3 etc corresponding to each row which I want to add to the json as mentioned in the subject.
I have a folder containing a lot of .json files. I want to edit all of these json by adding a new key and values like
Original json:
{"type":{"version":"1.0","name":"TEXT"},"value":{"OLD_KEY1": "OLD_VAL1", "OLD_KEY2": "OLD_VAL2", etc
Desired json after update:
{"type":{"version":"1.0","name":"TEXT"},"value":{"NEW_KEY": ["NEW_VAL1", "NEW_VAL2", "NEW_VAL3", "NEW_VAL4", "NEW_VAL5", "NEW_VAL6", "NEW_VAL7"],"OLD_KEY1": "OLD_VAL1", "OLD_KEY2": "OLD_VAL2", etc
I also have a csv file containing two columns. First column is a unique substring of the name of the json file and the second column is the list of NEW_VAL1, NEW_VAL2, NEW_VAL3 etc corresponding to each row which I want to add to the json as mentioned in the subject.