Multiply / Operator Layer

Perform element-wise multiplication between numeric columns or multiply a column by a constant value. Similar to pandas df['A'] * df['B'] or df['A'] * 5, numpy's multiply, or R's multiplication operator.

Mathematical form: for constant multiplication, or for column multiplication, where is the row index.

Common applications:

  • Currency conversions and exchange rates
  • Scaling measurements or sensor readings
  • Calculating areas (length × width)
  • Applying percentage adjustments
  • Unit conversions (meters to kilometers)
  • Population scaling and sampling weights
  • Energy and power calculations
Table
0
0
Table

The primary column for multiplication. Must be numeric type. Forms the base value for scaling, conversion, or paired multiplication operations.

Integer
0

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

  • ×2 for doubling quantities
  • ×1000 for unit conversions
  • ×100 for percentage calculations
  • ×-1 for sign reversal
0

64-bit unsigned integer multiplier. Range: 0 to 2^64-1. Use cases:

  • Pack size calculations
  • Storage unit conversions
  • Frequency multiplications
  • Batch size adjustments
0

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

  • Rate adjustments (×1.05 for 5% increase)
  • Physical constants (×9.81 for gravity)
  • Scaling factors (×0.001 for milli-units)
  • Probability weights (×0.5 for half-weight)

Other

column

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

  • quantity × unit_price
  • distance × rate
  • signal × amplitude
  • weight × dosage
  • demand × price

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.