如何在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
相关产品推荐
相关产品推荐

