avg

relationalai.semantics.std.aggregates

avg(*args: AggValue) -> Aggregate

Compute the average of values.

Parameters

• *args

  (AggValue, default: ()) - Values to average.

Returns

• Aggregate - An Aggregate representing the computation of the average. Returns ScaledNumber if the input is Number, or Float if the input is Float.

Examples

Compute average salary:

>>> select(aggregates.avg(Employee.salary))

Compute average order amount per customer:

>>> select(Customer, aggregates.avg(Order.amount).per(Customer).where(Order.customer == Customer))

Referenced By

RelationalAI Documentation
└──  Build With RelationalAI
    └──  Understand how PyRel works > Use advanced reasoning > Rules-based reasoning
        └──  Aggregate and group data
            └──  Average values with .avg()