Analyzing Rainfall data and sorting the data appropriately
5 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Priya Joshi
el 20 de Oct. de 2021
Comentada: Priya Joshi
el 18 de Nov. de 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 comentarios
Respuesta aceptada
Cris LaPierre
el 20 de Oct. de 2021
4 comentarios
Cris LaPierre
el 25 de Oct. de 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")
Más respuestas (1)
Priya Joshi
el 25 de Oct. de 2021
4 comentarios
Cris LaPierre
el 18 de Nov. de 2021
Editada: Cris LaPierre
el 18 de Nov. de 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?
Ver también
Categorías
Más información sobre Tables en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!