Unable to read .xlsx file using pandas

A. M. Thomas [PETech MIET MBA] thomasomea at gmail.com
Thu Dec 3 07:13:59 EST 2020


Kindly help manage read .xlsx files using pandas, thank you
import numpy as np
import pandas as pd
from pandas import Series, DataFrame
excelfile = pd.ExcelFile('C:\Users\THOMAS\Documents/Hash Analytics
Internship - DemoS2.xlsx')
dframe = excelfile.parse('Sheet10')
print (dframe)
C:\Users\THOMAS\AppData\Local\Programs\Python\Python39\python.exe
"C:/Users/THOMAS/PycharmProjects/Assignment#2/code File.py"
 File "C:\Users\THOMAS\PycharmProjects\Assignment#2\code File.py", line 5
 excelfile = pd.ExcelFile('C:\Users\THOMAS\Documents/Hash Analytics
Internship - DemoS2.xlsx')
 ^
SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in
position 2-3: truncated \UXXXXXXXX escape
Process finished with exit code 1
-- 
Best Regards,
*A. M. Thomas*
Electrical & Solar Systems Expert
*THE GUY BEHIND THE SCENE*
Cell: +254 723 309 157 / +254 731 406 125
Email: thomasomea at gmail.com / thomaso.engineer at gmail.com
"Alternative energy for real and sustainable development that we need"


More information about the Python-list mailing list

AltStyle によって変換されたページ (->オリジナル) /