Intersection of two tables

19 次查看（过去 30 天）
Vilém Frynta
Vilém Frynta 2023-2-24
评论： Vilém Frynta 2023-2-24
Ran in:
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
Les Beckham 2023-2-24
编辑：Les Beckham 2023-2-24
Ran in:
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
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
Askic V 2023-2-24
编辑：Askic V 2023-2-24
Ran in:
Maybe this code can help you:
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 个评论
显示 1更早的评论
Vilém Frynta
Vilém Frynta 2023-2-24
I have even converted the table column into a string, to get rid of the cell.
Still not possible. I'm trying to intersect 21x1 string and 28x1 string and still it doesn't work. Not with ismember and and interesct. :(
Vilém Frynta
Vilém Frynta 2023-2-24
Oh I found out the problem, thanks for help!

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Environment and Settings 的更多信息

标签

产品


版本

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by