[R] matrix/df help populate NA

[jim holtman]

Is this what you want:

> x1 = structure(list(Subject = c("x1", "x2"), A = c(1.5, -1.2), B = c(-1.3,
+ -0.3), C = c(0.4, 0.3), D = c(-0.2, -0.1)), .Names = c("Subject",
+ "A", "B", "C", "D"), class = "data.frame", row.names = c(NA,
+ -2L))
>
> x2 = structure(list(Subject = c("x1", "x2"), A = c(4.3, 2.4), D = c(-2.4,
+ 0.1), F = c(1.3, 0.5), H = c(-2.3, -1.4)), .Names = c("Subject",
+ "A", "D", "F", "H"), class = "data.frame", row.names = c(NA,
+ -2L))
>
> # determine what the missing columns are and then add them to x2
> missing <- setdiff(colnames(x1), colnames(x2))
>
> new_x2 <- x2
>
> for (i in missing) new_x2[[i]] <- NA
>
> new_x2
  Subject   A    D   F    H  B  C
1      x1 4.3 -2.4 1.3 -2.3 NA NA
2      x2 2.4  0.1 0.5 -1.4 NA NA





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.

On Sat, Jun 13, 2015 at 11:17 PM, Adrian Johnson <oriolebaltimore at gmail.com>
wrote:

> Dear group:
>
> I have two data frames. The column names of the two data frame has
> some common variables but not identical.
>
> my aim is to make 2  DFs more uniform by taking union of both colnames
>
>
> For example: I have x1 and x2 matrices:
>
> > x1
>   Subject    A    B   C    D
> 1      x1  1.5 -1.3 0.4 -0.2
> 2      x2 -1.2 -0.3 0.3 -0.1
> > x2
>   Subject   A    D   F    H
> 1      x1 4.3 -2.4 1.3 -2.3
> 2      x2 2.4  0.1 0.5 -1.4
>
>  cases = c('A','B','C','D','F','H')
>
> for X2 I want to create newX2 DF.
>
> > x3
>   Subject   A  B  C    D   F    H
> 1      x1 4.3 NA NA -2.4 1.3 -2.3
> 2      x2 2.4 NA NA  0.1 0.5 -1.4
>
>
> Since B and C are no existing in x2, I put NAs.
>
> how can I create x3 matrix?
>
>
>
> dput code:
>
> x1 = structure(list(Subject = c("x1", "x2"), A = c(1.5, -1.2), B = c(-1.3,
> -0.3), C = c(0.4, 0.3), D = c(-0.2, -0.1)), .Names = c("Subject",
> "A", "B", "C", "D"), class = "data.frame", row.names = c(NA,
> -2L))
>
> x2 = structure(list(Subject = c("x1", "x2"), A = c(4.3, 2.4), D = c(-2.4,
> 0.1), F = c(1.3, 0.5), H = c(-2.3, -1.4)), .Names = c("Subject",
> "A", "D", "F", "H"), class = "data.frame", row.names = c(NA,
> -2L))
>
>
> Could you please help how to create x3 with NAs incorporated.
> adrian.
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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]]