Split character vector into separate rows

Asked Sep 29 '17 at 05:31

Active Sep 29 '17 at 05:40

Viewed 665 times

I have a data frame column, which is a list of words. I want to convert this list of words (each row), into long single list

df <- rbind(data.frame(words = c("a,b,c,d")),
            data.frame(words = c("a,b,c,e")),
            data.frame(words = c("d,a,b,a,b,c,d")))

> df
          words
1       a,b,c,d
2       a,b,c,e
3 d,a,b,a,b,c,d

I want a df such that each word from each row is a new row. I am looking for a vector of elements

#Expected Output
a
b
c
d
a
b
c
e
d
a
b
a
b
c
d

edited Sep 29 '17 at 05:40

Ronak Shah

377,200
20
156
213

asked Sep 29 '17 at 05:31

Hardik Gupta

4,700
9
41
83

2

`data.frame(new_row = unlist(strsplit(as.character(df$words), ",")))` – Ronak Shah Sep 29 '17 at 05:33
Ronak, can you please post this as an answer it is correct. Thank you – Hardik Gupta Sep 29 '17 at 05:34
1

I am looking for a duplicate for this, if I can't find one I will post as an answer. – Ronak Shah Sep 29 '17 at 05:36

Split character vector into separate rows

0 Answers0