FloorDivide / Operator Layer

Perform integer division (floor division) between numeric columns or by a constant value. Similar to Python's // operator, pandas integer division, or R's %/% operator. Rounds down to nearest integer after division.

Mathematical form: $y_{i} = ⌊ \frac{x _{i}}{v} ⌋$ for constant division, or $y_{i} = ⌊ \frac{x _{i}}{z _{i}} ⌋$ for column division.

Common applications:

Time conversion (hours from minutes)
Grouping into fixed sizes (items per package)
Integer ratios (whole units conversion)
Batch calculations (complete batches processed)
Calendar calculations (complete weeks)
Storage allocation (blocks needed)

Note: Division by zero results in null values.

Table

SelectLeft

column

The numerator column for floor division. Must be numeric type. Forms the dividend in integer division operations (e.g., total items, total minutes).

SelectRight

oneof

Integer

Value

i64

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

÷24 (days from hours)
÷7 (complete weeks)
÷100 (integer percentage)

Must be non-zero to avoid null results

UnsignedInteger

Value

u64

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

Batch size calculations
Storage block allocation
Fixed-size grouping

Must be non-zero to avoid null results

Float

Value

f64

64-bit floating-point divisor. Result is still floored to integer. Examples:

÷2.5 (complete pairs with overflow)
÷0.5 (doubling with floor)
÷1.5 (complete units with remainder)

Must be non-zero to avoid null results

Column

Other

column

The denominator column for element-wise floor division. Common pairs:

minutes ÷ interval (complete intervals)
items ÷ package_size (full packages)
storage ÷ block_size (allocated blocks)

Zero values result in null outputs

AsColumn

name

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.