title: How to pivot table by ParentAuction column in such a way that i get output shown in picture
body: <p><a href="https://i.stack.imgur.com/SptA3.png" rel="nofollow noreferrer">this a csv file visualized in ms excel</a></p>
  
  <p>how do i use pandas pivot table to get output in such a way that all the Make gets segmented by their respective ParentAuction values</p>
  
  <p>like this,
  <a href="https://i.stack.imgur.com/94I85.png" rel="nofollow noreferrer">output</a> </p>
  
  <p>when i run this,</p>
  
  <pre><code>pd.pivot_table(df,columns=['Make','Sales','AVG PMV','AVG GrossProfit','Loss%'],values=['ParentAuction'])
  </code></pre>
  
  <p>i get this error 
  <code>pandas.core.base.DataError: No numeric types to aggregate
  </code></p>