
Hi R Help list

I'm looking to visualise US foreign aid 1946-2009 and I have the dataset for this. The trouble is it's a bit too complex and I need to simply it 

I want to merge all of the rows with the same country together and add up the individual totals to make one total figure per country per year

Below is an example of the kind of data. The real dataset has 2447 rows and covers 63 years. There are many missing values. Basically I would 
like to go from the top example to the bottom example and be able to scale it up to cover many more countries and years.

Thanks in advance for any help you can offer.

country          programme                                               FY1985         FY1986
Afghanistan    Child Survival and Health                            10,000,000  15,000,000
Afghanistan    Department of Defense Security Assistance  15,000,000   15,000,000
Afghanistan    Narcotics Control                                         NA               5,000,000                   
Afghanistan    Peace Corps                                                NA              7,500,000
Albania          Child Survival and Health                              NA                   25,000
Albania          Department of Defense Security Assistance     NA                   NA
Albania          Narcotics Control                                         NA                    5,000
Albania          Peace Corps                                                NA                    NA


	
	
		
			

		
		
			

		
	


country          programme                                                                                                                               FY1985         FY1986
Afghanistan    Child Survival and Health,Department of Defense Security Assistance,Narcotics Control,Peace Corps    25,000,000   42,500,000
Albania          Child Survival and Health,Department of Defense Security Assistance,Narcotics Control,Peace Corps       NA                  30,000

 		 	   		  
	[[alternative HTML version deleted]]

