R语言:group_by, summarise, arrange, slice
生成数据:
library(dplyr)
set.seed(1)
df <- expand.grid(list(A = 1:5, B = 1:5, C = 1:5))
df$value <- runif(nrow(df))
情况 1:group_by + summarise
df %>% group_by(A, B) %>% summarise(max = max(value))
情况 2:group_by + arrange
result <- df %>% group_by(A, B) %>% filter(value == max(value)) %>% arrange(A,B,C)
情况 3:group_by + top_n
df %>% group_by(A, B) %>% top_n(n=1)
情况 4:group_by + slice
df %>% group_by(A,B) %>% slice(which.max(value))
本文来自博客园,作者:橙子牛奶糖(陈文燕),转载请注明原文链接:https://www.cnblogs.com/chenwenyan/p/16164272.html