dplyr table manipulation methods for zoomed dm objects — dplyr_table_manipulation" />

Use these methods without the '.zoomed_dm' suffix (see examples).

# S3 method for zoomed_dm
filter(.data, ...)

# S3 method for zoomed_dm
mutate(.data, ...)

# S3 method for zoomed_dm
transmute(.data, ...)

# S3 method for zoomed_dm
select(.data, ...)

# S3 method for zoomed_dm
rename(.data, ...)

# S3 method for zoomed_dm
distinct(.data, ..., .keep_all = FALSE)

# S3 method for zoomed_dm
arrange(.data, ...)

# S3 method for zoomed_dm
slice(.data, ..., .keep_pk = NULL)

# S3 method for zoomed_dm
group_by(.data, ...)

# S3 method for zoomed_dm
ungroup(x, ...)

# S3 method for zoomed_dm
summarise(.data, ...)

# S3 method for zoomed_dm
pull(.data, var = -1, ...)

Arguments

.data

object of class zoomed_dm

...

see corresponding function in package dplyr or tidyr

.keep_all

For distinct.zoomed_dm(): see dplyr::distinct

.keep_pk

For slice.zoomed_dm: Logical, if TRUE, the primary key will be retained during this transformation. If FALSE, it will be dropped. By default, the value is NULL, which causes the function to issue a message in case a primary key is available for the zoomed table. This argument is specific for the slice.zoomed_dm() method.

x

For ungroup.zoomed_dm: object of class zoomed_dm

var

A variable specified as:

  • a literal variable name

  • a positive integer, giving the position counting from the left

  • a negative integer, giving the position counting from the right.

The default returns the last column (on the assumption that's the column you've created most recently).

This argument is taken by expression and supports quasiquotation (you can unquote column names and column locations).

Examples

zoomed <- dm_nycflights13() %>% dm_zoom_to(flights) %>% group_by(month) %>% arrange(desc(day)) %>% summarize(avg_air_time = mean(air_time, na.rm = TRUE)) zoomed
#> # Zoomed table: flights #> # A tibble: 12 x 2 #> month avg_air_time #> <int> <dbl> #> 1 1 147. #> 2 2 149. #> 3 3 144. #> 4 4 158. #> 5 5 147. #> 6 6 152. #> 7 7 153. #> 8 8 157. #> 9 9 138. #> 10 10 143. #> 11 11 157. #> 12 12 179.
dm_insert_zoomed(zoomed, new_tbl_name = "avg_air_time_per_month")
#> ── Table source ──────────────────────────────────────────────────────────────── #> src: <environment: R_GlobalEnv> #> ── Metadata ──────────────────────────────────────────────────────────────────── #> Tables: `airlines`, `airports`, `flights`, `planes`, `weather`, `avg_air_time_per_month` #> Columns: 55 #> Primary keys: 3 #> Foreign keys: 3