Pandas groupby size column name

import pandas as pd

df = pd.DataFrame({'A': ['x', 'x', 'x','y','y']
                , 'B': ['a', 'c', 'c','b','b']})
print (df)
   A  B
0  x  a
1  x  c
2  x  c
3  y  b
4  y  b

df = df.groupby(['A', 'B']).size().reset_index(name='Size')
print (df)
   A  B  Size
0  x  a     1
1  x  c     2
2  y  b     2

Source: stackoverflow.com

Similar codes

3 votes124 views1 answer
Multiply column of dataframe by number
Python
1 vote131 views1 answer
How to write a dict in pytohn
Python
22 votes118 views1 answer
Python test if number in string
Python
0 vote121 views1 answer
Try open file
Python
51 votes158 views1 answer
Add new keys to a dictionary python
Python
-2 votes116 views1 answer
Python telegram bot get user name
Python
0 vote173 views1 answer
Field 'id' expected a number but got <django.db.models.fields.related_descriptors.create_forward_many_to_many_manager.<locals>.ManyRelatedManager object at 0x7fb02044de80>
Python Django
0 vote117 views1 answer
Save artist animation puython
Python
0 vote135 views1 answer
Run multiple function with multiprocessing python
Python
5 votes119 views3 answers
Convert list to dataframe
Python