Repeated values in matrix

17 次查看（过去 30 天）
Rachel Ramirez
Rachel Ramirez 2021-1-13
评论： Rachel Ramirez 2021-1-20
Hi,
I have no idea how to approach this problem and needed some guidance. Any help would be appreciated.
Say I have a matrix/array similar to Table_1. How can I go about finding the first 5 numbers that repeat at least twice only on the FIRST column? Once found a new matrix would be generated where all values from the original matrix would be included up until the 5th value from the FIRST column that repeats at least twice is found similar to Table_2. I have no idea if this is even possible to do. Keep in mind this is just an example, matrix could be larger or smaller so I would prefer not to set a value.
Please refer to images. Thank you.
I would like to keep them as array/matrix and not use cells.
  2 个评论
David Hill
David Hill 2021-1-13
Why not stop at [7 6] since it is the fifth value that repeats twice?
Rachel Ramirez
Rachel Ramirez 2021-1-13
编辑：Rachel Ramirez 2021-1-13
oh yes! that was an error from my part. it would stop at [7 6]. Here is an updated version. I was actually thinking, I could either include all values that are in b/w even though they don't meet the condition of repeating or just generate matrix that meets the condition. Does it make sense?

请先登录，再进行评论。

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

采纳的回答

Prudhvi Peddagoni
Prudhvi Peddagoni 2021-1-19
编辑：Prudhvi Peddagoni 2021-1-19
Hi,
You can define a variable called freq, to store the frequency of the a number. Frequency of number is stored in index. You will go through the matrix until atleast 5 of these indices has a value greater than 2.
freq = zeros(100,1); %assuming the numbers in the matrix won't be greater than 100
for i = 1:length(M)
freq(M(i,1)) = freq(M(i,1))+1;
if nnz(freq>=2) >= 5
break
end
end
%now we need to remove numbers which have frequency lessthan 2
freq(freq<2) = 0;
Now you need to iterate through the original matrix . Let x be the number present in the first column. You will include this row in the final matrix if freq(x) is not equal to zero. You iterate through the original matrix until you reach the row (variable i).
Hope this helps.
  3 个评论
显示 1更早的评论
Prudhvi Peddagoni
Prudhvi Peddagoni 2021-1-19
Thanks for the help madhan. I have edited the typo.
Rachel Ramirez
Rachel Ramirez 2021-1-20
Thank you for the explanation. I tested out and seems to be working well. I'm going to see how to get the x values from the first column.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Loops and Conditional Statements 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by