search

TomAugspurger / effective-pandas

Source code for my collection of articles on using pandas.
https://leanpub.com/effective-pandas
Creative Commons Attribution 4.0 International
1.53k stars 383 forks source link

error when loading data #35

Open joseberlines opened 3 years ago

joseberlines commented 3 years ago

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

bradhannigandaley commented 3 years ago

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.