WOLFRAM

Wolfram Language & System Documentation Center

MissingFallback[arg1,arg2,…]

gives the first argument argi that is not MissingQ.

Details
Details and Options Details and Options
Examples  
Basic Examples  
Scope  
Applications  
Properties & Relations  
See Also
Related Guides
History
Cite this Page

MissingFallback

MissingFallback[arg1,arg2,…]

gives the first argument argi that is not MissingQ.

Details

Examples

open all close all

Basic Examples  (2)

MissingFallback gives the first of its arguments that is not of the form Missing[…]:

If only missing elements are present, the last of them will be returned:

Use MissingFallback to replace missing values in a Tabular object with values of another column:

Use a fixed value instead:

Scope  (1)

Use functions of columns in MissingFallback to fill in missing values in a Tabular object:

Use the sum of row values from other columns:

Use the mean of row values from neighboring columns:

Applications  (2)

Construct a Tabular object with a column containing the moons of Pluto:

Some of those moons have a Missing["NotAvailable"] value for the "PolarRadius" property:

Use the "Radius" property as fallback:

Take a Tabular object of Palmer penguin data:

Create a pivot table of penguin species and sex distribution over the islands:

The resulting table has missing values:

Use MissingFallback to fill in Missing values to compute total of all female penguins for each island:

Properties & Relations  (2)

If all arguments of MissingFallback are Missing[…] objects, the last one is returned:

The symbol Missing is not treated as a missing object:

Missing[] with no arguments is treated as a missing object:

Wolfram Research (2025), MissingFallback, Wolfram Language function, https://reference.wolfram.com/language/ref/MissingFallback.html.

Text

Wolfram Research (2025), MissingFallback, Wolfram Language function, https://reference.wolfram.com/language/ref/MissingFallback.html.

CMS

Wolfram Language. 2025. "MissingFallback." Wolfram Language & System Documentation Center. Wolfram Research. https://reference.wolfram.com/language/ref/MissingFallback.html.

APA

Wolfram Language. (2025). MissingFallback. Wolfram Language & System Documentation Center. Retrieved from https://reference.wolfram.com/language/ref/MissingFallback.html

BibTeX

@misc{reference.wolfram_2025_missingfallback, author="Wolfram Research", title="{MissingFallback}", year="2025", howpublished="\url{https://reference.wolfram.com/language/ref/MissingFallback.html}", note=[Accessed: 15-August-2025]}

BibLaTeX

@online{reference.wolfram_2025_missingfallback, organization={Wolfram Research}, title={MissingFallback}, year={2025}, url={https://reference.wolfram.com/language/ref/MissingFallback.html}, note=[Accessed: 15-August-2025]}