Sign / Computation Layer

Extract the sign of numeric values (-1, 0, or 1). Similar to numpy.sign() or R's sign().

Mathematical form: $y_{i} = ⎩ ⎨ ⎧ - 1 01 if x_{i} < 0 if x_{i} = 0 if x_{i} > 0$

Common applications:

Direction indicators (positive/negative trends)
Error analysis (bias direction)
Phase detection (signal processing)
Flow direction (physics calculations)
Balance indicators (accounting)
Sentiment analysis (positive/negative scores)

Note: Preserves the sign of zero and handles negative zero appropriately.

Table

Transforms

[, ...]

Select

column

The numeric column to extract signs from. Common inputs:

Financial data (profits/losses)
Error terms (residuals)
Measurement differences
Rate of change values
Balance amounts

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.