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])