Hi all, Is there an easy way to generate an object wich will be the same matrix, but ordered by de cfp value? The data frame consists of numeric columns: "Block" "X" "Y" "cfp" "yfp" "ID" 0 524 244 213.41795 7.18482109 1 0 556 270 65.383904 9.568372661 2 0 528 316 40.789474 5.573732175 3 0 642 432 135.81734 12.40134427 4 0 716 430 34.359135 3.944923077 5 0 894 362 109.63158 3.197160316 6 0 958 130 63.98452 3.396452004 7 0 506 92 83.513931 9.105496856 8 0 476 464 91.674919 9.178089414 9 0 364 426 44.13932 2.068334364 10 Thanks in advance, Juan Pablo [[alternative HTML version deleted]]
On Tue, 2007-02-27 at 14:46 -0300, Juan Pablo Fededa wrote:> Hi all, > > Is there an easy way to generate an object wich will be the same matrix, but > ordered by de cfp value? > The data frame consists of numeric columns: > "Block" "X" "Y" "cfp" "yfp" "ID" > 0 524 244 213.41795 7.18482109 1 > 0 556 270 65.383904 9.568372661 2 > 0 528 316 40.789474 5.573732175 3 > 0 642 432 135.81734 12.40134427 4 > 0 716 430 34.359135 3.944923077 5 > 0 894 362 109.63158 3.197160316 6 > 0 958 130 63.98452 3.396452004 7 > 0 506 92 83.513931 9.105496856 8 > 0 476 464 91.674919 9.178089414 9 > 0 364 426 44.13932 2.068334364 10 > > Thanks in advance,Yes, see ?order. E.g.: mat <- scan() 0 524 244 213.41795 7.18482109 1 0 556 270 65.383904 9.568372661 2 0 528 316 40.789474 5.573732175 3 0 642 432 135.81734 12.40134427 4 0 716 430 34.359135 3.944923077 5 0 894 362 109.63158 3.197160316 6 0 958 130 63.98452 3.396452004 7 0 506 92 83.513931 9.105496856 8 0 476 464 91.674919 9.178089414 9 0 364 426 44.13932 2.068334364 10 mat <- data.frame(matrix(mat, ncol = 6, byrow = TRUE)) names(mat) <- c("Block", "X", "Y", "cfp", "yfp", "ID") mat mat[order(mat$cfp), ] HTH G -- %~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~% Gavin Simpson [t] +44 (0)20 7679 0522 ECRC, UCL Geography, [f] +44 (0)20 7679 0565 Pearson Building, [e] gavin.simpsonATNOSPAMucl.ac.uk Gower Street, London [w] http://www.ucl.ac.uk/~ucfagls/ UK. WC1E 6BT. [w] http://www.freshwaters.org.uk %~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%~%
Juan Pablo, X is data.frame or matrix X <- X[order(X[,4]),] options see help(order) Felipe de Mendiburu -----Original Message----- From: r-help-bounces at stat.math.ethz.ch [mailto:r-help-bounces at stat.math.ethz.ch]On Behalf Of Juan Pablo Fededa Sent: Tuesday, February 27, 2007 12:47 PM To: R-help at stat.math.ethz.ch Subject: [R] ordered matrix question Hi all, Is there an easy way to generate an object wich will be the same matrix, but ordered by de cfp value? The data frame consists of numeric columns: "Block" "X" "Y" "cfp" "yfp" "ID" 0 524 244 213.41795 7.18482109 1 0 556 270 65.383904 9.568372661 2 0 528 316 40.789474 5.573732175 3 0 642 432 135.81734 12.40134427 4 0 716 430 34.359135 3.944923077 5 0 894 362 109.63158 3.197160316 6 0 958 130 63.98452 3.396452004 7 0 506 92 83.513931 9.105496856 8 0 476 464 91.674919 9.178089414 9 0 364 426 44.13932 2.068334364 10 Thanks in advance, Juan Pablo [[alternative HTML version deleted]] ______________________________________________ R-help at stat.math.ethz.ch 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.
> -----Original Message----- > From: r-help-bounces at stat.math.ethz.ch [mailto:r-help-bounces at stat.math.ethz.ch] > On Behalf Of Juan Pablo Fededa > Sent: Tuesday, February 27, 2007 9:47 AM > To: R-help at stat.math.ethz.ch > Subject: [R] ordered matrix question > > Hi all, > > Is there an easy way to generate an object wich will be the same matrix, but > ordered by de cfp value? > The data frame consists of numeric columns: > "Block" "X" "Y" "cfp" "yfp" "ID" > 0 524 244 213.41795 7.18482109 1 > 0 556 270 65.383904 9.568372661 2 > 0 528 316 40.789474 5.573732175 3 > 0 642 432 135.81734 12.40134427 4 > 0 716 430 34.359135 3.944923077 5 > 0 894 362 109.63158 3.197160316 6 > 0 958 130 63.98452 3.396452004 7 > 0 506 92 83.513931 9.105496856 8 > 0 476 464 91.674919 9.178089414 9 > 0 364 426 44.13932 2.068334364 10 > > Thanks in advance, > > > Juan PabloJuan, Look at ?order. Something like this should work your.df[order(your.df$cfp, decreasing=TRUE), ] Hope this is helpful, Dan Daniel Nordlund Bothell, WA USA
"Juan Pablo Fededa" <jpfededa at gmail.com> wrote in message news:7bff68f40702270946x65769440l47b6f8fcade0f0f7 at mail.gmail.com...> Hi all, > > Is there an easy way to generate an object wich will be the same matrix, > but > ordered by de cfp value?Does this help?> RawData <- "Block X Y cfp yfp ID+ 0 524 244 213.41795 7.18482109 1 + 0 556 270 65.383904 9.568372661 2 + 0 528 316 40.789474 5.573732175 3 + 0 642 432 135.81734 12.40134427 4 + 0 716 430 34.359135 3.944923077 5 + 0 894 362 109.63158 3.197160316 6 + 0 958 130 63.98452 3.396452004 7 + 0 506 92 83.513931 9.105496856 8 + 0 476 464 91.674919 9.178089414 9 + 0 364 426 44.13932 2.068334364 10"> d <- read.table(textConnection(RawData), header=TRUE)> d.ordered <- data.matrix( d[order(d$cfp),] )> d.orderedBlock X Y cfp yfp ID 5 0 716 430 34.35914 3.944923 5 3 0 528 316 40.78947 5.573732 3 10 0 364 426 44.13932 2.068334 10 7 0 958 130 63.98452 3.396452 7 2 0 556 270 65.38390 9.568373 2 8 0 506 92 83.51393 9.105497 8 9 0 476 464 91.67492 9.178089 9 6 0 894 362 109.63158 3.197160 6 4 0 642 432 135.81734 12.401344 4 1 0 524 244 213.41795 7.184821 1 efg Earl F. Glynn Stowers Institute for Medical Research