Use groupby in Pandas to count things in one column in comparison to another,df.groupby('Event').Status.value_counts().unstack().fillna(0)