asked on
Python Append/ Insert Filenames to Existing CSV
I have a process that loops through a source folder, goes to a particular sheet in each workbook, and extracts row data from that specified sheet, creates a dataframe and saves the data to a csv file. Is there a way to append /insert into the csv file the file names of each file in the source folder with out having to write that info into the source files?
* pandasPython
Last Comment
Arana (G.P.)
Do you mean you want to add a column to the dataframe to hold the file the row of data came from?
ASKER
Norrie,
Yes , that is correct-- I want to add a field in the dataframe to hold the name of the each file from the source folder.
Yes , that is correct-- I want to add a field in the dataframe to hold the name of the each file from the source folder.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.