python - Better way to split column by value into new columns?

Question

This question already has answers here: question from:https://stackoverflow.com/questions/65854344/better-way-to-split-column-by-value-into-new-columns

Answer 1

IIUC,

df.set_index(['ID','User'])['Rating'].unstack('User').reset_index()

OR

df.pivot('ID','User','Rating').reset_index()

Output:

User  ID  type 1  type 2
0      1       4       5
1      2       3       2
2      3       1       5
3      4       4       3