title: Could pandas use column as index?
body: <p>I have a spreadsheet like this:</p>
  
  <pre><code>Locality    2005    2006    2007    2008    2009
  
  ABBOTSFORD  427000  448000  602500  600000  638500
  ABERFELDIE  534000  600000  735000  710000  775000
  AIREYS INLET459000  440000  430000  517500  512500
  </code></pre>
  
  <p>I don't want to manually swap the column with the row. Could it be possible        to use pandas reading data to a list as this:</p>
  
  <pre><code>data['ABBOTSFORD']=[427000,448000,602500,600000,638500]
  data['ABERFELDIE']=[534000,600000,735000,710000,775000]
  data['AIREYS INLET']=[459000,440000,430000,517500,512500]
  </code></pre>