Multi-variate infilling of missing daily discharge data on the Niger basin

Ganiyu Titilope Oyerinde; Agnide E. Lawin; Oluwafemi E. Adeyeri

doi:10.2166/wpt.2021.048

Multi-variate infilling of missing daily discharge data on the Niger basin

Ganiyu Titilope Oyerinde^*
, Agnide E. Lawin
, Oluwafemi E. Adeyeri

^*Corresponding author for this work

Research output: Journal Publications and Reviews › RGC 21 - Publication in refereed journal › peer-review

11 Citations (Scopus)

71 Downloads (CityUHK Scholars)

Abstract

The Niger basin has experienced historical drought episodes and floods in recent times. Reliable hydrological modelling has been hampered by missing values in daily river discharge data. We assessed the potential of using the Multivariate Imputation by Chained Equations (MICE) to estimate both continuous and discontinuous daily missing data across different spatial scales in the Niger basin. The study was conducted on 22 discharge stations that have missing data ranging from 2% to 70%. Four efficiency metrics were used to determine the effectiveness of MICE. The flow duration curves (FDC) of observed and filled data were compared to determine how MICE captured the discharge patterns. Mann-Kendall, Modified Mann-Kendall, Pettit and Sen’s Slope were used to assess the complete discharge trends using the gap-filled data. Results shows that MICE near perfectly filled the missing discharge data with Nash-Sutcliffe Efficiency (NSE) range of 0.94–0.99 for the calibration (1992–1994) period. Good fits were obtained between FDC of observed and gap-filled data in all considered stations. All the catchments showed significantly increasing discharge trend since 1990s after gap filling. Consequently, the use of MICE in handling missing data challenges across spatial scales in the Niger basin was proposed.

Original language	English
Pages (from-to)	961-979
Number of pages	19
Journal	Water Practice and Technology
Volume	16
Issue number	3
Online published	28 May 2021
DOIs	https://doi.org/10.2166/wpt.2021.048
Publication status	Published - 1 Jul 2021
Externally published	Yes

Bibliographical note

Publisher Copyright:
© 2021 The Authors.

Funding

The research of this article was supported by DAAD within the framework of the Federal Ministry of Education and Research. The authors and publisher are fully responsible for the content. We thank the Niger Basin Authority for providing the hydrological data.

Research Keywords

Hydrology
Multiple imputation
River discharge
Spatial scale
Trend analysis
West Africa

Publisher's Copyright Statement

This full text is made available under CC-BY 4.0. https://creativecommons.org/licenses/by/4.0/

Access Output

10.2166/wpt.2021.048

86894452.pdfFinal Published version, 1.55 MBLicence: CC BY

Other Access Options

Check CityUHK Library

Permanent Link

Right click to copy link

Cite this

@article{3ff3a01e9dec4a9da61c6fe37fb60b17,

title = "Multi-variate infilling of missing daily discharge data on the Niger basin",

abstract = "The Niger basin has experienced historical drought episodes and floods in recent times. Reliable hydrological modelling has been hampered by missing values in daily river discharge data. We assessed the potential of using the Multivariate Imputation by Chained Equations (MICE) to estimate both continuous and discontinuous daily missing data across different spatial scales in the Niger basin. The study was conducted on 22 discharge stations that have missing data ranging from 2\% to 70\%. Four efficiency metrics were used to determine the effectiveness of MICE. The flow duration curves (FDC) of observed and filled data were compared to determine how MICE captured the discharge patterns. Mann-Kendall, Modified Mann-Kendall, Pettit and Sen{\textquoteright}s Slope were used to assess the complete discharge trends using the gap-filled data. Results shows that MICE near perfectly filled the missing discharge data with Nash-Sutcliffe Efficiency (NSE) range of 0.94–0.99 for the calibration (1992–1994) period. Good fits were obtained between FDC of observed and gap-filled data in all considered stations. All the catchments showed significantly increasing discharge trend since 1990s after gap filling. Consequently, the use of MICE in handling missing data challenges across spatial scales in the Niger basin was proposed.",

keywords = "Hydrology, Multiple imputation, River discharge, Spatial scale, Trend analysis, West Africa",

author = "Oyerinde, \{Ganiyu Titilope\} and Lawin, \{Agnide E.\} and Adeyeri, \{Oluwafemi E.\}",

note = "Publisher Copyright: {\textcopyright} 2021 The Authors.",

year = "2021",

month = jul,

day = "1",

doi = "10.2166/wpt.2021.048",

language = "English",

volume = "16",

pages = "961--979",

journal = "Water Practice and Technology",

issn = "1751-231X",

publisher = "IWA Publishing",

number = "3",

}

