r - 有条件地替换 R 中的值

Question

我有一个关于 R 的问题。我有一个数据集，我想根据彼此相邻的列的值更改其单元格

Data <- tibble(a = 1:5,  
b = c("G","H","I","J","K"),
c = c("G","H","J","I","J"))

我想更改字符。如果 b 和 c 具有相同的字符，则为 NA。

期望的输出

Data <- tibble(a = 1:5,  
    b = c("NA","NA","I","J","K"),
    c = c("NA","NA","J","I","J"))

非常感谢您的提前帮助。

Answer 1

library(data.table)
setDT(Data)[b == c, c("b", "c") := NA]
#    a    b    c
# 1: 1 <NA> <NA>
# 2: 2 <NA> <NA>
# 3: 3    I    J
# 4: 4    J    I
# 5: 5    K    J