[R] data and parameters

Moritz Grenke r-list at 360mix.de
Fri Jan 21 11:20:36 CET 2011

#dummy data:
master=as.data.frame(list(clientId=c(1:4,2), date=1001:1005,
control=as.data.frame(list(clientId=c(2,3), mindate=c(100,1005),
maxdate=c(1005,1005), control.params=c(1,2)))

#reducing master df:
#generating "TRUE FALSE index":
idIndex=master$clientId %in% control$clientId

#choose only those lines where index==TRUE

#merging dfs:
mergingIndex= match(master_reduced$clientId, control$clientId)
master_reduced=cbind(master_reduced, control[mergingIndex,])

#finally choose those lines where date is in range
dateIndex=master_reduced$date>master_reduced$mindate &

Hope this helps
Moritz Grenke

-----Ursprüngliche Nachricht-----
Von: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org] Im
Auftrag von analyst41 at hotmail.com
Gesendet: Freitag, 21. Januar 2011 03:02
An: r-help at r-project.org
Betreff: [R] data and parameters

(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.

More information about the R-help mailing list