I have a Distance matrix of cities, say 5.
I have also attached the data in the csv file.
I want to group (clusters) these cities based on criteria that cities are less than 5 km apart in the group.
The resultant cluster would be
Is there a R code or SAS code or even in Excel this can be done.
I have used usual clustering procedures but it doesn’t give me overlapping clusters i.e. where one city can come in multiple clusters, which I require.
Thanks for the help.citydistance.csv (84 Bytes)