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

5 votes362 views4 answers
Python open mat file
Python
2 votes329 views6 answers
K
Python
0 vote337 views1 answer
Description of imdb dataset python
Python
1 vote319 views1 answer
Plot specific columns pandas
Python
0 vote313 views4 answers
Pandas filter
Python
0 vote297 views1 answer
Cieling function pandas
Python
1 vote331 views2 answers
Phi
Python
1 vote332 views1 answer
How to find which 2 rows of a df are the most similar
Python
0 vote343 views1 answer
Django orm group by month and year
Python
0 vote312 views1 answer
Sys.path.append python
Python