Can't Read_excel With Pandas

I am learning pandas lib. in Python3, but i have a big problem. When i use command to read_excel i get an error. import pandas as pd df = pd.read_excel(r'D:\PythonProjects\stocks.

Solution 1:

What happens when you do

pd.ExcelFile(filename)

If that throws the same error, then it might due to the version of xlrd. I couldn't find extract_formula from xlrd's Book object from their latest release. [source]

Solution 2:

try installing the

xlrd version '0.9.4'

Worked for me

Solution 3:

just add at the beginning of your program:

import xlrd

in case it's not found, > pip install xlrd