<p dir="auto">We're due to release 0.13.1 in a few days (or as soon as we clear the queue),<br>
as a bugfix release stabilising 0.13.0, allowing us to start on the 3 month release cycle for 0.14.</p>
<p dir="auto">Anything that isn't in 0.13.1 will have to wait until then to hit pypi.</p>
<p dir="auto">Any objections, warnings or notes?</p>
<p dir="auto">cc <a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/users/jseabold/hovercard" data-octo-click="hovercard-link-click" data-octo-dimensions="link_type:self" href="https://github.com/jseabold">@jseabold</a> , <a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/users/yarikoptic/hovercard" data-octo-click="hovercard-link-click" data-octo-dimensions="link_type:self" href="https://github.com/yarikoptic">@yarikoptic</a>, <a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/users/juliantaylor/hovercard" data-octo-click="hovercard-link-click" data-octo-dimensions="link_type:self" href="https://github.com/juliantaylor">@juliantaylor</a>, <a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/users/takluyver/hovercard" data-octo-click="hovercard-link-click" data-octo-dimensions="link_type:self" href="https://github.com/takluyver">@takluyver</a></p>
<h4 dir="auto">Code Sample, a copy-pastable example if possible</h4>
<div class="highlight highlight-source-python notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="import pandas as pd
df = pd.read_csv('https://user-name:pwd@my.fqdn.com:8080/get_content.csv')
# fails with urlopen error [Errno 11003] getaddrinfo failed Python2.7 as well as Python 3.x"><pre class="notranslate"><span class="pl-k">import</span> <span class="pl-s1">pandas</span> <span class="pl-k">as</span> <span class="pl-s1">pd</span>
<span class="pl-s1">df</span> <span class="pl-c1">=</span> <span class="pl-s1">pd</span>.<span class="pl-en">read_csv</span>(<span class="pl-s">'https://user-name:pwd@my.fqdn.com:8080/get_content.csv'</span>)
<span class="pl-c"># fails with urlopen error [Errno 11003] getaddrinfo failed Python2.7 as well as Python 3.x</span></pre></div>
<h4 dir="auto">Problem description</h4>
<p dir="auto">HTTPS basic auth is very common. This URL format works in Excel, other text editors, etc.  This url works in <code class="notranslate">requests </code> library.  It seems like the scenario doesnt work because the underlying <code class="notranslate">urlopen</code> doesnt work</p>
<div class="highlight highlight-source-python notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="# I think it fails because the underlying code here fails in pandas/io/common.py:
from urllib2 import urlopen as _urlopen
b = _urlopen('https://un-name:pwd@my.fqdn.com:8080/get_content.csv')
# fails with urlopen error [Errno 11003] getaddrinfo failed"><pre class="notranslate"><span class="pl-c"># I think it fails because the underlying code here fails in pandas/io/common.py:</span>
<span class="pl-k">from</span> <span class="pl-s1">urllib2</span> <span class="pl-k">import</span> <span class="pl-s1">urlopen</span> <span class="pl-k">as</span> <span class="pl-s1">_urlopen</span>
<span class="pl-s1">b</span> <span class="pl-c1">=</span> <span class="pl-en">_urlopen</span>(<span class="pl-s">'https://un-name:pwd@my.fqdn.com:8080/get_content.csv'</span>)
<span class="pl-c"># fails with urlopen error [Errno 11003] getaddrinfo failed</span></pre></div>
<p dir="auto">see <a href="https://stackoverflow.com/questions/635113/python-urllib2-basic-http-authentication-and-tr-im" rel="nofollow">stackoverflow issue urllib basic auth</a><br>
Only way to overcome this is using <code class="notranslate">requests</code> + <code class="notranslate">StringIO</code> ?</p>
<h4 dir="auto">Expected Output</h4>
<p dir="auto">be able to get a CSV loaded dataframe</p>
<h4 dir="auto">Output of <code class="notranslate">pd.show_versions()</code></h4>
<details>
python: 2.7.13.final.0
python-bits: 64
pandas: 0.20.1
</details>