How to set proxy for Pandas pd.read_csv

Question

I have a python script that loads a csv file from a server via https. I'm behind a corporate proxy, so I need to provide that info to the script.

Let

proxy_dict = {"https://user:[email protected]:8080"}

where all values are changed to be correct.

Using

print(requests.get(my_url, proxies=proxy_dict).text[:1000]

works as expected.

I want to use pandas.read_csv, which does not have a proxy argument.

How do I set the proxy for pandas? Either as a variable, or for the kernel, or system-wide, as long as only Python is affected.

Running Anaconda 3.6.3 x64 on Windows 7 x64.

Thank you!

Answer 1

Maybe you can read the csv from a string, by using io.StringIO.

Please see the answer on: Pandas read_csv from url

import io

s = requests.get(my_url, proxies=proxy_dict).text

df = pd.read_csv(io.StringIO(s))

Answer 2

In addition, you need to do: proxy_dict = dict("https://user:[email protected]:8080")