title: Pandas pivot_table, sort values by columns
body: <p>I am a new user to Pandas and I love it!</p>
  
  <p>I am trying to create a pivot table in Pandas. Once I have pivot table the way I want, I would like to rank the values by the columns.</p>
  
  <p>I've attached an image from Excel as it is easier to see in tabular format what I am trying to achieve. <a href="https://i.stack.imgur.com/92iOQ.png" rel="noreferrer">Link to image</a></p>
  
  <p>I've searched through stackoverflow but am having trouble finding an answer. I tried using .sort() but this doesn't work. Any help will be appreciated.</p>
  
  <p>Thanks in advance</p>