/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 vote108 views1 answer
Def extract_title(input_df):
Python
0 vote95 views1 answer
Python how to add a string to the beginning of a list
Python
0 vote130 views2 answers
Django get superuser password
Python
0 vote125 views1 answer
Python conda how to see channels command
Python
0 vote101 views1 answer
Apply strip() a column in pandas
Python
2 votes96 views1 answer
How to move the pointer on screen using python
Python
0 vote125 views1 answer
Using claudinary in django
Python
20 votes105 views4 answers
Python pandas read_excel
Python
0 vote102 views2 answers
Logging the terminal output to a file
Python
9 votes104 views2 answers
Python script to read all file names in a folder
Python