我正在尝试使用python和selenium进行web抓取,但是每当我运行代码时,都会收到错误消息。
[4824:524:0818/154954.605:ERROR:ssl_client_socket_impl.cc(959)] handshake failed; returned -1, SSL error code 1, net_error -201
[4824:524:0818/154954.614:ERROR:ssl_client_socket_impl.cc(959)] handshake failed; returned -1, SSL error code 1, net_error -201
[4824:524:0818/154954.721:ERROR:ssl_client_socket_impl.cc(959)] handshake failed; returned -1, SSL error code 1, net_error -201
[4824:524:0818/154954.730:ERROR:ssl_client_socket_impl.cc(959)] handshake failed; returned -1, SSL error code 1, net_error -201
Empty DataFrame
Columns: [Rank, Country, Total Cases, New Cases, Deaths, New Deaths, Recovered, Active Cases, Critical]
Index: []
我的代码我正在尝试使用selenium访问一个名为worldometer的网站,并使用pandas从他们网站上的表格中提取数据。我以前使用selenium访问过其他网站,但当时没有给出错误提示。我使用的是python版本3.6.8
我尝试了一些修复方法,比如安装证书,但没有安装。我还尝试了其他修复方法,比如添加--ignore- OpenSSl -errors和--ignore-ssl-errors,但这也不起作用
import pandas as pd
import time
# Covid 19 Webscraper
browser = webdriver.Chrome('C:\\webdrivers\\chromedriver.exe')
# opening sites
browser.get("https://www.worldometers.info/coronavirus/")
time.sleep(15)
#creating Data Frame
df = pd.DataFrame(columns=['Rank','Country','Total Cases','New Cases','Deaths','New Deaths','Recovered','Active Cases','Critical'])
# finding xpath and info
for i in browser.find_elements_by_xpath("//*[@id='main_table_countries_today']/tbody/tr"):
td_list = i.find_elements_by_tag_name('td')
row = []
for td in td_list:
row.append(td.text)
data={}
for j in range(len(df.columns)):
data[df.columns[j]] = row[j]
df.append(data, ignore_index=True)
print(df)
发布于 2020-08-18 19:12:54
看起来你的浏览器商店没有网站所需的证书。请使用chrome选项,如下所示:
options = webdriver.ChromeOptions()
options.add_argument("--ignore-certificate-error")
options.add_argument("--ignore-ssl-errors")
browser = webdriver.Chrome('C:\\webdrivers\\chromedriver.exe',options=options)
browser.get("https://www.worldometers.info/coronavirus/")
具备以下功能:
caps = webdriver.DesiredCapabilities.CHROME.copy()
caps['acceptInsecureCerts'] = True
caps['acceptSslCerts'] = True
driver = webdriver.Chrome(desired_capabilities=caps)
https://stackoverflow.com/questions/63466426
复制相似问题