2020Sains MalaysianaOpen access

Imputation Techniques for Incomplete Load Data Based on Seasonality and Orientation of the Missing Values

Nur Arina Bazilah Kamisan, Muhammad Hisyam Lee, Abdul Ghapor Hussin, Yong Zulina Zubairi

Open full text 5 citations

Abstract

In load data, the missing problem always occurs in a set of data.Since it has a seasonal pattern according to days, most of the time, the load usage for the next day is predictable.For this reason, a new model has been developed based on these characteristics.Data containing missing values being divided to its seasonality pattern and for each subdivision, the values from mean, the mean with standard deviation and third quartile are calculated before being rearrange to form a new set of values that will replace the missing values.These three values will be used as imputations for the missing values.To examine the effects of the orientation of the missing values with the choices of imputation, the missing values from the data are divided into three parts: at the front, in the middle and at the end of the data with 5%, 15%, and 25% of missing values.The results from root mean square error and mean absolute error show that the proposed techniques, particularly the mean and the third quartile value, are superior to the other complex methods when dealing with the missing values.The mean imputation is ample when the missing values is presence at the front and in the middle of the data while the third quartile value is superior when the missing values is at the end of the data.

Open-access reader

About this research paper

What this paper is about

In load data, the missing problem always occurs in a set of data.Since it has a seasonal pattern according to days, most of the time, the load usage for the next day is predictable.For this reason, a new model has been developed based on these characteristics.Data containing missing values being divided to its seasonality pattern and for each subdivision, the values from mean, the mean with standard deviation and third quartile are calculated before being rearrange to form a new set of values that will replace the missing values.These three values will be used as imputations for the missing values.To examine the effects of the orientation of the missing values with the choices of imputation, the missing values from the data are divided into three parts: at the front, in the middle and at the end of the data with 5%, 15%, and 25% of missing values.The results from root mean square error and mean absolute error show that the proposed techniques, particularly the mean and the third quartile value, are superior to the other complex methods when dealing with the missing values.The mean imputation is ample when the missing values is presence at the front and in the middle of the data while the third quartile value is superior when the missing values is at the end of the data.

Why it matters

OpenAlex reports 5 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

In load data, the missing problem always occurs in a set of data.Since it has a seasonal pattern according to days, most of the time, the load usage for the next day is predictable.For this reason, a new model has been developed based on these characteristics.Data containing missing values being divided to its seasonality pattern and for each subdivision, the values from mean, the mean with standard deviation and third quartile are calculated before being rearrange to form a new set of values that will replace the missing values.These three values will be used as imputations for the missing values.To examine the effects of the orientation of the missing values with the choices of imputation, the missing values from the data are divided into three parts: at the front, in the middle and at the end of the data with 5%, 15%, and 25% of missing values.The results from root mean square error and mean absolute error show that the proposed techniques, particularly the mean and the third quartile value, are superior to the other complex methods when dealing with the missing values.The mean imputation is ample when the missing values is presence at the front and in the middle of the data while the third quartile value is superior when the missing values is at the end of the data.

Key concepts: Missing data, Imputation (statistics), Seasonality, Statistics, Econometrics, Mathematics

Related papers

Back to paper searchBrowse research topicsOriginal source
Imputation Techniques for Incomplete Load Data Based on Seasonality and Orientation of the Missing Values — Research Paper | ScholarLens