Hi, I would try to merge 2 dataframes x1, x2 with same structure. ID is the common columns. I don't understand why the result, x, is composed of NA ? Is someone understand the problem ? The code is : > x2[1:3,] ID sVOL logSignalMean 4340 8559;27*L11 3189.818 11.6392584 4335 8547;27*L9 3419.657 11.7396359 3267 6441;27*I18 0.000 -0.4460873 > x1[1:3,] ID sVOL logSignalMean 4339 8557;25*L11 2972.267 11.5373480 4334 8545;25*L9 3380.747 11.7231263 3266 6439;25*I18 0.000 -0.4460873 > x<- merge(x1,x2,by.x=ID,by.y=ID,suffixes=c("1","2")) > x[1:3,] ID sVOL1 logSignalMean1 sVOL2 logSignalMean2 NA <na> NA NA NA NA NA.1 <na> NA NA NA NA NA.2 <na> NA NA NA NA thanks, gg

On Tuesday 13 February 2007 04:29, Ghislaine Guigon wrote: > Hi, > > I would try to merge 2 dataframes x1, x2 with same structure. ID is the > common columns. I don't understand why the result, x, is composed of NA ? > Is someone understand the problem ? > > The code is : > > x2[1:3,] > > ID sVOL logSignalMean > 4340 8559;27*L11 3189.818 11.6392584 > 4335 8547;27*L9 3419.657 11.7396359 > 3267 6441;27*I18 0.000 -0.4460873 > > > x1[1:3,] > > ID sVOL logSignalMean > 4339 8557;25*L11 2972.267 11.5373480 > 4334 8545;25*L9 3380.747 11.7231263 > 3266 6439;25*I18 0.000 -0.4460873 > > > x<- merge(x1,x2,by.x=ID,by.y=ID,suffixes=c("1","2")) The by argument needs to be a number, a logical vector, or character. You are supplying a variable which is being interpreted as one of these. Change the statement to: x<- merge(x1,x2,by.x="ID",by.y="ID",suffixes=c("1","2")) That will probably get you the answer you want. > > x[1:3,] > > ID sVOL1 logSignalMean1 sVOL2 logSignalMean2 > NA <na> NA NA NA NA > NA.1 <na> NA NA NA NA > NA.2 <na> NA NA NA NA > > thanks, > gg

Hi Ghislaine, Try x<- merge(x1,x2,by.x="ID",by.y="ID",suffixes=c("1","2"),all.x=TRUE,all.y=T RU E) Thanks, Alex ------------------------------------ Alex Lam PhD student Department of Genetics and Genomics Roslin Institute (Edinburgh) Roslin Midlothian EH25 9PS Great Britain Phone +44 131 5274471 Web http://www.roslin.ac.uk Roslin Institute is a company limited by guarantee, registered in Scotland (registered number SC157100) and a Scottish Charity (registered number SC023592). Our registered office is at Roslin, Midlothian, EH25 9PS. VAT registration number 847380013. The information contained in this e-mail (including any attachments) is confidential and is intended for the use of the addressee only. The opinions expressed within this e-mail (including any attachments) are the opinions of the sender and do not necessarily constitute those of Roslin Institute (Edinburgh) ("the Institute") unless specifically stated by a sender who is duly authorised to do so on behalf of the Institute -----Original Message----- From: bioconductor-bounces@stat.math.ethz.ch [mailto:bioconductor-bounces at stat.math.ethz.ch] On Behalf Of Ghislaine Guigon Sent: 13 February 2007 09:30 To: bioconductor at stat.math.ethz.ch Subject: [BioC] merge two dataframes Hi, I would try to merge 2 dataframes x1, x2 with same structure. ID is the common columns. I don't understand why the result, x, is composed of NA ? Is someone understand the problem ? The code is : > x2[1:3,] ID sVOL logSignalMean 4340 8559;27*L11 3189.818 11.6392584 4335 8547;27*L9 3419.657 11.7396359 3267 6441;27*I18 0.000 -0.4460873 > x1[1:3,] ID sVOL logSignalMean 4339 8557;25*L11 2972.267 11.5373480 4334 8545;25*L9 3380.747 11.7231263 3266 6439;25*I18 0.000 -0.4460873 > x<- merge(x1,x2,by.x=ID,by.y=ID,suffixes=c("1","2")) > x[1:3,] ID sVOL1 logSignalMean1 sVOL2 logSignalMean2 NA <na> NA NA NA NA NA.1 <na> NA NA NA NA NA.2 <na> NA NA NA NA thanks, gg