How to get subset of data from given thresholds?

Question

Macy 2023-2-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1920235-how-to-get-subset-of-data-from-given-thresholds

评论： Macy 2023-2-28

采纳的回答： Askic V

在 MATLAB Online 中打开

Please help, here is a snippet of code. There are three different thresholds that I have to make subsets of data for:

1)NZE > 0.25

2)NZE > 0.5, DNS < 30% of max DNS

3)NZE > 0.5, |Percent| < 20% (make sure to do absolute value)

I am not sure how to write out the last two. Because there are two boundaries, I am struggling on how to write it. If I had to guess I would do the following but I know it is not correct:

sub = dat(dat(:,10)>0.5,:)&dat(dat(:,9)<0.2*max(:;9),:);

sub = dat(dat(:,10)>0.5,:)&dat(abs(dat(:,11)<0.2,:));;

Thank you.

dat = load('something random');
dat(:,12) = 1:size(dat,1);
names = {'DNS' 'NZE' 'Percent'};
columns = [9 10 11];
for i=1:3
    if(i==1) % NZE > 0.25                        %}
        sub = dat(dat(:,10)>0.25,:);             %} This section is correct
        dat_1 = sub;                             %}
    end
 
    if(i==2) % NZE > 0.5, DNS < 30% of max DNS
        sub =                                    %??? Not sure of how to do this
        dat_2 = sub;
    end
    
    if(i==3) % NZE > 0.5, |Percent| < 20%
        sub =                                    %??? Not sure of how to do this
        dat_3 = sub;
    end

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

请先登录，再进行评论。

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

Answer 1

Askic V 2023-2-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1920235-how-to-get-subset-of-data-from-given-thresholds#answer_1181450

编辑：Askic V 2023-2-28

在 MATLAB Online 中打开

Did you try this approach?

DNS = dat(:,9);
NZE = dat(:,10);
PER = dat(:,11);
% 1. 
sub = dat(NZE>0.25,:);
%2. 
sub = dat( (NZE>0.5) & (DNS<0.3* max(DNS)), : );
% 3. check percent column (is it 20% or 0.2)
sub = dat( (NZE>0.5) & (abs(PER)<20), : ); 