MATLAB Answers

Merge two matrices of different length with respect to a date

7 ビュー (過去 30 日間)
BeeTiaw
BeeTiaw 2019 年 7 月 27 日
コメント済み: BeeTiaw 2019 年 7 月 27 日
Hi,
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)
  1 件のコメント
BeeTiaw
BeeTiaw 2019 年 7 月 27 日
Thank you! this one works like magic.

サインインしてコメントする。

その他の回答 (0 件)

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by