我想从实际地址中提取纬度和经度。
我看过一些视频,帮助我编写以下脚本,但是出现了错误。
Lat=Geocode_Result[0]["geometry"]["Location"]["Lat"]
KeyError: 'Location'
import pandas as pd
import googlemaps code
df=pd.DataFrame({'Address':['9 RUE DU FOSSE, L-7772, luxembourg', '37 RUE DE LA GARE,
L-7535, luxembourg']}) # Creating a dataframe with 2 addresses (its just an example)
Gmaps_key=googlemaps.Client("xxxxxxxxx")
df['Latitude'] = None
df['Longitude'] = None
for i in range(len(df)):
Geocode_Result=Gmaps_key.geocode(df.loc[i,'Address']) # sending a request for each of the addresses
Lat=Geocode_Result[0]["geometry"]["Location"]["Lat"] # Extracting the Latitude information
Long=Geocode_Result[0]["geometry"]["Location"]["Long"] # Extracting the Longitude information
df.loc[i,'Latitude'] = Lat # Pass the information into the DataFrame
df.loc[i,'Longitude'] = Long
print(df)