Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


For more information, see the online learning platform

Fill missing values creates a variable or set of variables filling the missing values with a value designated by the strategy adopted. Missing values can be replaced by a default value, an average value, previous or next values and interpolation. It can be used for numeric and symbolic variables.


  1. Click Transform > Fill missing values in the menu.
  2. Enter a name for the new variable set.  

    titleVariable set

    Note that Filling Missing Values creates a Variable set, containing several new variables. Therefore, to check your Filled Missing variables you can go to the third icon on the left bar.

  3. Enter the variable name, default prefix: CLEAN_
  4. Choose the Method.
  5. Enter a Value, in case, Default Type enter a Default Value.
  6. Select Record set.
  7. Enter the variables or the set of variables.
  8. Enter a Index variable to define the order of rows (records). e.g. Select timestamp if the rows are not in chronological order. The ordering is important for some fill methods: i.e. interpolation, previous and next.  
  9. Click Save.

The types used:

  • Averagethe arithmetic mean of the original variable. 
  • Default value: the value designated in the Default value field. 
  • Interpolation: the linear interpolation between the value of the previous record and the value of the next record.  
  • Previous: the value of the previous record.
  • Next: the value of the next record.