I have an empty raster shapefile that only contains the latitude and the longitude of the centroids of each grid.
I now want to add an extra variable to each grid cell coming from a cvs or txt file. In this text file, latitude and longitude of the centroid of each grid is also included. Even though the information is given per centroid, the information relates to the entire grid cell (so each grid cell should be colored for 100% with one color / value).
Afterwards, I save the joined result again in a shapefile.
My data (MyData.cvs) and grid shapefile (grid_025dd.shp) can be found through the following link: https://drive.google.com/folderview?id=0By9u5m3kxn9yfjZtdFZLcW82SWpzT1VwZXE1a3FtRGtSdEl1c1NvY205TGpack9xSFc2T2s&usp=sharing
I would like to use R to do this merge because I need the shapefile, with the information of the variable, afterwards to continue my analysis in R. However, I do have ArcGis on my computer in case that R can't do the job. In that case, ArcGis could maybe make one shapefile with all the information so that I can use that in R.
I think the main reason why I don't manage solving this (basic?) issue is that I don't know how to handle the two column coordinates (one for longitude and one for latitude). Previously, I have always worked with one common ID in both the text file and the shapefile. Now I have two columns that form together the ID to merge both data.
Could someone help me with this? I have some experience with R but I am a beginner in ArcGis (yet, willing to learn!).