title: How to create a loop through multiple excel files same worksheet and perform the same function in pandas
body: <p>I have 130 different excel files which each having 5 worksheets with each having the same name. for example 1st excel file has worksheets like 'Personnele', 'Sales', 'Profit', 'Customer' and 'KPI'. each 130 of them has the same worksheets. I would like to work on the 5th worksheet of 130 excel files, 'KPI'.</p>
  <p>One by one i can read, manipulate, clean change the format (unpivoting etc) and write to excel again. But 130 files one by one takes a lot of time to do it.</p>
  <p>I want to read all of the excel files KPI worksheets into one pandas dataframe and manipulate, clean, change the format and write all of them as one excel file.</p>
  <p>I did try out some of the answers here asked 6 years ago but non of them are my solution.</p>
  <p>How can I do this with pandas?</p>