How do can I check whether 2 columns in an array have equal values in a row?

2 次查看（过去 30 天）
jrb13
jrb13 2016-5-2
评论： Robert 2016-5-4
I have an array of 5 columns and I would like to check whether columns 1 and 5 have the same value (1) and report the result to a vector. If the values are not the same, I want the vector to have values of 1 (e.g. [1, 1, 1, 1, 1, 1]). If the values in columns 1 and 5 are the same for a given row, I want to increase the value by 1 (e.g. 1, 1, 1, 1, 2, 2).
I receive the following error: Operands to the and && operators must be convertible to logical scalar values. When I change the && to &, the function returns ans = []. In the code below, the array is named positions and the vector into which I would like the values reported is named SimIDs.
Please let me know any additional information I can provide.
i=1;
SimIDs=[];
if positions(:,1)==1 && positions(:,5)==1
i=i+1;
SimIDs=[SimIDs,i];
end

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

采纳的回答

Robert
Robert 2016-5-2
编辑：Robert 2016-5-2
Your if statement is examining the entire column because you use : in your indexing expression instead of a loop index, but you increment i as though you were in a loop.
Instead, try using cumsum on your logical result as follows
SimIDs = cumsum(positions(:,1)==1 & positions(:,5)==1) + 1;
% add one to start at one rather than zero
  2 个评论
jrb13
jrb13 2016-5-3
Thank you very much! This is working for me. My data actually begin with a row with columns 1 and 5 having a value of 1, so I eliminated the +1. I don't quite understand how it works. The cumulative sum of the elements in A would at the least be 2, no?
Robert
Robert 2016-5-4
Yes, if the first value will always be 1, not zero, then your SimIDs will never start at zero anyhow. You don't need the +1.

请先登录，再进行评论。

更多回答（1 个）

Walter Roberson
Walter Roberson 2016-5-2
mask = positions(:,1) == positions(:,5);
SimIDs = ones(size(mask));
SimIds(mask) = positions(mask,1) + 1;

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by