代码
import requests
import pandas as pd
定义函数
- 其中key需要自己去高德申请密钥:见文章如何在高德开放平台获取密钥key-CSDN博客
def gaodexy(address):
par = {'address': address, 'key': '你的密钥'}###需要自己在高德中申请密钥
base = 'http://restapi.amap.com/v3/geocode/geo'
response = requests.get(base, par)
answer = response.json()
GPS = answer['geocodes'][0]['location'].split(",")
return GPS[0], GPS[1]
def gaodedidian(address):
par = {'address': address, 'key': '你的密钥'}
base = 'http://restapi.amap.com/v3/geocode/geo'
response = requests.get(base, par)
answer = response.json()
GPS = answer['geocodes'][0]['formatted_address'].split(",")
return GPS[0]
读取文件内容
- 只有一列地点名称
df=pd.read_excel('D:\\文件\\地点.xls')
df
代码执行
xy= df['地点'].apply(gaodexy)
address=df['地点'].apply(gaodedidian)
df['经纬度']=xy
df['地址']=address
df['经度']=df['经纬度'].str[0]
df['纬度']=df['经纬度'].str[1]
df
- 经纬度为高德的经纬度,如需wgs84需要另外转换