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

1 次查看（过去 30 天）

显示更早的评论

Centauri Jolene 2020-9-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/590914-if-the-row-values-in-multiple-columns-1-set-another-column-s-row-value-to-1-else-set-to-0

评论： Matt J 2020-9-9

采纳的回答： Matt J

X.mat

在 MATLAB Online 中打开

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

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

请先登录，再进行评论。

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

采纳的回答

Matt J 2020-9-9

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/590914-if-the-row-values-in-multiple-columns-1-set-another-column-s-row-value-to-1-else-set-to-0#answer_491896

编辑：Matt J 2020-9-9

在 MATLAB Online 中打开

D=all(   X{:,{'A','B','C'}} , 2);
X=[X,array2table(D)]

3 个评论
显示 1更早的评论隐藏 1更早的评论

Centauri Jolene 2020-9-9

Thanks so much.

Matt J 2020-9-9

I updated my answer accordingly.

请先登录，再进行评论。

类别

MATLAB Language Fundamentals Data Types Numeric Types Logical

在 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