Reading XLSX data from subfolders on desktop

  excel, jupyter-notebook, pandas, python, readfile

I am trying to read an excel file into a dataframe using pandas and jupyter notebook from subfolder on my desktop. The file is on my desktop in a folder called ‘Data’, subfolder ‘KN-Data’, subfolder ‘New-Files’, file name "Customers.xlsx".

Here is the code I am trying:

df_customers = pd.read_excel (r"C:/Users/Zach/Desktop/Data/KN-Data/New-Files/Customers.xlsx")

Error is

[Errno 2] No such file or directory: 'C:/Users/Zach/Desktop/Data/KN-Data/New-Files/Customers.xlsx'

Source: Python Questions

LEAVE A COMMENT