I have this dataset
| year | month | account | value |
| —- | —– | ——- | —— |
| 2023 | 1 | 1234 | 1 |
| 2023 | 1 | 9372 | 3 |
| 2023 | 2 | 1234 | 2 |
| 2023 | 2 | 8735 | 2 |
| 2024 | 1 | 8735 | 9 |
| 2024 | 1 | 0000 | 6 |
I want to by grouping year and month, every year and month have all distinct account and if that account doest exist in that year and month, the value will be 0.
How should I solve this?