You receive a raw dataset with mixed types, missing values, outliers, and high-cardinality categorical features. Walk me through designing a complete preprocessing pipeline that handles all these challenges.

Sample answer preview

Designing a complete preprocessing pipeline requires systematic handling of different data types and challenges while preventing data leakage and maintaining reproducibility. Start with exploratory analysis to understand the data.