DataFrameAggregationStatistics

DataFrame aggregation statistics

Predefined shortcuts for the most common statistical aggregation operations on DataFrame.

• count — calculate the number of rows (optionally counting only rows that satisfy the given predicate);

• max / maxOf / maxFor — calculate the maximum of all values on the selected columns / by a row expression / for each of the selected columns;

• min / minOf / minFor — calculate the minimum of all values on the selected columns / by a row expression / for each of the selected columns;

• sum / sumOf / sumFor — calculate the sum of all values on the selected columns / by a row expression / for each of the selected columns;

• mean / meanOf / meanFor — calculate the mean (average) of all values on the selected columns / by a row expression / for each of the selected columns;

• std / stdOf / stdFor — calculate the standard deviation of all values on the selected columns / by a row expression / for each of the selected columns;

• median / medianOf / medianFor — calculate the median of all values on the selected columns / by a row expression / for each of the selected columns;

• percentile / percentileOf / percentileFor — calculate a specified percentile of all values on the selected columns / by a row expression / for each of the selected columns.

For more information: See "Summary statistics" on the documentation website.