我想要在R数据框中反转多列数值的顺序(使最高的数字变为最低,依此类推),同时保留NA值不变。
以下是我的数据框示例:
my_data <- data.frame (animal = c("fox", "rabbit", "cow", "sheep", "pig", "mole"),
x = c("1", "2", "1", "3", "NA", 'NA'),
y = c('NA','NA','1','3','2','NA'),
z = c('1','2','3','4','NA','5'),
area = c("field","field","farm","farm","farm","farm"))
接下来,我想要实现的是:
my_ideal_data <- data.frame (animal = c("fox", "rabbit", "cow", "sheep", "pig", "mole"),
x = c("3", "2", "3", "1", "NA", 'NA'),
y = c('NA','NA','3','1','2','NA'),
z = c('5','4','3','2','NA','1'),
area = c("field","field","farm","farm","farm","farm"))
“animal”和“area”列保持不变,所有的NAs也保持不变 - 但我需要将x、y和z的值在每个列中以相反的顺序放置。
任何帮助都将不胜感激!
谢谢