有大佬知道如何让这段代码更简短一点吗

Question

# -*- codeing = utf-8 -*-
# @Software : PyCharm

import urllib.request
from lxml import etree
import pymysql

db = pymysql.connect(host="localhost",port=3306,user="root",password="***",database="***",charset="utf8",autocommit=True)
cursor = db.cursor()

url = "http://www.weather.com.cn/weather/101250101.shtml"
headers = {"User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.72 Safari/537.36"}
req = urllib.request.Request(url,headers=headers)
data = urllib.request.urlopen(req).read()

html = etree.HTML(data)
day = html.xpath("//ul/li/h1/text()")
wea = html.xpath("//ul/li/p[1]/@title")
tem = html.xpath("//ul/li/p[2]")
win1 = html.xpath("//ul/li/p[3]/em/span[1]/@title")
win2 = html.xpath("//ul/li/p[3]/em/span[1]/@title")
win3 = html.xpath("//ul/li/p[3]/i/text()")

for i in range(len(day)):
    print(day[i],wea[i],tem[i].xpath('string(.)').strip(),win1[i]+'/'+win2[i]+'/'+win3[i])
    sql = "insert into weather(day,wea,tem,win) values('"+day[i]+"','"+wea[i]+"','"+tem[i].xpath('string(.)').strip()+"','"+win1[i]+'/'+win2[i]+'/'+win3[i]+"')"
    cursor.execute(sql)
db.close()
print("完成")

Answer 1

你好，我是有问必答小助手，非常抱歉，本次您提出的有问必答问题，技术专家团超时未为您做出解答

本次提问扣除的有问必答次数，将会以问答VIP体验卡（1次有问必答机会、商城购买实体图书享受95折优惠）的形式为您补发到账户。

​​​​因为有问必答VIP体验卡有效期仅有1天，您在需要使用的时候【私信】联系我，我会为您补发。