Problem set 2-5 - Fixing Turnstile Data

import csv

def fix_turnstile_data(filenames):
    '''
    Filenames is a list of MTA Subway turnstile text files. A link to an example
    MTA Subway turnstile text file can be seen at the URL below:
    http://web.mta.info/developers/data/nyct/turnstile/turnstile_110507.txt
    
    As you can see, there are numerous data points included in each row of the
    a MTA Subway turnstile text file. 

    You want to write a function that will update each row in the text
    file so there is only one entry per row. A few examples below:
    A002,R051,02-00-00,05-28-11,00:00:00,REGULAR,003178521,001100739
    A002,R051,02-00-00,05-28-11,04:00:00,REGULAR,003178541,001100746
    A002,R051,02-00-00,05-28-11,08:00:00,REGULAR,003178559,001100775
    
    Write the updates to a different text file in the format of "updated_" + filename.
    For example:
        1) if you read in a text file called "turnstile_110521.txt"
        2) you should write the updated data to "updated_turnstile_110521.txt"

    The order of the fields should be preserved. Remember to read through the 
    Instructor Notes below for more details on the task. 
    
    In addition, here is a CSV reader/writer introductory tutorial:
    http://goo.gl/HBbvyy
    
    You can see a sample of the turnstile text file that's passed into this function
    and the the corresponding updated file in the links below:
    
    Sample input file:
    https://www.dropbox.com/s/mpin5zv4hgrx244/turnstile_110528.txt
    Sample updated file:
    https://www.dropbox.com/s/074xbgio4c39b7h/solution_turnstile_110528.txt
    '''
    for name in filenames:
        f_in  = open(name, 'r')
        f_out = open("updated_" + name, 'w')
        reader_in = csv.reader(f_in,delimiter = ',')
        writer_out = csv.writer(f_out,delimiter = ',')
        
     
        
        for line in reader_in:
            for i in range(1,len(line)-3):
                writer_out.writerow(line[0:3] + line[5*i-2:5*i+3]) 

    f_in.close()
    f_out.close()

    updated_rows=[]
    for line in reader_in:
        updated_row = line[0:3]
        for i in range(0,len(line[3:len(line)])):
            updated_row.append(line[i+3])
            if (i + 1) % 5 == 0:
                updated_rows.append(updated_row)
                updated_row = line[0:3]
    writer_out.writerows(updated_rows)