alexa Treatment of Missing Values in Data Mining | OMICS International
ISSN: 0974-7230
Journal of Computer Science & Systems Biology

Like us on:

Make the best use of Scientific Research and information from our 700+ peer reviewed, Open Access Journals that operates with the help of 50,000+ Editorial Board Members and esteemed reviewers and 1000+ Scientific associations in Medical, Clinical, Pharmaceutical, Engineering, Technology and Management Fields.
Meet Inspiring Speakers and Experts at our 3000+ Global Conferenceseries Events with over 600+ Conferences, 1200+ Symposiums and 1200+ Workshops on
Medical, Pharma, Engineering, Science, Technology and Business

Treatment of Missing Values in Data Mining

Waqas I*, Syed Saeed-Ur-Rahman S, Imran MJ and Rehan A
Superior University, Lahore, Pakistan
*Corresponding Author : Waqas I
Superior University, Lahore, Pakistan
E-mail: [email protected]
Received February 06, 2016; Accepted February 29, 2016; Published March 03, 2016
Citation:Waqas I, Syed Saeed-Ur-Rahman S, Imran MJ, Rehan A (2016) Treatment of Missing Values in Data Mining. J Comput Sci Syst Biol 9:051-053. doi:10.4172/jcsb.1000221
Copyright: © 2016 Waqas I, et al. This is an open-access article distributed under the terms of the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original author and source are credited.

Visit for more related articles at Journal of Computer Science & Systems Biology


Data mining has pushed the realm of information technology beyond predictable limits. Data mining has left its permanent marks on decision making in just in few years of its inception. Missing value is one of the major factor, which can render the obtain result beyond use attained from specific data set by applying data mining technique. There could be numerous reasons for missing values in a data set such as human error, hardware malfunction etc. It is imperative to tackle the labyrinth of missing values before applying any technique of data mining; otherwise, the information extracted from data set containing missing values will lead to the path of wrong decision making. There are several techniques available to control the issue of missing values such as replacing the missing value with: (a) closest value, (b) mean value and (c) median value etc. Some algorithms are also used to deal with the problem of missing values such as k-nearest neighbour. Paper reviewed certain techniques and algorithms to deal with the puzzle of missing values whereby achieving pure data set (i.e., data set without missing value) which in-turn will lead to path of correct and accurate decision making.

