I am trying to read an xlsx file using pd.read_excel but getting an error like this: Error

My code snippet looks like this: Notebook code

When i tried to open the xlsx file directly from notebook i got this error: opening xlsx file

PLease help me solve this issue.

CodePudding user response：

Your title says pd.read_excel, but your code says pd.read_csv. CSV files are plain text files, readable with Notepad. XLSX files are binary, and are not human-readable. If you have an XLSX file, then use pd.read_excel, like your title says.