python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - summarize

Calculate the median date based on two grouping conditions

I have the following data frame: > head(df) # A tibble: 6 x 6 # Groups: lat, decade [2] lat long date year decade month_day <dbl> <dbl> <date> <chr> &...
test-img

Recology

r

dplyr

group-by

median

summarize

Votes: 0

Answers: 2

Latest Answer

You must convert month_day to numeric to get the median. across is only needed if something is calculated for multiple columns individually e.g. to get median lon and lat using data %>% summarise(a...
test-img

danlooo

R summarize across with multiple functions

I have a data frame where I am grouping by county, and then trying to summarize teh rest of the data using summarise across. Some of the variables I would like to sum across, while other variables I w...
test-img

KLenny

r

summarize

across

Votes: 0

Answers: 1

Latest Answer

As long as the by group variables remain constant we can include multiple across() functions within a single invocation of summarise() to use different functions to summarize subsets of variables in t...
test-img

Len Greski

Aggregate and summarise character object with R

I have a breeding productivity dataset: df1 # Nest.box Obs.type individual.number Clutch Chick.status # 1 Nest1 Egg 1 First NA # 2 Nest1 Egg 2 First NA # 3 Nest1 Egg 3 First NA # 4...
test-img

Andre230

r

tidyr

summarize

Votes: 0

Answers: 4

Latest Answer

Here is a potential solution: library(dplyr) df <- read.table(text = "Nest.box Obs.type individual.number Clutch Chick.status 1 Nest1 Egg 1 First NA 2 Nest1 Egg 2 First NA 3 Nest1 Egg 3 First...
test-img

jared_mamrot

sum of multiple columns using group_by function

I want to calculate the sum in multiple columns with the group_by function. I want to group by the columns Gebied and Datum and calculate the sum in the columns Som van vangtuigen and Som van Aantal. ...
test-img

Pepijn95

r

dplyr

group-by

summarize

Votes: 0

Answers: 3

Latest Answer

You can use across() inside summarise instead of summarise_at. From ?summarize_at we can see that: Scoped verbs (_if, _at, _all) have been superseded by the use of across() in an existing verb. See v...
test-img

benson23

Posts

Questions

Blogs

Jobs