我早些时候发布了一个关于按组求和值的question,不包括NA或text以下的值。这个问题类似,但我不想按组进行求和,而是删除按id分组的特定文本(本例中为end)下的所有值(本例中为name)。例如,
我想从这里出发:
#Starting df
name = c("tom", "tom", "tom", "chris", "chris", "chris","chris", "jen", "jen", "jen","jen","jen")
value = c(2,10,"end",45,"end",13,20,6,"end",13,3,5)
start_df = data.frame(name,value) 到这里:
#Ending df
name = c("tom", "tom", "tom", "chris", "chris","jen", "jen")
value = c(2,10,"end",45,"end",6,"end")
end_df = data.frame(name,value) 除了end,还有其他文本,所以我希望找到一个解决方案,允许我指定文本。对我怎么做有什么想法吗?谢谢R社区。
发布于 2017-11-12 05:04:58
使用dplyr和tidyr的解决方案。start_df2是最后的输出。
library(dplyr)
library(tidyr)
start_df2 <- start_df %>%
mutate(ID = 1:n()) %>%
group_by(name) %>%
mutate(flag = ifelse(value %in% "end", 1, NA)) %>%
fill(flag, .direction = "up") %>%
filter(!is.na(flag)) %>%
ungroup() %>%
arrange(ID) %>%
select(-ID, -flag)
start_df2
# # A tibble: 7 x 2
# name value
# <fctr> <fctr>
# 1 tom 2
# 2 tom 10
# 3 tom end
# 4 chris 45
# 5 chris end
# 6 jen 6
# 7 jen end发布于 2017-11-12 05:08:00
另一个基于dplyr的解决方案:
start_df %>%
group_by(name) %>%
mutate(rownum = row_number(), keeprows = (value=='end') * rownum) %>%
filter(rownum <= max(keeprows)) %>%
select(-keeprows)发布于 2017-11-12 06:39:50
您可以使用slice来获取它,即
library(dplyr)
start_df %>%
group_by(name) %>%
slice(1L:which(value == 'end'))这给了,
A tibble: 7x2#组:名称3名称值1 chris 45 2 chris end 3 jen 6 4 jen end 5 tom 2 6 tom 10 7 tom end
https://stackoverflow.com/questions/47245580
复制相似问题