title: Pandas: Read a CSV of timeseries data with 'column' header as row element
body: <p>Is it possible to read a CSV file in this format:</p>
  
  <pre><code>2013-01-01,A,1
  2013-01-02,A,2
  2013-01-03,A,3
  2013-01-04,A,4
  2013-01-05,A,5
  2013-01-01,B,1
  2013-01-02,B,2
  2013-01-03,B,3
  2013-01-04,B,4
  2013-01-05,B,5
  </code></pre>
  
  <p>into a DataFrame that ends up like this:</p>
  
  <pre><code>             A   B
  2013-01-01   1   1
  2013-01-02   2   2
  2013-01-03   3   3
  2013-01-04   4   4
  2013-01-05   5   5
  </code></pre>
  
  <p>I couldn't see anything in the I/O docs (<a href="http://pandas.pydata.org/pandas-docs/dev/io.html" rel="nofollow">http://pandas.pydata.org/pandas-docs/dev/io.html</a>)</p>