Complete a SQL table with missing combinations of data
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))
}Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.