我正在嘗試從表中抓取一些數據。我得到了我期望的結果，但我找不到將它們保存在干凈的 CSV 表中的方法。這是代碼，在結果和我想要的下面。有什么建議嗎？from bs4 import BeautifulSoupimport urllib.request # web accessimport csvimport reurl = "https://wsc.nmbe.ch/family/87/Senoculidae"page = urllib.request.urlopen(url) # conntect to websitetry: page = urllib.request.urlopen(url)except: print("Ups!")soup = BeautifulSoup(page, 'html.parser')regex = re.compile('^speciesTitle')content_lis = soup.find_all('div', attrs={'class': regex})for li in content_lis: con = li.get_text("#",strip=True).split("\n")[0] print(con)我得到了這些不錯的輸出：Senoculus albidus#(F. O. Pickard-Cambridge, 1897)#|#| BrazilSenoculus barroanus#Chickering, 1941#|#| PanamaSenoculus bucolicus#Chickering, 1941#|#| Panama但我需要這樣的東西（CSV 用分號或制表符分隔）：Senoculus albidus;(F. O. Pickard-Cambridge, 1897);BrazilSenoculus barroanus;Chickering1941;PanamaSenoculus bucolicus;Chickering, 1941;Panama如何刪除字符“|” 和一些空間？有什么建議嗎？
2 回答
幕布斯6054654
TA貢獻1876條經驗 獲得超7個贊
嘗試這個：
from bs4 import BeautifulSoup
import urllib.request # web access
import re
url = "https://wsc.nmbe.ch/family/87/Senoculidae"
page = urllib.request.urlopen(url) # conntect to website
try:
page = urllib.request.urlopen(url)
except:
print("Ups!")
soup = BeautifulSoup(page, 'html.parser')
#div = soup.find(text=True, recursive=)
regex = re.compile('^speciesTitle')
content_lis = soup.find_all('div', attrs={'class': regex})
file = ''
for cl in content_lis:
a = cl.select_one('div a strong i')
b = cl.find(text=True, recursive=False)
c = cl.select_one('span')
cc = re.findall("[\w]+", c.text)[0]
file += f'{a.get_text(strip=True)};{b.strip()};{cc}\n'
with open('file.csv', 'w') as f:
f.write(file)
保存一個文件：
Senoculus albidus;(F. O. Pickard-Cambridge, 1897);Brazil
Senoculus barroanus;Chickering, 1941;Panama
Senoculus bucolicus;Chickering, 1941;Panama
Senoculus cambridgei;Mello-Leit?o, 1927;Brazil
Senoculus canaliculatus;F. O. Pickard-Cambridge, 1902;Mexico
Senoculus carminatus;Mello-Leit?o, 1927;Brazil
Senoculus darwini;(Holmberg, 1883);Argentina
Senoculus fimbriatus;Mello-Leit?o, 1927;Brazil
Senoculus gracilis;(Keyserling, 1879);Guyana
Senoculus guianensis;Caporiacco, 1947;j
Senoculus iricolor;(Simon, 1880);Brazil
Senoculus maronicus;Taczanowski, 1872;French
等等...
慕哥6287543
TA貢獻1831條經驗 獲得超10個贊
此代碼基于您的示例數據集：
lst=[
'Senoculus albidus#(F. O. Pickard-Cambridge, 1897)#|#| Brazil',
'Senoculus barroanus#Chickering, 1941#|#| Panama',
'Senoculus bucolicus#Chickering, 1941#|#| Panama'
]
lst2 = [s.replace('|',"").split('#') for s in lst]
lst3=[]
for s in lst2:
lst3.append(';'.join([sx.strip() for sx in s]).replace(';;',';'))
for s in lst3:
print(s)
輸出
Senoculus albidus;(F. O. Pickard-Cambridge, 1897);Brazil
Senoculus barroanus;Chickering, 1941;Panama
Senoculus bucolicus;Chickering, 1941;Panama
--- 根據請求者評論更新 ---
在最后一個循環中添加一行：
for li in content_lis:
con = li.get_text("#",strip=True).split("\n")[0]
con = ';'.join(sx.strip() for sx in con.replace('|',"").split('#')).replace(';;',';') # add this line
print(con)
添加回答
舉報
0/150
提交
取消