tech.tablesaw.aggregate

Class AggregateFunctions

java.lang.Object

tech.tablesaw.aggregate.AggregateFunctions

public class AggregateFunctions
extends Object

Field Summary

Fields

Modifier and Type	Field and Description
static BooleanAggregateFunction	allTrue
static BooleanAggregateFunction	anyTrue
static NumericAggregateFunction	change A function that returns the difference between the last and first items
static tech.tablesaw.aggregate.CountFunction	count A function that calculates the count of values in the column excluding missing values.
static tech.tablesaw.aggregate.BooleanCountFunction	countFalse
static tech.tablesaw.aggregate.CountFunction	countMissing A function that calculates the count of values in the column excluding missing values
static tech.tablesaw.aggregate.CountFunction	countNonMissing A function that calculates the count of values in the column excluding missing values
static tech.tablesaw.aggregate.BooleanCountFunction	countTrue
static tech.tablesaw.aggregate.CountFunction	countUnique A function that returns the number of non-missing unique values in the column param
static tech.tablesaw.aggregate.CountFunction	countWithMissing
static NumericAggregateFunction	cv A function that calculates the coefficient of variation (stdDev/mean) of the values in the column
static DateAggregateFunction	earliestDate
static DateTimeAggregateFunction	earliestDateTime
static NumericAggregateFunction	first A function that returns the first item
static NumericAggregateFunction	geometricMean
static NumericAggregateFunction	kurtosis
static NumericAggregateFunction	last A function that returns the last item
static DateAggregateFunction	latestDate
static DateTimeAggregateFunction	latestDateTime
static NumericAggregateFunction	max
static InstantAggregateFunction	maxInstant
static NumericAggregateFunction	mean A function that calculates the mean of the values in the column param
static NumericAggregateFunction	median
static NumericAggregateFunction	min
static InstantAggregateFunction	minInstant
static BooleanAggregateFunction	noneTrue
static NumericAggregateFunction	pctChange A function that returns the difference between the last and first items
static NumericAggregateFunction	percentile90
static NumericAggregateFunction	percentile95
static NumericAggregateFunction	percentile99
static NumericAggregateFunction	populationVariance
static NumericAggregateFunction	product
static tech.tablesaw.aggregate.BooleanNumericFunction	proportionFalse
static tech.tablesaw.aggregate.BooleanNumericFunction	proportionTrue
static NumericAggregateFunction	quadraticMean Returns the quadratic mean, aka, the root-mean-square
static NumericAggregateFunction	quartile1
static NumericAggregateFunction	quartile3
static NumericAggregateFunction	range
static NumericAggregateFunction	skewness
static NumericAggregateFunction	standardDeviation Deprecated. use stdDev instead
static NumericAggregateFunction	stdDev
static NumericAggregateFunction	sum A function that calculates the sum of the values in the column param
static NumericAggregateFunction	sumOfLogs
static NumericAggregateFunction	sumOfSquares
static NumericAggregateFunction	variance

Constructor Summary

Constructors

Constructor and Description
AggregateFunctions()

Method Summary

Modifier and Type	Method and Description
static Double	meanDifference(NumericColumn<?> column1, NumericColumn<?> column2)
static Double	percentile(NumericColumn<?> data, Double percentile)
static Double	sumDifference(NumericColumn<?> column1, NumericColumn<?> column2)

Methods inherited from class java.lang.Object

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

Field Detail

earliestDateTime

public static DateTimeAggregateFunction earliestDateTime

earliestDate

public static DateAggregateFunction earliestDate

latestDate

public static DateAggregateFunction latestDate

latestDateTime

public static DateTimeAggregateFunction latestDateTime

maxInstant

public static InstantAggregateFunction maxInstant

minInstant

public static InstantAggregateFunction minInstant

countTrue

public static tech.tablesaw.aggregate.BooleanCountFunction countTrue

allTrue

public static BooleanAggregateFunction allTrue

anyTrue

public static BooleanAggregateFunction anyTrue

noneTrue

public static BooleanAggregateFunction noneTrue

countFalse

public static tech.tablesaw.aggregate.BooleanCountFunction countFalse

proportionTrue

public static tech.tablesaw.aggregate.BooleanNumericFunction proportionTrue

proportionFalse

public static tech.tablesaw.aggregate.BooleanNumericFunction proportionFalse

first

public static NumericAggregateFunction first

A function that returns the first item

last

public static NumericAggregateFunction last

A function that returns the last item

change

public static NumericAggregateFunction change

A function that returns the difference between the last and first items

pctChange

public static NumericAggregateFunction pctChange

A function that returns the difference between the last and first items

countNonMissing

public static tech.tablesaw.aggregate.CountFunction countNonMissing

A function that calculates the count of values in the column excluding missing values

count

public static final tech.tablesaw.aggregate.CountFunction count

A function that calculates the count of values in the column excluding missing values. A synonym for countNonMissing

countMissing

public static tech.tablesaw.aggregate.CountFunction countMissing

A function that calculates the count of values in the column excluding missing values

countUnique

public static tech.tablesaw.aggregate.CountFunction countUnique

A function that returns the number of non-missing unique values in the column param

mean

public static final NumericAggregateFunction mean

A function that calculates the mean of the values in the column param

cv

public static final NumericAggregateFunction cv

A function that calculates the coefficient of variation (stdDev/mean) of the values in the column

sum

public static final NumericAggregateFunction sum

A function that calculates the sum of the values in the column param

median

public static final NumericAggregateFunction median

countWithMissing

public static final tech.tablesaw.aggregate.CountFunction countWithMissing

quartile1

public static final NumericAggregateFunction quartile1

quartile3

public static final NumericAggregateFunction quartile3

percentile90

public static final NumericAggregateFunction percentile90

percentile95

public static final NumericAggregateFunction percentile95

percentile99

public static final NumericAggregateFunction percentile99

range

public static final NumericAggregateFunction range

min

public static final NumericAggregateFunction min

max

public static final NumericAggregateFunction max

product

public static final NumericAggregateFunction product

geometricMean

public static final NumericAggregateFunction geometricMean

populationVariance

public static final NumericAggregateFunction populationVariance

quadraticMean

public static final NumericAggregateFunction quadraticMean

Returns the quadratic mean, aka, the root-mean-square

kurtosis

public static final NumericAggregateFunction kurtosis

skewness

public static final NumericAggregateFunction skewness

sumOfSquares

public static final NumericAggregateFunction sumOfSquares

sumOfLogs

public static final NumericAggregateFunction sumOfLogs

variance

public static final NumericAggregateFunction variance

stdDev

public static final NumericAggregateFunction stdDev

standardDeviation

@Deprecated
public static final NumericAggregateFunction standardDeviation

Deprecated. use stdDev instead

Constructor Detail

AggregateFunctions

public AggregateFunctions()

Method Detail

percentile

public static Double percentile(NumericColumn<?> data,
                                Double percentile)

meanDifference

public static Double meanDifference(NumericColumn<?> column1,
                                    NumericColumn<?> column2)

sumDifference

public static Double sumDifference(NumericColumn<?> column1,
                                   NumericColumn<?> column2)