import requests
from lxml import etree
import csv
url = 'http://www.piaofang.biz/'
headers = {'User-Agent': 'Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Mobile Safari/537.36'}
response = requests.get(url, headers=headers)
response.encoding = 'gb2312'
data = response.text
html = etree.HTML(data)
div_tag = html.xpath('//div[@class="zhuti"]')
div = div_tag[0] # div_tag只有一项
lst = []
dic = {}
title = div.xpath('.//td[@class="title"]/a/text()')
piaofang = div.xpath('.//td[@class="piaofang"]/span/text()')
for t,p in zip(title,piaofang): # zip()作用是同时遍历两个列表
dic['title'] = t
dic['piaofang'] = p
lst.append(dic)
print(dic)
with open('排行榜.csv', 'w', encoding='gb2312', newline='') as f:
write = csv.DictWriter(f, fieldnames=['title', 'piaofang'])
# 写入表头
write.writeheader()
# 写入数据
write.writerows(lst)
你的意思是指所有行数据都是一样的？
title,piaofang
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
夺宝奇兵4,"791,657,398"
全都一样这该怎么弄？