python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - summarize

Find mean of counts within groups

I have a dataframe that looks like this: library(tidyverse) x <- tibble( batch = rep(c(1,2), each=10), exp_id = c(rep('a',3),rep('b',2),rep('c',5),rep('d',6),rep('e',4)) ) I can run the...
test-img

Adam_G

r

dataframe

dplyr

summarize

Votes: 0

Answers: 2

Latest Answer

library(dplyr) group_by(x, batch) %>% summarize(avg_exp = mean(table(exp_id))) # # A tibble: 2 x 2 # batch avg_exp # <dbl> <dbl> # 1 1 3.33 # 2 2 5
test-img

r2evans

Summarize(mean) across records keeping the variables that don&#39;t change

I have a dataframe that contains records from various devices that measure parameters like temperature and humidity, I'm trying to group the records in intervals of 10 mins. Example in question: id ...
test-img

sandrodand

r

dataframe

mean

summarize

Votes: 0

Answers: 1

Latest Answer

Do you mean this: just add room or whatever to the group_by line: df %>% mutate(datetime = as.POSIXct(datetime)) %>% # This you may not need group_by(id, datetime = cut(datetime, "10 m...
test-img

TarJae

Using dot syntax in dplyr::across

This question is related to this one; it still hasn't been answered. I am trying to calculate summary statistics across multiple columns. The function dplyr::summarise_each has been deprecated so I ge...
test-img

gm007

r

dplyr

summarize

Votes: 0

Answers: 0

What&#39;s the easiest way to summarize by group and for the whole sample?

Suppose I have data that looks like this: Date time price minute FOMC Daily.Return <date> <time> <dbl> <dbl> <fct> <dbl> 1 2005-01-0...
test-img

Raul Guarini Riva

r

dplyr

tidyverse

grouping

summarize

Votes: 0

Answers: 2

Latest Answer

One option is to just row bind a duplicate of the whole data where you mutate() the FOMC variable to "ALL" so that you end up with that as a separate group when you group_by() and summarise(...
test-img

Dan Adams

Posts

Questions

Blogs

Jobs