新手尝试
import requestsimport pandas as pdimport csvdata = pd.read_csv('地址.csv',engine='python')#导入地址的csv文件data = data['地址']#选择地址列lis = []def gaode():for i in data:para = {'key':'你的key','address':i,'city':'需要查询的城市'}url = '/v3/geocode/geo?'req = requests.get(url,para)req = req.json()if req['infocode']=='10000':w = req['geocodes'][0]['formatted_address']z = req['geocodes'][0]['location']print(w)print(z)d = (w, z)else:print('查询不到')lis.append(d)t = ['位置','经纬度']with open('高度地图位置.csv', 'w', newline='')as f:writer = csv.writer(f)writer.writerow(t)writer.writerows(lis)if __name__ == '__main__':gaode()
