Python - replace integer in json body

Question

I need to replace an integer in a json body:

file1.json
{
    "id": 0,
    "col_1": "some value",
    "col_2": "another value"
}

I know to replace a string, I would use:

import json

with open('file1.json') as f:
    data = json.load(f)

data["col_1"] = data["col_1"].replace("some value", "new value")

But how would I replace the id, to the number 5 for example?

Why would you even use `data["col_1"].replace("some value", "new value")` and not `data["col_1"] = "new value"`? — mkrieger1, Jun 05 '23 at 16:51
sorry guys, I need more coffee I think. The answer seems obvious. Thanks — JD2775, Jun 05 '23 at 16:53

score 1 · Answer 1 · answered Jun 05 '23 at 16:51

You've got the right idea! Loading in the json as a string with json.load(path) and then manipulating the data in the instance is certainly the easiest way to do it. As the comments said, you can set that value with data["Column name"] = new value since once the data is read into python it's held as a dictionary.

What you need to do then is save the manipulated data item to .json, IIRC the function you're looking for is json.dump

I found a related post here: How do I write JSON data to a file?

Python - replace integer in json body

1 Answers1