Read Excel file using Pandas but not having encoding UTF-8

Q&A Non-DQ Courses
#1

I am trying to do a project of my own and using an excel file for the data.
So to read that file I used the following code:
import pandas as pd
bk_1 = pd.read_excel(‘ex.xlsx’)
print(bk_1)
After running it, a error occured: KeyError: 'show'

Then I tried to open the excel in jupyter then it was giving a message that the file is not UTF-8 encoded.

We have worked with csv files that are encoded differently but are excel files encoded differently too?

#2

Hi @pankajyadav6522,

I would be happy to help you with it. Can you please share with us the Jupyter notebook file (.ipynb) and excel dataset file?

Thanks,
Sahil