KIC Spheroid Calcium Pipeline (Script 02b/03) – Multi-Batch Dataset Integration

KIC Spheroid Calcium Pipeline — Script 02b/03 GUI-based R pipeline for merging multiple batch-level merged.csv datasets generated in Script 02a into a unified multi-batch dataset. What's included GUI selection of input/output paths Recursive scanning for merged.csv files Merging of multiple batch-level datasets into a unified multi-batch table Automatic column alignment across batches (NA fill for missing columns) Preservation of logical flags generated in Script 02a (keep_1hz, valid_well) Retention of assigned metadata (Group, optional RowGroup, Batch) Integrity checks for missing metadata and duplicate well identifiers Export of a standardized merged_raw.csv file Inputs merged.csv files generated in Script 02a Nested folder structures supported (recursive search enabled) Required columns: Well Batch Group Num.Peaks Optional but recommended: RowGroup keep_1hz valid_well Outputs merged_raw.csv containing: All standardized MEANS summary statistics Preserved filtering flags Assigned Group Optional RowGroup Batch identifiers Source tracking metadata Dataset is standardized and ready for statistical modeling, cross-group comparisons, multi-batch integration, and downstream visualization (Script 03). Citation Developed by Michele Buono, Talitha Spanjersberg, Nikki Scheen, and Nina van der Wilt.Free for research use and adaptation with citation via Zenodo.