Could pandas use column as index?
<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>