Calculating discharge over multiple years
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Need a function that finds the monthly maximum discharge. It should output two values, the discharge itself and the row in which each value occurs. The code should extract results for all months in all years.
I have a data set that has discharge in first column, day, month then year in 2,3 and 4 columns.
2 Kommentare
Rik
am 20 Jan. 2021
Bearbeitet: Rik
am 20 Jan. 2021
@George Sands Please don't edit away parts of your question after receiving an answer. That is very rude. It also looks like you deleted a comment, but unfortunately I can't restore that.
@dpb Could you flag this thread if there is more deleted content I could not restore?
Akzeptierte Antwort
dpb
am 16 Jan. 2021
Bearbeitet: dpb
am 16 Jan. 2021
Use a table or timetable and rowfun with grouping variables...a couple lines of code and an anonymous function will do it.
For the second desired output you may find augmenting the table with the row number may be the expeditious solution.
1 Kommentar
dpb
am 17 Jan. 2021
Look at doc/examples for timetable, rowfun for starters. Give it a shot and show us what you have done and where get stuck. Look at section in importing data, too...
Attach a smallish sample datafile would help folks write specific code; you have a very generic description.
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Tables finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!