#!/usr/bin/python inputFile=open('cw1-results.csv','r') # Open the results file lineNum = 0 # No. lines read in teams = [] # List of teams times = [] # List of teams' total times for line in inputFile: # Loop over lines in file lineNum = lineNum + 1 if lineNum > 1: # Ignore the header line = line.rstrip('\n') columns = line.split( ',' ) legTime = int( columns[3] ) #print columns # # Is team name already stored? # teamNum = -1 for l1 in range( len( teams ) ): if columns[0] == teams[l1]: teamNum = l1 if teamNum == -1: teams.append( columns[0] ) # Append team name times.append( legTime ) # Append time of first runner in this team #print teams, times else: times[teamNum] = times[teamNum] + legTime print teams print times