[R] Read data from .csv file as a matrix and compare the different between two matrix

[David Winsemius]

On Sep 4, 2012, at 4:39 PM, s.s.m. fauzi wrote:

> Hi,
> I have two table matrix, and I would like to compare the different between
> two matrix.
> For example:
> 
> Matrix 1:
>    A B C
> A 0  1 0
> B 0  0 1
> C 0  0  0
> 
> Matrix 2:
>   A B C
> A 0  1  0
> B 0  0  0
> C 0  0  0
> 
> Each column which have value 1, should also return value 1. As in this
> case/example, the result should appear like this (as below). The result of
> this differentiation should also be in matrix table and should be write in .
> csv file.
> 
> Result of the differences:

Differences? What differences?

If you examined the matrix returned by:

matrix1 == matrix2 it would look exactly like your desired result:


>   A B C
> A 0  1  0
> B 0  0  0
> C 0  0  0
> 
> At the mean time, I'm able to load the .csv file and convert it to matrix
> matrix1 <-read.table("matrix1.csv", header=T, sep=",")
> matrix1 <- as.matrix(matrix1)
> matrix2 <- read.table("matrix2.csv", header=T, sep=",")
> matrix2 <- as.matrix(matrix2)
> 
> But, I can't find a suitable script to compare the differences between the
> matrix and write it to file.
> 
> Appreciate any help from the expert
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> 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.

David Winsemius, MD
Alameda, CA, USA