title: pandas pivot table using index data of dataframe
body: <p>I want to create a pivot table from a pandas dataframe
  using dataframe.pivot()
  and include not only dataframe columns but also the data within the dataframe index.
  Couldn't find any docs that show how to do that.
  Any tips?</p>