Массовое редактирование CSV базы

import csv

infile = file("courses.csv", "r")
outfile = file("out.csv", "w")

reader = csv.reader(infile , dialect='excel')
writer = csv.writer(outfile , dialect='excel')

for inrow in reader:
    
    course_code = inrow[0][inrow[0].find("(")+1:inrow[0].find(")")]
    course_name = inrow[0][:inrow[0].find("(")][:-1]

    writer.writerow([course_code]+[course_name]+inrow[2:])
    
    continue

infile.close()
outfile.close()

sed 's/\([^(]*\) (\([^)]*\))/\1,\2/' <courses.csv >out.csv

course_name, course_code = map(lambda x:x[:-1],inrow[0].split('('))

import re
rex=re.compile(r'(?P<name>\w+) \((?P<code>\w+)\)')
...
mo=rex.search(inrow[0])
if mo:
    course_name = mo.group('name')
    course_code = mo.group('code')