create list using groupby

Real Raccoon answered on February 10, 2021 Popularity 6/10 Helpfulness 4/10

answer create list using groupby

related groupby and list

create list using groupby

Comment

In [2]: df.groupby('a')['b'].apply(list)

Popularity 6/10 Helpfulness 4/10 Language python

Source: stackoverflow.com

Tags: group-by list python using

Link to this answer
Share Copy Link

Contributed on Nov 01 2022

Real Raccoon

0 Answers Avg Quality 2/10

Closely Related Answers

groupby and list

Comment

In [1]: df = pd.DataFrame( {'a':['A','A','B','B','B','C'], 'b':[1,2,5,5,4,6]})
        df

Out[1]: 
   a  b
0  A  1
1  A  2
2  B  5
3  B  5
4  B  4
5  C  6

In [2]: df.groupby('a')['b'].apply(list)
Out[2]: 
a
A       [1, 2]
B    [5, 5, 4]
C          [6]
Name: b, dtype: object

In [3]: df1 = df.groupby('a')['b'].apply(list).reset_index(name='new')
        df1
Out[3]: 
   a        new
0  A     [1, 2]
1  B  [5, 5, 4]
2  C        [6]

Popularity 10/10 Helpfulness 3/10 Language python

Source: stackoverflow.com

Tags: group-by group-b

Link to this answer
Share Copy Link

Contributed on Feb 10 2021

Defeated Dragonfly

0 Answers Avg Quality 2/10

create list using groupby

Contents

More Related Answers

create list using groupby

Closely Related Answers

groupby and list

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.