import requests
import json
import re
import pandas as pd
AK = ‘6421081fec31ba6a1f9d7e2ecd64176c‘
def get_cor(address):
# 获取单个地址坐标信息
ret = requests.get(
url=‘https://restapi.amap.com/v3/geocode/geo?parameters‘,
params={
# ‘region‘:‘安阳市‘,
‘address‘:address,
‘key‘:AK
}
).json()
return ret[‘geocodes‘][0][‘location‘]
# 导入数据
df = pd.DataFrame({
‘位置‘:[‘北京大学‘,‘清华大学‘],
‘经度‘:[‘‘,‘‘],
‘纬度‘:[‘‘,‘‘]})
# 查询经纬度
df[‘经纬度‘] = df[‘位置‘].map(get_cor)
df[‘经度‘] = df[‘经纬度‘].map(lambda x:x.split(‘,‘)[0])
df[‘纬度‘] = df[‘经纬度‘].map(lambda x:x.split(‘,‘)[1])
# 导出数据
df.to_excel("xxxx.xlsx",index = 0)
原文:https://www.cnblogs.com/blog-for-me/p/14846493.html