nullFill#

swordfish.function.nullFill()#

When X is a vector/matrix:

  • If Y is a scalar: replace the null values in X with Y.

  • If Y is a vector/matrix : replace the null values in X with the values of corresponding elements in Y.

When X is a table, Y must be a scalar, and the function replaces all null values in X with Y. It is especially useful when we would like to replace all null values in a table with a certain value, such as -999999. Note that the system will convert the data type of Y to the specified column during the replacement. If Y cannot be converted, an error is raised.

The function always returns a new object. Input X is not altered.

Parameters:
  • X (Constant) – A vector/matrix/table.

  • Y (Constant) – Either a scalar, or a vector/matrix with the same dimension as X.