For my Master thesis, I want to address the question, whether rainfall anomalies can increase the risk of conflicts in Sub-Saharan Africa. As a moderator I have picked climate-related aid programs. The Aid data is a .csv file and comes from http://aiddata.org. The conflict data is a .csv file also and comes from the Social Conflict Analysis Database (https://www.strausscenter.org/scad.html). My precipitation data is from the University of East Anglia (http://wps-web1.ceda.ac.uk/submit/form?proc_id=Subsetter), gridded 0.5° x 0.5° and is a .nc data. I could also download it as a .csv dataset. After loading the data to QGIS it looks like this
I would like to combine the data in one dataset and the grid cells as unity of analysis. So I could analyze it with STATA or R. In the journal articles I have read so far, that they always work with grid cells, otherwise they could not combine the point data from conflict datasets to rainfall data. I guess I could use the 0.5° x 0.5° raster of the precipitation data or should I use artificial grid cells. Basically, my question is, how can I combine the data to do regression analysis? I did the QGIS-Tutorial, but did not find any answers to my question. Please help a political science student :). I am happy for any help. Unfortunately, we do not have a geographical faculty at my university.