/Python/Delete duplicates from db django the most efficient way

Delete duplicates from db django the most efficient way

Django model remove duplicates

from django.db.models import Count
from app.models import Email

duplicate_emails = Email.objects.values('email').annotate(email_count=Count('email')).filter(email_count__gt=1)

Source: newbedev.com

Removing duplicates from django models data

for duplicates in Tag.objects.values("name").annotate(
    records=Count("name")
).filter(records__gt=1):
    for tag in Tag.objects.filter(name=duplicates["name"])[1:]:
        tag.delete()

Source: djangotricks.com

Similar codes

17 votes191 views3 answers
Python print object
Python
0 vote178 views1 answer
Passport ocr python
Python
0 vote197 views1 answer
Value_count pandas change column name
Python
4 votes201 views1 answer
How to round the values in a list
Python
0 vote200 views2 answers
Python verifier qu'un string est un chiffre
Python
0 vote194 views1 answer
Install pytorch on nvidia jetson nx
Python
0 vote231 views4 answers
Write in multiple files python
Python
4 votes218 views2 answers
Split filename and extension python
Python
0 vote202 views1 answer
How to average only positive number in array numpy
Python
2 votes203 views2 answers
Pandas update with condition
Python