I have a dataframe:
id cost_arr amount_arr
1 [3,4,5,6] [23,34,45,26]
2 [7,8,9] [27,38,39]
3 [11,15,10,9,7] [611,615,610,89,79]
cost_arr and amount_arr are arrays.
How can I do that?
Thanks
Jeff
df = pd.DataFrame({'id': [1,1,1,1,2,2,2,3,3,3,3,3], 'cost': [3,4,5,6,7,8,9,11,15,10,9,7], 'amount': [23,34,45,26,27,38,39,611,615,610,89,79] }) dfI want a df with 3 rows and 3 columns:
id cost_arr amount_arr
1 [3,4,5,6] [23,34,45,26]
2 [7,8,9] [27,38,39]
3 [11,15,10,9,7] [611,615,610,89,79]
cost_arr and amount_arr are arrays.
How can I do that?
Thanks
Jeff