444,018 Members | 1,204 Online
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,018 IT Pros & Developers. It's quick & easy.

# Ideas for Grouping numeric data based on the distance from each other?

 P: n/a Hi Everyone, Just after some ideas and suggestions on how to do this. I have a large amount of numeric data which I would like to group given a distance as a parameter. IE. If my dataset was simply 1, 5, 9,10,11,16,17,25,29 and I pass in a distance of 2 then I would want to end up with groups like 1, 5, (9,10,11), (16,17) ,25,29 So [9,10,11] is grouped because each number is within a distance of 2 from each other. Equally [16,17] is grouped because of the same. To make this more complicated each numeric would actually be a x, y plot. So the actual data would be more like [10,12], [20,21] , [21,23], [30,31] etc. Each one having 2 sets of numbers. In this case the grouping would be [10,12], ([20,21][21,23]), [30,31]. So [20,21] and [21,23] are grouped because x in both sets are within 2 and y in both sets are within 2. any body have any good ideas to start me off Thanks very much in advance SoS Oct 26 '07 #1