I have a json file which when converted into a dataframe looks something like this:

sl no.    id    name    value    date
1        101    Math    90       -
2        101    Phy     87       -
3        201    Math    85       -
4        201    Phy     93       -

(Not the actual data but of the same principle with multiple repeating entries with one differing category)

What I’m trying to achieve looks something like this:

sl no.    id    Math    Phy    date
1        101    90      87     -
...

Is there any way to easily convert these categorical entries into columns of the same name instead of having multiple repeating entries for each student?