title: view index, sort results export, pivot table python pandas
body: <p>I created a dataframe, table, from a pivot table in pandas. </p>
  
  <pre><code>df = pd.DataFrame({'v1':[5,5,6,6,1,5], 'v2':['c','a','b','a','a','b']})
  table=pd.pivot_table(df,index=["v2"],values=["v1"],aggfunc=max)
  table.sort_values(by='v1', ascending=True)
  </code></pre>
  
  <p>1) I would like to see also in the table the results of v2.  <br></p>
  
  <p>2) In order to sort I used a new line, is that possible to do it direclty in the pd.pivot_table sentence?  <br></p>
  
  <p>3) in real world some tables are too big to see in the console, what's the best way to export results, to better check them, exporting to .csv?</p>
  
  <p>What I see in the console (Ipyhton shell) is this: </p>
  
  <pre><code>v2   v1 
  c    5
  a    6
  b    6
  </code></pre>