存储到csv文件中

点击查看代码

import requests
from lxml import etree

url = 'http://antpython.net/webspider/show_excel'
headers = {
    "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36 Edg/129.0.0.0"
}
response = requests.get(url, headers=headers)
html_etree = etree.HTML(response.text)
trs = html_etree.xpath('//tbody/tr')
with open('天气.csv', 'a') as f:
    f.write("ymd,high,low,tianqi,tianqi,fengli,aqi,aqiInfo,aqiLevel\n")
    for tr in trs:
        row = ','.join(tr.xpath('.//td/text()'))
        print(row)
        f.write(f"{row}\n")