def open_file(path): reader = csv.reader(open(path, 'r'), delimiter=',', dialect='excel') participants = [] participant = None rownum = 0 for row in reader: participant_id = None marathon_date = None marathon_name = None marathon_type = None marathon_time = None marathon_category = None #participant.append(row) if rownum == 0: header = row else: colnum = 0 for col in row: if header[colnum] == "PARTICIPANT ID": participant_id = col participant = Participant(col) elif header[colnum] == "EVENT DATE": marathon_date = col elif header[colnum] == "EVENT NAME": marathon_name = col elif header[colnum] == "EVENT TYPE": marathon_type = col elif header[colnum] == "TIME": marathon_time = col if marathon_time == "-1": participant.failed_times += 1 elif header[colnum] == "CATEGORY": marathon_category = col participant.total_marathons += 1 participant.add_marathon(marathon_date, marathon_name, marathon_type, marathon_time, marathon_category) else: print("Exception!") colnum += 1 participants.append(participant) rownum += 1 return participants