tech.tablesaw.aggregate

Class PivotTable

java.lang.Object

tech.tablesaw.aggregate.PivotTable

public class PivotTable
extends Object

PivotTable is used to 'rotate' a source table such that it is summarized on the values of some column. As implemented here, you supply: - a "key" categorical column from which the primary grouping is created, there will be one on each row of the result - a second categorical column for which a subtotal is created; this produces n columns on each row of the result - one column for each unique value - a numeric column that provides the values to be summarized - an aggregation function that defines what operation is performed on the values in the subgroups

Constructor Summary

Constructors

Constructor and Description
PivotTable()

Method Summary

Modifier and Type	Method and Description
static Table	pivot(Table table, CategoricalColumn<?> column1, CategoricalColumn<?> column2, NumericColumn<?> values, AggregateFunction<?,?> aggregateFunction)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

PivotTable

public PivotTable()

Method Detail

pivot

public static Table pivot(Table table,
                          CategoricalColumn<?> column1,
                          CategoricalColumn<?> column2,
                          NumericColumn<?> values,
                          AggregateFunction<?,?> aggregateFunction)