Dear R community,
 
I would like to merge two datasets based on the categorical predictor 
“country”. 
 
Dataset A:
 
Country           Measure1
Afganistan        1
Afganistan        1
Russia              5
Poland 3
Poland              2
 
Dataset B:
 
Country           Measure 2
Russia              2
Afganistan        10
Poland              15
 
My program does not work:
 
Country_A<-A$Country
Country_B<-B$Country
Measure2<-B$Measure2
 
for(i in 1:nrow(B)){
for(j in 1:nrow(A){
w[j]<-ifelse(Country_A[j]= =(Country_B[i]),Measure2[i], NA)
}}
 
A2<-cbind(B,w)
 

Thanks, Julia

_________________________________________________________________


        [[alternative HTML version deleted]]

______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Reply via email to