Applying a function to every row of a table using dplyr?

by

As of dplyr 0.2 (I think) rowwise() is implemented, so the answer to this problem becomes:

iris %>% 
  rowwise() %>% 
  mutate(Max.Len= max(Sepal.Length,Petal.Length))

Non rowwise alternative

Five years (!) later this answer still gets a lot of traffic. Since it was given, rowwise is increasingly not recommended, although lots of people seem to find it intuitive. Do yourself a favour and go through Jenny Bryan’s Row-oriented workflows in R with the tidyverse material to get a good handle on this topic.

The most straightforward way I have found is based on one of Hadley’s examples using pmap:

iris %>% 
  mutate(Max.Len= purrr::pmap_dbl(list(Sepal.Length, Petal.Length), max))

Using this approach, you can give an arbitrary number of arguments to the function (.f) inside pmap.

pmap is a good conceptual approach because it reflects the fact that when you’re doing row wise operations you’re actually working with tuples from a list of vectors (the columns in a dataframe).

More Related Contents:

  1. Why does summarize or mutate not work with group_by when I load `plyr` after `dplyr`?
  2. How to select the rows with maximum values in each group with dplyr? [duplicate]
  3. How to create a lag variable within each group?
  4. Why are my dplyr group_by & summarize not working properly? (name-collision with plyr)
  5. Unique rows, considering two columns, in R, without order
  6. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  7. dplyr: “Error in n(): function should not be called directly”
  8. Count number of rows by group using dplyr
  9. How to strsplit different number of strings in certain column by do function
  10. Change value of variable with dplyr
  11. Use variable names in functions of dplyr
  12. Create new variables with mutate_at while keeping the original ones
  13. How to interpret dplyr message `summarise()` regrouping output by ‘x’ (override with `.groups` argument)?
  14. Finding percentage in a sub-group using group_by and summarise
  15. Using spread with duplicate identifiers for rows
  16. filter for complete cases in data.frame using dplyr (case-wise deletion)
  17. dplyr – using column names as function arguments
  18. dplyr::group_by_ with character string input of several variable names
  19. How to parametrize function calls in dplyr 0.7?
  20. How to do range grouping on a column using dplyr?
  21. Split Data Frame into Rows of Fixed Size
  22. Arranging rows in custom order using dplyr
  23. R: How to filter/subset a sequence of dates
  24. Get first and last values per group – dplyr group_by with last() and first()
  25. How does one stop using rowwise in dplyr?
  26. grouped operations that result in length not equal to 1 or length of group in dplyr
  27. Chain arithmetic operators in dplyr with %>% pipe
  28. dplyr summarize with subtotals
  29. How to find difference between values in two rows in an R dataframe using dplyr
  30. Unlisting columns by groups

Leave a Comment