R语言基于三列多判定规则生成数据框一致性汇总新列的实现方法
R语言多列规则判定生成衍生列实现方案
原始示例数据构造
df <- data.frame( screening = c("XXX/01", "XXX/03", "XXX/08", "XXX/13", "XXX/09", "XXX/04"), consistancyAPP = c("Missing", "0-49% target", "Missing", "Missing", "Missing", "0-49% target"), consistancyVAF = c("50-100% target", "0-49% target", "Missing", "Missing", "0-49% target", "0-49% target"), consistancyCRF = c("50-100% target", "0-49% target", "50-100% target", "Missing", "50-100% target", "50-100% target") )
衍生列判定规则
- 三列取值完全一致时,新列取该一致值
- 三列中有两列值为
Missing时,新列取剩余第三列的非缺失值 - 三列中有两列取值一致(非缺失)时,新列取该一致值
- 三列取值全不相同时,新列取更低等级的
0-49% target
实现代码
基础R实现(无第三方依赖)
通过逐行遍历的方式适配规则,兼容性最强:
df$consistancyOverall <- apply( X = df[, c("consistancyAPP", "consistancyVAF", "consistancyCRF")], MARGIN = 1, FUN = function(row_vals) { # 统计当前行各取值的出现频次 val_freq <- table(row_vals) # 统计当前行Missing的数量 miss_count <- sum(row_vals == "Missing") # 规则2:存在2个Missing时取剩余非缺失值 if (miss_count == 2) return(row_vals[row_vals != "Missing"]) # 规则1/3:存在出现次数≥2的取值时,取该重复值 if (max(val_freq) >= 2) return(names(which.max(val_freq))) # 规则4:三个取值完全不同时取低等级值 return("0-49% target") } )
tidyverse实现(适配数据处理流水线)
可读性更强,适合批量处理场景:
# 需提前安装并加载dplyr包 library(dplyr) df <- df %>% rowwise() %>% mutate( consistancyOverall = { # 提取当前行三个判定列的取值 col_vals <- c(consistancyAPP, consistancyVAF, consistancyCRF) val_freq <- table(col_vals) miss_count <- sum(col_vals == "Missing") case_when( miss_count == 2 ~ col_vals[col_vals != "Missing"], max(val_freq) >= 2 ~ names(which.max(val_freq)), TRUE ~ "0-49% target" ) } ) %>% ungroup()
输出结果验证
运行上述任意一种代码后,执行print(df)可得到如下结果:
screening consistancyAPP consistancyVAF consistancyCRF consistancyOverall 1 XXX/01 Missing 50-100% target 50-100% target 50-100% target 2 XXX/03 0-49% target 0-49% target 0-49% target 0-49% target 3 XXX/08 Missing Missing 50-100% target 50-100% target 4 XXX/13 Missing Missing Missing Missing 5 XXX/09 Missing 0-49% target 50-100% target 0-49% target 6 XXX/04 0-49% target 0-49% target 50-100% target 0-49% target
注:提供的期望输出中第二行
screening字段为笔误,实际原始数据对应取值为XXX/03,代码运行逻辑与规则完全匹配。
内容的提问来源于stack exchange,提问作者Annie Wright
相关产品推荐
相关产品推荐

