Analyzing Rainfall data and sorting the data appropriately
8 views (last 30 days)
Show older comments
Priya Joshi
on 20 Oct 2021
Commented: Priya Joshi
on 18 Nov 2021
Hello,
I need to know how do I sort the rainfall data attached into monthly data and find out the dry days, maximum rainfall, all event sizes where rainfall is greater than 1mm and 10,50,90 percentile data. The rainfall data has a 6 min time step. Thanks
0 Comments
Accepted Answer
Cris LaPierre
on 20 Oct 2021
4 Comments
Cris LaPierre
on 25 Oct 2021
It just gets a little more complicated to read in because the date and number are in double quotes, so they are getting treated as a string, and read in as a single column.
Here's what I had to do in R2021b to get it into MATLAB
data = readtable('Rainfall 1994.xlsx','Range','A:A')
DR = split(data{:,1},',');
Date = datetime(DR(:,1),'InputFormat','M/dd/yyyy HH:mm');
Rainfall = str2double(DR(:,2));
RF = timetable(Date,Rainfall)
I also turned the data back into the original csv by removing the equation and the double quotes. It's a much simpler import process.
rf = readtimetable('Rainfall 1994.csv')
Once the data is imported, process the data however you like. MATLAB has some useful functions you may consider looking into, like retime, quantile, and groupsummary. For example, to turn your 6 minute data set into a daily data set, I might do the following
dailyRF = retime(rf,"daily","sum")
More Answers (1)
Priya Joshi
on 25 Oct 2021
4 Comments
Cris LaPierre
on 18 Nov 2021
Edited: Cris LaPierre
on 18 Nov 2021
Perhaps provide a simple example? It is not exactly clear to me what it is you want to do.
How did you create the graph?
See Also
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!