How to make the following code valid for tables not only matrices

Question

Salma fathi 2022-6-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1745430-how-to-make-the-following-code-valid-for-tables-not-only-matrices

回答： Eric Sofen 2022-6-23

hello, The following code finds the peak point for some data stored in an array or matrix lets say.

for ied=1:length(EDP)
    imax=[];
    [~,imax] = max(EDP(:,7));  %column 7 we have the variable NE8 which we are intrested in finding its maximum
    
   
    if (EDP(imax,6) < 190 || EDP(imax,6) >400)    %column 6 we have the variable GDALT, which is the alttitued
        EDP(imax,:)=[];
    elseif ( EDP(imax,6) > 190 && EDP(imax,6) < 190) %the range for the altitude of the peak is between 190-400
        break;
    end
end

How can we modify it such that it would be valid for data that are stored in tables also not only arrays or matrices.

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

请先登录，再进行评论。

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

Answer 1

KSSV 2022-6-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1745430-how-to-make-the-following-code-valid-for-tables-not-only-matrices#answer_990635

Convert the Table into array using table2array. You can extract any column from table T using T.(1), T.(2) etc....

2 个评论
显示无隐藏无

Salma fathi 2022-6-22

thank you for your reply. I have tried doing that and it worked.. but dealing with arrays is giving me sme hard time when trying to do further processing thats why I would like to have it all working for tables since all my data is stored into tables instead of every time converting from table to array. Would that be possible?

KSSV 2022-6-22

You can access any column of the table, I have already mentioned it.

请先登录，再进行评论。

Answer 2

Eric Sofen 2022-6-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1745430-how-to-make-the-following-code-valid-for-tables-not-only-matrices#answer_991930

在 MATLAB Online 中打开

There are a few ways to rework the indexing to work with tables. By the way, I'm not sure what the loop does (ied doesn't appear in the body of the loop).

[~,imax] = max(EDP.NE8);  %column 7 we have the variable NE8 which we are intrested in finding its maximum
if (EDP.GDALT(imax) < 190 || EDP.GDALT(imax) >400)    %column 6 we have the variable GDALT, which is the alttitued
    EDP(imax,:)=[];
elseif ( EDP.GDALT(imax) > 190 && EDP.GDALT(imax) < 190) %the range for the altitude of the peak is between 190-400
    break;
end