[R] Prob with merge

[Joel]

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.