首页 > 解决方案 > 为什么 all.equal 在两个数据集之间的数字列中显示平均相对差异,但是

问题描述

分别计算两列的平均值表明它们是相同的?

我无法在虚构的数据集上复制它,并且该数据集是适当的。这是唯一出现的评论。

数据中有 NA,某些行的顺序不同。

有人遇到过这种情况么?

根据下面的评论,我改进了我的问题:我的动机是看看两者之间的输出是否有任何差异:

1)

merged_dt1= merge.data.table(dta, dtb, all = T, by = c("col1", "col2"))

merged_dt2= merge.data.table(merged_dt1, dtc, all = T, by = c("col1", "col2"))
merged_dt1= merge(dta[, .(col1, col2)], dtb[, .(col1, col2)], 
all = TRUE, by = c("col1", "col2")))

merged_dt2 = merge(merged_dt1, dta, all.x = TRUE, by = c("col1", "col2"))
  
merged_dt2 = merge(merged_dt2 , dtb, all.x = TRUE, by = c("col1", "col2"))
 
merged_dt3 = merge(merged_dt1, dtc, all = TRUE, by = c("col1", "col2"))
 
merged_dt4 = merge(merged_dt3 , merged_dt2, all = TRUE, keyby = c("col1", "col2"))

标签: r

解决方案


推荐阅读