I have two excel data files, both are pretty much identical but is slightly different in the data that it contains are different. Both files have Country and Year, while one measures Co2 emissions and the other Gdp per cap data for the respective year and country.
Using R markdown, how could I go about combining these data sets, and then creating a scatter plot that shows co2 emissions against Gdp Per cap for every country for a certain year?
Any help would be greatly appreciated, I've been at it for ages and I am Stumped as to how to get it to work!