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.