arun
2014-Jan-23 17:12 UTC
[R] Matching data in two files but returning a value from a adjacent column
Hi, Try ?merge() or ?join() from library(plyr) #Please provide reproducible example. ?set.seed(42) ?dat1 <- data.frame(Stat_Ana=sample(20:30,10,replace=TRUE)) dat2 <- data.frame(Stat_Ana=20:30,Group=LETTERS[1:11]) merge(dat1,dat2,by="Stat_Ana") library(plyr) ?join(dat1,dat2,by="Stat_Ana") A.K. 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?