1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
import requests
import json
import MySQLdb
from pyecharts.charts import Map, Bar, Page
from pyecharts import options as opts
conn = MySQLdb.connect(
host='localhost',
port=3306,
user='root',
passwd='123456',
db='spider',
charset='utf8'
)
cursor = conn.cursor()
url = "https://view.inews.qq.com/g2/getOnsInfo?name=disease_h5"
res = requests.get(url).json()
print(res)
for province in json.loads(res['data'])['areaTree']:
for province_data in province['children']:
sql = "insert into province values(%s,%s)"
cursor.execute(sql, [province_data['name'], province_data['today']['confirm']])
conn.commit()
print(province_data['name'], province_data['today']['confirm'])
data = json.loads(res['data'])['chinaTotal']
print(data)
sql = 'insert into china_count values(%s,%s,%s,%s)'
cursor.execute(sql, [data['confirm'], data['heal'], data['dead'], data['suspect']])
conn.commit()
sql = "select * from province"
cursor.execute(sql)
datas = cursor.fetchall()
china_sql = 'select * from china_count'
cursor.execute(china_sql)
china_data = cursor.fetchone()
map_obj = (
Map()
.add("", datas, "china")
.set_global_opts(
title_opts=opts.TitleOpts(title="疫情情况", subtitle="截止目前为止,全国共有累计确诊{}例,累计治愈{}例,累计死亡{}例,疑似{}例"
.format(china_data[0], china_data[1], china_data[2], china_data[3])
),
visualmap_opts=opts.VisualMapOpts(max_=3),
)
)
name_list = [name[0] for name in datas]
data_list = [name[1] for name in datas]
bar_obj = (
Bar()
.add_xaxis(name_list)
.add_yaxis("各省份数据对比", data_list)
.set_global_opts(title_opts=opts.TitleOpts(title="各省份目前情况"),
datazoom_opts=[opts.DataZoomOpts()]
)
)
p = Page(layout=Page.SimplePageLayout)
p.add(map_obj, bar_obj)
p.render("疫情实时监控.html")
|
