pandas get count of rows with value in column code example

Example 1: pandas count values by column

df = pd.DataFrame({'a':list('abssbab')})
df.groupby('a').count()

Example 2: pandas count number of rows with value

In [37]:
df = pd.DataFrame({'a':list('abssbab')})
df.groupby('a').count()

Out[37]:

   a
a   
a  2
b  3
s  2

[3 rows x 1 columns]