dplyr mutate rowSums calculations or custom functions

by

This is more of a workaround but could be used

iris %>% mutate(sumVar = rowSums(.[1:4]))

As written in comments, you can also use a select inside of mutate to get the columns you want to sum up, for example

iris %>% 
  mutate(sumVar = rowSums(select(., contains("Sepal")))) %>% 
  head

or 

iris %>% 
  mutate(sumVar = select(., contains("Sepal")) %>% rowSums()) %>% 
  head

More Related Contents:

  1. data.table vs dplyr: can one do something well the other can’t or does poorly?
  2. Pass a string as variable name in dplyr::filter
  3. Select first and last row from grouped data
  4. Combine Multiple Columns Into Tidy Data [duplicate]
  5. Applying a function to every row of a table using dplyr?
  6. Using functions of multiple columns in a dplyr mutate_at call
  7. Sum across multiple columns with dplyr
  8. dplyr: nonstandard column names (white space, punctuation, starts with numbers)
  9. dplyr filter: Get rows with minimum of variable, but only the first if multiple minima
  10. dplyr mutate/replace several columns on a subset of rows
  11. dplyr: How to use group_by inside a function?
  12. Count non-NA values by group [duplicate]
  13. Concatenate unique strings after groupby in R
  14. ignore NA in dplyr row sum
  15. How to select last N observation from each group in dplyr dataframe?
  16. mutate function is not updating
  17. Switch displayed traces via plotly dropdown menu
  18. Create column with grouped values based on another column
  19. Rename multiple columns given character vectors of column names and replacement [duplicate]
  20. Error: could not find function “%>%”
  21. dplyr / R cumulative sum with reset
  22. dplyr change many data types
  23. How to perform multiple left joins using dplyr in R [duplicate]
  24. Create a group index for values connected directly and indirectly
  25. Error with select function from dplyr
  26. dplyr replacing na values in a column based on multiple conditions
  27. How to replace empty string with NA in R dataframe?
  28. Adding prefix or suffix to most data.frame variable names in piped R workflow
  29. Add margin row totals in dplyr chain
  30. Why does as_tibble() round floats to the nearest integer?

Leave a Comment