title: Transpose subset of pandas dataframe into multi-indexed data frame
body: <p>I have the following dataframe:</p>
  
  <pre><code>df.head(14) 
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/XgeDW.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XgeDW.jpg" alt="enter image description here"></a></p>
  
  <p>I'd like to transpose just the yr and  the <code>['WA_','BA_','IA_','AA_','NA_','TOM_']</code>
  variables by Label. The resulting dataframe should then be a Multi-indexed frame with Label and the WA_, BA_, etc. and the columns names will be 2010, 2011, etc.  I've tried, 
  <code>transpose(), groubby(), pivot_table(), long_to_wide()</code>, 
  and before I roll my own nested loop going line by line through this df I thought I'd ping the community. Something like this by every Label group:
  <a href="https://i.stack.imgur.com/VPa5m.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VPa5m.jpg" alt="enter image description here"></a></p>
  
  <p>I feel like the answer is in one of those functions but I'm just missing it. Thanks for your help! </p>