I want to do a GroupBy over several rows and find a maximum value. This is fine. However corresponding to the maximum row, let us say Row65 I want to get the readout of a value in another column in Row65. How can I set this reference between the maximum in a column in a certain row and the corresponding value in another column in the same row? Or is GroupBy not appropriate ?
you could join the grouped table afterwards with the original table using the group values and min/max value of the column to get the value from the other column.