[R] Splitting up rows in a data frame

Tom Wenseleers tom.wenseleers at bio.kuleuven.be
Thu Feb 4 16:41:19 CET 2010


Dear all,
I have the following data frame
goannot=read.table(file="c:\ApisGOannot.txt",colClasses="character",header=TRUE,sep="\t") 

         GB_nr           evidence                            GO_list
1       GB18414-RA     apis                             0001507, 
0003990, 0004104
2       GB10293-RA     apis                             0003676
3       GB12644-RA     apis                             0003677, 
0000786, 0006334, 0005634
4       GB17142-RA     apis                             0003677, 
0003899, 0006350
5       GB15064-RA     apis                             0003677, 0005515

and I would like to split up each row in the data frame based on the 
", " delimiter in the GO_list column. I.e. I would like to obtain
         GB_nr           evidence                            GO_list
1       GB18414-RA     apis                             0001507
2       GB18414-RA     apis                             0003990
3       GB18414-RA     apis                             0004104
4       GB10293-RA     apis                             0003676
5       GB12644-RA     apis                             0003677
6       GB12644-RA     apis                             0000786
7       GB12644-RA     apis                             0006334
8       GB12644-RA     apis                             0005634
...

I started to try to do this using strsplit, but I was thinking there 
might be more elegant ways to do this?
Any advice would be much appreciated (I am new to R)!

cheers,
Tom


Dr. T. Wenseleers
Dept. of Biology
Zoological Institute
K.U.Leuven
Naamsestraat 59
B-3000 Leuven
Belgium
tel. +32 (0)16 32 39 64
mobile +32 (0)472 40 45 96
e-mail tom.wenseleers at bio.kuleuven.be
web http://bio.kuleuven.be/ento/wenseleers/twenseleers.htm



More information about the R-help mailing list