Info

This question is closed. Reopen it to edit or answer.

half the first NaN value after the last non NaN value in each column

1 view (last 30 days)
Hi, I have a matrix
p = [NaN 2 NaN;
2 4 NaN;
2 6 8;
NaN 8 2;
NaN NaN 1;
NaN NaN 1]
The realized matrix
p1 = [NaN 2 NaN;
2 4 NaN;
2 6 8;
1(half of 2) 8 2;
NaN 4(half of 8) 1;
NaN NaN 1]
... Notice: Only the first NaN after the last non NaN value in each column is halved with the last non NaN value.. while the other NaN stay as they were.. Thank you for your answers. BR

Answers (2)

Jan
Jan on 30 Nov 2015
Edited: Jan on 30 Nov 2015
p = [NaN 2 NaN;
2 4 NaN;
2 6 8;
NaN 8 2;
NaN NaN 1;
NaN NaN 1];
m = isnan(p);
for col = 1:size(p, 2)
index = strfind(m(:, k).', [false, true]); % [EDITED]
if ~isempty(index)
p(index(1) + 1, k) = p(index(1), k) / 2;
end
end
  2 Comments
Jan
Jan on 30 Nov 2015
Please, Qian cao, giv us any chance to post an improvement. Tell us, what goes wrong. Do you get an error message or does the result differ from your expectations? I see a little typo, which is fixed now. So try it again.

Thorsten
Thorsten on 30 Nov 2015
ind = diff(isnan([p; p(end,:)])) == 1;
p(ind) = p(ind)/2;
  2 Comments
Qian cao
Qian cao on 30 Nov 2015
No...it should be the cell after p(ind)...I tried with p(ind+1) = p(ind)/2; But it does not work...Could you help me ? In your result, the last non NaN is replaced...but I need to keep it and just fill the cell after it in the column with a value that is half of it...
Thorsten
Thorsten on 30 Nov 2015
Edited: Thorsten on 30 Nov 2015
Use
ind = find(diff(isnan([p; p(end,:)])) == 1);
p(ind+1) = p(ind)/2;

Community Treasure Hunt

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

Start Hunting!