You need to enable JavaScript to run this app. R语言基于三列多判定规则生成数据框一致性汇总新列的实现方法
优惠活动
大模型
产品
解决方案
定价
更多

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

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.10.29 05:15:02