How to check if a column data is equal to any of a group of values?

13 vues (au cours des 30 derniers jours)
Leon
Leon le 3 Oct 2020
Modifié(e) : madhan ravi le 3 Oct 2020
I have a column data A like the below:
A = [1; 3; 2; 7; 11; 6];
B can be a group of numbers with unknow counts. For example B can be like the below:
B = [1; 7];
Here is my question. How do I come up with an index to show the elemens of A that can be any of B? For example if I know B has two elements, I can use something like the below, but B can have an unknown number of elements.
Ind1 = A == B(1);
Ind2 = A == B(2);
Ind = Ind1 + Ind2;

Réponses (4)

Sulaymon Eshkabilov
Sulaymon Eshkabilov le 3 Oct 2020
Hi,
Ind = sum(Ind1) + (Ind2);
  1 commentaire
Leon
Leon le 3 Oct 2020
Thanks!
Is there a better way to do this? B has an unknown number of elements, not necessarily 2.

Connectez-vous pour commenter.


Sulaymon Eshkabilov
Sulaymon Eshkabilov le 3 Oct 2020
You can use a loop for instance if you have many Bs, e.g.:
for ii = 1:numel(B)
Ind = A==B(ii); S(ii) = sum(Ind(:));
end
S_all=sum(S); % Total number of observed cases
  2 commentaires
Leon
Leon le 3 Oct 2020
Modifié(e) : Leon le 3 Oct 2020
Thank you. Unfortunately, it did not work. Were you trying to ask me to do something like this?
for i=1:numel(B)
Ind(:,i) = A==B(i);
end
S = sum(Ind,2);
The problem is that after we sum the logical valeus, I get this error. It seems the function sum messed it up.
Array indices must be positve integers or logical values.
Anyone knows how to find the indices without writing a loop? Many thanks.
Sulaymon Eshkabilov
Sulaymon Eshkabilov le 3 Oct 2020
You have edited the code that I've provide incorrectly.

Connectez-vous pour commenter.


Sulaymon Eshkabilov
Sulaymon Eshkabilov le 3 Oct 2020
Altenrative (more efficient one) solution can be this one:
S = sum(sum(ismember(A,B)))

madhan ravi
madhan ravi le 3 Oct 2020
Modifié(e) : madhan ravi le 3 Oct 2020
clear sum
Ind = sum(ismember(A, B), 2)
%Or perhaps you need
Ind = nnz(ismember(A, B))
%or
fprintf('%d occurs %d times/s\n', [B.'; sum(A == B.')])

Catégories

En savoir plus sur Matrix Indexing dans Help Center et File Exchange

Tags

Produits


Version

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by