classification of immigration department contracts

immi-contracts.py

import csv
import re
 
fList = ['client','detention','detain','manus','nauru','cocos','keeling','christmas','refugee','unaccompanied','humanitarian','minor','staff accomodation','curtin','villawood','scherger','inverbrackie','derby','construction camp','ita','idc','apod','irh','darwin airport','berrimah','bladin','wickham','phosphate','aqua','lilac','maribyrnong','inverbrackie','serco','transfield','g4s','gsl','toll']

nList = ['pontville','CI','weipa','regional','processing','IMA','tamil','farsi','afghanistan','screening','woomera','yongah']

with open('immigration-contracts.csv','rU') as csvinput:
	with open('output.csv', 'w') as csvoutput:
		writer = csv.writer(csvoutput, lineterminator='\n')
		reader = csv.reader(csvinput, lineterminator='\n')
 
		#Get the headers from the old csv, add to new csv and add our new column header
 
		headers = reader.next()
		writer.writerow(headers)
		
		#loop through the rows in the old csv 
 
		for row in reader:
 
			newrows = []

			for word in nList:
				if (re.search( word.lower()+r'\b', row[1].lower())) or (re.search( word.lower()+r'\b', row[9].lower())):
					for x in xrange(0, len(row)):
						newrows.append(row[x])
					print word
					break	
 
			if newrows:
				print newrows
				writer.writerow(newrows)