“CSV file does not exist” for a filename in jupyter notebook

Question

i have the following code.and i have the csv file located in the path but when i run the code it just says that the file dosent exist at all.i moved the code to diff locations and changed the path to the new one and i also changed the name of the file but it didnt worked.also i add ".csv" to the name of the file but no good came of it. here is the code:

import pandas as pd
import numpy as np
import csv
filename = ("C:\\Users\\Z\\pima-indians-diabetes.data.csv")
df1 = pd.read_csv(filename)
print(df1.head())'''

The error says

FileNotFoundError: [Errno 2] File C:\Users\Z\pima-indians-diabetes.data.csv does not exist: 'C:\\Users\\Z\\diabetes'

If the computer says the file doesn't exist, it's usually correct. A common beginner error is looking in the wrong place. Perhaps see also https://stackoverflow.com/questions/31435921/difference-between-and — tripleee, Nov 11 '20 at 07:15
my mistake was that i thought that i should add .csv to both code and the file but i understand that ishd have added that only to code and it worked.tnx dudes — Beryl Amend, Nov 11 '20 at 07:36

score 1 · Accepted Answer · answered Nov 11 '20 at 07:12

1

You need to give the *.csv file extension in your code. Replace

filename = ("C:\\Users\\Z\\diabetes")

with

filename = "C:\\Users\\Z\\diabetes.csv"

answered Nov 11 '20 at 07:12

Serge de Gosson de Varennes

2,377
2
10
21

In the description, he said that he added the extension and it didn't work – Oliver Hnat Nov 11 '20 at 07:13
Yes, but he has parenthesis around the filepath. They need to go. – Serge de Gosson de Varennes Nov 11 '20 at 07:14
1

They are harmless as such. – tripleee Nov 11 '20 at 07:16
1

see i did add .csv but it is in vain – Beryl Amend Nov 11 '20 at 07:20
yes finally it did worked tanks alot.i used to change the name of the file too and this time i didnt add .csv to the file but i just added to the code and it did worked, – Beryl Amend Nov 11 '20 at 07:32

score 0 · Answer 2 · answered Nov 11 '20 at 08:26

Few steps to check whether the file indeed exists:

Open a Command Prompt (Click Start and type cmd)
Type this command dir C:\Users\Z\pima-indians-diabetes.*
- This will clearly show if the file in question really exists.
- It might not be there at all.
- Or it might be named C:\Users\Z\diabetes.csv.csv.
- Latter can happen when saving a file with Save As and typing my-file.csv for the file name, unaware that the application being used also adds the extension .csv, so now there are two of those.
Here is the expected command output for an existing file with correct name:

C:\Users\Z>dir C:\Users\Z\pima-indians-diabetes.*
         983 pima-indians-diabetes.data.csv
               1 File(s)            983 bytes
               0 Dir(s)  220,040,663,040 bytes free

tnx alot dear reverent Doron. yes as u also mentioned my problem was the false name as it was named C:\Users\Z\diabetes.csv.csv — Beryl Amend, Nov 13 '20 at 17:15

score -1 · Answer 3 · answered Nov 11 '20 at 07:25

-1

remove '.' from your filename. I think it is effecting your file format

answered Nov 11 '20 at 07:25

phoenix

298
1
10

“CSV file does not exist” for a filename in jupyter notebook

3 Answers3