How to drop NA values with Query.jl?

data
query

#1

Could you please explain why this code snippet doesn’t work?

using DataFrames, Query

df = DataFrame(a=[1,2,3], b=@data [NA,2,3])

@from i in df begin
    @where !isequal(i.b, NA)
    @select i
    @collect DataFrame
end

#2

Found the answer to my question:

https://github.com/davidanthoff/Query.jl/issues/118

NA vs. NULL vs. NaN vs. NIL vs. … debate.


#3

The following should also work:

@where i.b != DataValues.NA