title: Grouping data by column name
body: <p>I have a dataframe that looks like:</p>
  
  <pre><code>[date1] [date1] [date2] [date2]
  
  [Min:]  [Max:]  [Min:]  [Max:]
  
  A         B       C       D
  </code></pre>
  
  <p>and my desired output would look like:</p>
  
  <pre><code>['Date'] ['Min'] ['Max']
  
  [date 1]   A        B
  
  [date 2]   C        D
  </code></pre>
  
  <p>How would I do this in pandas?</p>
  
  <p>I'm simply importing a csv I have locally saved.</p>
  
  <pre><code>import pandas as pd
  
  import csv
  
  import datetime
  
  SampleWeatherDate = pd.read_csv(weatherdata.csv)
  </code></pre>
  
  <p><a href="http://i.stack.imgur.com/PZEnr.png" rel="nofollow">This is what my data looks like in excel</a></p>