import requests
import pandas as pd
key='?' #传入自己申请的key值
adcode=520100 #城市adcode码
url='https://restapi.amap.com/v3/place/text?parameters'
id = []
lines = []
area = []
name = []
location_x = []
location_y = []
for n in range(10): #因为不清楚有多少个站点,所以往大一点的数循环
parameters={'key':key,
'city':"%s"%adcode,
'citylimit':'true',
'types':'150500', #地铁站点类型编码
'output':'json',
'offset':'20', #一页20条数据
'page':'%d'%n
}
reqs = requests.get(url=url, params=parameters)
jsondata = reqs.json() # 因为上面设置的是返回json格式所以.json
#整理格式
for i in range(len(jsondata['pois'])):
position=jsondata['pois'][i]
if position['parent']==[]:
# print(position)
station_id=position['id']
station_line=position['address']
station_area=position['adname']
station_name=position['name']
station_location_x,station_location_y=position['location'].split(',')
station_location_x=float(station_location_x)
station_location_y=float(station_location_y)
id.append(station_id)
lines.append(station_line)
area.append(station_area)
name.append(station_name)
location_x.append(station_location_x)
location_y.append(station_location_y)
if jsondata['pois']==[]:
break
data=pd.Dataframe({'id':id,'station_name':name,'lon':location_x,'lat':location_y,'line':lines })
data.to_excel(r'path',index=None) #path 填保存文件的路径