#**************     Notebooks / Pivot Widgets / Python      ************** 
#**************   Copyright 2019 Deephaven Data Labs, LLC  ***************

# This Notebook provides working examples for tutorial purposes, 
#and is not meant to replace the primary Deephaven documentation, which can be found at
#https://docs.deephaven.io/latest/Content/User/writeQueries/tableOperations/pivotWidgets.htm.

#############################################################################
# Run this block to import the PivotWidgetBuilder class and open the source
# tables used in each example

import jpy
# Get reference to Pivot Widget Builder java class
PivotWidgetBuilder = jpy.get_type("com.illumon.iris.console.utils.PivotWidgetBuilder")

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


# Basic Pivot Widget

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()