如何在R中的一个向量中累积添加值 [英] how to cumulatively add values in one vector in R
问题描述
我有一个看起来像这样的数据集
I have a data set that looks like this
id name year job job2
1 Jane 1980 Worker 0
1 Jane 1981 Manager 1
1 Jane 1982 Manager 1
1 Jane 1983 Manager 1
1 Jane 1984 Manager 1
1 Jane 1985 Manager 1
1 Jane 1986 Boss 0
1 Jane 1987 Boss 0
2 Bob 1985 Worker 0
2 Bob 1986 Worker 0
2 Bob 1987 Manager 1
2 Bob 1988 Boss 0
2 Bob 1989 Boss 0
2 Bob 1990 Boss 0
2 Bob 1991 Boss 0
2 Bob 1992 Boss 0
这里,job2
表示一个虚拟变量,表示一个人在那一年是否是Manager
.我想对这个数据集做两件事:第一,我只想保留这个人第一次成为Boss
时的那一行.其次,我想查看一个人担任 Manager
的累计年数,并将此信息存储在变量 cumu_job2
中.因此我想要:
Here, job2
denotes a dummy variable indicating whether a person was a Manager
during that year or not. I want to do two things to this data set: first, I only want to preserve the row when the person became Boss
for the first time. Second, I would like to see cumulative years a person worked as a Manager
and store this information in the variable cumu_job2
. Thus I would like to have:
id name year job job2 cumu_job2
1 Jane 1980 Worker 0 0
1 Jane 1981 Manager 1 1
1 Jane 1982 Manager 1 2
1 Jane 1983 Manager 1 3
1 Jane 1984 Manager 1 4
1 Jane 1985 Manager 1 5
1 Jane 1986 Boss 0 0
2 Bob 1985 Worker 0 0
2 Bob 1986 Worker 0 0
2 Bob 1987 Manager 1 1
2 Bob 1988 Boss 0 0
我已经更改了我的示例并包含了 Worker 位置,因为这更多地反映了我想要对原始数据集做的事情.此线程中的答案仅在数据集中只有 Managers 和 Boss 时才有效-因此,任何有关使这项工作的建议都很棒.我将不胜感激!!
I have changed my examples and included the Worker position because this reflects more what I want to do with the original data set. The answers in this thread only works when there are only Managers and Boss in the data set - so any suggestions for making this work would be great. I'll be very much grateful!!
推荐答案
这里是针对同一问题的简洁 dplyr
解决方案.
Here is the succinct dplyr
solution for the same problem.
注意:在读入数据时确保 stringsAsFactors = FALSE
.
NOTE: Make sure that stringsAsFactors = FALSE
while reading in the data.
library(dplyr)
dat %>%
group_by(name, job) %>%
filter(job != "Boss" | year == min(year)) %>%
mutate(cumu_job2 = cumsum(job2))
输出:
id name year job job2 cumu_job2
1 1 Jane 1980 Worker 0 0
2 1 Jane 1981 Manager 1 1
3 1 Jane 1982 Manager 1 2
4 1 Jane 1983 Manager 1 3
5 1 Jane 1984 Manager 1 4
6 1 Jane 1985 Manager 1 5
7 1 Jane 1986 Boss 0 0
8 2 Bob 1985 Worker 0 0
9 2 Bob 1986 Worker 0 0
10 2 Bob 1987 Manager 1 1
11 2 Bob 1988 Boss 0 0
说明
- 获取数据集
- 按名称和工作分组
- 根据条件过滤每个组
- 添加
cumu_job2
列.
这篇关于如何在R中的一个向量中累积添加值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!