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 vote265 views1 answer
Range function with for loop in python
Python
23 votes297 views1 answer
How to extract month from date in python
Python
1 vote253 views1 answer
Simulate webcam and microphone selenium
Python
0 vote340 views2 answers
Pandas read parquet from s3
Python
63 votes253 views6 answers
For loop with index python
Python
2 votes274 views2 answers
Python do nothing
Python
-2 votes249 views1 answer
What does waka waka mean
Python
6 votes266 views3 answers
Sort a dictionary by value then key
Python
0 vote252 views2 answers
How to calculate approximate distance with latitude and longitude
Python
4 votes256 views2 answers
Python mkdir
Python