[R] sort data.frame by specific date column

[Mark Knecht]

On Fri, Jul 10, 2009 at 7:44 PM, milton ruser<milton.ruser at gmail.com> wrote:
> Hi Mark,
>
> Like this?
>
> mydf<-read.table(stdin(), head=T)
> Trade PosType  EnDate EnTime  ExDate ExTime PL_Pos
> 1       1 1040107    915 1040107   1300    164
> 2       1 1040108    909 1040108   1300    184
> 3       1 1040115    921 1040115   1300     64
> 4       1 1040120   1134 1040120   1300    124
> 5       1 1040121    923 1040121   1300     84
> 6       1 1040205   1043 1040205   1300   -196
>
> mydf.sort<-mydf[order(mydf$EnDate),]
> mydf.sort
>
> Cheers
>
> milton
> brazil=toronto
>
> On Fri, Jul 10, 2009 at 10:30 PM, Mark Knecht <markknecht at gmail.com> wrote:
>>
>> I have a data.frame that was built from a number of smaller
>> data.frames with rbind. Each ssmaller data.frame bound together runs
>> over the same date ranges. The format of the whole thing looks like
>> this:
>>
>>     Trade PosType  EnDate EnTime  ExDate ExTime PL_Pos
>> 1        1       1 1040107    915 1040107   1300    164
>> 2        2       1 1040108    909 1040108   1300    184
>> 3        3       1 1040115    921 1040115   1300     64
>> 4        4       1 1040120   1134 1040120   1300    124
>> 5        5       1 1040121    923 1040121   1300     84
>> 6        6       1 1040205   1043 1040205   1300   -196
>>
>> I would like to sort the new data.frame using column 3, EnDate from
>> lowest to highest. How do I do this?
>>
>> The help file example section for ?sort doesn't seem to have any
>> examples of doing this by column so I'm wondering if this is the done
>> with some other command I haven't discovered, or am I just missing the
>> obvious at 7:30PM on a Friday night?
>>
>> Thanks,
>> Mark
>>
>> ______________________________________________
>> R-help at 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.
>
>
Precisely what I was looking for. The PosType values (1 and -1) where
in different data.frames and bound together. Now they are sorted and
intermingled as I was looking for.

The order command. Thanks!

Cheers,
Mark

     Trade PosType  EnDate EnTime  ExDate ExTime PL_Pos
1        1       1 1040107    915 1040107   1300    164
2        2       1 1040108    909 1040108   1300    184
3        3       1 1040115    921 1040115   1300     64
4        4       1 1040120   1134 1040120   1300    124
5        5       1 1040121    923 1040121   1300     84
4111     1      -1 1040127   1009 1040127   1301    104
412      2      -1 1040129    941 1040129   1301   -396
6        6       1 1040205   1043 1040205   1300   -196
7        7       1 1040211   1054 1040211   1300     14
413      3      -1 1040212    948 1040212   1301    154
8        8       1 1040217    909 1040217   1300     84
9        9       1 1040218    931 1040218   1125   -576
414      4      -1 1040219   1027 1040219   1301    824
10      10       1 1040225   1137 1040225   1300    214
11      11       1 1040226    935 1040226   1300    -36
415      5      -1 1040302    955 1040302   1301    114
12      12       1 1040303   1006 1040303   1300