时间戳

首页 > 解决方案 > 合并具有不同观察数量的两个数据框并匹配它们

r - 合并具有不同观察数量的两个数据框并匹配它们

问题描述

下面的数据框显示了我通过合并的两个数据框cbindX(Period1, Period2)。两者都有相同的列，但代表两个时间段，并且对 AEZ 有不同的观察。

阿卜耶伊和安哥拉的例子

> dput(new_data2[1:6, c(1,2,3,5,7,8,9,11) ])

structure(list(AEZ_1 = c("Tropics, lowland semi-arid", "Dominantly hydromorphic soils", "Tropics, lowland sub-humid", "Tropics, lowland semi-arid", "Dominantly built-up land", "Dominantly hydromorphic soils"), Country_1 = c("Abyei", "Abyei", "Angola", "Angola", "Angola", "Angola"), File_name_1 = c("PRIO_AEZ_FS_1981_2010", "PRIO_AEZ_FS_1981_2010", "PRIO_AEZ_FS_1981_2010", "PRIO_AEZ_FS_1981_2010", "PRIO_AEZ_FS_1981_2010", "PRIO_AEZ_FS_1981_2010"), Share_1 = c(9418.132755827, 520.625044495, 616817.473747498, 278142.684969026, 1330.4290338252, 74581.3053271609), AEZ_2 = c("Tropics, lowland semi-arid", "Tropics, lowland sub-humid", "Dominantly hydromorphic soils", "Tropics, lowland sub-humid", "Tropics, lowland semi-arid", "Dominantly built-up land"), Country_2 = c("Abyei", "Abyei", "Abyei", "Angola", "Angola", "Angola"), File_name_2 = c("PRIO_AEZ_FS_2011_2040", "PRIO_AEZ_FS_2011_2040", "PRIO_AEZ_FS_2011_2040", "PRIO_AEZ_FS_2011_2040", "PRIO_AEZ_FS_2011_2040", "PRIO_AEZ_FS_2011_2040"), Share_2 = c(8475.525647713, 942.6071081139, 520.625044495, 754641.194306016, 289900.409286599, 1330.4290338252)), row.names = c(NA, 6L), class = "data.frame")

我希望匹配 Country 以查看 AEZ 随时间的变化。

图 2

谢谢

标签： rdataframemergecbind

解决方案

我的建议是：在合并之前将第一个文件（数据框）中的 AEZ 变量重命名为 AEZ_1981，将第二个文件中的相同变量重命名为 AEZ_2011。这样您就可以保留所有信息并比较合并文件中的更改。

最好的，列夫

推荐阅读