.*?
3.数据存储
保存到MySQL数据库
def insert_info(value):
db = pymysql.connect("localhost", "root", "root", "exercise")
cursor = db.cursor()
sql = "INSERT INTO exer(name,origin) VALUES (%s,%s)"
try:
cursor.execute(sql, value)
db.commit()
print('插入数据成功')
except:
db.rollback()
print("插入数据失败")
db.close()
二、数据清洗
1.检查数据