Wolfram Function Repository
Instant-use add-on functions for the Wolfram Language
Function Repository Resource:
Test if an expression contains a Missing value
Check if an expression has a missing value at default level 1:
| In[1]:= | ![ResourceFunction["ContainsMissing"][{1, 2, Missing["NotAvailable"]}]](https://www.wolframcloud.com/obj/resourcesystem/images/a29/a294e4c8-d9ee-4192-82ef-1a64fa6d0818/1e6a55f8393c99d5.png) | 
| Out[1]= |  | 
Check if an expression contains a missing value (at default level 1):
| In[2]:= | ![ResourceFunction[
 "ContainsMissing"][{1, 2, {3, Missing["NotAvailable"]}}]](https://www.wolframcloud.com/obj/resourcesystem/images/a29/a294e4c8-d9ee-4192-82ef-1a64fa6d0818/13cab2a721849c43.png) | 
| Out[2]= |  | 
At level 2, the expression contains a missing value:
| In[3]:= | ![ResourceFunction[
 "ContainsMissing"][{1, 2, {3, Missing["NotAvailable"]}}, 2]](https://www.wolframcloud.com/obj/resourcesystem/images/a29/a294e4c8-d9ee-4192-82ef-1a64fa6d0818/05829180826f6e1a.png) | 
| Out[3]= |  | 
Define some sample data with missing values:
| In[4]:= | ![data = {
   {{2022, 1, 1}, {10, 10, 10, 10, 10}},
   {{2022, 1, 2}, {20, 20, 20, 20, 20}},
   {{2022, 1, 3}, {30, 30, 30, 30, Missing["NotAvailable"]}}
   };](https://www.wolframcloud.com/obj/resourcesystem/images/a29/a294e4c8-d9ee-4192-82ef-1a64fa6d0818/0ffd134717bc842a.png) | 
Check if it contains missing values at the lowest level (-1):
| In[5]:= | ![ResourceFunction["ContainsMissing"][data, -1]](https://www.wolframcloud.com/obj/resourcesystem/images/a29/a294e4c8-d9ee-4192-82ef-1a64fa6d0818/40b6df20d2f0401c.png) | 
| Out[5]= |  | 
Use with Select to get the element of the list with the missing value:
| In[6]:= | ![Select[data, ResourceFunction["ContainsMissing"][#, 2] &]](https://www.wolframcloud.com/obj/resourcesystem/images/a29/a294e4c8-d9ee-4192-82ef-1a64fa6d0818/62034b2225560225.png) | 
| Out[6]= |  | 
Select the data that does not contain missing values:
| In[7]:= | ![Select[data, Not[ResourceFunction["ContainsMissing"][#, 2]] &]](https://www.wolframcloud.com/obj/resourcesystem/images/a29/a294e4c8-d9ee-4192-82ef-1a64fa6d0818/5ea69bff67a413f2.png) | 
| Out[7]= |  | 
This work is licensed under a Creative Commons Attribution 4.0 International License