[Python] Pandas dataframe, resample for individual values in my column

I have a pandas dataframe that looks like this:

Date Country Value
0 2021-10-22 GB 98.139514
1 2021-11-29 GB 103.875788
2 2021-12-29 GB 111.097210
3 2021-12-24 GB 112.792079
4 2021-10-23 GB 107.566157
... ... ... ...
26043 2025-06-16 FR 0.714671
26044 2025-03-20 FR 0.721872
26045 2025-03-31 FR 0.699370
26046 2025-04-02 FR 0.728173
26047 2025-01-19 FR 0.635464


I would like to resample into monthly data for each country. I have tried the following:

merged_df.set_index('Date', inplace=True)
monthly_values = merged_df.groupby('Country').resample('M').sum()


This gives me almost what I am looking for, but not quite:

Country Value
Country Date
AT 2020-01-31 ATATATATATATATATATATATATATATATATATATATATATATAT... 67.844284
2020-02-29 ATATATATATATATATATATATATATATATATATATATATATATAT... 61.920792
2020-03-31 ATATATATATATATATATATATATATATATATATATATATATATAT... 63.493249
2020-04-30 ATATATATATATATATATATATATATATATATATATATATATATAT... 53.647165
2020-05-31 ATATATATATATATATATATATATATATATATATATATATATATAT... 55.296130
... ... ...
RO 2025-02-28 RORORORORORORORORORORORORORORORORORORORORORORO... 643.976598
2025-03-31 RORORORORORORORORORORORORORORORORORORORORORORO... 714.388839
2025-04-30 RORORORORORORORORORORORORORORORORORORORORORORO... 672.837984
2025-05-31 RORORORORORORORORORORORORORORORORORORORORORORO... 685.951395
2025-06-30 RORORORORORORORORORORORORORORORORORORORORORORO... 561.900990


Could anyone point me in the right direction?

See above for problem and expected output

Continue reading...