Sorting same rows & columns in two different matrices?

1 view (last 30 days)
Raju
Raju on 13 May 2019
Edited: dpb on 13 May 2019
I have two matrices
A =
16 2 3 13
5 11 0 8
9 7 NaN 12
4 14 15 1
B =
6 NaN 3 11
NaN 16 10 0
9 3 6 12
8 14 20 1
I want to select non-zero or no NaN values from matrix 'A'. These values are placed in certain rows:columns of the matix. I want to consider those selected rows:columns from A, and select same rows:columns in matrix B (of same szie). For small matrices, it is easier to recognise but how do we do in matrices of size 92x128. Any leads will be appreciated?

Answers (2)

KSSV
KSSV on 13 May 2019
A = [ 16 2 3 13
5 11 0 8
9 7 NaN 12
4 14 15 1];
idx = isnan(sum(A,2)) ;
% pick non nan rows
A(~idx,:)

dpb
dpb on 13 May 2019
Edited: dpb on 13 May 2019
Piece o' cake with logical indexing...
C=B(isnan(A)); % just return the values
ix=isnan(A); % return the pattern in logical array

Categories

Find more on Shifting and Sorting Matrices in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!