Compare tables
How can I compare numerical values from many tables ?
In R load the tables in matrix Mi using the syntax :
M1<-read.table("M1.csv", header=T, row.names =1, sep="\t")
Then create a new matrix C with the value "1" if the test is TRUE and "0" if FALSE.
C <- ifelse("test", 1, 0).
For example you can compare simultaneously 4 matrix with a complex test :
C <- ifelse(M1>0.6 & M2>0.6 & ((M3<0.3 & M3> -0.6) | (M4<0.3 & M4> -0.6)), 1, 0).