Create a ranking variable with dplyr?

by

It sounds like you’re looking for dense_rank from “dplyr” — but applied in a reverse order than what rank normally does.

Try this:

df %>% mutate(rank = dense_rank(desc(score)))
#   name score rank
# 1    A    10    1
# 2    B    10    1
# 3    C     9    2
# 4    D     8    3

More Related Contents:

  1. Use dynamic name for new column/variable in `dplyr`
  2. data.table vs dplyr: can one do something well the other can’t or does poorly?
  3. Extract a dplyr tbl column as a vector
  4. Pass arguments to dplyr functions
  5. dplyr::select function clashes with MASS::select
  6. Sum across multiple columns with dplyr
  7. dplyr: nonstandard column names (white space, punctuation, starts with numbers)
  8. dplyr filter: Get rows with minimum of variable, but only the first if multiple minima
  9. dplyr mutate/replace several columns on a subset of rows
  10. dplyr: How to use group_by inside a function?
  11. Count non-NA values by group [duplicate]
  12. Concatenate unique strings after groupby in R
  13. ignore NA in dplyr row sum
  14. How to select last N observation from each group in dplyr dataframe?
  15. mutate function is not updating
  16. Switch displayed traces via plotly dropdown menu
  17. Use filter in dplyr conditional on an if statement in R
  18. combine two data frames with all posible combinations
  19. dplyr / R cumulative sum with reset
  20. finding close match from data frame 1 in data fame 2
  21. Arranging rows in custom order using dplyr
  22. Get first and last values per group – dplyr group_by with last() and first()
  23. Add a column with count of NAs and Mean
  24. select columns based on multiple strings with dplyr contains()
  25. Error with select function from dplyr
  26. Run a custom function on a data frame in R, by group
  27. Dealing with spaces and “weird” characters in column names with dplyr::rename()
  28. Get name of dataframe passed through pipe in R
  29. Filtering rows in R unexpectedly removes NAs when using subset or dplyr::filter
  30. resetting cumsum if value goes to negative in r

Leave a Comment