Calculating discharge over multiple years
1 view (last 30 days)
Show older comments
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 Comments
Rik
on 20 Jan 2021
Edited: Rik
on 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?
Accepted Answer
dpb
on 16 Jan 2021
Edited: dpb
on 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 Comment
dpb
on 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.
More Answers (0)
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!