- 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 (최근 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개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Analysis에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!