Looping through Pandas Dataframe Columns to count values

Question

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?

Adrichut · Accepted Answer · 2022-03-31 16:20:48Z

1

You can do it like this :

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

answered Mar 31, 2022 at 16:20

2481 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1