open csv from different directory in python-CodePudding

Im trying to open a csv file as followed

My ipynb-file is in the following directory -> /data/filename.ipynb where as my csv file is in the following directory -> /data/preprocessed/processed_data.csv

When i try to open the file with the following code:

df = pd.read_csv('/preprocessed/processed_data.csv')

I get an exception that the file doesn't exist. Somehow I think I didn't quite understand how the directories work. Please help, thanks.

CodePudding user response：

try this-

df = pd.read_csv('preprocessed/processed_data.csv')

CodePudding user response：

Try using the os module with a relative path:

import os

filename = os.path.join(os.path.dirname(__file__),'path/to/file/processed_data.csv')
df = pd.read_csv(filename)