Compare two different data tables and extract rows

2021 1 9
1 个回答
回答已采纳
更新时间：2021 1 10
4 次查看（30 天）

0 个投票

I have two Excel file and also two different counter due to duplicate number. For example, Counter1 is 1,2,3,4,5; Counter2 is 1,2,2,3,4,5. Therefore, i wanna extract duplicate rows. Then, i would like to plot datas like plot(counter1,A1); hold on; plot(counter2,A2). My aim is display difference between 2 datas of excel files like plot(counter1,A-A). My problem is causing due to Data1 is receiving from sensor A, Data2 is receiving from sensor B.
Question: How can i match two counters? Note: For loop is take too long. I have more than 2.000.000.000 datas.

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

 采纳的回答

Cris LaPierre
Cris LaPierre 2021-1-9
编辑：Cris LaPierre 2021-1-9

0 个投票

I would use the unique function with the following syntax.
C = unique(A,___,'rows')
However, if you really have 2 billion rows, plan on any approach taking a while.

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

BERK INAN
BERK INAN 2021-1-10
I thanks a lot.
I solved this problem before you. I used unique function like you.
[C3,ia] = unique(Data1.counter1);
C4 = Data1(ia,:);

请先登录，再进行评论。

更多回答（0 个）

类别

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

产品

版本

R2020b

标签

Community Treasure Hunt

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

Start Hunting!

Translated by