I am trying to import Excel file in Python using Pandas. I am working in Spyder.
Below code is copied from a website and edited to suit my requirement.
import pandas as pd
excel_file = ‘ExcelPandasPythonExample.xls’
MyVariable = pd.read_excel(excel_file)
I am getting below error while trying this code. Please note, both the excel file and Python file are saved in the same folder.
FileNotFoundError: [Errno 2] No such file or directory: ‘ExcelPandasPythonExample.xls’
Can anyone please help me in this.