I have a column with 14000 rows and there is only two numbers in this column.

for i  in df['Yes/No']:
  
  if(i in "Yes"):
    y_counter  = 1

  else:
    n_counter  = 1

When I try this I get an equal 12/12 return for each counter. That is definitely not correct. How do I loop through and count the Yes and Nos?

CodePudding user response：

You can do it like this :

y_counter = (data['Yes/No'] == 'yes').sum()
n_counter = (data['Yes/No'] == 'no').sum()