JAVA日报

双人结对作业疫情可视化（地图json爬虫）

#!/usr/bin/python
# -*- coding: UTF-8 -*-
import json
import requests
import xlrd
import xlwt


# 获取所有数据json文件
def download_Json(url, name):
    print("-----------正在下载json文件 %s" % (url))
    print(name)
    try:
        # 将响应信息进行json格式化
        response = requests.get(url)
        versionInfo = response.text  # versionInfo  Unicode类型
        # print(versionInfo)
        # print(type(versionInfo))
        versionInfoPython = json.loads(versionInfo)   # unicode转化为字典类型
        # print(type(versionInfoPython))
        # print(versionInfoPython)
        path = "E:\Pycharm\Project\geojson\" +name + ".json"  # 修改一下路径
        print(path)
        # 将json格式化的数据保存
        with open(path, 'w') as f1:
            f1.write(json.dumps(versionInfoPython,  indent=4))  # json.dumps()将字典转化为json indent=4是为了好看

        print("下载成功，文件保存位置：" + path)
    except Exception as ex:
        print("--------下载出错----")
        pass


# 获取对应数据的json文件

for i in range(35):
    workbook = xlrd.open_workbook(r'E:PycharmProjectgeojsonCITYCODE.xls')  # 修改一下路径
    sheet1 = workbook.sheet_by_name('Sheet1')
    nrows = sheet1.nrows
    ncols = sheet1.ncols
    # print(nrows,ncols)
    cell_A = sheet1.cell(i, 0).value
    cell_B = int(sheet1.cell(i, 1).value)
    #print(cell_B)
    #print(cell_A)
    url = 'https://geo.datav.aliyun.com/areas_v2/bound/' + str(cell_B) + '_full.json'  # 输入json地址
    download_Json(url, cell_A)  # 第一个参数是json文件的地址，第二个参数是文件保存的名称，
    print(i + 1)
a = i + 1