pandas : use groupby on each element of list,df['categories'].apply(pd.Series).stack().value_counts()