title: pandas dataframe reshape after pivot
body: <p>The pivot code:</p>
  
  <pre><code>result = pandas.pivot_table(result, values=['value'], index=['index'], columns=['columns'], fill_value=0)
  </code></pre>
  
  <p>The result: </p>
  
  <pre><code>        value   value   value   
  columns col1    col2    col3    
  index
  idx1    14      1       1
  idx2    2       0       1
  idx3    6       0       0  
  </code></pre>
  
  <p>I tried:</p>
  
  <pre><code>result.columns = result.columns.get_level_values(1)
  </code></pre>
  
  <p>Then I got this:</p>
  
  <pre><code>columns col1    col2    col3
  index
  idx1    14      1       1
  idx2    2       0       1
  idx3    6       0       0  
  </code></pre>
  
  <p>Actually what I would like is this one:</p>
  
  <pre><code>index   col1    col2    col3
  idx1    14      1       1
  idx2    2       0       1
  idx3    6       0       0
  </code></pre>
  
  <p>Is there anyway to achieve this? Help really is appreciated. Thank you in advance.</p>