/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 vote175 views1 answer
R Return each result with an index
Python
1 vote172 views1 answer
How to use python to print multiplication table
Python
3 votes162 views3 answers
How to take input in 2d list in python
Python
6 votes227 views6 answers
Install pip python 3.9
Python
1 vote175 views1 answer
Split a path into all subpaths
Python
2 votes213 views2 answers
Pandas seaborn distplot
Python
1 vote194 views1 answer
Python selenium itemprop
Python
2 votes224 views3 answers
Check if value exists in list python
Python
1 vote171 views1 answer
How to replace a row value in pyspark dataframe
Python
4 votes184 views2 answers
How to count non null values in pandas
Python