I am using the global terrorism data set from Kaggle, and I'm trying to plot on a world map (or just Europe and neighboring countries). I need to plot the terror attacks as points: size - number killed. I also need to color the countries according to the number of immigrants in them - that I would require an input from a different data set. So far what I have got is:
df <- read.csv("C:.../globalterrorismdb_0617dist.csv", stringsAsFactors = FALSE)
locs <- data.frame(lon = df$longitude, lat = df$latitude, stringsAsFactors = FALSE)
nMap <- get_map("Vienna, Austria", zoom = 4, maptype = "toner", source = "stamen")
ggmap(nMap) +
geom_point(aes(x = locs$lon, y = locs$lat ,color = df$nkill), data = df) +
geom_point(size = 6, alpha = 0.3)
The important part of the attacks data looks like:
> Country, latitude, longitude
> United Kingdom 54.59727 -5.930109
> Spain 43.18418 -2.473289
> Turkey 37.95032 27.373266
> Italy 41.89052 12.494249
> United Kingdom 54.22641 -7.649053
Now I would like as mentioned to color countries according to the number of refugees and/or immigrants. For that purpose, lets assume I have a data set which contains that in the form of (fake numbers):
> country, #
> United Kingdom 123
> Spain 100
> Turkey 250
> Italy 80
Please help.

