Main Content

Clean Missing Data

Find, fill, or remove missing data in the Live Editor

Description

The Clean Missing Data task lets you interactively handle missing data values such as NaN or <missing>. The task automatically generates MATLAB® code for your live script.

Using this task, you can:

  • Find, fill, or remove missing data in a workspace variable.

  • Customize the method for filling data.

  • Define nonstandard missing value indicators.

  • Visualize the missing data and the cleaned data.

Clean Missing Data task in the Live Editor

Open the Task

To add the Clean Missing Data task to a live script in the MATLAB Live Editor:

  • On the Live Editor tab, click Task and select the Clean Missing Data icon .

  • In a code block in the live script, type a relevant keyword, such as missing or remove. Select Clean Missing Data from the suggested command completions.

Parameters

This task operates on input data contained in a vector, table, or timetable. The data can be of type single, double, duration, calendarDuration, datetime, categorical, string, char, or cell arrays of character vectors.

When providing a table or timetable for the input data, select All supported variables to clean all variables with a supported type. Select All numeric variables to clean all variables of type single or double. To choose specific supported variables to clean, select Specified variables and then select the variables individually.

Specify the method for filling missing data as one of these options.

MethodDescription
Linear interpolationLinear interpolation of neighboring, nonmissing values
Constant valueSpecified scalar value, which is 0 by default
Previous valuePrevious nonmissing value
Next valueNext nonmissing value
Nearest valueNearest nonmissing value
Spline interpolationPiecewise cubic spline interpolation
Shape-preserving cubic interpolation (PCHIP)Shape-preserving piecewise cubic spline interpolation
Modified Akima cubic interpolationModified Akima cubic Hermite interpolation
Moving medianMoving median with specified window size
Moving meanMoving mean with specified window size
Custom functionCustom fill method, specified as a local function or a function handle

Specify the window type and size when the method for filling missing data is Moving median or Moving mean.

WindowDescription
CenteredSpecified window length centered about the current point
AsymmetricSpecified window containing the number of elements before the current point and the number of elements after the current point

Window sizes are relative to the X-axis variable units.

Version History

Introduced in R2019b

expand all