[R] data and parameters

[Moritz Grenke]

#dummy data:
master=as.data.frame(list(clientId=c(1:4,2), date=1001:1005,
value=10001:10005))
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
master_reduced=master[idIndex,]
master_reduced

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

#finally choose those lines where date is in range
dateIndex=master_reduced$date>master_reduced$mindate &
master_reduced$date<master_reduced$maxdate
finalDF=master_reduced[dateIndex,]
finalDF

Hope this helps
Moritz
_________________________
Moritz Grenke
http://www.360mix.de

-----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
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.