How to set bottom repeating elements in matrix to NaN?

Question

Sushil Pokharel 2022-6-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1741915-how-to-set-bottom-repeating-elements-in-matrix-to-nan

移动：Dyuman Joshi 2023-8-26

采纳的回答： Voss

I have matrix of large size and I need to change the bottom repeating elements to nan. For instance:

a = [ 1 2 3 2 1 3

3 1 1 3 1 2

1 2 3 3 2 1

1 2 1 2 1 3

1 2 3 1 2 1];

In this matrix, I want to change the bottom repeating numbers. If the numbers are repeating on top, I don't want to do anything to them. Just want to replace the bottom repeating number by NaNs. Any help will be greatly appreciated.

Thank you.

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

Dyuman Joshi 2022-6-16

移动：Dyuman Joshi 2023-8-26

Okay. Just a note - If you want a general answer, do mention information explicitly. Answers will always be tailored according to the information you give. So limited data results in particular answer rather than a general solution.

I could only understand what you want to obtain after you gave another example above. Nonetheless, you got your answer.

Sushil Pokharel 2022-6-16

移动：Dyuman Joshi 2023-8-26

@Dyuman Joshi you are absolutely right. Sorry for the inconvenience.

请先登录，再进行评论。

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

Answer 1

Voss 2022-6-16

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1741915-how-to-set-bottom-repeating-elements-in-matrix-to-nan#answer_987220

在 MATLAB Online 中打开

a = [ 1 2 3 2 1 3        
    3 1 1 3 1 2
    1 2 3 3 2 1
    1 2 1 2 1 3
    1 2 3 1 2 1];
to_nan = cummin(a(1:end-1,:) == a(end,:),1,'reverse');
to_nan = to_nan([1:end end],:);
a(to_nan) = NaN
a = 5×6
     1     2     3     2     1     3
     3     1     1     3     1     2
   NaN   NaN     3     3     2     1
   NaN   NaN     1     2     1     3
   NaN   NaN     3     1     2     1

4 个评论
显示 2更早的评论隐藏 2更早的评论

Voss 2022-6-16

在 MATLAB Online 中打开

cummin is cumulative minimum. The second argument 1 tells it to operate in an up/down direction and 'reverse' tells it to go up from the bottom. So start at the bottom of the matrix and keep track of the running minimum value in each column. For example:

A = magic(5)
A = 5×5
  24     1     8    15
   5     7    14    16
   6    13    20    22
  12    19    21     3
  18    25     2     9
cummin(A,1,'reverse')
ans = 5×5
   5     1     2     3
   5     7     2     3
   6    13     2     3
  12    19     2     3
  18    25     2     9

So it's the smallest value encountered in each column of A as you start at the bottom and move up.

Now, I'm doing that on a logical matrix that says whether each element of the last row of your a is equal to the element of each other other row (in the same column):

a = [ 1 2 3 2 1 3        
1 1 3 1 2
2 3 3 2 1
2 1 2 1 3
2 3 1 2 1]
a = 5×6
   2     3     2     1     3
   1     1     3     1     2
   2     3     3     2     1
   2     1     2     1     3
   2     3     1     2     1
a(1:end-1,:) == a(end,:)
ans = 4×6 logical array
 1   1   0   0   0
 0   0   0   0   0
 1   1   0   1   1
 1   0   0   0   0

Imagine starting at the bottom of that matrix and going up, keeping track of the minimum value encountered so far in each column as you go up. As soon as you hit a zero, you'll get zeros the whole rest of the way, since there's not going to be anything less than that.

cummin(a(1:end-1,:) == a(end,:),1,'reverse')
ans = 4×6 logical array
   0   0   0   0   0   0
   0   0   0   0   0   0
   1   1   0   0   0   0
   1   1   0   0   0   0

And if you have a one in the output, it means you haven't hit a zero yet (i.e., it's ones all the way down).

When the cumulative minimum, going up from the bottom like that, is one, that means that the element there is equal to the element at the bottom of the column (since the cumulative minimum is of the comparison of rows of a, and where they are not equal, the value of a(1:end-1,:) == a(end,:) would be 0, which is less than 1). On the other hand, when the cumulative minimum is zero, that means that the element there is not equal to the element at the bottom of the column.

Therefore, the matrix above tells you where you have elements equal to and contiguous with the element at the bottoms of their respective columns.

Note that I'm using a(1:end-1,:), and not a(1:end,:) - which is just a - in the comparison. That is, I'm not comparing the last row to itself, because that would be like considering all values in the last row of a to be repeats (i.e., repeated once), which you wanted to avoid. So cummin(a(1:end-1,:) == a(end,:),1,'reverse') has one fewer row than a does, so to get the right result I append the last row of it to the end in the next line:

to_nan = to_nan([1:end end],:);

and use that to logical index into a to set those locations to NaN:

a(to_nan) = NaN

Sushil Pokharel 2022-6-17

hi @Voss, I really appreciate your help. now I have clear understanding about the code. Thank you so much for your help.

Voss 2022-6-17

You're welcome!

请先登录，再进行评论。

How to set bottom repeating elements in matrix to NaN?

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

采纳的回答

4 个评论
显示 2更早的评论隐藏 2更早的评论

更多回答（0 个）

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

How to set bottom repeating elements in matrix to NaN?

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

采纳的回答

4 个评论 显示 2更早的评论隐藏 2更早的评论

更多回答（0 个）

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

WeChat

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

4 个评论
显示 2更早的评论隐藏 2更早的评论