I have a table with three columns. In column 1 there is the ID, in column 2 there is a value that is used for comparison (identical for identical IDs) and in column 3 there is a value which is derived from an algorithm and which can differ by row.
Now, I want to aggregate all rows with the same ID so that I get the following format:
ID Value_Comparison Mean_Value
How is it possible to derive the mean value for column 3 for identical values in column 1? It is also possible to ignore column 2 and join it later, that would not matter.