Data mining; Missing value; Treatment of missing value
Missing data is one of the issues which are to be fathomed for real-time application. Improper imputation produces predisposition result. For example, manual information entrances system, inaccurate estimations, gear blunders, and numerous others. Hence legitimate consideration is expected to credit the missing values. Missing Data will not make any impact on the result if its percentage is less 1%, if missing data’s range within the range of 1-5% then it is somehow manageable; however in case of 5-15% complex techniques are used for handling the problems of missing data but if it exceeds from 15% then it will surely hinder the result achieved after applying data mining techniques [1]. Often, missing values appears as “NULL” in databases or it can be represented as empty cells in spreadsheet. Whereas, some flat-files use others symbols as well to indicate the missing values like “?” etc. If missing values are represented from any above depicted symbol then it is somewhat easier to identity and elucidates them but missing data can also be appeared as outliers or wrong data. These wrong data must be removed before performing analysis to get the result according to expectation [2].
Ordinary and modern strategies are there for handling this issue. The variables may be: (a) missing completely at random, (b) missing at random and (c) missing not at random. Each variable should be managed freely. Imputation techniques help to credit the missing values. Pre-processing must be carried out before imputing the values by imputation techniques. K-NN algorithm is utilized to gathering the data set into distinctive gatherings. After grouping of data, missing information in every gathering is imputed by mean, median and standard deviation. The results are compared in distinctive rate of precision [3].
Categories of Missing Data
Statistician categorized missing data into three categories as: (a) Missing at Random (MAR) (b) Missing Completely at Random (MCAR) and (c) Missing Not at Random (MNAR) [4].
According to Rubin, MAR is to be a condition in which the probability that data are missing depends only on the observed data but on the missing data, after controlling for observed data [5,6]. Missing completely at random (MCAR) is the prospect of a record possessing a missing value of the attribute but it does not depends on the missing data or the observed data [6]. Not missing at Random (NMAR) is the probability of a record containing missing value of field that depends on the value of attire [2].
Missing Values Problem
According to Luengo J, three issues are interlinked in the domain of missing values: (a) decrease in efficiency, (b) hurdles in analyzing and managing the data (c) differences between missing and complete data that impact on the result [2]. Missing Values issue must be tackled by attributing values by utilizing effective imputation method [7]. Loss of effectiveness is brought about by tedious procedure of managing missing values. It is somehow coupled with the second issue difficulties in managing and exploring information from data. Difficulties in tackling and data dissecting lie truth told that many techniques or calculations are normally not able for tackling missing values and issue of missing values should be comprehended preceding investigations amid data readiness stage. The other issue inclination coming about because of contrasts in between of missing values and non-missing values data lies indeed that attributed values are not the similar as estimated finished dataset [2].
Methods of Imputation
The process of replacing attributed values from the available data is known as Imputation. There are some imputation techniques which lie in the regime of: (a) regulated and (b) unsupervised. However, Listwise and Pairwise deletion erases entire line [3].
Standard deviation
It calculates the feast of information to the mean worth. Standard deviation is helpful while looking at dataset having the similar mean yet an alternate extent. It is the square base of the change which makes it easier to interpret. It is the most often utilized measure of scattering [8].
Mean substitution
Mean imputation technique is a standout amongst the most commonly used strategies. Mean substitution replaces missing values on a variable with the mean estimation of the observed values. The imputed missing values are dependent upon one variable– the between subjects mean for that variable based on accessible data. Mean substitution jelly the mean of a variables distribution; nonetheless, mean substitution regularly twists different attributes of a variables circulation. Utilizing constants to swap missing data will change the feature for the original dataset; overlooking the relationship among properties will predisposition the accompanying data mining algorithm. A variation of this technique is to swap the missing value of a characteristic with mean of acknowledged estimations of those values where chance of missing data has a place [9].
Median substitution
Mean or median substitution of covariates and result variables is still regularly utilized. The median is essentially as same as the mean. It is determined through gathering of data and calculating average. Median imputation brings about the average of the whole data set being the same as it would be with case deletion, yet the variability between individual’s reactions is diminished, biasing differences and covariance’s toward zero. Since the mean is influenced by the outliers appears common to utilize the median rather to just guarantee power. In this scenario, the absent information of a characteristic is replaced through the median of acknowledged values [2].
Median can be calculated by the given formula.
Where L is the length and n is the total number of items.
Regression imputation
This is one of the expansive strategies for imputation missing values. There are different regression techniques.
The linear regression: The linear regression which utilized for numeric variables and logistic regression is utilized for categorical data. The linear regression is chip away at linear capacity in view of likelihood and the logistic regression is deal with logistic function in view of likelihood yet it has just two possible outcomes for likelihood [10].
The linear regression can be calculated by the formula as follow:
Where Y is the explanatory variable and Z is dependent variable, d represents the slope of line and c represent the intercept.
The random regression: The random regression imputation which discover missing values for any variable in view of conditional distribution. It imputes the value in view of contingent dispersion of Y given X. It is more successful for numeric data [10].
Closest fit
The closet fit algorithm depends upon exchanging absent values with present value of the similar attribute of other likewise cases. Main notion is to find out from dataset likewise scenarios and select the likewise case to the case in discussion with missing attribute values [2].
K-nearest neighbour algorithm
It is a strategy for gathering cases in view of likeness from different cases. In the prospect of machine learning, it had created as an approach to perceive samples without obliging a precise match with any stockpile designs, or scenarios. Comparable scenarios are close to one another and unique cases are inaccessible from one another. Consequently, the difference of two scenarios is a degree of their uniqueness. Likewise scenarios are said to be “neighbours”. When another scenario is brought into consideration, its variation from each of the scenario in the model is processed. Orders of the comparable cases–closest neighbours– are matched and the new case is set that possess the best amount of closest neighbours [1].
In this system the principle component is Distance measurements. In 1NN imputation system we can supplant the missing values with the closest neighbour. At the same time if the estimation of K is more than one then supplant the missing value with the mean of K-closest neighbours. Here we talk about the one attribution technique which is said to be regression imputation which we as of now talked about above. The imputation techniques for missing value incorporate parametric regression imputation techniques and nonparametric regression imputation strategies. Non-parametric imputation models are K-closest neighbour or kernel regression.
In which we have no relationship in the middle of depended and autonomous variables. Parametric imputation model is Expectation Maximization (EM). In which we know the piece of relationship in the middle of depended and autonomous variables. Preference of Nonparametric imputation contrast with EM-parametric imputation. More effective for moderate size datasets. In parametric models the data are not fitted because it is less defenceless to slips. At the point when models of the information are not Apriori then this system is more exact [10].
The K- nearest neighbour calculation does not make express models. There are a few progressions for using acknowledged values of K-closest neighbour. One plausibility for numeric attributes is to attribute a mean of the closest neighbours’ characteristic values. Weights are contrariwise proportional to the distance from the neighbouring sections [2].
At Section Methods of Imputation, we elaborate different techniques to tackle and handle the missing values before applying the Data Mining tricks (at Pre Data Mining Stage). In this section, implementation of two techniques amongst the above mentioned methods is done as under.
Mean substitution
Small Data Set as a sample is selected from huge Database for the treatment of Missing Values in Table 1; that can be used for the censuses of the population.
The missing value of Age field is represented with red background. In the above small Dataset of 11 Rows, Missing value is presented in 4 rows; which is 36% of the whole dataset. As the ratio of missing value is too high, so we have to handle the missing value presented in the said data set at pre-data mining phase for the correct pattern generation.
Now, we are going to implement the Mean Substitution technique to handle the Missing Value of Age Field.
Mean =20
So, we can replace the missing value of Age fields with 20. Table 2 shows the Dataset after treatment of Missing Values.
Closest fit
Now, we are going to elaborate the closest fit technique for the treatment of missing values. We will implement the closest fit technique in data set mentioned in Table 3, which is relating to do the analysis on data regarding property.
In the above Dataset, the tuple having missing value of Rent Field is represented with red background. In closest fit approach, we will replace the missing value with 12000 (from the case with Area of 850). So, the Dataset after applying the closest fit approach is showing in Table 4.
Conclusions and Future Enhancement
This paper gives the complete view about the effective imputation techniques for discovering the missing values from the dataset. K-NN algorithm is one of the well-known classifier for gathering up of data. It is likewise examined that when the absent value percentage is high then the strategy is the exactness diminishes. Mean Substitution and Closest Fit techniques to handle Missing Values on small dataset works effectively and efficiently. Whereas, K-NN algorithm is better to handle missing value on the large dataset.
It can be further improved via contrasting and some other procedures i.e., MLP and SOM. Mean Substitution can be interchanged with mode, average, standard deviation or by applying Expectation value– Expansion, regression based strategies.

