Question 110338 in Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

modifiy data of json file

How can I modify the values of json file using python?
so my json file is:

{
  "roll no": "210",
  "school": "DAP",
  "city": "Delhi",
  "hobbies": [
    {
      "dance": "yes"
    },
 {
      "singing": "yes"
    },
 {
      "travel": "yes"
    },
            ]
}

so this is my json and I want to replace the values like:
roll no= 211 and travel="no" ,singing="no"

I have tried:

with open("student.json","r") as file:
    data=json.load(file)
    data["roll no"]= "211"
    
    for x in data:
        x["hobbies"]["singing"]="no"
        x["hobbies"]["travel"]="no"

            
        with open("student.json","w") as file:

        json.dump(data,file,indent=4)

I have tried this but the only change I’m able to doing is roll no,but I’m unable to change the hobbies values
expected output:

{
  "roll no": "211",
  "school": "DAP",
  "city": "Delhi",
  "hobbies": [
    {
      "dance": "yes"
    },
 {
      "singing": "no"
    },
 {
      "travel": "no"
    },
            ]
}
Tags:

3

Answers


  1. 0

    ‘hobbies’ is a list of dict so you should write:

    with open("student.json", "r") as file:
    data = json.load(file)

data["roll no"] = "211"
data["hobbies"][1]["singing"] = "no"
data["hobbies"][2]["travel"] = "no"

        
with open("student.json","w") as file:
    json.dump(data, file, indent=4)
    Login or Signup to reply.
  2. 0

    Here is how i have updated hobbies for new roll number

    import json

json_data = '''{
  "roll no": "210",
  "school": "DAP",
  "city": "Delhi",
  "hobbies": [
    {
      "dance": "yes"
    },
 {
      "singing": "yes"
    },
 {
      "travel": "yes"
    }
            ]
}
'''

data = json.loads(json_data)

data["roll no"] = "211"
for hobby in data["hobbies"]:
    for upd_hobby in ["singing", "travel"]:
        if upd_hobby in hobby:
            hobby[upd_hobby] = "no"

print(json.dumps(data, indent=4))

    Output:

    {
    "roll no": "211",
    "school": "DAP",
    "city": "Delhi",
    "hobbies": [
        {
            "dance": "yes"
        },
        {
            "singing": "no"
        },
        {
            "travel": "no"
        }
    ]
}
    Login or Signup to reply.
  3. 0

    As i said in above comment, you will get an error while passing index as string to list.

    See below code

    with open("./students.json", "r") as file:
  data = json.load(file)

    Methode 1 (If the hobbies are hardcoded)

    data["roll no"] = "211"
data["hobbies"][1]["singing"] = "no"
data["hobbies"][2]["travel"] = "no"

    Method 2 (if you want to dynamically include some hobbies to change their state ‘yes’ – ‘no’)

    hobbies_inc = ["singing", "travel"] # Create a list hobbies, that need to be included

for x in data["hobbies"]:
   if list(x)[0] in hobbies_inc:
        x[list(x)[0]] = "no"
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search