MATLAB Answers

Merge two matrices of different length with respect to a date

2 views (last 30 days)
BeeTiaw
BeeTiaw on 27 Jul 2019
Commented: BeeTiaw on 27 Jul 2019
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?

  0 Comments

Sign in to comment.

Accepted Answer

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

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by