python dataframe - grouping rows

Question

I'm new to python so the question might not be so clear.

I have this dataset with pandas dataframe that goes something like this.

        Id       item
0      A0029V93  B0239WN
1      A0029V93  B0302SS
2      A02948s8  B0029ST
...

and the result I want is

        Id       item
0      A0029V93  (B0239WN,B0302SS)
1      A02948s8  (B0029ST, ...)
2      ...       ...
...

No duplicate Id and all the items in the data paired with the ID It doesn't necessarily have to look like this as long as I can get the Id,[item] data.

score 1 · Answer 1 · answered Dec 05 '19 at 08:14

1

df.groupby('Id')['item'].apply(list)

answered Dec 05 '19 at 08:14

mjspier

6,386
5
33
43

Same question: https://stackoverflow.com/questions/22219004/grouping-rows-in-list-in-pandas-groupby – mjspier Dec 05 '19 at 08:18
thx for the help! Didn't know there was a same question couldn't find it. – CCC Dec 05 '19 at 08:18

python dataframe - grouping rows

1 Answers1