Groupby month and year pandas

Asked Dec 01 '20 at 11:14

Active Dec 01 '20 at 11:37

Viewed 9 times

I extract from date(e.g. 2020-11-19) to separe column year and month. Now i need group by "Celkem" to month. When i use sum() i have a problem that it also counts a year as column "Celkom" On each line need to have year for row in sql.

          Celkem  year  month
11     17.47  2020     11
19    305.10  2020     11
22   1197.50  2020     11
23   1848.10  2020     10
..       ...   ...    ...
288   369.59  2017     10
289    47.00  2017     10
290   277.00  2017     10

Expact:

1     1520.07  2020     11
2     1848.10  2020     10
3     .......  2020     9
4     .......  2020     8

edited Dec 01 '20 at 11:37

asked Dec 01 '20 at 11:14

Roman

Do you need `df.groupby('month')['Celkem'].sum()` ? – jezrael Dec 01 '20 at 11:17
Not working make same df as without this. – Roman Dec 01 '20 at 11:27
Make sum of "Celkem" by month. I try df_data.groupby(['month','year'])['Celkem'].sum().reset_index() / df_data.set_index(['year','month']).sum(level=[0,1]) / df_data.groupby(['year', 'month']).agg({'Celkem': "sum"}) – Roman Dec 01 '20 at 11:28
1 1520.07 2020 11 / 2 1848.10 2020 10 – Roman Dec 01 '20 at 11:30
1

Super, so `df = df.groupby(['month','year'], sort=False)['Celkem'].sum().reset_index()` working for me perfectly, for you not? – jezrael Dec 01 '20 at 11:35
Also why is division there `/ df_data.set_index(['year','month']).sum(level=[0,1]) / df_data.groupby(['year', 'month']).agg({'Celkem': "sum"})` ? – jezrael Dec 01 '20 at 11:35
I try what i find on stackoverflow but no group by month – Roman Dec 01 '20 at 11:39
1

Sorry with df = df.groupby(['month','year'], sort=False)['Celkem'].sum().reset_index() this work perfect. – Roman Dec 01 '20 at 11:42
Na Slovensko len excel tabulka je z Ceskeho softwareu. – Roman Dec 01 '20 at 11:45
Tak este lepsie, ;) – jezrael Dec 01 '20 at 11:45

Groupby month and year pandas

0 Answers0