Pd read excel()_ errors

[fat_fingers_squared]

Hi,

I am trying to run a simple pd.read_excel() function to read an excel file,"weather_data" I saved on my Mac in a python folder using the following code:


df = pd.read_excel(':C/Macintosh HD Users/myusername/python/weather_data.xlsx')

and I get the following error:

/Users/myusername/python)
^
SyntaxError: invalid syntax

Does anyone have any help or thoughts on best practices, or syntax tips?

Sincere thanks,
me

[snippsat]

df = pd.read_excel(':C/Macintosh HD Users/myusername/python/weather_data.xlsx')

Path should be like this.

df = pd.read_excel('C:/Macintosh HD Users/myusername/python/weather_data.xlsx')

[fat_fingers_squared]

df = pd.read_excel(':C/Macintosh HD Users/myusername/python/weather_data.xlsx')

Path should be like this.

df = pd.read_excel('C:/Macintosh HD Users/myusername/python/weather_data.xlsx')