get count of data based on column values code example Example: pandas count values by column df = pd.DataFrame({'a':list('abssbab')}) df.groupby('a').count()