how to import csv data into django models

by

You want to use the csv module that is part of the python language and you should use Django’s get_or_create method

 with open(path) as f:
        reader = csv.reader(f)
        for row in reader:
            _, created = Teacher.objects.get_or_create(
                first_name=row[0],
                last_name=row[1],
                middle_name=row[2],
                )
            # creates a tuple of the new object or
            # current object and a boolean of if it was created

In my example the model teacher has three attributes first_name, last_name and middle_name.

Django documentation of get_or_create method

More Related Contents:

  1. Django dynamic model fields
  2. Django set default form values
  3. In Django, how does one filter a QuerySet with dynamic field lookups?
  4. Django Aggregation: Summation of Multiplication of two fields
  5. Django post_save() signal implementation
  6. What is the most efficient way to store a list in the Django models?
  7. difference between filter with multiple arguments and chain filter in django
  8. LEFT JOIN Django ORM
  9. django.db.migrations.exceptions.InconsistentMigrationHistory
  10. Is this the way to validate Django model fields?
  11. Django Blob Model Field
  12. Django Many-to-Many (m2m) Relation to same model
  13. How to have a Python script for a Django app that accesses models without using the manage.py shell?
  14. How to display uploaded images in “Change List” page in Django Admin?
  15. How to change the file name of an uploaded file in Django?
  16. How to monkey patch Django?
  17. Easiest way to rename a model using Django/South?
  18. matching query does not exist Error in Django
  19. Django admin file upload with current model id
  20. Good ways to sort a queryset? – Django
  21. Resize fields in Django Admin
  22. Get the latest record with filter in Django
  23. Django DoesNotExist
  24. Generic many-to-many relationships
  25. python_2_unicode_compatible error
  26. How to validate uniqueness constraint across foreign key (django)
  27. How to store a dictionary on a Django Model?
  28. How to properly use the “choices” field option in Django
  29. update django database to reflect changes in existing models
  30. Django admin – inline inlines (or, three model editing at once)

Leave a Comment