This is a method for dplyr generic arrange(). It is translated to an order() call in the i argument of [.data.table.

# S3 method for dtplyr_step
arrange(.data, ..., .by_group = FALSE)

Arguments

.data

A lazy_dt().

...

<data-masking> Variables, or functions of variables. Use desc() to sort a variable in descending order.

.by_group

If TRUE, will sort first by grouping variable. Applies to grouped data frames only.

Examples

library(dplyr, warn.conflicts = FALSE) dt <- lazy_dt(mtcars) dt %>% arrange(vs, cyl)
#> Source: local data table [32 x 11] #> Call: `_DT1`[order(vs, cyl)] #> #> mpg cyl disp hp drat wt qsec vs am gear carb #> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> #> 1 26 4 120. 91 4.43 2.14 16.7 0 1 5 2 #> 2 21 6 160 110 3.9 2.62 16.5 0 1 4 4 #> 3 21 6 160 110 3.9 2.88 17.0 0 1 4 4 #> 4 19.7 6 145 175 3.62 2.77 15.5 0 1 5 6 #> 5 18.7 8 360 175 3.15 3.44 17.0 0 0 3 2 #> 6 14.3 8 360 245 3.21 3.57 15.8 0 0 3 4 #> # … with 26 more rows #> #> # Use as.data.table()/as.data.frame()/as_tibble() to access results
dt %>% arrange(desc(vs), cyl)
#> Source: local data table [32 x 11] #> Call: `_DT1`[order(desc(vs), cyl)] #> #> mpg cyl disp hp drat wt qsec vs am gear carb #> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> #> 1 22.8 4 108 93 3.85 2.32 18.6 1 1 4 1 #> 2 24.4 4 147. 62 3.69 3.19 20 1 0 4 2 #> 3 22.8 4 141. 95 3.92 3.15 22.9 1 0 4 2 #> 4 32.4 4 78.7 66 4.08 2.2 19.5 1 1 4 1 #> 5 30.4 4 75.7 52 4.93 1.62 18.5 1 1 4 2 #> 6 33.9 4 71.1 65 4.22 1.84 19.9 1 1 4 1 #> # … with 26 more rows #> #> # Use as.data.table()/as.data.frame()/as_tibble() to access results
dt %>% arrange(across(mpg:disp))
#> Source: local data table [32 x 11] #> Call: `_DT1`[order(mpg, cyl, disp)] #> #> mpg cyl disp hp drat wt qsec vs am gear carb #> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> #> 1 10.4 8 460 215 3 5.42 17.8 0 0 3 4 #> 2 10.4 8 472 205 2.93 5.25 18.0 0 0 3 4 #> 3 13.3 8 350 245 3.73 3.84 15.4 0 0 3 4 #> 4 14.3 8 360 245 3.21 3.57 15.8 0 0 3 4 #> 5 14.7 8 440 230 3.23 5.34 17.4 0 0 3 4 #> 6 15 8 301 335 3.54 3.57 14.6 0 1 5 8 #> # … with 26 more rows #> #> # Use as.data.table()/as.data.frame()/as_tibble() to access results