假设我有一个数据框架和范畴值,下面的条件或语句是true的,下面的条件或语句是true的~值是有序的: condition语句= a>b>d>c>0>z>y>x>w>q>r>n>m>t
df<- data.frame(ID = c(1,2,3),
measure1 = c('a', 'd', 'q'),
measure2 =c('c', '0', 'n'),
measure3 = c('z', 'r' ,'t'))我想要创建列measure4,根据该语句,输入是来自列的观察的最高值。在这里,measure4将分别是ID 1,2,3的c('a','d','q')。
发布于 2021-06-20 01:40:28
你可以用ordered -
library(dplyr)
order_set <- c("t", "m", "n", "r", "q", "w", "x", "y", "z", "0", "c", "d", "b", "a")
df %>%
mutate(across(starts_with('measure'), ordered, order_set)) %>%
mutate(measure4 = do.call(pmax, select(., starts_with('measure'))))
# ID measure1 measure2 measure3 measure4
#1 1 a c z a
#2 2 d 0 r d
#3 3 q n t qhttps://stackoverflow.com/questions/68051815
复制相似问题