Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ENH: read_csv(data_url, verify = False) #36807

Closed
Baelfur opened this issue Oct 2, 2020 · 2 comments
Closed

ENH: read_csv(data_url, verify = False) #36807

Baelfur opened this issue Oct 2, 2020 · 2 comments
Labels
Duplicate Report Duplicate issue or pull request Enhancement IO Data IO issues that don't fit into a more specific label

Comments

@Baelfur
Copy link

Baelfur commented Oct 2, 2020

Is your feature request related to a problem?

Pandas currently allows a csv to be opened from a URL, but does not allow you to set verify to false in the event that URL has an ssl certificate error.

Describe the solution you'd like

please add verify=false parameter to the pandas.read_csv() function when reading a file from a weburl.

API breaking implications

not sure

Describe alternatives you've considered

downloading the file first locally and overriding the ssl error via request.

Additional context

SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1076)

During handling of the above exception, another exception occurred:

URLError Traceback (most recent call last)
in
----> 1 df = pd.read_csv(fileDl)

# Your code here, if applicable
@Baelfur Baelfur added Enhancement Needs Triage Issue that has not been reviewed by a pandas team member labels Oct 2, 2020
@Baelfur Baelfur changed the title ENH: Verify = False ENH: read_csv(data_url, verify = False) Oct 2, 2020
@jreback
Copy link
Contributor

jreback commented Oct 2, 2020

duplicate of #36688

I think we can pass these thru using storage_options={'verify': False}

@jreback jreback closed this as completed Oct 2, 2020
@jreback jreback added IO Data IO issues that don't fit into a more specific label Duplicate Report Duplicate issue or pull request and removed Needs Triage Issue that has not been reviewed by a pandas team member labels Oct 2, 2020
@jreback jreback added this to the No action milestone Oct 2, 2020
@thoughtfuldata
Copy link

thoughtfuldata commented Sep 30, 2021

This actually doesn't work. still getting URLError: <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired

storage_options={'verify': False}

i.e pandas.read_csv('https://sponsor.ajay.app/database/sponsorTimes.csv', storage_options={'verify': False})

This is on windows

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Duplicate Report Duplicate issue or pull request Enhancement IO Data IO issues that don't fit into a more specific label
Projects
None yet
Development

No branches or pull requests

3 participants