Transforming Dataframe Columns in Python

Question

If I have a pandas Dataframe like such

enter image description here

and I want to transform it in a way that it results in

enter image description here

Is there a way to achieve this on the most correct way? a good pattern

Liam Foley · Accepted Answer · 2015-04-08 18:27:42Z

1

Use a pivot table:

pd.pivot_table(df,index='name',columns=['property'],aggfunc=sum).fillna(0)

Output:

         price          
Property  boat dog house
name                    
Bob          0   5     4
Josh         0   2     0
Sam          3   0     0

Sidenote: Pasting in your df's helps so people can use pd.read_clipboard instead of generating the df themselves.

answered Apr 8, 2015 at 18:27

Liam Foley

7,8822 gold badges28 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1