Skip to content

xlrd required for read_excel put not a requirement in setup.py #14673

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

Closed
kghose opened this issue Nov 16, 2016 · 1 comment
Closed

xlrd required for read_excel put not a requirement in setup.py #14673

kghose opened this issue Nov 16, 2016 · 1 comment
Labels
Build Library building on various platforms Usage Question

Comments

@kghose
Copy link

kghose commented Nov 16, 2016

I feel that requirements, such as 'xlrd' should be part of the setup.py file and installed when we install Pandas. Thanks!

A small, complete example of the issue

# Your code here
import pandas as pd
pd.read_excel('srep10775-s2.xls', sheet=1)

Expected Output

... should be contents of excel file

Actual Output

    218     def __init__(self, io, **kwds):
    219 
--> 220         import xlrd  # throw an ImportError if we need to
    221 
    222         ver = tuple(map(int, xlrd.__VERSION__.split(".")[:2]))

ImportError: No module named 'xlrd'

Output of pd.show_versions()

INSTALLED VERSIONS

commit: None
python: 3.5.2.final.0
python-bits: 64
OS: Darwin
OS-release: 16.1.0
machine: x86_64
processor: i386
byteorder: little
LC_ALL: None
LANG: en_US.UTF-8
LOCALE: en_US.UTF-8

pandas: 0.19.1
nose: 1.3.7
pip: 8.1.2
setuptools: 27.2.0
Cython: 0.24.1
numpy: 1.11.2
scipy: 0.18.1
statsmodels: None
xarray: None
IPython: 5.1.0
sphinx: 1.4.6
patsy: None
dateutil: 2.6.0
pytz: 2016.7
blosc: None
bottleneck: None
tables: 3.3.0
numexpr: 2.6.1
matplotlib: 1.5.3
openpyxl: None
xlrd: None
xlwt: None
xlsxwriter: None
lxml: None
bs4: None
html5lib: None
httplib2: None
apiclient: None
sqlalchemy: None
pymysql: None
psycopg2: None
jinja2: 2.8
boto: None
pandas_datareader: None

@jreback
Copy link
Contributor

jreback commented Nov 16, 2016

xlrd is an optional dependency. you can install it if you wish, but it is not required to use pandas. http://pandas.pydata.org/pandas-docs/stable/install.html#dependencies

@jreback jreback closed this as completed Nov 16, 2016
@jreback jreback added Build Library building on various platforms Usage Question labels Nov 16, 2016
@jreback jreback added this to the Next Major Release milestone Nov 16, 2016
jreback pushed a commit that referenced this issue Sep 22, 2017
Related issues: #8515, #14673

Author: Guilherme Beltramini <[email protected]>

Closes #17613 from gcbeltramini/xlrd-import and squashes the following commits:

dee1998 [Guilherme Beltramini] Add PR number and blank line
c2759cb [Guilherme Beltramini] Throw ImportError
alanbato pushed a commit to alanbato/pandas that referenced this issue Nov 10, 2017
Related issues: pandas-dev#8515, pandas-dev#14673

Author: Guilherme Beltramini <[email protected]>

Closes pandas-dev#17613 from gcbeltramini/xlrd-import and squashes the following commits:

dee1998 [Guilherme Beltramini] Add PR number and blank line
c2759cb [Guilherme Beltramini] Throw ImportError
No-Stream pushed a commit to No-Stream/pandas that referenced this issue Nov 28, 2017
Related issues: pandas-dev#8515, pandas-dev#14673

Author: Guilherme Beltramini <[email protected]>

Closes pandas-dev#17613 from gcbeltramini/xlrd-import and squashes the following commits:

dee1998 [Guilherme Beltramini] Add PR number and blank line
c2759cb [Guilherme Beltramini] Throw ImportError
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Build Library building on various platforms Usage Question
Projects
None yet
Development

No branches or pull requests

2 participants