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 vote196 views1 answer
How to apply sentence case in python
Python
-1 vote203 views1 answer
Group by data
Python
7 votes187 views3 answers
Delete key value in dictionary python
Python
2 votes213 views2 answers
Anaconda python 3.6 download
Python
2 votes196 views1 answer
Range python iterate by 2
Python
1 vote212 views2 answers
Stingray
Python
0 vote190 views1 answer
Mak a scipy csr sparse matrix
Python
34 votes182 views2 answers
Python shuffle list with seed
Python
0 vote198 views1 answer
Type hint tuple
Python
0 vote191 views1 answer
How to save string json to json object python
Python