title: Is it possible to write an Excel Pivot Table object from pandas?
body: <p>I'm replacing a lot of my Excel workload with pandas. I need to generate a standard Excel Pivot Table object (with the interactive UI such that users can define filters as they see fit). I'm not too well versed in pandas.pivot_table(), but before digging in want to know if this is possible.
  For example, given this DataFrame:</p>
  <pre><code>   Name Birth Year  Favorite Color
  George  1987    Red
  Maria   1987    Orange
  Andrew  1992    Blue
  Wyatt   1994    Red
  Celeste 1987    Blue
  Peter   1992    Blue
  </code></pre>
  <p>Is it possible to write an XLSX such as in this screenshot:</p>
  <p><a href="https://i.stack.imgur.com/LsEGq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LsEGq.png" alt="Excel pivot table" /></a></p>
  <p>Thanks in advance!</p>