Can't read csv file in same directory

Asked Jan 01 '20 at 10:33

Active Feb 20 '20 at 07:26

Viewed 3,638 times

I have a problem with a Pandas df read_csv command, when I use

import pandas as pd


df = pd.read_csv('C:\\Users\\Johnn\\Desktop\\Stock Picker\\Find Tickercode\\path.csv')

it works, and when I use

df = pd.read_csv('path.csv')

it dosent, but the csv file is in tha same directory as the py file, så I dont understand why

FileNotFoundError: [Errno 2] File b'path.csv' does not exist: b'path.csv

Can anybody please explain it for me. The py script is located in

C:\Users\Johnn\Desktop\Stock Picker\Find Tickercode\path.csv

And my editor is Atom

edited Feb 20 '20 at 07:26

Martin Gergov

asked Jan 01 '20 at 10:33

jhjorsal

where are you running the .py file from? – ignoring_gravity Jan 01 '20 at 10:34
Unfortunately it seems not, rather check again - `is in tha same directory as the py file,` – jezrael Jan 01 '20 at 10:35
2

Python is not running in the same directory as your CSV file resides. Try running Python from that directory. – arsha_ex Jan 01 '20 at 10:51
your csv file and python file need to be in same folder then your second solution will work – ravishankar chavare Jan 01 '20 at 11:04
yes you were all right but to me it is just a little strange that if you run the program from Atom then it does not work but if you run it from CMD it works. Thangs a lot – jhjorsal Jan 01 '20 at 11:12
In Python, you can always learn about your current working directory by issuing: os.getcwd() – arsha_ex Jan 01 '20 at 11:24
See also: https://stackoverflow.com/questions/40627075/how-do-i-get-current-working-directory-in-atom – arsha_ex Jan 01 '20 at 11:26

0 Answers0