I have a column with values yes no as mentioned below i want 1 if value is
yes 0 if value is no in next column
yes
no
yes
yes
no
no
yes
yes