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

14 votes213 views1 answer
How to find the version of python command linw
Python
0 vote172 views1 answer
Mechanize python XE #26
Python
1 vote191 views1 answer
How to set axis range matplotlib
Python
8 votes166 views1 answer
Python discord bot join voice channel
Python
86 votes202 views6 answers
Select random value from list python
Python
5 votes232 views1 answer
Pandas version check in python
Python
43 votes187 views6 answers
Create a dataframe python
Python
0 vote188 views1 answer
How to separate url from text in python
Python
10 votes175 views4 answers
Pandas
Python
5 votes174 views1 answer
How to use a string variable as a variable name in python
Python