后端
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文件处理:
疫情实时数据爬虫:
前端
layui框架+html+css+JavaScript
效果图