FillNullWithNan / Manipulation Layer

Convert null values to NaN (Not a Number) in floating-point columns. Similar to pandas' convert_dtypes() with nullable floating-point handling or R's NA to NaN conversion.

This operation is useful when:

  • Converting between different missing value representations
  • Preparing data for numerical computations
  • Working with libraries that expect NaN for missing values
  • Implementing IEEE 754 floating-point standards

Common applications:

  • Scientific computing frameworks integration
  • Mathematical library compatibility
  • Numerical analysis preparation
  • Legacy system data conversion

Note: Only applicable to floating-point columns as NaN is a special floating-point value defined by IEEE 754 standard.

Table
0
0
Table

Transforms

[, ...]

Defines a single column transformation from null to NaN. This conversion ensures compatibility with numerical computing systems and maintains proper floating-point missing value semantics in mathematical operations.

The floating-point column containing null values to convert to NaN. Used in:

  • Numerical arrays for computation
  • Statistical analysis preparation
  • Mathematical modeling inputs
  • Scientific data processing Must be a floating-point type column.

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.