Python (json) How to add every key of same name to the list

Question

I need to add every value from key name and from key age to the list

But after start of this code there is:

for i in len(jsondata['name']): builtins.KeyError: 'name'

But you see that I have "name": "husky", and "name": "shiba inu", in second one. So what would you rewrite?

Thank you

import json

names=[]
ages=[] 


#f = open('jsondata.json')

with open('jsondata.json') as fp:
    jsondata = json.load(fp)


for i in len(jsondata['name']):
    names.add(jsondata['name'])

for i in len(jsondata['age']):
    ages.add(jsondata['age'])

f.close()

Json file:

{
    "dogs": [
        {
            "name": "husky",
            "age": "12",
            "urls": [
                "https://www.dailypaws.com/dogs-puppies/dog-names/husky-names",
                "https://www.tonbridgehuskymalamutewalkinggroup.co.uk/"
            ]
        },
        {
            "name": "shiba inu",
            "age": "3",
            "urls": [
                "https://www.cryptoglobe.com/latest/2021/10/shiba-inu-shib-listed-on-trading-app-with-over-one-million-users/",
                "https://www.purina.co.uk/find-a-pet/dog-breeds/japanese-shibu-inu"
            ]
        }
    ]
}

Kartheek Tammana · Accepted Answer · 2021-10-30 11:10:07Z

1

for dog in jsondata["dogs"]:
    names.append(dog["name"])
    ages.append(dog["age"])

answered Oct 30, 2021 at 11:10

Kartheek Tammana

806 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dhana D. · Accepted Answer · 2021-10-30 11:12:44Z

0

You need to get the nested order. As you see, the key 'name' is under 'dogs', then the key 'name' does not exist under . Thus, you need to call it as

for i in range(len(jsondata['dogs'])):
    names.append(jsondata['dogs'][i]['name'])

If you want to get the entries

edited Oct 30, 2021 at 11:12

answered Oct 30, 2021 at 11:04

Dhana D.

1,7424 gold badges15 silver badges41 bronze badges

3 Comments

Jiří Baum Over a year ago

The 'dogs' field contains a list?

Miroslav Over a year ago

To which line do you think?

Dhana D. Over a year ago

Edited that. The 'dogs' field is indeed contains a list.

Talal Siddiqui · Accepted Answer · 2021-10-30 11:17:06Z

0

You should apply the loop over dogs element

name = []
age = []
data = """{
  "dogs": [
    {
      "name": "husky",
      "age": "12",
      "urls": [
        "https://www.dailypaws.com/dogs-puppies/dog-names/husky-names",
        "https://www.tonbridgehuskymalamutewalkinggroup.co.uk/"
      ]
    },
    {
      "name": "shiba inu",
      "age": "3",
      "urls": [
        "https://www.cryptoglobe.com/latest/2021/10/shiba-inu-shib-listed-on-trading-app-with-over-one-million-users/",
        "https://www.purina.co.uk/find-a-pet/dog-breeds/japanese-shibu-inu"
      ]
    }
  ]
}"""
    for m in data['dogs']:
        u_name= name.append(m.get('name','N/A'))
        u_age = age.append(m.get('age','N/A'))

m.get('age','N/A') statement will work as an if-else statement in JSON

edited Oct 30, 2021 at 11:17

answered Oct 30, 2021 at 11:05

Talal Siddiqui

1061 silver badge8 bronze badges

Collectives™ on Stack Overflow

Python (json) How to add every key of same name to the list

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related