I am trying to merge a table with a shape file using **R**. The shapefile's database is bigger than the table and I need to have null or zero values where the two data sets don't match.
Table data
no. table_id value 1. a11 123 2. a12 456 3. a14 789Shapefile's data db
no. polygon_id 1. a11 2. a12 3. a13 4. a14 5. a15Desired result (on the shapefile):
no. id value 1. a11 123 2. a12 456 3. a13 0 4. a14 789 5. a15 0What I tried
I tried marge but it didn't work I think because the two tables have different sizes.
#trying to mergejoined
Table data
no. table_id value 1. a11 123 2. a12 456 3. a14 789Shapefile's data db
no. polygon_id 1. a11 2. a12 3. a13 4. a14 5. a15Desired result (on the shapefile):
no. id value 1. a11 123 2. a12 456 3. a13 0 4. a14 789 5. a15 0What I tried
I tried marge but it didn't work I think because the two tables have different sizes.
#trying to mergejoined