On Dec 1, 2009, at 10:59 PM, jim holtman wrote:
The factor statement should have been: (missed the 'vec' on the
first reading)
dataDF$A1 <- factor(dataDF$A1, levels=vec)
It's not necessary to alter the data.frame. You can use the results of
the construction above as the row index and still keep the original
order:
> dataDF[factor(dataDF$A1, levels=vec), ]
A1 A2
3 C 3
2 A 2
1 B 1
> dataDF
A1 A2
1 B 1
2 A 2
3 C 3
--
David.
On Tue, Dec 1, 2009 at 10:57 PM, jim holtman <jholt...@gmail.com>
wrote:
Is this what you want:
dataDF = data.frame(A1 = c("B", "A", "C"), A2 = c(1,2,3))
dataDF
A1 A2
1 B 1
2 A 2
3 C 3
dataDF[order(dataDF$A1),]
A1 A2
2 A 2
1 B 1
3 C 3
If you want the sequence "CAB" then you will have to change the
factors in column 1:
dataDF$A1 <- factor(dataDF$A1, levels=c("C", "A", "B"))
dataDF[order(dataDF$A1),]
A1 A2
3 C 3
2 A 2
1 B 1
On Tue, Dec 1, 2009 at 10:36 PM, Hao Cen <h...@andrew.cmu.edu> wrote:
Hi,
I have a a vector and a data frame with two columns
vec = c("C", "A", "B")
dataDF = data.frame(A1 = c("B", "A", "C"), A2 = c(1,2,3))
I would like to sort the data frame by column A1 such that the
order of
elements in A1 is as the same as in vec.
After the ordering, the data frame would be
A1 A2
C 3
A 2
B 1
Any suggestions would be appreciated.
Thanks in advance
Jeff
[[alternative HTML version deleted]]
______________________________________________
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.
--
Jim Holtman
Cincinnati, OH
+1 513 646 9390
What is the problem that you are trying to solve?
--
Jim Holtman
Cincinnati, OH
+1 513 646 9390
What is the problem that you are trying to solve?
______________________________________________
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.
David Winsemius, MD
Heritage Laboratories
West Hartford, CT
______________________________________________
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.
