File b'.csv' does not exist

Question

import pandas as pd
df = pd.read_csv("stei-c-1.csv")

when the code is running :

FileNotFoundError: File b'stei-c-1.csv' does not exist

here the directory of file D:\ITB\Tugas\PTI\H4

the python file and the csv file in same location. how to fix it, thanks !

did you try explicitly stating the path to the file `df = pd.read_csv(r"D:\ITB\Tugas\PTI\H4\stei-c-1.csv")` — It_is_Chris, Oct 20 '18 at 17:59
@tavifbicandra if adding the path worked then your python file is probably not in the same directory as the file — It_is_Chris, Oct 20 '18 at 18:04
i have putting the file in same directory as the file, but isn't working — tavif bicandra, Oct 20 '18 at 18:06
File "D:\ITB\Tugas\PTI\H4\tes.py", line 2, in df = pd.read_csv("stei-c-1.csv") — tavif bicandra, Oct 20 '18 at 18:08
@tavifbicandra use `import os` `import pandas as pd` `directory = os.path.dirname(os.path.abspath(__file__))` `df = pd.read_csv(os.path.join(directory, "stei-c-1.csv"))` — eyllanesc, Oct 20 '18 at 18:16
when you execute from an editor the path is relative to the binary that executes it, that is to say the binary of notepad: `D:\Program Files\Notepad++ `, not necessarily of the .py and therefore it causes you the problem, with the previous method you will not have that problem anymore. — eyllanesc, Oct 20 '18 at 18:18
@asynts that's not quite right, it will actually be relative from where you launch the .py — eyllanesc, Oct 20 '18 at 20:33

Karn Kumar · Answer 1 · 2018-10-20T18:13:56.497

1

It should simply work by giving complete path.

df = pd.read_csv(r"D:\ITB\Tugas\PTI\H4\stei-c-1.csv")

However, as other mentioned if you are standing on the same Directory path where your Files are then you don't really need to mention the Full Path otherwise best to place absolute Path.

edited Oct 20 '18 at 18:13

answered Oct 20 '18 at 18:04

Karn Kumar

8,518
3
27
53

3

you forgot the `r` in front of the path – It_is_Chris Oct 20 '18 at 18:05
@Chris, thanks, edited that . – Karn Kumar Oct 20 '18 at 18:08
@Chris, Is that really needed put `r` in front? i'm Linux guy but i saw people using that without `r` as well. – Karn Kumar Oct 20 '18 at 18:11
yes it is unless you specify the path with \\ like such `"D:\\ITB\\Tugas\\PTI\\H4\\stei-c-1.csv"` – It_is_Chris Oct 20 '18 at 18:14
Ahh! thats Glad to know, thnx a mile again. – Karn Kumar Oct 20 '18 at 18:16
D:\Program Files\Notepad++ – tavif bicandra Oct 20 '18 at 18:17
Still not working for me. I'm using mac, does this work for mac too? – dekio Jun 19 '19 at 13:06

File b'.csv' does not exist

1 Answers1