[R] Sorting data.frame and again sorting within data.frame
Jeff Newmiller
jdnewmil at dcn.davis.CA.us
Mon Apr 15 18:33:09 CEST 2013
Yes, that would be because she converted to Date on the fly in her example, and so apparently did not need this reminder.
---------------------------------------------------------------------------
Jeff Newmiller The ..... ..... Go Live...
DCN:<jdnewmil at dcn.davis.ca.us> Basics: ##.#. ##.#. Live Go...
Live: OO#.. Dead: OO#.. Playing
Research Engineer (Solar/Batteries O.O#. #.O#. with
/Software/Embedded Controllers) .OO#. .OO#. rocks...1k
---------------------------------------------------------------------------
Sent from my phone. Please excuse my brevity.
David Winsemius <dwinsemius at comcast.net> wrote:
>
>On Apr 14, 2013, at 11:01 PM, Katherine Gobin wrote:
>
>> Dear R forum,
>>
>> I have a data.frame as defied below -
>>
>> df = data.frame(names = c("C", "A", "A", "B", "C", "B", "A", "B",
>"C"), dates = c("4/15/2013", "4/13/2013", "4/15/2013", "4/13/2013",
>"4/13/2013", "4/15/2013", "4/14/2013", "4/14/2013","4/14/2013" ),values
>= c(10, 31, 31, 17, 11, 34, 102, 47, 29))
>>
>>> df
>> names dates values
>> 1 C 4/15/2013 10
>> 2 A 4/13/2013 31
>> 3 A 4/15/2013 31
>> 4 B 4/13/2013 17
>> 5 C 4/13/2013 11
>> 6 B
>> 4/15/2013 34
>> 7 A 4/14/2013 102
>> 8 B 4/14/2013 47
>> 9 C 4/14/2013 29
>>
>> I need to sort df first on "names" in increasing order and then
>further on "dates" in a decreasing order i.e. I need
>>
>
>So far no one has pointed out that these are not really "Dates" in the
>R sense and will not sort correctly if any of the proposed methods are
>applied to sequences that extend beyond6 months, i.e, until October
>forward. You would be advised to convert to real Date-classed
>variables.
>
>?strptime
>?as.Date
More information about the R-help
mailing list