Add / Operator Layer

Perform element-wise addition between numeric columns or add a constant value to a column. Similar to pandas df['A'] + df['B'] or df['A'] + 5, or numpy's add operation.

Mathematical form: $y_{i} = x_{i} + v$ for constant addition, or $y_{i} = x_{i} + z_{i}$ for column addition, where $i$ is the row index.

Common applications:

Adjusting values (adding fees, taxes, margins)
Combining measurements or readings
Calculating totals (revenue + tax)
Offsetting numeric data
Index shifting or date adjustments

Table

SelectLeft

column

The primary column for addition operation. Must be numeric type. Forms the base values for the operation (e.g., base price, initial reading, starting value).

SelectRight

oneof

Integer

Value

i64

64-bit signed integer constant to add. Range: -2^63 to 2^63-1. Examples:

100 for fixed adjustments
-50 for deductions
365 for yearly offsets

UnsignedInteger

Value

u64

64-bit unsigned integer constant to add. Range: 0 to 2^64-1. Suitable for:

Adding positive quantities
Count-based adjustments
Non-negative increments

Float

Value

f64

64-bit floating-point constant to add. Provides about 15-17 decimal digits of precision. Common uses:

Percentage adjustments (add 0.05 for 5%)
Price modifications
Scientific calculations
Fractional adjustments

Column

Other

column

The second column for element-wise addition. Must be compatible numeric type with SelectLeft. Common pairs:

Revenue + Tax columns
Base price + Markup
Multiple measurement readings

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.