pbmc_small_nested <- pbmc_small_cell_type |> filter(first.labels != "Erythrocytes") |> mutate(cell_class=dplyr::if_else(`first.labels` %in% c("Macrophages", "Monocytes"), "myeloid", "lymphoid")) |> nest(data=-cell_class)## Warning: There were 2 warnings in `mutate()`. ## ...
(db_connection, from = my_table_name) # attempted query tmp = my_table %>% mutate(new_col = case_when(col1 == col2 ~ "a", TRUE ~ "b")) # check SQL code for query show_query(tmp) # compared to tmp = my_table %>% mutate(new_col = ifelse(col1 == col2, "a", "b...