[R] Overlaying the matrices

[Shubha Vishwanath Karanth]

Suppose if I modify the question as:

> x
  A B C D E
a 0 0 0 0 1
b 0 1 0 2 1
c 1 2 0 1 2
d 0 0 0 2 0
e 0 1 2 0 2

> y
  D E F
b 2 1 2
a 4 0 1
f 1 4 1

I need to get a matrix, which has the dimension being the union of the
row names and column names of both x and y such that the new matrix 'xx'
should contain only the corresponding elements in x, rest all should be
NA.

Any ideas for this?


Thanks, Shubha
-----Original Message-----
From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org]
On Behalf Of Shubha Vishwanath Karanth
Sent: Monday, June 09, 2008 4:57 PM
To: r-help at stat.math.ethz.ch
Subject: [R] Overlaying the matrices

Hi R,

 

I have a matrix,

 

> x1=matrix(NA,6,6,dimnames=list(letters[1:6],LETTERS[1:6]))

> x1

   A  B  C  D  E  F

a NA NA NA NA NA NA

b NA NA NA NA NA NA

c NA NA NA NA NA NA

d NA NA NA NA NA NA

e NA NA NA NA NA NA

f NA NA NA NA NA NA

 

> x2=matrix(rpois(9,1),3,3,dimnames=list(c("b","a","f"),c("D","E","F")))

> x2

  D E F

b 0 3 0

a 2 2 1

f 1 0 0

 

 

I need to put the values of x2 in the corresponding elements of x1. So
then, x1 would look like:

   A  B  C  D  E  F

a NA NA NA 2 2 1

b NA NA NA 0 3 0

c NA NA NA NA NA NA

d NA NA NA NA NA NA

e NA NA NA NA NA NA

f NA NA NA 1 0 0

 

 

 

What would be the best way to do this?

 

Many Thanks,

Shubha

 

 

This e-mail may contain confidential and/or privileged
i...{{dropped:13}}

______________________________________________
R-help at 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.
This e-mail may contain confidential and/or privileged i...{{dropped:10}}