Check values using if condition for each element of two rows in a matrix

Question

Damith 2014-3-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/121937-check-values-using-if-condition-for-each-element-of-two-rows-in-a-matrix

评论： Damith 2014-3-18

Hi,

I need to check values of each element of rows (2,:) and (1,:), (3,:) and (2.:) and so on upto 8 rows. The matix size is 8 x 40 and the values have zeros and decimal values (10.5, 100.2, 154.2 etc)

How can I implement to check for set of conditions for pair of rows at a time changing row numbers?

For example, suppose my matrix is AA(8x40) IF(AA(2,1)>0.1,IF(AA(2,1)=0,IF(AA(2,1)=0,IF(AA(1:1)=0,"1","0"))))

Above is the MS Excel function.

How can I implement this in MATLAB?

Can anyone help,

Thanks.

2 个评论
显示无隐藏无

Chris C 2014-3-17

I'm sorry. I really don't understand your questions. You want to check the rows of your matrix right? For what? That each element is the same? That one is larger than another.... there are nearly unlimited permutations of "checking" your matrix. If you could maybe try and explain the challenge a little more clearly, then I'd be happy to help.

Damith 2014-3-17

编辑：Damith 2014-3-17

Chris,

Sorry, My bad I did not explain the problem well. Let me elaborate.

I have a 3 matrices 365 rows x 40 columns of daily (365) precipitation data values for 40 years. So my matrices are AA = 365 x 40, BB = 365 x 40, CC = 365 x 40

I need to compare 2 rows at a time (e.g. row 2 with row 1, row 3 with row 2 across 40 years and so on)

Conditions need to check for each cell element of the first 2 rows across 40 years (e.g. row 2 and 1) are,

IF(AA(2,1)>0.1 and BB(2,1)=0,IF(CC(2,1)=0,IF(AA(1:1)=0,"1","0"))))

for row 3 and 2 are,

IF(AA(3,1)>0.1, BB(3,1)=0,IF(CC(3,1)=0,IF(AA(2:1)=0,"1","0"))))

. . .

upto row 365 and row 364. IF(AA(365,1)>0.1 and BB(365,1)=0,IF(CC(365,1)=0,IF(AA(364:1)=0,"1","0"))))

And I have 8 different set of conditions I need to check for same pairs of rows explained above. The eight conditions to check for each pair are as follows:

1)IF(AA(2,1)>0.1 and BB(2,1)=0 and IF(CC(2,1)=0 and IF(AA(1:1)=0,"1","0"))))

2)IF(AA(2,1)>0.1 and BB(2,1)=0 and IF(CC(2,1)=0 and IF(AA(1:1)>0.1,"1","0"))))

3)IF(AA(2,1)>0.1 and BB(2,1)=0 and IF(CC(2,1)>0.1 and IF(AA(1:1)=0,"1","0"))))

4)IF(AA(2,1)>0.1 and BB(2,1)=0 and IF(CC(2,1)>0.1 and IF(AA(1:1)>0.1,"1","0"))))

5)IF(AA(2,1)>0.1 and BB(2,1)>0.1 and IF(CC(2,1)=0 and IF(AA(1:1)=0,"1","0"))))

6)IF(AA(2,1)>0.1 and BB(2,1)>0.1 and IF(CC(2,1)=0 and IF(AA(1:1)>0.1,"1","0"))))

7)IF(AA(2,1)>0.1 and BB(2,1)>0.1 and IF(CC(2,1)>0.1 and IF(AA(1:1)=0,"1","0"))))

8)IF(AA(2,1)>0.1 and BB(2,1)>0.1 and IF(CC(2,1)>0.1 and IF(AA(1:1)>0.1,"1","0"))))

(NOTE: If all the conditions of each pair of rows are met, then output should be 1 otherwise zero)

Hope this helps to understand. My apologies for not explaining the problem well.

Hope to hear from you soon,

Thanks.

请先登录，再进行评论。

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

Answer 1

Mischa Kim 2014-3-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/121937-check-values-using-if-condition-for-each-element-of-two-rows-in-a-matrix#answer_128799

编辑：Mischa Kim 2014-3-17

在 MATLAB Online 中打开

Damith, this is the basic structure:

 data = rand(8,40);
 for ii = 1:length(data(:,1))-1                    % loop through all rows
     if sum(data(ii,:)) > sum(data(ii+1,:))        % iith and (ii+1)st row
        ...
     elseif *CONDITION*
        ...
     else
        ...
     end
 end

6 个评论
显示 4更早的评论隐藏 4更早的评论

Damith 2014-3-17

编辑：Damith 2014-3-17

Mischa,

I really appreciate and thanks for your quick answer. Sorry, My bad I did not explain the problem well. Let me elaborate.