##  Deephaven - Pivot Widgets Notebook - Python  
##  https://docs.deephaven.io/


from deephaven import *  # imports PivotWidgetBuilder

# generate shared tables
t = db.t("LearnIris", "StockTrades").where("Date=`2017-08-21`")
t2 = db.t("LearnIris", "StockQuotes").where("Date=`2017-08-25`")


# Basic Pivot Widget -  note this is directly using the java class
pw = PivotWidgetBuilder.pivot(t, "USym", "Exchange", "Last").show()


# Adding Row Columns
pwAddRows = PivotWidgetBuilder.pivot(t2, "USym", "Exchange", "Bid").addRows("Status").show()


# Adding Value Columns
pwAddValues = PivotWidgetBuilder.pivot(t, "USym", "Exchange", "Last").addValueColumns("Size").show()


# Adding Aggregations
pwAvg = PivotWidgetBuilder.pivot(t, "USym", "Exchange", "Last").addValueColumns("Size").avg().show()
pwSum = PivotWidgetBuilder.pivot(t, "USym", "Exchange", "Last").addValueColumns("Size").sum().show()


# Adding Grand Totals
pwTotals = PivotWidgetBuilder.pivot(t, "USym", "Exchange", "Last").addValueColumns("Size")\
    .sum().across().down().show()


# Adding Filter Columns
pwFilters = PivotWidgetBuilder.pivot(t, "USym", "Exchange", "Last").addValueColumns("Size")\
    .addFilterColumns("USym", "SaleCondition").sum().across().down().show()