keep the same row data from two matrix

2021 3 25
1 个回答
更新时间：2021 3 25
3 次查看（30 天）

0 个投票

i have a total data matrix a(253*2), now i just want to keep the data from b(223*1) and get the whole data is c(223*2), which means that keep the same data between a&b. how should i do?

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Mathieu NOE
Mathieu NOE 2021-3-25
hello
you mean c would be the first 223 rows of a ?
then this is it :
c = a(1:223,:);
zhengyang shang
zhengyang shang 2021-3-25
of course not, first need to find the data in the first row in the b and also in the first row in a, then output the c
Mathieu NOE
Mathieu NOE 2021-3-25
OK so you have to use find the get the similar values from col 1 in a and b
ind = find(a(:,1) == b);
c = a(ind,:);

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Jan
Jan 2021-3-25

0 个投票

This is a job for intersect or ismember.
[~, ia, ib] = intersect(a(:, 1), b);
c = [b(ib), a(ia, 2)]

2 个评论
显示 无 隐藏 无

zhengyang shang
zhengyang shang 2021-3-25
actually it still doesn't work because it tell me a and b are not contain same variable. i upload the data the matrix a is on the sheet1 and matrix b is on the sheet2.
Thanks so much!
Jan
Jan 2021-3-25
I cannot follow you. The tables do share at least some common data. So my code is expected to work. If it does not work for you, please post your code.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Matrices and Arrays 的更多信息

标签

评论：

Jan
Jan
2021-3-25

Community Treasure Hunt

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

Start Hunting!

Translated by