Package tech.tablesaw.aggregate

Class AggregateFunctions

java.lang.Object

tech.tablesaw.aggregate.AggregateFunctions

public class AggregateFunctions
extends Object

Field Summary

Fields

Modifier and Type	Field	Description
static AggregateFunction	count	A function that calculates the count of values in the column excluding missing values.
static BooleanAggregateFunction	countFalse
static AggregateFunction	countMissing	A function that calculates the count of values in the column excluding missing values
static AggregateFunction	countNonMissing	A function that calculates the count of values in the column excluding missing values
static BooleanAggregateFunction	countTrue
static AggregateFunction	countUnique	A function that returns the number of non-missing unique values in the column param
static AggregateFunction	countWithMissing
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 NumericAggregateFunction	max
static NumericAggregateFunction	mean	A function that calculates the mean of the values in the column param
static NumericAggregateFunction	median
static NumericAggregateFunction	min
static NumericAggregateFunction	percentile90
static NumericAggregateFunction	percentile95
static NumericAggregateFunction	percentile99
static NumericAggregateFunction	populationVariance
static NumericAggregateFunction	product
static BooleanAggregateFunction	proportionFalse
static BooleanAggregateFunction	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
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	Description
AggregateFunctions()

Method Summary

Modifier and Type	Method	Description
static double	meanDifference(NumberColumn column1, NumberColumn column2)
static double	percentile(NumberColumn data, double percentile)
static double	sumDifference(NumberColumn column1, NumberColumn column2)

Methods inherited from class java.lang.Object

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

Field Detail

countTrue

public static BooleanAggregateFunction countTrue

countFalse

public static BooleanAggregateFunction countFalse

proportionTrue

public static BooleanAggregateFunction proportionTrue

proportionFalse

public static BooleanAggregateFunction 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

countNonMissing

public static AggregateFunction countNonMissing

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

count

public static AggregateFunction count

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

countMissing

public static AggregateFunction countMissing

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

countUnique

public static AggregateFunction 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

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 AggregateFunction 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

public static final NumericAggregateFunction standardDeviation

Constructor Detail

AggregateFunctions

public AggregateFunctions()

Method Detail

percentile

public static double percentile(NumberColumn data,
                                double percentile)

meanDifference

public static double meanDifference(NumberColumn column1,
                                    NumberColumn column2)

sumDifference

public static double sumDifference(NumberColumn column1,
                                   NumberColumn column2)