Pandas: sum column values against specific value in another column

Question

I am using this data frame:

InvoiceNo    Amount    Year-Month
1            100       2019-01
2            125       2019-02
3            200       2019-02
4            300       2019-03
5            120       2019-03
6            350       2019-03
7            500       2019-04
8            230       2019-04
9            100       2019-04
10           200       2019-05

I want to sum up value against all the same months and display new column with those monthly values like this:

InvoiceNo    Amount    Year-Month    MonthlyValue
1            100       2019-01       100
2            125       2019-02       325
3            200       2019-02       325
4            300       2019-03       770
5            120       2019-03       770
6            350       2019-03       770
7            500       2019-04       830
8            230       2019-04       830
9            100       2019-04       830
10           200       2019-05       200

I tried df['MonthlyValue'] = df.groupby(['Year-Month'])['Year-Month'].transform(sum) and it doesn't seem to work.

jezrael · Accepted Answer · 2021-06-14 07:30:22Z

2

You are close, need specify column Amount after groupby:

df['MonthlyValue'] = df.groupby('Year-Month')['Amount'].transform('sum')

edited Jun 14, 2021 at 7:30

answered Jun 14, 2021 at 7:24

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Pandas: sum column values against specific value in another column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related