Python Pandas count rows based on column

Question

How to get row counts based on one column in Python pandas. For example I have a data frame like this:

Name         NameTitle    Sex

John         Dr           m
Mona         Dr           f
Mary         Mrs          f
Tom          Mr           m
Jack         Mr           m 
Leila        Ms           f
Soro         Ms           f 
Christi      Ms           f
Mike         Mr           m

I need to count the number of name titles based on sex. Desired output would be like this:

NameTitle    Sex    Count

Dr           m      1
Dr           f      1
Mrs          f      1
Mr           m      3
Ms           f      3

jezrael · Accepted Answer · 2017-05-22 11:09:35Z

8

Use groupby + size + reset_index:

df = df.groupby(['NameTitle','Sex'], sort=False).size().reset_index(name='Count')
print (df)
  NameTitle Sex  Count
0        Dr   m      1
1        Dr   f      1
2       Mrs   f      1
3        Mr   m      3
4        Ms   f      3

answered May 22, 2017 at 11:09

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Python Pandas count rows based on column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related