Python Accessing Nested JSON Data

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     quot country abbreviation quot    quot US quot    quot places quot                    quot place name quot    quot Belmont quot            quot longitude quot    quot -71 4594 quot            quot post code quot    quot 02178 quot            quot latitude quot    quot 42 4464 quot                        quot place name quot    quot Belmont quot            quot longitude quot    quot -71 2044 quot            quot post code quot    quot 02478 quot            quot latitude quot    quot 42 4128 quot            quot country quot    quot United States quot    quot place name quot    quot Belmont quot    quot state quot    quot Massachusetts quot    quot state abbreviation quot    quot MA quot

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

[python] Python Accessing Nested JSON Data

Examples related to python

Examples related to json