read_csv error

[ilcaa72]

here is my statement, and the error, the directory is correct, can you explian the issue? thanks

1 2 3 4 5

import pandas as pd   file = "C:\Users\MTS\Downloads\SPY.csv" spy = pd.read_csv(file) spy.head()

C:\Users\MTS\PycharmProjects\UnitTesting_Lynda\venv\Scripts\python.exe C:/Users/MTS/.PyCharmCE2019.1/config/scratches/scratch.py
File "C:/Users/MTS/.PyCharmCE2019.1/config/scratches/scratch.py", line 2
file = "C:\Users\MTS\Downloads\SPY.csv"
.........^
SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape

Process finished with exit code 1

[michalmonday]

Single backslash gives the following character (or characters) a special meaning:
https://docs.python.org/2.0/ref/strings.html
https://docs.python.org/3/reference/lexi...s-literals

For example '\U' allows you to enter hexadecimal value that will get interpretted as unicode character, like this:

1	print('\U00000041')

Output:
A

So when you wrote C:\Users it expected 8 digits following 'U'.

You could try:

1 2 3

file_name = "C:\\Users\\MTS\\Downloads\\SPY.csv" # or file_name = "C:/Users/MTS/Downloads/SPY.csv"

[ilcaa72]

thanks i ended up adding the r prefix to the string and made it a "raw string" it worked

filename = r"C:\Users\MTS\Downloads\SPY.csv"