pandas count the values in a column code example
Example 1: pandas count values by column
df = pd.DataFrame({'a':list('abssbab')})
df.groupby('a').count()
Example 2: pandas count
>>> df.set_index(["Person", "Single"]).count(level="Person")
Age
Person
John 2
Lewis 1
Myla 1