Retail price time series imputation Online publication date: Fri, 06-May-2016
by Obaid Ullah Malik; Robert J. Hilderman; Howard J. Hamilton; Richard Dosselmann
International Journal of Business Intelligence and Data Mining (IJBIDM), Vol. 11, No. 1, 2016
Abstract: A new method to fill in, or impute, missing prices in retail price time series datasets is proposed, called retail price time series imputation (RPTSI). It is constructed from an ensemble of three existing methods: namely, price change lookup, central moving average, and polynomial interpolation. Four extended variations of RPTSI are also proposed by considering historical prices for similar products sold by the same retailer and equivalent products sold by competing retailers. Crowdsourced datasets from four North American cities over a year and a half period were used in experiments to evaluate the five RPTSI-based methods and to compare the results against those obtained using last value carried forward, mean imputation, moving average, polynomial interpolation, and multiple imputation. Accuracy was measured by using mean absolute imputation error. Experimental results showed that the RPTSI-based methods had significantly higher accuracy than the other methods on both univariate and multivariate time series datasets.
Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Business Intelligence and Data Mining (IJBIDM):
Login with your Inderscience username and password:
Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.
If you still need assistance, please email subs@inderscience.com
Our Blog 
Follow us on Twitter 
Visit us on Facebook