Merge two matrices of different length with respect to a date

1 次查看（过去 30 天）
BeeTiaw
BeeTiaw 2019-7-27
评论： BeeTiaw 2019-7-27
Hi,
I want to merge these two datasets. It is slightly different with this one: https://uk.mathworks.com/matlabcentral/answers/316710-can-i-merge-two-matrices-of-different-length-with-respect-to-a-date-column-contained-in-both
Instead of trying to get the combination of the two based on the shortest length, I want to instead maintain the longest matrix and give a NaN values for the shortest matrix. This is my data:
A = [
2000 1
2001 1
2002 1
2003 1
2004 1
2005 1
2006 1
2007 1
2008 1
2009 1
2010 1
];
B = [
2005 3
2006 3
2007 3
2008 3
2009 3
2010 3
];
I am expecting the output to be like this one below:
AB = [
2000 1 NaN
2001 1 NaN
2002 1 NaN
2003 1 NaN
2004 1 NaN
2005 1 3
2006 1 3
2007 1 3
2008 1 3
2009 1 3
2010 1 3
];
How can we do this?

请先登录，再回答此问题。

采纳的回答

Andrei Bobrov
Andrei Bobrov 2019-7-27
AB = outerjoin(array2table(A,'v',{'years','dataA'}),...
array2table(B,'v',{'years','dataB'}),'MergeKeys',true)

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Graph and Network Algorithms 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by