Lookup Merge Utilities (Safe, Transactional, UTF-8) — lookup_merge

Utilities to safely read, merge, and write the participant lookup configuration (section_names_lookup.csv). All operations are read-then-merge in memory; writes are opt-in and transactional with timestamped backups to prevent accidental data loss.

Details

Expected columns in lookup data frame:

transcript_name
preferred_name
formal_name
participant_type (e.g., instructor, enrolled_student, guest, unknown)
student_id
notes (optional)