Python Pandas combine

Question

Let's say I have the Python pandas dataframe below, I want to combine the amount paid column based on employee ID.

[dataframe]

Do you need [pivot](https://stackoverflow.com/q/47152691) ? – jezrael Jan 03 '23 at 14:25 — jezrael, Jan 03 '23 at 14:25

score -1 · Answer 1 · edited Jan 03 '23 at 14:29

-1

Well try:

dataframe.groupby('EMPLOYEE_ID')['AMOUNT_PAID'].sum()

edited Jan 03 '23 at 14:29

eshirvana

answered Jan 03 '23 at 14:28

Airdjan

[A code-only answer is not high quality](//meta.stackoverflow.com/questions/392712/explaining-entirely-code-based-answers). While this code may be useful, you can improve it by saying why it works, how it works, when it should be used, and what its limitations are. Please [edit] your answer to include explanation and link to relevant documentation. – Stephen Ostermiller Jan 04 '23 at 01:47

1 Answers1