/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

5 votes126 views2 answers
Python pandas drop column by index
Python
0 vote126 views1 answer
Python make string one line
Python
6 votes164 views2 answers
Python cd to file
Python
0 vote120 views1 answer
Python detect tty
Python
6 votes127 views6 answers
Def python
Python
0 vote134 views1 answer
How add a favicon to django
Python
4 votes137 views4 answers
Generate random characters in python
Python
0 vote118 views1 answer
How to get table schema sql pyodbc
Python
7 votes124 views1 answer
Sdjflk
Python
0 vote120 views1 answer
Dataframe number of unique rows
Python