extract data based on certain range of other coloumn

2 次查看（过去 30 天）
TAPAS
TAPAS 2020-4-23
评论： Sulaymon Eshkabilov 2020-4-23
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.

请先登录，再回答此问题。

采纳的回答

Sulaymon Eshkabilov
The answer is quite simple;
  1. Import data: D=xlsread('data.xlsx');
  2. Sort out the data w.r.t the conditions using logical indexing e.g.:
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 个评论
显示 1更早的评论
TAPAS
TAPAS 2020-4-23
Can I extract data bounded by an area like here inthis case if the lat long value of the four corner of the area is Corner 1:-lon=105.475 lat=32.549 Corner 2:-lon=102.987 lat=30.697 Corner 3:-lon=102.761 lat=30.919 Corner 4:-lon=105.249 lat=32.771 I want to extract data within the area which is bounded by these four corner. Can you do this?
Sulaymon Eshkabilov
Sulaymon Eshkabilov 2020-4-23
again use the indexing option around corner boundaries with <= and >=

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Read, Write, and Modify Image 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by