Summarizing a dataframe in R with multiple functions in place?

Question

I am new to R and trying to summarize a dataframe with multiple functions and I would like the result to appear in the same column, rather than in separated columns for each function. For example, my data set looks something like this

data =  
  A  B
  ----
  1  2
  2  2
  3  2
  4  2

And I call summarize_all(data, c(min, max)) the dataframe becomes

a_fn1 b_fn1 a_fn2 b_fn2
    1     2     4     2

How can I make it so that the result of the summarize_all becomes this:

  A  B
  ----
  1  2
  4  2

Thanks

Karthik S · Accepted Answer · 2021-07-21 07:12:49Z

1

Does this work:

library(dplyr)
bind_rows(apply(data,2,min),apply(data,2,max))
# A tibble: 2 x 2
      A     B
  <dbl> <dbl>
1     1     2
2     4     2

answered Jul 21, 2021 at 7:12

Karthik S

11.6k2 gold badges15 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Anonymous Over a year ago

This does work! And how could I use this in a dplyr pipe?

Karthik S Over a year ago

@Anonymous, you can try apply(data,2,min) %>% bind_rows(apply(data,2,max))

akrun · Accepted Answer · 2021-07-21 18:28:57Z

1

Here is an option with transpose

library(dplyr)
library(tidyr)
pivot_longer(df1, cols = everything()) %>% 
    group_by(name) %>% 
    summarise(min = min(value), max = max(value)) %>% 
    data.table::transpose(., make.names = 'name')
  A B
1 1 2
2 4 2

data

df1 <- structure(list(A = 1:4, B = c(2L, 2L, 2L, 2L)),
 class = "data.frame", row.names = c(NA, 
-4L))

answered Jul 21, 2021 at 18:28

akrun

891k38 gold badges590 silver badges700 bronze badges

Collectives™ on Stack Overflow

Summarizing a dataframe in R with multiple functions in place?

2 Answers 2

2 Comments

data

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

data

Comments

Your Answer

Sign up or log in

Post as a guest

Related