How to interleave data from 2 doubles of differing length?

Question

Cyrus Yousefian 2022-9-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1813995-how-to-interleave-data-from-2-doubles-of-differing-length

评论： Cyrus Yousefian 2022-9-28

I want to interleave 2 doubles of differing length so that I end up with 2 doubles of the same length with empty cells so when it is output to excel it shows blanks.

Say I have these two doubles.

(in my actual code A is 57x1 and B is 446x1, not sure if that helps?)

A=[1;2;11;20];
B=[3;4;5;6;7;8;9;10;12;13;14;15;16;17;18;19];

I want to end up with

(not sure what an empty cell is for doubles, NaN maybe?)

A=[1;2;blank;blank;blank;blank;blank;blank;blank;blank;11;blank;blank;blank;blank;blank;blank;blank;blank;20];
B=[blank;blank;3;4;5;6;7;8;9;10;blank;12;13;14;15;16;17;18;19];

I do not care if the result is a double or a cell matrix.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Jan 2022-9-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1813995-how-to-interleave-data-from-2-doubles-of-differing-length#answer_1062755

在 MATLAB Online 中打开

A=[1420;2956;4492;6028];
B=[2960;3152;3344;3536;3728;3920;4112;4304;4496;4688;4880;5072;5264;5456;5648;5840];
[C, idx] = sort([A; B]);
idxa     = (idx <= numel(A));
AB       = NaN(numel(C), 2);
AB(idxa, 1)  = A;
AB(~idxa, 2) = B;
AB
AB = 20×2
        1420         NaN
        2956         NaN
         NaN        2960
         NaN        3152
         NaN        3344
         NaN        3536
         NaN        3728
         NaN        3920
         NaN        4112
         NaN        4304