我遇到了两个要合并的数据框的问题 . 一个比另一个大,但它们共享公共列名和rownames .
我想要做的是通过每行和每列中的特定元素合并它们 .
例如,我有1个数据框: row.names-US Bond,US Stock,EU Bond,EU Stock,Asia Bond,Asia Stock,col.names-Price Risk,Credit Risk,Market Risk;
其他数据框: row.names-US Bond,US Stock;col.names-Price Risk;
理想情况下,我想通过其唯一的行名和列名合并两个数据集 .
样品:
dat1<-matrix(' ',nrow=4,ncol=6)
colnames(dat1)<-c("Value","Percentage","Credit.Risk","Interest.Risk","Interest.Credit.Risk","Total")
rownames(dat1)<-c("Low.Gov.Debt","Low.Corp.Debt","High.Gov.Debt","High.Corp.Debt")
new<-portfolio
rownames(new)<-c("High.Gov.Debt","Low.Gov.Debt")
colnames(new)<-c("Value")
1 回答
您需要通过
row.names
指定匹配