arrange.tbl_lazy {dbplyr} | R Documentation |
Order rows of database tables by an expression involving its variables.
## S3 method for class 'tbl_lazy' arrange(.data, ..., .by_group = FALSE)
.data |
A tbl. All main verbs are S3 generics and provide methods
for |
... |
Comma separated list of unquoted variable names, or expressions
involving variable names. Use |
.by_group |
If |
An object of the same class as .data
.
Compared to its sorting behavior on local data, the arrange()
method for
most database tables sorts NA at the beginning unless wrapped with desc()
.
Users can override this behaviour by explicitly sorting on is.na(x)
.
library(dplyr) dbplyr::memdb_frame(a = c(3, 4, 1, 2)) %>% arrange(a) # NA sorted first dbplyr::memdb_frame(a = c(3, 4, NA, 2)) %>% arrange(a) # override by sorting on is.na() first dbplyr::memdb_frame(a = c(3, 4, NA, 2)) %>% arrange(is.na(a), a)