Skip to main content

DB_Table.fill_nothing

fill_nothingcolumns default

Group: Values
Aliases: fill missing, if_nothing

Documentation

Returns a new table where missing values in the specified columns have been replaced with the provided default(s).

Arguments

  • columns: Specifies columns by a name, index or regular expression to match names, or a Vector of these.
  • default: The value to replace missing values with. If this argument is a column, the value from default at the corresponding position will be used. If this argument is Previous_Value, the missing values will be replaced with the previous value in the column. Note that the first rows may stay Nothing if they do not have a previous value to use.

Examples

Fill missing values in two columns with the value 20.5.

      fill_nothing = table.fill_nothing ["col0", "col1"] 20.5