Hi,
Try:
dat <- read.table(text="
ID Name
1 Andy
2 John
3 Amy",sep="",header=TRUE,stringsAsFactors=FALSE)
dat2 <- read.table(text="
ID Date Value
1 2013-10-01 10
1 2013-10-02 15
2 2013-10-01 7
2 2013-10-03 10
2 2013-10-04 15
3 2013-10-01
10",sep="",header=TRUE,colClasses=c("numeric","Date","numeric"))
library(plyr)
res <-
reshape(ddply(merge(dat,dat2,by="ID"),.(ID),mutate,id=((seq_along(ID)-1)%%3+1))[,-3],idvar=c("ID","Name"),timevar="id",direction="wide")
rownames(res) <- 1:nrow(res)
colnames(res)[3:5] <- c("First", "Second", "Third")
res
# ID Name First Second Third
#1 1 Andy 10 15 NA
#2 2 John 7 10 15
#3 3 Amy 10 NA NA
A.K.
On Thursday, October 17, 2013 7:42 AM, Mat <matthias.we...@fnt.de> wrote:
hello togehter,
i have a little problem, maybe you can help me.
I have a data.frame like this one:
ID Name
1 Andy
2 John
3 Amy
and a data.frame like this:
ID Date Value
1 2013-10-01 10
1 2013-10-02 15
2 2013-10-01 7
2 2013-10-03 10
2 2013-10-04 15
3 2013-10-01 10
the result should be this one:
ID Name First Second Third
1 Andy 10 15
2 John 7 10 15
3 Amy 10
maybe you can help me, to do this?
Thank you.
Mat
--
View this message in context:
http://r.789695.n4.nabble.com/match-values-in-dependence-of-ID-and-Date-tp4678433.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
R-help@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.
______________________________________________
R-help@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.
