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 be2
-
Mean of
[1, 2, ""]
will be1.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.