title: Can Pandas Read Excel's Group Structure into a MultIndex?
body: <p>I have an Excel file with some (mostly) nicely grouped rows.  I built a fake example below.</p>
  
  <p>Is there a way to get read_excel in Pandas to produce a multiindex preserving this structure?</p>
  
  <p><a href="https://i.stack.imgur.com/8Cq10.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8Cq10.jpg" alt="investment sample"></a></p>
  
  <p>For this example the MultiIndex would have four levels (Family, Individual, Child (optional), investment).  If the subtotal values were lost that would be fine as they can easily be recreated in Pandas.</p>