Help with cell count

2 views (last 30 days)
FRANCISCO
FRANCISCO on 12 Dec 2013
Answered: Andrei Bobrov on 12 Dec 2013
I now have a cell of 95 rows. Each row is a series of numbers that I want to sort and count the number of times they are repeated.
For example:
r2 = {[1, 4, 3, 1, 1, 6]};
I using
if true
% code
[r8,r9,r10]=cellfun(@unique,r2,'un',0);
end
I get "r8" that puts me the result properly:
   r8 = {[1, 3, 4, 6]}
But I want to find the number of times each number is repeated:
NUMBER_____________________________OCCURS
1 ----------------------------------3
2 ----------------------------------0
3 ----------------------------------1
4 ----------------------------------1
5 ----------------------------------0
6 ----------------------------------1
How could I do this?
Many thanks
  2 Comments
Walter Roberson
Walter Roberson on 12 Dec 2013
Should the count be per-cell or over everything? Should the count be with respect to what was there before finding the unique values, or after the unique values (but over all the cells) ?
FRANCISCO
FRANCISCO on 12 Dec 2013
The count is for each cell, that is:
r2={ [1;4;3;1] ; [2;2;3] };
The result is:
r3={ [1 2;2 0;3 1;4 1];[1 0;2 2;3 1] };

Sign in to comment.

Accepted Answer

Andrei Bobrov
Andrei Bobrov on 12 Dec 2013
r2 = {[1, 4, 3, 1]; [2, 2, 3]};
r3 = cellfun(@(x)[(1:max(x))',accumarray(x(:),1)],r2,'un',0);

More Answers (1)

Image Analyst
Image Analyst on 12 Dec 2013
I would call unique() on the cell contents first.
out = unique(in);
If the output is the same length as the input vector, then you know that no numbers are repeated and the counts are all 1. If it's shorter, there are some repeats, so in that case I'd use unique the unique numbers as the "edges" and call histc(array, edges) to get the counts of each unique number. Not hard - give it a shot!

Categories

Find more on Data Type Conversion in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!