FileNotFoundError while importing a csv file using pandas in Jupyter notebook

Question

Screenshot of the described error.

import pandas as pd
df = pd.read_csv('/home/josepm/Documents/test_ver2.csv')

---------------------------------------------------------------------------
FileNotFoundError                         Traceback (most recent call last)
<ipython-input-3-5cd7fd573fb7> in <module>()
      1 import pandas as pd
----> 2 df = pd.read_csv('/home/josepm/Documents/test_ver2.csv')

I try to import a CSV file using pandas and every time it says that it doesn't find the file. It's like Jupyter doesn't see it. I tried to do this:

import os
os.path.isfile('/home/josepm/Documents/test_ver2.csv')

and it doesn't see the file either.

Well the error is self explanatory... you have to find out the right pathe to the file.. — B001ᛦ
– B001ᛦ, Commented Oct 9, 2017 at 10:03
I copied the path from the file properties option panel. It should be this one. How can I find the correct one? Screenshot of the file: link — Josep M Domingo
– Josep M Domingo, Commented Oct 9, 2017 at 10:07
I'm using the browser version of Jupyter. Maybe that's the problem. — Josep M Domingo
– Josep M Domingo, Commented Oct 9, 2017 at 10:23

Chankey Pathak · Accepted Answer · 2017-10-09 10:27:42Z

5

Change

pd.read_csv('\Users\user\Desktop\Workbook1.csv')

to

pd.read_csv(r'C:\Users\user\Desktop\Workbook1.csv')

edited Oct 9, 2017 at 10:27

answered Oct 9, 2017 at 10:26

Chankey Pathak

21.8k12 gold badges88 silver badges138 bronze badges

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

1 Comment

Randi Over a year ago

I tried this and this worked for me as well.

S. HU · Accepted Answer · 2017-12-27 07:14:42Z

1

Please try the following code:

import os  
path = os.path.abspath(r'file path')
f = open(path)
print(f)

edited Dec 27, 2017 at 7:14

answered Dec 27, 2017 at 6:05

S. HU

112 bronze badges

Comments

user2844967 · Accepted Answer · 2018-06-21 03:59:14Z

1

The working directory is the point from where all the files are accessed in Jupyter Notebook.

Find the current working directory

import os

os.getcwd()

Example o/p : 'C:\Users\xyz'

Now place your CSV files in this path

List the contents of your directory to check if the CSV file is present

os.listdir('C:\Users\xyz')

Now try reading the CSV file

answered Jun 21, 2018 at 3:59

user2844967

Comments

Ahmed Aunek · Accepted Answer · 2022-07-06 03:16:44Z

1

Copy the file directory, then paste it here:

pd.read_csv(r'(here)\(csv file name including .csv)').

for example:

pd.read_csv(r'C:\Users\DCL\ML and related\Bengaluru_House_Data.csv')

Hope this will work.

edited Jul 6, 2022 at 3:16

answered Jul 6, 2022 at 3:13

Ahmed Aunek

113 bronze badges

Comments

Prabhat Yadav · Accepted Answer · 2024-07-07 09:22:53Z

0

Well, This is not a coding error if you are using Jupiter Notebook.

Just look at your csv file size. if it is nothing showing the file size

you need to upload your csv data one more time like thisClick here to see image

in my case see the image and it shows the file size

edited Jul 7, 2024 at 9:22

answered Jul 7, 2024 at 9:13

Prabhat Yadav

11 bronze badge

1 Comment

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

FileNotFoundError while importing a csv file using pandas in Jupyter notebook

5 Answers 5

1 Comment

Comments

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related