Python Pandas read excel files (xlsx)

df = pd.read_excel(open(DataDir+ “\\usco2015v2.0.xlsx”, “rb”, buffering=0), sheet_name=”usco2015v2.0″)

Previous error messages:

I first used:
df = pd.read_excel(open(DataDir+ “\\usco2015v2.0.xlsx”), sheet_name=’usco2015v2.0′)

Then I got the error message:
ImportError: Missing optional dependency ‘xlrd’. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd.

I installed xlrd, but didn’t solve the problem.