title: How can I reshape a table with Pandas
body: <p>I need to reshape a single column table with the next format:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Year</th>
  <th>foo</th>
  <th>bar</th>
  <th>baz</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1999</td>
  <td>10</td>
  <td>30</td>
  <td>20</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>to the format:
  |  Category   | value |<br />
  |-----|-------|
  | foo | 10    |<br />
  | bar | 30    |<br />
  | baz | 20    |</p>
  <p>I kinda know how to use pandas pivot and pandas melt, but for some reason, it's not working with my table.
  I made the table extracting a single row from a bigger one containing more years.</p>