Re: [R] combine 2 data.frames in dependence of the ID

2014-02-26 Thread arun
to:smartpink...@yahoo.com] Gesendet: Mittwoch, 26. Februar 2014 10:08 An: Matthias Weber Betreff: Re: [R] combine 2 data.frames in dependence of the ID #or you could do: dcast(ddply(merge(dat1,dat2,by="FS_ID")[,-1],.(ABNR), mutate, DATE=cut(seq_along(DATE),breaks=c(0,1,2,3,4,5,

Re: [R] combine 2 data.frames in dependence of the ID

2014-02-26 Thread arun
run [mailto:smartpink...@yahoo.com] Gesendet: Mittwoch, 26. Februar 2014 10:08 An: Matthias Weber Betreff: Re: [R] combine 2 data.frames in dependence of the ID #or you could do: dcast(ddply(merge(dat1,dat2,by="FS_ID")[,-1],.(ABNR), mutate, DATE=cut(seq_along(DATE),breaks=c(0,1,2,3,4,5,

Re: [R] combine 2 data.frames in dependence of the ID

2014-02-26 Thread Mat
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 932733688812 11391 33688812 11392 33688812 11388 33688812 11390 3368

Re: [R] combine 2 data.frames in dependence of the ID

2014-02-25 Thread arun
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

[R] combine 2 data.frames in dependence of the ID

2014-02-25 Thread Mat
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