Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
consulting .csv file
#1
Hello, there!
I'm new in this forum.
Can you help to correct this code?
I get a message for syntax error.

import pandas as pd

df = pd.read_csv("C:\Users\User\Documents\DATAANALYSIS\DATASETS/avocado.csv")


Thanks in advance,

Biembe
Reply
#2
Don't use single backslash \ character as it also used to escape characters.
The problem here is C:\Users \U is used for Unicode values above FFFF.
>>> smile = '\U0001F642'
>>> print(smile)
Smile

The simplest put r(raw string) in front.
All these are okay:
>>> r"C:\Users\User\Documents\DATAANALYSIS\DATASETS/avocado.csv"
'C:\\Users\\User\\Documents\\DATAANALYSIS\\DATASETS/avocado.csv'
>>> 
>>> "C:/Users/User/Documents/DATAANALYSIS/DATASETS/avocado.csv"
'C:/Users/User/Documents/DATAANALYSIS/DATASETS/avocado.csv'
>>> 
>>> "C:\\Users\\User\\Documents\\DATAANALYSIS\\DATASETS\\avocado.csv"
'C:\\Users\\User\\Documents\\DATAANALYSIS\\DATASETS\\avocado.csv'
Reply


Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020