python - 使用 pandas read_csv 时出现 urllib.error.URLError

Question

我是 Python 新手，尝试从下面的 URL 下载 csv 文件，但收到如下错误 https://mldata.org/repository/data/download/csv/stockvalues/

下载 csv 的脚本不起作用

import pandas as pd

import numpy as np

url = 'https://mldata.org/repository/data/download/csv/stockvalues.csv'

url_data = pd.read_table(url,sep='\t')

url_data.head(3)

收到以下错误

urllib.error.URLError occurred Message=<urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:749)>
  StackTrace:

C:\Program Files\Anaconda3\lib\urllib\request.py:1320 in AbstractHTTPHandler.do_open

C:\Program Files\Anaconda3\lib\urllib\request.py:1361 in HTTPSHandler.https_open

C:\Program Files\Anaconda3\lib\urllib\request.py:504 in OpenerDirector._call_chain

C:\Program Files\Anaconda3\lib\urllib\request.py:544 in OpenerDirector._open

C:\Program Files\Anaconda3\lib\urllib\request.py:526 in OpenerDirector.open

C:\Program Files\Anaconda3\lib\urllib\request.py:223 in urlopen

C:\Program Files\Anaconda3\lib\site-packages\pandas\io\common.py:186 in get_filepath_or_buffer

C:\Program Files\Anaconda3\lib\site-packages\pandas\io\parsers.py:392 in _read

C:\Program Files\Anaconda3\lib\site-packages\pandas\io\parsers.py:655 in parser_f in _make_parser_function

Answer 1

您的网址有问题。当您的浏览器不信任该 URL 的证书时，就会出现该错误。这绝对意味着该网站有问题，或者链接有问题。