Intersection of two tables

조회 수: 30 (최근 30일)
Vilém Frynta . 2023년 2월 24일
댓글: Vilém Frynta . 2023년 2월 24일
Hi,
I'm trying to intersect two tables. They share same column with strings, and I want strings that are in both of these tables (intersection).
Example tables:
A = table();
A.user = ["user1";"user2";"user3";"user4"];
A.value = [10;20;30;40]
A = 4×2 table
user value _______ _____ "user1" 10 "user2" 20 "user3" 30 "user4" 40
B = table();
B.user = ["user3";"user4";"user5"];
B.value = [300;400;500]
B = 3×2 table
user value _______ _____ "user3" 300 "user4" 400 "user5" 500
I would like to get a logical vector (index) which would tell me positions of users, that are in both tables, which are user3 and user4 in this example. Values of the users are not important here, i need only those indexes.
Although this seems simple in my head, I wasn't able to do it in Matlab. I tried using outerjoin(), ismember() and intersect(), but always some errors and empty logical vectors as results.

댓글을 달려면 로그인하십시오.

채택된 답변

Les Beckham 2023년 2월 24일
편집: Les Beckham 님. 2023년 2월 24일
A = table();
A.user = ["user1";"user2";"user3";"user4"];
A.value = [10;20;30;40]
A = 4×2 table
user value _______ _____ "user1" 10 "user2" 20 "user3" 30 "user4" 40
B = table();
B.user = ["user3";"user4";"user5"];
B.value = [300;400;500]
B = 3×2 table
user value _______ _____ "user3" 300 "user4" 400 "user5" 500
Since you say you only care about the indices but you didn't say which table you wanted them for, here are both.
idxBinA = ismember(B.user, A.user) % where members of A.user are found in B.user
idxBinA = 3×1 logical array
1 1 0
idxAinB = ismember(A.user, B.user) % where members of B.user are found in A.user
idxAinB = 4×1 logical array
0 0 1 1
Does that get you what you need?
댓글 수: 1없음 표시없음 숨기기
Vilém Frynta 2023년 2월 24일
Yes, it looks similar to what I've tried.
But I do fail when applying this solution into my code. My logical vectors are full of zeros. It appears that strings in my table are also inside a cell, which is the issue..

댓글을 달려면 로그인하십시오.

추가 답변 (1개)

편집: Askic V 님. 2023년 2월 24일
A = table();
A.user = {'user1';'user2';'user3';'user4'};
A.value = [10;20;30;40]
A = 4×2 table
user value _________ _____ {'user1'} 10 {'user2'} 20 {'user3'} 30 {'user4'} 40
B = table();
B.user = {'user3';'user4';'user5'};
B.value = [300;400;500]
B = 3×2 table
user value _________ _____ {'user3'} 300 {'user4'} 400 {'user5'} 500
ind = ismember(B.user, A.user)
ind = 3×1 logical array
1 1 0
Or you can slightly modified what @Les Beckham suggested:
A = table();
A.user = {"user1";"user2";"user3";"user4"};
A.value = [10;20;30;40]
A = 4×2 table
user value ___________ _____ {["user1"]} 10 {["user2"]} 20 {["user3"]} 30 {["user4"]} 40
B = table();
B.user = {"user3";"user4";"user5"};
B.value = [300;400;500]
B = 3×2 table
user value ___________ _____ {["user3"]} 300 {["user4"]} 400 {["user5"]} 500
idxBinA = ismember([B.user{:}], [A.user{:}])
idxBinA = 1×3 logical array
1 1 0
댓글 수: 3이전 댓글 2개 표시이전 댓글 2개 숨기기
Vilém Frynta 2023년 2월 24일
Oh I found out the problem, thanks for help!

댓글을 달려면 로그인하십시오.

카테고리

Help CenterFile Exchange에서 Lengths and Angles에 대해 자세히 알아보기

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by