Dear R users,
I have the following data frame:
PROCHI date_admission
2 CAO0000713 1999-12-11
4 CAO0000713 1999-10-25
21 CAO0001743 1989-05-04
25 CAO0001743 1996-09-12
26 CAO0001743 1989-05-17
27 CAO0001743 1987-09-17
28 CAO0001743 1987-09-19
29 CAO0001743 1988-01-27
36 CAO0001747 2004-03-21
38 CAO0001747 2004-03-22
39 CAO0001747 2001-02-24
41 CAO0001747 2006-03-31
46 CAO0001901 2007-04-15
61 CAO0002736 2006-05-03
62 CAO0002736 2006-04-05
64 CAO0002736 2006-06-09
65 CAO0002736 2006-04-10
68 CAO0002736 2006-03-14
69 CAO0002736 1995-04-14
72 CAO0002736 1993-11-22
74 CAO0002736 2000-09-26
75 CAO0002736 1995-11-28
77 CAO0003129 1997-05-02
81 CAO0003129 2004-05-08
83 CAO0003129 1998-04-21
85 CAO0003129 1997-04-30
106 CAO0004563 1984-06-10
113 CAO0004563 1984-01-17
153 CAO0012804 1987-02-18
188 CAO0018045 1996-12-04
189 CAO0018045 1996-09-28
291 CAO0030632 1995-04-08
292 CAO0030632 2000-02-10
305 CAO0030632 2007-06-30
306 CAO0030632 2000-07-30
320 CAO0031775 1999-03-05
322 CAO0031775 1992-09-09
323 CAO0031775 1996-07-12
324 CAO0031775 2004-09-12
325 CAO0031775 1998-01-17
328 CAO0031775 1999-02-25
329 CAO0031775 1999-02-26
330 CAO0031775 1999-02-27
331 CAO0031775 2006-03-29
377 CAO0034275 1990-10-05
382 CAO0039712 1982-11-01
387 CAO0039712 2003-01-10
389 CAO0039712 1982-07-13
390 CAO0039712 1996-05-14
393 CAO0039712 1982-07-15
396 CAO0039712 1982-06-20
397 CAO0039712 1982-06-22
399 CAO0039712 1996-07-24
400 CAO0039712 1996-01-26
401 CAO0039712 1996-04-29
427 CAO0045125 1999-02-02
429 CAO0045125 2000-11-04
430 CAO0045125 1998-06-05
431 CAO0045125 1998-06-07
433 CAO0045125 1989-10-09
434 CAO0045125 1989-10-10
435 CAO0045125 1989-09-11
437 CAO0045125 1989-09-13
441 CAO0045125 1999-03-22
444 CAO0045125 1989-09-29
445 CAO0045125 2006-01-31
452 CAO0048575 2006-01-02
453 CAO0048575 2006-01-04
454 CAO0048856 1994-10-06
456 CAO0048856 1994-10-12
461 CAO0048856 1994-03-28
464 CAO0050041 2007-03-01
466 CAO0050041 2007-04-04
481 CAO0050041 2007-07-10
490 CAO0050041 1996-07-16
510 CAO0050041 2003-11-25
514 CAO0050041 2004-05-26
520 CAO0050041 2006-10-29
531 CAO0055131 1993-04-03
533 CAO0055131 1994-07-22
535 CAO0055131 1994-01-31
538 CAO0056636 1997-12-02
550 CAO0059403 1985-12-08
552 CAO0059403 2005-05-12
556 CAO0059403 1985-08-31
559 CAO0059680 2005-05-02
564 CAO0059680 2002-12-05
582 CAO0059680 2003-09-16
585 CAO0059680 1997-04-18
586 CAO0059680 2007-06-18
589 CAO0059680 2005-03-20
659 CAO0065288 2006-07-01
682 CAO0070694 2007-09-13
685 CAO0070694 2006-08-22
695 CAO0072477 2003-06-04
696 CAO0072477 2004-07-05
718 CAO0073505 1998-09-15
720 CAO0073505 1989-09-18
725 CAO0073505 2000-11-22
727 CAO0073505 1991-08-23
I have managed to order it by PROCHI number using orderBy(PROCHI, data=dd)
what I need to do is order by PROCHI then by date of admission so that date
of admission is ascending by PROCHI ascending.
PROCHI date_admission
2 CAO0000713 1999-10-25
4 CAO0000713 1999-12-11
21 CAO0001743 1987-09-17
25 CAO0001743 1989-05-04
26 CAO0001743 1989-05-17
27 CAO0001743 1996-09-12
I've also had a look at order using the following commands:
Just the straight dd[order(dd$PROCHI, dd$date_admission) ,]
and dd[ do.call(order, dd) ,]
but I'm not sure how I can achieve what I need.
Thanks,
Natalie
--
View this message in context:
http://n4.nabble.com/ordering-columns-in-a-data-frame-tp1587294p1587294.html
Sent from the R help mailing list archive at Nabble.com.
I'm not sure what's incorrect about your result, but the following works: d=data.frame(a=sample(letters[1:5],10,rep=T),b=rnorm(10),c=sample(1:10,10)); d d[order(d$a,d$c),] or, you can use orderBy: lib(doBy) orderBy(~a+b,data=d) #use a - sign to sort in descending sequence Did you leave off the tilde in your orderBy example? hth David Freedman, CDC Atlanta -- View this message in context: http://n4.nabble.com/ordering-columns-in-a-data-frame-tp1587294p1587318.html Sent from the R help mailing list archive at Nabble.com.
Thanks David. Leaving off the tilde was the problem. -- View this message in context: http://n4.nabble.com/ordering-columns-in-a-data-frame-tp1587294p1587491.html Sent from the R help mailing list archive at Nabble.com.