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 votes222 views2 answers
Formula of factorial
Python
0 vote169 views1 answer
Run python script without .py
Python
1 vote172 views5 answers
Scrapy proxy pool
Python
8 votes172 views6 answers
How to convert categorical data to numerical data in python
Python
0 vote168 views1 answer
Streaming upload requests python
Python
13 votes158 views2 answers
How to get last letter of string python
Python
9 votes224 views6 answers
Pattern in python
Python
0 vote209 views1 answer
Try and exception
Python
2 votes175 views3 answers
Select rows in python
Python
1 vote170 views1 answer
Python hasattribute
Python