Perform multiple transformations on pandas dataframe columns

Question

I have a DataFrame as follow:

and now I want group by Username and transform to new DataFrame as:

I using Python 2.7 or 3.6 both OK

cs95 · Accepted Answer · 2017-09-18 04:36:04Z

2

Seems like you want an agg, not a transform...

df = df.groupby('Username')\
         .agg({'Item' : lambda x: x.tolist(), 'Price' : 'sum'})

If you want a comma separated string of words, it would involve an additional str.join:

df = df.groupby('Username')\
      .agg({'Item' : lambda x: ', '.join(x.tolist()), 'Price' : 'sum'})
df

+------------+---------+-----------+
| Username   |   Price | Item      |
|------------+---------+-----------|
| Johne      |    4500 | Food, Tea |
| Mary       |    1000 | Meat      |
| Peter      |    2850 | Food, Egg |
| Ted        |     750 | CK        |
+------------+---------+-----------+

answered Sep 18, 2017 at 4:36

cs95

406k106 gold badges745 silver badges798 bronze badges

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

1 Comment

cs95 Over a year ago

@PhongNguyen ', '.join(set(x.tolist()))

Collectives™ on Stack Overflow

Perform multiple transformations on pandas dataframe columns

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related