How can I use a for loop to select values from a table that meet two conditions?

Question

Amy Hughes 2019-12-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/496396-how-can-i-use-a-for-loop-to-select-values-from-a-table-that-meet-two-conditions

评论： Amy Hughes 2019-12-13

My table is tab=table(metabolites, aerobic, anaerobic).

I am trying to compute a for loop that only selects those metabolites where they are >=0 in each aerobic and anaerobic columns and where they also different value in each column for each row.

I am not too sure how I can change the below for loop to say the above, as it is currently wrong. I would be grateful for any suggestions please. Thank-you

m=1
for i=1:height(tab)
    if(Aerobic(i)~=Anaerobic(i)) &
        (Aerobic(i) & Anaerobic(i) >=0)
        secmet(m, 1:3)=tab(i, 1:3)
        m=m+1
    else
        continue;
    end
end

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

请先登录，再进行评论。

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

Answer 1

Chuguang Pan 2019-12-13

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/496396-how-can-i-use-a-for-loop-to-select-values-from-a-table-that-meet-two-conditions#answer_406184

在 MATLAB Online 中打开

m=1;
for i=1:height(tab)
    if(Aerobic(i)~=Anaerobic(i)) &&  Aerobic(i)>=0 && Anaerobic(i)>=0
        secmet(m, 1:3)=tab(i, 1:3)
        m=m+1
    else
        continue;
    end
end