Getting JSON info in python

Question

Sample of the database:

"metros" : [
        {
            "code" : "SCL" ,
            "name" : "Santiago" ,
            "country" : "CL" ,
            "continent" : "South America" ,
            "timezone" : -4 ,
            "coordinates" : {"S" : 33, "W" : 71} ,
            "population" : 6000000 ,
            "region" : 1
        } , {
            "code" : "LIM" ,
            "name" : "Lima" ,
            "country" : "PE" ,
            "continent" : "South America" ,
            "timezone" : -5 ,
            "coordinates" : {"S" : 12, "W" : 77} ,
            "population" : 9050000 ,
            "region" : 1
        }

I'm trying to print all city names. My code is:

Jdata = json.loads(self.data)
for i in Jdata["metros"]:
    print Jdata["name"]

But when I run this I'm getting "KeyError: 'name'"

What's the correct syntax to get the name of the cities?

mrkre · Accepted Answer · 2014-10-03 05:33:35Z

4

Try:

for city in Jdata['metros']:
    print city['name']

When you use Jdata['name'], it tries to look for the key in metros, which obviously does not exist.

answered Oct 3, 2014 at 5:33

mrkre

1,54815 silver badges43 bronze badges

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

Comments

Suresh · Accepted Answer · 2014-10-03 05:41:10Z

1

{"metros":[{"code":"SCL","name":"Santiago","Region":"1"},{"code":"LIM","name":"Lima","Region":"1"}],
}

Then you can use your code:

import json
from pprint import pprint
json_data=open('json_data')

data = json.load(json_data)
pprint(data)
json_data.close()
With data, you can now also find values in like so:

data["metros"][1]["name"]

answered Oct 3, 2014 at 5:41

Suresh

1171 gold badge2 silver badges13 bronze badges

Collectives™ on Stack Overflow

Getting JSON info in 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