AggregateFunctions (tablesaw-core 0.43.1 API)

java.lang.Object
- tech.tablesaw.aggregate.AggregateFunctions

```
public class AggregateFunctions
extends Object
```
Static utility class for pre-defined instances of AggregateFunction

Field Summary

Fields
Modifier and Type	Field	Description
`static BooleanAggregateFunction`	`allTrue`	A function that takes a column argument and returns `true` if all values in that column are true
`static BooleanAggregateFunction`	`anyTrue`	A function that takes a column argument and returns `true` if at least one value in the column is true
`static NumericAggregateFunction`	`change`	A function that takes a `NumericColumn` argument and returns the difference between the last and first items
`static AnyIntAggregateFunction`	`count`	A function that takes a `Column` argument and returns the count of values in the column excluding missing values.
`static BooleanIntAggregateFunction`	`countFalse`	A function that takes a column argument and returns the count of `false` values in the column
`static AnyIntAggregateFunction`	`countMissing`	A function that takes a `NumericColumn` argument and returns the count of missing values in the column
`static AnyIntAggregateFunction`	`countNonMissing`	A function that takes a `Column` argument and returns the count of values in the column excluding missing values
`static BooleanIntAggregateFunction`	`countTrue`	A function that takes a column argument and returns the number of `true` values in a column
`static AnyIntAggregateFunction`	`countUnique`	AA function that takes a `Column` argument and returns the number of non-missing unique values in the column
`static AnyIntAggregateFunction`	`countWithMissing`	A function that takes a `Column` argument and returns the number of values in the column, including missing values
`static NumericAggregateFunction`	`cv`	A function that takes a `NumericColumn` argument and returns the coefficient of variation (stdDev/mean) of the values in the column
`static DateAggregateFunction`	`earliestDate`	A function that takes a column argument and returns the earliest date in that column
`static DateTimeAggregateFunction`	`earliestDateTime`	A function that takes a column argument and returns the earliest date-time value in that column
`static NumericAggregateFunction`	`first`	A function that takes a `NumericColumn` argument and returns the first item without sorting
`static NumericAggregateFunction`	`geometricMean`	A function that takes a `NumericColumn` argument and returns the geometric mean of all values in the column
`static NumericAggregateFunction`	`kurtosis`	A function that takes a `NumericColumn` argument and returns the kurtosis of its values
`static NumericAggregateFunction`	`last`	A function that takes a `NumericColumn` argument and returns the last item without sorting
`static DateAggregateFunction`	`latestDate`	A function that takes a column argument and returns the latest date in that column
`static DateTimeAggregateFunction`	`latestDateTime`	A function that takes a column argument and returns the latest date-time value in that column
`static NumericAggregateFunction`	`max`	A function that takes a `NumericColumn` argument and returns the largeset value in the column
`static InstantAggregateFunction`	`maxInstant`	A function that takes a column argument and returns the latest instant in that column
`static NumericAggregateFunction`	`mean`	A function that takes a `NumericColumn` argument and returns the mean of the values in the column
`static NumericAggregateFunction`	`median`	A function that takes a `NumericColumn` argument and returns the median of the values in the column
`static NumericAggregateFunction`	`min`	A function that takes a `NumericColumn` argument and returns the smallest value in the column
`static InstantAggregateFunction`	`minInstant`	A function that takes a column argument and returns the earliest Instant in that column
`static BooleanAggregateFunction`	`noneTrue`	A function that takes a column argument and returns `true` if no values in the column are true
`static NumericAggregateFunction`	`pctChange`	A function that takes a `NumericColumn` argument and returns the percent difference between the last and first items
`static NumericAggregateFunction`	`percentile90`	A function that takes a `NumericColumn` argument and returns the 90th percentile of the values in the column
`static NumericAggregateFunction`	`percentile95`	A function that takes a `NumericColumn` argument and returns the 95th percentile of the values in the column
`static NumericAggregateFunction`	`percentile99`	A function that takes a `NumericColumn` argument and returns the 99th percentile of the values in the column
`static NumericAggregateFunction`	`populationVariance`	A function that takes a `NumericColumn` argument and returns the population variance of all values in the column
`static NumericAggregateFunction`	`product`	A function that takes a `NumericColumn` argument and returns the product of all values in the column
`static BooleanDoubleAggregateFunction`	`proportionFalse`	A function that takes a column argument and returns the proportion of values in the column that are `false`
`static BooleanDoubleAggregateFunction`	`proportionTrue`	A function that takes a column argument and returns the proportion of values in that column that are `true`
`static NumericAggregateFunction`	`quadraticMean`	A function that takes a `NumericColumn` argument and returns the quadratic mean, aka, the root-mean-square
`static NumericAggregateFunction`	`quartile1`	A function that takes a `NumericColumn` argument and returns the first quartile of the values in the column
`static NumericAggregateFunction`	`quartile3`	A function that takes a `NumericColumn` argument and returns the third quartile of the values in the column
`static NumericAggregateFunction`	`range`	A function that takes a `NumericColumn` argument and returns the difference between the largest and smallest values in the column
`static NumericAggregateFunction`	`skewness`	A function that takes a `NumericColumn` argument and returns the skewness of its values
`static NumericAggregateFunction`	`standardDeviation`	Deprecated. use `stdDev` instead
`static NumericAggregateFunction`	`stdDev`	A function that takes a `NumericColumn` argument and returns the standard deviation of its values
`static NumericAggregateFunction`	`sum`	A function that takes a `NumericColumn` argument and returns the sum of the values in the column
`static NumericAggregateFunction`	`sumOfLogs`	A function that takes a `NumericColumn` argument and returns the sumOfLogs of its values
`static NumericAggregateFunction`	`sumOfSquares`	A function that takes a `NumericColumn` argument and returns the sumOfSquares of its values
`static NumericAggregateFunction`	`variance`	A function that takes a `NumericColumn` argument and returns the variance of its values

