Iterating through txt files in directory, saving filenames

Question

I'm iterating through files in a directory and would like to save the filename and some stuff I extract from the files in the same pandas dataframe. How can I save the names the txt files in a list (which I would then insert into pandas dataframe as a separate column) while going through all the files in a directory?

Here's part of my code:

columns_df = ['file', 'stuff']
df_stuff = pd.DataFrame(columns = columns_df)

filenamelist = []
stufflist = []

os.chdir(r'path\to\directory')
for file in glob.glob('*.txt'):
    # Extract some stuff from file and append to stufflist (DONE)
    # Save filename in the filenamelist (THE PROBLEM)

df_stuff['stuff'] = stufflist
df_stuff['file'] = filenamelist

score 0 · Accepted Answer · answered Sep 17 '20 at 08:38

0

Do you need this functionality?

for file in glob.glob('*.txt'):
    filenamelist.append(file)

answered Sep 17 '20 at 08:38

Alexandra Dudkina

4,302
3
15
27

How didn't I think of this. So simple, yet so effective. Thanks! – est Sep 17 '20 at 09:02

Iterating through txt files in directory, saving filenames

1 Answers1