Main Content

Clean Missing Data

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


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.

  • Automatically visualize the missing data and the cleaned data.

Clean Missing Data task in 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.


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, and cell arrays of character vectors.

When providing a table or timetable for the input data, specify All supported variables to clean all variables with a supported type. Choose 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 using one of these options:

Linear interpolationLinear interpolation of neighboring, nonmissing values.
Constant valueSpecified constant value.
Previous valuePrevious nonmissing value.
Next valueNext nonmissing value.
Nearest valueNearest nonmissing value.
Spline interpolationPiecewise cubic spline interpolation.
Shape-preserving cubic interpolationShape-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.

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

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

Behavior changed in R2022a