import pandas as pd
import requests,time,csv
from urllib.request import quote
#定义一个存储函数
def save_data(row):
f=open('门店经纬度.csv','a',encoding='GBK',newline='')
csv_writer = csv.writer(f)
csv_writer.writerow(row)
f.close()
#获取excel中的数据
csv_data = pd.read_excel('./东莞二手中介信息.xlsx',usecols=['名称','地址'])
site = csv_data.values.tolist()
for addr in site:
# print(addr[0]) 门店名称
addres = quote(addr[1])
# print(addr) 门店地址
url = 'http://api.map.baidu.com/geocoding/v3/?address='+addres+'&output=json&ak=你的AK%20//GET%E8%AF%B7%E6%B1%82'
# print(url) 整合URL
response = requests.get(url)
data = eval(response.text)
# print(data)
lat = data["result"]["location"]["lat"]
lon = data["result"]["location"]["lng"]
print(addr[0]+'经度是:'+str(lat)+'纬度是:'+str(lon))
row = [addr[0],lat,lon]
save_data(row)
AK需要从百度API中申请哦,跳转链接:
http://lbsyun.baidu.com/index.php?title=webapi/guide/webservice-geocoding
http://lbsyun.baidu.com/apiconsole/key?application=key#/home 这个是申请AK的地方
门店所需要的详细信息,可以从当地的房管局获取!