merge(t1,t2, by="a", all.x = TRUE) ------------------------------------------------------------------------ ---- ir. Thierry Onkelinx Instituut voor natuur- en bosonderzoek team Biometrie & Kwaliteitszorg Gaverstraat 4 9500 Geraardsbergen Belgium
Research Institute for Nature and Forest team Biometrics & Quality Assurance Gaverstraat 4 9500 Geraardsbergen Belgium tel. + 32 54/436 185 thierry.onkel...@inbo.be www.inbo.be To call in the statistician after the experiment is done may be no more than asking him to perform a post-mortem examination: he may be able to say what the experiment died of. ~ Sir Ronald Aylmer Fisher The plural of anecdote is not data. ~ Roger Brinner The combination of some data and an aching desire for an answer does not ensure that a reasonable answer can be extracted from a given body of data. ~ John Tukey > -----Oorspronkelijk bericht----- > Van: r-help-boun...@r-project.org > [mailto:r-help-boun...@r-project.org] Namens Joel > Verzonden: maandag 22 november 2010 15:07 > Aan: r-help@r-project.org > Onderwerp: [R] Prob with merge > > > Hi > > Im trying to merge 2 data frames using merge but I dont get > the result i want > > Lets make this a small test as my data set is to big to put > in here :). > > t1<-data.frame(a=c(1,2,3,4,5,6),b=c(11,11,NA,11,11,11)) > t1<-data.frame(a=c(1,2,3,4,5,8),b=c(12,12,12,12,12,32)) > > this gives me: > > > t1 > a b > 1 1 12 > 2 2 12 > 3 3 12 > 4 4 12 > 5 5 12 > 6 8 32 > > t2 > a b > 1 1 11 > 2 2 11 > 3 3 NA > 4 4 11 > 5 5 11 > 6 6 11 > > now when i merge i get: > > merge(t1,t2, by="a") > a b.x b.y > 1 1 12 11 > 2 2 12 11 > 3 3 12 NA > 4 4 12 11 > 5 5 12 11 > > > But what I want is it to look like: > > a b.x b.y > 1 1 12 11 > 2 2 12 11 > 3 3 12 NA > 4 4 12 11 > 5 5 12 11 > 6 8 32 NA > > So I keep all of the rows from t1 and get an NA in dose slots > at the t2 part of the merge. > Anyone know how to accomplice this? > > Thx > //Joel > > > > -- > View this message in context: > http://r.789695.n4.nabble.com/Prob-with-merge-tp3053652p3053652.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help@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. > ______________________________________________ R-help@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.
