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.

  • 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 Editor:

  • On the Live Editor tab, select Task > Clean Missing Data.

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

Parameters

Specify the method for filling missing data using one of the following options.

MethodDescription
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.

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.

Introduced in R2019b