如何根据R数据框每行数据返回有效数值对应的起始、结束列取值?
R实现每行取值为1的列起止计算方法
我们需要对数据框逐行统计取值为1的列,输出这些列的最小(起始)、最大(结束)列名,以下是两种可直接运行的实现方案。
示例数据构造
df <- structure(list(ID = c(1, 2), A1 = c(1, 1), A2 = c(1, 1), A3 = c(0, 1), A4 = c(0, 1), A5 = c(0, 1)), class = c("spec_tbl_df", "tbl_df", "tbl", "data.frame"), row.names = c(NA, -2L), spec = structure(list(cols = list(ID = structure(list(), class = c("collector_double", "collector")), A1 = structure(list(), class = c("collector_double", "collector")), A2 = structure(list(), class = c("collector_double", "collector")), A3 = structure(list(), class = c("collector_double", "collector")), A4 = structure(list(), class = c("collector_double", "collector")), A5 = structure(list(), class = c("collector_double", "collector"))), default = structure(list(), class = c("collector_guess", "collector")), skip = 1L), class = "col_spec"))
实现方案1:tidyverse 行操作(可读性高)
需先加载tidyverse包,代码如下:
library(tidyverse) df_result <- df %>% rowwise() %>% mutate( # 提取当前行取值为1的所有A开头列的列名 valid_cols = list(names(.)[c_across(A1:A5) == 1]), start = min(valid_cols), end = max(valid_cols) ) %>% ungroup() %>% # 按需保留输出列 select(ID, start, end)
运行后输出结果与预期一致:
| ID | start | end |
|---|---|---|
| 1 | A1 | A2 |
| 2 | A1 | A5 |
实现方案2:Base R 实现(无需额外安装包)
# 提取需要计算的A开头列 calc_cols <- grep("^A\\d+", names(df), value = TRUE) # 逐行计算起止列名 result <- cbind( df["ID"], t(apply(df[calc_cols], 1, function(row_data) { valid_cols <- names(row_data)[row_data == 1] c(start = min(valid_cols), end = max(valid_cols)) })) )
补充说明
如果你的数据中存在1的区域不连续的情况(如A1=1、A3=1,中间A2=0),上述逻辑会直接取最左和最右的1对应列名;如果需要拆分出多个连续段的起止值,可以配合rle()函数修改判断逻辑即可。
内容的提问来源于stack exchange,提问作者user11418708
相关产品推荐
相关产品推荐

