Could you help me solving the question regarding to coordinates, please?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Let's say I have such points:
- A=(2,4)
- B=(2,10)
- C=(2,15)
- D=(5,14)
- E=(6,7)
- F=(6,15)
- G=(8,16)
- H=(8,10)and I just want to select unique points which are A,B,C,D,E and G. I want to eliminate F and H because I've already used 6 in E and 15 in C for F; 8 in G and 10 in B.
Thanks for your time!
2 commentaires
Patrik Ek
le 17 Mar 2014
Ok you mean so that you can perform operations like,?
M(allSelectedPoints) = 42;
Réponse acceptée
Mischa Kim
le 17 Mar 2014
Modifié(e) : Mischa Kim
le 17 Mar 2014
Rengin, use
data = [2,4;
2,10;
2,15;
5,14;
6,7;
6,15;
8,16;
8,10];
[C,ia,ic] = unique(data(:,2));
data_elim = sortrows(data(ia,:),1)
Addendum: the below snippet shows how to read from and write to an Excel file.
data = xlsread('test.xlsx',1); % read from sheet 1
[C,ia,ic] = unique(data(:,2));
data_elim = sortrows(data(ia,:),1);
xlswrite('test.xlsx',data_elim,2); % write to sheet 2
4 commentaires
Mischa Kim
le 17 Mar 2014
I see. This one produces the result you're looking for:
data_elim = data;
for ii = 2:length(data(:,1))
if sum(ismember(data(ii,:),data(1:ii-1,:))) == 2
data_elim(ii,:) = [NaN NaN];
end
end
data_elim(all(isnan(data_elim(:,1)),2),:) = [];
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!