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

2 votes315 views3 answers
Sum elements array with step numy
Python
4 votes322 views1 answer
How to loop the length of an array pytoh
Python
1 vote316 views1 answer
Python print dict new line
Python
0 vote286 views1 answer
Pyplot aera
Python
10 votes322 views4 answers
How to check if Python is 32 or 64 bit
Python
1 vote298 views1 answer
Minimum from list of tuples
Python
3 votes336 views3 answers
Remove x label matplotlib
Python
1 vote382 views1 answer
Read files and write into another files python
Python
6 votes332 views6 answers
Install pip python 3.9
Python
-2 votes297 views1 answer
Python get an online file
Python