Python csv reader for row in reader gives syntax error

Question

New to Django/Python. I need to write an import script for a CSV file to seed some data (not using fixtures, did that already as that is JSON based and not CSV).

This works:

import csv
from datetime import datetime
from django.utils.timezone import make_aware
from django.core.management.base import BaseCommand
from chatterbox.models import Organisation, Course, Student

class Command(BaseCommand):
    def handle(self, **options):

      CSV_PATH = './students_AEKI.csv'

      Student.objects.filter(organisation__name__exact="AEKI").delete()

      with open(CSV_PATH) as file:
        file.readline() # skip the header
        csv_reader = csv.reader(file, delimiter=',')
        org = Organisation.objects.filter(name="AEKI")

        for row in csv_reader:
          _, Student.objects.get_or_create(
              first_name=row[0],
              last_name=row[1],
              email=row[2],
              organisation=org[0],
              enrolled=row[4],
              last_booking=row[5],
              credits_total=row[6],
              credits_balance=row[7],
              )

This does NOT work:

import csv
from datetime import datetime
from django.utils.timezone import make_aware
from django.core.management.base import BaseCommand
from chatterbox.models import Organisation, Course, Student

class Command(BaseCommand):
    def handle(self, **options):

      CSV_PATH = './students_AEKI.csv'

      Student.objects.filter(organisation__name__exact="AEKI").delete()

      with open(CSV_PATH) as file:
        file.readline() # skip the header
        csv_reader = csv.reader(file, delimiter=',')
        org = Organisation.objects.filter(name="AEKI")

        for row in csv_reader:
          enrolled_utc = make_aware(datetime.strptime(row[4], '%Y-%m-%d'))
          last_booking_utc = make_aware(datetime.strptime((row[5], '%Y-%m-%d'))
          _, Student.objects.get_or_create(
              first_name=row[0],
              last_name=row[1],
              email=row[2],
              organisation=org[0],
              enrolled=enrolled_utc,
              last_booking=last_booking_utc,
              credits_total=row[6],
              credits_balance=row[7],
              )

Syntax error at the "_".

I need to do some manipulation (eg like adding timezone to date fields) on data before creating it in the table. So what is wrong with the 2nd version?

last_booking_utc = datetime.strptime((row[5], '%Y-%m-%d') contains an extra (, is this on purpose? Regardless if it's on purpose or not, the problem is probably with unbalanced parenthesis. — Hampus Larsson
– Hampus Larsson, Commented Apr 15, 2020 at 12:39
@HampusLarsson Thanks, yes I just spotted that too! Updated the answer as it seems that the underscore and indentation are also part of the problem. — rmcsharry
– rmcsharry, Commented Apr 15, 2020 at 12:42

rmcsharry · Accepted Answer · 2020-04-15 12:45:33Z

1

There's a Syntax error at the "_". Remove the trailing characters.

Also this line has an extra bracket:

last_booking_utc = datetime.strptime((row[5], '%Y-%m-%d')

From

        for row in csv_reader:
          enrolled_utc = make_aware(datetime.strptime(row[4], '%Y-%m-%d'))
          last_booking_utc = make_aware(datetime.strptime((row[5], '%Y-%m-%d'))
          _, Student.objects.get_or_create(
              first_name=row[0],
              last_name=row[1],
              email=row[2],
              organisation=org[0],
              enrolled=enrolled_utc,
              last_booking=last_booking_utc,
              credits_total=row[6],
              credits_balance=row[7],
              )

To

        for row in csv_reader:
            enrolled_utc = make_aware(datetime.strptime(row[4], '%Y-%m-%d'))
            last_booking_utc = make_aware(datetime.strptime(row[5], '%Y-%m-%d'))
            Student.objects.get_or_create(
              first_name=row[0],
              last_name=row[1],
              email=row[2],
              organisation=org[0],
              enrolled=enrolled_utc,
              last_booking=last_booking_utc,
              credits_total=row[6],
              credits_balance=row[7],
              )

edited Apr 15, 2020 at 12:45

rmcsharry

5,58111 gold badges74 silver badges118 bronze badges

answered Apr 15, 2020 at 12:28

RMPR

3,5314 gold badges22 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

rmcsharry Over a year ago

Thanks but that gives "SyntaxError: invalid syntax" - look at my 2nd piece of code. The "Student" does not immediately follow the line "for row in csv_reader"

RMPR Over a year ago

Answer edited you need to remove the trailing characters and fix the indentation

rmcsharry Over a year ago

Thank you but I see the real cause is an extra ( on last_boooking_utc line ((row[5]. What is the purpose of the underscore then?

Hampus Larsson Over a year ago

A singular underscore is often just used as a "placeholder" in certain loops where the variable it holds is mostly discarded. A more complete answer can be found here.

rmcsharry Over a year ago

@HampusLarsson That leads me to this next question. Perhaps you have time to answer it? stackoverflow.com/questions/61229166/…

Collectives™ on Stack Overflow

Python csv reader for row in reader gives syntax error

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related