Custom sum with groupby pandas python

Asked Jan 23 '23 at 11:32

Active Jan 23 '23 at 11:32

Viewed 16 times

I am trying to make a group by with custom sum.

I have a dataframe with following columns:

date | describe | time | fees

I try to groupby with following order: df.groupby(['date', 'describe', 'time', 'fees'])['fees'].sum()

but I want to sum 'fees' based on 'date' column.

Any Idea to solve that?

asked Jan 23 '23 at 11:32

Emad Ali

3

`df.groupby(['date'])['fees'].sum()` ? – jezrael Jan 23 '23 at 11:33
the output of sum will be correct, but I will lose the rest columns, so I need to be the final result: "date" | "describe" | "time" | "fees" | sum("fees based on date" – Emad Ali Jan 23 '23 at 11:43
or | "date" | sum(fees of date) | "describe" | "time" | "fees"| – Emad Ali Jan 23 '23 at 11:46

0 Answers0