How to prepare rainfall data for modeling?

Rainfall Units

Date Time formats

  • Jan 1 2020, 11:20am
  • 2020, 1, 1, 11, 20
  • 11/20/2020, 11:20
  • 11/20/2020 11:20
  • etc
  • combine date time from multiple columns into one column
  • separate date time from one column to multiple columns
  1. we need to build a time index with fixed interval. Start the first two rows, then drag it. Be careful, sometimes Excel might get the calculation wrong, make sure you review the intervals using the method above and fix any errors.

An XPSWMM Example

  • 4 in/hr for the 1st hour (1in/15min=4in/hr)
  • 8in/hr for the 2nd hour.




Empowering Water Experts

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

5 websites to enhance your frontend skills in 2022

Good practices in Angular

Devops task using docker,jenkins,github.

Corporate Engineer by Day, Bloc Student by Night

Why should you join the open-source community?

Monday morning coffee before doing the code reviews

Set in Swift: The Overlooked one !

View Your Logs In Colour

How I solved the Arabic to Roman Numeral Conversion Question

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Mel Meng

Mel Meng

Empowering Water Experts

More from Medium

CFD / Computational Fluid Dynamics Analysis

CFD / Computational Fluid Dynamics Analysis

Soybean Crop Yield Prediction with ML Regression Techniques— Part 1: Tabular data

Exploratory Analysis for TimeSeries Forecasting on Crypto-Assets by G-Research

Generalization Of Machine Learning