Drop rows containing missing values

This is a method for the tidyr drop_na() generic. It is translated to data.table::na.omit()

# S3 method for dtplyr_step
drop_na(data, ...)

Arguments

data	A lazy_dt().
...	<tidy-select> Columns to inspect for missing values.

Examples

library(dplyr)
library(tidyr)

dt <- lazy_dt(tibble(x = c(1, 2, NA), y = c("a", NA, "b")))
dt %>% drop_na()
#> Source: local data table [1 x 2]
#> Call:   na.omit(`_DT7`)
#> 
#>       x y    
#>   <dbl> <chr>
#> 1     1 a    
#> 
#> # Use as.data.table()/as.data.frame()/as_tibble() to access results
dt %>% drop_na(x)
#> Source: local data table [2 x 2]
#> Call:   na.omit(`_DT7`, cols = "x")
#> 
#>       x y    
#>   <dbl> <chr>
#> 1     1 a    
#> 2     2 NA   
#> 
#> # Use as.data.table()/as.data.frame()/as_tibble() to access results

vars <- "y"
dt %>% drop_na(x, any_of(vars))
#> Source: local data table [1 x 2]
#> Call:   na.omit(`_DT7`, cols = c("x", "y"))
#> 
#>       x y    
#>   <dbl> <chr>
#> 1     1 a    
#> 
#> # Use as.data.table()/as.data.frame()/as_tibble() to access results