(unicode error) “unicodeescape” codec can”t decode bytes in position 2-3: truncated UXXXXXXXX escape

StackOverflow

I"m trying to read a .csv file into Python (Spyder) but I keep getting an error. My code:

import csv

data = open("C:UsersmicheDocumentsschooljaar2MIK2.6vektis_agb_zorgverlener")
data = csv.reader(data)  
print(data)

I get the following error:

SyntaxError: (unicode error) "unicodeescape" codec can"t decode bytes in position 2-3: truncated UXXXXXXXX escape

I have tried to replace the with or with / and I"ve tried to put an r before "C.. but all these things didn"t work.

Answer rating: 491

This error occurs because you are using a normal string as a path. You can use one of the three following solutions to fix your problem:

1: Just put r before your normal string it converts normal string to raw string:

pandas.read_csv(r"C:UsersDeePakDesktopmyac.csv")

2:

pandas.read_csv("C:/Users/DeePak/Desktop/myac.csv")

3:

pandas.read_csv("C:UsersDeePakDesktopmyac.csv")

Answer rating: 66

The first backslash in your string is being interpreted as a special character, in fact because it"s followed by a "U" it"s being interpreted as the start of a unicode code point.

To fix this you need to escape the backslashes in the string. I don"t know Python specifically but I"d guess you do it by doubling the backslashes:

data = open("C:UsersmicheDocumentsschooljaar2MIK2.6vektis_agb_zorgverlener")




Get Solution for free from DataCamp guru