Python Accessing Nested JSON Data [duplicate]

Question

I'm trying to get the zip code for a particular city using zippopotam.us. I have the following code which works, except when I try to access the post code key which returns TypeError: expected string or buffer

r = requests.get('http://api.zippopotam.us/us/ma/belmont')
j = r.json()

data = json.loads(j)

print j['state']
print data['places']['latitude']

Full JSON output:

{
"country abbreviation": "US",
"places": [
    {
        "place name": "Belmont",
        "longitude": "-71.4594",
        "post code": "02178",
        "latitude": "42.4464"
    },
    {
        "place name": "Belmont",
        "longitude": "-71.2044",
        "post code": "02478",
        "latitude": "42.4128"
    }
],
"country": "United States",
"place name": "Belmont",
"state": "Massachusetts",
"state abbreviation": "MA"
}

Plop your JSON into the tool in this snippet, check 'brackets only', then click the node you want to copy its code path to the clipboard. — ggorlen
– ggorlen, Commented Jul 20, 2021 at 22:19
The original question was essentially the result of a typo, but people who find this question later will be more interested in the linked duplicate. — Karl Knechtel
– Karl Knechtel, Commented Jul 2, 2022 at 1:03

larsaars · Accepted Answer · 2022-08-09 03:09:43Z

123

Places is a list and not a dictionary. This line below should therefore not work:

print(data['places']['latitude'])

You need to select one of the items in places and then you can list the place's properties. So to get the first post code you'd do:

print(data['places'][0]['post code'])

edited Aug 9, 2022 at 3:09

larsaars

2,3903 gold badges25 silver badges33 bronze badges

answered Apr 26, 2014 at 4:41

agrinh

1,9052 gold badges10 silver badges11 bronze badges

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

Comments

apardes · Accepted Answer · 2014-04-26 04:40:16Z

51

I did not realize that the first nested element is actually an array. The correct way access to the post code key is as follows:

r = requests.get('http://api.zippopotam.us/us/ma/belmont')
j = r.json()

print j['state']
print j['places'][1]['post code']

answered Apr 26, 2014 at 4:40

apardes

4,3807 gold badges43 silver badges67 bronze badges

Comments

MONTYHS · Accepted Answer · 2014-04-28 09:20:49Z

14

In your code j is Already json data and j['places'] is list not dict.

 r = requests.get('http://api.zippopotam.us/us/ma/belmont')
 j = r.json()

 print j['state']
 for each in j['places']:
    print each['latitude']

answered Apr 28, 2014 at 9:20

MONTYHS

9241 gold badge7 silver badges30 bronze badges

Comments

arielf · Accepted Answer · 2020-06-20 07:29:37Z

8

I'm using this lib to access nested dict keys

https://github.com/mewwts/addict

 import requests
 from addict import Dict
 r = requests.get('http://api.zippopotam.us/us/ma/belmont')
 j = Dict(r.json())

 print j.state
 print j.places[1]['post code']  # only work with keys without '-', space, or starting with number

edited Jun 20, 2020 at 7:29

arielf

5,9821 gold badge38 silver badges49 bronze badges

answered Mar 30, 2017 at 14:48

Ezequiel Bertti

8128 silver badges15 bronze badges

Collectives™ on Stack Overflow

Python Accessing Nested JSON Data [duplicate]

4 Answers 4

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Linked

Related