Here's the full issue syntax:
(unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape
I saw some common solutions but they don't seem to work...I slightly changed the actual pathname for security purposes but here's the code:
import pandas
data = pandas.read_excel("C:\Users\something\PycharmProjects\pythonproject\Test.xlsx")
Here are other versions that failed to work:
data = pandas.read_excel(r"C:\Users\something\PycharmProjects\pythonproject\Test.xlsx")
data = pandas.read_excel(r'C:\Users\something\PycharmProjects\pythonproject\Test.xlsx')
data = pandas.read_excel(r'C:/Users/something/PycharmProjects/pythonproject/Test.xlsx')
data = pandas.read_excel("C:\\Users\\something\\PycharmProjects\\pythonproject\\Test.xlsx")
Rename the "Users" folder; I don't even see the option to rename the folder to avoid the \U issue.
Moved all relevant files to a non-"Users" folder to avoid the \U problem but that didn't work either. I started getting a "_ main _" module not found error.
Any help is greatly appreciated!!