Loading CSV into Pandas - no file directory

Question

I need help debugging this code. I am trying to add a csv file to my pandas data frame.

import pandas as pd
df = pd.read_csv ('batting.csv')
print(df)

When I execute this code I am getting this error:

FileNotFoundError: [Errno 2] No such file or directory: 'batting.csv'

I then tried to change the directory using os

os.getcwd()
os.chdir(r"C:\Users\crack\Downloads\excel\batting.csv")

I am now coming across this error:

NotADirectoryError: [WinError 267] The directory name is invalid: 'C:\\Users\\crack\\Downloads\\excel\\batting.csv'

I am new to coding and have been looking for a solution to this error all day.

Indeed, ...\batting.csv is not a directory - it's a file. You could try pd.read_csv(r"C:\Users\crack\Downloads\excel\batting.csv") — ForceBru
– ForceBru, Commented May 7, 2022 at 21:16

fekef · Accepted Answer · 2022-05-07 22:06:43Z

1

You could try ,

df = pd.read_csv(r"C:\Users\crack\Downloads\excel\batting.csv")

instead of df = pd.read_csv ('batting.csv')

answered May 7, 2022 at 22:06

fekef

628 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Martin Evans · Accepted Answer · 2022-10-07 10:37:04Z

You are on the right track. The working directory is probably not where your file is located.

Try doing the following to see where it is:

print(os.getcwd())

The error you are seeing using os.chdir() is because you have specified a filename not a directory.

You have a few possible solutions:

Specify the full path to your CSV file:

pd.read_csv(r"C:\Users\crack\Downloads\excel\batting.csv")

Change the working directory to the same folder:

os.chdir(r"C:\Users\crack\Downloads\excel")
pd.read_csv("batting.csv")