combine 2 data.frames in dependence of the ID

Hi,
May be this helps:
dat1 <- read.table(text="FS_ID? ABNR
9327??? 33688812
11391? 33688812
11392? 33688812
11388? 33688812
11390? 33688812
12028? 33688812
12029? 33688812",sep="",header=TRUE)

dat2 <- read.table(text="FS_ID? DATE????????????? POST
11390? 2012-12-13??? 28
12029? 2013-01-17??? 28.3",header=TRUE,stringsAsFactors=FALSE)
library(reshape2)
setNames(dcast(merge(dat1,dat2, by="FS_ID")[,-1],ABNR~DATE,value.var="POST"),c("ABNR","FIRST","SECOND"))
#????? ABNR FIRST SECOND
#1 33688812??? 28?? 28.3
A.K.

Hello together, 

i have a little problem, maybe anyone can help me.
I have 2 data.frame, one look like this one:

FS_ID?  ABNR
9327? ?  33688812
11391?  33688812
11392?  33688812
11388?  33688812
11390?  33688812
12028?  33688812
12029?  33688812

the other data.frame looks like as follows:

FS_ID?  DATE? ? ? ? ? ? ? POST
11390?  2012-12-13? ?  28
12029?  2013-01-17? ?  28.3

what i am looking for, is a result, which look like this one:

ABNR? ? ? ? ?  FIRST? ?  SECOND? ? 
33688812? ?  28? ? ? ?  28.3

The ABNR and the "POST"-Value of my second data.frame should stand in one
row. The earlier date value should stand under "FIRST", the newer date under
"SECOND".

Maybe anyone can help me, how i can do this. 

Best regards. Mat



--
View this message in context: http://r.789695.n4.nabble.com/combine-2-data-frames-in-dependence-of-the-ID-tp4685781.html
Sent from the R help mailing list archive at Nabble.com.

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

thanks for the help up to here.

A little problem remains.

I have different "ABNR", if i try it with another ABNR, the Column extend
for each ABNR, it should start with "FIRST" again.

dat1 <- read.table(text="FS_ID  ABNR
9327    33688812
11391  33688812
11392  33688812
11388  33688812
11390  33688812
12028  33688812
12029  33688812
19999  33800000",sep="",header=TRUE)

dat2 <- read.table(text="FS_ID  DATE              POST
11390  2012-12-13    28
12029  2013-01-17    28.3
11391  2011-02-20    29
19999  2014-02-20    10",header=TRUE,stringsAsFactors=FALSE)
library(reshape2)
setNames(dcast(merge(dat1,dat2,
by="FS_ID")[,-1],ABNR~DATE,value.var="POST"),c("ABNR","FIRST","SECOND")) 

      ABNR FIRST SECOND THREE NA
1 33688812    29     28  28.3 NA
2 33800000    NA     NA    NA 10

it shoult start for each ABNR in the "FIRST"-Column again.

Right would be:

      ABNR FIRST SECOND THREE
1 33688812    29     28  28.3
2 33800000    10     NA    NA 

Thank you.



--
View this message in context: http://r.789695.n4.nabble.com/combine-2-data-frames-in-dependence-of-the-ID-tp4685781p4685855.html
Sent from the R help mailing list archive at Nabble.com.