Handling Missing Values in A Dataset
Main Article Content
Abstract
In predictive data mining, all issues pertaining to missing values in a dataset must be resolved before modeling can commence. Careful analysis and planning is required in the process of filling missing values to avoid introduction of artificial patterns, which may erroneously be discovered during modeling. In this work, four techniques: “Replacement with meanâ€, “Replacement with nearest neighborâ€, “Replacement with regression analysis†and “Discard columns with missing values†were used to fill missing values in “offences against persons†1980 - 2008 dataset obtained from the Nigeria Police Force. The dataset was divided into two; test set 1980 - 2003 (containing the filled in values) and holdout sample for validation 2004 – 2008. The test data was used to predict the holdout sample data – the objective being to determine which technique predicted the best match to actual data. The “Discard columns with missing values†technique achieved a correlation coefficient of -0.45 in one run. This work has demonstrated that missing values in a dataset can be handled and need not abort the data mining process.
Keywords: data mining; missing values; data preparation; replacement; correlation
Downloads
Article Details
COPYRIGHT
Submission of a manuscript implies: that the work described has not been published before, that it is not under consideration for publication elsewhere; that if and when the manuscript is accepted for publication, the authors agree to automatic transfer of the copyright to the publisher.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work
- The journal allows the author(s) to retain publishing rights without restrictions.
- The journal allows the author(s) to hold the copyright without restrictions.