Compare two different data tables and extract rows

8 次查看（过去 30 天）
BERK INAN
BERK INAN 2021-1-9
评论： BERK INAN 2021-1-10
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
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 个评论
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 个）

类别

在 Help Center 和 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