FileNotFoundError: [Errno 2], but path is correct

Question

I ran the following code:

import pandas as pd

data = pd.read_excel(r'C:\Users\ПеКа476\Desktop\Matrices\118_OG_6-sec_imcoh_sensors_4-8.xlsx')
print(data)

but this yielded an error:

FileNotFoundError: [Errno 2] No such file or directory: 'C:\\Users\\ПеКа476\\Desktop\\Matrices\\118_OG_6-sec_imcoh_sensors_4-8.xlsx'

The path is fully correct: C:\Users\ПеКа476\Desktop\Matrices\118_OG_6-sec_imcoh_sensors_4-8.xlsx — I take it from the file description. Can anyone please spot the error? I was trying to read other questions about this problem, but they report the same problem: unfull file path. But in my situation, the file path is almost correct.

@SayandipDutta what do u mean? xlsx? I think that this is the extension of excels files, no? — Arsenii, Mar 12 '20 at 08:02
Go to view, and check show extensions. It could be `xlsx` or `xls` or `csv` or number of different things, it is better to check. You can also find that info in `properties`. If I had to guess, I would say it is `xls` judging bt tge Type hint in your directory. — Sayandip Dutta, Mar 12 '20 at 08:05
@brunodesthuilliers Permissions would cause a different error. — Barmar, Mar 12 '20 at 08:07
@SayandipDutta If I try `csv` format I see this error: `XLRDError: Unsupported format, or corrupt file: Expected BOF record; found b'0.000000'` — Arsenii, Mar 12 '20 at 08:08
Open the excel file. Click File. Go to "Info" (Infromaticija). And click "copy path" (Kopirevai path). — Eduards, Mar 12 '20 at 08:08
It is not about trial and error, you need to check what the extension actually is, if it is `csv` read with `pd.read_csv`. — Sayandip Dutta, Mar 12 '20 at 08:10

score 1 · Accepted Answer · answered Mar 12 '20 at 08:14

1

Open the excel file.

Click File.

Go to "Info"

Click "Copy Path"

This ensures copying the correct path, including the correct extension.

answered Mar 12 '20 at 08:14

Eduards

1,734
2
12
37

FileNotFoundError: [Errno 2], but path is correct

1 Answers1