Logic on a Pandas Dataframe with a string

Question

This should be a really easy one, but I can't figure it out:: I have a dataframe, df, and it has two string values, "normal" and "odd". I'd like to find out how many are in either catagory::

type(bro_df)
pandas.core.frame.DataFrame

print(len(bro_df))
2000000

type(bro_df['label'])
pandas.core.series.Series

print(len(bro_df['label'] == 'normal'))
2000000

print(len(bro_df['label'] == 'odd'))
2000000

What's going on??!?!

Thanks, Nic

piRSquared · Accepted Answer · 2017-07-03 23:43:44Z

2

len(bro_df['label'] == 'odd') is the length of the boolean series of True and False. If you want the number of rows with those values:

(bro_df['label'] == 'odd').sum()

Or better yet

bro_df.label.value_counts()

answered Jul 3, 2017 at 23:43

piRSquared

296k68 gold badges509 silver badges654 bronze badges

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

1 Comment

npross Over a year ago

Yeah, these both work a treat, and can be applied to my/ones given circumstances. :-) Thanks!!

Collectives™ on Stack Overflow

Logic on a Pandas Dataframe with a string

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related