Method Summary

All Methods Static Methods Concrete Methods
Modifier and Type	Method	Description
`static Double`	`meanDifference(NumericColumn<?> column1, NumericColumn<?> column2)`	Returns the given mean difference of the values in the arguments TODO(lwhite): These are two column reductions.
`static Double`	`percentile(NumericColumn<?> data, Double percentile)`	Returns the given percentile of the values in the argument
`static Double`	`sumDifference(NumericColumn<?> column1, NumericColumn<?> column2)`	Returns the given sum difference of the values in the arguments TODO(lwhite): These are two column reductions.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - earliestDateTime
```
public static final DateTimeAggregateFunction earliestDateTime
```
    A function that takes a column argument and returns the earliest date-time value in that column
  - earliestDate
```
public static final DateAggregateFunction earliestDate
```
    A function that takes a column argument and returns the earliest date in that column
  - latestDate
```
public static final DateAggregateFunction latestDate
```
    A function that takes a column argument and returns the latest date in that column
  - latestDateTime
```
public static final DateTimeAggregateFunction latestDateTime
```
    A function that takes a column argument and returns the latest date-time value in that column
  - maxInstant
```
public static final InstantAggregateFunction maxInstant
```
    A function that takes a column argument and returns the latest instant in that column
  - minInstant
```
public static final InstantAggregateFunction minInstant
```
    A function that takes a column argument and returns the earliest Instant in that column
  - countTrue
```
public static final BooleanIntAggregateFunction countTrue
```
    A function that takes a column argument and returns the number of true values in a column
  - allTrue
```
public static final BooleanAggregateFunction allTrue
```
    A function that takes a column argument and returns true if all values in that column are true
  - anyTrue
```
public static final BooleanAggregateFunction anyTrue
```
    A function that takes a column argument and returns true if at least one value in the column is true
  - noneTrue
```
public static final BooleanAggregateFunction noneTrue
```
    A function that takes a column argument and returns true if no values in the column are true
  - countFalse
```
public static final BooleanIntAggregateFunction countFalse
```
    A function that takes a column argument and returns the count of false values in the column
  - proportionTrue
```
public static final BooleanDoubleAggregateFunction proportionTrue
```
    A function that takes a column argument and returns the proportion of values in that column that are true
  - proportionFalse
```
public static final BooleanDoubleAggregateFunction proportionFalse
```
    A function that takes a column argument and returns the proportion of values in the column that are false
  - first
```
public static final NumericAggregateFunction first
```
    A function that takes a NumericColumn argument and returns the first item without sorting
  - last
```
public static final NumericAggregateFunction last
```
    A function that takes a NumericColumn argument and returns the last item without sorting
  - change
```
public static final NumericAggregateFunction change
```
    A function that takes a NumericColumn argument and returns the difference between the last and first items
  - pctChange
```
public static final NumericAggregateFunction pctChange
```
    A function that takes a NumericColumn argument and returns the percent difference between the last and first items
  - countNonMissing
```
public static final AnyIntAggregateFunction countNonMissing
```
    A function that takes a Column argument and returns the count of values in the column excluding missing values
  - count
```
public static final AnyIntAggregateFunction count
```
    A function that takes a Column argument and returns the count of values in the column excluding missing values. A synonym for countNonMissing
  - countMissing
```
public static final AnyIntAggregateFunction countMissing
```
    A function that takes a NumericColumn argument and returns the count of missing values in the column
  - countUnique
```
public static final AnyIntAggregateFunction countUnique
```
    AA function that takes a Column argument and returns the number of non-missing unique values in the column
  - mean
