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:

impute example

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

impute missing data

See the video above for more details.

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

Try it free now!

Windows Logo Windows Download

v1.31.0 for Windows 11 / 10 / 8 / 7 (43 MB)

Apple Logo Mac Download

v1.31.0 for Mac 12.x to 10.13 (43 MB)


Questions or problems?

Email support@easydatatransform.com