Processing/Transposing Pandas Dataframe

Question

I got the following pandas dataframe:

Id    Category
1     type 2
1     type 3
1     type 2
2     type 1
2     type 2

I need to process and transpose the above data frame to:

Id Category_type_1 Category_type_2 Category_type_3
1          0               2              1
2          1               1              0

Appreciate if anyone could shows the easiest way to code this in python.

Answer 1

I'd groupby and use size

df.groupby(df.columns.tolist()).size().unstack().fillna(0)