import pandas as pd
from pandas import Series, DataFrame
data = DataFrame({'Qu1':[1,3,4,3,4],'Qu2':[2,3,1,2,3],'Qu3':[1,5,2,4,4]})
result = data.apply(pd.value_counts).fillna(0)
In [26]:data
Out[26]:
Qu1 Qu2 Qu3
01211335241233244434
In [27]:result
Out[28]:
Qu1 Qu2 Qu3
11112021322042025001