import requests
from lxml import etree
import csv
url=('https://www.58.com/fangjiawang/sheng-2023-27/')
myheader={"User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 Edg/109.0.1518.70"}
response = requests.get(url,headers=myheader)
allList = []
res = response.content.decode()
myhtml=etree.HTML(res)
divList = myhtml.xpath('//div[@class="price-item"]',ecoding='utf-8')
#print(divList)
for itemHtml in divList:
cs = itemHtml.xpath('./ul/li/a/b/text()')
fj = itemHtml.xpath('./ul/li/a/span/text()')
zzl = itemHtml.xpath('./ul/li/a/em/text()')
oneList = [cs,fj,zzl]
allList.append(oneList)
with open("fangjia.csv","w",encoding="utf-8-sig",newline="") as f:
writer = csv.writer(f)
writer.writerow(["城市","房价","增值率"])
writer.writerows(allList)
import requests
from lxml import etree
import csv
url = ('https://www.58.com/fangjiawang/sheng-2023-27/')
myheader = {
"User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 Edg/109.0.1518.70"}
response = requests.get(url, headers=myheader)
allList = []
res = response.content.decode()
myhtml = etree.HTML(res)
divList = myhtml.xpath('//div[@class="price-item"]', ecoding='utf-8')
# print(divList)
for itemHtml in divList:
cs = itemHtml.xpath('./ul/li/a/b/text()')
fj = itemHtml.xpath('./ul/li/a/span/text()')
zzl = itemHtml.xpath('./ul/li/a/em/text()')
oneList = [cs, fj, zzl]
allList.append(oneList)
with open("fangjia.csv", "w", encoding="utf-8-sig", newline="") as f:
writer = csv.writer(f)
writer.writerow(["城市", "房价", "增值率"])
# writer.writerows(allList)
for cs, fj, zzl in allList:
item = list( zip( cs, fj, zzl ) )
for i in item:
writer.writerow(i)
因为你代码就是这么写的呀
你想分成几个表格呢