if-statement: Pandas conditional creation of a new dataframe column

mardi 30 août 2016

This question is an extension of question. If we had this dataframe:

    Col1       Col2
1    A          Z
2    B          Z           
3    B          X
4    C          Y
5    C          W

and we wanted to do the equivalent of:

if Col2 in ('Z','X') then Col3 = 'J' 
else if Col2 = 'Y' then Col3 = 'K'
else Col3 = {value of Col1}

How could I do that?

if-statement