作为一名新生,我不知道如何编写csv文件帮助将数据存储在csv文件中。 我希望文件头应该是这样的,在头下面,数据应该对齐。提前谢谢 (0,0,“产品Url”) (0,1,“产品制造商”) (0,2,“产品模型”) (0,3,“产品颜色”) (0,4,“产品存储”) (0.5,“产品价格”) (0,6,“货币”) (0.7,“增值税”) (0.8,“运费”) (0,9,“国家”) (0,10,“日期”)
import xlwt
from selenium import webdriver
import re
import time
from datetime import date
class expert:
def __init__(self):
self.url='https://expert938.expertonline.it/dm-IT-it/Vendita_Smartphone_W8D.aspx'
self.country='IT'
self.currency='euro'
self.VAT='Included'
def experts(self):
try:
driver=webdriver.Chrome()
driver.get(self.url)
today = date.today()
time.sleep(5)
driver.maximize_window()
x=1
while True:
containers = []
flag = False
containers =driver.find_elements_by_css_selector('div[class="col-xs-12 skywalker_riga skywalker_riga_articolo"]')
for container in containers:
try:
url = container.find_element_by_css_selector('div[class="skywalker_riga_nome"]')
urls = url.find_element_by_tag_name('a').get_attribute('href')
if urls != "":
print(urls)
flag = True
except:
pass
try:
title = container.find_element_by_css_selector('div[class="skywalker_riga_nome"] h3').text
if title != "":
print(title)
flag = True
except:
pass
try:
price = container.find_element_by_css_selector('div[class="skywalker_riga_prezzo"]').text
if price != "":
print(price)
flag = True
except:
pass
print("flag value is:" +str(flag))
if flag==False:
break
try:
x+=1
time.sleep(5)
driver.get(self.url+"?pagina="+str(x))
print("next page")
except:
break
except:
pass
expertit=expert()
expertit.experts()
熊猫dataframe to CSV可以轻松做到这一点
第1步:Start with an empty dataframe并在循环时填充它
步骤2:python中的Add rows to existing dataframe或consider this while you deal with数据帧
有时,您可能会发现Python's writelines方法很有趣
相关问题 更多 >
编程相关推荐