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.