[R] tidyverse: grouped summaries (with summarize) [RESOLVED]
Rich Shepard
r@hep@rd @end|ng |rom @pp|-eco@y@@com
Tue Sep 14 01:04:28 CEST 2021
On Mon, 13 Sep 2021, Avi Gross via R-help wrote:
> As Eric has pointed out, perhaps Rich is not thinking pipelined. Summarize() takes a first argument as:
> summarise(.data=whatever, ...)
>
> But in a pipeline, you OMIT the first argument and let the pipeline supply an argument silently.
Avi,
Thank you. I read your message carefully and re-read the example on the
bottom of page 60 and top of page 61. Then changed the command to:
disc_by_month = disc %>%
group_by(year, month) %>%
summarize(vol = mean(cfs, na.rm = TRUE))
And, the script now returns what I need:
> disc_by_month
# A tibble: 66 × 3
# Groups: year [7]
year month vol
<int> <int> <dbl>
1 2016 3 221840.
2 2016 4 288589.
3 2016 5 255164.
4 2016 6 205371.
5 2016 7 167252.
6 2016 8 140465.
7 2016 9 97779.
8 2016 10 135482.
9 2016 11 166808.
10 2016 12 165787.
I missed the beginning of the command where the resulting dataframe needs to
be named first.
This clarifies my understanding and I appreciate your and Eric's help.
Regards,
Rich
More information about the R-help
mailing list