Data Comparability

Propose a concrete plan to align two or more datasets so they can be safely merged, unioned, or cross-analysed.

When to invoke

• User has two or more tabular datasets (CSV / Parquet / Excel / JSON) and wants to compare, join, or union them.
• Column names differ between sources (e.g. country vs nation vs Country_Name).
• Same logical field has different types across files (e.g. year is int in one, string in another).
• Same categorical field has divergent vocabularies (e.g. status: "active" vs "Active" vs "A" vs "1").

Procedure