Python Forum

Hello all -

I have files I'm trying to import. I do not name these files, they're created by another department. The files start with a number, usually the year. Each time I try to do so I get an error message:

Error:
FileNotFoundError: [Errno 2] No such file or directory:  'N:\\Learing KPI Report\Background Files\X818 Online.xlsx'

The file name is '2018 Online' so not sure why it appears as 'X818' in the error message.

I'm using pandas to import:

import pandas as pd
df = pd.read_excel ("N:\Learing KPI Report\Background Files\X818 Online.xlsx")

I tried importing another file from the same folder that did not start with a number just for kicks and giggles and it imported just fine.

Any assistance is appreciated.

Thanks!

if using python 3.6 or newer, you can use f-string to compile the file name:

>>> file_years = [2010, 2012, 2013, 2015, 2018]
>>> base_dir = 'N:/Learing KPI Report/Background Files/'
>>> for year in file_years:
...     filename = f'{base_dir}{year} Online.xlsx'
...     print(filename)
... 
N:/Learing KPI Report/Background Files/2010 Online.xlsx
N:/Learing KPI Report/Background Files/2012 Online.xlsx
N:/Learing KPI Report/Background Files/2013 Online.xlsx
N:/Learing KPI Report/Background Files/2015 Online.xlsx
N:/Learing KPI Report/Background Files/2018 Online.xlsx
>>> 

Note '/' instead of '\' avoids necessity of having to use escape sequence