i have a file with a date as filename e. g. 01012021.xlsx.
I create a new DataFrame based on this file in Pandas.
Now i want to have a column with the Date which is in the File as a TimeStamp.
How can i extract the filename and write it to a column into my DF?
Thanks in advance for any help, very appreciated.