通过geopy从pandas数据帧中获取所有详细信息

pip install geopy

import pandas as pd
from geopy.geocoders import Nominatim
from geopy.exc import GeocoderTimedOut

def get_location(address):
    geolocator = Nominatim(user_agent="my_app")  # 创建一个geolocator对象
    try:
        location = geolocator.geocode(address)  # 获取地址的地理位置信息
        return location
    except GeocoderTimedOut:
        return get_location(address)  # 如果超时，则重新尝试获取地理位置信息

df = pd.read_csv('data.csv')  # 假设数据文件名为data.csv，包含地址信息的列名为'address'

df['location'] = df['address'].apply(get_location)  # 将地理位置信息添加到新的列'location'

import pandas as pd
from geopy.geocoders import Nominatim
from geopy.exc import GeocoderTimedOut

def get_location(address):
    geolocator = Nominatim(user_agent="my_app")
    try:
        location = geolocator.geocode(address)
        return location
    except GeocoderTimedOut:
        return get_location(address)

df = pd.read_csv('data.csv')
df['location'] = df['address'].apply(get_location)

# 访问详细信息
for index, row in df.iterrows():
    print("Address:", row['address'])
    print("Latitude:", row['location'].latitude)
    print("Longitude:", row['location'].longitude)
    print("Country:", row['location'].raw['address']['country'])
    print("City:", row['location'].raw['address']['city'])
    print("Postal Code:", row['location'].raw['address']['postcode'])
    print("-------------------------------")