Add Panel Perspective Widget for Pivot Table Functionality

[Cyb3r-Monk]

Pivot tables in Excel are useful for investigation. Panel library has Perspective widget that turns a data frame into an interactive pivot table where you can select columns and aggregate functions and turn the data into a pivot table quickly. It would be nice to have the functionality in MSTICPy.

[ianhelle]

I had a look through the panel and perspective docs and there was quite a lot there. Wondered if you had a few use cases in mind that would be worth creating generic wrappers for. E.g. what startup params to use of columns, what kind of aggregation functions, etc. Not fully sure I fully follow how it is meant to be used.

[Cyb3r-Monk]

• It can take all the columns by default and we can supply which columns to use.
• Editable should be set to False(it's True by default)
• Plugin should be set to datagrid (it might be the default option already)
• The rest is totally depends on what the user wants
  • Aggregates, Group By, and Split By can be applied on the widget interactively.

The main use case for us as defenders is to easily apply group by, split by and aggregate without writing the code over and over again and see what happens. The Perspective widget makes it so easy by enabling drag and drop the columns and selecting the aggregations, etc. It's quite similar to the Pivot mode on Sentinel query results table.