effective-pandas icon indicating copy to clipboard operation
effective-pandas copied to clipboard

error when loading data

Open joseberlines opened this issue 3 years ago • 1 comments

when running cell 2 of the first notebook I get:

SSLError: HTTPSConnectionPool(host='www.transtats.bts.gov', port=443): Max retries exceeded with url: /DownLoad_Table.asp?Table_ID=236&Has_Group=3&Is_Zipped=0 (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1123)')))

It looks a problem related to the connection to the API. Would it be possible to include as part of the repo the data to work with? Thanks

joseberlines avatar Apr 13 '21 15:04 joseberlines

You can work around this by disabling SSL verification when calling the API, by adding verify=False to the requests.post arguments. Which is not something you want to do whenever you are dealing with private credentials or other sensitive information, but I think it's fine to do it here.

bradhannigandaley avatar Apr 23 '21 11:04 bradhannigandaley