dplyr – using mutate() like rowmeans()

by

You’re looking for

data %>% 
    rowwise() %>% 
    mutate(c=mean(c(a,b)))

#      id     a     b     c
#   (dbl) (dbl) (dbl) (dbl)
# 1   101     1     2   1.5
# 2   102     2     2   2.0
# 3   103     3     2   2.5

or

library(purrr)
data %>% 
    rowwise() %>% 
    mutate(c=lift_vd(mean)(a,b))

More Related Contents:

  1. Gather multiple sets of columns
  2. How to get summary statistics by group
  3. Is there a dplyr equivalent to data.table::rleid?
  4. Replace NA with previous or next value, by group, using dplyr
  5. Filter rows which contain a certain string
  6. Calculate group mean, sum, or other summary stats. and assign column to original data
  7. Rolling mean (moving average) by group/id with dplyr
  8. Programming with dplyr using string as input
  9. Count number of rows by group using dplyr
  10. Pass a vector of variable names to arrange() in dplyr
  11. Efficient way to filter one data frame by ranges in another
  12. R – add column that counts sequentially within groups but repeats for duplicates
  13. Categorize numeric variable with mutate
  14. Means multiple columns by multiple groups [duplicate]
  15. How to use map from purrr with dplyr::mutate to create multiple new columns based on column pairs
  16. Conditional cumsum with reset
  17. How to speed up subset by groups
  18. Use rle to group by runs when using dplyr
  19. Number of significant digits in dplyr summarise
  20. adding default values to item x group pairs that don’t have a value (df %>% spread %>% gather seems strange)
  21. dplyr mutate rowwise max of range of columns
  22. dplyr: lead() and lag() wrong when used with group_by()
  23. Reorder rows using custom order
  24. Spreading a two column data frame with tidyr
  25. R dplyr rowwise mean or min and other methods?
  26. How to replace all NA in a dataframe using tidyr::replace_na? [duplicate]
  27. Run a custom function on a data frame in R, by group
  28. Dealing with spaces and “weird” characters in column names with dplyr::rename()
  29. How to add only missing Dates in Dataframe
  30. Filtering rows in R unexpectedly removes NAs when using subset or dplyr::filter

Leave a Comment