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

0 vote191 views1 answer
Tableau prep encoding to a set of fields in a flow
Python
2 votes157 views1 answer
Pandas remove timezone info
Python
0 vote161 views1 answer
Python while variable is not
Python
1 vote184 views1 answer
How to retrieve dictionary values in python by index
Python
0 vote172 views1 answer
Upload data to s3 bucket python
Python
15 votes152 views3 answers
Get the current year in python
Python
-1 vote181 views1 answer
Print something after sec python
Python
2 votes159 views1 answer
How to find the text inside button in tkinter
Python
2 votes163 views3 answers
WARNING: pip is configured with locations that require TLS/SSL, however the ssl module in Python is not available.
Python
6 votes168 views1 answer
Selectfield flask wtf
Python