dplyr::select one column and output as vector

Question

dplyr::select results in a data.frame, is there a way to make it return a vector if the result is one column?

Currently, I have to do extra step (res <- res$y) to convert it to vector from data.frame, see this example:

#dummy data
df <- data.frame(x = 1:10, y = LETTERS[1:10], stringsAsFactors = FALSE)

#dplyr filter and select results in data.frame
res <- df %>% filter(x > 5) %>% select(y)
class(res)
#[1] "data.frame"

#desired result is a character vector
res <- res$y
class(res)
#[1] "character"

Something as below:

res <- df %>% filter(x > 5) %>% select(y) %>% as.character
res
# This gives strange output
[1] "c(\"F\", \"G\", \"H\", \"I\", \"J\")"

# I need:
# [1] "F" "G" "H" "I" "J"

@Henrik Yes, you are right. I saw that post, somehow couldn't replicate, hence this post. Now it works! `df %>% filter(x>5) %>% select(y) %>% .[["y"]]`. — zx8754, Nov 26 '14 at 13:22
This is not a duplicate. The other question is specific to table with database back-ends, where the answer to this question (`%>% .$y`) does not work. — nacnudus, Sep 16 '15 at 21:17

score 148 · Accepted Answer · edited Oct 27 '17 at 08:41

148

The best way to do it (IMO):

library(dplyr)
df <- data_frame(x = 1:10, y = LETTERS[1:10])

df %>% 
  filter(x > 5) %>% 
  .$y

In dplyr 0.7.0, you can now use pull():

df %>% filter(x > 5) %>% pull(y)

edited Oct 27 '17 at 08:41

zx8754

52,746
12
114
209

answered Nov 26 '14 at 22:56

hadley

102,019
32
183
245

5

Could you point to the documentation on the dot operator in this context? – Andy Jun 03 '15 at 17:19
2

@Andy see the magrittr docs – hadley Jun 05 '15 at 19:36
20

In dplyr 0.7.0, you can now use `pull()`: `df %>% filter(x > 5) %>% pull(y)` – ianmcook Jun 27 '17 at 20:40
3

surprised not to see the `%$%` pipe from `magrittr::`! As in: `df %>% filter(x>5) %$% y` – lefft Nov 08 '17 at 00:32

score 9 · Answer 2 · answered Nov 26 '14 at 12:42

9

Something like this?

> res <- df %>% filter(x>5) %>% select(y) %>% sapply(as.character) %>% as.vector
> res
[1] "F" "G" "H" "I" "J"
> class(res)
[1] "character"

answered Nov 26 '14 at 12:42

LyzandeR

37,047
12
77
87

score 6 · Answer 3 · answered Nov 26 '14 at 13:03

6

You could also try

res <- df %>%
           filter(x>5) %>%
           select(y) %>%
           as.matrix() %>%
           c()
#[1] "F" "G" "H" "I" "J"

 class(res)
#[1] "character"

answered Nov 26 '14 at 13:03

akrun

874,273
37
540
662

dplyr::select one column and output as vector

3 Answers3

Linked

Related