Clip / Manipulation Layer

Limit numeric values to specified bounds. Similar to numpy's clip() or R's pmin(pmax()).

Mathematical form: $y = ⎩ ⎨ ⎧ min x ma x if x < min if min \leq x \leq ma x if x > ma x$

Common applications:

Score normalization (0-100 range)
Physical measurement validation
Rating boundaries (1-5 stars)
Percentage constraints (0-100%)
Threshold enforcement
Outlier handling
Range standardization
Input validation

Table

Select

column

Numeric column to clip. Common scenarios:

Sensor readings within valid ranges
Normalized scores within bounds
Constrained measurements
Validated metrics
Bounded calculations

ClipType

oneof

MinMaxBound

Set both lower and upper bounds. Examples:

Constrain values between 0 and 1
Limit ratings from 1 to 5
Restrict percentages to 0-100
Bound errors within ±3σ

Lower

f64

Minimum allowed value. Values below this are set to this bound. Examples:

Minimum temperature thresholds
Score floors
Safety limit minimums
Baseline guarantees

Upper

f64

Maximum allowed value. Values above this are set to this bound. Examples:

Maximum capacity limits
Score ceilings
Safety limit maximums
Upper thresholds

MinBound

Set only lower bound. Examples:

Ensure non-negative values
Enforce minimum quantities
Maintain safety thresholds
Guarantee minimum levels

Lower

f64

Minimum allowed value. Values below this are set to this bound. Used for:

Non-negative enforcement
Minimum quantity requirements
Lower limit compliance
Base level assurance

MaxBound

Set only upper bound. Examples:

Limit maximum allocations
Cap growth factors
Control maximum exposure
Restrict peak values

Upper

f64

Maximum allowed value. Values above this are set to this bound. Used for:

Resource usage caps
Maximum exposure limits
Upper bound controls
Peak value restrictions

Name for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.