Need help in calculating average value on this format ....
The above is part of my .txt file, is there any method to calculate the average value for each ID ?
The first part is ID, second is value.
(Note: There are repeated same ID, so how to get those value and calculate average ?
Maybe the result will be :
00:24:c3:31:2b:e0 average : -88
00:12:17:7b:33:04 average : -90