You have a dataset with both numerical and categorical features, some with missing values. How would you build a preprocessing pipeline that handles all these cases appropriately?

Sample answer preview

Building a preprocessing pipeline for mixed data types requires combining ColumnTransformer with individual transformation pipelines for each column type. This approach handles the complexity while maintaining clean, reproducible code.