pd.read_excel(url)
View error message
Find out pandas Read url Data time , The use of urllib.request.urlopen Method
Access to information , The reason for the error is that this error will be thrown when the target website uses a self signed certificate
stay Lib\site-packages\pandas\io\common.py In file , That is, add the following code to the header of the above file , Cancel certificate validation globally .
import ssl
ssl._create_default_https_context = ssl._create_unverified_context
If it's a virtual environment , Find the file under the corresponding directory to modify .