Pandas CSV Import failing?

Question

I know this should be the easiest thing to do... but I can't figure it out! I'm simply trying to open a file

df1 = pd.read_csv(r'C:\Users\erifilidraklellis\Desktop\In It Together\Excel\CSV\ii2g.csv')

but I keep getting the error

FileNotFoundError: [Errno 2] No such file or directory: 'C:\\Users\\erifilidraklellis\\Desktop\\In It Together\\Excel\\CSV\\ii2g.csv'

Both the file I'm trying to open and the jupyter notebook are currently living in the same folder. Please help!

You can try relative path – Rajarshi Das Aug 04 '21 at 16:38 — Rajarshi Das, Aug 04 '21 at 16:38

score 2 · Answer 1 · answered Aug 04 '21 at 17:00

You mentioned that the files are in the same folder. Have you tried using a relative path ?

pd.read_csv('ii2g.csv')

or

pd.read_csv('./ii2g.csv')

If you have tried these options, maybe this question posted by Impuls3H issue; pandas.read_csv File Not Found Error will be of use.

Vidya Ganesh · Answer 2 · 2021-08-04T17:14:29.010

0

Apparently \In It Together\ has spaces which are not being handled. Try changing the name of the file. You could also refer to the sep section from Pandas Doc

edited Aug 04 '21 at 17:14

answered Aug 04 '21 at 17:03

Vidya Ganesh

788
11
24

I thought using `r'` dealt with that? – DrBwts Aug 04 '21 at 17:04
1

I thought so too and tested with a small example turns out 'r' doesnt seem to help that case – Vidya Ganesh Aug 04 '21 at 17:09

Pandas CSV Import failing?

2 Answers2