clip

relationalai.semantics.std.math

clip(value: NumberValue, lower: NumberValue, upper: NumberValue) -> Expression

Clip (clamp) a value to a range.

Parameters

• value

  (NumberValue) - The value to clip.

• lower

  (NumberValue) - The lower bound.

• upper

  (NumberValue) - The upper bound.

Returns

• Expression - An Expression computing the clipped value (min(upper, max(lower, value))). Returns Number if the input is Number, or Float if the input is Float.

Examples

Clip values to a range:

>>> select(math.clip(Employee.score, 0, 100))
>>> select(math.clip(Temperature.reading, -10, 40))