urllib.error.URLError: <urlopen error unknown url type: https>

I have a very simple function to pull an Excel file using Pandas from an url.  This function works perfectly in Jupyter notebook but fails in Pycharm with the following message:

C:\Users\e\AppData\Local\Continuum\anaconda3\envs\v\python.exe C:/Users/e/PycharmProjects/Blackjack/Song.py
Traceback (most recent call last):
  File "C:/Users/e/PycharmProjects/Test/Song.py", line 12, in <module>
    hpi_loader()
  File "C:/Users/e/PycharmProjects/Test/Song.py", line 7, in hpi_loader
    hpi_data = pd.read_excel(url)
  File "C:\Users\e\AppData\Local\Continuum\anaconda3\envs\v\lib\site-packages\pandas\util\_decorators.py", line 188, in wrapper
    return func(*args, **kwargs)
  File "C:\Users\e\AppData\Local\Continuum\anaconda3\envs\v\lib\site-packages\pandas\util\_decorators.py", line 188, in wrapper
    return func(*args, **kwargs)
  File "C:\Users\e\AppData\Local\Continuum\anaconda3\envs\v\lib\site-packages\pandas\io\excel.py", line 350, in read_excel
    io = ExcelFile(io, engine=engine)
  File "C:\Users\e\AppData\Local\Continuum\anaconda3\envs\v\lib\site-packages\pandas\io\excel.py", line 653, in __init__
    self._reader = self._engines[engine](self._io)
  File "C:\Users\e\AppData\Local\Continuum\anaconda3\envs\v\lib\site-packages\pandas\io\excel.py", line 402, in __init__
    filepath_or_buffer = _urlopen(filepath_or_buffer)
  File "C:\Users\e\AppData\Local\Continuum\anaconda3\envs\v\lib\urllib\request.py", line 222, in urlopen
    return opener.open(url, data, timeout)
  File "C:\Users\e\AppData\Local\Continuum\anaconda3\envs\v\lib\urllib\request.py", line 531, in open
    response = meth(req, response)
  File "C:\Users\e\AppData\Local\Continuum\anaconda3\envs\v\lib\urllib\request.py", line 641, in http_response
    'http', request, response, code, msg, hdrs)
  File "C:\Users\e\AppData\Local\Continuum\anaconda3\envs\v\lib\urllib\request.py", line 563, in error
    result = self._call_chain(*args)
  File "C:\Users\e\AppData\Local\Continuum\anaconda3\envs\v\lib\urllib\request.py", line 503, in _call_chain
    result = func(*args)
  File "C:\Users\e\AppData\Local\Continuum\anaconda3\envs\v\lib\urllib\request.py", line 755, in http_error_302
    return self.parent.open(new, timeout=req.timeout)
  File "C:\Users\e\AppData\Local\Continuum\anaconda3\envs\v\lib\urllib\request.py", line 525, in open
    response = self._open(req, data)
  File "C:\Users\e\AppData\Local\Continuum\anaconda3\envs\v\lib\urllib\request.py", line 548, in _open
    'unknown_open', req)
  File "C:\Users\e\AppData\Local\Continuum\anaconda3\envs\v\lib\urllib\request.py", line 503, in _call_chain
    result = func(*args)
  File "C:\Users\e\AppData\Local\Continuum\anaconda3\envs\v\lib\urllib\request.py", line 1387, in unknown_open
    raise URLError('unknown url type: %s' % type)
urllib.error.URLError: <urlopen error unknown url type: https>

Process finished with exit code 1

This is my function, any ideas?  Thanks.

import pandas as pd


def hpi_loader(
        url='http://www.nationwide.co.uk/-/media/MainSite/documents/about/house-price-index/downloads/seasonal_regional.xls?date=june'):
    hpi_data = pd.read_excel(url)
    return hpi_data


if __name__ == "__main__":
    hpi_loader()