count frequency of each unique occurence in an Nx2 matrix

1 次查看（过去 30 天）
lmac456
lmac456 2017-9-7
评论： ZIJIAN HE 2018-11-17
I have a data set where each point is described by two unique numbers (call it a and b), and I need to count the number of times each combination of these two numbers occurs. For example if I had 6 points that were described by
mat = [1 1 ; 1 3 ; 2 3; 2 1; 1 2; 1 3]
where a is the first column and b is the second column, I want to know how many times a specific combo occurs. I know I can get the count of one number in a column doing something like this:
sum(mat(:,1)==1)
sum(mat(:,2)==3)
which would return 4 and 3, respectively, but I want to count how many times the combo (1, 3) occurs, which would be 2 for this list.

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

采纳的回答

Jacob Ward
Jacob Ward 2017-9-7
You could iteratively test each row for the combo you are looking for, adding 1 to the total each time a match is found, like so:
mat = [1 1; 1 3; 2 3; 2 1; 1 2; 1 3];
totalOccurences = 0;
for i = 1:length(mat(:,1))
if mat(i,:)==[1 3]
totalOccurences = totalOccurences+1;
end
end
At the end of this code, totalOccurences = 2, which is the result you wanted to get in your example.

更多回答（1 个）

Steven Lord
Steven Lord 2017-9-7
If these are always going to be integer values, use histcounts2.

类别

在 Help Center 和 File Exchange 中查找有关 MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by