Re: [R] Help with subset

2010-01-25 Thread Jerry Floren
Hi Peter, Thanks again for showing me how to do this. This will save me hours of tedious work, and I can't believe how quickly R reads in and processes my data. It was taking about 40 minutes when I used Word's mail merge for this. When I first switched from Excel to R, R was so much faster than

Re: [R] Help with subset

2010-01-21 Thread Jerry Floren
Thank you very much Peter. I'm off until Monday, but now I have an interesting project to think about over the weekend. It looks pretty simple, and it sure will beat over 2,000 pages of code to cut and paste. Thanks again, Jerry Floren Minnesota Department of Agriculture -- View this message in

Re: [R] Help with subset

2010-01-21 Thread Peter Alspach
ntact me off list. P > -Original Message- > From: r-help-boun...@r-project.org > [mailto:r-help-boun...@r-project.org] On Behalf Of Jerry Floren > Sent: Friday, 22 January 2010 9:53 a.m. > To: r-help@r-project.org > Subject: Re: [R] Help with subset > > > Thank

Re: [R] Help with subset

2010-01-21 Thread Jerry Floren
Thank you Peter. I am really new to this. The spreadsheet I am working with has 12,379 rows with the first row consisting of the variable names and 12,378 rows of data. There are seven columns, and the 7th column is the only one with numerical data ("Results"). I need to match up the variable Re

Re: [R] Help with subset

2010-01-21 Thread Peter Alspach
116) > 8) { # steps for your analysis } } HTH .. Peter Alspach > -Original Message- > From: r-help-boun...@r-project.org > [mailto:r-help-boun...@r-project.org] On Behalf Of Jerry Floren > Sent: Friday, 22 January 2010 5:04 a.m. > To: r-help@r-project.org >

[R] Help with subset

2010-01-21 Thread Jerry Floren
I am so happy about learning how to read in multiple Excel files, that I have to try and make another improvement. I know what I have been doing is clumsy, but it works. Hopefully, someone can suggest a more elegant solution. As a novice, I have been using MS-Word and mail merge to write my code.

Re: [R] help with subset

2008-05-02 Thread partofy
ECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of > > [EMAIL PROTECTED] > > Sent: Friday, May 02, 2008 11:41 PM > > To: r-help@r-project.org > > Subject: [R] help with subset > > > > Dear list: > > > > I have a problem using the subset functi

Re: [R] help with subset

2008-05-02 Thread Jim Porzak
Justin, try subset(dat, treatment %in% vec) I guess thats what you want. On Fri, May 2, 2008 at 8:40 PM, <[EMAIL PROTECTED]> wrote: > Dear list: > > I have a problem using the subset function: > > dat<- data.frame(treatment=c("A", "B", "A", "C", "C", "D", "A", "D", > "C", "D"), response=rnorm(

Re: [R] help with subset

2008-05-02 Thread Christos Hatzis
Try %in% subset(dat, treatment %in% vec) > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Friday, May 02, 2008 11:41 PM > To: r-help@r-project.org > Subject: [R] help with subset > > Dear

[R] help with subset

2008-05-02 Thread partofy
Dear list: I have a problem using the subset function: dat<- data.frame(treatment=c("A", "B", "A", "C", "C", "D", "A", "D", "C", "D"), response=rnorm(10)) I am interested in treatments "A", "B" and "D" vec<- c("A", "B", "D") But I can only obtain what I want with: subset(dat, treatment=="A" | t