Replace NAs with specified values
This is a method for the tidyr::replace_na()
generic.
replace_na.tbl_lazy(data, replace = list(), ...)
data |
A pair of lazy data frame backed by database queries. |
replace |
A named list of values, with one value for each column that has NA values to be replaced. |
... |
Unused; included for compatibility with generic. |
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(x = c(1, 2, NA), y = c("a", NA, "b")) df %>% replace_na(list(x = 0, y = "unknown")) }
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.