TYPE_cols = df.filter(like='TYPE_')
d = pd.DataFrame([pd.unique(x) for x in TYPE_cols.values], df['EVALUATED'].
    values)
result = d.groupby(level=0).apply(lambda x: pd.value_counts(x.values.ravel()))
result.unstack(fill_value=0).T.reset_index().rename(columns={'index': 'TYPE'})
How to count unique occurences of particular value per row?