利用Python爬取全国各省份新冠肺炎疫情最新数据

PS:
利用Python爬取全球新冠肺炎疫情最新数据

数据来源

	url='https://user.guancha.cn/app/pneumonia'

数据库

user='root', password='12345678', 
db='COVID19db

代码

import requests
from lxml import etree
import time
# import csv
import pymysql
def data_writer(province1,diagnosis1,died1,cure1,date1):
    conn = pymysql.connect(host='localhost', port=3306, user='root', password='12345678', db='COVID19db', charset='utf8',
                           connect_timeout=1000)
    cursor = conn.cursor()
    sql = """create table if not exists 14CO