Thread Subject:

a problem of “if…else” statement

Hello,

I have a problem of “if…else” statement.
For instance, I have a data set bellow.
A B C D E F G
1 2 7 3 9
2 1 4 6 10
1 2 7 9 11



A B C D E F G
1 2 7 3 9 7 9
2 1 4 6 10 6 4
1 2 7 9 11 7 11
  
I want first data set to turn into second data set. There are complex conditions to determine the column F and column G.
Condition 1: numbers in column A determines whether column F or column G is filled with the number in column C. That is, if column A =1, then fills column F with numbers in column C; otherwise, fills column G with numbers in column C.
Ex1: when A1=1, F1=C1=7;
Ex2: when A2=2, G2=C2=4
After condition 1 is satisfied, either column F or column G is left empty, and then do condition 2.
Condition 2: If numbers in column B =1, then fill the empty column (F or G) with numbers in column D; otherwise, fill the empty column (F or G) with numbers in column E.
Ex1: when (condition1) A1=1 and when (condition2) B1=2, G1=E1=9;
Ex2: when (condition1) A2=2 and when (condition2) B2=1, F1=D1=6;
Can someone tell me how to do this? Thanks!
Sincerely,
Yihui

On 4/13/2011 3:06 AM, Yihui wrote:
> Hello,
>
> I have a problem of“if…else” statement.
> For instance, I have a data set bellow.
> A B C D E F G
> 1 2 7 3 9
> 2 1 4 6 10
> 1 2 7 9 11
>
>
>
> A B C D E F G
> 1 2 7 3 9 7 9
> 2 1 4 6 10 6 4
> 1 2 7 9 11 7 11
>
> I want first data set to turn into second data set. There are complex conditions to
> determine the column F and column G.
> Condition 1: numbers in column A determines whether column F or column G is filled
> with the number in column C. That is, if column A =1, then fills column F with
> numbers in column C; otherwise, fills column G with numbers in column C.
> Ex1: when A1=1, F1=C1=7;
> Ex2: when A2=2, G2=C2=4
> After condition 1 is satisfied, either column F or column G is left empty, and
> then do condition 2.
> Condition 2: If numbers in column B =1, then fill the empty column (F or G)
> with numbers in column D; otherwise, fill the empty column (F or G) with numbers in column E.
> Ex1: when (condition1) A1=1 and when (condition2) B1=2, G1=E1=9;
> Ex2: when (condition1) A2=2 and when (condition2) B2=1, F1=D1=6;
> Can someone tell me how to do this? Thanks!
> Sincerely,
> Yihui

Will your A and B columns always be such that if one had a '1' in some row,
then the other will have a '2' in the same row and vis versa?

If so, then a solution is a simple application of find:

-----------------
clear all
A=1; B=2; C=3; D=4; E=5; F=6; G=7;

%input is X matrix
X=[1 2 7 3 9 0 0;
    2 1 4 6 10 0 0;
    1 2 7 9 11 0 0];

%cond 1
X(X(:,A)==1,F) = X(X(:,A)==1,C);
X(X(:,A)==2,G) = X(X(:,A)==2,C);

%cond 2
X(X(:,B)==1,F)=X(X(:,B)==1,D);
X(X(:,B)==2,G)=X(X(:,B)==2,E);
-----------------------

X =

      1 2 7 3 9 7 9
      2 1 4 6 10 6 4
      1 2 7 9 11 7 11


If not, then an extra logic can be added. But before I do
that, lets first see if that is even needed.

--Nasser

"Yihui" wrote in message <io3sic$9kk$1@fred.mathworks.com>...
> Hello,
>
> I have a problem of “if…else” statement.
> For instance, I have a data set bellow.
> A B C D E F G
> 1 2 7 3 9
> 2 1 4 6 10
> 1 2 7 9 11
>
>
>
> A B C D E F G
> 1 2 7 3 9 7 9
> 2 1 4 6 10 6 4
> 1 2 7 9 11 7 11
>
> I want first data set to turn into second data set. There are complex conditions to determine the column F and column G.
> Condition 1: numbers in column A determines whether column F or column G is filled with the number in column C. That is, if column A =1, then fills column F with numbers in column C; otherwise, fills column G with numbers in column C.
> Ex1: when A1=1, F1=C1=7;
> Ex2: when A2=2, G2=C2=4
> After condition 1 is satisfied, either column F or column G is left empty, and then do condition 2.
> Condition 2: If numbers in column B =1, then fill the empty column (F or G) with numbers in column D; otherwise, fill the empty column (F or G) with numbers in column E.
> Ex1: when (condition1) A1=1 and when (condition2) B1=2, G1=E1=9;
> Ex2: when (condition1) A2=2 and when (condition2) B2=1, F1=D1=6;
> Can someone tell me how to do this? Thanks!
> Sincerely,
> Yihui
- - - - - - - - -
  Call your data array M.

