How to extract data from complex Json using python

Question

{
   "results" : [
      {
         "address_components" : [
            {
               "long_name" : "1600",
               "short_name" : "1600",
               "types" : [ "street_number" ]
            },
            {
               "long_name" : "Amphitheatre Parkway",
               "short_name" : "Amphitheatre Pkwy",
               "types" : [ "route" ]
            },
            {
               "long_name" : "Mountain View",
               "short_name" : "Mountain View",
               "types" : [ "locality", "political" ]
            },
            {
               "long_name" : "Santa Clara County",
               "short_name" : "Santa Clara County",
               "types" : [ "administrative_area_level_2", "political" ]
            },
            {
               "long_name" : "California",
               "short_name" : "CA",
               "types" : [ "administrative_area_level_1", "political" ]
            },
            {
               "long_name" : "United States",
               "short_name" : "US",
               "types" : [ "country", "political" ]
            },
            {
               "long_name" : "94043",
               "short_name" : "94043",
               "types" : [ "postal_code" ]
            }
         ],
         "formatted_address" : "1600 Amphitheatre Pkwy, Mountain View, CA 94043, USA",
         "geometry" : {
            "location" : {
               "lat" : 37.4224484,
               "lng" : -122.0843249
            },
            "location_type" : "ROOFTOP",
            "viewport" : {
               "northeast" : {
                  "lat" : 37.4237973802915,
                  "lng" : -122.0829759197085
               },
               "southwest" : {
                  "lat" : 37.4210994197085,
                  "lng" : -122.0856738802915
               }
            }
         },
         "place_id" : "ChIJ2eUgeAK6j4ARbn5u_wAGqWA",
         "types" : [ "street_address" ]
      }
   ],
   "status" : "OK"
}

How can i retrieve formatted_address,Lat and Long under geometry>Location etc. from json. Most of the json tutorials are explained with simple json file. Kindly help me on this and help me find some good tutorials

rafaelc · Accepted Answer · 2016-09-17 19:24:44Z

3

Actually, simple JSONs and complex JSONs are not that different. You can say that a complex JSON has many simpler JSONs inside, so if you know how to get data from simple ones, you end up knowing how to get data from complexes

Anyway, think of JSON objects as dictionaries and JSON arrays as lists. To get data from dicts, use the key for a value. To get data from lists, use the index (position) of a value.

So, in your case:

lat = json["results"][0]["geometry"]["location"]["lat"]
long = json["results"][0]["geometry"]["location"]["lng"]

and

formatted_address = json["results"][0]["formatted_address"]

Notice how the navigation through keys occur, and how you get deeper as you retrieve values from its keys

answered Sep 17, 2016 at 19:24

rafaelc

59.4k15 gold badges64 silver badges87 bronze badges

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

Comments

Deniz Kaplan · Accepted Answer · 2016-09-17 19:23:43Z

0

You can follow the documentation for json library from the links: python2 or python3 If you have any spesific questions, you can define traces or code parts to find correct answers.

answered Sep 17, 2016 at 19:23

Deniz Kaplan

1,6091 gold badge15 silver badges18 bronze badges

Collectives™ on Stack Overflow

How to extract data from complex Json using 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