Not neccessary to do this as you can specify which column in the two datases to use as common using the arguments by.x and by.y in merge().
Morassa Mohseni wrote: > Thanks! > Ill give this a try. I forgot to mention that the SNP.ID is not named the > same in both files, even though they contain the same information. I'll just > go ahead and open one of the files in a text editor and rename the columns > so they match. > -Morassa > PhD Student > Johns Hopkins Human Genetics > ----------- > Try looking at ?merge > > If your data is in two dataframes df1 and df2: > > merge(df1, df2) > > (This will merge on SNPID because that column is common to both dataframes). > > > > > > --- > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [*mailto:[EMAIL PROTECTED]<[EMAIL PROTECTED]>] > On Behalf Of Morassa Mohseni > > Sent: 24 August 2007 15:41 > > To: r-help@stat.math.ethz.ch > > Subject: [R] Merging two files together in R > > Hi, > > Thanks in advance for reading this post. > > I received some affymetrix genotyping data back recently (250K, Nsp > array)...However, in order for me to do any analysis on this data set, I > need to add append the annotation file to it. Basically I want to do > something that looks like this: > > > > > > Snpfile(tab delimited): > > > > > > SNPID Genotype X Y > > 123 AA 13.4 1.2 > > 456 AB 10.1 12.2 > > 789 BB 2.7 14.4 > > > > > > Annotation file (csv file): > > > > > > rs#, SNPID, Chromosome > > rs23525, 456, 12 > > rs78423, 123, 4 > > rs82342, 789, 9 > > > > > > What I am trying to get is an output file that looks like this: > > > > > > SNPID rs# Chromosome Genotype X > > Y > > 123 rs78423 4 AA > > 13.4 > > 1.2 > > 456 rs23525 12 AB > > 10.1 > > 12.2 > > 789 rs82342 9 BB > > 2.7 > > 14.4 > > > > > > > > > > The SNPID is the same in both files so I would like to use that to match > up...but they are not in the same order in both files, so I want to make > sure that I am appending and merging the 2 files correctly. So far all ive > really been able to do is import the files into R...Ive been looking through > the posts, and was wondering if I could use cbind(...) to merge the > files?...not sure though. > > > > > > Thanks again!! > > Morassa Mohseni > > > > > > PhD Student > > Johns Hopkins Dept. of Human Genetics > > Baltimore, MD > > [[alternative HTML version deleted]] > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@stat.math.ethz.ch mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > > > ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
