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 vote113 views1 answer
What mean import in python
Python
0 vote135 views1 answer
Write multiple DataFrames to Excel files
Python
0 vote103 views1 answer
RuntimeError: Please set pin numbering mode using GPIO.setmode(GPIO.BOARD) or GPIO.setmode(GPIO.BCM)
Python
0 vote109 views1 answer
Procfile heroku python example
Python
0 vote101 views1 answer
Eror api/kernelsUntitled.ipynb?kernel_name=python3
Python
1 vote107 views1 answer
Put array over array in numpy
Python
1 vote110 views1 answer
Remove columns that contain certain names in pandas
Python
0 vote128 views1 answer
Series summation in Python
Python
11 votes115 views2 answers
Format python number with commas
Python
14 votes158 views5 answers
Remove extra spaces python
Python