r - 如何只保留唯一行而忽略一列？

Question

如果我有这些数据:

df1 <- data.frame(name = c("apple", "apple", "apple", "orange", "orange"),
       ID = c(1, 2, 3, 4, 5),
       is_fruit = c("yes", "yes", "yes", "yes", "yes"))

我只想保留唯一的行，但忽略 ID 列，这样输出看起来像这样:

df2 <- data.frame(name = c("apple", "orange"),
       ID = c(1, 4),
       is_fruit = c("yes", "yes"))

df2
#    name ID is_fruit
#1  apple  1      yes
#2 orange  4      yes

我该怎么做，最好使用 dplyr？

Answer 1

你可以使用distinct函数；通过显式指定变量，您可以保留仅基于这些列的唯一行；还有 ?distinct:

If there are multiple rows for a given combination of inputs, only the first row will be preserved

distinct(df1, name, is_fruit, .keep_all = T)
#    name ID is_fruit
#1  apple  1      yes
#2 orange  4      yes