How do I separate negative datas with their row?

2021 6 14
1 个回答
回答已采纳
更新时间：2021 6 14
2 次查看（30 天）

0 个投票

First 2 rows contain the long/lat;third row contains the land/water values. I want to separate the files into land and water xyz files for bathymetry use therfore I need the negative values from the 3rd column and their respective rows. I would like to extract the whole row of data containing negative numbers in any of the columns. It has 9135x3 cells of data. Any idea how to do this?

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

 采纳的回答

KSSV
KSSV 2021-6-14
编辑：KSSV 2021-6-14

0 个投票

Let H be your third column.
idx = H<0 ; % get all negative values logical indices
lon1 = lon(idx) ;
lat1 = lat(idx) ;
H1 = H(idx) ;
If A is your data of size 9135x3.
iwant = A(A(:,3)<0,:) ;

7 个评论
显示 5更早的评论 隐藏 5更早的评论

Gary Ong
Gary Ong 2021-6-14
I am new to matlab so please pardon me.
I am getting this error,
Undefined operator '<' for input arguments of type 'table'.
KSSV
KSSV 2021-6-14
Show us the whole code which gave you error.
Gary Ong
Gary Ong 2021-6-14
idx = SG1<0 ;
lon1 = lon(idx) ;
lat1 = lat(idx) ;
h1 = h(idx) ;
Results = SG1(SG1(:,3)<0,:);
this is what I have right now
KSSV
KSSV 2021-6-14
How you got SG1, lon, lat; thios is what matters for the error.
Gary Ong
Gary Ong 2021-6-14
编辑：Gary Ong 2021-6-14
H = SG1(:,3); % Land/Water Values
J = SG1(:,1); % Longitude
K = SG1(:,2); % Latitude
idx = H<0 ; <===Undefined operator '<' for input arguments of type 'table'.
lon1 = J(idx) ;
lat1 = K(idx) ;
h1 = H(idx) ;
Results = SG1(SG1(:,3)<0,:);
I am not sure if I am doing this right. Please guide me.
SG1 is my 9135x3 data which I imported as table. Do I need to convert it to an array?
KSSV
KSSV 2021-6-14
H = SG1.(3); % Land/Water Values
J = SG1.(1); % Longitude
K = SG1.(2); % Latitude
idx = H<0 ;
lon1 = J(idx) ;
lat1 = K(idx) ;
h1 = H(idx) ;
Gary Ong
Gary Ong 2021-6-14
It worked! Thank you for your patience and guidance! @KSSV

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 MATLAB Support Package for USB Webcams 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by