Return the column names in a dataframe that contain duplicate values of another column.
duplicated_cols(data)
library(tidyverse) test_data <- tibble( Group = sample(c("Apple", "Pear"), size = 10, replace = TRUE), A = sample(c(NA_integer_, 1:3), size = 10, replace = TRUE), B = sample(c(NA_integer_, 4:6), size = 10, replace = TRUE), C = sample(c(NA_real_, seq(from = 6.01, to = 6.09, by = 0.01)), size = 10, replace = TRUE), D = sample(c(NA, TRUE, FALSE), size = 10, replace = TRUE) ) %>% dplyr::mutate(E = B) duplicated_cols(test_data)#> Error in cols_to_list(data = data): could not find function "cols_to_list"test_data %>% select(-all_of(duplicated_cols(test_data)))#> Error: could not find function "cols_to_list"