I have singleparts (pipes) with name and depth. I need to count the average depth based on name. So for e.g. pipe 'cont500str1' has average depth
(2,93+2,03+1,99+1,17+2,12)/5 = 2,048.
The complication is that some singleparts have the same name. So e.g. the first pipe 'plastic200' has average depth
'(2,76+1,58)/2 = 2,17', second pipe 'plastic200' has average depth
'(1,16+1,35+2,00+1,07+1,20)/5 = 1,356'.
How can I solve this problem?