[igraph] Help !!!

[lan gao]

Dear all,

I know I may need to ask the R help group, but it would be great if anyone here can help me out this the following questions:

 

I have a data set like this , three columns ,I need to combine the rows with  the col1 and col2 are exaclty the same then average the col3

 

 

YAL003W	GO:0003746	8.273667
YAL003W	GO:0003746	8.991333
YAL005C	GO:0000166	13.679
YAL005C	GO:0000166	13.89867
YAL005C	GO:0000166	10.169

For the above sample data, I want to combine the first 2 rows and average their corresponding col1 to col2 ...then combine the row3 to row5....average col3-clo5

 

 

the final data set would be like

YAL003W    GO:0003746       8.6325

YAL005C     GO:0000166       12.5822

 

Many thanks!!!