MissingFallback
MissingFallback[arg1,arg2,…]
gives the first argument argi that is not MissingQ.
Details
![](Files/MissingFallback.en/details_1.png)
- MissingFallback is typically used in TransformColumns and ConstructColumns to indicate how to proceed when Missing values are found.
- If all arguments of MissingFallback are of the form Missing[…], then the last one of them will be returned.
Examples
open allclose allBasic 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:
Scope (1)
Use functions of columns in MissingFallback to fill in missing values in a Tabular object:
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:
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