Header Standardisation

Check and normalise the header row of a flat dataset so every column name follows one convention, and reconcile against a data dictionary if one exists.

When to invoke

• User wants to check that the header row adheres to a standard (e.g. snake_case).
• User is about to create a data dictionary and wants headers normalised first so the dictionary can mirror them.
• Existing data dictionary uses one convention but the dataset's headers drifted.
• Preparing for SQL load — mixed-case or space-containing headers are fragile.

Conventions supported

• snake_case — lowercase, underscores (SQL-friendly, default recommendation)
• camelCase — first word lowercase, subsequent capitalised
• PascalCase — all words capitalised, no separator
• kebab-case — lowercase, hyphens (avoid for SQL)
• Title Case — human-friendly, space-separated
• SCREAMING_SNAKE_CASE — constants/enums