Calculating discharge over multiple years

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.

[Rik]

Edit restored from Google cache. This thread is now also added to the Wayback Machine.

@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?

[dpb]

@Rik I don't think there was any further comment...George never got back with sample data or additional questions so presume must have gotten his results from the hints given earlier.

Answer 1

[dpb]

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.

[dpb]

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.