So I am trying to load an excel file with multiple sheets in it. It is not a CSV file. So I am trying to use read_excel and then giving the reference to the file but still unable to load it.
How do I correct this code?
Asked
Active
Viewed 38 times
1 Answers
1
Prefix your file name by r (raw strings) else \Users will be considered as an unicode sequence:
df = pd.read_excel(r"C:\Users\...")
# HERE --^
Corralien
- 109,409
- 8
- 28
- 52
-
Thankyou kind sir. It worked. Appreciate it – Attitude Black Jun 07 '22 at 23:17
-
@AttitudeBlack if this answers your question then please consider accepting it – Dale K Jun 28 '22 at 00:42