python调用高德api生成省市区街道4级excel文档

 1.登录高德开发者平台

地址：高德开放平台 | 高德地图API

2.创建应用即可获得key

3.高德行政区域查询api

行政区域查询-API文档-开发指南-Web服务 API | 高德地图API

4.代码如下

import requests
import json
import pandas

req_url = 'https://restapi.amap.com/v3/config/district'

req_params = {
    'key': '高德开发者平台申请的应用key',
    'subdistrict': 4 #相应数字4 代表省-市-区-街道4级 1-代表 省1级 依次类推
}

response = requests.get(url=req_url,params=req_params)
provinces = json.loads(response.text)

def all(data):
    if data.get('districts'):
        for item in data.get('districts'):
            if item.get('level') == 'province':
                province = []
                province_item = [item.get('name'),item.get('adcode')]
                province.insert(0,province_item)
                item_data = pandas.DataFrame(data = province)
                item_data.to_csv('province.csv',mode='a',index=False,header=False) #将数据写入excel文件
            elif item.get('level') == 'city':
                city = []
                city_item = [item.get('name'),item.get('adcode'),data.get('adcode')]
                city.insert(0,city_item)
                item_data = pandas.DataFrame(data = city)
                item_data.to_csv('city.csv',mode='a',index=False,header=False)
            elif item.get('level') == 'district':
                district = []
                district_item = [item.get('name'),item.get('adcode'),data.get('adcode')]
                district.insert(0,district_item)
                item_data = pandas.DataFrame(data = district)
                item_data.to_csv('district.csv',mode='a',index=False,header=False)
            elif item.get('level') == 'street':
                street = []
                street_item = [item.get('name'),item.get('adcode'),data.get('adcode')]
                street.insert(0,street_item)
                item_data = pandas.DataFrame(data = street)
                item_data.to_csv('street.csv',mode='a',index=False,header=False)
            # print(item)
            all(item)
    else:
        return

def write_excel():
    all(provinces)

write_excel()