Hello all,

I don't know how to combine different data frames in a certain form, let 
me explain:

Suppose you have 5 data.frame like this one (but with different genes 
and values each data frame):

GeneName 	a1
SULT1 	8
SOCS3 	3.5
SOCS3 	3.4
SOCS3 	2.5
ASNS 	1.4


GeneName 	
	a2
SULT1 	
	5
SOCS3 	
	2
SOCS3 	
	1.4



Notice that there are replicates (SOCS3) but with different values.
What I would like to do is the following:
Combine this five data frames according to the GeneName (maybe from A to 
Z). As every frame has different genes but also common genes (but 
probably with a different value) I would like one frame. If there is a 
value for a gene in a1, a2 and a5 comparing to the other frames, it has 
to be shown, but if there is no value it has to show "na".
Also if there is more than one value for a gene it should be ordered in 
a decreasing way.

GeneName 	a1 	a2 	a3 	a4 	a5
SULT1 	8 	5 	na 	na 	2
SOCS3 	3.5 	2 	na 	2 	4.5
SOCS3 	3.4 	1.4 	na 	1.9 	3.5
SOCS3 	2.5 	na 	na 	na 	2.5
ASNS 	1.4 	na 	5 	3 	na


I hope you could help me with this.
Many thanks in advance,

Paul C. Schröder

--
Paul C. Schröder
PhD-Student Division of Proteomics, Genomics & Bioinformatics
Center for Applied Medicine (CIMA)
University of Navarra
Avda. Pio XII, 55
E-31008 Pamplona, Spain



	[[alternative HTML version deleted]]

