TypeError : Trouble accessing JSON metadata with Python

Question

So I'm trying to access the following JSON data with python and when i give the statement :

print school['students']

The underlying data gets printed but what I really want to be able to do is print the 'id' value.

   { 'students':[  
                  {  
                     'termone':{  
                        'english':'fifty',
                        'science':'hundred'
                     },
                     'id':'RA1081310005'
                  }
               ]
   }

So when I do the following I get an error :

 print school ['students']['id']

TypeError: list indices must be integers, not str

Can anyone suggest how i can access the ID & where I'm going wrong!

students is a list of students, not a dictionnary. so school["students"][0]['id'] — Stephane Martin
– Stephane Martin, Commented Dec 12, 2016 at 23:15

user2285236 · Accepted Answer · 2016-12-12 23:15:51Z

2

school['students'] is a list. You are trying to access the first element of that list and id key belongs to that element. Instead, try this:

school['students'][0]['id']
Out: 'RA1081310005'

answered Dec 12, 2016 at 23:15

user2285236

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

Comments

sporkl · Accepted Answer · 2016-12-12 23:20:33Z

0

The problem here is that in your list, 'id' is not a part of a dictionary, it is part of a list. To fix this, change your dictionary to the following:

school = {'students':{
            'termone': {
                "english": "fifty:,
                "science": "hundred
            },
            "id":"RA1081310005"
        }
}

Basically, you have a list, and there is no reason to have it, so I removed it.

answered Dec 12, 2016 at 23:20

sporkl

4016 silver badges19 bronze badges

Collectives™ on Stack Overflow

TypeError : Trouble accessing JSON metadata with Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related