A study on missing values imputation using K Harmonic means algorithm: Mixed datasets
Data cleaning is one step in the preprocessing which in the process often found missing values in the dataset. Missing values is the condition of the absence of data items on a subject. A quick step that can be taken to handle missing values is to remove data containing missing values, but this can reducing information in the data. Another way to handle missing values is by using imputation with mean, median, or mode, and several methods of imputation such as regression, likelihood, and the clustering approach. Imputation with the clustering approach is the focus of this study, where we used the K Harmonic Means which has been adjusted to handle mixed data. K Harmonic Means is an extension of K Means by reducing random centroid initialization sensitivity problems. Imputation of the missing values is carried out by distributing missing values observation to the cluster and replacing the missing values with the information on the same centroid cluster. The results of the simulation were evaluated using the root mean square error and the accuracy values of each imputation value for numerical and categorical data respectively.Data cleaning is one step in the preprocessing which in the process often found missing values in the dataset. Missing values is the condition of the absence of data items on a subject. A quick step that can be taken to handle missing values is to remove data containing missing values, but this can reducing information in the data. Another way to handle missing values is by using imputation with mean, median, or mode, and several methods of imputation such as regression, likelihood, and the clustering approach. Imputation with the clustering approach is the focus of this study, where we used the K Harmonic Means which has been adjusted to handle mixed data. K Harmonic Means is an extension of K Means by reducing random centroid initialization sensitivity problems. Imputation of the missing values is carried out by distributing missing values observation to the cluster and replacing the missing values with the information on the same centroid cluster. The results of the simulation were evaluated using the