MATLAB Table - Unique lookup from multiple instances

2 次查看（过去 30 天）
Nicholas Thomason
Nicholas Thomason 2022-5-27
编辑： Voss 2022-6-1
Hi all
I have a Table. In column 1 there are multiple instances of some double (an "ID"). Each of these IDs is uniquely paired with another number in column 2. I want to collapse this Table in to just one ID in column 1, paired with its match from column 2.
so for example:
TABLE1
col1 col2
a 3
a 3
a 3
b 9
b 9
c 27
c 27
RESULT: TABLE2
col1 col2
a 3
b 9
c 27
any help is much appreciated! thank you!

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

采纳的回答

Voss
Voss 2022-5-27
Ran in:
TABLE1 = table( ...
{'a';'a';'a';'b';'b';'c';'c'}, ...
[3;3;3;9;9;27;27], ...
'VariableNames',{'col1' 'col2'})
TABLE1 = 7×2 table
col1 col2 _____ ____ {'a'} 3 {'a'} 3 {'a'} 3 {'b'} 9 {'b'} 9 {'c'} 27 {'c'} 27
TABLE2 = unique(TABLE1) % or unique(TABLE1,'rows')
TABLE2 = 3×2 table
col1 col2 _____ ____ {'a'} 3 {'b'} 9 {'c'} 27

更多回答（0 个）

类别

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

标签

产品


版本

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by