"Must explicitly set engine if not passing in buffer or path for io" in Panda

python pandas valueerror
JohnAndrews picture JohnAndrews · Mar 22, 2017 · Viewed 7.2k times · Source

When running the following Python Panda code:

    xl          = pd.ExcelFile(dataFileUrl)
    sheets      = xl.sheet_names
    data        = xl.parse(sheets[0])
    colheaders  = list(data)

I receive the ValueError:

Must explicitly set engine if not passing in buffer or path for io

The file is for sure an excel file, no doubt about that.

What is happening?

Answer

Stael picture Stael · Mar 22, 2017

I would try

xl = pd.ExcelFile(dataFileUrl, engine='xlrd')

Related questions

ValueError: Shape of passed values is (1, 6), indices imply (6, 6)

I am passing a list from flask function to another function, and getting this value error. My code at sending end: @app.route('/process', methods=['POST']) def process(): name = request.form['name'] comment = request.form['comment'] wickets = request.form[…

Read More
ValueError: Unknown label type: 'continuous'

I've seen other posts talking about this but anyone of these can help me. I am using jupyter notebook with Python 3.6.0 on windows x6 machine. I have a large dataset but I keep only a piece of it to run …

Read More
sklearn-LinearRegression: could not convert string to float: '--'

I am trying to use a LinearRegression from sklearn and I am getting a 'Could not convert a string to float'. All columns of the dataframe are float and the output y is also float. I have looked at other …

Read More