Re: [R] merging multiple columns from two dataframes

From: Scott Chamberlain <scttchamberlain4_at_gmail.com>
Date: Wed, 04 May 2011 14:53:28 -0500

 merge(dat, pheno, by.x = "sid", by.y = "sen")

Scott
On Wednesday, May 4, 2011 at 12:53 PM, 1Rnwb wrote:
> Hello,
>
> I have data in a dataframe with 139104 rows which is multiple of 96x1449. i
> have a phenotype file which contains the phenotype information for the 96
> samples. the snp name is repeated 1449X96 samples. I haveto merge the two
> dataframes based on sid and sen. this is how my two dataframes look like
> dat<-data.frame(snpname=rep(letters[1:12],12),sid=rep(1:12,each=12),
> genotype=rep(c('aa','ab','bb'), 12))
> pheno<-data.frame(sen=1:12,disease=rep(c('N','Y'),6), wellid=1:12)
>
> I have to merge or add the disease column and 3 other columns to the data
> file. I am unable to use merge in R. I have searched google, i guess i am
> not hitting the correct terms to get the answer. I would appreciate any
> input on this issue. thanks
> sharad
>
> --
> View this message in context: http://r.789695.n4.nabble.com/merging-multiple-columns-from-two-dataframes-tp3496341p3496341.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help_at_r-project.org 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.
>

        [[alternative HTML version deleted]]



R-help_at_r-project.org 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. Received on Thu 05 May 2011 - 06:25:13 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 05 May 2011 - 07:00:07 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive