Reading file from a folder in Python

Question

I want to read Test.xlsx but the file is in another folder named 1. Is there a way to specify the file location file_loc? I tried this but there seems to be an error.

import pandas as pd
import numpy as np


file_loc = "C:\Users\USER\OneDrive - Technion\Research_Technion\Python_PNM\Sept12_2022\1\Test.xlsx"

df = pd.read_excel(file_loc, index_col=None, na_values=['NA'], usecols="A,C:AA")
A=df["N"].to_numpy()
print([A])

The error is

line 11
    file_loc = "C:\Users\USER\OneDrive - Technion\Research_Technion\Python_PNM\Sept12_2022\1\Test.xlsx"
                                                                                                       ^
SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape

one possible reason - your excel data is having some unsupported characters — user269867
– user269867, Commented Sep 12, 2022 at 3:28
The error is in specifying the file location, not the contents of the file as shown above. — user19862793
– user19862793, Commented Sep 12, 2022 at 3:34
You need to escape the \ characters in the path; file_loc = "C:\\Users\\USER\\OneDrive - Technion\\Research_Technion\\Python_PNM\\Sept12_2022\\1\\Test.xlsx" — bn_ln
– bn_ln, Commented Sep 12, 2022 at 3:53

Sharim09 · Accepted Answer · 2022-09-12 03:53:10Z

2

Try to change your path string to a raw string r'C:\Users\USER\OneDrive - Technion\Research_Technion\Python_PNM\Sept12_2022\1\Test.xlsx'

because \1 converts to an emoji(☺).

Or replace single slash\ with double slash\\ "C:\\Users\\USER\\OneDrive - Technion\\Research_Technion\\Python_PNM\\Sept12_2022\\1\\Test.xlsx"

import pandas as pd
import numpy as np


file_loc = r"C:\Users\USER\OneDrive - Technion\Research_Technion\Python_PNM\Sept12_2022\1\Test.xlsx"

df = pd.read_excel(file_loc, index_col=None, na_values=['NA'], usecols="A,C:AA")
A=df["N"].to_numpy()
print([A])

answered Sep 12, 2022 at 3:53

Sharim09

6,2262 gold badges10 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Reading file from a folder in Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related