r - 在 tidyr::complete 中使用字符向量指定嵌套列

Question

如何在 tidyr::complete 函数中定义要用于嵌套的列？

one_of或as.name不工作。

library(dplyr, warn.conflicts = FALSE)
df <- tibble(
  group = c(1:2, 1),
  item_id = c(1:2, 2),
  item_name = c("a", "b", "b"),
  value1 = 1:3,
  value2 = 4:6
)
char_vec <- c("item_id", "item_name")
df %>% complete(group, nesting(char_vec))

Error: `by` can't contain join column `char_vec` which is missing from RHS
Run `rlang::last_error()` to see where the error occurred.

标签： rdplyrnestedtidyr

Answer 1

dplyr 1.06 版的最新解决方案是!!!syms()：

library(dplyr)
df %>%
    complete(group, nesting(!!!syms(char_vec)))