title: Using Pandas to average data across excel sheets with matching column data
body: <p><a href="https://i.stack.imgur.com/3ySMd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3ySMd.png" alt="Data Snippet"></a></p>
  
  <p>See data snippet. I have similar data across multiple sheets in Excel with each sheet being a different year. For each month, day, and time (12 and 00), I would like to take the average of column K across all sheets. However, there is not identical # of rows of data for each sheet. I would like to take the average of  K across all sheets but only if data in columns A,B,E,G all match across the sheets. So from the data example, I would get the average value of K2 for all sheets where in every sheet month=1, date=1, time=am,and mb=100.</p>