Pivot Table(?) With A Pandas Dataframe

I have a DataFrame that is something similar to this id name value a Adam 5 b Eve 6 c Adam 4 a Eve 3 d Seth 2 b Adam 4 a Adam

Solution 1:

is that what you want?

In[54]: df.pivot_table(index='id', columns='name', values='value', aggfunc='sum')
Out[54]:
nameAdamEveSethida7.03.0NaNb4.06.0NaNc4.0NaNNaNdNaNNaN2.0

or without NaN's:

In[56]: df.pivot_table(index='id', columns='name', values='value', aggfunc='sum', fill_value=0)
Out[56]:
nameAdamEveSethida730b460c400d002