Tables and Figures at a glance

Table icon Table icon Table icon Table icon
Table 1 Table 2 Table 3 Table 4
Select your language of interest to view the total content in your interested language
Post your comment

Share This Article

Relevant Topics

Recommended Conferences

Article Usage

  • Total views: 10530
  • [From(publication date):
    March-2016 - Jul 19, 2018]
  • Breakdown by view type
  • HTML page views : 10216
  • PDF downloads : 314

Review summary

  1. Anthony
    Posted on Sep 21 2016 at 4:26 pm
    This paper reviewed certain techniques and algorithms to deal with the puzzle of missing values whereby achieving pure data set which in-turn will lead to path of correct and accurate decision making. This paper gives the complete view about the effective imputation techniques for discovering the missing values from the dataset.

Post your comment

captcha   Reload  Can't read the image? click here to refresh

Peer Reviewed Journals
Make the best use of Scientific Research and information from our 700 + peer reviewed, Open Access Journals
International Conferences 2018-19
Meet Inspiring Speakers and Experts at our 3000+ Global Annual Meetings

Contact Us

Agri & Aquaculture Journals

Dr. Krish

[email protected]

+1-702-714-7001Extn: 9040

Biochemistry Journals

Datta A

[email protected]

1-702-714-7001Extn: 9037

Business & Management Journals


[email protected]

1-702-714-7001Extn: 9042

Chemistry Journals

Gabriel Shaw

[email protected]

1-702-714-7001Extn: 9040

Clinical Journals

Datta A

[email protected]

1-702-714-7001Extn: 9037

Engineering Journals

James Franklin

[email protected]

1-702-714-7001Extn: 9042

Food & Nutrition Journals

Katie Wilson

[email protected]

1-702-714-7001Extn: 9042

General Science

Andrea Jason

[email protected]

1-702-714-7001Extn: 9043

Genetics & Molecular Biology Journals

Anna Melissa

[email protected]

1-702-714-7001Extn: 9006

Immunology & Microbiology Journals

David Gorantl

[email protected]

1-702-714-7001Extn: 9014

Materials Science Journals

Rachle Green

[email protected]

1-702-714-7001Extn: 9039

Nursing & Health Care Journals

Stephanie Skinner

[email protected]

1-702-714-7001Extn: 9039

Medical Journals

Nimmi Anna

[email protected]

1-702-714-7001Extn: 9038

Neuroscience & Psychology Journals

Nathan T

[email protected]

1-702-714-7001Extn: 9041

Pharmaceutical Sciences Journals

Ann Jose

[email protected]

1-702-714-7001Extn: 9007

Social & Political Science Journals

Steve Harry

[email protected]

1-702-714-7001Extn: 9042

© 2008- 2018 OMICS International - Open Access Publisher. Best viewed in Mozilla Firefox | Google Chrome | Above IE 7.0 version