Replace values in a matrix with ones from other matrix based on some criteria

1 次查看(过去 30 天)
Hello, I would appreciate any help to solve this problem. Lets say i have one matrix - A in such form Nan,0,0; Nan,0,0; 37,0,0; 0,0,0;
and another matrix - B, of the same size with some values. What i try to do is to replace Nan with values from B according to the value after Nan. It means that if i have 37, previous Nans should be replaced with correponding values of B from 37 column. So, basically in each column i have a number of Nan rows followed by some number that indicates from which column of B Nan should be replaced to corresponding values. Could you please help me. Thanks beforehand!

回答(4 个)

Iain
Iain 2014-8-27
A(isnan(A)) = B(isnan(A));

Andrei Bobrov
Andrei Bobrov 2014-8-27
i0 = isnan(A);
[ii,jj] = find(i0);
A(i0) = B(sub2ind(size(B),ii+1,jj));

Azzi Abdelmalek
Azzi Abdelmalek 2014-8-27
ii=isnan(A)
A(ii)=B(ii+1)

Olga
Olga 2014-8-27
Was not successful, unfortunately :(

类别

Help CenterFile Exchange 中查找有关 Matrix Operations and Transformations 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by