pull() is similar to $. It's mostly useful because it looks a little
nicer in pipes, it also works with remote data frames, and it can optionally
name the output.
Arguments
- .data
A data frame, data frame extension (e.g. a tibble), or a lazy data frame (e.g. from dbplyr or dtplyr). See Methods, below, for more details.
- 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).
- name
An optional parameter that specifies the column to be used as names for a named vector. Specified in a similar manner as
var.- ...
For use by methods.
Methods
This function is a generic, which means that packages can provide implementations (methods) for other classes. See the documentation of individual methods for extra arguments and differences in behaviour.
The following methods are currently available in loaded packages:
dbplyr (tbl_sql), dplyr (data.frame)
.
Examples
mtcars %>% pull(-1)
#> [1] 4 4 1 1 2 1 4 2 2 4 4 3 3 3 4 4 4 1 2 1 1 2 2 4 2 1 2 2 4 6 8 2
mtcars %>% pull(1)
#> [1] 21.0 21.0 22.8 21.4 18.7 18.1 14.3 24.4 22.8 19.2 17.8 16.4 17.3 15.2
#> [15] 10.4 10.4 14.7 32.4 30.4 33.9 21.5 15.5 15.2 13.3 19.2 27.3 26.0 30.4
#> [29] 15.8 19.7 15.0 21.4
mtcars %>% pull(cyl)
#> [1] 6 6 4 6 8 6 8 4 4 6 6 8 8 8 8 8 8 4 4 4 4 8 8 8 8 4 4 4 8 6 8 4
# Also works for remote sources
df <- dbplyr::memdb_frame(x = 1:10, y = 10:1, .name = "pull-ex")
df %>%
mutate(z = x * y) %>%
pull()
#> [1] 10 18 24 28 30 30 28 24 18 10
# Pull a named vector
starwars %>% pull(height, name)
#> Luke Skywalker C-3PO R2-D2
#> 172 167 96
#> Darth Vader Leia Organa Owen Lars
#> 202 150 178
#> Beru Whitesun lars R5-D4 Biggs Darklighter
#> 165 97 183
#> Obi-Wan Kenobi Anakin Skywalker Wilhuff Tarkin
#> 182 188 180
#> Chewbacca Han Solo Greedo
#> 228 180 173
#> Jabba Desilijic Tiure Wedge Antilles Jek Tono Porkins
#> 175 170 180
#> Yoda Palpatine Boba Fett
#> 66 170 183
#> IG-88 Bossk Lando Calrissian
#> 200 190 177
#> Lobot Ackbar Mon Mothma
#> 175 180 150
#> Arvel Crynyd Wicket Systri Warrick Nien Nunb
#> NA 88 160
#> Qui-Gon Jinn Nute Gunray Finis Valorum
#> 193 191 170
#> Jar Jar Binks Roos Tarpals Rugor Nass
#> 196 224 206
#> Ric Olié Watto Sebulba
#> 183 137 112
#> Quarsh Panaka Shmi Skywalker Darth Maul
#> 183 163 175
#> Bib Fortuna Ayla Secura Dud Bolt
#> 180 178 94
#> Gasgano Ben Quadinaros Mace Windu
#> 122 163 188
#> Ki-Adi-Mundi Kit Fisto Eeth Koth
#> 198 196 171
#> Adi Gallia Saesee Tiin Yarael Poof
#> 184 188 264
#> Plo Koon Mas Amedda Gregar Typho
#> 188 196 185
#> Cordé Cliegg Lars Poggle the Lesser
#> 157 183 183
#> Luminara Unduli Barriss Offee Dormé
#> 170 166 165
#> Dooku Bail Prestor Organa Jango Fett
#> 193 191 183
#> Zam Wesell Dexter Jettster Lama Su
#> 168 198 229
#> Taun We Jocasta Nu Ratts Tyerell
#> 213 167 79
#> R4-P17 Wat Tambor San Hill
#> 96 193 191
#> Shaak Ti Grievous Tarfful
#> 178 216 234
#> Raymus Antilles Sly Moore Tion Medon
#> 188 178 206
#> Finn Rey Poe Dameron
#> NA NA NA
#> BB8 Captain Phasma Padmé Amidala
#> NA NA 165