Merge two matrices of different length with respect to a date

1 vue (au cours des 30 derniers jours)
BeeTiaw
BeeTiaw le 27 Juil 2019
Commenté : BeeTiaw le 27 Juil 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?

Réponse acceptée

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

Plus de réponses (0)

Catégories

En savoir plus sur Language Fundamentals dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by