Compute the average of numerical values

This processor computes the line by line arithmetical mean (average) of a set of numeric columns.

For a given line, empty columns will be ignored, the mean will be calculated only over the non-empty columns. If all columns are empty, the result will be either an empty cell or a default value defined in the processor options.

Columns selection

This processor can compute the mean over multiple columns:

  • An explicit list of columns

  • All columns matching a given pattern

Examples

  • Mean of [1, 2, 3] will be 2

  • Mean of [1, 2, ""] will be 1.5 (the empty cell is ignored)

  • Mean of ["", ""] will be an empty cell or the default value, depending on the processor options.

Note that the processor doesn’t support non-numeric values: Mean of [1, 2, "some text"] may yield an error when the recipe runs, depending on the execution environment.