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).
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
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,
3 matches
Mail list logo