python实现地理编码

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

去高德地图申请好key

python代码

# -*- coding:utf_8 -*- # !/usr/bin/python37 """ @author:renyuan @software:PyCharm @file:湖南村庄.py @time:2021/5/12 001221:17 """ import requests import json import pandas as pd ## 读取Excel文件 df_address = pd.read_excel('输入的地址所在的Excel文件') ## 构造url df_address['url'] = 'https://restapi.amap.com/v3/geocode/geo?address='+df_address['address所在列']+'&output=JSON&key=输入你的key' ## 创建空df，用于接收文件 result = pd.DataFrame([]) for url in df_address['url']: ## get请求 response = requests.get(url) ## 返回json文件 persons = json.loads(response.text) ## json文件解析 for person in persons['geocodes']: dict = {} dict = person df = pd.DataFrame([dict]) ## 文件追加 result = result.append(df, ignore_index=False) print(result) result.to_csv('results.csv', index=False)