Turns implicit missing values into explicit missing values. This is a method
for the tidyr::complete()
generic.
complete.tbl_lazy(data, ..., fill = list())
data | A lazy data frame backed by a database query. |
---|---|
... | Specification of columns to expand. See tidyr::expand for more details. |
fill | A named list that for each variable supplies a single value to use instead of NA for missing combinations. |
Another tbl_lazy
. Use show_query()
to see the generated
query, and use collect()
to execute the query
and return data to R.
if (require("tidyr", quietly = TRUE)) { df <- memdb_frame( group = c(1:2, 1), item_id = c(1:2, 2), item_name = c("a", "b", "b"), value1 = 1:3, value2 = 4:6 ) df %>% complete(group, nesting(item_id, item_name)) # You can also choose to fill in missing values df %>% complete(group, nesting(item_id, item_name), fill = list(value1 = 0)) }#> # Source: lazy query [?? x 5] #> # Database: sqlite 3.34.1 [:memory:] #> group item_id item_name value1 value2 #> <dbl> <dbl> <chr> <dbl> <int> #> 1 1 1 a 1 4 #> 2 1 2 b 3 6 #> 3 2 1 a 0 NA #> 4 2 2 b 2 5