MissingDataRules

MissingDataRules
is an option for SemanticImport and related functions that specifies what should be considered "missing" and what to replace it with.

DetailsDetails

  • MissingDataRules->{s1->val1,s2->val2,} specifies that whenever an element has the form of a string or string pattern , it should be replaced in the output by a Missing incorporating .
  • MissingDataRules-><|name1->{s1->val1,},name2->,|> specifies replacements to use in columns with names .
  • MissingDataRules->{{s1->val1,},} specifies replacements to use in successive columns.
  • If is of the form Missing[], it is used directly.
  • MissingDataRules->Automatic uses heuristics to determine which elements should be considered missing.

ExamplesExamplesopen allclose all

Basic Examples  (5)Basic Examples  (5)

Specify how to handle missing data:

In[1]:=
Click for copyable input
Out[1]=
In[2]:=
Click for copyable input
Out[2]=

Match missing data by pattern:

In[1]:=
Click for copyable input
Out[1]=
In[2]:=
Click for copyable input
Out[2]=

Handle missing data differently in each column:

In[1]:=
Click for copyable input
Out[1]=
In[2]:=
Click for copyable input
Out[2]=

Handle missing data in the second column only:

In[1]:=
Click for copyable input
Out[1]=
In[2]:=
Click for copyable input
Out[2]=

Specify how to handle missing data by column name:

In[1]:=
Click for copyable input
Out[1]=
In[2]:=
Click for copyable input
Out[2]=
Introduced in 2014
(10.0)