This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English verison of the page.

Note: This page has been translated by MathWorks. Please click here
To view all translated materals including this page, select Japan from the country navigator on the bottom of this page.


Class: dataset

Find dataset array elements with missing values

The dataset data type might be removed in a future release. To work with heterogeneous data, use the MATLAB® table data type instead. See MATLAB table documentation for more information.


I = ismissing(ds)
I = ismissing(ds,Name,Value)


I = ismissing(ds) returns a logical array that indicates which elements in the dataset array, ds, contain a missing value. By default, ismissing recognizes NaN as a missing value in numeric variables, '' as a missing value in character variables, and <undefined> as a missing value in categorical arrays.

  • ds2 = ds(~any(I,2),:) creates a new dataset array containing only the complete observations in ds.

  • ds2 = ds(:,~any(I,1)) creates a new dataset array containing only the variables from ds with no missing values.

I = ismissing(ds,Name,Value) returns missing value indices with additional options specified by one or more Name,Value pair arguments.

Input Arguments


dataset array

Name-Value Pair Arguments

Specify optional comma-separated pairs of Name,Value arguments. Name is the argument name and Value is the corresponding value. Name must appear inside single quotes (' '). You can specify several name and value pair arguments in any order as Name1,Value1,...,NameN,ValueN.


Vector of numeric values to treat as missing value indicators in floating point ds variables. ismissing always treats a NaN value as a missing value.


Character vector or cell array of character vectors to treat as missing value indicators in character ds variables. ismissing always treats '' as a missing value.

Output Arguments


Logical array indicating which elements in ds contain a missing value. I is the same size as ds, with value 1 for elements that contain a missing value.

Was this topic helpful?