Re: [R] Linking 2 columns in 2 databases and applying a function

Daniel, That indeed does work... and I didn't even need to learn a new function. Thanks! -- Ryan Utz, Ph.D. Aquatic Ecologist/STREON Scientist National Ecological Observatory Network Home/Cell: (724) 272-7769 Work: (720) 746-4844 ext. 2488 [[alternative HTML version deleted]] ___

Re: [R] Linking 2 columns in 2 databases and applying a function

1st of all Dr Utz, thanks for your recent pubs on regional differences between the piedmont and coastal plain streams. and to add to Daniels post (giving your binary yes/no): df<-merge(x,y,all.x=T,all.y=F) df["exceed"] <- ifelse(df$Q>df$Threshold_Q , 1, 0) ## now look at df df Daniel Mal

Re: [R] Linking 2 columns in 2 databases and applying a function

For example, you can merge the two data frames and do a direct comparison: df<-merge(x,y,all.x=T,all.y=F) df df$Q>df$Threshold_Q HTH, Daniel Ryan Utz-2 wrote: > > Hi all, > > I have two datasets, one that represents a long-term time series and one > that represents summary data for the time

[R] Linking 2 columns in 2 databases and applying a function

Hi all, I have two datasets, one that represents a long-term time series and one that represents summary data for the time series. It looks something like this: x<-data.frame(Year=c(2001,2001,2001,2001,2001,2001,2002,2002,2002,2002,2002,2002), Month=c(1,1,1,2,2,2),Q=c(5,5,5,6,6,6,3,3,3,4,4,5)) y<