If the row values in multiple columns = 1, set another column's row value to 1, else set to 0

1 次查看（过去 30 天）
Centauri Jolene
Centauri Jolene 2020-9-9
评论： Matt J 2020-9-9
I have a table in which multiple columns contain either 0s or 1s. Lets say the columns are called A, B, & C.
I need to add a column, D, which has a value of 1 if within that row, A, B & C all have values of 1. If not, then D should have a value of 0 for that row.
Ive attached a .mat file with columns A, B & C for an example, but I need the addiitonal column 'D' added to the table:
A B C D
0 1 1 0
0 1 1 0
1 1 1 1
0 0 1 0
1 1 1 1
1 1 0 0
0 0 0 0
1 1 1 1
0 0 0 0
1 0 0 0
% I tried doing something like this but didnt work and seems inefficient:
for i = 1:height(X)
if X(i,'A') == 1 && X(i,'B') == 1 && X(i,'C') == 1
D = [D 1];
end
end

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

采纳的回答

Matt J
Matt J 2020-9-9
编辑：Matt J 2020-9-9
D=all( X{:,{'A','B','C'}} , 2);
X=[X,array2table(D)]
  3 个评论
显示 1更早的评论

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by