Loading data from csv file using pandas

Question

 File "<ipython-input-10-1de27a02fcfe>", line 1
df = pd.read_csv('C:\Users\niharika\Downloads\questions-data.csv')
                ^
SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape

Even though I place r in front of C, changing \ to / and also \\. Nothing worked to me.could someone please help me.

Did you try and adding a delimiter to your pd.read_csv argument. It might be that loading engine cannot automatically detect it? — Retiefasaurus, Aug 25 '18 at 07:51

score 0 · Answer 1 · answered Aug 25 '18 at 07:25

0

just try df = pd.read_csv('C:\\Users\\niharika\\Downloads\\questions-data.csv')

answered Aug 25 '18 at 07:25

sandeep rathore

72
10

score 0 · Answer 2 · answered Aug 25 '18 at 10:10

0

Try adding an r in front of the string like this

df = pd.read_csv(r'C:\Users\niharika\Downloads\questions-data.csv')

This case seems similar to yours

Error reading csv file unicodeescape

answered Aug 25 '18 at 10:10

Retiefasaurus

96
3

df = pd.read_csv(r'''C:\Users\niharika\Downloads\questions-data.csv''') try fixing the syntax like this – Retiefasaurus Aug 25 '18 at 12:32

Loading data from csv file using pandas

2 Answers2