How to create new rows dependent on other rows

Asked Sep 14 '17 at 03:10

Active Sep 14 '17 at 03:39

Viewed 27 times

I have the following table:

sp0000001-mRNA-1    
sp0000005-mRNA-1    GO:0003723
sp0000006-mRNA-1    GO:0016021
sp0000007-mRNA-1    GO:0003700|GO:0006355|GO:0043565

The aim would be to generate new rows for GO ids which were separated by |. From the above example it would lead to 2 more rows

sp0000001-mRNA-1    
sp0000005-mRNA-1    GO:0003723
sp0000006-mRNA-1    GO:0016021
sp0000007-mRNA-1    GO:0003700
sp0000007-mRNA-1    GO:0006355
sp0000007-mRNA-1    GO:0043565

How is it possible to do it R?

Thank you in advance

asked Sep 14 '17 at 03:10

user977828

7,259
16
66
117

`library(splitstackshape); cSplit(df, "V2", "|", "long")` – Ronak Shah Sep 14 '17 at 03:19
`tidyr::separate_rows` – Brian Sep 14 '17 at 03:20
`tidyr::unnest` – BENY Sep 14 '17 at 03:24
is there any performance difference between the above solutions? – user977828 Sep 14 '17 at 21:45

How to create new rows dependent on other rows

0 Answers0