# How to drop NA values with Query.jl?

**URL:** <https://discourse.julialang.org/t/how-to-drop-na-values-with-query-jl/7231>\
**Category:** Data\
**Tags:** data, query\
**Created:** [November 21, 2017, 9:11pm UTC](https://discourse.julialang.org/t/how-to-drop-na-values-with-query-jl/7231 "2017-11-21T21:11:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![juliohm](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/juliohm/32/215266_2.png) [@juliohm](https://discourse.julialang.org/u/juliohm)\
**Post date:** [November 21, 2017, 9:11pm UTC](https://discourse.julialang.org/t/how-to-drop-na-values-with-query-jl/7231/1 "2017-11-21T21:11:18Z")

</div>

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

```julia
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

```

---

<div class="post-metadata">

**Author:** ![juliohm](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/juliohm/32/215266_2.png) [@juliohm](https://discourse.julialang.org/u/juliohm)\
**Post date:** [November 21, 2017, 9:13pm UTC](https://discourse.julialang.org/t/how-to-drop-na-values-with-query-jl/7231/2 "2017-11-21T21:13:26Z")

</div>

Found the answer to my question:

[https://github.com/davidanthoff/Query.jl/issues/118](https://github.com/davidanthoff/Query.jl/issues/118)

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

---

<div class="post-metadata">

**Author:** ![davidanthoff](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/davidanthoff/32/223493_2.png) [@davidanthoff](https://discourse.julialang.org/u/davidanthoff)\
**Post date:** [November 21, 2017, 11:04pm UTC](https://discourse.julialang.org/t/how-to-drop-na-values-with-query-jl/7231/3 "2017-11-21T23:04:16Z")

</div>

The following should also work:

```julia
@where i.b != DataValues.NA

```