Data preparation is a necessary pre-processing step in analytics. It aims to clean the data from various resources and improve its quality for better productivity. This process includes many tasks such as fusion, cleaning, and augmentation of data. This teaching note will focus on illustrating data cleaning using the programming language Python, with all codes completed in Google Laboratory. Different solutions using the programming languages R and Microsoft Excel are also provided. To effectively illustrate the data preparation process, the relatively simple dataset Bengaluru House Prices is used. This is a relatively messy dataset with a few variables and many records, making it ideal for explaining data preparation steps.
看看哪些人也有訂購？