Mailman Faculty Parsing

mailman-faculty-parsing.py

import re, csv

reg = re.compile('(?<=Name: )(?P<faculty_name>.+)(?= HUID).+(?<=NETID: )(?P<faculty_3x3>.+)(?= EPPN)')

with open('grouper-export/groupExportAll_SPHFaculty.csv') as fdata:
    freader = csv.reader(fdata)
    with open('faculty-filenames.csv', 'w') as ffile:
        fieldnames = ['faculty_name', 'faculty_3x3', 'filename']
        writer = csv.DictWriter(ffile, fieldnames=fieldnames)
        writer.writeheader()
        for row in freader:
            result = reg.finditer(row[1])
            for obj in result:
                rowDict = obj.groupdict()
                rowDict['filename'] = rowDict['faculty_3x3'] + '.jpg'
                writer.writerow(rowDict)