[R] Matching data in two files but returning a value from a adjacent column
smartpink111 at yahoo.com
Thu Jan 23 18:12:54 CET 2014
Try ?merge() or ?join() from library(plyr)
#Please provide reproducible example.
dat1 <- data.frame(Stat_Ana=sample(20:30,10,replace=TRUE))
dat2 <- data.frame(Stat_Ana=20:30,Group=LETTERS[1:11])
I have a dataset where I have a column which holds information on what geographical statistical analysis square that row of data is from.
Groups of these statistical squares make up management regions.
In my second file I simply have a column of all statistical squares
and adjacent to this a column of which management region this stat
square is in. I want to find a way of using the stat squares in file one
to look into file two, find the corresponding stat square but then
return the management area value to an empty column in file one. Can
anyone help me?
More information about the R-help