清空筛选条件
清空筛选条件

how to delete the duplicated rows (in a specific way)?

1 次查看（过去 30 天）
Amr Hashem
Amr Hashem 2015-5-16
编辑： Andrei Bobrov 2015-5-16
i have this table (size:8*6 & cells):
and i want to delete duplicated rows with saving the 6th column in the original row.
i want the answer to be (table, size(5*8) , cell):
i have a larger data this is a sample, I hope that pictures clarify the problem.

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

采纳的回答

Andrei Bobrov
Andrei Bobrov 2015-5-16
编辑：Andrei Bobrov 2015-5-16
a = [text{:,1}];
m = numel(a);
[~,b1,c1] = unique(a,'first');
n = ones(m,1);
n(b1(2:end)) = 1-diff(b1);
i1 = accumarray([c1, cumsum(n)],(1:m)',[],[],m+1);
txt1 = [text(:,6);{''}];
out = [text(b1,1:5),tx1(i1)];

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by