```
public static final NumericAggregateFunction mean
```
    A function that takes a NumericColumn argument and returns the mean of the values in the column
  - cv
```
public static final NumericAggregateFunction cv
```
    A function that takes a NumericColumn argument and returns the coefficient of variation (stdDev/mean) of the values in the column
  - sum
```
public static final NumericAggregateFunction sum
```
    A function that takes a NumericColumn argument and returns the sum of the values in the column
  - median
```
public static final NumericAggregateFunction median
```
    A function that takes a NumericColumn argument and returns the median of the values in the column
  - countWithMissing
```
public static final AnyIntAggregateFunction countWithMissing
```
    A function that takes a Column argument and returns the number of values in the column, including missing values
  - quartile1
```
public static final NumericAggregateFunction quartile1
```
    A function that takes a NumericColumn argument and returns the first quartile of the values in the column
  - quartile3
```
public static final NumericAggregateFunction quartile3
```
    A function that takes a NumericColumn argument and returns the third quartile of the values in the column
  - percentile90
```
public static final NumericAggregateFunction percentile90
```
    A function that takes a NumericColumn argument and returns the 90th percentile of the values in the column
  - percentile95
```
public static final NumericAggregateFunction percentile95
```
    A function that takes a NumericColumn argument and returns the 95th percentile of the values in the column
  - percentile99
```
public static final NumericAggregateFunction percentile99
```
    A function that takes a NumericColumn argument and returns the 99th percentile of the values in the column
  - range
```
public static final NumericAggregateFunction range
```
    A function that takes a NumericColumn argument and returns the difference between the largest and smallest values in the column
  - min
```
public static final NumericAggregateFunction min
```
    A function that takes a NumericColumn argument and returns the smallest value in the column
  - max
```
public static final NumericAggregateFunction max
```
    A function that takes a NumericColumn argument and returns the largeset value in the column
  - product
```
public static final NumericAggregateFunction product
```
    A function that takes a NumericColumn argument and returns the product of all values in the column
  - geometricMean
```
public static final NumericAggregateFunction geometricMean
```
    A function that takes a NumericColumn argument and returns the geometric mean of all values in the column
  - populationVariance
```
public static final NumericAggregateFunction populationVariance
```
    A function that takes a NumericColumn argument and returns the population variance of all values in the column
  - quadraticMean
```
public static final NumericAggregateFunction quadraticMean
```
    A function that takes a NumericColumn argument and returns the quadratic mean, aka, the root-mean-square
  - kurtosis
```
public static final NumericAggregateFunction kurtosis
```
    A function that takes a NumericColumn argument and returns the kurtosis of its values
  - skewness
```
public static final NumericAggregateFunction skewness
```
    A function that takes a NumericColumn argument and returns the skewness of its values
  - sumOfSquares
```
public static final NumericAggregateFunction sumOfSquares
```
    A function that takes a NumericColumn argument and returns the sumOfSquares of its values
  - sumOfLogs
```
public static final NumericAggregateFunction sumOfLogs
```
    A function that takes a NumericColumn argument and returns the sumOfLogs of its values
  - variance
```
public static final NumericAggregateFunction variance
```
    A function that takes a NumericColumn argument and returns the variance of its values
  - stdDev
```
public static final NumericAggregateFunction stdDev
```
    A function that takes a NumericColumn argument and returns the standard deviation of its values
  - standardDeviation
```
@Deprecated
public static final NumericAggregateFunction standardDeviation
```
    Deprecated. use stdDev instead
- Method Detail
  - percentile
```
public static Double percentile(NumericColumn<?> data,
                                Double percentile)
```
    Returns the given percentile of the values in the argument
  - meanDifference
```
public static Double meanDifference(NumericColumn<?> column1,
                                    NumericColumn<?> column2)
```
    Returns the given mean difference of the values in the arguments
    TODO(lwhite): These are two column reductions. We need a class for that
  - sumDifference
```
public static Double sumDifference(NumericColumn<?> column1,
                                   NumericColumn<?> column2)
```
    Returns the given sum difference of the values in the arguments
    TODO(lwhite): These are two column reductions. We need a class for that

Class AggregateFunctions

Field Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

earliestDateTime

earliestDate

latestDate

latestDateTime

maxInstant

minInstant

countTrue

allTrue

anyTrue

noneTrue

countFalse

proportionTrue

proportionFalse

first

last

change

pctChange

countNonMissing

count

countMissing

countUnique

mean

cv

sum

median

countWithMissing

quartile1

quartile3

percentile90

percentile95

percentile99

range

min

max

product

geometricMean

populationVariance

quadraticMean

kurtosis

skewness

sumOfSquares

sumOfLogs

variance

stdDev

standardDeviation

Method Detail

percentile

meanDifference

sumDifference