python根据excel中的地名输出经纬度和地址

代码

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需要另外转换