How to drop NA values with Query.jl?

Specific Domains Data
,
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
2 Likes