title: Convert columns into rows with Pandas
body: <p>So my dataset has some information by location for n dates. The problem is each date is actually a different column header. For example the CSV looks like</p>
  <pre><code>location    name    Jan-2010    Feb-2010    March-2010
  A           &quot;test&quot;  12          20          30
  B           &quot;foo&quot;   18          20          25
  </code></pre>
  <p>What I would like is for it to look like</p>
  <pre><code>location    name    Date        Value
  A           &quot;test&quot;  Jan-2010    12       
  A           &quot;test&quot;  Feb-2010    20
  A           &quot;test&quot;  March-2010  30
  B           &quot;foo&quot;   Jan-2010    18       
  B           &quot;foo&quot;   Feb-2010    20
  B           &quot;foo&quot;   March-2010  25
  </code></pre>
  <p>My problem is I don't know how many dates are in the column (though I know they will always start after name)</p>