0

I have the following data frame

> library(splitstackshape)
> head(goa)
       V2         V5
1: A0A000 GO:0003824
2: A0A000 GO:0003870
3: A0A000 GO:0009058
4: A0A000 GO:0030170
5: A0A000 GO:0033014
6: A0A001 GO:0000166

and I would like to get this table:

> library(splitstackshape)
> head(goa)
       V2         V5
1: A0A000 GO:0003824,GO:0003870,GO:0009058,GO:0030170,GO:0033014
2: A0A001 GO:0000166 

I tried to use cSplit in the below way but it did not change anything.

> goa <- cSplit(goa, "V5", ",", "long")
> head(goa)
       V2         V5
1: A0A000 GO:0003824
2: A0A000 GO:0003870
3: A0A000 GO:0009058
4: A0A000 GO:0030170
5: A0A000 GO:0033014
6: A0A001 GO:0000166

What did I miss?

user977828
  • 7,259
  • 16
  • 66
  • 117

0 Answers0