Find missing values
TF = ismissing(
returns a logical array that indicates which elements of an array or table contain missing values. The size ofA
)TF
is the same as the size ofA
.
Standard missing values depend on the data type:
NaN
fordouble
,single
,duration
, andcalendarDuration
NaT
fordatetime
forstring
forcategorical
' '
forchar
{''}
forcell
of character vectors
TF = ismissing(
treats the values inA
,indicator
)indicator
as missing value indicators, ignoring all default indicators listed in the previous syntax.indicator
can be a single indicator or multiple indicators. For example, ifA
is an array of typedouble
, thenismissing(A,[0,-99])
treats 0 and -99 as missingdouble
values instead ofNaN
.
Since integer variables cannot storeNaN
, use a special integer value (otherwise unused) to indicate missing integer data, such as-99
.
For more information on finding missing strings, seeTest for Empty Strings and Missing Values.
ismissing
handles leading and trailing white space differently for indicators that are cell arrays of character vectors, character arrays, or categorical arrays.
For cell arrays of character vectors,ismissing
does not ignore indicator white space. All character vectors must match exactly.
For character arrays in table variables,ismissing
ignores trailing white space in the indicator.
For categorical arrays,ismissing
ignores leading and trailing white space in the indicator.
all
|any
|Clean Missing Data|fillmissing
|isempty
|isnan
|isoutlier
|isundefined
|missing
|rmmissing
|standardizeMissing