疫情数据可视化、数据挖掘、预测（Flask+Layui）

不带分号的程序员

已于 2022-04-13 17:42:22 修改

阅读量1.3k

点赞数

分类专栏：爬虫文章标签：前端 python flask

于 2022-04-11 12:01:43 首次发布

本文链接：https://blog.csdn.net/qq_25981527/article/details/124095781

版权

爬虫专栏收录该内容

4 篇文章 1 订阅

订阅专栏

后端

Flask

数据处理Excel表格：

丁香园数据接口：

import requests,pymysql
def update():
    conn = pymysql.connect(host='xxx.xxx.xxx.xxx', user='tf094', password='xxxxxxx', database='tf094',port=3306)
    cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)

    url="http://111.231.75.86:8000/api/statistics/latest/"
    res=requests.get(url).json()

    currentConfirmedCount=res.get('domesticStatistics').get('currentConfirmedCount')
    curedCount=res.get('domesticStatistics').get('curedCount')
    confirmedCount=res.get('domesticStatistics').get('confirmedCount')
    seriousCount=res.get('domesticStatistics').get('seriousCount')
    suspectedCount=res.get('domesticStatistics').get('suspectedCount')
    deadCount=res.get('domesticStatistics').get('deadCount')
    currentConfirmedIncr=res.get('domesticStatistics').get('currentConfirmedIncr')
    curedIncr=res.get('domesticStatistics').get('curedIncr')
    confirmedIncr=res.get('domesticStatistics').get('confirmedIncr')
    suspectedIncr=res.get('domesticStatistics').get('suspectedIncr')
    deadIncr=res.get('domesticStatistics').get('deadIncr')
    sql='insert into dingxiangyuan values (%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d)'%(currentConfirmedCount,
                                                                               curedCount,
                                                                               confirmedCount,
                                                                               seriousCount,
                                                                               suspectedCount,
                                                                               deadCount,
                                                                               currentConfirmedIncr,
                                                                               curedIncr,
                                                                               confirmedIncr,
                                                                               suspectedIncr,
                                                                               deadIncr)
    cursor.execute(sql)
    conn.commit()

Excel文件处理：