how to delete the duplicated rows (in a specific way)?
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Amr Hashem
il 16 Mag 2015
Modificato: Andrei Bobrov
il 16 Mag 2015
i have this table (size:8*6 & cells):
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/150181/image.png)
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):
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/150183/image.jpeg)
i have a larger data this is a sample, I hope that pictures clarify the problem.
0 Commenti
Risposta accettata
Andrei Bobrov
il 16 Mag 2015
Modificato: Andrei Bobrov
il 16 Mag 2015
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 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Environment and Settings in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!