Skip to content
RelationalAI Docs

stddev_samp

relationalai.semantics.std.aggregates 
stddev_samp(*args: AggValue) -> Aggregate

Compute the sample standard deviation of values.

Parameters

  • *args

    (AggValue, default: ()) - Values to compute sample standard deviation over. Can include Distinct wrapper for distinct aggregation.

Returns

  • Aggregate - An Aggregate representing the computation of the sample standard deviation. Always returns Float.

Examples

Compute sample standard deviation of salaries:

select(aggregates.stddev_samp(Employee.salary))

Compute sample standard deviation of salaries per department:

select(Department, aggregates.stddev_samp(Employee.salary).per(Department))

Referenced By

RelationalAI Documentation
└──  Release Notes
    └──  Python API Release Notes
        └──  What’s New in Version 1.10.0
            └──  New Features and Enhancements