I have a dataset with property ID, longitude, latitude, listing date and closing date (sale of property). I would like to assign a cluster/neighbor ID to the houses within 5miles from each other that have been listed on the market within 3 months from each other. I would appreciate if you suggest a code with and without the listing date being within 30-days requirement.
An example of pseudo-data
list id longitude latitude listing_date closing_date in 1/10
+--------------------------------------------------+
| id longitude latitude listin~e closin~e |
|--------------------------------------------------|
1. | 1 -67.24793 105.056 22839 23143 |
2. | 2 20.15248 81.45157 22800 22947 |
3. | 3 157.7826 121.4579 22716 22946 |
4. | 4 85.07596 189.9353 22881 23130 |
5. | 5 -110.7333 167.5668 22862 23151 |
|--------------------------------------------------|
6. | 6 -109.7496 245.5592 22725 22988 |
7. | 7 162.3455 -101.3925 22860 23069 |
8. | 8 -75.43965 -82.76 22714 22893 |
9. | 9 114.8696 -254.7969 22975 23051 |
10. | 10 -4.244534 76.7684 22976 23065 |
+--------------------------------------------------+
0 Response to Tagging neighborhood houses within timeframe
Post a Comment