[R] merging tables based on both row and column names
C Lin
baccts at hotmail.com
Mon Sep 28 20:46:18 CEST 2015
Dear R users,
I am trying to merge tables based on both their row names and column names.
My ultimate goal is to build a distribution table of values for each combination of row and column names.
I have more test tables, more x's and y's than in the toy example below.
Thanks in advance for your help.
For example :
test1 <- data.frame(rbind(c(0.1,0.2),0.3,0.1))
rownames(test1)=c('y1','y2','y3')
colnames(test1) = c('x1','x2');
test2 <- data.frame(rbind(c(0.8,0.9,0.5),c(0.5,0.1,0.6)))
rownames(test2) = c('y2','y5')
colnames(test2) = c('x1','x3','x2')
test1
x1 x2
y1 0.1 0.2
y2 0.3 0.3
y3 0.1 0.1
test2
x1 x3 x2
y2 0.8 0.9 0.5
y5 0.5 0.1 0.6
I would like to combine test1 and test2 such that if the column name and row name are both the same they are combined.
combined_test
x1 x2 x3
y1 0.1 0.2 NA
y2 (0.3,0.8) (0.3,0.5) 0.9
y3 0.1 0.1 NA
y5 0.5 0.6 0.1
More information about the R-help
mailing list