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 votes291 views1 answer
Hibernate windows with python
Python
18 votes264 views5 answers
Python auto clicker
Python
4 votes275 views3 answers
Pandas how to find column contains a certain value
Python
0 vote329 views3 answers
Pandas assign multiple columns at once
Python
0 vote278 views1 answer
Start of the american labor movement
Python
13 votes277 views4 answers
How to call a python script from another python script
Python
0 vote293 views1 answer
Python create a set of class
Python
2 votes277 views5 answers
Check boolean python
Python
0 vote232 views1 answer
Concat list of strings python
Python
0 vote314 views1 answer
Extract text from span python
Python