library(plyr) colnames(Y)[2]<- colnames(X) join(X,Y,type="left",by="k1") # k1 k2 #1 A 1 #2 <NA> NA #3 C 3 #4 B 2 A.K.
----- Original Message ----- From: nevil amos <nevil.a...@gmail.com> To: r-help <R-help@r-project.org> Cc: Sent: Friday, May 31, 2013 4:07 AM Subject: [R] merge without NA last I am trying to create a merge where the first value contains NA values. I wish to retain these in order. however when I use all.x=T and sort=F they are retained but na values are placed last: > X<-data.frame(k1=c("A",NA,"C","B")) > print (X) k1 1 A 2 <NA> 3 C 4 B > Y<-data.frame(k2=c(1,2,3),k3=c("A","B","C")) > Z<-merge(X,Y, by.x=1,by.y=2,all.x=T,sort=F) > print (Z) k1 k2 1 A 1 2 C 3 3 B 2 4 <NA> NA The result I need is k1 k2 1 A 1 2 <NA> NA 3 C 3 4 B 2 how do I prevent NA c=values being sorted to last - I need to retain values in position. thanks Nevil Amos [[alternative HTML version deleted]] ______________________________________________ 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.