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 votes185 views1 answer
Download youtube videos using api python
Python
-1 vote204 views1 answer
How to scan directory recursively python
Python
0 vote248 views2 answers
Flask return html
Python Flask
6 votes168 views3 answers
Python open folder
Python
2 votes167 views1 answer
Python how to make an array of ones
Python
0 vote168 views1 answer
Calculate the euler totient of a number python
Python
0 vote166 views1 answer
Def extract_title(input_df):
Python
0 vote155 views1 answer
Ax text relative coordinates
Python
0 vote163 views1 answer
Matplotlib include first number in plotter
Python
0 vote170 views1 answer
Tensorflow matrix multiplication
Python