Set specific values to NaN

Question

Sascha Winter 2017-4-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/335208-set-specific-values-to-nan

编辑： Peter Strassmann 2020-10-19

采纳的回答： Stephen23

在 MATLAB Online 中打开

Hello everyone

My problem is as follows. I have a matrix like this for example:

A = [1 2 3 4 5 6 6 6 6; 
4 3 5 4 6 7 7 7; 
4 4 4 3 7 8 8 8; 
1 3 3 3 3 3 3 5]'

Now i want to get a matrix which deletes the values which are similar (starting with the second) untill the end of the column. So columns 1, 2, 3 should delete some values while column 4 shouldn't delete any numbers.

At the end the matrix should look like this

A = [1 2 3 4 5 6 NaN NaN NaN; 
4 3 5 4 6 7 NaN NaN; 
4 4 4 3 7 8 NaN NaN; 
1 3 3 3 3 3 3 5]'

I hope you get my problem. Thanks in Advance.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Peter Strassmann 2020-10-19

编辑：Peter Strassmann 2020-10-19

在 MATLAB Online 中打开

Be aware that NaN values are only defined for data with single or double precision! It is resets integers to zero, e.g. uint8, int8.

rng(1);
A=randi([0,8], [100,1], "int8");
%A=double(A);
A(A>2)=nan;

If you want to associate NaN values to such data, you have to convert them first (before the remapping) with single(A) or double(A) into values with the according precision.

请先登录，再进行评论。

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

Answer 1

Stephen23 2017-4-13

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/335208-set-specific-values-to-nan#answer_262905

编辑：Stephen23 2017-4-14

在 MATLAB Online 中打开

>> A = [1,2,5,2;2,4,4,1;3,3,4,3;4,5,4,3;5,4,3,3;6,6,7,3;6,7,8,3;6,7,8,3;6,7,8,5];
>> idx = cumprod(double(diff(flipud(A))==0),1);
>> idx(end+1,:) = false;
>> idx = logical(flipud(idx));
>> A(idx) = NaN
A =
     1     2     5     2
     2     4     4     1
     3     3     4     3
     4     5     4     3
     5     4     3     3
     6     6     7     3
   NaN     7     8     3
   NaN   NaN   NaN     3
   NaN   NaN   NaN     5

5 个评论
显示 3更早的评论隐藏 3更早的评论

Stephen23 2017-4-14

在 MATLAB Online 中打开

Try this:

   A = [1,2,3,4,5,6,6,6,6; 3,4,4,4,5,6,6,2,1; NaN,NaN,2,4,5,6,6,6,6; 1,2,2,2,2,2,NaN,NaN,NaN; NaN,NaN,NaN,NaN,NaN,NaN,NaN,NaN,NaN]'
  idx = diff(flipud(A));
  idx = cumprod(double(idx==0|isnan(idx)),1);
  idx(end+1,:) = isnan(A(1,:));
  idx = logical(flipud(idx));
  A(idx) = NaN

which outputs this:

A =
   1     3   NaN     1   NaN
   2     4   NaN     2   NaN
   3     4     2   NaN   NaN
   4     4     4   NaN   NaN
   5     5     5   NaN   NaN
   6     6     6   NaN   NaN
 NaN     6   NaN   NaN   NaN
 NaN     2   NaN   NaN   NaN
 NaN     1   NaN   NaN   NaN