[R-sig-Geo] Export matrix weights to excel.

Rolando Valdez rvaldezr at gmail.com
Sat May 3 23:05:25 CEST 2014


Hello,

I'm working with a matrix weights, I want to know if I can export the output, to handle with excel.

This is a part what I have:

> zm <- readOGR(".", "zmdis”)
OGR data source with driver: ESRI Shapefile 
Source: ".", layer: "zmdis"
with 56 features and 8 fields
Feature type: wkbPolygon with 2 dimensions
> mapaxy = coordinates(zm)
> wdist100 = dnearneigh(mapaxy, d1=0, d2=100000)
> l100 = nb2listw(wdist100, style="W", zero.policy=T)
> summary(l100, zero.policy=T)
Characteristics of weights list object:
Neighbour list object:
Number of regions: 56 
Number of nonzero links: 86 
Percentage nonzero weights: 2.742347 
Average number of links: 1.535714 
21 regions with no links:
3 6 11 13 14 15 16 24 25 27 28 35 36 38 41 47 48 51 52 53 54
Link number distribution:

 0  1  2  3  4  5  8 
21 12 11  2  7  2  1 
12 least connected regions:
1 5 7 17 19 20 21 30 33 34 45 55 with 1 link
1 most connected region:
37 with 8 links

Weights style: W 
Weights constants summary:
   n   nn S0       S1    S2
W 35 1225 35 39.26667 147.3

I want to get a matrix [56 x 56] to work in excel with it.

Thank you in advance.

Rolando Valdez



More information about the R-sig-Geo mailing list