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 votes104 views1 answer
Regex for digits python
Python
8 votes144 views2 answers
How to print all combinations of a string in python
Python
0 vote101 views1 answer
3d array
Python
0 vote107 views2 answers
Flask get summernote text
Python
9 votes210 views3 answers
How to skip number in while loop python
Python
0 vote95 views1 answer
Numpy transpose shorthand
Python
1 vote126 views1 answer
Select certain element from ndarray python
Python
47 votes133 views5 answers
Sort the dictionary in python
Python
0 vote114 views1 answer
Cartpole dqn reward max is 200
Python
1 vote104 views1 answer
Convert pandas dataframe to django queryset
Python