docs-v2/content/flux/v0/stdlib/experimental/mean.md

title	description	menu	weight	flux/v0/tags	introduced
experimental.mean() function	`experimental.mean()` computes the mean or average of non-null values in the `_value` column of each input table.	flux_v0_ref name parent identifier experimental.mean experimental experimental/mean	101	transformations aggregates	0.107.0

experimental.mean() computes the mean or average of non-null values in the _value column of each input table.

Output tables contain a single row the with the calculated mean in the _value column.

Function type signature

(<-tables: stream[{A with _value: float}]) => stream[{A with _value: float}]

{{% caption %}} For more information, see Function type signatures. {{% /caption %}}

Parameters

tables

Input data. Default is piped-forward data (<-).

Examples

Calculate the average value of input tables

import "experimental"
import "sampledata"

sampledata.float()
    |> experimental.mean()

{{< expand-wrapper >}} {{% expand "View example input and output" %}}

Input data

_time	*tag	_value
2021-01-01T00:00:00Z	t1	-2.18
2021-01-01T00:00:10Z	t1	10.92
2021-01-01T00:00:20Z	t1	7.35
2021-01-01T00:00:30Z	t1	17.53
2021-01-01T00:00:40Z	t1	15.23
2021-01-01T00:00:50Z	t1	4.43

_time	*tag	_value
2021-01-01T00:00:00Z	t2	19.85
2021-01-01T00:00:10Z	t2	4.97
2021-01-01T00:00:20Z	t2	-3.75
2021-01-01T00:00:30Z	t2	19.77
2021-01-01T00:00:40Z	t2	13.86
2021-01-01T00:00:50Z	t2	1.86

Output data

*tag	_value
t1	8.88

*tag	_value
t2	9.426666666666668

{{% /expand %}} {{< /expand-wrapper >}}