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

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’)
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?

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?