C. elegans Lifespan Data Conversion

This python script helps convert a user friendly excel datasheet for lifespan experiments to a Prism compatible format. The script expects an excel file with separate sheets for each strain/condition (see the Template for an example). Within each sheet, the script expects a minimum of 5 columns: TA, TD, TM, TE, and TB for Total Alive, Total Dead, Total Missing, Total Explode, and Total Bagged. Each row of this sheet should be a timepoint (adult age in days). The script will take the data in the 5 columns and convert it into a new excel that is compatible with Prism's survival format. Specifically, it will create a row for every dead, missing, explode, and bagged event for each condition and assign it 0 or 1, with 0 for censored animals and 1 for natural death. This reformatted data can be copy and pasted (or linked) into Prism for convenience.