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

0 vote145 views1 answer
Cuantas palabras hay en una frase en python
Python
5 votes135 views1 answer
Selenium webdriver imports
Python
3 votes191 views6 answers
ImportError: Couldn't import Django. Are you sure it's installed and available on your PYTHONPATH environment variable? Did you forget to activate a virtual environment?
Python Django
1 vote129 views1 answer
Plot_histogram qiskit pycharm
Python
0 vote140 views2 answers
How to print aligned dictionary python
Python
1 vote144 views1 answer
TypeError: ‘builtin_function_or_method’ object is not subscriptable
Python
0 vote142 views1 answer
Python close browser
Python
0 vote174 views1 answer
Simplest flask memcached
Python Flask
0 vote130 views1 answer
Change orientatin of dict read pandas
Python
0 vote194 views1 answer
Compute the mean of this RDD’s elements.
Python