Pandas groupby without dropping data

Asked Jul 01 '19 at 14:25

Active Jul 01 '19 at 14:27

Viewed 23 times

I am trying to perform a gorupby function on a dataframe without losing any of the other data.

Given the below dataframe:

color    name     size
 red      Jim      L
 red      Pam      S

I want to return like so:

color    name_x    name_y    size_x    size_y
 red       Jim      Pam        L         S

I figured just a simple groupby is all I needed to do but for some reason it doesn't work as planned.

df = df.groupby('color')

asked Jul 01 '19 at 14:25

MaxB

1

Check Q 10 in the link – BENY Jul 01 '19 at 14:27
@WeNYoBen is it not possible to accomplish this with a `groupby()`? I don't understand how to adapt these pivot solutions... – MaxB Jul 01 '19 at 14:59
Then just do groupby + first the unstack – BENY Jul 01 '19 at 15:01
which is what I came here to try and figure out. – MaxB Jul 01 '19 at 15:05
1

`df.set_index(['color', df.groupby('color').cumcount()]).unstack()` from cs95 – BENY Jul 01 '19 at 15:08

0 Answers0