You can check Géron's book to know more about data preparation, specifically the second chapter. This chapter details an end-to-end machine learning project (price prediction). Here, the author describes scikit learn's pipelines for automating preprocessing tasks for your dataset.