Re: [R] Question on Merge/Lookup

2010-01-22 Thread Dennis Murphy
sqldf, authored by Gabor, if I read your intention correctly. D. On Fri, Jan 22, 2010 at 5:00 PM, Don MacQueen wrote: > Perhaps using the R merge() function, possibly twice in succession, will do > the job. (merge() does a one to many relational join, but with only two > dataframes at at time).

Re: [R] Question on Merge/Lookup

2010-01-22 Thread Don MacQueen
Perhaps using the R merge() function, possibly twice in succession, will do the job. (merge() does a one to many relational join, but with only two dataframes at at time). Or, there is an R package that lets you use the SQL language on dataframes. I don't recall its name, but a search on R pac

[R] Question on Merge/Lookup

2010-01-22 Thread GL
I need to merge three datasets and don't know how. If I were using SQL, I would use df3, look up the characteristics of each date in df1 and the value for each observation in df2. df1 - unique list of Dates and characteristics of those dates Date, MM, WW, DOW df2 - the raw data Date,