r-help Forum I'm using the dplyr:: summarize_all(funs(sum)) function and am receiving a warning message that the `funs()` is deprecated as of dplyr 0.8.0. Ok what should I be using to summarize all columns by sum? Jeff [[alternative HTML version deleted]]
Hello, Any of the two will do, the first is now preferred. library(dplyr) mtcars %>% summarise(across(everything(), sum)) mtcars %>% summarise_all(sum) # no need for `funs()` Hope this helps, Rui Barradas ?s 18:29 de 01/10/20, Jeff Reichman escreveu:> r-help Forum > > > > I'm using the dplyr:: summarize_all(funs(sum)) function and am receiving a > warning message that the `funs()` is deprecated as of dplyr 0.8.0. Ok what > should I be using to summarize all columns by sum? > > > > Jeff > > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >
The warning gives some suggestions. E.g., replace funs(sum,prod) with list(sum=sum,prod=prod). % R CMD Rscript -e 'library(dplyr,warn.conflicts=FALSE); data.frame(X=1:3,Y=c(11,13,17)) %>% summarize_all(funs(sum,prod))' X_sum Y_sum X_prod Y_prod 1 6 41 6 2431 Warning message: `funs()` is deprecated as of dplyr 0.8.0. Please use a list of either functions or lambdas: # Simple named list: list(mean = mean, median = median) # Auto named with `tibble::lst()`: tibble::lst(mean, median) # Using lambdas list(~ mean(., trim = .2), ~ median(., na.rm = TRUE)) This warning is displayed once every 8 hours. Call `lifecycle::last_warnings()` to see where this warning was generated. % R CMD Rscript -e 'library(dplyr,warn.conflicts=FALSE); data.frame(X=1:3,Y=c(11,13,17)) %>% summarize_all(list(sum=sum,prod=prod))' X_sum Y_sum X_prod Y_prod 1 6 41 6 2431 On Thu, Oct 1, 2020 at 10:29 AM Jeff Reichman <reichmanj at sbcglobal.net> wrote:> r-help Forum > > > > I'm using the dplyr:: summarize_all(funs(sum)) function and am receiving a > warning message that the `funs()` is deprecated as of dplyr 0.8.0. Ok what > should I be using to summarize all columns by sum? > > > > Jeff > > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >[[alternative HTML version deleted]]
Thanks Rui -----Original Message----- From: Rui Barradas <ruipbarradas at sapo.pt> Sent: Thursday, October 1, 2020 1:49 PM To: reichmanj at sbcglobal.net; r-help at r-project.org Subject: Re: [R] summarize_all Function Hello, Any of the two will do, the first is now preferred. library(dplyr) mtcars %>% summarise(across(everything(), sum)) mtcars %>% summarise_all(sum) # no need for `funs()` Hope this helps, Rui Barradas ?s 18:29 de 01/10/20, Jeff Reichman escreveu:> r-help Forum > > > > I'm using the dplyr:: summarize_all(funs(sum)) function and am > receiving a warning message that the `funs()` is deprecated as of > dplyr 0.8.0. Ok what should I be using to summarize all columns by sum? > > > > Jeff > > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >
Thanks Bill ? got it
From: Bill Dunlap <williamwdunlap at gmail.com>
Sent: Thursday, October 1, 2020 1:56 PM
To: reichmanj at sbcglobal.net
Cc: r-help at r-project.org
Subject: Re: [R] summarize_all Function
The warning gives some suggestions. E.g., replace funs(sum,prod) with
list(sum=sum,prod=prod).
% R CMD Rscript -e 'library(dplyr,warn.conflicts=FALSE);
data.frame(X=1:3,Y=c(11,13,17)) %>% summarize_all(funs(sum,prod))'
X_sum Y_sum X_prod Y_prod
1 6 41 6 2431
Warning message:
`funs()` is deprecated as of dplyr 0.8.0.
Please use a list of either functions or lambdas:
# Simple named list:
list(mean = mean, median = median)
# Auto named with `tibble::lst()`:
tibble::lst(mean, median)
# Using lambdas
list(~ mean(., trim = .2), ~ median(., na.rm = TRUE))
This warning is displayed once every 8 hours.
Call `lifecycle::last_warnings()` to see where this warning was generated.
% R CMD Rscript -e 'library(dplyr,warn.conflicts=FALSE);
data.frame(X=1:3,Y=c(11,13,17)) %>%
summarize_all(list(sum=sum,prod=prod))'
X_sum Y_sum X_prod Y_prod
1 6 41 6 2431
On Thu, Oct 1, 2020 at 10:29 AM Jeff Reichman <reichmanj at sbcglobal.net
<mailto:reichmanj at sbcglobal.net> > wrote:
r-help Forum
I'm using the dplyr:: summarize_all(funs(sum)) function and am receiving a
warning message that the `funs()` is deprecated as of dplyr 0.8.0. Ok what
should I be using to summarize all columns by sum?
Jeff
[[alternative HTML version deleted]]
______________________________________________
R-help at r-project.org <mailto:R-help at r-project.org> mailing list --
To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
[[alternative HTML version deleted]]