Python Data Pipeline Builder

Write a Python data pipeline that accomplishes the following:

Input data: {{input_description}} Desired output: {{output_description}} Transformations needed: {{transformations}}

Requirements:

1. Use pandas for data manipulation
2. Include proper error handling for common data issues (missing values, wrong types, duplicates)
3. Add logging at each major step
4. Make the pipeline idempotent (safe to run multiple times)
5. Include data validation checks before and after transformation
6. Add type hints and docstrings
7. Make it modular — each transformation should be a separate function

Also provide:

• A sample test with mock data
• Performance tips if the dataset is large (>1M rows)
• A brief explanation of each transformation step