after groupby how to add values in two rows to a list

Solutions on MaxInterview for after groupby how to add values in two rows to a list by the best coders in the world

Search
showing results for - "after groupby how to add values in two rows to a list"
Wassim
21 Jan 2018
1In [1]: df = pd.DataFrame( {'a':['A','A','B','B','B','C'], 'b':[1,2,5,5,4,6]})
2        df
3
4Out[1]: 
5   a  b
60  A  1
71  A  2
82  B  5
93  B  5
104  B  4
115  C  6
12
13In [2]: df.groupby('a')['b'].apply(list)
14Out[2]: 
15a
16A       [1, 2]
17B    [5, 5, 4]
18C          [6]
19Name: b, dtype: object
20
21In [3]: df1 = df.groupby('a')['b'].apply(list).reset_index(name='new')
22        df1
23Out[3]: 
24   a        new
250  A     [1, 2]
261  B  [5, 5, 4]
272  C        [6]
source
similar questions
pandas groupby multi indexhow to add multiple items in list pythondjango queryset group by sumdataframe groupby multiple columnspandas group by multiple columns and countpandas sum multiple columns groupbypython groupby sum single columnstwo groupby pandaspandas groupby sumpandas python group by for one column and sum another columnpandas groupby aggregate multiple columnsdjango querset group by sumhow to add two different times in pythonsum group by pandas and create new columngroup by 2c aggregate multiple column pandaspandas groupby max multiple columns in pandaspandas sum group bygroup by 2 unique attributes pandaspython add all values of another listpandas group by concatgroup by 2 columns pandasdataframe groupby rank by multiple column valuepython append multiple values
queries leading to this page
how to plot sum on multiple columns in pythonafter group by sum all the row value into one rowafter groupby how to add values in two rows to a list