Message-ID: <1406809933918-7586839.post@n2.nabble.com>
Date: 2014-07-31T12:32:13Z
From: HallS
Subject: Merging shapefiles and csv
Hi all,
I'm struggling to know how this will come across as my data is confidential.
Basically I have a shapefile (.shp) and a csv file while contain the same
regions (i.e.) a column which has the same information. Using this link:
https://sites.google.com/site/eospansite/alobotips/spatial_r_tips/rshp_xls
I managed to get quite far but once I got to the writeOGR command, I get the
error
Error in writeOGR(RSANHS, dsn = "C:/Users/Laptop/Documents/Rworkspace/", :
number of objects mismatch
shape1 at data <- merge(shape1 at data,csv,by.x="RSA",
+ by.y="RSA", all.x=T, sort=F)
>
> ###Checking it
> dim(shape at data)
[1] 1745 2
> dim(shape1 at data)
[1] 1747 5
This shows a discrepancy in two rows between the original shapefile and the
new merged one. When I looked at the merged file in full, there were a
number of NA rows at the bottom where there was no corresponding data to the
shapefile. I tried shape1 at data <- na.exclude(shape1 at data) and with na.omit,
and this did reduce the number of rows to 1690, but the problem persists.
Sorry if this is a really unhelpful question, I'm not sure how to do it when
data is confidential.
--
View this message in context: http://r-sig-geo.2731867.n2.nabble.com/Merging-shapefiles-and-csv-tp7586839.html
Sent from the R-sig-geo mailing list archive at Nabble.com.