I've got two data.frames and, when certain "keys" match, I would like to add the column values from one data frame to the other data.frame.
Below I list the two data.frames, i.e. neighborhoodInfo_df, and schoolZone_df. Based on the "address" key I would like to add the "schoolZone" key to the neighborhoodInfo_df data.frame. By any chance is there an R command to accomplish this in one or two steps. I think I could do this in a "for" loop or something, but think there is might be another way in R to accomplish it smarter. Thanks for any info. neighborhoodInfo1_df<-data.frame(address<-c(101),squareFootage<-c(2000),lotsize<-c(0.75)) neighborhoodInfo2_df<-data.frame(address<-c(108),squareFootage<-c(3000), lotsize<-c(1.25)) neighborhoodInfo_df<-rbind(neighborhoodInfo1_df, neighborhoodInfo2_df) schoolZone1_df<-data.frame(address<-c(101), schoolZone<-c("Sherman")) schoolZone2_df<-data.frame(address<-c(108), schoolZone<-c("Baker")) schoolZone_df<-rbind(schoolZone1_df, schoolZone2_df) ______________________________________________ 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.