extract data based on certain range of other coloumn

Question

TAPAS 2020-4-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/520209-extract-data-based-on-certain-range-of-other-coloumn

评论： 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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Sulaymon Eshkabilov 2020-4-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/520209-extract-data-based-on-certain-range-of-other-coloumn#answer_427935

The answer is quite simple;

Import data: D=xlsread('data.xlsx');
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更早的评论隐藏 1更早的评论

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 2020-4-23