quick and dirty parsing for naviance college admission results

college_parser.py

#script for parsing Mrs. Cao's file.

import csv

original = csv.reader(open('/Users/Eric/Desktop/destinations.csv','rU'))
f = open('/Users/Eric/Desktop/formattedList.txt', 'w')

current = ""
for row in original:
	college = row[2]
	if college != current:
		f.write('\n' + college + '\n--------------\n')
		current = college
		#format the name
		name = row[0].split(', ')[1] + ' ' + row[0].split(', ')[1]
		f.write(name+'\n')
	else:
		#same college as previous
		name = row[0].split(', ')[1] + ' ' + row[0].split(', ')[0]
		f.write(name+'\n')
		
f.close()