How do I get an index like with ismember, but with values representing the number of occurances?

3 views (last 30 days)
I have some vectors, let's call them A and B, and I want to find all elements of A contained within B. So far I've gotten an logical index of all the unique elements, but I need to go one step further and count up repetitions as well. So for instance:
A = ['monday', 'tuesday', 'thursday', 'monday']
B = ['monday', 'tuesday', 'wednesday', 'thursday', 'friday', 'saturday', 'sunday']
Index = [2 1 0 1 0 0 0]

Accepted Answer

Stephen23
Stephen23 on 1 Mar 2017
Edited: Stephen23 on 1 Mar 2017
>> A = {'monday', 'tuesday', 'thursday', 'monday'};
>> B = {'monday', 'tuesday', 'wednesday', 'thursday', 'friday', 'saturday', 'sunday'};
>> idx = cellfun(@(s)nnz(strcmp(A,s)),B)
idx =
2 1 0 1 0 0 0

More Answers (1)

Steven Lord
Steven Lord on 1 Mar 2017
A = {'monday', 'tuesday', 'thursday', 'monday'};
B = {'monday', 'tuesday', 'wednesday', 'thursday', 'friday', 'saturday', 'sunday'};
Ac = categorical(A, B);
Bc = categorical(B);
histcounts(Ac, Bc)
If your data is numeric you can skip the categorical steps, though you will need to add an extra element to the end of the second input. For categorical data, histcounts uses each category as a bin; for numeric data, it uses the second input as the edges of the bin. By default the leftmost edges are included in the bins. The extra element will be the rightmost edge of the last bin and will catch elements equal to the next to last element of the edges vector.
A = [1 2 4 1];
B = [1:7 Inf];
histcounts(A, B)

Categories

Find more on Categorical Arrays in Help Center and File Exchange

Products

Community Treasure Hunt

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

Start Hunting!