Download from this website the NUTS_RG_60M_2006 files (shapefile) and the csv-file T_DischargePoints_West.csv (source) and save them on your computer. Open them through ArcGis and plot xy-points. You get this result:
The cvs-file contains a number of variables. There is one categorical variable (dcpWaterBodyType). I now would like to know how many points from each category of dcpWaterBodyType there are in each nuts3-polygon. If possible, I also would like to determine automatically what the percentage of points of WaterBodyTypeA, WaterBodyTypeB, WaterBodyTypeC... is in one polygon and this for all the polygons.
Can somebody explain me how to do this in ArcGis or R?