Hello,
I don't believe there's an R function that does what you want, but you
can write one.
myrbind <- function(x, y){
cx <- colnames(x)
cy <- colnames(y)
if(is.null(cx) || is.null(cy)){
result <- rbind(x, y)
}else{
ox <- order(cx)
oy <- order(cy)
result <- rbind(x[, ox], y[, oy])
result <- result[, order(ox)]
}
result
}
myrbind(data1, data3)
r1 r2
[1,] 1 2
[2,] 1 1
[3,] 2 2
[4,] 3 2
[5,] 1 2
[6,] 1 1
[7,] 2 2
[8,] 3 2
Hope this helps,
Rui Barradas
Em 23-11-2012 15:11, Virgile Capo-Chichi escreveu:
Hi Jim,
I did not try merge because I thought it only adds variables instead of
cases. Below is what I am trying to do. When I joined data1 and data2, I
was was expecting three variables: r1, r2 and r3 with r2 and r3 presenting
missing values where they did not exist in the first place. V
r1<-c(1,1,2,3)
r2<-c(2,1,2,2)
r3<-c(2,1,4,1)
data1<-cbind(r1,r2)
data2<-cbind(r1,r3)
data1
r1 r2
[1,] 1 2
[2,] 1 1
[3,] 2 2
[4,] 3 2
data2
r1 r3
[1,] 1 2
[2,] 1 1
[3,] 2 4
[4,] 3 1
data<-rbind(data1, data2)
data
r1 r2
[1,] 1 2
[2,] 1 1
[3,] 2 2
[4,] 3 2
[5,] 1 2
[6,] 1 1
[7,] 2 4
[8,] 3 1
data3<-cbind(r2, r1)
data_test<-rbind(data1, data3)
data1
r1 r2
[1,] 1 2
[2,] 1 1
[3,] 2 2
[4,] 3 2
data3
r2 r1
[1,] 2 1
[2,] 1 1
[3,] 2 2
[4,] 2 3
data_test
r1 r2
[1,] 1 2
[2,] 1 1
[3,] 2 2
[4,] 3 2
[5,] 2 1
[6,] 1 1
[7,] 2 2
[8,] 2 3
2012/11/23 jim holtman <jholt...@gmail.com>
Have you tried 'merge'?
You did not provide any sample data (use 'dput' if you do) so that we
could show a possible solution.
On Fri, Nov 23, 2012 at 9:56 AM, Virgile Capo-Chichi
<vcapochi...@gmail.com> wrote:
Hello all,
I al trying to join (ADD FILES in SPSS) two files using the rbind()
function. However, with rbind() R does not behave the same way as SPSS. I
mean, it just concatenates the two blocs with no consideration for same
variables if these are not in the same position in the two files. Anyone
knows a function that performs the SPSS ADD FILES task? Thanks, V
[[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.
--
Jim Holtman
Data Munger Guru
What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.
[[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.
