Problem in Python pandas read csv

Question

Here is My code -

import pandas as pd
df = pd.read_csv(“C:\users\user\Desktop\Inan”)
print(df.head())

However I keep getting unicode error. I put r,changed slashes,used decode utf,encoding utf,but none are working. They either show unicode error,or say file not found. What am I missing? Aren’t I supposed to put the file path of the csv file in my device inside the bracket? How do I make it work?

Like I said,using double backlash,using different combination of slash,putting ‘r’ in front of C DID NOT WORK

Answer 1

I saved the file as ‘Deaths.csv’ So when I put the filepath,I was supposed to write ‘Deaths.csv.csv’ But instead I put only one csv. So I just changed the name to Deaths and put a csv in the code,and it was fixed.

And I needed to put the r in front. It looks like this now -

df = pd.read_csv(r“C:\Users\User\Desktop\Inan\deaths.csv”)

As this is an almost irreplicable and a silly mistake,I didn’t want to post the answer. But I did it anyways,just in case anyone might find it helpful XD

Answer 2

Have you tried double backslashes?

pd.read.csv("C:\\users\\user\\Desktop\\Inan")

Answer 3

Check the following things:
1) Is your file in the directory it is supposed to be?
2) Did you type the file name correctly in the Python script?
3) Is Python able to find the directory in which your file is?
4) Is the file closed (and not open in another program)?

Answer 4

Ahnaf Inan you want to read a certain file, don't you?
So your path should be something like
r"MyFolder\mydata.csv"

Answer 5

Ahnaf Inan
no that mistake was not silly.
It happens sometimes.
To post the mistake upgrades this post and might help others.

Answer 6

import pandas as pd
df = pd.read.csv(r“C:\users\user\Desktop\Inan”)
print(df.head())

also os.path can help.

Answer 7

My bad,that was a typo. I did run it with _csv,not .csv

Answer 8

You only pass the string with the directory? Where is the file name???

Answer 9

6. is content csv?

Answer 10

Oma Falk if you’re talking about what the error message I got before was,it was the unicode error,and the file not found error.

The file not found error was fixed by properly writing the filename.csv. As for the unicode error,putting the r in front of C:\ fixed it by turning into a raw string

Answer 11

could u send a hardcooy of error message please?

Answer 12

maybe in your time line (feed)

Answer 13

5) Are you running Python in an IDE or in shell/ command line...?

Answer 14

Ahnaf Inan I agree with Oma Falk: It ain't silly, and we all run in problems like that from time to time. 🙂
Thanks, you came back to this thread to share your solution!

Answer 15

moment...
u know it is pd.read_csv?

Answer 16

ok... next try
import pandas as pd
df = pd.read.csv(r“C:\users\user\Desktop\Inan”, encoding = "utf-8" )
print(df.head())

Answer 17

did the encoding utf too

And also the decode utf

as well as engine=python

Answer 18

@ Lisa sorry...I didn’t get it...

How do I put the file name?

Answer 19

Lisa I think I’m dumb as heck. Anyways,I did it the way you said and it said file not found :(

Answer 20

Just change the path of .csv file