/Python/Django orm group by month and year

Django orm group by month and year

print([v for v in
       Request.objects.annotate(month=ExtractMonth('date_creation'),
                                year=ExtractYear('date_creation'),)
                      .order_by()
                      .values('month', 'year')
                      .annotate(total=Count('*'))
                      .values('month', 'year', 'total')
       ])

Source: stackoverflow.com

Similar codes

2 votes171 views2 answers
Split datetime to date and time pandas
Python
0 vote156 views1 answer
How to find how many processors you have with python
Python
0 vote165 views1 answer
Pandas read csv dtype list
Python
10 votes186 views2 answers
How to find duplicate numbers in list in python
Python
1 vote158 views1 answer
Python edit string variable
Python
28 votes163 views6 answers
Flatten list python
Python
0 vote156 views1 answer
Python long numbers as string
Python
1.2K votes582 views10 answers
Twitch
Python
0 vote167 views1 answer
Argsort in descending order numpy
Python
3 votes169 views3 answers
Remove x label matplotlib
Python