- 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 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
TAPAS
el 23 de Abr. de 2020
Comentada: Sulaymon Eshkabilov
el 23 de Abr. de 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 comentarios
Respuesta aceptada
Sulaymon Eshkabilov
el 23 de Abr. de 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 comentarios
Sulaymon Eshkabilov
el 23 de Abr. de 2020
again use the indexing option around corner boundaries with <= and >=
Más respuestas (0)
Ver también
Categorías
Más información sobre Data Analysis en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!