Programming Challenge: Legacy System Data Migration (Jan 19, 2025)

Enterprises often have outdated legacy databases that need to be migrated to a modern system. Your task is to write a script that:

✅ Reads data from a CSV file (simulating a legacy database dump)
✅ Cleans up the data (e.g., removing duplicates, fixing inconsistencies)
✅ Converts it into a new format (e.g., JSON, SQL inserts)

Bonus Features:

• Allow the user to specify mappings (e.g., "Column X should be renamed to Field Y").

• Implement data validation (e.g., emails must be in valid format).

• Provide a summary report of how many records were migrated.

Example Output:

Processing legacy_data.csv...
Total records: 10,000
Duplicates removed: 53
Invalid emails fixed: 12
Data successfully converted to output.json

🔹 Why this matters: Enterprises constantly deal with data migrations, making this a great real-world challenge for IT professionals!