- Import data: D=xlsread('data.xlsx');
- Sort out the data w.r.t the conditions using logical indexing e.g.:
extract data based on certain range of other coloumn
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
TAPAS
le 23 Avr 2020
Commenté : Sulaymon Eshkabilov
le 23 Avr 2020
I have attached an xlsx file which have four coloumns the first two coloumn are latitude and longitude .I want to extract data based on the condition 102.7<=long<=105.2 and 30.6<=lat<=32.2.
0 commentaires
Réponse acceptée
Sulaymon Eshkabilov
le 23 Avr 2020
The answer is quite simple;
Lat = D(:,1);
Lon = D(:,2);
DN = D(:,3);
DE=D(:,4);
HD=D(:,5);
DD=D(:, 6);
Index =Lon>= 102.7 & Lon<=105.2 & Lat>=30.6 & Lat<=32.2;
DNnew=DN(Index);
DEnew = DE(Index);
etc.. etc.
3 commentaires
Sulaymon Eshkabilov
le 23 Avr 2020
again use the indexing option around corner boundaries with <= and >=
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Structures 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!