title: How to read single item details with multiple rows from uneven data in excel using pandas?
body: <p>I have an excel something like this -</p>
  <p><a href="https://i.stack.imgur.com/mNrUw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mNrUw.png" alt="enter image description here" /></a></p>
  <p>and I want an output like this -</p>
  <p><a href="https://i.stack.imgur.com/26Kcx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/26Kcx.png" alt="enter image description here" /></a></p>
  <p>Basically, I need to convert headers as line items and only the headers with non-zero amount should be picked for an employee. Example: Overtime Earnings will be added for only Employee 2 as it has non-zero amount. Also, for &quot;Other Type&quot;, the description to be considered are the column values except 'Total' and the corresponding amount should be picked from &quot;Other Earnings&quot;.</p>
  <p>Is there any way to achieve this using pandas library?</p>
  <p>Thanks in advance.</p>