How to specify directory using glob in python?

Question

Say I have a list of directories dirs.

dirs = ['C:\\path\\to\\dir1','C:\\path\\to\\dir2','C:\\path\\to\\dir3']

And in each of these directories, there are several excel files I want to get a list of. If I just use glob.glob("*.xls*") this only gives me a list of excel files in my current working directory, but I want to specifically get a list of the excel files in "C:\path\to\dir1", "C:\path\to\dir2" etc.

I have tried

import glob
for direc in dirs:
    print(glob.glob(direc + "*.xls*")
>>>[]

but this just produces empty lists.

What am I doing wrong here? How can I get a list of the excel files in each of the directories in dirs?

Or use os.path.join, so it still works if your directory name ends in a slash or back slash. — Sven Marnach
– Sven Marnach, Commented May 9, 2018 at 15:24
You can also glob recursively: glob.glob('dir*/*.xls*'). If it works from the command-line, it works in Python. — Erik Cederstrand
– Erik Cederstrand, Commented May 9, 2018 at 15:25

goks · Accepted Answer · 2018-05-22 18:44:45Z

4

You can use os.walk()

import os 
   for root,dirs,files in os.walk('C:\\path\\to\\'):
        for names in files:
            if names.endswith('.xls'):
               print(os.path.join(root, names))

edited May 22, 2018 at 18:44

answered May 9, 2018 at 15:37

goks

1,2065 gold badges20 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

How to specify directory using glob 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