You need to enable JavaScript to run this app. 如何在R中基于特定行数值筛选数据框的列
优惠活动
大模型
产品
解决方案
定价
更多

如何在R中基于特定行数值筛选数据框的列

R 基于指定行数值筛选列的实现方案

需求描述

现有数据框df1,第一列为基因IDEnsembl_ID,其余列为数值列。需要筛选出Ensembl_ID = "ENSG00000000005"的行对应数值小于-0.1的列,保留数据框所有行,最终排除不符合条件的logFC.5、logFC.9两列。

示例原始数据

df1 <- data.frame(Ensembl_ID = c("ENSG00000000003", "ENSG00000000005", "ENSG00000000419", "ENSG00000000457", "ENSG00000000460", "ENSG00000000938", "ENSG00000000971", "ENSG00000001036", "ENSG00000001084", "ENSG00000001167" ), logFC.1 = c(0.147447019707984, -0.278643924528991, 0.00638502079233481, 0.00248371473862579, 0.0591639590814736, -0.0892578080659792, -0.0139042150604349, 0.15210410748665, -0.0273174541997048, 0.0373813166759115 ), logFC.2 = c(0.14237211045168, -0.153847067952652, 0.00806519294435945, -0.0243298183425441, 0.0639184480028851, -0.0791126460573967, -0.0517704622015086, 0.100033161692714, 0.105136768894399, 0.0509474174745926 ), logFC.3 = c(0.0692402101693023, -0.212626837128185, 0.0665466667502187, 0.0189664498456434, 0.073631371224761, -0.0642014520794086, 0.0115060035255512, 0.104767159584613, 0.140378485980222, 0.0814931176279395), logFC.4 = c(0.175916688982428, -0.0606440302201137, 0.0862627141013101, 0.105179938123113, 0.128866411791584, -0.0988927171791539, 0.128758540724723, 0.0997656895899759, 0.345468063926355, 0.130898388184307), logFC.5 = c(0.144743421921328, 0.247159332221974, 0.0232237466183996, 0.0800788300610377, 0.178887735169961, -0.0592727391427514, -0.0723099661837084, 0.0387715967173523, -0.0607793368610136, 0.110464511693512), logFC.6 = c(0.0848187321362019, -0.299283590551811, 0.0366788808661408, -0.00763280370062748, 0.0145148270035513, -0.0384916970002755, -0.0000335640771631606, 0.0851895375297912, -0.00364050261322463, 0.0602143760128463), logFC.7 = c(0.305256444042024, -0.274308408751318, 0.0977066795857243, -0.0265659018074027, 0.136348613124811, -0.0938364533000299, -0.143634179166262, 0.139913812601005, 0.268708965044232, 0.133427360632365), logFC.8 = c(0.12744808339884, -0.285015311267508, 0.0459140048745496, -0.00976012971218515, 0.13292412700208, -0.184687147498946, -0.0411558715447517, 0.165717944056239, 0.323358546432839, 0.0502386767987279), logFC.9 = c(0.286824598926274, 0.095530985319937, 0.101370835445593, 0.0352336819150421, 0.0573659992830985, -0.0739779010955875, 0.00466993628480923, 0.0486643748696862, 0.0322601740536419, 0.0873158516027886))

可行实现方案

  • 基础R原生实现(无需加载第三方包)
# 定位目标行的索引
target_row <- which(df1$Ensembl_ID == "ENSG00000000005")
# 定义保留列:第一列必须保留,剩余数值列满足目标行数值小于-0.1
keep_cols <- c(TRUE, df1[target_row, -1] < -0.1)
# 提取结果
result <- df1[, keep_cols]
  • tidyverse/dplyr 实现
library(dplyr)
result <- df1 %>% 
  select(
    Ensembl_ID,
    where(~.x[df1$Ensembl_ID == "ENSG00000000005"] < -0.1)
  )
  • data.table 实现(适用于大数据集提速)
library(data.table)
# 转换为data.table格式
setDT(df1)
# 提取目标行的数值列数值
target_vals <- df1[Ensembl_ID == "ENSG00000000005", .SD, .SDcols = !"Ensembl_ID"]
# 筛选符合条件的列名
keep_cols <- c("Ensembl_ID", names(which(target_vals < -0.1)))
# 提取结果
result <- df1[, ..keep_cols]

内容的提问来源于stack exchange,提问作者SUMIT

相关产品推荐
方舟 Agent Plan

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

最近更新时间:2026.10.08 16:09:03