def as_csv(self, csvpath):
"""Output a CSV representation of a program"""
headings = [
'ipeds_unit_id', 'ope_id', 'program_code', 'program_name',
'program_length', 'program_level', 'accreditor', 'median_salary',
'average_time_to_complete', 'books_supplies', 'campus_name',
'cip_code', 'completion_rate', 'completion_cohort', 'completers',
'default_rate', 'job_placement_rate', 'job_placement_note',
'mean_student_loan_completers', 'median_student_loan_completers',
'soc_codes', 'total_cost', 'tuition_fees', 'test'
]
with open(csvpath, 'w') as f:
writer = csw(f)
writer.writerow(headings)
writer.writerow([
self.institution.school_id, '', self.program_code,
self.program_name, self.program_length, self.level,
self.accreditor, self.salary, self.time_to_complete,
self.books, self.campus, self.cip_code,
"{}".format(self.completion_rate), self.completion_cohort,
self.completers, "{0}".format(self.default_rate),
"{0}".format(self.job_rate), self.job_note,
self.mean_student_loan_completers,
self.median_student_loan_completers, self.soc_codes,
self.total_cost, self.tuition, self.test
])
def dump_csv(fpath, header, data):
with open(fpath, 'w') as f:
writer = csw(f)
writer.writerow(header)
for row in data:
writer.writerow([row[heading] for heading in header])
def write_clean_csv(fpath, fieldnames, clean_headings, data):
with open(fpath, 'w') as f:
writer = csw(f)
writer.writerow(clean_headings)
for row in data:
writer.writerow([row[name] for name in fieldnames])
