根据名称中包含模式的列在dplyr中构建rowSum [英] Build rowSums in dplyr based on columns containing pattern in their names

问题描述

我的数据框看起来像这样

My data frame looks something like this

USER OBSERVATION COUNT.1 COUNT.2 COUNT.3
A    1           0       1       1
A    2           1       1       2
A    3           3       0       0

我要使用dplyr构建一列，以对每一行的计数变量的值求和，并根据其名称选择计数变量.

With dplyr I want to build a columns that sums the values of the count-variables for each row, selecting the count-variables based on their name.

USER OBSERVATION COUNT.1 COUNT.2 COUNT.3 SUM
A    1           0       1       1       2
A    2           1       1       2       4
A    3           3       0       0       3

我该怎么做?

推荐答案

当您要求使用 dplyr 解决方案时，您可以执行以下操作:

As you asked for a dplyr solution, you can do:

library(dplyr)

df %>% 
  mutate(SUM = rowSums(select(., starts_with("COUNT"))))

  USER OBSERVATION COUNT.1 COUNT.2 COUNT.3 SUM
1    A           1       0       1       1   2
2    A           2       1       1       2   4
3    A           3       3       0       0   3

这篇关于根据名称中包含模式的列在dplyr中构建rowSum的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！