t1 = M(:,1)==1);
t2 = ~t1;
t3 = M(:,2)==1);
s = M(:,4).*t3+M(:,5).*(~t3);
M(:,6) = M(:,3).*t1+s.*t2;
M(:,7) = M(:,3).*t2+s.*t1;

Roger Stafford

"Roger Stafford" wrote in message <io4qie$erk$1@fred.mathworks.com>...
> ......
> t1 = M(:,1)==1);
> t3 = M(:,2)==1);
> .......
- - - - - - -
  Correction: There were a couple of unwanted parentheses above.

t1 = M(:,1)==1;
t3 = M(:,2)==1;

Roger Stafford

Dear Nasser,

Your resolution works very well. Thank you so much.

Sincerely,
Yihui

"Nasser M. Abbasi" <nma@12000.org> wrote in message <io3vcr$tp7$1@speranza.aioe.org>...
> On 4/13/2011 3:06 AM, Yihui wrote:
> > Hello,
> >
> > I have a problem of“if…else” statement.
> > For instance, I have a data set bellow.
> > A B C D E F G
> > 1 2 7 3 9
> > 2 1 4 6 10
> > 1 2 7 9 11
> >
> >
> >
> > A B C D E F G
> > 1 2 7 3 9 7 9
> > 2 1 4 6 10 6 4
> > 1 2 7 9 11 7 11
> >
> > I want first data set to turn into second data set. There are complex conditions to
> > determine the column F and column G.
> > Condition 1: numbers in column A determines whether column F or column G is filled
> > with the number in column C. That is, if column A =1, then fills column F with
> > numbers in column C; otherwise, fills column G with numbers in column C.
> > Ex1: when A1=1, F1=C1=7;
> > Ex2: when A2=2, G2=C2=4
> > After condition 1 is satisfied, either column F or column G is left empty, and
> > then do condition 2.
> > Condition 2: If numbers in column B =1, then fill the empty column (F or G)
> > with numbers in column D; otherwise, fill the empty column (F or G) with numbers in column E.
> > Ex1: when (condition1) A1=1 and when (condition2) B1=2, G1=E1=9;
> > Ex2: when (condition1) A2=2 and when (condition2) B2=1, F1=D1=6;
> > Can someone tell me how to do this? Thanks!
> > Sincerely,
> > Yihui
>
> Will your A and B columns always be such that if one had a '1' in some row,
> then the other will have a '2' in the same row and vis versa?
>
> If so, then a solution is a simple application of find:
>
> -----------------
> clear all
> A=1; B=2; C=3; D=4; E=5; F=6; G=7;
>
> %input is X matrix
> X=[1 2 7 3 9 0 0;
> 2 1 4 6 10 0 0;
> 1 2 7 9 11 0 0];
>
> %cond 1
> X(X(:,A)==1,F) = X(X(:,A)==1,C);
> X(X(:,A)==2,G) = X(X(:,A)==2,C);
>
> %cond 2
> X(X(:,B)==1,F)=X(X(:,B)==1,D);
> X(X(:,B)==2,G)=X(X(:,B)==2,E);
> -----------------------
>
> X =
>
> 1 2 7 3 9 7 9
> 2 1 4 6 10 6 4
> 1 2 7 9 11 7 11
>
>
> If not, then an extra logic can be added. But before I do
> that, lets first see if that is even needed.
>
> --Nasser
>
>
>

Dear Stafford,

This works elegantly. Thank you very much.

Sincerely,
Yihui


"Roger Stafford" wrote in message <io4tlp$f5b$1@fred.mathworks.com>...
> "Roger Stafford" wrote in message <io4qie$erk$1@fred.mathworks.com>...
> > ......
> > t1 = M(:,1)==1);
> > t3 = M(:,2)==1);
> > .......
> - - - - - - -
> Correction: There were a couple of unwanted parentheses above.
>
> t1 = M(:,1)==1;
> t3 = M(:,2)==1;
>
> Roger Stafford