为什么结果都挤在一个表格了

Question

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)

Answer 1

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)