Skip to main content

Table.fill_nothing

fill_nothingcolumnsdefaulterror_on_missing_columns

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.
  • error_on_missing_columns: If True, an error is raised if any of the specified columns are not found in the table. If False, missing columns are ignored.

Examples​

Fill missing values in two columns with the value 20.5.​

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