How to use ColumnTransformer to apply transformations to Dataframe columns in Python?

Hello everyone, I was learning about pre-processing tools used in Machine Learning and found a common tool called ColumnTransformer which basically can be used to apply transformations to different columns of the dataset. Can anyone tell me more about this tool and how to write its code to apply different transformations to both categorical and numerical columns? Please provide me with example codes so that I can understand this tool better, you can use the following sample dataset in your code to apply transformations.

Note: In this sample dataframe, columns Embarked and Sex are categorical and columns Fare and Age are numerical. You can use these columns in your examples.