/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

0 vote195 views1 answer
Displace items in array python
Python
0 vote219 views2 answers
Remove leading and lagging spaces dataframe python
Python
25 votes228 views6 answers
Import python file from another directory
Python
0 vote202 views1 answer
Lowercase all text in a column
Python
2 votes231 views1 answer
Pyspark session
Python
9 votes191 views6 answers
Np.random.choice
Python
0 vote184 views1 answer
Files and exceptions not working python
Python
19 votes210 views2 answers
How to avoid deprecation warning in python
Python
-1 vote197 views3 answers
Isodate in python
Python
33 votes187 views5 answers
Python exit program
Python