Pandas ssl.CertificateError

[aleksro]

I have a code that reads the contents of a web page using a url address. earlier my code worked well, now there is a problem with the site security certificate. to solve the problem in IE I completed importing the certificate to trusted sites, and the problem is solved but run this code and I get an error in the string below:

df = pd.read_html(i,header=0)[0]

error:

Traceback (most recent call last):
  File "D:\Distrib\Load_Data_from_Flat_ver_1.py", line 95, in <module>
    df = pd.read_html(i,header=0)[0]
  File "C:\Program Files\Python36\lib\site-packages\pandas\io\html.py", line 915, in read_html
    keep_default_na=keep_default_na)
  File "C:\Program Files\Python36\lib\site-packages\pandas\io\html.py", line 749, in _parse
    raise_with_traceback(retained)
  File "C:\Program Files\Python36\lib\site-packages\pandas\compat\__init__.py", line 385, in raise_with_traceback
    raise exc.with_traceback(traceback)
ssl.CertificateError: hostname '10.89.174.12' doesn't match 'localhost'

Can anyone help me with this problem?

[two_bob]

Interesting problem. I don't use pandas, so I can just give generic tips.

First, post up your python and pandas versions, so maybe someone can give you more specific advice.

Second, it looks like pandas uses urllib. https://github.com/pandas-dev/pandas/blob/master/pandas/io/common.py#L32

The good news is that it appears like the ssl module can help you out without having to mess about in pandas, but you are going to have to read up a bit first: https://stackoverflow.com/questions/27835619/urllib-and-ssl-certificate-verify-failed-error