What is the correct way to filter on missing values? The following does not work properly:
result = @from r in df begin @where !ismissing(r.A) @select r @collect DataFrame end
When I run such a query, the @where clause does not seem to recognize any values as missing. I encounter the same issue when using
isequal() in place of
ismissing(). I did some searching and learned that there are compatibility issues between Query.jl and the Missing type, and that prior to Julia v0.7
isnull() produced the expected behavior however
isnull() is no longer part of Base.