[R] data and parameters
jholtman at gmail.com
Fri Jan 21 14:01:46 CET 2011
forgot the control parameters:
+ select m.*, c.control_params
+ from master m, control c
+ where m.clientId = c.clientID
+ and m.date between c.mindate and c.maxdate
clientId date value control_params
1 2 1002 10002 1
2 2 1005 10005 1
On Thu, Jan 20, 2011 at 9:02 PM, analyst41 at hotmail.com
<analyst41 at hotmail.com> wrote:
> (1) I have a master data frame that reads
> ClientID |date |value
> (2) I also have a control data frame that reads
> Client ID| Min date| Max date| control parameters
> The control data set may not have all client IDs .
> I want to use the control data frame on the master data frame to
> remove client IDS that don't exist in the control data set and for
> those that do, remove dates outside the required range.
> (3) We can either put the control parameters on all rows corresponding
> to a client ID or look it up from the control data frame
> (4) The basic function call looks like
> do.something(df,control parameters)
> where df is the subset of the master data set that corresponds to a
> single client with unwanted dates removed and the control parameters
> pertain to that client.
> Any help would be appreciated.
> R-help at r-project.org mailing list
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
Data Munger Guru
What is the problem that you are trying to solve?
More information about the R-help