Re: [R] sorting/grouping/classification problem?

2013-01-28 Thread Bart Joosen
Hi, after all, brute force seems the way to go. I will use a simplified example to illustrate what I want (dump of dat4 is below): suppose dat4: ID rrt Mnd Result 1 0.45 00.1 1 0.48 00.3 1 1.24 00.5 2 0.45 30.2 2 0.48 30.6 2 1.22 30.4 I want to ge

Re: [R] sorting/grouping/classification problem?

2013-01-25 Thread arun
old 0.3 0.6 1.20 1.80 #4 1.2225    old 0.5 0.4 0.45 0.50 A.K. - Original Message - From: Bart Joosen To: Dennis Murphy ; r-help@r-project.org Cc: Sent: Friday, January 25, 2013 1:48 AM Subject: Re: [R] sorting/grouping/classification problem? Nice suggestion for the extra "Time" column

Re: [R] sorting/grouping/classification problem?

2013-01-25 Thread Bart Joosen
y possible combination of shuffling within certain limits (eg max 10% or so), calculate r2 for each combination and maximize? Seems so brute force and low elegant? Bart > Date: Fri, 25 Jan 2013 10:01:44 -0800 > From: smartpink...@yahoo.com > Subject: Re: [R] sorting/grouping/classific

Re: [R] sorting/grouping/classification problem?

2013-01-24 Thread Bart Joosen
clear now. Thank you all for your suggestions Bart > Date: Thu, 24 Jan 2013 15:01:40 -0800 > Subject: Re: [R] sorting/grouping/classification problem? > From: djmu...@gmail.com > To: bartjoo...@hotmail.com > > Hi: > > Here's a potential workaround: > > # Add

Re: [R] sorting/grouping/classification problem?

2013-01-24 Thread Bart Joosen
/grouping/classification problem? HI, If I understand your question, "dat3" is not you wanted. Is it something like this you wanted? library(reshape2) dcast(dat,rrt~Mnd,value.var="Result") # rrt 0 369 #1 0.35 NA NA 0.05 NA #2 0.36 NA NA NA 0.06 #3 0.44

Re: [R] sorting/grouping/classification problem?

2013-01-24 Thread arun
.2   NA 0.60 #5 0.46  NA  NA 1.20   NA #6 0.48 0.3 0.6   NA 1.80 #7 1.21  NA  NA 0.45   NA #8 1.22  NA 0.4   NA 0.50 #9 1.24 0.5  NA   NA   NA A.K. - Original Message - From: Bart Joosen To: r-help Cc: Sent: Thursday, January 24, 2013 2:31 PM Subject: [R] sorting/grouping/classifi

[R] sorting/grouping/classification problem?

2013-01-24 Thread Bart Joosen
Hi, I'm a database admin for a database which manage chromatographic results of products during stability studies. I use R for the reporting of the results in MS Word through R2wd. But now I think I need your help: suppose we have the following data frame: ID rrt Mnd Result 1 0.45 0