Add a “rank” column to a data frame

by

There is a rank function to help you with that:

transform(df, 
          year.rank = ave(count, year, 
                          FUN = function(x) rank(-x, ties.method = "first")))
  item year count year.rank
1    a 2010     1         3
2    b 2010     4         2
3    c 2010     6         1
4    a 2011     3         2
5    b 2011     8         1
6    c 2011     3         3
7    a 2012     5         3
8    b 2012     7         2
9    c 2012     9         1

More Related Contents:

  1. Several questions on ggplot2 [closed]
  2. object I am trying to take the mean of is not found
  3. How to create a consecutive group number
  4. Explicitly calling return in a function or not
  5. Consistent width for geom_bar in the event of missing data
  6. Importing Excel files into R, xlsx or xls
  7. Removing empty rows of a data file in R
  8. Why do some Unicode characters display in matrices, but not data frames in R?
  9. Group integer vector into consecutive runs
  10. ggplot2 heatmaps: using different gradients for categories
  11. How to generate distributions given, mean, SD, skew and kurtosis in R?
  12. Different legends and fill colours for facetted ggplot?
  13. Make Frequency Histogram for Factor Variables
  14. How can I make a discontinuous axis in R with ggplot2?
  15. Can dplyr join on multiple columns or composite key?
  16. Subset xts object by time of day
  17. Select rows of a matrix that meet a condition
  18. How to make variable bar widths in ggplot2 not overlap or gap
  19. How to group by two columns in R
  20. Plot inside a plot
  21. Add an image to a table-like output in R
  22. How to use empty space produced by facet_wrap?
  23. Drawing a barchart to compare two sets of data using ggplot2 package?
  24. Plotting multiple graphs in R [closed]
  25. Changing format of some axis labels in ggplot2 according to condition [duplicate]
  26. ggplot2 – using two different color scales for overlayed plots
  27. Extract digit from numeric in r
  28. What does the period mean when used with ~ (in a formula)?
  29. heatmap-like plot, but for categorical variables
  30. data.table: anonymous function in j

Leave a Comment