A study of cubic splines and Fourier series as interpolation techniques for filling in missing hourly data in energy and meteorological time series data sets is presented. The procedure developed in this paper is based on the local patterns of the data around the gaps. Artificial gaps, or “pseudogaps,” created by deleting consecutive data points from the measured data sets, were filled using four variants of the cubic spline technique and 12 variants of the Fourier series technique. The accuracy of these techniques was compared to the accuracy of results obtained using linear interpolation to fill the same pseudogaps. The pseudogaps filled were 1–6 data points in length created in 18 year-long sets of hourly energy use and weather data. More than 1000 pseudogaps of each gap length were created in each of the 18 data sets and filled using each of the 17 techniques evaluated. Use of mean bias error as the selection criterion found that linear interpolation is superior to the cubic spline and Fourier series methodologies for filling gaps of dry bulb and dew point temperature time series data. For hourly building cooling and heating use data, the Fourier series approach with 24 data points before and after each gap and six terms was found to be the most suitable; where there are insufficient data points to apply this approach, simple linear interpolation is recommended.
Skip Nav Destination
e-mail: dclaridge@tamu.edu
Article navigation
Research Papers
Study of Cubic Splines and Fourier Series as Interpolation Techniques for Filling in Short Periods of Missing Building Energy Use and Weather Data
Juan-Carlos Baltazar,
Juan-Carlos Baltazar
Energy Systems Laboratory,
Texas A&M University
, College Station, TX 77843-3581
Search for other works by this author on:
David E. Claridge
David E. Claridge
Energy Systems Laboratory,
e-mail: dclaridge@tamu.edu
Texas A&M University
, College Station, TX 77843-3581
Search for other works by this author on:
Juan-Carlos Baltazar
Energy Systems Laboratory,
Texas A&M University
, College Station, TX 77843-3581
David E. Claridge
Energy Systems Laboratory,
Texas A&M University
, College Station, TX 77843-3581e-mail: dclaridge@tamu.edu
J. Sol. Energy Eng. May 2006, 128(2): 226-230 (5 pages)
Published Online: November 16, 2005
Article history
Received:
July 15, 2005
Revised:
November 16, 2005
Citation
Baltazar, J., and Claridge, D. E. (November 16, 2005). "Study of Cubic Splines and Fourier Series as Interpolation Techniques for Filling in Short Periods of Missing Building Energy Use and Weather Data." ASME. J. Sol. Energy Eng. May 2006; 128(2): 226–230. https://doi.org/10.1115/1.2189872
Download citation file:
Get Email Alerts
Analysis of Erosion of Surfaces in Falling Particle Concentrating Solar Power
J. Sol. Energy Eng (April 2025)
Related Articles
A Singular Value Decomposition Approach to Similarity Evaluation Between Servo Loops of CNC Machine Tools
J. Manuf. Sci. Eng (December,2008)
Interpolating Three-Dimensional Kinematic Data Using Quaternion Splines and Hermite Curves
J Biomech Eng (April,2005)
A Fast and Efficient Method for Predicting Fluid Flow and Heat Transfer Problems
J. Heat Transfer (March,2008)
Parametric Identification of Nonlinear Systems Using Chaotic Excitation
J. Comput. Nonlinear Dynam (July,2007)
Related Proceedings Papers
Related Chapters
Vector Synthesis Interpolation for Cone Spline
International Conference on Mechanical and Electrical Technology 2009 (ICMET 2009)
Weekday-Weekend Ozone Concentrations in the Northeast United States
Air Quality Meteorology and Atmospheric Ozone
Differences in Income Stratification Estimates Based on Administrative and Survey Data: Evidence from Slovakia
International Conference on Electronics, Information and Communication Engineering (EICE 2012)