Split a String into rows and maintain mapping to other columns in R

Question

Sorry if the title is a bit misleading. Heres my problem;

I have dataframe with 3 columns

col1      col2      col3
Parta     3         xxx,yyy,zzz
Partb     4         aaa,bbb,ccc

I'd like to stringsplit col3 so that i get the contents in a new column but still maninatin the relationship to the other columns.. like this

col1     col2     col3
Parta    3        xxx
Parta    3        yyy
Parta    3        zzz
Partb    4        aaa
Partb    4        bbb
Partc    4        ccc

Simply I'm sure but I'm struggling...help appreciated.. Paul.

see `splitstackshape::cSplit()` – mtoto Oct 28 '16 at 11:52 — mtoto, Oct 28 '16 at 11:52
Can you give me the link to the answer..? – PaulBeales Oct 28 '16 at 12:09 — PaulBeales, Oct 28 '16 at 12:09

score 0 · Answer 1 · answered Oct 28 '16 at 11:58

0

We can use separate_rows from tidyr

library(tidyr)
separate_rows(df1, col3)

answered Oct 28 '16 at 11:58

akrun

874,273
37
540
662

can't locate tidyr{} on CRAN..? – PaulBeales Oct 28 '16 at 12:03
1

@PaulBeales I think the new package is library(tidyverse) which includes a dozen packages – akrun Oct 28 '16 at 12:19

Split a String into rows and maintain mapping to other columns in R

1 Answers1