i'm learning python but i'm having trouble combining daily frequency into monthly frequency as below
Date | Count |
---|---|
2020-01-01 | 1 |
2020-01-02 | 2 |
2020-01-03 | 0 |
... | ... |
2021-01-01 | 0 |
2021-01-02 | 3 |
how to make the dataframe above (data per daily) be like below (Data Per Monthly)
Date | Count |
---|---|
Jan-2020 | 15 |
Feb-2020 | 25 |
... | ... |
Jan-2021 | 21 |
Feb-2021 | 15 |