How to impute missing data values

Real-world data will often have missing values. Sometime you can just remove the rows with the missing values. For example, where you are working with large amounts of data with a few values ‘missing at random’, then removing a small number of rows is unlikely to affect the overall results. In other situations it might be preferable to ‘impute’ the missing values from other data in the same column. You can easily do this in Easy Data Transform using the Impute transform.

For example to impute the missing ages of Titanic passengers based on the average (mean) age of all passengers:

To impute the missing ages of Titanic passengers based on the median age of all passengers with the same passenger class and sex:

See the video above for more details.

Easy Data Transform can also help with converting, cleaning, filtering and enriching your data. All without coding.