| dense_rank {SparkR} | R Documentation |
Window function: returns the rank of rows within a window partition, without any gaps. The difference between rank and dense_rank is that dense_rank leaves no gaps in ranking sequence when there are ties. That is, if you were ranking a competition using dense_rank and had three people tie for second place, you would say that all three were in second place and that the next person came in third.
## S4 method for signature 'missing' dense_rank() dense_rank(x = "missing")
x |
empty. Should be used with no argument. |
This is equivalent to the DENSE_RANK function in SQL.
dense_rank since 1.6.0
Other window_funcs: cume_dist,
cume_dist,
cume_dist,missing-method;
lag, lag,
lag,characterOrColumn-method;
lead, lead,
lead,characterOrColumn,numeric-method;
ntile, ntile,
ntile,numeric-method;
percent_rank, percent_rank,
percent_rank,missing-method;
rank, rank,
rank, rank,ANY-method,
rank,missing-method;
row_number, row_number,
row_number,missing-method
## Not run:
##D df <- createDataFrame(mtcars)
##D ws <- orderBy(windowPartitionBy("am"), "hp")
##D out <- select(df, over(dense_rank(), ws), df$hp, df$am)
## End(Not run)