| rank {SparkR} | R Documentation |
Window function: returns the rank of rows within a window partition.
## S4 method for signature 'missing' rank() ## S4 method for signature 'ANY' rank(x, ...) rank(x, ...)
x |
a numeric, complex, character or logical vector. |
... |
additional argument(s) passed to the method. |
The difference between rank and denseRank is that denseRank leaves no gaps in ranking sequence when there are ties. That is, if you were ranking a competition using denseRank 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.
This is equivalent to the RANK function in SQL.
rank since 1.6.0
Other window_funcs: cume_dist,
cume_dist,
cume_dist,missing-method;
dense_rank, dense_rank,
dense_rank,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;
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(rank(), ws), df$hp, df$am)
## End(Not run)