What's wrong is I'm trying to select only those rows in which X > Y, but I'm getting rows in which Y > X and losing some in which X > Y. The row numbers are not being read as values. Very confusing. Jim > > What's wrong with it? It looks okay to me. If you use > subset(data, data$X >data$Y)you get the same results. Any chance you're > reading the row.numbers as values? > > BTW "data" is a reserved word in R and it is good practice not to use it > as a variable name. > > My Results > > X Y V3 > 3 3 1 2.236068 > 4 4 1 6.324555 > 5 5 1 5.000000 > 6 1 2 8.062258 > 10 5 2 5.656854 > 11 1 3 2.236068 > 12 2 3 9.486833 > 17 2 4 2.236068 > 18 3 4 8.062258 > 24 4 5 5.385165 > > > --- On Mon, 8/10/09, Jim Bouldin <jrboul...@ucdavis.edu> wrote: > > > From: Jim Bouldin <jrboul...@ucdavis.edu> > > Subject: [R] problem selecting rows meeting a criterion > > To: r-help@r-project.org > > Received: Monday, August 10, 2009, 5:49 PM > > > > When I try to select only those rows from the following > > data frame, called > > "data", in which X > Y > > > > X Y V3 > > 2 2 1 8.062258 > > 3 3 1 2.236068 > > 4 4 1 6.324555 > > 5 5 1 5.000000 > > 6 1 2 8.062258 > > 8 3 2 9.486833 > > 9 4 2 2.236068 > > 10 5 2 5.656854 > > 11 1 3 2.236068 > > 12 2 3 9.486833 > > 14 4 3 8.062258 > > 15 5 3 5.099020 > > 16 1 4 6.324555 > > 17 2 4 2.236068 > > 18 3 4 8.062258 > > 20 5 4 5.385165 > > 21 1 5 5.000000 > > 22 2 5 5.656854 > > 23 3 5 5.099020 > > 24 4 5 5.385165 > > > > using the commands > > > attach(data) > > > data2 = data[X >Y,];data2 > > > > I get this for data2: > > > > X Y V3 > > 3 3 1 2.236068 > > 4 4 1 6.324555 > > 5 5 1 5.000000 > > 6 1 2 8.062258 > > 10 5 2 5.656854 > > 11 1 3 2.236068 > > 12 2 3 9.486833 > > 17 2 4 2.236068 > > 18 3 4 8.062258 > > 24 4 5 5.385165 > > > > Clearly, this is not what I intend but I cannot figure out > > what I've done > > wrong. Any help appreciated. Thanks. > > > > Jim Bouldin > > > > __________________________________________________________________ > Ask a question on any topic and get answers from real people. Go to Yahoo! > Answers and share what you know at http://ca.answers.yahoo.com >
Jim Bouldin, PhD Research Ecologist Department of Plant Sciences, UC Davis Davis CA, 95616 530-554-1740 ______________________________________________ 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.
