Power / Operator Layer
Raise values in a column to a power (exponent), either constant or column-based. Similar to Python's ** operator, numpy.power(), or R's ^ operator.
Mathematical form: for constant exponent, or for column-based exponent, where is the row index.
Common applications:
- Area calculations (length²)
- Volume computations (length³)
- Compound interest (principal × rate^periods)
- Signal processing (amplitude^2)
- Statistical transformations (x^0.5 for sqrt)
- Growth modeling (exponential trends)
- Risk calculations (probability^attempts)
Note: Some combinations may result in null values (e.g., negative base with fractional exponent).
SelectBase
columnThe base column for power operation. Must be numeric type. Forms the number being raised to a power (e.g., principal amount, initial value, base measurement).
SelectExponent
oneofValue
f6464-bit floating-point exponent. Common applications:
- 0.5 for square root
- 1.5 for cube root of square
- 2.5 for power laws
- 0.333 for approximate cube root
May produce complex results with negative bases
Value
i6464-bit signed integer exponent. Range: -2^63 to 2^63-1. Common uses:
- ²: Square (area calculations)
- ³: Cube (volume calculations)
- -1: Reciprocal (1/x)
- -2: Inverse square (radiation falloff)
Negative values produce reciprocal powers
Value
u6464-bit unsigned integer exponent. Range: 0 to 2^64-1. Use cases:
- Powers of 2 (binary scaling)
- Repeated multiplications
- Polynomial terms
- Combination calculations
AsColumn
nameName 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.