TY - JOUR

T1 - Multi-variate infilling of missing daily discharge data on the Niger basin

AU - Oyerinde, Ganiyu Titilope

AU - Lawin, Agnide E.

AU - Adeyeri, Oluwafemi E.

PY - 2021/7/1

Y1 - 2021/7/1

N2 - The Niger basin has experienced historical drought episodes and floods in recent times. Reliable hydrological modelling has been hampered by missing values in daily river discharge data. We assessed the potential of using the Multivariate Imputation by Chained Equations (MICE) to estimate both continuous and discontinuous daily missing data across different spatial scales in the Niger basin. The study was conducted on 22 discharge stations that have missing data ranging from 2% to 70%. Four efficiency metrics were used to determine the effectiveness of MICE. The flow duration curves (FDC) of observed and filled data were compared to determine how MICE captured the discharge patterns. Mann-Kendall, Modified Mann-Kendall, Pettit and Sen’s Slope were used to assess the complete discharge trends using the gap-filled data. Results shows that MICE near perfectly filled the missing discharge data with Nash-Sutcliffe Efficiency (NSE) range of 0.94–0.99 for the calibration (1992–1994) period. Good fits were obtained between FDC of observed and gap-filled data in all considered stations. All the catchments showed significantly increasing discharge trend since 1990s after gap filling. Consequently, the use of MICE in handling missing data challenges across spatial scales in the Niger basin was proposed.

AB - The Niger basin has experienced historical drought episodes and floods in recent times. Reliable hydrological modelling has been hampered by missing values in daily river discharge data. We assessed the potential of using the Multivariate Imputation by Chained Equations (MICE) to estimate both continuous and discontinuous daily missing data across different spatial scales in the Niger basin. The study was conducted on 22 discharge stations that have missing data ranging from 2% to 70%. Four efficiency metrics were used to determine the effectiveness of MICE. The flow duration curves (FDC) of observed and filled data were compared to determine how MICE captured the discharge patterns. Mann-Kendall, Modified Mann-Kendall, Pettit and Sen’s Slope were used to assess the complete discharge trends using the gap-filled data. Results shows that MICE near perfectly filled the missing discharge data with Nash-Sutcliffe Efficiency (NSE) range of 0.94–0.99 for the calibration (1992–1994) period. Good fits were obtained between FDC of observed and gap-filled data in all considered stations. All the catchments showed significantly increasing discharge trend since 1990s after gap filling. Consequently, the use of MICE in handling missing data challenges across spatial scales in the Niger basin was proposed.

KW - Hydrology

KW - Multiple imputation

KW - River discharge

KW - Spatial scale

KW - Trend analysis

KW - West Africa

UR - https://www.scopus.com/pages/publications/85119720165

UR - https://www.scopus.com/record/pubmetrics.uri?eid=2-s2.0-85119720165&origin=recordpage

U2 - 10.2166/wpt.2021.048

DO - 10.2166/wpt.2021.048

M3 - RGC 21 - Publication in refereed journal

AN - SCOPUS:85119720165

SN - 1751-231X

VL - 16

SP - 961

EP - 979

JO - Water Practice and Technology

JF - Water Practice and Technology

IS - 3

ER -

Multi-variate infilling of missing daily discharge data on the Niger basin

Abstract

Bibliographical note

Funding

Research Keywords

Publisher's Copyright Statement

Access Output

Other Access Options

Permanent Link

Other Files and Links

Fingerprint

Cite this