MissingValuePattern
✖
MissingValuePattern
is an option for SynthesizeMissingValues and ToTabular to specify which data elements are considered missing.
Details

- MissingValuePattern is typically used to identify missing values. For instance, it is common to have some proxy value be interpreted as missing.
- Possible settings include:
-
Automatic automatically determine missing values patt use patt for each element to determine missing values - The patti can also be Automatic, in which case, missing for that column is automatically recognized.
- By default, Missing[…] and Indeterminate values are considered missing.
Examples
open allclose allBasic Examples (2)Summary of the most common use cases
Specify that missing values are indicated by the value "99":

https://wolfram.com/xid/0bh0wz164xzetu-8x5kky

https://wolfram.com/xid/0bh0wz164xzetu-tqp0bi

Specify that the missing values are integers:

https://wolfram.com/xid/0bh0wz164xzetu-wuutgv

https://wolfram.com/xid/0bh0wz164xzetu-3vqe10


https://wolfram.com/xid/0bh0wz164xzetu-wxtvf2

Scope (3)Survey of the scope of standard use cases
Specify missing values with Condition:

https://wolfram.com/xid/0bh0wz164xzetu-s7wk2q

https://wolfram.com/xid/0bh0wz164xzetu-jzetlh


https://wolfram.com/xid/0bh0wz164xzetu-dhfw6z

Train a distribution on a two-dimensional dataset:

https://wolfram.com/xid/0bh0wz164xzetu-9eb8g

Specify that missing values are indicated by the value "7":

https://wolfram.com/xid/0bh0wz164xzetu-u4nvqc

By default, Tabular only interprets explicit Missing[…] expressions as missing values:

https://wolfram.com/xid/0bh0wz164xzetu-fgylne

Use ToTabular to specify a pattern for the entries that should be additionally interpreted as missing values:

https://wolfram.com/xid/0bh0wz164xzetu-9qcy88

Specify multiple MissingValuePattern values:

https://wolfram.com/xid/0bh0wz164xzetu-t8q1ek


https://wolfram.com/xid/0bh0wz164xzetu-nxu3cd

Applications (1)Sample problems that can be solved with this function

https://wolfram.com/xid/0bh0wz164xzetu-hamat6

https://wolfram.com/xid/0bh0wz164xzetu-qzzjzs

Train a distribution on the images:

https://wolfram.com/xid/0bh0wz164xzetu-mwubth

Use MissingValuePattern to replace the pixel values that should be considered missing with the samples generated from the learned distribution:

https://wolfram.com/xid/0bh0wz164xzetu-xk37in

https://wolfram.com/xid/0bh0wz164xzetu-o19bnp

Wolfram Research (2019), MissingValuePattern, Wolfram Language function, https://reference.wolfram.com/language/ref/MissingValuePattern.html (updated 2025).
Text
Wolfram Research (2019), MissingValuePattern, Wolfram Language function, https://reference.wolfram.com/language/ref/MissingValuePattern.html (updated 2025).
Wolfram Research (2019), MissingValuePattern, Wolfram Language function, https://reference.wolfram.com/language/ref/MissingValuePattern.html (updated 2025).
CMS
Wolfram Language. 2019. "MissingValuePattern." Wolfram Language & System Documentation Center. Wolfram Research. Last Modified 2025. https://reference.wolfram.com/language/ref/MissingValuePattern.html.
Wolfram Language. 2019. "MissingValuePattern." Wolfram Language & System Documentation Center. Wolfram Research. Last Modified 2025. https://reference.wolfram.com/language/ref/MissingValuePattern.html.
APA
Wolfram Language. (2019). MissingValuePattern. Wolfram Language & System Documentation Center. Retrieved from https://reference.wolfram.com/language/ref/MissingValuePattern.html
Wolfram Language. (2019). MissingValuePattern. Wolfram Language & System Documentation Center. Retrieved from https://reference.wolfram.com/language/ref/MissingValuePattern.html
BibTeX
@misc{reference.wolfram_2025_missingvaluepattern, author="Wolfram Research", title="{MissingValuePattern}", year="2025", howpublished="\url{https://reference.wolfram.com/language/ref/MissingValuePattern.html}", note=[Accessed: 08-July-2025
]}
BibLaTeX
@online{reference.wolfram_2025_missingvaluepattern, organization={Wolfram Research}, title={MissingValuePattern}, year={2025}, url={https://reference.wolfram.com/language/ref/MissingValuePattern.html}, note=[Accessed: 08-July-2025
]}