I have a data about municipalities in France. And I want to create a spatial weight matrix using this data. But the problem is this is not a .shp
file data. It is .csv
Below is the link to the data file. This file has more than 35000 municipalities. For simplicity, I will just assume that there are only 10 municipalities. So the data will be of the form:-
data <- data.frame(insee=c("01001", "01002", "01004", "01005", "01006"),
insee_voisins=c("01002|01004|01005", "01001|01005", "01001|01006",
"01001|01002|01006", "01004|01006"))
Assuming that the above data creates a proper spatial pattern, how make its spatial weights matrix which will be of the following form:-
[, 1] [, 2] [, 3] [, 4] [, 5]
[1, ] 0 1 1 1 0
[2, ] 1 0 0 1 0
[3, ] 1 0 0 0 1
[4, ] 1 1 0 0 1
[5, ] 0 0 1 1 0
Please keep in mind that the actual data has more than 35000 municipalities. So if you have a memory and speed efficient solution, it would be better.
Thanks in advance.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…