如何使用python从json中提取特定数据

如何使用python从json中提取特定数据

问题描述:

我想提取下面给定的 json 中address_components"中存在的long_name"数据.挑战是我只想要类型"为administrative_area_level_2"的long_name"数据.请让我知道如何最好在python中仅提取该特定数据.谢谢

I want to extract the "long_name" data present in the "address_components" in the below given json. The challenge is I want only the "long_name" data whose "types" is "administrative_area_level_2". please let me know how to extract only that specific data preferably in python. Thanks

请注意 js["results"][0]["address_components"][2]["long_name"] 不是我想要提取其值的方式,因为 ["address_components"][2] 不断变化作为输入给出的不同位置.我的主要标准是提取long_name"的数据,其类型"始终为administrative_area_level_2"

edit: Note that js["results"][0]["address_components"][2]["long_name"] is not how I want to extract its value since ["address_components"][2] keeps varying for the different locations given as input. my main criteria is to extract data of "long_name" whose "types" is always "administrative_area_level_2"

{
    "status": "OK", 
    "results": [
        {
            "geometry": {
                "location_type": "APPROXIMATE", 
                "bounds": {
                    "northeast": {
                        "lat": 12.9177876, 
                        "lng": 80.24104
                    }, 
                    "southwest": {
                        "lat": 12.875989, 
                        "lng": 80.20860669999999
                    }
                }, 
                "viewport": {
                    "northeast": {
                        "lat": 12.9177876, 
                        "lng": 80.24104
                    }, 
                    "southwest": {
                        "lat": 12.875989, 
                        "lng": 80.20860669999999
                    }
                }, 
                "location": {
                    "lat": 12.9009877, 
                    "lng": 80.2279301
                 }
            }, 
            "formatted_address": "Sholinganallur, Chennai, Tamil Nadu, India", 
            "place_id": "ChIJGzh_3nlbUjoRGz_-itQtu_8", 
            "address_components": [
                {
                    "long_name": "Sholinganallur", 
                    "types": [
                        "sublocality_level_1", 
                        "sublocality", 
                        "political"
                    ], 
                    "short_name": "Sholinganallur"
                }, 
                {
                    "long_name": "Chennai", 
                    "types": [
                        "locality", 
                        "political"
                    ], 
                    "short_name": "Chennai"
                }, 
                {
                    "long_name": "Kanchipuram", 
                    "types": [
                        "administrative_area_level_2", 
                        "political"
                    ], 
                    "short_name": "Kanchipuram"
                }, 
                {
                    "long_name": "Tamil Nadu", 
                    "types": [
                        "administrative_area_level_1", 
                        "political"
                    ], 
                    "short_name": "TN"
                }, 
                {
                    "long_name": "India", 
                    "types": [
                        "country", 
                        "political"
                    ], 
                    "short_name": "IN"
                }
            ], 
            "partial_match": true, 
            "types": [
                "sublocality_level_1", 
                "sublocality", 
                "political"
            ]
        }
    ]
}

下面是我正在尝试的代码,但我只得到位置的输出.让我知道我需要在代码中进行哪些更改.

The below is the code which I am trying but I get output only till location. Let me know what changes I need to make in my code.

import urllib
import json

apiurl= 'http://maps.googleapis.com/maps/api/geocode/json?'

while True:
    address = raw_input('Enter location: ')
    if len(address) < 1 : break

    url = apiurl + urllib.urlencode({'sensor':'false', 'address':     address})
    print 'Retrieving', url
    uh = urllib.urlopen(url).read()

    print 'Retrieved',len(uh),'characters'
    js = json.loads(str(uh))
    print json.dumps(js, indent=4)   
    jayz = js["results"][0]
    lat = jayz["geometry"]["location"]["lat"]
    lng = jayz["geometry"]["location"]["lng"]
    print 'lat',lat,'lng',lng
    location = jayz['formatted_address']
    print location
    components = js["results"][0]["address_components"]
    names = [component['long_name'] for component in components if 'administrative_area_level_2' in component['types']]
    name = names[0]
    print "District:", name

您可以获取组件并在它们上循环并找到您想要的组件

You can get the components and loop on them and find the ones that you

js = eval(input_file.read())
components =  js["results"][0]["address_components"]
names = [component['long_name'] for component in components if 'administrative_area_level_2' in component['types']]

这里,名称将包括所有在其类型中具有管理区域_级别_2 的组件的 long_name

Here, names will include long_name of all the components that have administrative_area_level_2 in their types