Import list of folder names in a folder with Python

Question

So I've started down the path again of trying to automate something. My end game is to combine the data within Excel files containing the Clean Up in the file name and combine the data from a tab within these files named LOV. So basically it had to go into a folder with folders which have folders again that have 2 files, one file has the words Clean Up in the naming and is a .xlsx file. Which I need to only read those files and and pull the data from the tab called LOV into one large file. --- So that's my end goal. Which I just started and I am no where near, but now you know the end game.

Currently I'm stuck just getting a list of Folder names in the Master folder so I at least know it's getting there lol.

import os
import glob
import pandas as pd


# assigns directory location to PCC Folder
os.chdir('V:/PCC Clean Up Project 2017/_DCS Data SWAT Project/PCC Files 
Complete Ready to Submit/Brake System Parts')
FolderList = glob.glob('')

print(FolderList)

Any help is appreciated, thanks guys!

Possible duplicate [here](https://stackoverflow.com/questions/2690324/list-directories-and-get-the-name-of-the-directory) — Marco Milanesio, Nov 10 '17 at 15:15
If you can point me in the direction. All I saw was a file list and I need folder list. — Sam Russo, Nov 10 '17 at 15:16
`dir_names = [name for name in os.listdir(".") if os.path.isdir(name)]` provides you the list of folder names starting from `"."` — Marco Milanesio, Nov 10 '17 at 15:21
whats wrong with `os.listdir()` @SamRussoPalmer can you update your expected output — Pyd, Nov 10 '17 at 15:48

WiLL_K · Answer 1 · 2017-11-10T15:47:51.227

0

EDITED

Firstly Its hard to understand your question. But from what I understand you need to iterate over folders and subfolders, you can do that with

for root, dirs, files in os.walk(source): #Give your path in source
    for file in filenames:
        if file.endswith((".xlxs")): # You can check for any file extension
           filename = os.path.join(subdir,file)
           dirname = subdir.split(os.path.sep)[-1]  # gets the directory name
           print(dirname)

edited Nov 10 '17 at 15:47

answered Nov 10 '17 at 15:21

WiLL_K

575
1
3
22

Hey Will, this looks to still be giving me file names. The question I was asking is the folder names. I've added an image since my wording seems to be confusing. – Sam Russo Nov 10 '17 at 15:27
@SamRussoPalmer Please see the answer above and confirm if it worked for you. And please accept the answer if it solved your problem – WiLL_K Nov 10 '17 at 15:34

mhaseebmlk · Answer 2 · 2017-11-10T16:22:49.850

If you only want the list of folders in your current directory, you can use os.path. Here is how it works:

import os
directory = "V:/PCC Clean Up Project 2017/_DCS Data SWAT Project/PCC Files 
Complete Ready to Submit/Brake System Parts"
childDirectories = next(os.walk(directory))[1]

This will give you a list of all folders in your current directory.

Import list of folder names in a folder with Python

2 Answers2