I tried to import an excel file which is not within the same folder than the script. I need to get one folder above, then into another folder (B_folder) and there is file 2_file.xlsx
I tried:
df = pd.read_excel(r'..\B_folder\2_file.xlsx')
and got:
FileNotFoundError: [Errno 2] No such file or directory: '..\\B_folder\\2_file.xlsx'
also tried:
foreslash instead of backslash
without the 'r' before path
but I always get the error message above or this one:
OSError: [Errno 22] Invalid argument: '..\\B_folder\2_file.xlsx'
what is wrong?
A relative path starts with / , ./ or ../ . To get a relative path in Python you first have to find the location of the working directory where the script or module is stored. Then from that location, you get the relative path to the file want.
path. relpath(path) makes a absolute path to relative path. And if the path provided is itself a relative path then the function returns the same path.
Thanks for your suggestions. None of them did work but I found a solution.
df = pd.read_excel(r'./../B_folder/2_file.xlsx')
This works perfectly fine for me.
So if anybody faces the same problem, I hope this helps.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With