- 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
1 ビュー (過去 30 日間)
表示 古いコメント
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 件のコメント
採用された回答
Sulaymon Eshkabilov
2020 年 4 月 23 日
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 件のコメント
Sulaymon Eshkabilov
2020 年 4 月 23 日
again use the indexing option around corner boundaries with <= and >=
その他の回答 (0 件)
参考
カテゴリ
Find more on Earth, Ocean, and Atmospheric Sciences in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!