A COMPARATIVE STUDY TO ADDRESS MISSING DATA FROM HISTORICAL RAINFALL DATA IN KELANTAN AND PAHANG, MALAYSIA
DOI:
https://doi.org/10.11113/aej.v16.25374Keywords:
Climate change, Missing data, rainfall data, arithmetic mean average, inverse distance weighingAbstract
Climate change poses a critical threat to Malaysia, particularly in the context of increasing flood risks. The country is experiencing more frequent and intense rainfall events, leading to heightened incidences of flooding. These climatic shifts can be attributed to global warming and changing weather patterns. Malaysia's vulnerability to climate-induced floods necessitates urgent and comprehensive adaptation strategies. However, if there are any lacking or missing data to be analyze, hence the next step could be jive. Addressing missing data considers to be the most important part to do before proceeding to further hydrological procedure such as statistical comparison or Intensity-Duration-Frequency (IDF). Arithmetic Mean Average and Inverse Distance Weighing method would be use in this study to address missing data. The site location for this study were in Kelantan and Pahang. The stations involved in addressing the missing data are Station Pertanian Lundang, Stor JPS Kota Bharu and Mardi Kubang Keranji in Kelantan while Station Sungai Lembing, Bukit Goh and Sungai Panching Selatan in Pahang were selected. The range of data for all the stations were from 2013 to 2023 depends on which station have missing data throughout the years. The results shown that the percentage difference or compatibility between the two methods varies from 0 up to 50 percent difference. This study considers to be significance as this method would be the first step to do before proceeding to another hydrological method. Authorities such as Department of Irrigation and Drainage (DID) would be beneficiary to this study as they will use the missing rainfall data for further hydrological steps.
References
M. Filonchyk, M. P. Peterson, L. Zhang, V. Hurynovich, and Y. He, 2024, “Greenhouse gases emissions and global climate change: Examining the influence of CO2, CH4, and N2O,” Science of The Total Environment, 935: 173359, DOI: 10.1016/J.SCITOTENV.2024.173359.
[2] H. A. Rahman, 2018. “CLIMATE CHANGE SCENARIOS IN MALAYSIA: ENGAGING THE PUBLIC,” International Journal of Malay-Nusantara Studies, 1(2): 65-78,
[3] A. H. A. Tarmizi, S. N. Rahmat, A. T. A. Karim, and N. N. A. Tukimat, 2019, “Climate change and its impact on rainfall,” International Journal of Integrated Engineering, 11(1): 170–177, DOI: 10.30880/ijie.2019.11.01.020.
[4] M. Y. Safiah Yusmah et al., 2020, “Understanding urban flood vulnerability and resilience: a case study of Kuantan, Pahang, Malaysia,” Natural Hazards, 101(2): 551–571, DOI: 10.1007/s11069-020-03885-1.
[5] N. D. Mohd Idris and N. Abd Majid, 2024, “An Analysis of Malaysia’s Flood Vulnerability Study Using the Geographical Information System Technique,” International Journal of Academic Research in Business and Social Sciences, 14(7): 288-302, DOI: 10.6007/ijarbss/v14-i7/21831.
[6] B. C. C. Xian, C. W. Kang, M. A. Wahab, M. R. R. M. A. Zainol, and F. Baharudin, 2021. “Evaluation of low impact development and best management practices on peak flow reduction using SWMM,” in IOP Conference Series: Earth and Environmental Science, IOP Publishing Ltd,. DOI: 10.1088/1755-1315/646/1/012045.
[7] Z. Sa’adi et al., 2024, “Spatiotemporal assessment of rainfall and drought projection for integrated dam management in Benut River Basin, Malaysia under CMIP6 scenarios,” Environmental Challenges, 15: 100892. DOI: 10.1016/J.ENVC.2024.100892.
[8] W. Norliyana Wan Ismail, W. Zawiah Wan Zin, and W. Ibrahim, 2017. “Estimation of rainfall and stream flow missing data for Terengganu, Malaysia by using interpolation technique methods,”, Penerbit UTM Press,
[9] H. P. G. M. Caldera, V. R. P. C. Piyathisse, and K. D. W. Nandalal, 2016. “A Comparison of Methods of Estimating Missing Daily Rainfall Data,” Engineer: Journal of the Institution of Engineers, Sri Lanka, 49(4), 1–8. The Institution of Engineers, Sri Lanka,
[10] S. Wuthiwongyothin, 2021. C. Kalkan, and J. Panyavaraporn, “Evaluating Inverse Distance Weighting and Correlation Coefficient Weighting Infilling Methods on Daily Rainfall Time Series.” SNRU Journal of Science and Technology, 13(2): 71–79. Sakon Nakhon Rajabhat University,
[11] M. Az-Zuhri Azman, R. Zakaria, N. Fadhilah, and A. Radi, “Estimation of Missing Rainfall Data in Pahang Using Modified Spatial Interpolation Weighting Methods.” AIP Conference Proceedings 1643(1):65-72
[12] M. L. Tan and X. Yang, 2020. “Effect of rainfall station density, distribution and missing values on SWAT outputs in tropical region,” Journal of Hydrology, 584: 124660, Amsterdam, DOI: 10.1016/J.JHYDROL.2020.124660.
[13] R. Berndtsson, 2016. “Chow’s Handbook of Applied Hydrology,” McGraw Hill Education, 2nd Edition,
[14] K. N. Dirks, J. E. Hay, C. D. Stow, and D. Harris, 1998, “High-resolution studies of rainfall on Norfolk Island: Part II: Interpolation of rainfall data,” Journal of Hydrology. 208(3–4): 187–193, Jul. Amsterdam, DOI: 10.1016/S0022-1694(98)00155-3.
[15] G. E. A. P. A. Batista and M. C. Monard, 2003, “An analysis of four missing data treatment methods for supervised learning,” Applied Artificial Intelligence, 17(5–6): 519–533, DOI: 10.1080/713827181.
[16] A. Aieb, K. Madani, M. Scarpa, B. Bonacorso, and K. Lefsih, 2019, “A new approach for processing climate missing databases applied to daily rainfall data in Soummam watershed, Algeria,” Heliyon, 5(2): e01247, DOI: 10.1016/J.HELIYON.2019.E01247.
[17] S. Epps et al., 2008 “School Psychology Book Series Working With Parents of Noncompliant Children: A Guide to Evidence-Based Parent Training for Practitioners and Students.”, American Psychological Association (APA).
[18] A. S. Suchithra and S. Agarwal, 2020. IDF Curve Generation for Historical Rainfall Events Proceeding of National Conference on Emerging Trends in Civil Engineering IDF Curve Generation for Historical Rainfall Events. Retrieved October 2025.
[19] R. S. V. Teegavarapu and V. Chandramouli, 2005, “Improved weighting methods, deterministic and stochastic data-driven models for estimation of missing precipitation records,” Journal of Hydrology. 312(1–4): 191–206. Amsterdam, DOI: 10.1016/J.JHYDROL.2005.02.015.
[20] I. A. Nalder and R. W. Wein, 1998, “Spatial interpolation of climatic Normals: test of a new method in the Canadian boreal forest,” Agricultural and Forest Meteorology, 92(4): 211–225, DOI: 10.1016/S0168-1923(98)00102-6.
[21] G. Y. Lu and D. W. Wong, 2008, “An adaptive inverse-distance weighting spatial interpolation technique,” Computers & Geosciences. 34(9): 1044–1055. DOI: 10.1016/J.CAGEO.2007.07.010.
[22] S. S. P. Shen, P. Dzikowski, G. Li, and D. Griffith, 2001, “Interpolation of 1961-97 Daily Temperature and Precipitation Data onto Alberta Polygons of Ecodistrict and Soil Landscapes of Canada.” Retrieved October 2025.
