In R, how do I add a max by group? [duplicate]

by

If you redefine x first (the cbind makes both columns factors),

x<-data.frame(group,replicate)

you can use this:

merge(x,aggregate(replicate~group,x,FUN=max),all.x=TRUE,by="group")
   group replicate.x replicate.y
1      A           1           5
2      A           2           5
3      A           3           5
4      A           4           5
5      A           5           5
6      B           1           2
7      B           2           2
8      C           1           3
9      C           2           3
10     C           3           3

More Related Contents:

  1. Finding y-hat in R [closed]
  2. Reshape three column data frame to matrix (“long” to “wide” format) [duplicate]
  3. ggplot2 line chart gives “geom_path: Each group consist of only one observation. Do you need to adjust the group aesthetic?”
  4. How can I match fuzzy match strings from two datasets?
  5. Plot multiple lines in one graph [duplicate]
  6. Remove parentheses and text within from strings in R
  7. Sample random rows within each group in a data.table
  8. Recoding variables with R
  9. Explain ggplot2 warning: “Removed k rows containing missing values”
  10. How to efficiently use Rprof in R?
  11. How to drop columns by name pattern in R?
  12. Angle between two vectors in R
  13. double dots in a ggplot
  14. Specifying column names in a data.frame changes spaces to “.”
  15. Time out an R command via something like try()
  16. Fitting with ggplot2, geom_smooth and nls
  17. Function to split a matrix into sub-matrices in R
  18. Collect All user inputs throughout the Shiny App
  19. How to do range grouping on a column using dplyr?
  20. Select last non-NA value in a row, by row
  21. Change the default colour palette in ggplot
  22. How to label a barplot bar with positive and negative bars with ggplot2
  23. Inheritance in R
  24. Row-wise sort then concatenate across specific columns of data frame
  25. How do I draw gridlines using abline() that are behind the data?
  26. How to get geom_vline to honor facet_wrap?
  27. r random forest error – type of predictors in new data do not match
  28. R ggplot ordering bars within groups
  29. ggplot for loop outputs all the same graph
  30. Data.frame Merge and Selection of values which are common in 2 Data.frames

Leave a Comment