officewhe.blogg.se - Python write list to file tab delimited

Print the comma-delimited format using the appropriate variable valuesĬpp_list = list(csv.reader(f1, delimiter = "\t"))Īcad_subplan = "" if len(row) < 5 else rowĪdmit_term = "2158" if len(row) < 6 else row.

The good news: the majority of these fields have default values, which allowed me to quickly write a Python program to transform the tab-delimited file into the necessary comma-delimited format.

Subplan = concentration (e.g., American Literature or Molecular Biology).

Plan = area of study (e.g., English, Biology, or Economics).Program = degree (e.g., B.A., M.A., or Ph.D.).Career = type of degree (e.g., undergraduate, graduate, or professional).For those not familiar with PeopleSoft terminology, CPP data is the foundation of a student’s academic record.īasically, CPP consists of the following:

This week I was tasked with creating several thousand Career/Program/Plan records (CPP for short) to support enrollment conversion.