I have a strange request, easy to understand but should be very complicated to realize in my opinion. I have a dataframe composed of several spreadsheet excel (using df concat).

I would like to use all the df names (the excel spreadsheet name) to name all my rows, to know in which spreadsheet is coming from this row.

Thank you for your time/help 🙂

Use df name as rows name.