How can I index through logicals?

Question

Rookie Programmer 2023-7-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1994188-how-can-i-index-through-logicals

评论： Rookie Programmer 2023-7-10

How can I index/loop through table(T) to get the rows with logical 1s in T.logical. Also, check if the logical is 0s, if so get the respective row with the string 'High' from T.Level?

T = table;
A = randi([0, 1], 5, 5);
c1 = A(:,1);
c2 = A(:,2);
c3 = A(:,3);
c4 = A(:,4);
c5 = A(:,5);
vert = vertcat(c1, c2, c3);
Types = {'A', 'B', 'C', 'D', 'A', 'B', 'C', 'D', 'A', 'B', 'C', 'D', 'A', 'B', 'C'}';
Level = {'Low', 'Medium', 'High', 'Low', 'Medium', 'High', 'Low', 'Medium', 'High', 'Low', 'Medium', 'High', 'Low', 'Medium', 'High'}';
T.Types = Types;
T.logical = vert;
T.Level = Level;
TrueTable = table;
TrueTable.UniqueType = unique(T.Types);
numTypes = height(TrueTable);
TrueTable.Total = cell(numTypes, 1);

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

请先登录，再进行评论。

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

Answer 1

Voss 2023-7-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1994188-how-can-i-index-through-logicals#answer_1270713

编辑：Voss 2023-7-10

在 MATLAB Online 中打开

Construct table T:

A = randi([0, 1], 5, 5);
vert = reshape(A(:,1:3),[],1);
Types = {'A', 'B', 'C', 'D', 'A', 'B', 'C', 'D', 'A', 'B', 'C', 'D', 'A', 'B', 'C'}';
Level = {'Low', 'Medium', 'High', 'Low', 'Medium', 'High', 'Low', 'Medium', 'High', 'Low', 'Medium', 'High', 'Low', 'Medium', 'High'}';
T = table(Types,vert,Level);
T = renamevars(T,'vert','logical')
T = 15×3 table
    Types    logical      Level   
    _____    _______    __________

    {'A'}       1       {'Low'   }
    {'B'}       0       {'Medium'}
    {'C'}       1       {'High'  }
    {'D'}       0       {'Low'   }
    {'A'}       1       {'Medium'}
    {'B'}       0       {'High'  }
    {'C'}       1       {'Low'   }
    {'D'}       1       {'Medium'}
    {'A'}       0       {'High'  }
    {'B'}       1       {'Low'   }
    {'C'}       1       {'Medium'}
    {'D'}       0       {'High'  }
    {'A'}       0       {'Low'   }
    {'B'}       1       {'Medium'}
    {'C'}       1       {'High'  }

Get a new table (called rows) that contains the rows of T where logical is 1 or Level is 'High':

idx = T.logical | strcmp(T.Level,'High');
rows = T(idx,:)
rows = 12×3 table
    Types    logical      Level   
    _____    _______    __________

    {'A'}       1       {'Low'   }
    {'C'}       1       {'High'  }
    {'A'}       1       {'Medium'}
    {'B'}       0       {'High'  }
    {'C'}       1       {'Low'   }
    {'D'}       1       {'Medium'}
    {'A'}       0       {'High'  }
    {'B'}       1       {'Low'   }
    {'C'}       1       {'Medium'}
    {'D'}       0       {'High'  }
    {'B'}       1       {'Medium'}
    {'C'}       1       {'High'  }