ismember(A,B,'rows') indexing
조회 수: 14 (최근 30일)
이전 댓글 표시
Hello everyone,
I would like to compare two cells, want to see if element of A is a member of B, If yes then it should return 1 otherwise 0.
Size of A is 189x1 and Size of B is 108x1.
I used:
C = ismember(A,B,'rows');
It returned logical o,1. With Size of 189x1, Perfect.
But now. I want Values of B (108x1) sorted same like C with Size 189x1.
Any help would be appreciated.
Thank you.
Regard,s
Waqar Ali
댓글 수: 4
dpb
2019년 7월 11일
Well, that's easy enough -- add 81 elements on the end. The question is, what are the new elements to contain? I don't see there's any correlation between the two requests.
채택된 답변
Stephen23
2019년 7월 11일
편집: Stephen23
2019년 7월 11일
>> one = {'ADSµSOIC8';'AVX0603';'ELN';'ELNH10';'EPC';'EPC0603';'FAGDO214AA';'FAGDO214AA (SMB)';'FAGDO214AB';'FAGDO214AC';'FAGSMA';'FAGSOD123W';'FAGSOD128';'FSLLQFP-64 ePAD';'FSLLQFP80-ePad'}
one =
'ADSµSOIC8'
'AVX0603'
'ELN'
'ELNH10'
'EPC'
'EPC0603'
'FAGDO214AA'
'FAGDO214AA (SMB)'
'FAGDO214AB'
'FAGDO214AC'
'FAGSMA'
'FAGSOD123W'
'FAGSOD128'
'FSLLQFP-64 ePAD'
'FSLLQFP80-ePad'
>> two = {'ADSµSOIC8','1';'AVX0603','3';'ELN','2';'EPC','2';'EPC0603','3';'FAGDO214AA','10';'FAGDO214AC','1';'FAGSOD123W','5';'FAGSOD128','2';'FSLLQFP-64 ePAD','1'}
two =
'ADSµSOIC8' '1'
'AVX0603' '3'
'ELN' '2'
'EPC' '2'
'EPC0603' '3'
'FAGDO214AA' '10'
'FAGDO214AC' '1'
'FAGSOD123W' '5'
'FAGSOD128' '2'
'FSLLQFP-64 ePAD' '1'
>> [X,Y] = ismember(one,two);
>> out = one;
>> out(:,2) = {'0'};
>> out(X,2) = two(Y(X),2)
out =
'ADSµSOIC8' '1'
'AVX0603' '3'
'ELN' '2'
'ELNH10' '0'
'EPC' '2'
'EPC0603' '3'
'FAGDO214AA' '10'
'FAGDO214AA (SMB)' '0'
'FAGDO214AB' '0'
'FAGDO214AC' '1'
'FAGSMA' '0'
'FAGSOD123W' '5'
'FAGSOD128' '2'
'FSLLQFP-64 ePAD' '1'
'FSLLQFP80-ePad' '0'
댓글 수: 4
Guillaume
2019년 7월 11일
편집: Guillaume
2019년 7월 11일
One must wonder why an answer is accepted to then say it doesn't work.
As I've pointed out in my answer, you haven't given us enough details to know what you're doing exactly, so it's likely that no answer will work straight out of the box, but you should be able to work it out from there.
As said, you need to use the 2nd return value of ismember.
I'd recommend you not use X and Y as variable names but soemthing more meaningful
추가 답변 (2개)
joe
2019년 7월 11일
function result = compareMatrices( A,B)
result = zeros(size(A,1),size(B,2)); % generate matrix with the same size as the A
for i=1:numel(A) % this loop checkes the existens of all elements of A in B
[~,index]=ismember(A{i,1},B);
if index~=0 % if any element of A exists in B
result{i,1} = 1; % set 1 in the same position where the existens detected
end
end
end
댓글 수: 5
joe
2019년 7월 11일
if you have matrices with elements of deferent types
try to call the function like this: compareMatrices(string(A), string(B))
Guillaume
2019년 7월 11일
If the two cell arrays don't have the same number of columns, you're obviously not using ismember(A, B, 'rows') but something slightly more complex. I'm taking a guess here.
You also haven't said what needs to go in the result, when the row of A is not found in B.
In any case, you just have to use the 2nd output of ismember
[isfound, where] = ismember(A(:, 1), B(:, 1)); %compare column 1 of A and column 1 of B
C = [A(isfound), B(where(isfound), 3)]; %get rows of A found in B together with the matching value of column 3 of B
Adapt as necessary.
참고 항목
카테고리
Help Center 및 File Exchange에서 Matrix Indexing에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!