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.
• Assumes lower <= upper; the result is unspecified for an inverted range.

Examples

Clip values to a range:

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

Referenced By

RelationalAI Documentation
└──  Release Notes
    └──  Python API Release Notes
        └──  What’s New in Version 1.18.0
            └──  Bug Fixes