how to read a file name with variable in python?

Question

I have a folder with many .csv files in it with the following format:

FGS07_NAV_26246_20210422_86oylt.xls

FGS07_NAV_26246_ is always the same, 20210422 is the date and the most important parameter to go and pick the file, _86oylt also changes but not important at all.

I need to read one csv file with the same date as the operation date. let’s think that y is our date part, so I tried this code, but it doesn’t give me the write name:

file2 = r'C:/Users/name/Finance/LOF_PnL/FGS07_NAV_26246_' + y + '*.xls'
df2 = pd.read_excel(file2)

How should I fix?

What's does file2 end up as after concatenation? (by the way you're missing the closing apostrophe) — half of a glazier
– half of a glazier, Commented Apr 22, 2021 at 12:33
To find files using wildcards you should look at using glob - docs.python.org/3/library/glob.html. — norie
– norie, Commented Apr 22, 2021 at 12:35
Does this answer your question? Get a filtered list of files in a directory — Tomerikoo
– Tomerikoo, Commented Apr 22, 2021 at 12:41

Felipe Vila Chã · Accepted Answer · 2021-04-22 13:07:24Z

1

if you want just the specific file, you could try this one:

xls_file = [file for file in os.listdir(r"C:/Users/name/Finance/LOF_PnL") if file.endswith("xls") and y in file][0]

edited Apr 22, 2021 at 13:07

answered Apr 22, 2021 at 12:54

Felipe Vila Chã

462 bronze badges

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

Comments

Amit Nanaware · Accepted Answer · 2021-04-22 12:38:01Z

0

you can use glob module:

import glob
file2 = glob.glob(file2)[0]

answered Apr 22, 2021 at 12:38

Amit Nanaware

3,3961 gold badge8 silver badges19 bronze badges

Comments

Eeshaan · Accepted Answer · 2021-04-22 12:48:25Z

0

import os

all_files = os.listdir(r'C:/Users/name/Finance/LOF_PnL')
filtered_files = list(filter(lambda x : 'FGS07_NAV_26246_' + y in x, all_files))

and now filtered_files is a list with the names of all files having 'FGS07_NAV_26246_' + y in their file names. You can add the full path to these names if you want the absolute path. You can also use regex for a more fancy pattern lookup than in

answered Apr 22, 2021 at 12:48

Eeshaan

1,6551 gold badge15 silver badges22 bronze badges

Comments

Minh Quân · Accepted Answer · 2021-04-22 13:03:23Z

0

Maybe you can try to use join() or os.path.join() which are more standard.

"".join([str1, str2])
os.path.join(path_to_file, filename)

I hope this could be helpful. Maybe check the type of the file again also.

answered Apr 22, 2021 at 13:03

Minh Quân

364 bronze badges

Collectives™ on Stack Overflow

how to read a file name with variable in python?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related