I am struggling to exclude columns from the col parameter in pivot_longer.
Is this not possible?
E.g. let's say I want to take all columns which have "wk" in their name, except "wk2".
cols = vars(starts_with("wk"), -wk2),
names_to = "week",
names_prefix = "wk",
values_to = "rank",
values_drop_na = TRUE
vars(starts_with("wk"), -wk2) must evaluate to column positions or names, not a list