我有两列，并且它们之间的数据比较混乱。这两列都是因素。例：
Skill Employment
Skilled A
Unskilled B
12443 Skilled
24233 Skilled
我想要输出：
Skill Employment
Skilled A
Unskilled B
Skilled (Don't care if its blank or has the original values)
Skilled (Don't care if its blank or has the original values)
我试过了：
df %>% mutate(Skill = ifelse(Employment %in% c("Skilled", "Unskilled"), Skill, Employment))
我想我已经接近了，但是我不知道我哪里错了。
您可以grepl用来识别"Skilled"和"Unskilled"。在Employment列之间更改这些值，Skill并将Employment列设置为NA。
inds <- grepl('Skill', df$Employment)
df$Skill[inds] <- df$Employment[inds]
df$Employment[inds] <- NA
df
# Skill Employment
#1 Skilled A
#2 Unskilled B
#3 Skilled <NA>
#4 Skilled <NA>
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句