Skip to main content
 首页 » 编程设计

Python Selenium 将数据存储到 CSV 中的特定列

2024年12月31日7artech

我有两个打印件要写入一个 CSV 文件到 A 列和 B 列

我的问题是,当我在最后同时打印(第一次和第二次打印)时,我只得到一个元素,我猜是多次,因为它不在循环内。

print((text), (link[0:-9])) 

结果:

LMFCIIC PWFERT-BK 
LMFCIIC PMFEP-BK 
LMFCIIC LMF8CC-BL 
LMFCIIC PMFEP-GY 
LMFCIIC ASPCP-NV 
LMFCIIC LWBASK-PK 
LMFCIIC LWBATA-PK 
LMFCIIC LWBATOP-PK 
LMFCIIC LMF8CC-RD 

我的第一个打印看起来像这样:我想将它打印到 A

列
PWFERT-BK 
PMFEP-BK 
LMF8CC-BL 
PMFEP-GY 
ASPCP-NV 
LWBASK-PK 
LWBATA-PK 
LWBATOP-PK 
LMF8CC-RD 

我的第二次打印看起来像这样:我想将它打印到 B

列
LMFCIIC 
 
 
LWBASK 
LWBATA 
LWBATOP 
LMFCIIC 

这是我的完整代码:

from bs4 import BeautifulSoup 
from selenium import webdriver 
import html5lib 
import time 
import requests 
 
driver_path = '/usr/local/bin/chromedriver 2' 
driver = webdriver.Chrome(driver_path) 
driver.implicitly_wait(10) 
 
driver.get('https://www.tenniswarehouse-europe.com/zzz/producttracker_bl.html?ccode=SWIMG030') 
try: 
    iframe = driver.find_elements_by_tag_name('iframe') 
    for i in range(0, len(iframe)): 
            f = driver.find_elements_by_tag_name('iframe')[i] 
            driver.switch_to.frame(i) 
            #  your work to extract link 
            text = driver.find_element_by_tag_name('body').text 
            text = text.replace("Code: ","") 
            text = text.replace("No Copy Images to TW Server","") 
            print(text) 
            driver.switch_to_default_content() 
finally: 
    driver.quit() 
 
resp = requests.get('https://www.tenniswarehouse-europe.com/zzz/producttracker_bl.html?ccode=SWIMG030') 
soup = BeautifulSoup(resp.text,"lxml") 
for frame in soup.findAll('img'): 
    link = (frame['src']) 
    link = link.split('=')[1]  
    print ((link[0:-9])) 
  • 我使用了 www.example.com,因为无法从我的网络访问该链接

请您参考如下方法:

当您编写 driver.switch_to.frame(i) 时,您基本上是在访问 iframe html 元素。像普通的 html 页面一样,您也可以访问其内部元素。

从你之前的问题来看,iframe 是这样的

<body> 
<a href="http://www.test2.com" target="_blank"> 
<img src="https://img2.test2.com/LWBAD-1.jpg"></a> 
<br/>Code: LWBAD 

您可以通过以下方式轻松访问图片网址

img_src = driver.find_element_by_tag_name('img').get_attribute('src') 

并将其存储在csv文件中

代码:

from bs4 import BeautifulSoup 
from selenium import webdriver 
import html5lib 
import time 
import requests 
import csv 
 
driver_path = '/usr/local/bin/chromedriver 2' 
driver = webdriver.Chrome(driver_path) 
driver.implicitly_wait(10) 
 
driver.get('https://www.example.com') 
 
iframe = driver.find_elements_by_tag_name('iframe') 
images = driver.find_elements_by_tag_name('img') 
with open('file_name.csv', 'w', newline='') as csvfile: 
    field_names = ['text', 'src'] 
    writer = csv.DictWriter(csvfile, fieldnames=field_names) 
    writer.writerow({'text': 'text', 'src': 'src'}) 
    for i in range(0, len(iframe)): 
        f = driver.find_elements_by_tag_name('iframe')[i] 
        img_src = images[i].get_attribute('src') 
 
        # do the src splitting here 
        img_src = img_src.split('=')[1] 
 
        driver.switch_to.frame(i) 
 
        text = driver.find_element_by_tag_name('body').text 
 
 
        text = text.replace("Code: ", "") 
        text = text.replace("No Copy Images to TW Server", "") 
        print(text) 
        writer.writerow({'text': text, 'src': img_src}) 
 
        driver.switch_to_default_content() 
driver.quit()