Find the most frequent value by row

by

Something like : 

apply(df,1,function(x) names(which.max(table(x))))
[1] "red"    "yellow" "green"

In case there is a tie, which.max takes the first max value. From the
which.max help page :

Determines the location, i.e., index of the (first)
minimum or maximum of a numeric vector.

Ex : 

var4 <- c("yellow","green","yellow")
df <- data.frame(cbind(id, var1, var2, var3, var4))

> df
  id   var1   var2   var3   var4
1  1    red    red yellow yellow
2  2 yellow yellow orange  green
3  3  green  green  green yellow

apply(df,1,function(x) names(which.max(table(x))))
[1] "red"    "yellow" "green"

More Related Contents:

  1. Count number of rows per group and add result to original data frame
  2. Counting the number of elements with the values of x in a vector
  3. Add count of unique / distinct values by group to the original data
  4. Include levels of zero count in result of table()
  5. Count number of occurences for each unique value
  6. Create counter within consecutive runs of values
  7. How can I count runs in a sequence?
  8. Count non-NA values by group [duplicate]
  9. Count number of rows by group using dplyr
  10. How to count the frequency of a string for each row in R
  11. Extend contigency table with proportions (percentages)
  12. Why is the terminology of labels and levels in factors so weird?
  13. Find the n most common values in a vector [duplicate]
  14. Cumulative count of each value [duplicate]
  15. Tidyr how to spread into count of occurrence [duplicate]
  16. Count number of columns by a condition (>) for each row
  17. Count unique values for every column
  18. Remove unused factor levels from a ggplot bar plot
  19. How can I count the number of NAs per group?
  20. Linear Regression and group by in R
  21. How to assign from a function which returns more than one value?
  22. Increment by 1 for every change in column
  23. Usage of `…` (three-dots or dot-dot-dot) in functions [duplicate]
  24. combining two data frames of different lengths [closed]
  25. Mean of a column in a data frame, given the column’s name
  26. How to convert character of percentage into numeric in R
  27. is it possible to redirect console output to a variable?
  28. Using column names as function arguments
  29. Counting non NAs in a data frame; getting answer as a vector
  30. how to debug “factor has new levels” error for linear model and prediction [duplicate]

Leave a Comment