Extract a dplyr tbl column as a vector

by

With dplyr >= 0.7.0, you can use pull() to get a vector from a tbl.

library("dplyr")
#> 
#> Attaching package: 'dplyr'
#> The following objects are masked from 'package:stats':
#> 
#>     filter, lag
#> The following objects are masked from 'package:base':
#> 
#>     intersect, setdiff, setequal, union
db <- src_sqlite(tempfile(), create = TRUE)
iris2 <- copy_to(db, iris)
vec <- pull(iris2, Species)
head(vec)
#> [1] "setosa" "setosa" "setosa" "setosa" "setosa" "setosa"

More Related Contents:

  1. Pass arguments to dplyr functions
  2. Non-standard evaluation (NSE) in dplyr’s filter_ & pulling data from MySQL
  3. Gather multiple sets of columns
  4. How to get summary statistics by group
  5. Is there a dplyr equivalent to data.table::rleid?
  6. Replace NA with previous or next value, by group, using dplyr
  7. Filter rows which contain a certain string
  8. Filter multiple values on a string column in dplyr
  9. Group by multiple columns in dplyr, using string vector input
  10. R spreading multiple columns with tidyr [duplicate]
  11. Select groups which have at least one of a certain value
  12. Display / print all rows of a tibble (tbl_df)
  13. How to strsplit different number of strings in certain column by do function
  14. Finding Overlaps between interval sets / Efficient Overlap Joins
  15. R dplyr rolling sum
  16. How to remove rows with any zero value
  17. Select columns based on string match – dplyr::select
  18. Delete columns/rows with more than x% missing
  19. How to aggregate a dataframe by week?
  20. adding default values to item x group pairs that don’t have a value (df %>% spread %>% gather seems strange)
  21. dplyr mutate rowwise max of range of columns
  22. dplyr: lead() and lag() wrong when used with group_by()
  23. Reorder rows using custom order
  24. Spreading a two column data frame with tidyr
  25. R dplyr rowwise mean or min and other methods?
  26. Chain arithmetic operators in dplyr with %>% pipe
  27. dplyr summarize with subtotals
  28. How to find difference between values in two rows in an R dataframe using dplyr
  29. Unlisting columns by groups
  30. dplyr – Group by and select TOP x %

Leave a Comment