tech.tablesaw.analytic

Interface AnalyticQuerySteps.AnalyticFunctions

All Known Subinterfaces:

AnalyticQuerySteps.AddAggregateFunctions, AnalyticQuerySteps.AddAggregateFunctionsWithExecute

Enclosing interface:

AnalyticQuerySteps

public static interface AnalyticQuerySteps.AnalyticFunctions

An AnalyticFunction performs a calculation across a set of table rows that are somehow related to the current row. The related rows are defined by the window frame clause. See AnalyticQuerySteps.DefineWindowFame .

Tablesaw only supports a subset of the analytic functions you might find in a SQL database. If you would like to see a new numbering function implemented please file an issue on GitHub.

Method Summary

Modifier and Type	Method and Description
AnalyticQuerySteps.NameStepAggregate	count(String columnName)
AnalyticQuerySteps.NameStepAggregate	max(String columnName)
AnalyticQuerySteps.NameStepAggregate	mean(String columnName)
AnalyticQuerySteps.NameStepAggregate	min(String columnName)
AnalyticQuerySteps.NameStepAggregate	sum(String columnName)

Method Detail

sum

AnalyticQuerySteps.NameStepAggregate sum(String columnName)

mean

AnalyticQuerySteps.NameStepAggregate mean(String columnName)

max

AnalyticQuerySteps.NameStepAggregate max(String columnName)

min

AnalyticQuerySteps.NameStepAggregate min(String columnName)

count

AnalyticQuerySteps.NameStepAggregate count(String columnName)